ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where fips = 47097 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2111708 | 2111708 | 2022-01-13 | Lauderdale | Tennessee | 47097 | 5887 | 79 |
2108456 | 2108456 | 2022-01-12 | Lauderdale | Tennessee | 47097 | 5887 | 79 |
2105205 | 2105205 | 2022-01-11 | Lauderdale | Tennessee | 47097 | 5585 | 79 |
2101954 | 2101954 | 2022-01-10 | Lauderdale | Tennessee | 47097 | 5585 | 79 |
2098703 | 2098703 | 2022-01-09 | Lauderdale | Tennessee | 47097 | 5585 | 79 |
2095451 | 2095451 | 2022-01-08 | Lauderdale | Tennessee | 47097 | 5585 | 79 |
2092199 | 2092199 | 2022-01-07 | Lauderdale | Tennessee | 47097 | 5585 | 79 |
2088947 | 2088947 | 2022-01-06 | Lauderdale | Tennessee | 47097 | 5585 | 79 |
2085696 | 2085696 | 2022-01-05 | Lauderdale | Tennessee | 47097 | 5585 | 79 |
2082444 | 2082444 | 2022-01-04 | Lauderdale | Tennessee | 47097 | 5585 | 79 |
2079192 | 2079192 | 2022-01-03 | Lauderdale | Tennessee | 47097 | 5536 | 79 |
2075941 | 2075941 | 2022-01-02 | Lauderdale | Tennessee | 47097 | 5410 | 79 |
2072690 | 2072690 | 2022-01-01 | Lauderdale | Tennessee | 47097 | 5410 | 79 |
2069439 | 2069439 | 2021-12-31 | Lauderdale | Tennessee | 47097 | 5410 | 79 |
2066188 | 2066188 | 2021-12-30 | Lauderdale | Tennessee | 47097 | 5410 | 79 |
2062938 | 2062938 | 2021-12-29 | Lauderdale | Tennessee | 47097 | 5381 | 79 |
2059688 | 2059688 | 2021-12-28 | Lauderdale | Tennessee | 47097 | 5358 | 79 |
2056439 | 2056439 | 2021-12-27 | Lauderdale | Tennessee | 47097 | 5343 | 79 |
2053190 | 2053190 | 2021-12-26 | Lauderdale | Tennessee | 47097 | 5329 | 79 |
2049940 | 2049940 | 2021-12-25 | Lauderdale | Tennessee | 47097 | 5329 | 79 |
2046690 | 2046690 | 2021-12-24 | Lauderdale | Tennessee | 47097 | 5329 | 79 |
2043440 | 2043440 | 2021-12-23 | Lauderdale | Tennessee | 47097 | 5329 | 79 |
2040191 | 2040191 | 2021-12-22 | Lauderdale | Tennessee | 47097 | 5317 | 75 |
2036941 | 2036941 | 2021-12-21 | Lauderdale | Tennessee | 47097 | 5313 | 75 |
2033691 | 2033691 | 2021-12-20 | Lauderdale | Tennessee | 47097 | 5311 | 74 |
2030441 | 2030441 | 2021-12-19 | Lauderdale | Tennessee | 47097 | 5302 | 74 |
2027190 | 2027190 | 2021-12-18 | Lauderdale | Tennessee | 47097 | 5302 | 74 |
2023939 | 2023939 | 2021-12-17 | Lauderdale | Tennessee | 47097 | 5302 | 74 |
2020688 | 2020688 | 2021-12-16 | Lauderdale | Tennessee | 47097 | 5303 | 73 |
2017437 | 2017437 | 2021-12-15 | Lauderdale | Tennessee | 47097 | 5299 | 73 |
2014187 | 2014187 | 2021-12-14 | Lauderdale | Tennessee | 47097 | 5293 | 73 |
2010936 | 2010936 | 2021-12-13 | Lauderdale | Tennessee | 47097 | 5291 | 73 |
2007685 | 2007685 | 2021-12-12 | Lauderdale | Tennessee | 47097 | 5287 | 73 |
2004434 | 2004434 | 2021-12-11 | Lauderdale | Tennessee | 47097 | 5287 | 73 |
2001183 | 2001183 | 2021-12-10 | Lauderdale | Tennessee | 47097 | 5287 | 73 |
1997933 | 1997933 | 2021-12-09 | Lauderdale | Tennessee | 47097 | 5276 | 72 |
1994682 | 1994682 | 2021-12-08 | Lauderdale | Tennessee | 47097 | 5276 | 72 |
1991431 | 1991431 | 2021-12-07 | Lauderdale | Tennessee | 47097 | 5275 | 72 |
1988180 | 1988180 | 2021-12-06 | Lauderdale | Tennessee | 47097 | 5273 | 72 |
1984930 | 1984930 | 2021-12-05 | Lauderdale | Tennessee | 47097 | 5269 | 72 |
1981680 | 1981680 | 2021-12-04 | Lauderdale | Tennessee | 47097 | 5269 | 72 |
1978430 | 1978430 | 2021-12-03 | Lauderdale | Tennessee | 47097 | 5269 | 72 |
1975180 | 1975180 | 2021-12-02 | Lauderdale | Tennessee | 47097 | 5267 | 72 |
1971931 | 1971931 | 2021-12-01 | Lauderdale | Tennessee | 47097 | 5266 | 71 |
1968681 | 1968681 | 2021-11-30 | Lauderdale | Tennessee | 47097 | 5264 | 70 |
1965430 | 1965430 | 2021-11-29 | Lauderdale | Tennessee | 47097 | 5263 | 70 |
1962178 | 1962178 | 2021-11-28 | Lauderdale | Tennessee | 47097 | 5258 | 69 |
1958927 | 1958927 | 2021-11-27 | Lauderdale | Tennessee | 47097 | 5258 | 69 |
1955676 | 1955676 | 2021-11-26 | Lauderdale | Tennessee | 47097 | 5258 | 69 |
1952425 | 1952425 | 2021-11-25 | Lauderdale | Tennessee | 47097 | 5258 | 69 |
1949174 | 1949174 | 2021-11-24 | Lauderdale | Tennessee | 47097 | 5258 | 69 |
1945923 | 1945923 | 2021-11-23 | Lauderdale | Tennessee | 47097 | 5258 | 69 |
1942672 | 1942672 | 2021-11-22 | Lauderdale | Tennessee | 47097 | 5253 | 69 |
1939422 | 1939422 | 2021-11-21 | Lauderdale | Tennessee | 47097 | 5248 | 69 |
1936172 | 1936172 | 2021-11-20 | Lauderdale | Tennessee | 47097 | 5248 | 69 |
1932922 | 1932922 | 2021-11-19 | Lauderdale | Tennessee | 47097 | 5248 | 69 |
1929671 | 1929671 | 2021-11-18 | Lauderdale | Tennessee | 47097 | 5248 | 69 |
1926421 | 1926421 | 2021-11-17 | Lauderdale | Tennessee | 47097 | 5247 | 69 |
1923171 | 1923171 | 2021-11-16 | Lauderdale | Tennessee | 47097 | 5245 | 69 |
1919922 | 1919922 | 2021-11-15 | Lauderdale | Tennessee | 47097 | 5241 | 69 |
1916672 | 1916672 | 2021-11-14 | Lauderdale | Tennessee | 47097 | 5236 | 68 |
1913422 | 1913422 | 2021-11-13 | Lauderdale | Tennessee | 47097 | 5236 | 68 |
1910172 | 1910172 | 2021-11-12 | Lauderdale | Tennessee | 47097 | 5236 | 68 |
1906923 | 1906923 | 2021-11-11 | Lauderdale | Tennessee | 47097 | 5232 | 68 |
1903674 | 1903674 | 2021-11-10 | Lauderdale | Tennessee | 47097 | 5232 | 68 |
1900424 | 1900424 | 2021-11-09 | Lauderdale | Tennessee | 47097 | 5226 | 68 |
1897174 | 1897174 | 2021-11-08 | Lauderdale | Tennessee | 47097 | 5218 | 67 |
1893924 | 1893924 | 2021-11-07 | Lauderdale | Tennessee | 47097 | 5218 | 67 |
1890674 | 1890674 | 2021-11-06 | Lauderdale | Tennessee | 47097 | 5218 | 67 |
1887424 | 1887424 | 2021-11-05 | Lauderdale | Tennessee | 47097 | 5218 | 67 |
1884174 | 1884174 | 2021-11-04 | Lauderdale | Tennessee | 47097 | 5214 | 67 |
1880925 | 1880925 | 2021-11-03 | Lauderdale | Tennessee | 47097 | 5213 | 66 |
1877676 | 1877676 | 2021-11-02 | Lauderdale | Tennessee | 47097 | 5212 | 66 |
1874427 | 1874427 | 2021-11-01 | Lauderdale | Tennessee | 47097 | 5206 | 66 |
1871178 | 1871178 | 2021-10-31 | Lauderdale | Tennessee | 47097 | 5206 | 66 |
1867929 | 1867929 | 2021-10-30 | Lauderdale | Tennessee | 47097 | 5206 | 66 |
1864680 | 1864680 | 2021-10-29 | Lauderdale | Tennessee | 47097 | 5206 | 66 |
1861431 | 1861431 | 2021-10-28 | Lauderdale | Tennessee | 47097 | 5204 | 66 |
1858182 | 1858182 | 2021-10-27 | Lauderdale | Tennessee | 47097 | 5202 | 66 |
1854933 | 1854933 | 2021-10-26 | Lauderdale | Tennessee | 47097 | 5200 | 64 |
1851684 | 1851684 | 2021-10-25 | Lauderdale | Tennessee | 47097 | 5196 | 64 |
1848434 | 1848434 | 2021-10-24 | Lauderdale | Tennessee | 47097 | 5196 | 64 |
1845184 | 1845184 | 2021-10-23 | Lauderdale | Tennessee | 47097 | 5196 | 64 |
1841934 | 1841934 | 2021-10-22 | Lauderdale | Tennessee | 47097 | 5196 | 64 |
1838685 | 1838685 | 2021-10-21 | Lauderdale | Tennessee | 47097 | 5196 | 64 |
1835436 | 1835436 | 2021-10-20 | Lauderdale | Tennessee | 47097 | 5195 | 63 |
1832187 | 1832187 | 2021-10-19 | Lauderdale | Tennessee | 47097 | 5192 | 61 |
1828938 | 1828938 | 2021-10-18 | Lauderdale | Tennessee | 47097 | 5190 | 62 |
1825689 | 1825689 | 2021-10-17 | Lauderdale | Tennessee | 47097 | 5182 | 62 |
1822440 | 1822440 | 2021-10-16 | Lauderdale | Tennessee | 47097 | 5182 | 62 |
1819191 | 1819191 | 2021-10-15 | Lauderdale | Tennessee | 47097 | 5182 | 62 |
1815942 | 1815942 | 2021-10-14 | Lauderdale | Tennessee | 47097 | 5179 | 62 |
1812694 | 1812694 | 2021-10-13 | Lauderdale | Tennessee | 47097 | 5178 | 62 |
1809445 | 1809445 | 2021-10-12 | Lauderdale | Tennessee | 47097 | 5161 | 62 |
1806195 | 1806195 | 2021-10-11 | Lauderdale | Tennessee | 47097 | 5153 | 62 |
1802945 | 1802945 | 2021-10-10 | Lauderdale | Tennessee | 47097 | 5140 | 62 |
1799696 | 1799696 | 2021-10-09 | Lauderdale | Tennessee | 47097 | 5140 | 62 |
1796447 | 1796447 | 2021-10-08 | Lauderdale | Tennessee | 47097 | 5140 | 62 |
1793198 | 1793198 | 2021-10-07 | Lauderdale | Tennessee | 47097 | 5121 | 62 |
1789949 | 1789949 | 2021-10-06 | Lauderdale | Tennessee | 47097 | 5109 | 61 |
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);