enrollments

Data source: Big Local News · About: Big Local

7,819 rows where grade = "grade_1" and state = "WI" sorted by ccd_school_lvl descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_1 · 7,819 ✖
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
326105 326105 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other KG 12 2017   grade_1                                                   26                                             26
326383 326383 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2017   grade_1                                                   1                                             1
327128 327128 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other KG 12 2017   grade_1                                                   6                                             6
327350 327350 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_1                                                   4                                             4
327757 327757 WI Barron   school 5503090 1260 Public school Cumberland 550309002871 800 Island City Virtual Academy charter Regular School Yes Other PK 12 2017   grade_1                                                   2                                             2
328402 328402 WI Walworth   school 5504290 1638 Public school Elkhorn Area 550429003038 800 Elkhorn Options Virtual School charter Regular School Yes Other PK 12 2017   grade_1                                                   14                                             14
329253 329253 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000612 40 Bay View   Alternative School No Other PK 12 2017   grade_1                                                   2                                             2
329297 329297 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_1                                                   1                                             1
329772 329772 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_1                                                   11                                             11
330205 330205 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2017   grade_1                                                   1                                             1
330617 330617 WI Kenosha   school 5507320 2793 Public school Kenosha 550732002910 800 Kenosha eSchool K-12 charter Regular School Yes Other KG 12 2017   grade_1                                                   5                                             5
332208 332208 WI Taylor   school 5508940 3409 Public school Medford Area Public 550894002598 9100 Rural Virtual Academy charter Regular School Yes Other PK 11 2017   grade_1                                                   17                                             17
332229 332229 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2017   grade_1                                                   14                                             14
332456 332456 WI Iron   school 5509150 3484 Public school Mercer 550915001092 40 Mercer School   Regular School No Other PK 12 2017   grade_1                                                   8                                             8
332471 332471 WI Lincoln   school 5509210 3500 Public school Merrill Area 550921002927 800 Bridges Virtual Academy charter Regular School Yes Other PK 12 2017   grade_1                                                   62                                             62
333192 333192 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_1                                                   136                                             136
333483 333483 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002931 870 MacDowell Montessori School K3-12   Regular School No Other PK 12 2017   grade_1                                                   51                                             51
333768 333768 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_1                                                   22                                             22
333987 333987 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002967 875 Universal Academy for the College Bound charter Regular School Yes Other PK 12 2017   grade_1                                                   74                                             74
334071 334071 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000681 399 Wisconsin Conservatory of Lifelong Learning   Regular School No Other PK 12 2017   grade_1                                                   32                                             32
334096 334096 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_1                                                   92                                             92
334971 334971 WI Ozaukee   school 5504890 1945 Public school Northern Ozaukee 550489002801 850 Wisconsin Virtual Learning charter Regular School Yes Other PK 12 2017   grade_1                                                   24                                             24
336020 336020 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002944 800 Mighty River Academy of Virtual Education charter Regular School Yes Other KG 12 2017   grade_1                                                   2                                             2
336102 336102 WI Green Lake   school 5512300 4606 Public school Princeton 551230001595 40 Princeton School   Regular School No Other PK 12 2017   grade_1                                                   25                                             25
336333 336333 WI Racine   school 5512360 4620 Public school Racine Unified 551236003045 801 Racine Alternative Learning   Alternative School No Other KG 12 2017   grade_1                                                   1                                             1
337532 337532 WI Douglas   school 5513980 5397 Public school Solon Springs 551398001911 800 Solon Springs School   Regular School No Other PK 12 2017   grade_1                                                   21                                             21
338396 338396 WI Barron   school 5515060 5810 Public school Turtle Lake 551506003032 810 Laker Online charter Regular School Yes Other PK 12 2017   grade_1                                                   1                                             1
338448 338448 WI Manitowoc   school 5515120 5824 Public school Two Rivers Public 551512003037 810 Lighthouse Learning Academy charter Regular School Yes Other PK 12 2017   grade_1                                                   2                                             2
2318593 2318593 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other PK 12 2020   grade_1                                                   12                                             12
2319655 2319655 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other PK 12 2020   grade_1                                                   2                                             2
2319816 2319816 WI Milwaukee   school 5500041 8105 Non District Charter Schools Central City Cyberschool 550004102171 1211 Central City Cyberschool charter Regular School Yes Other PK 10 2020   grade_1                                                   40                                             40
2319881 2319881 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_1                                                   2                                             2
2320293 2320293 WI Barron   school 5503090 1260 Public school Cumberland 550309002871 800 Island City Virtual Academy charter Regular School Yes Other PK 12 2020   grade_1                                                   3                                             3
2320960 2320960 WI Walworth   school 5504290 1638 Public school Elkhorn Area 550429003038 800 Elkhorn Options Virtual School charter Regular School Yes Other PK 12 2020   grade_1                                                   17                                             17
2322316 2322316 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_1                                                   15                                             15
2322743 2322743 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 12 2020   grade_1                                                   19                                             19
2324842 2324842 WI Taylor   school 5508940 3409 Public school Medford Area Public 550894002598 9100 Rural Virtual Academy charter Regular School Yes Other PK 12 2020   grade_1                                                   49                                             49
2324865 2324865 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2020   grade_1                                                   23                                             23
2325084 2325084 WI Iron   school 5509150 3484 Public school Mercer 550915001092 40 Mercer School   Regular School No Other PK 12 2020   grade_1                                                   10                                             10
2325100 2325100 WI Lincoln   school 5509210 3500 Public school Merrill Area 550921002927 800 Bridges Virtual Academy charter Regular School Yes Other PK 12 2020   grade_1                                                   73                                             73
2325824 2325824 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_1                                                   167                                             167
2326102 2326102 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002931 870 MacDowell Montessori School K3-12   Regular School No Other PK 12 2020   grade_1                                                   58                                             58
2326382 2326382 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_1                                                   18                                             18
2326676 2326676 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000681 399 Wisconsin Conservatory of Lifelong Learning   Regular School No Other PK 12 2020   grade_1                                                   12                                             12
2326701 2326701 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_1                                                   91                                             91
2327255 2327255 WI Wood   school 5510380 3906 Public school Nekoosa 551038003089 800 WISE Academy charter Regular School Yes Other PK 12 2020   grade_1                                                   11                                             11
2327613 2327613 WI Ozaukee   school 5504890 1945 Public school Northern Ozaukee 550489002801 850 Wisconsin Virtual Learning charter Regular School Yes Other PK 12 2020   grade_1                                                   14                                             14
2328669 2328669 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002944 800 Mighty River Academy of Virtual Education charter Regular School Yes Other KG 12 2020   grade_1                                                   2                                             2
2328752 2328752 WI Green Lake   school 5512300 4606 Public school Princeton 551230001595 40 Princeton School   Regular School No Other PK 12 2020   grade_1                                                   19                                             19
2328964 2328964 WI Racine   school 5512360 4620 Public school Racine Unified 551236003045 801 Racine Alternative Learning   Alternative School No Other KG 12 2020   grade_1                                                   1                                             1
2329343 2329343 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_1                                                   8                                             8
2330139 2330139 WI Douglas   school 5513980 5397 Public school Solon Springs 551398001911 800 Solon Springs School   Regular School No Other PK 12 2020   grade_1                                                   15                                             15
2331119 2331119 WI Manitowoc   school 5515120 5824 Public school Two Rivers Public 551512003037 810 Lighthouse Learning Academy charter Regular School Yes Other PK 12 2020   grade_1                                                   5                                             5
2333387 2333387 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other PK 12 2021   grade_1                                                   87                                             87
2333670 2333670 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2021   grade_1                                                   2                                             2
2333862 2333862 WI Rock   school 5501050 413 Public school Beloit 550105002799 850 Beloit Virtual School   Regular School No Other PK 12 2021   grade_1                                                   3                                             3
2334032 2334032 WI Washburn   school 5501170 441 Public school Birchwood 550117003020 800 Bobcat Virtual Academy charter Regular School Yes Other KG 12 2021   grade_1                                                   2                                             2
2334448 2334448 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other PK 12 2021   grade_1                                                   9                                             9
2334597 2334597 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_1                                                   29                                             29
2334667 2334667 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_1                                                   3                                             3
2335089 2335089 WI Barron   school 5503090 1260 Public school Cumberland 550309002871 800 Island City Virtual Academy charter Regular School Yes Other PK 12 2021   grade_1                                                   10                                             10
2335785 2335785 WI Walworth   school 5504290 1638 Public school Elkhorn Area 550429003038 800 Elkhorn Options Virtual School charter Regular School Yes Other PK 12 2021   grade_1                                                   51                                             51
2336455 2336455 WI Taylor   school 5505280 2135 Public school Gilman 550528003114 9419 eSucceed Charter School charter Regular School Yes Other KG 12 2021   grade_1                                                   5                                             5
2336607 2336607 WI Burnett   school 5505670 2233 Public school Grantsburg 550567002704 400 iForward charter Regular School Yes Other KG 12 2021   grade_1                                                   7                                             7
2337143 2337143 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_1                                                   12                                             12
2337601 2337601 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_1                                                   24                                             24
2337641 2337641 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2021   grade_1                                                   4                                             4
2339508 2339508 WI Dane   school 5508790 3332 Public school Marshall 550879002901 9803 JEDI Virtual K-12 charter Alternative School Yes Other PK 12 2021   grade_1                                                   3                                             3
2339730 2339730 WI Taylor   school 5508940 3409 Public school Medford Area Public 550894002598 9100 Rural Virtual Academy charter Regular School Yes Other PK 12 2021   grade_1                                                   68                                             68
2339753 2339753 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other KG 12 2021   grade_1                                                   18                                             18
2339969 2339969 WI Iron   school 5509150 3484 Public school Mercer 550915001092 40 Mercer School   Regular School No Other PK 12 2021   grade_1                                                   12                                             12
2339985 2339985 WI Lincoln   school 5509210 3500 Public school Merrill Area 550921002927 800 Bridges Virtual Academy charter Regular School Yes Other PK 12 2021   grade_1                                                   91                                             91
2340720 2340720 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_1                                                   150                                             150
2340995 2340995 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002931 870 MacDowell Montessori School K3-12   Regular School No Other PK 12 2021   grade_1                                                   69                                             69
2341257 2341257 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002993 840 Obama School of Career and Technical Education   Regular School No Other PK 12 2021   grade_1                                                   21                                             21
2341546 2341546 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000681 399 Wisconsin Conservatory of Lifelong Learning   Regular School No Other PK 12 2021   grade_1                                                   8                                             8
2341570 2341570 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 2021   grade_1                                                   95                                             95
2341783 2341783 WI Marquette   school 5509870 3689 Public school Montello 550987003016 800 Montello Virtual Charter School charter Regular School Yes Other PK 12 2021   grade_1                                                   5                                             5
2342124 2342124 WI Wood   school 5510380 3906 Public school Nekoosa 551038003089 800 WISE Academy charter Regular School Yes Other PK 12 2021   grade_1                                                   15                                             15
2342487 2342487 WI Ozaukee   school 5504890 1945 Public school Northern Ozaukee 550489002801 850 Wisconsin Virtual Learning charter Regular School Yes Other PK 12 2021   grade_1                                                   19                                             19
2342573 2342573 WI Washburn   school 5509720 3654 Public school Northwood 550972003018 800 Northwood Virtual Charter School charter Regular School Yes Other PK 12 2021   grade_1                                                   4                                             4
2343559 2343559 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002944 800 Mighty River Academy of Virtual Education charter Regular School Yes Other KG 12 2021   grade_1                                                   3                                             3
2343643 2343643 WI Green Lake   school 5512300 4606 Public school Princeton 551230001595 40 Princeton School   Regular School No Other PK 12 2021   grade_1                                                   22                                             22
2343855 2343855 WI Racine   school 5512360 4620 Public school Racine Unified 551236003045 801 Racine Alternative Learning   Alternative School No Other KG 12 2021   grade_1                                                   3                                             3
2344242 2344242 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 2021   grade_1                                                   52                                             52
2344476 2344476 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 2021   grade_1                                                   21                                             21
2345032 2345032 WI Douglas   school 5513980 5397 Public school Solon Springs 551398003092 850 Eagles' Wings Virtual Charter School charter Regular School Yes Other PK 12 2021   grade_1                                                   1                                             1
2345042 2345042 WI Douglas   school 5513980 5397 Public school Solon Springs 551398001911 800 Solon Springs School   Regular School No Other PK 12 2021   grade_1                                                   6                                             6
2345988 2345988 WI Barron   school 5515060 5810 Public school Turtle Lake 551506003032 810 Laker Online charter Regular School Yes Other PK 12 2021   grade_1                                                   3                                             3
2346046 2346046 WI Manitowoc   school 5515120 5824 Public school Two Rivers Public 551512003037 810 Lighthouse Learning Academy charter Regular School Yes Other PK 12 2021   grade_1                                                   17                                             17
2346392 2346392 WI Jefferson   school 5515750 6125 Public school Watertown Unified 551575003127 800 eCampus Academy Charter School charter Regular School Yes Other PK 12 2021   grade_1                                                   4                                             4
2346860 2346860 WI Marathon   school 5515900 6223 Public school Wausau 551590003027 800 Wausau Area Virtual Education charter Regular School Yes Other KG 12 2021   grade_1                                                   16                                             16
2347856 2347856 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713003059 850 Wonewoc-Center Virtual Academy charter Regular School Yes Other KG 12 2021   grade_1                                                   1                                             1
3074383 3074383 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002825 850 Wisconsin Connections Academy charter Regular School Yes Other PK 12 2019   grade_1                                                   17                                             17
3074866 3074866 WI Rock   school 5501050 413 Public school Beloit 550105002799 850 Beloit Virtual School   Regular School No Other PK 12 2019   grade_1                                                   2                                             2
3075433 3075433 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other PK 12 2019   grade_1                                                   6                                             6
3075657 3075657 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes Other PK 12 2019   grade_1                                                   5                                             5
3076067 3076067 WI Barron   school 5503090 1260 Public school Cumberland 550309002871 800 Island City Virtual Academy charter Regular School Yes Other PK 12 2019   grade_1                                                   1                                             1
3076721 3076721 WI Walworth   school 5504290 1638 Public school Elkhorn Area 550429003038 800 Elkhorn Options Virtual School charter Regular School Yes Other PK 12 2019   grade_1                                                   11                                             11
3078069 3078069 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627003339 800 Hayward Ctr for Individualized Learning charter Regular School Yes Other PK 12 2019   grade_1                                                   10                                             10

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);