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
185 rows where patients_deaths = 18 sorted by county descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: county, patients_confirmed_cases, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
86546 | 86546 | 2020-10-22 | El Rio Memory Care Community | Stanislaus | 20 | 45 | 0 | 18 | 99 | ||||
86941 | 86941 | 2020-10-21 | El Rio Memory Care Community | Stanislaus | 20 | 45 | 0 | 18 | 99 | ||||
87333 | 87333 | 2020-10-20 | El Rio Memory Care Community | Stanislaus | 20 | 45 | 0 | 18 | 99 | ||||
87724 | 87724 | 2020-10-19 | El Rio Memory Care Community | Stanislaus | 20 | 45 | 0 | 18 | 99 | ||||
88115 | 88115 | 2020-10-16 | El Rio Memory Care Community | Stanislaus | 20 | 45 | 0 | 18 | 99 | ||||
88505 | 88505 | 2020-10-15 | El Rio Memory Care Community | Stanislaus | 20 | 45 | 0 | 18 | 99 | ||||
88893 | 88893 | 2020-10-14 | El Rio Memory Care Community | Stanislaus | 20 | 45 | 0 | 18 | 99 | ||||
89279 | 89279 | 2020-10-13 | El Rio Memory Care Community | Stanislaus | 20 | 45 | 0 | 18 | 99 | ||||
89662 | 89662 | 2020-10-12 | El Rio Memory Care Community | Stanislaus | 20 | 45 | 0 | 18 | 99 | ||||
90044 | 90044 | 2020-10-09 | El Rio Memory Care Community | Stanislaus | 20 | 45 | 0 | 18 | 99 | ||||
90424 | 90424 | 2020-10-08 | El Rio Memory Care Community | Stanislaus | 20 | 45 | 0 | 18 | 99 | ||||
90802 | 90802 | 2020-10-07 | El Rio Memory Care Community | Stanislaus | 20 | 45 | 0 | 18 | 99 | ||||
91178 | 91178 | 2020-10-06 | El Rio Memory Care Community | Stanislaus | 20 | 45 | 0 | 18 | 99 | ||||
91552 | 91552 | 2020-10-05 | El Rio Memory Care Community | Stanislaus | 20 | 45 | 0 | 18 | 99 | ||||
91916 | 91916 | 2020-10-02 | El Rio Memory Care Community | Stanislaus | 20 | 45 | 0 | 18 | 99 | ||||
92283 | 92283 | 2020-10-01 | El Rio Memory Care Community | Stanislaus | 20 | 45 | 0 | 18 | 99 | ||||
92649 | 92649 | 2020-09-30 | El Rio Memory Care Community | Stanislaus | 20 | 45 | 0 | 18 | 99 | ||||
93007 | 93007 | 2020-09-29 | El Rio Memory Care Community | Stanislaus | 20 | 45 | 0 | 18 | 99 | ||||
93363 | 93363 | 2020-09-28 | El Rio Memory Care Community | Stanislaus | 20 | 45 | 0 | 18 | 99 | ||||
93715 | 93715 | 2020-09-25 | El Rio Memory Care Community | Stanislaus | 20 | 45 | 0 | 18 | 99 | ||||
94073 | 94073 | 2020-09-24 | El Rio Memory Care Community | Stanislaus | 20 | 45 | 0 | 18 | 99 | ||||
94425 | 94425 | 2020-09-23 | El Rio Memory Care Community | Stanislaus | 20 | 45 | 0 | 18 | 99 | ||||
94772 | 94772 | 2020-09-22 | El Rio Memory Care Community | Stanislaus | 20 | 45 | 0 | 18 | 99 | ||||
95122 | 95122 | 2020-09-21 | El Rio Memory Care Community | Stanislaus | 20 | 45 | 0 | 18 | 99 | ||||
734 | 734 | 2021-06-27 | Montera, The | San Diego | 33 | 90 | 0 | 18 | 73 | ||||
1742 | 1742 | 2021-05-11 | Montera, The | San Diego | 33 | 90 | 0 | 18 | 73 | ||||
2781 | 2781 | 2021-04-27 | Montera, The | San Diego | 33 | 90 | 0 | 18 | 73 | ||||
3830 | 3830 | 2021-04-21 | Montera, The | San Diego | 33 | 90 | 0 | 18 | 73 | ||||
4877 | 4877 | 2021-04-06 | Montera, The | San Diego | 33 | 90 | 0 | 18 | 73 | ||||
5925 | 5925 | 2021-03-30 | Montera, The | San Diego | 33 | 90 | 0 | 18 | 73 | ||||
6972 | 6972 | 2021-03-29 | Montera, The | San Diego | 33 | 90 | 0 | 18 | 73 | ||||
8019 | 8019 | 2021-03-25 | Montera, The | San Diego | 33 | 90 | 0 | 18 | 73 | ||||
9066 | 9066 | 2021-03-24 | Montera, The | San Diego | 33 | 90 | 0 | 18 | 73 | ||||
10113 | 10113 | 2021-03-23 | Montera, The | San Diego | 33 | 90 | 0 | 18 | 73 | ||||
11159 | 11159 | 2021-03-22 | Montera, The | San Diego | 33 | 90 | 0 | 18 | 73 | ||||
12205 | 12205 | 2021-03-19 | Montera, The | San Diego | 33 | 90 | 0 | 18 | 73 | ||||
13250 | 13250 | 2021-03-18 | Montera, The | San Diego | 33 | 90 | 0 | 18 | 73 | ||||
14294 | 14294 | 2021-03-17 | Montera, The | San Diego | 33 | 90 | 0 | 18 | 73 | ||||
15338 | 15338 | 2021-03-16 | Montera, The | San Diego | 33 | 90 | 0 | 18 | 73 | ||||
16382 | 16382 | 2021-03-15 | Montera, The | San Diego | 33 | 90 | 0 | 18 | 73 | ||||
17426 | 17426 | 2021-03-12 | Montera, The | San Diego | 33 | 90 | 0 | 18 | 73 | ||||
18469 | 18469 | 2021-03-11 | Montera, The | San Diego | 33 | 90 | 0 | 18 | 73 | ||||
19511 | 19511 | 2021-03-10 | Montera, The | San Diego | 33 | 90 | 0 | 18 | 73 | ||||
20553 | 20553 | 2021-03-09 | Montera, The | San Diego | 33 | 90 | 0 | 18 | 73 | ||||
21554 | 21554 | 2021-03-08 | Montera, The | San Diego | 33 | 90 | 0 | 18 | 73 | ||||
22582 | 22582 | 2021-03-04 | Montera, The | San Diego | 33 | 90 | 0 | 18 | 73 | ||||
23622 | 23622 | 2021-03-03 | Montera, The | San Diego | 33 | 90 | 0 | 18 | 73 | ||||
24662 | 24662 | 2021-03-02 | Montera, The | San Diego | 33 | 90 | 0 | 18 | 73 | ||||
25701 | 25701 | 2021-03-01 | Montera, The | San Diego | 33 | 90 | 0 | 18 | 73 | ||||
26738 | 26738 | 2021-02-26 | Montera, The | San Diego | 33 | 90 | 0 | 18 | 73 | ||||
27775 | 27775 | 2021-02-25 | Montera, The | San Diego | 33 | 90 | 0 | 18 | 73 | ||||
28811 | 28811 | 2021-02-24 | Montera, The | San Diego | 33 | 90 | 0 | 18 | 73 | ||||
29845 | 29845 | 2021-02-22 | Montera, The | San Diego | 33 | 91 | 0 | 18 | 73 | ||||
30879 | 30879 | 2021-02-19 | Montera, The | San Diego | 33 | 91 | 0 | 18 | 73 | ||||
31913 | 31913 | 2021-02-18 | Montera, The | San Diego | 33 | 91 | 0 | 18 | 73 | ||||
38061 | 38061 | 2021-02-09 | Felicita Vida | San Diego | 33 | 44 | 0 | 18 | 73 | ||||
39085 | 39085 | 2021-02-08 | Felicita Vida | San Diego | 33 | 44 | 0 | 18 | 73 | ||||
40105 | 40105 | 2021-02-05 | Felicita Vida | San Diego | 33 | 44 | 0 | 18 | 73 | ||||
634 | 634 | 2021-06-27 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
1648 | 1648 | 2021-05-11 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
2683 | 2683 | 2021-04-27 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
3732 | 3732 | 2021-04-21 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
4779 | 4779 | 2021-04-06 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
5826 | 5826 | 2021-03-30 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
6873 | 6873 | 2021-03-29 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
7920 | 7920 | 2021-03-25 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
8967 | 8967 | 2021-03-24 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
10014 | 10014 | 2021-03-23 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
11060 | 11060 | 2021-03-22 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
12106 | 12106 | 2021-03-19 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
13151 | 13151 | 2021-03-18 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
14195 | 14195 | 2021-03-17 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
15239 | 15239 | 2021-03-16 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
16283 | 16283 | 2021-03-15 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
17327 | 17327 | 2021-03-12 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
18370 | 18370 | 2021-03-11 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
19412 | 19412 | 2021-03-10 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
20454 | 20454 | 2021-03-09 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
21460 | 21460 | 2021-03-08 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
22483 | 22483 | 2021-03-04 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
23523 | 23523 | 2021-03-03 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
24563 | 24563 | 2021-03-02 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
25602 | 25602 | 2021-03-01 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
26639 | 26639 | 2021-02-26 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
27676 | 27676 | 2021-02-25 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
28712 | 28712 | 2021-02-24 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
29746 | 29746 | 2021-02-22 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
30780 | 30780 | 2021-02-19 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
31814 | 31814 | 2021-02-18 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
32847 | 32847 | 2021-02-17 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
33878 | 33878 | 2021-02-16 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
34907 | 34907 | 2021-02-12 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
35934 | 35934 | 2021-02-11 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
36959 | 36959 | 2021-02-10 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
37984 | 37984 | 2021-02-09 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
39008 | 39008 | 2021-02-08 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
40028 | 40028 | 2021-02-05 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
41043 | 41043 | 2021-02-04 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
42054 | 42054 | 2021-02-03 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
43062 | 43062 | 2021-02-02 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 |
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 );