latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
55 rows where "date" is on date 2020-04-02 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
31468 | 31468 | Alameda | Alameda | 1 | 2020-04-02 | 434 | 38 | |
31469 | 31469 | Berkeley | Alameda | 1 | 2020-04-02 | 24 | 1 | |
31470 | 31470 | Alpine | Alpine | 3 | 2020-04-02 | 1 | 0 | TRUE |
31471 | 31471 | Amador | Amador | 5 | 2020-04-02 | 3 | 0 | |
31472 | 31472 | Butte | Butte | 7 | 2020-04-02 | 7 | 0 | |
31473 | 31473 | Calaveras | Calaveras | 9 | 2020-04-02 | 3 | 0 | |
31474 | 31474 | Colusa | Colusa | 11 | 2020-04-02 | 1 | 0 | |
31475 | 31475 | Contra Costa | Contra Costa | 13 | 2020-04-02 | 294 | 3 | |
31476 | 31476 | Del Norte | Del Norte | 15 | 2020-04-02 | 1 | 0 | |
31477 | 31477 | El Dorado | El Dorado | 17 | 2020-04-02 | 19 | 0 | |
31478 | 31478 | Fresno | Fresno | 19 | 2020-04-02 | 271 | 0 | |
31479 | 31479 | Glenn | Glenn | 21 | 2020-04-02 | 2 | 0 | |
31480 | 31480 | Humboldt | Humboldt | 23 | 2020-04-02 | 37 | 0 | |
31481 | 31481 | Imperial | Imperial | 25 | 2020-04-02 | 50 | 1 | |
31482 | 31482 | Inyo | Inyo | 27 | 2020-04-02 | 10 | 0 | |
31483 | 31483 | Kern | Kern | 29 | 2020-04-02 | 155 | 1 | |
31484 | 31484 | Kings | Kings | 31 | 2020-04-02 | 5 | 0 | |
31485 | 31485 | Long Beach | Los Angeles | 37 | 2020-04-02 | 153 | 2 | |
31486 | 31486 | Los Angeles | Los Angeles | 37 | 2020-04-02 | 3869 | 77 | |
31487 | 31487 | Pasadena | Los Angeles | 37 | 2020-04-02 | 49 | 1 | |
31488 | 31488 | Madera | Madera | 39 | 2020-04-02 | 28 | 1 | |
31489 | 31489 | Marin | Marin | 41 | 2020-04-02 | 118 | 6 | |
31490 | 31490 | Mendocino | Mendocino | 45 | 2020-04-02 | 4 | 0 | |
31491 | 31491 | Merced | Merced | 47 | 2020-04-02 | 16 | 0 | |
31492 | 31492 | Mono | Mono | 51 | 2020-04-02 | 18 | 1 | |
31493 | 31493 | Monterey | Monterey | 53 | 2020-04-02 | 53 | 2 | |
31494 | 31494 | Napa | Napa | 55 | 2020-04-02 | 18 | 1 | |
31495 | 31495 | Nevada | Nevada | 57 | 2020-04-02 | 30 | 0 | |
31496 | 31496 | Orange | Orange | 59 | 2020-04-02 | 648 | 13 | |
31497 | 31497 | Placer | Placer | 61 | 2020-04-02 | 90 | 2 | |
31498 | 31498 | Plumas | Plumas | 63 | 2020-04-02 | 2 | 0 | |
31499 | 31499 | Riverside | Riverside | 65 | 2020-04-02 | 493 | 14 | |
31500 | 31500 | Sacramento | Sacramento | 67 | 2020-04-02 | 341 | 9 | |
31501 | 31501 | San Benito | San Benito | 69 | 2020-04-02 | 23 | 1 | |
31502 | 31502 | San Bernardino | San Bernardino | 71 | 2020-04-02 | 304 | 13 | |
31503 | 31503 | San Diego | San Diego | 73 | 2020-04-02 | 966 | 16 | |
31504 | 31504 | San Francisco | San Francisco | 75 | 2020-04-02 | 450 | 7 | |
31505 | 31505 | San Joaquin | San Joaquin | 77 | 2020-04-02 | 164 | 10 | |
31506 | 31506 | San Luis Obispo | San Luis Obispo | 79 | 2020-04-02 | 89 | 0 | |
31507 | 31507 | San Mateo | San Mateo | 81 | 2020-04-02 | 453 | 10 | |
31508 | 31508 | Santa Barbara | Santa Barbara | 83 | 2020-04-02 | 139 | 1 | |
31509 | 31509 | Santa Clara | Santa Clara | 85 | 2020-04-02 | 1250 | 42 | |
31510 | 31510 | Santa Cruz | Santa Cruz | 87 | 2020-04-02 | 57 | 1 | |
31511 | 31511 | Shasta | Shasta | 89 | 2020-04-02 | 11 | 1 | |
31512 | 31512 | Siskiyou | Siskiyou | 93 | 2020-04-02 | 3 | 0 | |
31513 | 31513 | Solano | Solano | 95 | 2020-04-02 | 61 | 1 | |
31514 | 31514 | Sonoma | Sonoma | 97 | 2020-04-02 | 95 | 1 | |
31515 | 31515 | Stanislaus | Stanislaus | 99 | 2020-04-02 | 51 | 0 | |
31516 | 31516 | Sutter | Sutter | 101 | 2020-04-02 | 14 | 1 | |
31517 | 31517 | Tehama | Tehama | 103 | 2020-04-02 | 1 | 0 | TRUE |
31518 | 31518 | Tulare | Tulare | 107 | 2020-04-02 | 74 | 2 | |
31519 | 31519 | Tuolumne | Tuolumne | 109 | 2020-04-02 | 1 | 0 | |
31520 | 31520 | Ventura | Ventura | 111 | 2020-04-02 | 177 | 6 | |
31521 | 31521 | Yolo | Yolo | 113 | 2020-04-02 | 33 | 1 | |
31522 | 31522 | Yuba | Yuba | 115 | 2020-04-02 | 8 | 0 |
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 );