enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
3089570 3089570 WI Dane   school 5500990 350 Public school Belleville 550099000131 20 Belleville Elementary   Regular School No Elementary PK 01 2018   pre_kindergarten                                                   5                                             5
3089839 3089839 WI Jackson   school 5501260 476 Public school Black River Falls 550126000176 80 Forrest Street Early Learning Center   Regular School No Elementary PK 01 2018   pre_kindergarten                                                   11                                             11
3093497 3093497 WI Outagamie   school 5507290 2758 Public school Kaukauna Area 550729002433 50 Dr H B Tanner Elementary   Regular School No Elementary PK 01 2018   pre_kindergarten                                                   25                                             25
3097309 3097309 WI Dane   school 5509810 3675 Public school Monona Grove 550981000682 120 Taylor Prairie Elementary   Regular School No Elementary PK 01 2018   pre_kindergarten                                                   8                                             8
3098386 3098386 WI Winnebago   school 5510980 4088 Public school Omro 551098001440 40 Patch Elementary   Regular School No Elementary PK 01 2018   pre_kindergarten                                                   7                                             7
3099089 3099089 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002508 10 BA Kennedy School   Regular School No Elementary PK 01 2018   pre_kindergarten                                                   5                                             5
3102142 3102142 WI Fond du Lac   school 5515870 6216 Public school Waupun 551587002044 160 Meadow View Primary   Regular School No Elementary PK 01 2018   pre_kindergarten                                                   14                                             14
3088828 3088828 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 02 2018   pre_kindergarten                                                   6                                             6
3089220 3089220 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No Elementary PK 02 2018   pre_kindergarten                                                   14                                             14
3089707 3089707 WI Rock   school 5501080 422 Public school Beloit Turner 550108000157 60 Powers Elementary   Regular School No Elementary PK 02 2018   pre_kindergarten                                                   84                                             84
3091207 3091207 WI Walworth   school 5504020 1540 Public school East Troy Community 550402000409 20 Little Prairie Primary   Regular School No Elementary PK 02 2018   pre_kindergarten                                                   12                                             12
3091649 3091649 WI Rock   school 5504440 1694 Public school Evansville Community 550444000477 20 Levi Leonard Elementary   Regular School No Elementary PK 02 2018   pre_kindergarten                                                   2                                             2
3092832 3092832 WI Waukesha   school 5506140 2460 Public school Hartland-Lakeside J3 550614002257 20 North Elementary   Regular School No Elementary PK 02 2018   pre_kindergarten                                                   11                                             11
3092875 3092875 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627000689 20 Hayward Primary   Regular School No Elementary PK 02 2018   pre_kindergarten                                                   14                                             14
3094562 3094562 WI Kewaunee   school 5508340 3220 Public school Luxemburg-Casco 550834002525 110 Luxemburg-Casco Primary   Regular School No Elementary PK 02 2018   pre_kindergarten                                                   13                                             13
3094711 3094711 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002412 53 Lapham Elementary   Regular School No Elementary PK 02 2018   pre_kindergarten                                                   8                                             8
3095087 3095087 WI Dane   school 5508790 3332 Public school Marshall 550879000569 80 Marshall Early Learning Center   Regular School No Elementary PK 02 2018   pre_kindergarten                                                   6                                             6
3095204 3095204 WI Juneau   school 5508850 3360 Public school Mauston 550885001027 80 West Side Elementary   Regular School No Elementary PK 02 2018   pre_kindergarten                                                   4                                             4
3095222 3095222 WI Dodge   school 5508880 3367 Public school Mayville 550888001031 90 Parkview Elementary   Regular School No Elementary PK 02 2018   pre_kindergarten                                                   5                                             5
3095414 3095414 WI Waukesha   school 5509060 3437 Public school Menomonee Falls 550906001061 40 Benjamin Franklin Elementary and Early Learning Center   Regular School No Elementary PK 02 2018   pre_kindergarten                                                   15                                             15
3095433 3095433 WI Waukesha   school 5509060 3437 Public school Menomonee Falls 550906001067 200 Shady Lane Elementary   Regular School No Elementary PK 02 2018   pre_kindergarten                                                   11                                             11
3098481 3098481 WI Polk   school 5511160 4165 Public school Osceola 551116001479 40 Osceola Elementary   Regular School No Elementary PK 02 2018   pre_kindergarten                                                   4                                             4
3099720 3099720 WI Washington   school 5512900 4820 Public school Richfield J1 551290000467 40 Plat Elementary   Regular School No Elementary PK 02 2018   pre_kindergarten                                                   2                                             2
3100101 3100101 WI Sauk   school 5513410 5100 Public school Sauk Prairie 551341001761 150 Bridges Elementary   Regular School No Elementary PK 02 2018   pre_kindergarten                                                   13                                             13
3100243 3100243 WI Shawano   school 5513620 5264 Public school Shawano 551362002819 150 Hillcrest Primary School   Regular School No Elementary PK 02 2018   pre_kindergarten                                                   9                                             9
3100455 3100455 WI Washburn   school 5513710 5306 Public school Shell Lake 551371000507 10 Shell Lake Primary (K-2)   Regular School No Elementary PK 02 2018   pre_kindergarten                                                   5                                             5
3101339 3101339 WI Monroe   school 5514910 5747 Public school Tomah Area 551491001937 140 Oakdale Elementary   Regular School No Elementary PK 02 2018   pre_kindergarten                                                   19                                             19
3102069 3102069 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002926 110 White Rock Campus   Regular School No Elementary PK 02 2018   pre_kindergarten                                                   34                                             34
3102115 3102115 WI Waupaca   school 5515840 6195 Public school Waupaca 551584002033 60 Chain O Lakes Elementary   Regular School No Elementary PK 02 2018   pre_kindergarten                                                   5                                             5
3103131 3103131 WI Dane   school 5501230 469 Public school Wisconsin Heights 550123000170 20 Black Earth Elementary   Regular School No Elementary PK 02 2018   pre_kindergarten                                                   7                                             7
3088797 3088797 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2018   pre_kindergarten                                                   11                                             11
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
3089654 3089654 WI Rock   school 5501050 413 Public school Beloit 550105000141 110 Gaston Elementary   Regular School No Elementary PK 03 2018   pre_kindergarten                                                   6                                             6
3089661 3089661 WI Rock   school 5501050 413 Public school Beloit 550105000142 120 Hackett Elementary   Regular School No Elementary PK 03 2018   pre_kindergarten                                                   9                                             9
3089700 3089700 WI Rock   school 5501050 413 Public school Beloit 550105000153 320 Todd Elementary   Regular School No Elementary PK 03 2018   pre_kindergarten                                                   22                                             22
3090649 3090649 WI Columbia   school 5502820 1183 Public school Columbus 550282000321 80 Columbus Elementary   Regular School No Elementary PK 03 2018   pre_kindergarten                                                   4                                             4
3092061 3092061 WI Walworth   school 5505130 2051 Public school Genoa City J2 550513000547 20 Brookwood Elementary   Regular School No Elementary PK 03 2018   pre_kindergarten                                                   4                                             4
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
3095076 3095076 WI Green Lake   school 5508760 3325 Public school Markesan 550876001010 100 Markesan Primary   Regular School No Elementary PK 03 2018   pre_kindergarten                                                   5                                             5
3095704 3095704 WI Rock   school 5509570 3612 Public school Milton 550957002600 160 Harmony Elementary   Regular School No Elementary PK 03 2018   pre_kindergarten                                                   5                                             5
3095723 3095723 WI Rock   school 5509570 3612 Public school Milton 550957001120 140 West Elementary   Regular School No Elementary PK 03 2018   pre_kindergarten                                                   5                                             5
3097415 3097415 WI Marathon   school 5509960 3787 Public school Mosinee 550996001307 80 Mosinee Elementary   Regular School No Elementary PK 03 2018   pre_kindergarten                                                   7                                             7
3098828 3098828 WI Waukesha   school 5511640 4312 Public school Pewaukee 551164001536 60 Pewaukee Lake Elementary   Regular School No Elementary PK 03 2018   pre_kindergarten                                                   9                                             9
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
3099623 3099623 WI Oneida   school 5512720 4781 Public school Rhinelander 551272001675 60 Crescent Elementary   Regular School No Elementary PK 03 2018   pre_kindergarten                                                   5                                             5
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
3100083 3100083 WI Milwaukee   school 5513260 5026 Public school Saint Francis 551326001750 80 Willow Glen Primary School   Regular School No Elementary PK 03 2018   pre_kindergarten                                                   5                                             5
3102346 3102346 WI Waushara   school 5515960 6237 Public school Wautoma Area 551596002073 80 Riverview Elementary   Regular School No Elementary PK 03 2018   pre_kindergarten                                                   2                                             2
3089159 3089159 WI Trempealeau   school 5500420 154 Public school Arcadia 550042003040 190 Arcadia Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   9                                             9
3089467 3089467 WI Barron   school 5500870 308 Public school Barron Area 550087000119 160 Woodland Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   4                                             4
3089876 3089876 WI Chippewa   school 5501350 497 Public school Bloomer 550135000183 20 Bloomer Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   13                                             13
3090081 3090081 WI Racine   school 5501890 777 Public school Burlington Area 550189000239 60 Cooper Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   14                                             14
3090102 3090102 WI Racine   school 5501890 777 Public school Burlington Area 550189000243 140 Waller Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   5                                             5
3090204 3090204 WI Barron   school 5502130 903 Public school Cameron 550213000256 20 Cameron Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   3                                             3
3090297 3090297 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000266 20 Cedar Grove-Belgium Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   9                                             9
3090431 3090431 WI Calumet   school 5502520 1085 Public school Chilton 550252000278 20 Chilton Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   3                                             3
3090539 3090539 WI Rock   school 5502640 1134 Public school Clinton Community 550264000295 40 Clinton Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   2                                             2
3090795 3090795 WI Barron   school 5503090 1260 Public school Cumberland 550309000343 40 Cumberland Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   3                                             3
3090990 3090990 WI Brown   school 5503210 1414 Public school De Pere 550321002668 100 Susie C Altmayer Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   31                                             31
3091439 3091439 WI Dunn   school 5504230 1645 Public school Elk Mound Area 550423000454 60 Mound View Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   3                                             3
3093015 3093015 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   3                                             3
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
3093047 3093047 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002958 160 North Greenville Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   7                                             7
3093054 3093054 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663002709 120 Bay Harbor Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   23                                             23
3093109 3093109 WI Sheboygan   school 5506660 2605 Public school Howards Grove 550666000723 110 Northview Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   4                                             4
3093466 3093466 WI Jefferson   school 5507170 2730 Public school Johnson Creek 550717000782 20 Johnson Creek Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   13                                             13
3094009 3094009 WI Manitowoc   school 5507440 2828 Public school Kiel Area 550744002333 100 Zielanis Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   6                                             6
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
3094449 3094449 WI Outagamie   school 5508160 3129 Public school Little Chute Area 550816000900 20 Little Chute Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   5                                             5
3095275 3095275 WI Taylor   school 5508940 3409 Public school Medford Area Public 550894002361 180 Medford Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   12                                             12
3095612 3095612 WI Waukesha   school 5509360 3528 Public school Merton Community 550936000750 40 Merton Primary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   3                                             3
3095635 3095635 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951001105 40 Elm Lawn Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   2                                             2
3095659 3095659 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951001109 90 Northside Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   2                                             2
3095666 3095666 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951001110 100 Park Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   5                                             5
3095673 3095673 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951001111 120 Sauk Trail Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   3                                             3
3095680 3095680 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951000755 150 Sunset Ridge Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   2                                             2
3095687 3095687 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951001113 160 West Middleton Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   2                                             2
3097533 3097533 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017002372 20 Country Meadows Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   11                                             11
3097553 3097553 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001333 100 Mill Valley Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   14                                             14
3097795 3097795 WI Green   school 5510500 3934 Public school New Glarus 551050001375 20 New Glarus Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   5                                             5
3097855 3097855 WI Waupaca   school 5510590 3955 Public school New London 551059001383 40 Lincoln Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   8                                             8
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
3098080 3098080 WI Vilas   school 5503860 1526 Public school Northland Pines 550386000405 80 Northland Pines Elementary-Land O' Lakes   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   3                                             3
3098261 3098261 WI Waukesha   school 5510890 4060 Public school Oconomowoc Area 551089001418 60 Greenland Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   21                                             21
3098357 3098357 WI Oconto   school 5510920 4067 Public school Oconto Unified 551092001429 160 Oconto Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   73                                             73
3098447 3098447 WI Dane   school 5511100 4144 Public school Oregon 551110001468 20 Brooklyn Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   4                                             4
3098454 3098454 WI Dane   school 5511100 4144 Public school Oregon 551110001469 40 Netherwood Knoll Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   6                                             6
3098471 3098471 WI Dane   school 5511100 4144 Public school Oregon 551110001472 50 Prairie View Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   6                                             6
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
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
3098978 3098978 WI Ozaukee   school 5512000 4515 Public school Port Washington-Saukville 551200002320 40 Dunwiddie Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   2                                             2
3098985 3098985 WI Ozaukee   school 5512000 4515 Public school Port Washington-Saukville 551200001567 60 Lincoln Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   13                                             13
3098999 3098999 WI Ozaukee   school 5512000 4515 Public school Port Washington-Saukville 551200001569 120 Saukville Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   2                                             2
3099034 3099034 WI Columbia   school 5512060 4501 Public school Portage Community 551206002945 190 Portage Partnering Preschool   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   160                                             160
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
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
3099714 3099714 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281000581 25 Tainter Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   9                                             9
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
3100036 3100036 WI Saint Croix   school 5506060 2422 Public school Saint Croix Central 550606000671 40 Saint Croix Central Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   11                                             11
3100427 3100427 WI Sheboygan   school 5513680 5278 Public school Sheboygan Falls 551368001801 20 Sheboygan Falls Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   6                                             6

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