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)
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12432 | 12432 | 2021-03-19 | Brookdale Chanate | Sonoma | 11 | 1 | 0 | 0 | 97 | <11 | |||
12433 | 12433 | 2021-03-19 | Brookdale Paulin Creek | Sonoma | 13 | 1 | 0 | 0 | 97 | <11 | |||
12441 | 12441 | 2021-03-19 | Oakmont Gardens | Sonoma | 19 | 19 | 0 | 0 | 97 | ||||
12444 | 12444 | 2021-03-19 | Spring Lake Village | Sonoma | 26 | 1 | 0 | 0 | 97 | <11 | |||
12445 | 12445 | 2021-03-19 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
12449 | 12449 | 2021-03-19 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
12450 | 12450 | 2021-03-19 | Varenna At Fountaingrove | Sonoma | 14 | 0 | 0 | 0 | 97 | ||||
12451 | 12451 | 2021-03-19 | Villa Capri | Sonoma | 15 | 0 | 0 | 0 | 97 | ||||
13476 | 13476 | 2021-03-18 | Arbol Residences Of Santa Rosa | Sonoma | 12 | 1 | 0 | 0 | 97 | <11 | |||
13477 | 13477 | 2021-03-18 | Brookdale Chanate | Sonoma | 11 | 1 | 0 | 0 | 97 | <11 | |||
13478 | 13478 | 2021-03-18 | Brookdale Paulin Creek | Sonoma | 13 | 1 | 0 | 0 | 97 | <11 | |||
13486 | 13486 | 2021-03-18 | Oakmont Gardens | Sonoma | 19 | 19 | 0 | 0 | 97 | ||||
13489 | 13489 | 2021-03-18 | Spring Lake Village | Sonoma | 26 | 1 | 0 | 0 | 97 | <11 | |||
13490 | 13490 | 2021-03-18 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
13494 | 13494 | 2021-03-18 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
13495 | 13495 | 2021-03-18 | Varenna At Fountaingrove | Sonoma | 14 | 0 | 0 | 0 | 97 | ||||
13496 | 13496 | 2021-03-18 | Villa Capri | Sonoma | 15 | 0 | 0 | 0 | 97 | ||||
14520 | 14520 | 2021-03-17 | Arbol Residences Of Santa Rosa | Sonoma | 12 | 1 | 0 | 0 | 97 | <11 | |||
14521 | 14521 | 2021-03-17 | Brookdale Chanate | Sonoma | 11 | 1 | 0 | 0 | 97 | <11 | |||
14522 | 14522 | 2021-03-17 | Brookdale Paulin Creek | Sonoma | 13 | 1 | 0 | 0 | 97 | <11 | |||
14530 | 14530 | 2021-03-17 | Oakmont Gardens | Sonoma | 19 | 19 | 0 | 0 | 97 | ||||
14533 | 14533 | 2021-03-17 | Spring Lake Village | Sonoma | 26 | 1 | 0 | 0 | 97 | <11 | |||
14534 | 14534 | 2021-03-17 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
14538 | 14538 | 2021-03-17 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
14539 | 14539 | 2021-03-17 | Varenna At Fountaingrove | Sonoma | 14 | 0 | 0 | 0 | 97 | ||||
14540 | 14540 | 2021-03-17 | Villa Capri | Sonoma | 15 | 0 | 0 | 0 | 97 | ||||
15564 | 15564 | 2021-03-16 | Arbol Residences Of Santa Rosa | Sonoma | 12 | 1 | 0 | 0 | 97 | <11 | |||
15565 | 15565 | 2021-03-16 | Brookdale Chanate | Sonoma | 11 | 1 | 0 | 0 | 97 | <11 | |||
15566 | 15566 | 2021-03-16 | Brookdale Paulin Creek | Sonoma | 13 | 1 | 0 | 0 | 97 | <11 | |||
15574 | 15574 | 2021-03-16 | Oakmont Gardens | Sonoma | 19 | 19 | 0 | 0 | 97 | ||||
15577 | 15577 | 2021-03-16 | Spring Lake Village | Sonoma | 26 | 1 | 0 | 0 | 97 | <11 | |||
15578 | 15578 | 2021-03-16 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
15582 | 15582 | 2021-03-16 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
15583 | 15583 | 2021-03-16 | Varenna At Fountaingrove | Sonoma | 14 | 0 | 0 | 0 | 97 | ||||
15584 | 15584 | 2021-03-16 | Villa Capri | Sonoma | 15 | 0 | 0 | 0 | 97 | ||||
16608 | 16608 | 2021-03-15 | Arbol Residences Of Santa Rosa | Sonoma | 12 | 1 | 0 | 0 | 97 | <11 | |||
16609 | 16609 | 2021-03-15 | Brookdale Chanate | Sonoma | 11 | 1 | 0 | 0 | 97 | <11 | |||
16610 | 16610 | 2021-03-15 | Brookdale Paulin Creek | Sonoma | 13 | 1 | 0 | 0 | 97 | <11 | |||
16618 | 16618 | 2021-03-15 | Oakmont Gardens | Sonoma | 19 | 19 | 0 | 0 | 97 | ||||
16621 | 16621 | 2021-03-15 | Spring Lake Village | Sonoma | 26 | 1 | 0 | 0 | 97 | <11 | |||
16622 | 16622 | 2021-03-15 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
16626 | 16626 | 2021-03-15 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
16627 | 16627 | 2021-03-15 | Varenna At Fountaingrove | Sonoma | 14 | 0 | 0 | 0 | 97 | ||||
16628 | 16628 | 2021-03-15 | Villa Capri | Sonoma | 15 | 0 | 0 | 0 | 97 | ||||
17652 | 17652 | 2021-03-12 | Arbol Residences Of Santa Rosa | Sonoma | 11 | 1 | 0 | 0 | 97 | <11 | |||
17653 | 17653 | 2021-03-12 | Brookdale Chanate | Sonoma | 11 | 1 | 0 | 0 | 97 | <11 | |||
17654 | 17654 | 2021-03-12 | Brookdale Paulin Creek | Sonoma | 13 | 1 | 0 | 0 | 97 | <11 | |||
17662 | 17662 | 2021-03-12 | Oakmont Gardens | Sonoma | 19 | 19 | 0 | 0 | 97 | ||||
17665 | 17665 | 2021-03-12 | Spring Lake Village | Sonoma | 26 | 1 | 0 | 0 | 97 | <11 | |||
17666 | 17666 | 2021-03-12 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
17670 | 17670 | 2021-03-12 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
17671 | 17671 | 2021-03-12 | Varenna At Fountaingrove | Sonoma | 14 | 0 | 0 | 0 | 97 | ||||
17672 | 17672 | 2021-03-12 | Villa Capri | Sonoma | 15 | 0 | 0 | 0 | 97 | ||||
18695 | 18695 | 2021-03-11 | Arbol Residences Of Santa Rosa | Sonoma | 11 | 1 | 0 | 0 | 97 | <11 | |||
18696 | 18696 | 2021-03-11 | Brookdale Chanate | Sonoma | 11 | 1 | 0 | 0 | 97 | <11 | |||
18697 | 18697 | 2021-03-11 | Brookdale Paulin Creek | Sonoma | 13 | 1 | 0 | 0 | 97 | <11 | |||
18705 | 18705 | 2021-03-11 | Oakmont Gardens | Sonoma | 19 | 19 | 0 | 0 | 97 | ||||
18708 | 18708 | 2021-03-11 | Spring Lake Village | Sonoma | 26 | 1 | 0 | 0 | 97 | <11 | |||
18709 | 18709 | 2021-03-11 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
18713 | 18713 | 2021-03-11 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
18714 | 18714 | 2021-03-11 | Varenna At Fountaingrove | Sonoma | 14 | 0 | 0 | 0 | 97 | ||||
18715 | 18715 | 2021-03-11 | Villa Capri | Sonoma | 15 | 0 | 0 | 0 | 97 | ||||
19736 | 19736 | 2021-03-10 | Arbol Residences Of Santa Rosa | Sonoma | 11 | 1 | 0 | 0 | 97 | <11 | |||
19737 | 19737 | 2021-03-10 | Brookdale Chanate | Sonoma | 11 | 1 | 0 | 0 | 97 | <11 | |||
19738 | 19738 | 2021-03-10 | Brookdale Paulin Creek | Sonoma | 13 | 1 | 0 | 0 | 97 | <11 | |||
19746 | 19746 | 2021-03-10 | Oakmont Gardens | Sonoma | 19 | 19 | 0 | 0 | 97 | ||||
19749 | 19749 | 2021-03-10 | Spring Lake Village | Sonoma | 26 | 1 | 0 | 0 | 97 | <11 | |||
19750 | 19750 | 2021-03-10 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
19754 | 19754 | 2021-03-10 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
19755 | 19755 | 2021-03-10 | Varenna At Fountaingrove | Sonoma | 14 | 0 | 0 | 0 | 97 | ||||
19756 | 19756 | 2021-03-10 | Villa Capri | Sonoma | 15 | 0 | 0 | 0 | 97 | ||||
20778 | 20778 | 2021-03-09 | Arbol Residences Of Santa Rosa | Sonoma | 11 | 1 | 0 | 0 | 97 | <11 | |||
20779 | 20779 | 2021-03-09 | Brookdale Chanate | Sonoma | 11 | 1 | 0 | 0 | 97 | <11 | |||
20780 | 20780 | 2021-03-09 | Brookdale Paulin Creek | Sonoma | 13 | 1 | 0 | 0 | 97 | <11 | |||
20788 | 20788 | 2021-03-09 | Oakmont Gardens | Sonoma | 19 | 19 | 0 | 0 | 97 | ||||
20791 | 20791 | 2021-03-09 | Spring Lake Village | Sonoma | 26 | 1 | 0 | 0 | 97 | <11 | |||
20792 | 20792 | 2021-03-09 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
20796 | 20796 | 2021-03-09 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
20797 | 20797 | 2021-03-09 | Varenna At Fountaingrove | Sonoma | 14 | 0 | 0 | 0 | 97 | ||||
20798 | 20798 | 2021-03-09 | Villa Capri | Sonoma | 15 | 0 | 0 | 0 | 97 | ||||
21771 | 21771 | 2021-03-08 | Arbol Residences Of Santa Rosa | Sonoma | 11 | 1 | 0 | 0 | 97 | <11 | |||
21772 | 21772 | 2021-03-08 | Brookdale Chanate | Sonoma | 11 | 1 | 0 | 0 | 97 | <11 | |||
21773 | 21773 | 2021-03-08 | Brookdale Paulin Creek | Sonoma | 13 | 1 | 0 | 0 | 97 | <11 | |||
21781 | 21781 | 2021-03-08 | Oakmont Gardens | Sonoma | 19 | 19 | 0 | 0 | 97 | ||||
21784 | 21784 | 2021-03-08 | Spring Lake Village | Sonoma | 26 | 1 | 0 | 0 | 97 | <11 | |||
21785 | 21785 | 2021-03-08 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
21789 | 21789 | 2021-03-08 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
21790 | 21790 | 2021-03-08 | Varenna At Fountaingrove | Sonoma | 14 | 0 | 0 | 0 | 97 | ||||
21791 | 21791 | 2021-03-08 | Villa Capri | Sonoma | 15 | 0 | 0 | 0 | 97 | ||||
22807 | 22807 | 2021-03-04 | Arbol Residences Of Santa Rosa | Sonoma | 11 | 1 | 0 | 0 | 97 | <11 | |||
22808 | 22808 | 2021-03-04 | Brookdale Chanate | Sonoma | 11 | 1 | 0 | 0 | 97 | <11 | |||
22809 | 22809 | 2021-03-04 | Brookdale Paulin Creek | Sonoma | 13 | 1 | 0 | 0 | 97 | <11 | |||
22817 | 22817 | 2021-03-04 | Oakmont Gardens | Sonoma | 19 | 19 | 0 | 0 | 97 | ||||
22820 | 22820 | 2021-03-04 | Spring Lake Village | Sonoma | 26 | 1 | 0 | 0 | 97 | <11 | |||
22821 | 22821 | 2021-03-04 | Springfield Place | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
22825 | 22825 | 2021-03-04 | Sunrise Villa Sonoma | Sonoma | 21 | 1 | 0 | 0 | 97 | <11 | |||
22826 | 22826 | 2021-03-04 | Varenna At Fountaingrove | Sonoma | 14 | 0 | 0 | 0 | 97 | ||||
22827 | 22827 | 2021-03-04 | Villa Capri | Sonoma | 15 | 0 | 0 | 0 | 97 | ||||
23847 | 23847 | 2021-03-03 | Arbol Residences Of Santa Rosa | Sonoma | 11 | 1 | 0 | 0 | 97 | <11 | |||
23848 | 23848 | 2021-03-03 | Brookdale Chanate | Sonoma | 11 | 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 );