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
82 rows where patients_deaths = 12 and staff_confirmed_cases = 23 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: name, fips, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
691 | 691 | 2021-06-27 | Atria Rancho Penasquitos | San Diego | 23 | 60 | 0 | 12 | 73 | ||||
773 | 773 | 2021-06-27 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
1701 | 1701 | 2021-05-11 | Atria Rancho Penasquitos | San Diego | 23 | 60 | 0 | 12 | 73 | ||||
1780 | 1780 | 2021-05-11 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
2739 | 2739 | 2021-04-27 | Atria Rancho Penasquitos | San Diego | 23 | 60 | 0 | 12 | 73 | ||||
2820 | 2820 | 2021-04-27 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
3788 | 3788 | 2021-04-21 | Atria Rancho Penasquitos | San Diego | 23 | 60 | 0 | 12 | 73 | ||||
3869 | 3869 | 2021-04-21 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
4835 | 4835 | 2021-04-06 | Atria Rancho Penasquitos | San Diego | 23 | 60 | 0 | 12 | 73 | ||||
4916 | 4916 | 2021-04-06 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
5882 | 5882 | 2021-03-30 | Atria Rancho Penasquitos | San Diego | 23 | 60 | 0 | 12 | 73 | ||||
5963 | 5963 | 2021-03-30 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
6929 | 6929 | 2021-03-29 | Atria Rancho Penasquitos | San Diego | 23 | 60 | 0 | 12 | 73 | ||||
7010 | 7010 | 2021-03-29 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
7976 | 7976 | 2021-03-25 | Atria Rancho Penasquitos | San Diego | 23 | 60 | 0 | 12 | 73 | ||||
8057 | 8057 | 2021-03-25 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
9023 | 9023 | 2021-03-24 | Atria Rancho Penasquitos | San Diego | 23 | 60 | 0 | 12 | 73 | ||||
9104 | 9104 | 2021-03-24 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
10070 | 10070 | 2021-03-23 | Atria Rancho Penasquitos | San Diego | 23 | 60 | 0 | 12 | 73 | ||||
10151 | 10151 | 2021-03-23 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
11116 | 11116 | 2021-03-22 | Atria Rancho Penasquitos | San Diego | 23 | 60 | 0 | 12 | 73 | ||||
11197 | 11197 | 2021-03-22 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
12162 | 12162 | 2021-03-19 | Atria Rancho Penasquitos | San Diego | 23 | 60 | 0 | 12 | 73 | ||||
12243 | 12243 | 2021-03-19 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
13207 | 13207 | 2021-03-18 | Atria Rancho Penasquitos | San Diego | 23 | 60 | 0 | 12 | 73 | ||||
13288 | 13288 | 2021-03-18 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
14251 | 14251 | 2021-03-17 | Atria Rancho Penasquitos | San Diego | 23 | 60 | 0 | 12 | 73 | ||||
14332 | 14332 | 2021-03-17 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
15295 | 15295 | 2021-03-16 | Atria Rancho Penasquitos | San Diego | 23 | 60 | 0 | 12 | 73 | ||||
15376 | 15376 | 2021-03-16 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
16339 | 16339 | 2021-03-15 | Atria Rancho Penasquitos | San Diego | 23 | 60 | 0 | 12 | 73 | ||||
16420 | 16420 | 2021-03-15 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
17383 | 17383 | 2021-03-12 | Atria Rancho Penasquitos | San Diego | 23 | 60 | 0 | 12 | 73 | ||||
17464 | 17464 | 2021-03-12 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
18426 | 18426 | 2021-03-11 | Atria Rancho Penasquitos | San Diego | 23 | 60 | 0 | 12 | 73 | ||||
18507 | 18507 | 2021-03-11 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
19468 | 19468 | 2021-03-10 | Atria Rancho Penasquitos | San Diego | 23 | 60 | 0 | 12 | 73 | ||||
19549 | 19549 | 2021-03-10 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
20510 | 20510 | 2021-03-09 | Atria Rancho Penasquitos | San Diego | 23 | 60 | 0 | 12 | 73 | ||||
20591 | 20591 | 2021-03-09 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
21512 | 21512 | 2021-03-08 | Atria Rancho Penasquitos | San Diego | 23 | 60 | 0 | 12 | 73 | ||||
21591 | 21591 | 2021-03-08 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
22539 | 22539 | 2021-03-04 | Atria Rancho Penasquitos | San Diego | 23 | 60 | 0 | 12 | 73 | ||||
22620 | 22620 | 2021-03-04 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
23579 | 23579 | 2021-03-03 | Atria Rancho Penasquitos | San Diego | 23 | 60 | 0 | 12 | 73 | ||||
23660 | 23660 | 2021-03-03 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
24619 | 24619 | 2021-03-02 | Atria Rancho Penasquitos | San Diego | 23 | 60 | 0 | 12 | 73 | ||||
24700 | 24700 | 2021-03-02 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
25658 | 25658 | 2021-03-01 | Atria Rancho Penasquitos | San Diego | 23 | 60 | 0 | 12 | 73 | ||||
25739 | 25739 | 2021-03-01 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
26695 | 26695 | 2021-02-26 | Atria Rancho Penasquitos | San Diego | 23 | 60 | 0 | 12 | 73 | ||||
26776 | 26776 | 2021-02-26 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
27732 | 27732 | 2021-02-25 | Atria Rancho Penasquitos | San Diego | 23 | 60 | 0 | 12 | 73 | ||||
27813 | 27813 | 2021-02-25 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
28768 | 28768 | 2021-02-24 | Atria Rancho Penasquitos | San Diego | 23 | 60 | 0 | 12 | 73 | ||||
28849 | 28849 | 2021-02-24 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
29802 | 29802 | 2021-02-22 | Atria Rancho Penasquitos | San Diego | 23 | 59 | 0 | 12 | 73 | ||||
29882 | 29882 | 2021-02-22 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
30836 | 30836 | 2021-02-19 | Atria Rancho Penasquitos | San Diego | 23 | 59 | 0 | 12 | 73 | ||||
30916 | 30916 | 2021-02-19 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
31870 | 31870 | 2021-02-18 | Atria Rancho Penasquitos | San Diego | 23 | 59 | 0 | 12 | 73 | ||||
31950 | 31950 | 2021-02-18 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
32903 | 32903 | 2021-02-17 | Atria Rancho Penasquitos | San Diego | 23 | 59 | 0 | 12 | 73 | ||||
32983 | 32983 | 2021-02-17 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
33934 | 33934 | 2021-02-16 | Atria Rancho Penasquitos | San Diego | 23 | 59 | 0 | 12 | 73 | ||||
34014 | 34014 | 2021-02-16 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
35042 | 35042 | 2021-02-12 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
36069 | 36069 | 2021-02-11 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
37094 | 37094 | 2021-02-10 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
38119 | 38119 | 2021-02-09 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
39143 | 39143 | 2021-02-08 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
40163 | 40163 | 2021-02-05 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
41177 | 41177 | 2021-02-04 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
42188 | 42188 | 2021-02-03 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
43196 | 43196 | 2021-02-02 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
44202 | 44202 | 2021-02-01 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
45205 | 45205 | 2021-01-29 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
114753 | 114753 | 2020-05-28 | Pacifica Senior Living Northridge | Los Angeles | 23 | 38 | 0 | 12 | 37 | ||||
114837 | 114837 | 2020-05-27 | Pacifica Senior Living Northridge | Los Angeles | 23 | 38 | 0 | 12 | 37 | ||||
114920 | 114920 | 2020-05-26 | Pacifica Senior Living Northridge | Los Angeles | 23 | 38 | 0 | 12 | 37 | ||||
115003 | 115003 | 2020-05-25 | Pacifica Senior Living Northridge | Los Angeles | 23 | 38 | 0 | 12 | 37 | ||||
115085 | 115085 | 2020-05-24 | Pacifica Senior Living Northridge | Los Angeles | 23 | 37 | 0 | 12 | 37 |
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 );