Data source: Big Local News · About: Big Local

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

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
697776 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819000345 61 CHASKA MIDDLE SCHOOL EAST Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 174.0 4.0 15.0   0.0 3.0     0.0   9.0   98.0 107.0     5.0   *         *   205.0 174 4 15   0 3     0   9   98 107     5           205
697832 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000295 15 John Metcalf Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 66.0 23.0 16.0   0.0 18.0     0.0   9.0   61.0 71.0     13.0   1.0     48.0   13.0   132.0 66 23 16   0 18     0   9   61 71     13 1   48 13   132
697864 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239000484 25 DAKOTA HILLS MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 230.0 21.0 27.0   0.0 47.0     0.0   9.0   163.0 171.0     11.0   0.0         40.0   334.0 230 21 27   0 47     0   9   163 171     11 0     40   334
697889 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227002646 52 FRIENDLY HILLS MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_7 133.0 19.0 33.0   0.0 8.0     0.0   9.0   123.0 79.0     10.0   0.0     53.0   30.0   202.0 133 19 33   0 8     0   9   123 79     10 0   53 30   202
698160 MN Polk 60 school 2711130 595 Independent Districts and Schools EAST GRAND FORKS PUBLIC SCHOOL DIST 271113000494 310 CENTRAL MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 102.0 8.0 14.0   0.0 0.0     0.0   9.0   60.0 73.0     6.0   0.0     44.0   18.0   133.0 102 8 14   0 0     0   9   60 73     6 0   44 18   133
698216 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004681 344 Parkway Montessori/Community Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 20.0 29.0 33.0   1.0 79.0     0.0   9.0   84.0 87.0     58.0   2.0     144.0   21.0   171.0 20 29 33   1 79     0   9   84 87     58 2   144 21   171
698237 MN Saint Louis 69 school 2713920 700 Independent Districts and Schools HERMANTOWN PUBLIC SCHOOL DISTRICT 271392002143 15 HERMANTOWN MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_7 154.0 2.0 3.0   1.0 1.0     0.0   9.0   85.0 85.0     0.0   2.0     27.0   27.0   170.0 154 2 3   1 1     0   9   85 85     0 2   27 27   170
698333 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381001542 22 OLTMAN MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 138.0 12.0 24.0   0.0 18.0     0.0   9.0   102.0 99.0     11.0   4.0     73.0   23.0   201.0 138 12 24   0 18     0   9   102 99     11 4   73 23   201
698377 MN Wright 86 school 2733790 885 Independent Districts and Schools ST. MICHAEL-ALBERTVILLE SCHOOL DIST 273379004346 90 ST MICHAEL-ALBERTVILLE MIDDLE WEST Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_7 231.0 8.0 9.0   0.0 3.0     0.0   9.0   133.0 127.0     3.0   0.0     41.0   24.0   260.0 231 8 9   0 3     0   9   133 127     3 0   41 24   260
698381 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741003671 301 CAMBRIDGE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 166.0 4.0 7.0   0.0 6.0     0.0   9.0   102.0 90.0         2.0     65.0   29.0   192.0 166 4 7   0 6     0   9   102 90       2   65 29   192
700162 MN Sherburne 71 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137003363 603 IVAN SAND COMMUNITY SCHOOL-MIDDLE Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2017   grade_7 113.0 7.0 5.0   0.0 1.0     0.0   9.0   80.0 55.0     5.0   0.0     46.0   1.0   135.0 113 7 5   0 1     0   9   80 55     5 0   46 1   135
702569 MN Steele 74 school 2728050 761 Independent Districts and Schools OWATONNA PUBLIC SCHOOL DISTRICT 272805001227 151 OWATONNA JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No Middle 07 08 2017   grade_7 274.0 26.0 45.0   0.0 5.0     0.0   9.0   194.0 165.0     31.0   4.0         51.0   359.0 274 26 45   0 5     0   9   194 165     31 4     51   359
702583 MN Washington 82 school 2738190 834 Independent Districts and Schools STILLWATER AREA PUBLIC SCHOOL DIST. 273819001660 48 OAK-LAND JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No Other 07 09 2017   grade_7 229.0 24.0 20.0   1.0 21.0     0.0   9.0   161.0 143.0         *         42.0   304.0 229 24 20   1 21     0   9   161 143             42   304
1154562 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000117 3 ANOKA MIDDLE SCHOOL FOR THE ARTS Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 491.0 45.0 23.0   9.0 23.0     0.0   9.0   267.0 333.0     14.0   7.0     209.0   95.0   600.0 491 45 23   9 23     0   9   267 333     14 7   209 95   600
1154566 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000099 4 COON RAPIDS MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 270.0 51.0 27.0   7.0 19.0     0.0   9.0   197.0 186.0     18.0   8.0     183.0   53.0   383.0 270 51 27   7 19     0   9   197 186     18 8   183 53   383
1154792 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000228 346 OLSON MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 214.0 38.0 20.0   0.0 25.0     0.0   9.0   179.0 127.0     7.0   *         39.0   306.0 214 38 20   0 25     0   9   179 127     7       39   306
1155080 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104002788 225 LINCOLN PARK MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 86.0 6.0 4.0   10.0 1.0     0.0   9.0   59.0 57.0     0.0   3.0     77.0   14.0   116.0 86 6 4   10 1     0   9   59 57     0 3   77 14   116
1155113 MN Hennepin 27 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137002844 340 ROGERS MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 330.0 7.0 13.0   0.0 10.0     0.0   9.0   190.0 179.0     17.0   0.0     65.0   37.0   369.0 330 7 13   0 10     0   9   190 179     17 0   65 37   369
1155121 MN Sherburne 71 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137000517 400 VANDENBERGE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 168.0 2.0 9.0   2.0 3.0     0.0   9.0   95.0 98.0     5.0   0.0         25.0   193.0 168 2 9   2 3     0   9   95 98     5 0     25   193
1155202 MN Wright 86 school 2733790 885 Independent Districts and Schools ST. MICHAEL-ALBERTVILLE SCHOOL DIST 273379001536 30 ST. MICHAEL-ALBERTVILLE MIDDLE EAST Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 222.0 5.0 1.0   0.0 2.0     0.0   9.0   124.0 115.0     3.0   0.0     22.0   23.0   239.0 222 5 1   0 2     0   9   124 115     3 0   22 23   239
1155211 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741003671 301 CAMBRIDGE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 185.0 4.0 3.0   2.0 2.0     0.0   9.0   98.0 107.0     2.0   0.0     70.0   28.0   205.0 185 4 3   2 2     0   9   98 107     2 0   70 28   205
1155430 MN Ramsey 62 school 2700376 4210 Charter Schools Upper Mississippi Academy 270037604693 20 Upper Mississippi Middle Academy Middle School (Grades 5-8) Regular School Yes 2 06 08 2015   grade_7 91.0 13.0 14.0   0.0 1.0     0.0   9.0   88.0 40.0         *         *   128.0 91 13 14   0 1     0   9   88 40                 128
1159105 MN Steele 74 school 2728050 761 Independent Districts and Schools OWATONNA PUBLIC SCHOOL DISTRICT 272805001227 151 OWATONNA JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No 2 07 08 2015   grade_7 244.0 20.0 51.0   1.0 2.0     0.0   9.0   164.0 163.0     31.0   *     148.0   47.0   327.0 244 20 51   1 2     0   9   164 163     31     148 47   327
1826220 MN Saint Louis 69 school 2700008 2142 Independent Districts and Schools St. Louis County School District 270000804459 55 North Woods Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 35.0 0.0 0.0   12.0 0.0     0.0   9.0   32.0 24.0     0.0   0.0     30.0   15.0   56.0 35 0 0   12 0     0   9   32 24     0 0   30 15   56
1830558 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 2020   grade_7 2.0 10.0 14.0   11.0 21.0     0.0   9.0   33.0 34.0     16.0   2.0     58.0   16.0   67.0 2 10 14   11 21     0   9   33 34     16 2   58 16   67
1834291 MN Cottonwood 17 school 2742780 177 Independent Districts and Schools Windom Public School District 274278003068 60 Windom Middle Middle School (Grades 5-8) Regular School No Middle 04 08 2020   grade_7 52.0 4.0 26.0   1.0 2.0     2.0   9.0   54.0 42.0     7.0   0.0     50.0   19.0   96.0 52 4 26   1 2     2   9   54 42     7 0   50 19   96
1834381 MN Dodge 20 school 2716980 204 Independent Districts and Schools Kasson-Mantorville School District 271698002243 40 Kasson-Mantorville Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_7 148.0 2.0 10.0   0.0 1.0     0.0   9.0   87.0 83.0     2.0   1.0     32.0   21.0   170.0 148 2 10   0 1     0   9   87 83     2 1   32 21   170
1834866 MN Washington 82 school 2738190 834 Independent Districts and Schools Stillwater Area Public School Dist. 273819001660 48 Oak-Land Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 234.0 25.0 31.0   0.0 26.0     0.0   9.0   160.0 165.0     10.0   *     68.0   39.0   325.0 234 25 31   0 26     0   9   160 165     10     68 39   325
1880129 MN Itasca 31 school 2723310 319 Independent Districts and Schools Nashwauk-Keewatin School District 272331001138 50 Nashwauk Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 38.0 0.0 0.0   0.0 0.0     0.0   9.0   26.0 21.0     0.0   0.0     24.0   17.0   47.0 38 0 0   0 0     0   9   26 21     0 0   24 17   47
1880800 MN Saint Louis 69 school 2700008 2142 Independent Districts and Schools St. Louis County School District 270000804544 45 South Ridge Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 33.0 0.0 0.0   4.0 0.0     0.0   9.0   23.0 23.0     0.0   1.0     20.0   6.0   46.0 33 0 0   4 0     0   9   23 23     0 1   20 6   46
1888701 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools Mankato Public School District 271878002045 200 Prairie Winds Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 234.0 46.0 20.0   1.0 10.0     0.0   9.0   162.0 158.0     *   7.0     117.0   49.0   320.0 234 46 20   1 10     0   9   162 158       7   117 49   320
1888856 MN Dakota 19 school 2713530 200 Independent Districts and Schools Hastings Public School District 271353000693 130 Hastings Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_7 284.0 5.0 11.0   1.0 1.0     0.0   9.0   170.0 141.0     *   *     *   *   311.0 284 5 11   1 1     0   9   170 141                 311
1889037 MN Mille Lacs 48 school 2730030 477 Independent Districts and Schools Princeton Public School District 273003001272 20 Princeton Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 240.0 0.0 5.0   1.0 0.0     0.0   9.0   148.0 107.0     *   *     *   *   255.0 240 0 5   1 0     0   9   148 107                 255
1889049 MN Morrison 49 school 2718240 482 Independent Districts and Schools Little Falls Public School District 271824000963 200 Community Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 164.0 10.0 5.0   0.0 2.0     0.0   9.0   98.0 92.0     1.0   0.0     85.0   38.0   190.0 164 10 5   0 2     0   9   98 92     1 0   85 38   190
1889112 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180002449 340 Friedell Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 101.0 8.0 11.0   1.0 23.0     0.0   9.0   74.0 79.0     3.0   0.0     21.0   18.0   153.0 101 8 11   1 23     0   9   74 79     3 0   21 18   153
1889252 MN Sherburne 71 school 2711370 728 Independent Districts and Schools Elk River Public School District 271137003360 350 Zimmerman Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 161.0 1.0 7.0   2.0 1.0     0.0   9.0   90.0 91.0     *   0.0     42.0   25.0   181.0 161 1 7   2 1     0   9   90 91       0   42 25   181
1893517 MN Washington 82 school 2712270 831 Independent Districts and Schools Forest Lake Public School District 271227000600 116 Southwest Junior High Junior High School (Grades 7-8 or 7-9) Regular School No Middle 07 09 2018   grade_7 171.0 1.0 8.0   2.0 7.0     0.0   9.0   95.0 103.0     5.0   0.0     34.0   20.0   198.0 171 1 8   2 7     0   9   95 103     5 0   34 20   198
1944664 MN Itasca 31 school 2710140 317 Independent Districts and Schools DEER RIVER PUBLIC SCHOOL DISTRICT 271014000433 1 DEER RIVER SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_7 38.0 1.0 3.0   27.0 0.0     0.0   9.0   40.0 38.0     0.0   4.0     58.0   16.0   78.0 38 1 3   27 0     0   9   40 38     0 4   58 16   78
1945005 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004680 211 Creative Arts Secondary School Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_7 12.0 37.0 12.0   1.0 19.0     0.0   9.0   31.0 59.0     16.0   5.0     70.0   12.0   90.0 12 37 12   1 19     0   9   31 59     16 5   70 12   90
1945021 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004443 250 OPEN WORLD LEARNING SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_7 39.0 5.0 12.0   0.0 6.0     0.0   9.0   35.0 36.0     3.0   1.0     20.0   14.0   71.0 39 5 12   0 6     0   9   35 36     3 1   20 14   71
1949587 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 Middle 05 08 2019   grade_7 37.0 45.0 9.0   1.0 24.0     0.0   9.0   58.0 67.0     32.0   2.0     79.0   28.0   125.0 37 45 9   1 24     0   9   58 67     32 2   79 28   125
1949671 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 2019   grade_7 5.0 14.0 10.0   21.0 19.0     0.0   9.0   40.0 38.0     17.0   4.0     63.0   16.0   78.0 5 14 10   21 19     0   9   40 38     17 4   63 16   78
1953315 MN Carver 10 school 2741460 110 Independent Districts and Schools WACONIA PUBLIC SCHOOL DISTRICT 274146003066 220 Waconia Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 296.0 5.0 10.0   2.0 3.0     0.0   9.0   172.0 153.0     0.0   0.0     32.0   42.0   325.0 296 5 10   2 3     0   9   172 153     0 0   32 42   325
1953324 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819000345 61 CHASKA MIDDLE SCHOOL EAST Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 181.0 5.0 5.0   0.0 6.0     0.0   9.0   104.0 102.0     2.0   1.0     16.0   17.0   206.0 181 5 5   0 6     0   9   104 102     2 1   16 17   206
1953516 MN Hennepin 27 school 2725080 278 Independent Districts and Schools ORONO PUBLIC SCHOOL DISTRICT 272508001199 31 ORONO MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 213.0 2.0 6.0   0.0 1.0     0.0   9.0   126.0 105.0     2.0   0.0     18.0   32.0   231.0 213 2 6   0 1     0   9   126 105     2 0   18 32   231
1953560 MN Hennepin 27 school 2742160 284 Independent Districts and Schools WAYZATA PUBLIC SCHOOL DISTRICT 274216001764 51 WAYZATA WEST MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 173.0 11.0 12.0   0.0 36.0     0.0   9.0   109.0 132.0     *   *     26.0   20.0   241.0 173 11 12   0 36     0   9   109 132           26 20   241
1953572 MN Hennepin 27 school 2706240 286 Independent Districts and Schools BROOKLYN CENTER SCHOOL DISTRICT 270624005130 11 Brooklyn Center Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 18.0 59.0 46.0   0.0 20.0     0.0   9.0   86.0 66.0     *   *         *   152.0 18 59 46   0 20     0   9   86 66                 152
1953605 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools WILLMAR PUBLIC SCHOOL DISTRICT 274272001808 301 WILLMAR MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 127.0 47.0 117.0   3.0 4.0     1.0   9.0   158.0 150.0     *   0.0         *   308.0 127 47 117   3 4     1   9   158 150       0         308
1953610 MN Lyon 42 school 2718940 413 Independent Districts and Schools MARSHALL PUBLIC SCHOOL DISTRICT 271894003715 6 MARSHALL MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_7 121.0 12.0 17.0   0.0 16.0     0.0   9.0   88.0 87.0     *   *         *   175.0 121 12 17   0 16     0   9   88 87                 175
1953714 MN Otter Tail 56 school 2711880 544 Independent Districts and Schools FERGUS FALLS PUBLIC SCHOOL DISTRICT 271188004944 380 Kennedy Middle School Middle School (Grades 5-8) Regular School No Middle 04 08 2019   grade_7 162.0 7.0 9.0   2.0 0.0     0.0   9.0   100.0 89.0     *   0.0         22.0   189.0 162 7 9   2 0     0   9   100 89       0     22   189
1953783 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004681 344 Parkway Montessori/Community Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 19.0 41.0 19.0   4.0 59.0     0.0   9.0   80.0 71.0     21.0   2.0     113.0   37.0   151.0 19 41 19   4 59     0   9   80 71     21 2   113 37   151
1953787 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001621 345 RAMSEY MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 45.0 85.0 9.0   3.0 21.0     0.0   9.0   96.0 76.0     20.0   6.0     116.0   21.0   172.0 45 85 9   3 21     0   9   96 76     20 6   116 21   172
1953936 MN Winona 85 school 2744070 861 Independent Districts and Schools WINONA AREA PUBLIC SCHOOL DISTRICT 274407001830 6 WINONA MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_7 159.0 16.0 14.0   1.0 8.0     0.0   9.0   88.0 119.0     9.0   0.0     81.0   32.0   207.0 159 16 14   1 8     0   9   88 119     9 0   81 32   207
1954084 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000937 309 ANWATIN MIDDLE COM & SPANISH D I Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 27.0 70.0 67.0   6.0 10.0     1.0   9.0   86.0 104.0     37.0   1.0     135.0   25.0   190.0 27 70 67   6 10     1   9   86 104     37 1   135 25   190
1955693 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104002237 611 DULUTH AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2019   grade_7 42.0 8.0 3.0   2.0 0.0     0.0   9.0   40.0 24.0     0.0   2.0     49.0   47.0   64.0 42 8 3   2 0     0   9   40 24     0 2   49 47   64
1957375 MN Houston 28 school 2714280 294 Independent Districts and Schools HOUSTON PUBLIC SCHOOL DISTRICT 271428003187 12 MINNESOTA VIRTUAL ACADEMY Distance Learning Program OLL (State approved) Regular School No Other KG 12 2019   grade_7 81.0 19.0 10.0   2.0 3.0     1.0   9.0   59.0 66.0     1.0   1.0     32.0   23.0   125.0 81 19 10   2 3     1   9   59 66     1 1   32 23   125
853725 MN Itasca 31 school 2710140 317 Independent Districts and Schools DEER RIVER PUBLIC SCHOOL DISTRICT 271014000433 1 DEER RIVER SECONDARY Secondary School (Grades 7-12) Regular School No 4 06 12 2016   grade_7 32 0 2   22 0     0   9   33 32     0.0   *     48.0   15.0   65 32 0 2   22 0     0   9   33 32     0     48 15   65
854074 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004680 211 Creative Arts Secondary School Secondary School (Grades 7-12) Regular School No 4 06 12 2016   grade_7 10 22 18   2 29     0   9   42 48     29.0   1.0     76.0   9.0   90 10 22 18   2 29     0   9   42 48     29 1   76 9   90
862039 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778002984 105 CENTURY MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 252 7 4   1 17     1   9   141 150         0.0     19.0   32.0   291 252 7 4   1 17     1   9   141 150       0   19 32   291
862069 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227002646 52 FRIENDLY HILLS MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2016   grade_7 113 15 34   0 6     0   9   93 84     14.0   *     58.0   23.0   177 113 15 34   0 6     0   9   93 84     14     58 23   177
862193 MN Hennepin 27 school 2742160 284 Independent Districts and Schools WAYZATA PUBLIC SCHOOL DISTRICT 274216001762 52 WAYZATA EAST MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 161 10 12   0 37     0   9   130 99     8.0   1.0     27.0   21.0   229 161 10 12   0 37     0   9   130 99     8 1   27 21   229
862317 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180001019 330 WILLOW CREEK MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 181 38 50   1 15     0   9   146 148     42.0   2.0     130.0   58.0   294 181 38 50   1 15     0   9   146 148     42 2   130 58   294
862377 MN Ramsey 62 school 2742360 624 Independent Districts and Schools WHITE BEAR LAKE SCHOOL DISTRICT 274236001049 59 SUNRISE PARK MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 194 31 23   4 34     2   9   155 142         *         *   297 194 31 23   4 34     2   9   155 142                 297
862381 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001556 310 BATTLE CREEK MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 24 82 35   3 104     0   9   151 106     107.0   13.0     228.0   46.0   257 24 82 35   3 104     0   9   151 106     107 13   228 46   257
862394 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001969 342 MURRAY MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 84 58 22   9 34     0   9   105 111     43.0   9.0     121.0   37.0   216 84 58 22   9 34     0   9   105 111     43 9   121 37   216
1712286 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384004680 211 Creative Arts Secondary School Secondary School (Grades 7-12) Regular School No High 06 12 2021   grade_7 9 35 8   0 17     0   9   25 53     14.0   0.0     61.0   14.0   78 9 35 8   0 17     0   9   25 53     14 0   61 14   78
1712302 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384004443 250 Open World Learning Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2021   grade_7 37 5 15   0 4     0   9   32 38     *   0.0     23.0   8.0   70 37 5 15   0 4     0   9   32 38       0   23 8   70
1712563 MN Wright 86 school 2710170 879 Independent Districts and Schools Delano Public School District 271017000438 20 Delano High School Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 200 1 8   0 0     0   9   114 104     3.0   0.0     16.0   23.0   218 200 1 8   0 0     0   9   114 104     3 0   16 23   218
1713076 MN Ramsey 62 school 2700337 4098 Charter Schools Nova Classical Academy 270033704356 20 NOVA CLASSICAL ACADEMY UPPER SCHOOL Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_7 49 7 9   0 10     0   9   44 40     5.0   0.0     4.0   8.0   84 49 7 9   0 10     0   9   44 40     5 0   4 8   84
1713112 MN Ramsey 62 school 2700246 4132 Charter Schools Twin Cities Academy 270024603307 10 Twin Cities Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_7 22 28 27   0 20     0   9   52 54     18.0   2.0     61.0   16.0   106 22 28 27   0 20     0   9   52 54     18 2   61 16   106
1716537 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 2021   grade_7 44 20 5   1 6     0   9   45 40     6.0   0.0     21.0   11.0   85 44 20 5   1 6     0   9   45 40     6 0   21 11   85
1716923 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001612 528 Global Arts Plus Upper Elementary School (Grades PK-6) Regular School No Middle 05 08 2021   grade_7 47 40 26   2 16     0   9   67 73     31.0   2.0     77.0   27.0   140 47 40 26   2 16     0   9   67 73     31 2   77 27   140
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
1719928 MN Ramsey 62 school 2700262 4152 Charter Schools Twin Cities German Immersion Charter School 270026203578 10 Twin Cities German Immersion Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 32 4 4   0 4     0   9   21 32     1.0   0.0     2.0   13.0   53 32 4 4   0 4     0   9   21 32     1 0   2 13   53
1720732 MN Carver 10 school 2741460 110 Independent Districts and Schools Waconia Public School District 274146003066 220 Waconia Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 277 5 14   1 2     0   9   160 148     2.0   1.0     13.0   46.0   308 277 5 14   1 2     0   9   160 148     2 1   13 46   308
1721018 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools Willmar Public School District 274272001808 301 Willmar Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 101 56 109   2 7     2   9   151 135     *   *     *   *   286 101 56 109   2 7     2   9   151 135                 286
1721023 MN Lyon 42 school 2718940 413 Independent Districts and Schools Marshall Public School District 271894003715 6 Marshall Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 105 16 28   3 15     1   9   91 86     17.0   2.0     68.0   26.0   177 105 16 28   3 15     1   9   91 86     17 2   68 26   177
1721032 MN Mcleod 43 school 2714970 423 Independent Districts and Schools Hutchinson Public School District 271497000755 20 Hutchinson Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 160 1 21   0 6     0   9   110 87     *   *     43.0   *   197 160 1 21   0 6     0   9   110 87           43     197
1721058 MN Morrison 49 school 2718240 482 Independent Districts and Schools Little Falls Public School District 271824000963 200 Community Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 162 3 2   0 0     0   9   87 89     0.0   0.0     68.0   25.0   176 162 3 2   0 0     0   9   87 89     0 0   68 25   176
1721135 MN Otter Tail 56 school 2728230 549 Independent Districts and Schools Perham-Dent Public School District 272823002535 20 Prairie Wind Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 109 3 12   1 0     0   9   75 59     *   *     *   *   134 109 3 12   1 0     0   9   75 59                 134
1721187 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001567 315 Farnsworth Aerospace Upper Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 9 41 12   2 81     0   9   76 78     45.0   4.0     120.0   28.0   154 9 41 12   2 81     0   9   76 78     45 4   120 28   154
1721210 MN Rice 66 school 2711760 656 Independent Districts and Schools Faribault Public School District 271176000557 70 Faribault Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 114 57 80   0 3     0   9   149 114     34.0   1.0     170.0   42.0   263 114 57 80   0 3     0   9   149 114     34 1   170 42   263
1721227 MN Saint Louis 69 school 2730090 704 Independent Districts and Schools Proctor Public School District 273009001552 2 A.I. Jedlicka Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 147 1 5   1 1     0   9   99 65     0.0   0.0     37.0   28.0   164 147 1 5   1 1     0   9   99 65     0 0   37 28   164
1721240 MN Scott 70 school 2715750 717 Independent Districts and Schools Jordan Public School District 271575004144 128 Jordan Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 123 5 16   2 4     1   9   87 73     7.0   0.0     24.0   17.0   160 123 5 16   2 4     1   9   87 73     7 0   24 17   160
1721260 MN Scott 70 school 2723430 721 Independent Districts and Schools New Prague Area Schools 272343001145 111 New Prague Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 306 4 11   2 5     0   9   176 161     2.0   1.0     40.0   50.0   337 306 4 11   2 5     0   9   176 161     2 1   40 50   337
1721315 MN Steele 74 school 2728050 761 Independent Districts and Schools Owatonna Public School District 272805001227 151 Owatonna Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 270 28 56   2 3     0   9   178 190     8.0   0.0     144.0   52.0   368 270 28 56   2 3     0   9   178 190     8 0   144 52   368
1721362 MN Winona 85 school 2744070 861 Independent Districts and Schools Winona Area Public School District 274407001830 6 Winona Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 166 16 11   0 4     0   9   111 95     *   *     *   *   206 166 16 11   0 4     0   9   111 95                 206
1721393 MN Wright 86 school 2733790 885 Independent Districts and Schools St. Michael-Albertville School Dist 273379004346 90 St. Michael-Albertville Middle West Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 250 12 11   0 4     0   9   145 141     6.0   0.0     38.0   17.0   286 250 12 11   0 4     0   9   145 141     6 0   38 17   286
1721401 MN Isanti 30 school 2707410 911 Independent Districts and Schools Cambridge-Isanti Public School District 270741003629 302 Isanti Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 175 1 5   0 5     0   9   106 89     *   0.0     *   34.0   195 175 1 5   0 5     0   9   106 89       0     34   195
1721502 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000936 300 Anthony Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 136 50 19   0 8     0   9   116 106     23.0   0.0     79.0   30.0   222 136 50 19   0 8     0   9   116 106     23 0   79 30   222
689314 MN Itasca 31 school 2710140 317 Independent Districts and Schools DEER RIVER PUBLIC SCHOOL DISTRICT 271014000433 1 DEER RIVER SECONDARY Secondary School (Grades 7-12) Regular School No Other 06 12 2017   grade_7 40.0 0.0 2.0   22.0 0.0     0.0   8.0   37.0 35.0     0.0   0.0     55.0   21.0   72.0 40 0 2   22 0     0   8   37 35     0 0   55 21   72
689450 MN Mahnomen 44 school 2742120 435 Independent Districts and Schools WAUBUN-OGEMA-WHITE EARTH PUBLIC SCH 274212001756 30 WAUBUN SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 7.0 0.0 1.0   38.0 0.0     0.0   8.0   24.0 30.0     0.0   3.0     43.0   3.0   54.0 7 0 1   38 0     0   8   24 30     0 3   43 3   54
698078 MN Mille Lacs 48 school 2730030 477 Independent Districts and Schools PRINCETON PUBLIC SCHOOL DISTRICT 273003001272 20 Princeton Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 211.0 2.0 4.0   1.0 1.0     0.0   8.0   116.0 111.0         *         *   227.0 211 2 4   1 1     0   8   116 111                 227
698143 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180002449 340 FRIEDELL MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 101.0 22.0 7.0   0.0 20.0     0.0   8.0   84.0 74.0     10.0   *     31.0   14.0   158.0 101 22 7   0 20     0   8   84 74     10     31 14   158
698147 MN Otter Tail 56 school 2711880 544 Independent Districts and Schools FERGUS FALLS PUBLIC SCHOOL DISTRICT 271188004944 380 Kennedy Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 156.0 7.0 6.0   3.0 1.0     0.0   8.0   85.0 96.0     0.0   0.0     66.0   27.0   181.0 156 7 6   3 1     0   8   85 96     0 0   66 27   181
698405 MN Chisago 13 school 2700017 2144 Independent Districts and Schools CHISAGO LAKES SCHOOL DISTRICT 270001700351 3 CHISAGO LAKES MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 261.0 2.0 4.0   0.0 6.0     0.0   8.0   141.0 140.0         *         30.0   281.0 261 2 4   0 6     0   8   141 140             30   281
702579 MN Washington 82 school 2712270 831 Independent Districts and Schools FOREST LAKE PUBLIC SCHOOL DISTRICT 271227000600 116 Southwest Junior High Junior High School (Grades 7-8 or 7-9) Regular School No Other 07 09 2017   grade_7 186.0 3.0 8.0   2.0 6.0     0.0   8.0   110.0 103.0     3.0   0.0     41.0   27.0   213.0 186 3 8   2 6     0   8   110 103     3 0   41 27   213
1146656 MN Otter Tail 56 school 2711880 544 Independent Districts and Schools FERGUS FALLS PUBLIC SCHOOL DISTRICT 271188000578 390 KENNEDY SECONDARY SCHOOL Secondary School (Grades 7-12) Regular School No 4 06 12 2015   grade_7 149.0 2.0 3.0   1.0 0.0     0.0   8.0   88.0 75.0     1.0   0.0     61.0   30.0   163.0 149 2 3   1 0     0   8   88 75     1 0   61 30   163
1154599 MN Anoka 2 school 2733540 15 Independent Districts and Schools ST. FRANCIS PUBLIC SCHOOL DISTRICT 273354000013 123 ST. FRANCIS MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 335.0 0.0 7.0   2.0 8.0     0.0   8.0   184.0 176.0         *         *   360.0 335 0 7   2 8     0   8   184 176                 360
1154608 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023000443 4 DETROIT LAKES MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 179.0 2.0 2.0   27.0 3.0     0.0   8.0   116.0 105.0         *         *   221.0 179 2 2   27 3     0   8   116 105                 221

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