enrollments

Data source: Big Local News · About: Big Local

710 rows where grade = "grade_8", state = "MN" and year = 2017 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 710 ✖

grade ✖

  • grade_8 · 710 ✖
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
689011 689011 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 2017   grade_8 101.0 3.0 1.0   0.0 0.0     0.0   2.0   52.0 55.0     0.0   0.0     46.0   12.0   107.0 101 3 1   0 0     0   2   52 55     0 0   46 12   107
690310 690310 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_8 0.0 29.0 0.0   0.0 0.0     0.0   0.0   12.0 17.0     17.0   1.0         1.0   29.0 0 29 0   0 0     0   0   12 17     17 1     1   29
696298 696298 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_8 52.0 27.0 8.0   2.0 4.0     0.0   1.0   49.0 45.0     13.0   1.0     39.0   6.0   94.0 52 27 8   2 4     0   1   49 45     13 1   39 6   94
696320 696320 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_8 108.0 11.0 5.0   0.0 2.0     0.0   1.0   66.0 61.0     4.0   2.0     33.0   11.0   127.0 108 11 5   0 2     0   1   66 61     4 2   33 11   127
696341 696341 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_8 27.0 14.0 9.0   4.0 0.0     1.0   2.0   25.0 32.0     7.0   3.0     34.0   12.0   57.0 27 14 9   4 0     1   2   25 32     7 3   34 12   57
696411 696411 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_8 31.0 49.0 7.0   2.0 4.0     0.0   0.0   48.0 45.0     31.0   1.0     60.0   6.0   93.0 31 49 7   2 4     0   0   48 45     31 1   60 6   93
696450 696450 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_8 5.0 29.0 55.0   2.0 2.0     0.0   2.0   38.0 57.0     32.0   8.0         21.0   95.0 5 29 55   2 2     0   2   38 57     32 8     21   95
696461 696461 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_8 0.0 22.0 29.0   0.0 3.0     0.0   1.0   34.0 21.0     29.0   3.0         7.0   55.0 0 22 29   0 3     0   1   34 21     29 3     7   55
696480 696480 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_8 4.0 41.0 54.0   6.0 3.0     0.0   1.0   51.0 58.0     69.0   11.0         32.0   109.0 4 41 54   6 3     0   1   51 58     69 11     32   109
696491 696491 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_8 1.0 57.0 3.0   4.0 2.0     0.0   0.0   31.0 36.0     45.0   1.0         7.0   67.0 1 57 3   4 2     0   0   31 36     45 1     7   67
696513 696513 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_8 0.0 3.0 2.0   18.0 0.0     0.0   3.0   13.0 13.0     0.0   4.0         3.0   26.0 0 3 2   18 0     0   3   13 13     0 4     3   26
696523 696523 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_8 35.0 25.0 0.0   0.0 4.0     0.0   0.0   35.0 29.0     7.0   1.0     30.0   11.0   64.0 35 25 0   0 4     0   0   35 29     7 1   30 11   64
696592 696592 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_8 1.0 16.0 1.0   1.0 33.0     0.0   0.0   29.0 23.0     30.0   2.0         8.0   52.0 1 16 1   1 33     0   0   29 23     30 2     8   52
698495 698495 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_8 89.0 24.0 5.0   2.0 9.0     0.0   0.0   78.0 51.0     0.0   2.0     38.0   16.0   129.0 89 24 5   2 9     0   0   78 51     0 2   38 16   129
698499 698499 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_8 128.0 52.0 25.0   5.0 6.0     0.0   1.0   92.0 125.0     21.0   5.0     100.0   28.0   217.0 128 52 25   5 6     0   1   92 125     21 5   100 28   217
698503 698503 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_8 25.0 92.0 60.0   4.0 13.0     0.0   4.0   99.0 99.0     45.0   14.0     157.0   31.0   198.0 25 92 60   4 13     0   4   99 99     45 14   157 31   198
698507 698507 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_8 41.0 94.0 43.0   9.0 7.0     0.0   5.0   113.0 86.0     32.0   20.0     168.0   47.0   199.0 41 94 43   9 7     0   5   113 86     32 20   168 47   199
698511 698511 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_8 3.0 70.0 9.0   4.0 12.0     0.0   1.0   58.0 41.0     9.0   11.0         33.0   99.0 3 70 9   4 12     0   1   58 41     9 11     33   99
698515 698515 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_8 140.0 50.0 49.0   4.0 7.0     0.0   5.0   129.0 126.0     50.0   4.0     104.0   26.0   255.0 140 50 49   4 7     0   5   129 126     50 4   104 26   255
698519 698519 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_8 106.0 85.0 34.0   20.0 10.0     0.0   5.0   128.0 132.0     53.0   13.0     162.0   37.0   260.0 106 85 34   20 10     0   5   128 132     53 13   162 37   260
698523 698523 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_8 1.0 74.0 13.0   1.0 3.0     0.0   0.0   47.0 45.0     14.0   8.0         30.0   92.0 1 74 13   1 3     0   0   47 45     14 8     30   92
700942 700942 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_8 0.0 15.0 0.0   1.0 0.0     0.0   1.0   13.0 4.0     1.0   5.0     15.0   *   17.0 0 15 0   1 0     0   1   13 4     1 5   15     17
701699 701699 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_8 2.0 0.0 0.0   0.0 1.0     0.0   0.0   0.0 3.0         *         *   3.0 2 0 0   0 1     0   0   0 3                 3
701851 701851 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004188 415 MINNEAPOLIS ON LINE LEARNING Distance Learning Program OLL (State approved) Regular School No High 07 12 2017   grade_8 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
702159 702159 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001933 685 STADIUM VIEW Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 06 12 2017   grade_8 0.0 3.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0         *         *   3.0 0 3 0   0 0     0   0   3 0                 3
702171 702171 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_8 0.0 2.0 1.0   1.0 0.0     0.0   0.0   2.0 2.0         *         *   4.0 0 2 1   1 0     0   0   2 2                 4
702177 702177 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001948 697 MPS METRO C Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other KG 12 2017   grade_8 4.0 1.0 0.0   0.0 0.0     0.0   0.0   0.0 5.0         *         *   5.0 4 1 0   0 0     0   0   0 5                 5
702662 702662 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001903 361 CENTER SCHOOL Private Alternative Program Alternative School No High 07 12 2017   grade_8 0.0 0.0 0.0   3.0 0.0     0.0   0.0   1.0 2.0         *         *   3.0 0 0 0   3 0     0   0   1 2                 3
689117 689117 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 2017   grade_8 30.0 0.0 2.0   0.0 0.0     0.0   1.0   15.0 18.0     0.0   0.0     19.0   10.0   33.0 30 0 2   0 0     0   1   15 18     0 0   19 10   33
698527 698527 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_8 11.0 16.0 6.0   1.0 4.0     0.0   2.0   19.0 21.0     4.0   0.0     19.0   10.0   40.0 11 16 6   1 4     0   2   19 21     4 0   19 10   40
697765 697765 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_8 64.0 1.0 0.0   0.0 3.0     0.0   3.0   38.0 33.0     1.0   0.0     10.0   7.0   71.0 64 1 0   0 3     0   3   38 33     1 0   10 7   71
697686 697686 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_8 501.0 53.0 19.0   7.0 22.0     0.0   22.0   294.0 330.0     9.0   10.0     208.0   93.0   624.0 501 53 19   7 22     0   22   294 330     9 10   208 93   624
697690 697690 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_8 265.0 74.0 24.0   3.0 33.0     0.0   16.0   213.0 202.0     26.0   9.0     220.0   53.0   415.0 265 74 24   3 33     0   16   213 202     26 9   220 53   415
697694 697694 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_8 384.0 111.0 45.0   5.0 91.0     0.0   35.0   332.0 339.0     48.0   6.0     230.0   86.0   671.0 384 111 45   5 91     0   35   332 339     48 6   230 86   671
697698 697698 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_8 264.0 38.0 26.0   4.0 37.0     0.0   14.0   192.0 191.0     10.0   13.0     161.0   72.0   383.0 264 38 26   4 37     0   14   192 191     10 13   161 72   383
697702 697702 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002501 193 OAK VIEW MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 363.0 10.0 18.0   4.0 15.0     0.0   9.0   211.0 208.0     6.0   *     57.0   *   419.0 363 10 18   4 15     0   9   211 208     6     57     419
697706 697706 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_8 303.0 23.0 18.0   3.0 24.0     1.0   13.0   194.0 191.0     9.0   2.0     87.0   40.0   385.0 303 23 18   3 24     1   13   194 191     9 2   87 40   385
699740 699740 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002974 812 COMPASS-BELL CENTER Public Area Learning Center ALC (State approved) Alternative School No Other 06 12 2017   grade_8 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
700450 700450 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_8 8.0 4.0 1.0   1.0 0.0     0.0   3.0   16.0 1.0     0.0   1.0     12.0   *   17.0 8 4 1   1 0     0   3   16 1     0 1   12     17
701651 701651 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000002 464 ANTHONY LOUIS HOUSE Hospital/Medical/Partial Hospitalization Program Alternative School No Other 03 12 2017   grade_8 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
697769 697769 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_8 262.0 2.0 16.0   0.0 3.0     0.0   5.0   142.0 146.0     1.0   1.0     36.0   27.0   288.0 262 2 16   0 3     0   5   142 146     1 1   36 27   288
697773 697773 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_8 103.0 1.0 3.0   0.0 2.0     0.0   1.0   52.0 58.0     3.0   0.0     16.0   15.0   110.0 103 1 3   0 2     0   1   52 58     3 0   16 15   110
697777 697777 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_8 194.0 1.0 13.0   1.0 8.0     0.0   4.0   127.0 94.0     0.0   *     19.0   12.0   221.0 194 1 13   1 8     0   4   127 94     0     19 12   221
697781 697781 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_8 158.0 5.0 4.0   2.0 14.0     0.0   5.0   95.0 93.0     5.0   0.0     17.0   20.0   188.0 158 5 4   2 14     0   5   95 93     5 0   17 20   188
697785 697785 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_8 117.0 9.0 18.0   0.0 7.0     1.0   3.0   81.0 74.0         0.0         29.0   155.0 117 9 18   0 7     1   3   81 74       0     29   155
699831 699831 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_8 86.0 13.0 25.0   1.0 6.0     0.0   6.0   73.0 64.0     15.0   0.0     51.0   28.0   137.0 86 13 25   1 6     0   6   73 64     15 0   51 28   137
701664 701664 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_8 3.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 2.0         *         *   3.0 3 0 0   0 0     0   0   1 2                 3
702337 702337 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819004774 523 The Anicca Program Educational Oversight to Public Care and Treatment Day Program Alternative School No Other KG 12 2017   grade_8 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
689124 689124 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 2017   grade_8 54.0 0.0 1.0   13.0 1.0     0.0   2.0   37.0 34.0     1.0   0.0     34.0   12.0   71.0 54 0 1   13 1     0   2   37 34     1 0   34 12   71
697790 697790 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_8 7.0 0.0 3.0   51.0 0.0     0.0   4.0   38.0 27.0         *         *   65.0 7 0 3   51 0     0   4   38 27                 65
699834 699834 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 2017   grade_8 0.0 0.0 0.0   5.0 0.0     0.0   0.0   1.0 4.0         *         *   5.0 0 0 0   5 0     0   0   1 4                 5
697795 697795 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_8 64.0 0.0 2.0   0.0 0.0     0.0   0.0   33.0 33.0     0.0   0.0     31.0   13.0   66.0 64 0 2   0 0     0   0   33 33     0 0   31 13   66
689131 689131 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 2017   grade_8 7.0 0.0 0.0   3.0 1.0     0.0   0.0   8.0 3.0     0.0   0.0     7.0   3.0   11.0 7 0 0   3 1     0   0   8 3     0 0   7 3   11
697710 697710 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_8 448.0 12.0 21.0   2.0 22.0     0.0   10.0   248.0 267.0     7.0   4.0     81.0   76.0   515.0 448 12 21   2 22     0   10   248 267     7 4   81 76   515
701923 701923 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810004655 158 Pines School - ACS Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 08 12 2017   grade_8 0.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 0 0 1   0 0     0   0   1 0                 1
701931 701931 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_8 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
701937 701937 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810004620 161 Pines School - RJC Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 08 12 2017   grade_8 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
702249 702249 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810004616 162 PINES SCHOOL DAY PROGRAM Miscellaneous Program (assignment is now limited) Alternative School No High 08 12 2017   grade_8 0.0 1.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 0 1 0   0 0     0   0   1 0                 1
698765 698765 MN Chippewa 12 school 2721320 129 Independent Districts and Schools MONTEVIDEO PUBLIC SCHOOL DISTRICT 272132001072 40 MONTEVIDEO SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 08 12 2017   grade_8 62.0 1.0 18.0   1.0 0.0     1.0   6.0   39.0 50.0     7.0   0.0     42.0   17.0   89.0 62 1 18   1 0     1   6   39 50     7 0   42 17   89
697714 697714 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_8 27.0 79.0 72.0   2.0 11.0     2.0   10.0   116.0 87.0         *         *   203.0 27 79 72   2 11     2   10   116 87                 203
698663 698663 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951000396 16 COLUMBIA HEIGHTS SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 08 12 2017   grade_8 0.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 0.0         *         *   1.0 0 0 0   0 0     0   1   1 0                 1
697805 697805 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_8 197.0 3.0 4.0   2.0 3.0     0.0   3.0   115.0 97.0     0.0   *         *   212.0 197 3 4   2 3     0   3   115 97     0           212
699841 699841 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 2017   grade_8 22.0 0.0 2.0   0.0 0.0     0.0   1.0   20.0 5.0         0.0         0.0   25.0 22 0 2   0 0     0   1   20 5       0     0   25
701757 701757 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_8 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
689138 689138 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 2017   grade_8 68.0 1.0 2.0   1.0 2.0     0.0   0.0   37.0 37.0     0.0   1.0     31.0   6.0   74.0 68 1 2   1 2     0   0   37 37     0 1   31 6   74
697719 697719 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242000610 23 FRIDLEY MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_8 88.0 76.0 29.0   3.0 21.0     0.0   8.0   110.0 115.0         4.0         29.0   225.0 88 76 29   3 21     0   8   110 115       4     29   225
699754 699754 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_8 5.0 5.0 2.0   0.0 0.0     0.0   1.0   6.0 7.0         0.0         0.0   13.0 5 5 2   0 0     0   1   6 7       0     0   13
689145 689145 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 Other 06 12 2017   grade_8 74.0 0.0 0.0   1.0 1.0     0.0   1.0   37.0 40.0     0.0   0.0     13.0   12.0   77.0 74 0 0   1 1     0   1   37 40     0 0   13 12   77
697723 697723 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_8 297.0 4.0 11.0   2.0 15.0     0.0   7.0   160.0 176.0     10.0   0.0     85.0   *   336.0 297 4 11   2 15     0   7   160 176     10 0   85     336
699760 699760 MN Anoka 2 school 2733540 15 Independent Districts and Schools ST. FRANCIS PUBLIC SCHOOL DISTRICT 273354004980 18 Saints Academy Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2017   grade_8 36.0 0.0 1.0   0.0 0.0     0.0   1.0   22.0 16.0     0.0   *     14.0   0.0   38.0 36 0 1   0 0     0   1   22 16     0     14 0   38
701744 701744 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_8 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
702257 702257 MN Anoka 2 school 2733540 15 Independent Districts and Schools ST. FRANCIS PUBLIC SCHOOL DISTRICT 273354000268 850 CROSSROADS SCHOOL & VOC. CENTER Miscellaneous Program (assignment is now limited) Alternative School No Other KG 12 2017   grade_8 3.0 2.0 1.0   1.0 0.0     0.0   1.0   8.0 0.0         *         *   8.0 3 2 1   1 0     0   1   8 0                 8
689152 689152 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 2017   grade_8 80.0 0.0 1.0   0.0 0.0     0.0   3.0   40.0 44.0     0.0   0.0     10.0   15.0   84.0 80 0 1   0 0     0   3   40 44     0 0   10 15   84
697809 697809 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_8 356.0 34.0 38.0   9.0 5.0     0.0   27.0   256.0 213.0         *         *   469.0 356 34 38   9 5     0   27   256 213                 469
701968 701968 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_8 1.0 0.0 1.0   0.0 0.0     0.0   0.0   2.0 0.0         *         *   2.0 1 0 1   0 0     0   0   2 0                 2
689025 689025 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 2017   grade_8 8.0 2.0 0.0   0.0 0.0     0.0   2.0   5.0 7.0     0.0   0.0     2.0   0.0   12.0 8 2 0   0 0     0   2   5 7     0 0   2 0   12
697727 697727 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_8 224.0 43.0 61.0   1.0 32.0     2.0   26.0   194.0 195.0     30.0   2.0     176.0   45.0   389.0 224 43 61   1 32     2   26   194 195     30 2   176 45   389
700956 700956 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_8 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
700971 700971 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_8 3.0 1.0 1.0   0.0 0.0     0.0   0.0   3.0 2.0         *         *   5.0 3 1 1   0 0     0   0   3 2                 5
689159 689159 MN Clearwater 15 school 2703570 162 Independent Districts and Schools BAGLEY PUBLIC SCHOOL DISTRICT 270357000165 20 BAGLEY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_8 49.0 1.0 0.0   14.0 0.0     0.0   3.0   40.0 27.0     0.0   0.0     26.0   12.0   67.0 49 1 0   14 0     0   3   40 27     0 0   26 12   67
697813 697813 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_8 22.0 1.0 0.0   9.0 0.0     0.0   4.0   22.0 14.0     0.0   0.0     21.0   6.0   36.0 22 1 0   9 0     0   4   22 14     0 0   21 6   36
689166 689166 MN Cottonwood 17 school 2723010 173 Independent Districts and Schools MOUNTAIN LAKE PUBLIC SCHOOLS 272301001135 20 MOUNTAIN LAKE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_8 25.0 0.0 9.0   0.0 3.0     1.0   0.0   19.0 19.0     0.0   0.0     20.0   6.0   38.0 25 0 9   0 3     1   0   19 19     0 0   20 6   38
697819 697819 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_8 68.0 3.0 8.0   0.0 1.0     0.0   1.0   41.0 40.0     4.0   0.0     33.0   12.0   81.0 68 3 8   0 1     0   1   41 40     4 0   33 12   81
697824 697824 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609004196 22 FORESTVIEW MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_8 443.0 10.0 7.0   10.0 4.0     0.0   8.0   243.0 239.0     0.0   1.0         *   482.0 443 10 7   10 4     0   8   243 239     0 1         482
699859 699859 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_8 4.0 0.0 0.0   1.0 0.0     0.0   0.0   3.0 2.0         *         *   5.0 4 0 0   1 0     0   0   3 2                 5
702267 702267 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_8 8.0 0.0 0.0   0.0 0.0     0.0   0.0   8.0 0.0         *         *   8.0 8 0 0   0 0     0   0   8 0                 8
689173 689173 MN Crow Wing 18 school 2709750 182 Independent Districts and Schools CROSBY-IRONTON PUBLIC SCHOOL DIST. 270975000417 1 CROSBY-IRONTON SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_8 77.0 1.0 1.0   1.0 0.0     0.0   4.0   41.0 43.0     0.0   0.0     35.0   13.0   84.0 77 1 1   1 0     0   4   41 43     0 0   35 13   84
697829 697829 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_8 131.0 1.0 1.0   3.0 0.0     0.0   5.0   76.0 65.0     0.0   1.0     36.0   21.0   141.0 131 1 1   3 0     0   5   76 65     0 1   36 21   141
697833 697833 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000295 15 John Metcalf Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 78.0 19.0 18.0   1.0 8.0     0.0   8.0   71.0 61.0     13.0   2.0     47.0   21.0   132.0 78 19 18   1 8     0   8   71 61     13 2   47 21   132
697837 697837 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_8 99.0 23.0 17.0   0.0 24.0     0.0   12.0   88.0 87.0     14.0   0.0     54.0   16.0   175.0 99 23 17   0 24     0   12   88 87     14 0   54 16   175
697841 697841 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000297 85 Joseph Nicollet Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 54.0 24.0 16.0   0.0 12.0     2.0   8.0   53.0 63.0     5.0   3.0     49.0   10.0   116.0 54 24 16   0 12     2   8   53 63     5 3   49 10   116
699863 699863 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_8 70.0 75.0 71.0   0.0 8.0     2.0   28.0   115.0 139.0     56.0   2.0     177.0   40.0   254.0 70 75 71   0 8     2   28   115 139     56 2   177 40   254
691604 691604 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_8 11.0 0.0 0.0   0.0 0.0     0.0   1.0   5.0 7.0     0.0   0.0     0.0   3.0   12.0 11 0 0   0 0     0   1   5 7     0 0   0 3   12
697845 697845 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_8 205.0 6.0 19.0   2.0 14.0     0.0   6.0   131.0 121.0     4.0   0.0     46.0   32.0   252.0 205 6 19   2 14     0   6   131 121     4 0   46 32   252
697849 697849 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_8 258.0 6.0 13.0   2.0 17.0     0.0   5.0   155.0 146.0     5.0   0.0     47.0   45.0   301.0 258 6 13   2 17     0   5   155 146     5 0   47 45   301
697853 697853 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_8 272.0 3.0 17.0   0.0 10.0     0.0   14.0   164.0 152.0     0.0   *     34.0   39.0   316.0 272 3 17   0 10     0   14   164 152     0     34 39   316
697857 697857 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_8 180.0 19.0 18.0   0.0 16.0     0.0   6.0   131.0 108.0     7.0   1.0     40.0   42.0   239.0 180 19 18   0 16     0   6   131 108     7 1   40 42   239
697861 697861 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778002984 105 CENTURY MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 257.0 7.0 5.0   1.0 17.0     1.0   9.0   145.0 152.0     5.0   0.0     23.0   26.0   297.0 257 7 5   1 17     1   9   145 152     5 0   23 26   297
699872 699872 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778002804 590 LAKEVILLE AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No Other 06 12 2017   grade_8 5.0 1.0 0.0   0.0 0.0     0.0   0.0   4.0 2.0         *         *   6.0 5 1 0   0 0     0   0   4 2                 6
701770 701770 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_8 6.0 1.0 1.0   0.0 0.0     0.0   1.0   2.0 7.0         *         *   9.0 6 1 1   0 0     0   1   2 7                 9

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