enrollments

Data source: Big Local News · About: Big Local

14,664 rows where state = "WI" and year = 2017 sorted by total descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 14,664 ✖
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
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
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
325761 325761 WI Eau Claire   school 5500270 112 Public school Altoona 550027000026 40 Altoona High   Regular School No High 09 12 2017   grade_11                                                   99                                             99
325763 325763 WI Eau Claire   school 5500270 112 Public school Altoona 550027000026 40 Altoona High   Regular School No High 09 12 2017   grade_9                                                   99                                             99
325788 325788 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 02 2017   kindergarten                                                   99                                             99
325951 325951 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002426 130 Ferber Elementary   Regular School No Elementary PK 06 2017   kindergarten                                                   99                                             99
325995 325995 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002366 195 Houdini Elementary   Regular School No Elementary PK 06 2017   grade_2                                                   99                                             99
326004 326004 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000056 200 Huntley Elementary   Regular School No Elementary PK 06 2017   grade_3                                                   99                                             99
326213 326213 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000084 50 Pioneer Elementary   Regular School No Elementary KG 05 2017   grade_4                                                   99                                             99
326578 326578 WI Rock   school 5501050 413 Public school Beloit 550105000137 20 Aldrich Intermediate   Regular School No Elementary 04 08 2017   grade_8                                                   99                                             99
326670 326670 WI Rock   school 5501080 422 Public school Beloit Turner 550108000157 60 Powers Elementary   Regular School No Elementary PK 02 2017   grade_2                                                   99                                             99
326719 326719 WI Green Lake   school 5501140 434 Public school Berlin Area 550114000163 60 Clay Lamberton Elementary   Regular School No Elementary PK 05 2017   kindergarten                                                   99                                             99
326827 326827 WI Chippewa   school 5501350 497 Public school Bloomer 550135000183 20 Bloomer Elementary   Regular School No Elementary PK 04 2017   grade_3                                                   99                                             99
326836 326836 WI Chippewa   school 5501350 497 Public school Bloomer 550135000184 40 Bloomer High   Regular School No High 09 12 2017   grade_9                                                   99                                             99
327172 327172 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000259 40 Campbellsport High   Regular School No High 09 12 2017   grade_11                                                   99                                             99
327173 327173 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000259 40 Campbellsport High   Regular School No High 09 12 2017   grade_12                                                   99                                             99
327601 327601 WI Columbia   school 5502820 1183 Public school Columbus 550282000319 20 Columbus Middle   Regular School No Elementary 04 08 2017   grade_7                                                   99                                             99
327926 327926 WI Brown   school 5503210 1414 Public school De Pere 550321002668 100 Susie C Altmayer Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   99                                             99
328027 328027 WI Brown   school 5503660 1407 Public school Denmark 550366000389 100 Denmark Middle   Regular School No Middle 06 08 2017   grade_8                                                   99                                             99
328513 328513 WI Waukesha   school 5501770 714 Public school Elmbrook 550177001217 190 Swanson Elementary   Regular School No Elementary PK 05 2017   kindergarten                                                   99                                             99
329252 329252 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000612 40 Bay View   Alternative School No Other PK 12 2017   pk_12_total 50.0 10.0 23.0 6.0   2.0         8.0   71.0 28.0             44     77   99 50 10 23 6   2         8   71 28         44   77   99
329710 329710 WI Waukesha   school 5506030 2420 Public school Hamilton 550603001676 150 Woodside Elementary   Regular School No Elementary KG 05 2017   grade_1                                                   99                                             99
329714 329714 WI Waukesha   school 5506030 2420 Public school Hamilton 550603001676 150 Woodside Elementary   Regular School No Elementary KG 05 2017   grade_5                                                   99                                             99
330015 330015 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663000718 50 Meadowbrook Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   99                                             99
330570 330570 WI Kenosha   school 5507320 2793 Public school Kenosha 550732002754 490 Harborside Academy charter Regular School Yes Other 06 12 2017   grade_12                                                   99                                             99
331265 331265 WI Jefferson   school 5507710 2898 Public school Lake Mills Area 550771000887 40 Lake Mills High   Regular School No High 09 12 2017   grade_9                                                   99                                             99
331323 331323 WI Oconto   school 5507860 2961 Public school Lena 550786000897 60 Lena Middle   Regular School No Middle 06 08 2017   pk_12_total 91.0   2.0 2.0   1.0       2.0 1.0   56.0 43.0             45     12   99 91   2 2   1       2 1   56 43         45   12   99
331367 331367 WI Outagamie   school 5508160 3129 Public school Little Chute Area 550816000900 20 Little Chute Elementary   Regular School No Elementary PK 04 2017   grade_3                                                   99                                             99
331381 331381 WI Outagamie   school 5508160 3129 Public school Little Chute Area 550816000902 60 Little Chute Middle   Regular School No Middle 07 08 2017   grade_7                                                   99                                             99
332133 332133 WI Dodge   school 5508880 3367 Public school Mayville 550888001030 80 Mayville High   Regular School No High 09 12 2017   grade_12                                                   99                                             99
332451 332451 WI Ozaukee   school 5509130 3479 Public school Mequon-Thiensville 550913001090 160 Wilson Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   99                                             99
332537 332537 WI Waukesha   school 5509360 3528 Public school Merton Community 550936000750 40 Merton Primary   Regular School No Elementary PK 04 2017   grade_4                                                   99                                             99
332585 332585 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951001109 90 Northside Elementary   Regular School No Elementary PK 04 2017   kindergarten                                                   99                                             99
332686 332686 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001122 73 Allen-Field Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   99                                             99
333466 333466 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001209 256 Longfellow Elementary   Regular School No Elementary PK 08 2017   grade_5                                                   99                                             99
335516 335516 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119001497 320 Tipler Middle   Regular School No Middle 06 08 2017   grade_8                                                   99                                             99
335808 335808 WI Grant   school 5511850 4389 Public school Platteville 551185001553 60 Platteville High   Regular School No High 09 12 2017   grade_12                                                   99                                             99
335816 335816 WI Grant   school 5511850 4389 Public school Platteville 551185001555 120 Westview Elementary   Regular School No Elementary 01 04 2017   grade_1                                                   99                                             99
336242 336242 WI Racine   school 5512360 4620 Public school Racine Unified 551236001623 132 Jefferson Lighthouse Elementary   Regular School No Elementary KG 05 2017   grade_4                                                   99                                             99
338039 338039 WI Dane   school 5514640 5656 Public school Sun Prairie Area 551464001899 40 Eastside Elementary   Regular School No Elementary PK 04 2017   grade_2                                                   99                                             99
338067 338067 WI Dane   school 5514640 5656 Public school Sun Prairie Area 551464001401 210 Patrick Marsh Middle   Regular School No Middle 05 07 2017   grade_5                                                   99                                             99
338559 338559 WI Dane   school 5515330 5901 Public school Verona Area 551533002647 130 Glacier Edge Elementary   Regular School No Elementary KG 05 2017   grade_3                                                   99                                             99
339045 339045 WI Waupaca   school 5515840 6195 Public school Waupaca 551584001203 70 Waupaca Learning Center Elementary   Regular School No Elementary PK 04 2017   grade_1                                                   99                                             99
339921 339921 WI Milwaukee   school 5506000 6470 Public school Whitnall 550600000658 40 Hales Corners Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   99                                             99
339923 339923 WI Milwaukee   school 5506000 6470 Public school Whitnall 550600000658 40 Hales Corners Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   99                                             99
340049 340049 WI Sauk   school 5517040 6678 Public school Wisconsin Dells 551704002200 100 Wisconsin Dells High   Regular School No High 09 12 2017   grade_11                                                   99                                             99
332174 332174 WI Dane   school 5508910 3381 Public school McFarland 550891002975 430 Wisconsin Virtual Academy High (WIVA) charter Regular School Yes High 09 12 2017   pk_12_total 748.0 72.0 88.0 9.0   6.0         66.0   424.0 565.0             330     155   989 748 72 88 9   6         66   424 565         330   155   989
325859 325859 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002976 165 Appleton Community 4K   Regular School No Elementary PK PK 2017   pk_12_total 659.0 25.0 106.0 2.0   119.0       1.0 70.0   504.0 478.0             345     143   982 659 25 106 2   119       1 70   504 478         345   143   982
325860 325860 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002976 165 Appleton Community 4K   Regular School No Elementary PK PK 2017   kindergarten_4_year_old                                                   982                                             982
325785 325785 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 02 2017   grade_1                                                   98                                             98
325983 325983 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000055 180 Highlands Elementary   Regular School No Elementary PK 06 2017   kindergarten                                                   98                                             98
326429 326429 WI Barron   school 5500870 308 Public school Barron Area 550087000118 140 Riverview Middle   Regular School No Middle 05 08 2017   grade_8                                                   98                                             98
326648 326648 WI Rock   school 5501050 413 Public school Beloit 550105000150 260 Robinson Elementary   Regular School No Elementary PK 03 2017   grade_1                                                   98                                             98
326652 326652 WI Rock   school 5501050 413 Public school Beloit 550105000150 260 Robinson Elementary   Regular School No Elementary PK 03 2017   kindergarten                                                   98                                             98
326674 326674 WI Rock   school 5501080 422 Public school Beloit Turner 550108000158 100 Townview Elementary   Regular School No Elementary 03 05 2017   grade_3                                                   98                                             98
327909 327909 WI Brown   school 5503210 1414 Public school De Pere 550321000363 40 Dickinson Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   98                                             98
328831 328831 WI Milwaukee   school 5504800 1890 Public school Fox Point J2 550480000518 40 Stormonth Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   98                                             98
329715 329715 WI Waukesha   school 5506030 2420 Public school Hamilton 550603001676 150 Woodside Elementary   Regular School No Elementary KG 05 2017   kindergarten                                                   98                                             98
329733 329733 WI Washington   school 5506090 2443 Public school Hartford J1 550609000676 50 Rossman Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   98                                             98
329955 329955 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660000714 20 Hortonville Elementary   Regular School No Elementary PK 04 2017   grade_3                                                   98                                             98
330082 330082 WI Saint Croix   school 5506690 2611 Public school Hudson 550669000731 120 Rock Elementary   Regular School No Elementary KG 05 2017   grade_3                                                   98                                             98
330429 330429 WI Outagamie   school 5507290 2758 Public school Kaukauna Area 550729002433 50 Dr H B Tanner Elementary   Regular School No Elementary PK 01 2017   grade_1                                                   98                                             98
330670 330670 WI Kenosha   school 5507320 2793 Public school Kenosha 550732002653 170 Nash Elementary   Regular School No Elementary PK 05 2017   grade_3                                                   98                                             98
331378 331378 WI Outagamie   school 5508160 3129 Public school Little Chute Area 550816002858 100 Little Chute Intermediate   Regular School No Middle 05 06 2017   grade_5                                                   98                                             98
331495 331495 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852000929 225 Allis Elementary   Regular School No Elementary PK 05 2017   kindergarten_4_year_old                                                   98                                             98
331912 331912 WI Douglas   school 5508640 3297 Public school Maple 550864000988 170 Northwestern Middle   Regular School No Middle 06 08 2017   grade_6                                                   98                                             98
332131 332131 WI Dodge   school 5508880 3367 Public school Mayville 550888001030 80 Mayville High   Regular School No High 09 12 2017   grade_10                                                   98                                             98
332610 332610 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951001113 160 West Middleton Elementary   Regular School No Elementary PK 04 2017   grade_1                                                   98                                             98
332613 332613 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951001113 160 West Middleton Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   98                                             98
332685 332685 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001122 73 Allen-Field Elementary   Regular School No Elementary PK 05 2017   grade_3                                                   98                                             98
333079 333079 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001163 173 Forest Home Elementary   Regular School No Elementary PK 05 2017   kindergarten                                                   98                                             98
333202 333202 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002979 880 HAPA-Hmong American Peace Academy K3-12 charter Regular School Yes Other PK 12 2017   grade_8                                                   98                                             98
334741 334741 WI Calumet   school 5510530 3941 Public school New Holstein 551053001379 80 New Holstein High   Regular School No High 09 12 2017   grade_11                                                   98                                             98
335290 335290 WI Winnebago   school 5510980 4088 Public school Omro 551098001441 60 Omro High   Regular School No High 09 12 2017   grade_9                                                   98                                             98
335873 335873 WI Wood   school 5511970 4508 Public school Port Edwards 551197001564 40 John Edwards High   Regular School No High 09 12 2017   pk_12_total 85.0   6.0 2.0   2.0         3.0   54.0 44.0             27     10   98 85   6 2   2         3   54 44         27   10   98
335921 335921 WI Columbia   school 5512060 4501 Public school Portage Community 551206002419 120 Endeavor Elementary   Regular School No Elementary PK 05 2017   pk_12_total 73.0 1.0 22.0 1.0             1.0   51.0 47.0             51     11   98 73 1 22 1             1   51 47         51   11   98
336243 336243 WI Racine   school 5512360 4620 Public school Racine Unified 551236001623 132 Jefferson Lighthouse Elementary   Regular School No Elementary KG 05 2017   grade_5                                                   98                                             98
337784 337784 WI Chippewa   school 5514430 5593 Public school Stanley-Boyd Area 551443002363 120 Stanley Elementary   Regular School No Elementary KG 05 2017   grade_1                                                   98                                             98
338009 338009 WI Door   school 5514610 5642 Public school Sturgeon Bay 551461001895 50 Sunrise Elementary   Regular School No Elementary 03 05 2017   grade_5                                                   98                                             98
338048 338048 WI Dane   school 5514640 5656 Public school Sun Prairie Area 551464002624 150 Horizon Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   98                                             98
338063 338063 WI Dane   school 5514640 5656 Public school Sun Prairie Area 551464001900 60 Northside Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   98                                             98
338150 338150 WI Douglas   school 5514670 5663 Public school Superior 551467002539 115 Northern Lights Elementary   Regular School No Elementary PK 05 2017   kindergarten                                                   98                                             98
339251 339251 WI Waushara   school 5515960 6237 Public school Wautoma Area 551596002071 30 Parkside School   Regular School No Elementary 04 08 2017   grade_8                                                   98                                             98
339376 339376 WI Milwaukee   school 5515990 6244 Public school Wauwatosa 551599002921 430 Wauwatosa Virtual Academy charter Regular School Yes Other 06 12 2017   pk_12_total 43.0 28.0 14.0 2.0   3.0         8.0   42.0 56.0             14     12   98 43 28 14 2   3         8   42 56         14   12   98
339410 339410 WI Crawford   school 5516020 6251 Public school Wauzeka-Steuben 551602002095 40 Wauzeka High   Regular School No High 09 12 2017   pk_12_total 96.0   1.0               1.0   53.0 45.0             40     11   98 96   1               1   53 45         40   11   98
339697 339697 WI Vernon   school 5516410 6321 Public school Westby Area 551641002146 200 Westby High   Regular School No High 09 12 2017   grade_10                                                   98                                             98
339831 339831 WI Milwaukee   school 5516620 6419 Public school Whitefish Bay 551662002169 80 Richards Elementary   Regular School No Elementary PK 05 2017   kindergarten                                                   98                                             98
334566 334566 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032002308 210 Shattuck Middle   Regular School No Middle 07 08 2017   pk_12_total 830.0 19.0 76.0 5.0   24.0         19.0   517.0 456.0             234     110   973 830 19 76 5   24         19   517 456         234   110   973
326130 326130 WI Trempealeau   school 5500420 154 Public school Arcadia 550042000068 40 Arcadia High   Regular School No High 09 12 2017   grade_9                                                   97                                             97
326662 326662 WI Rock   school 5501050 413 Public school Beloit 550105000153 320 Todd Elementary   Regular School No Elementary PK 03 2017   grade_1                                                   97                                             97
326709 326709 WI Green Lake   school 5501140 434 Public school Berlin Area 550114000164 80 Berlin Middle   Regular School No Middle 06 08 2017   grade_6                                                   97                                             97
326716 326716 WI Green Lake   school 5501140 434 Public school Berlin Area 550114000163 60 Clay Lamberton Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   97                                             97
327380 327380 WI Calumet   school 5502520 1085 Public school Chilton 550252000279 40 Chilton High   Regular School No High 09 12 2017   grade_9                                                   97                                             97
328332 328332 WI Langlade   school 5504170 1582 Public school Elcho 550417000448 40 Elcho High   Regular School No High 09 12 2017   pk_12_total 86.0     9.0             2.0   50.0 47.0             47     18   97 86     9             2   50 47         47   18   97
328912 328912 WI Outagamie   school 5504920 1953 Public school Freedom Area 550492000532 20 Freedom Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   97                                             97
330016 330016 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663000718 50 Meadowbrook Elementary   Regular School No Elementary PK 04 2017   kindergarten                                                   97                                             97
330684 330684 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000820 420 Pleasant Prairie Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   97                                             97
331416 331416 WI Dodge   school 5508220 3171 Public school Lomira 550822000908 60 Lomira High   Regular School No High 09 12 2017   grade_10                                                   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]);