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-07-12
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: positive_patients
Link | rowid ▼ | date | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
9521 | 9521 | 2022-07-12 | Alameda | 1 | 159 | 45 | 21 | 4 | 96 |
9522 | 9522 | 2022-07-12 | Amador | 5 | 1 | 1 | 0 | 1 | 2 |
9523 | 9523 | 2022-07-12 | Butte | 7 | 30 | 0 | 5 | 0 | 13 |
9524 | 9524 | 2022-07-12 | Calaveras | 9 | 0 | 0 | 1 | 0 | 3 |
9525 | 9525 | 2022-07-12 | Colusa | 11 | 1 | 0 | 0 | 0 | 0 |
9526 | 9526 | 2022-07-12 | Contra Costa | 13 | 100 | 25 | 15 | 1 | 25 |
9527 | 9527 | 2022-07-12 | Del Norte | 15 | 8 | 0 | 2 | 0 | 0 |
9528 | 9528 | 2022-07-12 | El Dorado | 17 | 12 | 0 | 3 | 0 | 2 |
9529 | 9529 | 2022-07-12 | Fresno | 19 | 183 | 31 | 13 | 2 | 32 |
9530 | 9530 | 2022-07-12 | Glenn | 21 | 0 | 0 | 0 | 0 | 0 |
9531 | 9531 | 2022-07-12 | Humboldt | 23 | 13 | 1 | 3 | 0 | 7 |
9532 | 9532 | 2022-07-12 | Imperial | 25 | 18 | 0 | 1 | 0 | 9 |
9533 | 9533 | 2022-07-12 | Inyo | 27 | 0 | 0 | 0 | 0 | 1 |
9534 | 9534 | 2022-07-12 | Kern | 29 | 82 | 1 | 9 | 0 | 20 |
9535 | 9535 | 2022-07-12 | Kings | 31 | 13 | 0 | 1 | 0 | 3 |
9536 | 9536 | 2022-07-12 | Lake | 33 | 1 | 0 | 1 | 0 | 0 |
9537 | 9537 | 2022-07-12 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
9538 | 9538 | 2022-07-12 | Los Angeles | 37 | 1170 | 102 | 123 | 7 | 720 |
9539 | 9539 | 2022-07-12 | Madera | 39 | 14 | 0 | 3 | 1 | 10 |
9540 | 9540 | 2022-07-12 | Marin | 41 | 16 | 6 | 4 | 0 | 8 |
9541 | 9541 | 2022-07-12 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
9542 | 9542 | 2022-07-12 | Mendocino | 45 | 4 | 0 | 1 | 0 | 0 |
9543 | 9543 | 2022-07-12 | Merced | 47 | 17 | 0 | 2 | 0 | 8 |
9544 | 9544 | 2022-07-12 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
9545 | 9545 | 2022-07-12 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
9546 | 9546 | 2022-07-12 | Monterey | 53 | 46 | 0 | 3 | 0 | 20 |
9547 | 9547 | 2022-07-12 | Napa | 55 | 15 | 0 | 1 | 0 | 4 |
9548 | 9548 | 2022-07-12 | Nevada | 57 | 11 | 0 | 2 | 0 | 0 |
9549 | 9549 | 2022-07-12 | Orange | 59 | 301 | 20 | 27 | 3 | 169 |
9550 | 9550 | 2022-07-12 | Placer | 61 | 82 | 16 | 7 | 3 | 16 |
9551 | 9551 | 2022-07-12 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
9552 | 9552 | 2022-07-12 | Riverside | 65 | 236 | 15 | 13 | 1 | 106 |
9553 | 9553 | 2022-07-12 | Sacramento | 67 | 222 | 35 | 25 | 3 | 97 |
9554 | 9554 | 2022-07-12 | San Benito | 69 | 2 | 0 | 0 | 0 | 0 |
9555 | 9555 | 2022-07-12 | San Bernardino | 71 | 228 | 7 | 28 | 0 | 156 |
9556 | 9556 | 2022-07-12 | San Diego | 73 | 398 | 22 | 45 | 2 | 249 |
9557 | 9557 | 2022-07-12 | San Francisco | 75 | 130 | 9 | 24 | 0 | 96 |
9558 | 9558 | 2022-07-12 | San Joaquin | 77 | 73 | 4 | 17 | 0 | 6 |
9559 | 9559 | 2022-07-12 | San Luis Obispo | 79 | 18 | 0 | 0 | 0 | 22 |
9560 | 9560 | 2022-07-12 | San Mateo | 81 | 39 | 16 | 6 | 0 | 22 |
9561 | 9561 | 2022-07-12 | Santa Barbara | 83 | 48 | 2 | 5 | 2 | 19 |
9562 | 9562 | 2022-07-12 | Santa Clara | 85 | 252 | 17 | 41 | 2 | 55 |
9563 | 9563 | 2022-07-12 | Santa Cruz | 87 | 21 | 0 | 1 | 0 | 6 |
9564 | 9564 | 2022-07-12 | Shasta | 89 | 32 | 12 | 6 | 0 | 24 |
9565 | 9565 | 2022-07-12 | Siskiyou | 93 | 4 | 0 | 1 | 0 | 4 |
9566 | 9566 | 2022-07-12 | Solano | 95 | 47 | 19 | 5 | 1 | 22 |
9567 | 9567 | 2022-07-12 | Sonoma | 97 | 45 | 5 | 6 | 0 | 27 |
9568 | 9568 | 2022-07-12 | Stanislaus | 99 | 107 | 13 | 8 | 1 | 28 |
9569 | 9569 | 2022-07-12 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
9570 | 9570 | 2022-07-12 | Tehama | 103 | 9 | 0 | 1 | 0 | 4 |
9571 | 9571 | 2022-07-12 | Trinity | 105 | 1 | 0 | 0 | 0 | 0 |
9572 | 9572 | 2022-07-12 | Tulare | 107 | 47 | 3 | 2 | 0 | 19 |
9573 | 9573 | 2022-07-12 | Tuolumne | 109 | 7 | 0 | 0 | 0 | 2 |
9574 | 9574 | 2022-07-12 | Ventura | 111 | 95 | 0 | 6 | 0 | 34 |
9575 | 9575 | 2022-07-12 | Yolo | 113 | 10 | 0 | 2 | 0 | 1 |
9576 | 9576 | 2022-07-12 | Yuba | 115 | 9 | 0 | 0 | 0 | 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 );