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
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 |
---|---|---|---|---|---|---|---|---|---|
525 | 525 | 2020-07-13 | 52 | 2382 | 10593 | 15578 | 99 | 2775 | |
535 | 535 | 2020-07-01 | 52 | 2155 | 8900 | 13694 | 92 | 2496 | |
543 | 543 | 2020-06-23 | 52 | 2004 | 7739 | 12400 | 91 | 2321 | |
391 | 391 | 2020-11-24 | 53 | 1698 | 24209 | 30632 | 155 | 4954 | |
479 | 479 | 2020-08-28 | 53 | 2025 | 17498 | 23670 | 141 | 4028 | |
526 | 526 | 2020-07-12 | 53 | 2361 | 10457 | 15400 | 99 | 2753 | |
534 | 534 | 2020-07-02 | 53 | 1994 | 9047 | 13923 | 93 | 2524 | |
201 | 201 | 2021-06-24 | 54 | 28 | 51047 | 61589 | 231 | 9062 | |
527 | 527 | 2020-07-11 | 54 | 2030 | 10262 | 15267 | 99 | 2723 | |
555 | 555 | 2020-06-11 | 54 | 2378 | 6584 | 11010 | 67 | 2068 | |
199 | 199 | 2021-06-26 | 55 | 39 | 51060 | 61596 | 231 | 9062 | |
204 | 204 | 2021-06-21 | 55 | 34 | 51033 | 61580 | 229 | 9062 | |
387 | 387 | 2020-11-28 | 55 | 2182 | 25100 | 31688 | 157 | 5034 | |
529 | 529 | 2020-07-09 | 55 | 2145 | 9908 | 14886 | 98 | 2667 | |
533 | 533 | 2020-07-03 | 55 | 2030 | 9156 | 14074 | 93 | 2541 | |
203 | 203 | 2021-06-22 | 56 | 31 | 51038 | 61581 | 229 | 9062 | |
205 | 205 | 2021-06-20 | 56 | 37 | 51030 | 61579 | 229 | 9062 | |
206 | 206 | 2021-06-19 | 56 | 37 | 51027 | 61577 | 229 | 9062 | |
522 | 522 | 2020-07-16 | 56 | 2268 | 11093 | 16033 | 102 | 2870 | |
523 | 523 | 2020-07-15 | 56 | 2421 | 10952 | 15898 | 101 | 2843 | |
546 | 546 | 2020-06-20 | 56 | 2149 | 7301 | 11947 | 86 | 2228 | |
547 | 547 | 2020-06-19 | 56 | 2149 | 7301 | 11947 | 86 | 2228 | |
197 | 197 | 2021-06-28 | 57 | 35 | 51066 | 61600 | 231 | 9063 | |
202 | 202 | 2021-06-23 | 57 | 30 | 51044 | 61584 | 229 | 9062 | |
475 | 475 | 2020-09-01 | 57 | 1835 | 17831 | 24061 | 139 | 4104 | |
478 | 478 | 2020-08-29 | 57 | 2010 | 17632 | 23816 | 139 | 4048 | |
395 | 395 | 2020-11-20 | 58 | 1783 | 23440 | 29924 | 155 | 4892 | |
490 | 490 | 2020-08-17 | 58 | 2599 | 16280 | 22236 | 141 | 3729 | |
538 | 538 | 2020-06-28 | 58 | 2093 | 8409 | 13190 | 91 | 2433 | |
554 | 554 | 2020-06-12 | 58 | 2207 | 6624 | 11070 | 67 | 2080 | |
196 | 196 | 2021-06-29 | 59 | 35 | 51073 | 61606 | 231 | 9065 | |
536 | 536 | 2020-06-30 | 59 | 2148 | 9739 | 13538 | 92 | 2480 | |
548 | 548 | 2020-06-18 | 59 | 2192 | 7136 | 11677 | 86 | 2191 | |
551 | 551 | 2020-06-15 | 59 | 2063 | 6854 | 11349 | 82 | 2131 | |
484 | 484 | 2020-08-23 | 60 | 2458 | 17043 | 23111 | 140 | 3918 | |
556 | 556 | 2020-06-10 | 60 | 2659 | 6499 | 10841 | 67 | 2041 | |
557 | 557 | 2020-06-09 | 60 | 2157 | 6381 | 10716 | 64 | 2003 | |
495 | 495 | 2020-08-12 | 61 | 2855 | 15573 | 21272 | 129 | 3601 | |
564 | 564 | 2020-06-02 | 61 | 2662 | 5746 | 9749 | 52 | 1835 | |
483 | 483 | 2020-08-24 | 62 | 2545 | 17134 | 23242 | 140 | 3933 | |
494 | 494 | 2020-08-13 | 62 | 2756 | 15731 | 21470 | 130 | 3636 | |
195 | 195 | 2021-06-30 | 63 | 29 | 51080 | 61609 | 231 | 9065 | |
207 | 207 | 2021-06-18 | 63 | 34 | 51025 | 61576 | 229 | 9062 | |
488 | 488 | 2020-08-19 | 63 | 2713 | 16510 | 22423 | 140 | 3797 | |
489 | 489 | 2020-08-18 | 63 | 2621 | 16385 | 22307 | 140 | 3770 | |
491 | 491 | 2020-08-16 | 63 | 2708 | 16211 | 22053 | 132 | 3710 | |
492 | 492 | 2020-08-15 | 63 | 2712 | 16072 | 21868 | 132 | 3689 | |
493 | 493 | 2020-08-14 | 63 | 2806 | 15898 | 21716 | 130 | 3666 | |
537 | 537 | 2020-06-29 | 63 | 2296 | 8570 | 13403 | 91 | 2460 | |
480 | 480 | 2020-08-27 | 64 | 2131 | 17381 | 23541 | 139 | 4000 | |
559 | 559 | 2020-06-07 | 64 | 2635 | 6204 | 10480 | 60 | 1972 | |
566 | 566 | 2020-05-29 | 64 | 2930 | 5490 | 9273 | 45 | 1735 | |
499 | 499 | 2020-08-08 | 65 | 2848 | 15067 | 20546 | 129 | 3491 | |
496 | 496 | 2020-08-11 | 66 | 2899 | 15457 | 21050 | 129 | 3569 | |
553 | 553 | 2020-06-13 | 66 | 2185 | 6706 | 11146 | 68 | 2096 | |
560 | 560 | 2020-06-06 | 66 | 2612 | 6099 | 10308 | 57 | 1958 | |
561 | 561 | 2020-06-05 | 66 | 2701 | 5981 | 10151 | 56 | 1933 | |
394 | 394 | 2020-11-21 | 67 | 1495 | 23736 | 30082 | 155 | 4907 | |
532 | 532 | 2020-07-06 | 67 | 2335 | 9499 | 14515 | 95 | 2591 | |
481 | 481 | 2020-08-26 | 68 | 2151 | 17280 | 23402 | 141 | 3976 | |
539 | 539 | 2020-06-27 | 68 | 2107 | 8080 | 12666 | 86 | 2341 | |
563 | 563 | 2020-06-03 | 69 | 2644 | 5825 | 9903 | 54 | 1874 | |
385 | 385 | 2020-11-30 | 70 | 2489 | 25486 | 32279 | 159 | 5059 | |
482 | 482 | 2020-08-25 | 70 | 2448 | 17205 | 23326 | 140 | 3958 | |
528 | 528 | 2020-07-10 | 70 | 2294 | 10043 | 15039 | 98 | 2697 | |
382 | 382 | 2020-12-04 | 72 | 2646 | 26740 | 33717 | 161 | 5148 | |
208 | 208 | 2021-06-17 | 73 | 36 | 51019 | 61575 | 229 | 9062 | |
505 | 505 | 2020-08-02 | 73 | 3000 | 14275 | 19519 | 121 | 3332 | |
517 | 517 | 2020-07-21 | 73 | 2473 | 12029 | 16908 | 104 | 2980 | |
504 | 504 | 2020-08-03 | 74 | 2991 | 14374 | 19639 | 121 | 3355 | |
521 | 521 | 2020-07-17 | 74 | 2318 | 11293 | 16206 | 103 | 2898 | |
531 | 531 | 2020-07-07 | 74 | 2278 | 9641 | 14646 | 97 | 2618 | |
558 | 558 | 2020-06-08 | 74 | 2639 | 6265 | 10579 | 62 | 1985 | |
524 | 524 | 2020-07-14 | 75 | 2314 | 10784 | 15678 | 101 | 2804 | |
530 | 530 | 2020-07-08 | 75 | 2253 | 9765 | 14750 | 97 | 2646 | |
194 | 194 | 2021-07-01 | 76 | 46 | 51095 | 61612 | 231 | 9065 | |
500 | 500 | 2020-08-07 | 76 | 2902 | 14919 | 20359 | 126 | 3463 | |
212 | 212 | 2021-06-11 | 77 | 49 | 51000 | 61558 | 229 | 9061 | |
209 | 209 | 2021-06-16 | 78 | 37 | 51017 | 61575 | 229 | 9062 | |
210 | 210 | 2021-06-13 | 78 | 47 | 51007 | 61569 | 229 | 9061 | |
211 | 211 | 2021-06-12 | 78 | 44 | 51005 | 61564 | 229 | 9061 | |
215 | 215 | 2021-06-08 | 78 | 32 | 50982 | 61549 | 229 | 9060 | |
384 | 384 | 2020-12-02 | 78 | 2325 | 25923 | 32857 | 160 | 5098 | |
503 | 503 | 2020-08-04 | 78 | 2910 | 14513 | 19772 | 121 | 3381 | |
512 | 512 | 2020-07-26 | 78 | 2648 | 12981 | 18088 | 119 | 3118 | |
562 | 562 | 2020-06-04 | 78 | 2697 | 5895 | 10012 | 55 | 1908 | |
214 | 214 | 2021-06-09 | 79 | 41 | 50987 | 61554 | 229 | 9061 | |
221 | 221 | 2021-06-02 | 79 | 37 | 50939 | 61524 | 229 | 9058 | |
213 | 213 | 2021-06-10 | 81 | 45 | 50993 | 61557 | 229 | 9061 | |
220 | 220 | 2021-06-03 | 81 | 38 | 50946 | 61527 | 229 | 9059 | |
223 | 223 | 2021-05-31 | 81 | 40 | 50929 | 61510 | 229 | 9059 | |
224 | 224 | 2021-05-30 | 81 | 40 | 50929 | 61510 | 229 | 9059 | |
225 | 225 | 2021-05-29 | 81 | 25 | 50927 | 61497 | 229 | 9058 | |
232 | 232 | 2021-05-21 | 81 | 34 | 50874 | 61475 | 229 | 9056 | |
383 | 383 | 2020-12-03 | 81 | 2451 | 26268 | 33279 | 160 | 5123 | |
231 | 231 | 2021-05-22 | 82 | 33 | 50881 | 61477 | 229 | 9056 | |
519 | 519 | 2020-07-19 | 82 | 2536 | 11705 | 16615 | 104 | 2937 | |
520 | 520 | 2020-07-18 | 82 | 2420 | 11487 | 16365 | 104 | 2921 | |
222 | 222 | 2021-06-01 | 83 | 2 | 50935 | 61517 | 229 | 9058 | |
226 | 226 | 2021-05-28 | 83 | 29 | 50923 | 61495 | 229 | 9058 |
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 );