enrollments

Data source: Big Local News · About: Big Local

14,664 rows where state = "WI" and year = 2017 sorted by county

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 14,664 ✖
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
325627 325627 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2017   pk_12_total 367.0 12.0 49.0 3.0   1.0         5.0   206.0 231.0             301     82   437 367 12 49 3   1         5   206 231         301   82   437
325628 325628 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2017   grade_1                                                   63                                             63
325629 325629 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   53                                             53
325630 325630 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2017   grade_3                                                   76                                             76
325631 325631 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   81                                             81
325632 325632 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   62                                             62
325633 325633 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2017   kindergarten_4_year_old                                                   39                                             39
325634 325634 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2017   kindergarten                                                   51                                             51
325635 325635 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   12                                             12
325636 325636 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No High 09 12 2017   pk_12_total 445.0 5.0 29.0 6.0   1.0         3.0   249.0 240.0             316     96   489 445 5 29 6   1         3   249 240         316   96   489
325637 325637 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No High 09 12 2017   grade_10                                                   139                                             139
325638 325638 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No High 09 12 2017   grade_11                                                   103                                             103
325639 325639 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No High 09 12 2017   grade_12                                                   133                                             133
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
325641 325641 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No Middle 06 08 2017   pk_12_total 309.0 4.0 14.0 3.0           1.0 2.0   169.0 164.0             218     66   333 309 4 14 3           1 2   169 164         218   66   333
325642 325642 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No Middle 06 08 2017   grade_4                                                   1                                             1
325643 325643 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No Middle 06 08 2017   grade_6                                                   102                                             102
325644 325644 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No Middle 06 08 2017   grade_7                                                   123                                             123
325645 325645 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No Middle 06 08 2017   grade_8                                                   107                                             107
325646 325646 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 05 2017   pk_12_total 129.0 5.0 23.0 1.0             3.0   100.0 61.0             126     44   161 129 5 23 1             3   100 61         126   44   161
325647 325647 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 05 2017   grade_1                                                   30                                             30
325648 325648 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   24                                             24
325649 325649 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 05 2017   grade_3                                                   28                                             28
325650 325650 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   18                                             18
325651 325651 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   22                                             22
325652 325652 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 05 2017   kindergarten_4_year_old                                                   17                                             17
325653 325653 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 05 2017   kindergarten                                                   20                                             20
325654 325654 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   2                                             2
325655 325655 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No Elementary PK 05 2017   pk_12_total 129.0   6.0 1.0                 65.0 71.0             100     29   136 129   6 1                 65 71         100   29   136
325656 325656 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No Elementary PK 05 2017   grade_1                                                   25                                             25
325657 325657 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   22                                             22
325658 325658 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No Elementary PK 05 2017   grade_3                                                   26                                             26
325659 325659 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   17                                             17
325660 325660 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   16                                             16
325661 325661 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No Elementary PK 05 2017   kindergarten_4_year_old                                                   19                                             19
325662 325662 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No Elementary PK 05 2017   kindergarten                                                   10                                             10
325663 325663 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
326158 326158 WI Ashland   school 5500510 170 Public school Ashland 550051003017 400 Ashland Charter High School charter Regular School Yes High 09 12 2017   pk_12_total 20.0     4.0                 13.0 11.0             10     4   24 20     4                 13 11         10   4   24
326159 326159 WI Ashland   school 5500510 170 Public school Ashland 550051003017 400 Ashland Charter High School charter Regular School Yes High 09 12 2017   grade_10                                                   2                                             2
326160 326160 WI Ashland   school 5500510 170 Public school Ashland 550051003017 400 Ashland Charter High School charter Regular School Yes High 09 12 2017   grade_11                                                   4                                             4
326161 326161 WI Ashland   school 5500510 170 Public school Ashland 550051003017 400 Ashland Charter High School charter Regular School Yes High 09 12 2017   grade_12                                                   3                                             3
326162 326162 WI Ashland   school 5500510 170 Public school Ashland 550051003017 400 Ashland Charter High School charter Regular School Yes High 09 12 2017   grade_9                                                   15                                             15
326163 326163 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Ashland Elementary Charter School charter Regular School Yes Elementary 03 05 2017   pk_12_total 58.0   2.0 8.0   1.0         3.0   33.0 39.0             34     7   72 58   2 8   1         3   33 39         34   7   72
326164 326164 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Ashland Elementary Charter School charter Regular School Yes Elementary 03 05 2017   grade_3                                                   23                                             23
326165 326165 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Ashland Elementary Charter School charter Regular School Yes Elementary 03 05 2017   grade_4                                                   26                                             26
326166 326166 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Ashland Elementary Charter School charter Regular School Yes Elementary 03 05 2017   grade_5                                                   23                                             23
326167 326167 WI Ashland   school 5500510 170 Public school Ashland 550051000073 20 Ashland High   Regular School No High 09 12 2017   pk_12_total 461.0 3.0 12.0 121.0   6.0         32.0   349.0 286.0             297     113   635 461 3 12 121   6         32   349 286         297   113   635
326168 326168 WI Ashland   school 5500510 170 Public school Ashland 550051000073 20 Ashland High   Regular School No High 09 12 2017   grade_10                                                   152                                             152
326169 326169 WI Ashland   school 5500510 170 Public school Ashland 550051000073 20 Ashland High   Regular School No High 09 12 2017   grade_11                                                   177                                             177
326170 326170 WI Ashland   school 5500510 170 Public school Ashland 550051000073 20 Ashland High   Regular School No High 09 12 2017   grade_12                                                   156                                             156
326171 326171 WI Ashland   school 5500510 170 Public school Ashland 550051000073 20 Ashland High   Regular School No High 09 12 2017   grade_9                                                   150                                             150
326172 326172 WI Ashland   school 5500510 170 Public school Ashland 550051000074 30 Ashland Middle   Regular School No Middle 06 08 2017   pk_12_total 273.0 2.0 10.0 96.0   1.0         21.0   218.0 185.0             228     54   403 273 2 10 96   1         21   218 185         228   54   403
326173 326173 WI Ashland   school 5500510 170 Public school Ashland 550051000074 30 Ashland Middle   Regular School No Middle 06 08 2017   grade_6                                                   130                                             130
326174 326174 WI Ashland   school 5500510 170 Public school Ashland 550051000074 30 Ashland Middle   Regular School No Middle 06 08 2017   grade_7                                                   122                                             122
326175 326175 WI Ashland   school 5500510 170 Public school Ashland 550051000074 30 Ashland Middle   Regular School No Middle 06 08 2017   grade_8                                                   151                                             151
326176 326176 WI Ashland   school 5500510 170 Public school Ashland 550051000076 60 Lake Superior Intermediate   Regular School No Elementary 03 05 2017   pk_12_total 187.0 3.0 7.0 108.0   1.0         29.0   152.0 183.0             225     55   335 187 3 7 108   1         29   152 183         225   55   335
326177 326177 WI Ashland   school 5500510 170 Public school Ashland 550051000076 60 Lake Superior Intermediate   Regular School No Elementary 03 05 2017   grade_3                                                   118                                             118
326178 326178 WI Ashland   school 5500510 170 Public school Ashland 550051000076 60 Lake Superior Intermediate   Regular School No Elementary 03 05 2017   grade_4                                                   105                                             105
326179 326179 WI Ashland   school 5500510 170 Public school Ashland 550051000076 60 Lake Superior Intermediate   Regular School No Elementary 03 05 2017   grade_5                                                   112                                             112
326180 326180 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No Elementary PK 02 2017   pk_12_total 218.0     93.0           1.0 26.0   171.0 167.0             213     65   338 218     93           1 26   171 167         213   65   338
326181 326181 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No Elementary PK 02 2017   grade_1                                                   106                                             106
326182 326182 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No Elementary PK 02 2017   grade_2                                                   130                                             130
326183 326183 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No Elementary PK 02 2017   kindergarten                                                   101                                             101
326184 326184 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No Elementary PK 02 2017   pre_kindergarten                                                   1                                             1
326185 326185 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No Elementary PK 05 2017   pk_12_total 172.0     1.0             2.0   93.0 82.0             140     10   175 172     1             2   93 82         140   10   175
326186 326186 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No Elementary PK 05 2017   grade_1                                                   26                                             26
326187 326187 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   33                                             33
326188 326188 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No Elementary PK 05 2017   grade_3                                                   34                                             34
326189 326189 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   34                                             34
326190 326190 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   24                                             24
326191 326191 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No Elementary PK 05 2017   kindergarten                                                   24                                             24
326192 326192 WI Ashland   school 5500510 170 Public school Ashland 550051002986 250 Oredocker Project School charter Regular School Yes Middle 06 08 2017   pk_12_total 48.0   1.0 6.0             2.0   36.0 21.0             31     8   57 48   1 6             2   36 21         31   8   57
326193 326193 WI Ashland   school 5500510 170 Public school Ashland 550051002986 250 Oredocker Project School charter Regular School Yes Middle 06 08 2017   grade_6                                                   21                                             21
326194 326194 WI Ashland   school 5500510 170 Public school Ashland 550051002986 250 Oredocker Project School charter Regular School Yes Middle 06 08 2017   grade_7                                                   20                                             20
326195 326195 WI Ashland   school 5500510 170 Public school Ashland 550051002986 250 Oredocker Project School charter Regular School Yes Middle 06 08 2017   grade_8                                                   16                                             16
327057 327057 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2017   pk_12_total 85.0     1.0                 34.0 52.0             55     12   86 85     1                 34 52         55   12   86
327058 327058 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2017   grade_1                                                   13                                             13
327059 327059 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   9                                             9
327060 327060 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2017   grade_3                                                   16                                             16
327061 327061 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   12                                             12
327062 327062 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   12                                             12
327063 327063 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2017   kindergarten_4_year_old                                                   12                                             12
327064 327064 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2017   kindergarten                                                   8                                             8
327065 327065 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   4                                             4
327066 327066 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No Other 06 12 2017   pk_12_total 93.0     1.0                 50.0 44.0             46     21   94 93     1                 50 44         46   21   94
327067 327067 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No Other 06 12 2017   grade_10                                                   16                                             16
327068 327068 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No Other 06 12 2017   grade_11                                                   11                                             11
327069 327069 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No Other 06 12 2017   grade_12                                                   17                                             17
327070 327070 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No Other 06 12 2017   grade_6                                                   12                                             12
327071 327071 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No Other 06 12 2017   grade_7                                                   15                                             15
327072 327072 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No Other 06 12 2017   grade_8                                                   12                                             12
327073 327073 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No Other 06 12 2017   grade_9                                                   11                                             11
332228 332228 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2017   pk_12_total 255.0 7.0 4.0 8.0   4.0             158.0 120.0             159     45   278 255 7 4 8   4             158 120         159   45   278
332229 332229 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2017   grade_1                                                   14                                             14
332230 332230 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2017   grade_10                                                   18                                             18
332231 332231 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2017   grade_11                                                   20                                             20
332232 332232 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2017   grade_12                                                   21                                             21
332233 332233 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2017   grade_2                                                   30                                             30
332234 332234 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2017   grade_3                                                   18                                             18
332235 332235 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2017   grade_4                                                   19                                             19

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