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.
17 rows where "middle_reopening_date" is on date 2021-04-19 sorted by is_reopening_middle
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: county, middle_enr, high_enr, elem_in_school, high_in_school, total_in_school, reopening_plan, operational_status_elem, operational_status_high, is_reopening_elem, elem_reopening_date, is_reopening_high, high_reopening_date, near_term_opening_date, update_date, elem_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
50 | 50 | San Joaquin | Banta Elementary | 316.0 | 316.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | bantasd.org | Distance Learning Only | Distance Learning Only | Yes | Yes | 2021-04-13 | Yes | 2021-04-19 | 2021-04-13 | 2021-03-08 | |||
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 | |
150 | 150 | Los Angeles | Charter Oak Unified | 4528.0 | 2289.0 | 695.0 | 1544.0 | 2289.0 | 0.0 | 0.0 | 2289.0 | Distance Learning Only | Distance Learning Only | Distance Learning Only | Yes | Yes | 2021-04-06 | Yes | 2021-04-19 | Yes | 2021-04-19 | 2021-04-26 | 2021-03-08 | |
355 | 355 | Ventura | Hueneme Elementary | 7936.0 | 5297.0 | 2639.0 | 0.0 | 5297.0 | 0.0 | 0.0 | 5297.0 | https://core-docs.s3.amazonaws.com/documents/asset/uploaded_file/1142098/1126_001.pdf | Distance Learning Only | Distance Learning Only | Yes | Yes | 2021-03-29 | Yes | 2021-04-19 | 2021-04-19 | 2021-03-08 | |||
408 | 408 | San Diego | La Mesa-Spring Valley | 11781.0 | 11018.0 | 763.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | https://www.lmsvschools.org/wp-content/uploads/2021/02/LMSV-Covid-19-Safety-Plan-UPDATED-2.24.2021.pdf | Distance Learning Only | Distance Learning Only | Yes | Yes | 2021-04-19 | Yes | 2021-04-19 | 2021-04-19 | 2021-03-08 | |||
508 | 508 | Mendocino | Mendocino Unified | 525.0 | 339.0 | 6.0 | 180.0 | 339.0 | 0.0 | 0.0 | 339.0 | Distance Learning Only | Distance Learning Only | Distance Learning Only | Yes | Yes | 2021-03-29 | Yes | 2021-04-19 | Yes | 2021-04-19 | 2021-04-19 | 2021-03-09 | |
532 | 532 | Los Angeles | Monrovia Unified | 5385.0 | 2438.0 | 1244.0 | 1703.0 | 2438.0 | 0.0 | 0.0 | 2438.0 | https://4.files.edl.io/7656/03/08/21/230337-cd48d612-e57d-4cac-9d73-34fd141e7ae5.pdf | Distance Learning Only | Distance Learning Only | Distance Learning Only | Yes | Yes | 2021-03-29 | Yes | 2021-04-19 | Yes | 2021-04-19 | 2021-04-19 | 2021-03-13 |
543 | 543 | Santa Clara | Moreland | 4675.0 | 3666.0 | 1009.0 | 0.0 | 3666.0 | 0.0 | 0.0 | 3666.0 | https://www.moreland.org | Distance Learning Only | Distance Learning Only | Yes | Yes | 2021-03-22 | Yes | 2021-04-19 | 2021-04-19 | 2021-03-15 | |||
556 | 556 | San Bernardino | Mt. Baldy Joint Elementary | 109.0 | 109.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | Distance Learning Only | Distance Learning Only | Yes | Yes | 2021-04-19 | Yes | 2021-04-19 | 2021-04-19 | 2021-03-08 | ||||
615 | 615 | Ventura | Oxnard | 15722.0 | 12652.0 | 3070.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | https://www.oxnardsd.org/Page/13166 | Distance Learning Only | Distance Learning Only | Yes | Yes | 2021-04-12 | Yes | 2021-04-19 | 2021-04-22 | 2021-03-08 | |||
626 | 626 | Riverside | Palo Verde Unified | 2863.0 | 1954.0 | 0.0 | 909.0 | 1954.0 | 0.0 | 909.0 | 2863.0 | https://www.pvusd.us/COVID-19/index.html | Distance Learning Only | Distance Learning Only | Distance Learning Only | Yes | Yes | 2021-03-23 | Yes | 2021-04-19 | Yes | 2021-03-23 | 2021-04-19 | 2021-03-08 |
642 | 642 | Sonoma | Petaluma City Elementary Joint Union High | 6427.0 | 1698.0 | 1448.0 | 3281.0 | 0.0 | 0.0 | 0.0 | 0.0 | https://www.petalumacityschools.org/Page/5094 | Distance Learning Only | Distance Learning Only | Distance Learning Only | Yes | Yes | 2021-04-12 | Yes | 2021-04-19 | Yes | 2021-04-19 | 2021-04-19 | 2021-03-08 |
647 | 647 | Contra Costa | Pittsburg Unified | 11329.0 | 4945.0 | 2534.0 | 3850.0 | 0.0 | 0.0 | 0.0 | 0.0 | Distance Learning Only | Distance Learning Only | Distance Learning Only | Yes | Yes | 2021-04-15 | Yes | 2021-04-19 | Yes | 2021-04-26 | 2021-05-03 | 2021-03-09 | |
758 | 758 | San Mateo | San Mateo-Foster City | 11553.0 | 8671.0 | 2882.0 | 0.0 | 8671.0 | 0.0 | 0.0 | 8671.0 | http://www.smfcsd.net/en/covid-19-updates-resources/updates.html | Distance Learning Only | Distance Learning Only | Yes | Yes | 2021-03-08 | Yes | 2021-04-19 | 2021-04-19 | 2021-03-08 | |||
761 | 761 | Imperial | San Pasqual Valley Unified | 654.0 | 283.0 | 167.0 | 204.0 | 0.0 | 0.0 | 0.0 | 0.0 | Distance Learning Only | Distance Learning Only | Distance Learning Only | Yes | Yes | 2021-04-19 | Yes | 2021-04-19 | Yes | 2021-04-19 | 2021-04-19 | 2021-03-20 | |
770 | 770 | Santa Clara | Santa Clara County Office of Education | 1330.0 | 386.0 | 236.0 | 708.0 | 386.0 | 0.0 | 0.0 | 386.0 | www.sccoe.org | In-Person | Distance Learning Only | Distance Learning Only | Yes | Yes | 2021-04-19 | Yes | 2021-05-07 | 2021-05-07 | 2021-03-08 | ||
918 | 918 | Los Angeles | Walnut Valley Unified | 13790.0 | 5423.0 | 3418.0 | 4949.0 | 0.0 | 0.0 | 0.0 | 0.0 | Distance Learning Only | Distance Learning Only | Distance Learning Only | Yes | Yes | 2021-04-19 | Yes | 2021-04-19 | No | 2021-04-19 | 2021-03-13 |
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 );