Data source: Big Local News · About: Big Local

681 rows where grade = "grade_7", state = "MN" and year = 2019 sorted by county_state_id

View and edit SQL

year

  • 2019 · 681

grade

  • grade_7 · 681
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
1944368 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276000057 1 AITKIN SECONDARY SCHOOL Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 80.0 1.0 1.0   2.0 0.0     0.0   3.0   36.0 51.0     0.0   0.0     40.0   10.0   87.0 80 1 1   2 0     0   3   36 51     0 0   40 10   87
1944375 MN Aitkin 1 school 2719170 4 Independent Districts and Schools MCGREGOR PUBLIC SCHOOL DISTRICT 271917000904 40 MCGREGOR SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 22.0 0.0 1.0   6.0 0.0     0.0   0.0   14.0 15.0     0.0   0.0     14.0   9.0   29.0 22 0 1   6 0     0   0   14 15     0 0   14 9   29
1953226 MN Aitkin 1 school 2714010 2 Independent Districts and Schools HILL CITY PUBLIC SCHOOL DISTRICT 271401004653 2 Hill City Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_7 12.0 0.0 0.0   1.0 0.0     0.0   1.0   9.0 5.0     0.0   0.0     9.0   1.0   14.0 12 0 0   1 0     0   1   9 5     0 0   9 1   14
1958265 MN Aitkin 1 school 2700300 4177 Charter Schools MINISINAAKWAANG LEADERSHIP ACADEMY 270030003730 10 MINISINAAKWAANG LEADERSHIP ACADEMY Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2019   grade_7 0.0 0.0 0.0   2.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 0 0 0   2 0     0   0   1 1                 2
1944382 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333004658 788 Secondary Lighthouse Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 5.0 0.0 1.0   0.0 1.0     0.0   4.0   8.0 3.0     0.0   0.0     1.0   0.0   11.0 5 0 1   0 1     0   4   8 3     0 0   1 0   11
1945692 MN Anoka 2 school 2700093 4008 Charter Schools PACT CHARTER SCHOOL 270009303030 30 PACT CHARTER SECONDARY Secondary School (Grades 7-12) Regular School Yes High 07 12 2019   grade_7 46.0 3.0 3.0   0.0 0.0     0.0   2.0   20.0 34.0     5.0   0.0     10.0   8.0   54.0 46 3 3   0 0     0   2   20 34     5 0   10 8   54
1952739 MN Anoka 2 school 2700320 4185 Charter Schools DAVINCI ACADEMY 270032004268 10 DAVINCI ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_7 47.0 10.0 3.0   0.0 7.0     0.0   6.0   38.0 35.0     3.0   0.0     12.0   9.0   73.0 47 10 3   0 7     0   6   38 35     3 0   12 9   73
1952749 MN Anoka 2 school 2700313 4186 Charter Schools GLOBAL ACADEMY 270031304294 10 GLOBAL ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_7 8.0 38.0 0.0   0.0 0.0     0.0   1.0   29.0 18.0     7.0   0.0     38.0   11.0   47.0 8 38 0   0 0     0   1   29 18     7 0   38 11   47
1952943 MN Anoka 2 school 2700390 4224 Charter Schools Star of the North Academy Charter School 270039004759 10 Star of the North Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_7 6.0 10.0 0.0   0.0 2.0     0.0   0.0   10.0 8.0     8.0   0.0     5.0   3.0   18.0 6 10 0   0 2     0   0   10 8     8 0   5 3   18
1953230 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 Middle 06 08 2019   grade_7 454.0 68.0 27.0   6.0 23.0     1.0   33.0   306.0 306.0     23.0   13.0     209.0   104.0   612.0 454 68 27   6 23     1   33   306 306     23 13   209 104   612
1953234 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 Middle 06 08 2019   grade_7 260.0 80.0 36.0   7.0 25.0     0.0   26.0   236.0 198.0     21.0   17.0     229.0   73.0   434.0 260 80 36   7 25     0   26   236 198     21 17   229 73   434
1953242 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000119 90 NORTHDALE MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 277.0 54.0 31.0   4.0 43.0     0.0   21.0   231.0 199.0     19.0   11.0     191.0   79.0   430.0 277 54 31   4 43     0   21   231 199     19 11   191 79   430
1953246 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 2019   grade_7 362.0 11.0 13.0   0.0 9.0     1.0   11.0   212.0 195.0     4.0   5.0     65.0   *   407.0 362 11 13   0 9     1   11   212 195     4 5   65     407
1953250 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000122 195 Roosevelt Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 322.0 35.0 20.0   2.0 27.0     0.0   11.0   221.0 196.0     6.0   8.0     109.0   *   417.0 322 35 20   2 27     0   11   221 196     6 8   109     417
1953254 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 Middle 06 08 2019   grade_7 407.0 26.0 32.0   2.0 16.0     0.0   26.0   254.0 255.0     *   *         *   509.0 407 26 32   2 16     0   26   254 255                 509
1953258 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 Middle 06 08 2019   grade_7 39.0 84.0 94.0   5.0 8.0     0.0   15.0   127.0 118.0     39.0   5.0     182.0   32.0   245.0 39 84 94   5 8     0   15   127 118     39 5   182 32   245
1953263 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 2019   grade_7 60.0 84.0 24.0   2.0 12.0     0.0   13.0   104.0 91.0     20.0   6.0     134.0   27.0   195.0 60 84 24   2 12     0   13   104 91     20 6   134 27   195
1953267 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354000013 123 ST. FRANCIS MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 185.0 1.0 9.0   2.0 5.0     0.0   14.0   114.0 102.0     1.0   1.0     48.0   44.0   216.0 185 1 9   2 5     0   14   114 102     1 1   48 44   216
1953272 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001466 92 Westwood Intermediate and Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_7 254.0 64.0 65.0   7.0 46.0     1.0   36.0   235.0 238.0     56.0   5.0     189.0   59.0   473.0 254 64 65   7 46     1   36   235 238     56 5   189 59   473
1955344 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242003427 652 FRIDLEY MIDDLE AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No Middle 05 08 2019   grade_7 2.0 10.0 3.0   1.0 0.0     0.0   0.0   12.0 4.0     0.0   0.0     13.0   0.0   16.0 2 10 3   1 0     0   0   12 4     0 0   13 0   16
1955350 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354004980 18 Saints Academy Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2019   grade_7 98.0 0.0 5.0   0.0 11.0     0.0   2.0   68.0 48.0     8.0   4.0     42.0   7.0   116.0 98 0 5   0 11     0   2   68 48     8 4   42 7   116
1955973 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000005 467 RIVER TRAIL LEARNING CTR @ LO JACOB Special Education Special Education School No Other KG 12 2019   grade_7 9.0 1.0 1.0   0.0 0.0     0.0   1.0   12.0 0.0     0.0   0.0     7.0   *   12.0 9 1 1   0 0     0   1   12 0     0 0   7     12
1956585 MN Anoka 2 school 2702264 916 Intermediate Districts and Schools NORTHEAST METRO 916 270226404643 40 Karner Blue Education Center Special Education Special Education School No Elementary KG 08 2019   grade_7 3.0 2.0 1.0   0.0 0.0     0.0   0.0   5.0 1.0     *   *         *   6.0 3 2 1   0 0     0   0   5 1                 6
1957328 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354004917 15 Saints Online Distance Learning Program OLL (State approved) Regular School No Other 03 12 2019   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0     *   *         *   1.0 1 0 0   0 0     0   0   0 1                 1
1957515 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810004656 159 Pines School - NSP Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 06 12 2019   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1957528 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354005205 856 Crossroads School Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other KG 12 2019   grade_7 0.0 0.0 0.0   0.0 1.0     0.0   2.0   3.0 0.0     *   *         *   3.0 0 0 0   0 1     0   2   3 0                 3
1957785 MN Anoka 2 school 2702264 916 Intermediate Districts and Schools NORTHEAST METRO 916 270226404404 31 THE WILLOWS Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 07 12 2019   grade_7 0.0 0.0 1.0   0.0 0.0     0.0   0.0   0.0 1.0     *   *         *   1.0 0 0 1   0 0     0   0   0 1                 1
1944389 MN Becker 3 school 2712360 23 Independent Districts and Schools FRAZEE-VERGAS PUBLIC SCHOOL DIST. 271236000606 20 FRAZEE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 61.0 0.0 4.0   10.0 0.0     0.0   2.0   40.0 37.0     0.0   0.0     42.0   17.0   77.0 61 0 4   10 0     0   2   40 37     0 0   42 17   77
1945619 MN Becker 3 school 2700162 2889 Independent Districts and Schools LAKE PARK AUDUBON SCHOOL DISTRICT 270016200812 20 LAKE PARK AUDUBON SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 46.0 0.0 1.0   2.0 0.0     0.0   2.0   32.0 19.0     0.0   0.0     19.0   5.0   51.0 46 0 1   2 0     0   2   32 19     0 0   19 5   51
1953277 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 Middle 05 08 2019   grade_7 185.0 5.0 5.0   26.0 3.0     0.0   23.0   139.0 108.0     *   *         *   247.0 185 5 5   26 3     0   23   139 108                 247
1955361 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023003061 32 DETROIT LAKES MIDDLE ALC Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2019   grade_7 2.0 0.0 0.0   1.0 0.0     0.0   0.0   0.0 3.0     *   *         *   3.0 2 0 0   1 0     0   0   0 3                 3
1944396 MN Beltrami 4 school 2705730 32 Independent Districts and Schools BLACKDUCK PUBLIC SCHOOL DISTRICT 270573000213 20 BLACKDUCK SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 29.0 0.0 1.0   8.0 0.0     0.0   2.0   23.0 17.0     0.0   0.0     24.0   8.0   40.0 29 0 1   8 0     0   2   23 17     0 0   24 8   40
1944403 MN Beltrami 4 school 2717010 36 Independent Districts and Schools KELLIHER PUBLIC SCHOOL DISTRICT 271701000787 20 KELLIHER SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 17.0 0.0 0.0   12.0 0.0     0.0   0.0   17.0 12.0     0.0   0.0     23.0   3.0   29.0 17 0 0   12 0     0   0   17 12     0 0   23 3   29
1946349 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 2019   grade_7 0.0 0.0 0.0   19.0 0.0     0.0   0.0   13.0 6.0     *   *         *   19.0 0 0 0   19 0     0   0   13 6                 19
1952299 MN Beltrami 4 school 2700225 4058 Charter Schools SCHOOLCRAFT LEARNING COMMUNITY CHTR 270022503464 10 SCHOOLCRAFT LEARNING COMMUNITY CHTR Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_7 16.0 1.0 2.0   0.0 0.0     0.0   2.0   13.0 8.0     0.0   0.0     10.0   7.0   21.0 16 1 2   0 0     0   2   13 8     0 0   10 7   21
1953281 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444002031 15 BEMIDJI MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 243.0 3.0 5.0   57.0 5.0     1.0   52.0   177.0 189.0     *   *         *   366.0 243 3 5   57 5     1   52   177 189                 366
1953285 MN Beltrami 4 school 2730510 38 Independent Districts and Schools RED LAKE PUBLIC SCHOOL DISTRICT 273051002427 40 Red Lake Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 0.0 0.0 0.0   56.0 0.0     0.0   0.0   29.0 27.0     0.0   5.0     41.0   8.0   56.0 0 0 0   56 0     0   0   29 27     0 5   41 8   56
1954137 MN Beltrami 4 school 2700345 4106 Charter Schools TREKNORTH HIGH SCHOOL 270034504666 20 Trek North Middle School Middle School (Grades 5-8) Regular School Yes Middle 06 08 2019   grade_7 17.0 0.0 0.0   16.0 0.0     0.0   5.0   19.0 19.0     0.0   0.0     21.0   9.0   38.0 17 0 0   16 0     0   5   19 19     0 0   21 9   38
1954141 MN Beltrami 4 school 2700346 4107 Charter Schools VOYAGEURS EXPEDITIONARY 270034604667 20 Voyageurs Expeditionary MS Middle School (Grades 5-8) Regular School Yes Middle 06 08 2019   grade_7 3.0 0.0 0.0   11.0 0.0     0.0   2.0   6.0 10.0     0.0   0.0         4.0   16.0 3 0 0   11 0     0   2   6 10     0 0     4   16
1955381 MN Beltrami 4 school 2730510 38 Independent Districts and Schools RED LAKE PUBLIC SCHOOL DISTRICT 273051002793 50 RED LAKE MIDDLE LEVEL ALC Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2019   grade_7 0.0 0.0 0.0   5.0 0.0     0.0   0.0   3.0 2.0     *   *         *   5.0 0 0 0   5 0     0   0   3 2                 5
1957535 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000313 160 FIRST CITY SCHOOL Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 03 12 2019   grade_7 0.0 0.0 0.0   1.0 0.0     0.0   1.0   1.0 1.0     *   *         *   2.0 0 0 0   1 0     0   1   1 1                 2
1946383 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 Middle 04 08 2019   grade_7 150.0 0.0 3.0   1.0 0.0     1.0   2.0   84.0 73.0     0.0   0.0     36.0   24.0   157.0 150 0 3   1 0     1   2   84 73     0 0   36 24   157
1953289 MN Benton 5 school 2732880 47 Independent Districts and Schools SAUK RAPIDS-RICE PUBLIC SCHOOLS 273288002246 9 SAUK RAPIDS-RICE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 343.0 15.0 15.0   0.0 6.0     0.0   13.0   203.0 189.0     6.0   1.0     133.0   54.0   392.0 343 15 15   0 6     0   13   203 189     6 1   133 54   392
1945612 MN Big Stone 6 school 2700150 2888 Independent Districts and Schools CLINTON-GRACEVILLE-BEARDSLEY 270015000652 3 CLINTON-GRACEVILLE-BEARDSLEY SR. Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 17.0 0.0 0.0   0.0 0.0     0.0   0.0   8.0 9.0     *   *         *   17.0 17 0 0   0 0     0   0   8 9                 17
1945640 MN Big Stone 6 school 2700328 2903 Independent Districts and Schools ORTONVILLE PUBLIC SCHOOLS 270032804386 20 ORTONVILLE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 35.0 0.0 2.0   0.0 1.0     0.0   1.0   20.0 19.0     0.0   0.0     17.0   7.0   39.0 35 0 2   0 1     0   1   20 19     0 0   17 7   39
1958222 MN Big Stone 6 school 2700150 2888 Independent Districts and Schools CLINTON-GRACEVILLE-BEARDSLEY 270015003019 6 Lismore Colony School Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School No Other KG 11 2019   grade_7 3.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 1.0     *   *         *   3.0 3 0 0   0 0     0   0   2 1                 3
1944410 MN Blue Earth 7 school 2733480 75 Independent Districts and Schools ST. CLAIR PUBLIC SCHOOL DISTRICT 273348001478 20 ST. CLAIR SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 67.0 0.0 0.0   0.0 0.0     0.0   1.0   34.0 34.0     0.0   0.0     9.0   7.0   68.0 67 0 0   0 0     0   1   34 34     0 0   9 7   68
1945319 MN Blue Earth 7 school 2791445 2071 Independent Districts and Schools LAKE CRYSTAL-WELLCOME MEMORIAL 279144502312 30 LK CRYSTAL-WELLCOME MEMORIAL SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_7 67.0 2.0 1.0   0.0 0.0     0.0   0.0   36.0 34.0     0.0   0.0     15.0   7.0   70.0 67 2 1   0 0     0   0   36 34     0 0   15 7   70
1945334 MN Blue Earth 7 school 2700006 2135 Independent Districts and Schools MAPLE RIVER SCHOOL DISTRICT 270000600888 20 Maple River Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_7 60.0 0.0 2.0   0.0 0.0     0.0   3.0   34.0 31.0     0.0   0.0     20.0   14.0   65.0 60 0 2   0 0     0   3   34 31     0 0   20 14   65
1945744 MN Blue Earth 7 school 2700226 4066 Charter Schools Kato Public Charter School 270022603471 10 Kato Public Charter School Secondary School (Grades 7-12) Regular School Yes High 06 12 2019   grade_7 2.0 0.0 2.0   0.0 0.0     0.0   0.0   3.0 1.0     *   *         *   4.0 2 0 2   0 0     0   0   3 1                 4
1953297 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 2019   grade_7 253.0 33.0 26.0   2.0 9.0     0.0   20.0   179.0 164.0     16.0   5.0     130.0   *   343.0 253 33 26   2 9     0   20   179 164     16 5   130     343
1956019 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878004374 370 FUTURES PROGRAM Special Education Special Education School No Other KG 12 2019   grade_7 2.0 1.0 0.0   0.0 0.0     0.0   0.0   1.0 2.0     *   *         *   3.0 2 1 0   0 0     0   0   1 2                 3
1957864 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878005116 375 Prairie Care Mankato Educational Oversight to Public Care and Treatment Day Program Alternative School No High 06 12 2019   grade_7 2.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0     *   *         *   2.0 2 0 0   0 0     0   0   2 0                 2
1944417 MN Brown 8 school 2709540 81 Independent Districts and Schools COMFREY PUBLIC SCHOOL DISTRICT 270954000404 20 COMFREY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 13.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 6.0     0.0   0.0     9.0   2.0   13.0 13 0 0   0 0     0   0   7 6     0 0   9 2   13
1944424 MN Brown 8 school 2733210 84 Independent Districts and Schools SLEEPY EYE PUBLIC SCHOOL DISTRICT 273321001451 20 SLEEPY EYE SEC. Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 31.0 0.0 14.0   0.0 1.0     0.0   0.0   23.0 23.0     3.0   1.0     20.0   7.0   46.0 31 0 14   0 1     0   0   23 23     3 1   20 7   46
1944431 MN Brown 8 school 2733390 85 Independent Districts and Schools SPRINGFIELD PUBLIC SCHOOL DISTRICT 273339001471 1 SPRINGFIELD SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 40.0 0.0 0.0   0.0 0.0     0.0   0.0   25.0 15.0     0.0   0.0     15.0   1.0   40.0 40 0 0   0 0     0   0   25 15     0 0   15 1   40
1953302 MN Brown 8 school 2723490 88 Independent Districts and Schools NEW ULM PUBLIC SCHOOL DISTRICT 272349005035 40 NEW ULM MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_7 146.0 1.0 7.0   0.0 1.0     0.0   2.0   78.0 79.0     1.0   1.0     48.0   27.0   157.0 146 1 7   0 1     0   2   78 79     1 1   48 27   157
1955928 MN Brown 8 school 2791353 6049 Education Districts RIVER BEND EDUCATION DISTRICT 279135302494 20 RIVER BEND AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2019   grade_7 2.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 2 0 0   0 0     0   0   1 1                 2
1957127 MN Brown 8 school 2791353 6049 Education Districts RIVER BEND EDUCATION DISTRICT 279135304366 35 IMPRINTS PROGRAM Special Education Special Education School No Other 01 12 2019   grade_7 3.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0     *   *         *   3.0 3 0 0   0 0     0   0   3 0                 3
1944438 MN Carlton 9 school 2703690 91 Independent Districts and Schools BARNUM PUBLIC SCHOOL DISTRICT 270369000172 2 BARNUM SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 51.0 0.0 3.0   1.0 0.0     0.0   6.0   38.0 23.0     0.0   0.0     17.0   9.0   61.0 51 0 3   1 0     0   6   38 23     0 0   17 9   61
1944446 MN Carlton 9 school 2707590 93 Independent Districts and Schools CARLTON PUBLIC SCHOOL DISTRICT 270759000327 1 CARLTON SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_7 18.0 0.0 1.0   6.0 0.0     0.0   2.0   18.0 9.0     0.0   0.0     10.0   5.0   27.0 18 0 1   6 0     0   2   18 9     0 0   10 5   27
1944453 MN Carlton 9 school 2709690 95 Independent Districts and Schools CROMWELL-WRIGHT PUBLIC SCHOOLS 270969000409 20 CROMWELL-WRIGHT SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 34.0 0.0 0.0   3.0 1.0     0.0   0.0   17.0 21.0     0.0   0.0     15.0   5.0   38.0 34 0 0   3 1     0   0   17 21     0 0   15 5   38
1944460 MN Carlton 9 school 2721450 97 Independent Districts and Schools MOOSE LAKE PUBLIC SCHOOL DISTRICT 272145001094 10 MOOSE LAKE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 59.0 0.0 0.0   0.0 0.0     0.0   1.0   25.0 35.0     0.0   1.0     14.0   6.0   60.0 59 0 0   0 0     0   1   25 35     0 1   14 6   60
1944467 MN Carlton 9 school 2738880 99 Independent Districts and Schools ESKO PUBLIC SCHOOL DISTRICT 273888001681 1 LINCOLN SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 107.0 0.0 1.0   1.0 0.0     0.0   3.0   52.0 60.0     0.0   1.0     10.0   10.0   112.0 107 0 1   1 0     0   3   52 60     0 1   10 10   112
1944474 MN Carlton 9 school 2744190 100 Independent Districts and Schools WRENSHALL PUBLIC SCHOOL DISTRICT 274419001843 2 WRENSHALL SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 47.0 0.0 4.0   0.0 0.0     0.0   2.0   32.0 21.0     0.0   0.0     23.0   15.0   53.0 47 0 4   0 0     0   2   32 21     0 0   23 15   53
1953307 MN Carlton 9 school 2709420 94 Independent Districts and Schools CLOQUET PUBLIC SCHOOL DISTRICT 270942000381 201 CLOQUET MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_7 174.0 1.0 4.0   16.0 0.0     0.0   26.0   117.0 104.0     *   *         *   221.0 174 1 4   16 0     0   26   117 104                 221
1955392 MN Carlton 9 school 2709420 94 Independent Districts and Schools CLOQUET PUBLIC SCHOOL DISTRICT 270942002236 103 CLOQUET AREA ALT. ED. PROGRAMS Public Area Learning Center ALC (State approved) Alternative School No Other 01 12 2019   grade_7 1.0 0.0 0.0   1.0 0.0     0.0   0.0   2.0 0.0     *   *         *   2.0 1 0 0   1 0     0   0   2 0                 2
1956887 MN Carlton 9 school 2700442 6096 Special Education Cooperatives Northern Lights Academy Cooperative 270044205073 10 Northern Lights Academy Special Education Special Education School No Elementary KG 08 2019   grade_7 1.0 1.0 0.0   1.0 0.0     0.0   0.0   2.0 1.0     *   *         *   3.0 1 1 0   1 0     0   0   2 1                 3
1956893 MN Carlton 9 school 2700442 6096 Special Education Cooperatives Northern Lights Academy Cooperative 270044205117 20 Northern Lights Academy Cooperative-Our Savior's Special Education Special Education School No Elementary KG 08 2019   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1952166 MN Carver 10 school 2700116 4016 Charter Schools WORLD LEARNER CHARTER SCHOOL 270011602606 10 WORLD LEARNER CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary 01 08 2019   grade_7 16.0 0.0 1.0   0.0 2.0     0.0   1.0   12.0 8.0     0.0   0.0     2.0   5.0   20.0 16 0 1   0 2     0   1   12 8     0 0   2 5   20
1952766 MN Carver 10 school 2700319 4188 Charter Schools COLOGNE ACADEMY 270031904320 10 COLOGNE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_7 47.0 2.0 3.0   0.0 1.0     0.0   2.0   23.0 32.0     0.0   0.0     9.0   8.0   55.0 47 2 3   0 1     0   2   23 32     0 0   9 8   55
1953311 MN Carver 10 school 2723910 108 Independent Districts and Schools CENTRAL PUBLIC SCHOOL DISTRICT 272391002507 30 CENTRAL MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 64.0 1.0 3.0   0.0 0.0     0.0   2.0   39.0 31.0     0.0   0.0     16.0   9.0   70.0 64 1 3   0 0     0   2   39 31     0 0   16 9   70
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
1953320 MN Carver 10 school 2741910 111 Independent Districts and Schools WATERTOWN-MAYER PUBLIC SCHOOL DIST. 274191000024 841 WATERTOWN-MAYER MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_7 104.0 1.0 1.0   0.0 1.0     0.0   0.0   45.0 62.0     1.0   0.0     20.0   6.0   107.0 104 1 1   0 1     0   0   45 62     1 0   20 6   107
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
1953328 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_7 170.0 1.0 9.0   0.0 7.0     0.0   7.0   106.0 88.0     0.0   0.0     6.0   13.0   194.0 170 1 9   0 7     0   7   106 88     0 0   6 13   194
1953332 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819003180 63 PIONEER RIDGE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 112.0 7.0 4.0   0.0 7.0     0.0   8.0   74.0 64.0     1.0   0.0     20.0   16.0   138.0 112 7 4   0 7     0   8   74 64     1 0   20 16   138
1953508 MN Carver 10 school 2711670 276 Independent Districts and Schools MINNETONKA PUBLIC SCHOOL DISTRICT 271167002194 175 MINNETONKA WEST MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 340.0 13.0 16.0   0.0 18.0     0.0   20.0   208.0 199.0     4.0   1.0     26.0   46.0   407.0 340 13 16   0 18     0   20   208 199     4 1   26 46   407
1955412 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_7 91.0 17.0 50.0   1.0 10.0     1.0   12.0   105.0 77.0     20.0   0.0     92.0   47.0   182.0 91 17 50   1 10     1   12   105 77     20 0   92 47   182
1944481 MN Cass 11 school 2702910 113 Independent Districts and Schools WALKER-HACKENSACK-AKELEY SCHL. DIST 270291001737 20 WALKER-HACKENSACK-AKELEY SEC. Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 30.0 0.0 0.0   9.0 0.0     0.0   2.0   21.0 20.0     0.0   6.0     22.0   9.0   41.0 30 0 0   9 0     0   2   21 20     0 6   22 9   41
1944488 MN Cass 11 school 2730870 118 Independent Districts and Schools NORTHLAND COMMUNITY SCHOOLS 273087001308 20 NORTHLAND SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 25.0 0.0 0.0   10.0 0.0     0.0   0.0   12.0 23.0     *   *         *   35.0 25 0 0   10 0     0   0   12 23                 35
1945432 MN Cass 11 school 2728970 2174 Independent Districts and Schools PINE RIVER-BACKUS SCHOOL DISTRICT 272897000041 20 PINE RIVER-BACKUS HIGH SCHOOL Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 65.0 2.0 0.0   0.0 0.0     1.0   1.0   30.0 39.0     0.0   1.0     29.0   16.0   69.0 65 2 0   0 0     1   1   30 39     0 1   29 16   69
1953337 MN Cass 11 school 2708070 115 Independent Districts and Schools CASS LAKE-BENA PUBLIC SCHOOLS 270807003181 20 CASS LAKE-BENA MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_7 14.0 0.0 1.0   73.0 0.0     0.0   2.0   45.0 45.0     *   *         *   90.0 14 0 1   73 0     0   2   45 45                 90
1953342 MN Cass 11 school 2728350 116 Independent Districts and Schools PILLAGER PUBLIC SCHOOL DISTRICT 272835004841 40 Pillager Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_7 81.0 0.0 3.0   0.0 0.0     0.0   2.0   53.0 33.0     0.0   0.0     37.0   11.0   86.0 81 0 3   0 0     0   2   53 33     0 0   37 11   86
1955418 MN Cass 11 school 2708070 115 Independent Districts and Schools CASS LAKE-BENA PUBLIC SCHOOLS 270807002234 31 CASS LAKE-BENA AREA LRNG. CNTR. Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2019   grade_7 0.0 0.0 0.0   2.0 0.0     0.0   0.0   0.0 2.0     *   *         *   2.0 0 0 0   2 0     0   0   0 2                 2
1957548 MN Cass 11 school 2730870 118 Independent Districts and Schools NORTHLAND COMMUNITY SCHOOLS 273087003507 40 LITTLE SAND Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 07 12 2019   grade_7 1.0 0.0 1.0   0.0 0.0     0.0   0.0   0.0 2.0     *   *         *   2.0 1 0 1   0 0     0   0   0 2                 2
1945447 MN Chippewa 12 school 2700091 2180 Independent Districts and Schools MACCRAY School District 270009100365 20 MACCRAY SENIOR HIGH Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 52.0 0.0 9.0   0.0 0.0     1.0   1.0   35.0 28.0     0.0   0.0     23.0   13.0   63.0 52 0 9   0 0     1   1   35 28     0 0   23 13   63
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
1955915 MN Chippewa 12 school 2700058 6018 Education Districts MN River Valley Education District 270005802245 20 MN River Valley ALC-Seatbased Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2019   grade_7 2.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0     *   *         *   2.0 2 0 0   0 0     0   0   2 0                 2
1944495 MN Chisago 13 school 2732550 139 Independent Districts and Schools RUSH CITY PUBLIC SCHOOL DISTRICT 273255001406 20 RUSH CITY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 72.0 0.0 2.0   1.0 1.0     0.0   2.0   39.0 39.0     0.0   0.0     23.0   5.0   78.0 72 0 2   1 1     0   2   39 39     0 0   23 5   78
1953352 MN Chisago 13 school 2723820 138 Independent Districts and Schools NORTH BRANCH PUBLIC SCHOOLS 272382001164 20 NORTH BRANCH MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_7 181.0 2.0 10.0   0.0 6.0     0.0   7.0   97.0 109.0     *   1.0     58.0   32.0   206.0 181 2 10   0 6     0   7   97 109       1   58 32   206
1953987 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 2019   grade_7 249.0 1.0 3.0   1.0 5.0     0.0   6.0   141.0 124.0     0.0   1.0     49.0   29.0   265.0 249 1 3   1 5     0   6   141 124     0 1   49 29   265
1955425 MN Chisago 13 school 2723820 138 Independent Districts and Schools NORTH BRANCH PUBLIC SCHOOLS 272382000401 50 NORTH BRANCH LAB SCHOOL ALC Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2019   grade_7 22.0 0.0 2.0   0.0 4.0     0.0   1.0   16.0 13.0     *   0.0     18.0   2.0   29.0 22 0 2   0 4     0   1   16 13       0   18 2   29
1957031 MN Chisago 13 school 2700015 6009 Education Districts ST. CROIX RIVER EDUCATION DISTRICT 270001505144 50 Skillbuilding Opportunities for Academic Resiliency Special Education Special Education School No Other KG 12 2019   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1944502 MN Clay 14 school 2703660 146 Independent Districts and Schools Barnesville Public School District 270366000170 40 BARNESVILLE SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_7 73.0 0.0 1.0   0.0 0.0     0.0   2.0   49.0 27.0     0.0   0.0     14.0   10.0   76.0 73 0 1   0 0     0   2   49 27     0 0   14 10   76
1944509 MN Clay 14 school 2713560 150 Independent Districts and Schools HAWLEY PUBLIC SCHOOL DISTRICT 271356000699 20 HAWLEY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 75.0 0.0 1.0   1.0 0.0     0.0   4.0   42.0 39.0     2.0   0.0     10.0   11.0   81.0 75 0 1   1 0     0   4   42 39     2 0   10 11   81
1945311 MN Clay 14 school 2740810 914 Independent Districts and Schools ULEN-HITTERDAL PUBLIC SCHOOL DIST 274081001705 2 ULEN-HITTERDAL SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 21.0 1.0 0.0   2.0 0.0     0.0   2.0   13.0 13.0     0.0   0.0     7.0   2.0   26.0 21 1 0   2 0     0   2   13 13     0 0   7 2   26
1953357 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142003512 380 HORIZON MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_7 385.0 40.0 45.0   10.0 2.0     1.0   37.0   237.0 283.0     32.0   *     212.0   *   520.0 385 40 45   10 2     1   37   237 283     32     212     520
1953995 MN Clay 14 school 2710260 2164 Independent Districts and Schools DILWORTH-GLYNDON-FELTON 271026000448 3 DILWORTH-GLYNDON-FELTON MIDDLE SCH Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 104.0 0.0 9.0   2.0 0.0     0.0   7.0   54.0 68.0     0.0   1.0     37.0   20.0   122.0 104 0 9   2 0     0   7   54 68     0 1   37 20   122
1956700 MN Clay 14 school 2700040 397 Special Education Cooperatives Lake Agassiz Education Cooperative 270004005080 12 Glacial Ridge Transitional Skills Program Special Education Special Education School No High 07 12 2019   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0     *   *         *   1.0 1 0 0   0 0     0   0   0 1                 1

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