johns_hopkins_csse_daily_reports

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

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

10,101 rows where province_or_state = "Wisconsin" sorted by day descending

View and edit SQL

Suggested facets: recovered, day (date)

province_or_state

  • Wisconsin · 10,101

country_or_region

  • US 10,101
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
496170 2020-08-11 US Wisconsin Polk 55095 137 2 0 135 45.46130348 -92.44182875 2020-08-12 04:27:29 Polk, Wisconsin, US
496171 2020-08-11 US Wisconsin Juneau 55057 138 1 0 137 43.92456975 -90.11120239 2020-08-12 04:27:29 Juneau, Wisconsin, US
496172 2020-08-11 US Wisconsin St. Croix 55109 512 5 0 507 45.03437474 -92.45000068 2020-08-12 04:27:29 St. Croix, Wisconsin, US
496173 2020-08-11 US Wisconsin Ozaukee 55089 716 17 0 699 43.38352225 -87.94625009 2020-08-12 04:27:29 Ozaukee, Wisconsin, US
496174 2020-08-11 US Wisconsin Fond du Lac 55039 676 7 0 669 43.75354908 -88.48885325 2020-08-12 04:27:29 Fond du Lac, Wisconsin, US
496175 2020-08-11 US Wisconsin Walworth 55127 1359 23 0 1336 42.66858202 -88.54163073 2020-08-12 04:27:29 Walworth, Wisconsin, US
496176 2020-08-11 US Wisconsin Rock 55105 1444 26 0 1418 42.67151616 -89.07147900000002 2020-08-12 04:27:29 Rock, Wisconsin, US
496177 2020-08-11 US Wisconsin Waukesha 55133 4354 59 0 4295 43.01833055 -88.30431188 2020-08-12 04:27:29 Waukesha, Wisconsin, US
496909 2020-08-11 US Wisconsin Green Lake 55047 57 0 0 57 43.80025981 -89.04679553 2020-08-12 04:27:29 Green Lake, Wisconsin, US
496910 2020-08-11 US Wisconsin Iowa 55049 83 0 0 83 43.00050278 -90.13469017 2020-08-12 04:27:29 Iowa, Wisconsin, US
496911 2020-08-11 US Wisconsin Waushara 55137 120 1 0 119 44.11324419 -89.24317107 2020-08-12 04:27:29 Waushara, Wisconsin, US
496912 2020-08-11 US Wisconsin Sheboygan 55117 776 8 0 768 43.72099677 -87.94579284 2020-08-12 04:27:29 Sheboygan, Wisconsin, US
497410 2020-08-11 US Wisconsin Iron 55051 76 1 0 75 46.26302338 -90.24295041 2020-08-12 04:27:29 Iron, Wisconsin, US
497411 2020-08-11 US Wisconsin Burnett 55013 22 1 0 21 45.86303537 -92.36711412 2020-08-12 04:27:29 Burnett, Wisconsin, US
497412 2020-08-11 US Wisconsin Price 55099 33 0 0 33 45.68051754 -90.3609888 2020-08-12 04:27:29 Price, Wisconsin, US
497413 2020-08-11 US Wisconsin Kewaunee 55061 135 2 0 133 44.51727459 -87.61468386 2020-08-12 04:27:29 Kewaunee, Wisconsin, US
497414 2020-08-11 US Wisconsin Sawyer 55113 76 0 0 76 45.87931905 -91.14504927 2020-08-12 04:27:29 Sawyer, Wisconsin, US
497415 2020-08-11 US Wisconsin Crawford 55023 76 0 0 76 43.23870316 -90.93073686 2020-08-12 04:27:29 Crawford, Wisconsin, US
497416 2020-08-11 US Wisconsin Dunn 55033 128 0 0 128 44.94562799 -91.8962481 2020-08-12 04:27:29 Dunn, Wisconsin, US
497417 2020-08-11 US Wisconsin Waupaca 55135 473 15 0 458 44.47068056 -88.96534501 2020-08-12 04:27:29 Waupaca, Wisconsin, US
497418 2020-08-11 US Wisconsin Jefferson 55055 647 5 0 642 43.02054068 -88.77529134 2020-08-12 04:27:29 Jefferson, Wisconsin, US
497844 2020-08-11 US Wisconsin Vernon 55123 66 0 0 66 43.59422667 -90.8324691 2020-08-12 04:27:29 Vernon, Wisconsin, US
497845 2020-08-11 US Wisconsin Door 55029 107 3 0 104 44.95856458 -87.30002707 2020-08-12 04:27:29 Door, Wisconsin, US
497846 2020-08-11 US Wisconsin Wood 55141 322 2 0 320 44.45537896 -90.04158336 2020-08-12 04:27:29 Wood, Wisconsin, US
497847 2020-08-11 US Wisconsin La Crosse 55063 921 1 0 920 43.90632465 -91.11451093 2020-08-12 04:27:29 La Crosse, Wisconsin, US
498356 2020-08-11 US Wisconsin Rusk 55107 21 1 0 20 45.47498854 -91.1333012 2020-08-12 04:27:29 Rusk, Wisconsin, US
498357 2020-08-11 US Wisconsin Trempealeau 55121 345 2 0 343 44.30360275 -91.35893614 2020-08-12 04:27:29 Trempealeau, Wisconsin, US
498358 2020-08-11 US Wisconsin Jackson 55053 58 1 0 57 44.31864893 -90.80566792 2020-08-12 04:27:29 Jackson, Wisconsin, US
498359 2020-08-11 US Wisconsin Barron 55005 296 3 0 293 45.42372701 -91.84833627 2020-08-12 04:27:29 Barron, Wisconsin, US
498360 2020-08-11 US Wisconsin Monroe 55081 245 2 0 243 43.94641218 -90.618819 2020-08-12 04:27:29 Monroe, Wisconsin, US
498361 2020-08-11 US Wisconsin Chippewa 55017 241 0 0 241 45.06939744 -91.28068855 2020-08-12 04:27:29 Chippewa, Wisconsin, US
498362 2020-08-11 US Wisconsin Kenosha 55059 2692 60 0 2632 42.57639354 -88.04051686 2020-08-12 04:27:29 Kenosha, Wisconsin, US
498363 2020-08-11 US Wisconsin Racine 55101 3567 79 0 3488 42.74753117 -88.05941254 2020-08-12 04:27:29 Racine, Wisconsin, US
498866 2020-08-11 US Wisconsin Forest 55041 60 4 0 56 45.66678019 -88.77084892 2020-08-12 04:27:29 Forest, Wisconsin, US
498867 2020-08-11 US Wisconsin Taylor 55119 71 1 0 70 45.21179252 -90.5004405 2020-08-12 04:27:29 Taylor, Wisconsin, US
498868 2020-08-11 US Wisconsin Marquette 55077 80 1 0 79 43.81911946 -89.40073763 2020-08-12 04:27:29 Marquette, Wisconsin, US
498869 2020-08-11 US Wisconsin Adams 55001 86 2 0 84 43.96974651 -89.76782777 2020-08-12 04:27:29 Adams, Wisconsin, US
498870 2020-08-11 US Wisconsin Douglas 55031 191 0 0 191 46.43222285 -91.91595768 2020-08-12 04:27:29 Douglas, Wisconsin, US
498871 2020-08-11 US Wisconsin Green 55045 169 1 0 168 42.6794956 -89.60243287 2020-08-12 04:27:29 Green, Wisconsin, US
498872 2020-08-11 US Wisconsin Sauk 55111 452 3 0 449 43.42574087 -89.94966132 2020-08-12 04:27:29 Sauk, Wisconsin, US
498873 2020-08-11 US Wisconsin Dodge 55027 845 5 0 840 43.41576662 -88.70928178 2020-08-12 04:27:29 Dodge, Wisconsin, US
498874 2020-08-11 US Wisconsin Unassigned 90055 0 0 0 0 46.52868768 0.0 2020-08-12 04:27:29 Unassigned, Wisconsin, US
499340 2020-08-11 US Wisconsin Florence 55037 8 0 0 8 45.84963535 -88.39804137 2020-08-12 04:27:29 Florence, Wisconsin, US
499341 2020-08-11 US Wisconsin Pepin 55091 42 0 0 42 44.58307413 -91.99949611 2020-08-12 04:27:29 Pepin, Wisconsin, US
499342 2020-08-11 US Wisconsin Buffalo 55011 44 2 0 42 44.37835084 -91.75332578 2020-08-12 04:27:29 Buffalo, Wisconsin, US
499343 2020-08-11 US Wisconsin Menominee 55078 25 0 0 25 45.00422544 -88.70950714 2020-08-12 04:27:29 Menominee, Wisconsin, US
499344 2020-08-11 US Wisconsin Washburn 55129 47 0 0 47 45.89838588 -91.79050449 2020-08-12 04:27:29 Washburn, Wisconsin, US
499345 2020-08-11 US Wisconsin Richland 55103 37 4 0 33 43.3762778 -90.43012729 2020-08-12 04:27:29 Richland, Wisconsin, US
499346 2020-08-11 US Wisconsin Oneida 55085 153 0 0 153 45.70677897 -89.51944105 2020-08-12 04:27:29 Oneida, Wisconsin, US
499347 2020-08-11 US Wisconsin Shawano 55115 204 0 0 204 44.78902246 -88.76443896 2020-08-12 04:27:29 Shawano, Wisconsin, US
499348 2020-08-11 US Wisconsin Grant 55043 362 15 0 347 42.8671731 -90.7063218 2020-08-12 04:27:29 Grant, Wisconsin, US
499349 2020-08-11 US Wisconsin Portage 55097 426 0 0 426 44.47558711 -89.50152965 2020-08-12 04:27:29 Portage, Wisconsin, US
499350 2020-08-11 US Wisconsin Columbia 55021 255 2 0 253 43.46492199 -89.33589004 2020-08-12 04:27:29 Columbia, Wisconsin, US
499351 2020-08-11 US Wisconsin Manitowoc 55071 351 1 0 350 44.11946801 -87.80928853 2020-08-12 04:27:29 Manitowoc, Wisconsin, US
499352 2020-08-11 US Wisconsin Eau Claire 55035 596 4 0 592 44.726614 -91.28609183 2020-08-12 04:27:29 Eau Claire, Wisconsin, US
499353 2020-08-11 US Wisconsin Outagamie 55087 1299 14 0 1285 44.41578887 -88.46565023 2020-08-12 04:27:29 Outagamie, Wisconsin, US
499354 2020-08-11 US Wisconsin Winnebago 55139 1212 18 0 1194 44.06886922 -88.64477096 2020-08-12 04:27:29 Winnebago, Wisconsin, US
499753 2020-08-11 US Wisconsin Ashland 55003 26 1 0 25 46.31956891 -90.67837132 2020-08-12 04:27:29 Ashland, Wisconsin, US
499754 2020-08-11 US Wisconsin Bayfield 55007 29 1 0 28 46.52868768 -91.19716729 2020-08-12 04:27:29 Bayfield, Wisconsin, US
499755 2020-08-11 US Wisconsin Vilas 55125 60 0 0 60 46.05467334 -89.51719204 2020-08-12 04:27:29 Vilas, Wisconsin, US
499756 2020-08-11 US Wisconsin Lincoln 55069 69 0 0 69 45.33737523 -89.73411273 2020-08-12 04:27:29 Lincoln, Wisconsin, US
499757 2020-08-11 US Wisconsin Clark 55019 189 8 0 181 44.73483377 -90.61207486 2020-08-12 04:27:29 Clark, Wisconsin, US
499758 2020-08-11 US Wisconsin Pierce 55093 224 3 0 221 44.71850291 -92.4224416 2020-08-12 04:27:29 Pierce, Wisconsin, US
499759 2020-08-11 US Wisconsin Calumet 55015 334 2 0 332 44.0816316 -88.21780273 2020-08-12 04:27:29 Calumet, Wisconsin, US
500007 2020-08-11 US Wisconsin Langlade 55067 63 1 0 62 45.26271619 -89.07483625 2020-08-12 04:27:29 Langlade, Wisconsin, US
500008 2020-08-11 US Wisconsin Lafayette 55065 147 0 0 147 42.66005229 -90.1317729 2020-08-12 04:27:29 Lafayette, Wisconsin, US
500009 2020-08-11 US Wisconsin Oconto 55083 259 0 0 259 45.02715345 -88.26807503 2020-08-12 04:27:29 Oconto, Wisconsin, US
500010 2020-08-11 US Wisconsin Marinette 55075 432 4 0 428 45.38553432 -88.03324599999998 2020-08-12 04:27:29 Marinette, Wisconsin, US
500011 2020-08-11 US Wisconsin Marathon 55073 662 10 0 652 44.89792533 -89.75863384 2020-08-12 04:27:29 Marathon, Wisconsin, US
500012 2020-08-11 US Wisconsin Washington 55131 1108 22 0 1086 43.36863664 -88.22974712 2020-08-12 04:27:29 Washington, Wisconsin, US
500013 2020-08-11 US Wisconsin Brown 55009 4340 54 0 4286 44.4526553 -88.00411844 2020-08-12 04:27:29 Brown, Wisconsin, US
500014 2020-08-11 US Wisconsin Dane 55025 4578 38 0 4540 43.06601594 -89.41733797 2020-08-12 04:27:29 Dane, Wisconsin, US
500015 2020-08-11 US Wisconsin Milwaukee 55079 21331 458 0 20873 43.00486062 -87.96733172 2020-08-12 04:27:29 Milwaukee, Wisconsin, US
274097 2020-08-10 US Wisconsin Adams 55001 86 2 0 84 43.96974651 -89.76782777 2020-08-11 04:35:08 Adams, Wisconsin, US
274177 2020-08-10 US Wisconsin Ashland 55003 25 1 0 24 46.31956891 -90.67837132 2020-08-11 04:35:08 Ashland, Wisconsin, US
274225 2020-08-10 US Wisconsin Barron 55005 295 3 0 292 45.42372701 -91.84833627 2020-08-11 04:35:08 Barron, Wisconsin, US
274241 2020-08-10 US Wisconsin Bayfield 55007 28 1 0 27 46.52868768 -91.19716729 2020-08-11 04:35:08 Bayfield, Wisconsin, US
274379 2020-08-10 US Wisconsin Brown 55009 4264 54 0 4210 44.4526553 -88.00411844 2020-08-11 04:35:08 Brown, Wisconsin, US
274394 2020-08-10 US Wisconsin Buffalo 55011 44 2 0 42 44.37835084 -91.75332578 2020-08-11 04:35:08 Buffalo, Wisconsin, US
274407 2020-08-10 US Wisconsin Burnett 55013 22 1 0 21 45.86303537 -92.36711412 2020-08-11 04:35:08 Burnett, Wisconsin, US
274448 2020-08-10 US Wisconsin Calumet 55015 330 2 0 328 44.0816316 -88.21780273 2020-08-11 04:35:08 Calumet, Wisconsin, US
274589 2020-08-10 US Wisconsin Chippewa 55017 239 0 0 239 45.06939744 -91.28068855 2020-08-11 04:35:08 Chippewa, Wisconsin, US
274625 2020-08-10 US Wisconsin Clark 55019 188 7 0 181 44.73483377 -90.61207486 2020-08-11 04:35:08 Clark, Wisconsin, US
274707 2020-08-10 US Wisconsin Columbia 55021 252 1 0 251 43.46492199 -89.33589004 2020-08-11 04:35:08 Columbia, Wisconsin, US
274762 2020-08-10 US Wisconsin Crawford 55023 75 0 0 75 43.23870316 -90.93073686 2020-08-11 04:35:08 Crawford, Wisconsin, US
274810 2020-08-10 US Wisconsin Dane 55025 4554 38 0 4516 43.06601594 -89.41733797 2020-08-11 04:35:08 Dane, Wisconsin, US
274893 2020-08-10 US Wisconsin Dodge 55027 835 5 0 830 43.41576662 -88.70928178 2020-08-11 04:35:08 Dodge, Wisconsin, US
274899 2020-08-10 US Wisconsin Door 55029 106 3 0 103 44.95856458 -87.30002707 2020-08-11 04:35:08 Door, Wisconsin, US
274915 2020-08-10 US Wisconsin Douglas 55031 186 0 0 186 46.43222285 -91.91595768 2020-08-11 04:35:08 Douglas, Wisconsin, US
274924 2020-08-10 US Wisconsin Dunn 55033 126 0 0 126 44.94562799 -91.8962481 2020-08-11 04:35:08 Dunn, Wisconsin, US
274938 2020-08-10 US Wisconsin Eau Claire 55035 590 4 0 586 44.726614 -91.28609183 2020-08-11 04:35:08 Eau Claire, Wisconsin, US
275031 2020-08-10 US Wisconsin Florence 55037 8 0 0 8 45.84963535 -88.39804137 2020-08-11 04:35:08 Florence, Wisconsin, US
275041 2020-08-10 US Wisconsin Fond du Lac 55039 671 7 0 664 43.75354908 -88.48885325 2020-08-11 04:35:08 Fond du Lac, Wisconsin, US
275045 2020-08-10 US Wisconsin Forest 55041 59 4 0 55 45.66678019 -88.77084892 2020-08-11 04:35:08 Forest, Wisconsin, US
275189 2020-08-10 US Wisconsin Grant 55043 357 15 0 342 42.8671731 -90.7063218 2020-08-11 04:35:08 Grant, Wisconsin, US
275202 2020-08-10 US Wisconsin Green 55045 167 1 0 166 42.6794956 -89.60243287 2020-08-11 04:35:08 Green, Wisconsin, US
275203 2020-08-10 US Wisconsin Green Lake 55047 56 0 0 56 43.80025981 -89.04679553 2020-08-11 04:35:08 Green Lake, Wisconsin, US
275446 2020-08-10 US Wisconsin Iowa 55049 82 0 0 82 43.00050278 -90.13469017 2020-08-11 04:35:08 Iowa, Wisconsin, US
275451 2020-08-10 US Wisconsin Iron 55051 75 1 0 74 46.26302338 -90.24295041 2020-08-11 04:35:08 Iron, Wisconsin, US
275487 2020-08-10 US Wisconsin Jackson 55053 58 1 0 57 44.31864893 -90.80566792 2020-08-11 04:35:08 Jackson, Wisconsin, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [johns_hopkins_csse_daily_reports] (
   [day] TEXT,
   [country_or_region] TEXT,
   [province_or_state] TEXT,
   [admin2] TEXT,
   [fips] TEXT,
   [confirmed] INTEGER,
   [deaths] INTEGER,
   [recovered] INTEGER,
   [active] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day]
                ON [johns_hopkins_csse_daily_reports] ([day]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state]
                ON [johns_hopkins_csse_daily_reports] ([province_or_state]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region]
                ON [johns_hopkins_csse_daily_reports] ([country_or_region]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key]
                ON [johns_hopkins_csse_daily_reports] ([combined_key]);
Powered by Datasette · Query took 1990.081ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette