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

50,449 rows where province_or_state = "Minnesota" 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

  • Minnesota · 50,449 ✖

country_or_region

  • US 50,449
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
33978 33978 2021-10-23 US Minnesota Aitkin 27001 1840 43 0   46.60962049 -93.41168259999999 2021-10-24 04:21:22 Aitkin, Minnesota, US
33979 33979 2021-10-23 US Minnesota Anoka 27003 54052 520 0   45.27476015 -93.24604565 2021-10-24 04:21:22 Anoka, Minnesota, US
33980 33980 2021-10-23 US Minnesota Becker 27005 5348 62 0   46.93479392 -95.67158144 2021-10-24 04:21:22 Becker, Minnesota, US
33981 33981 2021-10-23 US Minnesota Beltrami 27007 6580 79 0   47.97373527 -94.93732139 2021-10-24 04:21:22 Beltrami, Minnesota, US
33982 33982 2021-10-23 US Minnesota Benton 27009 7477 111 0   45.69804958 -93.99514135 2021-10-24 04:21:22 Benton, Minnesota, US
33983 33983 2021-10-23 US Minnesota Big Stone 27011 797 4 0   45.42712824 -96.41403739 2021-10-24 04:21:22 Big Stone, Minnesota, US
33984 33984 2021-10-23 US Minnesota Blue Earth 27013 9666 59 0   44.03554215 -94.06699781 2021-10-24 04:21:22 Blue Earth, Minnesota, US
33985 33985 2021-10-23 US Minnesota Brown 27015 4115 47 0   44.24205652 -94.72562874 2021-10-24 04:21:22 Brown, Minnesota, US
33986 33986 2021-10-23 US Minnesota Carlton 27017 4468 66 0   46.59180601 -92.67601019 2021-10-24 04:21:22 Carlton, Minnesota, US
33987 33987 2021-10-23 US Minnesota Carver 27019 13665 56 0   44.82017001 -93.80099179999999 2021-10-24 04:21:22 Carver, Minnesota, US
33988 33988 2021-10-23 US Minnesota Cass 27021 4257 45 0   46.95043611 -94.32603968 2021-10-24 04:21:22 Cass, Minnesota, US
33989 33989 2021-10-23 US Minnesota Chippewa 27023 1903 40 0   45.02343421 -95.56403693 2021-10-24 04:21:22 Chippewa, Minnesota, US
33990 33990 2021-10-23 US Minnesota Chisago 27025 8372 63 0   45.5021011 -92.90861945 2021-10-24 04:21:22 Chisago, Minnesota, US
33991 33991 2021-10-23 US Minnesota Clay 27027 10253 99 0   46.89289518 -96.48761922 2021-10-24 04:21:22 Clay, Minnesota, US
33992 33992 2021-10-23 US Minnesota Clearwater 27029 1366 18 0   47.57992111 -95.37790562 2021-10-24 04:21:22 Clearwater, Minnesota, US
33993 33993 2021-10-23 US Minnesota Cook 27031 246 0 0   47.90504893 -90.52629546 2021-10-24 04:21:22 Cook, Minnesota, US
33994 33994 2021-10-23 US Minnesota Cottonwood 27033 1971 28 0   44.00715262 -95.18138802 2021-10-24 04:21:22 Cottonwood, Minnesota, US
33995 33995 2021-10-23 US Minnesota Crow Wing 27035 9518 109 0   46.48096553 -94.06755609 2021-10-24 04:21:22 Crow Wing, Minnesota, US
33996 33996 2021-10-23 US Minnesota Dakota 27037 57071 526 0   44.67172617 -93.06299363 2021-10-24 04:21:22 Dakota, Minnesota, US
33997 33997 2021-10-23 US Minnesota Dodge 27039 2735 10 0   44.02238415 -92.86244324 2021-10-24 04:21:22 Dodge, Minnesota, US
33998 33998 2021-10-23 US Minnesota Douglas 27041 6291 90 0   45.93348491 -95.45335469 2021-10-24 04:21:22 Douglas, Minnesota, US
33999 33999 2021-10-23 US Minnesota Faribault 27043 2206 30 0   43.67381499 -93.94787458 2021-10-24 04:21:22 Faribault, Minnesota, US
34000 34000 2021-10-23 US Minnesota Fillmore 27045 2438 12 0   43.67394126 -92.08980382 2021-10-24 04:21:22 Fillmore, Minnesota, US
34001 34001 2021-10-23 US Minnesota Freeborn 27047 4876 42 0   43.67385583 -93.34884422 2021-10-24 04:21:22 Freeborn, Minnesota, US
34002 34002 2021-10-23 US Minnesota Goodhue 27049 6199 85 0   44.40849741 -92.72341949999999 2021-10-24 04:21:22 Goodhue, Minnesota, US
34003 34003 2021-10-23 US Minnesota Grant 27051 786 9 0   45.93424769 -96.01139609 2021-10-24 04:21:22 Grant, Minnesota, US
34004 34004 2021-10-23 US Minnesota Hennepin 27053 153749 1923 0   45.00761521 -93.47694895 2021-10-24 04:21:22 Hennepin, Minnesota, US
34005 34005 2021-10-23 US Minnesota Houston 27055 2311 17 0   43.67129565 -91.49143057 2021-10-24 04:21:22 Houston, Minnesota, US
34006 34006 2021-10-23 US Minnesota Hubbard 27057 2927 44 0   47.10778564 -94.91693868 2021-10-24 04:21:22 Hubbard, Minnesota, US
34007 34007 2021-10-23 US Minnesota Isanti 27059 5730 74 0   45.56181234 -93.29487636 2021-10-24 04:21:22 Isanti, Minnesota, US
34008 34008 2021-10-23 US Minnesota Itasca 27061 6188 85 0   47.51009045 -93.63092229 2021-10-24 04:21:22 Itasca, Minnesota, US
34009 34009 2021-10-23 US Minnesota Jackson 27063 1473 15 0   43.67423373 -95.15398258 2021-10-24 04:21:22 Jackson, Minnesota, US
34010 34010 2021-10-23 US Minnesota Kanabec 27065 1922 30 0   45.9459309 -93.29275192 2021-10-24 04:21:22 Kanabec, Minnesota, US
34011 34011 2021-10-23 US Minnesota Kandiyohi 27067 8351 97 0   45.1526059 -95.00586446 2021-10-24 04:21:22 Kandiyohi, Minnesota, US
34012 34012 2021-10-23 US Minnesota Kittson 27069 611 22 0   48.77754106 -96.78317184 2021-10-24 04:21:22 Kittson, Minnesota, US
34013 34013 2021-10-23 US Minnesota Koochiching 27071 1386 19 0   48.24539665 -93.78352843 2021-10-24 04:21:22 Koochiching, Minnesota, US
34014 34014 2021-10-23 US Minnesota Lac qui Parle 27073 985 24 0   44.9973857 -96.17488219 2021-10-24 04:21:22 Lac qui Parle, Minnesota, US
34015 34015 2021-10-23 US Minnesota Lake 27075 1095 21 0   47.64270764 -91.44557998 2021-10-24 04:21:22 Lake, Minnesota, US
34016 34016 2021-10-23 US Minnesota Lake of the Woods 27077 476 4 0   48.77217001 -94.90274472 2021-10-24 04:21:22 Lake of the Woods, Minnesota, US
34017 34017 2021-10-23 US Minnesota Le Sueur 27079 3863 32 0   44.37136597 -93.72844721 2021-10-24 04:21:22 Le Sueur, Minnesota, US
34018 34018 2021-10-23 US Minnesota Lincoln 27081 784 5 0   44.41311883 -96.26688165 2021-10-24 04:21:22 Lincoln, Minnesota, US
34019 34019 2021-10-23 US Minnesota Lyon 27083 4563 56 0   44.41327865 -95.83806103 2021-10-24 04:21:22 Lyon, Minnesota, US
34020 34020 2021-10-23 US Minnesota Mahnomen 27087 903 12 0   47.32557075 -95.80921485 2021-10-24 04:21:22 Mahnomen, Minnesota, US
34021 34021 2021-10-23 US Minnesota Marshall 27089 1345 20 0   48.35825983 -96.37017407 2021-10-24 04:21:22 Marshall, Minnesota, US
34022 34022 2021-10-23 US Minnesota Martin 27091 3263 36 0   43.67429718 -94.55099908 2021-10-24 04:21:22 Martin, Minnesota, US
34023 34023 2021-10-23 US Minnesota McLeod 27085 5957 70 0   44.82367677 -94.27287017 2021-10-24 04:21:22 McLeod, Minnesota, US
34024 34024 2021-10-23 US Minnesota Meeker 27093 3568 54 0   45.12328869 -94.52839455 2021-10-24 04:21:22 Meeker, Minnesota, US
34025 34025 2021-10-23 US Minnesota Mille Lacs 27095 4169 67 0   45.93705297 -93.63236823 2021-10-24 04:21:22 Mille Lacs, Minnesota, US
34026 34026 2021-10-23 US Minnesota Morrison 27097 5577 67 0   46.01265363 -94.27341528 2021-10-24 04:21:22 Morrison, Minnesota, US
34027 34027 2021-10-23 US Minnesota Mower 27099 6455 41 0   43.67142874 -92.75234549 2021-10-24 04:21:22 Mower, Minnesota, US
34028 34028 2021-10-23 US Minnesota Murray 27101 1350 11 0   44.02216709 -95.76328482 2021-10-24 04:21:22 Murray, Minnesota, US
34029 34029 2021-10-23 US Minnesota Nicollet 27103 4344 54 0   44.35291112 -94.24710352 2021-10-24 04:21:22 Nicollet, Minnesota, US
34030 34030 2021-10-23 US Minnesota Nobles 27105 4816 52 0   43.67434621 -95.75329576 2021-10-24 04:21:22 Nobles, Minnesota, US
34031 34031 2021-10-23 US Minnesota Norman 27107 878 9 0   47.32628443 -96.45620947 2021-10-24 04:21:22 Norman, Minnesota, US
34032 34032 2021-10-23 US Minnesota Olmsted 27109 18144 120 0   44.00374114 -92.40209944 2021-10-24 04:21:22 Olmsted, Minnesota, US
34033 34033 2021-10-23 US Minnesota Otter Tail 27111 8061 105 0   46.40846929 -95.70835255 2021-10-24 04:21:22 Otter Tail, Minnesota, US
34034 34034 2021-10-23 US Minnesota Pennington 27113 2172 27 0   48.06642577 -96.0370814 2021-10-24 04:21:22 Pennington, Minnesota, US
34035 34035 2021-10-23 US Minnesota Pine 27115 4285 32 0   46.12105238 -92.74070188 2021-10-24 04:21:22 Pine, Minnesota, US
34036 34036 2021-10-23 US Minnesota Pipestone 27117 1334 27 0   44.02301619 -96.25841142 2021-10-24 04:21:22 Pipestone, Minnesota, US
34037 34037 2021-10-23 US Minnesota Polk 27119 5128 79 0   47.77372465 -96.40134647 2021-10-24 04:21:22 Polk, Minnesota, US
34038 34038 2021-10-23 US Minnesota Pope 27121 1614 8 0   45.58606667 -95.44451209 2021-10-24 04:21:22 Pope, Minnesota, US
34039 34039 2021-10-23 US Minnesota Ramsey 27123 63444 980 0   45.01625271 -93.09872295 2021-10-24 04:21:22 Ramsey, Minnesota, US
34040 34040 2021-10-23 US Minnesota Red Lake 27125 589 9 0   47.87197525 -96.09561104 2021-10-24 04:21:22 Red Lake, Minnesota, US
34041 34041 2021-10-23 US Minnesota Redwood 27127 2404 43 0   44.40555844 -95.25207021 2021-10-24 04:21:22 Redwood, Minnesota, US
34042 34042 2021-10-23 US Minnesota Renville 27129 2285 49 0   44.72836381 -94.94553734 2021-10-24 04:21:22 Renville, Minnesota, US
34043 34043 2021-10-23 US Minnesota Rice 27131 9985 131 0   44.3543376 -93.29658715 2021-10-24 04:21:22 Rice, Minnesota, US
34044 34044 2021-10-23 US Minnesota Rock 27133 1553 19 0   43.67482683 -96.25296832 2021-10-24 04:21:22 Rock, Minnesota, US
34045 34045 2021-10-23 US Minnesota Roseau 27135 2652 27 0   48.77501878 -95.81079919 2021-10-24 04:21:22 Roseau, Minnesota, US
34046 34046 2021-10-23 US Minnesota Scott 27139 21652 160 0   44.6490231 -93.53340251 2021-10-24 04:21:22 Scott, Minnesota, US
34047 34047 2021-10-23 US Minnesota Sherburne 27141 15515 115 0   45.44447208 -93.77617511 2021-10-24 04:21:22 Sherburne, Minnesota, US
34048 34048 2021-10-23 US Minnesota Sibley 27143 2116 12 0   44.5796592 -94.23164924 2021-10-24 04:21:22 Sibley, Minnesota, US
34049 34049 2021-10-23 US Minnesota St. Louis 27137 23735 361 0   47.604840700000004 -92.46879855 2021-10-24 04:21:22 St. Louis, Minnesota, US
34050 34050 2021-10-23 US Minnesota Stearns 27145 28419 253 0   45.55192576 -94.61078221 2021-10-24 04:21:22 Stearns, Minnesota, US
34051 34051 2021-10-23 US Minnesota Steele 27147 5858 25 0   44.02240351 -93.22627088 2021-10-24 04:21:22 Steele, Minnesota, US
34052 34052 2021-10-23 US Minnesota Stevens 27149 1249 11 0   45.58613007 -96.00163705 2021-10-24 04:21:22 Stevens, Minnesota, US
34053 34053 2021-10-23 US Minnesota Swift 27151 1346 19 0   45.2829032 -95.68264092 2021-10-24 04:21:22 Swift, Minnesota, US
34054 34054 2021-10-23 US Minnesota Todd 27153 4000 36 0   46.06996226 -94.89785296 2021-10-24 04:21:22 Todd, Minnesota, US
34055 34055 2021-10-23 US Minnesota Traverse 27155 516 5 0   45.77298854 -96.47062949 2021-10-24 04:21:22 Traverse, Minnesota, US
34056 34056 2021-10-23 US Minnesota Unassigned 90027 538 124 0   48.77754106 0.0 2021-10-24 04:21:22 Unassigned, Minnesota, US
34057 34057 2021-10-23 US Minnesota Wabasha 27157 2953 8 0   44.28424356 -92.23121312 2021-10-24 04:21:22 Wabasha, Minnesota, US
34058 34058 2021-10-23 US Minnesota Wadena 27159 2384 29 0   46.58589171 -94.96968506 2021-10-24 04:21:22 Wadena, Minnesota, US
34059 34059 2021-10-23 US Minnesota Waseca 27161 3273 31 0   44.02211116 -93.58720034 2021-10-24 04:21:22 Waseca, Minnesota, US
34060 34060 2021-10-23 US Minnesota Washington 27163 33690 331 0   45.03864533 -92.88429635 2021-10-24 04:21:22 Washington, Minnesota, US
34061 34061 2021-10-23 US Minnesota Watonwan 27165 1711 12 0   43.97823903 -94.61413846 2021-10-24 04:21:22 Watonwan, Minnesota, US
34062 34062 2021-10-23 US Minnesota Wilkin 27167 1028 14 0   46.35721532 -96.4684375 2021-10-24 04:21:22 Wilkin, Minnesota, US
34063 34063 2021-10-23 US Minnesota Winona 27169 6118 54 0   43.98772283 -91.78081305 2021-10-24 04:21:22 Winona, Minnesota, US
34064 34064 2021-10-23 US Minnesota Wright 27171 21388 171 0   45.17297924 -93.96234781 2021-10-24 04:21:22 Wright, Minnesota, US
34065 34065 2021-10-23 US Minnesota Yellow Medicine 27173 1572 20 0   44.71710183 -95.86842453 2021-10-24 04:21:22 Yellow Medicine, Minnesota, US
314462 314462 2021-10-22 US Minnesota Aitkin 27001 1840 43 0   46.60962049 -93.41168259999999 2021-10-23 04:21:32 Aitkin, Minnesota, US
314463 314463 2021-10-22 US Minnesota Anoka 27003 54052 520 0   45.27476015 -93.24604565 2021-10-23 04:21:32 Anoka, Minnesota, US
314464 314464 2021-10-22 US Minnesota Becker 27005 5348 62 0   46.93479392 -95.67158144 2021-10-23 04:21:32 Becker, Minnesota, US
314465 314465 2021-10-22 US Minnesota Beltrami 27007 6580 79 0   47.97373527 -94.93732139 2021-10-23 04:21:32 Beltrami, Minnesota, US
314466 314466 2021-10-22 US Minnesota Benton 27009 7477 111 0   45.69804958 -93.99514135 2021-10-23 04:21:32 Benton, Minnesota, US
314467 314467 2021-10-22 US Minnesota Big Stone 27011 797 4 0   45.42712824 -96.41403739 2021-10-23 04:21:32 Big Stone, Minnesota, US
314468 314468 2021-10-22 US Minnesota Blue Earth 27013 9666 59 0   44.03554215 -94.06699781 2021-10-23 04:21:32 Blue Earth, Minnesota, US
314469 314469 2021-10-22 US Minnesota Brown 27015 4115 47 0   44.24205652 -94.72562874 2021-10-23 04:21:32 Brown, Minnesota, US
314470 314470 2021-10-22 US Minnesota Carlton 27017 4468 66 0   46.59180601 -92.67601019 2021-10-23 04:21:32 Carlton, Minnesota, US
314471 314471 2021-10-22 US Minnesota Carver 27019 13665 56 0   44.82017001 -93.80099179999999 2021-10-23 04:21:32 Carver, Minnesota, US
314472 314472 2021-10-22 US Minnesota Cass 27021 4257 45 0   46.95043611 -94.32603968 2021-10-23 04:21:32 Cass, Minnesota, US
314473 314473 2021-10-22 US Minnesota Chippewa 27023 1903 40 0   45.02343421 -95.56403693 2021-10-23 04:21:32 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]);