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

105 rows where county = "Santa Clara" and staff_confirmed_cases = 13 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
891 891 2021-06-27 Campbell Village Santa Clara 13 22 0 1 85       <11
895 895 2021-06-27 Club Riviera Santa Clara 13 29 0 0 85        
1894 1894 2021-05-11 Campbell Village Santa Clara 13 22 0 1 85       <11
2938 2938 2021-04-27 Campbell Village Santa Clara 13 22 0 1 85       <11
2942 2942 2021-04-27 Club Riviera Santa Clara 13 29 0 0 85        
3987 3987 2021-04-21 Campbell Village Santa Clara 13 22 0 1 85       <11
3991 3991 2021-04-21 Club Riviera Santa Clara 13 29 0 0 85        
5038 5038 2021-04-06 Club Riviera Santa Clara 13 29 0 0 85        
6085 6085 2021-03-30 Club Riviera Santa Clara 13 29 0 0 85        
7132 7132 2021-03-29 Club Riviera Santa Clara 13 29 0 0 85        
8179 8179 2021-03-25 Club Riviera Santa Clara 13 29 0 0 85        
9226 9226 2021-03-24 Club Riviera Santa Clara 13 29 0 0 85        
10272 10272 2021-03-23 Club Riviera Santa Clara 13 29 0 0 85        
11319 11319 2021-03-22 Club Riviera Santa Clara 13 29 0 0 85        
12365 12365 2021-03-19 Club Riviera Santa Clara 13 29 0 0 85        
13410 13410 2021-03-18 Club Riviera Santa Clara 13 29 0 0 85        
14454 14454 2021-03-17 Club Riviera Santa Clara 13 29 0 0 85        
15498 15498 2021-03-16 Club Riviera Santa Clara 13 29 0 0 85        
16542 16542 2021-03-15 Club Riviera Santa Clara 13 29 0 0 85        
17586 17586 2021-03-12 Club Riviera Santa Clara 13 29 0 0 85        
18629 18629 2021-03-11 Club Riviera Santa Clara 13 29 0 0 85        
19670 19670 2021-03-10 Club Riviera Santa Clara 13 29 0 0 85        
20712 20712 2021-03-09 Club Riviera Santa Clara 13 29 0 0 85        
22741 22741 2021-03-04 Club Riviera Santa Clara 13 29 0 0 85        
23781 23781 2021-03-03 Club Riviera Santa Clara 13 29 0 0 85        
24820 24820 2021-03-02 Club Riviera Santa Clara 13 29 0 0 85        
25859 25859 2021-03-01 Club Riviera Santa Clara 13 29 0 0 85        
26896 26896 2021-02-26 Club Riviera Santa Clara 13 29 0 0 85        
27933 27933 2021-02-25 Club Riviera Santa Clara 13 29 0 0 85        
28969 28969 2021-02-24 Club Riviera Santa Clara 13 29 0 0 85        
30002 30002 2021-02-22 Club Riviera Santa Clara 13 29 0 0 85        
31036 31036 2021-02-19 Club Riviera Santa Clara 13 29 0 0 85        
32070 32070 2021-02-18 Club Riviera Santa Clara 13 29 0 0 85        
33103 33103 2021-02-17 Club Riviera Santa Clara 13 29 0 0 85        
34133 34133 2021-02-16 Club Riviera Santa Clara 13 29 0 0 85        
35161 35161 2021-02-12 Club Riviera Santa Clara 13 29 0 0 85        
36188 36188 2021-02-11 Club Riviera Santa Clara 13 29 0 0 85        
37213 37213 2021-02-10 Club Riviera Santa Clara 13 29 0 0 85        
38238 38238 2021-02-09 Club Riviera Santa Clara 13 29 0 0 85        
39262 39262 2021-02-08 Club Riviera Santa Clara 13 29 0 0 85        
40281 40281 2021-02-05 Club Riviera Santa Clara 13 29 0 0 85        
41295 41295 2021-02-04 Club Riviera Santa Clara 13 29 0 0 85        
42305 42305 2021-02-03 Club Riviera Santa Clara 13 29 0 0 85        
43313 43313 2021-02-02 Club Riviera Santa Clara 13 29 0 0 85        
44318 44318 2021-02-01 Club Riviera Santa Clara 13 29 0 0 85        
45318 45318 2021-01-29 Club Riviera Santa Clara 13 29 0 0 85        
46313 46313 2021-01-28 Club Riviera Santa Clara 13 29 0 0 85        
57591 57591 2021-01-08 Terraces At Los Altos, The Santa Clara 13 1 0 0 85   <11    
58464 58464 2021-01-07 Terraces At Los Altos, The Santa Clara 13 1 0 0 85   <11    
59323 59323 2021-01-06 Sunnyside Gardens Santa Clara 13 32 0 1 85       <11
59326 59326 2021-01-06 Terraces At Los Altos, The Santa Clara 13 1 0 0 85   <11    
60173 60173 2021-01-05 Sunnyside Gardens Santa Clara 13 32 0 1 85       <11
61010 61010 2021-01-04 Sunnyside Gardens Santa Clara 13 32 0 1 85       <11
65560 65560 2020-12-23 Saratoga Retirement Community Santa Clara 13 1 1 0 85   <11 <11  
66262 66262 2020-12-22 Saratoga Retirement Community Santa Clara 13 1 1 0 85   <11 <11  
66266 66266 2020-12-22 Sunrise Assisted Living Of Palo Alto Santa Clara 13 1 0 1 85   <11   <11
66268 66268 2020-12-22 Terraces Of Los Gatos, The Santa Clara 13 1 0 1 85   <11   <11
66953 66953 2020-12-21 Saratoga Retirement Community Santa Clara 13 1 1 0 85   <11 <11  
66957 66957 2020-12-21 Sunrise Assisted Living Of Palo Alto Santa Clara 13 1 0 1 85   <11   <11
67611 67611 2020-12-18 Saratoga Retirement Community Santa Clara 13 1 1 0 85   <11 <11  
68259 68259 2020-12-17 Saratoga Retirement Community Santa Clara 13 1 1 0 85   <11 <11  
68889 68889 2020-12-16 Saratoga Retirement Community Santa Clara 13 1 1 0 85   <11 <11  
69506 69506 2020-12-15 Saratoga Retirement Community Santa Clara 13 1 1 0 85   <11 <11  
73975 73975 2020-12-03 Palo Alto Commons Santa Clara 13 1 0 0 85   <11    
74481 74481 2020-12-02 Palo Alto Commons Santa Clara 13 1 0 0 85   <11    
74986 74986 2020-12-01 Vi At Palo Alto Santa Clara 13 14 0 1 85       <11
75483 75483 2020-11-30 Vi At Palo Alto Santa Clara 13 14 0 1 85       <11
75968 75968 2020-11-27 Vi At Palo Alto Santa Clara 13 14 0 1 85       <11
76441 76441 2020-11-25 Vi At Palo Alto Santa Clara 13 14 0 1 85       <11
76912 76912 2020-11-24 Vi At Palo Alto Santa Clara 13 14 0 1 85       <11
77355 77355 2020-11-23 Brookdale San Jose Santa Clara 13 1 0 0 85   <11    
77364 77364 2020-11-23 Vi At Palo Alto Santa Clara 13 14 0 1 85       <11
77814 77814 2020-11-20 Vi At Palo Alto Santa Clara 13 14 0 1 85       <11
78262 78262 2020-11-19 Vi At Palo Alto Santa Clara 13 14 0 1 85       <11
78705 78705 2020-11-18 Vi At Palo Alto Santa Clara 13 14 0 1 85       <11
79145 79145 2020-11-17 Vi At Palo Alto Santa Clara 13 13 0 1 85       <11
79582 79582 2020-11-16 Vi At Palo Alto Santa Clara 13 13 0 1 85       <11
80006 80006 2020-11-13 Vi At Palo Alto Santa Clara 13 13 0 1 85       <11
80427 80427 2020-11-12 Vi At Palo Alto Santa Clara 13 13 0 1 85       <11
80846 80846 2020-11-11 Vi At Palo Alto Santa Clara 13 13 0 1 85       <11
81264 81264 2020-11-10 Vi At Palo Alto Santa Clara 13 13 0 1 85       <11
81680 81680 2020-11-09 Vi At Palo Alto Santa Clara 13 13 0 1 85       <11
82095 82095 2020-11-06 Vi At Palo Alto Santa Clara 13 13 0 1 85       <11
82507 82507 2020-11-05 Vi At Palo Alto Santa Clara 13 13 0 1 85       <11
82918 82918 2020-11-04 Vi At Palo Alto Santa Clara 13 13 0 1 85       <11
83326 83326 2020-11-03 Vi At Palo Alto Santa Clara 13 13 0 1 85       <11
83731 83731 2020-11-02 Vi At Palo Alto Santa Clara 13 13 0 1 85       <11
84133 84133 2020-10-30 Vi At Palo Alto Santa Clara 13 13 0 1 85       <11
84535 84535 2020-10-29 Vi At Palo Alto Santa Clara 13 13 0 1 85       <11
84937 84937 2020-10-28 Vi At Palo Alto Santa Clara 13 13 0 1 85       <11
85339 85339 2020-10-27 Vi At Palo Alto Santa Clara 13 13 0 1 85       <11
85740 85740 2020-10-26 Vi At Palo Alto Santa Clara 13 13 0 1 85       <11
86133 86133 2020-10-23 Vi At Palo Alto Santa Clara 13 13 0 1 85       <11
86527 86527 2020-10-22 Vi At Palo Alto Santa Clara 13 13 0 1 85       <11
86922 86922 2020-10-21 Vi At Palo Alto Santa Clara 13 13 0 1 85       <11
87315 87315 2020-10-20 Vi At Palo Alto Santa Clara 13 13 0 1 85       <11
87706 87706 2020-10-19 Vi At Palo Alto Santa Clara 13 13 0 1 85       <11
88097 88097 2020-10-16 Vi At Palo Alto Santa Clara 13 13 0 1 85       <11
88487 88487 2020-10-15 Vi At Palo Alto Santa Clara 13 13 0 1 85       <11
88875 88875 2020-10-14 Vi At Palo Alto Santa Clara 13 13 0 1 85       <11

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