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

88,465 rows where country_or_region = "US" and province_or_state = "Minnesota" sorted by day descending

✎ View and edit SQL

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

Suggested facets: last_update (date)

province_or_state 1

  • Minnesota · 88,465 ✖

country_or_region 1

  • US · 88,465 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2754604 2754604 2022-12-29 US Minnesota Aitkin 27001 3623 65 0   46.60962049 -93.4116826 2022-12-30 04:21:04 Aitkin, Minnesota, US
2754605 2754605 2022-12-29 US Minnesota Anoka 27003 116729 861 0   45.27476015 -93.24604565 2022-12-30 04:21:04 Anoka, Minnesota, US
2754606 2754606 2022-12-29 US Minnesota Becker 27005 10292 99 0   46.93479392 -95.67158144 2022-12-30 04:21:04 Becker, Minnesota, US
2754607 2754607 2022-12-29 US Minnesota Beltrami 27007 13983 136 0   47.97373527 -94.93732139 2022-12-30 04:21:04 Beltrami, Minnesota, US
2754608 2754608 2022-12-29 US Minnesota Benton 27009 16655 196 0   45.69804958 -93.99514135 2022-12-30 04:21:04 Benton, Minnesota, US
2754609 2754609 2022-12-29 US Minnesota Big Stone 27011 1720 11 0   45.42712824 -96.41403739 2022-12-30 04:21:04 Big Stone, Minnesota, US
2754610 2754610 2022-12-29 US Minnesota Blue Earth 27013 20871 118 0   44.03554215 -94.06699781 2022-12-30 04:21:04 Blue Earth, Minnesota, US
2754611 2754611 2022-12-29 US Minnesota Brown 27015 7824 89 0   44.24205652 -94.72562874 2022-12-30 04:21:04 Brown, Minnesota, US
2754612 2754612 2022-12-29 US Minnesota Carlton 27017 11194 117 0   46.59180601 -92.67601019 2022-12-30 04:21:04 Carlton, Minnesota, US
2754613 2754613 2022-12-29 US Minnesota Carver 27019 31518 134 0   44.82017001 -93.8009918 2022-12-30 04:21:04 Carver, Minnesota, US
2754614 2754614 2022-12-29 US Minnesota Cass 27021 8409 92 0   46.95043611 -94.32603968 2022-12-30 04:21:04 Cass, Minnesota, US
2754615 2754615 2022-12-29 US Minnesota Chippewa 27023 3714 53 0   45.02343421 -95.56403693 2022-12-30 04:21:04 Chippewa, Minnesota, US
2754616 2754616 2022-12-29 US Minnesota Chisago 27025 16982 131 0   45.5021011 -92.90861945 2022-12-30 04:21:04 Chisago, Minnesota, US
2754617 2754617 2022-12-29 US Minnesota Clay 27027 23147 135 0   46.89289518 -96.48761922 2022-12-30 04:21:04 Clay, Minnesota, US
2754618 2754618 2022-12-29 US Minnesota Clearwater 27029 2443 32 0   47.57992111 -95.37790562 2022-12-30 04:21:04 Clearwater, Minnesota, US
2754619 2754619 2022-12-29 US Minnesota Cook 27031 807 5 0   47.90504893 -90.52629546 2022-12-30 04:21:04 Cook, Minnesota, US
2754620 2754620 2022-12-29 US Minnesota Cottonwood 27033 3705 42 0   44.00715262 -95.18138802 2022-12-30 04:21:04 Cottonwood, Minnesota, US
2754621 2754621 2022-12-29 US Minnesota Crow Wing 27035 18925 185 0   46.48096553 -94.06755609 2022-12-30 04:21:04 Crow Wing, Minnesota, US
2754622 2754622 2022-12-29 US Minnesota Dakota 27037 133892 875 0   44.67172617 -93.06299363 2022-12-30 04:21:04 Dakota, Minnesota, US
2754623 2754623 2022-12-29 US Minnesota Dodge 27039 6607 24 0   44.02238415 -92.86244324 2022-12-30 04:21:04 Dodge, Minnesota, US
2754624 2754624 2022-12-29 US Minnesota Douglas 27041 12983 132 0   45.93348491 -95.45335469 2022-12-30 04:21:04 Douglas, Minnesota, US
2754625 2754625 2022-12-29 US Minnesota Faribault 27043 4398 59 0   43.67381499 -93.94787458 2022-12-30 04:21:04 Faribault, Minnesota, US
2754626 2754626 2022-12-29 US Minnesota Fillmore 27045 5751 31 0   43.67394126 -92.08980382 2022-12-30 04:21:04 Fillmore, Minnesota, US
2754627 2754627 2022-12-29 US Minnesota Freeborn 27047 10387 89 0   43.67385583 -93.34884422 2022-12-30 04:21:04 Freeborn, Minnesota, US
2754628 2754628 2022-12-29 US Minnesota Goodhue 27049 15377 153 0   44.40849741 -92.7234195 2022-12-30 04:21:04 Goodhue, Minnesota, US
2754629 2754629 2022-12-29 US Minnesota Grant 27051 1778 15 0   45.93424769 -96.01139609 2022-12-30 04:21:04 Grant, Minnesota, US
2754630 2754630 2022-12-29 US Minnesota Hennepin 27053 376381 2848 0   45.00761521 -93.47694895 2022-12-30 04:21:04 Hennepin, Minnesota, US
2754631 2754631 2022-12-29 US Minnesota Houston 27055 5341 25 0   43.67129565 -91.49143057 2022-12-30 04:21:04 Houston, Minnesota, US
2754632 2754632 2022-12-29 US Minnesota Hubbard 27057 5953 68 0   47.10778564 -94.91693868 2022-12-30 04:21:04 Hubbard, Minnesota, US
2754633 2754633 2022-12-29 US Minnesota Isanti 27059 11516 127 0   45.56181234 -93.29487636 2022-12-30 04:21:04 Isanti, Minnesota, US
2754634 2754634 2022-12-29 US Minnesota Itasca 27061 13255 169 0   47.51009045 -93.63092229 2022-12-30 04:21:04 Itasca, Minnesota, US
2754635 2754635 2022-12-29 US Minnesota Jackson 27063 2600 20 0   43.67423373 -95.15398258 2022-12-30 04:21:04 Jackson, Minnesota, US
2754636 2754636 2022-12-29 US Minnesota Kanabec 27065 4218 60 0   45.9459309 -93.29275192 2022-12-30 04:21:04 Kanabec, Minnesota, US
2754637 2754637 2022-12-29 US Minnesota Kandiyohi 27067 15406 147 0   45.1526059 -95.00586446 2022-12-30 04:21:04 Kandiyohi, Minnesota, US
2754638 2754638 2022-12-29 US Minnesota Kittson 27069 1213 30 0   48.77754106 -96.78317184 2022-12-30 04:21:04 Kittson, Minnesota, US
2754639 2754639 2022-12-29 US Minnesota Koochiching 27071 3587 42 0   48.24539665 -93.78352843 2022-12-30 04:21:04 Koochiching, Minnesota, US
2754640 2754640 2022-12-29 US Minnesota Lac qui Parle 27073 2132 30 0   44.9973857 -96.17488219 2022-12-30 04:21:04 Lac qui Parle, Minnesota, US
2754641 2754641 2022-12-29 US Minnesota Lake 27075 2596 33 0   47.64270764 -91.44557998 2022-12-30 04:21:04 Lake, Minnesota, US
2754642 2754642 2022-12-29 US Minnesota Lake of the Woods 27077 906 6 0   48.77217001 -94.90274472 2022-12-30 04:21:04 Lake of the Woods, Minnesota, US
2754643 2754643 2022-12-29 US Minnesota Le Sueur 27079 7386 54 0   44.37136597 -93.72844721 2022-12-30 04:21:04 Le Sueur, Minnesota, US
2754644 2754644 2022-12-29 US Minnesota Lincoln 27081 1476 7 0   44.41311883 -96.26688165 2022-12-30 04:21:04 Lincoln, Minnesota, US
2754645 2754645 2022-12-29 US Minnesota Lyon 27083 8058 80 0   44.41327865 -95.83806103 2022-12-30 04:21:04 Lyon, Minnesota, US
2754646 2754646 2022-12-29 US Minnesota Mahnomen 27087 2109 18 0   47.32557075 -95.80921485 2022-12-30 04:21:04 Mahnomen, Minnesota, US
2754647 2754647 2022-12-29 US Minnesota Marshall 27089 2464 24 0   48.35825983 -96.37017407 2022-12-30 04:21:04 Marshall, Minnesota, US
2754648 2754648 2022-12-29 US Minnesota Martin 27091 6540 73 0   43.67429718 -94.55099908 2022-12-30 04:21:04 Martin, Minnesota, US
2754649 2754649 2022-12-29 US Minnesota McLeod 27085 12741 120 0   44.82367677 -94.27287017 2022-12-30 04:21:04 McLeod, Minnesota, US
2754650 2754650 2022-12-29 US Minnesota Meeker 27093 7009 82 0   45.12328869 -94.52839455 2022-12-30 04:21:04 Meeker, Minnesota, US
2754651 2754651 2022-12-29 US Minnesota Mille Lacs 27095 8238 126 0   45.93705297 -93.63236823 2022-12-30 04:21:04 Mille Lacs, Minnesota, US
2754652 2754652 2022-12-29 US Minnesota Morrison 27097 10905 118 0   46.01265363 -94.27341528 2022-12-30 04:21:04 Morrison, Minnesota, US
2754653 2754653 2022-12-29 US Minnesota Mower 27099 13620 81 0   43.67142874 -92.75234549 2022-12-30 04:21:04 Mower, Minnesota, US
2754654 2754654 2022-12-29 US Minnesota Murray 27101 2317 22 0   44.02216709 -95.76328482 2022-12-30 04:21:04 Murray, Minnesota, US
2754655 2754655 2022-12-29 US Minnesota Nicollet 27103 9665 73 0   44.35291112 -94.24710352 2022-12-30 04:21:04 Nicollet, Minnesota, US
2754656 2754656 2022-12-29 US Minnesota Nobles 27105 7809 65 0   43.67434621 -95.75329576 2022-12-30 04:21:04 Nobles, Minnesota, US
2754657 2754657 2022-12-29 US Minnesota Norman 27107 1761 16 0   47.32628443 -96.45620947 2022-12-30 04:21:04 Norman, Minnesota, US
2754658 2754658 2022-12-29 US Minnesota Olmsted 27109 51943 216 0   44.00374114 -92.40209944 2022-12-30 04:21:04 Olmsted, Minnesota, US
2754659 2754659 2022-12-29 US Minnesota Otter Tail 27111 15884 182 0   46.40846929 -95.70835255 2022-12-30 04:21:04 Otter Tail, Minnesota, US
2754660 2754660 2022-12-29 US Minnesota Pennington 27113 4234 43 0   48.06642577 -96.0370814 2022-12-30 04:21:04 Pennington, Minnesota, US
2754661 2754661 2022-12-29 US Minnesota Pine 27115 8368 75 0   46.12105238 -92.74070188 2022-12-30 04:21:04 Pine, Minnesota, US
2754662 2754662 2022-12-29 US Minnesota Pipestone 27117 2315 34 0   44.02301619 -96.25841142 2022-12-30 04:21:04 Pipestone, Minnesota, US
2754663 2754663 2022-12-29 US Minnesota Polk 27119 10422 127 0   47.77372465 -96.40134647 2022-12-30 04:21:04 Polk, Minnesota, US
2754664 2754664 2022-12-29 US Minnesota Pope 27121 3808 22 0   45.58606667 -95.44451209 2022-12-30 04:21:04 Pope, Minnesota, US
2754665 2754665 2022-12-29 US Minnesota Ramsey 27123 155217 1482 0   45.01625271 -93.09872295 2022-12-30 04:21:04 Ramsey, Minnesota, US
2754666 2754666 2022-12-29 US Minnesota Red Lake 27125 1049 14 0   47.87197525 -96.09561104 2022-12-30 04:21:04 Red Lake, Minnesota, US
2754667 2754667 2022-12-29 US Minnesota Redwood 27127 4616 55 0   44.40555844 -95.25207021 2022-12-30 04:21:04 Redwood, Minnesota, US
2754668 2754668 2022-12-29 US Minnesota Renville 27129 4406 59 0   44.72836381 -94.94553734 2022-12-30 04:21:04 Renville, Minnesota, US
2754669 2754669 2022-12-29 US Minnesota Rice 27131 20418 203 0   44.3543376 -93.29658715 2022-12-30 04:21:04 Rice, Minnesota, US
2754670 2754670 2022-12-29 US Minnesota Rock 27133 2733 35 0   43.67482683 -96.25296832 2022-12-30 04:21:04 Rock, Minnesota, US
2754671 2754671 2022-12-29 US Minnesota Roseau 27135 4973 47 0   48.77501878 -95.81079919 2022-12-30 04:21:04 Roseau, Minnesota, US
2754672 2754672 2022-12-29 US Minnesota Scott 27139 47085 287 0   44.6490231 -93.53340251 2022-12-30 04:21:04 Scott, Minnesota, US
2754673 2754673 2022-12-29 US Minnesota Sherburne 27141 31405 193 0   45.44447208 -93.77617511 2022-12-30 04:21:04 Sherburne, Minnesota, US
2754674 2754674 2022-12-29 US Minnesota Sibley 27143 4183 29 0   44.5796592 -94.23164924 2022-12-30 04:21:04 Sibley, Minnesota, US
2754675 2754675 2022-12-29 US Minnesota St. Louis 27137 59154 600 0   47.6048407 -92.46879855 2022-12-30 04:21:04 St. Louis, Minnesota, US
2754676 2754676 2022-12-29 US Minnesota Stearns 27145 60151 410 0   45.55192576 -94.61078221 2022-12-30 04:21:04 Stearns, Minnesota, US
2754677 2754677 2022-12-29 US Minnesota Steele 27147 11837 74 0   44.02240351 -93.22627088 2022-12-30 04:21:04 Steele, Minnesota, US
2754678 2754678 2022-12-29 US Minnesota Stevens 27149 3236 16 0   45.58613007 -96.00163705 2022-12-30 04:21:04 Stevens, Minnesota, US
2754679 2754679 2022-12-29 US Minnesota Swift 27151 2658 34 0   45.2829032 -95.68264092 2022-12-30 04:21:04 Swift, Minnesota, US
2754680 2754680 2022-12-29 US Minnesota Todd 27153 8269 72 0   46.06996226 -94.89785296 2022-12-30 04:21:04 Todd, Minnesota, US
2754681 2754681 2022-12-29 US Minnesota Traverse 27155 993 11 0   45.77298854 -96.47062949 2022-12-30 04:21:04 Traverse, Minnesota, US
2754682 2754682 2022-12-29 US Minnesota Unassigned 90027 1971 387 0   48.77754106 0.0 2022-12-30 04:21:04 Unassigned, Minnesota, US
2754683 2754683 2022-12-29 US Minnesota Wabasha 27157 6550 19 0   44.28424356 -92.23121312 2022-12-30 04:21:04 Wabasha, Minnesota, US
2754684 2754684 2022-12-29 US Minnesota Wadena 27159 5089 65 0   46.58589171 -94.96968506 2022-12-30 04:21:04 Wadena, Minnesota, US
2754685 2754685 2022-12-29 US Minnesota Waseca 27161 6239 43 0   44.02211116 -93.58720034 2022-12-30 04:21:04 Waseca, Minnesota, US
2754686 2754686 2022-12-29 US Minnesota Washington 27163 80897 551 0   45.03864533 -92.88429635 2022-12-30 04:21:04 Washington, Minnesota, US
2754687 2754687 2022-12-29 US Minnesota Watonwan 27165 3365 26 0   43.97823903 -94.61413846 2022-12-30 04:21:04 Watonwan, Minnesota, US
2754688 2754688 2022-12-29 US Minnesota Wilkin 27167 1898 24 0   46.35721532 -96.4684375 2022-12-30 04:21:04 Wilkin, Minnesota, US
2754689 2754689 2022-12-29 US Minnesota Winona 27169 15543 80 0   43.98772283 -91.78081305 2022-12-30 04:21:04 Winona, Minnesota, US
2754690 2754690 2022-12-29 US Minnesota Wright 27171 42030 331 0   45.17297924 -93.96234781 2022-12-30 04:21:04 Wright, Minnesota, US
2754691 2754691 2022-12-29 US Minnesota Yellow Medicine 27173 3038 31 0   44.71710183 -95.86842453 2022-12-30 04:21:04 Yellow Medicine, Minnesota, US
1075610 1075610 2022-12-28 US Minnesota Aitkin 27001 3612 65 0   46.60962049 -93.4116826 2022-12-29 04:21:01 Aitkin, Minnesota, US
1075611 1075611 2022-12-28 US Minnesota Anoka 27003 116345 857 0   45.27476015 -93.24604565 2022-12-29 04:21:01 Anoka, Minnesota, US
1075612 1075612 2022-12-28 US Minnesota Becker 27005 10270 99 0   46.93479392 -95.67158144 2022-12-29 04:21:01 Becker, Minnesota, US
1075613 1075613 2022-12-28 US Minnesota Beltrami 27007 13913 136 0   47.97373527 -94.93732139 2022-12-29 04:21:01 Beltrami, Minnesota, US
1075614 1075614 2022-12-28 US Minnesota Benton 27009 16596 196 0   45.69804958 -93.99514135 2022-12-29 04:21:01 Benton, Minnesota, US
1075615 1075615 2022-12-28 US Minnesota Big Stone 27011 1717 11 0   45.42712824 -96.41403739 2022-12-29 04:21:01 Big Stone, Minnesota, US
1075616 1075616 2022-12-28 US Minnesota Blue Earth 27013 20817 117 0   44.03554215 -94.06699781 2022-12-29 04:21:01 Blue Earth, Minnesota, US
1075617 1075617 2022-12-28 US Minnesota Brown 27015 7807 89 0   44.24205652 -94.72562874 2022-12-29 04:21:01 Brown, Minnesota, US
1075618 1075618 2022-12-28 US Minnesota Carlton 27017 11143 116 0   46.59180601 -92.67601019 2022-12-29 04:21:01 Carlton, Minnesota, US
1075619 1075619 2022-12-28 US Minnesota Carver 27019 31346 132 0   44.82017001 -93.8009918 2022-12-29 04:21:01 Carver, Minnesota, US
1075620 1075620 2022-12-28 US Minnesota Cass 27021 8363 92 0   46.95043611 -94.32603968 2022-12-29 04:21:01 Cass, Minnesota, US
1075621 1075621 2022-12-28 US Minnesota Chippewa 27023 3673 53 0   45.02343421 -95.56403693 2022-12-29 04:21:01 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] 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]);