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
53 rows where county = "San Francisco" and staff_confirmed_cases = 17 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
780 | 780 | 2021-06-27 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
1787 | 1787 | 2021-05-11 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
2827 | 2827 | 2021-04-27 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
3876 | 3876 | 2021-04-21 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
4923 | 4923 | 2021-04-06 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
5970 | 5970 | 2021-03-30 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
7017 | 7017 | 2021-03-29 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
8064 | 8064 | 2021-03-25 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
9111 | 9111 | 2021-03-24 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
10158 | 10158 | 2021-03-23 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
11204 | 11204 | 2021-03-22 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
12250 | 12250 | 2021-03-19 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
13295 | 13295 | 2021-03-18 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
14339 | 14339 | 2021-03-17 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
15383 | 15383 | 2021-03-16 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
16427 | 16427 | 2021-03-15 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
17471 | 17471 | 2021-03-12 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
18514 | 18514 | 2021-03-11 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
19556 | 19556 | 2021-03-10 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
20598 | 20598 | 2021-03-09 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
21598 | 21598 | 2021-03-08 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
22627 | 22627 | 2021-03-04 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
23667 | 23667 | 2021-03-03 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
24707 | 24707 | 2021-03-02 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
25746 | 25746 | 2021-03-01 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
26783 | 26783 | 2021-02-26 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
27820 | 27820 | 2021-02-25 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
28856 | 28856 | 2021-02-24 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
29889 | 29889 | 2021-02-22 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
30923 | 30923 | 2021-02-19 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
31957 | 31957 | 2021-02-18 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
32990 | 32990 | 2021-02-17 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
34021 | 34021 | 2021-02-16 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
35049 | 35049 | 2021-02-12 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
36076 | 36076 | 2021-02-11 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
37101 | 37101 | 2021-02-10 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
38126 | 38126 | 2021-02-09 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
39150 | 39150 | 2021-02-08 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
40170 | 40170 | 2021-02-05 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
41184 | 41184 | 2021-02-04 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
42195 | 42195 | 2021-02-03 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
43203 | 43203 | 2021-02-02 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
44209 | 44209 | 2021-02-01 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
45212 | 45212 | 2021-01-29 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
46207 | 46207 | 2021-01-28 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
47205 | 47205 | 2021-01-27 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
48161 | 48161 | 2021-01-26 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
49141 | 49141 | 2021-01-25 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
50081 | 50081 | 2021-01-21 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
51036 | 51036 | 2021-01-20 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
51995 | 51995 | 2021-01-19 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
52933 | 52933 | 2021-01-15 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
53847 | 53847 | 2021-01-14 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 |
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 );