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 "high_reopening_date" is on date 2021-04-06 sorted by is_reopening_high
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: county, operational_status_elem, operational_status_middle, is_reopening_elem, elem_reopening_date, is_reopening_middle, middle_reopening_date, update_date, elem_reopening_date (date), middle_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
43 | 43 | San Bernardino | Baker Valley Unified | 130.0 | 59.0 | 31.0 | 40.0 | 59.0 | 31.0 | 40.0 | 130.0 | http://www.baker.k12.ca.us/ | In-Person | Distance Learning Only | Distance Learning Only | Yes | Yes | 2021-04-06 | Yes | 2021-04-06 | 2021-04-06 | 2021-03-08 | ||
446 | 446 | Tulare | Lindsay Unified | 4052.0 | 2901.0 | 1.0 | 1150.0 | 2901.0 | 1.0 | 1150.0 | 4052.0 | https://www.lindsay.k12.ca.us/en-US/student-services-df48c417 | In-Person | Distance Learning Only | Distance Learning Only | Yes | Yes | 2021-04-05 | Yes | 2021-04-06 | 2021-04-06 | 2021-03-19 | ||
567 | 567 | San Bernardino | Needles Unified | 998.0 | 423.0 | 263.0 | 312.0 | 423.0 | 263.0 | 312.0 | 998.0 | Needlesusd.org | Hybrid | Distance Learning Only | Distance Learning Only | Yes | Yes | 2021-04-06 | Yes | 2021-04-06 | 2021-04-06 | 2021-03-09 | ||
583 | 583 | Monterey | North Monterey County Unified | 4594.0 | 2489.0 | 709.0 | 1396.0 | 2489.0 | 709.0 | 1396.0 | 4594.0 | https://www.nmcusd.org/domain/392 | Distance Learning Only | Distance Learning Only | Distance Learning Only | Yes | Yes | 2021-04-06 | Yes | 2021-04-06 | Yes | 2021-04-06 | 2021-04-06 | 2021-03-15 |
795 | 795 | Fresno | Selma Unified | 6256.0 | 3298.0 | 1021.0 | 1937.0 | 3298.0 | 1021.0 | 1937.0 | 6256.0 | https://drive.google.com/file/d/1kiBW9V3uqJ5Y-HlqZBx5sIhxucQVguO9/view?usp=sharing | Hybrid | Distance Learning Only | Distance Learning Only | Yes | Yes | 2021-04-06 | Yes | 2021-04-06 | 2021-04-06 | 2021-03-10 | ||
822 | 822 | Sonoma | Sonoma Valley Unified | 3716.0 | 1543.0 | 842.0 | 1331.0 | 1543.0 | 842.0 | 1331.0 | 3716.0 | https://www.sonomaschools.org/site/default.aspx?PageType=3&DomainID=4&ModuleInstanceID=7970&ViewID=6446EE88-D30C-497E-9316-3F8874B3E108&RenderLoc=0&FlexDataID=5864&PageID=1 | Distance Learning Only | Hybrid | Distance Learning Only | Yes | Yes | 2021-03-29 | Yes | 2021-04-06 | 2021-04-06 | 2021-03-15 | ||
899 | 899 | San Bernardino | Upland Unified | 10553.0 | 5661.0 | 1505.0 | 3387.0 | 5661.0 | 1505.0 | 3387.0 | 10553.0 | https://www.uplandusd.org/ | Distance Learning Only | Distance Learning Only | Distance Learning Only | Yes | Yes | 2021-03-23 | Yes | 2021-04-06 | Yes | 2021-04-06 | 2021-04-06 | 2021-03-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 );