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-09-10 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
21778 | 21778 | Alameda | Alameda | 1 | 2020-09-10 | 19016 | 401 | |
21779 | 21779 | Berkeley | Alameda | 1 | 2020-09-10 | 614 | 10 | |
21780 | 21780 | Alpine | Alpine | 3 | 2020-09-10 | 2 | 0 | TRUE |
21781 | 21781 | Amador | Amador | 5 | 2020-09-10 | 241 | 15 | |
21782 | 21782 | Butte | Butte | 7 | 2020-09-10 | 2590 | 28 | TRUE |
21783 | 21783 | Calaveras | Calaveras | 9 | 2020-09-10 | 286 | 2 | TRUE |
21784 | 21784 | Colusa | Colusa | 11 | 2020-09-10 | 487 | 6 | |
21785 | 21785 | Contra Costa | Contra Costa | 13 | 2020-09-10 | 14966 | 188 | |
21786 | 21786 | Del Norte | Del Norte | 15 | 2020-09-10 | 128 | 1 | |
21787 | 21787 | El Dorado | El Dorado | 17 | 2020-09-10 | 1025 | 2 | |
21788 | 21788 | Fresno | Fresno | 19 | 2020-09-10 | 28958 | 326 | |
21789 | 21789 | Glenn | Glenn | 21 | 2020-09-10 | 519 | 3 | |
21790 | 21790 | Humboldt | Humboldt | 23 | 2020-09-10 | 442 | 4 | |
21791 | 21791 | Imperial | Imperial | 25 | 2020-09-10 | 11183 | 303 | |
21792 | 21792 | Inyo | Inyo | 27 | 2020-09-10 | 185 | 14 | |
21793 | 21793 | Kern | Kern | 29 | 2020-09-10 | 30440 | 307 | |
21794 | 21794 | Kings | Kings | 31 | 2020-09-10 | 6918 | 76 | |
21795 | 21795 | Lake | Lake | 33 | 2020-09-10 | 378 | 6 | |
21796 | 21796 | Lassen | Lassen | 35 | 2020-09-10 | 727 | 0 | |
21797 | 21797 | Long Beach | Los Angeles | 37 | 2020-09-10 | 11088 | 230 | |
21798 | 21798 | Los Angeles | Los Angeles | 37 | 2020-09-10 | 237532 | 5784 | |
21799 | 21799 | Pasadena | Los Angeles | 37 | 2020-09-10 | 2455 | 117 | |
21800 | 21800 | Madera | Madera | 39 | 2020-09-10 | 4079 | 58 | |
21801 | 21801 | Marin | Marin | 41 | 2020-09-10 | 6407 | 99 | |
21802 | 21802 | Mariposa | Mariposa | 43 | 2020-09-10 | 74 | 2 | |
21803 | 21803 | Mendocino | Mendocino | 45 | 2020-09-10 | 778 | 17 | |
21804 | 21804 | Merced | Merced | 47 | 2020-09-10 | 8487 | 126 | |
21805 | 21805 | Modoc | Modoc | 49 | 2020-09-10 | 22 | 0 | |
21806 | 21806 | Mono | Mono | 51 | 2020-09-10 | 162 | 2 | |
21807 | 21807 | Monterey | Monterey | 53 | 2020-09-10 | 8738 | 62 | |
21808 | 21808 | Napa | Napa | 55 | 2020-09-10 | 1532 | 12 | |
21809 | 21809 | Nevada | Nevada | 57 | 2020-09-10 | 478 | 5 | |
21810 | 21810 | Orange | Orange | 59 | 2020-09-10 | 50471 | 1069 | |
21811 | 21811 | Placer | Placer | 61 | 2020-09-10 | 3249 | 38 | |
21812 | 21812 | Plumas | Plumas | 63 | 2020-09-10 | 46 | 0 | |
21813 | 21813 | Riverside | Riverside | 65 | 2020-09-10 | 54868 | 1094 | |
21814 | 21814 | Sacramento | Sacramento | 67 | 2020-09-10 | 19669 | 346 | |
21815 | 21815 | San Benito | San Benito | 69 | 2020-09-10 | 1209 | 10 | |
21816 | 21816 | San Bernardino | San Bernardino | 71 | 2020-09-10 | 50210 | 1041 | |
21817 | 21817 | San Diego | San Diego | 73 | 2020-09-10 | 41608 | 725 | |
21818 | 21818 | San Francisco | San Francisco | 75 | 2020-09-10 | 10120 | 88 | |
21819 | 21819 | San Joaquin | San Joaquin | 77 | 2020-09-10 | 18528 | 383 | |
21820 | 21820 | San Luis Obispo | San Luis Obispo | 79 | 2020-09-10 | 3194 | 23 | |
21821 | 21821 | San Mateo | San Mateo | 81 | 2020-09-10 | 8895 | 136 | |
21822 | 21822 | Santa Barbara | Santa Barbara | 83 | 2020-09-10 | 8579 | 103 | |
21823 | 21823 | Santa Clara | Santa Clara | 85 | 2020-09-10 | 19556 | 271 | TRUE |
21824 | 21824 | Santa Cruz | Santa Cruz | 87 | 2020-09-10 | 2013 | 7 | |
21825 | 21825 | Shasta | Shasta | 89 | 2020-09-10 | 611 | 12 | |
21826 | 21826 | Sierra | Sierra | 91 | 2020-09-10 | 6 | 0 | |
21827 | 21827 | Siskiyou | Siskiyou | 93 | 2020-09-10 | 154 | 0 | |
21828 | 21828 | Solano | Solano | 95 | 2020-09-10 | 5805 | 48 | |
21829 | 21829 | Sonoma | Sonoma | 97 | 2020-09-10 | 6561 | 105 | |
21830 | 21830 | Stanislaus | Stanislaus | 99 | 2020-09-10 | 15749 | 303 | |
21831 | 21831 | Sutter | Sutter | 101 | 2020-09-10 | 1542 | 10 | |
21832 | 21832 | Tehama | Tehama | 103 | 2020-09-10 | 462 | 1 | |
21833 | 21833 | Trinity | Trinity | 105 | 2020-09-10 | 14 | 0 | |
21834 | 21834 | Tulare | Tulare | 107 | 2020-09-10 | 15043 | 246 | |
21835 | 21835 | Tuolumne | Tuolumne | 109 | 2020-09-10 | 212 | 3 | |
21836 | 21836 | Ventura | Ventura | 111 | 2020-09-10 | 11373 | 129 | |
21837 | 21837 | Yolo | Yolo | 113 | 2020-09-10 | 2611 | 53 | |
21838 | 21838 | Yuba | Yuba | 115 | 2020-09-10 | 1044 | 7 |
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 );