ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
706 rows where fips = 29171 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1948181 | 1948181 | 2021-11-24 | Putnam | Missouri | 29171 | 680 | 19 |
1944930 | 1944930 | 2021-11-23 | Putnam | Missouri | 29171 | 676 | 19 |
1941679 | 1941679 | 2021-11-22 | Putnam | Missouri | 29171 | 671 | 19 |
1938429 | 1938429 | 2021-11-21 | Putnam | Missouri | 29171 | 671 | 19 |
1935179 | 1935179 | 2021-11-20 | Putnam | Missouri | 29171 | 671 | 19 |
1931929 | 1931929 | 2021-11-19 | Putnam | Missouri | 29171 | 669 | 19 |
1928678 | 1928678 | 2021-11-18 | Putnam | Missouri | 29171 | 669 | 19 |
1925428 | 1925428 | 2021-11-17 | Putnam | Missouri | 29171 | 659 | 11 |
1922179 | 1922179 | 2021-11-16 | Putnam | Missouri | 29171 | 655 | 11 |
1918929 | 1918929 | 2021-11-15 | Putnam | Missouri | 29171 | 655 | 10 |
1915679 | 1915679 | 2021-11-14 | Putnam | Missouri | 29171 | 655 | 10 |
1912429 | 1912429 | 2021-11-13 | Putnam | Missouri | 29171 | 654 | 10 |
1909179 | 1909179 | 2021-11-12 | Putnam | Missouri | 29171 | 653 | 10 |
1905930 | 1905930 | 2021-11-11 | Putnam | Missouri | 29171 | 649 | 10 |
1902681 | 1902681 | 2021-11-10 | Putnam | Missouri | 29171 | 649 | 10 |
1899431 | 1899431 | 2021-11-09 | Putnam | Missouri | 29171 | 638 | 10 |
1896181 | 1896181 | 2021-11-08 | Putnam | Missouri | 29171 | 635 | 10 |
1892931 | 1892931 | 2021-11-07 | Putnam | Missouri | 29171 | 635 | 10 |
1889681 | 1889681 | 2021-11-06 | Putnam | Missouri | 29171 | 635 | 10 |
1886431 | 1886431 | 2021-11-05 | Putnam | Missouri | 29171 | 634 | 10 |
1883182 | 1883182 | 2021-11-04 | Putnam | Missouri | 29171 | 634 | 10 |
1879933 | 1879933 | 2021-11-03 | Putnam | Missouri | 29171 | 632 | 10 |
1876684 | 1876684 | 2021-11-02 | Putnam | Missouri | 29171 | 630 | 10 |
1873435 | 1873435 | 2021-11-01 | Putnam | Missouri | 29171 | 628 | 10 |
1870186 | 1870186 | 2021-10-31 | Putnam | Missouri | 29171 | 628 | 10 |
1866937 | 1866937 | 2021-10-30 | Putnam | Missouri | 29171 | 628 | 10 |
1863688 | 1863688 | 2021-10-29 | Putnam | Missouri | 29171 | 626 | 10 |
1860439 | 1860439 | 2021-10-28 | Putnam | Missouri | 29171 | 623 | 10 |
1857190 | 1857190 | 2021-10-27 | Putnam | Missouri | 29171 | 622 | 10 |
1853941 | 1853941 | 2021-10-26 | Putnam | Missouri | 29171 | 622 | 10 |
1850692 | 1850692 | 2021-10-25 | Putnam | Missouri | 29171 | 622 | 10 |
1847442 | 1847442 | 2021-10-24 | Putnam | Missouri | 29171 | 622 | 10 |
1844192 | 1844192 | 2021-10-23 | Putnam | Missouri | 29171 | 622 | 10 |
1840942 | 1840942 | 2021-10-22 | Putnam | Missouri | 29171 | 622 | 10 |
1837693 | 1837693 | 2021-10-21 | Putnam | Missouri | 29171 | 620 | 10 |
1834444 | 1834444 | 2021-10-20 | Putnam | Missouri | 29171 | 618 | 10 |
1831195 | 1831195 | 2021-10-19 | Putnam | Missouri | 29171 | 617 | 10 |
1827946 | 1827946 | 2021-10-18 | Putnam | Missouri | 29171 | 617 | 10 |
1824697 | 1824697 | 2021-10-17 | Putnam | Missouri | 29171 | 617 | 10 |
1821448 | 1821448 | 2021-10-16 | Putnam | Missouri | 29171 | 617 | 10 |
1818199 | 1818199 | 2021-10-15 | Putnam | Missouri | 29171 | 616 | 10 |
1814950 | 1814950 | 2021-10-14 | Putnam | Missouri | 29171 | 616 | 10 |
1811702 | 1811702 | 2021-10-13 | Putnam | Missouri | 29171 | 615 | 10 |
1808453 | 1808453 | 2021-10-12 | Putnam | Missouri | 29171 | 615 | 9 |
1805202 | 1805202 | 2021-10-11 | Putnam | Missouri | 29171 | 615 | 9 |
1801953 | 1801953 | 2021-10-10 | Putnam | Missouri | 29171 | 614 | 9 |
1798704 | 1798704 | 2021-10-09 | Putnam | Missouri | 29171 | 614 | 9 |
1795455 | 1795455 | 2021-10-08 | Putnam | Missouri | 29171 | 614 | 9 |
1792206 | 1792206 | 2021-10-07 | Putnam | Missouri | 29171 | 613 | 9 |
1788957 | 1788957 | 2021-10-06 | Putnam | Missouri | 29171 | 613 | 9 |
1785709 | 1785709 | 2021-10-05 | Putnam | Missouri | 29171 | 611 | 9 |
1782460 | 1782460 | 2021-10-04 | Putnam | Missouri | 29171 | 608 | 9 |
1779210 | 1779210 | 2021-10-03 | Putnam | Missouri | 29171 | 608 | 9 |
1775960 | 1775960 | 2021-10-02 | Putnam | Missouri | 29171 | 608 | 9 |
1772710 | 1772710 | 2021-10-01 | Putnam | Missouri | 29171 | 607 | 9 |
1769461 | 1769461 | 2021-09-30 | Putnam | Missouri | 29171 | 607 | 9 |
1766212 | 1766212 | 2021-09-29 | Putnam | Missouri | 29171 | 602 | 9 |
1762963 | 1762963 | 2021-09-28 | Putnam | Missouri | 29171 | 598 | 9 |
1759714 | 1759714 | 2021-09-27 | Putnam | Missouri | 29171 | 595 | 9 |
1756466 | 1756466 | 2021-09-26 | Putnam | Missouri | 29171 | 595 | 9 |
1753218 | 1753218 | 2021-09-25 | Putnam | Missouri | 29171 | 595 | 9 |
1749970 | 1749970 | 2021-09-24 | Putnam | Missouri | 29171 | 592 | 7 |
1746720 | 1746720 | 2021-09-23 | Putnam | Missouri | 29171 | 592 | 7 |
1743471 | 1743471 | 2021-09-22 | Putnam | Missouri | 29171 | 590 | 7 |
1740222 | 1740222 | 2021-09-21 | Putnam | Missouri | 29171 | 589 | 7 |
1736973 | 1736973 | 2021-09-20 | Putnam | Missouri | 29171 | 587 | 7 |
1733723 | 1733723 | 2021-09-19 | Putnam | Missouri | 29171 | 587 | 7 |
1730473 | 1730473 | 2021-09-18 | Putnam | Missouri | 29171 | 587 | 7 |
1727223 | 1727223 | 2021-09-17 | Putnam | Missouri | 29171 | 585 | 7 |
1723974 | 1723974 | 2021-09-16 | Putnam | Missouri | 29171 | 584 | 7 |
1720725 | 1720725 | 2021-09-15 | Putnam | Missouri | 29171 | 579 | 7 |
1717477 | 1717477 | 2021-09-14 | Putnam | Missouri | 29171 | 571 | 7 |
1714229 | 1714229 | 2021-09-13 | Putnam | Missouri | 29171 | 568 | 7 |
1710983 | 1710983 | 2021-09-12 | Putnam | Missouri | 29171 | 567 | 7 |
1707736 | 1707736 | 2021-09-11 | Putnam | Missouri | 29171 | 566 | 7 |
1704489 | 1704489 | 2021-09-10 | Putnam | Missouri | 29171 | 563 | 7 |
1701239 | 1701239 | 2021-09-09 | Putnam | Missouri | 29171 | 558 | 7 |
1697990 | 1697990 | 2021-09-08 | Putnam | Missouri | 29171 | 557 | 7 |
1694742 | 1694742 | 2021-09-07 | Putnam | Missouri | 29171 | 555 | 6 |
1691493 | 1691493 | 2021-09-06 | Putnam | Missouri | 29171 | 551 | 6 |
1688243 | 1688243 | 2021-09-05 | Putnam | Missouri | 29171 | 550 | 6 |
1684993 | 1684993 | 2021-09-04 | Putnam | Missouri | 29171 | 550 | 6 |
1681742 | 1681742 | 2021-09-03 | Putnam | Missouri | 29171 | 550 | 6 |
1678494 | 1678494 | 2021-09-02 | Putnam | Missouri | 29171 | 547 | 6 |
1675246 | 1675246 | 2021-09-01 | Putnam | Missouri | 29171 | 545 | 6 |
1671998 | 1671998 | 2021-08-31 | Putnam | Missouri | 29171 | 545 | 6 |
1668751 | 1668751 | 2021-08-30 | Putnam | Missouri | 29171 | 545 | 5 |
1665504 | 1665504 | 2021-08-29 | Putnam | Missouri | 29171 | 545 | 5 |
1662256 | 1662256 | 2021-08-28 | Putnam | Missouri | 29171 | 545 | 5 |
1659008 | 1659008 | 2021-08-27 | Putnam | Missouri | 29171 | 545 | 5 |
1655759 | 1655759 | 2021-08-26 | Putnam | Missouri | 29171 | 545 | 5 |
1652512 | 1652512 | 2021-08-25 | Putnam | Missouri | 29171 | 543 | 5 |
1649264 | 1649264 | 2021-08-24 | Putnam | Missouri | 29171 | 540 | 5 |
1646015 | 1646015 | 2021-08-23 | Putnam | Missouri | 29171 | 540 | 5 |
1642766 | 1642766 | 2021-08-22 | Putnam | Missouri | 29171 | 540 | 5 |
1639516 | 1639516 | 2021-08-21 | Putnam | Missouri | 29171 | 539 | 5 |
1636266 | 1636266 | 2021-08-20 | Putnam | Missouri | 29171 | 539 | 5 |
1633016 | 1633016 | 2021-08-19 | Putnam | Missouri | 29171 | 538 | 5 |
1629769 | 1629769 | 2021-08-18 | Putnam | Missouri | 29171 | 537 | 5 |
1626522 | 1626522 | 2021-08-17 | Putnam | Missouri | 29171 | 535 | 5 |
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);