ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Washington" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1815984 | 1815984 | 2021-10-14 | Washington | Tennessee | 47179 | 21309 | 321 |
1812736 | 1812736 | 2021-10-13 | Washington | Tennessee | 47179 | 21270 | 321 |
1809487 | 1809487 | 2021-10-12 | Washington | Tennessee | 47179 | 21230 | 321 |
1806237 | 1806237 | 2021-10-11 | Washington | Tennessee | 47179 | 21192 | 319 |
1802987 | 1802987 | 2021-10-10 | Washington | Tennessee | 47179 | 21089 | 318 |
1799738 | 1799738 | 2021-10-09 | Washington | Tennessee | 47179 | 21089 | 318 |
1796489 | 1796489 | 2021-10-08 | Washington | Tennessee | 47179 | 21089 | 318 |
1793240 | 1793240 | 2021-10-07 | Washington | Tennessee | 47179 | 21035 | 316 |
1789991 | 1789991 | 2021-10-06 | Washington | Tennessee | 47179 | 20995 | 316 |
1786743 | 1786743 | 2021-10-05 | Washington | Tennessee | 47179 | 20935 | 311 |
1783494 | 1783494 | 2021-10-04 | Washington | Tennessee | 47179 | 20875 | 311 |
1780245 | 1780245 | 2021-10-03 | Washington | Tennessee | 47179 | 20764 | 309 |
1776995 | 1776995 | 2021-10-02 | Washington | Tennessee | 47179 | 20764 | 309 |
1773745 | 1773745 | 2021-10-01 | Washington | Tennessee | 47179 | 20764 | 309 |
1770495 | 1770495 | 2021-09-30 | Washington | Tennessee | 47179 | 20724 | 308 |
1767246 | 1767246 | 2021-09-29 | Washington | Tennessee | 47179 | 20667 | 307 |
1763997 | 1763997 | 2021-09-28 | Washington | Tennessee | 47179 | 20625 | 306 |
1760748 | 1760748 | 2021-09-27 | Washington | Tennessee | 47179 | 20545 | 300 |
1757500 | 1757500 | 2021-09-26 | Washington | Tennessee | 47179 | 20396 | 299 |
1754252 | 1754252 | 2021-09-25 | Washington | Tennessee | 47179 | 20396 | 299 |
1751004 | 1751004 | 2021-09-24 | Washington | Tennessee | 47179 | 20396 | 299 |
1747755 | 1747755 | 2021-09-23 | Washington | Tennessee | 47179 | 20307 | 298 |
1744505 | 1744505 | 2021-09-22 | Washington | Tennessee | 47179 | 20248 | 298 |
1741256 | 1741256 | 2021-09-21 | Washington | Tennessee | 47179 | 20069 | 296 |
1738007 | 1738007 | 2021-09-20 | Washington | Tennessee | 47179 | 20069 | 296 |
1734757 | 1734757 | 2021-09-19 | Washington | Tennessee | 47179 | 19862 | 291 |
1731507 | 1731507 | 2021-09-18 | Washington | Tennessee | 47179 | 19862 | 291 |
1728257 | 1728257 | 2021-09-17 | Washington | Tennessee | 47179 | 19862 | 291 |
1725008 | 1725008 | 2021-09-16 | Washington | Tennessee | 47179 | 19778 | 291 |
1721759 | 1721759 | 2021-09-15 | Washington | Tennessee | 47179 | 19684 | 288 |
1718511 | 1718511 | 2021-09-14 | Washington | Tennessee | 47179 | 19583 | 285 |
1715263 | 1715263 | 2021-09-13 | Washington | Tennessee | 47179 | 19511 | 283 |
1712017 | 1712017 | 2021-09-12 | Washington | Tennessee | 47179 | 19021 | 280 |
1708770 | 1708770 | 2021-09-11 | Washington | Tennessee | 47179 | 19021 | 280 |
1705523 | 1705523 | 2021-09-10 | Washington | Tennessee | 47179 | 19021 | 280 |
1702273 | 1702273 | 2021-09-09 | Washington | Tennessee | 47179 | 18954 | 280 |
1699024 | 1699024 | 2021-09-08 | Washington | Tennessee | 47179 | 18843 | 279 |
1695776 | 1695776 | 2021-09-07 | Washington | Tennessee | 47179 | 18733 | 274 |
1692528 | 1692528 | 2021-09-06 | Washington | Tennessee | 47179 | 18172 | 270 |
1689279 | 1689279 | 2021-09-05 | Washington | Tennessee | 47179 | 18172 | 270 |
1686029 | 1686029 | 2021-09-04 | Washington | Tennessee | 47179 | 18172 | 270 |
1682778 | 1682778 | 2021-09-03 | Washington | Tennessee | 47179 | 18172 | 270 |
1679528 | 1679528 | 2021-09-02 | Washington | Tennessee | 47179 | 18048 | 270 |
1676280 | 1676280 | 2021-09-01 | Washington | Tennessee | 47179 | 17947 | 269 |
1673033 | 1673033 | 2021-08-31 | Washington | Tennessee | 47179 | 17807 | 269 |
1669785 | 1669785 | 2021-08-30 | Washington | Tennessee | 47179 | 17627 | 268 |
1666538 | 1666538 | 2021-08-29 | Washington | Tennessee | 47179 | 17332 | 266 |
1663290 | 1663290 | 2021-08-28 | Washington | Tennessee | 47179 | 17332 | 266 |
1660042 | 1660042 | 2021-08-27 | Washington | Tennessee | 47179 | 17332 | 266 |
1656793 | 1656793 | 2021-08-26 | Washington | Tennessee | 47179 | 17169 | 265 |
1653546 | 1653546 | 2021-08-25 | Washington | Tennessee | 47179 | 16938 | 264 |
1650299 | 1650299 | 2021-08-24 | Washington | Tennessee | 47179 | 16938 | 264 |
1647050 | 1647050 | 2021-08-23 | Washington | Tennessee | 47179 | 16826 | 262 |
1643801 | 1643801 | 2021-08-22 | Washington | Tennessee | 47179 | 16529 | 262 |
1640551 | 1640551 | 2021-08-21 | Washington | Tennessee | 47179 | 16529 | 262 |
1637301 | 1637301 | 2021-08-20 | Washington | Tennessee | 47179 | 16529 | 262 |
1634051 | 1634051 | 2021-08-19 | Washington | Tennessee | 47179 | 16416 | 260 |
1630804 | 1630804 | 2021-08-18 | Washington | Tennessee | 47179 | 16287 | 260 |
1627557 | 1627557 | 2021-08-17 | Washington | Tennessee | 47179 | 16147 | 260 |
1624310 | 1624310 | 2021-08-16 | Washington | Tennessee | 47179 | 16040 | 259 |
1621063 | 1621063 | 2021-08-15 | Washington | Tennessee | 47179 | 15845 | 258 |
1617815 | 1617815 | 2021-08-14 | Washington | Tennessee | 47179 | 15845 | 258 |
1614567 | 1614567 | 2021-08-13 | Washington | Tennessee | 47179 | 15845 | 258 |
1611318 | 1611318 | 2021-08-12 | Washington | Tennessee | 47179 | 15783 | 258 |
1608070 | 1608070 | 2021-08-11 | Washington | Tennessee | 47179 | 15701 | 258 |
1604821 | 1604821 | 2021-08-10 | Washington | Tennessee | 47179 | 15657 | 258 |
1601572 | 1601572 | 2021-08-09 | Washington | Tennessee | 47179 | 15592 | 258 |
1598324 | 1598324 | 2021-08-08 | Washington | Tennessee | 47179 | 15490 | 256 |
1595075 | 1595075 | 2021-08-07 | Washington | Tennessee | 47179 | 15490 | 256 |
1591826 | 1591826 | 2021-08-06 | Washington | Tennessee | 47179 | 15490 | 256 |
1588577 | 1588577 | 2021-08-05 | Washington | Tennessee | 47179 | 15447 | 256 |
1585327 | 1585327 | 2021-08-04 | Washington | Tennessee | 47179 | 15398 | 255 |
1582077 | 1582077 | 2021-08-03 | Washington | Tennessee | 47179 | 15346 | 255 |
1578828 | 1578828 | 2021-08-02 | Washington | Tennessee | 47179 | 15301 | 255 |
1575580 | 1575580 | 2021-08-01 | Washington | Tennessee | 47179 | 15215 | 255 |
1572332 | 1572332 | 2021-07-31 | Washington | Tennessee | 47179 | 15215 | 255 |
1569084 | 1569084 | 2021-07-30 | Washington | Tennessee | 47179 | 15215 | 255 |
1565836 | 1565836 | 2021-07-29 | Washington | Tennessee | 47179 | 15176 | 255 |
1562588 | 1562588 | 2021-07-28 | Washington | Tennessee | 47179 | 15146 | 255 |
1559340 | 1559340 | 2021-07-27 | Washington | Tennessee | 47179 | 15110 | 255 |
1556093 | 1556093 | 2021-07-26 | Washington | Tennessee | 47179 | 15075 | 255 |
1552846 | 1552846 | 2021-07-25 | Washington | Tennessee | 47179 | 15031 | 255 |
1549599 | 1549599 | 2021-07-24 | Washington | Tennessee | 47179 | 15031 | 255 |
1546352 | 1546352 | 2021-07-23 | Washington | Tennessee | 47179 | 15031 | 255 |
1543105 | 1543105 | 2021-07-22 | Washington | Tennessee | 47179 | 15005 | 255 |
1539857 | 1539857 | 2021-07-21 | Washington | Tennessee | 47179 | 14975 | 255 |
1536610 | 1536610 | 2021-07-20 | Washington | Tennessee | 47179 | 14960 | 255 |
1533362 | 1533362 | 2021-07-19 | Washington | Tennessee | 47179 | 14946 | 254 |
1530115 | 1530115 | 2021-07-18 | Washington | Tennessee | 47179 | 14924 | 254 |
1526868 | 1526868 | 2021-07-17 | Washington | Tennessee | 47179 | 14924 | 254 |
1523621 | 1523621 | 2021-07-16 | Washington | Tennessee | 47179 | 14924 | 254 |
1520373 | 1520373 | 2021-07-15 | Washington | Tennessee | 47179 | 14917 | 254 |
1517125 | 1517125 | 2021-07-14 | Washington | Tennessee | 47179 | 14917 | 254 |
1513878 | 1513878 | 2021-07-13 | Washington | Tennessee | 47179 | 14903 | 254 |
1510632 | 1510632 | 2021-07-12 | Washington | Tennessee | 47179 | 14894 | 254 |
1507385 | 1507385 | 2021-07-11 | Washington | Tennessee | 47179 | 14884 | 254 |
1504139 | 1504139 | 2021-07-10 | Washington | Tennessee | 47179 | 14884 | 254 |
1500893 | 1500893 | 2021-07-09 | Washington | Tennessee | 47179 | 14884 | 254 |
1497647 | 1497647 | 2021-07-08 | Washington | Tennessee | 47179 | 14880 | 254 |
1494400 | 1494400 | 2021-07-07 | Washington | Tennessee | 47179 | 14876 | 254 |
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);