enrollments

Data source: Big Local News · About: Big Local

572 rows where grade = "pre_kindergarten", state = "WI" and year = 2020 sorted by total_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 572 ✖

grade ✖

  • pre_kindergarten · 572 ✖
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 ▼
2318139 2318139 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2318221 2318221 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   1                                             1
2318253 2318253 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2318819 2318819 WI La Crosse   school 5500780 245 Public school Bangor 550078000100 20 Bangor Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2319238 2319238 WI Washburn   school 5501170 441 Public school Birchwood 550117000168 20 Birchwood Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2319378 2319378 WI Shawano   school 5501560 623 Public school Bowler 550156000199 20 Bowler Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   1                                             1
2319432 2319432 WI Calumet   school 5501680 658 Public school Brillion 550168000206 20 Brillion Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2319496 2319496 WI Rusk   school 5501830 735 Public school Bruce 550183000234 20 Bruce Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2320153 2320153 WI Chippewa   school 5502880 1204 Public school Cornell 550288000323 20 Cornell Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2320252 2320252 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000340 80 Lincoln Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2321112 2321112 WI Washington   school 5504410 1687 Public school Erin 550441000476 20 Erin Elementary   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   1                                             1
2321200 2321200 WI Rusk   school 5514970 5757 Public school Flambeau 551497001919 120 Flambeau Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2321236 2321236 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468000493 30 Chegwin Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2321248 2321248 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468000494 80 Evans Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2321437 2321437 WI Milwaukee   school 5504830 1900 Public school Franklin Public 550483000523 80 Pleasant View Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2321506 2321506 WI Trempealeau   school 5504960 2009 Public school Galesville-Ettrick-Trempealeau 550496000538 60 Galesville Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2321540 2321540 WI Walworth   school 5505130 2051 Public school Genoa City J2 550513000547 20 Brookwood Elementary   Regular School No Elementary PK 03 2020   pre_kindergarten                                                   1                                             1
2321579 2321579 WI Washington   school 5505160 2058 Public school Germantown 550516000555 120 MacArthur Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2321613 2321613 WI Oconto   school 5505250 2128 Public school Gillett 550525000566 60 Gillett Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2321740 2321740 WI Clark   school 5505640 2226 Public school Granton Area 550564000599 20 Granton Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2321787 2321787 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000610 20 Aldo Leopold Community School K-8   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   1                                             1
2321823 2321823 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000614 100 Chappell Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2321841 2321841 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000617 175 Doty Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2321880 2321880 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000621 220 Elmore Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2321923 2321923 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000626 360 Jefferson Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2322004 2322004 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000633 435 Martin Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2322013 2322013 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002431 437 McAuliffe Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2322108 2322108 WI Green Lake   school 5505880 2310 Public school Green Lake 550588000646 20 Green Lake Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   1                                             1
2322995 2322995 WI Green   school 5507230 2737 Public school Juda 550723000784 20 Juda Elementary   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   1                                             1
2323112 2323112 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000806 140 Forest Park Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2323253 2323253 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000820 420 Pleasant Prairie Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2323262 2323262 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000821 440 Prairie Lane Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2323435 2323435 WI Washington   school 5507380 2800 Public school Kewaskum 550738000839 100 i4Learning Community School charter Regular School Yes Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2323597 2323597 WI La Crosse   school 5507530 2849 Public school La Crosse 550753001463 140 Coulee Montessori Charter School charter Regular School Yes Elementary PK 08 2020   pre_kindergarten                                                   1                                             1
2323707 2323707 WI La Crosse   school 5507530 2849 Public school La Crosse 550753000869 320 State Road Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2323919 2323919 WI Forest   school 5507830 2940 Public school Laona 550783000894 40 Robinson Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   1                                             1
2323949 2323949 WI Walworth   school 5508040 3087 Public school Linn J4 550804000898 20 Traver Elementary   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   1                                             1
2323961 2323961 WI Walworth   school 5508070 3094 Public school Linn J6 550807000899 20 Reek Elementary   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   1                                             1
2324070 2324070 WI Polk   school 5508280 3213 Public school Luck 550828000914 40 Luck Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2324541 2324541 WI Milwaukee   school 5504770 1897 Public school Maple Dale-Indian Hill 550477000515 20 Indian Hill School   Regular School No Elementary PK 03 2020   pre_kindergarten                                                   1                                             1
2324760 2324760 WI Juneau   school 5508850 3360 Public school Mauston 550885001027 80 West Side Elementary   Regular School No Elementary PK 02 2020   pre_kindergarten                                                   1                                             1
2325031 2325031 WI Dunn   school 5509090 3444 Public school Menomonie Area 550909001082 220 River Heights Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2325060 2325060 WI Ozaukee   school 5509130 3479 Public school Mequon-Thiensville 550913001086 80 Lake Shore Middle   Regular School No Middle 06 08 2020   pre_kindergarten                                                   1                                             1
2325098 2325098 WI Iron   school 5509150 3484 Public school Mercer 550915001092 40 Mercer School   Regular School No Other PK 12 2020   pre_kindergarten                                                   1                                             1
2325225 2325225 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951001111 120 Sauk Trail Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   1                                             1
2326773 2326773 WI Oneida   school 5509690 3640 Public school Minocqua J1 550969001278 20 Minocqua Elementary   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   1                                             1
2327279 2327279 WI Chippewa   school 5510440 3920 Public school New Auburn 551044001362 20 New Auburn Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2327428 2327428 WI Waupaca   school 5510590 3955 Public school New London 551059001386 100 Readfield Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   1                                             1
2327517 2327517 WI Racine   school 5512510 4690 Public school North Cape 551251001657 20 North Cape Elementary   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   1                                             1
2327716 2327716 WI Monroe   school 5510770 3990 Public school Norwalk-Ontario-Wilton 551077000683 50 Norwalk-Ontario-Wilton Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   1                                             1
2327728 2327728 WI Racine   school 5510800 4011 Public school Norway J7 551080001405 20 Drought Elementary   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   1                                             1
2327876 2327876 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2327964 2327964 WI La Crosse   school 5511010 4095 Public school Onalaska 551101001446 30 Northern Hills Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2327982 2327982 WI La Crosse   school 5511010 4095 Public school Onalaska 551101001449 60 Pertzsch Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2328236 2328236 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   1                                             1
2328338 2328338 WI Pepin   school 5511580 4270 Public school Pepin Area 551158001531 20 Pepin Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   1                                             1
2328537 2328537 WI Wood   school 5511970 4508 Public school Port Edwards 551197001565 60 Port Edwards Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   1                                             1
2328565 2328565 WI Ozaukee   school 5512000 4515 Public school Port Washington-Saukville 551200001569 120 Saukville Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   1                                             1
2328624 2328624 WI Grant   school 5512090 4529 Public school Potosi 551209001575 20 Potosi Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2328790 2328790 WI Brown   school 5512330 4613 Public school Pulaski Community 551233001598 50 Hillcrest Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2328817 2328817 WI Brown   school 5512330 4613 Public school Pulaski Community 551233001601 120 Sunnyside Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2329100 2329100 WI Racine   school 5512480 4686 Public school Raymond #14 551248001656 20 Raymond Elementary   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   1                                             1
2329137 2329137 WI Sauk   school 5512660 4753 Public school Reedsburg 551266001668 160 West Side Elementary   Regular School No Elementary PK 02 2020   pre_kindergarten                                                   1                                             1
2329674 2329674 WI Sauk   school 5513410 5100 Public school Sauk Prairie 551341001762 160 Tower Rock Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2329704 2329704 WI Crawford   school 5513470 5124 Public school Seneca Area 551347001764 60 Seneca Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2329994 2329994 WI Washburn   school 5513710 5306 Public school Shell Lake 551371000507 10 Shell Lake Primary (K-2)   Regular School No Elementary PK 02 2020   pre_kindergarten                                                   1                                             1
2330106 2330106 WI Washington   school 5513950 5390 Public school Slinger 551395001818 10 Allenton Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2330222 2330222 WI Bayfield   school 5512030 4522 Public school South Shore 551203001571 40 South Shore Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   1                                             1
2330747 2330747 WI Douglas   school 5514670 5663 Public school Superior 551467001906 40 Bryant Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2330782 2330782 WI Douglas   school 5514670 5663 Public school Superior 551467002348 120 Lake Superior Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2330815 2330815 WI Oconto   school 5514700 5670 Public school Suring Public 551470001921 60 Suring Elementary   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   1                                             1
2330875 2330875 WI Oneida   school 5514850 5733 Public school Three Lakes 551485001928 60 Three Lakes Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   1                                             1
2331083 2331083 WI Barron   school 5515060 5810 Public school Turtle Lake 551506001955 20 Turtle Lake Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2331384 2331384 WI Racine   school 5515700 6104 Public school Washington-Caldwell 551570001993 20 Washington Elementary   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   1                                             1
2331513 2331513 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002006 60 Bethesda Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2331618 2331618 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002290 410 Rose Glen Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2332036 2332036 WI Milwaukee   school 5515990 6244 Public school Wauwatosa 551599002089 240 Washington Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2332172 2332172 WI Milwaukee   school 5516260 6300 Public school West Allis-West Milwaukee 551626002108 160 Jefferson Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2332185 2332185 WI Milwaukee   school 5516260 6300 Public school West Allis-West Milwaukee 551626002114 280 Longfellow Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2332411 2332411 WI Marquette   school 5516440 6335 Public school Westfield 551644002150 80 Westfield Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   1                                             1
2318302 2318302 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 03 2020   pre_kindergarten                                                   2                                             2
2319028 2319028 WI Marinette   school 5511550 4263 Public school Beecher-Dunbar-Pembine 551155001529 40 Pembine Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   2                                             2
2319063 2319063 WI Lafayette   school 5501020 364 Public school Belmont Community 550102000134 20 Belmont Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   2                                             2
2319190 2319190 WI Lafayette   school 5501110 427 Public school Benton 550111000160 20 Benton Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   2                                             2
2319269 2319269 WI Lafayette   school 5505730 2240 Public school Black Hawk 550573000608 160 Black Hawk Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   2                                             2
2319322 2319322 WI Chippewa   school 5501350 497 Public school Bloomer 550135000183 20 Bloomer Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   2                                             2
2319342 2319342 WI Shawano   school 5501470 602 Public school Bonduel 550147000188 20 Bonduel Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   2                                             2
2319565 2319565 WI Racine   school 5501890 777 Public school Burlington Area 550189000243 140 Waller Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   2                                             2
2319638 2319638 WI Dane   school 5502100 896 Public school Cambridge 550210000254 20 Cambridge Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   2                                             2
2320004 2320004 WI Polk   school 5502610 1127 Public school Clear Lake 550261000291 20 Gaylord A Nelson Educational Center   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   2                                             2
2320051 2320051 WI Buffalo   school 5502700 1155 Public school Cochrane-Fountain City 550270000306 20 Cochrane-Fountain City Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   2                                             2
2320243 2320243 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306001228 140 Kosciuszko Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   2                                             2
2320514 2320514 WI Dane   school 5503270 1309 Public school Deerfield Community 550327000370 20 Deerfield Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   2                                             2
2320649 2320649 WI Bayfield   school 5503810 1491 Public school Drummond Area 550381000398 20 Drummond Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   2                                             2
2320905 2320905 WI Trempealeau   school 5504200 1600 Public school Eleva-Strum 550420000451 80 Eleva-Strum Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   2                                             2
2320944 2320944 WI Sheboygan   school 5504260 1631 Public school Elkhart Lake-Glenbeulah 550426000455 20 Elkhart Lake Elementary/Middle   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   2                                             2
2321219 2321219 WI Florence   school 5504650 1855 Public school Florence County 550465000489 40 Florence Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   2                                             2
2321832 2321832 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000616 140 Danz Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   2                                             2
2321958 2321958 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000166 390 King Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   2                                             2
2322057 2322057 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000639 590 Sullivan Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   2                                             2

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