ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 47075 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1815931 | 1815931 | 2021-10-14 | Haywood | Tennessee | 47075 | 3787 | 72 |
1812683 | 1812683 | 2021-10-13 | Haywood | Tennessee | 47075 | 3784 | 72 |
1809434 | 1809434 | 2021-10-12 | Haywood | Tennessee | 47075 | 3779 | 72 |
1806184 | 1806184 | 2021-10-11 | Haywood | Tennessee | 47075 | 3773 | 71 |
1802934 | 1802934 | 2021-10-10 | Haywood | Tennessee | 47075 | 3767 | 71 |
1799685 | 1799685 | 2021-10-09 | Haywood | Tennessee | 47075 | 3767 | 71 |
1796436 | 1796436 | 2021-10-08 | Haywood | Tennessee | 47075 | 3767 | 71 |
1793187 | 1793187 | 2021-10-07 | Haywood | Tennessee | 47075 | 3758 | 71 |
1789938 | 1789938 | 2021-10-06 | Haywood | Tennessee | 47075 | 3751 | 71 |
1786690 | 1786690 | 2021-10-05 | Haywood | Tennessee | 47075 | 3748 | 71 |
1783441 | 1783441 | 2021-10-04 | Haywood | Tennessee | 47075 | 3746 | 71 |
1780192 | 1780192 | 2021-10-03 | Haywood | Tennessee | 47075 | 3739 | 71 |
1776942 | 1776942 | 2021-10-02 | Haywood | Tennessee | 47075 | 3739 | 71 |
1773692 | 1773692 | 2021-10-01 | Haywood | Tennessee | 47075 | 3739 | 71 |
1770442 | 1770442 | 2021-09-30 | Haywood | Tennessee | 47075 | 3732 | 71 |
1767193 | 1767193 | 2021-09-29 | Haywood | Tennessee | 47075 | 3724 | 71 |
1763944 | 1763944 | 2021-09-28 | Haywood | Tennessee | 47075 | 3712 | 70 |
1760695 | 1760695 | 2021-09-27 | Haywood | Tennessee | 47075 | 3697 | 69 |
1757447 | 1757447 | 2021-09-26 | Haywood | Tennessee | 47075 | 3682 | 69 |
1754199 | 1754199 | 2021-09-25 | Haywood | Tennessee | 47075 | 3682 | 69 |
1750951 | 1750951 | 2021-09-24 | Haywood | Tennessee | 47075 | 3682 | 69 |
1747702 | 1747702 | 2021-09-23 | Haywood | Tennessee | 47075 | 3669 | 69 |
1744452 | 1744452 | 2021-09-22 | Haywood | Tennessee | 47075 | 3662 | 68 |
1741203 | 1741203 | 2021-09-21 | Haywood | Tennessee | 47075 | 3641 | 68 |
1737954 | 1737954 | 2021-09-20 | Haywood | Tennessee | 47075 | 3641 | 68 |
1734704 | 1734704 | 2021-09-19 | Haywood | Tennessee | 47075 | 3603 | 67 |
1731454 | 1731454 | 2021-09-18 | Haywood | Tennessee | 47075 | 3603 | 67 |
1728204 | 1728204 | 2021-09-17 | Haywood | Tennessee | 47075 | 3603 | 67 |
1724955 | 1724955 | 2021-09-16 | Haywood | Tennessee | 47075 | 3558 | 67 |
1721706 | 1721706 | 2021-09-15 | Haywood | Tennessee | 47075 | 3545 | 67 |
1718458 | 1718458 | 2021-09-14 | Haywood | Tennessee | 47075 | 3527 | 67 |
1715210 | 1715210 | 2021-09-13 | Haywood | Tennessee | 47075 | 3517 | 66 |
1711964 | 1711964 | 2021-09-12 | Haywood | Tennessee | 47075 | 3453 | 66 |
1708717 | 1708717 | 2021-09-11 | Haywood | Tennessee | 47075 | 3453 | 66 |
1705470 | 1705470 | 2021-09-10 | Haywood | Tennessee | 47075 | 3453 | 66 |
1702220 | 1702220 | 2021-09-09 | Haywood | Tennessee | 47075 | 3435 | 66 |
1698971 | 1698971 | 2021-09-08 | Haywood | Tennessee | 47075 | 3427 | 66 |
1695723 | 1695723 | 2021-09-07 | Haywood | Tennessee | 47075 | 3412 | 66 |
1692475 | 1692475 | 2021-09-06 | Haywood | Tennessee | 47075 | 3307 | 66 |
1689226 | 1689226 | 2021-09-05 | Haywood | Tennessee | 47075 | 3307 | 66 |
1685976 | 1685976 | 2021-09-04 | Haywood | Tennessee | 47075 | 3307 | 66 |
1682725 | 1682725 | 2021-09-03 | Haywood | Tennessee | 47075 | 3307 | 66 |
1679475 | 1679475 | 2021-09-02 | Haywood | Tennessee | 47075 | 3291 | 66 |
1676227 | 1676227 | 2021-09-01 | Haywood | Tennessee | 47075 | 3279 | 66 |
1672980 | 1672980 | 2021-08-31 | Haywood | Tennessee | 47075 | 3263 | 66 |
1669732 | 1669732 | 2021-08-30 | Haywood | Tennessee | 47075 | 3226 | 66 |
1666485 | 1666485 | 2021-08-29 | Haywood | Tennessee | 47075 | 3181 | 66 |
1663237 | 1663237 | 2021-08-28 | Haywood | Tennessee | 47075 | 3181 | 66 |
1659989 | 1659989 | 2021-08-27 | Haywood | Tennessee | 47075 | 3181 | 66 |
1656740 | 1656740 | 2021-08-26 | Haywood | Tennessee | 47075 | 3164 | 66 |
1653493 | 1653493 | 2021-08-25 | Haywood | Tennessee | 47075 | 3127 | 66 |
1650246 | 1650246 | 2021-08-24 | Haywood | Tennessee | 47075 | 3127 | 66 |
1646997 | 1646997 | 2021-08-23 | Haywood | Tennessee | 47075 | 3117 | 66 |
1643748 | 1643748 | 2021-08-22 | Haywood | Tennessee | 47075 | 3068 | 66 |
1640498 | 1640498 | 2021-08-21 | Haywood | Tennessee | 47075 | 3068 | 66 |
1637248 | 1637248 | 2021-08-20 | Haywood | Tennessee | 47075 | 3068 | 66 |
1633998 | 1633998 | 2021-08-19 | Haywood | Tennessee | 47075 | 3040 | 66 |
1630751 | 1630751 | 2021-08-18 | Haywood | Tennessee | 47075 | 3026 | 65 |
1627504 | 1627504 | 2021-08-17 | Haywood | Tennessee | 47075 | 3015 | 62 |
1624257 | 1624257 | 2021-08-16 | Haywood | Tennessee | 47075 | 3005 | 62 |
1621010 | 1621010 | 2021-08-15 | Haywood | Tennessee | 47075 | 2960 | 62 |
1617762 | 1617762 | 2021-08-14 | Haywood | Tennessee | 47075 | 2960 | 62 |
1614514 | 1614514 | 2021-08-13 | Haywood | Tennessee | 47075 | 2960 | 62 |
1611265 | 1611265 | 2021-08-12 | Haywood | Tennessee | 47075 | 2924 | 62 |
1608017 | 1608017 | 2021-08-11 | Haywood | Tennessee | 47075 | 2909 | 62 |
1604768 | 1604768 | 2021-08-10 | Haywood | Tennessee | 47075 | 2898 | 62 |
1601519 | 1601519 | 2021-08-09 | Haywood | Tennessee | 47075 | 2873 | 62 |
1598271 | 1598271 | 2021-08-08 | Haywood | Tennessee | 47075 | 2835 | 62 |
1595022 | 1595022 | 2021-08-07 | Haywood | Tennessee | 47075 | 2835 | 62 |
1591773 | 1591773 | 2021-08-06 | Haywood | Tennessee | 47075 | 2835 | 62 |
1588524 | 1588524 | 2021-08-05 | Haywood | Tennessee | 47075 | 2824 | 62 |
1585274 | 1585274 | 2021-08-04 | Haywood | Tennessee | 47075 | 2816 | 62 |
1582024 | 1582024 | 2021-08-03 | Haywood | Tennessee | 47075 | 2810 | 62 |
1578775 | 1578775 | 2021-08-02 | Haywood | Tennessee | 47075 | 2804 | 62 |
1575527 | 1575527 | 2021-08-01 | Haywood | Tennessee | 47075 | 2783 | 62 |
1572279 | 1572279 | 2021-07-31 | Haywood | Tennessee | 47075 | 2783 | 62 |
1569031 | 1569031 | 2021-07-30 | Haywood | Tennessee | 47075 | 2783 | 62 |
1565783 | 1565783 | 2021-07-29 | Haywood | Tennessee | 47075 | 2774 | 62 |
1562535 | 1562535 | 2021-07-28 | Haywood | Tennessee | 47075 | 2765 | 62 |
1559287 | 1559287 | 2021-07-27 | Haywood | Tennessee | 47075 | 2762 | 62 |
1556040 | 1556040 | 2021-07-26 | Haywood | Tennessee | 47075 | 2760 | 62 |
1552793 | 1552793 | 2021-07-25 | Haywood | Tennessee | 47075 | 2752 | 62 |
1549546 | 1549546 | 2021-07-24 | Haywood | Tennessee | 47075 | 2752 | 62 |
1546299 | 1546299 | 2021-07-23 | Haywood | Tennessee | 47075 | 2752 | 62 |
1543052 | 1543052 | 2021-07-22 | Haywood | Tennessee | 47075 | 2748 | 62 |
1539804 | 1539804 | 2021-07-21 | Haywood | Tennessee | 47075 | 2743 | 62 |
1536557 | 1536557 | 2021-07-20 | Haywood | Tennessee | 47075 | 2743 | 62 |
1533309 | 1533309 | 2021-07-19 | Haywood | Tennessee | 47075 | 2736 | 62 |
1530062 | 1530062 | 2021-07-18 | Haywood | Tennessee | 47075 | 2729 | 62 |
1526815 | 1526815 | 2021-07-17 | Haywood | Tennessee | 47075 | 2729 | 62 |
1523568 | 1523568 | 2021-07-16 | Haywood | Tennessee | 47075 | 2729 | 62 |
1520320 | 1520320 | 2021-07-15 | Haywood | Tennessee | 47075 | 2726 | 62 |
1517072 | 1517072 | 2021-07-14 | Haywood | Tennessee | 47075 | 2725 | 62 |
1513825 | 1513825 | 2021-07-13 | Haywood | Tennessee | 47075 | 2723 | 62 |
1510579 | 1510579 | 2021-07-12 | Haywood | Tennessee | 47075 | 2722 | 62 |
1507332 | 1507332 | 2021-07-11 | Haywood | Tennessee | 47075 | 2721 | 62 |
1504086 | 1504086 | 2021-07-10 | Haywood | Tennessee | 47075 | 2721 | 62 |
1500840 | 1500840 | 2021-07-09 | Haywood | Tennessee | 47075 | 2721 | 62 |
1497594 | 1497594 | 2021-07-08 | Haywood | Tennessee | 47075 | 2720 | 62 |
1494347 | 1494347 | 2021-07-07 | Haywood | Tennessee | 47075 | 2719 | 62 |
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);