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,213 rows where county = "Sonoma" sorted by staff_confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: name, patients_deaths, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
968 | 968 | 2021-06-27 | Hanna House Ridley | Sonoma | 1 | 25 | 0 | 1 | 97 | <11 | <11 | ||
975 | 975 | 2021-06-27 | Redwood Retreat | Sonoma | 1 | 13 | 0 | 1 | 97 | <11 | <11 | ||
977 | 977 | 2021-06-27 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
978 | 978 | 2021-06-27 | St. Francis Assisted Living 3 | Sonoma | 1 | 20 | 0 | 1 | 97 | <11 | <11 | ||
980 | 980 | 2021-06-27 | Sunrise Villa Santa Rosa | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
984 | 984 | 2021-06-27 | Wine Country Senior Living, Inc. | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
1968 | 1968 | 2021-05-11 | Hanna House Ridley | Sonoma | 1 | 25 | 0 | 1 | 97 | <11 | <11 | ||
1975 | 1975 | 2021-05-11 | Redwood Retreat | Sonoma | 1 | 13 | 0 | 1 | 97 | <11 | <11 | ||
1977 | 1977 | 2021-05-11 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
1978 | 1978 | 2021-05-11 | St. Francis Assisted Living 3 | Sonoma | 1 | 20 | 0 | 1 | 97 | <11 | <11 | ||
1980 | 1980 | 2021-05-11 | Sunrise Villa Santa Rosa | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
1984 | 1984 | 2021-05-11 | Wine Country Senior Living, Inc. | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
3013 | 3013 | 2021-04-27 | Hanna House Ridley | Sonoma | 1 | 25 | 0 | 1 | 97 | <11 | <11 | ||
3020 | 3020 | 2021-04-27 | Redwood Retreat | Sonoma | 1 | 13 | 0 | 1 | 97 | <11 | <11 | ||
3022 | 3022 | 2021-04-27 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
3023 | 3023 | 2021-04-27 | St. Francis Assisted Living 3 | Sonoma | 1 | 20 | 0 | 1 | 97 | <11 | <11 | ||
3025 | 3025 | 2021-04-27 | Sunrise Villa Santa Rosa | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
3029 | 3029 | 2021-04-27 | Wine Country Senior Living, Inc. | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
4062 | 4062 | 2021-04-21 | Hanna House Ridley | Sonoma | 1 | 25 | 0 | 1 | 97 | <11 | <11 | ||
4069 | 4069 | 2021-04-21 | Redwood Retreat | Sonoma | 1 | 13 | 0 | 1 | 97 | <11 | <11 | ||
4071 | 4071 | 2021-04-21 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
4072 | 4072 | 2021-04-21 | St. Francis Assisted Living 3 | Sonoma | 1 | 20 | 0 | 1 | 97 | <11 | <11 | ||
4074 | 4074 | 2021-04-21 | Sunrise Villa Santa Rosa | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
4078 | 4078 | 2021-04-21 | Wine Country Senior Living, Inc. | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
5109 | 5109 | 2021-04-06 | Hanna House Ridley | Sonoma | 1 | 25 | 0 | 1 | 97 | <11 | <11 | ||
5116 | 5116 | 2021-04-06 | Redwood Retreat | Sonoma | 1 | 13 | 0 | 1 | 97 | <11 | <11 | ||
5118 | 5118 | 2021-04-06 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
5119 | 5119 | 2021-04-06 | St. Francis Assisted Living 3 | Sonoma | 1 | 20 | 0 | 1 | 97 | <11 | <11 | ||
5121 | 5121 | 2021-04-06 | Sunrise Villa Santa Rosa | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
5125 | 5125 | 2021-04-06 | Wine Country Senior Living, Inc. | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
6156 | 6156 | 2021-03-30 | Hanna House Ridley | Sonoma | 1 | 25 | 0 | 1 | 97 | <11 | <11 | ||
6163 | 6163 | 2021-03-30 | Redwood Retreat | Sonoma | 1 | 13 | 0 | 1 | 97 | <11 | <11 | ||
6165 | 6165 | 2021-03-30 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
6166 | 6166 | 2021-03-30 | St. Francis Assisted Living 3 | Sonoma | 1 | 20 | 0 | 1 | 97 | <11 | <11 | ||
6168 | 6168 | 2021-03-30 | Sunrise Villa Santa Rosa | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
6172 | 6172 | 2021-03-30 | Wine Country Senior Living, Inc. | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
7203 | 7203 | 2021-03-29 | Hanna House Ridley | Sonoma | 1 | 25 | 0 | 1 | 97 | <11 | <11 | ||
7210 | 7210 | 2021-03-29 | Redwood Retreat | Sonoma | 1 | 13 | 0 | 1 | 97 | <11 | <11 | ||
7212 | 7212 | 2021-03-29 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
7213 | 7213 | 2021-03-29 | St. Francis Assisted Living 3 | Sonoma | 1 | 20 | 0 | 1 | 97 | <11 | <11 | ||
7215 | 7215 | 2021-03-29 | Sunrise Villa Santa Rosa | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
7219 | 7219 | 2021-03-29 | Wine Country Senior Living, Inc. | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
8249 | 8249 | 2021-03-25 | Fountaingrove Lodge | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
8250 | 8250 | 2021-03-25 | Hanna House Ridley | Sonoma | 1 | 25 | 0 | 1 | 97 | <11 | <11 | ||
8257 | 8257 | 2021-03-25 | Redwood Retreat | Sonoma | 1 | 13 | 0 | 1 | 97 | <11 | <11 | ||
8259 | 8259 | 2021-03-25 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
8260 | 8260 | 2021-03-25 | St. Francis Assisted Living 3 | Sonoma | 1 | 20 | 0 | 1 | 97 | <11 | <11 | ||
8262 | 8262 | 2021-03-25 | Sunrise Villa Santa Rosa | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
8266 | 8266 | 2021-03-25 | Wine Country Senior Living, Inc. | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
9296 | 9296 | 2021-03-24 | Fountaingrove Lodge | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
9297 | 9297 | 2021-03-24 | Hanna House Ridley | Sonoma | 1 | 25 | 0 | 1 | 97 | <11 | <11 | ||
9304 | 9304 | 2021-03-24 | Redwood Retreat | Sonoma | 1 | 13 | 0 | 1 | 97 | <11 | <11 | ||
9306 | 9306 | 2021-03-24 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
9307 | 9307 | 2021-03-24 | St. Francis Assisted Living 3 | Sonoma | 1 | 20 | 0 | 1 | 97 | <11 | <11 | ||
9309 | 9309 | 2021-03-24 | Sunrise Villa Santa Rosa | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
9313 | 9313 | 2021-03-24 | Wine Country Senior Living, Inc. | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
10343 | 10343 | 2021-03-23 | Fountaingrove Lodge | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
10344 | 10344 | 2021-03-23 | Hanna House Ridley | Sonoma | 1 | 25 | 0 | 1 | 97 | <11 | <11 | ||
10351 | 10351 | 2021-03-23 | Redwood Retreat | Sonoma | 1 | 13 | 0 | 1 | 97 | <11 | <11 | ||
10353 | 10353 | 2021-03-23 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
10354 | 10354 | 2021-03-23 | St. Francis Assisted Living 3 | Sonoma | 1 | 20 | 0 | 1 | 97 | <11 | <11 | ||
10356 | 10356 | 2021-03-23 | Sunrise Villa Santa Rosa | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
10360 | 10360 | 2021-03-23 | Wine Country Senior Living, Inc. | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
11389 | 11389 | 2021-03-22 | Fountaingrove Lodge | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
11390 | 11390 | 2021-03-22 | Hanna House Ridley | Sonoma | 1 | 25 | 0 | 1 | 97 | <11 | <11 | ||
11397 | 11397 | 2021-03-22 | Redwood Retreat | Sonoma | 1 | 13 | 0 | 1 | 97 | <11 | <11 | ||
11399 | 11399 | 2021-03-22 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
11400 | 11400 | 2021-03-22 | St. Francis Assisted Living 3 | Sonoma | 1 | 20 | 0 | 1 | 97 | <11 | <11 | ||
11402 | 11402 | 2021-03-22 | Sunrise Villa Santa Rosa | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
11406 | 11406 | 2021-03-22 | Wine Country Senior Living, Inc. | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
12435 | 12435 | 2021-03-19 | Fountaingrove Lodge | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
12436 | 12436 | 2021-03-19 | Hanna House Ridley | Sonoma | 1 | 25 | 0 | 1 | 97 | <11 | <11 | ||
12443 | 12443 | 2021-03-19 | Redwood Retreat | Sonoma | 1 | 13 | 0 | 1 | 97 | <11 | <11 | ||
12445 | 12445 | 2021-03-19 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
12446 | 12446 | 2021-03-19 | St. Francis Assisted Living 3 | Sonoma | 1 | 20 | 0 | 1 | 97 | <11 | <11 | ||
12448 | 12448 | 2021-03-19 | Sunrise Villa Santa Rosa | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
12452 | 12452 | 2021-03-19 | Wine Country Senior Living, Inc. | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
13480 | 13480 | 2021-03-18 | Fountaingrove Lodge | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
13481 | 13481 | 2021-03-18 | Hanna House Ridley | Sonoma | 1 | 25 | 0 | 1 | 97 | <11 | <11 | ||
13488 | 13488 | 2021-03-18 | Redwood Retreat | Sonoma | 1 | 13 | 0 | 1 | 97 | <11 | <11 | ||
13490 | 13490 | 2021-03-18 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
13491 | 13491 | 2021-03-18 | St. Francis Assisted Living 3 | Sonoma | 1 | 20 | 0 | 1 | 97 | <11 | <11 | ||
13493 | 13493 | 2021-03-18 | Sunrise Villa Santa Rosa | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
13497 | 13497 | 2021-03-18 | Wine Country Senior Living, Inc. | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
14524 | 14524 | 2021-03-17 | Fountaingrove Lodge | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
14525 | 14525 | 2021-03-17 | Hanna House Ridley | Sonoma | 1 | 25 | 0 | 1 | 97 | <11 | <11 | ||
14532 | 14532 | 2021-03-17 | Redwood Retreat | Sonoma | 1 | 13 | 0 | 1 | 97 | <11 | <11 | ||
14534 | 14534 | 2021-03-17 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
14535 | 14535 | 2021-03-17 | St. Francis Assisted Living 3 | Sonoma | 1 | 20 | 0 | 1 | 97 | <11 | <11 | ||
14537 | 14537 | 2021-03-17 | Sunrise Villa Santa Rosa | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
14541 | 14541 | 2021-03-17 | Wine Country Senior Living, Inc. | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
15568 | 15568 | 2021-03-16 | Fountaingrove Lodge | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
15569 | 15569 | 2021-03-16 | Hanna House Ridley | Sonoma | 1 | 25 | 0 | 1 | 97 | <11 | <11 | ||
15576 | 15576 | 2021-03-16 | Redwood Retreat | Sonoma | 1 | 13 | 0 | 1 | 97 | <11 | <11 | ||
15578 | 15578 | 2021-03-16 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
15579 | 15579 | 2021-03-16 | St. Francis Assisted Living 3 | Sonoma | 1 | 20 | 0 | 1 | 97 | <11 | <11 | ||
15581 | 15581 | 2021-03-16 | Sunrise Villa Santa Rosa | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
15585 | 15585 | 2021-03-16 | Wine Country Senior Living, Inc. | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
16612 | 16612 | 2021-03-15 | Fountaingrove Lodge | Sonoma | 1 | 1 | 0 | 1 | 97 | <11 | <11 | <11 | |
16613 | 16613 | 2021-03-15 | Hanna House Ridley | Sonoma | 1 | 25 | 0 | 1 | 97 | <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 );