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,333 rows sorted by icu_positive_patients
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | fips | positive_patients | suspected_patients | icu_positive_patients ▼ | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
2 | 2 | 2022-12-29 | Amador | 5 | 5 | 1 | 0 | 0 | 0 |
4 | 4 | 2022-12-29 | Calaveras | 9 | 1 | 0 | 0 | 0 | 0 |
5 | 5 | 2022-12-29 | Colusa | 11 | 0 | 0 | 0 | 0 | 0 |
7 | 7 | 2022-12-29 | Del Norte | 15 | 1 | 0 | 0 | 0 | 1 |
10 | 10 | 2022-12-29 | Glenn | 21 | 0 | 0 | 0 | 0 | 0 |
13 | 13 | 2022-12-29 | Inyo | 27 | 0 | 0 | 0 | 0 | 4 |
17 | 17 | 2022-12-29 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
21 | 21 | 2022-12-29 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
24 | 24 | 2022-12-29 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
25 | 25 | 2022-12-29 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
27 | 27 | 2022-12-29 | Napa | 55 | 10 | 1 | 0 | 0 | 2 |
31 | 31 | 2022-12-29 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
45 | 45 | 2022-12-29 | Siskiyou | 93 | 0 | 0 | 0 | 0 | 3 |
49 | 49 | 2022-12-29 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
50 | 50 | 2022-12-29 | Tehama | 103 | 3 | 0 | 0 | 0 | 3 |
51 | 51 | 2022-12-29 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
53 | 53 | 2022-12-29 | Tuolumne | 109 | 5 | 0 | 0 | 0 | 1 |
58 | 58 | 2022-12-28 | Amador | 5 | 6 | 0 | 0 | 0 | 0 |
60 | 60 | 2022-12-28 | Calaveras | 9 | 1 | 0 | 0 | 0 | 0 |
61 | 61 | 2022-12-28 | Colusa | 11 | 0 | 0 | 0 | 0 | 0 |
63 | 63 | 2022-12-28 | Del Norte | 15 | 2 | 0 | 0 | 0 | 1 |
66 | 66 | 2022-12-28 | Glenn | 21 | 1 | 0 | 0 | 0 | 0 |
69 | 69 | 2022-12-28 | Inyo | 27 | 1 | 0 | 0 | 0 | 3 |
73 | 73 | 2022-12-28 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
77 | 77 | 2022-12-28 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
80 | 80 | 2022-12-28 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
81 | 81 | 2022-12-28 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
83 | 83 | 2022-12-28 | Napa | 55 | 10 | 0 | 0 | 0 | 0 |
87 | 87 | 2022-12-28 | Plumas | 63 | 1 | 0 | 0 | 0 | 0 |
95 | 95 | 2022-12-28 | San Luis Obispo | 79 | 21 | 1 | 0 | 0 | 17 |
101 | 101 | 2022-12-28 | Siskiyou | 93 | 2 | 0 | 0 | 0 | 2 |
105 | 105 | 2022-12-28 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
107 | 107 | 2022-12-28 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
109 | 109 | 2022-12-28 | Tuolumne | 109 | 4 | 0 | 0 | 0 | 2 |
111 | 111 | 2022-12-28 | Yolo | 113 | 9 | 0 | 0 | 0 | 0 |
114 | 114 | 2022-12-27 | Amador | 5 | 6 | 0 | 0 | 0 | 0 |
116 | 116 | 2022-12-27 | Calaveras | 9 | 1 | 0 | 0 | 0 | 0 |
117 | 117 | 2022-12-27 | Colusa | 11 | 0 | 0 | 0 | 0 | 0 |
119 | 119 | 2022-12-27 | Del Norte | 15 | 3 | 0 | 0 | 0 | 2 |
122 | 122 | 2022-12-27 | Glenn | 21 | 0 | 0 | 0 | 0 | 0 |
125 | 125 | 2022-12-27 | Inyo | 27 | 2 | 0 | 0 | 0 | 4 |
129 | 129 | 2022-12-27 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
133 | 133 | 2022-12-27 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
136 | 136 | 2022-12-27 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
137 | 137 | 2022-12-27 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
139 | 139 | 2022-12-27 | Napa | 55 | 13 | 0 | 0 | 0 | 2 |
140 | 140 | 2022-12-27 | Nevada | 57 | 9 | 0 | 0 | 0 | 3 |
143 | 143 | 2022-12-27 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
151 | 151 | 2022-12-27 | San Luis Obispo | 79 | 20 | 0 | 0 | 0 | 17 |
156 | 156 | 2022-12-27 | Shasta | 89 | 19 | 0 | 0 | 0 | 28 |
157 | 157 | 2022-12-27 | Siskiyou | 93 | 2 | 0 | 0 | 0 | 4 |
161 | 161 | 2022-12-27 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
163 | 163 | 2022-12-27 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
165 | 165 | 2022-12-27 | Tuolumne | 109 | 7 | 0 | 0 | 0 | 2 |
167 | 167 | 2022-12-27 | Yolo | 113 | 7 | 0 | 0 | 0 | 2 |
168 | 168 | 2022-12-27 | Yuba | 115 | 18 | 2 | 0 | 0 | 7 |
170 | 170 | 2022-12-26 | Amador | 5 | 5 | 0 | 0 | 0 | 0 |
172 | 172 | 2022-12-26 | Calaveras | 9 | 0 | 0 | 0 | 0 | 2 |
173 | 173 | 2022-12-26 | Colusa | 11 | 0 | 0 | 0 | 0 | 0 |
175 | 175 | 2022-12-26 | Del Norte | 15 | 3 | 0 | 0 | 0 | 4 |
176 | 176 | 2022-12-26 | El Dorado | 17 | 7 | 0 | 0 | 0 | 2 |
178 | 178 | 2022-12-26 | Glenn | 21 | 0 | 0 | 0 | 0 | 0 |
180 | 180 | 2022-12-26 | Imperial | 25 | 67 | 0 | 0 | 0 | 15 |
181 | 181 | 2022-12-26 | Inyo | 27 | 1 | 0 | 0 | 0 | 3 |
185 | 185 | 2022-12-26 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
189 | 189 | 2022-12-26 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
190 | 190 | 2022-12-26 | Mendocino | 45 | 10 | 0 | 0 | 0 | 2 |
192 | 192 | 2022-12-26 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
193 | 193 | 2022-12-26 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
194 | 194 | 2022-12-26 | Monterey | 53 | 21 | 0 | 0 | 0 | 22 |
195 | 195 | 2022-12-26 | Napa | 55 | 12 | 0 | 0 | 0 | 1 |
199 | 199 | 2022-12-26 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
207 | 207 | 2022-12-26 | San Luis Obispo | 79 | 20 | 1 | 0 | 0 | 17 |
213 | 213 | 2022-12-26 | Siskiyou | 93 | 1 | 0 | 0 | 0 | 3 |
217 | 217 | 2022-12-26 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
218 | 218 | 2022-12-26 | Tehama | 103 | 2 | 0 | 0 | 0 | 1 |
219 | 219 | 2022-12-26 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
224 | 224 | 2022-12-26 | Yuba | 115 | 14 | 2 | 0 | 0 | 10 |
226 | 226 | 2022-12-25 | Amador | 5 | 5 | 0 | 0 | 0 | 1 |
228 | 228 | 2022-12-25 | Calaveras | 9 | 1 | 0 | 0 | 0 | 4 |
229 | 229 | 2022-12-25 | Colusa | 11 | 0 | 0 | 0 | 0 | 0 |
231 | 231 | 2022-12-25 | Del Norte | 15 | 3 | 0 | 0 | 0 | 2 |
232 | 232 | 2022-12-25 | El Dorado | 17 | 6 | 0 | 0 | 0 | 3 |
234 | 234 | 2022-12-25 | Glenn | 21 | 0 | 0 | 0 | 0 | 0 |
236 | 236 | 2022-12-25 | Imperial | 25 | 5 | 0 | 0 | 0 | 18 |
237 | 237 | 2022-12-25 | Inyo | 27 | 0 | 0 | 0 | 0 | 4 |
239 | 239 | 2022-12-25 | Kings | 31 | 5 | 0 | 0 | 0 | 2 |
241 | 241 | 2022-12-25 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
245 | 245 | 2022-12-25 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
248 | 248 | 2022-12-25 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
249 | 249 | 2022-12-25 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
251 | 251 | 2022-12-25 | Napa | 55 | 9 | 0 | 0 | 0 | 8 |
252 | 252 | 2022-12-25 | Nevada | 57 | 7 | 0 | 0 | 0 | 3 |
255 | 255 | 2022-12-25 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
263 | 263 | 2022-12-25 | San Luis Obispo | 79 | 17 | 2 | 0 | 0 | 19 |
269 | 269 | 2022-12-25 | Siskiyou | 93 | 1 | 0 | 0 | 0 | 4 |
273 | 273 | 2022-12-25 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
275 | 275 | 2022-12-25 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
280 | 280 | 2022-12-25 | Yuba | 115 | 15 | 2 | 0 | 0 | 11 |
282 | 282 | 2022-12-24 | Amador | 5 | 5 | 0 | 0 | 0 | 1 |
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 );