ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where county = "Williamson" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1815988 | 1815988 | 2021-10-14 | Williamson | Tennessee | 47187 | 39152 | 266 |
1812740 | 1812740 | 2021-10-13 | Williamson | Tennessee | 47187 | 39106 | 264 |
1809491 | 1809491 | 2021-10-12 | Williamson | Tennessee | 47187 | 39049 | 264 |
1806241 | 1806241 | 2021-10-11 | Williamson | Tennessee | 47187 | 38996 | 263 |
1802991 | 1802991 | 2021-10-10 | Williamson | Tennessee | 47187 | 38825 | 261 |
1799742 | 1799742 | 2021-10-09 | Williamson | Tennessee | 47187 | 38825 | 261 |
1796493 | 1796493 | 2021-10-08 | Williamson | Tennessee | 47187 | 38825 | 261 |
1793244 | 1793244 | 2021-10-07 | Williamson | Tennessee | 47187 | 38691 | 261 |
1789995 | 1789995 | 2021-10-06 | Williamson | Tennessee | 47187 | 38646 | 261 |
1786747 | 1786747 | 2021-10-05 | Williamson | Tennessee | 47187 | 38606 | 261 |
1783498 | 1783498 | 2021-10-04 | Williamson | Tennessee | 47187 | 38570 | 261 |
1780249 | 1780249 | 2021-10-03 | Williamson | Tennessee | 47187 | 38385 | 261 |
1776999 | 1776999 | 2021-10-02 | Williamson | Tennessee | 47187 | 38385 | 261 |
1773749 | 1773749 | 2021-10-01 | Williamson | Tennessee | 47187 | 38385 | 261 |
1770499 | 1770499 | 2021-09-30 | Williamson | Tennessee | 47187 | 38296 | 260 |
1767250 | 1767250 | 2021-09-29 | Williamson | Tennessee | 47187 | 38170 | 258 |
1764001 | 1764001 | 2021-09-28 | Williamson | Tennessee | 47187 | 38060 | 258 |
1760752 | 1760752 | 2021-09-27 | Williamson | Tennessee | 47187 | 37979 | 258 |
1757504 | 1757504 | 2021-09-26 | Williamson | Tennessee | 47187 | 37785 | 254 |
1754256 | 1754256 | 2021-09-25 | Williamson | Tennessee | 47187 | 37785 | 254 |
1751008 | 1751008 | 2021-09-24 | Williamson | Tennessee | 47187 | 37785 | 254 |
1747759 | 1747759 | 2021-09-23 | Williamson | Tennessee | 47187 | 37656 | 253 |
1744509 | 1744509 | 2021-09-22 | Williamson | Tennessee | 47187 | 37554 | 253 |
1741260 | 1741260 | 2021-09-21 | Williamson | Tennessee | 47187 | 37372 | 253 |
1738011 | 1738011 | 2021-09-20 | Williamson | Tennessee | 47187 | 37372 | 253 |
1734761 | 1734761 | 2021-09-19 | Williamson | Tennessee | 47187 | 37081 | 253 |
1731511 | 1731511 | 2021-09-18 | Williamson | Tennessee | 47187 | 37081 | 253 |
1728261 | 1728261 | 2021-09-17 | Williamson | Tennessee | 47187 | 37081 | 253 |
1725012 | 1725012 | 2021-09-16 | Williamson | Tennessee | 47187 | 36959 | 249 |
1721763 | 1721763 | 2021-09-15 | Williamson | Tennessee | 47187 | 36824 | 249 |
1718515 | 1718515 | 2021-09-14 | Williamson | Tennessee | 47187 | 36620 | 249 |
1715267 | 1715267 | 2021-09-13 | Williamson | Tennessee | 47187 | 36500 | 248 |
1712021 | 1712021 | 2021-09-12 | Williamson | Tennessee | 47187 | 35818 | 246 |
1708774 | 1708774 | 2021-09-11 | Williamson | Tennessee | 47187 | 35818 | 246 |
1705527 | 1705527 | 2021-09-10 | Williamson | Tennessee | 47187 | 35818 | 246 |
1702277 | 1702277 | 2021-09-09 | Williamson | Tennessee | 47187 | 35681 | 246 |
1699028 | 1699028 | 2021-09-08 | Williamson | Tennessee | 47187 | 35547 | 246 |
1695780 | 1695780 | 2021-09-07 | Williamson | Tennessee | 47187 | 35375 | 246 |
1692532 | 1692532 | 2021-09-06 | Williamson | Tennessee | 47187 | 34463 | 244 |
1689283 | 1689283 | 2021-09-05 | Williamson | Tennessee | 47187 | 34463 | 244 |
1686033 | 1686033 | 2021-09-04 | Williamson | Tennessee | 47187 | 34463 | 244 |
1682782 | 1682782 | 2021-09-03 | Williamson | Tennessee | 47187 | 34463 | 244 |
1679532 | 1679532 | 2021-09-02 | Williamson | Tennessee | 47187 | 34283 | 243 |
1676284 | 1676284 | 2021-09-01 | Williamson | Tennessee | 47187 | 34190 | 241 |
1673037 | 1673037 | 2021-08-31 | Williamson | Tennessee | 47187 | 33943 | 240 |
1669789 | 1669789 | 2021-08-30 | Williamson | Tennessee | 47187 | 33706 | 239 |
1666542 | 1666542 | 2021-08-29 | Williamson | Tennessee | 47187 | 33250 | 235 |
1663294 | 1663294 | 2021-08-28 | Williamson | Tennessee | 47187 | 33250 | 235 |
1660046 | 1660046 | 2021-08-27 | Williamson | Tennessee | 47187 | 33250 | 235 |
1656797 | 1656797 | 2021-08-26 | Williamson | Tennessee | 47187 | 33045 | 233 |
1653550 | 1653550 | 2021-08-25 | Williamson | Tennessee | 47187 | 32743 | 233 |
1650303 | 1650303 | 2021-08-24 | Williamson | Tennessee | 47187 | 32743 | 233 |
1647054 | 1647054 | 2021-08-23 | Williamson | Tennessee | 47187 | 32599 | 233 |
1643805 | 1643805 | 2021-08-22 | Williamson | Tennessee | 47187 | 32104 | 231 |
1640555 | 1640555 | 2021-08-21 | Williamson | Tennessee | 47187 | 32104 | 231 |
1637305 | 1637305 | 2021-08-20 | Williamson | Tennessee | 47187 | 32104 | 231 |
1634055 | 1634055 | 2021-08-19 | Williamson | Tennessee | 47187 | 31945 | 229 |
1630808 | 1630808 | 2021-08-18 | Williamson | Tennessee | 47187 | 31794 | 228 |
1627561 | 1627561 | 2021-08-17 | Williamson | Tennessee | 47187 | 31673 | 228 |
1624314 | 1624314 | 2021-08-16 | Williamson | Tennessee | 47187 | 31550 | 228 |
1621067 | 1621067 | 2021-08-15 | Williamson | Tennessee | 47187 | 31172 | 225 |
1617819 | 1617819 | 2021-08-14 | Williamson | Tennessee | 47187 | 31172 | 225 |
1614571 | 1614571 | 2021-08-13 | Williamson | Tennessee | 47187 | 31172 | 225 |
1611322 | 1611322 | 2021-08-12 | Williamson | Tennessee | 47187 | 31030 | 225 |
1608074 | 1608074 | 2021-08-11 | Williamson | Tennessee | 47187 | 30857 | 224 |
1604825 | 1604825 | 2021-08-10 | Williamson | Tennessee | 47187 | 30737 | 224 |
1601576 | 1601576 | 2021-08-09 | Williamson | Tennessee | 47187 | 30638 | 222 |
1598328 | 1598328 | 2021-08-08 | Williamson | Tennessee | 47187 | 30340 | 222 |
1595079 | 1595079 | 2021-08-07 | Williamson | Tennessee | 47187 | 30340 | 222 |
1591830 | 1591830 | 2021-08-06 | Williamson | Tennessee | 47187 | 30340 | 222 |
1588581 | 1588581 | 2021-08-05 | Williamson | Tennessee | 47187 | 30217 | 221 |
1585331 | 1585331 | 2021-08-04 | Williamson | Tennessee | 47187 | 30096 | 221 |
1582081 | 1582081 | 2021-08-03 | Williamson | Tennessee | 47187 | 29994 | 220 |
1578832 | 1578832 | 2021-08-02 | Williamson | Tennessee | 47187 | 29895 | 220 |
1575584 | 1575584 | 2021-08-01 | Williamson | Tennessee | 47187 | 29614 | 220 |
1572336 | 1572336 | 2021-07-31 | Williamson | Tennessee | 47187 | 29614 | 220 |
1569088 | 1569088 | 2021-07-30 | Williamson | Tennessee | 47187 | 29614 | 220 |
1565840 | 1565840 | 2021-07-29 | Williamson | Tennessee | 47187 | 29563 | 220 |
1562592 | 1562592 | 2021-07-28 | Williamson | Tennessee | 47187 | 29452 | 220 |
1559344 | 1559344 | 2021-07-27 | Williamson | Tennessee | 47187 | 29377 | 220 |
1556097 | 1556097 | 2021-07-26 | Williamson | Tennessee | 47187 | 29285 | 220 |
1552850 | 1552850 | 2021-07-25 | Williamson | Tennessee | 47187 | 29118 | 219 |
1549603 | 1549603 | 2021-07-24 | Williamson | Tennessee | 47187 | 29118 | 219 |
1546356 | 1546356 | 2021-07-23 | Williamson | Tennessee | 47187 | 29118 | 219 |
1543109 | 1543109 | 2021-07-22 | Williamson | Tennessee | 47187 | 29078 | 219 |
1539861 | 1539861 | 2021-07-21 | Williamson | Tennessee | 47187 | 29014 | 219 |
1536614 | 1536614 | 2021-07-20 | Williamson | Tennessee | 47187 | 28971 | 219 |
1533366 | 1533366 | 2021-07-19 | Williamson | Tennessee | 47187 | 28933 | 219 |
1530119 | 1530119 | 2021-07-18 | Williamson | Tennessee | 47187 | 28865 | 219 |
1526872 | 1526872 | 2021-07-17 | Williamson | Tennessee | 47187 | 28865 | 219 |
1523625 | 1523625 | 2021-07-16 | Williamson | Tennessee | 47187 | 28865 | 219 |
1520377 | 1520377 | 2021-07-15 | Williamson | Tennessee | 47187 | 28834 | 219 |
1517129 | 1517129 | 2021-07-14 | Williamson | Tennessee | 47187 | 28817 | 219 |
1513882 | 1513882 | 2021-07-13 | Williamson | Tennessee | 47187 | 28781 | 219 |
1510636 | 1510636 | 2021-07-12 | Williamson | Tennessee | 47187 | 28767 | 219 |
1507389 | 1507389 | 2021-07-11 | Williamson | Tennessee | 47187 | 28732 | 218 |
1504143 | 1504143 | 2021-07-10 | Williamson | Tennessee | 47187 | 28732 | 218 |
1500897 | 1500897 | 2021-07-09 | Williamson | Tennessee | 47187 | 28732 | 218 |
1497651 | 1497651 | 2021-07-08 | Williamson | Tennessee | 47187 | 28714 | 218 |
1494404 | 1494404 | 2021-07-07 | Williamson | Tennessee | 47187 | 28699 | 218 |
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);