enrollments

Data source: Big Local News · About: Big Local

3,996 rows where grade = "pre_kindergarten" and state = "WI" sorted by ccd_charter_school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • pre_kindergarten · 3,896 ✖
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
114159 114159 WI Dodge   school 5507260 2744 Public school Dodgeland 550726000791 40 Dodgeland Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   11                                             11
114176 114176 WI Iowa   school 5503690 1428 Public school Dodgeville 550369000390 20 Dodgeville Elementary   Regular School No 1.0 PK 04 2015   pre_kindergarten                                                   7                                             7
114241 114241 WI Pepin   school 5503840 1499 Public school Durand 550384000116 20 Arkansaw Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   72                                             72
114254 114254 WI Walworth   school 5504020 1540 Public school East Troy Community 550402000409 20 Doubek Elementary   Regular School No 1.0 PK 01 2015   pre_kindergarten                                                   13                                             13
114317 114317 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002778 120 Main Street School   Special Education School No 1.0 PK PK 2015   pre_kindergarten                                                   110                                             110
114405 114405 WI Marathon   school 5504080 1561 Public school Edgar 550408000440 20 Edgar Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   3                                             3
114423 114423 WI Rock   school 5504110 1568 Public school Edgerton 550411000442 40 Edgerton Community Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   7                                             7
114447 114447 WI Langlade   school 5504170 1582 Public school Elcho 550417000447 20 Elcho Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   3                                             3
114474 114474 WI Trempealeau   school 5504200 1600 Public school Eleva-Strum 550420000451 80 Strum Elementary   Regular School No 1.0 PK 03 2015   pre_kindergarten                                                   2                                             2
114492 114492 WI Dunn   school 5504230 1645 Public school Elk Mound Area 550423000454 60 Mound View Elementary   Regular School No 1.0 PK 04 2015   pre_kindergarten                                                   4                                             4
114526 114526 WI Walworth   school 5504290 1638 Public school Elkhorn Area 550429002529 120 Jackson Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   10                                             10
114535 114535 WI Walworth   school 5504290 1638 Public school Elkhorn Area 550429000461 80 Tibbets Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   1                                             1
114565 114565 WI Pierce   school 5504320 1659 Public school Ellsworth Community 550432000466 80 Lindgren Early Learning Center   Regular School No 1.0 PK PK 2015   pre_kindergarten                                                   13                                             13
114579 114579 WI Waukesha   school 5501770 714 Public school Elmbrook 550177000216 40 Brookfield Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   3                                             3
114587 114587 WI Waukesha   school 5501770 714 Public school Elmbrook 550177000218 80 Burleigh Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   42                                             42
114600 114600 WI Waukesha   school 5501770 714 Public school Elmbrook 550177002367 100 Dixon Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   4                                             4
114625 114625 WI Waukesha   school 5501770 714 Public school Elmbrook 550177001217 190 Swanson Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   7                                             7
114633 114633 WI Waukesha   school 5501770 714 Public school Elmbrook 550177000227 250 Tonawanda Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   2                                             2
114666 114666 WI Washington   school 5504410 1687 Public school Erin 550441000476 20 Erin Elementary   Regular School No 1.0 PK 08 2015   pre_kindergarten                                                   2                                             2
114687 114687 WI Rock   school 5504440 1694 Public school Evansville Community 550444000477 20 Levi Leonard Elementary   Regular School No 1.0 PK 02 2015   pre_kindergarten                                                   10                                             10
114700 114700 WI Eau Claire   school 5504500 1729 Public school Fall Creek 550450000480 20 Fall Creek Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   3                                             3
114718 114718 WI Columbia   school 5504530 1736 Public school Fall River 550453000483 20 Fall River Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   3                                             3
114736 114736 WI Grant   school 5504590 1813 Public school Fennimore Community 550459000485 20 Fennimore Elementary   Regular School No 1.0 PK 06 2015   pre_kindergarten                                                   8                                             8
114773 114773 WI Florence   school 5504650 1855 Public school Florence County 550465000489 40 Florence Elementary   Regular School No 1.0 PK 06 2015   pre_kindergarten                                                   1                                             1
114790 114790 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468000493 30 Chegwin Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   8                                             8
114820 114820 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468000499 200 Lakeshore Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   3                                             3
114837 114837 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468000501 240 Pier Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   25                                             25
114846 114846 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468000497 120 Riverside Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   9                                             9
114855 114855 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468000502 260 Roberts Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   1                                             1
114864 114864 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468000503 280 Rosenow Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   4                                             4
114928 114928 WI Jefferson   school 5504740 1883 Public school Fort Atkinson 550474000513 160 Purdy Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   21                                             21
114948 114948 WI Milwaukee   school 5504800 1890 Public school Fox Point J2 550480000518 40 Stormonth Elementary   Regular School No 1.0 PK 04 2015   pre_kindergarten                                                   4                                             4
114957 114957 WI Milwaukee   school 5504830 1900 Public school Franklin Public 550483000519 20 Ben Franklin Elementary   Regular School No 1.0 PK 06 2015   pre_kindergarten                                                   11                                             11
114966 114966 WI Milwaukee   school 5504830 1900 Public school Franklin Public 550483000520 40 Country Dale Elementary   Regular School No 1.0 PK 06 2015   pre_kindergarten                                                   2                                             2
114994 114994 WI Milwaukee   school 5504830 1900 Public school Franklin Public 550483000524 100 Robinwood Elementary   Regular School No 1.0 PK 06 2015   pre_kindergarten                                                   1                                             1
115003 115003 WI Milwaukee   school 5504830 1900 Public school Franklin Public 550483000151 120 Southwood Glen Elementary   Regular School No 1.0 PK 06 2015   pre_kindergarten                                                   14                                             14
115028 115028 WI Outagamie   school 5504920 1953 Public school Freedom Area 550492000532 20 Freedom Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   9                                             9
115049 115049 WI Washington   school 5512880 4843 Public school Friess Lake 551288001701 20 Friess Lake School   Regular School No 1.0 PK 08 2015   pre_kindergarten                                                   2                                             2
115066 115066 WI Trempealeau   school 5504960 2009 Public school Galesville-Ettrick-Trempealeau 550496000538 60 Galesville Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   3                                             3
115094 115094 WI Walworth   school 5505100 2044 Public school Geneva J4 550510000546 20 Woods Elementary   Regular School No 1.0 PK 08 2015   pre_kindergarten                                                   19                                             19
115101 115101 WI Walworth   school 5505130 2051 Public school Genoa City J2 550513000547 20 Brookwood Elementary   Regular School No 1.0 PK 03 2015   pre_kindergarten                                                   5                                             5
115115 115115 WI Washington   school 5505160 2058 Public school Germantown 550516000549 20 Amy Belle Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   5                                             5
115123 115123 WI Washington   school 5505160 2058 Public school Germantown 550516000550 40 County Line Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   6                                             6
115140 115140 WI Washington   school 5505160 2058 Public school Germantown 550516000555 120 MacArthur Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   5                                             5
115148 115148 WI Washington   school 5505160 2058 Public school Germantown 550516000556 140 Rockfield Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   40                                             40
115157 115157 WI Door   school 5505220 2114 Public school Gibraltar Area 550522002245 100 Gibraltar Elementary   Regular School No 1.0 PK 06 2015   pre_kindergarten                                                   10                                             10
115174 115174 WI Oconto   school 5505250 2128 Public school Gillett 550525000566 60 Gillett Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   3                                             3
115215 115215 WI Buffalo   school 5505370 2142 Public school Gilmanton 550537000573 40 Gilmanton Elementary   Regular School No 1.0 PK 04 2015   pre_kindergarten                                                   2                                             2
115238 115238 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000577 60 Parkway Elementary   Regular School No 1.0 PK 03 2015   pre_kindergarten                                                   7                                             7
115247 115247 WI Saint Croix   school 5505520 2198 Public school Glenwood City 550552000586 60 Glenwood City Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   4                                             4
115284 115284 WI Ozaukee   school 5505610 2217 Public school Grafton 550561002246 20 Grafton Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   12                                             12
115302 115302 WI Ozaukee   school 5505610 2217 Public school Grafton 550561002247 30 Kennedy Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   1                                             1
115311 115311 WI Ozaukee   school 5505610 2217 Public school Grafton 550561002250 100 Woodview Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   1                                             1
115320 115320 WI Clark   school 5505640 2226 Public school Granton Area 550564000599 20 Granton Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   2                                             2
115355 115355 WI Burnett   school 5505670 2233 Public school Grantsburg 550567000604 120 Nelson Elementary   Regular School No 1.0 PK KG 2015   pre_kindergarten                                                   7                                             7
115385 115385 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000612 40 Bay View   Alternative Education School No 4.0 PK 12 2015   pre_kindergarten                                                   23                                             23
115402 115402 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000614 100 Chappell Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   1                                             1
115410 115410 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000616 140 Danz Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   5                                             5
115433 115433 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002788 130 Early Learning Center   Regular School No 1.0 PK KG 2015   pre_kindergarten                                                   20                                             20
115457 115457 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000621 220 Elmore Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   1                                             1
115471 115471 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002965 170 Friedrich Froebel Garden of Early Learning   Regular School No 1.0 PK KG 2015   pre_kindergarten                                                   1                                             1
115474 115474 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002589 110 Green Bay Head Start   Regular School No 1.0 PK KG 2015   pre_kindergarten                                                   120                                             120
115483 115483 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000624 320 Howe Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   17                                             17
115492 115492 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000625 340 Jackson Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   9                                             9
115500 115500 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000626 360 Jefferson Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   1                                             1
115515 115515 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000627 370 Keller Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   52                                             52
115524 115524 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000628 380 Kennedy Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   9                                             9
115533 115533 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000166 390 King Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   1                                             1
115542 115542 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000629 400 Langlade Elementary   Regular School No 1.0 PK 06 2015   pre_kindergarten                                                   5                                             5
115561 115561 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000562 420 Lincoln Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   16                                             16
115574 115574 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000632 430 MacArthur Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   1                                             1
115582 115582 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000633 435 Martin Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   2                                             2
115613 115613 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582001672 160 Red Smith K-8   Regular School No 1.0 PK 08 2015   pre_kindergarten                                                   13                                             13
115626 115626 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000639 590 Sullivan Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   2                                             2
115646 115646 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000642 680 Webster Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   13                                             13
115713 115713 WI Milwaukee   school 5505910 2296 Public school Greendale 550591002256 100 Highland View Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   9                                             9
115724 115724 WI Milwaukee   school 5505940 2303 Public school Greenfield 550594000650 60 Edgewood Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   5                                             5
115733 115733 WI Milwaukee   school 5505940 2303 Public school Greenfield 550594000651 80 Elm Dale Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   3                                             3
115742 115742 WI Milwaukee   school 5505940 2303 Public school Greenfield 550594000652 100 Glenwood Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   1                                             1
115760 115760 WI Milwaukee   school 5505940 2303 Public school Greenfield 550594000655 160 Maple Grove Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   11                                             11
115785 115785 WI Shawano   school 5500056 2415 Public school Gresham 550005602748 100 Gresham Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   2                                             2
115826 115826 WI Waukesha   school 5506030 2420 Public school Hamilton 550603002432 140 Willow Springs Learning Center   Regular School No 1.0 PK PK 2015   pre_kindergarten                                                   20                                             20
115846 115846 WI Washington   school 5506090 2443 Public school Hartford J1 550609000675 40 Lincoln Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   11                                             11
115855 115855 WI Washington   school 5506090 2443 Public school Hartford J1 550609000676 50 Rossman Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   2                                             2
115878 115878 WI Waukesha   school 5506140 2460 Public school Hartland-Lakeside J3 550614002257 20 North Elementary   Regular School No 1.0 PK 02 2015   pre_kindergarten                                                   2                                             2
115921 115921 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627000689 20 Hayward Primary   Regular School No 1.0 PK 02 2015   pre_kindergarten                                                   20                                             20
115971 115971 WI Calumet   school 5506450 2534 Public school Hilbert 550645000700 20 Hilbert Elementary   Regular School No 1.0 PK 04 2015   pre_kindergarten                                                   2                                             2
115990 115990 WI Vernon   school 5506480 2541 Public school Hillsboro 550648000702 20 Hillsboro Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   2                                             2
116017 116017 WI La Crosse   school 5506540 2562 Public school Holmen 550654000709 80 Holmen Public Preschool   Alternative Education School No 1.0 PK PK 2015   pre_kindergarten                                                   20                                             20
116056 116056 WI Dodge   school 5506570 2576 Public school Horicon 550657000711 40 Van Brunt Elementary   Regular School No 1.0 PK 06 2015   pre_kindergarten                                                   3                                             3
116081 116081 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660000714 20 Hortonville Elementary   Regular School No 1.0 PK 04 2015   pre_kindergarten                                                   7                                             7
116098 116098 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002958 160 North Greenville Elementary   Regular School No 1.0 PK 04 2015   pre_kindergarten                                                   11                                             11
116105 116105 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663002709 120 Bay Harbor Elementary   Regular School No 1.0 PK 04 2015   pre_kindergarten                                                   1                                             1
116120 116120 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663002409 40 Forest Glen Elementary   Regular School No 1.0 PK 04 2015   pre_kindergarten                                                   13                                             13
116129 116129 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663000719 60 Howard Elementary   Regular School No 1.0 PK 04 2015   pre_kindergarten                                                   4                                             4
116139 116139 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663000718 50 Meadowbrook Elementary   Regular School No 1.0 PK 04 2015   pre_kindergarten                                                   6                                             6
116146 116146 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663000720 100 Suamico Elementary   Regular School No 1.0 PK 04 2015   pre_kindergarten                                                   6                                             6
116164 116164 WI Sheboygan   school 5506660 2605 Public school Howards Grove 550666000723 110 Northview Elementary   Regular School No 1.0 PK 04 2015   pre_kindergarten                                                   6                                             6
116202 116202 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002735 150 River Crest Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   62                                             62
116226 116226 WI Iron   school 5506750 2618 Public school Hurley 550675000734 80 Hurley Elementary   Regular School No 1.0 PK 06 2015   pre_kindergarten                                                   3                                             3

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