ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Washington" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177418 | 2177418 | 2022-02-02 | Washington | Wisconsin | 55131 | 36959 | 276 |
2174165 | 2174165 | 2022-02-01 | Washington | Wisconsin | 55131 | 36885 | 275 |
2170913 | 2170913 | 2022-01-31 | Washington | Wisconsin | 55131 | 36751 | 272 |
2167660 | 2167660 | 2022-01-30 | Washington | Wisconsin | 55131 | 36539 | 264 |
2164405 | 2164405 | 2022-01-29 | Washington | Wisconsin | 55131 | 36539 | 264 |
2161150 | 2161150 | 2022-01-28 | Washington | Wisconsin | 55131 | 36539 | 264 |
2157894 | 2157894 | 2022-01-27 | Washington | Wisconsin | 55131 | 36389 | 263 |
2154641 | 2154641 | 2022-01-26 | Washington | Wisconsin | 55131 | 36230 | 263 |
2151388 | 2151388 | 2022-01-25 | Washington | Wisconsin | 55131 | 36056 | 263 |
2148136 | 2148136 | 2022-01-24 | Washington | Wisconsin | 55131 | 35962 | 263 |
2144884 | 2144884 | 2022-01-23 | Washington | Wisconsin | 55131 | 35510 | 263 |
2141629 | 2141629 | 2022-01-22 | Washington | Wisconsin | 55131 | 35510 | 263 |
2138373 | 2138373 | 2022-01-21 | Washington | Wisconsin | 55131 | 35510 | 263 |
2135118 | 2135118 | 2022-01-20 | Washington | Wisconsin | 55131 | 35280 | 263 |
2131866 | 2131866 | 2022-01-19 | Washington | Wisconsin | 55131 | 35066 | 263 |
2128612 | 2128612 | 2022-01-18 | Washington | Wisconsin | 55131 | 34780 | 263 |
2125359 | 2125359 | 2022-01-17 | Washington | Wisconsin | 55131 | 33034 | 263 |
2122107 | 2122107 | 2022-01-16 | Washington | Wisconsin | 55131 | 32205 | 263 |
2118855 | 2118855 | 2022-01-15 | Washington | Wisconsin | 55131 | 32205 | 263 |
2115603 | 2115603 | 2022-01-14 | Washington | Wisconsin | 55131 | 32205 | 263 |
2112351 | 2112351 | 2022-01-13 | Washington | Wisconsin | 55131 | 31329 | 259 |
2109099 | 2109099 | 2022-01-12 | Washington | Wisconsin | 55131 | 31160 | 259 |
2105848 | 2105848 | 2022-01-11 | Washington | Wisconsin | 55131 | 30868 | 259 |
2102597 | 2102597 | 2022-01-10 | Washington | Wisconsin | 55131 | 30672 | 259 |
2099346 | 2099346 | 2022-01-09 | Washington | Wisconsin | 55131 | 30244 | 258 |
2096095 | 2096095 | 2022-01-08 | Washington | Wisconsin | 55131 | 30244 | 258 |
2092843 | 2092843 | 2022-01-07 | Washington | Wisconsin | 55131 | 30244 | 258 |
2089591 | 2089591 | 2022-01-06 | Washington | Wisconsin | 55131 | 30063 | 258 |
2086340 | 2086340 | 2022-01-05 | Washington | Wisconsin | 55131 | 29649 | 258 |
2083088 | 2083088 | 2022-01-04 | Washington | Wisconsin | 55131 | 29306 | 257 |
2079836 | 2079836 | 2022-01-03 | Washington | Wisconsin | 55131 | 29018 | 257 |
2076584 | 2076584 | 2022-01-02 | Washington | Wisconsin | 55131 | 28723 | 257 |
2073333 | 2073333 | 2022-01-01 | Washington | Wisconsin | 55131 | 28723 | 257 |
2070082 | 2070082 | 2021-12-31 | Washington | Wisconsin | 55131 | 28723 | 257 |
2066831 | 2066831 | 2021-12-30 | Washington | Wisconsin | 55131 | 28556 | 257 |
2063581 | 2063581 | 2021-12-29 | Washington | Wisconsin | 55131 | 28374 | 257 |
2060331 | 2060331 | 2021-12-28 | Washington | Wisconsin | 55131 | 28141 | 257 |
2057082 | 2057082 | 2021-12-27 | Washington | Wisconsin | 55131 | 28026 | 257 |
2053833 | 2053833 | 2021-12-26 | Washington | Wisconsin | 55131 | 27838 | 257 |
2050583 | 2050583 | 2021-12-25 | Washington | Wisconsin | 55131 | 27838 | 257 |
2047333 | 2047333 | 2021-12-24 | Washington | Wisconsin | 55131 | 27838 | 257 |
2044083 | 2044083 | 2021-12-23 | Washington | Wisconsin | 55131 | 27707 | 257 |
2040834 | 2040834 | 2021-12-22 | Washington | Wisconsin | 55131 | 27549 | 255 |
2037584 | 2037584 | 2021-12-21 | Washington | Wisconsin | 55131 | 27458 | 255 |
2034334 | 2034334 | 2021-12-20 | Washington | Wisconsin | 55131 | 27348 | 252 |
2031084 | 2031084 | 2021-12-19 | Washington | Wisconsin | 55131 | 27143 | 249 |
2027833 | 2027833 | 2021-12-18 | Washington | Wisconsin | 55131 | 27143 | 249 |
2024582 | 2024582 | 2021-12-17 | Washington | Wisconsin | 55131 | 27143 | 249 |
2021331 | 2021331 | 2021-12-16 | Washington | Wisconsin | 55131 | 27053 | 248 |
2018080 | 2018080 | 2021-12-15 | Washington | Wisconsin | 55131 | 26952 | 247 |
2014830 | 2014830 | 2021-12-14 | Washington | Wisconsin | 55131 | 26826 | 243 |
2011579 | 2011579 | 2021-12-13 | Washington | Wisconsin | 55131 | 26713 | 242 |
2008328 | 2008328 | 2021-12-12 | Washington | Wisconsin | 55131 | 26463 | 242 |
2005077 | 2005077 | 2021-12-11 | Washington | Wisconsin | 55131 | 26463 | 242 |
2001826 | 2001826 | 2021-12-10 | Washington | Wisconsin | 55131 | 26463 | 242 |
1998576 | 1998576 | 2021-12-09 | Washington | Wisconsin | 55131 | 26328 | 237 |
1995325 | 1995325 | 2021-12-08 | Washington | Wisconsin | 55131 | 26206 | 237 |
1992074 | 1992074 | 2021-12-07 | Washington | Wisconsin | 55131 | 25803 | 234 |
1988823 | 1988823 | 2021-12-06 | Washington | Wisconsin | 55131 | 25803 | 234 |
1985573 | 1985573 | 2021-12-05 | Washington | Wisconsin | 55131 | 25803 | 234 |
1982323 | 1982323 | 2021-12-04 | Washington | Wisconsin | 55131 | 25803 | 234 |
1979073 | 1979073 | 2021-12-03 | Washington | Wisconsin | 55131 | 25803 | 234 |
1975823 | 1975823 | 2021-12-02 | Washington | Wisconsin | 55131 | 25713 | 233 |
1972574 | 1972574 | 2021-12-01 | Washington | Wisconsin | 55131 | 25610 | 233 |
1969324 | 1969324 | 2021-11-30 | Washington | Wisconsin | 55131 | 25421 | 232 |
1966074 | 1966074 | 2021-11-29 | Washington | Wisconsin | 55131 | 25280 | 232 |
1962822 | 1962822 | 2021-11-28 | Washington | Wisconsin | 55131 | 25101 | 232 |
1959571 | 1959571 | 2021-11-27 | Washington | Wisconsin | 55131 | 25101 | 232 |
1956320 | 1956320 | 2021-11-26 | Washington | Wisconsin | 55131 | 25101 | 232 |
1953069 | 1953069 | 2021-11-25 | Washington | Wisconsin | 55131 | 25101 | 232 |
1949818 | 1949818 | 2021-11-24 | Washington | Wisconsin | 55131 | 24996 | 232 |
1946567 | 1946567 | 2021-11-23 | Washington | Wisconsin | 55131 | 24841 | 232 |
1943316 | 1943316 | 2021-11-22 | Washington | Wisconsin | 55131 | 24717 | 232 |
1940066 | 1940066 | 2021-11-21 | Washington | Wisconsin | 55131 | 24534 | 232 |
1936816 | 1936816 | 2021-11-20 | Washington | Wisconsin | 55131 | 24534 | 232 |
1933566 | 1933566 | 2021-11-19 | Washington | Wisconsin | 55131 | 24534 | 232 |
1930314 | 1930314 | 2021-11-18 | Washington | Wisconsin | 55131 | 24367 | 232 |
1927064 | 1927064 | 2021-11-17 | Washington | Wisconsin | 55131 | 24301 | 232 |
1923814 | 1923814 | 2021-11-16 | Washington | Wisconsin | 55131 | 24221 | 232 |
1920565 | 1920565 | 2021-11-15 | Washington | Wisconsin | 55131 | 24108 | 232 |
1917315 | 1917315 | 2021-11-14 | Washington | Wisconsin | 55131 | 23822 | 231 |
1914065 | 1914065 | 2021-11-13 | Washington | Wisconsin | 55131 | 23822 | 231 |
1910815 | 1910815 | 2021-11-12 | Washington | Wisconsin | 55131 | 23822 | 231 |
1907566 | 1907566 | 2021-11-11 | Washington | Wisconsin | 55131 | 23735 | 231 |
1904317 | 1904317 | 2021-11-10 | Washington | Wisconsin | 55131 | 23650 | 231 |
1901067 | 1901067 | 2021-11-09 | Washington | Wisconsin | 55131 | 23522 | 228 |
1897817 | 1897817 | 2021-11-08 | Washington | Wisconsin | 55131 | 23425 | 228 |
1894567 | 1894567 | 2021-11-07 | Washington | Wisconsin | 55131 | 23239 | 227 |
1891317 | 1891317 | 2021-11-06 | Washington | Wisconsin | 55131 | 23239 | 227 |
1888067 | 1888067 | 2021-11-05 | Washington | Wisconsin | 55131 | 23239 | 227 |
1884817 | 1884817 | 2021-11-04 | Washington | Wisconsin | 55131 | 23147 | 227 |
1881568 | 1881568 | 2021-11-03 | Washington | Wisconsin | 55131 | 23072 | 226 |
1878319 | 1878319 | 2021-11-02 | Washington | Wisconsin | 55131 | 22975 | 226 |
1875070 | 1875070 | 2021-11-01 | Washington | Wisconsin | 55131 | 22925 | 222 |
1871821 | 1871821 | 2021-10-31 | Washington | Wisconsin | 55131 | 22793 | 222 |
1868572 | 1868572 | 2021-10-30 | Washington | Wisconsin | 55131 | 22793 | 222 |
1865323 | 1865323 | 2021-10-29 | Washington | Wisconsin | 55131 | 22793 | 222 |
1862074 | 1862074 | 2021-10-28 | Washington | Wisconsin | 55131 | 22730 | 222 |
1858825 | 1858825 | 2021-10-27 | Washington | Wisconsin | 55131 | 22673 | 222 |
1855576 | 1855576 | 2021-10-26 | Washington | Wisconsin | 55131 | 22588 | 221 |
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);