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 county = "Placer" and staff_confirmed_cases = 22 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: name, staff_deaths, patients_deaths, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
519 | 519 | 2021-06-27 | Sterling Court At Roseville | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
1538 | 1538 | 2021-05-11 | Sterling Court At Roseville | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
2568 | 2568 | 2021-04-27 | Sterling Court At Roseville | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
3617 | 3617 | 2021-04-21 | Sterling Court At Roseville | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
4660 | 4660 | 2021-04-06 | Oakmont Of Roseville | Placer | 22 | 16 | 1 | 1 | 61 | <11 | <11 | ||
4665 | 4665 | 2021-04-06 | Sterling Court At Roseville | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
5707 | 5707 | 2021-03-30 | Oakmont Of Roseville | Placer | 22 | 16 | 1 | 1 | 61 | <11 | <11 | ||
5712 | 5712 | 2021-03-30 | Sterling Court At Roseville | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
6754 | 6754 | 2021-03-29 | Oakmont Of Roseville | Placer | 22 | 16 | 1 | 1 | 61 | <11 | <11 | ||
6759 | 6759 | 2021-03-29 | Sterling Court At Roseville | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
7801 | 7801 | 2021-03-25 | Oakmont Of Roseville | Placer | 22 | 16 | 1 | 1 | 61 | <11 | <11 | ||
7806 | 7806 | 2021-03-25 | Sterling Court At Roseville | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
8848 | 8848 | 2021-03-24 | Oakmont Of Roseville | Placer | 22 | 16 | 1 | 1 | 61 | <11 | <11 | ||
8853 | 8853 | 2021-03-24 | Sterling Court At Roseville | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
9895 | 9895 | 2021-03-23 | Oakmont Of Roseville | Placer | 22 | 16 | 1 | 1 | 61 | <11 | <11 | ||
9900 | 9900 | 2021-03-23 | Sterling Court At Roseville | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
10941 | 10941 | 2021-03-22 | Oakmont Of Roseville | Placer | 22 | 16 | 1 | 1 | 61 | <11 | <11 | ||
10946 | 10946 | 2021-03-22 | Sterling Court At Roseville | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
11987 | 11987 | 2021-03-19 | Oakmont Of Roseville | Placer | 22 | 16 | 1 | 1 | 61 | <11 | <11 | ||
11992 | 11992 | 2021-03-19 | Sterling Court At Roseville | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
13032 | 13032 | 2021-03-18 | Oakmont Of Roseville | Placer | 22 | 16 | 1 | 1 | 61 | <11 | <11 | ||
13037 | 13037 | 2021-03-18 | Sterling Court At Roseville | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
14077 | 14077 | 2021-03-17 | Oakmont Of Roseville | Placer | 22 | 16 | 1 | 1 | 61 | <11 | <11 | ||
14082 | 14082 | 2021-03-17 | Sterling Court At Roseville | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
15121 | 15121 | 2021-03-16 | Oakmont Of Roseville | Placer | 22 | 16 | 1 | 1 | 61 | <11 | <11 | ||
15126 | 15126 | 2021-03-16 | Sterling Court At Roseville | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
16165 | 16165 | 2021-03-15 | Oakmont Of Roseville | Placer | 22 | 16 | 1 | 1 | 61 | <11 | <11 | ||
16170 | 16170 | 2021-03-15 | Sterling Court At Roseville | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
17214 | 17214 | 2021-03-12 | Sterling Court At Roseville | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
18257 | 18257 | 2021-03-11 | Sterling Court At Roseville | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
19299 | 19299 | 2021-03-10 | Sterling Court At Roseville | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
20341 | 20341 | 2021-03-09 | Sterling Court At Roseville | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
21352 | 21352 | 2021-03-08 | Sterling Court At Roseville | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
22371 | 22371 | 2021-03-04 | Sterling Court At Roseville | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
23411 | 23411 | 2021-03-03 | Sterling Court At Roseville | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
24451 | 24451 | 2021-03-02 | Sterling Court At Roseville | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
25480 | 25480 | 2021-03-01 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
26517 | 26517 | 2021-02-26 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
27554 | 27554 | 2021-02-25 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
28590 | 28590 | 2021-02-24 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
29624 | 29624 | 2021-02-22 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
30658 | 30658 | 2021-02-19 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
31692 | 31692 | 2021-02-18 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
32725 | 32725 | 2021-02-17 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
33756 | 33756 | 2021-02-16 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
34785 | 34785 | 2021-02-12 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
35812 | 35812 | 2021-02-11 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
36837 | 36837 | 2021-02-10 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
37863 | 37863 | 2021-02-09 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
38887 | 38887 | 2021-02-08 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
39909 | 39909 | 2021-02-05 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
40924 | 40924 | 2021-02-04 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
41935 | 41935 | 2021-02-03 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
42944 | 42944 | 2021-02-02 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
43950 | 43950 | 2021-02-01 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
44953 | 44953 | 2021-01-29 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
45948 | 45948 | 2021-01-28 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
46944 | 46944 | 2021-01-27 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
47910 | 47910 | 2021-01-26 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
48881 | 48881 | 2021-01-25 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
49833 | 49833 | 2021-01-21 | Atria Rocklin | Placer | 22 | 30 | 0 | 1 | 61 | <11 | |||
49835 | 49835 | 2021-01-21 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
50781 | 50781 | 2021-01-20 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
51741 | 51741 | 2021-01-19 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
52685 | 52685 | 2021-01-15 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
53599 | 53599 | 2021-01-14 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
54521 | 54521 | 2021-01-13 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
55435 | 55435 | 2021-01-12 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
56345 | 56345 | 2021-01-11 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
57239 | 57239 | 2021-01-08 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
57244 | 57244 | 2021-01-08 | Oakmont Of Roseville | Placer | 22 | 16 | 0 | 0 | 61 | ||||
58116 | 58116 | 2021-01-07 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
58983 | 58983 | 2021-01-06 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
59838 | 59838 | 2021-01-05 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
60682 | 60682 | 2021-01-04 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
61498 | 61498 | 2020-12-31 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
62286 | 62286 | 2020-12-30 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
63065 | 63065 | 2020-12-29 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <11 | ||
63832 | 63832 | 2020-12-28 | Brookdale Sterling Court | Placer | 22 | 52 | 1 | 1 | 61 | <11 | <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 );