ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 47189 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1815989 | 1815989 | 2021-10-14 | Wilson | Tennessee | 47189 | 26755 | 325 |
1812741 | 1812741 | 2021-10-13 | Wilson | Tennessee | 47189 | 26715 | 325 |
1809492 | 1809492 | 2021-10-12 | Wilson | Tennessee | 47189 | 26659 | 325 |
1806242 | 1806242 | 2021-10-11 | Wilson | Tennessee | 47189 | 26637 | 324 |
1802992 | 1802992 | 2021-10-10 | Wilson | Tennessee | 47189 | 26527 | 323 |
1799743 | 1799743 | 2021-10-09 | Wilson | Tennessee | 47189 | 26527 | 323 |
1796494 | 1796494 | 2021-10-08 | Wilson | Tennessee | 47189 | 26527 | 323 |
1793245 | 1793245 | 2021-10-07 | Wilson | Tennessee | 47189 | 26446 | 323 |
1789996 | 1789996 | 2021-10-06 | Wilson | Tennessee | 47189 | 26423 | 322 |
1786748 | 1786748 | 2021-10-05 | Wilson | Tennessee | 47189 | 26405 | 320 |
1783499 | 1783499 | 2021-10-04 | Wilson | Tennessee | 47189 | 26375 | 319 |
1780250 | 1780250 | 2021-10-03 | Wilson | Tennessee | 47189 | 26253 | 318 |
1777000 | 1777000 | 2021-10-02 | Wilson | Tennessee | 47189 | 26253 | 318 |
1773750 | 1773750 | 2021-10-01 | Wilson | Tennessee | 47189 | 26253 | 318 |
1770500 | 1770500 | 2021-09-30 | Wilson | Tennessee | 47189 | 26162 | 318 |
1767251 | 1767251 | 2021-09-29 | Wilson | Tennessee | 47189 | 26097 | 317 |
1764002 | 1764002 | 2021-09-28 | Wilson | Tennessee | 47189 | 26020 | 316 |
1760753 | 1760753 | 2021-09-27 | Wilson | Tennessee | 47189 | 25974 | 312 |
1757505 | 1757505 | 2021-09-26 | Wilson | Tennessee | 47189 | 25825 | 312 |
1754257 | 1754257 | 2021-09-25 | Wilson | Tennessee | 47189 | 25825 | 312 |
1751009 | 1751009 | 2021-09-24 | Wilson | Tennessee | 47189 | 25825 | 312 |
1747760 | 1747760 | 2021-09-23 | Wilson | Tennessee | 47189 | 25746 | 309 |
1744510 | 1744510 | 2021-09-22 | Wilson | Tennessee | 47189 | 25643 | 309 |
1741261 | 1741261 | 2021-09-21 | Wilson | Tennessee | 47189 | 25481 | 304 |
1738012 | 1738012 | 2021-09-20 | Wilson | Tennessee | 47189 | 25481 | 304 |
1734762 | 1734762 | 2021-09-19 | Wilson | Tennessee | 47189 | 25274 | 302 |
1731512 | 1731512 | 2021-09-18 | Wilson | Tennessee | 47189 | 25274 | 302 |
1728262 | 1728262 | 2021-09-17 | Wilson | Tennessee | 47189 | 25274 | 302 |
1725013 | 1725013 | 2021-09-16 | Wilson | Tennessee | 47189 | 25185 | 301 |
1721764 | 1721764 | 2021-09-15 | Wilson | Tennessee | 47189 | 25110 | 301 |
1718516 | 1718516 | 2021-09-14 | Wilson | Tennessee | 47189 | 24975 | 299 |
1715268 | 1715268 | 2021-09-13 | Wilson | Tennessee | 47189 | 24885 | 294 |
1712022 | 1712022 | 2021-09-12 | Wilson | Tennessee | 47189 | 24355 | 289 |
1708775 | 1708775 | 2021-09-11 | Wilson | Tennessee | 47189 | 24355 | 289 |
1705528 | 1705528 | 2021-09-10 | Wilson | Tennessee | 47189 | 24355 | 289 |
1702278 | 1702278 | 2021-09-09 | Wilson | Tennessee | 47189 | 24238 | 289 |
1699029 | 1699029 | 2021-09-08 | Wilson | Tennessee | 47189 | 24142 | 287 |
1695781 | 1695781 | 2021-09-07 | Wilson | Tennessee | 47189 | 24052 | 285 |
1692533 | 1692533 | 2021-09-06 | Wilson | Tennessee | 47189 | 23366 | 278 |
1689284 | 1689284 | 2021-09-05 | Wilson | Tennessee | 47189 | 23366 | 278 |
1686034 | 1686034 | 2021-09-04 | Wilson | Tennessee | 47189 | 23366 | 278 |
1682783 | 1682783 | 2021-09-03 | Wilson | Tennessee | 47189 | 23366 | 278 |
1679533 | 1679533 | 2021-09-02 | Wilson | Tennessee | 47189 | 23225 | 275 |
1676285 | 1676285 | 2021-09-01 | Wilson | Tennessee | 47189 | 23204 | 273 |
1673038 | 1673038 | 2021-08-31 | Wilson | Tennessee | 47189 | 23009 | 272 |
1669790 | 1669790 | 2021-08-30 | Wilson | Tennessee | 47189 | 22843 | 272 |
1666543 | 1666543 | 2021-08-29 | Wilson | Tennessee | 47189 | 22451 | 268 |
1663295 | 1663295 | 2021-08-28 | Wilson | Tennessee | 47189 | 22451 | 268 |
1660047 | 1660047 | 2021-08-27 | Wilson | Tennessee | 47189 | 22451 | 268 |
1656798 | 1656798 | 2021-08-26 | Wilson | Tennessee | 47189 | 22294 | 266 |
1653551 | 1653551 | 2021-08-25 | Wilson | Tennessee | 47189 | 22089 | 266 |
1650304 | 1650304 | 2021-08-24 | Wilson | Tennessee | 47189 | 22089 | 266 |
1647055 | 1647055 | 2021-08-23 | Wilson | Tennessee | 47189 | 22015 | 266 |
1643806 | 1643806 | 2021-08-22 | Wilson | Tennessee | 47189 | 21619 | 264 |
1640556 | 1640556 | 2021-08-21 | Wilson | Tennessee | 47189 | 21619 | 264 |
1637306 | 1637306 | 2021-08-20 | Wilson | Tennessee | 47189 | 21619 | 264 |
1634056 | 1634056 | 2021-08-19 | Wilson | Tennessee | 47189 | 21466 | 262 |
1630809 | 1630809 | 2021-08-18 | Wilson | Tennessee | 47189 | 21321 | 261 |
1627562 | 1627562 | 2021-08-17 | Wilson | Tennessee | 47189 | 21195 | 262 |
1624315 | 1624315 | 2021-08-16 | Wilson | Tennessee | 47189 | 21125 | 261 |
1621068 | 1621068 | 2021-08-15 | Wilson | Tennessee | 47189 | 20904 | 261 |
1617820 | 1617820 | 2021-08-14 | Wilson | Tennessee | 47189 | 20904 | 261 |
1614572 | 1614572 | 2021-08-13 | Wilson | Tennessee | 47189 | 20904 | 261 |
1611323 | 1611323 | 2021-08-12 | Wilson | Tennessee | 47189 | 20820 | 261 |
1608075 | 1608075 | 2021-08-11 | Wilson | Tennessee | 47189 | 20662 | 261 |
1604826 | 1604826 | 2021-08-10 | Wilson | Tennessee | 47189 | 20576 | 261 |
1601577 | 1601577 | 2021-08-09 | Wilson | Tennessee | 47189 | 20503 | 260 |
1598329 | 1598329 | 2021-08-08 | Wilson | Tennessee | 47189 | 20305 | 260 |
1595080 | 1595080 | 2021-08-07 | Wilson | Tennessee | 47189 | 20305 | 260 |
1591831 | 1591831 | 2021-08-06 | Wilson | Tennessee | 47189 | 20305 | 260 |
1588582 | 1588582 | 2021-08-05 | Wilson | Tennessee | 47189 | 20245 | 260 |
1585332 | 1585332 | 2021-08-04 | Wilson | Tennessee | 47189 | 20190 | 259 |
1582082 | 1582082 | 2021-08-03 | Wilson | Tennessee | 47189 | 20117 | 259 |
1578833 | 1578833 | 2021-08-02 | Wilson | Tennessee | 47189 | 20022 | 260 |
1575585 | 1575585 | 2021-08-01 | Wilson | Tennessee | 47189 | 19878 | 257 |
1572337 | 1572337 | 2021-07-31 | Wilson | Tennessee | 47189 | 19878 | 257 |
1569089 | 1569089 | 2021-07-30 | Wilson | Tennessee | 47189 | 19878 | 257 |
1565841 | 1565841 | 2021-07-29 | Wilson | Tennessee | 47189 | 19844 | 257 |
1562593 | 1562593 | 2021-07-28 | Wilson | Tennessee | 47189 | 19802 | 256 |
1559345 | 1559345 | 2021-07-27 | Wilson | Tennessee | 47189 | 19773 | 255 |
1556098 | 1556098 | 2021-07-26 | Wilson | Tennessee | 47189 | 19704 | 254 |
1552851 | 1552851 | 2021-07-25 | Wilson | Tennessee | 47189 | 19637 | 253 |
1549604 | 1549604 | 2021-07-24 | Wilson | Tennessee | 47189 | 19637 | 253 |
1546357 | 1546357 | 2021-07-23 | Wilson | Tennessee | 47189 | 19637 | 253 |
1543110 | 1543110 | 2021-07-22 | Wilson | Tennessee | 47189 | 19602 | 253 |
1539862 | 1539862 | 2021-07-21 | Wilson | Tennessee | 47189 | 19575 | 252 |
1536615 | 1536615 | 2021-07-20 | Wilson | Tennessee | 47189 | 19556 | 252 |
1533367 | 1533367 | 2021-07-19 | Wilson | Tennessee | 47189 | 19544 | 252 |
1530120 | 1530120 | 2021-07-18 | Wilson | Tennessee | 47189 | 19513 | 252 |
1526873 | 1526873 | 2021-07-17 | Wilson | Tennessee | 47189 | 19513 | 252 |
1523626 | 1523626 | 2021-07-16 | Wilson | Tennessee | 47189 | 19513 | 251 |
1520378 | 1520378 | 2021-07-15 | Wilson | Tennessee | 47189 | 19501 | 251 |
1517130 | 1517130 | 2021-07-14 | Wilson | Tennessee | 47189 | 19491 | 251 |
1513883 | 1513883 | 2021-07-13 | Wilson | Tennessee | 47189 | 19477 | 251 |
1510637 | 1510637 | 2021-07-12 | Wilson | Tennessee | 47189 | 19456 | 250 |
1507390 | 1507390 | 2021-07-11 | Wilson | Tennessee | 47189 | 19435 | 250 |
1504144 | 1504144 | 2021-07-10 | Wilson | Tennessee | 47189 | 19435 | 250 |
1500898 | 1500898 | 2021-07-09 | Wilson | Tennessee | 47189 | 19435 | 250 |
1497652 | 1497652 | 2021-07-08 | Wilson | Tennessee | 47189 | 19427 | 250 |
1494405 | 1494405 | 2021-07-07 | Wilson | Tennessee | 47189 | 19414 | 250 |
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);