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

81 rows where county = "Riverside" and staff_confirmed_cases = 29 sorted by date descending

✎ View and edit SQL

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

Suggested facets: name, staff_deaths, staff_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
548 548 2021-06-27 Gladwell Rancho Mirage Riverside 29 37 0 1 65       <11
1566 1566 2021-05-11 Gladwell Rancho Mirage Riverside 29 37 0 1 65       <11
2597 2597 2021-04-27 Gladwell Rancho Mirage Riverside 29 37 0 1 65       <11
3646 3646 2021-04-21 Gladwell Rancho Mirage Riverside 29 37 0 1 65       <11
4694 4694 2021-04-06 Gladwell Rancho Mirage Riverside 29 37 0 1 65       <11
5741 5741 2021-03-30 Gladwell Rancho Mirage Riverside 29 37 0 1 65       <11
5746 5746 2021-03-30 Highgate Senior Living-Temecula Riverside 29 15 0 1 65       <11
6788 6788 2021-03-29 Gladwell Rancho Mirage Riverside 29 37 0 1 65       <11
6793 6793 2021-03-29 Highgate Senior Living-Temecula Riverside 29 15 0 1 65       <11
7835 7835 2021-03-25 Gladwell Rancho Mirage Riverside 29 37 0 1 65       <11
7840 7840 2021-03-25 Highgate Senior Living-Temecula Riverside 29 15 0 1 65       <11
8882 8882 2021-03-24 Gladwell Rancho Mirage Riverside 29 37 0 1 65       <11
8887 8887 2021-03-24 Highgate Senior Living-Temecula Riverside 29 15 0 1 65       <11
9929 9929 2021-03-23 Gladwell Rancho Mirage Riverside 29 37 0 1 65       <11
9934 9934 2021-03-23 Highgate Senior Living-Temecula Riverside 29 15 0 1 65       <11
10975 10975 2021-03-22 Gladwell Rancho Mirage Riverside 29 37 0 1 65       <11
10980 10980 2021-03-22 Highgate Senior Living-Temecula Riverside 29 15 0 1 65       <11
12021 12021 2021-03-19 Gladwell Rancho Mirage Riverside 29 37 0 1 65       <11
12026 12026 2021-03-19 Highgate Senior Living-Temecula Riverside 29 15 0 1 65       <11
13066 13066 2021-03-18 Gladwell Rancho Mirage Riverside 29 37 0 1 65       <11
13071 13071 2021-03-18 Highgate Senior Living-Temecula Riverside 29 15 0 1 65       <11
14111 14111 2021-03-17 Gladwell Rancho Mirage Riverside 29 37 0 1 65       <11
14116 14116 2021-03-17 Highgate Senior Living-Temecula Riverside 29 14 0 1 65       <11
15155 15155 2021-03-16 Gladwell Rancho Mirage Riverside 29 37 0 1 65       <11
15160 15160 2021-03-16 Highgate Senior Living-Temecula Riverside 29 14 0 1 65       <11
16199 16199 2021-03-15 Gladwell Rancho Mirage Riverside 29 37 0 1 65       <11
16204 16204 2021-03-15 Highgate Senior Living-Temecula Riverside 29 14 0 1 65       <11
17243 17243 2021-03-12 Gladwell Rancho Mirage Riverside 29 37 0 1 65       <11
17248 17248 2021-03-12 Highgate Senior Living-Temecula Riverside 29 14 0 1 65       <11
18286 18286 2021-03-11 Gladwell Rancho Mirage Riverside 29 37 0 1 65       <11
18291 18291 2021-03-11 Highgate Senior Living-Temecula Riverside 29 14 0 1 65       <11
19328 19328 2021-03-10 Gladwell Rancho Mirage Riverside 29 37 0 1 65       <11
19333 19333 2021-03-10 Highgate Senior Living-Temecula Riverside 29 14 0 1 65       <11
20370 20370 2021-03-09 Gladwell Rancho Mirage Riverside 29 37 0 1 65       <11
20375 20375 2021-03-09 Highgate Senior Living-Temecula Riverside 29 14 0 1 65       <11
21380 21380 2021-03-08 Gladwell Rancho Mirage Riverside 29 37 0 1 65       <11
21385 21385 2021-03-08 Highgate Senior Living-Temecula Riverside 29 14 0 1 65       <11
22400 22400 2021-03-04 Gladwell Rancho Mirage Riverside 29 37 0 1 65       <11
22405 22405 2021-03-04 Highgate Senior Living-Temecula Riverside 29 14 0 1 65       <11
23440 23440 2021-03-03 Gladwell Rancho Mirage Riverside 29 37 0 1 65       <11
23445 23445 2021-03-03 Highgate Senior Living-Temecula Riverside 29 14 0 1 65       <11
24480 24480 2021-03-02 Gladwell Rancho Mirage Riverside 29 37 0 1 65       <11
24485 24485 2021-03-02 Highgate Senior Living-Temecula Riverside 29 14 0 1 65       <11
25519 25519 2021-03-01 Gladwell Rancho Mirage Riverside 29 37 0 1 65       <11
25524 25524 2021-03-01 Highgate Senior Living-Temecula Riverside 29 14 0 1 65       <11
26556 26556 2021-02-26 Gladwell Rancho Mirage Riverside 29 37 0 1 65       <11
26561 26561 2021-02-26 Highgate Senior Living-Temecula Riverside 29 14 0 1 65       <11
27593 27593 2021-02-25 Gladwell Rancho Mirage Riverside 29 37 0 1 65       <11
27598 27598 2021-02-25 Highgate Senior Living-Temecula Riverside 29 14 0 1 65       <11
28629 28629 2021-02-24 Gladwell Rancho Mirage Riverside 29 37 0 1 65       <11
28634 28634 2021-02-24 Highgate Senior Living-Temecula Riverside 29 14 0 1 65       <11
29663 29663 2021-02-22 Gladwell Rancho Mirage Riverside 29 37 0 1 65       <11
29668 29668 2021-02-22 Highgate Senior Living-Temecula Riverside 29 14 0 1 65       <11
30697 30697 2021-02-19 Gladwell Rancho Mirage Riverside 29 37 0 1 65       <11
30702 30702 2021-02-19 Highgate Senior Living-Temecula Riverside 29 14 0 1 65       <11
31731 31731 2021-02-18 Gladwell Rancho Mirage Riverside 29 37 0 1 65       <11
31736 31736 2021-02-18 Highgate Senior Living-Temecula Riverside 29 14 0 1 65       <11
32764 32764 2021-02-17 Gladwell Rancho Mirage Riverside 29 37 0 1 65       <11
32769 32769 2021-02-17 Highgate Senior Living-Temecula Riverside 29 14 0 1 65       <11
33795 33795 2021-02-16 Gladwell Rancho Mirage Riverside 29 37 0 1 65       <11
33800 33800 2021-02-16 Highgate Senior Living-Temecula Riverside 29 14 0 1 65       <11
34829 34829 2021-02-12 Highgate Senior Living-Temecula Riverside 29 14 0 1 65       <11
35856 35856 2021-02-11 Highgate Senior Living-Temecula Riverside 29 14 0 1 65       <11
36881 36881 2021-02-10 Highgate Senior Living-Temecula Riverside 29 14 0 1 65       <11
37907 37907 2021-02-09 Highgate Senior Living-Temecula Riverside 29 14 0 1 65       <11
38931 38931 2021-02-08 Highgate Senior Living-Temecula Riverside 29 14 0 1 65       <11
39952 39952 2021-02-05 Highgate Senior Living-Temecula Riverside 29 14 0 1 65       <11
39983 39983 2021-02-05 Wildomar Senior Assisted Living Riverside 29 19 0 1 65       <11
40998 40998 2021-02-04 Wildomar Senior Assisted Living Riverside 29 19 0 1 65       <11
42009 42009 2021-02-03 Wildomar Senior Assisted Living Riverside 29 19 0 1 65       <11
43017 43017 2021-02-02 Wildomar Senior Assisted Living Riverside 29 19 0 1 65       <11
49869 49869 2021-01-21 Estancia Del Sol Riverside 29 25 0 1 65       <11
49898 49898 2021-01-21 Vineyard Place Riverside 29 42 1 18 65     <11  
50816 50816 2021-01-20 Estancia Del Sol Riverside 29 25 0 1 65       <11
50848 50848 2021-01-20 Vineyard Place Riverside 29 42 1 18 65     <11  
51776 51776 2021-01-19 Estancia Del Sol Riverside 29 25 0 1 65       <11
51808 51808 2021-01-19 Vineyard Place Riverside 29 42 1 18 65     <11  
52720 52720 2021-01-15 Estancia Del Sol Riverside 29 25 0 1 65       <11
53634 53634 2021-01-14 Estancia Del Sol Riverside 29 25 0 1 65       <11
64629 64629 2020-12-24 Welbrook Senior Living Arlington Riverside 29 16 1 1 65     <11 <11
65345 65345 2020-12-23 Welbrook Senior Living Arlington Riverside 29 16 1 1 65     <11 <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
);