ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Montgomery" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1948165 | 1948165 | 2021-11-24 | Montgomery | Missouri | 29139 | 1593 | 34 |
1944914 | 1944914 | 2021-11-23 | Montgomery | Missouri | 29139 | 1591 | 33 |
1941663 | 1941663 | 2021-11-22 | Montgomery | Missouri | 29139 | 1590 | 32 |
1938413 | 1938413 | 2021-11-21 | Montgomery | Missouri | 29139 | 1590 | 32 |
1935163 | 1935163 | 2021-11-20 | Montgomery | Missouri | 29139 | 1590 | 32 |
1931913 | 1931913 | 2021-11-19 | Montgomery | Missouri | 29139 | 1590 | 32 |
1928662 | 1928662 | 2021-11-18 | Montgomery | Missouri | 29139 | 1588 | 32 |
1925412 | 1925412 | 2021-11-17 | Montgomery | Missouri | 29139 | 1570 | 20 |
1922163 | 1922163 | 2021-11-16 | Montgomery | Missouri | 29139 | 1568 | 20 |
1918913 | 1918913 | 2021-11-15 | Montgomery | Missouri | 29139 | 1565 | 20 |
1915663 | 1915663 | 2021-11-14 | Montgomery | Missouri | 29139 | 1565 | 20 |
1912413 | 1912413 | 2021-11-13 | Montgomery | Missouri | 29139 | 1563 | 20 |
1909163 | 1909163 | 2021-11-12 | Montgomery | Missouri | 29139 | 1561 | 20 |
1905914 | 1905914 | 2021-11-11 | Montgomery | Missouri | 29139 | 1555 | 20 |
1902665 | 1902665 | 2021-11-10 | Montgomery | Missouri | 29139 | 1555 | 20 |
1899415 | 1899415 | 2021-11-09 | Montgomery | Missouri | 29139 | 1553 | 19 |
1896165 | 1896165 | 2021-11-08 | Montgomery | Missouri | 29139 | 1549 | 19 |
1892915 | 1892915 | 2021-11-07 | Montgomery | Missouri | 29139 | 1549 | 19 |
1889665 | 1889665 | 2021-11-06 | Montgomery | Missouri | 29139 | 1547 | 19 |
1886415 | 1886415 | 2021-11-05 | Montgomery | Missouri | 29139 | 1546 | 19 |
1883166 | 1883166 | 2021-11-04 | Montgomery | Missouri | 29139 | 1545 | 19 |
1879917 | 1879917 | 2021-11-03 | Montgomery | Missouri | 29139 | 1545 | 19 |
1876668 | 1876668 | 2021-11-02 | Montgomery | Missouri | 29139 | 1543 | 19 |
1873419 | 1873419 | 2021-11-01 | Montgomery | Missouri | 29139 | 1542 | 18 |
1870170 | 1870170 | 2021-10-31 | Montgomery | Missouri | 29139 | 1541 | 18 |
1866921 | 1866921 | 2021-10-30 | Montgomery | Missouri | 29139 | 1541 | 18 |
1863672 | 1863672 | 2021-10-29 | Montgomery | Missouri | 29139 | 1537 | 18 |
1860423 | 1860423 | 2021-10-28 | Montgomery | Missouri | 29139 | 1535 | 18 |
1857174 | 1857174 | 2021-10-27 | Montgomery | Missouri | 29139 | 1532 | 18 |
1853925 | 1853925 | 2021-10-26 | Montgomery | Missouri | 29139 | 1531 | 18 |
1850676 | 1850676 | 2021-10-25 | Montgomery | Missouri | 29139 | 1528 | 19 |
1847426 | 1847426 | 2021-10-24 | Montgomery | Missouri | 29139 | 1528 | 19 |
1844176 | 1844176 | 2021-10-23 | Montgomery | Missouri | 29139 | 1527 | 19 |
1840926 | 1840926 | 2021-10-22 | Montgomery | Missouri | 29139 | 1525 | 19 |
1837677 | 1837677 | 2021-10-21 | Montgomery | Missouri | 29139 | 1525 | 19 |
1834428 | 1834428 | 2021-10-20 | Montgomery | Missouri | 29139 | 1523 | 19 |
1831179 | 1831179 | 2021-10-19 | Montgomery | Missouri | 29139 | 1522 | 19 |
1827930 | 1827930 | 2021-10-18 | Montgomery | Missouri | 29139 | 1522 | 19 |
1824681 | 1824681 | 2021-10-17 | Montgomery | Missouri | 29139 | 1522 | 19 |
1821432 | 1821432 | 2021-10-16 | Montgomery | Missouri | 29139 | 1522 | 19 |
1818183 | 1818183 | 2021-10-15 | Montgomery | Missouri | 29139 | 1519 | 19 |
1814934 | 1814934 | 2021-10-14 | Montgomery | Missouri | 29139 | 1513 | 19 |
1811686 | 1811686 | 2021-10-13 | Montgomery | Missouri | 29139 | 1511 | 19 |
1808437 | 1808437 | 2021-10-12 | Montgomery | Missouri | 29139 | 1506 | 19 |
1805186 | 1805186 | 2021-10-11 | Montgomery | Missouri | 29139 | 1504 | 19 |
1801937 | 1801937 | 2021-10-10 | Montgomery | Missouri | 29139 | 1504 | 19 |
1798688 | 1798688 | 2021-10-09 | Montgomery | Missouri | 29139 | 1501 | 19 |
1795439 | 1795439 | 2021-10-08 | Montgomery | Missouri | 29139 | 1497 | 19 |
1792190 | 1792190 | 2021-10-07 | Montgomery | Missouri | 29139 | 1493 | 19 |
1788941 | 1788941 | 2021-10-06 | Montgomery | Missouri | 29139 | 1490 | 19 |
1785693 | 1785693 | 2021-10-05 | Montgomery | Missouri | 29139 | 1486 | 19 |
1782444 | 1782444 | 2021-10-04 | Montgomery | Missouri | 29139 | 1485 | 19 |
1779194 | 1779194 | 2021-10-03 | Montgomery | Missouri | 29139 | 1485 | 19 |
1775944 | 1775944 | 2021-10-02 | Montgomery | Missouri | 29139 | 1483 | 19 |
1772694 | 1772694 | 2021-10-01 | Montgomery | Missouri | 29139 | 1475 | 19 |
1769445 | 1769445 | 2021-09-30 | Montgomery | Missouri | 29139 | 1473 | 19 |
1766196 | 1766196 | 2021-09-29 | Montgomery | Missouri | 29139 | 1472 | 19 |
1762947 | 1762947 | 2021-09-28 | Montgomery | Missouri | 29139 | 1470 | 19 |
1759698 | 1759698 | 2021-09-27 | Montgomery | Missouri | 29139 | 1467 | 18 |
1756450 | 1756450 | 2021-09-26 | Montgomery | Missouri | 29139 | 1467 | 18 |
1753202 | 1753202 | 2021-09-25 | Montgomery | Missouri | 29139 | 1464 | 18 |
1749954 | 1749954 | 2021-09-24 | Montgomery | Missouri | 29139 | 1463 | 18 |
1746704 | 1746704 | 2021-09-23 | Montgomery | Missouri | 29139 | 1461 | 18 |
1743455 | 1743455 | 2021-09-22 | Montgomery | Missouri | 29139 | 1456 | 18 |
1740206 | 1740206 | 2021-09-21 | Montgomery | Missouri | 29139 | 1449 | 18 |
1736957 | 1736957 | 2021-09-20 | Montgomery | Missouri | 29139 | 1446 | 18 |
1733707 | 1733707 | 2021-09-19 | Montgomery | Missouri | 29139 | 1442 | 18 |
1730457 | 1730457 | 2021-09-18 | Montgomery | Missouri | 29139 | 1439 | 18 |
1727207 | 1727207 | 2021-09-17 | Montgomery | Missouri | 29139 | 1432 | 18 |
1723958 | 1723958 | 2021-09-16 | Montgomery | Missouri | 29139 | 1423 | 18 |
1720709 | 1720709 | 2021-09-15 | Montgomery | Missouri | 29139 | 1417 | 18 |
1717461 | 1717461 | 2021-09-14 | Montgomery | Missouri | 29139 | 1413 | 18 |
1714213 | 1714213 | 2021-09-13 | Montgomery | Missouri | 29139 | 1394 | 17 |
1710967 | 1710967 | 2021-09-12 | Montgomery | Missouri | 29139 | 1392 | 17 |
1707720 | 1707720 | 2021-09-11 | Montgomery | Missouri | 29139 | 1384 | 17 |
1704473 | 1704473 | 2021-09-10 | Montgomery | Missouri | 29139 | 1378 | 17 |
1701223 | 1701223 | 2021-09-09 | Montgomery | Missouri | 29139 | 1371 | 17 |
1697974 | 1697974 | 2021-09-08 | Montgomery | Missouri | 29139 | 1366 | 17 |
1694726 | 1694726 | 2021-09-07 | Montgomery | Missouri | 29139 | 1355 | 17 |
1691477 | 1691477 | 2021-09-06 | Montgomery | Missouri | 29139 | 1354 | 17 |
1688227 | 1688227 | 2021-09-05 | Montgomery | Missouri | 29139 | 1353 | 17 |
1684977 | 1684977 | 2021-09-04 | Montgomery | Missouri | 29139 | 1350 | 17 |
1681726 | 1681726 | 2021-09-03 | Montgomery | Missouri | 29139 | 1340 | 17 |
1678478 | 1678478 | 2021-09-02 | Montgomery | Missouri | 29139 | 1325 | 17 |
1675230 | 1675230 | 2021-09-01 | Montgomery | Missouri | 29139 | 1312 | 17 |
1671982 | 1671982 | 2021-08-31 | Montgomery | Missouri | 29139 | 1308 | 17 |
1668735 | 1668735 | 2021-08-30 | Montgomery | Missouri | 29139 | 1302 | 17 |
1665488 | 1665488 | 2021-08-29 | Montgomery | Missouri | 29139 | 1302 | 17 |
1662240 | 1662240 | 2021-08-28 | Montgomery | Missouri | 29139 | 1300 | 17 |
1658992 | 1658992 | 2021-08-27 | Montgomery | Missouri | 29139 | 1293 | 17 |
1655743 | 1655743 | 2021-08-26 | Montgomery | Missouri | 29139 | 1287 | 17 |
1652496 | 1652496 | 2021-08-25 | Montgomery | Missouri | 29139 | 1281 | 17 |
1649248 | 1649248 | 2021-08-24 | Montgomery | Missouri | 29139 | 1274 | 17 |
1645999 | 1645999 | 2021-08-23 | Montgomery | Missouri | 29139 | 1264 | 17 |
1642750 | 1642750 | 2021-08-22 | Montgomery | Missouri | 29139 | 1264 | 17 |
1639500 | 1639500 | 2021-08-21 | Montgomery | Missouri | 29139 | 1261 | 17 |
1636250 | 1636250 | 2021-08-20 | Montgomery | Missouri | 29139 | 1255 | 17 |
1633000 | 1633000 | 2021-08-19 | Montgomery | Missouri | 29139 | 1243 | 17 |
1629753 | 1629753 | 2021-08-18 | Montgomery | Missouri | 29139 | 1233 | 17 |
1626506 | 1626506 | 2021-08-17 | Montgomery | Missouri | 29139 | 1229 | 17 |
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);