ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
233 rows where deaths = 42 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2127932 | 2127932 | 2022-01-18 | Clay | Tennessee | 47027 | 1726 | 42 |
2127986 | 2127986 | 2022-01-18 | Perry | Tennessee | 47135 | 1774 | 42 |
2124680 | 2124680 | 2022-01-17 | Clay | Tennessee | 47027 | 1726 | 42 |
2124734 | 2124734 | 2022-01-17 | Perry | Tennessee | 47135 | 1774 | 42 |
2121428 | 2121428 | 2022-01-16 | Clay | Tennessee | 47027 | 1726 | 42 |
2121482 | 2121482 | 2022-01-16 | Perry | Tennessee | 47135 | 1774 | 42 |
2118176 | 2118176 | 2022-01-15 | Clay | Tennessee | 47027 | 1726 | 42 |
2118230 | 2118230 | 2022-01-15 | Perry | Tennessee | 47135 | 1774 | 42 |
2114925 | 2114925 | 2022-01-14 | Clay | Tennessee | 47027 | 1726 | 42 |
2114979 | 2114979 | 2022-01-14 | Perry | Tennessee | 47135 | 1774 | 42 |
2111673 | 2111673 | 2022-01-13 | Clay | Tennessee | 47027 | 1726 | 42 |
2111727 | 2111727 | 2022-01-13 | Perry | Tennessee | 47135 | 1774 | 42 |
2108421 | 2108421 | 2022-01-12 | Clay | Tennessee | 47027 | 1726 | 42 |
2108475 | 2108475 | 2022-01-12 | Perry | Tennessee | 47135 | 1774 | 42 |
2030469 | 2030469 | 2021-12-19 | Sequatchie | Tennessee | 47153 | 3122 | 42 |
2027218 | 2027218 | 2021-12-18 | Sequatchie | Tennessee | 47153 | 3122 | 42 |
2023967 | 2023967 | 2021-12-17 | Sequatchie | Tennessee | 47153 | 3122 | 42 |
2017480 | 2017480 | 2021-12-15 | Wayne | Tennessee | 47181 | 4207 | 42 |
1984925 | 1984925 | 2021-12-05 | Jackson | Tennessee | 47087 | 2121 | 42 |
1981675 | 1981675 | 2021-12-04 | Jackson | Tennessee | 47087 | 2121 | 42 |
1978425 | 1978425 | 2021-12-03 | Jackson | Tennessee | 47087 | 2121 | 42 |
1971913 | 1971913 | 2021-12-01 | Grundy | Tennessee | 47061 | 2937 | 42 |
1968663 | 1968663 | 2021-11-30 | Grundy | Tennessee | 47061 | 2933 | 42 |
1968683 | 1968683 | 2021-11-30 | Lewis | Tennessee | 47101 | 2570 | 42 |
1965412 | 1965412 | 2021-11-29 | Grundy | Tennessee | 47061 | 2929 | 42 |
1962160 | 1962160 | 2021-11-28 | Grundy | Tennessee | 47061 | 2928 | 42 |
1958909 | 1958909 | 2021-11-27 | Grundy | Tennessee | 47061 | 2928 | 42 |
1955658 | 1955658 | 2021-11-26 | Grundy | Tennessee | 47061 | 2928 | 42 |
1952407 | 1952407 | 2021-11-25 | Grundy | Tennessee | 47061 | 2928 | 42 |
1949156 | 1949156 | 2021-11-24 | Grundy | Tennessee | 47061 | 2928 | 42 |
1945905 | 1945905 | 2021-11-23 | Grundy | Tennessee | 47061 | 2927 | 42 |
1854892 | 1854892 | 2021-10-26 | Cannon | Tennessee | 47015 | 2795 | 42 |
1851643 | 1851643 | 2021-10-25 | Cannon | Tennessee | 47015 | 2786 | 42 |
1848393 | 1848393 | 2021-10-24 | Cannon | Tennessee | 47015 | 2786 | 42 |
1845143 | 1845143 | 2021-10-23 | Cannon | Tennessee | 47015 | 2786 | 42 |
1841893 | 1841893 | 2021-10-22 | Cannon | Tennessee | 47015 | 2786 | 42 |
1812732 | 1812732 | 2021-10-13 | Union | Tennessee | 47173 | 3010 | 42 |
1809483 | 1809483 | 2021-10-12 | Union | Tennessee | 47173 | 3001 | 42 |
1806233 | 1806233 | 2021-10-11 | Union | Tennessee | 47173 | 2984 | 42 |
1802983 | 1802983 | 2021-10-10 | Union | Tennessee | 47173 | 2947 | 42 |
1799734 | 1799734 | 2021-10-09 | Union | Tennessee | 47173 | 2947 | 42 |
1796485 | 1796485 | 2021-10-08 | Union | Tennessee | 47173 | 2947 | 42 |
1793236 | 1793236 | 2021-10-07 | Union | Tennessee | 47173 | 2925 | 42 |
1789921 | 1789921 | 2021-10-06 | Decatur | Tennessee | 47039 | 2370 | 42 |
1789987 | 1789987 | 2021-10-06 | Union | Tennessee | 47173 | 2920 | 42 |
1786673 | 1786673 | 2021-10-05 | Decatur | Tennessee | 47039 | 2359 | 42 |
1786694 | 1786694 | 2021-10-05 | Houston | Tennessee | 47083 | 1794 | 42 |
1786739 | 1786739 | 2021-10-05 | Union | Tennessee | 47173 | 2916 | 42 |
1783424 | 1783424 | 2021-10-04 | Decatur | Tennessee | 47039 | 2357 | 42 |
1783490 | 1783490 | 2021-10-04 | Union | Tennessee | 47173 | 2913 | 42 |
1780175 | 1780175 | 2021-10-03 | Decatur | Tennessee | 47039 | 2337 | 42 |
1780241 | 1780241 | 2021-10-03 | Union | Tennessee | 47173 | 2893 | 42 |
1776925 | 1776925 | 2021-10-02 | Decatur | Tennessee | 47039 | 2337 | 42 |
1776991 | 1776991 | 2021-10-02 | Union | Tennessee | 47173 | 2893 | 42 |
1773675 | 1773675 | 2021-10-01 | Decatur | Tennessee | 47039 | 2337 | 42 |
1773741 | 1773741 | 2021-10-01 | Union | Tennessee | 47173 | 2893 | 42 |
1770425 | 1770425 | 2021-09-30 | Decatur | Tennessee | 47039 | 2336 | 42 |
1770491 | 1770491 | 2021-09-30 | Union | Tennessee | 47173 | 2871 | 42 |
1767176 | 1767176 | 2021-09-29 | Decatur | Tennessee | 47039 | 2332 | 42 |
1767242 | 1767242 | 2021-09-29 | Union | Tennessee | 47173 | 2846 | 42 |
1763927 | 1763927 | 2021-09-28 | Decatur | Tennessee | 47039 | 2316 | 42 |
1763993 | 1763993 | 2021-09-28 | Union | Tennessee | 47173 | 2830 | 42 |
1760678 | 1760678 | 2021-09-27 | Decatur | Tennessee | 47039 | 2312 | 42 |
1760744 | 1760744 | 2021-09-27 | Union | Tennessee | 47173 | 2808 | 42 |
1757430 | 1757430 | 2021-09-26 | Decatur | Tennessee | 47039 | 2299 | 42 |
1754182 | 1754182 | 2021-09-25 | Decatur | Tennessee | 47039 | 2299 | 42 |
1750934 | 1750934 | 2021-09-24 | Decatur | Tennessee | 47039 | 2299 | 42 |
1747685 | 1747685 | 2021-09-23 | Decatur | Tennessee | 47039 | 2286 | 42 |
1744435 | 1744435 | 2021-09-22 | Decatur | Tennessee | 47039 | 2284 | 42 |
1744457 | 1744457 | 2021-09-22 | Humphreys | Tennessee | 47085 | 2882 | 42 |
1744479 | 1744479 | 2021-09-22 | Morgan | Tennessee | 47129 | 3458 | 42 |
1741230 | 1741230 | 2021-09-21 | Morgan | Tennessee | 47129 | 3422 | 42 |
1737981 | 1737981 | 2021-09-20 | Morgan | Tennessee | 47129 | 3422 | 42 |
1721748 | 1721748 | 2021-09-15 | Smith | Tennessee | 47159 | 3842 | 42 |
1718500 | 1718500 | 2021-09-14 | Smith | Tennessee | 47159 | 3801 | 42 |
1715252 | 1715252 | 2021-09-13 | Smith | Tennessee | 47159 | 3782 | 42 |
1712006 | 1712006 | 2021-09-12 | Smith | Tennessee | 47159 | 3694 | 42 |
1708759 | 1708759 | 2021-09-11 | Smith | Tennessee | 47159 | 3694 | 42 |
1705512 | 1705512 | 2021-09-10 | Smith | Tennessee | 47159 | 3694 | 42 |
1702262 | 1702262 | 2021-09-09 | Smith | Tennessee | 47159 | 3665 | 42 |
1699013 | 1699013 | 2021-09-08 | Smith | Tennessee | 47159 | 3642 | 42 |
1672945 | 1672945 | 2021-08-31 | Benton | Tennessee | 47005 | 2076 | 42 |
1669697 | 1669697 | 2021-08-30 | Benton | Tennessee | 47005 | 2057 | 42 |
1666450 | 1666450 | 2021-08-29 | Benton | Tennessee | 47005 | 2024 | 42 |
1663202 | 1663202 | 2021-08-28 | Benton | Tennessee | 47005 | 2024 | 42 |
1659954 | 1659954 | 2021-08-27 | Benton | Tennessee | 47005 | 2024 | 42 |
1656705 | 1656705 | 2021-08-26 | Benton | Tennessee | 47005 | 2014 | 42 |
1419657 | 1419657 | 2021-06-14 | Benton | Tennessee | 47005 | 1687 | 42 |
1416412 | 1416412 | 2021-06-13 | Benton | Tennessee | 47005 | 1687 | 42 |
1413166 | 1413166 | 2021-06-12 | Benton | Tennessee | 47005 | 1687 | 42 |
1409921 | 1409921 | 2021-06-11 | Benton | Tennessee | 47005 | 1687 | 42 |
1406676 | 1406676 | 2021-06-10 | Benton | Tennessee | 47005 | 1684 | 42 |
1403430 | 1403430 | 2021-06-09 | Benton | Tennessee | 47005 | 1683 | 42 |
1400185 | 1400185 | 2021-06-08 | Benton | Tennessee | 47005 | 1685 | 42 |
1396940 | 1396940 | 2021-06-07 | Benton | Tennessee | 47005 | 1684 | 42 |
1393693 | 1393693 | 2021-06-06 | Benton | Tennessee | 47005 | 1684 | 42 |
1390448 | 1390448 | 2021-06-05 | Benton | Tennessee | 47005 | 1684 | 42 |
1387203 | 1387203 | 2021-06-04 | Benton | Tennessee | 47005 | 1684 | 42 |
1383958 | 1383958 | 2021-06-03 | Benton | Tennessee | 47005 | 1682 | 42 |
1380712 | 1380712 | 2021-06-02 | Benton | Tennessee | 47005 | 1682 | 42 |
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);