ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Montgomery" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1815956 | 1815956 | 2021-10-14 | Montgomery | Tennessee | 47125 | 32429 | 323 |
1812708 | 1812708 | 2021-10-13 | Montgomery | Tennessee | 47125 | 32350 | 322 |
1809459 | 1809459 | 2021-10-12 | Montgomery | Tennessee | 47125 | 32294 | 322 |
1806209 | 1806209 | 2021-10-11 | Montgomery | Tennessee | 47125 | 32221 | 322 |
1802959 | 1802959 | 2021-10-10 | Montgomery | Tennessee | 47125 | 32056 | 322 |
1799710 | 1799710 | 2021-10-09 | Montgomery | Tennessee | 47125 | 32056 | 322 |
1796461 | 1796461 | 2021-10-08 | Montgomery | Tennessee | 47125 | 32056 | 322 |
1793212 | 1793212 | 2021-10-07 | Montgomery | Tennessee | 47125 | 31917 | 322 |
1789963 | 1789963 | 2021-10-06 | Montgomery | Tennessee | 47125 | 31834 | 322 |
1786715 | 1786715 | 2021-10-05 | Montgomery | Tennessee | 47125 | 31745 | 318 |
1783466 | 1783466 | 2021-10-04 | Montgomery | Tennessee | 47125 | 31708 | 318 |
1780217 | 1780217 | 2021-10-03 | Montgomery | Tennessee | 47125 | 31513 | 317 |
1776967 | 1776967 | 2021-10-02 | Montgomery | Tennessee | 47125 | 31513 | 317 |
1773717 | 1773717 | 2021-10-01 | Montgomery | Tennessee | 47125 | 31513 | 317 |
1770467 | 1770467 | 2021-09-30 | Montgomery | Tennessee | 47125 | 31415 | 317 |
1767218 | 1767218 | 2021-09-29 | Montgomery | Tennessee | 47125 | 31281 | 316 |
1763969 | 1763969 | 2021-09-28 | Montgomery | Tennessee | 47125 | 31197 | 311 |
1760720 | 1760720 | 2021-09-27 | Montgomery | Tennessee | 47125 | 31102 | 311 |
1757472 | 1757472 | 2021-09-26 | Montgomery | Tennessee | 47125 | 30837 | 302 |
1754224 | 1754224 | 2021-09-25 | Montgomery | Tennessee | 47125 | 30837 | 302 |
1750976 | 1750976 | 2021-09-24 | Montgomery | Tennessee | 47125 | 30837 | 302 |
1747727 | 1747727 | 2021-09-23 | Montgomery | Tennessee | 47125 | 30722 | 299 |
1744477 | 1744477 | 2021-09-22 | Montgomery | Tennessee | 47125 | 30580 | 299 |
1741228 | 1741228 | 2021-09-21 | Montgomery | Tennessee | 47125 | 30348 | 289 |
1737979 | 1737979 | 2021-09-20 | Montgomery | Tennessee | 47125 | 30348 | 289 |
1734729 | 1734729 | 2021-09-19 | Montgomery | Tennessee | 47125 | 29895 | 288 |
1731479 | 1731479 | 2021-09-18 | Montgomery | Tennessee | 47125 | 29895 | 288 |
1728229 | 1728229 | 2021-09-17 | Montgomery | Tennessee | 47125 | 29895 | 288 |
1724980 | 1724980 | 2021-09-16 | Montgomery | Tennessee | 47125 | 29730 | 287 |
1721731 | 1721731 | 2021-09-15 | Montgomery | Tennessee | 47125 | 29587 | 282 |
1718483 | 1718483 | 2021-09-14 | Montgomery | Tennessee | 47125 | 29355 | 276 |
1715235 | 1715235 | 2021-09-13 | Montgomery | Tennessee | 47125 | 29218 | 266 |
1711989 | 1711989 | 2021-09-12 | Montgomery | Tennessee | 47125 | 28295 | 248 |
1708742 | 1708742 | 2021-09-11 | Montgomery | Tennessee | 47125 | 28295 | 248 |
1705495 | 1705495 | 2021-09-10 | Montgomery | Tennessee | 47125 | 28295 | 248 |
1702245 | 1702245 | 2021-09-09 | Montgomery | Tennessee | 47125 | 28146 | 247 |
1698996 | 1698996 | 2021-09-08 | Montgomery | Tennessee | 47125 | 27946 | 246 |
1695748 | 1695748 | 2021-09-07 | Montgomery | Tennessee | 47125 | 27711 | 245 |
1692500 | 1692500 | 2021-09-06 | Montgomery | Tennessee | 47125 | 26446 | 245 |
1689251 | 1689251 | 2021-09-05 | Montgomery | Tennessee | 47125 | 26446 | 245 |
1686001 | 1686001 | 2021-09-04 | Montgomery | Tennessee | 47125 | 26446 | 245 |
1682750 | 1682750 | 2021-09-03 | Montgomery | Tennessee | 47125 | 26446 | 245 |
1679500 | 1679500 | 2021-09-02 | Montgomery | Tennessee | 47125 | 26217 | 241 |
1676252 | 1676252 | 2021-09-01 | Montgomery | Tennessee | 47125 | 26146 | 241 |
1673005 | 1673005 | 2021-08-31 | Montgomery | Tennessee | 47125 | 25686 | 241 |
1669757 | 1669757 | 2021-08-30 | Montgomery | Tennessee | 47125 | 25366 | 240 |
1666510 | 1666510 | 2021-08-29 | Montgomery | Tennessee | 47125 | 24951 | 239 |
1663262 | 1663262 | 2021-08-28 | Montgomery | Tennessee | 47125 | 24951 | 239 |
1660014 | 1660014 | 2021-08-27 | Montgomery | Tennessee | 47125 | 24951 | 239 |
1656765 | 1656765 | 2021-08-26 | Montgomery | Tennessee | 47125 | 24704 | 238 |
1653518 | 1653518 | 2021-08-25 | Montgomery | Tennessee | 47125 | 24432 | 238 |
1650271 | 1650271 | 2021-08-24 | Montgomery | Tennessee | 47125 | 24432 | 238 |
1647022 | 1647022 | 2021-08-23 | Montgomery | Tennessee | 47125 | 24305 | 238 |
1643773 | 1643773 | 2021-08-22 | Montgomery | Tennessee | 47125 | 23879 | 238 |
1640523 | 1640523 | 2021-08-21 | Montgomery | Tennessee | 47125 | 23879 | 238 |
1637273 | 1637273 | 2021-08-20 | Montgomery | Tennessee | 47125 | 23879 | 238 |
1634023 | 1634023 | 2021-08-19 | Montgomery | Tennessee | 47125 | 23753 | 238 |
1630776 | 1630776 | 2021-08-18 | Montgomery | Tennessee | 47125 | 23614 | 237 |
1627529 | 1627529 | 2021-08-17 | Montgomery | Tennessee | 47125 | 23465 | 237 |
1624282 | 1624282 | 2021-08-16 | Montgomery | Tennessee | 47125 | 23369 | 236 |
1621035 | 1621035 | 2021-08-15 | Montgomery | Tennessee | 47125 | 23086 | 236 |
1617787 | 1617787 | 2021-08-14 | Montgomery | Tennessee | 47125 | 23086 | 236 |
1614539 | 1614539 | 2021-08-13 | Montgomery | Tennessee | 47125 | 23086 | 236 |
1611290 | 1611290 | 2021-08-12 | Montgomery | Tennessee | 47125 | 22979 | 236 |
1608042 | 1608042 | 2021-08-11 | Montgomery | Tennessee | 47125 | 22833 | 236 |
1604793 | 1604793 | 2021-08-10 | Montgomery | Tennessee | 47125 | 22719 | 236 |
1601544 | 1601544 | 2021-08-09 | Montgomery | Tennessee | 47125 | 22609 | 236 |
1598296 | 1598296 | 2021-08-08 | Montgomery | Tennessee | 47125 | 22324 | 236 |
1595047 | 1595047 | 2021-08-07 | Montgomery | Tennessee | 47125 | 22324 | 236 |
1591798 | 1591798 | 2021-08-06 | Montgomery | Tennessee | 47125 | 22324 | 236 |
1588549 | 1588549 | 2021-08-05 | Montgomery | Tennessee | 47125 | 22204 | 236 |
1585299 | 1585299 | 2021-08-04 | Montgomery | Tennessee | 47125 | 22091 | 236 |
1582049 | 1582049 | 2021-08-03 | Montgomery | Tennessee | 47125 | 21998 | 235 |
1578800 | 1578800 | 2021-08-02 | Montgomery | Tennessee | 47125 | 21917 | 235 |
1575552 | 1575552 | 2021-08-01 | Montgomery | Tennessee | 47125 | 21734 | 235 |
1572304 | 1572304 | 2021-07-31 | Montgomery | Tennessee | 47125 | 21734 | 235 |
1569056 | 1569056 | 2021-07-30 | Montgomery | Tennessee | 47125 | 21734 | 235 |
1565808 | 1565808 | 2021-07-29 | Montgomery | Tennessee | 47125 | 21677 | 235 |
1562560 | 1562560 | 2021-07-28 | Montgomery | Tennessee | 47125 | 21622 | 235 |
1559312 | 1559312 | 2021-07-27 | Montgomery | Tennessee | 47125 | 21554 | 235 |
1556065 | 1556065 | 2021-07-26 | Montgomery | Tennessee | 47125 | 21511 | 235 |
1552818 | 1552818 | 2021-07-25 | Montgomery | Tennessee | 47125 | 21417 | 237 |
1549571 | 1549571 | 2021-07-24 | Montgomery | Tennessee | 47125 | 21417 | 237 |
1546324 | 1546324 | 2021-07-23 | Montgomery | Tennessee | 47125 | 21417 | 237 |
1543077 | 1543077 | 2021-07-22 | Montgomery | Tennessee | 47125 | 21373 | 237 |
1539829 | 1539829 | 2021-07-21 | Montgomery | Tennessee | 47125 | 21343 | 237 |
1536582 | 1536582 | 2021-07-20 | Montgomery | Tennessee | 47125 | 21311 | 237 |
1533334 | 1533334 | 2021-07-19 | Montgomery | Tennessee | 47125 | 21289 | 237 |
1530087 | 1530087 | 2021-07-18 | Montgomery | Tennessee | 47125 | 21233 | 236 |
1526840 | 1526840 | 2021-07-17 | Montgomery | Tennessee | 47125 | 21233 | 236 |
1523593 | 1523593 | 2021-07-16 | Montgomery | Tennessee | 47125 | 21233 | 236 |
1520345 | 1520345 | 2021-07-15 | Montgomery | Tennessee | 47125 | 21210 | 236 |
1517097 | 1517097 | 2021-07-14 | Montgomery | Tennessee | 47125 | 21183 | 235 |
1513850 | 1513850 | 2021-07-13 | Montgomery | Tennessee | 47125 | 21168 | 235 |
1510604 | 1510604 | 2021-07-12 | Montgomery | Tennessee | 47125 | 21156 | 235 |
1507357 | 1507357 | 2021-07-11 | Montgomery | Tennessee | 47125 | 21129 | 234 |
1504111 | 1504111 | 2021-07-10 | Montgomery | Tennessee | 47125 | 21129 | 234 |
1500865 | 1500865 | 2021-07-09 | Montgomery | Tennessee | 47125 | 21129 | 234 |
1497619 | 1497619 | 2021-07-08 | Montgomery | Tennessee | 47125 | 21120 | 234 |
1494372 | 1494372 | 2021-07-07 | Montgomery | Tennessee | 47125 | 21108 | 234 |
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);