daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
146 rows where "last_update" is on date 2022-04-13 and province_or_state = "Wisconsin" sorted by fips
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-04-12 | US | Wisconsin | Price | 55099 | 3249 | 33 | 0 | 45.68051754 | -90.36098879999999 | 2022-04-13 04:21:03 | Price, Wisconsin, US | |
2022-04-13 | US | Wisconsin | Price | 55099 | 3249 | 33 | 0 | 45.68051754 | -90.36098879999999 | 2022-04-13 23:21:06 | Price, Wisconsin, US | |
2022-04-12 | US | Wisconsin | Racine | 55101 | 56373 | 688 | 0 | 42.74753117 | -88.05941254 | 2022-04-13 04:21:03 | Racine, Wisconsin, US | |
2022-04-13 | US | Wisconsin | Racine | 55101 | 56394 | 688 | 0 | 42.74753117 | -88.05941254 | 2022-04-13 23:21:06 | Racine, Wisconsin, US | |
2022-04-12 | US | Wisconsin | Richland | 55103 | 3857 | 48 | 0 | 43.3762778 | -90.43012729 | 2022-04-13 04:21:03 | Richland, Wisconsin, US | |
2022-04-13 | US | Wisconsin | Richland | 55103 | 3859 | 48 | 0 | 43.3762778 | -90.43012729 | 2022-04-13 23:21:06 | Richland, Wisconsin, US | |
2022-04-12 | US | Wisconsin | Rock | 55105 | 42979 | 391 | 0 | 42.67151616 | -89.07147900000002 | 2022-04-13 04:21:03 | Rock, Wisconsin, US | |
2022-04-13 | US | Wisconsin | Rock | 55105 | 43000 | 391 | 0 | 42.67151616 | -89.07147900000002 | 2022-04-13 23:21:06 | Rock, Wisconsin, US | |
2022-04-12 | US | Wisconsin | Rusk | 55107 | 3415 | 54 | 0 | 45.47498854 | -91.1333012 | 2022-04-13 04:21:03 | Rusk, Wisconsin, US | |
2022-04-13 | US | Wisconsin | Rusk | 55107 | 3415 | 54 | 0 | 45.47498854 | -91.1333012 | 2022-04-13 23:21:06 | Rusk, Wisconsin, US | |
2022-04-12 | US | Wisconsin | St. Croix | 55109 | 24714 | 147 | 0 | 45.03437474 | -92.45000068 | 2022-04-13 04:21:03 | St. Croix, Wisconsin, US | |
2022-04-13 | US | Wisconsin | St. Croix | 55109 | 24733 | 147 | 0 | 45.03437474 | -92.45000068 | 2022-04-13 23:21:06 | St. Croix, Wisconsin, US | |
2022-04-12 | US | Wisconsin | Sauk | 55111 | 15879 | 132 | 0 | 43.42574087 | -89.94966132 | 2022-04-13 04:21:03 | Sauk, Wisconsin, US | |
2022-04-13 | US | Wisconsin | Sauk | 55111 | 15894 | 132 | 0 | 43.42574087 | -89.94966132 | 2022-04-13 23:21:06 | Sauk, Wisconsin, US | |
2022-04-12 | US | Wisconsin | Sawyer | 55113 | 4550 | 62 | 0 | 45.87931905 | -91.14504927 | 2022-04-13 04:21:03 | Sawyer, Wisconsin, US | |
2022-04-13 | US | Wisconsin | Sawyer | 55113 | 4550 | 62 | 0 | 45.87931905 | -91.14504927 | 2022-04-13 23:21:06 | Sawyer, Wisconsin, US | |
2022-04-12 | US | Wisconsin | Shawano | 55115 | 11652 | 150 | 0 | 44.78902246 | -88.76443896 | 2022-04-13 04:21:03 | Shawano, Wisconsin, US | |
2022-04-13 | US | Wisconsin | Shawano | 55115 | 11653 | 150 | 0 | 44.78902246 | -88.76443896 | 2022-04-13 23:21:06 | Shawano, Wisconsin, US | |
2022-04-12 | US | Wisconsin | Sheboygan | 55117 | 32490 | 315 | 0 | 43.72099677 | -87.94579284 | 2022-04-13 04:21:03 | Sheboygan, Wisconsin, US | |
2022-04-13 | US | Wisconsin | Sheboygan | 55117 | 32502 | 316 | 0 | 43.72099677 | -87.94579284 | 2022-04-13 23:21:06 | Sheboygan, Wisconsin, US | |
2022-04-12 | US | Wisconsin | Taylor | 55119 | 4827 | 72 | 0 | 45.21179252 | -90.5004405 | 2022-04-13 04:21:03 | Taylor, Wisconsin, US | |
2022-04-13 | US | Wisconsin | Taylor | 55119 | 4827 | 72 | 0 | 45.21179252 | -90.5004405 | 2022-04-13 23:21:06 | Taylor, Wisconsin, US | |
2022-04-12 | US | Wisconsin | Trempealeau | 55121 | 8393 | 63 | 0 | 44.30360275 | -91.35893614 | 2022-04-13 04:21:03 | Trempealeau, Wisconsin, US | |
2022-04-13 | US | Wisconsin | Trempealeau | 55121 | 8396 | 63 | 0 | 44.30360275 | -91.35893614 | 2022-04-13 23:21:06 | Trempealeau, Wisconsin, US | |
2022-04-12 | US | Wisconsin | Vernon | 55123 | 6030 | 96 | 0 | 43.59422667 | -90.8324691 | 2022-04-13 04:21:03 | Vernon, Wisconsin, US | |
2022-04-13 | US | Wisconsin | Vernon | 55123 | 6032 | 96 | 0 | 43.59422667 | -90.8324691 | 2022-04-13 23:21:06 | Vernon, Wisconsin, US | |
2022-04-12 | US | Wisconsin | Vilas | 55125 | 5222 | 89 | 0 | 46.05467334 | -89.51719204 | 2022-04-13 04:21:03 | Vilas, Wisconsin, US | |
2022-04-13 | US | Wisconsin | Vilas | 55125 | 5219 | 89 | 0 | 46.05467334 | -89.51719204 | 2022-04-13 23:21:06 | Vilas, Wisconsin, US | |
2022-04-12 | US | Wisconsin | Walworth | 55127 | 26725 | 278 | 0 | 42.66858202 | -88.54163073 | 2022-04-13 04:21:03 | Walworth, Wisconsin, US | |
2022-04-13 | US | Wisconsin | Walworth | 55127 | 26738 | 278 | 0 | 42.66858202 | -88.54163073 | 2022-04-13 23:21:06 | Walworth, Wisconsin, US | |
2022-04-12 | US | Wisconsin | Washburn | 55129 | 3980 | 46 | 0 | 45.89838588 | -91.79050449 | 2022-04-13 04:21:03 | Washburn, Wisconsin, US | |
2022-04-13 | US | Wisconsin | Washburn | 55129 | 3983 | 46 | 0 | 45.89838588 | -91.79050449 | 2022-04-13 23:21:06 | Washburn, Wisconsin, US | |
2022-04-12 | US | Wisconsin | Washington | 55131 | 38035 | 341 | 0 | 43.36863664 | -88.22974712 | 2022-04-13 04:21:03 | Washington, Wisconsin, US | |
2022-04-13 | US | Wisconsin | Washington | 55131 | 38042 | 341 | 0 | 43.36863664 | -88.22974712 | 2022-04-13 23:21:06 | Washington, Wisconsin, US | |
2022-04-12 | US | Wisconsin | Waukesha | 55133 | 112460 | 1091 | 0 | 43.01833055 | -88.30431188 | 2022-04-13 04:21:03 | Waukesha, Wisconsin, US | |
2022-04-13 | US | Wisconsin | Waukesha | 55133 | 112519 | 1091 | 0 | 43.01833055 | -88.30431188 | 2022-04-13 23:21:06 | Waukesha, Wisconsin, US | |
2022-04-12 | US | Wisconsin | Waupaca | 55135 | 13628 | 251 | 0 | 44.47068056 | -88.96534501 | 2022-04-13 04:21:03 | Waupaca, Wisconsin, US | |
2022-04-13 | US | Wisconsin | Waupaca | 55135 | 13631 | 251 | 0 | 44.47068056 | -88.96534501 | 2022-04-13 23:21:06 | Waupaca, Wisconsin, US | |
2022-04-12 | US | Wisconsin | Waushara | 55137 | 6389 | 87 | 0 | 44.11324419 | -89.24317107 | 2022-04-13 04:21:03 | Waushara, Wisconsin, US | |
2022-04-13 | US | Wisconsin | Waushara | 55137 | 6391 | 87 | 0 | 44.11324419 | -89.24317107 | 2022-04-13 23:21:06 | Waushara, Wisconsin, US | |
2022-04-12 | US | Wisconsin | Winnebago | 55139 | 51631 | 380 | 0 | 44.06886922 | -88.64477096 | 2022-04-13 04:21:03 | Winnebago, Wisconsin, US | |
2022-04-13 | US | Wisconsin | Winnebago | 55139 | 51662 | 380 | 0 | 44.06886922 | -88.64477096 | 2022-04-13 23:21:06 | Winnebago, Wisconsin, US | |
2022-04-12 | US | Wisconsin | Wood | 55141 | 20928 | 230 | 0 | 44.45537896 | -90.04158336 | 2022-04-13 04:21:03 | Wood, Wisconsin, US | |
2022-04-13 | US | Wisconsin | Wood | 55141 | 20934 | 230 | 0 | 44.45537896 | -90.04158336 | 2022-04-13 23:21:06 | Wood, Wisconsin, US | |
2022-04-12 | US | Wisconsin | Unassigned | 90055 | 0 | 0 | 0 | 46.52868768 | 0.0 | 2022-04-13 04:21:03 | Unassigned, Wisconsin, US | |
2022-04-13 | US | Wisconsin | Unassigned | 90055 | 0 | 0 | 0 | 46.52868768 | 0.0 | 2022-04-13 23:21:06 | Unassigned, Wisconsin, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;