ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
683 rows where deaths = 34 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Union 165
- Houston 69
- Perry 56
- Wayne 56
- Lake 48
- Grundy 26
- Jackson 22
- Hancock 21
- Hawkins 12
- Hickman 10
- McNairy 10
- Henderson 9
- Weakley 9
- Stewart 8
- Carroll 7
- Hardin 7
- Moore 7
- Lawrence 6
- Morgan 6
- Rutherford 6
- Campbell 5
- Haywood 5
- Henry 5
- Overton 5
- Cheatham 4
- Cumberland 4
- Franklin 4
- Giles 4
- Lincoln 4
- Marion 4
- …
state 1
- Tennessee · 683 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2378407 | 2378407 | 2022-04-05 | Hancock | Tennessee | 47067 | 2002 | 34 |
2375153 | 2375153 | 2022-04-04 | Hancock | Tennessee | 47067 | 2002 | 34 |
2371901 | 2371901 | 2022-04-03 | Hancock | Tennessee | 47067 | 2002 | 34 |
2368648 | 2368648 | 2022-04-02 | Hancock | Tennessee | 47067 | 2002 | 34 |
2365395 | 2365395 | 2022-04-01 | Hancock | Tennessee | 47067 | 2002 | 34 |
2362142 | 2362142 | 2022-03-31 | Hancock | Tennessee | 47067 | 2002 | 34 |
2358888 | 2358888 | 2022-03-30 | Hancock | Tennessee | 47067 | 2002 | 34 |
2355634 | 2355634 | 2022-03-29 | Hancock | Tennessee | 47067 | 2002 | 34 |
2352381 | 2352381 | 2022-03-28 | Hancock | Tennessee | 47067 | 2002 | 34 |
2349129 | 2349129 | 2022-03-27 | Hancock | Tennessee | 47067 | 2002 | 34 |
2345876 | 2345876 | 2022-03-26 | Hancock | Tennessee | 47067 | 2002 | 34 |
2342623 | 2342623 | 2022-03-25 | Hancock | Tennessee | 47067 | 2002 | 34 |
2339370 | 2339370 | 2022-03-24 | Hancock | Tennessee | 47067 | 2002 | 34 |
2336116 | 2336116 | 2022-03-23 | Hancock | Tennessee | 47067 | 2002 | 34 |
2332862 | 2332862 | 2022-03-22 | Hancock | Tennessee | 47067 | 2001 | 34 |
2329609 | 2329609 | 2022-03-21 | Hancock | Tennessee | 47067 | 2001 | 34 |
2326357 | 2326357 | 2022-03-20 | Hancock | Tennessee | 47067 | 2001 | 34 |
2323104 | 2323104 | 2022-03-19 | Hancock | Tennessee | 47067 | 2001 | 34 |
2319850 | 2319850 | 2022-03-18 | Hancock | Tennessee | 47067 | 2001 | 34 |
2316596 | 2316596 | 2022-03-17 | Hancock | Tennessee | 47067 | 2001 | 34 |
2313343 | 2313343 | 2022-03-16 | Hancock | Tennessee | 47067 | 2001 | 34 |
2196290 | 2196290 | 2022-02-08 | Lake | Tennessee | 47095 | 2581 | 34 |
2193036 | 2193036 | 2022-02-07 | Lake | Tennessee | 47095 | 2581 | 34 |
2189782 | 2189782 | 2022-02-06 | Lake | Tennessee | 47095 | 2581 | 34 |
2186529 | 2186529 | 2022-02-05 | Lake | Tennessee | 47095 | 2581 | 34 |
2183277 | 2183277 | 2022-02-04 | Lake | Tennessee | 47095 | 2581 | 34 |
2180025 | 2180025 | 2022-02-03 | Lake | Tennessee | 47095 | 2581 | 34 |
2176774 | 2176774 | 2022-02-02 | Lake | Tennessee | 47095 | 2581 | 34 |
2173520 | 2173520 | 2022-02-01 | Lake | Tennessee | 47095 | 2489 | 34 |
2173536 | 2173536 | 2022-02-01 | Moore | Tennessee | 47127 | 1940 | 34 |
2170268 | 2170268 | 2022-01-31 | Lake | Tennessee | 47095 | 2489 | 34 |
2170284 | 2170284 | 2022-01-31 | Moore | Tennessee | 47127 | 1940 | 34 |
2167014 | 2167014 | 2022-01-30 | Lake | Tennessee | 47095 | 2489 | 34 |
2167030 | 2167030 | 2022-01-30 | Moore | Tennessee | 47127 | 1940 | 34 |
2163759 | 2163759 | 2022-01-29 | Lake | Tennessee | 47095 | 2489 | 34 |
2163775 | 2163775 | 2022-01-29 | Moore | Tennessee | 47127 | 1940 | 34 |
2160504 | 2160504 | 2022-01-28 | Lake | Tennessee | 47095 | 2489 | 34 |
2160520 | 2160520 | 2022-01-28 | Moore | Tennessee | 47127 | 1940 | 34 |
2157248 | 2157248 | 2022-01-27 | Lake | Tennessee | 47095 | 2489 | 34 |
2157264 | 2157264 | 2022-01-27 | Moore | Tennessee | 47127 | 1940 | 34 |
2153995 | 2153995 | 2022-01-26 | Lake | Tennessee | 47095 | 2489 | 34 |
2154011 | 2154011 | 2022-01-26 | Moore | Tennessee | 47127 | 1940 | 34 |
2150743 | 2150743 | 2022-01-25 | Lake | Tennessee | 47095 | 2337 | 34 |
2147491 | 2147491 | 2022-01-24 | Lake | Tennessee | 47095 | 2337 | 34 |
2144237 | 2144237 | 2022-01-23 | Lake | Tennessee | 47095 | 2337 | 34 |
2140982 | 2140982 | 2022-01-22 | Lake | Tennessee | 47095 | 2337 | 34 |
2137726 | 2137726 | 2022-01-21 | Lake | Tennessee | 47095 | 2337 | 34 |
2134472 | 2134472 | 2022-01-20 | Lake | Tennessee | 47095 | 2337 | 34 |
2131220 | 2131220 | 2022-01-19 | Lake | Tennessee | 47095 | 2337 | 34 |
2127966 | 2127966 | 2022-01-18 | Lake | Tennessee | 47095 | 2177 | 34 |
2124714 | 2124714 | 2022-01-17 | Lake | Tennessee | 47095 | 2177 | 34 |
2121462 | 2121462 | 2022-01-16 | Lake | Tennessee | 47095 | 2177 | 34 |
2118210 | 2118210 | 2022-01-15 | Lake | Tennessee | 47095 | 2177 | 34 |
2114959 | 2114959 | 2022-01-14 | Lake | Tennessee | 47095 | 2177 | 34 |
2111707 | 2111707 | 2022-01-13 | Lake | Tennessee | 47095 | 2177 | 34 |
2108455 | 2108455 | 2022-01-12 | Lake | Tennessee | 47095 | 2177 | 34 |
2105204 | 2105204 | 2022-01-11 | Lake | Tennessee | 47095 | 2100 | 34 |
2101953 | 2101953 | 2022-01-10 | Lake | Tennessee | 47095 | 2100 | 34 |
2098702 | 2098702 | 2022-01-09 | Lake | Tennessee | 47095 | 2100 | 34 |
2095450 | 2095450 | 2022-01-08 | Lake | Tennessee | 47095 | 2100 | 34 |
2092198 | 2092198 | 2022-01-07 | Lake | Tennessee | 47095 | 2100 | 34 |
2088946 | 2088946 | 2022-01-06 | Lake | Tennessee | 47095 | 2100 | 34 |
2085695 | 2085695 | 2022-01-05 | Lake | Tennessee | 47095 | 2100 | 34 |
2082443 | 2082443 | 2022-01-04 | Lake | Tennessee | 47095 | 2100 | 34 |
2079191 | 2079191 | 2022-01-03 | Lake | Tennessee | 47095 | 2089 | 34 |
2075940 | 2075940 | 2022-01-02 | Lake | Tennessee | 47095 | 2065 | 34 |
2072689 | 2072689 | 2022-01-01 | Lake | Tennessee | 47095 | 2065 | 34 |
2069438 | 2069438 | 2021-12-31 | Lake | Tennessee | 47095 | 2065 | 34 |
2066187 | 2066187 | 2021-12-30 | Lake | Tennessee | 47095 | 2065 | 34 |
2062937 | 2062937 | 2021-12-29 | Lake | Tennessee | 47095 | 2060 | 34 |
2059687 | 2059687 | 2021-12-28 | Lake | Tennessee | 47095 | 2053 | 34 |
2056438 | 2056438 | 2021-12-27 | Lake | Tennessee | 47095 | 2050 | 34 |
2053189 | 2053189 | 2021-12-26 | Lake | Tennessee | 47095 | 2048 | 34 |
2049939 | 2049939 | 2021-12-25 | Lake | Tennessee | 47095 | 2048 | 34 |
2046689 | 2046689 | 2021-12-24 | Lake | Tennessee | 47095 | 2048 | 34 |
2043439 | 2043439 | 2021-12-23 | Lake | Tennessee | 47095 | 2048 | 34 |
2040203 | 2040203 | 2021-12-22 | Meigs | Tennessee | 47121 | 2318 | 34 |
2036953 | 2036953 | 2021-12-21 | Meigs | Tennessee | 47121 | 2312 | 34 |
2010957 | 2010957 | 2021-12-13 | Polk | Tennessee | 47139 | 3305 | 34 |
2007706 | 2007706 | 2021-12-12 | Polk | Tennessee | 47139 | 3298 | 34 |
2004455 | 2004455 | 2021-12-11 | Polk | Tennessee | 47139 | 3298 | 34 |
2001204 | 2001204 | 2021-12-10 | Polk | Tennessee | 47139 | 3298 | 34 |
1968700 | 1968700 | 2021-11-30 | Perry | Tennessee | 47135 | 1645 | 34 |
1965449 | 1965449 | 2021-11-29 | Perry | Tennessee | 47135 | 1641 | 34 |
1962197 | 1962197 | 2021-11-28 | Perry | Tennessee | 47135 | 1639 | 34 |
1958946 | 1958946 | 2021-11-27 | Perry | Tennessee | 47135 | 1639 | 34 |
1955695 | 1955695 | 2021-11-26 | Perry | Tennessee | 47135 | 1639 | 34 |
1952444 | 1952444 | 2021-11-25 | Perry | Tennessee | 47135 | 1639 | 34 |
1949193 | 1949193 | 2021-11-24 | Perry | Tennessee | 47135 | 1639 | 34 |
1945942 | 1945942 | 2021-11-23 | Perry | Tennessee | 47135 | 1638 | 34 |
1942691 | 1942691 | 2021-11-22 | Perry | Tennessee | 47135 | 1637 | 34 |
1939441 | 1939441 | 2021-11-21 | Perry | Tennessee | 47135 | 1634 | 34 |
1936191 | 1936191 | 2021-11-20 | Perry | Tennessee | 47135 | 1634 | 34 |
1932941 | 1932941 | 2021-11-19 | Perry | Tennessee | 47135 | 1634 | 34 |
1929690 | 1929690 | 2021-11-18 | Perry | Tennessee | 47135 | 1634 | 34 |
1926440 | 1926440 | 2021-11-17 | Perry | Tennessee | 47135 | 1634 | 34 |
1923190 | 1923190 | 2021-11-16 | Perry | Tennessee | 47135 | 1634 | 34 |
1919941 | 1919941 | 2021-11-15 | Perry | Tennessee | 47135 | 1634 | 34 |
1916691 | 1916691 | 2021-11-14 | Perry | Tennessee | 47135 | 1629 | 34 |
1913441 | 1913441 | 2021-11-13 | Perry | Tennessee | 47135 | 1629 | 34 |
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);