enrollments
Data source: Big Local News · About: Big Local
3,371,677 rows sorted by ccd_school_high_grade descending
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1443045 | 1443045 | NY | Bronx | school | 3601161 | 321200861108 | NYC AUTISM CHARTER-BRONX | 360116106615 | 321200861108 | NYC AUTISM CHARTER SCHOOL BRONX | charter | Special Education School | Yes | Ungraded | UG | UG | 2021 | ungraded_secondary | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
1532992 | 1532992 | NY | Bronx | school | 3601161 | 321200861108 | NYC AUTISM CHARTER-BRONX | 360116106615 | 321200861108 | NYC AUTISM CHARTER SCHOOL BRONX | charter | Special Education School | Yes | Ungraded | UG | UG | 2020 | grade_1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
1532993 | 1532993 | NY | Bronx | school | 3601161 | 321200861108 | NYC AUTISM CHARTER-BRONX | 360116106615 | 321200861108 | NYC AUTISM CHARTER SCHOOL BRONX | charter | Special Education School | Yes | Ungraded | UG | UG | 2020 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
1532994 | 1532994 | NY | Bronx | school | 3601161 | 321200861108 | NYC AUTISM CHARTER-BRONX | 360116106615 | 321200861108 | NYC AUTISM CHARTER SCHOOL BRONX | charter | Special Education School | Yes | Ungraded | UG | UG | 2020 | grade_11 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
1532995 | 1532995 | NY | Bronx | school | 3601161 | 321200861108 | NYC AUTISM CHARTER-BRONX | 360116106615 | 321200861108 | NYC AUTISM CHARTER SCHOOL BRONX | charter | Special Education School | Yes | Ungraded | UG | UG | 2020 | grade_12 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
1532996 | 1532996 | NY | Bronx | school | 3601161 | 321200861108 | NYC AUTISM CHARTER-BRONX | 360116106615 | 321200861108 | NYC AUTISM CHARTER SCHOOL BRONX | charter | Special Education School | Yes | Ungraded | UG | UG | 2020 | grade_2 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
1532997 | 1532997 | NY | Bronx | school | 3601161 | 321200861108 | NYC AUTISM CHARTER-BRONX | 360116106615 | 321200861108 | NYC AUTISM CHARTER SCHOOL BRONX | charter | Special Education School | Yes | Ungraded | UG | UG | 2020 | grade_3 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
1532998 | 1532998 | NY | Bronx | school | 3601161 | 321200861108 | NYC AUTISM CHARTER-BRONX | 360116106615 | 321200861108 | NYC AUTISM CHARTER SCHOOL BRONX | charter | Special Education School | Yes | Ungraded | UG | UG | 2020 | grade_4 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
1532999 | 1532999 | NY | Bronx | school | 3601161 | 321200861108 | NYC AUTISM CHARTER-BRONX | 360116106615 | 321200861108 | NYC AUTISM CHARTER SCHOOL BRONX | charter | Special Education School | Yes | Ungraded | UG | UG | 2020 | grade_5 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
1533000 | 1533000 | NY | Bronx | school | 3601161 | 321200861108 | NYC AUTISM CHARTER-BRONX | 360116106615 | 321200861108 | NYC AUTISM CHARTER SCHOOL BRONX | charter | Special Education School | Yes | Ungraded | UG | UG | 2020 | grade_6 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
1533001 | 1533001 | NY | Bronx | school | 3601161 | 321200861108 | NYC AUTISM CHARTER-BRONX | 360116106615 | 321200861108 | NYC AUTISM CHARTER SCHOOL BRONX | charter | Special Education School | Yes | Ungraded | UG | UG | 2020 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
1533002 | 1533002 | NY | Bronx | school | 3601161 | 321200861108 | NYC AUTISM CHARTER-BRONX | 360116106615 | 321200861108 | NYC AUTISM CHARTER SCHOOL BRONX | charter | Special Education School | Yes | Ungraded | UG | UG | 2020 | grade_8 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
1533003 | 1533003 | NY | Bronx | school | 3601161 | 321200861108 | NYC AUTISM CHARTER-BRONX | 360116106615 | 321200861108 | NYC AUTISM CHARTER SCHOOL BRONX | charter | Special Education School | Yes | Ungraded | UG | UG | 2020 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
1533004 | 1533004 | NY | Bronx | school | 3601161 | 321200861108 | NYC AUTISM CHARTER-BRONX | 360116106615 | 321200861108 | NYC AUTISM CHARTER SCHOOL BRONX | charter | Special Education School | Yes | Ungraded | UG | UG | 2020 | kindergarten_full_day | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
1533005 | 1533005 | NY | Bronx | school | 3601161 | 321200861108 | NYC AUTISM CHARTER-BRONX | 360116106615 | 321200861108 | NYC AUTISM CHARTER SCHOOL BRONX | charter | Special Education School | Yes | Ungraded | UG | UG | 2020 | kindergarten_half_day | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
1533006 | 1533006 | NY | Bronx | school | 3601161 | 321200861108 | NYC AUTISM CHARTER-BRONX | 360116106615 | 321200861108 | NYC AUTISM CHARTER SCHOOL BRONX | charter | Special Education School | Yes | Ungraded | UG | UG | 2020 | pk_12_total | 1.0 | 12.0 | 17.0 | 1.0 | 27.0 | 4.0 | * | 28 | 31 | 31 | 1 | 12 | 17 | 1 | 27 | 4 | 28 | 31 | 31 | |||||||||||||||||||||||||||||||||
1533007 | 1533007 | NY | Bronx | school | 3601161 | 321200861108 | NYC AUTISM CHARTER-BRONX | 360116106615 | 321200861108 | NYC AUTISM CHARTER SCHOOL BRONX | charter | Special Education School | Yes | Ungraded | UG | UG | 2020 | pre_kindergarten_full_day | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
1533008 | 1533008 | NY | Bronx | school | 3601161 | 321200861108 | NYC AUTISM CHARTER-BRONX | 360116106615 | 321200861108 | NYC AUTISM CHARTER SCHOOL BRONX | charter | Special Education School | Yes | Ungraded | UG | UG | 2020 | pre_kindergarten_half_day | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
1533009 | 1533009 | NY | Bronx | school | 3601161 | 321200861108 | NYC AUTISM CHARTER-BRONX | 360116106615 | 321200861108 | NYC AUTISM CHARTER SCHOOL BRONX | charter | Special Education School | Yes | Ungraded | UG | UG | 2020 | ungraded_elementary | 1.0 | 12.0 | 17.0 | 1.0 | 27.0 | 4.0 | * | 28 | 31 | 31 | 1 | 12 | 17 | 1 | 27 | 4 | 28 | 31 | 31 | |||||||||||||||||||||||||||||||||
1533010 | 1533010 | NY | Bronx | school | 3601161 | 321200861108 | NYC AUTISM CHARTER-BRONX | 360116106615 | 321200861108 | NYC AUTISM CHARTER SCHOOL BRONX | charter | Special Education School | Yes | Ungraded | UG | UG | 2020 | ungraded_secondary | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
1675697 | 1675697 | MA | Worcester | school | 2507080 | 162 | Lunenburg | 250708002882 | 1620605 | Lunenburg - Advanced Community Experience Program | Special Education School | No | Ungraded | UG | UG | 2021 | kindergarten | * | * | * | * | * | * | * | * | * | * | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||
1675698 | 1675698 | MA | Worcester | school | 2507080 | 162 | Lunenburg | 250708002882 | 1620605 | Lunenburg - Advanced Community Experience Program | Special Education School | No | Ungraded | UG | UG | 2021 | pre_kindergarten | * | * | * | * | * | * | * | * | * | * | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||
1675699 | 1675699 | MA | Worcester | school | 2507080 | 162 | Lunenburg | 250708002882 | 1620605 | Lunenburg - Advanced Community Experience Program | Special Education School | No | Ungraded | UG | UG | 2021 | grade_1 | * | * | * | * | * | * | * | * | * | * | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||
1675700 | 1675700 | MA | Worcester | school | 2507080 | 162 | Lunenburg | 250708002882 | 1620605 | Lunenburg - Advanced Community Experience Program | Special Education School | No | Ungraded | UG | UG | 2021 | grade_2 | * | * | * | * | * | * | * | * | * | * | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||
1675701 | 1675701 | MA | Worcester | school | 2507080 | 162 | Lunenburg | 250708002882 | 1620605 | Lunenburg - Advanced Community Experience Program | Special Education School | No | Ungraded | UG | UG | 2021 | grade_3 | * | * | * | * | * | * | * | * | * | * | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||
1675702 | 1675702 | MA | Worcester | school | 2507080 | 162 | Lunenburg | 250708002882 | 1620605 | Lunenburg - Advanced Community Experience Program | Special Education School | No | Ungraded | UG | UG | 2021 | grade_4 | * | * | * | * | * | * | * | * | * | * | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||
1675703 | 1675703 | MA | Worcester | school | 2507080 | 162 | Lunenburg | 250708002882 | 1620605 | Lunenburg - Advanced Community Experience Program | Special Education School | No | Ungraded | UG | UG | 2021 | grade_5 | * | * | * | * | * | * | * | * | * | * | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||
1675704 | 1675704 | MA | Worcester | school | 2507080 | 162 | Lunenburg | 250708002882 | 1620605 | Lunenburg - Advanced Community Experience Program | Special Education School | No | Ungraded | UG | UG | 2021 | grade_6 | * | * | * | * | * | * | * | * | * | * | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||
1675705 | 1675705 | MA | Worcester | school | 2507080 | 162 | Lunenburg | 250708002882 | 1620605 | Lunenburg - Advanced Community Experience Program | Special Education School | No | Ungraded | UG | UG | 2021 | grade_7 | * | * | * | * | * | * | * | * | * | * | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||
1675706 | 1675706 | MA | Worcester | school | 2507080 | 162 | Lunenburg | 250708002882 | 1620605 | Lunenburg - Advanced Community Experience Program | Special Education School | No | Ungraded | UG | UG | 2021 | grade_8 | * | * | * | * | * | * | * | * | * | * | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||
1675707 | 1675707 | MA | Worcester | school | 2507080 | 162 | Lunenburg | 250708002882 | 1620605 | Lunenburg - Advanced Community Experience Program | Special Education School | No | Ungraded | UG | UG | 2021 | grade_9 | * | * | * | * | * | * | * | * | * | * | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||
1675708 | 1675708 | MA | Worcester | school | 2507080 | 162 | Lunenburg | 250708002882 | 1620605 | Lunenburg - Advanced Community Experience Program | Special Education School | No | Ungraded | UG | UG | 2021 | grade_10 | * | * | * | * | * | * | * | * | * | * | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||
1675709 | 1675709 | MA | Worcester | school | 2507080 | 162 | Lunenburg | 250708002882 | 1620605 | Lunenburg - Advanced Community Experience Program | Special Education School | No | Ungraded | UG | UG | 2021 | grade_11 | * | * | * | * | * | * | * | * | * | * | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||
1675710 | 1675710 | MA | Worcester | school | 2507080 | 162 | Lunenburg | 250708002882 | 1620605 | Lunenburg - Advanced Community Experience Program | Special Education School | No | Ungraded | UG | UG | 2021 | grade_12 | * | * | * | * | * | * | * | * | * | * | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||
1675711 | 1675711 | MA | Worcester | school | 2507080 | 162 | Lunenburg | 250708002882 | 1620605 | Lunenburg - Advanced Community Experience Program | Special Education School | No | Ungraded | UG | UG | 2021 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | * | * | 4.0 | 4 | |||||||||||||||||||||||||||||||||||||||||
1678338 | 1678338 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002875 | 2810675 | Springfield - Springfield Vocational Academy | Special Education School | No | Ungraded | UG | UG | 2021 | sped_beyond_grade_12 | 13 | 27 | 82 | 0 | 5 | 0 | 0 | 86 | 41 | * | 127.0 | 13 | 27 | 82 | 0 | 5 | 0 | 0 | 86 | 41 | 127 | ||||||||||||||||||||||||||||||||
1877378 | 1877378 | NV | school | 3200120 | 4 | Elko | 320012000854 | 4902 | Elko Adult | Alternative School | No | Ungraded | UG | UG | 2019 | ungraded | 2.0 | 2.0 | 2 | 2 | 2 | 2 | ||||||||||||||||||||||||||||||||||||||||||||||||
1879543 | 1879543 | NV | school | 3200120 | 4 | Elko | 320012000854 | 4902 | Elko Adult | Alternative School | No | Ungraded | UG | UG | 2019 | k_12_total | 0.0 | 0.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 2 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | ||||||||||||||||||||||||||||||||||
2035027 | 2035027 | MS | school | 2801770 | 2400 | HARRISON CO SCHOOL DIST | 280177000289 | 2400020 | HARRISON CO CHILD DEVELOPMENT CEN | Regular School | No | Ungraded | UG | UG | 2020 | pre_kindergarten_spec_ed | 63 | 63 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2035028 | 2035028 | MS | school | 2801770 | 2400 | HARRISON CO SCHOOL DIST | 280177000289 | 2400020 | HARRISON CO CHILD DEVELOPMENT CEN | Regular School | No | Ungraded | UG | UG | 2020 | kindergarten_spec_ed | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||
2035029 | 2035029 | MS | school | 2801770 | 2400 | HARRISON CO SCHOOL DIST | 280177000289 | 2400020 | HARRISON CO CHILD DEVELOPMENT CEN | Regular School | No | Ungraded | UG | UG | 2020 | elementary_spec_ed | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||
2035030 | 2035030 | MS | school | 2801770 | 2400 | HARRISON CO SCHOOL DIST | 280177000289 | 2400020 | HARRISON CO CHILD DEVELOPMENT CEN | Regular School | No | Ungraded | UG | UG | 2020 | secondary_spec_ed | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||
2035031 | 2035031 | MS | school | 2801770 | 2400 | HARRISON CO SCHOOL DIST | 280177000289 | 2400020 | HARRISON CO CHILD DEVELOPMENT CEN | Regular School | No | Ungraded | UG | UG | 2020 | pk_12_total | 32 | 30 | 10 | * | * | 54.0 | 24.0 | 78 | 32 | 30 | 10 | 54 | 24 | 78 | ||||||||||||||||||||||||||||||||||||||||
2036178 | 2036178 | MS | school | 2803480 | 3022 | PASCAGOULA GAUTIER SCHOOL DIST | 280348001161 | 3022062 | EXCEPTIONAL SCHOOL | Regular School | No | Ungraded | UG | UG | 2020 | elementary_spec_ed | 22 | 22 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2036179 | 2036179 | MS | school | 2803480 | 3022 | PASCAGOULA GAUTIER SCHOOL DIST | 280348001161 | 3022062 | EXCEPTIONAL SCHOOL | Regular School | No | Ungraded | UG | UG | 2020 | secondary_spec_ed | 15 | 15 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2036180 | 2036180 | MS | school | 2803480 | 3022 | PASCAGOULA GAUTIER SCHOOL DIST | 280348001161 | 3022062 | EXCEPTIONAL SCHOOL | Regular School | No | Ungraded | UG | UG | 2020 | pk_12_total | 17 | * | * | 26.0 | 11.0 | 37 | 17 | 26 | 11 | 37 | ||||||||||||||||||||||||||||||||||||||||||||
2037275 | 2037275 | MS | school | 2802790 | 4500 | MADISON CO SCHOOL DIST | 280279001318 | 4500002 | MADISON CO PRE SCHOOL | Regular School | No | Ungraded | UG | UG | 2020 | pre_kindergarten_spec_ed | 38 | 38 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2037276 | 2037276 | MS | school | 2802790 | 4500 | MADISON CO SCHOOL DIST | 280279001318 | 4500002 | MADISON CO PRE SCHOOL | Regular School | No | Ungraded | UG | UG | 2020 | pk_12_total | 16 | 18 | * | * | 26.0 | 12.0 | 38 | 16 | 18 | 26 | 12 | 38 | ||||||||||||||||||||||||||||||||||||||||||
2043539 | 2043539 | MA | Worcester | school | 2507080 | 162 | Lunenburg | 250708002882 | 1620605 | Advanced Community Experience Program | Special Education School | No | Ungraded | UG | UG | 2019 | sped_beyond_grade_12 | 7 | 0 | 0 | 0 | 0 | 0 | 1 | 8.0 | 7 | 0 | 0 | 0 | 0 | 0 | 1 | 8 | |||||||||||||||||||||||||||||||||||||
2046156 | 2046156 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002875 | 2810675 | Springfield Vocational Academy | Special Education School | No | Ungraded | UG | UG | 2019 | sped_beyond_grade_12 | 9 | 18 | 65 | 0 | 4 | 0 | 1 | 97.0 | 9 | 18 | 65 | 0 | 4 | 0 | 1 | 97 | |||||||||||||||||||||||||||||||||||||
2156364 | 2156364 | NY | Erie | school | 3605850 | 140600010000 | BUFFALO | 360585000338 | 140600010042 | PS 42 OCCUPATIONAL TRAINING CTR | public | Special Education School | No | Ungraded | UG | UG | 2019 | grade_1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | * | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
2156365 | 2156365 | NY | Erie | school | 3605850 | 140600010000 | BUFFALO | 360585000338 | 140600010042 | PS 42 OCCUPATIONAL TRAINING CTR | public | Special Education School | No | Ungraded | UG | UG | 2019 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | * | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
2156366 | 2156366 | NY | Erie | school | 3605850 | 140600010000 | BUFFALO | 360585000338 | 140600010042 | PS 42 OCCUPATIONAL TRAINING CTR | public | Special Education School | No | Ungraded | UG | UG | 2019 | grade_11 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | * | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
2156367 | 2156367 | NY | Erie | school | 3605850 | 140600010000 | BUFFALO | 360585000338 | 140600010042 | PS 42 OCCUPATIONAL TRAINING CTR | public | Special Education School | No | Ungraded | UG | UG | 2019 | grade_12 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | * | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
2156368 | 2156368 | NY | Erie | school | 3605850 | 140600010000 | BUFFALO | 360585000338 | 140600010042 | PS 42 OCCUPATIONAL TRAINING CTR | public | Special Education School | No | Ungraded | UG | UG | 2019 | grade_2 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | * | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
2156369 | 2156369 | NY | Erie | school | 3605850 | 140600010000 | BUFFALO | 360585000338 | 140600010042 | PS 42 OCCUPATIONAL TRAINING CTR | public | Special Education School | No | Ungraded | UG | UG | 2019 | grade_3 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | * | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
2156370 | 2156370 | NY | Erie | school | 3605850 | 140600010000 | BUFFALO | 360585000338 | 140600010042 | PS 42 OCCUPATIONAL TRAINING CTR | public | Special Education School | No | Ungraded | UG | UG | 2019 | grade_4 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | * | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
2156371 | 2156371 | NY | Erie | school | 3605850 | 140600010000 | BUFFALO | 360585000338 | 140600010042 | PS 42 OCCUPATIONAL TRAINING CTR | public | Special Education School | No | Ungraded | UG | UG | 2019 | grade_5 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | * | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
2156372 | 2156372 | NY | Erie | school | 3605850 | 140600010000 | BUFFALO | 360585000338 | 140600010042 | PS 42 OCCUPATIONAL TRAINING CTR | public | Special Education School | No | Ungraded | UG | UG | 2019 | grade_6 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | * | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
2156373 | 2156373 | NY | Erie | school | 3605850 | 140600010000 | BUFFALO | 360585000338 | 140600010042 | PS 42 OCCUPATIONAL TRAINING CTR | public | Special Education School | No | Ungraded | UG | UG | 2019 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | * | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
2156374 | 2156374 | NY | Erie | school | 3605850 | 140600010000 | BUFFALO | 360585000338 | 140600010042 | PS 42 OCCUPATIONAL TRAINING CTR | public | Special Education School | No | Ungraded | UG | UG | 2019 | grade_8 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | * | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
2156375 | 2156375 | NY | Erie | school | 3605850 | 140600010000 | BUFFALO | 360585000338 | 140600010042 | PS 42 OCCUPATIONAL TRAINING CTR | public | Special Education School | No | Ungraded | UG | UG | 2019 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | * | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
2156376 | 2156376 | NY | Erie | school | 3605850 | 140600010000 | BUFFALO | 360585000338 | 140600010042 | PS 42 OCCUPATIONAL TRAINING CTR | public | Special Education School | No | Ungraded | UG | UG | 2019 | kindergarten_full_day | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | * | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
2156377 | 2156377 | NY | Erie | school | 3605850 | 140600010000 | BUFFALO | 360585000338 | 140600010042 | PS 42 OCCUPATIONAL TRAINING CTR | public | Special Education School | No | Ungraded | UG | UG | 2019 | kindergarten_half_day | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | * | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
2156378 | 2156378 | NY | Erie | school | 3605850 | 140600010000 | BUFFALO | 360585000338 | 140600010042 | PS 42 OCCUPATIONAL TRAINING CTR | public | Special Education School | No | Ungraded | UG | UG | 2019 | pk_12_total | 11.0 | 40.0 | 20.0 | 1.0 | 4.0 | 1.0 | 48.0 | 29.0 | * | * | * | 77 | 11 | 40 | 20 | 1 | 4 | 1 | 48 | 29 | 77 | |||||||||||||||||||||||||||||||
2156379 | 2156379 | NY | Erie | school | 3605850 | 140600010000 | BUFFALO | 360585000338 | 140600010042 | PS 42 OCCUPATIONAL TRAINING CTR | public | Special Education School | No | Ungraded | UG | UG | 2019 | pre_kindergarten_full_day | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | * | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
2156380 | 2156380 | NY | Erie | school | 3605850 | 140600010000 | BUFFALO | 360585000338 | 140600010042 | PS 42 OCCUPATIONAL TRAINING CTR | public | Special Education School | No | Ungraded | UG | UG | 2019 | pre_kindergarten_half_day | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | * | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
2156381 | 2156381 | NY | Erie | school | 3605850 | 140600010000 | BUFFALO | 360585000338 | 140600010042 | PS 42 OCCUPATIONAL TRAINING CTR | public | Special Education School | No | Ungraded | UG | UG | 2019 | ungraded_elementary | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | * | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
2156382 | 2156382 | NY | Erie | school | 3605850 | 140600010000 | BUFFALO | 360585000338 | 140600010042 | PS 42 OCCUPATIONAL TRAINING CTR | public | Special Education School | No | Ungraded | UG | UG | 2019 | ungraded_secondary | 11.0 | 40.0 | 20.0 | 1.0 | 4.0 | 1.0 | 48.0 | 29.0 | * | * | * | 77 | 11 | 40 | 20 | 1 | 4 | 1 | 48 | 29 | 77 | |||||||||||||||||||||||||||||||
2233170 | 2233170 | MA | Worcester | school | 2507080 | 162 | Lunenburg | 250708002882 | 1620605 | Lunenburg: Advanced Community Experience Program | Special Education School | No | Ungraded | UG | UG | 2018 | sped_beyond_grade_12 | 8 | 0 | 0 | 0 | 0 | 0 | 1 | 9.0 | 8 | 0 | 0 | 0 | 0 | 0 | 1 | 9 | |||||||||||||||||||||||||||||||||||||
2236260 | 2236260 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002875 | 2810675 | Springfield: Springfield Vocational Academy | Special Education School | No | Ungraded | UG | UG | 2018 | sped_beyond_grade_12 | 12 | 15 | 63 | 0 | 2 | 0 | 0 | 92.0 | 12 | 15 | 63 | 0 | 2 | 0 | 0 | 92 | |||||||||||||||||||||||||||||||||||||
2239361 | 2239361 | MA | Middlesex | school | 2508790 | 735 | North Middlesex | 250879002705 | 7350515 | North Middlesex: Peter Fitzpatrick School | Regular School | No | Ungraded | UG | UG | 2018 | sped_beyond_grade_12 | 17 | 0 | 0 | 0 | 0 | 0 | 1 | 18.0 | 17 | 0 | 0 | 0 | 0 | 0 | 1 | 18 | |||||||||||||||||||||||||||||||||||||
2241551 | 2241551 | MS | school | 2801770 | 2400 | HARRISON CO SCHOOL DIST | 280177000289 | 2400020 | HARRISON CO CHILD DEVELOPMENT CEN | Regular School | No | Ungraded | UG | UG | 2021 | pre_kindergarten_spec_ed | 46 | 46 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2241552 | 2241552 | MS | school | 2801770 | 2400 | HARRISON CO SCHOOL DIST | 280177000289 | 2400020 | HARRISON CO CHILD DEVELOPMENT CEN | Regular School | No | Ungraded | UG | UG | 2021 | kindergarten_spec_ed | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||
2241553 | 2241553 | MS | school | 2801770 | 2400 | HARRISON CO SCHOOL DIST | 280177000289 | 2400020 | HARRISON CO CHILD DEVELOPMENT CEN | Regular School | No | Ungraded | UG | UG | 2021 | elementary_spec_ed | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||
2241554 | 2241554 | MS | school | 2801770 | 2400 | HARRISON CO SCHOOL DIST | 280177000289 | 2400020 | HARRISON CO CHILD DEVELOPMENT CEN | Regular School | No | Ungraded | UG | UG | 2021 | secondary_spec_ed | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||
2241555 | 2241555 | MS | school | 2801770 | 2400 | HARRISON CO SCHOOL DIST | 280177000289 | 2400020 | HARRISON CO CHILD DEVELOPMENT CEN | Regular School | No | Ungraded | UG | UG | 2021 | pk_12_total | 30 | 13 | * | * | * | 42 | 14 | 56 | 30 | 13 | 42 | 14 | 56 | |||||||||||||||||||||||||||||||||||||||||
2242686 | 2242686 | MS | school | 2803480 | 3022 | PASCAGOULA GAUTIER SCHOOL DIST | 280348001161 | 3022062 | EXCEPTIONAL SCHOOL | Regular School | No | Ungraded | UG | UG | 2021 | kindergarten_spec_ed | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||
2242687 | 2242687 | MS | school | 2803480 | 3022 | PASCAGOULA GAUTIER SCHOOL DIST | 280348001161 | 3022062 | EXCEPTIONAL SCHOOL | Regular School | No | Ungraded | UG | UG | 2021 | elementary_spec_ed | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||
2242688 | 2242688 | MS | school | 2803480 | 3022 | PASCAGOULA GAUTIER SCHOOL DIST | 280348001161 | 3022062 | EXCEPTIONAL SCHOOL | Regular School | No | Ungraded | UG | UG | 2021 | secondary_spec_ed | 18 | 18 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2242689 | 2242689 | MS | school | 2803480 | 3022 | PASCAGOULA GAUTIER SCHOOL DIST | 280348001161 | 3022062 | EXCEPTIONAL SCHOOL | Regular School | No | Ungraded | UG | UG | 2021 | pk_12_total | * | 13 | * | * | * | 35 | 13 | 35 | ||||||||||||||||||||||||||||||||||||||||||||||
2242918 | 2242918 | MS | school | 2801192 | 3475 | ELLISVILLE STATE SCHOOL ADM | 280119201198 | 3475004 | ELLISVILLE STATE SCHOOL | Regular School | No | Ungraded | UG | UG | 2021 | secondary_spec_ed | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||
2242919 | 2242919 | MS | school | 2801192 | 3475 | ELLISVILLE STATE SCHOOL ADM | 280119201198 | 3475004 | ELLISVILLE STATE SCHOOL | Regular School | No | Ungraded | UG | UG | 2021 | pk_12_total | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||||||
2243769 | 2243769 | MS | school | 2802790 | 4500 | MADISON CO SCHOOL DIST | 280279001318 | 4500002 | MADISON CO PRE SCHOOL | Regular School | No | Ungraded | UG | UG | 2021 | pre_kindergarten_spec_ed | 40 | 40 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2243770 | 2243770 | MS | school | 2802790 | 4500 | MADISON CO SCHOOL DIST | 280279001318 | 4500002 | MADISON CO PRE SCHOOL | Regular School | No | Ungraded | UG | UG | 2021 | pk_12_total | 14 | 21 | * | * | 28 | 12 | 40 | 14 | 21 | 28 | 12 | 40 | ||||||||||||||||||||||||||||||||||||||||||
2245036 | 2245036 | MS | school | 2801196 | 6177 | HUDSPETH CENTER ADMINISTRATION | 280119601210 | 6177004 | C B NOBLIN SCHOOL | Regular School | No | Ungraded | UG | UG | 2021 | elementary_spec_ed | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||
2245037 | 2245037 | MS | school | 2801196 | 6177 | HUDSPETH CENTER ADMINISTRATION | 280119601210 | 6177004 | C B NOBLIN SCHOOL | Regular School | No | Ungraded | UG | UG | 2021 | secondary_spec_ed | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||
2245038 | 2245038 | MS | school | 2801196 | 6177 | HUDSPETH CENTER ADMINISTRATION | 280119601210 | 6177004 | C B NOBLIN SCHOOL | Regular School | No | Ungraded | UG | UG | 2021 | pk_12_total | * | * | * | * | 11 | 11 | ||||||||||||||||||||||||||||||||||||||||||||||||
3994 | 3994 | GA | school | 1301560 | 640 | Crisp County | 130156000772 | 5050 | Crisp County Pre-K | Regular School | No | 1 | PK | PK | 2015 | fall | pk_12_total | 96 | 160 | 16 | 0 | 4 | 0 | 4 | 135 | 145 | 280 | 96 | 160 | 16 | 0 | 4 | 0 | 4 | 135 | 145 | 280 | |||||||||||||||||||||||||||||||||
3996 | 3996 | GA | school | 1301560 | 640 | Crisp County | 130156000772 | 5050 | Crisp County Pre-K | Regular School | No | 1 | PK | PK | 2015 | fall | pre_kindergarten | 96 | 160 | 16 | 0 | 4 | 0 | 4 | 135 | 145 | 280 | 96 | 160 | 16 | 0 | 4 | 0 | 4 | 135 | 145 | 280 | |||||||||||||||||||||||||||||||||
5592 | 5592 | GA | school | 1302010 | 652 | Elbert County | 130201004085 | 113 | Paul J. Blackwell Learning Center | Regular School | No | 1 | PK | PK | 2015 | fall | pk_12_total | 70 | 87 | 17 | 0 | 2 | 0 | 8 | 108 | 76 | 184 | 70 | 87 | 17 | 0 | 2 | 0 | 8 | 108 | 76 | 184 | |||||||||||||||||||||||||||||||||
5593 | 5593 | GA | school | 1302010 | 652 | Elbert County | 130201004085 | 113 | Paul J. Blackwell Learning Center | Regular School | No | 1 | PK | PK | 2015 | fall | pre_kindergarten | 70 | 87 | 17 | 0 | 2 | 0 | 8 | 108 | 76 | 184 | 70 | 87 | 17 | 0 | 2 | 0 | 8 | 108 | 76 | 184 | |||||||||||||||||||||||||||||||||
7996 | 7996 | GA | school | 1302550 | 667 | Gwinnett County | 130255002268 | 299 | T. Carl Buice School | Regular School | No | 1 | PK | PK | 2015 | fall | pk_12_total | 22 | 7 | 18 | 0 | 3 | 0 | 3 | 40 | 13 | 53 | 22 | 7 | 18 | 0 | 3 | 0 | 3 | 40 | 13 | 53 | |||||||||||||||||||||||||||||||||
8076 | 8076 | GA | school | 1302550 | 667 | Gwinnett County | 130255002268 | 299 | T. Carl Buice School | Regular School | No | 1 | PK | PK | 2015 | fall | pre_kindergarten | 22 | 7 | 18 | 0 | 3 | 0 | 3 | 40 | 13 | 53 | 22 | 7 | 18 | 0 | 3 | 0 | 3 | 40 | 13 | 53 | |||||||||||||||||||||||||||||||||
16763 | 16763 | PA | Allegheny | 42003 | school | 4219170 | 102027451 | SD | Pittsburgh SD | 421917000928 | 7913 | Pittsburgh Chartiers Early Childhood Ctr | Regular School | No | Prekindergarten | PK | PK | 2021 | 1-Oct | grade_1 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
16797 | 16797 | PA | Allegheny | 42003 | school | 4219170 | 102027451 | SD | Pittsburgh SD | 421917000922 | 7916 | Pittsburgh Spring Garden Early Childhood | Regular School | No | Prekindergarten | PK | PK | 2021 | 1-Oct | grade_1 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
20079 | 20079 | PA | Allegheny | 42003 | school | 4219170 | 102027451 | SD | Pittsburgh SD | 421917000928 | 7913 | Pittsburgh Chartiers Early Childhood Ctr | Regular School | No | Prekindergarten | PK | PK | 2021 | 1-Oct | grade_2 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
20113 | 20113 | PA | Allegheny | 42003 | school | 4219170 | 102027451 | SD | Pittsburgh SD | 421917000922 | 7916 | Pittsburgh Spring Garden Early Childhood | Regular School | No | Prekindergarten | PK | PK | 2021 | 1-Oct | grade_2 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
23395 | 23395 | PA | Allegheny | 42003 | school | 4219170 | 102027451 | SD | Pittsburgh SD | 421917000928 | 7913 | Pittsburgh Chartiers Early Childhood Ctr | Regular School | No | Prekindergarten | PK | PK | 2021 | 1-Oct | grade_3 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
23429 | 23429 | PA | Allegheny | 42003 | school | 4219170 | 102027451 | SD | Pittsburgh SD | 421917000922 | 7916 | Pittsburgh Spring Garden Early Childhood | Regular School | No | Prekindergarten | PK | PK | 2021 | 1-Oct | grade_3 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
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]);