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,790 rows where fips = 77 sorted by patients_deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: patients_deaths, staff_deaths_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
797 | 797 | 2021-06-27 | Balance Assisted Living And Memory Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
798 | 798 | 2021-06-27 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
802 | 802 | 2021-06-27 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
1802 | 1802 | 2021-05-11 | Balance Assisted Living And Memory Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
1803 | 1803 | 2021-05-11 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
2844 | 2844 | 2021-04-27 | Balance Assisted Living And Memory Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
2845 | 2845 | 2021-04-27 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
2849 | 2849 | 2021-04-27 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
3893 | 3893 | 2021-04-21 | Balance Assisted Living And Memory Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
3894 | 3894 | 2021-04-21 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
3898 | 3898 | 2021-04-21 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
4940 | 4940 | 2021-04-06 | Balance Assisted Living And Memory Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
4941 | 4941 | 2021-04-06 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
4945 | 4945 | 2021-04-06 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
5987 | 5987 | 2021-03-30 | Balance Assisted Living And Memory Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
5988 | 5988 | 2021-03-30 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
5992 | 5992 | 2021-03-30 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
7034 | 7034 | 2021-03-29 | Balance Assisted Living And Memory Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
7035 | 7035 | 2021-03-29 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
7039 | 7039 | 2021-03-29 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
8081 | 8081 | 2021-03-25 | Balance Assisted Living And Memory Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
8082 | 8082 | 2021-03-25 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
8086 | 8086 | 2021-03-25 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
9128 | 9128 | 2021-03-24 | Balance Assisted Living And Memory Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
9129 | 9129 | 2021-03-24 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
9133 | 9133 | 2021-03-24 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
10175 | 10175 | 2021-03-23 | Balance Assisted Living And Memory Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
10176 | 10176 | 2021-03-23 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
10180 | 10180 | 2021-03-23 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
11221 | 11221 | 2021-03-22 | Balance Assisted Living And Memory Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
11222 | 11222 | 2021-03-22 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
11226 | 11226 | 2021-03-22 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
12267 | 12267 | 2021-03-19 | Balance Assisted Living And Memory Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
12268 | 12268 | 2021-03-19 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
12272 | 12272 | 2021-03-19 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
13312 | 13312 | 2021-03-18 | Balance Assisted Living And Memory Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
13313 | 13313 | 2021-03-18 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
13317 | 13317 | 2021-03-18 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
14356 | 14356 | 2021-03-17 | Balance Assisted Living And Memory Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
14357 | 14357 | 2021-03-17 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
14361 | 14361 | 2021-03-17 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
15400 | 15400 | 2021-03-16 | Balance Assisted Living And Memory Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
15401 | 15401 | 2021-03-16 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
15405 | 15405 | 2021-03-16 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
16444 | 16444 | 2021-03-15 | Balance Assisted Living And Memory Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
16445 | 16445 | 2021-03-15 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
16449 | 16449 | 2021-03-15 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
17488 | 17488 | 2021-03-12 | Balance Assisted Living And Memory Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
17489 | 17489 | 2021-03-12 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
17493 | 17493 | 2021-03-12 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
18531 | 18531 | 2021-03-11 | Balance Assisted Living And Memory Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
18532 | 18532 | 2021-03-11 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
18536 | 18536 | 2021-03-11 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
19573 | 19573 | 2021-03-10 | Balance Assisted Living And Memory Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
19574 | 19574 | 2021-03-10 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
19578 | 19578 | 2021-03-10 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
20615 | 20615 | 2021-03-09 | Balance Assisted Living And Memory Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
20616 | 20616 | 2021-03-09 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
20620 | 20620 | 2021-03-09 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
21613 | 21613 | 2021-03-08 | Balance Assisted Living And Memory Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
21614 | 21614 | 2021-03-08 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
22644 | 22644 | 2021-03-04 | Balance Assisted Living And Memory Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
22645 | 22645 | 2021-03-04 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
22649 | 22649 | 2021-03-04 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
23684 | 23684 | 2021-03-03 | Balance Assisted Living And Memory Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
23685 | 23685 | 2021-03-03 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
23689 | 23689 | 2021-03-03 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
24724 | 24724 | 2021-03-02 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
24728 | 24728 | 2021-03-02 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
25763 | 25763 | 2021-03-01 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
25767 | 25767 | 2021-03-01 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
26800 | 26800 | 2021-02-26 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
26804 | 26804 | 2021-02-26 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
27837 | 27837 | 2021-02-25 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
27841 | 27841 | 2021-02-25 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
28873 | 28873 | 2021-02-24 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
28877 | 28877 | 2021-02-24 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
29906 | 29906 | 2021-02-22 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
29910 | 29910 | 2021-02-22 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
30940 | 30940 | 2021-02-19 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
30944 | 30944 | 2021-02-19 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
31974 | 31974 | 2021-02-18 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
31978 | 31978 | 2021-02-18 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
33007 | 33007 | 2021-02-17 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
33011 | 33011 | 2021-02-17 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
34038 | 34038 | 2021-02-16 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
34042 | 34042 | 2021-02-16 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
35066 | 35066 | 2021-02-12 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
35070 | 35070 | 2021-02-12 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
36093 | 36093 | 2021-02-11 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
36097 | 36097 | 2021-02-11 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
37118 | 37118 | 2021-02-10 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
37121 | 37121 | 2021-02-10 | Camlu Assisted Living | San Joaquin | 1 | 27 | 0 | 0 | 77 | <11 | |||
37122 | 37122 | 2021-02-10 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
37135 | 37135 | 2021-02-10 | Somerford Place - Stockton | San Joaquin | 11 | 16 | 0 | 0 | 77 | ||||
38143 | 38143 | 2021-02-09 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
38146 | 38146 | 2021-02-09 | Camlu Assisted Living | San Joaquin | 1 | 25 | 0 | 0 | 77 | <11 | |||
38147 | 38147 | 2021-02-09 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
38160 | 38160 | 2021-02-09 | Somerford Place - Stockton | San Joaquin | 11 | 16 | 0 | 0 | 77 | ||||
39167 | 39167 | 2021-02-08 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <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 );