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 2021-07-23 sorted by staff_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
215250 | 215250 | 2021-07-23 | 140000321 | 140000321-alameda-county-medical-center-d-p-snf | ALAMEDA COUNTY MEDICAL CENTER D/P SNF | Alameda | 11 | 15 | 0 | 0 | 1 | ||||
215251 | 215251 | 2021-07-23 | 20000043 | 020000043-alameda-healthcare-wellness-center | ALAMEDA HEALTHCARE & WELLNESS CENTER | Alameda | 44 | 85 | 0 | 1 | 1 | <11 | |||
215257 | 215257 | 2021-07-23 | 140001291 | 140001291-avondale-villa-post-acute | AVONDALE VILLA POST-ACUTE | Alameda | 15 | 22 | 0 | 1 | 1 | <11 | |||
215259 | 215259 | 2021-07-23 | 20000135 | 020000135-bay-area-healthcare-center | BAY AREA HEALTHCARE CENTER | Alameda | 13 | 1 | 0 | 1 | 1 | <11 | <11 | ||
215260 | 215260 | 2021-07-23 | 20000026 | 020000026-bay-view-rehabilitation-hospital-llc | BAY VIEW REHABILITATION HOSPITAL, LLC | Alameda | 59 | 137 | 0 | 1 | 1 | <11 | |||
215261 | 215261 | 2021-07-23 | 20000060 | 020000060-baypoint-healthcare-center | BAYPOINT HEALTHCARE CENTER | Alameda | 13 | 1 | 0 | 0 | 1 | <11 | |||
215265 | 215265 | 2021-07-23 | 20000029 | 020000029-bethesda-home | BETHESDA HOME | Alameda | 19 | 29 | 0 | 1 | 1 | <11 | |||
215267 | 215267 | 2021-07-23 | 630015174 | 630015174-creekview-skilled-nursing | CREEKVIEW SKILLED NURSING | Alameda | 36 | 17 | 0 | 1 | 1 | <11 | |||
215268 | 215268 | 2021-07-23 | 20000053 | 020000053-crestwood-manor-fremont | CRESTWOOD MANOR - FREMONT | Alameda | 48 | 101 | 1 | 1 | 1 | <11 | <11 | ||
215269 | 215269 | 2021-07-23 | 20000129 | 020000129-crestwood-treatment-center | CRESTWOOD TREATMENT CENTER | Alameda | 19 | 25 | 0 | 0 | 1 | ||||
215271 | 215271 | 2021-07-23 | 20000133 | 020000133-driftwood-healthcare-center-hayward | DRIFTWOOD HEALTHCARE CENTER - HAYWARD | Alameda | 27 | 36 | 0 | 1 | 1 | <11 | |||
215272 | 215272 | 2021-07-23 | 20000116 | 020000116-east-bay-post-acute | EAST BAY POST-ACUTE | Alameda | 39 | 37 | 0 | 1 | 1 | <11 | |||
215273 | 215273 | 2021-07-23 | 20000128 | 020000128-elmwood-care-center | ELMWOOD CARE CENTER | Alameda | 25 | 55 | 0 | 1 | 1 | <11 | |||
215274 | 215274 | 2021-07-23 | 20000093 | 020000093-excell-health-care-center | EXCELL HEALTH CARE CENTER | Alameda | 31 | 63 | 0 | 1 | 1 | <11 | |||
215275 | 215275 | 2021-07-23 | 20000132 | 020000132-fremont-healthcare-center | FREMONT HEALTHCARE CENTER | Alameda | 13 | 48 | 0 | 1 | 1 | <11 | |||
215276 | 215276 | 2021-07-23 | 20000124 | 020000124-fruitvale-healthcare-center | FRUITVALE HEALTHCARE CENTER | Alameda | 77 | 128 | 0 | 13 | 1 | ||||
215277 | 215277 | 2021-07-23 | 20000125 | 020000125-garfield-neurobehavioral-center | GARFIELD NEUROBEHAVIORAL CENTER | Alameda | 51 | 45 | 0 | 1 | 1 | <11 | |||
215278 | 215278 | 2021-07-23 | 20000123 | 020000123-hayward-convalescent-hospital | HAYWARD CONVALESCENT HOSPITAL | Alameda | 33 | 28 | 0 | 1 | 1 | <11 | |||
215279 | 215279 | 2021-07-23 | 20000039 | 020000039-hayward-healthcare-wellness-center | HAYWARD HEALTHCARE & WELLNESS CENTER | Alameda | 48 | 59 | 1 | 1 | 1 | <11 | <11 | ||
215280 | 215280 | 2021-07-23 | 20000047 | 020000047-hayward-hills-health-care-center | HAYWARD HILLS HEALTH CARE CENTER | Alameda | 19 | 90 | 0 | 12 | 1 | ||||
215281 | 215281 | 2021-07-23 | 20000111 | 020000111-jones-convalescent-hospital | JONES CONVALESCENT HOSPITAL | Alameda | 11 | 1 | 0 | 0 | 1 | <11 | |||
215282 | 215282 | 2021-07-23 | 20000042 | 020000042-kaiser-permanente-post-acute-care-center | KAISER PERMANENTE POST-ACUTE CARE CENTER | Alameda | 61 | 20 | 1 | 1 | 1 | <11 | <11 | ||
215283 | 215283 | 2021-07-23 | 20000112 | 020000112-kyakameena-care-center | KYAKAMEENA CARE CENTER | Alameda | 15 | 1 | 0 | 0 | 1 | <11 | |||
215284 | 215284 | 2021-07-23 | 20000110 | 020000110-lake-merritt-healthcare-center-llc | LAKE MERRITT HEALTHCARE CENTER LLC | Alameda | 17 | 1 | 0 | 0 | 1 | <11 | |||
215287 | 215287 | 2021-07-23 | 20000040 | 020000040-masonic-home | MASONIC HOME | Alameda | 19 | 1 | 0 | 1 | 1 | <11 | <11 | ||
215289 | 215289 | 2021-07-23 | 20000079 | 020000079-medical-hill-healthcare-center | MEDICAL HILL HEALTHCARE CENTER | Alameda | 43 | 52 | 0 | 0 | 1 | ||||
215290 | 215290 | 2021-07-23 | 20000100 | 020000100-mercy-retirement-care-center | MERCY RETIREMENT & CARE CENTER | Alameda | 23 | 20 | 0 | 12 | 1 | ||||
215291 | 215291 | 2021-07-23 | 20000808 | 020000808-morton-bakar-center | MORTON BAKAR CENTER | Alameda | 36 | 48 | 0 | 1 | 1 | <11 | |||
215292 | 215292 | 2021-07-23 | 20000101 | 020000101-niles-canyon-post-acute | NILES CANYON POST ACUTE | Alameda | 19 | 36 | 0 | 1 | 1 | <11 | |||
215293 | 215293 | 2021-07-23 | 20000115 | 020000115-oakland-healthcare-wellness-center | OAKLAND HEALTHCARE & WELLNESS CENTER | Alameda | 56 | 88 | 0 | 1 | 1 | <11 | |||
215295 | 215295 | 2021-07-23 | 630014635 | 630014635-park-bridge-rehabilitation-and-wellness-center | PARK BRIDGE REHABILITATION AND WELLNESS CENTER | Alameda | 58 | 89 | 0 | 1 | 1 | <11 | |||
215297 | 215297 | 2021-07-23 | 20000090 | 020000090-parkview-healthcare-center | PARKVIEW HEALTHCARE CENTER | Alameda | 36 | 111 | 1 | 18 | 1 | <11 | |||
215298 | 215298 | 2021-07-23 | 20000091 | 020000091-piedmont-gardens-health-facility | PIEDMONT GARDENS HEALTH FACILITY | Alameda | 20 | 23 | 0 | 1 | 1 | <11 | |||
215299 | 215299 | 2021-07-23 | 140000086 | 140000086-pleasanton-nursing-and-rehabilitation-center | PLEASANTON NURSING AND REHABILITATION CENTER | Alameda | 64 | 52 | 1 | 12 | 1 | <11 | |||
215300 | 215300 | 2021-07-23 | 20000054 | 020000054-princeton-manor-healthcare-center-llc | PRINCETON MANOR HEALTHCARE CENTER, LLC | Alameda | 25 | 32 | 0 | 1 | 1 | <11 | |||
215301 | 215301 | 2021-07-23 | 20000276 | 020000276-redwood-convalescent-hospital-inc | REDWOOD CONVALESCENT HOSPITAL, INC. | Alameda | 11 | 24 | 0 | 1 | 1 | <11 | |||
215302 | 215302 | 2021-07-23 | 20000119 | 020000119-redwood-healthcare-center-llc | REDWOOD HEALTHCARE CENTER LLC | Alameda | 23 | 30 | 0 | 1 | 1 | <11 | |||
215303 | 215303 | 2021-07-23 | 20000077 | 020000077-san-leandro-healthcare-center | SAN LEANDRO HEALTHCARE CENTER | Alameda | 30 | 32 | 0 | 1 | 1 | <11 | |||
215304 | 215304 | 2021-07-23 | 20000074 | 020000074-serenethos-care-center-llc | SERENETHOS CARE CENTER, LLC | Alameda | 16 | 29 | 0 | 1 | 1 | <11 | |||
215306 | 215306 | 2021-07-23 | 20000076 | 020000076-st-francis-healthcare-center | ST FRANCIS HEALTHCARE CENTER | Alameda | 12 | 33 | 0 | 1 | 1 | <11 | |||
215309 | 215309 | 2021-07-23 | 20000037 | 020000037-st-patrick-s-post-acute | ST. PATRICK'S POST ACUTE | Alameda | 35 | 50 | 0 | 19 | 1 | ||||
215310 | 215310 | 2021-07-23 | 630014957 | 630014957-stratford-villa-post-acute | STRATFORD VILLA POST-ACUTE | Alameda | 15 | 26 | 0 | 1 | 1 | <11 | |||
215311 | 215311 | 2021-07-23 | 20000274 | 020000274-the-rehabilitation-center-of-oakland | THE REHABILITATION CENTER OF OAKLAND | Alameda | 21 | 37 | 0 | 1 | 1 | <11 | |||
215312 | 215312 | 2021-07-23 | 140000122 | 140000122-the-vineyards-healthcare-center | THE VINEYARDS HEALTHCARE CENTER | Alameda | 38 | 54 | 0 | 1 | 1 | <11 | |||
215313 | 215313 | 2021-07-23 | 140000626 | 140000626-valley-memorial-hospital-d-p-snf | VALLEY MEMORIAL HOSPITAL D/P SNF | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
215314 | 215314 | 2021-07-23 | 20000066 | 020000066-valley-pointe-nursing-rehabilitation-center | VALLEY POINTE NURSING & REHABILITATION CENTER | Alameda | 26 | 32 | 0 | 1 | 1 | <11 | |||
215315 | 215315 | 2021-07-23 | 20000019 | 020000019-vista-post-acute | VISTA POST ACUTE | Alameda | 39 | 59 | 0 | 1 | 1 | <11 | |||
215316 | 215316 | 2021-07-23 | 20000275 | 020000275-washington-center | WASHINGTON CENTER | Alameda | 37 | 34 | 0 | 1 | 1 | <11 | |||
215318 | 215318 | 2021-07-23 | 20000020 | 020000020-windsor-country-drive-care-center | WINDSOR COUNTRY DRIVE CARE CENTER | Alameda | 75 | 94 | 0 | 1 | 1 | <11 | |||
215319 | 215319 | 2021-07-23 | 20000103 | 020000103-windsor-gardens-care-center-of-hayward | WINDSOR GARDENS CARE CENTER OF HAYWARD | Alameda | 37 | 57 | 0 | 1 | 1 | <11 | |||
215320 | 215320 | 2021-07-23 | 20000277 | 020000277-windsor-healthcare-center-of-oakland | WINDSOR HEALTHCARE CENTER OF OAKLAND | Alameda | 54 | 87 | 0 | 1 | 1 | <11 | |||
215321 | 215321 | 2021-07-23 | 20000036 | 020000036-windsor-park-care-center-of-fremont | WINDSOR PARK CARE CENTER OF FREMONT | Alameda | 29 | 37 | 0 | 1 | 1 | <11 | |||
215322 | 215322 | 2021-07-23 | 20000071 | 020000071-windsor-post-acute-care-center-of-hayward | WINDSOR POST-ACUTE CARE CENTER OF HAYWARD | Alameda | 66 | 87 | 0 | 1 | 1 | <11 | |||
215323 | 215323 | 2021-07-23 | 30000074 | 030000074-kit-carson-nursing-rehabilitation-center | KIT CARSON NURSING & REHABILITATION CENTER | Amador | 29 | 61 | 0 | 17 | 5 | ||||
215324 | 215324 | 2021-07-23 | 230000255 | 230000255-arbor-post-acute | ARBOR POST ACUTE | Butte | 68 | 105 | 0 | 12 | 7 | ||||
215325 | 215325 | 2021-07-23 | 230000546 | 230000546-california-park-rehabilitation-hospital | CALIFORNIA PARK REHABILITATION HOSPITAL | Butte | 24 | 1 | 0 | 1 | 7 | <11 | <11 | ||
215326 | 215326 | 2021-07-23 | 230000802 | 230000802-country-crest-post-acute | COUNTRY CREST POST ACUTE | Butte | 14 | 1 | 0 | 0 | 7 | <11 | |||
215327 | 215327 | 2021-07-23 | 230000327 | 230000327-orchard-hospital-d-p-snf | ORCHARD HOSPITAL D/P SNF | Butte | 38 | 48 | 0 | 13 | 7 | ||||
215328 | 215328 | 2021-07-23 | 230000221 | 230000221-oroville-hospital-post-acute-center | OROVILLE HOSPITAL POST-ACUTE CENTER | Butte | 64 | 109 | 0 | 1 | 7 | <11 | |||
215329 | 215329 | 2021-07-23 | 230000036 | 230000036-riverside-convalescent-hospital | RIVERSIDE CONVALESCENT HOSPITAL | Butte | 73 | 87 | 0 | 13 | 7 | ||||
215331 | 215331 | 2021-07-23 | 230000025 | 230000025-windsor-chico-care-center | WINDSOR CHICO CARE CENTER | Butte | 19 | 36 | 0 | 1 | 7 | <11 | |||
215332 | 215332 | 2021-07-23 | 230000029 | 230000029-windsor-chico-creek-care-and-rehabilitation-center | WINDSOR CHICO CREEK CARE AND REHABILITATION CENTER | Butte | 39 | 68 | 0 | 1 | 7 | <11 | |||
215333 | 215333 | 2021-07-23 | 30000012 | 030000012-avalon-health-care-san-andreas | AVALON HEALTH CARE - SAN ANDREAS | Calaveras | 25 | 58 | 0 | 1 | 9 | <11 | |||
215334 | 215334 | 2021-07-23 | 230000424 | 230000424-colusa-medical-center-snf | COLUSA MEDICAL CENTER - SNF | Colusa | 20 | 26 | 0 | 1 | 11 | <11 | |||
215335 | 215335 | 2021-07-23 | 230000283 | 230000283-valley-west-post-acute | VALLEY WEST POST ACUTE | Colusa | 57 | 32 | 0 | 1 | 11 | <11 | |||
215336 | 215336 | 2021-07-23 | 140000574 | 140000574-alhambra-convalescent-hospital | ALHAMBRA CONVALESCENT HOSPITAL | Contra Costa | 17 | 11 | 0 | 1 | 13 | <11 | |||
215337 | 215337 | 2021-07-23 | 140000023 | 140000023-bayberry-skilled-nursing-healthcare-center | BAYBERRY SKILLED NURSING & HEALTHCARE CENTER | Contra Costa | 46 | 65 | 0 | 1 | 13 | <11 | |||
215338 | 215338 | 2021-07-23 | 140000138 | 140000138-creekside-healthcare-center | CREEKSIDE HEALTHCARE CENTER | Contra Costa | 18 | 1 | 0 | 0 | 13 | <11 | |||
215339 | 215339 | 2021-07-23 | 140000130 | 140000130-danville-post-acute-rehab | DANVILLE POST-ACUTE REHAB | Contra Costa | 16 | 12 | 0 | 1 | 13 | <11 | |||
215340 | 215340 | 2021-07-23 | 140000003 | 140000003-delta-view-post-acute | DELTA VIEW POST ACUTE | Contra Costa | 27 | 53 | 0 | 1 | 13 | <11 | |||
215341 | 215341 | 2021-07-23 | 140000564 | 140000564-diamond-ridge-healthcare-center | DIAMOND RIDGE HEALTHCARE CENTER | Contra Costa | 19 | 22 | 0 | 1 | 13 | <11 | |||
215344 | 215344 | 2021-07-23 | 140000102 | 140000102-legacy-post-acute-care | LEGACY POST ACUTE CARE | Contra Costa | 48 | 77 | 0 | 1 | 13 | <11 | |||
215345 | 215345 | 2021-07-23 | 140000105 | 140000105-lone-tree-post-acute | LONE TREE POST ACUTE | Contra Costa | 23 | 44 | 0 | 1 | 13 | <11 | |||
215346 | 215346 | 2021-07-23 | 140000745 | 140000745-manorcare-health-services-rossmoor | MANORCARE HEALTH SERVICES - ROSSMOOR | Contra Costa | 23 | 61 | 0 | 1 | 13 | <11 | |||
215347 | 215347 | 2021-07-23 | 140001126 | 140001126-manorcare-health-services-tice-valley | MANORCARE HEALTH SERVICES - TICE VALLEY | Contra Costa | 50 | 116 | 0 | 21 | 13 | ||||
215349 | 215349 | 2021-07-23 | 140000081 | 140000081-moraga-post-acute | MORAGA POST ACUTE | Contra Costa | 17 | 38 | 0 | 0 | 13 | ||||
215350 | 215350 | 2021-07-23 | 140000092 | 140000092-orinda-care-center-llc | ORINDA CARE CENTER, LLC | Contra Costa | 40 | 40 | 0 | 1 | 13 | <11 | |||
215353 | 215353 | 2021-07-23 | 140000096 | 140000096-pleasant-hill-post-acute | PLEASANT HILL POST ACUTE | Contra Costa | 27 | 48 | 0 | 1 | 13 | <11 | |||
215355 | 215355 | 2021-07-23 | 140000136 | 140000136-san-miguel-villa | SAN MIGUEL VILLA | Contra Costa | 51 | 105 | 1 | 36 | 13 | <11 | |||
215356 | 215356 | 2021-07-23 | 140000030 | 140000030-san-pablo-healthcare-wellness-center | SAN PABLO HEALTHCARE & WELLNESS CENTER | Contra Costa | 44 | 63 | 0 | 1 | 13 | <11 | |||
215360 | 215360 | 2021-07-23 | 140000733 | 140000733-stonebrook-healthcare-center | STONEBROOK HEALTHCARE CENTER | Contra Costa | 20 | 1 | 0 | 0 | 13 | <11 | |||
215362 | 215362 | 2021-07-23 | 140001185 | 140001185-the-reutlinger-community | THE REUTLINGER COMMUNITY | Contra Costa | 15 | 1 | 0 | 0 | 13 | <11 | |||
215363 | 215363 | 2021-07-23 | 140000061 | 140000061-vale-healthcare-center | VALE HEALTHCARE CENTER | Contra Costa | 30 | 39 | 0 | 11 | 13 | ||||
215364 | 215364 | 2021-07-23 | 140000083 | 140000083-walnut-creek-skilled-nursing-rehabilitation-center | WALNUT CREEK SKILLED NURSING & REHABILITATION CENTER | Contra Costa | 28 | 17 | 0 | 1 | 13 | <11 | |||
215365 | 215365 | 2021-07-23 | 140000121 | 140000121-willow-pass-healthcare-center | WILLOW PASS HEALTHCARE CENTER | Contra Costa | 16 | 52 | 0 | 1 | 13 | <11 | |||
215366 | 215366 | 2021-07-23 | 140000062 | 140000062-windsor-manor-rehabilitation-center-of-concord | WINDSOR MANOR REHABILITATION CENTER OF CONCORD | Contra Costa | 63 | 144 | 1 | 15 | 13 | <11 | |||
215367 | 215367 | 2021-07-23 | 140000082 | 140000082-windsor-rosewood-care-center | WINDSOR ROSEWOOD CARE CENTER | Contra Costa | 21 | 0 | 0 | 0 | 13 | ||||
215368 | 215368 | 2021-07-23 | 10000004 | 010000004-crescent-city-skilled-nursing | CRESCENT CITY SKILLED NURSING | Del Norte | 24 | 1 | 0 | 0 | 15 | <11 | |||
215369 | 215369 | 2021-07-23 | 30001525 | 030001525-barton-hospital-d-p-snf | BARTON HOSPITAL D/P SNF | El Dorado | 23 | 1 | 0 | 0 | 17 | <11 | |||
215370 | 215370 | 2021-07-23 | 30000063 | 030000063-gold-country-health-center | GOLD COUNTRY HEALTH CENTER | El Dorado | 21 | 40 | 0 | 14 | 17 | ||||
215371 | 215371 | 2021-07-23 | 30001064 | 030001064-marshall-medical-center-d-p-snf | MARSHALL MEDICAL CENTER D/P SNF | El Dorado | 0 | 0 | 0 | 0 | 17 | ||||
215372 | 215372 | 2021-07-23 | 30000085 | 030000085-the-pines-at-placerville-healthcare-center | THE PINES AT PLACERVILLE HEALTHCARE CENTER | El Dorado | 94 | 71 | 0 | 18 | 17 | ||||
215373 | 215373 | 2021-07-23 | 30000047 | 030000047-western-slope-health-center | WESTERN SLOPE HEALTH CENTER | El Dorado | 69 | 76 | 0 | 1 | 17 | <11 | |||
215374 | 215374 | 2021-07-23 | 40000015 | 040000015-bethel-lutheran-home-inc | BETHEL LUTHERAN HOME, INC. | Fresno | 28 | 34 | 0 | 1 | 19 | <11 | |||
215375 | 215375 | 2021-07-23 | 40000013 | 040000013-california-home-for-the-aged-inc | CALIFORNIA HOME FOR THE AGED, INC. | Fresno | 82 | 23 | 0 | 1 | 19 | <11 | |||
215378 | 215378 | 2021-07-23 | 40000474 | 040000474-community-subacute-and-transitional-care-center | COMMUNITY SUBACUTE AND TRANSITIONAL CARE CENTER | Fresno | 50 | 17 | 0 | 1 | 19 | <11 | |||
215379 | 215379 | 2021-07-23 | 40000019 | 040000019-dycora-transitional-health-clovis | DYCORA TRANSITIONAL HEALTH - CLOVIS | Fresno | 21 | 28 | 0 | 1 | 19 | <11 | |||
215380 | 215380 | 2021-07-23 | 40000033 | 040000033-dycora-transitional-health-fowler | DYCORA TRANSITIONAL HEALTH - FOWLER | Fresno | 28 | 37 | 0 | 1 | 19 | <11 | |||
215381 | 215381 | 2021-07-23 | 40000007 | 040000007-dycora-transitional-health-fresno | DYCORA TRANSITIONAL HEALTH - FRESNO | Fresno | 99 | 218 | 1 | 49 | 19 | <11 | |||
215382 | 215382 | 2021-07-23 | 40000049 | 040000049-dycora-transitional-health-manchester | DYCORA TRANSITIONAL HEALTH - MANCHESTER | Fresno | 32 | 64 | 0 | 14 | 19 |
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 );