enrollments

Data source: Big Local News · About: Big Local

671 rows where grade = "grade_7", state = "MN" and year = 2015 sorted by district_state_type

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 671 ✖

grade ✖

  • grade_7 · 671 ✖
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
1147446 1147446 MN Sibley 72 school 2700092 4007 Charter Schools Minnesota New Country School 270009202487 10 MINNESOTA NEW COUNTRY SCHOOL Secondary School (Grades 7-12) Regular School Yes 3 07 12 2015   grade_7 15.0 0.0 1.0   0.0 0.0     0.0   1.0   11.0 6.0     0.0   0.0     5.0   3.0   17.0 15 0 1   0 0     0   1   11 6     0 0   5 3   17
1147453 1147453 MN Anoka 2 school 2700093 4008 Charter Schools PACT CHARTER SCHOOL 270009303030 30 PACT CHARTER SECONDARY Secondary School (Grades 7-12) Regular School Yes 3 07 12 2015   grade_7 46.0 1.0 4.0   0.0 1.0     0.0   1.0   27.0 26.0     0.0   0.0     8.0   11.0   53.0 46 1 4   0 1     0   1   27 26     0 0   8 11   53
1147466 1147466 MN Washington 82 school 2700167 4043 Charter Schools MATH AND SCIENCE ACADEMY 270016703035 10 MATH AND SCIENCE ACADEMY Secondary School (Grades 7-12) Regular School Yes 4 06 12 2015   grade_7 58.0 4.0 3.0   0.0 20.0     0.0   5.0   49.0 41.0     0.0   0.0     2.0   5.0   90.0 58 4 3   0 20     0   5   49 41     0 0   2 5   90
1147483 1147483 MN Houston 28 school 2700178 4054 Charter Schools LACRESCENT MONTESSORI ACADEMY 270017804750 20 La Crescent Secondary Montessori Academy Secondary School (Grades 7-12) Regular School Yes 3 07 12 2015   grade_7 4.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 4.0         *         *   4.0 4 0 0   0 0     0   0   0 4                 4
1147489 1147489 MN Winona 85 school 2700221 4064 Charter Schools RIVERWAY LEARNING COMMUNITY CHTR 270022103136 20 RIVERWAY SECONDARY Secondary School (Grades 7-12) Regular School Yes 3 07 12 2015   grade_7 7.0 1.0 1.0   0.0 0.0     0.0   0.0   5.0 4.0         *         *   9.0 7 1 1   0 0     0   0   5 4                 9
1147497 1147497 MN Blue Earth 7 school 2700226 4066 Charter Schools Kato Public Charter School 270022603471 10 Kato Public Charter School Secondary School (Grades 7-12) Regular School Yes 4 06 12 2015   grade_7 4.0 2.0 1.0   0.0 0.0     0.0   0.0   5.0 2.0         *         *   7.0 4 2 1   0 0     0   0   5 2                 7
1147504 1147504 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA HIGH SCHOOL 270018603139 10 AFSA HIGH SCHOOL Secondary School (Grades 7-12) Regular School Yes 3 07 12 2015   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0         *         *   1.0 1 0 0   0 0     0   0   0 1                 1
1147511 1147511 MN Rice 66 school 2700192 4081 Charter Schools DISCOVERY PUBLIC SCHOOL FARIBAULT 270019203145 10 DISCOVERY PUBLIC SCHOOL FARIBAULT Secondary School (Grades 7-12) Regular School Yes 4 06 12 2015   grade_7 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
1147519 1147519 MN Rice 66 school 2700355 4091 Charter Schools ARCADIA CHARTER SCHOOL 270035504151 10 ARCADIA CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes 4 06 12 2015   grade_7 20.0 1.0 0.0   0.0 1.0     0.0   0.0   14.0 8.0     0.0   0.0     3.0   5.0   22.0 20 1 0   0 1     0   0   14 8     0 0   3 5   22
1147526 1147526 MN Mcleod 43 school 2700214 4093 Charter Schools New Century Academy 270021403275 10 New Century Academy Secondary School (Grades 7-12) Regular School Yes 3 07 12 2015   grade_7 13.0 0.0 1.0   0.0 0.0     0.0   1.0   7.0 8.0     0.0   0.0     10.0   2.0   15.0 13 0 1   0 0     0   1   7 8     0 0   10 2   15
1147534 1147534 MN Ramsey 62 school 2700337 4098 Charter Schools Nova Classical Academy 270033704356 20 NOVA CLASSICAL ACADEMY UPPER SCHOOL Secondary School (Grades 7-12) Regular School Yes 4 06 12 2015   grade_7 63.0 4.0 4.0   0.0 5.0     0.0   2.0   37.0 41.0     1.0   0.0     12.0   6.0   78.0 63 4 4   0 5     0   2   37 41     1 0   12 6   78
1147547 1147547 MN Ramsey 62 school 2700344 4105 Charter Schools GREAT RIVER SCHOOL 270034404093 10 GREAT RIVER SCHOOL Secondary School (Grades 7-12) Regular School Yes 4 01 12 2015   grade_7 44.0 1.0 2.0   0.0 1.0     0.0   3.0   27.0 24.0     1.0   0.0     6.0   7.0   51.0 44 1 2   0 1     0   3   27 24     1 0   6 7   51
1147560 1147560 MN Hennepin 27 school 2700364 4122 Charter Schools EAGLE RIDGE ACADEMY CHARTER SCHOOL 270036404108 10 EAGLE RIDGE ACADEMY CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes 4 06 12 2015   grade_7 50.0 8.0 1.0   0.0 12.0     0.0   4.0   35.0 40.0     4.0   0.0     18.0   4.0   75.0 50 8 1   0 12     0   4   35 40     4 0   18 4   75
1147567 1147567 MN Itasca 31 school 2700256 4146 Charter Schools NORTHERN LIGHTS COMMUNITY SCHOOL 270025603314 10 NORTHERN LIGHTS COMMUNITY SCHOOL Secondary School (Grades 7-12) Regular School Yes 4 06 12 2015   grade_7 4.0 0.0 0.0   2.0 0.0     0.0   1.0   3.0 4.0         *         *   7.0 4 0 0   2 0     0   1   3 4                 7
1147574 1147574 MN Sherburne 71 school 2700276 4160 Charter Schools SPECTRUM HIGH SCHOOL 270027603615 10 SPECTRUM HIGH SCHOOL Secondary School (Grades 7-12) Regular School Yes 3 07 12 2015   grade_7 93.0 2.0 2.0   0.0 1.0     0.0   4.0   40.0 62.0     2.0   0.0     19.0   15.0   102.0 93 2 2   0 1     0   4   40 62     2 0   19 15   102
1147581 1147581 MN Hennepin 27 school 2700315 4183 Charter Schools LIONSGATE ACADEMY 270031504325 10 LIONSGATE ACADEMY Secondary School (Grades 7-12) Regular School Yes 3 07 12 2015   grade_7 18.0 0.0 0.0   0.0 2.0     0.0   1.0   18.0 3.0     0.0   0.0     2.0   *   21.0 18 0 0   0 2     0   1   18 3     0 0   2     21
1147589 1147589 MN Unknown   school 2700367 4200 Charter Schools STEP ACADEMY CHARTER SCHOOL 270036704507 10 STEP ACADEMY CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes 4 06 12 2015   grade_7 0.0 50.0 0.0   0.0 1.0     0.0   0.0   27.0 24.0     7.0   0.0         1.0   51.0 0 50 0   0 1     0   0   27 24     7 0     1   51
1147596 1147596 MN Saint Louis 69 school 2700372 4207 Charter Schools Vermilion Country School 270037204555 10 Vermilion Country School Secondary School (Grades 7-12) Regular School Yes 3 07 12 2015   grade_7 4.0 0.0 0.0   2.0 0.0     0.0   0.0   5.0 1.0         *         *   6.0 4 0 0   2 0     0   0   5 1                 6
1147603 1147603 MN Kandiyohi 34 school 2700389 4217 Charter Schools TECHNICAL ACADEMIES OF MINNESOTA 270038904696 10 DREAM Technical Academy Secondary School (Grades 7-12) Regular School Yes 3 07 12 2015   grade_7 17.0 0.0 6.0   0.0 0.0     0.0   1.0   9.0 15.0     0.0   0.0     13.0   3.0   24.0 17 0 6   0 0     0   1   9 15     0 0   13 3   24
1153610 1153610 MN Winona 85 school 2705850 4001 Charter Schools BLUFFVIEW MONTESSORI 270585000018 10 BLUFFVIEW MONTESSORI Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 14.0 0.0 0.0   0.0 0.0     0.0   0.0   8.0 6.0     0.0   0.0     2.0   0.0   14.0 14 0 0   0 0     0   0   8 6     0 0   2 0   14
1153620 1153620 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 1 KG 08 2015   grade_7 1.0 11.0 0.0   0.0 0.0     0.0   1.0   6.0 7.0     4.0   0.0         1.0   13.0 1 11 0   0 0     0   1   6 7     4 0     1   13
1153646 1153646 MN Hennepin 27 school 2700096 4011 Charter Schools Athlos Leadership Academy 270009601892 10 Athlos Leadership Academy Elementary School (Grades PK-6) Regular School Yes 1 PK 08 2015   grade_7 36.0 32.0 6.0   0.0 2.0     0.0   5.0   43.0 38.0     12.0   2.0     45.0   14.0   81.0 36 32 6   0 2     0   5   43 38     12 2   45 14   81
1153656 1153656 MN Ramsey 62 school 2700115 4015 Charter Schools COMMUNITY OF PEACE ACADEMY 270011502605 10 COMMUNITY OF PEACE ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 3.0 18.0 18.0   1.0 33.0     0.0   2.0   33.0 42.0     12.0   2.0         8.0   75.0 3 18 18   1 33     0   2   33 42     12 2     8   75
1153665 1153665 MN Carver 10 school 2700116 4016 Charter Schools WORLD LEARNER CHARTER SCHOOL 270011602606 10 WORLD LEARNER CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes 1 01 08 2015   grade_7 24.0 1.0 0.0   0.0 0.0     0.0   0.0   13.0 12.0     0.0   0.0     4.0   7.0   25.0 24 1 0   0 0     0   0   13 12     0 0   4 7   25
1153682 1153682 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703566 17 Banaadir Academy Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 0.0 31.0 0.0   0.0 0.0     0.0   0.0   13.0 18.0     24.0   0.0         *   31.0 0 31 0   0 0     0   0   13 18     24 0         31
1153692 1153692 MN Ramsey 62 school 2700118 4018 Charter Schools ACHIEVE LANGUAGE ACADEMY 270011802608 10 ACHIEVE LANGUAGE ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 PK 08 2015   grade_7 7.0 5.0 14.0   0.0 22.0     0.0   0.0   26.0 22.0     25.0   0.0     36.0   6.0   48.0 7 5 14   0 22     0   0   26 22     25 0   36 6   48
1153702 1153702 MN Saint Louis 69 school 2700133 4020 Charter Schools DULUTH PUBLIC SCHOOLS ACADEMY 270013302711 10 NORTH STAR ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 111.0 5.0 3.0   5.0 3.0     0.0   13.0   74.0 66.0     1.0   0.0     46.0   24.0   140.0 111 5 3   5 3     0   13   74 66     1 0   46 24   140
1153719 1153719 MN Ramsey 62 school 2700140 4027 Charter Schools HIGHER GROUND ACADEMY 270014002719 10 HIGHER GROUND ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 0.0 72.0 0.0   0.0 0.0     0.0   0.0   40.0 32.0     10.0   0.0         2.0   72.0 0 72 0   0 0     0   0   40 32     10 0     2   72
1153736 1153736 MN Hennepin 27 school 2700151 4030 Charter Schools ODYSSEY ACADEMY 270015102946 10 ODYSSEY ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 4.0 17.0 2.0   0.0 1.0     0.0   1.0   15.0 10.0     3.0   0.0     21.0   6.0   25.0 4 17 2   0 1     0   1   15 10     3 0   21 6   25
1153760 1153760 MN Hennepin 27 school 2700159 4038 Charter Schools SOJOURNER TRUTH ACADEMY 270015902954 10 SOJOURNER TRUTH ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 1.0 31.0 15.0   0.0 0.0     0.0   2.0   22.0 27.0     10.0   1.0         8.0   49.0 1 31 15   0 0     0   2   22 27     10 1     8   49
1153770 1153770 MN Nicollet 52 school 2700174 4050 Charter Schools LAFAYETTE PUBLIC CHARTER SCHOOL 270017403042 10 LAFAYETTE PUBLIC CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 5.0 0.0 1.0   0.0 0.0     0.0   1.0   4.0 3.0         *         *   7.0 5 0 1   0 0     0   1   4 3                 7
1153777 1153777 MN Nicollet 52 school 2700174 4050 Charter Schools LAFAYETTE PUBLIC CHARTER SCHOOL 270017404126 20 STARLAND ELEMENTARY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 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
1153801 1153801 MN Beltrami 4 school 2700225 4058 Charter Schools SCHOOLCRAFT LEARNING COMMUNITY CHTR 270022503464 10 SCHOOLCRAFT LEARNING COMMUNITY CHTR Elementary School (Grades PK-6) Regular School Yes 4 KG 09 2015   grade_7 11.0 0.0 0.0   5.0 0.0     0.0   1.0   6.0 11.0     0.0   0.0     9.0   2.0   17.0 11 0 0   5 0     0   1   6 11     0 0   9 2   17
1153811 1153811 MN Crow Wing 18 school 2700218 4059 Charter Schools CROSSLAKE COMMUNITY CHARTER SCHOOL 270021803475 10 CROSSLAKE COMMUNITY CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 16.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 9.0     0.0   0.0     6.0   2.0   16.0 16 0 0   0 0     0   0   7 9     0 0   6 2   16
1153835 1153835 MN Hennepin 27 school 2700184 4068 Charter Schools EXCELL ACADEMY CHARTER 270018403137 10 EXCELL ACADEMY CHARTER Elementary School (Grades PK-6) Regular School Yes 1 PK 08 2015   grade_7 0.0 21.0 0.0   0.0 0.0     0.0   0.0   6.0 15.0     6.0   1.0         4.0   21.0 0 21 0   0 0     0   0   6 15     6 1     4   21
1153845 1153845 MN Ramsey 62 school 2700230 4070 Charter Schools HOPE COMMUNITY ACADEMY 270023003482 10 HOPE COMMUNITY ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 1.0 2.0 0.0   0.0 37.0     0.0   0.0   24.0 16.0     16.0   0.0     35.0   7.0   40.0 1 2 0   0 37     0   0   24 16     16 0   35 7   40
1153892 1153892 MN Hennepin 27 school 2700210 4086 Charter Schools WOODSON INSTITUTE FOR EXCELLENCE CH 270021003271 10 WOODSON INSTITUTE FOR EXCELLENCE CH Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 0.0 21.0 0.0   0.0 0.0     0.0   0.0   11.0 10.0     0.0   2.0         6.0   21.0 0 21 0   0 0     0   0   11 10     0 2     6   21
1153911 1153911 MN Hennepin 27 school 2700354 4089 Charter Schools NEW CITY SCHOOL 270035404849 20 New City School - East Campus Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 9.0 3.0 1.0   0.0 1.0     0.0   1.0   9.0 6.0     1.0   0.0     8.0   2.0   15.0 9 3 1   0 1     0   1   9 6     1 0   8 2   15
1153942 1153942 MN Cook 16 school 2700339 4100 Charter Schools GREAT EXPECTATIONS 270033904177 10 GREAT EXPECTATIONS Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 10.0 0.0 1.0   0.0 0.0     0.0   0.0   7.0 4.0     0.0   0.0     3.0   2.0   11.0 10 0 1   0 0     0   0   7 4     0 0   3 2   11
1153952 1153952 MN Ramsey 62 school 2700342 4103 Charter Schools HMONG COLLEGE PREP ACADEMY 270034203700 20 HMONG COLLEGE PREP MIDDLE ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 0.0 1.0 0.0   0.0 94.0     0.0   0.0   52.0 43.0     43.0   2.0     83.0   12.0   95.0 0 1 0   0 94     0   0   52 43     43 2   83 12   95
1154005 1154005 MN Hennepin 27 school 2700366 4124 Charter Schools BEACON ACADEMY 270036604110 10 BEACON ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 29.0 4.0 5.0   0.0 1.0     0.0   4.0   19.0 24.0     1.0   0.0     11.0   11.0   43.0 29 4 5   0 1     0   4   19 24     1 0   11 11   43
1154030 1154030 MN Olmsted 55 school 2700247 4135 Charter Schools ROCHESTER MATH AND SCIENCE ACADEMY 270024703308 10 ROCHESTER MATH AND SCIENCE ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 0.0 27.0 0.0   0.0 0.0     0.0   0.0   12.0 15.0     22.0   0.0         0.0   27.0 0 27 0   0 0     0   0   12 15     22 0     0   27
1154054 1154054 MN Hennepin 27 school 2700273 4139 Charter Schools LOVEWORKS ACADEMY FOR ARTS 270027303575 10 LOVEWORKS ACADEMY FOR ARTS Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 0.0 21.0 0.0   0.0 0.0     0.0   0.0   10.0 11.0     0.0   0.0         7.0   21.0 0 21 0   0 0     0   0   10 11     0 0     7   21
1154064 1154064 MN Hennepin 27 school 2700281 4140 Charter Schools YINGHUA ACADEMY 270028103611 10 YINGHUA ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 11.0 0.0 0.0   1.0 13.0     0.0   0.0   11.0 14.0     0.0   0.0     4.0   5.0   25.0 11 0 0   1 13     0   0   11 14     0 0   4 5   25
1154074 1154074 MN Dakota 19 school 2700251 4141 Charter Schools PAIDEIA ACADEMY CHARTER SCHOOL 270025103576 10 PAIDEIA ACADEMY CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 20.0 3.0 0.0   0.0 2.0     0.0   4.0   11.0 18.0     0.0   0.0     6.0   7.0   29.0 20 3 0   0 2     0   4   11 18     0 0   6 7   29
1154089 1154089 MN Hennepin 27 school 2700253 4143 Charter Schools NEW MILLENNIUM ACADEMY CHARTER SCH 270025303311 10 New Millenium Academy Charter School Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 0.0 1.0 0.0   1.0 33.0     0.0   0.0   19.0 16.0     30.0   0.0         9.0   35.0 0 1 0   1 33     0   0   19 16     30 0     9   35
1154114 1154114 MN Ramsey 62 school 2700262 4152 Charter Schools Twin Cities German Immersion Charter School 270026203578 10 Twin Cities German Immersion Charter School Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 25.0 0.0 0.0   0.0 0.0     0.0   2.0   8.0 19.0     1.0   0.0     2.0   5.0   27.0 25 0 0   0 0     0   2   8 19     1 0   2 5   27
1154124 1154124 MN Ramsey 62 school 2700263 4153 Charter Schools DUGSI ACADEMY 270026303320 10 DUGSI ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 0.0 24.0 0.0   0.0 0.0     0.0   0.0   13.0 11.0     12.0   0.0         1.0   24.0 0 24 0   0 0     0   0   13 11     12 0     1   24
1154157 1154157 MN Hennepin 27 school 2700278 4162 Charter Schools SOUTHSIDE FAMILY CHARTER SCHOOL 270027803617 10 SOUTHSIDE FAMILY CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 3.0 2.0 3.0   0.0 0.0     0.0   2.0   2.0 8.0     0.0   0.0     6.0   4.0   10.0 3 2 3   0 0     0   2   2 8     0 0   6 4   10
1154200 1154200 MN Hennepin 27 school 2700295 4171 Charter Schools NOBLE ACADEMY 270029503727 10 NOBLE ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 0.0 5.0 1.0   0.0 32.0     0.0   0.0   22.0 16.0     32.0   1.0     30.0   3.0   38.0 0 5 1   0 32     0   0   22 16     32 1   30 3   38
1154218 1154218 MN Ramsey 62 school 2700304 4181 Charter Schools COMMUNITY SCHOOL OF EXCELLENCE 270030403728 10 COMMUNITY SCHOOL OF EXCELLENCE Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 1.0 0.0 0.0   0.0 92.0     0.0   1.0   57.0 37.0     64.0   0.0         16.0   94.0 1 0 0   0 92     0   1   57 37     64 0     16   94
1154228 1154228 MN Scott 70 school 2700311 4184 Charter Schools ASPEN ACADEMY 270031104282 10 ASPEN ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 46.0 4.0 1.0   0.0 1.0     0.0   1.0   26.0 27.0     8.0   0.0     13.0   2.0   53.0 46 4 1   0 1     0   1   26 27     8 0   13 2   53
1154238 1154238 MN Anoka 2 school 2700320 4185 Charter Schools DAVINCI ACADEMY 270032004268 10 DAVINCI ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 31.0 4.0 1.0   1.0 4.0     0.0   0.0   21.0 20.0     0.0   0.0     8.0   4.0   41.0 31 4 1   1 4     0   0   21 20     0 0   8 4   41
1154248 1154248 MN Anoka 2 school 2700313 4186 Charter Schools GLOBAL ACADEMY 270031304294 10 GLOBAL ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 14.0 35.0 0.0   0.0 0.0     0.0   0.0   24.0 25.0     13.0   0.0         5.0   49.0 14 35 0   0 0     0   0   24 25     13 0     5   49
1154265 1154265 MN Carver 10 school 2700319 4188 Charter Schools COLOGNE ACADEMY 270031904320 10 COLOGNE ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 20.0 0.0 1.0   0.0 0.0     0.0   0.0   9.0 12.0     0.0   0.0     2.0   3.0   21.0 20 0 1   0 0     0   0   9 12     0 0   2 3   21
1154283 1154283 MN Hennepin 27 school 2700309 4192 Charter Schools BEST ACADEMY 270030904261 10 BEST ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 0.0 78.0 0.0   0.0 0.0     0.0   0.0   42.0 36.0     3.0   0.0         7.0   78.0 0 78 0   0 0     0   0   42 36     3 0     7   78
1154301 1154301 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 1 KG 08 2015   grade_7 12.0 1.0 3.0   0.0 0.0     0.0   0.0   7.0 9.0     0.0   1.0     5.0   1.0   16.0 12 1 3   0 0     0   0   7 9     0 1   5 1   16
1154346 1154346 MN Hennepin 27 school 2700378 4208 Charter Schools NASHA SHKOLA CHARTER SCHOOL 270037804635 10 NASHA SHKOLA CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 10.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 7.0         0.0     7.0   1.0   10.0 10 0 0   0 0     0   0   3 7       0   7 1   10
1155341 1155341 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703261 11 MINNESOTA TRANSITIONS MIDDLE Middle School (Grades 5-8) Regular School Yes 2 06 08 2015   grade_7 0.0 14.0 4.0   4.0 0.0     0.0   1.0   12.0 11.0         *         7.0   23.0 0 14 4   4 0     0   1   12 11             7   23
1155345 1155345 MN Ramsey 62 school 2700142 4029 Charter Schools ST. PAUL CITY SCHOOL 270014204150 20 ST. PAUL CITY MIDDLE SCHOOL Middle School (Grades 5-8) Regular School Yes 2 06 08 2015   grade_7 0.0 8.0 17.0   0.0 12.0     0.0   0.0   20.0 17.0     25.0   0.0         7.0   37.0 0 8 17   0 12     0   0   20 17     25 0     7   37
1155349 1155349 MN Ramsey 62 school 2700166 4042 Charter Schools Twin Cities Academy 270016603034 10 TWIN CITIES ACADEMY Middle School (Grades 5-8) Regular School Yes 2 06 08 2015   grade_7 38.0 16.0 11.0   0.0 6.0     0.0   6.0   39.0 38.0     3.0   0.0     36.0   11.0   77.0 38 16 11   0 6     0   6   39 38     3 0   36 11   77
1155354 1155354 MN Washington 82 school 2700177 4053 Charter Schools NORTH LAKES ACADEMY 270017703045 10 NORTH LAKES ACADEMY Middle School (Grades 5-8) Regular School Yes 2 05 08 2015   grade_7 56.0 2.0 2.0   0.0 2.0     0.0   2.0   34.0 30.0     0.0   0.0     16.0   14.0   64.0 56 2 2   0 2     0   2   34 30     0 0   16 14   64
1155359 1155359 MN Hennepin 27 school 2700220 4067 Charter Schools AURORA CHARTER SCHOOL 270022004420 20 AURORA MIDDLE SCHOOL Middle School (Grades 5-8) Regular School Yes 2 05 08 2015   grade_7 0.0 0.0 45.0   0.0 0.0     0.0   0.0   20.0 25.0     18.0   0.0         1.0   45.0 0 0 45   0 0     0   0   20 25     18 0     1   45
1155364 1155364 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA HIGH SCHOOL 270018604854 20 AFSA Middle School Middle School (Grades 5-8) Regular School Yes 2 05 08 2015   grade_7 28.0 4.0 2.0   0.0 2.0     0.0   6.0   26.0 16.0         *         *   42.0 28 4 2   0 2     0   6   26 16                 42
1155367 1155367 MN Ramsey 62 school 2700187 4075 Charter Schools AVALON SCHOOL 270018704664 20 Avalon Middle School Middle School (Grades 5-8) Regular School Yes 2 06 08 2015   grade_7 19.0 1.0 1.0   0.0 3.0     0.0   0.0   17.0 7.0     0.0   1.0     6.0   8.0   24.0 19 1 1   0 3     0   0   17 7     0 1   6 8   24
1155372 1155372 MN Hennepin 27 school 2700189 4078 Charter Schools Minnesota International Middle Charter 270018903142 10 Minnesota International Middle Charter School Middle School (Grades 5-8) Regular School Yes 2 05 08 2015   grade_7 1.0 99.0 0.0   0.0 0.0     0.0   0.0   51.0 49.0     64.0   2.0         10.0   100.0 1 99 0   0 0     0   0   51 49     64 2     10   100
1155376 1155376 MN Beltrami 4 school 2700345 4106 Charter Schools TREKNORTH HIGH SCHOOL 270034504666 20 Trek North Middle School Middle School (Grades 5-8) Regular School Yes 2 06 08 2015   grade_7 14.0 0.0 4.0   12.0 0.0     0.0   5.0   17.0 18.0     0.0   0.0     25.0   3.0   35.0 14 0 4   12 0     0   5   17 18     0 0   25 3   35
1155380 1155380 MN Beltrami 4 school 2700346 4107 Charter Schools VOYAGEURS EXPEDITIONARY 270034604667 20 Voyageurs Expeditionary MS Middle School (Grades 5-8) Regular School Yes 2 06 08 2015   grade_7 1.0 1.0 0.0   6.0 0.0     0.0   0.0   2.0 6.0         *         *   8.0 1 1 0   6 0     0   0   2 6                 8
1155385 1155385 MN Hennepin 27 school 2700357 4115 Charter Schools MINNEAPOLIS ACADEMY CHARTER SCHOOL 270035704101 10 MINNEAPOLIS ACADEMY CHARTER SCHOOL Middle School (Grades 5-8) Regular School Yes 2 05 08 2015   grade_7 3.0 14.0 22.0   1.0 1.0     0.0   0.0   17.0 24.0     16.0   0.0         6.0   41.0 3 14 22   1 1     0   0   17 24     16 0     6   41
1155390 1155390 MN Washington 82 school 2700362 4120 Charter Schools ST. CROIX PREPARATORY ACADEMY 270036204222 20 ST CROIX PREPARATORY ACADEMY MIDDLE Middle School (Grades 5-8) Regular School Yes 2 05 08 2015   grade_7 81.0 1.0 4.0   0.0 5.0     0.0   0.0   39.0 52.0     0.0   0.0     7.0   4.0   91.0 81 1 4   0 5     0   0   39 52     0 0   7 4   91
1155394 1155394 MN Hennepin 27 school 2700240 4126 Charter Schools PRAIRIE SEEDS ACADEMY 270024004805 30 Prairie Seeds Middle School Academy Middle School (Grades 5-8) Regular School Yes 2 06 08 2015   grade_7 0.0 11.0 4.0   0.0 48.0     0.0   2.0   35.0 30.0     24.0   2.0     46.0   7.0   65.0 0 11 4   0 48     0   2   35 30     24 2   46 7   65
1155400 1155400 MN Stearns 73 school 2700252 4142 Charter Schools Stride Academy Charter School 270025204405 20 STRIDE ACADEMY MIDDLE SCHOOL Middle School (Grades 5-8) Regular School Yes 2 04 08 2015   grade_7 30.0 13.0 0.0   0.0 0.0     0.0   0.0   29.0 14.0     8.0   1.0     30.0   15.0   43.0 30 13 0   0 0     0   0   29 14     8 1   30 15   43
1155404 1155404 MN Hennepin 27 school 2700284 4159 Charter Schools Seven Hills Preparatory Academy 270028404804 20 Seven Hills Preparatory Academy Upper School Middle School (Grades 5-8) Regular School Yes 2 06 08 2015   grade_7 45.0 5.0 12.0   0.0 0.0     0.0   5.0   31.0 36.0     0.0   1.0     20.0   9.0   67.0 45 5 12   0 0     0   5   31 36     0 1   20 9   67
1155411 1155411 MN Ramsey 62 school 2700292 4164 Charter Schools LAURA JEFFREY ACADEMY CHARTER 270029203713 10 LAURA JEFFREY ACADEMY CHARTER Middle School (Grades 5-8) Regular School Yes 2 05 08 2015   grade_7 15.0 15.0 4.0   0.0 5.0     0.0   6.0   0.0 45.0     0.0   0.0     25.0   16.0   45.0 15 15 4   0 5     0   6   0 45     0 0   25 16   45
1155416 1155416 MN Hennepin 27 school 2700288 4170 Charter Schools HIAWATHA ACADEMIES 270028804599 11 Hiawatha College Prep Middle School (Grades 5-8) Regular School Yes 2 05 08 2015   grade_7 1.0 3.0 79.0   1.0 0.0     0.0   0.0   46.0 38.0     68.0   1.0         7.0   84.0 1 3 79   1 0     0   0   46 38     68 1     7   84
1155421 1155421 MN Hennepin 27 school 2700308 4191 Charter Schools KIPP MINNESOTA CHARTER SCHOOL 270030804244 10 KIPP MINNESOTA CHARTER SCHOOL Middle School (Grades 5-8) Regular School Yes 2 05 08 2015   grade_7 1.0 57.0 1.0   0.0 0.0     0.0   1.0   33.0 27.0     0.0   1.0         13.0   60.0 1 57 1   0 0     0   1   33 27     0 1     13   60
1155426 1155426 MN Hennepin 27 school 2700333 4199 Charter Schools PARNASSUS PREPARATORY CHARTER SCH 270033304837 20 Parnassus Preparatory School-Logic Middle School (Grades 5-8) Regular School Yes 2 05 08 2015   grade_7 25.0 10.0 1.0   0.0 3.0     0.0   5.0   13.0 31.0     3.0   0.0     10.0   3.0   44.0 25 10 1   0 3     0   5   13 31     3 0   10 3   44
1155430 1155430 MN Ramsey 62 school 2700376 4210 Charter Schools Upper Mississippi Academy 270037604693 20 Upper Mississippi Middle Academy Middle School (Grades 5-8) Regular School Yes 2 06 08 2015   grade_7 91.0 13.0 14.0   0.0 1.0     0.0   9.0   88.0 40.0         *         *   128.0 91 13 14   0 1     0   9   88 40                 128
1155433 1155433 MN Hennepin 27 school 2700384 4218 Charter Schools Venture Academy 270038404697 10 Venture Academy Middle School (Grades 5-8) Regular School Yes 2 06 08 2015   grade_7 4.0 13.0 48.0   7.0 5.0     0.0   3.0   48.0 32.0     36.0   3.0     71.0   17.0   80.0 4 13 48   7 5     0   3   48 32     36 3   71 17   80
1156377 1156377 MN Ramsey 62 school 2700152 4031 Charter Schools JENNINGS COMMUNITY LEARNING CENTER 270015202947 10 JENNINGS EXPERIENTIAL HIGH SCHOOL Senior High School (Grades 9-12) Regular School Yes 3 07 12 2015   grade_7 0.0 1.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0         *         *   1.0 0 1 0   0 0     0   0   0 1                 1
1156495 1156495 MN Hennepin 27 school 2700245 4131 Charter Schools METRO SCHOOLS CHARTER 270024503573 10 METRO SCHOOLS CHARTER Senior High School (Grades 9-12) Regular School Yes 4 05 12 2015   grade_7 0.0 25.0 0.0   0.0 0.0     0.0   0.0   10.0 15.0     20.0   0.0         6.0   25.0 0 25 0   0 0     0   0   10 15     20 0     6   25
1156533 1156533 MN Ramsey 62 school 2700376 4210 Charter Schools Upper Mississippi Academy 270037604694 30 Upper Mississippi High Academy Senior High School (Grades 9-12) Regular School Yes 3 07 12 2015   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1158167 1158167 MN Ramsey 62 school 2700028 4005 Charter Schools METRO DEAF SCHOOL 270002802341 10 METRO DEAF SCHOOL Special Education Special Education School Yes 4 PK 12 2015   grade_7 1.0 1.0 1.0   0.0 0.0     0.0   0.0   1.0 2.0         *         *   3.0 1 1 1   0 0     0   0   1 2                 3
1158540 1158540 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703264 14 VIRTUAL HIGH SCHOOL Distance Learning Program OLL (State approved) Regular School Yes 4 06 12 2015   grade_7 7.0 0.0 1.0   0.0 0.0     0.0   0.0   4.0 4.0         *         *   8.0 7 0 1   0 0     0   0   4 4                 8
1158554 1158554 MN Ramsey 62 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703694 18 MTCS CONNECTIONS ACADEMY Distance Learning Program OLL (State approved) Regular School Yes 4 KG 12 2015   grade_7 147.0 1.0 2.0   1.0 3.0     1.0   3.0   74.0 84.0     5.0   0.0     61.0   14.0   158.0 147 1 2   1 3     1   3   74 84     5 0   61 14   158
1158565 1158565 MN Ramsey 62 school 2700138 4025 Charter Schools CYBER VILLAGE ACADEMY 270013802717 10 CYBER VILLAGE ACADEMY Distance Learning Program OLL (State approved) Regular School Yes 4 03 12 2015   grade_7 20.0 0.0 4.0   0.0 0.0     0.0   2.0   13.0 13.0     0.0   0.0     8.0   6.0   26.0 20 0 4   0 0     0   2   13 13     0 0   8 6   26
1158577 1158577 MN Unknown   school 2700193 4082 Charter Schools BLUESKY CHARTER SCHOOL 270019303146 10 BLUESKY CHARTER SCHOOL Distance Learning Program OLL (State approved) Regular School Yes 3 07 12 2015   grade_7 7.0 0.0 0.0   0.0 1.0     0.0   0.0   5.0 3.0         *         *   8.0 7 0 0   0 1     0   0   5 3                 8
1158595 1158595 MN Lesueur 40 school 2700261 4151 Charter Schools EDVISIONS OFF CAMPUS SCHOOL 270026103319 10 EDVISIONS OFF CAMPUS SCHOOL Distance Learning Program OLL (State approved) Regular School Yes 3 07 12 2015   grade_7 9.0 3.0 0.0   0.0 0.0     0.0   0.0   4.0 8.0     0.0   0.0     4.0   2.0   12.0 9 3 0   0 0     0   0   4 8     0 0   4 2   12
1159150 1159150 MN Wright 86 school 2700360 4118 Charter Schools KALEIDOSCOPE CHARTER SCHOOL 270036004668 20 Kaleidoscope Charter School Junior High Junior High School (Grades 7-8 or 7-9) Regular School Yes 4 06 10 2015   grade_7 23.0 1.0 1.0   0.0 0.0     0.0   0.0   14.0 11.0     0.0   0.0     7.0   10.0   25.0 23 1 1   0 0     0   0   14 11     0 0   7 10   25
1159415 1159415 MN Washington 82 school 2723380 4003 Charter Schools NEW HEIGHTS SCHOOL, INC. 272338000020 10 NEW HEIGHTS SCHOOL, INC. Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes 4 KG 12 2015   grade_7 6.0 0.0 2.0   0.0 0.0     0.0   0.0   6.0 2.0         *         *   8.0 6 0 2   0 0     0   0   6 2                 8
1159429 1159429 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. CHARTER SCHOOL 270013902718 10 E.C.H.O. CHARTER SCHOOL Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes 4 KG 12 2015   grade_7 9.0 0.0 0.0   0.0 0.0     0.0   1.0   5.0 5.0     0.0   0.0     6.0   1.0   10.0 9 0 0   0 0     0   1   5 5     0 0   6 1   10
1159443 1159443 MN Hennepin 27 school 2700285 4163 Charter Schools LEARNING FOR LEADERSHIP CHARTER 270028503618 10 LEARNING FOR LEADERSHIP CHARTER Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes 4 KG 12 2015   grade_7 3.0 17.0 1.0   0.0 0.0     0.0   2.0   9.0 14.0     11.0   0.0         1.0   23.0 3 17 1   0 0     0   2   9 14     11 0     1   23
1159456 1159456 MN Aitkin 1 school 2700300 4177 Charter Schools MINISINAAKWAANG LEADERSHIP ACADEMY 270030003730 10 MINISINAAKWAANG LEADERSHIP ACADEMY Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes 4 KG 12 2015   grade_7 1.0 0.0 0.0   2.0 0.0     0.0   1.0   3.0 1.0         *         *   4.0 1 0 0   2 0     0   1   3 1                 4
1157161 1157161 MN Unknown   school 2700014 6004 Education Districts FRESHWATER ED. DIST. 270001402222 20 FRESHWATER ED. DIST. ALC Public Area Learning Center ALC (State approved) Alternative Education School No 4 06 12 2015   grade_7 2.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 1.0         *         *   2.0 2 0 0   0 0     0   0   1 1                 2
1157168 1157168 MN Olmsted 55 school 2700054 6012 Education Districts ZUMBRO EDUCATION DISTRICT 270005402492 20 ZUMBRO AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative Education School No 4 06 12 2015   grade_7 2.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0         *         *   2.0 2 0 0   0 0     0   0   2 0                 2
1157189 1157189 MN Chippewa 12 school 2700058 6018 Education Districts MN River Valley Education District 270005802245 20 MN River Valley ALC-Seatbased Public Area Learning Center ALC (State approved) Alternative Education School No 3 07 12 2015   grade_7 1.0 0.0 0.0   2.0 0.0     0.0   0.0   2.0 1.0         *         *   3.0 1 0 0   2 0     0   0   2 1                 3
1157211 1157211 MN Goodhue 25 school 2791443 6051 Education Districts Goodhue County Education District 279144304717 610 Pathways Program Public Area Learning Center ALC (State approved) Alternative Education School No 2 06 07 2015   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1158175 1158175 MN Otter Tail 56 school 2700014 6004 Education Districts FRESHWATER ED. DIST. 270001403297 40 WHITE PINE ACADEMY Special Education Special Education School No 3 07 12 2015   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1158183 1158183 MN Otter Tail 56 school 2700014 6004 Education Districts FRESHWATER ED. DIST. 270001404821 50 Elm Tree Academy Special Education Special Education School No 4 03 12 2015   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1158189 1158189 MN Unknown   school 2700014 6004 Education Districts FRESHWATER ED. DIST. 270001403675 60 LEAF RIVER ACADEMY Special Education Special Education School No 4 KG 12 2015   grade_7 2.0 1.0 0.0   1.0 0.0     0.0   0.0   4.0 0.0         *         *   4.0 2 1 0   1 0     0   0   4 0                 4

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