ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
410 rows where deaths = 20 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Washburn 96
- Bayfield 43
- Adams 32
- Juneau 31
- Rusk 25
- Waupaca 13
- Sheboygan 12
- Iowa 11
- Jackson 10
- Green Lake 8
- Dunn 7
- Door 6
- Monroe 6
- Ozaukee 6
- St. Croix 6
- Washington 6
- Clark 5
- Crawford 5
- Marquette 5
- Polk 5
- Waukesha 5
- Columbia 4
- Dane 4
- Iron 4
- La Crosse 4
- Marinette 4
- Pierce 4
- Portage 4
- Sawyer 4
- Waushara 4
- …
state 1
- Wisconsin · 410 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2180635 | 2180635 | 2022-02-03 | Lafayette | Wisconsin | 55065 | 3487 | 20 |
2177384 | 2177384 | 2022-02-02 | Lafayette | Wisconsin | 55065 | 3474 | 20 |
2174131 | 2174131 | 2022-02-01 | Lafayette | Wisconsin | 55065 | 3464 | 20 |
2031042 | 2031042 | 2021-12-19 | Iowa | Wisconsin | 55049 | 3348 | 20 |
2027791 | 2027791 | 2021-12-18 | Iowa | Wisconsin | 55049 | 3348 | 20 |
2024540 | 2024540 | 2021-12-17 | Iowa | Wisconsin | 55049 | 3348 | 20 |
2021289 | 2021289 | 2021-12-16 | Iowa | Wisconsin | 55049 | 3332 | 20 |
2018038 | 2018038 | 2021-12-15 | Iowa | Wisconsin | 55049 | 3317 | 20 |
2014788 | 2014788 | 2021-12-14 | Iowa | Wisconsin | 55049 | 3297 | 20 |
2011537 | 2011537 | 2021-12-13 | Iowa | Wisconsin | 55049 | 3281 | 20 |
2008286 | 2008286 | 2021-12-12 | Iowa | Wisconsin | 55049 | 3252 | 20 |
2005035 | 2005035 | 2021-12-11 | Iowa | Wisconsin | 55049 | 3252 | 20 |
2001784 | 2001784 | 2021-12-10 | Iowa | Wisconsin | 55049 | 3252 | 20 |
1998534 | 1998534 | 2021-12-09 | Iowa | Wisconsin | 55049 | 3229 | 20 |
1670331 | 1670331 | 2021-08-30 | Crawford | Wisconsin | 55023 | 1877 | 20 |
1667084 | 1667084 | 2021-08-29 | Crawford | Wisconsin | 55023 | 1874 | 20 |
1663836 | 1663836 | 2021-08-28 | Crawford | Wisconsin | 55023 | 1874 | 20 |
1660588 | 1660588 | 2021-08-27 | Crawford | Wisconsin | 55023 | 1874 | 20 |
1657340 | 1657340 | 2021-08-26 | Crawford | Wisconsin | 55023 | 1872 | 20 |
1553381 | 1553381 | 2021-07-25 | Adams | Wisconsin | 55001 | 1985 | 20 |
1550134 | 1550134 | 2021-07-24 | Adams | Wisconsin | 55001 | 1985 | 20 |
1546887 | 1546887 | 2021-07-23 | Adams | Wisconsin | 55001 | 1985 | 20 |
1543640 | 1543640 | 2021-07-22 | Adams | Wisconsin | 55001 | 1984 | 20 |
1540392 | 1540392 | 2021-07-21 | Adams | Wisconsin | 55001 | 1981 | 20 |
1537145 | 1537145 | 2021-07-20 | Adams | Wisconsin | 55001 | 1971 | 20 |
1533897 | 1533897 | 2021-07-19 | Adams | Wisconsin | 55001 | 1970 | 20 |
1530650 | 1530650 | 2021-07-18 | Adams | Wisconsin | 55001 | 1970 | 20 |
1527403 | 1527403 | 2021-07-17 | Adams | Wisconsin | 55001 | 1970 | 20 |
1524156 | 1524156 | 2021-07-16 | Adams | Wisconsin | 55001 | 1970 | 20 |
1520908 | 1520908 | 2021-07-15 | Adams | Wisconsin | 55001 | 1970 | 20 |
1520911 | 1520911 | 2021-07-15 | Bayfield | Wisconsin | 55007 | 1291 | 20 |
1517660 | 1517660 | 2021-07-14 | Adams | Wisconsin | 55001 | 1970 | 20 |
1517663 | 1517663 | 2021-07-14 | Bayfield | Wisconsin | 55007 | 1292 | 20 |
1514413 | 1514413 | 2021-07-13 | Adams | Wisconsin | 55001 | 1970 | 20 |
1514416 | 1514416 | 2021-07-13 | Bayfield | Wisconsin | 55007 | 1291 | 20 |
1511167 | 1511167 | 2021-07-12 | Adams | Wisconsin | 55001 | 1970 | 20 |
1511170 | 1511170 | 2021-07-12 | Bayfield | Wisconsin | 55007 | 1290 | 20 |
1507920 | 1507920 | 2021-07-11 | Adams | Wisconsin | 55001 | 1970 | 20 |
1507923 | 1507923 | 2021-07-11 | Bayfield | Wisconsin | 55007 | 1290 | 20 |
1504674 | 1504674 | 2021-07-10 | Adams | Wisconsin | 55001 | 1970 | 20 |
1504677 | 1504677 | 2021-07-10 | Bayfield | Wisconsin | 55007 | 1290 | 20 |
1501428 | 1501428 | 2021-07-09 | Adams | Wisconsin | 55001 | 1970 | 20 |
1501431 | 1501431 | 2021-07-09 | Bayfield | Wisconsin | 55007 | 1290 | 20 |
1498182 | 1498182 | 2021-07-08 | Adams | Wisconsin | 55001 | 1970 | 20 |
1498185 | 1498185 | 2021-07-08 | Bayfield | Wisconsin | 55007 | 1289 | 20 |
1494935 | 1494935 | 2021-07-07 | Adams | Wisconsin | 55001 | 1970 | 20 |
1494938 | 1494938 | 2021-07-07 | Bayfield | Wisconsin | 55007 | 1290 | 20 |
1491688 | 1491688 | 2021-07-06 | Adams | Wisconsin | 55001 | 1970 | 20 |
1491691 | 1491691 | 2021-07-06 | Bayfield | Wisconsin | 55007 | 1290 | 20 |
1488441 | 1488441 | 2021-07-05 | Adams | Wisconsin | 55001 | 1969 | 20 |
1488444 | 1488444 | 2021-07-05 | Bayfield | Wisconsin | 55007 | 1290 | 20 |
1485194 | 1485194 | 2021-07-04 | Adams | Wisconsin | 55001 | 1969 | 20 |
1485197 | 1485197 | 2021-07-04 | Bayfield | Wisconsin | 55007 | 1290 | 20 |
1481948 | 1481948 | 2021-07-03 | Adams | Wisconsin | 55001 | 1969 | 20 |
1481951 | 1481951 | 2021-07-03 | Bayfield | Wisconsin | 55007 | 1290 | 20 |
1478701 | 1478701 | 2021-07-02 | Adams | Wisconsin | 55001 | 1969 | 20 |
1478704 | 1478704 | 2021-07-02 | Bayfield | Wisconsin | 55007 | 1290 | 20 |
1475455 | 1475455 | 2021-07-01 | Adams | Wisconsin | 55001 | 1968 | 20 |
1475458 | 1475458 | 2021-07-01 | Bayfield | Wisconsin | 55007 | 1291 | 20 |
1472209 | 1472209 | 2021-06-30 | Adams | Wisconsin | 55001 | 1969 | 20 |
1472212 | 1472212 | 2021-06-30 | Bayfield | Wisconsin | 55007 | 1291 | 20 |
1468964 | 1468964 | 2021-06-29 | Adams | Wisconsin | 55001 | 1968 | 20 |
1468967 | 1468967 | 2021-06-29 | Bayfield | Wisconsin | 55007 | 1291 | 20 |
1465719 | 1465719 | 2021-06-28 | Adams | Wisconsin | 55001 | 1967 | 20 |
1465722 | 1465722 | 2021-06-28 | Bayfield | Wisconsin | 55007 | 1290 | 20 |
1465773 | 1465773 | 2021-06-28 | Rusk | Wisconsin | 55107 | 1461 | 20 |
1462474 | 1462474 | 2021-06-27 | Adams | Wisconsin | 55001 | 1967 | 20 |
1462477 | 1462477 | 2021-06-27 | Bayfield | Wisconsin | 55007 | 1291 | 20 |
1462528 | 1462528 | 2021-06-27 | Rusk | Wisconsin | 55107 | 1460 | 20 |
1459229 | 1459229 | 2021-06-26 | Adams | Wisconsin | 55001 | 1967 | 20 |
1459232 | 1459232 | 2021-06-26 | Bayfield | Wisconsin | 55007 | 1291 | 20 |
1459283 | 1459283 | 2021-06-26 | Rusk | Wisconsin | 55107 | 1460 | 20 |
1455984 | 1455984 | 2021-06-25 | Adams | Wisconsin | 55001 | 1967 | 20 |
1455987 | 1455987 | 2021-06-25 | Bayfield | Wisconsin | 55007 | 1291 | 20 |
1456038 | 1456038 | 2021-06-25 | Rusk | Wisconsin | 55107 | 1460 | 20 |
1452739 | 1452739 | 2021-06-24 | Adams | Wisconsin | 55001 | 1967 | 20 |
1452742 | 1452742 | 2021-06-24 | Bayfield | Wisconsin | 55007 | 1298 | 20 |
1452793 | 1452793 | 2021-06-24 | Rusk | Wisconsin | 55107 | 1459 | 20 |
1449496 | 1449496 | 2021-06-23 | Bayfield | Wisconsin | 55007 | 1297 | 20 |
1449547 | 1449547 | 2021-06-23 | Rusk | Wisconsin | 55107 | 1458 | 20 |
1446251 | 1446251 | 2021-06-22 | Bayfield | Wisconsin | 55007 | 1296 | 20 |
1446302 | 1446302 | 2021-06-22 | Rusk | Wisconsin | 55107 | 1456 | 20 |
1443006 | 1443006 | 2021-06-21 | Bayfield | Wisconsin | 55007 | 1295 | 20 |
1443057 | 1443057 | 2021-06-21 | Rusk | Wisconsin | 55107 | 1455 | 20 |
1439761 | 1439761 | 2021-06-20 | Bayfield | Wisconsin | 55007 | 1295 | 20 |
1439812 | 1439812 | 2021-06-20 | Rusk | Wisconsin | 55107 | 1454 | 20 |
1436514 | 1436514 | 2021-06-19 | Bayfield | Wisconsin | 55007 | 1295 | 20 |
1436565 | 1436565 | 2021-06-19 | Rusk | Wisconsin | 55107 | 1454 | 20 |
1433267 | 1433267 | 2021-06-18 | Bayfield | Wisconsin | 55007 | 1295 | 20 |
1433318 | 1433318 | 2021-06-18 | Rusk | Wisconsin | 55107 | 1454 | 20 |
1430021 | 1430021 | 2021-06-17 | Bayfield | Wisconsin | 55007 | 1295 | 20 |
1430072 | 1430072 | 2021-06-17 | Rusk | Wisconsin | 55107 | 1452 | 20 |
1426776 | 1426776 | 2021-06-16 | Bayfield | Wisconsin | 55007 | 1292 | 20 |
1426827 | 1426827 | 2021-06-16 | Rusk | Wisconsin | 55107 | 1452 | 20 |
1423530 | 1423530 | 2021-06-15 | Bayfield | Wisconsin | 55007 | 1291 | 20 |
1423581 | 1423581 | 2021-06-15 | Rusk | Wisconsin | 55107 | 1452 | 20 |
1420283 | 1420283 | 2021-06-14 | Bayfield | Wisconsin | 55007 | 1292 | 20 |
1420334 | 1420334 | 2021-06-14 | Rusk | Wisconsin | 55107 | 1451 | 20 |
1417038 | 1417038 | 2021-06-13 | Bayfield | Wisconsin | 55007 | 1293 | 20 |
1417089 | 1417089 | 2021-06-13 | Rusk | Wisconsin | 55107 | 1449 | 20 |
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);