enrollments

Data source: Big Local News · About: Big Local

14,806 rows where state = "WI" and year = 2020

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 14,806 ✖
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
2318120 2318120 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2020   pk_12_total 47.0 288.0 176.0               40.0   262.0 289.0             467     59   551 47 288 176               40   262 289         467   59   551
2318121 2318121 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2020   grade_1                                                   47                                             47
2318122 2318122 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2020   grade_2                                                   55                                             55
2318123 2318123 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2020   grade_3                                                   57                                             57
2318124 2318124 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2020   grade_4                                                   57                                             57
2318125 2318125 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2020   grade_5                                                   59                                             59
2318126 2318126 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2020   grade_6                                                   58                                             58
2318127 2318127 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2020   grade_7                                                   59                                             59
2318128 2318128 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2020   grade_8                                                   60                                             60
2318129 2318129 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2020   kindergarten_4_year_old                                                   39                                             39
2318130 2318130 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2020   kindergarten                                                   60                                             60
2318131 2318131 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2020   pk_12_total 139.0 3.0 217.0     1.0         3.0   195.0 168.0             285     51   363 139 3 217     1         3   195 168         285   51   363
2318132 2318132 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   55                                             55
2318133 2318133 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   58                                             58
2318134 2318134 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2020   grade_3                                                   55                                             55
2318135 2318135 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   50                                             50
2318136 2318136 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2020   grade_5                                                   58                                             58
2318137 2318137 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2020   kindergarten_4_year_old                                                   46                                             46
2318138 2318138 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2020   kindergarten                                                   40                                             40
2318139 2318139 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2318140 2318140 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2020   pk_12_total 186.0 4.0 189.0     1.0         2.0   194.0 188.0             246     49   382 186 4 189     1         2   194 188         246   49   382
2318141 2318141 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2020   grade_10                                                   49                                             49
2318142 2318142 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2020   grade_11                                                   50                                             50
2318143 2318143 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2020   grade_12                                                   44                                             44
2318144 2318144 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2020   grade_6                                                   54                                             54
2318145 2318145 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2020   grade_7                                                   67                                             67
2318146 2318146 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2020   grade_8                                                   59                                             59
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
2318148 2318148 WI Clark   school   7 Public Schools-Multidistrict Charters Abbotsford   9100 Rural Virtual Academy charter           2020   pk_12_total 2.0                       1.0 1.0             *     *   2 2                       1 1                 2
2318149 2318149 WI Clark   school   7 Public Schools-Multidistrict Charters Abbotsford   9100 Rural Virtual Academy charter           2020   grade_8                                                   1                                             1
2318150 2318150 WI Clark   school   7 Public Schools-Multidistrict Charters Abbotsford   9100 Rural Virtual Academy charter           2020   kindergarten_4_year_old                                                   1                                             1
2318151 2318151 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 04 2020   pk_12_total 392.0 9.0 39.0 2.0   3.0         21.0   229.0 237.0             262     132   466 392 9 39 2   3         21   229 237         262   132   466
2318152 2318152 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 04 2020   grade_1                                                   75                                             75
2318153 2318153 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 04 2020   grade_2                                                   74                                             74
2318154 2318154 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 04 2020   grade_3                                                   66                                             66
2318155 2318155 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   91                                             91
2318156 2318156 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 04 2020   grade_8                                                   1                                             1
2318157 2318157 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 04 2020   kindergarten_4_year_old                                                   79                                             79
2318158 2318158 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 04 2020   kindergarten                                                   67                                             67
2318159 2318159 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   13                                             13
2318160 2318160 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No High 09 12 2020   pk_12_total 410.0 4.0 27.0 4.0             18.0   243.0 220.0             298     121   463 410 4 27 4             18   243 220         298   121   463
2318161 2318161 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No High 09 12 2020   grade_10                                                   130                                             130
2318162 2318162 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No High 09 12 2020   grade_11                                                   108                                             108
2318163 2318163 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No High 09 12 2020   grade_12                                                   110                                             110
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
2318165 2318165 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No Middle 05 08 2020   pk_12_total 365.0 8.0 44.0     1.0         19.0   223.0 214.0             290     108   437 365 8 44     1         19   223 214         290   108   437
2318166 2318166 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No Middle 05 08 2020   grade_5                                                   103                                             103
2318167 2318167 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No Middle 05 08 2020   grade_6                                                   125                                             125
2318168 2318168 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No Middle 05 08 2020   grade_7                                                   112                                             112
2318169 2318169 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No Middle 05 08 2020   grade_8                                                   97                                             97
2318170 2318170 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 04 2020   pk_12_total 54.0 2.0 7.0               6.0   43.0 26.0             50     7   69 54 2 7               6   43 26         50   7   69
2318171 2318171 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 04 2020   grade_1                                                   17                                             17
2318172 2318172 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 04 2020   grade_2                                                   16                                             16
2318173 2318173 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 04 2020   grade_3                                                   11                                             11
2318174 2318174 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   13                                             13
2318175 2318175 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 04 2020   kindergarten                                                   12                                             12
2318176 2318176 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle   Regular School No Middle 05 08 2020   pk_12_total 79.0 3.0 4.0               5.0   52.0 39.0             36     15   91 79 3 4               5   52 39         36   15   91
2318177 2318177 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle   Regular School No Middle 05 08 2020   grade_5                                                   17                                             17
2318178 2318178 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle   Regular School No Middle 05 08 2020   grade_6                                                   22                                             22
2318179 2318179 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle   Regular School No Middle 05 08 2020   grade_7                                                   25                                             25
2318180 2318180 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle   Regular School No Middle 05 08 2020   grade_8                                                   27                                             27
2318181 2318181 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 04 2020   pk_12_total 138.0   12.0               5.0   78.0 77.0             75     21   155 138   12               5   78 77         75   21   155
2318182 2318182 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 04 2020   grade_1                                                   25                                             25
2318183 2318183 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 04 2020   grade_2                                                   34                                             34
2318184 2318184 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 04 2020   grade_3                                                   18                                             18
2318185 2318185 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   24                                             24
2318186 2318186 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 04 2020   kindergarten_4_year_old                                                   20                                             20
2318187 2318187 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 04 2020   kindergarten                                                   34                                             34
2318188 2318188 WI Green   school 5500120 63 Public school Albany 550012000014 40 Albany High   Regular School No High 09 12 2020   pk_12_total 84.0 1.0 3.0     1.0         3.0   41.0 51.0             37     14   92 84 1 3     1         3   41 51         37   14   92
2318189 2318189 WI Green   school 5500120 63 Public school Albany 550012000014 40 Albany High   Regular School No High 09 12 2020   grade_10                                                   28                                             28
2318190 2318190 WI Green   school 5500120 63 Public school Albany 550012000014 40 Albany High   Regular School No High 09 12 2020   grade_11                                                   26                                             26
2318191 2318191 WI Green   school 5500120 63 Public school Albany 550012000014 40 Albany High   Regular School No High 09 12 2020   grade_12                                                   18                                             18
2318192 2318192 WI Green   school 5500120 63 Public school Albany 550012000014 40 Albany High   Regular School No High 09 12 2020   grade_9                                                   20                                             20
2318193 2318193 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No Elementary PK 06 2020   pk_12_total 333.0 6.0 26.0 1.0   3.0         12.0   217.0 164.0             200     69   381 333 6 26 1   3         12   217 164         200   69   381
2318194 2318194 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No Elementary PK 06 2020   grade_1                                                   46                                             46
2318195 2318195 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No Elementary PK 06 2020   grade_2                                                   45                                             45
2318196 2318196 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No Elementary PK 06 2020   grade_3                                                   47                                             47
2318197 2318197 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No Elementary PK 06 2020   grade_4                                                   59                                             59
2318198 2318198 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No Elementary PK 06 2020   grade_5                                                   48                                             48
2318199 2318199 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No Elementary PK 06 2020   grade_6                                                   57                                             57
2318200 2318200 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No Elementary PK 06 2020   kindergarten_4_year_old                                                   38                                             38
2318201 2318201 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No Elementary PK 06 2020   kindergarten                                                   37                                             37
2318202 2318202 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   4                                             4
2318203 2318203 WI Kewaunee   school 5500150 70 Public school Algoma 550015000016 40 Algoma High   Regular School No High 07 12 2020   pk_12_total 283.0 5.0 26.0 2.0             7.0   155.0 168.0             142     47   323 283 5 26 2             7   155 168         142   47   323
2318204 2318204 WI Kewaunee   school 5500150 70 Public school Algoma 550015000016 40 Algoma High   Regular School No High 07 12 2020   grade_10                                                   53                                             53
2318205 2318205 WI Kewaunee   school 5500150 70 Public school Algoma 550015000016 40 Algoma High   Regular School No High 07 12 2020   grade_11                                                   43                                             43
2318206 2318206 WI Kewaunee   school 5500150 70 Public school Algoma 550015000016 40 Algoma High   Regular School No High 07 12 2020   grade_12                                                   61                                             61
2318207 2318207 WI Kewaunee   school 5500150 70 Public school Algoma 550015000016 40 Algoma High   Regular School No High 07 12 2020   grade_7                                                   54                                             54
2318208 2318208 WI Kewaunee   school 5500150 70 Public school Algoma 550015000016 40 Algoma High   Regular School No High 07 12 2020   grade_8                                                   52                                             52
2318209 2318209 WI Kewaunee   school 5500150 70 Public school Algoma 550015000016 40 Algoma High   Regular School No High 07 12 2020   grade_9                                                   60                                             60
2318210 2318210 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2020   pk_12_total 151.0   10.0               1.0   81.0 81.0             64     30   162 151   10               1   81 81         64   30   162
2318211 2318211 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2020   grade_1                                                   16                                             16
2318212 2318212 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2020   grade_2                                                   16                                             16
2318213 2318213 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2020   grade_3                                                   15                                             15
2318214 2318214 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2020   grade_4                                                   14                                             14
2318215 2318215 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2020   grade_5                                                   23                                             23
2318216 2318216 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2020   grade_6                                                   18                                             18
2318217 2318217 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2020   grade_7                                                   19                                             19
2318218 2318218 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   12                                             12
2318219 2318219 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2020   kindergarten_4_year_old                                                   11                                             11

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