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 2020-05-07

✎ 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
755824 755824 2020-05-07 140000321 140000321-alameda-county-medical-center-d-p-snf ALAMEDA COUNTY MEDICAL CENTER D/P SNF Alameda 0 0 0 0 1        
755825 755825 2020-05-07 20000043 020000043-alameda-healthcare-wellness-center ALAMEDA HEALTHCARE & WELLNESS CENTER Alameda 1 0 0 0 1 <11      
755826 755826 2020-05-07 630011864 630011864-alameda-hospital-southshore-convalescent ALAMEDA HOSPITAL - SOUTHSHORE CONVALESCENT Alameda 0 0 0 0 1        
755827 755827 2020-05-07 140000686 140000686-alameda-hospital-d-p-snf ALAMEDA HOSPITAL D/P SNF Alameda 0 0 0 0 1        
755828 755828 2020-05-07 630013891 630013891-all-saint-s-maubert ALL SAINT'S MAUBERT Alameda 0 0 0 0 1        
755829 755829 2020-05-07 20000070 020000070-all-saints-subacute-transitional-care ALL SAINTS SUBACUTE & TRANSITIONAL CARE Alameda 0 0 0 0 1        
755830 755830 2020-05-07 20000010 020000010-ashby-care-center ASHBY CARE CENTER Alameda 0 0 0 0 1        
755831 755831 2020-05-07 20000015 020000015-bancroft-healthcare-center BANCROFT HEALTHCARE CENTER Alameda 0 0 0 0 1        
755832 755832 2020-05-07 20000135 020000135-bay-area-healthcare-center BAY AREA HEALTHCARE CENTER Alameda 0 1 0 0 1   <11    
755833 755833 2020-05-07 20000026 020000026-bay-view-rehabilitation-hospital-llc BAY VIEW REHABILITATION HOSPITAL, LLC Alameda 0 0 0 0 1        
755834 755834 2020-05-07 20000060 020000060-baypoint-healthcare-center BAYPOINT HEALTHCARE CENTER Alameda 0 0 0 0 1        
755835 755835 2020-05-07 630011713 630011713-baywood-court-health-center BAYWOOD COURT HEALTH CENTER Alameda 1 0 0 0 1 <11      
755836 755836 2020-05-07 20001250 020001250-bellaken-skilled-nursing-center BELLAKEN SKILLED NURSING CENTER Alameda 0 0 0 0 1        
755837 755837 2020-05-07 20000028 020000028-berkeley-pines-skilled-nursing-center BERKELEY PINES SKILLED NURSING CENTER Alameda 0 0 0 0 1        
755838 755838 2020-05-07 20000029 020000029-bethesda-home BETHESDA HOME Alameda 0 0 0 0 1        
755839 755839 2020-05-07 20000048 020000048-chaparral-house CHAPARRAL HOUSE Alameda 0 0 0 0 1        
755840 755840 2020-05-07 630015174 630015174-creekview-skilled-nursing CREEKVIEW SKILLED NURSING Alameda 1 0 0 0 1 <11      
755841 755841 2020-05-07 20000053 020000053-crestwood-manor-fremont CRESTWOOD MANOR - FREMONT Alameda 1 0 0 0 1 <11      
755842 755842 2020-05-07 20000129 020000129-crestwood-treatment-center CRESTWOOD TREATMENT CENTER Alameda 0 0 0 0 1        
755843 755843 2020-05-07 20000087 020000087-crown-bay-nursing-rehabilitation-center CROWN BAY NURSING & REHABILITATION CENTER Alameda 0 0 0 0 1        
755844 755844 2020-05-07 20000133 020000133-driftwood-healthcare-center-hayward DRIFTWOOD HEALTHCARE CENTER - HAYWARD Alameda 11 25 0 1 1       <11
755845 755845 2020-05-07 20000116 020000116-east-bay-post-acute EAST BAY POST-ACUTE Alameda 33 32 0 1 1       <11
755846 755846 2020-05-07 20000128 020000128-elmwood-care-center ELMWOOD CARE CENTER Alameda 0 0 0 0 1        
755847 755847 2020-05-07 20000093 020000093-excell-health-care-center EXCELL HEALTH CARE CENTER Alameda 19 40 0 1 1       <11
755848 755848 2020-05-07 20000132 020000132-fremont-healthcare-center FREMONT HEALTHCARE CENTER Alameda 1 1 0 0 1 <11 <11    
755849 755849 2020-05-07 20000124 020000124-fruitvale-healthcare-center FRUITVALE HEALTHCARE CENTER Alameda 0 0 0 0 1        
755850 755850 2020-05-07 20000125 020000125-garfield-neurobehavioral-center GARFIELD NEUROBEHAVIORAL CENTER Alameda 1 0 0 0 1 <11      
755851 755851 2020-05-07 20000037 020000037-gateway-care-rehabilitation-center GATEWAY CARE & REHABILITATION CENTER Alameda 28 49 0 17 1        
755852 755852 2020-05-07 20000123 020000123-hayward-convalescent-hospital HAYWARD CONVALESCENT HOSPITAL Alameda 0 0 0 0 1        
755853 755853 2020-05-07 20000039 020000039-hayward-healthcare-wellness-center HAYWARD HEALTHCARE & WELLNESS CENTER Alameda 1 0 0 0 1 <11      
755854 755854 2020-05-07 20000047 020000047-hayward-hills-health-care-center HAYWARD HILLS HEALTH CARE CENTER Alameda 0 0 0 0 1        
755855 755855 2020-05-07 20000101 020000101-hillside-senior-care HILLSIDE SENIOR CARE Alameda 0 1 0 1 1   <11   <11
755856 755856 2020-05-07 20000111 020000111-jones-convalescent-hospital JONES CONVALESCENT HOSPITAL Alameda 0 0 0 0 1        
755857 755857 2020-05-07 20000042 020000042-kaiser-permanente-post-acute-care-center KAISER PERMANENTE POST-ACUTE CARE CENTER Alameda 1 1 0 0 1 <11 <11    
755858 755858 2020-05-07 20000112 020000112-kyakameena-care-center KYAKAMEENA CARE CENTER Alameda 0 0 0 0 1        
755859 755859 2020-05-07 20000110 020000110-lake-merritt-healthcare-center-llc LAKE MERRITT HEALTHCARE CENTER LLC Alameda 0 0 0 0 1        
755860 755860 2020-05-07 20000114 020000114-lake-park-retirement-residence LAKE PARK RETIREMENT RESIDENCE Alameda 0 0 0 0 1        
755861 755861 2020-05-07 20000104 020000104-marina-garden-nursing-center MARINA GARDEN NURSING CENTER Alameda 0 0 0 0 1        
755862 755862 2020-05-07 20000040 020000040-masonic-home MASONIC HOME Alameda 0 0 0 0 1        
755863 755863 2020-05-07 20000099 020000099-mcclure-post-acute MCCLURE POST ACUTE Alameda 0 0 0 0 1        
755864 755864 2020-05-07 20000079 020000079-medical-hill-healthcare-center MEDICAL HILL HEALTHCARE CENTER Alameda 0 0 0 0 1        
755865 755865 2020-05-07 20000100 020000100-mercy-retirement-care-center MERCY RETIREMENT & CARE CENTER Alameda 1 1 0 0 1 <11 <11    
755866 755866 2020-05-07 630014957 630014957-mocho-park-care-center MOCHO PARK CARE CENTER Alameda 0 0 0 0 1        
755867 755867 2020-05-07 20000808 020000808-morton-bakar-center MORTON BAKAR CENTER Alameda 0 0 0 0 1        
755868 755868 2020-05-07 20000115 020000115-oakland-healthcare-wellness-center OAKLAND HEALTHCARE & WELLNESS CENTER Alameda 0 0 0 0 1        
755869 755869 2020-05-07 20000880 020000880-oakland-heights-nursing-and-rehabilitation OAKLAND HEIGHTS NURSING AND REHABILITATION Alameda 0 0 0 0 1        
755870 755870 2020-05-07 630014635 630014635-park-bridge-rehabilitation-and-wellness-center PARK BRIDGE REHABILITATION AND WELLNESS CENTER Alameda 1 0 0 0 1 <11      
755871 755871 2020-05-07 20000094 020000094-park-central-care-and-rehabilitation-center PARK CENTRAL CARE AND REHABILITATION CENTER Alameda 0 0 0 0 1        
755872 755872 2020-05-07 20000090 020000090-parkview-healthcare-center PARKVIEW HEALTHCARE CENTER Alameda 1 0 0 0 1 <11      
755873 755873 2020-05-07 20000091 020000091-piedmont-gardens-health-facility PIEDMONT GARDENS HEALTH FACILITY Alameda 0 0 0 0 1        
755874 755874 2020-05-07 140000086 140000086-pleasanton-nursing-and-rehabilitation-center PLEASANTON NURSING AND REHABILITATION CENTER Alameda 0 0 0 0 1        
755875 755875 2020-05-07 20000054 020000054-princeton-manor-healthcare-center-llc PRINCETON MANOR HEALTHCARE CENTER, LLC Alameda 0 0 0 0 1        
755876 755876 2020-05-07 20000276 020000276-redwood-convalescent-hospital-inc REDWOOD CONVALESCENT HOSPITAL, INC. Alameda 1 1 0 0 1 <11 <11    
755877 755877 2020-05-07 20000119 020000119-redwood-healthcare-center-llc REDWOOD HEALTHCARE CENTER LLC Alameda 14 26 0 1 1       <11
755878 755878 2020-05-07 20000077 020000077-san-leandro-healthcare-center SAN LEANDRO HEALTHCARE CENTER Alameda 1 1 0 1 1 <11 <11   <11
755879 755879 2020-05-07 140001291 140001291-silver-oak-manor SILVER OAK MANOR Alameda 0 0 0 0 1        
755880 755880 2020-05-07 20000005 020000005-st-anthony-care-center ST ANTHONY CARE CENTER Alameda 0 0 0 0 1        
755881 755881 2020-05-07 20000074 020000074-st-christopher-convalescent-hospital ST CHRISTOPHER CONVALESCENT HOSPITAL Alameda 0 0 0 0 1        
755882 755882 2020-05-07 20000076 020000076-st-francis-healthcare-center ST FRANCIS HEALTHCARE CENTER Alameda 0 0 0 0 1        
755883 755883 2020-05-07 20000068 020000068-st-john-kronstadt-convalescent-center ST JOHN KRONSTADT CONVALESCENT CENTER Alameda 0 0 0 0 1        
755884 755884 2020-05-07 20000064 020000064-st-pauls-towers ST PAULS TOWERS Alameda 0 0 0 0 1        
755885 755885 2020-05-07 20000274 020000274-the-rehabilitation-center-of-oakland THE REHABILITATION CENTER OF OAKLAND Alameda 0 0 0 0 1        
755886 755886 2020-05-07 140000122 140000122-the-vineyards-healthcare-center THE VINEYARDS HEALTHCARE CENTER Alameda 0 0 0 0 1        
755887 755887 2020-05-07 140000626 140000626-valley-memorial-hospital-d-p-snf VALLEY MEMORIAL HOSPITAL D/P SNF Alameda 0 0 0 0 1        
755888 755888 2020-05-07 20000066 020000066-valley-pointe-nursing-rehabilitation-center VALLEY POINTE NURSING & REHABILITATION CENTER Alameda 0 0 0 0 1        
755889 755889 2020-05-07 20000019 020000019-vista-post-acute VISTA POST ACUTE Alameda 0 0 0 0 1        
755890 755890 2020-05-07 20000275 020000275-washington-center WASHINGTON CENTER Alameda 1 0 0 0 1 <11      
755891 755891 2020-05-07 20000065 020000065-we-care-skilled-nursing-facility WE CARE SKILLED NURSING FACILITY Alameda 0 0 0 0 1        
755892 755892 2020-05-07 20000020 020000020-windsor-country-drive-care-center WINDSOR COUNTRY DRIVE CARE CENTER Alameda 0 0 0 0 1        
755893 755893 2020-05-07 20000103 020000103-windsor-gardens-care-center-of-hayward WINDSOR GARDENS CARE CENTER OF HAYWARD Alameda 0 0 0 0 1        
755894 755894 2020-05-07 20000277 020000277-windsor-healthcare-center-of-oakland WINDSOR HEALTHCARE CENTER OF OAKLAND Alameda 1 0 0 0 1 <11      
755895 755895 2020-05-07 20000036 020000036-windsor-park-care-center-of-fremont WINDSOR PARK CARE CENTER OF FREMONT Alameda 0 0 0 0 1        
755896 755896 2020-05-07 20000071 020000071-windsor-post-acute-care-center-of-hayward WINDSOR POST-ACUTE CARE CENTER OF HAYWARD Alameda 19 23 0 1 1       <11
755897 755897 2020-05-07 30000074 030000074-kit-carson-nursing-rehabilitation-center KIT CARSON NURSING & REHABILITATION CENTER Amador 0 0 0 0 5        
755898 755898 2020-05-07 230000255 230000255-arbor-post-acute ARBOR POST ACUTE Butte 0 0 0 0 7        
755899 755899 2020-05-07 230000546 230000546-california-park-rehabilitation-hospital CALIFORNIA PARK REHABILITATION HOSPITAL Butte 0 0 0 0 7        
755900 755900 2020-05-07 230000802 230000802-country-crest-post-acute COUNTRY CREST POST ACUTE Butte 0 0 0 0 7        
755901 755901 2020-05-07 230000327 230000327-orchard-hospital-d-p-snf ORCHARD HOSPITAL D/P SNF Butte 0 0 0 0 7        
755902 755902 2020-05-07 230000221 230000221-oroville-hospital-post-acute-center OROVILLE HOSPITAL POST-ACUTE CENTER Butte 0 0 0 0 7        
755903 755903 2020-05-07 230000036 230000036-riverside-convalescent-hospital RIVERSIDE CONVALESCENT HOSPITAL Butte 0 0 0 0 7        
755904 755904 2020-05-07 230000037 230000037-shadowbrook-post-acute SHADOWBROOK POST ACUTE Butte 0 0 0 0 7        
755905 755905 2020-05-07 230000025 230000025-windsor-chico-care-center WINDSOR CHICO CARE CENTER Butte 0 0 0 0 7        
755906 755906 2020-05-07 230000029 230000029-windsor-chico-creek-care-and-rehabilitation-center WINDSOR CHICO CREEK CARE AND REHABILITATION CENTER Butte 0 0 0 0 7        
755907 755907 2020-05-07 30000012 030000012-avalon-health-care-san-andreas AVALON HEALTH CARE - SAN ANDREAS Calaveras 0 0 0 0 9        
755908 755908 2020-05-07 230000424 230000424-colusa-medical-center-snf COLUSA MEDICAL CENTER - SNF Colusa 0 0 0 0 11        
755909 755909 2020-05-07 230000283 230000283-valley-west-post-acute VALLEY WEST POST ACUTE Colusa 0 0 0 0 11        
755910 755910 2020-05-07 140000574 140000574-alhambra-convalescent-hospital ALHAMBRA CONVALESCENT HOSPITAL Contra Costa 0 0 0 0 13        
755911 755911 2020-05-07 140000003 140000003-antioch-convalescent-hospital ANTIOCH CONVALESCENT HOSPITAL Contra Costa 0 0 0 0 13        
755912 755912 2020-05-07 140000023 140000023-bayberry-skilled-nursing-healthcare-center BAYBERRY SKILLED NURSING & HEALTHCARE CENTER Contra Costa 0 0 0 0 13        
755913 755913 2020-05-07 140000138 140000138-creekside-healthcare-center CREEKSIDE HEALTHCARE CENTER Contra Costa 0 0 0 0 13        
755914 755914 2020-05-07 140000130 140000130-danville-post-acute-rehab DANVILLE POST-ACUTE REHAB Contra Costa 0 0 0 0 13        
755915 755915 2020-05-07 140000564 140000564-diamond-ridge-healthcare-center DIAMOND RIDGE HEALTHCARE CENTER Contra Costa 0 0 0 0 13        
755916 755916 2020-05-07 140000038 140000038-greenridge-senior-care GREENRIDGE SENIOR CARE Contra Costa 0 0 0 0 13        
755917 755917 2020-05-07 140000051 140000051-la-casa-via-transitional-care-center LA CASA VIA TRANSITIONAL CARE CENTER Contra Costa 0 0 0 0 13        
755918 755918 2020-05-07 140000102 140000102-legacy-nursing-and-rehabilitation-center LEGACY NURSING AND REHABILITATION CENTER Contra Costa 0 0 0 0 13        
755919 755919 2020-05-07 140000105 140000105-lone-tree-convalescent-hospital LONE TREE CONVALESCENT HOSPITAL Contra Costa 0 0 0 0 13        
755920 755920 2020-05-07 140001126 140001126-manor-care-health-services-tice-valley MANOR CARE HEALTH SERVICES-TICE VALLEY Contra Costa 0 0 0 0 13        
755921 755921 2020-05-07 140000745 140000745-manorcare-health-services-rossmoor MANORCARE HEALTH SERVICES - ROSSMOOR Contra Costa 0 0 0 0 13        
755922 755922 2020-05-07 140000106 140000106-martinez-convalescent-hospital MARTINEZ CONVALESCENT HOSPITAL Contra Costa 0 0 0 0 13        
755923 755923 2020-05-07 140000081 140000081-moraga-post-acute MORAGA POST ACUTE Contra Costa 0 0 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
);