enrollments

Data source: Big Local News · About: Big Local

3,996 rows where grade = "pre_kindergarten" and state = "WI" sorted by ccd_school_lvl 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
2319079 2319079 WI Rock   school 5501050 413 Public school Beloit 550105002855 150 Beloit Early Learning   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   10                                             10
2319785 2319785 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002772 110 Early Learning Center   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten                                                   20                                             20
2319948 2319948 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255002784 100 Korger-Chestnut   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   6                                             6
2320035 2320035 WI Waupaca   school 5502670 1141 Public school Clintonville 550267000303 60 Dellwood Early Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   7                                             7
2320077 2320077 WI Clark   school 5502730 1162 Public school Colby 550273000312 120 Little Stars Pre-School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   6                                             6
2320427 2320427 WI Dane   school 5503180 1316 Public school De Forest Area 550318002368 100 Holum Education Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   16                                             16
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
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
2321239 2321239 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468003042 130 Early Learning in Fond du Lac   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   28                                             28
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
2322255 2322255 WI Waukesha   school 5506030 2420 Public school Hamilton 550603002432 140 Willow Springs Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   21                                             21
2322441 2322441 WI La Crosse   school 5506540 2562 Public school Holmen 550654000709 80 Holmen Public Preschool   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   16                                             16
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
2323513 2323513 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   17                                             17
2324494 2324494 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861002436 240 Riverview Early Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   29                                             29
2325146 2325146 WI Lincoln   school 5509210 3500 Public school Merrill Area 550921000746 240 Pine River School for Young Learners (PRSYL)   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   40                                             40
2327202 2327202 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032001354 280 Washington School of Early Learning   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   32                                             32
2327244 2327244 WI Wood   school 5510380 3906 Public school Nekoosa 551038003014 150 Nekoosa 4K   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   8                                             8
2327437 2327437 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062003079 180 New Richmond Early Childhood Special Education   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten                                                   16                                             16
2328130 2328130 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119002723 190 Ready 4 Learning School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   24                                             24
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
2329278 2329278 WI Richland   school 5512960 4851 Public school Richland 551296001706 260 Lincoln Elementary   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   16                                             16
2329732 2329732 WI Door   school 5513500 5130 Public school Sevastopol 551350000229 10 Sevastopol Pre-School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   2                                             2
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
2330355 2330355 WI Washburn   school 5514220 5474 Public school Spooner Area 551422002956 120 Little Rails Early Learning   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   8                                             8
2330392 2330392 WI Chippewa   school 5514430 5593 Public school Stanley-Boyd Area 551443001864 20 Boyd Elementary   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   10                                             10
2330502 2330502 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001145 350 Preschool Options   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten                                                   32                                             32
2330588 2330588 WI Dane   school 5514550 5621 Public school Stoughton Area 551455003094 190 SASD 4K   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   12                                             12
2330794 2330794 WI Douglas   school 5514670 5663 Public school Superior 551467002811 130 Superior Community Preschool   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   10                                             10
2331224 2331224 WI Dane   school 5515330 5901 Public school Verona Area 551533002285 110 Early Childhood   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   16                                             16
2331668 2331668 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002926 110 White Rock Campus   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   22                                             22
2332282 2332282 WI Washington   school 5516290 6307 Public school West Bend 551629002912 110 Rolf's Early Childhood Center   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten                                                   31                                             31
2332564 2332564 WI Walworth   school 5516680 6461 Public school Whitewater Unified 551668002834 100 Whitewater 4K   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   10                                             10
2332813 2332813 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707003357 140 WRPS Four-year-old Kindergarten and PK Early Childhood   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   9                                             9
2333853 2333853 WI Rock   school 5501050 413 Public school Beloit 550105002855 150 Beloit Early Learning   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   15                                             15
2334567 2334567 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002772 110 Early Learning Center   Special Education School No Prekindergarten PK PK 2021   pre_kindergarten                                                   12                                             12
2334733 2334733 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255002784 100 Korger-Chestnut   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   12                                             12
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
2335224 2335224 WI Dane   school 5503180 1316 Public school De Forest Area 550318002368 100 Holum Education Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   13                                             13
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
2335598 2335598 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000423 200 Prairie Ridge Early Learning School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   43                                             43
2336067 2336067 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468003042 130 Early Learning in Fond du Lac   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   24                                             24
2336738 2336738 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002589 110 Green Bay Head Start   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   29                                             29
2337095 2337095 WI Waukesha   school 5506030 2420 Public school Hamilton 550603002432 140 Willow Springs Learning Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   13                                             13
2337268 2337268 WI La Crosse   school 5506540 2562 Public school Holmen 550654000709 80 Holmen Public Preschool   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   11                                             11
2337949 2337949 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000811 250 Chavez Learning Station   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   32                                             32
2338397 2338397 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   19                                             19
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
2339364 2339364 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861002436 240 Riverview Early Learning Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   10                                             10
2340030 2340030 WI Lincoln   school 5509210 3500 Public school Merrill Area 550921000746 240 Pine River School for Young Learners (PRSYL)   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   20                                             20
2342071 2342071 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032001354 280 Washington School of Early Learning   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   34                                             34
2342311 2342311 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062003079 180 New Richmond Early Childhood Special Education   Special Education School No Prekindergarten PK PK 2021   pre_kindergarten                                                   17                                             17
2343025 2343025 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119002723 190 Ready 4 Learning School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   34                                             34
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
2344173 2344173 WI Richland   school 5512960 4851 Public school Richland 551296001706 260 Lincoln Elementary   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   12                                             12
2344632 2344632 WI Door   school 5513500 5130 Public school Sevastopol 551350000229 10 Sevastopol Pre-School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   3                                             3
2344720 2344720 WI Sheboygan   school 5513650 5271 Public school Sheboygan Area 551365002423 93 Early Learning Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   44                                             44
2345252 2345252 WI Washburn   school 5514220 5474 Public school Spooner Area 551422002956 120 Little Rails Early Learning   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   1                                             1
2345289 2345289 WI Chippewa   school 5514430 5593 Public school Stanley-Boyd Area 551443001864 20 Boyd Elementary   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   2                                             2
2345397 2345397 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001145 350 Preschool Options   Special Education School No Prekindergarten PK PK 2021   pre_kindergarten                                                   27                                             27
2345494 2345494 WI Dane   school 5514550 5621 Public school Stoughton Area 551455003094 190 SASD 4K   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   10                                             10
2345704 2345704 WI Douglas   school 5514670 5663 Public school Superior 551467002811 130 Superior Community Preschool   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   5                                             5
2346151 2346151 WI Dane   school 5515330 5901 Public school Verona Area 551533002285 110 Early Childhood   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   18                                             18
2346624 2346624 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002926 110 White Rock Campus   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   15                                             15
2347253 2347253 WI Washington   school 5516290 6307 Public school West Bend 551629002912 110 Rolf's Early Childhood Center   Special Education School No Prekindergarten PK PK 2021   pre_kindergarten                                                   32                                             32
2347552 2347552 WI Walworth   school 5516680 6461 Public school Whitewater Unified 551668002834 100 Whitewater 4K   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   10                                             10
2347803 2347803 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707003357 140 WRPS Four-year-old Kindergarten and PK Early Childhood   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   7                                             7
3074856 3074856 WI Rock   school 5501050 413 Public school Beloit 550105002855 150 Beloit Early Learning   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   9                                             9
3075564 3075564 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002772 110 Early Learning Center   Special Education School No Prekindergarten PK PK 2019   pre_kindergarten                                                   8                                             8
3075724 3075724 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255002784 100 Korger-Chestnut   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   10                                             10
3075812 3075812 WI Waupaca   school 5502670 1141 Public school Clintonville 550267000303 60 Dellwood Early Learning Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   12                                             12
3076203 3076203 WI Dane   school 5503180 1316 Public school De Forest Area 550318002368 100 Holum Education Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   13                                             13
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
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
3077000 3077000 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468003042 130 Early Learning in Fond du Lac   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   18                                             18
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
3078005 3078005 WI Waukesha   school 5506030 2420 Public school Hamilton 550603002432 140 Willow Springs Learning Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   17                                             17
3078192 3078192 WI La Crosse   school 5506540 2562 Public school Holmen 550654000709 80 Holmen Public Preschool   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   25                                             25
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
3079263 3079263 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   19                                             19
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
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
3082957 3082957 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032001354 280 Washington School of Early Learning   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   33                                             33
3082999 3082999 WI Wood   school 5510380 3906 Public school Nekoosa 551038003014 150 Nekoosa 4K   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   4                                             4
3083193 3083193 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062003079 180 New Richmond Early Childhood Special Education   Special Education School No Prekindergarten PK PK 2019   pre_kindergarten                                                   16                                             16
3083870 3083870 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119002723 190 Ready 4 Learning School   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   19                                             19
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
3084710 3084710 WI Racine   school 5512360 4620 Public school Racine Unified 551236002708 114 Racine Early Education Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   9                                             9
3085008 3085008 WI Richland   school 5512960 4851 Public school Richland 551296001706 260 Lincoln Elementary   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   16                                             16
3085461 3085461 WI Door   school 5513500 5130 Public school Sevastopol 551350000229 10 Sevastopol Pre-School   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   1                                             1
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
3086024 3086024 WI Monroe   school 5514160 5460 Public school Sparta Area 551416002465 130 Sparta Charter Prekindergarten charter Regular School Yes Prekindergarten PK PK 2019   pre_kindergarten                                                   12                                             12
3086069 3086069 WI Washburn   school 5514220 5474 Public school Spooner Area 551422002956 120 Little Rails Early Learning   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   10                                             10
3086106 3086106 WI Chippewa   school 5514430 5593 Public school Stanley-Boyd Area 551443001864 20 Boyd Elementary   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   6                                             6
3086211 3086211 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001145 350 Preschool Options   Special Education School No Prekindergarten PK PK 2019   pre_kindergarten                                                   29                                             29
3086294 3086294 WI Dane   school 5514550 5621 Public school Stoughton Area 551455003094 190 SASD 4K   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   8                                             8
3086499 3086499 WI Douglas   school 5514670 5663 Public school Superior 551467002811 130 Superior Community Preschool   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   10                                             10
3086923 3086923 WI Dane   school 5515330 5901 Public school Verona Area 551533002285 110 Early Childhood   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   17                                             17
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
3088523 3088523 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707003357 140 WRPS Four-year-old Kindergarten and PK Early Childhood   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   13                                             13

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