la_times_cdph_adult_and_senior_care_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_adult_and_senior_care_facilities
116,613 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
54996 | 54996 | 2021-01-12 | Acacia Creek - Union City | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
54997 | 54997 | 2021-01-12 | Aegis Assisted Living Of Fremont | Alameda | 12 | 1 | 0 | 0 | 1 | <11 | |||
54998 | 54998 | 2021-01-12 | Arcadian Residential Community | Alameda | 15 | 28 | 0 | 1 | 1 | <11 | |||
54999 | 54999 | 2021-01-12 | Brookdale North Fremont | Alameda | 22 | 21 | 0 | 1 | 1 | <11 | |||
55000 | 55000 | 2021-01-12 | Carefield Pleasanton | Alameda | 17 | 24 | 0 | 1 | 1 | <11 | |||
55001 | 55001 | 2021-01-12 | Carlton Plaza Of Fremont | Alameda | 13 | 1 | 0 | 0 | 1 | <11 | |||
55002 | 55002 | 2021-01-12 | Carlton Plaza Of San Leandro | Alameda | 32 | 40 | 1 | 1 | 1 | <11 | <11 | ||
55003 | 55003 | 2021-01-12 | Creekview Assisted Living | Alameda | 19 | 1 | 0 | 0 | 1 | <11 | |||
55004 | 55004 | 2021-01-12 | Elder Ashram | Alameda | 1 | 18 | 0 | 0 | 1 | <11 | |||
55005 | 55005 | 2021-01-12 | Fremont Hills | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
55006 | 55006 | 2021-01-12 | Fremont Rtrmt Com-Happy Lvng By Cogir/Cogir Fremon | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
55007 | 55007 | 2021-01-12 | Fremont Village | Alameda | 30 | 51 | 1 | 13 | 1 | <11 | |||
55008 | 55008 | 2021-01-12 | Lakeside Park | Alameda | 20 | 18 | 0 | 1 | 1 | <11 | |||
55009 | 55009 | 2021-01-12 | Landmark Villa | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
55010 | 55010 | 2021-01-12 | Lincoln Villa | Alameda | 1 | 1 | 0 | 1 | 1 | <11 | <11 | <11 | |
55011 | 55011 | 2021-01-12 | Marymount Villa Retirement Center | Alameda | 17 | 49 | 1 | 16 | 1 | <11 | |||
55012 | 55012 | 2021-01-12 | Masonic Home For Adults | Alameda | 17 | 1 | 0 | 0 | 1 | <11 | |||
55013 | 55013 | 2021-01-12 | Merrill Gardens At Rockridge | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
55014 | 55014 | 2021-01-12 | Oakcreek | Alameda | 1 | 15 | 0 | 1 | 1 | <11 | <11 | ||
55015 | 55015 | 2021-01-12 | Oakmont Of Mariner Point | Alameda | 16 | 1 | 0 | 0 | 1 | <11 | |||
55016 | 55016 | 2021-01-12 | Pacifica Senior Living Oakland | Alameda | 12 | 21 | 0 | 1 | 1 | <11 | |||
55017 | 55017 | 2021-01-12 | Parkview, The | Alameda | 18 | 37 | 0 | 1 | 1 | <11 | |||
55018 | 55018 | 2021-01-12 | Point At Rockridge, The | Alameda | 1 | 16 | 0 | 1 | 1 | <11 | <11 | ||
55019 | 55019 | 2021-01-12 | Quail Garden | Alameda | 1 | 16 | 0 | 1 | 1 | <11 | <11 | ||
55020 | 55020 | 2021-01-12 | Rosegate | Alameda | 1 | 19 | 0 | 0 | 1 | <11 | |||
55021 | 55021 | 2021-01-12 | Scott Villa | Alameda | 1 | 30 | 0 | 1 | 1 | <11 | <11 | ||
55022 | 55022 | 2021-01-12 | Silverado Senior Living - Berkeley | Alameda | 30 | 56 | 0 | 1 | 1 | <11 | |||
55023 | 55023 | 2021-01-12 | St. Regis Retirement Center, Inc. | Alameda | 1 | 19 | 0 | 1 | 1 | <11 | <11 | ||
55024 | 55024 | 2021-01-12 | Stoneridge Creek Pleasanton | Alameda | 24 | 1 | 0 | 0 | 1 | <11 | |||
55025 | 55025 | 2021-01-12 | Watermark At Rosewood Gardens, The | Alameda | 14 | 34 | 0 | 1 | 1 | <11 | |||
55026 | 55026 | 2021-01-12 | Watermark By The Bay, The | Alameda | 12 | 1 | 0 | 0 | 1 | <11 | |||
55027 | 55027 | 2021-01-12 | Waters Edge Lodge | Alameda | 1 | 1 | 0 | 1 | 1 | <11 | <11 | <11 | |
55028 | 55028 | 2021-01-12 | Willow Creek Alzheimer's & Dementia Care Center | Alameda | 1 | 1 | 0 | 1 | 1 | <11 | <11 | <11 | |
55029 | 55029 | 2021-01-12 | Amador Residential Care Facility | Amador | 1 | 1 | 0 | 1 | 5 | <11 | <11 | <11 | |
55030 | 55030 | 2021-01-12 | Compass Rose | Butte | 1 | 20 | 0 | 1 | 7 | <11 | <11 | ||
55031 | 55031 | 2021-01-12 | Country Crest Assisted Living | Butte | 1 | 1 | 0 | 1 | 7 | <11 | <11 | <11 | |
55032 | 55032 | 2021-01-12 | Country House | Butte | 1 | 14 | 0 | 0 | 7 | <11 | |||
55033 | 55033 | 2021-01-12 | Courtyard At Little Chico Creek, The | Butte | 18 | 22 | 0 | 0 | 7 | ||||
55034 | 55034 | 2021-01-12 | Townsend House | Butte | 1 | 17 | 0 | 0 | 7 | <11 | |||
55035 | 55035 | 2021-01-12 | Windchime Of Chico | Butte | 1 | 20 | 1 | 1 | 7 | <11 | <11 | <11 | |
55036 | 55036 | 2021-01-12 | Atria Valley View | Contra Costa | 12 | 1 | 0 | 0 | 13 | <11 | |||
55037 | 55037 | 2021-01-12 | Brookdale Diablo Lodge | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
55038 | 55038 | 2021-01-12 | Brookdale San Ramon | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
55039 | 55039 | 2021-01-12 | Byron Park | Contra Costa | 16 | 14 | 0 | 1 | 13 | <11 | |||
55040 | 55040 | 2021-01-12 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
55041 | 55041 | 2021-01-12 | Chateau III | Contra Costa | 38 | 39 | 0 | 1 | 13 | <11 | |||
55042 | 55042 | 2021-01-12 | Commons At Dallas Ranch, The | Contra Costa | 11 | 1 | 0 | 0 | 13 | <11 | |||
55043 | 55043 | 2021-01-12 | Concord Royale | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
55044 | 55044 | 2021-01-12 | Friendship Care Home | Contra Costa | 1 | 16 | 0 | 1 | 13 | <11 | <11 | ||
55045 | 55045 | 2021-01-12 | Greenridge Senior Care | Contra Costa | 0 | 1 | 0 | 1 | 13 | <11 | <11 | ||
55046 | 55046 | 2021-01-12 | Kensington, The | Contra Costa | 1 | 1 | 0 | 0 | 13 | <11 | <11 | ||
55047 | 55047 | 2021-01-12 | Pleasant Hill Oasis | Contra Costa | 1 | 15 | 0 | 0 | 13 | <11 | |||
55048 | 55048 | 2021-01-12 | Reutlinger Community, The | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
55049 | 55049 | 2021-01-12 | Sunrise Assisted Living Of Danville | Contra Costa | 31 | 24 | 0 | 1 | 13 | <11 | |||
55050 | 55050 | 2021-01-12 | Sunrise Villa San Ramon | Contra Costa | 0 | 1 | 0 | 1 | 13 | <11 | <11 | ||
55051 | 55051 | 2021-01-12 | TreVista Concord | Contra Costa | 11 | 22 | 0 | 1 | 13 | <11 | |||
55052 | 55052 | 2021-01-12 | Trevista Antioch | Contra Costa | 15 | 1 | 0 | 1 | 13 | <11 | <11 | ||
55053 | 55053 | 2021-01-12 | Walnut Creek Willows | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
55054 | 55054 | 2021-01-12 | Westmont Of Brentwood | Contra Costa | 21 | 31 | 0 | 1 | 13 | <11 | |||
55055 | 55055 | 2021-01-12 | Westmont Of Pinole | Contra Costa | 1 | 1 | 0 | 0 | 13 | <11 | <11 | ||
55056 | 55056 | 2021-01-12 | Eskaton Village Placerville | El Dorado | 18 | 26 | 0 | 1 | 17 | <11 | |||
55057 | 55057 | 2021-01-12 | New West Haven Ii | El Dorado | 1 | 15 | 0 | 1 | 17 | <11 | <11 | ||
55058 | 55058 | 2021-01-12 | Oakmont Of El Dorado Hills | El Dorado | 1 | 1 | 0 | 0 | 17 | <11 | <11 | ||
55059 | 55059 | 2021-01-12 | Ponte Palmero | El Dorado | 1 | 1 | 0 | 1 | 17 | <11 | <11 | <11 | |
55060 | 55060 | 2021-01-12 | Autumn Ridge Assisted Living | Fresno | 1 | 1 | 0 | 1 | 19 | <11 | <11 | <11 | |
55061 | 55061 | 2021-01-12 | Belmar Villa | Fresno | 1 | 14 | 0 | 1 | 19 | <11 | <11 | ||
55062 | 55062 | 2021-01-12 | Carmel Village At Clovis | Fresno | 22 | 1 | 0 | 0 | 19 | <11 | |||
55063 | 55063 | 2021-01-12 | Carmel Village Memory Care | Fresno | 19 | 28 | 0 | 1 | 19 | <11 | |||
55064 | 55064 | 2021-01-12 | Compass Pointe Memory Care | Fresno | 1 | 26 | 0 | 1 | 19 | <11 | <11 | ||
55065 | 55065 | 2021-01-12 | Fairwinds - Woodward Park | Fresno | 25 | 15 | 0 | 1 | 19 | <11 | |||
55066 | 55066 | 2021-01-12 | Gettysburg Christian Home | Fresno | 0 | 1 | 0 | 1 | 19 | <11 | <11 | ||
55067 | 55067 | 2021-01-12 | Kingston Bay Senior Living | Fresno | 19 | 11 | 0 | 1 | 19 | <11 | |||
55068 | 55068 | 2021-01-12 | Oakmont Of Fresno | Fresno | 19 | 36 | 0 | 1 | 19 | <11 | |||
55069 | 55069 | 2021-01-12 | Pacifica Senior Living Fresno | Fresno | 1 | 1 | 0 | 1 | 19 | <11 | <11 | <11 | |
55070 | 55070 | 2021-01-12 | Paintbrush Assisted Living And Memory Care | Fresno | 12 | 17 | 0 | 0 | 19 | ||||
55071 | 55071 | 2021-01-12 | Palm Village Retirement Community | Fresno | 22 | 17 | 0 | 0 | 19 | ||||
55072 | 55072 | 2021-01-12 | Rehabilitation Centre Of Fresno | Fresno | 1 | 27 | 0 | 1 | 19 | <11 | <11 | ||
55073 | 55073 | 2021-01-12 | Sierra View Homes Residential Care | Fresno | 12 | 1 | 0 | 0 | 19 | <11 | |||
55074 | 55074 | 2021-01-12 | The Terraces At San Joaquin Gardens | Fresno | 13 | 17 | 0 | 0 | 19 | ||||
55075 | 55075 | 2021-01-12 | Twilight Haven | Fresno | 12 | 11 | 0 | 0 | 19 | ||||
55076 | 55076 | 2021-01-12 | Veterans Home Of California-Fresno | Fresno | 20 | 11 | 0 | 0 | 19 | ||||
55077 | 55077 | 2021-01-12 | Westmont Of Fresno | Fresno | 11 | 1 | 0 | 0 | 19 | <11 | |||
55078 | 55078 | 2021-01-12 | Windham, The | Fresno | 1 | 12 | 0 | 1 | 19 | <11 | <11 | ||
55079 | 55079 | 2021-01-12 | Westhaven Assisted Living | Glenn | 17 | 33 | 0 | 1 | 21 | <11 | |||
55080 | 55080 | 2021-01-12 | Alder Bay Assisted Living | Humboldt | 1 | 1 | 0 | 1 | 23 | <11 | <11 | <11 | |
55081 | 55081 | 2021-01-12 | A&a Cottage View Assisted Living,inc. | Imperial | 1 | 1 | 0 | 1 | 25 | <11 | <11 | <11 | |
55082 | 55082 | 2021-01-12 | Blossom Valley Inn | Imperial | 12 | 57 | 0 | 1 | 25 | <11 | |||
55083 | 55083 | 2021-01-12 | Heart & Hand, Inc. | Imperial | 1 | 1 | 0 | 0 | 25 | <11 | <11 | ||
55084 | 55084 | 2021-01-12 | Brookdale Riverwalk | Kern | 1 | 16 | 0 | 0 | 29 | <11 | |||
55085 | 55085 | 2021-01-12 | Centre Village | Kern | 36 | 1 | 0 | 0 | 29 | <11 | |||
55086 | 55086 | 2021-01-12 | Hallmark Of Bakersfield | Kern | 1 | 13 | 0 | 0 | 29 | <11 | |||
55087 | 55087 | 2021-01-12 | Jasmin Terrace At Bakersfield | Kern | 1 | 1 | 0 | 1 | 29 | <11 | <11 | <11 | |
55088 | 55088 | 2021-01-12 | Pacifica Of Bakersfield | Kern | 1 | 1 | 0 | 1 | 29 | <11 | <11 | <11 | |
55089 | 55089 | 2021-01-12 | Pointe At Summit Hills, The | Kern | 19 | 1 | 0 | 1 | 29 | <11 | <11 | ||
55090 | 55090 | 2021-01-12 | Riverside Ranch, Asc Treatment Group | Kern | 1 | 1 | 0 | 0 | 29 | <11 | <11 | ||
55091 | 55091 | 2021-01-12 | Rosewood Retirement Community | Kern | 13 | 1 | 0 | 1 | 29 | <11 | <11 | ||
55092 | 55092 | 2021-01-12 | Westchester Gardens | Kern | 1 | 17 | 0 | 0 | 29 | <11 | |||
55093 | 55093 | 2021-01-12 | Diamond Terraces | Kings | 1 | 14 | 0 | 0 | 31 | <11 | |||
55094 | 55094 | 2021-01-12 | Abbey Road Villa | Los Angeles | 1 | 34 | 0 | 0 | 37 | <11 | |||
55095 | 55095 | 2021-01-12 | Aegis Of Granada Hills | Los Angeles | 17 | 18 | 0 | 1 | 37 | <11 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [la_times_cdph_adult_and_senior_care_facilities] ( [date] 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 );