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
1,577 rows where patients_deaths = 1 and staff_confirmed_cases = 19 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: staff_deaths_note, date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27 | 27 | 2021-06-27 | Parkview, The | Alameda | 19 | 41 | 0 | 1 | 1 | <11 | |||
53 | 53 | 2021-06-27 | Aegis Assisted Living Of Pleasant Hill | Contra Costa | 19 | 28 | 0 | 1 | 13 | <11 | |||
91 | 91 | 2021-06-27 | Kingston Bay Senior Living | Fresno | 19 | 12 | 0 | 1 | 19 | <11 | |||
92 | 92 | 2021-06-27 | Oakmont Of Fresno | Fresno | 19 | 36 | 0 | 1 | 19 | <11 | |||
188 | 188 | 2021-06-27 | Climb, Inc. | Los Angeles | 19 | 35 | 0 | 1 | 37 | <11 | |||
198 | 198 | 2021-06-27 | Del Mar Park | Los Angeles | 19 | 28 | 0 | 1 | 37 | <11 | |||
410 | 410 | 2021-06-27 | Aegis Assisted Living Of Dana Point | Orange | 19 | 1 | 0 | 1 | 59 | <11 | <11 | ||
477 | 477 | 2021-06-27 | Regency, The | Orange | 19 | 12 | 0 | 1 | 59 | <11 | |||
496 | 496 | 2021-06-27 | Sunrise Of Mission Viejo | Orange | 19 | 28 | 0 | 1 | 59 | <11 | |||
542 | 542 | 2021-06-27 | Corona Residential Care Center LLC | Riverside | 19 | 58 | 0 | 1 | 65 | <11 | |||
588 | 588 | 2021-06-27 | Yorkshire Village | Riverside | 19 | 37 | 0 | 1 | 65 | <11 | |||
700 | 700 | 2021-06-27 | Canyon Villas | San Diego | 19 | 1 | 0 | 1 | 73 | <11 | <11 | ||
790 | 790 | 2021-06-27 | Providence Place | San Francisco | 19 | 28 | 0 | 1 | 75 | <11 | |||
851 | 851 | 2021-06-27 | Pacifica Senior Living Mission Villa | San Mateo | 19 | 42 | 0 | 1 | 81 | <11 | |||
962 | 962 | 2021-06-27 | Vista Prado Inc | Solano | 19 | 36 | 0 | 1 | 95 | <11 | |||
1024 | 1024 | 2021-06-27 | Atria Grand Oaks | Ventura | 19 | 21 | 0 | 1 | 111 | <11 | |||
1080 | 1080 | 2021-05-11 | Parkview, The | Alameda | 19 | 41 | 0 | 1 | 1 | <11 | |||
1106 | 1106 | 2021-05-11 | Aegis Assisted Living Of Pleasant Hill | Contra Costa | 19 | 28 | 0 | 1 | 13 | <11 | |||
1144 | 1144 | 2021-05-11 | Kingston Bay Senior Living | Fresno | 19 | 12 | 0 | 1 | 19 | <11 | |||
1145 | 1145 | 2021-05-11 | Oakmont Of Fresno | Fresno | 19 | 36 | 0 | 1 | 19 | <11 | |||
1241 | 1241 | 2021-05-11 | Del Mar Park | Los Angeles | 19 | 28 | 0 | 1 | 37 | <11 | |||
1433 | 1433 | 2021-05-11 | Aegis Assisted Living Of Dana Point | Orange | 19 | 1 | 0 | 1 | 59 | <11 | <11 | ||
1496 | 1496 | 2021-05-11 | Regency, The | Orange | 19 | 12 | 0 | 1 | 59 | <11 | |||
1515 | 1515 | 2021-05-11 | Sunrise Of Mission Viejo | Orange | 19 | 28 | 0 | 1 | 59 | <11 | |||
1560 | 1560 | 2021-05-11 | Corona Residential Care Center LLC | Riverside | 19 | 58 | 0 | 1 | 65 | <11 | |||
1602 | 1602 | 2021-05-11 | Yorkshire Village | Riverside | 19 | 37 | 0 | 1 | 65 | <11 | |||
1710 | 1710 | 2021-05-11 | Canyon Villas | San Diego | 19 | 1 | 0 | 1 | 73 | <11 | <11 | ||
1795 | 1795 | 2021-05-11 | Providence Place | San Francisco | 19 | 28 | 0 | 1 | 75 | <11 | |||
1854 | 1854 | 2021-05-11 | Pacifica Senior Living Mission Villa | San Mateo | 19 | 42 | 0 | 1 | 81 | <11 | |||
1962 | 1962 | 2021-05-11 | Vista Prado Inc | Solano | 19 | 36 | 0 | 1 | 95 | <11 | |||
2021 | 2021 | 2021-05-11 | Atria Grand Oaks | Ventura | 19 | 21 | 0 | 1 | 111 | <11 | |||
2078 | 2078 | 2021-04-27 | Parkview, The | Alameda | 19 | 41 | 0 | 1 | 1 | <11 | |||
2104 | 2104 | 2021-04-27 | Aegis Assisted Living Of Pleasant Hill | Contra Costa | 19 | 28 | 0 | 1 | 13 | <11 | |||
2142 | 2142 | 2021-04-27 | Kingston Bay Senior Living | Fresno | 19 | 12 | 0 | 1 | 19 | <11 | |||
2143 | 2143 | 2021-04-27 | Oakmont Of Fresno | Fresno | 19 | 36 | 0 | 1 | 19 | <11 | |||
2238 | 2238 | 2021-04-27 | Climb, Inc. | Los Angeles | 19 | 35 | 0 | 1 | 37 | <11 | |||
2248 | 2248 | 2021-04-27 | Del Mar Park | Los Angeles | 19 | 28 | 0 | 1 | 37 | <11 | |||
2459 | 2459 | 2021-04-27 | Aegis Assisted Living Of Dana Point | Orange | 19 | 1 | 0 | 1 | 59 | <11 | <11 | ||
2526 | 2526 | 2021-04-27 | Regency, The | Orange | 19 | 12 | 0 | 1 | 59 | <11 | |||
2545 | 2545 | 2021-04-27 | Sunrise Of Mission Viejo | Orange | 19 | 28 | 0 | 1 | 59 | <11 | |||
2637 | 2637 | 2021-04-27 | Yorkshire Village | Riverside | 19 | 37 | 0 | 1 | 65 | <11 | |||
2748 | 2748 | 2021-04-27 | Canyon Villas | San Diego | 19 | 1 | 0 | 1 | 73 | <11 | <11 | ||
2837 | 2837 | 2021-04-27 | Providence Place | San Francisco | 19 | 28 | 0 | 1 | 75 | <11 | |||
2898 | 2898 | 2021-04-27 | Pacifica Senior Living Mission Villa | San Mateo | 19 | 42 | 0 | 1 | 81 | <11 | |||
3007 | 3007 | 2021-04-27 | Vista Prado Inc | Solano | 19 | 36 | 0 | 1 | 95 | <11 | |||
3069 | 3069 | 2021-04-27 | Atria Grand Oaks | Ventura | 19 | 21 | 0 | 1 | 111 | <11 | |||
3127 | 3127 | 2021-04-21 | Parkview, The | Alameda | 19 | 41 | 0 | 1 | 1 | <11 | |||
3153 | 3153 | 2021-04-21 | Aegis Assisted Living Of Pleasant Hill | Contra Costa | 19 | 28 | 0 | 1 | 13 | <11 | |||
3191 | 3191 | 2021-04-21 | Kingston Bay Senior Living | Fresno | 19 | 12 | 0 | 1 | 19 | <11 | |||
3192 | 3192 | 2021-04-21 | Oakmont Of Fresno | Fresno | 19 | 36 | 0 | 1 | 19 | <11 | |||
3287 | 3287 | 2021-04-21 | Climb, Inc. | Los Angeles | 19 | 35 | 0 | 1 | 37 | <11 | |||
3297 | 3297 | 2021-04-21 | Del Mar Park | Los Angeles | 19 | 28 | 0 | 1 | 37 | <11 | |||
3508 | 3508 | 2021-04-21 | Aegis Assisted Living Of Dana Point | Orange | 19 | 1 | 0 | 1 | 59 | <11 | <11 | ||
3575 | 3575 | 2021-04-21 | Regency, The | Orange | 19 | 12 | 0 | 1 | 59 | <11 | |||
3594 | 3594 | 2021-04-21 | Sunrise Of Mission Viejo | Orange | 19 | 28 | 0 | 1 | 59 | <11 | |||
3686 | 3686 | 2021-04-21 | Yorkshire Village | Riverside | 19 | 37 | 0 | 1 | 65 | <11 | |||
3797 | 3797 | 2021-04-21 | Canyon Villas | San Diego | 19 | 1 | 0 | 1 | 73 | <11 | <11 | ||
3886 | 3886 | 2021-04-21 | Providence Place | San Francisco | 19 | 28 | 0 | 1 | 75 | <11 | |||
3947 | 3947 | 2021-04-21 | Pacifica Senior Living Mission Villa | San Mateo | 19 | 42 | 0 | 1 | 81 | <11 | |||
4056 | 4056 | 2021-04-21 | Vista Prado Inc | Solano | 19 | 36 | 0 | 1 | 95 | <11 | |||
4118 | 4118 | 2021-04-21 | Atria Grand Oaks | Ventura | 19 | 21 | 0 | 1 | 111 | <11 | |||
4176 | 4176 | 2021-04-06 | Parkview, The | Alameda | 19 | 41 | 0 | 1 | 1 | <11 | |||
4202 | 4202 | 2021-04-06 | Aegis Assisted Living Of Pleasant Hill | Contra Costa | 19 | 28 | 0 | 1 | 13 | <11 | |||
4240 | 4240 | 2021-04-06 | Kingston Bay Senior Living | Fresno | 19 | 12 | 0 | 1 | 19 | <11 | |||
4241 | 4241 | 2021-04-06 | Oakmont Of Fresno | Fresno | 19 | 36 | 0 | 1 | 19 | <11 | |||
4336 | 4336 | 2021-04-06 | Climb, Inc. | Los Angeles | 19 | 35 | 0 | 1 | 37 | <11 | |||
4346 | 4346 | 2021-04-06 | Del Mar Park | Los Angeles | 19 | 28 | 0 | 1 | 37 | <11 | |||
4556 | 4556 | 2021-04-06 | Aegis Assisted Living Of Dana Point | Orange | 19 | 1 | 0 | 1 | 59 | <11 | <11 | ||
4623 | 4623 | 2021-04-06 | Regency, The | Orange | 19 | 12 | 0 | 1 | 59 | <11 | |||
4642 | 4642 | 2021-04-06 | Sunrise Of Mission Viejo | Orange | 19 | 28 | 0 | 1 | 59 | <11 | |||
4734 | 4734 | 2021-04-06 | Yorkshire Village | Riverside | 19 | 37 | 0 | 1 | 65 | <11 | |||
4844 | 4844 | 2021-04-06 | Canyon Villas | San Diego | 19 | 1 | 0 | 1 | 73 | <11 | <11 | ||
4907 | 4907 | 2021-04-06 | Stellar Care | San Diego | 19 | 28 | 1 | 1 | 73 | <11 | <11 | ||
4933 | 4933 | 2021-04-06 | Providence Place | San Francisco | 19 | 28 | 0 | 1 | 75 | <11 | |||
4994 | 4994 | 2021-04-06 | Pacifica Senior Living Mission Villa | San Mateo | 19 | 42 | 0 | 1 | 81 | <11 | |||
5103 | 5103 | 2021-04-06 | Vista Prado Inc | Solano | 19 | 36 | 0 | 1 | 95 | <11 | |||
5165 | 5165 | 2021-04-06 | Atria Grand Oaks | Ventura | 19 | 21 | 0 | 1 | 111 | <11 | |||
5223 | 5223 | 2021-03-30 | Parkview, The | Alameda | 19 | 41 | 0 | 1 | 1 | <11 | |||
5249 | 5249 | 2021-03-30 | Aegis Assisted Living Of Pleasant Hill | Contra Costa | 19 | 28 | 0 | 1 | 13 | <11 | |||
5287 | 5287 | 2021-03-30 | Kingston Bay Senior Living | Fresno | 19 | 12 | 0 | 1 | 19 | <11 | |||
5288 | 5288 | 2021-03-30 | Oakmont Of Fresno | Fresno | 19 | 36 | 0 | 1 | 19 | <11 | |||
5383 | 5383 | 2021-03-30 | Climb, Inc. | Los Angeles | 19 | 35 | 0 | 1 | 37 | <11 | |||
5393 | 5393 | 2021-03-30 | Del Mar Park | Los Angeles | 19 | 28 | 0 | 1 | 37 | <11 | |||
5603 | 5603 | 2021-03-30 | Aegis Assisted Living Of Dana Point | Orange | 19 | 1 | 0 | 1 | 59 | <11 | <11 | ||
5670 | 5670 | 2021-03-30 | Regency, The | Orange | 19 | 12 | 0 | 1 | 59 | <11 | |||
5689 | 5689 | 2021-03-30 | Sunrise Of Mission Viejo | Orange | 19 | 28 | 0 | 1 | 59 | <11 | |||
5781 | 5781 | 2021-03-30 | Yorkshire Village | Riverside | 19 | 37 | 0 | 1 | 65 | <11 | |||
5892 | 5892 | 2021-03-30 | Canyon Villas | San Diego | 19 | 1 | 0 | 1 | 73 | <11 | <11 | ||
5955 | 5955 | 2021-03-30 | Stellar Care | San Diego | 19 | 28 | 1 | 1 | 73 | <11 | <11 | ||
5980 | 5980 | 2021-03-30 | Providence Place | San Francisco | 19 | 28 | 0 | 1 | 75 | <11 | |||
6041 | 6041 | 2021-03-30 | Pacifica Senior Living Mission Villa | San Mateo | 19 | 42 | 0 | 1 | 81 | <11 | |||
6150 | 6150 | 2021-03-30 | Vista Prado Inc | Solano | 19 | 36 | 0 | 1 | 95 | <11 | |||
6212 | 6212 | 2021-03-30 | Atria Grand Oaks | Ventura | 19 | 21 | 0 | 1 | 111 | <11 | |||
6270 | 6270 | 2021-03-29 | Parkview, The | Alameda | 19 | 41 | 0 | 1 | 1 | <11 | |||
6296 | 6296 | 2021-03-29 | Aegis Assisted Living Of Pleasant Hill | Contra Costa | 19 | 28 | 0 | 1 | 13 | <11 | |||
6334 | 6334 | 2021-03-29 | Kingston Bay Senior Living | Fresno | 19 | 12 | 0 | 1 | 19 | <11 | |||
6335 | 6335 | 2021-03-29 | Oakmont Of Fresno | Fresno | 19 | 36 | 0 | 1 | 19 | <11 | |||
6430 | 6430 | 2021-03-29 | Climb, Inc. | Los Angeles | 19 | 35 | 0 | 1 | 37 | <11 | |||
6440 | 6440 | 2021-03-29 | Del Mar Park | Los Angeles | 19 | 28 | 0 | 1 | 37 | <11 | |||
6650 | 6650 | 2021-03-29 | Aegis Assisted Living Of Dana Point | Orange | 19 | 1 | 0 | 1 | 59 | <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 );