enrollments

Data source: Big Local News · About: Big Local

4,121 rows where grade = "grade_12" and state = "WI" sorted by ccd_school_low_grade descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_12 · 4,121 ✖
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
112713 112713 WI Rock   school 5501050 413 Public school Beloit 550105002799 850 Beloit Virtual School   Regular School No 4.0 PK 12 2015   grade_12                                                   3                                             3
113469 113469 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_12                                                   1                                             1
113878 113878 WI Barron   school 5503090 1260 Public school Cumberland 550309002871 800 Island City Virtual Academy charter Regular School Yes 4.0 PK 12 2015   grade_12                                                   1                                             1
115377 115377 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_12                                                   21                                             21
115423 115423 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_12                                                   20                                             20
115893 115893 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_12                                                   7                                             7
118362 118362 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No 4.0 PK 12 2015   grade_12                                                   17                                             17
118588 118588 WI Iron   school 5509150 3484 Public school Mercer 550915001092 40 Mercer School   Regular School No 4.0 PK 12 2015   grade_12                                                   7                                             7
118603 118603 WI Lincoln   school 5509210 3500 Public school Merrill Area 550921002927 800 Bridges Virtual Academy charter Regular School Yes 4.0 PK 12 2015   grade_12                                                   18                                             18
119344 119344 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_12                                                   58                                             58
119647 119647 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002931 870 MacDowell Montessori School K3-12   Regular School No 4.0 PK 12 2015   grade_12                                                   32                                             32
119906 119906 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_12                                                   75                                             75
120225 120225 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000681 399 WI Conservatory of Lifelong Learning   Regular School No 4.0 PK 12 2015   grade_12                                                   42                                             42
120250 120250 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_12                                                   38                                             38
121162 121162 WI Ozaukee   school 5504890 1945 Public school Northern Ozaukee 550489002801 850 Wisconsin Virtual Learning charter Regular School Yes 4.0 PK 12 2015   grade_12                                                   62                                             62
122263 122263 WI Green Lake   school 5512300 4606 Public school Princeton 551230001595 40 Princeton School   Regular School No 4.0 PK 12 2015   grade_12                                                   21                                             21
123689 123689 WI Douglas   school 5513980 5397 Public school Solon Springs 551398001911 800 Solon Springs School   Regular School No 4.0 PK 12 2015   grade_12                                                   23                                             23
123903 123903 WI Washburn   school 5514220 5474 Public school Spooner Area 551422002971 850 Spooner Area Virtual Education Academy charter Regular School Yes 4.0 PK 12 2015   grade_12                                                   2                                             2
124454 124454 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_12                                                   40                                             40
282692 282692 WI Rock   school 5501050 413 Public school Beloit 550105002799 850 Beloit Virtual School   Regular School No 4.0 PK 12 2016   grade_12                                                   12                                             12
283447 283447 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes 4.0 PK 12 2016   grade_12                                                   3                                             3
284506 284506 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_12                                                   4                                             4
285384 285384 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_12                                                   12                                             12
285427 285427 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_12                                                   25                                             25
285896 285896 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_12                                                   15                                             15
288358 288358 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No 4.0 PK 12 2016   grade_12                                                   19                                             19
288588 288588 WI Iron   school 5509150 3484 Public school Mercer 550915001092 40 Mercer School   Regular School No 4.0 PK 12 2016   grade_12                                                   7                                             7
288603 288603 WI Lincoln   school 5509210 3500 Public school Merrill Area 550921002927 800 Bridges Virtual Academy charter Regular School Yes 4.0 PK 12 2016   grade_12                                                   25                                             25
289325 289325 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_12                                                   48                                             48
289616 289616 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002931 870 MacDowell Montessori School K3-12   Regular School No 4.0 PK 12 2016   grade_12                                                   26                                             26
289875 289875 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_12                                                   68                                             68
290182 290182 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000681 399 WI Conservatory of Lifelong Learning   Regular School No 4.0 PK 12 2016   grade_12                                                   26                                             26
290207 290207 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_12                                                   24                                             24
291120 291120 WI Ozaukee   school 5504890 1945 Public school Northern Ozaukee 550489002801 850 Wisconsin Virtual Learning charter Regular School Yes 4.0 PK 12 2016   grade_12                                                   54                                             54
292226 292226 WI Green Lake   school 5512300 4606 Public school Princeton 551230001595 40 Princeton School   Regular School No 4.0 PK 12 2016   grade_12                                                   39                                             39
293644 293644 WI Douglas   school 5513980 5397 Public school Solon Springs 551398001911 800 Solon Springs School   Regular School No 4.0 PK 12 2016   grade_12                                                   22                                             22
294389 294389 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_12                                                   31                                             31
325885 325885 WI Outagamie   school 5500390 147 Public school Appleton Area 550039003021 820 Appleview   Special Education School No Other PK 12 2017   grade_12                                                   1                                             1
326592 326592 WI Rock   school 5501050 413 Public school Beloit 550105002799 850 Beloit Virtual School   Regular School No Other PK 12 2017   grade_12                                                   21                                             21
327353 327353 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_12                                                   1                                             1
327759 327759 WI Barron   school 5503090 1260 Public school Cumberland 550309002871 800 Island City Virtual Academy charter Regular School Yes Other PK 12 2017   grade_12                                                   2                                             2
328405 328405 WI Walworth   school 5504290 1638 Public school Elkhorn Area 550429003038 800 Elkhorn Options Virtual School charter Regular School Yes Other PK 12 2017   grade_12                                                   8                                             8
329256 329256 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000612 40 Bay View   Alternative School No Other PK 12 2017   grade_12                                                   53                                             53
329300 329300 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_12                                                   103                                             103
329775 329775 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_12                                                   9                                             9
332232 332232 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2017   grade_12                                                   21                                             21
332459 332459 WI Iron   school 5509150 3484 Public school Mercer 550915001092 40 Mercer School   Regular School No Other PK 12 2017   grade_12                                                   11                                             11
332474 332474 WI Lincoln   school 5509210 3500 Public school Merrill Area 550921002927 800 Bridges Virtual Academy charter Regular School Yes Other PK 12 2017   grade_12                                                   19                                             19
333195 333195 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_12                                                   54                                             54
333486 333486 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002931 870 MacDowell Montessori School K3-12   Regular School No Other PK 12 2017   grade_12                                                   30                                             30
333771 333771 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_12                                                   63                                             63
334074 334074 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000681 399 Wisconsin Conservatory of Lifelong Learning   Regular School No Other PK 12 2017   grade_12                                                   35                                             35
334099 334099 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_12                                                   27                                             27
334974 334974 WI Ozaukee   school 5504890 1945 Public school Northern Ozaukee 550489002801 850 Wisconsin Virtual Learning charter Regular School Yes Other PK 12 2017   grade_12                                                   57                                             57
336105 336105 WI Green Lake   school 5512300 4606 Public school Princeton 551230001595 40 Princeton School   Regular School No Other PK 12 2017   grade_12                                                   24                                             24
337535 337535 WI Douglas   school 5513980 5397 Public school Solon Springs 551398001911 800 Solon Springs School   Regular School No Other PK 12 2017   grade_12                                                   17                                             17
338288 338288 WI Monroe   school 5514910 5747 Public school Tomah Area 551491002543 800 Robert Kupper Learning Center   Alternative School No Other PK 12 2017   grade_12                                                   34                                             34
338451 338451 WI Manitowoc   school 5515120 5824 Public school Two Rivers Public 551512003037 810 Lighthouse Learning Academy charter Regular School Yes Other PK 12 2017   grade_12                                                   6                                             6
339862 339862 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_12                                                   12                                             12
2318596 2318596 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other PK 12 2020   grade_12                                                   77                                             77
2319091 2319091 WI Rock   school 5501050 413 Public school Beloit 550105002799 850 Beloit Virtual School   Regular School No Other PK 12 2020   grade_12                                                   2                                             2
2319257 2319257 WI Washburn   school 5501170 441 Public school Birchwood 550117003020 800 Bobcat Virtual Academy charter Regular School Yes Other PK 12 2020   grade_12                                                   4                                             4
2319658 2319658 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other PK 12 2020   grade_12                                                   22                                             22
2319884 2319884 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_12                                                   7                                             7
2320296 2320296 WI Barron   school 5503090 1260 Public school Cumberland 550309002871 800 Island City Virtual Academy charter Regular School Yes Other PK 12 2020   grade_12                                                   3                                             3
2320963 2320963 WI Walworth   school 5504290 1638 Public school Elkhorn Area 550429003038 800 Elkhorn Options Virtual School charter Regular School Yes Other PK 12 2020   grade_12                                                   21                                             21
2321800 2321800 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000612 40 Bay View   Alternative School No Other PK 12 2020   grade_12                                                   15                                             15
2322319 2322319 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_12                                                   13                                             13
2323848 2323848 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_12                                                   10                                             10
2324845 2324845 WI Taylor   school 5508940 3409 Public school Medford Area Public 550894002598 9100 Rural Virtual Academy charter Regular School Yes Other PK 12 2020   grade_12                                                   53                                             53
2324868 2324868 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2020   grade_12                                                   24                                             24
2325087 2325087 WI Iron   school 5509150 3484 Public school Mercer 550915001092 40 Mercer School   Regular School No Other PK 12 2020   grade_12                                                   14                                             14
2325103 2325103 WI Lincoln   school 5509210 3500 Public school Merrill Area 550921002927 800 Bridges Virtual Academy charter Regular School Yes Other PK 12 2020   grade_12                                                   35                                             35
2325827 2325827 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_12                                                   68                                             68
2326105 2326105 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002931 870 MacDowell Montessori School K3-12   Regular School No Other PK 12 2020   grade_12                                                   46                                             46
2326385 2326385 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_12                                                   75                                             75
2326679 2326679 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000681 399 Wisconsin Conservatory of Lifelong Learning   Regular School No Other PK 12 2020   grade_12                                                   36                                             36
2326704 2326704 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_12                                                   39                                             39
2327258 2327258 WI Wood   school 5510380 3906 Public school Nekoosa 551038003089 800 WISE Academy charter Regular School Yes Other PK 12 2020   grade_12                                                   4                                             4
2327616 2327616 WI Ozaukee   school 5504890 1945 Public school Northern Ozaukee 550489002801 850 Wisconsin Virtual Learning charter Regular School Yes Other PK 12 2020   grade_12                                                   59                                             59
2328755 2328755 WI Green Lake   school 5512300 4606 Public school Princeton 551230001595 40 Princeton School   Regular School No Other PK 12 2020   grade_12                                                   30                                             30
2329346 2329346 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_12                                                   1                                             1
2329579 2329579 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_12                                                   69                                             69
2330136 2330136 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_12                                                   3                                             3
2330142 2330142 WI Douglas   school 5513980 5397 Public school Solon Springs 551398001911 800 Solon Springs School   Regular School No Other PK 12 2020   grade_12                                                   19                                             19
2330937 2330937 WI Monroe   school 5514910 5747 Public school Tomah Area 551491002543 800 Robert Kupper Learning Center   Alternative School No Other PK 12 2020   grade_12                                                   27                                             27
2331071 2331071 WI Barron   school 5515060 5810 Public school Turtle Lake 551506003032 810 Laker Online charter Regular School Yes Other PK 12 2020   grade_12                                                   2                                             2
2331122 2331122 WI Manitowoc   school 5515120 5824 Public school Two Rivers Public 551512003037 810 Lighthouse Learning Academy charter Regular School Yes Other PK 12 2020   grade_12                                                   7                                             7
2333390 2333390 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other PK 12 2021   grade_12                                                   90                                             90
2333865 2333865 WI Rock   school 5501050 413 Public school Beloit 550105002799 850 Beloit Virtual School   Regular School No Other PK 12 2021   grade_12                                                   6                                             6
2334451 2334451 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other PK 12 2021   grade_12                                                   26                                             26
2334670 2334670 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_12                                                   5                                             5
2335092 2335092 WI Barron   school 5503090 1260 Public school Cumberland 550309002871 800 Island City Virtual Academy charter Regular School Yes Other PK 12 2021   grade_12                                                   5                                             5
2335788 2335788 WI Walworth   school 5504290 1638 Public school Elkhorn Area 550429003038 800 Elkhorn Options Virtual School charter Regular School Yes Other PK 12 2021   grade_12                                                   44                                             44
2335922 2335922 WI Pierce   school 5504350 1666 Public school Elmwood 550435003121 800 Western Wisconsin Virtual Charter School (WWVC) charter Regular School Yes Other PK 12 2021   grade_12                                                   2                                             2
2336647 2336647 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000612 40 Bay View   Alternative School No Other PK 12 2021   grade_12                                                   11                                             11
2337146 2337146 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_12                                                   13                                             13
2339511 2339511 WI Dane   school 5508790 3332 Public school Marshall 550879002901 9803 JEDI Virtual K-12 charter Alternative School Yes Other PK 12 2021   grade_12                                                   6                                             6
2339733 2339733 WI Taylor   school 5508940 3409 Public school Medford Area Public 550894002598 9100 Rural Virtual Academy charter Regular School Yes Other PK 12 2021   grade_12                                                   39                                             39
2339972 2339972 WI Iron   school 5509150 3484 Public school Mercer 550915001092 40 Mercer School   Regular School No Other PK 12 2021   grade_12                                                   19                                             19

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