enrollments

Data source: Big Local News · About: Big Local

3,996 rows where grade = "pre_kindergarten" and state = "WI" sorted by total_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • pre_kindergarten · 3,996 ✖
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 ▲
330944 330944 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No Elementary PK PK 2017   pre_kindergarten                                                   301                                             301
2328822 2328822 WI Racine   school 5512360 4620 Public school Racine Unified 551236002708 114 Bull Early Education Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   167                                             167
2343713 2343713 WI Racine   school 5512360 4620 Public school Racine Unified 551236002708 114 Bull Early Education Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   163                                             163
118780 118780 WI Rock   school 5509570 3612 Public school Milton 550957001120 140 West Elementary   Regular School No 1.0 PK 03 2015   pre_kindergarten                                                   162                                             162
3099034 3099034 WI Columbia   school 5512060 4501 Public school Portage Community 551206002945 190 Portage Partnering Preschool   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   160                                             160
2328601 2328601 WI Columbia   school 5512060 4501 Public school Portage Community 551206002945 190 Portage Partnering Preschool   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   159                                             159
3084339 3084339 WI Columbia   school 5512060 4501 Public school Portage Community 551206002945 190 Portage Partnering Preschool   Regular School No Elementary PK 04 2019   pre_kindergarten                                                   151                                             151
336326 336326 WI Racine   school 5512360 4620 Public school Racine Unified 551236000458 172 P-COC Parent-Child Oriented Classroom   Regular School No Elementary PK PK 2017   pre_kindergarten                                                   147                                             147
335951 335951 WI Columbia   school 5512060 4501 Public school Portage Community 551206002945 190 Portage Partnering Preschool   Regular School No Elementary PK 04 2017   pre_kindergarten                                                   145                                             145
125751 125751 WI Washington   school 5516290 6307 Public school West Bend 551629002133 180 Washington County Head Start & West Bend Title I   Regular School No 1.0 PK PK 2015   pre_kindergarten                                                   138                                             138
295691 295691 WI Washington   school 5516290 6307 Public school West Bend 551629002133 180 Washington County Head Start & West Bend Title I   Regular School No 1.0 PK PK 2016   pre_kindergarten                                                   138                                             138
3084691 3084691 WI Racine   school 5512360 4620 Public school Racine Unified 551236000458 172 P-COC Parent-Child Oriented Classroom   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   133                                             133
288108 288108 WI Marinette   school 5508700 3311 Public school Marinette 550870002838 100 Sunrise Early Learning Center   Regular School No 1.0 PK KG 2016   pre_kindergarten                                                   130                                             130
118117 118117 WI Marinette   school 5508700 3311 Public school Marinette 550870002838 100 Sunrise Early Learning Center   Regular School No 1.0 PK KG 2015   pre_kindergarten                                                   122                                             122
115474 115474 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002589 110 Green Bay Head Start   Regular School No 1.0 PK KG 2015   pre_kindergarten                                                   120                                             120
2343493 2343493 WI Columbia   school 5512060 4501 Public school Portage Community 551206002945 190 Portage Partnering Preschool   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   120                                             120
114317 114317 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002778 120 Main Street School   Special Education School No 1.0 PK PK 2015   pre_kindergarten                                                   110                                             110
285479 285479 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002589 110 Green Bay Head Start   Regular School No 1.0 PK KG 2016   pre_kindergarten                                                   105                                             105
125746 125746 WI Washington   school 5516290 6307 Public school West Bend 551629002912 110 Rolf's Early Childhood Center   Special Education School No 1.0 PK PK 2015   pre_kindergarten                                                   104                                             104
2338974 2338974 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002475 190 4K PK Off Site   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   104                                             104
125104 125104 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002926 110 Waukesha Early Learning Center   Regular School No 1.0 PK PK 2015   pre_kindergarten                                                   103                                             103
329354 329354 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002589 110 Green Bay Head Start   Regular School No Elementary PK KG 2017   pre_kindergarten                                                   100                                             100
3079828 3079828 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002475 190 4K PK Off Site   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   95                                             95
122483 122483 WI Racine   school 5512360 4620 Public school Racine Unified 551236000458 172 P-COC   Regular School No 1.0 PK PK 2015   pre_kindergarten                                                   93                                             93
331488 331488 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002475 190 4K PK Off Site   Regular School No Elementary PK PK 2017   pre_kindergarten                                                   90                                             90
292452 292452 WI Racine   school 5512360 4620 Public school Racine Unified 551236000458 172 P-COC   Regular School No 1.0 PK PK 2016   pre_kindergarten                                                   89                                             89
284299 284299 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002778 120 Main Street School   Special Education School No 1.0 PK PK 2016   pre_kindergarten                                                   88                                             88
287617 287617 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002475 190 4K PK Off Site   Regular School No 1.0 PK PK 2016   pre_kindergarten                                                   87                                             87
3074950 3074950 WI Rock   school 5501080 422 Public school Beloit Turner 550108000157 60 Powers Elementary   Regular School No Elementary PK 02 2019   pre_kindergarten                                                   86                                             86
295038 295038 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002926 110 Waukesha Early Learning Center   Regular School No 1.0 PK KG 2016   pre_kindergarten                                                   85                                             85
295686 295686 WI Washington   school 5516290 6307 Public school West Bend 551629002912 110 Rolf's Early Childhood Center   Special Education School No 1.0 PK PK 2016   pre_kindergarten                                                   85                                             85
3089707 3089707 WI Rock   school 5501080 422 Public school Beloit Turner 550108000157 60 Powers Elementary   Regular School No Elementary PK 02 2018   pre_kindergarten                                                   84                                             84
3092428 3092428 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002589 110 Green Bay Head Start   Regular School No Elementary PK KG 2018   pre_kindergarten                                                   84                                             84
3077651 3077651 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002589 110 Green Bay Head Start   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   83                                             83
2323077 2323077 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000811 250 Chavez Learning Station   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   82                                             82
3078826 3078826 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000811 250 Chavez Learning Station   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   80                                             80
330504 330504 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000811 250 Chavez Learning Station   Regular School No Elementary PK PK 2017   pre_kindergarten                                                   79                                             79
2321898 2321898 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002589 110 Green Bay Head Start   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   77                                             77
116619 116619 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000811 250 Chavez Learning Station   Regular School No 1.0 PK PK 2015   pre_kindergarten                                                   73                                             73
3098357 3098357 WI Oconto   school 5510920 4067 Public school Oconto Unified 551092001429 160 Oconto Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   73                                             73
114241 114241 WI Pepin   school 5503840 1499 Public school Durand 550384000116 20 Arkansaw Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   72                                             72
293332 293332 WI Sheboygan   school 5513650 5271 Public school Sheboygan Area 551365002423 93 Early Learning Center   Regular School No 1.0 PK PK 2016   pre_kindergarten                                                   72                                             72
117620 117620 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002475 190 4K PK Off Site   Regular School No 1.0 PK PK 2015   pre_kindergarten                                                   70                                             70
3075256 3075256 WI Green   school 5501740 700 Public school Brodhead 550174000211 20 Ronald R Albrecht Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                                                   70                                             70
3085549 3085549 WI Sheboygan   school 5513650 5271 Public school Sheboygan Area 551365002423 93 Early Learning Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   70                                             70
125223 125223 WI Marathon   school 5515900 6223 Public school Wausau 551590002455 10 A C Kiefer Educational Center   Regular School No 1.0 PK KG 2015   pre_kindergarten                                                   69                                             69
2320715 2320715 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002778 120 Eau Claire Community Sites   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten                                                   69                                             69
3093569 3093569 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000811 250 Chavez Learning Station   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                                                   69                                             69
2346044 2346044 WI Manitowoc   school 5515120 5824 Public school Two Rivers Public 551512001959 40 Koenig Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   68                                             68
2319470 2319470 WI Green   school 5501740 700 Public school Brodhead 550174000211 20 Ronald R Albrecht Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   67                                             67
292479 292479 WI Racine   school 5512360 4620 Public school Racine Unified 551236001636 174 Red Apple Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   66                                             66
2320094 2320094 WI Marinette   school 5502760 1169 Public school Coleman 550276000313 40 Coleman Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   64                                             64
2321037 2321037 WI Waukesha   school 5501770 714 Public school Elmbrook 550177000218 80 Burleigh Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   64                                             64
327558 327558 WI Marinette   school 5502760 1169 Public school Coleman 550276000313 40 Coleman Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   63                                             63
335270 335270 WI Oconto   school 5510920 4067 Public school Oconto Unified 551092001429 160 Oconto Elementary   Regular School No Elementary PK 04 2017   pre_kindergarten                                                   63                                             63
2329820 2329820 WI Sheboygan   school 5513650 5271 Public school Sheboygan Area 551365002423 93 Early Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   63                                             63
3076798 3076798 WI Waukesha   school 5501770 714 Public school Elmbrook 550177000218 80 Burleigh Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                                                   63                                             63
116202 116202 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002735 150 River Crest Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   62                                             62
120755 120755 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032001354 280 Washington Early Learning Center   Regular School No 1.0 PK PK 2015   pre_kindergarten                                                   61                                             61
337223 337223 WI Sheboygan   school 5513650 5271 Public school Sheboygan Area 551365002423 93 Early Learning Center   Regular School No Elementary PK PK 2017   pre_kindergarten                                                   61                                             61
326672 326672 WI Rock   school 5501080 422 Public school Beloit Turner 550108000157 60 Powers Elementary   Regular School No Elementary PK 02 2017   pre_kindergarten                                                   60                                             60
2334861 2334861 WI Clark   school 5502730 1162 Public school Colby 550273000312 120 Little Stars Pre-School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   59                                             59
3076561 3076561 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000423 200 Prairie Ridge Early Learning School   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   59                                             59
2342802 2342802 WI Oconto   school 5510920 4067 Public school Oconto Unified 551092001429 160 Oconto Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   58                                             58
295160 295160 WI Marathon   school 5515900 6223 Public school Wausau 551590002455 10 A C Kiefer Educational Center   Regular School No 1.0 PK KG 2016   pre_kindergarten                                                   57                                             57
328242 328242 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000423 200 Prairie Ridge Early Learning School   Regular School No Elementary PK PK 2017   pre_kindergarten                                                   57                                             57
2334251 2334251 WI Green   school 5501740 700 Public school Brodhead 550174000211 20 Ronald R Albrecht Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   57                                             57
2335515 2335515 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002778 120 Eau Claire Community Sites   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   57                                             57
3100280 3100280 WI Sheboygan   school 5513650 5271 Public school Sheboygan Area 551365002423 93 Early Learning Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                                                   57                                             57
3083655 3083655 WI Oconto   school 5510920 4067 Public school Oconto Unified 551092001429 160 Oconto Elementary   Regular School No Elementary PK 04 2019   pre_kindergarten                                                   56                                             56
3091307 3091307 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000423 200 Prairie Ridge Early Learning School   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                                                   56                                             56
3090020 3090020 WI Green   school 5501740 700 Public school Brodhead 550174000211 20 Ronald R Albrecht Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   55                                             55
2321940 2321940 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000627 370 Keller Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   54                                             54
112162 112162 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000059 280 Lincoln Elementary   Regular School No 1.0 PK 06 2015   pre_kindergarten                                                   53                                             53
293846 293846 WI Washburn   school 5514220 5474 Public school Spooner Area 551422002956 120 Little Rails Early Learning   Regular School No 1.0 PK PK 2016   pre_kindergarten                                                   53                                             53
115515 115515 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000627 370 Keller Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   52                                             52
123376 123376 WI Sheboygan   school 5513650 5271 Public school Sheboygan Area 551365002423 93 Early Learning Center   Regular School No 1.0 PK PK 2015   pre_kindergarten                                                   52                                             52
286200 286200 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002735 150 River Crest Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   52                                             52
330078 330078 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002735 150 River Crest Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   52                                             52
338716 338716 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566002454 15 Evergreen Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten                                                   52                                             52
3075866 3075866 WI Marinette   school 5502760 1169 Public school Coleman 550276000313 40 Coleman Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                                                   52                                             52
3080874 3080874 WI Lincoln   school 5509210 3500 Public school Merrill Area 550921000746 240 Pine River School for Young Learners (PRSYL)   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   52                                             52
284586 284586 WI Waukesha   school 5501770 714 Public school Elmbrook 550177000218 80 Burleigh Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   51                                             51
3076487 3076487 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002778 120 Eau Claire Community Sites   Special Education School No Prekindergarten PK PK 2019   pre_kindergarten                                                   51                                             51
3090616 3090616 WI Marinette   school 5502760 1169 Public school Coleman 550276000313 40 Coleman Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   51                                             51
339113 339113 WI Marathon   school 5515900 6223 Public school Wausau 551590002049 80 G D Jones Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   50                                             50
2320797 2320797 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000423 200 Prairie Ridge Early Learning School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   50                                             50
3087999 3087999 WI Washington   school 5516290 6307 Public school West Bend 551629002912 110 Rolf's Early Childhood Center   Special Education School No Prekindergarten PK PK 2019   pre_kindergarten                                                   50                                             50
3091544 3091544 WI Waukesha   school 5501770 714 Public school Elmbrook 550177000218 80 Burleigh Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   50                                             50
3087090 3087090 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566002454 15 Evergreen Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten                                                   48                                             48
331004 331004 WI Waukesha   school 5500073 8135 Non District Charter Schools La Casa de Esperanza Charter School 550007303031 100 La Casa de Esperanza Charter School charter Regular School Yes Elementary PK 08 2017   pre_kindergarten                                                   47                                             47
334592 334592 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032001354 280 Washington Early Learning Center   Regular School No Elementary PK PK 2017   pre_kindergarten                                                   47                                             47
2328995 2328995 WI Racine   school 5512360 4620 Public school Racine Unified 551236003044 101 RUSD Montessori   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   47                                             47
3087111 3087111 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566002510 110 Woodfield Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten                                                   47                                             47
3100532 3100532 WI Kenosha   school 5513860 5369 Public school Silver Lake J1 551386001815 20 Riverview Elementary   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   47                                             47
2334878 2334878 WI Marinette   school 5502760 1169 Public school Coleman 550276000313 40 Coleman Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   46                                             46
2335857 2335857 WI Waukesha   school 5501770 714 Public school Elmbrook 550177000218 80 Burleigh Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   46                                             46
2339526 2339526 WI Dane   school 5508790 3332 Public school Marshall 550879000569 80 Marshall Early Learning Center   Regular School No Elementary PK 02 2021   pre_kindergarten                                                   46                                             46
113675 113675 WI Marinette   school 5502760 1169 Public school Coleman 550276000313 40 Coleman Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   45                                             45
288008 288008 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861002436 240 Riverview Elementary   Regular School No 1.0 PK KG 2016   pre_kindergarten                                                   45                                             45

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