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

288 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-02-28 261 412 55092 61031 225 8987   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
2 2 2021-02-27 265 451 49991 60830 225 8958   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
3 3 2021-02-26 285 518 49980 60807 225 8957   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
4 4 2021-02-25 303 545 49953 60785 225 8950   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
5 5 2021-02-24 312 577 49926 60762 225 8942   https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-063.aspx
6 6 2021-02-22 360 702 49909 60740 224 8926   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
7 7 2021-02-21 387 694 49897 60730 224 8923   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
8 8 2021-02-20 421 763 49872 60714 224 8917   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
9 9 2021-02-19 457 865 49856 60696 224 8910   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
10 10 2021-02-18 500 884 49799 60704 223 8904   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
11 11 2021-02-17 550 930 49782 60666 223 8897   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
12 12 2021-02-16 570 1004 49763 60648 222 8890   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
13 13 2021-02-15 587 1092 49732 60635 221 8878   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
14 14 2021-02-14 611 1161 49718 60621 221 8872   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
15 15 2021-02-13 676 1153 49697 60584 220 8862   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
16 16 2021-02-12 738 1227 49666 60546 219 8840   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
17 17 2021-02-11 816 1351 49621 60498 219 8827   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
18 18 2021-02-10 917 1374 49585 60445 219 8808   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
19 19 2021-02-09 967 1543 49555 60420 219 8794   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
20 20 2021-02-08 1035 1580 49434 60370 219 8780   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
21 21 2021-02-07 1094 1610 49362 60297 219 8762   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
22 22 2021-02-06 1171 1690 49337 60270 218 8755   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
23 23 2021-02-05 1288 1896 49285 60191 216 8732   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
24 24 2021-02-04 1424 2013 49211 60093 215 8713   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
25 25 2021-02-03 1574 2087 49144 60013 210 8690   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
26 26 2021-02-02 1692 2245 49106 59936 208 8664   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
27 27 2021-02-01 1763 2247 49048 59876 207 8630   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
28 28 2021-01-31 1861 2384 49010 59801 206 8616   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
29 29 2021-01-29 2225 2659 48832 59505 204 8568   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
30 30 2021-01-28 2468 2771 48709 59362 204 8541   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
31 31 2021-01-27 2717 2915 48573 59231 204 8511   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
32 32 2021-01-26 2824 3134 48491 59133 203 8465   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
33 33 2021-01-25 2957 3303 48388 58981 202 8426   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
34 34 2021-01-24 3150 3349 48291 58885 202 8397   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
35 35 2021-01-23 3383 3451 48155 58689 202 8362   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
36 36 2021-01-22 3656 3530 47987 58388 202 8304   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
37 37 2021-01-21 4041 3837 47777 58167 202 8251   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
38 38 2021-01-20 4268 3743 47560 57830 201 8190   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
39 39 2021-01-19 4511 4062 47404 57619 202 8124   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
40 40 2021-01-18 4713 4201 47285 57405 201 8067   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
41 41 2021-01-16 5041 4595 46921 56868 200 7983   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
42 42 2021-01-15 5283 4683 46607 56476 198 7914   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
43 43 2021-01-14 5687 4715 46241 55911 196 7854   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
44 44 2021-01-13 6002 4554 45857 55534 194 7768   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
45 45 2021-01-11 6531 5374 45441 54962 192 7579   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
46 46 2021-01-10 6586 5413 45149 54691 192 7512   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
47 47 2021-01-09 6594 5323 44780 54296 192 7444   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
48 48 2021-01-08 6661 5495 44336 53735 191 7363   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
49 49 2021-01-07 6732 5512 43769 53100 190 7280   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
50 50 2021-01-06 6871 5431 43218 52343 191 7172   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
51 51 2021-01-05 6953 5887 42884 52058 187 7104   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
52 52 2021-01-04 7098 5655 42567 51687 189 7012   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
53 53 2021-01-03 7183 5985 42232 51403 183 6946   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
54 54 2021-01-02 7389 6089 41872 51018 181 6865   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
55 55 2021-01-01 7509 6075 41316 50405 180 6793   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
56 56 2020-12-31 7516 5802 40545 49472 180 6712   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
57 57 2020-12-30 7549 6030 39846 48658 174 6628   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
58 58 2020-12-29 7436 5544 39291 47950 171 6521   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
59 59 2020-12-28 7464 5915 38931 47538 171 6443   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
60 60 2020-12-24 8067 5835 37662 45920 170 6247   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
61 61 2020-12-23 7846 5809 36426 44495 169 6109   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
62 62 2020-12-22 7699 5589 35949 43945 169 6033   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
63 63 2020-12-21 7510 5973 35474 43427 169 5960   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
64 64 2020-12-20 7367 6056 35042 43027 169 5911   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
65 65 2020-12-19 7202 5797 34476 42385 167 5852   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
66 66 2020-12-18 7054 5693 33796 41526 168 5789   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
67 67 2020-12-17 270 5150 33047 40572 167 5703   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
68 68 2020-12-16 152 4761 32302 39659 167 5665   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
69 69 2020-12-15 151 4866 31847 39122 167 5595   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
70 70 2020-12-14 127 4439 31425 38498 166 5526   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
71 71 2020-12-13 118 4378 30858 37916 167 5488   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
72 72 2020-12-12 221 3896 30216 37331 167 5451   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
73 73 2020-12-11 109 3683 29585 36743 164 5405   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
74 74 2020-12-10 104 3248 28992 36042 163 5362   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
75 75 2020-12-09 104 3282 28571 35648 163 5317   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
76 76 2020-12-08 85 3044 28248 35332 163 5275   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
77 77 2020-12-06 83 3084 27669 34630 163 5203   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
78 78 2020-12-05 85 2917 27268 34241 161 5175   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
79 79 2020-12-04 72 2646 26740 33717 161 5148   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
80 80 2020-12-03 81 2451 26268 33279 160 5123   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
81 81 2020-12-02 78 2325 25923 32857 160 5098   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
82 82 2020-11-30 70 2489 25486 32279 159 5059   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
83 83 2020-11-29 46 2324 25323 31949 158 5047   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
84 84 2020-11-28 55 2182 25100 31688 157 5034   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
85 85 2020-11-27 52 2024 24895 31420 157 5014   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
86 86 2020-11-26 83 1941 24629 31075 156 4996   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
87 87 2020-11-25 46 1806 24356 30842 156 4970   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
88 88 2020-11-24 53 1698 24209 30632 155 4954   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
89 89 2020-11-23 34 1778 24063 30494 155 4934   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
90 90 2020-11-22 46 1789 23950 30335 155 4921   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
91 91 2020-11-21 67 1495 23736 30082 155 4907   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
92 92 2020-11-20 58 1783 23440 29924 155 4892   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
93 93 2020-11-19 47 1543 23155 29614 155 4876   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
94 94 2020-11-18 35 1427 22943 29403 155 4861   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
95 95 2020-11-17 26 1368 22854 29327 155 4848   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
96 96 2020-11-16 27 1523 22719 29229 154 4836   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
97 97 2020-11-15 32 1233 22457 28851 154 4817   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
98 98 2020-11-14 32 1233 22457 28851 154 4817   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
99 99 2020-11-13 29 1232 22270 28722 154 4802   https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx
100 100 2020-11-12 21 1070 22035 28450 154 4793   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
);