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,221 rows where patients_deaths = 1 and staff_confirmed_cases = 17 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: fips, staff_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6 | 6 | 2021-06-27 | Carefield Pleasanton | Alameda | 17 | 24 | 0 | 1 | 1 | <11 | |||
58 | 58 | 2021-06-27 | Byron Park | Contra Costa | 17 | 14 | 0 | 1 | 13 | <11 | |||
73 | 73 | 2021-06-27 | Sunrise Assisted Living Of Walnut Creek | Contra Costa | 17 | 25 | 0 | 1 | 13 | <11 | |||
104 | 104 | 2021-06-27 | Westhaven Assisted Living | Glenn | 17 | 33 | 0 | 1 | 21 | <11 | |||
171 | 171 | 2021-06-27 | Brookdale Walnut | Los Angeles | 17 | 38 | 0 | 1 | 37 | <11 | |||
183 | 183 | 2021-06-27 | Chateau Long Beach | Los Angeles | 17 | 55 | 0 | 1 | 37 | <11 | |||
240 | 240 | 2021-06-27 | Inn At The Park Ventura | Los Angeles | 17 | 67 | 0 | 1 | 37 | <11 | |||
424 | 424 | 2021-06-27 | Brookdale Irvine | Orange | 17 | 1 | 0 | 1 | 59 | <11 | <11 | ||
493 | 493 | 2021-06-27 | Sunrise Assisted Living Of Fullerton | Orange | 17 | 23 | 0 | 1 | 59 | <11 | |||
498 | 498 | 2021-06-27 | Sunrise Villa Bradford | Orange | 17 | 13 | 0 | 1 | 59 | <11 | |||
531 | 531 | 2021-06-27 | Brookdale Murrieta | Riverside | 17 | 27 | 0 | 1 | 65 | <11 | |||
557 | 557 | 2021-06-27 | Legend Gardens | Riverside | 17 | 13 | 0 | 1 | 65 | <11 | |||
629 | 629 | 2021-06-27 | Sun Oak Assisted Living | Sacramento | 17 | 22 | 0 | 1 | 67 | <11 | |||
732 | 732 | 2021-06-27 | Monarch Cottages La Jolla | San Diego | 17 | 17 | 0 | 1 | 73 | <11 | |||
743 | 743 | 2021-06-27 | Oakmont Of Pacific Beach | San Diego | 17 | 27 | 0 | 1 | 73 | <11 | |||
780 | 780 | 2021-06-27 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
845 | 845 | 2021-06-27 | Hopkins Manor Pacific Corporation | San Mateo | 17 | 32 | 0 | 1 | 81 | <11 | |||
956 | 956 | 2021-06-27 | Parkrose Gardens Of Fairfield | Solano | 17 | 39 | 1 | 1 | 95 | <11 | <11 | ||
966 | 966 | 2021-06-27 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
1035 | 1035 | 2021-06-27 | Pacifica Senior Living Oxnard | Ventura | 17 | 26 | 0 | 1 | 111 | <11 | |||
1047 | 1047 | 2021-06-27 | Wellness Care Senior Living | Ventura | 17 | 29 | 0 | 1 | 111 | <11 | |||
1060 | 1060 | 2021-05-11 | Carefield Pleasanton | Alameda | 17 | 24 | 0 | 1 | 1 | <11 | |||
1111 | 1111 | 2021-05-11 | Byron Park | Contra Costa | 17 | 14 | 0 | 1 | 13 | <11 | |||
1126 | 1126 | 2021-05-11 | Sunrise Assisted Living Of Walnut Creek | Contra Costa | 17 | 25 | 0 | 1 | 13 | <11 | |||
1157 | 1157 | 2021-05-11 | Westhaven Assisted Living | Glenn | 17 | 33 | 0 | 1 | 21 | <11 | |||
1218 | 1218 | 2021-05-11 | Brookdale Walnut | Los Angeles | 17 | 38 | 0 | 1 | 37 | <11 | |||
1228 | 1228 | 2021-05-11 | Chateau Long Beach | Los Angeles | 17 | 55 | 0 | 1 | 37 | <11 | |||
1279 | 1279 | 2021-05-11 | Inn At The Park Ventura | Los Angeles | 17 | 67 | 0 | 1 | 37 | <11 | |||
1446 | 1446 | 2021-05-11 | Brookdale Irvine | Orange | 17 | 1 | 0 | 1 | 59 | <11 | <11 | ||
1517 | 1517 | 2021-05-11 | Sunrise Villa Bradford | Orange | 17 | 13 | 0 | 1 | 59 | <11 | |||
1550 | 1550 | 2021-05-11 | Brookdale Murrieta | Riverside | 17 | 27 | 0 | 1 | 65 | <11 | |||
1575 | 1575 | 2021-05-11 | Legend Gardens | Riverside | 17 | 13 | 0 | 1 | 65 | <11 | |||
1643 | 1643 | 2021-05-11 | Sun Oak Assisted Living | Sacramento | 17 | 22 | 0 | 1 | 67 | <11 | |||
1740 | 1740 | 2021-05-11 | Monarch Cottages La Jolla | San Diego | 17 | 17 | 0 | 1 | 73 | <11 | |||
1750 | 1750 | 2021-05-11 | Oakmont Of Pacific Beach | San Diego | 17 | 27 | 0 | 1 | 73 | <11 | |||
1787 | 1787 | 2021-05-11 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
1848 | 1848 | 2021-05-11 | Hopkins Manor Pacific Corporation | San Mateo | 17 | 32 | 0 | 1 | 81 | <11 | |||
1956 | 1956 | 2021-05-11 | Parkrose Gardens Of Fairfield | Solano | 17 | 39 | 1 | 1 | 95 | <11 | <11 | ||
1966 | 1966 | 2021-05-11 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
2032 | 2032 | 2021-05-11 | Pacifica Senior Living Oxnard | Ventura | 17 | 26 | 0 | 1 | 111 | <11 | |||
2043 | 2043 | 2021-05-11 | Wellness Care Senior Living | Ventura | 17 | 29 | 0 | 1 | 111 | <11 | |||
2056 | 2056 | 2021-04-27 | Carefield Pleasanton | Alameda | 17 | 24 | 0 | 1 | 1 | <11 | |||
2109 | 2109 | 2021-04-27 | Byron Park | Contra Costa | 17 | 14 | 0 | 1 | 13 | <11 | |||
2123 | 2123 | 2021-04-27 | Sunrise Assisted Living Of Walnut Creek | Contra Costa | 17 | 25 | 0 | 1 | 13 | <11 | |||
2154 | 2154 | 2021-04-27 | Westhaven Assisted Living | Glenn | 17 | 33 | 0 | 1 | 21 | <11 | |||
2221 | 2221 | 2021-04-27 | Brookdale Walnut | Los Angeles | 17 | 38 | 0 | 1 | 37 | <11 | |||
2233 | 2233 | 2021-04-27 | Chateau Long Beach | Los Angeles | 17 | 55 | 0 | 1 | 37 | <11 | |||
2290 | 2290 | 2021-04-27 | Inn At The Park Ventura | Los Angeles | 17 | 67 | 0 | 1 | 37 | <11 | |||
2440 | 2440 | 2021-04-27 | Cottages Of Carmel | Monterey | 17 | 21 | 0 | 1 | 53 | <11 | |||
2473 | 2473 | 2021-04-27 | Brookdale Irvine | Orange | 17 | 1 | 0 | 1 | 59 | <11 | <11 | ||
2547 | 2547 | 2021-04-27 | Sunrise Villa Bradford | Orange | 17 | 13 | 0 | 1 | 59 | <11 | |||
2580 | 2580 | 2021-04-27 | Brookdale Murrieta | Riverside | 17 | 27 | 0 | 1 | 65 | <11 | |||
2606 | 2606 | 2021-04-27 | Legend Gardens | Riverside | 17 | 13 | 0 | 1 | 65 | <11 | |||
2678 | 2678 | 2021-04-27 | Sun Oak Assisted Living | Sacramento | 17 | 22 | 0 | 1 | 67 | <11 | |||
2779 | 2779 | 2021-04-27 | Monarch Cottages La Jolla | San Diego | 17 | 17 | 0 | 1 | 73 | <11 | |||
2790 | 2790 | 2021-04-27 | Oakmont Of Pacific Beach | San Diego | 17 | 27 | 0 | 1 | 73 | <11 | |||
2827 | 2827 | 2021-04-27 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
2892 | 2892 | 2021-04-27 | Hopkins Manor Pacific Corporation | San Mateo | 17 | 32 | 0 | 1 | 81 | <11 | |||
3001 | 3001 | 2021-04-27 | Parkrose Gardens Of Fairfield | Solano | 17 | 39 | 1 | 1 | 95 | <11 | <11 | ||
3011 | 3011 | 2021-04-27 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
3080 | 3080 | 2021-04-27 | Pacifica Senior Living Oxnard | Ventura | 17 | 26 | 0 | 1 | 111 | <11 | |||
3092 | 3092 | 2021-04-27 | Wellness Care Senior Living | Ventura | 17 | 29 | 0 | 1 | 111 | <11 | |||
3105 | 3105 | 2021-04-21 | Carefield Pleasanton | Alameda | 17 | 24 | 0 | 1 | 1 | <11 | |||
3158 | 3158 | 2021-04-21 | Byron Park | Contra Costa | 17 | 14 | 0 | 1 | 13 | <11 | |||
3172 | 3172 | 2021-04-21 | Sunrise Assisted Living Of Walnut Creek | Contra Costa | 17 | 25 | 0 | 1 | 13 | <11 | |||
3203 | 3203 | 2021-04-21 | Westhaven Assisted Living | Glenn | 17 | 33 | 0 | 1 | 21 | <11 | |||
3270 | 3270 | 2021-04-21 | Brookdale Walnut | Los Angeles | 17 | 38 | 0 | 1 | 37 | <11 | |||
3282 | 3282 | 2021-04-21 | Chateau Long Beach | Los Angeles | 17 | 55 | 0 | 1 | 37 | <11 | |||
3339 | 3339 | 2021-04-21 | Inn At The Park Ventura | Los Angeles | 17 | 67 | 0 | 1 | 37 | <11 | |||
3489 | 3489 | 2021-04-21 | Cottages Of Carmel | Monterey | 17 | 21 | 0 | 1 | 53 | <11 | |||
3522 | 3522 | 2021-04-21 | Brookdale Irvine | Orange | 17 | 1 | 0 | 1 | 59 | <11 | <11 | ||
3596 | 3596 | 2021-04-21 | Sunrise Villa Bradford | Orange | 17 | 13 | 0 | 1 | 59 | <11 | |||
3629 | 3629 | 2021-04-21 | Brookdale Murrieta | Riverside | 17 | 27 | 0 | 1 | 65 | <11 | |||
3655 | 3655 | 2021-04-21 | Legend Gardens | Riverside | 17 | 13 | 0 | 1 | 65 | <11 | |||
3727 | 3727 | 2021-04-21 | Sun Oak Assisted Living | Sacramento | 17 | 22 | 0 | 1 | 67 | <11 | |||
3828 | 3828 | 2021-04-21 | Monarch Cottages La Jolla | San Diego | 17 | 17 | 0 | 1 | 73 | <11 | |||
3839 | 3839 | 2021-04-21 | Oakmont Of Pacific Beach | San Diego | 17 | 27 | 0 | 1 | 73 | <11 | |||
3876 | 3876 | 2021-04-21 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <11 | |||
3941 | 3941 | 2021-04-21 | Hopkins Manor Pacific Corporation | San Mateo | 17 | 32 | 0 | 1 | 81 | <11 | |||
4050 | 4050 | 2021-04-21 | Parkrose Gardens Of Fairfield | Solano | 17 | 39 | 1 | 1 | 95 | <11 | <11 | ||
4060 | 4060 | 2021-04-21 | Brookdale Windsor | Sonoma | 17 | 17 | 0 | 1 | 97 | <11 | |||
4129 | 4129 | 2021-04-21 | Pacifica Senior Living Oxnard | Ventura | 17 | 26 | 0 | 1 | 111 | <11 | |||
4141 | 4141 | 2021-04-21 | Wellness Care Senior Living | Ventura | 17 | 29 | 0 | 1 | 111 | <11 | |||
4154 | 4154 | 2021-04-06 | Carefield Pleasanton | Alameda | 17 | 24 | 0 | 1 | 1 | <11 | |||
4221 | 4221 | 2021-04-06 | Sunrise Assisted Living Of Walnut Creek | Contra Costa | 17 | 25 | 0 | 1 | 13 | <11 | |||
4252 | 4252 | 2021-04-06 | Westhaven Assisted Living | Glenn | 17 | 33 | 0 | 1 | 21 | <11 | |||
4267 | 4267 | 2021-04-06 | Rosewood Retirement Community | Kern | 17 | 1 | 0 | 1 | 29 | <11 | <11 | ||
4319 | 4319 | 2021-04-06 | Brookdale Walnut | Los Angeles | 17 | 38 | 0 | 1 | 37 | <11 | |||
4331 | 4331 | 2021-04-06 | Chateau Long Beach | Los Angeles | 17 | 55 | 0 | 1 | 37 | <11 | |||
4388 | 4388 | 2021-04-06 | Inn At The Park Ventura | Los Angeles | 17 | 67 | 0 | 1 | 37 | <11 | |||
4537 | 4537 | 2021-04-06 | Cottages Of Carmel | Monterey | 17 | 21 | 0 | 1 | 53 | <11 | |||
4570 | 4570 | 2021-04-06 | Brookdale Irvine | Orange | 17 | 1 | 0 | 1 | 59 | <11 | <11 | ||
4638 | 4638 | 2021-04-06 | Sunrise Assisted Living At Tustin | Orange | 17 | 1 | 0 | 1 | 59 | <11 | <11 | ||
4644 | 4644 | 2021-04-06 | Sunrise Villa Bradford | Orange | 17 | 13 | 0 | 1 | 59 | <11 | |||
4677 | 4677 | 2021-04-06 | Brookdale Murrieta | Riverside | 17 | 27 | 0 | 1 | 65 | <11 | |||
4703 | 4703 | 2021-04-06 | Legend Gardens | Riverside | 17 | 13 | 0 | 1 | 65 | <11 | |||
4774 | 4774 | 2021-04-06 | Sun Oak Assisted Living | Sacramento | 17 | 22 | 0 | 1 | 67 | <11 | |||
4875 | 4875 | 2021-04-06 | Monarch Cottages La Jolla | San Diego | 17 | 17 | 0 | 1 | 73 | <11 | |||
4886 | 4886 | 2021-04-06 | Oakmont Of Pacific Beach | San Diego | 17 | 27 | 0 | 1 | 73 | <11 | |||
4923 | 4923 | 2021-04-06 | Buena Vista Manor House | San Francisco | 17 | 25 | 0 | 1 | 75 | <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 );