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 |
---|---|---|---|---|---|---|---|
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 |
1491136 | 1491136 | 2021-07-06 | Robertson | Tennessee | 47147 | 9986 | 141 |
1487889 | 1487889 | 2021-07-05 | Robertson | Tennessee | 47147 | 9974 | 141 |
1484642 | 1484642 | 2021-07-04 | Robertson | Tennessee | 47147 | 9974 | 141 |
1481396 | 1481396 | 2021-07-03 | Robertson | Tennessee | 47147 | 9974 | 141 |
1478149 | 1478149 | 2021-07-02 | Robertson | Tennessee | 47147 | 9974 | 141 |
1474903 | 1474903 | 2021-07-01 | Robertson | Tennessee | 47147 | 9966 | 141 |
1471657 | 1471657 | 2021-06-30 | Robertson | Tennessee | 47147 | 9965 | 141 |
1468412 | 1468412 | 2021-06-29 | Robertson | Tennessee | 47147 | 9962 | 141 |
1465167 | 1465167 | 2021-06-28 | Robertson | Tennessee | 47147 | 9961 | 141 |
1461922 | 1461922 | 2021-06-27 | Robertson | Tennessee | 47147 | 9957 | 141 |
1458677 | 1458677 | 2021-06-26 | Robertson | Tennessee | 47147 | 9957 | 141 |
1455432 | 1455432 | 2021-06-25 | Robertson | Tennessee | 47147 | 9957 | 141 |
1452187 | 1452187 | 2021-06-24 | Robertson | Tennessee | 47147 | 9957 | 140 |
1448941 | 1448941 | 2021-06-23 | Robertson | Tennessee | 47147 | 9956 | 140 |
1445696 | 1445696 | 2021-06-22 | Robertson | Tennessee | 47147 | 9953 | 140 |
1442451 | 1442451 | 2021-06-21 | Robertson | Tennessee | 47147 | 9953 | 140 |
1439206 | 1439206 | 2021-06-20 | Robertson | Tennessee | 47147 | 9947 | 140 |
1435959 | 1435959 | 2021-06-19 | Robertson | Tennessee | 47147 | 9947 | 140 |
1432712 | 1432712 | 2021-06-18 | Robertson | Tennessee | 47147 | 9947 | 140 |
1429466 | 1429466 | 2021-06-17 | Robertson | Tennessee | 47147 | 9947 | 139 |
1426221 | 1426221 | 2021-06-16 | Robertson | Tennessee | 47147 | 9946 | 139 |
1422974 | 1422974 | 2021-06-15 | Robertson | Tennessee | 47147 | 9946 | 139 |
1419728 | 1419728 | 2021-06-14 | Robertson | Tennessee | 47147 | 9929 | 132 |
1416483 | 1416483 | 2021-06-13 | Robertson | Tennessee | 47147 | 9929 | 132 |
1413237 | 1413237 | 2021-06-12 | Robertson | Tennessee | 47147 | 9929 | 132 |
1409992 | 1409992 | 2021-06-11 | Robertson | Tennessee | 47147 | 9929 | 132 |
1406747 | 1406747 | 2021-06-10 | Robertson | Tennessee | 47147 | 9854 | 132 |
1403501 | 1403501 | 2021-06-09 | Robertson | Tennessee | 47147 | 9850 | 132 |
1400256 | 1400256 | 2021-06-08 | Robertson | Tennessee | 47147 | 9850 | 132 |
1397011 | 1397011 | 2021-06-07 | Robertson | Tennessee | 47147 | 9849 | 132 |
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);