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

257 rows where county = "San Diego" and staff_confirmed_cases = 15 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

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
727 727 2021-06-27 Las Villas Del Norte San Diego 15 58 0 12 73        
768 768 2021-06-27 Sunrise At La Costa San Diego 15 11 0 1 73       <11
1736 1736 2021-05-11 Las Villas Del Norte San Diego 15 58 0 12 73        
1775 1775 2021-05-11 Sunrise At La Costa San Diego 15 11 0 1 73       <11
2775 2775 2021-04-27 Las Villas Del Norte San Diego 15 58 0 12 73        
2815 2815 2021-04-27 Sunrise At La Costa San Diego 15 11 0 1 73       <11
3824 3824 2021-04-21 Las Villas Del Norte San Diego 15 58 0 12 73        
3864 3864 2021-04-21 Sunrise At La Costa San Diego 15 11 0 1 73       <11
4871 4871 2021-04-06 Las Villas Del Norte San Diego 15 58 0 12 73        
4911 4911 2021-04-06 Sunrise At La Costa San Diego 15 11 0 1 73       <11
5919 5919 2021-03-30 Las Villas Del Norte San Diego 15 58 0 12 73        
5959 5959 2021-03-30 Sunrise At La Costa San Diego 15 11 0 1 73       <11
6966 6966 2021-03-29 Las Villas Del Norte San Diego 15 58 0 12 73        
7006 7006 2021-03-29 Sunrise At La Costa San Diego 15 11 0 1 73       <11
8013 8013 2021-03-25 Las Villas Del Norte San Diego 15 58 0 12 73        
8053 8053 2021-03-25 Sunrise At La Costa San Diego 15 11 0 1 73       <11
9060 9060 2021-03-24 Las Villas Del Norte San Diego 15 58 0 12 73        
9100 9100 2021-03-24 Sunrise At La Costa San Diego 15 11 0 1 73       <11
10107 10107 2021-03-23 Las Villas Del Norte San Diego 15 58 0 12 73        
10147 10147 2021-03-23 Sunrise At La Costa San Diego 15 11 0 1 73       <11
11153 11153 2021-03-22 Las Villas Del Norte San Diego 15 58 0 12 73        
11193 11193 2021-03-22 Sunrise At La Costa San Diego 15 11 0 1 73       <11
12199 12199 2021-03-19 Las Villas Del Norte San Diego 15 58 0 12 73        
12239 12239 2021-03-19 Sunrise At La Costa San Diego 15 11 0 1 73       <11
13244 13244 2021-03-18 Las Villas Del Norte San Diego 15 58 0 12 73        
13284 13284 2021-03-18 Sunrise At La Costa San Diego 15 11 0 1 73       <11
14288 14288 2021-03-17 Las Villas Del Norte San Diego 15 58 0 12 73        
14328 14328 2021-03-17 Sunrise At La Costa San Diego 15 11 0 1 73       <11
15331 15331 2021-03-16 Las Villas Del Norte San Diego 15 58 0 12 73        
15372 15372 2021-03-16 Sunrise At La Costa San Diego 15 11 0 1 73       <11
16376 16376 2021-03-15 Las Villas Del Norte San Diego 15 58 0 12 73        
16416 16416 2021-03-15 Sunrise At La Costa San Diego 15 11 0 1 73       <11
17420 17420 2021-03-12 Las Villas Del Norte San Diego 15 58 0 12 73        
17460 17460 2021-03-12 Sunrise At La Costa San Diego 15 11 0 1 73       <11
18463 18463 2021-03-11 Las Villas Del Norte San Diego 15 58 0 12 73        
18503 18503 2021-03-11 Sunrise At La Costa San Diego 15 11 0 1 73       <11
19505 19505 2021-03-10 Las Villas Del Norte San Diego 15 58 0 12 73        
19545 19545 2021-03-10 Sunrise At La Costa San Diego 15 11 0 1 73       <11
20547 20547 2021-03-09 Las Villas Del Norte San Diego 15 58 0 12 73        
20587 20587 2021-03-09 Sunrise At La Costa San Diego 15 11 0 1 73       <11
21548 21548 2021-03-08 Las Villas Del Norte San Diego 15 58 0 12 73        
21587 21587 2021-03-08 Sunrise At La Costa San Diego 15 11 0 1 73       <11
22576 22576 2021-03-04 Las Villas Del Norte San Diego 15 58 0 12 73        
22616 22616 2021-03-04 Sunrise At La Costa San Diego 15 11 0 1 73       <11
23616 23616 2021-03-03 Las Villas Del Norte San Diego 15 58 0 12 73        
23656 23656 2021-03-03 Sunrise At La Costa San Diego 15 11 0 1 73       <11
24656 24656 2021-03-02 Las Villas Del Norte San Diego 15 58 0 12 73        
24696 24696 2021-03-02 Sunrise At La Costa San Diego 15 11 0 1 73       <11
25695 25695 2021-03-01 Las Villas Del Norte San Diego 15 58 0 12 73        
25735 25735 2021-03-01 Sunrise At La Costa San Diego 15 11 0 1 73       <11
26732 26732 2021-02-26 Las Villas Del Norte San Diego 15 58 0 12 73        
26772 26772 2021-02-26 Sunrise At La Costa San Diego 15 11 0 1 73       <11
27769 27769 2021-02-25 Las Villas Del Norte San Diego 15 58 0 12 73        
27809 27809 2021-02-25 Sunrise At La Costa San Diego 15 11 0 1 73       <11
28805 28805 2021-02-24 Las Villas Del Norte San Diego 15 58 0 12 73        
28845 28845 2021-02-24 Sunrise At La Costa San Diego 15 11 0 1 73       <11
29839 29839 2021-02-22 Las Villas Del Norte San Diego 15 58 0 12 73        
29878 29878 2021-02-22 Sunrise At La Costa San Diego 15 11 0 1 73       <11
30873 30873 2021-02-19 Las Villas Del Norte San Diego 15 58 0 12 73        
30911 30911 2021-02-19 Sunrise Assisted Living At La Jolla San Diego 15 1 0 1 73   <11   <11
30912 30912 2021-02-19 Sunrise At La Costa San Diego 15 11 0 1 73       <11
31907 31907 2021-02-18 Las Villas Del Norte San Diego 15 58 0 12 73        
31945 31945 2021-02-18 Sunrise Assisted Living At La Jolla San Diego 15 1 0 1 73   <11   <11
31946 31946 2021-02-18 Sunrise At La Costa San Diego 15 11 0 1 73       <11
32940 32940 2021-02-17 Las Villas Del Norte San Diego 15 58 0 12 73        
32978 32978 2021-02-17 Sunrise Assisted Living At La Jolla San Diego 15 1 0 1 73   <11   <11
32979 32979 2021-02-17 Sunrise At La Costa San Diego 15 11 0 1 73       <11
33971 33971 2021-02-16 Las Villas Del Norte San Diego 15 58 0 12 73        
34009 34009 2021-02-16 Sunrise Assisted Living At La Jolla San Diego 15 1 0 1 73   <11   <11
34010 34010 2021-02-16 Sunrise At La Costa San Diego 15 11 0 1 73       <11
34999 34999 2021-02-12 Las Villas Del Norte San Diego 15 58 0 12 73        
35022 35022 2021-02-12 Redwood Terrace San Diego 15 1 0 1 73   <11   <11
35037 35037 2021-02-12 Sunrise Assisted Living At La Jolla San Diego 15 1 0 1 73   <11   <11
35038 35038 2021-02-12 Sunrise At La Costa San Diego 15 11 0 1 73       <11
36026 36026 2021-02-11 Las Villas Del Norte San Diego 15 58 0 12 73        
36049 36049 2021-02-11 Redwood Terrace San Diego 15 1 0 1 73   <11   <11
36064 36064 2021-02-11 Sunrise Assisted Living At La Jolla San Diego 15 1 0 1 73   <11   <11
36065 36065 2021-02-11 Sunrise At La Costa San Diego 15 11 0 1 73       <11
37051 37051 2021-02-10 Las Villas Del Norte San Diego 15 58 0 12 73        
37074 37074 2021-02-10 Redwood Terrace San Diego 15 1 0 1 73   <11   <11
37089 37089 2021-02-10 Sunrise Assisted Living At La Jolla San Diego 15 1 0 1 73   <11   <11
37090 37090 2021-02-10 Sunrise At La Costa San Diego 15 11 0 1 73       <11
38076 38076 2021-02-09 Las Villas Del Norte San Diego 15 58 0 12 73        
38099 38099 2021-02-09 Redwood Terrace San Diego 15 1 0 1 73   <11   <11
38114 38114 2021-02-09 Sunrise Assisted Living At La Jolla San Diego 15 1 0 1 73   <11   <11
38115 38115 2021-02-09 Sunrise At La Costa San Diego 15 11 0 1 73       <11
39100 39100 2021-02-08 Las Villas Del Norte San Diego 15 58 0 12 73        
39123 39123 2021-02-08 Redwood Terrace San Diego 15 1 0 1 73   <11   <11
39138 39138 2021-02-08 Sunrise Assisted Living At La Jolla San Diego 15 1 0 1 73   <11   <11
39139 39139 2021-02-08 Sunrise At La Costa San Diego 15 11 0 1 73       <11
40120 40120 2021-02-05 Las Villas Del Norte San Diego 15 58 0 12 73        
40135 40135 2021-02-05 Oakmont Of Pacific Beach San Diego 15 27 0 1 73       <11
40143 40143 2021-02-05 Redwood Terrace San Diego 15 1 0 1 73   <11   <11
40158 40158 2021-02-05 Sunrise Assisted Living At La Jolla San Diego 15 1 0 1 73   <11   <11
40159 40159 2021-02-05 Sunrise At La Costa San Diego 15 11 0 1 73       <11
41134 41134 2021-02-04 Las Villas Del Norte San Diego 15 58 0 12 73        
41149 41149 2021-02-04 Oakmont Of Pacific Beach San Diego 15 27 0 1 73       <11
41157 41157 2021-02-04 Redwood Terrace San Diego 15 1 0 1 73   <11   <11
41172 41172 2021-02-04 Sunrise Assisted Living At La Jolla San Diego 15 1 0 1 73   <11   <11
41173 41173 2021-02-04 Sunrise At La Costa San Diego 15 11 0 1 73       <11

Next page

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