ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
272 rows where deaths = 79 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Henderson 42
- Lauderdale 27
- Haywood 21
- Unicoi 16
- Hardeman 15
- Henry 13
- Campbell 9
- Macon 9
- DeKalb 8
- Lawrence 7
- Claiborne 6
- Franklin 6
- Lincoln 6
- Madison 6
- Overton 6
- Warren 6
- Carter 5
- Cheatham 5
- Dyer 5
- Fayette 5
- Roane 5
- Hardin 4
- McMinn 4
- Carroll 3
- Greene 3
- Putnam 3
- Tipton 3
- Benton 2
- Cumberland 2
- Dickson 2
- …
state 1
- Tennessee · 272 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2127967 | 2127967 | 2022-01-18 | Lauderdale | Tennessee | 47097 | 5887 | 79 |
2124715 | 2124715 | 2022-01-17 | Lauderdale | Tennessee | 47097 | 5887 | 79 |
2121463 | 2121463 | 2022-01-16 | Lauderdale | Tennessee | 47097 | 5887 | 79 |
2118211 | 2118211 | 2022-01-15 | Lauderdale | Tennessee | 47097 | 5887 | 79 |
2114960 | 2114960 | 2022-01-14 | Lauderdale | Tennessee | 47097 | 5887 | 79 |
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 |
2105242 | 2105242 | 2022-01-11 | Unicoi | Tennessee | 47171 | 3485 | 79 |
2101954 | 2101954 | 2022-01-10 | Lauderdale | Tennessee | 47097 | 5585 | 79 |
2101991 | 2101991 | 2022-01-10 | Unicoi | Tennessee | 47171 | 3485 | 79 |
2098703 | 2098703 | 2022-01-09 | Lauderdale | Tennessee | 47097 | 5585 | 79 |
2098740 | 2098740 | 2022-01-09 | Unicoi | Tennessee | 47171 | 3485 | 79 |
2095451 | 2095451 | 2022-01-08 | Lauderdale | Tennessee | 47097 | 5585 | 79 |
2095488 | 2095488 | 2022-01-08 | Unicoi | Tennessee | 47171 | 3485 | 79 |
2092199 | 2092199 | 2022-01-07 | Lauderdale | Tennessee | 47097 | 5585 | 79 |
2092236 | 2092236 | 2022-01-07 | Unicoi | Tennessee | 47171 | 3485 | 79 |
2088947 | 2088947 | 2022-01-06 | Lauderdale | Tennessee | 47097 | 5585 | 79 |
2088984 | 2088984 | 2022-01-06 | Unicoi | Tennessee | 47171 | 3485 | 79 |
2085696 | 2085696 | 2022-01-05 | Lauderdale | Tennessee | 47097 | 5585 | 79 |
2085733 | 2085733 | 2022-01-05 | Unicoi | Tennessee | 47171 | 3485 | 79 |
2082444 | 2082444 | 2022-01-04 | Lauderdale | Tennessee | 47097 | 5585 | 79 |
2082481 | 2082481 | 2022-01-04 | Unicoi | Tennessee | 47171 | 3485 | 79 |
2079192 | 2079192 | 2022-01-03 | Lauderdale | Tennessee | 47097 | 5536 | 79 |
2079229 | 2079229 | 2022-01-03 | Unicoi | Tennessee | 47171 | 3474 | 79 |
2075941 | 2075941 | 2022-01-02 | Lauderdale | Tennessee | 47097 | 5410 | 79 |
2075978 | 2075978 | 2022-01-02 | Unicoi | Tennessee | 47171 | 3426 | 79 |
2072690 | 2072690 | 2022-01-01 | Lauderdale | Tennessee | 47097 | 5410 | 79 |
2072727 | 2072727 | 2022-01-01 | Unicoi | Tennessee | 47171 | 3426 | 79 |
2069439 | 2069439 | 2021-12-31 | Lauderdale | Tennessee | 47097 | 5410 | 79 |
2069476 | 2069476 | 2021-12-31 | Unicoi | Tennessee | 47171 | 3426 | 79 |
2066188 | 2066188 | 2021-12-30 | Lauderdale | Tennessee | 47097 | 5410 | 79 |
2066225 | 2066225 | 2021-12-30 | Unicoi | Tennessee | 47171 | 3426 | 79 |
2062892 | 2062892 | 2021-12-29 | Benton | Tennessee | 47005 | 3137 | 79 |
2062938 | 2062938 | 2021-12-29 | Lauderdale | Tennessee | 47097 | 5381 | 79 |
2062975 | 2062975 | 2021-12-29 | Unicoi | Tennessee | 47171 | 3398 | 79 |
2059642 | 2059642 | 2021-12-28 | Benton | Tennessee | 47005 | 3120 | 79 |
2059688 | 2059688 | 2021-12-28 | Lauderdale | Tennessee | 47097 | 5358 | 79 |
2059725 | 2059725 | 2021-12-28 | Unicoi | Tennessee | 47171 | 3390 | 79 |
2056439 | 2056439 | 2021-12-27 | Lauderdale | Tennessee | 47097 | 5343 | 79 |
2056476 | 2056476 | 2021-12-27 | Unicoi | Tennessee | 47171 | 3383 | 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 |
2040162 | 2040162 | 2021-12-22 | DeKalb | Tennessee | 47041 | 4429 | 79 |
2040180 | 2040180 | 2021-12-22 | Haywood | Tennessee | 47075 | 3984 | 79 |
2040198 | 2040198 | 2021-12-22 | Marion | Tennessee | 47115 | 6008 | 79 |
2040202 | 2040202 | 2021-12-22 | McNairy | Tennessee | 47109 | 4913 | 79 |
2036912 | 2036912 | 2021-12-21 | DeKalb | Tennessee | 47041 | 4423 | 79 |
2036930 | 2036930 | 2021-12-21 | Haywood | Tennessee | 47075 | 3979 | 79 |
2033662 | 2033662 | 2021-12-20 | DeKalb | Tennessee | 47041 | 4416 | 79 |
2033680 | 2033680 | 2021-12-20 | Haywood | Tennessee | 47075 | 3976 | 79 |
2030403 | 2030403 | 2021-12-19 | Cheatham | Tennessee | 47021 | 7375 | 79 |
2030412 | 2030412 | 2021-12-19 | DeKalb | Tennessee | 47041 | 4407 | 79 |
2030430 | 2030430 | 2021-12-19 | Haywood | Tennessee | 47075 | 3967 | 79 |
2027152 | 2027152 | 2021-12-18 | Cheatham | Tennessee | 47021 | 7375 | 79 |
2027161 | 2027161 | 2021-12-18 | DeKalb | Tennessee | 47041 | 4407 | 79 |
2027179 | 2027179 | 2021-12-18 | Haywood | Tennessee | 47075 | 3967 | 79 |
2023901 | 2023901 | 2021-12-17 | Cheatham | Tennessee | 47021 | 7375 | 79 |
2023910 | 2023910 | 2021-12-17 | DeKalb | Tennessee | 47041 | 4407 | 79 |
2023928 | 2023928 | 2021-12-17 | Haywood | Tennessee | 47075 | 3967 | 79 |
2020650 | 2020650 | 2021-12-16 | Cheatham | Tennessee | 47021 | 7364 | 79 |
2020659 | 2020659 | 2021-12-16 | DeKalb | Tennessee | 47041 | 4399 | 79 |
2020677 | 2020677 | 2021-12-16 | Haywood | Tennessee | 47075 | 3962 | 79 |
2017399 | 2017399 | 2021-12-15 | Cheatham | Tennessee | 47021 | 7351 | 79 |
2017408 | 2017408 | 2021-12-15 | DeKalb | Tennessee | 47041 | 4389 | 79 |
2017426 | 2017426 | 2021-12-15 | Haywood | Tennessee | 47075 | 3954 | 79 |
2014176 | 2014176 | 2021-12-14 | Haywood | Tennessee | 47075 | 3947 | 79 |
2010925 | 2010925 | 2021-12-13 | Haywood | Tennessee | 47075 | 3944 | 79 |
2007674 | 2007674 | 2021-12-12 | Haywood | Tennessee | 47075 | 3942 | 79 |
2004423 | 2004423 | 2021-12-11 | Haywood | Tennessee | 47075 | 3942 | 79 |
2001172 | 2001172 | 2021-12-10 | Haywood | Tennessee | 47075 | 3942 | 79 |
1997922 | 1997922 | 2021-12-09 | Haywood | Tennessee | 47075 | 3934 | 79 |
1994671 | 1994671 | 2021-12-08 | Haywood | Tennessee | 47075 | 3934 | 79 |
1991420 | 1991420 | 2021-12-07 | Haywood | Tennessee | 47075 | 3932 | 79 |
1988169 | 1988169 | 2021-12-06 | Haywood | Tennessee | 47075 | 3927 | 79 |
1984919 | 1984919 | 2021-12-05 | Haywood | Tennessee | 47075 | 3919 | 79 |
1981669 | 1981669 | 2021-12-04 | Haywood | Tennessee | 47075 | 3919 | 79 |
1978419 | 1978419 | 2021-12-03 | Haywood | Tennessee | 47075 | 3919 | 79 |
1975169 | 1975169 | 2021-12-02 | Haywood | Tennessee | 47075 | 3919 | 79 |
1854919 | 1854919 | 2021-10-26 | Hardeman | Tennessee | 47069 | 5101 | 79 |
1851670 | 1851670 | 2021-10-25 | Hardeman | Tennessee | 47069 | 5097 | 79 |
1848420 | 1848420 | 2021-10-24 | Hardeman | Tennessee | 47069 | 5097 | 79 |
1845170 | 1845170 | 2021-10-23 | Hardeman | Tennessee | 47069 | 5097 | 79 |
1841920 | 1841920 | 2021-10-22 | Hardeman | Tennessee | 47069 | 5097 | 79 |
1838643 | 1838643 | 2021-10-21 | Campbell | Tennessee | 47013 | 7172 | 79 |
1838671 | 1838671 | 2021-10-21 | Hardeman | Tennessee | 47069 | 5093 | 79 |
1835394 | 1835394 | 2021-10-20 | Campbell | Tennessee | 47013 | 7142 | 79 |
1835422 | 1835422 | 2021-10-20 | Hardeman | Tennessee | 47069 | 5088 | 79 |
1835454 | 1835454 | 2021-10-20 | Overton | Tennessee | 47133 | 4763 | 79 |
1832145 | 1832145 | 2021-10-19 | Campbell | Tennessee | 47013 | 7117 | 79 |
1832173 | 1832173 | 2021-10-19 | Hardeman | Tennessee | 47069 | 5079 | 79 |
1832205 | 1832205 | 2021-10-19 | Overton | Tennessee | 47133 | 4753 | 79 |
1828896 | 1828896 | 2021-10-18 | Campbell | Tennessee | 47013 | 7060 | 79 |
1828924 | 1828924 | 2021-10-18 | Hardeman | Tennessee | 47069 | 5071 | 79 |
1828956 | 1828956 | 2021-10-18 | Overton | Tennessee | 47133 | 4748 | 79 |
1825647 | 1825647 | 2021-10-17 | Campbell | Tennessee | 47013 | 6993 | 79 |
1825675 | 1825675 | 2021-10-17 | Hardeman | Tennessee | 47069 | 5066 | 79 |
1825707 | 1825707 | 2021-10-17 | Overton | Tennessee | 47133 | 4730 | 79 |
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);