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
45 rows where county = "San Joaquin" and staff_confirmed_cases = 22 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
800 | 800 | 2021-06-27 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
1805 | 1805 | 2021-05-11 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
2847 | 2847 | 2021-04-27 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
3896 | 3896 | 2021-04-21 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
4943 | 4943 | 2021-04-06 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
5990 | 5990 | 2021-03-30 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
7037 | 7037 | 2021-03-29 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
8084 | 8084 | 2021-03-25 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
9131 | 9131 | 2021-03-24 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
10178 | 10178 | 2021-03-23 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
11224 | 11224 | 2021-03-22 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
12270 | 12270 | 2021-03-19 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
13315 | 13315 | 2021-03-18 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
14359 | 14359 | 2021-03-17 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
15403 | 15403 | 2021-03-16 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
16447 | 16447 | 2021-03-15 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
17491 | 17491 | 2021-03-12 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
18534 | 18534 | 2021-03-11 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
19576 | 19576 | 2021-03-10 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
20618 | 20618 | 2021-03-09 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
21616 | 21616 | 2021-03-08 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
22647 | 22647 | 2021-03-04 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
23687 | 23687 | 2021-03-03 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
24726 | 24726 | 2021-03-02 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
25765 | 25765 | 2021-03-01 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
26802 | 26802 | 2021-02-26 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
27839 | 27839 | 2021-02-25 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
28875 | 28875 | 2021-02-24 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
29908 | 29908 | 2021-02-22 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
30942 | 30942 | 2021-02-19 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
31976 | 31976 | 2021-02-18 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
33009 | 33009 | 2021-02-17 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
34040 | 34040 | 2021-02-16 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
35068 | 35068 | 2021-02-12 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
35072 | 35072 | 2021-02-12 | Commons On Thornton, The | San Joaquin | 22 | 23 | 0 | 1 | 77 | <11 | |||
36095 | 36095 | 2021-02-11 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
36099 | 36099 | 2021-02-11 | Commons On Thornton, The | San Joaquin | 22 | 23 | 0 | 1 | 77 | <11 | |||
37120 | 37120 | 2021-02-10 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
37124 | 37124 | 2021-02-10 | Commons On Thornton, The | San Joaquin | 22 | 23 | 0 | 1 | 77 | <11 | |||
38145 | 38145 | 2021-02-09 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
38149 | 38149 | 2021-02-09 | Commons On Thornton, The | San Joaquin | 22 | 23 | 0 | 1 | 77 | <11 | |||
39169 | 39169 | 2021-02-08 | Brookdale Tracy | San Joaquin | 22 | 42 | 0 | 1 | 77 | <11 | |||
39173 | 39173 | 2021-02-08 | Commons On Thornton, The | San Joaquin | 22 | 23 | 0 | 1 | 77 | <11 | |||
63295 | 63295 | 2020-12-29 | O'connor Woods Assisted Living | San Joaquin | 22 | 1 | 0 | 1 | 77 | <11 | <11 | ||
64058 | 64058 | 2020-12-28 | O'connor Woods Assisted Living | San Joaquin | 22 | 1 | 0 | 1 | 77 | <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 );