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 |
---|---|---|---|---|---|---|---|
2174992 | 2174992 | 2022-02-02 | Adair | Iowa | 19001 | 1525 | 47 |
2171739 | 2171739 | 2022-02-01 | Adair | Iowa | 19001 | 1488 | 46 |
2168486 | 2168486 | 2022-01-31 | Adair | Iowa | 19001 | 1488 | 46 |
2165231 | 2165231 | 2022-01-30 | Adair | Iowa | 19001 | 1488 | 46 |
2161976 | 2161976 | 2022-01-29 | Adair | Iowa | 19001 | 1488 | 46 |
2158721 | 2158721 | 2022-01-28 | Adair | Iowa | 19001 | 1488 | 46 |
2155467 | 2155467 | 2022-01-27 | Adair | Iowa | 19001 | 1488 | 46 |
2152214 | 2152214 | 2022-01-26 | Adair | Iowa | 19001 | 1488 | 46 |
2148962 | 2148962 | 2022-01-25 | Adair | Iowa | 19001 | 1440 | 46 |
2145710 | 2145710 | 2022-01-24 | Adair | Iowa | 19001 | 1440 | 46 |
2142455 | 2142455 | 2022-01-23 | Adair | Iowa | 19001 | 1440 | 46 |
2139200 | 2139200 | 2022-01-22 | Adair | Iowa | 19001 | 1440 | 46 |
2135944 | 2135944 | 2022-01-21 | Adair | Iowa | 19001 | 1440 | 46 |
2132692 | 2132692 | 2022-01-20 | Adair | Iowa | 19001 | 1440 | 46 |
2129439 | 2129439 | 2022-01-19 | Adair | Iowa | 19001 | 1440 | 46 |
2126185 | 2126185 | 2022-01-18 | Adair | Iowa | 19001 | 1392 | 46 |
2122933 | 2122933 | 2022-01-17 | Adair | Iowa | 19001 | 1392 | 46 |
2119681 | 2119681 | 2022-01-16 | Adair | Iowa | 19001 | 1392 | 46 |
2116429 | 2116429 | 2022-01-15 | Adair | Iowa | 19001 | 1392 | 46 |
2113178 | 2113178 | 2022-01-14 | Adair | Iowa | 19001 | 1392 | 46 |
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 |
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);