enrollments

Data source: Big Local News · About: Big Local

14,702 rows where state = "WI" and year = 2018 sorted by total descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 14,702 ✖
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
3088816 3088816 WI Polk   school 5500300 119 Public school Amery 550030000075 50 Amery Intermediate   Regular School No Elementary 03 05 2018   grade_3                                                   99                                             99
3088824 3088824 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 02 2018   grade_1                                                   99                                             99
3089036 3089036 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000056 200 Huntley Elementary   Regular School No Elementary PK 06 2018   grade_1                                                   99                                             99
3089179 3089179 WI Lafayette   school 5500450 161 Public school Argyle 550045000070 40 Argyle High   Regular School No High 09 12 2018   pk_12_total 92.0 1.0 3.0     2.0         1.0   51.0 48.0             27     8   99 92 1 3     2         1   51 48         27   8   99
3089445 3089445 WI Barron   school 5500870 308 Public school Barron Area 550087000114 30 Barron High   Regular School No High 09 12 2018   grade_9                                                   99                                             99
3089681 3089681 WI Rock   school 5501050 413 Public school Beloit 550105000150 260 Robinson Elementary   Regular School No Elementary PK 03 2018   grade_1                                                   99                                             99
3089817 3089817 WI Lafayette   school 5505730 2240 Public school Black Hawk 550573000605 20 Black Hawk High   Regular School No High 09 12 2018   pk_12_total 98.0   1.0                   60.0 39.0             27     11   99 98   1                   60 39         27   11   99
3089995 3089995 WI Kenosha   school 5501710 665 Public school Bristol #1 550171000209 20 Bristol Elementary   Regular School No Elementary PK 08 2018   grade_3                                                   99                                             99
3090211 3090211 WI Barron   school 5502130 903 Public school Cameron 550213002286 200 Cameron Middle   Regular School No Middle 05 08 2018   grade_5                                                   99                                             99
3090283 3090283 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No High 07 12 2018   pk_12_total 97.0 1.0       1.0             50.0 49.0             40     11   99 97 1       1             50 49         40   11   99
3090939 3090939 WI Dane   school 5503180 1316 Public school De Forest Area 550318000354 20 Eagle Point Elementary   Regular School No Elementary KG 04 2018   grade_3                                                   99                                             99
3091513 3091513 WI Pierce   school 5504320 1659 Public school Ellsworth Community 550432000465 60 Ellsworth Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   99                                             99
3092123 3092123 WI Door   school 5505220 2114 Public school Gibraltar Area 550522001456 200 Gibraltar Middle   Regular School No Middle 07 08 2018   pk_12_total 78.0   16.0     1.0         4.0   66.0 33.0             29     4   99 78   16     1         4   66 33         29   4   99
3092983 3092983 WI La Crosse   school 5506540 2562 Public school Holmen 550654002298 100 Viking Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   99                                             99
3093068 3093068 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663002409 40 Forest Glen Elementary   Regular School No Elementary PK 04 2018   kindergarten                                                   99                                             99
3094371 3094371 WI Forest   school 5507830 2940 Public school Laona 550783000893 20 Laona High   Regular School No High 07 12 2018   pk_12_total 86.0 1.0 2.0 8.0           2.0     51.0 48.0             41     13   99 86 1 2 8           2     51 48         41   13   99
3094588 3094588 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002483 110 Cesar Chavez Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   99                                             99
3095207 3095207 WI Dodge   school 5508880 3367 Public school Mayville 550888001030 80 Mayville High   Regular School No High 09 12 2018   grade_11                                                   99                                             99
3095208 3095208 WI Dodge   school 5508880 3367 Public school Mayville 550888001030 80 Mayville High   Regular School No High 09 12 2018   grade_12                                                   99                                             99
3095686 3095686 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951001113 160 West Middleton Elementary   Regular School No Elementary PK 04 2018   kindergarten                                                   99                                             99
3096730 3096730 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001155 146 Milwaukee German Immersion   Regular School No Elementary PK 05 2018   grade_1                                                   99                                             99
3096737 3096737 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001155 146 Milwaukee German Immersion   Regular School No Elementary PK 05 2018   kindergarten                                                   99                                             99
3096837 3096837 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003010 474 NOVA Tech-Northwest Opportunities Vocational Academy Technical High charter Career and Technical School Yes High 09 12 2018   pk_12_total 1.0 88.0 4.0               6.0   52.0 47.0             79     24   99 1 88 4               6   52 47         79   24   99
3097314 3097314 WI Dane   school 5509810 3675 Public school Monona Grove 550981002343 80 Winnequah School   Regular School No Elementary PK 05 2018   grade_2                                                   99                                             99
3097570 3097570 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001336 220 Tess Corners Elementary   Regular School No Elementary PK 04 2018   grade_4                                                   99                                             99
3098089 3098089 WI Vilas   school 5503860 1526 Public school Northland Pines 550386000406 90 Northland Pines High   Regular School No High 09 12 2018   grade_10                                                   99                                             99
3098452 3098452 WI Dane   school 5511100 4144 Public school Oregon 551110001469 40 Netherwood Knoll Elementary   Regular School No Elementary PK 04 2018   grade_4                                                   99                                             99
3098809 3098809 WI Marinette   school 5511610 4305 Public school Peshtigo 551161003026 200 Peshtigo Middle   Regular School No Middle 07 08 2018   grade_8                                                   99                                             99
3098888 3098888 WI Grant   school 5511850 4389 Public school Platteville 551185001553 60 Platteville High   Regular School No High 09 12 2018   grade_10                                                   99                                             99
3098899 3098899 WI Grant   school 5511850 4389 Public school Platteville 551185001555 120 Westview Elementary   Regular School No Elementary 01 04 2018   grade_2                                                   99                                             99
3099177 3099177 WI Pierce   school 5512240 4578 Public school Prescott 551224001592 60 Prescott High   Regular School No High 09 12 2018   grade_10                                                   99                                             99
3100087 3100087 WI Kenosha   school 5513350 5068 Public school Salem 551335001753 20 Salem Elementary   Regular School No Elementary PK 08 2018   grade_3                                                   99                                             99
3100426 3100426 WI Sheboygan   school 5513680 5278 Public school Sheboygan Falls 551368001801 20 Sheboygan Falls Elementary   Regular School No Elementary PK 04 2018   kindergarten                                                   99                                             99
3101098 3101098 WI Dane   school 5514640 5656 Public school Sun Prairie Area 551464002624 150 Horizon Elementary   Regular School No Elementary PK 04 2018   grade_3                                                   99                                             99
3101137 3101137 WI Dane   school 5514640 5656 Public school Sun Prairie Area 551464001901 70 Royal Oaks Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   99                                             99
3101200 3101200 WI Douglas   school 5514670 5663 Public school Superior 551467002539 115 Northern Lights Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   99                                             99
3101628 3101628 WI Dane   school 5515330 5901 Public school Verona Area 551533002647 130 Glacier Edge Elementary   Regular School No Elementary KG 05 2018   grade_1                                                   99                                             99
3102026 3102026 WI Waukesha   school 5515780 6174 Public school Waukesha 551578000261 480 Summit View Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   99                                             99
3102082 3102082 WI Dane   school 5515810 6181 Public school Waunakee Community 551581002648 110 Arboretum Elementary   Regular School No Elementary PK 04 2018   grade_3                                                   99                                             99
3102128 3102128 WI Waupaca   school 5515840 6195 Public school Waupaca 551584001203 70 Waupaca Learning Center Elementary   Regular School No Elementary PK 04 2018   grade_2                                                   99                                             99
3102331 3102331 WI Waushara   school 5515960 6237 Public school Wautoma Area 551596002071 30 Parkside School   Regular School No Middle 04 08 2018   grade_7                                                   99                                             99
3102349 3102349 WI Waushara   school 5515960 6237 Public school Wautoma Area 551596002074 140 Wautoma High   Regular School No High 09 12 2018   grade_11                                                   99                                             99
3095383 3095383 WI Winnebago   school 5509030 3430 Public school Menasha Joint 550903001059 100 Menasha High   Regular School No High 09 12 2018   pk_12_total 668.0 30.0 180.0 5.0   42.0         62.0   513.0 474.0             515     140   987 668 30 180 5   42         62   513 474         515   140   987
3098217 3098217 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001412 120 Oak Creek East Middle   Regular School No Middle 06 08 2018   pk_12_total 749.0 28.0 128.0 3.0   55.0       1.0 19.0   538.0 445.0             182     64   983 749 28 128 3   55       1 19   538 445         182   64   983
3091227 3091227 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000421 170 DeLong Middle   Regular School No Middle 06 08 2018   pk_12_total 764.0 26.0 44.0 10.0   93.0       3.0 41.0   523.0 458.0             390     161   981 764 26 44 10   93       3 41   523 458         390   161   981
3089248 3089248 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000084 50 Pioneer Elementary   Regular School No Elementary KG 05 2018   grade_3                                                   98                                             98
3089613 3089613 WI Rock   school 5501050 413 Public school Beloit 550105002974 421 Beloit Learning Academy   Alternative School No High 06 12 2018   grade_12                                                   98                                             98
3089750 3089750 WI Green Lake   school 5501140 434 Public school Berlin Area 550114000163 60 Clay Lamberton Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   98                                             98
3089873 3089873 WI Chippewa   school 5501350 497 Public school Bloomer 550135000183 20 Bloomer Elementary   Regular School No Elementary PK 04 2018   grade_4                                                   98                                             98
3090653 3090653 WI Columbia   school 5502820 1183 Public school Columbus 550282000318 40 Columbus High   Regular School No High 09 12 2018   grade_12                                                   98                                             98
3090938 3090938 WI Dane   school 5503180 1316 Public school De Forest Area 550318000354 20 Eagle Point Elementary   Regular School No Elementary KG 04 2018   grade_2                                                   98                                             98
3091087 3091087 WI Brown   school 5503660 1407 Public school Denmark 550366000388 80 Denmark High   Regular School No High 09 12 2018   grade_9                                                   98                                             98
3092028 3092028 WI Trempealeau   school 5504960 2009 Public school Galesville-Ettrick-Trempealeau 550496000536 40 Galesville-Ettrick-Trempealeau High   Regular School No High 09 12 2018   grade_10                                                   98                                             98
3092033 3092033 WI Trempealeau   school 5504960 2009 Public school Galesville-Ettrick-Trempealeau 550496000537 50 Galesville-Ettrick-Trempealeau Middle   Regular School No Middle 06 08 2018   grade_6                                                   98                                             98
3092771 3092771 WI Waukesha   school 5506030 2420 Public school Hamilton 550603000667 120 Marcy Elementary   Regular School No Elementary KG 05 2018   grade_3                                                   98                                             98
3095274 3095274 WI Taylor   school 5508940 3409 Public school Medford Area Public 550894002361 180 Medford Elementary   Regular School No Elementary PK 04 2018   kindergarten                                                   98                                             98
3096150 3096150 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001163 173 Forest Home Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   98                                             98
3096620 3096620 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001164 176 Meir School   Regular School No Other 03 12 2018   grade_12                                                   98                                             98
3096623 3096623 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001164 176 Meir School   Regular School No Other 03 12 2018   grade_5                                                   98                                             98
3096777 3096777 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001161 167 Milwaukee Spanish Immersion   Regular School No Elementary PK 05 2018   grade_2                                                   98                                             98
3097176 3097176 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes Other PK 12 2018   grade_2                                                   98                                             98
3097905 3097905 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062002789 170 New Richmond Hillside Elementary   Regular School No Elementary KG 05 2018   grade_3                                                   98                                             98
3097997 3097997 WI Fond du Lac   school 5510740 3983 Public school North Fond du Lac 551074001398 55 Friendship Learning Elementary   Regular School No Elementary 01 05 2018   grade_2                                                   98                                             98
3097998 3097998 WI Fond du Lac   school 5510740 3983 Public school North Fond du Lac 551074001398 55 Friendship Learning Elementary   Regular School No Elementary 01 05 2018   grade_3                                                   98                                             98
3098005 3098005 WI Fond du Lac   school 5510740 3983 Public school North Fond du Lac 551074001399 60 Horace Mann High   Regular School No High 09 12 2018   grade_9                                                   98                                             98
3098478 3098478 WI Polk   school 5511160 4165 Public school Osceola 551116001479 40 Osceola Elementary   Regular School No Elementary PK 02 2018   grade_1                                                   98                                             98
3098748 3098748 WI Rock   school 5511130 4151 Public school Parkview 551113001477 120 Parkview Junior High   Regular School No Middle 07 08 2018   pk_12_total 90.0   4.0 2.0             2.0   45.0 53.0             24     11   98 90   4 2             2   45 53         24   11   98
3099474 3099474 WI Racine   school 5512360 4620 Public school Racine Unified 551236001642 162 Wadewitz Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   98                                             98
3100573 3100573 WI Washington   school 5513950 5390 Public school Slinger 551395001819 20 Slinger Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   98                                             98
3100853 3100853 WI Chippewa   school 5514430 5593 Public school Stanley-Boyd Area 551443001866 100 Stanley-Boyd Middle   Regular School No Middle 06 08 2018   grade_7                                                   98                                             98
3101054 3101054 WI Door   school 5514610 5642 Public school Sturgeon Bay 551461001894 10 Sturgeon Bay High   Regular School No High 09 12 2018   grade_11                                                   98                                             98
3101552 3101552 WI Racine   school 5515180 5859 Public school Union Grove J1 551518001964 20 Union Grove Elementary   Regular School No Elementary PK 08 2018   grade_8                                                   98                                             98
3101630 3101630 WI Dane   school 5515330 5901 Public school Verona Area 551533002647 130 Glacier Edge Elementary   Regular School No Elementary KG 05 2018   grade_3                                                   98                                             98
3101658 3101658 WI Dane   school 5515330 5901 Public school Verona Area 551533001971 80 Sugar Creek Elementary   Regular School No Elementary KG 05 2018   kindergarten                                                   98                                             98
3102111 3102111 WI Waupaca   school 5515840 6195 Public school Waupaca 551584002033 60 Chain O Lakes Elementary   Regular School No Elementary PK 02 2018   pk_12_total 89.0 2.0 7.0                   62.0 36.0             35     15   98 89 2 7                   62 36         35   15   98
3102330 3102330 WI Waushara   school 5515960 6237 Public school Wautoma Area 551596002071 30 Parkside School   Regular School No Middle 04 08 2018   grade_6                                                   98                                             98
3102909 3102909 WI Milwaukee   school 5516620 6419 Public school Whitefish Bay 551662002169 80 Richards Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   98                                             98
3095452 3095452 WI Dunn   school 5509090 3444 Public school Menomonie Area 550909001079 180 Menomonie High   Regular School No High 09 12 2018   pk_12_total 841.0 18.0 21.0 3.0   48.0       2.0 39.0   526.0 446.0             291     157   972 841 18 21 3   48       2 39   526 446         291   157   972
3097642 3097642 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032002308 210 Shattuck Middle   Regular School No Middle 07 08 2018   pk_12_total 817.0 20.0 87.0 1.0   21.0         26.0   497.0 475.0             254     118   972 817 20 87 1   21         26   497 475         254   118   972
3093885 3093885 WI Waukesha   school 5503510 1376 Public school Kettle Moraine 550351000376 120 Kettle Moraine High   Regular School No High 09 12 2018   pk_12_total 885.0 2.0 50.0 1.0   11.0         22.0   550.0 421.0             82     133   971 885 2 50 1   11         22   550 421         82   133   971
3101214 3101214 WI Douglas   school 5514670 5663 Public school Superior 551467001907 60 Superior Middle   Regular School No Middle 06 08 2018   pk_12_total 838.0 40.0 18.0 30.0   12.0       1.0 32.0   481.0 490.0             436     179   971 838 40 18 30   12       1 32   481 490         436   179   971
3088801 3088801 WI Eau Claire   school 5500270 112 Public school Altoona 550027000026 40 Altoona High   Regular School No High 09 12 2018   grade_12                                                   97                                             97
3089685 3089685 WI Rock   school 5501050 413 Public school Beloit 550105000150 260 Robinson Elementary   Regular School No Elementary PK 03 2018   kindergarten                                                   97                                             97
3089695 3089695 WI Rock   school 5501050 413 Public school Beloit 550105000153 320 Todd Elementary   Regular School No Elementary PK 03 2018   grade_1                                                   97                                             97
3089883 3089883 WI Chippewa   school 5501350 497 Public school Bloomer 550135000185 60 Bloomer Middle   Regular School No Middle 05 08 2018   grade_5                                                   97                                             97
3090434 3090434 WI Calumet   school 5502520 1085 Public school Chilton 550252000279 40 Chilton High   Regular School No High 09 12 2018   grade_11                                                   97                                             97
3090870 3090870 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317002643 130 Mountain Bay Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   97                                             97
3090967 3090967 WI Brown   school 5503210 1414 Public school De Pere 550321000363 40 Dickinson Elementary   Regular School No Elementary PK 04 2018   grade_1                                                   97                                             97
3090978 3090978 WI Brown   school 5503210 1414 Public school De Pere 550321001254 50 Heritage Elementary   Regular School No Elementary PK 04 2018   grade_2                                                   97                                             97
3091080 3091080 WI Brown   school 5503660 1407 Public school Denmark 550366000387 60 Denmark Elementary   Regular School No Elementary 01 05 2018   grade_3                                                   97                                             97
3091646 3091646 WI Rock   school 5504440 1694 Public school Evansville Community 550444000477 20 Levi Leonard Elementary   Regular School No Elementary PK 02 2018   grade_2                                                   97                                             97
3092575 3092575 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000639 590 Sullivan Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   97                                             97
3092839 3092839 WI Waukesha   school 5506140 2460 Public school Hartland-Lakeside J3 550614002258 40 South Elementary   Regular School No Elementary 03 05 2018   grade_4                                                   97                                             97
3093024 3093024 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660000714 20 Hortonville Elementary   Regular School No Elementary PK 04 2018   grade_1                                                   97                                             97
3094037 3094037 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747000851 110 Westside Elementary   Regular School No Elementary KG 04 2018   grade_1                                                   97                                             97
3094050 3094050 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747002641 130 Woodland School   Regular School No Elementary KG 04 2018   kindergarten                                                   97                                             97
3094135 3094135 WI La Crosse   school 5507530 2849 Public school La Crosse 550753000863 180 Lincoln Middle   Regular School No Middle 06 08 2018   grade_8                                                   97                                             97
3095209 3095209 WI Dodge   school 5508880 3367 Public school Mayville 550888001030 80 Mayville High   Regular School No High 09 12 2018   grade_9                                                   97                                             97
3095272 3095272 WI Taylor   school 5508940 3409 Public school Medford Area Public 550894002361 180 Medford Elementary   Regular School No Elementary PK 04 2018   grade_4                                                   97                                             97
3095432 3095432 WI Waukesha   school 5509060 3437 Public school Menomonee Falls 550906001067 200 Shady Lane Elementary   Regular School No Elementary PK 02 2018   kindergarten                                                   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]);