home / la-times

Menu
  • GraphQL API

cdph-adult-and-senior-care-facilities

Table actions
  • GraphQL API for cdph-adult-and-senior-care-facilities

California's Department of Public Health is listing the residential care facilities for the elderly and adult residential facilities across the state with COVID-19 outbreaks.

These are also sometimes known as assisted-living facilities. In some circumstances the true total of cases is obscured. The lowest number in the range is entered into the record in the staff or patients field and an accompanying note field includes the set of possible values.

Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README

date
The date when the data were retrieved in ISO 8601 format.
name
The name of the nursing home.
county
The name of the county where the city is located.
fips
The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
staff_confirmed_cases
The cumulative number of confirmed coronavirus case amoung staff at that time.
patients_confirmed_cases
The cumulative number of confirmed coronavirus case amoung patients at that time.
staff_confirmed_cases_note
In cases where the staff_confirmed_cases are obscured, this explains the range of possible values.
patients_confirmed_cases_note
In cases where the patients_confirmed_cases are obscured, this explains the range of possible values.
staff_deaths
The cumulative number of deaths amoung staff at that time.
patients_deaths
The cumulative number of deaths amoung patients at that time.
staff_deaths_note
In cases where the staff_deaths are obscured, this explains the range of possible values.
patients_deaths_note
In cases where the patients_deaths are obscured, this explains the range of possible values.

116,613 rows

✎ View and edit SQL

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

date (date) >30 ✖

  • 2021-06-27 1,054
  • 2021-04-21 1,049
  • 2021-04-27 1,049
  • 2021-03-23 1,047
  • 2021-03-24 1,047
  • 2021-03-25 1,047
  • 2021-03-29 1,047
  • 2021-03-30 1,047
  • 2021-04-06 1,047
  • 2021-03-22 1,046
  • 2021-03-18 1,045
  • 2021-03-19 1,045
  • 2021-03-12 1,044
  • 2021-03-15 1,044
  • 2021-03-16 1,044
  • 2021-03-17 1,044
  • 2021-03-11 1,043
  • 2021-03-09 1,042
  • 2021-03-10 1,041
  • 2021-03-03 1,040
  • 2021-03-04 1,040
  • 2021-03-01 1,039
  • 2021-03-02 1,039
  • 2021-02-25 1,037
  • 2021-02-26 1,037
  • 2021-02-24 1,036
  • 2021-02-19 1,034
  • 2021-02-17 1,033
  • 2021-02-18 1,033
  • 2021-02-22 1,033
  • …
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 "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
);
Powered by Datasette · Queries took 1008.739ms · Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README