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-11-01
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: icu_positive_patients, icu_suspected_patients, icu_available_beds
Link | rowid ▼ | date | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
3249 | 3249 | 2022-11-01 | Alameda | 1 | 55 | 42 | 3 | 3 | 110 |
3250 | 3250 | 2022-11-01 | Amador | 5 | 2 | 0 | 0 | 0 | 2 |
3251 | 3251 | 2022-11-01 | Butte | 7 | 9 | 0 | 1 | 0 | 14 |
3252 | 3252 | 2022-11-01 | Calaveras | 9 | 0 | 0 | 0 | 0 | 2 |
3253 | 3253 | 2022-11-01 | Colusa | 11 | 0 | 0 | 0 | 0 | 0 |
3254 | 3254 | 2022-11-01 | Contra Costa | 13 | 39 | 26 | 6 | 1 | 48 |
3255 | 3255 | 2022-11-01 | Del Norte | 15 | 2 | 0 | 0 | 0 | 4 |
3256 | 3256 | 2022-11-01 | El Dorado | 17 | 2 | 0 | 0 | 0 | 3 |
3257 | 3257 | 2022-11-01 | Fresno | 19 | 70 | 17 | 10 | 4 | 32 |
3258 | 3258 | 2022-11-01 | Glenn | 21 | 1 | 0 | 0 | 0 | 0 |
3259 | 3259 | 2022-11-01 | Humboldt | 23 | 6 | 0 | 2 | 0 | 7 |
3260 | 3260 | 2022-11-01 | Imperial | 25 | 8 | 0 | 0 | 0 | 11 |
3261 | 3261 | 2022-11-01 | Inyo | 27 | 0 | 0 | 0 | 0 | 4 |
3262 | 3262 | 2022-11-01 | Kern | 29 | 27 | 0 | 2 | 0 | 35 |
3263 | 3263 | 2022-11-01 | Kings | 31 | 5 | 0 | 1 | 0 | 4 |
3264 | 3264 | 2022-11-01 | Lake | 33 | 1 | 0 | 1 | 0 | 0 |
3265 | 3265 | 2022-11-01 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
3266 | 3266 | 2022-11-01 | Los Angeles | 37 | 432 | 47 | 48 | 5 | 657 |
3267 | 3267 | 2022-11-01 | Madera | 39 | 6 | 2 | 1 | 0 | 8 |
3268 | 3268 | 2022-11-01 | Marin | 41 | 13 | 3 | 0 | 1 | 16 |
3269 | 3269 | 2022-11-01 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
3270 | 3270 | 2022-11-01 | Mendocino | 45 | 3 | 0 | 2 | 0 | 0 |
3271 | 3271 | 2022-11-01 | Merced | 47 | 5 | 1 | 0 | 0 | 11 |
3272 | 3272 | 2022-11-01 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
3273 | 3273 | 2022-11-01 | Mono | 51 | 1 | 0 | 0 | 0 | 2 |
3274 | 3274 | 2022-11-01 | Monterey | 53 | 17 | 0 | 0 | 0 | 23 |
3275 | 3275 | 2022-11-01 | Napa | 55 | 2 | 0 | 1 | 0 | 5 |
3276 | 3276 | 2022-11-01 | Nevada | 57 | 6 | 0 | 0 | 0 | 6 |
3277 | 3277 | 2022-11-01 | Orange | 59 | 125 | 11 | 19 | 3 | 146 |
3278 | 3278 | 2022-11-01 | Placer | 61 | 42 | 20 | 5 | 3 | 18 |
3279 | 3279 | 2022-11-01 | Plumas | 63 | 1 | 0 | 0 | 0 | 0 |
3280 | 3280 | 2022-11-01 | Riverside | 65 | 68 | 11 | 5 | 0 | 120 |
3281 | 3281 | 2022-11-01 | Sacramento | 67 | 84 | 39 | 13 | 6 | 71 |
3282 | 3282 | 2022-11-01 | San Benito | 69 | 1 | 0 | 0 | 0 | 1 |
3283 | 3283 | 2022-11-01 | San Bernardino | 71 | 76 | 3 | 12 | 0 | 151 |
3284 | 3284 | 2022-11-01 | San Diego | 73 | 117 | 16 | 12 | 1 | 265 |
3285 | 3285 | 2022-11-01 | San Francisco | 75 | 59 | 15 | 6 | 1 | 73 |
3286 | 3286 | 2022-11-01 | San Joaquin | 77 | 28 | 6 | 3 | 1 | 12 |
3287 | 3287 | 2022-11-01 | San Luis Obispo | 79 | 1 | 0 | 0 | 0 | 23 |
3288 | 3288 | 2022-11-01 | San Mateo | 81 | 37 | 10 | 4 | 1 | 14 |
3289 | 3289 | 2022-11-01 | Santa Barbara | 83 | 23 | 1 | 5 | 0 | 14 |
3290 | 3290 | 2022-11-01 | Santa Clara | 85 | 98 | 20 | 12 | 2 | 59 |
3291 | 3291 | 2022-11-01 | Santa Cruz | 87 | 4 | 0 | 0 | 0 | 0 |
3292 | 3292 | 2022-11-01 | Shasta | 89 | 7 | 0 | 1 | 0 | 29 |
3293 | 3293 | 2022-11-01 | Siskiyou | 93 | 1 | 0 | 0 | 0 | 0 |
3294 | 3294 | 2022-11-01 | Solano | 95 | 17 | 30 | 5 | 3 | 18 |
3295 | 3295 | 2022-11-01 | Sonoma | 97 | 27 | 11 | 4 | 0 | 25 |
3296 | 3296 | 2022-11-01 | Stanislaus | 99 | 53 | 16 | 10 | 4 | 23 |
3297 | 3297 | 2022-11-01 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
3298 | 3298 | 2022-11-01 | Tehama | 103 | 2 | 0 | 0 | 0 | 7 |
3299 | 3299 | 2022-11-01 | Trinity | 105 | 5 | 0 | 0 | 0 | 0 |
3300 | 3300 | 2022-11-01 | Tulare | 107 | 11 | 2 | 0 | 0 | 23 |
3301 | 3301 | 2022-11-01 | Tuolumne | 109 | 3 | 0 | 0 | 0 | 3 |
3302 | 3302 | 2022-11-01 | Ventura | 111 | 29 | 4 | 4 | 1 | 34 |
3303 | 3303 | 2022-11-01 | Yolo | 113 | 2 | 0 | 2 | 0 | 0 |
3304 | 3304 | 2022-11-01 | Yuba | 115 | 1 | 0 | 0 | 0 | 5 |
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 );