ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Clay" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109946 | 2109946 | 2022-01-13 | Clay | Iowa | 19041 | 3379 | 40 |
2106695 | 2106695 | 2022-01-12 | Clay | Iowa | 19041 | 3379 | 40 |
2103444 | 2103444 | 2022-01-11 | Clay | Iowa | 19041 | 3203 | 40 |
2100193 | 2100193 | 2022-01-10 | Clay | Iowa | 19041 | 3203 | 40 |
2096942 | 2096942 | 2022-01-09 | Clay | Iowa | 19041 | 3203 | 40 |
2093690 | 2093690 | 2022-01-08 | Clay | Iowa | 19041 | 3203 | 40 |
2090438 | 2090438 | 2022-01-07 | Clay | Iowa | 19041 | 3203 | 40 |
2087187 | 2087187 | 2022-01-06 | Clay | Iowa | 19041 | 3203 | 40 |
2083935 | 2083935 | 2022-01-05 | Clay | Iowa | 19041 | 3203 | 40 |
2080683 | 2080683 | 2022-01-04 | Clay | Iowa | 19041 | 3124 | 38 |
2077431 | 2077431 | 2022-01-03 | Clay | Iowa | 19041 | 3124 | 38 |
2074180 | 2074180 | 2022-01-02 | Clay | Iowa | 19041 | 3124 | 38 |
2070929 | 2070929 | 2022-01-01 | Clay | Iowa | 19041 | 3124 | 38 |
2067678 | 2067678 | 2021-12-31 | Clay | Iowa | 19041 | 3124 | 38 |
2064427 | 2064427 | 2021-12-30 | Clay | Iowa | 19041 | 3124 | 38 |
2061177 | 2061177 | 2021-12-29 | Clay | Iowa | 19041 | 3124 | 38 |
2057928 | 2057928 | 2021-12-28 | Clay | Iowa | 19041 | 3086 | 38 |
2054679 | 2054679 | 2021-12-27 | Clay | Iowa | 19041 | 3086 | 38 |
2051429 | 2051429 | 2021-12-26 | Clay | Iowa | 19041 | 3086 | 38 |
2048179 | 2048179 | 2021-12-25 | Clay | Iowa | 19041 | 3086 | 38 |
2044929 | 2044929 | 2021-12-24 | Clay | Iowa | 19041 | 3086 | 38 |
2041680 | 2041680 | 2021-12-23 | Clay | Iowa | 19041 | 3086 | 38 |
2038430 | 2038430 | 2021-12-22 | Clay | Iowa | 19041 | 3086 | 38 |
2035180 | 2035180 | 2021-12-21 | Clay | Iowa | 19041 | 3051 | 38 |
2031930 | 2031930 | 2021-12-20 | Clay | Iowa | 19041 | 3051 | 38 |
2028679 | 2028679 | 2021-12-19 | Clay | Iowa | 19041 | 3051 | 38 |
2025428 | 2025428 | 2021-12-18 | Clay | Iowa | 19041 | 3051 | 38 |
2022177 | 2022177 | 2021-12-17 | Clay | Iowa | 19041 | 3051 | 38 |
2018926 | 2018926 | 2021-12-16 | Clay | Iowa | 19041 | 3051 | 38 |
2015676 | 2015676 | 2021-12-15 | Clay | Iowa | 19041 | 3051 | 38 |
2012425 | 2012425 | 2021-12-14 | Clay | Iowa | 19041 | 3012 | 38 |
2009174 | 2009174 | 2021-12-13 | Clay | Iowa | 19041 | 3012 | 38 |
2005923 | 2005923 | 2021-12-12 | Clay | Iowa | 19041 | 3012 | 38 |
2002672 | 2002672 | 2021-12-11 | Clay | Iowa | 19041 | 3012 | 38 |
1999422 | 1999422 | 2021-12-10 | Clay | Iowa | 19041 | 3012 | 38 |
1996171 | 1996171 | 2021-12-09 | Clay | Iowa | 19041 | 3012 | 38 |
1992920 | 1992920 | 2021-12-08 | Clay | Iowa | 19041 | 3012 | 38 |
1989669 | 1989669 | 2021-12-07 | Clay | Iowa | 19041 | 2982 | 36 |
1986419 | 1986419 | 2021-12-06 | Clay | Iowa | 19041 | 2982 | 36 |
1983169 | 1983169 | 2021-12-05 | Clay | Iowa | 19041 | 2982 | 36 |
1979919 | 1979919 | 2021-12-04 | Clay | Iowa | 19041 | 2982 | 36 |
1976669 | 1976669 | 2021-12-03 | Clay | Iowa | 19041 | 2982 | 36 |
1973420 | 1973420 | 2021-12-02 | Clay | Iowa | 19041 | 2982 | 36 |
1970170 | 1970170 | 2021-12-01 | Clay | Iowa | 19041 | 2982 | 36 |
1966920 | 1966920 | 2021-11-30 | Clay | Iowa | 19041 | 2957 | 36 |
1963668 | 1963668 | 2021-11-29 | Clay | Iowa | 19041 | 2957 | 36 |
1960417 | 1960417 | 2021-11-28 | Clay | Iowa | 19041 | 2957 | 36 |
1957166 | 1957166 | 2021-11-27 | Clay | Iowa | 19041 | 2957 | 36 |
1953915 | 1953915 | 2021-11-26 | Clay | Iowa | 19041 | 2957 | 36 |
1950664 | 1950664 | 2021-11-25 | Clay | Iowa | 19041 | 2957 | 36 |
1947413 | 1947413 | 2021-11-24 | Clay | Iowa | 19041 | 2957 | 36 |
1944162 | 1944162 | 2021-11-23 | Clay | Iowa | 19041 | 2933 | 35 |
1940912 | 1940912 | 2021-11-22 | Clay | Iowa | 19041 | 2933 | 35 |
1937662 | 1937662 | 2021-11-21 | Clay | Iowa | 19041 | 2933 | 35 |
1934412 | 1934412 | 2021-11-20 | Clay | Iowa | 19041 | 2933 | 35 |
1931161 | 1931161 | 2021-11-19 | Clay | Iowa | 19041 | 2933 | 35 |
1927910 | 1927910 | 2021-11-18 | Clay | Iowa | 19041 | 2933 | 35 |
1924660 | 1924660 | 2021-11-17 | Clay | Iowa | 19041 | 2933 | 35 |
1921411 | 1921411 | 2021-11-16 | Clay | Iowa | 19041 | 2900 | 35 |
1918161 | 1918161 | 2021-11-15 | Clay | Iowa | 19041 | 2900 | 35 |
1914911 | 1914911 | 2021-11-14 | Clay | Iowa | 19041 | 2900 | 35 |
1911661 | 1911661 | 2021-11-13 | Clay | Iowa | 19041 | 2900 | 35 |
1908412 | 1908412 | 2021-11-12 | Clay | Iowa | 19041 | 2900 | 35 |
1905163 | 1905163 | 2021-11-11 | Clay | Iowa | 19041 | 2900 | 35 |
1901913 | 1901913 | 2021-11-10 | Clay | Iowa | 19041 | 2900 | 35 |
1898663 | 1898663 | 2021-11-09 | Clay | Iowa | 19041 | 2865 | 35 |
1895413 | 1895413 | 2021-11-08 | Clay | Iowa | 19041 | 2865 | 35 |
1892163 | 1892163 | 2021-11-07 | Clay | Iowa | 19041 | 2865 | 35 |
1888913 | 1888913 | 2021-11-06 | Clay | Iowa | 19041 | 2865 | 35 |
1885663 | 1885663 | 2021-11-05 | Clay | Iowa | 19041 | 2865 | 35 |
1882414 | 1882414 | 2021-11-04 | Clay | Iowa | 19041 | 2865 | 35 |
1879165 | 1879165 | 2021-11-03 | Clay | Iowa | 19041 | 2865 | 35 |
1875916 | 1875916 | 2021-11-02 | Clay | Iowa | 19041 | 2836 | 35 |
1872667 | 1872667 | 2021-11-01 | Clay | Iowa | 19041 | 2836 | 35 |
1869418 | 1869418 | 2021-10-31 | Clay | Iowa | 19041 | 2836 | 35 |
1866169 | 1866169 | 2021-10-30 | Clay | Iowa | 19041 | 2836 | 35 |
1862920 | 1862920 | 2021-10-29 | Clay | Iowa | 19041 | 2836 | 35 |
1859671 | 1859671 | 2021-10-28 | Clay | Iowa | 19041 | 2836 | 35 |
1856422 | 1856422 | 2021-10-27 | Clay | Iowa | 19041 | 2836 | 35 |
1853173 | 1853173 | 2021-10-26 | Clay | Iowa | 19041 | 2791 | 33 |
1849924 | 1849924 | 2021-10-25 | Clay | Iowa | 19041 | 2791 | 33 |
1846674 | 1846674 | 2021-10-24 | Clay | Iowa | 19041 | 2791 | 33 |
1843424 | 1843424 | 2021-10-23 | Clay | Iowa | 19041 | 2791 | 33 |
1840174 | 1840174 | 2021-10-22 | Clay | Iowa | 19041 | 2791 | 33 |
1836925 | 1836925 | 2021-10-21 | Clay | Iowa | 19041 | 2791 | 33 |
1833676 | 1833676 | 2021-10-20 | Clay | Iowa | 19041 | 2791 | 33 |
1830427 | 1830427 | 2021-10-19 | Clay | Iowa | 19041 | 2748 | 31 |
1827178 | 1827178 | 2021-10-18 | Clay | Iowa | 19041 | 2748 | 31 |
1823929 | 1823929 | 2021-10-17 | Clay | Iowa | 19041 | 2748 | 31 |
1820680 | 1820680 | 2021-10-16 | Clay | Iowa | 19041 | 2748 | 31 |
1817431 | 1817431 | 2021-10-15 | Clay | Iowa | 19041 | 2748 | 31 |
1814183 | 1814183 | 2021-10-14 | Clay | Iowa | 19041 | 2748 | 31 |
1810934 | 1810934 | 2021-10-13 | Clay | Iowa | 19041 | 2748 | 31 |
1807685 | 1807685 | 2021-10-12 | Clay | Iowa | 19041 | 2711 | 29 |
1804434 | 1804434 | 2021-10-11 | Clay | Iowa | 19041 | 2711 | 29 |
1801185 | 1801185 | 2021-10-10 | Clay | Iowa | 19041 | 2711 | 29 |
1797936 | 1797936 | 2021-10-09 | Clay | Iowa | 19041 | 2711 | 29 |
1794687 | 1794687 | 2021-10-08 | Clay | Iowa | 19041 | 2711 | 29 |
1791439 | 1791439 | 2021-10-07 | Clay | Iowa | 19041 | 2711 | 29 |
1788190 | 1788190 | 2021-10-06 | Clay | Iowa | 19041 | 2711 | 29 |
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);