ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 29027 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1840868 | 1840868 | 2021-10-22 | Callaway | Missouri | 29027 | 7403 | 69 |
1837619 | 1837619 | 2021-10-21 | Callaway | Missouri | 29027 | 7397 | 69 |
1834370 | 1834370 | 2021-10-20 | Callaway | Missouri | 29027 | 7391 | 69 |
1831121 | 1831121 | 2021-10-19 | Callaway | Missouri | 29027 | 7384 | 69 |
1827872 | 1827872 | 2021-10-18 | Callaway | Missouri | 29027 | 7376 | 67 |
1824623 | 1824623 | 2021-10-17 | Callaway | Missouri | 29027 | 7372 | 67 |
1821374 | 1821374 | 2021-10-16 | Callaway | Missouri | 29027 | 7366 | 67 |
1818125 | 1818125 | 2021-10-15 | Callaway | Missouri | 29027 | 7355 | 67 |
1814876 | 1814876 | 2021-10-14 | Callaway | Missouri | 29027 | 7340 | 67 |
1811628 | 1811628 | 2021-10-13 | Callaway | Missouri | 29027 | 7323 | 67 |
1808379 | 1808379 | 2021-10-12 | Callaway | Missouri | 29027 | 7314 | 67 |
1805128 | 1805128 | 2021-10-11 | Callaway | Missouri | 29027 | 7299 | 67 |
1801879 | 1801879 | 2021-10-10 | Callaway | Missouri | 29027 | 7294 | 67 |
1798630 | 1798630 | 2021-10-09 | Callaway | Missouri | 29027 | 7287 | 67 |
1795381 | 1795381 | 2021-10-08 | Callaway | Missouri | 29027 | 7273 | 67 |
1792132 | 1792132 | 2021-10-07 | Callaway | Missouri | 29027 | 7254 | 67 |
1788883 | 1788883 | 2021-10-06 | Callaway | Missouri | 29027 | 7240 | 67 |
1785635 | 1785635 | 2021-10-05 | Callaway | Missouri | 29027 | 7230 | 67 |
1782386 | 1782386 | 2021-10-04 | Callaway | Missouri | 29027 | 7216 | 67 |
1779136 | 1779136 | 2021-10-03 | Callaway | Missouri | 29027 | 7209 | 67 |
1775886 | 1775886 | 2021-10-02 | Callaway | Missouri | 29027 | 7201 | 67 |
1772636 | 1772636 | 2021-10-01 | Callaway | Missouri | 29027 | 7163 | 65 |
1769387 | 1769387 | 2021-09-30 | Callaway | Missouri | 29027 | 7148 | 65 |
1766138 | 1766138 | 2021-09-29 | Callaway | Missouri | 29027 | 7137 | 65 |
1762889 | 1762889 | 2021-09-28 | Callaway | Missouri | 29027 | 7124 | 65 |
1759640 | 1759640 | 2021-09-27 | Callaway | Missouri | 29027 | 7091 | 64 |
1756392 | 1756392 | 2021-09-26 | Callaway | Missouri | 29027 | 7086 | 64 |
1753144 | 1753144 | 2021-09-25 | Callaway | Missouri | 29027 | 7079 | 64 |
1749896 | 1749896 | 2021-09-24 | Callaway | Missouri | 29027 | 7051 | 64 |
1746646 | 1746646 | 2021-09-23 | Callaway | Missouri | 29027 | 7039 | 64 |
1743397 | 1743397 | 2021-09-22 | Callaway | Missouri | 29027 | 7026 | 64 |
1740148 | 1740148 | 2021-09-21 | Callaway | Missouri | 29027 | 7014 | 64 |
1736899 | 1736899 | 2021-09-20 | Callaway | Missouri | 29027 | 6995 | 61 |
1733649 | 1733649 | 2021-09-19 | Callaway | Missouri | 29027 | 6991 | 61 |
1730399 | 1730399 | 2021-09-18 | Callaway | Missouri | 29027 | 6972 | 61 |
1727149 | 1727149 | 2021-09-17 | Callaway | Missouri | 29027 | 6957 | 61 |
1723900 | 1723900 | 2021-09-16 | Callaway | Missouri | 29027 | 6941 | 61 |
1720651 | 1720651 | 2021-09-15 | Callaway | Missouri | 29027 | 6917 | 61 |
1717403 | 1717403 | 2021-09-14 | Callaway | Missouri | 29027 | 6905 | 61 |
1714155 | 1714155 | 2021-09-13 | Callaway | Missouri | 29027 | 6885 | 60 |
1710909 | 1710909 | 2021-09-12 | Callaway | Missouri | 29027 | 6877 | 60 |
1707662 | 1707662 | 2021-09-11 | Callaway | Missouri | 29027 | 6863 | 60 |
1704415 | 1704415 | 2021-09-10 | Callaway | Missouri | 29027 | 6852 | 60 |
1701165 | 1701165 | 2021-09-09 | Callaway | Missouri | 29027 | 6836 | 60 |
1697916 | 1697916 | 2021-09-08 | Callaway | Missouri | 29027 | 6801 | 60 |
1694668 | 1694668 | 2021-09-07 | Callaway | Missouri | 29027 | 6792 | 60 |
1691419 | 1691419 | 2021-09-06 | Callaway | Missouri | 29027 | 6785 | 60 |
1688169 | 1688169 | 2021-09-05 | Callaway | Missouri | 29027 | 6778 | 60 |
1684919 | 1684919 | 2021-09-04 | Callaway | Missouri | 29027 | 6761 | 60 |
1681668 | 1681668 | 2021-09-03 | Callaway | Missouri | 29027 | 6746 | 60 |
1678420 | 1678420 | 2021-09-02 | Callaway | Missouri | 29027 | 6722 | 60 |
1675172 | 1675172 | 2021-09-01 | Callaway | Missouri | 29027 | 6680 | 60 |
1671924 | 1671924 | 2021-08-31 | Callaway | Missouri | 29027 | 6661 | 59 |
1668677 | 1668677 | 2021-08-30 | Callaway | Missouri | 29027 | 6646 | 57 |
1665430 | 1665430 | 2021-08-29 | Callaway | Missouri | 29027 | 6615 | 57 |
1662182 | 1662182 | 2021-08-28 | Callaway | Missouri | 29027 | 6577 | 57 |
1658934 | 1658934 | 2021-08-27 | Callaway | Missouri | 29027 | 6542 | 57 |
1655685 | 1655685 | 2021-08-26 | Callaway | Missouri | 29027 | 6508 | 57 |
1652438 | 1652438 | 2021-08-25 | Callaway | Missouri | 29027 | 6468 | 57 |
1649190 | 1649190 | 2021-08-24 | Callaway | Missouri | 29027 | 6450 | 57 |
1645941 | 1645941 | 2021-08-23 | Callaway | Missouri | 29027 | 6427 | 57 |
1642692 | 1642692 | 2021-08-22 | Callaway | Missouri | 29027 | 6413 | 57 |
1639442 | 1639442 | 2021-08-21 | Callaway | Missouri | 29027 | 6395 | 57 |
1636192 | 1636192 | 2021-08-20 | Callaway | Missouri | 29027 | 6366 | 57 |
1632942 | 1632942 | 2021-08-19 | Callaway | Missouri | 29027 | 6342 | 57 |
1629695 | 1629695 | 2021-08-18 | Callaway | Missouri | 29027 | 6308 | 57 |
1626448 | 1626448 | 2021-08-17 | Callaway | Missouri | 29027 | 6278 | 57 |
1623201 | 1623201 | 2021-08-16 | Callaway | Missouri | 29027 | 6255 | 55 |
1619954 | 1619954 | 2021-08-15 | Callaway | Missouri | 29027 | 6237 | 55 |
1616706 | 1616706 | 2021-08-14 | Callaway | Missouri | 29027 | 6217 | 55 |
1613458 | 1613458 | 2021-08-13 | Callaway | Missouri | 29027 | 6189 | 55 |
1610209 | 1610209 | 2021-08-12 | Callaway | Missouri | 29027 | 6153 | 55 |
1606961 | 1606961 | 2021-08-11 | Callaway | Missouri | 29027 | 6123 | 55 |
1603712 | 1603712 | 2021-08-10 | Callaway | Missouri | 29027 | 6074 | 55 |
1600463 | 1600463 | 2021-08-09 | Callaway | Missouri | 29027 | 6039 | 52 |
1597215 | 1597215 | 2021-08-08 | Callaway | Missouri | 29027 | 6029 | 52 |
1593966 | 1593966 | 2021-08-07 | Callaway | Missouri | 29027 | 6014 | 52 |
1590717 | 1590717 | 2021-08-06 | Callaway | Missouri | 29027 | 5974 | 52 |
1587468 | 1587468 | 2021-08-05 | Callaway | Missouri | 29027 | 5929 | 52 |
1584217 | 1584217 | 2021-08-04 | Callaway | Missouri | 29027 | 5884 | 52 |
1580968 | 1580968 | 2021-08-03 | Callaway | Missouri | 29027 | 5827 | 52 |
1577719 | 1577719 | 2021-08-02 | Callaway | Missouri | 29027 | 5805 | 51 |
1574471 | 1574471 | 2021-08-01 | Callaway | Missouri | 29027 | 5788 | 51 |
1571223 | 1571223 | 2021-07-31 | Callaway | Missouri | 29027 | 5773 | 51 |
1567975 | 1567975 | 2021-07-30 | Callaway | Missouri | 29027 | 5743 | 51 |
1564727 | 1564727 | 2021-07-29 | Callaway | Missouri | 29027 | 5682 | 51 |
1561479 | 1561479 | 2021-07-28 | Callaway | Missouri | 29027 | 5660 | 51 |
1558231 | 1558231 | 2021-07-27 | Callaway | Missouri | 29027 | 5607 | 51 |
1554984 | 1554984 | 2021-07-26 | Callaway | Missouri | 29027 | 5568 | 51 |
1551737 | 1551737 | 2021-07-25 | Callaway | Missouri | 29027 | 5563 | 51 |
1548490 | 1548490 | 2021-07-24 | Callaway | Missouri | 29027 | 5536 | 51 |
1545243 | 1545243 | 2021-07-23 | Callaway | Missouri | 29027 | 5502 | 51 |
1541995 | 1541995 | 2021-07-22 | Callaway | Missouri | 29027 | 5482 | 51 |
1538748 | 1538748 | 2021-07-21 | Callaway | Missouri | 29027 | 5456 | 51 |
1535501 | 1535501 | 2021-07-20 | Callaway | Missouri | 29027 | 5423 | 51 |
1532253 | 1532253 | 2021-07-19 | Callaway | Missouri | 29027 | 5406 | 51 |
1529006 | 1529006 | 2021-07-18 | Callaway | Missouri | 29027 | 5402 | 51 |
1525759 | 1525759 | 2021-07-17 | Callaway | Missouri | 29027 | 5395 | 51 |
1522512 | 1522512 | 2021-07-16 | Callaway | Missouri | 29027 | 5330 | 51 |
1519263 | 1519263 | 2021-07-15 | Callaway | Missouri | 29027 | 5317 | 51 |
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);