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.
7 rows where elem_reopening_date = "2021-04-01" sorted by middle_in_school
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: county, high_enr, middle_in_school, high_in_school, operational_status_middle, operational_status_high, is_reopening, is_reopening_middle, middle_reopening_date, is_reopening_high, high_reopening_date, near_term_opening_date, update_date, elem_reopening_date (date), middle_reopening_date (date), high_reopening_date (date), near_term_opening_date (date), update_date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
61 | 61 | Los Angeles | Bellflower Unified | 11347.0 | 5877.0 | 52.0 | 5418.0 | 5877.0 | 0.0 | 0.0 | 5877.0 | https://www.busd.k12.ca.us/cms/lib/CA02204429/Centricity/Domain/4016/COVID19_School_Guidance_Checklist%20030121.pdf https://www.busd.k12.ca.us/domain/4005 | Distance Learning Only | Distance Learning Only | Distance Learning Only | Yes | Yes | 2021-04-01 | Yes | 2021-04-19 | No | 2021-04-12 | 2021-03-08 | |
191 | 191 | San Bernardino | Cucamonga Elementary | 2439.0 | 1640.0 | 799.0 | 0.0 | 1640.0 | 0.0 | 0.0 | 1640.0 | https://www.cuca.k12.ca.us/pf4/cms2/view_page?d=x&group_id=1516954842088&vdid=i1h4e1rqreia291 | Distance Learning Only | Distance Learning Only | No | Yes | 2021-04-01 | No | 2021-03-08 | |||||
342 | 342 | Imperial | Heber Elementary | 1268.0 | 1268.0 | 0.0 | 0.0 | 1268.0 | 0.0 | 0.0 | 1268.0 | https://www.hesdk8.org/o/heber-esd/browse/194791 | Distance Learning Only | Distance Learning Only | Yes | Yes | 2021-04-01 | Yes | 2021-04-01 | 2021-04-01 | 2021-03-11 | |||
523 | 523 | Santa Clara | Milpitas Unified | 10299.0 | 5507.0 | 1558.0 | 3234.0 | 5507.0 | 0.0 | 0.0 | 5507.0 | https://drive.google.com/file/d/1UbhKN2aTHAvjn9zun7a7ZXSTlH4Lwsjf/view | Distance Learning Only | Distance Learning Only | Distance Learning Only | Yes | Yes | 2021-04-01 | No | No | 2021-04-15 | 2021-03-08 | ||
341 | 341 | Sonoma | Healdsburg Unified | 1176.0 | 297.0 | 334.0 | 545.0 | 297.0 | 334.0 | 545.0 | 1176.0 | https://www.husd.com/pf4/cms2/view_page?d=x&group_id=1500178971285&vdid=iwv23en2fqw660u | Distance Learning Only | Distance Learning Only | Distance Learning Only | Yes | Yes | 2021-04-01 | Yes | 2021-04-05 | Yes | 2021-04-05 | 2021-04-05 | 2021-03-08 |
121 | 121 | Imperial | Calipatria Unified | 1140.0 | 449.0 | 340.0 | 351.0 | 449.0 | 340.0 | 0.0 | 789.0 | Distance Learning Only | Distance Learning Only | Distance Learning Only | No | Yes | 2021-04-01 | Yes | 2021-04-01 | No | 2021-03-08 | |||
781 | 781 | Sonoma | Santa Rosa City Schools | 14259.0 | 3577.0 | 2949.0 | 7733.0 | 3577.0 | 2949.0 | 7733.0 | 14259.0 | https://www.srcschools.org/Page/4524 | Distance Learning Only | Hybrid | Hybrid | Yes | Yes | 2021-04-01 | 2021-04-26 | 2021-03-17 |
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 );