enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
690308 690308 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004903 390 Heritage STEM Academy Secondary School (Grades 7-12) Regular School No Other 06 12 2017   grade_6 0.0 12.0 0.0   0.0 0.0     0.0   0.0   7.0 5.0     8.0   0.0         0.0   12.0 0 12 0   0 0     0   0   7 5     8 0     0   12
690555 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
696296 696296 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000942 106 BARTON OPEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 08 2017   grade_6 45.0 24.0 4.0   1.0 3.0     1.0   1.0   38.0 41.0     12.0   2.0     33.0   7.0   79.0 45 24 4   1 3     1   1   38 41     12 2   33 7   79
696318 696318 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000969 121 LAKE HARRIET UPPER SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 04 08 2017   grade_6 116.0 4.0 4.0   0.0 6.0     0.0   2.0   57.0 75.0     5.0   0.0     20.0   13.0   132.0 116 4 4   0 6     0   2   57 75     5 0   20 13   132
696339 696339 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000988 134 LK NOKOMIS COMM-KEEWAYDIN CAMPUS Elementary School (Grades PK-6) Regular School No Elementary 03 08 2017   grade_6 36.0 14.0 18.0   2.0 3.0     0.0   1.0   32.0 42.0     6.0   2.0     40.0   4.0   74.0 36 14 18   2 3     0   1   32 42     6 2   40 4   74
696409 696409 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001031 160 SEWARD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 08 2017   grade_6 40.0 46.0 4.0   2.0 2.0     0.0   1.0   46.0 49.0     29.0   1.0     61.0   7.0   95.0 40 46 4   2 2     0   1   46 49     29 1   61 7   95
696448 696448 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001866 175 FOLWELL ARTS MAGNET Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_6 12.0 23.0 61.0   3.0 1.0     0.0   3.0   52.0 51.0     35.0   8.0     91.0   19.0   103.0 12 23 61   3 1     0   3   52 51     35 8   91 19   103
696459 696459 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000986 179 JEFFERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_6 1.0 40.0 32.0   0.0 1.0     0.0   1.0   39.0 36.0         5.0         14.0   75.0 1 40 32   0 1     0   1   39 36       5     14   75
696478 696478 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000932 190 ANDERSEN COMMUNITY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_6 4.0 38.0 74.0   8.0 1.0     0.0   2.0   67.0 60.0     65.0   10.0         27.0   127.0 4 38 74   8 1     0   2   67 60     65 10     27   127
696489 696489 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002297 193 SULLIVAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_6 0.0 58.0 4.0   1.0 0.0     0.0   0.0   33.0 30.0     43.0   6.0         6.0   63.0 0 58 4   1 0     0   0   33 30     43 6     6   63
696511 696511 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004172 225 ANISHINABE ACADEMY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_6 0.0 2.0 0.0   28.0 0.0     0.0   0.0   11.0 19.0     0.0   *         10.0   30.0 0 2 0   28 0     0   0   11 19     0       10   30
696521 696521 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002144 226 MARCY OPEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 08 2017   grade_6 40.0 35.0 11.0   5.0 2.0     0.0   0.0   55.0 38.0     11.0   1.0     54.0   12.0   93.0 40 35 11   5 2     0   0   55 38     11 1   54 12   93
696590 696590 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004239 291 HMONG INTERNATIONAL ACADEMY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_6 0.0 14.0 1.0   1.0 24.0     0.0   3.0   23.0 20.0     18.0   8.0         9.0   43.0 0 14 1   1 24     0   3   23 20     18 8     9   43
698493 698493 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000965 119 Field Community Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_6 87.0 21.0 9.0   1.0 5.0     0.0   3.0   63.0 63.0     8.0   2.0     38.0   25.0   126.0 87 21 9   1 5     0   3   63 63     8 2   38 25   126
698497 698497 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000936 300 ANTHONY MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 133.0 69.0 27.0   0.0 9.0     0.0   5.0   126.0 117.0     33.0   9.0     111.0   37.0   243.0 133 69 27   0 9     0   5   126 117     33 9   111 37   243
698501 698501 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 2017   grade_6 25.0 58.0 78.0   4.0 19.0     0.0   2.0   91.0 95.0     59.0   10.0     139.0   31.0   186.0 25 58 78   4 19     0   2   91 95     59 10   139 31   186
698505 698505 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001008 316 NORTHEAST MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 38.0 72.0 41.0   2.0 6.0     0.0   3.0   85.0 77.0     36.0   9.0     132.0   33.0   162.0 38 72 41   2 6     0   3   85 77     36 9   132 33   162
698509 698509 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002581 318 OLSON MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 20.0 74.0 14.0   5.0 13.0     0.0   1.0   78.0 49.0     19.0   15.0     109.0   31.0   127.0 20 74 14   5 13     0   1   78 49     19 15   109 31   127
698513 698513 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004574 323 RAMSEY MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 146.0 71.0 40.0   3.0 13.0     2.0   5.0   145.0 135.0     43.0   9.0     133.0   39.0   280.0 146 71 40   3 13     2   5   145 135     43 9   133 39   280
698517 698517 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001028 324 SANFORD MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 141.0 89.0 53.0   21.0 15.0     0.0   15.0   165.0 169.0     53.0   11.0     202.0   51.0   334.0 141 89 53   21 15     0   15   165 169     53 11   202 51   334
698521 698521 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004882 327 Franklin Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 5.0 98.0 19.0   4.0 2.0     1.0   4.0   59.0 74.0     12.0   20.0         38.0   133.0 5 98 19   4 2     1   4   59 74     12 20     38   133
700940 700940 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124003022 625 RIVER BEND EDUCATIONAL CENTER Special Education Special Education School No Other KG 12 2017   grade_6 0.0 8.0 0.0   0.0 0.0     0.0   0.0   7.0 1.0         *         *   8.0 0 8 0   0 0     0   0   7 1                 8
701697 701697 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001935 688 MPS METRO HA Hospital/Medical/Partial Hospitalization Program Alternative School No Other KG 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
702169 702169 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001936 689 MPS METRO SJ Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other KG 12 2017   grade_6 1.0 4.0 0.0   0.0 0.0     0.0   1.0   4.0 2.0         *         *   6.0 1 4 0   0 0     0   1   4 2                 6
702644 702644 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002860 315 RONALD MCDONALD HOUSE Private Alternative Program Alternative School No Other KG 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
691205 691205 MN Carlton 9 school 2744190 100 Independent Districts and Schools WRENSHALL PUBLIC SCHOOL DISTRICT 274419001842 1 WRENSHALL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 20.0 0.0 0.0   0.0 0.0     0.0   0.0   10.0 10.0     0.0   0.0     15.0   6.0   20.0 20 0 0   0 0     0   0   10 10     0 0   15 6   20
698525 698525 MN Washington 82 school 2700411 1001 State Operated Integration Magnet School Crosswinds Arts and Science School 270041104874 10 Crosswinds Arts and Science Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 6.0 8.0 4.0   1.0 1.0     0.0   3.0   9.0 14.0     0.0   0.0     14.0   4.0   23.0 6 8 4   1 1     0   3   9 14     0 0   14 4   23
697763 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
697684 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 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 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 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 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 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 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 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
697767 697767 MN Carver 10 school 2741460 110 Independent Districts and Schools WACONIA PUBLIC SCHOOL DISTRICT 274146003066 220 CLEARWATER MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 266.0 3.0 15.0   1.0 2.0     2.0   13.0   165.0 137.0     5.0   1.0     48.0   53.0   302.0 266 3 15   1 2     2   13   165 137     5 1   48 53   302
697771 697771 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 06 08 2017   grade_6 127.0 0.0 1.0   0.0 1.0     0.0   3.0   65.0 67.0     0.0   0.0     27.0   13.0   132.0 127 0 1   0 1     0   3   65 67     0 0   27 13   132
697775 697775 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819000345 61 CHASKA MIDDLE SCHOOL EAST Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 149.0 2.0 15.0   1.0 3.0     0.0   11.0   80.0 101.0     4.0   0.0         *   181.0 149 2 15   1 3     0   11   80 101     4 0         181
697779 697779 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 2017   grade_6 158.0 4.0 11.0   0.0 10.0     0.0   10.0   98.0 95.0         0.0     24.0   23.0   193.0 158 4 11   0 10     0   10   98 95       0   24 23   193
697783 697783 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 2017   grade_6 144.0 11.0 30.0   0.0 10.0     0.0   11.0   113.0 93.0     5.0   *     58.0   *   206.0 144 11 30   0 10     0   11   113 93     5     58     206
699829 699829 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 2017   grade_6 59.0 6.0 28.0   2.0 1.0     0.0   6.0   50.0 52.0     12.0   0.0     44.0   22.0   102.0 59 6 28   2 1     0   6   50 52     12 0   44 22   102
701663 701663 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819004659 522 PrairieCare Chaska Hospital/Medical/Partial Hospitalization Program Alternative School No Other KG 12 2017   grade_6 1.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 1.0         *         *   2.0 1 0 1   0 0     0   0   1 1                 2
691309 691309 MN Cass 11 school 2702910 113 Independent Districts and Schools WALKER-HACKENSACK-AKELEY SCHL. DIST 270291001736 10 W.H.A. ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 42.0 0.0 3.0   10.0 0.0     0.0   4.0   28.0 31.0     0.0   3.0     31.0   15.0   59.0 42 0 3   10 0     0   4   28 31     0 3   31 15   59
697788 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
697793 697793 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 2017   grade_6 81.0 1.0 1.0   1.0 0.0     0.0   0.0   33.0 51.0     0.0   0.0     32.0   12.0   84.0 81 1 1   1 0     0   0   33 51     0 0   32 12   84
691333 691333 MN Cass 11 school 2730870 118 Independent Districts and Schools NORTHLAND COMMUNITY SCHOOLS 273087001307 10 REMER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 17.0 0.0 0.0   5.0 0.0     0.0   7.0   18.0 11.0     0.0   0.0     20.0   9.0   29.0 17 0 0   5 0     0   7   18 11     0 0   20 9   29
697708 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 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
697799 697799 MN Chippewa 12 school 2721320 129 Independent Districts and Schools MONTEVIDEO PUBLIC SCHOOL DISTRICT 272132001071 30 MONTEVIDEO MIDDLE Middle School (Grades 5-8) Regular School No Elementary 04 07 2017   grade_6 92.0 1.0 12.0   0.0 2.0     0.0   4.0   70.0 41.0     4.0   0.0     43.0   23.0   111.0 92 1 12   0 2     0   4   70 41     4 0   43 23   111
697712 697712 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 2017   grade_6 51.0 82.0 92.0   5.0 17.0     0.0   24.0   130.0 141.0     54.0   15.0     224.0   *   271.0 51 82 92   5 17     0   24   130 141     54 15   224     271
697803 697803 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 2017   grade_6 192.0 0.0 7.0   2.0 2.0     0.0   3.0   110.0 96.0         *         *   206.0 192 0 7   2 2     0   3   110 96                 206
701755 701755 MN Chisago 13 school 2723820 138 Independent Districts and Schools NORTH BRANCH PUBLIC SCHOOLS 272382002633 70 DISTANCE LEARNING PROGRAM Distance Learning Program OLL (State approved) Regular School No Other KG 12 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
691357 691357 MN Chisago 13 school 2732550 139 Independent Districts and Schools RUSH CITY PUBLIC SCHOOL DISTRICT 273255001405 10 C.E. JACOBSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 67.0 0.0 1.0   1.0 2.0     0.0   0.0   39.0 32.0     2.0   0.0     28.0   9.0   71.0 67 0 1   1 2     0   0   39 32     2 0   28 9   71
697717 697717 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_6 74.0 83.0 34.0   1.0 15.0     0.0   18.0   117.0 108.0         *         *   225.0 74 83 34   1 15     0   18   117 108                 225
699752 699752 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 2017   grade_6 2.0 2.0 2.0   0.0 1.0     0.0   1.0   4.0 4.0         *         *   8.0 2 2 2   0 1     0   1   4 4                 8
691365 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
697721 697721 MN Anoka 2 school 2733540 15 Independent Districts and Schools ST. FRANCIS PUBLIC SCHOOL DISTRICT 273354000013 123 ST. FRANCIS MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 312.0 2.0 12.0   5.0 9.0     0.0   20.0   182.0 178.0         *         *   360.0 312 2 12   5 9     0   20   182 178                 360
701743 701743 MN Anoka 2 school 2733540 15 Independent Districts and Schools ST. FRANCIS PUBLIC SCHOOL DISTRICT 273354004917 15 Saints Online Distance Learning Program OLL (State approved) Regular School No Other 03 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
691373 691373 MN Clay 14 school 2713560 150 Independent Districts and Schools HAWLEY PUBLIC SCHOOL DISTRICT 271356000698 10 HAWLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 60.0 0.0 0.0   0.0 0.0     1.0   2.0   40.0 23.0         *         *   63.0 60 0 0   0 0     1   2   40 23                 63
691380 691380 MN Clay 14 school 2713560 150 Independent Districts and Schools HAWLEY PUBLIC SCHOOL DISTRICT 271356002240 11 SPRING PRAIRIE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_6 4.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 2.0         *         *   4.0 4 0 0   0 0     0   0   2 2                 4
697807 697807 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 06 08 2017   grade_6 339.0 26.0 41.0   19.0 3.0     0.0   30.0   245.0 213.0         *         *   458.0 339 26 41   19 3     0   30   245 213                 458
701967 701967 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142002799 970 CLAY COUNTY SHELTER CARE Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 03 12 2017   grade_6 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
690866 690866 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333004657 787 Elementary Lighthouse Elementary School (Grades PK-6) Regular School No Elementary 01 06 2017   grade_6 9.0 0.0 1.0   0.0 0.0     0.0   0.0   7.0 3.0     0.0   0.0     2.0   1.0   10.0 9 0 1   0 0     0   0   7 3     0 0   2 1   10
697725 697725 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001466 92 WESTWOOD MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 236.0 51.0 59.0   2.0 31.0     0.0   21.0   217.0 183.0     22.0   1.0     160.0   39.0   400.0 236 51 59   2 31     0   21   217 183     22 1   160 39   400
700954 700954 MN Rice 66 school 2700129 160 State Operated Schools (which include MN Academy Deaf & Blind, School for the Arts) MINNESOTA STATE ACADEMIES 270012903056 1 MN ACADEMY FOR THE BLIND Special Education Special Education School No Other PK 12 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
700969 700969 MN Rice 66 school 2700129 160 State Operated Schools (which include MN Academy Deaf & Blind, School for the Arts) MINNESOTA STATE ACADEMIES 270012902409 2 MN ACADEMY FOR THE DEAF Special Education Special Education School No Other PK 12 2017   grade_6 6.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 2.0         *         *   6.0 6 0 0   0 0     0   0   4 2                 6
691410 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
697811 697811 MN Cook 16 school 2713110 166 Independent Districts and Schools COOK COUNTY PUBLIC SCHOOLS 271311002635 40 COOK COUNTY MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 18.0 0.0 2.0   5.0 0.0     0.0   2.0   14.0 13.0     0.0   0.0     14.0   3.0   27.0 18 0 2   5 0     0   2   14 13     0 0   14 3   27
691428 691428 MN Cottonwood 17 school 2723010 173 Independent Districts and Schools MOUNTAIN LAKE PUBLIC SCHOOLS 272301001134 10 MOUNTAIN LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 26.0 0.0 5.0   0.0 1.0     0.0   1.0   14.0 19.0     1.0   0.0     18.0   7.0   33.0 26 0 5   0 1     0   1   14 19     1 0   18 7   33
697817 697817 MN Cottonwood 17 school 2742780 177 Independent Districts and Schools WINDOM PUBLIC SCHOOL DISTRICT 274278003068 60 WINDOM MIDDLE Middle School (Grades 5-8) Regular School No Elementary 04 08 2017   grade_6 66.0 3.0 12.0   0.0 0.0     0.0   2.0   47.0 36.0     1.0   0.0     30.0   15.0   83.0 66 3 12   0 0     0   2   47 36     1 0   30 15   83
697822 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 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 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
691480 691480 MN Crow Wing 18 school 2709750 182 Independent Districts and Schools CROSBY-IRONTON PUBLIC SCHOOL DIST. 270975000291 6 CUYUNA RANGE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 69.0 0.0 3.0   0.0 0.0     0.0   4.0   42.0 34.0     0.0   0.0     43.0   12.0   76.0 69 0 3   0 0     0   4   42 34     0 0   43 12   76
697827 697827 MN Crow Wing 18 school 2728200 186 Independent Districts and Schools PEQUOT LAKES PUBLIC SCHOOLS 272820003069 15 PEQUOT LAKES MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_6 131.0 3.0 0.0   1.0 0.0     0.0   4.0   68.0 71.0     0.0   0.0     31.0   19.0   139.0 131 3 0   1 0     0   4   68 71     0 0   31 19   139
697831 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 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 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 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
691602 691602 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182004816 155 Gateway Academy Elementary School (Grades PK-6) Regular School No Elementary 03 08 2017   grade_6 5.0 2.0 1.0   0.0 1.0     0.0   1.0   8.0 2.0         0.0         *   10.0 5 2 1   0 1     0   1   8 2       0         10
697843 697843 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 2017   grade_6 208.0 6.0 12.0   2.0 9.0     0.0   13.0   129.0 121.0     3.0   2.0         *   250.0 208 6 12   2 9     0   13   129 121     3 2         250
697847 697847 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182002983 60 ROBERT BOECKMAN MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 237.0 7.0 16.0   2.0 13.0     0.0   10.0   144.0 141.0         0.0     37.0   53.0   285.0 237 7 16   2 13     0   10   144 141       0   37 53   285
697851 697851 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778002435 89 MCGUIRE MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 247.0 13.0 11.0   1.0 17.0     2.0   15.0   150.0 156.0     4.0   *     48.0   51.0   306.0 247 13 11   1 17     2   15   150 156     4     48 51   306
697855 697855 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 2017   grade_6 176.0 7.0 28.0   1.0 16.0     1.0   12.0   115.0 126.0     7.0   4.0     55.0   37.0   241.0 176 7 28   1 16     1   12   115 126     7 4   55 37   241
697859 697859 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_6 265.0 8.0 9.0   3.0 18.0     0.0   6.0   160.0 149.0         0.0         *   309.0 265 8 9   3 18     0   6   160 149       0         309
701768 701768 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778004309 90 Link12 Lakeville Distance Learning Program OLL (State approved) Regular School No Other KG 12 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
691677 691677 MN Dakota 19 school 2730150 195 Independent Districts and Schools RANDOLPH PUBLIC SCHOOL DISTRICT 273015001286 10 RANDOLPH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 49.0 0.0 0.0   0.0 0.0     0.0   1.0   28.0 22.0     0.0   0.0         7.0   50.0 49 0 0   0 0     0   1   28 22     0 0     7   50
697863 697863 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239000484 25 DAKOTA HILLS MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 244.0 31.0 39.0   0.0 42.0     1.0   22.0   194.0 185.0     12.0   *         36.0   379.0 244 31 39   0 42     1   22   194 185     12       36   379
697867 697867 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002437 32 BLACK HAWK MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 164.0 50.0 26.0   1.0 25.0     0.0   28.0   146.0 148.0     25.0   *     99.0   48.0   294.0 164 50 26   1 25     0   28   146 148     25     99 48   294
697871 697871 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001381 39 ROSEMOUNT MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 339.0 19.0 23.0   0.0 24.0     0.0   20.0   230.0 195.0         0.0     60.0   52.0   425.0 339 19 23   0 24     0   20   230 195       0   60 52   425
697875 697875 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002644 86 FALCON RIDGE MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 211.0 35.0 39.0   1.0 28.0     0.0   32.0   193.0 153.0     28.0   4.0     88.0   48.0   346.0 211 35 39   1 28     0   32   193 153     28 4   88 48   346
697879 697879 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 Middle 06 08 2017   grade_6 230.0 35.0 20.0   1.0 33.0     1.0   29.0   170.0 179.0     11.0   0.0     87.0   63.0   349.0 230 35 20   1 33     1   29   170 179     11 0   87 63   349
697883 697883 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001383 98 VALLEY MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 192.0 68.0 42.0   4.0 24.0     1.0   24.0   177.0 178.0     28.0   0.0     149.0   56.0   355.0 192 68 42   4 24     1   24   177 178     28 0   149 56   355
700533 700533 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002517 100 DAKOTA RIDGE SCHOOL Special Education Special Education School No Other KG 12 2017   grade_6 2.0 0.0 0.0   0.0 0.0     0.0   1.0   2.0 1.0         *         *   3.0 2 0 0   0 0     0   1   2 1                 3
697888 697888 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_6 93.0 22.0 28.0   0.0 14.0     0.0   14.0   85.0 86.0     12.0   4.0     54.0   30.0   171.0 93 22 28   0 14     0   14   85 86     12 4   54 30   171
697893 697893 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227001774 54 HERITAGE E-STEM MAGNET SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_6 83.0 15.0 66.0   0.0 2.0     0.0   12.0   85.0 93.0     19.0   2.0     90.0   23.0   178.0 83 15 66   0 2     0   12   85 93     19 2   90 23   178
697897 697897 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 Middle 06 08 2017   grade_6 149.0 15.0 64.0   1.0 8.0     0.0   22.0   126.0 133.0     21.0   2.0     99.0   41.0   259.0 149 15 64   1 8     0   22   126 133     21 2   99 41   259
697680 697680 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 2017   grade_6 21.0 0.0 0.0   1.0 0.0     0.0   2.0   12.0 12.0     0.0   0.0     15.0   3.0   24.0 21 0 0   1 0     0   2   12 12     0 0   15 3   24
697902 697902 MN Dakota 19 school 2713530 200 Independent Districts and Schools HASTINGS PUBLIC SCHOOL DISTRICT 271353000693 130 HASTINGS MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_6 282.0 5.0 9.0   1.0 2.0     0.0   12.0   172.0 139.0         0.0         *   311.0 282 5 9   1 2     0   12   172 139       0         311

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