Data source: Big Local News · About: Big Local

4,774 rows where grade = "grade_7" and state = "MN" sorted by ccd_school_low_grade

View and edit SQL

year

grade

  • grade_7 · 4,774
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ▼ ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
694054 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001594 494 CAPITOL HILL MAGNET/RONDO Elementary School (Grades PK-6) Regular School No Elementary 01 08 2017   grade_7 64.0 52.0 13.0   0.0 70.0     0.0   3.0   100.0 102.0     20.0   0.0     101.0   8.0   202.0 64 52 13   0 70     0   3   100 102     20 0   101 8   202
696685 MN Carver 10 school 2700116 4016 Charter Schools WORLD LEARNER CHARTER SCHOOL 270011602606 10 WORLD LEARNER CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary 01 08 2017   grade_7 27.0 0.0 4.0   0.0 1.0     0.0   0.0   14.0 18.0     1.0   0.0     0.0   5.0   32.0 27 0 4   0 1     0   0   14 18     1 0   0 5   32
699807 MN Carlton 9 school 2709420 94 Independent Districts and Schools CLOQUET PUBLIC SCHOOL DISTRICT 270942002236 103 CLOQUET AREA ALT. ED. PROGRAMS Public Area Learning Center ALC (State approved) Alternative School No Other 01 12 2017   grade_7 2.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0         *         *   2.0 2 0 0   0 0     0   0   2 0                 2
701035 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002503542 479 SAFE Special Education Special Education School No Other 01 12 2017   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 1 0 0   0 0     0   0   1 0                 1
701047 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002503229 480 STRIVE SECONDARY Special Education Special Education School No Other 01 12 2017   grade_7 1.0 2.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0         *         *   3.0 1 2 0   0 0     0   0   3 0                 3
701060 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002503234 486 CIP Special Education Special Education School No Other 01 12 2017   grade_7 5.0 2.0 0.0   0.0 0.0     0.0   0.0   7.0 0.0         *         *   7.0 5 2 0   0 0     0   0   7 0                 7
701075 MN Scott 70 school 2700420 288 Intermediate Districts and Schools Southwest Metro Intermediate 288 270042005038 12 SW Metro Level 4 Programs Special Education Special Education School No Other 01 12 2017   grade_7 6.0 1.0 3.0   0.0 0.0     0.0   0.0   8.0 2.0         *         *   10.0 6 1 3   0 0     0   0   8 2                 10
701300 MN Mille Lacs 48 school 2700318 6079 Special Education Cooperatives RUM RIVER SPECIAL EDUCATION COOP 270031804296 10 RUM RIVER NORTH Special Education Special Education School No Other 01 12 2017   grade_7 6.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 2.0         *         *   6.0 6 0 0   0 0     0   0   4 2                 6
701547 MN Stearns 73 school 2791455 6026 Education Districts WEST CENTRAL EDUCATION DISTRICT 279145503591 24 BEACON PROGRAM W CENTRAL ED. DIST. Special Education Special Education School No Other 01 11 2017   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 1 0 0   0 0     0   0   1 0                 1
702083 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104001562 81 MERRITT CREEK ACADEMY Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 01 12 2017   grade_7 4.0 0.0 1.0   3.0 0.0     0.0   1.0   9.0 0.0         *         *   9.0 4 0 1   3 0     0   1   9 0                 9
702349 MN Mille Lacs 48 school 2730030 477 Independent Districts and Schools PRINCETON PUBLIC SCHOOL DISTRICT 273003004936 90 Princeton Alternative Services Educational Oversight to Public Care and Treatment Day Program Alternative School No Other 01 12 2017   grade_7 2.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 1.0         *         *   2.0 2 0 0   0 0     0   0   1 1                 2
858368 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001594 494 CAPITOL HILL MAGNET/RONDO Elementary School (Grades PK-6) Regular School No 1 01 08 2016   grade_7 84 45 13   3 64     0   5   119 95     24.0   0.0     90.0   9.0   214 84 45 13   3 64     0   5   119 95     24 0   90 9   214
860957 MN Carver 10 school 2700116 4016 Charter Schools WORLD LEARNER CHARTER SCHOOL 270011602606 10 WORLD LEARNER CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes 1 01 08 2016   grade_7 22 0 0   0 0     0   0   9 13     0.0   0.0     2.0   2.0   22 22 0 0   0 0     0   0   9 13     0 0   2 2   22
863985 MN Carlton 9 school 2709420 94 Independent Districts and Schools CLOQUET PUBLIC SCHOOL DISTRICT 270942002236 103 CLOQUET AREA ALT. ED. PROGRAMS Public Area Learning Center ALC (State approved) Alternative Education School No 4 01 12 2016   grade_7 5 0 0   0 0     0   1   5 1         *         *   6 5 0 0   0 0     0   1   5 1                 6
865161 MN Chisago 13 school 2700017 2144 Independent Districts and Schools CHISAGO LAKES SCHOOL DISTRICT 270001704939 17 SOAR Special Education Special Education School No 4 01 12 2016   grade_7 1 0 0   0 0     0   1   2 0         *         *   2 1 0 0   0 0     0   1   2 0                 2
865275 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002503542 479 SAFE Special Education Special Education School No 4 01 12 2016   grade_7 3 0 0   0 0     0   0   3 0         *         *   3 3 0 0   0 0     0   0   3 0                 3
865301 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002503234 486 CIP Special Education Special Education School No 4 01 12 2016   grade_7 6 4 0   0 0     0   0   10 0     0.0   0.0     5.0   *   10 6 4 0   0 0     0   0   10 0     0 0   5     10
865531 MN Mille Lacs 48 school 2700318 6079 Special Education Cooperatives RUM RIVER SPECIAL EDUCATION COOP 270031804296 10 RUM RIVER NORTH Special Education Special Education School No 4 01 12 2016   grade_7 4 1 0   0 0     0   0   5 0         *         *   5 4 1 0   0 0     0   0   5 0                 5
865569 MN Cottonwood 17 school 2700086 991 Service Cooperative (ECSU Region) REGION 6 AND 8-SW/WC SRV COOPERATIVE 270008604168 16 RED ROCK RIDGE SETTING IV Special Education Special Education School No 4 01 12 2016   grade_7 6 0 0   0 0     0   0   6 0         *         *   6 6 0 0   0 0     0   0   6 0                 6
865721 MN Brown 8 school 2791353 6049 Education Districts RIVER BEND EDUCATION DISTRICT 279135304366 35 IMPRINTS PROGRAM Special Education Special Education School No 4 01 12 2016   grade_7 2 0 0   0 0     0   0   2 0         *         *   2 2 0 0   0 0     0   0   2 0                 2
866420 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104001562 81 MERRITT CREEK ACADEMY Educational Oversight to Public Residential Care & Treatment (State approved) Alternative Education School No 4 01 12 2016   grade_7 5 2 0   1 0     0   0   7 1         *         *   8 5 2 0   1 0     0   0   7 1                 8
1147547 MN Ramsey 62 school 2700344 4105 Charter Schools GREAT RIVER SCHOOL 270034404093 10 GREAT RIVER SCHOOL Secondary School (Grades 7-12) Regular School Yes 4 01 12 2015   grade_7 44.0 1.0 2.0   0.0 1.0     0.0   3.0   27.0 24.0     1.0   0.0     6.0   7.0   51.0 44 1 2   0 1     0   3   27 24     1 0   6 7   51
1151046 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001594 494 CAPITOL HILL MAGNET/RONDO Elementary School (Grades PK-6) Regular School No 1 01 08 2015   grade_7 83.0 60.0 15.0   1.0 58.0     0.0   3.0   120.0 100.0     33.0   0.0     109.0   7.0   220.0 83 60 15   1 58     0   3   120 100     33 0   109 7   220
1153665 MN Carver 10 school 2700116 4016 Charter Schools WORLD LEARNER CHARTER SCHOOL 270011602606 10 WORLD LEARNER CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes 1 01 08 2015   grade_7 24.0 1.0 0.0   0.0 0.0     0.0   0.0   13.0 12.0     0.0   0.0     4.0   7.0   25.0 24 1 0   0 0     0   0   13 12     0 0   4 7   25
1156616 MN Carlton 9 school 2709420 94 Independent Districts and Schools CLOQUET PUBLIC SCHOOL DISTRICT 270942002236 103 CLOQUET AREA ALT. ED. PROGRAMS Public Area Learning Center ALC (State approved) Alternative Education School No 4 01 12 2015   grade_7 0.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 0.0         *         *   1.0 0 0 0   0 0     0   1   1 0                 1
1157402 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520003593 45 ACHIEVE Special Education Special Education School No 4 01 12 2015   grade_7 2.0 1.0 0.0   1.0 0.0     0.0   0.0   3.0 1.0         *         *   4.0 2 1 0   1 0     0   0   3 1                 4
1157850 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002503542 479 SAFE Special Education Special Education School No 4 01 12 2015   grade_7 1.0 1.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0         *         *   2.0 1 1 0   0 0     0   0   2 0                 2
1158106 MN Cottonwood 17 school 2700086 991 Service Cooperative (ECSU Region) REGION 6 AND 8-SW/WC SRV COOPERATIVE 270008604168 16 RED ROCK RIDGE SETTING IV Special Education Special Education School No 4 01 12 2015   grade_7 2.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 1.0         *         *   2.0 2 0 0   0 0     0   0   1 1                 2
1158791 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104001562 81 MERRITT CREEK ACADEMY Educational Oversight to Public Residential Care & Treatment (State approved) Alternative Education School No 4 01 12 2015   grade_7 8.0 1.0 1.0   0.0 0.0     0.0   0.0   7.0 3.0     0.0   1.0         8.0   10.0 8 1 1   0 0     0   0   7 3     0 1     8   10
1716870 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001594 494 Capitol Hill Magnet/Rondo Elementary School (Grades PK-6) Regular School No Elementary 01 08 2021   grade_7 64 59 8   0 45     0   16   94 98     18.0   0.0     92.0   15.0   192 64 59 8   0 45     0   16   94 98     18 0   92 15   192
1719488 MN Carver 10 school 2700116 4016 Charter Schools World Learner Charter School 270011602606 10 World Learner Charter School Elementary School (Grades PK-6) Regular School Yes Elementary 01 08 2021   grade_7 19 1 2   0 2     0   0   8 16     0.0   0.0     1.0   3.0   24 19 1 2   0 2     0   0   8 16     0 0   1 3   24
1723788 MN Sherburne 71 school 2711370 728 Independent Districts and Schools Elk River School District 271137004142 401 ISD 728 Focus/Journey Special Education Special Education School No Other 01 12 2021   grade_7 1 0 0   0 0     0   1   2 0     *   *     *   *   2 1 0 0   0 0     0   1   2 0                 2
1724224 MN Mower 50 school 2700327 6083 Special Education Cooperatives Southern MN Education Consortium 270032705231 150 RESET Special Education Special Education School No Other 01 12 2021   grade_7 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1724543 MN Brown 8 school 2791353 6049 Education Districts River Bend Education District 279135304366 35 Imprints Program Special Education Special Education School No Other 01 12 2021   grade_7 5 1 0   0 0     0   0   6 0     *   *     *   *   6 5 1 0   0 0     0   0   6 0                 6
1830421 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001594 494 Capitol Hill Magnet/Rondo Elementary School (Grades PK-6) Regular School No Elementary 01 08 2020   grade_7 74.0 45.0 12.0   0.0 57.0     1.0   12.0   119.0 82.0     12.0   0.0     94.0   12.0   201.0 74 45 12   0 57     1   12   119 82     12 0   94 12   201
1833032 MN Carver 10 school 2700116 4016 Charter Schools World Learner Charter School 270011602606 10 World Learner Charter School Elementary School (Grades PK-6) Regular School Yes Elementary 01 08 2020   grade_7 25.0 0.0 1.0   0.0 1.0     0.0   0.0   12.0 15.0     0.0   0.0     3.0   5.0   27.0 25 0 1   0 1     0   0   12 15     0 0   3 5   27
1836347 MN Carlton 9 school 2709420 94 Independent Districts and Schools Cloquet Public School District 270942002236 103 CLOQUET AREA ALT. ED. PROGRAMS Public Area Learning Center ALC (State approved) Alternative School No Other 01 12 2020   grade_7 0.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 0.0     *   *         *   1.0 0 0 0   0 0     0   1   1 0                 1
1837465 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools Intermediate School District 287 270002503542 479 Safe Special Education Special Education School No Other 01 12 2020   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   1.0   2.0 0.0     *   *         *   2.0 1 0 0   0 0     0   1   2 0                 2
1837475 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools Intermediate School District 287 270002503229 480 Strive Secondary Special Education Special Education School No Other 01 12 2020   grade_7 0.0 2.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0     *   *         *   2.0 0 2 0   0 0     0   0   2 0                 2
1837488 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools Intermediate School District 287 270002503234 486 CIP Special Education Special Education School No Other 01 12 2020   grade_7 3.0 3.0 0.0   0.0 0.0     0.0   1.0   5.0 2.0     *   *         *   7.0 3 3 0   0 0     0   1   5 2                 7
1837503 MN Scott 70 school 2700420 288 Intermediate Districts and Schools Southwest Metro Intermediate 288 270042005038 12 SW Metro Level 4 Programs Special Education Special Education School No Other 01 12 2020   grade_7 10.0 1.0 2.0   0.0 0.0     0.0   0.0   10.0 3.0     0.0   0.0     4.0   *   13.0 10 1 2   0 0     0   0   10 3     0 0   4     13
1884951 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001594 494 Capitol Hill Magnet/Rondo Elementary School (Grades PK-6) Regular School No Elementary 01 08 2018   grade_7 82.0 65.0 12.0   0.0 54.0     0.0   4.0   119.0 98.0     13.0   1.0     97.0   9.0   217.0 82 65 12   0 54     0   4   119 98     13 1   97 9   217
1887587 MN Carver 10 school 2700116 4016 Charter Schools World Learner Charter School 270011602606 10 World Learner Charter School Elementary School (Grades PK-6) Regular School Yes Elementary 01 08 2018   grade_7 19.0 3.0 0.0   0.0 0.0     0.0   1.0   10.0 13.0     2.0   0.0     2.0   5.0   23.0 19 3 0   0 0     0   1   10 13     2 0   2 5   23
1890768 MN Carlton 9 school 2709420 94 Independent Districts and Schools Cloquet Public School District 270942002236 103 Cloquet Area Alt. Ed. Programs Public Area Learning Center ALC (State approved) Alternative School No Other 01 12 2018   grade_7 0.0 0.0 0.0   0.0 0.0     0.0   2.0   2.0 0.0     *   *     *   *   2.0 0 0 0   0 0     0   2   2 0                 2
1891840 MN Chisago 13 school 2700017 2144 Independent Districts and Schools Chisago Lakes School District 270001704939 17 SOAR Special Education Special Education School No Other 01 12 2018   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *     *   *   1.0 1 0 0   0 0     0   0   1 0                 1
1891957 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools Intermediate School District 287 270002503542 479 Safe Special Education Special Education School No Other 01 12 2018   grade_7 1.0 2.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0     *   *     *   *   3.0 1 2 0   0 0     0   0   3 0                 3
1891983 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools Intermediate School District 287 270002503234 486 CIP Special Education Special Education School No Other 01 12 2018   grade_7 4.0 0.0 2.0   1.0 0.0     0.0   1.0   8.0 0.0     *   *     *   *   8.0 4 0 2   1 0     0   1   8 0                 8
1892225 MN Mille Lacs 48 school 2700318 6079 Special Education Cooperatives Rum River Special Education Cooperative 270031804296 10 Rum River North Special Education Special Education School No Other 01 12 2018   grade_7 9.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 2.0     *   *     *   *   9.0 9 0 0   0 0     0   0   7 2                 9
1892344 MN Cottonwood 17 school 2700086 991 Service Cooperative (ECSU Region) Region 6 and 8-SW/WC Service Cooperative 270008604168 16 Red Rock Ridge Learning Center Special Education Special Education School No Other 01 12 2018   grade_7 3.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 1.0     *   *     *   *   3.0 3 0 0   0 0     0   0   2 1                 3
1892518 MN Brown 8 school 2791353 6049 Education Districts River Bend Education District 279135304366 35 Imprints Program Special Education Special Education School No Other 01 12 2018   grade_7 3.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 1.0     *   *     *   *   3.0 3 0 0   0 0     0   0   2 1                 3
1949534 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001594 494 CAPITOL HILL MAGNET/RONDO Elementary School (Grades PK-6) Regular School No Elementary 01 08 2019   grade_7 68.0 57.0 11.0   0.0 54.0     0.0   13.0   111.0 92.0     12.0   1.0     97.0   10.0   203.0 68 57 11   0 54     0   13   111 92     12 1   97 10   203
1952166 MN Carver 10 school 2700116 4016 Charter Schools WORLD LEARNER CHARTER SCHOOL 270011602606 10 WORLD LEARNER CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary 01 08 2019   grade_7 16.0 0.0 1.0   0.0 2.0     0.0   1.0   12.0 8.0     0.0   0.0     2.0   5.0   20.0 16 0 1   0 2     0   1   12 8     0 0   2 5   20
1955392 MN Carlton 9 school 2709420 94 Independent Districts and Schools CLOQUET PUBLIC SCHOOL DISTRICT 270942002236 103 CLOQUET AREA ALT. ED. PROGRAMS Public Area Learning Center ALC (State approved) Alternative School No Other 01 12 2019   grade_7 1.0 0.0 0.0   1.0 0.0     0.0   0.0   2.0 0.0     *   *         *   2.0 1 0 0   1 0     0   0   2 0                 2
1956519 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002503542 479 SAFE Special Education Special Education School No Other 01 12 2019   grade_7 0.0 2.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0     *   *         *   2.0 0 2 0   0 0     0   0   2 0                 2
1956530 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002503229 480 STRIVE SECONDARY Special Education Special Education School No Other 01 12 2019   grade_7 0.0 1.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0     *   *         *   1.0 0 1 0   0 0     0   0   0 1                 1
1956544 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002503234 486 CIP Special Education Special Education School No Other 01 12 2019   grade_7 6.0 1.0 0.0   1.0 2.0     0.0   1.0   10.0 1.0     2.0   0.0     3.0   *   11.0 6 1 0   1 2     0   1   10 1     2 0   3     11
1956559 MN Scott 70 school 2700420 288 Intermediate Districts and Schools Southwest Metro Intermediate 288 270042005038 12 SW Metro Level 4 Programs Special Education Special Education School No Other 01 12 2019   grade_7 5.0 1.0 0.0   0.0 0.0     0.0   1.0   7.0 0.0     *   *         *   7.0 5 1 0   0 0     0   1   7 0                 7
1956773 MN Mille Lacs 48 school 2700318 6079 Special Education Cooperatives RUM RIVER SPECIAL EDUCATION COOP 270031804296 10 RUM RIVER NORTH Special Education Special Education School No Other 01 12 2019   grade_7 7.0 1.0 0.0   1.0 0.0     0.0   0.0   6.0 3.0     *   *         *   9.0 7 1 0   1 0     0   0   6 3                 9
1956916 MN Cottonwood 17 school 2700086 991 Service Cooperative (ECSU Region) Region 6 and 8-SW/WC Service Cooperative 270008604168 16 SWWC ELC - Windom Special Education Special Education School No Other 01 12 2019   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1957127 MN Brown 8 school 2791353 6049 Education Districts RIVER BEND EDUCATION DISTRICT 279135304366 35 IMPRINTS PROGRAM Special Education Special Education School No Other 01 12 2019   grade_7 3.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0     *   *         *   3.0 3 0 0   0 0     0   0   3 0                 3
1957581 MN Hennepin 27 school 2733780 283 Independent Districts and Schools ST. LOUIS PARK PUBLIC SCHOOL DIST. 273378004332 759 MELROSE Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 01 12 2019   grade_7 0.0 1.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0     *   *         *   1.0 0 1 0   0 0     0   0   0 1                 1
700842 MN Sherburne 71 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137004142 401 ISD 728 FOCUS/JOURNEY Special Education Special Education School No Other 02 12 2017   grade_7 2.0 1.0 0.0   0.0 0.0     0.0   1.0   4.0 0.0         *         *   4.0 2 1 0   0 0     0   1   4 0                 4
701492 MN Otter Tail 56 school 2700014 6004 Education Districts FRESHWATER ED. DIST. 270001404821 50 Elm Tree Academy Special Education Special Education School No Other 02 12 2017   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 1 0 0   0 0     0   0   1 0                 1
701573 MN Brown 8 school 2791353 6049 Education Districts RIVER BEND EDUCATION DISTRICT 279135304366 35 IMPRINTS PROGRAM Special Education Special Education School No Other 02 12 2017   grade_7 3.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 2.0         *         *   3.0 3 0 0   0 0     0   0   1 2                 3
702065 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001334 678 JUVENILE SERVICE CENTER Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 02 12 2017   grade_7 0.0 1.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0         *         *   1.0 0 1 0   0 0     0   0   0 1                 1
702266 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000468 17 LINCOLN EDUCATION CENTER Miscellaneous Program (assignment is now limited) Alternative School No Other 02 12 2017   grade_7 1.0 1.0 0.0   1.0 0.0     0.0   1.0   2.0 2.0         *         *   4.0 1 1 0   1 0     0   1   2 2                 4
866403 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001334 678 JUVENILE SERVICE CENTER Educational Oversight to Public Residential Care & Treatment (State approved) Alternative Education School No 4 02 12 2016   grade_7 0 1 0   0 0     0   0   0 1         *         *   1 0 1 0   0 0     0   0   0 1                 1
1158251 MN Brown 8 school 2791353 6049 Education Districts RIVER BEND EDUCATION DISTRICT 279135304366 35 IMPRINTS PROGRAM Special Education Special Education School No 4 02 12 2015   grade_7 3.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0         *         *   3.0 3 0 0   0 0     0   0   3 0                 3
1158773 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001334 678 JUVENILE SERVICE CENTER Educational Oversight to Public Residential Care & Treatment (State approved) Alternative Education School No 4 02 12 2015   grade_7 0.0 1.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 0 1 0   0 0     0   0   1 0                 1
1719699 MN Hennepin 27 school 2700190 4079 Charter Schools Friendship Academy of Fine Arts Charter 270019005280 30 Friendship Academy of the Arts - Intermediate Elementary School (Grades PK-6) Regular School Yes Middle 02 08 2021   grade_7 0 20 0   0 0     0   0   10 10     0.0   0.0     *   4.0   20 0 20 0   0 0     0   0   10 10     0 0     4   20
1724430 MN Wadena 80 school 2700014 6004 Education Districts Freshwater Education District 270001404821 50 Elm Tree Academy Special Education Special Education School No Other 02 12 2021   grade_7 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1725174 MN Anoka 2 school 2702264 916 Intermediate Districts and Schools Northeast Metro 916 270226405176 26 Cambia Hills Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 02 12 2021   grade_7 1 0 0   0 0     0   1   0 2     *   *     *   *   2 1 0 0   0 0     0   1   0 2                 2
1725229 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools Brainerd Public School District 270609000468 17 Lincoln Education Center Miscellaneous Program (assignment is now limited) Alternative School No Other 02 12 2021   grade_7 2 1 0   1 0     0   1   4 1     *   *     *   *   5 2 1 0   1 0     0   1   4 1                 5
1837302 MN Sherburne 71 school 2711370 728 Independent Districts and Schools Elk River School District 271137004142 401 ISD 728 Focus/Journey Special Education Special Education School No Other 02 12 2020   grade_7 2.0 0.0 0.0   0.0 0.0     0.0   2.0   4.0 0.0     *   *         *   4.0 2 0 0   0 0     0   2   4 0                 4
1837885 MN Cottonwood 17 school 2700086 991 Service Cooperative (ECSU Region) Region 6 and 8-SW/WC Service Cooperative 270008604168 16 SWWC ELC - Windom Special Education Special Education School No Other 02 12 2020   grade_7 3.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0     *   *         *   3.0 3 0 0   0 0     0   0   3 0                 3
1837980 MN Otter Tail 56 school 2700014 6004 Education Districts Freshwater Ed. Dist. 270001404821 50 Elm Tree Academy Special Education Special Education School No Other 02 12 2020   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1838121 MN Brown 8 school 2791353 6049 Education Districts River Bend Education District 279135305192 55 Raptor Program Special Education Special Education School No Other 02 12 2020   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1838634 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001334 678 Juvenile Service Center Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 02 12 2020   grade_7 0.0 3.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0     *   *         *   3.0 0 3 0   0 0     0   0   3 0                 3
1838812 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools Brainerd Public School District 270609000468 17 Lincoln Education Center Miscellaneous Program (assignment is now limited) Alternative School No Other 02 12 2020   grade_7 5.0 0.0 0.0   2.0 0.0     0.0   0.0   5.0 2.0     *   *         *   7.0 5 0 0   2 0     0   0   5 2                 7
1838844 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools Mankato Public School District 271878005116 375 Prairie Care Mankato Educational Oversight to Public Care and Treatment Day Program Alternative School No Other 02 12 2020   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1956342 MN Sherburne 71 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137004142 401 ISD 728 FOCUS/JOURNEY Special Education Special Education School No Other 02 12 2019   grade_7 3.0 0.0 2.0   0.0 0.0     0.0   0.0   5.0 0.0     *   *         *   5.0 3 0 2   0 0     0   0   5 0                 5
691603 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182004816 155 Gateway Academy Elementary School (Grades PK-6) Regular School No Elementary 03 08 2017   grade_7 7.0 0.0 2.0   0.0 0.0     0.0   0.0   4.0 5.0         *         *   9.0 7 0 2   0 0     0   0   4 5                 9
696340 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000988 134 LK NOKOMIS COMM-KEEWAYDIN CAMPUS Elementary School (Grades PK-6) Regular School No Elementary 03 08 2017   grade_7 27.0 15.0 14.0   5.0 7.0     0.0   1.0   41.0 28.0     10.0   2.0     42.0   13.0   69.0 27 15 14   5 7     0   1   41 28     10 2   42 13   69
701802 MN Mille Lacs 48 school 2730030 477 Independent Districts and Schools PRINCETON PUBLIC SCHOOL DISTRICT 273003004927 80 Princeton Online Academy Distance Learning Program OLL (State approved) Regular School No Other 03 12 2017   grade_7 3.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 1.0         *         *   3.0 3 0 0   0 0     0   0   2 1                 3
701943 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000313 160 FIRST CITY SCHOOL Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 03 12 2017   grade_7 0.0 0.0 0.0   1.0 0.0     0.0   0.0   0.0 1.0         *         *   1.0 0 0 0   1 0     0   0   0 1                 1
855980 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182004816 155 Gateway Academy Elementary School (Grades PK-6) Regular School No 1 03 07 2016   grade_7 16 0 1   0 0     0   1   10 8     0.0   0.0     2.0   3.0   18 16 0 1   0 0     0   1   10 8     0 0   2 3   18
860622 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000988 134 LK NOKOMIS COMM-KEEWAYDIN CAMPUS Elementary School (Grades PK-6) Regular School No 1 03 08 2016   grade_7 30 15 11   3 0     1   3   26 37     7.0   6.0     39.0   11.0   63 30 15 11   3 0     1   3   26 37     7 6   39 11   63
865079 MN Sherburne 71 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137004142 401 ISD 728 FOCUS/JOURNEY Special Education Special Education School No 4 03 12 2016   grade_7 2 0 0   0 0     0   0   2 0         *         *   2 2 0 0   0 0     0   0   2 0                 2
866275 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000313 160 FIRST CITY SCHOOL Educational Oversight to Public Residential Care & Treatment (State approved) Alternative Education School No 4 03 12 2016   grade_7 0 0 0   2 0     0   2   3 1         *         *   4 0 0 0   2 0     0   2   3 1                 4
866296 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142002799 970 CLAY COUNTY SHELTER CARE Educational Oversight to Public Residential Care & Treatment (State approved) Alternative Education School No 4 03 12 2016   grade_7 0 0 0   1 0     0   0   0 1         *         *   1 0 0 0   1 0     0   0   0 1                 1
866609 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000468 17 LINCOLN EDUCATION CENTER Miscellaneous Program (assignment is now limited) Alternative Education School No 4 03 12 2016   grade_7 5 1 0   0 0     0   1   7 0         *         *   7 5 1 0   0 0     0   1   7 0                 7
1153326 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000988 134 LK NOKOMIS COMM-KEEWAYDIN CAMPUS Elementary School (Grades PK-6) Regular School No 1 03 08 2015   grade_7 27.0 16.0 12.0   3.0 0.0     0.0   0.0   30.0 28.0     7.0   6.0     34.0   12.0   58.0 27 16 12   3 0     0   0   30 28     7 6   34 12   58
1157655 MN Sherburne 71 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137004142 401 ISD 728 FOCUS/JOURNEY Special Education Special Education School No 4 03 12 2015   grade_7 2.0 0.0 0.0   0.0 0.0     0.0   1.0   3.0 0.0         *         *   3.0 2 0 0   0 0     0   1   3 0                 3
1158183 MN Otter Tail 56 school 2700014 6004 Education Districts FRESHWATER ED. DIST. 270001404821 50 Elm Tree Academy Special Education Special Education School No 4 03 12 2015   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1158565 MN Ramsey 62 school 2700138 4025 Charter Schools CYBER VILLAGE ACADEMY 270013802717 10 CYBER VILLAGE ACADEMY Distance Learning Program OLL (State approved) Regular School Yes 4 03 12 2015   grade_7 20.0 0.0 4.0   0.0 0.0     0.0   2.0   13.0 13.0     0.0   0.0     8.0   6.0   26.0 20 0 4   0 0     0   2   13 13     0 0   8 6   26
1158629 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000313 160 FIRST CITY SCHOOL Educational Oversight to Public Residential Care & Treatment (State approved) Alternative Education School No 4 03 12 2015   grade_7 0.0 0.0 0.0   1.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 0 0 0   1 0     0   0   1 0                 1
1158656 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142002799 970 CLAY COUNTY SHELTER CARE Educational Oversight to Public Residential Care & Treatment (State approved) Alternative Education School No 4 03 12 2015   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1158981 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000468 17 LINCOLN EDUCATION CENTER Miscellaneous Program (assignment is now limited) Alternative Education School No 4 03 12 2015   grade_7 3.0 0.0 0.0   1.0 0.0     0.0   1.0   4.0 1.0         *         *   5.0 3 0 0   1 0     0   1   4 1                 5
1719142 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000988 134 Lake Nokomis Comm-Keewaydin Campus Elementary School (Grades PK-6) Regular School No Middle 03 08 2021   grade_7 42 12 10   1 1     1   9   37 39     6.0   0.0     33.0   18.0   76 42 12 10   1 1     1   9   37 39     6 0   33 18   76
1720028 MN Hennepin 27 school 2700295 4171 Charter Schools Noble Academy 270029503727 10 Noble Academy Elementary School (Grades PK-6) Regular School Yes Middle 03 08 2021   grade_7 0 10 1   0 75     0   1   45 42     25.0   0.0     62.0   11.0   87 0 10 1   0 75     0   1   45 42     25 0   62 11   87

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);