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 2021-05-14
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: icu_positive_patients, icu_available_beds
Link | rowid ▼ | date | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
33265 | 33265 | 2021-05-14 | Alameda | 1 | 74 | 36 | 18 | 5 | 102 |
33266 | 33266 | 2021-05-14 | Amador | 5 | 1 | 0 | 1 | 0 | 3 |
33267 | 33267 | 2021-05-14 | Butte | 7 | 15 | 0 | 2 | 0 | 11 |
33268 | 33268 | 2021-05-14 | Calaveras | 9 | 0 | 0 | 0 | 0 | 4 |
33269 | 33269 | 2021-05-14 | Colusa | 11 | 2 | 0 | 0 | 0 | 5 |
33270 | 33270 | 2021-05-14 | Contra Costa | 13 | 29 | 4 | 7 | 0 | 52 |
33271 | 33271 | 2021-05-14 | Del Norte | 15 | 0 | 0 | 0 | 0 | 4 |
33272 | 33272 | 2021-05-14 | El Dorado | 17 | 0 | 0 | 0 | 0 | 4 |
33273 | 33273 | 2021-05-14 | Fresno | 19 | 73 | 9 | 15 | 0 | 14 |
33274 | 33274 | 2021-05-14 | Glenn | 21 | 0 | 0 | 0 | 0 | 0 |
33275 | 33275 | 2021-05-14 | Humboldt | 23 | 7 | 2 | 2 | 0 | 7 |
33276 | 33276 | 2021-05-14 | Imperial | 25 | 18 | 0 | 7 | 0 | 4 |
33277 | 33277 | 2021-05-14 | Inyo | 27 | 1 | 0 | 0 | 0 | 1 |
33278 | 33278 | 2021-05-14 | Kern | 29 | 28 | 3 | 5 | 0 | 48 |
33279 | 33279 | 2021-05-14 | Kings | 31 | 3 | 0 | 0 | 0 | 1 |
33280 | 33280 | 2021-05-14 | Lake | 33 | 0 | 0 | 0 | 0 | 2 |
33281 | 33281 | 2021-05-14 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
33282 | 33282 | 2021-05-14 | Los Angeles | 37 | 325 | 90 | 73 | 11 | 646 |
33283 | 33283 | 2021-05-14 | Madera | 39 | 2 | 9 | 1 | 1 | 3 |
33284 | 33284 | 2021-05-14 | Marin | 41 | 5 | 2 | 1 | 0 | 10 |
33285 | 33285 | 2021-05-14 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
33286 | 33286 | 2021-05-14 | Mendocino | 45 | 3 | 0 | 3 | 0 | 5 |
33287 | 33287 | 2021-05-14 | Merced | 47 | 10 | 0 | 3 | 0 | 6 |
33288 | 33288 | 2021-05-14 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
33289 | 33289 | 2021-05-14 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
33290 | 33290 | 2021-05-14 | Monterey | 53 | 9 | 0 | 1 | 0 | 32 |
33291 | 33291 | 2021-05-14 | Napa | 55 | 4 | 0 | 1 | 0 | 1 |
33292 | 33292 | 2021-05-14 | Nevada | 57 | 6 | 0 | 3 | 0 | 1 |
33293 | 33293 | 2021-05-14 | Orange | 59 | 80 | 9 | 25 | 0 | 238 |
33294 | 33294 | 2021-05-14 | Placer | 61 | 35 | 7 | 7 | 1 | 26 |
33295 | 33295 | 2021-05-14 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
33296 | 33296 | 2021-05-14 | Riverside | 65 | 62 | 26 | 16 | 2 | 113 |
33297 | 33297 | 2021-05-14 | Sacramento | 67 | 82 | 13 | 28 | 2 | 118 |
33298 | 33298 | 2021-05-14 | San Benito | 69 | 0 | 0 | 0 | 0 | 1 |
33299 | 33299 | 2021-05-14 | San Bernardino | 71 | 68 | 15 | 16 | 3 | 153 |
33300 | 33300 | 2021-05-14 | San Diego | 73 | 137 | 10 | 43 | 1 | 168 |
33301 | 33301 | 2021-05-14 | San Francisco | 75 | 14 | 6 | 5 | 2 | 79 |
33302 | 33302 | 2021-05-14 | San Joaquin | 77 | 40 | 9 | 13 | 2 | 10 |
33303 | 33303 | 2021-05-14 | San Luis Obispo | 79 | 2 | 0 | 0 | 0 | 23 |
33304 | 33304 | 2021-05-14 | San Mateo | 81 | 21 | 4 | 4 | 0 | 20 |
33305 | 33305 | 2021-05-14 | Santa Barbara | 83 | 18 | 0 | 2 | 0 | 36 |
33306 | 33306 | 2021-05-14 | Santa Clara | 85 | 57 | 15 | 14 | 4 | 82 |
33307 | 33307 | 2021-05-14 | Santa Cruz | 87 | 1 | 0 | 0 | 0 | 9 |
33308 | 33308 | 2021-05-14 | Shasta | 89 | 8 | 0 | 0 | 0 | 23 |
33309 | 33309 | 2021-05-14 | Siskiyou | 93 | 4 | 0 | 0 | 0 | 5 |
33310 | 33310 | 2021-05-14 | Solano | 95 | 27 | 8 | 3 | 1 | 13 |
33311 | 33311 | 2021-05-14 | Sonoma | 97 | 7 | 1 | 2 | 0 | 31 |
33312 | 33312 | 2021-05-14 | Stanislaus | 99 | 94 | 7 | 18 | 0 | 34 |
33313 | 33313 | 2021-05-14 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
33314 | 33314 | 2021-05-14 | Tehama | 103 | 3 | 0 | 1 | 0 | 2 |
33315 | 33315 | 2021-05-14 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
33316 | 33316 | 2021-05-14 | Tulare | 107 | 16 | 4 | 0 | 0 | 20 |
33317 | 33317 | 2021-05-14 | Tuolumne | 109 | 3 | 0 | 0 | 0 | 4 |
33318 | 33318 | 2021-05-14 | Ventura | 111 | 23 | 4 | 3 | 0 | 45 |
33319 | 33319 | 2021-05-14 | Yolo | 113 | 3 | 0 | 0 | 0 | 5 |
33320 | 33320 | 2021-05-14 | Yuba | 115 | 8 | 2 | 3 | 0 | 9 |
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 );