la_times_cdph_adult_and_senior_care_totals

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

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_totals

65 rows sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date)

Link rowid date ▲ confirmed_cases deaths source_url
1 1 2020-07-02 3621 446 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/7-01.pdf
2 2 2020-07-01 3567 442 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/6-30.pdf
3 3 2020-06-30 3500 439 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/6-29.pdf
4 4 2020-06-29 3416 430 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/6-28.pdf
5 5 2020-06-28 3347 429 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/6-27.pdf
6 6 2020-06-27 3234 421 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/6-26.pdf
7 7 2020-06-26 3186 414 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/6-25.pdf
8 8 2020-06-25 3130 408 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/6-24.pdf
9 9 2020-06-24 3099 406 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/6-23.pdf
10 10 2020-06-23 3008 400 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/6-22.pdf
11 11 2020-06-22 2969 398 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/6-21.pdf
12 12 2020-06-21 2953 394 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/6-20.pdf
13 13 2020-06-20 2900 393 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/6-19.pdf
14 14 2020-06-19 2863 389 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/6-18.pdf
15 15 2020-06-18 2812 388 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-06-17.pdf
16 16 2020-06-17 2777 383 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-06-16.pdf
17 17 2020-06-16 2706 377 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-06-15.pdf
18 18 2020-06-15 2680 376 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-06-14.pdf
19 19 2020-06-14 2665 375 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-06-13.pdf
20 20 2020-06-13 2586 369 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-06-12.pdf?ver=2020-06-13-155105-973
21 21 2020-06-12 2562 373 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-06-11.pdf
22 22 2020-06-11 2506 366 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-06-10.pdf
23 23 2020-06-10 2476 362 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-06-09.pdf
24 24 2020-06-09 2440 357 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-06-08.pdf
25 25 2020-06-08 2420 351 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-06-07.pdf
26 26 2020-06-07 2390 349 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-06-06.pdf
27 27 2020-06-06 2375 348 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-06-05.pdf
28 28 2020-06-05 2349 344 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-06-04.pdf
29 29 2020-06-04 2299 342 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-06-03.pdf
30 30 2020-06-03 2277 336 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-06-02.pdf
31 31 2020-06-02 2207 331 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-06-01.pdf
32 32 2020-06-01 2195 328 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-05-31.pdf
33 33 2020-05-31 2192 326 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-05-30.pdf
34 34 2020-05-30 2173 323 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-05-29.pdf
35 35 2020-05-29 2194 310 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-05-28.pdf
36 36 2020-05-28 2164 305 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-05-27.pdf
37 37 2020-05-27 2143 305 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-05-26.pdf
38 38 2020-05-26 2134 303 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-05-25.pdf
39 39 2020-05-25 2122 302 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-05-24.pdf
40 40 2020-05-24 2104 300 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-05-23.pdf
41 41 2020-05-22 2036 295 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-05-21.pdf
42 42 2020-05-21 1997 290 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-05-20.pdf
43 43 2020-05-20 1861 284 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-05-19.pdf
44 44 2020-05-19 1929 272 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-05-18.pdf
45 45 2020-05-18 1904 269 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-05-17.pdf
46 46 2020-05-17 1876 268 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-05-16.pdf
47 47 2020-05-16 1873 266 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-05-15.pdf
48 48 2020-05-15 1834 262 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-05-14.pdf
49 49 2020-05-14 1803 257 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-05-13.pdf
50 50 2020-05-13 1767 250 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-05-12.pdf
51 51 2020-05-12 1730 241 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-05-11.pdf
52 52 2020-05-11 1708 231 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-05-10.pdf
53 53 2020-05-10 1667 229 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-05-09.pdf
54 54 2020-05-09 1644 228 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-05-08.pdf
55 55 2020-05-08 1617 224 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-05-07.pdf
56 56 2020-05-07 1602 216 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-05-06.pdf
57 57 2020-05-06 1552 201 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-05-05.pdf
58 58 2020-05-05 1473 187 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-05-04.pdf
59 59 2020-05-04 1430 178 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-05-03.pdf
60 60 2020-05-03 1419 177 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-05-02.pdf
61 61 2020-05-02 1404 175 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-05-01.pdf
62 62 2020-05-01 1340 170 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-4-30.pdf
63 63 2020-04-29 1267 155 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-4-28.pdf
64 64 2020-04-28 1198 147 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-4-27.pdf
65 65 2020-04-27 1179 146 https://www.cdss.ca.gov/Portals/9/Additional-Resources/Research-and-Data/DSSDS/RCFE-4-26_V2.pdf

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [la_times_cdph_adult_and_senior_care_totals] (
   [date] TEXT,
   [confirmed_cases] INTEGER,
   [deaths] INTEGER,
   [source_url] TEXT
);
Powered by Datasette · Query took 11.488ms · 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_totals