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 country_or_region = "US" and province_or_state = "Wisconsin" sorted by country_or_region

✎ View and edit SQL

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

Suggested facets: last_update (date)

These facets timed out: day

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
2021-12-02 US Wisconsin Adams 55001 3098 37 0   43.96974651 -89.76782777 2021-12-03 04:23:05 Adams, Wisconsin, US
2021-12-02 US Wisconsin Ashland 55003 2142 22 0   46.31956891 -90.67837132 2021-12-03 04:23:05 Ashland, Wisconsin, US
2021-12-02 US Wisconsin Barron 55005 9708 101 0   45.42372701 -91.84833627 2021-12-03 04:23:05 Barron, Wisconsin, US
2021-12-02 US Wisconsin Bayfield 55007 2033 30 0   46.52868768 -91.19716729 2021-12-03 04:23:05 Bayfield, Wisconsin, US
2021-12-02 US Wisconsin Brown 55009 52545 335 0   44.452655299999996 -88.00411844 2021-12-03 04:23:05 Brown, Wisconsin, US
2021-12-02 US Wisconsin Buffalo 55011 2295 8 0   44.37835084 -91.75332578 2021-12-03 04:23:05 Buffalo, Wisconsin, US
2021-12-02 US Wisconsin Burnett 55013 2735 33 0   45.86303537 -92.36711412 2021-12-03 04:23:05 Burnett, Wisconsin, US
2021-12-02 US Wisconsin Calumet 55015 9664 73 0   44.0816316 -88.21780273 2021-12-03 04:23:05 Calumet, Wisconsin, US
2021-12-02 US Wisconsin Chippewa 55017 12504 129 0   45.06939744 -91.28068855 2021-12-03 04:23:05 Chippewa, Wisconsin, US
2021-12-02 US Wisconsin Clark 55019 5536 87 0   44.73483377 -90.61207486 2021-12-03 04:23:05 Clark, Wisconsin, US
2021-12-02 US Wisconsin Columbia 55021 9020 94 0   43.46492199 -89.33589004 2021-12-03 04:23:05 Columbia, Wisconsin, US
2021-12-02 US Wisconsin Crawford 55023 2691 23 0   43.23870316 -90.93073686 2021-12-03 04:23:05 Crawford, Wisconsin, US
2021-12-02 US Wisconsin Dane 55025 63152 388 0   43.06601594 -89.41733797 2021-12-03 04:23:05 Dane, Wisconsin, US
2021-12-02 US Wisconsin Dodge 55027 18185 239 0   43.41576662 -88.70928178 2021-12-03 04:23:05 Dodge, Wisconsin, US
2021-12-02 US Wisconsin Door 55029 4237 42 0   44.95856458 -87.30002707 2021-12-03 04:23:05 Door, Wisconsin, US
2021-12-02 US Wisconsin Douglas 55031 7409 66 0   46.43222285 -91.91595768 2021-12-03 04:23:05 Douglas, Wisconsin, US
2021-12-02 US Wisconsin Dunn 55033 8571 53 0   44.94562799 -91.8962481 2021-12-03 04:23:05 Dunn, Wisconsin, US
2021-12-02 US Wisconsin Eau Claire 55035 18770 152 0   44.726614 -91.28609183 2021-12-03 04:23:05 Eau Claire, Wisconsin, US
2021-12-02 US Wisconsin Florence 55037 721 14 0   45.84963535 -88.39804137 2021-12-03 04:23:05 Florence, Wisconsin, US
2021-12-02 US Wisconsin Fond du Lac 55039 20383 175 0   43.75354908 -88.48885325 2021-12-03 04:23:05 Fond du Lac, Wisconsin, US
2021-12-02 US Wisconsin Forest 55041 1736 33 0   45.66678019 -88.77084892 2021-12-03 04:23:05 Forest, Wisconsin, US
2021-12-02 US Wisconsin Grant 55043 8552 119 0   42.8671731 -90.7063218 2021-12-03 04:23:05 Grant, Wisconsin, US
2021-12-02 US Wisconsin Green 55045 5500 38 0   42.6794956 -89.60243287 2021-12-03 04:23:05 Green, Wisconsin, US
2021-12-02 US Wisconsin Green Lake 55047 3433 36 0   43.80025981 -89.04679553 2021-12-03 04:23:05 Green Lake, Wisconsin, US
2021-12-02 US Wisconsin Iowa 55049 3116 19 0   43.00050278 -90.13469017 2021-12-03 04:23:05 Iowa, Wisconsin, US
2021-12-02 US Wisconsin Iron 55051 980 43 0   46.26302338 -90.24295041 2021-12-03 04:23:05 Iron, Wisconsin, US
2021-12-02 US Wisconsin Jackson 55053 3844 35 0   44.31864893 -90.80566792 2021-12-03 04:23:05 Jackson, Wisconsin, US
2021-12-02 US Wisconsin Jefferson 55055 13603 167 0   43.02054068 -88.77529134 2021-12-03 04:23:05 Jefferson, Wisconsin, US
2021-12-02 US Wisconsin Juneau 55057 5027 44 0   43.92456975 -90.11120239 2021-12-03 04:23:05 Juneau, Wisconsin, US
2021-12-02 US Wisconsin Kenosha 55059 26787 412 0   42.57639354 -88.04051686 2021-12-03 04:23:05 Kenosha, Wisconsin, US
2021-12-02 US Wisconsin Kewaunee 55061 4120 49 0   44.51727459 -87.61468386 2021-12-03 04:23:05 Kewaunee, Wisconsin, US
2021-12-02 US Wisconsin La Crosse 55063 19850 125 0   43.90632465 -91.11451093 2021-12-03 04:23:05 La Crosse, Wisconsin, US
2021-12-02 US Wisconsin Lafayette 55065 2447 13 0   42.66005229 -90.1317729 2021-12-03 04:23:05 Lafayette, Wisconsin, US
2021-12-02 US Wisconsin Langlade 55067 3579 59 0   45.26271619 -89.07483625 2021-12-03 04:23:05 Langlade, Wisconsin, US
2021-12-02 US Wisconsin Lincoln 55069 4925 118 0   45.33737523 -89.73411273 2021-12-03 04:23:05 Lincoln, Wisconsin, US
2021-12-02 US Wisconsin Manitowoc 55071 13752 122 0   44.11946801 -87.80928853 2021-12-03 04:23:05 Manitowoc, Wisconsin, US
2021-12-02 US Wisconsin Marathon 55073 25385 328 0   44.89792533 -89.75863384 2021-12-03 04:23:05 Marathon, Wisconsin, US
2021-12-02 US Wisconsin Marinette 55075 8154 82 0   45.38553432 -88.03324599999998 2021-12-03 04:23:05 Marinette, Wisconsin, US
2021-12-02 US Wisconsin Marquette 55077 2658 37 0   43.81911946 -89.40073763 2021-12-03 04:23:05 Marquette, Wisconsin, US
2021-12-02 US Wisconsin Menominee 55078 1005 11 0   45.00422544 -88.70950714 2021-12-03 04:23:05 Menominee, Wisconsin, US
2021-12-02 US Wisconsin Milwaukee 55079 162672 1703 0   43.00486062 -87.96733172 2021-12-03 04:23:05 Milwaukee, Wisconsin, US
2021-12-02 US Wisconsin Monroe 55081 7653 58 0   43.94641218 -90.61881899999999 2021-12-03 04:23:05 Monroe, Wisconsin, US
2021-12-02 US Wisconsin Oconto 55083 8017 78 0   45.02715345 -88.26807503 2021-12-03 04:23:05 Oconto, Wisconsin, US
2021-12-02 US Wisconsin Oneida 55085 5854 101 0   45.70677897 -89.51944105 2021-12-03 04:23:05 Oneida, Wisconsin, US
2021-12-02 US Wisconsin Outagamie 55087 35200 287 0   44.41578887 -88.46565023 2021-12-03 04:23:05 Outagamie, Wisconsin, US
2021-12-02 US Wisconsin Ozaukee 55089 13807 123 0   43.38352225 -87.94625009 2021-12-03 04:23:05 Ozaukee, Wisconsin, US
2021-12-02 US Wisconsin Pepin 55091 1337 10 0   44.58307413 -91.99949611 2021-12-03 04:23:05 Pepin, Wisconsin, US
2021-12-02 US Wisconsin Pierce 55093 7617 55 0   44.71850291 -92.4224416 2021-12-03 04:23:05 Pierce, Wisconsin, US
2021-12-02 US Wisconsin Polk 55095 8425 93 0   45.46130348 -92.44182875 2021-12-03 04:23:05 Polk, Wisconsin, US
2021-12-02 US Wisconsin Portage 55097 11175 111 0   44.47558711 -89.50152965 2021-12-03 04:23:05 Portage, Wisconsin, US
2021-12-02 US Wisconsin Price 55099 2235 16 0   45.68051754 -90.36098879999999 2021-12-03 04:23:05 Price, Wisconsin, US
2021-12-02 US Wisconsin Racine 55101 35260 483 0   42.74753117 -88.05941254 2021-12-03 04:23:05 Racine, Wisconsin, US
2021-12-02 US Wisconsin Richland 55103 2527 31 0   43.3762778 -90.43012729 2021-12-03 04:23:05 Richland, Wisconsin, US
2021-12-02 US Wisconsin Rock 55105 25237 261 0   42.67151616 -89.07147900000002 2021-12-03 04:23:05 Rock, Wisconsin, US
2021-12-02 US Wisconsin Rusk 55107 2455 37 0   45.47498854 -91.1333012 2021-12-03 04:23:05 Rusk, Wisconsin, US
2021-12-02 US Wisconsin Sauk 55111 9800 75 0   43.42574087 -89.94966132 2021-12-03 04:23:05 Sauk, Wisconsin, US
2021-12-02 US Wisconsin Sawyer 55113 3191 39 0   45.87931905 -91.14504927 2021-12-03 04:23:05 Sawyer, Wisconsin, US
2021-12-02 US Wisconsin Shawano 55115 7952 97 0   44.78902246 -88.76443896 2021-12-03 04:23:05 Shawano, Wisconsin, US
2021-12-02 US Wisconsin Sheboygan 55117 21073 196 0   43.72099677 -87.94579284 2021-12-03 04:23:05 Sheboygan, Wisconsin, US
2021-12-02 US Wisconsin St. Croix 55109 16232 94 0   45.03437474 -92.45000068 2021-12-03 04:23:05 St. Croix, Wisconsin, US
2021-12-02 US Wisconsin Taylor 55119 3505 49 0   45.21179252 -90.5004405 2021-12-03 04:23:05 Taylor, Wisconsin, US
2021-12-02 US Wisconsin Trempealeau 55121 5609 52 0   44.30360275 -91.35893614 2021-12-03 04:23:05 Trempealeau, Wisconsin, US
2021-12-02 US Wisconsin Unassigned 90055 0 0 0   46.52868768 0.0 2021-12-03 04:23:05 Unassigned, Wisconsin, US
2021-12-02 US Wisconsin Vernon 55123 3574 69 0   43.59422667 -90.8324691 2021-12-03 04:23:05 Vernon, Wisconsin, US
2021-12-02 US Wisconsin Vilas 55125 3469 62 0   46.05467334 -89.51719204 2021-12-03 04:23:05 Vilas, Wisconsin, US
2021-12-02 US Wisconsin Walworth 55127 17569 201 0   42.66858202 -88.54163073 2021-12-03 04:23:05 Walworth, Wisconsin, US
2021-12-02 US Wisconsin Washburn 55129 2822 30 0   45.89838588 -91.79050449 2021-12-03 04:23:05 Washburn, Wisconsin, US
2021-12-02 US Wisconsin Washington 55131 25713 233 0   43.36863664 -88.22974712 2021-12-03 04:23:05 Washington, Wisconsin, US
2021-12-02 US Wisconsin Waukesha 55133 70503 769 0   43.01833055 -88.30431188 2021-12-03 04:23:05 Waukesha, Wisconsin, US
2021-12-02 US Wisconsin Waupaca 55135 9498 197 0   44.47068056 -88.96534501 2021-12-03 04:23:05 Waupaca, Wisconsin, US
2021-12-02 US Wisconsin Waushara 55137 4130 59 0   44.11324419 -89.24317107 2021-12-03 04:23:05 Waushara, Wisconsin, US
2021-12-02 US Wisconsin Winnebago 55139 31510 286 0   44.06886922 -88.64477096 2021-12-03 04:23:05 Winnebago, Wisconsin, US
2021-12-02 US Wisconsin Wood 55141 12913 149 0   44.45537896 -90.04158336 2021-12-03 04:23:05 Wood, Wisconsin, US
2021-10-28 US Wisconsin Adams 55001 2764 33 0   43.96974651 -89.76782777 2021-10-29 04:22:03 Adams, Wisconsin, US
2021-10-28 US Wisconsin Ashland 55003 1849 17 0   46.31956891 -90.67837132 2021-10-29 04:22:03 Ashland, Wisconsin, US
2021-10-28 US Wisconsin Barron 55005 8431 94 0   45.42372701 -91.84833627 2021-10-29 04:22:03 Barron, Wisconsin, US
2021-10-28 US Wisconsin Bayfield 55007 1667 25 0   46.52868768 -91.19716729 2021-10-29 04:22:03 Bayfield, Wisconsin, US
2021-10-28 US Wisconsin Brown 55009 46166 322 0   44.452655299999996 -88.00411844 2021-10-29 04:22:03 Brown, Wisconsin, US
2021-10-28 US Wisconsin Buffalo 55011 1995 8 0   44.37835084 -91.75332578 2021-10-29 04:22:03 Buffalo, Wisconsin, US
2021-10-28 US Wisconsin Burnett 55013 2274 32 0   45.86303537 -92.36711412 2021-10-29 04:22:03 Burnett, Wisconsin, US
2021-10-28 US Wisconsin Calumet 55015 8417 59 0   44.0816316 -88.21780273 2021-10-29 04:22:03 Calumet, Wisconsin, US
2021-10-28 US Wisconsin Chippewa 55017 10987 116 0   45.06939744 -91.28068855 2021-10-29 04:22:03 Chippewa, Wisconsin, US
2021-10-28 US Wisconsin Clark 55019 4811 79 0   44.73483377 -90.61207486 2021-10-29 04:22:03 Clark, Wisconsin, US
2021-10-28 US Wisconsin Columbia 55021 8011 80 0   43.46492199 -89.33589004 2021-10-29 04:22:03 Columbia, Wisconsin, US
2021-10-28 US Wisconsin Crawford 55023 2328 22 0   43.23870316 -90.93073686 2021-10-29 04:22:03 Crawford, Wisconsin, US
2021-10-28 US Wisconsin Dane 55025 57867 371 0   43.06601594 -89.41733797 2021-10-29 04:22:03 Dane, Wisconsin, US
2021-10-28 US Wisconsin Dodge 55027 16132 228 0   43.41576662 -88.70928178 2021-10-29 04:22:03 Dodge, Wisconsin, US
2021-10-28 US Wisconsin Door 55029 3798 39 0   44.95856458 -87.30002707 2021-10-29 04:22:03 Door, Wisconsin, US
2021-10-28 US Wisconsin Douglas 55031 6090 66 0   46.43222285 -91.91595768 2021-10-29 04:22:03 Douglas, Wisconsin, US
2021-10-28 US Wisconsin Dunn 55033 7072 46 0   44.94562799 -91.8962481 2021-10-29 04:22:03 Dunn, Wisconsin, US
2021-10-28 US Wisconsin Eau Claire 55035 16406 139 0   44.726614 -91.28609183 2021-10-29 04:22:03 Eau Claire, Wisconsin, US
2021-10-28 US Wisconsin Florence 55037 651 14 0   45.84963535 -88.39804137 2021-10-29 04:22:03 Florence, Wisconsin, US
2021-10-28 US Wisconsin Fond du Lac 55039 18216 161 0   43.75354908 -88.48885325 2021-10-29 04:22:03 Fond du Lac, Wisconsin, US
2021-10-28 US Wisconsin Forest 55041 1526 31 0   45.66678019 -88.77084892 2021-10-29 04:22:03 Forest, Wisconsin, US
2021-10-28 US Wisconsin Grant 55043 7622 117 0   42.8671731 -90.7063218 2021-10-29 04:22:03 Grant, Wisconsin, US
2021-10-28 US Wisconsin Green 55045 4628 33 0   42.6794956 -89.60243287 2021-10-29 04:22:03 Green, Wisconsin, US
2021-10-28 US Wisconsin Green Lake 55047 3078 32 0   43.80025981 -89.04679553 2021-10-29 04:22:03 Green Lake, Wisconsin, US
2021-10-28 US Wisconsin Iowa 55049 2775 17 0   43.00050278 -90.13469017 2021-10-29 04:22:03 Iowa, Wisconsin, US
2021-10-28 US Wisconsin Iron 55051 899 42 0   46.26302338 -90.24295041 2021-10-29 04:22:03 Iron, Wisconsin, US
2021-10-28 US Wisconsin Jackson 55053 3433 32 0   44.31864893 -90.80566792 2021-10-29 04:22:03 Jackson, 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;