ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
408 rows where deaths = 32 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Cannon 102
- Humphreys 59
- Lake 16
- Moore 16
- Sequatchie 16
- Carter 13
- Houston 11
- Van Buren 11
- Hardeman 9
- Benton 7
- Hancock 7
- McMinn 7
- Scott 7
- Clay 6
- Lawrence 5
- Macon 5
- McNairy 5
- Perry 5
- Rutherford 5
- Decatur 4
- Grundy 4
- Jefferson 4
- Johnson 4
- Meigs 4
- Monroe 4
- Tipton 4
- Anderson 3
- Blount 3
- Campbell 3
- Cocke 3
- …
state 1
- Tennessee · 408 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2310090 | 2310090 | 2022-03-15 | Hancock | Tennessee | 47067 | 1998 | 32 |
2306837 | 2306837 | 2022-03-14 | Hancock | Tennessee | 47067 | 1998 | 32 |
2303586 | 2303586 | 2022-03-13 | Hancock | Tennessee | 47067 | 1998 | 32 |
2300334 | 2300334 | 2022-03-12 | Hancock | Tennessee | 47067 | 1998 | 32 |
2297082 | 2297082 | 2022-03-11 | Hancock | Tennessee | 47067 | 1998 | 32 |
2293830 | 2293830 | 2022-03-10 | Hancock | Tennessee | 47067 | 1998 | 32 |
2290578 | 2290578 | 2022-03-09 | Hancock | Tennessee | 47067 | 1998 | 32 |
2127982 | 2127982 | 2022-01-18 | Moore | Tennessee | 47127 | 1625 | 32 |
2124730 | 2124730 | 2022-01-17 | Moore | Tennessee | 47127 | 1625 | 32 |
2121478 | 2121478 | 2022-01-16 | Moore | Tennessee | 47127 | 1625 | 32 |
2118226 | 2118226 | 2022-01-15 | Moore | Tennessee | 47127 | 1625 | 32 |
2114975 | 2114975 | 2022-01-14 | Moore | Tennessee | 47127 | 1625 | 32 |
2111723 | 2111723 | 2022-01-13 | Moore | Tennessee | 47127 | 1625 | 32 |
2108471 | 2108471 | 2022-01-12 | Moore | Tennessee | 47127 | 1625 | 32 |
2105220 | 2105220 | 2022-01-11 | Moore | Tennessee | 47127 | 1561 | 32 |
2101969 | 2101969 | 2022-01-10 | Moore | Tennessee | 47127 | 1561 | 32 |
2098718 | 2098718 | 2022-01-09 | Moore | Tennessee | 47127 | 1561 | 32 |
2095466 | 2095466 | 2022-01-08 | Moore | Tennessee | 47127 | 1561 | 32 |
2092214 | 2092214 | 2022-01-07 | Moore | Tennessee | 47127 | 1561 | 32 |
2088962 | 2088962 | 2022-01-06 | Moore | Tennessee | 47127 | 1561 | 32 |
2085711 | 2085711 | 2022-01-05 | Moore | Tennessee | 47127 | 1561 | 32 |
2082459 | 2082459 | 2022-01-04 | Moore | Tennessee | 47127 | 1561 | 32 |
2079207 | 2079207 | 2022-01-03 | Moore | Tennessee | 47127 | 1557 | 32 |
2040190 | 2040190 | 2021-12-22 | Lake | Tennessee | 47095 | 2044 | 32 |
2036940 | 2036940 | 2021-12-21 | Lake | Tennessee | 47095 | 2043 | 32 |
2033690 | 2033690 | 2021-12-20 | Lake | Tennessee | 47095 | 2042 | 32 |
2030440 | 2030440 | 2021-12-19 | Lake | Tennessee | 47095 | 2042 | 32 |
2027189 | 2027189 | 2021-12-18 | Lake | Tennessee | 47095 | 2042 | 32 |
2023938 | 2023938 | 2021-12-17 | Lake | Tennessee | 47095 | 2042 | 32 |
2020687 | 2020687 | 2021-12-16 | Lake | Tennessee | 47095 | 2041 | 32 |
2017436 | 2017436 | 2021-12-15 | Lake | Tennessee | 47095 | 2041 | 32 |
2014186 | 2014186 | 2021-12-14 | Lake | Tennessee | 47095 | 2038 | 32 |
2010935 | 2010935 | 2021-12-13 | Lake | Tennessee | 47095 | 2038 | 32 |
2010976 | 2010976 | 2021-12-13 | Van Buren | Tennessee | 47175 | 1316 | 32 |
2007684 | 2007684 | 2021-12-12 | Lake | Tennessee | 47095 | 2035 | 32 |
2007725 | 2007725 | 2021-12-12 | Van Buren | Tennessee | 47175 | 1312 | 32 |
2004433 | 2004433 | 2021-12-11 | Lake | Tennessee | 47095 | 2035 | 32 |
2004474 | 2004474 | 2021-12-11 | Van Buren | Tennessee | 47175 | 1312 | 32 |
2001182 | 2001182 | 2021-12-10 | Lake | Tennessee | 47095 | 2035 | 32 |
2001223 | 2001223 | 2021-12-10 | Van Buren | Tennessee | 47175 | 1312 | 32 |
1997932 | 1997932 | 2021-12-09 | Lake | Tennessee | 47095 | 2033 | 32 |
1997973 | 1997973 | 2021-12-09 | Van Buren | Tennessee | 47175 | 1308 | 32 |
1994681 | 1994681 | 2021-12-08 | Lake | Tennessee | 47095 | 2033 | 32 |
1994722 | 1994722 | 2021-12-08 | Van Buren | Tennessee | 47175 | 1308 | 32 |
1991430 | 1991430 | 2021-12-07 | Lake | Tennessee | 47095 | 2031 | 32 |
1991471 | 1991471 | 2021-12-07 | Van Buren | Tennessee | 47175 | 1305 | 32 |
1988220 | 1988220 | 2021-12-06 | Van Buren | Tennessee | 47175 | 1298 | 32 |
1984942 | 1984942 | 2021-12-05 | Meigs | Tennessee | 47121 | 2239 | 32 |
1984970 | 1984970 | 2021-12-05 | Van Buren | Tennessee | 47175 | 1292 | 32 |
1981692 | 1981692 | 2021-12-04 | Meigs | Tennessee | 47121 | 2239 | 32 |
1981720 | 1981720 | 2021-12-04 | Van Buren | Tennessee | 47175 | 1292 | 32 |
1978442 | 1978442 | 2021-12-03 | Meigs | Tennessee | 47121 | 2239 | 32 |
1978470 | 1978470 | 2021-12-03 | Van Buren | Tennessee | 47175 | 1292 | 32 |
1975192 | 1975192 | 2021-12-02 | Meigs | Tennessee | 47121 | 2238 | 32 |
1942693 | 1942693 | 2021-11-22 | Polk | Tennessee | 47139 | 3238 | 32 |
1858210 | 1858210 | 2021-10-27 | Sequatchie | Tennessee | 47153 | 2990 | 32 |
1854961 | 1854961 | 2021-10-26 | Sequatchie | Tennessee | 47153 | 2988 | 32 |
1851712 | 1851712 | 2021-10-25 | Sequatchie | Tennessee | 47153 | 2973 | 32 |
1848462 | 1848462 | 2021-10-24 | Sequatchie | Tennessee | 47153 | 2973 | 32 |
1845212 | 1845212 | 2021-10-23 | Sequatchie | Tennessee | 47153 | 2973 | 32 |
1841962 | 1841962 | 2021-10-22 | Sequatchie | Tennessee | 47153 | 2973 | 32 |
1838713 | 1838713 | 2021-10-21 | Sequatchie | Tennessee | 47153 | 2967 | 32 |
1835464 | 1835464 | 2021-10-20 | Sequatchie | Tennessee | 47153 | 2964 | 32 |
1832215 | 1832215 | 2021-10-19 | Sequatchie | Tennessee | 47153 | 2958 | 32 |
1828966 | 1828966 | 2021-10-18 | Sequatchie | Tennessee | 47153 | 2955 | 32 |
1825717 | 1825717 | 2021-10-17 | Sequatchie | Tennessee | 47153 | 2942 | 32 |
1822468 | 1822468 | 2021-10-16 | Sequatchie | Tennessee | 47153 | 2942 | 32 |
1819219 | 1819219 | 2021-10-15 | Sequatchie | Tennessee | 47153 | 2942 | 32 |
1815970 | 1815970 | 2021-10-14 | Sequatchie | Tennessee | 47153 | 2938 | 32 |
1812722 | 1812722 | 2021-10-13 | Sequatchie | Tennessee | 47153 | 2935 | 32 |
1809473 | 1809473 | 2021-10-12 | Sequatchie | Tennessee | 47153 | 2932 | 32 |
1780222 | 1780222 | 2021-10-03 | Perry | Tennessee | 47135 | 1540 | 32 |
1776972 | 1776972 | 2021-10-02 | Perry | Tennessee | 47135 | 1540 | 32 |
1773722 | 1773722 | 2021-10-01 | Perry | Tennessee | 47135 | 1540 | 32 |
1770472 | 1770472 | 2021-09-30 | Perry | Tennessee | 47135 | 1537 | 32 |
1767223 | 1767223 | 2021-09-29 | Perry | Tennessee | 47135 | 1534 | 32 |
1767236 | 1767236 | 2021-09-29 | Stewart | Tennessee | 47161 | 2015 | 32 |
1715186 | 1715186 | 2021-09-13 | Clay | Tennessee | 47027 | 1317 | 32 |
1711940 | 1711940 | 2021-09-12 | Clay | Tennessee | 47027 | 1290 | 32 |
1708693 | 1708693 | 2021-09-11 | Clay | Tennessee | 47027 | 1290 | 32 |
1705446 | 1705446 | 2021-09-10 | Clay | Tennessee | 47027 | 1290 | 32 |
1702196 | 1702196 | 2021-09-09 | Clay | Tennessee | 47027 | 1281 | 32 |
1698947 | 1698947 | 2021-09-08 | Clay | Tennessee | 47027 | 1275 | 32 |
1692445 | 1692445 | 2021-09-06 | Cannon | Tennessee | 47015 | 2300 | 32 |
1689196 | 1689196 | 2021-09-05 | Cannon | Tennessee | 47015 | 2300 | 32 |
1685946 | 1685946 | 2021-09-04 | Cannon | Tennessee | 47015 | 2300 | 32 |
1682695 | 1682695 | 2021-09-03 | Cannon | Tennessee | 47015 | 2300 | 32 |
1679445 | 1679445 | 2021-09-02 | Cannon | Tennessee | 47015 | 2284 | 32 |
1676197 | 1676197 | 2021-09-01 | Cannon | Tennessee | 47015 | 2281 | 32 |
1672950 | 1672950 | 2021-08-31 | Cannon | Tennessee | 47015 | 2252 | 32 |
1669702 | 1669702 | 2021-08-30 | Cannon | Tennessee | 47015 | 2242 | 32 |
1666455 | 1666455 | 2021-08-29 | Cannon | Tennessee | 47015 | 2205 | 32 |
1663207 | 1663207 | 2021-08-28 | Cannon | Tennessee | 47015 | 2205 | 32 |
1659959 | 1659959 | 2021-08-27 | Cannon | Tennessee | 47015 | 2205 | 32 |
1656710 | 1656710 | 2021-08-26 | Cannon | Tennessee | 47015 | 2187 | 32 |
1653463 | 1653463 | 2021-08-25 | Cannon | Tennessee | 47015 | 2162 | 32 |
1650216 | 1650216 | 2021-08-24 | Cannon | Tennessee | 47015 | 2162 | 32 |
1646967 | 1646967 | 2021-08-23 | Cannon | Tennessee | 47015 | 2148 | 32 |
1643718 | 1643718 | 2021-08-22 | Cannon | Tennessee | 47015 | 2117 | 32 |
1643753 | 1643753 | 2021-08-22 | Humphreys | Tennessee | 47085 | 2259 | 32 |
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);