enrollments
Data source: Big Local News · About: Big Local
75,136 rows where state = "SD" sorted by district_state_id descending
This data as json, CSV (advanced)
grade ✖
- grade_11 4,681
- grade_12 4,681
- grade_2 4,681
- grade_3 4,681
- grade_4 4,681
- grade_5 4,681
- grade_6 4,681
- grade_7 4,681
- grade_8 4,681
- grade_9 4,681
- k_12_total 4,681
- kindergarten 4,681
- pk_12_total 4,681
- pre_kindergarten 4,681
- grade_10 4,680
- grade_1 4,678
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3012794 | 3012794 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000469 | 1 | Newell High School | Regular School | No | High | 09 | 12 | 2017 | grade_10 | 22.0 | 1.0 | 1.0 | 1.0 | 1.0 | 15.0 | 11.0 | 26.0 | 22 | 1 | 1 | 1 | 1 | 15 | 11 | 26 | ||||||||||||||||||||||||||||||||||||||
3012795 | 3012795 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000968 | 4 | Newell Middle Sch | Regular School | No | Middle | 06 | 08 | 2017 | 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 | ||||||||||||||||||||||||||||||||||
3012796 | 3012796 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000468 | 2 | Newell Elem | Regular School | No | Elementary | PK | 05 | 2017 | 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 | ||||||||||||||||||||||||||||||||||||
3012797 | 3012797 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000469 | 1 | Newell High School | Regular School | No | High | 09 | 12 | 2017 | grade_11 | 21.0 | 1.0 | 0.0 | 1.0 | 0.0 | 13.0 | 10.0 | 23.0 | 21 | 1 | 0 | 1 | 0 | 13 | 10 | 23 | ||||||||||||||||||||||||||||||||||||||
3012798 | 3012798 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000968 | 4 | Newell Middle Sch | Regular School | No | Middle | 06 | 08 | 2017 | 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 | ||||||||||||||||||||||||||||||||||
3012799 | 3012799 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000468 | 2 | Newell Elem | Regular School | No | Elementary | PK | 05 | 2017 | 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 | ||||||||||||||||||||||||||||||||||||
3012800 | 3012800 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000469 | 1 | Newell High School | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 24.0 | 0.0 | 1.0 | 0.0 | 0.0 | 13.0 | 12.0 | 25.0 | 24 | 0 | 1 | 0 | 0 | 13 | 12 | 25 | ||||||||||||||||||||||||||||||||||||||
3012801 | 3012801 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000968 | 4 | Newell Middle Sch | Regular School | No | Middle | 06 | 08 | 2017 | 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 | ||||||||||||||||||||||||||||||||||
3012802 | 3012802 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000468 | 2 | Newell Elem | Regular School | No | Elementary | PK | 05 | 2017 | grade_2 | 17.0 | 0.0 | 0.0 | 5.0 | 0.0 | 0.0 | 11.0 | 11.0 | 22.0 | 17 | 0 | 0 | 5 | 0 | 0 | 11 | 11 | 22 | ||||||||||||||||||||||||||||||||||||
3012803 | 3012803 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000469 | 1 | Newell High School | Regular School | No | High | 09 | 12 | 2017 | 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 | ||||||||||||||||||||||||||||||||||||||
3012804 | 3012804 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000968 | 4 | Newell Middle Sch | Regular School | No | Middle | 06 | 08 | 2017 | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
3012805 | 3012805 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000468 | 2 | Newell Elem | Regular School | No | Elementary | PK | 05 | 2017 | grade_3 | 10.0 | 1.0 | 0.0 | 3.0 | 0.0 | 1.0 | 5.0 | 10.0 | 15.0 | 10 | 1 | 0 | 3 | 0 | 1 | 5 | 10 | 15 | ||||||||||||||||||||||||||||||||||||
3012806 | 3012806 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000469 | 1 | Newell High School | Regular School | No | High | 09 | 12 | 2017 | 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 | ||||||||||||||||||||||||||||||||||||||
3012807 | 3012807 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000968 | 4 | Newell Middle Sch | Regular School | No | Middle | 06 | 08 | 2017 | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
3012808 | 3012808 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000468 | 2 | Newell Elem | Regular School | No | Elementary | PK | 05 | 2017 | grade_4 | 14.0 | 0.0 | 2.0 | 2.0 | 0.0 | 0.0 | 11.0 | 7.0 | 18.0 | 14 | 0 | 2 | 2 | 0 | 0 | 11 | 7 | 18 | ||||||||||||||||||||||||||||||||||||
3012809 | 3012809 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000469 | 1 | Newell High School | Regular School | No | High | 09 | 12 | 2017 | 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 | ||||||||||||||||||||||||||||||||||||||
3012810 | 3012810 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000968 | 4 | Newell Middle Sch | Regular School | No | Middle | 06 | 08 | 2017 | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
3012811 | 3012811 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000468 | 2 | Newell Elem | Regular School | No | Elementary | PK | 05 | 2017 | grade_5 | 20.0 | 1.0 | 0.0 | 0.0 | 1.0 | 1.0 | 13.0 | 10.0 | 23.0 | 20 | 1 | 0 | 0 | 1 | 1 | 13 | 10 | 23 | ||||||||||||||||||||||||||||||||||||
3012812 | 3012812 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000469 | 1 | Newell High School | Regular School | No | High | 09 | 12 | 2017 | 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 | ||||||||||||||||||||||||||||||||||||||
3012813 | 3012813 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000968 | 4 | Newell Middle Sch | Regular School | No | Middle | 06 | 08 | 2017 | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
3012814 | 3012814 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000468 | 2 | Newell Elem | Regular School | No | Elementary | PK | 05 | 2017 | 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 | ||||||||||||||||||||||||||||||||||||
3012815 | 3012815 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000469 | 1 | Newell High School | Regular School | No | High | 09 | 12 | 2017 | 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 | ||||||||||||||||||||||||||||||||||||||
3012816 | 3012816 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000968 | 4 | Newell Middle Sch | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 23.0 | 0.0 | 1.0 | 6.0 | 0.0 | 0.0 | 1.0 | 17.0 | 14.0 | 31.0 | 23 | 0 | 1 | 6 | 0 | 0 | 1 | 17 | 14 | 31 | ||||||||||||||||||||||||||||||||||
3012817 | 3012817 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000468 | 2 | Newell Elem | Regular School | No | Elementary | PK | 05 | 2017 | 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 | ||||||||||||||||||||||||||||||||||||
3012818 | 3012818 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000469 | 1 | Newell High School | Regular School | No | High | 09 | 12 | 2017 | 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 | ||||||||||||||||||||||||||||||||||||||
3012819 | 3012819 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000968 | 4 | Newell Middle Sch | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 16.0 | 2.0 | 1.0 | 1.0 | 2.0 | 0.0 | 0.0 | 15.0 | 7.0 | 22.0 | 16 | 2 | 1 | 1 | 2 | 0 | 0 | 15 | 7 | 22 | ||||||||||||||||||||||||||||||||||
3012820 | 3012820 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000468 | 2 | Newell Elem | Regular School | No | Elementary | PK | 05 | 2017 | 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 | ||||||||||||||||||||||||||||||||||||
3012821 | 3012821 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000469 | 1 | Newell High School | Regular School | No | High | 09 | 12 | 2017 | 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 | ||||||||||||||||||||||||||||||||||||||
3012822 | 3012822 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000968 | 4 | Newell Middle Sch | Regular School | No | Middle | 06 | 08 | 2017 | grade_8 | 29.0 | 0.0 | 0.0 | 1.0 | 0.0 | 1.0 | 0.0 | 18.0 | 13.0 | 31.0 | 29 | 0 | 0 | 1 | 0 | 1 | 0 | 18 | 13 | 31 | ||||||||||||||||||||||||||||||||||
3012823 | 3012823 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000468 | 2 | Newell Elem | Regular School | No | Elementary | PK | 05 | 2017 | 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 | ||||||||||||||||||||||||||||||||||||
3012824 | 3012824 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000469 | 1 | Newell High School | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 22.0 | 1.0 | 1.0 | 0.0 | 1.0 | 14.0 | 11.0 | 25.0 | 22 | 1 | 1 | 0 | 1 | 14 | 11 | 25 | ||||||||||||||||||||||||||||||||||||||
3012825 | 3012825 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000968 | 4 | Newell Middle Sch | Regular School | No | Middle | 06 | 08 | 2017 | 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 | ||||||||||||||||||||||||||||||||||
3012826 | 3012826 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000468 | 2 | Newell Elem | Regular School | No | Elementary | PK | 05 | 2017 | k_12_total | 91.0 | 3.0 | 3.0 | 10.0 | 2.0 | 3.0 | 59.0 | 53.0 | 0.0 | 112.0 | 91 | 3 | 3 | 10 | 2 | 3 | 59 | 53 | 112 | |||||||||||||||||||||||||||||||||||
3012827 | 3012827 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000469 | 1 | Newell High School | Regular School | No | High | 09 | 12 | 2017 | k_12_total | 89.0 | 3.0 | 3.0 | 2.0 | 2.0 | 55.0 | 44.0 | 0.0 | 99.0 | 89 | 3 | 3 | 2 | 2 | 55 | 44 | 99 | |||||||||||||||||||||||||||||||||||||
3012828 | 3012828 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000968 | 4 | Newell Middle Sch | Regular School | No | Middle | 06 | 08 | 2017 | k_12_total | 68.0 | 2.0 | 2.0 | 8.0 | 2.0 | 1.0 | 1.0 | 50.0 | 34.0 | 0.0 | 84.0 | 68 | 2 | 2 | 8 | 2 | 1 | 1 | 50 | 34 | 84 | |||||||||||||||||||||||||||||||||
3012829 | 3012829 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000468 | 2 | Newell Elem | Regular School | No | Elementary | PK | 05 | 2017 | kindergarten | 13.0 | 0.0 | 1.0 | 0.0 | 1.0 | 0.0 | 9.0 | 6.0 | 15.0 | 13 | 0 | 1 | 0 | 1 | 0 | 9 | 6 | 15 | ||||||||||||||||||||||||||||||||||||
3012830 | 3012830 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000469 | 1 | Newell High School | Regular School | No | High | 09 | 12 | 2017 | 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 | ||||||||||||||||||||||||||||||||||||||
3012831 | 3012831 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000968 | 4 | Newell Middle Sch | Regular School | No | Middle | 06 | 08 | 2017 | 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 | ||||||||||||||||||||||||||||||||||
3012832 | 3012832 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000468 | 2 | Newell Elem | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 104.0 | 3.0 | 3.0 | 13.0 | 3.0 | 3.0 | 66.0 | 63.0 | 129.0 | 104 | 3 | 3 | 13 | 3 | 3 | 66 | 63 | 129 | ||||||||||||||||||||||||||||||||||||
3012833 | 3012833 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000469 | 1 | Newell High School | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 89.0 | 3.0 | 3.0 | 2.0 | 2.0 | 55.0 | 44.0 | 99.0 | 89 | 3 | 3 | 2 | 2 | 55 | 44 | 99 | ||||||||||||||||||||||||||||||||||||||
3012834 | 3012834 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000968 | 4 | Newell Middle Sch | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 68.0 | 2.0 | 2.0 | 8.0 | 2.0 | 1.0 | 1.0 | 50.0 | 34.0 | 84.0 | 68 | 2 | 2 | 8 | 2 | 1 | 1 | 50 | 34 | 84 | ||||||||||||||||||||||||||||||||||
3012835 | 3012835 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000468 | 2 | Newell Elem | Regular School | No | Elementary | PK | 05 | 2017 | pre_kindergarten | 13.0 | 0.0 | 0.0 | 3.0 | 1.0 | 0.0 | 7.0 | 10.0 | 17.0 | 13 | 0 | 0 | 3 | 1 | 0 | 7 | 10 | 17 | ||||||||||||||||||||||||||||||||||||
3012836 | 3012836 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000469 | 1 | Newell High School | Regular School | No | High | 09 | 12 | 2017 | 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 | ||||||||||||||||||||||||||||||||||||||
3012837 | 3012837 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000968 | 4 | Newell Middle Sch | Regular School | No | Middle | 06 | 08 | 2017 | 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 | ||||||||||||||||||||||||||||||||||
3350654 | 3350654 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000468 | 2 | Newell Elem | Regular School | No | 1 | PK | 05 | 2016 | grade_1 | 20.0 | 0.0 | 0.0 | 2.0 | 0.0 | 0.0 | 11.0 | 11.0 | 22.0 | 20 | 0 | 0 | 2 | 0 | 0 | 11 | 11 | 22 | ||||||||||||||||||||||||||||||||||||
3350655 | 3350655 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000469 | 1 | Newell High School | Regular School | No | 3 | 09 | 12 | 2016 | 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 | ||||||||||||||||||||||||||||||||||||||
3350656 | 3350656 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000968 | 4 | Newell Middle Sch | Regular School | No | 2 | 06 | 08 | 2016 | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
3350657 | 3350657 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000468 | 2 | Newell Elem | Regular School | No | 1 | PK | 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 | ||||||||||||||||||||||||||||||||||||
3350658 | 3350658 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000469 | 1 | Newell High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_10 | 22.0 | 1.0 | 0.0 | 1.0 | 0.0 | 14.0 | 10.0 | 24.0 | 22 | 1 | 0 | 1 | 0 | 14 | 10 | 24 | ||||||||||||||||||||||||||||||||||||||
3350659 | 3350659 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000968 | 4 | Newell Middle Sch | Regular School | No | 2 | 06 | 08 | 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 | ||||||||||||||||||||||||||||||||||
3350660 | 3350660 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000468 | 2 | Newell Elem | Regular School | No | 1 | PK | 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 | ||||||||||||||||||||||||||||||||||||
3350661 | 3350661 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000469 | 1 | Newell High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_11 | 23.0 | 0.0 | 0.0 | 2.0 | 0.0 | 15.0 | 10.0 | 25.0 | 23 | 0 | 0 | 2 | 0 | 15 | 10 | 25 | ||||||||||||||||||||||||||||||||||||||
3350662 | 3350662 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000968 | 4 | Newell Middle Sch | Regular School | No | 2 | 06 | 08 | 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 | ||||||||||||||||||||||||||||||||||
3350663 | 3350663 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000468 | 2 | Newell Elem | Regular School | No | 1 | PK | 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 | ||||||||||||||||||||||||||||||||||||
3350664 | 3350664 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000469 | 1 | Newell High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 9.0 | 2.0 | 0.0 | 2.0 | 0.0 | 6.0 | 7.0 | 13.0 | 9 | 2 | 0 | 2 | 0 | 6 | 7 | 13 | ||||||||||||||||||||||||||||||||||||||
3350665 | 3350665 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000968 | 4 | Newell Middle Sch | Regular School | No | 2 | 06 | 08 | 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 | ||||||||||||||||||||||||||||||||||
3350666 | 3350666 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000468 | 2 | Newell Elem | Regular School | No | 1 | PK | 05 | 2016 | grade_2 | 13.0 | 1.0 | 0.0 | 2.0 | 0.0 | 2.0 | 9.0 | 9.0 | 18.0 | 13 | 1 | 0 | 2 | 0 | 2 | 9 | 9 | 18 | ||||||||||||||||||||||||||||||||||||
3350667 | 3350667 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000469 | 1 | Newell High School | Regular School | No | 3 | 09 | 12 | 2016 | 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 | ||||||||||||||||||||||||||||||||||||||
3350668 | 3350668 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000968 | 4 | Newell Middle Sch | Regular School | No | 2 | 06 | 08 | 2016 | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
3350669 | 3350669 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000468 | 2 | Newell Elem | Regular School | No | 1 | PK | 05 | 2016 | grade_3 | 16.0 | 0.0 | 2.0 | 1.0 | 0.0 | 0.0 | 13.0 | 6.0 | 19.0 | 16 | 0 | 2 | 1 | 0 | 0 | 13 | 6 | 19 | ||||||||||||||||||||||||||||||||||||
3350670 | 3350670 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000469 | 1 | Newell High School | Regular School | No | 3 | 09 | 12 | 2016 | 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 | ||||||||||||||||||||||||||||||||||||||
3350671 | 3350671 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000968 | 4 | Newell Middle Sch | Regular School | No | 2 | 06 | 08 | 2016 | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
3350672 | 3350672 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000468 | 2 | Newell Elem | Regular School | No | 1 | PK | 05 | 2016 | grade_4 | 22.0 | 1.0 | 0.0 | 0.0 | 1.0 | 1.0 | 12.0 | 13.0 | 25.0 | 22 | 1 | 0 | 0 | 1 | 1 | 12 | 13 | 25 | ||||||||||||||||||||||||||||||||||||
3350673 | 3350673 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000469 | 1 | Newell High School | Regular School | No | 3 | 09 | 12 | 2016 | 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 | ||||||||||||||||||||||||||||||||||||||
3350674 | 3350674 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000968 | 4 | Newell Middle Sch | Regular School | No | 2 | 06 | 08 | 2016 | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
3350675 | 3350675 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000468 | 2 | Newell Elem | Regular School | No | 1 | PK | 05 | 2016 | grade_5 | 22.0 | 0.0 | 1.0 | 5.0 | 0.0 | 1.0 | 16.0 | 13.0 | 29.0 | 22 | 0 | 1 | 5 | 0 | 1 | 16 | 13 | 29 | ||||||||||||||||||||||||||||||||||||
3350676 | 3350676 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000469 | 1 | Newell High School | Regular School | No | 3 | 09 | 12 | 2016 | 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 | ||||||||||||||||||||||||||||||||||||||
3350677 | 3350677 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000968 | 4 | Newell Middle Sch | Regular School | No | 2 | 06 | 08 | 2016 | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
3350678 | 3350678 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000468 | 2 | Newell Elem | Regular School | No | 1 | PK | 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 | ||||||||||||||||||||||||||||||||||||
3350679 | 3350679 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000469 | 1 | Newell High School | Regular School | No | 3 | 09 | 12 | 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 | ||||||||||||||||||||||||||||||||||||||
3350680 | 3350680 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000968 | 4 | Newell Middle Sch | Regular School | No | 2 | 06 | 08 | 2016 | grade_6 | 15.0 | 2.0 | 1.0 | 2.0 | 2.0 | 0.0 | 0.0 | 15.0 | 7.0 | 22.0 | 15 | 2 | 1 | 2 | 2 | 0 | 0 | 15 | 7 | 22 | ||||||||||||||||||||||||||||||||||
3350681 | 3350681 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000468 | 2 | Newell Elem | Regular School | No | 1 | PK | 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 | ||||||||||||||||||||||||||||||||||||
3350682 | 3350682 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000469 | 1 | Newell High School | Regular School | No | 3 | 09 | 12 | 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 | ||||||||||||||||||||||||||||||||||||||
3350683 | 3350683 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000968 | 4 | Newell Middle Sch | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 27.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 15.0 | 13.0 | 28.0 | 27 | 0 | 0 | 0 | 0 | 1 | 0 | 15 | 13 | 28 | ||||||||||||||||||||||||||||||||||
3350684 | 3350684 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000468 | 2 | Newell Elem | Regular School | No | 1 | PK | 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 | ||||||||||||||||||||||||||||||||||||
3350685 | 3350685 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000469 | 1 | Newell High School | Regular School | No | 3 | 09 | 12 | 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 | ||||||||||||||||||||||||||||||||||||||
3350686 | 3350686 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000968 | 4 | Newell Middle Sch | Regular School | No | 2 | 06 | 08 | 2016 | grade_8 | 21.0 | 1.0 | 1.0 | 1.0 | 0.0 | 0.0 | 1.0 | 14.0 | 11.0 | 25.0 | 21 | 1 | 1 | 1 | 0 | 0 | 1 | 14 | 11 | 25 | ||||||||||||||||||||||||||||||||||
3350687 | 3350687 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000468 | 2 | Newell Elem | Regular School | No | 1 | PK | 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 | ||||||||||||||||||||||||||||||||||||
3350688 | 3350688 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000469 | 1 | Newell High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_9 | 16.0 | 1.0 | 1.0 | 1.0 | 1.0 | 10.0 | 10.0 | 20.0 | 16 | 1 | 1 | 1 | 1 | 10 | 10 | 20 | ||||||||||||||||||||||||||||||||||||||
3350689 | 3350689 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000968 | 4 | Newell Middle Sch | Regular School | No | 2 | 06 | 08 | 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 | ||||||||||||||||||||||||||||||||||
3350690 | 3350690 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000468 | 2 | Newell Elem | Regular School | No | 1 | PK | 05 | 2016 | k_12_total | 109.0 | 3.0 | 3.0 | 10.0 | 1.0 | 5.0 | 70.0 | 61.0 | 131.0 | 109 | 3 | 3 | 10 | 1 | 5 | 70 | 61 | 131 | ||||||||||||||||||||||||||||||||||||
3350691 | 3350691 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000469 | 1 | Newell High School | Regular School | No | 3 | 09 | 12 | 2016 | k_12_total | 70.0 | 4.0 | 1.0 | 6.0 | 1.0 | 45.0 | 37.0 | 82.0 | 70 | 4 | 1 | 6 | 1 | 45 | 37 | 82 | ||||||||||||||||||||||||||||||||||||||
3350692 | 3350692 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000968 | 4 | Newell Middle Sch | Regular School | No | 2 | 06 | 08 | 2016 | k_12_total | 63.0 | 3.0 | 2.0 | 3.0 | 2.0 | 1.0 | 1.0 | 44.0 | 31.0 | 75.0 | 63 | 3 | 2 | 3 | 2 | 1 | 1 | 44 | 31 | 75 | ||||||||||||||||||||||||||||||||||
3350693 | 3350693 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000468 | 2 | Newell Elem | Regular School | No | 1 | PK | 05 | 2016 | kindergarten | 16.0 | 1.0 | 0.0 | 0.0 | 0.0 | 1.0 | 9.0 | 9.0 | 18.0 | 16 | 1 | 0 | 0 | 0 | 1 | 9 | 9 | 18 | ||||||||||||||||||||||||||||||||||||
3350694 | 3350694 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000469 | 1 | Newell High School | Regular School | No | 3 | 09 | 12 | 2016 | 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 | ||||||||||||||||||||||||||||||||||||||
3350695 | 3350695 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000968 | 4 | Newell Middle Sch | Regular School | No | 2 | 06 | 08 | 2016 | 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 | ||||||||||||||||||||||||||||||||||
3350696 | 3350696 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000468 | 2 | Newell Elem | Regular School | No | 1 | PK | 05 | 2016 | pk_12_total | 129.0 | 3.0 | 4.0 | 13.0 | 1.0 | 5.0 | 83.0 | 72.0 | 155.0 | 129 | 3 | 4 | 13 | 1 | 5 | 83 | 72 | 155 | ||||||||||||||||||||||||||||||||||||
3350697 | 3350697 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000469 | 1 | Newell High School | Regular School | No | 3 | 09 | 12 | 2016 | pk_12_total | 70.0 | 4.0 | 1.0 | 6.0 | 1.0 | 45.0 | 37.0 | 82.0 | 70 | 4 | 1 | 6 | 1 | 45 | 37 | 82 | ||||||||||||||||||||||||||||||||||||||
3350698 | 3350698 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000968 | 4 | Newell Middle Sch | Regular School | No | 2 | 06 | 08 | 2016 | pk_12_total | 63.0 | 3.0 | 2.0 | 3.0 | 2.0 | 1.0 | 1.0 | 44.0 | 31.0 | 75.0 | 63 | 3 | 2 | 3 | 2 | 1 | 1 | 44 | 31 | 75 | ||||||||||||||||||||||||||||||||||
3350699 | 3350699 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000468 | 2 | Newell Elem | Regular School | No | 1 | PK | 05 | 2016 | pre_kindergarten | 20.0 | 0.0 | 1.0 | 3.0 | 0.0 | 0.0 | 13.0 | 11.0 | 24.0 | 20 | 0 | 1 | 3 | 0 | 0 | 13 | 11 | 24 | ||||||||||||||||||||||||||||||||||||
3350700 | 3350700 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000469 | 1 | Newell High School | Regular School | No | 3 | 09 | 12 | 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 | ||||||||||||||||||||||||||||||||||||||
3350701 | 3350701 | SD | school | 4650850 | 9002 | Newell 09-2 | 465085000968 | 4 | Newell Middle Sch | Regular School | No | 2 | 06 | 08 | 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 | ||||||||||||||||||||||||||||||||||
250381 | 250381 | SD | school | 4605610 | 9001 | Belle Fourche 09-1 | 460561001277 | 9 | Belle Fourche Education Connection | Alternative School | No | High | 09 | 12 | 2018 | grade_1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
250382 | 250382 | SD | school | 4605610 | 9001 | Belle Fourche 09-1 | 460561000038 | 1 | Belle Fourche HS | Regular School | No | High | 09 | 12 | 2018 | 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 | ||||||||||||||||||||||||||||||||||||||
250383 | 250383 | SD | school | 4605610 | 9001 | Belle Fourche 09-1 | 460561001117 | 7 | Belle Fourche MS | Regular School | No | Middle | 05 | 08 | 2018 | grade_1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
250384 | 250384 | SD | school | 4605610 | 9001 | Belle Fourche 09-1 | 460561000289 | 8 | North Park Elementary | Regular School | No | Elementary | KG | KG | 2018 | grade_1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
250385 | 250385 | SD | school | 4605610 | 9001 | Belle Fourche 09-1 | 460561000269 | 3 | South Park Elementary | Regular School | No | Elementary | 01 | 04 | 2018 | grade_1 | 97.0 | 7.0 | 1.0 | 5.0 | 54.0 | 56.0 | 110.0 | 97 | 7 | 1 | 5 | 54 | 56 | 110 | ||||||||||||||||||||||||||||||||||||||||
250386 | 250386 | SD | school | 4605610 | 9001 | Belle Fourche 09-1 | 460561001277 | 9 | Belle Fourche Education Connection | Alternative School | No | High | 09 | 12 | 2018 | grade_10 | 6.0 | 0.0 | 1.0 | 1.0 | 5.0 | 3.0 | 8.0 | 6 | 0 | 1 | 1 | 5 | 3 | 8 | ||||||||||||||||||||||||||||||||||||||||
250387 | 250387 | SD | school | 4605610 | 9001 | Belle Fourche 09-1 | 460561000038 | 1 | Belle Fourche HS | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 70.0 | 6.0 | 0.0 | 2.0 | 6.0 | 45.0 | 39.0 | 84.0 | 70 | 6 | 0 | 2 | 6 | 45 | 39 | 84 | ||||||||||||||||||||||||||||||||||||||
250388 | 250388 | SD | school | 4605610 | 9001 | Belle Fourche 09-1 | 460561001117 | 7 | Belle Fourche MS | Regular School | No | Middle | 05 | 08 | 2018 | grade_10 | 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]);