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-20
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 |
---|---|---|---|---|---|---|---|---|---|
55049 | 55049 | 2020-04-20 | Alameda | 1 | 85 | 52 | 38 | 4 | 59 |
55050 | 55050 | 2020-04-20 | Amador | 5 | 0 | 0 | 0 | 0 | 4 |
55051 | 55051 | 2020-04-20 | Butte | 7 | 1 | 2 | 0 | 1 | 9 |
55052 | 55052 | 2020-04-20 | Calaveras | 9 | 0 | 1 | 0 | 0 | 11 |
55053 | 55053 | 2020-04-20 | Colusa | 11 | 1 | 0 | 0 | 0 | 5 |
55054 | 55054 | 2020-04-20 | Contra Costa | 13 | 37 | 28 | 13 | 8 | 75 |
55055 | 55055 | 2020-04-20 | Del Norte | 15 | 0 | 2 | 0 | 1 | 1 |
55056 | 55056 | 2020-04-20 | El Dorado | 17 | 0 | 4 | 0 | 0 | 13 |
55057 | 55057 | 2020-04-20 | Fresno | 19 | 35 | 30 | 15 | 1 | 55 |
55058 | 55058 | 2020-04-20 | Glenn | 21 | 0 | 0 | 0 | 0 | |
55059 | 55059 | 2020-04-20 | Humboldt | 23 | 0 | 6 | 0 | 0 | 4 |
55060 | 55060 | 2020-04-20 | Imperial | 25 | 25 | 9 | 11 | 2 | 1 |
55061 | 55061 | 2020-04-20 | Inyo | 27 | 1 | 0 | 1 | 0 | 4 |
55062 | 55062 | 2020-04-20 | Kern | 29 | 34 | 11 | 13 | 1 | 51 |
55063 | 55063 | 2020-04-20 | Kings | 31 | 8 | 0 | 3 | 0 | 3 |
55064 | 55064 | 2020-04-20 | Lake | 33 | 0 | 2 | 0 | 1 | 0 |
55065 | 55065 | 2020-04-20 | Lassen | 35 | 0 | 1 | 0 | 0 | |
55066 | 55066 | 2020-04-20 | Los Angeles | 37 | 1791 | 602 | 625 | 93 | 607 |
55067 | 55067 | 2020-04-20 | Madera | 39 | 0 | 6 | 0 | 0 | 7 |
55068 | 55068 | 2020-04-20 | Marin | 41 | 6 | 4 | 2 | 1 | 11 |
55069 | 55069 | 2020-04-20 | Mariposa | 43 | 0 | 1 | 0 | 0 | |
55070 | 55070 | 2020-04-20 | Mendocino | 45 | 0 | 0 | 0 | 0 | 7 |
55071 | 55071 | 2020-04-20 | Merced | 47 | 0 | 1 | 0 | 1 | 6 |
55072 | 55072 | 2020-04-20 | Modoc | 49 | 0 | 0 | 0 | 0 | |
55073 | 55073 | 2020-04-20 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
55074 | 55074 | 2020-04-20 | Monterey | 53 | 24 | 7 | 2 | 1 | 23 |
55075 | 55075 | 2020-04-20 | Napa | 55 | 1 | 2 | 1 | 0 | 8 |
55076 | 55076 | 2020-04-20 | Nevada | 57 | 1 | 5 | 1 | 2 | 7 |
55077 | 55077 | 2020-04-20 | Orange | 59 | 172 | 102 | 73 | 21 | 184 |
55078 | 55078 | 2020-04-20 | Placer | 61 | 8 | 7 | 2 | 1 | 15 |
55079 | 55079 | 2020-04-20 | Plumas | 63 | 0 | 0 | 0 | 0 | |
55080 | 55080 | 2020-04-20 | Riverside | 65 | 240 | 145 | 72 | 29 | 133 |
55081 | 55081 | 2020-04-20 | Sacramento | 67 | 69 | 32 | 33 | 8 | 62 |
55082 | 55082 | 2020-04-20 | San Benito | 69 | 0 | 0 | 0 | 0 | 3 |
55083 | 55083 | 2020-04-20 | San Bernardino | 71 | 152 | 200 | 60 | 28 | 150 |
55084 | 55084 | 2020-04-20 | San Diego | 73 | 238 | 76 | 95 | 13 | 149 |
55085 | 55085 | 2020-04-20 | San Francisco | 75 | 79 | 27 | 27 | 7 | 73 |
55086 | 55086 | 2020-04-20 | San Joaquin | 77 | 30 | 23 | 16 | 4 | 18 |
55087 | 55087 | 2020-04-20 | San Luis Obispo | 79 | 2 | 3 | 2 | 0 | 28 |
55088 | 55088 | 2020-04-20 | San Mateo | 81 | 56 | 16 | 18 | 4 | 19 |
55089 | 55089 | 2020-04-20 | Santa Barbara | 83 | 30 | 9 | 20 | 2 | 61 |
55090 | 55090 | 2020-04-20 | Santa Clara | 85 | 149 | 42 | 68 | 8 | 115 |
55091 | 55091 | 2020-04-20 | Santa Cruz | 87 | 3 | 1 | 1 | 0 | 11 |
55092 | 55092 | 2020-04-20 | Shasta | 89 | 1 | 0 | 1 | 0 | 16 |
55093 | 55093 | 2020-04-20 | Siskiyou | 93 | 0 | 1 | 0 | 1 | 5 |
55094 | 55094 | 2020-04-20 | Solano | 95 | 10 | 11 | 6 | 3 | 36 |
55095 | 55095 | 2020-04-20 | Sonoma | 97 | 2 | 12 | 0 | 6 | 29 |
55096 | 55096 | 2020-04-20 | Stanislaus | 99 | 13 | 18 | 5 | 6 | 34 |
55097 | 55097 | 2020-04-20 | Sutter | 101 | 0 | 0 | |||
55098 | 55098 | 2020-04-20 | Tehama | 103 | 0 | 0 | 0 | 0 | 6 |
55099 | 55099 | 2020-04-20 | Trinity | 105 | 0 | 0 | 0 | 0 | |
55100 | 55100 | 2020-04-20 | Tulare | 107 | 27 | 0 | 9 | 0 | 15 |
55101 | 55101 | 2020-04-20 | Tuolumne | 109 | 0 | 0 | 0 | 0 | 2 |
55102 | 55102 | 2020-04-20 | Ventura | 111 | 29 | 18 | 8 | 2 | 27 |
55103 | 55103 | 2020-04-20 | Yolo | 113 | 5 | 1 | 0 | 0 | 14 |
55104 | 55104 | 2020-04-20 | Yuba | 115 | 0 | 1 | 0 | 1 | 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 );