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-01-28
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 |
---|---|---|---|---|---|---|---|---|---|
39201 | 39201 | 2021-01-28 | Alameda | 1 | 353 | 46 | 107 | 8 | 63 |
39202 | 39202 | 2021-01-28 | Amador | 5 | 12 | 0 | 6 | 0 | 0 |
39203 | 39203 | 2021-01-28 | Butte | 7 | 41 | 1 | 8 | 0 | 7 |
39204 | 39204 | 2021-01-28 | Calaveras | 9 | 3 | 0 | 1 | 0 | 5 |
39205 | 39205 | 2021-01-28 | Colusa | 11 | 7 | 0 | 0 | 0 | 5 |
39206 | 39206 | 2021-01-28 | Contra Costa | 13 | 189 | 14 | 50 | 3 | 33 |
39207 | 39207 | 2021-01-28 | Del Norte | 15 | 0 | 1 | 0 | 1 | 1 |
39208 | 39208 | 2021-01-28 | El Dorado | 17 | 15 | 3 | 3 | 0 | 9 |
39209 | 39209 | 2021-01-28 | Fresno | 19 | 472 | 28 | 92 | 0 | 12 |
39210 | 39210 | 2021-01-28 | Glenn | 21 | 3 | 2 | 0 | 0 | 0 |
39211 | 39211 | 2021-01-28 | Humboldt | 23 | 13 | 4 | 2 | 0 | 7 |
39212 | 39212 | 2021-01-28 | Imperial | 25 | 75 | 0 | 36 | 0 | 1 |
39213 | 39213 | 2021-01-28 | Inyo | 27 | 4 | 0 | 0 | 0 | 2 |
39214 | 39214 | 2021-01-28 | Kern | 29 | 317 | 9 | 92 | 0 | 24 |
39215 | 39215 | 2021-01-28 | Kings | 31 | 81 | 0 | 10 | 0 | 1 |
39216 | 39216 | 2021-01-28 | Lake | 33 | 7 | 1 | 4 | 1 | 1 |
39217 | 39217 | 2021-01-28 | Lassen | 35 | 3 | 0 | 0 | 0 | 0 |
39218 | 39218 | 2021-01-28 | Los Angeles | 37 | 5669 | 372 | 1498 | 29 | 272 |
39219 | 39219 | 2021-01-28 | Madera | 39 | 67 | 6 | 19 | 1 | 0 |
39220 | 39220 | 2021-01-28 | Marin | 41 | 27 | 2 | 6 | 0 | 9 |
39221 | 39221 | 2021-01-28 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
39222 | 39222 | 2021-01-28 | Mendocino | 45 | 15 | 2 | 3 | 0 | 26 |
39223 | 39223 | 2021-01-28 | Merced | 47 | 52 | 0 | 21 | 0 | 0 |
39224 | 39224 | 2021-01-28 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
39225 | 39225 | 2021-01-28 | Mono | 51 | 0 | 0 | 0 | 0 | 1 |
39226 | 39226 | 2021-01-28 | Monterey | 53 | 149 | 2 | 30 | 0 | 11 |
39227 | 39227 | 2021-01-28 | Napa | 55 | 21 | 0 | 4 | 0 | 2 |
39228 | 39228 | 2021-01-28 | Nevada | 57 | 13 | 0 | 2 | 0 | 3 |
39229 | 39229 | 2021-01-28 | Orange | 59 | 1521 | 33 | 426 | 4 | 117 |
39230 | 39230 | 2021-01-28 | Placer | 61 | 115 | 17 | 23 | 3 | 8 |
39231 | 39231 | 2021-01-28 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
39232 | 39232 | 2021-01-28 | Riverside | 65 | 1128 | 124 | 290 | 14 | 20 |
39233 | 39233 | 2021-01-28 | Sacramento | 67 | 365 | 16 | 111 | 4 | 48 |
39234 | 39234 | 2021-01-28 | San Benito | 69 | 12 | 0 | 5 | 0 | 0 |
39235 | 39235 | 2021-01-28 | San Bernardino | 71 | 1128 | 51 | 276 | 4 | 81 |
39236 | 39236 | 2021-01-28 | San Diego | 73 | 1328 | 55 | 388 | 9 | 159 |
39237 | 39237 | 2021-01-28 | San Francisco | 75 | 176 | 2 | 55 | 0 | 55 |
39238 | 39238 | 2021-01-28 | San Joaquin | 77 | 253 | 16 | 73 | 0 | 5 |
39239 | 39239 | 2021-01-28 | San Luis Obispo | 79 | 43 | 0 | 18 | 0 | 12 |
39240 | 39240 | 2021-01-28 | San Mateo | 81 | 146 | 10 | 35 | 0 | 16 |
39241 | 39241 | 2021-01-28 | Santa Barbara | 83 | 180 | 7 | 48 | 2 | 17 |
39242 | 39242 | 2021-01-28 | Santa Clara | 85 | 487 | 9 | 135 | 0 | 47 |
39243 | 39243 | 2021-01-28 | Santa Cruz | 87 | 39 | 1 | 6 | 0 | 3 |
39244 | 39244 | 2021-01-28 | Shasta | 89 | 32 | 0 | 2 | 0 | 15 |
39245 | 39245 | 2021-01-28 | Siskiyou | 93 | 2 | 1 | 0 | 0 | 4 |
39246 | 39246 | 2021-01-28 | Solano | 95 | 147 | 11 | 42 | 0 | 8 |
39247 | 39247 | 2021-01-28 | Sonoma | 97 | 89 | 6 | 22 | 0 | 13 |
39248 | 39248 | 2021-01-28 | Stanislaus | 99 | 281 | 10 | 61 | 0 | 18 |
39249 | 39249 | 2021-01-28 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
39250 | 39250 | 2021-01-28 | Tehama | 103 | 11 | 0 | 2 | 0 | 1 |
39251 | 39251 | 2021-01-28 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
39252 | 39252 | 2021-01-28 | Tulare | 107 | 153 | 7 | 22 | 1 | 14 |
39253 | 39253 | 2021-01-28 | Tuolumne | 109 | 7 | 0 | 2 | 0 | 3 |
39254 | 39254 | 2021-01-28 | Ventura | 111 | 386 | 7 | 89 | 3 | 26 |
39255 | 39255 | 2021-01-28 | Yolo | 113 | 19 | 0 | 8 | 0 | 0 |
39256 | 39256 | 2021-01-28 | Yuba | 115 | 49 | 0 | 12 | 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 );