ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Franklin" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1832164 | 1832164 | 2021-10-19 | Franklin | Tennessee | 47051 | 7862 | 100 |
1828915 | 1828915 | 2021-10-18 | Franklin | Tennessee | 47051 | 7854 | 100 |
1825666 | 1825666 | 2021-10-17 | Franklin | Tennessee | 47051 | 7838 | 100 |
1822417 | 1822417 | 2021-10-16 | Franklin | Tennessee | 47051 | 7838 | 100 |
1819168 | 1819168 | 2021-10-15 | Franklin | Tennessee | 47051 | 7838 | 100 |
1815919 | 1815919 | 2021-10-14 | Franklin | Tennessee | 47051 | 7834 | 100 |
1812671 | 1812671 | 2021-10-13 | Franklin | Tennessee | 47051 | 7813 | 100 |
1809422 | 1809422 | 2021-10-12 | Franklin | Tennessee | 47051 | 7798 | 100 |
1806172 | 1806172 | 2021-10-11 | Franklin | Tennessee | 47051 | 7761 | 99 |
1802922 | 1802922 | 2021-10-10 | Franklin | Tennessee | 47051 | 7735 | 100 |
1799673 | 1799673 | 2021-10-09 | Franklin | Tennessee | 47051 | 7735 | 100 |
1796424 | 1796424 | 2021-10-08 | Franklin | Tennessee | 47051 | 7735 | 100 |
1793175 | 1793175 | 2021-10-07 | Franklin | Tennessee | 47051 | 7710 | 99 |
1789926 | 1789926 | 2021-10-06 | Franklin | Tennessee | 47051 | 7700 | 99 |
1786678 | 1786678 | 2021-10-05 | Franklin | Tennessee | 47051 | 7695 | 99 |
1783429 | 1783429 | 2021-10-04 | Franklin | Tennessee | 47051 | 7679 | 99 |
1780180 | 1780180 | 2021-10-03 | Franklin | Tennessee | 47051 | 7645 | 98 |
1776930 | 1776930 | 2021-10-02 | Franklin | Tennessee | 47051 | 7645 | 98 |
1773680 | 1773680 | 2021-10-01 | Franklin | Tennessee | 47051 | 7645 | 98 |
1770430 | 1770430 | 2021-09-30 | Franklin | Tennessee | 47051 | 7633 | 97 |
1767181 | 1767181 | 2021-09-29 | Franklin | Tennessee | 47051 | 7609 | 97 |
1763932 | 1763932 | 2021-09-28 | Franklin | Tennessee | 47051 | 7585 | 96 |
1760683 | 1760683 | 2021-09-27 | Franklin | Tennessee | 47051 | 7567 | 96 |
1757435 | 1757435 | 2021-09-26 | Franklin | Tennessee | 47051 | 7531 | 96 |
1754187 | 1754187 | 2021-09-25 | Franklin | Tennessee | 47051 | 7531 | 96 |
1750939 | 1750939 | 2021-09-24 | Franklin | Tennessee | 47051 | 7531 | 96 |
1747690 | 1747690 | 2021-09-23 | Franklin | Tennessee | 47051 | 7503 | 96 |
1744440 | 1744440 | 2021-09-22 | Franklin | Tennessee | 47051 | 7481 | 96 |
1741191 | 1741191 | 2021-09-21 | Franklin | Tennessee | 47051 | 7413 | 95 |
1737942 | 1737942 | 2021-09-20 | Franklin | Tennessee | 47051 | 7413 | 95 |
1734692 | 1734692 | 2021-09-19 | Franklin | Tennessee | 47051 | 7347 | 95 |
1731442 | 1731442 | 2021-09-18 | Franklin | Tennessee | 47051 | 7347 | 95 |
1728192 | 1728192 | 2021-09-17 | Franklin | Tennessee | 47051 | 7347 | 95 |
1724943 | 1724943 | 2021-09-16 | Franklin | Tennessee | 47051 | 7299 | 95 |
1721694 | 1721694 | 2021-09-15 | Franklin | Tennessee | 47051 | 7248 | 95 |
1718446 | 1718446 | 2021-09-14 | Franklin | Tennessee | 47051 | 7213 | 94 |
1715198 | 1715198 | 2021-09-13 | Franklin | Tennessee | 47051 | 7189 | 94 |
1711952 | 1711952 | 2021-09-12 | Franklin | Tennessee | 47051 | 6966 | 94 |
1708705 | 1708705 | 2021-09-11 | Franklin | Tennessee | 47051 | 6966 | 94 |
1705458 | 1705458 | 2021-09-10 | Franklin | Tennessee | 47051 | 6966 | 94 |
1702208 | 1702208 | 2021-09-09 | Franklin | Tennessee | 47051 | 6937 | 94 |
1698959 | 1698959 | 2021-09-08 | Franklin | Tennessee | 47051 | 6896 | 94 |
1695711 | 1695711 | 2021-09-07 | Franklin | Tennessee | 47051 | 6863 | 94 |
1692463 | 1692463 | 2021-09-06 | Franklin | Tennessee | 47051 | 6614 | 94 |
1689214 | 1689214 | 2021-09-05 | Franklin | Tennessee | 47051 | 6614 | 94 |
1685964 | 1685964 | 2021-09-04 | Franklin | Tennessee | 47051 | 6614 | 94 |
1682713 | 1682713 | 2021-09-03 | Franklin | Tennessee | 47051 | 6614 | 94 |
1679463 | 1679463 | 2021-09-02 | Franklin | Tennessee | 47051 | 6585 | 93 |
1676215 | 1676215 | 2021-09-01 | Franklin | Tennessee | 47051 | 6578 | 93 |
1672968 | 1672968 | 2021-08-31 | Franklin | Tennessee | 47051 | 6499 | 93 |
1669720 | 1669720 | 2021-08-30 | Franklin | Tennessee | 47051 | 6455 | 93 |
1666473 | 1666473 | 2021-08-29 | Franklin | Tennessee | 47051 | 6281 | 93 |
1663225 | 1663225 | 2021-08-28 | Franklin | Tennessee | 47051 | 6281 | 93 |
1659977 | 1659977 | 2021-08-27 | Franklin | Tennessee | 47051 | 6281 | 93 |
1656728 | 1656728 | 2021-08-26 | Franklin | Tennessee | 47051 | 6216 | 93 |
1653481 | 1653481 | 2021-08-25 | Franklin | Tennessee | 47051 | 6115 | 93 |
1650234 | 1650234 | 2021-08-24 | Franklin | Tennessee | 47051 | 6115 | 93 |
1646985 | 1646985 | 2021-08-23 | Franklin | Tennessee | 47051 | 6078 | 92 |
1643736 | 1643736 | 2021-08-22 | Franklin | Tennessee | 47051 | 5933 | 92 |
1640486 | 1640486 | 2021-08-21 | Franklin | Tennessee | 47051 | 5933 | 92 |
1637236 | 1637236 | 2021-08-20 | Franklin | Tennessee | 47051 | 5933 | 92 |
1633986 | 1633986 | 2021-08-19 | Franklin | Tennessee | 47051 | 5873 | 92 |
1630739 | 1630739 | 2021-08-18 | Franklin | Tennessee | 47051 | 5825 | 92 |
1627492 | 1627492 | 2021-08-17 | Franklin | Tennessee | 47051 | 5785 | 92 |
1624245 | 1624245 | 2021-08-16 | Franklin | Tennessee | 47051 | 5762 | 92 |
1620998 | 1620998 | 2021-08-15 | Franklin | Tennessee | 47051 | 5704 | 92 |
1617750 | 1617750 | 2021-08-14 | Franklin | Tennessee | 47051 | 5704 | 92 |
1614502 | 1614502 | 2021-08-13 | Franklin | Tennessee | 47051 | 5704 | 92 |
1611253 | 1611253 | 2021-08-12 | Franklin | Tennessee | 47051 | 5673 | 92 |
1608005 | 1608005 | 2021-08-11 | Franklin | Tennessee | 47051 | 5640 | 92 |
1604756 | 1604756 | 2021-08-10 | Franklin | Tennessee | 47051 | 5600 | 92 |
1601507 | 1601507 | 2021-08-09 | Franklin | Tennessee | 47051 | 5568 | 92 |
1598259 | 1598259 | 2021-08-08 | Franklin | Tennessee | 47051 | 5536 | 92 |
1595010 | 1595010 | 2021-08-07 | Franklin | Tennessee | 47051 | 5536 | 92 |
1591761 | 1591761 | 2021-08-06 | Franklin | Tennessee | 47051 | 5536 | 92 |
1588512 | 1588512 | 2021-08-05 | Franklin | Tennessee | 47051 | 5515 | 92 |
1585262 | 1585262 | 2021-08-04 | Franklin | Tennessee | 47051 | 5505 | 92 |
1582012 | 1582012 | 2021-08-03 | Franklin | Tennessee | 47051 | 5494 | 92 |
1578763 | 1578763 | 2021-08-02 | Franklin | Tennessee | 47051 | 5479 | 92 |
1575515 | 1575515 | 2021-08-01 | Franklin | Tennessee | 47051 | 5451 | 92 |
1572267 | 1572267 | 2021-07-31 | Franklin | Tennessee | 47051 | 5451 | 92 |
1569019 | 1569019 | 2021-07-30 | Franklin | Tennessee | 47051 | 5451 | 92 |
1565771 | 1565771 | 2021-07-29 | Franklin | Tennessee | 47051 | 5443 | 92 |
1562523 | 1562523 | 2021-07-28 | Franklin | Tennessee | 47051 | 5422 | 92 |
1559275 | 1559275 | 2021-07-27 | Franklin | Tennessee | 47051 | 5408 | 92 |
1556028 | 1556028 | 2021-07-26 | Franklin | Tennessee | 47051 | 5396 | 92 |
1552781 | 1552781 | 2021-07-25 | Franklin | Tennessee | 47051 | 5375 | 92 |
1549534 | 1549534 | 2021-07-24 | Franklin | Tennessee | 47051 | 5375 | 92 |
1546287 | 1546287 | 2021-07-23 | Franklin | Tennessee | 47051 | 5375 | 92 |
1543040 | 1543040 | 2021-07-22 | Franklin | Tennessee | 47051 | 5362 | 92 |
1539792 | 1539792 | 2021-07-21 | Franklin | Tennessee | 47051 | 5350 | 92 |
1536545 | 1536545 | 2021-07-20 | Franklin | Tennessee | 47051 | 5316 | 92 |
1533297 | 1533297 | 2021-07-19 | Franklin | Tennessee | 47051 | 5304 | 92 |
1530050 | 1530050 | 2021-07-18 | Franklin | Tennessee | 47051 | 5289 | 92 |
1526803 | 1526803 | 2021-07-17 | Franklin | Tennessee | 47051 | 5289 | 92 |
1523556 | 1523556 | 2021-07-16 | Franklin | Tennessee | 47051 | 5289 | 92 |
1520308 | 1520308 | 2021-07-15 | Franklin | Tennessee | 47051 | 5287 | 92 |
1517060 | 1517060 | 2021-07-14 | Franklin | Tennessee | 47051 | 5279 | 92 |
1513813 | 1513813 | 2021-07-13 | Franklin | Tennessee | 47051 | 5273 | 92 |
1510567 | 1510567 | 2021-07-12 | Franklin | Tennessee | 47051 | 5266 | 92 |
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);