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-18 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: positive_patients, icu_positive_patients
Link | rowid | date ▲ | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
55161 | 55161 | 2020-04-18 | Alameda | 1 | 82 | 73 | 36 | 16 | 62 |
55162 | 55162 | 2020-04-18 | Amador | 5 | 0 | 0 | 0 | 0 | 3 |
55163 | 55163 | 2020-04-18 | Butte | 7 | 1 | 4 | 0 | 2 | 11 |
55164 | 55164 | 2020-04-18 | Calaveras | 9 | 0 | 0 | 0 | 0 | 11 |
55165 | 55165 | 2020-04-18 | Colusa | 11 | 0 | 0 | 0 | 0 | 6 |
55166 | 55166 | 2020-04-18 | Contra Costa | 13 | 35 | 44 | 13 | 8 | 79 |
55167 | 55167 | 2020-04-18 | Del Norte | 15 | 0 | 2 | 0 | 1 | 6 |
55168 | 55168 | 2020-04-18 | El Dorado | 17 | 0 | 8 | 0 | 2 | 11 |
55169 | 55169 | 2020-04-18 | Fresno | 19 | 32 | 35 | 13 | 2 | 51 |
55170 | 55170 | 2020-04-18 | Glenn | 21 | 0 | 0 | 0 | 0 | |
55171 | 55171 | 2020-04-18 | Humboldt | 23 | 0 | 4 | 0 | 0 | 5 |
55172 | 55172 | 2020-04-18 | Imperial | 25 | 21 | 12 | 9 | 4 | 2 |
55173 | 55173 | 2020-04-18 | Inyo | 27 | 1 | 1 | 1 | 0 | 4 |
55174 | 55174 | 2020-04-18 | Kern | 29 | 33 | 14 | 18 | 2 | 56 |
55175 | 55175 | 2020-04-18 | Kings | 31 | 8 | 0 | 2 | 0 | 1 |
55176 | 55176 | 2020-04-18 | Lake | 33 | 0 | 0 | 0 | 0 | 6 |
55177 | 55177 | 2020-04-18 | Lassen | 35 | 0 | 1 | 0 | 0 | |
55178 | 55178 | 2020-04-18 | Los Angeles | 37 | 1709 | 578 | 586 | 110 | 579 |
55179 | 55179 | 2020-04-18 | Madera | 39 | 0 | 7 | 0 | 0 | 7 |
55180 | 55180 | 2020-04-18 | Marin | 41 | 3 | 1 | 1 | 0 | 13 |
55181 | 55181 | 2020-04-18 | Mariposa | 43 | 0 | 0 | 0 | 0 | |
55182 | 55182 | 2020-04-18 | Mendocino | 45 | 0 | 0 | 0 | 0 | 9 |
55183 | 55183 | 2020-04-18 | Merced | 47 | 0 | 3 | 0 | 0 | 4 |
55184 | 55184 | 2020-04-18 | Modoc | 49 | 0 | 1 | 0 | 0 | |
55185 | 55185 | 2020-04-18 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
55186 | 55186 | 2020-04-18 | Monterey | 53 | 26 | 21 | 2 | 0 | 38 |
55187 | 55187 | 2020-04-18 | Napa | 55 | 0 | 0 | 0 | 0 | 13 |
55188 | 55188 | 2020-04-18 | Nevada | 57 | 4 | 5 | 1 | 4 | 4 |
55189 | 55189 | 2020-04-18 | Orange | 59 | 157 | 120 | 64 | 23 | 263 |
55190 | 55190 | 2020-04-18 | Placer | 61 | 11 | 17 | 1 | 2 | 6 |
55191 | 55191 | 2020-04-18 | Plumas | 63 | 0 | 1 | 0 | 0 | |
55192 | 55192 | 2020-04-18 | Riverside | 65 | 223 | 118 | 71 | 19 | 133 |
55193 | 55193 | 2020-04-18 | Sacramento | 67 | 65 | 46 | 22 | 17 | 58 |
55194 | 55194 | 2020-04-18 | San Benito | 69 | 0 | 0 | 0 | 0 | 2 |
55195 | 55195 | 2020-04-18 | San Bernardino | 71 | 161 | 108 | 61 | 22 | 107 |
55196 | 55196 | 2020-04-18 | San Diego | 73 | 223 | 97 | 90 | 18 | 164 |
55197 | 55197 | 2020-04-18 | San Francisco | 75 | 74 | 29 | 27 | 7 | 75 |
55198 | 55198 | 2020-04-18 | San Joaquin | 77 | 23 | 27 | 11 | 4 | 38 |
55199 | 55199 | 2020-04-18 | San Luis Obispo | 79 | 3 | 12 | 3 | 2 | 23 |
55200 | 55200 | 2020-04-18 | San Mateo | 81 | 49 | 12 | 16 | 0 | 37 |
55201 | 55201 | 2020-04-18 | Santa Barbara | 83 | 31 | 9 | 15 | 4 | 60 |
55202 | 55202 | 2020-04-18 | Santa Clara | 85 | 137 | 52 | 67 | 13 | 84 |
55203 | 55203 | 2020-04-18 | Santa Cruz | 87 | 2 | 2 | 1 | 1 | 12 |
55204 | 55204 | 2020-04-18 | Shasta | 89 | 1 | 1 | 1 | 0 | 13 |
55205 | 55205 | 2020-04-18 | Siskiyou | 93 | 0 | 1 | 0 | 1 | 4 |
55206 | 55206 | 2020-04-18 | Solano | 95 | 9 | 11 | 6 | 1 | 34 |
55207 | 55207 | 2020-04-18 | Sonoma | 97 | 2 | 4 | 1 | 1 | 32 |
55208 | 55208 | 2020-04-18 | Stanislaus | 99 | 14 | 23 | 5 | 1 | 31 |
55209 | 55209 | 2020-04-18 | Sutter | 101 | 0 | 0 | |||
55210 | 55210 | 2020-04-18 | Tehama | 103 | 0 | 0 | 0 | 0 | 4 |
55211 | 55211 | 2020-04-18 | Trinity | 105 | 0 | 0 | 0 | 0 | |
55212 | 55212 | 2020-04-18 | Tulare | 107 | 27 | 0 | 9 | 0 | 11 |
55213 | 55213 | 2020-04-18 | Tuolumne | 109 | 0 | 0 | 0 | 0 | 1 |
55214 | 55214 | 2020-04-18 | Ventura | 111 | 25 | 28 | 9 | 5 | 35 |
55215 | 55215 | 2020-04-18 | Yolo | 113 | 4 | 0 | 1 | 0 | 14 |
55216 | 55216 | 2020-04-18 | Yuba | 115 | 0 | 3 | 0 | 2 | 5 |
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 );