enrollments

Data source: Big Local News · About: Big Local

15,006 rows where state = "WI" and year = 2021 sorted by county descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 15,006 ✖
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
2333521 2333521 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No Elementary PK 05 2021   pk_12_total 349.0   16.0               8.0   208.0 165.0     5.0       106     36   373 349   16               8   208 165     5   106   36   373
2333522 2333522 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   51                                             51
2333523 2333523 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   49                                             49
2333524 2333524 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No Elementary PK 05 2021   grade_3                                                   56                                             56
2333525 2333525 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   50                                             50
2333526 2333526 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No Elementary PK 05 2021   grade_5                                                   51                                             51
2333527 2333527 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No Elementary PK 05 2021   kindergarten_4_year_old                                                   54                                             54
2333528 2333528 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No Elementary PK 05 2021   kindergarten                                                   58                                             58
2333529 2333529 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   4                                             4
2333530 2333530 WI Wood   school 5500600 203 Public school Auburndale 550060000091 60 Auburndale High   Regular School No High 06 12 2021   pk_12_total 366.0 2.0 21.0               7.0   203.0 193.0     9.0       103     36   396 366 2 21               7   203 193     9   103   36   396
2333531 2333531 WI Wood   school 5500600 203 Public school Auburndale 550060000091 60 Auburndale High   Regular School No High 06 12 2021   grade_10                                                   52                                             52
2333532 2333532 WI Wood   school 5500600 203 Public school Auburndale 550060000091 60 Auburndale High   Regular School No High 06 12 2021   grade_11                                                   51                                             51
2333533 2333533 WI Wood   school 5500600 203 Public school Auburndale 550060000091 60 Auburndale High   Regular School No High 06 12 2021   grade_12                                                   65                                             65
2333534 2333534 WI Wood   school 5500600 203 Public school Auburndale 550060000091 60 Auburndale High   Regular School No High 06 12 2021   grade_6                                                   63                                             63
2333535 2333535 WI Wood   school 5500600 203 Public school Auburndale 550060000091 60 Auburndale High   Regular School No High 06 12 2021   grade_7                                                   59                                             59
2333536 2333536 WI Wood   school 5500600 203 Public school Auburndale 550060000091 60 Auburndale High   Regular School No High 06 12 2021   grade_8                                                   53                                             53
2333537 2333537 WI Wood   school 5500600 203 Public school Auburndale 550060000091 60 Auburndale High   Regular School No High 06 12 2021   grade_9                                                   53                                             53
2333538 2333538 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2021   pk_12_total 20.0                       6.0 14.0             8     1   20 20                       6 14         8   1   20
2333539 2333539 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2021   grade_10                                                   4                                             4
2333540 2333540 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2021   grade_11                                                   3                                             3
2333541 2333541 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2021   grade_12                                                   3                                             3
2333542 2333542 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2021   grade_2                                                   1                                             1
2333543 2333543 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2021   grade_4                                                   2                                             2
2333544 2333544 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2021   grade_5                                                   1                                             1
2333545 2333545 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2021   grade_6                                                   1                                             1
2333546 2333546 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2021   grade_7                                                   1                                             1
2333547 2333547 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2021   grade_8                                                   1                                             1
2333548 2333548 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2021   grade_9                                                   3                                             3
2339540 2339540 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No Elementary PK 06 2021   pk_12_total 543.0 10.0 21.0     21.0         23.0   314.0 304.0     9.0       210     56   618 543 10 21     21         23   314 304     9   210   56   618
2339541 2339541 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No Elementary PK 06 2021   grade_1                                                   85                                             85
2339542 2339542 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No Elementary PK 06 2021   grade_2                                                   97                                             97
2339543 2339543 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No Elementary PK 06 2021   grade_3                                                   81                                             81
2339544 2339544 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No Elementary PK 06 2021   grade_4                                                   92                                             92
2339545 2339545 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No Elementary PK 06 2021   grade_5                                                   92                                             92
2339546 2339546 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No Elementary PK 06 2021   grade_6                                                   87                                             87
2339547 2339547 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No Elementary PK 06 2021   kindergarten                                                   84                                             84
2339548 2339548 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No Elementary PK 06 2021   pk_12_total 252.0 1.0 24.0     2.0         11.0   162.0 128.0     11.0       172     55   290 252 1 24     2         11   162 128     11   172   55   290
2339549 2339549 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No Elementary PK 06 2021   grade_1                                                   37                                             37
2339550 2339550 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No Elementary PK 06 2021   grade_2                                                   45                                             45
2339551 2339551 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No Elementary PK 06 2021   grade_3                                                   50                                             50
2339552 2339552 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No Elementary PK 06 2021   grade_4                                                   39                                             39
2339553 2339553 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No Elementary PK 06 2021   grade_5                                                   41                                             41
2339554 2339554 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No Elementary PK 06 2021   grade_6                                                   42                                             42
2339555 2339555 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No Elementary PK 06 2021   kindergarten                                                   36                                             36
2339556 2339556 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No Elementary PK 06 2021   pk_12_total 266.0 3.0 25.0     5.0         7.0   160.0 146.0     5.0       155     54   306 266 3 25     5         7   160 146     5   155   54   306
2339557 2339557 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No Elementary PK 06 2021   grade_1                                                   38                                             38
2339558 2339558 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No Elementary PK 06 2021   grade_2                                                   40                                             40
2339559 2339559 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No Elementary PK 06 2021   grade_3                                                   41                                             41
2339560 2339560 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No Elementary PK 06 2021   grade_4                                                   45                                             45
2339561 2339561 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No Elementary PK 06 2021   grade_5                                                   54                                             54
2339562 2339562 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No Elementary PK 06 2021   grade_6                                                   45                                             45
2339563 2339563 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No Elementary PK 06 2021   kindergarten                                                   43                                             43
2339564 2339564 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001021 120 Marshfield High   Regular School No High 09 12 2021   pk_12_total 1079.0 16.0 63.0 4.0   19.0         39.0   622.0 598.0     16.0       384     139   1220 1079 16 63 4   19         39   622 598     16   384   139   1220
2339565 2339565 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001021 120 Marshfield High   Regular School No High 09 12 2021   grade_10                                                   274                                             274
2339566 2339566 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001021 120 Marshfield High   Regular School No High 09 12 2021   grade_11                                                   318                                             318
2339567 2339567 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001021 120 Marshfield High   Regular School No High 09 12 2021   grade_12                                                   322                                             322
2339568 2339568 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001021 120 Marshfield High   Regular School No High 09 12 2021   grade_9                                                   306                                             306
2339569 2339569 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882002672 130 Marshfield K4   Regular School No Prekindergarten PK PK 2021   pk_12_total 172.0 3.0 8.0     3.0         7.0   84.0 109.0             48     10   193 172 3 8     3         7   84 109         48   10   193
2339570 2339570 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882002672 130 Marshfield K4   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   193                                             193
2339571 2339571 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001020 110 Marshfield Middle   Regular School No Middle 07 08 2021   pk_12_total 537.0 8.0 31.0     12.0       1.0 17.0   296.0 310.0     7.0       216     68   606 537 8 31     12       1 17   296 310     7   216   68   606
2339572 2339572 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001020 110 Marshfield Middle   Regular School No Middle 07 08 2021   grade_7                                                   307                                             307
2339573 2339573 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001020 110 Marshfield Middle   Regular School No Middle 07 08 2021   grade_8                                                   299                                             299
2339574 2339574 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No Elementary KG 06 2021   pk_12_total 285.0 2.0 14.0               3.0   156.0 148.0     8.0       89     30   304 285 2 14               3   156 148     8   89   30   304
2339575 2339575 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No Elementary KG 06 2021   grade_1                                                   52                                             52
2339576 2339576 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No Elementary KG 06 2021   grade_2                                                   43                                             43
2339577 2339577 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No Elementary KG 06 2021   grade_3                                                   49                                             49
2339578 2339578 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No Elementary KG 06 2021   grade_4                                                   44                                             44
2339579 2339579 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No Elementary KG 06 2021   grade_5                                                   39                                             39
2339580 2339580 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No Elementary KG 06 2021   grade_6                                                   42                                             42
2339581 2339581 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No Elementary KG 06 2021   kindergarten                                                   35                                             35
2339582 2339582 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2021   pk_12_total 59.0                   1.0   27.0 33.0             23     13   60 59                   1   27 33         23   13   60
2339583 2339583 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2021   grade_1                                                   3                                             3
2339584 2339584 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2021   grade_10                                                   7                                             7
2339585 2339585 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2021   grade_11                                                   5                                             5
2339586 2339586 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2021   grade_12                                                   3                                             3
2339587 2339587 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2021   grade_2                                                   4                                             4
2339588 2339588 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2021   grade_3                                                   4                                             4
2339589 2339589 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2021   grade_4                                                   5                                             5
2339590 2339590 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2021   grade_5                                                   7                                             7
2339591 2339591 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2021   grade_6                                                   2                                             2
2339592 2339592 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2021   grade_7                                                   6                                             6
2339593 2339593 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2021   grade_8                                                   7                                             7
2339594 2339594 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2021   grade_9                                                   3                                             3
2339595 2339595 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2021   kindergarten                                                   4                                             4
2339596 2339596 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No Elementary PK 06 2021   pk_12_total 272.0 10.0 17.0 1.0   10.0       1.0 21.0   177.0 155.0     5.0       112     58   332 272 10 17 1   10       1 21   177 155     5   112   58   332
2339597 2339597 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No Elementary PK 06 2021   grade_1                                                   39                                             39
2339598 2339598 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No Elementary PK 06 2021   grade_2                                                   48                                             48
2339599 2339599 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No Elementary PK 06 2021   grade_3                                                   41                                             41
2339600 2339600 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No Elementary PK 06 2021   grade_4                                                   49                                             49
2339601 2339601 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No Elementary PK 06 2021   grade_5                                                   46                                             46
2339602 2339602 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No Elementary PK 06 2021   grade_6                                                   48                                             48
2339603 2339603 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No Elementary PK 06 2021   kindergarten                                                   41                                             41
2339604 2339604 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   20                                             20
2342097 2342097 WI Wood   school 5510380 3906 Public school Nekoosa 551038001358 20 Alexander Middle   Regular School No Middle 04 08 2021   pk_12_total 272.0   37.0 9.0   1.0         25.0   181.0 163.0     13.0       195     44   344 272   37 9   1         25   181 163     13   195   44   344
2342098 2342098 WI Wood   school 5510380 3906 Public school Nekoosa 551038001358 20 Alexander Middle   Regular School No Middle 04 08 2021   grade_4                                                   70                                             70
2342099 2342099 WI Wood   school 5510380 3906 Public school Nekoosa 551038001358 20 Alexander Middle   Regular School No Middle 04 08 2021   grade_5                                                   65                                             65
2342100 2342100 WI Wood   school 5510380 3906 Public school Nekoosa 551038001358 20 Alexander Middle   Regular School No Middle 04 08 2021   grade_6                                                   67                                             67
2342101 2342101 WI Wood   school 5510380 3906 Public school Nekoosa 551038001358 20 Alexander Middle   Regular School No Middle 04 08 2021   grade_7                                                   67                                             67
2342102 2342102 WI Wood   school 5510380 3906 Public school Nekoosa 551038001358 20 Alexander Middle   Regular School No Middle 04 08 2021   grade_8                                                   75                                             75
2342103 2342103 WI Wood   school 5510380 3906 Public school Nekoosa 551038002957 100 Central Wisconsin STEM Academy charter Regular School Yes Middle 06 08 2021   pk_12_total 21.0   2.0               1.0   14.0 10.0             11     6   24 21   2               1   14 10         11   6   24

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