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.
9 rows where "middle_reopening_date" is on date 2021-04-19 and operational_status_middle = "Distance Learning Only"
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: county, district, elem_enr, middle_enr, high_enr, elem_in_school, total_in_school, reopening_plan, operational_status_elem, operational_status_high, is_reopening, is_reopening_elem, elem_reopening_date, is_reopening_high, high_reopening_date, near_term_opening_date, update_date, elem_reopening_date (date), middle_reopening_date (date), high_reopening_date (date), near_term_opening_date (date), update_date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29 | 29 | 1611190122085 | Alameda | Alameda Unified | THE ACADEMY OF ALAMEDA | 476.0 | 0.0 | 476.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | Distance Learning Only | Yes | Yes | 2021-04-19 | 2021-04-19 | 2021-03-09 | |||||||
60 | 60 | 39684860140392 | San Joaquin | Banta Elementary | BANTA CHARTER | 0.0 | 0.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 | |||
237 | 237 | 10621660106740 | Fresno | Fresno Unified | ASPEN VALLEY PREP ACADEMY | 418.0 | 418.0 | 0.0 | 0.0 | 418.0 | 0.0 | 0.0 | 418.0 | https://valley.aspenps.org/apps/cross.jsp?wREC_ID=4841&crossPath=/apps/pages/index.jsp%3FuREC_ID%3D476993%26type%3Dd | Distance Learning Only | Distance Learning Only | Yes | Yes | 2021-04-06 | Yes | 2021-04-19 | 2021-04-06 | 2021-03-08 | |||
533 | 533 | 19647330117614 | Los Angeles | Los Angeles Unified | NEW LOS ANGELES CHARTER | 319.0 | 0.0 | 319.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | https://www.newlamiddle.org/apps/pages/index.jsp?uREC_ID=183196&type=d&pREC_ID=2140624 | Distance Learning Only | Yes | Yes | 2021-04-19 | 2021-04-19 | 2021-03-09 | ||||||
613 | 613 | 19647330108928 | Los Angeles | Los Angeles Unified | LARCHMONT CHARTER | 1551.0 | 713.0 | 401.0 | 437.0 | 0.0 | 0.0 | 0.0 | 0.0 | https://www.larchmontcharter.org/covidpreventionplan | Distance Learning Only | Distance Learning Only | Distance Learning Only | Yes | Yes | 2021-03-26 | Yes | 2021-04-19 | Yes | 2021-04-19 | 2021-03-26 | 2021-03-08 |
902 | 902 | 49709040101923 | Sonoma | Roseland | ROSELAND CHARTER | 1459.0 | 125.0 | 534.0 | 800.0 | 0.0 | 0.0 | 0.0 | 0.0 | Distance Learning Only | Distance Learning Only | Distance Learning Only | No | Yes | 2021-04-20 | Yes | 2021-04-19 | Yes | 2021-04-19 | 2021-03-09 | ||
993 | 993 | 37683380111906 | San Diego | San Diego Unified | KING-CHAVEZ PREPARATORY ACADEMY | 360.0 | 0.0 | 360.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | https://drive.google.com/file/d/1RkdY__GwaNsLmiLysSBRktzuCWdBedxN/view | Distance Learning Only | Yes | Yes | 2021-04-19 | 2021-04-19 | 2021-03-17 | ||||||
1104 | 1104 | 44104474430252 | Santa Cruz | Santa Cruz County Office of Education | PACIFIC COLLEGIATE CHARTER | 544.0 | 0.0 | 0.0 | 544.0 | 0.0 | 0.0 | 0.0 | 0.0 | https://docs.google.com/spreadsheets/d/194M5GOOi97w_sgQt_Z6ZxJn20_byN4TF70rys8LaL6Y/edit#gid=0 | Distance Learning Only | Distance Learning Only | Yes | Yes | 2021-04-19 | Yes | 2021-04-19 | 2021-04-19 | 2021-03-08 | |||
1129 | 1129 | 49709530105866 | Sonoma | Sonoma Valley Unified | WOODLAND STAR CHARTER | 258.0 | 258.0 | 0.0 | 0.0 | 258.0 | 0.0 | 0.0 | 258.0 | Distance Learning Only | Distance Learning Only | Yes | Yes | 2021-04-12 | Yes | 2021-04-19 | 2021-04-19 | 2021-03-18 |
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 );