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
28 rows where county = "San Bernardino" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
675 | 675 | 2021-06-27 | Valley Crest | San Bernardino | 17 | 34 | 0 | 12 | 71 | ||||
1685 | 1685 | 2021-05-11 | Valley Crest | San Bernardino | 17 | 34 | 0 | 12 | 71 | ||||
2723 | 2723 | 2021-04-27 | Valley Crest | San Bernardino | 17 | 34 | 0 | 12 | 71 | ||||
3772 | 3772 | 2021-04-21 | Valley Crest | San Bernardino | 17 | 34 | 0 | 12 | 71 | ||||
4819 | 4819 | 2021-04-06 | Valley Crest | San Bernardino | 17 | 34 | 0 | 12 | 71 | ||||
5866 | 5866 | 2021-03-30 | Valley Crest | San Bernardino | 17 | 34 | 0 | 12 | 71 | ||||
6913 | 6913 | 2021-03-29 | Valley Crest | San Bernardino | 17 | 34 | 0 | 12 | 71 | ||||
7960 | 7960 | 2021-03-25 | Valley Crest | San Bernardino | 17 | 34 | 0 | 12 | 71 | ||||
9007 | 9007 | 2021-03-24 | Valley Crest | San Bernardino | 17 | 34 | 0 | 12 | 71 | ||||
10054 | 10054 | 2021-03-23 | Valley Crest | San Bernardino | 17 | 34 | 0 | 12 | 71 | ||||
11100 | 11100 | 2021-03-22 | Valley Crest | San Bernardino | 17 | 34 | 0 | 12 | 71 | ||||
12146 | 12146 | 2021-03-19 | Valley Crest | San Bernardino | 17 | 34 | 0 | 12 | 71 | ||||
13191 | 13191 | 2021-03-18 | Valley Crest | San Bernardino | 17 | 34 | 0 | 12 | 71 | ||||
14235 | 14235 | 2021-03-17 | Valley Crest | San Bernardino | 17 | 34 | 0 | 12 | 71 | ||||
15279 | 15279 | 2021-03-16 | Valley Crest | San Bernardino | 17 | 34 | 0 | 12 | 71 | ||||
16323 | 16323 | 2021-03-15 | Valley Crest | San Bernardino | 17 | 34 | 0 | 12 | 71 | ||||
17367 | 17367 | 2021-03-12 | Valley Crest | San Bernardino | 17 | 34 | 0 | 12 | 71 | ||||
18410 | 18410 | 2021-03-11 | Valley Crest | San Bernardino | 17 | 34 | 0 | 12 | 71 | ||||
19452 | 19452 | 2021-03-10 | Valley Crest | San Bernardino | 17 | 34 | 0 | 12 | 71 | ||||
20494 | 20494 | 2021-03-09 | Valley Crest | San Bernardino | 17 | 34 | 0 | 12 | 71 | ||||
21496 | 21496 | 2021-03-08 | Valley Crest | San Bernardino | 17 | 34 | 0 | 12 | 71 | ||||
22523 | 22523 | 2021-03-04 | Valley Crest | San Bernardino | 17 | 34 | 0 | 12 | 71 | ||||
23563 | 23563 | 2021-03-03 | Valley Crest | San Bernardino | 17 | 34 | 0 | 12 | 71 | ||||
24603 | 24603 | 2021-03-02 | Valley Crest | San Bernardino | 17 | 34 | 0 | 12 | 71 | ||||
25642 | 25642 | 2021-03-01 | Valley Crest | San Bernardino | 17 | 34 | 0 | 12 | 71 | ||||
26679 | 26679 | 2021-02-26 | Valley Crest | San Bernardino | 17 | 34 | 0 | 12 | 71 | ||||
27716 | 27716 | 2021-02-25 | Valley Crest | San Bernardino | 17 | 34 | 0 | 12 | 71 | ||||
28752 | 28752 | 2021-02-24 | Valley Crest | San Bernardino | 17 | 34 | 0 | 12 | 71 |
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 );