ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Scott" and fips = 19163 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175073 | 2175073 | 2022-02-02 | Scott | Iowa | 19163 | 39182 | 359 |
2171820 | 2171820 | 2022-02-01 | Scott | Iowa | 19163 | 37931 | 346 |
2168567 | 2168567 | 2022-01-31 | Scott | Iowa | 19163 | 37931 | 346 |
2165312 | 2165312 | 2022-01-30 | Scott | Iowa | 19163 | 37931 | 346 |
2162057 | 2162057 | 2022-01-29 | Scott | Iowa | 19163 | 37931 | 346 |
2158802 | 2158802 | 2022-01-28 | Scott | Iowa | 19163 | 37931 | 346 |
2155548 | 2155548 | 2022-01-27 | Scott | Iowa | 19163 | 37931 | 346 |
2152295 | 2152295 | 2022-01-26 | Scott | Iowa | 19163 | 37931 | 346 |
2149043 | 2149043 | 2022-01-25 | Scott | Iowa | 19163 | 36329 | 335 |
2145791 | 2145791 | 2022-01-24 | Scott | Iowa | 19163 | 36329 | 335 |
2142536 | 2142536 | 2022-01-23 | Scott | Iowa | 19163 | 36329 | 335 |
2139281 | 2139281 | 2022-01-22 | Scott | Iowa | 19163 | 36329 | 335 |
2136025 | 2136025 | 2022-01-21 | Scott | Iowa | 19163 | 36329 | 335 |
2132773 | 2132773 | 2022-01-20 | Scott | Iowa | 19163 | 36329 | 335 |
2129520 | 2129520 | 2022-01-19 | Scott | Iowa | 19163 | 36329 | 335 |
2126266 | 2126266 | 2022-01-18 | Scott | Iowa | 19163 | 34449 | 328 |
2123014 | 2123014 | 2022-01-17 | Scott | Iowa | 19163 | 34449 | 328 |
2119762 | 2119762 | 2022-01-16 | Scott | Iowa | 19163 | 34449 | 328 |
2116510 | 2116510 | 2022-01-15 | Scott | Iowa | 19163 | 34449 | 328 |
2113259 | 2113259 | 2022-01-14 | Scott | Iowa | 19163 | 34449 | 328 |
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 |
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);