enrollments

Data source: Big Local News · About: Big Local

15,786 rows where grade = "pk_12_total" and state = "WI" sorted by female

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • pk_12_total · 15,686 ✖
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
2343133 2343133 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001514 20 Palmyra Elementary   Regular School No Elementary PK 06 2021   pk_12_total                                                   0                                             0
2343950 2343950 WI Dodge   school   4634 Public Schools-Multidistrict Charters Randolph   405 Kiel eSchool charter           2021   pk_12_total                                                   0                                             0
2344122 2344122 WI Taylor   school   4795 Public Schools-Multidistrict Charters Rib Lake   9100 Rural Virtual Academy charter           2021   pk_12_total                                                   0                                             0
2345133 2345133 WI Door   school   5457 Public Schools-Multidistrict Charters Southern Door County   9100 Rural Virtual Academy charter           2021   pk_12_total 8.0                       8.0               *     1   8 8                       8               1   8
2345290 2345290 WI Chippewa   school   5593 Public Schools-Multidistrict Charters Stanley-Boyd Area   9419 eSucceed Charter School charter           2021   pk_12_total                                                   0                                             0
2346564 2346564 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003070 800 Riverview School   Alternative School No High 06 12 2021   pk_12_total 1.0   1.0               1.0   3.0       1.0       *     *   3 1   1               1   3       1           3
2347902 2347902 WI Vilas   school   6720 Public Schools-Multidistrict Charters Woodruff J1   9418 Lakeland STAR School--Strong Talented Adventurous Remarkable charter           2021   pk_12_total                                                   0                                             0
3074148 3074148 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002679 800 Appleton Cooperative Educational Center   Alternative School No Other 04 12 2019   pk_12_total 1.0                       1.0               *     *   1 1                       1                   1
3074945 3074945 WI Rock   school   422 Public Schools-Multidistrict Charters Beloit Turner   9803 JEDI Virtual K-12 charter           2019   pk_12_total                                                   0                                             0
3075005 3075005 WI Walworth   school   6013 Public Schools-Multidistrict Charters Big Foot UHS   9401 Walworth Co Educ Alt High charter           2019   pk_12_total 1.0                       1.0               *     *   1 1                       1                   1
3075372 3075372 WI Ashland   school 5501920 840 Public school Butternut 550192002751 450 Promethean Charter School charter Regular School Yes High 09 12 2019   pk_12_total 1.0         1.0             2.0               *     *   2 1         1             2                   2
3076558 3076558 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002675 430 Oxford Avenue School   Alternative School No High 10 12 2019   pk_12_total                                                   0                                             0
3076658 3076658 WI Langlade   school   1582 Public Schools-Multidistrict Charters Elcho   9100 Rural Virtual Academy charter           2019   pk_12_total                                                   0                                             0
3077124 3077124 WI Jefferson   school   1883 Public Schools-Multidistrict Charters Fort Atkinson   9803 JEDI Virtual K-12 charter           2019   pk_12_total                                                   0                                             0
3077400 3077400 WI Taylor   school   2135 Public Schools-Multidistrict Charters Gilman   9100 Rural Virtual Academy charter           2019   pk_12_total                                                   0                                             0
3078944 3078944 WI Kenosha   school 5507320 2793 Public school Kenosha 550732003051 810 Kenosha Pike School   Special Education School No Other PK 12 2019   pk_12_total                                                   0                                             0
3079238 3079238 WI Vernon   school   5960 Public Schools-Multidistrict Charters Kickapoo Area   9407 Vernon County Area Better Futures High charter           2019   pk_12_total                                                   0                                             0
3079482 3079482 WI Vernon   school   2863 Public Schools-Multidistrict Charters La Farge   9407 Vernon County Area Better Futures High charter           2019   pk_12_total 1.0                       1.0               *     *   1 1                       1                   1
3079496 3079496 WI Vilas   school   1848 Public Schools-Multidistrict Charters Lac du Flambeau #1   9418 Lakeland STAR School--Strong Talented Adventurous Remarkable charter           2019   pk_12_total                                                   0                                             0
3079945 3079945 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002909 220 Innovative & Alternative Middle   Alternative School No Middle 06 08 2019   pk_12_total                                                   0                                             0
3080354 3080354 WI Dane   school   3332 Public Schools-Multidistrict Charters Marshall   9803 JEDI Virtual K-12 charter           2019   pk_12_total                                                   0                                             0
3080460 3080460 WI Juneau   school   3360 Public Schools-Multidistrict Charters Mauston   9405 Juneau County Charter School charter           2019   pk_12_total                                                   0                                             0
3082862 3082862 WI Juneau   school   3871 Public Schools-Multidistrict Charters Necedah Area   9405 Juneau County Charter School charter           2019   pk_12_total                                                   0                                             0
3083127 3083127 WI Juneau   school 5510560 3948 Public school New Lisbon 551056002517 9405 Juneau County Charter School charter Regular School Yes High 07 12 2019   pk_12_total 2.0                       2.0               *     *   2 2                       2                   2
3083248 3083248 WI Waukesha   school 5510710 3976 Public school Norris 551071001395 20 Norris Academy   Regular School No Other 03 12 2019   pk_12_total 11.0 13.0 2.0               1.0   27.0               20     9   27 11 13 2               1   27           20   9   27
3083257 3083257 WI Waukesha   school 5510710 3976 Public school Norris 551071003072 800 Norris Academy Virtual School charter Alternative School Yes Other KG 12 2019   pk_12_total 4.0                       4.0               *     *   4 4                       4                   4
3083319 3083319 WI Vilas   school   616 Public Schools-Multidistrict Charters North Lakeland   9418 Lakeland STAR School--Strong Talented Adventurous Remarkable charter           2019   pk_12_total                                                   0                                             0
3083437 3083437 WI Washburn   school 5509720 3654 Public school Northwood 550972003018 800 Northwood Virtual Charter School charter Regular School Yes Other PK 12 2019   pk_12_total                                                   0                                             0
3084459 3084459 WI Price   school   4571 Public Schools-Multidistrict Charters Prentice   9100 Rural Virtual Academy charter           2019   pk_12_total                                                   0                                             0
3085262 3085262 WI Juneau   school   1673 Public Schools-Multidistrict Charters Royall   9405 Juneau County Charter Sch charter           2019   pk_12_total                                                   0                                             0
3085856 3085856 WI Douglas   school 5513980 5397 Public school Solon Springs 551398003092 850 Eagles' Wings Virtual Charter School charter Regular School Yes Other PK 12 2019   pk_12_total                                                   0                                             0
3087117 3087117 WI Jefferson   school   6118 Public Schools-Multidistrict Charters Waterloo   9803 JEDI Virtual K-12 charter           2019   pk_12_total 1.0                   1.0   2.0               *     *   2 1                   1   2                   2
3088072 3088072 WI Vernon   school   6321 Public Schools-Multidistrict Charters Westby Area   9407 Vernon County Area Better Futures High charter           2019   pk_12_total 3.0                       3.0               *     *   3 3                       3                   3
3088248 3088248 WI Walworth   school   6461 Public Schools-Multidistrict Charters Whitewater Unified   9803 JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive charter           2019   pk_12_total                                                   0                                             0
3088329 3088329 WI Walworth   school   6482 Public Schools-Multidistrict Charters Williams Bay   9401 Walworth Co Educ Alt High charter           2019   pk_12_total                                                   0                                             0
3088552 3088552 WI Juneau   school   6713 Public Schools-Multidistrict Charters Wonewoc-Union Center   9405 Juneau County Charter School charter           2019   pk_12_total                                                   0                                             0
3088607 3088607 WI Vilas   school   6720 Public Schools-Multidistrict Charters Woodruff J1   9418 Lakeland STAR School--Strong Talented Adventurous Remarkable charter           2019   pk_12_total                                                   0                                             0
3088665 3088665 WI Clark   school   7 Public Schools-Multidistrict Charters Abbotsford   9100 Rural Virtual Academy charter           2018   pk_12_total 3.0                       3.0               *     *   3 3                       3                   3
3088904 3088904 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002679 800 Appleton Cooperative Educational Center   Alternative School No Other 04 12 2018   pk_12_total 1.0 1.0       2.0             4.0               *     *   4 1 1       2             4                   4
3090086 3090086 WI Racine   school   777 Public Schools-Multidistrict Charters Burlington Area   9803 JEDI Virtual K-12 charter           2018   pk_12_total                                                   0                                             0
3090127 3090127 WI Ashland   school 5501920 840 Public school Butternut 550192002751 450 Promethean Charter School charter Regular School Yes High 09 12 2018   pk_12_total 1.0         1.0             2.0               *     *   2 1         1             2                   2
3091304 3091304 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002675 430 Oxford Avenue School   Alternative School No High 10 12 2018   pk_12_total                                                   0                                             0
3091873 3091873 WI Jefferson   school   1883 Public Schools-Multidistrict Charters Fort Atkinson   9803 JEDI Virtual K-12 charter           2018   pk_12_total                                                   0                                             0
3091935 3091935 WI Milwaukee   school 5504830 1900 Public school Franklin Public 550483002685 400 Milwaukee County Correctional Facility South   Alternative School No High 09 12 2018   pk_12_total 2.0 39.0 8.0               2.0   51.0               4     32   51 2 39 8               2   51           4   32   51
3093232 3093232 WI Waupaca   school   2639 Public Schools-Multidistrict Charters Iola-Scandinavia   9408 Waupaca County Charter charter           2018   pk_12_total                                                   0                                             0
3093691 3093691 WI Kenosha   school 5507320 2793 Public school Kenosha 550732003051 810 Kenosha Pike School   Special Education School No Other PK 12 2018   pk_12_total 2.0 1.0                     3.0               *     *   3 2 1                     3                   3
3093741 3093741 WI Kenosha   school 5507320 2793 Public school Kenosha 550732001714 405 Phoenix Project   Alternative School No High 09 12 2018   pk_12_total 7.0 16.0 4.0               2.0   29.0               3     11   29 7 16 4               2   29           3   11   29
3094230 3094230 WI Vernon   school   2863 Public Schools-Multidistrict Charters La Farge   9407 Vernon County Area Better Futures High charter           2018   pk_12_total                                                   0                                             0
3094677 3094677 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002909 220 Innovative & Alternative Middle   Alternative School No Middle 06 08 2018   pk_12_total                                                   0                                             0
3094758 3094758 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002670 820 Metro School   Alternative School No Other 04 12 2018   pk_12_total   9.0 2.0 1.0             1.0   13.0               *     6   13   9 2 1             1   13               6   13
3094900 3094900 WI Waupaca   school   3276 Public Schools-Multidistrict Charters Manawa   9408 Waupaca County Charter charter           2018   pk_12_total                                                   0                                             0
3095010 3095010 WI Marathon   school 5508670 3304 Public school Marathon City 550867000992 40 Marathon High   Regular School No High 09 12 2018   pk_12_total                                                   0                                             0
3095011 3095011 WI Marathon   school 5508670 3304 Public school Marathon City 550867002893 210 Marathon Venture Academy charter Regular School Yes Middle 06 08 2018   pk_12_total                                                   0                                             0
3095077 3095077 WI Dane   school   3332 Public Schools-Multidistrict Charters Marshall   9803 JEDI Virtual K-12 charter           2018   pk_12_total                                                   0                                             0
3097573 3097573 WI Juneau   school   3871 Public Schools-Multidistrict Charters Necedah Area   9405 Juneau County Charter School charter           2018   pk_12_total                                                   0                                             0
3097951 3097951 WI Waukesha   school 5510710 3976 Public school Norris 551071003072 800 Norris Academy Virtual School charter Alternative School Yes Other KG 12 2018   pk_12_total                                                   0                                             0
3097952 3097952 WI Waukesha   school 5510710 3976 Public school Norris 551071001395 20 Norris High   Regular School No High 06 12 2018   pk_12_total 9.0 11.0                     20.0               6     8   20 9 11                     20           6   8   20
3099412 3099412 WI Racine   school 5512360 4620 Public school Racine Unified 551236000458 172 P-COC Parent-Child Oriented Classroom   Regular School No Prekindergarten PK PK 2018   pk_12_total                                                   0                                             0
3099995 3099995 WI Juneau   school   1673 Public Schools-Multidistrict Charters Royall   9405 Juneau County Charter Sch charter           2018   pk_12_total                                                   0                                             0
3100886 3100886 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001125 320 Juvenile Detention   Alternative School No Other KG 12 2018   pk_12_total 1.0                       1.0               *     *   1 1                       1                   1
3101815 3101815 WI Jefferson   school   6118 Public Schools-Multidistrict Charters Waterloo   9803 JEDI Virtual K-12 charter           2018   pk_12_total                                                   0                                             0
3102692 3102692 WI Washington   school 5516290 6307 Public school West Bend 551629002133 180 Washington County Head Start & West Bend Title I   Regular School No Elementary PK KG 2018   pk_12_total                                                   0                                             0
3102943 3102943 WI Walworth   school   6461 Public Schools-Multidistrict Charters Whitewater Unified   9803 JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive charter           2018   pk_12_total                                                   0                                             0
3103257 3103257 WI Juneau   school   6713 Public Schools-Multidistrict Charters Wonewoc-Union Center   9405 Juneau County Charter School charter           2018   pk_12_total                                                   0                                             0
3103276 3103276 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713003059 850 Wonewoc-Center Virtual Academy charter Regular School Yes Other KG 12 2018   pk_12_total                     1.0   1.0               *     *   1                     1   1                   1
111963 111963 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2015   pk_12_total 2.0   1.0                   2.0 1.0             *     *   3 2   1                   2 1                 3
112378 112378 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2015   pk_12_total 1.0                         1.0             *     *   1 1                         1                 1
113193 113193 WI Ashland   school 5501920 840 Public school Butternut 550192002751 450 Promethean Charter School charter Regular School Yes 3.0 09 12 2015   pk_12_total 4.0                       3.0 1.0             *     *   4 4                       3 1                 4
114104 114104 WI Walworth   school   1380 Public Schools-Multidistrict Charters Delavan-Darien   9401 Walworth Co Educ Alt High charter           2015   pk_12_total 6.0   1.0     1.0             7.0 1.0             *     1   8 6   1     1             7 1             1   8
114761 114761 WI Rusk   school 5514970 5757 Public school Flambeau 551497002684 410 Whitetail Academy charter Regular School Yes 3.0 09 12 2015   pk_12_total 5.0                       4.0 1.0             *     *   5 5                       4 1                 5
117035 117035 WI Manitowoc   school 5507440 2828 Public school Kiel Area 550744002554 405 Kiel eSchool charter Regular School Yes 3.0 07 12 2015   pk_12_total 5.0                       4.0 1.0             *     *   5 5                       4 1                 5
121406 121406 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095002736 410 New Path charter Alternative Education School Yes 4.0 06 12 2015   pk_12_total 9.0                   1.0   9.0 1.0             *     *   10 9                   1   9 1                 10
122923 122923 WI Pierce   school 5513050 4893 Public school River Falls 551305002999 430 River Falls eSchool charter Regular School Yes 4.0 06 12 2015   pk_12_total 1.0                         1.0             *     *   1 1                         1                 1
124045 124045 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001145 350 Preschool Options   Special Education School No 1.0 PK PK 2015   pk_12_total 1.0     1.0                 1.0 1.0             *     *   2 1     1                 1 1                 2
282859 282859 WI Washburn   school 5501170 441 Public school Birchwood 550117003020 800 Bobcat Virtual Academy charter Regular School Yes 4.0 PK 12 2016   pk_12_total 2.0                       1.0 1.0             *     *   2 2                       1 1                 2
284019 284019 WI Vernon   school 5503240 1421 Public school De Soto Area 550324003022 810 De Soto Virtual School charter Regular School Yes 4.0 PK 12 2016   pk_12_total 1.0                         1.0             *     *   1 1                         1                 1
284364 284364 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002658 800 Second Avenue School   Alternative Education School No 4.0 04 12 2016   pk_12_total 4.0 3.0                 1.0   7.0 1.0             *     *   8 4 3                 1   7 1                 8
284979 284979 WI Milwaukee   school 5504830 1900 Public school Franklin Public 550483002685 400 Milwaukee County Correctional Facility South   Alternative Education School No 3.0 10 12 2016   pk_12_total 2.0 41.0 4.0                   46.0 1.0                   13   47 2 41 4                   46 1             13   47
287377 287377 WI Jefferson   school   2898 Public Schools-Multidistrict Charters Lake Mills Area   9803 JEDI Virtual K-12 charter           2016   pk_12_total 1.0                         1.0             *     *   1 1                         1                 1
287989 287989 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861002714 9120 Manitowoc County Comprehensive Charter School charter Special Education School Yes 1.0 01 08 2016   pk_12_total 3.0 1.0                 1.0   4.0 1.0             *     *   5 3 1                 1   4 1                 5
290005 290005 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002555 825 St Charles Behav Reassign Success Acad   Alternative Education School No 4.0 06 12 2016   pk_12_total   5.0 1.0                   5.0 1.0             *     *   6   5 1                   5 1                 6
290622 290622 WI Juneau   school   3871 Public Schools-Multidistrict Charters Necedah Area   9405 Juneau County Charter School charter           2016   pk_12_total 5.0   1.0                   5.0 1.0             *     *   6 5   1                   5 1                 6
293929 293929 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001125 320 Juvenile Detention   Alternative Education School No 4.0 KG 12 2016   pk_12_total 2.0                       1.0 1.0             *     *   2 2                       1 1                 2
294497 294497 WI Barron   school 5515060 5810 Public school Turtle Lake 551506003032 810 Laker Online charter Regular School Yes 4.0 PK 12 2016   pk_12_total 1.0                         1.0             *     *   1 1                         1                 1
296243 296243 WI Juneau   school   6713 Public Schools-Multidistrict Charters Wonewoc-Union Center   9405 Juneau County Charter School charter           2016   pk_12_total 1.0                         1.0             *     *   1 1                         1                 1
325625 325625 WI Clark   school   7 Public Schools-Multidistrict Charters Abbotsford   9100 Rural Virtual Academy charter           2017   pk_12_total 1.0                         1.0             *     *   1 1                         1                 1
325861 325861 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002679 800 Appleton Cooperative Educational Center   Alternative School No Other 04 12 2017   pk_12_total 1.0   1.0 1.0                 2.0 1.0             *     *   3 1   1 1                 2 1                 3
330352 330352 WI Rock   school 5507020 2695 Public school Janesville 550702002948 850 Youth Services Center   Alternative School No Other 04 12 2017   pk_12_total 3.0 6.0                 1.0   9.0 1.0             *     *   10 3 6                 1   9 1                 10
330920 330920 WI Vernon   school   5960 Public Schools-Multidistrict Charters Kickapoo Area   9407 Vernon County Area Better Futures High charter           2017   pk_12_total 1.0                         1.0             *     *   1 1                         1                 1
331601 331601 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002909 220 Innovative & Alternative Middle   Alternative School No Middle 06 08 2017   pk_12_total   1.0                       1.0             *     *   1   1                       1                 1
334748 334748 WI Juneau   school 5510560 3948 Public school New Lisbon 551056002517 9405 Juneau County Charter School charter Regular School Yes High 07 12 2017   pk_12_total 2.0                       1.0 1.0             *     *   2 2                       1 1                 2
338549 338549 WI Dane   school 5515330 5901 Public school Verona Area 551533002285 110 Early Childhood   Regular School No Elementary PK PK 2017   pk_12_total 10.0   3.0               1.0   13.0 1.0                   *   14 10   3               1   13 1                 14
339619 339619 WI Washington   school 5516290 6307 Public school West Bend 551629002666 400 Washington Street School   Alternative School No Other 06 12 2017   pk_12_total 1.0                         1.0             *     *   1 1                         1                 1
2318148 2318148 WI Clark   school   7 Public Schools-Multidistrict Charters Abbotsford   9100 Rural Virtual Academy charter           2020   pk_12_total 2.0                       1.0 1.0             *     *   2 2                       1 1                 2
2319612 2319612 WI Chippewa   school   870 Public Schools-Multidistrict Charters Cadott Community   9419 eSucceed Charter School charter           2020   pk_12_total 1.0                         1.0             *     *   1 1                         1                 1
2320819 2320819 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002658 800 Second Avenue School   Alternative School No Other 04 12 2020   pk_12_total 10.0 1.0                     10.0 1.0             2     2   11 10 1                     10 1         2   2   11
2321623 2321623 WI Taylor   school 5505280 2135 Public school Gilman 550528003114 9419 eSucceed Charter School charter Regular School Yes High 09 12 2020   pk_12_total 1.0                         1.0             *     *   1 1                         1                 1
2323821 2323821 WI Walworth   school 5507650 2884 Public school Lake Geneva-Genoa City UHS 550765003109 410 New Visions Charter School charter Regular School Yes High 09 12 2020   pk_12_total     1.0                     1.0             *     *   1     1                     1                 1
2323826 2323826 WI Chippewa   school   2891 Public Schools-Multidistrict Charters Lake Holcombe   9419 eSucceed Charter School charter           2020   pk_12_total 1.0                         1.0             *     *   1 1                         1                 1
2324304 2324304 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002670 820 Metro School   Alternative School No Other 04 12 2020   pk_12_total 2.0 10.0                 1.0   12.0 1.0             7     7   13 2 10                 1   12 1         7   7   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]);