enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
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
701202 701202 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002603897 500 917 DASH Special Education Special Education School No Other PK 12 2017   grade_8 2.0 0.0 1.0   0.0 0.0     0.0   0.0   3.0 0.0         *         *   3.0 2 0 1   0 0     0   0   3 0                 3
701153 701153 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002602121 51 917 INTRA-DAKOTA EDUCATIONAL ALT Special Education Special Education School No Other KG 12 2017   grade_8 0.0 1.0 1.0   1.0 0.0     0.0   0.0   1.0 2.0         *         *   3.0 0 1 1   1 0     0   0   1 2                 3
701177 701177 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002602125 61 917 PACES Special Education Special Education School No Other KG 12 2017   grade_8 4.0 0.0 0.0   0.0 1.0     0.0   0.0   5.0 0.0         *         *   5.0 4 0 0   0 1     0   0   5 0                 5
701191 701191 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002604218 400 917 SUN Special Education Special Education School No Other KG 12 2017   grade_8 4.0 0.0 0.0   1.0 0.0     0.0   1.0   3.0 3.0         *         *   6.0 4 0 0   1 0     0   1   3 3                 6
690130 690130 MN Meeker 47 school 2700106 2396 Independent Districts and Schools A.C.G.C. Public School District 270010602570 300 A.C.G.C. SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_8 47.0 0.0 4.0   1.0 0.0     0.0   0.0   32.0 20.0     2.0   0.0     26.0   11.0   52.0 47 0 4   1 0     0   0   32 20     2 0   26 11   52
698242 698242 MN Saint Louis 69 school 2730090 704 Independent Districts and Schools PROCTOR PUBLIC SCHOOL DISTRICT 273009001552 2 A.I. JEDLICKA MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 146.0 1.0 2.0   1.0 0.0     0.0   2.0   89.0 63.0     0.0   1.0     40.0   25.0   152.0 146 1 2   1 0     0   2   89 63     0 1   40 25   152
700604 700604 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520003593 45 ACHIEVE Special Education Special Education School No Other KG 12 2017   grade_8 1.0 3.0 0.0   0.0 0.0     0.0   0.0   2.0 2.0         *         *   4.0 1 3 0   0 0     0   0   2 2                 4
696722 696722 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_8 3.0 5.0 11.0   0.0 24.0     0.0   1.0   21.0 23.0     26.0   0.0         9.0   44.0 3 5 11   0 24     0   1   21 23     26 0     9   44
690224 690224 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_8 21.0 0.0 2.0   2.0 0.0     0.0   1.0   17.0 9.0     0.0   0.0     13.0   5.0   26.0 21 0 2   2 0     0   1   17 9     0 0   13 5   26
698111 698111 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_8 31.0 0.0 4.0   0.0 1.0     0.0   2.0   19.0 19.0     1.0   0.0     15.0   2.0   38.0 31 0 4   0 1     0   2   19 19     1 0   15 2   38
690395 690395 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA HIGH SCHOOL 270018603139 10 AFSA HIGH SCHOOL Secondary School (Grades 7-12) Regular School Yes High 07 12 2017   grade_8 35.0 2.0 4.0   0.0 2.0     0.0   5.0   27.0 21.0     0.0   0.0     12.0   12.0   48.0 35 2 4   0 2     0   5   27 21     0 0   12 12   48
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
702567 702567 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000063 50 ALBANY JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No Middle 07 08 2017   grade_8 131.0 1.0 3.0   0.0 1.0     1.0   4.0   65.0 76.0     1.0   1.0     33.0   17.0   141.0 131 1 3   0 1     1   4   65 76     1 1   33 17   141
698874 698874 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000068 310 ALBERT LEA SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 08 12 2017   grade_8 175.0 5.0 48.0   0.0 17.0     0.0   7.0   128.0 124.0         *         *   252.0 175 5 48   0 17     0   7   128 124                 252
689223 689223 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000080 1 ALDEN-CONGER SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_8 51.0 0.0 3.0   0.0 0.0     0.0   0.0   27.0 27.0     0.0   0.0     17.0   11.0   54.0 51 0 3   0 0     0   0   27 27     0 0   17 11   54
701096 701096 MN Ramsey 62 school 2702264 916 Intermediate Districts and Schools NORTHEAST METRO 916 270226402093 36 ALP @ CAPITOL VIEW CENTER Special Education Special Education School No Other 05 12 2017   grade_8 0.0 4.0 0.0   0.0 0.0     0.0   0.0   3.0 1.0         *         *   4.0 0 4 0   0 0     0   0   3 1                 4
694176 694176 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384002303 579 AMERICAN INDIAN MAGNET SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_8 7.0 14.0 8.0   7.0 21.0     0.0   2.0   25.0 34.0     25.0   2.0     50.0   10.0   59.0 7 14 8   7 21     0   2   25 34     25 2   50 10   59
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
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
698350 698350 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_8 111.0 0.0 2.0   0.0 0.0     0.0   3.0   60.0 56.0     1.0   0.0     27.0   19.0   116.0 111 0 2   0 0     0   3   60 56     1 0   27 19   116
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
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
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
690410 690410 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_8 17.0 0.0 0.0   0.0 0.0     0.0   0.0   10.0 7.0     0.0   0.0     2.0   12.0   17.0 17 0 0   0 0     0   0   10 7     0 0   2 12   17
702507 702507 MN Washington 82 school 2702264 916 Intermediate Districts and Schools NORTHEAST METRO 916 270226403646 35 ARIS 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   1.0 0.0         *         *   1.0 1 0 0   0 0     0   0   1 0                 1
702112 702112 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104001589 605 ARROWHEAD JUVENILE CENTER Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 04 12 2017   grade_8 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
689251 689251 MN Grant 26 school 2703300 261 Independent Districts and Schools ASHBY PUBLIC SCHOOL DISTRICT 270330000137 20 ASHBY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_8 26.0 0.0 0.0   0.0 0.0     0.0   0.0   13.0 13.0     0.0   0.0     11.0   4.0   26.0 26 0 0   0 0     0   0   13 13     0 0   11 4   26
697259 697259 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_8 16.0 1.0 0.0   0.0 1.0     0.0   0.0   10.0 8.0     1.0   0.0     3.0   2.0   18.0 16 1 0   0 1     0   0   10 8     1 0   3 2   18
698541 698541 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_8 0.0 0.0 39.0   0.0 0.0     0.0   0.0   20.0 19.0     19.0   0.0         4.0   39.0 0 0 39   0 0     0   0   20 19     19 0     4   39
700021 700021 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345002231 150 AUSTIN AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No Other 06 12 2017   grade_8 5.0 1.0 8.0   0.0 0.0     0.0   0.0   7.0 7.0     6.0   0.0     12.0   0.0   14.0 5 1 8   0 0     0   0   7 7     6 0   12 0   14
701364 701364 MN Rice 66 school 2700424 6094 Special Education Cooperatives Cannon Valley Special Education Cooperative 270042404938 10 Alexander Learning Academy Special Education Special Education School No Other KG 12 2017   grade_8 2.0 2.0 0.0   0.0 0.0     0.0   0.0   4.0 0.0         *         *   4.0 2 2 0   0 0     0   0   4 0                 4
697480 697480 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_8 11.0 0.0 0.0   0.0 0.0     0.0   0.0   8.0 3.0     0.0   0.0     2.0   1.0   11.0 11 0 0   0 0     0   0   8 3     0 0   2 1   11
696665 696665 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_8 10.0 31.0 5.0   0.0 4.0     0.0   5.0   35.0 20.0     2.0   0.0     33.0   10.0   55.0 10 31 5   0 4     0   5   35 20     2 0   33 10   55
698549 698549 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_8 18.0 1.0 2.0   3.0 1.0     0.0   0.0   18.0 7.0     0.0   0.0     9.0   9.0   25.0 18 1 2   3 1     0   0   18 7     0 0   9 9   25
689716 689716 MN Roseau 68 school 2703540 676 Independent Districts and Schools BADGER PUBLIC SCHOOL DISTRICT 270354000163 20 BADGER SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_8 25.0 1.0 0.0   0.0 0.0     0.0   0.0   10.0 16.0     0.0   0.0     9.0   1.0   26.0 25 1 0   0 0     0   0   10 16     0 0   9 1   26
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
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
689081 689081 MN Carlton 9 school 2703690 91 Independent Districts and Schools BARNUM PUBLIC SCHOOL DISTRICT 270369000172 2 BARNUM SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_8 59.0 1.0 0.0   0.0 1.0     0.0   3.0   36.0 28.0     0.0   0.0     23.0   10.0   64.0 59 1 0   0 1     0   3   36 28     0 0   23 10   64
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
698200 698200 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001556 310 BATTLE CREEK MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 23.0 67.0 37.0   5.0 95.0     0.0   9.0   140.0 96.0     109.0   9.0     190.0   34.0   236.0 23 67 37   5 95     0   9   140 96     109 9   190 34   236
689556 689556 MN Otter Tail 56 school 2703750 542 Independent Districts and Schools BATTLE LAKE PUBLIC SCHOOL DISTRICT 270375000176 20 BATTLE LAKE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_8 32.0 1.0 4.0   0.0 0.0     0.0   2.0   21.0 18.0     0.0   0.0     11.0   7.0   39.0 32 1 4   0 0     0   2   21 18     0 0   11 7   39
697034 697034 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_8 31.0 2.0 3.0   0.0 1.0     0.0   2.0   23.0 16.0     0.0   0.0     9.0   10.0   39.0 31 2 3   0 1     0   2   23 16     0 0   9 10   39
698271 698271 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_8 227.0 0.0 5.0   3.0 2.0     0.0   6.0   112.0 131.0     0.0   1.0     33.0   27.0   243.0 227 0 5   3 2     0   6   112 131     0 1   33 27   243
690123 690123 MN Stearns 73 school 2700105 2364 Independent Districts and Schools Belgrade-Brooten-Elrosa Public School District 270010502567 2 BELGRADE-BROOTEN-ELROSA SEC. Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_8 41.0 0.0 3.0   0.0 0.0     0.0   0.0   22.0 22.0     0.0   0.0     15.0   5.0   44.0 41 0 3   0 0     0   0   22 22     0 0   15 5   44
702548 702548 MN Scott 70 school 2704050 716 Independent Districts and Schools BELLE PLAINE PUBLIC SCHOOL DISTRICT 270405002169 30 BELLE PLAINE JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No Middle 07 08 2017   grade_8 116.0 1.0 7.0   1.0 4.0     0.0   3.0   69.0 63.0     2.0   0.0     21.0   19.0   132.0 116 1 7   1 4     0   3   69 63     2 0   21 19   132
701408 701408 MN Lyon 42 school 2700086 991 Service Cooperative (ECSU Region) Region 6 and 8-SW/WC Service Cooperative 270008604438 22 BELVIEW LEARNING CTR BRIDGES Special Education Special Education School No Other KG 12 2017   grade_8 3.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0         *         *   3.0 3 0 0   0 0     0   0   3 0                 3
700476 700476 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444004194 70 BEMIDJI BYLAW Special Education Special Education School No Other 06 12 2017   grade_8 0.0 0.0 0.0   1.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 0 0 0   1 0     0   0   1 0                 1
697736 697736 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_8 270.0 8.0 7.0   63.0 6.0     0.0   16.0   190.0 180.0         6.0     165.0   61.0   370.0 270 8 7   63 6     0   16   190 180       6   165 61   370
689833 689833 MN Swift 76 school 2704470 777 Independent Districts and Schools BENSON PUBLIC SCHOOL DISTRICT 270447000199 101 BENSON SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_8 67.0 0.0 7.0   0.0 1.0     0.0   0.0   38.0 37.0         *         *   75.0 67 0 7   0 1     0   0   38 37                 75
701603 701603 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_8 6.0 0.0 0.0   0.0 0.0     0.0   0.0   6.0 0.0         *         *   6.0 6 0 0   0 0     0   0   6 0                 6
701610 701610 MN Stearns 73 school 2700071 6383 Education Districts BENTON-STEARNS ED. DISTRICT 270007104581 40 BENTON-STEARNS EDUCATION CENTER Special Education Special Education School No Other 06 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
689840 689840 MN Todd 77 school 2705430 786 Independent Districts and Schools Bertha-Hewitt Public School District 270543000204 20 BERTHA SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_8 28.0 0.0 0.0   0.0 1.0     0.0   1.0   17.0 13.0     0.0   0.0     19.0   9.0   30.0 28 0 0   0 1     0   1   17 13     0 0   19 9   30
698275 698275 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_8 217.0 9.0 11.0   1.0 7.0     0.0   4.0   125.0 124.0     2.0   0.0     53.0   24.0   249.0 217 9 11   1 7     0   4   125 124     2 0   53 24   249
689322 689322 MN Itasca 31 school 2713170 318 Independent Districts and Schools GRAND RAPIDS PUBLIC SCHOOL DISTRICT 271317000934 350 BIGFORK SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_8 17.0 0.0 0.0   0.0 0.0     0.0   1.0   11.0 7.0     0.0   *         3.0   18.0 17 0 0   0 0     0   1   11 7     0       3   18
697869 697869 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_8 157.0 52.0 31.0   3.0 34.0     0.0   14.0   139.0 152.0     13.0   1.0     93.0   43.0   291.0 157 52 31   3 34     0   14   139 152     13 1   93 43   291
689039 689039 MN Beltrami 4 school 2705730 32 Independent Districts and Schools BLACKDUCK PUBLIC SCHOOL DISTRICT 270573000213 20 BLACKDUCK SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_8 34.0 2.0 0.0   7.0 0.0     0.0   2.0   22.0 23.0     0.0   4.0     27.0   8.0   45.0 34 2 0   7 0     0   2   22 23     0 4   27 8   45
689798 689798 MN Steele 74 school 2705760 756 Independent Districts and Schools BLOOMING PRAIRIE PUBLIC SCHOOL DIST 270576000215 20 BLOOMING PRAIRIE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_8 60.0 0.0 9.0   0.0 0.0     0.0   3.0   30.0 42.0     1.0   0.0     25.0   9.0   72.0 60 0 9   0 0     0   3   30 42     1 0   25 9   72
701435 701435 MN Pipestone 59 school 2700086 991 Service Cooperative (ECSU Region) Region 6 and 8-SW/WC Service Cooperative 270008604353 29 BLUE MOUND LEARNING CENTER Special Education Special Education 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
701900 701900 MN Dakota 19 school 2700193 4082 Charter Schools BLUESKY CHARTER SCHOOL 270019303146 10 BLUESKY CHARTER SCHOOL Distance Learning Program OLL (State approved) Regular School Yes High 07 12 2017   grade_8 20.0 1.0 0.0   0.0 2.0     0.0   0.0   11.0 12.0         2.0         *   23.0 20 1 0   0 2     0   0   11 12       2         23
696628 696628 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_8 13.0 1.0 0.0   0.0 0.0     0.0   0.0   5.0 9.0     0.0   0.0     6.0   3.0   14.0 13 1 0   0 0     0   0   5 9     0 0   6 3   14
700240 700240 MN Renville 65 school 2705660 2534 Independent Districts and Schools Bird Island-Olivia-Lake Lillian Public School District 270566004726 25 BOLD ALC Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2017   grade_8 2.0 0.0 2.0   0.0 0.0     0.0   0.0   2.0 2.0         *         *   4.0 2 0 2   0 0     0   0   2 2                 4
690144 690144 MN Renville 65 school 2705660 2534 Independent Districts and Schools Bird Island-Olivia-Lake Lillian Public School District 270566000147 20 BOLD SENIOR HIGH Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_8 36.0 0.0 5.0   0.0 0.0     0.0   2.0   29.0 14.0         *         *   43.0 36 0 5   0 0     0   2   29 14                 43
689307 689307 MN Isanti 30 school 2706060 314 Independent Districts and Schools BRAHAM PUBLIC SCHOOL DISTRICT 270606000247 1 BRAHAM AREA SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_8 59.0 0.0 0.0   0.0 1.0     0.0   3.0   38.0 25.0     0.0   0.0     23.0   6.0   63.0 59 0 0   0 1     0   3   38 25     0 0   23 6   63
698341 698341 MN Wilkin 84 school 2706150 846 Independent Districts and Schools BRECKENRIDGE PUBLIC SCHOOL DISTRICT 270615003005 20 BRECKENRIDGE MIDDLE Middle School (Grades 5-8) Regular School No Middle 07 08 2017   grade_8 37.0 0.0 1.0   1.0 0.0     0.0   0.0   24.0 15.0     0.0   0.0     15.0   6.0   39.0 37 0 1   1 0     0   0   24 15     0 0   15 6   39
700759 700759 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384002189 430 BRIDGE VIEW SPECIAL EDUCATION Special Education Special Education School No Other KG 12 2017   grade_8 4.0 7.0 1.0   1.0 1.0     0.0   0.0   8.0 6.0     5.0   1.0     6.0   *   14.0 4 7 1   1 1     0   0   8 6     5 1   6     14
689272 689272 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_8 21.0 59.0 37.0   1.0 22.0     0.0   10.0   67.0 83.0     25.0   6.0     124.0   18.0   150.0 21 59 37   1 22     0   10   67 83     25 6   124 18   150
689847 689847 MN Todd 77 school 2706300 787 Independent Districts and Schools BROWERVILLE PUBLIC SCHOOL DISTRICT 270630000278 20 BROWERVILLE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_8 47.0 0.0 3.0   0.0 0.0     0.0   0.0   34.0 16.0     0.0   0.0     23.0   7.0   50.0 47 0 3   0 0     0   0   34 16     0 0   23 7   50
698313 698313 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_8 8.0 0.0 0.0   1.0 0.0     0.0   0.0   5.0 4.0         *         *   9.0 8 0 0   1 0     0   0   5 4                 9
698354 698354 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_8 423.0 5.0 10.0   2.0 3.0     1.0   10.0   215.0 239.0         *     103.0   *   454.0 423 5 10   2 3     1   10   215 239           103     454
690031 690031 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_8 30.0 0.0 8.0   0.0 0.0     0.0   2.0   20.0 20.0     3.0   0.0     15.0   6.0   40.0 30 0 8   0 0     0   2   20 20     3 0   15 6   40
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
689890 689890 MN Watonwan 83 school 2707320 836 Independent Districts and Schools BUTTERFIELD PUBLIC SCHOOL DISTRICT 270732000305 30 BUTTERFIELD SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_8 3.0 0.0 5.0   0.0 0.0     0.0   0.0   3.0 5.0         *         *   8.0 3 0 5   0 0     0   0   3 5                 8
698120 698120 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_8 150.0 1.0 3.0   0.0 1.0     0.0   7.0   89.0 73.0     1.0   0.0     22.0   11.0   162.0 150 1 3   0 1     0   7   89 73     1 0   22 11   162
696704 696704 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703566 17 Banaadir Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_8 0.0 30.0 0.0   0.0 0.0     0.0   0.0   14.0 16.0     24.0   0.0         0.0   30.0 0 30 0   0 0     0   0   14 16     24 0     0   30
701085 701085 MN Ramsey 62 school 2702264 916 Intermediate Districts and Schools NORTHEAST METRO 916 270226402064 15 Bellaire Education Center Special Education Special Education School No Other 05 12 2017   grade_8 7.0 3.0 0.0   1.0 1.0     0.0   0.0   8.0 4.0     0.0   1.0     6.0   *   12.0 7 3 0   1 1     0   0   8 4     0 1   6     12
698607 698607 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_8 0.0 61.0 1.0   0.0 0.0     0.0   1.0   31.0 32.0     4.0   2.0     51.0   10.0   63.0 0 61 1   0 0     0   1   31 32     4 2   51 10   63
690237 690237 MN Faribault 22 school 2700130 2860 Independent Districts and Schools BLUE EARTH AREA PUBLIC SCHOOL 270013002498 20 Blue Earth Area Secondary Secondary School (Grades 7-12) Regular School No High 08 12 2017   grade_8 76.0 0.0 11.0   0.0 0.0     0.0   0.0   48.0 39.0     1.0   0.0     37.0   7.0   87.0 76 0 11   0 0     0   0   48 39     1 0   37 7   87
698490 698490 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_8 31.0 1.0 0.0   0.0 0.0     0.0   0.0   19.0 13.0     0.0   0.0     13.0   2.0   32.0 31 1 0   0 0     0   0   19 13     0 0   13 2   32
702059 702059 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004858 54 Brittany's Place Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other KG 12 2017   grade_8 0.0 0.0 0.0   1.0 0.0     0.0   0.0   0.0 1.0         *         *   1.0 0 0 0   1 0     0   0   0 1                 1
697974 697974 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001208 33 Brooklyn Middle School, a Science, Technology, Engineering, Art and Math School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 56.0 94.0 34.0   0.0 91.0     0.0   27.0   158.0 144.0     41.0   *     201.0   36.0   302.0 56 94 34   0 91     0   27   158 144     41     201 36   302
698022 698022 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_8 43.0 2.0 0.0   0.0 0.0     0.0   1.0   26.0 20.0     0.0   0.0     14.0   8.0   46.0 43 2 0   0 0     0   1   26 20     0 0   14 8   46
698382 698382 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_8 197.0 5.0 4.0   3.0 4.0     0.0   6.0   120.0 99.0         0.0     72.0   29.0   219.0 197 5 4   3 4     0   6   120 99       0   72 29   219
689919 689919 MN Wilkin 84 school 2707450 852 Independent Districts and Schools CAMPBELL-TINTAH PUBLIC SCHOOL DIST. 270745000320 20 CAMPBELL-TINTAH SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_8 12.0 0.0 0.0   0.0 0.0     0.0   1.0   5.0 8.0     0.0   0.0     8.0   4.0   13.0 12 0 0   0 0     0   1   5 8     0 0   8 4   13
689947 689947 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools CANBY PUBLIC SCHOOL DISTRICT 270747000322 10 CANBY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_8 36.0 1.0 1.0   0.0 0.0     0.0   0.0   20.0 18.0     0.0   0.0     15.0   4.0   38.0 36 1 1   0 0     0   0   20 18     0 0   15 4   38
697334 697334 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_8 11.0 1.0 2.0   0.0 0.0     0.0   2.0   10.0 6.0     2.0   0.0     2.0   3.0   16.0 11 1 2   0 0     0   2   10 6     2 0   2 3   16
694055 694055 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001594 494 CAPITOL HILL MAGNET/RONDO Elementary School (Grades PK-6) Regular School No Elementary 01 08 2017   grade_8 78.0 48.0 12.0   2.0 66.0     0.0   4.0   119.0 91.0     26.0   1.0     93.0   10.0   210.0 78 48 12   2 66     0   4   119 91     26 1   93 10   210
701330 701330 MN Mower 50 school 2700327 6083 Special Education Cooperatives SOUTHERN MN EDUCATION CONSORTIUM 270032705011 40 CARDS Program 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
702042 702042 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180002823 217 CARE & TREATMENT JDC/VON WALD Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 05 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
689089 689089 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_8 39.0 0.0 1.0   6.0 0.0     0.0   0.0   27.0 19.0     0.0   0.0     21.0   10.0   46.0 39 0 1   6 0     0   0   27 19     0 0   21 10   46
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
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
690195 690195 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_8 36.0 0.0 0.0   2.0 0.0     0.0   2.0   24.0 16.0     0.0   0.0     14.0   4.0   40.0 36 0 0   2 0     0   2   24 16     0 0   14 4   40
696639 696639 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_8 0.0 14.0 1.0   0.0 1.0     0.0   0.0   11.0 5.0         0.0         3.0   16.0 0 14 1   0 1     0   0   11 5       0     3   16
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
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
700095 700095 MN Ramsey 62 school 2742360 624 Independent Districts and Schools WHITE BEAR LAKE SCHOOL DISTRICT 274236003161 58 CENTRAL AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2017   grade_8 25.0 0.0 2.0   0.0 2.0     0.0   4.0   17.0 16.0     1.0   0.0     8.0   2.0   33.0 25 0 2   0 2     0   4   17 16     1 0   8 2   33
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
698161 698161 MN Polk 60 school 2711130 595 Independent Districts and Schools EAST GRAND FORKS PUBLIC SCHOOL DIST 271113000494 310 CENTRAL MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 105.0 7.0 14.0   0.0 1.0     0.0   6.0   65.0 68.0     7.0   0.0     35.0   20.0   133.0 105 7 14   0 1     0   6   65 68     7 0   35 20   133

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);