ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
721 rows where county = "Grundy" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1948133 | 1948133 | 2021-11-24 | Grundy | Missouri | 29079 | 1713 | 55 |
1944882 | 1944882 | 2021-11-23 | Grundy | Missouri | 29079 | 1711 | 55 |
1941631 | 1941631 | 2021-11-22 | Grundy | Missouri | 29079 | 1709 | 55 |
1938381 | 1938381 | 2021-11-21 | Grundy | Missouri | 29079 | 1708 | 55 |
1935131 | 1935131 | 2021-11-20 | Grundy | Missouri | 29079 | 1706 | 55 |
1931881 | 1931881 | 2021-11-19 | Grundy | Missouri | 29079 | 1705 | 55 |
1928630 | 1928630 | 2021-11-18 | Grundy | Missouri | 29079 | 1700 | 55 |
1925380 | 1925380 | 2021-11-17 | Grundy | Missouri | 29079 | 1609 | 50 |
1922131 | 1922131 | 2021-11-16 | Grundy | Missouri | 29079 | 1609 | 50 |
1918881 | 1918881 | 2021-11-15 | Grundy | Missouri | 29079 | 1609 | 49 |
1915631 | 1915631 | 2021-11-14 | Grundy | Missouri | 29079 | 1607 | 49 |
1912381 | 1912381 | 2021-11-13 | Grundy | Missouri | 29079 | 1605 | 49 |
1909131 | 1909131 | 2021-11-12 | Grundy | Missouri | 29079 | 1605 | 49 |
1905882 | 1905882 | 2021-11-11 | Grundy | Missouri | 29079 | 1605 | 49 |
1902633 | 1902633 | 2021-11-10 | Grundy | Missouri | 29079 | 1605 | 49 |
1899383 | 1899383 | 2021-11-09 | Grundy | Missouri | 29079 | 1604 | 49 |
1896133 | 1896133 | 2021-11-08 | Grundy | Missouri | 29079 | 1602 | 48 |
1892883 | 1892883 | 2021-11-07 | Grundy | Missouri | 29079 | 1602 | 48 |
1889633 | 1889633 | 2021-11-06 | Grundy | Missouri | 29079 | 1602 | 48 |
1886383 | 1886383 | 2021-11-05 | Grundy | Missouri | 29079 | 1601 | 48 |
1883134 | 1883134 | 2021-11-04 | Grundy | Missouri | 29079 | 1600 | 48 |
1879885 | 1879885 | 2021-11-03 | Grundy | Missouri | 29079 | 1593 | 48 |
1876636 | 1876636 | 2021-11-02 | Grundy | Missouri | 29079 | 1593 | 48 |
1873387 | 1873387 | 2021-11-01 | Grundy | Missouri | 29079 | 1591 | 48 |
1870138 | 1870138 | 2021-10-31 | Grundy | Missouri | 29079 | 1591 | 48 |
1866889 | 1866889 | 2021-10-30 | Grundy | Missouri | 29079 | 1591 | 48 |
1863640 | 1863640 | 2021-10-29 | Grundy | Missouri | 29079 | 1589 | 48 |
1860391 | 1860391 | 2021-10-28 | Grundy | Missouri | 29079 | 1588 | 48 |
1857142 | 1857142 | 2021-10-27 | Grundy | Missouri | 29079 | 1586 | 48 |
1853893 | 1853893 | 2021-10-26 | Grundy | Missouri | 29079 | 1583 | 48 |
1850644 | 1850644 | 2021-10-25 | Grundy | Missouri | 29079 | 1581 | 47 |
1847394 | 1847394 | 2021-10-24 | Grundy | Missouri | 29079 | 1580 | 47 |
1844144 | 1844144 | 2021-10-23 | Grundy | Missouri | 29079 | 1575 | 47 |
1840894 | 1840894 | 2021-10-22 | Grundy | Missouri | 29079 | 1573 | 47 |
1837645 | 1837645 | 2021-10-21 | Grundy | Missouri | 29079 | 1571 | 47 |
1834396 | 1834396 | 2021-10-20 | Grundy | Missouri | 29079 | 1569 | 47 |
1831147 | 1831147 | 2021-10-19 | Grundy | Missouri | 29079 | 1568 | 47 |
1827898 | 1827898 | 2021-10-18 | Grundy | Missouri | 29079 | 1565 | 47 |
1824649 | 1824649 | 2021-10-17 | Grundy | Missouri | 29079 | 1563 | 47 |
1821400 | 1821400 | 2021-10-16 | Grundy | Missouri | 29079 | 1560 | 47 |
1818151 | 1818151 | 2021-10-15 | Grundy | Missouri | 29079 | 1558 | 47 |
1814902 | 1814902 | 2021-10-14 | Grundy | Missouri | 29079 | 1555 | 47 |
1811654 | 1811654 | 2021-10-13 | Grundy | Missouri | 29079 | 1550 | 47 |
1808405 | 1808405 | 2021-10-12 | Grundy | Missouri | 29079 | 1550 | 47 |
1805154 | 1805154 | 2021-10-11 | Grundy | Missouri | 29079 | 1548 | 47 |
1801905 | 1801905 | 2021-10-10 | Grundy | Missouri | 29079 | 1548 | 47 |
1798656 | 1798656 | 2021-10-09 | Grundy | Missouri | 29079 | 1546 | 47 |
1795407 | 1795407 | 2021-10-08 | Grundy | Missouri | 29079 | 1543 | 47 |
1792158 | 1792158 | 2021-10-07 | Grundy | Missouri | 29079 | 1542 | 47 |
1788909 | 1788909 | 2021-10-06 | Grundy | Missouri | 29079 | 1535 | 47 |
1785661 | 1785661 | 2021-10-05 | Grundy | Missouri | 29079 | 1534 | 47 |
1782412 | 1782412 | 2021-10-04 | Grundy | Missouri | 29079 | 1530 | 47 |
1779162 | 1779162 | 2021-10-03 | Grundy | Missouri | 29079 | 1527 | 47 |
1775912 | 1775912 | 2021-10-02 | Grundy | Missouri | 29079 | 1526 | 47 |
1772662 | 1772662 | 2021-10-01 | Grundy | Missouri | 29079 | 1521 | 47 |
1769413 | 1769413 | 2021-09-30 | Grundy | Missouri | 29079 | 1519 | 47 |
1766164 | 1766164 | 2021-09-29 | Grundy | Missouri | 29079 | 1515 | 47 |
1762915 | 1762915 | 2021-09-28 | Grundy | Missouri | 29079 | 1506 | 47 |
1759666 | 1759666 | 2021-09-27 | Grundy | Missouri | 29079 | 1502 | 45 |
1756418 | 1756418 | 2021-09-26 | Grundy | Missouri | 29079 | 1502 | 45 |
1753170 | 1753170 | 2021-09-25 | Grundy | Missouri | 29079 | 1501 | 45 |
1749922 | 1749922 | 2021-09-24 | Grundy | Missouri | 29079 | 1499 | 45 |
1746672 | 1746672 | 2021-09-23 | Grundy | Missouri | 29079 | 1495 | 45 |
1743423 | 1743423 | 2021-09-22 | Grundy | Missouri | 29079 | 1490 | 45 |
1740174 | 1740174 | 2021-09-21 | Grundy | Missouri | 29079 | 1484 | 45 |
1736925 | 1736925 | 2021-09-20 | Grundy | Missouri | 29079 | 1477 | 45 |
1733675 | 1733675 | 2021-09-19 | Grundy | Missouri | 29079 | 1475 | 45 |
1730425 | 1730425 | 2021-09-18 | Grundy | Missouri | 29079 | 1473 | 45 |
1727175 | 1727175 | 2021-09-17 | Grundy | Missouri | 29079 | 1466 | 44 |
1723926 | 1723926 | 2021-09-16 | Grundy | Missouri | 29079 | 1462 | 44 |
1720677 | 1720677 | 2021-09-15 | Grundy | Missouri | 29079 | 1459 | 44 |
1717429 | 1717429 | 2021-09-14 | Grundy | Missouri | 29079 | 1455 | 43 |
1714181 | 1714181 | 2021-09-13 | Grundy | Missouri | 29079 | 1452 | 42 |
1710935 | 1710935 | 2021-09-12 | Grundy | Missouri | 29079 | 1451 | 42 |
1707688 | 1707688 | 2021-09-11 | Grundy | Missouri | 29079 | 1444 | 41 |
1704441 | 1704441 | 2021-09-10 | Grundy | Missouri | 29079 | 1438 | 41 |
1701191 | 1701191 | 2021-09-09 | Grundy | Missouri | 29079 | 1428 | 41 |
1697942 | 1697942 | 2021-09-08 | Grundy | Missouri | 29079 | 1425 | 41 |
1694694 | 1694694 | 2021-09-07 | Grundy | Missouri | 29079 | 1422 | 41 |
1691445 | 1691445 | 2021-09-06 | Grundy | Missouri | 29079 | 1421 | 41 |
1688195 | 1688195 | 2021-09-05 | Grundy | Missouri | 29079 | 1419 | 41 |
1684945 | 1684945 | 2021-09-04 | Grundy | Missouri | 29079 | 1415 | 41 |
1681694 | 1681694 | 2021-09-03 | Grundy | Missouri | 29079 | 1410 | 41 |
1678446 | 1678446 | 2021-09-02 | Grundy | Missouri | 29079 | 1404 | 41 |
1675198 | 1675198 | 2021-09-01 | Grundy | Missouri | 29079 | 1399 | 41 |
1671950 | 1671950 | 2021-08-31 | Grundy | Missouri | 29079 | 1393 | 41 |
1668703 | 1668703 | 2021-08-30 | Grundy | Missouri | 29079 | 1391 | 38 |
1665456 | 1665456 | 2021-08-29 | Grundy | Missouri | 29079 | 1390 | 38 |
1662208 | 1662208 | 2021-08-28 | Grundy | Missouri | 29079 | 1390 | 38 |
1658960 | 1658960 | 2021-08-27 | Grundy | Missouri | 29079 | 1385 | 38 |
1655711 | 1655711 | 2021-08-26 | Grundy | Missouri | 29079 | 1383 | 38 |
1652464 | 1652464 | 2021-08-25 | Grundy | Missouri | 29079 | 1376 | 38 |
1649216 | 1649216 | 2021-08-24 | Grundy | Missouri | 29079 | 1372 | 38 |
1645967 | 1645967 | 2021-08-23 | Grundy | Missouri | 29079 | 1371 | 37 |
1642718 | 1642718 | 2021-08-22 | Grundy | Missouri | 29079 | 1364 | 37 |
1639468 | 1639468 | 2021-08-21 | Grundy | Missouri | 29079 | 1357 | 37 |
1636218 | 1636218 | 2021-08-20 | Grundy | Missouri | 29079 | 1347 | 37 |
1632968 | 1632968 | 2021-08-19 | Grundy | Missouri | 29079 | 1338 | 36 |
1629721 | 1629721 | 2021-08-18 | Grundy | Missouri | 29079 | 1317 | 36 |
1626474 | 1626474 | 2021-08-17 | Grundy | Missouri | 29079 | 1310 | 36 |
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);