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-07-06
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: suspected_patients, icu_available_beds
Link | rowid ▼ | date | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
50737 | 50737 | 2020-07-06 | Alameda | 1 | 142 | 45 | 50 | 10 | 132 |
50738 | 50738 | 2020-07-06 | Amador | 5 | 1 | 0 | 1 | 0 | 2 |
50739 | 50739 | 2020-07-06 | Butte | 7 | 12 | 1 | 7 | 1 | 1 |
50740 | 50740 | 2020-07-06 | Calaveras | 9 | 0 | 3 | 0 | 2 | 8 |
50741 | 50741 | 2020-07-06 | Colusa | 11 | 0 | 0 | 0 | 0 | 6 |
50742 | 50742 | 2020-07-06 | Contra Costa | 13 | 57 | 27 | 22 | 8 | 143 |
50743 | 50743 | 2020-07-06 | Del Norte | 15 | 1 | 0 | 0 | 0 | 2 |
50744 | 50744 | 2020-07-06 | El Dorado | 17 | 2 | 0 | 2 | 0 | 5 |
50745 | 50745 | 2020-07-06 | Fresno | 19 | 148 | 14 | 31 | 1 | 89 |
50746 | 50746 | 2020-07-06 | Glenn | 21 | 0 | 1 | 0 | 0 | |
50747 | 50747 | 2020-07-06 | Humboldt | 23 | 1 | 2 | 1 | 0 | 4 |
50748 | 50748 | 2020-07-06 | Imperial | 25 | 89 | 2 | 20 | 0 | 18 |
50749 | 50749 | 2020-07-06 | Inyo | 27 | 0 | 1 | 0 | 1 | 3 |
50750 | 50750 | 2020-07-06 | Kern | 29 | 211 | 12 | 60 | 1 | 85 |
50751 | 50751 | 2020-07-06 | Kings | 31 | 49 | 3 | 7 | 1 | 0 |
50752 | 50752 | 2020-07-06 | Lake | 33 | 3 | 3 | 0 | 1 | 2 |
50753 | 50753 | 2020-07-06 | Lassen | 35 | 1 | 0 | 0 | 0 | |
50754 | 50754 | 2020-07-06 | Los Angeles | 37 | 2004 | 666 | 529 | 103 | 1334 |
50755 | 50755 | 2020-07-06 | Madera | 39 | 26 | 6 | 4 | 0 | 22 |
50756 | 50756 | 2020-07-06 | Marin | 41 | 34 | 5 | 7 | 1 | 9 |
50757 | 50757 | 2020-07-06 | Mariposa | 43 | 0 | 0 | 0 | 0 | |
50758 | 50758 | 2020-07-06 | Mendocino | 45 | 0 | 0 | 0 | 0 | 6 |
50759 | 50759 | 2020-07-06 | Merced | 47 | 22 | 2 | 5 | 1 | 4 |
50760 | 50760 | 2020-07-06 | Modoc | 49 | 0 | 0 | 0 | 0 | |
50761 | 50761 | 2020-07-06 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
50762 | 50762 | 2020-07-06 | Monterey | 53 | 35 | 2 | 9 | 0 | 84 |
50763 | 50763 | 2020-07-06 | Napa | 55 | 7 | 0 | 6 | 0 | 5 |
50764 | 50764 | 2020-07-06 | Nevada | 57 | 3 | 3 | 1 | 0 | 6 |
50765 | 50765 | 2020-07-06 | Orange | 59 | 659 | 180 | 224 | 26 | 406 |
50766 | 50766 | 2020-07-06 | Placer | 61 | 26 | 15 | 5 | 5 | 30 |
50767 | 50767 | 2020-07-06 | Plumas | 63 | 0 | 1 | 0 | 0 | |
50768 | 50768 | 2020-07-06 | Riverside | 65 | 520 | 138 | 130 | 16 | 124 |
50769 | 50769 | 2020-07-06 | Sacramento | 67 | 157 | 15 | 41 | 5 | 87 |
50770 | 50770 | 2020-07-06 | San Benito | 69 | 0 | 0 | 0 | 0 | 0 |
50771 | 50771 | 2020-07-06 | San Bernardino | 71 | 501 | 73 | 160 | 10 | 129 |
50772 | 50772 | 2020-07-06 | San Diego | 73 | 384 | 72 | 159 | 16 | 339 |
50773 | 50773 | 2020-07-06 | San Francisco | 75 | 68 | 12 | 27 | 1 | 120 |
50774 | 50774 | 2020-07-06 | San Joaquin | 77 | 168 | 74 | 43 | 4 | 46 |
50775 | 50775 | 2020-07-06 | San Luis Obispo | 79 | 11 | 2 | 3 | 2 | 40 |
50776 | 50776 | 2020-07-06 | San Mateo | 81 | 48 | 7 | 13 | 2 | 72 |
50777 | 50777 | 2020-07-06 | Santa Barbara | 83 | 72 | 8 | 21 | 2 | 68 |
50778 | 50778 | 2020-07-06 | Santa Clara | 85 | 88 | 16 | 33 | 2 | 195 |
50779 | 50779 | 2020-07-06 | Santa Cruz | 87 | 11 | 2 | 2 | 0 | 29 |
50780 | 50780 | 2020-07-06 | Shasta | 89 | 5 | 1 | 3 | 0 | 9 |
50781 | 50781 | 2020-07-06 | Siskiyou | 93 | 0 | 0 | 0 | 0 | 4 |
50782 | 50782 | 2020-07-06 | Solano | 95 | 38 | 5 | 15 | 1 | 35 |
50783 | 50783 | 2020-07-06 | Sonoma | 97 | 22 | 11 | 8 | 5 | 48 |
50784 | 50784 | 2020-07-06 | Stanislaus | 99 | 160 | 46 | 41 | 5 | 99 |
50785 | 50785 | 2020-07-06 | Sutter | 101 | 0 | 0 | 0 | 0 | |
50786 | 50786 | 2020-07-06 | Tehama | 103 | 0 | 0 | 0 | 0 | 1 |
50787 | 50787 | 2020-07-06 | Trinity | 105 | 0 | 0 | 0 | 0 | |
50788 | 50788 | 2020-07-06 | Tulare | 107 | 81 | 5 | 11 | 2 | 8 |
50789 | 50789 | 2020-07-06 | Tuolumne | 109 | 1 | 0 | 0 | 0 | 3 |
50790 | 50790 | 2020-07-06 | Ventura | 111 | 92 | 28 | 30 | 8 | 47 |
50791 | 50791 | 2020-07-06 | Yolo | 113 | 9 | 0 | 2 | 0 | 0 |
50792 | 50792 | 2020-07-06 | Yuba | 115 | 20 | 1 | 7 | 1 | 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 );