ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
713 rows where fips = 29067 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175726 | 2175726 | 2022-02-02 | Douglas | Missouri | 29067 | 2404 | 69 |
2172473 | 2172473 | 2022-02-01 | Douglas | Missouri | 29067 | 2376 | 69 |
2169220 | 2169220 | 2022-01-31 | Douglas | Missouri | 29067 | 2373 | 68 |
2165965 | 2165965 | 2022-01-30 | Douglas | Missouri | 29067 | 2372 | 68 |
2162710 | 2162710 | 2022-01-29 | Douglas | Missouri | 29067 | 2366 | 68 |
2159455 | 2159455 | 2022-01-28 | Douglas | Missouri | 29067 | 2337 | 68 |
2156201 | 2156201 | 2022-01-27 | Douglas | Missouri | 29067 | 2296 | 68 |
2152948 | 2152948 | 2022-01-26 | Douglas | Missouri | 29067 | 2264 | 68 |
2149696 | 2149696 | 2022-01-25 | Douglas | Missouri | 29067 | 2233 | 68 |
2146444 | 2146444 | 2022-01-24 | Douglas | Missouri | 29067 | 2217 | 68 |
2143189 | 2143189 | 2022-01-23 | Douglas | Missouri | 29067 | 2204 | 68 |
2139934 | 2139934 | 2022-01-22 | Douglas | Missouri | 29067 | 2192 | 68 |
2136678 | 2136678 | 2022-01-21 | Douglas | Missouri | 29067 | 2172 | 68 |
2133426 | 2133426 | 2022-01-20 | Douglas | Missouri | 29067 | 2158 | 68 |
2130173 | 2130173 | 2022-01-19 | Douglas | Missouri | 29067 | 2134 | 68 |
2126919 | 2126919 | 2022-01-18 | Douglas | Missouri | 29067 | 2114 | 68 |
2123667 | 2123667 | 2022-01-17 | Douglas | Missouri | 29067 | 2085 | 68 |
2120415 | 2120415 | 2022-01-16 | Douglas | Missouri | 29067 | 2085 | 68 |
2117163 | 2117163 | 2022-01-15 | Douglas | Missouri | 29067 | 2084 | 68 |
2113912 | 2113912 | 2022-01-14 | Douglas | Missouri | 29067 | 2069 | 68 |
2110660 | 2110660 | 2022-01-13 | Douglas | Missouri | 29067 | 2060 | 68 |
2107409 | 2107409 | 2022-01-12 | Douglas | Missouri | 29067 | 2042 | 68 |
2104158 | 2104158 | 2022-01-11 | Douglas | Missouri | 29067 | 2032 | 68 |
2100907 | 2100907 | 2022-01-10 | Douglas | Missouri | 29067 | 2025 | 67 |
2097656 | 2097656 | 2022-01-09 | Douglas | Missouri | 29067 | 2024 | 67 |
2094404 | 2094404 | 2022-01-08 | Douglas | Missouri | 29067 | 2021 | 67 |
2091152 | 2091152 | 2022-01-07 | Douglas | Missouri | 29067 | 2008 | 67 |
2087901 | 2087901 | 2022-01-06 | Douglas | Missouri | 29067 | 2004 | 67 |
2084649 | 2084649 | 2022-01-05 | Douglas | Missouri | 29067 | 1997 | 67 |
2081397 | 2081397 | 2022-01-04 | Douglas | Missouri | 29067 | 1986 | 67 |
2078145 | 2078145 | 2022-01-03 | Douglas | Missouri | 29067 | 1972 | 66 |
2074894 | 2074894 | 2022-01-02 | Douglas | Missouri | 29067 | 1952 | 66 |
2071643 | 2071643 | 2022-01-01 | Douglas | Missouri | 29067 | 1952 | 66 |
2068392 | 2068392 | 2021-12-31 | Douglas | Missouri | 29067 | 1952 | 66 |
2065141 | 2065141 | 2021-12-30 | Douglas | Missouri | 29067 | 1952 | 66 |
2061891 | 2061891 | 2021-12-29 | Douglas | Missouri | 29067 | 1943 | 66 |
2058642 | 2058642 | 2021-12-28 | Douglas | Missouri | 29067 | 1930 | 66 |
2055393 | 2055393 | 2021-12-27 | Douglas | Missouri | 29067 | 1930 | 65 |
2052143 | 2052143 | 2021-12-26 | Douglas | Missouri | 29067 | 1923 | 65 |
2048893 | 2048893 | 2021-12-25 | Douglas | Missouri | 29067 | 1923 | 65 |
2045643 | 2045643 | 2021-12-24 | Douglas | Missouri | 29067 | 1923 | 65 |
2042393 | 2042393 | 2021-12-23 | Douglas | Missouri | 29067 | 1923 | 65 |
2039144 | 2039144 | 2021-12-22 | Douglas | Missouri | 29067 | 1907 | 65 |
2035894 | 2035894 | 2021-12-21 | Douglas | Missouri | 29067 | 1900 | 65 |
2032644 | 2032644 | 2021-12-20 | Douglas | Missouri | 29067 | 1896 | 63 |
2029393 | 2029393 | 2021-12-19 | Douglas | Missouri | 29067 | 1895 | 63 |
2026142 | 2026142 | 2021-12-18 | Douglas | Missouri | 29067 | 1893 | 63 |
2022891 | 2022891 | 2021-12-17 | Douglas | Missouri | 29067 | 1873 | 63 |
2019640 | 2019640 | 2021-12-16 | Douglas | Missouri | 29067 | 1862 | 63 |
2016390 | 2016390 | 2021-12-15 | Douglas | Missouri | 29067 | 1846 | 63 |
2013139 | 2013139 | 2021-12-14 | Douglas | Missouri | 29067 | 1835 | 63 |
2009888 | 2009888 | 2021-12-13 | Douglas | Missouri | 29067 | 1825 | 63 |
2006637 | 2006637 | 2021-12-12 | Douglas | Missouri | 29067 | 1820 | 63 |
2003386 | 2003386 | 2021-12-11 | Douglas | Missouri | 29067 | 1817 | 63 |
2000136 | 2000136 | 2021-12-10 | Douglas | Missouri | 29067 | 1813 | 63 |
1996885 | 1996885 | 2021-12-09 | Douglas | Missouri | 29067 | 1808 | 63 |
1993634 | 1993634 | 2021-12-08 | Douglas | Missouri | 29067 | 1802 | 63 |
1990383 | 1990383 | 2021-12-07 | Douglas | Missouri | 29067 | 1794 | 63 |
1987133 | 1987133 | 2021-12-06 | Douglas | Missouri | 29067 | 1792 | 63 |
1983883 | 1983883 | 2021-12-05 | Douglas | Missouri | 29067 | 1789 | 63 |
1980633 | 1980633 | 2021-12-04 | Douglas | Missouri | 29067 | 1789 | 63 |
1977383 | 1977383 | 2021-12-03 | Douglas | Missouri | 29067 | 1784 | 63 |
1974133 | 1974133 | 2021-12-02 | Douglas | Missouri | 29067 | 1784 | 63 |
1970884 | 1970884 | 2021-12-01 | Douglas | Missouri | 29067 | 1778 | 63 |
1967634 | 1967634 | 2021-11-30 | Douglas | Missouri | 29067 | 1772 | 63 |
1964382 | 1964382 | 2021-11-29 | Douglas | Missouri | 29067 | 1772 | 61 |
1961131 | 1961131 | 2021-11-28 | Douglas | Missouri | 29067 | 1758 | 61 |
1957880 | 1957880 | 2021-11-27 | Douglas | Missouri | 29067 | 1758 | 61 |
1954629 | 1954629 | 2021-11-26 | Douglas | Missouri | 29067 | 1758 | 61 |
1951378 | 1951378 | 2021-11-25 | Douglas | Missouri | 29067 | 1758 | 61 |
1948127 | 1948127 | 2021-11-24 | Douglas | Missouri | 29067 | 1758 | 61 |
1944876 | 1944876 | 2021-11-23 | Douglas | Missouri | 29067 | 1752 | 61 |
1941625 | 1941625 | 2021-11-22 | Douglas | Missouri | 29067 | 1751 | 61 |
1938375 | 1938375 | 2021-11-21 | Douglas | Missouri | 29067 | 1750 | 61 |
1935125 | 1935125 | 2021-11-20 | Douglas | Missouri | 29067 | 1750 | 61 |
1931875 | 1931875 | 2021-11-19 | Douglas | Missouri | 29067 | 1746 | 61 |
1928624 | 1928624 | 2021-11-18 | Douglas | Missouri | 29067 | 1742 | 61 |
1925374 | 1925374 | 2021-11-17 | Douglas | Missouri | 29067 | 1681 | 47 |
1922125 | 1922125 | 2021-11-16 | Douglas | Missouri | 29067 | 1673 | 47 |
1918875 | 1918875 | 2021-11-15 | Douglas | Missouri | 29067 | 1671 | 47 |
1915625 | 1915625 | 2021-11-14 | Douglas | Missouri | 29067 | 1671 | 47 |
1912375 | 1912375 | 2021-11-13 | Douglas | Missouri | 29067 | 1669 | 47 |
1909125 | 1909125 | 2021-11-12 | Douglas | Missouri | 29067 | 1667 | 47 |
1905876 | 1905876 | 2021-11-11 | Douglas | Missouri | 29067 | 1665 | 47 |
1902627 | 1902627 | 2021-11-10 | Douglas | Missouri | 29067 | 1665 | 47 |
1899377 | 1899377 | 2021-11-09 | Douglas | Missouri | 29067 | 1663 | 47 |
1896127 | 1896127 | 2021-11-08 | Douglas | Missouri | 29067 | 1661 | 47 |
1892877 | 1892877 | 2021-11-07 | Douglas | Missouri | 29067 | 1660 | 47 |
1889627 | 1889627 | 2021-11-06 | Douglas | Missouri | 29067 | 1660 | 47 |
1886377 | 1886377 | 2021-11-05 | Douglas | Missouri | 29067 | 1656 | 47 |
1883128 | 1883128 | 2021-11-04 | Douglas | Missouri | 29067 | 1656 | 47 |
1879879 | 1879879 | 2021-11-03 | Douglas | Missouri | 29067 | 1654 | 47 |
1876630 | 1876630 | 2021-11-02 | Douglas | Missouri | 29067 | 1648 | 47 |
1873381 | 1873381 | 2021-11-01 | Douglas | Missouri | 29067 | 1646 | 46 |
1870132 | 1870132 | 2021-10-31 | Douglas | Missouri | 29067 | 1645 | 46 |
1866883 | 1866883 | 2021-10-30 | Douglas | Missouri | 29067 | 1645 | 46 |
1863634 | 1863634 | 2021-10-29 | Douglas | Missouri | 29067 | 1641 | 46 |
1860385 | 1860385 | 2021-10-28 | Douglas | Missouri | 29067 | 1636 | 46 |
1857136 | 1857136 | 2021-10-27 | Douglas | Missouri | 29067 | 1632 | 46 |
1853887 | 1853887 | 2021-10-26 | Douglas | Missouri | 29067 | 1629 | 46 |
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);