cdph-skilled-nursing-facilities

Table actions

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.

1,224 rows where "date" is on date 2021-09-18

✎ View and edit SQL

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

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
145538 145538 2021-09-18 140000321 140000321-alameda-county-medical-center-d-p-snf ALAMEDA COUNTY MEDICAL CENTER D/P SNF Alameda 15 21 0 0 1        
145539 145539 2021-09-18 20000043 020000043-alameda-healthcare-wellness-center ALAMEDA HEALTHCARE & WELLNESS CENTER Alameda 45 85 0 1 1       <11
145540 145540 2021-09-18 630011864 630011864-alameda-hospital-southshore-convalescent ALAMEDA HOSPITAL - SOUTHSHORE CONVALESCENT Alameda 1 1 0 0 1 <11 <11    
145541 145541 2021-09-18 140000686 140000686-alameda-hospital-d-p-snf ALAMEDA HOSPITAL D/P SNF Alameda 1 0 0 0 1 <11      
145542 145542 2021-09-18 630013891 630013891-all-saint-s-maubert ALL SAINT'S MAUBERT Alameda 1 0 0 0 1 <11      
145543 145543 2021-09-18 20000070 020000070-all-saints-subacute-transitional-care ALL SAINTS SUBACUTE & TRANSITIONAL CARE Alameda 1 0 0 0 1 <11      
145544 145544 2021-09-18 20000010 020000010-ashby-care-center ASHBY CARE CENTER Alameda 0 0 0 0 1        
145545 145545 2021-09-18 140001291 140001291-avondale-villa-post-acute AVONDALE VILLA POST-ACUTE Alameda 16 22 0 1 1       <11
145546 145546 2021-09-18 20000015 020000015-bancroft-healthcare-center BANCROFT HEALTHCARE CENTER Alameda 1 0 0 0 1 <11      
145547 145547 2021-09-18 20000135 020000135-bay-area-healthcare-center BAY AREA HEALTHCARE CENTER Alameda 14 1 0 1 1   <11   <11
145548 145548 2021-09-18 20000026 020000026-bay-view-rehabilitation-hospital-llc BAY VIEW REHABILITATION HOSPITAL, LLC Alameda 60 137 0 1 1       <11
145549 145549 2021-09-18 20000060 020000060-baypoint-healthcare-center BAYPOINT HEALTHCARE CENTER Alameda 13 1 0 0 1   <11    
145550 145550 2021-09-18 630011713 630011713-baywood-court-health-center BAYWOOD COURT HEALTH CENTER Alameda 1 0 0 0 1 <11      
145551 145551 2021-09-18 20001250 020001250-bellaken-skilled-nursing-center BELLAKEN SKILLED NURSING CENTER Alameda 1 1 0 0 1 <11 <11    
145552 145552 2021-09-18 20000028 020000028-berkeley-pines-skilled-nursing-center BERKELEY PINES SKILLED NURSING CENTER Alameda 1 20 0 1 1 <11     <11
145553 145553 2021-09-18 20000029 020000029-bethesda-home BETHESDA HOME Alameda 19 29 0 1 1       <11
145554 145554 2021-09-18 20000048 020000048-chaparral-house CHAPARRAL HOUSE Alameda 1 1 0 0 1 <11 <11    
145555 145555 2021-09-18 630015174 630015174-creekview-skilled-nursing CREEKVIEW SKILLED NURSING Alameda 41 17 0 1 1       <11
145556 145556 2021-09-18 20000053 020000053-crestwood-manor-fremont CRESTWOOD MANOR - FREMONT Alameda 48 102 1 1 1     <11 <11
145557 145557 2021-09-18 20000129 020000129-crestwood-treatment-center CRESTWOOD TREATMENT CENTER Alameda 21 25 0 0 1        
145558 145558 2021-09-18 20000087 020000087-crown-bay-nursing-rehabilitation-center CROWN BAY NURSING & REHABILITATION CENTER Alameda 1 1 0 20 1 <11 <11    
145559 145559 2021-09-18 20000133 020000133-driftwood-healthcare-center-hayward DRIFTWOOD HEALTHCARE CENTER - HAYWARD Alameda 27 36 0 1 1       <11
145560 145560 2021-09-18 20000116 020000116-east-bay-post-acute EAST BAY POST-ACUTE Alameda 41 39 0 1 1       <11
145561 145561 2021-09-18 20000128 020000128-elmwood-care-center ELMWOOD CARE CENTER Alameda 26 55 0 1 1       <11
145562 145562 2021-09-18 20000093 020000093-excell-health-care-center EXCELL HEALTH CARE CENTER Alameda 31 64 0 1 1       <11
145563 145563 2021-09-18 20000132 020000132-fremont-healthcare-center FREMONT HEALTHCARE CENTER Alameda 13 48 0 1 1       <11
145564 145564 2021-09-18 20000124 020000124-fruitvale-healthcare-center FRUITVALE HEALTHCARE CENTER Alameda 77 128 0 13 1        
145565 145565 2021-09-18 20000125 020000125-garfield-neurobehavioral-center GARFIELD NEUROBEHAVIORAL CENTER Alameda 51 45 0 1 1       <11
145566 145566 2021-09-18 20000123 020000123-hayward-convalescent-hospital HAYWARD CONVALESCENT HOSPITAL Alameda 34 28 0 1 1       <11
145567 145567 2021-09-18 20000039 020000039-hayward-healthcare-wellness-center HAYWARD HEALTHCARE & WELLNESS CENTER Alameda 50 59 1 1 1     <11 <11
145568 145568 2021-09-18 20000047 020000047-hayward-hills-health-care-center HAYWARD HILLS HEALTH CARE CENTER Alameda 19 90 0 12 1        
145569 145569 2021-09-18 20000111 020000111-jones-convalescent-hospital JONES CONVALESCENT HOSPITAL Alameda 11 1 0 0 1   <11    
145570 145570 2021-09-18 20000042 020000042-kaiser-permanente-post-acute-care-center KAISER PERMANENTE POST-ACUTE CARE CENTER Alameda 66 21 1 1 1     <11 <11
145571 145571 2021-09-18 20000112 020000112-kyakameena-care-center KYAKAMEENA CARE CENTER Alameda 15 1 0 0 1   <11    
145572 145572 2021-09-18 20000110 020000110-lake-merritt-healthcare-center-llc LAKE MERRITT HEALTHCARE CENTER LLC Alameda 19 1 0 0 1   <11    
145573 145573 2021-09-18 20000114 020000114-lake-park-retirement-residence LAKE PARK RETIREMENT RESIDENCE Alameda 1 0 0 0 1 <11      
145574 145574 2021-09-18 20000104 020000104-marina-garden-nursing-center MARINA GARDEN NURSING CENTER Alameda 1 14 0 0 1 <11      
145575 145575 2021-09-18 20000040 020000040-masonic-home MASONIC HOME Alameda 20 1 0 1 1   <11   <11
145576 145576 2021-09-18 20000099 020000099-mcclure-post-acute MCCLURE POST ACUTE Alameda 12 1 0 0 1   <11    
145577 145577 2021-09-18 20000079 020000079-medical-hill-healthcare-center MEDICAL HILL HEALTHCARE CENTER Alameda 43 52 0 0 1        
145578 145578 2021-09-18 20000100 020000100-mercy-retirement-care-center MERCY RETIREMENT & CARE CENTER Alameda 23 21 0 12 1        
145579 145579 2021-09-18 20000808 020000808-morton-bakar-center MORTON BAKAR CENTER Alameda 37 48 0 1 1       <11
145580 145580 2021-09-18 20000101 020000101-niles-canyon-post-acute NILES CANYON POST ACUTE Alameda 22 36 0 1 1       <11
145581 145581 2021-09-18 20000115 020000115-oakland-healthcare-wellness-center OAKLAND HEALTHCARE & WELLNESS CENTER Alameda 56 88 0 1 1       <11
145582 145582 2021-09-18 20000880 020000880-oakland-heights-nursing-and-rehabilitation OAKLAND HEIGHTS NURSING AND REHABILITATION Alameda 1 0 0 0 1 <11      
145583 145583 2021-09-18 630014635 630014635-park-bridge-rehabilitation-and-wellness-center PARK BRIDGE REHABILITATION AND WELLNESS CENTER Alameda 59 91 0 1 1       <11
145584 145584 2021-09-18 20000094 020000094-park-central-care-and-rehabilitation-center PARK CENTRAL CARE AND REHABILITATION CENTER Alameda 1 1 0 0 1 <11 <11    
145585 145585 2021-09-18 20000090 020000090-parkview-healthcare-center PARKVIEW HEALTHCARE CENTER Alameda 36 111 1 18 1     <11  
145586 145586 2021-09-18 20000091 020000091-piedmont-gardens-health-facility PIEDMONT GARDENS HEALTH FACILITY Alameda 20 23 0 1 1       <11
145587 145587 2021-09-18 140000086 140000086-pleasanton-nursing-and-rehabilitation-center PLEASANTON NURSING AND REHABILITATION CENTER Alameda 67 52 1 12 1     <11  
145588 145588 2021-09-18 20000054 020000054-princeton-manor-healthcare-center-llc PRINCETON MANOR HEALTHCARE CENTER, LLC Alameda 27 32 0 1 1       <11
145589 145589 2021-09-18 20000276 020000276-redwood-convalescent-hospital-inc REDWOOD CONVALESCENT HOSPITAL, INC. Alameda 14 24 0 1 1       <11
145590 145590 2021-09-18 20000119 020000119-redwood-healthcare-center-llc REDWOOD HEALTHCARE CENTER LLC Alameda 23 30 0 1 1       <11
145591 145591 2021-09-18 20000077 020000077-san-leandro-healthcare-center SAN LEANDRO HEALTHCARE CENTER Alameda 30 32 0 1 1       <11
145592 145592 2021-09-18 20000074 020000074-serenethos-care-center-llc SERENETHOS CARE CENTER, LLC Alameda 16 29 0 1 1       <11
145593 145593 2021-09-18 20000005 020000005-st-anthony-care-center ST ANTHONY CARE CENTER Alameda 1 1 0 0 1 <11 <11    
145594 145594 2021-09-18 20000076 020000076-st-francis-healthcare-center ST FRANCIS HEALTHCARE CENTER Alameda 12 33 0 1 1       <11
145595 145595 2021-09-18 20000068 020000068-st-john-kronstadt-convalescent-center ST JOHN KRONSTADT CONVALESCENT CENTER Alameda 1 0 0 0 1 <11      
145596 145596 2021-09-18 20000064 020000064-st-pauls-towers ST PAULS TOWERS Alameda 1 0 0 0 1 <11      
145597 145597 2021-09-18 20000037 020000037-st-patrick-s-post-acute ST. PATRICK'S POST ACUTE Alameda 35 50 0 19 1        
145598 145598 2021-09-18 630014957 630014957-stratford-villa-post-acute STRATFORD VILLA POST-ACUTE Alameda 15 26 0 1 1       <11
145599 145599 2021-09-18 20000274 020000274-the-rehabilitation-center-of-oakland THE REHABILITATION CENTER OF OAKLAND Alameda 27 37 0 1 1       <11
145600 145600 2021-09-18 140000122 140000122-the-vineyards-healthcare-center THE VINEYARDS HEALTHCARE CENTER Alameda 40 54 0 1 1       <11
145601 145601 2021-09-18 140000626 140000626-valley-memorial-hospital-d-p-snf VALLEY MEMORIAL HOSPITAL D/P SNF Alameda 0 0 0 0 1        
145602 145602 2021-09-18 20000066 020000066-valley-pointe-nursing-rehabilitation-center VALLEY POINTE NURSING & REHABILITATION CENTER Alameda 26 32 0 1 1       <11
145603 145603 2021-09-18 20000019 020000019-vista-post-acute VISTA POST ACUTE Alameda 40 59 0 1 1       <11
145604 145604 2021-09-18 20000275 020000275-washington-center WASHINGTON CENTER Alameda 38 34 0 1 1       <11
145605 145605 2021-09-18 20000065 020000065-we-care-skilled-nursing-facility WE CARE SKILLED NURSING FACILITY Alameda 1 1 0 0 1 <11 <11    
145606 145606 2021-09-18 20000020 020000020-windsor-country-drive-care-center WINDSOR COUNTRY DRIVE CARE CENTER Alameda 75 94 0 1 1       <11
145607 145607 2021-09-18 20000103 020000103-windsor-gardens-care-center-of-hayward WINDSOR GARDENS CARE CENTER OF HAYWARD Alameda 38 57 0 1 1       <11
145608 145608 2021-09-18 20000277 020000277-windsor-healthcare-center-of-oakland WINDSOR HEALTHCARE CENTER OF OAKLAND Alameda 54 87 0 1 1       <11
145609 145609 2021-09-18 20000036 020000036-windsor-park-care-center-of-fremont WINDSOR PARK CARE CENTER OF FREMONT Alameda 29 37 0 1 1       <11
145610 145610 2021-09-18 20000071 020000071-windsor-post-acute-care-center-of-hayward WINDSOR POST-ACUTE CARE CENTER OF HAYWARD Alameda 67 87 0 1 1       <11
145611 145611 2021-09-18 30000074 030000074-kit-carson-nursing-rehabilitation-center KIT CARSON NURSING & REHABILITATION CENTER Amador 34 67 0 17 5        
145612 145612 2021-09-18 230000255 230000255-arbor-post-acute ARBOR POST ACUTE Butte 69 124 0 18 7        
145613 145613 2021-09-18 230000546 230000546-california-park-rehabilitation-hospital CALIFORNIA PARK REHABILITATION HOSPITAL Butte 28 1 0 1 7   <11   <11
145614 145614 2021-09-18 230000802 230000802-country-crest-post-acute COUNTRY CREST POST ACUTE Butte 19 1 0 0 7   <11    
145615 145615 2021-09-18 230000327 230000327-orchard-hospital-d-p-snf ORCHARD HOSPITAL D/P SNF Butte 39 48 0 13 7        
145616 145616 2021-09-18 230000221 230000221-oroville-hospital-post-acute-center OROVILLE HOSPITAL POST-ACUTE CENTER Butte 77 112 0 1 7       <11
145617 145617 2021-09-18 230000036 230000036-riverside-convalescent-hospital RIVERSIDE CONVALESCENT HOSPITAL Butte 75 87 0 13 7        
145618 145618 2021-09-18 230000037 230000037-shadowbrook-post-acute SHADOWBROOK POST ACUTE Butte 1 23 0 1 7 <11     <11
145619 145619 2021-09-18 230000025 230000025-windsor-chico-care-center WINDSOR CHICO CARE CENTER Butte 24 44 0 1 7       <11
145620 145620 2021-09-18 230000029 230000029-windsor-chico-creek-care-and-rehabilitation-center WINDSOR CHICO CREEK CARE AND REHABILITATION CENTER Butte 42 72 0 1 7       <11
145621 145621 2021-09-18 30000012 030000012-avalon-health-care-san-andreas AVALON HEALTH CARE - SAN ANDREAS Calaveras 27 61 0 1 9       <11
145622 145622 2021-09-18 230000424 230000424-colusa-medical-center-snf COLUSA MEDICAL CENTER - SNF Colusa 20 26 0 1 11       <11
145623 145623 2021-09-18 230000283 230000283-valley-west-post-acute VALLEY WEST POST ACUTE Colusa 59 32 0 1 11       <11
145624 145624 2021-09-18 140000574 140000574-alhambra-convalescent-hospital ALHAMBRA CONVALESCENT HOSPITAL Contra Costa 18 11 0 1 13       <11
145625 145625 2021-09-18 140000023 140000023-bayberry-skilled-nursing-healthcare-center BAYBERRY SKILLED NURSING & HEALTHCARE CENTER Contra Costa 48 66 0 1 13       <11
145626 145626 2021-09-18 140000138 140000138-creekside-healthcare-center CREEKSIDE HEALTHCARE CENTER Contra Costa 21 1 0 0 13   <11    
145627 145627 2021-09-18 140000130 140000130-danville-post-acute-rehab DANVILLE POST-ACUTE REHAB Contra Costa 16 12 0 1 13       <11
145628 145628 2021-09-18 140000003 140000003-delta-view-post-acute DELTA VIEW POST ACUTE Contra Costa 30 57 0 1 13       <11
145629 145629 2021-09-18 140000564 140000564-diamond-ridge-healthcare-center DIAMOND RIDGE HEALTHCARE CENTER Contra Costa 19 22 0 1 13       <11
145630 145630 2021-09-18 140000038 140000038-greenridge-post-acute GREENRIDGE POST ACUTE Contra Costa 11 1 0 0 13   <11    
145631 145631 2021-09-18 140000051 140000051-la-casa-via-transitional-care-center LA CASA VIA TRANSITIONAL CARE CENTER Contra Costa 1 30 0 0 13 <11      
145632 145632 2021-09-18 140000102 140000102-legacy-post-acute-care LEGACY POST ACUTE CARE Contra Costa 49 77 0 1 13       <11
145633 145633 2021-09-18 140000105 140000105-lone-tree-post-acute LONE TREE POST ACUTE Contra Costa 23 44 0 1 13       <11
145634 145634 2021-09-18 140000745 140000745-manorcare-health-services-rossmoor MANORCARE HEALTH SERVICES - ROSSMOOR Contra Costa 25 61 0 1 13       <11
145635 145635 2021-09-18 140001126 140001126-manorcare-health-services-tice-valley MANORCARE HEALTH SERVICES - TICE VALLEY Contra Costa 54 118 0 21 13        
145636 145636 2021-09-18 140000106 140000106-martinez-convalescent-hospital MARTINEZ CONVALESCENT HOSPITAL Contra Costa 1 1 1 1 13 <11 <11 <11 <11
145637 145637 2021-09-18 140000081 140000081-moraga-post-acute MORAGA POST ACUTE Contra Costa 18 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
);