ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Dickinson" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109955 | 2109955 | 2022-01-13 | Dickinson | Iowa | 19059 | 3597 | 61 |
2106704 | 2106704 | 2022-01-12 | Dickinson | Iowa | 19059 | 3597 | 61 |
2103453 | 2103453 | 2022-01-11 | Dickinson | Iowa | 19059 | 3466 | 61 |
2100202 | 2100202 | 2022-01-10 | Dickinson | Iowa | 19059 | 3466 | 61 |
2096951 | 2096951 | 2022-01-09 | Dickinson | Iowa | 19059 | 3466 | 61 |
2093699 | 2093699 | 2022-01-08 | Dickinson | Iowa | 19059 | 3466 | 61 |
2090447 | 2090447 | 2022-01-07 | Dickinson | Iowa | 19059 | 3466 | 61 |
2087196 | 2087196 | 2022-01-06 | Dickinson | Iowa | 19059 | 3466 | 61 |
2083944 | 2083944 | 2022-01-05 | Dickinson | Iowa | 19059 | 3466 | 61 |
2080692 | 2080692 | 2022-01-04 | Dickinson | Iowa | 19059 | 3383 | 60 |
2077440 | 2077440 | 2022-01-03 | Dickinson | Iowa | 19059 | 3383 | 60 |
2074189 | 2074189 | 2022-01-02 | Dickinson | Iowa | 19059 | 3383 | 60 |
2070938 | 2070938 | 2022-01-01 | Dickinson | Iowa | 19059 | 3383 | 60 |
2067687 | 2067687 | 2021-12-31 | Dickinson | Iowa | 19059 | 3383 | 60 |
2064436 | 2064436 | 2021-12-30 | Dickinson | Iowa | 19059 | 3383 | 60 |
2061186 | 2061186 | 2021-12-29 | Dickinson | Iowa | 19059 | 3383 | 60 |
2057937 | 2057937 | 2021-12-28 | Dickinson | Iowa | 19059 | 3332 | 60 |
2054688 | 2054688 | 2021-12-27 | Dickinson | Iowa | 19059 | 3332 | 60 |
2051438 | 2051438 | 2021-12-26 | Dickinson | Iowa | 19059 | 3332 | 60 |
2048188 | 2048188 | 2021-12-25 | Dickinson | Iowa | 19059 | 3332 | 60 |
2044938 | 2044938 | 2021-12-24 | Dickinson | Iowa | 19059 | 3332 | 60 |
2041689 | 2041689 | 2021-12-23 | Dickinson | Iowa | 19059 | 3332 | 60 |
2038439 | 2038439 | 2021-12-22 | Dickinson | Iowa | 19059 | 3332 | 60 |
2035189 | 2035189 | 2021-12-21 | Dickinson | Iowa | 19059 | 3289 | 57 |
2031939 | 2031939 | 2021-12-20 | Dickinson | Iowa | 19059 | 3289 | 57 |
2028688 | 2028688 | 2021-12-19 | Dickinson | Iowa | 19059 | 3289 | 57 |
2025437 | 2025437 | 2021-12-18 | Dickinson | Iowa | 19059 | 3289 | 57 |
2022186 | 2022186 | 2021-12-17 | Dickinson | Iowa | 19059 | 3289 | 57 |
2018935 | 2018935 | 2021-12-16 | Dickinson | Iowa | 19059 | 3289 | 57 |
2015685 | 2015685 | 2021-12-15 | Dickinson | Iowa | 19059 | 3289 | 57 |
2012434 | 2012434 | 2021-12-14 | Dickinson | Iowa | 19059 | 3230 | 56 |
2009183 | 2009183 | 2021-12-13 | Dickinson | Iowa | 19059 | 3230 | 56 |
2005932 | 2005932 | 2021-12-12 | Dickinson | Iowa | 19059 | 3230 | 56 |
2002681 | 2002681 | 2021-12-11 | Dickinson | Iowa | 19059 | 3230 | 56 |
1999431 | 1999431 | 2021-12-10 | Dickinson | Iowa | 19059 | 3230 | 56 |
1996180 | 1996180 | 2021-12-09 | Dickinson | Iowa | 19059 | 3230 | 56 |
1992929 | 1992929 | 2021-12-08 | Dickinson | Iowa | 19059 | 3230 | 56 |
1989678 | 1989678 | 2021-12-07 | Dickinson | Iowa | 19059 | 3183 | 55 |
1986428 | 1986428 | 2021-12-06 | Dickinson | Iowa | 19059 | 3183 | 55 |
1983178 | 1983178 | 2021-12-05 | Dickinson | Iowa | 19059 | 3183 | 55 |
1979928 | 1979928 | 2021-12-04 | Dickinson | Iowa | 19059 | 3183 | 55 |
1976678 | 1976678 | 2021-12-03 | Dickinson | Iowa | 19059 | 3183 | 55 |
1973429 | 1973429 | 2021-12-02 | Dickinson | Iowa | 19059 | 3183 | 55 |
1970179 | 1970179 | 2021-12-01 | Dickinson | Iowa | 19059 | 3183 | 55 |
1966929 | 1966929 | 2021-11-30 | Dickinson | Iowa | 19059 | 3150 | 55 |
1963677 | 1963677 | 2021-11-29 | Dickinson | Iowa | 19059 | 3150 | 55 |
1960426 | 1960426 | 2021-11-28 | Dickinson | Iowa | 19059 | 3150 | 55 |
1957175 | 1957175 | 2021-11-27 | Dickinson | Iowa | 19059 | 3150 | 55 |
1953924 | 1953924 | 2021-11-26 | Dickinson | Iowa | 19059 | 3150 | 55 |
1950673 | 1950673 | 2021-11-25 | Dickinson | Iowa | 19059 | 3150 | 55 |
1947422 | 1947422 | 2021-11-24 | Dickinson | Iowa | 19059 | 3150 | 55 |
1944171 | 1944171 | 2021-11-23 | Dickinson | Iowa | 19059 | 3122 | 55 |
1940921 | 1940921 | 2021-11-22 | Dickinson | Iowa | 19059 | 3122 | 55 |
1937671 | 1937671 | 2021-11-21 | Dickinson | Iowa | 19059 | 3122 | 55 |
1934421 | 1934421 | 2021-11-20 | Dickinson | Iowa | 19059 | 3122 | 55 |
1931170 | 1931170 | 2021-11-19 | Dickinson | Iowa | 19059 | 3122 | 55 |
1927919 | 1927919 | 2021-11-18 | Dickinson | Iowa | 19059 | 3122 | 55 |
1924669 | 1924669 | 2021-11-17 | Dickinson | Iowa | 19059 | 3122 | 55 |
1921420 | 1921420 | 2021-11-16 | Dickinson | Iowa | 19059 | 3085 | 53 |
1918170 | 1918170 | 2021-11-15 | Dickinson | Iowa | 19059 | 3085 | 53 |
1914920 | 1914920 | 2021-11-14 | Dickinson | Iowa | 19059 | 3085 | 53 |
1911670 | 1911670 | 2021-11-13 | Dickinson | Iowa | 19059 | 3085 | 53 |
1908421 | 1908421 | 2021-11-12 | Dickinson | Iowa | 19059 | 3085 | 53 |
1905172 | 1905172 | 2021-11-11 | Dickinson | Iowa | 19059 | 3085 | 53 |
1901922 | 1901922 | 2021-11-10 | Dickinson | Iowa | 19059 | 3085 | 53 |
1898672 | 1898672 | 2021-11-09 | Dickinson | Iowa | 19059 | 3062 | 52 |
1895422 | 1895422 | 2021-11-08 | Dickinson | Iowa | 19059 | 3062 | 52 |
1892172 | 1892172 | 2021-11-07 | Dickinson | Iowa | 19059 | 3062 | 52 |
1888922 | 1888922 | 2021-11-06 | Dickinson | Iowa | 19059 | 3062 | 52 |
1885672 | 1885672 | 2021-11-05 | Dickinson | Iowa | 19059 | 3062 | 52 |
1882423 | 1882423 | 2021-11-04 | Dickinson | Iowa | 19059 | 3062 | 52 |
1879174 | 1879174 | 2021-11-03 | Dickinson | Iowa | 19059 | 3062 | 52 |
1875925 | 1875925 | 2021-11-02 | Dickinson | Iowa | 19059 | 3033 | 52 |
1872676 | 1872676 | 2021-11-01 | Dickinson | Iowa | 19059 | 3033 | 52 |
1869427 | 1869427 | 2021-10-31 | Dickinson | Iowa | 19059 | 3033 | 52 |
1866178 | 1866178 | 2021-10-30 | Dickinson | Iowa | 19059 | 3033 | 52 |
1862929 | 1862929 | 2021-10-29 | Dickinson | Iowa | 19059 | 3033 | 52 |
1859680 | 1859680 | 2021-10-28 | Dickinson | Iowa | 19059 | 3033 | 52 |
1856431 | 1856431 | 2021-10-27 | Dickinson | Iowa | 19059 | 3033 | 52 |
1853182 | 1853182 | 2021-10-26 | Dickinson | Iowa | 19059 | 3010 | 52 |
1849933 | 1849933 | 2021-10-25 | Dickinson | Iowa | 19059 | 3010 | 52 |
1846683 | 1846683 | 2021-10-24 | Dickinson | Iowa | 19059 | 3010 | 52 |
1843433 | 1843433 | 2021-10-23 | Dickinson | Iowa | 19059 | 3010 | 52 |
1840183 | 1840183 | 2021-10-22 | Dickinson | Iowa | 19059 | 3010 | 52 |
1836934 | 1836934 | 2021-10-21 | Dickinson | Iowa | 19059 | 3010 | 52 |
1833685 | 1833685 | 2021-10-20 | Dickinson | Iowa | 19059 | 3010 | 52 |
1830436 | 1830436 | 2021-10-19 | Dickinson | Iowa | 19059 | 2976 | 51 |
1827187 | 1827187 | 2021-10-18 | Dickinson | Iowa | 19059 | 2976 | 51 |
1823938 | 1823938 | 2021-10-17 | Dickinson | Iowa | 19059 | 2976 | 51 |
1820689 | 1820689 | 2021-10-16 | Dickinson | Iowa | 19059 | 2976 | 51 |
1817440 | 1817440 | 2021-10-15 | Dickinson | Iowa | 19059 | 2976 | 51 |
1814192 | 1814192 | 2021-10-14 | Dickinson | Iowa | 19059 | 2976 | 51 |
1810943 | 1810943 | 2021-10-13 | Dickinson | Iowa | 19059 | 2976 | 51 |
1807694 | 1807694 | 2021-10-12 | Dickinson | Iowa | 19059 | 2915 | 51 |
1804443 | 1804443 | 2021-10-11 | Dickinson | Iowa | 19059 | 2915 | 51 |
1801194 | 1801194 | 2021-10-10 | Dickinson | Iowa | 19059 | 2915 | 51 |
1797945 | 1797945 | 2021-10-09 | Dickinson | Iowa | 19059 | 2915 | 51 |
1794696 | 1794696 | 2021-10-08 | Dickinson | Iowa | 19059 | 2915 | 51 |
1791448 | 1791448 | 2021-10-07 | Dickinson | Iowa | 19059 | 2915 | 51 |
1788199 | 1788199 | 2021-10-06 | Dickinson | Iowa | 19059 | 2915 | 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);