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

12 rows where county = "San Joaquin" and staff_confirmed_cases = 28 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
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

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