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
90 rows where county = "San Joaquin" and staff_confirmed_cases = 21 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: name, patients_confirmed_cases
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40188 | 40188 | 2021-02-05 | Brookdale Tracy | San Joaquin | 21 | 37 | 0 | 1 | 77 | <11 | |||
40192 | 40192 | 2021-02-05 | Commons On Thornton, The | San Joaquin | 21 | 23 | 0 | 1 | 77 | <11 | |||
41202 | 41202 | 2021-02-04 | Brookdale Tracy | San Joaquin | 21 | 37 | 0 | 1 | 77 | <11 | |||
41206 | 41206 | 2021-02-04 | Commons On Thornton, The | San Joaquin | 21 | 23 | 0 | 1 | 77 | <11 | |||
42213 | 42213 | 2021-02-03 | Brookdale Tracy | San Joaquin | 21 | 37 | 0 | 1 | 77 | <11 | |||
42217 | 42217 | 2021-02-03 | Commons On Thornton, The | San Joaquin | 21 | 23 | 0 | 1 | 77 | <11 | |||
43221 | 43221 | 2021-02-02 | Brookdale Tracy | San Joaquin | 21 | 36 | 0 | 1 | 77 | <11 | |||
43225 | 43225 | 2021-02-02 | Commons On Thornton, The | San Joaquin | 21 | 23 | 0 | 1 | 77 | <11 | |||
44227 | 44227 | 2021-02-01 | Brookdale Tracy | San Joaquin | 21 | 36 | 0 | 1 | 77 | <11 | |||
44231 | 44231 | 2021-02-01 | Commons On Thornton, The | San Joaquin | 21 | 23 | 0 | 1 | 77 | <11 | |||
45229 | 45229 | 2021-01-29 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
45233 | 45233 | 2021-01-29 | Commons On Thornton, The | San Joaquin | 21 | 23 | 0 | 1 | 77 | <11 | |||
46224 | 46224 | 2021-01-28 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
46228 | 46228 | 2021-01-28 | Commons On Thornton, The | San Joaquin | 21 | 23 | 0 | 1 | 77 | <11 | |||
47222 | 47222 | 2021-01-27 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
47225 | 47225 | 2021-01-27 | Commons On Thornton, The | San Joaquin | 21 | 23 | 0 | 1 | 77 | <11 | |||
48176 | 48176 | 2021-01-26 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
48178 | 48178 | 2021-01-26 | Commons On Thornton, The | San Joaquin | 21 | 22 | 0 | 1 | 77 | <11 | |||
49158 | 49158 | 2021-01-25 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
49161 | 49161 | 2021-01-25 | Commons On Thornton, The | San Joaquin | 21 | 22 | 0 | 1 | 77 | <11 | |||
50096 | 50096 | 2021-01-21 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
50098 | 50098 | 2021-01-21 | Commons On Thornton, The | San Joaquin | 21 | 22 | 0 | 1 | 77 | <11 | |||
51053 | 51053 | 2021-01-20 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
51056 | 51056 | 2021-01-20 | Commons On Thornton, The | San Joaquin | 21 | 22 | 0 | 1 | 77 | <11 | |||
52012 | 52012 | 2021-01-19 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
52015 | 52015 | 2021-01-19 | Commons On Thornton, The | San Joaquin | 21 | 22 | 0 | 1 | 77 | <11 | |||
52948 | 52948 | 2021-01-15 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
52951 | 52951 | 2021-01-15 | Commons On Thornton, The | San Joaquin | 21 | 22 | 0 | 1 | 77 | <11 | |||
53862 | 53862 | 2021-01-14 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
53865 | 53865 | 2021-01-14 | Commons On Thornton, The | San Joaquin | 21 | 22 | 0 | 1 | 77 | <11 | |||
54784 | 54784 | 2021-01-13 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
54787 | 54787 | 2021-01-13 | Commons On Thornton, The | San Joaquin | 21 | 22 | 0 | 1 | 77 | <11 | |||
55697 | 55697 | 2021-01-12 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
55700 | 55700 | 2021-01-12 | Commons On Thornton, The | San Joaquin | 21 | 21 | 0 | 1 | 77 | <11 | |||
56605 | 56605 | 2021-01-11 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
56607 | 56607 | 2021-01-11 | Commons On Thornton, The | San Joaquin | 21 | 21 | 0 | 1 | 77 | <11 | |||
57494 | 57494 | 2021-01-08 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
57496 | 57496 | 2021-01-08 | Commons On Thornton, The | San Joaquin | 21 | 21 | 0 | 1 | 77 | <11 | |||
58368 | 58368 | 2021-01-07 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
58370 | 58370 | 2021-01-07 | Commons On Thornton, The | San Joaquin | 21 | 21 | 0 | 1 | 77 | <11 | |||
59233 | 59233 | 2021-01-06 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
59235 | 59235 | 2021-01-06 | Commons On Thornton, The | San Joaquin | 21 | 21 | 0 | 1 | 77 | <11 | |||
60085 | 60085 | 2021-01-05 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
60087 | 60087 | 2021-01-05 | Commons On Thornton, The | San Joaquin | 21 | 21 | 0 | 1 | 77 | <11 | |||
60924 | 60924 | 2021-01-04 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
60926 | 60926 | 2021-01-04 | Commons On Thornton, The | San Joaquin | 21 | 21 | 0 | 1 | 77 | <11 | |||
61731 | 61731 | 2020-12-31 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
61733 | 61733 | 2020-12-31 | Commons On Thornton, The | San Joaquin | 21 | 19 | 0 | 1 | 77 | <11 | |||
62515 | 62515 | 2020-12-30 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
62517 | 62517 | 2020-12-30 | Commons On Thornton, The | San Joaquin | 21 | 19 | 0 | 1 | 77 | <11 | |||
63288 | 63288 | 2020-12-29 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
63290 | 63290 | 2020-12-29 | Commons On Thornton, The | San Joaquin | 21 | 19 | 0 | 1 | 77 | <11 | |||
64051 | 64051 | 2020-12-28 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
64053 | 64053 | 2020-12-28 | Commons On Thornton, The | San Joaquin | 21 | 19 | 0 | 1 | 77 | <11 | |||
64780 | 64780 | 2020-12-24 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
64782 | 64782 | 2020-12-24 | Commons On Thornton, The | San Joaquin | 21 | 19 | 0 | 1 | 77 | <11 | |||
65494 | 65494 | 2020-12-23 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
65496 | 65496 | 2020-12-23 | Commons On Thornton, The | San Joaquin | 21 | 19 | 0 | 1 | 77 | <11 | |||
66196 | 66196 | 2020-12-22 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
66198 | 66198 | 2020-12-22 | Commons On Thornton, The | San Joaquin | 21 | 19 | 0 | 1 | 77 | <11 | |||
66888 | 66888 | 2020-12-21 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
66890 | 66890 | 2020-12-21 | Commons On Thornton, The | San Joaquin | 21 | 19 | 0 | 1 | 77 | <11 | |||
67550 | 67550 | 2020-12-18 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
68199 | 68199 | 2020-12-17 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
68830 | 68830 | 2020-12-16 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
69447 | 69447 | 2020-12-15 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
70055 | 70055 | 2020-12-14 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
70638 | 70638 | 2020-12-11 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
71212 | 71212 | 2020-12-10 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
71776 | 71776 | 2020-12-09 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
72332 | 72332 | 2020-12-08 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
72878 | 72878 | 2020-12-07 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
73406 | 73406 | 2020-12-04 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
73924 | 73924 | 2020-12-03 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
74431 | 74431 | 2020-12-02 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
74932 | 74932 | 2020-12-01 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
75430 | 75430 | 2020-11-30 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
75917 | 75917 | 2020-11-27 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
76391 | 76391 | 2020-11-25 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
76862 | 76862 | 2020-11-24 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
77318 | 77318 | 2020-11-23 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
77768 | 77768 | 2020-11-20 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
78216 | 78216 | 2020-11-19 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
78660 | 78660 | 2020-11-18 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
79100 | 79100 | 2020-11-17 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
79537 | 79537 | 2020-11-16 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
79963 | 79963 | 2020-11-13 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
80384 | 80384 | 2020-11-12 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
80803 | 80803 | 2020-11-11 | Brookdale Tracy | San Joaquin | 21 | 30 | 0 | 1 | 77 | <11 | |||
81221 | 81221 | 2020-11-10 | Brookdale Tracy | San Joaquin | 21 | 30 | 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 );