ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 19001 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109926 | 2109926 | 2022-01-13 | Adair | Iowa | 19001 | 1392 | 46 |
2106675 | 2106675 | 2022-01-12 | Adair | Iowa | 19001 | 1392 | 46 |
2103424 | 2103424 | 2022-01-11 | Adair | Iowa | 19001 | 1363 | 44 |
2100173 | 2100173 | 2022-01-10 | Adair | Iowa | 19001 | 1363 | 44 |
2096922 | 2096922 | 2022-01-09 | Adair | Iowa | 19001 | 1363 | 44 |
2093670 | 2093670 | 2022-01-08 | Adair | Iowa | 19001 | 1363 | 44 |
2090418 | 2090418 | 2022-01-07 | Adair | Iowa | 19001 | 1363 | 44 |
2087167 | 2087167 | 2022-01-06 | Adair | Iowa | 19001 | 1363 | 44 |
2083915 | 2083915 | 2022-01-05 | Adair | Iowa | 19001 | 1363 | 44 |
2080663 | 2080663 | 2022-01-04 | Adair | Iowa | 19001 | 1330 | 44 |
2077411 | 2077411 | 2022-01-03 | Adair | Iowa | 19001 | 1330 | 44 |
2074160 | 2074160 | 2022-01-02 | Adair | Iowa | 19001 | 1330 | 44 |
2070909 | 2070909 | 2022-01-01 | Adair | Iowa | 19001 | 1330 | 44 |
2067658 | 2067658 | 2021-12-31 | Adair | Iowa | 19001 | 1330 | 44 |
2064407 | 2064407 | 2021-12-30 | Adair | Iowa | 19001 | 1330 | 44 |
2061157 | 2061157 | 2021-12-29 | Adair | Iowa | 19001 | 1330 | 44 |
2057908 | 2057908 | 2021-12-28 | Adair | Iowa | 19001 | 1305 | 43 |
2054659 | 2054659 | 2021-12-27 | Adair | Iowa | 19001 | 1305 | 43 |
2051409 | 2051409 | 2021-12-26 | Adair | Iowa | 19001 | 1305 | 43 |
2048159 | 2048159 | 2021-12-25 | Adair | Iowa | 19001 | 1305 | 43 |
2044909 | 2044909 | 2021-12-24 | Adair | Iowa | 19001 | 1305 | 43 |
2041660 | 2041660 | 2021-12-23 | Adair | Iowa | 19001 | 1305 | 43 |
2038410 | 2038410 | 2021-12-22 | Adair | Iowa | 19001 | 1305 | 43 |
2035160 | 2035160 | 2021-12-21 | Adair | Iowa | 19001 | 1264 | 43 |
2031910 | 2031910 | 2021-12-20 | Adair | Iowa | 19001 | 1264 | 43 |
2028659 | 2028659 | 2021-12-19 | Adair | Iowa | 19001 | 1264 | 43 |
2025408 | 2025408 | 2021-12-18 | Adair | Iowa | 19001 | 1264 | 43 |
2022157 | 2022157 | 2021-12-17 | Adair | Iowa | 19001 | 1264 | 43 |
2018906 | 2018906 | 2021-12-16 | Adair | Iowa | 19001 | 1264 | 43 |
2015656 | 2015656 | 2021-12-15 | Adair | Iowa | 19001 | 1264 | 43 |
2012405 | 2012405 | 2021-12-14 | Adair | Iowa | 19001 | 1219 | 41 |
2009154 | 2009154 | 2021-12-13 | Adair | Iowa | 19001 | 1219 | 41 |
2005903 | 2005903 | 2021-12-12 | Adair | Iowa | 19001 | 1219 | 41 |
2002652 | 2002652 | 2021-12-11 | Adair | Iowa | 19001 | 1219 | 41 |
1999402 | 1999402 | 2021-12-10 | Adair | Iowa | 19001 | 1219 | 41 |
1996151 | 1996151 | 2021-12-09 | Adair | Iowa | 19001 | 1219 | 41 |
1992900 | 1992900 | 2021-12-08 | Adair | Iowa | 19001 | 1219 | 41 |
1989649 | 1989649 | 2021-12-07 | Adair | Iowa | 19001 | 1187 | 39 |
1986399 | 1986399 | 2021-12-06 | Adair | Iowa | 19001 | 1187 | 39 |
1983149 | 1983149 | 2021-12-05 | Adair | Iowa | 19001 | 1187 | 39 |
1979899 | 1979899 | 2021-12-04 | Adair | Iowa | 19001 | 1187 | 39 |
1976649 | 1976649 | 2021-12-03 | Adair | Iowa | 19001 | 1187 | 39 |
1973400 | 1973400 | 2021-12-02 | Adair | Iowa | 19001 | 1187 | 39 |
1970150 | 1970150 | 2021-12-01 | Adair | Iowa | 19001 | 1187 | 39 |
1966900 | 1966900 | 2021-11-30 | Adair | Iowa | 19001 | 1149 | 37 |
1963648 | 1963648 | 2021-11-29 | Adair | Iowa | 19001 | 1149 | 37 |
1960397 | 1960397 | 2021-11-28 | Adair | Iowa | 19001 | 1149 | 37 |
1957146 | 1957146 | 2021-11-27 | Adair | Iowa | 19001 | 1149 | 37 |
1953895 | 1953895 | 2021-11-26 | Adair | Iowa | 19001 | 1149 | 37 |
1950644 | 1950644 | 2021-11-25 | Adair | Iowa | 19001 | 1149 | 37 |
1947393 | 1947393 | 2021-11-24 | Adair | Iowa | 19001 | 1149 | 37 |
1944142 | 1944142 | 2021-11-23 | Adair | Iowa | 19001 | 1114 | 37 |
1940892 | 1940892 | 2021-11-22 | Adair | Iowa | 19001 | 1114 | 37 |
1937642 | 1937642 | 2021-11-21 | Adair | Iowa | 19001 | 1114 | 37 |
1934392 | 1934392 | 2021-11-20 | Adair | Iowa | 19001 | 1114 | 37 |
1931141 | 1931141 | 2021-11-19 | Adair | Iowa | 19001 | 1114 | 37 |
1927890 | 1927890 | 2021-11-18 | Adair | Iowa | 19001 | 1114 | 37 |
1924640 | 1924640 | 2021-11-17 | Adair | Iowa | 19001 | 1114 | 37 |
1921391 | 1921391 | 2021-11-16 | Adair | Iowa | 19001 | 1090 | 37 |
1918141 | 1918141 | 2021-11-15 | Adair | Iowa | 19001 | 1090 | 37 |
1914891 | 1914891 | 2021-11-14 | Adair | Iowa | 19001 | 1090 | 37 |
1911641 | 1911641 | 2021-11-13 | Adair | Iowa | 19001 | 1090 | 37 |
1908392 | 1908392 | 2021-11-12 | Adair | Iowa | 19001 | 1090 | 37 |
1905143 | 1905143 | 2021-11-11 | Adair | Iowa | 19001 | 1090 | 37 |
1901893 | 1901893 | 2021-11-10 | Adair | Iowa | 19001 | 1090 | 37 |
1898643 | 1898643 | 2021-11-09 | Adair | Iowa | 19001 | 1073 | 36 |
1895393 | 1895393 | 2021-11-08 | Adair | Iowa | 19001 | 1073 | 36 |
1892143 | 1892143 | 2021-11-07 | Adair | Iowa | 19001 | 1073 | 36 |
1888893 | 1888893 | 2021-11-06 | Adair | Iowa | 19001 | 1073 | 36 |
1885643 | 1885643 | 2021-11-05 | Adair | Iowa | 19001 | 1073 | 36 |
1882394 | 1882394 | 2021-11-04 | Adair | Iowa | 19001 | 1073 | 36 |
1879145 | 1879145 | 2021-11-03 | Adair | Iowa | 19001 | 1073 | 36 |
1875896 | 1875896 | 2021-11-02 | Adair | Iowa | 19001 | 1062 | 35 |
1872647 | 1872647 | 2021-11-01 | Adair | Iowa | 19001 | 1062 | 35 |
1869398 | 1869398 | 2021-10-31 | Adair | Iowa | 19001 | 1062 | 35 |
1866149 | 1866149 | 2021-10-30 | Adair | Iowa | 19001 | 1062 | 35 |
1862900 | 1862900 | 2021-10-29 | Adair | Iowa | 19001 | 1062 | 35 |
1859651 | 1859651 | 2021-10-28 | Adair | Iowa | 19001 | 1062 | 35 |
1856402 | 1856402 | 2021-10-27 | Adair | Iowa | 19001 | 1062 | 35 |
1853153 | 1853153 | 2021-10-26 | Adair | Iowa | 19001 | 1053 | 35 |
1849904 | 1849904 | 2021-10-25 | Adair | Iowa | 19001 | 1053 | 35 |
1846654 | 1846654 | 2021-10-24 | Adair | Iowa | 19001 | 1053 | 35 |
1843404 | 1843404 | 2021-10-23 | Adair | Iowa | 19001 | 1053 | 35 |
1840154 | 1840154 | 2021-10-22 | Adair | Iowa | 19001 | 1053 | 35 |
1836905 | 1836905 | 2021-10-21 | Adair | Iowa | 19001 | 1053 | 35 |
1833656 | 1833656 | 2021-10-20 | Adair | Iowa | 19001 | 1053 | 35 |
1830407 | 1830407 | 2021-10-19 | Adair | Iowa | 19001 | 1038 | 34 |
1827158 | 1827158 | 2021-10-18 | Adair | Iowa | 19001 | 1038 | 34 |
1823909 | 1823909 | 2021-10-17 | Adair | Iowa | 19001 | 1038 | 34 |
1820660 | 1820660 | 2021-10-16 | Adair | Iowa | 19001 | 1038 | 34 |
1817411 | 1817411 | 2021-10-15 | Adair | Iowa | 19001 | 1038 | 34 |
1814163 | 1814163 | 2021-10-14 | Adair | Iowa | 19001 | 1038 | 34 |
1810914 | 1810914 | 2021-10-13 | Adair | Iowa | 19001 | 1038 | 34 |
1807665 | 1807665 | 2021-10-12 | Adair | Iowa | 19001 | 1010 | 34 |
1804414 | 1804414 | 2021-10-11 | Adair | Iowa | 19001 | 1010 | 34 |
1801165 | 1801165 | 2021-10-10 | Adair | Iowa | 19001 | 1010 | 34 |
1797916 | 1797916 | 2021-10-09 | Adair | Iowa | 19001 | 1010 | 34 |
1794667 | 1794667 | 2021-10-08 | Adair | Iowa | 19001 | 1010 | 34 |
1791419 | 1791419 | 2021-10-07 | Adair | Iowa | 19001 | 1010 | 34 |
1788170 | 1788170 | 2021-10-06 | Adair | Iowa | 19001 | 1010 | 34 |
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);