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
2,148 rows where fips = 13 and patients_deaths = 1 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: staff_confirmed_cases, patients_confirmed_cases, staff_confirmed_cases_note, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
53 | 53 | 2021-06-27 | Aegis Assisted Living Of Pleasant Hill | Contra Costa | 19 | 28 | 0 | 1 | 13 | <11 | |||
56 | 56 | 2021-06-27 | Brookdale Diablo Lodge | Contra Costa | 1 | 12 | 0 | 1 | 13 | <11 | <11 | ||
57 | 57 | 2021-06-27 | Brookdale San Ramon | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
58 | 58 | 2021-06-27 | Byron Park | Contra Costa | 17 | 14 | 0 | 1 | 13 | <11 | |||
59 | 59 | 2021-06-27 | Carnelian I | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
60 | 60 | 2021-06-27 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
61 | 61 | 2021-06-27 | Chateau III | Contra Costa | 38 | 39 | 0 | 1 | 13 | <11 | |||
62 | 62 | 2021-06-27 | Commons At Dallas Ranch, The | Contra Costa | 13 | 16 | 0 | 1 | 13 | <11 | |||
63 | 63 | 2021-06-27 | Concord Royale | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
65 | 65 | 2021-06-27 | Friendship Care Home | Contra Costa | 1 | 16 | 0 | 1 | 13 | <11 | <11 | ||
66 | 66 | 2021-06-27 | Greenridge Senior Care | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
68 | 68 | 2021-06-27 | Kensington, The | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
71 | 71 | 2021-06-27 | Reutlinger Community, The | Contra Costa | 14 | 1 | 0 | 1 | 13 | <11 | <11 | ||
72 | 72 | 2021-06-27 | Sunrise Assisted Living Of Danville | Contra Costa | 33 | 25 | 0 | 1 | 13 | <11 | |||
73 | 73 | 2021-06-27 | Sunrise Assisted Living Of Walnut Creek | Contra Costa | 17 | 25 | 0 | 1 | 13 | <11 | |||
74 | 74 | 2021-06-27 | Sunrise Villa San Ramon | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
75 | 75 | 2021-06-27 | TreVista Concord | Contra Costa | 13 | 22 | 0 | 1 | 13 | <11 | |||
76 | 76 | 2021-06-27 | Trevista Antioch | Contra Costa | 30 | 45 | 0 | 1 | 13 | <11 | |||
77 | 77 | 2021-06-27 | Walnut Creek Willows | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
78 | 78 | 2021-06-27 | Westmont Of Brentwood | Contra Costa | 25 | 34 | 0 | 1 | 13 | <11 | |||
1106 | 1106 | 2021-05-11 | Aegis Assisted Living Of Pleasant Hill | Contra Costa | 19 | 28 | 0 | 1 | 13 | <11 | |||
1109 | 1109 | 2021-05-11 | Brookdale Diablo Lodge | Contra Costa | 1 | 12 | 0 | 1 | 13 | <11 | <11 | ||
1110 | 1110 | 2021-05-11 | Brookdale San Ramon | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
1111 | 1111 | 2021-05-11 | Byron Park | Contra Costa | 17 | 14 | 0 | 1 | 13 | <11 | |||
1112 | 1112 | 2021-05-11 | Carnelian I | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
1113 | 1113 | 2021-05-11 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
1114 | 1114 | 2021-05-11 | Chateau III | Contra Costa | 38 | 39 | 0 | 1 | 13 | <11 | |||
1115 | 1115 | 2021-05-11 | Commons At Dallas Ranch, The | Contra Costa | 13 | 16 | 0 | 1 | 13 | <11 | |||
1116 | 1116 | 2021-05-11 | Concord Royale | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
1118 | 1118 | 2021-05-11 | Friendship Care Home | Contra Costa | 1 | 16 | 0 | 1 | 13 | <11 | <11 | ||
1119 | 1119 | 2021-05-11 | Greenridge Senior Care | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
1121 | 1121 | 2021-05-11 | Kensington, The | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
1124 | 1124 | 2021-05-11 | Reutlinger Community, The | Contra Costa | 14 | 1 | 0 | 1 | 13 | <11 | <11 | ||
1125 | 1125 | 2021-05-11 | Sunrise Assisted Living Of Danville | Contra Costa | 33 | 25 | 0 | 1 | 13 | <11 | |||
1126 | 1126 | 2021-05-11 | Sunrise Assisted Living Of Walnut Creek | Contra Costa | 17 | 25 | 0 | 1 | 13 | <11 | |||
1127 | 1127 | 2021-05-11 | Sunrise Villa San Ramon | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
1128 | 1128 | 2021-05-11 | TreVista Concord | Contra Costa | 12 | 22 | 0 | 1 | 13 | <11 | |||
1129 | 1129 | 2021-05-11 | Trevista Antioch | Contra Costa | 30 | 45 | 0 | 1 | 13 | <11 | |||
1130 | 1130 | 2021-05-11 | Walnut Creek Willows | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
1131 | 1131 | 2021-05-11 | Westmont Of Brentwood | Contra Costa | 25 | 34 | 0 | 1 | 13 | <11 | |||
2104 | 2104 | 2021-04-27 | Aegis Assisted Living Of Pleasant Hill | Contra Costa | 19 | 28 | 0 | 1 | 13 | <11 | |||
2107 | 2107 | 2021-04-27 | Brookdale Diablo Lodge | Contra Costa | 1 | 12 | 0 | 1 | 13 | <11 | <11 | ||
2108 | 2108 | 2021-04-27 | Brookdale San Ramon | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
2109 | 2109 | 2021-04-27 | Byron Park | Contra Costa | 17 | 14 | 0 | 1 | 13 | <11 | |||
2110 | 2110 | 2021-04-27 | Carnelian I | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
2111 | 2111 | 2021-04-27 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
2112 | 2112 | 2021-04-27 | Chateau III | Contra Costa | 38 | 39 | 0 | 1 | 13 | <11 | |||
2113 | 2113 | 2021-04-27 | Commons At Dallas Ranch, The | Contra Costa | 13 | 16 | 0 | 1 | 13 | <11 | |||
2114 | 2114 | 2021-04-27 | Concord Royale | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
2115 | 2115 | 2021-04-27 | Friendship Care Home | Contra Costa | 1 | 16 | 0 | 1 | 13 | <11 | <11 | ||
2116 | 2116 | 2021-04-27 | Greenridge Senior Care | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
2121 | 2121 | 2021-04-27 | Reutlinger Community, The | Contra Costa | 14 | 1 | 0 | 1 | 13 | <11 | <11 | ||
2122 | 2122 | 2021-04-27 | Sunrise Assisted Living Of Danville | Contra Costa | 33 | 25 | 0 | 1 | 13 | <11 | |||
2123 | 2123 | 2021-04-27 | Sunrise Assisted Living Of Walnut Creek | Contra Costa | 17 | 25 | 0 | 1 | 13 | <11 | |||
2124 | 2124 | 2021-04-27 | Sunrise Villa San Ramon | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
2125 | 2125 | 2021-04-27 | TreVista Concord | Contra Costa | 12 | 22 | 0 | 1 | 13 | <11 | |||
2126 | 2126 | 2021-04-27 | Trevista Antioch | Contra Costa | 29 | 45 | 0 | 1 | 13 | <11 | |||
2127 | 2127 | 2021-04-27 | Walnut Creek Willows | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
2128 | 2128 | 2021-04-27 | Westmont Of Brentwood | Contra Costa | 25 | 34 | 0 | 1 | 13 | <11 | |||
3153 | 3153 | 2021-04-21 | Aegis Assisted Living Of Pleasant Hill | Contra Costa | 19 | 28 | 0 | 1 | 13 | <11 | |||
3156 | 3156 | 2021-04-21 | Brookdale Diablo Lodge | Contra Costa | 1 | 12 | 0 | 1 | 13 | <11 | <11 | ||
3157 | 3157 | 2021-04-21 | Brookdale San Ramon | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
3158 | 3158 | 2021-04-21 | Byron Park | Contra Costa | 17 | 14 | 0 | 1 | 13 | <11 | |||
3159 | 3159 | 2021-04-21 | Carnelian I | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
3160 | 3160 | 2021-04-21 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
3161 | 3161 | 2021-04-21 | Chateau III | Contra Costa | 38 | 39 | 0 | 1 | 13 | <11 | |||
3162 | 3162 | 2021-04-21 | Commons At Dallas Ranch, The | Contra Costa | 13 | 16 | 0 | 1 | 13 | <11 | |||
3163 | 3163 | 2021-04-21 | Concord Royale | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
3164 | 3164 | 2021-04-21 | Friendship Care Home | Contra Costa | 1 | 16 | 0 | 1 | 13 | <11 | <11 | ||
3165 | 3165 | 2021-04-21 | Greenridge Senior Care | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
3170 | 3170 | 2021-04-21 | Reutlinger Community, The | Contra Costa | 14 | 1 | 0 | 1 | 13 | <11 | <11 | ||
3171 | 3171 | 2021-04-21 | Sunrise Assisted Living Of Danville | Contra Costa | 33 | 25 | 0 | 1 | 13 | <11 | |||
3172 | 3172 | 2021-04-21 | Sunrise Assisted Living Of Walnut Creek | Contra Costa | 17 | 25 | 0 | 1 | 13 | <11 | |||
3173 | 3173 | 2021-04-21 | Sunrise Villa San Ramon | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
3174 | 3174 | 2021-04-21 | TreVista Concord | Contra Costa | 12 | 22 | 0 | 1 | 13 | <11 | |||
3175 | 3175 | 2021-04-21 | Trevista Antioch | Contra Costa | 28 | 45 | 0 | 1 | 13 | <11 | |||
3176 | 3176 | 2021-04-21 | Walnut Creek Willows | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
3177 | 3177 | 2021-04-21 | Westmont Of Brentwood | Contra Costa | 25 | 34 | 0 | 1 | 13 | <11 | |||
4202 | 4202 | 2021-04-06 | Aegis Assisted Living Of Pleasant Hill | Contra Costa | 19 | 28 | 0 | 1 | 13 | <11 | |||
4205 | 4205 | 2021-04-06 | Brookdale Diablo Lodge | Contra Costa | 1 | 12 | 0 | 1 | 13 | <11 | <11 | ||
4206 | 4206 | 2021-04-06 | Brookdale San Ramon | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
4207 | 4207 | 2021-04-06 | Byron Park | Contra Costa | 16 | 14 | 0 | 1 | 13 | <11 | |||
4208 | 4208 | 2021-04-06 | Carnelian I | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
4209 | 4209 | 2021-04-06 | Chateau At Poets Corner | Contra Costa | 27 | 28 | 0 | 1 | 13 | <11 | |||
4210 | 4210 | 2021-04-06 | Chateau III | Contra Costa | 38 | 39 | 0 | 1 | 13 | <11 | |||
4211 | 4211 | 2021-04-06 | Commons At Dallas Ranch, The | Contra Costa | 13 | 16 | 0 | 1 | 13 | <11 | |||
4212 | 4212 | 2021-04-06 | Concord Royale | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
4213 | 4213 | 2021-04-06 | Friendship Care Home | Contra Costa | 1 | 16 | 0 | 1 | 13 | <11 | <11 | ||
4214 | 4214 | 2021-04-06 | Greenridge Senior Care | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
4219 | 4219 | 2021-04-06 | Reutlinger Community, The | Contra Costa | 14 | 1 | 0 | 1 | 13 | <11 | <11 | ||
4220 | 4220 | 2021-04-06 | Sunrise Assisted Living Of Danville | Contra Costa | 33 | 25 | 0 | 1 | 13 | <11 | |||
4221 | 4221 | 2021-04-06 | Sunrise Assisted Living Of Walnut Creek | Contra Costa | 17 | 25 | 0 | 1 | 13 | <11 | |||
4222 | 4222 | 2021-04-06 | Sunrise Villa San Ramon | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
4223 | 4223 | 2021-04-06 | TreVista Concord | Contra Costa | 12 | 22 | 0 | 1 | 13 | <11 | |||
4224 | 4224 | 2021-04-06 | Trevista Antioch | Contra Costa | 28 | 45 | 0 | 1 | 13 | <11 | |||
4225 | 4225 | 2021-04-06 | Walnut Creek Willows | Contra Costa | 1 | 1 | 0 | 1 | 13 | <11 | <11 | <11 | |
4226 | 4226 | 2021-04-06 | Westmont Of Brentwood | Contra Costa | 25 | 34 | 0 | 1 | 13 | <11 | |||
5249 | 5249 | 2021-03-30 | Aegis Assisted Living Of Pleasant Hill | Contra Costa | 19 | 28 | 0 | 1 | 13 | <11 | |||
5252 | 5252 | 2021-03-30 | Brookdale Diablo Lodge | Contra Costa | 1 | 12 | 0 | 1 | 13 | <11 | <11 | ||
5253 | 5253 | 2021-03-30 | Brookdale San Ramon | Contra Costa | 1 | 1 | 0 | 1 | 13 | <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 );