ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
350 rows where deaths = 69 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Hardin 63
- Weakley 56
- Loudon 47
- Union 21
- Grundy 14
- Lauderdale 14
- Lawrence 13
- Scott 10
- Lincoln 8
- White 8
- Decatur 7
- Humphreys 7
- Johnson 7
- Unicoi 7
- Fentress 6
- Claiborne 5
- Haywood 5
- Franklin 4
- Henderson 4
- McNairy 4
- Hickman 3
- Jefferson 3
- Sequatchie 3
- Sumner 3
- Tipton 3
- Wilson 3
- Campbell 2
- Hamilton 2
- Roane 2
- Robertson 2
- …
state 1
- Tennessee · 350 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502187 | 2502187 | 2022-05-13 | Sequatchie | Tennessee | 47153 | 4226 | 69 |
2498929 | 2498929 | 2022-05-12 | Sequatchie | Tennessee | 47153 | 4226 | 69 |
2495671 | 2495671 | 2022-05-11 | Sequatchie | Tennessee | 47153 | 4226 | 69 |
2423972 | 2423972 | 2022-04-19 | Decatur | Tennessee | 47039 | 3731 | 69 |
2420716 | 2420716 | 2022-04-18 | Decatur | Tennessee | 47039 | 3731 | 69 |
2417460 | 2417460 | 2022-04-17 | Decatur | Tennessee | 47039 | 3731 | 69 |
2414204 | 2414204 | 2022-04-16 | Decatur | Tennessee | 47039 | 3731 | 69 |
2410948 | 2410948 | 2022-04-15 | Decatur | Tennessee | 47039 | 3731 | 69 |
2407692 | 2407692 | 2022-04-14 | Decatur | Tennessee | 47039 | 3731 | 69 |
2404436 | 2404436 | 2022-04-13 | Decatur | Tennessee | 47039 | 3731 | 69 |
2310087 | 2310087 | 2022-03-15 | Grundy | Tennessee | 47061 | 3974 | 69 |
2310099 | 2310099 | 2022-03-15 | Humphreys | Tennessee | 47085 | 4834 | 69 |
2306834 | 2306834 | 2022-03-14 | Grundy | Tennessee | 47061 | 3974 | 69 |
2306846 | 2306846 | 2022-03-14 | Humphreys | Tennessee | 47085 | 4834 | 69 |
2303583 | 2303583 | 2022-03-13 | Grundy | Tennessee | 47061 | 3974 | 69 |
2303595 | 2303595 | 2022-03-13 | Humphreys | Tennessee | 47085 | 4834 | 69 |
2300331 | 2300331 | 2022-03-12 | Grundy | Tennessee | 47061 | 3974 | 69 |
2300343 | 2300343 | 2022-03-12 | Humphreys | Tennessee | 47085 | 4834 | 69 |
2297079 | 2297079 | 2022-03-11 | Grundy | Tennessee | 47061 | 3974 | 69 |
2297091 | 2297091 | 2022-03-11 | Humphreys | Tennessee | 47085 | 4834 | 69 |
2293827 | 2293827 | 2022-03-10 | Grundy | Tennessee | 47061 | 3974 | 69 |
2293839 | 2293839 | 2022-03-10 | Humphreys | Tennessee | 47085 | 4834 | 69 |
2290575 | 2290575 | 2022-03-09 | Grundy | Tennessee | 47061 | 3974 | 69 |
2290587 | 2290587 | 2022-03-09 | Humphreys | Tennessee | 47085 | 4834 | 69 |
2287323 | 2287323 | 2022-03-08 | Grundy | Tennessee | 47061 | 3960 | 69 |
2287379 | 2287379 | 2022-03-08 | Union | Tennessee | 47173 | 5373 | 69 |
2284071 | 2284071 | 2022-03-07 | Grundy | Tennessee | 47061 | 3960 | 69 |
2284127 | 2284127 | 2022-03-07 | Union | Tennessee | 47173 | 5373 | 69 |
2280819 | 2280819 | 2022-03-06 | Grundy | Tennessee | 47061 | 3960 | 69 |
2280875 | 2280875 | 2022-03-06 | Union | Tennessee | 47173 | 5373 | 69 |
2277566 | 2277566 | 2022-03-05 | Grundy | Tennessee | 47061 | 3960 | 69 |
2277622 | 2277622 | 2022-03-05 | Union | Tennessee | 47173 | 5373 | 69 |
2274313 | 2274313 | 2022-03-04 | Grundy | Tennessee | 47061 | 3960 | 69 |
2274369 | 2274369 | 2022-03-04 | Union | Tennessee | 47173 | 5373 | 69 |
2271060 | 2271060 | 2022-03-03 | Grundy | Tennessee | 47061 | 3960 | 69 |
2271116 | 2271116 | 2022-03-03 | Union | Tennessee | 47173 | 5373 | 69 |
2267808 | 2267808 | 2022-03-02 | Grundy | Tennessee | 47061 | 3960 | 69 |
2267864 | 2267864 | 2022-03-02 | Union | Tennessee | 47173 | 5373 | 69 |
2264611 | 2264611 | 2022-03-01 | Union | Tennessee | 47173 | 5332 | 69 |
2261361 | 2261361 | 2022-02-28 | Union | Tennessee | 47173 | 5332 | 69 |
2258110 | 2258110 | 2022-02-27 | Union | Tennessee | 47173 | 5332 | 69 |
2254859 | 2254859 | 2022-02-26 | Union | Tennessee | 47173 | 5332 | 69 |
2251608 | 2251608 | 2022-02-25 | Union | Tennessee | 47173 | 5332 | 69 |
2248357 | 2248357 | 2022-02-24 | Union | Tennessee | 47173 | 5332 | 69 |
2245106 | 2245106 | 2022-02-23 | Union | Tennessee | 47173 | 5332 | 69 |
2219098 | 2219098 | 2022-02-15 | Union | Tennessee | 47173 | 5083 | 69 |
2215847 | 2215847 | 2022-02-14 | Union | Tennessee | 47173 | 5083 | 69 |
2212596 | 2212596 | 2022-02-13 | Union | Tennessee | 47173 | 5083 | 69 |
2209343 | 2209343 | 2022-02-12 | Union | Tennessee | 47173 | 5083 | 69 |
2206090 | 2206090 | 2022-02-11 | Union | Tennessee | 47173 | 5083 | 69 |
2202837 | 2202837 | 2022-02-10 | Union | Tennessee | 47173 | 5083 | 69 |
2199583 | 2199583 | 2022-02-09 | Union | Tennessee | 47173 | 5083 | 69 |
2150741 | 2150741 | 2022-01-25 | Johnson | Tennessee | 47091 | 4447 | 69 |
2147489 | 2147489 | 2022-01-24 | Johnson | Tennessee | 47091 | 4447 | 69 |
2144235 | 2144235 | 2022-01-23 | Johnson | Tennessee | 47091 | 4447 | 69 |
2140980 | 2140980 | 2022-01-22 | Johnson | Tennessee | 47091 | 4447 | 69 |
2137724 | 2137724 | 2022-01-21 | Johnson | Tennessee | 47091 | 4447 | 69 |
2134470 | 2134470 | 2022-01-20 | Johnson | Tennessee | 47091 | 4447 | 69 |
2131218 | 2131218 | 2022-01-19 | Johnson | Tennessee | 47091 | 4447 | 69 |
2020715 | 2020715 | 2021-12-16 | Scott | Tennessee | 47151 | 5919 | 69 |
2017464 | 2017464 | 2021-12-15 | Scott | Tennessee | 47151 | 5900 | 69 |
2014214 | 2014214 | 2021-12-14 | Scott | Tennessee | 47151 | 5860 | 69 |
2010963 | 2010963 | 2021-12-13 | Scott | Tennessee | 47151 | 5858 | 69 |
2010973 | 2010973 | 2021-12-13 | Unicoi | Tennessee | 47171 | 3317 | 69 |
2007712 | 2007712 | 2021-12-12 | Scott | Tennessee | 47151 | 5826 | 69 |
2007722 | 2007722 | 2021-12-12 | Unicoi | Tennessee | 47171 | 3309 | 69 |
2004461 | 2004461 | 2021-12-11 | Scott | Tennessee | 47151 | 5826 | 69 |
2004471 | 2004471 | 2021-12-11 | Unicoi | Tennessee | 47171 | 3309 | 69 |
2001210 | 2001210 | 2021-12-10 | Scott | Tennessee | 47151 | 5826 | 69 |
2001220 | 2001220 | 2021-12-10 | Unicoi | Tennessee | 47171 | 3309 | 69 |
1997960 | 1997960 | 2021-12-09 | Scott | Tennessee | 47151 | 5808 | 69 |
1997970 | 1997970 | 2021-12-09 | Unicoi | Tennessee | 47171 | 3291 | 69 |
1994709 | 1994709 | 2021-12-08 | Scott | Tennessee | 47151 | 5808 | 69 |
1994719 | 1994719 | 2021-12-08 | Unicoi | Tennessee | 47171 | 3291 | 69 |
1991458 | 1991458 | 2021-12-07 | Scott | Tennessee | 47151 | 5805 | 69 |
1991468 | 1991468 | 2021-12-07 | Unicoi | Tennessee | 47171 | 3282 | 69 |
1965406 | 1965406 | 2021-11-29 | Fentress | Tennessee | 47049 | 3779 | 69 |
1962154 | 1962154 | 2021-11-28 | Fentress | Tennessee | 47049 | 3763 | 69 |
1962178 | 1962178 | 2021-11-28 | Lauderdale | Tennessee | 47097 | 5258 | 69 |
1958903 | 1958903 | 2021-11-27 | Fentress | Tennessee | 47049 | 3763 | 69 |
1958927 | 1958927 | 2021-11-27 | Lauderdale | Tennessee | 47097 | 5258 | 69 |
1955652 | 1955652 | 2021-11-26 | Fentress | Tennessee | 47049 | 3763 | 69 |
1955676 | 1955676 | 2021-11-26 | Lauderdale | Tennessee | 47097 | 5258 | 69 |
1952401 | 1952401 | 2021-11-25 | Fentress | Tennessee | 47049 | 3763 | 69 |
1952425 | 1952425 | 2021-11-25 | Lauderdale | Tennessee | 47097 | 5258 | 69 |
1949150 | 1949150 | 2021-11-24 | Fentress | Tennessee | 47049 | 3763 | 69 |
1949174 | 1949174 | 2021-11-24 | Lauderdale | Tennessee | 47097 | 5258 | 69 |
1945923 | 1945923 | 2021-11-23 | Lauderdale | Tennessee | 47097 | 5258 | 69 |
1942672 | 1942672 | 2021-11-22 | Lauderdale | Tennessee | 47097 | 5253 | 69 |
1939422 | 1939422 | 2021-11-21 | Lauderdale | Tennessee | 47097 | 5248 | 69 |
1936172 | 1936172 | 2021-11-20 | Lauderdale | Tennessee | 47097 | 5248 | 69 |
1932922 | 1932922 | 2021-11-19 | Lauderdale | Tennessee | 47097 | 5248 | 69 |
1929671 | 1929671 | 2021-11-18 | Lauderdale | Tennessee | 47097 | 5248 | 69 |
1926421 | 1926421 | 2021-11-17 | Lauderdale | Tennessee | 47097 | 5247 | 69 |
1923171 | 1923171 | 2021-11-16 | Lauderdale | Tennessee | 47097 | 5245 | 69 |
1919922 | 1919922 | 2021-11-15 | Lauderdale | Tennessee | 47097 | 5241 | 69 |
1851695 | 1851695 | 2021-10-25 | McNairy | Tennessee | 47109 | 4594 | 69 |
1848445 | 1848445 | 2021-10-24 | McNairy | Tennessee | 47109 | 4594 | 69 |
1845195 | 1845195 | 2021-10-23 | McNairy | Tennessee | 47109 | 4594 | 69 |
1841945 | 1841945 | 2021-10-22 | McNairy | Tennessee | 47109 | 4594 | 69 |
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);