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-09-12 sorted by patients_deaths_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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
599273 | 599273 | 2020-09-12 | 140000321 | 140000321-alameda-county-medical-center-d-p-snf | ALAMEDA COUNTY MEDICAL CENTER D/P SNF | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
599275 | 599275 | 2020-09-12 | 630011864 | 630011864-alameda-hospital-southshore-convalescent | ALAMEDA HOSPITAL - SOUTHSHORE CONVALESCENT | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
599276 | 599276 | 2020-09-12 | 140000686 | 140000686-alameda-hospital-d-p-snf | ALAMEDA HOSPITAL D/P SNF | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
599277 | 599277 | 2020-09-12 | 630013891 | 630013891-all-saint-s-maubert | ALL SAINT'S MAUBERT | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
599278 | 599278 | 2020-09-12 | 20000070 | 020000070-all-saints-subacute-transitional-care | ALL SAINTS SUBACUTE & TRANSITIONAL CARE | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
599279 | 599279 | 2020-09-12 | 20000010 | 020000010-ashby-care-center | ASHBY CARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
599280 | 599280 | 2020-09-12 | 140001291 | 140001291-avondale-villa-post-acute | AVONDALE VILLA POST-ACUTE | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
599281 | 599281 | 2020-09-12 | 20000015 | 020000015-bancroft-healthcare-center | BANCROFT HEALTHCARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
599282 | 599282 | 2020-09-12 | 20000135 | 020000135-bay-area-healthcare-center | BAY AREA HEALTHCARE CENTER | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
599283 | 599283 | 2020-09-12 | 20000026 | 020000026-bay-view-rehabilitation-hospital-llc | BAY VIEW REHABILITATION HOSPITAL, LLC | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
599284 | 599284 | 2020-09-12 | 20000060 | 020000060-baypoint-healthcare-center | BAYPOINT HEALTHCARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
599285 | 599285 | 2020-09-12 | 630011713 | 630011713-baywood-court-health-center | BAYWOOD COURT HEALTH CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
599286 | 599286 | 2020-09-12 | 20001250 | 020001250-bellaken-skilled-nursing-center | BELLAKEN SKILLED NURSING CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
599288 | 599288 | 2020-09-12 | 20000029 | 020000029-bethesda-home | BETHESDA HOME | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
599289 | 599289 | 2020-09-12 | 20000048 | 020000048-chaparral-house | CHAPARRAL HOUSE | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
599290 | 599290 | 2020-09-12 | 630015174 | 630015174-creekview-skilled-nursing | CREEKVIEW SKILLED NURSING | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
599292 | 599292 | 2020-09-12 | 20000129 | 020000129-crestwood-treatment-center | CRESTWOOD TREATMENT CENTER | Alameda | 1 | 25 | 0 | 0 | 1 | <11 | |||
599293 | 599293 | 2020-09-12 | 20000087 | 020000087-crown-bay-nursing-rehabilitation-center | CROWN BAY NURSING & REHABILITATION CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
599299 | 599299 | 2020-09-12 | 20000124 | 020000124-fruitvale-healthcare-center | FRUITVALE HEALTHCARE CENTER | Alameda | 15 | 11 | 0 | 0 | 1 | ||||
599301 | 599301 | 2020-09-12 | 20000123 | 020000123-hayward-convalescent-hospital | HAYWARD CONVALESCENT HOSPITAL | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
599302 | 599302 | 2020-09-12 | 20000039 | 020000039-hayward-healthcare-wellness-center | HAYWARD HEALTHCARE & WELLNESS CENTER | Alameda | 1 | 1 | 1 | 0 | 1 | <11 | <11 | <11 | |
599303 | 599303 | 2020-09-12 | 20000047 | 020000047-hayward-hills-health-care-center | HAYWARD HILLS HEALTH CARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
599304 | 599304 | 2020-09-12 | 20000111 | 020000111-jones-convalescent-hospital | JONES CONVALESCENT HOSPITAL | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
599306 | 599306 | 2020-09-12 | 20000112 | 020000112-kyakameena-care-center | KYAKAMEENA CARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
599307 | 599307 | 2020-09-12 | 20000110 | 020000110-lake-merritt-healthcare-center-llc | LAKE MERRITT HEALTHCARE CENTER LLC | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
599308 | 599308 | 2020-09-12 | 20000114 | 020000114-lake-park-retirement-residence | LAKE PARK RETIREMENT RESIDENCE | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
599309 | 599309 | 2020-09-12 | 20000104 | 020000104-marina-garden-nursing-center | MARINA GARDEN NURSING CENTER | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
599310 | 599310 | 2020-09-12 | 20000040 | 020000040-masonic-home | MASONIC HOME | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
599311 | 599311 | 2020-09-12 | 20000099 | 020000099-mcclure-post-acute | MCCLURE POST ACUTE | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
599312 | 599312 | 2020-09-12 | 20000079 | 020000079-medical-hill-healthcare-center | MEDICAL HILL HEALTHCARE CENTER | Alameda | 31 | 49 | 0 | 0 | 1 | ||||
599313 | 599313 | 2020-09-12 | 20000100 | 020000100-mercy-retirement-care-center | MERCY RETIREMENT & CARE CENTER | Alameda | 20 | 20 | 0 | 12 | 1 | ||||
599316 | 599316 | 2020-09-12 | 20000115 | 020000115-oakland-healthcare-wellness-center | OAKLAND HEALTHCARE & WELLNESS CENTER | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
599317 | 599317 | 2020-09-12 | 20000880 | 020000880-oakland-heights-nursing-and-rehabilitation | OAKLAND HEIGHTS NURSING AND REHABILITATION | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
599318 | 599318 | 2020-09-12 | 630014635 | 630014635-park-bridge-rehabilitation-and-wellness-center | PARK BRIDGE REHABILITATION AND WELLNESS CENTER | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
599319 | 599319 | 2020-09-12 | 20000094 | 020000094-park-central-care-and-rehabilitation-center | PARK CENTRAL CARE AND REHABILITATION CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
599321 | 599321 | 2020-09-12 | 20000091 | 020000091-piedmont-gardens-health-facility | PIEDMONT GARDENS HEALTH FACILITY | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
599328 | 599328 | 2020-09-12 | 20000005 | 020000005-st-anthony-care-center | ST ANTHONY CARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
599329 | 599329 | 2020-09-12 | 20000076 | 020000076-st-francis-healthcare-center | ST FRANCIS HEALTHCARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
599330 | 599330 | 2020-09-12 | 20000068 | 020000068-st-john-kronstadt-convalescent-center | ST JOHN KRONSTADT CONVALESCENT CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
599331 | 599331 | 2020-09-12 | 20000064 | 020000064-st-pauls-towers | ST PAULS TOWERS | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
599332 | 599332 | 2020-09-12 | 20000037 | 020000037-st-patrick-s-post-acute | ST. PATRICK'S POST ACUTE | Alameda | 31 | 49 | 0 | 19 | 1 | ||||
599333 | 599333 | 2020-09-12 | 630014957 | 630014957-stratford-villa-post-acute | STRATFORD VILLA POST-ACUTE | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
599335 | 599335 | 2020-09-12 | 140000122 | 140000122-the-vineyards-healthcare-center | THE VINEYARDS HEALTHCARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
599336 | 599336 | 2020-09-12 | 140000626 | 140000626-valley-memorial-hospital-d-p-snf | VALLEY MEMORIAL HOSPITAL D/P SNF | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
599337 | 599337 | 2020-09-12 | 20000066 | 020000066-valley-pointe-nursing-rehabilitation-center | VALLEY POINTE NURSING & REHABILITATION CENTER | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
599339 | 599339 | 2020-09-12 | 20000275 | 020000275-washington-center | WASHINGTON CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
599340 | 599340 | 2020-09-12 | 20000065 | 020000065-we-care-skilled-nursing-facility | WE CARE SKILLED NURSING FACILITY | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
599341 | 599341 | 2020-09-12 | 20000020 | 020000020-windsor-country-drive-care-center | WINDSOR COUNTRY DRIVE CARE CENTER | Alameda | 18 | 19 | 0 | 0 | 1 | ||||
599342 | 599342 | 2020-09-12 | 20000103 | 020000103-windsor-gardens-care-center-of-hayward | WINDSOR GARDENS CARE CENTER OF HAYWARD | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
599344 | 599344 | 2020-09-12 | 20000036 | 020000036-windsor-park-care-center-of-fremont | WINDSOR PARK CARE CENTER OF FREMONT | Alameda | 15 | 16 | 0 | 0 | 1 | ||||
599346 | 599346 | 2020-09-12 | 30000074 | 030000074-kit-carson-nursing-rehabilitation-center | KIT CARSON NURSING & REHABILITATION CENTER | Amador | 22 | 51 | 0 | 16 | 5 | ||||
599349 | 599349 | 2020-09-12 | 230000802 | 230000802-country-crest-post-acute | COUNTRY CREST POST ACUTE | Butte | 1 | 1 | 0 | 0 | 7 | <11 | <11 | ||
599350 | 599350 | 2020-09-12 | 230000327 | 230000327-orchard-hospital-d-p-snf | ORCHARD HOSPITAL D/P SNF | Butte | 0 | 0 | 0 | 0 | 7 | ||||
599351 | 599351 | 2020-09-12 | 230000221 | 230000221-oroville-hospital-post-acute-center | OROVILLE HOSPITAL POST-ACUTE CENTER | Butte | 1 | 0 | 0 | 0 | 7 | <11 | |||
599353 | 599353 | 2020-09-12 | 230000037 | 230000037-shadowbrook-post-acute | SHADOWBROOK POST ACUTE | Butte | 0 | 0 | 0 | 0 | 7 | ||||
599359 | 599359 | 2020-09-12 | 140000574 | 140000574-alhambra-convalescent-hospital | ALHAMBRA CONVALESCENT HOSPITAL | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
599361 | 599361 | 2020-09-12 | 140000138 | 140000138-creekside-healthcare-center | CREEKSIDE HEALTHCARE CENTER | Contra Costa | 1 | 1 | 0 | 0 | 13 | <11 | <11 | ||
599362 | 599362 | 2020-09-12 | 140000130 | 140000130-danville-post-acute-rehab | DANVILLE POST-ACUTE REHAB | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
599363 | 599363 | 2020-09-12 | 140000003 | 140000003-delta-view-post-acute | DELTA VIEW POST ACUTE | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
599365 | 599365 | 2020-09-12 | 140000038 | 140000038-greenridge-post-acute | GREENRIDGE POST ACUTE | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
599366 | 599366 | 2020-09-12 | 140000051 | 140000051-la-casa-via-transitional-care-center | LA CASA VIA TRANSITIONAL CARE CENTER | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
599368 | 599368 | 2020-09-12 | 140000105 | 140000105-lone-tree-post-acute | LONE TREE POST ACUTE | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
599369 | 599369 | 2020-09-12 | 140000745 | 140000745-manorcare-health-services-rossmoor | MANORCARE HEALTH SERVICES - ROSSMOOR | Contra Costa | 1 | 1 | 0 | 0 | 13 | <11 | <11 | ||
599370 | 599370 | 2020-09-12 | 140001126 | 140001126-manorcare-health-services-tice-valley | MANORCARE HEALTH SERVICES - TICE VALLEY | Contra Costa | 39 | 92 | 0 | 17 | 13 | ||||
599372 | 599372 | 2020-09-12 | 140000081 | 140000081-moraga-post-acute | MORAGA POST ACUTE | Contra Costa | 1 | 11 | 0 | 0 | 13 | <11 | |||
599375 | 599375 | 2020-09-12 | 140000962 | 140000962-pittsburg-skilled-nursing-center | PITTSBURG SKILLED NURSING CENTER | Contra Costa | 0 | 1 | 0 | 0 | 13 | <11 | |||
599377 | 599377 | 2020-09-12 | 140000049 | 140000049-richmond-post-acute-care | RICHMOND POST ACUTE CARE | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
599378 | 599378 | 2020-09-12 | 140000136 | 140000136-san-miguel-villa | SAN MIGUEL VILLA | Contra Costa | 17 | 65 | 1 | 20 | 13 | <11 | |||
599379 | 599379 | 2020-09-12 | 140000030 | 140000030-san-pablo-healthcare-wellness-center | SAN PABLO HEALTHCARE & WELLNESS CENTER | Contra Costa | 1 | 1 | 0 | 0 | 13 | <11 | <11 | ||
599382 | 599382 | 2020-09-12 | 140000080 | 140000080-shields-richmond-nursing-center | SHIELDS RICHMOND NURSING CENTER | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
599383 | 599383 | 2020-09-12 | 140000733 | 140000733-stonebrook-healthcare-center | STONEBROOK HEALTHCARE CENTER | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
599384 | 599384 | 2020-09-12 | 140000078 | 140000078-tampico-terrace-care-center | TAMPICO TERRACE CARE CENTER | Contra Costa | 1 | 1 | 0 | 0 | 13 | <11 | <11 | ||
599385 | 599385 | 2020-09-12 | 140001185 | 140001185-the-reutlinger-community | THE REUTLINGER COMMUNITY | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
599386 | 599386 | 2020-09-12 | 140000061 | 140000061-vale-healthcare-center | VALE HEALTHCARE CENTER | Contra Costa | 1 | 1 | 0 | 0 | 13 | <11 | <11 | ||
599387 | 599387 | 2020-09-12 | 140000083 | 140000083-walnut-creek-skilled-nursing-rehabilitation-center | WALNUT CREEK SKILLED NURSING & REHABILITATION CENTER | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
599388 | 599388 | 2020-09-12 | 140000121 | 140000121-willow-pass-healthcare-center | WILLOW PASS HEALTHCARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
599389 | 599389 | 2020-09-12 | 140000062 | 140000062-windsor-manor-rehabilitation-center-of-concord | WINDSOR MANOR REHABILITATION CENTER OF CONCORD | Contra Costa | 1 | 18 | 0 | 0 | 13 | <11 | |||
599390 | 599390 | 2020-09-12 | 140000082 | 140000082-windsor-rosewood-care-center | WINDSOR ROSEWOOD CARE CENTER | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
599391 | 599391 | 2020-09-12 | 10000004 | 010000004-crescent-city-skilled-nursing | CRESCENT CITY SKILLED NURSING | Del Norte | 0 | 0 | 0 | 0 | 15 | ||||
599392 | 599392 | 2020-09-12 | 30001525 | 030001525-barton-hospital-d-p-snf | BARTON HOSPITAL D/P SNF | El Dorado | 1 | 1 | 0 | 0 | 17 | <11 | <11 | ||
599393 | 599393 | 2020-09-12 | 30000063 | 030000063-gold-country-health-center | GOLD COUNTRY HEALTH CENTER | El Dorado | 1 | 0 | 0 | 0 | 17 | <11 | |||
599394 | 599394 | 2020-09-12 | 30001064 | 030001064-marshall-medical-center-d-p-snf | MARSHALL MEDICAL CENTER D/P SNF | El Dorado | 0 | 0 | 0 | 0 | 17 | ||||
599395 | 599395 | 2020-09-12 | 30000085 | 030000085-the-pines-at-placerville-healthcare-center | THE PINES AT PLACERVILLE HEALTHCARE CENTER | El Dorado | 1 | 1 | 0 | 0 | 17 | <11 | <11 | ||
599396 | 599396 | 2020-09-12 | 30000047 | 030000047-western-slope-health-center | WESTERN SLOPE HEALTH CENTER | El Dorado | 1 | 0 | 0 | 0 | 17 | <11 | |||
599401 | 599401 | 2020-09-12 | 40000474 | 040000474-community-subacute-and-transitional-care-center | COMMUNITY SUBACUTE AND TRANSITIONAL CARE CENTER | Fresno | 12 | 1 | 0 | 0 | 19 | <11 | |||
599402 | 599402 | 2020-09-12 | 40000019 | 040000019-dycora-transitional-health-clovis | DYCORA TRANSITIONAL HEALTH - CLOVIS | Fresno | 1 | 1 | 0 | 0 | 19 | <11 | <11 | ||
599403 | 599403 | 2020-09-12 | 40000033 | 040000033-dycora-transitional-health-fowler | DYCORA TRANSITIONAL HEALTH - FOWLER | Fresno | 1 | 0 | 0 | 0 | 19 | <11 | |||
599404 | 599404 | 2020-09-12 | 40000007 | 040000007-dycora-transitional-health-fresno | DYCORA TRANSITIONAL HEALTH - FRESNO | Fresno | 38 | 118 | 1 | 33 | 19 | <11 | |||
599406 | 599406 | 2020-09-12 | 40000026 | 040000026-dycora-transitional-health-memory-care-of-fresno | DYCORA TRANSITIONAL HEALTH - MEMORY CARE OF FRESNO | Fresno | 13 | 30 | 0 | 12 | 19 | ||||
599410 | 599410 | 2020-09-12 | 40000025 | 040000025-fowler-care-center | FOWLER CARE CENTER | Fresno | 1 | 1 | 0 | 0 | 19 | <11 | <11 | ||
599411 | 599411 | 2020-09-12 | 40000043 | 040000043-fresno-nursing-center | FRESNO NURSING CENTER | Fresno | 1 | 1 | 0 | 0 | 19 | <11 | <11 | ||
599412 | 599412 | 2020-09-12 | 40000004 | 040000004-fresno-postacute-care | FRESNO POSTACUTE CARE | Fresno | 1 | 11 | 0 | 0 | 19 | <11 | |||
599413 | 599413 | 2020-09-12 | 40000047 | 040000047-healthcare-centre-of-fresno | HEALTHCARE CENTRE OF FRESNO | Fresno | 12 | 1 | 0 | 0 | 19 | <11 | |||
599416 | 599416 | 2020-09-12 | 40000036 | 040000036-manning-gardens-care-center-inc | MANNING GARDENS CARE CENTER, INC. | Fresno | 1 | 0 | 0 | 0 | 19 | <11 | |||
599417 | 599417 | 2020-09-12 | 40000059 | 040000059-north-pointe-healthcare-centre | NORTH POINTE HEALTHCARE CENTRE | Fresno | 1 | 0 | 0 | 0 | 19 | <11 | |||
599418 | 599418 | 2020-09-12 | 40000051 | 040000051-oakwood-gardens-care-center | OAKWOOD GARDENS CARE CENTER | Fresno | 12 | 1 | 0 | 0 | 19 | <11 | |||
599421 | 599421 | 2020-09-12 | 40000010 | 040000010-palm-village-retirement-community-health-care-ctr | PALM VILLAGE RETIREMENT COMMUNITY HEALTH CARE CTR. | Fresno | 26 | 1 | 0 | 0 | 19 | <11 | |||
599422 | 599422 | 2020-09-12 | 40000052 | 040000052-rolling-hills-care-center | ROLLING HILLS CARE CENTER | Fresno | 1 | 0 | 0 | 0 | 19 | <11 | |||
599425 | 599425 | 2020-09-12 | 40000061 | 040000061-sunnyside-convalescent-hospital | SUNNYSIDE CONVALESCENT HOSPITAL | Fresno | 1 | 1 | 0 | 0 | 19 | <11 | <11 | ||
599426 | 599426 | 2020-09-12 | 40000076 | 040000076-the-terraces-at-san-joaquin-gardens-village | THE TERRACES AT SAN JOAQUIN GARDENS VILLAGE | Fresno | 1 | 1 | 0 | 0 | 19 | <11 | <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 );