la_times_cdph_skilled_nursing_totals

Table actions
⚠️ 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_skilled_nursing_totals

342 rows sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: staff_deaths_note, source_url, date (date)

Link rowid date ▲ staff_active_cases patients_active_cases staff_confirmed_cases patients_confirmed_cases staff_deaths patients_deaths staff_deaths_note source_url
1 1 2021-05-04 128 64 50722 61422 229 9050   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
2 2 2021-05-03 125 63 50715 61409 229 9050   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
3 3 2021-05-01 120 53 50692 61388 229 9048   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
4 4 2021-04-30 132 54 50687 61386 229 9048   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
5 5 2021-04-29 149 46 50678 61380 229 9047   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
6 6 2021-04-28 150 56 50664 61380 229 9047   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
7 7 2021-04-27 149 58 50660 61376 229 9045   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
8 8 2021-04-26 146 69 50651 61376 229 9044   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
9 9 2021-04-23 140 79 50622 61363 226 9041   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
10 10 2021-04-22 148 91 50613 61358 226 9040   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
11 11 2021-04-21 150 94 50603 61352 226 9040   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
12 12 2021-04-19 153 95 50591 61346 226 9040   https://docs.google.com/spreadsheets/d/1AkdpI9HjJ1mnLgWNQZXCaaqXwWhf6speFI41gYae6gY/edit#gid=613420202
13 13 2021-04-17 155 104 50573 61326 226 9040   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
14 14 2021-04-16 154 105 50556 61315 226 9038   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
15 15 2021-04-15 138 104 50544 61322 226 9038   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
16 16 2021-04-14 142 89 50529 61308 226 9037   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
17 17 2021-04-13 154 102 50526 61297 226 9035   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
18 18 2021-04-12 157 124 50520 61295 226 9035   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
19 19 2021-04-11 161 141 50515 61283 226 9035   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
20 20 2021-04-10 175 123 50505 61260 226 9034   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
21 21 2021-04-09 189 123 50496 61252 226 9033   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
22 22 2021-04-08 181 124 50479 61242 225 9032   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
23 23 2021-04-07 180 135 50467 61228 225 9032   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
24 24 2021-04-06 174 135 50457 61221 225 9035   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
25 25 2021-04-05 174 135 50452 61218 225 9033   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
26 26 2021-04-02 165 130 50415 61193 225 9030   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
27 27 2021-04-01 149 139 50427 61203 225 9040   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
28 28 2021-03-31 176 142 50387 61168 225 9028   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
29 29 2021-03-30 174 152 50372 61161 225 9027   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
30 30 2021-03-29 168 161 50363 61152 225 9026   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
31 31 2021-03-26 148 181 50306 61110 225 9019   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
32 32 2021-03-25 159 164 50266 61057 225 9016   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
33 33 2021-03-24 154 168 50286 61092 225 9017   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
34 34 2021-03-23 157 196 50282 61087 225 9016   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
35 35 2021-03-22 162 202 50277 61083 225 9015   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
36 36 2021-03-21 161 162 50266 61066 225 9011   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
37 37 2021-03-20 170 232 50256 61066 225 9010   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
38 38 2021-03-19 175 222 50242 61065 225 9009   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
39 39 2021-03-18 168 233 50218 61051 225 9003   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
40 40 2021-03-17 166 258 50203 61041 225 9002   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
41 41 2021-03-16 160 225 50190 61033 225 9001   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
42 42 2021-03-15 163 258 50233 61095 225 9017   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
43 43 2021-03-14 164 277 50174 61022 225 8998   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
44 44 2021-03-13 175 282 50163 61009 225 8996   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
45 45 2021-03-12 174 287 50149 60991 225 8995   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
46 46 2021-03-11 181 299 50129 60980 225 8994   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
47 47 2021-03-10 202 296 50123 60970 225 8993   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
48 48 2021-03-09 205 291 50116 60953 225 8992   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
49 49 2021-03-08 202 288 50106 60952 225 8991   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
50 50 2021-03-05 214 306 50063 60912 225 8984   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
51 51 2021-03-04 228 329 50046 60890 225 8978   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
52 52 2021-03-03 231 372 50033 60871 225 8974   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
53 53 2021-03-02 243 392 50070 60904 225 8994   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
54 54 2021-03-01 258 415 50155 61183 225 9026   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
55 55 2021-02-28 261 412 50092 61031 225 8987   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
56 56 2021-02-27 265 451 49991 60830 225 8958   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
57 57 2021-02-26 285 518 49980 60807 225 8957   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
58 58 2021-02-25 303 545 49953 60785 225 8950   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
59 59 2021-02-24 312 577 49926 60762 225 8942   https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-063.aspx
60 60 2021-02-22 360 702 49909 60740 224 8926   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
61 61 2021-02-21 387 694 49897 60730 224 8923   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
62 62 2021-02-20 421 763 49872 60714 224 8917   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
63 63 2021-02-19 457 865 49856 60696 224 8910   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
64 64 2021-02-18 500 884 49799 60704 223 8904   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
65 65 2021-02-17 550 930 49782 60666 223 8897   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
66 66 2021-02-16 570 1004 49763 60648 222 8890   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
67 67 2021-02-15 587 1092 49732 60635 221 8878   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
68 68 2021-02-14 611 1161 49718 60621 221 8872   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
69 69 2021-02-13 676 1153 49697 60584 220 8862   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
70 70 2021-02-12 738 1227 49666 60546 219 8840   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
71 71 2021-02-11 816 1351 49621 60498 219 8827   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
72 72 2021-02-10 917 1374 49585 60445 219 8808   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
73 73 2021-02-09 967 1543 49555 60420 219 8794   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
74 74 2021-02-08 1035 1580 49434 60370 219 8780   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
75 75 2021-02-07 1094 1610 49362 60297 219 8762   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
76 76 2021-02-06 1171 1690 49337 60270 218 8755   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
77 77 2021-02-05 1288 1896 49285 60191 216 8732   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
78 78 2021-02-04 1424 2013 49211 60093 215 8713   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
79 79 2021-02-03 1574 2087 49144 60013 210 8690   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
80 80 2021-02-02 1692 2245 49106 59936 208 8664   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
81 81 2021-02-01 1763 2247 49048 59876 207 8630   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
82 82 2021-01-31 1861 2384 49010 59801 206 8616   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
83 83 2021-01-29 2225 2659 48832 59505 204 8568   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
84 84 2021-01-28 2468 2771 48709 59362 204 8541   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
85 85 2021-01-27 2717 2915 48573 59231 204 8511   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
86 86 2021-01-26 2824 3134 48491 59133 203 8465   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
87 87 2021-01-25 2957 3303 48388 58981 202 8426   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
88 88 2021-01-24 3150 3349 48291 58885 202 8397   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
89 89 2021-01-23 3383 3451 48155 58689 202 8362   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
90 90 2021-01-22 3656 3530 47987 58388 202 8304   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
91 91 2021-01-21 4041 3837 47777 58167 202 8251   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
92 92 2021-01-20 4268 3743 47560 57830 201 8190   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
93 93 2021-01-19 4511 4062 47404 57619 202 8124   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
94 94 2021-01-18 4713 4201 47285 57405 201 8067   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
95 95 2021-01-16 5041 4595 46921 56868 200 7983   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
96 96 2021-01-15 5283 4683 46607 56476 198 7914   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
97 97 2021-01-14 5687 4715 46241 55911 196 7854   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
98 98 2021-01-13 6002 4554 45857 55534 194 7768   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
99 99 2021-01-11 6531 5374 45441 54962 192 7579   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
100 100 2021-01-10 6586 5413 45149 54691 192 7512   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [la_times_cdph_skilled_nursing_totals] (
   [date] TEXT,
   [staff_active_cases] INTEGER,
   [patients_active_cases] INTEGER,
   [staff_confirmed_cases] INTEGER,
   [patients_confirmed_cases] INTEGER,
   [staff_deaths] INTEGER,
   [patients_deaths] INTEGER,
   [staff_deaths_note] TEXT,
   [source_url] TEXT
);