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-08-04 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 |
---|---|---|---|---|---|---|---|---|
1770 | 1770 | Alameda | Alameda | 1 | 2021-08-04 | 93976 | 1240 | |
1771 | 1771 | Berkeley | Alameda | 1 | 2021-08-04 | 4037 | 50 | |
1772 | 1772 | Alpine | Alpine | 3 | 2021-08-04 | 89 | 0 | TRUE |
1773 | 1773 | Amador | Amador | 5 | 2021-08-04 | 3912 | 48 | |
1774 | 1774 | Butte | Butte | 7 | 2021-08-04 | 13509 | 200 | |
1775 | 1775 | Calaveras | Calaveras | 9 | 2021-08-04 | 2359 | 58 | |
1776 | 1776 | Colusa | Colusa | 11 | 2021-08-04 | 2381 | 18 | TRUE |
1777 | 1777 | Contra Costa | Contra Costa | 13 | 2021-08-04 | 78314 | 838 | |
1778 | 1778 | Del Norte | Del Norte | 15 | 2021-08-04 | 1777 | 10 | |
1779 | 1779 | El Dorado | El Dorado | 17 | 2021-08-04 | 11375 | 121 | |
1780 | 1780 | Fresno | Fresno | 19 | 2021-08-04 | 105732 | 1746 | |
1781 | 1781 | Glenn | Glenn | 21 | 2021-08-04 | 2410 | 27 | |
1782 | 1782 | Humboldt | Humboldt | 23 | 2021-08-04 | 5351 | 54 | |
1783 | 1783 | Imperial | Imperial | 25 | 2021-08-04 | 29036 | 746 | |
1784 | 1784 | Inyo | Inyo | 27 | 2021-08-04 | 1482 | 38 | TRUE |
1785 | 1785 | Kern | Kern | 29 | 2021-08-04 | 114342 | 1428 | |
1786 | 1786 | Kings | Kings | 31 | 2021-08-04 | 23906 | 252 | |
1787 | 1787 | Lake | Lake | 33 | 2021-08-04 | 4294 | 65 | TRUE |
1788 | 1788 | Lassen | Lassen | 35 | 2021-08-04 | 5905 | 26 | TRUE |
1789 | 1789 | Long Beach | Los Angeles | 37 | 2021-08-04 | 56696 | 955 | |
1790 | 1790 | Los Angeles | Los Angeles | 37 | 2021-08-04 | 1243063 | 23415 | |
1791 | 1791 | Pasadena | Los Angeles | 37 | 2021-08-04 | 12004 | 353 | |
1792 | 1792 | Madera | Madera | 39 | 2021-08-04 | 17120 | 249 | TRUE |
1793 | 1793 | Marin | Marin | 41 | 2021-08-04 | 15097 | 214 | |
1794 | 1794 | Mariposa | Mariposa | 43 | 2021-08-04 | 537 | 7 | |
1795 | 1795 | Mendocino | Mendocino | 45 | 2021-08-04 | 4856 | 52 | |
1796 | 1796 | Merced | Merced | 47 | 2021-08-04 | 33321 | 485 | TRUE |
1797 | 1797 | Modoc | Modoc | 49 | 2021-08-04 | 577 | 7 | |
1798 | 1798 | Mono | Mono | 51 | 2021-08-04 | 1339 | 5 | TRUE |
1799 | 1799 | Monterey | Monterey | 53 | 2021-08-04 | 44669 | 529 | |
1800 | 1800 | Napa | Napa | 55 | 2021-08-04 | 10562 | 81 | |
1801 | 1801 | Nevada | Nevada | 57 | 2021-08-04 | 5693 | 75 | |
1802 | 1802 | Orange | Orange | 59 | 2021-08-04 | 267131 | 5143 | |
1803 | 1803 | Placer | Placer | 61 | 2021-08-04 | 25559 | 307 | TRUE |
1804 | 1804 | Plumas | Plumas | 63 | 2021-08-04 | 792 | 6 | TRUE |
1805 | 1805 | Riverside | Riverside | 65 | 2021-08-04 | 311573 | 4667 | |
1806 | 1806 | Sacramento | Sacramento | 67 | 2021-08-04 | 117831 | 1790 | |
1807 | 1807 | San Benito | San Benito | 69 | 2021-08-04 | 6326 | 64 | |
1808 | 1808 | San Bernardino | San Bernardino | 71 | 2021-08-04 | 309502 | 4858 | |
1809 | 1809 | San Diego | San Diego | 73 | 2021-08-04 | 301100 | 3805 | |
1810 | 1810 | San Francisco | San Francisco | 75 | 2021-08-04 | 41482 | 565 | |
1811 | 1811 | San Joaquin | San Joaquin | 77 | 2021-08-04 | 78119 | 1474 | |
1812 | 1812 | San Luis Obispo | San Luis Obispo | 79 | 2021-08-04 | 22356 | 267 | TRUE |
1813 | 1813 | San Mateo | San Mateo | 81 | 2021-08-04 | 45198 | 588 | |
1814 | 1814 | Santa Barbara | Santa Barbara | 83 | 2021-08-04 | 36106 | 464 | TRUE |
1815 | 1815 | Santa Clara | Santa Clara | 85 | 2021-08-04 | 124586 | 1709 | |
1816 | 1816 | Santa Cruz | Santa Cruz | 87 | 2021-08-04 | 16779 | 207 | TRUE |
1817 | 1817 | Shasta | Shasta | 89 | 2021-08-04 | 13179 | 242 | |
1818 | 1818 | Sierra | Sierra | 91 | 2021-08-04 | 137 | 0 | TRUE |
1819 | 1819 | Siskiyou | Siskiyou | 93 | 2021-08-04 | 2605 | 40 | |
1820 | 1820 | Solano | Solano | 95 | 2021-08-04 | 36525 | 249 | |
1821 | 1821 | Sonoma | Sonoma | 97 | 2021-08-04 | 33414 | 331 | |
1822 | 1822 | Stanislaus | Stanislaus | 99 | 2021-08-04 | 59874 | 1097 | |
1823 | 1823 | Sutter | Sutter | 101 | 2021-08-04 | 10392 | 111 | |
1824 | 1824 | Tehama | Tehama | 103 | 2021-08-04 | 5942 | 66 | |
1825 | 1825 | Trinity | Trinity | 105 | 2021-08-04 | 474 | 6 | |
1826 | 1826 | Tulare | Tulare | 107 | 2021-08-04 | 50799 | 853 | |
1827 | 1827 | Tuolumne | Tuolumne | 109 | 2021-08-04 | 4731 | 73 | |
1828 | 1828 | Ventura | Ventura | 111 | 2021-08-04 | 84589 | 1039 | |
1829 | 1829 | Yolo | Yolo | 113 | 2021-08-04 | 15132 | 213 | |
1830 | 1830 | Yuba | Yuba | 115 | 2021-08-04 | 7148 | 42 |
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 );