cdph-skilled-nursing-facilities
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-04-27 sorted by staff_confirmed_cases
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
768064 | 768064 | 2020-04-27 | 140000321 | 140000321-alameda-county-medical-center-d-p-snf | ALAMEDA COUNTY MEDICAL CENTER D/P SNF | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768066 | 768066 | 2020-04-27 | 630011864 | 630011864-alameda-hospital-southshore-convalescent | ALAMEDA HOSPITAL - SOUTHSHORE CONVALESCENT | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768067 | 768067 | 2020-04-27 | 140000686 | 140000686-alameda-hospital-d-p-snf | ALAMEDA HOSPITAL D/P SNF | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768068 | 768068 | 2020-04-27 | 630013891 | 630013891-all-saint-s-maubert | ALL SAINT'S MAUBERT | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768069 | 768069 | 2020-04-27 | 20000070 | 020000070-all-saints-subacute-transitional-care | ALL SAINTS SUBACUTE & TRANSITIONAL CARE | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768070 | 768070 | 2020-04-27 | 20000010 | 020000010-ashby-care-center | ASHBY CARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768071 | 768071 | 2020-04-27 | 20000015 | 020000015-bancroft-healthcare-center | BANCROFT HEALTHCARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768072 | 768072 | 2020-04-27 | 20000135 | 020000135-bay-area-healthcare-center | BAY AREA HEALTHCARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768073 | 768073 | 2020-04-27 | 20000026 | 020000026-bay-view-rehabilitation-hospital-llc | BAY VIEW REHABILITATION HOSPITAL, LLC | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768074 | 768074 | 2020-04-27 | 20000060 | 020000060-baypoint-healthcare-center | BAYPOINT HEALTHCARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768076 | 768076 | 2020-04-27 | 20001250 | 020001250-bellaken-skilled-nursing-center | BELLAKEN SKILLED NURSING CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768077 | 768077 | 2020-04-27 | 20000028 | 020000028-berkeley-pines-skilled-nursing-center | BERKELEY PINES SKILLED NURSING CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768078 | 768078 | 2020-04-27 | 20000029 | 020000029-bethesda-home | BETHESDA HOME | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768079 | 768079 | 2020-04-27 | 20000048 | 020000048-chaparral-house | CHAPARRAL HOUSE | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768080 | 768080 | 2020-04-27 | 630015174 | 630015174-creekview-skilled-nursing | CREEKVIEW SKILLED NURSING | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768082 | 768082 | 2020-04-27 | 20000129 | 020000129-crestwood-treatment-center | CRESTWOOD TREATMENT CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768083 | 768083 | 2020-04-27 | 20000087 | 020000087-crown-bay-nursing-rehabilitation-center | CROWN BAY NURSING & REHABILITATION CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768086 | 768086 | 2020-04-27 | 20000128 | 020000128-elmwood-care-center | ELMWOOD CARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768088 | 768088 | 2020-04-27 | 20000132 | 020000132-fremont-healthcare-center | FREMONT HEALTHCARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768089 | 768089 | 2020-04-27 | 20000124 | 020000124-fruitvale-healthcare-center | FRUITVALE HEALTHCARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768092 | 768092 | 2020-04-27 | 20000123 | 020000123-hayward-convalescent-hospital | HAYWARD CONVALESCENT HOSPITAL | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768094 | 768094 | 2020-04-27 | 20000047 | 020000047-hayward-hills-health-care-center | HAYWARD HILLS HEALTH CARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768095 | 768095 | 2020-04-27 | 20000101 | 020000101-hillside-senior-care | HILLSIDE SENIOR CARE | Alameda | 0 | 1 | 0 | 1 | 1 | <11 | <11 | ||
768096 | 768096 | 2020-04-27 | 20000111 | 020000111-jones-convalescent-hospital | JONES CONVALESCENT HOSPITAL | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768098 | 768098 | 2020-04-27 | 20000112 | 020000112-kyakameena-care-center | KYAKAMEENA CARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768099 | 768099 | 2020-04-27 | 20000110 | 020000110-lake-merritt-healthcare-center-llc | LAKE MERRITT HEALTHCARE CENTER LLC | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768100 | 768100 | 2020-04-27 | 20000114 | 020000114-lake-park-retirement-residence | LAKE PARK RETIREMENT RESIDENCE | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768101 | 768101 | 2020-04-27 | 20000104 | 020000104-marina-garden-nursing-center | MARINA GARDEN NURSING CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768102 | 768102 | 2020-04-27 | 20000040 | 020000040-masonic-home | MASONIC HOME | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768103 | 768103 | 2020-04-27 | 20000099 | 020000099-mcclure-post-acute | MCCLURE POST ACUTE | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768104 | 768104 | 2020-04-27 | 20000079 | 020000079-medical-hill-healthcare-center | MEDICAL HILL HEALTHCARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768106 | 768106 | 2020-04-27 | 630014957 | 630014957-mocho-park-care-center | MOCHO PARK CARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768107 | 768107 | 2020-04-27 | 20000808 | 020000808-morton-bakar-center | MORTON BAKAR CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768108 | 768108 | 2020-04-27 | 20000115 | 020000115-oakland-healthcare-wellness-center | OAKLAND HEALTHCARE & WELLNESS CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768109 | 768109 | 2020-04-27 | 20000880 | 020000880-oakland-heights-nursing-and-rehabilitation | OAKLAND HEIGHTS NURSING AND REHABILITATION | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768111 | 768111 | 2020-04-27 | 20000094 | 020000094-park-central-care-and-rehabilitation-center | PARK CENTRAL CARE AND REHABILITATION CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768113 | 768113 | 2020-04-27 | 20000091 | 020000091-piedmont-gardens-health-facility | PIEDMONT GARDENS HEALTH FACILITY | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768114 | 768114 | 2020-04-27 | 140000086 | 140000086-pleasanton-nursing-and-rehabilitation-center | PLEASANTON NURSING AND REHABILITATION CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768115 | 768115 | 2020-04-27 | 20000054 | 020000054-princeton-manor-healthcare-center-llc | PRINCETON MANOR HEALTHCARE CENTER, LLC | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768119 | 768119 | 2020-04-27 | 140001291 | 140001291-silver-oak-manor | SILVER OAK MANOR | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768120 | 768120 | 2020-04-27 | 20000005 | 020000005-st-anthony-care-center | ST ANTHONY CARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768121 | 768121 | 2020-04-27 | 20000074 | 020000074-st-christopher-convalescent-hospital | ST CHRISTOPHER CONVALESCENT HOSPITAL | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768122 | 768122 | 2020-04-27 | 20000076 | 020000076-st-francis-healthcare-center | ST FRANCIS HEALTHCARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768123 | 768123 | 2020-04-27 | 20000068 | 020000068-st-john-kronstadt-convalescent-center | ST JOHN KRONSTADT CONVALESCENT CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768124 | 768124 | 2020-04-27 | 20000064 | 020000064-st-pauls-towers | ST PAULS TOWERS | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768125 | 768125 | 2020-04-27 | 20000274 | 020000274-the-rehabilitation-center-of-oakland | THE REHABILITATION CENTER OF OAKLAND | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768126 | 768126 | 2020-04-27 | 140000122 | 140000122-the-vineyards-healthcare-center | THE VINEYARDS HEALTHCARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768127 | 768127 | 2020-04-27 | 140000626 | 140000626-valley-memorial-hospital-d-p-snf | VALLEY MEMORIAL HOSPITAL D/P SNF | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768128 | 768128 | 2020-04-27 | 20000066 | 020000066-valley-pointe-nursing-rehabilitation-center | VALLEY POINTE NURSING & REHABILITATION CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768129 | 768129 | 2020-04-27 | 20000019 | 020000019-vista-post-acute | VISTA POST ACUTE | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768131 | 768131 | 2020-04-27 | 20000065 | 020000065-we-care-skilled-nursing-facility | WE CARE SKILLED NURSING FACILITY | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768132 | 768132 | 2020-04-27 | 20000020 | 020000020-windsor-country-drive-care-center | WINDSOR COUNTRY DRIVE CARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768133 | 768133 | 2020-04-27 | 20000103 | 020000103-windsor-gardens-care-center-of-hayward | WINDSOR GARDENS CARE CENTER OF HAYWARD | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768135 | 768135 | 2020-04-27 | 20000036 | 020000036-windsor-park-care-center-of-fremont | WINDSOR PARK CARE CENTER OF FREMONT | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
768137 | 768137 | 2020-04-27 | 30000074 | 030000074-kit-carson-nursing-rehabilitation-center | KIT CARSON NURSING & REHABILITATION CENTER | Amador | 0 | 0 | 0 | 0 | 5 | ||||
768138 | 768138 | 2020-04-27 | 230000255 | 230000255-arbor-post-acute | ARBOR POST ACUTE | Butte | 0 | 0 | 0 | 0 | 7 | ||||
768139 | 768139 | 2020-04-27 | 230000546 | 230000546-california-park-rehabilitation-hospital | CALIFORNIA PARK REHABILITATION HOSPITAL | Butte | 0 | 0 | 0 | 0 | 7 | ||||
768140 | 768140 | 2020-04-27 | 230000802 | 230000802-country-crest-post-acute | COUNTRY CREST POST ACUTE | Butte | 0 | 0 | 0 | 0 | 7 | ||||
768141 | 768141 | 2020-04-27 | 230000327 | 230000327-orchard-hospital-d-p-snf | ORCHARD HOSPITAL D/P SNF | Butte | 0 | 0 | 0 | 0 | 7 | ||||
768142 | 768142 | 2020-04-27 | 230000221 | 230000221-oroville-hospital-post-acute-center | OROVILLE HOSPITAL POST-ACUTE CENTER | Butte | 0 | 0 | 0 | 0 | 7 | ||||
768143 | 768143 | 2020-04-27 | 230000036 | 230000036-riverside-convalescent-hospital | RIVERSIDE CONVALESCENT HOSPITAL | Butte | 0 | 0 | 0 | 0 | 7 | ||||
768144 | 768144 | 2020-04-27 | 230000037 | 230000037-shadowbrook-post-acute | SHADOWBROOK POST ACUTE | Butte | 0 | 0 | 0 | 0 | 7 | ||||
768145 | 768145 | 2020-04-27 | 230000025 | 230000025-windsor-chico-care-center | WINDSOR CHICO CARE CENTER | Butte | 0 | 0 | 0 | 0 | 7 | ||||
768146 | 768146 | 2020-04-27 | 230000029 | 230000029-windsor-chico-creek-care-and-rehabilitation-center | WINDSOR CHICO CREEK CARE AND REHABILITATION CENTER | Butte | 0 | 0 | 0 | 0 | 7 | ||||
768147 | 768147 | 2020-04-27 | 30000012 | 030000012-avalon-health-care-san-andreas | AVALON HEALTH CARE - SAN ANDREAS | Calaveras | 0 | 0 | 0 | 0 | 9 | ||||
768148 | 768148 | 2020-04-27 | 230000424 | 230000424-colusa-medical-center-snf | COLUSA MEDICAL CENTER - SNF | Colusa | 0 | 0 | 0 | 0 | 11 | ||||
768149 | 768149 | 2020-04-27 | 230000283 | 230000283-valley-west-post-acute | VALLEY WEST POST ACUTE | Colusa | 0 | 0 | 0 | 0 | 11 | ||||
768150 | 768150 | 2020-04-27 | 140000574 | 140000574-alhambra-convalescent-hospital | ALHAMBRA CONVALESCENT HOSPITAL | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
768151 | 768151 | 2020-04-27 | 140000003 | 140000003-antioch-convalescent-hospital | ANTIOCH CONVALESCENT HOSPITAL | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
768152 | 768152 | 2020-04-27 | 140000023 | 140000023-bayberry-skilled-nursing-healthcare-center | BAYBERRY SKILLED NURSING & HEALTHCARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
768153 | 768153 | 2020-04-27 | 140000138 | 140000138-creekside-healthcare-center | CREEKSIDE HEALTHCARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
768154 | 768154 | 2020-04-27 | 140000130 | 140000130-danville-post-acute-rehab | DANVILLE POST-ACUTE REHAB | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
768155 | 768155 | 2020-04-27 | 140000564 | 140000564-diamond-ridge-healthcare-center | DIAMOND RIDGE HEALTHCARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
768156 | 768156 | 2020-04-27 | 140000038 | 140000038-greenridge-senior-care | GREENRIDGE SENIOR CARE | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
768157 | 768157 | 2020-04-27 | 140000051 | 140000051-la-casa-via-transitional-care-center | LA CASA VIA TRANSITIONAL CARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
768158 | 768158 | 2020-04-27 | 140000102 | 140000102-legacy-nursing-and-rehabilitation-center | LEGACY NURSING AND REHABILITATION CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
768159 | 768159 | 2020-04-27 | 140000105 | 140000105-lone-tree-convalescent-hospital | LONE TREE CONVALESCENT HOSPITAL | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
768160 | 768160 | 2020-04-27 | 140001126 | 140001126-manor-care-health-services-tice-valley | MANOR CARE HEALTH SERVICES-TICE VALLEY | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
768161 | 768161 | 2020-04-27 | 140000745 | 140000745-manorcare-health-services-rossmoor | MANORCARE HEALTH SERVICES - ROSSMOOR | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
768162 | 768162 | 2020-04-27 | 140000106 | 140000106-martinez-convalescent-hospital | MARTINEZ CONVALESCENT HOSPITAL | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
768163 | 768163 | 2020-04-27 | 140000081 | 140000081-moraga-post-acute | MORAGA POST ACUTE | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
768165 | 768165 | 2020-04-27 | 140000024 | 140000024-patterson-care-center | PATTERSON CARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
768166 | 768166 | 2020-04-27 | 140000962 | 140000962-pittsburg-skilled-nursing-center | PITTSBURG SKILLED NURSING CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
768167 | 768167 | 2020-04-27 | 140000096 | 140000096-pleasant-hill-post-acute | PLEASANT HILL POST ACUTE | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
768168 | 768168 | 2020-04-27 | 140000136 | 140000136-san-miguel-villa | SAN MIGUEL VILLA | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
768169 | 768169 | 2020-04-27 | 140000030 | 140000030-san-pablo-healthcare-wellness-center | SAN PABLO HEALTHCARE & WELLNESS CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
768170 | 768170 | 2020-04-27 | 140000885 | 140000885-san-ramon-regional-medical-center-d-p-snf | SAN RAMON REGIONAL MEDICAL CENTER D/P SNF | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
768171 | 768171 | 2020-04-27 | 140000396 | 140000396-shields-nursing-center | SHIELDS NURSING CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
768172 | 768172 | 2020-04-27 | 140000080 | 140000080-shields-richmond-nursing-center | SHIELDS RICHMOND NURSING CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
768173 | 768173 | 2020-04-27 | 140000733 | 140000733-stonebrook-healthcare-center | STONEBROOK HEALTHCARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
768174 | 768174 | 2020-04-27 | 140000078 | 140000078-tampico-terrace-care-center | TAMPICO TERRACE CARE CENTER | Contra Costa | 0 | 1 | 0 | 0 | 13 | <11 | |||
768175 | 768175 | 2020-04-27 | 140001185 | 140001185-the-reutlinger-community | THE REUTLINGER COMMUNITY | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
768176 | 768176 | 2020-04-27 | 140000061 | 140000061-vale-healthcare-center | VALE HEALTHCARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
768177 | 768177 | 2020-04-27 | 140000049 | 140000049-vintage-estates-of-richmond | VINTAGE ESTATES OF RICHMOND | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
768178 | 768178 | 2020-04-27 | 140000083 | 140000083-walnut-creek-skilled-nursing-rehabilitation-center | WALNUT CREEK SKILLED NURSING & REHABILITATION CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
768179 | 768179 | 2020-04-27 | 140000121 | 140000121-willow-pass-healthcare-center | WILLOW PASS HEALTHCARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
768180 | 768180 | 2020-04-27 | 140000062 | 140000062-windsor-manor-rehabilitation-center-of-concord | WINDSOR MANOR REHABILITATION CENTER OF CONCORD | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
768181 | 768181 | 2020-04-27 | 140000082 | 140000082-windsor-rosewood-care-center | WINDSOR ROSEWOOD CARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
768182 | 768182 | 2020-04-27 | 10000004 | 010000004-crescent-city-skilled-nursing | CRESCENT CITY SKILLED NURSING | Del Norte | 0 | 0 | 0 | 0 | 15 | ||||
768183 | 768183 | 2020-04-27 | 30001525 | 030001525-barton-hospital-d-p-snf | BARTON HOSPITAL D/P SNF | El Dorado | 0 | 0 | 0 | 0 | 17 |
Advanced export
JSON shape: default, array, newline-delimited
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 );