ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 29083 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1840896 | 1840896 | 2021-10-22 | Henry | Missouri | 29083 | 3271 | 49 |
1837647 | 1837647 | 2021-10-21 | Henry | Missouri | 29083 | 3256 | 49 |
1834398 | 1834398 | 2021-10-20 | Henry | Missouri | 29083 | 3252 | 49 |
1831149 | 1831149 | 2021-10-19 | Henry | Missouri | 29083 | 3242 | 49 |
1827900 | 1827900 | 2021-10-18 | Henry | Missouri | 29083 | 3231 | 49 |
1824651 | 1824651 | 2021-10-17 | Henry | Missouri | 29083 | 3226 | 49 |
1821402 | 1821402 | 2021-10-16 | Henry | Missouri | 29083 | 3219 | 49 |
1818153 | 1818153 | 2021-10-15 | Henry | Missouri | 29083 | 3206 | 49 |
1814904 | 1814904 | 2021-10-14 | Henry | Missouri | 29083 | 3197 | 49 |
1811656 | 1811656 | 2021-10-13 | Henry | Missouri | 29083 | 3185 | 49 |
1808407 | 1808407 | 2021-10-12 | Henry | Missouri | 29083 | 3182 | 49 |
1805156 | 1805156 | 2021-10-11 | Henry | Missouri | 29083 | 3173 | 49 |
1801907 | 1801907 | 2021-10-10 | Henry | Missouri | 29083 | 3169 | 49 |
1798658 | 1798658 | 2021-10-09 | Henry | Missouri | 29083 | 3169 | 49 |
1795409 | 1795409 | 2021-10-08 | Henry | Missouri | 29083 | 3170 | 49 |
1792160 | 1792160 | 2021-10-07 | Henry | Missouri | 29083 | 3162 | 49 |
1788911 | 1788911 | 2021-10-06 | Henry | Missouri | 29083 | 3155 | 49 |
1785663 | 1785663 | 2021-10-05 | Henry | Missouri | 29083 | 3141 | 49 |
1782414 | 1782414 | 2021-10-04 | Henry | Missouri | 29083 | 3137 | 49 |
1779164 | 1779164 | 2021-10-03 | Henry | Missouri | 29083 | 3136 | 49 |
1775914 | 1775914 | 2021-10-02 | Henry | Missouri | 29083 | 3129 | 49 |
1772664 | 1772664 | 2021-10-01 | Henry | Missouri | 29083 | 3126 | 49 |
1769415 | 1769415 | 2021-09-30 | Henry | Missouri | 29083 | 3113 | 49 |
1766166 | 1766166 | 2021-09-29 | Henry | Missouri | 29083 | 3104 | 49 |
1762917 | 1762917 | 2021-09-28 | Henry | Missouri | 29083 | 3099 | 49 |
1759668 | 1759668 | 2021-09-27 | Henry | Missouri | 29083 | 3084 | 48 |
1756420 | 1756420 | 2021-09-26 | Henry | Missouri | 29083 | 3076 | 48 |
1753172 | 1753172 | 2021-09-25 | Henry | Missouri | 29083 | 3075 | 48 |
1749924 | 1749924 | 2021-09-24 | Henry | Missouri | 29083 | 3062 | 48 |
1746674 | 1746674 | 2021-09-23 | Henry | Missouri | 29083 | 3044 | 48 |
1743425 | 1743425 | 2021-09-22 | Henry | Missouri | 29083 | 3034 | 48 |
1740176 | 1740176 | 2021-09-21 | Henry | Missouri | 29083 | 3021 | 48 |
1736927 | 1736927 | 2021-09-20 | Henry | Missouri | 29083 | 3011 | 46 |
1733677 | 1733677 | 2021-09-19 | Henry | Missouri | 29083 | 3003 | 46 |
1730427 | 1730427 | 2021-09-18 | Henry | Missouri | 29083 | 3001 | 46 |
1727177 | 1727177 | 2021-09-17 | Henry | Missouri | 29083 | 2978 | 46 |
1723928 | 1723928 | 2021-09-16 | Henry | Missouri | 29083 | 2967 | 46 |
1720679 | 1720679 | 2021-09-15 | Henry | Missouri | 29083 | 2962 | 46 |
1717431 | 1717431 | 2021-09-14 | Henry | Missouri | 29083 | 2946 | 46 |
1714183 | 1714183 | 2021-09-13 | Henry | Missouri | 29083 | 2931 | 44 |
1710937 | 1710937 | 2021-09-12 | Henry | Missouri | 29083 | 2923 | 44 |
1707690 | 1707690 | 2021-09-11 | Henry | Missouri | 29083 | 2916 | 44 |
1704443 | 1704443 | 2021-09-10 | Henry | Missouri | 29083 | 2913 | 44 |
1701193 | 1701193 | 2021-09-09 | Henry | Missouri | 29083 | 2899 | 44 |
1697944 | 1697944 | 2021-09-08 | Henry | Missouri | 29083 | 2883 | 44 |
1694696 | 1694696 | 2021-09-07 | Henry | Missouri | 29083 | 2876 | 43 |
1691447 | 1691447 | 2021-09-06 | Henry | Missouri | 29083 | 2873 | 43 |
1688197 | 1688197 | 2021-09-05 | Henry | Missouri | 29083 | 2864 | 43 |
1684947 | 1684947 | 2021-09-04 | Henry | Missouri | 29083 | 2855 | 43 |
1681696 | 1681696 | 2021-09-03 | Henry | Missouri | 29083 | 2847 | 43 |
1678448 | 1678448 | 2021-09-02 | Henry | Missouri | 29083 | 2824 | 43 |
1675200 | 1675200 | 2021-09-01 | Henry | Missouri | 29083 | 2804 | 42 |
1671952 | 1671952 | 2021-08-31 | Henry | Missouri | 29083 | 2783 | 42 |
1668705 | 1668705 | 2021-08-30 | Henry | Missouri | 29083 | 2774 | 42 |
1665458 | 1665458 | 2021-08-29 | Henry | Missouri | 29083 | 2765 | 42 |
1662210 | 1662210 | 2021-08-28 | Henry | Missouri | 29083 | 2760 | 42 |
1658962 | 1658962 | 2021-08-27 | Henry | Missouri | 29083 | 2749 | 42 |
1655713 | 1655713 | 2021-08-26 | Henry | Missouri | 29083 | 2725 | 41 |
1652466 | 1652466 | 2021-08-25 | Henry | Missouri | 29083 | 2717 | 41 |
1649218 | 1649218 | 2021-08-24 | Henry | Missouri | 29083 | 2702 | 41 |
1645969 | 1645969 | 2021-08-23 | Henry | Missouri | 29083 | 2693 | 41 |
1642720 | 1642720 | 2021-08-22 | Henry | Missouri | 29083 | 2683 | 41 |
1639470 | 1639470 | 2021-08-21 | Henry | Missouri | 29083 | 2675 | 41 |
1636220 | 1636220 | 2021-08-20 | Henry | Missouri | 29083 | 2649 | 41 |
1632970 | 1632970 | 2021-08-19 | Henry | Missouri | 29083 | 2628 | 41 |
1629723 | 1629723 | 2021-08-18 | Henry | Missouri | 29083 | 2615 | 41 |
1626476 | 1626476 | 2021-08-17 | Henry | Missouri | 29083 | 2588 | 41 |
1623229 | 1623229 | 2021-08-16 | Henry | Missouri | 29083 | 2576 | 41 |
1619982 | 1619982 | 2021-08-15 | Henry | Missouri | 29083 | 2566 | 41 |
1616734 | 1616734 | 2021-08-14 | Henry | Missouri | 29083 | 2563 | 41 |
1613486 | 1613486 | 2021-08-13 | Henry | Missouri | 29083 | 2552 | 41 |
1610237 | 1610237 | 2021-08-12 | Henry | Missouri | 29083 | 2523 | 41 |
1606989 | 1606989 | 2021-08-11 | Henry | Missouri | 29083 | 2506 | 41 |
1603740 | 1603740 | 2021-08-10 | Henry | Missouri | 29083 | 2474 | 41 |
1600491 | 1600491 | 2021-08-09 | Henry | Missouri | 29083 | 2457 | 41 |
1597243 | 1597243 | 2021-08-08 | Henry | Missouri | 29083 | 2451 | 41 |
1593994 | 1593994 | 2021-08-07 | Henry | Missouri | 29083 | 2442 | 41 |
1590745 | 1590745 | 2021-08-06 | Henry | Missouri | 29083 | 2424 | 41 |
1587496 | 1587496 | 2021-08-05 | Henry | Missouri | 29083 | 2412 | 41 |
1584245 | 1584245 | 2021-08-04 | Henry | Missouri | 29083 | 2395 | 41 |
1580996 | 1580996 | 2021-08-03 | Henry | Missouri | 29083 | 2368 | 41 |
1577747 | 1577747 | 2021-08-02 | Henry | Missouri | 29083 | 2349 | 40 |
1574499 | 1574499 | 2021-08-01 | Henry | Missouri | 29083 | 2341 | 40 |
1571251 | 1571251 | 2021-07-31 | Henry | Missouri | 29083 | 2337 | 40 |
1568003 | 1568003 | 2021-07-30 | Henry | Missouri | 29083 | 2319 | 40 |
1564755 | 1564755 | 2021-07-29 | Henry | Missouri | 29083 | 2303 | 40 |
1561507 | 1561507 | 2021-07-28 | Henry | Missouri | 29083 | 2274 | 40 |
1558259 | 1558259 | 2021-07-27 | Henry | Missouri | 29083 | 2258 | 40 |
1555012 | 1555012 | 2021-07-26 | Henry | Missouri | 29083 | 2246 | 40 |
1551765 | 1551765 | 2021-07-25 | Henry | Missouri | 29083 | 2237 | 40 |
1548518 | 1548518 | 2021-07-24 | Henry | Missouri | 29083 | 2227 | 40 |
1545271 | 1545271 | 2021-07-23 | Henry | Missouri | 29083 | 2202 | 40 |
1542023 | 1542023 | 2021-07-22 | Henry | Missouri | 29083 | 2195 | 40 |
1538776 | 1538776 | 2021-07-21 | Henry | Missouri | 29083 | 2181 | 40 |
1535529 | 1535529 | 2021-07-20 | Henry | Missouri | 29083 | 2174 | 40 |
1532281 | 1532281 | 2021-07-19 | Henry | Missouri | 29083 | 2165 | 40 |
1529034 | 1529034 | 2021-07-18 | Henry | Missouri | 29083 | 2160 | 40 |
1525787 | 1525787 | 2021-07-17 | Henry | Missouri | 29083 | 2157 | 40 |
1522540 | 1522540 | 2021-07-16 | Henry | Missouri | 29083 | 2144 | 40 |
1519291 | 1519291 | 2021-07-15 | Henry | Missouri | 29083 | 2141 | 40 |
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);