enrollments

Data source: Big Local News · About: Big Local

5,797 rows where grade = "kindergarten_4_year_old" and state = "WI" sorted by total_int 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 ▲
325860 325860 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002976 165 Appleton Community 4K   Regular School No Elementary PK PK 2017   kindergarten_4_year_old                                                   982                                             982
281974 281974 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002976 165 Appleton Community 4K   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   976                                             976
3088903 3088903 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002976 165 Appleton Community 4K   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   934                                             934
3074147 3074147 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002976 165 Appleton Community 4K   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   933                                             933
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
111999 111999 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002976 165 Appleton Community 4K   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   896                                             896
117619 117619 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002475 190 4K PK Off Site   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   811                                             811
284342 284342 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000423 200 Prairie Ridge Early Learning School   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   779                                             779
287616 287616 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002475 190 4K PK Off Site   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   766                                             766
3094564 3094564 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002475 190 4K PK Off Site   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   744                                             744
114359 114359 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000423 200 Prairie Ridge Early Learning School   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   730                                             730
125103 125103 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002926 110 Waukesha Early Learning Center   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   720                                             720
3079827 3079827 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002475 190 4K PK Off Site   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   716                                             716
331487 331487 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002475 190 4K PK Off Site   Regular School No Elementary PK PK 2017   kindergarten_4_year_old                                                   709                                             709
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
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
295036 295036 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002926 110 Waukesha Early Learning Center   Regular School No 1.0 PK KG 2016   kindergarten_4_year_old                                                   653                                             653
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
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
3086424 3086424 WI Dane   school 5514640 5656 Public school Sun Prairie Area 551464002761 190 Sun Prairie Four Kids   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   574                                             574
3101140 3101140 WI Dane   school 5514640 5656 Public school Sun Prairie Area 551464002761 190 Sun Prairie Four Kids   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   571                                             571
293331 293331 WI Sheboygan   school 5513650 5271 Public school Sheboygan Area 551365002423 93 Early Learning Center   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   553                                             553
3100279 3100279 WI Sheboygan   school 5513650 5271 Public school Sheboygan Area 551365002423 93 Early Learning Center   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   551                                             551
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
124044 124044 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449002739 110 Point 4 the Future   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   540                                             540
293977 293977 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449002739 110 Point 4 the Future   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   538                                             538
3085548 3085548 WI Sheboygan   school 5513650 5271 Public school Sheboygan Area 551365002423 93 Early Learning Center   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   534                                             534
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
3078622 3078622 WI Rock   school 5507020 2695 Public school Janesville 550702002770 100 Preschool 4 Janesville   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   525                                             525
2338973 2338973 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002475 190 4K PK Off Site   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   522                                             522
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
337880 337880 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449002739 110 Point 4 the Future   Regular School No Elementary PK PK 2017   kindergarten_4_year_old                                                   520                                             520
328169 328169 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002778 120 Eau Claire Community Sites   Special Education School No Elementary PK PK 2017   kindergarten_4_year_old                                                   519                                             519
123375 123375 WI Sheboygan   school 5513650 5271 Public school Sheboygan Area 551365002423 93 Early Learning Center   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   516                                             516
338087 338087 WI Dane   school 5514640 5656 Public school Sun Prairie Area 551464002761 190 Sun Prairie Four Kids   Regular School No Elementary PK PK 2017   kindergarten_4_year_old                                                   516                                             516
3091232 3091232 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002778 120 Eau Claire Community Sites   Special Education School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   514                                             514
116423 116423 WI Rock   school 5507020 2695 Public school Janesville 550702002770 100 Preschool 4 Janesville   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   513                                             513
3093370 3093370 WI Rock   school 5507020 2695 Public school Janesville 550702002770 100 Preschool 4 Janesville   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   507                                             507
294184 294184 WI Dane   school 5514640 5656 Public school Sun Prairie Area 551464002761 190 Sun Prairie Four Kids   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   506                                             506
286424 286424 WI Rock   school 5507020 2695 Public school Janesville 550702002770 100 Preschool 4 Janesville   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   505                                             505
3086204 3086204 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449002739 110 Point 4 the Future   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   505                                             505
337222 337222 WI Sheboygan   school 5513650 5271 Public school Sheboygan Area 551365002423 93 Early Learning Center   Regular School No Elementary PK PK 2017   kindergarten_4_year_old                                                   501                                             501
335492 335492 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119002723 190 Ready 4 Learning School   Regular School No Elementary PK PK 2017   kindergarten_4_year_old                                                   490                                             490
3076486 3076486 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   kindergarten_4_year_old                                                   484                                             484
2345628 2345628 WI Dane   school 5514640 5656 Public school Sun Prairie Area 551464002761 190 Sun Prairie Four Kids   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   483                                             483
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
291624 291624 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119002723 190 Ready 4 Learning School   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   480                                             480
3098570 3098570 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119002723 190 Ready 4 Learning School   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   480                                             480
121662 121662 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119002723 190 Ready 4 Learning School   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   478                                             478
330301 330301 WI Rock   school 5507020 2695 Public school Janesville 550702002770 100 Preschool 4 Janesville   Regular School No Elementary PK PK 2017   kindergarten_4_year_old                                                   478                                             478
2344719 2344719 WI Sheboygan   school 5513650 5271 Public school Sheboygan Area 551365002423 93 Early Learning Center   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   476                                             476
124253 124253 WI Dane   school 5514640 5656 Public school Sun Prairie Area 551464002761 190 Sun Prairie Four Kids   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   473                                             473
3100933 3100933 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449002739 110 Point 4 the Future   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   452                                             452
2345389 2345389 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449002739 110 Point 4 the Future   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   449                                             449
3083869 3083869 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119002723 190 Ready 4 Learning School   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   439                                             439
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
2343024 2343024 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119002723 190 Ready 4 Learning School   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   435                                             435
285475 285475 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002965 170 Friedrich Froebel Garden of Early Learning   Regular School No 1.0 PK KG 2016   kindergarten_4_year_old                                                   434                                             434
3077647 3077647 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002965 170 Friedrich Froebel Garden of Early Learning   Regular School No Elementary PK KG 2019   kindergarten_4_year_old                                                   430                                             430
329350 329350 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002965 170 Friedrich Froebel Garden of Early Learning   Regular School No Elementary PK KG 2017   kindergarten_4_year_old                                                   421                                             421
115470 115470 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002965 170 Friedrich Froebel Garden of Early Learning   Regular School No 1.0 PK KG 2015   kindergarten_4_year_old                                                   416                                             416
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
3092424 3092424 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002965 170 Friedrich Froebel Garden of Early Learning   Regular School No Elementary PK KG 2018   kindergarten_4_year_old                                                   387                                             387
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
3090823 3090823 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 2018   kindergarten_4_year_old                                                   384                                             384
286120 286120 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663002814 130 Howard and Suamico 4K Collaborative   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   379                                             379
327417 327417 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255002784 100 Korger-Chestnut   Regular School No Elementary PK PK 2017   kindergarten_4_year_old                                                   375                                             375
330000 330000 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663002814 130 Howard and Suamico 4K Collaborative   Regular School No Elementary PK PK 2017   kindergarten_4_year_old                                                   372                                             372
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
3088009 3088009 WI Washington   school 5516290 6307 Public school West Bend 551629003035 120 West Bend School District 4K   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   369                                             369
113532 113532 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255002784 100 Korger-Chestnut   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   365                                             365
283510 283510 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255002784 100 Korger-Chestnut   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   363                                             363
113896 113896 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317002963 190 DCE 4K Community Partnership   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   361                                             361
3093070 3093070 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663002814 130 Howard and Suamico 4K Collaborative   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   361                                             361
327769 327769 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317002963 190 D C Everest 4K Community Partnership   Regular School No Elementary PK PK 2017   kindergarten_4_year_old                                                   360                                             360
3076082 3076082 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 2019   kindergarten_4_year_old                                                   360                                             360
3082956 3082956 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032001354 280 Washington School of Early Learning   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   360                                             360
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
116122 116122 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663002814 130 Howard and Suamico 4K Collaborative   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   356                                             356
3075723 3075723 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255002784 100 Korger-Chestnut   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   356                                             356
3095652 3095652 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 2018   kindergarten_4_year_old                                                   354                                             354
338987 338987 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002926 110 White Rock Campus   Regular School No Elementary PK 01 2017   kindergarten_4_year_old                                                   352                                             352
288705 288705 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002888 110 MCPASD 4K   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   351                                             351
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
339622 339622 WI Washington   school 5516290 6307 Public school West Bend 551629003035 120 West Bend School District 4K   Regular School No Elementary PK PK 2017   kindergarten_4_year_old                                                   348                                             348
3097667 3097667 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032001354 280 Washington School of Early Learning   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   346                                             346
3078311 3078311 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663002814 130 Howard and Suamico 4K Collaborative   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   344                                             344
283880 283880 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317002963 190 DCE 4K Community Partnership   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   342                                             342
2342070 2342070 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032001354 280 Washington School of Early Learning   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   342                                             342
334591 334591 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032001354 280 Washington Early Learning Center   Regular School No Elementary PK PK 2017   kindergarten_4_year_old                                                   341                                             341
3094946 3094946 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861002436 240 Riverview Elementary   Regular School No Elementary PK KG 2018   kindergarten_4_year_old                                                   340                                             340
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
3087373 3087373 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002926 110 White Rock Campus   Regular School No Elementary PK 03 2019   kindergarten_4_year_old                                                   335                                             335
331872 331872 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861002436 240 Riverview Elementary   Regular School No Elementary PK KG 2017   kindergarten_4_year_old                                                   333                                             333
3090473 3090473 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255002784 100 Korger-Chestnut   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   333                                             333
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
122327 122327 WI Racine   school 5512360 4620 Public school Racine Unified 551236002657 113 All District 4 Year Old Kindergarten   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   324                                             324
3080936 3080936 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 2019   kindergarten_4_year_old                                                   322                                             322
288006 288006 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861002436 240 Riverview Elementary   Regular School No 1.0 PK KG 2016   kindergarten_4_year_old                                                   321                                             321

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