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-02-14
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: positive_patients, icu_suspected_patients
Link | rowid ▼ | date | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
38249 | 38249 | 2021-02-14 | Alameda | 1 | 201 | 49 | 67 | 5 | 81 |
38250 | 38250 | 2021-02-14 | Amador | 5 | 7 | 0 | 1 | 0 | 0 |
38251 | 38251 | 2021-02-14 | Butte | 7 | 14 | 2 | 0 | 1 | 16 |
38252 | 38252 | 2021-02-14 | Calaveras | 9 | 2 | 0 | 1 | 0 | 5 |
38253 | 38253 | 2021-02-14 | Colusa | 11 | 5 | 0 | 0 | 0 | 5 |
38254 | 38254 | 2021-02-14 | Contra Costa | 13 | 99 | 17 | 34 | 3 | 40 |
38255 | 38255 | 2021-02-14 | Del Norte | 15 | 2 | 0 | 0 | 0 | 1 |
38256 | 38256 | 2021-02-14 | El Dorado | 17 | 6 | 0 | 2 | 0 | 6 |
38257 | 38257 | 2021-02-14 | Fresno | 19 | 308 | 16 | 84 | 3 | 17 |
38258 | 38258 | 2021-02-14 | Glenn | 21 | 0 | 0 | 0 | 0 | 0 |
38259 | 38259 | 2021-02-14 | Humboldt | 23 | 13 | 2 | 4 | 1 | 7 |
38260 | 38260 | 2021-02-14 | Imperial | 25 | 29 | 1 | 17 | 0 | 0 |
38261 | 38261 | 2021-02-14 | Inyo | 27 | 0 | 0 | 0 | 0 | 2 |
38262 | 38262 | 2021-02-14 | Kern | 29 | 221 | 7 | 52 | 0 | 26 |
38263 | 38263 | 2021-02-14 | Kings | 31 | 60 | 0 | 10 | 0 | 4 |
38264 | 38264 | 2021-02-14 | Lake | 33 | 4 | 0 | 1 | 0 | 1 |
38265 | 38265 | 2021-02-14 | Lassen | 35 | 2 | 0 | 0 | 0 | 0 |
38266 | 38266 | 2021-02-14 | Los Angeles | 37 | 2964 | 200 | 908 | 40 | 360 |
38267 | 38267 | 2021-02-14 | Madera | 39 | 42 | 7 | 13 | 0 | 0 |
38268 | 38268 | 2021-02-14 | Marin | 41 | 17 | 3 | 7 | 0 | 15 |
38269 | 38269 | 2021-02-14 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
38270 | 38270 | 2021-02-14 | Mendocino | 45 | 13 | 0 | 5 | 0 | 3 |
38271 | 38271 | 2021-02-14 | Merced | 47 | 33 | 0 | 13 | 0 | 2 |
38272 | 38272 | 2021-02-14 | Modoc | 49 | 2 | 0 | 0 | 0 | 0 |
38273 | 38273 | 2021-02-14 | Mono | 51 | 1 | 0 | 0 | 0 | 2 |
38274 | 38274 | 2021-02-14 | Monterey | 53 | 79 | 0 | 10 | 0 | 19 |
38275 | 38275 | 2021-02-14 | Napa | 55 | 11 | 0 | 1 | 0 | 4 |
38276 | 38276 | 2021-02-14 | Nevada | 57 | 6 | 0 | 0 | 0 | 6 |
38277 | 38277 | 2021-02-14 | Orange | 59 | 777 | 32 | 242 | 4 | 127 |
38278 | 38278 | 2021-02-14 | Placer | 61 | 78 | 10 | 19 | 2 | 12 |
38279 | 38279 | 2021-02-14 | Plumas | 63 | 2 | 0 | 0 | 0 | 0 |
38280 | 38280 | 2021-02-14 | Riverside | 65 | 576 | 56 | 181 | 6 | 38 |
38281 | 38281 | 2021-02-14 | Sacramento | 67 | 223 | 25 | 59 | 4 | 87 |
38282 | 38282 | 2021-02-14 | San Benito | 69 | 13 | 0 | 4 | 0 | 0 |
38283 | 38283 | 2021-02-14 | San Bernardino | 71 | 576 | 42 | 145 | 6 | 90 |
38284 | 38284 | 2021-02-14 | San Diego | 73 | 806 | 36 | 277 | 6 | 181 |
38285 | 38285 | 2021-02-14 | San Francisco | 75 | 118 | 3 | 38 | 0 | 88 |
38286 | 38286 | 2021-02-14 | San Joaquin | 77 | 159 | 11 | 56 | 1 | 5 |
38287 | 38287 | 2021-02-14 | San Luis Obispo | 79 | 30 | 0 | 8 | 0 | 21 |
38288 | 38288 | 2021-02-14 | San Mateo | 81 | 81 | 10 | 25 | 4 | 15 |
38289 | 38289 | 2021-02-14 | Santa Barbara | 83 | 119 | 4 | 25 | 0 | 33 |
38290 | 38290 | 2021-02-14 | Santa Clara | 85 | 293 | 24 | 89 | 4 | 64 |
38291 | 38291 | 2021-02-14 | Santa Cruz | 87 | 30 | 0 | 7 | 0 | 5 |
38292 | 38292 | 2021-02-14 | Shasta | 89 | 16 | 0 | 2 | 0 | 23 |
38293 | 38293 | 2021-02-14 | Siskiyou | 93 | 3 | 0 | 1 | 0 | 2 |
38294 | 38294 | 2021-02-14 | Solano | 95 | 92 | 14 | 22 | 1 | 13 |
38295 | 38295 | 2021-02-14 | Sonoma | 97 | 48 | 1 | 20 | 0 | 26 |
38296 | 38296 | 2021-02-14 | Stanislaus | 99 | 178 | 17 | 36 | 1 | 8 |
38297 | 38297 | 2021-02-14 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
38298 | 38298 | 2021-02-14 | Tehama | 103 | 6 | 0 | 1 | 0 | 1 |
38299 | 38299 | 2021-02-14 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
38300 | 38300 | 2021-02-14 | Tulare | 107 | 97 | 5 | 10 | 2 | 21 |
38301 | 38301 | 2021-02-14 | Tuolumne | 109 | 4 | 0 | 1 | 0 | 2 |
38302 | 38302 | 2021-02-14 | Ventura | 111 | 221 | 12 | 50 | 4 | 43 |
38303 | 38303 | 2021-02-14 | Yolo | 113 | 10 | 0 | 5 | 0 | 0 |
38304 | 38304 | 2021-02-14 | Yuba | 115 | 30 | 0 | 9 | 0 | 3 |
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 );