la_times_cdph_skilled_nursing_facilities
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-12 sorted by date
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
749704 | 749704 | 2020-05-12 | 140000321 | 140000321-alameda-county-medical-center-d-p-snf | ALAMEDA COUNTY MEDICAL CENTER D/P SNF | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749705 | 749705 | 2020-05-12 | 20000043 | 020000043-alameda-healthcare-wellness-center | ALAMEDA HEALTHCARE & WELLNESS CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
749706 | 749706 | 2020-05-12 | 630011864 | 630011864-alameda-hospital-southshore-convalescent | ALAMEDA HOSPITAL - SOUTHSHORE CONVALESCENT | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749707 | 749707 | 2020-05-12 | 140000686 | 140000686-alameda-hospital-d-p-snf | ALAMEDA HOSPITAL D/P SNF | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749708 | 749708 | 2020-05-12 | 630013891 | 630013891-all-saint-s-maubert | ALL SAINT'S MAUBERT | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749709 | 749709 | 2020-05-12 | 20000070 | 020000070-all-saints-subacute-transitional-care | ALL SAINTS SUBACUTE & TRANSITIONAL CARE | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749710 | 749710 | 2020-05-12 | 20000010 | 020000010-ashby-care-center | ASHBY CARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749711 | 749711 | 2020-05-12 | 20000015 | 020000015-bancroft-healthcare-center | BANCROFT HEALTHCARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749712 | 749712 | 2020-05-12 | 20000135 | 020000135-bay-area-healthcare-center | BAY AREA HEALTHCARE CENTER | Alameda | 0 | 1 | 0 | 0 | 1 | <11 | |||
749713 | 749713 | 2020-05-12 | 20000026 | 020000026-bay-view-rehabilitation-hospital-llc | BAY VIEW REHABILITATION HOSPITAL, LLC | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749714 | 749714 | 2020-05-12 | 20000060 | 020000060-baypoint-healthcare-center | BAYPOINT HEALTHCARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749715 | 749715 | 2020-05-12 | 630011713 | 630011713-baywood-court-health-center | BAYWOOD COURT HEALTH CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
749716 | 749716 | 2020-05-12 | 20001250 | 020001250-bellaken-skilled-nursing-center | BELLAKEN SKILLED NURSING CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749717 | 749717 | 2020-05-12 | 20000028 | 020000028-berkeley-pines-skilled-nursing-center | BERKELEY PINES SKILLED NURSING CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749718 | 749718 | 2020-05-12 | 20000029 | 020000029-bethesda-home | BETHESDA HOME | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749719 | 749719 | 2020-05-12 | 20000048 | 020000048-chaparral-house | CHAPARRAL HOUSE | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749720 | 749720 | 2020-05-12 | 630015174 | 630015174-creekview-skilled-nursing | CREEKVIEW SKILLED NURSING | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
749721 | 749721 | 2020-05-12 | 20000053 | 020000053-crestwood-manor-fremont | CRESTWOOD MANOR - FREMONT | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
749722 | 749722 | 2020-05-12 | 20000129 | 020000129-crestwood-treatment-center | CRESTWOOD TREATMENT CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749723 | 749723 | 2020-05-12 | 20000087 | 020000087-crown-bay-nursing-rehabilitation-center | CROWN BAY NURSING & REHABILITATION CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749724 | 749724 | 2020-05-12 | 20000133 | 020000133-driftwood-healthcare-center-hayward | DRIFTWOOD HEALTHCARE CENTER - HAYWARD | Alameda | 11 | 26 | 0 | 1 | 1 | <11 | |||
749725 | 749725 | 2020-05-12 | 20000116 | 020000116-east-bay-post-acute | EAST BAY POST-ACUTE | Alameda | 33 | 32 | 0 | 1 | 1 | <11 | |||
749726 | 749726 | 2020-05-12 | 20000128 | 020000128-elmwood-care-center | ELMWOOD CARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749727 | 749727 | 2020-05-12 | 20000093 | 020000093-excell-health-care-center | EXCELL HEALTH CARE CENTER | Alameda | 19 | 41 | 0 | 1 | 1 | <11 | |||
749728 | 749728 | 2020-05-12 | 20000132 | 020000132-fremont-healthcare-center | FREMONT HEALTHCARE CENTER | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
749729 | 749729 | 2020-05-12 | 20000124 | 020000124-fruitvale-healthcare-center | FRUITVALE HEALTHCARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749730 | 749730 | 2020-05-12 | 20000125 | 020000125-garfield-neurobehavioral-center | GARFIELD NEUROBEHAVIORAL CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
749731 | 749731 | 2020-05-12 | 20000037 | 020000037-gateway-care-rehabilitation-center | GATEWAY CARE & REHABILITATION CENTER | Alameda | 28 | 49 | 0 | 17 | 1 | ||||
749732 | 749732 | 2020-05-12 | 20000123 | 020000123-hayward-convalescent-hospital | HAYWARD CONVALESCENT HOSPITAL | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749733 | 749733 | 2020-05-12 | 20000039 | 020000039-hayward-healthcare-wellness-center | HAYWARD HEALTHCARE & WELLNESS CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
749734 | 749734 | 2020-05-12 | 20000047 | 020000047-hayward-hills-health-care-center | HAYWARD HILLS HEALTH CARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749735 | 749735 | 2020-05-12 | 20000101 | 020000101-hillside-senior-care | HILLSIDE SENIOR CARE | Alameda | 1 | 1 | 0 | 1 | 1 | <11 | <11 | <11 | |
749736 | 749736 | 2020-05-12 | 20000111 | 020000111-jones-convalescent-hospital | JONES CONVALESCENT HOSPITAL | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749737 | 749737 | 2020-05-12 | 20000042 | 020000042-kaiser-permanente-post-acute-care-center | KAISER PERMANENTE POST-ACUTE CARE CENTER | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
749738 | 749738 | 2020-05-12 | 20000112 | 020000112-kyakameena-care-center | KYAKAMEENA CARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749739 | 749739 | 2020-05-12 | 20000110 | 020000110-lake-merritt-healthcare-center-llc | LAKE MERRITT HEALTHCARE CENTER LLC | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749740 | 749740 | 2020-05-12 | 20000114 | 020000114-lake-park-retirement-residence | LAKE PARK RETIREMENT RESIDENCE | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749741 | 749741 | 2020-05-12 | 20000104 | 020000104-marina-garden-nursing-center | MARINA GARDEN NURSING CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749742 | 749742 | 2020-05-12 | 20000040 | 020000040-masonic-home | MASONIC HOME | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749743 | 749743 | 2020-05-12 | 20000099 | 020000099-mcclure-post-acute | MCCLURE POST ACUTE | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749744 | 749744 | 2020-05-12 | 20000079 | 020000079-medical-hill-healthcare-center | MEDICAL HILL HEALTHCARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749745 | 749745 | 2020-05-12 | 20000100 | 020000100-mercy-retirement-care-center | MERCY RETIREMENT & CARE CENTER | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
749746 | 749746 | 2020-05-12 | 630014957 | 630014957-mocho-park-care-center | MOCHO PARK CARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749747 | 749747 | 2020-05-12 | 20000808 | 020000808-morton-bakar-center | MORTON BAKAR CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749748 | 749748 | 2020-05-12 | 20000115 | 020000115-oakland-healthcare-wellness-center | OAKLAND HEALTHCARE & WELLNESS CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749749 | 749749 | 2020-05-12 | 20000880 | 020000880-oakland-heights-nursing-and-rehabilitation | OAKLAND HEIGHTS NURSING AND REHABILITATION | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749750 | 749750 | 2020-05-12 | 630014635 | 630014635-park-bridge-rehabilitation-and-wellness-center | PARK BRIDGE REHABILITATION AND WELLNESS CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
749751 | 749751 | 2020-05-12 | 20000094 | 020000094-park-central-care-and-rehabilitation-center | PARK CENTRAL CARE AND REHABILITATION CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749752 | 749752 | 2020-05-12 | 20000090 | 020000090-parkview-healthcare-center | PARKVIEW HEALTHCARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
749753 | 749753 | 2020-05-12 | 20000091 | 020000091-piedmont-gardens-health-facility | PIEDMONT GARDENS HEALTH FACILITY | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749754 | 749754 | 2020-05-12 | 140000086 | 140000086-pleasanton-nursing-and-rehabilitation-center | PLEASANTON NURSING AND REHABILITATION CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749755 | 749755 | 2020-05-12 | 20000054 | 020000054-princeton-manor-healthcare-center-llc | PRINCETON MANOR HEALTHCARE CENTER, LLC | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749756 | 749756 | 2020-05-12 | 20000276 | 020000276-redwood-convalescent-hospital-inc | REDWOOD CONVALESCENT HOSPITAL, INC. | Alameda | 1 | 13 | 0 | 0 | 1 | <11 | |||
749757 | 749757 | 2020-05-12 | 20000119 | 020000119-redwood-healthcare-center-llc | REDWOOD HEALTHCARE CENTER LLC | Alameda | 14 | 26 | 0 | 1 | 1 | <11 | |||
749758 | 749758 | 2020-05-12 | 20000077 | 020000077-san-leandro-healthcare-center | SAN LEANDRO HEALTHCARE CENTER | Alameda | 1 | 1 | 0 | 1 | 1 | <11 | <11 | <11 | |
749759 | 749759 | 2020-05-12 | 140001291 | 140001291-silver-oak-manor | SILVER OAK MANOR | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749760 | 749760 | 2020-05-12 | 20000005 | 020000005-st-anthony-care-center | ST ANTHONY CARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749761 | 749761 | 2020-05-12 | 20000074 | 020000074-st-christopher-convalescent-hospital | ST CHRISTOPHER CONVALESCENT HOSPITAL | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749762 | 749762 | 2020-05-12 | 20000076 | 020000076-st-francis-healthcare-center | ST FRANCIS HEALTHCARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749763 | 749763 | 2020-05-12 | 20000068 | 020000068-st-john-kronstadt-convalescent-center | ST JOHN KRONSTADT CONVALESCENT CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749764 | 749764 | 2020-05-12 | 20000064 | 020000064-st-pauls-towers | ST PAULS TOWERS | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749765 | 749765 | 2020-05-12 | 20000274 | 020000274-the-rehabilitation-center-of-oakland | THE REHABILITATION CENTER OF OAKLAND | Alameda | 0 | 1 | 0 | 0 | 1 | <11 | |||
749766 | 749766 | 2020-05-12 | 140000122 | 140000122-the-vineyards-healthcare-center | THE VINEYARDS HEALTHCARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749767 | 749767 | 2020-05-12 | 140000626 | 140000626-valley-memorial-hospital-d-p-snf | VALLEY MEMORIAL HOSPITAL D/P SNF | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749768 | 749768 | 2020-05-12 | 20000066 | 020000066-valley-pointe-nursing-rehabilitation-center | VALLEY POINTE NURSING & REHABILITATION CENTER | Alameda | 0 | 1 | 0 | 0 | 1 | <11 | |||
749769 | 749769 | 2020-05-12 | 20000019 | 020000019-vista-post-acute | VISTA POST ACUTE | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749770 | 749770 | 2020-05-12 | 20000275 | 020000275-washington-center | WASHINGTON CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
749771 | 749771 | 2020-05-12 | 20000065 | 020000065-we-care-skilled-nursing-facility | WE CARE SKILLED NURSING FACILITY | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749772 | 749772 | 2020-05-12 | 20000020 | 020000020-windsor-country-drive-care-center | WINDSOR COUNTRY DRIVE CARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749773 | 749773 | 2020-05-12 | 20000103 | 020000103-windsor-gardens-care-center-of-hayward | WINDSOR GARDENS CARE CENTER OF HAYWARD | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749774 | 749774 | 2020-05-12 | 20000277 | 020000277-windsor-healthcare-center-of-oakland | WINDSOR HEALTHCARE CENTER OF OAKLAND | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
749775 | 749775 | 2020-05-12 | 20000036 | 020000036-windsor-park-care-center-of-fremont | WINDSOR PARK CARE CENTER OF FREMONT | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
749776 | 749776 | 2020-05-12 | 20000071 | 020000071-windsor-post-acute-care-center-of-hayward | WINDSOR POST-ACUTE CARE CENTER OF HAYWARD | Alameda | 19 | 23 | 0 | 1 | 1 | <11 | |||
749777 | 749777 | 2020-05-12 | 30000074 | 030000074-kit-carson-nursing-rehabilitation-center | KIT CARSON NURSING & REHABILITATION CENTER | Amador | 0 | 0 | 0 | 0 | 5 | ||||
749778 | 749778 | 2020-05-12 | 230000255 | 230000255-arbor-post-acute | ARBOR POST ACUTE | Butte | 0 | 0 | 0 | 0 | 7 | ||||
749779 | 749779 | 2020-05-12 | 230000546 | 230000546-california-park-rehabilitation-hospital | CALIFORNIA PARK REHABILITATION HOSPITAL | Butte | 0 | 0 | 0 | 0 | 7 | ||||
749780 | 749780 | 2020-05-12 | 230000802 | 230000802-country-crest-post-acute | COUNTRY CREST POST ACUTE | Butte | 0 | 0 | 0 | 0 | 7 | ||||
749781 | 749781 | 2020-05-12 | 230000327 | 230000327-orchard-hospital-d-p-snf | ORCHARD HOSPITAL D/P SNF | Butte | 0 | 0 | 0 | 0 | 7 | ||||
749782 | 749782 | 2020-05-12 | 230000221 | 230000221-oroville-hospital-post-acute-center | OROVILLE HOSPITAL POST-ACUTE CENTER | Butte | 0 | 0 | 0 | 0 | 7 | ||||
749783 | 749783 | 2020-05-12 | 230000036 | 230000036-riverside-convalescent-hospital | RIVERSIDE CONVALESCENT HOSPITAL | Butte | 0 | 0 | 0 | 0 | 7 | ||||
749784 | 749784 | 2020-05-12 | 230000037 | 230000037-shadowbrook-post-acute | SHADOWBROOK POST ACUTE | Butte | 0 | 0 | 0 | 0 | 7 | ||||
749785 | 749785 | 2020-05-12 | 230000025 | 230000025-windsor-chico-care-center | WINDSOR CHICO CARE CENTER | Butte | 0 | 0 | 0 | 0 | 7 | ||||
749786 | 749786 | 2020-05-12 | 230000029 | 230000029-windsor-chico-creek-care-and-rehabilitation-center | WINDSOR CHICO CREEK CARE AND REHABILITATION CENTER | Butte | 0 | 0 | 0 | 0 | 7 | ||||
749787 | 749787 | 2020-05-12 | 30000012 | 030000012-avalon-health-care-san-andreas | AVALON HEALTH CARE - SAN ANDREAS | Calaveras | 0 | 0 | 0 | 0 | 9 | ||||
749788 | 749788 | 2020-05-12 | 230000424 | 230000424-colusa-medical-center-snf | COLUSA MEDICAL CENTER - SNF | Colusa | 0 | 0 | 0 | 0 | 11 | ||||
749789 | 749789 | 2020-05-12 | 230000283 | 230000283-valley-west-post-acute | VALLEY WEST POST ACUTE | Colusa | 0 | 0 | 0 | 0 | 11 | ||||
749790 | 749790 | 2020-05-12 | 140000574 | 140000574-alhambra-convalescent-hospital | ALHAMBRA CONVALESCENT HOSPITAL | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
749791 | 749791 | 2020-05-12 | 140000003 | 140000003-antioch-convalescent-hospital | ANTIOCH CONVALESCENT HOSPITAL | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
749792 | 749792 | 2020-05-12 | 140000023 | 140000023-bayberry-skilled-nursing-healthcare-center | BAYBERRY SKILLED NURSING & HEALTHCARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
749793 | 749793 | 2020-05-12 | 140000138 | 140000138-creekside-healthcare-center | CREEKSIDE HEALTHCARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
749794 | 749794 | 2020-05-12 | 140000130 | 140000130-danville-post-acute-rehab | DANVILLE POST-ACUTE REHAB | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
749795 | 749795 | 2020-05-12 | 140000564 | 140000564-diamond-ridge-healthcare-center | DIAMOND RIDGE HEALTHCARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
749796 | 749796 | 2020-05-12 | 140000038 | 140000038-greenridge-senior-care | GREENRIDGE SENIOR CARE | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
749797 | 749797 | 2020-05-12 | 140000051 | 140000051-la-casa-via-transitional-care-center | LA CASA VIA TRANSITIONAL CARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
749798 | 749798 | 2020-05-12 | 140000102 | 140000102-legacy-nursing-and-rehabilitation-center | LEGACY NURSING AND REHABILITATION CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
749799 | 749799 | 2020-05-12 | 140000105 | 140000105-lone-tree-convalescent-hospital | LONE TREE CONVALESCENT HOSPITAL | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
749800 | 749800 | 2020-05-12 | 140001126 | 140001126-manor-care-health-services-tice-valley | MANOR CARE HEALTH SERVICES-TICE VALLEY | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
749801 | 749801 | 2020-05-12 | 140000745 | 140000745-manorcare-health-services-rossmoor | MANORCARE HEALTH SERVICES - ROSSMOOR | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
749802 | 749802 | 2020-05-12 | 140000106 | 140000106-martinez-convalescent-hospital | MARTINEZ CONVALESCENT HOSPITAL | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
749803 | 749803 | 2020-05-12 | 140000081 | 140000081-moraga-post-acute | MORAGA POST ACUTE | Contra Costa | 0 | 0 | 0 | 0 | 13 |
Advanced export
JSON shape: default, array, newline-delimited
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 );