ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where fips = 47057 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1815922 | 1815922 | 2021-10-14 | Grainger | Tennessee | 47057 | 4276 | 65 |
1812674 | 1812674 | 2021-10-13 | Grainger | Tennessee | 47057 | 4262 | 63 |
1809425 | 1809425 | 2021-10-12 | Grainger | Tennessee | 47057 | 4250 | 61 |
1806175 | 1806175 | 2021-10-11 | Grainger | Tennessee | 47057 | 4236 | 61 |
1802925 | 1802925 | 2021-10-10 | Grainger | Tennessee | 47057 | 4213 | 61 |
1799676 | 1799676 | 2021-10-09 | Grainger | Tennessee | 47057 | 4213 | 61 |
1796427 | 1796427 | 2021-10-08 | Grainger | Tennessee | 47057 | 4213 | 61 |
1793178 | 1793178 | 2021-10-07 | Grainger | Tennessee | 47057 | 4178 | 60 |
1789929 | 1789929 | 2021-10-06 | Grainger | Tennessee | 47057 | 4160 | 60 |
1786681 | 1786681 | 2021-10-05 | Grainger | Tennessee | 47057 | 4146 | 60 |
1783432 | 1783432 | 2021-10-04 | Grainger | Tennessee | 47057 | 4141 | 60 |
1780183 | 1780183 | 2021-10-03 | Grainger | Tennessee | 47057 | 4120 | 60 |
1776933 | 1776933 | 2021-10-02 | Grainger | Tennessee | 47057 | 4120 | 60 |
1773683 | 1773683 | 2021-10-01 | Grainger | Tennessee | 47057 | 4120 | 60 |
1770433 | 1770433 | 2021-09-30 | Grainger | Tennessee | 47057 | 4108 | 60 |
1767184 | 1767184 | 2021-09-29 | Grainger | Tennessee | 47057 | 4092 | 58 |
1763935 | 1763935 | 2021-09-28 | Grainger | Tennessee | 47057 | 4071 | 58 |
1760686 | 1760686 | 2021-09-27 | Grainger | Tennessee | 47057 | 4052 | 57 |
1757438 | 1757438 | 2021-09-26 | Grainger | Tennessee | 47057 | 4024 | 57 |
1754190 | 1754190 | 2021-09-25 | Grainger | Tennessee | 47057 | 4024 | 57 |
1750942 | 1750942 | 2021-09-24 | Grainger | Tennessee | 47057 | 4024 | 57 |
1747693 | 1747693 | 2021-09-23 | Grainger | Tennessee | 47057 | 3988 | 57 |
1744443 | 1744443 | 2021-09-22 | Grainger | Tennessee | 47057 | 3973 | 57 |
1741194 | 1741194 | 2021-09-21 | Grainger | Tennessee | 47057 | 3929 | 54 |
1737945 | 1737945 | 2021-09-20 | Grainger | Tennessee | 47057 | 3929 | 54 |
1734695 | 1734695 | 2021-09-19 | Grainger | Tennessee | 47057 | 3870 | 54 |
1731445 | 1731445 | 2021-09-18 | Grainger | Tennessee | 47057 | 3870 | 54 |
1728195 | 1728195 | 2021-09-17 | Grainger | Tennessee | 47057 | 3870 | 54 |
1724946 | 1724946 | 2021-09-16 | Grainger | Tennessee | 47057 | 3823 | 54 |
1721697 | 1721697 | 2021-09-15 | Grainger | Tennessee | 47057 | 3803 | 54 |
1718449 | 1718449 | 2021-09-14 | Grainger | Tennessee | 47057 | 3779 | 54 |
1715201 | 1715201 | 2021-09-13 | Grainger | Tennessee | 47057 | 3758 | 53 |
1711955 | 1711955 | 2021-09-12 | Grainger | Tennessee | 47057 | 3630 | 52 |
1708708 | 1708708 | 2021-09-11 | Grainger | Tennessee | 47057 | 3630 | 52 |
1705461 | 1705461 | 2021-09-10 | Grainger | Tennessee | 47057 | 3630 | 52 |
1702211 | 1702211 | 2021-09-09 | Grainger | Tennessee | 47057 | 3606 | 52 |
1698962 | 1698962 | 2021-09-08 | Grainger | Tennessee | 47057 | 3597 | 52 |
1695714 | 1695714 | 2021-09-07 | Grainger | Tennessee | 47057 | 3578 | 52 |
1692466 | 1692466 | 2021-09-06 | Grainger | Tennessee | 47057 | 3415 | 52 |
1689217 | 1689217 | 2021-09-05 | Grainger | Tennessee | 47057 | 3415 | 52 |
1685967 | 1685967 | 2021-09-04 | Grainger | Tennessee | 47057 | 3415 | 52 |
1682716 | 1682716 | 2021-09-03 | Grainger | Tennessee | 47057 | 3415 | 52 |
1679466 | 1679466 | 2021-09-02 | Grainger | Tennessee | 47057 | 3395 | 52 |
1676218 | 1676218 | 2021-09-01 | Grainger | Tennessee | 47057 | 3376 | 52 |
1672971 | 1672971 | 2021-08-31 | Grainger | Tennessee | 47057 | 3351 | 52 |
1669723 | 1669723 | 2021-08-30 | Grainger | Tennessee | 47057 | 3310 | 52 |
1666476 | 1666476 | 2021-08-29 | Grainger | Tennessee | 47057 | 3189 | 52 |
1663228 | 1663228 | 2021-08-28 | Grainger | Tennessee | 47057 | 3189 | 52 |
1659980 | 1659980 | 2021-08-27 | Grainger | Tennessee | 47057 | 3189 | 52 |
1656731 | 1656731 | 2021-08-26 | Grainger | Tennessee | 47057 | 3159 | 52 |
1653484 | 1653484 | 2021-08-25 | Grainger | Tennessee | 47057 | 3100 | 52 |
1650237 | 1650237 | 2021-08-24 | Grainger | Tennessee | 47057 | 3100 | 52 |
1646988 | 1646988 | 2021-08-23 | Grainger | Tennessee | 47057 | 3093 | 52 |
1643739 | 1643739 | 2021-08-22 | Grainger | Tennessee | 47057 | 3010 | 51 |
1640489 | 1640489 | 2021-08-21 | Grainger | Tennessee | 47057 | 3010 | 51 |
1637239 | 1637239 | 2021-08-20 | Grainger | Tennessee | 47057 | 3010 | 51 |
1633989 | 1633989 | 2021-08-19 | Grainger | Tennessee | 47057 | 2963 | 51 |
1630742 | 1630742 | 2021-08-18 | Grainger | Tennessee | 47057 | 2937 | 51 |
1627495 | 1627495 | 2021-08-17 | Grainger | Tennessee | 47057 | 2920 | 51 |
1624248 | 1624248 | 2021-08-16 | Grainger | Tennessee | 47057 | 2908 | 51 |
1621001 | 1621001 | 2021-08-15 | Grainger | Tennessee | 47057 | 2877 | 51 |
1617753 | 1617753 | 2021-08-14 | Grainger | Tennessee | 47057 | 2877 | 51 |
1614505 | 1614505 | 2021-08-13 | Grainger | Tennessee | 47057 | 2877 | 51 |
1611256 | 1611256 | 2021-08-12 | Grainger | Tennessee | 47057 | 2849 | 51 |
1608008 | 1608008 | 2021-08-11 | Grainger | Tennessee | 47057 | 2833 | 51 |
1604759 | 1604759 | 2021-08-10 | Grainger | Tennessee | 47057 | 2824 | 51 |
1601510 | 1601510 | 2021-08-09 | Grainger | Tennessee | 47057 | 2816 | 51 |
1598262 | 1598262 | 2021-08-08 | Grainger | Tennessee | 47057 | 2784 | 51 |
1595013 | 1595013 | 2021-08-07 | Grainger | Tennessee | 47057 | 2784 | 51 |
1591764 | 1591764 | 2021-08-06 | Grainger | Tennessee | 47057 | 2784 | 51 |
1588515 | 1588515 | 2021-08-05 | Grainger | Tennessee | 47057 | 2770 | 51 |
1585265 | 1585265 | 2021-08-04 | Grainger | Tennessee | 47057 | 2759 | 51 |
1582015 | 1582015 | 2021-08-03 | Grainger | Tennessee | 47057 | 2756 | 51 |
1578766 | 1578766 | 2021-08-02 | Grainger | Tennessee | 47057 | 2751 | 50 |
1575518 | 1575518 | 2021-08-01 | Grainger | Tennessee | 47057 | 2730 | 50 |
1572270 | 1572270 | 2021-07-31 | Grainger | Tennessee | 47057 | 2730 | 50 |
1569022 | 1569022 | 2021-07-30 | Grainger | Tennessee | 47057 | 2730 | 50 |
1565774 | 1565774 | 2021-07-29 | Grainger | Tennessee | 47057 | 2723 | 50 |
1562526 | 1562526 | 2021-07-28 | Grainger | Tennessee | 47057 | 2720 | 50 |
1559278 | 1559278 | 2021-07-27 | Grainger | Tennessee | 47057 | 2717 | 50 |
1556031 | 1556031 | 2021-07-26 | Grainger | Tennessee | 47057 | 2712 | 50 |
1552784 | 1552784 | 2021-07-25 | Grainger | Tennessee | 47057 | 2706 | 50 |
1549537 | 1549537 | 2021-07-24 | Grainger | Tennessee | 47057 | 2706 | 50 |
1546290 | 1546290 | 2021-07-23 | Grainger | Tennessee | 47057 | 2706 | 50 |
1543043 | 1543043 | 2021-07-22 | Grainger | Tennessee | 47057 | 2705 | 50 |
1539795 | 1539795 | 2021-07-21 | Grainger | Tennessee | 47057 | 2704 | 50 |
1536548 | 1536548 | 2021-07-20 | Grainger | Tennessee | 47057 | 2704 | 50 |
1533300 | 1533300 | 2021-07-19 | Grainger | Tennessee | 47057 | 2701 | 50 |
1530053 | 1530053 | 2021-07-18 | Grainger | Tennessee | 47057 | 2692 | 50 |
1526806 | 1526806 | 2021-07-17 | Grainger | Tennessee | 47057 | 2692 | 50 |
1523559 | 1523559 | 2021-07-16 | Grainger | Tennessee | 47057 | 2692 | 50 |
1520311 | 1520311 | 2021-07-15 | Grainger | Tennessee | 47057 | 2690 | 50 |
1517063 | 1517063 | 2021-07-14 | Grainger | Tennessee | 47057 | 2689 | 50 |
1513816 | 1513816 | 2021-07-13 | Grainger | Tennessee | 47057 | 2687 | 50 |
1510570 | 1510570 | 2021-07-12 | Grainger | Tennessee | 47057 | 2687 | 50 |
1507323 | 1507323 | 2021-07-11 | Grainger | Tennessee | 47057 | 2684 | 50 |
1504077 | 1504077 | 2021-07-10 | Grainger | Tennessee | 47057 | 2684 | 50 |
1500831 | 1500831 | 2021-07-09 | Grainger | Tennessee | 47057 | 2684 | 50 |
1497585 | 1497585 | 2021-07-08 | Grainger | Tennessee | 47057 | 2682 | 50 |
1494338 | 1494338 | 2021-07-07 | Grainger | Tennessee | 47057 | 2682 | 50 |
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);