la_times_cdph_hospital_patient_county_totals
Data license: Reusing the data · Data source: California Department of Public Health via The Los Angeles Times · About: Data dictionary for la_times_cdph_hospital_patient_county_totals
56,333 rows sorted by suspected_patients
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | fips | positive_patients | suspected_patients ▼ | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
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 |
179 | 179 | 2022-12-26 | Humboldt | 23 | 7 | 0 | 2 | 0 | 4 |
180 | 180 | 2022-12-26 | Imperial | 25 | 67 | 0 | 0 | 0 | 15 |
181 | 181 | 2022-12-26 | Inyo | 27 | 1 | 0 | 0 | 0 | 3 |
183 | 183 | 2022-12-26 | Kings | 31 | 7 | 0 | 2 | 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 |
191 | 191 | 2022-12-26 | Merced | 47 | 20 | 0 | 3 | 0 | 5 |
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 |
196 | 196 | 2022-12-26 | Nevada | 57 | 10 | 0 | 1 | 0 | 5 |
199 | 199 | 2022-12-26 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
202 | 202 | 2022-12-26 | San Benito | 69 | 2 | 0 | 1 | 0 | 0 |
209 | 209 | 2022-12-26 | Santa Barbara | 83 | 44 | 0 | 4 | 0 | 22 |
211 | 211 | 2022-12-26 | Santa Cruz | 87 | 27 | 0 | 2 | 0 | 0 |
212 | 212 | 2022-12-26 | Shasta | 89 | 19 | 0 | 1 | 0 | 28 |
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 |
221 | 221 | 2022-12-26 | Tuolumne | 109 | 8 | 0 | 2 | 0 | 0 |
223 | 223 | 2022-12-26 | Yolo | 113 | 10 | 0 | 1 | 0 | 5 |
226 | 226 | 2022-12-25 | Amador | 5 | 5 | 0 | 0 | 0 | 1 |
227 | 227 | 2022-12-25 | Butte | 7 | 38 | 0 | 1 | 0 | 16 |
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 |
235 | 235 | 2022-12-25 | Humboldt | 23 | 7 | 0 | 2 | 0 | 7 |
236 | 236 | 2022-12-25 | Imperial | 25 | 5 | 0 | 0 | 0 | 18 |
237 | 237 | 2022-12-25 | Inyo | 27 | 0 | 0 | 0 | 0 | 4 |
238 | 238 | 2022-12-25 | Kern | 29 | 66 | 0 | 11 | 0 | 22 |
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 |
246 | 246 | 2022-12-25 | Mendocino | 45 | 9 | 0 | 1 | 0 | 3 |
247 | 247 | 2022-12-25 | Merced | 47 | 19 | 0 | 2 | 0 | 4 |
248 | 248 | 2022-12-25 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
249 | 249 | 2022-12-25 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
250 | 250 | 2022-12-25 | Monterey | 53 | 19 | 0 | 1 | 0 | 25 |
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 |
258 | 258 | 2022-12-25 | San Benito | 69 | 2 | 0 | 1 | 0 | 0 |
267 | 267 | 2022-12-25 | Santa Cruz | 87 | 27 | 0 | 1 | 0 | 0 |
269 | 269 | 2022-12-25 | Siskiyou | 93 | 1 | 0 | 0 | 0 | 4 |
273 | 273 | 2022-12-25 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
274 | 274 | 2022-12-25 | Tehama | 103 | 3 | 0 | 1 | 0 | 2 |
275 | 275 | 2022-12-25 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
276 | 276 | 2022-12-25 | Tulare | 107 | 41 | 0 | 1 | 0 | 26 |
277 | 277 | 2022-12-25 | Tuolumne | 109 | 7 | 0 | 2 | 0 | 0 |
279 | 279 | 2022-12-25 | Yolo | 113 | 7 | 0 | 1 | 0 | 3 |
282 | 282 | 2022-12-24 | Amador | 5 | 5 | 0 | 0 | 0 | 1 |
283 | 283 | 2022-12-24 | Butte | 7 | 42 | 0 | 1 | 0 | 19 |
284 | 284 | 2022-12-24 | Calaveras | 9 | 1 | 0 | 0 | 0 | 1 |
285 | 285 | 2022-12-24 | Colusa | 11 | 0 | 0 | 0 | 0 | 0 |
287 | 287 | 2022-12-24 | Del Norte | 15 | 3 | 0 | 0 | 0 | 2 |
288 | 288 | 2022-12-24 | El Dorado | 17 | 8 | 0 | 0 | 0 | 4 |
290 | 290 | 2022-12-24 | Glenn | 21 | 0 | 0 | 0 | 0 | 0 |
291 | 291 | 2022-12-24 | Humboldt | 23 | 8 | 0 | 1 | 0 | 3 |
292 | 292 | 2022-12-24 | Imperial | 25 | 7 | 0 | 2 | 0 | 15 |
293 | 293 | 2022-12-24 | Inyo | 27 | 0 | 0 | 0 | 0 | 4 |
294 | 294 | 2022-12-24 | Kern | 29 | 68 | 0 | 12 | 0 | 25 |
295 | 295 | 2022-12-24 | Kings | 31 | 5 | 0 | 0 | 0 | 1 |
297 | 297 | 2022-12-24 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
301 | 301 | 2022-12-24 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
302 | 302 | 2022-12-24 | Mendocino | 45 | 9 | 0 | 2 | 0 | 2 |
303 | 303 | 2022-12-24 | Merced | 47 | 19 | 0 | 2 | 0 | 5 |
304 | 304 | 2022-12-24 | Modoc | 49 | 1 | 0 | 0 | 0 | 0 |
305 | 305 | 2022-12-24 | Mono | 51 | 0 | 0 | 0 | 0 | 1 |
306 | 306 | 2022-12-24 | Monterey | 53 | 20 | 0 | 1 | 0 | 20 |
307 | 307 | 2022-12-24 | Napa | 55 | 8 | 0 | 0 | 0 | 4 |
308 | 308 | 2022-12-24 | Nevada | 57 | 10 | 0 | 0 | 0 | 4 |
311 | 311 | 2022-12-24 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
314 | 314 | 2022-12-24 | San Benito | 69 | 2 | 0 | 1 | 0 | 0 |
321 | 321 | 2022-12-24 | Santa Barbara | 83 | 50 | 0 | 6 | 0 | 17 |
323 | 323 | 2022-12-24 | Santa Cruz | 87 | 24 | 0 | 1 | 0 | 2 |
325 | 325 | 2022-12-24 | Siskiyou | 93 | 2 | 0 | 0 | 0 | 1 |
329 | 329 | 2022-12-24 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
330 | 330 | 2022-12-24 | Tehama | 103 | 3 | 0 | 1 | 0 | 0 |
331 | 331 | 2022-12-24 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
333 | 333 | 2022-12-24 | Tuolumne | 109 | 4 | 0 | 2 | 0 | 0 |
335 | 335 | 2022-12-24 | Yolo | 113 | 4 | 0 | 0 | 0 | 2 |
336 | 336 | 2022-12-24 | Yuba | 115 | 12 | 0 | 0 | 0 | 6 |
338 | 338 | 2022-12-23 | Amador | 5 | 4 | 0 | 0 | 0 | 0 |
339 | 339 | 2022-12-23 | Butte | 7 | 44 | 0 | 3 | 0 | 13 |
340 | 340 | 2022-12-23 | Calaveras | 9 | 1 | 0 | 0 | 0 | 1 |
341 | 341 | 2022-12-23 | Colusa | 11 | 0 | 0 | 0 | 0 | 0 |
343 | 343 | 2022-12-23 | Del Norte | 15 | 3 | 0 | 1 | 0 | 3 |
346 | 346 | 2022-12-23 | Glenn | 21 | 1 | 0 | 0 | 0 | 0 |
347 | 347 | 2022-12-23 | Humboldt | 23 | 13 | 0 | 1 | 0 | 2 |
348 | 348 | 2022-12-23 | Imperial | 25 | 13 | 0 | 2 | 0 | 9 |
349 | 349 | 2022-12-23 | Inyo | 27 | 0 | 0 | 0 | 0 | 3 |
350 | 350 | 2022-12-23 | Kern | 29 | 68 | 0 | 14 | 0 | 21 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [la_times_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 );