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
4,048 rows where fips = 1 sorted by patients_deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: patients_deaths, patients_confirmed_cases_note, patients_deaths_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | 2021-06-27 | Acacia Creek - Union City | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
2 | 2 | 2021-06-27 | Aegis Assisted Living Of Fremont | Alameda | 12 | 15 | 0 | 0 | 1 | ||||
4 | 4 | 2021-06-27 | Belmont Village Albany | Alameda | 15 | 1 | 0 | 0 | 1 | <11 | |||
7 | 7 | 2021-06-27 | Carlton Plaza Of Fremont | Alameda | 13 | 1 | 0 | 0 | 1 | <11 | |||
10 | 10 | 2021-06-27 | Elder Ashram | Alameda | 1 | 18 | 0 | 0 | 1 | <11 | |||
11 | 11 | 2021-06-27 | Fremont Hills | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
12 | 12 | 2021-06-27 | Fremont Rtrmt Com-Happy Lvng By Cogir/Cogir Fremon | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
17 | 17 | 2021-06-27 | Landmark Villa | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
20 | 20 | 2021-06-27 | Masonic Home For Adults | Alameda | 17 | 1 | 0 | 0 | 1 | <11 | |||
26 | 26 | 2021-06-27 | Pacifica Senior Living San Leandro | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
30 | 30 | 2021-06-27 | Rosegate | Alameda | 11 | 19 | 0 | 0 | 1 | ||||
33 | 33 | 2021-06-27 | St. Paul's Towers | Alameda | 20 | 1 | 0 | 0 | 1 | <11 | |||
35 | 35 | 2021-06-27 | Stoneridge Creek Pleasanton | Alameda | 38 | 1 | 0 | 0 | 1 | <11 | |||
36 | 36 | 2021-06-27 | Sunrise Of Pleasanton | Alameda | 13 | 16 | 0 | 0 | 1 | ||||
38 | 38 | 2021-06-27 | Watermark By The Bay, The | Alameda | 12 | 1 | 0 | 0 | 1 | <11 | |||
1055 | 1055 | 2021-05-11 | Acacia Creek - Union City | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
1056 | 1056 | 2021-05-11 | Aegis Assisted Living Of Fremont | Alameda | 12 | 15 | 0 | 0 | 1 | ||||
1058 | 1058 | 2021-05-11 | Belmont Village Albany | Alameda | 15 | 1 | 0 | 0 | 1 | <11 | |||
1061 | 1061 | 2021-05-11 | Carlton Plaza Of Fremont | Alameda | 13 | 1 | 0 | 0 | 1 | <11 | |||
1064 | 1064 | 2021-05-11 | Fremont Hills | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
1065 | 1065 | 2021-05-11 | Fremont Rtrmt Com-Happy Lvng By Cogir/Cogir Fremon | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
1070 | 1070 | 2021-05-11 | Landmark Villa | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
1073 | 1073 | 2021-05-11 | Masonic Home For Adults | Alameda | 17 | 1 | 0 | 0 | 1 | <11 | |||
1079 | 1079 | 2021-05-11 | Pacifica Senior Living San Leandro | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
1083 | 1083 | 2021-05-11 | Rosegate | Alameda | 11 | 19 | 0 | 0 | 1 | ||||
1086 | 1086 | 2021-05-11 | St. Paul's Towers | Alameda | 20 | 1 | 0 | 0 | 1 | <11 | |||
1088 | 1088 | 2021-05-11 | Stoneridge Creek Pleasanton | Alameda | 38 | 1 | 0 | 0 | 1 | <11 | |||
1089 | 1089 | 2021-05-11 | Sunrise Of Pleasanton | Alameda | 13 | 16 | 0 | 0 | 1 | ||||
1091 | 1091 | 2021-05-11 | Watermark By The Bay, The | Alameda | 12 | 1 | 0 | 0 | 1 | <11 | |||
2051 | 2051 | 2021-04-27 | Acacia Creek - Union City | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
2052 | 2052 | 2021-04-27 | Aegis Assisted Living Of Fremont | Alameda | 12 | 15 | 0 | 0 | 1 | ||||
2054 | 2054 | 2021-04-27 | Belmont Village Albany | Alameda | 15 | 1 | 0 | 0 | 1 | <11 | |||
2057 | 2057 | 2021-04-27 | Carlton Plaza Of Fremont | Alameda | 13 | 1 | 0 | 0 | 1 | <11 | |||
2060 | 2060 | 2021-04-27 | Diana's Care Home | Alameda | 1 | 29 | 0 | 0 | 1 | <11 | |||
2061 | 2061 | 2021-04-27 | Elder Ashram | Alameda | 1 | 18 | 0 | 0 | 1 | <11 | |||
2062 | 2062 | 2021-04-27 | Fremont Hills | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
2063 | 2063 | 2021-04-27 | Fremont Rtrmt Com-Happy Lvng By Cogir/Cogir Fremon | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
2068 | 2068 | 2021-04-27 | Landmark Villa | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
2071 | 2071 | 2021-04-27 | Masonic Home For Adults | Alameda | 17 | 1 | 0 | 0 | 1 | <11 | |||
2077 | 2077 | 2021-04-27 | Pacifica Senior Living San Leandro | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
2081 | 2081 | 2021-04-27 | Rosegate | Alameda | 11 | 19 | 0 | 0 | 1 | ||||
2084 | 2084 | 2021-04-27 | St. Paul's Towers | Alameda | 20 | 1 | 0 | 0 | 1 | <11 | |||
2086 | 2086 | 2021-04-27 | Stoneridge Creek Pleasanton | Alameda | 38 | 1 | 0 | 0 | 1 | <11 | |||
2087 | 2087 | 2021-04-27 | Sunrise Of Pleasanton | Alameda | 13 | 16 | 0 | 0 | 1 | ||||
2089 | 2089 | 2021-04-27 | Watermark By The Bay, The | Alameda | 12 | 1 | 0 | 0 | 1 | <11 | |||
3100 | 3100 | 2021-04-21 | Acacia Creek - Union City | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
3101 | 3101 | 2021-04-21 | Aegis Assisted Living Of Fremont | Alameda | 12 | 15 | 0 | 0 | 1 | ||||
3103 | 3103 | 2021-04-21 | Belmont Village Albany | Alameda | 15 | 1 | 0 | 0 | 1 | <11 | |||
3106 | 3106 | 2021-04-21 | Carlton Plaza Of Fremont | Alameda | 13 | 1 | 0 | 0 | 1 | <11 | |||
3109 | 3109 | 2021-04-21 | Diana's Care Home | Alameda | 1 | 29 | 0 | 0 | 1 | <11 | |||
3110 | 3110 | 2021-04-21 | Elder Ashram | Alameda | 1 | 18 | 0 | 0 | 1 | <11 | |||
3111 | 3111 | 2021-04-21 | Fremont Hills | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
3112 | 3112 | 2021-04-21 | Fremont Rtrmt Com-Happy Lvng By Cogir/Cogir Fremon | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
3117 | 3117 | 2021-04-21 | Landmark Villa | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
3120 | 3120 | 2021-04-21 | Masonic Home For Adults | Alameda | 17 | 1 | 0 | 0 | 1 | <11 | |||
3126 | 3126 | 2021-04-21 | Pacifica Senior Living San Leandro | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
3130 | 3130 | 2021-04-21 | Rosegate | Alameda | 11 | 19 | 0 | 0 | 1 | ||||
3133 | 3133 | 2021-04-21 | St. Paul's Towers | Alameda | 20 | 1 | 0 | 0 | 1 | <11 | |||
3135 | 3135 | 2021-04-21 | Stoneridge Creek Pleasanton | Alameda | 38 | 1 | 0 | 0 | 1 | <11 | |||
3136 | 3136 | 2021-04-21 | Sunrise Of Pleasanton | Alameda | 13 | 16 | 0 | 0 | 1 | ||||
3138 | 3138 | 2021-04-21 | Watermark By The Bay, The | Alameda | 12 | 1 | 0 | 0 | 1 | <11 | |||
4149 | 4149 | 2021-04-06 | Acacia Creek - Union City | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
4150 | 4150 | 2021-04-06 | Aegis Assisted Living Of Fremont | Alameda | 12 | 15 | 0 | 0 | 1 | ||||
4152 | 4152 | 2021-04-06 | Belmont Village Albany | Alameda | 15 | 1 | 0 | 0 | 1 | <11 | |||
4155 | 4155 | 2021-04-06 | Carlton Plaza Of Fremont | Alameda | 13 | 1 | 0 | 0 | 1 | <11 | |||
4158 | 4158 | 2021-04-06 | Diana's Care Home | Alameda | 1 | 29 | 0 | 0 | 1 | <11 | |||
4159 | 4159 | 2021-04-06 | Elder Ashram | Alameda | 1 | 18 | 0 | 0 | 1 | <11 | |||
4160 | 4160 | 2021-04-06 | Fremont Hills | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
4161 | 4161 | 2021-04-06 | Fremont Rtrmt Com-Happy Lvng By Cogir/Cogir Fremon | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
4166 | 4166 | 2021-04-06 | Landmark Villa | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
4169 | 4169 | 2021-04-06 | Masonic Home For Adults | Alameda | 17 | 1 | 0 | 0 | 1 | <11 | |||
4175 | 4175 | 2021-04-06 | Pacifica Senior Living San Leandro | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
4179 | 4179 | 2021-04-06 | Rosegate | Alameda | 11 | 19 | 0 | 0 | 1 | ||||
4182 | 4182 | 2021-04-06 | St. Paul's Towers | Alameda | 20 | 1 | 0 | 0 | 1 | <11 | |||
4184 | 4184 | 2021-04-06 | Stoneridge Creek Pleasanton | Alameda | 38 | 1 | 0 | 0 | 1 | <11 | |||
4185 | 4185 | 2021-04-06 | Sunrise Of Pleasanton | Alameda | 13 | 16 | 0 | 0 | 1 | ||||
4187 | 4187 | 2021-04-06 | Watermark By The Bay, The | Alameda | 12 | 1 | 0 | 0 | 1 | <11 | |||
5196 | 5196 | 2021-03-30 | Acacia Creek - Union City | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
5197 | 5197 | 2021-03-30 | Aegis Assisted Living Of Fremont | Alameda | 12 | 15 | 0 | 0 | 1 | ||||
5199 | 5199 | 2021-03-30 | Belmont Village Albany | Alameda | 15 | 1 | 0 | 0 | 1 | <11 | |||
5202 | 5202 | 2021-03-30 | Carlton Plaza Of Fremont | Alameda | 13 | 1 | 0 | 0 | 1 | <11 | |||
5205 | 5205 | 2021-03-30 | Diana's Care Home | Alameda | 1 | 29 | 0 | 0 | 1 | <11 | |||
5206 | 5206 | 2021-03-30 | Elder Ashram | Alameda | 1 | 18 | 0 | 0 | 1 | <11 | |||
5207 | 5207 | 2021-03-30 | Fremont Hills | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
5208 | 5208 | 2021-03-30 | Fremont Rtrmt Com-Happy Lvng By Cogir/Cogir Fremon | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
5213 | 5213 | 2021-03-30 | Landmark Villa | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
5216 | 5216 | 2021-03-30 | Masonic Home For Adults | Alameda | 17 | 1 | 0 | 0 | 1 | <11 | |||
5222 | 5222 | 2021-03-30 | Pacifica Senior Living San Leandro | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
5226 | 5226 | 2021-03-30 | Rosegate | Alameda | 11 | 19 | 0 | 0 | 1 | ||||
5229 | 5229 | 2021-03-30 | St. Paul's Towers | Alameda | 20 | 1 | 0 | 0 | 1 | <11 | |||
5231 | 5231 | 2021-03-30 | Stoneridge Creek Pleasanton | Alameda | 38 | 1 | 0 | 0 | 1 | <11 | |||
5232 | 5232 | 2021-03-30 | Sunrise Of Pleasanton | Alameda | 13 | 16 | 0 | 0 | 1 | ||||
5234 | 5234 | 2021-03-30 | Watermark By The Bay, The | Alameda | 12 | 1 | 0 | 0 | 1 | <11 | |||
6243 | 6243 | 2021-03-29 | Acacia Creek - Union City | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
6244 | 6244 | 2021-03-29 | Aegis Assisted Living Of Fremont | Alameda | 12 | 15 | 0 | 0 | 1 | ||||
6246 | 6246 | 2021-03-29 | Belmont Village Albany | Alameda | 15 | 1 | 0 | 0 | 1 | <11 | |||
6249 | 6249 | 2021-03-29 | Carlton Plaza Of Fremont | Alameda | 13 | 1 | 0 | 0 | 1 | <11 | |||
6252 | 6252 | 2021-03-29 | Diana's Care Home | Alameda | 1 | 29 | 0 | 0 | 1 | <11 | |||
6253 | 6253 | 2021-03-29 | Elder Ashram | Alameda | 1 | 18 | 0 | 0 | 1 | <11 | |||
6254 | 6254 | 2021-03-29 | Fremont Hills | Alameda | 1 | 1 | 0 | 0 | 1 | <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 );