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
41 rows where county = "Sonoma" and staff_confirmed_cases = 21 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: name, patients_confirmed_cases, patients_deaths, patients_confirmed_cases_note, patients_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
981 | 981 | 2021-06-27 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
1981 | 1981 | 2021-05-11 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
3026 | 3026 | 2021-04-27 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
4075 | 4075 | 2021-04-21 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
5122 | 5122 | 2021-04-06 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
6169 | 6169 | 2021-03-30 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
7216 | 7216 | 2021-03-29 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
8263 | 8263 | 2021-03-25 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
9310 | 9310 | 2021-03-24 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
10357 | 10357 | 2021-03-23 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
11403 | 11403 | 2021-03-22 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
12449 | 12449 | 2021-03-19 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
13494 | 13494 | 2021-03-18 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
14538 | 14538 | 2021-03-17 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
15582 | 15582 | 2021-03-16 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
16626 | 16626 | 2021-03-15 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
17670 | 17670 | 2021-03-12 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
18713 | 18713 | 2021-03-11 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
19754 | 19754 | 2021-03-10 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
20796 | 20796 | 2021-03-09 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
21789 | 21789 | 2021-03-08 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
22825 | 22825 | 2021-03-04 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
23865 | 23865 | 2021-03-03 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
24904 | 24904 | 2021-03-02 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
25943 | 25943 | 2021-03-01 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
26980 | 26980 | 2021-02-26 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
28017 | 28017 | 2021-02-25 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
29053 | 29053 | 2021-02-24 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
49321 | 49321 | 2021-01-25 | Spring Lake Village | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
50249 | 50249 | 2021-01-21 | Spring Lake Village | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
51210 | 51210 | 2021-01-20 | Spring Lake Village | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
52167 | 52167 | 2021-01-19 | Spring Lake Village | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
53100 | 53100 | 2021-01-15 | Spring Lake Village | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
54013 | 54013 | 2021-01-14 | Spring Lake Village | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
54933 | 54933 | 2021-01-13 | Spring Lake Village | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
70727 | 70727 | 2020-12-11 | Primrose Alzheimer's Living Inc | Sonoma | 21 | 35 | 0 | 1 | 97 | <11 | |||
71300 | 71300 | 2020-12-10 | Primrose Alzheimer's Living Inc | Sonoma | 21 | 35 | 0 | 1 | 97 | <11 | |||
71864 | 71864 | 2020-12-09 | Primrose Alzheimer's Living Inc | Sonoma | 21 | 35 | 0 | 1 | 97 | <11 | |||
72418 | 72418 | 2020-12-08 | Primrose Alzheimer's Living Inc | Sonoma | 21 | 35 | 0 | 1 | 97 | <11 | |||
72962 | 72962 | 2020-12-07 | Primrose Alzheimer's Living Inc | Sonoma | 21 | 35 | 0 | 1 | 97 | <11 | |||
73486 | 73486 | 2020-12-04 | Primrose Alzheimer's Living Inc | Sonoma | 21 | 35 | 0 | 1 | 97 | <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 );