enrollments
Data source: Big Local News · About: Big Local
10,768 rows where state = "SD" and year = 2020 sorted by ccd_school_type descending
This data as json, CSV (advanced)
grade ✖
- grade_1 673
- grade_10 673
- grade_11 673
- grade_12 673
- grade_2 673
- grade_3 673
- grade_4 673
- grade_5 673
- grade_6 673
- grade_7 673
- grade_8 673
- grade_9 673
- k_12_total 673
- kindergarten 673
- pk_12_total 673
- pre_kindergarten 673
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
494621 | 494621 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001072 | 64 | Jefferson Building | Special Education School | Not applicable | Other | PK | 12 | 2020 | grade_1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
494623 | 494623 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001341 | 44 | Lincoln Building | Special Education School | Not applicable | High | 12 | 12 | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
494646 | 494646 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001072 | 64 | Jefferson Building | Special Education School | Not applicable | Other | PK | 12 | 2020 | grade_10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
494648 | 494648 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001341 | 44 | Lincoln Building | Special Education School | Not applicable | High | 12 | 12 | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
494671 | 494671 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001072 | 64 | Jefferson Building | Special Education School | Not applicable | Other | PK | 12 | 2020 | grade_11 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
494673 | 494673 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001341 | 44 | Lincoln Building | Special Education School | Not applicable | High | 12 | 12 | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
494696 | 494696 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001072 | 64 | Jefferson Building | Special Education School | Not applicable | Other | PK | 12 | 2020 | grade_12 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
494698 | 494698 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001341 | 44 | Lincoln Building | Special Education School | Not applicable | High | 12 | 12 | 2020 | grade_12 | 20.0 | 1.0 | 5.0 | 3.0 | 1.0 | 2.0 | 21.0 | 11.0 | 32.0 | 20 | 1 | 5 | 3 | 1 | 2 | 21 | 11 | 32 | ||||||||||||||||||||||||||||||||||||
494721 | 494721 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001072 | 64 | Jefferson Building | Special Education School | Not applicable | Other | PK | 12 | 2020 | grade_2 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
494723 | 494723 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001341 | 44 | Lincoln Building | Special Education School | Not applicable | High | 12 | 12 | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
494746 | 494746 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001072 | 64 | Jefferson Building | Special Education School | Not applicable | Other | PK | 12 | 2020 | grade_3 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
494748 | 494748 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001341 | 44 | Lincoln Building | Special Education School | Not applicable | High | 12 | 12 | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
494771 | 494771 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001072 | 64 | Jefferson Building | Special Education School | Not applicable | Other | PK | 12 | 2020 | grade_4 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
494773 | 494773 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001341 | 44 | Lincoln Building | Special Education School | Not applicable | High | 12 | 12 | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
494796 | 494796 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001072 | 64 | Jefferson Building | Special Education School | Not applicable | Other | PK | 12 | 2020 | grade_5 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
494798 | 494798 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001341 | 44 | Lincoln Building | Special Education School | Not applicable | High | 12 | 12 | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
494821 | 494821 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001072 | 64 | Jefferson Building | Special Education School | Not applicable | Other | PK | 12 | 2020 | grade_6 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
494823 | 494823 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001341 | 44 | Lincoln Building | Special Education School | Not applicable | High | 12 | 12 | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
494846 | 494846 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001072 | 64 | Jefferson Building | Special Education School | Not applicable | Other | PK | 12 | 2020 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
494848 | 494848 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001341 | 44 | Lincoln Building | Special Education School | Not applicable | High | 12 | 12 | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
494871 | 494871 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001072 | 64 | Jefferson Building | Special Education School | Not applicable | Other | PK | 12 | 2020 | grade_8 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
494873 | 494873 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001341 | 44 | Lincoln Building | Special Education School | Not applicable | High | 12 | 12 | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
494896 | 494896 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001072 | 64 | Jefferson Building | Special Education School | Not applicable | Other | PK | 12 | 2020 | grade_9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
494898 | 494898 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001341 | 44 | Lincoln Building | Special Education School | Not applicable | High | 12 | 12 | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
494921 | 494921 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001072 | 64 | Jefferson Building | Special Education School | Not applicable | Other | PK | 12 | 2020 | k_12_total | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
494923 | 494923 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001341 | 44 | Lincoln Building | Special Education School | Not applicable | High | 12 | 12 | 2020 | k_12_total | 20.0 | 1.0 | 5.0 | 3.0 | 1.0 | 2.0 | 21.0 | 11.0 | 0.0 | 32.0 | 20 | 1 | 5 | 3 | 1 | 2 | 21 | 11 | 32 | |||||||||||||||||||||||||||||||||||
494946 | 494946 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001072 | 64 | Jefferson Building | Special Education School | Not applicable | Other | PK | 12 | 2020 | kindergarten | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
494948 | 494948 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001341 | 44 | Lincoln Building | Special Education School | Not applicable | High | 12 | 12 | 2020 | 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 | ||||||||||||||||||||||||||||||||||||
494971 | 494971 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001072 | 64 | Jefferson Building | Special Education School | Not applicable | Other | PK | 12 | 2020 | pk_12_total | 22.0 | 1.0 | 17.0 | 2.0 | 26.0 | 16.0 | 42.0 | 22 | 1 | 17 | 2 | 26 | 16 | 42 | ||||||||||||||||||||||||||||||||||||||||
494973 | 494973 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001341 | 44 | Lincoln Building | Special Education School | Not applicable | High | 12 | 12 | 2020 | pk_12_total | 20.0 | 1.0 | 5.0 | 3.0 | 1.0 | 2.0 | 21.0 | 11.0 | 32.0 | 20 | 1 | 5 | 3 | 1 | 2 | 21 | 11 | 32 | ||||||||||||||||||||||||||||||||||||
494996 | 494996 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001072 | 64 | Jefferson Building | Special Education School | Not applicable | Other | PK | 12 | 2020 | pre_kindergarten | 22.0 | 1.0 | 17.0 | 2.0 | 26.0 | 16.0 | 42.0 | 22 | 1 | 17 | 2 | 26 | 16 | 42 | ||||||||||||||||||||||||||||||||||||||||
494998 | 494998 | SD | school | 4659820 | 51004 | Rapid City Area 51-4 | 465982001341 | 44 | Lincoln Building | Special Education School | Not applicable | High | 12 | 12 | 2020 | 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 | ||||||||||||||||||||||||||||||||||||
495371 | 495371 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001122 | 41 | Community Campus | Special Education School | Not applicable | High | 12 | 12 | 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 | ||||||||||||||||||||||||||||||||||||||
495376 | 495376 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001123 | 45 | FLEX | Special Education School | Not applicable | High | 06 | 12 | 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 | ||||||||||||||||||||||||||||||||||||||
495399 | 495399 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001138 | 12 | Structured Teaching Program | Special Education School | Not applicable | High | 06 | 12 | 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 | ||||||||||||||||||||||||||||||||||||||
495400 | 495400 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001121 | 39 | Success Academy | Special Education School | Not applicable | High | 06 | 12 | 2020 | grade_1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
495401 | 495401 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000609 | 40 | Summit Oaks Day Program | Special Education School | Not applicable | Other | KG | 12 | 2020 | grade_1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
495413 | 495413 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001122 | 41 | Community Campus | Special Education School | Not applicable | High | 12 | 12 | 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 | ||||||||||||||||||||||||||||||||||||||
495418 | 495418 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001123 | 45 | FLEX | Special Education School | Not applicable | High | 06 | 12 | 2020 | grade_10 | 5.0 | 2.0 | 3.0 | 1.0 | 1.0 | 8.0 | 4.0 | 12.0 | 5 | 2 | 3 | 1 | 1 | 8 | 4 | 12 | ||||||||||||||||||||||||||||||||||||||
495441 | 495441 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001138 | 12 | Structured Teaching Program | Special Education School | Not applicable | High | 06 | 12 | 2020 | grade_10 | 1.0 | 1.0 | 1.0 | 0.0 | 1.0 | 3.0 | 1.0 | 4.0 | 1 | 1 | 1 | 0 | 1 | 3 | 1 | 4 | ||||||||||||||||||||||||||||||||||||||
495442 | 495442 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001121 | 39 | Success Academy | Special Education School | Not applicable | High | 06 | 12 | 2020 | grade_10 | 1.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 1.0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||||||||
495443 | 495443 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000609 | 40 | Summit Oaks Day Program | Special Education School | Not applicable | Other | KG | 12 | 2020 | grade_10 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||
495455 | 495455 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001122 | 41 | Community Campus | Special Education School | Not applicable | High | 12 | 12 | 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 | ||||||||||||||||||||||||||||||||||||||
495460 | 495460 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001123 | 45 | FLEX | Special Education School | Not applicable | High | 06 | 12 | 2020 | grade_11 | 4.0 | 1.0 | 1.0 | 0.0 | 1.0 | 4.0 | 3.0 | 7.0 | 4 | 1 | 1 | 0 | 1 | 4 | 3 | 7 | ||||||||||||||||||||||||||||||||||||||
495483 | 495483 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001138 | 12 | Structured Teaching Program | Special Education School | Not applicable | High | 06 | 12 | 2020 | grade_11 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 1.0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||||||
495484 | 495484 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001121 | 39 | Success Academy | Special Education School | Not applicable | High | 06 | 12 | 2020 | grade_11 | 1.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 1.0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||||||||
495485 | 495485 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000609 | 40 | Summit Oaks Day Program | Special Education School | Not applicable | Other | KG | 12 | 2020 | grade_11 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
495497 | 495497 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001122 | 41 | Community Campus | Special Education School | Not applicable | High | 12 | 12 | 2020 | grade_12 | 28.0 | 7.0 | 3.0 | 1.0 | 4.0 | 27.0 | 16.0 | 43.0 | 28 | 7 | 3 | 1 | 4 | 27 | 16 | 43 | ||||||||||||||||||||||||||||||||||||||
495502 | 495502 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001123 | 45 | FLEX | Special Education School | Not applicable | High | 06 | 12 | 2020 | grade_12 | 1.0 | 1.0 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 | 2.0 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 2 | ||||||||||||||||||||||||||||||||||||||
495525 | 495525 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001138 | 12 | Structured Teaching Program | Special Education School | Not applicable | High | 06 | 12 | 2020 | grade_12 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 2.0 | 2 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||||||
495526 | 495526 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001121 | 39 | Success Academy | Special Education School | Not applicable | High | 06 | 12 | 2020 | grade_12 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
495527 | 495527 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000609 | 40 | Summit Oaks Day Program | Special Education School | Not applicable | Other | KG | 12 | 2020 | grade_12 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
495539 | 495539 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001122 | 41 | Community Campus | Special Education School | Not applicable | High | 12 | 12 | 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 | ||||||||||||||||||||||||||||||||||||||
495544 | 495544 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001123 | 45 | FLEX | Special Education School | Not applicable | High | 06 | 12 | 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 | ||||||||||||||||||||||||||||||||||||||
495567 | 495567 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001138 | 12 | Structured Teaching Program | Special Education School | Not applicable | High | 06 | 12 | 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 | ||||||||||||||||||||||||||||||||||||||
495568 | 495568 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001121 | 39 | Success Academy | Special Education School | Not applicable | High | 06 | 12 | 2020 | grade_2 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
495569 | 495569 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000609 | 40 | Summit Oaks Day Program | Special Education School | Not applicable | Other | KG | 12 | 2020 | grade_2 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
495581 | 495581 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001122 | 41 | Community Campus | Special Education School | Not applicable | High | 12 | 12 | 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 | ||||||||||||||||||||||||||||||||||||||
495586 | 495586 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001123 | 45 | FLEX | Special Education School | Not applicable | High | 06 | 12 | 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 | ||||||||||||||||||||||||||||||||||||||
495609 | 495609 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001138 | 12 | Structured Teaching Program | Special Education School | Not applicable | High | 06 | 12 | 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 | ||||||||||||||||||||||||||||||||||||||
495610 | 495610 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001121 | 39 | Success Academy | Special Education School | Not applicable | High | 06 | 12 | 2020 | grade_3 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
495611 | 495611 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000609 | 40 | Summit Oaks Day Program | Special Education School | Not applicable | Other | KG | 12 | 2020 | grade_3 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
495623 | 495623 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001122 | 41 | Community Campus | Special Education School | Not applicable | High | 12 | 12 | 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 | ||||||||||||||||||||||||||||||||||||||
495628 | 495628 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001123 | 45 | FLEX | Special Education School | Not applicable | High | 06 | 12 | 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 | ||||||||||||||||||||||||||||||||||||||
495651 | 495651 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001138 | 12 | Structured Teaching Program | Special Education School | Not applicable | High | 06 | 12 | 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 | ||||||||||||||||||||||||||||||||||||||
495652 | 495652 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001121 | 39 | Success Academy | Special Education School | Not applicable | High | 06 | 12 | 2020 | grade_4 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
495653 | 495653 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000609 | 40 | Summit Oaks Day Program | Special Education School | Not applicable | Other | KG | 12 | 2020 | grade_4 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
495665 | 495665 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001122 | 41 | Community Campus | Special Education School | Not applicable | High | 12 | 12 | 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 | ||||||||||||||||||||||||||||||||||||||
495670 | 495670 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001123 | 45 | FLEX | Special Education School | Not applicable | High | 06 | 12 | 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 | ||||||||||||||||||||||||||||||||||||||
495693 | 495693 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001138 | 12 | Structured Teaching Program | Special Education School | Not applicable | High | 06 | 12 | 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 | ||||||||||||||||||||||||||||||||||||||
495694 | 495694 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001121 | 39 | Success Academy | Special Education School | Not applicable | High | 06 | 12 | 2020 | grade_5 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
495695 | 495695 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000609 | 40 | Summit Oaks Day Program | Special Education School | Not applicable | Other | KG | 12 | 2020 | grade_5 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
495707 | 495707 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001122 | 41 | Community Campus | Special Education School | Not applicable | High | 12 | 12 | 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 | ||||||||||||||||||||||||||||||||||||||
495712 | 495712 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001123 | 45 | FLEX | Special Education School | Not applicable | High | 06 | 12 | 2020 | grade_6 | 1.0 | 1.0 | 0.0 | 0.0 | 1.0 | 1.0 | 2.0 | 3.0 | 1 | 1 | 0 | 0 | 1 | 1 | 2 | 3 | ||||||||||||||||||||||||||||||||||||||
495735 | 495735 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001138 | 12 | Structured Teaching Program | Special Education School | Not applicable | High | 06 | 12 | 2020 | grade_6 | 3.0 | 2.0 | 1.0 | 0.0 | 0.0 | 4.0 | 2.0 | 6.0 | 3 | 2 | 1 | 0 | 0 | 4 | 2 | 6 | ||||||||||||||||||||||||||||||||||||||
495736 | 495736 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001121 | 39 | Success Academy | Special Education School | Not applicable | High | 06 | 12 | 2020 | grade_6 | 5.0 | 0.0 | 2.0 | 1.0 | 7.0 | 1.0 | 8.0 | 5 | 0 | 2 | 1 | 7 | 1 | 8 | ||||||||||||||||||||||||||||||||||||||||
495737 | 495737 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000609 | 40 | Summit Oaks Day Program | Special Education School | Not applicable | Other | KG | 12 | 2020 | grade_6 | 1.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 1.0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||||||||
495749 | 495749 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001122 | 41 | Community Campus | Special Education School | Not applicable | High | 12 | 12 | 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 | ||||||||||||||||||||||||||||||||||||||
495754 | 495754 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001123 | 45 | FLEX | Special Education School | Not applicable | High | 06 | 12 | 2020 | grade_7 | 1.0 | 2.0 | 0.0 | 0.0 | 0.0 | 2.0 | 1.0 | 3.0 | 1 | 2 | 0 | 0 | 0 | 2 | 1 | 3 | ||||||||||||||||||||||||||||||||||||||
495777 | 495777 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001138 | 12 | Structured Teaching Program | Special Education School | Not applicable | High | 06 | 12 | 2020 | grade_7 | 2.0 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 | 2.0 | 3.0 | 2 | 0 | 0 | 0 | 1 | 1 | 2 | 3 | ||||||||||||||||||||||||||||||||||||||
495778 | 495778 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001121 | 39 | Success Academy | Special Education School | Not applicable | High | 06 | 12 | 2020 | grade_7 | 1.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 1.0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||||||||
495779 | 495779 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000609 | 40 | Summit Oaks Day Program | Special Education School | Not applicable | Other | KG | 12 | 2020 | grade_7 | 4.0 | 1.0 | 1.0 | 2.0 | 7.0 | 1.0 | 8.0 | 4 | 1 | 1 | 2 | 7 | 1 | 8 | ||||||||||||||||||||||||||||||||||||||||
495791 | 495791 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001122 | 41 | Community Campus | Special Education School | Not applicable | High | 12 | 12 | 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 | ||||||||||||||||||||||||||||||||||||||
495796 | 495796 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001123 | 45 | FLEX | Special Education School | Not applicable | High | 06 | 12 | 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 | ||||||||||||||||||||||||||||||||||||||
495819 | 495819 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001138 | 12 | Structured Teaching Program | Special Education School | Not applicable | High | 06 | 12 | 2020 | grade_8 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 1.0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||||||
495820 | 495820 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001121 | 39 | Success Academy | Special Education School | Not applicable | High | 06 | 12 | 2020 | grade_8 | 1.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 1.0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||||||||
495821 | 495821 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000609 | 40 | Summit Oaks Day Program | Special Education School | Not applicable | Other | KG | 12 | 2020 | grade_8 | 1.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 1.0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||||||||
495833 | 495833 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001122 | 41 | Community Campus | Special Education School | Not applicable | High | 12 | 12 | 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 | ||||||||||||||||||||||||||||||||||||||
495838 | 495838 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001123 | 45 | FLEX | Special Education School | Not applicable | High | 06 | 12 | 2020 | grade_9 | 5.0 | 4.0 | 0.0 | 5.0 | 1.0 | 9.0 | 6.0 | 15.0 | 5 | 4 | 0 | 5 | 1 | 9 | 6 | 15 | ||||||||||||||||||||||||||||||||||||||
495861 | 495861 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001138 | 12 | Structured Teaching Program | Special Education School | Not applicable | High | 06 | 12 | 2020 | grade_9 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 | 1.0 | 2.0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 2 | ||||||||||||||||||||||||||||||||||||||
495862 | 495862 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001121 | 39 | Success Academy | Special Education School | Not applicable | High | 06 | 12 | 2020 | grade_9 | 2.0 | 1.0 | 1.0 | 0.0 | 4.0 | 0.0 | 4.0 | 2 | 1 | 1 | 0 | 4 | 0 | 4 | ||||||||||||||||||||||||||||||||||||||||
495863 | 495863 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000609 | 40 | Summit Oaks Day Program | Special Education School | Not applicable | Other | KG | 12 | 2020 | grade_9 | 5.0 | 1.0 | 1.0 | 0.0 | 6.0 | 1.0 | 7.0 | 5 | 1 | 1 | 0 | 6 | 1 | 7 | ||||||||||||||||||||||||||||||||||||||||
495875 | 495875 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001122 | 41 | Community Campus | Special Education School | Not applicable | High | 12 | 12 | 2020 | k_12_total | 28.0 | 7.0 | 3.0 | 1.0 | 4.0 | 27.0 | 16.0 | 14.0 | 43.0 | 28 | 7 | 3 | 1 | 4 | 27 | 16 | 43 | |||||||||||||||||||||||||||||||||||||
495880 | 495880 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001123 | 45 | FLEX | Special Education School | Not applicable | High | 06 | 12 | 2020 | k_12_total | 17.0 | 11.0 | 4.0 | 6.0 | 4.0 | 25.0 | 17.0 | 11.9 | 42.0 | 17 | 11 | 4 | 6 | 4 | 25 | 17 | 42 | |||||||||||||||||||||||||||||||||||||
495903 | 495903 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001138 | 12 | Structured Teaching Program | Special Education School | Not applicable | High | 06 | 12 | 2020 | k_12_total | 10.0 | 3.0 | 2.0 | 1.0 | 3.0 | 13.0 | 6.0 | 10.5 | 19.0 | 10 | 3 | 2 | 1 | 3 | 13 | 6 | 19 | |||||||||||||||||||||||||||||||||||||
495904 | 495904 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001121 | 39 | Success Academy | Special Education School | Not applicable | High | 06 | 12 | 2020 | k_12_total | 11.0 | 1.0 | 3.0 | 1.0 | 15.0 | 1.0 | 0.0 | 16.0 | 11 | 1 | 3 | 1 | 15 | 1 | 16 | |||||||||||||||||||||||||||||||||||||||
495905 | 495905 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627000609 | 40 | Summit Oaks Day Program | Special Education School | Not applicable | Other | KG | 12 | 2020 | k_12_total | 12.0 | 2.0 | 2.0 | 2.0 | 15.0 | 3.0 | 5.6 | 18.0 | 12 | 2 | 2 | 2 | 15 | 3 | 18 | |||||||||||||||||||||||||||||||||||||||
495917 | 495917 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001122 | 41 | Community Campus | Special Education School | Not applicable | High | 12 | 12 | 2020 | 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 | ||||||||||||||||||||||||||||||||||||||
495922 | 495922 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001123 | 45 | FLEX | Special Education School | Not applicable | High | 06 | 12 | 2020 | 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 | ||||||||||||||||||||||||||||||||||||||
495945 | 495945 | SD | school | 4666270 | 49005 | Sioux Falls 49-5 | 466627001138 | 12 | Structured Teaching Program | Special Education School | Not applicable | High | 06 | 12 | 2020 | 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 |
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]);