enrollments

Data source: Big Local News · About: Big Local

4,953 rows where grade = "grade_8" and state = "MN" sorted by multiracial descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_8 · 4,953 ✖
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
689315 689315 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_8 31.0 0.0 3.0   22.0 0.0     0.0   9.0   32.0 33.0     0.0   *     42.0   13.0   65.0 31 0 3   22 0     0   9   32 33     0     42 13   65
689687 689687 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004429 252 WASHINGTON TECH SECONDARY MAGNET Secondary School (Grades 7-12) Regular School No Other 06 12 2017   grade_8 18.0 86.0 37.0   1.0 201.0     0.0   9.0   184.0 168.0     179.0   3.0     315.0   41.0   352.0 18 86 37   1 201     0   9   184 168     179 3   315 41   352
697702 697702 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002501 193 OAK VIEW MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 363.0 10.0 18.0   4.0 15.0     0.0   9.0   211.0 208.0     6.0   *     57.0   *   419.0 363 10 18   4 15     0   9   211 208     6     57     419
697861 697861 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 Middle 06 08 2017   grade_8 257.0 7.0 5.0   1.0 17.0     1.0   9.0   145.0 152.0     5.0   0.0     23.0   26.0   297.0 257 7 5   1 17     1   9   145 152     5 0   23 26   297
697890 697890 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_8 110.0 19.0 35.0   0.0 6.0     0.0   9.0   92.0 87.0     11.0   4.0     51.0   23.0   179.0 110 19 35   0 6     0   9   92 87     11 4   51 23   179
697913 697913 MN Douglas 21 school 2703060 206 Independent Districts and Schools ALEXANDRIA PUBLIC SCHOOL DISTRICT 270306000083 310 Discovery Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 283.0 2.0 6.0   1.0 8.0     0.0   9.0   168.0 141.0     1.0   1.0     76.0   45.0   309.0 283 2 6   1 8     0   9   168 141     1 1   76 45   309
697933 697933 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000226 13 OAK GROVE MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 150.0 46.0 37.0   2.0 17.0     0.0   9.0   141.0 120.0     21.0   *     98.0   55.0   261.0 150 46 37   2 17     0   9   141 120     21     98 55   261
698014 698014 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 Middle 06 08 2017   grade_8 171.0 11.0 16.0   0.0 41.0     0.0   9.0   137.0 111.0     15.0   0.0     36.0   *   248.0 171 11 16   0 41     0   9   137 111     15 0   36     248
698200 698200 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 Middle 06 08 2017   grade_8 23.0 67.0 37.0   5.0 95.0     0.0   9.0   140.0 96.0     109.0   9.0     190.0   34.0   236.0 23 67 37   5 95     0   9   140 96     109 9   190 34   236
702580 702580 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_8 231.0 4.0 6.0   1.0 7.0     0.0   9.0   125.0 133.0     3.0   0.0     57.0   33.0   258.0 231 4 6   1 7     0   9   125 133     3 0   57 33   258
1154596 1154596 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242000610 23 FRIDLEY MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_8 102.0 49.0 26.0   6.0 23.0     0.0   9.0   109.0 106.0     31.0   2.0     135.0   28.0   215.0 102 49 26   6 23     0   9   109 106     31 2   135 28   215
1154713 1154713 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 2015   grade_8 257.0 5.0 11.0   0.0 20.0     0.0   9.0   157.0 145.0     4.0   0.0     22.0   28.0   302.0 257 5 11   0 20     0   9   157 145     4 0   22 28   302
1154717 1154717 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 2 06 08 2015   grade_8 297.0 16.0 24.0   0.0 43.0     0.0   9.0   192.0 197.0     7.0   2.0         49.0   389.0 297 16 24   0 43     0   9   192 197     7 2     49   389
1154733 1154733 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001943 93 SCOTT HIGHLANDS MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_8 238.0 30.0 17.0   1.0 25.0     1.0   9.0   171.0 150.0     7.0   1.0     71.0   52.0   321.0 238 30 17   1 25     1   9   171 150     7 1   71 52   321
1154756 1154756 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 2 05 08 2015   grade_8 302.0 7.0 15.0   2.0 4.0     0.0   9.0   166.0 173.0         *         *   339.0 302 7 15   2 4     0   9   166 173                 339
1154850 1154850 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 2015   grade_8 168.0 19.0 7.0   0.0 47.0     0.0   9.0   127.0 123.0         2.0     25.0   *   250.0 168 19 7   0 47     0   9   127 123       2   25     250
1154873 1154873 MN Itasca 31 school 2709480 316 Independent Districts and Schools GREENWAY PUBLIC SCHOOL DISTRICT 270948002785 210 GREENWAY MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_8 69.0 0.0 1.0   1.0 0.0     0.0   9.0   45.0 35.0     0.0   0.0     44.0   18.0   80.0 69 0 1   1 0     0   9   45 35     0 0   44 18   80
1154927 1154927 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345000150 300 ELLIS MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_8 217.0 16.0 81.0   0.0 9.0     1.0   9.0   182.0 151.0     31.0   3.0     187.0   *   333.0 217 16 81   0 9     1   9   182 151     31 3   187     333
1154974 1154974 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 2015   grade_8 210.0 41.0 50.0   0.0 28.0     0.0   9.0   179.0 159.0     30.0   7.0     143.0   46.0   338.0 210 41 50   0 28     0   9   179 159     30 7   143 46   338
1154978 1154978 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180001020 335 KELLOGG MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_8 196.0 36.0 11.0   1.0 22.0     0.0   9.0   119.0 156.0     24.0   4.0     106.0   34.0   275.0 196 36 11   1 22     0   9   119 156     24 4   106 34   275
1155026 1155026 MN Ramsey 62 school 2742360 624 Independent Districts and Schools WHITE BEAR LAKE SCHOOL DISTRICT 274236001787 57 CENTRAL MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_8 295.0 12.0 13.0   3.0 12.0     0.0   9.0   181.0 163.0         *         *   344.0 295 12 13   3 12     0   9   181 163                 344
1155114 1155114 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_8 330.0 7.0 12.0   2.0 11.0     0.0   9.0   202.0 169.0     21.0   *     49.0   34.0   371.0 330 7 12   2 11     0   9   202 169     21     49 34   371
1155164 1155164 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 2 06 08 2015   grade_8 153.0 29.0 28.0   1.0 24.0     0.0   9.0   121.0 123.0     20.0   2.0     103.0   35.0   244.0 153 29 28   1 24     0   9   121 123     20 2   103 35   244
1155208 1155208 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 2 05 08 2015   grade_8 178.0 6.0 7.0   0.0 2.0     1.0   9.0   104.0 99.0     9.0   0.0     33.0   11.0   203.0 178 6 7   0 2     1   9   104 99     9 0   33 11   203
1826142 1826142 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 2020   grade_8 179.0 0.0 3.0   0.0 0.0     0.0   9.0   95.0 96.0     1.0   0.0     20.0   22.0   191.0 179 0 3   0 0     0   9   95 96     1 0   20 22   191
1826221 1826221 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_8 27.0 0.0 1.0   13.0 0.0     0.0   9.0   20.0 30.0     0.0   0.0     31.0   14.0   50.0 27 0 1   13 0     0   9   20 30     0 0   31 14   50
1834240 1834240 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 2020   grade_8 290.0 6.0 13.0   1.0 3.0     0.0   9.0   171.0 151.0     2.0   0.0     26.0   40.0   322.0 290 6 13   1 3     0   9   171 151     2 0   26 40   322
1834249 1834249 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 2020   grade_8 184.0 6.0 6.0   0.0 6.0     0.0   9.0   112.0 99.0     1.0   1.0     15.0   15.0   211.0 184 6 6   0 6     0   9   112 99     1 1   15 15   211
1834253 1834253 MN Carver 10 school 2708190 112 Independent Districts and Schools Eastern Carver County Public School 270819002798 62 Chaska Middle School West Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_8 176.0 7.0 19.0   0.0 9.0     1.0   9.0   119.0 102.0     2.0   0.0     26.0   16.0   221.0 176 7 19   0 9     1   9   119 102     2 0   26 16   221
1834441 1834441 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 2020   grade_8 219.0 1.0 5.0   0.0 3.0     0.0   9.0   124.0 113.0     2.0   0.0     18.0   33.0   237.0 219 1 5   0 3     0   9   124 113     2 0   18 33   237
1834497 1834497 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 2020   grade_8 8.0 63.0 45.0   1.0 22.0     0.0   9.0   84.0 64.0     29.0   3.0         22.0   148.0 8 63 45   1 22     0   9   84 64     29 3     22   148
1834539 1834539 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 2020   grade_8 122.0 17.0 23.0   2.0 18.0     0.0   9.0   95.0 96.0     23.0   1.0     85.0   22.0   191.0 122 17 23   2 18     0   9   95 96     23 1   85 22   191
1834562 1834562 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 2020   grade_8 237.0 1.0 9.0   0.0 3.0     0.0   9.0   117.0 142.0     *   *         *   259.0 237 1 9   0 3     0   9   117 142                 259
1834704 1834704 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 2020   grade_8 9.0 34.0 11.0   2.0 102.0     0.0   9.0   99.0 68.0     47.0   1.0     123.0   26.0   167.0 9 34 11   2 102     0   9   99 68     47 1   123 26   167
1834895 1834895 MN Wright 86 school 2721390 882 Independent Districts and Schools Monticello Public School District 272139002209 30 Monticello Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_8 304.0 8.0 40.0   0.0 1.0     0.0   9.0   181.0 181.0     12.0   4.0     74.0   44.0   362.0 304 8 40   0 1     0   9   181 181     12 4   74 44   362
1835031 1835031 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 2020   grade_8 28.0 68.0 66.0   5.0 9.0     0.0   9.0   84.0 101.0     31.0   3.0     118.0   26.0   185.0 28 68 66   5 9     0   9   84 101     31 3   118 26   185
1835144 1835144 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 Middle 06 08 2020   grade_8 49.0 6.0 12.0   0.0 2.0     0.0   9.0   46.0 32.0     0.0   0.0     14.0   25.0   78.0 49 6 12   0 2     0   9   46 32     0 0   14 25   78
1836640 1836640 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 2020   grade_8 51.0 10.0 4.0   1.0 1.0     0.0   9.0   46.0 30.0     1.0   0.0     41.0   36.0   76.0 51 10 4   1 1     0   9   46 30     1 0   41 36   76
1880116 1880116 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 2018   grade_8 39.0 0.0 1.0   20.0 0.0     0.0   9.0   34.0 35.0     0.0   0.0     45.0   15.0   69.0 39 0 1   20 0     0   9   34 35     0 0   45 15   69
1888969 1888969 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 Middle 06 08 2018   grade_8 142.0 12.0 7.0   0.0 51.0     0.0   9.0   116.0 105.0     6.0   0.0     18.0   15.0   221.0 142 12 7   0 51     0   9   116 105     6 0   18 15   221
1889057 1889057 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345000150 300 Ellis Middle Middle School (Grades 5-8) Regular School No Middle 07 08 2018   grade_8 194.0 29.0 89.0   0.0 25.0     1.0   9.0   173.0 174.0     *   *     187.0   *   347.0 194 29 89   0 25     1   9   173 174           187     347
1889118 1889118 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 05 08 2018   grade_8 159.0 3.0 6.0   3.0 2.0     0.0   9.0   87.0 95.0     2.0   0.0     66.0   26.0   182.0 159 3 6   3 2     0   9   87 95     2 0   66 26   182
1889183 1889183 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 Middle 06 08 2018   grade_8 74.0 99.0 20.0   4.0 30.0     0.0   9.0   137.0 99.0     34.0   6.0     151.0   39.0   236.0 74 99 20   4 30     0   9   137 99     34 6   151 39   236
1889261 1889261 MN Sherburne 71 school 2711370 728 Independent Districts and Schools Elk River Public School District 271137002038 410 Salk Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_8 213.0 19.0 4.0   2.0 7.0     0.0   9.0   138.0 116.0     0.0   0.0     52.0   28.0   254.0 213 19 4   2 7     0   9   138 116     0 0   52 28   254
1889364 1889364 MN Wright 86 school 2733790 885 Independent Districts and Schools St. Michael-Albertville School District 273379004346 90 St. Michael-Albertville Middle West Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_8 234.0 10.0 8.0   0.0 3.0     0.0   9.0   136.0 128.0     3.0   0.0     39.0   26.0   264.0 234 10 8   0 3     0   9   136 128     3 0   39 26   264
1944679 1944679 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 2019   grade_8 40.0 1.0 0.0   0.0 0.0     0.0   9.0   28.0 22.0     0.0   2.0     26.0   18.0   50.0 40 1 0   0 0     0   9   28 22     0 2   26 18   50
1944977 1944977 MN Polk 60 school 2709720 593 Independent Districts and Schools CROOKSTON PUBLIC SCHOOL DISTRICT 270972000412 90 CROOKSTON SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_8 70.0 3.0 22.0   3.0 0.0     0.0   9.0   53.0 54.0     4.0   8.0     54.0   24.0   107.0 70 3 22   3 0     0   9   53 54     4 8   54 24   107
1953329 1953329 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819002798 62 CHASKA MIDDLE SCHOOL WEST Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_8 148.0 4.0 10.0   0.0 13.0     0.0   9.0   101.0 83.0     1.0   0.0     17.0   14.0   184.0 148 4 10   0 13     0   9   101 83     1 0   17 14   184
1953394 1953394 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182000570 30 LEVI P. DODGE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_8 197.0 7.0 17.0   2.0 6.0     0.0   9.0   124.0 114.0     6.0   *         *   238.0 197 7 17   2 6     0   9   124 114     6           238
1953517 1953517 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_8 213.0 5.0 6.0   0.0 4.0     0.0   9.0   130.0 107.0     1.0   0.0     15.0   37.0   237.0 213 5 6   0 4     0   9   130 107     1 0   15 37   237
1953529 1953529 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001214 86 North View Middle School, an IB World School Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_8 8.0 91.0 41.0   4.0 43.0     0.0   9.0   109.0 87.0     48.0   9.0     161.0   31.0   196.0 8 91 41   4 43     0   9   109 87     48 9   161 31   196
1953634 1953634 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 2019   grade_8 241.0 0.0 6.0   1.0 0.0     0.0   9.0   146.0 111.0     *   *         *   257.0 241 0 6   1 0     0   9   146 111                 257
1953767 1953767 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 Middle 06 08 2019   grade_8 15.0 81.0 39.0   2.0 90.0     0.0   9.0   129.0 107.0     83.0   5.0     176.0   39.0   236.0 15 81 39   2 90     0   9   129 107     83 5   176 39   236
1953772 1953772 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 2019   grade_8 10.0 35.0 18.0   1.0 109.0     0.0   9.0   90.0 92.0     46.0   2.0     144.0   23.0   182.0 10 35 18   1 109     0   9   90 92     46 2   144 23   182
1953776 1953776 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001591 330 HIGHLAND PARK MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_8 110.0 45.0 77.0   2.0 9.0     0.0   9.0   132.0 120.0     22.0   3.0     119.0   29.0   252.0 110 45 77   2 9     0   9   132 120     22 3   119 29   252
1953963 1953963 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 Middle 05 08 2019   grade_8 222.0 6.0 8.0   0.0 6.0     0.0   9.0   133.0 118.0     1.0   1.0     25.0   20.0   251.0 222 6 8   0 6     0   9   133 118     1 1   25 20   251
1953972 1953972 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 2019   grade_8 200.0 2.0 2.0   4.0 3.0     0.0   9.0   110.0 110.0     *   0.0     70.0   25.0   220.0 200 2 2   4 3     0   9   110 110       0   70 25   220
1955413 1955413 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819004622 66 112 ALC MIDDLE SCHOOL Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2019   grade_8 83.0 16.0 33.0   3.0 6.0     0.0   9.0   76.0 74.0     16.0   0.0     55.0   37.0   150.0 83 16 33   3 6     0   9   76 74     16 0   55 37   150
853655 853655 MN Goodhue 25 school 2730480 256 Independent Districts and Schools RED WING PUBLIC SCHOOL DISTRICT 273048001293 108 RED WING SENIOR HIGH Secondary School (Grades 7-12) Regular School No 3 08 12 2016   grade_8 149 9 19   11 8     0   9   111 94     4.0   0.0     70.0   31.0   205 149 9 19   11 8     0   9   111 94     4 0   70 31   205
861889 861889 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 2016   grade_8 262 52 24   7 21     0   9   192 183     19.0   4.0     175.0   43.0   375 262 52 24   7 21     0   9   192 183     19 4   175 43   375
861913 861913 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951000395 17 COLUMBIA ACADEMY Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_8 57 79 77   4 11     0   9   111 126     42.0   6.0     191.0   45.0   237 57 79 77   4 11     0   9   111 126     42 6   191 45   237
862061 862061 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001943 93 SCOTT HIGHLANDS MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_8 208 34 21   0 35     0   9   140 167         0.0     72.0   52.0   307 208 34 21   0 35     0   9   140 167       0   72 52   307
862084 862084 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 2 05 08 2016   grade_8 314 6 16   3 3     0   9   169 182     5.0   0.0     66.0   39.0   351 314 6 16   3 3     0   9   169 182     5 0   66 39   351
862121 862121 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 2016   grade_8 216 36 19   0 23     0   9   174 129         1.0         40.0   303 216 36 19   0 23     0   9   174 129       1     40   303
862259 862259 MN Mille Lacs 48 school 2730030 477 Independent Districts and Schools PRINCETON PUBLIC SCHOOL DISTRICT 273003001272 20 PRINCETON MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_8 241 0 7   2 1     0   9   139 121     1.0   2.0     82.0   26.0   260 241 0 7   2 1     0   9   139 121     1 2   82 26   260
862503 862503 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381002465 20 COTTAGE GROVE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_8 279 25 33   1 42     0   9   210 179     13.0   4.0     92.0   53.0   389 279 25 33   1 42     0   9   210 179     13 4   92 53   389
862559 862559 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 2016   grade_8 193 6 3   2 1     0   9   106 108         3.0     74.0   28.0   214 193 6 3   2 1     0   9   106 108       3   74 28   214
866690 866690 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426000616 380 HOPKINS WEST JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No 2 07 09 2016   grade_8 167 44 9   1 13     1   9   119 125     2.0   1.0     93.0   40.0   244 167 44 9   1 13     1   9   119 125     2 1   93 40   244
866699 866699 MN Scott 70 school 2733000 720 Independent Districts and Schools SHAKOPEE PUBLIC SCHOOL DISTRICT 273300001439 84 SHAKOPEE JUNIOR HIGH WEST Junior High School (Grades 7-8 or 7-9) Regular School No 2 07 09 2016   grade_8 183 20 40   3 46     0   9   149 152     28.0   0.0     97.0   33.0   301 183 20 40   3 46     0   9   149 152     28 0   97 33   301
1712287 1712287 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_8 11 24 13   0 15     0   9   28 44     10.0   0.0     56.0   14.0   72 11 24 13   0 15     0   9   28 44     10 0   56 14   72
1712303 1712303 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_8 43 3 14   1 6     0   9   45 31     *   0.0     21.0   8.0   76 43 3 14   1 6     0   9   45 31       0   21 8   76
1713105 1713105 MN Hennepin 27 school 2700364 4122 Charter Schools Eagle Ridge Academy Charter School 270036404108 10 Eagle Ridge Academy Charter School Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_8 56 19 3   1 21     0   9   55 54     9.0   0.0     26.0   8.0   109 56 19 3   1 21     0   9   55 54     9 0   26 8   109
1716538 1716538 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_8 56 9 4   0 7     0   9   49 36     1.0   0.0     19.0   16.0   85 56 9 4   0 7     0   9   49 36     1 0   19 16   85
1720816 1720816 MN Dakota 19 school 2717780 194 Independent Districts and Schools Lakeville Public School District 271778000483 104 Kenwood Trail Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_8 132 20 39   0 5     0   9   96 109     7.0   0.0     40.0   28.0   205 132 20 39   0 5     0   9   96 109     7 0   40 28   205
1721200 1721200 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 2021   grade_8 14 24 13   6 55     1   9   64 58     35.0   2.0     95.0   32.0   122 14 24 13   6 55     1   9   64 58     35 2   95 32   122
1721402 1721402 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_8 148 3 8   2 5     0   9   84 91     4.0   0.0     48.0   *   175 148 3 8   2 5     0   9   84 91     4 0   48     175
697719 697719 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242000610 23 FRIDLEY MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_8 88.0 76.0 29.0   3.0 21.0     0.0   8.0   110.0 115.0         4.0         29.0   225.0 88 76 29   3 21     0   8   110 115       4     29   225
697824 697824 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609004196 22 FORESTVIEW MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_8 443.0 10.0 7.0   10.0 4.0     0.0   8.0   243.0 239.0     0.0   1.0         *   482.0 443 10 7   10 4     0   8   243 239     0 1         482
697833 697833 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_8 78.0 19.0 18.0   1.0 8.0     0.0   8.0   71.0 61.0     13.0   2.0     47.0   21.0   132.0 78 19 18   1 8     0   8   71 61     13 2   47 21   132
697841 697841 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000297 85 Joseph Nicollet Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 54.0 24.0 16.0   0.0 12.0     2.0   8.0   53.0 63.0     5.0   3.0     49.0   10.0   116.0 54 24 16   0 12     2   8   53 63     5 3   49 10   116
698279 698279 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 Middle 06 08 2017   grade_8 332.0 13.0 10.0   0.0 13.0     0.0   8.0   194.0 182.0     12.0   *     52.0   46.0   376.0 332 13 10   0 13     0   8   194 182     12     52 46   376
698291 698291 MN Sherburne 71 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137002038 410 SALK MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 222.0 10.0 11.0   1.0 4.0     0.0   8.0   134.0 122.0     3.0   0.0     24.0   24.0   256.0 222 10 11   1 4     0   8   134 122     3 0   24 24   256
698373 698373 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 Middle 05 08 2017   grade_8 240.0 11.0 6.0   0.0 7.0     0.0   8.0   144.0 128.0     3.0   1.0     22.0   25.0   272.0 240 11 6   0 7     0   8   144 128     3 1   22 25   272
701792 701792 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 2017   grade_8 119.0 10.0 13.0   6.0 2.0     0.0   8.0   68.0 90.0     3.0   2.0     56.0   25.0   158.0 119 10 13   6 2     0   8   68 90     3 2   56 25   158
702584 702584 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_8 218.0 15.0 11.0   3.0 20.0     0.0   8.0   147.0 128.0         *         *   275.0 218 15 11   3 20     0   8   147 128                 275
1146545 1146545 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 3 07 12 2015   grade_8 8.0 0.0 0.0   31.0 0.0     0.0   8.0   30.0 17.0     0.0   2.0     30.0   4.0   47.0 8 0 0   31 0     0   8   30 17     0 2   30 4   47
1154587 1154587 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810002784 166 CENTENNIAL MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_8 418.0 9.0 25.0   4.0 22.0     0.0   8.0   247.0 239.0     3.0   2.0     99.0   83.0   486.0 418 9 25   4 22     0   8   247 239     3 2   99 83   486
1154591 1154591 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951000395 17 COLUMBIA ACADEMY Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_8 48.0 73.0 73.0   4.0 14.0     0.0   8.0   103.0 117.0     45.0   7.0         31.0   220.0 48 73 73   4 14     0   8   103 117     45 7     31   220
1154688 1154688 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609004196 22 FORESTVIEW MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_8 434.0 7.0 6.0   4.0 6.0     0.0   8.0   233.0 232.0     0.0   *         *   465.0 434 7 6   4 6     0   8   233 232     0           465
1154742 1154742 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 2015   grade_8 102.0 11.0 33.0   1.0 11.0     0.0   8.0   72.0 94.0     10.0   0.0     50.0   27.0   166.0 102 11 33   1 11     0   8   72 94     10 0   50 27   166
1154751 1154751 MN Dakota 19 school 2715030 199 Independent Districts and Schools INVER GROVE HEIGHTS SCHOOLS 271503000765 27 INVER GROVE HEIGHTS MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_8 182.0 35.0 68.0   4.0 9.0     0.0   8.0   163.0 143.0     26.0   0.0     117.0   38.0   306.0 182 35 68   4 9     0   8   163 143     26 0   117 38   306
1154914 1154914 MN Mille Lacs 48 school 2730030 477 Independent Districts and Schools PRINCETON PUBLIC SCHOOL DISTRICT 273003001272 20 PRINCETON MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_8 252.0 0.0 8.0   1.0 2.0     0.0   8.0   117.0 154.0     0.0   2.0     86.0   24.0   271.0 252 0 8   1 2     0   8   117 154     0 2   86 24   271
1155047 1155047 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 2015   grade_8 99.0 58.0 21.0   3.0 42.0     0.0   8.0   124.0 107.0     43.0   6.0     123.0   34.0   231.0 99 58 21   3 42     0   8   124 107     43 6   123 34   231
1155081 1155081 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_8 121.0 11.0 4.0   8.0 3.0     0.0   8.0   72.0 83.0     0.0   7.0     93.0   13.0   155.0 121 11 4   8 3     0   8   72 83     0 7   93 13   155
1155180 1155180 MN Wright 86 school 2703150 876 Independent Districts and Schools ANNANDALE PUBLIC SCHOOL DISTRICT 270315000093 2 ANNANDALE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_8 122.0 1.0 2.0   0.0 0.0     0.0   8.0   65.0 68.0     2.0   0.0     36.0   21.0   133.0 122 1 2   0 0     0   8   65 68     2 0   36 21   133
1155212 1155212 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_8 184.0 3.0 1.0   1.0 4.0     0.0   8.0   97.0 104.0     4.0   1.0     70.0   23.0   201.0 184 3 1   1 4     0   8   97 104     4 1   70 23   201
1155236 1155236 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 2 06 08 2015   grade_8 238.0 2.0 5.0   1.0 2.0     1.0   8.0   134.0 123.0         *         29.0   257.0 238 2 5   1 2     1   8   134 123             29   257
1825804 1825804 MN Pine 58 school 2728380 578 Independent Districts and Schools Pine City Public School District 272838001256 20 Pine City Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_8 114.0 0.0 4.0   1.0 0.0     0.0   8.0   61.0 66.0     0.0   0.0     45.0   13.0   127.0 114 0 4   1 0     0   8   61 66     0 0   45 13   127
1825925 1825925 MN Roseau 68 school 2741850 690 Independent Districts and Schools Warroad Public School District 274185001745 30 Warroad High School Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_8 65.0 0.0 2.0   4.0 3.0     0.0   8.0   39.0 43.0     1.0   0.0     23.0   11.0   82.0 65 0 2   4 3     0   8   39 43     1 0   23 11   82
1826163 1826163 MN Mille Lacs 48 school 2720670 912 Independent Districts and Schools Milaca Public School District 272067000924 30 Milaca Secondary High Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_8 121.0 0.0 4.0   0.0 0.0     0.0   8.0   79.0 54.0     0.0   1.0     56.0   24.0   133.0 121 0 4   0 0     0   8   79 54     0 1   56 24   133

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