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 rows where "date" is on date 2021-01-06
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: suspected_patients
Link | rowid ▼ | date | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
40433 | 40433 | 2021-01-06 | Alameda | 1 | 431 | 50 | 112 | 4 | 69 |
40434 | 40434 | 2021-01-06 | Amador | 5 | 9 | 0 | 4 | 0 | 1 |
40435 | 40435 | 2021-01-06 | Butte | 7 | 86 | 0 | 9 | 0 | 11 |
40436 | 40436 | 2021-01-06 | Calaveras | 9 | 6 | 0 | 3 | 0 | 4 |
40437 | 40437 | 2021-01-06 | Colusa | 11 | 7 | 0 | 0 | 0 | 5 |
40438 | 40438 | 2021-01-06 | Contra Costa | 13 | 273 | 17 | 66 | 2 | 27 |
40439 | 40439 | 2021-01-06 | Del Norte | 15 | 2 | 0 | 1 | 0 | 1 |
40440 | 40440 | 2021-01-06 | El Dorado | 17 | 39 | 0 | 10 | 0 | 3 |
40441 | 40441 | 2021-01-06 | Fresno | 19 | 626 | 29 | 114 | 0 | 8 |
40442 | 40442 | 2021-01-06 | Glenn | 21 | 6 | 0 | 0 | 0 | 0 |
40443 | 40443 | 2021-01-06 | Humboldt | 23 | 8 | 3 | 3 | 2 | 10 |
40444 | 40444 | 2021-01-06 | Imperial | 25 | 174 | 2 | 66 | 0 | 4 |
40445 | 40445 | 2021-01-06 | Inyo | 27 | 8 | 0 | 2 | 0 | 2 |
40446 | 40446 | 2021-01-06 | Kern | 29 | 433 | 13 | 92 | 2 | 13 |
40447 | 40447 | 2021-01-06 | Kings | 31 | 93 | 1 | 16 | 0 | 4 |
40448 | 40448 | 2021-01-06 | Lake | 33 | 11 | 0 | 4 | 0 | 2 |
40449 | 40449 | 2021-01-06 | Lassen | 35 | 4 | 0 | 0 | 0 | 0 |
40450 | 40450 | 2021-01-06 | Los Angeles | 37 | 8074 | 311 | 1665 | 36 | 328 |
40451 | 40451 | 2021-01-06 | Madera | 39 | 57 | 4 | 11 | 0 | 2 |
40452 | 40452 | 2021-01-06 | Marin | 41 | 38 | 3 | 8 | 0 | 14 |
40453 | 40453 | 2021-01-06 | Mariposa | 43 | 1 | 0 | 0 | 0 | 0 |
40454 | 40454 | 2021-01-06 | Mendocino | 45 | 12 | 0 | 4 | 0 | 4 |
40455 | 40455 | 2021-01-06 | Merced | 47 | 57 | 0 | 16 | 0 | 3 |
40456 | 40456 | 2021-01-06 | Modoc | 49 | 1 | 0 | 0 | 0 | 0 |
40457 | 40457 | 2021-01-06 | Mono | 51 | 1 | 0 | 0 | 0 | 2 |
40458 | 40458 | 2021-01-06 | Monterey | 53 | 207 | 5 | 32 | 0 | 33 |
40459 | 40459 | 2021-01-06 | Napa | 55 | 26 | 1 | 22 | 0 | 3 |
40460 | 40460 | 2021-01-06 | Nevada | 57 | 13 | 0 | 4 | 0 | 3 |
40461 | 40461 | 2021-01-06 | Orange | 59 | 2253 | 53 | 502 | 4 | 80 |
40462 | 40462 | 2021-01-06 | Placer | 61 | 181 | 19 | 27 | 3 | 13 |
40463 | 40463 | 2021-01-06 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
40464 | 40464 | 2021-01-06 | Riverside | 65 | 1634 | 119 | 364 | 12 | 27 |
40465 | 40465 | 2021-01-06 | Sacramento | 67 | 499 | 32 | 115 | 6 | 66 |
40466 | 40466 | 2021-01-06 | San Benito | 69 | 14 | 0 | 5 | 0 | 0 |
40467 | 40467 | 2021-01-06 | San Bernardino | 71 | 1762 | 81 | 363 | 5 | 54 |
40468 | 40468 | 2021-01-06 | San Diego | 73 | 1661 | 71 | 391 | 9 | 169 |
40469 | 40469 | 2021-01-06 | San Francisco | 75 | 233 | 10 | 60 | 1 | 46 |
40470 | 40470 | 2021-01-06 | San Joaquin | 77 | 334 | 9 | 87 | 0 | 7 |
40471 | 40471 | 2021-01-06 | San Luis Obispo | 79 | 70 | 1 | 17 | 0 | 13 |
40472 | 40472 | 2021-01-06 | San Mateo | 81 | 180 | 7 | 39 | 1 | 12 |
40473 | 40473 | 2021-01-06 | Santa Barbara | 83 | 178 | 4 | 59 | 0 | 18 |
40474 | 40474 | 2021-01-06 | Santa Clara | 85 | 723 | 28 | 165 | 6 | 27 |
40475 | 40475 | 2021-01-06 | Santa Cruz | 87 | 76 | 0 | 14 | 0 | 4 |
40476 | 40476 | 2021-01-06 | Shasta | 89 | 49 | 0 | 7 | 0 | 8 |
40477 | 40477 | 2021-01-06 | Siskiyou | 93 | 5 | 0 | 1 | 0 | 9 |
40478 | 40478 | 2021-01-06 | Solano | 95 | 170 | 14 | 36 | 1 | 8 |
40479 | 40479 | 2021-01-06 | Sonoma | 97 | 105 | 3 | 19 | 2 | 24 |
40480 | 40480 | 2021-01-06 | Stanislaus | 99 | 349 | 9 | 66 | 2 | 12 |
40481 | 40481 | 2021-01-06 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
40482 | 40482 | 2021-01-06 | Tehama | 103 | 17 | 0 | 4 | 0 | 1 |
40483 | 40483 | 2021-01-06 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
40484 | 40484 | 2021-01-06 | Tulare | 107 | 219 | 3 | 26 | 0 | 14 |
40485 | 40485 | 2021-01-06 | Tuolumne | 109 | 10 | 0 | 1 | 0 | 1 |
40486 | 40486 | 2021-01-06 | Ventura | 111 | 418 | 8 | 86 | 1 | 21 |
40487 | 40487 | 2021-01-06 | Yolo | 113 | 30 | 0 | 11 | 0 | 16 |
40488 | 40488 | 2021-01-06 | Yuba | 115 | 65 | 5 | 13 | 0 | 4 |
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 );