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

31 rows where county = "Santa Clara" and staff_confirmed_cases = 26 sorted by date descending

✎ View and edit SQL

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
64856 64856 2020-12-24 Vi At Palo Alto Santa Clara 26 18 0 1 85       <11
65567 65567 2020-12-23 Vi At Palo Alto Santa Clara 26 18 0 1 85       <11
66269 66269 2020-12-22 Vi At Palo Alto Santa Clara 26 18 0 1 85       <11
66960 66960 2020-12-21 Vi At Palo Alto Santa Clara 26 18 0 1 85       <11
69502 69502 2020-12-15 Merrill Gardens At Campbell Santa Clara 26 21 0 1 85       <11
70110 70110 2020-12-14 Merrill Gardens At Campbell Santa Clara 26 21 0 1 85       <11
70692 70692 2020-12-11 Merrill Gardens At Campbell Santa Clara 26 21 0 1 85       <11
91905 91905 2020-10-02 Villa Fontana Santa Clara 26 35 0 1 85       <11
92271 92271 2020-10-01 Villa Fontana Santa Clara 26 35 0 1 85       <11
92637 92637 2020-09-30 Villa Fontana Santa Clara 26 35 0 1 85       <11
92996 92996 2020-09-29 Villa Fontana Santa Clara 26 35 0 1 85       <11
93352 93352 2020-09-28 Villa Fontana Santa Clara 26 35 0 1 85       <11
93704 93704 2020-09-25 Villa Fontana Santa Clara 26 35 0 1 85       <11
94061 94061 2020-09-24 Villa Fontana Santa Clara 26 35 0 1 85       <11
94414 94414 2020-09-23 Villa Fontana Santa Clara 26 35 0 1 85       <11
94761 94761 2020-09-22 Villa Fontana Santa Clara 26 35 0 1 85       <11
95110 95110 2020-09-21 Villa Fontana Santa Clara 26 35 0 1 85       <11
95457 95457 2020-09-18 Villa Fontana Santa Clara 26 35 0 1 85       <11
95801 95801 2020-09-17 Villa Fontana Santa Clara 26 35 0 1 85       <11
96144 96144 2020-09-16 Villa Fontana Santa Clara 26 35 0 1 85       <11
96482 96482 2020-09-15 Villa Fontana Santa Clara 26 35 0 1 85       <11
96813 96813 2020-09-14 Villa Fontana Santa Clara 26 35 0 1 85       <11
97145 97145 2020-09-11 Villa Fontana Santa Clara 26 35 0 1 85       <11
97477 97477 2020-09-10 Villa Fontana Santa Clara 26 35 0 1 85       <11
97805 97805 2020-09-09 Villa Fontana Santa Clara 26 35 0 1 85       <11
98128 98128 2020-09-08 Villa Fontana Santa Clara 26 35 0 1 85       <11
98452 98452 2020-09-07 Villa Fontana Santa Clara 26 35 0 1 85       <11
98771 98771 2020-09-04 Villa Fontana Santa Clara 26 35 0 1 85       <11
99087 99087 2020-09-03 Villa Fontana Santa Clara 26 35 0 1 85       <11
99400 99400 2020-09-02 Villa Fontana Santa Clara 26 35 0 1 85       <11
99712 99712 2020-09-01 Villa Fontana Santa Clara 26 35 0 1 85       <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
);