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
48 rows where county = "Sacramento" and patients_deaths = 18 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
634 | 634 | 2021-06-27 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
1648 | 1648 | 2021-05-11 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
2683 | 2683 | 2021-04-27 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
3732 | 3732 | 2021-04-21 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
4779 | 4779 | 2021-04-06 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
5826 | 5826 | 2021-03-30 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
6873 | 6873 | 2021-03-29 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
7920 | 7920 | 2021-03-25 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
8967 | 8967 | 2021-03-24 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
10014 | 10014 | 2021-03-23 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
11060 | 11060 | 2021-03-22 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
12106 | 12106 | 2021-03-19 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
13151 | 13151 | 2021-03-18 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
14195 | 14195 | 2021-03-17 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
15239 | 15239 | 2021-03-16 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
16283 | 16283 | 2021-03-15 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
17327 | 17327 | 2021-03-12 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
18370 | 18370 | 2021-03-11 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
19412 | 19412 | 2021-03-10 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
20454 | 20454 | 2021-03-09 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
21460 | 21460 | 2021-03-08 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
22483 | 22483 | 2021-03-04 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
23523 | 23523 | 2021-03-03 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
24563 | 24563 | 2021-03-02 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
25602 | 25602 | 2021-03-01 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
26639 | 26639 | 2021-02-26 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
27676 | 27676 | 2021-02-25 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
28712 | 28712 | 2021-02-24 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
29746 | 29746 | 2021-02-22 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
30780 | 30780 | 2021-02-19 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
31814 | 31814 | 2021-02-18 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
32847 | 32847 | 2021-02-17 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
33878 | 33878 | 2021-02-16 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
34907 | 34907 | 2021-02-12 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
35934 | 35934 | 2021-02-11 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
36959 | 36959 | 2021-02-10 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
37984 | 37984 | 2021-02-09 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
39008 | 39008 | 2021-02-08 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
40028 | 40028 | 2021-02-05 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
41043 | 41043 | 2021-02-04 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
42054 | 42054 | 2021-02-03 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
43062 | 43062 | 2021-02-02 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
44068 | 44068 | 2021-02-01 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
45071 | 45071 | 2021-01-29 | Waterleaf At Land Park, The | Sacramento | 20 | 44 | 0 | 18 | 67 | ||||
46066 | 46066 | 2021-01-28 | Waterleaf At Land Park, The | Sacramento | 20 | 44 | 0 | 18 | 67 | ||||
47065 | 47065 | 2021-01-27 | Waterleaf At Land Park, The | Sacramento | 20 | 44 | 0 | 18 | 67 | ||||
48027 | 48027 | 2021-01-26 | Waterleaf At Land Park, The | Sacramento | 20 | 44 | 0 | 18 | 67 | ||||
49001 | 49001 | 2021-01-25 | Waterleaf At Land Park, The | Sacramento | 20 | 44 | 0 | 18 | 67 |
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 );