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
73 rows where county = "Sonoma" and staff_confirmed_cases = 17 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: name, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
966 | 966 | 2021-06-27 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
1966 | 1966 | 2021-05-11 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
3011 | 3011 | 2021-04-27 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
4060 | 4060 | 2021-04-21 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
5107 | 5107 | 2021-04-06 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
6154 | 6154 | 2021-03-30 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
7201 | 7201 | 2021-03-29 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
8248 | 8248 | 2021-03-25 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
9295 | 9295 | 2021-03-24 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
10342 | 10342 | 2021-03-23 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
11388 | 11388 | 2021-03-22 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
12434 | 12434 | 2021-03-19 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
13479 | 13479 | 2021-03-18 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
14523 | 14523 | 2021-03-17 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
15567 | 15567 | 2021-03-16 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
16611 | 16611 | 2021-03-15 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
17655 | 17655 | 2021-03-12 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
18698 | 18698 | 2021-03-11 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
19739 | 19739 | 2021-03-10 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
20781 | 20781 | 2021-03-09 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
21774 | 21774 | 2021-03-08 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
22810 | 22810 | 2021-03-04 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
23850 | 23850 | 2021-03-03 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
24889 | 24889 | 2021-03-02 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
25928 | 25928 | 2021-03-01 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
26965 | 26965 | 2021-02-26 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
28002 | 28002 | 2021-02-25 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
29038 | 29038 | 2021-02-24 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
30071 | 30071 | 2021-02-22 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
31105 | 31105 | 2021-02-19 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
32139 | 32139 | 2021-02-18 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
33172 | 33172 | 2021-02-17 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
34202 | 34202 | 2021-02-16 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
35230 | 35230 | 2021-02-12 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
36256 | 36256 | 2021-02-11 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
37281 | 37281 | 2021-02-10 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
38306 | 38306 | 2021-02-09 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
39330 | 39330 | 2021-02-08 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
40348 | 40348 | 2021-02-05 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
40363 | 40363 | 2021-02-05 | Sunrise Villa Sonoma | Sonoma | 17 | 1 | 0 | 0 | 97 | <11 | |||
41362 | 41362 | 2021-02-04 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
41377 | 41377 | 2021-02-04 | Sunrise Villa Sonoma | Sonoma | 17 | 1 | 0 | 0 | 97 | <11 | |||
42371 | 42371 | 2021-02-03 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
42386 | 42386 | 2021-02-03 | Sunrise Villa Sonoma | Sonoma | 17 | 1 | 0 | 0 | 97 | <11 | |||
43379 | 43379 | 2021-02-02 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
44384 | 44384 | 2021-02-01 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
45383 | 45383 | 2021-01-29 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
46378 | 46378 | 2021-01-28 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
47377 | 47377 | 2021-01-27 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
48324 | 48324 | 2021-01-26 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
49311 | 49311 | 2021-01-25 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
50239 | 50239 | 2021-01-21 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
51200 | 51200 | 2021-01-20 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
52157 | 52157 | 2021-01-19 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
53090 | 53090 | 2021-01-15 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
54003 | 54003 | 2021-01-14 | Brookdale Windsor | Sonoma | 17 | 15 | 0 | 1 | 97 | <11 | |||
54923 | 54923 | 2021-01-13 | Brookdale Windsor | Sonoma | 17 | 15 | 0 | 1 | 97 | <11 | |||
55835 | 55835 | 2021-01-12 | Brookdale Windsor | Sonoma | 17 | 15 | 0 | 1 | 97 | <11 | |||
56741 | 56741 | 2021-01-11 | Brookdale Windsor | Sonoma | 17 | 15 | 0 | 1 | 97 | <11 | |||
57624 | 57624 | 2021-01-08 | Brookdale Windsor | Sonoma | 17 | 15 | 0 | 1 | 97 | <11 | |||
61854 | 61854 | 2020-12-31 | Spring Lake Village | Sonoma | 17 | 1 | 0 | 0 | 97 | <11 | |||
62634 | 62634 | 2020-12-30 | Spring Lake Village | Sonoma | 17 | 1 | 0 | 0 | 97 | <11 | |||
63404 | 63404 | 2020-12-29 | Spring Lake Village | Sonoma | 17 | 1 | 0 | 0 | 97 | <11 | |||
97813 | 97813 | 2020-09-09 | Primrose Alzheimer's Living Inc | Sonoma | 17 | 34 | 0 | 1 | 97 | <11 | |||
98136 | 98136 | 2020-09-08 | Primrose Alzheimer's Living Inc | Sonoma | 17 | 34 | 0 | 1 | 97 | <11 | |||
98460 | 98460 | 2020-09-07 | Primrose Alzheimer's Living Inc | Sonoma | 17 | 34 | 0 | 1 | 97 | <11 | |||
98778 | 98778 | 2020-09-04 | Primrose Alzheimer's Living Inc | Sonoma | 17 | 34 | 0 | 1 | 97 | <11 | |||
99094 | 99094 | 2020-09-03 | Primrose Alzheimer's Living Inc | Sonoma | 17 | 34 | 0 | 1 | 97 | <11 | |||
99407 | 99407 | 2020-09-02 | Primrose Alzheimer's Living Inc | Sonoma | 17 | 34 | 0 | 1 | 97 | <11 | |||
99719 | 99719 | 2020-09-01 | Primrose Alzheimer's Living Inc | Sonoma | 17 | 34 | 0 | 1 | 97 | <11 | |||
100029 | 100029 | 2020-08-31 | Primrose Alzheimer's Living Inc | Sonoma | 17 | 34 | 0 | 1 | 97 | <11 | |||
100334 | 100334 | 2020-08-28 | Primrose Alzheimer's Living Inc | Sonoma | 17 | 34 | 0 | 1 | 97 | <11 | |||
100638 | 100638 | 2020-08-27 | Primrose Alzheimer's Living Inc | Sonoma | 17 | 33 | 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 );