ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Henry" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1948135 | 1948135 | 2021-11-24 | Henry | Missouri | 29083 | 3541 | 62 |
1944884 | 1944884 | 2021-11-23 | Henry | Missouri | 29083 | 3537 | 62 |
1941633 | 1941633 | 2021-11-22 | Henry | Missouri | 29083 | 3515 | 62 |
1938383 | 1938383 | 2021-11-21 | Henry | Missouri | 29083 | 3515 | 62 |
1935133 | 1935133 | 2021-11-20 | Henry | Missouri | 29083 | 3511 | 62 |
1931883 | 1931883 | 2021-11-19 | Henry | Missouri | 29083 | 3507 | 62 |
1928632 | 1928632 | 2021-11-18 | Henry | Missouri | 29083 | 3501 | 62 |
1925382 | 1925382 | 2021-11-17 | Henry | Missouri | 29083 | 3457 | 51 |
1922133 | 1922133 | 2021-11-16 | Henry | Missouri | 29083 | 3441 | 51 |
1918883 | 1918883 | 2021-11-15 | Henry | Missouri | 29083 | 3433 | 51 |
1915633 | 1915633 | 2021-11-14 | Henry | Missouri | 29083 | 3429 | 51 |
1912383 | 1912383 | 2021-11-13 | Henry | Missouri | 29083 | 3413 | 51 |
1909133 | 1909133 | 2021-11-12 | Henry | Missouri | 29083 | 3395 | 51 |
1905884 | 1905884 | 2021-11-11 | Henry | Missouri | 29083 | 3371 | 51 |
1902635 | 1902635 | 2021-11-10 | Henry | Missouri | 29083 | 3371 | 51 |
1899385 | 1899385 | 2021-11-09 | Henry | Missouri | 29083 | 3361 | 51 |
1896135 | 1896135 | 2021-11-08 | Henry | Missouri | 29083 | 3352 | 51 |
1892885 | 1892885 | 2021-11-07 | Henry | Missouri | 29083 | 3346 | 51 |
1889635 | 1889635 | 2021-11-06 | Henry | Missouri | 29083 | 3344 | 51 |
1886385 | 1886385 | 2021-11-05 | Henry | Missouri | 29083 | 3340 | 51 |
1883136 | 1883136 | 2021-11-04 | Henry | Missouri | 29083 | 3336 | 51 |
1879887 | 1879887 | 2021-11-03 | Henry | Missouri | 29083 | 3331 | 51 |
1876638 | 1876638 | 2021-11-02 | Henry | Missouri | 29083 | 3325 | 51 |
1873389 | 1873389 | 2021-11-01 | Henry | Missouri | 29083 | 3321 | 50 |
1870140 | 1870140 | 2021-10-31 | Henry | Missouri | 29083 | 3319 | 50 |
1866891 | 1866891 | 2021-10-30 | Henry | Missouri | 29083 | 3316 | 50 |
1863642 | 1863642 | 2021-10-29 | Henry | Missouri | 29083 | 3312 | 50 |
1860393 | 1860393 | 2021-10-28 | Henry | Missouri | 29083 | 3300 | 50 |
1857144 | 1857144 | 2021-10-27 | Henry | Missouri | 29083 | 3291 | 50 |
1853895 | 1853895 | 2021-10-26 | Henry | Missouri | 29083 | 3288 | 50 |
1850646 | 1850646 | 2021-10-25 | Henry | Missouri | 29083 | 3283 | 49 |
1847396 | 1847396 | 2021-10-24 | Henry | Missouri | 29083 | 3281 | 49 |
1844146 | 1844146 | 2021-10-23 | Henry | Missouri | 29083 | 3280 | 49 |
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 |
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);