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-08-30
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: icu_positive_patients
Link | rowid ▼ | date | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
6777 | 6777 | 2022-08-30 | Alameda | 1 | 121 | 44 | 36 | 8 | 84 |
6778 | 6778 | 2022-08-30 | Amador | 5 | 2 | 0 | 0 | 0 | 6 |
6779 | 6779 | 2022-08-30 | Butte | 7 | 25 | 1 | 3 | 0 | 15 |
6780 | 6780 | 2022-08-30 | Calaveras | 9 | 1 | 0 | 0 | 0 | 1 |
6781 | 6781 | 2022-08-30 | Colusa | 11 | 1 | 0 | 0 | 0 | 0 |
6782 | 6782 | 2022-08-30 | Contra Costa | 13 | 57 | 22 | 9 | 2 | 35 |
6783 | 6783 | 2022-08-30 | Del Norte | 15 | 6 | 0 | 1 | 0 | 0 |
6784 | 6784 | 2022-08-30 | El Dorado | 17 | 0 | 0 | 0 | 0 | 1 |
6785 | 6785 | 2022-08-30 | Fresno | 19 | 178 | 12 | 16 | 0 | 28 |
6786 | 6786 | 2022-08-30 | Glenn | 21 | 3 | 0 | 0 | 0 | 0 |
6787 | 6787 | 2022-08-30 | Humboldt | 23 | 4 | 0 | 0 | 0 | 5 |
6788 | 6788 | 2022-08-30 | Imperial | 25 | 20 | 0 | 0 | 0 | 14 |
6789 | 6789 | 2022-08-30 | Inyo | 27 | 0 | 0 | 0 | 0 | 3 |
6790 | 6790 | 2022-08-30 | Kern | 29 | 63 | 0 | 6 | 0 | 27 |
6791 | 6791 | 2022-08-30 | Kings | 31 | 7 | 0 | 0 | 0 | 3 |
6792 | 6792 | 2022-08-30 | Lake | 33 | 3 | 0 | 0 | 0 | 2 |
6793 | 6793 | 2022-08-30 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
6794 | 6794 | 2022-08-30 | Los Angeles | 37 | 796 | 57 | 79 | 10 | 689 |
6795 | 6795 | 2022-08-30 | Madera | 39 | 20 | 8 | 5 | 1 | 9 |
6796 | 6796 | 2022-08-30 | Marin | 41 | 19 | 5 | 1 | 0 | 2 |
6797 | 6797 | 2022-08-30 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
6798 | 6798 | 2022-08-30 | Mendocino | 45 | 4 | 0 | 1 | 0 | 2 |
6799 | 6799 | 2022-08-30 | Merced | 47 | 11 | 0 | 0 | 0 | 15 |
6800 | 6800 | 2022-08-30 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
6801 | 6801 | 2022-08-30 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
6802 | 6802 | 2022-08-30 | Monterey | 53 | 32 | 1 | 4 | 0 | 19 |
6803 | 6803 | 2022-08-30 | Napa | 55 | 9 | 0 | 0 | 0 | 5 |
6804 | 6804 | 2022-08-30 | Nevada | 57 | 6 | 1 | 0 | 0 | 8 |
6805 | 6805 | 2022-08-30 | Orange | 59 | 204 | 6 | 27 | 1 | 139 |
6806 | 6806 | 2022-08-30 | Placer | 61 | 72 | 16 | 12 | 3 | 18 |
6807 | 6807 | 2022-08-30 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
6808 | 6808 | 2022-08-30 | Riverside | 65 | 140 | 18 | 14 | 3 | 94 |
6809 | 6809 | 2022-08-30 | Sacramento | 67 | 165 | 29 | 20 | 4 | 98 |
6810 | 6810 | 2022-08-30 | San Benito | 69 | 0 | 0 | 0 | 0 | 0 |
6811 | 6811 | 2022-08-30 | San Bernardino | 71 | 169 | 5 | 17 | 2 | 143 |
6812 | 6812 | 2022-08-30 | San Diego | 73 | 254 | 15 | 28 | 1 | 253 |
6813 | 6813 | 2022-08-30 | San Francisco | 75 | 64 | 6 | 11 | 1 | 57 |
6814 | 6814 | 2022-08-30 | San Joaquin | 77 | 50 | 3 | 7 | 0 | 15 |
6815 | 6815 | 2022-08-30 | San Luis Obispo | 79 | 18 | 0 | 0 | 0 | 21 |
6816 | 6816 | 2022-08-30 | San Mateo | 81 | 34 | 15 | 5 | 4 | 55 |
6817 | 6817 | 2022-08-30 | Santa Barbara | 83 | 33 | 0 | 2 | 0 | 32 |
6818 | 6818 | 2022-08-30 | Santa Clara | 85 | 172 | 20 | 26 | 2 | 60 |
6819 | 6819 | 2022-08-30 | Santa Cruz | 87 | 9 | 0 | 1 | 0 | 1 |
6820 | 6820 | 2022-08-30 | Shasta | 89 | 19 | 1 | 0 | 0 | 31 |
6821 | 6821 | 2022-08-30 | Siskiyou | 93 | 1 | 0 | 0 | 0 | 1 |
6822 | 6822 | 2022-08-30 | Solano | 95 | 46 | 28 | 8 | 2 | 11 |
6823 | 6823 | 2022-08-30 | Sonoma | 97 | 38 | 6 | 2 | 0 | 16 |
6824 | 6824 | 2022-08-30 | Stanislaus | 99 | 86 | 13 | 7 | 0 | 28 |
6825 | 6825 | 2022-08-30 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
6826 | 6826 | 2022-08-30 | Tehama | 103 | 5 | 0 | 1 | 0 | 6 |
6827 | 6827 | 2022-08-30 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
6828 | 6828 | 2022-08-30 | Tulare | 107 | 42 | 2 | 2 | 0 | 27 |
6829 | 6829 | 2022-08-30 | Tuolumne | 109 | 0 | 0 | 0 | 0 | 2 |
6830 | 6830 | 2022-08-30 | Ventura | 111 | 65 | 3 | 6 | 0 | 40 |
6831 | 6831 | 2022-08-30 | Yolo | 113 | 11 | 0 | 6 | 0 | 1 |
6832 | 6832 | 2022-08-30 | Yuba | 115 | 10 | 0 | 0 | 0 | 11 |
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 );