enrollments

Data source: Big Local News · About: Big Local

3,931 rows where grade = "grade_9" and state = "WI" sorted by school_nces_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_9 · 3,931 ✖
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
112935 112935 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No 3.0 07 12 2015   grade_9                                                   33                                             33
282916 282916 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No 3.0 07 12 2016   grade_9                                                   49                                             49
326816 326816 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No High 07 12 2017   grade_9                                                   46                                             46
2319314 2319314 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No High 07 12 2020   grade_9                                                   47                                             47
2334098 2334098 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No High 07 12 2021   grade_9                                                   44                                             44
3075101 3075101 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No High 07 12 2019   grade_9                                                   40                                             40
3089861 3089861 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No High 07 12 2018   grade_9                                                   46                                             46
122967 122967 WI Grant   school 5500017 4904 Public school River Ridge 550001700686 80 River Ridge Middle/High   Regular School No 3.0 07 12 2015   grade_9                                                   33                                             33
292929 292929 WI Grant   school 5500017 4904 Public school River Ridge 550001700686 80 River Ridge Middle/High   Regular School No 3.0 07 12 2016   grade_9                                                   47                                             47
336817 336817 WI Grant   school 5500017 4904 Public school River Ridge 550001700686 80 River Ridge Middle/High   Regular School No High 07 12 2017   grade_9                                                   49                                             49
2329429 2329429 WI Grant   school 5500017 4904 Public school River Ridge 550001700686 80 River Ridge High   Regular School No High 09 12 2020   grade_9                                                   52                                             52
2344326 2344326 WI Grant   school 5500017 4904 Public school River Ridge 550001700686 80 River Ridge High   Regular School No High 09 12 2021   grade_9                                                   39                                             39
3085148 3085148 WI Grant   school 5500017 4904 Public school River Ridge 550001700686 80 River Ridge High   Regular School No High 09 12 2019   grade_9                                                   54                                             54
3099884 3099884 WI Grant   school 5500017 4904 Public school River Ridge 550001700686 80 River Ridge High   Regular School No High 09 12 2018   grade_9                                                   45                                             45
111756 111756 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No 4.0 06 12 2015   grade_9                                                   50                                             50
281730 281730 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No 4.0 06 12 2016   grade_9                                                   55                                             55
325624 325624 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No Other 06 12 2017   grade_9                                                   41                                             41
2318147 2318147 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2020   grade_9                                                   59                                             59
2332953 2332953 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2021   grade_9                                                   61                                             61
3073915 3073915 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2019   grade_9                                                   50                                             50
3088664 3088664 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2018   grade_9                                                   55                                             55
2319825 2319825 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_9                                                   44                                             44
2334607 2334607 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_9                                                   25                                             25
120258 120258 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_9                                                   85                                             85
290215 290215 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_9                                                   72                                             72
334107 334107 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_9                                                   84                                             84
2326712 2326712 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_9                                                   103                                             103
2341581 2341581 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_9                                                   117                                             117
3082477 3082477 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 2019   grade_9                                                   108                                             108
3097183 3097183 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 2018   grade_9                                                   102                                             102
124360 124360 WI Milwaukee   school 5500050 8115 Non District Charter Schools Tenor High School 550005002637 400 Tenor High School charter Regular School Yes 3.0 09 12 2015   grade_9                                                   65                                             65
115793 115793 WI Shawano   school 5500056 2415 Public school Gresham 550005602740 400 Gresham High   Regular School No 4.0 06 12 2015   grade_9                                                   22                                             22
285796 285796 WI Shawano   school 5500056 2415 Public school Gresham 550005602740 400 Gresham High   Regular School No 4.0 06 12 2016   grade_9                                                   29                                             29
329675 329675 WI Shawano   school 5500056 2415 Public school Gresham 550005602740 400 Gresham High   Regular School No Other 06 12 2017   grade_9                                                   28                                             28
2322223 2322223 WI Shawano   school 5500056 2415 Public school Gresham 550005602740 400 Gresham High   Regular School No High 06 12 2020   grade_9                                                   15                                             15
2337063 2337063 WI Shawano   school 5500056 2415 Public school Gresham 550005602740 400 Gresham High   Regular School No High 06 12 2021   grade_9                                                   17                                             17
3077972 3077972 WI Shawano   school 5500056 2415 Public school Gresham 550005602740 400 Gresham High   Regular School No High 06 12 2019   grade_9                                                   17                                             17
3092748 3092748 WI Shawano   school 5500056 2415 Public school Gresham 550005602740 400 Gresham High   Regular School No High 06 12 2018   grade_9                                                   16                                             16
113425 113425 WI Price   school 5500058 1071 Public school Chequamegon 550005802763 400 Chequamegon High   Regular School No 3.0 09 12 2015   grade_9                                                   66                                             66
283407 283407 WI Price   school 5500058 1071 Public school Chequamegon 550005802763 400 Chequamegon High   Regular School No 3.0 09 12 2016   grade_9                                                   44                                             44
327306 327306 WI Price   school 5500058 1071 Public school Chequamegon 550005802763 400 Chequamegon High   Regular School No High 09 12 2017   grade_9                                                   69                                             69
2319837 2319837 WI Price   school 5500058 1071 Public school Chequamegon 550005802763 400 Chequamegon High   Regular School No High 09 12 2020   grade_9                                                   54                                             54
2334619 2334619 WI Price   school 5500058 1071 Public school Chequamegon 550005802763 400 Chequamegon High   Regular School No High 09 12 2021   grade_9                                                   50                                             50
3075613 3075613 WI Price   school 5500058 1071 Public school Chequamegon 550005802763 400 Chequamegon High   Regular School No High 09 12 2019   grade_9                                                   48                                             48
3090364 3090364 WI Price   school 5500058 1071 Public school Chequamegon 550005802763 400 Chequamegon High   Regular School No High 09 12 2018   grade_9                                                   61                                             61
327315 327315 WI Price   school 5500058 1071 Public school Chequamegon 550005802780 450 Class ACT Charter charter Career and Technical School Yes High 09 12 2017   grade_9                                                   2                                             2
2319846 2319846 WI Price   school 5500058 1071 Public school Chequamegon 550005802780 450 Class ACT Charter charter Career and Technical School Yes High 09 12 2020   grade_9                                                   4                                             4
2334628 2334628 WI Price   school 5500058 1071 Public school Chequamegon 550005802780 450 Class ACT Charter charter Career and Technical School Yes High 09 12 2021   grade_9                                                   2                                             2
3075622 3075622 WI Price   school 5500058 1071 Public school Chequamegon 550005802780 450 Class ACT Charter charter Career and Technical School Yes High 09 12 2019   grade_9                                                   10                                             10
3090373 3090373 WI Price   school 5500058 1071 Public school Chequamegon 550005802780 450 Class ACT Charter charter Career and Technical School Yes High 09 12 2018   grade_9                                                   4                                             4
111770 111770 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No 3.0 09 12 2015   grade_9                                                   103                                             103
281744 281744 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No 3.0 09 12 2016   grade_9                                                   135                                             135
325640 325640 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No High 09 12 2017   grade_9                                                   114                                             114
2318164 2318164 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No High 09 12 2020   grade_9                                                   115                                             115
2332967 2332967 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No High 09 12 2021   grade_9                                                   94                                             94
3073933 3073933 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No High 09 12 2019   grade_9                                                   131                                             131
3088682 3088682 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No High 09 12 2018   grade_9                                                   113                                             113
113451 113451 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102807 400 Chetek-Weyerhaeuser High   Regular School No 3.0 09 12 2015   grade_9                                                   77                                             77
283430 283430 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102807 400 Chetek-Weyerhaeuser High   Regular School No 3.0 09 12 2016   grade_9                                                   61                                             61
327335 327335 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102807 400 Chetek-Weyerhaeuser High   Regular School No High 09 12 2017   grade_9                                                   55                                             55
2319866 2319866 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102807 400 Chetek-Weyerhaeuser High   Regular School No High 09 12 2020   grade_9                                                   62                                             62
2334652 2334652 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102807 400 Chetek-Weyerhaeuser High   Regular School No High 09 12 2021   grade_9                                                   70                                             70
3075642 3075642 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102807 400 Chetek-Weyerhaeuser High   Regular School No High 09 12 2019   grade_9                                                   58                                             58
3090393 3090393 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102807 400 Chetek-Weyerhaeuser High   Regular School No High 09 12 2018   grade_9                                                   70                                             70
113477 113477 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_9                                                   4                                             4
283455 283455 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_9                                                   5                                             5
327361 327361 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_9                                                   3                                             3
2319892 2319892 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_9                                                   4                                             4
2334678 2334678 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_9                                                   5                                             5
3075668 3075668 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_9                                                   1                                             1
3090419 3090419 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes Other PK 12 2018   grade_9                                                   2                                             2
124692 124692 WI Milwaukee   school 5500064 8124 Non District Charter Schools Veritas High 550006402496 400 Veritas High charter Regular School Yes 3.0 09 12 2015   grade_9                                                   78                                             78
120287 120287 WI Milwaukee   school 5500066 8127 Non District Charter Schools Milwaukee Collegiate Academy 550006602865 400 Milwaukee Collegiate Academy charter Regular School Yes 3.0 09 12 2015   grade_9                                                   139                                             139
290244 290244 WI Milwaukee   school 5500066 8127 Non District Charter Schools Milwaukee Collegiate Academy 550006602865 400 Milwaukee Collegiate Academy charter Regular School Yes 3.0 09 12 2016   grade_9                                                   140                                             140
334114 334114 WI Milwaukee   school 5500066 8127 Non District Charter Schools Milwaukee Collegiate Academy 550006602865 400 Milwaukee Collegiate Academy charter Regular School Yes High 09 12 2017   grade_9                                                   92                                             92
2320639 2320639 WI Milwaukee   school 5500066 8127 Non District Charter Schools Dr Howard Fuller Collegiate Academy 550006602865 400 Dr Howard Fuller Collegiate Academy charter Regular School Yes High 09 12 2020   grade_9                                                   100                                             100
2335440 2335440 WI Milwaukee   school 5500066 8127 Non District Charter Schools Dr Howard Fuller Collegiate Academy 550006602865 400 Dr Howard Fuller Collegiate Academy charter Regular School Yes High 09 12 2021   grade_9                                                   86                                             86
3082484 3082484 WI Milwaukee   school 5500066 8127 Non District Charter Schools Milwaukee Collegiate Academy 550006602865 400 Milwaukee Collegiate Academy charter Regular School Yes High 09 12 2019   grade_9                                                   110                                             110
3097190 3097190 WI Milwaukee   school 5500066 8127 Non District Charter Schools Milwaukee Collegiate Academy 550006602865 400 Milwaukee Collegiate Academy charter Regular School Yes High 09 12 2018   grade_9                                                   82                                             82
114673 114673 WI Milwaukee   school 5500069 8131 Non District Charter Schools Escuela Verde 550006902920 400 Escuela Verde charter Regular School Yes 3.0 07 12 2015   grade_9                                                   26                                             26
284670 284670 WI Milwaukee   school 5500069 8131 Non District Charter Schools Escuela Verde 550006902920 400 Escuela Verde charter Regular School Yes 3.0 07 12 2016   grade_9                                                   53                                             53
328559 328559 WI Milwaukee   school 5500069 8131 Non District Charter Schools Escuela Verde 550006902920 400 Escuela Verde charter Regular School Yes High 07 12 2017   grade_9                                                   20                                             20
2321117 2321117 WI Milwaukee   school 5500069 8131 Non District Charter Schools Escuela Verde 550006902920 400 Escuela Verde charter Regular School Yes High 09 12 2020   grade_9                                                   41                                             41
2335945 2335945 WI Milwaukee   school 5500069 8131 Non District Charter Schools Escuela Verde 550006902920 400 Escuela Verde charter Regular School Yes High 09 12 2021   grade_9                                                   27                                             27
3076877 3076877 WI Milwaukee   school 5500069 8131 Non District Charter Schools Escuela Verde 550006902920 400 Escuela Verde charter Regular School Yes High 09 12 2019   grade_9                                                   28                                             28
3091625 3091625 WI Milwaukee   school 5500069 8131 Non District Charter Schools Escuela Verde 550006902920 400 Escuela Verde charter Regular School Yes High 07 12 2018   grade_9                                                   33                                             33
337097 337097 WI Milwaukee   school 5500074 8001 Non District Charter Schools Seeds of Health Inc 550007402496 8124 Veritas High charter Regular School Yes High 09 12 2017   grade_9                                                   52                                             52
2329695 2329695 WI Milwaukee   school 5500074 8001 Non District Charter Schools Seeds of Health Inc 550007402496 8124 Veritas High charter Regular School Yes High 09 12 2020   grade_9                                                   56                                             56
2344595 2344595 WI Milwaukee   school 5500074 8001 Non District Charter Schools Seeds of Health Inc 550007402496 8124 Veritas High charter Regular School Yes High 09 12 2021   grade_9                                                   53                                             53
3085424 3085424 WI Milwaukee   school 5500074 8001 Non District Charter Schools Seeds of Health Inc 550007402496 8124 Veritas High charter Regular School Yes High 09 12 2019   grade_9                                                   79                                             79
3100156 3100156 WI Milwaukee   school 5500074 8001 Non District Charter Schools Seeds of Health Inc 550007402496 8124 Veritas High charter Regular School Yes High 09 12 2018   grade_9                                                   76                                             76
337092 337092 WI Milwaukee   school 5500074 8001 Non District Charter Schools Seeds of Health Inc 550007402637 8115 Tenor High School charter Regular School Yes High 09 12 2017   grade_9                                                   56                                             56
2329690 2329690 WI Milwaukee   school 5500074 8001 Non District Charter Schools Seeds of Health Inc 550007402637 8115 Tenor High charter Regular School Yes High 09 12 2020   grade_9                                                   59                                             59
2344590 2344590 WI Milwaukee   school 5500074 8001 Non District Charter Schools Seeds of Health Inc 550007402637 8115 Tenor High charter Regular School Yes High 09 12 2021   grade_9                                                   162                                             162
3085419 3085419 WI Milwaukee   school 5500074 8001 Non District Charter Schools Seeds of Health Inc 550007402637 8115 Tenor High charter Regular School Yes High 09 12 2019   grade_9                                                   75                                             75
3100151 3100151 WI Milwaukee   school 5500074 8001 Non District Charter Schools Seeds of Health Inc 550007402637 8115 Tenor High charter Regular School Yes High 09 12 2018   grade_9                                                   55                                             55
2328305 2328305 WI Milwaukee   school 5500079 8139 Non District Charter Schools Pathways High 550007903064 8139 Pathways High charter Regular School Yes High 09 12 2020   grade_9                                                   24                                             24
2343194 2343194 WI Milwaukee   school 5500079 8139 Non District Charter Schools Pathways High 550007903064 8139 Pathways High charter Regular School Yes High 09 12 2021   grade_9                                                   25                                             25
3084056 3084056 WI Milwaukee   school 5500079 8139 Non District Charter Schools Pathways High 550007903064 8139 Pathways High charter Regular School Yes High 09 12 2019   grade_9                                                   23                                             23
3098755 3098755 WI Milwaukee   school 5500079 8139 Non District Charter Schools Pathways High 550007903064 8139 Pathways High charter Regular School Yes High 09 12 2018   grade_9                                                   43                                             43

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