la_times_cdph_skilled_nursing_totals
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
591 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | staff_active_cases | patients_active_cases | staff_confirmed_cases | patients_confirmed_cases | staff_deaths | patients_deaths | staff_deaths_note |
---|---|---|---|---|---|---|---|---|---|
349 | 349 | 2021-01-10 | 6586 | 5413 | 45149 | 54691 | 192 | 7512 | |
350 | 350 | 2021-01-09 | 6594 | 5323 | 44780 | 54296 | 192 | 7444 | |
351 | 351 | 2021-01-08 | 6661 | 5495 | 44336 | 53735 | 191 | 7363 | |
352 | 352 | 2021-01-07 | 6732 | 5512 | 43769 | 53100 | 190 | 7280 | |
353 | 353 | 2021-01-06 | 6871 | 5431 | 43218 | 52343 | 191 | 7172 | |
354 | 354 | 2021-01-05 | 6953 | 5887 | 42884 | 52058 | 187 | 7104 | |
355 | 355 | 2021-01-04 | 7098 | 5655 | 42567 | 51687 | 189 | 7012 | |
356 | 356 | 2021-01-03 | 7183 | 5985 | 42232 | 51403 | 183 | 6946 | |
357 | 357 | 2021-01-02 | 7389 | 6089 | 41872 | 51018 | 181 | 6865 | |
358 | 358 | 2021-01-01 | 7509 | 6075 | 41316 | 50405 | 180 | 6793 | |
359 | 359 | 2020-12-31 | 7516 | 5802 | 40545 | 49472 | 180 | 6712 | |
360 | 360 | 2020-12-30 | 7549 | 6030 | 39846 | 48658 | 174 | 6628 | |
361 | 361 | 2020-12-29 | 7436 | 5544 | 39291 | 47950 | 171 | 6521 | |
362 | 362 | 2020-12-28 | 7464 | 5915 | 38931 | 47538 | 171 | 6443 | |
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 | |
366 | 366 | 2020-12-21 | 7510 | 5973 | 35474 | 43427 | 169 | 5960 | |
367 | 367 | 2020-12-20 | 7367 | 6056 | 35042 | 43027 | 169 | 5911 | |
368 | 368 | 2020-12-19 | 7202 | 5797 | 34476 | 42385 | 167 | 5852 | |
369 | 369 | 2020-12-18 | 7054 | 5693 | 33796 | 41526 | 168 | 5789 | |
370 | 370 | 2020-12-17 | 270 | 5150 | 33047 | 40572 | 167 | 5703 | |
371 | 371 | 2020-12-16 | 152 | 4761 | 32302 | 39659 | 167 | 5665 | |
372 | 372 | 2020-12-15 | 151 | 4866 | 31847 | 39122 | 167 | 5595 | |
373 | 373 | 2020-12-14 | 127 | 4439 | 31425 | 38498 | 166 | 5526 | |
374 | 374 | 2020-12-13 | 118 | 4378 | 30858 | 37916 | 167 | 5488 | |
375 | 375 | 2020-12-12 | 221 | 3896 | 30216 | 37331 | 167 | 5451 | |
376 | 376 | 2020-12-11 | 109 | 3683 | 29585 | 36743 | 164 | 5405 | |
377 | 377 | 2020-12-10 | 104 | 3248 | 28992 | 36042 | 163 | 5362 | |
378 | 378 | 2020-12-09 | 104 | 3282 | 28571 | 35648 | 163 | 5317 | |
379 | 379 | 2020-12-08 | 85 | 3044 | 28248 | 35332 | 163 | 5275 | |
380 | 380 | 2020-12-06 | 83 | 3084 | 27669 | 34630 | 163 | 5203 | |
381 | 381 | 2020-12-05 | 85 | 2917 | 27268 | 34241 | 161 | 5175 | |
382 | 382 | 2020-12-04 | 72 | 2646 | 26740 | 33717 | 161 | 5148 | |
383 | 383 | 2020-12-03 | 81 | 2451 | 26268 | 33279 | 160 | 5123 | |
384 | 384 | 2020-12-02 | 78 | 2325 | 25923 | 32857 | 160 | 5098 | |
385 | 385 | 2020-11-30 | 70 | 2489 | 25486 | 32279 | 159 | 5059 | |
386 | 386 | 2020-11-29 | 46 | 2324 | 25323 | 31949 | 158 | 5047 | |
387 | 387 | 2020-11-28 | 55 | 2182 | 25100 | 31688 | 157 | 5034 | |
388 | 388 | 2020-11-27 | 52 | 2024 | 24895 | 31420 | 157 | 5014 | |
389 | 389 | 2020-11-26 | 83 | 1941 | 24629 | 31075 | 156 | 4996 | |
390 | 390 | 2020-11-25 | 46 | 1806 | 24356 | 30842 | 156 | 4970 | |
391 | 391 | 2020-11-24 | 53 | 1698 | 24209 | 30632 | 155 | 4954 | |
392 | 392 | 2020-11-23 | 34 | 1778 | 24063 | 30494 | 155 | 4934 | |
393 | 393 | 2020-11-22 | 46 | 1789 | 23950 | 30335 | 155 | 4921 | |
394 | 394 | 2020-11-21 | 67 | 1495 | 23736 | 30082 | 155 | 4907 | |
395 | 395 | 2020-11-20 | 58 | 1783 | 23440 | 29924 | 155 | 4892 | |
396 | 396 | 2020-11-19 | 47 | 1543 | 23155 | 29614 | 155 | 4876 | |
397 | 397 | 2020-11-18 | 35 | 1427 | 22943 | 29403 | 155 | 4861 | |
398 | 398 | 2020-11-17 | 26 | 1368 | 22854 | 29327 | 155 | 4848 | |
399 | 399 | 2020-11-16 | 27 | 1523 | 22719 | 29229 | 154 | 4836 | |
400 | 400 | 2020-11-15 | 32 | 1233 | 22457 | 28851 | 154 | 4817 | |
401 | 401 | 2020-11-14 | 32 | 1233 | 22457 | 28851 | 154 | 4817 | |
402 | 402 | 2020-11-13 | 29 | 1232 | 22270 | 28722 | 154 | 4802 | |
403 | 403 | 2020-11-12 | 21 | 1070 | 22035 | 28450 | 154 | 4793 | |
404 | 404 | 2020-11-11 | 23 | 1052 | 21912 | 28308 | 154 | 4789 | |
405 | 405 | 2020-11-10 | 23 | 1030 | 21833 | 28250 | 154 | 4779 | |
406 | 406 | 2020-11-09 | 25 | 1001 | 21762 | 28192 | 154 | 4770 | |
407 | 407 | 2020-11-08 | 19 | 998 | 21688 | 28143 | 154 | 4767 | |
408 | 408 | 2020-11-07 | 24 | 981 | 21592 | 27986 | 154 | 4761 | |
409 | 409 | 2020-11-06 | 16 | 837 | 21471 | 27884 | 154 | 4753 | |
410 | 410 | 2020-11-05 | 15 | 726 | 21355 | 27721 | 154 | 4744 | |
411 | 411 | 2020-11-04 | 13 | 641 | 21284 | 27599 | 154 | 4736 | |
412 | 412 | 2020-11-03 | 11 | 689 | 21248 | 27545 | 154 | 4729 | |
413 | 413 | 2020-11-02 | 13 | 681 | 21202 | 27511 | 154 | 4720 | |
414 | 414 | 2020-11-01 | 17 | 613 | 21164 | 27480 | 153 | 4715 | |
415 | 415 | 2020-10-31 | 24 | 641 | 21090 | 27443 | 153 | 4710 | |
416 | 416 | 2020-10-30 | 17 | 696 | 21006 | 27411 | 153 | 4705 | |
417 | 417 | 2020-10-29 | 11 | 757 | 20912 | 27339 | 153 | 4698 | |
418 | 418 | 2020-10-28 | 5 | 680 | 20848 | 27292 | 153 | 4692 | |
419 | 419 | 2020-10-27 | 11 | 716 | 20821 | 27259 | 153 | 4683 | |
420 | 420 | 2020-10-26 | 15 | 737 | 20800 | 27220 | 153 | 4675 | |
421 | 421 | 2020-10-25 | 9 | 703 | 20769 | 27189 | 153 | 4668 | |
422 | 422 | 2020-10-24 | 13 | 663 | 20714 | 27141 | 153 | 4662 | |
423 | 423 | 2020-10-23 | 8 | 786 | 20654 | 27111 | 152 | 4653 | |
424 | 424 | 2020-10-22 | 15 | 759 | 20568 | 27019 | 151 | 4650 | |
425 | 425 | 2020-10-21 | 18 | 726 | 20528 | 26960 | 151 | 4644 | |
426 | 426 | 2020-10-20 | 12 | 658 | 20484 | 26937 | 151 | 4636 | |
427 | 427 | 2020-10-19 | 13 | 790 | 20447 | 26916 | 152 | 4629 | |
428 | 428 | 2020-10-18 | 16 | 720 | 20422 | 26866 | 152 | 4625 | |
429 | 429 | 2020-10-17 | 14 | 702 | 20380 | 26829 | 152 | 4621 | |
430 | 430 | 2020-10-16 | 12 | 643 | 20314 | 26799 | 152 | 4605 | |
431 | 431 | 2020-10-15 | 8 | 673 | 20245 | 26721 | 152 | 4596 | |
432 | 432 | 2020-10-14 | 5 | 563 | 20194 | 26647 | 152 | 4591 | |
433 | 433 | 2020-10-13 | 6 | 722 | 20167 | 26603 | 152 | 4582 | |
434 | 434 | 2020-10-12 | 7 | 701 | 20133 | 26577 | 152 | 4573 | |
435 | 435 | 2020-10-11 | 2 | 682 | 20089 | 26547 | 152 | 4572 | |
436 | 436 | 2020-10-10 | 5 | 747 | 20043 | 26502 | 152 | 4564 | |
437 | 437 | 2020-10-09 | 6 | 767 | 19989 | 26456 | 152 | 4557 | |
438 | 438 | 2020-10-08 | 12 | 748 | 19952 | 26421 | 152 | 4549 | |
439 | 439 | 2020-10-07 | 15 | 773 | 19884 | 26350 | 152 | 4540 | |
440 | 440 | 2020-10-06 | 9 | 817 | 19847 | 26313 | 151 | 4522 | |
441 | 441 | 2020-10-05 | 10 | 846 | 19832 | 26291 | 151 | 4510 | |
442 | 442 | 2020-10-04 | 8 | 869 | 19795 | 26248 | 151 | 4505 | |
443 | 443 | 2020-10-03 | 14 | 901 | 19735 | 26209 | 150 | 4493 | |
444 | 444 | 2020-10-02 | 17 | 920 | 19674 | 26168 | 150 | 4488 | |
445 | 445 | 2020-10-01 | 21 | 949 | 19617 | 26104 | 149 | 4475 | |
446 | 446 | 2020-09-30 | 19 | 929 | 19529 | 26037 | 149 | 4469 | |
447 | 447 | 2020-09-29 | 22 | 981 | 19492 | 25991 | 149 | 4457 | |
448 | 448 | 2020-09-28 | 22 | 1058 | 19459 | 25955 | 149 | 4439 |
Advanced export
JSON shape: default, array, newline-delimited
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 );