ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
335 rows where deaths = 83 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Carroll 88
- Fayette 54
- Rhea 29
- Overton 25
- Smith 21
- Benton 14
- Marshall 10
- Lawrence 9
- Hardin 8
- Chester 7
- Haywood 7
- Lauderdale 7
- Lincoln 7
- Warren 7
- Henry 5
- Montgomery 5
- Claiborne 2
- Henderson 2
- Jefferson 2
- Knox 2
- Obion 2
- Putnam 2
- Sumner 2
- Washington 2
- Bedford 1
- Campbell 1
- Cocke 1
- Dyer 1
- Franklin 1
- Giles 1
- …
state 1
- Tennessee · 335 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2401240 | 2401240 | 2022-04-12 | Smith | Tennessee | 47159 | 6160 | 83 |
2397985 | 2397985 | 2022-04-11 | Smith | Tennessee | 47159 | 6160 | 83 |
2394730 | 2394730 | 2022-04-10 | Smith | Tennessee | 47159 | 6160 | 83 |
2391474 | 2391474 | 2022-04-09 | Smith | Tennessee | 47159 | 6160 | 83 |
2388218 | 2388218 | 2022-04-08 | Smith | Tennessee | 47159 | 6160 | 83 |
2384963 | 2384963 | 2022-04-07 | Smith | Tennessee | 47159 | 6160 | 83 |
2381708 | 2381708 | 2022-04-06 | Smith | Tennessee | 47159 | 6160 | 83 |
2378453 | 2378453 | 2022-04-05 | Smith | Tennessee | 47159 | 6158 | 83 |
2375199 | 2375199 | 2022-04-04 | Smith | Tennessee | 47159 | 6158 | 83 |
2371947 | 2371947 | 2022-04-03 | Smith | Tennessee | 47159 | 6158 | 83 |
2368694 | 2368694 | 2022-04-02 | Smith | Tennessee | 47159 | 6158 | 83 |
2365441 | 2365441 | 2022-04-01 | Smith | Tennessee | 47159 | 6158 | 83 |
2362188 | 2362188 | 2022-03-31 | Smith | Tennessee | 47159 | 6158 | 83 |
2358934 | 2358934 | 2022-03-30 | Smith | Tennessee | 47159 | 6158 | 83 |
2355680 | 2355680 | 2022-03-29 | Smith | Tennessee | 47159 | 6157 | 83 |
2352427 | 2352427 | 2022-03-28 | Smith | Tennessee | 47159 | 6157 | 83 |
2349175 | 2349175 | 2022-03-27 | Smith | Tennessee | 47159 | 6157 | 83 |
2345922 | 2345922 | 2022-03-26 | Smith | Tennessee | 47159 | 6157 | 83 |
2342669 | 2342669 | 2022-03-25 | Smith | Tennessee | 47159 | 6157 | 83 |
2339416 | 2339416 | 2022-03-24 | Smith | Tennessee | 47159 | 6157 | 83 |
2336162 | 2336162 | 2022-03-23 | Smith | Tennessee | 47159 | 6157 | 83 |
2173475 | 2173475 | 2022-02-01 | Benton | Tennessee | 47005 | 3746 | 83 |
2173510 | 2173510 | 2022-02-01 | Haywood | Tennessee | 47075 | 5449 | 83 |
2173521 | 2173521 | 2022-02-01 | Lauderdale | Tennessee | 47097 | 6938 | 83 |
2170223 | 2170223 | 2022-01-31 | Benton | Tennessee | 47005 | 3746 | 83 |
2170258 | 2170258 | 2022-01-31 | Haywood | Tennessee | 47075 | 5449 | 83 |
2170269 | 2170269 | 2022-01-31 | Lauderdale | Tennessee | 47097 | 6938 | 83 |
2166969 | 2166969 | 2022-01-30 | Benton | Tennessee | 47005 | 3746 | 83 |
2167004 | 2167004 | 2022-01-30 | Haywood | Tennessee | 47075 | 5449 | 83 |
2167015 | 2167015 | 2022-01-30 | Lauderdale | Tennessee | 47097 | 6938 | 83 |
2163714 | 2163714 | 2022-01-29 | Benton | Tennessee | 47005 | 3746 | 83 |
2163749 | 2163749 | 2022-01-29 | Haywood | Tennessee | 47075 | 5449 | 83 |
2163760 | 2163760 | 2022-01-29 | Lauderdale | Tennessee | 47097 | 6938 | 83 |
2160459 | 2160459 | 2022-01-28 | Benton | Tennessee | 47005 | 3746 | 83 |
2160494 | 2160494 | 2022-01-28 | Haywood | Tennessee | 47075 | 5449 | 83 |
2160505 | 2160505 | 2022-01-28 | Lauderdale | Tennessee | 47097 | 6938 | 83 |
2157203 | 2157203 | 2022-01-27 | Benton | Tennessee | 47005 | 3746 | 83 |
2157238 | 2157238 | 2022-01-27 | Haywood | Tennessee | 47075 | 5449 | 83 |
2157249 | 2157249 | 2022-01-27 | Lauderdale | Tennessee | 47097 | 6938 | 83 |
2153950 | 2153950 | 2022-01-26 | Benton | Tennessee | 47005 | 3746 | 83 |
2153985 | 2153985 | 2022-01-26 | Haywood | Tennessee | 47075 | 5449 | 83 |
2153996 | 2153996 | 2022-01-26 | Lauderdale | Tennessee | 47097 | 6938 | 83 |
2150698 | 2150698 | 2022-01-25 | Benton | Tennessee | 47005 | 3526 | 83 |
2150707 | 2150707 | 2022-01-25 | Chester | Tennessee | 47023 | 4562 | 83 |
2147446 | 2147446 | 2022-01-24 | Benton | Tennessee | 47005 | 3526 | 83 |
2147455 | 2147455 | 2022-01-24 | Chester | Tennessee | 47023 | 4562 | 83 |
2144192 | 2144192 | 2022-01-23 | Benton | Tennessee | 47005 | 3526 | 83 |
2144201 | 2144201 | 2022-01-23 | Chester | Tennessee | 47023 | 4562 | 83 |
2140937 | 2140937 | 2022-01-22 | Benton | Tennessee | 47005 | 3526 | 83 |
2140946 | 2140946 | 2022-01-22 | Chester | Tennessee | 47023 | 4562 | 83 |
2137681 | 2137681 | 2022-01-21 | Benton | Tennessee | 47005 | 3526 | 83 |
2137690 | 2137690 | 2022-01-21 | Chester | Tennessee | 47023 | 4562 | 83 |
2134427 | 2134427 | 2022-01-20 | Benton | Tennessee | 47005 | 3526 | 83 |
2134436 | 2134436 | 2022-01-20 | Chester | Tennessee | 47023 | 4562 | 83 |
2131175 | 2131175 | 2022-01-19 | Benton | Tennessee | 47005 | 3526 | 83 |
2131184 | 2131184 | 2022-01-19 | Chester | Tennessee | 47023 | 4562 | 83 |
2040183 | 2040183 | 2021-12-22 | Hickman | Tennessee | 47081 | 4927 | 83 |
1965448 | 1965448 | 2021-11-29 | Overton | Tennessee | 47133 | 4908 | 83 |
1962196 | 1962196 | 2021-11-28 | Overton | Tennessee | 47133 | 4892 | 83 |
1958945 | 1958945 | 2021-11-27 | Overton | Tennessee | 47133 | 4892 | 83 |
1955694 | 1955694 | 2021-11-26 | Overton | Tennessee | 47133 | 4892 | 83 |
1952443 | 1952443 | 2021-11-25 | Overton | Tennessee | 47133 | 4892 | 83 |
1949192 | 1949192 | 2021-11-24 | Overton | Tennessee | 47133 | 4892 | 83 |
1945941 | 1945941 | 2021-11-23 | Overton | Tennessee | 47133 | 4890 | 83 |
1942690 | 1942690 | 2021-11-22 | Overton | Tennessee | 47133 | 4888 | 83 |
1939440 | 1939440 | 2021-11-21 | Overton | Tennessee | 47133 | 4880 | 83 |
1936190 | 1936190 | 2021-11-20 | Overton | Tennessee | 47133 | 4880 | 83 |
1932940 | 1932940 | 2021-11-19 | Overton | Tennessee | 47133 | 4880 | 83 |
1929689 | 1929689 | 2021-11-18 | Overton | Tennessee | 47133 | 4881 | 83 |
1926439 | 1926439 | 2021-11-17 | Overton | Tennessee | 47133 | 4878 | 83 |
1923189 | 1923189 | 2021-11-16 | Overton | Tennessee | 47133 | 4872 | 83 |
1919908 | 1919908 | 2021-11-15 | Hardeman | Tennessee | 47069 | 5155 | 83 |
1919940 | 1919940 | 2021-11-15 | Overton | Tennessee | 47133 | 4858 | 83 |
1916690 | 1916690 | 2021-11-14 | Overton | Tennessee | 47133 | 4851 | 83 |
1913440 | 1913440 | 2021-11-13 | Overton | Tennessee | 47133 | 4851 | 83 |
1910190 | 1910190 | 2021-11-12 | Overton | Tennessee | 47133 | 4851 | 83 |
1906910 | 1906910 | 2021-11-11 | Hardin | Tennessee | 47071 | 5593 | 83 |
1906941 | 1906941 | 2021-11-11 | Overton | Tennessee | 47133 | 4845 | 83 |
1903661 | 1903661 | 2021-11-10 | Hardin | Tennessee | 47071 | 5593 | 83 |
1903692 | 1903692 | 2021-11-10 | Overton | Tennessee | 47133 | 4845 | 83 |
1900411 | 1900411 | 2021-11-09 | Hardin | Tennessee | 47071 | 5584 | 83 |
1900442 | 1900442 | 2021-11-09 | Overton | Tennessee | 47133 | 4824 | 83 |
1897161 | 1897161 | 2021-11-08 | Hardin | Tennessee | 47071 | 5570 | 83 |
1897192 | 1897192 | 2021-11-08 | Overton | Tennessee | 47133 | 4804 | 83 |
1893911 | 1893911 | 2021-11-07 | Hardin | Tennessee | 47071 | 5570 | 83 |
1893942 | 1893942 | 2021-11-07 | Overton | Tennessee | 47133 | 4804 | 83 |
1890661 | 1890661 | 2021-11-06 | Hardin | Tennessee | 47071 | 5570 | 83 |
1890692 | 1890692 | 2021-11-06 | Overton | Tennessee | 47133 | 4804 | 83 |
1887411 | 1887411 | 2021-11-05 | Hardin | Tennessee | 47071 | 5570 | 83 |
1887442 | 1887442 | 2021-11-05 | Overton | Tennessee | 47133 | 4804 | 83 |
1884161 | 1884161 | 2021-11-04 | Hardin | Tennessee | 47071 | 5565 | 83 |
1877634 | 1877634 | 2021-11-02 | Campbell | Tennessee | 47013 | 7297 | 83 |
1854936 | 1854936 | 2021-10-26 | Lincoln | Tennessee | 47103 | 6658 | 83 |
1851687 | 1851687 | 2021-10-25 | Lincoln | Tennessee | 47103 | 6636 | 83 |
1848437 | 1848437 | 2021-10-24 | Lincoln | Tennessee | 47103 | 6636 | 83 |
1845187 | 1845187 | 2021-10-23 | Lincoln | Tennessee | 47103 | 6636 | 83 |
1841937 | 1841937 | 2021-10-22 | Lincoln | Tennessee | 47103 | 6636 | 83 |
1838688 | 1838688 | 2021-10-21 | Lincoln | Tennessee | 47103 | 6628 | 83 |
1835439 | 1835439 | 2021-10-20 | Lincoln | Tennessee | 47103 | 6618 | 83 |
1815950 | 1815950 | 2021-10-14 | Marshall | Tennessee | 47117 | 6775 | 83 |
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);