Data source: Big Local News · About: Big Local

4,774 rows where grade = "grade_7" and state = "MN" sorted by ccd_school_high_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
697316 MN Hennepin 27 school 2700309 4192 Charter Schools BEST ACADEMY 270030904261 10 Best Academy East at Olson Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2017   grade_7 0.0 30.0 0.0   0.0 0.0     0.0   0.0   14.0 16.0     17.0   2.0     26.0   0.0   30.0 0 30 0   0 0     0   0   14 16     17 2   26 0   30
697463 MN Ramsey 62 school 2700393 4225 Charter Schools Universal Academy Charter School 270039304758 10 Universal Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2017   grade_7 0.0 20.0 0.0   0.0 2.0     0.0   0.0   4.0 18.0         0.0         0.0   22.0 0 20 0   0 2     0   0   4 18       0     0   22
697800 MN Chippewa 12 school 2721320 129 Independent Districts and Schools MONTEVIDEO PUBLIC SCHOOL DISTRICT 272132001071 30 MONTEVIDEO MIDDLE Middle School (Grades 5-8) Regular School No Elementary 04 07 2017   grade_7 91.0 0.0 16.0   1.0 0.0     0.0   3.0   57.0 54.0     7.0   0.0     47.0   21.0   111.0 91 0 16   1 0     0   3   57 54     7 0   47 21   111
697920 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000078 320 SOUTHWEST MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 07 2017   grade_7 194.0 9.0 54.0   0.0 13.0     0.0   13.0   145.0 138.0         *         *   283.0 194 9 54   0 13     0   13   145 138                 283
697929 MN Goodhue 25 school 2730480 256 Independent Districts and Schools RED WING PUBLIC SCHOOL DISTRICT 273048001298 109 TWIN BLUFF MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 07 2017   grade_7 161.0 5.0 18.0   9.0 4.0     1.0   12.0   100.0 110.0     1.0   0.0     51.0   26.0   210.0 161 5 18   9 4     1   12   100 110     1 0   51 26   210
697966 MN Hennepin 27 school 2722920 277 Independent Districts and Schools WESTONKA PUBLIC SCHOOL DISTRICT 272292001109 63 GRANDVIEW MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 07 2017   grade_7 195.0 2.0 8.0   0.0 4.0     0.0   6.0   111.0 104.0     2.0   0.0     48.0   37.0   215.0 195 2 8   0 4     0   6   111 104     2 0   48 37   215
698419 MN Morrison 49 school 2733900 2170 Independent Districts and Schools STAPLES-MOTLEY SCHOOL DISTRICT 273390002468 50 MOTLEY-STAPLES MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Elementary 04 07 2017   grade_7 80.0 0.0 4.0   1.0 1.0     0.0   1.0   47.0 40.0     0.0   4.0     43.0   12.0   87.0 80 0 4   1 1     0   1   47 40     0 4   43 12   87
698469 MN Faribault 22 school 2700130 2860 Independent Districts and Schools BLUE EARTH AREA PUBLIC SCHOOL 270013002497 23 BLUE EARTH AREA MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 07 2017   grade_7 77.0 1.0 18.0   0.0 0.0     0.0   0.0   44.0 52.0     0.0   0.0     46.0   12.0   96.0 77 1 18   0 0     0   0   44 52     0 0   46 12   96
700402 MN Goodhue 25 school 2791443 6051 Education Districts Goodhue County Education District 279144304717 610 Pathways Program Grades 6-7 Public Area Learning Center ALC (State approved) Alternative School No Middle 06 07 2017   grade_7 3.0 0.0 1.0   2.0 0.0     0.0   0.0   1.0 5.0         *         *   6.0 3 0 1   2 0     0   0   1 5                 6
700703 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295002998 39 MOUNDS VIEW BRIDGES PROGRAM Special Education Special Education School No Elementary KG 07 2017   grade_7 4.0 0.0 1.0   0.0 0.0     0.0   0.0   4.0 1.0         *         *   5.0 4 0 1   0 0     0   0   4 1                 5
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
861658 MN Dodge 20 school 2700375 4214 Charter Schools WEST CONCORD PUBLIC CHARTER SCHOOL 270037504607 10 WEST CONCORD PUBLIC CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes 1 KG 07 2016   grade_7 6 0 0   0 0     0   0   5 1         *         *   6 6 0 0   0 0     0   0   5 1                 6
861722 MN Isanti 30 school 2700397 4227 Charter Schools Art and Science Academy 270039704766 10 Art and Science Academy Elementary School (Grades PK-6) Regular School Yes 1 KG 07 2016   grade_7 11 0 0   0 0     0   0   8 3     0.0   0.0     4.0   0.0   11 11 0 0   0 0     0   0   8 3     0 0   4 0   11
861731 MN Washington 82 school 2700401 4228 Charter Schools Woodbury Leadership Academy 270040104812 10 Woodbury Leadership Academy Elementary School (Grades PK-6) Regular School Yes 1 KG 07 2016   grade_7 15 0 0   0 1     0   1   9 8     0.0   0.0     1.0   3.0   17 15 0 0   0 1     0   1   9 8     0 0   1 3   17
861991 MN Chippewa 12 school 2721320 129 Independent Districts and Schools MONTEVIDEO PUBLIC SCHOOL DISTRICT 272132001071 30 MONTEVIDEO MIDDLE Middle School (Grades 5-8) Regular School No 2 04 07 2016   grade_7 67 1 19   0 0     1   5   42 51     9.0   1.0     48.0   16.0   93 67 1 19   0 0     1   5   42 51     9 1   48 16   93
862100 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000078 320 SOUTHWEST MIDDLE Middle School (Grades 5-8) Regular School No 2 06 07 2016   grade_7 170 6 45   1 15     0   7   127 117         *         *   244 170 6 45   1 15     0   7   127 117                 244
862109 MN Goodhue 25 school 2730480 256 Independent Districts and Schools RED WING PUBLIC SCHOOL DISTRICT 273048001298 109 TWIN BLUFF MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 05 07 2016   grade_7 148 4 15   8 1     0   10   91 95     3.0   1.0     64.0   21.0   186 148 4 15   8 1     0   10   91 95     3 1   64 21   186
862146 MN Hennepin 27 school 2722920 277 Independent Districts and Schools WESTONKA PUBLIC SCHOOL DISTRICT 272292001109 63 GRANDVIEW MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 05 07 2016   grade_7 177 3 6   0 0     0   11   104 93     0.0   0.0     32.0   24.0   197 177 3 6   0 0     0   11   104 93     0 0   32 24   197
862639 MN Faribault 22 school 2700130 2860 Independent Districts and Schools BLUE EARTH AREA PUBLIC SCHOOL 270013002497 23 BLUE EARTH AREA MIDDLE Middle School (Grades 5-8) Regular School No 2 06 07 2016   grade_7 78 0 15   0 0     0   0   56 37     3.0   0.0     39.0   7.0   93 78 0 15   0 0     0   0   56 37     3 0   39 7   93
862812 MN Hennepin 27 school 2700405 4235 Charter Schools Flex Academy 270040504794 10 Flex Academy Middle School (Grades 5-8) Regular School Yes 2 05 07 2016   grade_7 10 3 5   1 0     0   0   13 6         1.0         *   19 10 3 5   1 0     0   0   13 6       1         19
864928 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295002998 39 MOUNDS VIEW BRIDGES PROGRAM Special Education Special Education School No 1 KG 07 2016   grade_7 1 2 0   0 0     0   1   4 0         *         *   4 1 2 0   0 0     0   1   4 0                 4
865113 MN Steele 74 school 2728050 761 Independent Districts and Schools OWATONNA PUBLIC SCHOOL DISTRICT 272805004822 155 Elementary Actions Special Education Special Education School No 1 KG 07 2016   grade_7 0 1 0   0 0     0   0   1 0         *         *   1 0 1 0   0 0     0   0   1 0                 1
1154664 MN Chippewa 12 school 2721320 129 Independent Districts and Schools MONTEVIDEO PUBLIC SCHOOL DISTRICT 272132001071 30 MONTEVIDEO MIDDLE Middle School (Grades 5-8) Regular School No 2 04 07 2015   grade_7 64.0 3.0 16.0   1.0 1.0     0.0   2.0   53.0 34.0     12.0   0.0     40.0   17.0   87.0 64 3 16   1 1     0   2   53 34     12 0   40 17   87
1154772 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000078 320 SOUTHWEST MIDDLE Middle School (Grades 5-8) Regular School No 2 06 07 2015   grade_7 167.0 7.0 57.0   0.0 10.0     0.0   6.0   126.0 121.0         *         *   247.0 167 7 57   0 10     0   6   126 121                 247
1154781 MN Goodhue 25 school 2730480 256 Independent Districts and Schools RED WING PUBLIC SCHOOL DISTRICT 273048001298 109 TWIN BLUFF MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 05 07 2015   grade_7 152.0 10.0 15.0   12.0 8.0     0.0   6.0   108.0 95.0     3.0   1.0     77.0   27.0   203.0 152 10 15   12 8     0   6   108 95     3 1   77 27   203
1154818 MN Hennepin 27 school 2722920 277 Independent Districts and Schools WESTONKA PUBLIC SCHOOL DISTRICT 272292001109 63 GRANDVIEW MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 05 07 2015   grade_7 154.0 3.0 9.0   0.0 2.0     0.0   13.0   92.0 89.0     1.0   1.0     46.0   20.0   181.0 154 3 9   0 2     0   13   92 89     1 1   46 20   181
1155292 MN Faribault 22 school 2700130 2860 Independent Districts and Schools BLUE EARTH AREA PUBLIC SCHOOL 270013002497 23 BLUE EARTH AREA MIDDLE Middle School (Grades 5-8) Regular School No 2 06 07 2015   grade_7 75.0 1.0 10.0   0.0 0.0     0.0   0.0   53.0 33.0     2.0   0.0     38.0   12.0   86.0 75 1 10   0 0     0   0   53 33     2 0   38 12   86
1157211 MN Goodhue 25 school 2791443 6051 Education Districts Goodhue County Education District 279144304717 610 Pathways Program Public Area Learning Center ALC (State approved) Alternative Education School No 2 06 07 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
1157506 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295002998 39 MOUNDS VIEW BRIDGES PROGRAM Special Education Special Education School No 1 KG 07 2015   grade_7 2.0 2.0 0.0   0.0 0.0     0.0   0.0   3.0 1.0         *         *   4.0 2 2 0   0 0     0   0   3 1                 4
1719725 MN Ramsey 62 school 2700353 4088 Charter Schools Urban Academy Charter School 270035304173 10 Urban Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 07 2021   grade_7 1 6 0   0 31     0   0   15 23     21.0   0.0     *   8.0   38 1 6 0   0 31     0   0   15 23     21 0     8   38
1720106 MN Hennepin 27 school 2700308 4191 Charter Schools KIPP Minnesota Charter School 270030805269 20 KIPP Legacy Academy Elementary School (Grades PK-6) Regular School Yes Middle 04 07 2021   grade_7 0 34 1   0 0     0   0   19 16     0.0   3.0     28.0   9.0   35 0 34 1   0 0     0   0   19 16     0 3   28 9   35
1720342 MN Hennepin 27 school 2700404 4232 Charter Schools Success Academy 270040404790 10 Success Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2021   grade_7 0 9 0   0 0     0   0   5 4     *   *     *   *   9 0 9 0   0 0     0   0   5 4                 9
1720405 MN Chisago 13 school 2700429 4253 Charter Schools Phoenix Academy Charter School 270042904969 10 Phoenix Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2021   grade_7 8 0 0   0 0     0   1   3 6     *   *     *   *   9 8 0 0   0 0     0   1   3 6                 9
1720506 MN Ramsey 62 school 2700458 4275 Charter Schools St. Paul School of Northern Lights 270045805256 10 St. Paul School of Northern Lights Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2021   grade_7 6 0 1   0 0     0   1   5 3     *   *     *   *   8 6 0 1   0 0     0   1   5 3                 8
1720765 MN Chippewa 12 school 2721320 129 Independent Districts and Schools Montevideo Public School District 272132001071 30 Montevideo Middle Middle School (Grades 5-8) Regular School No Middle 04 07 2021   grade_7 73 2 15   2 0     3   6   50 51     10.0   0.0     42.0   18.0   101 73 2 15   2 0     3   6   50 51     10 0   42 18   101
1720879 MN Freeborn 24 school 2702970 241 Independent Districts and Schools Albert Lea Public School District 270297000078 320 Southwest Middle Middle School (Grades 5-8) Regular School No Middle 06 07 2021   grade_7 165 7 72   0 21     0   8   149 124     *   *     *   *   273 165 7 72   0 21     0   8   149 124                 273
1720919 MN Hennepin 27 school 2722920 277 Independent Districts and Schools Westonka Public School District 272292001109 63 Grandview Middle School Middle School (Grades 5-8) Regular School No Middle 05 07 2021   grade_7 160 8 11   0 1     0   13   89 104     3.0   0.0     26.0   36.0   193 160 8 11   0 1     0   13   89 104     3 0   26 36   193
1721473 MN Faribault 22 school 2700130 2860 Independent Districts and Schools Blue Earth Area Public School 270013002497 23 Blue Earth Area Middle Middle School (Grades 5-8) Regular School No Middle 06 07 2021   grade_7 71 1 9   0 0     0   0   42 39     2.0   0.0     25.0   15.0   81 71 1 9   0 0     0   0   42 39     2 0   25 15   81
1721611 MN Hennepin 27 school 2700288 4170 Charter Schools Hiawatha Academies 270028805141 15 Hiawatha College Prep - Northrop Middle School (Grades 5-8) Regular School Yes Middle 05 07 2021   grade_7 0 7 73   0 1     0   1   44 38     32.0   1.0     73.0   11.0   82 0 7 73   0 1     0   1   44 38     32 1   73 11   82
1721633 MN Anoka 2 school 2700380 4213 Charter Schools Prodeo Academy 270038005319 12 Prodeo Academy Columbia Heights Middle Middle School (Grades 5-8) Regular School Yes Middle 05 07 2021   grade_7 1 32 17   0 0     0   1   25 26     7.0   6.0     38.0   7.0   51 1 32 17   0 0     0   1   25 26     7 6   38 7   51
1721652 MN Ramsey 62 school 2700438 4258 Charter Schools The Journey School 270043805290 20 The Journey School Middle Middle School (Grades 5-8) Regular School Yes Middle 07 07 2021   grade_7 3 1 4   0 0     0   2   5 5     1.0   0.0     *   1.0   10 3 1 4   0 0     0   2   5 5     1 0     1   10
1723656 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295002998 39 Mounds View Bridges Program Special Education Special Education School No Elementary KG 07 2021   grade_7 0 0 1   0 0     0   0   1 0     *   *     *   *   1 0 0 1   0 0     0   0   1 0                 1
1829732 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180001004 136 Jefferson Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 07 2020   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
1833254 MN Hennepin 27 school 2700190 4079 Charter Schools Friendship Academy of Fine Arts Charter 270019003143 10 Friendship Academy of Fine Arts Charter Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2020   grade_7 0.0 19.0 0.0   0.0 0.0     0.0   0.0   10.0 9.0     0.0   0.0     11.0   3.0   19.0 0 19 0   0 0     0   0   10 9     0 0   11 3   19
1833305 MN Hennepin 27 school 2700237 4097 Charter Schools Partnership Academy, Inc. 270023703278 10 Partnership Academy, Inc. Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2020   grade_7 0.0 3.0 43.0   0.0 0.0     0.0   0.0   24.0 22.0     *   0.0     35.0   6.0   46.0 0 3 43   0 0     0   0   24 22       0   35 6   46
1833446 MN Stearns 73 school 2700252 4142 Charter Schools Stride Academy Charter School 270025204405 20 Stride Academy K-7 Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2020   grade_7 7.0 39.0 1.0   1.0 1.0     0.0   1.0   25.0 25.0     26.0   0.0     35.0   10.0   50.0 7 39 1   1 1     0   1   25 25     26 0   35 10   50
1833759 MN Hennepin 27 school 2700373 4209 Charter Schools Mastery School 270037304602 10 Mastery School Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2020   grade_7 0.0 20.0 0.0   0.0 0.0     0.0   1.0   13.0 8.0     0.0   0.0         9.0   21.0 0 20 0   0 0     0   1   13 8     0 0     9   21
1833926 MN Ramsey 62 school 2700423 4243 Charter Schools North Metro Flex Academy 270042304942 10 North Metro Flex Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2020   grade_7 2.0 6.0 2.0   0.0 0.0     0.0   0.0   5.0 5.0     2.0   0.0         6.0   10.0 2 6 2   0 0     0   0   5 5     2 0     6   10
1833987 MN Hennepin 27 school 2700439 4261 Charter Schools SciTech Academy Charter School 270043905072 10 SciTech Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2020   grade_7 0.0 23.0 0.0   0.0 0.0     0.0   0.0   16.0 7.0     *   0.0         6.0   23.0 0 23 0   0 0     0   0   16 7       0     6   23
1834272 MN Chippewa 12 school 2721320 129 Independent Districts and Schools Montevideo Public School District 272132001071 30 Montevideo Middle Middle School (Grades 5-8) Regular School No Middle 04 07 2020   grade_7 79.0 2.0 23.0   3.0 2.0     2.0   6.0   60.0 57.0     9.0   0.0     59.0   18.0   117.0 79 2 23   3 2     2   6   60 57     9 0   59 18   117
1834393 MN Freeborn 24 school 2702970 241 Independent Districts and Schools Albert Lea Public School District 270297000078 320 Southwest Middle Middle School (Grades 5-8) Regular School No Middle 06 07 2020   grade_7 162.0 10.0 58.0   1.0 23.0     0.0   12.0   129.0 137.0     *   *         *   266.0 162 10 58   1 23     0   12   129 137                 266
1834402 MN Goodhue 25 school 2730480 256 Independent Districts and Schools Red Wing Public School District 273048001298 109 Twin Bluff Middle School Middle School (Grades 5-8) Regular School No Middle 05 07 2020   grade_7 142.0 8.0 23.0   7.0 5.0     0.0   12.0   102.0 95.0     3.0   0.0     71.0   30.0   197.0 142 8 23   7 5     0   12   102 95     3 0   71 30   197
1834437 MN Hennepin 27 school 2722920 277 Independent Districts and Schools Westonka Public School District 272292001109 63 Grandview Middle School Middle School (Grades 5-8) Regular School No Middle 05 07 2020   grade_7 162.0 3.0 6.0   0.0 2.0     0.0   15.0   96.0 92.0     0.0   1.0     29.0   30.0   188.0 162 3 6   0 2     0   15   96 92     0 1   29 30   188
1834997 MN Faribault 22 school 2700130 2860 Independent Districts and Schools Blue Earth Area Public School 270013002497 23 Blue Earth Area Middle Middle School (Grades 5-8) Regular School No Middle 06 07 2020   grade_7 70.0 3.0 11.0   0.0 0.0     0.0   1.0   42.0 43.0     2.0   0.0     45.0   12.0   85.0 70 3 11   0 0     0   1   42 43     2 0   45 12   85
1837173 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295002998 39 Mounds View Bridges Program Special Education Special Education School No Elementary KG 07 2020   grade_7 4.0 2.0 0.0   0.0 0.0     0.0   0.0   6.0 0.0     *   *         *   6.0 4 2 0   0 0     0   0   6 0                 6
1837709 MN Wright 86 school 2700045 938 Special Education Cooperatives Meeker And Wright Special Education 270004502732 18 Eastern Wright Program Special Education Special Education School No Elementary KG 07 2020   grade_7 4.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 1.0     *   *         *   4.0 4 0 0   0 0     0   0   3 1                 4
1886255 MN Wright 86 school 2707200 877 Independent Districts and Schools Buffalo-Hanover-Montrose Public Schools 270720000286 20 Hanover Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 07 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
1887787 MN Ramsey 62 school 2700185 4073 Charter Schools Academia Cesar Chavez Charter School 270018503138 10 Academia Cesar Chavez Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 07 2018   grade_7 4.0 0.0 52.0   0.0 1.0     0.0   1.0   26.0 32.0     28.0   2.0     *   11.0   58.0 4 0 52   0 1     0   1   26 32     28 2     11   58
1888480 MN Stearns 73 school 2700430 4250 Charter Schools Athlos Academy of Saint Cloud 270043004959 10 Athlos Academy of Saint Cloud Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2018   grade_7 32.0 26.0 4.0   0.0 1.0     0.0   6.0   38.0 31.0     18.0   1.0     37.0   9.0   69.0 32 26 4   0 1     0   6   38 31     18 1   37 9   69
1888751 MN Chippewa 12 school 2721320 129 Independent Districts and Schools Montevideo Public School District 272132001071 30 Montevideo Middle Middle School (Grades 5-8) Regular School No Middle 04 07 2018   grade_7 89.0 1.0 11.0   0.0 2.0     1.0   3.0   68.0 39.0     5.0   0.0     39.0   19.0   107.0 89 1 11   0 2     1   3   68 39     5 0   39 19   107
1888873 MN Freeborn 24 school 2702970 241 Independent Districts and Schools Albert Lea Public School District 270297000078 320 Southwest Middle Middle School (Grades 5-8) Regular School No Middle 06 07 2018   grade_7 163.0 5.0 59.0   3.0 14.0     0.0   8.0   132.0 120.0     14.0   1.0     123.0   37.0   252.0 163 5 59   3 14     0   8   132 120     14 1   123 37   252
1888882 MN Goodhue 25 school 2730480 256 Independent Districts and Schools Red Wing Public School District 273048001298 109 Twin Bluff Middle School Middle School (Grades 5-8) Regular School No Middle 05 07 2018   grade_7 155.0 5.0 18.0   7.0 1.0     0.0   15.0   99.0 102.0     1.0   0.0     71.0   31.0   201.0 155 5 18   7 1     0   15   99 102     1 0   71 31   201
1888917 MN Hennepin 27 school 2722920 277 Independent Districts and Schools Westonka Public School District 272292001109 63 Grandview Middle School Middle School (Grades 5-8) Regular School No Middle 05 07 2018   grade_7 178.0 5.0 7.0   1.0 3.0     0.0   7.0   103.0 98.0     0.0   0.0     25.0   28.0   201.0 178 5 7   1 3     0   7   103 98     0 0   25 28   201
1889397 MN Morrison 49 school 2733900 2170 Independent Districts and Schools Staples-Motley School District 273390002468 50 Motley-Staples Middle School Middle School (Grades 5-8) Regular School No Middle 04 07 2018   grade_7 87.0 0.0 3.0   0.0 0.0     0.0   4.0   52.0 42.0     0.0   3.0     50.0   17.0   94.0 87 0 3   0 0     0   4   52 42     0 3   50 17   94
1889443 MN Faribault 22 school 2700130 2860 Independent Districts and Schools Blue Earth Area Public Schools 270013002497 23 Blue Earth Area Middle Middle School (Grades 5-8) Regular School No Middle 06 07 2018   grade_7 74.0 3.0 17.0   1.0 0.0     0.0   2.0   56.0 41.0     1.0   0.0     54.0   12.0   97.0 74 3 17   1 0     0   2   56 41     1 0   54 12   97
1891345 MN Goodhue 25 school 2791443 6051 Education Districts Goodhue County Education District 279144304717 610 Pathways Program Grades 6-7 Public Area Learning Center ALC (State approved) Alternative School No Middle 06 07 2018   grade_7 1.0 0.0 1.0   1.0 0.0     0.0   1.0   3.0 1.0     *   *     *   *   4.0 1 0 1   1 0     0   1   3 1                 4
1891637 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295002998 39 Mounds View Bridges Program Special Education Special Education School No Elementary KG 07 2018   grade_7 1.0 1.0 1.0   0.0 0.0     0.0   0.0   3.0 0.0     *   *     *   *   3.0 1 1 1   0 0     0   0   3 0                 3
1892215 MN Wright 86 school 2700045 938 Special Education Cooperatives Meeker and Wright Special Education 270004502732 18 Eastern Wright Program Special Education Special Education School No Elementary KG 07 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
1952644 MN Mcleod 43 school 2700277 4161 Charter Schools NEW DISCOVERIES MONTESSORI ACADEMY 270027703616 10 NEW DISCOVERIES MONTESSORI ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary PK 07 2019   grade_7 9.0 0.0 3.0   0.0 0.0     0.0   0.0   3.0 9.0     0.0   0.0         6.0   12.0 9 0 3   0 0     0   0   3 9     0 0     6   12
1952679 MN Hennepin 27 school 2700289 4169 Charter Schools Stonebridge World School 270028903731 10 Stonebridge World School Elementary School (Grades PK-6) Regular School Yes Elementary PK 07 2019   grade_7 0.0 18.0 7.0   1.0 0.0     0.0   1.0   19.0 8.0     3.0   1.0         8.0   27.0 0 18 7   1 0     0   1   19 8     3 1     8   27
1952909 MN Hennepin 27 school 2700398 4219 Charter Schools Northeast College Prep 270039804757 10 Northeast College Prep Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2019   grade_7 3.0 27.0 4.0   0.0 1.0     0.0   1.0   15.0 21.0     13.0   0.0         5.0   36.0 3 27 4   0 1     0   1   15 21     13 0     5   36
1952918 MN Hennepin 27 school 2700394 4220 Charter Schools Agamim Classical Academy 270039404751 10 Agamim Classical Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2019   grade_7 7.0 8.0 1.0   0.0 0.0     0.0   0.0   7.0 9.0     2.0   0.0     8.0   4.0   16.0 7 8 1   0 0     0   0   7 9     2 0   8 4   16
1952927 MN Dakota 19 school 2700391 4221 Charter Schools Discovery Charter School 270039104764 10 Discovery Charter Elementary School Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2019   grade_7 7.0 1.0 4.0   0.0 0.0     0.0   1.0   8.0 5.0     1.0   0.0     6.0   3.0   13.0 7 1 4   0 0     0   1   8 5     1 0   6 3   13
1952963 MN Hennepin 27 school 2700396 4226 Charter Schools Bdote Learning Center 270039604763 10 Bdote Learning Center Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2019   grade_7 0.0 0.0 1.0   11.0 0.0     0.0   0.0   7.0 5.0     0.0   8.0         6.0   12.0 0 0 1   11 0     0   0   7 5     0 8     6   12
1953026 MN Ramsey 62 school 2700410 4240 Charter Schools New Century School 270041004873 10 New Century School Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2019   grade_7 0.0 25.0 0.0   0.0 0.0     0.0   0.0   8.0 17.0     *   0.0         1.0   25.0 0 25 0   0 0     0   0   8 17       0     1   25
1953348 MN Chippewa 12 school 2721320 129 Independent Districts and Schools MONTEVIDEO PUBLIC SCHOOL DISTRICT 272132001071 30 MONTEVIDEO MIDDLE Middle School (Grades 5-8) Regular School No Middle 04 07 2019   grade_7 89.0 2.0 20.0   1.0 0.0     0.0   2.0   60.0 54.0     3.0   1.0     45.0   20.0   114.0 89 2 20   1 0     0   2   60 54     3 1   45 20   114
1953469 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000078 320 SOUTHWEST MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 07 2019   grade_7 163.0 4.0 50.0   0.0 12.0     0.0   6.0   127.0 108.0     *   *         *   235.0 163 4 50   0 12     0   6   127 108                 235
1953478 MN Goodhue 25 school 2730480 256 Independent Districts and Schools RED WING PUBLIC SCHOOL DISTRICT 273048001298 109 TWIN BLUFF MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 07 2019   grade_7 178.0 8.0 17.0   8.0 4.0     0.0   17.0   101.0 131.0     1.0   0.0     88.0   29.0   232.0 178 8 17   8 4     0   17   101 131     1 0   88 29   232
1953513 MN Hennepin 27 school 2722920 277 Independent Districts and Schools WESTONKA PUBLIC SCHOOL DISTRICT 272292001109 63 GRANDVIEW MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 07 2019   grade_7 173.0 2.0 8.0   1.0 1.0     0.0   15.0   113.0 87.0     0.0   *     34.0   31.0   200.0 173 2 8   1 1     0   15   113 87     0     34 31   200
1954001 MN Morrison 49 school 2733900 2170 Independent Districts and Schools STAPLES-MOTLEY SCHOOL DISTRICT 273390002468 50 MOTLEY-STAPLES MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 04 07 2019   grade_7 77.0 0.0 4.0   2.0 0.0     0.0   0.0   50.0 33.0     1.0   5.0     42.0   11.0   83.0 77 0 4   2 0     0   0   50 33     1 5   42 11   83
1954051 MN Faribault 22 school 2700130 2860 Independent Districts and Schools BLUE EARTH AREA PUBLIC SCHOOL 270013002497 23 BLUE EARTH AREA MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 07 2019   grade_7 73.0 1.0 8.0   0.0 1.0     0.0   0.0   43.0 40.0     4.0   0.0         7.0   83.0 73 1 8   0 1     0   0   43 40     4 0     7   83
1956205 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295002998 39 MOUNDS VIEW BRIDGES PROGRAM Special Education Special Education School No Elementary KG 07 2019   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
1956763 MN Wright 86 school 2700045 938 Special Education Cooperatives MEEKER AND WRIGHT SPECIAL EDUCATION 270004502732 18 EASTERN WRIGHT PROGRAM Special Education Special Education School No Elementary KG 07 2019   grade_7 2.0 1.0 0.0   0.0 0.0     0.0   0.0   2.0 1.0     *   *         *   3.0 2 1 0   0 0     0   0   2 1                 3
690899 MN Becker 3 school 2728960 25 Independent Districts and Schools PINE POINT PUBLIC SCHOOL DISTRICT 272896000034 70 PINE POINT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_7 0.0 0.0 0.0   3.0 0.0     0.0   0.0   0.0 3.0         *         *   3.0 0 0 0   3 0     0   0   0 3                 3
690986 MN Beltrami 4 school 2730510 38 Independent Districts and Schools RED LAKE PUBLIC SCHOOL DISTRICT 273051001301 20 PONEMAH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_7 0.0 0.0 0.0   7.0 0.0     0.0   0.0   5.0 2.0         *         *   7.0 0 0 0   7 0     0   0   5 2                 7
691021 MN Benton 5 school 2712240 51 Independent Districts and Schools FOLEY PUBLIC SCHOOL DISTRICT 271224002270 30 FOLEY INTERMEDIATE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 04 08 2017   grade_7 145.0 0.0 1.0   0.0 0.0     0.0   2.0   81.0 67.0     0.0   0.0     41.0   23.0   148.0 145 0 1   0 0     0   2   81 67     0 0   41 23   148
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
692600 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178004952 401 The FAIR School - Crystal Elementary School (Grades PK-6) Regular School No Elementary 04 08 2017   grade_7 32.0 50.0 7.0   3.0 5.0     0.0   10.0   47.0 60.0     5.0   0.0     55.0   13.0   107.0 32 50 7   3 5     0   10   47 60     5 0   55 13   107
693432 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180001005 138 LINCOLN K-8 CHOICE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 08 2017   grade_7 31.0 4.0 2.0   0.0 4.0     0.0   2.0   19.0 24.0         0.0         6.0   43.0 31 4 2   0 4     0   2   19 24       0     6   43
693754 MN Ramsey 62 school 2732430 623 Independent Districts and Schools ROSEVILLE PUBLIC SCHOOL DISTRICT 273243001046 73 PARKVIEW CENTER SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_7 65.0 15.0 3.0   0.0 6.0     0.0   2.0   47.0 44.0         0.0         12.0   91.0 65 15 3   0 6     0   2   47 44       0     12   91
694031 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004457 489 HAZEL PARK PREPARATORY ACADEMY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_7 4.0 40.0 24.0   2.0 32.0     0.0   0.0   56.0 46.0     37.0   6.0     89.0   10.0   102.0 4 40 24   2 32     0   0   56 46     37 6   89 10   102
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
694100 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001612 528 LINWOOD MONROE ARTS PLUS UPPER Elementary School (Grades PK-6) Regular School No Elementary 04 08 2017   grade_7 49.0 40.0 13.0   0.0 22.0     0.0   6.0   59.0 71.0     29.0   0.0     77.0   27.0   130.0 49 40 13   0 22     0   6   59 71     29 0   77 27   130
694175 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384002303 579 AMERICAN INDIAN MAGNET SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_7 3.0 9.0 13.0   15.0 23.0     0.0   4.0   30.0 37.0     22.0   1.0     57.0   15.0   67.0 3 9 13   15 23     0   4   30 37     22 1   57 15   67
694697 MN Stearns 73 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351001485 25 KENNEDY COMMUNITY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_7 62.0 9.0 4.0   0.0 0.0     0.0   1.0   43.0 33.0         0.0     34.0   13.0   76.0 62 9 4   0 0     0   1   43 33       0   34 13   76
696219 MN Lesueur 40 school 2700379 2905 Independent Districts and Schools TRI-CITY UNITED SCHOOL DISTRICT 270037904626 10 LE CENTER PRE K-8 Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_7 46.0 1.0 16.0   0.0 0.0     0.0   0.0   29.0 34.0     4.0   0.0     30.0   3.0   63.0 46 1 16   0 0     0   0   29 34     4 0   30 3   63
696230 MN Lesueur 40 school 2700379 2905 Independent Districts and Schools TRI-CITY UNITED SCHOOL DISTRICT 270037904625 30 MONTGOMERY PRE K-8 Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_7 73.0 1.0 12.0   0.0 0.0     0.0   4.0   43.0 47.0     4.0   3.0     38.0   9.0   90.0 73 1 12   0 0     0   4   43 47     4 3   38 9   90
696297 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000942 106 BARTON OPEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 08 2017   grade_7 55.0 22.0 4.0   2.0 4.0     0.0   1.0   43.0 45.0     13.0   0.0     30.0   6.0   88.0 55 22 4   2 4     0   1   43 45     13 0   30 6   88
696319 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000969 121 LAKE HARRIET UPPER SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 04 08 2017   grade_7 129.0 7.0 11.0   1.0 9.0     0.0   4.0   82.0 79.0     3.0   0.0     21.0   16.0   161.0 129 7 11   1 9     0   4   82 79     3 0   21 16   161
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

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]);