enrollments

Data source: Big Local News · About: Big Local

567 rows where grade = "pre_kindergarten", state = "WI" and year = 2016 sorted by county

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 567 ✖

grade ✖

  • pre_kindergarten · 567 ✖
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
281739 281739 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
282285 282285 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No 1.0 PK 02 2016   pre_kindergarten                                                   27                                             27
282293 282293 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   2                                             2
283167 283167 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
288369 288369 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No 4.0 PK 12 2016   pre_kindergarten                                                   9                                             9
282539 282539 WI Barron   school 5500870 308 Public school Barron Area 550087000119 160 Woodland Elementary   Regular School No 1.0 PK 04 2016   pre_kindergarten                                                   8                                             8
283252 283252 WI Barron   school 5502130 903 Public school Cameron 550213000256 20 Cameron Elementary   Regular School No 1.0 PK 04 2016   pre_kindergarten                                                   3                                             3
283443 283443 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102805 100 Chetek-Weyerhaeuser Roselawn Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   3                                             3
283835 283835 WI Barron   school 5503090 1260 Public school Cumberland 550309000343 40 Cumberland Elementary   Regular School No 1.0 PK 04 2016   pre_kindergarten                                                   8                                             8
292164 292164 WI Barron   school 5512180 4557 Public school Prairie Farm Public 551218001585 20 Prairie Farm Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
292759 292759 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281000581 25 Tainter Elementary   Regular School No 1.0 PK 04 2016   pre_kindergarten                                                   11                                             11
284206 284206 WI Bayfield   school 5503810 1491 Public school Drummond Area 550381000398 20 Drummond Elementary   Regular School No 1.0 PK 06 2016   pre_kindergarten                                                   1                                             1
282306 282306 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000294 55 Cormier School and Early Learning Center   Regular School No 1.0 PK KG 2016   pre_kindergarten                                                   10                                             10
284009 284009 WI Brown   school 5503210 1414 Public school De Pere 550321002668 100 Susie C Altmayer Elementary   Regular School No 1.0 PK 04 2016   pre_kindergarten                                                   26                                             26
284104 284104 WI Brown   school 5503660 1407 Public school Denmark 550366000346 40 Denmark Early Childhood Ctr   Regular School No 1.0 PK KG 2016   pre_kindergarten                                                   9                                             9
285372 285372 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000610 20 Aldo Leopold Community School K-8   Regular School No 1.0 PK 08 2016   pre_kindergarten                                                   1                                             1
285380 285380 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000611 30 Baird Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
285389 285389 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000612 40 Bay View   Alternative Education School No 4.0 PK 12 2016   pre_kindergarten                                                   15                                             15
285398 285398 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000613 60 Beaumont Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
285414 285414 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000616 140 Danz Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   3                                             3
285438 285438 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002788 130 Early Learning Center   Regular School No 1.0 PK KG 2016   pre_kindergarten                                                   15                                             15
285469 285469 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000622 280 Fort Howard Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   2                                             2
285479 285479 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002589 110 Green Bay Head Start   Regular School No 1.0 PK KG 2016   pre_kindergarten                                                   105                                             105
285488 285488 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000624 320 Howe Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   17                                             17
285497 285497 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000625 340 Jackson Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   10                                             10
285519 285519 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000627 370 Keller Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   37                                             37
285528 285528 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000628 380 Kennedy Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   13                                             13
285537 285537 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000166 390 King Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   2                                             2
285546 285546 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000629 400 Langlade Elementary   Regular School No 1.0 PK 06 2016   pre_kindergarten                                                   7                                             7
285565 285565 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000562 420 Lincoln Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   19                                             19
285585 285585 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000633 435 Martin Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   4                                             4
285593 285593 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002431 437 McAuliffe Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   4                                             4
285601 285601 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000634 440 Nicolet Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
285618 285618 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582001672 160 Red Smith K-8   Regular School No 1.0 PK 08 2016   pre_kindergarten                                                   15                                             15
285650 285650 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000642 680 Webster Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   13                                             13
286102 286102 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663002709 120 Bay Harbor Elementary   Regular School No 1.0 PK 04 2016   pre_kindergarten                                                   2                                             2
286118 286118 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663002409 40 Forest Glen Elementary   Regular School No 1.0 PK 04 2016   pre_kindergarten                                                   9                                             9
286127 286127 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663000719 60 Howard Elementary   Regular School No 1.0 PK 04 2016   pre_kindergarten                                                   3                                             3
286137 286137 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663000718 50 Meadowbrook Elementary   Regular School No 1.0 PK 04 2016   pre_kindergarten                                                   3                                             3
286144 286144 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663000720 100 Suamico Elementary   Regular School No 1.0 PK 04 2016   pre_kindergarten                                                   1                                             1
292254 292254 WI Brown   school 5512330 4613 Public school Pulaski Community 551233001597 40 Glenbrook Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   4                                             4
292263 292263 WI Brown   school 5512330 4613 Public school Pulaski Community 551233001598 50 Hillcrest Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
292272 292272 WI Brown   school 5512330 4613 Public school Pulaski Community 551233001599 60 Lannoye Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   24                                             24
292290 292290 WI Brown   school 5512330 4613 Public school Pulaski Community 551233001601 120 Sunnyside Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
295734 295734 WI Brown   school 5516320 6328 Public school West De Pere 551632002139 140 Westwood Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   20                                             20
296298 296298 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002228 20 Wrightstown Elementary   Regular School No 1.0 PK 04 2016   pre_kindergarten                                                   5                                             5
283615 283615 WI Buffalo   school 5502700 1155 Public school Cochrane-Fountain City 550270000306 20 Cochrane-Fountain City Elementary   Regular School No 1.0 PK 06 2016   pre_kindergarten                                                   2                                             2
285221 285221 WI Buffalo   school 5505370 2142 Public school Gilmanton 550537000573 40 Gilmanton Elementary   Regular School No 1.0 PK 04 2016   pre_kindergarten                                                   3                                             3
290325 290325 WI Buffalo   school 5509780 3668 Public school Mondovi 550978001284 20 Anthony Elementary   Regular School No 1.0 PK PK 2016   pre_kindergarten                                                   3                                             3
285360 285360 WI Burnett   school 5505670 2233 Public school Grantsburg 550567000604 120 Nelson Elementary   Regular School No 1.0 PK KG 2016   pre_kindergarten                                                   7                                             7
293596 293596 WI Burnett   school 5513890 5376 Public school Siren 551389001816 20 Siren Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   7                                             7
295499 295499 WI Burnett   school 5516230 6293 Public school Webster 551623002098 60 Webster Elementary   Regular School No 1.0 PK 04 2016   pre_kindergarten                                                   2                                             2
283032 283032 WI Calumet   school 5501680 658 Public school Brillion 550168000206 20 Brillion Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
283468 283468 WI Calumet   school 5502520 1085 Public school Chilton 550252000278 20 Chilton Elementary   Regular School No 1.0 PK 04 2016   pre_kindergarten                                                   4                                             4
285967 285967 WI Calumet   school 5506450 2534 Public school Hilbert 550645000700 20 Hilbert Elementary   Regular School No 1.0 PK 04 2016   pre_kindergarten                                                   4                                             4
290874 290874 WI Calumet   school 5510530 3941 Public school New Holstein 551053001378 60 New Holstein Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   13                                             13
282932 282932 WI Chippewa   school 5501350 497 Public school Bloomer 550135000183 20 Bloomer Elementary   Regular School No 1.0 PK 04 2016   pre_kindergarten                                                   10                                             10
283187 283187 WI Chippewa   school 5502040 870 Public school Cadott Community 550204000247 20 Cadott Elementary   Regular School No 1.0 PK 06 2016   pre_kindergarten                                                   6                                             6
283511 283511 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255002784 100 Korger-Chestnut   Regular School No 1.0 PK PK 2016   pre_kindergarten                                                   38                                             38
283713 283713 WI Chippewa   school 5502880 1204 Public school Cornell 550288000323 20 Cornell Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   3                                             3
290793 290793 WI Chippewa   school 5510440 3920 Public school New Auburn 551044001362 20 New Auburn Elementary   Regular School No 1.0 PK 06 2016   pre_kindergarten                                                   3                                             3
293883 293883 WI Chippewa   school 5514430 5593 Public school Stanley-Boyd Area 551443001864 20 Boyd Elementary   Regular School No 1.0 PK PK 2016   pre_kindergarten                                                   10                                             10
281722 281722 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
283641 283641 WI Clark   school 5502730 1162 Public school Colby 550273000312 120 Little Stars Pre-School   Regular School No 1.0 PK PK 2016   pre_kindergarten                                                   19                                             19
283646 283646 WI Clark   school   1162 Public Schools-Multidistrict Charters Colby   9100 Rural Virtual Academy charter           2016   pre_kindergarten                                                   1                                             1
287570 287570 WI Clark   school 5508250 3206 Public school Loyal 550825000911 20 Loyal Elementary   Regular School No 1.0 PK 06 2016   pre_kindergarten                                                   2                                             2
291721 291721 WI Clark   school 5511310 4207 Public school Owen-Withee 551131001509 20 Owen-Withee Elementary   Regular School No 1.0 PK 06 2016   pre_kindergarten                                                   3                                             3
283204 283204 WI Columbia   school 5502070 882 Public school Cambria-Friesland 550207000253 60 Cambria Friesland Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   3                                             3
283688 283688 WI Columbia   school 5502820 1183 Public school Columbus 550282000321 80 Columbus Elementary   Regular School No 1.0 PK 03 2016   pre_kindergarten                                                   5                                             5
287528 287528 WI Columbia   school 5508190 3150 Public school Lodi 550819000903 20 Lodi Primary   Regular School No 1.0 PK KG 2016   pre_kindergarten                                                   3                                             3
291764 291764 WI Columbia   school 5511370 4228 Public school Pardeeville Area 551137001517 60 Pardeeville Elementary   Regular School No 1.0 PK 04 2016   pre_kindergarten                                                   4                                             4
292049 292049 WI Columbia   school 5512060 4501 Public school Portage Community 551206002419 120 Endeavor Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
292074 292074 WI Columbia   school 5512060 4501 Public school Portage Community 551206002945 190 Portage Partnering Preschool   Regular School No 1.0 PK 04 2016   pre_kindergarten                                                   7                                             7
292108 292108 WI Columbia   school 5512120 4536 Public school Poynette 551212001577 20 Arlington Elementary   Regular School No 1.0 PK KG 2016   pre_kindergarten                                                   5                                             5
292560 292560 WI Columbia   school 5512420 4634 Public school Randolph 551242001650 20 Randolph Elementary   Regular School No 1.0 PK 08 2016   pre_kindergarten                                                   5                                             5
292824 292824 WI Columbia   school 5512990 4865 Public school Rio Community 551299001712 20 Rio Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   4                                             4
291040 291040 WI Crawford   school 5504980 2016 Public school North Crawford 550498002244 110 North Crawford Elementary   Regular School No 1.0 PK 08 2016   pre_kindergarten                                                   3                                             3
292129 292129 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002508 10 BA Kennedy School   Regular School No 1.0 PK 01 2016   pre_kindergarten                                                   44                                             44
293215 293215 WI Crawford   school 5513470 5124 Public school Seneca 551347001764 60 Seneca Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   5                                             5
295482 295482 WI Crawford   school 5516020 6251 Public school Wauzeka-Steuben 551602002094 20 Wauzeka Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
282639 282639 WI Dane   school 5500990 350 Public school Belleville 550099000131 20 Belleville Elementary   Regular School No 1.0 PK 01 2016   pre_kindergarten                                                   2                                             2
283221 283221 WI Dane   school 5502100 896 Public school Cambridge 550210000254 20 Cambridge Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   6                                             6
283964 283964 WI Dane   school 5503180 1316 Public school De Forest Area 550318002368 100 Holum Education Center   Regular School No 1.0 PK PK 2016   pre_kindergarten                                                   13                                             13
284046 284046 WI Dane   school 5503270 1309 Public school Deerfield Community 550327000370 20 Deerfield Elementary   Regular School No 1.0 PK 06 2016   pre_kindergarten                                                   6                                             6
287617 287617 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002475 190 4K PK Off Site   Regular School No 1.0 PK PK 2016   pre_kindergarten                                                   87                                             87
287683 287683 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852000928 210 Falk Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   18                                             18
287765 287765 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002412 53 Lapham Elementary   Regular School No 1.0 PK 02 2016   pre_kindergarten                                                   12                                             12
287786 287786 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852000921 65 Lindbergh Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
287795 287795 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852000946 495 Lowell Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   10                                             10
287832 287832 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852000940 390 Muir Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   19                                             19
288152 288152 WI Dane   school 5508790 3332 Public school Marshall 550879000569 80 Marshall Early Learning Center   Regular School No 1.0 PK 02 2016   pre_kindergarten                                                   3                                             3
288284 288284 WI Dane   school 5508910 3381 Public school McFarland 550891001033 10 Conrad Elvehjem Early Learning Center   Regular School No 1.0 PK KG 2016   pre_kindergarten                                                   14                                             14
288693 288693 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951001105 40 Elm Lawn Elementary   Regular School No 1.0 PK 04 2016   pre_kindergarten                                                   2                                             2
288717 288717 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951001109 90 Northside Elementary   Regular School No 1.0 PK 04 2016   pre_kindergarten                                                   3                                             3
288724 288724 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951001110 100 Park Elementary   Regular School No 1.0 PK 04 2016   pre_kindergarten                                                   2                                             2
288731 288731 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951001111 120 Sauk Trail Elementary   Regular School No 1.0 PK 04 2016   pre_kindergarten                                                   8                                             8
288738 288738 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951000755 150 Sunset Ridge Elementary   Regular School No 1.0 PK 04 2016   pre_kindergarten                                                   2                                             2
288745 288745 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951001113 160 West Middleton Elementary   Regular School No 1.0 PK 04 2016   pre_kindergarten                                                   3                                             3
290365 290365 WI Dane   school 5509810 3675 Public school Monona Grove 550981000682 120 Taylor Prairie Elementary   Regular School No 1.0 PK 01 2016   pre_kindergarten                                                   7                                             7
290376 290376 WI Dane   school 5509810 3675 Public school Monona Grove 550981002343 80 Winnequah School   Regular School No 1.0 PK 05 2016   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]);