enrollments
Data source: Big Local News · About: Big Local
75,136 rows where state = "SD" sorted by ccd_school_type descending
This data as json, CSV (advanced)
grade ✖
- grade_1 4,696
- grade_10 4,696
- grade_11 4,696
- grade_12 4,696
- grade_2 4,696
- grade_3 4,696
- grade_4 4,696
- grade_5 4,696
- grade_6 4,696
- grade_7 4,696
- grade_8 4,696
- grade_9 4,696
- k_12_total 4,696
- kindergarten 4,696
- pk_12_total 4,696
- pre_kindergarten 4,696
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2969514 | 2969514 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001305 | 37 | Career and Technical Education Academy | Vocational Education School | No | 3 | 09 | 12 | 2015 | grade_1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2969548 | 2969548 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001344 | 65 | Spanish Immersion Elementary | Vocational Education School | No | 1 | KG | 05 | 2015 | grade_1 | 65.0 | 2.0 | 9.0 | 1.0 | 1.0 | 0.0 | 2.0 | 40.0 | 40.0 | 80.0 | 65 | 2 | 9 | 1 | 1 | 0 | 2 | 40 | 40 | 80 | ||||||||||||||||||||||||||||||||||
2969559 | 2969559 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001305 | 37 | Career and Technical Education Academy | Vocational Education School | No | 3 | 09 | 12 | 2015 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2969593 | 2969593 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001344 | 65 | Spanish Immersion Elementary | Vocational Education School | No | 1 | KG | 05 | 2015 | 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 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
2969604 | 2969604 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001305 | 37 | Career and Technical Education Academy | Vocational Education School | No | 3 | 09 | 12 | 2015 | grade_11 | 3.0 | 0.0 | 1.0 | 2.0 | 3.0 | 3 | 0 | 1 | 2 | 3 | ||||||||||||||||||||||||||||||||||||||||||||
2969638 | 2969638 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001344 | 65 | Spanish Immersion Elementary | Vocational Education School | No | 1 | KG | 05 | 2015 | 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 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
2969649 | 2969649 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001305 | 37 | Career and Technical Education Academy | Vocational Education School | No | 3 | 09 | 12 | 2015 | grade_12 | 9.0 | 1.0 | 5.0 | 5.0 | 10.0 | 9 | 1 | 5 | 5 | 10 | ||||||||||||||||||||||||||||||||||||||||||||
2969683 | 2969683 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001344 | 65 | Spanish Immersion Elementary | Vocational Education School | No | 1 | KG | 05 | 2015 | 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 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
2969694 | 2969694 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001305 | 37 | Career and Technical Education Academy | Vocational Education School | No | 3 | 09 | 12 | 2015 | grade_2 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2969728 | 2969728 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001344 | 65 | Spanish Immersion Elementary | Vocational Education School | No | 1 | KG | 05 | 2015 | grade_2 | 72.0 | 0.0 | 7.0 | 2.0 | 1.0 | 1.0 | 3.0 | 38.0 | 48.0 | 86.0 | 72 | 0 | 7 | 2 | 1 | 1 | 3 | 38 | 48 | 86 | ||||||||||||||||||||||||||||||||||
2969739 | 2969739 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001305 | 37 | Career and Technical Education Academy | Vocational Education School | No | 3 | 09 | 12 | 2015 | grade_3 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2969773 | 2969773 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001344 | 65 | Spanish Immersion Elementary | Vocational Education School | No | 1 | KG | 05 | 2015 | grade_3 | 54.0 | 2.0 | 9.0 | 0.0 | 1.0 | 0.0 | 1.0 | 35.0 | 32.0 | 67.0 | 54 | 2 | 9 | 0 | 1 | 0 | 1 | 35 | 32 | 67 | ||||||||||||||||||||||||||||||||||
2969784 | 2969784 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001305 | 37 | Career and Technical Education Academy | Vocational Education School | No | 3 | 09 | 12 | 2015 | grade_4 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2969818 | 2969818 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001344 | 65 | Spanish Immersion Elementary | Vocational Education School | No | 1 | KG | 05 | 2015 | grade_4 | 32.0 | 1.0 | 4.0 | 0.0 | 1.0 | 0.0 | 1.0 | 22.0 | 17.0 | 39.0 | 32 | 1 | 4 | 0 | 1 | 0 | 1 | 22 | 17 | 39 | ||||||||||||||||||||||||||||||||||
2969829 | 2969829 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001305 | 37 | Career and Technical Education Academy | Vocational Education School | No | 3 | 09 | 12 | 2015 | grade_5 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2969863 | 2969863 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001344 | 65 | Spanish Immersion Elementary | Vocational Education School | No | 1 | KG | 05 | 2015 | grade_5 | 36.0 | 1.0 | 0.0 | 1.0 | 0.0 | 0.0 | 2.0 | 14.0 | 26.0 | 40.0 | 36 | 1 | 0 | 1 | 0 | 0 | 2 | 14 | 26 | 40 | ||||||||||||||||||||||||||||||||||
2969874 | 2969874 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001305 | 37 | Career and Technical Education Academy | Vocational Education School | No | 3 | 09 | 12 | 2015 | grade_6 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2969908 | 2969908 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001344 | 65 | Spanish Immersion Elementary | Vocational Education School | No | 1 | KG | 05 | 2015 | 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 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
2969919 | 2969919 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001305 | 37 | Career and Technical Education Academy | Vocational Education School | No | 3 | 09 | 12 | 2015 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2969953 | 2969953 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001344 | 65 | Spanish Immersion Elementary | Vocational Education School | No | 1 | KG | 05 | 2015 | 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 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
2969964 | 2969964 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001305 | 37 | Career and Technical Education Academy | Vocational Education School | No | 3 | 09 | 12 | 2015 | grade_8 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2969998 | 2969998 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001344 | 65 | Spanish Immersion Elementary | Vocational Education School | No | 1 | KG | 05 | 2015 | 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 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
2970009 | 2970009 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001305 | 37 | Career and Technical Education Academy | Vocational Education School | No | 3 | 09 | 12 | 2015 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2970043 | 2970043 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001344 | 65 | Spanish Immersion Elementary | Vocational Education School | No | 1 | KG | 05 | 2015 | 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 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
2970054 | 2970054 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001305 | 37 | Career and Technical Education Academy | Vocational Education School | No | 3 | 09 | 12 | 2015 | k_12_total | 12.0 | 1.0 | 6.0 | 7.0 | 0.0 | 13.0 | 12 | 1 | 6 | 7 | 13 | |||||||||||||||||||||||||||||||||||||||||||
2970088 | 2970088 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001344 | 65 | Spanish Immersion Elementary | Vocational Education School | No | 1 | KG | 05 | 2015 | k_12_total | 351.0 | 8.0 | 34.0 | 4.0 | 5.0 | 1.0 | 16.0 | 211.0 | 208.0 | 0.2 | 419.0 | 351 | 8 | 34 | 4 | 5 | 1 | 16 | 211 | 208 | 419 | |||||||||||||||||||||||||||||||||
2970099 | 2970099 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001305 | 37 | Career and Technical Education Academy | Vocational Education School | No | 3 | 09 | 12 | 2015 | kindergarten | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2970133 | 2970133 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001344 | 65 | Spanish Immersion Elementary | Vocational Education School | No | 1 | KG | 05 | 2015 | kindergarten | 92.0 | 2.0 | 5.0 | 0.0 | 1.0 | 0.0 | 7.0 | 62.0 | 45.0 | 107.0 | 92 | 2 | 5 | 0 | 1 | 0 | 7 | 62 | 45 | 107 | ||||||||||||||||||||||||||||||||||
2970144 | 2970144 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001305 | 37 | Career and Technical Education Academy | Vocational Education School | No | 3 | 09 | 12 | 2015 | pk_12_total | 12.0 | 1.0 | 6.0 | 7.0 | 13.0 | 12 | 1 | 6 | 7 | 13 | ||||||||||||||||||||||||||||||||||||||||||||
2970178 | 2970178 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001344 | 65 | Spanish Immersion Elementary | Vocational Education School | No | 1 | KG | 05 | 2015 | pk_12_total | 351.0 | 8.0 | 34.0 | 4.0 | 5.0 | 1.0 | 16.0 | 211.0 | 208.0 | 419.0 | 351 | 8 | 34 | 4 | 5 | 1 | 16 | 211 | 208 | 419 | ||||||||||||||||||||||||||||||||||
2970189 | 2970189 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001305 | 37 | Career and Technical Education Academy | Vocational Education School | No | 3 | 09 | 12 | 2015 | pre_kindergarten | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2970223 | 2970223 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001344 | 65 | Spanish Immersion Elementary | Vocational Education School | No | 1 | KG | 05 | 2015 | pre_kindergarten | 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 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
3352114 | 3352114 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001305 | 37 | Career and Technical Education Academy | Vocational Education School | No | 3 | 09 | 12 | 2016 | grade_1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
3352145 | 3352145 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001344 | 65 | Spanish Immersion Elementary | Vocational Education School | No | 1 | KG | 05 | 2016 | grade_1 | 88.0 | 2.0 | 5.0 | 2.0 | 1.0 | 0.0 | 7.0 | 57.0 | 48.0 | 105.0 | 88 | 2 | 5 | 2 | 1 | 0 | 7 | 57 | 48 | 105 | ||||||||||||||||||||||||||||||||||
3352157 | 3352157 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001305 | 37 | Career and Technical Education Academy | Vocational Education School | No | 3 | 09 | 12 | 2016 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
3352188 | 3352188 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001344 | 65 | Spanish Immersion Elementary | Vocational Education School | No | 1 | KG | 05 | 2016 | 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 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
3352200 | 3352200 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001305 | 37 | Career and Technical Education Academy | Vocational Education School | No | 3 | 09 | 12 | 2016 | grade_11 | 1.0 | 0.0 | 1.0 | 0.0 | 1.0 | 1 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||||||||||||
3352231 | 3352231 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001344 | 65 | Spanish Immersion Elementary | Vocational Education School | No | 1 | KG | 05 | 2016 | 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 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
3352243 | 3352243 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001305 | 37 | Career and Technical Education Academy | Vocational Education School | No | 3 | 09 | 12 | 2016 | grade_12 | 17.0 | 1.0 | 16.0 | 2.0 | 18.0 | 17 | 1 | 16 | 2 | 18 | ||||||||||||||||||||||||||||||||||||||||||||
3352274 | 3352274 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001344 | 65 | Spanish Immersion Elementary | Vocational Education School | No | 1 | KG | 05 | 2016 | 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 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
3352286 | 3352286 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001305 | 37 | Career and Technical Education Academy | Vocational Education School | No | 3 | 09 | 12 | 2016 | grade_2 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
3352317 | 3352317 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001344 | 65 | Spanish Immersion Elementary | Vocational Education School | No | 1 | KG | 05 | 2016 | grade_2 | 61.0 | 2.0 | 9.0 | 0.0 | 0.0 | 0.0 | 3.0 | 36.0 | 39.0 | 75.0 | 61 | 2 | 9 | 0 | 0 | 0 | 3 | 36 | 39 | 75 | ||||||||||||||||||||||||||||||||||
3352329 | 3352329 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001305 | 37 | Career and Technical Education Academy | Vocational Education School | No | 3 | 09 | 12 | 2016 | grade_3 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
3352360 | 3352360 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001344 | 65 | Spanish Immersion Elementary | Vocational Education School | No | 1 | KG | 05 | 2016 | grade_3 | 69.0 | 0.0 | 7.0 | 1.0 | 1.0 | 1.0 | 4.0 | 37.0 | 46.0 | 83.0 | 69 | 0 | 7 | 1 | 1 | 1 | 4 | 37 | 46 | 83 | ||||||||||||||||||||||||||||||||||
3352372 | 3352372 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001305 | 37 | Career and Technical Education Academy | Vocational Education School | No | 3 | 09 | 12 | 2016 | grade_4 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
3352403 | 3352403 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001344 | 65 | Spanish Immersion Elementary | Vocational Education School | No | 1 | KG | 05 | 2016 | grade_4 | 49.0 | 2.0 | 9.0 | 0.0 | 0.0 | 0.0 | 2.0 | 33.0 | 29.0 | 62.0 | 49 | 2 | 9 | 0 | 0 | 0 | 2 | 33 | 29 | 62 | ||||||||||||||||||||||||||||||||||
3352415 | 3352415 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001305 | 37 | Career and Technical Education Academy | Vocational Education School | No | 3 | 09 | 12 | 2016 | grade_5 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
3352446 | 3352446 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001344 | 65 | Spanish Immersion Elementary | Vocational Education School | No | 1 | KG | 05 | 2016 | grade_5 | 30.0 | 0.0 | 4.0 | 0.0 | 2.0 | 0.0 | 1.0 | 20.0 | 17.0 | 37.0 | 30 | 0 | 4 | 0 | 2 | 0 | 1 | 20 | 17 | 37 | ||||||||||||||||||||||||||||||||||
3352458 | 3352458 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001305 | 37 | Career and Technical Education Academy | Vocational Education School | No | 3 | 09 | 12 | 2016 | grade_6 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
3352489 | 3352489 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001344 | 65 | Spanish Immersion Elementary | Vocational Education School | No | 1 | KG | 05 | 2016 | 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 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
3352501 | 3352501 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001305 | 37 | Career and Technical Education Academy | Vocational Education School | No | 3 | 09 | 12 | 2016 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
3352532 | 3352532 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001344 | 65 | Spanish Immersion Elementary | Vocational Education School | No | 1 | KG | 05 | 2016 | 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 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
3352544 | 3352544 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001305 | 37 | Career and Technical Education Academy | Vocational Education School | No | 3 | 09 | 12 | 2016 | grade_8 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
3352575 | 3352575 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001344 | 65 | Spanish Immersion Elementary | Vocational Education School | No | 1 | KG | 05 | 2016 | 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 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
3352587 | 3352587 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001305 | 37 | Career and Technical Education Academy | Vocational Education School | No | 3 | 09 | 12 | 2016 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
3352618 | 3352618 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001344 | 65 | Spanish Immersion Elementary | Vocational Education School | No | 1 | KG | 05 | 2016 | 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 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
3352630 | 3352630 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001305 | 37 | Career and Technical Education Academy | Vocational Education School | No | 3 | 09 | 12 | 2016 | k_12_total | 18.0 | 1.0 | 17.0 | 2.0 | 0.0 | 19.0 | 18 | 1 | 17 | 2 | 19 | |||||||||||||||||||||||||||||||||||||||||||
3352661 | 3352661 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001344 | 65 | Spanish Immersion Elementary | Vocational Education School | No | 1 | KG | 05 | 2016 | k_12_total | 388.0 | 7.0 | 47.0 | 4.0 | 4.0 | 1.0 | 19.0 | 231.0 | 239.0 | 0.2 | 470.0 | 388 | 7 | 47 | 4 | 4 | 1 | 19 | 231 | 239 | 470 | |||||||||||||||||||||||||||||||||
3352673 | 3352673 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001305 | 37 | Career and Technical Education Academy | Vocational Education School | No | 3 | 09 | 12 | 2016 | kindergarten | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
3352704 | 3352704 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001344 | 65 | Spanish Immersion Elementary | Vocational Education School | No | 1 | KG | 05 | 2016 | kindergarten | 91.0 | 1.0 | 13.0 | 1.0 | 0.0 | 0.0 | 2.0 | 48.0 | 60.0 | 108.0 | 91 | 1 | 13 | 1 | 0 | 0 | 2 | 48 | 60 | 108 | ||||||||||||||||||||||||||||||||||
3352716 | 3352716 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001305 | 37 | Career and Technical Education Academy | Vocational Education School | No | 3 | 09 | 12 | 2016 | pk_12_total | 18.0 | 1.0 | 17.0 | 2.0 | 19.0 | 18 | 1 | 17 | 2 | 19 | ||||||||||||||||||||||||||||||||||||||||||||
3352747 | 3352747 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001344 | 65 | Spanish Immersion Elementary | Vocational Education School | No | 1 | KG | 05 | 2016 | pk_12_total | 388.0 | 7.0 | 47.0 | 4.0 | 4.0 | 1.0 | 19.0 | 231.0 | 239.0 | 470.0 | 388 | 7 | 47 | 4 | 4 | 1 | 19 | 231 | 239 | 470 | ||||||||||||||||||||||||||||||||||
3352759 | 3352759 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001305 | 37 | Career and Technical Education Academy | Vocational Education School | No | 3 | 09 | 12 | 2016 | pre_kindergarten | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
3352790 | 3352790 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001344 | 65 | Spanish Immersion Elementary | Vocational Education School | No | 1 | KG | 05 | 2016 | pre_kindergarten | 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 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
2968670 | 2968670 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001072 | 64 | Jefferson Building | Special Education School | No | 4 | PK | 12 | 2015 | grade_1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2968672 | 2968672 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001341 | 44 | Lincoln Building | Special Education School | No | 3 | 12 | 12 | 2015 | grade_1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2968695 | 2968695 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001072 | 64 | Jefferson Building | Special Education School | No | 4 | PK | 12 | 2015 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2968697 | 2968697 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001341 | 44 | Lincoln Building | Special Education School | No | 3 | 12 | 12 | 2015 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2968720 | 2968720 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001072 | 64 | Jefferson Building | Special Education School | No | 4 | PK | 12 | 2015 | grade_11 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2968722 | 2968722 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001341 | 44 | Lincoln Building | Special Education School | No | 3 | 12 | 12 | 2015 | grade_11 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2968745 | 2968745 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001072 | 64 | Jefferson Building | Special Education School | No | 4 | PK | 12 | 2015 | grade_12 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2968747 | 2968747 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001341 | 44 | Lincoln Building | Special Education School | No | 3 | 12 | 12 | 2015 | grade_12 | 24.0 | 1.0 | 1.0 | 16.0 | 10.0 | 26.0 | 24 | 1 | 1 | 16 | 10 | 26 | ||||||||||||||||||||||||||||||||||||||||||
2968770 | 2968770 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001072 | 64 | Jefferson Building | Special Education School | No | 4 | PK | 12 | 2015 | grade_2 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2968772 | 2968772 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001341 | 44 | Lincoln Building | Special Education School | No | 3 | 12 | 12 | 2015 | grade_2 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2968795 | 2968795 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001072 | 64 | Jefferson Building | Special Education School | No | 4 | PK | 12 | 2015 | grade_3 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2968797 | 2968797 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001341 | 44 | Lincoln Building | Special Education School | No | 3 | 12 | 12 | 2015 | grade_3 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2968820 | 2968820 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001072 | 64 | Jefferson Building | Special Education School | No | 4 | PK | 12 | 2015 | grade_4 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2968822 | 2968822 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001341 | 44 | Lincoln Building | Special Education School | No | 3 | 12 | 12 | 2015 | grade_4 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2968845 | 2968845 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001072 | 64 | Jefferson Building | Special Education School | No | 4 | PK | 12 | 2015 | grade_5 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2968847 | 2968847 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001341 | 44 | Lincoln Building | Special Education School | No | 3 | 12 | 12 | 2015 | grade_5 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2968870 | 2968870 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001072 | 64 | Jefferson Building | Special Education School | No | 4 | PK | 12 | 2015 | grade_6 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2968872 | 2968872 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001341 | 44 | Lincoln Building | Special Education School | No | 3 | 12 | 12 | 2015 | grade_6 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2968895 | 2968895 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001072 | 64 | Jefferson Building | Special Education School | No | 4 | PK | 12 | 2015 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2968897 | 2968897 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001341 | 44 | Lincoln Building | Special Education School | No | 3 | 12 | 12 | 2015 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2968920 | 2968920 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001072 | 64 | Jefferson Building | Special Education School | No | 4 | PK | 12 | 2015 | grade_8 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2968922 | 2968922 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001341 | 44 | Lincoln Building | Special Education School | No | 3 | 12 | 12 | 2015 | grade_8 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2968945 | 2968945 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001072 | 64 | Jefferson Building | Special Education School | No | 4 | PK | 12 | 2015 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2968947 | 2968947 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001341 | 44 | Lincoln Building | Special Education School | No | 3 | 12 | 12 | 2015 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2968970 | 2968970 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001072 | 64 | Jefferson Building | Special Education School | No | 4 | PK | 12 | 2015 | k_12_total | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2968972 | 2968972 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001341 | 44 | Lincoln Building | Special Education School | No | 3 | 12 | 12 | 2015 | k_12_total | 24.0 | 1.0 | 1.0 | 16.0 | 10.0 | 0.0 | 26.0 | 24 | 1 | 1 | 16 | 10 | 26 | |||||||||||||||||||||||||||||||||||||||||
2968995 | 2968995 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001072 | 64 | Jefferson Building | Special Education School | No | 4 | PK | 12 | 2015 | kindergarten | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2968997 | 2968997 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001341 | 44 | Lincoln Building | Special Education School | No | 3 | 12 | 12 | 2015 | kindergarten | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2969020 | 2969020 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001072 | 64 | Jefferson Building | Special Education School | No | 4 | PK | 12 | 2015 | pk_12_total | 17.0 | 5.0 | 2.0 | 16.0 | 8.0 | 24.0 | 17 | 5 | 2 | 16 | 8 | 24 | ||||||||||||||||||||||||||||||||||||||||||
2969022 | 2969022 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001341 | 44 | Lincoln Building | Special Education School | No | 3 | 12 | 12 | 2015 | pk_12_total | 24.0 | 1.0 | 1.0 | 16.0 | 10.0 | 26.0 | 24 | 1 | 1 | 16 | 10 | 26 | ||||||||||||||||||||||||||||||||||||||||||
2969045 | 2969045 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001072 | 64 | Jefferson Building | Special Education School | No | 4 | PK | 12 | 2015 | pre_kindergarten | 17.0 | 5.0 | 2.0 | 16.0 | 8.0 | 24.0 | 17 | 5 | 2 | 16 | 8 | 24 | ||||||||||||||||||||||||||||||||||||||||||
2969047 | 2969047 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001341 | 44 | Lincoln Building | Special Education School | No | 3 | 12 | 12 | 2015 | pre_kindergarten | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2969517 | 2969517 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001122 | 41 | Community Campus | Special Education School | No | 4 | KG | 12 | 2015 | grade_1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
2969522 | 2969522 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001123 | 45 | FLEX | Special Education School | No | 4 | 06 | 12 | 2015 | 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 | ||||||||||||||||||||||||||||||||||||||
2969549 | 2969549 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001121 | 39 | Success Academy | Special Education School | No | 4 | 05 | 12 | 2015 | grade_1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
2969550 | 2969550 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000609 | 40 | Summit Oaks Day Program | Special Education School | No | 4 | KG | 12 | 2015 | 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 |
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]);