ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Sumner" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1815976 | 1815976 | 2021-10-14 | Sumner | Tennessee | 47165 | 33802 | 405 |
1812728 | 1812728 | 2021-10-13 | Sumner | Tennessee | 47165 | 33735 | 405 |
1809479 | 1809479 | 2021-10-12 | Sumner | Tennessee | 47165 | 33669 | 405 |
1806229 | 1806229 | 2021-10-11 | Sumner | Tennessee | 47165 | 33636 | 403 |
1802979 | 1802979 | 2021-10-10 | Sumner | Tennessee | 47165 | 33528 | 403 |
1799730 | 1799730 | 2021-10-09 | Sumner | Tennessee | 47165 | 33528 | 403 |
1796481 | 1796481 | 2021-10-08 | Sumner | Tennessee | 47165 | 33528 | 403 |
1793232 | 1793232 | 2021-10-07 | Sumner | Tennessee | 47165 | 33446 | 403 |
1789983 | 1789983 | 2021-10-06 | Sumner | Tennessee | 47165 | 33392 | 403 |
1786735 | 1786735 | 2021-10-05 | Sumner | Tennessee | 47165 | 33342 | 403 |
1783486 | 1783486 | 2021-10-04 | Sumner | Tennessee | 47165 | 33318 | 402 |
1780237 | 1780237 | 2021-10-03 | Sumner | Tennessee | 47165 | 33172 | 402 |
1776987 | 1776987 | 2021-10-02 | Sumner | Tennessee | 47165 | 33172 | 402 |
1773737 | 1773737 | 2021-10-01 | Sumner | Tennessee | 47165 | 33172 | 402 |
1770487 | 1770487 | 2021-09-30 | Sumner | Tennessee | 47165 | 33100 | 401 |
1767238 | 1767238 | 2021-09-29 | Sumner | Tennessee | 47165 | 33027 | 399 |
1763989 | 1763989 | 2021-09-28 | Sumner | Tennessee | 47165 | 32944 | 399 |
1760740 | 1760740 | 2021-09-27 | Sumner | Tennessee | 47165 | 32898 | 399 |
1757492 | 1757492 | 2021-09-26 | Sumner | Tennessee | 47165 | 32739 | 395 |
1754244 | 1754244 | 2021-09-25 | Sumner | Tennessee | 47165 | 32739 | 395 |
1750996 | 1750996 | 2021-09-24 | Sumner | Tennessee | 47165 | 32739 | 395 |
1747747 | 1747747 | 2021-09-23 | Sumner | Tennessee | 47165 | 32636 | 393 |
1744497 | 1744497 | 2021-09-22 | Sumner | Tennessee | 47165 | 32544 | 393 |
1741248 | 1741248 | 2021-09-21 | Sumner | Tennessee | 47165 | 32399 | 393 |
1737999 | 1737999 | 2021-09-20 | Sumner | Tennessee | 47165 | 32399 | 393 |
1734749 | 1734749 | 2021-09-19 | Sumner | Tennessee | 47165 | 32184 | 392 |
1731499 | 1731499 | 2021-09-18 | Sumner | Tennessee | 47165 | 32184 | 392 |
1728249 | 1728249 | 2021-09-17 | Sumner | Tennessee | 47165 | 32184 | 392 |
1725000 | 1725000 | 2021-09-16 | Sumner | Tennessee | 47165 | 32103 | 392 |
1721751 | 1721751 | 2021-09-15 | Sumner | Tennessee | 47165 | 31992 | 391 |
1718503 | 1718503 | 2021-09-14 | Sumner | Tennessee | 47165 | 31788 | 391 |
1715255 | 1715255 | 2021-09-13 | Sumner | Tennessee | 47165 | 31688 | 389 |
1712009 | 1712009 | 2021-09-12 | Sumner | Tennessee | 47165 | 31121 | 388 |
1708762 | 1708762 | 2021-09-11 | Sumner | Tennessee | 47165 | 31121 | 388 |
1705515 | 1705515 | 2021-09-10 | Sumner | Tennessee | 47165 | 31121 | 388 |
1702265 | 1702265 | 2021-09-09 | Sumner | Tennessee | 47165 | 31021 | 388 |
1699016 | 1699016 | 2021-09-08 | Sumner | Tennessee | 47165 | 30897 | 386 |
1695768 | 1695768 | 2021-09-07 | Sumner | Tennessee | 47165 | 30827 | 383 |
1692520 | 1692520 | 2021-09-06 | Sumner | Tennessee | 47165 | 30035 | 379 |
1689271 | 1689271 | 2021-09-05 | Sumner | Tennessee | 47165 | 30035 | 379 |
1686021 | 1686021 | 2021-09-04 | Sumner | Tennessee | 47165 | 30035 | 379 |
1682770 | 1682770 | 2021-09-03 | Sumner | Tennessee | 47165 | 30035 | 379 |
1679520 | 1679520 | 2021-09-02 | Sumner | Tennessee | 47165 | 29854 | 377 |
1676272 | 1676272 | 2021-09-01 | Sumner | Tennessee | 47165 | 29801 | 377 |
1673025 | 1673025 | 2021-08-31 | Sumner | Tennessee | 47165 | 29584 | 377 |
1669777 | 1669777 | 2021-08-30 | Sumner | Tennessee | 47165 | 29350 | 376 |
1666530 | 1666530 | 2021-08-29 | Sumner | Tennessee | 47165 | 28853 | 375 |
1663282 | 1663282 | 2021-08-28 | Sumner | Tennessee | 47165 | 28853 | 375 |
1660034 | 1660034 | 2021-08-27 | Sumner | Tennessee | 47165 | 28853 | 375 |
1656785 | 1656785 | 2021-08-26 | Sumner | Tennessee | 47165 | 28653 | 375 |
1653538 | 1653538 | 2021-08-25 | Sumner | Tennessee | 47165 | 28357 | 374 |
1650291 | 1650291 | 2021-08-24 | Sumner | Tennessee | 47165 | 28357 | 374 |
1647042 | 1647042 | 2021-08-23 | Sumner | Tennessee | 47165 | 28216 | 374 |
1643793 | 1643793 | 2021-08-22 | Sumner | Tennessee | 47165 | 27666 | 370 |
1640543 | 1640543 | 2021-08-21 | Sumner | Tennessee | 47165 | 27666 | 370 |
1637293 | 1637293 | 2021-08-20 | Sumner | Tennessee | 47165 | 27666 | 370 |
1634043 | 1634043 | 2021-08-19 | Sumner | Tennessee | 47165 | 27498 | 368 |
1630796 | 1630796 | 2021-08-18 | Sumner | Tennessee | 47165 | 27283 | 367 |
1627549 | 1627549 | 2021-08-17 | Sumner | Tennessee | 47165 | 27137 | 367 |
1624302 | 1624302 | 2021-08-16 | Sumner | Tennessee | 47165 | 27032 | 366 |
1621055 | 1621055 | 2021-08-15 | Sumner | Tennessee | 47165 | 26688 | 364 |
1617807 | 1617807 | 2021-08-14 | Sumner | Tennessee | 47165 | 26688 | 364 |
1614559 | 1614559 | 2021-08-13 | Sumner | Tennessee | 47165 | 26688 | 364 |
1611310 | 1611310 | 2021-08-12 | Sumner | Tennessee | 47165 | 26562 | 364 |
1608062 | 1608062 | 2021-08-11 | Sumner | Tennessee | 47165 | 26379 | 364 |
1604813 | 1604813 | 2021-08-10 | Sumner | Tennessee | 47165 | 26234 | 364 |
1601564 | 1601564 | 2021-08-09 | Sumner | Tennessee | 47165 | 26151 | 364 |
1598316 | 1598316 | 2021-08-08 | Sumner | Tennessee | 47165 | 25922 | 364 |
1595067 | 1595067 | 2021-08-07 | Sumner | Tennessee | 47165 | 25922 | 364 |
1591818 | 1591818 | 2021-08-06 | Sumner | Tennessee | 47165 | 25922 | 364 |
1588569 | 1588569 | 2021-08-05 | Sumner | Tennessee | 47165 | 25814 | 364 |
1585319 | 1585319 | 2021-08-04 | Sumner | Tennessee | 47165 | 25751 | 364 |
1582069 | 1582069 | 2021-08-03 | Sumner | Tennessee | 47165 | 25647 | 364 |
1578820 | 1578820 | 2021-08-02 | Sumner | Tennessee | 47165 | 25579 | 364 |
1575572 | 1575572 | 2021-08-01 | Sumner | Tennessee | 47165 | 25399 | 362 |
1572324 | 1572324 | 2021-07-31 | Sumner | Tennessee | 47165 | 25399 | 362 |
1569076 | 1569076 | 2021-07-30 | Sumner | Tennessee | 47165 | 25399 | 362 |
1565828 | 1565828 | 2021-07-29 | Sumner | Tennessee | 47165 | 25348 | 362 |
1562580 | 1562580 | 2021-07-28 | Sumner | Tennessee | 47165 | 25292 | 362 |
1559332 | 1559332 | 2021-07-27 | Sumner | Tennessee | 47165 | 25235 | 361 |
1556085 | 1556085 | 2021-07-26 | Sumner | Tennessee | 47165 | 25183 | 361 |
1552838 | 1552838 | 2021-07-25 | Sumner | Tennessee | 47165 | 25096 | 360 |
1549591 | 1549591 | 2021-07-24 | Sumner | Tennessee | 47165 | 25096 | 360 |
1546344 | 1546344 | 2021-07-23 | Sumner | Tennessee | 47165 | 25096 | 360 |
1543097 | 1543097 | 2021-07-22 | Sumner | Tennessee | 47165 | 25054 | 360 |
1539849 | 1539849 | 2021-07-21 | Sumner | Tennessee | 47165 | 25015 | 359 |
1536602 | 1536602 | 2021-07-20 | Sumner | Tennessee | 47165 | 24971 | 359 |
1533354 | 1533354 | 2021-07-19 | Sumner | Tennessee | 47165 | 24940 | 359 |
1530107 | 1530107 | 2021-07-18 | Sumner | Tennessee | 47165 | 24864 | 359 |
1526860 | 1526860 | 2021-07-17 | Sumner | Tennessee | 47165 | 24864 | 359 |
1523613 | 1523613 | 2021-07-16 | Sumner | Tennessee | 47165 | 24864 | 358 |
1520365 | 1520365 | 2021-07-15 | Sumner | Tennessee | 47165 | 24832 | 358 |
1517117 | 1517117 | 2021-07-14 | Sumner | Tennessee | 47165 | 24810 | 358 |
1513870 | 1513870 | 2021-07-13 | Sumner | Tennessee | 47165 | 24771 | 358 |
1510624 | 1510624 | 2021-07-12 | Sumner | Tennessee | 47165 | 24742 | 358 |
1507377 | 1507377 | 2021-07-11 | Sumner | Tennessee | 47165 | 24687 | 355 |
1504131 | 1504131 | 2021-07-10 | Sumner | Tennessee | 47165 | 24687 | 355 |
1500885 | 1500885 | 2021-07-09 | Sumner | Tennessee | 47165 | 24687 | 355 |
1497639 | 1497639 | 2021-07-08 | Sumner | Tennessee | 47165 | 24657 | 355 |
1494392 | 1494392 | 2021-07-07 | Sumner | Tennessee | 47165 | 24637 | 355 |
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);