la_times_cdph_adult_and_senior_care_facilities

⚠️ 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

5,584 rows sorted by date descending

View and edit SQL

Suggested facets: county, fips, staff_confirmed_cases, patients_confirmed_cases_note, staff_deaths, patients_deaths, staff_deaths_note, patients_deaths_note, date (date)

Link rowid date ▲ id name county fips staff_confirmed_cases patients_confirmed_cases staff_confirmed_cases_note patients_confirmed_cases_note staff_deaths patients_deaths staff_deaths_note patients_deaths_note
1 2020-07-02 None Point At Rockridge, The Alameda 1 1 14 10 or fewer   0 1   10 or fewer
2 2020-07-02 None St. Regis Retirement Center, Inc. Alameda 1 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
3 2020-07-02 None Chateau III Contra Costa 13 35 39     0 1   10 or fewer
4 2020-07-02 None Alder Bay Assisted Living Humboldt 23 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
5 2020-07-02 None Blossom Valley Inn Imperial 25 1 37 10 or fewer   0 0    
6 2020-07-02 None Ararat Home Of Los Angeles Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
7 2020-07-02 None Arbor Vista Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
8 2020-07-02 None Atria Park Of Pacific Palisades Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
9 2020-07-02 None Avantgarde Senior Living Of Tarzana Los Angeles 37 22 17     0 1   10 or fewer
10 2020-07-02 None Belmont Village Encino Los Angeles 37 24 26     0 1   10 or fewer
11 2020-07-02 None Belmont Village Hollywood Los Angeles 37 17 20     0 1   10 or fewer
12 2020-07-02 None Belmont Village Rancho Palos Verdes Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
13 2020-07-02 None Beverly Hills Carmel Retirement Hotel Los Angeles 37 1 15 10 or fewer   0 1   10 or fewer
14 2020-07-02 None Beverly Hills Gardens Care Center Los Angeles 37 1 12 10 or fewer   1 1 10 or fewer 10 or fewer
15 2020-07-02 None Brookdale Central Whittier Los Angeles 37 1 1 10 or fewer 10 or fewer 0 0    
16 2020-07-02 None Brookdale Monrovia Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
17 2020-07-02 None Brookdale Northridge Los Angeles 37 1 23 10 or fewer   0 13    
18 2020-07-02 None Canyon Trails At Topanga Senior Living Los Angeles 37 12 35     0 1   10 or fewer
19 2020-07-02 None Carson Senior Assisted Living Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
20 2020-07-02 None Cedars Assisted Living, The Los Angeles 37 14 38     0 1   10 or fewer
21 2020-07-02 None City View La, LLC Los Angeles 37 1 1 10 or fewer 10 or fewer 0 0    
22 2020-07-02 None Commons At Woodland Hills, The Los Angeles 37 1 11 10 or fewer   0 1   10 or fewer
23 2020-07-02 None Crofton Manor Inn Los Angeles 37 17 32     0 1   10 or fewer
24 2020-07-02 None Fallbrook Glen Of West Hills Los Angeles 37 1 19 10 or fewer   0 1   10 or fewer
25 2020-07-02 None Golden Assisted Living Los Angeles 37 1 12 10 or fewer   0 0    
26 2020-07-02 None Grandview, The Los Angeles 37 1 18 10 or fewer   0 1   10 or fewer
27 2020-07-02 None Grove At Cerritos, The Los Angeles 37 0 1   10 or fewer 0 1   10 or fewer
28 2020-07-02 None Heights At Burbank, The Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
29 2020-07-02 None Inn At The Park Ventura Los Angeles 37 1 23 10 or fewer   0 1   10 or fewer
30 2020-07-02 None Jasmin Terrace At El Molino Los Angeles 37 26 66     0 16    
31 2020-07-02 None Kensington Redondo Beach, The Los Angeles 37 22 23     0 1   10 or fewer
32 2020-07-02 None Kensington Sierra Madre, The Los Angeles 37 15 12     0 1   10 or fewer
33 2020-07-02 None Kingsley Manor Los Angeles 37 1 0 10 or fewer   1 0 10 or fewer  
34 2020-07-02 None Lakewood Park Manor Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
35 2020-07-02 None Meadowbrook At Agoura Hills Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
36 2020-07-02 None Mugungwha Silver Town Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
37 2020-07-02 None Oakmont Of Santa Clarita Los Angeles 37 1 14 10 or fewer   0 1   10 or fewer
38 2020-07-02 None Oakmont Of Valencia Los Angeles 37 1 15 10 or fewer   0 1   10 or fewer
39 2020-07-02 None Pacifica Senior Living Northridge Los Angeles 37 26 42     0 16    
40 2020-07-02 None Palmcrest Grand Residence Los Angeles 37 1 15 10 or fewer   0 1   10 or fewer
41 2020-07-02 None Rosecrans Villa Residential Care Los Angeles 37 1 14 10 or fewer   0 0    
42 2020-07-02 None Silverado Senior Living - Calabasas Los Angeles 37 17 49     0 13    
43 2020-07-02 None Silverado Senior Living – Beverly Place Los Angeles 37 33 57     1 13 10 or fewer  
44 2020-07-02 None Solheim Senior Community Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
45 2020-07-02 None Sunrise Assisted Living Of Studio City Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
46 2020-07-02 None Sunrise Villa Culver City Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
47 2020-07-02 None Veterans Home Of California – West Los Angeles Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
48 2020-07-02 None Villa Gardens Los Angeles 37 31 17     0 1   10 or fewer
49 2020-07-02 None Vista Del Mar Senior Living Los Angeles 37 1 24 10 or fewer   0 0    
50 2020-07-02 None West Valley Assisted Living Los Angeles 37 0 1   10 or fewer 0 1   10 or fewer
51 2020-07-02 None Windsor Hall Care Home Inc. Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
52 2020-07-02 None Atria Tamalpais Creek Marin 41 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
53 2020-07-02 None Drake Terrace Marin 41 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
54 2020-07-02 None Windchime Of Marin Marin 41 1 11 10 or fewer   0 1   10 or fewer
55 2020-07-02 None Acacia Villas Orange 59 1 14 10 or fewer   0 1   10 or fewer
56 2020-07-02 None Activcare At Yorba Linda Orange 59 1 1 10 or fewer 10 or fewer 0 0    
57 2020-07-02 None Anaheim Crown Plaza Orange 59 1 1 10 or fewer 10 or fewer 0 0    
58 2020-07-02 None Atria San Juan Orange 59 0 1   10 or fewer 0 1   10 or fewer
59 2020-07-02 None Brookdale Nohl Ranch Orange 59 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
60 2020-07-02 None Brookdale Yorba Linda Orange 59 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
61 2020-07-02 None Regency, The Orange 59 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
62 2020-07-02 None Sea Cliff Assisted Living Orange 59 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
63 2020-07-02 None Sunflower Gardens Orange 59 15 31     0 1   10 or fewer
64 2020-07-02 None Whitten Heights Assisted Living And Memory Care Orange 59 12 14     0 1   10 or fewer
65 2020-07-02 None Atria Rocklin Placer 61 0 1   10 or fewer 0 1   10 or fewer
66 2020-07-02 None Gardens Of Riverside, The Riverside 65 18 29     0 1   10 or fewer
67 2020-07-02 None Gladwell Rancho Mirage Riverside 65 1 13 10 or fewer   0 1   10 or fewer
68 2020-07-02 None Kenneth Slaman Riverside 65 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
69 2020-07-02 None Palms At La Quinta, The Riverside 65 1 19 10 or fewer   0 1   10 or fewer
70 2020-07-02 None Raincross At Riverside Riverside 65 1 14 10 or fewer   0 1   10 or fewer
71 2020-07-02 None Renaissance Village Murrieta Riverside 65 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
72 2020-07-02 None Renaissance Village Rancho Belago Riverside 65 1 11 10 or fewer   0 1   10 or fewer
73 2020-07-02 None Vista Cove At Rancho Mirage Riverside 65 1 28 10 or fewer   0 0    
74 2020-07-02 None Welbrook Senior Living Arlington Riverside 65 11 1   10 or fewer 1 1 10 or fewer 10 or fewer
75 2020-07-02 None Carlton Plaza Of Elk Grove Sacramento 67 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
76 2020-07-02 None Eskaton Gold River Lodge Sacramento 67 0 1   10 or fewer 0 1   10 or fewer
77 2020-07-02 None Eskaton Village Sacramento 67 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
78 2020-07-02 None Oakmont Of Folsom Sacramento 67 1 22 10 or fewer   0 1   10 or fewer
79 2020-07-02 None Sky Park Gardens Sacramento 67 11 1   10 or fewer 0 0    
80 2020-07-02 None Summerset Assisted Living Sacramento 67 1 22 10 or fewer   0 1   10 or fewer
81 2020-07-02 None Sunrise Assisted Living Of Fair Oaks Sacramento 67 1 17 10 or fewer   0 1   10 or fewer
82 2020-07-02 None Sunrise Assisted Living Of Sacramento Sacramento 67 24 25     0 1   10 or fewer
83 2020-07-02 None Blossom Grove Alzheimer's Special Care Center San Bernardino 71 1 16 10 or fewer   0 1   10 or fewer
84 2020-07-02 None Plymouth Village Of Redlands San Bernardino 71 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
85 2020-07-02 None Rose Garden Residential Care San Bernardino 71 1 30 10 or fewer   0 1   10 or fewer
86 2020-07-02 None Sterling Inn San Bernardino 71 1 1 10 or fewer 10 or fewer 1 0 10 or fewer  
87 2020-07-02 None Activcare At Mission Bay San Diego 73 0 1   10 or fewer 0 1   10 or fewer
88 2020-07-02 None Activcare At Rolling Hills Ranch San Diego 73 1 21 10 or fewer   0 1   10 or fewer
89 2020-07-02 None Atria Collwood San Diego 73 1 0 10 or fewer   1 0 10 or fewer  
90 2020-07-02 None Brookdale Clairemont San Diego 73 1 1 10 or fewer 10 or fewer 0 0    
91 2020-07-02 None Cedars @ Paradise Village San Diego 73 0 1   10 or fewer 0 1   10 or fewer
92 2020-07-02 None Cloisters Of The Valley, LLC San Diego 73 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
93 2020-07-02 None Elmcroft Of La Mesa San Diego 73 15 34     0 14    
94 2020-07-02 None Golden Living Health Management, Inc. San Diego 73 1 1 10 or fewer 10 or fewer 0 0    
95 2020-07-02 None Kasitz Kastle San Diego 73 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
96 2020-07-02 None La Vida Real San Diego 73 18 13     0 1   10 or fewer
97 2020-07-02 None Mesaview Senior Assisted Living San Diego 73 1 0 10 or fewer   1 0 10 or fewer  
98 2020-07-02 None Plaza Village Senior Living San Diego 73 1 1 10 or fewer 10 or fewer 0 0    
99 2020-07-02 None Silverado Senior Living - Escondido San Diego 73 1 17 10 or fewer   0 1   10 or fewer
100 2020-07-02 None Stellar Care San Diego 73 1 13 10 or fewer   1 1 10 or fewer 10 or fewer

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [la_times_cdph_adult_and_senior_care_facilities] (
   [date] TEXT,
   [id] TEXT,
   [name] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [staff_confirmed_cases] INTEGER,
   [patients_confirmed_cases] INTEGER,
   [staff_confirmed_cases_note] TEXT,
   [patients_confirmed_cases_note] TEXT,
   [staff_deaths] INTEGER,
   [patients_deaths] INTEGER,
   [staff_deaths_note] TEXT,
   [patients_deaths_note] TEXT
);
Powered by Datasette · Query took 419.548ms · 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