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
69 rows where county = "Sonoma" and staff_confirmed_cases = 23 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
974 | 974 | 2021-06-27 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
1974 | 1974 | 2021-05-11 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
3019 | 3019 | 2021-04-27 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
4068 | 4068 | 2021-04-21 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
5115 | 5115 | 2021-04-06 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
6162 | 6162 | 2021-03-30 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
7209 | 7209 | 2021-03-29 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
8256 | 8256 | 2021-03-25 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
9303 | 9303 | 2021-03-24 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
10350 | 10350 | 2021-03-23 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
11396 | 11396 | 2021-03-22 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
12442 | 12442 | 2021-03-19 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
13487 | 13487 | 2021-03-18 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
14531 | 14531 | 2021-03-17 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
15575 | 15575 | 2021-03-16 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
16619 | 16619 | 2021-03-15 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
17663 | 17663 | 2021-03-12 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
18706 | 18706 | 2021-03-11 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
19747 | 19747 | 2021-03-10 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
20789 | 20789 | 2021-03-09 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
21782 | 21782 | 2021-03-08 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
22818 | 22818 | 2021-03-04 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
23858 | 23858 | 2021-03-03 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
24897 | 24897 | 2021-03-02 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
25936 | 25936 | 2021-03-01 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
26973 | 26973 | 2021-02-26 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
28010 | 28010 | 2021-02-25 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
29046 | 29046 | 2021-02-24 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
30079 | 30079 | 2021-02-22 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
31113 | 31113 | 2021-02-19 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
32147 | 32147 | 2021-02-18 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
33180 | 33180 | 2021-02-17 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
34210 | 34210 | 2021-02-16 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
35238 | 35238 | 2021-02-12 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
36264 | 36264 | 2021-02-11 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
37289 | 37289 | 2021-02-10 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
38314 | 38314 | 2021-02-09 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
39338 | 39338 | 2021-02-08 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
40356 | 40356 | 2021-02-05 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
41370 | 41370 | 2021-02-04 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
42379 | 42379 | 2021-02-03 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
43387 | 43387 | 2021-02-02 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
44392 | 44392 | 2021-02-01 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
45391 | 45391 | 2021-01-29 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
46386 | 46386 | 2021-01-28 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
47385 | 47385 | 2021-01-27 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
48332 | 48332 | 2021-01-26 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
49319 | 49319 | 2021-01-25 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
50247 | 50247 | 2021-01-21 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
51208 | 51208 | 2021-01-20 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
52165 | 52165 | 2021-01-19 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
53098 | 53098 | 2021-01-15 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
54011 | 54011 | 2021-01-14 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
54931 | 54931 | 2021-01-13 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
55843 | 55843 | 2021-01-12 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
56749 | 56749 | 2021-01-11 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
57632 | 57632 | 2021-01-08 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
58505 | 58505 | 2021-01-07 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
59366 | 59366 | 2021-01-06 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
60215 | 60215 | 2021-01-05 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
61052 | 61052 | 2021-01-04 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
61852 | 61852 | 2020-12-31 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
62632 | 62632 | 2020-12-30 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
63402 | 63402 | 2020-12-29 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
64164 | 64164 | 2020-12-28 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
64887 | 64887 | 2020-12-24 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
65598 | 65598 | 2020-12-23 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
66300 | 66300 | 2020-12-22 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 0 | 1 | 97 | <11 | |||
66991 | 66991 | 2020-12-21 | Primrose Alzheimer's Living Inc | Sonoma | 23 | 36 | 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 );