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
79 rows where staff_confirmed_cases = 31 and staff_deaths = 1 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: county, patients_confirmed_cases, patients_deaths, patients_confirmed_cases_note, patients_deaths_note
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1624 | 1624 | 2021-05-11 | Eskaton Village | Sacramento | 31 | 19 | 1 | 1 | 67 | <11 | <11 | ||
2659 | 2659 | 2021-04-27 | Eskaton Village | Sacramento | 31 | 19 | 1 | 1 | 67 | <11 | <11 | ||
3708 | 3708 | 2021-04-21 | Eskaton Village | Sacramento | 31 | 19 | 1 | 1 | 67 | <11 | <11 | ||
4755 | 4755 | 2021-04-06 | Eskaton Village | Sacramento | 31 | 19 | 1 | 1 | 67 | <11 | <11 | ||
5772 | 5772 | 2021-03-30 | Vineyard Place | Riverside | 31 | 42 | 1 | 18 | 65 | <11 | |||
5802 | 5802 | 2021-03-30 | Eskaton Village | Sacramento | 31 | 19 | 1 | 1 | 67 | <11 | <11 | ||
6819 | 6819 | 2021-03-29 | Vineyard Place | Riverside | 31 | 42 | 1 | 18 | 65 | <11 | |||
6849 | 6849 | 2021-03-29 | Eskaton Village | Sacramento | 31 | 19 | 1 | 1 | 67 | <11 | <11 | ||
7866 | 7866 | 2021-03-25 | Vineyard Place | Riverside | 31 | 42 | 1 | 18 | 65 | <11 | |||
7896 | 7896 | 2021-03-25 | Eskaton Village | Sacramento | 31 | 19 | 1 | 1 | 67 | <11 | <11 | ||
8913 | 8913 | 2021-03-24 | Vineyard Place | Riverside | 31 | 42 | 1 | 18 | 65 | <11 | |||
8943 | 8943 | 2021-03-24 | Eskaton Village | Sacramento | 31 | 19 | 1 | 1 | 67 | <11 | <11 | ||
9960 | 9960 | 2021-03-23 | Vineyard Place | Riverside | 31 | 42 | 1 | 18 | 65 | <11 | |||
9990 | 9990 | 2021-03-23 | Eskaton Village | Sacramento | 31 | 19 | 1 | 1 | 67 | <11 | <11 | ||
11006 | 11006 | 2021-03-22 | Vineyard Place | Riverside | 31 | 42 | 1 | 18 | 65 | <11 | |||
11036 | 11036 | 2021-03-22 | Eskaton Village | Sacramento | 31 | 19 | 1 | 1 | 67 | <11 | <11 | ||
12052 | 12052 | 2021-03-19 | Vineyard Place | Riverside | 31 | 42 | 1 | 18 | 65 | <11 | |||
12082 | 12082 | 2021-03-19 | Eskaton Village | Sacramento | 31 | 19 | 1 | 1 | 67 | <11 | <11 | ||
13097 | 13097 | 2021-03-18 | Vineyard Place | Riverside | 31 | 42 | 1 | 18 | 65 | <11 | |||
13127 | 13127 | 2021-03-18 | Eskaton Village | Sacramento | 31 | 19 | 1 | 1 | 67 | <11 | <11 | ||
14141 | 14141 | 2021-03-17 | Vineyard Place | Riverside | 31 | 42 | 1 | 18 | 65 | <11 | |||
14171 | 14171 | 2021-03-17 | Eskaton Village | Sacramento | 31 | 19 | 1 | 1 | 67 | <11 | <11 | ||
15185 | 15185 | 2021-03-16 | Vineyard Place | Riverside | 31 | 42 | 1 | 18 | 65 | <11 | |||
15215 | 15215 | 2021-03-16 | Eskaton Village | Sacramento | 31 | 19 | 1 | 1 | 67 | <11 | <11 | ||
16229 | 16229 | 2021-03-15 | Vineyard Place | Riverside | 31 | 42 | 1 | 18 | 65 | <11 | |||
16259 | 16259 | 2021-03-15 | Eskaton Village | Sacramento | 31 | 19 | 1 | 1 | 67 | <11 | <11 | ||
16712 | 16712 | 2021-03-12 | Fremont Village | Alameda | 31 | 57 | 1 | 14 | 1 | <11 | |||
17273 | 17273 | 2021-03-12 | Vineyard Place | Riverside | 31 | 42 | 1 | 18 | 65 | <11 | |||
17756 | 17756 | 2021-03-11 | Fremont Village | Alameda | 31 | 56 | 1 | 13 | 1 | <11 | |||
18316 | 18316 | 2021-03-11 | Vineyard Place | Riverside | 31 | 42 | 1 | 18 | 65 | <11 | |||
18799 | 18799 | 2021-03-10 | Fremont Village | Alameda | 31 | 56 | 1 | 13 | 1 | <11 | |||
19358 | 19358 | 2021-03-10 | Vineyard Place | Riverside | 31 | 42 | 1 | 18 | 65 | <11 | |||
19840 | 19840 | 2021-03-09 | Fremont Village | Alameda | 31 | 56 | 1 | 13 | 1 | <11 | |||
20400 | 20400 | 2021-03-09 | Vineyard Place | Riverside | 31 | 42 | 1 | 18 | 65 | <11 | |||
20882 | 20882 | 2021-03-08 | Fremont Village | Alameda | 31 | 56 | 1 | 13 | 1 | <11 | |||
21406 | 21406 | 2021-03-08 | Vineyard Place | Riverside | 31 | 42 | 1 | 18 | 65 | <11 | |||
21871 | 21871 | 2021-03-04 | Fremont Village | Alameda | 31 | 56 | 1 | 13 | 1 | <11 | |||
22911 | 22911 | 2021-03-03 | Fremont Village | Alameda | 31 | 56 | 1 | 13 | 1 | <11 | |||
23951 | 23951 | 2021-03-02 | Fremont Village | Alameda | 31 | 56 | 1 | 13 | 1 | <11 | |||
24990 | 24990 | 2021-03-01 | Fremont Village | Alameda | 31 | 56 | 1 | 13 | 1 | <11 | |||
26029 | 26029 | 2021-02-26 | Fremont Village | Alameda | 31 | 56 | 1 | 13 | 1 | <11 | |||
27066 | 27066 | 2021-02-25 | Fremont Village | Alameda | 31 | 56 | 1 | 13 | 1 | <11 | |||
28103 | 28103 | 2021-02-24 | Fremont Village | Alameda | 31 | 56 | 1 | 13 | 1 | <11 | |||
29139 | 29139 | 2021-02-22 | Fremont Village | Alameda | 31 | 56 | 1 | 13 | 1 | <11 | |||
30172 | 30172 | 2021-02-19 | Fremont Village | Alameda | 31 | 56 | 1 | 13 | 1 | <11 | |||
31206 | 31206 | 2021-02-18 | Fremont Village | Alameda | 31 | 56 | 1 | 13 | 1 | <11 | |||
32239 | 32239 | 2021-02-17 | Fremont Village | Alameda | 31 | 56 | 1 | 13 | 1 | <11 | |||
33272 | 33272 | 2021-02-16 | Fremont Village | Alameda | 31 | 56 | 1 | 13 | 1 | <11 | |||
34302 | 34302 | 2021-02-12 | Fremont Village | Alameda | 31 | 56 | 1 | 13 | 1 | <11 | |||
35329 | 35329 | 2021-02-11 | Fremont Village | Alameda | 31 | 56 | 1 | 13 | 1 | <11 | |||
36355 | 36355 | 2021-02-10 | Fremont Village | Alameda | 31 | 56 | 1 | 13 | 1 | <11 | |||
37380 | 37380 | 2021-02-09 | Fremont Village | Alameda | 31 | 56 | 1 | 13 | 1 | <11 | |||
38405 | 38405 | 2021-02-08 | Fremont Village | Alameda | 31 | 56 | 1 | 13 | 1 | <11 | |||
39428 | 39428 | 2021-02-05 | Fremont Village | Alameda | 31 | 56 | 1 | 13 | 1 | <11 | |||
40446 | 40446 | 2021-02-04 | Fremont Village | Alameda | 31 | 56 | 1 | 13 | 1 | <11 | |||
41459 | 41459 | 2021-02-03 | Fremont Village | Alameda | 31 | 56 | 1 | 13 | 1 | <11 | |||
42469 | 42469 | 2021-02-02 | Fremont Village | Alameda | 31 | 56 | 1 | 13 | 1 | <11 | |||
43476 | 43476 | 2021-02-01 | Fremont Village | Alameda | 31 | 56 | 1 | 13 | 1 | <11 | |||
44481 | 44481 | 2021-01-29 | Fremont Village | Alameda | 31 | 56 | 1 | 13 | 1 | <11 | |||
45479 | 45479 | 2021-01-28 | Fremont Village | Alameda | 31 | 56 | 1 | 13 | 1 | <11 | |||
46474 | 46474 | 2021-01-27 | Fremont Village | Alameda | 31 | 56 | 1 | 13 | 1 | <11 | |||
46761 | 46761 | 2021-01-27 | Silverado Senior Living - Sierra Vista | Los Angeles | 31 | 53 | 1 | 1 | 37 | <11 | <11 | ||
47470 | 47470 | 2021-01-26 | Fremont Village | Alameda | 31 | 56 | 1 | 13 | 1 | <11 | |||
47734 | 47734 | 2021-01-26 | Silverado Senior Living – Sierra Vista | Los Angeles | 31 | 53 | 1 | 1 | 37 | <11 | <11 | ||
48413 | 48413 | 2021-01-25 | Fremont Village | Alameda | 31 | 56 | 1 | 13 | 1 | <11 | |||
48698 | 48698 | 2021-01-25 | Silverado Senior Living – Sierra Vista | Los Angeles | 31 | 53 | 1 | 1 | 37 | <11 | <11 | ||
49403 | 49403 | 2021-01-21 | Fremont Village | Alameda | 31 | 53 | 1 | 13 | 1 | <11 | |||
49660 | 49660 | 2021-01-21 | Silverado Senior Living – Sierra Vista | Los Angeles | 31 | 53 | 1 | 1 | 37 | <11 | <11 | ||
50326 | 50326 | 2021-01-20 | Fremont Village | Alameda | 31 | 53 | 1 | 13 | 1 | <11 | |||
50601 | 50601 | 2021-01-20 | Silverado Senior Living – Sierra Vista | Los Angeles | 31 | 53 | 1 | 1 | 37 | <11 | <11 | ||
51288 | 51288 | 2021-01-19 | Fremont Village | Alameda | 31 | 53 | 1 | 13 | 1 | <11 | |||
51561 | 51561 | 2021-01-19 | Silverado Senior Living – Sierra Vista | Los Angeles | 31 | 53 | 1 | 1 | 37 | <11 | <11 | ||
58110 | 58110 | 2021-01-07 | Town & Country | Orange | 31 | 1 | 1 | 0 | 59 | <11 | <11 | ||
58977 | 58977 | 2021-01-06 | Town & Country | Orange | 31 | 1 | 1 | 0 | 59 | <11 | <11 | ||
115329 | 115329 | 2020-05-20 | Silverado Senior Living – Beverly Place | Los Angeles | 31 | 53 | 1 | 12 | 37 | <11 | |||
115406 | 115406 | 2020-05-19 | Silverado Senior Living – Beverly Place | Los Angeles | 31 | 53 | 1 | 12 | 37 | <11 | |||
115481 | 115481 | 2020-05-18 | Silverado Senior Living – Beverly Place | Los Angeles | 31 | 53 | 1 | 12 | 37 | <11 | |||
115555 | 115555 | 2020-05-17 | Silverado Senior Living – Beverly Place | Los Angeles | 31 | 53 | 1 | 12 | 37 | <11 | |||
115628 | 115628 | 2020-05-16 | Silverado Senior Living – Beverly Place | Los Angeles | 31 | 53 | 1 | 12 | 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 );