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-08-21
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: positive_patients, icu_available_beds
Link | rowid ▼ | date | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
7281 | 7281 | 2022-08-21 | Alameda | 1 | 132 | 34 | 21 | 15 | 107 |
7282 | 7282 | 2022-08-21 | Amador | 5 | 1 | 0 | 0 | 0 | 1 |
7283 | 7283 | 2022-08-21 | Butte | 7 | 18 | 0 | 2 | 0 | 19 |
7284 | 7284 | 2022-08-21 | Calaveras | 9 | 2 | 0 | 0 | 0 | 2 |
7285 | 7285 | 2022-08-21 | Colusa | 11 | 0 | 0 | 0 | 0 | 0 |
7286 | 7286 | 2022-08-21 | Contra Costa | 13 | 61 | 23 | 13 | 1 | 40 |
7287 | 7287 | 2022-08-21 | Del Norte | 15 | 3 | 0 | 1 | 0 | 1 |
7288 | 7288 | 2022-08-21 | El Dorado | 17 | 7 | 1 | 0 | 0 | 4 |
7289 | 7289 | 2022-08-21 | Fresno | 19 | 167 | 27 | 16 | 0 | 23 |
7290 | 7290 | 2022-08-21 | Glenn | 21 | 1 | 0 | 0 | 0 | 0 |
7291 | 7291 | 2022-08-21 | Humboldt | 23 | 8 | 1 | 4 | 0 | 7 |
7292 | 7292 | 2022-08-21 | Imperial | 25 | 10 | 0 | 0 | 0 | 13 |
7293 | 7293 | 2022-08-21 | Inyo | 27 | 0 | 1 | 0 | 0 | 1 |
7294 | 7294 | 2022-08-21 | Kern | 29 | 76 | 0 | 13 | 0 | 22 |
7295 | 7295 | 2022-08-21 | Kings | 31 | 6 | 0 | 1 | 0 | 1 |
7296 | 7296 | 2022-08-21 | Lake | 33 | 3 | 0 | 1 | 0 | 4 |
7297 | 7297 | 2022-08-21 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
7298 | 7298 | 2022-08-21 | Los Angeles | 37 | 909 | 56 | 108 | 2 | 676 |
7299 | 7299 | 2022-08-21 | Madera | 39 | 20 | 13 | 4 | 0 | 8 |
7300 | 7300 | 2022-08-21 | Marin | 41 | 19 | 4 | 3 | 0 | 9 |
7301 | 7301 | 2022-08-21 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
7302 | 7302 | 2022-08-21 | Mendocino | 45 | 6 | 0 | 3 | 0 | 3 |
7303 | 7303 | 2022-08-21 | Merced | 47 | 12 | 0 | 1 | 0 | 11 |
7304 | 7304 | 2022-08-21 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
7305 | 7305 | 2022-08-21 | Mono | 51 | 0 | 0 | 0 | 0 | 1 |
7306 | 7306 | 2022-08-21 | Monterey | 53 | 28 | 0 | 3 | 0 | 19 |
7307 | 7307 | 2022-08-21 | Napa | 55 | 4 | 0 | 1 | 0 | 2 |
7308 | 7308 | 2022-08-21 | Nevada | 57 | 5 | 0 | 1 | 0 | 1 |
7309 | 7309 | 2022-08-21 | Orange | 59 | 253 | 7 | 33 | 2 | 164 |
7310 | 7310 | 2022-08-21 | Placer | 61 | 69 | 12 | 14 | 3 | 15 |
7311 | 7311 | 2022-08-21 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
7312 | 7312 | 2022-08-21 | Riverside | 65 | 166 | 18 | 16 | 3 | 101 |
7313 | 7313 | 2022-08-21 | Sacramento | 67 | 161 | 19 | 24 | 3 | 90 |
7314 | 7314 | 2022-08-21 | San Benito | 69 | 2 | 0 | 0 | 0 | 0 |
7315 | 7315 | 2022-08-21 | San Bernardino | 71 | 158 | 8 | 19 | 1 | 177 |
7316 | 7316 | 2022-08-21 | San Diego | 73 | 304 | 12 | 28 | 0 | 285 |
7317 | 7317 | 2022-08-21 | San Francisco | 75 | 98 | 8 | 12 | 2 | 108 |
7318 | 7318 | 2022-08-21 | San Joaquin | 77 | 62 | 8 | 8 | 2 | 14 |
7319 | 7319 | 2022-08-21 | San Luis Obispo | 79 | 21 | 0 | 0 | 0 | 20 |
7320 | 7320 | 2022-08-21 | San Mateo | 81 | 41 | 8 | 2 | 0 | 21 |
7321 | 7321 | 2022-08-21 | Santa Barbara | 83 | 46 | 0 | 4 | 0 | 23 |
7322 | 7322 | 2022-08-21 | Santa Clara | 85 | 201 | 24 | 23 | 3 | 52 |
7323 | 7323 | 2022-08-21 | Santa Cruz | 87 | 17 | 0 | 2 | 0 | 4 |
7324 | 7324 | 2022-08-21 | Shasta | 89 | 3 | 0 | 0 | 0 | 16 |
7325 | 7325 | 2022-08-21 | Siskiyou | 93 | 1 | 0 | 0 | 0 | 5 |
7326 | 7326 | 2022-08-21 | Solano | 95 | 41 | 18 | 9 | 2 | 15 |
7327 | 7327 | 2022-08-21 | Sonoma | 97 | 40 | 6 | 4 | 0 | 24 |
7328 | 7328 | 2022-08-21 | Stanislaus | 99 | 97 | 11 | 14 | 0 | 31 |
7329 | 7329 | 2022-08-21 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
7330 | 7330 | 2022-08-21 | Tehama | 103 | 1 | 0 | 0 | 0 | 4 |
7331 | 7331 | 2022-08-21 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
7332 | 7332 | 2022-08-21 | Tulare | 107 | 32 | 2 | 1 | 0 | 22 |
7333 | 7333 | 2022-08-21 | Tuolumne | 109 | 1 | 0 | 0 | 0 | 3 |
7334 | 7334 | 2022-08-21 | Ventura | 111 | 70 | 2 | 6 | 0 | 29 |
7335 | 7335 | 2022-08-21 | Yolo | 113 | 7 | 0 | 0 | 0 | 6 |
7336 | 7336 | 2022-08-21 | Yuba | 115 | 15 | 0 | 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 );