charter-schools-reopening
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- cdscode
- A 14-digit code unique to the charter school. Assigned by California department of Education
- district
- Name of school district the charter schools is part of.
- school
- Name of the charter school.
- enr_total
- Total students enrolled
- 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 school's reopening plan.
- operational_status_elem
- Operational status as of update_date.
- operational_status_middle
- Operational status as of update_date.
- operational_status_high
- Operational status as of update_date.
- elem_reopening_date
- Planned reopening date as of update date.
- middle_reopening_date
- Planned reopening date as of update date.
- high_reopening_date
- Planned reopening date as of update date.
- near_term_opening_date
- Earliest planned reopening date for the school as of update date.
- update_date
- The date when the charter school submitted status report to the state.
2 rows where "middle_reopening_date" is on date 2021-08-23 sorted by update_date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: high_reopening_date (date), near_term_opening_date (date), update_date (date)
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "charter-schools-reopening" ( [cdscode] INTEGER, [county] TEXT, [district] TEXT, [school] 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 );