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 rows where "day" is on date 2020-06-16 and province_or_state = "Wisconsin" sorted by day descending

✎ View and edit SQL

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

province_or_state 1

  • Wisconsin · 73 ✖

country_or_region 1

day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2020-06-16 US Wisconsin Adams 55001 8 2 0 6 43.96974651 -89.76782777 2020-06-17 04:33:21 Adams, Wisconsin, US
2020-06-16 US Wisconsin Ashland 55003 3 0 0 3 46.31956891 -90.67837132 2020-06-17 04:33:21 Ashland, Wisconsin, US
2020-06-16 US Wisconsin Barron 55005 26 0 0 26 45.42372701 -91.84833627 2020-06-17 04:33:21 Barron, Wisconsin, US
2020-06-16 US Wisconsin Bayfield 55007 3 1 0 2 46.52868768 -91.19716729 2020-06-17 04:33:21 Bayfield, Wisconsin, US
2020-06-16 US Wisconsin Brown 55009 2492 39 0 2453 44.4526553 -88.00411844 2020-06-17 04:33:21 Brown, Wisconsin, US
2020-06-16 US Wisconsin Buffalo 55011 7 2 0 5 44.37835084 -91.75332578 2020-06-17 04:33:21 Buffalo, Wisconsin, US
2020-06-16 US Wisconsin Burnett 55013 3 1 0 2 45.86303537 -92.36711412 2020-06-17 04:33:21 Burnett, Wisconsin, US
2020-06-16 US Wisconsin Calumet 55015 87 2 0 85 44.0816316 -88.21780273 2020-06-17 04:33:21 Calumet, Wisconsin, US
2020-06-16 US Wisconsin Chippewa 55017 63 0 0 63 45.06939744 -91.28068855 2020-06-17 04:33:21 Chippewa, Wisconsin, US
2020-06-16 US Wisconsin Clark 55019 51 4 0 47 44.73483377 -90.61207486 2020-06-17 04:33:21 Clark, Wisconsin, US
2020-06-16 US Wisconsin Columbia 55021 58 1 0 57 43.46492199 -89.33589004 2020-06-17 04:33:21 Columbia, Wisconsin, US
2020-06-16 US Wisconsin Crawford 55023 27 0 0 27 43.23870316 -90.93073686 2020-06-17 04:33:21 Crawford, Wisconsin, US
2020-06-16 US Wisconsin Dane 55025 980 30 0 950 43.06601594 -89.41733797 2020-06-17 04:33:21 Dane, Wisconsin, US
2020-06-16 US Wisconsin Dodge 55027 424 4 0 420 43.41576662 -88.70928178 2020-06-17 04:33:21 Dodge, Wisconsin, US
2020-06-16 US Wisconsin Door 55029 39 3 0 36 44.95856458 -87.30002707 2020-06-17 04:33:21 Door, Wisconsin, US
2020-06-16 US Wisconsin Douglas 55031 20 0 0 20 46.43222285 -91.91595768 2020-06-17 04:33:21 Douglas, Wisconsin, US
2020-06-16 US Wisconsin Dunn 55033 29 0 0 29 44.94562799 -91.8962481 2020-06-17 04:33:21 Dunn, Wisconsin, US
2020-06-16 US Wisconsin Eau Claire 55035 138 0 0 138 44.726614 -91.28609183 2020-06-17 04:33:21 Eau Claire, Wisconsin, US
2020-06-16 US Wisconsin Florence 55037 2 0 0 2 45.84963535 -88.39804137 2020-06-17 04:33:21 Florence, Wisconsin, US
2020-06-16 US Wisconsin Fond du Lac 55039 272 6 0 266 43.75354908 -88.48885325 2020-06-17 04:33:21 Fond du Lac, Wisconsin, US
2020-06-16 US Wisconsin Forest 55041 34 2 0 32 45.66678019 -88.77084892 2020-06-17 04:33:21 Forest, Wisconsin, US
2020-06-16 US Wisconsin Grant 55043 107 12 0 95 42.8671731 -90.7063218 2020-06-17 04:33:21 Grant, Wisconsin, US
2020-06-16 US Wisconsin Green 55045 77 1 0 76 42.6794956 -89.60243287 2020-06-17 04:33:21 Green, Wisconsin, US
2020-06-16 US Wisconsin Green Lake 55047 24 0 0 24 43.80025981 -89.04679553 2020-06-17 04:33:21 Green Lake, Wisconsin, US
2020-06-16 US Wisconsin Iowa 55049 17 0 0 17 43.00050278 -90.13469017 2020-06-17 04:33:21 Iowa, Wisconsin, US
2020-06-16 US Wisconsin Iron 55051 2 1 0 1 46.26302338 -90.24295041 2020-06-17 04:33:21 Iron, Wisconsin, US
2020-06-16 US Wisconsin Jackson 55053 21 1 0 20 44.31864893 -90.80566792 2020-06-17 04:33:21 Jackson, Wisconsin, US
2020-06-16 US Wisconsin Jefferson 55055 161 4 0 157 43.02054068 -88.77529134 2020-06-17 04:33:21 Jefferson, Wisconsin, US
2020-06-16 US Wisconsin Juneau 55057 25 1 0 24 43.92456975 -90.11120239 2020-06-17 04:33:21 Juneau, Wisconsin, US
2020-06-16 US Wisconsin Kenosha 55059 1374 37 0 1337 42.57639354 -88.04051686 2020-06-17 04:33:21 Kenosha, Wisconsin, US
2020-06-16 US Wisconsin Kewaunee 55061 39 1 0 38 44.51727459 -87.61468386 2020-06-17 04:33:21 Kewaunee, Wisconsin, US
2020-06-16 US Wisconsin La Crosse 55063 132 0 0 132 43.90632465 -91.11451093 2020-06-17 04:33:21 La Crosse, Wisconsin, US
2020-06-16 US Wisconsin Lafayette 55065 43 0 0 43 42.66005229 -90.1317729 2020-06-17 04:33:21 Lafayette, Wisconsin, US
2020-06-16 US Wisconsin Langlade 55067 6 0 0 6 45.26271619 -89.07483625 2020-06-17 04:33:21 Langlade, Wisconsin, US
2020-06-16 US Wisconsin Lincoln 55069 7 0 0 7 45.33737523 -89.73411273 2020-06-17 04:33:21 Lincoln, Wisconsin, US
2020-06-16 US Wisconsin Manitowoc 55071 48 1 0 47 44.11946801 -87.80928853 2020-06-17 04:33:21 Manitowoc, Wisconsin, US
2020-06-16 US Wisconsin Marathon 55073 83 1 0 82 44.89792533 -89.75863384 2020-06-17 04:33:21 Marathon, Wisconsin, US
2020-06-16 US Wisconsin Marinette 55075 40 3 0 37 45.38553432 -88.03324599999998 2020-06-17 04:33:21 Marinette, Wisconsin, US
2020-06-16 US Wisconsin Marquette 55077 9 1 0 8 43.81911946 -89.40073763 2020-06-17 04:33:21 Marquette, Wisconsin, US
2020-06-16 US Wisconsin Menominee 55078 4 0 0 4 45.00422544 -88.70950714 2020-06-17 04:33:21 Menominee, Wisconsin, US
2020-06-16 US Wisconsin Milwaukee 55079 9658 352 0 9306 43.00486062 -87.96733172 2020-06-17 04:33:21 Milwaukee, Wisconsin, US
2020-06-16 US Wisconsin Monroe 55081 36 1 0 35 43.94641218 -90.618819 2020-06-17 04:33:21 Monroe, Wisconsin, US
2020-06-16 US Wisconsin Oconto 55083 45 0 0 45 45.02715345 -88.26807503 2020-06-17 04:33:21 Oconto, Wisconsin, US
2020-06-16 US Wisconsin Oneida 55085 17 0 0 17 45.70677897 -89.51944105 2020-06-17 04:33:21 Oneida, Wisconsin, US
2020-06-16 US Wisconsin Outagamie 55087 345 8 0 337 44.41578887 -88.46565023 2020-06-17 04:33:21 Outagamie, Wisconsin, US
2020-06-16 US Wisconsin Ozaukee 55089 199 15 0 184 43.38352225 -87.94625009 2020-06-17 04:33:21 Ozaukee, Wisconsin, US
2020-06-16 US Wisconsin Pepin 55091 1 0 0 1 44.58307413 -91.99949611 2020-06-17 04:33:21 Pepin, Wisconsin, US
2020-06-16 US Wisconsin Pierce 55093 57 0 0 57 44.71850291 -92.4224416 2020-06-17 04:33:21 Pierce, Wisconsin, US
2020-06-16 US Wisconsin Polk 55095 36 1 0 35 45.46130348 -92.44182875 2020-06-17 04:33:21 Polk, Wisconsin, US
2020-06-16 US Wisconsin Portage 55097 82 0 0 82 44.47558711 -89.50152965 2020-06-17 04:33:21 Portage, Wisconsin, US
2020-06-16 US Wisconsin Price 55099 2 0 0 2 45.68051754 -90.3609888 2020-06-17 04:33:21 Price, Wisconsin, US
2020-06-16 US Wisconsin Racine 55101 2033 55 0 1978 42.74753117 -88.05941254 2020-06-17 04:33:21 Racine, Wisconsin, US
2020-06-16 US Wisconsin Richland 55103 14 4 0 10 43.3762778 -90.43012729 2020-06-17 04:33:21 Richland, Wisconsin, US
2020-06-16 US Wisconsin Rock 55105 761 22 0 739 42.67151616 -89.07147900000002 2020-06-17 04:33:21 Rock, Wisconsin, US
2020-06-16 US Wisconsin Rusk 55107 10 0 0 10 45.47498854 -91.1333012 2020-06-17 04:33:21 Rusk, Wisconsin, US
2020-06-16 US Wisconsin Sauk 55111 87 3 0 84 43.42574087 -89.94966132 2020-06-17 04:33:21 Sauk, Wisconsin, US
2020-06-16 US Wisconsin Sawyer 55113 9 0 0 9 45.87931905 -91.14504927 2020-06-17 04:33:21 Sawyer, Wisconsin, US
2020-06-16 US Wisconsin Shawano 55115 64 0 0 64 44.78902246 -88.76443896 2020-06-17 04:33:21 Shawano, Wisconsin, US
2020-06-16 US Wisconsin Sheboygan 55117 166 4 0 162 43.72099677 -87.94579284 2020-06-17 04:33:21 Sheboygan, Wisconsin, US
2020-06-16 US Wisconsin St. Croix 55109 116 0 0 116 45.03437474 -92.45000068 2020-06-17 04:33:21 St. Croix, Wisconsin, US
2020-06-16 US Wisconsin Taylor 55119 5 0 0 5 45.21179252 -90.5004405 2020-06-17 04:33:21 Taylor, Wisconsin, US
2020-06-16 US Wisconsin Trempealeau 55121 71 0 0 71 44.30360275 -91.35893614 2020-06-17 04:33:21 Trempealeau, Wisconsin, US
2020-06-16 US Wisconsin Unassigned 90055 0 0 0 0 46.52868768 0.0 2020-06-17 04:33:21 Unassigned, Wisconsin, US
2020-06-16 US Wisconsin Vernon 55123 24 0 0 24 43.59422667 -90.8324691 2020-06-17 04:33:21 Vernon, Wisconsin, US
2020-06-16 US Wisconsin Vilas 55125 8 0 0 8 46.05467334 -89.51719204 2020-06-17 04:33:21 Vilas, Wisconsin, US
2020-06-16 US Wisconsin Walworth 55127 480 17 0 463 42.66858202 -88.54163073 2020-06-17 04:33:21 Walworth, Wisconsin, US
2020-06-16 US Wisconsin Washburn 55129 3 0 0 3 45.89838588 -91.79050449 2020-06-17 04:33:21 Washburn, Wisconsin, US
2020-06-16 US Wisconsin Washington 55131 296 11 0 285 43.36863664 -88.22974712 2020-06-17 04:33:21 Washington, Wisconsin, US
2020-06-16 US Wisconsin Waukesha 55133 928 35 0 893 43.01833055 -88.30431188 2020-06-17 04:33:21 Waukesha, Wisconsin, US
2020-06-16 US Wisconsin Waupaca 55135 80 4 0 76 44.47068056 -88.96534501 2020-06-17 04:33:21 Waupaca, Wisconsin, US
2020-06-16 US Wisconsin Waushara 55137 20 0 0 20 44.11324419 -89.24317107 2020-06-17 04:33:21 Waushara, Wisconsin, US
2020-06-16 US Wisconsin Winnebago 55139 537 9 0 528 44.06886922 -88.64477096 2020-06-17 04:33:21 Winnebago, Wisconsin, US
2020-06-16 US Wisconsin Wood 55141 23 1 0 22 44.45537896 -90.04158336 2020-06-17 04:33:21 Wood, Wisconsin, US

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;