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

42,075 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

  • Wisconsin · 42,075 ✖

country_or_region

  • US 42,075
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
35808 35808 2021-10-23 US Wisconsin Adams 55001 2721 33 0   43.96974651 -89.76782777 2021-10-24 04:21:22 Adams, Wisconsin, US
35809 35809 2021-10-23 US Wisconsin Ashland 55003 1820 16 0   46.31956891 -90.67837132 2021-10-24 04:21:22 Ashland, Wisconsin, US
35810 35810 2021-10-23 US Wisconsin Barron 55005 8327 92 0   45.42372701 -91.84833627 2021-10-24 04:21:22 Barron, Wisconsin, US
35811 35811 2021-10-23 US Wisconsin Bayfield 55007 1625 25 0   46.52868768 -91.19716729 2021-10-24 04:21:22 Bayfield, Wisconsin, US
35812 35812 2021-10-23 US Wisconsin Brown 55009 45497 318 0   44.452655299999996 -88.00411844 2021-10-24 04:21:22 Brown, Wisconsin, US
35813 35813 2021-10-23 US Wisconsin Buffalo 55011 1952 8 0   44.37835084 -91.75332578 2021-10-24 04:21:22 Buffalo, Wisconsin, US
35814 35814 2021-10-23 US Wisconsin Burnett 55013 2217 32 0   45.86303537 -92.36711412 2021-10-24 04:21:22 Burnett, Wisconsin, US
35815 35815 2021-10-23 US Wisconsin Calumet 55015 8232 59 0   44.0816316 -88.21780273 2021-10-24 04:21:22 Calumet, Wisconsin, US
35816 35816 2021-10-23 US Wisconsin Chippewa 55017 10801 116 0   45.06939744 -91.28068855 2021-10-24 04:21:22 Chippewa, Wisconsin, US
35817 35817 2021-10-23 US Wisconsin Clark 55019 4745 78 0   44.73483377 -90.61207486 2021-10-24 04:21:22 Clark, Wisconsin, US
35818 35818 2021-10-23 US Wisconsin Columbia 55021 7885 78 0   43.46492199 -89.33589004 2021-10-24 04:21:22 Columbia, Wisconsin, US
35819 35819 2021-10-23 US Wisconsin Crawford 55023 2285 22 0   43.23870316 -90.93073686 2021-10-24 04:21:22 Crawford, Wisconsin, US
35820 35820 2021-10-23 US Wisconsin Dane 55025 57350 369 0   43.06601594 -89.41733797 2021-10-24 04:21:22 Dane, Wisconsin, US
35821 35821 2021-10-23 US Wisconsin Dodge 55027 15955 227 0   43.41576662 -88.70928178 2021-10-24 04:21:22 Dodge, Wisconsin, US
35822 35822 2021-10-23 US Wisconsin Door 55029 3746 39 0   44.95856458 -87.30002707 2021-10-24 04:21:22 Door, Wisconsin, US
35823 35823 2021-10-23 US Wisconsin Douglas 55031 5946 66 0   46.43222285 -91.91595768 2021-10-24 04:21:22 Douglas, Wisconsin, US
35824 35824 2021-10-23 US Wisconsin Dunn 55033 6978 46 0   44.94562799 -91.8962481 2021-10-24 04:21:22 Dunn, Wisconsin, US
35825 35825 2021-10-23 US Wisconsin Eau Claire 55035 16129 138 0   44.726614 -91.28609183 2021-10-24 04:21:22 Eau Claire, Wisconsin, US
35826 35826 2021-10-23 US Wisconsin Florence 55037 632 14 0   45.84963535 -88.39804137 2021-10-24 04:21:22 Florence, Wisconsin, US
35827 35827 2021-10-23 US Wisconsin Fond du Lac 55039 17959 158 0   43.75354908 -88.48885325 2021-10-24 04:21:22 Fond du Lac, Wisconsin, US
35828 35828 2021-10-23 US Wisconsin Forest 55041 1515 31 0   45.66678019 -88.77084892 2021-10-24 04:21:22 Forest, Wisconsin, US
35829 35829 2021-10-23 US Wisconsin Grant 55043 7536 116 0   42.8671731 -90.7063218 2021-10-24 04:21:22 Grant, Wisconsin, US
35830 35830 2021-10-23 US Wisconsin Green 55045 4565 30 0   42.6794956 -89.60243287 2021-10-24 04:21:22 Green, Wisconsin, US
35831 35831 2021-10-23 US Wisconsin Green Lake 55047 3020 30 0   43.80025981 -89.04679553 2021-10-24 04:21:22 Green Lake, Wisconsin, US
35832 35832 2021-10-23 US Wisconsin Iowa 55049 2723 17 0   43.00050278 -90.13469017 2021-10-24 04:21:22 Iowa, Wisconsin, US
35833 35833 2021-10-23 US Wisconsin Iron 55051 887 42 0   46.26302338 -90.24295041 2021-10-24 04:21:22 Iron, Wisconsin, US
35834 35834 2021-10-23 US Wisconsin Jackson 55053 3366 31 0   44.31864893 -90.80566792 2021-10-24 04:21:22 Jackson, Wisconsin, US
35835 35835 2021-10-23 US Wisconsin Jefferson 55055 11736 149 0   43.02054068 -88.77529134 2021-10-24 04:21:22 Jefferson, Wisconsin, US
35836 35836 2021-10-23 US Wisconsin Juneau 55057 4174 35 0   43.92456975 -90.11120239 2021-10-24 04:21:22 Juneau, Wisconsin, US
35837 35837 2021-10-23 US Wisconsin Kenosha 55059 23818 381 0   42.57639354 -88.04051686 2021-10-24 04:21:22 Kenosha, Wisconsin, US
35838 35838 2021-10-23 US Wisconsin Kewaunee 55061 3574 41 0   44.51727459 -87.61468386 2021-10-24 04:21:22 Kewaunee, Wisconsin, US
35839 35839 2021-10-23 US Wisconsin La Crosse 55063 17186 110 0   43.90632465 -91.11451093 2021-10-24 04:21:22 La Crosse, Wisconsin, US
35840 35840 2021-10-23 US Wisconsin Lafayette 55065 2101 12 0   42.66005229 -90.1317729 2021-10-24 04:21:22 Lafayette, Wisconsin, US
35841 35841 2021-10-23 US Wisconsin Langlade 55067 3142 54 0   45.26271619 -89.07483625 2021-10-24 04:21:22 Langlade, Wisconsin, US
35842 35842 2021-10-23 US Wisconsin Lincoln 55069 4323 109 0   45.33737523 -89.73411273 2021-10-24 04:21:22 Lincoln, Wisconsin, US
35843 35843 2021-10-23 US Wisconsin Manitowoc 55071 11620 106 0   44.11946801 -87.80928853 2021-10-24 04:21:22 Manitowoc, Wisconsin, US
35844 35844 2021-10-23 US Wisconsin Marathon 55073 20913 266 0   44.89792533 -89.75863384 2021-10-24 04:21:22 Marathon, Wisconsin, US
35845 35845 2021-10-23 US Wisconsin Marinette 55075 6692 79 0   45.38553432 -88.03324599999998 2021-10-24 04:21:22 Marinette, Wisconsin, US
35846 35846 2021-10-23 US Wisconsin Marquette 55077 2279 33 0   43.81911946 -89.40073763 2021-10-24 04:21:22 Marquette, Wisconsin, US
35847 35847 2021-10-23 US Wisconsin Menominee 55078 948 11 0   45.00422544 -88.70950714 2021-10-24 04:21:22 Menominee, Wisconsin, US
35848 35848 2021-10-23 US Wisconsin Milwaukee 55079 150104 1594 0   43.00486062 -87.96733172 2021-10-24 04:21:22 Milwaukee, Wisconsin, US
35849 35849 2021-10-23 US Wisconsin Monroe 55081 6400 56 0   43.94641218 -90.61881899999999 2021-10-24 04:21:22 Monroe, Wisconsin, US
35850 35850 2021-10-23 US Wisconsin Oconto 55083 7126 76 0   45.02715345 -88.26807503 2021-10-24 04:21:22 Oconto, Wisconsin, US
35851 35851 2021-10-23 US Wisconsin Oneida 55085 4946 91 0   45.70677897 -89.51944105 2021-10-24 04:21:22 Oneida, Wisconsin, US
35852 35852 2021-10-23 US Wisconsin Outagamie 55087 30294 269 0   44.41578887 -88.46565023 2021-10-24 04:21:22 Outagamie, Wisconsin, US
35853 35853 2021-10-23 US Wisconsin Ozaukee 55089 12292 115 0   43.38352225 -87.94625009 2021-10-24 04:21:22 Ozaukee, Wisconsin, US
35854 35854 2021-10-23 US Wisconsin Pepin 55091 1158 10 0   44.58307413 -91.99949611 2021-10-24 04:21:22 Pepin, Wisconsin, US
35855 35855 2021-10-23 US Wisconsin Pierce 55093 6263 46 0   44.71850291 -92.4224416 2021-10-24 04:21:22 Pierce, Wisconsin, US
35856 35856 2021-10-23 US Wisconsin Polk 55095 6749 84 0   45.46130348 -92.44182875 2021-10-24 04:21:22 Polk, Wisconsin, US
35857 35857 2021-10-23 US Wisconsin Portage 55097 9437 96 0   44.47558711 -89.50152965 2021-10-24 04:21:22 Portage, Wisconsin, US
35858 35858 2021-10-23 US Wisconsin Price 55099 1813 11 0   45.68051754 -90.36098879999999 2021-10-24 04:21:22 Price, Wisconsin, US
35859 35859 2021-10-23 US Wisconsin Racine 55101 31441 447 0   42.74753117 -88.05941254 2021-10-24 04:21:22 Racine, Wisconsin, US
35860 35860 2021-10-23 US Wisconsin Richland 55103 2194 23 0   43.3762778 -90.43012729 2021-10-24 04:21:22 Richland, Wisconsin, US
35861 35861 2021-10-23 US Wisconsin Rock 55105 22145 244 0   42.67151616 -89.07147900000002 2021-10-24 04:21:22 Rock, Wisconsin, US
35862 35862 2021-10-23 US Wisconsin Rusk 55107 2189 34 0   45.47498854 -91.1333012 2021-10-24 04:21:22 Rusk, Wisconsin, US
35863 35863 2021-10-23 US Wisconsin Sauk 55111 8272 66 0   43.42574087 -89.94966132 2021-10-24 04:21:22 Sauk, Wisconsin, US
35864 35864 2021-10-23 US Wisconsin Sawyer 55113 2521 31 0   45.87931905 -91.14504927 2021-10-24 04:21:22 Sawyer, Wisconsin, US
35865 35865 2021-10-23 US Wisconsin Shawano 55115 7000 90 0   44.78902246 -88.76443896 2021-10-24 04:21:22 Shawano, Wisconsin, US
35866 35866 2021-10-23 US Wisconsin Sheboygan 55117 18064 186 0   43.72099677 -87.94579284 2021-10-24 04:21:22 Sheboygan, Wisconsin, US
35867 35867 2021-10-23 US Wisconsin St. Croix 55109 12788 85 0   45.03437474 -92.45000068 2021-10-24 04:21:22 St. Croix, Wisconsin, US
35868 35868 2021-10-23 US Wisconsin Taylor 55119 2986 45 0   45.21179252 -90.5004405 2021-10-24 04:21:22 Taylor, Wisconsin, US
35869 35869 2021-10-23 US Wisconsin Trempealeau 55121 4918 52 0   44.30360275 -91.35893614 2021-10-24 04:21:22 Trempealeau, Wisconsin, US
35870 35870 2021-10-23 US Wisconsin Unassigned 90055 0 0 0   46.52868768 0.0 2021-10-24 04:21:22 Unassigned, Wisconsin, US
35871 35871 2021-10-23 US Wisconsin Vernon 55123 2873 57 0   43.59422667 -90.8324691 2021-10-24 04:21:22 Vernon, Wisconsin, US
35872 35872 2021-10-23 US Wisconsin Vilas 55125 3065 53 0   46.05467334 -89.51719204 2021-10-24 04:21:22 Vilas, Wisconsin, US
35873 35873 2021-10-23 US Wisconsin Walworth 55127 15442 188 0   42.66858202 -88.54163073 2021-10-24 04:21:22 Walworth, Wisconsin, US
35874 35874 2021-10-23 US Wisconsin Washburn 55129 2191 27 0   45.89838588 -91.79050449 2021-10-24 04:21:22 Washburn, Wisconsin, US
35875 35875 2021-10-23 US Wisconsin Washington 55131 22291 221 0   43.36863664 -88.22974712 2021-10-24 04:21:22 Washington, Wisconsin, US
35876 35876 2021-10-23 US Wisconsin Waukesha 55133 62105 718 0   43.01833055 -88.30431188 2021-10-24 04:21:22 Waukesha, Wisconsin, US
35877 35877 2021-10-23 US Wisconsin Waupaca 55135 8176 183 0   44.47068056 -88.96534501 2021-10-24 04:21:22 Waupaca, Wisconsin, US
35878 35878 2021-10-23 US Wisconsin Waushara 55137 3660 50 0   44.11324419 -89.24317107 2021-10-24 04:21:22 Waushara, Wisconsin, US
35879 35879 2021-10-23 US Wisconsin Winnebago 55139 27209 259 0   44.06886922 -88.64477096 2021-10-24 04:21:22 Winnebago, Wisconsin, US
35880 35880 2021-10-23 US Wisconsin Wood 55141 10480 135 0   44.45537896 -90.04158336 2021-10-24 04:21:22 Wood, Wisconsin, US
316292 316292 2021-10-22 US Wisconsin Adams 55001 2721 33 0   43.96974651 -89.76782777 2021-10-23 04:21:32 Adams, Wisconsin, US
316293 316293 2021-10-22 US Wisconsin Ashland 55003 1820 16 0   46.31956891 -90.67837132 2021-10-23 04:21:32 Ashland, Wisconsin, US
316294 316294 2021-10-22 US Wisconsin Barron 55005 8327 92 0   45.42372701 -91.84833627 2021-10-23 04:21:32 Barron, Wisconsin, US
316295 316295 2021-10-22 US Wisconsin Bayfield 55007 1625 25 0   46.52868768 -91.19716729 2021-10-23 04:21:32 Bayfield, Wisconsin, US
316296 316296 2021-10-22 US Wisconsin Brown 55009 45497 318 0   44.452655299999996 -88.00411844 2021-10-23 04:21:32 Brown, Wisconsin, US
316297 316297 2021-10-22 US Wisconsin Buffalo 55011 1952 8 0   44.37835084 -91.75332578 2021-10-23 04:21:32 Buffalo, Wisconsin, US
316298 316298 2021-10-22 US Wisconsin Burnett 55013 2217 32 0   45.86303537 -92.36711412 2021-10-23 04:21:32 Burnett, Wisconsin, US
316299 316299 2021-10-22 US Wisconsin Calumet 55015 8232 59 0   44.0816316 -88.21780273 2021-10-23 04:21:32 Calumet, Wisconsin, US
316300 316300 2021-10-22 US Wisconsin Chippewa 55017 10801 116 0   45.06939744 -91.28068855 2021-10-23 04:21:32 Chippewa, Wisconsin, US
316301 316301 2021-10-22 US Wisconsin Clark 55019 4745 78 0   44.73483377 -90.61207486 2021-10-23 04:21:32 Clark, Wisconsin, US
316302 316302 2021-10-22 US Wisconsin Columbia 55021 7885 78 0   43.46492199 -89.33589004 2021-10-23 04:21:32 Columbia, Wisconsin, US
316303 316303 2021-10-22 US Wisconsin Crawford 55023 2285 22 0   43.23870316 -90.93073686 2021-10-23 04:21:32 Crawford, Wisconsin, US
316304 316304 2021-10-22 US Wisconsin Dane 55025 57350 369 0   43.06601594 -89.41733797 2021-10-23 04:21:32 Dane, Wisconsin, US
316305 316305 2021-10-22 US Wisconsin Dodge 55027 15955 227 0   43.41576662 -88.70928178 2021-10-23 04:21:32 Dodge, Wisconsin, US
316306 316306 2021-10-22 US Wisconsin Door 55029 3746 39 0   44.95856458 -87.30002707 2021-10-23 04:21:32 Door, Wisconsin, US
316307 316307 2021-10-22 US Wisconsin Douglas 55031 5946 66 0   46.43222285 -91.91595768 2021-10-23 04:21:32 Douglas, Wisconsin, US
316308 316308 2021-10-22 US Wisconsin Dunn 55033 6978 46 0   44.94562799 -91.8962481 2021-10-23 04:21:32 Dunn, Wisconsin, US
316309 316309 2021-10-22 US Wisconsin Eau Claire 55035 16129 138 0   44.726614 -91.28609183 2021-10-23 04:21:32 Eau Claire, Wisconsin, US
316310 316310 2021-10-22 US Wisconsin Florence 55037 632 14 0   45.84963535 -88.39804137 2021-10-23 04:21:32 Florence, Wisconsin, US
316311 316311 2021-10-22 US Wisconsin Fond du Lac 55039 17959 158 0   43.75354908 -88.48885325 2021-10-23 04:21:32 Fond du Lac, Wisconsin, US
316312 316312 2021-10-22 US Wisconsin Forest 55041 1515 31 0   45.66678019 -88.77084892 2021-10-23 04:21:32 Forest, Wisconsin, US
316313 316313 2021-10-22 US Wisconsin Grant 55043 7536 116 0   42.8671731 -90.7063218 2021-10-23 04:21:32 Grant, Wisconsin, US
316314 316314 2021-10-22 US Wisconsin Green 55045 4565 30 0   42.6794956 -89.60243287 2021-10-23 04:21:32 Green, Wisconsin, US
316315 316315 2021-10-22 US Wisconsin Green Lake 55047 3020 30 0   43.80025981 -89.04679553 2021-10-23 04:21:32 Green Lake, Wisconsin, US
316316 316316 2021-10-22 US Wisconsin Iowa 55049 2723 17 0   43.00050278 -90.13469017 2021-10-23 04:21:32 Iowa, Wisconsin, US
316317 316317 2021-10-22 US Wisconsin Iron 55051 887 42 0   46.26302338 -90.24295041 2021-10-23 04:21:32 Iron, Wisconsin, US
316318 316318 2021-10-22 US Wisconsin Jackson 55053 3366 31 0   44.31864893 -90.80566792 2021-10-23 04:21:32 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]);