enrollments

Data source: Big Local News · About: Big Local

14,749 rows where state = "WI" and year = 2019 sorted by total descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 14,749 ✖
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
3074256 3074256 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000055 180 Highlands Elementary   Regular School No Elementary PK 06 2019   grade_2                                                   99                                             99
3074278 3074278 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002366 195 Houdini Elementary   Regular School No Elementary PK 06 2019   kindergarten                                                   99                                             99
3075117 3075117 WI Chippewa   school 5501350 497 Public school Bloomer 550135000185 60 Bloomer Middle   Regular School No Middle 05 08 2019   grade_6                                                   99                                             99
3075235 3075235 WI Kenosha   school 5501710 665 Public school Bristol #1 550171000209 20 Bristol Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   99                                             99
3076198 3076198 WI Dane   school 5503180 1316 Public school De Forest Area 550318000354 20 Eagle Point Elementary   Regular School No Elementary KG 04 2019   grade_3                                                   99                                             99
3076687 3076687 WI Dunn   school 5504230 1645 Public school Elk Mound Area 550423000454 60 Mound View Elementary   Regular School No Elementary PK 04 2019   grade_1                                                   99                                             99
3076768 3076768 WI Pierce   school 5504320 1659 Public school Ellsworth Community 550432000465 60 Ellsworth Elementary   Regular School No Elementary PK 05 2019   grade_2                                                   99                                             99
3078211 3078211 WI La Crosse   school 5506540 2562 Public school Holmen 550654002298 100 Viking Elementary   Regular School No Elementary PK 05 2019   grade_4                                                   99                                             99
3078960 3078960 WI Kenosha   school 5507320 2793 Public school Kenosha 550732001462 480 Lakeview Technology Academy   Career and Technical School No High 09 12 2019   grade_9                                                   99                                             99
3079001 3079001 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000820 420 Pleasant Prairie Elementary   Regular School No Elementary PK 05 2019   kindergarten                                                   99                                             99
3079289 3079289 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747000851 110 Westside Elementary   Regular School No Elementary KG 04 2019   grade_2                                                   99                                             99
3079690 3079690 WI Outagamie   school 5508160 3129 Public school Little Chute Area 550816002959 130 Flex Academy charter Regular School Yes Elementary KG 08 2019   pk_12_total 90.0 4.0 1.0               4.0   41.0 58.0             27     11   99 90 4 1               4   41 58         27   11   99
3079852 3079852 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002483 110 Cesar Chavez Elementary   Regular School No Elementary PK 05 2019   grade_2                                                   99                                             99
3080257 3080257 WI Douglas   school 5508640 3297 Public school Maple 550864000988 170 Northwestern Middle   Regular School No Middle 06 08 2019   grade_8                                                   99                                             99
3080558 3080558 WI Taylor   school 5508940 3409 Public school Medford Area Public 550894002361 180 Medford Elementary   Regular School No Elementary PK 04 2019   kindergarten                                                   99                                             99
3080963 3080963 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951000755 150 Sunset Ridge Elementary   Regular School No Elementary PK 04 2019   kindergarten                                                   99                                             99
3081044 3081044 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001122 73 Allen-Field Elementary   Regular School No Elementary PK 05 2019   grade_5                                                   99                                             99
3081072 3081072 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002782 434 Audubon Technology and Communication High   Regular School No High 09 12 2019   grade_12                                                   99                                             99
3081445 3081445 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001163 173 Forest Home Elementary   Regular School No Elementary PK 05 2019   kindergarten                                                   99                                             99
3082292 3082292 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001156 149 Starms Early Childhood   Regular School No Elementary PK KG 2019   kindergarten_4_year_old                                                   99                                             99
3083203 3083203 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062002789 170 New Richmond Hillside Elementary   Regular School No Elementary KG 05 2019   grade_4                                                   99                                             99
3083574 3083574 WI Waukesha   school 5510890 4060 Public school Oconomowoc Area 551089001420 90 Meadow View Elementary   Regular School No Elementary PK 04 2019   grade_4                                                   99                                             99
3083778 3083778 WI Polk   school 5511160 4165 Public school Osceola 551116001479 40 Osceola Elementary   Regular School No Elementary PK 02 2019   kindergarten                                                   99                                             99
3084423 3084423 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215001584 60 Prairie du Chien High   Regular School No High 09 12 2019   grade_9                                                   99                                             99
3084471 3084471 WI Pierce   school 5512240 4578 Public school Prescott 551224001592 60 Prescott High   Regular School No High 09 12 2019   grade_11                                                   99                                             99
3084615 3084615 WI Racine   school 5512360 4620 Public school Racine Unified 551236001623 132 Jefferson Lighthouse Elementary   Regular School No Elementary KG 05 2019   grade_3                                                   99                                             99
3085843 3085843 WI Washington   school 5513950 5390 Public school Slinger 551395001819 20 Slinger Elementary   Regular School No Elementary PK 05 2019   grade_4                                                   99                                             99
3086330 3086330 WI Door   school 5514610 5642 Public school Sturgeon Bay 551461001894 10 Sturgeon Bay High   Regular School No High 09 12 2019   grade_11                                                   99                                             99
3086933 3086933 WI Dane   school 5515330 5901 Public school Verona Area 551533002647 130 Glacier Edge Elementary   Regular School No Elementary KG 05 2019   grade_5                                                   99                                             99
3087144 3087144 WI Jefferson   school 5515750 6125 Public school Watertown Unified 551575001997 40 Douglas Elementary   Regular School No Elementary KG 05 2019   grade_5                                                   99                                             99
3087566 3087566 WI Marathon   school 5515900 6223 Public school Wausau 551590002060 300 Riverview Elementary   Regular School No Elementary PK 05 2019   kindergarten_4_year_old                                                   99                                             99
3087800 3087800 WI Crawford   school 5516020 6251 Public school Wauzeka-Steuben 551602002095 40 Wauzeka High   Regular School No High 09 12 2019   pk_12_total 95.0 1.0 1.0               2.0   62.0 37.0             54     14   99 95 1 1               2   62 37         54   14   99
3086856 3086856 WI Racine   school 5515150 5852 Public school Union Grove UHS 551515001963 20 Union Grove High   Regular School No High 09 12 2019   pk_12_total 863.0 4.0 88.0 4.0   15.0         12.0   506.0 480.0             110     77   986 863 4 88 4   15         12   506 480         110   77   986
3076711 3076711 WI Walworth   school 5504290 1638 Public school Elkhorn Area 550429000459 40 Elkhorn Area High   Regular School No High 09 12 2019   pk_12_total 791.0 13.0 134.0 4.0   15.0       1.0 22.0   498.0 482.0             265     107   980 791 13 134 4   15       1 22   498 482         265   107   980
3074261 3074261 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000055 180 Highlands Elementary   Regular School No Elementary PK 06 2019   kindergarten                                                   98                                             98
3075057 3075057 WI Lafayette   school 5505730 2240 Public school Black Hawk 550573000605 20 Black Hawk High   Regular School No High 09 12 2019   pk_12_total 97.0 1.0                     61.0 37.0             40     13   98 97 1                     61 37         40   13   98
3076199 3076199 WI Dane   school 5503180 1316 Public school De Forest Area 550318000354 20 Eagle Point Elementary   Regular School No Elementary KG 04 2019   grade_4                                                   98                                             98
3076465 3076465 WI Walworth   school 5504020 1540 Public school East Troy Community 550402001640 100 Prairie View Elementary   Regular School No Elementary 03 05 2019   grade_5                                                   98                                             98
3076856 3076856 WI Pierce   school 5504350 1666 Public school Elmwood 550435000347 30 Elmwood Middle   Regular School No Middle 05 08 2019   pk_12_total 87.0 1.0 6.0 1.0             3.0   56.0 42.0             40     8   98 87 1 6 1             3   56 42         40   8   98
3078031 3078031 WI Washington   school 5506090 2443 Public school Hartford J1 550609000676 50 Rossman Elementary   Regular School No Elementary PK 05 2019   grade_5                                                   98                                             98
3078232 3078232 WI Dodge   school 5506570 2576 Public school Horicon 550657000713 80 Horicon Junior High   Regular School No Middle 07 08 2019   pk_12_total 86.0 1.0 5.0 3.0             3.0   48.0 50.0             38     11   98 86 1 5 3             3   48 50         38   11   98
3078985 3078985 WI Kenosha   school 5507320 2793 Public school Kenosha 550732002653 170 Nash Elementary   Regular School No Elementary PK 05 2019   grade_3                                                   98                                             98
3079216 3079216 WI Kewaunee   school 5507410 2814 Public school Kewaunee 550741000841 100 Kewaunee High   Regular School No High 09 12 2019   grade_9                                                   98                                             98
3079633 3079633 WI Forest   school 5507830 2940 Public school Laona 550783000893 20 Laona High   Regular School No High 07 12 2019   pk_12_total 86.0   1.0 10.0           1.0     49.0 49.0             44     9   98 86   1 10           1     49 49         44   9   98
3079755 3079755 WI Dodge   school 5508220 3171 Public school Lomira 550822000908 60 Lomira High   Regular School No High 09 12 2019   grade_10                                                   98                                             98
3081838 3081838 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001209 256 Longfellow Elementary   Regular School No Elementary PK 08 2019   grade_3                                                   98                                             98
3083009 3083009 WI Wood   school 5510380 3906 Public school Nekoosa 551038003089 800 WISE Academy charter Regular School Yes Other PK 12 2019   pk_12_total 89.0   2.0 1.0             6.0   51.0 47.0             30         98 89   2 1             6   51 47         30       98
3083205 3083205 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062002789 170 New Richmond Hillside Elementary   Regular School No Elementary KG 05 2019   kindergarten                                                   98                                             98
3083299 3083299 WI Fond du Lac   school 5510740 3983 Public school North Fond du Lac 551074001398 55 Friendship Learning Elementary   Regular School No Elementary 01 05 2019   grade_3                                                   98                                             98
3083391 3083391 WI Vilas   school 5503860 1526 Public school Northland Pines 550386000406 90 Northland Pines High   Regular School No High 09 12 2019   grade_11                                                   98                                             98
3083777 3083777 WI Polk   school 5511160 4165 Public school Osceola 551116001479 40 Osceola Elementary   Regular School No Elementary PK 02 2019   kindergarten_4_year_old                                                   98                                             98
3085305 3085305 WI Saint Croix   school 5506060 2422 Public school Saint Croix Central 550606000672 60 Saint Croix Central High   Regular School No High 09 12 2019   grade_11                                                   98                                             98
3086698 3086698 WI Lincoln   school 5514940 5754 Public school Tomahawk 551494001948 220 Tomahawk Middle   Regular School No Middle 06 08 2019   grade_7                                                   98                                             98
3087143 3087143 WI Jefferson   school 5515750 6125 Public school Watertown Unified 551575001997 40 Douglas Elementary   Regular School No Elementary KG 05 2019   grade_4                                                   98                                             98
3088489 3088489 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707003365 430 River Cities High   Alternative School No High 09 12 2019   pk_12_total 78.0 4.0 4.0 2.0   4.0       1.0 5.0   60.0 38.0             70     22   98 78 4 4 2   4       1 5   60 38         70   22   98
3088029 3088029 WI Brown   school 5516320 6328 Public school West De Pere 551632002138 120 West De Pere High   Regular School No High 09 12 2019   pk_12_total 809.0 27.0 39.0 45.0   23.0       1.0 35.0   523.0 456.0             184     108   979 809 27 39 45   23       1 35   523 456         184   108   979
3083516 3083516 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001412 120 Oak Creek East Middle   Regular School No Middle 06 08 2019   pk_12_total 744.0 30.0 123.0 3.0   50.0       3.0 24.0   520.0 457.0             193     66   977 744 30 123 3   50       3 24   520 457         193   66   977
3085108 3085108 WI Pierce   school 5513050 4893 Public school River Falls 551305001724 80 River Falls High   Regular School No High 09 12 2019   pk_12_total 873.0 17.0 34.0 4.0   22.0       1.0 26.0   497.0 480.0             146     96   977 873 17 34 4   22       1 26   497 480         146   96   977
3087473 3087473 WI Marathon   school 5515900 6223 Public school Wausau 551590002063 360 East High   Regular School No High 09 12 2019   pk_12_total 702.0 30.0 64.0 5.0   121.0       1.0 54.0   514.0 463.0             377     136   977 702 30 64 5   121       1 54   514 463         377   136   977
3080736 3080736 WI Dunn   school 5509090 3444 Public school Menomonie Area 550909001079 180 Menomonie High   Regular School No High 09 12 2019   pk_12_total 841.0 8.0 30.0 1.0   58.0       2.0 32.0   512.0 460.0             307     137   972 841 8 30 1   58       2 32   512 460         307   137   972
3088222 3088222 WI Milwaukee   school 5516620 6419 Public school Whitefish Bay 551662002170 100 Whitefish Bay High   Regular School No High 09 12 2019   pk_12_total 740.0 75.0 49.0     57.0         49.0   484.0 486.0             20     79   970 740 75 49     57         49   484 486         20   79   970
3074401 3074401 WI Trempealeau   school 5500420 154 Public school Arcadia 550042003040 190 Arcadia Elementary   Regular School No Elementary PK 04 2019   kindergarten_4_year_old                                                   97                                             97
3074408 3074408 WI Trempealeau   school 5500420 154 Public school Arcadia 550042000068 40 Arcadia High   Regular School No High 09 12 2019   grade_9                                                   97                                             97
3074493 3074493 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000084 50 Pioneer Elementary   Regular School No Elementary KG 05 2019   grade_4                                                   97                                             97
3074929 3074929 WI Rock   school 5501050 413 Public school Beloit 550105000150 260 Robinson Elementary   Regular School No Elementary PK 03 2019   kindergarten                                                   97                                             97
3074940 3074940 WI Rock   school 5501050 413 Public school Beloit 550105000153 320 Todd Elementary   Regular School No Elementary PK 03 2019   grade_2                                                   97                                             97
3074941 3074941 WI Rock   school 5501050 413 Public school Beloit 550105000153 320 Todd Elementary   Regular School No Elementary PK 03 2019   grade_3                                                   97                                             97
3074992 3074992 WI Green Lake   school 5501140 434 Public school Berlin Area 550114000163 60 Clay Lamberton Elementary   Regular School No Elementary PK 05 2019   grade_1                                                   97                                             97
3075462 3075462 WI Barron   school 5502130 903 Public school Cameron 550213002286 200 Cameron Middle   Regular School No Middle 05 08 2019   grade_6                                                   97                                             97
3075478 3075478 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000259 40 Campbellsport High   Regular School No High 09 12 2019   grade_10                                                   97                                             97
3075689 3075689 WI Calumet   school 5502520 1085 Public school Chilton 550252002430 30 Chilton Middle   Regular School No Middle 05 08 2019   grade_6                                                   97                                             97
3075901 3075901 WI Columbia   school 5502820 1183 Public school Columbus 550282000318 40 Columbus High   Regular School No High 09 12 2019   grade_11                                                   97                                             97
3076103 3076103 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317001737 50 Evergreen Elementary   Regular School No Elementary PK 05 2019   grade_2                                                   97                                             97
3076208 3076208 WI Dane   school 5503180 1316 Public school De Forest Area 550318000360 140 Windsor Elementary   Regular School No Elementary KG 04 2019   grade_4                                                   97                                             97
3076230 3076230 WI Brown   school 5503210 1414 Public school De Pere 550321000363 40 Dickinson Elementary   Regular School No Elementary PK 04 2019   kindergarten                                                   97                                             97
3076635 3076635 WI Rock   school 5504110 1568 Public school Edgerton 550411000446 160 Yahara Elementary   Regular School No Elementary 01 05 2019   pk_12_total 76.0   9.0               12.0   46.0 51.0             33     12   97 76   9               12   46 51         33   12   97
3076809 3076809 WI Waukesha   school 5501770 714 Public school Elmbrook 550177002367 100 Dixon Elementary   Regular School No Elementary PK 05 2019   grade_5                                                   97                                             97
3077234 3077234 WI Outagamie   school 5504920 1953 Public school Freedom Area 550492000532 20 Freedom Elementary   Regular School No Elementary PK 05 2019   grade_1                                                   97                                             97
3077801 3077801 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000639 590 Sullivan Elementary   Regular School No Elementary PK 05 2019   grade_2                                                   97                                             97
3078389 3078389 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002735 150 River Crest Elementary   Regular School No Elementary PK 05 2019   grade_5                                                   97                                             97
3079384 3079384 WI La Crosse   school 5507530 2849 Public school La Crosse 550753000863 180 Lincoln Middle   Regular School No Middle 06 08 2019   grade_6                                                   97                                             97
3080379 3080379 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No Elementary PK 06 2019   grade_2                                                   97                                             97
3080381 3080381 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No Elementary PK 06 2019   grade_4                                                   97                                             97
3080480 3080480 WI Juneau   school 5508850 3360 Public school Mauston 550885001026 20 Olson Middle   Regular School No Middle 06 08 2019   grade_6                                                   97                                             97
3080713 3080713 WI Waukesha   school 5509060 3437 Public school Menomonee Falls 550906001067 200 Shady Lane Elementary   Regular School No Elementary PK 02 2019   grade_1                                                   97                                             97
3080908 3080908 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002882 400 Clark Street Community School charter Regular School Yes High 09 12 2019   pk_12_total 71.0 1.0 8.0 1.0   5.0         11.0   50.0 47.0             26     35   97 71 1 8 1   5         11   50 47         26   35   97
3080967 3080967 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951001113 160 West Middleton Elementary   Regular School No Elementary PK 04 2019   grade_2                                                   97                                             97
3082291 3082291 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001156 149 Starms Early Childhood   Regular School No Elementary PK KG 2019   kindergarten_3_year_old                                                   97                                             97
3083673 3083673 WI Winnebago   school 5510980 4088 Public school Omro 551098001441 60 Omro High   Regular School No High 09 12 2019   grade_11                                                   97                                             97
3083751 3083751 WI Dane   school 5511100 4144 Public school Oregon 551110001469 40 Netherwood Knoll Elementary   Regular School No Elementary PK 04 2019   grade_4                                                   97                                             97
3084207 3084207 WI Grant   school 5511850 4389 Public school Platteville 551185001551 20 Wilkins Elementary   Regular School No Elementary PK KG 2019   kindergarten                                                   97                                             97
3084329 3084329 WI Columbia   school 5512060 4501 Public school Portage Community 551206002310 90 Muir Elementary   Regular School No Elementary 02 05 2019   grade_5                                                   97                                             97
3085170 3085170 WI Sauk   school 5514250 5523 Public school River Valley 551425001856 100 River Valley Middle   Regular School No Middle 05 08 2019   grade_6                                                   97                                             97
3085301 3085301 WI Saint Croix   school 5506060 2422 Public school Saint Croix Central 550606000671 40 Saint Croix Central Elementary   Regular School No Elementary PK 04 2019   kindergarten                                                   97                                             97
3085476 3085476 WI Outagamie   school 5513530 5138 Public school Seymour Community 551353001771 60 Rock Ledge Elementary   Regular School No Elementary PK 05 2019   grade_3                                                   97                                             97
3085557 3085557 WI Sheboygan   school 5513650 5271 Public school Sheboygan Area 551365002859 451 Etude High charter Regular School Yes High 09 12 2019   pk_12_total 74.0 3.0 12.0     1.0         7.0   45.0 52.0             47     26   97 74 3 12     1         7   45 52         47   26   97
3085562 3085562 WI Sheboygan   school 5513650 5271 Public school Sheboygan Area 551365002899 250 Etude Middle charter Regular School Yes Middle 06 08 2019   pk_12_total 63.0 1.0 18.0 2.0   2.0         11.0   47.0 50.0             58     20   97 63 1 18 2   2         11   47 50         58   20   97
3087359 3087359 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002023 400 Waukesha STEM Academy charter Regular School Yes Elementary PK 08 2019   grade_7                                                   97                                             97
3087447 3087447 WI Fond du Lac   school 5515870 6216 Public school Waupun 551587002044 160 Meadow View Primary   Regular School No Elementary PK 01 2019   kindergarten_4_year_old                                                   97                                             97
3088408 3088408 WI Sauk   school 5517040 6678 Public school Wisconsin Dells 551704002201 120 Spring Hill Elementary   Regular School No Elementary PK 05 2019   grade_5                                                   97                                             97

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