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

590 rows sorted by date descending

✎ View and edit SQL

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

Suggested facets: staff_deaths_note, date (date)

Link rowid date ▲ staff_active_cases patients_active_cases staff_confirmed_cases patients_confirmed_cases staff_deaths patients_deaths staff_deaths_note
1 1 2022-01-13 2829 10455 68469 71525 242 9474  
2 2 2022-01-12 2528 10146 67547 70852 242 9463  
3 3 2022-01-11 2020 9673 66578 70139 242 9452  
4 4 2022-01-10 1912 9141 65776 69708 242 9445  
5 5 2022-01-09 1762 8514 65014 69370 242 9441  
6 6 2022-01-08 1777 7919 64325 69034 242 9434  
7 7 2022-01-07 1663 7287 63574 68532 242 9423  
8 8 2022-01-06 1369 6419 62568 68063 242 9418  
9 9 2022-01-05 1210 5655 61690 67688 253 9415  
10 10 2022-01-04 988 4734 60668 67268 253 9403  
11 11 2022-01-03 897 4203 60074 67066 253 9395  
12 12 2022-01-02 809 3747 59622 66995 253 9396  
13 13 2022-01-01 840 3341 59188 66860 256 9394  
14 14 2021-12-31 720 2820 58638 66642 254 9390  
15 15 2021-12-30 616 2255 58036 66428 253 9389  
16 16 2021-12-29 478 1672 57423 66269 253 9389  
17 17 2021-12-28 373 1194 56927 66144 252 9387  
18 18 2021-12-27 271 940 56657 66049 252 9382  
19 19 2021-12-26 304 816 56522 66009 252 9382  
20 20 2021-12-25 236 734 56428 65962 252 9381  
21 21 2021-12-24 245 638 56309 65922 252 9380  
22 22 2021-12-23 178 523 56171 65856 252 9380  
23 23 2021-12-22 188 434 56061 65820 252 9380  
24 24 2021-12-21 154 357 55960 65773 252 9379  
25 25 2021-12-20 120 318 55897 65750 252 9379  
26 26 2021-12-19 115 306 55875 65741 252 9377  
27 27 2021-12-18 146 291 55847 65736 252 9377  
28 28 2021-12-17 140 284 55818 65725 252 9377  
29 29 2021-12-16 158 273 55781 65715 252 9375  
30 30 2021-12-15 183 275 55751 65701 252 9374  
31 31 2021-12-14 175 282 55733 65674 285 9373  
32 32 2021-12-13 202 288 55717 65653 252 9370  
33 33 2021-12-12 165 287 55706 65644 252 9369  
34 34 2021-12-11 190 293 55694 65631 252 9369  
35 35 2021-12-10 205 284 55671 65619 252 9369  
36 36 2021-12-09 223 275 55648 65604 252 9369  
37 37 2021-12-08 209 273 55627 65583 252 9367  
38 38 2021-12-07 232 276 55603 65565 252 9363  
39 39 2021-12-06 240 267 55579 65541 251 9362  
40 40 2021-12-05 221 276 55569 65529 251 9361  
41 41 2021-12-04 230 272 55556 65515 251 9361  
42 42 2021-12-03 255 271 55534 65490 251 9361  
43 43 2021-12-02 223 264 55508 65449 251 9355  
44 44 2021-12-01 207 237 55476 65430 251 9355  
45 45 2021-11-30 194 217 55451 65395 251 9353  
46 46 2021-11-29 244 206 55429 65378 251 9351  
47 47 2021-11-28 202 202 55419 65333 251 9350  
48 48 2021-11-27 187 196 55401 65320 251 9350  
49 49 2021-11-26 202 201 55387 65294 251 9349  
50 50 2021-11-25 186 215 55373 65276 251 9349  
51 51 2021-11-24 206 221 55354 65250 251 9348  
52 52 2021-11-23 189 218 55327 65225 251 9346  
53 53 2021-11-22 196 219 55311 65207 251 9343  
54 54 2021-11-21 176 204 52351 61458 240 8737  
55 55 2021-11-20 174 206 51933 60934 238 8646  
56 56 2021-11-19 240 201 55257 65152 250 9311  
57 57 2021-11-18 108 203 61147 71507 298 10252  
58 58 2021-11-17 118 228 55237 65115 250 9338  
59 59 2021-11-16 222 250 55232 65107 250 9337  
60 60 2021-11-15 238 270 55221 65104 250 9336  
61 61 2021-11-14 247 292 55215 65102 250 9334  
62 62 2021-11-13 219 295 55203 65097 250 9333  
63 63 2021-11-12 254 301 55184 65072 250 9330  
64 64 2021-11-11 259 306 55156 65048 250 9328  
65 65 2021-11-10 254 311 55131 65023 250 9322  
66 66 2021-11-09 328 308 55107 65009 250 9322  
67 67 2021-11-08 299 313 55091 65000 250 9321  
68 68 2021-11-07 327 318 55079 64991 250 9320  
69 69 2021-11-06 304 326 55070 64962 250 9317  
70 70 2021-11-05 427 345 55055 64946 250 9316  
71 71 2021-11-04 421 346 55033 64906 250 9314  
72 72 2021-11-03 428 354 55009 64861 250 9313  
73 73 2021-11-02 357 354 54982 64801 250 9309  
74 74 2021-11-01 400 339 54951 64768 250 9305  
75 75 2021-10-31 409 327 54923 64750 250 9302  
76 76 2021-10-28 40 270 54821 64607 250 9290  
77 77 2021-10-27 365 290 54818 64607 250 9290  
78 78 2021-10-26 338 285 54798 64555 250 9288  
79 79 2021-10-25 348 278 54777 64538 250 9286  
80 80 2021-10-24 289 274 54760 64505 250 9285  
81 81 2021-10-23 302 271 54743 64468 250 9284  
82 82 2021-10-22 289 254 54709 64421 250 9279  
83 83 2021-10-21 290 266 54686 64373 249 9276  
84 84 2021-10-20 303 265 54654 64333 249 9274  
85 85 2021-10-19 270 265 54627 64286 249 9273  
86 86 2021-10-18 290 269 54611 64251 249 9271  
87 87 2021-10-17 235 276 54595 64220 249 9267  
88 88 2021-10-16 244 279 54583 64202 249 9265  
89 89 2021-10-15 247 279 54570 64160 249 9264  
90 90 2021-10-14 220 288 54551 64131 249 9262  
91 91 2021-10-13 304 296 54528 64105 249 9261  
92 92 2021-10-12 267 309 54513 64081 249 9259  
93 93 2021-10-11 306 321 54499 64063 249 9257  
94 94 2021-10-10 278 328 54486 64052 249 9257  
95 95 2021-10-09 299 322 54472 64029 249 9256  
96 96 2021-10-08 287 328 54455 63988 249 9254  
97 97 2021-10-07 281 340 54420 63974 249 9253  
98 98 2021-10-06 288 339 54389 63948 249 9253  
99 99 2021-10-05 260 337 54362 63925 249 9252  
100 100 2021-10-04 259 337 54342 63893 249 9248  

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
);