enrollments

Data source: Big Local News · About: Big Local

4,744 rows where grade = "grade_8" and state = "WI" sorted by school descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_8 · 4,744 ✖
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
332093 332093 WI Juneau   school 5508850 3360 Public school Mauston 550885002863 410 iLEAD Individualized Leadership and Entrepreneurship Academic Discovery charter Regular School Yes High 07 12 2017   grade_8                                                   9                                             9
2324726 2324726 WI Juneau   school 5508850 3360 Public school Mauston 550885002863 410 iLEAD Individualized Leadership and Entrepreneurship Academic Discovery charter Regular School Yes High 07 12 2020   grade_8                                                   8                                             8
2339614 2339614 WI Juneau   school 5508850 3360 Public school Mauston 550885002863 410 iLEAD Individualized Leadership and Entrepreneurship Academic Discovery charter Regular School Yes High 07 12 2021   grade_8                                                   7                                             7
3080454 3080454 WI Juneau   school 5508850 3360 Public school Mauston 550885002863 410 iLEAD Individualized Leadership and Entrepreneurship Academic Discovery charter Regular School Yes High 07 12 2019   grade_8                                                   6                                             6
3095161 3095161 WI Juneau   school 5508850 3360 Public school Mauston 550885002863 410 iLEAD Individualized Leadership and Entrepreneurship Academic Discovery charter Regular School Yes High 07 12 2018   grade_8                                                   3                                             3
118237 118237 WI Juneau   school 5508850 3360 Public school Mauston 550885002863 410 iLEAD Charter School charter Regular School Yes 3.0 07 12 2015   grade_8                                                   4                                             4
288227 288227 WI Juneau   school 5508850 3360 Public school Mauston 550885002863 410 iLEAD Charter School charter Regular School Yes 3.0 07 12 2016   grade_8                                                   7                                             7
115350 115350 WI Burnett   school 5505670 2233 Public school Grantsburg 550567002704 400 iForward charter Regular School Yes 4.0 06 12 2015   grade_8                                                   52                                             52
285355 285355 WI Burnett   school 5505670 2233 Public school Grantsburg 550567002704 400 iForward charter Regular School Yes 4.0 06 12 2016   grade_8                                                   49                                             49
329226 329226 WI Burnett   school 5505670 2233 Public school Grantsburg 550567002704 400 iForward charter Regular School Yes Other 06 12 2017   grade_8                                                   50                                             50
2321770 2321770 WI Burnett   school 5505670 2233 Public school Grantsburg 550567002704 400 iForward charter Regular School Yes High 06 12 2020   grade_8                                                   56                                             56
2336617 2336617 WI Burnett   school 5505670 2233 Public school Grantsburg 550567002704 400 iForward charter Regular School Yes Other KG 12 2021   grade_8                                                   104                                             104
3077531 3077531 WI Burnett   school 5505670 2233 Public school Grantsburg 550567002704 400 iForward charter Regular School Yes High 06 12 2019   grade_8                                                   59                                             59
3092302 3092302 WI Burnett   school 5505670 2233 Public school Grantsburg 550567002704 400 iForward charter Regular School Yes High 06 12 2018   grade_8                                                   50                                             50
2334402 2334402 WI Chippewa   school   870 Public Schools-Multidistrict Charters Cadott Community   9419 eSucceed Charter School charter           2021   grade_8                                                   8                                             8
2334957 2334957 WI Chippewa   school   1204 Public Schools-Multidistrict Charters Cornell   9419 eSucceed Charter School charter           2021   grade_8                                                   3                                             3
2336465 2336465 WI Taylor   school 5505280 2135 Public school Gilman 550528003114 9419 eSucceed Charter School charter Regular School Yes Other KG 12 2021   grade_8                                                   6                                             6
2342139 2342139 WI Chippewa   school   3920 Public Schools-Multidistrict Charters New Auburn   9419 eSucceed Charter School charter           2021   grade_8                                                   1                                             1
2346402 2346402 WI Jefferson   school 5515750 6125 Public school Watertown Unified 551575003127 800 eCampus Academy Charter School charter Regular School Yes Other PK 12 2021   grade_8                                                   13                                             13
125004 125004 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003380 470 eAchieve Academy - Wisconsin charter Regular School Yes 4.0 06 12 2015   grade_8                                                   94                                             94
294940 294940 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003380 470 eAchieve Academy - Wisconsin charter Regular School Yes 4.0 06 12 2016   grade_8                                                   60                                             60
338848 338848 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003380 470 eAchieve Academy - Wisconsin charter Regular School Yes Other 06 12 2017   grade_8                                                   64                                             64
2331524 2331524 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003380 470 eAchieve Academy - Wisconsin charter Regular School Yes High 06 12 2020   grade_8                                                   66                                             66
2346479 2346479 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003380 470 eAchieve Academy - Wisconsin charter Regular School Yes High 06 12 2021   grade_8                                                   109                                             109
3087227 3087227 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003380 470 eAchieve Academy - Wisconsin charter Regular School Yes High 06 12 2019   grade_8                                                   70                                             70
3101922 3101922 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003380 470 eAchieve Academy - Wisconsin charter Regular School Yes High 06 12 2018   grade_8                                                   63                                             63
330356 330356 WI Rock   school 5507020 2695 Public school Janesville 550702002948 850 Youth Services Center   Alternative School No Other 04 12 2017   grade_8                                                   1                                             1
126380 126380 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No 1.0 PK 08 2015   grade_8                                                   74                                             74
296317 296317 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No 1.0 PK 08 2016   grade_8                                                   68                                             68
340258 340258 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2017   grade_8                                                   70                                             70
2332923 2332923 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   55                                             55
2347929 2347929 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2021   grade_8                                                   64                                             64
3088634 3088634 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2019   grade_8                                                   74                                             74
3103336 3103336 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2018   grade_8                                                   69                                             69
126371 126371 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No 2.0 05 08 2015   grade_8                                                   108                                             108
296308 296308 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No 2.0 05 08 2016   grade_8                                                   108                                             108
340249 340249 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No Middle 05 08 2017   grade_8                                                   102                                             102
2332914 2332914 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No Middle 05 08 2020   grade_8                                                   100                                             100
2347920 2347920 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No Middle 05 08 2021   grade_8                                                   88                                             88
3088625 3088625 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No Middle 05 08 2019   grade_8                                                   92                                             92
3103327 3103327 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No Middle 05 08 2018   grade_8                                                   94                                             94
114884 114884 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468002325 365 Woodworth Middle   Regular School No 2.0 06 08 2015   grade_8                                                   177                                             177
284879 284879 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468002325 365 Woodworth Middle   Regular School No 2.0 06 08 2016   grade_8                                                   168                                             168
328768 328768 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468002325 365 Woodworth Middle   Regular School No Middle 06 08 2017   grade_8                                                   169                                             169
2321333 2321333 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468002325 365 Woodworth Middle   Regular School No Middle 06 08 2020   grade_8                                                   169                                             169
2336162 2336162 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468002325 365 Woodworth Middle   Regular School No Middle 06 08 2021   grade_8                                                   155                                             155
3077094 3077094 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468002325 365 Woodworth Middle   Regular School No Middle 06 08 2019   grade_8                                                   173                                             173
3091843 3091843 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468002325 365 Woodworth Middle   Regular School No Middle 06 08 2018   grade_8                                                   153                                             153
115092 115092 WI Walworth   school 5505100 2044 Public school Geneva J4 550510000546 20 Woods Elementary   Regular School No 1.0 PK 08 2015   grade_8                                                   22                                             22
285096 285096 WI Walworth   school 5505100 2044 Public school Geneva J4 550510000546 20 Woods Elementary   Regular School No 1.0 PK 08 2016   grade_8                                                   22                                             22
328978 328978 WI Walworth   school 5505100 2044 Public school Geneva J4 550510000546 20 Woods Elementary   Regular School No Elementary PK 08 2017   grade_8                                                   23                                             23
2321532 2321532 WI Walworth   school 5505100 2044 Public school Geneva J4 550510000546 20 Woods Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   14                                             14
2336362 2336362 WI Walworth   school 5505100 2044 Public school Geneva J4 550510000546 20 Woods Elementary   Regular School No Elementary PK 08 2021   grade_8                                                   13                                             13
3077293 3077293 WI Walworth   school 5505100 2044 Public school Geneva J4 550510000546 20 Woods Elementary   Regular School No Elementary PK 08 2019   grade_8                                                   8                                             8
3092052 3092052 WI Walworth   school 5505100 2044 Public school Geneva J4 550510000546 20 Woods Elementary   Regular School No Elementary PK 08 2018   grade_8                                                   18                                             18
2332881 2332881 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School - State Street Campus 550007002942 100 Woodlands School - State Street Campus charter Regular School Yes Elementary PK 08 2020   grade_8                                                   24                                             24
2347888 2347888 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School - State Street Campus 550007002942 100 Woodlands School - State Street Campus charter Regular School Yes Elementary PK 08 2021   grade_8                                                   35                                             35
126333 126333 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes 1.0 PK 08 2015   grade_8                                                   32                                             32
296270 296270 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes 1.0 PK 08 2016   grade_8                                                   34                                             34
340209 340209 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2017   grade_8                                                   33                                             33
2332870 2332870 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2020   grade_8                                                   37                                             37
2347877 2347877 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2021   grade_8                                                   34                                             34
3088582 3088582 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2019   grade_8                                                   35                                             35
3103286 3103286 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2018   grade_8                                                   36                                             36
120346 120346 WI Oneida   school 5509690 3640 Public school Minocqua J1 550969002840 250 Woodland Progressive School for 21st Century Citizens charter Regular School Yes 2.0 06 08 2015   grade_8                                                   11                                             11
290304 290304 WI Oneida   school 5509690 3640 Public school Minocqua J1 550969002840 250 Woodland Progressive School for 21st Century Citizens charter Regular School Yes 2.0 06 08 2016   grade_8                                                   18                                             18
334175 334175 WI Oneida   school 5509690 3640 Public school Minocqua J1 550969002840 250 Woodland Progressive School for 21st Century Citizens charter Regular School Yes Middle 06 08 2017   grade_8                                                   16                                             16
2326777 2326777 WI Oneida   school 5509690 3640 Public school Minocqua J1 550969002840 250 Woodland Progressive School for 21st Century Citizens charter Regular School Yes Middle 06 08 2020   grade_8                                                   10                                             10
3082546 3082546 WI Oneida   school 5509690 3640 Public school Minocqua J1 550969002840 250 Woodland Progressive School for 21st Century Citizens charter Regular School Yes Middle 06 08 2019   grade_8                                                   11                                             11
3097250 3097250 WI Oneida   school 5509690 3640 Public school Minocqua J1 550969002840 250 Woodland Progressive School for 21st Century Citizens charter Regular School Yes Middle 06 08 2018   grade_8                                                   14                                             14
2347866 2347866 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_8                                                   3                                             3
126324 126324 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002226 100 Wonewoc-Center Junior High   Regular School No 2.0 06 08 2015   grade_8                                                   28                                             28
296261 296261 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002226 100 Wonewoc-Center Junior High   Regular School No 2.0 06 08 2016   grade_8                                                   17                                             17
340200 340200 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002226 100 Wonewoc-Center Junior High   Regular School No Middle 06 08 2017   grade_8                                                   30                                             30
2332859 2332859 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002226 100 Wonewoc-Center Junior High   Regular School No Middle 06 08 2020   grade_8                                                   30                                             30
2347854 2347854 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002226 100 Wonewoc-Center Junior High   Regular School No Middle 06 08 2021   grade_8                                                   26                                             26
3088570 3088570 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002226 100 Wonewoc-Center Junior High   Regular School No Middle 06 08 2019   grade_8                                                   18                                             18
3103275 3103275 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002226 100 Wonewoc-Center Junior High   Regular School No Middle 06 08 2018   grade_8                                                   23                                             23
126296 126296 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No 1.0 PK 08 2015   grade_8                                                   47                                             47
296234 296234 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No 1.0 PK 08 2016   grade_8                                                   41                                             41
340174 340174 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2017   grade_8                                                   43                                             43
2332833 2332833 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   48                                             48
2347823 2347823 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2021   grade_8                                                   43                                             43
3088543 3088543 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2019   grade_8                                                   45                                             45
3103248 3103248 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2018   grade_8                                                   50                                             50
121169 121169 WI Ozaukee   school 5504890 1945 Public school Northern Ozaukee 550489002801 850 Wisconsin Virtual Learning charter Regular School Yes 4.0 PK 12 2015   grade_8                                                   35                                             35
291127 291127 WI Ozaukee   school 5504890 1945 Public school Northern Ozaukee 550489002801 850 Wisconsin Virtual Learning charter Regular School Yes 4.0 PK 12 2016   grade_8                                                   32                                             32
334981 334981 WI Ozaukee   school 5504890 1945 Public school Northern Ozaukee 550489002801 850 Wisconsin Virtual Learning charter Regular School Yes Other PK 12 2017   grade_8                                                   27                                             27
2327623 2327623 WI Ozaukee   school 5504890 1945 Public school Northern Ozaukee 550489002801 850 Wisconsin Virtual Learning charter Regular School Yes Other PK 12 2020   grade_8                                                   27                                             27
2342497 2342497 WI Ozaukee   school 5504890 1945 Public school Northern Ozaukee 550489002801 850 Wisconsin Virtual Learning charter Regular School Yes Other PK 12 2021   grade_8                                                   29                                             29
3083360 3083360 WI Ozaukee   school 5504890 1945 Public school Northern Ozaukee 550489002801 850 Wisconsin Virtual Learning charter Regular School Yes Other PK 12 2019   grade_8                                                   26                                             26
3098059 3098059 WI Ozaukee   school 5504890 1945 Public school Northern Ozaukee 550489002801 850 Wisconsin Virtual Learning charter Regular School Yes Other PK 12 2018   grade_8                                                   20                                             20
118319 118319 WI Dane   school 5508910 3381 Public school McFarland 550891002973 160 Wisconsin Virtual Academy K-8 (WIVA) charter Regular School Yes 1.0 KG 08 2015   grade_8                                                   180                                             180
288314 288314 WI Dane   school 5508910 3381 Public school McFarland 550891002973 160 Wisconsin Virtual Academy K-8 (WIVA) charter Regular School Yes 1.0 KG 08 2016   grade_8                                                   180                                             180
332187 332187 WI Dane   school 5508910 3381 Public school McFarland 550891002973 160 Wisconsin Virtual Academy K-8 (WIVA) charter Regular School Yes Elementary KG 08 2017   grade_8                                                   208                                             208
2324821 2324821 WI Dane   school 5508910 3381 Public school McFarland 550891002973 160 Wisconsin Virtual Academy K-8 (WIVA) charter Regular School Yes Elementary KG 08 2020   grade_8                                                   242                                             242
2339709 2339709 WI Dane   school 5508910 3381 Public school McFarland 550891002973 160 Wisconsin Virtual Academy K-8 (WIVA) charter Regular School Yes Elementary KG 08 2021   grade_8                                                   366                                             366
3080550 3080550 WI Dane   school 5508910 3381 Public school McFarland 550891002973 160 Wisconsin Virtual Academy K-8 (WIVA) charter Regular School Yes Elementary KG 08 2019   grade_8                                                   186                                             186
3095266 3095266 WI Dane   school 5508910 3381 Public school McFarland 550891002973 160 Wisconsin Virtual Academy K-8 (WIVA) charter Regular School Yes Elementary KG 08 2018   grade_8                                                   187                                             187
2332801 2332801 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002216 290 Wisconsin Rapids Area Middle   Regular School No Middle 06 08 2020   grade_8                                                   355                                             355

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