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 date descending
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 |
---|---|---|---|---|---|---|---|---|---|
5253 | 5253 | 2022-09-27 | Siskiyou | 93 | 2 | 0 | 1 | 0 | 4 |
5254 | 5254 | 2022-09-27 | Solano | 95 | 29 | 20 | 1 | 1 | 11 |
5255 | 5255 | 2022-09-27 | Sonoma | 97 | 23 | 9 | 2 | 1 | 18 |
5256 | 5256 | 2022-09-27 | Stanislaus | 99 | 43 | 10 | 3 | 0 | 36 |
5257 | 5257 | 2022-09-27 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
5258 | 5258 | 2022-09-27 | Tehama | 103 | 1 | 0 | 0 | 0 | 5 |
5259 | 5259 | 2022-09-27 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
5260 | 5260 | 2022-09-27 | Tulare | 107 | 21 | 1 | 2 | 0 | 30 |
5261 | 5261 | 2022-09-27 | Tuolumne | 109 | 0 | 0 | 0 | 0 | 4 |
5262 | 5262 | 2022-09-27 | Ventura | 111 | 38 | 7 | 2 | 0 | 35 |
5263 | 5263 | 2022-09-27 | Yolo | 113 | 7 | 0 | 0 | 0 | 4 |
5264 | 5264 | 2022-09-27 | Yuba | 115 | 7 | 0 | 1 | 0 | 8 |
5265 | 5265 | 2022-09-26 | Alameda | 1 | 81 | 36 | 4 | 3 | 99 |
5266 | 5266 | 2022-09-26 | Amador | 5 | 2 | 0 | 1 | 0 | 2 |
5267 | 5267 | 2022-09-26 | Butte | 7 | 24 | 0 | 1 | 0 | 21 |
5268 | 5268 | 2022-09-26 | Calaveras | 9 | 2 | 0 | 0 | 0 | 2 |
5269 | 5269 | 2022-09-26 | Colusa | 11 | 1 | 0 | 0 | 0 | 0 |
5270 | 5270 | 2022-09-26 | Contra Costa | 13 | 55 | 36 | 7 | 3 | 57 |
5271 | 5271 | 2022-09-26 | Del Norte | 15 | 2 | 0 | 0 | 0 | 1 |
5272 | 5272 | 2022-09-26 | El Dorado | 17 | 5 | 0 | 0 | 0 | 3 |
5273 | 5273 | 2022-09-26 | Fresno | 19 | 97 | 20 | 13 | 0 | 33 |
5274 | 5274 | 2022-09-26 | Glenn | 21 | 2 | 0 | 0 | 0 | 0 |
5275 | 5275 | 2022-09-26 | Humboldt | 23 | 10 | 0 | 0 | 0 | 8 |
5276 | 5276 | 2022-09-26 | Imperial | 25 | 5 | 0 | 1 | 0 | 1 |
5277 | 5277 | 2022-09-26 | Inyo | 27 | 0 | 0 | 0 | 0 | 4 |
5278 | 5278 | 2022-09-26 | Kern | 29 | 39 | 1 | 7 | 0 | 56 |
5279 | 5279 | 2022-09-26 | Kings | 31 | 2 | 0 | 0 | 0 | 3 |
5280 | 5280 | 2022-09-26 | Lake | 33 | 0 | 0 | 0 | 0 | 1 |
5281 | 5281 | 2022-09-26 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
5282 | 5282 | 2022-09-26 | Los Angeles | 37 | 496 | 38 | 53 | 4 | 672 |
5283 | 5283 | 2022-09-26 | Madera | 39 | 10 | 7 | 2 | 0 | 9 |
5284 | 5284 | 2022-09-26 | Marin | 41 | 10 | 7 | 0 | 0 | 15 |
5285 | 5285 | 2022-09-26 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
5286 | 5286 | 2022-09-26 | Mendocino | 45 | 1 | 0 | 0 | 0 | 3 |
5287 | 5287 | 2022-09-26 | Merced | 47 | 10 | 0 | 0 | 0 | 3 |
5288 | 5288 | 2022-09-26 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
5289 | 5289 | 2022-09-26 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
5290 | 5290 | 2022-09-26 | Monterey | 53 | 16 | 0 | 2 | 0 | 22 |
5291 | 5291 | 2022-09-26 | Napa | 55 | 6 | 0 | 1 | 0 | 8 |
5292 | 5292 | 2022-09-26 | Nevada | 57 | 1 | 0 | 0 | 0 | 6 |
5293 | 5293 | 2022-09-26 | Orange | 59 | 140 | 5 | 23 | 1 | 157 |
5294 | 5294 | 2022-09-26 | Placer | 61 | 46 | 17 | 4 | 4 | 18 |
5295 | 5295 | 2022-09-26 | Plumas | 63 | 1 | 0 | 0 | 0 | 0 |
5296 | 5296 | 2022-09-26 | Riverside | 65 | 70 | 21 | 15 | 1 | 102 |
5297 | 5297 | 2022-09-26 | Sacramento | 67 | 126 | 26 | 20 | 3 | 99 |
5298 | 5298 | 2022-09-26 | San Benito | 69 | 2 | 0 | 2 | 0 | 0 |
5299 | 5299 | 2022-09-26 | San Bernardino | 71 | 87 | 4 | 12 | 0 | 164 |
5300 | 5300 | 2022-09-26 | San Diego | 73 | 216 | 13 | 15 | 0 | 283 |
5301 | 5301 | 2022-09-26 | San Francisco | 75 | 54 | 6 | 9 | 0 | 89 |
5302 | 5302 | 2022-09-26 | San Joaquin | 77 | 38 | 3 | 3 | 1 | 15 |
5303 | 5303 | 2022-09-26 | San Luis Obispo | 79 | 7 | 0 | 0 | 0 | 19 |
5304 | 5304 | 2022-09-26 | San Mateo | 81 | 26 | 10 | 1 | 0 | 19 |
5305 | 5305 | 2022-09-26 | Santa Barbara | 83 | 22 | 0 | 0 | 0 | 33 |
5306 | 5306 | 2022-09-26 | Santa Clara | 85 | 130 | 30 | 17 | 2 | 73 |
5307 | 5307 | 2022-09-26 | Santa Cruz | 87 | 13 | 0 | 0 | 0 | 0 |
5308 | 5308 | 2022-09-26 | Shasta | 89 | 17 | 0 | 3 | 0 | 31 |
5309 | 5309 | 2022-09-26 | Siskiyou | 93 | 1 | 0 | 0 | 0 | 3 |
5310 | 5310 | 2022-09-26 | Solano | 95 | 25 | 21 | 2 | 1 | 9 |
5311 | 5311 | 2022-09-26 | Sonoma | 97 | 33 | 10 | 2 | 1 | 21 |
5312 | 5312 | 2022-09-26 | Stanislaus | 99 | 49 | 8 | 3 | 0 | 40 |
5313 | 5313 | 2022-09-26 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
5314 | 5314 | 2022-09-26 | Tehama | 103 | 1 | 0 | 0 | 0 | 3 |
5315 | 5315 | 2022-09-26 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
5316 | 5316 | 2022-09-26 | Tulare | 107 | 20 | 2 | 2 | 0 | 29 |
5317 | 5317 | 2022-09-26 | Tuolumne | 109 | 1 | 0 | 0 | 0 | 2 |
5318 | 5318 | 2022-09-26 | Ventura | 111 | 34 | 7 | 1 | 0 | 34 |
5319 | 5319 | 2022-09-26 | Yolo | 113 | 5 | 0 | 3 | 0 | 4 |
5320 | 5320 | 2022-09-26 | Yuba | 115 | 7 | 0 | 1 | 0 | 12 |
5321 | 5321 | 2022-09-25 | Alameda | 1 | 81 | 35 | 5 | 4 | 92 |
5322 | 5322 | 2022-09-25 | Amador | 5 | 2 | 0 | 1 | 0 | 1 |
5323 | 5323 | 2022-09-25 | Butte | 7 | 29 | 0 | 1 | 0 | 12 |
5324 | 5324 | 2022-09-25 | Calaveras | 9 | 3 | 0 | 1 | 0 | 1 |
5325 | 5325 | 2022-09-25 | Colusa | 11 | 1 | 0 | 0 | 0 | 0 |
5326 | 5326 | 2022-09-25 | Contra Costa | 13 | 54 | 43 | 9 | 2 | 53 |
5327 | 5327 | 2022-09-25 | Del Norte | 15 | 1 | 0 | 0 | 0 | 3 |
5328 | 5328 | 2022-09-25 | El Dorado | 17 | 6 | 0 | 0 | 0 | 3 |
5329 | 5329 | 2022-09-25 | Fresno | 19 | 101 | 17 | 11 | 0 | 34 |
5330 | 5330 | 2022-09-25 | Glenn | 21 | 1 | 0 | 0 | 0 | 0 |
5331 | 5331 | 2022-09-25 | Humboldt | 23 | 8 | 0 | 0 | 0 | 7 |
5332 | 5332 | 2022-09-25 | Imperial | 25 | 6 | 0 | 0 | 0 | 5 |
5333 | 5333 | 2022-09-25 | Inyo | 27 | 0 | 0 | 0 | 0 | 4 |
5334 | 5334 | 2022-09-25 | Kern | 29 | 41 | 1 | 8 | 0 | 20 |
5335 | 5335 | 2022-09-25 | Kings | 31 | 2 | 0 | 0 | 0 | 3 |
5336 | 5336 | 2022-09-25 | Lake | 33 | 0 | 0 | 0 | 0 | 2 |
5337 | 5337 | 2022-09-25 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
5338 | 5338 | 2022-09-25 | Los Angeles | 37 | 499 | 72 | 60 | 4 | 730 |
5339 | 5339 | 2022-09-25 | Madera | 39 | 11 | 6 | 2 | 0 | 10 |
5340 | 5340 | 2022-09-25 | Marin | 41 | 7 | 9 | 0 | 0 | 13 |
5341 | 5341 | 2022-09-25 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
5342 | 5342 | 2022-09-25 | Mendocino | 45 | 2 | 0 | 0 | 0 | 3 |
5343 | 5343 | 2022-09-25 | Merced | 47 | 8 | 0 | 0 | 0 | 2 |
5344 | 5344 | 2022-09-25 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
5345 | 5345 | 2022-09-25 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
5346 | 5346 | 2022-09-25 | Monterey | 53 | 18 | 0 | 2 | 0 | 21 |
5347 | 5347 | 2022-09-25 | Napa | 55 | 4 | 0 | 1 | 0 | 8 |
5348 | 5348 | 2022-09-25 | Nevada | 57 | 3 | 0 | 0 | 0 | 6 |
5349 | 5349 | 2022-09-25 | Orange | 59 | 137 | 7 | 21 | 2 | 147 |
5350 | 5350 | 2022-09-25 | Placer | 61 | 50 | 17 | 4 | 4 | 11 |
5351 | 5351 | 2022-09-25 | Plumas | 63 | 1 | 0 | 0 | 0 | 0 |
5352 | 5352 | 2022-09-25 | Riverside | 65 | 73 | 12 | 15 | 1 | 90 |
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 );