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

10,308 rows sorted by date descending

View and edit SQL

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

staff_deaths

  • 0 9,291
  • 1 614
  • 403
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-08-03 None Brookdale North Fremont Alameda 1 22 21     0 1   10 or fewer
2 2020-08-03 None Carlton Plaza Of San Leandro Alameda 1 1 1 10 or fewer 10 or fewer 0 0    
3 2020-08-03 None Fremont Village Alameda 1 27 47     0 1   10 or fewer
4 2020-08-03 None Lincoln Villa Alameda 1 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
5 2020-08-03 None Point At Rockridge, The Alameda 1 1 14 10 or fewer   0 1   10 or fewer
6 2020-08-03 None St. Regis Retirement Center, Inc. Alameda 1 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
7 2020-08-03 None Chateau At Poets Corner Contra Costa 13 1 18 10 or fewer   0 1   10 or fewer
8 2020-08-03 None Chateau III Contra Costa 13 36 39     0 1   10 or fewer
9 2020-08-03 None Greenridge Senior Care Contra Costa 13 0 1   10 or fewer 0 1   10 or fewer
10 2020-08-03 None Belmar Villa Fresno 19 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
11 2020-08-03 None Carmel Village Memory Care Fresno 19 0 1   10 or fewer 0 1   10 or fewer
12 2020-08-03 None Fairwinds - Woodward Park Fresno 19 20 1   10 or fewer 0 1   10 or fewer
13 2020-08-03 None Gettysburg Christian Home Fresno 19 0 1   10 or fewer 0 1   10 or fewer
14 2020-08-03 None Kingston Bay Senior Living Fresno 19 1 1 10 or fewer 10 or fewer 0 0    
15 2020-08-03 None Alder Bay Assisted Living Humboldt 23 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
16 2020-08-03 None Blossom Valley Inn Imperial 25 1 49 10 or fewer   1 1 10 or fewer 10 or fewer
17 2020-08-03 None Centre Village Kern 29 15 1   10 or fewer 0 0    
18 2020-08-03 None Hallmark Of Bakersfield Kern 29 1 13 10 or fewer   0 0    
19 2020-08-03 None Pacifica Of Bakersfield Kern 29 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
20 2020-08-03 None Abbey Road Villa Los Angeles 37 1 19 10 or fewer   0 0    
21 2020-08-03 None Alta Vista Gardens Los Angeles 37 1 14 10 or fewer   0 0    
22 2020-08-03 None Ararat Home Of Los Angeles Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
23 2020-08-03 None Arbor Vista Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
24 2020-08-03 None Atria Park Of Pacific Palisades Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
25 2020-08-03 None Avantgarde Senior Living Of Tarzana Los Angeles 37 22 17     0 1   10 or fewer
26 2020-08-03 None Belmont Village Encino Los Angeles 37 24 26     0 1   10 or fewer
27 2020-08-03 None Belmont Village Hollywood Los Angeles 37 20 18     0 1   10 or fewer
28 2020-08-03 None Belmont Village Rancho Palos Verdes Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
29 2020-08-03 None Belmont Village Westwood Los Angeles 37 11 1   10 or fewer 0 0    
30 2020-08-03 None Beverly Hills Carmel Retirement Hotel Los Angeles 37 1 15 10 or fewer   1 1 10 or fewer 10 or fewer
31 2020-08-03 None Beverly Hills Gardens Care Center Los Angeles 37 1 12 10 or fewer   1 1 10 or fewer 10 or fewer
32 2020-08-03 None Brookdale Central Whittier Los Angeles 37 1 1 10 or fewer 10 or fewer 0 0    
33 2020-08-03 None Brookdale Gardens Of Tarzana Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
34 2020-08-03 None Brookdale Monrovia Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
35 2020-08-03 None Brookdale Northridge Los Angeles 37 11 23     0 13    
36 2020-08-03 None Canyon Trails At Topanga Senior Living Los Angeles 37 12 35     0 1   10 or fewer
37 2020-08-03 None Carson Senior Assisted Living Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
38 2020-08-03 None Cedars Assisted Living, The Los Angeles 37 14 39     0 1   10 or fewer
39 2020-08-03 None Charlie's Residential Care Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
40 2020-08-03 None City View La, LLC Los Angeles 37 1 1 10 or fewer 10 or fewer 0 0    
41 2020-08-03 None Commons At Woodland Hills, The Los Angeles 37 19 29     0 1   10 or fewer
42 2020-08-03 None Crofton Manor Inn Los Angeles 37 22 32     0 1   10 or fewer
43 2020-08-03 None Fallbrook Glen Of West Hills Los Angeles 37 1 19 10 or fewer   0 1   10 or fewer
44 2020-08-03 None Glen Park At Glendale - Boynton St Los Angeles 37 11 21     0 1   10 or fewer
45 2020-08-03 None Golden Assisted Living Los Angeles 37 1 12 10 or fewer   0 0    
46 2020-08-03 None Grandview, The Los Angeles 37 1 18 10 or fewer   0 1   10 or fewer
47 2020-08-03 None Grove At Cerritos, The Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
48 2020-08-03 None Heights At Burbank, The Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
49 2020-08-03 None Hollenbeck Palms Los Angeles 37 1 1 10 or fewer 10 or fewer 0 0    
50 2020-08-03 None Inn At The Park Ventura Los Angeles 37 1 29 10 or fewer   0 1   10 or fewer
51 2020-08-03 None Jasmin Terrace At El Molino Los Angeles 37 26 66     0 19    
52 2020-08-03 None Kensington Redondo Beach, The Los Angeles 37 22 22     1 1 10 or fewer 10 or fewer
53 2020-08-03 None Kensington Sierra Madre, The Los Angeles 37 17 12     0 1   10 or fewer
54 2020-08-03 None Kingsley Manor Los Angeles 37 1 0 10 or fewer   1 0 10 or fewer  
55 2020-08-03 None Lakewood Park Manor Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
56 2020-08-03 None Lucerne One Llc Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
57 2020-08-03 None Meadowbrook At Agoura Hills Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
58 2020-08-03 None Mgh Corporation, The Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
59 2020-08-03 None Mugungwha Silver Town Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
60 2020-08-03 None Oakmont Of Santa Clarita Los Angeles 37 1 14 10 or fewer   0 1   10 or fewer
61 2020-08-03 None Oakmont Of Valencia Los Angeles 37 1 15 10 or fewer   0 1   10 or fewer
62 2020-08-03 None Pacifica Senior Living Northridge Los Angeles 37 26 42     0 16    
63 2020-08-03 None Palmcrest Grand Residence Los Angeles 37 1 15 10 or fewer   0 1   10 or fewer
64 2020-08-03 None Regency Palms Long Beach Los Angeles 37 13 1   10 or fewer 0 0    
65 2020-08-03 None Rosecrans Villa Residential Care Los Angeles 37 1 14 10 or fewer   0 0    
66 2020-08-03 None Royalty Assisted Living Los Angeles 37 0 1   10 or fewer 0 1   10 or fewer
67 2020-08-03 None Silverado Senior Living - Calabasas Los Angeles 37 17 49     0 13    
68 2020-08-03 None Silverado Senior Living – Beverly Place Los Angeles 37 33 57     1 13 10 or fewer  
69 2020-08-03 None Solheim Senior Community Los Angeles 37 11 1   10 or fewer 0 1   10 or fewer
70 2020-08-03 None Sunrise Assisted Living Of Studio City Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
71 2020-08-03 None Sunrise At Sterling Canyon Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
72 2020-08-03 None Sunrise Of Beverly Hills Los Angeles 37 1 1 10 or fewer 10 or fewer 0 0    
73 2020-08-03 None Sunrise Of Westlake Village Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
74 2020-08-03 None Sunrise Villa Culver City Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
75 2020-08-03 None Veterans Home Of California – West Los Angeles Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
76 2020-08-03 None Villa Gardens Los Angeles 37 40 17     0 1   10 or fewer
77 2020-08-03 None Village At Sherman Oaks, The Los Angeles 37 1 1 10 or fewer 10 or fewer 0 0    
78 2020-08-03 None Vista Del Mar Senior Living Los Angeles 37 11 28     0 1   10 or fewer
79 2020-08-03 None Watermark At Beverly Hills, The Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
80 2020-08-03 None West Valley Assisted Living Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
81 2020-08-03 None Western Assemblies Home Los Angeles 37 11 1   10 or fewer 0 1   10 or fewer
82 2020-08-03 None Whittier Place Senior Living Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
83 2020-08-03 None Windsor Hall Care Home Inc. Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
84 2020-08-03 None Cedar Creek Senior Living Madera 39 1 21 10 or fewer   0 1   10 or fewer
85 2020-08-03 None Aegis Assisted Living Of Corte Madera Marin 41 13 1   10 or fewer 0 0    
86 2020-08-03 None Atria Tamalpais Creek Marin 41 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
87 2020-08-03 None Drake Terrace Marin 41 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
88 2020-08-03 None Golden Home Extended Care, Inc. Marin 41 1 13 10 or fewer   0 0    
89 2020-08-03 None Nazareth House Of San Rafael, Inc. Marin 41 11 17     0 1   10 or fewer
90 2020-08-03 None Windchime Of Marin Marin 41 1 11 10 or fewer   0 1   10 or fewer
91 2020-08-03 None Acacia Villas Orange 59 1 14 10 or fewer   0 1   10 or fewer
92 2020-08-03 None Activcare At Yorba Linda Orange 59 11 17     1 1 10 or fewer 10 or fewer
93 2020-08-03 None Anaheim Crown Plaza Orange 59 1 1 10 or fewer 10 or fewer 0 0    
94 2020-08-03 None Atria San Juan Orange 59 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
95 2020-08-03 None Brookdale Anaheim Orange 59 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
96 2020-08-03 None Brookdale Nohl Ranch Orange 59 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
97 2020-08-03 None Brookdale Yorba Linda Orange 59 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
98 2020-08-03 None Capriana Orange 59 11 1   10 or fewer 0 1   10 or fewer
99 2020-08-03 None Carmel Village Retirement Community Orange 59 12 1   10 or fewer 0 1   10 or fewer
100 2020-08-03 None Harbor Heights Assisted Living & Memory Care Orange 59 1 1 10 or fewer 10 or fewer 0 0    

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 630.677ms · 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