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
776,631 rows sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | 2022-01-15 | 140000321 | 140000321-alameda-county-medical-center-d-p-snf | ALAMEDA COUNTY MEDICAL CENTER D/P SNF | Alameda | 45 | 38 | 0 | 0 | 1 | ||||
2 | 2 | 2022-01-15 | 20000043 | 020000043-alameda-healthcare-wellness-center | ALAMEDA HEALTHCARE & WELLNESS CENTER | Alameda | 47 | 86 | 0 | 1 | 1 | <11 | |||
3 | 3 | 2022-01-15 | 630011864 | 630011864-alameda-hospital-southshore-convalescent | ALAMEDA HOSPITAL - SOUTHSHORE CONVALESCENT | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
4 | 4 | 2022-01-15 | 140000686 | 140000686-alameda-hospital-d-p-snf | ALAMEDA HOSPITAL D/P SNF | Alameda | 12 | 1 | 0 | 0 | 1 | <11 | |||
5 | 5 | 2022-01-15 | 630013891 | 630013891-all-saint-s-maubert | ALL SAINT'S MAUBERT | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
6 | 6 | 2022-01-15 | 20000070 | 020000070-all-saints-subacute-transitional-care | ALL SAINTS SUBACUTE & TRANSITIONAL CARE | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
7 | 7 | 2022-01-15 | 20000010 | 020000010-ashby-care-center | ASHBY CARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
8 | 8 | 2022-01-15 | 140001291 | 140001291-avondale-villa-post-acute | AVONDALE VILLA POST-ACUTE | Alameda | 18 | 22 | 0 | 1 | 1 | <11 | |||
9 | 9 | 2022-01-15 | 20000015 | 020000015-bancroft-healthcare-center | BANCROFT HEALTHCARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
10 | 10 | 2022-01-15 | 20000135 | 020000135-bay-area-healthcare-center | BAY AREA HEALTHCARE CENTER | Alameda | 27 | 1 | 0 | 1 | 1 | <11 | <11 | ||
11 | 11 | 2022-01-15 | 20000026 | 020000026-bay-view-rehabilitation-hospital-llc | BAY VIEW REHABILITATION HOSPITAL, LLC | Alameda | 71 | 141 | 0 | 1 | 1 | <11 | |||
12 | 12 | 2022-01-15 | 20000060 | 020000060-baypoint-healthcare-center | BAYPOINT HEALTHCARE CENTER | Alameda | 15 | 19 | 0 | 1 | 1 | <11 | |||
13 | 13 | 2022-01-15 | 630011713 | 630011713-baywood-court-health-center | BAYWOOD COURT HEALTH CENTER | Alameda | 12 | 1 | 0 | 0 | 1 | <11 | |||
14 | 14 | 2022-01-15 | 20001250 | 020001250-bellaken-skilled-nursing-center | BELLAKEN SKILLED NURSING CENTER | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
15 | 15 | 2022-01-15 | 20000028 | 020000028-berkeley-pines-skilled-nursing-center | BERKELEY PINES SKILLED NURSING CENTER | Alameda | 1 | 20 | 0 | 1 | 1 | <11 | <11 | ||
16 | 16 | 2022-01-15 | 20000029 | 020000029-bethesda-home | BETHESDA HOME | Alameda | 20 | 29 | 0 | 1 | 1 | <11 | |||
17 | 17 | 2022-01-15 | 20000048 | 020000048-chaparral-house | CHAPARRAL HOUSE | Alameda | 14 | 1 | 0 | 0 | 1 | <11 | |||
18 | 18 | 2022-01-15 | 630015174 | 630015174-creekview-skilled-nursing | CREEKVIEW SKILLED NURSING | Alameda | 58 | 19 | 0 | 1 | 1 | <11 | |||
19 | 19 | 2022-01-15 | 20000053 | 020000053-crestwood-manor-fremont | CRESTWOOD MANOR - FREMONT | Alameda | 64 | 103 | 1 | 1 | 1 | <11 | <11 | ||
20 | 20 | 2022-01-15 | 20000129 | 020000129-crestwood-treatment-center | CRESTWOOD TREATMENT CENTER | Alameda | 32 | 25 | 0 | 0 | 1 | ||||
21 | 21 | 2022-01-15 | 20000087 | 020000087-crown-bay-nursing-rehabilitation-center | CROWN BAY NURSING & REHABILITATION CENTER | Alameda | 1 | 1 | 0 | 20 | 1 | <11 | <11 | ||
22 | 22 | 2022-01-15 | 20000133 | 020000133-driftwood-healthcare-center-hayward | DRIFTWOOD HEALTHCARE CENTER - HAYWARD | Alameda | 42 | 36 | 0 | 1 | 1 | <11 | |||
23 | 23 | 2022-01-15 | 20000116 | 020000116-east-bay-post-acute | EAST BAY POST-ACUTE | Alameda | 45 | 41 | 0 | 1 | 1 | <11 | |||
24 | 24 | 2022-01-15 | 20000128 | 020000128-elmwood-care-center | ELMWOOD CARE CENTER | Alameda | 31 | 59 | 0 | 1 | 1 | <11 | |||
25 | 25 | 2022-01-15 | 20000093 | 020000093-excell-health-care-center | EXCELL HEALTH CARE CENTER | Alameda | 52 | 83 | 0 | 1 | 1 | <11 | |||
26 | 26 | 2022-01-15 | 20000132 | 020000132-fremont-healthcare-center | FREMONT HEALTHCARE CENTER | Alameda | 26 | 50 | 0 | 1 | 1 | <11 | |||
27 | 27 | 2022-01-15 | 20000124 | 020000124-fruitvale-healthcare-center | FRUITVALE HEALTHCARE CENTER | Alameda | 81 | 129 | 0 | 13 | 1 | ||||
28 | 28 | 2022-01-15 | 20000125 | 020000125-garfield-neurobehavioral-center | GARFIELD NEUROBEHAVIORAL CENTER | Alameda | 59 | 52 | 0 | 1 | 1 | <11 | |||
29 | 29 | 2022-01-15 | 20000123 | 020000123-hayward-convalescent-hospital | HAYWARD CONVALESCENT HOSPITAL | Alameda | 34 | 28 | 0 | 1 | 1 | <11 | |||
30 | 30 | 2022-01-15 | 20000039 | 020000039-hayward-healthcare-wellness-center | HAYWARD HEALTHCARE & WELLNESS CENTER | Alameda | 52 | 60 | 1 | 1 | 1 | <11 | <11 | ||
31 | 31 | 2022-01-15 | 20000047 | 020000047-hayward-hills-health-care-center | HAYWARD HILLS HEALTH CARE CENTER | Alameda | 25 | 90 | 0 | 12 | 1 | ||||
32 | 32 | 2022-01-15 | 20000111 | 020000111-jones-convalescent-hospital | JONES CONVALESCENT HOSPITAL | Alameda | 13 | 1 | 0 | 0 | 1 | <11 | |||
33 | 33 | 2022-01-15 | 20000042 | 020000042-kaiser-permanente-post-acute-care-center | KAISER PERMANENTE POST-ACUTE CARE CENTER | Alameda | 106 | 24 | 1 | 1 | 1 | <11 | <11 | ||
34 | 34 | 2022-01-15 | 20000112 | 020000112-kyakameena-care-center | KYAKAMEENA CARE CENTER | Alameda | 20 | 1 | 0 | 0 | 1 | <11 | |||
35 | 35 | 2022-01-15 | 20000110 | 020000110-lake-merritt-healthcare-center-llc | LAKE MERRITT HEALTHCARE CENTER LLC | Alameda | 38 | 43 | 0 | 1 | 1 | <11 | |||
36 | 36 | 2022-01-15 | 20000114 | 020000114-lake-park-retirement-residence | LAKE PARK RETIREMENT RESIDENCE | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
37 | 37 | 2022-01-15 | 20000104 | 020000104-marina-garden-nursing-center | MARINA GARDEN NURSING CENTER | Alameda | 1 | 15 | 0 | 0 | 1 | <11 | |||
38 | 38 | 2022-01-15 | 20000040 | 020000040-masonic-home | MASONIC HOME | Alameda | 24 | 1 | 0 | 1 | 1 | <11 | <11 | ||
39 | 39 | 2022-01-15 | 20000099 | 020000099-mcclure-post-acute | MCCLURE POST ACUTE | Alameda | 17 | 1 | 0 | 0 | 1 | <11 | |||
40 | 40 | 2022-01-15 | 20000079 | 020000079-medical-hill-healthcare-center | MEDICAL HILL HEALTHCARE CENTER | Alameda | 43 | 52 | 0 | 0 | 1 | ||||
41 | 41 | 2022-01-15 | 20000100 | 020000100-mercy-retirement-care-center | MERCY RETIREMENT & CARE CENTER | Alameda | 29 | 23 | 0 | 12 | 1 | ||||
42 | 42 | 2022-01-15 | 20000808 | 020000808-morton-bakar-center | MORTON BAKAR CENTER | Alameda | 40 | 48 | 0 | 1 | 1 | <11 | |||
43 | 43 | 2022-01-15 | 20000101 | 020000101-niles-canyon-post-acute | NILES CANYON POST ACUTE | Alameda | 22 | 36 | 0 | 1 | 1 | <11 | |||
44 | 44 | 2022-01-15 | 20000115 | 020000115-oakland-healthcare-wellness-center | OAKLAND HEALTHCARE & WELLNESS CENTER | Alameda | 74 | 97 | 0 | 1 | 1 | <11 | |||
45 | 45 | 2022-01-15 | 20000880 | 020000880-oakland-heights-nursing-and-rehabilitation | OAKLAND HEIGHTS NURSING AND REHABILITATION | Alameda | 13 | 1 | 0 | 0 | 1 | <11 | |||
46 | 46 | 2022-01-15 | 630014635 | 630014635-park-bridge-rehabilitation-and-wellness-center | PARK BRIDGE REHABILITATION AND WELLNESS CENTER | Alameda | 69 | 97 | 0 | 1 | 1 | <11 | |||
47 | 47 | 2022-01-15 | 20000094 | 020000094-park-central-care-and-rehabilitation-center | PARK CENTRAL CARE AND REHABILITATION CENTER | Alameda | 13 | 1 | 0 | 0 | 1 | <11 | |||
48 | 48 | 2022-01-15 | 20000090 | 020000090-parkview-healthcare-center | PARKVIEW HEALTHCARE CENTER | Alameda | 46 | 113 | 1 | 18 | 1 | <11 | |||
49 | 49 | 2022-01-15 | 20000091 | 020000091-piedmont-gardens-health-facility | PIEDMONT GARDENS HEALTH FACILITY | Alameda | 21 | 23 | 0 | 1 | 1 | <11 | |||
50 | 50 | 2022-01-15 | 140000086 | 140000086-pleasanton-nursing-and-rehabilitation-center | PLEASANTON NURSING AND REHABILITATION CENTER | Alameda | 76 | 61 | 1 | 12 | 1 | <11 | |||
51 | 51 | 2022-01-15 | 20000054 | 020000054-princeton-manor-healthcare-center-llc | PRINCETON MANOR HEALTHCARE CENTER, LLC | Alameda | 37 | 55 | 0 | 1 | 1 | <11 | |||
52 | 52 | 2022-01-15 | 20000276 | 020000276-redwood-convalescent-hospital-inc | REDWOOD CONVALESCENT HOSPITAL, INC. | Alameda | 26 | 24 | 0 | 1 | 1 | <11 | |||
53 | 53 | 2022-01-15 | 20000119 | 020000119-redwood-healthcare-center-llc | REDWOOD HEALTHCARE CENTER LLC | Alameda | 23 | 30 | 0 | 1 | 1 | <11 | |||
54 | 54 | 2022-01-15 | 20000077 | 020000077-san-leandro-healthcare-center | SAN LEANDRO HEALTHCARE CENTER | Alameda | 31 | 32 | 0 | 1 | 1 | <11 | |||
55 | 55 | 2022-01-15 | 20000074 | 020000074-serenethos-care-center-llc | SERENETHOS CARE CENTER, LLC | Alameda | 17 | 29 | 0 | 1 | 1 | <11 | |||
56 | 56 | 2022-01-15 | 20000005 | 020000005-st-anthony-care-center | ST ANTHONY CARE CENTER | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
57 | 57 | 2022-01-15 | 20000076 | 020000076-st-francis-healthcare-center | ST FRANCIS HEALTHCARE CENTER | Alameda | 14 | 33 | 0 | 1 | 1 | <11 | |||
58 | 58 | 2022-01-15 | 20000068 | 020000068-st-john-kronstadt-convalescent-center | ST JOHN KRONSTADT CONVALESCENT CENTER | Alameda | 14 | 0 | 0 | 0 | 1 | ||||
59 | 59 | 2022-01-15 | 20000064 | 020000064-st-pauls-towers | ST PAULS TOWERS | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
60 | 60 | 2022-01-15 | 20000037 | 020000037-st-patrick-s-post-acute | ST. PATRICK'S POST ACUTE | Alameda | 35 | 50 | 0 | 19 | 1 | ||||
61 | 61 | 2022-01-15 | 630014957 | 630014957-stratford-villa-post-acute | STRATFORD VILLA POST-ACUTE | Alameda | 15 | 26 | 0 | 1 | 1 | <11 | |||
62 | 62 | 2022-01-15 | 20000274 | 020000274-the-rehabilitation-center-of-oakland | THE REHABILITATION CENTER OF OAKLAND | Alameda | 32 | 37 | 0 | 1 | 1 | <11 | |||
63 | 63 | 2022-01-15 | 140000122 | 140000122-the-vineyards-healthcare-center | THE VINEYARDS HEALTHCARE CENTER | Alameda | 46 | 55 | 0 | 1 | 1 | <11 | |||
64 | 64 | 2022-01-15 | 140000626 | 140000626-valley-memorial-hospital-d-p-snf | VALLEY MEMORIAL HOSPITAL D/P SNF | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
65 | 65 | 2022-01-15 | 20000066 | 020000066-valley-pointe-nursing-rehabilitation-center | VALLEY POINTE NURSING & REHABILITATION CENTER | Alameda | 38 | 49 | 0 | 1 | 1 | <11 | |||
66 | 66 | 2022-01-15 | 20000019 | 020000019-vista-post-acute | VISTA POST ACUTE | Alameda | 49 | 64 | 0 | 1 | 1 | <11 | |||
67 | 67 | 2022-01-15 | 20000275 | 020000275-washington-center | WASHINGTON CENTER | Alameda | 50 | 34 | 0 | 1 | 1 | <11 | |||
68 | 68 | 2022-01-15 | 20000065 | 020000065-we-care-skilled-nursing-facility | WE CARE SKILLED NURSING FACILITY | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
69 | 69 | 2022-01-15 | 20000020 | 020000020-windsor-country-drive-care-center | WINDSOR COUNTRY DRIVE CARE CENTER | Alameda | 83 | 97 | 0 | 1 | 1 | <11 | |||
70 | 70 | 2022-01-15 | 20000103 | 020000103-windsor-gardens-care-center-of-hayward | WINDSOR GARDENS CARE CENTER OF HAYWARD | Alameda | 43 | 58 | 0 | 1 | 1 | <11 | |||
71 | 71 | 2022-01-15 | 20000277 | 020000277-windsor-healthcare-center-of-oakland | WINDSOR HEALTHCARE CENTER OF OAKLAND | Alameda | 74 | 93 | 0 | 1 | 1 | <11 | |||
72 | 72 | 2022-01-15 | 20000036 | 020000036-windsor-park-care-center-of-fremont | WINDSOR PARK CARE CENTER OF FREMONT | Alameda | 36 | 37 | 0 | 1 | 1 | <11 | |||
73 | 73 | 2022-01-15 | 20000071 | 020000071-windsor-post-acute-care-center-of-hayward | WINDSOR POST-ACUTE CARE CENTER OF HAYWARD | Alameda | 75 | 89 | 0 | 1 | 1 | <11 | |||
1224 | 1224 | 2022-01-14 | 140000321 | 140000321-alameda-county-medical-center-d-p-snf | ALAMEDA COUNTY MEDICAL CENTER D/P SNF | Alameda | 45 | 38 | 0 | 0 | 1 | ||||
1225 | 1225 | 2022-01-14 | 20000043 | 020000043-alameda-healthcare-wellness-center | ALAMEDA HEALTHCARE & WELLNESS CENTER | Alameda | 47 | 86 | 0 | 1 | 1 | <11 | |||
1226 | 1226 | 2022-01-14 | 630011864 | 630011864-alameda-hospital-southshore-convalescent | ALAMEDA HOSPITAL - SOUTHSHORE CONVALESCENT | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
1227 | 1227 | 2022-01-14 | 140000686 | 140000686-alameda-hospital-d-p-snf | ALAMEDA HOSPITAL D/P SNF | Alameda | 12 | 1 | 0 | 0 | 1 | <11 | |||
1228 | 1228 | 2022-01-14 | 630013891 | 630013891-all-saint-s-maubert | ALL SAINT'S MAUBERT | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
1229 | 1229 | 2022-01-14 | 20000070 | 020000070-all-saints-subacute-transitional-care | ALL SAINTS SUBACUTE & TRANSITIONAL CARE | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
1230 | 1230 | 2022-01-14 | 20000010 | 020000010-ashby-care-center | ASHBY CARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
1231 | 1231 | 2022-01-14 | 140001291 | 140001291-avondale-villa-post-acute | AVONDALE VILLA POST-ACUTE | Alameda | 18 | 22 | 0 | 1 | 1 | <11 | |||
1232 | 1232 | 2022-01-14 | 20000015 | 020000015-bancroft-healthcare-center | BANCROFT HEALTHCARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
1233 | 1233 | 2022-01-14 | 20000135 | 020000135-bay-area-healthcare-center | BAY AREA HEALTHCARE CENTER | Alameda | 27 | 1 | 0 | 1 | 1 | <11 | <11 | ||
1234 | 1234 | 2022-01-14 | 20000026 | 020000026-bay-view-rehabilitation-hospital-llc | BAY VIEW REHABILITATION HOSPITAL, LLC | Alameda | 71 | 141 | 0 | 1 | 1 | <11 | |||
1235 | 1235 | 2022-01-14 | 20000060 | 020000060-baypoint-healthcare-center | BAYPOINT HEALTHCARE CENTER | Alameda | 15 | 19 | 0 | 1 | 1 | <11 | |||
1236 | 1236 | 2022-01-14 | 630011713 | 630011713-baywood-court-health-center | BAYWOOD COURT HEALTH CENTER | Alameda | 12 | 1 | 0 | 0 | 1 | <11 | |||
1237 | 1237 | 2022-01-14 | 20001250 | 020001250-bellaken-skilled-nursing-center | BELLAKEN SKILLED NURSING CENTER | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
1238 | 1238 | 2022-01-14 | 20000028 | 020000028-berkeley-pines-skilled-nursing-center | BERKELEY PINES SKILLED NURSING CENTER | Alameda | 1 | 20 | 0 | 1 | 1 | <11 | <11 | ||
1239 | 1239 | 2022-01-14 | 20000029 | 020000029-bethesda-home | BETHESDA HOME | Alameda | 20 | 29 | 0 | 1 | 1 | <11 | |||
1240 | 1240 | 2022-01-14 | 20000048 | 020000048-chaparral-house | CHAPARRAL HOUSE | Alameda | 14 | 1 | 0 | 0 | 1 | <11 | |||
1241 | 1241 | 2022-01-14 | 630015174 | 630015174-creekview-skilled-nursing | CREEKVIEW SKILLED NURSING | Alameda | 58 | 19 | 0 | 1 | 1 | <11 | |||
1242 | 1242 | 2022-01-14 | 20000053 | 020000053-crestwood-manor-fremont | CRESTWOOD MANOR - FREMONT | Alameda | 64 | 103 | 1 | 1 | 1 | <11 | <11 | ||
1243 | 1243 | 2022-01-14 | 20000129 | 020000129-crestwood-treatment-center | CRESTWOOD TREATMENT CENTER | Alameda | 32 | 25 | 0 | 0 | 1 | ||||
1244 | 1244 | 2022-01-14 | 20000087 | 020000087-crown-bay-nursing-rehabilitation-center | CROWN BAY NURSING & REHABILITATION CENTER | Alameda | 1 | 1 | 0 | 20 | 1 | <11 | <11 | ||
1245 | 1245 | 2022-01-14 | 20000133 | 020000133-driftwood-healthcare-center-hayward | DRIFTWOOD HEALTHCARE CENTER - HAYWARD | Alameda | 42 | 36 | 0 | 1 | 1 | <11 | |||
1246 | 1246 | 2022-01-14 | 20000116 | 020000116-east-bay-post-acute | EAST BAY POST-ACUTE | Alameda | 45 | 41 | 0 | 1 | 1 | <11 | |||
1247 | 1247 | 2022-01-14 | 20000128 | 020000128-elmwood-care-center | ELMWOOD CARE CENTER | Alameda | 31 | 59 | 0 | 1 | 1 | <11 | |||
1248 | 1248 | 2022-01-14 | 20000093 | 020000093-excell-health-care-center | EXCELL HEALTH CARE CENTER | Alameda | 52 | 83 | 0 | 1 | 1 | <11 | |||
1249 | 1249 | 2022-01-14 | 20000132 | 020000132-fremont-healthcare-center | FREMONT HEALTHCARE CENTER | Alameda | 26 | 50 | 0 | 1 | 1 | <11 | |||
1250 | 1250 | 2022-01-14 | 20000124 | 020000124-fruitvale-healthcare-center | FRUITVALE HEALTHCARE CENTER | Alameda | 81 | 129 | 0 | 13 | 1 |
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 );