ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Warren" and fips = 47177 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1851725 | 1851725 | 2021-10-25 | Warren | Tennessee | 47177 | 8568 | 119 |
1848475 | 1848475 | 2021-10-24 | Warren | Tennessee | 47177 | 8568 | 119 |
1845225 | 1845225 | 2021-10-23 | Warren | Tennessee | 47177 | 8568 | 119 |
1841975 | 1841975 | 2021-10-22 | Warren | Tennessee | 47177 | 8568 | 119 |
1838726 | 1838726 | 2021-10-21 | Warren | Tennessee | 47177 | 8556 | 117 |
1835477 | 1835477 | 2021-10-20 | Warren | Tennessee | 47177 | 8544 | 117 |
1832228 | 1832228 | 2021-10-19 | Warren | Tennessee | 47177 | 8524 | 116 |
1828979 | 1828979 | 2021-10-18 | Warren | Tennessee | 47177 | 8516 | 113 |
1825730 | 1825730 | 2021-10-17 | Warren | Tennessee | 47177 | 8493 | 113 |
1822481 | 1822481 | 2021-10-16 | Warren | Tennessee | 47177 | 8493 | 113 |
1819232 | 1819232 | 2021-10-15 | Warren | Tennessee | 47177 | 8493 | 113 |
1815983 | 1815983 | 2021-10-14 | Warren | Tennessee | 47177 | 8481 | 113 |
1812735 | 1812735 | 2021-10-13 | Warren | Tennessee | 47177 | 8460 | 113 |
1809486 | 1809486 | 2021-10-12 | Warren | Tennessee | 47177 | 8439 | 113 |
1806236 | 1806236 | 2021-10-11 | Warren | Tennessee | 47177 | 8418 | 110 |
1802986 | 1802986 | 2021-10-10 | Warren | Tennessee | 47177 | 8370 | 109 |
1799737 | 1799737 | 2021-10-09 | Warren | Tennessee | 47177 | 8370 | 109 |
1796488 | 1796488 | 2021-10-08 | Warren | Tennessee | 47177 | 8370 | 109 |
1793239 | 1793239 | 2021-10-07 | Warren | Tennessee | 47177 | 8333 | 106 |
1789990 | 1789990 | 2021-10-06 | Warren | Tennessee | 47177 | 8325 | 106 |
1786742 | 1786742 | 2021-10-05 | Warren | Tennessee | 47177 | 8317 | 106 |
1783493 | 1783493 | 2021-10-04 | Warren | Tennessee | 47177 | 8296 | 102 |
1780244 | 1780244 | 2021-10-03 | Warren | Tennessee | 47177 | 8252 | 102 |
1776994 | 1776994 | 2021-10-02 | Warren | Tennessee | 47177 | 8252 | 102 |
1773744 | 1773744 | 2021-10-01 | Warren | Tennessee | 47177 | 8252 | 102 |
1770494 | 1770494 | 2021-09-30 | Warren | Tennessee | 47177 | 8226 | 102 |
1767245 | 1767245 | 2021-09-29 | Warren | Tennessee | 47177 | 8179 | 101 |
1763996 | 1763996 | 2021-09-28 | Warren | Tennessee | 47177 | 8157 | 101 |
1760747 | 1760747 | 2021-09-27 | Warren | Tennessee | 47177 | 8124 | 101 |
1757499 | 1757499 | 2021-09-26 | Warren | Tennessee | 47177 | 8075 | 101 |
1754251 | 1754251 | 2021-09-25 | Warren | Tennessee | 47177 | 8075 | 101 |
1751003 | 1751003 | 2021-09-24 | Warren | Tennessee | 47177 | 8075 | 101 |
1747754 | 1747754 | 2021-09-23 | Warren | Tennessee | 47177 | 8020 | 101 |
1744504 | 1744504 | 2021-09-22 | Warren | Tennessee | 47177 | 7996 | 101 |
1741255 | 1741255 | 2021-09-21 | Warren | Tennessee | 47177 | 7916 | 96 |
1738006 | 1738006 | 2021-09-20 | Warren | Tennessee | 47177 | 7916 | 96 |
1734756 | 1734756 | 2021-09-19 | Warren | Tennessee | 47177 | 7813 | 96 |
1731506 | 1731506 | 2021-09-18 | Warren | Tennessee | 47177 | 7813 | 96 |
1728256 | 1728256 | 2021-09-17 | Warren | Tennessee | 47177 | 7813 | 96 |
1725007 | 1725007 | 2021-09-16 | Warren | Tennessee | 47177 | 7756 | 96 |
1721758 | 1721758 | 2021-09-15 | Warren | Tennessee | 47177 | 7710 | 96 |
1718510 | 1718510 | 2021-09-14 | Warren | Tennessee | 47177 | 7665 | 95 |
1715262 | 1715262 | 2021-09-13 | Warren | Tennessee | 47177 | 7625 | 95 |
1712016 | 1712016 | 2021-09-12 | Warren | Tennessee | 47177 | 7362 | 94 |
1708769 | 1708769 | 2021-09-11 | Warren | Tennessee | 47177 | 7362 | 94 |
1705522 | 1705522 | 2021-09-10 | Warren | Tennessee | 47177 | 7362 | 94 |
1702272 | 1702272 | 2021-09-09 | Warren | Tennessee | 47177 | 7279 | 94 |
1699023 | 1699023 | 2021-09-08 | Warren | Tennessee | 47177 | 7256 | 92 |
1695775 | 1695775 | 2021-09-07 | Warren | Tennessee | 47177 | 7203 | 92 |
1692527 | 1692527 | 2021-09-06 | Warren | Tennessee | 47177 | 6821 | 92 |
1689278 | 1689278 | 2021-09-05 | Warren | Tennessee | 47177 | 6821 | 92 |
1686028 | 1686028 | 2021-09-04 | Warren | Tennessee | 47177 | 6821 | 92 |
1682777 | 1682777 | 2021-09-03 | Warren | Tennessee | 47177 | 6821 | 92 |
1679527 | 1679527 | 2021-09-02 | Warren | Tennessee | 47177 | 6753 | 92 |
1676279 | 1676279 | 2021-09-01 | Warren | Tennessee | 47177 | 6722 | 92 |
1673032 | 1673032 | 2021-08-31 | Warren | Tennessee | 47177 | 6651 | 92 |
1669784 | 1669784 | 2021-08-30 | Warren | Tennessee | 47177 | 6541 | 91 |
1666537 | 1666537 | 2021-08-29 | Warren | Tennessee | 47177 | 6324 | 91 |
1663289 | 1663289 | 2021-08-28 | Warren | Tennessee | 47177 | 6324 | 91 |
1660041 | 1660041 | 2021-08-27 | Warren | Tennessee | 47177 | 6324 | 91 |
1656792 | 1656792 | 2021-08-26 | Warren | Tennessee | 47177 | 6266 | 91 |
1653545 | 1653545 | 2021-08-25 | Warren | Tennessee | 47177 | 6186 | 91 |
1650298 | 1650298 | 2021-08-24 | Warren | Tennessee | 47177 | 6186 | 91 |
1647049 | 1647049 | 2021-08-23 | Warren | Tennessee | 47177 | 6145 | 91 |
1643800 | 1643800 | 2021-08-22 | Warren | Tennessee | 47177 | 6008 | 91 |
1640550 | 1640550 | 2021-08-21 | Warren | Tennessee | 47177 | 6008 | 91 |
1637300 | 1637300 | 2021-08-20 | Warren | Tennessee | 47177 | 6008 | 91 |
1634050 | 1634050 | 2021-08-19 | Warren | Tennessee | 47177 | 5972 | 87 |
1630803 | 1630803 | 2021-08-18 | Warren | Tennessee | 47177 | 5941 | 87 |
1627556 | 1627556 | 2021-08-17 | Warren | Tennessee | 47177 | 5916 | 87 |
1624309 | 1624309 | 2021-08-16 | Warren | Tennessee | 47177 | 5904 | 87 |
1621062 | 1621062 | 2021-08-15 | Warren | Tennessee | 47177 | 5862 | 86 |
1617814 | 1617814 | 2021-08-14 | Warren | Tennessee | 47177 | 5862 | 86 |
1614566 | 1614566 | 2021-08-13 | Warren | Tennessee | 47177 | 5862 | 86 |
1611317 | 1611317 | 2021-08-12 | Warren | Tennessee | 47177 | 5828 | 85 |
1608069 | 1608069 | 2021-08-11 | Warren | Tennessee | 47177 | 5800 | 85 |
1604820 | 1604820 | 2021-08-10 | Warren | Tennessee | 47177 | 5785 | 85 |
1601571 | 1601571 | 2021-08-09 | Warren | Tennessee | 47177 | 5763 | 85 |
1598323 | 1598323 | 2021-08-08 | Warren | Tennessee | 47177 | 5735 | 85 |
1595074 | 1595074 | 2021-08-07 | Warren | Tennessee | 47177 | 5735 | 85 |
1591825 | 1591825 | 2021-08-06 | Warren | Tennessee | 47177 | 5735 | 85 |
1588576 | 1588576 | 2021-08-05 | Warren | Tennessee | 47177 | 5720 | 85 |
1585326 | 1585326 | 2021-08-04 | Warren | Tennessee | 47177 | 5715 | 85 |
1582076 | 1582076 | 2021-08-03 | Warren | Tennessee | 47177 | 5704 | 85 |
1578827 | 1578827 | 2021-08-02 | Warren | Tennessee | 47177 | 5699 | 85 |
1575579 | 1575579 | 2021-08-01 | Warren | Tennessee | 47177 | 5673 | 85 |
1572331 | 1572331 | 2021-07-31 | Warren | Tennessee | 47177 | 5673 | 85 |
1569083 | 1569083 | 2021-07-30 | Warren | Tennessee | 47177 | 5673 | 85 |
1565835 | 1565835 | 2021-07-29 | Warren | Tennessee | 47177 | 5670 | 85 |
1562587 | 1562587 | 2021-07-28 | Warren | Tennessee | 47177 | 5659 | 85 |
1559339 | 1559339 | 2021-07-27 | Warren | Tennessee | 47177 | 5647 | 85 |
1556092 | 1556092 | 2021-07-26 | Warren | Tennessee | 47177 | 5646 | 85 |
1552845 | 1552845 | 2021-07-25 | Warren | Tennessee | 47177 | 5629 | 84 |
1549598 | 1549598 | 2021-07-24 | Warren | Tennessee | 47177 | 5629 | 84 |
1546351 | 1546351 | 2021-07-23 | Warren | Tennessee | 47177 | 5629 | 84 |
1543104 | 1543104 | 2021-07-22 | Warren | Tennessee | 47177 | 5623 | 84 |
1539856 | 1539856 | 2021-07-21 | Warren | Tennessee | 47177 | 5621 | 84 |
1536609 | 1536609 | 2021-07-20 | Warren | Tennessee | 47177 | 5619 | 84 |
1533361 | 1533361 | 2021-07-19 | Warren | Tennessee | 47177 | 5618 | 84 |
1530114 | 1530114 | 2021-07-18 | Warren | Tennessee | 47177 | 5615 | 84 |
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);