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 2020-04-15
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: suspected_patients, icu_suspected_patients
Link | rowid ▼ | date | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
55329 | 55329 | 2020-04-15 | Alameda | 1 | 81 | 99 | 34 | 11 | 70 |
55330 | 55330 | 2020-04-15 | Amador | 5 | 0 | 0 | 0 | 0 | 2 |
55331 | 55331 | 2020-04-15 | Butte | 7 | 1 | 5 | 0 | 2 | 6 |
55332 | 55332 | 2020-04-15 | Calaveras | 9 | 0 | 0 | 0 | 0 | 10 |
55333 | 55333 | 2020-04-15 | Colusa | 11 | 0 | 0 | 0 | 0 | 6 |
55334 | 55334 | 2020-04-15 | Contra Costa | 13 | 38 | 41 | 16 | 8 | 76 |
55335 | 55335 | 2020-04-15 | Del Norte | 15 | 0 | 0 | 0 | 1 | 4 |
55336 | 55336 | 2020-04-15 | El Dorado | 17 | 0 | 5 | 0 | 1 | 12 |
55337 | 55337 | 2020-04-15 | Fresno | 19 | 25 | 33 | 12 | 2 | 44 |
55338 | 55338 | 2020-04-15 | Glenn | 21 | 0 | 0 | 0 | 0 | |
55339 | 55339 | 2020-04-15 | Humboldt | 23 | 2 | 5 | 0 | 0 | 11 |
55340 | 55340 | 2020-04-15 | Imperial | 25 | 21 | 13 | 7 | 4 | 2 |
55341 | 55341 | 2020-04-15 | Inyo | 27 | 15 | 163 | 0 | 0 | 6 |
55342 | 55342 | 2020-04-15 | Kern | 29 | 40 | 12 | 16 | 1 | 47 |
55343 | 55343 | 2020-04-15 | Kings | 31 | 8 | 0 | 2 | 0 | 3 |
55344 | 55344 | 2020-04-15 | Lake | 33 | 3 | 3 | 0 | 2 | 1 |
55345 | 55345 | 2020-04-15 | Lassen | 35 | 0 | 6 | 0 | 0 | |
55346 | 55346 | 2020-04-15 | Los Angeles | 37 | 1624 | 632 | 600 | 139 | 566 |
55347 | 55347 | 2020-04-15 | Madera | 39 | 1 | 6 | 0 | 1 | 6 |
55348 | 55348 | 2020-04-15 | Marin | 41 | 4 | 10 | 2 | 4 | 11 |
55349 | 55349 | 2020-04-15 | Mariposa | 43 | 0 | 4 | 0 | 0 | |
55350 | 55350 | 2020-04-15 | Mendocino | 45 | 0 | 0 | 0 | 0 | 8 |
55351 | 55351 | 2020-04-15 | Merced | 47 | 0 | 0 | 0 | 0 | 5 |
55352 | 55352 | 2020-04-15 | Modoc | 49 | 0 | 0 | 0 | 0 | |
55353 | 55353 | 2020-04-15 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
55354 | 55354 | 2020-04-15 | Monterey | 53 | 20 | 11 | 4 | 1 | 22 |
55355 | 55355 | 2020-04-15 | Napa | 55 | 0 | 0 | 0 | 0 | 8 |
55356 | 55356 | 2020-04-15 | Nevada | 57 | 3 | 4 | 2 | 1 | 2 |
55357 | 55357 | 2020-04-15 | Orange | 59 | 156 | 103 | 73 | 27 | 235 |
55358 | 55358 | 2020-04-15 | Placer | 61 | 13 | 11 | 2 | 4 | 12 |
55359 | 55359 | 2020-04-15 | Plumas | 63 | 0 | 0 | 0 | 0 | |
55360 | 55360 | 2020-04-15 | Riverside | 65 | 207 | 155 | 70 | 29 | 112 |
55361 | 55361 | 2020-04-15 | Sacramento | 67 | 66 | 60 | 20 | 14 | 55 |
55362 | 55362 | 2020-04-15 | San Benito | 69 | 1 | 0 | 0 | 0 | 4 |
55363 | 55363 | 2020-04-15 | San Bernardino | 71 | 149 | 109 | 65 | 39 | 61 |
55364 | 55364 | 2020-04-15 | San Diego | 73 | 236 | 112 | 98 | 23 | 148 |
55365 | 55365 | 2020-04-15 | San Francisco | 75 | 87 | 84 | 25 | 7 | 76 |
55366 | 55366 | 2020-04-15 | San Joaquin | 77 | 21 | 21 | 10 | 3 | 27 |
55367 | 55367 | 2020-04-15 | San Luis Obispo | 79 | 2 | 6 | 2 | 4 | 28 |
55368 | 55368 | 2020-04-15 | San Mateo | 81 | 53 | 18 | 14 | 4 | 27 |
55369 | 55369 | 2020-04-15 | Santa Barbara | 83 | 37 | 7 | 17 | 2 | 61 |
55370 | 55370 | 2020-04-15 | Santa Clara | 85 | 144 | 42 | 65 | 6 | 92 |
55371 | 55371 | 2020-04-15 | Santa Cruz | 87 | 4 | 2 | 3 | 2 | 5 |
55372 | 55372 | 2020-04-15 | Shasta | 89 | 1 | 1 | 1 | 0 | 13 |
55373 | 55373 | 2020-04-15 | Siskiyou | 93 | 2 | 0 | 0 | 2 | 3 |
55374 | 55374 | 2020-04-15 | Solano | 95 | 9 | 14 | 6 | 4 | 30 |
55375 | 55375 | 2020-04-15 | Sonoma | 97 | 3 | 13 | 1 | 7 | 25 |
55376 | 55376 | 2020-04-15 | Stanislaus | 99 | 19 | 17 | 7 | 4 | 33 |
55377 | 55377 | 2020-04-15 | Sutter | 101 | 0 | 0 | |||
55378 | 55378 | 2020-04-15 | Tehama | 103 | 0 | 0 | 0 | 0 | 7 |
55379 | 55379 | 2020-04-15 | Trinity | 105 | 0 | 0 | 0 | 0 | |
55380 | 55380 | 2020-04-15 | Tulare | 107 | 18 | 3 | 7 | 0 | 22 |
55381 | 55381 | 2020-04-15 | Tuolumne | 109 | 0 | 0 | 0 | 0 | 3 |
55382 | 55382 | 2020-04-15 | Ventura | 111 | 25 | 57 | 8 | 16 | 37 |
55383 | 55383 | 2020-04-15 | Yolo | 113 | 2 | 1 | 2 | 0 | 14 |
55384 | 55384 | 2020-04-15 | Yuba | 115 | 0 | 2 | 0 | 2 | 8 |
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 );