enrollments

Data source: Big Local News · About: Big Local

4,091 rows where grade = "grade_11" and state = "WI" sorted by ccd_school_low_grade descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_11 · 4,091 ✖
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
112712 112712 WI Rock   school 5501050 413 Public school Beloit 550105002799 850 Beloit Virtual School   Regular School No 4.0 PK 12 2015   grade_11                                                   6                                             6
113468 113468 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes 4.0 PK 12 2015   grade_11                                                   3                                             3
113877 113877 WI Barron   school 5503090 1260 Public school Cumberland 550309002871 800 Island City Virtual Academy charter Regular School Yes 4.0 PK 12 2015   grade_11                                                   1                                             1
115376 115376 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000612 40 Bay View   Alternative Education School No 4.0 PK 12 2015   grade_11                                                   5                                             5
115422 115422 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582003009 800 Dr Rosa Minoka-Hill School   Alternative Education School No 4.0 PK 12 2015   grade_11                                                   18                                             18
115892 115892 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627003339 800 Hayward Ctr for Individualized Learning charter Regular School Yes 4.0 PK 12 2015   grade_11                                                   18                                             18
118361 118361 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No 4.0 PK 12 2015   grade_11                                                   18                                             18
118587 118587 WI Iron   school 5509150 3484 Public school Mercer 550915001092 40 Mercer School   Regular School No 4.0 PK 12 2015   grade_11                                                   8                                             8
118602 118602 WI Lincoln   school 5509210 3500 Public school Merrill Area 550921002927 800 Bridges Virtual Academy charter Regular School Yes 4.0 PK 12 2015   grade_11                                                   26                                             26
119343 119343 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002979 880 HAPA-Hmong Amer Peace Academy K3-12 charter Regular School Yes 4.0 PK 12 2015   grade_11                                                   52                                             52
119646 119646 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002931 870 MacDowell Montessori School K3-12   Regular School No 4.0 PK 12 2015   grade_11                                                   29                                             29
119905 119905 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002993 840 Obama School of Career and Technical Education   Regular School No 4.0 PK 12 2015   grade_11                                                   97                                             97
120224 120224 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000681 399 WI Conservatory of Lifelong Learning   Regular School No 4.0 PK 12 2015   grade_11                                                   51                                             51
120249 120249 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes 4.0 PK 12 2015   grade_11                                                   30                                             30
121161 121161 WI Ozaukee   school 5504890 1945 Public school Northern Ozaukee 550489002801 850 Wisconsin Virtual Learning charter Regular School Yes 4.0 PK 12 2015   grade_11                                                   46                                             46
122262 122262 WI Green Lake   school 5512300 4606 Public school Princeton 551230001595 40 Princeton School   Regular School No 4.0 PK 12 2015   grade_11                                                   38                                             38
123688 123688 WI Douglas   school 5513980 5397 Public school Solon Springs 551398001911 800 Solon Springs School   Regular School No 4.0 PK 12 2015   grade_11                                                   24                                             24
124453 124453 WI Monroe   school 5514910 5747 Public school Tomah Area 551491002543 800 Robert Kupper Learning Center   Alternative Education School No 4.0 PK 12 2015   grade_11                                                   4                                             4
282691 282691 WI Rock   school 5501050 413 Public school Beloit 550105002799 850 Beloit Virtual School   Regular School No 4.0 PK 12 2016   grade_11                                                   13                                             13
284505 284505 WI Walworth   school 5504290 1638 Public school Elkhorn Area 550429003038 800 Elkhorn Options Virtual School charter Regular School Yes 4.0 PK 12 2016   grade_11                                                   3                                             3
285383 285383 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000612 40 Bay View   Alternative Education School No 4.0 PK 12 2016   grade_11                                                   1                                             1
285426 285426 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582003009 800 Dr Rosa Minoka-Hill School   Alternative Education School No 4.0 PK 12 2016   grade_11                                                   16                                             16
285895 285895 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627003339 800 Hayward Ctr for Individualized Learning charter Regular School Yes 4.0 PK 12 2016   grade_11                                                   8                                             8
288357 288357 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No 4.0 PK 12 2016   grade_11                                                   15                                             15
288587 288587 WI Iron   school 5509150 3484 Public school Mercer 550915001092 40 Mercer School   Regular School No 4.0 PK 12 2016   grade_11                                                   11                                             11
288602 288602 WI Lincoln   school 5509210 3500 Public school Merrill Area 550921002927 800 Bridges Virtual Academy charter Regular School Yes 4.0 PK 12 2016   grade_11                                                   27                                             27
289324 289324 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002979 880 HAPA-Hmong Amer Peace Academy K3-12 charter Regular School Yes 4.0 PK 12 2016   grade_11                                                   57                                             57
289615 289615 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002931 870 MacDowell Montessori School K3-12   Regular School No 4.0 PK 12 2016   grade_11                                                   27                                             27
289874 289874 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002993 840 Obama School of Career and Technical Education   Regular School No 4.0 PK 12 2016   grade_11                                                   81                                             81
290181 290181 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000681 399 WI Conservatory of Lifelong Learning   Regular School No 4.0 PK 12 2016   grade_11                                                   45                                             45
290206 290206 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes 4.0 PK 12 2016   grade_11                                                   31                                             31
291119 291119 WI Ozaukee   school 5504890 1945 Public school Northern Ozaukee 550489002801 850 Wisconsin Virtual Learning charter Regular School Yes 4.0 PK 12 2016   grade_11                                                   47                                             47
292225 292225 WI Green Lake   school 5512300 4606 Public school Princeton 551230001595 40 Princeton School   Regular School No 4.0 PK 12 2016   grade_11                                                   23                                             23
293643 293643 WI Douglas   school 5513980 5397 Public school Solon Springs 551398001911 800 Solon Springs School   Regular School No 4.0 PK 12 2016   grade_11                                                   20                                             20
294388 294388 WI Monroe   school 5514910 5747 Public school Tomah Area 551491002543 800 Robert Kupper Learning Center   Alternative Education School No 4.0 PK 12 2016   grade_11                                                   10                                             10
325884 325884 WI Outagamie   school 5500390 147 Public school Appleton Area 550039003021 820 Appleview   Special Education School No Other PK 12 2017   grade_11                                                   1                                             1
326591 326591 WI Rock   school 5501050 413 Public school Beloit 550105002799 850 Beloit Virtual School   Regular School No Other PK 12 2017   grade_11                                                   13                                             13
327352 327352 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes Other PK 12 2017   grade_11                                                   6                                             6
328404 328404 WI Walworth   school 5504290 1638 Public school Elkhorn Area 550429003038 800 Elkhorn Options Virtual School charter Regular School Yes Other PK 12 2017   grade_11                                                   12                                             12
329255 329255 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000612 40 Bay View   Alternative School No Other PK 12 2017   grade_11                                                   10                                             10
329299 329299 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582003009 800 Dr Rosa Minoka-Hill School   Alternative School No Other PK 12 2017   grade_11                                                   13                                             13
329774 329774 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627003339 800 Hayward Ctr for Individualized Learning charter Regular School Yes Other PK 12 2017   grade_11                                                   12                                             12
332210 332210 WI Taylor   school 5508940 3409 Public school Medford Area Public 550894002598 9100 Rural Virtual Academy charter Regular School Yes Other PK 11 2017   grade_11                                                   20                                             20
332231 332231 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2017   grade_11                                                   20                                             20
332458 332458 WI Iron   school 5509150 3484 Public school Mercer 550915001092 40 Mercer School   Regular School No Other PK 12 2017   grade_11                                                   8                                             8
332473 332473 WI Lincoln   school 5509210 3500 Public school Merrill Area 550921002927 800 Bridges Virtual Academy charter Regular School Yes Other PK 12 2017   grade_11                                                   34                                             34
333194 333194 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002979 880 HAPA-Hmong American Peace Academy K3-12 charter Regular School Yes Other PK 12 2017   grade_11                                                   69                                             69
333485 333485 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002931 870 MacDowell Montessori School K3-12   Regular School No Other PK 12 2017   grade_11                                                   36                                             36
333770 333770 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002993 840 Obama School of Career and Technical Education   Regular School No Other PK 12 2017   grade_11                                                   107                                             107
334073 334073 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000681 399 Wisconsin Conservatory of Lifelong Learning   Regular School No Other PK 12 2017   grade_11                                                   49                                             49
334098 334098 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes Other PK 12 2017   grade_11                                                   45                                             45
334973 334973 WI Ozaukee   school 5504890 1945 Public school Northern Ozaukee 550489002801 850 Wisconsin Virtual Learning charter Regular School Yes Other PK 12 2017   grade_11                                                   39                                             39
336104 336104 WI Green Lake   school 5512300 4606 Public school Princeton 551230001595 40 Princeton School   Regular School No Other PK 12 2017   grade_11                                                   30                                             30
337534 337534 WI Douglas   school 5513980 5397 Public school Solon Springs 551398001911 800 Solon Springs School   Regular School No Other PK 12 2017   grade_11                                                   13                                             13
338287 338287 WI Monroe   school 5514910 5747 Public school Tomah Area 551491002543 800 Robert Kupper Learning Center   Alternative School No Other PK 12 2017   grade_11                                                   7                                             7
338450 338450 WI Manitowoc   school 5515120 5824 Public school Two Rivers Public 551512003037 810 Lighthouse Learning Academy charter Regular School Yes Other PK 12 2017   grade_11                                                   9                                             9
339861 339861 WI Walworth   school 5516680 6461 Public school Whitewater Unified 551668002901 9803 JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive charter Alternative School Yes Other PK 12 2017   grade_11                                                   13                                             13
2318595 2318595 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other PK 12 2020   grade_11                                                   83                                             83
2319090 2319090 WI Rock   school 5501050 413 Public school Beloit 550105002799 850 Beloit Virtual School   Regular School No Other PK 12 2020   grade_11                                                   5                                             5
2319256 2319256 WI Washburn   school 5501170 441 Public school Birchwood 550117003020 800 Bobcat Virtual Academy charter Regular School Yes Other PK 12 2020   grade_11                                                   2                                             2
2319657 2319657 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other PK 12 2020   grade_11                                                   13                                             13
2319883 2319883 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes Other PK 12 2020   grade_11                                                   2                                             2
2320295 2320295 WI Barron   school 5503090 1260 Public school Cumberland 550309002871 800 Island City Virtual Academy charter Regular School Yes Other PK 12 2020   grade_11                                                   6                                             6
2320962 2320962 WI Walworth   school 5504290 1638 Public school Elkhorn Area 550429003038 800 Elkhorn Options Virtual School charter Regular School Yes Other PK 12 2020   grade_11                                                   13                                             13
2321799 2321799 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000612 40 Bay View   Alternative School No Other PK 12 2020   grade_11                                                   1                                             1
2322318 2322318 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627003339 800 Hayward Ctr for Individualized Learning charter Regular School Yes Other PK 12 2020   grade_11                                                   14                                             14
2323847 2323847 WI Jefferson   school 5507710 2898 Public school Lake Mills Area 550771002901 9803 JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive charter Alternative School Yes Other PK 12 2020   grade_11                                                   7                                             7
2324844 2324844 WI Taylor   school 5508940 3409 Public school Medford Area Public 550894002598 9100 Rural Virtual Academy charter Regular School Yes Other PK 12 2020   grade_11                                                   30                                             30
2324867 2324867 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2020   grade_11                                                   23                                             23
2325086 2325086 WI Iron   school 5509150 3484 Public school Mercer 550915001092 40 Mercer School   Regular School No Other PK 12 2020   grade_11                                                   21                                             21
2325102 2325102 WI Lincoln   school 5509210 3500 Public school Merrill Area 550921002927 800 Bridges Virtual Academy charter Regular School Yes Other PK 12 2020   grade_11                                                   28                                             28
2325826 2325826 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002979 880 HAPA-Hmong American Peace Academy K3-12 charter Regular School Yes Other PK 12 2020   grade_11                                                   88                                             88
2326104 2326104 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002931 870 MacDowell Montessori School K3-12   Regular School No Other PK 12 2020   grade_11                                                   53                                             53
2326384 2326384 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002993 840 Obama School of Career and Technical Education   Regular School No Other PK 12 2020   grade_11                                                   77                                             77
2326678 2326678 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000681 399 Wisconsin Conservatory of Lifelong Learning   Regular School No Other PK 12 2020   grade_11                                                   32                                             32
2326703 2326703 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes Other PK 12 2020   grade_11                                                   41                                             41
2327257 2327257 WI Wood   school 5510380 3906 Public school Nekoosa 551038003089 800 WISE Academy charter Regular School Yes Other PK 12 2020   grade_11                                                   3                                             3
2327615 2327615 WI Ozaukee   school 5504890 1945 Public school Northern Ozaukee 550489002801 850 Wisconsin Virtual Learning charter Regular School Yes Other PK 12 2020   grade_11                                                   42                                             42
2328754 2328754 WI Green Lake   school 5512300 4606 Public school Princeton 551230001595 40 Princeton School   Regular School No Other PK 12 2020   grade_11                                                   30                                             30
2329345 2329345 WI Fond du Lac   school 5513020 4872 Public school Ripon Area 551302003102 800 Odyssey Academy of Virtual Learning charter Regular School Yes Other PK 12 2020   grade_11                                                   7                                             7
2329578 2329578 WI Saint Croix   school 5506060 2422 Public school Saint Croix Central 550606002989 850 Saint Croix Virtual Academy Inc charter Regular School Yes Other PK 12 2020   grade_11                                                   41                                             41
2330135 2330135 WI Douglas   school 5513980 5397 Public school Solon Springs 551398003092 850 Eagles' Wings Virtual Charter School charter Regular School Yes Other PK 12 2020   grade_11                                                   1                                             1
2330141 2330141 WI Douglas   school 5513980 5397 Public school Solon Springs 551398001911 800 Solon Springs School   Regular School No Other PK 12 2020   grade_11                                                   20                                             20
2330936 2330936 WI Monroe   school 5514910 5747 Public school Tomah Area 551491002543 800 Robert Kupper Learning Center   Alternative School No Other PK 12 2020   grade_11                                                   6                                             6
2331121 2331121 WI Manitowoc   school 5515120 5824 Public school Two Rivers Public 551512003037 810 Lighthouse Learning Academy charter Regular School Yes Other PK 12 2020   grade_11                                                   6                                             6
2333389 2333389 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other PK 12 2021   grade_11                                                   81                                             81
2333864 2333864 WI Rock   school 5501050 413 Public school Beloit 550105002799 850 Beloit Virtual School   Regular School No Other PK 12 2021   grade_11                                                   7                                             7
2334450 2334450 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other PK 12 2021   grade_11                                                   13                                             13
2334599 2334599 WI Milwaukee   school 5500041 8105 Non District Charter Schools Central City Cyberschool 550004102171 1211 Central City Cyberschool charter Regular School Yes Other PK 11 2021   grade_11                                                   2                                             2
2334669 2334669 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes Other PK 12 2021   grade_11                                                   4                                             4
2335091 2335091 WI Barron   school 5503090 1260 Public school Cumberland 550309002871 800 Island City Virtual Academy charter Regular School Yes Other PK 12 2021   grade_11                                                   9                                             9
2335787 2335787 WI Walworth   school 5504290 1638 Public school Elkhorn Area 550429003038 800 Elkhorn Options Virtual School charter Regular School Yes Other PK 12 2021   grade_11                                                   34                                             34
2336646 2336646 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000612 40 Bay View   Alternative School No Other PK 12 2021   grade_11                                                   1                                             1
2337145 2337145 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627003339 800 Hayward Ctr for Individualized Learning charter Regular School Yes Other PK 12 2021   grade_11                                                   18                                             18
2337603 2337603 WI Dane   school 5500082 8141 Non District Charter Schools Isthmus Montessori Academy Public 550008203085 8141 Isthmus Montessori Academy Public charter Regular School Yes Other PK 11 2021   grade_11                                                   2                                             2
2339510 2339510 WI Dane   school 5508790 3332 Public school Marshall 550879002901 9803 JEDI Virtual K-12 charter Alternative School Yes Other PK 12 2021   grade_11                                                   8                                             8
2339732 2339732 WI Taylor   school 5508940 3409 Public school Medford Area Public 550894002598 9100 Rural Virtual Academy charter Regular School Yes Other PK 12 2021   grade_11                                                   54                                             54
2339971 2339971 WI Iron   school 5509150 3484 Public school Mercer 550915001092 40 Mercer School   Regular School No Other PK 12 2021   grade_11                                                   13                                             13
2339987 2339987 WI Lincoln   school 5509210 3500 Public school Merrill Area 550921002927 800 Bridges Virtual Academy charter Regular School Yes Other PK 12 2021   grade_11                                                   61                                             61
2340722 2340722 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002979 880 HAPA-Hmong American Peace Academy K3-12 charter Regular School Yes Other PK 12 2021   grade_11                                                   84                                             84

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