ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
9,229 rows where county = "Lake" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1817364 | 1817364 | 2021-10-15 | Lake | Indiana | 18089 | 65914 | 1199 |
1817900 | 1817900 | 2021-10-15 | Lake | Michigan | 26085 | 911 | 20 |
1817979 | 1817979 | 2021-10-15 | Lake | Minnesota | 27075 | 1062 | 21 |
1818252 | 1818252 | 2021-10-15 | Lake | Montana | 30047 | 3822 | 58 |
1818718 | 1818718 | 2021-10-15 | Lake | Ohio | 39085 | 26457 | 434 |
1818861 | 1818861 | 2021-10-15 | Lake | Oregon | 41037 | 890 | 11 |
1819115 | 1819115 | 2021-10-15 | Lake | South Dakota | 46079 | 1545 | 20 |
1819190 | 1819190 | 2021-10-15 | Lake | Tennessee | 47095 | 2004 | 31 |
1813569 | 1813569 | 2021-10-14 | Lake | California | 6033 | 6499 | 103 |
1813645 | 1813645 | 2021-10-14 | Lake | Colorado | 8065 | 994 | 1 |
1813722 | 1813722 | 2021-10-14 | Lake | Florida | 12069 | 53476 | 1120 |
1814017 | 1814017 | 2021-10-14 | Lake | Illinois | 17097 | 79434 | 1145 |
1814116 | 1814116 | 2021-10-14 | Lake | Indiana | 18089 | 65813 | 1198 |
1814651 | 1814651 | 2021-10-14 | Lake | Michigan | 26085 | 901 | 20 |
1814730 | 1814730 | 2021-10-14 | Lake | Minnesota | 27075 | 1057 | 21 |
1815003 | 1815003 | 2021-10-14 | Lake | Montana | 30047 | 3783 | 58 |
1815469 | 1815469 | 2021-10-14 | Lake | Ohio | 39085 | 26352 | 432 |
1815612 | 1815612 | 2021-10-14 | Lake | Oregon | 41037 | 883 | 11 |
1815866 | 1815866 | 2021-10-14 | Lake | South Dakota | 46079 | 1543 | 20 |
1815941 | 1815941 | 2021-10-14 | Lake | Tennessee | 47095 | 2004 | 31 |
1810320 | 1810320 | 2021-10-13 | Lake | California | 6033 | 6500 | 97 |
1810396 | 1810396 | 2021-10-13 | Lake | Colorado | 8065 | 978 | 1 |
1810473 | 1810473 | 2021-10-13 | Lake | Florida | 12069 | 53476 | 1120 |
1810768 | 1810768 | 2021-10-13 | Lake | Illinois | 17097 | 79360 | 1144 |
1810867 | 1810867 | 2021-10-13 | Lake | Indiana | 18089 | 65703 | 1192 |
1811403 | 1811403 | 2021-10-13 | Lake | Michigan | 26085 | 901 | 20 |
1811482 | 1811482 | 2021-10-13 | Lake | Minnesota | 27075 | 1057 | 21 |
1811755 | 1811755 | 2021-10-13 | Lake | Montana | 30047 | 3667 | 57 |
1812221 | 1812221 | 2021-10-13 | Lake | Ohio | 39085 | 26274 | 432 |
1812364 | 1812364 | 2021-10-13 | Lake | Oregon | 41037 | 877 | 11 |
1812618 | 1812618 | 2021-10-13 | Lake | South Dakota | 46079 | 1541 | 20 |
1812693 | 1812693 | 2021-10-13 | Lake | Tennessee | 47095 | 2004 | 31 |
1807071 | 1807071 | 2021-10-12 | Lake | California | 6033 | 6489 | 97 |
1807147 | 1807147 | 2021-10-12 | Lake | Colorado | 8065 | 974 | 1 |
1807224 | 1807224 | 2021-10-12 | Lake | Florida | 12069 | 53476 | 1120 |
1807519 | 1807519 | 2021-10-12 | Lake | Illinois | 17097 | 79242 | 1144 |
1807618 | 1807618 | 2021-10-12 | Lake | Indiana | 18089 | 65555 | 1189 |
1808154 | 1808154 | 2021-10-12 | Lake | Michigan | 26085 | 888 | 19 |
1808233 | 1808233 | 2021-10-12 | Lake | Minnesota | 27075 | 1054 | 21 |
1808506 | 1808506 | 2021-10-12 | Lake | Montana | 30047 | 3544 | 56 |
1808972 | 1808972 | 2021-10-12 | Lake | Ohio | 39085 | 26163 | 432 |
1809115 | 1809115 | 2021-10-12 | Lake | Oregon | 41037 | 869 | 10 |
1809369 | 1809369 | 2021-10-12 | Lake | South Dakota | 46079 | 1535 | 20 |
1809444 | 1809444 | 2021-10-12 | Lake | Tennessee | 47095 | 2001 | 31 |
1803820 | 1803820 | 2021-10-11 | Lake | California | 6033 | 6477 | 97 |
1803896 | 1803896 | 2021-10-11 | Lake | Colorado | 8065 | 973 | 1 |
1803973 | 1803973 | 2021-10-11 | Lake | Florida | 12069 | 53476 | 1120 |
1804268 | 1804268 | 2021-10-11 | Lake | Illinois | 17097 | 78886 | 1143 |
1804367 | 1804367 | 2021-10-11 | Lake | Indiana | 18089 | 65474 | 1186 |
1804903 | 1804903 | 2021-10-11 | Lake | Michigan | 26085 | 888 | 19 |
1804982 | 1804982 | 2021-10-11 | Lake | Minnesota | 27075 | 1039 | 21 |
1805255 | 1805255 | 2021-10-11 | Lake | Montana | 30047 | 3419 | 55 |
1805722 | 1805722 | 2021-10-11 | Lake | Ohio | 39085 | 26093 | 432 |
1805865 | 1805865 | 2021-10-11 | Lake | Oregon | 41037 | 856 | 9 |
1806119 | 1806119 | 2021-10-11 | Lake | South Dakota | 46079 | 1534 | 20 |
1806194 | 1806194 | 2021-10-11 | Lake | Tennessee | 47095 | 2000 | 31 |
1800571 | 1800571 | 2021-10-10 | Lake | California | 6033 | 6411 | 97 |
1800647 | 1800647 | 2021-10-10 | Lake | Colorado | 8065 | 972 | 1 |
1800724 | 1800724 | 2021-10-10 | Lake | Florida | 12069 | 53476 | 1120 |
1801019 | 1801019 | 2021-10-10 | Lake | Illinois | 17097 | 78886 | 1143 |
1801118 | 1801118 | 2021-10-10 | Lake | Indiana | 18089 | 65234 | 1183 |
1801654 | 1801654 | 2021-10-10 | Lake | Michigan | 26085 | 869 | 19 |
1801733 | 1801733 | 2021-10-10 | Lake | Minnesota | 27075 | 1030 | 21 |
1802006 | 1802006 | 2021-10-10 | Lake | Montana | 30047 | 3419 | 55 |
1802472 | 1802472 | 2021-10-10 | Lake | Ohio | 39085 | 26029 | 432 |
1802615 | 1802615 | 2021-10-10 | Lake | Oregon | 41037 | 850 | 9 |
1802869 | 1802869 | 2021-10-10 | Lake | South Dakota | 46079 | 1534 | 20 |
1802944 | 1802944 | 2021-10-10 | Lake | Tennessee | 47095 | 1999 | 31 |
1797322 | 1797322 | 2021-10-09 | Lake | California | 6033 | 6411 | 97 |
1797398 | 1797398 | 2021-10-09 | Lake | Colorado | 8065 | 972 | 1 |
1797475 | 1797475 | 2021-10-09 | Lake | Florida | 12069 | 53476 | 1120 |
1797770 | 1797770 | 2021-10-09 | Lake | Illinois | 17097 | 78886 | 1143 |
1797869 | 1797869 | 2021-10-09 | Lake | Indiana | 18089 | 65234 | 1183 |
1798405 | 1798405 | 2021-10-09 | Lake | Michigan | 26085 | 869 | 19 |
1798484 | 1798484 | 2021-10-09 | Lake | Minnesota | 27075 | 1030 | 21 |
1798757 | 1798757 | 2021-10-09 | Lake | Montana | 30047 | 3419 | 55 |
1799223 | 1799223 | 2021-10-09 | Lake | Ohio | 39085 | 25941 | 432 |
1799366 | 1799366 | 2021-10-09 | Lake | Oregon | 41037 | 850 | 9 |
1799620 | 1799620 | 2021-10-09 | Lake | South Dakota | 46079 | 1534 | 20 |
1799695 | 1799695 | 2021-10-09 | Lake | Tennessee | 47095 | 1999 | 31 |
1794073 | 1794073 | 2021-10-08 | Lake | California | 6033 | 6411 | 97 |
1794149 | 1794149 | 2021-10-08 | Lake | Colorado | 8065 | 972 | 1 |
1794226 | 1794226 | 2021-10-08 | Lake | Florida | 12069 | 53476 | 1120 |
1794521 | 1794521 | 2021-10-08 | Lake | Illinois | 17097 | 78886 | 1143 |
1794620 | 1794620 | 2021-10-08 | Lake | Indiana | 18089 | 65234 | 1183 |
1795156 | 1795156 | 2021-10-08 | Lake | Michigan | 26085 | 869 | 19 |
1795235 | 1795235 | 2021-10-08 | Lake | Minnesota | 27075 | 1030 | 21 |
1795508 | 1795508 | 2021-10-08 | Lake | Montana | 30047 | 3419 | 55 |
1795974 | 1795974 | 2021-10-08 | Lake | Ohio | 39085 | 25876 | 432 |
1796117 | 1796117 | 2021-10-08 | Lake | Oregon | 41037 | 850 | 9 |
1796371 | 1796371 | 2021-10-08 | Lake | South Dakota | 46079 | 1534 | 20 |
1796446 | 1796446 | 2021-10-08 | Lake | Tennessee | 47095 | 1999 | 31 |
1790825 | 1790825 | 2021-10-07 | Lake | California | 6033 | 6399 | 97 |
1790901 | 1790901 | 2021-10-07 | Lake | Colorado | 8065 | 969 | 1 |
1790978 | 1790978 | 2021-10-07 | Lake | Florida | 12069 | 52933 | 1120 |
1791273 | 1791273 | 2021-10-07 | Lake | Illinois | 17097 | 78768 | 1143 |
1791372 | 1791372 | 2021-10-07 | Lake | Indiana | 18089 | 65104 | 1179 |
1791907 | 1791907 | 2021-10-07 | Lake | Michigan | 26085 | 847 | 19 |
1791986 | 1791986 | 2021-10-07 | Lake | Minnesota | 27075 | 1026 | 21 |
1792259 | 1792259 | 2021-10-07 | Lake | Montana | 30047 | 3370 | 55 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);