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-07-12 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
25438 | 25438 | Alameda | Alameda | 1 | 2020-07-12 | 7933 | 199 | TRUE |
25439 | 25439 | Berkeley | Alameda | 1 | 2020-07-12 | 276 | 5 | |
25440 | 25440 | Alpine | Alpine | 3 | 2020-07-12 | 1 | 0 | TRUE |
25441 | 25441 | Amador | Amador | 5 | 2020-07-12 | 40 | 0 | TRUE |
25442 | 25442 | Butte | Butte | 7 | 2020-07-12 | 341 | 4 | TRUE |
25443 | 25443 | Calaveras | Calaveras | 9 | 2020-07-12 | 67 | 0 | TRUE |
25444 | 25444 | Colusa | Colusa | 11 | 2020-07-12 | 113 | 0 | TRUE |
25445 | 25445 | Contra Costa | Contra Costa | 13 | 2020-07-12 | 4714 | 90 | |
25446 | 25446 | Del Norte | Del Norte | 15 | 2020-07-12 | 60 | 0 | TRUE |
25447 | 25447 | El Dorado | El Dorado | 17 | 2020-07-12 | 307 | 0 | TRUE |
25448 | 25448 | Fresno | Fresno | 19 | 2020-07-12 | 14662 | 88 | TRUE |
25449 | 25449 | Glenn | Glenn | 21 | 2020-07-12 | 164 | 0 | TRUE |
25450 | 25450 | Humboldt | Humboldt | 23 | 2020-07-12 | 165 | 4 | TRUE |
25451 | 25451 | Imperial | Imperial | 25 | 2020-07-12 | 7827 | 135 | TRUE |
25452 | 25452 | Inyo | Inyo | 27 | 2020-07-12 | 35 | 1 | TRUE |
25453 | 25453 | Kern | Kern | 29 | 2020-07-12 | 6502 | 97 | |
25454 | 25454 | Kings | Kings | 31 | 2020-07-12 | 2970 | 39 | |
25455 | 25455 | Lake | Lake | 33 | 2020-07-12 | 108 | 1 | TRUE |
25456 | 25456 | Lassen | Lassen | 35 | 2020-07-12 | 337 | 0 | |
25457 | 25457 | Long Beach | Los Angeles | 37 | 2020-07-12 | 5388 | 147 | |
25458 | 25458 | Los Angeles | Los Angeles | 37 | 2020-07-12 | 126691 | 3562 | |
25459 | 25459 | Pasadena | Los Angeles | 37 | 2020-07-12 | 1517 | 100 | |
25460 | 25460 | Madera | Madera | 39 | 2020-07-12 | 893 | 8 | TRUE |
25461 | 25461 | Marin | Marin | 41 | 2020-07-12 | 3702 | 32 | |
25462 | 25462 | Mariposa | Mariposa | 43 | 2020-07-12 | 32 | 1 | |
25463 | 25463 | Mendocino | Mendocino | 45 | 2020-07-12 | 132 | 0 | |
25464 | 25464 | Merced | Merced | 47 | 2020-07-12 | 1884 | 12 | TRUE |
25465 | 25465 | Modoc | Modoc | 49 | 2020-07-12 | 0 | 0 | TRUE |
25466 | 25466 | Mono | Mono | 51 | 2020-07-12 | 51 | 1 | |
25467 | 25467 | Monterey | Monterey | 53 | 2020-07-12 | 2682 | 18 | |
25468 | 25468 | Napa | Napa | 55 | 2020-07-12 | 477 | 4 | TRUE |
25469 | 25469 | Nevada | Nevada | 57 | 2020-07-12 | 163 | 1 | TRUE |
25470 | 25470 | Orange | Orange | 59 | 2020-07-12 | 24715 | 423 | |
25471 | 25471 | Placer | Placer | 61 | 2020-07-12 | 1077 | 11 | |
25472 | 25472 | Plumas | Plumas | 63 | 2020-07-12 | 17 | 0 | TRUE |
25473 | 25473 | Riverside | Riverside | 65 | 2020-07-12 | 24765 | 537 | TRUE |
25474 | 25474 | Sacramento | Sacramento | 67 | 2020-07-12 | 5489 | 83 | |
25475 | 25475 | San Benito | San Benito | 69 | 2020-07-12 | 362 | 2 | |
25476 | 25476 | San Bernardino | San Bernardino | 71 | 2020-07-12 | 19043 | 423 | |
25477 | 25477 | San Diego | San Diego | 73 | 2020-07-12 | 19929 | 422 | |
25478 | 25478 | San Francisco | San Francisco | 75 | 2020-07-12 | 4522 | 50 | |
25479 | 25479 | San Joaquin | San Joaquin | 77 | 2020-07-12 | 6279 | 68 | TRUE |
25480 | 25480 | San Luis Obispo | San Luis Obispo | 79 | 2020-07-12 | 905 | 4 | TRUE |
25481 | 25481 | San Mateo | San Mateo | 81 | 2020-07-12 | 3949 | 112 | TRUE |
25482 | 25482 | Santa Barbara | Santa Barbara | 83 | 2020-07-12 | 3931 | 31 | TRUE |
25483 | 25483 | Santa Clara | Santa Clara | 85 | 2020-07-12 | 7356 | 171 | |
25484 | 25484 | Santa Cruz | Santa Cruz | 87 | 2020-07-12 | 569 | 3 | |
25485 | 25485 | Shasta | Shasta | 89 | 2020-07-12 | 200 | 6 | |
25486 | 25486 | Sierra | Sierra | 91 | 2020-07-12 | 1 | 0 | TRUE |
25487 | 25487 | Siskiyou | Siskiyou | 93 | 2020-07-12 | 41 | 0 | TRUE |
25488 | 25488 | Solano | Solano | 95 | 2020-07-12 | 2075 | 28 | TRUE |
25489 | 25489 | Sonoma | Sonoma | 97 | 2020-07-12 | 1819 | 16 | |
25490 | 25490 | Stanislaus | Stanislaus | 99 | 2020-07-12 | 4973 | 51 | |
25491 | 25491 | Sutter | Sutter | 101 | 2020-07-12 | 403 | 4 | |
25492 | 25492 | Tehama | Tehama | 103 | 2020-07-12 | 107 | 1 | TRUE |
25493 | 25493 | Trinity | Trinity | 105 | 2020-07-12 | 2 | 0 | TRUE |
25494 | 25494 | Tulare | Tulare | 107 | 2020-07-12 | 5678 | 152 | TRUE |
25495 | 25495 | Tuolumne | Tuolumne | 109 | 2020-07-12 | 73 | 0 | |
25496 | 25496 | Ventura | Ventura | 111 | 2020-07-12 | 4246 | 53 | TRUE |
25497 | 25497 | Yolo | Yolo | 113 | 2020-07-12 | 929 | 28 | |
25498 | 25498 | Yuba | Yuba | 115 | 2020-07-12 | 198 | 3 |
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 );