enrollments

Data source: Big Local News · About: Big Local

560 rows where grade = "pre_kindergarten", state = "WI" and year = 2021 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 560 ✖

grade ✖

  • pre_kindergarten · 560 ✖
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
2332985 2332985 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   1                                             1
2333033 2333033 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   1                                             1
2333049 2333049 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2333427 2333427 WI Lafayette   school 5500450 161 Public school Argyle 550045000069 20 Argyle Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2333600 2333600 WI La Crosse   school 5500780 245 Public school Bangor 550078000100 20 Bangor Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2333803 2333803 WI Marinette   school 5511550 4263 Public school Beecher-Dunbar-Pembine 551155001529 40 Pembine Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   1                                             1
2334260 2334260 WI Milwaukee   school 5501800 721 Public school Brown Deer 550180000232 80 Brown Deer Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2334469 2334469 WI Barron   school 5502130 903 Public school Cameron 550213000256 20 Cameron Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   1                                             1
2334518 2334518 WI Monroe   school 5502340 980 Public school Cashton 550234000262 20 Cashton Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2334789 2334789 WI Polk   school 5502610 1127 Public school Clear Lake 550261000291 20 Gaylord A Nelson Educational Center   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   1                                             1
2335056 2335056 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000338 50 Mitchell Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2335138 2335138 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317001738 60 Hatley Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2335296 2335296 WI Vernon   school 5503240 1421 Public school De Soto Area 550324000368 80 Prairie View Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2335700 2335700 WI Langlade   school 5504170 1582 Public school Elcho 550417000447 20 Elcho Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2335764 2335764 WI Sheboygan   school 5504260 1631 Public school Elkhart Lake-Glenbeulah 550426000455 20 Elkhart Lake Elementary/Middle   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   1                                             1
2335940 2335940 WI Washington   school 5504410 1687 Public school Erin 550441000476 20 Erin Elementary   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   1                                             1
2336064 2336064 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468000493 30 Chegwin Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2336108 2336108 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468000500 230 Parkside Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2336228 2336228 WI Milwaukee   school 5504800 1890 Public school Fox Point J2 550480000518 40 Stormonth Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   1                                             1
2336237 2336237 WI Milwaukee   school 5504830 1900 Public school Franklin Public 550483000519 20 Ben Franklin Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2336276 2336276 WI Milwaukee   school 5504830 1900 Public school Franklin Public 550483000524 100 Robinwood Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2336285 2336285 WI Milwaukee   school 5504830 1900 Public school Franklin Public 550483000151 120 Southwood Glen Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2336444 2336444 WI Oconto   school 5505250 2128 Public school Gillett 550525000566 60 Gillett Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2336658 2336658 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000613 60 Beaumont Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2336831 2336831 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000632 430 MacArthur Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2336840 2336840 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000633 435 Martin Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2336893 2336893 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000639 590 Sullivan Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2336922 2336922 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000643 700 Wequiock Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2336945 2336945 WI Green Lake   school 5505880 2310 Public school Green Lake 550588000646 20 Green Lake Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   1                                             1
2337012 2337012 WI Milwaukee   school 5505940 2303 Public school Greenfield 550594000652 100 Glenwood Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2337030 2337030 WI Milwaukee   school 5505940 2303 Public school Greenfield 550594000655 160 Maple Grove Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2337241 2337241 WI Vernon   school 5506480 2541 Public school Hillsboro 550648000702 20 Hillsboro Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2337544 2337544 WI Dodge   school 5506780 2625 Public school Hustisford 550678000737 20 John Hustis Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2337639 2337639 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2337767 2337767 WI Rock   school 5507020 2695 Public school Janesville 550702000774 330 Van Buren Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2337776 2337776 WI Rock   school 5507020 2695 Public school Janesville 550702000775 340 Washington Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2338026 2338026 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000810 240 Harvey Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2338056 2338056 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000814 310 Jeffery Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2338115 2338115 WI Kenosha   school 5507320 2793 Public school Kenosha 550732002653 170 Nash Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2338297 2338297 WI Washington   school 5507380 2800 Public school Kewaskum 550738000835 40 Farmington Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2338479 2338479 WI La Crosse   school 5507530 2849 Public school La Crosse 550753001463 140 Coulee Montessori Charter School charter Regular School Yes Elementary PK 08 2021   pre_kindergarten                                                   1                                             1
2338541 2338541 WI La Crosse   school 5507530 2849 Public school La Crosse 550753000196 111 North Woods International School   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2338659 2338659 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   1                                             1
2338894 2338894 WI Dodge   school 5508220 3171 Public school Lomira 550822000907 40 Lomira Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2339426 2339426 WI Marathon   school 5508670 3304 Public school Marathon City 550867000991 20 Marathon Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2339751 2339751 WI Taylor   school 5508940 3409 Public school Medford Area Public 550894001047 320 Stetsonville Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   1                                             1
2340104 2340104 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951003131 170 Pope Farm Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   1                                             1
2341910 2341910 WI Waukesha   school 5510060 3822 Public school Mukwonago 551006001321 70 Prairie View Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   1                                             1
2341927 2341927 WI Waukesha   school 5510060 3822 Public school Mukwonago 551006002307 80 Section Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   1                                             1
2342148 2342148 WI Chippewa   school 5510440 3920 Public school New Auburn 551044001362 20 New Auburn Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   1                                             1
2342174 2342174 WI Waukesha   school 5510470 3925 Public school New Berlin 551047000224 60 Elmwood Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   1                                             1
2342255 2342255 WI Juneau   school 5510560 3948 Public school New Lisbon 551056001381 40 New Lisbon Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   1                                             1
2342293 2342293 WI Waupaca   school 5510590 3955 Public school New London 551059001385 90 Parkview Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   1                                             1
2342301 2342301 WI Waupaca   school 5510590 3955 Public school New London 551059001386 100 Readfield Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   1                                             1
2342309 2342309 WI Waupaca   school 5510590 3955 Public school New London 551059001387 120 Sugar Bush Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   1                                             1
2342460 2342460 WI Vilas   school 5501530 616 Public school North Lakeland 550153000198 50 North Lakeland Elementary   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   1                                             1
2342663 2342663 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001410 80 Meadowview Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2342768 2342768 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2342868 2342868 WI La Crosse   school 5511010 4095 Public school Onalaska 551101001449 60 Pertzsch Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2342929 2342929 WI Dane   school 5511100 4144 Public school Oregon 551110001472 50 Prairie View Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   1                                             1
2343108 2343108 WI Clark   school 5511310 4207 Public school Owen-Withee 551131001509 20 Owen-Withee Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2343150 2343150 WI Columbia   school 5511370 4228 Public school Pardeeville Area 551137001517 60 Pardeeville Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   1                                             1
2343171 2343171 WI Kenosha   school 5511400 4235 Public school Paris J1 551140001520 20 Paris Elementary   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   1                                             1
2343387 2343387 WI Sheboygan   school 5511940 4473 Public school Plymouth Joint 551194001559 40 Fairview Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   1                                             1
2343457 2343457 WI Ozaukee   school 5512000 4515 Public school Port Washington-Saukville 551200001569 120 Saukville Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   1                                             1
2343672 2343672 WI Brown   school 5512330 4613 Public school Pulaski Community 551233001597 40 Glenbrook Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2343681 2343681 WI Brown   school 5512330 4613 Public school Pulaski Community 551233001598 50 Hillcrest Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2343832 2343832 WI Racine   school 5512360 4620 Public school Racine Unified 551236001632 148 Mitchell School   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   1                                             1
2343882 2343882 WI Racine   school 5512360 4620 Public school Racine Unified 551236001637 154 Roosevelt Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2343918 2343918 WI Racine   school 5512360 4620 Public school Racine Unified 551236001642 162 Wadewitz Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2343962 2343962 WI Dodge   school 5512420 4634 Public school Randolph 551242001650 20 Randolph Elementary   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   1                                             1
2344112 2344112 WI Taylor   school 5512780 4795 Public school Rib Lake 551278002463 100 Rib Lake Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2344321 2344321 WI Grant   school 5500017 4904 Public school River Ridge 550001700684 20 River Ridge Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   1                                             1
2344420 2344420 WI Fond du Lac   school 5513100 4956 Public school Rosendale-Brandon 551310001730 60 Rosendale Primary   Regular School No Elementary PK 03 2021   pre_kindergarten                                                   1                                             1
2344430 2344430 WI Portage   school 5513140 4963 Public school Rosholt 551314001732 20 Rosholt Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   1                                             1
2344889 2344889 WI Washburn   school 5513710 5306 Public school Shell Lake 551371000507 10 Shell Lake Primary (K-2)   Regular School No Elementary PK 02 2021   pre_kindergarten                                                   1                                             1
2344916 2344916 WI Milwaukee   school 5513800 5355 Public school Shorewood 551380001809 20 Atwater Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   1                                             1
2344977 2344977 WI Burnett   school 5513890 5376 Public school Siren 551389001816 20 Siren Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2345056 2345056 WI Douglas   school 5513980 5397 Public school Solon Springs 551398001911 800 Solon Springs School   Regular School No Other PK 12 2021   pre_kindergarten                                                   1                                             1
2345252 2345252 WI Washburn   school 5514220 5474 Public school Spooner Area 551422002956 120 Little Rails Early Learning   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   1                                             1
2345458 2345458 WI Waukesha   school 5509390 3542 Public school Stone Bank 550939002270 20 Stone Bank Elementary   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   1                                             1
2345519 2345519 WI Marathon   school 5514580 5628 Public school Stratford 551458000582 25 Stratford Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2345674 2345674 WI Douglas   school 5514670 5663 Public school Superior 551467002347 110 Four Corners Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2345790 2345790 WI Oneida   school 5514850 5733 Public school Three Lakes 551485001928 60 Three Lakes Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   1                                             1
2345807 2345807 WI Shawano   school 5514880 5740 Public school Tigerton 551488001931 20 Tigerton Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2346291 2346291 WI Door   school 5515570 6069 Public school Washington 551557001986 20 Washington Island Elementary   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   1                                             1
2346459 2346459 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002004 20 Banting Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2346468 2346468 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002006 60 Bethesda Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2346496 2346496 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002011 160 Hadfield Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2346505 2346505 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003126 140 Hawthorne Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2346523 2346523 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002014 200 Hillcrest Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2346575 2346575 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002290 410 Rose Glen Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2346644 2346644 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002028 540 Whittier Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2346886 2346886 WI Marinette   school 5515930 6230 Public school Wausaukee 551593002067 80 Wausaukee Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2346935 2346935 WI Milwaukee   school 5515990 6244 Public school Wauwatosa 551599002078 40 Eisenhower Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2346944 2346944 WI Milwaukee   school 5515990 6244 Public school Wauwatosa 551599002081 100 Jefferson Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2347050 2347050 WI Milwaukee   school 5515990 6244 Public school Wauwatosa 551599002093 300 Wilson Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2347103 2347103 WI Milwaukee   school 5516260 6300 Public school West Allis-West Milwaukee 551626002103 60 Franklin Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2347112 2347112 WI Milwaukee   school 5516260 6300 Public school West Allis-West Milwaukee 551626002105 100 Hoover Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
2347212 2347212 WI Milwaukee   school 5516260 6300 Public school West Allis-West Milwaukee 551626002124 480 Wilson Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1

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