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-05-05 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 |
---|---|---|---|---|---|---|---|---|
29586 | 29586 | Alameda | Alameda | 1 | 2020-05-05 | 1771 | 102 | |
29587 | 29587 | Berkeley | Alameda | 1 | 2020-05-05 | 57 | 1 | |
29588 | 29588 | Alpine | Alpine | 3 | 2020-05-05 | 1 | 0 | TRUE |
29589 | 29589 | Amador | Amador | 5 | 2020-05-05 | 8 | 0 | |
29590 | 29590 | Butte | Butte | 7 | 2020-05-05 | 19 | 0 | |
29591 | 29591 | Calaveras | Calaveras | 9 | 2020-05-05 | 13 | 0 | TRUE |
29592 | 29592 | Colusa | Colusa | 11 | 2020-05-05 | 3 | 0 | |
29593 | 29593 | Contra Costa | Contra Costa | 13 | 2020-05-05 | 961 | 29 | |
29594 | 29594 | Del Norte | Del Norte | 15 | 2020-05-05 | 3 | 0 | |
29595 | 29595 | El Dorado | El Dorado | 17 | 2020-05-05 | 53 | 0 | |
29596 | 29596 | Fresno | Fresno | 19 | 2020-05-05 | 1352 | 9 | |
29597 | 29597 | Glenn | Glenn | 21 | 2020-05-05 | 5 | 0 | |
29598 | 29598 | Humboldt | Humboldt | 23 | 2020-05-05 | 54 | 0 | |
29599 | 29599 | Imperial | Imperial | 25 | 2020-05-05 | 400 | 9 | |
29600 | 29600 | Inyo | Inyo | 27 | 2020-05-05 | 19 | 1 | |
29601 | 29601 | Kern | Kern | 29 | 2020-05-05 | 1045 | 11 | |
29602 | 29602 | Kings | Kings | 31 | 2020-05-05 | 211 | 1 | |
29603 | 29603 | Lake | Lake | 33 | 2020-05-05 | 8 | 0 | |
29604 | 29604 | Lassen | Lassen | 35 | 2020-05-05 | 0 | 0 | |
29605 | 29605 | Long Beach | Los Angeles | 37 | 2020-05-05 | 789 | 38 | |
29606 | 29606 | Los Angeles | Los Angeles | 37 | 2020-05-05 | 26595 | 1216 | |
29607 | 29607 | Pasadena | Los Angeles | 37 | 2020-05-05 | 482 | 61 | |
29608 | 29608 | Madera | Madera | 39 | 2020-05-05 | 54 | 2 | |
29609 | 29609 | Marin | Marin | 41 | 2020-05-05 | 243 | 14 | |
29610 | 29610 | Mariposa | Mariposa | 43 | 2020-05-05 | 14 | 0 | |
29611 | 29611 | Mendocino | Mendocino | 45 | 2020-05-05 | 12 | 0 | TRUE |
29612 | 29612 | Merced | Merced | 47 | 2020-05-05 | 146 | 3 | |
29613 | 29613 | Modoc | Modoc | 49 | 2020-05-05 | 0 | 0 | |
29614 | 29614 | Mono | Mono | 51 | 2020-05-05 | 26 | 1 | |
29615 | 29615 | Monterey | Monterey | 53 | 2020-05-05 | 241 | 6 | |
29616 | 29616 | Napa | Napa | 55 | 2020-05-05 | 75 | 2 | |
29617 | 29617 | Nevada | Nevada | 57 | 2020-05-05 | 41 | 1 | TRUE |
29618 | 29618 | Orange | Orange | 59 | 2020-05-05 | 2865 | 61 | |
29619 | 29619 | Placer | Placer | 61 | 2020-05-05 | 162 | 8 | |
29620 | 29620 | Plumas | Plumas | 63 | 2020-05-05 | 4 | 0 | |
29621 | 29621 | Riverside | Riverside | 65 | 2020-05-05 | 4454 | 184 | |
29622 | 29622 | Sacramento | Sacramento | 67 | 2020-05-05 | 1133 | 47 | |
29623 | 29623 | San Benito | San Benito | 69 | 2020-05-05 | 53 | 2 | |
29624 | 29624 | San Bernardino | San Bernardino | 71 | 2020-05-05 | 2329 | 124 | |
29625 | 29625 | San Diego | San Diego | 73 | 2020-05-05 | 4160 | 150 | |
29626 | 29626 | San Francisco | San Francisco | 75 | 2020-05-05 | 1728 | 31 | |
29627 | 29627 | San Joaquin | San Joaquin | 77 | 2020-05-05 | 577 | 26 | |
29628 | 29628 | San Luis Obispo | San Luis Obispo | 79 | 2020-05-05 | 204 | 1 | |
29629 | 29629 | San Mateo | San Mateo | 81 | 2020-05-05 | 1315 | 56 | |
29630 | 29630 | Santa Barbara | Santa Barbara | 83 | 2020-05-05 | 544 | 9 | |
29631 | 29631 | Santa Clara | Santa Clara | 85 | 2020-05-05 | 2296 | 126 | |
29632 | 29632 | Santa Cruz | Santa Cruz | 87 | 2020-05-05 | 138 | 2 | |
29633 | 29633 | Shasta | Shasta | 89 | 2020-05-05 | 31 | 4 | |
29634 | 29634 | Sierra | Sierra | 91 | 2020-05-05 | 0 | 0 | |
29635 | 29635 | Siskiyou | Siskiyou | 93 | 2020-05-05 | 5 | 0 | |
29636 | 29636 | Solano | Solano | 95 | 2020-05-05 | 325 | 6 | |
29637 | 29637 | Sonoma | Sonoma | 97 | 2020-05-05 | 261 | 3 | TRUE |
29638 | 29638 | Stanislaus | Stanislaus | 99 | 2020-05-05 | 433 | 15 | |
29639 | 29639 | Sutter | Sutter | 101 | 2020-05-05 | 31 | 2 | |
29640 | 29640 | Tehama | Tehama | 103 | 2020-05-05 | 1 | 1 | TRUE |
29641 | 29641 | Trinity | Trinity | 105 | 2020-05-05 | 0 | 0 | |
29642 | 29642 | Tulare | Tulare | 107 | 2020-05-05 | 858 | 40 | |
29643 | 29643 | Tuolumne | Tuolumne | 109 | 2020-05-05 | 2 | 0 | |
29644 | 29644 | Ventura | Ventura | 111 | 2020-05-05 | 595 | 19 | |
29645 | 29645 | Yolo | Yolo | 113 | 2020-05-05 | 172 | 19 | |
29646 | 29646 | Yuba | Yuba | 115 | 2020-05-05 | 19 | 1 |
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 );