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 2020-10-05 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
20253 | 20253 | Alameda | Alameda | 1 | 2020-10-05 | 21030 | 426 | |
20254 | 20254 | Berkeley | Alameda | 1 | 2020-10-05 | 719 | 10 | |
20255 | 20255 | Alpine | Alpine | 3 | 2020-10-05 | 3 | 0 | |
20256 | 20256 | Amador | Amador | 5 | 2020-10-05 | 264 | 15 | |
20257 | 20257 | Butte | Butte | 7 | 2020-10-05 | 2910 | 45 | |
20258 | 20258 | Calaveras | Calaveras | 9 | 2020-10-05 | 324 | 14 | TRUE |
20259 | 20259 | Colusa | Colusa | 11 | 2020-10-05 | 539 | 6 | |
20260 | 20260 | Contra Costa | Contra Costa | 13 | 2020-10-05 | 17322 | 213 | |
20261 | 20261 | Del Norte | Del Norte | 15 | 2020-10-05 | 152 | 1 | |
20262 | 20262 | El Dorado | El Dorado | 17 | 2020-10-05 | 1207 | 4 | |
20263 | 20263 | Fresno | Fresno | 19 | 2020-10-05 | 31218 | 399 | |
20264 | 20264 | Glenn | Glenn | 21 | 2020-10-05 | 609 | 3 | |
20265 | 20265 | Humboldt | Humboldt | 23 | 2020-10-05 | 522 | 8 | |
20266 | 20266 | Imperial | Imperial | 25 | 2020-10-05 | 12076 | 326 | |
20267 | 20267 | Inyo | Inyo | 27 | 2020-10-05 | 197 | 15 | |
20268 | 20268 | Kern | Kern | 29 | 2020-10-05 | 32522 | 386 | |
20269 | 20269 | Kings | Kings | 31 | 2020-10-05 | 7919 | 82 | |
20270 | 20270 | Lake | Lake | 33 | 2020-10-05 | 593 | 12 | |
20271 | 20271 | Lassen | Lassen | 35 | 2020-10-05 | 744 | 0 | |
20272 | 20272 | Long Beach | Los Angeles | 37 | 2020-10-05 | 12129 | 248 | |
20273 | 20273 | Los Angeles | Los Angeles | 37 | 2020-10-05 | 260271 | 6281 | |
20274 | 20274 | Pasadena | Los Angeles | 37 | 2020-10-05 | 2618 | 126 | |
20275 | 20275 | Madera | Madera | 39 | 2020-10-05 | 4706 | 70 | |
20276 | 20276 | Marin | Marin | 41 | 2020-10-05 | 6796 | 119 | |
20277 | 20277 | Mariposa | Mariposa | 43 | 2020-10-05 | 76 | 2 | |
20278 | 20278 | Mendocino | Mendocino | 45 | 2020-10-05 | 1010 | 20 | |
20279 | 20279 | Merced | Merced | 47 | 2020-10-05 | 9081 | 148 | |
20280 | 20280 | Modoc | Modoc | 49 | 2020-10-05 | 27 | 0 | |
20281 | 20281 | Mono | Mono | 51 | 2020-10-05 | 169 | 2 | TRUE |
20282 | 20282 | Monterey | Monterey | 53 | 2020-10-05 | 10402 | 75 | |
20283 | 20283 | Napa | Napa | 55 | 2020-10-05 | 1758 | 12 | |
20284 | 20284 | Nevada | Nevada | 57 | 2020-10-05 | 550 | 7 | |
20285 | 20285 | Orange | Orange | 59 | 2020-10-05 | 54760 | 1287 | |
20286 | 20286 | Placer | Placer | 61 | 2020-10-05 | 3684 | 49 | |
20287 | 20287 | Plumas | Plumas | 63 | 2020-10-05 | 52 | 0 | |
20288 | 20288 | Riverside | Riverside | 65 | 2020-10-05 | 60738 | 1238 | |
20289 | 20289 | Sacramento | Sacramento | 67 | 2020-10-05 | 23245 | 432 | |
20290 | 20290 | San Benito | San Benito | 69 | 2020-10-05 | 1367 | 12 | |
20291 | 20291 | San Bernardino | San Bernardino | 71 | 2020-10-05 | 56400 | 1134 | |
20292 | 20292 | San Diego | San Diego | 73 | 2020-10-05 | 48660 | 803 | |
20293 | 20293 | San Francisco | San Francisco | 75 | 2020-10-05 | 11480 | 108 | |
20294 | 20294 | San Joaquin | San Joaquin | 77 | 2020-10-05 | 20569 | 471 | |
20295 | 20295 | San Luis Obispo | San Luis Obispo | 79 | 2020-10-05 | 3742 | 31 | |
20296 | 20296 | San Mateo | San Mateo | 81 | 2020-10-05 | 10275 | 152 | |
20297 | 20297 | Santa Barbara | Santa Barbara | 83 | 2020-10-05 | 9319 | 115 | |
20298 | 20298 | Santa Clara | Santa Clara | 85 | 2020-10-05 | 22242 | 324 | |
20299 | 20299 | Santa Cruz | Santa Cruz | 87 | 2020-10-05 | 2519 | 12 | |
20300 | 20300 | Shasta | Shasta | 89 | 2020-10-05 | 1158 | 22 | |
20301 | 20301 | Sierra | Sierra | 91 | 2020-10-05 | 6 | 0 | |
20302 | 20302 | Siskiyou | Siskiyou | 93 | 2020-10-05 | 171 | 0 | |
20303 | 20303 | Solano | Solano | 95 | 2020-10-05 | 6601 | 72 | |
20304 | 20304 | Sonoma | Sonoma | 97 | 2020-10-05 | 7940 | 122 | |
20305 | 20305 | Stanislaus | Stanislaus | 99 | 2020-10-05 | 16759 | 374 | |
20306 | 20306 | Sutter | Sutter | 101 | 2020-10-05 | 1763 | 12 | |
20307 | 20307 | Tehama | Tehama | 103 | 2020-10-05 | 618 | 7 | TRUE |
20308 | 20308 | Trinity | Trinity | 105 | 2020-10-05 | 19 | 0 | |
20309 | 20309 | Tulare | Tulare | 107 | 2020-10-05 | 16490 | 265 | |
20310 | 20310 | Tuolumne | Tuolumne | 109 | 2020-10-05 | 233 | 4 | |
20311 | 20311 | Ventura | Ventura | 111 | 2020-10-05 | 13045 | 154 | |
20312 | 20312 | Yolo | Yolo | 113 | 2020-10-05 | 2893 | 56 | |
20313 | 20313 | Yuba | Yuba | 115 | 2020-10-05 | 1207 | 10 |
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 );