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

15 rows where county = "Kern" and staff_confirmed_cases = 23 sorted by date descending

✎ View and edit SQL

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

Suggested facets: 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
69027 69027 2020-12-15 Centre Village Kern 23 1 0 0 29   <11    
69640 69640 2020-12-14 Centre Village Kern 23 1 0 0 29   <11    
70243 70243 2020-12-11 Centre Village Kern 23 1 0 0 29   <11    
70822 70822 2020-12-10 Centre Village Kern 23 1 0 0 29   <11    
71395 71395 2020-12-09 Centre Village Kern 23 1 0 0 29   <11    
71959 71959 2020-12-08 Centre Village Kern 23 1 0 0 29   <11    
72511 72511 2020-12-07 Centre Village Kern 23 1 0 0 29   <11    
73052 73052 2020-12-04 Centre Village Kern 23 1 0 0 29   <11    
73577 73577 2020-12-03 Centre Village Kern 23 1 0 0 29   <11    
74090 74090 2020-12-02 Centre Village Kern 23 1 0 0 29   <11    
74594 74594 2020-12-01 Centre Village Kern 23 1 0 0 29   <11    
75094 75094 2020-11-30 Centre Village Kern 23 1 0 0 29   <11    
75590 75590 2020-11-27 Centre Village Kern 23 1 0 0 29   <11    
76072 76072 2020-11-25 Centre Village Kern 23 1 0 0 29   <11    
76545 76545 2020-11-24 Centre Village Kern 23 1 0 0 29   <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
);