ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Warren" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176816 | 2176816 | 2022-02-02 | Warren | Tennessee | 47177 | 11735 | 154 |
2173562 | 2173562 | 2022-02-01 | Warren | Tennessee | 47177 | 10915 | 154 |
2170310 | 2170310 | 2022-01-31 | Warren | Tennessee | 47177 | 10915 | 154 |
2167056 | 2167056 | 2022-01-30 | Warren | Tennessee | 47177 | 10915 | 154 |
2163801 | 2163801 | 2022-01-29 | Warren | Tennessee | 47177 | 10915 | 154 |
2160546 | 2160546 | 2022-01-28 | Warren | Tennessee | 47177 | 10915 | 154 |
2157290 | 2157290 | 2022-01-27 | Warren | Tennessee | 47177 | 10915 | 154 |
2154037 | 2154037 | 2022-01-26 | Warren | Tennessee | 47177 | 10915 | 154 |
2150785 | 2150785 | 2022-01-25 | Warren | Tennessee | 47177 | 9973 | 154 |
2147533 | 2147533 | 2022-01-24 | Warren | Tennessee | 47177 | 9973 | 154 |
2144279 | 2144279 | 2022-01-23 | Warren | Tennessee | 47177 | 9973 | 154 |
2141024 | 2141024 | 2022-01-22 | Warren | Tennessee | 47177 | 9973 | 154 |
2137768 | 2137768 | 2022-01-21 | Warren | Tennessee | 47177 | 9973 | 154 |
2134514 | 2134514 | 2022-01-20 | Warren | Tennessee | 47177 | 9973 | 154 |
2131262 | 2131262 | 2022-01-19 | Warren | Tennessee | 47177 | 9973 | 154 |
2128008 | 2128008 | 2022-01-18 | Warren | Tennessee | 47177 | 9440 | 153 |
2124756 | 2124756 | 2022-01-17 | Warren | Tennessee | 47177 | 9440 | 153 |
2121504 | 2121504 | 2022-01-16 | Warren | Tennessee | 47177 | 9440 | 153 |
2118252 | 2118252 | 2022-01-15 | Warren | Tennessee | 47177 | 9440 | 153 |
2115001 | 2115001 | 2022-01-14 | Warren | Tennessee | 47177 | 9440 | 153 |
2111749 | 2111749 | 2022-01-13 | Warren | Tennessee | 47177 | 9440 | 153 |
2108497 | 2108497 | 2022-01-12 | Warren | Tennessee | 47177 | 9440 | 153 |
2105246 | 2105246 | 2022-01-11 | Warren | Tennessee | 47177 | 9216 | 152 |
2101995 | 2101995 | 2022-01-10 | Warren | Tennessee | 47177 | 9216 | 152 |
2098744 | 2098744 | 2022-01-09 | Warren | Tennessee | 47177 | 9216 | 152 |
2095492 | 2095492 | 2022-01-08 | Warren | Tennessee | 47177 | 9216 | 152 |
2092240 | 2092240 | 2022-01-07 | Warren | Tennessee | 47177 | 9216 | 152 |
2088988 | 2088988 | 2022-01-06 | Warren | Tennessee | 47177 | 9216 | 152 |
2085737 | 2085737 | 2022-01-05 | Warren | Tennessee | 47177 | 9216 | 152 |
2082485 | 2082485 | 2022-01-04 | Warren | Tennessee | 47177 | 9216 | 152 |
2079233 | 2079233 | 2022-01-03 | Warren | Tennessee | 47177 | 9200 | 152 |
2075982 | 2075982 | 2022-01-02 | Warren | Tennessee | 47177 | 9131 | 152 |
2072731 | 2072731 | 2022-01-01 | Warren | Tennessee | 47177 | 9131 | 152 |
2069480 | 2069480 | 2021-12-31 | Warren | Tennessee | 47177 | 9131 | 152 |
2066229 | 2066229 | 2021-12-30 | Warren | Tennessee | 47177 | 9131 | 152 |
2062979 | 2062979 | 2021-12-29 | Warren | Tennessee | 47177 | 9102 | 150 |
2059729 | 2059729 | 2021-12-28 | Warren | Tennessee | 47177 | 9080 | 150 |
2056480 | 2056480 | 2021-12-27 | Warren | Tennessee | 47177 | 9050 | 148 |
2053231 | 2053231 | 2021-12-26 | Warren | Tennessee | 47177 | 9023 | 145 |
2049981 | 2049981 | 2021-12-25 | Warren | Tennessee | 47177 | 9023 | 145 |
2046731 | 2046731 | 2021-12-24 | Warren | Tennessee | 47177 | 9023 | 145 |
2043481 | 2043481 | 2021-12-23 | Warren | Tennessee | 47177 | 9023 | 145 |
2040232 | 2040232 | 2021-12-22 | Warren | Tennessee | 47177 | 9010 | 135 |
2036982 | 2036982 | 2021-12-21 | Warren | Tennessee | 47177 | 9005 | 135 |
2033732 | 2033732 | 2021-12-20 | Warren | Tennessee | 47177 | 9000 | 135 |
2030482 | 2030482 | 2021-12-19 | Warren | Tennessee | 47177 | 8982 | 135 |
2027231 | 2027231 | 2021-12-18 | Warren | Tennessee | 47177 | 8982 | 135 |
2023980 | 2023980 | 2021-12-17 | Warren | Tennessee | 47177 | 8982 | 135 |
2020729 | 2020729 | 2021-12-16 | Warren | Tennessee | 47177 | 8976 | 135 |
2017478 | 2017478 | 2021-12-15 | Warren | Tennessee | 47177 | 8969 | 135 |
2014228 | 2014228 | 2021-12-14 | Warren | Tennessee | 47177 | 8961 | 134 |
2010977 | 2010977 | 2021-12-13 | Warren | Tennessee | 47177 | 8951 | 133 |
2007726 | 2007726 | 2021-12-12 | Warren | Tennessee | 47177 | 8931 | 133 |
2004475 | 2004475 | 2021-12-11 | Warren | Tennessee | 47177 | 8931 | 133 |
2001224 | 2001224 | 2021-12-10 | Warren | Tennessee | 47177 | 8931 | 133 |
1997974 | 1997974 | 2021-12-09 | Warren | Tennessee | 47177 | 8908 | 133 |
1994723 | 1994723 | 2021-12-08 | Warren | Tennessee | 47177 | 8908 | 133 |
1991472 | 1991472 | 2021-12-07 | Warren | Tennessee | 47177 | 8898 | 133 |
1988221 | 1988221 | 2021-12-06 | Warren | Tennessee | 47177 | 8881 | 132 |
1984971 | 1984971 | 2021-12-05 | Warren | Tennessee | 47177 | 8857 | 132 |
1981721 | 1981721 | 2021-12-04 | Warren | Tennessee | 47177 | 8857 | 132 |
1978471 | 1978471 | 2021-12-03 | Warren | Tennessee | 47177 | 8857 | 132 |
1975221 | 1975221 | 2021-12-02 | Warren | Tennessee | 47177 | 8848 | 132 |
1971972 | 1971972 | 2021-12-01 | Warren | Tennessee | 47177 | 8834 | 132 |
1968722 | 1968722 | 2021-11-30 | Warren | Tennessee | 47177 | 8823 | 131 |
1965471 | 1965471 | 2021-11-29 | Warren | Tennessee | 47177 | 8815 | 130 |
1962219 | 1962219 | 2021-11-28 | Warren | Tennessee | 47177 | 8789 | 130 |
1958968 | 1958968 | 2021-11-27 | Warren | Tennessee | 47177 | 8789 | 130 |
1955717 | 1955717 | 2021-11-26 | Warren | Tennessee | 47177 | 8789 | 130 |
1952466 | 1952466 | 2021-11-25 | Warren | Tennessee | 47177 | 8789 | 130 |
1949215 | 1949215 | 2021-11-24 | Warren | Tennessee | 47177 | 8789 | 130 |
1945964 | 1945964 | 2021-11-23 | Warren | Tennessee | 47177 | 8785 | 128 |
1942713 | 1942713 | 2021-11-22 | Warren | Tennessee | 47177 | 8781 | 128 |
1939463 | 1939463 | 2021-11-21 | Warren | Tennessee | 47177 | 8764 | 128 |
1936213 | 1936213 | 2021-11-20 | Warren | Tennessee | 47177 | 8764 | 128 |
1932963 | 1932963 | 2021-11-19 | Warren | Tennessee | 47177 | 8764 | 128 |
1929712 | 1929712 | 2021-11-18 | Warren | Tennessee | 47177 | 8749 | 125 |
1926462 | 1926462 | 2021-11-17 | Warren | Tennessee | 47177 | 8739 | 125 |
1923212 | 1923212 | 2021-11-16 | Warren | Tennessee | 47177 | 8729 | 125 |
1919963 | 1919963 | 2021-11-15 | Warren | Tennessee | 47177 | 8717 | 125 |
1916713 | 1916713 | 2021-11-14 | Warren | Tennessee | 47177 | 8703 | 125 |
1913463 | 1913463 | 2021-11-13 | Warren | Tennessee | 47177 | 8703 | 125 |
1910213 | 1910213 | 2021-11-12 | Warren | Tennessee | 47177 | 8703 | 125 |
1906964 | 1906964 | 2021-11-11 | Warren | Tennessee | 47177 | 8688 | 125 |
1903715 | 1903715 | 2021-11-10 | Warren | Tennessee | 47177 | 8688 | 125 |
1900465 | 1900465 | 2021-11-09 | Warren | Tennessee | 47177 | 8672 | 125 |
1897215 | 1897215 | 2021-11-08 | Warren | Tennessee | 47177 | 8654 | 122 |
1893965 | 1893965 | 2021-11-07 | Warren | Tennessee | 47177 | 8654 | 122 |
1890715 | 1890715 | 2021-11-06 | Warren | Tennessee | 47177 | 8654 | 122 |
1887465 | 1887465 | 2021-11-05 | Warren | Tennessee | 47177 | 8654 | 122 |
1884215 | 1884215 | 2021-11-04 | Warren | Tennessee | 47177 | 8651 | 122 |
1880966 | 1880966 | 2021-11-03 | Warren | Tennessee | 47177 | 8643 | 122 |
1877717 | 1877717 | 2021-11-02 | Warren | Tennessee | 47177 | 8631 | 121 |
1874468 | 1874468 | 2021-11-01 | Warren | Tennessee | 47177 | 8618 | 121 |
1871219 | 1871219 | 2021-10-31 | Warren | Tennessee | 47177 | 8618 | 121 |
1867970 | 1867970 | 2021-10-30 | Warren | Tennessee | 47177 | 8618 | 121 |
1864721 | 1864721 | 2021-10-29 | Warren | Tennessee | 47177 | 8618 | 121 |
1861472 | 1861472 | 2021-10-28 | Warren | Tennessee | 47177 | 8613 | 121 |
1858223 | 1858223 | 2021-10-27 | Warren | Tennessee | 47177 | 8599 | 121 |
1854974 | 1854974 | 2021-10-26 | Warren | Tennessee | 47177 | 8594 | 120 |
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);