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
2,790 rows where county = "San Joaquin" sorted by staff_confirmed_cases descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: patients_deaths, staff_confirmed_cases_note, staff_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
810 | 810 | 2021-06-27 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
1813 | 1813 | 2021-05-11 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
2857 | 2857 | 2021-04-27 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
3906 | 3906 | 2021-04-21 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
4953 | 4953 | 2021-04-06 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
6000 | 6000 | 2021-03-30 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
7047 | 7047 | 2021-03-29 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
8094 | 8094 | 2021-03-25 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
9141 | 9141 | 2021-03-24 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
10188 | 10188 | 2021-03-23 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
11234 | 11234 | 2021-03-22 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
12280 | 12280 | 2021-03-19 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
13325 | 13325 | 2021-03-18 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
14369 | 14369 | 2021-03-17 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
15413 | 15413 | 2021-03-16 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
16457 | 16457 | 2021-03-15 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
17501 | 17501 | 2021-03-12 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
18544 | 18544 | 2021-03-11 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
19585 | 19585 | 2021-03-10 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
20627 | 20627 | 2021-03-09 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
21623 | 21623 | 2021-03-08 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
22656 | 22656 | 2021-03-04 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
23696 | 23696 | 2021-03-03 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
24735 | 24735 | 2021-03-02 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
25774 | 25774 | 2021-03-01 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
26811 | 26811 | 2021-02-26 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
27848 | 27848 | 2021-02-25 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
28884 | 28884 | 2021-02-24 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
29917 | 29917 | 2021-02-22 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
30951 | 30951 | 2021-02-19 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
31985 | 31985 | 2021-02-18 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
33018 | 33018 | 2021-02-17 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
34049 | 34049 | 2021-02-16 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
35077 | 35077 | 2021-02-12 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
36104 | 36104 | 2021-02-11 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
37129 | 37129 | 2021-02-10 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
38154 | 38154 | 2021-02-09 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
39178 | 39178 | 2021-02-08 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
40197 | 40197 | 2021-02-05 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
41211 | 41211 | 2021-02-04 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
42222 | 42222 | 2021-02-03 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
43230 | 43230 | 2021-02-02 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
44236 | 44236 | 2021-02-01 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
45238 | 45238 | 2021-01-29 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
46233 | 46233 | 2021-01-28 | O'connor Woods Assisted Living | San Joaquin | 29 | 13 | 0 | 1 | 77 | <11 | |||
47230 | 47230 | 2021-01-27 | O'connor Woods Assisted Living | San Joaquin | 29 | 13 | 0 | 1 | 77 | <11 | |||
48182 | 48182 | 2021-01-26 | O'connor Woods Assisted Living | San Joaquin | 29 | 13 | 0 | 1 | 77 | <11 | |||
49166 | 49166 | 2021-01-25 | O'connor Woods Assisted Living | San Joaquin | 28 | 13 | 0 | 1 | 77 | <11 | |||
50102 | 50102 | 2021-01-21 | O'connor Woods Assisted Living | San Joaquin | 28 | 12 | 0 | 1 | 77 | <11 | |||
51061 | 51061 | 2021-01-20 | O'connor Woods Assisted Living | San Joaquin | 28 | 12 | 0 | 1 | 77 | <11 | |||
52020 | 52020 | 2021-01-19 | O'connor Woods Assisted Living | San Joaquin | 28 | 12 | 0 | 1 | 77 | <11 | |||
52956 | 52956 | 2021-01-15 | O'connor Woods Assisted Living | San Joaquin | 28 | 1 | 0 | 1 | 77 | <11 | <11 | ||
53870 | 53870 | 2021-01-14 | O'connor Woods Assisted Living | San Joaquin | 28 | 1 | 0 | 1 | 77 | <11 | <11 | ||
54792 | 54792 | 2021-01-13 | O'connor Woods Assisted Living | San Joaquin | 28 | 1 | 0 | 1 | 77 | <11 | <11 | ||
55705 | 55705 | 2021-01-12 | O'connor Woods Assisted Living | San Joaquin | 28 | 1 | 0 | 1 | 77 | <11 | <11 | ||
56612 | 56612 | 2021-01-11 | O'connor Woods Assisted Living | San Joaquin | 28 | 1 | 0 | 1 | 77 | <11 | <11 | ||
57501 | 57501 | 2021-01-08 | O'connor Woods Assisted Living | San Joaquin | 28 | 1 | 0 | 1 | 77 | <11 | <11 | ||
58375 | 58375 | 2021-01-07 | O'connor Woods Assisted Living | San Joaquin | 28 | 1 | 0 | 1 | 77 | <11 | <11 | ||
59240 | 59240 | 2021-01-06 | O'connor Woods Assisted Living | San Joaquin | 28 | 1 | 0 | 1 | 77 | <11 | <11 | ||
60092 | 60092 | 2021-01-05 | O'connor Woods Assisted Living | San Joaquin | 25 | 1 | 0 | 1 | 77 | <11 | <11 | ||
60931 | 60931 | 2021-01-04 | O'connor Woods Assisted Living | San Joaquin | 25 | 1 | 0 | 1 | 77 | <11 | <11 | ||
804 | 804 | 2021-06-27 | Commons On Thornton, The | San Joaquin | 24 | 24 | 0 | 1 | 77 | <11 | |||
1808 | 1808 | 2021-05-11 | Commons On Thornton, The | San Joaquin | 24 | 24 | 0 | 1 | 77 | <11 | |||
2851 | 2851 | 2021-04-27 | Commons On Thornton, The | San Joaquin | 24 | 24 | 0 | 1 | 77 | <11 | |||
3900 | 3900 | 2021-04-21 | Commons On Thornton, The | San Joaquin | 24 | 24 | 0 | 1 | 77 | <11 | |||
4947 | 4947 | 2021-04-06 | Commons On Thornton, The | San Joaquin | 24 | 24 | 0 | 1 | 77 | <11 | |||
5994 | 5994 | 2021-03-30 | Commons On Thornton, The | San Joaquin | 24 | 24 | 0 | 1 | 77 | <11 | |||
7041 | 7041 | 2021-03-29 | Commons On Thornton, The | San Joaquin | 24 | 24 | 0 | 1 | 77 | <11 | |||
8088 | 8088 | 2021-03-25 | Commons On Thornton, The | San Joaquin | 24 | 24 | 0 | 1 | 77 | <11 | |||
9135 | 9135 | 2021-03-24 | Commons On Thornton, The | San Joaquin | 24 | 24 | 0 | 1 | 77 | <11 | |||
10182 | 10182 | 2021-03-23 | Commons On Thornton, The | San Joaquin | 24 | 24 | 0 | 1 | 77 | <11 | |||
11228 | 11228 | 2021-03-22 | Commons On Thornton, The | San Joaquin | 24 | 24 | 0 | 1 | 77 | <11 | |||
12274 | 12274 | 2021-03-19 | Commons On Thornton, The | San Joaquin | 24 | 24 | 0 | 1 | 77 | <11 | |||
13319 | 13319 | 2021-03-18 | Commons On Thornton, The | San Joaquin | 24 | 24 | 0 | 1 | 77 | <11 | |||
14363 | 14363 | 2021-03-17 | Commons On Thornton, The | San Joaquin | 24 | 24 | 0 | 1 | 77 | <11 | |||
15407 | 15407 | 2021-03-16 | Commons On Thornton, The | San Joaquin | 24 | 24 | 0 | 1 | 77 | <11 | |||
16451 | 16451 | 2021-03-15 | Commons On Thornton, The | San Joaquin | 24 | 24 | 0 | 1 | 77 | <11 | |||
17495 | 17495 | 2021-03-12 | Commons On Thornton, The | San Joaquin | 24 | 24 | 0 | 1 | 77 | <11 | |||
18538 | 18538 | 2021-03-11 | Commons On Thornton, The | San Joaquin | 24 | 24 | 0 | 1 | 77 | <11 | |||
19580 | 19580 | 2021-03-10 | Commons On Thornton, The | San Joaquin | 24 | 24 | 0 | 1 | 77 | <11 | |||
20622 | 20622 | 2021-03-09 | Commons On Thornton, The | San Joaquin | 24 | 24 | 0 | 1 | 77 | <11 | |||
21619 | 21619 | 2021-03-08 | Commons On Thornton, The | San Joaquin | 24 | 24 | 0 | 1 | 77 | <11 | |||
22651 | 22651 | 2021-03-04 | Commons On Thornton, The | San Joaquin | 24 | 24 | 0 | 1 | 77 | <11 | |||
23691 | 23691 | 2021-03-03 | Commons On Thornton, The | San Joaquin | 24 | 24 | 0 | 1 | 77 | <11 | |||
24730 | 24730 | 2021-03-02 | Commons On Thornton, The | San Joaquin | 24 | 24 | 0 | 1 | 77 | <11 | |||
25769 | 25769 | 2021-03-01 | Commons On Thornton, The | San Joaquin | 24 | 24 | 0 | 1 | 77 | <11 | |||
26806 | 26806 | 2021-02-26 | Commons On Thornton, The | San Joaquin | 24 | 24 | 0 | 1 | 77 | <11 | |||
27843 | 27843 | 2021-02-25 | Commons On Thornton, The | San Joaquin | 24 | 24 | 0 | 1 | 77 | <11 | |||
28879 | 28879 | 2021-02-24 | Commons On Thornton, The | San Joaquin | 24 | 24 | 0 | 1 | 77 | <11 | |||
29912 | 29912 | 2021-02-22 | Commons On Thornton, The | San Joaquin | 24 | 23 | 0 | 1 | 77 | <11 | |||
30946 | 30946 | 2021-02-19 | Commons On Thornton, The | San Joaquin | 24 | 23 | 0 | 1 | 77 | <11 | |||
31980 | 31980 | 2021-02-18 | Commons On Thornton, The | San Joaquin | 24 | 23 | 0 | 1 | 77 | <11 | |||
33013 | 33013 | 2021-02-17 | Commons On Thornton, The | San Joaquin | 24 | 23 | 0 | 1 | 77 | <11 | |||
34044 | 34044 | 2021-02-16 | Commons On Thornton, The | San Joaquin | 24 | 23 | 0 | 1 | 77 | <11 | |||
61738 | 61738 | 2020-12-31 | O'connor Woods Assisted Living | San Joaquin | 24 | 1 | 0 | 1 | 77 | <11 | <11 | ||
62522 | 62522 | 2020-12-30 | O'connor Woods Assisted Living | San Joaquin | 24 | 1 | 0 | 1 | 77 | <11 | <11 | ||
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 |
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 );