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 2022-03-15
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: positive_patients, suspected_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 |
---|---|---|---|---|---|---|---|---|---|
16185 | 16185 | 2022-03-15 | Alameda | 1 | 70 | 12 | 8 | 0 | 107 |
16186 | 16186 | 2022-03-15 | Amador | 5 | 4 | 0 | 0 | 0 | 2 |
16187 | 16187 | 2022-03-15 | Butte | 7 | 22 | 0 | 0 | 0 | 11 |
16188 | 16188 | 2022-03-15 | Calaveras | 9 | 1 | 0 | 1 | 0 | 3 |
16189 | 16189 | 2022-03-15 | Colusa | 11 | 2 | 0 | 0 | 0 | 0 |
16190 | 16190 | 2022-03-15 | Contra Costa | 13 | 29 | 24 | 11 | 1 | 49 |
16191 | 16191 | 2022-03-15 | Del Norte | 15 | 4 | 0 | 1 | 0 | 1 |
16192 | 16192 | 2022-03-15 | El Dorado | 17 | 4 | 0 | 0 | 0 | 3 |
16193 | 16193 | 2022-03-15 | Fresno | 19 | 135 | 14 | 19 | 2 | 26 |
16194 | 16194 | 2022-03-15 | Glenn | 21 | 1 | 0 | 0 | 0 | 0 |
16195 | 16195 | 2022-03-15 | Humboldt | 23 | 5 | 1 | 2 | 0 | 5 |
16196 | 16196 | 2022-03-15 | Imperial | 25 | 12 | 0 | 6 | 0 | 1 |
16197 | 16197 | 2022-03-15 | Inyo | 27 | 0 | 0 | 0 | 0 | 2 |
16198 | 16198 | 2022-03-15 | Kern | 29 | 49 | 1 | 10 | 0 | 27 |
16199 | 16199 | 2022-03-15 | Kings | 31 | 15 | 0 | 1 | 0 | 1 |
16200 | 16200 | 2022-03-15 | Lake | 33 | 3 | 0 | 0 | 0 | 0 |
16201 | 16201 | 2022-03-15 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
16202 | 16202 | 2022-03-15 | Los Angeles | 37 | 499 | 80 | 90 | 5 | 600 |
16203 | 16203 | 2022-03-15 | Madera | 39 | 11 | 4 | 1 | 0 | 9 |
16204 | 16204 | 2022-03-15 | Marin | 41 | 6 | 7 | 0 | 1 | 17 |
16205 | 16205 | 2022-03-15 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
16206 | 16206 | 2022-03-15 | Mendocino | 45 | 5 | 0 | 1 | 0 | 3 |
16207 | 16207 | 2022-03-15 | Merced | 47 | 23 | 0 | 3 | 0 | 6 |
16208 | 16208 | 2022-03-15 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
16209 | 16209 | 2022-03-15 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
16210 | 16210 | 2022-03-15 | Monterey | 53 | 14 | 0 | 1 | 0 | 20 |
16211 | 16211 | 2022-03-15 | Napa | 55 | 8 | 0 | 3 | 0 | 5 |
16212 | 16212 | 2022-03-15 | Nevada | 57 | 3 | 0 | 0 | 0 | 2 |
16213 | 16213 | 2022-03-15 | Orange | 59 | 133 | 9 | 29 | 5 | 181 |
16214 | 16214 | 2022-03-15 | Placer | 61 | 50 | 19 | 4 | 2 | 22 |
16215 | 16215 | 2022-03-15 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
16216 | 16216 | 2022-03-15 | Riverside | 65 | 100 | 20 | 16 | 1 | 114 |
16217 | 16217 | 2022-03-15 | Sacramento | 67 | 139 | 13 | 21 | 4 | 100 |
16218 | 16218 | 2022-03-15 | San Benito | 69 | 1 | 0 | 1 | 0 | 0 |
16219 | 16219 | 2022-03-15 | San Bernardino | 71 | 105 | 11 | 30 | 2 | 144 |
16220 | 16220 | 2022-03-15 | San Diego | 73 | 219 | 17 | 42 | 2 | 223 |
16221 | 16221 | 2022-03-15 | San Francisco | 75 | 45 | 4 | 10 | 0 | 86 |
16222 | 16222 | 2022-03-15 | San Joaquin | 77 | 30 | 4 | 8 | 0 | 17 |
16223 | 16223 | 2022-03-15 | San Luis Obispo | 79 | 8 | 0 | 1 | 0 | 17 |
16224 | 16224 | 2022-03-15 | San Mateo | 81 | 33 | 1 | 3 | 0 | 17 |
16225 | 16225 | 2022-03-15 | Santa Barbara | 83 | 20 | 1 | 1 | 0 | 32 |
16226 | 16226 | 2022-03-15 | Santa Clara | 85 | 136 | 13 | 29 | 2 | 53 |
16227 | 16227 | 2022-03-15 | Santa Cruz | 87 | 13 | 1 | 3 | 0 | 8 |
16228 | 16228 | 2022-03-15 | Shasta | 89 | 22 | 0 | 2 | 0 | 3 |
16229 | 16229 | 2022-03-15 | Siskiyou | 93 | 2 | 0 | 0 | 0 | 3 |
16230 | 16230 | 2022-03-15 | Solano | 95 | 36 | 21 | 5 | 4 | 26 |
16231 | 16231 | 2022-03-15 | Sonoma | 97 | 13 | 3 | 4 | 1 | 17 |
16232 | 16232 | 2022-03-15 | Stanislaus | 99 | 95 | 10 | 15 | 1 | 28 |
16233 | 16233 | 2022-03-15 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
16234 | 16234 | 2022-03-15 | Tehama | 103 | 2 | 0 | 0 | 0 | 8 |
16235 | 16235 | 2022-03-15 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
16236 | 16236 | 2022-03-15 | Tulare | 107 | 38 | 1 | 6 | 0 | 14 |
16237 | 16237 | 2022-03-15 | Tuolumne | 109 | 4 | 0 | 1 | 0 | 3 |
16238 | 16238 | 2022-03-15 | Ventura | 111 | 46 | 4 | 6 | 0 | 27 |
16239 | 16239 | 2022-03-15 | Yolo | 113 | 3 | 0 | 2 | 0 | 6 |
16240 | 16240 | 2022-03-15 | Yuba | 115 | 9 | 0 | 3 | 0 | 2 |
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 );