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 2021-03-26 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update, date (date)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
9761 | 9761 | Alameda | Alameda | 1 | 2021-03-26 | 80097 | 1200 | |
9762 | 9762 | Berkeley | Alameda | 1 | 2021-03-26 | 3426 | 46 | |
9763 | 9763 | Alpine | Alpine | 3 | 2021-03-26 | 86 | 0 | TRUE |
9764 | 9764 | Amador | Amador | 5 | 2021-03-26 | 3502 | 45 | |
9765 | 9765 | Butte | Butte | 7 | 2021-03-26 | 11278 | 177 | |
9766 | 9766 | Calaveras | Calaveras | 9 | 2021-03-26 | 1995 | 51 | |
9767 | 9767 | Colusa | Colusa | 11 | 2021-03-26 | 2164 | 16 | |
9768 | 9768 | Contra Costa | Contra Costa | 13 | 2021-03-26 | 64961 | 748 | |
9769 | 9769 | Del Norte | Del Norte | 15 | 2021-03-26 | 1125 | 5 | |
9770 | 9770 | El Dorado | El Dorado | 17 | 2021-03-26 | 9417 | 107 | |
9771 | 9771 | Fresno | Fresno | 19 | 2021-03-26 | 98760 | 1592 | |
9772 | 9772 | Glenn | Glenn | 21 | 2021-03-26 | 2252 | 25 | |
9773 | 9773 | Humboldt | Humboldt | 23 | 2021-03-26 | 3448 | 35 | |
9774 | 9774 | Imperial | Imperial | 25 | 2021-03-26 | 26998 | 715 | |
9775 | 9775 | Inyo | Inyo | 27 | 2021-03-26 | 1394 | 37 | |
9776 | 9776 | Kern | Kern | 29 | 2021-03-26 | 105912 | 1167 | |
9777 | 9777 | Kings | Kings | 31 | 2021-03-26 | 22578 | 241 | |
9778 | 9778 | Lake | Lake | 33 | 2021-03-26 | 3295 | 43 | |
9779 | 9779 | Lassen | Lassen | 35 | 2021-03-26 | 5649 | 24 | |
9780 | 9780 | Long Beach | Los Angeles | 37 | 2021-03-26 | 51976 | 908 | |
9781 | 9781 | Los Angeles | Los Angeles | 37 | 2021-03-26 | 1154019 | 21813 | |
9782 | 9782 | Pasadena | Los Angeles | 37 | 2021-03-26 | 11121 | 335 | |
9783 | 9783 | Madera | Madera | 39 | 2021-03-26 | 15862 | 231 | |
9784 | 9784 | Marin | Marin | 41 | 2021-03-26 | 13635 | 201 | |
9785 | 9785 | Mariposa | Mariposa | 43 | 2021-03-26 | 408 | 7 | |
9786 | 9786 | Mendocino | Mendocino | 45 | 2021-03-26 | 3935 | 46 | |
9787 | 9787 | Merced | Merced | 47 | 2021-03-26 | 30419 | 434 | |
9788 | 9788 | Modoc | Modoc | 49 | 2021-03-26 | 472 | 4 | TRUE |
9789 | 9789 | Mono | Mono | 51 | 2021-03-26 | 1261 | 4 | |
9790 | 9790 | Monterey | Monterey | 53 | 2021-03-26 | 42868 | 340 | |
9791 | 9791 | Napa | Napa | 55 | 2021-03-26 | 9336 | 75 | |
9792 | 9792 | Nevada | Nevada | 57 | 2021-03-26 | 4219 | 74 | |
9793 | 9793 | Orange | Orange | 59 | 2021-03-26 | 250095 | 4684 | |
9794 | 9794 | Placer | Placer | 61 | 2021-03-26 | 20736 | 263 | |
9795 | 9795 | Plumas | Plumas | 63 | 2021-03-26 | 675 | 6 | TRUE |
9796 | 9796 | Riverside | Riverside | 65 | 2021-03-26 | 293831 | 4248 | |
9797 | 9797 | Sacramento | Sacramento | 67 | 2021-03-26 | 96990 | 1599 | |
9798 | 9798 | San Benito | San Benito | 69 | 2021-03-26 | 5846 | 61 | |
9799 | 9799 | San Bernardino | San Bernardino | 71 | 2021-03-26 | 290315 | 4727 | |
9800 | 9800 | San Diego | San Diego | 73 | 2021-03-26 | 269049 | 3525 | |
9801 | 9801 | San Francisco | San Francisco | 75 | 2021-03-26 | 34930 | 461 | |
9802 | 9802 | San Joaquin | San Joaquin | 77 | 2021-03-26 | 69448 | 1250 | |
9803 | 9803 | San Luis Obispo | San Luis Obispo | 79 | 2021-03-26 | 20402 | 255 | |
9804 | 9804 | San Mateo | San Mateo | 81 | 2021-03-26 | 40105 | 547 | |
9805 | 9805 | Santa Barbara | Santa Barbara | 83 | 2021-03-26 | 33020 | 435 | |
9806 | 9806 | Santa Clara | Santa Clara | 85 | 2021-03-26 | 113470 | 1648 | |
9807 | 9807 | Santa Cruz | Santa Cruz | 87 | 2021-03-26 | 15247 | 200 | |
9808 | 9808 | Shasta | Shasta | 89 | 2021-03-26 | 11333 | 202 | |
9809 | 9809 | Sierra | Sierra | 91 | 2021-03-26 | 104 | 0 | |
9810 | 9810 | Siskiyou | Siskiyou | 93 | 2021-03-26 | 1870 | 15 | |
9811 | 9811 | Solano | Solano | 95 | 2021-03-26 | 31009 | 191 | |
9812 | 9812 | Sonoma | Sonoma | 97 | 2021-03-26 | 29090 | 308 | |
9813 | 9813 | Stanislaus | Stanislaus | 99 | 2021-03-26 | 52392 | 992 | |
9814 | 9814 | Sutter | Sutter | 101 | 2021-03-26 | 9110 | 102 | |
9815 | 9815 | Tehama | Tehama | 103 | 2021-03-26 | 5255 | 54 | |
9816 | 9816 | Trinity | Trinity | 105 | 2021-03-26 | 387 | 5 | |
9817 | 9817 | Tulare | Tulare | 107 | 2021-03-26 | 48960 | 805 | |
9818 | 9818 | Tuolumne | Tuolumne | 109 | 2021-03-26 | 4024 | 62 | |
9819 | 9819 | Ventura | Ventura | 111 | 2021-03-26 | 79472 | 969 | |
9820 | 9820 | Yolo | Yolo | 113 | 2021-03-26 | 13176 | 196 | |
9821 | 9821 | Yuba | Yuba | 115 | 2021-03-26 | 5953 | 40 |
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 );