enrollments

Data source: Big Local News · About: Big Local

103,197 rows where state = "WI" sorted by total descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
118513 118513 WI Dunn   school 5509090 3444 Public school Menomonie Area 550909001079 180 Menomonie High   Regular School No 3.0 09 12 2015   pk_12_total 866.0 10.0 27.0 1.0   60.0       3.0 31.0   507.0 491.0             351     129   998 866 10 27 1   60       3 31   507 491         351   129   998
332563 332563 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951000754 50 Glacier Creek Middle   Regular School No Middle 05 08 2017   pk_12_total 773.0 38.0 64.0 3.0   81.0         37.0   505.0 491.0             144     99   996 773 38 64 3   81         37   505 491         144   99   996
338160 338160 WI Douglas   school 5514670 5663 Public school Superior 551467001907 60 Superior Middle   Regular School No Middle 06 08 2017   pk_12_total 867.0 37.0 17.0 37.0   15.0       2.0 21.0   522.0 474.0             432     187   996 867 37 17 37   15       2 21   522 474         432   187   996
2345710 2345710 WI Douglas   school 5514670 5663 Public school Superior 551467001907 60 Superior Middle   Regular School No Middle 06 08 2021   pk_12_total 847.0 30.0 23.0 14.0   13.0         68.0   502.0 493.0     3.0       549     180   995 847 30 23 14   13         68   502 493     3   549   180   995
288301 288301 WI Dane   school 5508910 3381 Public school McFarland 550891002975 430 Wisconsin Virtual Academy High (WIVA) charter Regular School Yes 3.0 09 12 2016   pk_12_total 752.0 81.0 88.0 12.0   7.0         54.0   405.0 589.0             308     156   994 752 81 88 12   7         54   405 589         308   156   994
2321354 2321354 WI Jefferson   school 5504740 1883 Public school Fort Atkinson 550474000510 80 Fort Atkinson High   Regular School No High 09 12 2020   pk_12_total 885.0 12.0 55.0 8.0   16.0       3.0 14.0   505.0 488.0             344     134   993 885 12 55 8   16       3 14   505 488         344   134   993
2346084 2346084 WI Racine   school 5515150 5852 Public school Union Grove UHS 551515001963 20 Union Grove High   Regular School No High 09 12 2021   pk_12_total 868.0 5.0 79.0 3.0   10.0       1.0 27.0   490.0 503.0     6.0       142     80   993 868 5 79 3   10       1 27   490 503     6   142   80   993
282432 282432 WI Sauk   school 5500810 280 Public school Baraboo 550081000103 40 Baraboo High   Regular School No 3.0 09 12 2016   pk_12_total 870.0 8.0 65.0 31.0   9.0       1.0 8.0   519.0 473.0             367     138   992 870 8 65 31   9       1 8   519 473         367   138   992
2333477 2333477 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000081 20 Ashwaubenon High   Regular School No High 09 12 2021   pk_12_total 722.0 38.0 91.0 22.0   37.0         82.0   495.0 497.0     22.0       353     115   992 722 38 91 22   37         82   495 497     22   353   115   992
334023 334023 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002272 33 Vincent High   Regular School No High 09 12 2017   pk_12_total 22.0 911.0 21.0 1.0   21.0         15.0   558.0 433.0             774     253   991 22 911 21 1   21         15   558 433         774   253   991
334222 334222 WI Dane   school 5509810 3675 Public school Monona Grove 550981001291 60 Monona Grove High   Regular School No High 09 12 2017   pk_12_total 820.0 35.0 64.0 2.0   33.0         37.0   498.0 493.0             156     86   991 820 35 64 2   33         37   498 493         156   86   991
2342312 2342312 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062001390 60 New Richmond High   Regular School No High 09 12 2021   pk_12_total 894.0 11.0 28.0 5.0   15.0       1.0 37.0   510.0 481.0     3.0       257     117   991 894 11 28 5   15       1 37   510 481     3   257   117   991
112532 112532 WI Barron   school 5500870 308 Public school Barron Area 550087000114 30 Barron High   Regular School No 3.0 09 12 2015   grade_10                                                   99                                             99
112732 112732 WI Rock   school 5501050 413 Public school Beloit 550105000141 110 Gaston Elementary   Regular School No 1.0 PK 03 2015   grade_2                                                   99                                             99
113131 113131 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes 1.0 PK 08 2015   grade_6                                                   99                                             99
113485 113485 WI Calumet   school 5502520 1085 Public school Chilton 550252000278 20 Chilton Elementary   Regular School No 1.0 PK 04 2015   grade_2                                                   99                                             99
113500 113500 WI Calumet   school 5502520 1085 Public school Chilton 550252002430 30 Chilton Middle   Regular School No 2.0 05 08 2015   grade_8                                                   99                                             99
113605 113605 WI Rock   school 5502640 1134 Public school Clinton Community 550264000297 80 Clinton Middle   Regular School No 2.0 05 08 2015   grade_5                                                   99                                             99
113739 113739 WI Chippewa   school 5502880 1204 Public school Cornell 550288002896 300 Cornell Middle   Regular School No 2.0 06 08 2015   pk_12_total 93.0 1.0 3.0 2.0                 56.0 43.0             62     15   99 93 1 3 2                 56 43         62   15   99
113998 113998 WI Dane   school 5503180 1316 Public school De Forest Area 550318000108 160 Yahara Elementary   Regular School No 1.0 KG 04 2015   kindergarten                                                   99                                             99
114030 114030 WI Brown   school 5503210 1414 Public school De Pere 550321002668 100 Susie C Altmayer Elementary   Regular School No 1.0 PK 04 2015   kindergarten                                                   99                                             99
114137 114137 WI Brown   school 5503660 1407 Public school Denmark 550366000389 100 Denmark Middle   Regular School No 2.0 06 08 2015   grade_6                                                   99                                             99
115022 115022 WI Outagamie   school 5504920 1953 Public school Freedom Area 550492000532 20 Freedom Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   99                                             99
115473 115473 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002589 110 Green Bay Head Start   Regular School No 1.0 PK KG 2015   kindergarten_4_year_old                                                   99                                             99
115816 115816 WI Waukesha   school 5506030 2420 Public school Hamilton 550603000667 120 Marcy Elementary   Regular School No 1.0 KG 05 2015   grade_3                                                   99                                             99
115817 115817 WI Waukesha   school 5506030 2420 Public school Hamilton 550603000667 120 Marcy Elementary   Regular School No 1.0 KG 05 2015   grade_4                                                   99                                             99
115848 115848 WI Washington   school 5506090 2443 Public school Hartford J1 550609000676 50 Rossman Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   99                                             99
116062 116062 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No 1.0 PK 04 2015   grade_1                                                   99                                             99
116076 116076 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660000714 20 Hortonville Elementary   Regular School No 1.0 PK 04 2015   grade_2                                                   99                                             99
116090 116090 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002408 30 Hortonville Middle   Regular School No 2.0 05 08 2015   grade_7                                                   99                                             99
116135 116135 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663000718 50 Meadowbrook Elementary   Regular School No 1.0 PK 04 2015   grade_2                                                   99                                             99
117389 117389 WI Jefferson   school 5507710 2898 Public school Lake Mills Area 550771000889 100 Lake Mills Elementary   Regular School No 1.0 PK 04 2015   grade_4                                                   99                                             99
117506 117506 WI Outagamie   school 5508160 3129 Public school Little Chute Area 550816000901 40 Little Chute High   Regular School No 3.0 09 12 2015   grade_11                                                   99                                             99
117508 117508 WI Outagamie   school 5508160 3129 Public school Little Chute Area 550816000901 40 Little Chute High   Regular School No 3.0 09 12 2015   grade_9                                                   99                                             99
117510 117510 WI Outagamie   school 5508160 3129 Public school Little Chute Area 550816002858 100 Little Chute Intermediate   Regular School No 2.0 05 06 2015   grade_5                                                   99                                             99
117530 117530 WI Columbia   school 5508190 3150 Public school Lodi 550819000903 20 Lodi Primary   Regular School No 1.0 PK KG 2015   pk_12_total 83.0   9.0     2.0         5.0   49.0 50.0             22     15   99 83   9     2         5   49 50         22   15   99
117548 117548 WI Dodge   school 5508220 3171 Public school Lomira 550822000908 60 Lomira High   Regular School No 3.0 09 12 2015   grade_10                                                   99                                             99
118181 118181 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No 1.0 KG 06 2015   grade_5                                                   99                                             99
118326 118326 WI Taylor   school 5508940 3409 Public school Medford Area Public 550894002361 180 Medford Elementary   Regular School No 1.0 PK 04 2015   kindergarten_4_year_old                                                   99                                             99
118736 118736 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951000755 150 Sunset Ridge Elementary   Regular School No 1.0 PK 04 2015   grade_4                                                   99                                             99
118987 118987 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002755 407 Carmen High School of Science and Technology charter Regular School Yes 3.0 09 12 2015   grade_9                                                   99                                             99
119563 119563 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001317 1121 La Causa Charter School charter Regular School Yes 1.0 PK 08 2015   grade_2                                                   99                                             99
119781 119781 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001155 146 Milwaukee German Immersion   Regular School No 1.0 PK 05 2015   kindergarten_4_year_old                                                   99                                             99
119897 119897 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003010 474 NOVA Tech charter Vocational Education School Yes 3.0 09 12 2015   pk_12_total 5.0 93.0 1.0                   41.0 58.0             74     25   99 5 93 1                   41 58         74   25   99
120251 120251 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes 4.0 PK 12 2015   grade_2                                                   99                                             99
120785 120785 WI Wood   school 5510380 3906 Public school Nekoosa 551038001358 20 Alexander Middle   Regular School No 2.0 04 08 2015   grade_8                                                   99                                             99
121004 121004 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062002789 170 New Richmond Hillside Elementary   Regular School No 1.0 KG 05 2015   grade_2                                                   99                                             99
121005 121005 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062002789 170 New Richmond Hillside Elementary   Regular School No 1.0 KG 05 2015   grade_3                                                   99                                             99
121006 121006 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062002789 170 New Richmond Hillside Elementary   Regular School No 1.0 KG 05 2015   grade_4                                                   99                                             99
121359 121359 WI Waukesha   school 5510890 4060 Public school Oconomowoc Area 551089001420 90 Meadow View Elementary   Regular School No 1.0 PK 04 2015   grade_1                                                   99                                             99
121892 121892 WI Marinette   school 5511610 4305 Public school Peshtigo 551161001534 100 Peshtigo Middle/High   Regular School No 3.0 07 12 2015   grade_9                                                   99                                             99
121978 121978 WI Grant   school 5511850 4389 Public school Platteville 551185001551 20 Wilkins Elementary   Regular School No 1.0 PK 01 2015   kindergarten_4_year_old                                                   99                                             99
122898 122898 WI Fond du Lac   school 5513020 4872 Public school Ripon Area 551302001718 120 Ripon High   Regular School No 3.0 09 12 2015   grade_11                                                   99                                             99
123716 123716 WI Saint Croix   school 5514010 5432 Public school Somerset 551401001108 60 Somerset Middle   Regular School No 2.0 05 08 2015   grade_7                                                   99                                             99
124199 124199 WI Dane   school 5514640 5656 Public school Sun Prairie Area 551464001899 40 Eastside Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   99                                             99
125617 125617 WI Milwaukee   school 5516260 6300 Public school West Allis-West Milwaukee 551626002108 160 Jefferson Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   99                                             99
125726 125726 WI Washington   school 5516290 6307 Public school West Bend 551629002130 70 Green Tree Elementary   Regular School No 1.0 PK 04 2015   grade_4                                                   99                                             99
126245 126245 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002791 180 Vesper Community Academy   Regular School No 1.0 PK 05 2015   pk_12_total 97.0 2.0                     58.0 41.0             26     22   99 97 2                     58 41         26   22   99
281866 281866 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Pedersen Elementary   Regular School No 1.0 PK 03 2016   kindergarten_4_year_old                                                   99                                             99
281928 281928 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000043 200 Pleasant View Elementary   Regular School No 1.0 PK 05 2016   pk_12_total 95.0                   4.0   48.0 51.0             47     9   99 95                   4   48 51         47   9   99
282102 282102 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000056 200 Huntley Elementary   Regular School No 1.0 PK 06 2016   grade_2                                                   99                                             99
282760 282760 WI Rock   school 5501050 413 Public school Beloit 550105000153 320 Todd Elementary   Regular School No 1.0 PK 03 2016   grade_1                                                   99                                             99
282762 282762 WI Rock   school 5501050 413 Public school Beloit 550105000153 320 Todd Elementary   Regular School No 1.0 PK 03 2016   grade_3                                                   99                                             99
283080 283080 WI Milwaukee   school 5501800 721 Public school Brown Deer 550180000232 80 Brown Deer Elementary   Regular School No 1.0 PK 06 2016   kindergarten                                                   99                                             99
283906 283906 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317002288 70 Riverside Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   99                                             99
284001 284001 WI Brown   school 5503210 1414 Public school De Pere 550321001254 50 Heritage Elementary   Regular School No 1.0 PK 04 2016   kindergarten                                                   99                                             99
284682 284682 WI Rock   school 5504440 1694 Public school Evansville Community 550444000477 20 Levi Leonard Elementary   Regular School No 1.0 PK 02 2016   grade_2                                                   99                                             99
284943 284943 WI Milwaukee   school 5504800 1890 Public school Fox Point J2 550480000517 20 Bayside Middle   Regular School No 2.0 05 08 2016   grade_7                                                   99                                             99
285234 285234 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No 2.0 04 08 2016   grade_5                                                   99                                             99
285821 285821 WI Waukesha   school 5506030 2420 Public school Hamilton 550603000667 120 Marcy Elementary   Regular School No 1.0 KG 05 2016   grade_5                                                   99                                             99
285834 285834 WI Waukesha   school 5506030 2420 Public school Hamilton 550603001676 150 Woodside Elementary   Regular School No 1.0 KG 05 2016   grade_4                                                   99                                             99
285852 285852 WI Washington   school 5506090 2443 Public school Hartford J1 550609000676 50 Rossman Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   99                                             99
285857 285857 WI Washington   school 5506090 2443 Public school Hartford J1 550609000676 50 Rossman Elementary   Regular School No 1.0 PK 05 2016   kindergarten                                                   99                                             99
286029 286029 WI La Crosse   school 5506540 2562 Public school Holmen 550654002298 100 Viking Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   99                                             99
286099 286099 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663002709 120 Bay Harbor Elementary   Regular School No 1.0 PK 04 2016   grade_3                                                   99                                             99
286114 286114 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663002409 40 Forest Glen Elementary   Regular School No 1.0 PK 04 2016   grade_3                                                   99                                             99
286117 286117 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663002409 40 Forest Glen Elementary   Regular School No 1.0 PK 04 2016   kindergarten                                                   99                                             99
286792 286792 WI Kenosha   school 5507320 2793 Public school Kenosha 550732002653 170 Nash Elementary   Regular School No 1.0 PK 05 2016   grade_5                                                   99                                             99
286979 286979 WI Washington   school 5507380 2800 Public school Kewaskum 550738000839 100 i4Learning Community School charter Regular School Yes 1.0 PK 05 2016   pk_12_total 94.0 1.0 3.0               1.0   51.0 48.0             13     12   99 94 1 3               1   51 48         13   12   99
287372 287372 WI Chippewa   school 5507680 2891 Public school Lake Holcombe 550768000886 40 Holcombe High   Regular School No 3.0 09 12 2016   pk_12_total 88.0 4.0 4.0               3.0   54.0 45.0             43     14   99 88 4 4               3   54 45         43   14   99
287509 287509 WI Outagamie   school 5508160 3129 Public school Little Chute Area 550816000902 60 Little Chute Middle   Regular School No 2.0 07 08 2016   grade_7                                                   99                                             99
287639 287639 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002483 110 Cesar Chavez Elementary   Regular School No 1.0 PK 05 2016   grade_5                                                   99                                             99
287905 287905 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852000932 270 Stephens Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   99                                             99
288168 288168 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No 1.0 KG 06 2016   grade_2                                                   99                                             99
288171 288171 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No 1.0 KG 06 2016   grade_5                                                   99                                             99
288263 288263 WI Dodge   school 5508880 3367 Public school Mayville 550888001030 80 Mayville High   Regular School No 3.0 09 12 2016   grade_10                                                   99                                             99
288264 288264 WI Dodge   school 5508880 3367 Public school Mayville 550888001030 80 Mayville High   Regular School No 3.0 09 12 2016   grade_11                                                   99                                             99
289331 289331 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002979 880 HAPA-Hmong Amer Peace Academy K3-12 charter Regular School Yes 4.0 PK 12 2016   grade_7                                                   99                                             99
289597 289597 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001209 256 Longfellow Elementary   Regular School No 1.0 PK 08 2016   grade_6                                                   99                                             99
289602 289602 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001209 256 Longfellow Elementary   Regular School No 1.0 PK 08 2016   kindergarten                                                   99                                             99
289666 289666 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001164 176 Meir School   Regular School No 4.0 03 10 2016   grade_5                                                   99                                             99
289751 289751 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001155 146 Milwaukee German Immersion   Regular School No 1.0 PK 05 2016   kindergarten_4_year_old                                                   99                                             99
289828 289828 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001221 52 Morse Marshall   Regular School No 4.0 06 12 2016   grade_7                                                   99                                             99
289866 289866 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003010 474 NOVA Tech charter Vocational Education School Yes 3.0 09 12 2016   pk_12_total 6.0 89.0 4.0                   38.0 61.0             34     16   99 6 89 4                   38 61         34   16   99
291056 291056 WI Fond du Lac   school 5510740 3983 Public school North Fond du Lac 551074001398 55 Friendship Learning Elementary   Regular School No 1.0 01 05 2016   grade_2                                                   99                                             99
291499 291499 WI Dane   school 5511100 4144 Public school Oregon 551110001469 40 Netherwood Knoll Elementary   Regular School No 1.0 PK 04 2016   grade_4                                                   99                                             99
292058 292058 WI Columbia   school 5512060 4501 Public school Portage Community 551206002310 90 Muir Elementary School   Regular School No 1.0 02 05 2016   grade_2                                                   99                                             99
292214 292214 WI Pierce   school 5512240 4578 Public school Prescott 551224001592 60 Prescott High   Regular School No 3.0 09 12 2016   grade_10                                                   99                                             99
292991 292991 WI Milwaukee   school 5500071 8133 Non District Charter Schools Rocketship Southside Community Prep 550007102969 100 Rocketship Southside Community Prep charter Regular School Yes 1.0 PK 05 2016   grade_1                                                   99                                             99
293468 293468 WI Sheboygan   school 5513650 5271 Public school Sheboygan Area 551365001800 400 Wilson Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   99                                             99

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