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

116,613 rows sorted by date descending

✎ View and edit SQL

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

Suggested facets: staff_deaths, 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
1 1 2021-06-27 Acacia Creek - Union City Alameda 1 1 0 0 1 <11 <11    
2 2 2021-06-27 Aegis Assisted Living Of Fremont Alameda 12 15 0 0 1        
3 3 2021-06-27 Arcadian Residential Community Alameda 15 28 0 1 1       <11
4 4 2021-06-27 Belmont Village Albany Alameda 15 1 0 0 1   <11    
5 5 2021-06-27 Brookdale North Fremont Alameda 22 26 0 1 1       <11
6 6 2021-06-27 Carefield Pleasanton Alameda 17 24 0 1 1       <11
7 7 2021-06-27 Carlton Plaza Of Fremont Alameda 13 1 0 0 1   <11    
8 8 2021-06-27 Carlton Plaza Of San Leandro Alameda 36 41 1 1 1     <11 <11
9 9 2021-06-27 Creekview Assisted Living Alameda 28 28 0 1 1       <11
10 10 2021-06-27 Elder Ashram Alameda 1 18 0 0 1 <11      
11 11 2021-06-27 Fremont Hills Alameda 1 1 0 0 1 <11 <11    
12 12 2021-06-27 Fremont Rtrmt Com-Happy Lvng By Cogir/Cogir Fremon Alameda 1 1 0 0 1 <11 <11    
13 13 2021-06-27 Fremont Village Alameda 33 60 1 14 1     <11  
14 14 2021-06-27 Heritage Haven Alameda 1 21 0 1 1 <11     <11
15 15 2021-06-27 J-Sei Home Alameda 1 1 0 1 1 <11 <11   <11
16 16 2021-06-27 Lakeside Park Alameda 21 18 0 1 1       <11
17 17 2021-06-27 Landmark Villa Alameda 1 1 0 0 1 <11 <11    
18 18 2021-06-27 Lincoln Villa Alameda 1 18 0 1 1 <11     <11
19 19 2021-06-27 Marymount Villa Retirement Center Alameda 17 49 1 16 1     <11  
20 20 2021-06-27 Masonic Home For Adults Alameda 17 1 0 0 1   <11    
21 21 2021-06-27 Merrill Gardens At Rockridge Alameda 11 1 1 1 1   <11 <11 <11
22 22 2021-06-27 Mori Manor Alameda 1 1 0 1 1 <11 <11   <11
23 23 2021-06-27 Oakcreek Alameda 1 15 0 1 1 <11     <11
24 24 2021-06-27 Oakmont Of Mariner Point Alameda 24 26 0 1 1       <11
25 25 2021-06-27 Pacifica Senior Living Oakland Alameda 20 22 0 1 1       <11
26 26 2021-06-27 Pacifica Senior Living San Leandro Alameda 1 1 0 0 1 <11 <11    
27 27 2021-06-27 Parkview, The Alameda 19 41 0 1 1       <11
28 28 2021-06-27 Point At Rockridge, The Alameda 13 35 0 1 1       <11
29 29 2021-06-27 Quail Garden Alameda 1 16 0 1 1 <11     <11
30 30 2021-06-27 Rosegate Alameda 11 19 0 0 1        
31 31 2021-06-27 Scott Villa Alameda 1 30 0 1 1 <11     <11
32 32 2021-06-27 Silverado Senior Living - Berkeley Alameda 33 58 0 14 1        
33 33 2021-06-27 St. Paul's Towers Alameda 20 1 0 0 1   <11    
34 34 2021-06-27 St. Regis Retirement Center, Inc. Alameda 11 19 0 1 1       <11
35 35 2021-06-27 Stoneridge Creek Pleasanton Alameda 38 1 0 0 1   <11    
36 36 2021-06-27 Sunrise Of Pleasanton Alameda 13 16 0 0 1        
37 37 2021-06-27 Watermark At Rosewood Gardens, The Alameda 14 34 0 1 1       <11
38 38 2021-06-27 Watermark By The Bay, The Alameda 12 1 0 0 1   <11    
39 39 2021-06-27 Waters Edge Lodge Alameda 1 1 0 1 1 <11 <11   <11
40 40 2021-06-27 Willow Creek Alzheimer's & Dementia Care Center Alameda 1 1 0 1 1 <11 <11   <11
41 41 2021-06-27 Woodside Residential Care Facility For Elderly Alameda 1 11 0 1 1 <11     <11
42 42 2021-06-27 Amador Residential Care Facility Amador 1 1 0 1 5 <11 <11   <11
43 43 2021-06-27 Amber Grove Place Butte 14 22 0 1 7       <11
44 44 2021-06-27 Compass Rose Butte 11 20 0 1 7       <11
45 45 2021-06-27 Country Crest Assisted Living Butte 1 1 0 1 7 <11 <11   <11
46 46 2021-06-27 Country House Butte 1 15 0 0 7 <11      
47 47 2021-06-27 Courtyard At Little Chico Creek, The Butte 18 22 0 0 7        
48 48 2021-06-27 Prestige Assisted Living At Chico Butte 15 1 1 0 7   <11 <11  
49 49 2021-06-27 Roseleaf Gardens Butte 13 26 1 1 7     <11 <11
50 50 2021-06-27 Townsend House Butte 1 17 0 0 7 <11      
51 51 2021-06-27 Windchime Of Chico Butte 1 20 1 1 7 <11   <11 <11
52 52 2021-06-27 Aegis Assisted Living Of Moraga Contra Costa 11 1 0 0 13   <11    
53 53 2021-06-27 Aegis Assisted Living Of Pleasant Hill Contra Costa 19 28 0 1 13       <11
54 54 2021-06-27 Atria Valley View Contra Costa 12 1 0 0 13   <11    
55 55 2021-06-27 Atria Walnut Creek Contra Costa 1 1 0 0 13 <11 <11    
56 56 2021-06-27 Brookdale Diablo Lodge Contra Costa 1 12 0 1 13 <11     <11
57 57 2021-06-27 Brookdale San Ramon Contra Costa 1 1 0 1 13 <11 <11   <11
58 58 2021-06-27 Byron Park Contra Costa 17 14 0 1 13       <11
59 59 2021-06-27 Carnelian I Contra Costa 1 1 0 1 13 <11 <11   <11
60 60 2021-06-27 Chateau At Poets Corner Contra Costa 27 28 0 1 13       <11
61 61 2021-06-27 Chateau III Contra Costa 38 39 0 1 13       <11
62 62 2021-06-27 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
63 63 2021-06-27 Concord Royale Contra Costa 1 1 0 1 13 <11 <11   <11
64 64 2021-06-27 Diana's Care Home Contra Costa 1 30 0 0 13 <11      
65 65 2021-06-27 Friendship Care Home Contra Costa 1 16 0 1 13 <11     <11
66 66 2021-06-27 Greenridge Senior Care Contra Costa 1 1 0 1 13 <11 <11   <11
67 67 2021-06-27 Heatherwood Memory Care Contra Costa 1 1 0 0 13 <11 <11    
68 68 2021-06-27 Kensington, The Contra Costa 1 1 0 1 13 <11 <11   <11
69 69 2021-06-27 Montecito Oakmont Senior Living Contra Costa 1 1 0 0 13 <11 <11    
70 70 2021-06-27 Pleasant Hill Oasis Contra Costa 14 16 0 0 13        
71 71 2021-06-27 Reutlinger Community, The Contra Costa 14 1 0 1 13   <11   <11
72 72 2021-06-27 Sunrise Assisted Living Of Danville Contra Costa 33 25 0 1 13       <11
73 73 2021-06-27 Sunrise Assisted Living Of Walnut Creek Contra Costa 17 25 0 1 13       <11
74 74 2021-06-27 Sunrise Villa San Ramon Contra Costa 1 1 0 1 13 <11 <11   <11
75 75 2021-06-27 TreVista Concord Contra Costa 13 22 0 1 13       <11
76 76 2021-06-27 Trevista Antioch Contra Costa 30 45 0 1 13       <11
77 77 2021-06-27 Walnut Creek Willows Contra Costa 1 1 0 1 13 <11 <11   <11
78 78 2021-06-27 Westmont Of Brentwood Contra Costa 25 34 0 1 13       <11
79 79 2021-06-27 Westmont Of Pinole Contra Costa 1 1 0 0 13 <11 <11    
80 80 2021-06-27 Eskaton Village Placerville El Dorado 18 26 0 1 17       <11
81 81 2021-06-27 New West Haven Ii El Dorado 1 15 0 1 17 <11     <11
82 82 2021-06-27 Oakmont Of El Dorado Hills El Dorado 11 1 0 0 17   <11    
83 83 2021-06-27 Ponte Palmero El Dorado 1 1 0 1 17 <11 <11   <11
84 84 2021-06-27 Autumn Ridge Assisted Living Fresno 1 1 0 1 19 <11 <11   <11
85 85 2021-06-27 Belmar Villa Fresno 1 14 0 1 19 <11     <11
86 86 2021-06-27 Carmel Village At Clovis Fresno 23 1 0 0 19   <11    
87 87 2021-06-27 Carmel Village Memory Care Fresno 23 28 0 1 19       <11
88 88 2021-06-27 Fairwinds - Woodward Park Fresno 25 15 0 1 19       <11
89 89 2021-06-27 Gettysburg Christian Home Fresno 0 1 0 1 19   <11   <11
90 90 2021-06-27 Harvest At Fowler, The Fresno 1 1 0 1 19 <11 <11   <11
91 91 2021-06-27 Kingston Bay Senior Living Fresno 19 12 0 1 19       <11
92 92 2021-06-27 Oakmont Of Fresno Fresno 19 36 0 1 19       <11
93 93 2021-06-27 Pacifica Senior Living Fresno Fresno 16 15 1 1 19     <11 <11
94 94 2021-06-27 Paintbrush Assisted Living And Memory Care Fresno 19 32 0 0 19        
95 95 2021-06-27 Palm Village Retirement Community Fresno 29 18 0 0 19        
96 96 2021-06-27 Rehabilitation Centre Of Fresno Fresno 1 27 0 1 19 <11     <11
97 97 2021-06-27 River Bluffs Memory Care Community Fresno 1 26 0 1 19 <11     <11
98 98 2021-06-27 Sierra View Homes Residential Care Fresno 13 1 0 0 19   <11    
99 99 2021-06-27 Terraces At San Joaquin Gardens, The Fresno 42 33 0 1 19       <11
100 100 2021-06-27 Twilight Haven Fresno 12 11 0 0 19        

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