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 |
---|---|---|---|---|---|---|---|
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 |
1787344 | 1787344 | 2021-10-05 | Washington | Wisconsin | 55131 | 21100 | 218 |
1784095 | 1784095 | 2021-10-04 | Washington | Wisconsin | 55131 | 20967 | 218 |
1780846 | 1780846 | 2021-10-03 | Washington | Wisconsin | 55131 | 20752 | 217 |
1777596 | 1777596 | 2021-10-02 | Washington | Wisconsin | 55131 | 20752 | 217 |
1774346 | 1774346 | 2021-10-01 | Washington | Wisconsin | 55131 | 20752 | 217 |
1771096 | 1771096 | 2021-09-30 | Washington | Wisconsin | 55131 | 20620 | 217 |
1767847 | 1767847 | 2021-09-29 | Washington | Wisconsin | 55131 | 20524 | 216 |
1764598 | 1764598 | 2021-09-28 | Washington | Wisconsin | 55131 | 20450 | 214 |
1761349 | 1761349 | 2021-09-27 | Washington | Wisconsin | 55131 | 20377 | 214 |
1758101 | 1758101 | 2021-09-26 | Washington | Wisconsin | 55131 | 20141 | 214 |
1754853 | 1754853 | 2021-09-25 | Washington | Wisconsin | 55131 | 20141 | 214 |
1751605 | 1751605 | 2021-09-24 | Washington | Wisconsin | 55131 | 20141 | 214 |
1748356 | 1748356 | 2021-09-23 | Washington | Wisconsin | 55131 | 19996 | 214 |
1745106 | 1745106 | 2021-09-22 | Washington | Wisconsin | 55131 | 19871 | 214 |
1741857 | 1741857 | 2021-09-21 | Washington | Wisconsin | 55131 | 19825 | 214 |
1738608 | 1738608 | 2021-09-20 | Washington | Wisconsin | 55131 | 19768 | 214 |
1735359 | 1735359 | 2021-09-19 | Washington | Wisconsin | 55131 | 19465 | 214 |
1732109 | 1732109 | 2021-09-18 | Washington | Wisconsin | 55131 | 19465 | 214 |
1728859 | 1728859 | 2021-09-17 | Washington | Wisconsin | 55131 | 19465 | 214 |
1725609 | 1725609 | 2021-09-16 | Washington | Wisconsin | 55131 | 19284 | 212 |
1722360 | 1722360 | 2021-09-15 | Washington | Wisconsin | 55131 | 19225 | 212 |
1719112 | 1719112 | 2021-09-14 | Washington | Wisconsin | 55131 | 19129 | 212 |
1715864 | 1715864 | 2021-09-13 | Washington | Wisconsin | 55131 | 19090 | 211 |
1712618 | 1712618 | 2021-09-12 | Washington | Wisconsin | 55131 | 18850 | 211 |
1709371 | 1709371 | 2021-09-11 | Washington | Wisconsin | 55131 | 18850 | 211 |
1706124 | 1706124 | 2021-09-10 | Washington | Wisconsin | 55131 | 18850 | 211 |
1702876 | 1702876 | 2021-09-09 | Washington | Wisconsin | 55131 | 18815 | 211 |
1699626 | 1699626 | 2021-09-08 | Washington | Wisconsin | 55131 | 18782 | 211 |
1696377 | 1696377 | 2021-09-07 | Washington | Wisconsin | 55131 | 18764 | 209 |
1693129 | 1693129 | 2021-09-06 | Washington | Wisconsin | 55131 | 18710 | 209 |
1689880 | 1689880 | 2021-09-05 | Washington | Wisconsin | 55131 | 18643 | 209 |
1686630 | 1686630 | 2021-09-04 | Washington | Wisconsin | 55131 | 18643 | 209 |
1683380 | 1683380 | 2021-09-03 | Washington | Wisconsin | 55131 | 18643 | 209 |
1680129 | 1680129 | 2021-09-02 | Washington | Wisconsin | 55131 | 18568 | 208 |
1676881 | 1676881 | 2021-09-01 | Washington | Wisconsin | 55131 | 18453 | 208 |
1673634 | 1673634 | 2021-08-31 | Washington | Wisconsin | 55131 | 18407 | 207 |
1670386 | 1670386 | 2021-08-30 | Washington | Wisconsin | 55131 | 18342 | 206 |
1667139 | 1667139 | 2021-08-29 | Washington | Wisconsin | 55131 | 18232 | 206 |
1663891 | 1663891 | 2021-08-28 | Washington | Wisconsin | 55131 | 18232 | 206 |
1660643 | 1660643 | 2021-08-27 | Washington | Wisconsin | 55131 | 18232 | 206 |
1657395 | 1657395 | 2021-08-26 | Washington | Wisconsin | 55131 | 18174 | 206 |
1654147 | 1654147 | 2021-08-25 | Washington | Wisconsin | 55131 | 18091 | 206 |
1650901 | 1650901 | 2021-08-24 | Washington | Wisconsin | 55131 | 18005 | 205 |
1647652 | 1647652 | 2021-08-23 | Washington | Wisconsin | 55131 | 17934 | 205 |
1644403 | 1644403 | 2021-08-22 | Washington | Wisconsin | 55131 | 17866 | 205 |
1641153 | 1641153 | 2021-08-21 | Washington | Wisconsin | 55131 | 17866 | 205 |
1637903 | 1637903 | 2021-08-20 | Washington | Wisconsin | 55131 | 17866 | 205 |
1634653 | 1634653 | 2021-08-19 | Washington | Wisconsin | 55131 | 17835 | 204 |
1631405 | 1631405 | 2021-08-18 | Washington | Wisconsin | 55131 | 17766 | 204 |
1628158 | 1628158 | 2021-08-17 | Washington | Wisconsin | 55131 | 17728 | 204 |
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);