la-times: charter-schools-reopening: 4 rows where "elem_reopening_date" is on date 2021-04-20 and is

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.

4 rows where "elem_reopening_date" is on date 2021-04-20 and is_reopening = "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	operational_status_elem	operational_status_middle	is_reopening	is_reopening_elem	elem_reopening_date	is_reopening_middle	middle_reopening_date	near_term_opening_date	update_date
457	457	19647330139071	Los Angeles	Los Angeles Unified	KIPP PUEBLO UNIDO	104.0	104.0	Distance Learning Only	Distance Learning Only	Yes	Yes	2021-04-20	Yes	2021-04-20	2021-04-20	2021-03-08
492	492	19647330129460	Los Angeles	Los Angeles Unified	KIPP VIDA PREPARATORY ACADEMY	572.0	572.0	Distance Learning Only		Yes	Yes	2021-04-20			2021-04-20	2021-03-09
510	510	19647330117903	Los Angeles	Los Angeles Unified	KIPP RAICES ACADEMY	586.0	586.0	Distance Learning Only		Yes	Yes	2021-04-20			2021-04-20	2021-03-08
592	592	19647330131797	Los Angeles	Los Angeles Unified	KIPP PROMESA PREP	558.0	558.0	Distance Learning Only		Yes	Yes	2021-04-20			2021-04-20	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
);