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 patients_deaths_note
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: staff_confirmed_cases, 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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
963 | 963 | 2021-06-27 | Arbol Residences Of Santa Rosa | Sonoma | 12 | 1 | 0 | 0 | 97 | <11 | |||
964 | 964 | 2021-06-27 | Brookdale Chanate | Sonoma | 11 | 1 | 0 | 0 | 97 | <11 | |||
965 | 965 | 2021-06-27 | Brookdale Paulin Creek | Sonoma | 13 | 1 | 0 | 0 | 97 | <11 | |||
973 | 973 | 2021-06-27 | Oakmont Gardens | Sonoma | 19 | 19 | 0 | 0 | 97 | ||||
976 | 976 | 2021-06-27 | Spring Lake Village | Sonoma | 26 | 1 | 0 | 0 | 97 | <11 | |||
977 | 977 | 2021-06-27 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
981 | 981 | 2021-06-27 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
982 | 982 | 2021-06-27 | Varenna At Fountaingrove | Sonoma | 14 | 0 | 0 | 0 | 97 | ||||
983 | 983 | 2021-06-27 | Villa Capri | Sonoma | 15 | 0 | 0 | 0 | 97 | ||||
1963 | 1963 | 2021-05-11 | Arbol Residences Of Santa Rosa | Sonoma | 12 | 1 | 0 | 0 | 97 | <11 | |||
1964 | 1964 | 2021-05-11 | Brookdale Chanate | Sonoma | 11 | 1 | 0 | 0 | 97 | <11 | |||
1965 | 1965 | 2021-05-11 | Brookdale Paulin Creek | Sonoma | 13 | 1 | 0 | 0 | 97 | <11 | |||
1973 | 1973 | 2021-05-11 | Oakmont Gardens | Sonoma | 19 | 19 | 0 | 0 | 97 | ||||
1976 | 1976 | 2021-05-11 | Spring Lake Village | Sonoma | 26 | 1 | 0 | 0 | 97 | <11 | |||
1977 | 1977 | 2021-05-11 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
1981 | 1981 | 2021-05-11 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
1982 | 1982 | 2021-05-11 | Varenna At Fountaingrove | Sonoma | 14 | 0 | 0 | 0 | 97 | ||||
1983 | 1983 | 2021-05-11 | Villa Capri | Sonoma | 15 | 0 | 0 | 0 | 97 | ||||
3008 | 3008 | 2021-04-27 | Arbol Residences Of Santa Rosa | Sonoma | 12 | 1 | 0 | 0 | 97 | <11 | |||
3009 | 3009 | 2021-04-27 | Brookdale Chanate | Sonoma | 11 | 1 | 0 | 0 | 97 | <11 | |||
3010 | 3010 | 2021-04-27 | Brookdale Paulin Creek | Sonoma | 13 | 1 | 0 | 0 | 97 | <11 | |||
3018 | 3018 | 2021-04-27 | Oakmont Gardens | Sonoma | 19 | 19 | 0 | 0 | 97 | ||||
3021 | 3021 | 2021-04-27 | Spring Lake Village | Sonoma | 26 | 1 | 0 | 0 | 97 | <11 | |||
3022 | 3022 | 2021-04-27 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
3026 | 3026 | 2021-04-27 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
3027 | 3027 | 2021-04-27 | Varenna At Fountaingrove | Sonoma | 14 | 0 | 0 | 0 | 97 | ||||
3028 | 3028 | 2021-04-27 | Villa Capri | Sonoma | 15 | 0 | 0 | 0 | 97 | ||||
4057 | 4057 | 2021-04-21 | Arbol Residences Of Santa Rosa | Sonoma | 12 | 1 | 0 | 0 | 97 | <11 | |||
4058 | 4058 | 2021-04-21 | Brookdale Chanate | Sonoma | 11 | 1 | 0 | 0 | 97 | <11 | |||
4059 | 4059 | 2021-04-21 | Brookdale Paulin Creek | Sonoma | 13 | 1 | 0 | 0 | 97 | <11 | |||
4067 | 4067 | 2021-04-21 | Oakmont Gardens | Sonoma | 19 | 19 | 0 | 0 | 97 | ||||
4070 | 4070 | 2021-04-21 | Spring Lake Village | Sonoma | 26 | 1 | 0 | 0 | 97 | <11 | |||
4071 | 4071 | 2021-04-21 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
4075 | 4075 | 2021-04-21 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
4076 | 4076 | 2021-04-21 | Varenna At Fountaingrove | Sonoma | 14 | 0 | 0 | 0 | 97 | ||||
4077 | 4077 | 2021-04-21 | Villa Capri | Sonoma | 15 | 0 | 0 | 0 | 97 | ||||
5104 | 5104 | 2021-04-06 | Arbol Residences Of Santa Rosa | Sonoma | 12 | 1 | 0 | 0 | 97 | <11 | |||
5105 | 5105 | 2021-04-06 | Brookdale Chanate | Sonoma | 11 | 1 | 0 | 0 | 97 | <11 | |||
5106 | 5106 | 2021-04-06 | Brookdale Paulin Creek | Sonoma | 13 | 1 | 0 | 0 | 97 | <11 | |||
5114 | 5114 | 2021-04-06 | Oakmont Gardens | Sonoma | 19 | 19 | 0 | 0 | 97 | ||||
5117 | 5117 | 2021-04-06 | Spring Lake Village | Sonoma | 26 | 1 | 0 | 0 | 97 | <11 | |||
5118 | 5118 | 2021-04-06 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
5122 | 5122 | 2021-04-06 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
5123 | 5123 | 2021-04-06 | Varenna At Fountaingrove | Sonoma | 14 | 0 | 0 | 0 | 97 | ||||
5124 | 5124 | 2021-04-06 | Villa Capri | Sonoma | 15 | 0 | 0 | 0 | 97 | ||||
6151 | 6151 | 2021-03-30 | Arbol Residences Of Santa Rosa | Sonoma | 12 | 1 | 0 | 0 | 97 | <11 | |||
6152 | 6152 | 2021-03-30 | Brookdale Chanate | Sonoma | 11 | 1 | 0 | 0 | 97 | <11 | |||
6153 | 6153 | 2021-03-30 | Brookdale Paulin Creek | Sonoma | 13 | 1 | 0 | 0 | 97 | <11 | |||
6161 | 6161 | 2021-03-30 | Oakmont Gardens | Sonoma | 19 | 19 | 0 | 0 | 97 | ||||
6164 | 6164 | 2021-03-30 | Spring Lake Village | Sonoma | 26 | 1 | 0 | 0 | 97 | <11 | |||
6165 | 6165 | 2021-03-30 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
6169 | 6169 | 2021-03-30 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
6170 | 6170 | 2021-03-30 | Varenna At Fountaingrove | Sonoma | 14 | 0 | 0 | 0 | 97 | ||||
6171 | 6171 | 2021-03-30 | Villa Capri | Sonoma | 15 | 0 | 0 | 0 | 97 | ||||
7198 | 7198 | 2021-03-29 | Arbol Residences Of Santa Rosa | Sonoma | 12 | 1 | 0 | 0 | 97 | <11 | |||
7199 | 7199 | 2021-03-29 | Brookdale Chanate | Sonoma | 11 | 1 | 0 | 0 | 97 | <11 | |||
7200 | 7200 | 2021-03-29 | Brookdale Paulin Creek | Sonoma | 13 | 1 | 0 | 0 | 97 | <11 | |||
7208 | 7208 | 2021-03-29 | Oakmont Gardens | Sonoma | 19 | 19 | 0 | 0 | 97 | ||||
7211 | 7211 | 2021-03-29 | Spring Lake Village | Sonoma | 26 | 1 | 0 | 0 | 97 | <11 | |||
7212 | 7212 | 2021-03-29 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
7216 | 7216 | 2021-03-29 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
7217 | 7217 | 2021-03-29 | Varenna At Fountaingrove | Sonoma | 14 | 0 | 0 | 0 | 97 | ||||
7218 | 7218 | 2021-03-29 | Villa Capri | Sonoma | 15 | 0 | 0 | 0 | 97 | ||||
8245 | 8245 | 2021-03-25 | Arbol Residences Of Santa Rosa | Sonoma | 12 | 1 | 0 | 0 | 97 | <11 | |||
8246 | 8246 | 2021-03-25 | Brookdale Chanate | Sonoma | 11 | 1 | 0 | 0 | 97 | <11 | |||
8247 | 8247 | 2021-03-25 | Brookdale Paulin Creek | Sonoma | 13 | 1 | 0 | 0 | 97 | <11 | |||
8255 | 8255 | 2021-03-25 | Oakmont Gardens | Sonoma | 19 | 19 | 0 | 0 | 97 | ||||
8258 | 8258 | 2021-03-25 | Spring Lake Village | Sonoma | 26 | 1 | 0 | 0 | 97 | <11 | |||
8259 | 8259 | 2021-03-25 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
8263 | 8263 | 2021-03-25 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
8264 | 8264 | 2021-03-25 | Varenna At Fountaingrove | Sonoma | 14 | 0 | 0 | 0 | 97 | ||||
8265 | 8265 | 2021-03-25 | Villa Capri | Sonoma | 15 | 0 | 0 | 0 | 97 | ||||
9292 | 9292 | 2021-03-24 | Arbol Residences Of Santa Rosa | Sonoma | 12 | 1 | 0 | 0 | 97 | <11 | |||
9293 | 9293 | 2021-03-24 | Brookdale Chanate | Sonoma | 11 | 1 | 0 | 0 | 97 | <11 | |||
9294 | 9294 | 2021-03-24 | Brookdale Paulin Creek | Sonoma | 13 | 1 | 0 | 0 | 97 | <11 | |||
9302 | 9302 | 2021-03-24 | Oakmont Gardens | Sonoma | 19 | 19 | 0 | 0 | 97 | ||||
9305 | 9305 | 2021-03-24 | Spring Lake Village | Sonoma | 26 | 1 | 0 | 0 | 97 | <11 | |||
9306 | 9306 | 2021-03-24 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
9310 | 9310 | 2021-03-24 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
9311 | 9311 | 2021-03-24 | Varenna At Fountaingrove | Sonoma | 14 | 0 | 0 | 0 | 97 | ||||
9312 | 9312 | 2021-03-24 | Villa Capri | Sonoma | 15 | 0 | 0 | 0 | 97 | ||||
10339 | 10339 | 2021-03-23 | Arbol Residences Of Santa Rosa | Sonoma | 12 | 1 | 0 | 0 | 97 | <11 | |||
10340 | 10340 | 2021-03-23 | Brookdale Chanate | Sonoma | 11 | 1 | 0 | 0 | 97 | <11 | |||
10341 | 10341 | 2021-03-23 | Brookdale Paulin Creek | Sonoma | 13 | 1 | 0 | 0 | 97 | <11 | |||
10349 | 10349 | 2021-03-23 | Oakmont Gardens | Sonoma | 19 | 19 | 0 | 0 | 97 | ||||
10352 | 10352 | 2021-03-23 | Spring Lake Village | Sonoma | 26 | 1 | 0 | 0 | 97 | <11 | |||
10353 | 10353 | 2021-03-23 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
10357 | 10357 | 2021-03-23 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
10358 | 10358 | 2021-03-23 | Varenna At Fountaingrove | Sonoma | 14 | 0 | 0 | 0 | 97 | ||||
10359 | 10359 | 2021-03-23 | Villa Capri | Sonoma | 15 | 0 | 0 | 0 | 97 | ||||
11385 | 11385 | 2021-03-22 | Arbol Residences Of Santa Rosa | Sonoma | 12 | 1 | 0 | 0 | 97 | <11 | |||
11386 | 11386 | 2021-03-22 | Brookdale Chanate | Sonoma | 11 | 1 | 0 | 0 | 97 | <11 | |||
11387 | 11387 | 2021-03-22 | Brookdale Paulin Creek | Sonoma | 13 | 1 | 0 | 0 | 97 | <11 | |||
11395 | 11395 | 2021-03-22 | Oakmont Gardens | Sonoma | 19 | 19 | 0 | 0 | 97 | ||||
11398 | 11398 | 2021-03-22 | Spring Lake Village | Sonoma | 26 | 1 | 0 | 0 | 97 | <11 | |||
11399 | 11399 | 2021-03-22 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
11403 | 11403 | 2021-03-22 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
11404 | 11404 | 2021-03-22 | Varenna At Fountaingrove | Sonoma | 14 | 0 | 0 | 0 | 97 | ||||
11405 | 11405 | 2021-03-22 | Villa Capri | Sonoma | 15 | 0 | 0 | 0 | 97 | ||||
12431 | 12431 | 2021-03-19 | Arbol Residences Of Santa Rosa | Sonoma | 12 | 1 | 0 | 0 | 97 | <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 );