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 2020-10-27
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: positive_patients, icu_positive_patients, icu_available_beds
Link | rowid ▼ | date | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
44409 | 44409 | 2020-10-27 | Alameda | 1 | 58 | 34 | 17 | 6 | 116 |
44410 | 44410 | 2020-10-27 | Amador | 5 | 2 | 0 | 0 | 0 | 6 |
44411 | 44411 | 2020-10-27 | Butte | 7 | 10 | 0 | 3 | 0 | 9 |
44412 | 44412 | 2020-10-27 | Calaveras | 9 | 0 | 0 | 0 | 0 | 4 |
44413 | 44413 | 2020-10-27 | Colusa | 11 | 0 | 0 | 0 | 0 | 0 |
44414 | 44414 | 2020-10-27 | Contra Costa | 13 | 33 | 10 | 11 | 0 | 47 |
44415 | 44415 | 2020-10-27 | Del Norte | 15 | 1 | 0 | 0 | 0 | 1 |
44416 | 44416 | 2020-10-27 | El Dorado | 17 | 1 | 1 | 1 | 1 | 7 |
44417 | 44417 | 2020-10-27 | Fresno | 19 | 96 | 16 | 28 | 0 | 23 |
44418 | 44418 | 2020-10-27 | Glenn | 21 | 0 | 0 | 0 | 0 | 0 |
44419 | 44419 | 2020-10-27 | Humboldt | 23 | 2 | 1 | 0 | 0 | 6 |
44420 | 44420 | 2020-10-27 | Imperial | 25 | 44 | 0 | 14 | 0 | 1 |
44421 | 44421 | 2020-10-27 | Inyo | 27 | 0 | 0 | 0 | 0 | 4 |
44422 | 44422 | 2020-10-27 | Kern | 29 | 46 | 1 | 19 | 0 | 67 |
44423 | 44423 | 2020-10-27 | Kings | 31 | 19 | 0 | 3 | 0 | 14 |
44424 | 44424 | 2020-10-27 | Lake | 33 | 2 | 0 | 2 | 0 | 2 |
44425 | 44425 | 2020-10-27 | Lassen | 35 | 0 | 1 | 0 | 0 | 0 |
44426 | 44426 | 2020-10-27 | Los Angeles | 37 | 750 | 267 | 229 | 38 | 762 |
44427 | 44427 | 2020-10-27 | Madera | 39 | 12 | 10 | 2 | 1 | 28 |
44428 | 44428 | 2020-10-27 | Marin | 41 | 5 | 3 | 0 | 0 | 17 |
44429 | 44429 | 2020-10-27 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
44430 | 44430 | 2020-10-27 | Mendocino | 45 | 0 | 0 | 0 | 0 | 4 |
44431 | 44431 | 2020-10-27 | Merced | 47 | 5 | 1 | 2 | 0 | 8 |
44432 | 44432 | 2020-10-27 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
44433 | 44433 | 2020-10-27 | Mono | 51 | 0 | 1 | 0 | 0 | 2 |
44434 | 44434 | 2020-10-27 | Monterey | 53 | 26 | 1 | 9 | 0 | 19 |
44435 | 44435 | 2020-10-27 | Napa | 55 | 7 | 0 | 2 | 0 | 22 |
44436 | 44436 | 2020-10-27 | Nevada | 57 | 1 | 1 | 0 | 0 | 4 |
44437 | 44437 | 2020-10-27 | Orange | 59 | 177 | 36 | 60 | 5 | 176 |
44438 | 44438 | 2020-10-27 | Placer | 61 | 18 | 14 | 3 | 3 | 29 |
44439 | 44439 | 2020-10-27 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
44440 | 44440 | 2020-10-27 | Riverside | 65 | 148 | 48 | 32 | 11 | 69 |
44441 | 44441 | 2020-10-27 | Sacramento | 67 | 76 | 20 | 12 | 8 | 77 |
44442 | 44442 | 2020-10-27 | San Benito | 69 | 0 | 0 | 0 | 0 | 3 |
44443 | 44443 | 2020-10-27 | San Bernardino | 71 | 233 | 35 | 52 | 12 | 109 |
44444 | 44444 | 2020-10-27 | San Diego | 73 | 182 | 59 | 67 | 13 | 286 |
44445 | 44445 | 2020-10-27 | San Francisco | 75 | 31 | 1 | 6 | 0 | 64 |
44446 | 44446 | 2020-10-27 | San Joaquin | 77 | 26 | 4 | 7 | 0 | 41 |
44447 | 44447 | 2020-10-27 | San Luis Obispo | 79 | 7 | 0 | 1 | 0 | 29 |
44448 | 44448 | 2020-10-27 | San Mateo | 81 | 18 | 3 | 5 | 0 | 35 |
44449 | 44449 | 2020-10-27 | Santa Barbara | 83 | 11 | 0 | 3 | 0 | 61 |
44450 | 44450 | 2020-10-27 | Santa Clara | 85 | 79 | 26 | 19 | 1 | 64 |
44451 | 44451 | 2020-10-27 | Santa Cruz | 87 | 9 | 0 | 2 | 0 | 6 |
44452 | 44452 | 2020-10-27 | Shasta | 89 | 9 | 1 | 2 | 0 | 3 |
44453 | 44453 | 2020-10-27 | Siskiyou | 93 | 2 | 0 | 1 | 0 | 7 |
44454 | 44454 | 2020-10-27 | Solano | 95 | 27 | 11 | 7 | 0 | 8 |
44455 | 44455 | 2020-10-27 | Sonoma | 97 | 27 | 8 | 5 | 1 | 11 |
44456 | 44456 | 2020-10-27 | Stanislaus | 99 | 59 | 21 | 15 | 3 | 12 |
44457 | 44457 | 2020-10-27 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
44458 | 44458 | 2020-10-27 | Tehama | 103 | 6 | 1 | 2 | 0 | 2 |
44459 | 44459 | 2020-10-27 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
44460 | 44460 | 2020-10-27 | Tulare | 107 | 33 | 6 | 6 | 1 | 19 |
44461 | 44461 | 2020-10-27 | Tuolumne | 109 | 1 | 0 | 0 | 0 | 1 |
44462 | 44462 | 2020-10-27 | Ventura | 111 | 28 | 14 | 11 | 3 | 56 |
44463 | 44463 | 2020-10-27 | Yolo | 113 | 8 | 0 | 3 | 0 | 5 |
44464 | 44464 | 2020-10-27 | Yuba | 115 | 7 | 0 | 0 | 0 | 14 |
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 );