la-times: charter-schools-reopening: 1 row where "elem_reopening_date" is on date 2021-08-12 and is_reopening

Number of students with an option to return to individual charter schools calculated from combination of data from California Safe Schools For All and California Department of Education. This file stopped updating in June 2021.

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.

1 row where "elem_reopening_date" is on date 2021-08-12 and is_reopening_high = "Yes"

descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Link	rowid ▼	cdscode	county	district	school	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
243	243	11101161130103	Glenn	Glenn County Office of Education	WILLIAM FINCH	106.0	22.0	23.0	61.0	0.0	0.0	0.0	0.0	https://sites.google.com/site/wmfinchcharter/documents	Distance Learning Only	Distance Learning Only	Distance Learning Only	Yes	Yes	2021-08-12	Yes	2021-08-12	Yes	2021-08-12	2021-08-12	2021-03-08

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
);