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
138 rows where fips = 47 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: name, patients_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
385 | 385 | 2021-06-27 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
386 | 386 | 2021-06-27 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
1409 | 1409 | 2021-05-11 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
1410 | 1410 | 2021-05-11 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
2434 | 2434 | 2021-04-27 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
2435 | 2435 | 2021-04-27 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
3483 | 3483 | 2021-04-21 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
3484 | 3484 | 2021-04-21 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
4531 | 4531 | 2021-04-06 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
4532 | 4532 | 2021-04-06 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
5578 | 5578 | 2021-03-30 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
5579 | 5579 | 2021-03-30 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
6625 | 6625 | 2021-03-29 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
6626 | 6626 | 2021-03-29 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
7672 | 7672 | 2021-03-25 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
7673 | 7673 | 2021-03-25 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
8719 | 8719 | 2021-03-24 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
8720 | 8720 | 2021-03-24 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
9766 | 9766 | 2021-03-23 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
9767 | 9767 | 2021-03-23 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
10812 | 10812 | 2021-03-22 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
10813 | 10813 | 2021-03-22 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
11858 | 11858 | 2021-03-19 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
11859 | 11859 | 2021-03-19 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
12903 | 12903 | 2021-03-18 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
12904 | 12904 | 2021-03-18 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
13948 | 13948 | 2021-03-17 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
13949 | 13949 | 2021-03-17 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
14992 | 14992 | 2021-03-16 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
14993 | 14993 | 2021-03-16 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
16036 | 16036 | 2021-03-15 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
16037 | 16037 | 2021-03-15 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
17080 | 17080 | 2021-03-12 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
17081 | 17081 | 2021-03-12 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
18123 | 18123 | 2021-03-11 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
18124 | 18124 | 2021-03-11 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
19165 | 19165 | 2021-03-10 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
19166 | 19166 | 2021-03-10 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
20207 | 20207 | 2021-03-09 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
20208 | 20208 | 2021-03-09 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
21223 | 21223 | 2021-03-08 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
21224 | 21224 | 2021-03-08 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
22237 | 22237 | 2021-03-04 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
22238 | 22238 | 2021-03-04 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
23277 | 23277 | 2021-03-03 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
23278 | 23278 | 2021-03-03 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
24317 | 24317 | 2021-03-02 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
24318 | 24318 | 2021-03-02 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
25356 | 25356 | 2021-03-01 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
25357 | 25357 | 2021-03-01 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
26393 | 26393 | 2021-02-26 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
26394 | 26394 | 2021-02-26 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
27430 | 27430 | 2021-02-25 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
27431 | 27431 | 2021-02-25 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
28466 | 28466 | 2021-02-24 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
28467 | 28467 | 2021-02-24 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
29500 | 29500 | 2021-02-22 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
29501 | 29501 | 2021-02-22 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
30534 | 30534 | 2021-02-19 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
30535 | 30535 | 2021-02-19 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
31568 | 31568 | 2021-02-18 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
31569 | 31569 | 2021-02-18 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
32601 | 32601 | 2021-02-17 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
32602 | 32602 | 2021-02-17 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
33632 | 33632 | 2021-02-16 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
33633 | 33633 | 2021-02-16 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
34661 | 34661 | 2021-02-12 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
34662 | 34662 | 2021-02-12 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
35688 | 35688 | 2021-02-11 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
35689 | 35689 | 2021-02-11 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
36713 | 36713 | 2021-02-10 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
36714 | 36714 | 2021-02-10 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
37739 | 37739 | 2021-02-09 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
37740 | 37740 | 2021-02-09 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
38763 | 38763 | 2021-02-08 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
38764 | 38764 | 2021-02-08 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
39785 | 39785 | 2021-02-05 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
39786 | 39786 | 2021-02-05 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
40801 | 40801 | 2021-02-04 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
40802 | 40802 | 2021-02-04 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
41814 | 41814 | 2021-02-03 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
41815 | 41815 | 2021-02-03 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
42823 | 42823 | 2021-02-02 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
42824 | 42824 | 2021-02-02 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
43830 | 43830 | 2021-02-01 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
43831 | 43831 | 2021-02-01 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
44834 | 44834 | 2021-01-29 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
44835 | 44835 | 2021-01-29 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
45830 | 45830 | 2021-01-28 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
45831 | 45831 | 2021-01-28 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
46824 | 46824 | 2021-01-27 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
46825 | 46825 | 2021-01-27 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
47795 | 47795 | 2021-01-26 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
47796 | 47796 | 2021-01-26 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
48761 | 48761 | 2021-01-25 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
48762 | 48762 | 2021-01-25 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
49720 | 49720 | 2021-01-21 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
49721 | 49721 | 2021-01-21 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <11 | <11 | |
50663 | 50663 | 2021-01-20 | New Bethany | Merced | 1 | 1 | 0 | 0 | 47 | <11 | <11 | ||
50664 | 50664 | 2021-01-20 | Pacifica Senior Living Merced | Merced | 1 | 1 | 0 | 1 | 47 | <11 | <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 );