ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
578 rows where deaths = 25 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Polk 80
- Meigs 56
- Lewis 43
- Perry 26
- Stewart 24
- Hardin 22
- Van Buren 21
- Moore 16
- Union 15
- Crockett 14
- Hardeman 13
- DeKalb 12
- Macon 12
- Trousdale 11
- Haywood 10
- Chester 9
- Hamblen 8
- Henderson 8
- Marion 8
- Weakley 8
- Williamson 8
- Anderson 7
- Jefferson 7
- Pickett 7
- Cannon 6
- Lake 6
- McMinn 6
- Robertson 6
- Sullivan 6
- Clay 5
- …
state 1
- Tennessee · 578 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2020703 | 2020703 | 2021-12-16 | Moore | Tennessee | 47127 | 1483 | 25 |
2017452 | 2017452 | 2021-12-15 | Moore | Tennessee | 47127 | 1482 | 25 |
2014202 | 2014202 | 2021-12-14 | Moore | Tennessee | 47127 | 1480 | 25 |
2010951 | 2010951 | 2021-12-13 | Moore | Tennessee | 47127 | 1477 | 25 |
2007700 | 2007700 | 2021-12-12 | Moore | Tennessee | 47127 | 1474 | 25 |
2004449 | 2004449 | 2021-12-11 | Moore | Tennessee | 47127 | 1474 | 25 |
2001198 | 2001198 | 2021-12-10 | Moore | Tennessee | 47127 | 1474 | 25 |
1997948 | 1997948 | 2021-12-09 | Moore | Tennessee | 47127 | 1471 | 25 |
1994697 | 1994697 | 2021-12-08 | Moore | Tennessee | 47127 | 1471 | 25 |
1991446 | 1991446 | 2021-12-07 | Moore | Tennessee | 47127 | 1468 | 25 |
1988195 | 1988195 | 2021-12-06 | Moore | Tennessee | 47127 | 1467 | 25 |
1984945 | 1984945 | 2021-12-05 | Moore | Tennessee | 47127 | 1465 | 25 |
1981695 | 1981695 | 2021-12-04 | Moore | Tennessee | 47127 | 1465 | 25 |
1978445 | 1978445 | 2021-12-03 | Moore | Tennessee | 47127 | 1465 | 25 |
1975195 | 1975195 | 2021-12-02 | Moore | Tennessee | 47127 | 1463 | 25 |
1971946 | 1971946 | 2021-12-01 | Moore | Tennessee | 47127 | 1464 | 25 |
1945943 | 1945943 | 2021-11-23 | Pickett | Tennessee | 47137 | 1121 | 25 |
1942692 | 1942692 | 2021-11-22 | Pickett | Tennessee | 47137 | 1116 | 25 |
1939442 | 1939442 | 2021-11-21 | Pickett | Tennessee | 47137 | 1111 | 25 |
1936192 | 1936192 | 2021-11-20 | Pickett | Tennessee | 47137 | 1111 | 25 |
1932942 | 1932942 | 2021-11-19 | Pickett | Tennessee | 47137 | 1111 | 25 |
1929691 | 1929691 | 2021-11-18 | Pickett | Tennessee | 47137 | 1108 | 25 |
1926441 | 1926441 | 2021-11-17 | Pickett | Tennessee | 47137 | 1106 | 25 |
1828974 | 1828974 | 2021-10-18 | Trousdale | Tennessee | 47169 | 3142 | 25 |
1825725 | 1825725 | 2021-10-17 | Trousdale | Tennessee | 47169 | 3137 | 25 |
1822476 | 1822476 | 2021-10-16 | Trousdale | Tennessee | 47169 | 3137 | 25 |
1819227 | 1819227 | 2021-10-15 | Trousdale | Tennessee | 47169 | 3137 | 25 |
1815978 | 1815978 | 2021-10-14 | Trousdale | Tennessee | 47169 | 3132 | 25 |
1812730 | 1812730 | 2021-10-13 | Trousdale | Tennessee | 47169 | 3128 | 25 |
1809481 | 1809481 | 2021-10-12 | Trousdale | Tennessee | 47169 | 3123 | 25 |
1806231 | 1806231 | 2021-10-11 | Trousdale | Tennessee | 47169 | 3121 | 25 |
1802981 | 1802981 | 2021-10-10 | Trousdale | Tennessee | 47169 | 3104 | 25 |
1799732 | 1799732 | 2021-10-09 | Trousdale | Tennessee | 47169 | 3104 | 25 |
1796483 | 1796483 | 2021-10-08 | Trousdale | Tennessee | 47169 | 3104 | 25 |
1780243 | 1780243 | 2021-10-03 | Van Buren | Tennessee | 47175 | 1181 | 25 |
1776993 | 1776993 | 2021-10-02 | Van Buren | Tennessee | 47175 | 1181 | 25 |
1773743 | 1773743 | 2021-10-01 | Van Buren | Tennessee | 47175 | 1181 | 25 |
1770493 | 1770493 | 2021-09-30 | Van Buren | Tennessee | 47175 | 1174 | 25 |
1767244 | 1767244 | 2021-09-29 | Van Buren | Tennessee | 47175 | 1170 | 25 |
1763967 | 1763967 | 2021-09-28 | Meigs | Tennessee | 47121 | 2079 | 25 |
1763995 | 1763995 | 2021-09-28 | Van Buren | Tennessee | 47175 | 1164 | 25 |
1760718 | 1760718 | 2021-09-27 | Meigs | Tennessee | 47121 | 2074 | 25 |
1760727 | 1760727 | 2021-09-27 | Polk | Tennessee | 47139 | 2999 | 25 |
1760746 | 1760746 | 2021-09-27 | Van Buren | Tennessee | 47175 | 1165 | 25 |
1757470 | 1757470 | 2021-09-26 | Meigs | Tennessee | 47121 | 2064 | 25 |
1757479 | 1757479 | 2021-09-26 | Polk | Tennessee | 47139 | 2984 | 25 |
1757498 | 1757498 | 2021-09-26 | Van Buren | Tennessee | 47175 | 1154 | 25 |
1754222 | 1754222 | 2021-09-25 | Meigs | Tennessee | 47121 | 2064 | 25 |
1754231 | 1754231 | 2021-09-25 | Polk | Tennessee | 47139 | 2984 | 25 |
1754250 | 1754250 | 2021-09-25 | Van Buren | Tennessee | 47175 | 1154 | 25 |
1750974 | 1750974 | 2021-09-24 | Meigs | Tennessee | 47121 | 2064 | 25 |
1750983 | 1750983 | 2021-09-24 | Polk | Tennessee | 47139 | 2984 | 25 |
1751002 | 1751002 | 2021-09-24 | Van Buren | Tennessee | 47175 | 1154 | 25 |
1747725 | 1747725 | 2021-09-23 | Meigs | Tennessee | 47121 | 2059 | 25 |
1747734 | 1747734 | 2021-09-23 | Polk | Tennessee | 47139 | 2974 | 25 |
1747753 | 1747753 | 2021-09-23 | Van Buren | Tennessee | 47175 | 1149 | 25 |
1744475 | 1744475 | 2021-09-22 | Meigs | Tennessee | 47121 | 2052 | 25 |
1744484 | 1744484 | 2021-09-22 | Polk | Tennessee | 47139 | 2967 | 25 |
1744503 | 1744503 | 2021-09-22 | Van Buren | Tennessee | 47175 | 1148 | 25 |
1741235 | 1741235 | 2021-09-21 | Polk | Tennessee | 47139 | 2947 | 25 |
1741254 | 1741254 | 2021-09-21 | Van Buren | Tennessee | 47175 | 1139 | 25 |
1737986 | 1737986 | 2021-09-20 | Polk | Tennessee | 47139 | 2947 | 25 |
1738005 | 1738005 | 2021-09-20 | Van Buren | Tennessee | 47175 | 1139 | 25 |
1734736 | 1734736 | 2021-09-19 | Polk | Tennessee | 47139 | 2912 | 25 |
1734755 | 1734755 | 2021-09-19 | Van Buren | Tennessee | 47175 | 1126 | 25 |
1731486 | 1731486 | 2021-09-18 | Polk | Tennessee | 47139 | 2912 | 25 |
1731505 | 1731505 | 2021-09-18 | Van Buren | Tennessee | 47175 | 1126 | 25 |
1728236 | 1728236 | 2021-09-17 | Polk | Tennessee | 47139 | 2912 | 25 |
1728255 | 1728255 | 2021-09-17 | Van Buren | Tennessee | 47175 | 1126 | 25 |
1724987 | 1724987 | 2021-09-16 | Polk | Tennessee | 47139 | 2895 | 25 |
1725006 | 1725006 | 2021-09-16 | Van Buren | Tennessee | 47175 | 1109 | 25 |
1721738 | 1721738 | 2021-09-15 | Polk | Tennessee | 47139 | 2879 | 25 |
1721757 | 1721757 | 2021-09-15 | Van Buren | Tennessee | 47175 | 1105 | 25 |
1718490 | 1718490 | 2021-09-14 | Polk | Tennessee | 47139 | 2857 | 25 |
1718509 | 1718509 | 2021-09-14 | Van Buren | Tennessee | 47175 | 1094 | 25 |
1715242 | 1715242 | 2021-09-13 | Polk | Tennessee | 47139 | 2847 | 25 |
1715261 | 1715261 | 2021-09-13 | Van Buren | Tennessee | 47175 | 1087 | 25 |
1711996 | 1711996 | 2021-09-12 | Polk | Tennessee | 47139 | 2759 | 25 |
1708749 | 1708749 | 2021-09-11 | Polk | Tennessee | 47139 | 2759 | 25 |
1705502 | 1705502 | 2021-09-10 | Polk | Tennessee | 47139 | 2759 | 25 |
1702252 | 1702252 | 2021-09-09 | Polk | Tennessee | 47139 | 2747 | 25 |
1699003 | 1699003 | 2021-09-08 | Polk | Tennessee | 47139 | 2735 | 25 |
1695755 | 1695755 | 2021-09-07 | Polk | Tennessee | 47139 | 2719 | 25 |
1692507 | 1692507 | 2021-09-06 | Polk | Tennessee | 47139 | 2586 | 25 |
1689258 | 1689258 | 2021-09-05 | Polk | Tennessee | 47139 | 2586 | 25 |
1686008 | 1686008 | 2021-09-04 | Polk | Tennessee | 47139 | 2586 | 25 |
1682757 | 1682757 | 2021-09-03 | Polk | Tennessee | 47139 | 2586 | 25 |
1679507 | 1679507 | 2021-09-02 | Polk | Tennessee | 47139 | 2568 | 25 |
1676259 | 1676259 | 2021-09-01 | Polk | Tennessee | 47139 | 2562 | 25 |
1673012 | 1673012 | 2021-08-31 | Polk | Tennessee | 47139 | 2538 | 25 |
1669764 | 1669764 | 2021-08-30 | Polk | Tennessee | 47139 | 2514 | 25 |
1666517 | 1666517 | 2021-08-29 | Polk | Tennessee | 47139 | 2468 | 25 |
1663269 | 1663269 | 2021-08-28 | Polk | Tennessee | 47139 | 2468 | 25 |
1660021 | 1660021 | 2021-08-27 | Polk | Tennessee | 47139 | 2468 | 25 |
1656772 | 1656772 | 2021-08-26 | Polk | Tennessee | 47139 | 2449 | 25 |
1653525 | 1653525 | 2021-08-25 | Polk | Tennessee | 47139 | 2427 | 25 |
1650278 | 1650278 | 2021-08-24 | Polk | Tennessee | 47139 | 2427 | 25 |
1647029 | 1647029 | 2021-08-23 | Polk | Tennessee | 47139 | 2407 | 25 |
1643780 | 1643780 | 2021-08-22 | Polk | Tennessee | 47139 | 2368 | 25 |
1640530 | 1640530 | 2021-08-21 | Polk | Tennessee | 47139 | 2368 | 25 |
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);