enrollments

Data source: Big Local News · About: Big Local

14,702 rows where state = "WI" and year = 2018 sorted by county

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 14,702 ✖
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
3088669 3088669 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2018   pk_12_total 380.0 12.0 45.0 1.0   2.0         5.0   218.0 227.0             251     98   445 380 12 45 1   2         5   218 227         251   98   445
3088670 3088670 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   46                                             46
3088671 3088671 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   63                                             63
3088672 3088672 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   56                                             56
3088673 3088673 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   74                                             74
3088674 3088674 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   79                                             79
3088675 3088675 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   60                                             60
3088676 3088676 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   53                                             53
3088677 3088677 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   14                                             14
3088678 3088678 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No High 09 12 2018   pk_12_total 422.0 8.0 24.0 5.0   1.0         5.0   247.0 218.0             325     99   465 422 8 24 5   1         5   247 218         325   99   465
3088679 3088679 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No High 09 12 2018   grade_10                                                   116                                             116
3088680 3088680 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No High 09 12 2018   grade_11                                                   135                                             135
3088681 3088681 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No High 09 12 2018   grade_12                                                   101                                             101
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
3088683 3088683 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No Middle 06 08 2018   pk_12_total 297.0 3.0 23.0 4.0           2.0 2.0   170.0 161.0             208     69   331 297 3 23 4           2 2   170 161         208   69   331
3088684 3088684 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No Middle 06 08 2018   grade_6                                                   102                                             102
3088685 3088685 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No Middle 06 08 2018   grade_7                                                   106                                             106
3088686 3088686 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No Middle 06 08 2018   grade_8                                                   123                                             123
3088687 3088687 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 05 2018   pk_12_total 123.0 5.0 18.0 2.0   1.0         6.0   92.0 63.0             96     36   155 123 5 18 2   1         6   92 63         96   36   155
3088688 3088688 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   18                                             18
3088689 3088689 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   24                                             24
3088690 3088690 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   24                                             24
3088691 3088691 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   24                                             24
3088692 3088692 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   20                                             20
3088693 3088693 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   19                                             19
3088694 3088694 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   26                                             26
3088695 3088695 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No Elementary PK 05 2018   pk_12_total 132.0   5.0 1.0                 61.0 77.0             76     27   138 132   5 1                 61 77         76   27   138
3088696 3088696 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   14                                             14
3088697 3088697 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   26                                             26
3088698 3088698 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   21                                             21
3088699 3088699 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   31                                             31
3088700 3088700 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   19                                             19
3088701 3088701 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   12                                             12
3088702 3088702 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   15                                             15
3089193 3089193 WI Ashland   school 5500510 170 Public school Ashland 550051000073 20 Ashland High   Regular School No High 09 12 2018   pk_12_total 476.0 4.0 12.0 128.0   4.0         36.0   367.0 293.0             332     104   660 476 4 12 128   4         36   367 293         332   104   660
3089194 3089194 WI Ashland   school 5500510 170 Public school Ashland 550051000073 20 Ashland High   Regular School No High 09 12 2018   grade_10                                                   161                                             161
3089195 3089195 WI Ashland   school 5500510 170 Public school Ashland 550051000073 20 Ashland High   Regular School No High 09 12 2018   grade_11                                                   149                                             149
3089196 3089196 WI Ashland   school 5500510 170 Public school Ashland 550051000073 20 Ashland High   Regular School No High 09 12 2018   grade_12                                                   185                                             185
3089197 3089197 WI Ashland   school 5500510 170 Public school Ashland 550051000073 20 Ashland High   Regular School No High 09 12 2018   grade_9                                                   165                                             165
3089198 3089198 WI Ashland   school 5500510 170 Public school Ashland 550051000074 30 Ashland Middle   Regular School No Middle 06 08 2018   pk_12_total 274.0 3.0 5.0 93.0   1.0         26.0   205.0 197.0             249     50   402 274 3 5 93   1         26   205 197         249   50   402
3089199 3089199 WI Ashland   school 5500510 170 Public school Ashland 550051000074 30 Ashland Middle   Regular School No Middle 06 08 2018   grade_6                                                   147                                             147
3089200 3089200 WI Ashland   school 5500510 170 Public school Ashland 550051000074 30 Ashland Middle   Regular School No Middle 06 08 2018   grade_7                                                   128                                             128
3089201 3089201 WI Ashland   school 5500510 170 Public school Ashland 550051000074 30 Ashland Middle   Regular School No Middle 06 08 2018   grade_8                                                   127                                             127
3089202 3089202 WI Ashland   school 5500510 170 Public school Ashland 550051003017 400 Lake Superior High charter Regular School Yes High 09 12 2018   pk_12_total 11.0     3.0                 6.0 8.0             7     1   14 11     3                 6 8         7   1   14
3089203 3089203 WI Ashland   school 5500510 170 Public school Ashland 550051003017 400 Lake Superior High charter Regular School Yes High 09 12 2018   grade_10                                                   8                                             8
3089204 3089204 WI Ashland   school 5500510 170 Public school Ashland 550051003017 400 Lake Superior High charter Regular School Yes High 09 12 2018   grade_11                                                   1                                             1
3089205 3089205 WI Ashland   school 5500510 170 Public school Ashland 550051003017 400 Lake Superior High charter Regular School Yes High 09 12 2018   grade_12                                                   2                                             2
3089206 3089206 WI Ashland   school 5500510 170 Public school Ashland 550051003017 400 Lake Superior High charter Regular School Yes High 09 12 2018   grade_9                                                   3                                             3
3089207 3089207 WI Ashland   school 5500510 170 Public school Ashland 550051000076 60 Lake Superior Intermediate   Regular School No Elementary 03 05 2018   pk_12_total 190.0 1.0 6.0 95.0   1.0         26.0   140.0 179.0             211     53   319 190 1 6 95   1         26   140 179         211   53   319
3089208 3089208 WI Ashland   school 5500510 170 Public school Ashland 550051000076 60 Lake Superior Intermediate   Regular School No Elementary 03 05 2018   grade_3                                                   111                                             111
3089209 3089209 WI Ashland   school 5500510 170 Public school Ashland 550051000076 60 Lake Superior Intermediate   Regular School No Elementary 03 05 2018   grade_4                                                   113                                             113
3089210 3089210 WI Ashland   school 5500510 170 Public school Ashland 550051000076 60 Lake Superior Intermediate   Regular School No Elementary 03 05 2018   grade_5                                                   95                                             95
3089211 3089211 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Lake Superior Learning Community charter Regular School Yes Elementary 03 05 2018   pk_12_total 49.0   2.0 9.0   1.0         3.0   31.0 33.0             34     8   64 49   2 9   1         3   31 33         34   8   64
3089212 3089212 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Lake Superior Learning Community charter Regular School Yes Elementary 03 05 2018   grade_3                                                   15                                             15
3089213 3089213 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Lake Superior Learning Community charter Regular School Yes Elementary 03 05 2018   grade_4                                                   24                                             24
3089214 3089214 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Lake Superior Learning Community charter Regular School Yes Elementary 03 05 2018   grade_5                                                   25                                             25
3089215 3089215 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No Elementary PK 02 2018   pk_12_total 292.0   6.0 89.0             38.0   246.0 179.0             251     85   425 292   6 89             38   246 179         251   85   425
3089216 3089216 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No Elementary PK 02 2018   grade_1                                                   103                                             103
3089217 3089217 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No Elementary PK 02 2018   grade_2                                                   107                                             107
3089218 3089218 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No Elementary PK 02 2018   kindergarten_4_year_old                                                   83                                             83
3089219 3089219 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No Elementary PK 02 2018   kindergarten                                                   118                                             118
3089220 3089220 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No Elementary PK 02 2018   pre_kindergarten                                                   14                                             14
3089221 3089221 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No Elementary PK 05 2018   pk_12_total 178.0     1.0                 97.0 82.0             142     6   179 178     1                 97 82         142   6   179
3089222 3089222 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   25                                             25
3089223 3089223 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   27                                             27
3089224 3089224 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   34                                             34
3089225 3089225 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   34                                             34
3089226 3089226 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   33                                             33
3089227 3089227 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   26                                             26
3089228 3089228 WI Ashland   school 5500510 170 Public school Ashland 550051002986 250 Oredocker Project School charter Regular School Yes Middle 06 08 2018   pk_12_total 33.0   1.0 10.0             3.0   29.0 18.0             33     14   47 33   1 10             3   29 18         33   14   47
3089229 3089229 WI Ashland   school 5500510 170 Public school Ashland 550051002986 250 Oredocker Project School charter Regular School Yes Middle 06 08 2018   grade_6                                                   11                                             11
3089230 3089230 WI Ashland   school 5500510 170 Public school Ashland 550051002986 250 Oredocker Project School charter Regular School Yes Middle 06 08 2018   grade_7                                                   20                                             20
3089231 3089231 WI Ashland   school 5500510 170 Public school Ashland 550051002986 250 Oredocker Project School charter Regular School Yes Middle 06 08 2018   grade_8                                                   16                                             16
3090110 3090110 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2018   pk_12_total 88.0     1.0                 37.0 52.0             46     19   89 88     1                 37 52         46   19   89
3090111 3090111 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   10                                             10
3090112 3090112 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   11                                             11
3090113 3090113 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   8                                             8
3090114 3090114 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   17                                             17
3090115 3090115 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   10                                             10
3090116 3090116 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   6                                             6
3090117 3090117 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   13                                             13
3090118 3090118 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   14                                             14
3090119 3090119 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No High 06 12 2018   pk_12_total 94.0     1.0                 51.0 44.0             45     28   95 94     1                 51 44         45   28   95
3090120 3090120 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No High 06 12 2018   grade_10                                                   10                                             10
3090121 3090121 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No High 06 12 2018   grade_11                                                   19                                             19
3090122 3090122 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No High 06 12 2018   grade_12                                                   11                                             11
3090123 3090123 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No High 06 12 2018   grade_6                                                   13                                             13
3090124 3090124 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No High 06 12 2018   grade_7                                                   13                                             13
3090125 3090125 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No High 06 12 2018   grade_8                                                   14                                             14
3090126 3090126 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No High 06 12 2018   grade_9                                                   15                                             15
3090127 3090127 WI Ashland   school 5501920 840 Public school Butternut 550192002751 450 Promethean Charter School charter Regular School Yes High 09 12 2018   pk_12_total 1.0         1.0             2.0               *     *   2 1         1             2                   2
3090128 3090128 WI Ashland   school 5501920 840 Public school Butternut 550192002751 450 Promethean Charter School charter Regular School Yes High 09 12 2018   grade_10                                                   1                                             1
3090129 3090129 WI Ashland   school 5501920 840 Public school Butternut 550192002751 450 Promethean Charter School charter Regular School Yes High 09 12 2018   grade_12                                                   1                                             1
3095308 3095308 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2018   pk_12_total 266.0 10.0 4.0 14.0   3.0         1.0   160.0 138.0             182     63   298 266 10 4 14   3         1   160 138         182   63   298
3095309 3095309 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2018   grade_1                                                   20                                             20
3095310 3095310 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2018   grade_10                                                   24                                             24
3095311 3095311 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2018   grade_11                                                   18                                             18
3095312 3095312 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2018   grade_12                                                   24                                             24
3095313 3095313 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2018   grade_2                                                   15                                             15
3095314 3095314 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2018   grade_3                                                   29                                             29

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