enrollments
Data source: Big Local News · About: Big Local
4,696 rows where grade = "grade_7" and state = "SD" sorted by district descending
This data as json, CSV (advanced)
Link | rowid | state | county | county_state_id | admin_level | district_nces_id | district_state_id | district_state_type | district ▲ | school_nces_id | school_state_id | school | school_state_type | ccd_school_type | ccd_charter_school | ccd_school_lvl | ccd_school_low_grade | ccd_school_high_grade | year | term | grade | white | black | hispanic | native_american | native_american_alaskan_native | asian | native_hawaiian | asian_pacific_islander | native_hawaiian_pacific_islander | pacific_islander | multiracial | unknown_race | male | female | non_binary | unknown_gender | ell | ell_percent | homeless | homeless_percent | low_income | free_and_reduced | free_and_reduced_percent | disability | section_504 | total | white_int | black_int | hispanic_int | native_american_int | native_american_alaskan_native_int | asian_int | native_hawaiian_int | asian_pacific_islander_int | native_hawaiian_pacific_islander_int | pacific_islander_int | multiracial_int | unknown_race_int | male_int | female_int | non_binary_int | unknown_gender_int | ell_int | homeless_int | low_income_int | free_and_reduced_int | disability_int | section_504_int | total_int |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
260499 | 260499 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000791 | 3 | Beadle Elem | Regular School | No | Elementary | KG | 05 | 2018 | 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 | ||||||||||||||||||||||||||||||||||||
260500 | 260500 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000793 | 4 | Lincoln Elem | Regular School | No | Elementary | KG | 05 | 2018 | 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 | ||||||||||||||||||||||||||||||||||||
260501 | 260501 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000795 | 5 | Stewart Elem | Regular School | No | Elementary | KG | 05 | 2018 | 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 | ||||||||||||||||||||||||||||||||||||
260502 | 260502 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043001009 | 6 | Webster Elem | Regular School | No | Elementary | PK | 05 | 2018 | 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 | ||||||||||||||||||||||||||||||||||||
260503 | 260503 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000798 | 1 | Yankton Hi Sch | Regular School | No | High | 09 | 12 | 2018 | 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 | ||||||||||||||||||||||||||||||||||||
260504 | 260504 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043010799 | 2 | Yankton Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 187.0 | 3.0 | 18.0 | 10.0 | 1.0 | 3.0 | 112.0 | 110.0 | 222.0 | 187 | 3 | 18 | 10 | 1 | 3 | 112 | 110 | 222 | ||||||||||||||||||||||||||||||||||||
367758 | 367758 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000791 | 3 | Beadle Elem | Regular School | No | Elementary | KG | 05 | 2019 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
367759 | 367759 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000793 | 4 | Lincoln Elem | Regular School | No | Elementary | KG | 05 | 2019 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
367760 | 367760 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000795 | 5 | Stewart Elem | Regular School | No | Elementary | KG | 05 | 2019 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
367761 | 367761 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043001009 | 6 | Webster Elem | Regular School | No | Elementary | PK | 05 | 2019 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
367762 | 367762 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000798 | 1 | Yankton Hi Sch | Regular School | No | High | 09 | 12 | 2019 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
367763 | 367763 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043010799 | 2 | Yankton Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 169.0 | 3.0 | 17.0 | 13.0 | 0.0 | 11.0 | 115.0 | 98.0 | 213.0 | 169 | 3 | 17 | 13 | 0 | 11 | 115 | 98 | 213 | ||||||||||||||||||||||||||||||||||||
459668 | 459668 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000791 | 3 | Beadle Elementary | Regular School | Not applicable | Elementary | KG | 05 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||
459669 | 459669 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000793 | 4 | Lincoln Elementary | Regular School | Not applicable | Elementary | KG | 05 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||
459670 | 459670 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000795 | 5 | Stewart Elementary | Regular School | Not applicable | Elementary | KG | 05 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||
459671 | 459671 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043001009 | 6 | Webster Elementary | Regular School | Not applicable | Elementary | PK | 05 | 2021 | 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 | ||||||||||||||||||||||||||||||||||
459672 | 459672 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000798 | 1 | Yankton High School | Regular School | Not applicable | High | 09 | 12 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||
459673 | 459673 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043010799 | 2 | Yankton Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2021 | grade_7 | 185.0 | 2.0 | 22.0 | 8.0 | 0.0 | 0.0 | 2.0 | 115.0 | 104.0 | 219.0 | 185 | 2 | 22 | 8 | 0 | 0 | 2 | 115 | 104 | 219 | ||||||||||||||||||||||||||||||||||
498059 | 498059 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000791 | 3 | Beadle Elementary | Regular School | Not applicable | Elementary | KG | 05 | 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 | ||||||||||||||||||||||||||||||||||||
498060 | 498060 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000793 | 4 | Lincoln Elementary | Regular School | Not applicable | Elementary | KG | 05 | 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 | ||||||||||||||||||||||||||||||||||||
498061 | 498061 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000795 | 5 | Stewart Elementary | Regular School | Not applicable | Elementary | KG | 05 | 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 | ||||||||||||||||||||||||||||||||||||
498062 | 498062 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043001009 | 6 | Webster Elementary | Regular School | Not applicable | Elementary | PK | 05 | 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 | ||||||||||||||||||||||||||||||||||||
498063 | 498063 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000798 | 1 | Yankton High School | Regular School | Not applicable | High | 09 | 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 | ||||||||||||||||||||||||||||||||||||
498064 | 498064 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043010799 | 2 | Yankton Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2020 | grade_7 | 176.0 | 0.0 | 15.0 | 6.0 | 2.0 | 8.0 | 108.0 | 99.0 | 207.0 | 176 | 0 | 15 | 6 | 2 | 8 | 108 | 99 | 207 | ||||||||||||||||||||||||||||||||||||
2972284 | 2972284 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000791 | 3 | Beadle Elem | Regular 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 | ||||||||||||||||||||||||||||||||||||
2972285 | 2972285 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000793 | 4 | Lincoln Elem | Regular 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 | ||||||||||||||||||||||||||||||||||||
2972286 | 2972286 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000795 | 5 | Stewart Elem | Regular School | No | 1 | PK | 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 | ||||||||||||||||||||||||||||||||||
2972287 | 2972287 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043001009 | 6 | Webster Elem | Regular School | No | 1 | PK | 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 | ||||||||||||||||||||||||||||||||||||
2972288 | 2972288 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000798 | 1 | Yankton Hi Sch | Regular School | No | 3 | 09 | 12 | 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 | ||||||||||||||||||||||||||||||||||||
2972289 | 2972289 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000799 | 2 | Yankton Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 172.0 | 3.0 | 13.0 | 10.0 | 1.0 | 5.0 | 109.0 | 95.0 | 204.0 | 172 | 3 | 13 | 10 | 1 | 5 | 109 | 95 | 204 | ||||||||||||||||||||||||||||||||||||
3016892 | 3016892 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000791 | 3 | Beadle Elem | Regular School | No | Elementary | KG | 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 | ||||||||||||||||||||||||||||||||||||||
3016893 | 3016893 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000793 | 4 | Lincoln Elem | Regular School | No | Elementary | KG | 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 | ||||||||||||||||||||||||||||||||||||
3016894 | 3016894 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000795 | 5 | Stewart Elem | Regular School | No | Elementary | KG | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
3016895 | 3016895 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043001009 | 6 | Webster 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 | ||||||||||||||||||||||||||||||||||||
3016896 | 3016896 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000798 | 1 | Yankton Hi Sch | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
3016897 | 3016897 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043010799 | 2 | Yankton Middle School | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 177.0 | 4.0 | 12.0 | 10.0 | 4.0 | 3.0 | 112.0 | 98.0 | 210.0 | 177 | 4 | 12 | 10 | 4 | 3 | 112 | 98 | 210 | ||||||||||||||||||||||||||||||||||||
3354788 | 3354788 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000791 | 3 | Beadle Elem | Regular 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 | ||||||||||||||||||||||||||||||||||||||
3354789 | 3354789 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000793 | 4 | Lincoln Elem | Regular 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 | ||||||||||||||||||||||||||||||||||||
3354790 | 3354790 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000795 | 5 | Stewart 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
3354791 | 3354791 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043001009 | 6 | Webster 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 | ||||||||||||||||||||||||||||||||||||
3354792 | 3354792 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043000798 | 1 | Yankton Hi Sch | 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
3354793 | 3354793 | SD | school | 4680430 | 63003 | Yankton 63-3 | 468043010799 | 2 | Yankton Middle School | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 149.0 | 2.0 | 9.0 | 12.0 | 0.0 | 0.0 | 90.0 | 82.0 | 172.0 | 149 | 2 | 9 | 12 | 0 | 0 | 90 | 82 | 172 | ||||||||||||||||||||||||||||||||||||
260431 | 260431 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000789 | 3 | Woonsocket Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 17.0 | 0.0 | 1.0 | 0.0 | 1.0 | 9.0 | 10.0 | 19.0 | 17 | 0 | 1 | 0 | 1 | 9 | 10 | 19 | ||||||||||||||||||||||||||||||||||||||
260432 | 260432 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000790 | 1 | Woonsocket High School | Regular School | No | High | 09 | 12 | 2018 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
367690 | 367690 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000789 | 3 | Woonsocket Elementary | Regular School | No | Elementary | PK | 08 | 2019 | grade_7 | 16.0 | 0.0 | 2.0 | 0.0 | 1.0 | 2.0 | 9.0 | 12.0 | 21.0 | 16 | 0 | 2 | 0 | 1 | 2 | 9 | 12 | 21 | ||||||||||||||||||||||||||||||||||||
367691 | 367691 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000790 | 1 | Woonsocket High School | Regular School | No | High | 09 | 12 | 2019 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
459600 | 459600 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000789 | 3 | Woonsocket Elementary | Regular School | Not applicable | Elementary | PK | 08 | 2021 | grade_7 | 26.0 | 0.0 | 0.0 | 0.0 | 14.0 | 12.0 | 26.0 | 26 | 0 | 0 | 0 | 14 | 12 | 26 | ||||||||||||||||||||||||||||||||||||||||
459601 | 459601 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000790 | 1 | Woonsocket High School | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
497991 | 497991 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000789 | 3 | Woonsocket Elementary | Regular School | Not applicable | Elementary | PK | 08 | 2020 | grade_7 | 23.0 | 0.0 | 2.0 | 0.0 | 1.0 | 0.0 | 14.0 | 12.0 | 26.0 | 23 | 0 | 2 | 0 | 1 | 0 | 14 | 12 | 26 | ||||||||||||||||||||||||||||||||||||
497992 | 497992 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000790 | 1 | Woonsocket High School | Regular School | Not applicable | High | 09 | 12 | 2020 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2972216 | 2972216 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000789 | 3 | Woonsocket Elementary | Regular School | No | 1 | PK | 08 | 2015 | grade_7 | 22.0 | 1.0 | 0.0 | 0.0 | 9.0 | 14.0 | 23.0 | 22 | 1 | 0 | 0 | 9 | 14 | 23 | ||||||||||||||||||||||||||||||||||||||||
2972217 | 2972217 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000790 | 1 | Woonsocket High School | Regular School | No | 3 | 09 | 12 | 2015 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
3016824 | 3016824 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000789 | 3 | Woonsocket Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 14.0 | 0.0 | 0.0 | 0.0 | 6.0 | 8.0 | 14.0 | 14 | 0 | 0 | 0 | 6 | 8 | 14 | ||||||||||||||||||||||||||||||||||||||||
3016825 | 3016825 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000790 | 1 | Woonsocket 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 | ||||||||||||||||||||||||||||||||||||||||||
3354720 | 3354720 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000789 | 3 | Woonsocket Elementary | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 15.0 | 1.0 | 0.0 | 0.0 | 8.0 | 8.0 | 16.0 | 15 | 1 | 0 | 0 | 8 | 8 | 16 | ||||||||||||||||||||||||||||||||||||||||
3354721 | 3354721 | SD | school | 4680190 | 55004 | Woonsocket 55-4 | 468019000790 | 1 | Woonsocket 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 | ||||||||||||||||||||||||||||||||||||||||||
260392 | 260392 | SD | school | 4680100 | 2006 | Wolsey-Wessington 02-6 | 468010000783 | 2 | Wolsey-Wessington Elementary | Regular School | No | Elementary | PK | 04 | 2018 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
260393 | 260393 | SD | school | 4680100 | 2006 | Wolsey-Wessington 02-6 | 468010000784 | 1 | Wolsey-Wessington High School | Regular School | No | High | 09 | 12 | 2018 | 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 | ||||||||||||||||||||||||||||||||||||||
260394 | 260394 | SD | school | 4680100 | 2006 | Wolsey-Wessington 02-6 | 468010000546 | 3 | Wolsey-Wessington Middle School | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 24.0 | 1.0 | 2.0 | 1.0 | 17.0 | 11.0 | 28.0 | 24 | 1 | 2 | 1 | 17 | 11 | 28 | ||||||||||||||||||||||||||||||||||||||||
367651 | 367651 | SD | school | 4680100 | 2006 | Wolsey-Wessington 02-6 | 468010000783 | 2 | Wolsey-Wessington Elementary | Regular School | No | Elementary | PK | 04 | 2019 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
367652 | 367652 | SD | school | 4680100 | 2006 | Wolsey-Wessington 02-6 | 468010000784 | 1 | Wolsey-Wessington High School | Regular School | No | High | 09 | 12 | 2019 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
367653 | 367653 | SD | school | 4680100 | 2006 | Wolsey-Wessington 02-6 | 468010000546 | 3 | Wolsey-Wessington Middle School | Regular School | No | Middle | 05 | 08 | 2019 | grade_7 | 21.0 | 6.0 | 2.0 | 9.0 | 20.0 | 29.0 | 21 | 6 | 2 | 9 | 20 | 29 | ||||||||||||||||||||||||||||||||||||||||||
459561 | 459561 | SD | school | 4680100 | 2006 | Wolsey-Wessington 02-6 | 468010000783 | 2 | Wolsey-Wessington Elementary | Regular School | Not applicable | Elementary | PK | 05 | 2021 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
459562 | 459562 | SD | school | 4680100 | 2006 | Wolsey-Wessington 02-6 | 468010000784 | 1 | Wolsey-Wessington High School | Regular School | Not applicable | High | 09 | 12 | 2021 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
459563 | 459563 | SD | school | 4680100 | 2006 | Wolsey-Wessington 02-6 | 468010000546 | 3 | Wolsey-Wessington Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2021 | grade_7 | 24.0 | 1.0 | 1.0 | 14.0 | 12.0 | 26.0 | 24 | 1 | 1 | 14 | 12 | 26 | ||||||||||||||||||||||||||||||||||||||||||
497952 | 497952 | SD | school | 4680100 | 2006 | Wolsey-Wessington 02-6 | 468010000783 | 2 | Wolsey-Wessington Elementary | Regular School | Not applicable | Elementary | PK | 04 | 2020 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
497953 | 497953 | SD | school | 4680100 | 2006 | Wolsey-Wessington 02-6 | 468010000784 | 1 | Wolsey-Wessington High School | Regular School | Not applicable | High | 09 | 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 | ||||||||||||||||||||||||||||||||||||||||
497954 | 497954 | SD | school | 4680100 | 2006 | Wolsey-Wessington 02-6 | 468010000546 | 3 | Wolsey-Wessington Middle School | Regular School | Not applicable | Middle | 05 | 08 | 2020 | grade_7 | 26.0 | 4.0 | 1.0 | 16.0 | 15.0 | 31.0 | 26 | 4 | 1 | 16 | 15 | 31 | ||||||||||||||||||||||||||||||||||||||||||
2972177 | 2972177 | SD | school | 4680100 | 2006 | Wolsey-Wessington 02-6 | 468010000783 | 2 | Wolsey-Wessington Elementary | Regular School | No | 1 | PK | 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 | ||||||||||||||||||||||||||||||||||||||
2972178 | 2972178 | SD | school | 4680100 | 2006 | Wolsey-Wessington 02-6 | 468010000784 | 1 | Wolsey-Wessington High School | Regular School | No | 3 | 09 | 12 | 2015 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
2972179 | 2972179 | SD | school | 4680100 | 2006 | Wolsey-Wessington 02-6 | 468010000546 | 3 | Wolsey-Wessington Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 19.0 | 2.0 | 1.0 | 0.0 | 1.0 | 11.0 | 12.0 | 23.0 | 19 | 2 | 1 | 0 | 1 | 11 | 12 | 23 | ||||||||||||||||||||||||||||||||||||||
3016785 | 3016785 | SD | school | 4680100 | 2006 | Wolsey-Wessington 02-6 | 468010000783 | 2 | Wolsey-Wessington Elementary | Regular School | No | Elementary | PK | 04 | 2017 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
3016786 | 3016786 | SD | school | 4680100 | 2006 | Wolsey-Wessington 02-6 | 468010000784 | 1 | Wolsey-Wessington 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 | ||||||||||||||||||||||||||||||||||||||
3016787 | 3016787 | SD | school | 4680100 | 2006 | Wolsey-Wessington 02-6 | 468010000546 | 3 | Wolsey-Wessington Middle School | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 25.0 | 2.0 | 3.0 | 0.0 | 1.0 | 8.0 | 23.0 | 31.0 | 25 | 2 | 3 | 0 | 1 | 8 | 23 | 31 | ||||||||||||||||||||||||||||||||||||||
3354681 | 3354681 | SD | school | 4680100 | 2006 | Wolsey-Wessington 02-6 | 468010000783 | 2 | Wolsey-Wessington Elementary | Regular School | No | 1 | PK | 06 | 2016 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
3354682 | 3354682 | SD | school | 4680100 | 2006 | Wolsey-Wessington 02-6 | 468010000784 | 1 | Wolsey-Wessington 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 | ||||||||||||||||||||||||||||||||||||||
3354683 | 3354683 | SD | school | 4680100 | 2006 | Wolsey-Wessington 02-6 | 468010000546 | 3 | Wolsey-Wessington Middle School | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 26.0 | 1.0 | 1.0 | 1.0 | 1.0 | 16.0 | 14.0 | 30.0 | 26 | 1 | 1 | 1 | 1 | 16 | 14 | 30 | ||||||||||||||||||||||||||||||||||||||
260344 | 260344 | SD | school | 4679710 | 59002 | Winner 59-2 | 467971000479 | 4 | Winner Elementary | Regular School | No | Elementary | KG | 05 | 2018 | 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 | ||||||||||||||||||||||||||||||||||||
260345 | 260345 | SD | school | 4679710 | 59002 | Winner 59-2 | 467971000781 | 1 | Winner High School | Regular School | No | High | 09 | 12 | 2018 | 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 | ||||||||||||||||||||||||||||||||||||
260346 | 260346 | SD | school | 4679710 | 59002 | Winner 59-2 | 467971000782 | 2 | Winner Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 36.0 | 0.0 | 12.0 | 0.0 | 24.0 | 24.0 | 48.0 | 36 | 0 | 12 | 0 | 24 | 24 | 48 | ||||||||||||||||||||||||||||||||||||||||
367603 | 367603 | SD | school | 4679710 | 59002 | Winner 59-2 | 467971000479 | 4 | Winner Elementary | Regular School | No | Elementary | KG | 05 | 2019 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
367604 | 367604 | SD | school | 4679710 | 59002 | Winner 59-2 | 467971000781 | 1 | Winner High School | Regular School | No | High | 09 | 12 | 2019 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
367605 | 367605 | SD | school | 4679710 | 59002 | Winner 59-2 | 467971000782 | 2 | Winner Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 40.0 | 0.0 | 18.0 | 0.0 | 32.0 | 26.0 | 58.0 | 40 | 0 | 18 | 0 | 32 | 26 | 58 | ||||||||||||||||||||||||||||||||||||||||
459513 | 459513 | SD | school | 4679710 | 59002 | Winner 59-2 | 467971000479 | 4 | Winner Elementary | Regular School | Not applicable | Elementary | KG | 05 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||
459514 | 459514 | SD | school | 4679710 | 59002 | Winner 59-2 | 467971000781 | 1 | Winner High School | Regular School | Not applicable | High | 09 | 12 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||
459515 | 459515 | SD | school | 4679710 | 59002 | Winner 59-2 | 467971000782 | 2 | Winner Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2021 | grade_7 | 30.0 | 2.0 | 18.0 | 0.0 | 21.0 | 29.0 | 50.0 | 30 | 2 | 18 | 0 | 21 | 29 | 50 | ||||||||||||||||||||||||||||||||||||||||
497904 | 497904 | SD | school | 4679710 | 59002 | Winner 59-2 | 467971000479 | 4 | Winner Elementary | Regular School | Not applicable | Elementary | KG | 05 | 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 | ||||||||||||||||||||||||||||||||||||
497905 | 497905 | SD | school | 4679710 | 59002 | Winner 59-2 | 467971000781 | 1 | Winner High School | Regular School | Not applicable | High | 09 | 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 | ||||||||||||||||||||||||||||||||||||
497906 | 497906 | SD | school | 4679710 | 59002 | Winner 59-2 | 467971000782 | 2 | Winner Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2020 | grade_7 | 31.0 | 0.0 | 16.0 | 28.0 | 19.0 | 47.0 | 31 | 0 | 16 | 28 | 19 | 47 | ||||||||||||||||||||||||||||||||||||||||||
2972129 | 2972129 | SD | school | 4679710 | 59002 | Winner 59-2 | 467971000479 | 4 | Winner Elementary | Regular School | No | 1 | PK | 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 | ||||||||||||||||||||||||||||||||||||||
2972130 | 2972130 | SD | school | 4679710 | 59002 | Winner 59-2 | 467971000781 | 1 | Winner High School | Regular School | No | 3 | 09 | 12 | 2015 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2972131 | 2972131 | SD | school | 4679710 | 59002 | Winner 59-2 | 467971000782 | 2 | Winner Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 32.0 | 0.0 | 18.0 | 0.0 | 25.0 | 25.0 | 50.0 | 32 | 0 | 18 | 0 | 25 | 25 | 50 | ||||||||||||||||||||||||||||||||||||||||
3016737 | 3016737 | SD | school | 4679710 | 59002 | Winner 59-2 | 467971000479 | 4 | Winner Elementary | 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 | ||||||||||||||||||||||||||||||||||||||
3016738 | 3016738 | SD | school | 4679710 | 59002 | Winner 59-2 | 467971000781 | 1 | Winner 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
3016739 | 3016739 | SD | school | 4679710 | 59002 | Winner 59-2 | 467971000782 | 2 | Winner Middle School | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 39.0 | 0.0 | 0.0 | 12.0 | 2.0 | 25.0 | 28.0 | 53.0 | 39 | 0 | 0 | 12 | 2 | 25 | 28 | 53 | ||||||||||||||||||||||||||||||||||||||
3354633 | 3354633 | SD | school | 4679710 | 59002 | Winner 59-2 | 467971000479 | 4 | Winner Elementary | 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 | ||||||||||||||||||||||||||||||||||||
3354634 | 3354634 | SD | school | 4679710 | 59002 | Winner 59-2 | 467971000781 | 1 | Winner 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 | ||||||||||||||||||||||||||||||||||||||||||
3354635 | 3354635 | SD | school | 4679710 | 59002 | Winner 59-2 | 467971000782 | 2 | Winner Middle School | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 33.0 | 1.0 | 19.0 | 1.0 | 23.0 | 31.0 | 54.0 | 33 | 1 | 19 | 1 | 23 | 31 | 54 | ||||||||||||||||||||||||||||||||||||||||
260296 | 260296 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300757 | 2 | Wilmot Elem | Regular School | No | Elementary | PK | 06 | 2018 | 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 | ||||||||||||||||||||||||||||||||||||||
260297 | 260297 | SD | school | 4600003 | 54007 | Wilmot 54-7 | 460000300758 | 1 | Wilmot Hi Sch | Regular School | No | High | 09 | 12 | 2018 | grade_7 | 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]);