cdph-hospital-patient-state-totals
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- date
- The date for which hospital data were reported in ISO 8601 format.
- positive_patients
- The current number confirmed coronavirus cases in hospitals on this date.
- suspected_patients
- The current number suspected coronavirus cases in hospitals on this date.
- icu_positive_patients
- The current number confirmed coronavirus cases in intensive-care units on this date.
- icu_suspected_patients
- The current number suspected coronavirus cases in intensive-care units on this date.
- icu_available_beds
- The current number open and avilable intensive-care beds on this date.
1,006 rows sorted by icu_positive_patients descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | positive_patients | suspected_patients | icu_positive_patients ▲ | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|
719 | 719 | 2021-01-10 | 21664 | 965 | 4868 | 103 | 1242 |
720 | 720 | 2021-01-09 | 21647 | 866 | 4863 | 102 | 1159 |
718 | 718 | 2021-01-11 | 21747 | 918 | 4854 | 108 | 1229 |
721 | 721 | 2021-01-08 | 21754 | 846 | 4854 | 85 | 1173 |
717 | 717 | 2021-01-12 | 21654 | 896 | 4829 | 100 | 1183 |
722 | 722 | 2021-01-07 | 21855 | 981 | 4812 | 93 | 1147 |
716 | 716 | 2021-01-13 | 21282 | 928 | 4770 | 108 | 1094 |
714 | 714 | 2021-01-15 | 20722 | 857 | 4750 | 96 | 1128 |
715 | 715 | 2021-01-14 | 20999 | 858 | 4743 | 88 | 1111 |
723 | 723 | 2021-01-06 | 21938 | 915 | 4742 | 99 | 1210 |
713 | 713 | 2021-01-16 | 20323 | 820 | 4725 | 95 | 1070 |
712 | 712 | 2021-01-17 | 20172 | 830 | 4719 | 107 | 1113 |
711 | 711 | 2021-01-18 | 20062 | 880 | 4693 | 100 | 1177 |
710 | 710 | 2021-01-19 | 19979 | 835 | 4682 | 76 | 1159 |
709 | 709 | 2021-01-20 | 19537 | 871 | 4670 | 76 | 1030 |
724 | 724 | 2021-01-05 | 21923 | 898 | 4636 | 95 | 1311 |
725 | 725 | 2021-01-04 | 21597 | 888 | 4634 | 100 | 1319 |
708 | 708 | 2021-01-21 | 18985 | 870 | 4627 | 91 | 1095 |
726 | 726 | 2021-01-03 | 21128 | 875 | 4584 | 87 | 1337 |
707 | 707 | 2021-01-22 | 18442 | 851 | 4534 | 107 | 1124 |
728 | 728 | 2021-01-01 | 20344 | 859 | 4531 | 75 | 1335 |
729 | 729 | 2020-12-31 | 20540 | 893 | 4524 | 93 | 1291 |
727 | 727 | 2021-01-02 | 20690 | 820 | 4509 | 104 | 1324 |
706 | 706 | 2021-01-23 | 17810 | 828 | 4459 | 83 | 1116 |
730 | 730 | 2020-12-30 | 20640 | 824 | 4432 | 86 | 1237 |
705 | 705 | 2021-01-24 | 17432 | 915 | 4395 | 80 | 1168 |
731 | 731 | 2020-12-29 | 20612 | 821 | 4389 | 89 | 1270 |
704 | 704 | 2021-01-25 | 17236 | 803 | 4315 | 69 | 1166 |
732 | 732 | 2020-12-28 | 20390 | 850 | 4308 | 82 | 1428 |
703 | 703 | 2021-01-26 | 16839 | 871 | 4284 | 91 | 1186 |
733 | 733 | 2020-12-27 | 19766 | 876 | 4228 | 132 | 1385 |
702 | 702 | 2021-01-27 | 16251 | 892 | 4196 | 87 | 1199 |
701 | 701 | 2021-01-28 | 15705 | 876 | 4145 | 87 | 1187 |
734 | 734 | 2020-12-26 | 19237 | 822 | 4123 | 91 | 1475 |
735 | 735 | 2020-12-25 | 18943 | 854 | 4043 | 88 | 1392 |
700 | 700 | 2021-01-29 | 15296 | 828 | 4016 | 87 | 1184 |
737 | 737 | 2020-12-23 | 18875 | 896 | 3962 | 107 | 1302 |
736 | 736 | 2020-12-24 | 18937 | 834 | 3949 | 86 | 1387 |
699 | 699 | 2021-01-30 | 14856 | 820 | 3944 | 103 | 1194 |
698 | 698 | 2021-01-31 | 14443 | 769 | 3857 | 92 | 1290 |
738 | 738 | 2020-12-22 | 18448 | 913 | 3827 | 128 | 1373 |
697 | 697 | 2021-02-01 | 14221 | 778 | 3797 | 97 | 1284 |
739 | 739 | 2020-12-21 | 17843 | 1118 | 3755 | 106 | 1399 |
696 | 696 | 2021-02-02 | 13766 | 812 | 3667 | 105 | 1278 |
740 | 740 | 2020-12-20 | 17190 | 1169 | 3644 | 112 | 1429 |
695 | 695 | 2021-02-03 | 13277 | 861 | 3637 | 119 | 1269 |
741 | 741 | 2020-12-19 | 16843 | 907 | 3614 | 96 | 1353 |
742 | 742 | 2020-12-18 | 16465 | 933 | 3523 | 97 | 1284 |
743 | 743 | 2020-12-17 | 16019 | 946 | 3447 | 106 | 1234 |
694 | 694 | 2021-02-04 | 12863 | 809 | 3432 | 95 | 1318 |
693 | 693 | 2021-02-05 | 12345 | 792 | 3391 | 88 | 1286 |
744 | 744 | 2020-12-16 | 15431 | 995 | 3280 | 112 | 1260 |
692 | 692 | 2021-02-06 | 11695 | 781 | 3260 | 79 | 1300 |
691 | 691 | 2021-02-07 | 11385 | 700 | 3240 | 73 | 1377 |
745 | 745 | 2020-12-15 | 14939 | 947 | 3188 | 109 | 1331 |
690 | 690 | 2021-02-08 | 11198 | 706 | 3164 | 100 | 1384 |
746 | 746 | 2020-12-14 | 14283 | 915 | 3081 | 112 | 1466 |
689 | 689 | 2021-02-09 | 10771 | 745 | 3031 | 96 | 1394 |
747 | 747 | 2020-12-13 | 13635 | 943 | 2967 | 111 | 1424 |
688 | 688 | 2021-02-10 | 10348 | 680 | 2933 | 81 | 1366 |
687 | 687 | 2021-02-11 | 9872 | 622 | 2849 | 81 | 1399 |
748 | 748 | 2020-12-12 | 13047 | 913 | 2820 | 117 | 1412 |
749 | 749 | 2020-12-11 | 12444 | 966 | 2752 | 114 | 1419 |
686 | 686 | 2021-02-12 | 9414 | 584 | 2731 | 77 | 1437 |
750 | 750 | 2020-12-10 | 12013 | 927 | 2669 | 104 | 1450 |
685 | 685 | 2021-02-13 | 8996 | 640 | 2632 | 101 | 1428 |
751 | 751 | 2020-12-09 | 11497 | 980 | 2621 | 89 | 1487 |
339 | 339 | 2022-01-25 | 15279 | 550 | 2609 | 53 | 1464 |
341 | 341 | 2022-01-23 | 15204 | 540 | 2602 | 71 | 1466 |
340 | 340 | 2022-01-24 | 15248 | 535 | 2600 | 56 | 1548 |
337 | 337 | 2022-01-27 | 14674 | 502 | 2585 | 42 | 1449 |
338 | 338 | 2022-01-26 | 15015 | 588 | 2577 | 55 | 1427 |
342 | 342 | 2022-01-22 | 15184 | 595 | 2567 | 73 | 1382 |
684 | 684 | 2021-02-14 | 8727 | 606 | 2562 | 98 | 1530 |
336 | 336 | 2022-01-28 | 14404 | 522 | 2559 | 42 | 1423 |
335 | 335 | 2022-01-29 | 13834 | 496 | 2548 | 58 | 1481 |
343 | 343 | 2022-01-21 | 15435 | 571 | 2541 | 55 | 1380 |
334 | 334 | 2022-01-30 | 13435 | 460 | 2534 | 46 | 1467 |
752 | 752 | 2020-12-08 | 11012 | 953 | 2506 | 121 | 1566 |
333 | 333 | 2022-01-31 | 13367 | 452 | 2494 | 44 | 1528 |
683 | 683 | 2021-02-15 | 8479 | 616 | 2487 | 117 | 1629 |
344 | 344 | 2022-01-20 | 15383 | 567 | 2485 | 59 | 1402 |
345 | 345 | 2022-01-19 | 15393 | 575 | 2467 | 41 | 1338 |
682 | 682 | 2021-02-16 | 8215 | 640 | 2439 | 94 | 1643 |
332 | 332 | 2022-02-01 | 12995 | 452 | 2435 | 51 | 1446 |
753 | 753 | 2020-12-07 | 10567 | 944 | 2417 | 109 | 1679 |
346 | 346 | 2022-01-18 | 15179 | 647 | 2404 | 61 | 1438 |
331 | 331 | 2022-02-02 | 12643 | 438 | 2366 | 53 | 1414 |
754 | 754 | 2020-12-06 | 10070 | 928 | 2360 | 110 | 1714 |
681 | 681 | 2021-02-17 | 7904 | 662 | 2341 | 86 | 1610 |
347 | 347 | 2022-01-17 | 14654 | 597 | 2311 | 66 | 1497 |
330 | 330 | 2022-02-03 | 12134 | 418 | 2283 | 39 | 1434 |
755 | 755 | 2020-12-05 | 9740 | 884 | 2281 | 112 | 1567 |
329 | 329 | 2022-02-04 | 11524 | 417 | 2226 | 50 | 1433 |
680 | 680 | 2021-02-18 | 7514 | 642 | 2207 | 84 | 1631 |
348 | 348 | 2022-01-16 | 14209 | 597 | 2185 | 58 | 1504 |
756 | 756 | 2020-12-04 | 9453 | 833 | 2182 | 83 | 1628 |
757 | 757 | 2020-12-03 | 9065 | 883 | 2152 | 96 | 1673 |
349 | 349 | 2022-01-15 | 13927 | 578 | 2144 | 54 | 1452 |
487 | 487 | 2021-08-30 | 8342 | 424 | 2128 | 44 | 1696 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "cdph-hospital-patient-state-totals" ( [date] TEXT, [positive_patients] INTEGER, [suspected_patients] INTEGER, [icu_positive_patients] INTEGER, [icu_suspected_patients] INTEGER, [icu_available_beds] INTEGER );