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-04 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
29647 | 29647 | Alameda | Alameda | 1 | 2020-05-04 | 1736 | 100 | |
29648 | 29648 | Berkeley | Alameda | 1 | 2020-05-04 | 56 | 1 | |
29649 | 29649 | Alpine | Alpine | 3 | 2020-05-04 | 1 | 0 | TRUE |
29650 | 29650 | Amador | Amador | 5 | 2020-05-04 | 8 | 0 | |
29651 | 29651 | Butte | Butte | 7 | 2020-05-04 | 16 | 0 | |
29652 | 29652 | Calaveras | Calaveras | 9 | 2020-05-04 | 13 | 0 | TRUE |
29653 | 29653 | Colusa | Colusa | 11 | 2020-05-04 | 3 | 0 | |
29654 | 29654 | Contra Costa | Contra Costa | 13 | 2020-05-04 | 941 | 28 | |
29655 | 29655 | Del Norte | Del Norte | 15 | 2020-05-04 | 3 | 0 | |
29656 | 29656 | El Dorado | El Dorado | 17 | 2020-05-04 | 53 | 0 | |
29657 | 29657 | Fresno | Fresno | 19 | 2020-05-04 | 1287 | 9 | |
29658 | 29658 | Glenn | Glenn | 21 | 2020-05-04 | 5 | 0 | |
29659 | 29659 | Humboldt | Humboldt | 23 | 2020-05-04 | 54 | 0 | |
29660 | 29660 | Imperial | Imperial | 25 | 2020-05-04 | 379 | 9 | |
29661 | 29661 | Inyo | Inyo | 27 | 2020-05-04 | 19 | 1 | |
29662 | 29662 | Kern | Kern | 29 | 2020-05-04 | 1016 | 8 | |
29663 | 29663 | Kings | Kings | 31 | 2020-05-04 | 198 | 1 | |
29664 | 29664 | Lake | Lake | 33 | 2020-05-04 | 7 | 0 | |
29665 | 29665 | Lassen | Lassen | 35 | 2020-05-04 | 0 | 0 | TRUE |
29666 | 29666 | Long Beach | Los Angeles | 37 | 2020-05-04 | 768 | 37 | |
29667 | 29667 | Los Angeles | Los Angeles | 37 | 2020-05-04 | 25018 | 1163 | |
29668 | 29668 | Pasadena | Los Angeles | 37 | 2020-05-04 | 452 | 60 | |
29669 | 29669 | Madera | Madera | 39 | 2020-05-04 | 54 | 2 | |
29670 | 29670 | Marin | Marin | 41 | 2020-05-04 | 241 | 13 | |
29671 | 29671 | Mariposa | Mariposa | 43 | 2020-05-04 | 14 | 0 | |
29672 | 29672 | Mendocino | Mendocino | 45 | 2020-05-04 | 12 | 0 | |
29673 | 29673 | Merced | Merced | 47 | 2020-05-04 | 146 | 3 | |
29674 | 29674 | Modoc | Modoc | 49 | 2020-05-04 | 0 | 0 | TRUE |
29675 | 29675 | Mono | Mono | 51 | 2020-05-04 | 26 | 1 | TRUE |
29676 | 29676 | Monterey | Monterey | 53 | 2020-05-04 | 237 | 6 | |
29677 | 29677 | Napa | Napa | 55 | 2020-05-04 | 74 | 2 | |
29678 | 29678 | Nevada | Nevada | 57 | 2020-05-04 | 41 | 1 | TRUE |
29679 | 29679 | Orange | Orange | 59 | 2020-05-04 | 2799 | 57 | |
29680 | 29680 | Placer | Placer | 61 | 2020-05-04 | 162 | 8 | |
29681 | 29681 | Plumas | Plumas | 63 | 2020-05-04 | 4 | 0 | |
29682 | 29682 | Riverside | Riverside | 65 | 2020-05-04 | 4354 | 181 | |
29683 | 29683 | Sacramento | Sacramento | 67 | 2020-05-04 | 1127 | 47 | |
29684 | 29684 | San Benito | San Benito | 69 | 2020-05-04 | 52 | 2 | |
29685 | 29685 | San Bernardino | San Bernardino | 71 | 2020-05-04 | 2182 | 121 | |
29686 | 29686 | San Diego | San Diego | 73 | 2020-05-04 | 4020 | 144 | |
29687 | 29687 | San Francisco | San Francisco | 75 | 2020-05-04 | 1624 | 29 | |
29688 | 29688 | San Joaquin | San Joaquin | 77 | 2020-05-04 | 573 | 26 | |
29689 | 29689 | San Luis Obispo | San Luis Obispo | 79 | 2020-05-04 | 202 | 1 | |
29690 | 29690 | San Mateo | San Mateo | 81 | 2020-05-04 | 1281 | 51 | |
29691 | 29691 | Santa Barbara | Santa Barbara | 83 | 2020-05-04 | 526 | 8 | |
29692 | 29692 | Santa Clara | Santa Clara | 85 | 2020-05-04 | 2283 | 124 | |
29693 | 29693 | Santa Cruz | Santa Cruz | 87 | 2020-05-04 | 137 | 2 | |
29694 | 29694 | Shasta | Shasta | 89 | 2020-05-04 | 31 | 4 | |
29695 | 29695 | Sierra | Sierra | 91 | 2020-05-04 | 0 | 0 | |
29696 | 29696 | Siskiyou | Siskiyou | 93 | 2020-05-04 | 5 | 0 | |
29697 | 29697 | Solano | Solano | 95 | 2020-05-04 | 320 | 6 | |
29698 | 29698 | Sonoma | Sonoma | 97 | 2020-05-04 | 261 | 3 | |
29699 | 29699 | Stanislaus | Stanislaus | 99 | 2020-05-04 | 428 | 15 | |
29700 | 29700 | Sutter | Sutter | 101 | 2020-05-04 | 31 | 2 | |
29701 | 29701 | Tehama | Tehama | 103 | 2020-05-04 | 1 | 1 | TRUE |
29702 | 29702 | Trinity | Trinity | 105 | 2020-05-04 | 0 | 0 | TRUE |
29703 | 29703 | Tulare | Tulare | 107 | 2020-05-04 | 757 | 40 | |
29704 | 29704 | Tuolumne | Tuolumne | 109 | 2020-05-04 | 2 | 0 | |
29705 | 29705 | Ventura | Ventura | 111 | 2020-05-04 | 577 | 19 | |
29706 | 29706 | Yolo | Yolo | 113 | 2020-05-04 | 171 | 19 | |
29707 | 29707 | Yuba | Yuba | 115 | 2020-05-04 | 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 );