enrollments

Data source: Big Local News · About: Big Local

4,960 rows where grade = "grade_6" and state = "WI" sorted by district descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_6 · 4,960 ✖
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
126378 126378 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No 1.0 PK 08 2015   grade_6                                                   70                                             70
296315 296315 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No 1.0 PK 08 2016   grade_6                                                   60                                             60
340256 340256 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2017   grade_6                                                   69                                             69
2332921 2332921 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2020   grade_6                                                   47                                             47
2347927 2347927 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2021   grade_6                                                   57                                             57
3088632 3088632 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2019   grade_6                                                   53                                             53
3103334 3103334 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2018   grade_6                                                   48                                             48
126369 126369 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No 2.0 05 08 2015   grade_6                                                   103                                             103
296306 296306 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No 2.0 05 08 2016   grade_6                                                   83                                             83
340247 340247 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No Middle 05 08 2017   grade_6                                                   94                                             94
2332912 2332912 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No Middle 05 08 2020   grade_6                                                   89                                             89
2347918 2347918 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No Middle 05 08 2021   grade_6                                                   89                                             89
3088623 3088623 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No Middle 05 08 2019   grade_6                                                   88                                             88
3103325 3103325 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No Middle 05 08 2018   grade_6                                                   95                                             95
126348 126348 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No 1.0 PK 08 2015   grade_6                                                   53                                             53
296286 296286 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No 1.0 PK 08 2016   grade_6                                                   57                                             57
340226 340226 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2017   grade_6                                                   56                                             56
2332890 2332890 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2020   grade_6                                                   46                                             46
2347897 2347897 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2021   grade_6                                                   58                                             58
3088601 3088601 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2019   grade_6                                                   59                                             59
3103304 3103304 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2018   grade_6                                                   51                                             51
3103295 3103295 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School East 550007002942 100 Woodlands School East charter Regular School Yes Elementary PK 08 2018   grade_6                                                   28                                             28
2332879 2332879 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School - State Street Campus 550007002942 100 Woodlands School - State Street Campus charter Regular School Yes Elementary PK 08 2020   grade_6                                                   36                                             36
2347886 2347886 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School - State Street Campus 550007002942 100 Woodlands School - State Street Campus charter Regular School Yes Elementary PK 08 2021   grade_6                                                   28                                             28
3088591 3088591 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School - State Street Campus 550007002942 100 Woodlands School - State Street Campus charter Regular School Yes Elementary PK 08 2019   grade_6                                                   38                                             38
126331 126331 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes 1.0 PK 08 2015   grade_6                                                   34                                             34
296268 296268 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes 1.0 PK 08 2016   grade_6                                                   37                                             37
340207 340207 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2017   grade_6                                                   35                                             35
2332868 2332868 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2020   grade_6                                                   37                                             37
2347875 2347875 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2021   grade_6                                                   36                                             36
3088580 3088580 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2019   grade_6                                                   34                                             34
3103284 3103284 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2018   grade_6                                                   36                                             36
126322 126322 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002226 100 Wonewoc-Center Junior High   Regular School No 2.0 06 08 2015   grade_6                                                   30                                             30
296259 296259 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002226 100 Wonewoc-Center Junior High   Regular School No 2.0 06 08 2016   grade_6                                                   22                                             22
340198 340198 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002226 100 Wonewoc-Center Junior High   Regular School No Middle 06 08 2017   grade_6                                                   21                                             21
2332857 2332857 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002226 100 Wonewoc-Center Junior High   Regular School No Middle 06 08 2020   grade_6                                                   17                                             17
2347852 2347852 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002226 100 Wonewoc-Center Junior High   Regular School No Middle 06 08 2021   grade_6                                                   24                                             24
2347864 2347864 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713003059 850 Wonewoc-Center Virtual Academy charter Regular School Yes Other KG 12 2021   grade_6                                                   3                                             3
3088568 3088568 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002226 100 Wonewoc-Center Junior High   Regular School No Middle 06 08 2019   grade_6                                                   27                                             27
3103273 3103273 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002226 100 Wonewoc-Center Junior High   Regular School No Middle 06 08 2018   grade_6                                                   33                                             33
126283 126283 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No 1.0 PK 08 2015   grade_6                                                   42                                             42
126294 126294 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No 1.0 PK 08 2015   grade_6                                                   43                                             43
296221 296221 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No 1.0 PK 08 2016   grade_6                                                   43                                             43
296232 296232 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No 1.0 PK 08 2016   grade_6                                                   49                                             49
340161 340161 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2017   grade_6                                                   37                                             37
340172 340172 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2017   grade_6                                                   47                                             47
2332820 2332820 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2020   grade_6                                                   43                                             43
2332831 2332831 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2020   grade_6                                                   42                                             42
2347810 2347810 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2021   grade_6                                                   35                                             35
2347821 2347821 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2021   grade_6                                                   43                                             43
3088530 3088530 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2019   grade_6                                                   49                                             49
3088541 3088541 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2019   grade_6                                                   49                                             49
3103235 3103235 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2018   grade_6                                                   33                                             33
3103246 3103246 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2018   grade_6                                                   44                                             44
126263 126263 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002216 290 Wisconsin Rapids Area Middle   Regular School No 2.0 06 07 2015   grade_6                                                   336                                             336
296201 296201 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002216 290 Wisconsin Rapids Area Middle   Regular School No 2.0 06 07 2016   grade_6                                                   370                                             370
340141 340141 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002216 290 Wisconsin Rapids Area Middle   Regular School No Middle 06 07 2017   grade_6                                                   346                                             346
2332735 2332735 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707003088 190 Central Oaks Academy   Regular School No Elementary PK 08 2020   grade_6                                                   14                                             14
2332799 2332799 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002216 290 Wisconsin Rapids Area Middle   Regular School No Middle 06 08 2020   grade_6                                                   352                                             352
2347726 2347726 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707003088 190 Central Oaks Academy   Regular School No Elementary PK 08 2021   grade_6                                                   66                                             66
2347789 2347789 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002216 290 Wisconsin Rapids Area Middle   Regular School No Middle 06 08 2021   grade_6                                                   296                                             296
3088446 3088446 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707003088 190 Central Oaks Academy   Regular School No Elementary PK 08 2019   grade_6                                                   17                                             17
3088509 3088509 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002216 290 Wisconsin Rapids Area Middle   Regular School No Middle 06 08 2019   grade_6                                                   366                                             366
3103215 3103215 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002216 290 Wisconsin Rapids Area Middle   Regular School No Middle 06 07 2018   grade_6                                                   362                                             362
126191 126191 WI Dane   school 5501230 469 Public school Wisconsin Heights 550123000609 80 Wisconsin Heights Middle   Regular School No 2.0 06 08 2015   grade_6                                                   55                                             55
296129 296129 WI Dane   school 5501230 469 Public school Wisconsin Heights 550123000609 80 Wisconsin Heights Middle   Regular School No 2.0 06 08 2016   grade_6                                                   45                                             45
340068 340068 WI Dane   school 5501230 469 Public school Wisconsin Heights 550123000609 80 Wisconsin Heights Middle   Regular School No Middle 06 08 2017   grade_6                                                   55                                             55
2332726 2332726 WI Dane   school 5501230 469 Public school Wisconsin Heights 550123000609 80 Wisconsin Heights Middle   Regular School No Middle 06 08 2020   grade_6                                                   56                                             56
2347717 2347717 WI Dane   school 5501230 469 Public school Wisconsin Heights 550123000609 80 Wisconsin Heights Middle   Regular School No Middle 06 08 2021   grade_6                                                   50                                             50
3088437 3088437 WI Dane   school 5501230 469 Public school Wisconsin Heights 550123000609 80 Wisconsin Heights Middle   Regular School No Middle 06 08 2019   grade_6                                                   51                                             51
3103142 3103142 WI Dane   school 5501230 469 Public school Wisconsin Heights 550123000609 80 Wisconsin Heights Middle   Regular School No Middle 06 08 2018   grade_6                                                   47                                             47
126167 126167 WI Sauk   school 5517040 6678 Public school Wisconsin Dells 551704002271 200 Spring Hill Middle   Regular School No 2.0 06 08 2015   grade_6                                                   133                                             133
296105 296105 WI Sauk   school 5517040 6678 Public school Wisconsin Dells 551704002271 200 Spring Hill Middle   Regular School No 2.0 06 08 2016   grade_6                                                   124                                             124
340044 340044 WI Sauk   school 5517040 6678 Public school Wisconsin Dells 551704002271 200 Spring Hill Middle   Regular School No Middle 06 08 2017   grade_6                                                   140                                             140
2332702 2332702 WI Sauk   school 5517040 6678 Public school Wisconsin Dells 551704002271 200 Spring Hill Middle   Regular School No Middle 06 08 2020   grade_6                                                   134                                             134
2347698 2347698 WI Sauk   school 5517040 6678 Public school Wisconsin Dells 551704002271 200 Wisconsin Dells Middle School   Regular School No Middle 06 08 2021   grade_6                                                   120                                             120
3088413 3088413 WI Sauk   school 5517040 6678 Public school Wisconsin Dells 551704002271 200 Spring Hill Middle   Regular School No Middle 06 08 2019   grade_6                                                   134                                             134
3103118 3103118 WI Sauk   school 5517040 6678 Public school Wisconsin Dells 551704002271 200 Spring Hill Middle   Regular School No Middle 06 08 2018   grade_6                                                   146                                             146
126139 126139 WI Sawyer   school 5516860 6615 Public school Winter 551686002315 100 Winter Middle   Regular School No 2.0 06 08 2015   grade_6                                                   18                                             18
296077 296077 WI Sawyer   school 5516860 6615 Public school Winter 551686002315 100 Winter Middle   Regular School No 2.0 06 08 2016   grade_6                                                   12                                             12
340016 340016 WI Sawyer   school 5516860 6615 Public school Winter 551686002315 100 Winter Middle   Regular School No Middle 06 08 2017   grade_6                                                   16                                             16
2332674 2332674 WI Sawyer   school 5516860 6615 Public school Winter 551686002315 100 Winter Middle   Regular School No Middle 06 08 2020   grade_6                                                   18                                             18
2347665 2347665 WI Sawyer   school 5516860 6615 Public school Winter 551686002315 100 Winter Middle   Regular School No Middle 06 08 2021   grade_6                                                   20                                             20
3088385 3088385 WI Sawyer   school 5516860 6615 Public school Winter 551686002315 100 Winter Middle   Regular School No Middle 06 08 2019   grade_6                                                   22                                             22
3103090 3103090 WI Sawyer   school 5516860 6615 Public school Winter 551686002315 100 Winter Middle   Regular School No Middle 06 08 2018   grade_6                                                   19                                             19
126121 126121 WI Winnebago   school 5516830 6608 Public school Winneconne Community 551683002192 80 Winneconne Middle   Regular School No 2.0 06 08 2015   grade_6                                                   128                                             128
296059 296059 WI Winnebago   school 5516830 6608 Public school Winneconne Community 551683002192 80 Winneconne Middle   Regular School No 2.0 06 08 2016   grade_6                                                   113                                             113
339998 339998 WI Winnebago   school 5516830 6608 Public school Winneconne Community 551683002192 80 Winneconne Middle   Regular School No Middle 06 08 2017   grade_6                                                   121                                             121
2332657 2332657 WI Winnebago   school 5516830 6608 Public school Winneconne Community 551683002192 80 Winneconne Middle   Regular School No Middle 06 08 2020   grade_6                                                   154                                             154
2347647 2347647 WI Winnebago   school 5516830 6608 Public school Winneconne Community 551683002192 80 Winneconne Middle   Regular School No Middle 06 08 2021   grade_6                                                   114                                             114
3088368 3088368 WI Winnebago   school 5516830 6608 Public school Winneconne Community 551683002192 80 Winneconne Middle   Regular School No Middle 06 08 2019   grade_6                                                   115                                             115
3103073 3103073 WI Winnebago   school 5516830 6608 Public school Winneconne Community 551683002192 80 Winneconne Middle   Regular School No Middle 06 08 2018   grade_6                                                   123                                             123
126091 126091 WI Walworth   school 5516740 6482 Public school Williams Bay 551674002186 20 Williams Bay Elementary   Regular School No 1.0 PK 06 2015   grade_6                                                   55                                             55
296036 296036 WI Walworth   school 5516740 6482 Public school Williams Bay 551674000277 30 Williams Bay Middle   Regular School No 2.0 06 08 2016   grade_6                                                   53                                             53
339975 339975 WI Walworth   school 5516740 6482 Public school Williams Bay 551674000277 30 Williams Bay Middle   Regular School No Middle 06 08 2017   grade_6                                                   62                                             62
2332634 2332634 WI Walworth   school 5516740 6482 Public school Williams Bay 551674000277 30 Williams Bay Middle   Regular School No Middle 06 08 2020   grade_6                                                   63                                             63
2347624 2347624 WI Walworth   school 5516740 6482 Public school Williams Bay 551674000277 30 Williams Bay Middle   Regular School No Middle 06 08 2021   grade_6                                                   44                                             44
3088345 3088345 WI Walworth   school 5516740 6482 Public school Williams Bay 551674000277 30 Williams Bay Middle   Regular School No Middle 06 08 2019   grade_6                                                   57                                             57
3103050 3103050 WI Walworth   school 5516740 6482 Public school Williams Bay 551674000277 30 Williams Bay Middle   Regular School No Middle 06 08 2018   grade_6                                                   50                                             50
126081 126081 WI Waushara   school 5516710 6475 Public school Wild Rose 551671002185 60 Wild Rose High   Regular School No 4.0 06 12 2015   grade_6                                                   33                                             33

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