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 rows where "date" is on date 2020-04-17 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: positive_patients, suspected_patients, icu_positive_patients
Link | rowid | date ▲ | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
55217 | 55217 | 2020-04-17 | Alameda | 1 | 85 | 91 | 35 | 18 | 55 |
55218 | 55218 | 2020-04-17 | Amador | 5 | 0 | 0 | 0 | 0 | 3 |
55219 | 55219 | 2020-04-17 | Butte | 7 | 1 | 9 | 0 | 6 | 7 |
55220 | 55220 | 2020-04-17 | Calaveras | 9 | 0 | 2 | 0 | 2 | 9 |
55221 | 55221 | 2020-04-17 | Colusa | 11 | 0 | 1 | 0 | 1 | 5 |
55222 | 55222 | 2020-04-17 | Contra Costa | 13 | 34 | 46 | 13 | 11 | 59 |
55223 | 55223 | 2020-04-17 | Del Norte | 15 | 0 | 4 | 0 | 1 | 3 |
55224 | 55224 | 2020-04-17 | El Dorado | 17 | 0 | 6 | 0 | 1 | 12 |
55225 | 55225 | 2020-04-17 | Fresno | 19 | 31 | 29 | 12 | 2 | 52 |
55226 | 55226 | 2020-04-17 | Glenn | 21 | 0 | 0 | 0 | 0 | |
55227 | 55227 | 2020-04-17 | Humboldt | 23 | 0 | 4 | 2 | 1 | 1 |
55228 | 55228 | 2020-04-17 | Imperial | 25 | 19 | 15 | 10 | 2 | 3 |
55229 | 55229 | 2020-04-17 | Inyo | 27 | 0 | 3 | 0 | 1 | 5 |
55230 | 55230 | 2020-04-17 | Kern | 29 | 36 | 16 | 18 | 1 | 59 |
55231 | 55231 | 2020-04-17 | Kings | 31 | 7 | 0 | 2 | 0 | 0 |
55232 | 55232 | 2020-04-17 | Lake | 33 | 0 | 6 | 0 | 1 | 3 |
55233 | 55233 | 2020-04-17 | Lassen | 35 | 0 | 5 | 0 | 0 | |
55234 | 55234 | 2020-04-17 | Los Angeles | 37 | 1720 | 634 | 594 | 105 | 593 |
55235 | 55235 | 2020-04-17 | Madera | 39 | 0 | 5 | 0 | 0 | 7 |
55236 | 55236 | 2020-04-17 | Marin | 41 | 4 | 2 | 2 | 0 | 15 |
55237 | 55237 | 2020-04-17 | Mariposa | 43 | 0 | 1 | 0 | 0 | |
55238 | 55238 | 2020-04-17 | Mendocino | 45 | 0 | 0 | 0 | 0 | 7 |
55239 | 55239 | 2020-04-17 | Merced | 47 | 0 | 4 | 0 | 2 | 3 |
55240 | 55240 | 2020-04-17 | Modoc | 49 | 0 | 1 | 0 | 0 | |
55241 | 55241 | 2020-04-17 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
55242 | 55242 | 2020-04-17 | Monterey | 53 | 22 | 25 | 3 | 1 | 22 |
55243 | 55243 | 2020-04-17 | Napa | 55 | 0 | 1 | 0 | 0 | 13 |
55244 | 55244 | 2020-04-17 | Nevada | 57 | 2 | 4 | 1 | 3 | 0 |
55245 | 55245 | 2020-04-17 | Orange | 59 | 160 | 124 | 58 | 15 | 274 |
55246 | 55246 | 2020-04-17 | Placer | 61 | 12 | 17 | 1 | 2 | 16 |
55247 | 55247 | 2020-04-17 | Plumas | 63 | 0 | 1 | 0 | 0 | |
55248 | 55248 | 2020-04-17 | Riverside | 65 | 215 | 144 | 69 | 23 | 119 |
55249 | 55249 | 2020-04-17 | Sacramento | 67 | 63 | 46 | 24 | 18 | 38 |
55250 | 55250 | 2020-04-17 | San Benito | 69 | 1 | 0 | 0 | 0 | 2 |
55251 | 55251 | 2020-04-17 | San Bernardino | 71 | 165 | 123 | 62 | 29 | 82 |
55252 | 55252 | 2020-04-17 | San Diego | 73 | 232 | 111 | 92 | 21 | 157 |
55253 | 55253 | 2020-04-17 | San Francisco | 75 | 79 | 36 | 28 | 8 | 66 |
55254 | 55254 | 2020-04-17 | San Joaquin | 77 | 23 | 23 | 10 | 3 | 26 |
55255 | 55255 | 2020-04-17 | San Luis Obispo | 79 | 3 | 11 | 3 | 2 | 32 |
55256 | 55256 | 2020-04-17 | San Mateo | 81 | 51 | 16 | 16 | 1 | 22 |
55257 | 55257 | 2020-04-17 | Santa Barbara | 83 | 36 | 6 | 16 | 0 | 63 |
55258 | 55258 | 2020-04-17 | Santa Clara | 85 | 140 | 60 | 71 | 11 | 86 |
55259 | 55259 | 2020-04-17 | Santa Cruz | 87 | 2 | 3 | 1 | 2 | 6 |
55260 | 55260 | 2020-04-17 | Shasta | 89 | 1 | 0 | 1 | 0 | 13 |
55261 | 55261 | 2020-04-17 | Siskiyou | 93 | 0 | 3 | 0 | 0 | 4 |
55262 | 55262 | 2020-04-17 | Solano | 95 | 10 | 11 | 5 | 1 | 36 |
55263 | 55263 | 2020-04-17 | Sonoma | 97 | 2 | 6 | 1 | 3 | 33 |
55264 | 55264 | 2020-04-17 | Stanislaus | 99 | 15 | 17 | 7 | 2 | 22 |
55265 | 55265 | 2020-04-17 | Sutter | 101 | 0 | 0 | |||
55266 | 55266 | 2020-04-17 | Tehama | 103 | 0 | 0 | 0 | 0 | 5 |
55267 | 55267 | 2020-04-17 | Trinity | 105 | 0 | 0 | 0 | 0 | |
55268 | 55268 | 2020-04-17 | Tulare | 107 | 23 | 5 | 7 | 1 | 6 |
55269 | 55269 | 2020-04-17 | Tuolumne | 109 | 0 | 0 | 0 | 0 | 2 |
55270 | 55270 | 2020-04-17 | Ventura | 111 | 23 | 33 | 8 | 11 | 37 |
55271 | 55271 | 2020-04-17 | Yolo | 113 | 4 | 0 | 1 | 0 | 14 |
55272 | 55272 | 2020-04-17 | Yuba | 115 | 0 | 5 | 0 | 4 | 4 |
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 );