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

20 rows where county = "Ventura" and staff_confirmed_cases = 20 sorted by date descending

✎ View and edit SQL

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

Suggested facets: name, patients_deaths, patients_deaths_note, 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
45435 45435 2021-01-29 Almavia Of Camarillo Ventura 20 15 0 1 111       <11
46430 46430 2021-01-28 Almavia Of Camarillo Ventura 20 15 0 1 111       <11
47427 47427 2021-01-27 Almavia Of Camarillo Ventura 20 15 0 1 111       <11
48370 48370 2021-01-26 Almavia Of Camarillo Ventura 20 15 0 1 111       <11
49360 49360 2021-01-25 Almavia Of Camarillo Ventura 20 15 0 1 111       <11
51251 51251 2021-01-20 Belmont Village Thousand Oaks Ventura 20 18 0 1 111       <11
52208 52208 2021-01-19 Belmont Village Thousand Oaks Ventura 20 18 0 1 111       <11
53153 53153 2021-01-15 Sunrise At Wood Ranch Ventura 20 1 0 1 111   <11   <11
54066 54066 2021-01-14 Sunrise At Wood Ranch Ventura 20 1 0 1 111   <11   <11
54986 54986 2021-01-13 Sunrise At Wood Ranch Ventura 20 1 0 1 111   <11   <11
55898 55898 2021-01-12 Sunrise At Wood Ranch Ventura 20 1 0 1 111   <11   <11
56802 56802 2021-01-11 Sunrise At Wood Ranch Ventura 20 1 0 1 111   <11   <11
57680 57680 2021-01-08 Royal Gardens Of Camarillo Ventura 20 48 0 1 111       <11
57683 57683 2021-01-08 Sunrise At Wood Ranch Ventura 20 1 0 1 111   <11   <11
61889 61889 2020-12-31 Reserve At Thousand Oaks, The Ventura 20 1 0 0 111   <11    
61892 61892 2020-12-31 University Village Thousand Oaks Ventura 20 1 0 1 111   <11   <11
62668 62668 2020-12-30 Reserve At Thousand Oaks, The Ventura 20 1 0 0 111   <11    
62671 62671 2020-12-30 University Village Thousand Oaks Ventura 20 1 0 1 111   <11   <11
63439 63439 2020-12-29 Reserve At Thousand Oaks, The Ventura 20 1 0 0 111   <11    
64201 64201 2020-12-28 Reserve At Thousand Oaks, The Ventura 20 1 0 0 111   <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
);