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
893 rows where staff_confirmed_cases = 27 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: fips, staff_deaths_note, patients_deaths_note, date (date)
county 18 ✖
- Los Angeles 359
- Sacramento 96
- Orange 81
- Contra Costa 63
- Santa Clara 60
- San Bernardino 51
- Ventura 36
- Santa Barbara 31
- San Diego 24
- Alameda 19
- Riverside 19
- San Mateo 18
- Fresno 10
- Sonoma 9
- Marin 7
- San Francisco 4
- Shasta 3
- Yolo 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37375 | 37375 | 2021-02-09 | Creekview Assisted Living | Alameda | 27 | 25 | 0 | 1 | 1 | <11 | |||
38400 | 38400 | 2021-02-08 | Creekview Assisted Living | Alameda | 27 | 25 | 0 | 1 | 1 | <11 | |||
104607 | 104607 | 2020-08-10 | Fremont Village | Alameda | 27 | 48 | 1 | 11 | 1 | <11 | |||
104865 | 104865 | 2020-08-09 | Fremont Village | Alameda | 27 | 48 | 1 | 11 | 1 | <11 | |||
105118 | 105118 | 2020-08-08 | Fremont Village | Alameda | 27 | 48 | 1 | 11 | 1 | <11 | |||
105369 | 105369 | 2020-08-07 | Fremont Village | Alameda | 27 | 48 | 1 | 1 | 1 | <11 | <11 | ||
105610 | 105610 | 2020-08-06 | Fremont Village | Alameda | 27 | 48 | 0 | 1 | 1 | <11 | |||
105848 | 105848 | 2020-08-05 | Fremont Village | Alameda | 27 | 48 | 0 | 1 | 1 | <11 | |||
106079 | 106079 | 2020-08-04 | Fremont Village | Alameda | 27 | 47 | 1 | 1 | 1 | <11 | <11 | ||
106312 | 106312 | 2020-08-03 | Fremont Village | Alameda | 27 | 47 | 0 | 1 | 1 | <11 | |||
106545 | 106545 | 2020-08-02 | Fremont Village | Alameda | 27 | 47 | 0 | 1 | 1 | <11 | |||
106777 | 106777 | 2020-08-01 | Fremont Village | Alameda | 27 | 47 | 0 | 1 | 1 | <11 | |||
107005 | 107005 | 2020-07-31 | Fremont Village | Alameda | 27 | 47 | 0 | 1 | 1 | <11 | |||
107223 | 107223 | 2020-07-30 | Fremont Village | Alameda | 27 | 47 | 0 | 1 | 1 | <11 | |||
107441 | 107441 | 2020-07-29 | Fremont Village | Alameda | 27 | 47 | 0 | 1 | 1 | <11 | |||
107656 | 107656 | 2020-07-28 | Fremont Village | Alameda | 27 | 47 | 0 | 1 | 1 | <11 | |||
107863 | 107863 | 2020-07-27 | Fremont Village | Alameda | 27 | 47 | 0 | 1 | 1 | <11 | |||
108065 | 108065 | 2020-07-26 | Fremont Village | Alameda | 27 | 47 | 0 | 1 | 1 | <11 | |||
108265 | 108265 | 2020-07-25 | Fremont Village | Alameda | 27 | 47 | 0 | 1 | 1 | <11 | |||
60 | 60 | 2021-06-27 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
1113 | 1113 | 2021-05-11 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
2111 | 2111 | 2021-04-27 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
3160 | 3160 | 2021-04-21 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
4209 | 4209 | 2021-04-06 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
5256 | 5256 | 2021-03-30 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
6303 | 6303 | 2021-03-29 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
7350 | 7350 | 2021-03-25 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
8397 | 8397 | 2021-03-24 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
9444 | 9444 | 2021-03-23 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
10491 | 10491 | 2021-03-22 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
11537 | 11537 | 2021-03-19 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
12582 | 12582 | 2021-03-18 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
13627 | 13627 | 2021-03-17 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
14671 | 14671 | 2021-03-16 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
15715 | 15715 | 2021-03-15 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
16759 | 16759 | 2021-03-12 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
17803 | 17803 | 2021-03-11 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
18845 | 18845 | 2021-03-10 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
19887 | 19887 | 2021-03-09 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
20929 | 20929 | 2021-03-08 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
21918 | 21918 | 2021-03-04 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
22958 | 22958 | 2021-03-03 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
23998 | 23998 | 2021-03-02 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
25037 | 25037 | 2021-03-01 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
26076 | 26076 | 2021-02-26 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
27113 | 27113 | 2021-02-25 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
28150 | 28150 | 2021-02-24 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
29185 | 29185 | 2021-02-22 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
30219 | 30219 | 2021-02-19 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
31253 | 31253 | 2021-02-18 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
32286 | 32286 | 2021-02-17 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
33318 | 33318 | 2021-02-16 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
34347 | 34347 | 2021-02-12 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
35374 | 35374 | 2021-02-11 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
36400 | 36400 | 2021-02-10 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
37425 | 37425 | 2021-02-09 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
38450 | 38450 | 2021-02-08 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
39473 | 39473 | 2021-02-05 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
40490 | 40490 | 2021-02-04 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
41503 | 41503 | 2021-02-03 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
42513 | 42513 | 2021-02-02 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
43520 | 43520 | 2021-02-01 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
44525 | 44525 | 2021-01-29 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
45523 | 45523 | 2021-01-28 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
46517 | 46517 | 2021-01-27 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
47512 | 47512 | 2021-01-26 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
48454 | 48454 | 2021-01-25 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
49443 | 49443 | 2021-01-21 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
50364 | 50364 | 2021-01-20 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
51325 | 51325 | 2021-01-19 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
52278 | 52278 | 2021-01-15 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
53197 | 53197 | 2021-01-14 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
54121 | 54121 | 2021-01-13 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
55040 | 55040 | 2021-01-12 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
55951 | 55951 | 2021-01-11 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
56854 | 56854 | 2021-01-08 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
57735 | 57735 | 2021-01-07 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
58605 | 58605 | 2021-01-06 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
59464 | 59464 | 2021-01-05 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
60312 | 60312 | 2021-01-04 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
116497 | 116497 | 2020-04-28 | Chateau III | Contra Costa | 27 | 39 | 13 | ||||||
116530 | 116530 | 2020-04-27 | Chateau III | Contra Costa | 27 | 39 | 13 | ||||||
40528 | 40528 | 2021-02-04 | Veterans Home Of California-Fresno | Fresno | 27 | 12 | 0 | 0 | 19 | ||||
41541 | 41541 | 2021-02-03 | Veterans Home Of California-Fresno | Fresno | 27 | 12 | 0 | 0 | 19 | ||||
42551 | 42551 | 2021-02-02 | Veterans Home Of California-Fresno | Fresno | 27 | 12 | 0 | 0 | 19 | ||||
43558 | 43558 | 2021-02-01 | Veterans Home Of California-Fresno | Fresno | 27 | 12 | 0 | 0 | 19 | ||||
44563 | 44563 | 2021-01-29 | Veterans Home Of California- Fresno | Fresno | 27 | 12 | 0 | 0 | 19 | ||||
46550 | 46550 | 2021-01-27 | Palm Village Retirement Community | Fresno | 27 | 17 | 0 | 0 | 19 | ||||
47545 | 47545 | 2021-01-26 | Palm Village Retirement Community | Fresno | 27 | 17 | 0 | 0 | 19 | ||||
48487 | 48487 | 2021-01-25 | Palm Village Retirement Community | Fresno | 27 | 17 | 0 | 0 | 19 | ||||
49475 | 49475 | 2021-01-21 | Palm Village Retirement Community | Fresno | 27 | 17 | 0 | 0 | 19 | ||||
50396 | 50396 | 2021-01-20 | Palm Village Retirement Community | Fresno | 27 | 17 | 0 | 0 | 19 | ||||
150 | 150 | 2021-06-27 | Belmont Village Rancho Palos Verdes | Los Angeles | 27 | 24 | 0 | 1 | 37 | <11 | |||
152 | 152 | 2021-06-27 | Beverly Hills Carmel Retirement Hotel | Los Angeles | 27 | 22 | 1 | 1 | 37 | <11 | <11 | ||
168 | 168 | 2021-06-27 | Brookdale San Dimas | Los Angeles | 27 | 26 | 0 | 1 | 37 | <11 | |||
187 | 187 | 2021-06-27 | Clearwater At South Bay | Los Angeles | 27 | 22 | 0 | 1 | 37 | <11 | |||
1197 | 1197 | 2021-05-11 | Belmont Village Rancho Palos Verdes | Los Angeles | 27 | 24 | 0 | 1 | 37 | <11 | |||
1199 | 1199 | 2021-05-11 | Beverly Hills Carmel Retirement Hotel | Los Angeles | 27 | 22 | 1 | 1 | 37 | <11 | <11 | ||
1215 | 1215 | 2021-05-11 | Brookdale San Dimas | Los Angeles | 27 | 26 | 0 | 1 | 37 | <11 | |||
1232 | 1232 | 2021-05-11 | Clearwater At South Bay | Los Angeles | 27 | 22 | 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 );