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 |
---|---|---|---|---|---|---|---|
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 |
1852327 | 1852327 | 2021-10-25 | Washington | Wisconsin | 55131 | 22536 | 221 |
1849077 | 1849077 | 2021-10-24 | Washington | Wisconsin | 55131 | 22291 | 221 |
1845827 | 1845827 | 2021-10-23 | Washington | Wisconsin | 55131 | 22291 | 221 |
1842577 | 1842577 | 2021-10-22 | Washington | Wisconsin | 55131 | 22291 | 221 |
1839328 | 1839328 | 2021-10-21 | Washington | Wisconsin | 55131 | 22252 | 220 |
1836079 | 1836079 | 2021-10-20 | Washington | Wisconsin | 55131 | 22198 | 220 |
1832830 | 1832830 | 2021-10-19 | Washington | Wisconsin | 55131 | 22137 | 219 |
1829581 | 1829581 | 2021-10-18 | Washington | Wisconsin | 55131 | 22109 | 219 |
1826332 | 1826332 | 2021-10-17 | Washington | Wisconsin | 55131 | 21999 | 219 |
1823083 | 1823083 | 2021-10-16 | Washington | Wisconsin | 55131 | 21806 | 219 |
1819834 | 1819834 | 2021-10-15 | Washington | Wisconsin | 55131 | 21806 | 219 |
1816585 | 1816585 | 2021-10-14 | Washington | Wisconsin | 55131 | 21806 | 219 |
1813337 | 1813337 | 2021-10-13 | Washington | Wisconsin | 55131 | 21726 | 218 |
1810088 | 1810088 | 2021-10-12 | Washington | Wisconsin | 55131 | 21655 | 218 |
1806839 | 1806839 | 2021-10-11 | Washington | Wisconsin | 55131 | 21602 | 218 |
1803588 | 1803588 | 2021-10-10 | Washington | Wisconsin | 55131 | 21327 | 218 |
1800339 | 1800339 | 2021-10-09 | Washington | Wisconsin | 55131 | 21327 | 218 |
1797090 | 1797090 | 2021-10-08 | Washington | Wisconsin | 55131 | 21327 | 218 |
1793841 | 1793841 | 2021-10-07 | Washington | Wisconsin | 55131 | 21260 | 218 |
1790592 | 1790592 | 2021-10-06 | Washington | Wisconsin | 55131 | 21176 | 218 |
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);