ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 47149 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1815968 | 1815968 | 2021-10-14 | Rutherford | Tennessee | 47149 | 60995 | 525 |
1812720 | 1812720 | 2021-10-13 | Rutherford | Tennessee | 47149 | 60909 | 525 |
1809471 | 1809471 | 2021-10-12 | Rutherford | Tennessee | 47149 | 60802 | 524 |
1806221 | 1806221 | 2021-10-11 | Rutherford | Tennessee | 47149 | 60734 | 522 |
1802971 | 1802971 | 2021-10-10 | Rutherford | Tennessee | 47149 | 60556 | 522 |
1799722 | 1799722 | 2021-10-09 | Rutherford | Tennessee | 47149 | 60556 | 522 |
1796473 | 1796473 | 2021-10-08 | Rutherford | Tennessee | 47149 | 60556 | 522 |
1793224 | 1793224 | 2021-10-07 | Rutherford | Tennessee | 47149 | 60387 | 521 |
1789975 | 1789975 | 2021-10-06 | Rutherford | Tennessee | 47149 | 60287 | 521 |
1786727 | 1786727 | 2021-10-05 | Rutherford | Tennessee | 47149 | 60203 | 521 |
1783478 | 1783478 | 2021-10-04 | Rutherford | Tennessee | 47149 | 60163 | 519 |
1780229 | 1780229 | 2021-10-03 | Rutherford | Tennessee | 47149 | 59925 | 518 |
1776979 | 1776979 | 2021-10-02 | Rutherford | Tennessee | 47149 | 59925 | 518 |
1773729 | 1773729 | 2021-10-01 | Rutherford | Tennessee | 47149 | 59925 | 518 |
1770479 | 1770479 | 2021-09-30 | Rutherford | Tennessee | 47149 | 59776 | 514 |
1767230 | 1767230 | 2021-09-29 | Rutherford | Tennessee | 47149 | 59603 | 514 |
1763981 | 1763981 | 2021-09-28 | Rutherford | Tennessee | 47149 | 59479 | 514 |
1760732 | 1760732 | 2021-09-27 | Rutherford | Tennessee | 47149 | 59392 | 510 |
1757484 | 1757484 | 2021-09-26 | Rutherford | Tennessee | 47149 | 59040 | 502 |
1754236 | 1754236 | 2021-09-25 | Rutherford | Tennessee | 47149 | 59040 | 502 |
1750988 | 1750988 | 2021-09-24 | Rutherford | Tennessee | 47149 | 59040 | 502 |
1747739 | 1747739 | 2021-09-23 | Rutherford | Tennessee | 47149 | 58882 | 500 |
1744489 | 1744489 | 2021-09-22 | Rutherford | Tennessee | 47149 | 58721 | 499 |
1741240 | 1741240 | 2021-09-21 | Rutherford | Tennessee | 47149 | 58372 | 492 |
1737991 | 1737991 | 2021-09-20 | Rutherford | Tennessee | 47149 | 58372 | 492 |
1734741 | 1734741 | 2021-09-19 | Rutherford | Tennessee | 47149 | 57681 | 488 |
1731491 | 1731491 | 2021-09-18 | Rutherford | Tennessee | 47149 | 57681 | 488 |
1728241 | 1728241 | 2021-09-17 | Rutherford | Tennessee | 47149 | 57681 | 488 |
1724992 | 1724992 | 2021-09-16 | Rutherford | Tennessee | 47149 | 57465 | 487 |
1721743 | 1721743 | 2021-09-15 | Rutherford | Tennessee | 47149 | 57271 | 485 |
1718495 | 1718495 | 2021-09-14 | Rutherford | Tennessee | 47149 | 56834 | 483 |
1715247 | 1715247 | 2021-09-13 | Rutherford | Tennessee | 47149 | 56648 | 479 |
1712001 | 1712001 | 2021-09-12 | Rutherford | Tennessee | 47149 | 55172 | 478 |
1708754 | 1708754 | 2021-09-11 | Rutherford | Tennessee | 47149 | 55172 | 478 |
1705507 | 1705507 | 2021-09-10 | Rutherford | Tennessee | 47149 | 55172 | 478 |
1702257 | 1702257 | 2021-09-09 | Rutherford | Tennessee | 47149 | 54973 | 478 |
1699008 | 1699008 | 2021-09-08 | Rutherford | Tennessee | 47149 | 54731 | 475 |
1695760 | 1695760 | 2021-09-07 | Rutherford | Tennessee | 47149 | 54545 | 475 |
1692512 | 1692512 | 2021-09-06 | Rutherford | Tennessee | 47149 | 52410 | 475 |
1689263 | 1689263 | 2021-09-05 | Rutherford | Tennessee | 47149 | 52410 | 475 |
1686013 | 1686013 | 2021-09-04 | Rutherford | Tennessee | 47149 | 52410 | 475 |
1682762 | 1682762 | 2021-09-03 | Rutherford | Tennessee | 47149 | 52410 | 475 |
1679512 | 1679512 | 2021-09-02 | Rutherford | Tennessee | 47149 | 52186 | 474 |
1676264 | 1676264 | 2021-09-01 | Rutherford | Tennessee | 47149 | 52127 | 473 |
1673017 | 1673017 | 2021-08-31 | Rutherford | Tennessee | 47149 | 51683 | 473 |
1669769 | 1669769 | 2021-08-30 | Rutherford | Tennessee | 47149 | 51144 | 471 |
1666522 | 1666522 | 2021-08-29 | Rutherford | Tennessee | 47149 | 50229 | 470 |
1663274 | 1663274 | 2021-08-28 | Rutherford | Tennessee | 47149 | 50229 | 470 |
1660026 | 1660026 | 2021-08-27 | Rutherford | Tennessee | 47149 | 50229 | 470 |
1656777 | 1656777 | 2021-08-26 | Rutherford | Tennessee | 47149 | 49845 | 468 |
1653530 | 1653530 | 2021-08-25 | Rutherford | Tennessee | 47149 | 49384 | 466 |
1650283 | 1650283 | 2021-08-24 | Rutherford | Tennessee | 47149 | 49384 | 466 |
1647034 | 1647034 | 2021-08-23 | Rutherford | Tennessee | 47149 | 49187 | 463 |
1643785 | 1643785 | 2021-08-22 | Rutherford | Tennessee | 47149 | 48277 | 462 |
1640535 | 1640535 | 2021-08-21 | Rutherford | Tennessee | 47149 | 48277 | 462 |
1637285 | 1637285 | 2021-08-20 | Rutherford | Tennessee | 47149 | 48277 | 462 |
1634035 | 1634035 | 2021-08-19 | Rutherford | Tennessee | 47149 | 47996 | 462 |
1630788 | 1630788 | 2021-08-18 | Rutherford | Tennessee | 47149 | 47755 | 458 |
1627541 | 1627541 | 2021-08-17 | Rutherford | Tennessee | 47149 | 47538 | 458 |
1624294 | 1624294 | 2021-08-16 | Rutherford | Tennessee | 47149 | 47405 | 458 |
1621047 | 1621047 | 2021-08-15 | Rutherford | Tennessee | 47149 | 46828 | 458 |
1617799 | 1617799 | 2021-08-14 | Rutherford | Tennessee | 47149 | 46828 | 458 |
1614551 | 1614551 | 2021-08-13 | Rutherford | Tennessee | 47149 | 46828 | 458 |
1611302 | 1611302 | 2021-08-12 | Rutherford | Tennessee | 47149 | 46664 | 458 |
1608054 | 1608054 | 2021-08-11 | Rutherford | Tennessee | 47149 | 46383 | 458 |
1604805 | 1604805 | 2021-08-10 | Rutherford | Tennessee | 47149 | 46205 | 458 |
1601556 | 1601556 | 2021-08-09 | Rutherford | Tennessee | 47149 | 46075 | 453 |
1598308 | 1598308 | 2021-08-08 | Rutherford | Tennessee | 47149 | 45709 | 453 |
1595059 | 1595059 | 2021-08-07 | Rutherford | Tennessee | 47149 | 45709 | 453 |
1591810 | 1591810 | 2021-08-06 | Rutherford | Tennessee | 47149 | 45709 | 453 |
1588561 | 1588561 | 2021-08-05 | Rutherford | Tennessee | 47149 | 45554 | 452 |
1585311 | 1585311 | 2021-08-04 | Rutherford | Tennessee | 47149 | 45428 | 452 |
1582061 | 1582061 | 2021-08-03 | Rutherford | Tennessee | 47149 | 45298 | 452 |
1578812 | 1578812 | 2021-08-02 | Rutherford | Tennessee | 47149 | 45177 | 452 |
1575564 | 1575564 | 2021-08-01 | Rutherford | Tennessee | 47149 | 44884 | 452 |
1572316 | 1572316 | 2021-07-31 | Rutherford | Tennessee | 47149 | 44884 | 452 |
1569068 | 1569068 | 2021-07-30 | Rutherford | Tennessee | 47149 | 44884 | 452 |
1565820 | 1565820 | 2021-07-29 | Rutherford | Tennessee | 47149 | 44775 | 453 |
1562572 | 1562572 | 2021-07-28 | Rutherford | Tennessee | 47149 | 44636 | 453 |
1559324 | 1559324 | 2021-07-27 | Rutherford | Tennessee | 47149 | 44558 | 453 |
1556077 | 1556077 | 2021-07-26 | Rutherford | Tennessee | 47149 | 44470 | 452 |
1552830 | 1552830 | 2021-07-25 | Rutherford | Tennessee | 47149 | 44291 | 451 |
1549583 | 1549583 | 2021-07-24 | Rutherford | Tennessee | 47149 | 44291 | 451 |
1546336 | 1546336 | 2021-07-23 | Rutherford | Tennessee | 47149 | 44291 | 451 |
1543089 | 1543089 | 2021-07-22 | Rutherford | Tennessee | 47149 | 44215 | 451 |
1539841 | 1539841 | 2021-07-21 | Rutherford | Tennessee | 47149 | 44154 | 451 |
1536594 | 1536594 | 2021-07-20 | Rutherford | Tennessee | 47149 | 44081 | 451 |
1533346 | 1533346 | 2021-07-19 | Rutherford | Tennessee | 47149 | 44034 | 451 |
1530099 | 1530099 | 2021-07-18 | Rutherford | Tennessee | 47149 | 43943 | 451 |
1526852 | 1526852 | 2021-07-17 | Rutherford | Tennessee | 47149 | 43943 | 451 |
1523605 | 1523605 | 2021-07-16 | Rutherford | Tennessee | 47149 | 43943 | 451 |
1520357 | 1520357 | 2021-07-15 | Rutherford | Tennessee | 47149 | 43915 | 451 |
1517109 | 1517109 | 2021-07-14 | Rutherford | Tennessee | 47149 | 43898 | 451 |
1513862 | 1513862 | 2021-07-13 | Rutherford | Tennessee | 47149 | 43867 | 451 |
1510616 | 1510616 | 2021-07-12 | Rutherford | Tennessee | 47149 | 43855 | 450 |
1507369 | 1507369 | 2021-07-11 | Rutherford | Tennessee | 47149 | 43818 | 450 |
1504123 | 1504123 | 2021-07-10 | Rutherford | Tennessee | 47149 | 43818 | 450 |
1500877 | 1500877 | 2021-07-09 | Rutherford | Tennessee | 47149 | 43818 | 450 |
1497631 | 1497631 | 2021-07-08 | Rutherford | Tennessee | 47149 | 43799 | 450 |
1494384 | 1494384 | 2021-07-07 | Rutherford | Tennessee | 47149 | 43784 | 449 |
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);