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-06-09
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: suspected_patients, icu_suspected_patients, icu_available_beds
Link | rowid ▼ | date | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
11369 | 11369 | 2022-06-09 | Alameda | 1 | 109 | 41 | 12 | 5 | 89 |
11370 | 11370 | 2022-06-09 | Amador | 5 | 0 | 0 | 0 | 0 | 3 |
11371 | 11371 | 2022-06-09 | Butte | 7 | 24 | 1 | 1 | 0 | 16 |
11372 | 11372 | 2022-06-09 | Calaveras | 9 | 1 | 0 | 1 | 0 | 3 |
11373 | 11373 | 2022-06-09 | Colusa | 11 | 10 | 0 | 0 | 0 | 0 |
11374 | 11374 | 2022-06-09 | Contra Costa | 13 | 95 | 34 | 10 | 5 | 41 |
11375 | 11375 | 2022-06-09 | Del Norte | 15 | 2 | 0 | 0 | 0 | 0 |
11376 | 11376 | 2022-06-09 | El Dorado | 17 | 12 | 1 | 3 | 1 | 5 |
11377 | 11377 | 2022-06-09 | Fresno | 19 | 109 | 24 | 8 | 5 | 26 |
11378 | 11378 | 2022-06-09 | Glenn | 21 | 5 | 0 | 0 | 0 | 0 |
11379 | 11379 | 2022-06-09 | Humboldt | 23 | 16 | 1 | 3 | 0 | 4 |
11380 | 11380 | 2022-06-09 | Imperial | 25 | 7 | 0 | 1 | 0 | 7 |
11381 | 11381 | 2022-06-09 | Inyo | 27 | 0 | 0 | 0 | 0 | 2 |
11382 | 11382 | 2022-06-09 | Kern | 29 | 38 | 1 | 8 | 0 | 19 |
11383 | 11383 | 2022-06-09 | Kings | 31 | 8 | 2 | 0 | 2 | 4 |
11384 | 11384 | 2022-06-09 | Lake | 33 | 5 | 0 | 3 | 0 | 0 |
11385 | 11385 | 2022-06-09 | Lassen | 35 | 2 | 0 | 0 | 0 | 0 |
11386 | 11386 | 2022-06-09 | Los Angeles | 37 | 616 | 87 | 63 | 3 | 611 |
11387 | 11387 | 2022-06-09 | Madera | 39 | 6 | 6 | 1 | 0 | 7 |
11388 | 11388 | 2022-06-09 | Marin | 41 | 17 | 11 | 1 | 0 | 8 |
11389 | 11389 | 2022-06-09 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
11390 | 11390 | 2022-06-09 | Mendocino | 45 | 7 | 0 | 2 | 0 | 1 |
11391 | 11391 | 2022-06-09 | Merced | 47 | 18 | 0 | 2 | 0 | 7 |
11392 | 11392 | 2022-06-09 | Modoc | 49 | 1 | 0 | 0 | 0 | 0 |
11393 | 11393 | 2022-06-09 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
11394 | 11394 | 2022-06-09 | Monterey | 53 | 22 | 6 | 1 | 0 | 18 |
11395 | 11395 | 2022-06-09 | Napa | 55 | 12 | 0 | 1 | 0 | 5 |
11396 | 11396 | 2022-06-09 | Nevada | 57 | 4 | 0 | 0 | 0 | 4 |
11397 | 11397 | 2022-06-09 | Orange | 59 | 188 | 3 | 20 | 0 | 180 |
11398 | 11398 | 2022-06-09 | Placer | 61 | 68 | 21 | 4 | 4 | 17 |
11399 | 11399 | 2022-06-09 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
11400 | 11400 | 2022-06-09 | Riverside | 65 | 98 | 19 | 9 | 4 | 118 |
11401 | 11401 | 2022-06-09 | Sacramento | 67 | 191 | 27 | 28 | 5 | 71 |
11402 | 11402 | 2022-06-09 | San Benito | 69 | 3 | 0 | 1 | 0 | 1 |
11403 | 11403 | 2022-06-09 | San Bernardino | 71 | 89 | 9 | 15 | 1 | 163 |
11404 | 11404 | 2022-06-09 | San Diego | 73 | 240 | 9 | 23 | 0 | 268 |
11405 | 11405 | 2022-06-09 | San Francisco | 75 | 88 | 13 | 12 | 1 | 103 |
11406 | 11406 | 2022-06-09 | San Joaquin | 77 | 44 | 6 | 4 | 1 | 19 |
11407 | 11407 | 2022-06-09 | San Luis Obispo | 79 | 13 | 1 | 0 | 0 | 17 |
11408 | 11408 | 2022-06-09 | San Mateo | 81 | 42 | 6 | 1 | 1 | 26 |
11409 | 11409 | 2022-06-09 | Santa Barbara | 83 | 23 | 1 | 3 | 1 | 18 |
11410 | 11410 | 2022-06-09 | Santa Clara | 85 | 194 | 23 | 29 | 3 | 53 |
11411 | 11411 | 2022-06-09 | Santa Cruz | 87 | 22 | 0 | 1 | 0 | 6 |
11412 | 11412 | 2022-06-09 | Shasta | 89 | 11 | 0 | 1 | 0 | 27 |
11413 | 11413 | 2022-06-09 | Siskiyou | 93 | 1 | 0 | 0 | 0 | 7 |
11414 | 11414 | 2022-06-09 | Solano | 95 | 39 | 26 | 5 | 3 | 22 |
11415 | 11415 | 2022-06-09 | Sonoma | 97 | 43 | 5 | 5 | 0 | 24 |
11416 | 11416 | 2022-06-09 | Stanislaus | 99 | 65 | 20 | 7 | 4 | 39 |
11417 | 11417 | 2022-06-09 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
11418 | 11418 | 2022-06-09 | Tehama | 103 | 1 | 0 | 0 | 0 | 2 |
11419 | 11419 | 2022-06-09 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
11420 | 11420 | 2022-06-09 | Tulare | 107 | 17 | 2 | 0 | 1 | 26 |
11421 | 11421 | 2022-06-09 | Tuolumne | 109 | 2 | 0 | 1 | 0 | 3 |
11422 | 11422 | 2022-06-09 | Ventura | 111 | 41 | 1 | 2 | 0 | 23 |
11423 | 11423 | 2022-06-09 | Yolo | 113 | 4 | 0 | 1 | 0 | 3 |
11424 | 11424 | 2022-06-09 | Yuba | 115 | 14 | 0 | 1 | 0 | 7 |
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 );