cdph-hospital-patient-county-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.
- county
- The name of the county.
- fips
- The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
- 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.
56,333 rows sorted by positive_patients
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | fips | positive_patients ▼ | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
5 | 5 | 2022-12-29 | Colusa | 11 | 0 | 0 | 0 | 0 | 0 |
10 | 10 | 2022-12-29 | Glenn | 21 | 0 | 0 | 0 | 0 | 0 |
13 | 13 | 2022-12-29 | Inyo | 27 | 0 | 0 | 0 | 0 | 4 |
17 | 17 | 2022-12-29 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
21 | 21 | 2022-12-29 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
24 | 24 | 2022-12-29 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
25 | 25 | 2022-12-29 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
31 | 31 | 2022-12-29 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
45 | 45 | 2022-12-29 | Siskiyou | 93 | 0 | 0 | 0 | 0 | 3 |
49 | 49 | 2022-12-29 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
51 | 51 | 2022-12-29 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
61 | 61 | 2022-12-28 | Colusa | 11 | 0 | 0 | 0 | 0 | 0 |
73 | 73 | 2022-12-28 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
77 | 77 | 2022-12-28 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
80 | 80 | 2022-12-28 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
81 | 81 | 2022-12-28 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
105 | 105 | 2022-12-28 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
107 | 107 | 2022-12-28 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
117 | 117 | 2022-12-27 | Colusa | 11 | 0 | 0 | 0 | 0 | 0 |
122 | 122 | 2022-12-27 | Glenn | 21 | 0 | 0 | 0 | 0 | 0 |
129 | 129 | 2022-12-27 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
133 | 133 | 2022-12-27 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
136 | 136 | 2022-12-27 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
137 | 137 | 2022-12-27 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
143 | 143 | 2022-12-27 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
161 | 161 | 2022-12-27 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
163 | 163 | 2022-12-27 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
172 | 172 | 2022-12-26 | Calaveras | 9 | 0 | 0 | 0 | 0 | 2 |
173 | 173 | 2022-12-26 | Colusa | 11 | 0 | 0 | 0 | 0 | 0 |
178 | 178 | 2022-12-26 | Glenn | 21 | 0 | 0 | 0 | 0 | 0 |
185 | 185 | 2022-12-26 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
189 | 189 | 2022-12-26 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
192 | 192 | 2022-12-26 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
193 | 193 | 2022-12-26 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
199 | 199 | 2022-12-26 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
217 | 217 | 2022-12-26 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
219 | 219 | 2022-12-26 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
229 | 229 | 2022-12-25 | Colusa | 11 | 0 | 0 | 0 | 0 | 0 |
234 | 234 | 2022-12-25 | Glenn | 21 | 0 | 0 | 0 | 0 | 0 |
237 | 237 | 2022-12-25 | Inyo | 27 | 0 | 0 | 0 | 0 | 4 |
241 | 241 | 2022-12-25 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
245 | 245 | 2022-12-25 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
248 | 248 | 2022-12-25 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
249 | 249 | 2022-12-25 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
255 | 255 | 2022-12-25 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
273 | 273 | 2022-12-25 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
275 | 275 | 2022-12-25 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
285 | 285 | 2022-12-24 | Colusa | 11 | 0 | 0 | 0 | 0 | 0 |
290 | 290 | 2022-12-24 | Glenn | 21 | 0 | 0 | 0 | 0 | 0 |
293 | 293 | 2022-12-24 | Inyo | 27 | 0 | 0 | 0 | 0 | 4 |
297 | 297 | 2022-12-24 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
301 | 301 | 2022-12-24 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
305 | 305 | 2022-12-24 | Mono | 51 | 0 | 0 | 0 | 0 | 1 |
311 | 311 | 2022-12-24 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
329 | 329 | 2022-12-24 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
331 | 331 | 2022-12-24 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
341 | 341 | 2022-12-23 | Colusa | 11 | 0 | 0 | 0 | 0 | 0 |
349 | 349 | 2022-12-23 | Inyo | 27 | 0 | 0 | 0 | 0 | 3 |
353 | 353 | 2022-12-23 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
357 | 357 | 2022-12-23 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
360 | 360 | 2022-12-23 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
361 | 361 | 2022-12-23 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
367 | 367 | 2022-12-23 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
381 | 381 | 2022-12-23 | Siskiyou | 93 | 0 | 0 | 0 | 0 | 3 |
385 | 385 | 2022-12-23 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
387 | 387 | 2022-12-23 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
396 | 396 | 2022-12-22 | Calaveras | 9 | 0 | 0 | 0 | 0 | 1 |
397 | 397 | 2022-12-22 | Colusa | 11 | 0 | 0 | 0 | 0 | 0 |
405 | 405 | 2022-12-22 | Inyo | 27 | 0 | 0 | 0 | 0 | 3 |
409 | 409 | 2022-12-22 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
413 | 413 | 2022-12-22 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
416 | 416 | 2022-12-22 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
417 | 417 | 2022-12-22 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
423 | 423 | 2022-12-22 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
437 | 437 | 2022-12-22 | Siskiyou | 93 | 0 | 0 | 0 | 0 | 4 |
441 | 441 | 2022-12-22 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
443 | 443 | 2022-12-22 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
452 | 452 | 2022-12-21 | Calaveras | 9 | 0 | 0 | 0 | 0 | 3 |
453 | 453 | 2022-12-21 | Colusa | 11 | 0 | 0 | 0 | 0 | 0 |
461 | 461 | 2022-12-21 | Inyo | 27 | 0 | 0 | 0 | 0 | 3 |
465 | 465 | 2022-12-21 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
469 | 469 | 2022-12-21 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
472 | 472 | 2022-12-21 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
497 | 497 | 2022-12-21 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
499 | 499 | 2022-12-21 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
508 | 508 | 2022-12-20 | Calaveras | 9 | 0 | 0 | 0 | 0 | 2 |
509 | 509 | 2022-12-20 | Colusa | 11 | 0 | 0 | 0 | 0 | 0 |
521 | 521 | 2022-12-20 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
525 | 525 | 2022-12-20 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
528 | 528 | 2022-12-20 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
553 | 553 | 2022-12-20 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
555 | 555 | 2022-12-20 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
577 | 577 | 2022-12-19 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
581 | 581 | 2022-12-19 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
584 | 584 | 2022-12-19 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
591 | 591 | 2022-12-19 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
609 | 609 | 2022-12-19 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
611 | 611 | 2022-12-19 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
633 | 633 | 2022-12-18 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
637 | 637 | 2022-12-18 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "cdph-hospital-patient-county-totals" ( [date] TEXT, [county] TEXT, [fips] INTEGER, [positive_patients] INTEGER, [suspected_patients] INTEGER, [icu_positive_patients] INTEGER, [icu_suspected_patients] INTEGER, [icu_available_beds] INTEGER );