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

108 rows where county = "Sacramento" and staff_confirmed_cases = 23 sorted by date descending

✎ View and edit SQL

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

Suggested facets: name, patients_confirmed_cases, patients_deaths_note

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
604 604 2021-06-27 Country Club Manor Sacramento 23 33 0 0 67        
1618 1618 2021-05-11 Country Club Manor Sacramento 23 33 0 0 67        
2653 2653 2021-04-27 Country Club Manor Sacramento 23 33 0 0 67        
3702 3702 2021-04-21 Country Club Manor Sacramento 23 33 0 0 67        
4749 4749 2021-04-06 Country Club Manor Sacramento 23 33 0 0 67        
5796 5796 2021-03-30 Country Club Manor Sacramento 23 33 0 0 67        
6843 6843 2021-03-29 Country Club Manor Sacramento 23 33 0 0 67        
7890 7890 2021-03-25 Country Club Manor Sacramento 23 33 0 0 67        
8937 8937 2021-03-24 Country Club Manor Sacramento 23 33 0 0 67        
9984 9984 2021-03-23 Country Club Manor Sacramento 23 33 0 0 67        
11030 11030 2021-03-22 Country Club Manor Sacramento 23 33 0 0 67        
12076 12076 2021-03-19 Country Club Manor Sacramento 23 33 0 0 67        
13121 13121 2021-03-18 Country Club Manor Sacramento 23 33 0 0 67        
14165 14165 2021-03-17 Country Club Manor Sacramento 23 33 0 0 67        
15209 15209 2021-03-16 Country Club Manor Sacramento 23 33 0 0 67        
16253 16253 2021-03-15 Country Club Manor Sacramento 23 33 0 0 67        
17297 17297 2021-03-12 Country Club Manor Sacramento 23 33 0 0 67        
18340 18340 2021-03-11 Country Club Manor Sacramento 23 33 0 0 67        
19382 19382 2021-03-10 Country Club Manor Sacramento 23 33 0 0 67        
20424 20424 2021-03-09 Country Club Manor Sacramento 23 33 0 0 67        
21430 21430 2021-03-08 Country Club Manor Sacramento 23 33 0 0 67        
22454 22454 2021-03-04 Country Club Manor Sacramento 23 33 0 0 67        
23494 23494 2021-03-03 Country Club Manor Sacramento 23 33 0 0 67        
24534 24534 2021-03-02 Country Club Manor Sacramento 23 33 0 0 67        
25574 25574 2021-03-01 Country Club Manor Sacramento 23 33 0 0 67        
26611 26611 2021-02-26 Country Club Manor Sacramento 23 33 0 0 67        
27648 27648 2021-02-25 Country Club Manor Sacramento 23 33 0 0 67        
28684 28684 2021-02-24 Country Club Manor Sacramento 23 33 0 0 67        
29718 29718 2021-02-22 Country Club Manor Sacramento 23 33 0 0 67        
30752 30752 2021-02-19 Country Club Manor Sacramento 23 33 0 0 67        
31786 31786 2021-02-18 Country Club Manor Sacramento 23 33 0 0 67        
32819 32819 2021-02-17 Country Club Manor Sacramento 23 33 0 0 67        
33850 33850 2021-02-16 Country Club Manor Sacramento 23 33 0 0 67        
34879 34879 2021-02-12 Country Club Manor Sacramento 23 33 0 0 67        
35895 35895 2021-02-11 Atria El Camino Gardens Sacramento 23 32 0 1 67       <11
35906 35906 2021-02-11 Country Club Manor Sacramento 23 33 0 0 67        
36920 36920 2021-02-10 Atria El Camino Gardens Sacramento 23 32 0 1 67       <11
36931 36931 2021-02-10 Country Club Manor Sacramento 23 33 0 0 67        
37945 37945 2021-02-09 Atria El Camino Gardens Sacramento 23 32 0 1 67       <11
37956 37956 2021-02-09 Country Club Manor Sacramento 23 33 0 0 67        
38969 38969 2021-02-08 Atria El Camino Gardens Sacramento 23 32 0 1 67       <11
38980 38980 2021-02-08 Country Club Manor Sacramento 23 33 0 0 67        
39989 39989 2021-02-05 Atria El Camino Gardens Sacramento 23 32 0 1 67       <11
40000 40000 2021-02-05 Country Club Manor Sacramento 23 33 0 0 67        
41004 41004 2021-02-04 Atria El Camino Gardens Sacramento 23 32 0 1 67       <11
41015 41015 2021-02-04 Country Club Manor Sacramento 23 33 0 0 67        
42015 42015 2021-02-03 Atria El Camino Gardens Sacramento 23 32 0 1 67       <11
42021 42021 2021-02-03 Carlton Senior Living Orangevale Sacramento 23 1 0 0 67   <11    
42026 42026 2021-02-03 Country Club Manor Sacramento 23 33 0 0 67        
43023 43023 2021-02-02 Atria El Camino Gardens Sacramento 23 32 0 1 67       <11
43029 43029 2021-02-02 Carlton Senior Living Orangevale Sacramento 23 1 0 0 67   <11    
43034 43034 2021-02-02 Country Club Manor Sacramento 23 33 0 0 67        
44029 44029 2021-02-01 Atria El Camino Gardens Sacramento 23 32 0 1 67       <11
44039 44039 2021-02-01 Country Club Manor Sacramento 23 33 0 0 67        
44043 44043 2021-02-01 Eskaton Fountainwood Lodge Sacramento 23 1 0 0 67   <11    
45032 45032 2021-01-29 Atria El Camino Gardens Sacramento 23 32 0 1 67       <11
45042 45042 2021-01-29 Country Club Manor Sacramento 23 33 0 0 67        
45046 45046 2021-01-29 Eskaton Fountainwood Lodge Sacramento 23 1 0 0 67   <11    
46027 46027 2021-01-28 Atria El Camino Gardens Sacramento 23 32 0 1 67       <11
46037 46037 2021-01-28 Country Club Manor Sacramento 23 33 0 0 67        
46041 46041 2021-01-28 Eskaton Fountainwood Lodge Sacramento 23 1 0 0 67   <11    
47037 47037 2021-01-27 Country Club Manor Sacramento 23 33 0 0 67        
47040 47040 2021-01-27 Eskaton Fountainwood Lodge Sacramento 23 1 0 0 67   <11    
47998 47998 2021-01-26 Country Club Manor Sacramento 23 33 0 0 67        
48002 48002 2021-01-26 Eskaton Fountainwood Lodge Sacramento 23 1 0 0 67   <11    
48972 48972 2021-01-25 Country Club Manor Sacramento 23 33 0 0 67        
48976 48976 2021-01-25 Eskaton Fountainwood Lodge Sacramento 23 1 0 0 67   <11    
49922 49922 2021-01-21 Country Club Manor Sacramento 23 33 0 0 67        
49926 49926 2021-01-21 Eskaton Fountainwood Lodge Sacramento 23 1 0 0 67   <11    
50872 50872 2021-01-20 Country Club Manor Sacramento 23 33 0 0 67        
50876 50876 2021-01-20 Eskaton Fountainwood Lodge Sacramento 23 1 0 0 67   <11    
51832 51832 2021-01-19 Country Club Manor Sacramento 23 33 0 0 67        
51836 51836 2021-01-19 Eskaton Fountainwood Lodge Sacramento 23 1 0 0 67   <11    
52769 52769 2021-01-15 Care Center Sacramento 23 1 0 0 67   <11    
52777 52777 2021-01-15 Country Club Manor Sacramento 23 33 0 0 67        
53690 53690 2021-01-14 Country Club Manor Sacramento 23 33 0 0 67        
53694 53694 2021-01-14 Eskaton Fountainwood Lodge Sacramento 23 1 0 0 67   <11    
54612 54612 2021-01-13 Country Club Manor Sacramento 23 33 0 0 67        
54616 54616 2021-01-13 Eskaton Fountainwood Lodge Sacramento 23 1 0 0 67   <11    
55526 55526 2021-01-12 Country Club Manor Sacramento 23 33 0 0 67        
55530 55530 2021-01-12 Eskaton Fountainwood Lodge Sacramento 23 1 0 0 67   <11    
56436 56436 2021-01-11 Country Club Manor Sacramento 23 33 0 0 67        
56439 56439 2021-01-11 Eskaton Fountainwood Lodge Sacramento 23 1 0 0 67   <11    
57331 57331 2021-01-08 Eskaton Fountainwood Lodge Sacramento 23 1 0 0 67   <11    
58208 58208 2021-01-07 Eskaton Fountainwood Lodge Sacramento 23 1 0 0 67   <11    
59074 59074 2021-01-06 Eskaton Fountainwood Lodge Sacramento 23 1 0 0 67   <11    
59087 59087 2021-01-06 Revere Court Sacramento 23 41 0 1 67       <11
59928 59928 2021-01-05 Eskaton Fountainwood Lodge Sacramento 23 1 0 0 67   <11    
59941 59941 2021-01-05 Revere Court Sacramento 23 41 0 1 67       <11
60783 60783 2021-01-04 Revere Court Sacramento 23 41 0 1 67       <11
61597 61597 2020-12-31 Revere Court Sacramento 23 41 0 1 67       <11
62362 62362 2020-12-30 Carlton Plaza Of Elk Grove Sacramento 23 18 0 1 67       <11
63137 63137 2020-12-29 Carlton Plaza Of Elk Grove Sacramento 23 18 0 1 67       <11
63903 63903 2020-12-28 Carlton Plaza Of Elk Grove Sacramento 23 18 0 1 67       <11
64637 64637 2020-12-24 Carlton Plaza Of Elk Grove Sacramento 23 18 0 1 67       <11
65353 65353 2020-12-23 Carlton Plaza Of Elk Grove Sacramento 23 18 0 1 67       <11
68074 68074 2020-12-17 Carlton Plaza Of Sacramento Sacramento 23 20 0 1 67       <11
116189 116189 2020-05-08 Sunrise Assisted Living of Sacramento Sacramento 23 25 0 1 67       <11
116254 116254 2020-05-07 Sunrise Assisted Living of Sacramento Sacramento 23 25     67        
116303 116303 2020-05-06 Sunrise Assisted Living of Sacramento Sacramento 23 25     67        

Next page

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