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
75 rows where "date" is on date 2021-03-09 and staff_deaths = 1 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19834 | 19834 | 2021-03-09 | Carlton Plaza Of San Leandro | Alameda | 35 | 41 | 1 | 1 | 1 | <11 | <11 | ||
19840 | 19840 | 2021-03-09 | Fremont Village | Alameda | 31 | 56 | 1 | 13 | 1 | <11 | |||
19846 | 19846 | 2021-03-09 | Marymount Villa Retirement Center | Alameda | 17 | 49 | 1 | 16 | 1 | <11 | |||
19848 | 19848 | 2021-03-09 | Merrill Gardens At Rockridge | Alameda | 11 | 1 | 1 | 1 | 1 | <11 | <11 | <11 | |
19875 | 19875 | 2021-03-09 | Prestige Assisted Living At Chico | Butte | 14 | 0 | 1 | 0 | 7 | <11 | |||
19876 | 19876 | 2021-03-09 | Roseleaf Gardens | Butte | 13 | 26 | 1 | 1 | 7 | <11 | <11 | ||
19878 | 19878 | 2021-03-09 | Windchime Of Chico | Butte | 1 | 20 | 1 | 1 | 7 | <11 | <11 | <11 | |
19920 | 19920 | 2021-03-09 | Pacifica Senior Living Fresno | Fresno | 16 | 15 | 1 | 1 | 19 | <11 | <11 | ||
19960 | 19960 | 2021-03-09 | Arcadian, The | Los Angeles | 26 | 93 | 1 | 25 | 37 | <11 | |||
19965 | 19965 | 2021-03-09 | Atria Rancho Park | Los Angeles | 21 | 46 | 1 | 1 | 37 | <11 | <11 | ||
19972 | 19972 | 2021-03-09 | Belmont Village Calabasas | Los Angeles | 55 | 50 | 1 | 1 | 37 | <11 | <11 | ||
19973 | 19973 | 2021-03-09 | Belmont Village Encino | Los Angeles | 54 | 43 | 1 | 1 | 37 | <11 | <11 | ||
19976 | 19976 | 2021-03-09 | Belmont Village Westwood | Los Angeles | 75 | 36 | 1 | 1 | 37 | <11 | <11 | ||
19977 | 19977 | 2021-03-09 | Beverly Hills Carmel Retirement Hotel | Los Angeles | 27 | 22 | 1 | 1 | 37 | <11 | <11 | ||
19978 | 19978 | 2021-03-09 | Beverly Hills Carmel Retirement Hotel North | Los Angeles | 15 | 1 | 1 | 0 | 37 | <11 | <11 | ||
19979 | 19979 | 2021-03-09 | Beverly Hills Gardens Care Center | Los Angeles | 1 | 12 | 1 | 1 | 37 | <11 | <11 | <11 | |
19986 | 19986 | 2021-03-09 | Brookdale Alhambra | Los Angeles | 15 | 1 | 1 | 0 | 37 | <11 | <11 | ||
20011 | 20011 | 2021-03-09 | Claremont Place | Los Angeles | 24 | 23 | 1 | 1 | 37 | <11 | <11 | ||
20014 | 20014 | 2021-03-09 | Commons At Woodland Hills, The | Los Angeles | 50 | 68 | 1 | 1 | 37 | <11 | <11 | ||
20027 | 20027 | 2021-03-09 | Elim Healthcare, Inc. | Los Angeles | 14 | 69 | 1 | 11 | 37 | <11 | |||
20044 | 20044 | 2021-03-09 | Glen Park At Long Beach | Los Angeles | 19 | 22 | 1 | 1 | 37 | <11 | <11 | ||
20053 | 20053 | 2021-03-09 | Grandview, The | Los Angeles | 16 | 44 | 1 | 1 | 37 | <11 | <11 | ||
20069 | 20069 | 2021-03-09 | Kingsley Manor | Los Angeles | 27 | 45 | 1 | 1 | 37 | <11 | <11 | ||
20086 | 20086 | 2021-03-09 | Merrill Gardens At Rolling Hills Estates | Los Angeles | 1 | 0 | 1 | 0 | 37 | <11 | <11 | ||
20105 | 20105 | 2021-03-09 | Oakview | Los Angeles | 21 | 1 | 1 | 1 | 37 | <11 | <11 | <11 | |
20135 | 20135 | 2021-03-09 | Sakura Gardens At Los Angeles | Los Angeles | 21 | 19 | 1 | 1 | 37 | <11 | <11 | ||
20140 | 20140 | 2021-03-09 | Silverado Senior Living - Beverly Place | Los Angeles | 46 | 60 | 1 | 13 | 37 | <11 | |||
20142 | 20142 | 2021-03-09 | Silverado Senior Living - Sierra Vista | Los Angeles | 38 | 64 | 1 | 14 | 37 | <11 | |||
20163 | 20163 | 2021-03-09 | Sunrise Of Beverly Hills | Los Angeles | 21 | 1 | 1 | 0 | 37 | <11 | <11 | ||
20167 | 20167 | 2021-03-09 | Terraces At Park Marino, The | Los Angeles | 19 | 15 | 1 | 0 | 37 | <11 | |||
20168 | 20168 | 2021-03-09 | Terraza Court | Los Angeles | 1 | 33 | 1 | 0 | 37 | <11 | <11 | ||
20223 | 20223 | 2021-03-09 | Country Inn | Napa | 14 | 11 | 1 | 1 | 55 | <11 | <11 | ||
20224 | 20224 | 2021-03-09 | Meadows Of Napa Valley, The | Napa | 33 | 1 | 1 | 0 | 55 | <11 | <11 | ||
20225 | 20225 | 2021-03-09 | Nazareth Rose Garden Of Napa | Napa | 1 | 17 | 1 | 1 | 55 | <11 | <11 | <11 | |
20230 | 20230 | 2021-03-09 | Acacia Villas | Orange | 14 | 19 | 1 | 1 | 59 | <11 | <11 | ||
20235 | 20235 | 2021-03-09 | Anaheim Guest Home | Orange | 1 | 1 | 1 | 0 | 59 | <11 | <11 | <11 | |
20251 | 20251 | 2021-03-09 | Capriana | Orange | 57 | 46 | 1 | 14 | 59 | <11 | |||
20276 | 20276 | 2021-03-09 | Karlton Residential Care Center | Orange | 25 | 40 | 1 | 1 | 59 | <11 | <11 | ||
20278 | 20278 | 2021-03-09 | Kirkwood Orange | Orange | 13 | 23 | 1 | 1 | 59 | <11 | <11 | ||
20307 | 20307 | 2021-03-09 | Silverado Brea Llc | Orange | 23 | 28 | 1 | 1 | 59 | <11 | <11 | ||
20316 | 20316 | 2021-03-09 | Sunrise At Yorba Linda | Orange | 27 | 19 | 1 | 1 | 59 | <11 | <11 | ||
20321 | 20321 | 2021-03-09 | Town & Country | Orange | 75 | 73 | 1 | 1 | 59 | <11 | <11 | ||
20322 | 20322 | 2021-03-09 | Valley View Gardens | Orange | 35 | 42 | 1 | 1 | 59 | <11 | <11 | ||
20331 | 20331 | 2021-03-09 | College Way Residential Care | Placer | 1 | 1 | 1 | 0 | 61 | <11 | <11 | <11 | |
20336 | 20336 | 2021-03-09 | Oakmont Of Roseville | Placer | 23 | 16 | 1 | 1 | 61 | <11 | <11 | ||
20341 | 20341 | 2021-03-09 | Sterling Court At Roseville | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
20357 | 20357 | 2021-03-09 | Caleo Bay Alzheimer's Special Care Center | Riverside | 24 | 45 | 1 | 1 | 65 | <11 | <11 | ||
20365 | 20365 | 2021-03-09 | Desert Cove Assisted Living At Desert Hot Springs | Riverside | 15 | 14 | 1 | 1 | 65 | <11 | <11 | ||
20381 | 20381 | 2021-03-09 | Mission Bell Adult Residential Care Home | Riverside | 1 | 1 | 1 | 0 | 65 | <11 | <11 | <11 | |
20383 | 20383 | 2021-03-09 | Murrieta Gardens | Riverside | 15 | 27 | 1 | 1 | 65 | <11 | <11 | ||
20388 | 20388 | 2021-03-09 | Palms At La Quinta, The | Riverside | 18 | 37 | 1 | 16 | 65 | <11 | |||
20397 | 20397 | 2021-03-09 | Sunrise At Canyon Crest | Riverside | 49 | 25 | 1 | 1 | 65 | <11 | <11 | ||
20400 | 20400 | 2021-03-09 | Vineyard Place | Riverside | 31 | 42 | 1 | 18 | 65 | <11 | |||
20405 | 20405 | 2021-03-09 | Welbrook Senior Living Arlington | Riverside | 47 | 32 | 1 | 11 | 65 | <11 | |||
20420 | 20420 | 2021-03-09 | Chalet, The | Sacramento | 1 | 17 | 1 | 1 | 67 | <11 | <11 | <11 | |
20430 | 20430 | 2021-03-09 | Eskaton Village | Sacramento | 30 | 19 | 1 | 1 | 67 | <11 | <11 | ||
20483 | 20483 | 2021-03-09 | Pacifica Senior Living Hillsborough | San Bernardino | 23 | 26 | 1 | 1 | 71 | <11 | <11 | ||
20491 | 20491 | 2021-03-09 | Sterling Inn | San Bernardino | 25 | 30 | 1 | 1 | 71 | <11 | <11 | ||
20495 | 20495 | 2021-03-09 | Villas At San Bernardino | San Bernardino | 18 | 26 | 1 | 1 | 71 | <11 | <11 | ||
20506 | 20506 | 2021-03-09 | Atria Collwood | San Diego | 1 | 0 | 1 | 0 | 73 | <11 | <11 | ||
20546 | 20546 | 2021-03-09 | Las Villas De Carlsbad | San Diego | 36 | 47 | 1 | 13 | 73 | <11 | |||
20549 | 20549 | 2021-03-09 | Lo-Har Senior Living | San Diego | 11 | 32 | 1 | 1 | 73 | <11 | <11 | ||
20563 | 20563 | 2021-03-09 | Ocean Hills Assisted Living & Memory Care | San Diego | 12 | 1 | 1 | 0 | 73 | <11 | <11 | ||
20565 | 20565 | 2021-03-09 | Pacifica Senior Living Escondido | San Diego | 23 | 17 | 1 | 1 | 73 | <11 | <11 | ||
20583 | 20583 | 2021-03-09 | Stellar Care | San Diego | 19 | 28 | 1 | 1 | 73 | <11 | <11 | ||
20611 | 20611 | 2021-03-09 | San Francisco Towers | San Francisco | 30 | 15 | 1 | 1 | 75 | <11 | <11 | ||
20667 | 20667 | 2021-03-09 | Mills Estate Villa | San Mateo | 18 | 19 | 1 | 1 | 81 | <11 | <11 | ||
20670 | 20670 | 2021-03-09 | Peninsula Regent (The) | San Mateo | 28 | 1 | 1 | 0 | 81 | <11 | <11 | ||
20719 | 20719 | 2021-03-09 | Merrill Gardens At Campbell | Santa Clara | 34 | 24 | 1 | 1 | 85 | <11 | <11 | ||
20724 | 20724 | 2021-03-09 | Pacific Gardens | Santa Clara | 24 | 13 | 1 | 1 | 85 | <11 | <11 | ||
20725 | 20725 | 2021-03-09 | Palm Villas, Campbell | Santa Clara | 19 | 33 | 1 | 12 | 85 | <11 | |||
20729 | 20729 | 2021-03-09 | Saratoga Retirement Community | Santa Clara | 18 | 1 | 1 | 1 | 85 | <11 | <11 | <11 | |
20733 | 20733 | 2021-03-09 | Sunrise Assisted Living Of Palo Alto | Santa Clara | 21 | 20 | 1 | 1 | 85 | <11 | <11 | ||
20739 | 20739 | 2021-03-09 | Vila Monte | Santa Clara | 1 | 1 | 1 | 0 | 85 | <11 | <11 | <11 | |
20771 | 20771 | 2021-03-09 | Parkrose Gardens Of Fairfield | Solano | 17 | 39 | 1 | 1 | 95 | <11 | <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 );