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-05-21
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: positive_patients, icu_positive_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 |
---|---|---|---|---|---|---|---|---|---|
12433 | 12433 | 2022-05-21 | Alameda | 1 | 92 | 41 | 3 | 8 | 90 |
12434 | 12434 | 2022-05-21 | Amador | 5 | 0 | 0 | 0 | 0 | 2 |
12435 | 12435 | 2022-05-21 | Butte | 7 | 7 | 0 | 0 | 0 | 15 |
12436 | 12436 | 2022-05-21 | Calaveras | 9 | 0 | 0 | 0 | 0 | 4 |
12437 | 12437 | 2022-05-21 | Colusa | 11 | 0 | 0 | 0 | 0 | 0 |
12438 | 12438 | 2022-05-21 | Contra Costa | 13 | 76 | 31 | 11 | 5 | 32 |
12439 | 12439 | 2022-05-21 | Del Norte | 15 | 0 | 0 | 0 | 0 | 3 |
12440 | 12440 | 2022-05-21 | El Dorado | 17 | 4 | 0 | 1 | 0 | 1 |
12441 | 12441 | 2022-05-21 | Fresno | 19 | 66 | 20 | 9 | 0 | 26 |
12442 | 12442 | 2022-05-21 | Glenn | 21 | 0 | 0 | 0 | 0 | 0 |
12443 | 12443 | 2022-05-21 | Humboldt | 23 | 13 | 2 | 5 | 0 | 6 |
12444 | 12444 | 2022-05-21 | Imperial | 25 | 4 | 0 | 2 | 0 | 11 |
12445 | 12445 | 2022-05-21 | Inyo | 27 | 0 | 0 | 0 | 0 | 2 |
12446 | 12446 | 2022-05-21 | Kern | 29 | 39 | 0 | 6 | 0 | 20 |
12447 | 12447 | 2022-05-21 | Kings | 31 | 0 | 0 | 0 | 0 | 2 |
12448 | 12448 | 2022-05-21 | Lake | 33 | 0 | 0 | 0 | 0 | 0 |
12449 | 12449 | 2022-05-21 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
12450 | 12450 | 2022-05-21 | Los Angeles | 37 | 385 | 50 | 49 | 7 | 618 |
12451 | 12451 | 2022-05-21 | Madera | 39 | 2 | 3 | 1 | 2 | 7 |
12452 | 12452 | 2022-05-21 | Marin | 41 | 16 | 7 | 2 | 0 | 9 |
12453 | 12453 | 2022-05-21 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
12454 | 12454 | 2022-05-21 | Mendocino | 45 | 5 | 0 | 1 | 0 | 2 |
12455 | 12455 | 2022-05-21 | Merced | 47 | 3 | 0 | 0 | 0 | 11 |
12456 | 12456 | 2022-05-21 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
12457 | 12457 | 2022-05-21 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
12458 | 12458 | 2022-05-21 | Monterey | 53 | 11 | 0 | 1 | 0 | 22 |
12459 | 12459 | 2022-05-21 | Napa | 55 | 5 | 0 | 0 | 0 | 2 |
12460 | 12460 | 2022-05-21 | Nevada | 57 | 1 | 0 | 0 | 0 | 6 |
12461 | 12461 | 2022-05-21 | Orange | 59 | 112 | 4 | 15 | 0 | 191 |
12462 | 12462 | 2022-05-21 | Placer | 61 | 39 | 15 | 4 | 0 | 14 |
12463 | 12463 | 2022-05-21 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
12464 | 12464 | 2022-05-21 | Riverside | 65 | 79 | 17 | 9 | 1 | 107 |
12465 | 12465 | 2022-05-21 | Sacramento | 67 | 116 | 18 | 15 | 4 | 76 |
12466 | 12466 | 2022-05-21 | San Benito | 69 | 0 | 0 | 0 | 0 | 0 |
12467 | 12467 | 2022-05-21 | San Bernardino | 71 | 51 | 7 | 8 | 0 | 206 |
12468 | 12468 | 2022-05-21 | San Diego | 73 | 142 | 10 | 21 | 0 | 218 |
12469 | 12469 | 2022-05-21 | San Francisco | 75 | 94 | 2 | 13 | 0 | 84 |
12470 | 12470 | 2022-05-21 | San Joaquin | 77 | 26 | 4 | 9 | 0 | 28 |
12471 | 12471 | 2022-05-21 | San Luis Obispo | 79 | 11 | 0 | 0 | 0 | 19 |
12472 | 12472 | 2022-05-21 | San Mateo | 81 | 47 | 4 | 2 | 1 | 14 |
12473 | 12473 | 2022-05-21 | Santa Barbara | 83 | 20 | 0 | 4 | 0 | 23 |
12474 | 12474 | 2022-05-21 | Santa Clara | 85 | 129 | 22 | 17 | 0 | 59 |
12475 | 12475 | 2022-05-21 | Santa Cruz | 87 | 13 | 0 | 2 | 0 | 6 |
12476 | 12476 | 2022-05-21 | Shasta | 89 | 7 | 0 | 3 | 0 | 20 |
12477 | 12477 | 2022-05-21 | Siskiyou | 93 | 1 | 0 | 0 | 0 | 4 |
12478 | 12478 | 2022-05-21 | Solano | 95 | 27 | 22 | 2 | 1 | 19 |
12479 | 12479 | 2022-05-21 | Sonoma | 97 | 36 | 4 | 1 | 0 | 17 |
12480 | 12480 | 2022-05-21 | Stanislaus | 99 | 42 | 11 | 6 | 2 | 38 |
12481 | 12481 | 2022-05-21 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
12482 | 12482 | 2022-05-21 | Tehama | 103 | 1 | 0 | 1 | 0 | 2 |
12483 | 12483 | 2022-05-21 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
12484 | 12484 | 2022-05-21 | Tulare | 107 | 22 | 6 | 0 | 0 | 19 |
12485 | 12485 | 2022-05-21 | Tuolumne | 109 | 1 | 0 | 0 | 0 | 0 |
12486 | 12486 | 2022-05-21 | Ventura | 111 | 36 | 2 | 2 | 0 | 30 |
12487 | 12487 | 2022-05-21 | Yolo | 113 | 2 | 0 | 1 | 0 | 1 |
12488 | 12488 | 2022-05-21 | Yuba | 115 | 6 | 0 | 2 | 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 );