Data source: Big Local News · About: Big Local

702 rows where grade = "grade_6", state = "MN" and year = 2017 sorted by district

View and edit SQL

year

  • 2017 · 702

grade

  • grade_6 · 702
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
695866 MN Meeker 47 school 2700106 2396 Independent Districts and Schools A.C.G.C. Public School District 270010603647 150 ACGC ELEMENTARY GRADES 5 AND 6 Elementary School (Grades PK-6) Regular School No Middle 05 06 2017   grade_6 56.0 0.0 4.0   2.0 0.0     0.0   3.0   36.0 29.0     0.0   1.0     28.0   10.0   65.0 56 0 4   2 0     0   3   36 29     0 1   28 10   65
696720 MN Ramsey 62 school 2700118 4018 Charter Schools ACHIEVE LANGUAGE ACADEMY 270011802608 10 ACHIEVE LANGUAGE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2017   grade_6 4.0 6.0 16.0   1.0 21.0     0.0   1.0   26.0 23.0     27.0   1.0     42.0   6.0   49.0 4 6 16   1 21     0   1   26 23     27 1   42 6   49
690222 MN Norman 54 school 2700126 2854 Independent Districts and Schools ADA-BORUP PUBLIC SCHOOL DISTRICT 270012600051 30 ADA-BORUP SECONDARY Secondary School (Grades 7-12) Regular School No Other 06 12 2017   grade_6 35.0 2.0 1.0   1.0 0.0     0.0   2.0   18.0 23.0     0.0   0.0     20.0   6.0   41.0 35 2 1   1 0     0   2   18 23     0 0   20 6   41
698109 MN Nobles 53 school 2702730 511 Independent Districts and Schools ADRIAN PUBLIC SCHOOL DISTRICT 270273003076 15 ADRIAN MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 47.0 1.0 6.0   0.0 2.0     0.0   1.0   31.0 26.0     1.0   0.0     25.0   11.0   57.0 47 1 6   0 2     0   1   31 26     1 0   25 11   57
698544 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA HIGH SCHOOL 270018604854 20 AFSA Middle School Middle School (Grades 5-8) Regular School Yes Middle 05 08 2017   grade_6 15.0 6.0 5.0   0.0 2.0     0.0   1.0   14.0 15.0     0.0   0.0     8.0   6.0   29.0 15 6 5   0 2     0   1   14 15     0 0   8 6   29
690555 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276000059 2 RIPPLESIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 90.0 1.0 2.0   0.0 0.0     0.0   5.0   61.0 37.0     1.0   0.0     48.0   12.0   98.0 90 1 2   0 0     0   5   61 37     1 0   48 12   98
694761 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000062 10 ALBANY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 06 2017   grade_6 61.0 0.0 5.0   0.0 0.0     0.0   1.0   30.0 37.0     2.0   0.0     19.0   13.0   67.0 61 0 5   0 0     0   1   30 37     2 0   19 13   67
694769 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000065 30 AVON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 48.0 0.0 1.0   0.0 0.0     0.0   0.0   21.0 28.0     0.0   0.0     9.0   7.0   49.0 48 0 1   0 0     0   0   21 28     0 0   9 7   49
697919 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000078 320 SOUTHWEST MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 07 2017   grade_6 160.0 6.0 58.0   3.0 14.0     0.0   8.0   128.0 121.0         *         *   249.0 160 6 58   3 14     0   8   128 121                 249
699887 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297002228 350 Albert Lea Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No Other 06 12 2017   grade_6 5.0 2.0 3.0   0.0 0.0     0.0   1.0   6.0 5.0         *         *   11.0 5 2 3   0 0     0   1   6 5                 11
692023 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000079 2 ALDEN-CONGER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 42.0 0.0 3.0   0.0 0.0     0.0   1.0   18.0 28.0     0.0   0.0     15.0   10.0   46.0 42 0 3   0 0     0   1   18 28     0 0   15 10   46
697911 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_6 279.0 2.0 9.0   1.0 5.0     0.0   10.0   148.0 158.0     1.0   1.0     82.0   51.0   306.0 279 2 9   1 5     0   10   148 158     1 1   82 51   306
698348 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 Middle 06 08 2017   grade_6 130.0 2.0 4.0   0.0 0.0     0.0   3.0   68.0 71.0     2.0   1.0     31.0   18.0   139.0 130 2 4   0 0     0   3   68 71     2 1   31 18   139
690408 MN Rice 66 school 2700355 4091 Charter Schools ARCADIA CHARTER SCHOOL 270035504151 10 ARCADIA CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   grade_6 19.0 1.0 0.0   0.0 0.0     0.0   0.0   10.0 10.0     0.0   0.0     3.0   7.0   20.0 19 1 0   0 0     0   0   10 10     0 0   3 7   20
692063 MN Grant 26 school 2703300 261 Independent Districts and Schools ASHBY PUBLIC SCHOOL DISTRICT 270330000136 10 ASHBY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 15.0 0.0 1.0   0.0 0.0     0.0   0.0   7.0 9.0     0.0   0.0     7.0   2.0   16.0 15 0 1   0 0     0   0   7 9     0 0   7 2   16
697257 MN Scott 70 school 2700311 4184 Charter Schools ASPEN ACADEMY 270031104282 10 ASPEN ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_6 35.0 2.0 0.0   0.0 3.0     0.0   1.0   24.0 17.0     1.0   0.0     6.0   3.0   41.0 35 2 0   0 3     0   1   24 17     1 0   6 3   41
698539 MN Hennepin 27 school 2700220 4067 Charter Schools AURORA CHARTER SCHOOL 270022004420 20 AURORA MIDDLE SCHOOL Middle School (Grades 5-8) Regular School Yes Middle 05 08 2017   grade_6 0.0 0.0 47.0   0.0 0.0     0.0   0.0   27.0 20.0         0.0     41.0   4.0   47.0 0 0 47   0 0     0   0   27 20       0   41 4   47
693240 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345004638 280 I.J. HOLTON INTERMEDIATE SCHOOL Elementary School (Grades PK-6) Regular School No Middle 05 06 2017   grade_6 183.0 26.0 92.0   0.0 23.0     1.0   10.0   165.0 170.0         *         *   335.0 183 26 92   0 23     1   10   165 170                 335
702617 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345003192 450 NEW DOMINION ACADEMY Educational Oversight to Private Residential Care & Treatment (State approved) Alternative School No Other KG 12 2017   grade_6 1.0 1.0 0.0   1.0 0.0     0.0   0.0   0.0 3.0         *         *   3.0 1 1 0   1 0     0   0   0 3                 3
698547 MN Ramsey 62 school 2700187 4075 Charter Schools AVALON SCHOOL 270018704664 20 Avalon Middle School Middle School (Grades 5-8) Regular School Yes Middle 06 08 2017   grade_6 8.0 1.0 2.0   1.0 0.0     0.0   0.0   6.0 6.0     0.0   0.0     6.0   2.0   12.0 8 1 2   1 0     0   0   6 6     0 0   6 2   12
696890 MN Ramsey 62 school 2700185 4073 Charter Schools Academia Cesar Chavez Charter School 270018503138 10 Academia Cesar Chavez Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 06 2017   grade_6 5.0 0.0 49.0   0.0 1.0     0.0   1.0   25.0 31.0     29.0   0.0         9.0   56.0 5 0 49   0 1     0   1   25 31     29 0     9   56
697684 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 2017   grade_6 458.0 50.0 28.0   7.0 21.0     1.0   20.0   257.0 328.0     16.0   8.0     203.0   65.0   585.0 458 50 28   7 21     1   20   257 328     16 8   203 65   585
697688 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 2017   grade_6 250.0 55.0 39.0   4.0 29.0     0.0   25.0   211.0 191.0     16.0   11.0     213.0   56.0   402.0 250 55 39   4 29     0   25   211 191     16 11   213 56   402
697692 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000108 6 JACKSON MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 418.0 111.0 50.0   6.0 99.0     0.0   40.0   344.0 380.0     27.0   3.0     250.0   96.0   724.0 418 111 50   6 99     0   40   344 380     27 3   250 96   724
697696 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 2017   grade_6 233.0 59.0 35.0   1.0 37.0     0.0   29.0   205.0 189.0     13.0   7.0     159.0   79.0   394.0 233 59 35   1 37     0   29   205 189     13 7   159 79   394
697700 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_6 342.0 10.0 7.0   2.0 8.0     1.0   15.0   199.0 186.0         3.0         *   385.0 342 10 7   2 8     1   15   199 186       3         385
697704 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 2017   grade_6 321.0 28.0 14.0   1.0 33.0     0.0   13.0   200.0 210.0     7.0   1.0     86.0   44.0   410.0 321 28 14   1 33     0   13   200 210     7 1   86 44   410
700448 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 2017   grade_6 4.0 1.0 0.0   0.0 0.0     0.0   1.0   6.0 0.0         *         *   6.0 4 1 0   0 0     0   1   6 0                 6
701649 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002504 440 Alexandra House Homeless Student Program, Title I Alternative School No Other KG 12 2017   grade_6 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     0   1   0 1                 1
697478 MN Isanti 30 school 2700397 4227 Charter Schools Art and Science Academy 270039704766 10 Art and Science Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_6 35.0 0.0 1.0   0.0 0.0     0.0   0.0   8.0 28.0     0.0   0.0     11.0   4.0   36.0 35 0 1   0 0     0   0   8 28     0 0   11 4   36
697560 MN Stearns 73 school 2700430 4250 Charter Schools Athlos Academy of Saint Cloud 270043004959 10 Athlos Academy of Saint Cloud Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2017   grade_6 37.0 11.0 2.0   1.0 2.0     0.0   10.0   31.0 32.0     2.0   1.0     30.0   13.0   63.0 37 11 2   1 2     0   10   31 32     2 1   30 13   63
696663 MN Hennepin 27 school 2700096 4011 Charter Schools Athlos Leadership Academy 270009601892 10 Athlos Leadership Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2017   grade_6 9.0 54.0 6.0   1.0 4.0     0.0   12.0   39.0 47.0     9.0   1.0     63.0   8.0   86.0 9 54 6   1 4     0   12   39 47     9 1   63 8   86
701384 MN Mower 50 school 2700426 6095 Special Education Cooperatives Austin Albert Lea Area Special Education Cooperative (AALASEC) 270042605016 550 Oakland Education Center Special Education Special Education School No Other KG 12 2017   grade_6 4.0 1.0 1.0   0.0 0.0     0.0   0.0   4.0 2.0         *         *   6.0 4 1 1   0 0     0   0   4 2                 6
694261 MN Roseau 68 school 2703540 676 Independent Districts and Schools BADGER PUBLIC SCHOOL DISTRICT 270354000162 10 BADGER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 20.0 1.0 0.0   0.0 0.0     0.0   0.0   12.0 9.0     0.0   0.0     9.0   2.0   21.0 20 1 0   0 0     0   0   12 9     0 0   9 2   21
691410 MN Clearwater 15 school 2703570 162 Independent Districts and Schools BAGLEY PUBLIC SCHOOL DISTRICT 270357000164 10 BAGLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 51.0 1.0 0.0   20.0 1.0     0.0   6.0   41.0 38.0     0.0   0.0     44.0   14.0   79.0 51 1 0   20 1     0   6   41 38     0 0   44 14   79
691146 MN Carlton 9 school 2703690 91 Independent Districts and Schools BARNUM PUBLIC SCHOOL DISTRICT 270369000171 1 BARNUM ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 52.0 0.0 1.0   0.0 0.0     0.0   5.0   36.0 22.0     0.0   0.0     18.0   8.0   58.0 52 0 1   0 0     0   5   36 22     0 0   18 8   58
693480 MN Otter Tail 56 school 2703750 542 Independent Districts and Schools BATTLE LAKE PUBLIC SCHOOL DISTRICT 270375000175 10 BATTLE LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_6 30.0 0.0 2.0   0.0 0.0     0.0   0.0   14.0 18.0     0.0   0.0     6.0   1.0   32.0 30 0 2   0 0     0   0   14 18     0 0   6 1   32
697032 MN Hennepin 27 school 2700366 4124 Charter Schools BEACON ACADEMY 270036604110 10 BEACON ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_6 26.0 12.0 3.0   0.0 0.0     0.0   2.0   23.0 20.0     0.0   1.0     15.0   5.0   43.0 26 12 3   0 0     0   2   23 20     0 1   15 5   43
698269 MN Sherburne 71 school 2703870 726 Independent Districts and Schools BECKER PUBLIC SCHOOL DISTRICT 270387002556 30 BECKER MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 197.0 3.0 5.0   0.0 0.0     0.0   9.0   101.0 113.0     2.0   0.0     42.0   29.0   214.0 197 3 5   0 0     0   9   101 113     2 0   42 29   214
694454 MN Scott 70 school 2704050 716 Independent Districts and Schools BELLE PLAINE PUBLIC SCHOOL DISTRICT 270405003718 11 OAK CREST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 06 2017   grade_6 102.0 2.0 5.0   2.0 2.0     1.0   4.0   53.0 65.0     1.0   0.0     25.0   11.0   118.0 102 2 5   2 2     1   4   53 65     1 0   25 11   118
697734 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 2017   grade_6 263.0 5.0 7.0   48.0 2.0     0.0   28.0   183.0 170.0     2.0   *         *   353.0 263 5 7   48 2     0   28   183 170     2           353
694887 MN Swift 76 school 2704470 777 Independent Districts and Schools BENSON PUBLIC SCHOOL DISTRICT 270447000201 103 NORTHSIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 49.0 1.0 7.0   0.0 1.0     0.0   0.0   26.0 32.0         *         *   58.0 49 1 7   0 1     0   0   26 32                 58
702445 MN Swift 76 school 2704470 777 Independent Districts and Schools BENSON PUBLIC SCHOOL DISTRICT 270447003708 112 Benson Day Treatment Educational Oversight to Public Care and Treatment Day Program Alternative School No Other KG 12 2017   grade_6 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
701601 MN Stearns 73 school 2700071 6383 Education Districts BENTON-STEARNS ED. DISTRICT 270007102403 10 BENTON-STEARNS ED. DISTRICT Special Education Special Education School No Other PK 12 2017   grade_6 4.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 1.0         *         *   4.0 4 0 0   0 0     0   0   3 1                 4
697315 MN Hennepin 27 school 2700309 4192 Charter Schools BEST ACADEMY 270030904261 10 Best Academy East at Olson Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2017   grade_6 0.0 33.0 0.0   0.0 0.0     0.0   0.0   17.0 16.0     16.0   0.0     27.0   1.0   33.0 0 33 0   0 0     0   0   17 16     16 0   27 1   33
698605 MN Hennepin 27 school 2700309 4192 Charter Schools BEST ACADEMY 270030904773 20 Best Academy K-8 at Penn Middle School (Grades 5-8) Regular School Yes Elementary KG 08 2017   grade_6 1.0 74.0 2.0   1.0 0.0     0.0   3.0   45.0 36.0     2.0   5.0     72.0   18.0   81.0 1 74 2   1 0     0   3   45 36     2 5   72 18   81
698273 MN Sherburne 71 school 2705460 727 Independent Districts and Schools BIG LAKE PUBLIC SCHOOL DISTRICT 270546002462 30 BIG LAKE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 217.0 8.0 14.0   0.0 1.0     0.0   18.0   127.0 131.0     3.0   1.0     53.0   42.0   258.0 217 8 14   0 1     0   18   127 131     3 1   53 42   258
690957 MN Beltrami 4 school 2705730 32 Independent Districts and Schools BLACKDUCK PUBLIC SCHOOL DISTRICT 270573000212 10 BLACKDUCK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 46.0 0.0 0.0   6.0 0.0     0.0   5.0   29.0 28.0     0.0   4.0     37.0   15.0   57.0 46 0 0   6 0     0   5   29 28     0 4   37 15   57
694812 MN Steele 74 school 2705760 756 Independent Districts and Schools BLOOMING PRAIRIE PUBLIC SCHOOL DIST 270576000214 10 BLOOMING PRAIRIE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 48.0 0.0 5.0   0.0 0.0     0.0   4.0   24.0 33.0     0.0   0.0     19.0   5.0   57.0 48 0 5   0 0     0   4   24 33     0 0   19 5   57
697931 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_6 147.0 44.0 40.0   0.0 11.0     0.0   23.0   136.0 129.0     12.0   *     105.0   33.0   265.0 147 44 40   0 11     0   23   136 129     12     105 33   265
697935 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000638 345 VALLEY VIEW MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 49.0 69.0 87.0   2.0 21.0     0.0   20.0   131.0 117.0     42.0   7.0     177.0   47.0   248.0 49 69 87   2 21     0   20   131 117     42 7   177 47   248
697939 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 Middle 06 08 2017   grade_6 220.0 22.0 26.0   0.0 18.0     0.0   19.0   143.0 162.0         *         55.0   305.0 220 22 26   0 18     0   19   143 162             55   305
700577 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579004809 503 SUN Center Special Education Special Education School No Elementary KG 08 2017   grade_6 2.0 1.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0         *         *   3.0 2 1 0   0 0     0   0   3 0                 3
698468 MN Faribault 22 school 2700130 2860 Independent Districts and Schools BLUE EARTH AREA PUBLIC SCHOOL 270013002497 23 BLUE EARTH AREA MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 07 2017   grade_6 73.0 3.0 17.0   1.0 0.0     0.0   2.0   56.0 40.0     1.0   0.0     46.0   14.0   96.0 73 3 17   1 0     0   2   56 40     1 0   46 14   96
696626 MN Winona 85 school 2705850 4001 Charter Schools BLUFFVIEW MONTESSORI 270585000018 10 BLUFFVIEW MONTESSORI Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_6 16.0 1.0 3.0   0.0 0.0     0.0   2.0   11.0 11.0     0.0   0.0     7.0   4.0   22.0 16 1 3   0 0     0   2   11 11     0 0   7 4   22
692774 MN Isanti 30 school 2706060 314 Independent Districts and Schools BRAHAM PUBLIC SCHOOL DISTRICT 270606000245 2 BRAHAM ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 56.0 1.0 1.0   0.0 0.0     0.0   3.0   24.0 37.0     0.0   1.0     27.0   12.0   61.0 56 1 1   0 0     0   3   24 37     0 1   27 12   61
697822 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_6 474.0 13.0 3.0   6.0 4.0     1.0   14.0   242.0 273.0         3.0     209.0   93.0   515.0 474 13 3   6 4     1   14   242 273       3   209 93   515
699857 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609002982 21 MIDDLE LEVEL ALTERNATIVE PROGRAM Public Area Learning Center ALC (State approved) Alternative School No Middle 05 08 2017   grade_6 4.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 1.0         *         *   4.0 4 0 0   0 0     0   0   3 1                 4
702265 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000468 17 LINCOLN EDUCATION CENTER Miscellaneous Program (assignment is now limited) Alternative School No Other 02 12 2017   grade_6 1.0 0.0 0.0   0.0 0.0     0.0   2.0   3.0 0.0         *         *   3.0 1 0 0   0 0     0   2   3 0                 3
698488 MN Douglas 21 school 2700382 2908 Independent Districts and Schools BRANDON-EVANSVILLE PUBLIC SCHOOLS 270038204740 3 Brandon-Evansville Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 34.0 0.0 0.0   0.0 0.0     0.0   1.0   16.0 19.0     0.0   0.0     14.0   2.0   35.0 34 0 0   0 0     0   1   16 19     0 0   14 2   35
695263 MN Wilkin 84 school 2706150 846 Independent Districts and Schools BRECKENRIDGE PUBLIC SCHOOL DISTRICT 270615000266 10 BRECKENRIDGE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 39.0 0.0 0.0   3.0 0.0     0.0   5.0   24.0 23.0     0.0   1.0     21.0   10.0   47.0 39 0 0   3 0     0   5   24 23     0 1   21 10   47
697304 MN Hennepin 27 school 2700316 4189 Charter Schools BRIGHT WATER ELEMENTARY 270031604319 10 BRIGHT WATER ELEMENTARY Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2017   grade_6 1.0 1.0 5.0   0.0 0.0     0.0   0.0   4.0 3.0         *         *   7.0 1 1 5   0 0     0   0   4 3                 7
689270 MN Hennepin 27 school 2706240 286 Independent Districts and Schools BROOKLYN CENTER SCHOOL DISTRICT 270624000273 12 BROOKLYN CENTER SECONDARY Secondary School (Grades 7-12) Regular School No Other 06 12 2017   grade_6 15.0 51.0 27.0   1.0 20.0     0.0   6.0   54.0 66.0         *         *   120.0 15 51 27   1 20     0   6   54 66                 120
701776 MN Hennepin 27 school 2706240 286 Independent Districts and Schools BROOKLYN CENTER SCHOOL DISTRICT 270624004306 221 INSIGHT SCHOOL OF MINNESOTA Distance Learning Program OLL (State approved) Regular School No Other 06 12 2017   grade_6 3.0 0.0 0.0   0.0 1.0     0.0   0.0   2.0 2.0         *         *   4.0 3 0 0   0 1     0   0   2 2                 4
694905 MN Todd 77 school 2706300 787 Independent Districts and Schools BROWERVILLE PUBLIC SCHOOL DISTRICT 270630000277 10 BROWERVILLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 31.0 0.0 1.0   0.0 0.0     0.0   0.0   21.0 11.0     0.0   0.0     19.0   13.0   32.0 31 0 1   0 0     0   0   21 11     0 0   19 13   32
698311 MN Traverse 78 school 2707110 801 Independent Districts and Schools BROWNS VALLEY PUBLIC SCHOOL DIST. 270711000280 20 BROWNS VALLEY MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_6 4.0 0.0 0.0   10.0 0.0     0.0   0.0   6.0 8.0     0.0   0.0     11.0   3.0   14.0 4 0 0   10 0     0   0   6 8     0 0   11 3   14
690029 MN Renville 65 school 2700023 2159 Independent Districts and Schools BUFFALO LK-HECTOR-STEWART PUBLIC SC 270002300704 20 BUFFALO LAKE-HECTOR SECONDARY Secondary School (Grades 7-12) Regular School No Other 06 12 2017   grade_6 34.0 0.0 6.0   0.0 1.0     0.0   0.0   23.0 18.0     0.0   0.0     14.0   9.0   41.0 34 0 6   0 1     0   0   23 18     0 0   14 9   41
695353 MN Wright 86 school 2707200 877 Independent Districts and Schools BUFFALO-HANOVER-MONTROSE PUBLIC SCH 270720000286 20 HANOVER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_6 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
698352 MN Wright 86 school 2707200 877 Independent Districts and Schools BUFFALO-HANOVER-MONTROSE PUBLIC SCH 270720000284 30 BUFFALO COMMUNITY MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 418.0 7.0 14.0   1.0 6.0     0.0   17.0   227.0 236.0         *         *   463.0 418 7 14   1 6     0   17   227 236                 463
697831 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_6 42.0 18.0 18.0   1.0 14.0     0.0   13.0   50.0 56.0     10.0   1.0     54.0   19.0   106.0 42 18 18   1 14     0   13   50 56     10 1   54 19   106
697835 MN Scott 70 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729002639 66 Eagle Ridge Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 78.0 20.0 25.0   0.0 21.0     0.0   12.0   78.0 78.0     4.0   0.0     59.0   16.0   156.0 78 20 25   0 21     0   12   78 78     4 0   59 16   156
697839 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_6 64.0 27.0 14.0   2.0 14.0     1.0   11.0   73.0 60.0     3.0   3.0     64.0   11.0   133.0 64 27 14   2 14     1   11   73 60     3 3   64 11   133
699861 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729002640 314 BURNSVILLE AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No Other 06 12 2017   grade_6 83.0 79.0 75.0   1.0 16.0     3.0   25.0   144.0 138.0     54.0   2.0     185.0   74.0   282.0 83 79 75   1 16     3   25   144 138     54 2   185 74   282
695235 MN Watonwan 83 school 2707320 836 Independent Districts and Schools BUTTERFIELD PUBLIC SCHOOL DISTRICT 270732000304 10 BUTTERFIELD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 4.0 1.0 5.0   0.0 0.0     0.0   0.0   8.0 2.0     3.0   0.0     7.0   5.0   10.0 4 1 5   0 0     0   0   8 2     3 0   7 5   10
698118 MN Olmsted 55 school 2707350 531 Independent Districts and Schools BYRON PUBLIC SCHOOL DISTRICT 270735000981 30 BYRON MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 137.0 3.0 9.0   0.0 0.0     0.0   6.0   71.0 84.0     0.0   0.0     26.0   26.0   155.0 137 3 9   0 0     0   6   71 84     0 0   26 26   155
691365 MN Clay 14 school 2703660 146 Independent Districts and Schools Barnesville Public School District 270366000169 10 BARNESVILLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_6 67.0 0.0 1.0   0.0 0.0     0.0   2.0   39.0 31.0     0.0   1.0     6.0   4.0   70.0 67 0 1   0 0     0   2   39 31     0 1   6 4   70
695849 MN Stearns 73 school 2700105 2364 Independent Districts and Schools Belgrade-Brooten-Elrosa Public School District 270010500182 1 BELGRADE-BROOTEN-ELROSA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 47.0 0.0 4.0   0.0 0.0     0.0   0.0   24.0 27.0     2.0   0.0     13.0   8.0   51.0 47 0 4   0 0     0   0   24 27     2 0   13 8   51
694896 MN Todd 77 school 2705430 786 Independent Districts and Schools Bertha-Hewitt Public School District 270543000203 10 BERTHA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 28.0 0.0 0.0   0.0 0.0     0.0   2.0   14.0 16.0     0.0   1.0     16.0   3.0   30.0 28 0 0   0 0     0   2   14 16     0 1   16 3   30
695904 MN Renville 65 school 2705660 2534 Independent Districts and Schools Bird Island-Olivia-Lake Lillian Public School District 270566000144 15 BOLD-BIRD ISLAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_6 31.0 0.0 11.0   0.0 1.0     0.0   0.0   15.0 28.0     5.0   0.0     30.0   4.0   43.0 31 0 11   0 1     0   0   15 28     5 0   30 4   43
698020 MN Houston 28 school 2707380 299 Independent Districts and Schools CALEDONIA PUBLIC SCHOOL DISTRICT 270738000310 20 CALEDONIA MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 47.0 3.0 0.0   0.0 0.0     0.0   2.0   27.0 25.0     0.0   0.0     22.0   11.0   52.0 47 3 0   0 0     0   2   27 25     0 0   22 11   52
698380 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_6 198.0 1.0 3.0   3.0 3.0     0.0   11.0   107.0 112.0     1.0   3.0     83.0   20.0   219.0 198 1 3   3 3     0   11   107 112     1 3   83 20   219
698384 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741003629 302 ISANTI MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 99.0 0.0 10.0   0.0 4.0     0.0   4.0   62.0 55.0     5.0   0.0     52.0   14.0   117.0 99 0 10   0 4     0   4   62 55     5 0   52 14   117
698388 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741003634 303 MINNESOTA CENTER Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 25.0 0.0 1.0   0.0 0.0     0.0   2.0   16.0 12.0     0.0   0.0     8.0   7.0   28.0 25 0 1   0 0     0   2   16 12     0 0   8 7   28
695281 MN Wilkin 84 school 2707450 852 Independent Districts and Schools CAMPBELL-TINTAH PUBLIC SCHOOL DIST. 270745000319 10 CAMPBELL-TINTAH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 5.0 0.0 0.0   0.0 0.0     0.0   1.0   4.0 2.0         *         *   6.0 5 0 0   0 0     0   1   4 2                 6
695445 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools CANBY PUBLIC SCHOOL DISTRICT 270747000321 20 CANBY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 34.0 0.0 1.0   0.0 0.0     0.0   0.0   16.0 19.0     0.0   0.0     14.0   4.0   35.0 34 0 1   0 0     0   0   16 19     0 0   14 4   35
689229 MN Goodhue 25 school 2707500 252 Independent Districts and Schools CANNON FALLS PUBLIC SCHOOL DISTRICT 270750000324 2 Cannon Falls Secondary Secondary School (Grades 7-12) Regular School No Other 06 12 2017   grade_6 81.0 1.0 4.0   1.0 0.0     0.0   6.0   47.0 46.0     0.0   0.0     26.0   7.0   93.0 81 1 4   1 0     0   6   47 46     0 0   26 7   93
697332 MN Rice 66 school 2700324 4194 Charter Schools CANNON RIVER STEM SCHOOL 270032404271 10 CANNON RIVER STEM SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_6 40.0 0.0 3.0   1.0 0.0     0.0   0.0   20.0 24.0     2.0   0.0     12.0   8.0   44.0 40 0 3   1 0     0   0   20 24     2 0   12 8   44
689087 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 Other 06 12 2017   grade_6 29.0 0.0 0.0   4.0 1.0     0.0   2.0   22.0 14.0     0.0   0.0     16.0   9.0   36.0 29 0 0   4 1     0   2   22 14     0 0   16 9   36
697788 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 2017   grade_6 8.0 0.0 3.0   68.0 0.0     0.0   3.0   48.0 34.0     0.0   2.0     66.0   24.0   82.0 8 0 3   68 0     0   3   48 34     0 2   66 24   82
690193 MN Redwood 64 school 2700110 2754 Independent Districts and Schools CEDAR MOUNTAIN SCHOOL DISTRICT 270011001099 2 CEDAR MOUNTAIN SECONDARY Secondary School (Grades 7-12) Regular School No Other 06 12 2017   grade_6 31.0 0.0 3.0   2.0 0.0     0.0   1.0   20.0 17.0     0.0   0.0     22.0   7.0   37.0 31 0 3   2 0     0   1   20 17     0 0   22 7   37
696637 MN Hennepin 27 school 2700027 4004 Charter Schools CEDAR RIVERSIDE COMMUNITY SCHOOL 270002702340 10 CEDAR RIVERSIDE COMMUNITY SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2017   grade_6 0.0 16.0 0.0   0.0 0.0     0.0   0.0   9.0 7.0     8.0   0.0         3.0   16.0 0 16 0   0 0     0   0   9 7     8 0     3   16
697708 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 2017   grade_6 395.0 19.0 21.0   2.0 23.0     1.0   21.0   261.0 221.0         *         *   482.0 395 19 21   2 23     1   21   261 221                 482
701929 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 Other 06 12 2017   grade_6 0.0 0.0 0.0   0.0 1.0     0.0   0.0   1.0 0.0         *         *   1.0 0 0 0   0 1     0   0   1 0                 1
697763 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 2017   grade_6 66.0 0.0 6.0   0.0 1.0     1.0   1.0   41.0 34.0     1.0   0.0     18.0   14.0   75.0 66 0 6   0 1     1   1   41 34     1 0   18 14   75
691956 MN Fillmore 23 school 2708220 227 Independent Districts and Schools CHATFIELD PUBLIC SCHOOLS 270822000349 2 CHATFIELD ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 86.0 1.0 1.0   0.0 0.0     0.0   0.0   41.0 47.0     0.0   0.0     19.0   7.0   88.0 86 1 1   0 0     0   0   41 47     0 0   19 7   88
698404 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_6 253.0 2.0 4.0   0.0 1.0     0.0   4.0   134.0 130.0         *         24.0   264.0 253 2 4   0 1     0   4   134 130             24   264
700914 MN Chisago 13 school 2700017 2144 Independent Districts and Schools CHISAGO LAKES SCHOOL DISTRICT 270001704939 17 SOAR Special Education Special Education School No Other 01 12 2017   grade_6 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
694297 MN Saint Louis 69 school 2708910 695 Independent Districts and Schools CHISHOLM PUBLIC SCHOOL DISTRICT 270891000356 301 CHISHOLM ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 04 06 2017   grade_6 43.0 2.0 1.0   0.0 0.0     0.0   3.0   24.0 25.0     0.0   0.0     22.0   10.0   49.0 43 2 1   0 0     0   3   24 25     0 0   22 10   49
694868 MN Stevens 75 school 2708940 771 Independent Districts and Schools CHOKIO-ALBERTA PUBLIC SCHOOL DIST. 270894000362 3 CHOKIO-ALBERTA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_6 9.0 0.0 0.0   0.0 0.0     0.0   0.0   5.0 4.0         *         *   9.0 9 0 0   0 0     0   0   5 4                 9
697239 MN Yellow Medicine 87 school 2700290 4172 Charter Schools CLARKFIELD CHARTER SCHOOL 270029003726 10 CLARKFIELD CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2017   grade_6 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

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