ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
341 rows where deaths = 54 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- McNairy 71
- DeKalb 44
- Scott 29
- Crockett 25
- Johnson 14
- Meigs 14
- Chester 13
- Marion 10
- Grainger 8
- Marshall 8
- Benton 7
- Bledsoe 7
- Perry 7
- Polk 7
- Cheatham 6
- Unicoi 6
- Hardeman 5
- Bedford 4
- Campbell 4
- Lincoln 4
- Madison 4
- Greene 3
- Sevier 3
- Weakley 3
- Hamilton 2
- Hardin 2
- Jefferson 2
- Lawrence 2
- McMinn 2
- Monroe 2
- …
state 1
- Tennessee · 341 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2332832 | 2332832 | 2022-03-22 | Bledsoe | Tennessee | 47007 | 4651 | 54 |
2332896 | 2332896 | 2022-03-22 | Perry | Tennessee | 47135 | 2327 | 54 |
2329579 | 2329579 | 2022-03-21 | Bledsoe | Tennessee | 47007 | 4651 | 54 |
2329643 | 2329643 | 2022-03-21 | Perry | Tennessee | 47135 | 2327 | 54 |
2326327 | 2326327 | 2022-03-20 | Bledsoe | Tennessee | 47007 | 4651 | 54 |
2326391 | 2326391 | 2022-03-20 | Perry | Tennessee | 47135 | 2327 | 54 |
2323074 | 2323074 | 2022-03-19 | Bledsoe | Tennessee | 47007 | 4651 | 54 |
2323138 | 2323138 | 2022-03-19 | Perry | Tennessee | 47135 | 2327 | 54 |
2319820 | 2319820 | 2022-03-18 | Bledsoe | Tennessee | 47007 | 4651 | 54 |
2319884 | 2319884 | 2022-03-18 | Perry | Tennessee | 47135 | 2327 | 54 |
2316566 | 2316566 | 2022-03-17 | Bledsoe | Tennessee | 47007 | 4651 | 54 |
2316630 | 2316630 | 2022-03-17 | Perry | Tennessee | 47135 | 2327 | 54 |
2313313 | 2313313 | 2022-03-16 | Bledsoe | Tennessee | 47007 | 4651 | 54 |
2313377 | 2313377 | 2022-03-16 | Perry | Tennessee | 47135 | 2327 | 54 |
2310117 | 2310117 | 2022-03-15 | Meigs | Tennessee | 47121 | 3347 | 54 |
2306864 | 2306864 | 2022-03-14 | Meigs | Tennessee | 47121 | 3347 | 54 |
2303613 | 2303613 | 2022-03-13 | Meigs | Tennessee | 47121 | 3347 | 54 |
2300361 | 2300361 | 2022-03-12 | Meigs | Tennessee | 47121 | 3347 | 54 |
2297109 | 2297109 | 2022-03-11 | Meigs | Tennessee | 47121 | 3347 | 54 |
2293857 | 2293857 | 2022-03-10 | Meigs | Tennessee | 47121 | 3347 | 54 |
2290605 | 2290605 | 2022-03-09 | Meigs | Tennessee | 47121 | 3347 | 54 |
2287353 | 2287353 | 2022-03-08 | Meigs | Tennessee | 47121 | 3345 | 54 |
2284101 | 2284101 | 2022-03-07 | Meigs | Tennessee | 47121 | 3345 | 54 |
2280849 | 2280849 | 2022-03-06 | Meigs | Tennessee | 47121 | 3345 | 54 |
2277596 | 2277596 | 2022-03-05 | Meigs | Tennessee | 47121 | 3345 | 54 |
2274343 | 2274343 | 2022-03-04 | Meigs | Tennessee | 47121 | 3345 | 54 |
2271090 | 2271090 | 2022-03-03 | Meigs | Tennessee | 47121 | 3345 | 54 |
2267838 | 2267838 | 2022-03-02 | Meigs | Tennessee | 47121 | 3345 | 54 |
2241838 | 2241838 | 2022-02-22 | Polk | Tennessee | 47139 | 4568 | 54 |
2238587 | 2238587 | 2022-02-21 | Polk | Tennessee | 47139 | 4568 | 54 |
2235336 | 2235336 | 2022-02-20 | Polk | Tennessee | 47139 | 4568 | 54 |
2232085 | 2232085 | 2022-02-19 | Polk | Tennessee | 47139 | 4568 | 54 |
2228834 | 2228834 | 2022-02-18 | Polk | Tennessee | 47139 | 4568 | 54 |
2225583 | 2225583 | 2022-02-17 | Polk | Tennessee | 47139 | 4568 | 54 |
2222332 | 2222332 | 2022-02-16 | Polk | Tennessee | 47139 | 4568 | 54 |
2033688 | 2033688 | 2021-12-20 | Johnson | Tennessee | 47091 | 4117 | 54 |
2030438 | 2030438 | 2021-12-19 | Johnson | Tennessee | 47091 | 4100 | 54 |
2027187 | 2027187 | 2021-12-18 | Johnson | Tennessee | 47091 | 4100 | 54 |
2023936 | 2023936 | 2021-12-17 | Johnson | Tennessee | 47091 | 4100 | 54 |
2020685 | 2020685 | 2021-12-16 | Johnson | Tennessee | 47091 | 4090 | 54 |
2017434 | 2017434 | 2021-12-15 | Johnson | Tennessee | 47091 | 4076 | 54 |
2014184 | 2014184 | 2021-12-14 | Johnson | Tennessee | 47091 | 4070 | 54 |
2010933 | 2010933 | 2021-12-13 | Johnson | Tennessee | 47091 | 4059 | 54 |
2007682 | 2007682 | 2021-12-12 | Johnson | Tennessee | 47091 | 4044 | 54 |
2004431 | 2004431 | 2021-12-11 | Johnson | Tennessee | 47091 | 4044 | 54 |
2001180 | 2001180 | 2021-12-10 | Johnson | Tennessee | 47091 | 4044 | 54 |
1997930 | 1997930 | 2021-12-09 | Johnson | Tennessee | 47091 | 4019 | 54 |
1994679 | 1994679 | 2021-12-08 | Johnson | Tennessee | 47091 | 4019 | 54 |
1991428 | 1991428 | 2021-12-07 | Johnson | Tennessee | 47091 | 4013 | 54 |
1906877 | 1906877 | 2021-11-11 | Benton | Tennessee | 47005 | 2861 | 54 |
1903628 | 1903628 | 2021-11-10 | Benton | Tennessee | 47005 | 2861 | 54 |
1900378 | 1900378 | 2021-11-09 | Benton | Tennessee | 47005 | 2850 | 54 |
1897128 | 1897128 | 2021-11-08 | Benton | Tennessee | 47005 | 2834 | 54 |
1893878 | 1893878 | 2021-11-07 | Benton | Tennessee | 47005 | 2834 | 54 |
1890628 | 1890628 | 2021-11-06 | Benton | Tennessee | 47005 | 2834 | 54 |
1887378 | 1887378 | 2021-11-05 | Benton | Tennessee | 47005 | 2834 | 54 |
1884181 | 1884181 | 2021-11-04 | Marion | Tennessee | 47115 | 5800 | 54 |
1880932 | 1880932 | 2021-11-03 | Marion | Tennessee | 47115 | 5797 | 54 |
1877683 | 1877683 | 2021-11-02 | Marion | Tennessee | 47115 | 5794 | 54 |
1874434 | 1874434 | 2021-11-01 | Marion | Tennessee | 47115 | 5783 | 54 |
1871185 | 1871185 | 2021-10-31 | Marion | Tennessee | 47115 | 5783 | 54 |
1867936 | 1867936 | 2021-10-30 | Marion | Tennessee | 47115 | 5783 | 54 |
1864687 | 1864687 | 2021-10-29 | Marion | Tennessee | 47115 | 5783 | 54 |
1861438 | 1861438 | 2021-10-28 | Marion | Tennessee | 47115 | 5770 | 54 |
1858189 | 1858189 | 2021-10-27 | Marion | Tennessee | 47115 | 5765 | 54 |
1854940 | 1854940 | 2021-10-26 | Marion | Tennessee | 47115 | 5762 | 54 |
1809472 | 1809472 | 2021-10-12 | Scott | Tennessee | 47151 | 4981 | 54 |
1806222 | 1806222 | 2021-10-11 | Scott | Tennessee | 47151 | 4955 | 54 |
1802972 | 1802972 | 2021-10-10 | Scott | Tennessee | 47151 | 4931 | 54 |
1799723 | 1799723 | 2021-10-09 | Scott | Tennessee | 47151 | 4931 | 54 |
1796474 | 1796474 | 2021-10-08 | Scott | Tennessee | 47151 | 4931 | 54 |
1793225 | 1793225 | 2021-10-07 | Scott | Tennessee | 47151 | 4917 | 54 |
1789976 | 1789976 | 2021-10-06 | Scott | Tennessee | 47151 | 4896 | 54 |
1786728 | 1786728 | 2021-10-05 | Scott | Tennessee | 47151 | 4878 | 54 |
1783479 | 1783479 | 2021-10-04 | Scott | Tennessee | 47151 | 4865 | 54 |
1780230 | 1780230 | 2021-10-03 | Scott | Tennessee | 47151 | 4827 | 54 |
1776980 | 1776980 | 2021-10-02 | Scott | Tennessee | 47151 | 4827 | 54 |
1773730 | 1773730 | 2021-10-01 | Scott | Tennessee | 47151 | 4827 | 54 |
1770480 | 1770480 | 2021-09-30 | Scott | Tennessee | 47151 | 4807 | 54 |
1767231 | 1767231 | 2021-09-29 | Scott | Tennessee | 47151 | 4783 | 54 |
1763982 | 1763982 | 2021-09-28 | Scott | Tennessee | 47151 | 4754 | 54 |
1760733 | 1760733 | 2021-09-27 | Scott | Tennessee | 47151 | 4731 | 54 |
1757485 | 1757485 | 2021-09-26 | Scott | Tennessee | 47151 | 4671 | 54 |
1754237 | 1754237 | 2021-09-25 | Scott | Tennessee | 47151 | 4671 | 54 |
1750989 | 1750989 | 2021-09-24 | Scott | Tennessee | 47151 | 4671 | 54 |
1747740 | 1747740 | 2021-09-23 | Scott | Tennessee | 47151 | 4600 | 54 |
1744490 | 1744490 | 2021-09-22 | Scott | Tennessee | 47151 | 4572 | 54 |
1741194 | 1741194 | 2021-09-21 | Grainger | Tennessee | 47057 | 3929 | 54 |
1741241 | 1741241 | 2021-09-21 | Scott | Tennessee | 47151 | 4541 | 54 |
1737945 | 1737945 | 2021-09-20 | Grainger | Tennessee | 47057 | 3929 | 54 |
1737992 | 1737992 | 2021-09-20 | Scott | Tennessee | 47151 | 4541 | 54 |
1734683 | 1734683 | 2021-09-19 | Crockett | Tennessee | 47033 | 3146 | 54 |
1734695 | 1734695 | 2021-09-19 | Grainger | Tennessee | 47057 | 3870 | 54 |
1734742 | 1734742 | 2021-09-19 | Scott | Tennessee | 47151 | 4439 | 54 |
1731433 | 1731433 | 2021-09-18 | Crockett | Tennessee | 47033 | 3146 | 54 |
1731445 | 1731445 | 2021-09-18 | Grainger | Tennessee | 47057 | 3870 | 54 |
1731492 | 1731492 | 2021-09-18 | Scott | Tennessee | 47151 | 4439 | 54 |
1728183 | 1728183 | 2021-09-17 | Crockett | Tennessee | 47033 | 3146 | 54 |
1728195 | 1728195 | 2021-09-17 | Grainger | Tennessee | 47057 | 3870 | 54 |
1728242 | 1728242 | 2021-09-17 | Scott | Tennessee | 47151 | 4439 | 54 |
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);