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-04-10
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: positive_patients, icu_positive_patients
Link | rowid ▼ | date | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
55609 | 55609 | 2020-04-10 | Alameda | 1 | 93 | 71 | 45 | 26 | 128 |
55610 | 55610 | 2020-04-10 | Amador | 5 | 0 | 0 | 0 | 0 | 4 |
55611 | 55611 | 2020-04-10 | Butte | 7 | 1 | 15 | 1 | 5 | 5 |
55612 | 55612 | 2020-04-10 | Calaveras | 9 | 0 | 0 | 0 | 0 | 11 |
55613 | 55613 | 2020-04-10 | Colusa | 11 | 0 | 0 | 0 | 0 | 6 |
55614 | 55614 | 2020-04-10 | Contra Costa | 13 | 42 | 30 | 17 | 6 | 75 |
55615 | 55615 | 2020-04-10 | Del Norte | 15 | 0 | 3 | 0 | 0 | 4 |
55616 | 55616 | 2020-04-10 | El Dorado | 17 | 17 | 1 | 0 | 1 | 10 |
55617 | 55617 | 2020-04-10 | Fresno | 19 | 27 | 41 | 11 | 9 | 57 |
55618 | 55618 | 2020-04-10 | Glenn | 21 | 0 | 0 | 0 | 0 | |
55619 | 55619 | 2020-04-10 | Humboldt | 23 | 2 | 10 | 0 | 3 | 0 |
55620 | 55620 | 2020-04-10 | Imperial | 25 | 14 | 12 | 8 | 3 | 1 |
55621 | 55621 | 2020-04-10 | Inyo | 27 | 9 | 135 | 1 | 0 | 3 |
55622 | 55622 | 2020-04-10 | Kern | 29 | 33 | 38 | 15 | 5 | 45 |
55623 | 55623 | 2020-04-10 | Kings | 31 | 8 | 0 | 3 | 0 | 1 |
55624 | 55624 | 2020-04-10 | Lake | 33 | 0 | 1 | 0 | 0 | 2 |
55625 | 55625 | 2020-04-10 | Lassen | 35 | 0 | 2 | 0 | 0 | |
55626 | 55626 | 2020-04-10 | Los Angeles | 37 | 1299 | 754 | 514 | 142 | 663 |
55627 | 55627 | 2020-04-10 | Madera | 39 | 0 | 5 | 0 | 1 | 6 |
55628 | 55628 | 2020-04-10 | Marin | 41 | 6 | 26 | 1 | 1 | 17 |
55629 | 55629 | 2020-04-10 | Mariposa | 43 | 0 | 0 | 0 | 0 | |
55630 | 55630 | 2020-04-10 | Mendocino | 45 | 0 | 1 | 0 | 1 | 5 |
55631 | 55631 | 2020-04-10 | Merced | 47 | 0 | 2 | 0 | 1 | 4 |
55632 | 55632 | 2020-04-10 | Modoc | 49 | 0 | 0 | 0 | 0 | |
55633 | 55633 | 2020-04-10 | Mono | 51 | 0 | 3 | 0 | 0 | 2 |
55634 | 55634 | 2020-04-10 | Monterey | 53 | 18 | 21 | 5 | 1 | 25 |
55635 | 55635 | 2020-04-10 | Napa | 55 | 0 | 7 | 0 | 4 | 7 |
55636 | 55636 | 2020-04-10 | Nevada | 57 | 3 | 3 | 2 | 1 | 6 |
55637 | 55637 | 2020-04-10 | Orange | 59 | 139 | 129 | 69 | 25 | 187 |
55638 | 55638 | 2020-04-10 | Placer | 61 | 16 | 11 | 9 | 3 | 9 |
55639 | 55639 | 2020-04-10 | Plumas | 63 | 0 | 0 | 0 | 0 | |
55640 | 55640 | 2020-04-10 | Riverside | 65 | 206 | 141 | 57 | 34 | 140 |
55641 | 55641 | 2020-04-10 | Sacramento | 67 | 70 | 45 | 30 | 13 | 69 |
55642 | 55642 | 2020-04-10 | San Benito | 69 | 2 | 1 | 1 | 0 | 1 |
55643 | 55643 | 2020-04-10 | San Bernardino | 71 | 156 | 295 | 66 | 58 | 134 |
55644 | 55644 | 2020-04-10 | San Diego | 73 | 230 | 124 | 96 | 14 | 153 |
55645 | 55645 | 2020-04-10 | San Francisco | 75 | 85 | 46 | 32 | 12 | 125 |
55646 | 55646 | 2020-04-10 | San Joaquin | 77 | 26 | 17 | 14 | 5 | 20 |
55647 | 55647 | 2020-04-10 | San Luis Obispo | 79 | 2 | 3 | 2 | 3 | 24 |
55648 | 55648 | 2020-04-10 | San Mateo | 81 | 56 | 12 | 18 | 3 | 41 |
55649 | 55649 | 2020-04-10 | Santa Barbara | 83 | 42 | 13 | 19 | 1 | 43 |
55650 | 55650 | 2020-04-10 | Santa Clara | 85 | 151 | 44 | 67 | 5 | 99 |
55651 | 55651 | 2020-04-10 | Santa Cruz | 87 | 4 | 11 | 3 | 5 | 4 |
55652 | 55652 | 2020-04-10 | Shasta | 89 | 5 | 7 | 2 | 1 | 12 |
55653 | 55653 | 2020-04-10 | Siskiyou | 93 | 0 | 0 | 0 | 0 | 4 |
55654 | 55654 | 2020-04-10 | Solano | 95 | 18 | 9 | 9 | 3 | 31 |
55655 | 55655 | 2020-04-10 | Sonoma | 97 | 4 | 18 | 1 | 6 | 32 |
55656 | 55656 | 2020-04-10 | Stanislaus | 99 | 27 | 17 | 11 | 3 | 44 |
55657 | 55657 | 2020-04-10 | Sutter | 101 | 0 | 0 | |||
55658 | 55658 | 2020-04-10 | Tehama | 103 | 0 | 1 | 0 | 0 | 8 |
55659 | 55659 | 2020-04-10 | Trinity | 105 | 0 | 0 | 0 | 0 | |
55660 | 55660 | 2020-04-10 | Tulare | 107 | 11 | 10 | 6 | 1 | 16 |
55661 | 55661 | 2020-04-10 | Tuolumne | 109 | 0 | 0 | 0 | 1 | 0 |
55662 | 55662 | 2020-04-10 | Ventura | 111 | 19 | 76 | 8 | 13 | 30 |
55663 | 55663 | 2020-04-10 | Yolo | 113 | 3 | 2 | 1 | 1 | 7 |
55664 | 55664 | 2020-04-10 | Yuba | 115 | 2 | 8 | 1 | 0 | 7 |
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 );