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-17 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13741 | 13741 | 2021-03-17 | Canyon Trails At Topanga Senior Living | Los Angeles | 34 | 74 | 0 | 12 | 37 | ||||
13824 | 13824 | 2021-03-17 | Meadowbrook At Agoura Hills | Los Angeles | 44 | 55 | 0 | 12 | 37 | ||||
13868 | 13868 | 2021-03-17 | Regency Park Oak Knoll | Los Angeles | 43 | 61 | 0 | 12 | 37 | ||||
14235 | 14235 | 2021-03-17 | Valley Crest | San Bernardino | 17 | 34 | 0 | 12 | 71 | ||||
14251 | 14251 | 2021-03-17 | Atria Rancho Penasquitos | San Diego | 23 | 60 | 0 | 12 | 73 | ||||
14288 | 14288 | 2021-03-17 | Las Villas Del Norte | San Diego | 15 | 58 | 0 | 12 | 73 | ||||
14291 | 14291 | 2021-03-17 | Meridian At Lake San Marcos, The | San Diego | 37 | 41 | 0 | 12 | 73 | ||||
14320 | 14320 | 2021-03-17 | Silvergate San Marcos Retirement Residence | San Diego | 44 | 59 | 0 | 12 | 73 | ||||
14332 | 14332 | 2021-03-17 | Vista Gardens | San Diego | 23 | 43 | 0 | 12 | 73 | ||||
14403 | 14403 | 2021-03-17 | Gordon Manor | San Mateo | 12 | 25 | 0 | 12 | 81 | ||||
14451 | 14451 | 2021-03-17 | Carlton Plaza Of San Jose | Santa Clara | 50 | 53 | 0 | 12 | 85 | ||||
14467 | 14467 | 2021-03-17 | Palm Villas, Campbell | Santa Clara | 19 | 33 | 1 | 12 | 85 | <11 | |||
14474 | 14474 | 2021-03-17 | Sunnyside Gardens | Santa Clara | 25 | 31 | 0 | 12 | 85 | ||||
14594 | 14594 | 2021-03-17 | 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 );