cdph-skilled-nursing-totals
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- date
- The date when the data were retrieved in ISO 8601 format.
- staff_active_cases
- The number of active coronavirus case among staff at that time.
- patients_active_cases
- The number of active coronavirus case amoung patients at that time.
- staff_confirmed_cases
- The cumulative number of confirmed coronavirus case among staff at that time.
- patients_confirmed_cases
- The cumulative number of confirmed coronavirus case among patients at that time.
- staff_deaths
- The cumulative number of deaths case among staff at that time.
- patients_deaths
- The cumulative number of deaths case among patients at that time.
- staff_deaths_note
- In cases where the staff_deaths are obscured, this explains the range of possible values.
- source_url
- The URL to the state data release.
591 rows sorted by staff_active_cases descending
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 |
---|---|---|---|---|---|---|---|---|---|
567 | 567 | 2020-05-28 | 5429 | 9209 | 64 | 1701 | |||
568 | 568 | 2020-05-27 | 5245 | 9028 | 61 | 1632 | |||
569 | 569 | 2020-05-22 | 7908 | 1434 | |||||
570 | 570 | 2020-05-21 | 7908 | 1434 | |||||
571 | 571 | 2020-05-20 | 7908 | 1434 | |||||
572 | 572 | 2020-05-18 | 2886 | 4856 | 26 | 848 | |||
573 | 573 | 2020-05-15 | 2886 | 4856 | 26 | 848 | |||
574 | 574 | 2020-05-14 | 3492 | 5971 | 21 | 1150 | |||
575 | 575 | 2020-05-12 | 3658 | 6250 | 23 | 1058 | |||
576 | 576 | 2020-05-11 | 3684 | 6025 | 19 | 977 | |||
577 | 577 | 2020-05-10 | 3684 | 6025 | 19 | 977 | |||
578 | 578 | 2020-05-09 | 3665 | 6060 | 18 | 1020 | |||
579 | 579 | 2020-05-08 | 3682 | 6045 | 19 | 1033 | |||
580 | 580 | 2020-05-07 | 3545 | 5709 | 19 | 979 | |||
581 | 581 | 2020-05-06 | 3349 | 5604 | 17 | 929 | |||
582 | 582 | 2020-05-05 | 3091 | 4909 | 15 | 748 | |||
583 | 583 | 2020-05-04 | 3299 | 4782 | 15 | 733 | |||
584 | 584 | 2020-05-02 | 2723 | 4569 | 11 | 644 | |||
585 | 585 | 2020-05-01 | 2775 | 4189 | 1 | 658 | 10 or fewer | ||
586 | 586 | 2020-04-30 | 2697 | 4711 | 11 | 663 | |||
587 | 587 | 2020-04-29 | 2594 | 3923 | 19 | 618 | |||
588 | 588 | 2020-04-28 | 2323 | 3515 | 1 | 578 | 10 or fewer | ||
589 | 589 | 2020-04-25 | 2329 | 3441 | 1 | 545 | 10 or fewer | ||
590 | 590 | 2020-04-24 | 2099 | 3141 | 1 | 486 | 10 or fewer | ||
591 | 591 | 2020-04-19 | 1279 | 1721 | |||||
363 | 363 | 2020-12-24 | 8067 | 5835 | 37662 | 45920 | 170 | 6247 | |
364 | 364 | 2020-12-23 | 7846 | 5809 | 36426 | 44495 | 169 | 6109 | |
365 | 365 | 2020-12-22 | 7699 | 5589 | 35949 | 43945 | 169 | 6033 | |
360 | 360 | 2020-12-30 | 7549 | 6030 | 39846 | 48658 | 174 | 6628 | |
359 | 359 | 2020-12-31 | 7516 | 5802 | 40545 | 49472 | 180 | 6712 | |
366 | 366 | 2020-12-21 | 7510 | 5973 | 35474 | 43427 | 169 | 5960 | |
358 | 358 | 2021-01-01 | 7509 | 6075 | 41316 | 50405 | 180 | 6793 | |
362 | 362 | 2020-12-28 | 7464 | 5915 | 38931 | 47538 | 171 | 6443 | |
361 | 361 | 2020-12-29 | 7436 | 5544 | 39291 | 47950 | 171 | 6521 | |
357 | 357 | 2021-01-02 | 7389 | 6089 | 41872 | 51018 | 181 | 6865 | |
367 | 367 | 2020-12-20 | 7367 | 6056 | 35042 | 43027 | 169 | 5911 | |
368 | 368 | 2020-12-19 | 7202 | 5797 | 34476 | 42385 | 167 | 5852 | |
356 | 356 | 2021-01-03 | 7183 | 5985 | 42232 | 51403 | 183 | 6946 | |
355 | 355 | 2021-01-04 | 7098 | 5655 | 42567 | 51687 | 189 | 7012 | |
369 | 369 | 2020-12-18 | 7054 | 5693 | 33796 | 41526 | 168 | 5789 | |
354 | 354 | 2021-01-05 | 6953 | 5887 | 42884 | 52058 | 187 | 7104 | |
353 | 353 | 2021-01-06 | 6871 | 5431 | 43218 | 52343 | 191 | 7172 | |
352 | 352 | 2021-01-07 | 6732 | 5512 | 43769 | 53100 | 190 | 7280 | |
351 | 351 | 2021-01-08 | 6661 | 5495 | 44336 | 53735 | 191 | 7363 | |
350 | 350 | 2021-01-09 | 6594 | 5323 | 44780 | 54296 | 192 | 7444 | |
349 | 349 | 2021-01-10 | 6586 | 5413 | 45149 | 54691 | 192 | 7512 | |
348 | 348 | 2021-01-11 | 6531 | 5374 | 45441 | 54962 | 192 | 7579 | |
347 | 347 | 2021-01-13 | 6002 | 4554 | 45857 | 55534 | 194 | 7768 | |
346 | 346 | 2021-01-14 | 5687 | 4715 | 46241 | 55911 | 196 | 7854 | |
345 | 345 | 2021-01-15 | 5283 | 4683 | 46607 | 56476 | 198 | 7914 | |
344 | 344 | 2021-01-16 | 5041 | 4595 | 46921 | 56868 | 200 | 7983 | |
343 | 343 | 2021-01-18 | 4713 | 4201 | 47285 | 57405 | 201 | 8067 | |
342 | 342 | 2021-01-19 | 4511 | 4062 | 47404 | 57619 | 202 | 8124 | |
341 | 341 | 2021-01-20 | 4268 | 3743 | 47560 | 57830 | 201 | 8190 | |
340 | 340 | 2021-01-21 | 4041 | 3837 | 47777 | 58167 | 202 | 8251 | |
339 | 339 | 2021-01-22 | 3656 | 3530 | 47987 | 58388 | 202 | 8304 | |
338 | 338 | 2021-01-23 | 3383 | 3451 | 48155 | 58689 | 202 | 8362 | |
1 | 1 | 2022-01-14 | 3201 | 10869 | 69485 | 72360 | 242 | 9484 | |
337 | 337 | 2021-01-24 | 3150 | 3349 | 48291 | 58885 | 202 | 8397 | |
336 | 336 | 2021-01-25 | 2957 | 3303 | 48388 | 58981 | 202 | 8426 | |
2 | 2 | 2022-01-13 | 2829 | 10455 | 68469 | 71525 | 242 | 9474 | |
335 | 335 | 2021-01-26 | 2824 | 3134 | 48491 | 59133 | 203 | 8465 | |
334 | 334 | 2021-01-27 | 2717 | 2915 | 48573 | 59231 | 204 | 8511 | |
3 | 3 | 2022-01-12 | 2528 | 10146 | 67547 | 70852 | 242 | 9463 | |
333 | 333 | 2021-01-28 | 2468 | 2771 | 48709 | 59362 | 204 | 8541 | |
332 | 332 | 2021-01-29 | 2225 | 2659 | 48832 | 59505 | 204 | 8568 | |
4 | 4 | 2022-01-11 | 2020 | 9673 | 66578 | 70139 | 242 | 9452 | |
5 | 5 | 2022-01-10 | 1912 | 9141 | 65776 | 69708 | 242 | 9445 | |
331 | 331 | 2021-01-31 | 1861 | 2384 | 49010 | 59801 | 206 | 8616 | |
7 | 7 | 2022-01-08 | 1777 | 7919 | 64325 | 69034 | 242 | 9434 | |
330 | 330 | 2021-02-01 | 1763 | 2247 | 49048 | 59876 | 207 | 8630 | |
6 | 6 | 2022-01-09 | 1762 | 8514 | 65014 | 69370 | 242 | 9441 | |
329 | 329 | 2021-02-02 | 1692 | 2245 | 49106 | 59936 | 208 | 8664 | |
8 | 8 | 2022-01-07 | 1663 | 7287 | 63574 | 68532 | 242 | 9423 | |
328 | 328 | 2021-02-03 | 1574 | 2087 | 49144 | 60013 | 210 | 8690 | |
327 | 327 | 2021-02-04 | 1424 | 2013 | 49211 | 60093 | 215 | 8713 | |
9 | 9 | 2022-01-06 | 1369 | 6419 | 62568 | 68063 | 242 | 9418 | |
326 | 326 | 2021-02-05 | 1288 | 1896 | 49285 | 60191 | 216 | 8732 | |
10 | 10 | 2022-01-05 | 1210 | 5655 | 61690 | 67688 | 253 | 9415 | |
325 | 325 | 2021-02-06 | 1171 | 1690 | 49337 | 60270 | 218 | 8755 | |
324 | 324 | 2021-02-07 | 1094 | 1610 | 49362 | 60297 | 219 | 8762 | |
323 | 323 | 2021-02-08 | 1035 | 1580 | 49434 | 60370 | 219 | 8780 | |
11 | 11 | 2022-01-04 | 988 | 4734 | 60668 | 67268 | 253 | 9403 | |
322 | 322 | 2021-02-09 | 967 | 1543 | 49555 | 60420 | 219 | 8794 | |
321 | 321 | 2021-02-10 | 917 | 1374 | 49585 | 60445 | 219 | 8808 | |
12 | 12 | 2022-01-03 | 897 | 4203 | 60074 | 67066 | 253 | 9395 | |
14 | 14 | 2022-01-01 | 840 | 3341 | 59188 | 66860 | 256 | 9394 | |
320 | 320 | 2021-02-11 | 816 | 1351 | 49621 | 60498 | 219 | 8827 | |
13 | 13 | 2022-01-02 | 809 | 3747 | 59622 | 66995 | 253 | 9396 | |
319 | 319 | 2021-02-12 | 738 | 1227 | 49666 | 60546 | 219 | 8840 | |
137 | 137 | 2021-08-29 | 730 | 384 | 53226 | 62956 | 245 | 9142 | |
138 | 138 | 2021-08-28 | 729 | 386 | 53202 | 62934 | 245 | 9142 | |
135 | 135 | 2021-08-31 | 728 | 400 | 53309 | 62998 | 246 | 9149 | |
136 | 136 | 2021-08-30 | 728 | 425 | 53264 | 62971 | 246 | 9147 | |
143 | 143 | 2021-08-23 | 727 | 401 | 52916 | 62717 | 245 | 9134 | |
139 | 139 | 2021-08-27 | 724 | 356 | 53154 | 62882 | 245 | 9139 | |
15 | 15 | 2021-12-31 | 720 | 2820 | 58638 | 66642 | 254 | 9390 | |
134 | 134 | 2021-09-01 | 720 | 410 | 53355 | 63043 | 246 | 9154 | |
142 | 142 | 2021-08-24 | 717 | 358 | 52955 | 62746 | 245 | 9135 | |
140 | 140 | 2021-08-26 | 714 | 429 | 53086 | 62841 | 245 | 9138 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "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 );