la_times_cdph_adult_and_senior_care_facilities
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
14 rows where "date" is on date 2021-03-12 and patients_deaths = 12 sorted by date descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16873 | 16873 | 2021-03-12 | Canyon Trails At Topanga Senior Living | Los Angeles | 34 | 74 | 0 | 12 | 37 | ||||
16956 | 16956 | 2021-03-12 | Meadowbrook At Agoura Hills | Los Angeles | 44 | 55 | 0 | 12 | 37 | ||||
17000 | 17000 | 2021-03-12 | Regency Park Oak Knoll | Los Angeles | 43 | 61 | 0 | 12 | 37 | ||||
17367 | 17367 | 2021-03-12 | Valley Crest | San Bernardino | 17 | 34 | 0 | 12 | 71 | ||||
17383 | 17383 | 2021-03-12 | Atria Rancho Penasquitos | San Diego | 23 | 60 | 0 | 12 | 73 | ||||
17420 | 17420 | 2021-03-12 | Las Villas Del Norte | San Diego | 15 | 58 | 0 | 12 | 73 | ||||
17423 | 17423 | 2021-03-12 | Meridian At Lake San Marcos, The | San Diego | 37 | 41 | 0 | 12 | 73 | ||||
17452 | 17452 | 2021-03-12 | Silvergate San Marcos Retirement Residence | San Diego | 44 | 59 | 0 | 12 | 73 | ||||
17464 | 17464 | 2021-03-12 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
17535 | 17535 | 2021-03-12 | Gordon Manor | San Mateo | 12 | 25 | 0 | 12 | 81 | ||||
17583 | 17583 | 2021-03-12 | Carlton Plaza Of San Jose | Santa Clara | 50 | 53 | 0 | 12 | 85 | ||||
17599 | 17599 | 2021-03-12 | Palm Villas, Campbell | Santa Clara | 19 | 33 | 1 | 12 | 85 | <11 | |||
17606 | 17606 | 2021-03-12 | Sunnyside Gardens | Santa Clara | 25 | 31 | 0 | 12 | 85 | ||||
17726 | 17726 | 2021-03-12 | Royal Gardens Of Camarillo | Ventura | 37 | 66 | 0 | 12 | 111 |
Advanced export
JSON shape: default, array, newline-delimited
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 );