home / covid

Menu
  • GraphQL API

johns_hopkins_csse_daily_reports

Table actions
  • GraphQL API for 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

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

✎ View and edit SQL

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

Suggested facets: day (date), last_update (date)

province_or_state 1

  • Wisconsin · 73,611 ✖

country_or_region 1

  • US 73,611
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2756434 2756434 2022-12-29 US Wisconsin Adams 55001 5715 70 0   43.96974651 -89.76782777 2022-12-30 04:21:04 Adams, Wisconsin, US
2756435 2756435 2022-12-29 US Wisconsin Ashland 55003 4077 42 0   46.31956891 -90.67837132 2022-12-30 04:21:04 Ashland, Wisconsin, US
2756436 2756436 2022-12-29 US Wisconsin Barron 55005 15829 151 0   45.42372701 -91.84833627 2022-12-30 04:21:04 Barron, Wisconsin, US
2756437 2756437 2022-12-29 US Wisconsin Bayfield 55007 4276 44 0   46.52868768 -91.19716729 2022-12-30 04:21:04 Bayfield, Wisconsin, US
2756438 2756438 2022-12-29 US Wisconsin Brown 55009 101045 608 0   44.4526553 -88.00411844 2022-12-30 04:21:04 Brown, Wisconsin, US
2756439 2756439 2022-12-29 US Wisconsin Buffalo 55011 4131 14 0   44.37835084 -91.75332578 2022-12-30 04:21:04 Buffalo, Wisconsin, US
2756440 2756440 2022-12-29 US Wisconsin Burnett 55013 5019 45 0   45.86303537 -92.36711412 2022-12-30 04:21:04 Burnett, Wisconsin, US
2756441 2756441 2022-12-29 US Wisconsin Calumet 55015 16630 129 0   44.0816316 -88.21780273 2022-12-30 04:21:04 Calumet, Wisconsin, US
2756442 2756442 2022-12-29 US Wisconsin Chippewa 55017 21716 210 0   45.06939744 -91.28068855 2022-12-30 04:21:04 Chippewa, Wisconsin, US
2756443 2756443 2022-12-29 US Wisconsin Clark 55019 8824 129 0   44.73483377 -90.61207486 2022-12-30 04:21:04 Clark, Wisconsin, US
2756444 2756444 2022-12-29 US Wisconsin Columbia 55021 19191 146 0   43.46492199 -89.33589004 2022-12-30 04:21:04 Columbia, Wisconsin, US
2756445 2756445 2022-12-29 US Wisconsin Crawford 55023 5279 32 0   43.23870316 -90.93073686 2022-12-30 04:21:04 Crawford, Wisconsin, US
2756446 2756446 2022-12-29 US Wisconsin Dane 55025 175003 615 0   43.06601594 -89.41733797 2022-12-30 04:21:04 Dane, Wisconsin, US
2756447 2756447 2022-12-29 US Wisconsin Dodge 55027 32122 363 0   43.41576662 -88.70928178 2022-12-30 04:21:04 Dodge, Wisconsin, US
2756448 2756448 2022-12-29 US Wisconsin Door 55029 8595 85 0   44.95856458 -87.30002707 2022-12-30 04:21:04 Door, Wisconsin, US
2756449 2756449 2022-12-29 US Wisconsin Douglas 55031 14174 88 0   46.43222285 -91.91595768 2022-12-30 04:21:04 Douglas, Wisconsin, US
2756450 2756450 2022-12-29 US Wisconsin Dunn 55033 15324 81 0   44.94562799 -91.8962481 2022-12-30 04:21:04 Dunn, Wisconsin, US
2756451 2756451 2022-12-29 US Wisconsin Eau Claire 55035 35946 210 0   44.726614 -91.28609183 2022-12-30 04:21:04 Eau Claire, Wisconsin, US
2756452 2756452 2022-12-29 US Wisconsin Florence 55037 1325 17 0   45.84963535 -88.39804137 2022-12-30 04:21:04 Florence, Wisconsin, US
2756453 2756453 2022-12-29 US Wisconsin Fond du Lac 55039 38452 307 0   43.75354908 -88.48885325 2022-12-30 04:21:04 Fond du Lac, Wisconsin, US
2756454 2756454 2022-12-29 US Wisconsin Forest 55041 3272 54 0   45.66678019 -88.77084892 2022-12-30 04:21:04 Forest, Wisconsin, US
2756455 2756455 2022-12-29 US Wisconsin Grant 55043 15209 160 0   42.8671731 -90.7063218 2022-12-30 04:21:04 Grant, Wisconsin, US
2756456 2756456 2022-12-29 US Wisconsin Green 55045 11356 60 0   42.6794956 -89.60243287 2022-12-30 04:21:04 Green, Wisconsin, US
2756457 2756457 2022-12-29 US Wisconsin Green Lake 55047 6245 71 0   43.80025981 -89.04679553 2022-12-30 04:21:04 Green Lake, Wisconsin, US
2756458 2756458 2022-12-29 US Wisconsin Iowa 55049 6749 32 0   43.00050278 -90.13469017 2022-12-30 04:21:04 Iowa, Wisconsin, US
2756459 2756459 2022-12-29 US Wisconsin Iron 55051 1782 49 0   46.26302338 -90.24295041 2022-12-30 04:21:04 Iron, Wisconsin, US
2756460 2756460 2022-12-29 US Wisconsin Jackson 55053 6754 45 0   44.31864893 -90.80566792 2022-12-30 04:21:04 Jackson, Wisconsin, US
2756461 2756461 2022-12-29 US Wisconsin Jefferson 55055 26271 258 0   43.02054068 -88.77529134 2022-12-30 04:21:04 Jefferson, Wisconsin, US
2756462 2756462 2022-12-29 US Wisconsin Juneau 55057 9241 75 0   43.92456975 -90.11120239 2022-12-30 04:21:04 Juneau, Wisconsin, US
2756463 2756463 2022-12-29 US Wisconsin Kenosha 55059 55048 701 0   42.57639354 -88.04051686 2022-12-30 04:21:04 Kenosha, Wisconsin, US
2756464 2756464 2022-12-29 US Wisconsin Kewaunee 55061 6699 64 0   44.51727459 -87.61468386 2022-12-30 04:21:04 Kewaunee, Wisconsin, US
2756465 2756465 2022-12-29 US Wisconsin La Crosse 55063 42689 205 0   43.90632465 -91.11451093 2022-12-30 04:21:04 La Crosse, Wisconsin, US
2756466 2756466 2022-12-29 US Wisconsin Lafayette 55065 4367 30 0   42.66005229 -90.1317729 2022-12-30 04:21:04 Lafayette, Wisconsin, US
2756467 2756467 2022-12-29 US Wisconsin Langlade 55067 6541 103 0   45.26271619 -89.07483625 2022-12-30 04:21:04 Langlade, Wisconsin, US
2756468 2756468 2022-12-29 US Wisconsin Lincoln 55069 8794 157 0   45.33737523 -89.73411273 2022-12-30 04:21:04 Lincoln, Wisconsin, US
2756469 2756469 2022-12-29 US Wisconsin Manitowoc 55071 24595 212 0   44.11946801 -87.80928853 2022-12-30 04:21:04 Manitowoc, Wisconsin, US
2756470 2756470 2022-12-29 US Wisconsin Marathon 55073 48222 537 0   44.89792533 -89.75863384 2022-12-30 04:21:04 Marathon, Wisconsin, US
2756471 2756471 2022-12-29 US Wisconsin Marinette 55075 14135 147 0   45.38553432 -88.033246 2022-12-30 04:21:04 Marinette, Wisconsin, US
2756472 2756472 2022-12-29 US Wisconsin Marquette 55077 4551 67 0   43.81911946 -89.40073763 2022-12-30 04:21:04 Marquette, Wisconsin, US
2756473 2756473 2022-12-29 US Wisconsin Menominee 55078 2284 15 0   45.00422544 -88.70950714 2022-12-30 04:21:04 Menominee, Wisconsin, US
2756474 2756474 2022-12-29 US Wisconsin Milwaukee 55079 332557 2431 0   43.00486062 -87.96733172 2022-12-30 04:21:04 Milwaukee, Wisconsin, US
2756475 2756475 2022-12-29 US Wisconsin Monroe 55081 14359 106 0   43.94641218 -90.618819 2022-12-30 04:21:04 Monroe, Wisconsin, US
2756476 2756476 2022-12-29 US Wisconsin Oconto 55083 13144 129 0   45.02715345 -88.26807503 2022-12-30 04:21:04 Oconto, Wisconsin, US
2756477 2756477 2022-12-29 US Wisconsin Oneida 55085 10673 148 0   45.70677897 -89.51944105 2022-12-30 04:21:04 Oneida, Wisconsin, US
2756478 2756478 2022-12-29 US Wisconsin Outagamie 55087 63594 439 0   44.41578887 -88.46565023 2022-12-30 04:21:04 Outagamie, Wisconsin, US
2756479 2756479 2022-12-29 US Wisconsin Ozaukee 55089 27248 199 0   43.38352225 -87.94625009 2022-12-30 04:21:04 Ozaukee, Wisconsin, US
2756480 2756480 2022-12-29 US Wisconsin Pepin 55091 2270 19 0   44.58307413 -91.99949611 2022-12-30 04:21:04 Pepin, Wisconsin, US
2756481 2756481 2022-12-29 US Wisconsin Pierce 55093 13261 77 0   44.71850291 -92.4224416 2022-12-30 04:21:04 Pierce, Wisconsin, US
2756482 2756482 2022-12-29 US Wisconsin Polk 55095 14837 125 0   45.46130348 -92.44182875 2022-12-30 04:21:04 Polk, Wisconsin, US
2756483 2756483 2022-12-29 US Wisconsin Portage 55097 22249 171 0   44.47558711 -89.50152965 2022-12-30 04:21:04 Portage, Wisconsin, US
2756484 2756484 2022-12-29 US Wisconsin Price 55099 3950 37 0   45.68051754 -90.3609888 2022-12-30 04:21:04 Price, Wisconsin, US
2756485 2756485 2022-12-29 US Wisconsin Racine 55101 69665 735 0   42.74753117 -88.05941254 2022-12-30 04:21:04 Racine, Wisconsin, US
2756486 2756486 2022-12-29 US Wisconsin Richland 55103 4890 53 0   43.3762778 -90.43012729 2022-12-30 04:21:04 Richland, Wisconsin, US
2756487 2756487 2022-12-29 US Wisconsin Rock 55105 54179 438 0   42.67151616 -89.071479 2022-12-30 04:21:04 Rock, Wisconsin, US
2756488 2756488 2022-12-29 US Wisconsin Rusk 55107 4101 61 0   45.47498854 -91.1333012 2022-12-30 04:21:04 Rusk, Wisconsin, US
2756489 2756489 2022-12-29 US Wisconsin Sauk 55111 20525 158 0   43.42574087 -89.94966132 2022-12-30 04:21:04 Sauk, Wisconsin, US
2756490 2756490 2022-12-29 US Wisconsin Sawyer 55113 5855 66 0   45.87931905 -91.14504927 2022-12-30 04:21:04 Sawyer, Wisconsin, US
2756491 2756491 2022-12-29 US Wisconsin Shawano 55115 13908 163 0   44.78902246 -88.76443896 2022-12-30 04:21:04 Shawano, Wisconsin, US
2756492 2756492 2022-12-29 US Wisconsin Sheboygan 55117 38729 352 0   43.72099677 -87.94579284 2022-12-30 04:21:04 Sheboygan, Wisconsin, US
2756493 2756493 2022-12-29 US Wisconsin St. Croix 55109 30166 160 0   45.03437474 -92.45000068 2022-12-30 04:21:04 St. Croix, Wisconsin, US
2756494 2756494 2022-12-29 US Wisconsin Taylor 55119 5671 78 0   45.21179252 -90.5004405 2022-12-30 04:21:04 Taylor, Wisconsin, US
2756495 2756495 2022-12-29 US Wisconsin Trempealeau 55121 9740 72 0   44.30360275 -91.35893614 2022-12-30 04:21:04 Trempealeau, Wisconsin, US
2756496 2756496 2022-12-29 US Wisconsin Unassigned 90055 0 0 0   46.52868768 0.0 2022-12-30 04:21:04 Unassigned, Wisconsin, US
2756497 2756497 2022-12-29 US Wisconsin Vernon 55123 7484 115 0   43.59422667 -90.8324691 2022-12-30 04:21:04 Vernon, Wisconsin, US
2756498 2756498 2022-12-29 US Wisconsin Vilas 55125 6369 103 0   46.05467334 -89.51719204 2022-12-30 04:21:04 Vilas, Wisconsin, US
2756499 2756499 2022-12-29 US Wisconsin Walworth 55127 32581 300 0   42.66858202 -88.54163073 2022-12-30 04:21:04 Walworth, Wisconsin, US
2756500 2756500 2022-12-29 US Wisconsin Washburn 55129 4925 51 0   45.89838588 -91.79050449 2022-12-30 04:21:04 Washburn, Wisconsin, US
2756501 2756501 2022-12-29 US Wisconsin Washington 55131 45890 359 0   43.36863664 -88.22974712 2022-12-30 04:21:04 Washington, Wisconsin, US
2756502 2756502 2022-12-29 US Wisconsin Waukesha 55133 136875 1205 0   43.01833055 -88.30431188 2022-12-30 04:21:04 Waukesha, Wisconsin, US
2756503 2756503 2022-12-29 US Wisconsin Waupaca 55135 16073 262 0   44.47068056 -88.96534501 2022-12-30 04:21:04 Waupaca, Wisconsin, US
2756504 2756504 2022-12-29 US Wisconsin Waushara 55137 7535 92 0   44.11324419 -89.24317107 2022-12-30 04:21:04 Waushara, Wisconsin, US
2756505 2756505 2022-12-29 US Wisconsin Winnebago 55139 62617 410 0   44.06886922 -88.64477096 2022-12-30 04:21:04 Winnebago, Wisconsin, US
2756506 2756506 2022-12-29 US Wisconsin Wood 55141 26240 258 0   44.45537896 -90.04158336 2022-12-30 04:21:04 Wood, Wisconsin, US
1077440 1077440 2022-12-28 US Wisconsin Adams 55001 5708 70 0   43.96974651 -89.76782777 2022-12-29 04:21:01 Adams, Wisconsin, US
1077441 1077441 2022-12-28 US Wisconsin Ashland 55003 4075 42 0   46.31956891 -90.67837132 2022-12-29 04:21:01 Ashland, Wisconsin, US
1077442 1077442 2022-12-28 US Wisconsin Barron 55005 15821 151 0   45.42372701 -91.84833627 2022-12-29 04:21:01 Barron, Wisconsin, US
1077443 1077443 2022-12-28 US Wisconsin Bayfield 55007 4272 44 0   46.52868768 -91.19716729 2022-12-29 04:21:01 Bayfield, Wisconsin, US
1077444 1077444 2022-12-28 US Wisconsin Brown 55009 100963 608 0   44.4526553 -88.00411844 2022-12-29 04:21:01 Brown, Wisconsin, US
1077445 1077445 2022-12-28 US Wisconsin Buffalo 55011 4130 14 0   44.37835084 -91.75332578 2022-12-29 04:21:01 Buffalo, Wisconsin, US
1077446 1077446 2022-12-28 US Wisconsin Burnett 55013 5010 45 0   45.86303537 -92.36711412 2022-12-29 04:21:01 Burnett, Wisconsin, US
1077447 1077447 2022-12-28 US Wisconsin Calumet 55015 16620 129 0   44.0816316 -88.21780273 2022-12-29 04:21:01 Calumet, Wisconsin, US
1077448 1077448 2022-12-28 US Wisconsin Chippewa 55017 21712 209 0   45.06939744 -91.28068855 2022-12-29 04:21:01 Chippewa, Wisconsin, US
1077449 1077449 2022-12-28 US Wisconsin Clark 55019 8820 129 0   44.73483377 -90.61207486 2022-12-29 04:21:01 Clark, Wisconsin, US
1077450 1077450 2022-12-28 US Wisconsin Columbia 55021 19178 146 0   43.46492199 -89.33589004 2022-12-29 04:21:01 Columbia, Wisconsin, US
1077451 1077451 2022-12-28 US Wisconsin Crawford 55023 5277 32 0   43.23870316 -90.93073686 2022-12-29 04:21:01 Crawford, Wisconsin, US
1077452 1077452 2022-12-28 US Wisconsin Dane 55025 174876 613 0   43.06601594 -89.41733797 2022-12-29 04:21:01 Dane, Wisconsin, US
1077453 1077453 2022-12-28 US Wisconsin Dodge 55027 32100 363 0   43.41576662 -88.70928178 2022-12-29 04:21:01 Dodge, Wisconsin, US
1077454 1077454 2022-12-28 US Wisconsin Door 55029 8588 85 0   44.95856458 -87.30002707 2022-12-29 04:21:01 Door, Wisconsin, US
1077455 1077455 2022-12-28 US Wisconsin Douglas 55031 14169 88 0   46.43222285 -91.91595768 2022-12-29 04:21:01 Douglas, Wisconsin, US
1077456 1077456 2022-12-28 US Wisconsin Dunn 55033 15312 81 0   44.94562799 -91.8962481 2022-12-29 04:21:01 Dunn, Wisconsin, US
1077457 1077457 2022-12-28 US Wisconsin Eau Claire 55035 35921 210 0   44.726614 -91.28609183 2022-12-29 04:21:01 Eau Claire, Wisconsin, US
1077458 1077458 2022-12-28 US Wisconsin Florence 55037 1322 17 0   45.84963535 -88.39804137 2022-12-29 04:21:01 Florence, Wisconsin, US
1077459 1077459 2022-12-28 US Wisconsin Fond du Lac 55039 38441 307 0   43.75354908 -88.48885325 2022-12-29 04:21:01 Fond du Lac, Wisconsin, US
1077460 1077460 2022-12-28 US Wisconsin Forest 55041 3271 54 0   45.66678019 -88.77084892 2022-12-29 04:21:01 Forest, Wisconsin, US
1077461 1077461 2022-12-28 US Wisconsin Grant 55043 15202 160 0   42.8671731 -90.7063218 2022-12-29 04:21:01 Grant, Wisconsin, US
1077462 1077462 2022-12-28 US Wisconsin Green 55045 11345 60 0   42.6794956 -89.60243287 2022-12-29 04:21:01 Green, Wisconsin, US
1077463 1077463 2022-12-28 US Wisconsin Green Lake 55047 6242 71 0   43.80025981 -89.04679553 2022-12-29 04:21:01 Green Lake, Wisconsin, US
1077464 1077464 2022-12-28 US Wisconsin Iowa 55049 6747 32 0   43.00050278 -90.13469017 2022-12-29 04:21:01 Iowa, Wisconsin, US
1077465 1077465 2022-12-28 US Wisconsin Iron 55051 1781 49 0   46.26302338 -90.24295041 2022-12-29 04:21:01 Iron, Wisconsin, US
1077466 1077466 2022-12-28 US Wisconsin Jackson 55053 6751 45 0   44.31864893 -90.80566792 2022-12-29 04:21:01 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] TEXT,
   [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 · Queries took 1056.152ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette