la_times_cdph_skilled_nursing_facilities

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: Reusing the data · Data source: California Department of Public Health via The Los Angeles Times · About: Data dictionary for la_times_cdph_skilled_nursing_facilities

1,224 rows where "date" is on date 2020-05-09 sorted by date descending

✎ 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
753376 753376 2020-05-09 140000321 140000321-alameda-county-medical-center-d-p-snf ALAMEDA COUNTY MEDICAL CENTER D/P SNF Alameda 0 0 0 0 1        
753377 753377 2020-05-09 20000043 020000043-alameda-healthcare-wellness-center ALAMEDA HEALTHCARE & WELLNESS CENTER Alameda 1 0 0 0 1 <11      
753378 753378 2020-05-09 630011864 630011864-alameda-hospital-southshore-convalescent ALAMEDA HOSPITAL - SOUTHSHORE CONVALESCENT Alameda 0 0 0 0 1        
753379 753379 2020-05-09 140000686 140000686-alameda-hospital-d-p-snf ALAMEDA HOSPITAL D/P SNF Alameda 0 0 0 0 1        
753380 753380 2020-05-09 630013891 630013891-all-saint-s-maubert ALL SAINT'S MAUBERT Alameda 0 0 0 0 1        
753381 753381 2020-05-09 20000070 020000070-all-saints-subacute-transitional-care ALL SAINTS SUBACUTE & TRANSITIONAL CARE Alameda 0 0 0 0 1        
753382 753382 2020-05-09 20000010 020000010-ashby-care-center ASHBY CARE CENTER Alameda 0 0 0 0 1        
753383 753383 2020-05-09 20000015 020000015-bancroft-healthcare-center BANCROFT HEALTHCARE CENTER Alameda 0 0 0 0 1        
753384 753384 2020-05-09 20000135 020000135-bay-area-healthcare-center BAY AREA HEALTHCARE CENTER Alameda 0 1 0 0 1   <11    
753385 753385 2020-05-09 20000026 020000026-bay-view-rehabilitation-hospital-llc BAY VIEW REHABILITATION HOSPITAL, LLC Alameda 0 0 0 0 1        
753386 753386 2020-05-09 20000060 020000060-baypoint-healthcare-center BAYPOINT HEALTHCARE CENTER Alameda 0 0 0 0 1        
753387 753387 2020-05-09 630011713 630011713-baywood-court-health-center BAYWOOD COURT HEALTH CENTER Alameda 1 0 0 0 1 <11      
753388 753388 2020-05-09 20001250 020001250-bellaken-skilled-nursing-center BELLAKEN SKILLED NURSING CENTER Alameda 0 0 0 0 1        
753389 753389 2020-05-09 20000028 020000028-berkeley-pines-skilled-nursing-center BERKELEY PINES SKILLED NURSING CENTER Alameda 0 0 0 0 1        
753390 753390 2020-05-09 20000029 020000029-bethesda-home BETHESDA HOME Alameda 0 0 0 0 1        
753391 753391 2020-05-09 20000048 020000048-chaparral-house CHAPARRAL HOUSE Alameda 0 0 0 0 1        
753392 753392 2020-05-09 630015174 630015174-creekview-skilled-nursing CREEKVIEW SKILLED NURSING Alameda 1 0 0 0 1 <11      
753393 753393 2020-05-09 20000053 020000053-crestwood-manor-fremont CRESTWOOD MANOR - FREMONT Alameda 1 0 0 0 1 <11      
753394 753394 2020-05-09 20000129 020000129-crestwood-treatment-center CRESTWOOD TREATMENT CENTER Alameda 0 0 0 0 1        
753395 753395 2020-05-09 20000087 020000087-crown-bay-nursing-rehabilitation-center CROWN BAY NURSING & REHABILITATION CENTER Alameda 0 0 0 0 1        
753396 753396 2020-05-09 20000133 020000133-driftwood-healthcare-center-hayward DRIFTWOOD HEALTHCARE CENTER - HAYWARD Alameda 11 25 0 1 1       <11
753397 753397 2020-05-09 20000116 020000116-east-bay-post-acute EAST BAY POST-ACUTE Alameda 33 32 0 1 1       <11
753398 753398 2020-05-09 20000128 020000128-elmwood-care-center ELMWOOD CARE CENTER Alameda 0 0 0 0 1        
753399 753399 2020-05-09 20000093 020000093-excell-health-care-center EXCELL HEALTH CARE CENTER Alameda 19 41 0 1 1       <11
753400 753400 2020-05-09 20000132 020000132-fremont-healthcare-center FREMONT HEALTHCARE CENTER Alameda 1 1 0 0 1 <11 <11    
753401 753401 2020-05-09 20000124 020000124-fruitvale-healthcare-center FRUITVALE HEALTHCARE CENTER Alameda 0 0 0 0 1        
753402 753402 2020-05-09 20000125 020000125-garfield-neurobehavioral-center GARFIELD NEUROBEHAVIORAL CENTER Alameda 1 0 0 0 1 <11      
753403 753403 2020-05-09 20000037 020000037-gateway-care-rehabilitation-center GATEWAY CARE & REHABILITATION CENTER Alameda 28 49 0 17 1        
753404 753404 2020-05-09 20000123 020000123-hayward-convalescent-hospital HAYWARD CONVALESCENT HOSPITAL Alameda 0 0 0 0 1        
753405 753405 2020-05-09 20000039 020000039-hayward-healthcare-wellness-center HAYWARD HEALTHCARE & WELLNESS CENTER Alameda 1 0 0 0 1 <11      
753406 753406 2020-05-09 20000047 020000047-hayward-hills-health-care-center HAYWARD HILLS HEALTH CARE CENTER Alameda 0 0 0 0 1        
753407 753407 2020-05-09 20000101 020000101-hillside-senior-care HILLSIDE SENIOR CARE Alameda 0 1 0 1 1   <11   <11
753408 753408 2020-05-09 20000111 020000111-jones-convalescent-hospital JONES CONVALESCENT HOSPITAL Alameda 0 0 0 0 1        
753409 753409 2020-05-09 20000042 020000042-kaiser-permanente-post-acute-care-center KAISER PERMANENTE POST-ACUTE CARE CENTER Alameda 1 1 0 0 1 <11 <11    
753410 753410 2020-05-09 20000112 020000112-kyakameena-care-center KYAKAMEENA CARE CENTER Alameda 0 0 0 0 1        
753411 753411 2020-05-09 20000110 020000110-lake-merritt-healthcare-center-llc LAKE MERRITT HEALTHCARE CENTER LLC Alameda 0 0 0 0 1        
753412 753412 2020-05-09 20000114 020000114-lake-park-retirement-residence LAKE PARK RETIREMENT RESIDENCE Alameda 0 0 0 0 1        
753413 753413 2020-05-09 20000104 020000104-marina-garden-nursing-center MARINA GARDEN NURSING CENTER Alameda 0 0 0 0 1        
753414 753414 2020-05-09 20000040 020000040-masonic-home MASONIC HOME Alameda 0 0 0 0 1        
753415 753415 2020-05-09 20000099 020000099-mcclure-post-acute MCCLURE POST ACUTE Alameda 0 0 0 0 1        
753416 753416 2020-05-09 20000079 020000079-medical-hill-healthcare-center MEDICAL HILL HEALTHCARE CENTER Alameda 0 0 0 0 1        
753417 753417 2020-05-09 20000100 020000100-mercy-retirement-care-center MERCY RETIREMENT & CARE CENTER Alameda 1 1 0 0 1 <11 <11    
753418 753418 2020-05-09 630014957 630014957-mocho-park-care-center MOCHO PARK CARE CENTER Alameda 0 0 0 0 1        
753419 753419 2020-05-09 20000808 020000808-morton-bakar-center MORTON BAKAR CENTER Alameda 0 0 0 0 1        
753420 753420 2020-05-09 20000115 020000115-oakland-healthcare-wellness-center OAKLAND HEALTHCARE & WELLNESS CENTER Alameda 0 0 0 0 1        
753421 753421 2020-05-09 20000880 020000880-oakland-heights-nursing-and-rehabilitation OAKLAND HEIGHTS NURSING AND REHABILITATION Alameda 0 0 0 0 1        
753422 753422 2020-05-09 630014635 630014635-park-bridge-rehabilitation-and-wellness-center PARK BRIDGE REHABILITATION AND WELLNESS CENTER Alameda 1 0 0 0 1 <11      
753423 753423 2020-05-09 20000094 020000094-park-central-care-and-rehabilitation-center PARK CENTRAL CARE AND REHABILITATION CENTER Alameda 0 0 0 0 1        
753424 753424 2020-05-09 20000090 020000090-parkview-healthcare-center PARKVIEW HEALTHCARE CENTER Alameda 1 0 0 0 1 <11      
753425 753425 2020-05-09 20000091 020000091-piedmont-gardens-health-facility PIEDMONT GARDENS HEALTH FACILITY Alameda 0 0 0 0 1        
753426 753426 2020-05-09 140000086 140000086-pleasanton-nursing-and-rehabilitation-center PLEASANTON NURSING AND REHABILITATION CENTER Alameda 0 0 0 0 1        
753427 753427 2020-05-09 20000054 020000054-princeton-manor-healthcare-center-llc PRINCETON MANOR HEALTHCARE CENTER, LLC Alameda 0 0 0 0 1        
753428 753428 2020-05-09 20000276 020000276-redwood-convalescent-hospital-inc REDWOOD CONVALESCENT HOSPITAL, INC. Alameda 1 13 0 0 1 <11      
753429 753429 2020-05-09 20000119 020000119-redwood-healthcare-center-llc REDWOOD HEALTHCARE CENTER LLC Alameda 14 26 0 1 1       <11
753430 753430 2020-05-09 20000077 020000077-san-leandro-healthcare-center SAN LEANDRO HEALTHCARE CENTER Alameda 1 1 0 1 1 <11 <11   <11
753431 753431 2020-05-09 140001291 140001291-silver-oak-manor SILVER OAK MANOR Alameda 0 0 0 0 1        
753432 753432 2020-05-09 20000005 020000005-st-anthony-care-center ST ANTHONY CARE CENTER Alameda 0 0 0 0 1        
753433 753433 2020-05-09 20000074 020000074-st-christopher-convalescent-hospital ST CHRISTOPHER CONVALESCENT HOSPITAL Alameda 0 0 0 0 1        
753434 753434 2020-05-09 20000076 020000076-st-francis-healthcare-center ST FRANCIS HEALTHCARE CENTER Alameda 0 0 0 0 1        
753435 753435 2020-05-09 20000068 020000068-st-john-kronstadt-convalescent-center ST JOHN KRONSTADT CONVALESCENT CENTER Alameda 0 0 0 0 1        
753436 753436 2020-05-09 20000064 020000064-st-pauls-towers ST PAULS TOWERS Alameda 0 0 0 0 1        
753437 753437 2020-05-09 20000274 020000274-the-rehabilitation-center-of-oakland THE REHABILITATION CENTER OF OAKLAND Alameda 0 1 0 0 1   <11    
753438 753438 2020-05-09 140000122 140000122-the-vineyards-healthcare-center THE VINEYARDS HEALTHCARE CENTER Alameda 0 0 0 0 1        
753439 753439 2020-05-09 140000626 140000626-valley-memorial-hospital-d-p-snf VALLEY MEMORIAL HOSPITAL D/P SNF Alameda 0 0 0 0 1        
753440 753440 2020-05-09 20000066 020000066-valley-pointe-nursing-rehabilitation-center VALLEY POINTE NURSING & REHABILITATION CENTER Alameda 0 0 0 0 1        
753441 753441 2020-05-09 20000019 020000019-vista-post-acute VISTA POST ACUTE Alameda 0 0 0 0 1        
753442 753442 2020-05-09 20000275 020000275-washington-center WASHINGTON CENTER Alameda 1 0 0 0 1 <11      
753443 753443 2020-05-09 20000065 020000065-we-care-skilled-nursing-facility WE CARE SKILLED NURSING FACILITY Alameda 0 0 0 0 1        
753444 753444 2020-05-09 20000020 020000020-windsor-country-drive-care-center WINDSOR COUNTRY DRIVE CARE CENTER Alameda 0 0 0 0 1        
753445 753445 2020-05-09 20000103 020000103-windsor-gardens-care-center-of-hayward WINDSOR GARDENS CARE CENTER OF HAYWARD Alameda 0 0 0 0 1        
753446 753446 2020-05-09 20000277 020000277-windsor-healthcare-center-of-oakland WINDSOR HEALTHCARE CENTER OF OAKLAND Alameda 1 0 0 0 1 <11      
753447 753447 2020-05-09 20000036 020000036-windsor-park-care-center-of-fremont WINDSOR PARK CARE CENTER OF FREMONT Alameda 0 0 0 0 1        
753448 753448 2020-05-09 20000071 020000071-windsor-post-acute-care-center-of-hayward WINDSOR POST-ACUTE CARE CENTER OF HAYWARD Alameda 19 23 0 1 1       <11
753449 753449 2020-05-09 30000074 030000074-kit-carson-nursing-rehabilitation-center KIT CARSON NURSING & REHABILITATION CENTER Amador 0 0 0 0 5        
753450 753450 2020-05-09 230000255 230000255-arbor-post-acute ARBOR POST ACUTE Butte 0 0 0 0 7        
753451 753451 2020-05-09 230000546 230000546-california-park-rehabilitation-hospital CALIFORNIA PARK REHABILITATION HOSPITAL Butte 0 0 0 0 7        
753452 753452 2020-05-09 230000802 230000802-country-crest-post-acute COUNTRY CREST POST ACUTE Butte 0 0 0 0 7        
753453 753453 2020-05-09 230000327 230000327-orchard-hospital-d-p-snf ORCHARD HOSPITAL D/P SNF Butte 0 0 0 0 7        
753454 753454 2020-05-09 230000221 230000221-oroville-hospital-post-acute-center OROVILLE HOSPITAL POST-ACUTE CENTER Butte 0 0 0 0 7        
753455 753455 2020-05-09 230000036 230000036-riverside-convalescent-hospital RIVERSIDE CONVALESCENT HOSPITAL Butte 0 0 0 0 7        
753456 753456 2020-05-09 230000037 230000037-shadowbrook-post-acute SHADOWBROOK POST ACUTE Butte 0 0 0 0 7        
753457 753457 2020-05-09 230000025 230000025-windsor-chico-care-center WINDSOR CHICO CARE CENTER Butte 0 0 0 0 7        
753458 753458 2020-05-09 230000029 230000029-windsor-chico-creek-care-and-rehabilitation-center WINDSOR CHICO CREEK CARE AND REHABILITATION CENTER Butte 0 0 0 0 7        
753459 753459 2020-05-09 30000012 030000012-avalon-health-care-san-andreas AVALON HEALTH CARE - SAN ANDREAS Calaveras 0 0 0 0 9        
753460 753460 2020-05-09 230000424 230000424-colusa-medical-center-snf COLUSA MEDICAL CENTER - SNF Colusa 0 0 0 0 11        
753461 753461 2020-05-09 230000283 230000283-valley-west-post-acute VALLEY WEST POST ACUTE Colusa 0 0 0 0 11        
753462 753462 2020-05-09 140000574 140000574-alhambra-convalescent-hospital ALHAMBRA CONVALESCENT HOSPITAL Contra Costa 0 0 0 0 13        
753463 753463 2020-05-09 140000003 140000003-antioch-convalescent-hospital ANTIOCH CONVALESCENT HOSPITAL Contra Costa 0 0 0 0 13        
753464 753464 2020-05-09 140000023 140000023-bayberry-skilled-nursing-healthcare-center BAYBERRY SKILLED NURSING & HEALTHCARE CENTER Contra Costa 0 0 0 0 13        
753465 753465 2020-05-09 140000138 140000138-creekside-healthcare-center CREEKSIDE HEALTHCARE CENTER Contra Costa 0 0 0 0 13        
753466 753466 2020-05-09 140000130 140000130-danville-post-acute-rehab DANVILLE POST-ACUTE REHAB Contra Costa 0 0 0 0 13        
753467 753467 2020-05-09 140000564 140000564-diamond-ridge-healthcare-center DIAMOND RIDGE HEALTHCARE CENTER Contra Costa 0 0 0 0 13        
753468 753468 2020-05-09 140000038 140000038-greenridge-senior-care GREENRIDGE SENIOR CARE Contra Costa 0 0 0 0 13        
753469 753469 2020-05-09 140000051 140000051-la-casa-via-transitional-care-center LA CASA VIA TRANSITIONAL CARE CENTER Contra Costa 0 0 0 0 13        
753470 753470 2020-05-09 140000102 140000102-legacy-nursing-and-rehabilitation-center LEGACY NURSING AND REHABILITATION CENTER Contra Costa 0 0 0 0 13        
753471 753471 2020-05-09 140000105 140000105-lone-tree-convalescent-hospital LONE TREE CONVALESCENT HOSPITAL Contra Costa 0 0 0 0 13        
753472 753472 2020-05-09 140001126 140001126-manor-care-health-services-tice-valley MANOR CARE HEALTH SERVICES-TICE VALLEY Contra Costa 0 0 0 0 13        
753473 753473 2020-05-09 140000745 140000745-manorcare-health-services-rossmoor MANORCARE HEALTH SERVICES - ROSSMOOR Contra Costa 0 0 0 0 13        
753474 753474 2020-05-09 140000106 140000106-martinez-convalescent-hospital MARTINEZ CONVALESCENT HOSPITAL Contra Costa 0 0 0 0 13        
753475 753475 2020-05-09 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 [la_times_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
);