home / la-times

Menu
  • GraphQL API

cdph-hospital-patient-state-totals

Table actions
  • GraphQL API for cdph-hospital-patient-state-totals

California's Department of Public Health is releasing county-level hospitalization totals. The file aggregates them statewide.

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

✎ View and edit SQL

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
1 1 2022-12-29 4619 612 517 58 1978
2 2 2022-12-28 4561 613 537 55 2016
3 3 2022-12-27 4432 565 530 60 2147
4 4 2022-12-26 4416 554 510 64 2168
5 5 2022-12-25 4175 550 505 53 2205
6 6 2022-12-24 4275 551 550 70 2025
7 7 2022-12-23 4467 571 524 62 1904
8 8 2022-12-22 4392 549 499 67 1883
9 9 2022-12-21 4520 599 522 64 1627
10 10 2022-12-20 4544 614 515 79 1801
11 11 2022-12-19 4520 583 523 77 1908
12 12 2022-12-18 4388 592 489 81 1910
13 13 2022-12-17 4310 575 490 74 1849
14 14 2022-12-16 4413 594 528 72 1718
15 15 2022-12-15 4428 673 531 71 1646
16 16 2022-12-14 4508 667 511 74 1725
17 17 2022-12-13 4555 608 531 72 1800
18 18 2022-12-12 4471 615 527 80 1943
19 19 2022-12-11 4267 652 504 85 1956
20 20 2022-12-10 4171 644 517 83 1851
21 21 2022-12-09 4290 632 505 83 1793
22 22 2022-12-08 4371 672 506 73 1791
23 23 2022-12-07 4387 627 487 69 1575
24 24 2022-12-06 4321 671 463 81 1653
25 25 2022-12-05 4208 571 493 75 1821
26 26 2022-12-04 4035 577 468 72 1802
27 27 2022-12-03 3889 567 441 70 1671
28 28 2022-12-02 4039 570 465 77 1626
29 29 2022-12-01 3942 591 441 79 1603
30 30 2022-11-30 3793 605 408 84 1626
31 31 2022-11-29 3737 610 384 82 1651
32 32 2022-11-28 3532 570 379 71 1842
33 33 2022-11-27 3290 609 376 71 1936
34 34 2022-11-26 3147 580 367 67 1923
35 35 2022-11-25 3014 537 342 51 1967
36 36 2022-11-24 2883 497 327 48 1858
37 37 2022-11-23 2782 495 340 46 1759
38 38 2022-11-22 2676 524 346 48 1805
39 39 2022-11-21 2598 462 330 44 2001
40 40 2022-11-20 2494 447 327 39 1923
41 41 2022-11-19 2337 414 303 43 1823
42 42 2022-11-18 2327 430 318 40 1781
43 43 2022-11-17 2278 416 306 45 1801
44 44 2022-11-16 2187 403 287 38 1795
45 45 2022-11-15 2094 403 266 35 1898
46 46 2022-11-14 2035 395 260 48 2120
47 47 2022-11-13 2032 416 256 50 1996
48 48 2022-11-12 1942 410 232 48 1904
49 49 2022-11-11 1886 382 234 50 1864
50 50 2022-11-10 1871 395 220 46 1886
51 51 2022-11-09 1842 427 225 55 1964
52 52 2022-11-08 1855 400 225 46 1938
53 53 2022-11-07 1756 393 231 57 2150
54 54 2022-11-06 1719 395 218 55 2081
55 55 2022-11-05 1671 411 198 57 1976
56 56 2022-11-04 1704 383 211 53 2010
57 57 2022-11-03 1730 407 193 48 2048
58 58 2022-11-02 1700 410 196 49 1985
59 59 2022-11-01 1634 353 200 40 2138
60 60 2022-10-31 1592 336 191 41 2223
61 61 2022-10-30 1626 342 203 50 2182
62 62 2022-10-29 1532 354 185 42 2088
63 63 2022-10-28 1569 354 210 37 2039
64 64 2022-10-27 1599 368 208 47 2021
65 65 2022-10-26 1674 327 192 40 1983
66 66 2022-10-25 1537 311 198 46 2011
67 67 2022-10-24 1514 323 190 43 2212
68 68 2022-10-23 1558 312 211 41 2125
69 69 2022-10-22 1555 329 193 46 2074
70 70 2022-10-21 1579 320 186 33 2044
71 71 2022-10-20 1599 353 200 42 2032
72 72 2022-10-19 1617 331 210 33 1989
73 73 2022-10-18 1601 323 212 38 2060
74 74 2022-10-17 1615 322 218 41 2250
75 75 2022-10-16 1649 319 226 40 2244
76 76 2022-10-15 1649 322 224 47 2254
77 77 2022-10-14 1669 294 225 44 2100
78 78 2022-10-13 1700 290 230 40 2120
79 79 2022-10-12 1733 288 232 36 2037
80 80 2022-10-11 1759 282 218 25 2223
81 81 2022-10-10 1765 299 228 34 2271
82 82 2022-10-09 1735 313 220 35 2256
83 83 2022-10-08 1693 326 209 33 2380
84 84 2022-10-07 1755 325 231 29 2289
85 85 2022-10-06 1823 305 233 31 2173
86 86 2022-10-05 1870 313 247 38 2121
87 87 2022-10-04 1896 279 229 41 2247
88 88 2022-10-03 1894 299 247 27 2303
89 89 2022-10-02 1889 320 254 27 2279
90 90 2022-10-01 1803 286 231 21 2106
91 91 2022-09-30 1903 302 235 25 2085
92 92 2022-09-29 1930 420 242 27 2217
93 93 2022-09-28 2001 291 238 28 2160
94 94 2022-09-27 1999 337 243 28 2255
95 95 2022-09-26 2048 328 230 24 2290
96 96 2022-09-25 2064 365 253 29 2232
97 97 2022-09-24 2031 341 260 29 2032
98 98 2022-09-23 2085 375 253 31 2047
99 99 2022-09-22 2133 338 267 30 2098
100 100 2022-09-21 2115 350 283 37 2076

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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
);
Powered by Datasette · Queries took 13.929ms · Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README