ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Tipton" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1815977 | 1815977 | 2021-10-14 | Tipton | Tennessee | 47167 | 11215 | 126 |
1812729 | 1812729 | 2021-10-13 | Tipton | Tennessee | 47167 | 11207 | 126 |
1809480 | 1809480 | 2021-10-12 | Tipton | Tennessee | 47167 | 11184 | 126 |
1806230 | 1806230 | 2021-10-11 | Tipton | Tennessee | 47167 | 11161 | 126 |
1802980 | 1802980 | 2021-10-10 | Tipton | Tennessee | 47167 | 11116 | 126 |
1799731 | 1799731 | 2021-10-09 | Tipton | Tennessee | 47167 | 11116 | 126 |
1796482 | 1796482 | 2021-10-08 | Tipton | Tennessee | 47167 | 11116 | 126 |
1793233 | 1793233 | 2021-10-07 | Tipton | Tennessee | 47167 | 11085 | 126 |
1789984 | 1789984 | 2021-10-06 | Tipton | Tennessee | 47167 | 11053 | 126 |
1786736 | 1786736 | 2021-10-05 | Tipton | Tennessee | 47167 | 11037 | 126 |
1783487 | 1783487 | 2021-10-04 | Tipton | Tennessee | 47167 | 11024 | 126 |
1780238 | 1780238 | 2021-10-03 | Tipton | Tennessee | 47167 | 10971 | 125 |
1776988 | 1776988 | 2021-10-02 | Tipton | Tennessee | 47167 | 10971 | 125 |
1773738 | 1773738 | 2021-10-01 | Tipton | Tennessee | 47167 | 10971 | 125 |
1770488 | 1770488 | 2021-09-30 | Tipton | Tennessee | 47167 | 10942 | 125 |
1767239 | 1767239 | 2021-09-29 | Tipton | Tennessee | 47167 | 10918 | 125 |
1763990 | 1763990 | 2021-09-28 | Tipton | Tennessee | 47167 | 10872 | 125 |
1760741 | 1760741 | 2021-09-27 | Tipton | Tennessee | 47167 | 10855 | 124 |
1757493 | 1757493 | 2021-09-26 | Tipton | Tennessee | 47167 | 10792 | 124 |
1754245 | 1754245 | 2021-09-25 | Tipton | Tennessee | 47167 | 10792 | 124 |
1750997 | 1750997 | 2021-09-24 | Tipton | Tennessee | 47167 | 10792 | 124 |
1747748 | 1747748 | 2021-09-23 | Tipton | Tennessee | 47167 | 10752 | 123 |
1744498 | 1744498 | 2021-09-22 | Tipton | Tennessee | 47167 | 10718 | 117 |
1741249 | 1741249 | 2021-09-21 | Tipton | Tennessee | 47167 | 10644 | 117 |
1738000 | 1738000 | 2021-09-20 | Tipton | Tennessee | 47167 | 10644 | 117 |
1734750 | 1734750 | 2021-09-19 | Tipton | Tennessee | 47167 | 10541 | 115 |
1731500 | 1731500 | 2021-09-18 | Tipton | Tennessee | 47167 | 10541 | 115 |
1728250 | 1728250 | 2021-09-17 | Tipton | Tennessee | 47167 | 10541 | 115 |
1725001 | 1725001 | 2021-09-16 | Tipton | Tennessee | 47167 | 10483 | 115 |
1721752 | 1721752 | 2021-09-15 | Tipton | Tennessee | 47167 | 10450 | 115 |
1718504 | 1718504 | 2021-09-14 | Tipton | Tennessee | 47167 | 10414 | 115 |
1715256 | 1715256 | 2021-09-13 | Tipton | Tennessee | 47167 | 10378 | 115 |
1712010 | 1712010 | 2021-09-12 | Tipton | Tennessee | 47167 | 10165 | 115 |
1708763 | 1708763 | 2021-09-11 | Tipton | Tennessee | 47167 | 10165 | 115 |
1705516 | 1705516 | 2021-09-10 | Tipton | Tennessee | 47167 | 10165 | 115 |
1702266 | 1702266 | 2021-09-09 | Tipton | Tennessee | 47167 | 10098 | 115 |
1699017 | 1699017 | 2021-09-08 | Tipton | Tennessee | 47167 | 10064 | 112 |
1695769 | 1695769 | 2021-09-07 | Tipton | Tennessee | 47167 | 10039 | 112 |
1692521 | 1692521 | 2021-09-06 | Tipton | Tennessee | 47167 | 9693 | 112 |
1689272 | 1689272 | 2021-09-05 | Tipton | Tennessee | 47167 | 9693 | 112 |
1686022 | 1686022 | 2021-09-04 | Tipton | Tennessee | 47167 | 9693 | 112 |
1682771 | 1682771 | 2021-09-03 | Tipton | Tennessee | 47167 | 9693 | 112 |
1679521 | 1679521 | 2021-09-02 | Tipton | Tennessee | 47167 | 9621 | 112 |
1676273 | 1676273 | 2021-09-01 | Tipton | Tennessee | 47167 | 9590 | 112 |
1673026 | 1673026 | 2021-08-31 | Tipton | Tennessee | 47167 | 9521 | 111 |
1669778 | 1669778 | 2021-08-30 | Tipton | Tennessee | 47167 | 9434 | 110 |
1666531 | 1666531 | 2021-08-29 | Tipton | Tennessee | 47167 | 9232 | 110 |
1663283 | 1663283 | 2021-08-28 | Tipton | Tennessee | 47167 | 9232 | 110 |
1660035 | 1660035 | 2021-08-27 | Tipton | Tennessee | 47167 | 9232 | 110 |
1656786 | 1656786 | 2021-08-26 | Tipton | Tennessee | 47167 | 9158 | 109 |
1653539 | 1653539 | 2021-08-25 | Tipton | Tennessee | 47167 | 9053 | 109 |
1650292 | 1650292 | 2021-08-24 | Tipton | Tennessee | 47167 | 9053 | 109 |
1647043 | 1647043 | 2021-08-23 | Tipton | Tennessee | 47167 | 9001 | 109 |
1643794 | 1643794 | 2021-08-22 | Tipton | Tennessee | 47167 | 8787 | 109 |
1640544 | 1640544 | 2021-08-21 | Tipton | Tennessee | 47167 | 8787 | 109 |
1637294 | 1637294 | 2021-08-20 | Tipton | Tennessee | 47167 | 8787 | 109 |
1634044 | 1634044 | 2021-08-19 | Tipton | Tennessee | 47167 | 8714 | 109 |
1630797 | 1630797 | 2021-08-18 | Tipton | Tennessee | 47167 | 8647 | 108 |
1627550 | 1627550 | 2021-08-17 | Tipton | Tennessee | 47167 | 8608 | 107 |
1624303 | 1624303 | 2021-08-16 | Tipton | Tennessee | 47167 | 8568 | 107 |
1621056 | 1621056 | 2021-08-15 | Tipton | Tennessee | 47167 | 8436 | 107 |
1617808 | 1617808 | 2021-08-14 | Tipton | Tennessee | 47167 | 8436 | 107 |
1614560 | 1614560 | 2021-08-13 | Tipton | Tennessee | 47167 | 8436 | 107 |
1611311 | 1611311 | 2021-08-12 | Tipton | Tennessee | 47167 | 8393 | 107 |
1608063 | 1608063 | 2021-08-11 | Tipton | Tennessee | 47167 | 8335 | 106 |
1604814 | 1604814 | 2021-08-10 | Tipton | Tennessee | 47167 | 8279 | 106 |
1601565 | 1601565 | 2021-08-09 | Tipton | Tennessee | 47167 | 8251 | 106 |
1598317 | 1598317 | 2021-08-08 | Tipton | Tennessee | 47167 | 8112 | 106 |
1595068 | 1595068 | 2021-08-07 | Tipton | Tennessee | 47167 | 8112 | 106 |
1591819 | 1591819 | 2021-08-06 | Tipton | Tennessee | 47167 | 8112 | 106 |
1588570 | 1588570 | 2021-08-05 | Tipton | Tennessee | 47167 | 8079 | 106 |
1585320 | 1585320 | 2021-08-04 | Tipton | Tennessee | 47167 | 8052 | 106 |
1582070 | 1582070 | 2021-08-03 | Tipton | Tennessee | 47167 | 8001 | 106 |
1578821 | 1578821 | 2021-08-02 | Tipton | Tennessee | 47167 | 7982 | 106 |
1575573 | 1575573 | 2021-08-01 | Tipton | Tennessee | 47167 | 7898 | 106 |
1572325 | 1572325 | 2021-07-31 | Tipton | Tennessee | 47167 | 7898 | 106 |
1569077 | 1569077 | 2021-07-30 | Tipton | Tennessee | 47167 | 7898 | 106 |
1565829 | 1565829 | 2021-07-29 | Tipton | Tennessee | 47167 | 7872 | 106 |
1562581 | 1562581 | 2021-07-28 | Tipton | Tennessee | 47167 | 7826 | 104 |
1559333 | 1559333 | 2021-07-27 | Tipton | Tennessee | 47167 | 7783 | 103 |
1556086 | 1556086 | 2021-07-26 | Tipton | Tennessee | 47167 | 7747 | 103 |
1552839 | 1552839 | 2021-07-25 | Tipton | Tennessee | 47167 | 7685 | 104 |
1549592 | 1549592 | 2021-07-24 | Tipton | Tennessee | 47167 | 7685 | 104 |
1546345 | 1546345 | 2021-07-23 | Tipton | Tennessee | 47167 | 7685 | 104 |
1543098 | 1543098 | 2021-07-22 | Tipton | Tennessee | 47167 | 7659 | 104 |
1539850 | 1539850 | 2021-07-21 | Tipton | Tennessee | 47167 | 7634 | 104 |
1536603 | 1536603 | 2021-07-20 | Tipton | Tennessee | 47167 | 7615 | 104 |
1533355 | 1533355 | 2021-07-19 | Tipton | Tennessee | 47167 | 7600 | 104 |
1530108 | 1530108 | 2021-07-18 | Tipton | Tennessee | 47167 | 7566 | 104 |
1526861 | 1526861 | 2021-07-17 | Tipton | Tennessee | 47167 | 7566 | 104 |
1523614 | 1523614 | 2021-07-16 | Tipton | Tennessee | 47167 | 7566 | 104 |
1520366 | 1520366 | 2021-07-15 | Tipton | Tennessee | 47167 | 7551 | 104 |
1517118 | 1517118 | 2021-07-14 | Tipton | Tennessee | 47167 | 7541 | 104 |
1513871 | 1513871 | 2021-07-13 | Tipton | Tennessee | 47167 | 7527 | 104 |
1510625 | 1510625 | 2021-07-12 | Tipton | Tennessee | 47167 | 7519 | 104 |
1507378 | 1507378 | 2021-07-11 | Tipton | Tennessee | 47167 | 7502 | 104 |
1504132 | 1504132 | 2021-07-10 | Tipton | Tennessee | 47167 | 7502 | 104 |
1500886 | 1500886 | 2021-07-09 | Tipton | Tennessee | 47167 | 7502 | 104 |
1497640 | 1497640 | 2021-07-08 | Tipton | Tennessee | 47167 | 7495 | 104 |
1494393 | 1494393 | 2021-07-07 | Tipton | Tennessee | 47167 | 7488 | 104 |
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);