enrollments

Data source: Big Local News · About: Big Local

5,797 rows where grade = "kindergarten_4_year_old" and state = "WI" sorted by ccd_school_lvl descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • kindergarten_4_year_old · 5,797 ✖
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
2318356 2318356 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002976 165 Appleton Community 4K   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   922                                             922
2318836 2318836 WI Sauk   school 5500810 280 Public school Baraboo 550081002803 150 Baraboo Early Learning Cooperative   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   144                                             144
2318838 2318838 WI Sauk   school 5500810 280 Public school Baraboo 550081002802 160 Baraboo Early Learning Cooperative RHS Renewal Head Start of Baraboo   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   16                                             16
2318962 2318962 WI Dodge   school 5500960 336 Public school Beaver Dam Unified 550096003082 150 BDUSD4Kids   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   190                                             190
2319078 2319078 WI Rock   school 5501050 413 Public school Beloit 550105002855 150 Beloit Early Learning   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   41                                             41
2319519 2319519 WI Racine   school 5501890 777 Public school Burlington Area 550189002987 150 4K Community School   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   44                                             44
2319947 2319947 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255002784 100 Korger-Chestnut   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   350                                             350
2320034 2320034 WI Waupaca   school 5502670 1141 Public school Clintonville 550267000303 60 Dellwood Early Learning Center   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   80                                             80
2320076 2320076 WI Clark   school 5502730 1162 Public school Colby 550273000312 120 Little Stars Pre-School   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   46                                             46
2320307 2320307 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317002963 190 D C Everest 4K Community Partnership   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   371                                             371
2320426 2320426 WI Dane   school 5503180 1316 Public school De Forest Area 550318002368 100 Holum Education Center   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   305                                             305
2320714 2320714 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   kindergarten_4_year_old                                                   547                                             547
2320796 2320796 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   kindergarten_4_year_old                                                   264                                             264
2321238 2321238 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   kindergarten_4_year_old                                                   301                                             301
2321353 2321353 WI Jefferson   school 5504740 1883 Public school Fort Atkinson 550474002749 130 Fort Atkinson 4K   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   82                                             82
2321897 2321897 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002589 110 Green Bay Head Start   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   118                                             118
2322148 2322148 WI Milwaukee   school 5505910 2296 Public school Greendale 550591003347 110 Time 4 Learning Charter School charter Regular School Yes Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   97                                             97
2322254 2322254 WI Waukesha   school 5506030 2420 Public school Hamilton 550603002432 140 Willow Springs Learning Center   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   245                                             245
2322440 2322440 WI La Crosse   school 5506540 2562 Public school Holmen 550654000709 80 Holmen Public Preschool   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   206                                             206
2322511 2322511 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002848 150 Hortonville Area K4 School   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   151                                             151
2322561 2322561 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663002814 130 Howard and Suamico 4K Collaborative   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   331                                             331
2322609 2322609 WI Saint Croix   school 5506690 2611 Public school Hudson 550669003069 190 Hudson 4K   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   331                                             331
2322871 2322871 WI Rock   school 5507020 2695 Public school Janesville 550702002770 100 Preschool 4 Janesville   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   482                                             482
2323076 2323076 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000811 250 Chavez Learning Station   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   57                                             57
2323187 2323187 WI Kenosha   school 5507320 2793 Public school Kenosha 550732002779 105 Kenosha 4 Year Old Kindergarten   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   117                                             117
2323373 2323373 WI Waukesha   school 5503510 1376 Public school Kettle Moraine 550351002852 100 Kettle Moraine 4K   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   86                                             86
2323512 2323512 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   314                                             314
2323630 2323630 WI La Crosse   school 5507530 2849 Public school La Crosse 550753002467 114 La Crosse Offsite Preschool   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   104                                             104
2324105 2324105 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002475 190 4K PK Off Site   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   675                                             675
2324493 2324493 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861002436 240 Riverview Early Learning Center   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   290                                             290
2324682 2324682 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882002672 130 Marshfield K4   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   222                                             222
2324780 2324780 WI Dane   school 5508910 3381 Public school McFarland 550891002902 150 4K McFarland   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   141                                             141
2325033 2325033 WI Dunn   school 5509090 3444 Public school Menomonie Area 550909002940 150 School District of the Menomonie Area 4K   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   243                                             243
2325145 2325145 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   kindergarten_4_year_old                                                   162                                             162
2325204 2325204 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002888 110 Middleton-Cross Plains Area School District 4K   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   316                                             316
2326842 2326842 WI Dane   school 5509810 3675 Public school Monona Grove 550981002703 130 Together 4 Kids School   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   97                                             97
2326972 2326972 WI Dane   school 5509990 3794 Public school Mount Horeb Area 550999002994 150 Mount Horeb Area Community 4K   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   142                                             142
2327011 2327011 WI Waukesha   school 5510060 3822 Public school Mukwonago 551006003024 140 District 4K   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   238                                             238
2327201 2327201 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032001354 280 Washington School of Early Learning   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   386                                             386
2327243 2327243 WI Wood   school 5510380 3906 Public school Nekoosa 551038003014 150 Nekoosa 4K   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   51                                             51
2327469 2327469 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062002757 150 NR4Kids   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   273                                             273
2327540 2327540 WI Fond du Lac   school 5510740 3983 Public school North Fond du Lac 551074002531 110 Early Learning Center   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   86                                             86
2327754 2327754 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083002659 160 Early Learning Academy   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   308                                             308
2328019 2328019 WI Dane   school 5511100 4144 Public school Oregon 551110002841 100 Oregon 4K   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   208                                             208
2328129 2328129 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119002723 190 Ready 4 Learning School   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   610                                             610
2328558 2328558 WI Ozaukee   school 5512000 4515 Public school Port Washington-Saukville 551200003049 180 Port Washington-Saukville School District Preschool   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   152                                             152
2328741 2328741 WI Pierce   school 5512240 4578 Public school Prescott 551224002762 100 Prescott 4K   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   87                                             87
2328819 2328819 WI Racine   school 5512360 4620 Public school Racine Unified 551236002657 113 All District 4 Year Old Kindergarten   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   81                                             81
2328821 2328821 WI Racine   school 5512360 4620 Public school Racine Unified 551236002708 114 Bull Early Education Center   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   155                                             155
2329102 2329102 WI Sauk   school 5512660 4753 Public school Reedsburg 551266002889 150 4K Community-Based   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   70                                             70
2329236 2329236 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281002528 150 Head Start   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   38                                             38
2329238 2329238 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281002526 110 Hilltop Day Care and Preschool   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   19                                             19
2329277 2329277 WI Richland   school 5512960 4851 Public school Richland 551296001706 260 Lincoln Elementary   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   76                                             76
2329388 2329388 WI Pierce   school 5513050 4893 Public school River Falls 551305002924 130 River Falls 4 Children   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   193                                             193
2329731 2329731 WI Door   school 5513500 5130 Public school Sevastopol 551350000229 10 Sevastopol Pre-School   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   26                                             26
2329819 2329819 WI Sheboygan   school 5513650 5271 Public school Sheboygan Area 551365002423 93 Early Learning Center   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   590                                             590
2330354 2330354 WI Washburn   school 5514220 5474 Public school Spooner Area 551422002956 120 Little Rails Early Learning   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   50                                             50
2330391 2330391 WI Chippewa   school 5514430 5593 Public school Stanley-Boyd Area 551443001864 20 Boyd Elementary   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   56                                             56
2330495 2330495 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449002739 110 Point 4 the Future   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   533                                             533
2330587 2330587 WI Dane   school 5514550 5621 Public school Stoughton Area 551455003094 190 SASD 4K   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   158                                             158
2330718 2330718 WI Dane   school 5514640 5656 Public school Sun Prairie Area 551464002761 190 Sun Prairie Four Kids   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   521                                             521
2330793 2330793 WI Douglas   school 5514670 5663 Public school Superior 551467002811 130 Superior Community Preschool   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   158                                             158
2330954 2330954 WI Monroe   school 5514910 5747 Public school Tomah Area 551491002797 120 Timber PUPS Learning Center   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   53                                             53
2331273 2331273 WI Dane   school 5515330 5901 Public school Verona Area 551533002890 160 Verona Area K4   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   336                                             336
2331482 2331482 WI Jefferson   school 5515750 6125 Public school Watertown Unified 551575002661 110 Watertown 4 Kids   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   176                                             176
2331667 2331667 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002926 110 White Rock Campus   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   266                                             266
2331696 2331696 WI Dane   school 5515810 6181 Public school Waunakee Community 551581002869 150 Waunakee Community 4K School   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   239                                             239
2331731 2331731 WI Waupaca   school 5515840 6195 Public school Waupaca 551584003007 170 Waupaca Community 4-Year Old Kindergarten   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   136                                             136
2332281 2332281 WI Washington   school 5516290 6307 Public school West Bend 551629002912 110 Rolf's Early Childhood Center   Special Education School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   1                                             1
2332291 2332291 WI Washington   school 5516290 6307 Public school West Bend 551629003035 120 West Bend School District 4K   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   358                                             358
2332563 2332563 WI Walworth   school 5516680 6461 Public school Whitewater Unified 551668002834 100 Whitewater 4K   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   18                                             18
2332575 2332575 WI Milwaukee   school 5506000 6470 Public school Whitnall 550600002673 130 CORE4 Collaborating on Readiness Education for Four-Year-Olds charter Regular School Yes Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   112                                             112
2332812 2332812 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   kindergarten_4_year_old                                                   165                                             165
2333151 2333151 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002976 165 Appleton Community 4K   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   687                                             687
2333617 2333617 WI Sauk   school 5500810 280 Public school Baraboo 550081002803 150 Baraboo Early Learning Cooperative   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   151                                             151
2333619 2333619 WI Sauk   school 5500810 280 Public school Baraboo 550081002802 160 Baraboo Early Learning Cooperative RHS Renewal Head Start of Baraboo   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   17                                             17
2333745 2333745 WI Dodge   school 5500960 336 Public school Beaver Dam Unified 550096003082 150 BDUSD4Kids   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   179                                             179
2333852 2333852 WI Rock   school 5501050 413 Public school Beloit 550105002855 150 Beloit Early Learning   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   47                                             47
2334298 2334298 WI Racine   school 5501890 777 Public school Burlington Area 550189002987 150 4K Community School   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   31                                             31
2334732 2334732 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255002784 100 Korger-Chestnut   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   307                                             307
2335104 2335104 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317002963 190 D C Everest 4K Community Partnership   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   309                                             309
2335223 2335223 WI Dane   school 5503180 1316 Public school De Forest Area 550318002368 100 Holum Education Center   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   289                                             289
2335514 2335514 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002778 120 Eau Claire Community Sites   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   438                                             438
2335597 2335597 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   kindergarten_4_year_old                                                   169                                             169
2336066 2336066 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   kindergarten_4_year_old                                                   278                                             278
2336182 2336182 WI Jefferson   school 5504740 1883 Public school Fort Atkinson 550474002749 130 Fort Atkinson 4K   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   117                                             117
2336735 2336735 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582003128 80 GBAPS Community 4K Site   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   197                                             197
2336737 2336737 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002589 110 Green Bay Head Start   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   164                                             164
2336985 2336985 WI Milwaukee   school 5505910 2296 Public school Greendale 550591003347 110 Time 4 Learning Charter School charter Regular School Yes Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   77                                             77
2337094 2337094 WI Waukesha   school 5506030 2420 Public school Hamilton 550603002432 140 Willow Springs Learning Center   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   251                                             251
2337267 2337267 WI La Crosse   school 5506540 2562 Public school Holmen 550654000709 80 Holmen Public Preschool   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   169                                             169
2337354 2337354 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002848 150 Hortonville Area K4 School   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   158                                             158
2337403 2337403 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663002814 130 Howard and Suamico 4K Collaborative   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   276                                             276
2337451 2337451 WI Saint Croix   school 5506690 2611 Public school Hudson 550669003069 190 Hudson 4K   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   306                                             306
2337734 2337734 WI Rock   school 5507020 2695 Public school Janesville 550702002770 100 Preschool 4 Janesville   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   396                                             396
2337948 2337948 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000811 250 Chavez Learning Station   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   34                                             34
2338058 2338058 WI Kenosha   school 5507320 2793 Public school Kenosha 550732002779 105 Kenosha 4 Year Old Kindergarten   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   76                                             76
2338245 2338245 WI Waukesha   school 5503510 1376 Public school Kettle Moraine 550351002852 100 Kettle Moraine 4K   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   64                                             64
2338396 2338396 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   292                                             292
2338508 2338508 WI La Crosse   school 5507530 2849 Public school La Crosse 550753002467 114 La Crosse Offsite Preschool   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   102                                             102

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