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

24,847 rows where province_or_state = "Wisconsin" sorted by day descending

✎ View and edit SQL

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

province_or_state

  • Wisconsin · 24,847 ✖

country_or_region

  • US 24,847
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
804803 804803 2021-03-01 US Wisconsin Adams 55001 1743 15 0 1728 43.96974651 -89.76782777 2021-03-02 05:23:30 Adams, Wisconsin, US
804804 804804 2021-03-01 US Wisconsin Ashland 55003 1241 16 0 1225 46.31956891 -90.67837132 2021-03-02 05:23:30 Ashland, Wisconsin, US
804805 804805 2021-03-01 US Wisconsin Barron 55005 5514 76 0 5438 45.42372701 -91.84833627 2021-03-02 05:23:30 Barron, Wisconsin, US
804806 804806 2021-03-01 US Wisconsin Bayfield 55007 1140 19 0 1121 46.52868768 -91.19716729 2021-03-02 05:23:30 Bayfield, Wisconsin, US
804807 804807 2021-03-01 US Wisconsin Brown 55009 32641 250 0 32391 44.4526553 -88.00411844 2021-03-02 05:23:30 Brown, Wisconsin, US
804808 804808 2021-03-01 US Wisconsin Buffalo 55011 1352 7 0 1345 44.37835084 -91.75332578 2021-03-02 05:23:30 Buffalo, Wisconsin, US
804809 804809 2021-03-01 US Wisconsin Burnett 55013 1343 23 0 1320 45.86303537 -92.36711412 2021-03-02 05:23:30 Burnett, Wisconsin, US
804810 804810 2021-03-01 US Wisconsin Calumet 55015 6018 46 0 5972 44.0816316 -88.21780273 2021-03-02 05:23:30 Calumet, Wisconsin, US
804811 804811 2021-03-01 US Wisconsin Chippewa 55017 7225 94 0 7131 45.06939744 -91.28068855 2021-03-02 05:23:30 Chippewa, Wisconsin, US
804812 804812 2021-03-01 US Wisconsin Clark 55019 3543 61 0 3482 44.73483377 -90.61207486 2021-03-02 05:23:30 Clark, Wisconsin, US
804813 804813 2021-03-01 US Wisconsin Columbia 55021 5421 60 0 5361 43.46492199 -89.33589004 2021-03-02 05:23:30 Columbia, Wisconsin, US
804814 804814 2021-03-01 US Wisconsin Crawford 55023 1718 17 0 1701 43.23870316 -90.93073686 2021-03-02 05:23:30 Crawford, Wisconsin, US
804815 804815 2021-03-01 US Wisconsin Dane 55025 42157 296 0 41861 43.06601594 -89.41733797 2021-03-02 05:23:30 Dane, Wisconsin, US
804816 804816 2021-03-01 US Wisconsin Dodge 55027 12190 176 0 12014 43.41576662 -88.70928178 2021-03-02 05:23:30 Dodge, Wisconsin, US
804817 804817 2021-03-01 US Wisconsin Door 55029 2613 25 0 2588 44.95856458 -87.30002707 2021-03-02 05:23:30 Door, Wisconsin, US
804818 804818 2021-03-01 US Wisconsin Douglas 55031 4238 40 0 4198 46.43222285 -91.91595768 2021-03-02 05:23:30 Douglas, Wisconsin, US
804819 804819 2021-03-01 US Wisconsin Dunn 55033 4594 28 0 4566 44.94562799 -91.8962481 2021-03-02 05:23:30 Dunn, Wisconsin, US
804820 804820 2021-03-01 US Wisconsin Eau Claire 55035 11309 114 0 11195 44.726614 -91.28609183 2021-03-02 05:23:30 Eau Claire, Wisconsin, US
804821 804821 2021-03-01 US Wisconsin Florence 55037 468 12 0 456 45.84963535 -88.39804137 2021-03-02 05:23:30 Florence, Wisconsin, US
804822 804822 2021-03-01 US Wisconsin Fond du Lac 55039 13048 101 0 12947 43.75354908 -88.48885325 2021-03-02 05:23:30 Fond du Lac, Wisconsin, US
804823 804823 2021-03-01 US Wisconsin Forest 55041 994 26 0 968 45.66678019 -88.77084892 2021-03-02 05:23:30 Forest, Wisconsin, US
804824 804824 2021-03-01 US Wisconsin Grant 55043 5341 85 0 5256 42.8671731 -90.7063218 2021-03-02 05:23:30 Grant, Wisconsin, US
804825 804825 2021-03-01 US Wisconsin Green 55045 3257 22 0 3235 42.6794956 -89.60243287 2021-03-02 05:23:30 Green, Wisconsin, US
804826 804826 2021-03-01 US Wisconsin Green Lake 55047 1944 21 0 1923 43.80025981 -89.04679553 2021-03-02 05:23:30 Green Lake, Wisconsin, US
804827 804827 2021-03-01 US Wisconsin Iowa 55049 1945 10 0 1935 43.00050278 -90.13469017 2021-03-02 05:23:30 Iowa, Wisconsin, US
804828 804828 2021-03-01 US Wisconsin Iron 55051 658 39 0 619 46.26302338 -90.24295041 2021-03-02 05:23:30 Iron, Wisconsin, US
804829 804829 2021-03-01 US Wisconsin Jackson 55053 2615 23 0 2592 44.31864893 -90.80566792 2021-03-02 05:23:30 Jackson, Wisconsin, US
804830 804830 2021-03-01 US Wisconsin Jefferson 55055 8826 125 0 8701 43.02054068 -88.77529134 2021-03-02 05:23:30 Jefferson, Wisconsin, US
804831 804831 2021-03-01 US Wisconsin Juneau 55057 3070 20 0 3050 43.92456975 -90.11120239 2021-03-02 05:23:30 Juneau, Wisconsin, US
804832 804832 2021-03-01 US Wisconsin Kenosha 55059 16956 315 0 16641 42.57639354 -88.04051686 2021-03-02 05:23:30 Kenosha, Wisconsin, US
804833 804833 2021-03-01 US Wisconsin Kewaunee 55061 2581 28 0 2553 44.51727459 -87.61468386 2021-03-02 05:23:30 Kewaunee, Wisconsin, US
804834 804834 2021-03-01 US Wisconsin La Crosse 55063 12886 78 0 12808 43.90632465 -91.11451093 2021-03-02 05:23:30 La Crosse, Wisconsin, US
804835 804835 2021-03-01 US Wisconsin Lafayette 55065 1611 8 0 1603 42.66005229 -90.1317729 2021-03-02 05:23:30 Lafayette, Wisconsin, US
804836 804836 2021-03-01 US Wisconsin Langlade 55067 2090 44 0 2046 45.26271619 -89.07483625 2021-03-02 05:23:30 Langlade, Wisconsin, US
804837 804837 2021-03-01 US Wisconsin Lincoln 55069 3102 75 0 3027 45.33737523 -89.73411273 2021-03-02 05:23:30 Lincoln, Wisconsin, US
804838 804838 2021-03-01 US Wisconsin Manitowoc 55071 8363 81 0 8282 44.11946801 -87.80928853 2021-03-02 05:23:30 Manitowoc, Wisconsin, US
804839 804839 2021-03-01 US Wisconsin Marathon 55073 15037 209 0 14828 44.89792533 -89.75863384 2021-03-02 05:23:30 Marathon, Wisconsin, US
804840 804840 2021-03-01 US Wisconsin Marinette 55075 4364 66 0 4298 45.38553432 -88.03324599999998 2021-03-02 05:23:30 Marinette, Wisconsin, US
804841 804841 2021-03-01 US Wisconsin Marquette 55077 1486 26 0 1460 43.81911946 -89.40073763 2021-03-02 05:23:30 Marquette, Wisconsin, US
804842 804842 2021-03-01 US Wisconsin Menominee 55078 797 11 0 786 45.00422544 -88.70950714 2021-03-02 05:23:30 Menominee, Wisconsin, US
804843 804843 2021-03-01 US Wisconsin Milwaukee 55079 107112 1274 0 105838 43.00486062 -87.96733172 2021-03-02 05:23:30 Milwaukee, Wisconsin, US
804844 804844 2021-03-01 US Wisconsin Monroe 55081 4411 32 0 4379 43.94641218 -90.618819 2021-03-02 05:23:30 Monroe, Wisconsin, US
804845 804845 2021-03-01 US Wisconsin Oconto 55083 4709 55 0 4654 45.02715345 -88.26807503 2021-03-02 05:23:30 Oconto, Wisconsin, US
804846 804846 2021-03-01 US Wisconsin Oneida 55085 3517 71 0 3446 45.70677897 -89.51944105 2021-03-02 05:23:30 Oneida, Wisconsin, US
804847 804847 2021-03-01 US Wisconsin Outagamie 55087 21630 207 0 21423 44.41578887 -88.46565023 2021-03-02 05:23:30 Outagamie, Wisconsin, US
804848 804848 2021-03-01 US Wisconsin Ozaukee 55089 8528 83 0 8445 43.38352225 -87.94625009 2021-03-02 05:23:30 Ozaukee, Wisconsin, US
804849 804849 2021-03-01 US Wisconsin Pepin 55091 826 7 0 819 44.58307413 -91.99949611 2021-03-02 05:23:30 Pepin, Wisconsin, US
804850 804850 2021-03-01 US Wisconsin Pierce 55093 4367 39 0 4328 44.71850291 -92.4224416 2021-03-02 05:23:30 Pierce, Wisconsin, US
804851 804851 2021-03-01 US Wisconsin Polk 55095 3994 44 0 3950 45.46130348 -92.44182875 2021-03-02 05:23:30 Polk, Wisconsin, US
804852 804852 2021-03-01 US Wisconsin Portage 55097 7000 67 0 6933 44.47558711 -89.50152965 2021-03-02 05:23:30 Portage, Wisconsin, US
804853 804853 2021-03-01 US Wisconsin Price 55099 1254 7 0 1247 45.68051754 -90.3609888 2021-03-02 05:23:30 Price, Wisconsin, US
804854 804854 2021-03-01 US Wisconsin Racine 55101 22940 349 0 22591 42.74753117 -88.05941254 2021-03-02 05:23:30 Racine, Wisconsin, US
804855 804855 2021-03-01 US Wisconsin Richland 55103 1322 14 0 1308 43.3762778 -90.43012729 2021-03-02 05:23:30 Richland, Wisconsin, US
804856 804856 2021-03-01 US Wisconsin Rock 55105 15941 173 0 15768 42.67151616 -89.07147900000002 2021-03-02 05:23:30 Rock, Wisconsin, US
804857 804857 2021-03-01 US Wisconsin Rusk 55107 1293 17 0 1276 45.47498854 -91.1333012 2021-03-02 05:23:30 Rusk, Wisconsin, US
804858 804858 2021-03-01 US Wisconsin Sauk 55111 5527 47 0 5480 43.42574087 -89.94966132 2021-03-02 05:23:30 Sauk, Wisconsin, US
804859 804859 2021-03-01 US Wisconsin Sawyer 55113 1551 21 0 1530 45.87931905 -91.14504927 2021-03-02 05:23:30 Sawyer, Wisconsin, US
804860 804860 2021-03-01 US Wisconsin Shawano 55115 5094 81 0 5013 44.78902246 -88.76443896 2021-03-02 05:23:30 Shawano, Wisconsin, US
804861 804861 2021-03-01 US Wisconsin Sheboygan 55117 13676 136 0 13540 43.72099677 -87.94579284 2021-03-02 05:23:30 Sheboygan, Wisconsin, US
804862 804862 2021-03-01 US Wisconsin St. Croix 55109 8011 47 0 7964 45.03437474 -92.45000068 2021-03-02 05:23:30 St. Croix, Wisconsin, US
804863 804863 2021-03-01 US Wisconsin Taylor 55119 2013 30 0 1983 45.21179252 -90.5004405 2021-03-02 05:23:30 Taylor, Wisconsin, US
804864 804864 2021-03-01 US Wisconsin Trempealeau 55121 3485 38 0 3447 44.30360275 -91.35893614 2021-03-02 05:23:30 Trempealeau, Wisconsin, US
804865 804865 2021-03-01 US Wisconsin Unassigned 90055 0 0 0 0 46.52868768 0.0 2021-03-02 05:23:30 Unassigned, Wisconsin, US
804866 804866 2021-03-01 US Wisconsin Vernon 55123 1895 39 0 1856 43.59422667 -90.8324691 2021-03-02 05:23:30 Vernon, Wisconsin, US
804867 804867 2021-03-01 US Wisconsin Vilas 55125 2263 38 0 2225 46.05467334 -89.51719204 2021-03-02 05:23:30 Vilas, Wisconsin, US
804868 804868 2021-03-01 US Wisconsin Walworth 55127 11222 146 0 11076 42.66858202 -88.54163073 2021-03-02 05:23:30 Walworth, Wisconsin, US
804869 804869 2021-03-01 US Wisconsin Washburn 55129 1367 20 0 1347 45.89838588 -91.79050449 2021-03-02 05:23:30 Washburn, Wisconsin, US
804870 804870 2021-03-01 US Wisconsin Washington 55131 15520 142 0 15378 43.36863664 -88.22974712 2021-03-02 05:23:30 Washington, Wisconsin, US
804871 804871 2021-03-01 US Wisconsin Waukesha 55133 44813 525 0 44288 43.01833055 -88.30431188 2021-03-02 05:23:30 Waukesha, Wisconsin, US
804872 804872 2021-03-01 US Wisconsin Waupaca 55135 5676 154 0 5522 44.47068056 -88.96534501 2021-03-02 05:23:30 Waupaca, Wisconsin, US
804873 804873 2021-03-01 US Wisconsin Waushara 55137 2403 34 0 2369 44.11324419 -89.24317107 2021-03-02 05:23:30 Waushara, Wisconsin, US
804874 804874 2021-03-01 US Wisconsin Winnebago 55139 19761 204 0 19557 44.06886922 -88.64477096 2021-03-02 05:23:30 Winnebago, Wisconsin, US
804875 804875 2021-03-01 US Wisconsin Wood 55141 7140 85 0 7055 44.45537896 -90.04158336 2021-03-02 05:23:30 Wood, Wisconsin, US
1069945 1069945 2021-02-28 US Wisconsin Adams 55001 1739 15 0 1724 43.96974651 -89.76782777 2021-03-01 05:23:01 Adams, Wisconsin, US
1069946 1069946 2021-02-28 US Wisconsin Ashland 55003 1241 16 0 1225 46.31956891 -90.67837132 2021-03-01 05:23:01 Ashland, Wisconsin, US
1069947 1069947 2021-02-28 US Wisconsin Barron 55005 5509 76 0 5433 45.42372701 -91.84833627 2021-03-01 05:23:01 Barron, Wisconsin, US
1069948 1069948 2021-02-28 US Wisconsin Bayfield 55007 1139 19 0 1120 46.52868768 -91.19716729 2021-03-01 05:23:01 Bayfield, Wisconsin, US
1069949 1069949 2021-02-28 US Wisconsin Brown 55009 32637 250 0 32387 44.4526553 -88.00411844 2021-03-01 05:23:01 Brown, Wisconsin, US
1069950 1069950 2021-02-28 US Wisconsin Buffalo 55011 1352 7 0 1345 44.37835084 -91.75332578 2021-03-01 05:23:01 Buffalo, Wisconsin, US
1069951 1069951 2021-02-28 US Wisconsin Burnett 55013 1342 23 0 1319 45.86303537 -92.36711412 2021-03-01 05:23:01 Burnett, Wisconsin, US
1069952 1069952 2021-02-28 US Wisconsin Calumet 55015 6014 46 0 5968 44.0816316 -88.21780273 2021-03-01 05:23:01 Calumet, Wisconsin, US
1069953 1069953 2021-02-28 US Wisconsin Chippewa 55017 7224 94 0 7130 45.06939744 -91.28068855 2021-03-01 05:23:01 Chippewa, Wisconsin, US
1069954 1069954 2021-02-28 US Wisconsin Clark 55019 3543 61 0 3482 44.73483377 -90.61207486 2021-03-01 05:23:01 Clark, Wisconsin, US
1069955 1069955 2021-02-28 US Wisconsin Columbia 55021 5410 60 0 5350 43.46492199 -89.33589004 2021-03-01 05:23:01 Columbia, Wisconsin, US
1069956 1069956 2021-02-28 US Wisconsin Crawford 55023 1718 17 0 1701 43.23870316 -90.93073686 2021-03-01 05:23:01 Crawford, Wisconsin, US
1069957 1069957 2021-02-28 US Wisconsin Dane 55025 42100 296 0 41804 43.06601594 -89.41733797 2021-03-01 05:23:01 Dane, Wisconsin, US
1069958 1069958 2021-02-28 US Wisconsin Dodge 55027 12184 176 0 12008 43.41576662 -88.70928178 2021-03-01 05:23:01 Dodge, Wisconsin, US
1069959 1069959 2021-02-28 US Wisconsin Door 55029 2613 25 0 2588 44.95856458 -87.30002707 2021-03-01 05:23:01 Door, Wisconsin, US
1069960 1069960 2021-02-28 US Wisconsin Douglas 55031 4236 40 0 4196 46.43222285 -91.91595768 2021-03-01 05:23:01 Douglas, Wisconsin, US
1069961 1069961 2021-02-28 US Wisconsin Dunn 55033 4592 28 0 4564 44.94562799 -91.8962481 2021-03-01 05:23:01 Dunn, Wisconsin, US
1069962 1069962 2021-02-28 US Wisconsin Eau Claire 55035 11309 114 0 11195 44.726614 -91.28609183 2021-03-01 05:23:01 Eau Claire, Wisconsin, US
1069963 1069963 2021-02-28 US Wisconsin Florence 55037 468 12 0 456 45.84963535 -88.39804137 2021-03-01 05:23:01 Florence, Wisconsin, US
1069964 1069964 2021-02-28 US Wisconsin Fond du Lac 55039 13046 101 0 12945 43.75354908 -88.48885325 2021-03-01 05:23:01 Fond du Lac, Wisconsin, US
1069965 1069965 2021-02-28 US Wisconsin Forest 55041 994 26 0 968 45.66678019 -88.77084892 2021-03-01 05:23:01 Forest, Wisconsin, US
1069966 1069966 2021-02-28 US Wisconsin Grant 55043 5338 85 0 5253 42.8671731 -90.7063218 2021-03-01 05:23:01 Grant, Wisconsin, US
1069967 1069967 2021-02-28 US Wisconsin Green 55045 3257 22 0 3235 42.6794956 -89.60243287 2021-03-01 05:23:01 Green, Wisconsin, US
1069968 1069968 2021-02-28 US Wisconsin Green Lake 55047 1944 21 0 1923 43.80025981 -89.04679553 2021-03-01 05:23:01 Green Lake, Wisconsin, US
1069969 1069969 2021-02-28 US Wisconsin Iowa 55049 1940 10 0 1930 43.00050278 -90.13469017 2021-03-01 05:23:01 Iowa, Wisconsin, US
1069970 1069970 2021-02-28 US Wisconsin Iron 55051 658 39 0 619 46.26302338 -90.24295041 2021-03-01 05:23:01 Iron, Wisconsin, US
1069971 1069971 2021-02-28 US Wisconsin Jackson 55053 2615 23 0 2592 44.31864893 -90.80566792 2021-03-01 05:23: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]);