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

63 rows where county = "Monterey" and staff_confirmed_cases = 13 sorted by date descending

✎ View and edit SQL

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

Suggested facets: name, 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
392 392 2021-06-27 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
1415 1415 2021-05-11 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
2442 2442 2021-04-27 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
3491 3491 2021-04-21 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
4539 4539 2021-04-06 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
5586 5586 2021-03-30 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
6633 6633 2021-03-29 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
7680 7680 2021-03-25 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
8727 8727 2021-03-24 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
9774 9774 2021-03-23 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
10820 10820 2021-03-22 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
11866 11866 2021-03-19 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
12911 12911 2021-03-18 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
13956 13956 2021-03-17 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
15000 15000 2021-03-16 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
16044 16044 2021-03-15 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
17088 17088 2021-03-12 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
18131 18131 2021-03-11 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
19173 19173 2021-03-10 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
20215 20215 2021-03-09 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
21230 21230 2021-03-08 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
22245 22245 2021-03-04 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
23285 23285 2021-03-03 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
24325 24325 2021-03-02 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
25364 25364 2021-03-01 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
26401 26401 2021-02-26 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
27438 27438 2021-02-25 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
28474 28474 2021-02-24 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
29508 29508 2021-02-22 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
30542 30542 2021-02-19 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
31576 31576 2021-02-18 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
32609 32609 2021-02-17 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
33640 33640 2021-02-16 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
34669 34669 2021-02-12 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
35696 35696 2021-02-11 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
36721 36721 2021-02-10 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
37747 37747 2021-02-09 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
38771 38771 2021-02-08 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
39793 39793 2021-02-05 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
40809 40809 2021-02-04 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
41821 41821 2021-02-03 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
42830 42830 2021-02-02 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
43837 43837 2021-02-01 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
44841 44841 2021-01-29 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
45837 45837 2021-01-28 Merrill Gardens At Monterey Monterey 13 1 0 0 53   <11    
49729 49729 2021-01-21 Sunrise Villa Salinas Monterey 13 1 0 0 53   <11    
50673 50673 2021-01-20 Sunrise Villa Salinas Monterey 13 1 0 0 53   <11    
51633 51633 2021-01-19 Sunrise Villa Salinas Monterey 13 1 0 0 53   <11    
52582 52582 2021-01-15 Sunrise Villa Salinas Monterey 13 1 0 0 53   <11    
53496 53496 2021-01-14 Sunrise Villa Salinas Monterey 13 1 0 0 53   <11    
65199 65199 2020-12-23 Cottages Of Carmel Monterey 13 19 0 1 53       <11
65907 65907 2020-12-22 Cottages Of Carmel Monterey 13 19 0 1 53       <11
66604 66604 2020-12-21 Cottages Of Carmel Monterey 13 19 0 1 53       <11
67279 67279 2020-12-18 Cottages Of Carmel Monterey 13 19 0 1 53       <11
67930 67930 2020-12-17 Cottages Of Carmel Monterey 13 19 0 1 53       <11
68567 68567 2020-12-16 Cottages Of Carmel Monterey 13 19 0 1 53       <11
69191 69191 2020-12-15 Cottages Of Carmel Monterey 13 19 0 1 53       <11
69800 69800 2020-12-14 Cottages Of Carmel Monterey 13 19 0 1 53       <11
70389 70389 2020-12-11 Cottages Of Carmel Monterey 13 16 0 1 53       <11
70964 70964 2020-12-10 Cottages Of Carmel Monterey 13 16 0 1 53       <11
71534 71534 2020-12-09 Cottages Of Carmel Monterey 13 16 0 1 53       <11
72095 72095 2020-12-08 Cottages Of Carmel Monterey 13 16 0 1 53       <11
72644 72644 2020-12-07 Cottages Of Carmel Monterey 13 16 0 1 53       <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
);