ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
86 rows where deaths = 161 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 15
county 15
- Waupaca 37
- Eau Claire 8
- Fond du Lac 7
- Portage 5
- Jefferson 4
- Outagamie 4
- Walworth 4
- La Crosse 3
- Rock 3
- Sheboygan 3
- Winnebago 3
- Dodge 2
- Chippewa 1
- Washington 1
- Wood 1
state 1
- Wisconsin · 86 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502787 | 2502787 | 2022-05-13 | Portage | Wisconsin | 55097 | 18469 | 161 |
2499529 | 2499529 | 2022-05-12 | Portage | Wisconsin | 55097 | 18449 | 161 |
2496271 | 2496271 | 2022-05-11 | Portage | Wisconsin | 55097 | 18415 | 161 |
2493013 | 2493013 | 2022-05-10 | Portage | Wisconsin | 55097 | 18400 | 161 |
2489755 | 2489755 | 2022-05-09 | Portage | Wisconsin | 55097 | 18381 | 161 |
2213167 | 2213167 | 2022-02-13 | La Crosse | Wisconsin | 55063 | 33563 | 161 |
2209914 | 2209914 | 2022-02-12 | La Crosse | Wisconsin | 55063 | 33563 | 161 |
2206661 | 2206661 | 2022-02-11 | La Crosse | Wisconsin | 55063 | 33563 | 161 |
2170855 | 2170855 | 2022-01-31 | Chippewa | Wisconsin | 55017 | 17776 | 161 |
2060282 | 2060282 | 2021-12-28 | Eau Claire | Wisconsin | 55035 | 20542 | 161 |
2057033 | 2057033 | 2021-12-27 | Eau Claire | Wisconsin | 55035 | 20406 | 161 |
2053784 | 2053784 | 2021-12-26 | Eau Claire | Wisconsin | 55035 | 20328 | 161 |
2050534 | 2050534 | 2021-12-25 | Eau Claire | Wisconsin | 55035 | 20328 | 161 |
2047284 | 2047284 | 2021-12-24 | Eau Claire | Wisconsin | 55035 | 20328 | 161 |
2044034 | 2044034 | 2021-12-23 | Eau Claire | Wisconsin | 55035 | 20223 | 161 |
2040785 | 2040785 | 2021-12-22 | Eau Claire | Wisconsin | 55035 | 20114 | 161 |
2037535 | 2037535 | 2021-12-21 | Eau Claire | Wisconsin | 55035 | 20029 | 161 |
2021336 | 2021336 | 2021-12-16 | Wood | Wisconsin | 55141 | 13993 | 161 |
1920526 | 1920526 | 2021-11-15 | Jefferson | Wisconsin | 55055 | 12616 | 161 |
1917276 | 1917276 | 2021-11-14 | Jefferson | Wisconsin | 55055 | 12479 | 161 |
1914026 | 1914026 | 2021-11-13 | Jefferson | Wisconsin | 55055 | 12479 | 161 |
1910776 | 1910776 | 2021-11-12 | Jefferson | Wisconsin | 55055 | 12479 | 161 |
1875023 | 1875023 | 2021-11-01 | Fond du Lac | Wisconsin | 55039 | 18430 | 161 |
1871774 | 1871774 | 2021-10-31 | Fond du Lac | Wisconsin | 55039 | 18314 | 161 |
1868525 | 1868525 | 2021-10-30 | Fond du Lac | Wisconsin | 55039 | 18314 | 161 |
1865276 | 1865276 | 2021-10-29 | Fond du Lac | Wisconsin | 55039 | 18314 | 161 |
1862027 | 1862027 | 2021-10-28 | Fond du Lac | Wisconsin | 55039 | 18216 | 161 |
1858778 | 1858778 | 2021-10-27 | Fond du Lac | Wisconsin | 55039 | 18169 | 161 |
1855529 | 1855529 | 2021-10-26 | Fond du Lac | Wisconsin | 55039 | 18133 | 161 |
1381393 | 1381393 | 2021-06-02 | Sheboygan | Wisconsin | 55117 | 14767 | 161 |
1378148 | 1378148 | 2021-06-01 | Sheboygan | Wisconsin | 55117 | 14765 | 161 |
1374902 | 1374902 | 2021-05-31 | Sheboygan | Wisconsin | 55117 | 14761 | 161 |
1352187 | 1352187 | 2021-05-24 | Walworth | Wisconsin | 55127 | 12609 | 161 |
1348941 | 1348941 | 2021-05-23 | Walworth | Wisconsin | 55127 | 12609 | 161 |
1345693 | 1345693 | 2021-05-22 | Walworth | Wisconsin | 55127 | 12609 | 161 |
1342445 | 1342445 | 2021-05-21 | Walworth | Wisconsin | 55127 | 12609 | 161 |
1274268 | 1274268 | 2021-04-30 | Washington | Wisconsin | 55131 | 16581 | 161 |
1271023 | 1271023 | 2021-04-29 | Waupaca | Wisconsin | 55135 | 5982 | 161 |
1267776 | 1267776 | 2021-04-28 | Waupaca | Wisconsin | 55135 | 5979 | 161 |
1264529 | 1264529 | 2021-04-27 | Waupaca | Wisconsin | 55135 | 5974 | 161 |
1261282 | 1261282 | 2021-04-26 | Waupaca | Wisconsin | 55135 | 5973 | 161 |
1258035 | 1258035 | 2021-04-25 | Waupaca | Wisconsin | 55135 | 5974 | 161 |
1254788 | 1254788 | 2021-04-24 | Waupaca | Wisconsin | 55135 | 5970 | 161 |
1251541 | 1251541 | 2021-04-23 | Waupaca | Wisconsin | 55135 | 5967 | 161 |
1248294 | 1248294 | 2021-04-22 | Waupaca | Wisconsin | 55135 | 5966 | 161 |
1245047 | 1245047 | 2021-04-21 | Waupaca | Wisconsin | 55135 | 5962 | 161 |
1241800 | 1241800 | 2021-04-20 | Waupaca | Wisconsin | 55135 | 5956 | 161 |
1238553 | 1238553 | 2021-04-19 | Waupaca | Wisconsin | 55135 | 5948 | 161 |
1235306 | 1235306 | 2021-04-18 | Waupaca | Wisconsin | 55135 | 5948 | 161 |
1232058 | 1232058 | 2021-04-17 | Waupaca | Wisconsin | 55135 | 5946 | 161 |
1228810 | 1228810 | 2021-04-16 | Waupaca | Wisconsin | 55135 | 5939 | 161 |
1225562 | 1225562 | 2021-04-15 | Waupaca | Wisconsin | 55135 | 5930 | 161 |
1222315 | 1222315 | 2021-04-14 | Waupaca | Wisconsin | 55135 | 5920 | 161 |
1219067 | 1219067 | 2021-04-13 | Waupaca | Wisconsin | 55135 | 5915 | 161 |
1215819 | 1215819 | 2021-04-12 | Waupaca | Wisconsin | 55135 | 5907 | 161 |
1212572 | 1212572 | 2021-04-11 | Waupaca | Wisconsin | 55135 | 5903 | 161 |
1209323 | 1209323 | 2021-04-10 | Waupaca | Wisconsin | 55135 | 5893 | 161 |
1206075 | 1206075 | 2021-04-09 | Waupaca | Wisconsin | 55135 | 5891 | 161 |
1202827 | 1202827 | 2021-04-08 | Waupaca | Wisconsin | 55135 | 5884 | 161 |
1199579 | 1199579 | 2021-04-07 | Waupaca | Wisconsin | 55135 | 5880 | 161 |
1196330 | 1196330 | 2021-04-06 | Waupaca | Wisconsin | 55135 | 5878 | 161 |
1193082 | 1193082 | 2021-04-05 | Waupaca | Wisconsin | 55135 | 5869 | 161 |
1189832 | 1189832 | 2021-04-04 | Waupaca | Wisconsin | 55135 | 5866 | 161 |
1186585 | 1186585 | 2021-04-03 | Waupaca | Wisconsin | 55135 | 5861 | 161 |
1183338 | 1183338 | 2021-04-02 | Waupaca | Wisconsin | 55135 | 5852 | 161 |
1180091 | 1180091 | 2021-04-01 | Waupaca | Wisconsin | 55135 | 5843 | 161 |
1176844 | 1176844 | 2021-03-31 | Waupaca | Wisconsin | 55135 | 5837 | 161 |
1173597 | 1173597 | 2021-03-30 | Waupaca | Wisconsin | 55135 | 5833 | 161 |
1170350 | 1170350 | 2021-03-29 | Waupaca | Wisconsin | 55135 | 5830 | 161 |
1167102 | 1167102 | 2021-03-28 | Waupaca | Wisconsin | 55135 | 5830 | 161 |
1163854 | 1163854 | 2021-03-27 | Waupaca | Wisconsin | 55135 | 5822 | 161 |
1160606 | 1160606 | 2021-03-26 | Waupaca | Wisconsin | 55135 | 5818 | 161 |
1157358 | 1157358 | 2021-03-25 | Waupaca | Wisconsin | 55135 | 5814 | 161 |
1154111 | 1154111 | 2021-03-24 | Waupaca | Wisconsin | 55135 | 5809 | 161 |
1011272 | 1011272 | 2021-02-08 | Rock | Wisconsin | 55105 | 15482 | 161 |
1008026 | 1008026 | 2021-02-07 | Rock | Wisconsin | 55105 | 15468 | 161 |
1004780 | 1004780 | 2021-02-06 | Rock | Wisconsin | 55105 | 15449 | 161 |
975525 | 975525 | 2021-01-28 | Dodge | Wisconsin | 55027 | 11828 | 161 |
972280 | 972280 | 2021-01-27 | Dodge | Wisconsin | 55027 | 11806 | 161 |
897671 | 897671 | 2021-01-04 | Outagamie | Wisconsin | 55087 | 17839 | 161 |
894425 | 894425 | 2021-01-03 | Outagamie | Wisconsin | 55087 | 17793 | 161 |
891179 | 891179 | 2021-01-02 | Outagamie | Wisconsin | 55087 | 17624 | 161 |
887932 | 887932 | 2021-01-01 | Outagamie | Wisconsin | 55087 | 17622 | 161 |
855508 | 855508 | 2020-12-22 | Winnebago | Wisconsin | 55139 | 16506 | 161 |
852263 | 852263 | 2020-12-21 | Winnebago | Wisconsin | 55139 | 16441 | 161 |
849018 | 849018 | 2020-12-20 | Winnebago | Wisconsin | 55139 | 16373 | 161 |
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);