enrollments

Data source: Big Local News · About: Big Local

558 rows where grade = "pre_kindergarten", state = "WI" and year = 2018 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 558 ✖

grade ✖

  • pre_kindergarten · 558 ✖
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
3088749 3088749 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   1                                             1
3088781 3088781 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3088845 3088845 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000038 80 Crestwood Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3089178 3089178 WI Lafayette   school 5500450 161 Public school Argyle 550045000069 20 Argyle Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3089409 3089409 WI Iowa   school 5500840 287 Public school Barneveld 550084000111 20 Barneveld Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3089635 3089635 WI Rock   school 5501050 413 Public school Beloit 550105000139 60 Converse Elementary   Regular School No Elementary PK 03 2018   pre_kindergarten                                                   1                                             1
3089730 3089730 WI Lafayette   school 5501110 427 Public school Benton 550111000160 20 Benton Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten                                                   1                                             1
3089781 3089781 WI Washburn   school 5501170 441 Public school Birchwood 550117000168 20 Birchwood Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3089816 3089816 WI Lafayette   school 5505730 2240 Public school Black Hawk 550573000608 160 Black Hawk Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3090531 3090531 WI Polk   school 5502610 1127 Public school Clear Lake 550261000291 20 Gaylord A Nelson Educational Center   Regular School No Elementary PK 06 2018   pre_kindergarten                                                   1                                             1
3090578 3090578 WI Buffalo   school 5502700 1155 Public school Cochrane-Fountain City 550270000306 20 Cochrane-Fountain City Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten                                                   1                                             1
3090771 3090771 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000340 80 Lincoln Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3090864 3090864 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317001738 60 Hatley Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3091016 3091016 WI Vernon   school 5503240 1421 Public school De Soto Area 550324000368 80 Prairie View Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3091395 3091395 WI Langlade   school 5504170 1582 Public school Elcho 550417000447 20 Elcho Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3091498 3091498 WI Walworth   school 5504290 1638 Public school Elkhorn Area 550429000461 80 Tibbets Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3091619 3091619 WI Washington   school 5504410 1687 Public school Erin 550441000476 20 Erin Elementary   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   1                                             1
3091680 3091680 WI Columbia   school 5504530 1736 Public school Fall River 550453000483 20 Fall River Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3091715 3091715 WI Rusk   school 5514970 5757 Public school Flambeau 551497001919 120 Flambeau Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3092319 3092319 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 2018   pre_kindergarten                                                   1                                             1
3092346 3092346 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000613 60 Beaumont Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3092371 3092371 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000617 175 Doty Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3092454 3092454 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000626 360 Jefferson Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3092527 3092527 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000632 430 MacArthur Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3092544 3092544 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002431 437 McAuliffe Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3092632 3092632 WI Green Lake   school 5505880 2310 Public school Green Lake 550588000646 20 Green Lake Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten                                                   1                                             1
3093487 3093487 WI Green   school 5507230 2737 Public school Juda 550723000784 20 Juda Elementary   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   1                                             1
3093678 3093678 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000814 310 Jeffery Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3093857 3093857 WI Waukesha   school 5503510 1376 Public school Kettle Moraine 550351000374 40 Cushing Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3093925 3093925 WI Washington   school 5507380 2800 Public school Kewaskum 550738000835 40 Farmington Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3094059 3094059 WI Sheboygan   school 5507500 2842 Public school Kohler 550750000852 20 Kohler Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3094103 3094103 WI La Crosse   school 5507530 2849 Public school La Crosse 550753000855 60 Emerson Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3094165 3094165 WI La Crosse   school 5507530 2849 Public school La Crosse 550753000857 80 Northside Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3094426 3094426 WI Walworth   school 5508070 3094 Public school Linn J6 550807000899 20 Reek Elementary   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   1                                             1
3094519 3094519 WI Clark   school 5508250 3206 Public school Loyal 550825000911 20 Loyal Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten                                                   1                                             1
3095475 3095475 WI Dunn   school 5509090 3444 Public school Menomonie Area 550909001082 220 River Heights Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3095541 3095541 WI Iron   school 5509150 3484 Public school Mercer 550915001092 40 Mercer School   Regular School No Other PK 12 2018   pre_kindergarten                                                   1                                             1
3097246 3097246 WI Oneida   school 5509690 3640 Public school Minocqua J1 550969001278 20 Minocqua Elementary   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   1                                             1
3097582 3097582 WI Juneau   school 5510230 3871 Public school Necedah Area 551023001337 20 Necedah Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3097894 3097894 WI Waupaca   school 5510590 3955 Public school New London 551059001387 120 Sugar Bush Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   1                                             1
3097969 3097969 WI Racine   school 5512510 4690 Public school North Cape 551251001657 20 North Cape Elementary   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   1                                             1
3098017 3098017 WI Waukesha   school 5509300 3514 Public school North Lake 550930002268 20 North Lake Elementary   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   1                                             1
3098029 3098029 WI Vilas   school 5501530 616 Public school North Lakeland 550153000198 50 North Lakeland Elementary   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   1                                             1
3098166 3098166 WI Racine   school 5510800 4011 Public school Norway J7 551080001405 20 Drought Elementary   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   1                                             1
3098200 3098200 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001408 40 Edgewood Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3098313 3098313 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3098711 3098711 WI Columbia   school 5511370 4228 Public school Pardeeville Area 551137001517 60 Pardeeville Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   1                                             1
3098840 3098840 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   1                                             1
3098875 3098875 WI Wood   school 5511790 4368 Public school Pittsville 551179001546 20 Pittsville Elementary   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   1                                             1
3098914 3098914 WI Pierce   school 5511880 4459 Public school Plum City 551188001556 20 Plum City Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3099057 3099057 WI Grant   school 5512090 4529 Public school Potosi 551209001575 20 Potosi Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3099216 3099216 WI Brown   school 5512330 4613 Public school Pulaski Community 551233001597 40 Glenbrook Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3099294 3099294 WI Racine   school 5512360 4620 Public school Racine Unified 551236002311 119 Gifford Elementary   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   1                                             1
3099389 3099389 WI Racine   school 5512360 4620 Public school Racine Unified 551236001632 148 Mitchell Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3099532 3099532 WI Sheboygan   school 5512450 4641 Public school Random Lake 551245001654 60 Random Lake Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   1                                             1
3099561 3099561 WI Sauk   school 5512660 4753 Public school Reedsburg 551266001662 20 Ironton-La Valle Elementary   Regular School No Elementary PK 03 2018   pre_kindergarten                                                   1                                             1
3099603 3099603 WI Manitowoc   school 5512690 4760 Public school Reedsville 551269001669 20 Reedsville Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   1                                             1
3099879 3099879 WI Grant   school 5500017 4904 Public school River Ridge 550001700684 20 River Ridge Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   1                                             1
3099976 3099976 WI Fond du Lac   school 5513100 4956 Public school Rosendale-Brandon 551310001730 60 Rosendale Primary   Regular School No Elementary PK 03 2018   pre_kindergarten                                                   1                                             1
3100165 3100165 WI Crawford   school 5513470 5124 Public school Seneca Area 551347001764 60 Seneca Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3100567 3100567 WI Washington   school 5513950 5390 Public school Slinger 551395001818 10 Allenton Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3100652 3100652 WI Milwaukee   school 5514040 5439 Public school South Milwaukee 551404001830 80 Rawson Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3100671 3100671 WI Bayfield   school 5512030 4522 Public school South Shore 551203001571 40 South Shore Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten                                                   1                                             1
3100790 3100790 WI Marathon   school 5514190 5467 Public school Spencer 551419001844 20 Spencer Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3100826 3100826 WI Pierce   school 5514340 5586 Public school Spring Valley 551434001862 60 Spring Valley Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3101161 3101161 WI Douglas   school 5514670 5663 Public school Superior 551467001906 40 Bryant Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3101179 3101179 WI Douglas   school 5514670 5663 Public school Superior 551467002347 110 Four Corners Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3101188 3101188 WI Douglas   school 5514670 5663 Public school Superior 551467000687 300 Great Lakes Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3101246 3101246 WI Waukesha   school 5509240 3510 Public school Swallow 550924002267 20 Swallow Elementary   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   1                                             1
3101412 3101412 WI Portage   school 5500330 126 Public school Tomorrow River 550033000032 20 Amherst Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   1                                             1
3101451 3101451 WI Kenosha   school 5500052 5780 Public school Trevor-Wilmot Consolidated 550005202644 20 Trevor-Wilmot Grade   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   1                                             1
3101459 3101459 WI Waushara   school 5511820 4375 Public school Tri-County Area 551182001550 100 Tri-County Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   1                                             1
3102056 3102056 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002023 400 Waukesha STEM Academy charter Regular School Yes Elementary PK 08 2018   pre_kindergarten                                                   1                                             1
3102396 3102396 WI Milwaukee   school 5515990 6244 Public school Wauwatosa 551599002085 160 Madison Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3102438 3102438 WI Milwaukee   school 5515990 6244 Public school Wauwatosa 551599002089 240 Washington Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3102641 3102641 WI Milwaukee   school 5516260 6300 Public school West Allis-West Milwaukee 551626002124 480 Wilson Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3102772 3102772 WI Vernon   school 5516410 6321 Public school Westby Area 551641002145 180 Westby Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   1                                             1
3102791 3102791 WI Marquette   school 5516440 6335 Public school Westfield 551644002147 20 Coloma Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten                                                   1                                             1
3102801 3102801 WI Marquette   school 5516440 6335 Public school Westfield 551644002149 60 Oxford Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten                                                   1                                             1
3103043 3103043 WI Walworth   school 5516740 6482 Public school Williams Bay 551674002186 20 Williams Bay Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3103164 3103164 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002206 80 Grove Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3089059 3089059 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000058 260 Johnston Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten                                                   10                                             10
3090754 3090754 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000339 60 Jones Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   10                                             10
3091807 3091807 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468000497 120 Riverside Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   10                                             10
3092100 3092100 WI Washington   school 5505160 2058 Public school Germantown 550516000555 120 MacArthur Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   10                                             10
3092193 3092193 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000577 60 Parkway Elementary   Regular School No Elementary PK 03 2018   pre_kindergarten                                                   10                                             10
3093004 3093004 WI Dodge   school 5506570 2576 Public school Horicon 550657000711 40 Van Brunt Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten                                                   10                                             10
3093030 3093030 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660000714 20 Hortonville Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   10                                             10
3093327 3093327 WI Rock   school 5507020 2695 Public school Janesville 550702000764 160 Jefferson Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   10                                             10
3094337 3094337 WI Jefferson   school 5507710 2898 Public school Lake Mills Area 550771000889 100 Lake Mills Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   10                                             10
3097441 3097441 WI Dane   school 5509990 3794 Public school Mount Horeb Area 550999002318 140 Mount Horeb Early Learning Center   Regular School No Elementary PK KG 2018   pre_kindergarten                                                   10                                             10
3098331 3098331 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001066 280 Oconto Falls Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   10                                             10
3098937 3098937 WI Sheboygan   school 5511940 4473 Public school Plymouth Joint 551194002445 50 Horizon Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   10                                             10
3099427 3099427 WI Racine   school 5512360 4620 Public school Racine Unified 551236002708 114 Racine Early Education Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                                                   10                                             10
3100801 3100801 WI Washburn   school 5514220 5474 Public school Spooner Area 551422002956 120 Little Rails Early Learning   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                                                   10                                             10
3101064 3101064 WI Door   school 5514610 5642 Public school Sturgeon Bay 551461001896 70 Sunset Elementary   Regular School No Elementary PK KG 2018   pre_kindergarten                                                   10                                             10
3101101 3101101 WI Dane   school 5514640 5656 Public school Sun Prairie Area 551464002624 150 Horizon Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   10                                             10
3101298 3101298 WI Shawano   school 5514880 5740 Public school Tigerton 551488001931 20 Tigerton Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   10                                             10
3101516 3101516 WI Manitowoc   school 5515120 5824 Public school Two Rivers Public 551512001959 40 Koenig Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   10                                             10
3102891 3102891 WI Langlade   school 5516590 6440 Public school White Lake 551659002164 20 White Lake Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten                                                   10                                             10

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