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

31 rows where county = "Sacramento" and staff_confirmed_cases = 28 sorted by date descending

✎ View and edit SQL

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
1613 1613 2021-05-11 Carlton Senior Living Orangevale Sacramento 28 18 0 0 67        
2648 2648 2021-04-27 Carlton Senior Living Orangevale Sacramento 28 18 0 0 67        
3697 3697 2021-04-21 Carlton Senior Living Orangevale Sacramento 28 18 0 0 67        
4744 4744 2021-04-06 Carlton Senior Living Orangevale Sacramento 28 18 0 0 67        
5791 5791 2021-03-30 Carlton Senior Living Orangevale Sacramento 28 18 0 0 67        
6838 6838 2021-03-29 Carlton Senior Living Orangevale Sacramento 28 18 0 0 67        
7885 7885 2021-03-25 Carlton Senior Living Orangevale Sacramento 28 18 0 0 67        
8932 8932 2021-03-24 Carlton Senior Living Orangevale Sacramento 28 18 0 0 67        
9979 9979 2021-03-23 Carlton Senior Living Orangevale Sacramento 28 18 0 0 67        
11025 11025 2021-03-22 Carlton Senior Living Orangevale Sacramento 28 18 0 0 67        
12071 12071 2021-03-19 Carlton Senior Living Orangevale Sacramento 28 18 0 0 67        
13116 13116 2021-03-18 Carlton Senior Living Orangevale Sacramento 28 18 0 0 67        
14160 14160 2021-03-17 Carlton Senior Living Orangevale Sacramento 28 18 0 0 67        
15204 15204 2021-03-16 Carlton Senior Living Orangevale Sacramento 28 18 0 0 67        
16248 16248 2021-03-15 Carlton Senior Living Orangevale Sacramento 28 18 0 0 67        
17292 17292 2021-03-12 Carlton Senior Living Orangevale Sacramento 28 18 0 0 67        
18335 18335 2021-03-11 Carlton Senior Living Orangevale Sacramento 28 18 0 0 67        
19377 19377 2021-03-10 Carlton Senior Living Orangevale Sacramento 28 18 0 0 67        
20419 20419 2021-03-09 Carlton Senior Living Orangevale Sacramento 28 18 0 0 67        
21425 21425 2021-03-08 Carlton Senior Living Orangevale Sacramento 28 18 0 0 67        
22449 22449 2021-03-04 Carlton Senior Living Orangevale Sacramento 28 18 0 0 67        
23489 23489 2021-03-03 Carlton Senior Living Orangevale Sacramento 28 18 0 0 67        
24529 24529 2021-03-02 Carlton Senior Living Orangevale Sacramento 28 18 0 0 67        
25569 25569 2021-03-01 Carlton Senior Living Orangevale Sacramento 28 18 0 0 67        
26606 26606 2021-02-26 Carlton Senior Living Orangevale Sacramento 28 18 0 0 67        
27643 27643 2021-02-25 Carlton Senior Living Orangevale Sacramento 28 18 0 0 67        
28679 28679 2021-02-24 Carlton Senior Living Orangevale Sacramento 28 18 0 0 67        
29713 29713 2021-02-22 Carlton Senior Living Orangevale Sacramento 28 18 0 0 67        
30747 30747 2021-02-19 Carlton Senior Living Orangevale Sacramento 28 18 0 0 67        
31781 31781 2021-02-18 Carlton Senior Living Orangevale Sacramento 28 18 0 0 67        
32814 32814 2021-02-17 Carlton Senior Living Orangevale Sacramento 28 18 0 0 67        

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