ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
347 rows where deaths = 78 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Macon 112
- Henderson 29
- Fayette 28
- Hickman 28
- Chester 16
- Overton 14
- Lincoln 10
- McNairy 9
- Morgan 7
- Warren 7
- Carroll 6
- Jefferson 6
- Lawrence 6
- White 6
- Hamilton 5
- Hardeman 5
- Hardin 5
- Madison 5
- Loudon 4
- Unicoi 4
- Wilson 4
- Claiborne 3
- Washington 3
- Weakley 3
- Dickson 2
- Hamblen 2
- Marion 2
- Obion 2
- Benton 1
- Campbell 1
- …
state 1
- Tennessee · 347 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2310121 | 2310121 | 2022-03-15 | Morgan | Tennessee | 47129 | 6145 | 78 |
2306868 | 2306868 | 2022-03-14 | Morgan | Tennessee | 47129 | 6145 | 78 |
2303617 | 2303617 | 2022-03-13 | Morgan | Tennessee | 47129 | 6145 | 78 |
2300365 | 2300365 | 2022-03-12 | Morgan | Tennessee | 47129 | 6145 | 78 |
2297113 | 2297113 | 2022-03-11 | Morgan | Tennessee | 47129 | 6145 | 78 |
2293861 | 2293861 | 2022-03-10 | Morgan | Tennessee | 47129 | 6145 | 78 |
2290609 | 2290609 | 2022-03-09 | Morgan | Tennessee | 47129 | 6145 | 78 |
2056393 | 2056393 | 2021-12-27 | Benton | Tennessee | 47005 | 3113 | 78 |
2053227 | 2053227 | 2021-12-26 | Unicoi | Tennessee | 47171 | 3375 | 78 |
2049977 | 2049977 | 2021-12-25 | Unicoi | Tennessee | 47171 | 3375 | 78 |
2046727 | 2046727 | 2021-12-24 | Unicoi | Tennessee | 47171 | 3375 | 78 |
2043477 | 2043477 | 2021-12-23 | Unicoi | Tennessee | 47171 | 3375 | 78 |
2036904 | 2036904 | 2021-12-21 | Chester | Tennessee | 47023 | 3700 | 78 |
2036948 | 2036948 | 2021-12-21 | Marion | Tennessee | 47115 | 6001 | 78 |
2036952 | 2036952 | 2021-12-21 | McNairy | Tennessee | 47109 | 4902 | 78 |
2033654 | 2033654 | 2021-12-20 | Chester | Tennessee | 47023 | 3694 | 78 |
2033698 | 2033698 | 2021-12-20 | Marion | Tennessee | 47115 | 5996 | 78 |
2033702 | 2033702 | 2021-12-20 | McNairy | Tennessee | 47109 | 4895 | 78 |
2030404 | 2030404 | 2021-12-19 | Chester | Tennessee | 47023 | 3675 | 78 |
2030452 | 2030452 | 2021-12-19 | McNairy | Tennessee | 47109 | 4881 | 78 |
2027153 | 2027153 | 2021-12-18 | Chester | Tennessee | 47023 | 3675 | 78 |
2027201 | 2027201 | 2021-12-18 | McNairy | Tennessee | 47109 | 4881 | 78 |
2023902 | 2023902 | 2021-12-17 | Chester | Tennessee | 47023 | 3675 | 78 |
2023950 | 2023950 | 2021-12-17 | McNairy | Tennessee | 47109 | 4881 | 78 |
2020651 | 2020651 | 2021-12-16 | Chester | Tennessee | 47023 | 3665 | 78 |
2020699 | 2020699 | 2021-12-16 | McNairy | Tennessee | 47109 | 4877 | 78 |
2017400 | 2017400 | 2021-12-15 | Chester | Tennessee | 47023 | 3656 | 78 |
2017448 | 2017448 | 2021-12-15 | McNairy | Tennessee | 47109 | 4864 | 78 |
2014150 | 2014150 | 2021-12-14 | Chester | Tennessee | 47023 | 3648 | 78 |
2014158 | 2014158 | 2021-12-14 | DeKalb | Tennessee | 47041 | 4382 | 78 |
2014198 | 2014198 | 2021-12-14 | McNairy | Tennessee | 47109 | 4861 | 78 |
2010899 | 2010899 | 2021-12-13 | Chester | Tennessee | 47023 | 3647 | 78 |
2010947 | 2010947 | 2021-12-13 | McNairy | Tennessee | 47109 | 4861 | 78 |
2007648 | 2007648 | 2021-12-12 | Chester | Tennessee | 47023 | 3640 | 78 |
2004397 | 2004397 | 2021-12-11 | Chester | Tennessee | 47023 | 3640 | 78 |
2001146 | 2001146 | 2021-12-10 | Chester | Tennessee | 47023 | 3640 | 78 |
1997896 | 1997896 | 2021-12-09 | Chester | Tennessee | 47023 | 3630 | 78 |
1994645 | 1994645 | 2021-12-08 | Chester | Tennessee | 47023 | 3630 | 78 |
1991394 | 1991394 | 2021-12-07 | Chester | Tennessee | 47023 | 3630 | 78 |
1988143 | 1988143 | 2021-12-06 | Chester | Tennessee | 47023 | 3627 | 78 |
1988172 | 1988172 | 2021-12-06 | Hickman | Tennessee | 47081 | 4818 | 78 |
1984922 | 1984922 | 2021-12-05 | Hickman | Tennessee | 47081 | 4799 | 78 |
1981672 | 1981672 | 2021-12-04 | Hickman | Tennessee | 47081 | 4799 | 78 |
1978422 | 1978422 | 2021-12-03 | Hickman | Tennessee | 47081 | 4799 | 78 |
1975172 | 1975172 | 2021-12-02 | Hickman | Tennessee | 47081 | 4786 | 78 |
1971920 | 1971920 | 2021-12-01 | Haywood | Tennessee | 47075 | 3920 | 78 |
1971923 | 1971923 | 2021-12-01 | Hickman | Tennessee | 47081 | 4772 | 78 |
1968673 | 1968673 | 2021-11-30 | Hickman | Tennessee | 47081 | 4758 | 78 |
1965422 | 1965422 | 2021-11-29 | Hickman | Tennessee | 47081 | 4754 | 78 |
1962170 | 1962170 | 2021-11-28 | Hickman | Tennessee | 47081 | 4726 | 78 |
1958919 | 1958919 | 2021-11-27 | Hickman | Tennessee | 47081 | 4726 | 78 |
1955668 | 1955668 | 2021-11-26 | Hickman | Tennessee | 47081 | 4726 | 78 |
1952417 | 1952417 | 2021-11-25 | Hickman | Tennessee | 47081 | 4726 | 78 |
1949166 | 1949166 | 2021-11-24 | Hickman | Tennessee | 47081 | 4726 | 78 |
1945915 | 1945915 | 2021-11-23 | Hickman | Tennessee | 47081 | 4725 | 78 |
1942664 | 1942664 | 2021-11-22 | Hickman | Tennessee | 47081 | 4722 | 78 |
1939414 | 1939414 | 2021-11-21 | Hickman | Tennessee | 47081 | 4707 | 78 |
1936164 | 1936164 | 2021-11-20 | Hickman | Tennessee | 47081 | 4707 | 78 |
1932914 | 1932914 | 2021-11-19 | Hickman | Tennessee | 47081 | 4707 | 78 |
1929663 | 1929663 | 2021-11-18 | Hickman | Tennessee | 47081 | 4697 | 78 |
1926413 | 1926413 | 2021-11-17 | Hickman | Tennessee | 47081 | 4690 | 78 |
1923163 | 1923163 | 2021-11-16 | Hickman | Tennessee | 47081 | 4677 | 78 |
1919914 | 1919914 | 2021-11-15 | Hickman | Tennessee | 47081 | 4669 | 78 |
1916664 | 1916664 | 2021-11-14 | Hickman | Tennessee | 47081 | 4656 | 78 |
1913414 | 1913414 | 2021-11-13 | Hickman | Tennessee | 47081 | 4656 | 78 |
1910164 | 1910164 | 2021-11-12 | Hickman | Tennessee | 47081 | 4656 | 78 |
1906915 | 1906915 | 2021-11-11 | Hickman | Tennessee | 47081 | 4648 | 78 |
1903666 | 1903666 | 2021-11-10 | Hickman | Tennessee | 47081 | 4648 | 78 |
1900416 | 1900416 | 2021-11-09 | Hickman | Tennessee | 47081 | 4642 | 78 |
1815960 | 1815960 | 2021-10-14 | Overton | Tennessee | 47133 | 4723 | 78 |
1812712 | 1812712 | 2021-10-13 | Overton | Tennessee | 47133 | 4715 | 78 |
1809403 | 1809403 | 2021-10-12 | Campbell | Tennessee | 47013 | 6892 | 78 |
1809463 | 1809463 | 2021-10-12 | Overton | Tennessee | 47133 | 4709 | 78 |
1806181 | 1806181 | 2021-10-11 | Hardeman | Tennessee | 47069 | 5050 | 78 |
1806213 | 1806213 | 2021-10-11 | Overton | Tennessee | 47133 | 4693 | 78 |
1802931 | 1802931 | 2021-10-10 | Hardeman | Tennessee | 47069 | 5039 | 78 |
1802963 | 1802963 | 2021-10-10 | Overton | Tennessee | 47133 | 4664 | 78 |
1799682 | 1799682 | 2021-10-09 | Hardeman | Tennessee | 47069 | 5039 | 78 |
1799714 | 1799714 | 2021-10-09 | Overton | Tennessee | 47133 | 4664 | 78 |
1796433 | 1796433 | 2021-10-08 | Hardeman | Tennessee | 47069 | 5039 | 78 |
1796465 | 1796465 | 2021-10-08 | Overton | Tennessee | 47133 | 4664 | 78 |
1793184 | 1793184 | 2021-10-07 | Hardeman | Tennessee | 47069 | 5030 | 78 |
1793216 | 1793216 | 2021-10-07 | Overton | Tennessee | 47133 | 4655 | 78 |
1789967 | 1789967 | 2021-10-06 | Overton | Tennessee | 47133 | 4645 | 78 |
1786719 | 1786719 | 2021-10-05 | Overton | Tennessee | 47133 | 4639 | 78 |
1783470 | 1783470 | 2021-10-04 | Overton | Tennessee | 47133 | 4637 | 78 |
1780221 | 1780221 | 2021-10-03 | Overton | Tennessee | 47133 | 4601 | 78 |
1776971 | 1776971 | 2021-10-02 | Overton | Tennessee | 47133 | 4601 | 78 |
1773721 | 1773721 | 2021-10-01 | Overton | Tennessee | 47133 | 4601 | 78 |
1757445 | 1757445 | 2021-09-26 | Hardin | Tennessee | 47071 | 5258 | 78 |
1757502 | 1757502 | 2021-09-26 | Weakley | Tennessee | 47183 | 5910 | 78 |
1754197 | 1754197 | 2021-09-25 | Hardin | Tennessee | 47071 | 5258 | 78 |
1754254 | 1754254 | 2021-09-25 | Weakley | Tennessee | 47183 | 5910 | 78 |
1750949 | 1750949 | 2021-09-24 | Hardin | Tennessee | 47071 | 5258 | 78 |
1751006 | 1751006 | 2021-09-24 | Weakley | Tennessee | 47183 | 5910 | 78 |
1747700 | 1747700 | 2021-09-23 | Hardin | Tennessee | 47071 | 5221 | 78 |
1747716 | 1747716 | 2021-09-23 | Lincoln | Tennessee | 47103 | 6269 | 78 |
1744450 | 1744450 | 2021-09-22 | Hardin | Tennessee | 47071 | 5207 | 78 |
1744466 | 1744466 | 2021-09-22 | Lincoln | Tennessee | 47103 | 6244 | 78 |
1741217 | 1741217 | 2021-09-21 | Lincoln | Tennessee | 47103 | 6162 | 78 |
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);