ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Clay" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176740 | 2176740 | 2022-02-02 | Clay | Tennessee | 47027 | 2021 | 44 |
2173486 | 2173486 | 2022-02-01 | Clay | Tennessee | 47027 | 1916 | 44 |
2170234 | 2170234 | 2022-01-31 | Clay | Tennessee | 47027 | 1916 | 44 |
2166980 | 2166980 | 2022-01-30 | Clay | Tennessee | 47027 | 1916 | 44 |
2163725 | 2163725 | 2022-01-29 | Clay | Tennessee | 47027 | 1916 | 44 |
2160470 | 2160470 | 2022-01-28 | Clay | Tennessee | 47027 | 1916 | 44 |
2157214 | 2157214 | 2022-01-27 | Clay | Tennessee | 47027 | 1916 | 44 |
2153961 | 2153961 | 2022-01-26 | Clay | Tennessee | 47027 | 1916 | 44 |
2150709 | 2150709 | 2022-01-25 | Clay | Tennessee | 47027 | 1797 | 43 |
2147457 | 2147457 | 2022-01-24 | Clay | Tennessee | 47027 | 1797 | 43 |
2144203 | 2144203 | 2022-01-23 | Clay | Tennessee | 47027 | 1797 | 43 |
2140948 | 2140948 | 2022-01-22 | Clay | Tennessee | 47027 | 1797 | 43 |
2137692 | 2137692 | 2022-01-21 | Clay | Tennessee | 47027 | 1797 | 43 |
2134438 | 2134438 | 2022-01-20 | Clay | Tennessee | 47027 | 1797 | 43 |
2131186 | 2131186 | 2022-01-19 | Clay | Tennessee | 47027 | 1797 | 43 |
2127932 | 2127932 | 2022-01-18 | Clay | Tennessee | 47027 | 1726 | 42 |
2124680 | 2124680 | 2022-01-17 | Clay | Tennessee | 47027 | 1726 | 42 |
2121428 | 2121428 | 2022-01-16 | Clay | Tennessee | 47027 | 1726 | 42 |
2118176 | 2118176 | 2022-01-15 | Clay | Tennessee | 47027 | 1726 | 42 |
2114925 | 2114925 | 2022-01-14 | Clay | Tennessee | 47027 | 1726 | 42 |
2111673 | 2111673 | 2022-01-13 | Clay | Tennessee | 47027 | 1726 | 42 |
2108421 | 2108421 | 2022-01-12 | Clay | Tennessee | 47027 | 1726 | 42 |
2105170 | 2105170 | 2022-01-11 | Clay | Tennessee | 47027 | 1683 | 40 |
2101919 | 2101919 | 2022-01-10 | Clay | Tennessee | 47027 | 1683 | 40 |
2098668 | 2098668 | 2022-01-09 | Clay | Tennessee | 47027 | 1683 | 40 |
2095416 | 2095416 | 2022-01-08 | Clay | Tennessee | 47027 | 1683 | 40 |
2092164 | 2092164 | 2022-01-07 | Clay | Tennessee | 47027 | 1683 | 40 |
2088912 | 2088912 | 2022-01-06 | Clay | Tennessee | 47027 | 1683 | 40 |
2085661 | 2085661 | 2022-01-05 | Clay | Tennessee | 47027 | 1683 | 40 |
2082409 | 2082409 | 2022-01-04 | Clay | Tennessee | 47027 | 1683 | 40 |
2079157 | 2079157 | 2022-01-03 | Clay | Tennessee | 47027 | 1678 | 40 |
2075906 | 2075906 | 2022-01-02 | Clay | Tennessee | 47027 | 1649 | 40 |
2072655 | 2072655 | 2022-01-01 | Clay | Tennessee | 47027 | 1649 | 40 |
2069404 | 2069404 | 2021-12-31 | Clay | Tennessee | 47027 | 1649 | 40 |
2066153 | 2066153 | 2021-12-30 | Clay | Tennessee | 47027 | 1649 | 40 |
2062903 | 2062903 | 2021-12-29 | Clay | Tennessee | 47027 | 1644 | 40 |
2059653 | 2059653 | 2021-12-28 | Clay | Tennessee | 47027 | 1635 | 39 |
2056404 | 2056404 | 2021-12-27 | Clay | Tennessee | 47027 | 1629 | 39 |
2053155 | 2053155 | 2021-12-26 | Clay | Tennessee | 47027 | 1627 | 39 |
2049905 | 2049905 | 2021-12-25 | Clay | Tennessee | 47027 | 1627 | 39 |
2046655 | 2046655 | 2021-12-24 | Clay | Tennessee | 47027 | 1627 | 39 |
2043405 | 2043405 | 2021-12-23 | Clay | Tennessee | 47027 | 1627 | 39 |
2040156 | 2040156 | 2021-12-22 | Clay | Tennessee | 47027 | 1621 | 37 |
2036906 | 2036906 | 2021-12-21 | Clay | Tennessee | 47027 | 1617 | 37 |
2033656 | 2033656 | 2021-12-20 | Clay | Tennessee | 47027 | 1614 | 37 |
2030406 | 2030406 | 2021-12-19 | Clay | Tennessee | 47027 | 1610 | 37 |
2027155 | 2027155 | 2021-12-18 | Clay | Tennessee | 47027 | 1610 | 37 |
2023904 | 2023904 | 2021-12-17 | Clay | Tennessee | 47027 | 1610 | 37 |
2020653 | 2020653 | 2021-12-16 | Clay | Tennessee | 47027 | 1607 | 37 |
2017402 | 2017402 | 2021-12-15 | Clay | Tennessee | 47027 | 1598 | 37 |
2014152 | 2014152 | 2021-12-14 | Clay | Tennessee | 47027 | 1594 | 37 |
2010901 | 2010901 | 2021-12-13 | Clay | Tennessee | 47027 | 1591 | 37 |
2007650 | 2007650 | 2021-12-12 | Clay | Tennessee | 47027 | 1582 | 37 |
2004399 | 2004399 | 2021-12-11 | Clay | Tennessee | 47027 | 1582 | 37 |
2001148 | 2001148 | 2021-12-10 | Clay | Tennessee | 47027 | 1582 | 37 |
1997898 | 1997898 | 2021-12-09 | Clay | Tennessee | 47027 | 1571 | 37 |
1994647 | 1994647 | 2021-12-08 | Clay | Tennessee | 47027 | 1571 | 37 |
1991396 | 1991396 | 2021-12-07 | Clay | Tennessee | 47027 | 1570 | 37 |
1988145 | 1988145 | 2021-12-06 | Clay | Tennessee | 47027 | 1565 | 37 |
1984895 | 1984895 | 2021-12-05 | Clay | Tennessee | 47027 | 1559 | 37 |
1981645 | 1981645 | 2021-12-04 | Clay | Tennessee | 47027 | 1559 | 37 |
1978395 | 1978395 | 2021-12-03 | Clay | Tennessee | 47027 | 1559 | 37 |
1975145 | 1975145 | 2021-12-02 | Clay | Tennessee | 47027 | 1556 | 37 |
1971896 | 1971896 | 2021-12-01 | Clay | Tennessee | 47027 | 1554 | 37 |
1968646 | 1968646 | 2021-11-30 | Clay | Tennessee | 47027 | 1554 | 37 |
1965395 | 1965395 | 2021-11-29 | Clay | Tennessee | 47027 | 1550 | 37 |
1962143 | 1962143 | 2021-11-28 | Clay | Tennessee | 47027 | 1548 | 37 |
1958892 | 1958892 | 2021-11-27 | Clay | Tennessee | 47027 | 1548 | 37 |
1955641 | 1955641 | 2021-11-26 | Clay | Tennessee | 47027 | 1548 | 37 |
1952390 | 1952390 | 2021-11-25 | Clay | Tennessee | 47027 | 1548 | 37 |
1949139 | 1949139 | 2021-11-24 | Clay | Tennessee | 47027 | 1548 | 37 |
1945888 | 1945888 | 2021-11-23 | Clay | Tennessee | 47027 | 1548 | 37 |
1942637 | 1942637 | 2021-11-22 | Clay | Tennessee | 47027 | 1548 | 37 |
1939387 | 1939387 | 2021-11-21 | Clay | Tennessee | 47027 | 1547 | 37 |
1936137 | 1936137 | 2021-11-20 | Clay | Tennessee | 47027 | 1547 | 37 |
1932887 | 1932887 | 2021-11-19 | Clay | Tennessee | 47027 | 1547 | 37 |
1929636 | 1929636 | 2021-11-18 | Clay | Tennessee | 47027 | 1544 | 37 |
1926386 | 1926386 | 2021-11-17 | Clay | Tennessee | 47027 | 1544 | 37 |
1923136 | 1923136 | 2021-11-16 | Clay | Tennessee | 47027 | 1543 | 37 |
1919887 | 1919887 | 2021-11-15 | Clay | Tennessee | 47027 | 1543 | 37 |
1916637 | 1916637 | 2021-11-14 | Clay | Tennessee | 47027 | 1542 | 37 |
1913387 | 1913387 | 2021-11-13 | Clay | Tennessee | 47027 | 1542 | 37 |
1910137 | 1910137 | 2021-11-12 | Clay | Tennessee | 47027 | 1542 | 37 |
1906888 | 1906888 | 2021-11-11 | Clay | Tennessee | 47027 | 1541 | 37 |
1903639 | 1903639 | 2021-11-10 | Clay | Tennessee | 47027 | 1541 | 37 |
1900389 | 1900389 | 2021-11-09 | Clay | Tennessee | 47027 | 1540 | 37 |
1897139 | 1897139 | 2021-11-08 | Clay | Tennessee | 47027 | 1537 | 37 |
1893889 | 1893889 | 2021-11-07 | Clay | Tennessee | 47027 | 1537 | 37 |
1890639 | 1890639 | 2021-11-06 | Clay | Tennessee | 47027 | 1537 | 37 |
1887389 | 1887389 | 2021-11-05 | Clay | Tennessee | 47027 | 1537 | 37 |
1884139 | 1884139 | 2021-11-04 | Clay | Tennessee | 47027 | 1536 | 37 |
1880890 | 1880890 | 2021-11-03 | Clay | Tennessee | 47027 | 1531 | 37 |
1877641 | 1877641 | 2021-11-02 | Clay | Tennessee | 47027 | 1531 | 37 |
1874392 | 1874392 | 2021-11-01 | Clay | Tennessee | 47027 | 1530 | 37 |
1871143 | 1871143 | 2021-10-31 | Clay | Tennessee | 47027 | 1530 | 37 |
1867894 | 1867894 | 2021-10-30 | Clay | Tennessee | 47027 | 1530 | 37 |
1864645 | 1864645 | 2021-10-29 | Clay | Tennessee | 47027 | 1530 | 37 |
1861396 | 1861396 | 2021-10-28 | Clay | Tennessee | 47027 | 1531 | 37 |
1858147 | 1858147 | 2021-10-27 | Clay | Tennessee | 47027 | 1529 | 37 |
1854898 | 1854898 | 2021-10-26 | Clay | Tennessee | 47027 | 1528 | 37 |
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);