enrollments

Data source: Big Local News · About: Big Local

14,749 rows where state = "WI" and year = 2019 sorted by county

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 14,749 ✖
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
3073921 3073921 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 04 2019   pk_12_total 397.0 7.0 36.0 1.0   1.0         14.0   204.0 252.0             314     111   456 397 7 36 1   1         14   204 252         314   111   456
3073922 3073922 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 04 2019   grade_1                                                   69                                             69
3073923 3073923 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 04 2019   grade_2                                                   61                                             61
3073924 3073924 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 04 2019   grade_3                                                   94                                             94
3073925 3073925 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 04 2019   grade_4                                                   76                                             76
3073926 3073926 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 04 2019   kindergarten_4_year_old                                                   73                                             73
3073927 3073927 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 04 2019   kindergarten                                                   73                                             73
3073928 3073928 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 04 2019   pre_kindergarten                                                   10                                             10
3073929 3073929 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No High 09 12 2019   pk_12_total 440.0 5.0 23.0 5.0   2.0       1.0 10.0   252.0 234.0             309     112   486 440 5 23 5   2       1 10   252 234         309   112   486
3073930 3073930 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No High 09 12 2019   grade_10                                                   111                                             111
3073931 3073931 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No High 09 12 2019   grade_11                                                   112                                             112
3073932 3073932 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No High 09 12 2019   grade_12                                                   132                                             132
3073933 3073933 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No High 09 12 2019   grade_9                                                   131                                             131
3073934 3073934 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No Middle 05 08 2019   pk_12_total 384.0 6.0 44.0 5.0   1.0         10.0   229.0 221.0             302     103   450 384 6 44 5   1         10   229 221         302   103   450
3073935 3073935 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No Middle 05 08 2019   grade_5                                                   120                                             120
3073936 3073936 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No Middle 05 08 2019   grade_6                                                   115                                             115
3073937 3073937 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No Middle 05 08 2019   grade_7                                                   104                                             104
3073938 3073938 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No Middle 05 08 2019   grade_8                                                   111                                             111
3073939 3073939 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 04 2019   pk_12_total 85.0 3.0 7.0 2.0             5.0   64.0 38.0             89     27   102 85 3 7 2             5   64 38         89   27   102
3073940 3073940 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 04 2019   grade_1                                                   25                                             25
3073941 3073941 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 04 2019   grade_2                                                   14                                             14
3073942 3073942 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 04 2019   grade_3                                                   20                                             20
3073943 3073943 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 04 2019   grade_4                                                   22                                             22
3073944 3073944 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 04 2019   kindergarten_4_year_old                                                   1                                             1
3073945 3073945 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 04 2019   kindergarten                                                   20                                             20
3074437 3074437 WI Ashland   school 5500510 170 Public school Ashland 550051000073 20 Ashland High   Regular School No High 09 12 2019   pk_12_total 446.0 7.0 13.0 126.0   3.0         36.0   336.0 295.0             367     101   631 446 7 13 126   3         36   336 295         367   101   631
3074438 3074438 WI Ashland   school 5500510 170 Public school Ashland 550051000073 20 Ashland High   Regular School No High 09 12 2019   grade_10                                                   173                                             173
3074439 3074439 WI Ashland   school 5500510 170 Public school Ashland 550051000073 20 Ashland High   Regular School No High 09 12 2019   grade_11                                                   159                                             159
3074440 3074440 WI Ashland   school 5500510 170 Public school Ashland 550051000073 20 Ashland High   Regular School No High 09 12 2019   grade_12                                                   158                                             158
3074441 3074441 WI Ashland   school 5500510 170 Public school Ashland 550051000073 20 Ashland High   Regular School No High 09 12 2019   grade_9                                                   141                                             141
3074442 3074442 WI Ashland   school 5500510 170 Public school Ashland 550051000074 30 Ashland Middle   Regular School No Middle 06 08 2019   pk_12_total 303.0 4.0 3.0 94.0   1.0         26.0   227.0 204.0             283     58   431 303 4 3 94   1         26   227 204         283   58   431
3074443 3074443 WI Ashland   school 5500510 170 Public school Ashland 550051000074 30 Ashland Middle   Regular School No Middle 06 08 2019   grade_6                                                   145                                             145
3074444 3074444 WI Ashland   school 5500510 170 Public school Ashland 550051000074 30 Ashland Middle   Regular School No Middle 06 08 2019   grade_7                                                   152                                             152
3074445 3074445 WI Ashland   school 5500510 170 Public school Ashland 550051000074 30 Ashland Middle   Regular School No Middle 06 08 2019   grade_8                                                   134                                             134
3074446 3074446 WI Ashland   school 5500510 170 Public school Ashland 550051003017 400 Lake Superior High charter Regular School Yes High 09 12 2019   pk_12_total 13.0   1.0 10.0                 12.0 12.0             *     6   24 13   1 10                 12 12             6   24
3074447 3074447 WI Ashland   school 5500510 170 Public school Ashland 550051003017 400 Lake Superior High charter Regular School Yes High 09 12 2019   grade_10                                                   4                                             4
3074448 3074448 WI Ashland   school 5500510 170 Public school Ashland 550051003017 400 Lake Superior High charter Regular School Yes High 09 12 2019   grade_11                                                   8                                             8
3074449 3074449 WI Ashland   school 5500510 170 Public school Ashland 550051003017 400 Lake Superior High charter Regular School Yes High 09 12 2019   grade_12                                                   2                                             2
3074450 3074450 WI Ashland   school 5500510 170 Public school Ashland 550051003017 400 Lake Superior High charter Regular School Yes High 09 12 2019   grade_9                                                   10                                             10
3074451 3074451 WI Ashland   school 5500510 170 Public school Ashland 550051000076 60 Lake Superior Intermediate   Regular School No Elementary 03 05 2019   pk_12_total 197.0 1.0 7.0 87.0             23.0   149.0 166.0             217     54   315 197 1 7 87             23   149 166         217   54   315
3074452 3074452 WI Ashland   school 5500510 170 Public school Ashland 550051000076 60 Lake Superior Intermediate   Regular School No Elementary 03 05 2019   grade_3                                                   89                                             89
3074453 3074453 WI Ashland   school 5500510 170 Public school Ashland 550051000076 60 Lake Superior Intermediate   Regular School No Elementary 03 05 2019   grade_4                                                   118                                             118
3074454 3074454 WI Ashland   school 5500510 170 Public school Ashland 550051000076 60 Lake Superior Intermediate   Regular School No Elementary 03 05 2019   grade_5                                                   108                                             108
3074455 3074455 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Lake Superior Learning Community charter Regular School Yes Elementary 03 06 2019   pk_12_total 48.0 1.0 2.0 12.0   2.0         7.0   32.0 40.0             46     8   72 48 1 2 12   2         7   32 40         46   8   72
3074456 3074456 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Lake Superior Learning Community charter Regular School Yes Elementary 03 06 2019   grade_3                                                   21                                             21
3074457 3074457 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Lake Superior Learning Community charter Regular School Yes Elementary 03 06 2019   grade_4                                                   14                                             14
3074458 3074458 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Lake Superior Learning Community charter Regular School Yes Elementary 03 06 2019   grade_5                                                   26                                             26
3074459 3074459 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Lake Superior Learning Community charter Regular School Yes Elementary 03 06 2019   grade_6                                                   11                                             11
3074460 3074460 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No Elementary PK 02 2019   pk_12_total 279.0 2.0 7.0 86.0             37.0   229.0 182.0             270     77   411 279 2 7 86             37   229 182         270   77   411
3074461 3074461 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No Elementary PK 02 2019   grade_1                                                   116                                             116
3074462 3074462 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No Elementary PK 02 2019   grade_2                                                   100                                             100
3074463 3074463 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No Elementary PK 02 2019   kindergarten_4_year_old                                                   79                                             79
3074464 3074464 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No Elementary PK 02 2019   kindergarten                                                   110                                             110
3074465 3074465 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No Elementary PK 02 2019   pre_kindergarten                                                   6                                             6
3074466 3074466 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No Elementary PK 05 2019   pk_12_total 186.0                       108.0 78.0             153     7   186 186                       108 78         153   7   186
3074467 3074467 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No Elementary PK 05 2019   grade_1                                                   27                                             27
3074468 3074468 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No Elementary PK 05 2019   grade_2                                                   25                                             25
3074469 3074469 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No Elementary PK 05 2019   grade_3                                                   28                                             28
3074470 3074470 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No Elementary PK 05 2019   grade_4                                                   37                                             37
3074471 3074471 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No Elementary PK 05 2019   grade_5                                                   36                                             36
3074472 3074472 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No Elementary PK 05 2019   kindergarten                                                   33                                             33
3074473 3074473 WI Ashland   school 5500510 170 Public school Ashland 550051002986 250 Oredocker Project School charter Regular School Yes Middle 06 08 2019   pk_12_total 14.0     6.0             3.0   14.0 9.0             *     8   23 14     6             3   14 9             8   23
3074474 3074474 WI Ashland   school 5500510 170 Public school Ashland 550051002986 250 Oredocker Project School charter Regular School Yes Middle 06 08 2019   grade_7                                                   7                                             7
3074475 3074475 WI Ashland   school 5500510 170 Public school Ashland 550051002986 250 Oredocker Project School charter Regular School Yes Middle 06 08 2019   grade_8                                                   16                                             16
3075355 3075355 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2019   pk_12_total 102.0     2.0                 41.0 63.0             47     18   104 102     2                 41 63         47   18   104
3075356 3075356 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2019   grade_1                                                   15                                             15
3075357 3075357 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2019   grade_2                                                   11                                             11
3075358 3075358 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2019   grade_3                                                   11                                             11
3075359 3075359 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2019   grade_4                                                   11                                             11
3075360 3075360 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2019   grade_5                                                   18                                             18
3075361 3075361 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2019   kindergarten_4_year_old                                                   14                                             14
3075362 3075362 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2019   kindergarten                                                   10                                             10
3075363 3075363 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                                                   14                                             14
3075364 3075364 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No High 06 12 2019   pk_12_total 96.0     1.0             3.0   52.0 48.0             40     30   100 96     1             3   52 48         40   30   100
3075365 3075365 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No High 06 12 2019   grade_10                                                   15                                             15
3075366 3075366 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No High 06 12 2019   grade_11                                                   12                                             12
3075367 3075367 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No High 06 12 2019   grade_12                                                   20                                             20
3075368 3075368 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No High 06 12 2019   grade_6                                                   9                                             9
3075369 3075369 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No High 06 12 2019   grade_7                                                   15                                             15
3075370 3075370 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No High 06 12 2019   grade_8                                                   14                                             14
3075371 3075371 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No High 06 12 2019   grade_9                                                   15                                             15
3075372 3075372 WI Ashland   school 5501920 840 Public school Butternut 550192002751 450 Promethean Charter School charter Regular School Yes High 09 12 2019   pk_12_total 1.0         1.0             2.0               *     *   2 1         1             2                   2
3075373 3075373 WI Ashland   school 5501920 840 Public school Butternut 550192002751 450 Promethean Charter School charter Regular School Yes High 09 12 2019   grade_10                                                   1                                             1
3075374 3075374 WI Ashland   school 5501920 840 Public school Butternut 550192002751 450 Promethean Charter School charter Regular School Yes High 09 12 2019   grade_11                                                   1                                             1
3080592 3080592 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2019   pk_12_total 247.0 5.0 3.0 11.0   4.0         1.0   143.0 128.0             151     46   271 247 5 3 11   4         1   143 128         151   46   271
3080593 3080593 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2019   grade_1                                                   22                                             22
3080594 3080594 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2019   grade_10                                                   24                                             24
3080595 3080595 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2019   grade_11                                                   22                                             22
3080596 3080596 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2019   grade_12                                                   18                                             18
3080597 3080597 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2019   grade_2                                                   17                                             17
3080598 3080598 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2019   grade_3                                                   13                                             13
3080599 3080599 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2019   grade_4                                                   27                                             27
3080600 3080600 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2019   grade_5                                                   19                                             19
3080601 3080601 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2019   grade_6                                                   18                                             18
3080602 3080602 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2019   grade_7                                                   16                                             16
3080603 3080603 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2019   grade_8                                                   28                                             28
3080604 3080604 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2019   grade_9                                                   9                                             9
3080605 3080605 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2019   kindergarten_4_year_old                                                   15                                             15
3080606 3080606 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2019   kindergarten                                                   21                                             21
3080607 3080607 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2019   pre_kindergarten                                                   2                                             2

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