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-12-08 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 |
---|---|---|---|---|---|---|---|---|
16349 | 16349 | Alameda | Alameda | 1 | 2020-12-08 | 33527 | 577 | |
16350 | 16350 | Berkeley | Alameda | 1 | 2020-12-08 | 1390 | 14 | |
16351 | 16351 | Alpine | Alpine | 3 | 2020-12-08 | 57 | 0 | TRUE |
16352 | 16352 | Amador | Amador | 5 | 2020-12-08 | 1162 | 18 | |
16353 | 16353 | Butte | Butte | 7 | 2020-12-08 | 4651 | 62 | |
16354 | 16354 | Calaveras | Calaveras | 9 | 2020-12-08 | 588 | 22 | |
16355 | 16355 | Colusa | Colusa | 11 | 2020-12-08 | 885 | 7 | |
16356 | 16356 | Contra Costa | Contra Costa | 13 | 2020-12-08 | 28088 | 267 | |
16357 | 16357 | Del Norte | Del Norte | 15 | 2020-12-08 | 489 | 1 | |
16358 | 16358 | El Dorado | El Dorado | 17 | 2020-12-08 | 3356 | 8 | |
16359 | 16359 | Fresno | Fresno | 19 | 2020-12-08 | 51335 | 514 | |
16360 | 16360 | Glenn | Glenn | 21 | 2020-12-08 | 1101 | 11 | |
16361 | 16361 | Humboldt | Humboldt | 23 | 2020-12-08 | 1137 | 9 | |
16362 | 16362 | Imperial | Imperial | 25 | 2020-12-08 | 17400 | 360 | |
16363 | 16363 | Inyo | Inyo | 27 | 2020-12-08 | 353 | 16 | |
16364 | 16364 | Kern | Kern | 29 | 2020-12-08 | 46397 | 457 | |
16365 | 16365 | Kings | Kings | 31 | 2020-12-08 | 12624 | 95 | |
16366 | 16366 | Lake | Lake | 33 | 2020-12-08 | 1131 | 21 | |
16367 | 16367 | Lassen | Lassen | 35 | 2020-12-08 | 2856 | 5 | |
16368 | 16368 | Long Beach | Los Angeles | 37 | 2020-12-08 | 19186 | 287 | |
16369 | 16369 | Los Angeles | Los Angeles | 37 | 2020-12-08 | 443674 | 7582 | |
16370 | 16370 | Pasadena | Los Angeles | 37 | 2020-12-08 | 4329 | 137 | |
16371 | 16371 | Madera | Madera | 39 | 2020-12-08 | 7115 | 107 | |
16372 | 16372 | Marin | Marin | 41 | 2020-12-08 | 8192 | 132 | |
16373 | 16373 | Mariposa | Mariposa | 43 | 2020-12-08 | 165 | 4 | |
16374 | 16374 | Mendocino | Mendocino | 45 | 2020-12-08 | 1816 | 24 | |
16375 | 16375 | Merced | Merced | 47 | 2020-12-08 | 13851 | 198 | |
16376 | 16376 | Modoc | Modoc | 49 | 2020-12-08 | 200 | 0 | |
16377 | 16377 | Mono | Mono | 51 | 2020-12-08 | 627 | 3 | |
16378 | 16378 | Monterey | Monterey | 53 | 2020-12-08 | 16840 | 136 | |
16379 | 16379 | Napa | Napa | 55 | 2020-12-08 | 3733 | 20 | |
16380 | 16380 | Nevada | Nevada | 57 | 2020-12-08 | 1811 | 19 | |
16381 | 16381 | Orange | Orange | 59 | 2020-12-08 | 90513 | 1633 | |
16382 | 16382 | Placer | Placer | 61 | 2020-12-08 | 8173 | 81 | |
16383 | 16383 | Plumas | Plumas | 63 | 2020-12-08 | 301 | 0 | |
16384 | 16384 | Riverside | Riverside | 65 | 2020-12-08 | 103221 | 1513 | |
16385 | 16385 | Sacramento | Sacramento | 67 | 2020-12-08 | 44688 | 635 | |
16386 | 16386 | San Benito | San Benito | 69 | 2020-12-08 | 2214 | 19 | |
16387 | 16387 | San Bernardino | San Bernardino | 71 | 2020-12-08 | 108946 | 1672 | |
16388 | 16388 | San Diego | San Diego | 73 | 2020-12-08 | 95445 | 1088 | |
16389 | 16389 | San Francisco | San Francisco | 75 | 2020-12-08 | 17197 | 164 | |
16390 | 16390 | San Joaquin | San Joaquin | 77 | 2020-12-08 | 28532 | 530 | |
16391 | 16391 | San Luis Obispo | San Luis Obispo | 79 | 2020-12-08 | 6965 | 42 | |
16392 | 16392 | San Mateo | San Mateo | 81 | 2020-12-08 | 16371 | 177 | |
16393 | 16393 | Santa Barbara | Santa Barbara | 83 | 2020-12-08 | 12502 | 139 | |
16394 | 16394 | Santa Clara | Santa Clara | 85 | 2020-12-08 | 46718 | 494 | |
16395 | 16395 | Santa Cruz | Santa Cruz | 87 | 2020-12-08 | 5176 | 47 | |
16396 | 16396 | Shasta | Shasta | 89 | 2020-12-08 | 6055 | 54 | |
16397 | 16397 | Sierra | Sierra | 91 | 2020-12-08 | 25 | 0 | |
16398 | 16398 | Siskiyou | Siskiyou | 93 | 2020-12-08 | 851 | 7 | |
16399 | 16399 | Solano | Solano | 95 | 2020-12-08 | 11950 | 90 | |
16400 | 16400 | Sonoma | Sonoma | 97 | 2020-12-08 | 13719 | 160 | |
16401 | 16401 | Stanislaus | Stanislaus | 99 | 2020-12-08 | 24807 | 450 | |
16402 | 16402 | Sutter | Sutter | 101 | 2020-12-08 | 4435 | 26 | |
16403 | 16403 | Tehama | Tehama | 103 | 2020-12-08 | 2112 | 29 | |
16404 | 16404 | Trinity | Trinity | 105 | 2020-12-08 | 217 | 1 | |
16405 | 16405 | Tulare | Tulare | 107 | 2020-12-08 | 23662 | 319 | |
16406 | 16406 | Tuolumne | Tuolumne | 109 | 2020-12-08 | 1321 | 14 | |
16407 | 16407 | Ventura | Ventura | 111 | 2020-12-08 | 23473 | 195 | |
16408 | 16408 | Yolo | Yolo | 113 | 2020-12-08 | 5549 | 84 | |
16409 | 16409 | Yuba | Yuba | 115 | 2020-12-08 | 2650 | 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 );