la_times_cdph_adult_and_senior_care_facilities

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

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

16 rows where county = "Marin" and staff_confirmed_cases = 13 sorted by date descending

✎ View and edit SQL

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

Suggested facets: name, patients_confirmed_cases_note, patients_deaths_note, date (date)

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
92437 92437 2020-09-30 Drake Terrace Marin 13 1 0 1 41   <11   <11
92798 92798 2020-09-29 Drake Terrace Marin 13 1 0 1 41   <11   <11
93154 93154 2020-09-28 Drake Terrace Marin 13 1 0 1 41   <11   <11
93507 93507 2020-09-25 Drake Terrace Marin 13 1 0 1 41   <11   <11
93863 93863 2020-09-24 Drake Terrace Marin 13 1 0 1 41   <11   <11
94218 94218 2020-09-23 Drake Terrace Marin 13 1 0 1 41   <11   <11
94565 94565 2020-09-22 Drake Terrace Marin 13 1 0 1 41   <11   <11
94914 94914 2020-09-21 Drake Terrace Marin 13 1 0 1 41   <11   <11
95265 95265 2020-09-18 Drake Terrace Marin 13 1 0 1 41   <11   <11
105458 105458 2020-08-07 Nazareth House Of San Rafael, Inc. Marin 13 18 0 1 41       <11
105694 105694 2020-08-06 Aegis Assisted Living Of Corte Madera Marin 13 1 0 0 41   <11    
105698 105698 2020-08-06 Nazareth House Of San Rafael, Inc. Marin 13 18 0 1 41       <11
105927 105927 2020-08-05 Aegis Assisted Living Of Corte Madera Marin 13 1 0 0 41   <11    
106161 106161 2020-08-04 Aegis Assisted Living Of Corte Madera Marin 13 1 0 0 41   <11    
106394 106394 2020-08-03 Aegis Assisted Living Of Corte Madera Marin 13 1 0 0 41   <11    
106627 106627 2020-08-02 Aegis Assisted Living Of Corte Madera Marin 13 1 0 0 41   <11    

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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