daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
146 rows where "last_update" is on date 2022-05-26 and province_or_state = "Wisconsin" sorted by confirmed
This data as json, yaml, Notebook, copyable, CSV (advanced)
day | country_or_region | province_or_state | admin2 | fips | confirmed ▼ | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-05-22 | US | Wisconsin | Chippewa | 55017 | 19291 | 188 | 0 | 45.06939744 | -91.28068855 | 2022-05-26 04:20:50 | Chippewa, Wisconsin, US | |
2022-05-25 | US | Wisconsin | Chippewa | 55017 | 19291 | 188 | 0 | 45.06939744 | -91.28068855 | 2022-05-26 04:20:50 | Chippewa, Wisconsin, US | |
2022-05-22 | US | Wisconsin | Manitowoc | 55071 | 21055 | 190 | 0 | 44.11946801 | -87.80928853 | 2022-05-26 04:20:50 | Manitowoc, Wisconsin, US | |
2022-05-25 | US | Wisconsin | Manitowoc | 55071 | 21055 | 190 | 0 | 44.11946801 | -87.80928853 | 2022-05-26 04:20:50 | Manitowoc, Wisconsin, US | |
2022-05-22 | US | Wisconsin | Wood | 55141 | 21772 | 236 | 0 | 44.45537896 | -90.04158336 | 2022-05-26 04:20:50 | Wood, Wisconsin, US | |
2022-05-25 | US | Wisconsin | Wood | 55141 | 21772 | 236 | 0 | 44.45537896 | -90.04158336 | 2022-05-26 04:20:50 | Wood, Wisconsin, US | |
2022-05-22 | US | Wisconsin | Jefferson | 55055 | 22284 | 244 | 0 | 43.02054068 | -88.77529134 | 2022-05-26 04:20:50 | Jefferson, Wisconsin, US | |
2022-05-25 | US | Wisconsin | Jefferson | 55055 | 22284 | 244 | 0 | 43.02054068 | -88.77529134 | 2022-05-26 04:20:50 | Jefferson, Wisconsin, US | |
2022-05-22 | US | Wisconsin | Ozaukee | 55089 | 23587 | 189 | 0 | 43.38352225 | -87.94625009 | 2022-05-26 04:20:50 | Ozaukee, Wisconsin, US | |
2022-05-25 | US | Wisconsin | Ozaukee | 55089 | 23587 | 189 | 0 | 43.38352225 | -87.94625009 | 2022-05-26 04:20:50 | Ozaukee, Wisconsin, US | |
2022-05-22 | US | Wisconsin | St. Croix | 55109 | 25984 | 151 | 0 | 45.03437474 | -92.45000068 | 2022-05-26 04:20:50 | St. Croix, Wisconsin, US | |
2022-05-25 | US | Wisconsin | St. Croix | 55109 | 25984 | 151 | 0 | 45.03437474 | -92.45000068 | 2022-05-26 04:20:50 | St. Croix, Wisconsin, US | |
2022-05-22 | US | Wisconsin | Walworth | 55127 | 27669 | 283 | 0 | 42.66858202 | -88.54163073 | 2022-05-26 04:20:50 | Walworth, Wisconsin, US | |
2022-05-25 | US | Wisconsin | Walworth | 55127 | 27669 | 283 | 0 | 42.66858202 | -88.54163073 | 2022-05-26 04:20:50 | Walworth, Wisconsin, US | |
2022-05-22 | US | Wisconsin | Dodge | 55027 | 27785 | 339 | 0 | 43.41576662 | -88.70928178 | 2022-05-26 04:20:50 | Dodge, Wisconsin, US | |
2022-05-25 | US | Wisconsin | Dodge | 55027 | 27785 | 339 | 0 | 43.41576662 | -88.70928178 | 2022-05-26 04:20:50 | Dodge, Wisconsin, US | |
2022-05-22 | US | Wisconsin | Eau Claire | 55035 | 31675 | 191 | 0 | 44.726614 | -91.28609183 | 2022-05-26 04:20:50 | Eau Claire, Wisconsin, US | |
2022-05-25 | US | Wisconsin | Eau Claire | 55035 | 31675 | 191 | 0 | 44.726614 | -91.28609183 | 2022-05-26 04:20:50 | Eau Claire, Wisconsin, US | |
2022-05-22 | US | Wisconsin | Fond du Lac | 55039 | 32889 | 280 | 0 | 43.75354908 | -88.48885325 | 2022-05-26 04:20:50 | Fond du Lac, Wisconsin, US | |
2022-05-25 | US | Wisconsin | Fond du Lac | 55039 | 32889 | 280 | 0 | 43.75354908 | -88.48885325 | 2022-05-26 04:20:50 | Fond du Lac, Wisconsin, US | |
2022-05-22 | US | Wisconsin | Sheboygan | 55117 | 33466 | 323 | 0 | 43.72099677 | -87.94579284 | 2022-05-26 04:20:50 | Sheboygan, Wisconsin, US | |
2022-05-25 | US | Wisconsin | Sheboygan | 55117 | 33466 | 323 | 0 | 43.72099677 | -87.94579284 | 2022-05-26 04:20:50 | Sheboygan, Wisconsin, US | |
2022-05-22 | US | Wisconsin | La Crosse | 55063 | 36601 | 187 | 0 | 43.90632465 | -91.11451093 | 2022-05-26 04:20:50 | La Crosse, Wisconsin, US | |
2022-05-25 | US | Wisconsin | La Crosse | 55063 | 36601 | 187 | 0 | 43.90632465 | -91.11451093 | 2022-05-26 04:20:50 | La Crosse, Wisconsin, US | |
2022-05-22 | US | Wisconsin | Washington | 55131 | 39597 | 344 | 0 | 43.36863664 | -88.22974712 | 2022-05-26 04:20:50 | Washington, Wisconsin, US | |
2022-05-25 | US | Wisconsin | Washington | 55131 | 39597 | 344 | 0 | 43.36863664 | -88.22974712 | 2022-05-26 04:20:50 | Washington, Wisconsin, US | |
2022-05-22 | US | Wisconsin | Marathon | 55073 | 40886 | 495 | 0 | 44.89792533 | -89.75863384 | 2022-05-26 04:20:50 | Marathon, Wisconsin, US | |
2022-05-25 | US | Wisconsin | Marathon | 55073 | 40886 | 495 | 0 | 44.89792533 | -89.75863384 | 2022-05-26 04:20:50 | Marathon, Wisconsin, US | |
2022-05-22 | US | Wisconsin | Rock | 55105 | 44947 | 396 | 0 | 42.67151616 | -89.071479 | 2022-05-26 04:20:50 | Rock, Wisconsin, US | |
2022-05-25 | US | Wisconsin | Rock | 55105 | 44947 | 396 | 0 | 42.67151616 | -89.071479 | 2022-05-26 04:20:50 | Rock, Wisconsin, US | |
2022-05-22 | US | Wisconsin | Kenosha | 55059 | 46037 | 634 | 0 | 42.57639354 | -88.04051686 | 2022-05-26 04:20:50 | Kenosha, Wisconsin, US | |
2022-05-25 | US | Wisconsin | Kenosha | 55059 | 46037 | 634 | 0 | 42.57639354 | -88.04051686 | 2022-05-26 04:20:50 | Kenosha, Wisconsin, US | |
2022-05-22 | US | Wisconsin | Winnebago | 55139 | 53754 | 387 | 0 | 44.06886922 | -88.64477096 | 2022-05-26 04:20:50 | Winnebago, Wisconsin, US | |
2022-05-25 | US | Wisconsin | Winnebago | 55139 | 53754 | 387 | 0 | 44.06886922 | -88.64477096 | 2022-05-26 04:20:50 | Winnebago, Wisconsin, US | |
2022-05-22 | US | Wisconsin | Outagamie | 55087 | 55822 | 409 | 0 | 44.41578887 | -88.46565023 | 2022-05-26 04:20:50 | Outagamie, Wisconsin, US | |
2022-05-25 | US | Wisconsin | Outagamie | 55087 | 55822 | 409 | 0 | 44.41578887 | -88.46565023 | 2022-05-26 04:20:50 | Outagamie, Wisconsin, US | |
2022-05-22 | US | Wisconsin | Racine | 55101 | 58706 | 690 | 0 | 42.74753117 | -88.05941254 | 2022-05-26 04:20:50 | Racine, Wisconsin, US | |
2022-05-25 | US | Wisconsin | Racine | 55101 | 58706 | 690 | 0 | 42.74753117 | -88.05941254 | 2022-05-26 04:20:50 | Racine, Wisconsin, US | |
2022-05-22 | US | Wisconsin | Brown | 55009 | 86757 | 559 | 0 | 44.4526553 | -88.00411844 | 2022-05-26 04:20:50 | Brown, Wisconsin, US | |
2022-05-25 | US | Wisconsin | Brown | 55009 | 86757 | 559 | 0 | 44.4526553 | -88.00411844 | 2022-05-26 04:20:50 | Brown, Wisconsin, US | |
2022-05-22 | US | Wisconsin | Waukesha | 55133 | 117912 | 1100 | 0 | 43.01833055 | -88.30431188 | 2022-05-26 04:20:50 | Waukesha, Wisconsin, US | |
2022-05-25 | US | Wisconsin | Waukesha | 55133 | 117912 | 1100 | 0 | 43.01833055 | -88.30431188 | 2022-05-26 04:20:50 | Waukesha, Wisconsin, US | |
2022-05-22 | US | Wisconsin | Dane | 55025 | 138684 | 519 | 0 | 43.06601594 | -89.41733797 | 2022-05-26 04:20:50 | Dane, Wisconsin, US | |
2022-05-25 | US | Wisconsin | Dane | 55025 | 138684 | 519 | 0 | 43.06601594 | -89.41733797 | 2022-05-26 04:20:50 | Dane, Wisconsin, US | |
2022-05-22 | US | Wisconsin | Milwaukee | 55079 | 282040 | 2299 | 0 | 43.00486062 | -87.96733172 | 2022-05-26 04:20:50 | Milwaukee, Wisconsin, US | |
2022-05-25 | US | Wisconsin | Milwaukee | 55079 | 282040 | 2299 | 0 | 43.00486062 | -87.96733172 | 2022-05-26 04:20:50 | Milwaukee, Wisconsin, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;