ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
634 rows where deaths = 26 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Lewis 126
- Lake 109
- Trousdale 35
- Pickett 29
- Sequatchie 18
- Clay 16
- Macon 14
- Wayne 11
- Henderson 10
- Hickman 10
- Houston 10
- Marion 10
- Bledsoe 9
- Cocke 9
- Unicoi 9
- Hardeman 8
- Van Buren 8
- Weakley 8
- Hancock 7
- Perry 7
- Robertson 7
- Stewart 7
- Benton 6
- Campbell 6
- Crockett 6
- Grainger 6
- Sullivan 6
- Williamson 6
- Carroll 5
- Carter 5
- …
state 1
- Tennessee · 634 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2079177 | 2079177 | 2022-01-03 | Hancock | Tennessee | 47067 | 1436 | 26 |
2075926 | 2075926 | 2022-01-02 | Hancock | Tennessee | 47067 | 1399 | 26 |
2072675 | 2072675 | 2022-01-01 | Hancock | Tennessee | 47067 | 1399 | 26 |
2069424 | 2069424 | 2021-12-31 | Hancock | Tennessee | 47067 | 1399 | 26 |
2066173 | 2066173 | 2021-12-30 | Hancock | Tennessee | 47067 | 1399 | 26 |
2062923 | 2062923 | 2021-12-29 | Hancock | Tennessee | 47067 | 1393 | 26 |
2059673 | 2059673 | 2021-12-28 | Hancock | Tennessee | 47067 | 1384 | 26 |
2040211 | 2040211 | 2021-12-22 | Pickett | Tennessee | 47137 | 1147 | 26 |
2036961 | 2036961 | 2021-12-21 | Pickett | Tennessee | 47137 | 1146 | 26 |
2033706 | 2033706 | 2021-12-20 | Moore | Tennessee | 47127 | 1489 | 26 |
2033711 | 2033711 | 2021-12-20 | Pickett | Tennessee | 47137 | 1146 | 26 |
2030456 | 2030456 | 2021-12-19 | Moore | Tennessee | 47127 | 1483 | 26 |
2030461 | 2030461 | 2021-12-19 | Pickett | Tennessee | 47137 | 1144 | 26 |
2027205 | 2027205 | 2021-12-18 | Moore | Tennessee | 47127 | 1483 | 26 |
2027210 | 2027210 | 2021-12-18 | Pickett | Tennessee | 47137 | 1144 | 26 |
2023954 | 2023954 | 2021-12-17 | Moore | Tennessee | 47127 | 1483 | 26 |
2023959 | 2023959 | 2021-12-17 | Pickett | Tennessee | 47137 | 1144 | 26 |
2020708 | 2020708 | 2021-12-16 | Pickett | Tennessee | 47137 | 1142 | 26 |
2017392 | 2017392 | 2021-12-15 | Bledsoe | Tennessee | 47007 | 3596 | 26 |
2017457 | 2017457 | 2021-12-15 | Pickett | Tennessee | 47137 | 1141 | 26 |
2014142 | 2014142 | 2021-12-14 | Bledsoe | Tennessee | 47007 | 3591 | 26 |
2014207 | 2014207 | 2021-12-14 | Pickett | Tennessee | 47137 | 1136 | 26 |
2010891 | 2010891 | 2021-12-13 | Bledsoe | Tennessee | 47007 | 3588 | 26 |
2010956 | 2010956 | 2021-12-13 | Pickett | Tennessee | 47137 | 1136 | 26 |
2007640 | 2007640 | 2021-12-12 | Bledsoe | Tennessee | 47007 | 3585 | 26 |
2007705 | 2007705 | 2021-12-12 | Pickett | Tennessee | 47137 | 1135 | 26 |
2004389 | 2004389 | 2021-12-11 | Bledsoe | Tennessee | 47007 | 3585 | 26 |
2004454 | 2004454 | 2021-12-11 | Pickett | Tennessee | 47137 | 1135 | 26 |
2001138 | 2001138 | 2021-12-10 | Bledsoe | Tennessee | 47007 | 3585 | 26 |
2001203 | 2001203 | 2021-12-10 | Pickett | Tennessee | 47137 | 1135 | 26 |
1997888 | 1997888 | 2021-12-09 | Bledsoe | Tennessee | 47007 | 3584 | 26 |
1997953 | 1997953 | 2021-12-09 | Pickett | Tennessee | 47137 | 1135 | 26 |
1994637 | 1994637 | 2021-12-08 | Bledsoe | Tennessee | 47007 | 3584 | 26 |
1994702 | 1994702 | 2021-12-08 | Pickett | Tennessee | 47137 | 1135 | 26 |
1991386 | 1991386 | 2021-12-07 | Bledsoe | Tennessee | 47007 | 3582 | 26 |
1991451 | 1991451 | 2021-12-07 | Pickett | Tennessee | 47137 | 1131 | 26 |
1988200 | 1988200 | 2021-12-06 | Pickett | Tennessee | 47137 | 1130 | 26 |
1984950 | 1984950 | 2021-12-05 | Pickett | Tennessee | 47137 | 1129 | 26 |
1981700 | 1981700 | 2021-12-04 | Pickett | Tennessee | 47137 | 1129 | 26 |
1978450 | 1978450 | 2021-12-03 | Pickett | Tennessee | 47137 | 1129 | 26 |
1975200 | 1975200 | 2021-12-02 | Pickett | Tennessee | 47137 | 1128 | 26 |
1971951 | 1971951 | 2021-12-01 | Pickett | Tennessee | 47137 | 1127 | 26 |
1968701 | 1968701 | 2021-11-30 | Pickett | Tennessee | 47137 | 1123 | 26 |
1965450 | 1965450 | 2021-11-29 | Pickett | Tennessee | 47137 | 1122 | 26 |
1962198 | 1962198 | 2021-11-28 | Pickett | Tennessee | 47137 | 1121 | 26 |
1958947 | 1958947 | 2021-11-27 | Pickett | Tennessee | 47137 | 1121 | 26 |
1955696 | 1955696 | 2021-11-26 | Pickett | Tennessee | 47137 | 1121 | 26 |
1952445 | 1952445 | 2021-11-25 | Pickett | Tennessee | 47137 | 1121 | 26 |
1949194 | 1949194 | 2021-11-24 | Pickett | Tennessee | 47137 | 1121 | 26 |
1942708 | 1942708 | 2021-11-22 | Trousdale | Tennessee | 47169 | 3225 | 26 |
1939458 | 1939458 | 2021-11-21 | Trousdale | Tennessee | 47169 | 3219 | 26 |
1936208 | 1936208 | 2021-11-20 | Trousdale | Tennessee | 47169 | 3219 | 26 |
1932958 | 1932958 | 2021-11-19 | Trousdale | Tennessee | 47169 | 3219 | 26 |
1929707 | 1929707 | 2021-11-18 | Trousdale | Tennessee | 47169 | 3215 | 26 |
1926457 | 1926457 | 2021-11-17 | Trousdale | Tennessee | 47169 | 3212 | 26 |
1923207 | 1923207 | 2021-11-16 | Trousdale | Tennessee | 47169 | 3207 | 26 |
1919958 | 1919958 | 2021-11-15 | Trousdale | Tennessee | 47169 | 3205 | 26 |
1916708 | 1916708 | 2021-11-14 | Trousdale | Tennessee | 47169 | 3199 | 26 |
1913458 | 1913458 | 2021-11-13 | Trousdale | Tennessee | 47169 | 3199 | 26 |
1910208 | 1910208 | 2021-11-12 | Trousdale | Tennessee | 47169 | 3199 | 26 |
1906959 | 1906959 | 2021-11-11 | Trousdale | Tennessee | 47169 | 3187 | 26 |
1903710 | 1903710 | 2021-11-10 | Trousdale | Tennessee | 47169 | 3187 | 26 |
1900460 | 1900460 | 2021-11-09 | Trousdale | Tennessee | 47169 | 3185 | 26 |
1897210 | 1897210 | 2021-11-08 | Trousdale | Tennessee | 47169 | 3172 | 26 |
1893960 | 1893960 | 2021-11-07 | Trousdale | Tennessee | 47169 | 3172 | 26 |
1890710 | 1890710 | 2021-11-06 | Trousdale | Tennessee | 47169 | 3172 | 26 |
1887460 | 1887460 | 2021-11-05 | Trousdale | Tennessee | 47169 | 3172 | 26 |
1884210 | 1884210 | 2021-11-04 | Trousdale | Tennessee | 47169 | 3171 | 26 |
1880961 | 1880961 | 2021-11-03 | Trousdale | Tennessee | 47169 | 3170 | 26 |
1877712 | 1877712 | 2021-11-02 | Trousdale | Tennessee | 47169 | 3167 | 26 |
1874463 | 1874463 | 2021-11-01 | Trousdale | Tennessee | 47169 | 3162 | 26 |
1871214 | 1871214 | 2021-10-31 | Trousdale | Tennessee | 47169 | 3162 | 26 |
1867965 | 1867965 | 2021-10-30 | Trousdale | Tennessee | 47169 | 3162 | 26 |
1864716 | 1864716 | 2021-10-29 | Trousdale | Tennessee | 47169 | 3162 | 26 |
1861467 | 1861467 | 2021-10-28 | Trousdale | Tennessee | 47169 | 3158 | 26 |
1858218 | 1858218 | 2021-10-27 | Trousdale | Tennessee | 47169 | 3158 | 26 |
1854969 | 1854969 | 2021-10-26 | Trousdale | Tennessee | 47169 | 3155 | 26 |
1851720 | 1851720 | 2021-10-25 | Trousdale | Tennessee | 47169 | 3152 | 26 |
1848470 | 1848470 | 2021-10-24 | Trousdale | Tennessee | 47169 | 3152 | 26 |
1845220 | 1845220 | 2021-10-23 | Trousdale | Tennessee | 47169 | 3152 | 26 |
1841970 | 1841970 | 2021-10-22 | Trousdale | Tennessee | 47169 | 3152 | 26 |
1838721 | 1838721 | 2021-10-21 | Trousdale | Tennessee | 47169 | 3149 | 26 |
1835472 | 1835472 | 2021-10-20 | Trousdale | Tennessee | 47169 | 3148 | 26 |
1832223 | 1832223 | 2021-10-19 | Trousdale | Tennessee | 47169 | 3146 | 26 |
1806235 | 1806235 | 2021-10-11 | Van Buren | Tennessee | 47175 | 1204 | 26 |
1802985 | 1802985 | 2021-10-10 | Van Buren | Tennessee | 47175 | 1194 | 26 |
1799736 | 1799736 | 2021-10-09 | Van Buren | Tennessee | 47175 | 1194 | 26 |
1796487 | 1796487 | 2021-10-08 | Van Buren | Tennessee | 47175 | 1194 | 26 |
1793238 | 1793238 | 2021-10-07 | Van Buren | Tennessee | 47175 | 1190 | 26 |
1789989 | 1789989 | 2021-10-06 | Van Buren | Tennessee | 47175 | 1187 | 26 |
1786741 | 1786741 | 2021-10-05 | Van Buren | Tennessee | 47175 | 1186 | 26 |
1783492 | 1783492 | 2021-10-04 | Van Buren | Tennessee | 47175 | 1187 | 26 |
1770465 | 1770465 | 2021-09-30 | Meigs | Tennessee | 47121 | 2092 | 26 |
1767216 | 1767216 | 2021-09-29 | Meigs | Tennessee | 47121 | 2082 | 26 |
1611278 | 1611278 | 2021-08-12 | Lewis | Tennessee | 47101 | 1776 | 26 |
1608030 | 1608030 | 2021-08-11 | Lewis | Tennessee | 47101 | 1771 | 26 |
1604781 | 1604781 | 2021-08-10 | Lewis | Tennessee | 47101 | 1766 | 26 |
1601532 | 1601532 | 2021-08-09 | Lewis | Tennessee | 47101 | 1758 | 26 |
1598284 | 1598284 | 2021-08-08 | Lewis | Tennessee | 47101 | 1737 | 26 |
1595035 | 1595035 | 2021-08-07 | Lewis | Tennessee | 47101 | 1737 | 26 |
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);