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-04-14
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: suspected_patients, icu_available_beds
Link | rowid ▼ | date | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
14505 | 14505 | 2022-04-14 | Alameda | 1 | 53 | 36 | 4 | 4 | 123 |
14506 | 14506 | 2022-04-14 | Amador | 5 | 1 | 0 | 0 | 0 | 1 |
14507 | 14507 | 2022-04-14 | Butte | 7 | 5 | 0 | 1 | 0 | 15 |
14508 | 14508 | 2022-04-14 | Calaveras | 9 | 0 | 0 | 0 | 0 | 5 |
14509 | 14509 | 2022-04-14 | Colusa | 11 | 0 | 0 | 0 | 0 | 0 |
14510 | 14510 | 2022-04-14 | Contra Costa | 13 | 26 | 24 | 2 | 3 | 36 |
14511 | 14511 | 2022-04-14 | Del Norte | 15 | 0 | 0 | 0 | 0 | 2 |
14512 | 14512 | 2022-04-14 | El Dorado | 17 | 0 | 0 | 0 | 0 | 2 |
14513 | 14513 | 2022-04-14 | Fresno | 19 | 45 | 11 | 4 | 1 | 25 |
14514 | 14514 | 2022-04-14 | Glenn | 21 | 0 | 0 | 0 | 0 | 0 |
14515 | 14515 | 2022-04-14 | Humboldt | 23 | 8 | 1 | 2 | 0 | 6 |
14516 | 14516 | 2022-04-14 | Imperial | 25 | 3 | 0 | 1 | 0 | 8 |
14517 | 14517 | 2022-04-14 | Inyo | 27 | 0 | 0 | 0 | 0 | 2 |
14518 | 14518 | 2022-04-14 | Kern | 29 | 19 | 0 | 8 | 0 | 24 |
14519 | 14519 | 2022-04-14 | Kings | 31 | 3 | 0 | 0 | 0 | 6 |
14520 | 14520 | 2022-04-14 | Lake | 33 | 1 | 0 | 1 | 0 | 0 |
14521 | 14521 | 2022-04-14 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
14522 | 14522 | 2022-04-14 | Los Angeles | 37 | 228 | 56 | 31 | 3 | 655 |
14523 | 14523 | 2022-04-14 | Madera | 39 | 4 | 4 | 2 | 0 | 9 |
14524 | 14524 | 2022-04-14 | Marin | 41 | 4 | 3 | 1 | 0 | 9 |
14525 | 14525 | 2022-04-14 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
14526 | 14526 | 2022-04-14 | Mendocino | 45 | 1 | 0 | 1 | 0 | 4 |
14527 | 14527 | 2022-04-14 | Merced | 47 | 8 | 0 | 1 | 0 | 12 |
14528 | 14528 | 2022-04-14 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
14529 | 14529 | 2022-04-14 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
14530 | 14530 | 2022-04-14 | Monterey | 53 | 9 | 0 | 0 | 0 | 17 |
14531 | 14531 | 2022-04-14 | Napa | 55 | 2 | 0 | 0 | 0 | 5 |
14532 | 14532 | 2022-04-14 | Nevada | 57 | 2 | 0 | 2 | 0 | 2 |
14533 | 14533 | 2022-04-14 | Orange | 59 | 67 | 6 | 13 | 0 | 167 |
14534 | 14534 | 2022-04-14 | Placer | 61 | 30 | 16 | 5 | 2 | 20 |
14535 | 14535 | 2022-04-14 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
14536 | 14536 | 2022-04-14 | Riverside | 65 | 54 | 7 | 8 | 0 | 104 |
14537 | 14537 | 2022-04-14 | Sacramento | 67 | 56 | 16 | 6 | 4 | 97 |
14538 | 14538 | 2022-04-14 | San Benito | 69 | 0 | 0 | 0 | 0 | 1 |
14539 | 14539 | 2022-04-14 | San Bernardino | 71 | 42 | 7 | 8 | 2 | 199 |
14540 | 14540 | 2022-04-14 | San Diego | 73 | 105 | 14 | 21 | 2 | 252 |
14541 | 14541 | 2022-04-14 | San Francisco | 75 | 30 | 11 | 1 | 3 | 90 |
14542 | 14542 | 2022-04-14 | San Joaquin | 77 | 9 | 5 | 4 | 1 | 17 |
14543 | 14543 | 2022-04-14 | San Luis Obispo | 79 | 2 | 0 | 0 | 0 | 16 |
14544 | 14544 | 2022-04-14 | San Mateo | 81 | 14 | 8 | 3 | 0 | 19 |
14545 | 14545 | 2022-04-14 | Santa Barbara | 83 | 4 | 0 | 0 | 0 | 30 |
14546 | 14546 | 2022-04-14 | Santa Clara | 85 | 83 | 16 | 13 | 4 | 68 |
14547 | 14547 | 2022-04-14 | Santa Cruz | 87 | 3 | 0 | 1 | 0 | 7 |
14548 | 14548 | 2022-04-14 | Shasta | 89 | 4 | 0 | 2 | 0 | 24 |
14549 | 14549 | 2022-04-14 | Siskiyou | 93 | 1 | 0 | 1 | 0 | 3 |
14550 | 14550 | 2022-04-14 | Solano | 95 | 12 | 12 | 1 | 2 | 26 |
14551 | 14551 | 2022-04-14 | Sonoma | 97 | 15 | 2 | 2 | 0 | 14 |
14552 | 14552 | 2022-04-14 | Stanislaus | 99 | 20 | 12 | 4 | 2 | 36 |
14553 | 14553 | 2022-04-14 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
14554 | 14554 | 2022-04-14 | Tehama | 103 | 0 | 0 | 0 | 0 | 6 |
14555 | 14555 | 2022-04-14 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
14556 | 14556 | 2022-04-14 | Tulare | 107 | 13 | 3 | 0 | 0 | 21 |
14557 | 14557 | 2022-04-14 | Tuolumne | 109 | 0 | 0 | 0 | 0 | 3 |
14558 | 14558 | 2022-04-14 | Ventura | 111 | 11 | 1 | 1 | 0 | 38 |
14559 | 14559 | 2022-04-14 | Yolo | 113 | 2 | 0 | 0 | 0 | 0 |
14560 | 14560 | 2022-04-14 | Yuba | 115 | 1 | 0 | 0 | 0 | 4 |
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 );