daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

73,611 rows where province_or_state = "Wisconsin" sorted by day

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

province_or_state 1

  • Wisconsin · 73,611 ✖

country_or_region 1

  • US 73,611
day ▼ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2020-03-23 US Wisconsin Dunn 55033 1 0 0 1 44.94562799 -91.8962481 2020-03-23 23:19:34 Dunn, Wisconsin, US
2020-03-23 US Wisconsin Eau Claire 55035 4 0 0 4 44.726614 -91.28609183 2020-03-23 23:19:34 Eau Claire, Wisconsin, US
2020-03-23 US Wisconsin Florence 55037 0 0 0 0 45.84963535 -88.39804137 2020-03-23 23:19:34 Florence, Wisconsin, US
2020-03-23 US Wisconsin Fond du Lac 55039 16 1 0 15 43.75354908 -88.48885325 2020-03-23 23:19:34 Fond du Lac, Wisconsin, US
2020-03-23 US Wisconsin Forest 55041 0 0 0 0 45.66678019 -88.77084892 2020-03-23 23:19:34 Forest, Wisconsin, US
2020-03-23 US Wisconsin Grant 55043 0 0 0 0 42.8671731 -90.7063218 2020-03-23 23:19:34 Grant, Wisconsin, US
2020-03-23 US Wisconsin Green 55045 1 0 0 1 42.6794956 -89.60243287 2020-03-23 23:19:34 Green, Wisconsin, US
2020-03-23 US Wisconsin Green Lake 55047 0 0 0 0 43.80025981 -89.04679553 2020-03-23 23:19:34 Green Lake, Wisconsin, US
2020-03-23 US Wisconsin Iowa 55049 0 0 0 0 43.00050278 -90.13469017 2020-03-23 23:19:34 Iowa, Wisconsin, US
2020-03-23 US Wisconsin Iron 55051 0 0 0 0 46.26302338 -90.24295041 2020-03-23 23:19:34 Iron, Wisconsin, US
2020-03-23 US Wisconsin Jackson 55053 0 0 0 0 44.31864893 -90.80566792 2020-03-23 23:19:34 Jackson, Wisconsin, US
2020-03-23 US Wisconsin Jefferson 55055 2 0 0 2 43.02054068 -88.77529134 2020-03-23 23:19:34 Jefferson, Wisconsin, US
2020-03-23 US Wisconsin Juneau 55057 0 0 0 0 43.92456975 -90.11120239 2020-03-23 23:19:34 Juneau, Wisconsin, US
2020-03-23 US Wisconsin Kenosha 55059 12 0 0 12 42.57639354 -88.04051686 2020-03-23 23:19:34 Kenosha, Wisconsin, US
2020-03-23 US Wisconsin Kewaunee 55061 0 0 0 0 44.51727459 -87.61468386 2020-03-23 23:19:34 Kewaunee, Wisconsin, US
2020-03-23 US Wisconsin La Crosse 55063 5 0 0 5 43.90632465 -91.11451093 2020-03-23 23:19:34 La Crosse, Wisconsin, US
2020-03-23 US Wisconsin Lafayette 55065 0 0 0 0 42.66005229 -90.1317729 2020-03-23 23:19:34 Lafayette, Wisconsin, US
2020-03-23 US Wisconsin Langlade 55067 0 0 0 0 45.26271619 -89.07483625 2020-03-23 23:19:34 Langlade, Wisconsin, US
2020-03-23 US Wisconsin Lincoln 55069 0 0 0 0 45.33737523 -89.73411273 2020-03-23 23:19:34 Lincoln, Wisconsin, US
2020-03-23 US Wisconsin Manitowoc 55071 0 0 0 0 44.11946801 -87.80928853 2020-03-23 23:19:34 Manitowoc, Wisconsin, US
2020-03-23 US Wisconsin Marathon 55073 1 0 0 1 44.89792533 -89.75863384 2020-03-23 23:19:34 Marathon, Wisconsin, US
2020-03-23 US Wisconsin Marinette 55075 0 0 0 0 45.38553432 -88.03324599999998 2020-03-23 23:19:34 Marinette, Wisconsin, US
2020-03-23 US Wisconsin Marquette 55077 0 0 0 0 43.81911946 -89.40073763 2020-03-23 23:19:34 Marquette, Wisconsin, US
2020-03-23 US Wisconsin Menominee 55078 0 0 0 0 45.00422544 -88.70950714 2020-03-23 23:19:34 Menominee, Wisconsin, US
2020-03-23 US Wisconsin Milwaukee 55079 204 3 0 201 43.00486062 -87.96733172 2020-03-23 23:19:34 Milwaukee, Wisconsin, US
2020-03-23 US Wisconsin Monroe 55081 0 0 0 0 43.94641218 -90.61881899999999 2020-03-23 23:19:34 Monroe, Wisconsin, US
2020-03-23 US Wisconsin Oconto 55083 0 0 0 0 45.02715345 -88.26807503 2020-03-23 23:19:34 Oconto, Wisconsin, US
2020-03-23 US Wisconsin Oneida 55085 0 0 0 0 45.70677897 -89.51944105 2020-03-23 23:19:34 Oneida, Wisconsin, US
2020-03-23 US Wisconsin Outagamie 55087 2 0 0 2 44.41578887 -88.46565023 2020-03-23 23:19:34 Outagamie, Wisconsin, US
2020-03-23 US Wisconsin Ozaukee 55089 14 1 0 13 43.38352225 -87.94625009 2020-03-23 23:19:34 Ozaukee, Wisconsin, US
2020-03-23 US Wisconsin Pepin 55091 0 0 0 0 44.58307413 -91.99949611 2020-03-23 23:19:34 Pepin, Wisconsin, US
2020-03-23 US Wisconsin Pierce 55093 3 0 0 3 44.71850291 -92.4224416 2020-03-23 23:19:34 Pierce, Wisconsin, US
2020-03-23 US Wisconsin Polk 55095 0 0 0 0 45.46130348 -92.44182875 2020-03-23 23:19:34 Polk, Wisconsin, US
2020-03-23 US Wisconsin Portage 55097 0 0 0 0 44.47558711 -89.50152965 2020-03-23 23:19:34 Portage, Wisconsin, US
2020-03-23 US Wisconsin Price 55099 0 0 0 0 45.68051754 -90.36098879999999 2020-03-23 23:19:34 Price, Wisconsin, US
2020-03-23 US Wisconsin Racine 55101 5 0 0 5 42.74753117 -88.05941254 2020-03-23 23:19:34 Racine, Wisconsin, US
2020-03-23 US Wisconsin Richland 55103 0 0 0 0 43.3762778 -90.43012729 2020-03-23 23:19:34 Richland, Wisconsin, US
2020-03-23 US Wisconsin Rock 55105 3 0 0 3 42.67151616 -89.07147900000002 2020-03-23 23:19:34 Rock, Wisconsin, US
2020-03-23 US Wisconsin Rusk 55107 0 0 0 0 45.47498854 -91.1333012 2020-03-23 23:19:34 Rusk, Wisconsin, US
2020-03-23 US Wisconsin Sauk 55111 3 0 0 3 43.42574087 -89.94966132 2020-03-23 23:19:34 Sauk, Wisconsin, US
2020-03-23 US Wisconsin Sawyer 55113 0 0 0 0 45.87931905 -91.14504927 2020-03-23 23:19:34 Sawyer, Wisconsin, US
2020-03-23 US Wisconsin Shawano 55115 0 0 0 0 44.78902246 -88.76443896 2020-03-23 23:19:34 Shawano, Wisconsin, US
2020-03-23 US Wisconsin Sheboygan 55117 6 0 0 6 43.72099677 -87.94579284 2020-03-23 23:19:34 Sheboygan, Wisconsin, US
2020-03-23 US Wisconsin St. Croix 55109 3 0 0 3 45.03437474 -92.45000068 2020-03-23 23:19:34 St. Croix, Wisconsin, US
2020-03-23 US Wisconsin Taylor 55119 0 0 0 0 45.21179252 -90.5004405 2020-03-23 23:19:34 Taylor, Wisconsin, US
2020-03-23 US Wisconsin Trempealeau 55121 0 0 0 0 44.30360275 -91.35893614 2020-03-23 23:19:34 Trempealeau, Wisconsin, US
2020-03-23 US Wisconsin Vernon 55123 0 0 0 0 43.59422667 -90.8324691 2020-03-23 23:19:34 Vernon, Wisconsin, US
2020-03-23 US Wisconsin Vilas 55125 0 0 0 0 46.05467334 -89.51719204 2020-03-23 23:19:34 Vilas, Wisconsin, US
2020-03-23 US Wisconsin Walworth 55127 3 0 0 3 42.66858202 -88.54163073 2020-03-23 23:19:34 Walworth, Wisconsin, US
2020-03-23 US Wisconsin Washburn 55129 0 0 0 0 45.89838588 -91.79050449 2020-03-23 23:19:34 Washburn, Wisconsin, US
2020-03-23 US Wisconsin Washington 55131 15 0 0 15 43.36863664 -88.22974712 2020-03-23 23:19:34 Washington, Wisconsin, US
2020-03-23 US Wisconsin Waukesha 55133 31 0 0 31 43.01833055 -88.30431188 2020-03-23 23:19:34 Waukesha, Wisconsin, US
2020-03-23 US Wisconsin Waupaca 55135 0 0 0 0 44.47068056 -88.96534501 2020-03-23 23:19:34 Waupaca, Wisconsin, US
2020-03-23 US Wisconsin Waushara 55137 0 0 0 0 44.11324419 -89.24317107 2020-03-23 23:19:34 Waushara, Wisconsin, US
2020-03-23 US Wisconsin Winnebago 55139 5 0 0 5 44.06886922 -88.64477096 2020-03-23 23:19:34 Winnebago, Wisconsin, US
2020-03-23 US Wisconsin Wood 55141 1 0 0 1 44.45537896 -90.04158336 2020-03-23 23:19:34 Wood, Wisconsin, US
2020-03-24 US Wisconsin Adams 55001 0 0 0 0 43.96974651 -89.76782777 2020-03-24 23:37:31 Adams, Wisconsin, US
2020-03-24 US Wisconsin Ashland 55003 0 0 0 0 46.31956891 -90.67837132 2020-03-24 23:37:31 Ashland, Wisconsin, US
2020-03-24 US Wisconsin Barron 55005 0 0 0 0 45.42372701 -91.84833627 2020-03-24 23:37:31 Barron, Wisconsin, US
2020-03-24 US Wisconsin Bayfield 55007 1 0 0 1 46.52868768 -91.19716729 2020-03-24 23:37:31 Bayfield, Wisconsin, US
2020-03-24 US Wisconsin Brown 55009 3 0 0 3 44.452655299999996 -88.00411844 2020-03-24 23:37:31 Brown, Wisconsin, US
2020-03-24 US Wisconsin Buffalo 55011 0 0 0 0 44.37835084 -91.75332578 2020-03-24 23:37:31 Buffalo, Wisconsin, US
2020-03-24 US Wisconsin Burnett 55013 0 0 0 0 45.86303537 -92.36711412 2020-03-24 23:37:31 Burnett, Wisconsin, US
2020-03-24 US Wisconsin Calumet 55015 1 0 0 1 44.0816316 -88.21780273 2020-03-24 23:37:31 Calumet, Wisconsin, US
2020-03-24 US Wisconsin Chippewa 55017 1 0 0 1 45.06939744 -91.28068855 2020-03-24 23:37:31 Chippewa, Wisconsin, US
2020-03-24 US Wisconsin Clark 55019 0 0 0 0 44.73483377 -90.61207486 2020-03-24 23:37:31 Clark, Wisconsin, US
2020-03-24 US Wisconsin Columbia 55021 5 0 0 5 43.46492199 -89.33589004 2020-03-24 23:37:31 Columbia, Wisconsin, US
2020-03-24 US Wisconsin Crawford 55023 0 0 0 0 43.23870316 -90.93073686 2020-03-24 23:37:31 Crawford, Wisconsin, US
2020-03-24 US Wisconsin Dane 55025 72 0 0 72 43.06601594 -89.41733797 2020-03-24 23:37:31 Dane, Wisconsin, US
2020-03-24 US Wisconsin Dodge 55027 2 0 0 2 43.41576662 -88.70928178 2020-03-24 23:37:31 Dodge, Wisconsin, US
2020-03-24 US Wisconsin Door 55029 0 0 0 0 44.95856458 -87.30002707 2020-03-24 23:37:31 Door, Wisconsin, US
2020-03-24 US Wisconsin Douglas 55031 4 0 0 4 46.43222285 -91.91595768 2020-03-24 23:37:31 Douglas, Wisconsin, US
2020-03-24 US Wisconsin Dunn 55033 1 0 0 1 44.94562799 -91.8962481 2020-03-24 23:37:31 Dunn, Wisconsin, US
2020-03-24 US Wisconsin Eau Claire 55035 4 0 0 4 44.726614 -91.28609183 2020-03-24 23:37:31 Eau Claire, Wisconsin, US
2020-03-24 US Wisconsin Florence 55037 0 0 0 0 45.84963535 -88.39804137 2020-03-24 23:37:31 Florence, Wisconsin, US
2020-03-24 US Wisconsin Fond du Lac 55039 18 1 0 17 43.75354908 -88.48885325 2020-03-24 23:37:31 Fond du Lac, Wisconsin, US
2020-03-24 US Wisconsin Forest 55041 0 0 0 0 45.66678019 -88.77084892 2020-03-24 23:37:31 Forest, Wisconsin, US
2020-03-24 US Wisconsin Grant 55043 0 0 0 0 42.8671731 -90.7063218 2020-03-24 23:37:31 Grant, Wisconsin, US
2020-03-24 US Wisconsin Green 55045 1 0 0 1 42.6794956 -89.60243287 2020-03-24 23:37:31 Green, Wisconsin, US
2020-03-24 US Wisconsin Green Lake 55047 0 0 0 0 43.80025981 -89.04679553 2020-03-24 23:37:31 Green Lake, Wisconsin, US
2020-03-24 US Wisconsin Iowa 55049 1 0 0 1 43.00050278 -90.13469017 2020-03-24 23:37:31 Iowa, Wisconsin, US
2020-03-24 US Wisconsin Iron 55051 0 0 0 0 46.26302338 -90.24295041 2020-03-24 23:37:31 Iron, Wisconsin, US
2020-03-24 US Wisconsin Jackson 55053 0 0 0 0 44.31864893 -90.80566792 2020-03-24 23:37:31 Jackson, Wisconsin, US
2020-03-24 US Wisconsin Jefferson 55055 4 0 0 4 43.02054068 -88.77529134 2020-03-24 23:37:31 Jefferson, Wisconsin, US
2020-03-24 US Wisconsin Juneau 55057 0 0 0 0 43.92456975 -90.11120239 2020-03-24 23:37:31 Juneau, Wisconsin, US
2020-03-24 US Wisconsin Kenosha 55059 13 0 0 13 42.57639354 -88.04051686 2020-03-24 23:37:31 Kenosha, Wisconsin, US
2020-03-24 US Wisconsin Kewaunee 55061 0 0 0 0 44.51727459 -87.61468386 2020-03-24 23:37:31 Kewaunee, Wisconsin, US
2020-03-24 US Wisconsin La Crosse 55063 5 0 0 5 43.90632465 -91.11451093 2020-03-24 23:37:31 La Crosse, Wisconsin, US
2020-03-24 US Wisconsin Lafayette 55065 0 0 0 0 42.66005229 -90.1317729 2020-03-24 23:37:31 Lafayette, Wisconsin, US
2020-03-24 US Wisconsin Langlade 55067 0 0 0 0 45.26271619 -89.07483625 2020-03-24 23:37:31 Langlade, Wisconsin, US
2020-03-24 US Wisconsin Lincoln 55069 0 0 0 0 45.33737523 -89.73411273 2020-03-24 23:37:31 Lincoln, Wisconsin, US
2020-03-24 US Wisconsin Manitowoc 55071 0 0 0 0 44.11946801 -87.80928853 2020-03-24 23:37:31 Manitowoc, Wisconsin, US
2020-03-24 US Wisconsin Marathon 55073 1 0 0 1 44.89792533 -89.75863384 2020-03-24 23:37:31 Marathon, Wisconsin, US
2020-03-24 US Wisconsin Marinette 55075 0 0 0 0 45.38553432 -88.03324599999998 2020-03-24 23:37:31 Marinette, Wisconsin, US
2020-03-24 US Wisconsin Marquette 55077 0 0 0 0 43.81911946 -89.40073763 2020-03-24 23:37:31 Marquette, Wisconsin, US
2020-03-24 US Wisconsin Menominee 55078 0 0 0 0 45.00422544 -88.70950714 2020-03-24 23:37:31 Menominee, Wisconsin, US
2020-03-24 US Wisconsin Milwaukee 55079 243 3 0 240 43.00486062 -87.96733172 2020-03-24 23:37:31 Milwaukee, Wisconsin, US
2020-03-24 US Wisconsin Monroe 55081 0 0 0 0 43.94641218 -90.61881899999999 2020-03-24 23:37:31 Monroe, Wisconsin, US
2020-03-24 US Wisconsin Oconto 55083 0 0 0 0 45.02715345 -88.26807503 2020-03-24 23:37:31 Oconto, Wisconsin, US
2020-03-24 US Wisconsin Oneida 55085 0 0 0 0 45.70677897 -89.51944105 2020-03-24 23:37:31 Oneida, Wisconsin, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;