la_times_cdph_adult_and_senior_care_facilities

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

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

41 rows where county = "Contra Costa" and staff_confirmed_cases = 28 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: patients_confirmed_cases, patients_deaths_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
3175 3175 2021-04-21 Trevista Antioch Contra Costa 28 45 0 1 13       <11
4224 4224 2021-04-06 Trevista Antioch Contra Costa 28 45 0 1 13       <11
5271 5271 2021-03-30 Trevista Antioch Contra Costa 28 45 0 1 13       <11
6318 6318 2021-03-29 Trevista Antioch Contra Costa 28 45 0 1 13       <11
7365 7365 2021-03-25 Trevista Antioch Contra Costa 28 45 0 1 13       <11
8412 8412 2021-03-24 Trevista Antioch Contra Costa 28 45 0 1 13       <11
9459 9459 2021-03-23 Trevista Antioch Contra Costa 28 45 0 1 13       <11
10506 10506 2021-03-22 Trevista Antioch Contra Costa 28 45 0 1 13       <11
11552 11552 2021-03-19 Trevista Antioch Contra Costa 28 45 0 1 13       <11
12597 12597 2021-03-18 Trevista Antioch Contra Costa 28 45 0 1 13       <11
13642 13642 2021-03-17 Trevista Antioch Contra Costa 28 45 0 1 13       <11
14686 14686 2021-03-16 Trevista Antioch Contra Costa 28 45 0 1 13       <11
15730 15730 2021-03-15 Trevista Antioch Contra Costa 28 45 0 1 13       <11
16774 16774 2021-03-12 Trevista Antioch Contra Costa 28 45 0 1 13       <11
17818 17818 2021-03-11 Trevista Antioch Contra Costa 28 45 0 1 13       <11
18860 18860 2021-03-10 Trevista Antioch Contra Costa 28 45 0 1 13       <11
19902 19902 2021-03-09 Trevista Antioch Contra Costa 28 45 0 1 13       <11
20944 20944 2021-03-08 Trevista Antioch Contra Costa 28 45 0 1 13       <11
21933 21933 2021-03-04 Trevista Antioch Contra Costa 28 45 0 1 13       <11
22973 22973 2021-03-03 Trevista Antioch Contra Costa 28 45 0 1 13       <11
24013 24013 2021-03-02 Trevista Antioch Contra Costa 28 45 0 1 13       <11
25052 25052 2021-03-01 Trevista Antioch Contra Costa 28 45 0 1 13       <11
26091 26091 2021-02-26 Trevista Antioch Contra Costa 28 45 0 1 13       <11
27128 27128 2021-02-25 Trevista Antioch Contra Costa 28 45 0 1 13       <11
28165 28165 2021-02-24 Trevista Antioch Contra Costa 28 45 0 1 13       <11
29200 29200 2021-02-22 Trevista Antioch Contra Costa 28 45 0 1 13       <11
30234 30234 2021-02-19 Trevista Antioch Contra Costa 28 45 0 1 13       <11
31268 31268 2021-02-18 Trevista Antioch Contra Costa 28 45 0 1 13       <11
32301 32301 2021-02-17 Trevista Antioch Contra Costa 28 45 0 1 13       <11
33332 33332 2021-02-16 Trevista Antioch Contra Costa 28 45 0 1 13       <11
34361 34361 2021-02-12 Trevista Antioch Contra Costa 28 44 0 1 13       <11
35388 35388 2021-02-11 Trevista Antioch Contra Costa 28 44 0 1 13       <11
36414 36414 2021-02-10 Trevista Antioch Contra Costa 28 44 0 1 13       <11
37439 37439 2021-02-09 Trevista Antioch Contra Costa 28 44 0 1 13       <11
38464 38464 2021-02-08 Trevista Antioch Contra Costa 28 44 0 1 13       <11
67074 67074 2020-12-18 Sunrise Assisted Living Of Danville Contra Costa 28 20 0 1 13       <11
67729 67729 2020-12-17 Sunrise Assisted Living Of Danville Contra Costa 28 20 0 1 13       <11
116355 116355 2020-05-04 Chateau III Contra Costa 28 39     13        
116392 116392 2020-05-02 Chateau III Contra Costa 28 39     13        
116429 116429 2020-05-01 Chateau III Contra Costa 28 39     13        
116464 116464 2020-04-30 Chateau III Contra Costa 28 39     13        

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);