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,223 rows where "date" is on date 2020-08-18 sorted by patients_confirmed_cases_note
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
629851 | 629851 | 2020-08-18 | 140000686 | 140000686-alameda-hospital-d-p-snf | ALAMEDA HOSPITAL D/P SNF | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
629852 | 629852 | 2020-08-18 | 630013891 | 630013891-all-saint-s-maubert | ALL SAINT'S MAUBERT | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
629853 | 629853 | 2020-08-18 | 20000070 | 020000070-all-saints-subacute-transitional-care | ALL SAINTS SUBACUTE & TRANSITIONAL CARE | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
629854 | 629854 | 2020-08-18 | 20000010 | 020000010-ashby-care-center | ASHBY CARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
629855 | 629855 | 2020-08-18 | 140001291 | 140001291-avondale-villa-post-acute | AVONDALE VILLA POST-ACUTE | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
629856 | 629856 | 2020-08-18 | 20000015 | 020000015-bancroft-healthcare-center | BANCROFT HEALTHCARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
629859 | 629859 | 2020-08-18 | 20000060 | 020000060-baypoint-healthcare-center | BAYPOINT HEALTHCARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
629860 | 629860 | 2020-08-18 | 630011713 | 630011713-baywood-court-health-center | BAYWOOD COURT HEALTH CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
629861 | 629861 | 2020-08-18 | 20001250 | 020001250-bellaken-skilled-nursing-center | BELLAKEN SKILLED NURSING CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
629862 | 629862 | 2020-08-18 | 20000028 | 020000028-berkeley-pines-skilled-nursing-center | BERKELEY PINES SKILLED NURSING CENTER | Alameda | 1 | 18 | 0 | 1 | 1 | <11 | <11 | ||
629863 | 629863 | 2020-08-18 | 20000029 | 020000029-bethesda-home | BETHESDA HOME | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
629866 | 629866 | 2020-08-18 | 20000053 | 020000053-crestwood-manor-fremont | CRESTWOOD MANOR - FREMONT | Alameda | 17 | 52 | 1 | 1 | 1 | <11 | <11 | ||
629867 | 629867 | 2020-08-18 | 20000129 | 020000129-crestwood-treatment-center | CRESTWOOD TREATMENT CENTER | Alameda | 1 | 25 | 0 | 0 | 1 | <11 | |||
629868 | 629868 | 2020-08-18 | 20000087 | 020000087-crown-bay-nursing-rehabilitation-center | CROWN BAY NURSING & REHABILITATION CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
629869 | 629869 | 2020-08-18 | 20000133 | 020000133-driftwood-healthcare-center-hayward | DRIFTWOOD HEALTHCARE CENTER - HAYWARD | Alameda | 13 | 32 | 0 | 1 | 1 | <11 | |||
629870 | 629870 | 2020-08-18 | 20000116 | 020000116-east-bay-post-acute | EAST BAY POST-ACUTE | Alameda | 27 | 33 | 0 | 1 | 1 | <11 | |||
629872 | 629872 | 2020-08-18 | 20000093 | 020000093-excell-health-care-center | EXCELL HEALTH CARE CENTER | Alameda | 23 | 43 | 0 | 1 | 1 | <11 | |||
629873 | 629873 | 2020-08-18 | 20000132 | 020000132-fremont-healthcare-center | FREMONT HEALTHCARE CENTER | Alameda | 1 | 38 | 0 | 1 | 1 | <11 | <11 | ||
629874 | 629874 | 2020-08-18 | 20000124 | 020000124-fruitvale-healthcare-center | FRUITVALE HEALTHCARE CENTER | Alameda | 13 | 11 | 0 | 0 | 1 | ||||
629875 | 629875 | 2020-08-18 | 20000125 | 020000125-garfield-neurobehavioral-center | GARFIELD NEUROBEHAVIORAL CENTER | Alameda | 37 | 34 | 0 | 0 | 1 | ||||
629876 | 629876 | 2020-08-18 | 20000123 | 020000123-hayward-convalescent-hospital | HAYWARD CONVALESCENT HOSPITAL | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
629878 | 629878 | 2020-08-18 | 20000047 | 020000047-hayward-hills-health-care-center | HAYWARD HILLS HEALTH CARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
629879 | 629879 | 2020-08-18 | 20000111 | 020000111-jones-convalescent-hospital | JONES CONVALESCENT HOSPITAL | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
629880 | 629880 | 2020-08-18 | 20000042 | 020000042-kaiser-permanente-post-acute-care-center | KAISER PERMANENTE POST-ACUTE CARE CENTER | Alameda | 12 | 18 | 0 | 1 | 1 | <11 | |||
629881 | 629881 | 2020-08-18 | 20000112 | 020000112-kyakameena-care-center | KYAKAMEENA CARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
629882 | 629882 | 2020-08-18 | 20000110 | 020000110-lake-merritt-healthcare-center-llc | LAKE MERRITT HEALTHCARE CENTER LLC | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
629883 | 629883 | 2020-08-18 | 20000114 | 020000114-lake-park-retirement-residence | LAKE PARK RETIREMENT RESIDENCE | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
629885 | 629885 | 2020-08-18 | 20000040 | 020000040-masonic-home | MASONIC HOME | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
629886 | 629886 | 2020-08-18 | 20000099 | 020000099-mcclure-post-acute | MCCLURE POST ACUTE | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
629887 | 629887 | 2020-08-18 | 20000079 | 020000079-medical-hill-healthcare-center | MEDICAL HILL HEALTHCARE CENTER | Alameda | 30 | 40 | 0 | 0 | 1 | ||||
629888 | 629888 | 2020-08-18 | 20000100 | 020000100-mercy-retirement-care-center | MERCY RETIREMENT & CARE CENTER | Alameda | 13 | 16 | 0 | 1 | 1 | <11 | |||
629889 | 629889 | 2020-08-18 | 20000808 | 020000808-morton-bakar-center | MORTON BAKAR CENTER | Alameda | 1 | 17 | 0 | 1 | 1 | <11 | <11 | ||
629892 | 629892 | 2020-08-18 | 20000880 | 020000880-oakland-heights-nursing-and-rehabilitation | OAKLAND HEIGHTS NURSING AND REHABILITATION | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
629894 | 629894 | 2020-08-18 | 20000094 | 020000094-park-central-care-and-rehabilitation-center | PARK CENTRAL CARE AND REHABILITATION CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
629895 | 629895 | 2020-08-18 | 20000090 | 020000090-parkview-healthcare-center | PARKVIEW HEALTHCARE CENTER | Alameda | 20 | 61 | 1 | 1 | 1 | <11 | <11 | ||
629896 | 629896 | 2020-08-18 | 20000091 | 020000091-piedmont-gardens-health-facility | PIEDMONT GARDENS HEALTH FACILITY | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
629899 | 629899 | 2020-08-18 | 20000276 | 020000276-redwood-convalescent-hospital-inc | REDWOOD CONVALESCENT HOSPITAL, INC. | Alameda | 1 | 21 | 0 | 1 | 1 | <11 | <11 | ||
629900 | 629900 | 2020-08-18 | 20000119 | 020000119-redwood-healthcare-center-llc | REDWOOD HEALTHCARE CENTER LLC | Alameda | 16 | 29 | 0 | 1 | 1 | <11 | |||
629902 | 629902 | 2020-08-18 | 20000074 | 020000074-serenethos-care-center-llc | SERENETHOS CARE CENTER, LLC | Alameda | 11 | 21 | 0 | 0 | 1 | ||||
629903 | 629903 | 2020-08-18 | 20000005 | 020000005-st-anthony-care-center | ST ANTHONY CARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
629904 | 629904 | 2020-08-18 | 20000076 | 020000076-st-francis-healthcare-center | ST FRANCIS HEALTHCARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
629905 | 629905 | 2020-08-18 | 20000068 | 020000068-st-john-kronstadt-convalescent-center | ST JOHN KRONSTADT CONVALESCENT CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
629906 | 629906 | 2020-08-18 | 20000064 | 020000064-st-pauls-towers | ST PAULS TOWERS | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
629907 | 629907 | 2020-08-18 | 20000037 | 020000037-st-patrick-s-post-acute | ST. PATRICK'S POST ACUTE | Alameda | 31 | 48 | 0 | 19 | 1 | ||||
629909 | 629909 | 2020-08-18 | 20000274 | 020000274-the-rehabilitation-center-of-oakland | THE REHABILITATION CENTER OF OAKLAND | Alameda | 1 | 24 | 0 | 1 | 1 | <11 | <11 | ||
629910 | 629910 | 2020-08-18 | 140000122 | 140000122-the-vineyards-healthcare-center | THE VINEYARDS HEALTHCARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
629911 | 629911 | 2020-08-18 | 140000626 | 140000626-valley-memorial-hospital-d-p-snf | VALLEY MEMORIAL HOSPITAL D/P SNF | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
629913 | 629913 | 2020-08-18 | 20000019 | 020000019-vista-post-acute | VISTA POST ACUTE | Alameda | 27 | 48 | 0 | 1 | 1 | <11 | |||
629914 | 629914 | 2020-08-18 | 20000275 | 020000275-washington-center | WASHINGTON CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
629915 | 629915 | 2020-08-18 | 20000065 | 020000065-we-care-skilled-nursing-facility | WE CARE SKILLED NURSING FACILITY | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
629918 | 629918 | 2020-08-18 | 20000277 | 020000277-windsor-healthcare-center-of-oakland | WINDSOR HEALTHCARE CENTER OF OAKLAND | Alameda | 28 | 39 | 0 | 1 | 1 | <11 | |||
629919 | 629919 | 2020-08-18 | 20000036 | 020000036-windsor-park-care-center-of-fremont | WINDSOR PARK CARE CENTER OF FREMONT | Alameda | 14 | 16 | 0 | 0 | 1 | ||||
629920 | 629920 | 2020-08-18 | 20000071 | 020000071-windsor-post-acute-care-center-of-hayward | WINDSOR POST-ACUTE CARE CENTER OF HAYWARD | Alameda | 31 | 30 | 0 | 1 | 1 | <11 | |||
629921 | 629921 | 2020-08-18 | 30000074 | 030000074-kit-carson-nursing-rehabilitation-center | KIT CARSON NURSING & REHABILITATION CENTER | Amador | 22 | 50 | 0 | 15 | 5 | ||||
629922 | 629922 | 2020-08-18 | 230000255 | 230000255-arbor-post-acute | ARBOR POST ACUTE | Butte | 12 | 17 | 0 | 1 | 7 | <11 | |||
629925 | 629925 | 2020-08-18 | 230000327 | 230000327-orchard-hospital-d-p-snf | ORCHARD HOSPITAL D/P SNF | Butte | 0 | 0 | 0 | 0 | 7 | ||||
629926 | 629926 | 2020-08-18 | 230000221 | 230000221-oroville-hospital-post-acute-center | OROVILLE HOSPITAL POST-ACUTE CENTER | Butte | 1 | 0 | 0 | 0 | 7 | <11 | |||
629927 | 629927 | 2020-08-18 | 230000036 | 230000036-riverside-convalescent-hospital | RIVERSIDE CONVALESCENT HOSPITAL | Butte | 1 | 15 | 0 | 0 | 7 | <11 | |||
629928 | 629928 | 2020-08-18 | 230000037 | 230000037-shadowbrook-post-acute | SHADOWBROOK POST ACUTE | Butte | 0 | 0 | 0 | 0 | 7 | ||||
629930 | 629930 | 2020-08-18 | 230000029 | 230000029-windsor-chico-creek-care-and-rehabilitation-center | WINDSOR CHICO CREEK CARE AND REHABILITATION CENTER | Butte | 28 | 38 | 0 | 1 | 7 | <11 | |||
629932 | 629932 | 2020-08-18 | 230000424 | 230000424-colusa-medical-center-snf | COLUSA MEDICAL CENTER - SNF | Colusa | 1 | 0 | 0 | 0 | 11 | <11 | |||
629933 | 629933 | 2020-08-18 | 230000283 | 230000283-valley-west-post-acute | VALLEY WEST POST ACUTE | Colusa | 39 | 29 | 0 | 1 | 11 | <11 | |||
629934 | 629934 | 2020-08-18 | 140000574 | 140000574-alhambra-convalescent-hospital | ALHAMBRA CONVALESCENT HOSPITAL | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
629935 | 629935 | 2020-08-18 | 140000023 | 140000023-bayberry-skilled-nursing-healthcare-center | BAYBERRY SKILLED NURSING & HEALTHCARE CENTER | Contra Costa | 28 | 53 | 0 | 1 | 13 | <11 | |||
629936 | 629936 | 2020-08-18 | 140000138 | 140000138-creekside-healthcare-center | CREEKSIDE HEALTHCARE CENTER | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
629937 | 629937 | 2020-08-18 | 140000130 | 140000130-danville-post-acute-rehab | DANVILLE POST-ACUTE REHAB | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
629938 | 629938 | 2020-08-18 | 140000003 | 140000003-delta-view-post-acute | DELTA VIEW POST ACUTE | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
629939 | 629939 | 2020-08-18 | 140000564 | 140000564-diamond-ridge-healthcare-center | DIAMOND RIDGE HEALTHCARE CENTER | Contra Costa | 15 | 20 | 0 | 1 | 13 | <11 | |||
629940 | 629940 | 2020-08-18 | 140000038 | 140000038-greenridge-post-acute | GREENRIDGE POST ACUTE | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
629941 | 629941 | 2020-08-18 | 140000051 | 140000051-la-casa-via-transitional-care-center | LA CASA VIA TRANSITIONAL CARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
629942 | 629942 | 2020-08-18 | 140000102 | 140000102-legacy-post-acute-care | LEGACY POST ACUTE CARE | Contra Costa | 12 | 13 | 0 | 1 | 13 | <11 | |||
629943 | 629943 | 2020-08-18 | 140000105 | 140000105-lone-tree-post-acute | LONE TREE POST ACUTE | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
629945 | 629945 | 2020-08-18 | 140001126 | 140001126-manorcare-health-services-tice-valley | MANORCARE HEALTH SERVICES - TICE VALLEY | Contra Costa | 39 | 92 | 0 | 17 | 13 | ||||
629947 | 629947 | 2020-08-18 | 140000081 | 140000081-moraga-post-acute | MORAGA POST ACUTE | Contra Costa | 1 | 11 | 0 | 0 | 13 | <11 | |||
629948 | 629948 | 2020-08-18 | 140000092 | 140000092-orinda-care-center-llc | ORINDA CARE CENTER, LLC | Contra Costa | 32 | 40 | 0 | 1 | 13 | <11 | |||
629951 | 629951 | 2020-08-18 | 140000096 | 140000096-pleasant-hill-post-acute | PLEASANT HILL POST ACUTE | Contra Costa | 18 | 28 | 0 | 1 | 13 | <11 | |||
629952 | 629952 | 2020-08-18 | 140000049 | 140000049-richmond-post-acute-care | RICHMOND POST ACUTE CARE | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
629953 | 629953 | 2020-08-18 | 140000136 | 140000136-san-miguel-villa | SAN MIGUEL VILLA | Contra Costa | 17 | 65 | 1 | 20 | 13 | <11 | |||
629956 | 629956 | 2020-08-18 | 140000396 | 140000396-shields-nursing-center | SHIELDS NURSING CENTER | Contra Costa | 0 | 0 | 0 | 1 | 13 | <11 | |||
629957 | 629957 | 2020-08-18 | 140000080 | 140000080-shields-richmond-nursing-center | SHIELDS RICHMOND NURSING CENTER | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
629958 | 629958 | 2020-08-18 | 140000733 | 140000733-stonebrook-healthcare-center | STONEBROOK HEALTHCARE CENTER | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
629960 | 629960 | 2020-08-18 | 140001185 | 140001185-the-reutlinger-community | THE REUTLINGER COMMUNITY | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
629962 | 629962 | 2020-08-18 | 140000083 | 140000083-walnut-creek-skilled-nursing-rehabilitation-center | WALNUT CREEK SKILLED NURSING & REHABILITATION CENTER | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
629963 | 629963 | 2020-08-18 | 140000121 | 140000121-willow-pass-healthcare-center | WILLOW PASS HEALTHCARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
629965 | 629965 | 2020-08-18 | 140000082 | 140000082-windsor-rosewood-care-center | WINDSOR ROSEWOOD CARE CENTER | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
629966 | 629966 | 2020-08-18 | 10000004 | 010000004-crescent-city-skilled-nursing | CRESCENT CITY SKILLED NURSING | Del Norte | 0 | 0 | 0 | 0 | 15 | ||||
629968 | 629968 | 2020-08-18 | 30000063 | 030000063-gold-country-health-center | GOLD COUNTRY HEALTH CENTER | El Dorado | 1 | 0 | 0 | 0 | 17 | <11 | |||
629969 | 629969 | 2020-08-18 | 30001064 | 030001064-marshall-medical-center-d-p-snf | MARSHALL MEDICAL CENTER D/P SNF | El Dorado | 0 | 0 | 0 | 0 | 17 | ||||
629970 | 629970 | 2020-08-18 | 30000085 | 030000085-the-pines-at-placerville-healthcare-center | THE PINES AT PLACERVILLE HEALTHCARE CENTER | El Dorado | 1 | 0 | 0 | 0 | 17 | <11 | |||
629971 | 629971 | 2020-08-18 | 30000047 | 030000047-western-slope-health-center | WESTERN SLOPE HEALTH CENTER | El Dorado | 1 | 0 | 0 | 0 | 17 | <11 | |||
629972 | 629972 | 2020-08-18 | 40000015 | 040000015-bethel-lutheran-home-inc | BETHEL LUTHERAN HOME, INC. | Fresno | 23 | 30 | 0 | 1 | 19 | <11 | |||
629973 | 629973 | 2020-08-18 | 40000013 | 040000013-california-home-for-the-aged-inc | CALIFORNIA HOME FOR THE AGED, INC. | Fresno | 15 | 15 | 0 | 1 | 19 | <11 | |||
629978 | 629978 | 2020-08-18 | 40000033 | 040000033-dycora-transitional-health-fowler | DYCORA TRANSITIONAL HEALTH - FOWLER | Fresno | 1 | 0 | 0 | 0 | 19 | <11 | |||
629979 | 629979 | 2020-08-18 | 40000007 | 040000007-dycora-transitional-health-fresno | DYCORA TRANSITIONAL HEALTH - FRESNO | Fresno | 37 | 118 | 1 | 33 | 19 | <11 | |||
629980 | 629980 | 2020-08-18 | 40000049 | 040000049-dycora-transitional-health-manchester | DYCORA TRANSITIONAL HEALTH - MANCHESTER | Fresno | 1 | 20 | 0 | 1 | 19 | <11 | <11 | ||
629981 | 629981 | 2020-08-18 | 40000026 | 040000026-dycora-transitional-health-memory-care-of-fresno | DYCORA TRANSITIONAL HEALTH - MEMORY CARE OF FRESNO | Fresno | 1 | 13 | 0 | 1 | 19 | <11 | <11 | ||
629982 | 629982 | 2020-08-18 | 40000067 | 040000067-dycora-transitional-health-reedley | DYCORA TRANSITIONAL HEALTH - REEDLEY | Fresno | 23 | 14 | 0 | 1 | 19 | <11 | |||
629989 | 629989 | 2020-08-18 | 40000014 | 040000014-horizon-health-and-subacute-center | HORIZON HEALTH AND SUBACUTE CENTER | Fresno | 17 | 14 | 0 | 1 | 19 | <11 | |||
629990 | 629990 | 2020-08-18 | 40000002 | 040000002-kingsburg-center | KINGSBURG CENTER | Fresno | 23 | 28 | 0 | 1 | 19 | <11 | |||
629991 | 629991 | 2020-08-18 | 40000036 | 040000036-manning-gardens-care-center-inc | MANNING GARDENS CARE CENTER, INC. | Fresno | 1 | 0 | 0 | 0 | 19 | <11 |
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 );