latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
61 rows where "date" is on date 2021-08-30 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update, date (date)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
184 | 184 | Alameda | Alameda | 1 | 2021-08-30 | 103165 | 1259 | |
185 | 185 | Berkeley | Alameda | 1 | 2021-08-30 | 4517 | 53 | |
186 | 186 | Alpine | Alpine | 3 | 2021-08-30 | 89 | 0 | TRUE |
187 | 187 | Amador | Amador | 5 | 2021-08-30 | 4465 | 53 | |
188 | 188 | Butte | Butte | 7 | 2021-08-30 | 15851 | 208 | |
189 | 189 | Calaveras | Calaveras | 9 | 2021-08-30 | 2835 | 61 | |
190 | 190 | Colusa | Colusa | 11 | 2021-08-30 | 2754 | 18 | |
191 | 191 | Contra Costa | Contra Costa | 13 | 2021-08-30 | 88050 | 869 | |
192 | 192 | Del Norte | Del Norte | 15 | 2021-08-30 | 2890 | 23 | |
193 | 193 | El Dorado | El Dorado | 17 | 2021-08-30 | 13282 | 122 | |
194 | 194 | Fresno | Fresno | 19 | 2021-08-30 | 115502 | 1792 | |
195 | 195 | Glenn | Glenn | 21 | 2021-08-30 | 2602 | 30 | |
196 | 196 | Humboldt | Humboldt | 23 | 2021-08-30 | 6992 | 75 | |
197 | 197 | Imperial | Imperial | 25 | 2021-08-30 | 29719 | 751 | TRUE |
198 | 198 | Inyo | Inyo | 27 | 2021-08-30 | 1569 | 39 | |
199 | 199 | Kern | Kern | 29 | 2021-08-30 | 124432 | 1462 | |
200 | 200 | Kings | Kings | 31 | 2021-08-30 | 26314 | 264 | |
201 | 201 | Lake | Lake | 33 | 2021-08-30 | 5293 | 74 | |
202 | 202 | Lassen | Lassen | 35 | 2021-08-30 | 6265 | 27 | |
203 | 203 | Long Beach | Los Angeles | 37 | 2021-08-30 | 60773 | 977 | |
204 | 204 | Los Angeles | Los Angeles | 37 | 2021-08-30 | 1329699 | 23916 | TRUE |
205 | 205 | Pasadena | Los Angeles | 37 | 2021-08-30 | 12723 | 354 | |
206 | 206 | Madera | Madera | 39 | 2021-08-30 | 18129 | 250 | TRUE |
207 | 207 | Marin | Marin | 41 | 2021-08-30 | 16290 | 215 | |
208 | 208 | Mariposa | Mariposa | 43 | 2021-08-30 | 803 | 10 | |
209 | 209 | Mendocino | Mendocino | 45 | 2021-08-30 | 5927 | 61 | TRUE |
210 | 210 | Merced | Merced | 47 | 2021-08-30 | 36740 | 508 | |
211 | 211 | Modoc | Modoc | 49 | 2021-08-30 | 606 | 7 | TRUE |
212 | 212 | Mono | Mono | 51 | 2021-08-30 | 1445 | 5 | |
213 | 213 | Monterey | Monterey | 53 | 2021-08-30 | 46424 | 542 | |
214 | 214 | Napa | Napa | 55 | 2021-08-30 | 11604 | 86 | |
215 | 215 | Nevada | Nevada | 57 | 2021-08-30 | 7156 | 85 | |
216 | 216 | Orange | Orange | 59 | 2021-08-30 | 285098 | 5220 | |
217 | 217 | Placer | Placer | 61 | 2021-08-30 | 28948 | 316 | TRUE |
218 | 218 | Plumas | Plumas | 63 | 2021-08-30 | 1017 | 6 | |
219 | 219 | Riverside | Riverside | 65 | 2021-08-30 | 334846 | 4727 | |
220 | 220 | Sacramento | Sacramento | 67 | 2021-08-30 | 133480 | 1907 | |
221 | 221 | San Benito | San Benito | 69 | 2021-08-30 | 6696 | 65 | |
222 | 222 | San Bernardino | San Bernardino | 71 | 2021-08-30 | 328780 | 4914 | |
223 | 223 | San Diego | San Diego | 73 | 2021-08-30 | 333011 | 3885 | |
224 | 224 | San Francisco | San Francisco | 75 | 2021-08-30 | 46500 | 584 | |
225 | 225 | San Joaquin | San Joaquin | 77 | 2021-08-30 | 85922 | 1528 | |
226 | 226 | San Luis Obispo | San Luis Obispo | 79 | 2021-08-30 | 25137 | 279 | TRUE |
227 | 227 | San Mateo | San Mateo | 81 | 2021-08-30 | 48545 | 595 | |
228 | 228 | Santa Barbara | Santa Barbara | 83 | 2021-08-30 | 39118 | 476 | |
229 | 229 | Santa Clara | Santa Clara | 85 | 2021-08-30 | 133780 | 1731 | |
230 | 230 | Santa Cruz | Santa Cruz | 87 | 2021-08-30 | 18340 | 210 | |
231 | 231 | Shasta | Shasta | 89 | 2021-08-30 | 15353 | 254 | |
232 | 232 | Sierra | Sierra | 91 | 2021-08-30 | 188 | 0 | TRUE |
233 | 233 | Siskiyou | Siskiyou | 93 | 2021-08-30 | 3203 | 40 | TRUE |
234 | 234 | Solano | Solano | 95 | 2021-08-30 | 40477 | 270 | |
235 | 235 | Sonoma | Sonoma | 97 | 2021-08-30 | 36498 | 353 | TRUE |
236 | 236 | Stanislaus | Stanislaus | 99 | 2021-08-30 | 66642 | 1139 | |
237 | 237 | Sutter | Sutter | 101 | 2021-08-30 | 11961 | 121 | |
238 | 238 | Tehama | Tehama | 103 | 2021-08-30 | 6864 | 71 | TRUE |
239 | 239 | Trinity | Trinity | 105 | 2021-08-30 | 641 | 8 | |
240 | 240 | Tulare | Tulare | 107 | 2021-08-30 | 54523 | 869 | |
241 | 241 | Tuolumne | Tuolumne | 109 | 2021-08-30 | 5660 | 88 | |
242 | 242 | Ventura | Ventura | 111 | 2021-08-30 | 90335 | 1074 | |
243 | 243 | Yolo | Yolo | 113 | 2021-08-30 | 16925 | 229 | |
244 | 244 | Yuba | Yuba | 115 | 2021-08-30 | 8551 | 50 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_agency_totals] ( [agency] TEXT, [county] TEXT, [fips] INTEGER, [date] TEXT, [confirmed_cases] INTEGER, [deaths] INTEGER, [did_not_update] TEXT );