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

48 rows where county = "Contra Costa" and staff_confirmed_cases = 13 sorted by date descending

✎ View and edit SQL

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

Suggested facets: 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
62 62 2021-06-27 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
75 75 2021-06-27 TreVista Concord Contra Costa 13 22 0 1 13       <11
1115 1115 2021-05-11 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
2113 2113 2021-04-27 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
3162 3162 2021-04-21 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
4211 4211 2021-04-06 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
5258 5258 2021-03-30 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
6305 6305 2021-03-29 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
7352 7352 2021-03-25 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
8399 8399 2021-03-24 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
9446 9446 2021-03-23 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
10493 10493 2021-03-22 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
11539 11539 2021-03-19 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
12584 12584 2021-03-18 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
13629 13629 2021-03-17 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
14673 14673 2021-03-16 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
15717 15717 2021-03-15 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
16761 16761 2021-03-12 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
17805 17805 2021-03-11 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
18847 18847 2021-03-10 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
19889 19889 2021-03-09 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
20931 20931 2021-03-08 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
21920 21920 2021-03-04 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
22960 22960 2021-03-03 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
24000 24000 2021-03-02 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
25039 25039 2021-03-01 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
26078 26078 2021-02-26 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
27115 27115 2021-02-25 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
28152 28152 2021-02-24 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
29187 29187 2021-02-22 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
30221 30221 2021-02-19 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
31255 31255 2021-02-18 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
32288 32288 2021-02-17 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
33320 33320 2021-02-16 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
34349 34349 2021-02-12 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
35376 35376 2021-02-11 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
36402 36402 2021-02-10 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
37427 37427 2021-02-09 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
38452 38452 2021-02-08 Commons At Dallas Ranch, The Contra Costa 13 16 0 1 13       <11
39475 39475 2021-02-05 Commons At Dallas Ranch, The Contra Costa 13 15 0 1 13       <11
40492 40492 2021-02-04 Commons At Dallas Ranch, The Contra Costa 13 15 0 1 13       <11
41505 41505 2021-02-03 Commons At Dallas Ranch, The Contra Costa 13 15 0 1 13       <11
42515 42515 2021-02-02 Commons At Dallas Ranch, The Contra Costa 13 15 0 1 13       <11
43522 43522 2021-02-01 Commons At Dallas Ranch, The Contra Costa 13 15 0 1 13       <11
104612 104612 2020-08-10 Byron Park Contra Costa 13 13 0 1 13       <11
104613 104613 2020-08-10 Chateau At Poets Corner Contra Costa 13 18 0 1 13       <11
104870 104870 2020-08-09 Byron Park Contra Costa 13 13 0 1 13       <11
104871 104871 2020-08-09 Chateau At Poets Corner Contra Costa 13 18 0 1 13       <11

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