enrollments

Data source: Big Local News · About: Big Local

14,617 rows where state = "WI" and year = 2016 sorted by county

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 14,617 ✖
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
281731 281731 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2016   pk_12_total 397.0 9.0 41.0 5.0   1.0       1.0 5.0   234.0 225.0             329     77   459 397 9 41 5   1       1 5   234 225         329   77   459
281732 281732 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   50                                             50
281733 281733 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   75                                             75
281734 281734 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2016   grade_3                                                   72                                             72
281735 281735 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   67                                             67
281736 281736 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2016   grade_5                                                   78                                             78
281737 281737 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2016   kindergarten_4_year_old                                                   53                                             53
281738 281738 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2016   kindergarten                                                   63                                             63
281739 281739 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
281740 281740 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No 3.0 09 12 2016   pk_12_total 444.0 5.0 31.0 5.0   1.0       1.0 2.0   239.0 250.0             335     94   489 444 5 31 5   1       1 2   239 250         335   94   489
281741 281741 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No 3.0 09 12 2016   grade_10                                                   107                                             107
281742 281742 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No 3.0 09 12 2016   grade_11                                                   130                                             130
281743 281743 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No 3.0 09 12 2016   grade_12                                                   117                                             117
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
281745 281745 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No 2.0 06 08 2016   pk_12_total 325.0 7.0 15.0 4.0           1.0 2.0   180.0 174.0             247     61   354 325 7 15 4           1 2   180 174         247   61   354
281746 281746 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No 2.0 06 08 2016   grade_6                                                   128                                             128
281747 281747 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No 2.0 06 08 2016   grade_7                                                   110                                             110
281748 281748 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No 2.0 06 08 2016   grade_8                                                   116                                             116
281749 281749 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No 1.0 PK 05 2016   pk_12_total 132.0 5.0 13.0 1.0             2.0   95.0 58.0             121     33   153 132 5 13 1             2   95 58         121   33   153
281750 281750 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   22                                             22
281751 281751 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   26                                             26
281752 281752 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No 1.0 PK 05 2016   grade_3                                                   20                                             20
281753 281753 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   21                                             21
281754 281754 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No 1.0 PK 05 2016   grade_5                                                   14                                             14
281755 281755 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No 1.0 PK 05 2016   kindergarten_4_year_old                                                   20                                             20
281756 281756 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No 1.0 PK 05 2016   kindergarten                                                   30                                             30
281757 281757 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No 1.0 PK 05 2016   pk_12_total 111.0   1.0 1.0                 54.0 59.0             78     19   113 111   1 1                 54 59         78   19   113
281758 281758 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   20                                             20
281759 281759 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   23                                             23
281760 281760 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No 1.0 PK 05 2016   grade_3                                                   16                                             16
281761 281761 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   16                                             16
281762 281762 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No 1.0 PK 05 2016   grade_5                                                   11                                             11
281763 281763 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No 1.0 PK 05 2016   kindergarten_4_year_old                                                   7                                             7
281764 281764 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No 1.0 PK 05 2016   kindergarten                                                   20                                             20
282259 282259 WI Ashland   school 5500510 170 Public school Ashland 550051003017 400 Ashland Charter High School charter Regular School Yes 3.0 09 12 2016   pk_12_total 37.0     5.0             1.0   21.0 22.0             20     8   43 37     5             1   21 22         20   8   43
282260 282260 WI Ashland   school 5500510 170 Public school Ashland 550051003017 400 Ashland Charter High School charter Regular School Yes 3.0 09 12 2016   grade_10                                                   15                                             15
282261 282261 WI Ashland   school 5500510 170 Public school Ashland 550051003017 400 Ashland Charter High School charter Regular School Yes 3.0 09 12 2016   grade_11                                                   15                                             15
282262 282262 WI Ashland   school 5500510 170 Public school Ashland 550051003017 400 Ashland Charter High School charter Regular School Yes 3.0 09 12 2016   grade_12                                                   8                                             8
282263 282263 WI Ashland   school 5500510 170 Public school Ashland 550051003017 400 Ashland Charter High School charter Regular School Yes 3.0 09 12 2016   grade_9                                                   5                                             5
282264 282264 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Ashland Elementary Charter School charter Regular School Yes 1.0 03 05 2016   pk_12_total 60.0     5.0             4.0   31.0 38.0             38     7   69 60     5             4   31 38         38   7   69
282265 282265 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Ashland Elementary Charter School charter Regular School Yes 1.0 03 05 2016   grade_3                                                   23                                             23
282266 282266 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Ashland Elementary Charter School charter Regular School Yes 1.0 03 05 2016   grade_4                                                   24                                             24
282267 282267 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Ashland Elementary Charter School charter Regular School Yes 1.0 03 05 2016   grade_5                                                   22                                             22
282268 282268 WI Ashland   school 5500510 170 Public school Ashland 550051000073 20 Ashland High   Regular School No 3.0 09 12 2016   pk_12_total 464.0 4.0 12.0 121.0   3.0         26.0   342.0 288.0             320     103   630 464 4 12 121   3         26   342 288         320   103   630
282269 282269 WI Ashland   school 5500510 170 Public school Ashland 550051000073 20 Ashland High   Regular School No 3.0 09 12 2016   grade_10                                                   162                                             162
282270 282270 WI Ashland   school 5500510 170 Public school Ashland 550051000073 20 Ashland High   Regular School No 3.0 09 12 2016   grade_11                                                   147                                             147
282271 282271 WI Ashland   school 5500510 170 Public school Ashland 550051000073 20 Ashland High   Regular School No 3.0 09 12 2016   grade_12                                                   165                                             165
282272 282272 WI Ashland   school 5500510 170 Public school Ashland 550051000073 20 Ashland High   Regular School No 3.0 09 12 2016   grade_9                                                   156                                             156
282273 282273 WI Ashland   school 5500510 170 Public school Ashland 550051000074 30 Ashland Middle   Regular School No 2.0 06 08 2016   pk_12_total 274.0 4.0 12.0 95.0   1.0         27.0   211.0 202.0             261     55   413 274 4 12 95   1         27   211 202         261   55   413
282274 282274 WI Ashland   school 5500510 170 Public school Ashland 550051000074 30 Ashland Middle   Regular School No 2.0 06 08 2016   grade_6                                                   128                                             128
282275 282275 WI Ashland   school 5500510 170 Public school Ashland 550051000074 30 Ashland Middle   Regular School No 2.0 06 08 2016   grade_7                                                   146                                             146
282276 282276 WI Ashland   school 5500510 170 Public school Ashland 550051000074 30 Ashland Middle   Regular School No 2.0 06 08 2016   grade_8                                                   139                                             139
282277 282277 WI Ashland   school 5500510 170 Public school Ashland 550051000076 60 Lake Superior Intermediate   Regular School No 1.0 03 05 2016   pk_12_total 185.0 6.0 3.0 101.0   2.0         18.0   161.0 154.0             206     58   315 185 6 3 101   2         18   161 154         206   58   315
282278 282278 WI Ashland   school 5500510 170 Public school Ashland 550051000076 60 Lake Superior Intermediate   Regular School No 1.0 03 05 2016   grade_3                                                   114                                             114
282279 282279 WI Ashland   school 5500510 170 Public school Ashland 550051000076 60 Lake Superior Intermediate   Regular School No 1.0 03 05 2016   grade_4                                                   103                                             103
282280 282280 WI Ashland   school 5500510 170 Public school Ashland 550051000076 60 Lake Superior Intermediate   Regular School No 1.0 03 05 2016   grade_5                                                   98                                             98
282281 282281 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No 1.0 PK 02 2016   pk_12_total 263.0 2.0 5.0 109.0           1.0 22.0   200.0 202.0             261     90   402 263 2 5 109           1 22   200 202         261   90   402
282282 282282 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No 1.0 PK 02 2016   grade_1                                                   127                                             127
282283 282283 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No 1.0 PK 02 2016   grade_2                                                   141                                             141
282284 282284 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No 1.0 PK 02 2016   kindergarten                                                   107                                             107
282285 282285 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No 1.0 PK 02 2016   pre_kindergarten                                                   27                                             27
282286 282286 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No 1.0 PK 05 2016   pk_12_total 188.0                   1.0   104.0 85.0             145     14   189 188                   1   104 85         145   14   189
282287 282287 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   35                                             35
282288 282288 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   35                                             35
282289 282289 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No 1.0 PK 05 2016   grade_3                                                   34                                             34
282290 282290 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   25                                             25
282291 282291 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No 1.0 PK 05 2016   grade_5                                                   31                                             31
282292 282292 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No 1.0 PK 05 2016   kindergarten                                                   27                                             27
282293 282293 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   2                                             2
282294 282294 WI Ashland   school 5500510 170 Public school Ashland 550051002986 250 Oredocker Project School charter Regular School Yes 2.0 06 08 2016   pk_12_total 52.0   1.0 10.0   1.0         2.0   38.0 28.0             42     8   66 52   1 10   1         2   38 28         42   8   66
282295 282295 WI Ashland   school 5500510 170 Public school Ashland 550051002986 250 Oredocker Project School charter Regular School Yes 2.0 06 08 2016   grade_6                                                   20                                             20
282296 282296 WI Ashland   school 5500510 170 Public school Ashland 550051002986 250 Oredocker Project School charter Regular School Yes 2.0 06 08 2016   grade_7                                                   20                                             20
282297 282297 WI Ashland   school 5500510 170 Public school Ashland 550051002986 250 Oredocker Project School charter Regular School Yes 2.0 06 08 2016   grade_8                                                   26                                             26
283159 283159 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No 1.0 PK 05 2016   pk_12_total 91.0     2.0                 41.0 52.0             66     21   93 91     2                 41 52         66   21   93
283160 283160 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   10                                             10
283161 283161 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   14                                             14
283162 283162 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No 1.0 PK 05 2016   grade_3                                                   15                                             15
283163 283163 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   13                                             13
283164 283164 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No 1.0 PK 05 2016   grade_5                                                   14                                             14
283165 283165 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No 1.0 PK 05 2016   kindergarten_4_year_old                                                   12                                             12
283166 283166 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No 1.0 PK 05 2016   kindergarten                                                   14                                             14
283167 283167 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
283168 283168 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No 4.0 06 12 2016   pk_12_total 103.0   1.0               1.0   57.0 48.0             68     22   105 103   1               1   57 48         68   22   105
283169 283169 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No 4.0 06 12 2016   grade_10                                                   13                                             13
283170 283170 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No 4.0 06 12 2016   grade_11                                                   19                                             19
283171 283171 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No 4.0 06 12 2016   grade_12                                                   12                                             12
283172 283172 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No 4.0 06 12 2016   grade_6                                                   16                                             16
283173 283173 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No 4.0 06 12 2016   grade_7                                                   13                                             13
283174 283174 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No 4.0 06 12 2016   grade_8                                                   13                                             13
283175 283175 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No 4.0 06 12 2016   grade_9                                                   19                                             19
283176 283176 WI Ashland   school 5501920 840 Public school Butternut 550192002751 450 Promethean Charter School charter Regular School Yes 3.0 09 12 2016   pk_12_total 1.0                       1.0               *     *   1 1                       1                   1
283177 283177 WI Ashland   school 5501920 840 Public school Butternut 550192002751 450 Promethean Charter School charter Regular School Yes 3.0 09 12 2016   grade_12                                                   1                                             1
288354 288354 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No 4.0 PK 12 2016   pk_12_total 248.0 6.0 5.0 8.0   4.0         1.0   149.0 123.0             144     40   272 248 6 5 8   4         1   149 123         144   40   272
288355 288355 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No 4.0 PK 12 2016   grade_1                                                   29                                             29
288356 288356 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No 4.0 PK 12 2016   grade_10                                                   23                                             23
288357 288357 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No 4.0 PK 12 2016   grade_11                                                   15                                             15
288358 288358 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No 4.0 PK 12 2016   grade_12                                                   19                                             19
288359 288359 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No 4.0 PK 12 2016   grade_2                                                   19                                             19
288360 288360 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No 4.0 PK 12 2016   grade_3                                                   18                                             18
288361 288361 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No 4.0 PK 12 2016   grade_4                                                   17                                             17

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