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 |
---|---|---|---|---|---|---|---|---|---|
51173 | 51173 | 2020-06-29 | Siskiyou | 93 | 0 | 0 | 0 | 0 | 4 |
51174 | 51174 | 2020-06-29 | Solano | 95 | 39 | 5 | 8 | 0 | 42 |
51175 | 51175 | 2020-06-29 | Sonoma | 97 | 11 | 1 | 7 | 1 | 50 |
51176 | 51176 | 2020-06-29 | Stanislaus | 99 | 113 | 29 | 35 | 3 | 74 |
51177 | 51177 | 2020-06-29 | Sutter | 101 | 0 | 0 | 0 | 0 | |
51178 | 51178 | 2020-06-29 | Tehama | 103 | 0 | 0 | 0 | 0 | 1 |
51179 | 51179 | 2020-06-29 | Trinity | 105 | 0 | 5 | 0 | 0 | |
51180 | 51180 | 2020-06-29 | Tulare | 107 | 74 | 6 | 13 | 0 | 12 |
51181 | 51181 | 2020-06-29 | Tuolumne | 109 | 1 | 0 | 0 | 0 | 0 |
51182 | 51182 | 2020-06-29 | Ventura | 111 | 74 | 37 | 26 | 4 | 45 |
51183 | 51183 | 2020-06-29 | Yolo | 113 | 3 | 1 | 1 | 0 | 1 |
51184 | 51184 | 2020-06-29 | Yuba | 115 | 8 | 0 | 3 | 0 | 11 |
51185 | 51185 | 2020-06-28 | Alameda | 1 | 102 | 39 | 35 | 10 | 124 |
51186 | 51186 | 2020-06-28 | Amador | 5 | 0 | 0 | 0 | 0 | 0 |
51187 | 51187 | 2020-06-28 | Butte | 7 | 5 | 0 | 2 | 0 | 4 |
51188 | 51188 | 2020-06-28 | Calaveras | 9 | 1 | 1 | 1 | 0 | 10 |
51189 | 51189 | 2020-06-28 | Colusa | 11 | 0 | 0 | 0 | 0 | 6 |
51190 | 51190 | 2020-06-28 | Contra Costa | 13 | 32 | 18 | 13 | 5 | 130 |
51191 | 51191 | 2020-06-28 | Del Norte | 15 | 1 | 1 | 1 | 1 | 0 |
51192 | 51192 | 2020-06-28 | El Dorado | 17 | 1 | 3 | 1 | 3 | 6 |
51193 | 51193 | 2020-06-28 | Fresno | 19 | 118 | 48 | 30 | 1 | 68 |
51194 | 51194 | 2020-06-28 | Glenn | 21 | 0 | 1 | 0 | 0 | |
51195 | 51195 | 2020-06-28 | Humboldt | 23 | 1 | 3 | 0 | 1 | 1 |
51196 | 51196 | 2020-06-28 | Imperial | 25 | 72 | 2 | 17 | 0 | 1 |
51197 | 51197 | 2020-06-28 | Inyo | 27 | 0 | 0 | 0 | 0 | 3 |
51198 | 51198 | 2020-06-28 | Kern | 29 | 146 | 9 | 53 | 1 | 75 |
51199 | 51199 | 2020-06-28 | Kings | 31 | 53 | 1 | 6 | 0 | 1 |
51200 | 51200 | 2020-06-28 | Lake | 33 | 2 | 0 | 2 | 0 | 1 |
51201 | 51201 | 2020-06-28 | Lassen | 35 | 0 | 0 | 0 | 0 | |
51202 | 51202 | 2020-06-28 | Los Angeles | 37 | 1783 | 682 | 469 | 97 | 1320 |
51203 | 51203 | 2020-06-28 | Madera | 39 | 9 | 7 | 0 | 1 | 15 |
51204 | 51204 | 2020-06-28 | Marin | 41 | 15 | 4 | 5 | 0 | 16 |
51205 | 51205 | 2020-06-28 | Mariposa | 43 | 0 | 0 | 0 | 0 | |
51206 | 51206 | 2020-06-28 | Mendocino | 45 | 0 | 0 | 0 | 0 | 5 |
51207 | 51207 | 2020-06-28 | Merced | 47 | 19 | 0 | 6 | 0 | 2 |
51208 | 51208 | 2020-06-28 | Modoc | 49 | 0 | 0 | 0 | 0 | |
51209 | 51209 | 2020-06-28 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
51210 | 51210 | 2020-06-28 | Monterey | 53 | 26 | 0 | 10 | 0 | 79 |
51211 | 51211 | 2020-06-28 | Napa | 55 | 7 | 3 | 5 | 2 | 6 |
51212 | 51212 | 2020-06-28 | Nevada | 57 | 1 | 3 | 1 | 2 | 2 |
51213 | 51213 | 2020-06-28 | Orange | 59 | 485 | 110 | 175 | 18 | 417 |
51214 | 51214 | 2020-06-28 | Placer | 61 | 13 | 5 | 4 | 0 | 33 |
51215 | 51215 | 2020-06-28 | Plumas | 63 | 0 | 0 | 0 | 0 | |
51216 | 51216 | 2020-06-28 | Riverside | 65 | 367 | 115 | 106 | 18 | 96 |
51217 | 51217 | 2020-06-28 | Sacramento | 67 | 87 | 19 | 21 | 9 | 70 |
51218 | 51218 | 2020-06-28 | San Benito | 69 | 0 | 0 | 0 | 0 | 3 |
51219 | 51219 | 2020-06-28 | San Bernardino | 71 | 376 | 83 | 135 | 12 | 124 |
51220 | 51220 | 2020-06-28 | San Diego | 73 | 373 | 85 | 160 | 18 | 314 |
51221 | 51221 | 2020-06-28 | San Francisco | 75 | 59 | 10 | 22 | 3 | 103 |
51222 | 51222 | 2020-06-28 | San Joaquin | 77 | 129 | 31 | 34 | 6 | 52 |
51223 | 51223 | 2020-06-28 | San Luis Obispo | 79 | 8 | 2 | 2 | 0 | 38 |
51224 | 51224 | 2020-06-28 | San Mateo | 81 | 27 | 5 | 11 | 0 | 54 |
51225 | 51225 | 2020-06-28 | Santa Barbara | 83 | 66 | 3 | 21 | 0 | 73 |
51226 | 51226 | 2020-06-28 | Santa Clara | 85 | 83 | 22 | 32 | 1 | 187 |
51227 | 51227 | 2020-06-28 | Santa Cruz | 87 | 9 | 10 | 0 | 0 | 7 |
51228 | 51228 | 2020-06-28 | Shasta | 89 | 8 | 2 | 1 | 0 | 7 |
51229 | 51229 | 2020-06-28 | Siskiyou | 93 | 0 | 0 | 0 | 0 | 4 |
51230 | 51230 | 2020-06-28 | Solano | 95 | 30 | 5 | 7 | 0 | 39 |
51231 | 51231 | 2020-06-28 | Sonoma | 97 | 11 | 1 | 6 | 1 | 48 |
51232 | 51232 | 2020-06-28 | Stanislaus | 99 | 108 | 28 | 36 | 2 | 83 |
51233 | 51233 | 2020-06-28 | Sutter | 101 | 0 | 0 | 0 | 0 | |
51234 | 51234 | 2020-06-28 | Tehama | 103 | 0 | 0 | 0 | 0 | 2 |
51235 | 51235 | 2020-06-28 | Trinity | 105 | 0 | 4 | 0 | 0 | |
51236 | 51236 | 2020-06-28 | Tulare | 107 | 66 | 5 | 12 | 0 | 5 |
51237 | 51237 | 2020-06-28 | Tuolumne | 109 | 1 | 0 | 0 | 0 | 1 |
51238 | 51238 | 2020-06-28 | Ventura | 111 | 66 | 32 | 21 | 8 | 62 |
51239 | 51239 | 2020-06-28 | Yolo | 113 | 3 | 1 | 1 | 1 | 1 |
51240 | 51240 | 2020-06-28 | Yuba | 115 | 7 | 0 | 1 | 0 | 17 |
51241 | 51241 | 2020-06-27 | Alameda | 1 | 99 | 40 | 36 | 11 | 115 |
51242 | 51242 | 2020-06-27 | Amador | 5 | 0 | 0 | 0 | 0 | 0 |
51243 | 51243 | 2020-06-27 | Butte | 7 | 5 | 0 | 2 | 0 | 5 |
51244 | 51244 | 2020-06-27 | Calaveras | 9 | 1 | 0 | 1 | 0 | 9 |
51245 | 51245 | 2020-06-27 | Colusa | 11 | 1 | 1 | 0 | 0 | 6 |
51246 | 51246 | 2020-06-27 | Contra Costa | 13 | 38 | 25 | 10 | 3 | 130 |
51247 | 51247 | 2020-06-27 | Del Norte | 15 | 1 | 0 | 0 | 0 | 0 |
51248 | 51248 | 2020-06-27 | El Dorado | 17 | 1 | 1 | 1 | 1 | 9 |
51249 | 51249 | 2020-06-27 | Fresno | 19 | 111 | 53 | 27 | 2 | 73 |
51250 | 51250 | 2020-06-27 | Glenn | 21 | 0 | 1 | 0 | 0 | |
51251 | 51251 | 2020-06-27 | Humboldt | 23 | 1 | 3 | 0 | 1 | 1 |
51252 | 51252 | 2020-06-27 | Imperial | 25 | 77 | 2 | 17 | 0 | 8 |
51253 | 51253 | 2020-06-27 | Inyo | 27 | 0 | 0 | 0 | 0 | 3 |
51254 | 51254 | 2020-06-27 | Kern | 29 | 142 | 34 | 42 | 10 | 70 |
51255 | 51255 | 2020-06-27 | Kings | 31 | 54 | 1 | 6 | 0 | 5 |
51256 | 51256 | 2020-06-27 | Lake | 33 | 0 | 3 | 0 | 2 | 0 |
51257 | 51257 | 2020-06-27 | Lassen | 35 | 0 | 0 | 0 | 0 | |
51258 | 51258 | 2020-06-27 | Los Angeles | 37 | 1710 | 606 | 443 | 80 | 1244 |
51259 | 51259 | 2020-06-27 | Madera | 39 | 12 | 10 | 0 | 0 | 15 |
51260 | 51260 | 2020-06-27 | Marin | 41 | 12 | 2 | 5 | 0 | 16 |
51261 | 51261 | 2020-06-27 | Mariposa | 43 | 0 | 0 | 0 | 0 | |
51262 | 51262 | 2020-06-27 | Mendocino | 45 | 0 | 0 | 0 | 0 | 5 |
51263 | 51263 | 2020-06-27 | Merced | 47 | 15 | 0 | 6 | 0 | 3 |
51264 | 51264 | 2020-06-27 | Modoc | 49 | 0 | 0 | 0 | 0 | |
51265 | 51265 | 2020-06-27 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
51266 | 51266 | 2020-06-27 | Monterey | 53 | 19 | 2 | 11 | 0 | 84 |
51267 | 51267 | 2020-06-27 | Napa | 55 | 7 | 1 | 5 | 0 | 1 |
51268 | 51268 | 2020-06-27 | Nevada | 57 | 1 | 3 | 1 | 1 | 7 |
51269 | 51269 | 2020-06-27 | Orange | 59 | 492 | 103 | 170 | 22 | 401 |
51270 | 51270 | 2020-06-27 | Placer | 61 | 11 | 3 | 3 | 0 | 36 |
51271 | 51271 | 2020-06-27 | Plumas | 63 | 0 | 0 | 0 | 0 | |
51272 | 51272 | 2020-06-27 | Riverside | 65 | 340 | 145 | 108 | 23 | 88 |
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 );