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
12 rows where staff_confirmed_cases = 23 and staff_deaths = "" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: name, patients_confirmed_cases, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
116254 | 116254 | 2020-05-07 | Sunrise Assisted Living of Sacramento | Sacramento | 23 | 25 | 67 | ||||||
116303 | 116303 | 2020-05-06 | Sunrise Assisted Living of Sacramento | Sacramento | 23 | 25 | 67 | ||||||
116342 | 116342 | 2020-05-05 | Sunrise Assisted Living of Sacramento | Sacramento | 23 | 25 | 67 | ||||||
116379 | 116379 | 2020-05-04 | Sunrise Assisted Living of Sacramento | Sacramento | 23 | 25 | 67 | ||||||
116416 | 116416 | 2020-05-02 | Sunrise Assisted Living of Sacramento | Sacramento | 23 | 25 | 67 | ||||||
116452 | 116452 | 2020-05-01 | Sunrise Assisted Living of Sacramento | Sacramento | 23 | 25 | 67 | ||||||
116485 | 116485 | 2020-04-30 | Sunrise Assisted Living of Sacramento | Sacramento | 23 | 25 | 67 | ||||||
116518 | 116518 | 2020-04-28 | Sunrise Assisted Living of Sacramento | Sacramento | 23 | 25 | 67 | ||||||
116550 | 116550 | 2020-04-27 | Sunrise Assisted Living of Sacramento | Sacramento | 23 | 25 | 67 | ||||||
116582 | 116582 | 2020-04-26 | Sunrise Assisted Living of Sacramento | Sacramento | 23 | 25 | 67 | ||||||
116598 | 116598 | 2020-04-19 | JASMIN TERRACE AT EL MOLINO | Los Angeles | 23 | 16 | 37 | ||||||
116599 | 116599 | 2020-04-19 | KENSINGTON REDONDO BEACH, THE | Los Angeles | 23 | 19 | 37 |
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 );