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

11,993 rows where province_or_state = "Minnesota" sorted by day descending

View and edit SQL

Suggested facets: last_update (date)

province_or_state

  • Minnesota · 11,993

country_or_region

  • US 11,993
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
135731 2020-08-12 US Minnesota Aitkin 27001 40 1 0 39 46.60962049 -93.4116826 2020-08-13 04:29:15 Aitkin, Minnesota, US
135732 2020-08-12 US Minnesota Anoka 27003 3792 115 0 3677 45.27476015 -93.24604565 2020-08-13 04:29:15 Anoka, Minnesota, US
135733 2020-08-12 US Minnesota Becker 27005 161 1 0 160 46.93479392 -95.67158144 2020-08-13 04:29:15 Becker, Minnesota, US
135734 2020-08-12 US Minnesota Beltrami 27007 249 0 0 249 47.97373527 -94.93732139 2020-08-13 04:29:15 Beltrami, Minnesota, US
135735 2020-08-12 US Minnesota Benton 27009 323 3 0 320 45.69804958 -93.99514135 2020-08-13 04:29:15 Benton, Minnesota, US
135736 2020-08-12 US Minnesota Big Stone 27011 22 0 0 22 45.42712824 -96.41403739 2020-08-13 04:29:15 Big Stone, Minnesota, US
135737 2020-08-12 US Minnesota Blue Earth 27013 941 5 0 936 44.03554215 -94.06699781 2020-08-13 04:29:15 Blue Earth, Minnesota, US
135738 2020-08-12 US Minnesota Brown 27015 89 2 0 87 44.24205652 -94.72562874 2020-08-13 04:29:15 Brown, Minnesota, US
135739 2020-08-12 US Minnesota Carlton 27017 145 0 0 145 46.59180601 -92.67601019 2020-08-13 04:29:15 Carlton, Minnesota, US
135740 2020-08-12 US Minnesota Carver 27019 890 3 0 887 44.82017001 -93.8009918 2020-08-13 04:29:15 Carver, Minnesota, US
135741 2020-08-12 US Minnesota Cass 27021 76 2 0 74 46.95043611 -94.32603968 2020-08-13 04:29:15 Cass, Minnesota, US
135742 2020-08-12 US Minnesota Chippewa 27023 109 1 0 108 45.02343421 -95.56403693 2020-08-13 04:29:15 Chippewa, Minnesota, US
135743 2020-08-12 US Minnesota Chisago 27025 207 1 0 206 45.5021011 -92.90861945 2020-08-13 04:29:15 Chisago, Minnesota, US
135744 2020-08-12 US Minnesota Clay 27027 792 40 0 752 46.89289518 -96.48761922 2020-08-13 04:29:15 Clay, Minnesota, US
135745 2020-08-12 US Minnesota Clearwater 27029 14 0 0 14 47.57992111 -95.37790562 2020-08-13 04:29:15 Clearwater, Minnesota, US
135746 2020-08-12 US Minnesota Cook 27031 5 0 0 5 47.90504893 -90.52629546 2020-08-13 04:29:15 Cook, Minnesota, US
135747 2020-08-12 US Minnesota Cottonwood 27033 177 0 0 177 44.00715262 -95.18138802 2020-08-13 04:29:15 Cottonwood, Minnesota, US
135748 2020-08-12 US Minnesota Crow Wing 27035 246 14 0 232 46.48096553 -94.06755609 2020-08-13 04:29:15 Crow Wing, Minnesota, US
135749 2020-08-12 US Minnesota Dakota 27037 4558 106 0 4452 44.67172617 -93.06299363 2020-08-13 04:29:15 Dakota, Minnesota, US
135750 2020-08-12 US Minnesota Dodge 27039 131 0 0 131 44.02238415 -92.86244324 2020-08-13 04:29:15 Dodge, Minnesota, US
135751 2020-08-12 US Minnesota Douglas 27041 144 2 0 142 45.93348491 -95.45335469 2020-08-13 04:29:15 Douglas, Minnesota, US
135752 2020-08-12 US Minnesota Faribault 27043 89 0 0 89 43.67381499 -93.94787458 2020-08-13 04:29:15 Faribault, Minnesota, US
135753 2020-08-12 US Minnesota Fillmore 27045 71 0 0 71 43.67394126 -92.08980382 2020-08-13 04:29:15 Fillmore, Minnesota, US
135754 2020-08-12 US Minnesota Freeborn 27047 360 1 0 359 43.67385583 -93.34884422 2020-08-13 04:29:15 Freeborn, Minnesota, US
135755 2020-08-12 US Minnesota Goodhue 27049 202 9 0 193 44.40849741 -92.7234195 2020-08-13 04:29:15 Goodhue, Minnesota, US
135756 2020-08-12 US Minnesota Grant 27051 56 3 0 53 45.93424769 -96.01139609 2020-08-13 04:29:15 Grant, Minnesota, US
135757 2020-08-12 US Minnesota Hennepin 27053 19677 840 0 18837 45.00761521 -93.47694895 2020-08-13 04:29:15 Hennepin, Minnesota, US
135758 2020-08-12 US Minnesota Houston 27055 44 0 0 44 43.67129565 -91.49143057 2020-08-13 04:29:15 Houston, Minnesota, US
135759 2020-08-12 US Minnesota Hubbard 27057 35 0 0 35 47.10778564 -94.91693868 2020-08-13 04:29:15 Hubbard, Minnesota, US
135760 2020-08-12 US Minnesota Isanti 27059 131 0 0 131 45.56181234 -93.29487636 2020-08-13 04:29:15 Isanti, Minnesota, US
135761 2020-08-12 US Minnesota Itasca 27061 146 12 0 134 47.51009045 -93.63092229 2020-08-13 04:29:15 Itasca, Minnesota, US
135762 2020-08-12 US Minnesota Jackson 27063 79 0 0 79 43.67423373 -95.15398258 2020-08-13 04:29:15 Jackson, Minnesota, US
135763 2020-08-12 US Minnesota Kanabec 27065 37 2 0 35 45.9459309 -93.29275192 2020-08-13 04:29:15 Kanabec, Minnesota, US
135764 2020-08-12 US Minnesota Kandiyohi 27067 705 1 0 704 45.1526059 -95.00586446 2020-08-13 04:29:15 Kandiyohi, Minnesota, US
135765 2020-08-12 US Minnesota Kittson 27069 3 0 0 3 48.77754106 -96.78317184 2020-08-13 04:29:15 Kittson, Minnesota, US
135766 2020-08-12 US Minnesota Koochiching 27071 80 3 0 77 48.24539665 -93.78352843 2020-08-13 04:29:15 Koochiching, Minnesota, US
135767 2020-08-12 US Minnesota Lac qui Parle 27073 8 0 0 8 44.9973857 -96.17488219 2020-08-13 04:29:15 Lac qui Parle, Minnesota, US
135768 2020-08-12 US Minnesota Lake 27075 22 0 0 22 47.64270764 -91.44557998 2020-08-13 04:29:15 Lake, Minnesota, US
135769 2020-08-12 US Minnesota Lake of the Woods 27077 4 0 0 4 48.77217001 -94.90274472 2020-08-13 04:29:15 Lake of the Woods, Minnesota, US
135770 2020-08-12 US Minnesota Le Sueur 27079 230 1 0 229 44.37136597 -93.72844721 2020-08-13 04:29:15 Le Sueur, Minnesota, US
135771 2020-08-12 US Minnesota Lincoln 27081 59 0 0 59 44.41311883 -96.26688165 2020-08-13 04:29:15 Lincoln, Minnesota, US
135772 2020-08-12 US Minnesota Lyon 27083 425 3 0 422 44.41327865 -95.83806103 2020-08-13 04:29:15 Lyon, Minnesota, US
135773 2020-08-12 US Minnesota Mahnomen 27087 27 1 0 26 47.32557075 -95.80921485 2020-08-13 04:29:15 Mahnomen, Minnesota, US
135774 2020-08-12 US Minnesota Marshall 27089 29 0 0 29 48.35825983 -96.37017407 2020-08-13 04:29:15 Marshall, Minnesota, US
135775 2020-08-12 US Minnesota Martin 27091 209 5 0 204 43.67429718 -94.55099908 2020-08-13 04:29:15 Martin, Minnesota, US
135776 2020-08-12 US Minnesota McLeod 27085 208 0 0 208 44.82367677 -94.27287017 2020-08-13 04:29:15 McLeod, Minnesota, US
135777 2020-08-12 US Minnesota Meeker 27093 87 2 0 85 45.12328869 -94.52839455 2020-08-13 04:29:15 Meeker, Minnesota, US
135778 2020-08-12 US Minnesota Mille Lacs 27095 72 3 0 69 45.93705297 -93.63236823 2020-08-13 04:29:15 Mille Lacs, Minnesota, US
135779 2020-08-12 US Minnesota Morrison 27097 93 1 0 92 46.01265363 -94.27341528 2020-08-13 04:29:15 Morrison, Minnesota, US
135780 2020-08-12 US Minnesota Mower 27099 1107 2 0 1105 43.67142874 -92.75234549 2020-08-13 04:29:15 Mower, Minnesota, US
135781 2020-08-12 US Minnesota Murray 27101 124 1 0 123 44.02216709 -95.76328482 2020-08-13 04:29:15 Murray, Minnesota, US
135782 2020-08-12 US Minnesota Nicollet 27103 351 13 0 338 44.35291112 -94.24710352 2020-08-13 04:29:15 Nicollet, Minnesota, US
135783 2020-08-12 US Minnesota Nobles 27105 1773 6 0 1767 43.67434621 -95.75329576 2020-08-13 04:29:15 Nobles, Minnesota, US
135784 2020-08-12 US Minnesota Norman 27107 40 0 0 40 47.32628443 -96.45620947 2020-08-13 04:29:15 Norman, Minnesota, US
135785 2020-08-12 US Minnesota Olmsted 27109 1781 23 0 1758 44.00374114 -92.40209944 2020-08-13 04:29:15 Olmsted, Minnesota, US
135786 2020-08-12 US Minnesota Otter Tail 27111 198 3 0 195 46.40846929 -95.70835255 2020-08-13 04:29:15 Otter Tail, Minnesota, US
135787 2020-08-12 US Minnesota Pennington 27113 75 1 0 74 48.06642577 -96.0370814 2020-08-13 04:29:15 Pennington, Minnesota, US
135788 2020-08-12 US Minnesota Pine 27115 129 0 0 129 46.12105238 -92.74070188 2020-08-13 04:29:15 Pine, Minnesota, US
135789 2020-08-12 US Minnesota Pipestone 27117 158 9 0 149 44.02301619 -96.25841142 2020-08-13 04:29:15 Pipestone, Minnesota, US
135790 2020-08-12 US Minnesota Polk 27119 156 4 0 152 47.77372465 -96.40134647 2020-08-13 04:29:15 Polk, Minnesota, US
135791 2020-08-12 US Minnesota Pope 27121 48 0 0 48 45.58606667 -95.44451209 2020-08-13 04:29:15 Pope, Minnesota, US
135792 2020-08-12 US Minnesota Ramsey 27123 7775 269 0 7506 45.01625271 -93.09872295 2020-08-13 04:29:15 Ramsey, Minnesota, US
135793 2020-08-12 US Minnesota Red Lake 27125 24 0 0 24 47.87197525 -96.09561104 2020-08-13 04:29:15 Red Lake, Minnesota, US
135794 2020-08-12 US Minnesota Redwood 27127 36 0 0 36 44.40555844 -95.25207021 2020-08-13 04:29:15 Redwood, Minnesota, US
135795 2020-08-12 US Minnesota Renville 27129 67 5 0 62 44.72836381 -94.94553734 2020-08-13 04:29:15 Renville, Minnesota, US
135796 2020-08-12 US Minnesota Rice 27131 1042 8 0 1034 44.3543376 -93.29658715 2020-08-13 04:29:15 Rice, Minnesota, US
135797 2020-08-12 US Minnesota Rock 27133 85 0 0 85 43.67482683 -96.25296832 2020-08-13 04:29:15 Rock, Minnesota, US
135798 2020-08-12 US Minnesota Roseau 27135 53 0 0 53 48.77501878 -95.81079919 2020-08-13 04:29:15 Roseau, Minnesota, US
135799 2020-08-12 US Minnesota Scott 27139 1608 22 0 1586 44.6490231 -93.53340251 2020-08-13 04:29:15 Scott, Minnesota, US
135800 2020-08-12 US Minnesota Sherburne 27141 737 10 0 727 45.44447208 -93.77617511 2020-08-13 04:29:15 Sherburne, Minnesota, US
135801 2020-08-12 US Minnesota Sibley 27143 84 2 0 82 44.5796592 -94.23164924 2020-08-13 04:29:15 Sibley, Minnesota, US
135802 2020-08-12 US Minnesota St. Louis 27137 600 20 0 580 47.6048407 -92.46879855 2020-08-13 04:29:15 St. Louis, Minnesota, US
135803 2020-08-12 US Minnesota Stearns 27145 2913 20 0 2893 45.55192576 -94.61078221 2020-08-13 04:29:15 Stearns, Minnesota, US
135804 2020-08-12 US Minnesota Steele 27147 351 2 0 349 44.02240351 -93.22627088 2020-08-13 04:29:15 Steele, Minnesota, US
135805 2020-08-12 US Minnesota Stevens 27149 18 0 0 18 45.58613007 -96.00163705 2020-08-13 04:29:15 Stevens, Minnesota, US
135806 2020-08-12 US Minnesota Swift 27151 55 1 0 54 45.2829032 -95.68264092 2020-08-13 04:29:15 Swift, Minnesota, US
135807 2020-08-12 US Minnesota Todd 27153 429 2 0 427 46.06996226 -94.89785296 2020-08-13 04:29:15 Todd, Minnesota, US
135808 2020-08-12 US Minnesota Traverse 27155 11 0 0 11 45.77298854 -96.47062949 2020-08-13 04:29:15 Traverse, Minnesota, US
135809 2020-08-12 US Minnesota Unassigned 90027 133 46 0 87 48.77754106 0.0 2020-08-13 04:29:15 Unassigned, Minnesota, US
135810 2020-08-12 US Minnesota Wabasha 27157 92 0 0 92 44.28424356 -92.23121312 2020-08-13 04:29:15 Wabasha, Minnesota, US
135811 2020-08-12 US Minnesota Wadena 27159 27 0 0 27 46.58589171 -94.96968506 2020-08-13 04:29:15 Wadena, Minnesota, US
135812 2020-08-12 US Minnesota Waseca 27161 149 0 0 149 44.02211116 -93.58720034 2020-08-13 04:29:15 Waseca, Minnesota, US
135813 2020-08-12 US Minnesota Washington 27163 2192 47 0 2145 45.03864533 -92.88429635 2020-08-13 04:29:15 Washington, Minnesota, US
135814 2020-08-12 US Minnesota Watonwan 27165 328 1 0 327 43.97823903 -94.61413846 2020-08-13 04:29:15 Watonwan, Minnesota, US
135815 2020-08-12 US Minnesota Wilkin 27167 35 3 0 32 46.35721532 -96.4684375 2020-08-13 04:29:15 Wilkin, Minnesota, US
135816 2020-08-12 US Minnesota Winona 27169 265 16 0 249 43.98772283 -91.78081305 2020-08-13 04:29:15 Winona, Minnesota, US
135817 2020-08-12 US Minnesota Wright 27171 903 5 0 898 45.17297924 -93.96234781 2020-08-13 04:29:15 Wright, Minnesota, US
135818 2020-08-12 US Minnesota Yellow Medicine 27173 52 0 0 52 44.71710183 -95.86842453 2020-08-13 04:29:15 Yellow Medicine, Minnesota, US
502101 2020-08-11 US Minnesota Aitkin 27001 41 1 0 40 46.60962049 -93.4116826 2020-08-12 04:27:29 Aitkin, Minnesota, US
502102 2020-08-11 US Minnesota Anoka 27003 3752 115 0 3637 45.27476015 -93.24604565 2020-08-12 04:27:29 Anoka, Minnesota, US
502103 2020-08-11 US Minnesota Becker 27005 161 1 0 160 46.93479392 -95.67158144 2020-08-12 04:27:29 Becker, Minnesota, US
502104 2020-08-11 US Minnesota Beltrami 27007 244 0 0 244 47.97373527 -94.93732139 2020-08-12 04:27:29 Beltrami, Minnesota, US
502105 2020-08-11 US Minnesota Benton 27009 320 3 0 317 45.69804958 -93.99514135 2020-08-12 04:27:29 Benton, Minnesota, US
502106 2020-08-11 US Minnesota Big Stone 27011 22 0 0 22 45.42712824 -96.41403739 2020-08-12 04:27:29 Big Stone, Minnesota, US
502107 2020-08-11 US Minnesota Blue Earth 27013 932 5 0 927 44.03554215 -94.06699781 2020-08-12 04:27:29 Blue Earth, Minnesota, US
502108 2020-08-11 US Minnesota Brown 27015 89 2 0 87 44.24205652 -94.72562874 2020-08-12 04:27:29 Brown, Minnesota, US
502109 2020-08-11 US Minnesota Carlton 27017 142 0 0 142 46.59180601 -92.67601019 2020-08-12 04:27:29 Carlton, Minnesota, US
502110 2020-08-11 US Minnesota Carver 27019 878 3 0 875 44.82017001 -93.8009918 2020-08-12 04:27:29 Carver, Minnesota, US
502111 2020-08-11 US Minnesota Cass 27021 74 2 0 72 46.95043611 -94.32603968 2020-08-12 04:27:29 Cass, Minnesota, US
502112 2020-08-11 US Minnesota Chippewa 27023 107 1 0 106 45.02343421 -95.56403693 2020-08-12 04:27:29 Chippewa, Minnesota, 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 2066.092ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette