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
182 rows where county = "Madera" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
82694 | 82694 | 2020-11-04 | Cedar Creek Senior Living | Madera | 1 | 20 | 0 | 1 | 39 | <11 | <11 | ||
83104 | 83104 | 2020-11-03 | Cedar Creek Senior Living | Madera | 1 | 20 | 0 | 1 | 39 | <11 | <11 | ||
83511 | 83511 | 2020-11-02 | Cedar Creek Senior Living | Madera | 1 | 20 | 0 | 1 | 39 | <11 | <11 | ||
83915 | 83915 | 2020-10-30 | Cedar Creek Senior Living | Madera | 1 | 20 | 0 | 1 | 39 | <11 | <11 | ||
84317 | 84317 | 2020-10-29 | Cedar Creek Senior Living | Madera | 1 | 20 | 0 | 1 | 39 | <11 | <11 | ||
84719 | 84719 | 2020-10-28 | Cedar Creek Senior Living | Madera | 1 | 20 | 0 | 1 | 39 | <11 | <11 | ||
85120 | 85120 | 2020-10-27 | Cedar Creek Senior Living | Madera | 1 | 20 | 0 | 1 | 39 | <11 | <11 | ||
85522 | 85522 | 2020-10-26 | Cedar Creek Senior Living | Madera | 1 | 20 | 0 | 1 | 39 | <11 | <11 | ||
85916 | 85916 | 2020-10-23 | Cedar Creek Senior Living | Madera | 1 | 20 | 0 | 1 | 39 | <11 | <11 | ||
86309 | 86309 | 2020-10-22 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
86704 | 86704 | 2020-10-21 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
87099 | 87099 | 2020-10-20 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
87491 | 87491 | 2020-10-19 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
87882 | 87882 | 2020-10-16 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
88273 | 88273 | 2020-10-15 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
88662 | 88662 | 2020-10-14 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
89050 | 89050 | 2020-10-13 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
89436 | 89436 | 2020-10-12 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
89818 | 89818 | 2020-10-09 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
90200 | 90200 | 2020-10-08 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
90580 | 90580 | 2020-10-07 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
90957 | 90957 | 2020-10-06 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
91331 | 91331 | 2020-10-05 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
91701 | 91701 | 2020-10-02 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
92067 | 92067 | 2020-10-01 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
92434 | 92434 | 2020-09-30 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
92795 | 92795 | 2020-09-29 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
93151 | 93151 | 2020-09-28 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
93504 | 93504 | 2020-09-25 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
93860 | 93860 | 2020-09-24 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
94215 | 94215 | 2020-09-23 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
94562 | 94562 | 2020-09-22 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
94911 | 94911 | 2020-09-21 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
95262 | 95262 | 2020-09-18 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
95608 | 95608 | 2020-09-17 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
95952 | 95952 | 2020-09-16 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
96292 | 96292 | 2020-09-15 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
96625 | 96625 | 2020-09-14 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
96957 | 96957 | 2020-09-11 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
97290 | 97290 | 2020-09-10 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
97621 | 97621 | 2020-09-09 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
97946 | 97946 | 2020-09-08 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
98270 | 98270 | 2020-09-07 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
98592 | 98592 | 2020-09-04 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
98910 | 98910 | 2020-09-03 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
99224 | 99224 | 2020-09-02 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
99536 | 99536 | 2020-09-01 | Cedar Creek Senior Living | Madera | 1 | 20 | 0 | 1 | 39 | <11 | <11 | ||
99847 | 99847 | 2020-08-31 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
100153 | 100153 | 2020-08-28 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
100458 | 100458 | 2020-08-27 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
100761 | 100761 | 2020-08-26 | Cedar Creek Senior Living | Madera | 1 | 20 | 0 | 1 | 39 | <11 | <11 | ||
101062 | 101062 | 2020-08-25 | Cedar Creek Senior Living | Madera | 1 | 20 | 0 | 1 | 39 | <11 | <11 | ||
101362 | 101362 | 2020-08-24 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
101653 | 101653 | 2020-08-23 | Cedar Creek Senior Living | Madera | 1 | 20 | 0 | 1 | 39 | <11 | <11 | ||
101944 | 101944 | 2020-08-22 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
102235 | 102235 | 2020-08-21 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
102526 | 102526 | 2020-08-19 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
102808 | 102808 | 2020-08-18 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
103088 | 103088 | 2020-08-16 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
103367 | 103367 | 2020-08-15 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
103642 | 103642 | 2020-08-14 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
103912 | 103912 | 2020-08-13 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
104176 | 104176 | 2020-08-12 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
104437 | 104437 | 2020-08-11 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
104697 | 104697 | 2020-08-10 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
104955 | 104955 | 2020-08-09 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
105206 | 105206 | 2020-08-08 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
105453 | 105453 | 2020-08-07 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
105693 | 105693 | 2020-08-06 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
105926 | 105926 | 2020-08-05 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
106160 | 106160 | 2020-08-04 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
106393 | 106393 | 2020-08-03 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
106626 | 106626 | 2020-08-02 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
106856 | 106856 | 2020-08-01 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
107080 | 107080 | 2020-07-31 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
107299 | 107299 | 2020-07-30 | Cedar Creek Senior Living | Madera | 1 | 21 | 0 | 1 | 39 | <11 | <11 | ||
107516 | 107516 | 2020-07-29 | Cedar Creek Senior Living | Madera | 1 | 19 | 0 | 1 | 39 | <11 | <11 | ||
107730 | 107730 | 2020-07-28 | Cedar Creek Senior Living | Madera | 1 | 19 | 0 | 1 | 39 | <11 | <11 | ||
107935 | 107935 | 2020-07-27 | Cedar Creek Senior Living | Madera | 1 | 18 | 0 | 1 | 39 | <11 | <11 | ||
108137 | 108137 | 2020-07-26 | Cedar Creek Senior Living | Madera | 1 | 19 | 0 | 1 | 39 | <11 | <11 | ||
108335 | 108335 | 2020-07-25 | Cedar Creek Senior Living | Madera | 1 | 18 | 0 | 1 | 39 | <11 | <11 | ||
108525 | 108525 | 2020-07-24 | Cedar Creek Senior Living | Madera | 1 | 1 | 0 | 1 | 39 | <11 | <11 | <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 );