ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 47147 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1815967 | 1815967 | 2021-10-14 | Robertson | Tennessee | 47147 | 13917 | 175 |
1812719 | 1812719 | 2021-10-13 | Robertson | Tennessee | 47147 | 13900 | 175 |
1809470 | 1809470 | 2021-10-12 | Robertson | Tennessee | 47147 | 13880 | 175 |
1806220 | 1806220 | 2021-10-11 | Robertson | Tennessee | 47147 | 13866 | 175 |
1802970 | 1802970 | 2021-10-10 | Robertson | Tennessee | 47147 | 13814 | 175 |
1799721 | 1799721 | 2021-10-09 | Robertson | Tennessee | 47147 | 13814 | 175 |
1796472 | 1796472 | 2021-10-08 | Robertson | Tennessee | 47147 | 13814 | 175 |
1793223 | 1793223 | 2021-10-07 | Robertson | Tennessee | 47147 | 13784 | 175 |
1789974 | 1789974 | 2021-10-06 | Robertson | Tennessee | 47147 | 13756 | 175 |
1786726 | 1786726 | 2021-10-05 | Robertson | Tennessee | 47147 | 13739 | 175 |
1783477 | 1783477 | 2021-10-04 | Robertson | Tennessee | 47147 | 13723 | 175 |
1780228 | 1780228 | 2021-10-03 | Robertson | Tennessee | 47147 | 13665 | 175 |
1776978 | 1776978 | 2021-10-02 | Robertson | Tennessee | 47147 | 13665 | 175 |
1773728 | 1773728 | 2021-10-01 | Robertson | Tennessee | 47147 | 13665 | 175 |
1770478 | 1770478 | 2021-09-30 | Robertson | Tennessee | 47147 | 13628 | 172 |
1767229 | 1767229 | 2021-09-29 | Robertson | Tennessee | 47147 | 13592 | 171 |
1763980 | 1763980 | 2021-09-28 | Robertson | Tennessee | 47147 | 13554 | 170 |
1760731 | 1760731 | 2021-09-27 | Robertson | Tennessee | 47147 | 13524 | 170 |
1757483 | 1757483 | 2021-09-26 | Robertson | Tennessee | 47147 | 13440 | 170 |
1754235 | 1754235 | 2021-09-25 | Robertson | Tennessee | 47147 | 13440 | 170 |
1750987 | 1750987 | 2021-09-24 | Robertson | Tennessee | 47147 | 13440 | 170 |
1747738 | 1747738 | 2021-09-23 | Robertson | Tennessee | 47147 | 13394 | 170 |
1744488 | 1744488 | 2021-09-22 | Robertson | Tennessee | 47147 | 13336 | 170 |
1741239 | 1741239 | 2021-09-21 | Robertson | Tennessee | 47147 | 13229 | 166 |
1737990 | 1737990 | 2021-09-20 | Robertson | Tennessee | 47147 | 13229 | 166 |
1734740 | 1734740 | 2021-09-19 | Robertson | Tennessee | 47147 | 13108 | 163 |
1731490 | 1731490 | 2021-09-18 | Robertson | Tennessee | 47147 | 13108 | 163 |
1728240 | 1728240 | 2021-09-17 | Robertson | Tennessee | 47147 | 13108 | 163 |
1724991 | 1724991 | 2021-09-16 | Robertson | Tennessee | 47147 | 13046 | 163 |
1721742 | 1721742 | 2021-09-15 | Robertson | Tennessee | 47147 | 12995 | 161 |
1718494 | 1718494 | 2021-09-14 | Robertson | Tennessee | 47147 | 12890 | 161 |
1715246 | 1715246 | 2021-09-13 | Robertson | Tennessee | 47147 | 12829 | 160 |
1712000 | 1712000 | 2021-09-12 | Robertson | Tennessee | 47147 | 12509 | 160 |
1708753 | 1708753 | 2021-09-11 | Robertson | Tennessee | 47147 | 12509 | 160 |
1705506 | 1705506 | 2021-09-10 | Robertson | Tennessee | 47147 | 12509 | 160 |
1702256 | 1702256 | 2021-09-09 | Robertson | Tennessee | 47147 | 12454 | 160 |
1699007 | 1699007 | 2021-09-08 | Robertson | Tennessee | 47147 | 12414 | 159 |
1695759 | 1695759 | 2021-09-07 | Robertson | Tennessee | 47147 | 12364 | 158 |
1692511 | 1692511 | 2021-09-06 | Robertson | Tennessee | 47147 | 11955 | 153 |
1689262 | 1689262 | 2021-09-05 | Robertson | Tennessee | 47147 | 11955 | 153 |
1686012 | 1686012 | 2021-09-04 | Robertson | Tennessee | 47147 | 11955 | 153 |
1682761 | 1682761 | 2021-09-03 | Robertson | Tennessee | 47147 | 11955 | 153 |
1679511 | 1679511 | 2021-09-02 | Robertson | Tennessee | 47147 | 11901 | 152 |
1676263 | 1676263 | 2021-09-01 | Robertson | Tennessee | 47147 | 11878 | 150 |
1673016 | 1673016 | 2021-08-31 | Robertson | Tennessee | 47147 | 11770 | 149 |
1669768 | 1669768 | 2021-08-30 | Robertson | Tennessee | 47147 | 11671 | 149 |
1666521 | 1666521 | 2021-08-29 | Robertson | Tennessee | 47147 | 11477 | 146 |
1663273 | 1663273 | 2021-08-28 | Robertson | Tennessee | 47147 | 11477 | 146 |
1660025 | 1660025 | 2021-08-27 | Robertson | Tennessee | 47147 | 11477 | 146 |
1656776 | 1656776 | 2021-08-26 | Robertson | Tennessee | 47147 | 11382 | 146 |
1653529 | 1653529 | 2021-08-25 | Robertson | Tennessee | 47147 | 11264 | 145 |
1650282 | 1650282 | 2021-08-24 | Robertson | Tennessee | 47147 | 11264 | 145 |
1647033 | 1647033 | 2021-08-23 | Robertson | Tennessee | 47147 | 11212 | 145 |
1643784 | 1643784 | 2021-08-22 | Robertson | Tennessee | 47147 | 10972 | 145 |
1640534 | 1640534 | 2021-08-21 | Robertson | Tennessee | 47147 | 10972 | 145 |
1637284 | 1637284 | 2021-08-20 | Robertson | Tennessee | 47147 | 10972 | 145 |
1634034 | 1634034 | 2021-08-19 | Robertson | Tennessee | 47147 | 10907 | 145 |
1630787 | 1630787 | 2021-08-18 | Robertson | Tennessee | 47147 | 10843 | 145 |
1627540 | 1627540 | 2021-08-17 | Robertson | Tennessee | 47147 | 10795 | 145 |
1624293 | 1624293 | 2021-08-16 | Robertson | Tennessee | 47147 | 10768 | 145 |
1621046 | 1621046 | 2021-08-15 | Robertson | Tennessee | 47147 | 10639 | 145 |
1617798 | 1617798 | 2021-08-14 | Robertson | Tennessee | 47147 | 10639 | 145 |
1614550 | 1614550 | 2021-08-13 | Robertson | Tennessee | 47147 | 10639 | 145 |
1611301 | 1611301 | 2021-08-12 | Robertson | Tennessee | 47147 | 10589 | 145 |
1608053 | 1608053 | 2021-08-11 | Robertson | Tennessee | 47147 | 10536 | 145 |
1604804 | 1604804 | 2021-08-10 | Robertson | Tennessee | 47147 | 10497 | 145 |
1601555 | 1601555 | 2021-08-09 | Robertson | Tennessee | 47147 | 10475 | 145 |
1598307 | 1598307 | 2021-08-08 | Robertson | Tennessee | 47147 | 10369 | 145 |
1595058 | 1595058 | 2021-08-07 | Robertson | Tennessee | 47147 | 10369 | 145 |
1591809 | 1591809 | 2021-08-06 | Robertson | Tennessee | 47147 | 10369 | 145 |
1588560 | 1588560 | 2021-08-05 | Robertson | Tennessee | 47147 | 10329 | 144 |
1585310 | 1585310 | 2021-08-04 | Robertson | Tennessee | 47147 | 10298 | 144 |
1582060 | 1582060 | 2021-08-03 | Robertson | Tennessee | 47147 | 10260 | 144 |
1578811 | 1578811 | 2021-08-02 | Robertson | Tennessee | 47147 | 10241 | 144 |
1575563 | 1575563 | 2021-08-01 | Robertson | Tennessee | 47147 | 10197 | 143 |
1572315 | 1572315 | 2021-07-31 | Robertson | Tennessee | 47147 | 10197 | 143 |
1569067 | 1569067 | 2021-07-30 | Robertson | Tennessee | 47147 | 10197 | 143 |
1565819 | 1565819 | 2021-07-29 | Robertson | Tennessee | 47147 | 10186 | 142 |
1562571 | 1562571 | 2021-07-28 | Robertson | Tennessee | 47147 | 10164 | 142 |
1559323 | 1559323 | 2021-07-27 | Robertson | Tennessee | 47147 | 10141 | 142 |
1556076 | 1556076 | 2021-07-26 | Robertson | Tennessee | 47147 | 10127 | 142 |
1552829 | 1552829 | 2021-07-25 | Robertson | Tennessee | 47147 | 10103 | 142 |
1549582 | 1549582 | 2021-07-24 | Robertson | Tennessee | 47147 | 10103 | 142 |
1546335 | 1546335 | 2021-07-23 | Robertson | Tennessee | 47147 | 10103 | 142 |
1543088 | 1543088 | 2021-07-22 | Robertson | Tennessee | 47147 | 10099 | 142 |
1539840 | 1539840 | 2021-07-21 | Robertson | Tennessee | 47147 | 10084 | 142 |
1536593 | 1536593 | 2021-07-20 | Robertson | Tennessee | 47147 | 10079 | 141 |
1533345 | 1533345 | 2021-07-19 | Robertson | Tennessee | 47147 | 10069 | 141 |
1530098 | 1530098 | 2021-07-18 | Robertson | Tennessee | 47147 | 10048 | 141 |
1526851 | 1526851 | 2021-07-17 | Robertson | Tennessee | 47147 | 10048 | 141 |
1523604 | 1523604 | 2021-07-16 | Robertson | Tennessee | 47147 | 10048 | 141 |
1520356 | 1520356 | 2021-07-15 | Robertson | Tennessee | 47147 | 10040 | 141 |
1517108 | 1517108 | 2021-07-14 | Robertson | Tennessee | 47147 | 10032 | 141 |
1513861 | 1513861 | 2021-07-13 | Robertson | Tennessee | 47147 | 10025 | 141 |
1510615 | 1510615 | 2021-07-12 | Robertson | Tennessee | 47147 | 10018 | 141 |
1507368 | 1507368 | 2021-07-11 | Robertson | Tennessee | 47147 | 10003 | 141 |
1504122 | 1504122 | 2021-07-10 | Robertson | Tennessee | 47147 | 10003 | 141 |
1500876 | 1500876 | 2021-07-09 | Robertson | Tennessee | 47147 | 10003 | 141 |
1497630 | 1497630 | 2021-07-08 | Robertson | Tennessee | 47147 | 10000 | 141 |
1494383 | 1494383 | 2021-07-07 | Robertson | Tennessee | 47147 | 9991 | 141 |
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);