school-districts-reopening
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- district
- Name of public school district.
- enr_total
- Total students enrolled in the district.
- elem_enr
- Total students enrolled in grades K-5. Subset of enr_total.
- middle_enr
- Total students enrolled in grades 6-8. Subset of enr_total.
- high_enr
- Total students enrolled in grades 9-12. Subset of enr_total.
- elem_in_school
- Students in grades K-5 that have the option to participate in an in-person or hybrid learning.
- middle_in_school
- Students in grades 6-8 grades that have the option to participate in an in-person or hybrid learning.
- high_in_school
- Students in grades 9-12 grades that have the option to participate in an in-person or hybrid learning.
- total_in_school
- Sum of elem_in_school,middle_in_school and high_in_school.
- reopening_plan
- Link to district's reopening plan.
- operational_status_elem
- Operational status as of update_date for the district's elementary schools.
- operational_status_middle
- Operational status as of update_date for the district's middle schools.
- operational_status_high
- Operational status as of update_date for the district's high schools.
- elem_reopening_date
- Planned reopening date for the district's elementary schools as of update date.
- middle_reopening_date
- Planned reopening date for the district's middle schools as of update date.
- high_reopening_date
- Planned reopening date for the district's high schools as of update date.
- near_term_opening_date
- Earliest planned reopening date for the district as of update date.
- update_date
- The date when the district submitted status report to the state.
9 rows where "update_date" is on date 2021-02-08 sorted by elem_reopening_date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: county, enr_total, elem_enr, middle_enr, high_enr, elem_in_school, middle_in_school, high_in_school, total_in_school, operational_status_elem, operational_status_middle, operational_status_high
Link | rowid | county | district | enr_total | elem_enr | middle_enr | high_enr | elem_in_school | middle_in_school | high_in_school | total_in_school | reopening_plan | operational_status_elem | operational_status_middle | operational_status_high | is_reopening | is_reopening_elem | elem_reopening_date ▼ | is_reopening_middle | middle_reopening_date | is_reopening_high | high_reopening_date | near_term_opening_date | update_date |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
46 | 46 | Santa Barbara | Ballard Elementary | 143.0 | 143.0 | 0.0 | 0.0 | 143.0 | 0.0 | 0.0 | 143.0 | http://ballardschool.org/Library/document/COVID%2019%20Prevention%20Program.pdf | Hybrid | 2021-02-08 | ||||||||||
172 | 172 | Placer | Colfax Elementary | 386.0 | 386.0 | 0.0 | 0.0 | 386.0 | 0.0 | 0.0 | 386.0 | https://www.colfax.k12.ca.us/apps/bbmessages/show_bbm.jsp?REC_ID=132198 | Hybrid | Hybrid | 2021-02-08 | |||||||||
216 | 216 | Merced | Dos Palos Oro Loma Joint Unified | 2346.0 | 1099.0 | 570.0 | 677.0 | 1099.0 | 570.0 | 677.0 | 2346.0 | Www.dpol.net | Hybrid | Hybrid | Hybrid | 2021-02-08 | ||||||||
283 | 283 | Sutter | Franklin Elementary | 498.0 | 498.0 | 0.0 | 0.0 | 498.0 | 0.0 | 0.0 | 498.0 | http://www.franklin.k12.ca.us/documents/COVID/WAIVER 9_15_2020.pdf | Hybrid | 2021-02-08 | ||||||||||
287 | 287 | Shasta | French Gulch-Whiskeytown Elementary | 25.0 | 25.0 | 0.0 | 0.0 | 25.0 | 0.0 | 0.0 | 25.0 | frenchgulchschool.com | In-Person | 2021-02-08 | ||||||||||
449 | 449 | Siskiyou | Little Shasta Elementary | 25.0 | 25.0 | 0.0 | 0.0 | 25.0 | 0.0 | 0.0 | 25.0 | www.littleshasta.k12.ca.us | In-Person | 2021-02-08 | ||||||||||
571 | 571 | Alameda | New Haven Unified | 11024.0 | 4684.0 | 2462.0 | 3878.0 | 0.0 | 0.0 | 0.0 | 0.0 | https://4.files.edl.io/f62f/01/25/21/191123-cbef0530-e862-4a0d-b862-911e41ebb9dd.pdf | Distance Learning Only | Distance Learning Only | Distance Learning Only | 2021-02-08 | ||||||||
820 | 820 | Santa Barbara | Solvang Elementary | 635.0 | 635.0 | 0.0 | 0.0 | 635.0 | 0.0 | 0.0 | 635.0 | solvangschool.org | Hybrid | 2021-02-08 | ||||||||||
961 | 961 | Tulare | Woodville Union Elementary | 438.0 | 438.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | https://home.woodvilleschools.org/index.html | Distance Learning Only | 2021-02-08 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "school-districts-reopening" ( [county] TEXT, [district] TEXT, [enr_total] FLOAT, [elem_enr] FLOAT, [middle_enr] FLOAT, [high_enr] FLOAT, [elem_in_school] FLOAT, [middle_in_school] FLOAT, [high_in_school] FLOAT, [total_in_school] FLOAT, [reopening_plan] TEXT, [operational_status_elem] TEXT, [operational_status_middle] TEXT, [operational_status_high] TEXT, [is_reopening] TEXT, [is_reopening_elem] TEXT, [elem_reopening_date] TEXT, [is_reopening_middle] TEXT, [middle_reopening_date] TEXT, [is_reopening_high] TEXT, [high_reopening_date] TEXT, [near_term_opening_date] TEXT, [update_date] TEXT );