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 2021-01-31
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: icu_suspected_patients
Link | rowid ▼ | date | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
39033 | 39033 | 2021-01-31 | Alameda | 1 | 318 | 31 | 97 | 5 | 68 |
39034 | 39034 | 2021-01-31 | Amador | 5 | 8 | 0 | 5 | 0 | 1 |
39035 | 39035 | 2021-01-31 | Butte | 7 | 43 | 0 | 9 | 0 | 4 |
39036 | 39036 | 2021-01-31 | Calaveras | 9 | 2 | 0 | 1 | 0 | 5 |
39037 | 39037 | 2021-01-31 | Colusa | 11 | 5 | 0 | 0 | 0 | 5 |
39038 | 39038 | 2021-01-31 | Contra Costa | 13 | 172 | 16 | 37 | 2 | 38 |
39039 | 39039 | 2021-01-31 | Del Norte | 15 | 0 | 0 | 0 | 0 | 2 |
39040 | 39040 | 2021-01-31 | El Dorado | 17 | 12 | 0 | 3 | 0 | 9 |
39041 | 39041 | 2021-01-31 | Fresno | 19 | 452 | 29 | 72 | 1 | 9 |
39042 | 39042 | 2021-01-31 | Glenn | 21 | 3 | 2 | 0 | 0 | 0 |
39043 | 39043 | 2021-01-31 | Humboldt | 23 | 10 | 2 | 2 | 1 | 10 |
39044 | 39044 | 2021-01-31 | Imperial | 25 | 72 | 0 | 31 | 0 | 3 |
39045 | 39045 | 2021-01-31 | Inyo | 27 | 4 | 0 | 1 | 0 | 1 |
39046 | 39046 | 2021-01-31 | Kern | 29 | 293 | 6 | 75 | 0 | 27 |
39047 | 39047 | 2021-01-31 | Kings | 31 | 84 | 0 | 9 | 0 | 2 |
39048 | 39048 | 2021-01-31 | Lake | 33 | 7 | 0 | 2 | 0 | 2 |
39049 | 39049 | 2021-01-31 | Lassen | 35 | 4 | 0 | 0 | 0 | 0 |
39050 | 39050 | 2021-01-31 | Los Angeles | 37 | 5259 | 300 | 1415 | 36 | 327 |
39051 | 39051 | 2021-01-31 | Madera | 39 | 51 | 10 | 14 | 2 | 0 |
39052 | 39052 | 2021-01-31 | Marin | 41 | 29 | 3 | 6 | 0 | 13 |
39053 | 39053 | 2021-01-31 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
39054 | 39054 | 2021-01-31 | Mendocino | 45 | 10 | 1 | 1 | 0 | 5 |
39055 | 39055 | 2021-01-31 | Merced | 47 | 39 | 0 | 19 | 0 | 4 |
39056 | 39056 | 2021-01-31 | Modoc | 49 | 1 | 0 | 0 | 0 | 0 |
39057 | 39057 | 2021-01-31 | Mono | 51 | 0 | 0 | 0 | 0 | 1 |
39058 | 39058 | 2021-01-31 | Monterey | 53 | 128 | 1 | 28 | 0 | 20 |
39059 | 39059 | 2021-01-31 | Napa | 55 | 15 | 0 | 4 | 0 | 6 |
39060 | 39060 | 2021-01-31 | Nevada | 57 | 1 | 11 | 0 | 2 | 0 |
39061 | 39061 | 2021-01-31 | Orange | 59 | 1362 | 30 | 384 | 3 | 120 |
39062 | 39062 | 2021-01-31 | Placer | 61 | 107 | 11 | 24 | 1 | 13 |
39063 | 39063 | 2021-01-31 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
39064 | 39064 | 2021-01-31 | Riverside | 65 | 979 | 129 | 268 | 11 | 46 |
39065 | 39065 | 2021-01-31 | Sacramento | 67 | 339 | 14 | 102 | 4 | 67 |
39066 | 39066 | 2021-01-31 | San Benito | 69 | 10 | 0 | 4 | 0 | 0 |
39067 | 39067 | 2021-01-31 | San Bernardino | 71 | 1036 | 39 | 256 | 4 | 61 |
39068 | 39068 | 2021-01-31 | San Diego | 73 | 1306 | 41 | 379 | 8 | 161 |
39069 | 39069 | 2021-01-31 | San Francisco | 75 | 170 | 4 | 49 | 0 | 61 |
39070 | 39070 | 2021-01-31 | San Joaquin | 77 | 212 | 15 | 69 | 1 | 7 |
39071 | 39071 | 2021-01-31 | San Luis Obispo | 79 | 45 | 2 | 14 | 0 | 16 |
39072 | 39072 | 2021-01-31 | San Mateo | 81 | 139 | 5 | 31 | 0 | 18 |
39073 | 39073 | 2021-01-31 | Santa Barbara | 83 | 170 | 8 | 47 | 2 | 17 |
39074 | 39074 | 2021-01-31 | Santa Clara | 85 | 454 | 12 | 129 | 3 | 41 |
39075 | 39075 | 2021-01-31 | Santa Cruz | 87 | 42 | 2 | 12 | 0 | 4 |
39076 | 39076 | 2021-01-31 | Shasta | 89 | 25 | 0 | 1 | 0 | 15 |
39077 | 39077 | 2021-01-31 | Siskiyou | 93 | 0 | 0 | 0 | 0 | 4 |
39078 | 39078 | 2021-01-31 | Solano | 95 | 126 | 4 | 36 | 0 | 10 |
39079 | 39079 | 2021-01-31 | Sonoma | 97 | 78 | 2 | 21 | 0 | 17 |
39080 | 39080 | 2021-01-31 | Stanislaus | 99 | 246 | 11 | 61 | 1 | 15 |
39081 | 39081 | 2021-01-31 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
39082 | 39082 | 2021-01-31 | Tehama | 103 | 11 | 0 | 2 | 0 | 1 |
39083 | 39083 | 2021-01-31 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
39084 | 39084 | 2021-01-31 | Tulare | 107 | 149 | 5 | 24 | 1 | 8 |
39085 | 39085 | 2021-01-31 | Tuolumne | 109 | 9 | 0 | 2 | 0 | 1 |
39086 | 39086 | 2021-01-31 | Ventura | 111 | 351 | 16 | 90 | 4 | 20 |
39087 | 39087 | 2021-01-31 | Yolo | 113 | 12 | 0 | 8 | 0 | 1 |
39088 | 39088 | 2021-01-31 | Yuba | 115 | 43 | 7 | 13 | 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 );