ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Scott" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110007 | 2110007 | 2022-01-13 | Scott | Iowa | 19163 | 34449 | 328 |
2106756 | 2106756 | 2022-01-12 | Scott | Iowa | 19163 | 34449 | 328 |
2103505 | 2103505 | 2022-01-11 | Scott | Iowa | 19163 | 32506 | 322 |
2100254 | 2100254 | 2022-01-10 | Scott | Iowa | 19163 | 32506 | 322 |
2097003 | 2097003 | 2022-01-09 | Scott | Iowa | 19163 | 32506 | 322 |
2093751 | 2093751 | 2022-01-08 | Scott | Iowa | 19163 | 32506 | 322 |
2090499 | 2090499 | 2022-01-07 | Scott | Iowa | 19163 | 32506 | 322 |
2087248 | 2087248 | 2022-01-06 | Scott | Iowa | 19163 | 32506 | 322 |
2083996 | 2083996 | 2022-01-05 | Scott | Iowa | 19163 | 32506 | 322 |
2080744 | 2080744 | 2022-01-04 | Scott | Iowa | 19163 | 30853 | 310 |
2077492 | 2077492 | 2022-01-03 | Scott | Iowa | 19163 | 30853 | 310 |
2074241 | 2074241 | 2022-01-02 | Scott | Iowa | 19163 | 30853 | 310 |
2070990 | 2070990 | 2022-01-01 | Scott | Iowa | 19163 | 30853 | 310 |
2067739 | 2067739 | 2021-12-31 | Scott | Iowa | 19163 | 30853 | 310 |
2064488 | 2064488 | 2021-12-30 | Scott | Iowa | 19163 | 30853 | 310 |
2061238 | 2061238 | 2021-12-29 | Scott | Iowa | 19163 | 30853 | 310 |
2057989 | 2057989 | 2021-12-28 | Scott | Iowa | 19163 | 29900 | 310 |
2054740 | 2054740 | 2021-12-27 | Scott | Iowa | 19163 | 29900 | 310 |
2051490 | 2051490 | 2021-12-26 | Scott | Iowa | 19163 | 29900 | 310 |
2048240 | 2048240 | 2021-12-25 | Scott | Iowa | 19163 | 29900 | 310 |
2044990 | 2044990 | 2021-12-24 | Scott | Iowa | 19163 | 29900 | 310 |
2041741 | 2041741 | 2021-12-23 | Scott | Iowa | 19163 | 29900 | 310 |
2038491 | 2038491 | 2021-12-22 | Scott | Iowa | 19163 | 29900 | 310 |
2035241 | 2035241 | 2021-12-21 | Scott | Iowa | 19163 | 28907 | 305 |
2031991 | 2031991 | 2021-12-20 | Scott | Iowa | 19163 | 28907 | 305 |
2028740 | 2028740 | 2021-12-19 | Scott | Iowa | 19163 | 28907 | 305 |
2025489 | 2025489 | 2021-12-18 | Scott | Iowa | 19163 | 28907 | 305 |
2022238 | 2022238 | 2021-12-17 | Scott | Iowa | 19163 | 28907 | 305 |
2018987 | 2018987 | 2021-12-16 | Scott | Iowa | 19163 | 28907 | 305 |
2015737 | 2015737 | 2021-12-15 | Scott | Iowa | 19163 | 28907 | 305 |
2012486 | 2012486 | 2021-12-14 | Scott | Iowa | 19163 | 28028 | 301 |
2009235 | 2009235 | 2021-12-13 | Scott | Iowa | 19163 | 28028 | 301 |
2005984 | 2005984 | 2021-12-12 | Scott | Iowa | 19163 | 28028 | 301 |
2002733 | 2002733 | 2021-12-11 | Scott | Iowa | 19163 | 28028 | 301 |
1999483 | 1999483 | 2021-12-10 | Scott | Iowa | 19163 | 28028 | 301 |
1996232 | 1996232 | 2021-12-09 | Scott | Iowa | 19163 | 28028 | 301 |
1992981 | 1992981 | 2021-12-08 | Scott | Iowa | 19163 | 28028 | 301 |
1989730 | 1989730 | 2021-12-07 | Scott | Iowa | 19163 | 27227 | 295 |
1986480 | 1986480 | 2021-12-06 | Scott | Iowa | 19163 | 27227 | 295 |
1983230 | 1983230 | 2021-12-05 | Scott | Iowa | 19163 | 27227 | 295 |
1979980 | 1979980 | 2021-12-04 | Scott | Iowa | 19163 | 27227 | 295 |
1976730 | 1976730 | 2021-12-03 | Scott | Iowa | 19163 | 27227 | 295 |
1973481 | 1973481 | 2021-12-02 | Scott | Iowa | 19163 | 27227 | 295 |
1970231 | 1970231 | 2021-12-01 | Scott | Iowa | 19163 | 27227 | 295 |
1966981 | 1966981 | 2021-11-30 | Scott | Iowa | 19163 | 26705 | 292 |
1963729 | 1963729 | 2021-11-29 | Scott | Iowa | 19163 | 26705 | 292 |
1960478 | 1960478 | 2021-11-28 | Scott | Iowa | 19163 | 26705 | 292 |
1957227 | 1957227 | 2021-11-27 | Scott | Iowa | 19163 | 26705 | 292 |
1953976 | 1953976 | 2021-11-26 | Scott | Iowa | 19163 | 26705 | 292 |
1950725 | 1950725 | 2021-11-25 | Scott | Iowa | 19163 | 26705 | 292 |
1947474 | 1947474 | 2021-11-24 | Scott | Iowa | 19163 | 26705 | 292 |
1944223 | 1944223 | 2021-11-23 | Scott | Iowa | 19163 | 26226 | 288 |
1940973 | 1940973 | 2021-11-22 | Scott | Iowa | 19163 | 26226 | 288 |
1937723 | 1937723 | 2021-11-21 | Scott | Iowa | 19163 | 26226 | 288 |
1934473 | 1934473 | 2021-11-20 | Scott | Iowa | 19163 | 26226 | 288 |
1931222 | 1931222 | 2021-11-19 | Scott | Iowa | 19163 | 26226 | 288 |
1927971 | 1927971 | 2021-11-18 | Scott | Iowa | 19163 | 26226 | 288 |
1924721 | 1924721 | 2021-11-17 | Scott | Iowa | 19163 | 26226 | 288 |
1921472 | 1921472 | 2021-11-16 | Scott | Iowa | 19163 | 25838 | 282 |
1918222 | 1918222 | 2021-11-15 | Scott | Iowa | 19163 | 25838 | 282 |
1914972 | 1914972 | 2021-11-14 | Scott | Iowa | 19163 | 25838 | 282 |
1911722 | 1911722 | 2021-11-13 | Scott | Iowa | 19163 | 25838 | 282 |
1908473 | 1908473 | 2021-11-12 | Scott | Iowa | 19163 | 25838 | 282 |
1905224 | 1905224 | 2021-11-11 | Scott | Iowa | 19163 | 25838 | 282 |
1901974 | 1901974 | 2021-11-10 | Scott | Iowa | 19163 | 25838 | 282 |
1898724 | 1898724 | 2021-11-09 | Scott | Iowa | 19163 | 25243 | 282 |
1895474 | 1895474 | 2021-11-08 | Scott | Iowa | 19163 | 25243 | 282 |
1892224 | 1892224 | 2021-11-07 | Scott | Iowa | 19163 | 25243 | 282 |
1888974 | 1888974 | 2021-11-06 | Scott | Iowa | 19163 | 25243 | 282 |
1885724 | 1885724 | 2021-11-05 | Scott | Iowa | 19163 | 25243 | 282 |
1882475 | 1882475 | 2021-11-04 | Scott | Iowa | 19163 | 25243 | 282 |
1879226 | 1879226 | 2021-11-03 | Scott | Iowa | 19163 | 25243 | 282 |
1875977 | 1875977 | 2021-11-02 | Scott | Iowa | 19163 | 25000 | 276 |
1872728 | 1872728 | 2021-11-01 | Scott | Iowa | 19163 | 25000 | 276 |
1869479 | 1869479 | 2021-10-31 | Scott | Iowa | 19163 | 25000 | 276 |
1866230 | 1866230 | 2021-10-30 | Scott | Iowa | 19163 | 25000 | 276 |
1862981 | 1862981 | 2021-10-29 | Scott | Iowa | 19163 | 25000 | 276 |
1859732 | 1859732 | 2021-10-28 | Scott | Iowa | 19163 | 25000 | 276 |
1856483 | 1856483 | 2021-10-27 | Scott | Iowa | 19163 | 25000 | 276 |
1853234 | 1853234 | 2021-10-26 | Scott | Iowa | 19163 | 24750 | 274 |
1849985 | 1849985 | 2021-10-25 | Scott | Iowa | 19163 | 24750 | 274 |
1846735 | 1846735 | 2021-10-24 | Scott | Iowa | 19163 | 24750 | 274 |
1843485 | 1843485 | 2021-10-23 | Scott | Iowa | 19163 | 24750 | 274 |
1840235 | 1840235 | 2021-10-22 | Scott | Iowa | 19163 | 24750 | 274 |
1836986 | 1836986 | 2021-10-21 | Scott | Iowa | 19163 | 24750 | 274 |
1833737 | 1833737 | 2021-10-20 | Scott | Iowa | 19163 | 24750 | 274 |
1830488 | 1830488 | 2021-10-19 | Scott | Iowa | 19163 | 24459 | 271 |
1827239 | 1827239 | 2021-10-18 | Scott | Iowa | 19163 | 24459 | 271 |
1823990 | 1823990 | 2021-10-17 | Scott | Iowa | 19163 | 24459 | 271 |
1820741 | 1820741 | 2021-10-16 | Scott | Iowa | 19163 | 24459 | 271 |
1817492 | 1817492 | 2021-10-15 | Scott | Iowa | 19163 | 24459 | 271 |
1814244 | 1814244 | 2021-10-14 | Scott | Iowa | 19163 | 24459 | 271 |
1810995 | 1810995 | 2021-10-13 | Scott | Iowa | 19163 | 24459 | 271 |
1807746 | 1807746 | 2021-10-12 | Scott | Iowa | 19163 | 24172 | 270 |
1804495 | 1804495 | 2021-10-11 | Scott | Iowa | 19163 | 24172 | 270 |
1801246 | 1801246 | 2021-10-10 | Scott | Iowa | 19163 | 24172 | 270 |
1797997 | 1797997 | 2021-10-09 | Scott | Iowa | 19163 | 24172 | 270 |
1794748 | 1794748 | 2021-10-08 | Scott | Iowa | 19163 | 24172 | 270 |
1791500 | 1791500 | 2021-10-07 | Scott | Iowa | 19163 | 24172 | 270 |
1788251 | 1788251 | 2021-10-06 | Scott | Iowa | 19163 | 24172 | 270 |
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);