ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 47167 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176810 | 2176810 | 2022-02-02 | Tipton | Tennessee | 47167 | 16628 | 192 |
2173556 | 2173556 | 2022-02-01 | Tipton | Tennessee | 47167 | 15921 | 191 |
2170304 | 2170304 | 2022-01-31 | Tipton | Tennessee | 47167 | 15921 | 191 |
2167050 | 2167050 | 2022-01-30 | Tipton | Tennessee | 47167 | 15921 | 191 |
2163795 | 2163795 | 2022-01-29 | Tipton | Tennessee | 47167 | 15921 | 191 |
2160540 | 2160540 | 2022-01-28 | Tipton | Tennessee | 47167 | 15921 | 191 |
2157284 | 2157284 | 2022-01-27 | Tipton | Tennessee | 47167 | 15921 | 191 |
2154031 | 2154031 | 2022-01-26 | Tipton | Tennessee | 47167 | 15921 | 191 |
2150779 | 2150779 | 2022-01-25 | Tipton | Tennessee | 47167 | 15144 | 186 |
2147527 | 2147527 | 2022-01-24 | Tipton | Tennessee | 47167 | 15144 | 186 |
2144273 | 2144273 | 2022-01-23 | Tipton | Tennessee | 47167 | 15144 | 186 |
2141018 | 2141018 | 2022-01-22 | Tipton | Tennessee | 47167 | 15144 | 186 |
2137762 | 2137762 | 2022-01-21 | Tipton | Tennessee | 47167 | 15144 | 186 |
2134508 | 2134508 | 2022-01-20 | Tipton | Tennessee | 47167 | 15144 | 186 |
2131256 | 2131256 | 2022-01-19 | Tipton | Tennessee | 47167 | 15144 | 186 |
2128002 | 2128002 | 2022-01-18 | Tipton | Tennessee | 47167 | 14231 | 179 |
2124750 | 2124750 | 2022-01-17 | Tipton | Tennessee | 47167 | 14231 | 179 |
2121498 | 2121498 | 2022-01-16 | Tipton | Tennessee | 47167 | 14231 | 179 |
2118246 | 2118246 | 2022-01-15 | Tipton | Tennessee | 47167 | 14231 | 179 |
2114995 | 2114995 | 2022-01-14 | Tipton | Tennessee | 47167 | 14231 | 179 |
2111743 | 2111743 | 2022-01-13 | Tipton | Tennessee | 47167 | 14231 | 179 |
2108491 | 2108491 | 2022-01-12 | Tipton | Tennessee | 47167 | 14231 | 179 |
2105240 | 2105240 | 2022-01-11 | Tipton | Tennessee | 47167 | 13413 | 179 |
2101989 | 2101989 | 2022-01-10 | Tipton | Tennessee | 47167 | 13413 | 179 |
2098738 | 2098738 | 2022-01-09 | Tipton | Tennessee | 47167 | 13413 | 179 |
2095486 | 2095486 | 2022-01-08 | Tipton | Tennessee | 47167 | 13413 | 179 |
2092234 | 2092234 | 2022-01-07 | Tipton | Tennessee | 47167 | 13413 | 179 |
2088982 | 2088982 | 2022-01-06 | Tipton | Tennessee | 47167 | 13413 | 179 |
2085731 | 2085731 | 2022-01-05 | Tipton | Tennessee | 47167 | 13413 | 179 |
2082479 | 2082479 | 2022-01-04 | Tipton | Tennessee | 47167 | 13413 | 179 |
2079227 | 2079227 | 2022-01-03 | Tipton | Tennessee | 47167 | 13296 | 179 |
2075976 | 2075976 | 2022-01-02 | Tipton | Tennessee | 47167 | 12806 | 179 |
2072725 | 2072725 | 2022-01-01 | Tipton | Tennessee | 47167 | 12806 | 179 |
2069474 | 2069474 | 2021-12-31 | Tipton | Tennessee | 47167 | 12806 | 179 |
2066223 | 2066223 | 2021-12-30 | Tipton | Tennessee | 47167 | 12806 | 179 |
2062973 | 2062973 | 2021-12-29 | Tipton | Tennessee | 47167 | 12592 | 179 |
2059723 | 2059723 | 2021-12-28 | Tipton | Tennessee | 47167 | 12436 | 179 |
2056474 | 2056474 | 2021-12-27 | Tipton | Tennessee | 47167 | 12314 | 179 |
2053225 | 2053225 | 2021-12-26 | Tipton | Tennessee | 47167 | 12138 | 177 |
2049975 | 2049975 | 2021-12-25 | Tipton | Tennessee | 47167 | 12138 | 177 |
2046725 | 2046725 | 2021-12-24 | Tipton | Tennessee | 47167 | 12138 | 177 |
2043475 | 2043475 | 2021-12-23 | Tipton | Tennessee | 47167 | 12138 | 177 |
2040226 | 2040226 | 2021-12-22 | Tipton | Tennessee | 47167 | 12072 | 154 |
2036976 | 2036976 | 2021-12-21 | Tipton | Tennessee | 47167 | 12034 | 154 |
2033726 | 2033726 | 2021-12-20 | Tipton | Tennessee | 47167 | 12018 | 154 |
2030476 | 2030476 | 2021-12-19 | Tipton | Tennessee | 47167 | 11969 | 154 |
2027225 | 2027225 | 2021-12-18 | Tipton | Tennessee | 47167 | 11969 | 154 |
2023974 | 2023974 | 2021-12-17 | Tipton | Tennessee | 47167 | 11969 | 154 |
2020723 | 2020723 | 2021-12-16 | Tipton | Tennessee | 47167 | 11946 | 154 |
2017472 | 2017472 | 2021-12-15 | Tipton | Tennessee | 47167 | 11934 | 154 |
2014222 | 2014222 | 2021-12-14 | Tipton | Tennessee | 47167 | 11908 | 152 |
2010971 | 2010971 | 2021-12-13 | Tipton | Tennessee | 47167 | 11900 | 150 |
2007720 | 2007720 | 2021-12-12 | Tipton | Tennessee | 47167 | 11867 | 150 |
2004469 | 2004469 | 2021-12-11 | Tipton | Tennessee | 47167 | 11867 | 150 |
2001218 | 2001218 | 2021-12-10 | Tipton | Tennessee | 47167 | 11867 | 150 |
1997968 | 1997968 | 2021-12-09 | Tipton | Tennessee | 47167 | 11827 | 150 |
1994717 | 1994717 | 2021-12-08 | Tipton | Tennessee | 47167 | 11827 | 150 |
1991466 | 1991466 | 2021-12-07 | Tipton | Tennessee | 47167 | 11811 | 150 |
1988215 | 1988215 | 2021-12-06 | Tipton | Tennessee | 47167 | 11791 | 146 |
1984965 | 1984965 | 2021-12-05 | Tipton | Tennessee | 47167 | 11754 | 145 |
1981715 | 1981715 | 2021-12-04 | Tipton | Tennessee | 47167 | 11754 | 145 |
1978465 | 1978465 | 2021-12-03 | Tipton | Tennessee | 47167 | 11754 | 145 |
1975215 | 1975215 | 2021-12-02 | Tipton | Tennessee | 47167 | 11742 | 143 |
1971966 | 1971966 | 2021-12-01 | Tipton | Tennessee | 47167 | 11723 | 143 |
1968716 | 1968716 | 2021-11-30 | Tipton | Tennessee | 47167 | 11700 | 142 |
1965465 | 1965465 | 2021-11-29 | Tipton | Tennessee | 47167 | 11679 | 141 |
1962213 | 1962213 | 2021-11-28 | Tipton | Tennessee | 47167 | 11637 | 141 |
1958962 | 1958962 | 2021-11-27 | Tipton | Tennessee | 47167 | 11637 | 141 |
1955711 | 1955711 | 2021-11-26 | Tipton | Tennessee | 47167 | 11637 | 141 |
1952460 | 1952460 | 2021-11-25 | Tipton | Tennessee | 47167 | 11637 | 141 |
1949209 | 1949209 | 2021-11-24 | Tipton | Tennessee | 47167 | 11637 | 141 |
1945958 | 1945958 | 2021-11-23 | Tipton | Tennessee | 47167 | 11634 | 141 |
1942707 | 1942707 | 2021-11-22 | Tipton | Tennessee | 47167 | 11625 | 140 |
1939457 | 1939457 | 2021-11-21 | Tipton | Tennessee | 47167 | 11593 | 140 |
1936207 | 1936207 | 2021-11-20 | Tipton | Tennessee | 47167 | 11593 | 140 |
1932957 | 1932957 | 2021-11-19 | Tipton | Tennessee | 47167 | 11593 | 140 |
1929706 | 1929706 | 2021-11-18 | Tipton | Tennessee | 47167 | 11575 | 140 |
1926456 | 1926456 | 2021-11-17 | Tipton | Tennessee | 47167 | 11545 | 140 |
1923206 | 1923206 | 2021-11-16 | Tipton | Tennessee | 47167 | 11528 | 140 |
1919957 | 1919957 | 2021-11-15 | Tipton | Tennessee | 47167 | 11500 | 138 |
1916707 | 1916707 | 2021-11-14 | Tipton | Tennessee | 47167 | 11469 | 138 |
1913457 | 1913457 | 2021-11-13 | Tipton | Tennessee | 47167 | 11469 | 138 |
1910207 | 1910207 | 2021-11-12 | Tipton | Tennessee | 47167 | 11469 | 138 |
1906958 | 1906958 | 2021-11-11 | Tipton | Tennessee | 47167 | 11446 | 138 |
1903709 | 1903709 | 2021-11-10 | Tipton | Tennessee | 47167 | 11446 | 138 |
1900459 | 1900459 | 2021-11-09 | Tipton | Tennessee | 47167 | 11437 | 138 |
1897209 | 1897209 | 2021-11-08 | Tipton | Tennessee | 47167 | 11403 | 136 |
1893959 | 1893959 | 2021-11-07 | Tipton | Tennessee | 47167 | 11403 | 136 |
1890709 | 1890709 | 2021-11-06 | Tipton | Tennessee | 47167 | 11403 | 136 |
1887459 | 1887459 | 2021-11-05 | Tipton | Tennessee | 47167 | 11403 | 136 |
1884209 | 1884209 | 2021-11-04 | Tipton | Tennessee | 47167 | 11392 | 136 |
1880960 | 1880960 | 2021-11-03 | Tipton | Tennessee | 47167 | 11386 | 130 |
1877711 | 1877711 | 2021-11-02 | Tipton | Tennessee | 47167 | 11379 | 130 |
1874462 | 1874462 | 2021-11-01 | Tipton | Tennessee | 47167 | 11350 | 130 |
1871213 | 1871213 | 2021-10-31 | Tipton | Tennessee | 47167 | 11350 | 130 |
1867964 | 1867964 | 2021-10-30 | Tipton | Tennessee | 47167 | 11350 | 130 |
1864715 | 1864715 | 2021-10-29 | Tipton | Tennessee | 47167 | 11350 | 130 |
1861466 | 1861466 | 2021-10-28 | Tipton | Tennessee | 47167 | 11341 | 128 |
1858217 | 1858217 | 2021-10-27 | Tipton | Tennessee | 47167 | 11331 | 128 |
1854968 | 1854968 | 2021-10-26 | Tipton | Tennessee | 47167 | 11324 | 128 |
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);