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
80 rows where county = "Solano" and patients_confirmed_cases = 42 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
951 | 951 | 2021-06-27 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
1951 | 1951 | 2021-05-11 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
2996 | 2996 | 2021-04-27 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
4045 | 4045 | 2021-04-21 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
5092 | 5092 | 2021-04-06 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
6139 | 6139 | 2021-03-30 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
7186 | 7186 | 2021-03-29 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
8233 | 8233 | 2021-03-25 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
9280 | 9280 | 2021-03-24 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
10327 | 10327 | 2021-03-23 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
11373 | 11373 | 2021-03-22 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
12419 | 12419 | 2021-03-19 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
13464 | 13464 | 2021-03-18 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
14508 | 14508 | 2021-03-17 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
15552 | 15552 | 2021-03-16 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
16596 | 16596 | 2021-03-15 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
17640 | 17640 | 2021-03-12 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
18683 | 18683 | 2021-03-11 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
19724 | 19724 | 2021-03-10 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
20766 | 20766 | 2021-03-09 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
21759 | 21759 | 2021-03-08 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
22795 | 22795 | 2021-03-04 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
23835 | 23835 | 2021-03-03 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
24874 | 24874 | 2021-03-02 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
25913 | 25913 | 2021-03-01 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
26950 | 26950 | 2021-02-26 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
27987 | 27987 | 2021-02-25 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
29023 | 29023 | 2021-02-24 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
30056 | 30056 | 2021-02-22 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
31090 | 31090 | 2021-02-19 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
32124 | 32124 | 2021-02-18 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
33157 | 33157 | 2021-02-17 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
34187 | 34187 | 2021-02-16 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
35215 | 35215 | 2021-02-12 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
36242 | 36242 | 2021-02-11 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
37267 | 37267 | 2021-02-10 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
38292 | 38292 | 2021-02-09 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
39316 | 39316 | 2021-02-08 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
40335 | 40335 | 2021-02-05 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
41349 | 41349 | 2021-02-04 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
42359 | 42359 | 2021-02-03 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
43367 | 43367 | 2021-02-02 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
44372 | 44372 | 2021-02-01 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
45371 | 45371 | 2021-01-29 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
46366 | 46366 | 2021-01-28 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
47364 | 47364 | 2021-01-27 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
48311 | 48311 | 2021-01-26 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
49298 | 49298 | 2021-01-25 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
50226 | 50226 | 2021-01-21 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
51187 | 51187 | 2021-01-20 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
52144 | 52144 | 2021-01-19 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
53078 | 53078 | 2021-01-15 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
53991 | 53991 | 2021-01-14 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
54911 | 54911 | 2021-01-13 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
55823 | 55823 | 2021-01-12 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
56729 | 56729 | 2021-01-11 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
57613 | 57613 | 2021-01-08 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
58486 | 58486 | 2021-01-07 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
59347 | 59347 | 2021-01-06 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
60196 | 60196 | 2021-01-05 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
61033 | 61033 | 2021-01-04 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
61834 | 61834 | 2020-12-31 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
62615 | 62615 | 2020-12-30 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
63385 | 63385 | 2020-12-29 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
64147 | 64147 | 2020-12-28 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
64871 | 64871 | 2020-12-24 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
65582 | 65582 | 2020-12-23 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
66284 | 66284 | 2020-12-22 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
66975 | 66975 | 2020-12-21 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
67632 | 67632 | 2020-12-18 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
68279 | 68279 | 2020-12-17 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
68909 | 68909 | 2020-12-16 | Magnolia Court | Solano | 20 | 42 | 0 | 1 | 95 | <11 | |||
69524 | 69524 | 2020-12-15 | Magnolia Court | Solano | 19 | 42 | 0 | 1 | 95 | <11 | |||
70132 | 70132 | 2020-12-14 | Magnolia Court | Solano | 19 | 42 | 0 | 1 | 95 | <11 | |||
70714 | 70714 | 2020-12-11 | Magnolia Court | Solano | 19 | 42 | 0 | 1 | 95 | <11 | |||
71288 | 71288 | 2020-12-10 | Magnolia Court | Solano | 19 | 42 | 0 | 1 | 95 | <11 | |||
71852 | 71852 | 2020-12-09 | Magnolia Court | Solano | 19 | 42 | 0 | 1 | 95 | <11 | |||
72406 | 72406 | 2020-12-08 | Magnolia Court | Solano | 19 | 42 | 0 | 1 | 95 | <11 | |||
72950 | 72950 | 2020-12-07 | Magnolia Court | Solano | 19 | 42 | 0 | 1 | 95 | <11 | |||
73476 | 73476 | 2020-12-04 | Magnolia Court | Solano | 19 | 42 | 0 | 1 | 95 | <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 );