ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
213 rows where deaths = 57 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Sauk 29
- St. Croix 21
- Oconto 15
- Door 11
- Juneau 10
- Langlade 10
- Manitowoc 10
- Calumet 9
- Sawyer 8
- Barron 7
- Vilas 7
- Brown 6
- Douglas 6
- Portage 6
- Adams 5
- Marquette 4
- Waushara 4
- Chippewa 3
- Dane 3
- Dodge 3
- Oneida 3
- Trempealeau 3
- Vernon 3
- Waukesha 3
- Clark 2
- Kewaunee 2
- La Crosse 2
- Marathon 2
- Rock 2
- Winnebago 2
- …
state 1
- Wisconsin · 213 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2333455 | 2333455 | 2022-03-22 | Adams | Wisconsin | 55001 | 4621 | 57 |
2330201 | 2330201 | 2022-03-21 | Adams | Wisconsin | 55001 | 4615 | 57 |
2326949 | 2326949 | 2022-03-20 | Adams | Wisconsin | 55001 | 4613 | 57 |
2326987 | 2326987 | 2022-03-20 | Marquette | Wisconsin | 55077 | 3792 | 57 |
2323696 | 2323696 | 2022-03-19 | Adams | Wisconsin | 55001 | 4613 | 57 |
2323734 | 2323734 | 2022-03-19 | Marquette | Wisconsin | 55077 | 3792 | 57 |
2320442 | 2320442 | 2022-03-18 | Adams | Wisconsin | 55001 | 4613 | 57 |
2320480 | 2320480 | 2022-03-18 | Marquette | Wisconsin | 55077 | 3792 | 57 |
2317226 | 2317226 | 2022-03-17 | Marquette | Wisconsin | 55077 | 3789 | 57 |
2310712 | 2310712 | 2022-03-15 | Kewaunee | Wisconsin | 55061 | 5823 | 57 |
2307459 | 2307459 | 2022-03-14 | Kewaunee | Wisconsin | 55061 | 5823 | 57 |
2242450 | 2242450 | 2022-02-22 | Sawyer | Wisconsin | 55113 | 4487 | 57 |
2239199 | 2239199 | 2022-02-21 | Sawyer | Wisconsin | 55113 | 4487 | 57 |
2235906 | 2235906 | 2022-02-20 | Door | Wisconsin | 55029 | 6889 | 57 |
2235948 | 2235948 | 2022-02-20 | Sawyer | Wisconsin | 55113 | 4482 | 57 |
2232655 | 2232655 | 2022-02-19 | Door | Wisconsin | 55029 | 6889 | 57 |
2232697 | 2232697 | 2022-02-19 | Sawyer | Wisconsin | 55113 | 4482 | 57 |
2229404 | 2229404 | 2022-02-18 | Door | Wisconsin | 55029 | 6889 | 57 |
2229446 | 2229446 | 2022-02-18 | Sawyer | Wisconsin | 55113 | 4482 | 57 |
2226153 | 2226153 | 2022-02-17 | Door | Wisconsin | 55029 | 6883 | 57 |
2226195 | 2226195 | 2022-02-17 | Sawyer | Wisconsin | 55113 | 4478 | 57 |
2222902 | 2222902 | 2022-02-16 | Door | Wisconsin | 55029 | 6877 | 57 |
2222944 | 2222944 | 2022-02-16 | Sawyer | Wisconsin | 55113 | 4476 | 57 |
2219651 | 2219651 | 2022-02-15 | Door | Wisconsin | 55029 | 6874 | 57 |
2219693 | 2219693 | 2022-02-15 | Sawyer | Wisconsin | 55113 | 4470 | 57 |
2216401 | 2216401 | 2022-02-14 | Door | Wisconsin | 55029 | 6869 | 57 |
2213150 | 2213150 | 2022-02-13 | Door | Wisconsin | 55029 | 6854 | 57 |
2209897 | 2209897 | 2022-02-12 | Door | Wisconsin | 55029 | 6854 | 57 |
2206644 | 2206644 | 2022-02-11 | Door | Wisconsin | 55029 | 6854 | 57 |
2203391 | 2203391 | 2022-02-10 | Door | Wisconsin | 55029 | 6843 | 57 |
2180626 | 2180626 | 2022-02-03 | Green Lake | Wisconsin | 55047 | 4876 | 57 |
2157856 | 2157856 | 2022-01-27 | Juneau | Wisconsin | 55057 | 7257 | 57 |
2154603 | 2154603 | 2022-01-26 | Juneau | Wisconsin | 55057 | 7184 | 57 |
2151350 | 2151350 | 2022-01-25 | Juneau | Wisconsin | 55057 | 7148 | 57 |
2148098 | 2148098 | 2022-01-24 | Juneau | Wisconsin | 55057 | 7120 | 57 |
2144846 | 2144846 | 2022-01-23 | Juneau | Wisconsin | 55057 | 7004 | 57 |
2141591 | 2141591 | 2022-01-22 | Juneau | Wisconsin | 55057 | 7004 | 57 |
2138335 | 2138335 | 2022-01-21 | Juneau | Wisconsin | 55057 | 7004 | 57 |
2135080 | 2135080 | 2022-01-20 | Juneau | Wisconsin | 55057 | 6937 | 57 |
2135113 | 2135113 | 2022-01-20 | Trempealeau | Wisconsin | 55121 | 7513 | 57 |
2131828 | 2131828 | 2022-01-19 | Juneau | Wisconsin | 55057 | 6881 | 57 |
2131861 | 2131861 | 2022-01-19 | Trempealeau | Wisconsin | 55121 | 7415 | 57 |
2128574 | 2128574 | 2022-01-18 | Juneau | Wisconsin | 55057 | 6800 | 57 |
2128607 | 2128607 | 2022-01-18 | Trempealeau | Wisconsin | 55121 | 7290 | 57 |
2037534 | 2037534 | 2021-12-21 | Dunn | Wisconsin | 55033 | 9285 | 57 |
2014811 | 2014811 | 2021-12-14 | Pierce | Wisconsin | 55093 | 8051 | 57 |
1966077 | 1966077 | 2021-11-29 | Waushara | Wisconsin | 55137 | 4050 | 57 |
1962825 | 1962825 | 2021-11-28 | Waushara | Wisconsin | 55137 | 4048 | 57 |
1959574 | 1959574 | 2021-11-27 | Waushara | Wisconsin | 55137 | 4048 | 57 |
1956323 | 1956323 | 2021-11-26 | Waushara | Wisconsin | 55137 | 4048 | 57 |
1946542 | 1946542 | 2021-11-23 | Monroe | Wisconsin | 55081 | 7303 | 57 |
1917282 | 1917282 | 2021-11-14 | Langlade | Wisconsin | 55067 | 3364 | 57 |
1914032 | 1914032 | 2021-11-13 | Langlade | Wisconsin | 55067 | 3364 | 57 |
1910782 | 1910782 | 2021-11-12 | Langlade | Wisconsin | 55067 | 3364 | 57 |
1907533 | 1907533 | 2021-11-11 | Langlade | Wisconsin | 55067 | 3360 | 57 |
1904284 | 1904284 | 2021-11-10 | Langlade | Wisconsin | 55067 | 3336 | 57 |
1901034 | 1901034 | 2021-11-09 | Langlade | Wisconsin | 55067 | 3322 | 57 |
1901064 | 1901064 | 2021-11-09 | Vilas | Wisconsin | 55125 | 3204 | 57 |
1897784 | 1897784 | 2021-11-08 | Langlade | Wisconsin | 55067 | 3309 | 57 |
1897814 | 1897814 | 2021-11-08 | Vilas | Wisconsin | 55125 | 3194 | 57 |
1894534 | 1894534 | 2021-11-07 | Langlade | Wisconsin | 55067 | 3271 | 57 |
1894564 | 1894564 | 2021-11-07 | Vilas | Wisconsin | 55125 | 3179 | 57 |
1891284 | 1891284 | 2021-11-06 | Langlade | Wisconsin | 55067 | 3271 | 57 |
1891314 | 1891314 | 2021-11-06 | Vilas | Wisconsin | 55125 | 3179 | 57 |
1888034 | 1888034 | 2021-11-05 | Langlade | Wisconsin | 55067 | 3271 | 57 |
1888064 | 1888064 | 2021-11-05 | Vilas | Wisconsin | 55125 | 3179 | 57 |
1884814 | 1884814 | 2021-11-04 | Vilas | Wisconsin | 55125 | 3172 | 57 |
1881565 | 1881565 | 2021-11-03 | Vilas | Wisconsin | 55125 | 3157 | 57 |
1849073 | 1849073 | 2021-10-24 | Vernon | Wisconsin | 55123 | 2873 | 57 |
1845823 | 1845823 | 2021-10-23 | Vernon | Wisconsin | 55123 | 2873 | 57 |
1842573 | 1842573 | 2021-10-22 | Vernon | Wisconsin | 55123 | 2873 | 57 |
1722301 | 1722301 | 2021-09-15 | Calumet | Wisconsin | 55015 | 7292 | 57 |
1719053 | 1719053 | 2021-09-14 | Calumet | Wisconsin | 55015 | 7269 | 57 |
1715805 | 1715805 | 2021-09-13 | Calumet | Wisconsin | 55015 | 7237 | 57 |
1712559 | 1712559 | 2021-09-12 | Calumet | Wisconsin | 55015 | 7219 | 57 |
1709312 | 1709312 | 2021-09-11 | Calumet | Wisconsin | 55015 | 7219 | 57 |
1706065 | 1706065 | 2021-09-10 | Calumet | Wisconsin | 55015 | 7219 | 57 |
1702816 | 1702816 | 2021-09-09 | Calumet | Wisconsin | 55015 | 7191 | 57 |
1699566 | 1699566 | 2021-09-08 | Calumet | Wisconsin | 55015 | 7174 | 57 |
1696318 | 1696318 | 2021-09-07 | Calumet | Wisconsin | 55015 | 7156 | 57 |
1556683 | 1556683 | 2021-07-26 | Sauk | Wisconsin | 55111 | 6331 | 57 |
1553436 | 1553436 | 2021-07-25 | Sauk | Wisconsin | 55111 | 6324 | 57 |
1550189 | 1550189 | 2021-07-24 | Sauk | Wisconsin | 55111 | 6324 | 57 |
1546942 | 1546942 | 2021-07-23 | Sauk | Wisconsin | 55111 | 6324 | 57 |
1543695 | 1543695 | 2021-07-22 | Sauk | Wisconsin | 55111 | 6316 | 57 |
1540447 | 1540447 | 2021-07-21 | Sauk | Wisconsin | 55111 | 6311 | 57 |
1537200 | 1537200 | 2021-07-20 | Sauk | Wisconsin | 55111 | 6305 | 57 |
1533952 | 1533952 | 2021-07-19 | Sauk | Wisconsin | 55111 | 6301 | 57 |
1530705 | 1530705 | 2021-07-18 | Sauk | Wisconsin | 55111 | 6293 | 57 |
1527458 | 1527458 | 2021-07-17 | Sauk | Wisconsin | 55111 | 6293 | 57 |
1524211 | 1524211 | 2021-07-16 | Sauk | Wisconsin | 55111 | 6293 | 57 |
1520963 | 1520963 | 2021-07-15 | Sauk | Wisconsin | 55111 | 6290 | 57 |
1517715 | 1517715 | 2021-07-14 | Sauk | Wisconsin | 55111 | 6286 | 57 |
1514468 | 1514468 | 2021-07-13 | Sauk | Wisconsin | 55111 | 6283 | 57 |
1511222 | 1511222 | 2021-07-12 | Sauk | Wisconsin | 55111 | 6279 | 57 |
1507975 | 1507975 | 2021-07-11 | Sauk | Wisconsin | 55111 | 6268 | 57 |
1504729 | 1504729 | 2021-07-10 | Sauk | Wisconsin | 55111 | 6268 | 57 |
1501483 | 1501483 | 2021-07-09 | Sauk | Wisconsin | 55111 | 6268 | 57 |
1498237 | 1498237 | 2021-07-08 | Sauk | Wisconsin | 55111 | 6263 | 57 |
1494990 | 1494990 | 2021-07-07 | Sauk | Wisconsin | 55111 | 6260 | 57 |
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);