enrollments
Data source: Big Local News · About: Big Local
4,696 rows where grade = "grade_7" and state = "SD" sorted by district_state_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
254040 | 254040 | SD | school | 4632430 | 10001 | Herreid 10-1 | 463243000277 | 2 | Herreid 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 | ||||||||||||||||||||||||||||||||||||||||||
254041 | 254041 | SD | school | 4632430 | 10001 | Herreid 10-1 | 463243000278 | 1 | Herreid 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 | ||||||||||||||||||||||||||||||||||||||||||
254042 | 254042 | SD | school | 4632430 | 10001 | Herreid 10-1 | 463243000910 | 3 | Herreid Middle Sch | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 3.0 | 0.0 | 1.0 | 1.0 | 4.0 | 1.0 | 5.0 | 3 | 0 | 1 | 1 | 4 | 1 | 5 | ||||||||||||||||||||||||||||||||||||||||
361267 | 361267 | SD | school | 4632430 | 10001 | Herreid 10-1 | 463243000277 | 2 | Herreid 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 | ||||||||||||||||||||||||||||||||||||||||||
361268 | 361268 | SD | school | 4632430 | 10001 | Herreid 10-1 | 463243000278 | 1 | Herreid 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 | ||||||||||||||||||||||||||||||||||||||||||
361269 | 361269 | SD | school | 4632430 | 10001 | Herreid 10-1 | 463243000910 | 3 | Herreid Middle Sch | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 9.0 | 0.0 | 0.0 | 6.0 | 3.0 | 9.0 | 9 | 0 | 0 | 6 | 3 | 9 | ||||||||||||||||||||||||||||||||||||||||||
453113 | 453113 | SD | school | 4632430 | 10001 | Herreid 10-1 | 463243000277 | 2 | Herreid Elem | 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 | ||||||||||||||||||||||||||||||||||||||||
453114 | 453114 | SD | school | 4632430 | 10001 | Herreid 10-1 | 463243000278 | 1 | Herreid Hi Sch | 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 | ||||||||||||||||||||||||||||||||||||||||||
453115 | 453115 | SD | school | 4632430 | 10001 | Herreid 10-1 | 463243000910 | 3 | Herreid Middle Sch | Regular School | Not applicable | Middle | 06 | 08 | 2021 | grade_7 | 6.0 | 1.0 | 1.0 | 4.0 | 4.0 | 8.0 | 6 | 1 | 1 | 4 | 4 | 8 | ||||||||||||||||||||||||||||||||||||||||||
491536 | 491536 | SD | school | 4632430 | 10001 | Herreid 10-1 | 463243000277 | 2 | Herreid Elem | 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 | ||||||||||||||||||||||||||||||||||||||||
491537 | 491537 | SD | school | 4632430 | 10001 | Herreid 10-1 | 463243000278 | 1 | Herreid Hi Sch | 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 | ||||||||||||||||||||||||||||||||||||||||||
491538 | 491538 | SD | school | 4632430 | 10001 | Herreid 10-1 | 463243000910 | 3 | Herreid Middle Sch | Regular School | Not applicable | Middle | 06 | 08 | 2020 | grade_7 | 10.0 | 0.0 | 4.0 | 6.0 | 10.0 | 10 | 0 | 4 | 6 | 10 | ||||||||||||||||||||||||||||||||||||||||||||
2965809 | 2965809 | SD | school | 4632430 | 10001 | Herreid 10-1 | 463243000277 | 2 | Herreid 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 | ||||||||||||||||||||||||||||||||||||||||||||
2965810 | 2965810 | SD | school | 4632430 | 10001 | Herreid 10-1 | 463243000278 | 1 | Herreid 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 | ||||||||||||||||||||||||||||||||||||||||||
2965811 | 2965811 | SD | school | 4632430 | 10001 | Herreid 10-1 | 463243000910 | 3 | Herreid Middle Sch | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 13.0 | 0.0 | 7.0 | 6.0 | 13.0 | 13 | 0 | 7 | 6 | 13 | ||||||||||||||||||||||||||||||||||||||||||||
3010497 | 3010497 | SD | school | 4632430 | 10001 | Herreid 10-1 | 463243000277 | 2 | Herreid 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 | ||||||||||||||||||||||||||||||||||||||||
3010498 | 3010498 | SD | school | 4632430 | 10001 | Herreid 10-1 | 463243000278 | 1 | Herreid 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 | ||||||||||||||||||||||||||||||||||||||||||
3010499 | 3010499 | SD | school | 4632430 | 10001 | Herreid 10-1 | 463243000910 | 3 | Herreid Middle Sch | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 6.0 | 0.0 | 0.0 | 0.0 | 4.0 | 2.0 | 6.0 | 6 | 0 | 0 | 0 | 4 | 2 | 6 | ||||||||||||||||||||||||||||||||||||||||
3348393 | 3348393 | SD | school | 4632430 | 10001 | Herreid 10-1 | 463243000277 | 2 | Herreid 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 | ||||||||||||||||||||||||||||||||||||||||||
3348394 | 3348394 | SD | school | 4632430 | 10001 | Herreid 10-1 | 463243000278 | 1 | Herreid Hi Sch | Regular School | No | 3 | 09 | 12 | 2016 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
3348395 | 3348395 | SD | school | 4632430 | 10001 | Herreid 10-1 | 463243000910 | 3 | Herreid Middle Sch | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 6.0 | 1.0 | 0.0 | 0.0 | 4.0 | 3.0 | 7.0 | 6 | 1 | 0 | 0 | 4 | 3 | 7 | ||||||||||||||||||||||||||||||||||||||||
256938 | 256938 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571001274 | 5 | Aurora Plains Academy High School | Alternative 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 | ||||||||||||||||||||||||||||||||||||||
256939 | 256939 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571001276 | 4 | Aurora Plains Academy Middle School | Alternative School | No | Middle | 04 | 08 | 2018 | grade_7 | 3.0 | 2.0 | 0.0 | 1.0 | 6.0 | 0.0 | 6.0 | 3 | 2 | 0 | 1 | 6 | 0 | 6 | ||||||||||||||||||||||||||||||||||||||||
256940 | 256940 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571000507 | 2 | Plankinton Elementary | 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 | ||||||||||||||||||||||||||||||||||||||||
256941 | 256941 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571000508 | 1 | Plankinton 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 | ||||||||||||||||||||||||||||||||||||||||||||
256942 | 256942 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571000927 | 3 | Plankinton Junior High | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 10.0 | 4.0 | 8.0 | 6.0 | 14.0 | 10 | 4 | 8 | 6 | 14 | ||||||||||||||||||||||||||||||||||||||||||||
364213 | 364213 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571001274 | 5 | Aurora Plains Academy High School | Alternative 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 | ||||||||||||||||||||||||||||||||||||||
364214 | 364214 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571001276 | 4 | Aurora Plains Academy Middle School | Alternative School | No | Middle | 04 | 08 | 2019 | grade_7 | 4.0 | 1.0 | 1.0 | 2.0 | 0.0 | 7.0 | 1.0 | 8.0 | 4 | 1 | 1 | 2 | 0 | 7 | 1 | 8 | ||||||||||||||||||||||||||||||||||||||
364215 | 364215 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571000507 | 2 | Plankinton Elementary | Regular School | No | Elementary | PK | 06 | 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 | ||||||||||||||||||||||||||||||||||||||
364216 | 364216 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571000508 | 1 | Plankinton 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 | ||||||||||||||||||||||||||||||||||||||||||
364217 | 364217 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571000927 | 3 | Plankinton Junior High | Regular School | No | Middle | 07 | 08 | 2019 | grade_7 | 22.0 | 0.0 | 1.0 | 11.0 | 12.0 | 23.0 | 22 | 0 | 1 | 11 | 12 | 23 | ||||||||||||||||||||||||||||||||||||||||||
456091 | 456091 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571001274 | 5 | Aurora Plains Academy High School | Alternative 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 | ||||||||||||||||||||||||||||||||||||||||||
456092 | 456092 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571001276 | 4 | Aurora Plains Academy Middle School | Alternative School | Not applicable | Middle | 04 | 08 | 2021 | grade_7 | 0.0 | 0.0 | 2.0 | 0.0 | 0.0 | 2.0 | 2.0 | 0 | 0 | 2 | 0 | 0 | 2 | 2 | ||||||||||||||||||||||||||||||||||||||||
456093 | 456093 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571000507 | 2 | Plankinton Elementary | Regular School | Not applicable | Elementary | PK | 06 | 2021 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
456094 | 456094 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571000508 | 1 | Plankinton 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 | ||||||||||||||||||||||||||||||||||||||||
456095 | 456095 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571000927 | 3 | Plankinton Junior High | Regular School | Not applicable | Middle | 07 | 08 | 2021 | grade_7 | 15.0 | 7.0 | 0.0 | 12.0 | 10.0 | 22.0 | 15 | 7 | 0 | 12 | 10 | 22 | ||||||||||||||||||||||||||||||||||||||||||
494498 | 494498 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571001274 | 5 | Aurora Plains Academy High School | Alternative 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 | ||||||||||||||||||||||||||||||||||||||||
494499 | 494499 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571001276 | 4 | Aurora Plains Academy Middle School | Alternative School | Not applicable | Middle | 04 | 08 | 2020 | grade_7 | 2.0 | 1.0 | 0.0 | 6.0 | 7.0 | 2.0 | 9.0 | 2 | 1 | 0 | 6 | 7 | 2 | 9 | ||||||||||||||||||||||||||||||||||||||||
494500 | 494500 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571000507 | 2 | Plankinton Elementary | Regular School | Not applicable | Elementary | PK | 06 | 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 | ||||||||||||||||||||||||||||||||||||||
494501 | 494501 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571000508 | 1 | Plankinton 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 | ||||||||||||||||||||||||||||||||||||||||||
494502 | 494502 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571000927 | 3 | Plankinton Junior High | Regular School | Not applicable | Middle | 07 | 08 | 2020 | grade_7 | 13.0 | 10.0 | 2.0 | 0.0 | 13.0 | 12.0 | 25.0 | 13 | 10 | 2 | 0 | 13 | 12 | 25 | ||||||||||||||||||||||||||||||||||||||||
2968547 | 2968547 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571001274 | 5 | Aurora Plains Academy High School | Alternative Education 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 | ||||||||||||||||||||||||||||||||||||||||||
2968548 | 2968548 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571001276 | 4 | Aurora Plains Academy Middle School | Alternative Education School | No | 2 | 05 | 08 | 2015 | grade_7 | 4.0 | 0.0 | 2.0 | 0.0 | 6.0 | 0.0 | 6.0 | 4 | 0 | 2 | 0 | 6 | 0 | 6 | ||||||||||||||||||||||||||||||||||||||||
2968549 | 2968549 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571000507 | 2 | Plankinton Elementary | Regular School | No | 1 | PK | 06 | 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 | ||||||||||||||||||||||||||||||||||||||
2968550 | 2968550 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571000508 | 1 | Plankinton 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 | ||||||||||||||||||||||||||||||||||||||||||
2968551 | 2968551 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571000927 | 3 | Plankinton Junior High | Regular School | No | 2 | 07 | 08 | 2015 | grade_7 | 13.0 | 3.0 | 8.0 | 8.0 | 16.0 | 13 | 3 | 8 | 8 | 16 | ||||||||||||||||||||||||||||||||||||||||||||
3013379 | 3013379 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571001274 | 5 | Aurora Plains Academy High School | Alternative 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 | ||||||||||||||||||||||||||||||||||||||
3013380 | 3013380 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571001276 | 4 | Aurora Plains Academy Middle School | Alternative School | No | Elementary | 04 | 08 | 2017 | grade_7 | 7.0 | 1.0 | 0.0 | 2.0 | 7.0 | 3.0 | 10.0 | 7 | 1 | 0 | 2 | 7 | 3 | 10 | ||||||||||||||||||||||||||||||||||||||||
3013381 | 3013381 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571000507 | 2 | Plankinton Elementary | Regular School | No | Elementary | PK | 06 | 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 | ||||||||||||||||||||||||||||||||||||||
3013382 | 3013382 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571000508 | 1 | Plankinton 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 | ||||||||||||||||||||||||||||||||||||||||||||
3013383 | 3013383 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571000927 | 3 | Plankinton Junior High | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 17.0 | 6.0 | 11.0 | 12.0 | 23.0 | 17 | 6 | 11 | 12 | 23 | ||||||||||||||||||||||||||||||||||||||||||||
3351243 | 3351243 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571001274 | 5 | Aurora Plains Academy High School | Alternative Education 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 | ||||||||||||||||||||||||||||||||||||||||||
3351244 | 3351244 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571001276 | 4 | Aurora Plains Academy Middle School | Alternative Education School | No | 2 | 05 | 08 | 2016 | grade_7 | 2.0 | 0.0 | 0.0 | 1.0 | 2.0 | 3.0 | 2.0 | 5.0 | 2 | 0 | 0 | 1 | 2 | 3 | 2 | 5 | ||||||||||||||||||||||||||||||||||||||
3351245 | 3351245 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571000507 | 2 | Plankinton 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
3351246 | 3351246 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571000508 | 1 | Plankinton 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 | ||||||||||||||||||||||||||||||||||||||||||
3351247 | 3351247 | SD | school | 4655710 | 1001 | Plankinton 01-1 | 465571000927 | 3 | Plankinton Junior High | Regular School | No | 2 | 07 | 08 | 2016 | grade_7 | 15.0 | 2.0 | 7.0 | 10.0 | 17.0 | 15 | 2 | 7 | 10 | 17 | ||||||||||||||||||||||||||||||||||||||||||||
2970666 | 2970666 | SD | school | 4669540 | 1002 | Stickney 01-2 | 466954000628 | 2 | Stickney Elementary | Regular School | No | 1 | KG | 06 | 2015 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
2970667 | 2970667 | SD | school | 4669540 | 1002 | Stickney 01-2 | 466954000629 | 1 | Stickney High School | Regular School | No | 3 | 09 | 12 | 2015 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
2970668 | 2970668 | SD | school | 4669540 | 1002 | Stickney 01-2 | 466954001054 | 3 | Stickney Jr High | Regular School | No | 2 | 07 | 08 | 2015 | grade_7 | 7.0 | 4.0 | 3.0 | 7.0 | 7 | 4 | 3 | 7 | ||||||||||||||||||||||||||||||||||||||||||||||
2970669 | 2970669 | SD | school | 4669540 | 1002 | Stickney 01-2 | 466954001330 | 4 | Stickney Pre-School | Regular School | No | 1 | PK | PK | 2015 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
260088 | 260088 | SD | school | 4678510 | 1003 | White Lake 01-3 | 467851000745 | 2 | White Lake Elementary | 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 | ||||||||||||||||||||||||||||||||||||||||
260089 | 260089 | SD | school | 4678510 | 1003 | White Lake 01-3 | 467851000746 | 1 | White Lake 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 | ||||||||||||||||||||||||||||||||||||||||||||
260090 | 260090 | SD | school | 4678510 | 1003 | White Lake 01-3 | 467851000950 | 3 | White Lake JH | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 7.0 | 1.0 | 1.0 | 6.0 | 3.0 | 9.0 | 7 | 1 | 1 | 6 | 3 | 9 | ||||||||||||||||||||||||||||||||||||||||||
367347 | 367347 | SD | school | 4678510 | 1003 | White Lake 01-3 | 467851000745 | 2 | White Lake Elementary | Regular School | No | Elementary | PK | 06 | 2019 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
367348 | 367348 | SD | school | 4678510 | 1003 | White Lake 01-3 | 467851000746 | 1 | White Lake 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 | ||||||||||||||||||||||||||||||||||||||||||||
367349 | 367349 | SD | school | 4678510 | 1003 | White Lake 01-3 | 467851000950 | 3 | White Lake JH | Regular School | No | Middle | 07 | 08 | 2019 | grade_7 | 7.0 | 0.0 | 0.0 | 2.0 | 5.0 | 7.0 | 7 | 0 | 0 | 2 | 5 | 7 | ||||||||||||||||||||||||||||||||||||||||||
459257 | 459257 | SD | school | 4678510 | 1003 | White Lake 01-3 | 467851000745 | 2 | White Lake 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 | ||||||||||||||||||||||||||||||||||||||||||||
459258 | 459258 | SD | school | 4678510 | 1003 | White Lake 01-3 | 467851000746 | 1 | White Lake 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 | ||||||||||||||||||||||||||||||||||||||||||
459259 | 459259 | SD | school | 4678510 | 1003 | White Lake 01-3 | 467851000950 | 3 | White Lake Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2021 | grade_7 | 7.0 | 1.0 | 0.0 | 3.0 | 5.0 | 8.0 | 7 | 1 | 0 | 3 | 5 | 8 | ||||||||||||||||||||||||||||||||||||||||||
497648 | 497648 | SD | school | 4678510 | 1003 | White Lake 01-3 | 467851000745 | 2 | White Lake Elementary | Regular School | Not applicable | Elementary | PK | 06 | 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 | ||||||||||||||||||||||||||||||||||||||
497649 | 497649 | SD | school | 4678510 | 1003 | White Lake 01-3 | 467851000746 | 1 | White Lake 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 | ||||||||||||||||||||||||||||||||||||||||||
497650 | 497650 | SD | school | 4678510 | 1003 | White Lake 01-3 | 467851000950 | 3 | White Lake JH | Regular School | Not applicable | Middle | 07 | 08 | 2020 | grade_7 | 10.0 | 1.0 | 6.0 | 5.0 | 11.0 | 10 | 1 | 6 | 5 | 11 | ||||||||||||||||||||||||||||||||||||||||||||
2971857 | 2971857 | SD | school | 4678510 | 1003 | White Lake 01-3 | 467851000745 | 2 | White Lake Elementary | Regular School | No | 1 | PK | 06 | 2015 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2971858 | 2971858 | SD | school | 4678510 | 1003 | White Lake 01-3 | 467851000746 | 1 | White Lake 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 | ||||||||||||||||||||||||||||||||||||||||||
2971859 | 2971859 | SD | school | 4678510 | 1003 | White Lake 01-3 | 467851000950 | 3 | White Lake JH | Regular School | No | 2 | 07 | 08 | 2015 | grade_7 | 8.0 | 0.0 | 4.0 | 4.0 | 8.0 | 8 | 0 | 4 | 4 | 8 | ||||||||||||||||||||||||||||||||||||||||||||
3016481 | 3016481 | SD | school | 4678510 | 1003 | White Lake 01-3 | 467851000745 | 2 | White Lake Elementary | Regular School | No | Elementary | PK | 06 | 2017 | grade_7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
3016482 | 3016482 | SD | school | 4678510 | 1003 | White Lake 01-3 | 467851000746 | 1 | White Lake 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 | ||||||||||||||||||||||||||||||||||||||||||||
3016483 | 3016483 | SD | school | 4678510 | 1003 | White Lake 01-3 | 467851000950 | 3 | White Lake JH | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 9.0 | 1.0 | 4.0 | 6.0 | 10.0 | 9 | 1 | 4 | 6 | 10 | ||||||||||||||||||||||||||||||||||||||||||||
3354361 | 3354361 | SD | school | 4678510 | 1003 | White Lake 01-3 | 467851000745 | 2 | White Lake 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 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
3354362 | 3354362 | SD | school | 4678510 | 1003 | White Lake 01-3 | 467851000746 | 1 | White Lake 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 | ||||||||||||||||||||||||||||||||||||||||
3354363 | 3354363 | SD | school | 4678510 | 1003 | White Lake 01-3 | 467851000950 | 3 | White Lake JH | Regular School | No | 2 | 07 | 08 | 2016 | grade_7 | 3.0 | 2.0 | 4.0 | 1.0 | 5.0 | 3 | 2 | 4 | 1 | 5 | ||||||||||||||||||||||||||||||||||||||||||||
250122 | 250122 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954000359 | 2 | Andes Central Elementary | 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 | ||||||||||||||||||||||||||||||||||||||||
250123 | 250123 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954000360 | 1 | Andes Central 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 | ||||||||||||||||||||||||||||||||||||||||||
250124 | 250124 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954000850 | 4 | Andes Central Jr High | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 1.0 | 2.0 | 13.0 | 0.0 | 9.0 | 7.0 | 16.0 | 1 | 2 | 13 | 0 | 9 | 7 | 16 | ||||||||||||||||||||||||||||||||||||||||
250125 | 250125 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954001080 | 5 | Lakeview Colony Elem | Regular School | No | Elementary | KG | 08 | 2018 | grade_7 | 2.0 | 1.0 | 1.0 | 2.0 | 2 | 1 | 1 | 2 | ||||||||||||||||||||||||||||||||||||||||||||||
250126 | 250126 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954001379 | 6 | Pease Creek Colony Elementary | Regular School | No | Elementary | KG | 08 | 2018 | grade_7 | 1.0 | 0.0 | 1.0 | 1.0 | 1 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||
357365 | 357365 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954000359 | 2 | Andes Central Elementary | 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 | ||||||||||||||||||||||||||||||||||||||||
357366 | 357366 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954000360 | 1 | Andes Central 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 | ||||||||||||||||||||||||||||||||||||||||
357367 | 357367 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954000850 | 4 | Andes Central Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 6.0 | 1.0 | 12.0 | 2.0 | 8.0 | 13.0 | 21.0 | 6 | 1 | 12 | 2 | 8 | 13 | 21 | ||||||||||||||||||||||||||||||||||||||||
357368 | 357368 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954001080 | 5 | Lakeview Colony Elem | Regular School | No | Elementary | KG | 08 | 2019 | grade_7 | 5.0 | 2.0 | 3.0 | 5.0 | 5 | 2 | 3 | 5 | ||||||||||||||||||||||||||||||||||||||||||||||
357369 | 357369 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954001379 | 6 | Pease Creek Colony Elementary | Regular School | No | Elementary | KG | 08 | 2019 | grade_7 | 4.0 | 0.0 | 4.0 | 4.0 | 4 | 0 | 4 | 4 | ||||||||||||||||||||||||||||||||||||||||||||||
449218 | 449218 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954000359 | 2 | Andes Central 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 | ||||||||||||||||||||||||||||||||||||||||
449219 | 449219 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954000360 | 1 | Andes Central 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 | ||||||||||||||||||||||||||||||||||||||||
449220 | 449220 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954000850 | 4 | Andes Central Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2021 | grade_7 | 9.0 | 1.0 | 9.0 | 3.0 | 9.0 | 13.0 | 22.0 | 9 | 1 | 9 | 3 | 9 | 13 | 22 | ||||||||||||||||||||||||||||||||||||||||
449221 | 449221 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954001080 | 5 | Lakeview Colony Elem | Regular School | Not applicable | Elementary | KG | 08 | 2021 | grade_7 | 4.0 | 4.0 | 0.0 | 4.0 | 4 | 4 | 0 | 4 | ||||||||||||||||||||||||||||||||||||||||||||||
487641 | 487641 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954000359 | 2 | Andes Central 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 | ||||||||||||||||||||||||||||||||||||||||
487642 | 487642 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954000360 | 1 | Andes Central 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 | ||||||||||||||||||||||||||||||||||||||||
487643 | 487643 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954000850 | 4 | Andes Central Middle School | Regular School | Not applicable | Middle | 06 | 08 | 2020 | grade_7 | 3.0 | 13.0 | 1.0 | 9.0 | 8.0 | 17.0 | 3 | 13 | 1 | 9 | 8 | 17 | ||||||||||||||||||||||||||||||||||||||||||
487644 | 487644 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954001080 | 5 | Lakeview Colony Elem | Regular School | Not applicable | Elementary | KG | 08 | 2020 | grade_7 | 3.0 | 1.0 | 2.0 | 3.0 | 3 | 1 | 2 | 3 | ||||||||||||||||||||||||||||||||||||||||||||||
2961914 | 2961914 | SD | school | 4639540 | 11001 | Andes Central 11-1 | 463954000359 | 2 | Andes Central Elementary | Regular School | No | 1 | PK | 06 | 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 |
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]);