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
176 rows where county = "Sacramento" and staff_confirmed_cases = 14 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: patients_deaths, staff_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
631 | 631 | 2021-06-27 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
1646 | 1646 | 2021-05-11 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
2680 | 2680 | 2021-04-27 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
3729 | 3729 | 2021-04-21 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
4776 | 4776 | 2021-04-06 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
5823 | 5823 | 2021-03-30 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
6870 | 6870 | 2021-03-29 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
7916 | 7916 | 2021-03-25 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
7917 | 7917 | 2021-03-25 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
8963 | 8963 | 2021-03-24 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
8964 | 8964 | 2021-03-24 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
10010 | 10010 | 2021-03-23 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
10011 | 10011 | 2021-03-23 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
11056 | 11056 | 2021-03-22 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
11057 | 11057 | 2021-03-22 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
12102 | 12102 | 2021-03-19 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
12103 | 12103 | 2021-03-19 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
13147 | 13147 | 2021-03-18 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
13148 | 13148 | 2021-03-18 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
14191 | 14191 | 2021-03-17 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
14192 | 14192 | 2021-03-17 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
15235 | 15235 | 2021-03-16 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
15236 | 15236 | 2021-03-16 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
16279 | 16279 | 2021-03-15 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
16280 | 16280 | 2021-03-15 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
17323 | 17323 | 2021-03-12 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
17324 | 17324 | 2021-03-12 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
18366 | 18366 | 2021-03-11 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
18367 | 18367 | 2021-03-11 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
19392 | 19392 | 2021-03-10 | Greenhaven Estates | Sacramento | 14 | 1 | 0 | 1 | 67 | <11 | <11 | ||
19408 | 19408 | 2021-03-10 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
19409 | 19409 | 2021-03-10 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
20434 | 20434 | 2021-03-09 | Greenhaven Estates | Sacramento | 14 | 1 | 0 | 1 | 67 | <11 | <11 | ||
20450 | 20450 | 2021-03-09 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
20451 | 20451 | 2021-03-09 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
21440 | 21440 | 2021-03-08 | Greenhaven Estates | Sacramento | 14 | 1 | 0 | 1 | 67 | <11 | <11 | ||
21456 | 21456 | 2021-03-08 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
21457 | 21457 | 2021-03-08 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
22464 | 22464 | 2021-03-04 | Greenhaven Estates | Sacramento | 14 | 1 | 0 | 1 | 67 | <11 | <11 | ||
22479 | 22479 | 2021-03-04 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
22480 | 22480 | 2021-03-04 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
23504 | 23504 | 2021-03-03 | Greenhaven Estates | Sacramento | 14 | 1 | 0 | 1 | 67 | <11 | <11 | ||
23519 | 23519 | 2021-03-03 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
23520 | 23520 | 2021-03-03 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
24544 | 24544 | 2021-03-02 | Greenhaven Estates | Sacramento | 14 | 1 | 0 | 1 | 67 | <11 | <11 | ||
24559 | 24559 | 2021-03-02 | Sunrise Assisted Living Of FairOaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
24560 | 24560 | 2021-03-02 | Sunrise Assisted Living OfCarmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
25583 | 25583 | 2021-03-01 | Greenhaven Estates | Sacramento | 14 | 1 | 0 | 1 | 67 | <11 | <11 | ||
25598 | 25598 | 2021-03-01 | Sunrise Assisted Living Of FairOaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
25599 | 25599 | 2021-03-01 | Sunrise Assisted Living OfCarmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
26620 | 26620 | 2021-02-26 | Greenhaven Estates | Sacramento | 14 | 1 | 0 | 1 | 67 | <11 | <11 | ||
26635 | 26635 | 2021-02-26 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
26636 | 26636 | 2021-02-26 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
27657 | 27657 | 2021-02-25 | Greenhaven Estates | Sacramento | 14 | 1 | 0 | 1 | 67 | <11 | <11 | ||
27672 | 27672 | 2021-02-25 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
27673 | 27673 | 2021-02-25 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
28693 | 28693 | 2021-02-24 | Greenhaven Estates | Sacramento | 14 | 1 | 0 | 1 | 67 | <11 | <11 | ||
28708 | 28708 | 2021-02-24 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
28709 | 28709 | 2021-02-24 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
29727 | 29727 | 2021-02-22 | Greenhaven Estates | Sacramento | 14 | 1 | 0 | 1 | 67 | <11 | <11 | ||
29742 | 29742 | 2021-02-22 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
29743 | 29743 | 2021-02-22 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
30761 | 30761 | 2021-02-19 | Greenhaven Estates | Sacramento | 14 | 1 | 0 | 1 | 67 | <11 | <11 | ||
30776 | 30776 | 2021-02-19 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
30777 | 30777 | 2021-02-19 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
31795 | 31795 | 2021-02-18 | Greenhaven Estates | Sacramento | 14 | 1 | 0 | 1 | 67 | <11 | <11 | ||
31810 | 31810 | 2021-02-18 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
31811 | 31811 | 2021-02-18 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
32828 | 32828 | 2021-02-17 | Greenhaven Estates | Sacramento | 14 | 1 | 0 | 1 | 67 | <11 | <11 | ||
32843 | 32843 | 2021-02-17 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
32844 | 32844 | 2021-02-17 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
33859 | 33859 | 2021-02-16 | Greenhaven Estates | Sacramento | 14 | 1 | 0 | 1 | 67 | <11 | <11 | ||
33874 | 33874 | 2021-02-16 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
33875 | 33875 | 2021-02-16 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
34888 | 34888 | 2021-02-12 | Greenhaven Estates | Sacramento | 14 | 1 | 0 | 1 | 67 | <11 | <11 | ||
34903 | 34903 | 2021-02-12 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
34904 | 34904 | 2021-02-12 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
35915 | 35915 | 2021-02-11 | Greenhaven Estates | Sacramento | 14 | 1 | 0 | 1 | 67 | <11 | <11 | ||
35930 | 35930 | 2021-02-11 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
35931 | 35931 | 2021-02-11 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
36940 | 36940 | 2021-02-10 | Greenhaven Estates | Sacramento | 14 | 1 | 0 | 1 | 67 | <11 | <11 | ||
36955 | 36955 | 2021-02-10 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
36956 | 36956 | 2021-02-10 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
37965 | 37965 | 2021-02-09 | Greenhaven Estates | Sacramento | 14 | 1 | 0 | 1 | 67 | <11 | <11 | ||
37980 | 37980 | 2021-02-09 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
37981 | 37981 | 2021-02-09 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
38989 | 38989 | 2021-02-08 | Greenhaven Estates | Sacramento | 14 | 1 | 0 | 1 | 67 | <11 | <11 | ||
39004 | 39004 | 2021-02-08 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
39005 | 39005 | 2021-02-08 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
40009 | 40009 | 2021-02-05 | Greenhaven Estates | Sacramento | 14 | 1 | 0 | 1 | 67 | <11 | <11 | ||
40024 | 40024 | 2021-02-05 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
40025 | 40025 | 2021-02-05 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
41024 | 41024 | 2021-02-04 | Greenhaven Estates | Sacramento | 14 | 1 | 0 | 1 | 67 | <11 | <11 | ||
41039 | 41039 | 2021-02-04 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
41040 | 41040 | 2021-02-04 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
42035 | 42035 | 2021-02-03 | Greenhaven Estates | Sacramento | 14 | 1 | 0 | 1 | 67 | <11 | <11 | ||
42050 | 42050 | 2021-02-03 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
42051 | 42051 | 2021-02-03 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
43043 | 43043 | 2021-02-02 | Greenhaven Estates | Sacramento | 14 | 1 | 0 | 1 | 67 | <11 | <11 | ||
43058 | 43058 | 2021-02-02 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 |
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 );