la_times_cdph_adult_and_senior_care_facilities
Data license: Reusing the data · Data source: California Department of Public Health via The Los Angeles Times · About: Data dictionary for la_times_cdph_adult_and_senior_care_facilities
13 rows where patients_deaths = 17 and staff_confirmed_cases = 19 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | name | county | staff_confirmed_cases | patients_confirmed_cases | staff_deaths | patients_deaths | fips | staff_confirmed_cases_note | patients_confirmed_cases_note | staff_deaths_note | patients_deaths_note |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
95469 | 95469 | 2020-09-18 | El Rio Memory Care Community | Stanislaus | 19 | 44 | 1 | 17 | 99 | <11 | |||
95813 | 95813 | 2020-09-17 | El Rio Memory Care Community | Stanislaus | 19 | 44 | 1 | 17 | 99 | <11 | |||
96156 | 96156 | 2020-09-16 | El Rio Memory Care Community | Stanislaus | 19 | 44 | 1 | 17 | 99 | <11 | |||
96494 | 96494 | 2020-09-15 | El Rio Memory Care Community | Stanislaus | 19 | 44 | 1 | 17 | 99 | <11 | |||
96824 | 96824 | 2020-09-14 | El Rio Memory Care Community | Stanislaus | 19 | 44 | 1 | 17 | 99 | <11 | |||
97157 | 97157 | 2020-09-11 | El Rio Memory Care Community | Stanislaus | 19 | 44 | 1 | 17 | 99 | <11 | |||
97489 | 97489 | 2020-09-10 | El Rio Memory Care Community | Stanislaus | 19 | 44 | 1 | 17 | 99 | <11 | |||
97817 | 97817 | 2020-09-09 | El Rio Memory Care Community | Stanislaus | 19 | 44 | 1 | 17 | 99 | <11 | |||
98140 | 98140 | 2020-09-08 | El Rio Memory Care Community | Stanislaus | 19 | 44 | 1 | 17 | 99 | <11 | |||
98464 | 98464 | 2020-09-07 | El Rio Memory Care Community | Stanislaus | 19 | 44 | 1 | 17 | 99 | <11 | |||
98782 | 98782 | 2020-09-04 | El Rio Memory Care Community | Stanislaus | 19 | 44 | 1 | 17 | 99 | <11 | |||
99098 | 99098 | 2020-09-03 | El Rio Memory Care Community | Stanislaus | 19 | 44 | 1 | 17 | 99 | <11 | |||
99410 | 99410 | 2020-09-02 | El Rio Memory Care Community | Stanislaus | 19 | 44 | 1 | 17 | 99 | <11 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [la_times_cdph_adult_and_senior_care_facilities] ( [date] TEXT, [name] TEXT, [county] TEXT, [staff_confirmed_cases] INTEGER, [patients_confirmed_cases] INTEGER, [staff_deaths] INTEGER, [patients_deaths] INTEGER, [fips] INTEGER, [staff_confirmed_cases_note] TEXT, [patients_confirmed_cases_note] TEXT, [staff_deaths_note] TEXT, [patients_deaths_note] TEXT );