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-08-11 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 |
---|---|---|---|---|---|---|---|---|
23608 | 23608 | Alameda | Alameda | 1 | 2020-08-11 | 13613 | 267 | |
23609 | 23609 | Berkeley | Alameda | 1 | 2020-08-11 | 450 | 8 | |
23610 | 23610 | Alpine | Alpine | 3 | 2020-08-11 | 2 | 0 | TRUE |
23611 | 23611 | Amador | Amador | 5 | 2020-08-11 | 195 | 10 | |
23612 | 23612 | Butte | Butte | 7 | 2020-08-11 | 1296 | 8 | |
23613 | 23613 | Calaveras | Calaveras | 9 | 2020-08-11 | 161 | 1 | |
23614 | 23614 | Colusa | Colusa | 11 | 2020-08-11 | 396 | 5 | |
23615 | 23615 | Contra Costa | Contra Costa | 13 | 2020-08-11 | 9787 | 146 | |
23616 | 23616 | Del Norte | Del Norte | 15 | 2020-08-11 | 104 | 0 | |
23617 | 23617 | El Dorado | El Dorado | 17 | 2020-08-11 | 785 | 2 | |
23618 | 23618 | Fresno | Fresno | 19 | 2020-08-11 | 24266 | 191 | |
23619 | 23619 | Glenn | Glenn | 21 | 2020-08-11 | 396 | 3 | |
23620 | 23620 | Humboldt | Humboldt | 23 | 2020-08-11 | 293 | 4 | |
23621 | 23621 | Imperial | Imperial | 25 | 2020-08-11 | 9867 | 244 | |
23622 | 23622 | Inyo | Inyo | 27 | 2020-08-11 | 113 | 5 | |
23623 | 23623 | Kern | Kern | 29 | 2020-08-11 | 24995 | 183 | |
23624 | 23624 | Kings | Kings | 31 | 2020-08-11 | 5067 | 62 | |
23625 | 23625 | Lake | Lake | 33 | 2020-08-11 | 253 | 2 | |
23626 | 23626 | Lassen | Lassen | 35 | 2020-08-11 | 683 | 0 | TRUE |
23627 | 23627 | Long Beach | Los Angeles | 37 | 2020-08-11 | 9210 | 184 | |
23628 | 23628 | Los Angeles | Los Angeles | 37 | 2020-08-11 | 200802 | 4763 | |
23629 | 23629 | Pasadena | Los Angeles | 37 | 2020-08-11 | 2133 | 111 | |
23630 | 23630 | Madera | Madera | 39 | 2020-08-11 | 2590 | 40 | |
23631 | 23631 | Marin | Marin | 41 | 2020-08-11 | 5471 | 81 | |
23632 | 23632 | Mariposa | Mariposa | 43 | 2020-08-11 | 63 | 2 | |
23633 | 23633 | Mendocino | Mendocino | 45 | 2020-08-11 | 478 | 10 | |
23634 | 23634 | Merced | Merced | 47 | 2020-08-11 | 6102 | 74 | |
23635 | 23635 | Modoc | Modoc | 49 | 2020-08-11 | 5 | 0 | |
23636 | 23636 | Mono | Mono | 51 | 2020-08-11 | 158 | 1 | |
23637 | 23637 | Monterey | Monterey | 53 | 2020-08-11 | 5494 | 37 | |
23638 | 23638 | Napa | Napa | 55 | 2020-08-11 | 1129 | 11 | |
23639 | 23639 | Nevada | Nevada | 57 | 2020-08-11 | 357 | 1 | |
23640 | 23640 | Orange | Orange | 59 | 2020-08-11 | 41578 | 734 | |
23641 | 23641 | Placer | Placer | 61 | 2020-08-11 | 2377 | 24 | |
23642 | 23642 | Plumas | Plumas | 63 | 2020-08-11 | 37 | 0 | |
23643 | 23643 | Riverside | Riverside | 65 | 2020-08-11 | 43376 | 824 | |
23644 | 23644 | Sacramento | Sacramento | 67 | 2020-08-11 | 12274 | 179 | |
23645 | 23645 | San Benito | San Benito | 69 | 2020-08-11 | 767 | 4 | |
23646 | 23646 | San Bernardino | San Bernardino | 71 | 2020-08-11 | 37315 | 831 | |
23647 | 23647 | San Diego | San Diego | 73 | 2020-08-11 | 33157 | 602 | |
23648 | 23648 | San Francisco | San Francisco | 75 | 2020-08-11 | 7692 | 67 | |
23649 | 23649 | San Joaquin | San Joaquin | 77 | 2020-08-11 | 13870 | 235 | |
23650 | 23650 | San Luis Obispo | San Luis Obispo | 79 | 2020-08-11 | 2278 | 17 | |
23651 | 23651 | San Mateo | San Mateo | 81 | 2020-08-11 | 6431 | 122 | |
23652 | 23652 | Santa Barbara | Santa Barbara | 83 | 2020-08-11 | 7074 | 73 | |
23653 | 23653 | Santa Clara | Santa Clara | 85 | 2020-08-11 | 14458 | 209 | |
23654 | 23654 | Santa Cruz | Santa Cruz | 87 | 2020-08-11 | 1287 | 6 | |
23655 | 23655 | Shasta | Shasta | 89 | 2020-08-11 | 469 | 10 | |
23656 | 23656 | Sierra | Sierra | 91 | 2020-08-11 | 5 | 0 | |
23657 | 23657 | Siskiyou | Siskiyou | 93 | 2020-08-11 | 106 | 0 | |
23658 | 23658 | Solano | Solano | 95 | 2020-08-11 | 4338 | 41 | |
23659 | 23659 | Sonoma | Sonoma | 97 | 2020-08-11 | 3825 | 51 | |
23660 | 23660 | Stanislaus | Stanislaus | 99 | 2020-08-11 | 10855 | 177 | |
23661 | 23661 | Sutter | Sutter | 101 | 2020-08-11 | 1019 | 7 | |
23662 | 23662 | Tehama | Tehama | 103 | 2020-08-11 | 304 | 1 | |
23663 | 23663 | Trinity | Trinity | 105 | 2020-08-11 | 6 | 0 | |
23664 | 23664 | Tulare | Tulare | 107 | 2020-08-11 | 11549 | 198 | |
23665 | 23665 | Tuolumne | Tuolumne | 109 | 2020-08-11 | 159 | 2 | |
23666 | 23666 | Ventura | Ventura | 111 | 2020-08-11 | 8740 | 93 | |
23667 | 23667 | Yolo | Yolo | 113 | 2020-08-11 | 1898 | 45 | |
23668 | 23668 | Yuba | Yuba | 115 | 2020-08-11 | 678 | 4 |
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 );