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

30,033 rows where province_or_state = "Minnesota" sorted by day descending

✎ View and edit SQL

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

province_or_state

  • Minnesota · 30,033 ✖

country_or_region

  • US 30,033
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
955009 955009 2021-03-05 US Minnesota Aitkin 27001 1192 33 0 1159 46.60962049 -93.4116826 2021-03-06 04:23:41 Aitkin, Minnesota, US
955010 955010 2021-03-05 US Minnesota Anoka 27003 33430 390 0 33040 45.27476015 -93.24604565 2021-03-06 04:23:41 Anoka, Minnesota, US
955011 955011 2021-03-05 US Minnesota Becker 27005 3139 42 0 3097 46.93479392 -95.67158144 2021-03-06 04:23:41 Becker, Minnesota, US
955012 955012 2021-03-05 US Minnesota Beltrami 27007 3387 51 0 3336 47.97373527 -94.93732139 2021-03-06 04:23:41 Beltrami, Minnesota, US
955013 955013 2021-03-05 US Minnesota Benton 27009 4492 90 0 4402 45.69804958 -93.99514135 2021-03-06 04:23:41 Benton, Minnesota, US
955014 955014 2021-03-05 US Minnesota Big Stone 27011 516 3 0 513 45.42712824 -96.41403739 2021-03-06 04:23:41 Big Stone, Minnesota, US
955015 955015 2021-03-05 US Minnesota Blue Earth 27013 5996 35 0 5961 44.03554215 -94.06699781 2021-03-06 04:23:41 Blue Earth, Minnesota, US
955016 955016 2021-03-05 US Minnesota Brown 27015 2472 37 0 2435 44.24205652 -94.72562874 2021-03-06 04:23:41 Brown, Minnesota, US
955017 955017 2021-03-05 US Minnesota Carlton 27017 3002 49 0 2953 46.59180601 -92.67601019 2021-03-06 04:23:41 Carlton, Minnesota, US
955018 955018 2021-03-05 US Minnesota Carver 27019 7832 41 0 7791 44.82017001 -93.8009918 2021-03-06 04:23:41 Carver, Minnesota, US
955019 955019 2021-03-05 US Minnesota Cass 27021 2210 24 0 2186 46.95043611 -94.32603968 2021-03-06 04:23:41 Cass, Minnesota, US
955020 955020 2021-03-05 US Minnesota Chippewa 27023 1368 35 0 1333 45.02343421 -95.56403693 2021-03-06 04:23:41 Chippewa, Minnesota, US
955021 955021 2021-03-05 US Minnesota Chisago 27025 5010 45 0 4965 45.5021011 -92.90861945 2021-03-06 04:23:41 Chisago, Minnesota, US
955022 955022 2021-03-05 US Minnesota Clay 27027 6945 87 0 6858 46.89289518 -96.48761922 2021-03-06 04:23:41 Clay, Minnesota, US
955023 955023 2021-03-05 US Minnesota Clearwater 27029 719 14 0 705 47.57992111 -95.37790562 2021-03-06 04:23:41 Clearwater, Minnesota, US
955024 955024 2021-03-05 US Minnesota Cook 27031 118 0 0 118 47.90504893 -90.52629546 2021-03-06 04:23:41 Cook, Minnesota, US
955025 955025 2021-03-05 US Minnesota Cottonwood 27033 1359 20 0 1339 44.00715262 -95.18138802 2021-03-06 04:23:41 Cottonwood, Minnesota, US
955026 955026 2021-03-05 US Minnesota Crow Wing 27035 5227 82 0 5145 46.48096553 -94.06755609 2021-03-06 04:23:41 Crow Wing, Minnesota, US
955027 955027 2021-03-05 US Minnesota Dakota 27037 36543 394 0 36149 44.67172617 -93.06299363 2021-03-06 04:23:41 Dakota, Minnesota, US
955028 955028 2021-03-05 US Minnesota Dodge 27039 1538 4 0 1534 44.02238415 -92.86244324 2021-03-06 04:23:41 Dodge, Minnesota, US
955029 955029 2021-03-05 US Minnesota Douglas 27041 3937 68 0 3869 45.93348491 -95.45335469 2021-03-06 04:23:41 Douglas, Minnesota, US
955030 955030 2021-03-05 US Minnesota Faribault 27043 1245 17 0 1228 43.67381499 -93.94787458 2021-03-06 04:23:41 Faribault, Minnesota, US
955031 955031 2021-03-05 US Minnesota Fillmore 27045 1390 8 0 1382 43.67394126 -92.08980382 2021-03-06 04:23:41 Fillmore, Minnesota, US
955032 955032 2021-03-05 US Minnesota Freeborn 27047 2858 24 0 2834 43.67385583 -93.34884422 2021-03-06 04:23:41 Freeborn, Minnesota, US
955033 955033 2021-03-05 US Minnesota Goodhue 27049 3880 69 0 3811 44.40849741 -92.7234195 2021-03-06 04:23:41 Goodhue, Minnesota, US
955034 955034 2021-03-05 US Minnesota Grant 27051 491 8 0 483 45.93424769 -96.01139609 2021-03-06 04:23:41 Grant, Minnesota, US
955035 955035 2021-03-05 US Minnesota Hennepin 27053 101285 1589 0 99696 45.00761521 -93.47694895 2021-03-06 04:23:41 Hennepin, Minnesota, US
955036 955036 2021-03-05 US Minnesota Houston 27055 1581 14 0 1567 43.67129565 -91.49143057 2021-03-06 04:23:41 Houston, Minnesota, US
955037 955037 2021-03-05 US Minnesota Hubbard 27057 1607 41 0 1566 47.10778564 -94.91693868 2021-03-06 04:23:41 Hubbard, Minnesota, US
955038 955038 2021-03-05 US Minnesota Isanti 27059 3082 56 0 3026 45.56181234 -93.29487636 2021-03-06 04:23:41 Isanti, Minnesota, US
955039 955039 2021-03-05 US Minnesota Itasca 27061 3142 46 0 3096 47.51009045 -93.63092229 2021-03-06 04:23:41 Itasca, Minnesota, US
955040 955040 2021-03-05 US Minnesota Jackson 27063 942 10 0 932 43.67423373 -95.15398258 2021-03-06 04:23:41 Jackson, Minnesota, US
955041 955041 2021-03-05 US Minnesota Kanabec 27065 1081 19 0 1062 45.9459309 -93.29275192 2021-03-06 04:23:41 Kanabec, Minnesota, US
955042 955042 2021-03-05 US Minnesota Kandiyohi 27067 5806 74 0 5732 45.1526059 -95.00586446 2021-03-06 04:23:41 Kandiyohi, Minnesota, US
955043 955043 2021-03-05 US Minnesota Kittson 27069 409 21 0 388 48.77754106 -96.78317184 2021-03-06 04:23:41 Kittson, Minnesota, US
955044 955044 2021-03-05 US Minnesota Koochiching 27071 621 11 0 610 48.24539665 -93.78352843 2021-03-06 04:23:41 Koochiching, Minnesota, US
955045 955045 2021-03-05 US Minnesota Lac qui Parle 27073 686 16 0 670 44.9973857 -96.17488219 2021-03-06 04:23:41 Lac qui Parle, Minnesota, US
955046 955046 2021-03-05 US Minnesota Lake 27075 742 18 0 724 47.64270764 -91.44557998 2021-03-06 04:23:41 Lake, Minnesota, US
955047 955047 2021-03-05 US Minnesota Lake of the Woods 27077 222 1 0 221 48.77217001 -94.90274472 2021-03-06 04:23:41 Lake of the Woods, Minnesota, US
955048 955048 2021-03-05 US Minnesota Le Sueur 27079 2374 20 0 2354 44.37136597 -93.72844721 2021-03-06 04:23:41 Le Sueur, Minnesota, US
955049 955049 2021-03-05 US Minnesota Lincoln 27081 512 2 0 510 44.41311883 -96.26688165 2021-03-06 04:23:41 Lincoln, Minnesota, US
955050 955050 2021-03-05 US Minnesota Lyon 27083 3138 44 0 3094 44.41327865 -95.83806103 2021-03-06 04:23:41 Lyon, Minnesota, US
955051 955051 2021-03-05 US Minnesota Mahnomen 27087 443 7 0 436 47.32557075 -95.80921485 2021-03-06 04:23:41 Mahnomen, Minnesota, US
955052 955052 2021-03-05 US Minnesota Marshall 27089 784 15 0 769 48.35825983 -96.37017407 2021-03-06 04:23:41 Marshall, Minnesota, US
955053 955053 2021-03-05 US Minnesota Martin 27091 1906 29 0 1877 43.67429718 -94.55099908 2021-03-06 04:23:41 Martin, Minnesota, US
955054 955054 2021-03-05 US Minnesota McLeod 27085 3405 50 0 3355 44.82367677 -94.27287017 2021-03-06 04:23:41 McLeod, Minnesota, US
955055 955055 2021-03-05 US Minnesota Meeker 27093 2081 34 0 2047 45.12328869 -94.52839455 2021-03-06 04:23:41 Meeker, Minnesota, US
955056 955056 2021-03-05 US Minnesota Mille Lacs 27095 2290 47 0 2243 45.93705297 -93.63236823 2021-03-06 04:23:41 Mille Lacs, Minnesota, US
955057 955057 2021-03-05 US Minnesota Morrison 27097 3262 47 0 3215 46.01265363 -94.27341528 2021-03-06 04:23:41 Morrison, Minnesota, US
955058 955058 2021-03-05 US Minnesota Mower 27099 4100 31 0 4069 43.67142874 -92.75234549 2021-03-06 04:23:41 Mower, Minnesota, US
955059 955059 2021-03-05 US Minnesota Murray 27101 953 8 0 945 44.02216709 -95.76328482 2021-03-06 04:23:41 Murray, Minnesota, US
955060 955060 2021-03-05 US Minnesota Nicollet 27103 2615 41 0 2574 44.35291112 -94.24710352 2021-03-06 04:23:41 Nicollet, Minnesota, US
955061 955061 2021-03-05 US Minnesota Nobles 27105 3871 47 0 3824 43.67434621 -95.75329576 2021-03-06 04:23:41 Nobles, Minnesota, US
955062 955062 2021-03-05 US Minnesota Norman 27107 478 8 0 470 47.32628443 -96.45620947 2021-03-06 04:23:41 Norman, Minnesota, US
955063 955063 2021-03-05 US Minnesota Olmsted 27109 11848 90 0 11758 44.00374114 -92.40209944 2021-03-06 04:23:41 Olmsted, Minnesota, US
955064 955064 2021-03-05 US Minnesota Otter Tail 27111 4855 70 0 4785 46.40846929 -95.70835255 2021-03-06 04:23:41 Otter Tail, Minnesota, US
955065 955065 2021-03-05 US Minnesota Pennington 27113 1377 16 0 1361 48.06642577 -96.0370814 2021-03-06 04:23:41 Pennington, Minnesota, US
955066 955066 2021-03-05 US Minnesota Pine 27115 2826 16 0 2810 46.12105238 -92.74070188 2021-03-06 04:23:41 Pine, Minnesota, US
955067 955067 2021-03-05 US Minnesota Pipestone 27117 1018 24 0 994 44.02301619 -96.25841142 2021-03-06 04:23:41 Pipestone, Minnesota, US
955068 955068 2021-03-05 US Minnesota Polk 27119 3446 63 0 3383 47.77372465 -96.40134647 2021-03-06 04:23:41 Polk, Minnesota, US
955069 955069 2021-03-05 US Minnesota Pope 27121 809 5 0 804 45.58606667 -95.44451209 2021-03-06 04:23:41 Pope, Minnesota, US
955070 955070 2021-03-05 US Minnesota Ramsey 27123 43273 808 0 42465 45.01625271 -93.09872295 2021-03-06 04:23:41 Ramsey, Minnesota, US
955071 955071 2021-03-05 US Minnesota Red Lake 27125 361 5 0 356 47.87197525 -96.09561104 2021-03-06 04:23:41 Red Lake, Minnesota, US
955072 955072 2021-03-05 US Minnesota Redwood 27127 1471 27 0 1444 44.40555844 -95.25207021 2021-03-06 04:23:41 Redwood, Minnesota, US
955073 955073 2021-03-05 US Minnesota Renville 27129 1516 40 0 1476 44.72836381 -94.94553734 2021-03-06 04:23:41 Renville, Minnesota, US
955074 955074 2021-03-05 US Minnesota Rice 27131 6722 91 0 6631 44.3543376 -93.29658715 2021-03-06 04:23:41 Rice, Minnesota, US
955075 955075 2021-03-05 US Minnesota Rock 27133 1161 14 0 1147 43.67482683 -96.25296832 2021-03-06 04:23:41 Rock, Minnesota, US
955076 955076 2021-03-05 US Minnesota Roseau 27135 1809 17 0 1792 48.77501878 -95.81079919 2021-03-06 04:23:41 Roseau, Minnesota, US
955077 955077 2021-03-05 US Minnesota Scott 27139 13381 107 0 13274 44.6490231 -93.53340251 2021-03-06 04:23:41 Scott, Minnesota, US
955078 955078 2021-03-05 US Minnesota Sherburne 27141 8771 74 0 8697 45.44447208 -93.77617511 2021-03-06 04:23:41 Sherburne, Minnesota, US
955079 955079 2021-03-05 US Minnesota Sibley 27143 1176 10 0 1166 44.5796592 -94.23164924 2021-03-06 04:23:41 Sibley, Minnesota, US
955080 955080 2021-03-05 US Minnesota St. Louis 27137 14866 265 0 14601 47.6048407 -92.46879855 2021-03-06 04:23:41 St. Louis, Minnesota, US
955081 955081 2021-03-05 US Minnesota Stearns 27145 18786 202 0 18584 45.55192576 -94.61078221 2021-03-06 04:23:41 Stearns, Minnesota, US
955082 955082 2021-03-05 US Minnesota Steele 27147 3030 11 0 3019 44.02240351 -93.22627088 2021-03-06 04:23:41 Steele, Minnesota, US
955083 955083 2021-03-05 US Minnesota Stevens 27149 746 8 0 738 45.58613007 -96.00163705 2021-03-06 04:23:41 Stevens, Minnesota, US
955084 955084 2021-03-05 US Minnesota Swift 27151 878 18 0 860 45.2829032 -95.68264092 2021-03-06 04:23:41 Swift, Minnesota, US
955085 955085 2021-03-05 US Minnesota Todd 27153 2492 30 0 2462 46.06996226 -94.89785296 2021-03-06 04:23:41 Todd, Minnesota, US
955086 955086 2021-03-05 US Minnesota Traverse 27155 310 5 0 305 45.77298854 -96.47062949 2021-03-06 04:23:41 Traverse, Minnesota, US
955087 955087 2021-03-05 US Minnesota Unassigned 90027 447 68 0 379 48.77754106 0.0 2021-03-06 04:23:41 Unassigned, Minnesota, US
955088 955088 2021-03-05 US Minnesota Wabasha 27157 1871 3 0 1868 44.28424356 -92.23121312 2021-03-06 04:23:41 Wabasha, Minnesota, US
955089 955089 2021-03-05 US Minnesota Wadena 27159 1313 20 0 1293 46.58589171 -94.96968506 2021-03-06 04:23:41 Wadena, Minnesota, US
955090 955090 2021-03-05 US Minnesota Waseca 27161 2101 17 0 2084 44.02211116 -93.58720034 2021-03-06 04:23:41 Waseca, Minnesota, US
955091 955091 2021-03-05 US Minnesota Washington 27163 22183 261 0 21922 45.03864533 -92.88429635 2021-03-06 04:23:41 Washington, Minnesota, US
955092 955092 2021-03-05 US Minnesota Watonwan 27165 1179 8 0 1171 43.97823903 -94.61413846 2021-03-06 04:23:41 Watonwan, Minnesota, US
955093 955093 2021-03-05 US Minnesota Wilkin 27167 677 11 0 666 46.35721532 -96.4684375 2021-03-06 04:23:41 Wilkin, Minnesota, US
955094 955094 2021-03-05 US Minnesota Winona 27169 4200 49 0 4151 43.98772283 -91.78081305 2021-03-06 04:23:41 Winona, Minnesota, US
955095 955095 2021-03-05 US Minnesota Wright 27171 12580 116 0 12464 45.17297924 -93.96234781 2021-03-06 04:23:41 Wright, Minnesota, US
955096 955096 2021-03-05 US Minnesota Yellow Medicine 27173 977 17 0 960 44.71710183 -95.86842453 2021-03-06 04:23:41 Yellow Medicine, Minnesota, US
902369 902369 2021-03-04 US Minnesota Aitkin 27001 1191 33 0 1158 46.60962049 -93.4116826 2021-03-05 05:26:29 Aitkin, Minnesota, US
902370 902370 2021-03-04 US Minnesota Anoka 27003 33391 390 0 33001 45.27476015 -93.24604565 2021-03-05 05:26:29 Anoka, Minnesota, US
902371 902371 2021-03-04 US Minnesota Becker 27005 3131 42 0 3089 46.93479392 -95.67158144 2021-03-05 05:26:29 Becker, Minnesota, US
902372 902372 2021-03-04 US Minnesota Beltrami 27007 3386 51 0 3335 47.97373527 -94.93732139 2021-03-05 05:26:29 Beltrami, Minnesota, US
902373 902373 2021-03-04 US Minnesota Benton 27009 4482 90 0 4392 45.69804958 -93.99514135 2021-03-05 05:26:29 Benton, Minnesota, US
902374 902374 2021-03-04 US Minnesota Big Stone 27011 516 3 0 513 45.42712824 -96.41403739 2021-03-05 05:26:29 Big Stone, Minnesota, US
902375 902375 2021-03-04 US Minnesota Blue Earth 27013 5983 35 0 5948 44.03554215 -94.06699781 2021-03-05 05:26:29 Blue Earth, Minnesota, US
902376 902376 2021-03-04 US Minnesota Brown 27015 2461 37 0 2424 44.24205652 -94.72562874 2021-03-05 05:26:29 Brown, Minnesota, US
902377 902377 2021-03-04 US Minnesota Carlton 27017 3001 49 0 2952 46.59180601 -92.67601019 2021-03-05 05:26:29 Carlton, Minnesota, US
902378 902378 2021-03-04 US Minnesota Carver 27019 7798 40 0 7758 44.82017001 -93.8009918 2021-03-05 05:26:29 Carver, Minnesota, US
902379 902379 2021-03-04 US Minnesota Cass 27021 2207 24 0 2183 46.95043611 -94.32603968 2021-03-05 05:26:29 Cass, Minnesota, US
902380 902380 2021-03-04 US Minnesota Chippewa 27023 1367 35 0 1332 45.02343421 -95.56403693 2021-03-05 05:26: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]);