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_available_beds
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds ▼ |
---|---|---|---|---|---|---|---|
358 | 358 | 2022-01-06 | 9279 | 578 | 1500 | 56 | 1546 |
340 | 340 | 2022-01-24 | 15248 | 535 | 2600 | 56 | 1548 |
322 | 322 | 2022-02-11 | 8756 | 532 | 1783 | 45 | 1553 |
327 | 327 | 2022-02-06 | 10595 | 432 | 2101 | 51 | 1554 |
324 | 324 | 2022-02-09 | 9707 | 421 | 1902 | 57 | 1557 |
475 | 475 | 2021-09-11 | 6875 | 372 | 1879 | 36 | 1562 |
470 | 470 | 2021-09-16 | 6415 | 385 | 1812 | 42 | 1563 |
477 | 477 | 2021-09-09 | 7360 | 358 | 1962 | 33 | 1564 |
482 | 482 | 2021-09-04 | 7764 | 368 | 2008 | 43 | 1564 |
752 | 752 | 2020-12-08 | 11012 | 953 | 2506 | 121 | 1566 |
755 | 755 | 2020-12-05 | 9740 | 884 | 2281 | 112 | 1567 |
321 | 321 | 2022-02-12 | 8388 | 446 | 1677 | 49 | 1571 |
359 | 359 | 2022-01-05 | 8671 | 568 | 1430 | 53 | 1574 |
491 | 491 | 2021-08-26 | 8342 | 405 | 2005 | 41 | 1574 |
23 | 23 | 2022-12-07 | 4387 | 627 | 487 | 69 | 1575 |
325 | 325 | 2022-02-08 | 10009 | 380 | 1958 | 49 | 1579 |
323 | 323 | 2022-02-10 | 9241 | 448 | 1841 | 49 | 1585 |
354 | 354 | 2022-01-10 | 11815 | 532 | 1813 | 56 | 1601 |
489 | 489 | 2021-08-28 | 8220 | 388 | 2043 | 46 | 1601 |
29 | 29 | 2022-12-01 | 3942 | 591 | 441 | 79 | 1603 |
486 | 486 | 2021-08-31 | 8353 | 413 | 2096 | 27 | 1603 |
355 | 355 | 2022-01-09 | 11048 | 536 | 1710 | 44 | 1604 |
496 | 496 | 2021-08-21 | 7882 | 427 | 1878 | 43 | 1604 |
469 | 469 | 2021-09-17 | 6255 | 359 | 1785 | 44 | 1605 |
679 | 679 | 2021-02-19 | 7148 | 599 | 2089 | 79 | 1610 |
681 | 681 | 2021-02-17 | 7904 | 662 | 2341 | 86 | 1610 |
490 | 490 | 2021-08-27 | 8277 | 398 | 1986 | 52 | 1611 |
463 | 463 | 2021-09-23 | 5782 | 352 | 1633 | 26 | 1618 |
471 | 471 | 2021-09-15 | 6553 | 422 | 1815 | 53 | 1619 |
387 | 387 | 2021-12-08 | 3401 | 362 | 861 | 35 | 1622 |
386 | 386 | 2021-12-09 | 3345 | 306 | 847 | 33 | 1623 |
28 | 28 | 2022-12-02 | 4039 | 570 | 465 | 77 | 1626 |
30 | 30 | 2022-11-30 | 3793 | 605 | 408 | 84 | 1626 |
9 | 9 | 2022-12-21 | 4520 | 599 | 522 | 64 | 1627 |
497 | 497 | 2021-08-20 | 7833 | 458 | 1885 | 44 | 1627 |
756 | 756 | 2020-12-04 | 9453 | 833 | 2182 | 83 | 1628 |
683 | 683 | 2021-02-15 | 8479 | 616 | 2487 | 117 | 1629 |
680 | 680 | 2021-02-18 | 7514 | 642 | 2207 | 84 | 1631 |
464 | 464 | 2021-09-22 | 5840 | 356 | 1664 | 44 | 1641 |
478 | 478 | 2021-09-08 | 7511 | 375 | 2009 | 56 | 1642 |
682 | 682 | 2021-02-16 | 8215 | 640 | 2439 | 94 | 1643 |
15 | 15 | 2022-12-15 | 4428 | 673 | 531 | 71 | 1646 |
379 | 379 | 2021-12-16 | 3590 | 324 | 938 | 33 | 1647 |
380 | 380 | 2021-12-15 | 3614 | 357 | 936 | 35 | 1649 |
472 | 472 | 2021-09-14 | 6655 | 401 | 1837 | 104 | 1649 |
326 | 326 | 2022-02-07 | 10412 | 424 | 2007 | 50 | 1650 |
31 | 31 | 2022-11-29 | 3737 | 610 | 384 | 82 | 1651 |
360 | 360 | 2022-01-04 | 8032 | 590 | 1390 | 55 | 1651 |
24 | 24 | 2022-12-06 | 4321 | 671 | 463 | 81 | 1653 |
468 | 468 | 2021-09-18 | 6024 | 374 | 1753 | 42 | 1664 |
384 | 384 | 2021-12-11 | 3445 | 355 | 906 | 41 | 1666 |
498 | 498 | 2021-08-19 | 7817 | 419 | 1841 | 38 | 1668 |
315 | 315 | 2022-02-18 | 6495 | 449 | 1300 | 43 | 1670 |
27 | 27 | 2022-12-03 | 3889 | 567 | 441 | 70 | 1671 |
493 | 493 | 2021-08-24 | 8308 | 401 | 2012 | 64 | 1671 |
504 | 504 | 2021-08-13 | 6844 | 378 | 1588 | 39 | 1671 |
377 | 377 | 2021-12-18 | 3557 | 317 | 951 | 38 | 1672 |
378 | 378 | 2021-12-17 | 3589 | 326 | 929 | 38 | 1672 |
465 | 465 | 2021-09-21 | 5986 | 386 | 1693 | 50 | 1673 |
757 | 757 | 2020-12-03 | 9065 | 883 | 2152 | 96 | 1673 |
462 | 462 | 2021-09-24 | 5597 | 372 | 1577 | 31 | 1677 |
317 | 317 | 2022-02-16 | 7271 | 406 | 1438 | 47 | 1679 |
320 | 320 | 2022-02-13 | 8189 | 406 | 1629 | 48 | 1679 |
753 | 753 | 2020-12-07 | 10567 | 944 | 2417 | 109 | 1679 |
678 | 678 | 2021-02-20 | 6704 | 609 | 2003 | 70 | 1682 |
495 | 495 | 2021-08-22 | 8084 | 404 | 1914 | 54 | 1692 |
316 | 316 | 2022-02-17 | 6896 | 400 | 1373 | 45 | 1694 |
473 | 473 | 2021-09-13 | 6810 | 413 | 1853 | 42 | 1696 |
480 | 480 | 2021-09-06 | 7705 | 419 | 2016 | 47 | 1696 |
487 | 487 | 2021-08-30 | 8342 | 424 | 2128 | 44 | 1696 |
499 | 499 | 2021-08-18 | 7779 | 426 | 1772 | 57 | 1696 |
474 | 474 | 2021-09-12 | 6844 | 410 | 1870 | 43 | 1706 |
373 | 373 | 2021-12-22 | 3622 | 383 | 949 | 46 | 1708 |
383 | 383 | 2021-12-12 | 3465 | 339 | 937 | 30 | 1708 |
365 | 365 | 2021-12-30 | 5498 | 409 | 1116 | 55 | 1709 |
481 | 481 | 2021-09-05 | 7736 | 384 | 1999 | 48 | 1709 |
461 | 461 | 2021-09-25 | 5440 | 369 | 1569 | 31 | 1711 |
479 | 479 | 2021-09-07 | 7649 | 376 | 2037 | 51 | 1712 |
754 | 754 | 2020-12-06 | 10070 | 928 | 2360 | 110 | 1714 |
14 | 14 | 2022-12-16 | 4413 | 594 | 528 | 72 | 1718 |
506 | 506 | 2021-08-11 | 6629 | 418 | 1504 | 51 | 1722 |
16 | 16 | 2022-12-14 | 4508 | 667 | 511 | 74 | 1725 |
381 | 381 | 2021-12-14 | 3613 | 339 | 929 | 27 | 1725 |
374 | 374 | 2021-12-21 | 3589 | 373 | 937 | 41 | 1726 |
426 | 426 | 2021-10-30 | 3802 | 384 | 969 | 41 | 1729 |
758 | 758 | 2020-12-02 | 8831 | 871 | 2066 | 81 | 1731 |
427 | 427 | 2021-10-29 | 3866 | 350 | 982 | 52 | 1732 |
505 | 505 | 2021-08-12 | 6692 | 371 | 1524 | 44 | 1733 |
675 | 675 | 2021-02-23 | 6185 | 579 | 1778 | 64 | 1734 |
364 | 364 | 2021-12-31 | 5882 | 461 | 1161 | 48 | 1736 |
388 | 388 | 2021-12-07 | 3356 | 359 | 857 | 40 | 1740 |
458 | 458 | 2021-09-28 | 5180 | 369 | 1444 | 35 | 1740 |
488 | 488 | 2021-08-29 | 8268 | 411 | 2077 | 41 | 1740 |
406 | 406 | 2021-11-19 | 3268 | 273 | 906 | 28 | 1741 |
428 | 428 | 2021-10-28 | 3816 | 340 | 984 | 32 | 1741 |
494 | 494 | 2021-08-23 | 8245 | 430 | 1991 | 57 | 1747 |
392 | 392 | 2021-12-03 | 3220 | 333 | 850 | 39 | 1748 |
393 | 393 | 2021-12-02 | 3203 | 318 | 860 | 35 | 1748 |
394 | 394 | 2021-12-01 | 3187 | 343 | 866 | 42 | 1751 |
414 | 414 | 2021-11-11 | 3585 | 323 | 989 | 34 | 1754 |
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 );