ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
594 rows where deaths = 8 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Lafayette 75
- Price 68
- Buffalo 58
- Clark 58
- Outagamie 34
- Unknown 29
- Jefferson 20
- Sheboygan 20
- Menominee 19
- Monroe 13
- St. Croix 13
- Sawyer 12
- Pierce 11
- Walworth 11
- Florence 10
- Fond du Lac 10
- Juneau 10
- Marinette 8
- Pepin 7
- Eau Claire 6
- Richland 6
- Shawano 6
- Adams 5
- Ashland 5
- Dodge 5
- Iowa 5
- Sauk 5
- Vilas 5
- Columbia 4
- Dunn 4
- …
state 1
- Wisconsin · 594 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1998515 | 1998515 | 2021-12-09 | Buffalo | Wisconsin | 55011 | 2336 | 8 |
1995264 | 1995264 | 2021-12-08 | Buffalo | Wisconsin | 55011 | 2325 | 8 |
1992013 | 1992013 | 2021-12-07 | Buffalo | Wisconsin | 55011 | 2307 | 8 |
1988762 | 1988762 | 2021-12-06 | Buffalo | Wisconsin | 55011 | 2307 | 8 |
1985512 | 1985512 | 2021-12-05 | Buffalo | Wisconsin | 55011 | 2307 | 8 |
1982262 | 1982262 | 2021-12-04 | Buffalo | Wisconsin | 55011 | 2307 | 8 |
1979012 | 1979012 | 2021-12-03 | Buffalo | Wisconsin | 55011 | 2307 | 8 |
1975762 | 1975762 | 2021-12-02 | Buffalo | Wisconsin | 55011 | 2295 | 8 |
1972513 | 1972513 | 2021-12-01 | Buffalo | Wisconsin | 55011 | 2285 | 8 |
1969263 | 1969263 | 2021-11-30 | Buffalo | Wisconsin | 55011 | 2271 | 8 |
1966013 | 1966013 | 2021-11-29 | Buffalo | Wisconsin | 55011 | 2258 | 8 |
1962761 | 1962761 | 2021-11-28 | Buffalo | Wisconsin | 55011 | 2256 | 8 |
1959510 | 1959510 | 2021-11-27 | Buffalo | Wisconsin | 55011 | 2256 | 8 |
1956259 | 1956259 | 2021-11-26 | Buffalo | Wisconsin | 55011 | 2256 | 8 |
1953008 | 1953008 | 2021-11-25 | Buffalo | Wisconsin | 55011 | 2253 | 8 |
1949757 | 1949757 | 2021-11-24 | Buffalo | Wisconsin | 55011 | 2249 | 8 |
1946506 | 1946506 | 2021-11-23 | Buffalo | Wisconsin | 55011 | 2236 | 8 |
1943255 | 1943255 | 2021-11-22 | Buffalo | Wisconsin | 55011 | 2231 | 8 |
1940005 | 1940005 | 2021-11-21 | Buffalo | Wisconsin | 55011 | 2205 | 8 |
1936755 | 1936755 | 2021-11-20 | Buffalo | Wisconsin | 55011 | 2205 | 8 |
1933505 | 1933505 | 2021-11-19 | Buffalo | Wisconsin | 55011 | 2205 | 8 |
1930253 | 1930253 | 2021-11-18 | Buffalo | Wisconsin | 55011 | 2190 | 8 |
1927003 | 1927003 | 2021-11-17 | Buffalo | Wisconsin | 55011 | 2183 | 8 |
1923753 | 1923753 | 2021-11-16 | Buffalo | Wisconsin | 55011 | 2170 | 8 |
1920504 | 1920504 | 2021-11-15 | Buffalo | Wisconsin | 55011 | 2159 | 8 |
1917254 | 1917254 | 2021-11-14 | Buffalo | Wisconsin | 55011 | 2136 | 8 |
1914004 | 1914004 | 2021-11-13 | Buffalo | Wisconsin | 55011 | 2136 | 8 |
1910754 | 1910754 | 2021-11-12 | Buffalo | Wisconsin | 55011 | 2136 | 8 |
1907505 | 1907505 | 2021-11-11 | Buffalo | Wisconsin | 55011 | 2124 | 8 |
1904256 | 1904256 | 2021-11-10 | Buffalo | Wisconsin | 55011 | 2118 | 8 |
1901006 | 1901006 | 2021-11-09 | Buffalo | Wisconsin | 55011 | 2102 | 8 |
1897756 | 1897756 | 2021-11-08 | Buffalo | Wisconsin | 55011 | 2093 | 8 |
1894506 | 1894506 | 2021-11-07 | Buffalo | Wisconsin | 55011 | 2069 | 8 |
1891256 | 1891256 | 2021-11-06 | Buffalo | Wisconsin | 55011 | 2069 | 8 |
1888006 | 1888006 | 2021-11-05 | Buffalo | Wisconsin | 55011 | 2069 | 8 |
1884756 | 1884756 | 2021-11-04 | Buffalo | Wisconsin | 55011 | 2057 | 8 |
1881507 | 1881507 | 2021-11-03 | Buffalo | Wisconsin | 55011 | 2050 | 8 |
1878258 | 1878258 | 2021-11-02 | Buffalo | Wisconsin | 55011 | 2037 | 8 |
1875009 | 1875009 | 2021-11-01 | Buffalo | Wisconsin | 55011 | 2030 | 8 |
1871760 | 1871760 | 2021-10-31 | Buffalo | Wisconsin | 55011 | 2007 | 8 |
1868511 | 1868511 | 2021-10-30 | Buffalo | Wisconsin | 55011 | 2007 | 8 |
1865262 | 1865262 | 2021-10-29 | Buffalo | Wisconsin | 55011 | 2007 | 8 |
1862013 | 1862013 | 2021-10-28 | Buffalo | Wisconsin | 55011 | 1995 | 8 |
1858764 | 1858764 | 2021-10-27 | Buffalo | Wisconsin | 55011 | 1986 | 8 |
1855515 | 1855515 | 2021-10-26 | Buffalo | Wisconsin | 55011 | 1979 | 8 |
1852266 | 1852266 | 2021-10-25 | Buffalo | Wisconsin | 55011 | 1972 | 8 |
1849016 | 1849016 | 2021-10-24 | Buffalo | Wisconsin | 55011 | 1952 | 8 |
1845766 | 1845766 | 2021-10-23 | Buffalo | Wisconsin | 55011 | 1952 | 8 |
1842516 | 1842516 | 2021-10-22 | Buffalo | Wisconsin | 55011 | 1952 | 8 |
1839267 | 1839267 | 2021-10-21 | Buffalo | Wisconsin | 55011 | 1944 | 8 |
1836018 | 1836018 | 2021-10-20 | Buffalo | Wisconsin | 55011 | 1938 | 8 |
1832769 | 1832769 | 2021-10-19 | Buffalo | Wisconsin | 55011 | 1932 | 8 |
1829520 | 1829520 | 2021-10-18 | Buffalo | Wisconsin | 55011 | 1925 | 8 |
1826271 | 1826271 | 2021-10-17 | Buffalo | Wisconsin | 55011 | 1914 | 8 |
1823022 | 1823022 | 2021-10-16 | Buffalo | Wisconsin | 55011 | 1887 | 8 |
1819773 | 1819773 | 2021-10-15 | Buffalo | Wisconsin | 55011 | 1887 | 8 |
1816524 | 1816524 | 2021-10-14 | Buffalo | Wisconsin | 55011 | 1887 | 8 |
1813276 | 1813276 | 2021-10-13 | Buffalo | Wisconsin | 55011 | 1875 | 8 |
1784075 | 1784075 | 2021-10-04 | Pepin | Wisconsin | 55091 | 1108 | 8 |
1780826 | 1780826 | 2021-10-03 | Pepin | Wisconsin | 55091 | 1100 | 8 |
1780830 | 1780830 | 2021-10-03 | Price | Wisconsin | 55099 | 1617 | 8 |
1777576 | 1777576 | 2021-10-02 | Pepin | Wisconsin | 55091 | 1100 | 8 |
1777580 | 1777580 | 2021-10-02 | Price | Wisconsin | 55099 | 1617 | 8 |
1774326 | 1774326 | 2021-10-01 | Pepin | Wisconsin | 55091 | 1100 | 8 |
1774330 | 1774330 | 2021-10-01 | Price | Wisconsin | 55099 | 1617 | 8 |
1771076 | 1771076 | 2021-09-30 | Pepin | Wisconsin | 55091 | 1087 | 8 |
1771080 | 1771080 | 2021-09-30 | Price | Wisconsin | 55099 | 1607 | 8 |
1767827 | 1767827 | 2021-09-29 | Pepin | Wisconsin | 55091 | 1083 | 8 |
1767831 | 1767831 | 2021-09-29 | Price | Wisconsin | 55099 | 1595 | 8 |
1764578 | 1764578 | 2021-09-28 | Pepin | Wisconsin | 55091 | 1078 | 8 |
1764582 | 1764582 | 2021-09-28 | Price | Wisconsin | 55099 | 1588 | 8 |
1761333 | 1761333 | 2021-09-27 | Price | Wisconsin | 55099 | 1585 | 8 |
1758085 | 1758085 | 2021-09-26 | Price | Wisconsin | 55099 | 1567 | 8 |
1754837 | 1754837 | 2021-09-25 | Price | Wisconsin | 55099 | 1567 | 8 |
1751589 | 1751589 | 2021-09-24 | Price | Wisconsin | 55099 | 1567 | 8 |
1748340 | 1748340 | 2021-09-23 | Price | Wisconsin | 55099 | 1563 | 8 |
1745090 | 1745090 | 2021-09-22 | Price | Wisconsin | 55099 | 1557 | 8 |
1741841 | 1741841 | 2021-09-21 | Price | Wisconsin | 55099 | 1551 | 8 |
1738592 | 1738592 | 2021-09-20 | Price | Wisconsin | 55099 | 1548 | 8 |
1735343 | 1735343 | 2021-09-19 | Price | Wisconsin | 55099 | 1523 | 8 |
1732093 | 1732093 | 2021-09-18 | Price | Wisconsin | 55099 | 1523 | 8 |
1728843 | 1728843 | 2021-09-17 | Price | Wisconsin | 55099 | 1523 | 8 |
1725593 | 1725593 | 2021-09-16 | Price | Wisconsin | 55099 | 1515 | 8 |
1722344 | 1722344 | 2021-09-15 | Price | Wisconsin | 55099 | 1501 | 8 |
1719096 | 1719096 | 2021-09-14 | Price | Wisconsin | 55099 | 1492 | 8 |
1715848 | 1715848 | 2021-09-13 | Price | Wisconsin | 55099 | 1488 | 8 |
1712602 | 1712602 | 2021-09-12 | Price | Wisconsin | 55099 | 1472 | 8 |
1709355 | 1709355 | 2021-09-11 | Price | Wisconsin | 55099 | 1472 | 8 |
1706108 | 1706108 | 2021-09-10 | Price | Wisconsin | 55099 | 1472 | 8 |
1702859 | 1702859 | 2021-09-09 | Price | Wisconsin | 55099 | 1463 | 8 |
1699609 | 1699609 | 2021-09-08 | Price | Wisconsin | 55099 | 1457 | 8 |
1696361 | 1696361 | 2021-09-07 | Price | Wisconsin | 55099 | 1453 | 8 |
1693113 | 1693113 | 2021-09-06 | Price | Wisconsin | 55099 | 1453 | 8 |
1689864 | 1689864 | 2021-09-05 | Price | Wisconsin | 55099 | 1439 | 8 |
1686614 | 1686614 | 2021-09-04 | Price | Wisconsin | 55099 | 1439 | 8 |
1683364 | 1683364 | 2021-09-03 | Price | Wisconsin | 55099 | 1439 | 8 |
1680113 | 1680113 | 2021-09-02 | Price | Wisconsin | 55099 | 1434 | 8 |
1676865 | 1676865 | 2021-09-01 | Price | Wisconsin | 55099 | 1433 | 8 |
1673618 | 1673618 | 2021-08-31 | Price | Wisconsin | 55099 | 1424 | 8 |
1670370 | 1670370 | 2021-08-30 | Price | Wisconsin | 55099 | 1423 | 8 |
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);