la_times_cdph_skilled_nursing_facilities

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

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

107,902 rows sorted by date descending

View and edit SQL

Link rowid date ▲ id name county fips staff_active_cases patients_active_cases staff_confirmed_cases patients_confirmed_cases staff_confirmed_cases_note patients_confirmed_cases_note staff_deaths patients_deaths staff_deaths_note patients_deaths_note
7339 2020-07-31 140000321 ALAMEDA COUNTY MEDICAL CENTER D/P SNF Alameda 1 0 0 0 1   10 or fewer 0 0    
7340 2020-07-31 20000043 ALAMEDA HEALTHCARE & WELLNESS CENTER Alameda 1 0 0 1 1 10 or fewer 10 or fewer 0 0    
7341 2020-07-31 630011864 ALAMEDA HOSPITAL - SOUTHSHORE CONVALESCENT Alameda 1 0 0 1 1 10 or fewer 10 or fewer 0 0    
7342 2020-07-31 140000686 ALAMEDA HOSPITAL D/P SNF Alameda 1 0 0 0 0     0 0    
7343 2020-07-31 630013891 ALL SAINT'S MAUBERT Alameda 1 0 0 1 0 10 or fewer   0 0    
7344 2020-07-31 20000070 ALL SAINTS SUBACUTE & TRANSITIONAL CARE Alameda 1 0 0 1 0 10 or fewer   0 0    
7345 2020-07-31 20000010 ASHBY CARE CENTER Alameda 1 0 0 0 0     0 0    
7346 2020-07-31 20000015 BANCROFT HEALTHCARE CENTER Alameda 1 0 0 1 0 10 or fewer   0 0    
7347 2020-07-31 20000135 BAY AREA HEALTHCARE CENTER Alameda 1 0 0 1 1 10 or fewer 10 or fewer 0 0    
7348 2020-07-31 20000026 BAY VIEW REHABILITATION HOSPITAL, LLC Alameda 1 0 0 1 0 10 or fewer   0 0    
7349 2020-07-31 20000060 BAYPOINT HEALTHCARE CENTER Alameda 1 0 0 1 0 10 or fewer   0 0    
7350 2020-07-31 630011713 BAYWOOD COURT HEALTH CENTER Alameda 1 0 0 1 0 10 or fewer   0 0    
7351 2020-07-31 20001250 BELLAKEN SKILLED NURSING CENTER Alameda 1 0 0 0 0     0 0    
7352 2020-07-31 20000028 BERKELEY PINES SKILLED NURSING CENTER Alameda 1 0 0 1 18 10 or fewer   0 1   10 or fewer
7353 2020-07-31 20000029 BETHESDA HOME Alameda 1 0 0 0 0     0 0    
7354 2020-07-31 20000048 CHAPARRAL HOUSE Alameda 1 0 0 1 1 10 or fewer 10 or fewer 0 0    
7355 2020-07-31 630015174 CREEKVIEW SKILLED NURSING Alameda 1 0 0 1 1 10 or fewer 10 or fewer 0 0    
7356 2020-07-31 20000053 CRESTWOOD MANOR - FREMONT Alameda 1 0 37 17 48     0 0    
7357 2020-07-31 20000129 CRESTWOOD TREATMENT CENTER Alameda 1 0 19 1 18 10 or fewer   0 0    
7358 2020-07-31 20000087 CROWN BAY NURSING & REHABILITATION CENTER Alameda 1 0 0 1 0 10 or fewer   0 0    
7359 2020-07-31 20000133 DRIFTWOOD HEALTHCARE CENTER - HAYWARD Alameda 1 0 0 12 32     0 1   10 or fewer
7360 2020-07-31 20000116 EAST BAY POST-ACUTE Alameda 1 0 0 25 33     0 1   10 or fewer
7361 2020-07-31 20000128 ELMWOOD CARE CENTER Alameda 1 0 0 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
7362 2020-07-31 20000093 EXCELL HEALTH CARE CENTER Alameda 1 0 0 23 43     0 1   10 or fewer
7363 2020-07-31 20000132 FREMONT HEALTHCARE CENTER Alameda 1 0 0 1 38 10 or fewer   0 1   10 or fewer
7364 2020-07-31 20000124 FRUITVALE HEALTHCARE CENTER Alameda 1 0 0 1 11 10 or fewer   0 0    
7365 2020-07-31 20000125 GARFIELD NEUROBEHAVIORAL CENTER Alameda 1 0 0 1 0 10 or fewer   0 0    
7366 2020-07-31 20000037 GATEWAY CARE & REHABILITATION CENTER Alameda 1 0 0 31 48     0 19    
7367 2020-07-31 20000123 HAYWARD CONVALESCENT HOSPITAL Alameda 1 0 0 0 0     0 0    
7368 2020-07-31 20000039 HAYWARD HEALTHCARE & WELLNESS CENTER Alameda 1 0 0 1 1 10 or fewer 10 or fewer 1 0 10 or fewer  
7369 2020-07-31 20000047 HAYWARD HILLS HEALTH CARE CENTER Alameda 1 0 0 0 0     0 0    
7370 2020-07-31 20000101 HILLSIDE SENIOR CARE Alameda 1 0 0 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
7371 2020-07-31 20000111 JONES CONVALESCENT HOSPITAL Alameda 1 0 0 0 0     0 0    
7372 2020-07-31 20000042 KAISER PERMANENTE POST-ACUTE CARE CENTER Alameda 1 0 1 1 18 10 or fewer   0 1   10 or fewer
7373 2020-07-31 20000112 KYAKAMEENA CARE CENTER Alameda 1 0 0 1 0 10 or fewer   0 0    
7374 2020-07-31 20000110 LAKE MERRITT HEALTHCARE CENTER LLC Alameda 1 0 0 1 0 10 or fewer   0 0    
7375 2020-07-31 20000114 LAKE PARK RETIREMENT RESIDENCE Alameda 1 0 0 0 0     0 0    
7376 2020-07-31 20000104 MARINA GARDEN NURSING CENTER Alameda 1 0 0 0 0     0 0    
7377 2020-07-31 20000040 MASONIC HOME Alameda 1 0 0 1 0 10 or fewer   0 0    
7378 2020-07-31 20000099 MCCLURE POST ACUTE Alameda 1 0 0 0 0     0 0    
7379 2020-07-31 20000079 MEDICAL HILL HEALTHCARE CENTER Alameda 1 0 0 1 0 10 or fewer   0 0    
7380 2020-07-31 20000100 MERCY RETIREMENT & CARE CENTER Alameda 1 0 0 1 1 10 or fewer 10 or fewer 0 0    
7381 2020-07-31 630014957 MOCHO PARK CARE CENTER Alameda 1 0 0 1 1 10 or fewer 10 or fewer 0 0    
7382 2020-07-31 20000808 MORTON BAKAR CENTER Alameda 1 0 0 1 1 10 or fewer 10 or fewer 0 0    
7383 2020-07-31 20000115 OAKLAND HEALTHCARE & WELLNESS CENTER Alameda 1 0 0 1 0 10 or fewer   0 0    
7384 2020-07-31 20000880 OAKLAND HEIGHTS NURSING AND REHABILITATION Alameda 1 0 0 0 0     0 0    
7385 2020-07-31 630014635 PARK BRIDGE REHABILITATION AND WELLNESS CENTER Alameda 1 0 0 1 1 10 or fewer 10 or fewer 0 0    
7386 2020-07-31 20000094 PARK CENTRAL CARE AND REHABILITATION CENTER Alameda 1 0 0 1 0 10 or fewer   0 0    
7387 2020-07-31 20000090 PARKVIEW HEALTHCARE CENTER Alameda 1 0 60 20 61     1 1 10 or fewer 10 or fewer
7388 2020-07-31 20000091 PIEDMONT GARDENS HEALTH FACILITY Alameda 1 0 0 1 0 10 or fewer   0 0    
7389 2020-07-31 140000086 PLEASANTON NURSING AND REHABILITATION CENTER Alameda 1 0 0 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
7390 2020-07-31 20000054 PRINCETON MANOR HEALTHCARE CENTER, LLC Alameda 1 0 0 0 0     0 0    
7391 2020-07-31 20000276 REDWOOD CONVALESCENT HOSPITAL, INC. Alameda 1 0 0 1 21 10 or fewer   0 1   10 or fewer
7392 2020-07-31 20000119 REDWOOD HEALTHCARE CENTER LLC Alameda 1 0 0 16 29     0 1   10 or fewer
7393 2020-07-31 20000077 SAN LEANDRO HEALTHCARE CENTER Alameda 1 0 0 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
7394 2020-07-31 140001291 SILVER OAK MANOR Alameda 1 0 0 0 0     0 0    
7395 2020-07-31 20000005 ST ANTHONY CARE CENTER Alameda 1 0 0 1 0 10 or fewer   0 0    
7396 2020-07-31 20000074 ST CHRISTOPHER CONVALESCENT HOSPITAL Alameda 1 0 1 1 1 10 or fewer 10 or fewer 0 0    
7397 2020-07-31 20000076 ST FRANCIS HEALTHCARE CENTER Alameda 1 0 0 0 0     0 0    
7398 2020-07-31 20000068 ST JOHN KRONSTADT CONVALESCENT CENTER Alameda 1 0 0 0 0     0 0    
7399 2020-07-31 20000064 ST PAULS TOWERS Alameda 1 0 0 0 0     0 0    
7400 2020-07-31 20000274 THE REHABILITATION CENTER OF OAKLAND Alameda 1 0 11 1 12 10 or fewer   0 1   10 or fewer
7401 2020-07-31 140000122 THE VINEYARDS HEALTHCARE CENTER Alameda 1 0 0 1 0 10 or fewer   0 0    
7402 2020-07-31 140000626 VALLEY MEMORIAL HOSPITAL D/P SNF Alameda 1 0 0 0 0     0 0    
7403 2020-07-31 20000066 VALLEY POINTE NURSING & REHABILITATION CENTER Alameda 1 0 0 1 1 10 or fewer 10 or fewer 0 0    
7404 2020-07-31 20000019 VISTA POST ACUTE Alameda 1 0 0 27 48     0 1   10 or fewer
7405 2020-07-31 20000275 WASHINGTON CENTER Alameda 1 0 0 1 0 10 or fewer   0 0    
7406 2020-07-31 20000065 WE CARE SKILLED NURSING FACILITY Alameda 1 0 0 1 0 10 or fewer   0 0    
7407 2020-07-31 20000020 WINDSOR COUNTRY DRIVE CARE CENTER Alameda 1 0 0 15 1   10 or fewer 0 0    
7408 2020-07-31 20000103 WINDSOR GARDENS CARE CENTER OF HAYWARD Alameda 1 0 0 1 0 10 or fewer   0 0    
7409 2020-07-31 20000277 WINDSOR HEALTHCARE CENTER OF OAKLAND Alameda 1 0 0 1 1 10 or fewer 10 or fewer 0 0    
7410 2020-07-31 20000036 WINDSOR PARK CARE CENTER OF FREMONT Alameda 1 0 1 1 16 10 or fewer   0 0    
7411 2020-07-31 20000071 WINDSOR POST-ACUTE CARE CENTER OF HAYWARD Alameda 1 0 0 27 29     0 1   10 or fewer
7412 2020-07-31 30000074 KIT CARSON NURSING & REHABILITATION CENTER Amador 5 0 0 1 19 10 or fewer   0 0    
7413 2020-07-31 230000255 ARBOR POST ACUTE Butte 7 0 0 0 0     0 0    
7414 2020-07-31 230000546 CALIFORNIA PARK REHABILITATION HOSPITAL Butte 7 0 0 1 1 10 or fewer 10 or fewer 0 0    
7415 2020-07-31 230000802 COUNTRY CREST POST ACUTE Butte 7 0 0 1 1 10 or fewer 10 or fewer 0 0    
7416 2020-07-31 230000327 ORCHARD HOSPITAL D/P SNF Butte 7 0 0 0 0     0 0    
7417 2020-07-31 230000221 OROVILLE HOSPITAL POST-ACUTE CENTER Butte 7 0 0 1 0 10 or fewer   0 0    
7418 2020-07-31 230000036 RIVERSIDE CONVALESCENT HOSPITAL Butte 7 0 0 1 1 10 or fewer 10 or fewer 0 0    
7419 2020-07-31 230000037 SHADOWBROOK POST ACUTE Butte 7 0 0 0 0     0 0    
7420 2020-07-31 230000025 WINDSOR CHICO CARE CENTER Butte 7 0 0 0 0     0 0    
7421 2020-07-31 230000029 WINDSOR CHICO CREEK CARE AND REHABILITATION CENTER Butte 7 0 0 23 26     0 1   10 or fewer
7422 2020-07-31 30000012 AVALON HEALTH CARE - SAN ANDREAS Calaveras 9 0 0 1 0 10 or fewer   0 0    
7423 2020-07-31 230000424 COLUSA MEDICAL CENTER - SNF Colusa 11 0 0 1 0 10 or fewer   0 0    
7424 2020-07-31 230000283 VALLEY WEST POST ACUTE Colusa 11 0 1 39 29     0 1   10 or fewer
7425 2020-07-31 140000574 ALHAMBRA CONVALESCENT HOSPITAL Contra Costa 13 0 0 0 0     0 0    
7426 2020-07-31 140000003 ANTIOCH CONVALESCENT HOSPITAL Contra Costa 13 0 0 1 0 10 or fewer   0 0    
7427 2020-07-31 140000023 BAYBERRY SKILLED NURSING & HEALTHCARE CENTER Contra Costa 13 0 1 13 15     0 1   10 or fewer
7428 2020-07-31 140000138 CREEKSIDE HEALTHCARE CENTER Contra Costa 13 0 0 0 0     0 0    
7429 2020-07-31 140000130 DANVILLE POST-ACUTE REHAB Contra Costa 13 0 0 1 0 10 or fewer   0 0    
7430 2020-07-31 140000564 DIAMOND RIDGE HEALTHCARE CENTER Contra Costa 13 0 1 15 12     0 1   10 or fewer
7431 2020-07-31 140000038 GREENRIDGE SENIOR CARE Contra Costa 13 0 0 1 0 10 or fewer   0 0    
7432 2020-07-31 140000051 LA CASA VIA TRANSITIONAL CARE CENTER Contra Costa 13 0 0 0 0     0 0    
7433 2020-07-31 140000102 LEGACY NURSING AND REHABILITATION CENTER Contra Costa 13 0 0 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
7434 2020-07-31 140000105 LONE TREE CONVALESCENT HOSPITAL Contra Costa 13 0 0 1 0 10 or fewer   0 0    
7435 2020-07-31 140001126 MANOR CARE HEALTH SERVICES-TICE VALLEY Contra Costa 13 0 11 39 92     0 14    
7436 2020-07-31 140000745 MANORCARE HEALTH SERVICES - ROSSMOOR Contra Costa 13 0 0 0 0     0 0    
7437 2020-07-31 140000106 MARTINEZ CONVALESCENT HOSPITAL Contra Costa 13 0 0 0 0     0 0    
7438 2020-07-31 140000081 MORAGA POST ACUTE Contra Costa 13 0 1 1 11 10 or fewer   0 0    

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [la_times_cdph_skilled_nursing_facilities] (
   [date] TEXT,
   [id] INTEGER,
   [name] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [staff_active_cases] INTEGER,
   [patients_active_cases] INTEGER,
   [staff_confirmed_cases] INTEGER,
   [patients_confirmed_cases] INTEGER,
   [staff_confirmed_cases_note] TEXT,
   [patients_confirmed_cases_note] TEXT,
   [staff_deaths] INTEGER,
   [patients_deaths] INTEGER,
   [staff_deaths_note] TEXT,
   [patients_deaths_note] TEXT
);
Powered by Datasette · Query took 41.532ms · 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