ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 47047 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1815917 | 1815917 | 2021-10-14 | Fayette | Tennessee | 47047 | 7215 | 100 |
1812669 | 1812669 | 2021-10-13 | Fayette | Tennessee | 47047 | 7208 | 100 |
1809420 | 1809420 | 2021-10-12 | Fayette | Tennessee | 47047 | 7196 | 100 |
1806170 | 1806170 | 2021-10-11 | Fayette | Tennessee | 47047 | 7182 | 100 |
1802920 | 1802920 | 2021-10-10 | Fayette | Tennessee | 47047 | 7157 | 100 |
1799671 | 1799671 | 2021-10-09 | Fayette | Tennessee | 47047 | 7157 | 100 |
1796422 | 1796422 | 2021-10-08 | Fayette | Tennessee | 47047 | 7157 | 100 |
1793173 | 1793173 | 2021-10-07 | Fayette | Tennessee | 47047 | 7141 | 99 |
1789924 | 1789924 | 2021-10-06 | Fayette | Tennessee | 47047 | 7128 | 97 |
1786676 | 1786676 | 2021-10-05 | Fayette | Tennessee | 47047 | 7116 | 97 |
1783427 | 1783427 | 2021-10-04 | Fayette | Tennessee | 47047 | 7107 | 97 |
1780178 | 1780178 | 2021-10-03 | Fayette | Tennessee | 47047 | 7071 | 97 |
1776928 | 1776928 | 2021-10-02 | Fayette | Tennessee | 47047 | 7071 | 97 |
1773678 | 1773678 | 2021-10-01 | Fayette | Tennessee | 47047 | 7071 | 97 |
1770428 | 1770428 | 2021-09-30 | Fayette | Tennessee | 47047 | 7055 | 97 |
1767179 | 1767179 | 2021-09-29 | Fayette | Tennessee | 47047 | 7036 | 97 |
1763930 | 1763930 | 2021-09-28 | Fayette | Tennessee | 47047 | 7014 | 97 |
1760681 | 1760681 | 2021-09-27 | Fayette | Tennessee | 47047 | 6998 | 97 |
1757433 | 1757433 | 2021-09-26 | Fayette | Tennessee | 47047 | 6962 | 96 |
1754185 | 1754185 | 2021-09-25 | Fayette | Tennessee | 47047 | 6962 | 96 |
1750937 | 1750937 | 2021-09-24 | Fayette | Tennessee | 47047 | 6962 | 96 |
1747688 | 1747688 | 2021-09-23 | Fayette | Tennessee | 47047 | 6938 | 95 |
1744438 | 1744438 | 2021-09-22 | Fayette | Tennessee | 47047 | 6917 | 94 |
1741189 | 1741189 | 2021-09-21 | Fayette | Tennessee | 47047 | 6889 | 94 |
1737940 | 1737940 | 2021-09-20 | Fayette | Tennessee | 47047 | 6889 | 94 |
1734690 | 1734690 | 2021-09-19 | Fayette | Tennessee | 47047 | 6837 | 93 |
1731440 | 1731440 | 2021-09-18 | Fayette | Tennessee | 47047 | 6837 | 93 |
1728190 | 1728190 | 2021-09-17 | Fayette | Tennessee | 47047 | 6837 | 93 |
1724941 | 1724941 | 2021-09-16 | Fayette | Tennessee | 47047 | 6790 | 93 |
1721692 | 1721692 | 2021-09-15 | Fayette | Tennessee | 47047 | 6770 | 93 |
1718444 | 1718444 | 2021-09-14 | Fayette | Tennessee | 47047 | 6736 | 93 |
1715196 | 1715196 | 2021-09-13 | Fayette | Tennessee | 47047 | 6726 | 93 |
1711950 | 1711950 | 2021-09-12 | Fayette | Tennessee | 47047 | 6585 | 93 |
1708703 | 1708703 | 2021-09-11 | Fayette | Tennessee | 47047 | 6585 | 93 |
1705456 | 1705456 | 2021-09-10 | Fayette | Tennessee | 47047 | 6585 | 93 |
1702206 | 1702206 | 2021-09-09 | Fayette | Tennessee | 47047 | 6567 | 93 |
1698957 | 1698957 | 2021-09-08 | Fayette | Tennessee | 47047 | 6550 | 90 |
1695709 | 1695709 | 2021-09-07 | Fayette | Tennessee | 47047 | 6534 | 90 |
1692461 | 1692461 | 2021-09-06 | Fayette | Tennessee | 47047 | 6344 | 90 |
1689212 | 1689212 | 2021-09-05 | Fayette | Tennessee | 47047 | 6344 | 90 |
1685962 | 1685962 | 2021-09-04 | Fayette | Tennessee | 47047 | 6344 | 90 |
1682711 | 1682711 | 2021-09-03 | Fayette | Tennessee | 47047 | 6344 | 90 |
1679461 | 1679461 | 2021-09-02 | Fayette | Tennessee | 47047 | 6303 | 88 |
1676213 | 1676213 | 2021-09-01 | Fayette | Tennessee | 47047 | 6299 | 87 |
1672966 | 1672966 | 2021-08-31 | Fayette | Tennessee | 47047 | 6254 | 87 |
1669718 | 1669718 | 2021-08-30 | Fayette | Tennessee | 47047 | 6203 | 87 |
1666471 | 1666471 | 2021-08-29 | Fayette | Tennessee | 47047 | 6123 | 86 |
1663223 | 1663223 | 2021-08-28 | Fayette | Tennessee | 47047 | 6123 | 86 |
1659975 | 1659975 | 2021-08-27 | Fayette | Tennessee | 47047 | 6123 | 86 |
1656726 | 1656726 | 2021-08-26 | Fayette | Tennessee | 47047 | 6067 | 86 |
1653479 | 1653479 | 2021-08-25 | Fayette | Tennessee | 47047 | 6024 | 86 |
1650232 | 1650232 | 2021-08-24 | Fayette | Tennessee | 47047 | 6024 | 86 |
1646983 | 1646983 | 2021-08-23 | Fayette | Tennessee | 47047 | 6003 | 86 |
1643734 | 1643734 | 2021-08-22 | Fayette | Tennessee | 47047 | 5901 | 85 |
1640484 | 1640484 | 2021-08-21 | Fayette | Tennessee | 47047 | 5901 | 85 |
1637234 | 1637234 | 2021-08-20 | Fayette | Tennessee | 47047 | 5901 | 85 |
1633984 | 1633984 | 2021-08-19 | Fayette | Tennessee | 47047 | 5882 | 85 |
1630737 | 1630737 | 2021-08-18 | Fayette | Tennessee | 47047 | 5850 | 85 |
1627490 | 1627490 | 2021-08-17 | Fayette | Tennessee | 47047 | 5821 | 85 |
1624243 | 1624243 | 2021-08-16 | Fayette | Tennessee | 47047 | 5804 | 85 |
1620996 | 1620996 | 2021-08-15 | Fayette | Tennessee | 47047 | 5738 | 85 |
1617748 | 1617748 | 2021-08-14 | Fayette | Tennessee | 47047 | 5738 | 85 |
1614500 | 1614500 | 2021-08-13 | Fayette | Tennessee | 47047 | 5738 | 85 |
1611251 | 1611251 | 2021-08-12 | Fayette | Tennessee | 47047 | 5704 | 85 |
1608003 | 1608003 | 2021-08-11 | Fayette | Tennessee | 47047 | 5674 | 83 |
1604754 | 1604754 | 2021-08-10 | Fayette | Tennessee | 47047 | 5644 | 83 |
1601505 | 1601505 | 2021-08-09 | Fayette | Tennessee | 47047 | 5620 | 83 |
1598257 | 1598257 | 2021-08-08 | Fayette | Tennessee | 47047 | 5550 | 83 |
1595008 | 1595008 | 2021-08-07 | Fayette | Tennessee | 47047 | 5550 | 83 |
1591759 | 1591759 | 2021-08-06 | Fayette | Tennessee | 47047 | 5550 | 83 |
1588510 | 1588510 | 2021-08-05 | Fayette | Tennessee | 47047 | 5519 | 83 |
1585260 | 1585260 | 2021-08-04 | Fayette | Tennessee | 47047 | 5498 | 83 |
1582010 | 1582010 | 2021-08-03 | Fayette | Tennessee | 47047 | 5476 | 83 |
1578761 | 1578761 | 2021-08-02 | Fayette | Tennessee | 47047 | 5464 | 83 |
1575513 | 1575513 | 2021-08-01 | Fayette | Tennessee | 47047 | 5414 | 83 |
1572265 | 1572265 | 2021-07-31 | Fayette | Tennessee | 47047 | 5414 | 83 |
1569017 | 1569017 | 2021-07-30 | Fayette | Tennessee | 47047 | 5414 | 83 |
1565769 | 1565769 | 2021-07-29 | Fayette | Tennessee | 47047 | 5393 | 83 |
1562521 | 1562521 | 2021-07-28 | Fayette | Tennessee | 47047 | 5381 | 83 |
1559273 | 1559273 | 2021-07-27 | Fayette | Tennessee | 47047 | 5368 | 83 |
1556026 | 1556026 | 2021-07-26 | Fayette | Tennessee | 47047 | 5354 | 83 |
1552779 | 1552779 | 2021-07-25 | Fayette | Tennessee | 47047 | 5333 | 83 |
1549532 | 1549532 | 2021-07-24 | Fayette | Tennessee | 47047 | 5333 | 83 |
1546285 | 1546285 | 2021-07-23 | Fayette | Tennessee | 47047 | 5333 | 83 |
1543038 | 1543038 | 2021-07-22 | Fayette | Tennessee | 47047 | 5322 | 83 |
1539790 | 1539790 | 2021-07-21 | Fayette | Tennessee | 47047 | 5307 | 83 |
1536543 | 1536543 | 2021-07-20 | Fayette | Tennessee | 47047 | 5302 | 83 |
1533295 | 1533295 | 2021-07-19 | Fayette | Tennessee | 47047 | 5293 | 83 |
1530048 | 1530048 | 2021-07-18 | Fayette | Tennessee | 47047 | 5276 | 83 |
1526801 | 1526801 | 2021-07-17 | Fayette | Tennessee | 47047 | 5276 | 83 |
1523554 | 1523554 | 2021-07-16 | Fayette | Tennessee | 47047 | 5276 | 83 |
1520306 | 1520306 | 2021-07-15 | Fayette | Tennessee | 47047 | 5271 | 83 |
1517058 | 1517058 | 2021-07-14 | Fayette | Tennessee | 47047 | 5268 | 83 |
1513811 | 1513811 | 2021-07-13 | Fayette | Tennessee | 47047 | 5259 | 83 |
1510565 | 1510565 | 2021-07-12 | Fayette | Tennessee | 47047 | 5255 | 83 |
1507318 | 1507318 | 2021-07-11 | Fayette | Tennessee | 47047 | 5242 | 83 |
1504072 | 1504072 | 2021-07-10 | Fayette | Tennessee | 47047 | 5242 | 83 |
1500826 | 1500826 | 2021-07-09 | Fayette | Tennessee | 47047 | 5242 | 83 |
1497580 | 1497580 | 2021-07-08 | Fayette | Tennessee | 47047 | 5238 | 83 |
1494333 | 1494333 | 2021-07-07 | Fayette | Tennessee | 47047 | 5233 | 83 |
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);