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,333 rows sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
56279 | 56279 | 2020-03-29 | Alameda | 1 | 36 | 91 | 20 | 16 | 119 |
56280 | 56280 | 2020-03-29 | Amador | 5 | 1 | 0 | 0 | 0 | 2 |
56281 | 56281 | 2020-03-29 | Butte | 7 | |||||
56282 | 56282 | 2020-03-29 | Calaveras | 9 | |||||
56283 | 56283 | 2020-03-29 | Colusa | 11 | |||||
56284 | 56284 | 2020-03-29 | Contra Costa | 13 | 23 | 62 | 8 | 15 | 62 |
56285 | 56285 | 2020-03-29 | Del Norte | 15 | 1 | 2 | 0 | 0 | 3 |
56286 | 56286 | 2020-03-29 | El Dorado | 17 | 0 | 6 | 0 | 3 | 3 |
56287 | 56287 | 2020-03-29 | Fresno | 19 | 8 | 116 | 3 | 14 | 22 |
56288 | 56288 | 2020-03-29 | Glenn | 21 | |||||
56289 | 56289 | 2020-03-29 | Humboldt | 23 | 1 | 10 | 0 | 0 | 18 |
56290 | 56290 | 2020-03-29 | Imperial | 25 | 5 | 100 | 1 | 2 | 2 |
56291 | 56291 | 2020-03-29 | Inyo | 27 | |||||
56292 | 56292 | 2020-03-29 | Kern | 29 | 16 | 57 | 8 | 8 | 39 |
56293 | 56293 | 2020-03-29 | Kings | 31 | 2 | 5 | 1 | 0 | 2 |
56294 | 56294 | 2020-03-29 | Lake | 33 | 0 | 1 | 0 | 1 | 2 |
56295 | 56295 | 2020-03-29 | Lassen | 35 | 0 | 2 | 0 | 0 | |
56296 | 56296 | 2020-03-29 | Los Angeles | 37 | 489 | 1132 | 191 | 182 | 345 |
56297 | 56297 | 2020-03-29 | Madera | 39 | 1 | 6 | 1 | 1 | 8 |
56298 | 56298 | 2020-03-29 | Marin | 41 | 7 | 13 | 2 | 6 | 11 |
56299 | 56299 | 2020-03-29 | Mendocino | 45 | 1 | 11 | 0 | 0 | 1 |
56300 | 56300 | 2020-03-29 | Merced | 47 | 1 | 7 | 0 | 0 | 3 |
56301 | 56301 | 2020-03-29 | Modoc | 49 | 0 | 0 | 0 | 0 | |
56302 | 56302 | 2020-03-29 | Mono | 51 | 0 | 1 | 0 | 0 | 2 |
56303 | 56303 | 2020-03-29 | Monterey | 53 | 2 | 16 | 1 | 2 | 10 |
56304 | 56304 | 2020-03-29 | Napa | 55 | 0 | 26 | 5 | ||
56305 | 56305 | 2020-03-29 | Nevada | 57 | 23 | 1 | 0 | 3 | |
56306 | 56306 | 2020-03-29 | Orange | 59 | 74 | 167 | 31 | 40 | 131 |
56307 | 56307 | 2020-03-29 | Placer | 61 | 18 | 14 | 4 | 1 | 10 |
56308 | 56308 | 2020-03-29 | Plumas | 63 | 0 | 1 | 0 | 1 | |
56309 | 56309 | 2020-03-29 | Riverside | 65 | 44 | 78 | 13 | 20 | 46 |
56310 | 56310 | 2020-03-29 | Sacramento | 67 | 36 | 27 | 12 | 18 | 50 |
56311 | 56311 | 2020-03-29 | San Benito | 69 | 1 | 1 | 1 | 0 | 1 |
56312 | 56312 | 2020-03-29 | San Bernardino | 71 | 33 | 123 | 19 | 20 | 65 |
56313 | 56313 | 2020-03-29 | San Diego | 73 | 121 | 211 | 77 | 39 | 205 |
56314 | 56314 | 2020-03-29 | San Francisco | 75 | 50 | 73 | 24 | 10 | 61 |
56315 | 56315 | 2020-03-29 | San Joaquin | 77 | 34 | 35 | 5 | 2 | 7 |
56316 | 56316 | 2020-03-29 | San Luis Obispo | 79 | 7 | 12 | 3 | 4 | 948 |
56317 | 56317 | 2020-03-29 | San Mateo | 81 | 46 | 27 | 16 | 10 | 28 |
56318 | 56318 | 2020-03-29 | Santa Barbara | 83 | 15 | 21 | 9 | 3 | 47 |
56319 | 56319 | 2020-03-29 | Santa Clara | 85 | 141 | 72 | 65 | 15 | 70 |
56320 | 56320 | 2020-03-29 | Santa Cruz | 87 | 0 | 0 | 0 | 0 | |
56321 | 56321 | 2020-03-29 | Shasta | 89 | 0 | 0 | 0 | 0 | |
56322 | 56322 | 2020-03-29 | Siskiyou | 93 | 0 | 0 | 0 | 0 | 2 |
56323 | 56323 | 2020-03-29 | Solano | 95 | 7 | 27 | 4 | 1 | 28 |
56324 | 56324 | 2020-03-29 | Sonoma | 97 | 7 | 20 | 2 | 5 | 12 |
56325 | 56325 | 2020-03-29 | Stanislaus | 99 | 20 | 48 | 9 | 8 | 25 |
56326 | 56326 | 2020-03-29 | Sutter | 101 | 0 | 0 | 0 | 0 | |
56327 | 56327 | 2020-03-29 | Tehama | 103 | 0 | 0 | 0 | 0 | 2 |
56328 | 56328 | 2020-03-29 | Trinity | 105 | 0 | 0 | 0 | 0 | |
56329 | 56329 | 2020-03-29 | Tulare | 107 | 6 | 13 | 5 | 3 | 7 |
56330 | 56330 | 2020-03-29 | Tuolumne | 109 | 1 | 5 | 0 | 0 | 0 |
56331 | 56331 | 2020-03-29 | Ventura | 111 | 24 | 85 | 5 | 19 | 14 |
56332 | 56332 | 2020-03-29 | Yolo | 113 | 2 | 3 | 1 | 1 | 0 |
56333 | 56333 | 2020-03-29 | Yuba | 115 | 2 | 12 | 2 | 4 | 2 |
56224 | 56224 | 2020-03-30 | Alameda | 1 | 59 | 89 | 27 | 18 | 146 |
56225 | 56225 | 2020-03-30 | Amador | 5 | 0 | 1 | 0 | 0 | 4 |
56226 | 56226 | 2020-03-30 | Butte | 7 | 4 | 12 | 2 | 1 | 5 |
56227 | 56227 | 2020-03-30 | Calaveras | 9 | 0 | 3 | 0 | 1 | 5 |
56228 | 56228 | 2020-03-30 | Colusa | 11 | 0 | 1 | 0 | 1 | 5 |
56229 | 56229 | 2020-03-30 | Contra Costa | 13 | 25 | 54 | 11 | 6 | 90 |
56230 | 56230 | 2020-03-30 | Del Norte | 15 | 0 | 2 | 0 | 0 | 5 |
56231 | 56231 | 2020-03-30 | El Dorado | 17 | 0 | 9 | 0 | 6 | 9 |
56232 | 56232 | 2020-03-30 | Fresno | 19 | 10 | 88 | 3 | 14 | 24 |
56233 | 56233 | 2020-03-30 | Glenn | 21 | 0 | 0 | 0 | 0 | |
56234 | 56234 | 2020-03-30 | Humboldt | 23 | 1 | 8 | 0 | 0 | 10 |
56235 | 56235 | 2020-03-30 | Imperial | 25 | 19 | 109 | 3 | 3 | 4 |
56236 | 56236 | 2020-03-30 | Inyo | 27 | |||||
56237 | 56237 | 2020-03-30 | Kern | 29 | 18 | 123 | 6 | 8 | 51 |
56238 | 56238 | 2020-03-30 | Kings | 31 | 2 | 12 | 1 | 2 | 0 |
56239 | 56239 | 2020-03-30 | Lake | 33 | 0 | 1 | 0 | 1 | 3 |
56240 | 56240 | 2020-03-30 | Lassen | 35 | 0 | 4 | 0 | 0 | |
56241 | 56241 | 2020-03-30 | Los Angeles | 37 | 601 | 1277 | 245 | 244 | 456 |
56242 | 56242 | 2020-03-30 | Madera | 39 | 1 | 5 | 1 | 3 | 4 |
56243 | 56243 | 2020-03-30 | Marin | 41 | 10 | 9 | 4 | 2 | 16 |
56244 | 56244 | 2020-03-30 | Mendocino | 45 | 2 | 11 | 0 | 1 | 8 |
56245 | 56245 | 2020-03-30 | Merced | 47 | 1 | 9 | 0 | 2 | 11 |
56246 | 56246 | 2020-03-30 | Modoc | 49 | 0 | 31 | 0 | 0 | |
56247 | 56247 | 2020-03-30 | Mono | 51 | 0 | 1 | 0 | 0 | 2 |
56248 | 56248 | 2020-03-30 | Monterey | 53 | 11 | 16 | 4 | 0 | 17 |
56249 | 56249 | 2020-03-30 | Napa | 55 | 3 | 8 | 1 | 0 | 9 |
56250 | 56250 | 2020-03-30 | Nevada | 57 | 26 | 17 | 2 | 5 | 3 |
56251 | 56251 | 2020-03-30 | Orange | 59 | 98 | 251 | 42 | 58 | 131 |
56252 | 56252 | 2020-03-30 | Placer | 61 | 19 | 19 | 5 | 1 | 29 |
56253 | 56253 | 2020-03-30 | Plumas | 63 | 0 | 1 | 0 | 0 | |
56254 | 56254 | 2020-03-30 | Riverside | 65 | 60 | 133 | 22 | 33 | 77 |
56255 | 56255 | 2020-03-30 | Sacramento | 67 | 45 | 86 | 21 | 23 | 58 |
56256 | 56256 | 2020-03-30 | San Benito | 69 | 1 | 1 | 1 | 0 | 1 |
56257 | 56257 | 2020-03-30 | San Bernardino | 71 | 67 | 179 | 27 | 33 | 66 |
56258 | 56258 | 2020-03-30 | San Diego | 73 | 146 | 446 | 72 | 23 | 228 |
56259 | 56259 | 2020-03-30 | San Francisco | 75 | 58 | 92 | 18 | 7 | 90 |
56260 | 56260 | 2020-03-30 | San Joaquin | 77 | 28 | 30 | 8 | 4 | 53 |
56261 | 56261 | 2020-03-30 | San Luis Obispo | 79 | 5 | 11 | 3 | 4 | 957 |
56262 | 56262 | 2020-03-30 | San Mateo | 81 | 56 | 40 | 18 | 11 | 47 |
56263 | 56263 | 2020-03-30 | Santa Barbara | 83 | 19 | 25 | 11 | 7 | 48 |
56264 | 56264 | 2020-03-30 | Santa Clara | 85 | 153 | 93 | 74 | 23 | 103 |
56265 | 56265 | 2020-03-30 | Santa Cruz | 87 | 0 | 2 | 0 | 0 | 4 |
56266 | 56266 | 2020-03-30 | Shasta | 89 | 1 | 4 | 0 | 0 | 13 |
56267 | 56267 | 2020-03-30 | Siskiyou | 93 | 0 | 0 | 0 | 0 | 3 |
56268 | 56268 | 2020-03-30 | Solano | 95 | 15 | 16 | 6 | 0 | 47 |
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 );