ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where deaths = 154 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2287967 | 2287967 | 2022-03-08 | Portage | Wisconsin | 55097 | 17831 | 154 |
2180634 | 2180634 | 2022-02-03 | La Crosse | Wisconsin | 55063 | 32908 | 154 |
2177383 | 2177383 | 2022-02-02 | La Crosse | Wisconsin | 55063 | 32708 | 154 |
2135060 | 2135060 | 2022-01-20 | Chippewa | Wisconsin | 55017 | 16524 | 154 |
2131808 | 2131808 | 2022-01-19 | Chippewa | Wisconsin | 55017 | 16292 | 154 |
2128554 | 2128554 | 2022-01-18 | Chippewa | Wisconsin | 55017 | 16076 | 154 |
2125328 | 2125328 | 2022-01-17 | Manitowoc | Wisconsin | 55071 | 17999 | 154 |
1998581 | 1998581 | 2021-12-09 | Wood | Wisconsin | 55141 | 13424 | 154 |
1901028 | 1901028 | 2021-11-09 | Jefferson | Wisconsin | 55055 | 12325 | 154 |
1897778 | 1897778 | 2021-11-08 | Jefferson | Wisconsin | 55055 | 12282 | 154 |
1894528 | 1894528 | 2021-11-07 | Jefferson | Wisconsin | 55055 | 12194 | 154 |
1891278 | 1891278 | 2021-11-06 | Jefferson | Wisconsin | 55055 | 12194 | 154 |
1888028 | 1888028 | 2021-11-05 | Jefferson | Wisconsin | 55055 | 12194 | 154 |
1884778 | 1884778 | 2021-11-04 | Jefferson | Wisconsin | 55055 | 12145 | 154 |
1806792 | 1806792 | 2021-10-11 | Fond du Lac | Wisconsin | 55039 | 17265 | 154 |
1803541 | 1803541 | 2021-10-10 | Fond du Lac | Wisconsin | 55039 | 17171 | 154 |
1800292 | 1800292 | 2021-10-09 | Fond du Lac | Wisconsin | 55039 | 17171 | 154 |
1797043 | 1797043 | 2021-10-08 | Fond du Lac | Wisconsin | 55039 | 17171 | 154 |
1793794 | 1793794 | 2021-10-07 | Fond du Lac | Wisconsin | 55039 | 17071 | 154 |
1790545 | 1790545 | 2021-10-06 | Fond du Lac | Wisconsin | 55039 | 17007 | 154 |
1787297 | 1787297 | 2021-10-05 | Fond du Lac | Wisconsin | 55039 | 16950 | 154 |
1758054 | 1758054 | 2021-09-26 | Fond du Lac | Wisconsin | 55039 | 16145 | 154 |
1754806 | 1754806 | 2021-09-25 | Fond du Lac | Wisconsin | 55039 | 16145 | 154 |
1751558 | 1751558 | 2021-09-24 | Fond du Lac | Wisconsin | 55039 | 16145 | 154 |
1748309 | 1748309 | 2021-09-23 | Fond du Lac | Wisconsin | 55039 | 16067 | 154 |
1232056 | 1232056 | 2021-04-17 | Washington | Wisconsin | 55131 | 16347 | 154 |
1225560 | 1225560 | 2021-04-15 | Washington | Wisconsin | 55131 | 16312 | 154 |
1222313 | 1222313 | 2021-04-14 | Washington | Wisconsin | 55131 | 16296 | 154 |
1219065 | 1219065 | 2021-04-13 | Washington | Wisconsin | 55131 | 16302 | 154 |
1215817 | 1215817 | 2021-04-12 | Washington | Wisconsin | 55131 | 16249 | 154 |
1212570 | 1212570 | 2021-04-11 | Washington | Wisconsin | 55131 | 16247 | 154 |
1209321 | 1209321 | 2021-04-10 | Washington | Wisconsin | 55131 | 16235 | 154 |
1206073 | 1206073 | 2021-04-09 | Washington | Wisconsin | 55131 | 16219 | 154 |
1170346 | 1170346 | 2021-03-29 | Walworth | Wisconsin | 55127 | 11782 | 154 |
1167098 | 1167098 | 2021-03-28 | Walworth | Wisconsin | 55127 | 11757 | 154 |
1163850 | 1163850 | 2021-03-27 | Walworth | Wisconsin | 55127 | 11757 | 154 |
1160602 | 1160602 | 2021-03-26 | Walworth | Wisconsin | 55127 | 11757 | 154 |
1034005 | 1034005 | 2021-02-15 | Waupaca | Wisconsin | 55135 | 5578 | 154 |
1030759 | 1030759 | 2021-02-14 | Waupaca | Wisconsin | 55135 | 5578 | 154 |
1027512 | 1027512 | 2021-02-13 | Waupaca | Wisconsin | 55135 | 5576 | 154 |
1024267 | 1024267 | 2021-02-12 | Waupaca | Wisconsin | 55135 | 5569 | 154 |
855482 | 855482 | 2020-12-22 | Outagamie | Wisconsin | 55087 | 16847 | 154 |
793778 | 793778 | 2020-12-03 | Brown | Wisconsin | 55009 | 23986 | 154 |
787313 | 787313 | 2020-12-01 | Kenosha | Wisconsin | 55059 | 10596 | 154 |
86806 | 86806 | 2020-04-24 | Milwaukee | Wisconsin | 55079 | 2431 | 154 |
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);