home / la-times

Menu
  • GraphQL API

cdph-skilled-nursing-facilities

Table actions
  • GraphQL API for cdph-skilled-nursing-facilities

California's Department of Social Services is listing the skilled-nursing facilities across the state with COVID-19 outbreaks. The source documents are available in the pdf/adult-and-senior-care/ directory of this repository.

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.
id
The facility's unique identifier with the state.
name
The name of the skilled-nursing facility.
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 current number of confirmed coronavirus case amoung staff at that time.
patients_confirmed_cases
The current 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 case amoung staff at that time.
patients_deaths
The cumulative number of deaths case 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.

776,631 rows

✎ View and edit SQL

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

Suggested facets: date (date)

Link rowid ▼ date id slug 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 2022-01-15 140000321 140000321-alameda-county-medical-center-d-p-snf ALAMEDA COUNTY MEDICAL CENTER D/P SNF Alameda 45 38 0 0 1        
2 2 2022-01-15 20000043 020000043-alameda-healthcare-wellness-center ALAMEDA HEALTHCARE & WELLNESS CENTER Alameda 47 86 0 1 1       <11
3 3 2022-01-15 630011864 630011864-alameda-hospital-southshore-convalescent ALAMEDA HOSPITAL - SOUTHSHORE CONVALESCENT Alameda 1 1 0 0 1 <11 <11    
4 4 2022-01-15 140000686 140000686-alameda-hospital-d-p-snf ALAMEDA HOSPITAL D/P SNF Alameda 12 1 0 0 1   <11    
5 5 2022-01-15 630013891 630013891-all-saint-s-maubert ALL SAINT'S MAUBERT Alameda 1 0 0 0 1 <11      
6 6 2022-01-15 20000070 020000070-all-saints-subacute-transitional-care ALL SAINTS SUBACUTE & TRANSITIONAL CARE Alameda 1 1 0 0 1 <11 <11    
7 7 2022-01-15 20000010 020000010-ashby-care-center ASHBY CARE CENTER Alameda 1 0 0 0 1 <11      
8 8 2022-01-15 140001291 140001291-avondale-villa-post-acute AVONDALE VILLA POST-ACUTE Alameda 18 22 0 1 1       <11
9 9 2022-01-15 20000015 020000015-bancroft-healthcare-center BANCROFT HEALTHCARE CENTER Alameda 1 0 0 0 1 <11      
10 10 2022-01-15 20000135 020000135-bay-area-healthcare-center BAY AREA HEALTHCARE CENTER Alameda 27 1 0 1 1   <11   <11
11 11 2022-01-15 20000026 020000026-bay-view-rehabilitation-hospital-llc BAY VIEW REHABILITATION HOSPITAL, LLC Alameda 71 141 0 1 1       <11
12 12 2022-01-15 20000060 020000060-baypoint-healthcare-center BAYPOINT HEALTHCARE CENTER Alameda 15 19 0 1 1       <11
13 13 2022-01-15 630011713 630011713-baywood-court-health-center BAYWOOD COURT HEALTH CENTER Alameda 12 1 0 0 1   <11    
14 14 2022-01-15 20001250 020001250-bellaken-skilled-nursing-center BELLAKEN SKILLED NURSING CENTER Alameda 1 1 0 0 1 <11 <11    
15 15 2022-01-15 20000028 020000028-berkeley-pines-skilled-nursing-center BERKELEY PINES SKILLED NURSING CENTER Alameda 1 20 0 1 1 <11     <11
16 16 2022-01-15 20000029 020000029-bethesda-home BETHESDA HOME Alameda 20 29 0 1 1       <11
17 17 2022-01-15 20000048 020000048-chaparral-house CHAPARRAL HOUSE Alameda 14 1 0 0 1   <11    
18 18 2022-01-15 630015174 630015174-creekview-skilled-nursing CREEKVIEW SKILLED NURSING Alameda 58 19 0 1 1       <11
19 19 2022-01-15 20000053 020000053-crestwood-manor-fremont CRESTWOOD MANOR - FREMONT Alameda 64 103 1 1 1     <11 <11
20 20 2022-01-15 20000129 020000129-crestwood-treatment-center CRESTWOOD TREATMENT CENTER Alameda 32 25 0 0 1        
21 21 2022-01-15 20000087 020000087-crown-bay-nursing-rehabilitation-center CROWN BAY NURSING & REHABILITATION CENTER Alameda 1 1 0 20 1 <11 <11    
22 22 2022-01-15 20000133 020000133-driftwood-healthcare-center-hayward DRIFTWOOD HEALTHCARE CENTER - HAYWARD Alameda 42 36 0 1 1       <11
23 23 2022-01-15 20000116 020000116-east-bay-post-acute EAST BAY POST-ACUTE Alameda 45 41 0 1 1       <11
24 24 2022-01-15 20000128 020000128-elmwood-care-center ELMWOOD CARE CENTER Alameda 31 59 0 1 1       <11
25 25 2022-01-15 20000093 020000093-excell-health-care-center EXCELL HEALTH CARE CENTER Alameda 52 83 0 1 1       <11
26 26 2022-01-15 20000132 020000132-fremont-healthcare-center FREMONT HEALTHCARE CENTER Alameda 26 50 0 1 1       <11
27 27 2022-01-15 20000124 020000124-fruitvale-healthcare-center FRUITVALE HEALTHCARE CENTER Alameda 81 129 0 13 1        
28 28 2022-01-15 20000125 020000125-garfield-neurobehavioral-center GARFIELD NEUROBEHAVIORAL CENTER Alameda 59 52 0 1 1       <11
29 29 2022-01-15 20000123 020000123-hayward-convalescent-hospital HAYWARD CONVALESCENT HOSPITAL Alameda 34 28 0 1 1       <11
30 30 2022-01-15 20000039 020000039-hayward-healthcare-wellness-center HAYWARD HEALTHCARE & WELLNESS CENTER Alameda 52 60 1 1 1     <11 <11
31 31 2022-01-15 20000047 020000047-hayward-hills-health-care-center HAYWARD HILLS HEALTH CARE CENTER Alameda 25 90 0 12 1        
32 32 2022-01-15 20000111 020000111-jones-convalescent-hospital JONES CONVALESCENT HOSPITAL Alameda 13 1 0 0 1   <11    
33 33 2022-01-15 20000042 020000042-kaiser-permanente-post-acute-care-center KAISER PERMANENTE POST-ACUTE CARE CENTER Alameda 106 24 1 1 1     <11 <11
34 34 2022-01-15 20000112 020000112-kyakameena-care-center KYAKAMEENA CARE CENTER Alameda 20 1 0 0 1   <11    
35 35 2022-01-15 20000110 020000110-lake-merritt-healthcare-center-llc LAKE MERRITT HEALTHCARE CENTER LLC Alameda 38 43 0 1 1       <11
36 36 2022-01-15 20000114 020000114-lake-park-retirement-residence LAKE PARK RETIREMENT RESIDENCE Alameda 1 0 0 0 1 <11      
37 37 2022-01-15 20000104 020000104-marina-garden-nursing-center MARINA GARDEN NURSING CENTER Alameda 1 15 0 0 1 <11      
38 38 2022-01-15 20000040 020000040-masonic-home MASONIC HOME Alameda 24 1 0 1 1   <11   <11
39 39 2022-01-15 20000099 020000099-mcclure-post-acute MCCLURE POST ACUTE Alameda 17 1 0 0 1   <11    
40 40 2022-01-15 20000079 020000079-medical-hill-healthcare-center MEDICAL HILL HEALTHCARE CENTER Alameda 43 52 0 0 1        
41 41 2022-01-15 20000100 020000100-mercy-retirement-care-center MERCY RETIREMENT & CARE CENTER Alameda 29 23 0 12 1        
42 42 2022-01-15 20000808 020000808-morton-bakar-center MORTON BAKAR CENTER Alameda 40 48 0 1 1       <11
43 43 2022-01-15 20000101 020000101-niles-canyon-post-acute NILES CANYON POST ACUTE Alameda 22 36 0 1 1       <11
44 44 2022-01-15 20000115 020000115-oakland-healthcare-wellness-center OAKLAND HEALTHCARE & WELLNESS CENTER Alameda 74 97 0 1 1       <11
45 45 2022-01-15 20000880 020000880-oakland-heights-nursing-and-rehabilitation OAKLAND HEIGHTS NURSING AND REHABILITATION Alameda 13 1 0 0 1   <11    
46 46 2022-01-15 630014635 630014635-park-bridge-rehabilitation-and-wellness-center PARK BRIDGE REHABILITATION AND WELLNESS CENTER Alameda 69 97 0 1 1       <11
47 47 2022-01-15 20000094 020000094-park-central-care-and-rehabilitation-center PARK CENTRAL CARE AND REHABILITATION CENTER Alameda 13 1 0 0 1   <11    
48 48 2022-01-15 20000090 020000090-parkview-healthcare-center PARKVIEW HEALTHCARE CENTER Alameda 46 113 1 18 1     <11  
49 49 2022-01-15 20000091 020000091-piedmont-gardens-health-facility PIEDMONT GARDENS HEALTH FACILITY Alameda 21 23 0 1 1       <11
50 50 2022-01-15 140000086 140000086-pleasanton-nursing-and-rehabilitation-center PLEASANTON NURSING AND REHABILITATION CENTER Alameda 76 61 1 12 1     <11  
51 51 2022-01-15 20000054 020000054-princeton-manor-healthcare-center-llc PRINCETON MANOR HEALTHCARE CENTER, LLC Alameda 37 55 0 1 1       <11
52 52 2022-01-15 20000276 020000276-redwood-convalescent-hospital-inc REDWOOD CONVALESCENT HOSPITAL, INC. Alameda 26 24 0 1 1       <11
53 53 2022-01-15 20000119 020000119-redwood-healthcare-center-llc REDWOOD HEALTHCARE CENTER LLC Alameda 23 30 0 1 1       <11
54 54 2022-01-15 20000077 020000077-san-leandro-healthcare-center SAN LEANDRO HEALTHCARE CENTER Alameda 31 32 0 1 1       <11
55 55 2022-01-15 20000074 020000074-serenethos-care-center-llc SERENETHOS CARE CENTER, LLC Alameda 17 29 0 1 1       <11
56 56 2022-01-15 20000005 020000005-st-anthony-care-center ST ANTHONY CARE CENTER Alameda 1 1 0 0 1 <11 <11    
57 57 2022-01-15 20000076 020000076-st-francis-healthcare-center ST FRANCIS HEALTHCARE CENTER Alameda 14 33 0 1 1       <11
58 58 2022-01-15 20000068 020000068-st-john-kronstadt-convalescent-center ST JOHN KRONSTADT CONVALESCENT CENTER Alameda 14 0 0 0 1        
59 59 2022-01-15 20000064 020000064-st-pauls-towers ST PAULS TOWERS Alameda 1 0 0 0 1 <11      
60 60 2022-01-15 20000037 020000037-st-patrick-s-post-acute ST. PATRICK'S POST ACUTE Alameda 35 50 0 19 1        
61 61 2022-01-15 630014957 630014957-stratford-villa-post-acute STRATFORD VILLA POST-ACUTE Alameda 15 26 0 1 1       <11
62 62 2022-01-15 20000274 020000274-the-rehabilitation-center-of-oakland THE REHABILITATION CENTER OF OAKLAND Alameda 32 37 0 1 1       <11
63 63 2022-01-15 140000122 140000122-the-vineyards-healthcare-center THE VINEYARDS HEALTHCARE CENTER Alameda 46 55 0 1 1       <11
64 64 2022-01-15 140000626 140000626-valley-memorial-hospital-d-p-snf VALLEY MEMORIAL HOSPITAL D/P SNF Alameda 0 0 0 0 1        
65 65 2022-01-15 20000066 020000066-valley-pointe-nursing-rehabilitation-center VALLEY POINTE NURSING & REHABILITATION CENTER Alameda 38 49 0 1 1       <11
66 66 2022-01-15 20000019 020000019-vista-post-acute VISTA POST ACUTE Alameda 49 64 0 1 1       <11
67 67 2022-01-15 20000275 020000275-washington-center WASHINGTON CENTER Alameda 50 34 0 1 1       <11
68 68 2022-01-15 20000065 020000065-we-care-skilled-nursing-facility WE CARE SKILLED NURSING FACILITY Alameda 1 1 0 0 1 <11 <11    
69 69 2022-01-15 20000020 020000020-windsor-country-drive-care-center WINDSOR COUNTRY DRIVE CARE CENTER Alameda 83 97 0 1 1       <11
70 70 2022-01-15 20000103 020000103-windsor-gardens-care-center-of-hayward WINDSOR GARDENS CARE CENTER OF HAYWARD Alameda 43 58 0 1 1       <11
71 71 2022-01-15 20000277 020000277-windsor-healthcare-center-of-oakland WINDSOR HEALTHCARE CENTER OF OAKLAND Alameda 74 93 0 1 1       <11
72 72 2022-01-15 20000036 020000036-windsor-park-care-center-of-fremont WINDSOR PARK CARE CENTER OF FREMONT Alameda 36 37 0 1 1       <11
73 73 2022-01-15 20000071 020000071-windsor-post-acute-care-center-of-hayward WINDSOR POST-ACUTE CARE CENTER OF HAYWARD Alameda 75 89 0 1 1       <11
74 74 2022-01-15 30000074 030000074-kit-carson-nursing-rehabilitation-center KIT CARSON NURSING & REHABILITATION CENTER Amador 39 67 0 17 5        
75 75 2022-01-15 230000255 230000255-arbor-post-acute ARBOR POST ACUTE Butte 77 130 0 18 7        
76 76 2022-01-15 230000546 230000546-california-park-rehabilitation-hospital CALIFORNIA PARK REHABILITATION HOSPITAL Butte 34 1 0 1 7   <11   <11
77 77 2022-01-15 230000802 230000802-country-crest-post-acute COUNTRY CREST POST ACUTE Butte 31 16 0 1 7       <11
78 78 2022-01-15 230000327 230000327-orchard-hospital-d-p-snf ORCHARD HOSPITAL D/P SNF Butte 46 48 0 13 7        
79 79 2022-01-15 230000221 230000221-oroville-hospital-post-acute-center OROVILLE HOSPITAL POST-ACUTE CENTER Butte 105 141 0 1 7       <11
80 80 2022-01-15 230000036 230000036-riverside-convalescent-hospital RIVERSIDE CONVALESCENT HOSPITAL Butte 85 90 0 13 7        
81 81 2022-01-15 230000037 230000037-shadowbrook-post-acute SHADOWBROOK POST ACUTE Butte 13 33 0 1 7       <11
82 82 2022-01-15 230000025 230000025-windsor-chico-care-center WINDSOR CHICO CARE CENTER Butte 29 46 0 1 7       <11
83 83 2022-01-15 230000029 230000029-windsor-chico-creek-care-and-rehabilitation-center WINDSOR CHICO CREEK CARE AND REHABILITATION CENTER Butte 49 78 0 1 7       <11
84 84 2022-01-15 30000012 030000012-avalon-health-care-san-andreas AVALON HEALTH CARE - SAN ANDREAS Calaveras 39 71 0 1 9       <11
85 85 2022-01-15 230000424 230000424-colusa-medical-center-snf COLUSA MEDICAL CENTER - SNF Colusa 21 26 0 1 11       <11
86 86 2022-01-15 230000283 230000283-valley-west-post-acute VALLEY WEST POST ACUTE Colusa 59 32 0 1 11       <11
87 87 2022-01-15 140000574 140000574-alhambra-convalescent-hospital ALHAMBRA CONVALESCENT HOSPITAL Contra Costa 18 11 0 1 13       <11
88 88 2022-01-15 140000023 140000023-bayberry-skilled-nursing-healthcare-center BAYBERRY SKILLED NURSING & HEALTHCARE CENTER Contra Costa 71 80 0 1 13       <11
89 89 2022-01-15 140000138 140000138-creekside-healthcare-center CREEKSIDE HEALTHCARE CENTER Contra Costa 34 1 0 0 13   <11    
90 90 2022-01-15 140000130 140000130-danville-post-acute-rehab DANVILLE POST-ACUTE REHAB Contra Costa 24 19 0 1 13       <11
91 91 2022-01-15 140000003 140000003-delta-view-post-acute DELTA VIEW POST ACUTE Contra Costa 36 60 0 1 13       <11
92 92 2022-01-15 140000564 140000564-diamond-ridge-healthcare-center DIAMOND RIDGE HEALTHCARE CENTER Contra Costa 36 26 0 1 13       <11
93 93 2022-01-15 140000038 140000038-greenridge-post-acute GREENRIDGE POST ACUTE Contra Costa 11 1 0 0 13   <11    
94 94 2022-01-15 140000051 140000051-la-casa-via-transitional-care-center LA CASA VIA TRANSITIONAL CARE CENTER Contra Costa 18 30 0 0 13        
95 95 2022-01-15 140000102 140000102-legacy-post-acute-care LEGACY POST ACUTE CARE Contra Costa 66 86 0 1 13       <11
96 96 2022-01-15 140000105 140000105-lone-tree-post-acute LONE TREE POST ACUTE Contra Costa 31 45 0 1 13       <11
97 97 2022-01-15 140000745 140000745-manorcare-health-services-rossmoor MANORCARE HEALTH SERVICES - ROSSMOOR Contra Costa 25 63 0 1 13       <11
98 98 2022-01-15 140001126 140001126-manorcare-health-services-tice-valley MANORCARE HEALTH SERVICES - TICE VALLEY Contra Costa 69 125 0 21 13        
99 99 2022-01-15 140000106 140000106-martinez-convalescent-hospital MARTINEZ CONVALESCENT HOSPITAL Contra Costa 1 1 1 1 13 <11 <11 <11 <11
100 100 2022-01-15 140000081 140000081-moraga-post-acute MORAGA POST ACUTE Contra Costa 20 40 0 0 13        

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "cdph-skilled-nursing-facilities" (
   [date] TEXT,
   [id] INTEGER,
   [slug] 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 1259.646ms · Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README