enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
3074520 3074520 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No Elementary PK 05 2019   pk_12_total 364.0   14.0               8.0   205.0 181.0             128     40   386 364   14               8   205 181         128   40   386
3074521 3074521 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No Elementary PK 05 2019   grade_1                                                   57                                             57
3074522 3074522 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No Elementary PK 05 2019   grade_2                                                   52                                             52
3074523 3074523 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No Elementary PK 05 2019   grade_3                                                   52                                             52
3074524 3074524 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No Elementary PK 05 2019   grade_4                                                   63                                             63
3074525 3074525 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No Elementary PK 05 2019   grade_5                                                   56                                             56
3074526 3074526 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No Elementary PK 05 2019   kindergarten_4_year_old                                                   39                                             39
3074527 3074527 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No Elementary PK 05 2019   kindergarten                                                   65                                             65
3074528 3074528 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                                                   2                                             2
3074529 3074529 WI Wood   school 5500600 203 Public school Auburndale 550060000091 60 Auburndale High   Regular School No High 06 12 2019   pk_12_total 410.0 1.0 11.0 1.0             5.0   212.0 216.0             126     42   428 410 1 11 1             5   212 216         126   42   428
3074530 3074530 WI Wood   school 5500600 203 Public school Auburndale 550060000091 60 Auburndale High   Regular School No High 06 12 2019   grade_10                                                   68                                             68
3074531 3074531 WI Wood   school 5500600 203 Public school Auburndale 550060000091 60 Auburndale High   Regular School No High 06 12 2019   grade_11                                                   61                                             61
3074532 3074532 WI Wood   school 5500600 203 Public school Auburndale 550060000091 60 Auburndale High   Regular School No High 06 12 2019   grade_12                                                   65                                             65
3074533 3074533 WI Wood   school 5500600 203 Public school Auburndale 550060000091 60 Auburndale High   Regular School No High 06 12 2019   grade_6                                                   57                                             57
3074534 3074534 WI Wood   school 5500600 203 Public school Auburndale 550060000091 60 Auburndale High   Regular School No High 06 12 2019   grade_7                                                   66                                             66
3074535 3074535 WI Wood   school 5500600 203 Public school Auburndale 550060000091 60 Auburndale High   Regular School No High 06 12 2019   grade_8                                                   55                                             55
3074536 3074536 WI Wood   school 5500600 203 Public school Auburndale 550060000091 60 Auburndale High   Regular School No High 06 12 2019   grade_9                                                   56                                             56
3074537 3074537 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2019   pk_12_total 4.0                       1.0 3.0             *     *   4 4                       1 3                 4
3074538 3074538 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2019   grade_7                                                   1                                             1
3074539 3074539 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2019   grade_8                                                   1                                             1
3074540 3074540 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2019   grade_9                                                   2                                             2
3080377 3080377 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No Elementary PK 06 2019   pk_12_total 606.0 8.0 25.0     20.0         24.0   337.0 346.0             238     73   683 606 8 25     20         24   337 346         238   73   683
3080378 3080378 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No Elementary PK 06 2019   grade_1                                                   82                                             82
3080379 3080379 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No Elementary PK 06 2019   grade_2                                                   97                                             97
3080380 3080380 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No Elementary PK 06 2019   grade_3                                                   95                                             95
3080381 3080381 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No Elementary PK 06 2019   grade_4                                                   97                                             97
3080382 3080382 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No Elementary PK 06 2019   grade_5                                                   101                                             101
3080383 3080383 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   103                                             103
3080384 3080384 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No Elementary PK 06 2019   kindergarten                                                   103                                             103
3080385 3080385 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten                                                   5                                             5
3080386 3080386 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No Elementary KG 06 2019   pk_12_total 269.0 11.0 26.0     3.0         15.0   172.0 152.0             173     48   324 269 11 26     3         15   172 152         173   48   324
3080387 3080387 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No Elementary KG 06 2019   grade_1                                                   48                                             48
3080388 3080388 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No Elementary KG 06 2019   grade_2                                                   47                                             47
3080389 3080389 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No Elementary KG 06 2019   grade_3                                                   46                                             46
3080390 3080390 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No Elementary KG 06 2019   grade_4                                                   45                                             45
3080391 3080391 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No Elementary KG 06 2019   grade_5                                                   51                                             51
3080392 3080392 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No Elementary KG 06 2019   grade_6                                                   47                                             47
3080393 3080393 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No Elementary KG 06 2019   kindergarten                                                   40                                             40
3080394 3080394 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No Elementary KG 06 2019   pk_12_total 293.0 3.0 14.0     8.0       2.0 11.0   173.0 158.0             155     46   331 293 3 14     8       2 11   173 158         155   46   331
3080395 3080395 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No Elementary KG 06 2019   grade_1                                                   43                                             43
3080396 3080396 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No Elementary KG 06 2019   grade_2                                                   42                                             42
3080397 3080397 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No Elementary KG 06 2019   grade_3                                                   51                                             51
3080398 3080398 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No Elementary KG 06 2019   grade_4                                                   47                                             47
3080399 3080399 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No Elementary KG 06 2019   grade_5                                                   55                                             55
3080400 3080400 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No Elementary KG 06 2019   grade_6                                                   50                                             50
3080401 3080401 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No Elementary KG 06 2019   kindergarten                                                   43                                             43
3080402 3080402 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001021 120 Marshfield High   Regular School No High 09 12 2019   pk_12_total 1091.0 16.0 56.0 4.0   32.0         35.0   652.0 582.0             343     151   1234 1091 16 56 4   32         35   652 582         343   151   1234
3080403 3080403 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001021 120 Marshfield High   Regular School No High 09 12 2019   grade_10                                                   315                                             315
3080404 3080404 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001021 120 Marshfield High   Regular School No High 09 12 2019   grade_11                                                   278                                             278
3080405 3080405 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001021 120 Marshfield High   Regular School No High 09 12 2019   grade_12                                                   321                                             321
3080406 3080406 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001021 120 Marshfield High   Regular School No High 09 12 2019   grade_9                                                   320                                             320
3080407 3080407 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882002672 130 Marshfield K4   Regular School No Prekindergarten PK PK 2019   pk_12_total 188.0 3.0 12.0     7.0         3.0   111.0 102.0             40     24   213 188 3 12     7         3   111 102         40   24   213
3080408 3080408 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882002672 130 Marshfield K4   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   213                                             213
3080409 3080409 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001020 110 Marshfield Middle   Regular School No Middle 07 08 2019   pk_12_total 500.0 4.0 37.0 4.0   16.0         14.0   275.0 300.0             187     70   575 500 4 37 4   16         14   275 300         187   70   575
3080410 3080410 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001020 110 Marshfield Middle   Regular School No Middle 07 08 2019   grade_7                                                   309                                             309
3080411 3080411 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001020 110 Marshfield Middle   Regular School No Middle 07 08 2019   grade_8                                                   266                                             266
3080412 3080412 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No Elementary KG 06 2019   pk_12_total 302.0 1.0 15.0               2.0   170.0 150.0             95     26   320 302 1 15               2   170 150         95   26   320
3080413 3080413 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No Elementary KG 06 2019   grade_1                                                   49                                             49
3080414 3080414 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No Elementary KG 06 2019   grade_2                                                   46                                             46
3080415 3080415 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No Elementary KG 06 2019   grade_3                                                   46                                             46
3080416 3080416 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No Elementary KG 06 2019   grade_4                                                   41                                             41
3080417 3080417 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No Elementary KG 06 2019   grade_5                                                   44                                             44
3080418 3080418 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No Elementary KG 06 2019   grade_6                                                   52                                             52
3080419 3080419 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No Elementary KG 06 2019   kindergarten                                                   42                                             42
3080420 3080420 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2019   pk_12_total 37.0 1.0       1.0             22.0 17.0             6     6   39 37 1       1             22 17         6   6   39
3080421 3080421 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2019   grade_1                                                   2                                             2
3080422 3080422 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2019   grade_10                                                   1                                             1
3080423 3080423 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2019   grade_11                                                   3                                             3
3080424 3080424 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2019   grade_12                                                   2                                             2
3080425 3080425 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2019   grade_2                                                   4                                             4
3080426 3080426 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2019   grade_3                                                   6                                             6
3080427 3080427 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2019   grade_4                                                   1                                             1
3080428 3080428 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2019   grade_5                                                   5                                             5
3080429 3080429 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2019   grade_6                                                   4                                             4
3080430 3080430 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2019   grade_7                                                   2                                             2
3080431 3080431 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2019   grade_8                                                   2                                             2
3080432 3080432 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2019   grade_9                                                   2                                             2
3080433 3080433 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2019   kindergarten_4_year_old                                                   1                                             1
3080434 3080434 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2019   kindergarten                                                   4                                             4
3080435 3080435 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No Elementary PK 06 2019   pk_12_total 301.0 4.0 15.0 1.0   11.0         17.0   177.0 172.0             99     55   349 301 4 15 1   11         17   177 172         99   55   349
3080436 3080436 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No Elementary PK 06 2019   grade_1                                                   40                                             40
3080437 3080437 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No Elementary PK 06 2019   grade_2                                                   47                                             47
3080438 3080438 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No Elementary PK 06 2019   grade_3                                                   47                                             47
3080439 3080439 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No Elementary PK 06 2019   grade_4                                                   47                                             47
3080440 3080440 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No Elementary PK 06 2019   grade_5                                                   52                                             52
3080441 3080441 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   51                                             51
3080442 3080442 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No Elementary PK 06 2019   kindergarten_4_year_old                                                   1                                             1
3080443 3080443 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No Elementary PK 06 2019   kindergarten                                                   48                                             48
3080444 3080444 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten                                                   16                                             16
3082982 3082982 WI Wood   school 5510380 3906 Public school Nekoosa 551038001358 20 Alexander Middle   Regular School No Middle 04 08 2019   pk_12_total 254.0 3.0 37.0 9.0   3.0         30.0   179.0 157.0             176     45   336 254 3 37 9   3         30   179 157         176   45   336
3082983 3082983 WI Wood   school 5510380 3906 Public school Nekoosa 551038001358 20 Alexander Middle   Regular School No Middle 04 08 2019   grade_4                                                   80                                             80
3082984 3082984 WI Wood   school 5510380 3906 Public school Nekoosa 551038001358 20 Alexander Middle   Regular School No Middle 04 08 2019   grade_5                                                   71                                             71
3082985 3082985 WI Wood   school 5510380 3906 Public school Nekoosa 551038001358 20 Alexander Middle   Regular School No Middle 04 08 2019   grade_6                                                   69                                             69
3082986 3082986 WI Wood   school 5510380 3906 Public school Nekoosa 551038001358 20 Alexander Middle   Regular School No Middle 04 08 2019   grade_7                                                   57                                             57
3082987 3082987 WI Wood   school 5510380 3906 Public school Nekoosa 551038001358 20 Alexander Middle   Regular School No Middle 04 08 2019   grade_8                                                   59                                             59
3082988 3082988 WI Wood   school 5510380 3906 Public school Nekoosa 551038002957 100 Central Wisconsin STEM Academy charter Regular School Yes Middle 05 08 2019   pk_12_total 23.0   3.0                   21.0 5.0             10     1   26 23   3                   21 5         10   1   26
3082989 3082989 WI Wood   school 5510380 3906 Public school Nekoosa 551038002957 100 Central Wisconsin STEM Academy charter Regular School Yes Middle 05 08 2019   grade_6                                                   11                                             11
3082990 3082990 WI Wood   school 5510380 3906 Public school Nekoosa 551038002957 100 Central Wisconsin STEM Academy charter Regular School Yes Middle 05 08 2019   grade_7                                                   6                                             6
3082991 3082991 WI Wood   school 5510380 3906 Public school Nekoosa 551038002957 100 Central Wisconsin STEM Academy charter Regular School Yes Middle 05 08 2019   grade_8                                                   9                                             9
3082992 3082992 WI Wood   school 5510380 3906 Public school Nekoosa 551038002344 40 Humke Elementary   Regular School No Elementary PK 03 2019   pk_12_total 230.0   40.0 8.0   3.0       1.0 16.0   145.0 153.0             184     39   298 230   40 8   3       1 16   145 153         184   39   298

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