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

26 rows where county = "Yolo" and staff_confirmed_cases = 21 sorted by date descending

✎ View and edit SQL

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

Suggested facets: 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
31187 31187 2021-02-19 Carlton Plaza Of Davis Yolo 21 29 0 1 113       <11
32220 32220 2021-02-18 Carlton Plaza Of Davis Yolo 21 29 0 1 113       <11
33253 33253 2021-02-17 Carlton Plaza Of Davis Yolo 21 29 0 1 113       <11
34283 34283 2021-02-16 Carlton Plaza Of Davis Yolo 21 29 0 1 113       <11
35310 35310 2021-02-12 Carlton Plaza Of Davis Yolo 21 29 0 1 113       <11
36336 36336 2021-02-11 Carlton Plaza Of Davis Yolo 21 29 0 1 113       <11
37361 37361 2021-02-10 Carlton Plaza Of Davis Yolo 21 29 0 1 113       <11
38386 38386 2021-02-09 Carlton Plaza Of Davis Yolo 21 29 0 1 113       <11
39409 39409 2021-02-08 Carlton Plaza Of Davis Yolo 21 29 0 1 113       <11
40427 40427 2021-02-05 Carlton Plaza Of Davis Yolo 21 29 0 1 113       <11
41440 41440 2021-02-04 Carlton Plaza Of Davis Yolo 21 29 0 1 113       <11
42450 42450 2021-02-03 Carlton Plaza Of Davis Yolo 21 29 0 1 113       <11
43457 43457 2021-02-02 Carlton Plaza Of Davis Yolo 21 29 0 1 113       <11
44462 44462 2021-02-01 Carlton Plaza Of Davis Yolo 21 29 0 1 113       <11
45460 45460 2021-01-29 Carlton Plaza Of Davis Yolo 21 29 0 1 113       <11
46455 46455 2021-01-28 Carlton Plaza Of Davis Yolo 21 29 0 1 113       <11
47452 47452 2021-01-27 Carlton Plaza Of Davis Yolo 21 29 0 1 113       <11
48395 48395 2021-01-26 Carlton Plaza Of Davis Yolo 21 29 0 1 113       <11
49385 49385 2021-01-25 Carlton Plaza Of Davis Yolo 21 28 0 1 113       <11
50309 50309 2021-01-21 Carlton Plaza Of Davis Yolo 21 28 0 1 113       <11
51271 51271 2021-01-20 Carlton Plaza Of Davis Yolo 21 28 0 1 113       <11
52227 52227 2021-01-19 Carlton Plaza Of Davis Yolo 21 28 0 1 113       <11
68961 68961 2020-12-16 University Retirement Community At Davis Yolo 21 1 0 0 113   <11    
69576 69576 2020-12-15 University Retirement Community At Davis Yolo 21 1 0 0 113   <11    
70183 70183 2020-12-14 University Retirement Community At Davis Yolo 21 1 0 0 113   <11    
70762 70762 2020-12-11 University Retirement Community At Davis Yolo 21 1 0 0 113   <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
);