johns_hopkins_csse_daily_reports

Table actions
⚠️ 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 rows where "last_update" is on date 2020-09-10 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

Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2175055 2175055 2020-09-09 US Wisconsin Adams 55001 150 3 0 147 43.96974651 -89.76782777 2020-09-10 04:29:01 Adams, Wisconsin, US
2175056 2175056 2020-09-09 US Wisconsin Ashland 55003 38 1 0 37 46.31956891 -90.67837132 2020-09-10 04:29:01 Ashland, Wisconsin, US
2175057 2175057 2020-09-09 US Wisconsin Barron 55005 393 3 0 390 45.42372701 -91.84833627 2020-09-10 04:29:01 Barron, Wisconsin, US
2175058 2175058 2020-09-09 US Wisconsin Bayfield 55007 63 1 0 62 46.52868768 -91.19716729 2020-09-10 04:29:01 Bayfield, Wisconsin, US
2175059 2175059 2020-09-09 US Wisconsin Brown 55009 6067 58 0 6009 44.4526553 -88.00411844 2020-09-10 04:29:01 Brown, Wisconsin, US
2175060 2175060 2020-09-09 US Wisconsin Buffalo 55011 97 2 0 95 44.37835084 -91.75332578 2020-09-10 04:29:01 Buffalo, Wisconsin, US
2175061 2175061 2020-09-09 US Wisconsin Burnett 55013 57 2 0 55 45.86303537 -92.36711412 2020-09-10 04:29:01 Burnett, Wisconsin, US
2175062 2175062 2020-09-09 US Wisconsin Calumet 55015 619 2 0 617 44.0816316 -88.21780273 2020-09-10 04:29:01 Calumet, Wisconsin, US
2175063 2175063 2020-09-09 US Wisconsin Chippewa 55017 389 0 0 389 45.06939744 -91.28068855 2020-09-10 04:29:01 Chippewa, Wisconsin, US
2175064 2175064 2020-09-09 US Wisconsin Clark 55019 261 8 0 253 44.73483377 -90.61207486 2020-09-10 04:29:01 Clark, Wisconsin, US
2175065 2175065 2020-09-09 US Wisconsin Columbia 55021 400 2 0 398 43.46492199 -89.33589004 2020-09-10 04:29:01 Columbia, Wisconsin, US
2175066 2175066 2020-09-09 US Wisconsin Crawford 55023 121 0 0 121 43.23870316 -90.93073686 2020-09-10 04:29:01 Crawford, Wisconsin, US
2175067 2175067 2020-09-09 US Wisconsin Dane 55025 6489 41 0 6448 43.06601594 -89.41733797 2020-09-10 04:29:01 Dane, Wisconsin, US
2175068 2175068 2020-09-09 US Wisconsin Dodge 55027 1326 6 0 1320 43.41576662 -88.70928178 2020-09-10 04:29:01 Dodge, Wisconsin, US
2175069 2175069 2020-09-09 US Wisconsin Door 55029 157 3 0 154 44.95856458 -87.30002707 2020-09-10 04:29:01 Door, Wisconsin, US
2175070 2175070 2020-09-09 US Wisconsin Douglas 55031 297 0 0 297 46.43222285 -91.91595768 2020-09-10 04:29:01 Douglas, Wisconsin, US
2175071 2175071 2020-09-09 US Wisconsin Dunn 55033 208 0 0 208 44.94562799 -91.8962481 2020-09-10 04:29:01 Dunn, Wisconsin, US
2175072 2175072 2020-09-09 US Wisconsin Eau Claire 55035 1037 6 0 1031 44.726614 -91.28609183 2020-09-10 04:29:01 Eau Claire, Wisconsin, US
2175073 2175073 2020-09-09 US Wisconsin Florence 55037 31 0 0 31 45.84963535 -88.39804137 2020-09-10 04:29:01 Florence, Wisconsin, US
2175074 2175074 2020-09-09 US Wisconsin Fond du Lac 55039 1304 12 0 1292 43.75354908 -88.48885325 2020-09-10 04:29:01 Fond du Lac, Wisconsin, US
2175075 2175075 2020-09-09 US Wisconsin Forest 55041 116 4 0 112 45.66678019 -88.77084892 2020-09-10 04:29:01 Forest, Wisconsin, US
2175076 2175076 2020-09-09 US Wisconsin Grant 55043 499 19 0 480 42.8671731 -90.7063218 2020-09-10 04:29:01 Grant, Wisconsin, US
2175077 2175077 2020-09-09 US Wisconsin Green 55045 316 2 0 314 42.6794956 -89.60243287 2020-09-10 04:29:01 Green, Wisconsin, US
2175078 2175078 2020-09-09 US Wisconsin Green Lake 55047 114 0 0 114 43.80025981 -89.04679553 2020-09-10 04:29:01 Green Lake, Wisconsin, US
2175079 2175079 2020-09-09 US Wisconsin Iowa 55049 125 0 0 125 43.00050278 -90.13469017 2020-09-10 04:29:01 Iowa, Wisconsin, US
2175080 2175080 2020-09-09 US Wisconsin Iron 55051 131 1 0 130 46.26302338 -90.24295041 2020-09-10 04:29:01 Iron, Wisconsin, US
2175081 2175081 2020-09-09 US Wisconsin Jackson 55053 77 1 0 76 44.31864893 -90.80566792 2020-09-10 04:29:01 Jackson, Wisconsin, US
2175082 2175082 2020-09-09 US Wisconsin Jefferson 55055 1007 7 0 1000 43.02054068 -88.77529134 2020-09-10 04:29:01 Jefferson, Wisconsin, US
2175083 2175083 2020-09-09 US Wisconsin Juneau 55057 255 1 0 254 43.92456975 -90.11120239 2020-09-10 04:29:01 Juneau, Wisconsin, US
2175084 2175084 2020-09-09 US Wisconsin Kenosha 55059 3074 64 0 3010 42.57639354 -88.04051686 2020-09-10 04:29:01 Kenosha, Wisconsin, US
2175085 2175085 2020-09-09 US Wisconsin Kewaunee 55061 224 2 0 222 44.51727459 -87.61468386 2020-09-10 04:29:01 Kewaunee, Wisconsin, US
2175086 2175086 2020-09-09 US Wisconsin La Crosse 55063 1370 2 0 1368 43.90632465 -91.11451093 2020-09-10 04:29:01 La Crosse, Wisconsin, US
2175087 2175087 2020-09-09 US Wisconsin Lafayette 55065 188 0 0 188 42.66005229 -90.1317729 2020-09-10 04:29:01 Lafayette, Wisconsin, US
2175088 2175088 2020-09-09 US Wisconsin Langlade 55067 90 2 0 88 45.26271619 -89.07483625 2020-09-10 04:29:01 Langlade, Wisconsin, US
2175089 2175089 2020-09-09 US Wisconsin Lincoln 55069 96 1 0 95 45.33737523 -89.73411273 2020-09-10 04:29:01 Lincoln, Wisconsin, US
2175090 2175090 2020-09-09 US Wisconsin Manitowoc 55071 632 2 0 630 44.11946801 -87.80928853 2020-09-10 04:29:01 Manitowoc, Wisconsin, US
2175091 2175091 2020-09-09 US Wisconsin Marathon 55073 833 14 0 819 44.89792533 -89.75863384 2020-09-10 04:29:01 Marathon, Wisconsin, US
2175092 2175092 2020-09-09 US Wisconsin Marinette 55075 647 7 0 640 45.38553432 -88.03324599999998 2020-09-10 04:29:01 Marinette, Wisconsin, US
2175093 2175093 2020-09-09 US Wisconsin Marquette 55077 118 1 0 117 43.81911946 -89.40073763 2020-09-10 04:29:01 Marquette, Wisconsin, US
2175094 2175094 2020-09-09 US Wisconsin Menominee 55078 30 0 0 30 45.00422544 -88.70950714 2020-09-10 04:29:01 Menominee, Wisconsin, US
2175095 2175095 2020-09-09 US Wisconsin Milwaukee 55079 25014 507 0 24507 43.00486062 -87.96733172 2020-09-10 04:29:01 Milwaukee, Wisconsin, US
2175096 2175096 2020-09-09 US Wisconsin Monroe 55081 303 2 0 301 43.94641218 -90.618819 2020-09-10 04:29:01 Monroe, Wisconsin, US
2175097 2175097 2020-09-09 US Wisconsin Oconto 55083 509 4 0 505 45.02715345 -88.26807503 2020-09-10 04:29:01 Oconto, Wisconsin, US
2175098 2175098 2020-09-09 US Wisconsin Oneida 55085 241 1 0 240 45.70677897 -89.51944105 2020-09-10 04:29:01 Oneida, Wisconsin, US
2175099 2175099 2020-09-09 US Wisconsin Outagamie 55087 2407 23 0 2384 44.41578887 -88.46565023 2020-09-10 04:29:01 Outagamie, Wisconsin, US
2175100 2175100 2020-09-09 US Wisconsin Ozaukee 55089 1030 18 0 1012 43.38352225 -87.94625009 2020-09-10 04:29:01 Ozaukee, Wisconsin, US
2175101 2175101 2020-09-09 US Wisconsin Pepin 55091 48 0 0 48 44.58307413 -91.99949611 2020-09-10 04:29:01 Pepin, Wisconsin, US
2175102 2175102 2020-09-09 US Wisconsin Pierce 55093 314 6 0 308 44.71850291 -92.4224416 2020-09-10 04:29:01 Pierce, Wisconsin, US
2175103 2175103 2020-09-09 US Wisconsin Polk 55095 189 2 0 187 45.46130348 -92.44182875 2020-09-10 04:29:01 Polk, Wisconsin, US
2175104 2175104 2020-09-09 US Wisconsin Portage 55097 793 2 0 791 44.47558711 -89.50152965 2020-09-10 04:29:01 Portage, Wisconsin, US
2175105 2175105 2020-09-09 US Wisconsin Price 55099 36 0 0 36 45.68051754 -90.3609888 2020-09-10 04:29:01 Price, Wisconsin, US
2175106 2175106 2020-09-09 US Wisconsin Racine 55101 4193 92 0 4101 42.74753117 -88.05941254 2020-09-10 04:29:01 Racine, Wisconsin, US
2175107 2175107 2020-09-09 US Wisconsin Richland 55103 61 4 0 57 43.3762778 -90.43012729 2020-09-10 04:29:01 Richland, Wisconsin, US
2175108 2175108 2020-09-09 US Wisconsin Rock 55105 1875 29 0 1846 42.67151616 -89.07147900000002 2020-09-10 04:29:01 Rock, Wisconsin, US
2175109 2175109 2020-09-09 US Wisconsin Rusk 55107 30 1 0 29 45.47498854 -91.1333012 2020-09-10 04:29:01 Rusk, Wisconsin, US
2175110 2175110 2020-09-09 US Wisconsin Sauk 55111 683 3 0 680 43.42574087 -89.94966132 2020-09-10 04:29:01 Sauk, Wisconsin, US
2175111 2175111 2020-09-09 US Wisconsin Sawyer 55113 167 1 0 166 45.87931905 -91.14504927 2020-09-10 04:29:01 Sawyer, Wisconsin, US
2175112 2175112 2020-09-09 US Wisconsin Shawano 55115 352 0 0 352 44.78902246 -88.76443896 2020-09-10 04:29:01 Shawano, Wisconsin, US
2175113 2175113 2020-09-09 US Wisconsin Sheboygan 55117 1192 10 0 1182 43.72099677 -87.94579284 2020-09-10 04:29:01 Sheboygan, Wisconsin, US
2175114 2175114 2020-09-09 US Wisconsin St. Croix 55109 688 7 0 681 45.03437474 -92.45000068 2020-09-10 04:29:01 St. Croix, Wisconsin, US
2175115 2175115 2020-09-09 US Wisconsin Taylor 55119 123 3 0 120 45.21179252 -90.5004405 2020-09-10 04:29:01 Taylor, Wisconsin, US
2175116 2175116 2020-09-09 US Wisconsin Trempealeau 55121 445 2 0 443 44.30360275 -91.35893614 2020-09-10 04:29:01 Trempealeau, Wisconsin, US
2175117 2175117 2020-09-09 US Wisconsin Unassigned 90055 0 0 0 0 46.52868768 0.0 2020-09-10 04:29:01 Unassigned, Wisconsin, US
2175118 2175118 2020-09-09 US Wisconsin Vernon 55123 119 0 0 119 43.59422667 -90.8324691 2020-09-10 04:29:01 Vernon, Wisconsin, US
2175119 2175119 2020-09-09 US Wisconsin Vilas 55125 136 0 0 136 46.05467334 -89.51719204 2020-09-10 04:29:01 Vilas, Wisconsin, US
2175120 2175120 2020-09-09 US Wisconsin Walworth 55127 1880 32 0 1848 42.66858202 -88.54163073 2020-09-10 04:29:01 Walworth, Wisconsin, US
2175121 2175121 2020-09-09 US Wisconsin Washburn 55129 77 0 0 77 45.89838588 -91.79050449 2020-09-10 04:29:01 Washburn, Wisconsin, US
2175122 2175122 2020-09-09 US Wisconsin Washington 55131 1826 30 0 1796 43.36863664 -88.22974712 2020-09-10 04:29:01 Washington, Wisconsin, US
2175123 2175123 2020-09-09 US Wisconsin Waukesha 55133 5886 78 0 5808 43.01833055 -88.30431188 2020-09-10 04:29:01 Waukesha, Wisconsin, US
2175124 2175124 2020-09-09 US Wisconsin Waupaca 55135 783 19 0 764 44.47068056 -88.96534501 2020-09-10 04:29:01 Waupaca, Wisconsin, US
2175125 2175125 2020-09-09 US Wisconsin Waushara 55137 202 2 0 200 44.11324419 -89.24317107 2020-09-10 04:29:01 Waushara, Wisconsin, US
2175126 2175126 2020-09-09 US Wisconsin Winnebago 55139 1748 22 0 1726 44.06886922 -88.64477096 2020-09-10 04:29:01 Winnebago, Wisconsin, US
2175127 2175127 2020-09-09 US Wisconsin Wood 55141 538 3 0 535 44.45537896 -90.04158336 2020-09-10 04:29:01 Wood, Wisconsin, US

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]);