ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Marshall" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175055 | 2175055 | 2022-02-02 | Marshall | Iowa | 19127 | 8993 | 98 |
2171802 | 2171802 | 2022-02-01 | Marshall | Iowa | 19127 | 8776 | 96 |
2168549 | 2168549 | 2022-01-31 | Marshall | Iowa | 19127 | 8776 | 96 |
2165294 | 2165294 | 2022-01-30 | Marshall | Iowa | 19127 | 8776 | 96 |
2162039 | 2162039 | 2022-01-29 | Marshall | Iowa | 19127 | 8776 | 96 |
2158784 | 2158784 | 2022-01-28 | Marshall | Iowa | 19127 | 8776 | 96 |
2155530 | 2155530 | 2022-01-27 | Marshall | Iowa | 19127 | 8776 | 96 |
2152277 | 2152277 | 2022-01-26 | Marshall | Iowa | 19127 | 8776 | 96 |
2149025 | 2149025 | 2022-01-25 | Marshall | Iowa | 19127 | 8306 | 96 |
2145773 | 2145773 | 2022-01-24 | Marshall | Iowa | 19127 | 8306 | 96 |
2142518 | 2142518 | 2022-01-23 | Marshall | Iowa | 19127 | 8306 | 96 |
2139263 | 2139263 | 2022-01-22 | Marshall | Iowa | 19127 | 8306 | 96 |
2136007 | 2136007 | 2022-01-21 | Marshall | Iowa | 19127 | 8306 | 96 |
2132755 | 2132755 | 2022-01-20 | Marshall | Iowa | 19127 | 8306 | 96 |
2129502 | 2129502 | 2022-01-19 | Marshall | Iowa | 19127 | 8306 | 96 |
2126248 | 2126248 | 2022-01-18 | Marshall | Iowa | 19127 | 7847 | 95 |
2122996 | 2122996 | 2022-01-17 | Marshall | Iowa | 19127 | 7847 | 95 |
2119744 | 2119744 | 2022-01-16 | Marshall | Iowa | 19127 | 7847 | 95 |
2116492 | 2116492 | 2022-01-15 | Marshall | Iowa | 19127 | 7847 | 95 |
2113241 | 2113241 | 2022-01-14 | Marshall | Iowa | 19127 | 7847 | 95 |
2109989 | 2109989 | 2022-01-13 | Marshall | Iowa | 19127 | 7847 | 95 |
2106738 | 2106738 | 2022-01-12 | Marshall | Iowa | 19127 | 7847 | 95 |
2103487 | 2103487 | 2022-01-11 | Marshall | Iowa | 19127 | 7361 | 95 |
2100236 | 2100236 | 2022-01-10 | Marshall | Iowa | 19127 | 7361 | 95 |
2096985 | 2096985 | 2022-01-09 | Marshall | Iowa | 19127 | 7361 | 95 |
2093733 | 2093733 | 2022-01-08 | Marshall | Iowa | 19127 | 7361 | 95 |
2090481 | 2090481 | 2022-01-07 | Marshall | Iowa | 19127 | 7361 | 95 |
2087230 | 2087230 | 2022-01-06 | Marshall | Iowa | 19127 | 7361 | 95 |
2083978 | 2083978 | 2022-01-05 | Marshall | Iowa | 19127 | 7361 | 95 |
2080726 | 2080726 | 2022-01-04 | Marshall | Iowa | 19127 | 7148 | 94 |
2077474 | 2077474 | 2022-01-03 | Marshall | Iowa | 19127 | 7148 | 94 |
2074223 | 2074223 | 2022-01-02 | Marshall | Iowa | 19127 | 7148 | 94 |
2070972 | 2070972 | 2022-01-01 | Marshall | Iowa | 19127 | 7148 | 94 |
2067721 | 2067721 | 2021-12-31 | Marshall | Iowa | 19127 | 7148 | 94 |
2064470 | 2064470 | 2021-12-30 | Marshall | Iowa | 19127 | 7148 | 94 |
2061220 | 2061220 | 2021-12-29 | Marshall | Iowa | 19127 | 7148 | 94 |
2057971 | 2057971 | 2021-12-28 | Marshall | Iowa | 19127 | 7031 | 94 |
2054722 | 2054722 | 2021-12-27 | Marshall | Iowa | 19127 | 7031 | 94 |
2051472 | 2051472 | 2021-12-26 | Marshall | Iowa | 19127 | 7031 | 94 |
2048222 | 2048222 | 2021-12-25 | Marshall | Iowa | 19127 | 7031 | 94 |
2044972 | 2044972 | 2021-12-24 | Marshall | Iowa | 19127 | 7031 | 94 |
2041723 | 2041723 | 2021-12-23 | Marshall | Iowa | 19127 | 7031 | 94 |
2038473 | 2038473 | 2021-12-22 | Marshall | Iowa | 19127 | 7031 | 94 |
2035223 | 2035223 | 2021-12-21 | Marshall | Iowa | 19127 | 6945 | 94 |
2031973 | 2031973 | 2021-12-20 | Marshall | Iowa | 19127 | 6945 | 94 |
2028722 | 2028722 | 2021-12-19 | Marshall | Iowa | 19127 | 6945 | 94 |
2025471 | 2025471 | 2021-12-18 | Marshall | Iowa | 19127 | 6945 | 94 |
2022220 | 2022220 | 2021-12-17 | Marshall | Iowa | 19127 | 6945 | 94 |
2018969 | 2018969 | 2021-12-16 | Marshall | Iowa | 19127 | 6945 | 94 |
2015719 | 2015719 | 2021-12-15 | Marshall | Iowa | 19127 | 6945 | 94 |
2012468 | 2012468 | 2021-12-14 | Marshall | Iowa | 19127 | 6856 | 94 |
2009217 | 2009217 | 2021-12-13 | Marshall | Iowa | 19127 | 6856 | 94 |
2005966 | 2005966 | 2021-12-12 | Marshall | Iowa | 19127 | 6856 | 94 |
2002715 | 2002715 | 2021-12-11 | Marshall | Iowa | 19127 | 6856 | 94 |
1999465 | 1999465 | 2021-12-10 | Marshall | Iowa | 19127 | 6856 | 94 |
1996214 | 1996214 | 2021-12-09 | Marshall | Iowa | 19127 | 6856 | 94 |
1992963 | 1992963 | 2021-12-08 | Marshall | Iowa | 19127 | 6856 | 94 |
1989712 | 1989712 | 2021-12-07 | Marshall | Iowa | 19127 | 6767 | 94 |
1986462 | 1986462 | 2021-12-06 | Marshall | Iowa | 19127 | 6767 | 94 |
1983212 | 1983212 | 2021-12-05 | Marshall | Iowa | 19127 | 6767 | 94 |
1979962 | 1979962 | 2021-12-04 | Marshall | Iowa | 19127 | 6767 | 94 |
1976712 | 1976712 | 2021-12-03 | Marshall | Iowa | 19127 | 6767 | 94 |
1973463 | 1973463 | 2021-12-02 | Marshall | Iowa | 19127 | 6767 | 94 |
1970213 | 1970213 | 2021-12-01 | Marshall | Iowa | 19127 | 6767 | 94 |
1966963 | 1966963 | 2021-11-30 | Marshall | Iowa | 19127 | 6704 | 93 |
1963711 | 1963711 | 2021-11-29 | Marshall | Iowa | 19127 | 6704 | 93 |
1960460 | 1960460 | 2021-11-28 | Marshall | Iowa | 19127 | 6704 | 93 |
1957209 | 1957209 | 2021-11-27 | Marshall | Iowa | 19127 | 6704 | 93 |
1953958 | 1953958 | 2021-11-26 | Marshall | Iowa | 19127 | 6704 | 93 |
1950707 | 1950707 | 2021-11-25 | Marshall | Iowa | 19127 | 6704 | 93 |
1947456 | 1947456 | 2021-11-24 | Marshall | Iowa | 19127 | 6704 | 93 |
1944205 | 1944205 | 2021-11-23 | Marshall | Iowa | 19127 | 6623 | 92 |
1940955 | 1940955 | 2021-11-22 | Marshall | Iowa | 19127 | 6623 | 92 |
1937705 | 1937705 | 2021-11-21 | Marshall | Iowa | 19127 | 6623 | 92 |
1934455 | 1934455 | 2021-11-20 | Marshall | Iowa | 19127 | 6623 | 92 |
1931204 | 1931204 | 2021-11-19 | Marshall | Iowa | 19127 | 6623 | 92 |
1927953 | 1927953 | 2021-11-18 | Marshall | Iowa | 19127 | 6623 | 92 |
1924703 | 1924703 | 2021-11-17 | Marshall | Iowa | 19127 | 6623 | 92 |
1921454 | 1921454 | 2021-11-16 | Marshall | Iowa | 19127 | 6576 | 92 |
1918204 | 1918204 | 2021-11-15 | Marshall | Iowa | 19127 | 6576 | 92 |
1914954 | 1914954 | 2021-11-14 | Marshall | Iowa | 19127 | 6576 | 92 |
1911704 | 1911704 | 2021-11-13 | Marshall | Iowa | 19127 | 6576 | 92 |
1908455 | 1908455 | 2021-11-12 | Marshall | Iowa | 19127 | 6576 | 92 |
1905206 | 1905206 | 2021-11-11 | Marshall | Iowa | 19127 | 6576 | 92 |
1901956 | 1901956 | 2021-11-10 | Marshall | Iowa | 19127 | 6576 | 92 |
1898706 | 1898706 | 2021-11-09 | Marshall | Iowa | 19127 | 6529 | 91 |
1895456 | 1895456 | 2021-11-08 | Marshall | Iowa | 19127 | 6529 | 91 |
1892206 | 1892206 | 2021-11-07 | Marshall | Iowa | 19127 | 6529 | 91 |
1888956 | 1888956 | 2021-11-06 | Marshall | Iowa | 19127 | 6529 | 91 |
1885706 | 1885706 | 2021-11-05 | Marshall | Iowa | 19127 | 6529 | 91 |
1882457 | 1882457 | 2021-11-04 | Marshall | Iowa | 19127 | 6529 | 91 |
1879208 | 1879208 | 2021-11-03 | Marshall | Iowa | 19127 | 6529 | 91 |
1875959 | 1875959 | 2021-11-02 | Marshall | Iowa | 19127 | 6476 | 88 |
1872710 | 1872710 | 2021-11-01 | Marshall | Iowa | 19127 | 6476 | 88 |
1869461 | 1869461 | 2021-10-31 | Marshall | Iowa | 19127 | 6476 | 88 |
1866212 | 1866212 | 2021-10-30 | Marshall | Iowa | 19127 | 6476 | 88 |
1862963 | 1862963 | 2021-10-29 | Marshall | Iowa | 19127 | 6476 | 88 |
1859714 | 1859714 | 2021-10-28 | Marshall | Iowa | 19127 | 6476 | 88 |
1856465 | 1856465 | 2021-10-27 | Marshall | Iowa | 19127 | 6476 | 88 |
1853216 | 1853216 | 2021-10-26 | Marshall | Iowa | 19127 | 6422 | 85 |
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);