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
36 rows where county = "San Joaquin" and staff_confirmed_cases = 19 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: name, patients_confirmed_cases_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
64787 | 64787 | 2020-12-24 | O'connor Woods Assisted Living | San Joaquin | 19 | 1 | 0 | 1 | 77 | <11 | <11 | ||
86091 | 86091 | 2020-10-23 | Brookdale Tracy | San Joaquin | 19 | 29 | 0 | 1 | 77 | <11 | |||
86486 | 86486 | 2020-10-22 | Brookdale Tracy | San Joaquin | 19 | 29 | 0 | 1 | 77 | <11 | |||
86881 | 86881 | 2020-10-21 | Brookdale Tracy | San Joaquin | 19 | 29 | 0 | 1 | 77 | <11 | |||
87274 | 87274 | 2020-10-20 | Brookdale Tracy | San Joaquin | 19 | 29 | 0 | 1 | 77 | <11 | |||
87666 | 87666 | 2020-10-19 | Brookdale Tracy | San Joaquin | 19 | 29 | 0 | 1 | 77 | <11 | |||
88057 | 88057 | 2020-10-16 | Brookdale Tracy | San Joaquin | 19 | 29 | 0 | 1 | 77 | <11 | |||
88447 | 88447 | 2020-10-15 | Brookdale Tracy | San Joaquin | 19 | 29 | 0 | 1 | 77 | <11 | |||
88835 | 88835 | 2020-10-14 | Brookdale Tracy | San Joaquin | 19 | 29 | 0 | 1 | 77 | <11 | |||
89222 | 89222 | 2020-10-13 | Brookdale Tracy | San Joaquin | 19 | 29 | 0 | 1 | 77 | <11 | |||
89606 | 89606 | 2020-10-12 | Brookdale Tracy | San Joaquin | 19 | 29 | 0 | 1 | 77 | <11 | |||
89988 | 89988 | 2020-10-09 | Brookdale Tracy | San Joaquin | 19 | 29 | 0 | 1 | 77 | <11 | |||
90368 | 90368 | 2020-10-08 | Brookdale Tracy | San Joaquin | 19 | 29 | 0 | 1 | 77 | <11 | |||
90746 | 90746 | 2020-10-07 | Brookdale Tracy | San Joaquin | 19 | 29 | 0 | 1 | 77 | <11 | |||
91123 | 91123 | 2020-10-06 | Brookdale Tracy | San Joaquin | 19 | 29 | 0 | 1 | 77 | <11 | |||
91497 | 91497 | 2020-10-05 | Brookdale Tracy | San Joaquin | 19 | 29 | 0 | 1 | 77 | <11 | |||
91865 | 91865 | 2020-10-02 | Brookdale Tracy | San Joaquin | 19 | 29 | 0 | 1 | 77 | <11 | |||
92231 | 92231 | 2020-10-01 | Brookdale Tracy | San Joaquin | 19 | 29 | 0 | 1 | 77 | <11 | |||
92597 | 92597 | 2020-09-30 | Brookdale Tracy | San Joaquin | 19 | 29 | 0 | 1 | 77 | <11 | |||
92956 | 92956 | 2020-09-29 | Brookdale Tracy | San Joaquin | 19 | 29 | 0 | 1 | 77 | <11 | |||
93312 | 93312 | 2020-09-28 | Brookdale Tracy | San Joaquin | 19 | 29 | 0 | 1 | 77 | <11 | |||
93664 | 93664 | 2020-09-25 | Brookdale Tracy | San Joaquin | 19 | 29 | 0 | 1 | 77 | <11 | |||
94021 | 94021 | 2020-09-24 | Brookdale Tracy | San Joaquin | 19 | 29 | 0 | 1 | 77 | <11 | |||
94375 | 94375 | 2020-09-23 | Brookdale Tracy | San Joaquin | 19 | 29 | 0 | 1 | 77 | <11 | |||
94722 | 94722 | 2020-09-22 | Brookdale Tracy | San Joaquin | 19 | 29 | 0 | 1 | 77 | <11 | |||
95072 | 95072 | 2020-09-21 | Brookdale Tracy | San Joaquin | 19 | 29 | 0 | 1 | 77 | <11 | |||
95419 | 95419 | 2020-09-18 | Brookdale Tracy | San Joaquin | 19 | 29 | 0 | 1 | 77 | <11 | |||
95763 | 95763 | 2020-09-17 | Brookdale Tracy | San Joaquin | 19 | 29 | 0 | 1 | 77 | <11 | |||
96106 | 96106 | 2020-09-16 | Brookdale Tracy | San Joaquin | 19 | 29 | 0 | 1 | 77 | <11 | |||
97440 | 97440 | 2020-09-10 | Brookdale Tracy | San Joaquin | 19 | 28 | 0 | 1 | 77 | <11 | |||
97768 | 97768 | 2020-09-09 | Brookdale Tracy | San Joaquin | 19 | 28 | 0 | 1 | 77 | <11 | |||
98092 | 98092 | 2020-09-08 | Brookdale Tracy | San Joaquin | 19 | 28 | 0 | 1 | 77 | <11 | |||
98416 | 98416 | 2020-09-07 | Brookdale Tracy | San Joaquin | 19 | 28 | 0 | 1 | 77 | <11 | |||
98735 | 98735 | 2020-09-04 | Brookdale Tracy | San Joaquin | 19 | 28 | 0 | 1 | 77 | <11 | |||
99051 | 99051 | 2020-09-03 | Brookdale Tracy | San Joaquin | 19 | 28 | 0 | 1 | 77 | <11 | |||
99364 | 99364 | 2020-09-02 | Brookdale Tracy | San Joaquin | 19 | 28 | 0 | 1 | 77 | <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 );