daily_reports (view)
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 active descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▲ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-10-28 | US | Minnesota | Dakota | 27037 | 10132 | 138 | 0 | 9994 | 44.67172617 | -93.06299363 | 2020-10-29 04:24:49 | Dakota, Minnesota, US |
2021-01-11 | US | Minnesota | Faribault | 27043 | 1013 | 14 | 0 | 999 | 43.67381499 | -93.94787458 | 2021-01-12 05:22:15 | Faribault, Minnesota, US |
2020-11-26 | US | Minnesota | Martin | 27091 | 1019 | 20 | 0 | 999 | 43.67429718 | -94.55099908 | 2020-11-27 05:26:53 | Martin, Minnesota, US |
2021-01-29 | US | Minnesota | Pennington | 27113 | 1015 | 16 | 0 | 999 | 48.06642577 | -96.0370814 | 2021-01-30 05:22:49 | Pennington, Minnesota, US |
2020-11-25 | US | Minnesota | Martin | 27091 | 1019 | 20 | 0 | 999 | 43.67429718 | -94.55099908 | 2020-11-26 05:27:44 | Martin, Minnesota, US |
2020-12-17 | US | Minnesota | Watonwan | 27165 | 1004 | 5 | 0 | 999 | 43.97823903 | -94.61413846 | 2020-12-18 05:28:18 | Watonwan, Minnesota, US |
2020-12-26 | US | Minnesota | Rock | 27133 | 1009 | 10 | 0 | 999 | 43.67482683 | -96.25296832 | 2020-12-27 05:22:55 | Rock, Minnesota, US |
2021-01-28 | US | Minnesota | Pennington | 27113 | 1015 | 16 | 0 | 999 | 48.06642577 | -96.0370814 | 2021-01-29 05:22:23 | Pennington, Minnesota, US |
2021-03-06 | US | Minnesota | Hennepin | 27053 | 101490 | 1592 | 0 | 99898 | 45.00761521 | -93.47694895 | 2021-03-07 05:21:54 | Hennepin, Minnesota, US |
2020-12-16 | US | Minnesota | Wright | 27171 | 10057 | 69 | 0 | 9988 | 45.17297924 | -93.96234781 | 2020-12-17 05:28:12 | Wright, Minnesota, US |
2020-12-25 | US | Minnesota | Rock | 27133 | 1008 | 10 | 0 | 998 | 43.67482683 | -96.25296832 | 2020-12-26 05:22:28 | Rock, Minnesota, US |
2020-12-15 | US | Minnesota | Houston | 27055 | 1004 | 6 | 0 | 998 | 43.67129565 | -91.49143057 | 2020-12-16 05:28:04 | Houston, Minnesota, US |
2020-12-24 | US | Minnesota | Rock | 27133 | 1008 | 10 | 0 | 998 | 43.67482683 | -96.25296832 | 2020-12-25 05:22:48 | Rock, Minnesota, US |
2020-08-05 | US | Minnesota | Rice | 27131 | 1006 | 8 | 0 | 998 | 44.3543376 | -93.29658715 | 2020-08-06 04:35:02 | Rice, Minnesota, US |
2021-01-26 | US | Minnesota | Pennington | 27113 | 1013 | 16 | 0 | 997 | 48.06642577 | -96.0370814 | 2021-01-27 05:23:41 | Pennington, Minnesota, US |
2020-12-02 | US | Minnesota | Redwood | 27127 | 1017 | 20 | 0 | 997 | 44.40555844 | -95.25207021 | 2020-12-03 05:28:22 | Redwood, Minnesota, US |
2021-01-02 | US | Minnesota | Aitkin | 27001 | 1029 | 32 | 0 | 997 | 46.60962049 | -93.4116826 | 2021-01-03 05:22:52 | Aitkin, Minnesota, US |
2021-01-10 | US | Minnesota | Faribault | 27043 | 1011 | 14 | 0 | 997 | 43.67381499 | -93.94787458 | 2021-01-11 05:21:50 | Faribault, Minnesota, US |
2020-07-17 | US | Minnesota | Mower | 27099 | 999 | 2 | 0 | 997 | 43.67142874 | -92.75234549 | 2020-07-18 04:34:45 | Mower, Minnesota, US |
2020-10-06 | US | Minnesota | Winona | 27169 | 1015 | 18 | 0 | 997 | 43.98772283 | -91.78081305 | 2020-10-07 04:23:40 | Winona, Minnesota, US |
2020-11-02 | US | Minnesota | Todd | 27153 | 1004 | 7 | 0 | 997 | 46.06996226 | -94.89785296 | 2020-11-03 06:00:16 | Todd, Minnesota, US |
2021-03-05 | US | Minnesota | Hennepin | 27053 | 101285 | 1589 | 0 | 99696 | 45.00761521 | -93.47694895 | 2021-03-06 04:23:41 | Hennepin, Minnesota, US |
2020-06-20 | US | Minnesota | Hennepin | 27053 | 10705 | 744 | 0 | 9961 | 45.00761521 | -93.47694895 | 2020-06-21 04:33:19 | Hennepin, Minnesota, US |
2020-12-12 | US | Minnesota | Wadena | 27159 | 1005 | 9 | 0 | 996 | 46.58589171 | -94.96968506 | 2020-12-13 05:27:20 | Wadena, Minnesota, US |
2021-01-27 | US | Minnesota | Pennington | 27113 | 1012 | 16 | 0 | 996 | 48.06642577 | -96.0370814 | 2021-01-28 05:22:24 | Pennington, Minnesota, US |
2020-09-17 | US | Minnesota | Ramsey | 27123 | 10267 | 314 | 0 | 9953 | 45.01625271 | -93.09872295 | 2020-09-18 05:05:00 | Ramsey, Minnesota, US |
2021-03-04 | US | Minnesota | Hennepin | 27053 | 101110 | 1588 | 0 | 99522 | 45.00761521 | -93.47694895 | 2021-03-05 05:26:29 | Hennepin, Minnesota, US |
2020-08-21 | US | Minnesota | Carver | 27019 | 999 | 4 | 0 | 995 | 44.82017001 | -93.8009918 | 2020-08-22 04:27:49 | Carver, Minnesota, US |
2020-12-23 | US | Minnesota | Rock | 27133 | 1005 | 10 | 0 | 995 | 43.67482683 | -96.25296832 | 2020-12-24 05:23:04 | Rock, Minnesota, US |
2021-01-11 | US | Minnesota | Olmsted | 27109 | 10015 | 68 | 0 | 9947 | 44.00374114 | -92.40209944 | 2021-01-12 05:22:15 | Olmsted, Minnesota, US |
2020-12-12 | US | Minnesota | Scott | 27139 | 10013 | 69 | 0 | 9944 | 44.6490231 | -93.53340251 | 2020-12-13 05:27:20 | Scott, Minnesota, US |
2020-08-04 | US | Minnesota | Rice | 27131 | 1002 | 8 | 0 | 994 | 44.3543376 | -93.29658715 | 2020-08-05 04:34:43 | Rice, Minnesota, US |
2020-07-16 | US | Minnesota | Mower | 27099 | 996 | 2 | 0 | 994 | 43.67142874 | -92.75234549 | 2020-07-17 04:34:50 | Mower, Minnesota, US |
2020-09-12 | US | Minnesota | Sherburne | 27141 | 1007 | 13 | 0 | 994 | 45.44447208 | -93.77617511 | 2020-09-13 04:30:52 | Sherburne, Minnesota, US |
2020-12-29 | US | Minnesota | Sibley | 27143 | 999 | 5 | 0 | 994 | 44.5796592 | -94.23164924 | 2020-12-30 05:22:34 | Sibley, Minnesota, US |
2020-11-07 | US | Minnesota | Waseca | 27161 | 1004 | 10 | 0 | 994 | 44.02211116 | -93.58720034 | 2020-11-08 05:24:56 | Waseca, Minnesota, US |
2021-03-05 | US | Minnesota | Pipestone | 27117 | 1018 | 24 | 0 | 994 | 44.02301619 | -96.25841142 | 2021-03-06 04:23:41 | Pipestone, Minnesota, US |
2021-01-24 | US | Minnesota | Pennington | 27113 | 1010 | 16 | 0 | 994 | 48.06642577 | -96.0370814 | 2021-01-25 05:22:16 | Pennington, Minnesota, US |
2021-01-23 | US | Minnesota | Pennington | 27113 | 1010 | 16 | 0 | 994 | 48.06642577 | -96.0370814 | 2021-01-24 05:22:35 | Pennington, Minnesota, US |
2021-01-25 | US | Minnesota | Pennington | 27113 | 1010 | 16 | 0 | 994 | 48.06642577 | -96.0370814 | 2021-01-26 05:22:02 | Pennington, Minnesota, US |
2021-03-06 | US | Minnesota | Pipestone | 27117 | 1018 | 24 | 0 | 994 | 44.02301619 | -96.25841142 | 2021-03-07 05:21:54 | Pipestone, Minnesota, US |
2020-12-22 | US | Minnesota | Rock | 27133 | 1004 | 10 | 0 | 994 | 43.67482683 | -96.25296832 | 2020-12-23 05:22:03 | Rock, Minnesota, US |
2021-01-10 | US | Minnesota | Olmsted | 27109 | 10004 | 68 | 0 | 9936 | 44.00374114 | -92.40209944 | 2021-01-11 05:21:50 | Olmsted, Minnesota, US |
2021-03-03 | US | Minnesota | Hennepin | 27053 | 100913 | 1586 | 0 | 99327 | 45.00761521 | -93.47694895 | 2021-03-04 05:24:24 | Hennepin, Minnesota, US |
2020-11-10 | US | Minnesota | Becker | 27005 | 997 | 4 | 0 | 993 | 46.93479392 | -95.67158144 | 2020-11-11 05:25:30 | Becker, Minnesota, US |
2020-11-27 | US | Minnesota | Wabasha | 27157 | 994 | 1 | 0 | 993 | 44.28424356 | -92.23121312 | 2020-11-28 05:25:50 | Wabasha, Minnesota, US |
2021-01-29 | US | Minnesota | Kanabec | 27065 | 1011 | 18 | 0 | 993 | 45.9459309 | -93.29275192 | 2021-01-30 05:22:49 | Kanabec, Minnesota, US |
2021-03-04 | US | Minnesota | Pipestone | 27117 | 1017 | 24 | 0 | 993 | 44.02301619 | -96.25841142 | 2021-03-05 05:26:29 | Pipestone, Minnesota, US |
2020-12-16 | US | Minnesota | Watonwan | 27165 | 998 | 5 | 0 | 993 | 43.97823903 | -94.61413846 | 2020-12-17 05:28:12 | Watonwan, Minnesota, US |
2020-08-18 | US | Minnesota | Blue Earth | 27013 | 998 | 5 | 0 | 993 | 44.03554215 | -94.06699781 | 2020-08-19 04:27:00 | Blue Earth, Minnesota, US |
2020-12-28 | US | Minnesota | Sibley | 27143 | 998 | 5 | 0 | 993 | 44.5796592 | -94.23164924 | 2020-12-29 05:22:37 | Sibley, Minnesota, US |
2021-01-09 | US | Minnesota | Faribault | 27043 | 1006 | 13 | 0 | 993 | 43.67381499 | -93.94787458 | 2021-01-10 05:22:12 | Faribault, Minnesota, US |
2020-12-15 | US | Minnesota | Wright | 27171 | 9997 | 68 | 0 | 9929 | 45.17297924 | -93.96234781 | 2020-12-16 05:28:04 | Wright, Minnesota, US |
2020-12-21 | US | Minnesota | Rock | 27133 | 1002 | 10 | 0 | 992 | 43.67482683 | -96.25296832 | 2020-12-22 05:22:33 | Rock, Minnesota, US |
2021-03-03 | US | Minnesota | Pipestone | 27117 | 1016 | 24 | 0 | 992 | 44.02301619 | -96.25841142 | 2021-03-04 05:24:24 | Pipestone, Minnesota, US |
2020-12-08 | US | Minnesota | Dodge | 27039 | 993 | 1 | 0 | 992 | 44.02238415 | -92.86244324 | 2020-12-09 05:28:01 | Dodge, Minnesota, US |
2020-10-31 | US | Minnesota | Beltrami | 27007 | 1002 | 10 | 0 | 992 | 47.97373527 | -94.93732139 | 2020-11-01 04:36:19 | Beltrami, Minnesota, US |
2020-07-15 | US | Minnesota | Mower | 27099 | 994 | 2 | 0 | 992 | 43.67142874 | -92.75234549 | 2020-07-16 04:44:59 | Mower, Minnesota, US |
2020-11-14 | US | Minnesota | Mille Lacs | 27095 | 1018 | 26 | 0 | 992 | 45.93705297 | -93.63236823 | 2020-11-15 05:26:53 | Mille Lacs, Minnesota, US |
2020-12-27 | US | Minnesota | Sibley | 27143 | 997 | 5 | 0 | 992 | 44.5796592 | -94.23164924 | 2020-12-28 05:22:06 | Sibley, Minnesota, US |
2021-03-02 | US | Minnesota | Hennepin | 27053 | 100764 | 1586 | 0 | 99178 | 45.00761521 | -93.47694895 | 2021-03-03 05:23:28 | Hennepin, Minnesota, US |
2021-01-09 | US | Minnesota | Olmsted | 27109 | 9978 | 66 | 0 | 9912 | 44.00374114 | -92.40209944 | 2021-01-10 05:22:12 | Olmsted, Minnesota, US |
2020-11-18 | US | Minnesota | Pine | 27115 | 996 | 5 | 0 | 991 | 46.12105238 | -92.74070188 | 2020-11-19 05:25:23 | Pine, Minnesota, US |
2020-12-15 | US | Minnesota | Watonwan | 27165 | 996 | 5 | 0 | 991 | 43.97823903 | -94.61413846 | 2020-12-16 05:28:04 | Watonwan, Minnesota, US |
2021-01-01 | US | Minnesota | Aitkin | 27001 | 1023 | 32 | 0 | 991 | 46.60962049 | -93.4116826 | 2021-01-02 05:22:33 | Aitkin, Minnesota, US |
2020-12-14 | US | Minnesota | Houston | 27055 | 996 | 5 | 0 | 991 | 43.67129565 | -91.49143057 | 2020-12-15 05:26:38 | Houston, Minnesota, US |
2020-05-22 | US | Minnesota | Anoka | 27003 | 1044 | 53 | 0 | 991 | 45.27476015 | -93.24604565 | 2020-05-23 02:32:42 | Anoka, Minnesota, US |
2021-01-22 | US | Minnesota | Pennington | 27113 | 1007 | 16 | 0 | 991 | 48.06642577 | -96.0370814 | 2021-01-23 05:22:03 | Pennington, Minnesota, US |
2020-08-03 | US | Minnesota | Rice | 27131 | 999 | 8 | 0 | 991 | 44.3543376 | -93.29658715 | 2020-08-04 04:41:59 | Rice, Minnesota, US |
2020-11-11 | US | Minnesota | Nicollet | 27103 | 1011 | 20 | 0 | 991 | 44.35291112 | -94.24710352 | 2020-11-12 05:25:55 | Nicollet, Minnesota, US |
2020-12-31 | US | Minnesota | Aitkin | 27001 | 1023 | 32 | 0 | 991 | 46.60962049 | -93.4116826 | 2021-01-01 05:23:07 | Aitkin, Minnesota, US |
2021-03-01 | US | Minnesota | Hennepin | 27053 | 100680 | 1585 | 0 | 99095 | 45.00761521 | -93.47694895 | 2021-03-02 05:23:30 | Hennepin, Minnesota, US |
2021-03-01 | US | Minnesota | Pipestone | 27117 | 1014 | 24 | 0 | 990 | 44.02301619 | -96.25841142 | 2021-03-02 05:23:30 | Pipestone, Minnesota, US |
2020-10-27 | US | Minnesota | Lyon | 27083 | 996 | 6 | 0 | 990 | 44.41327865 | -95.83806103 | 2020-10-28 04:24:39 | Lyon, Minnesota, US |
2020-12-14 | US | Minnesota | Watonwan | 27165 | 995 | 5 | 0 | 990 | 43.97823903 | -94.61413846 | 2020-12-15 05:26:38 | Watonwan, Minnesota, US |
2020-12-26 | US | Minnesota | Sibley | 27143 | 994 | 4 | 0 | 990 | 44.5796592 | -94.23164924 | 2020-12-27 05:22:55 | Sibley, Minnesota, US |
2021-02-28 | US | Minnesota | Pipestone | 27117 | 1014 | 24 | 0 | 990 | 44.02301619 | -96.25841142 | 2021-03-01 05:23:01 | Pipestone, Minnesota, US |
2020-11-14 | US | Minnesota | Freeborn | 27047 | 995 | 5 | 0 | 990 | 43.67385583 | -93.34884422 | 2020-11-15 05:26:53 | Freeborn, Minnesota, US |
2021-02-27 | US | Minnesota | Pipestone | 27117 | 1014 | 24 | 0 | 990 | 44.02301619 | -96.25841142 | 2021-02-28 05:22:20 | Pipestone, Minnesota, US |
2021-03-02 | US | Minnesota | Pipestone | 27117 | 1014 | 24 | 0 | 990 | 44.02301619 | -96.25841142 | 2021-03-03 05:23:28 | Pipestone, Minnesota, US |
2020-11-11 | US | Minnesota | McLeod | 27085 | 995 | 5 | 0 | 990 | 44.82367677 | -94.27287017 | 2020-11-12 05:25:55 | McLeod, Minnesota, US |
2020-12-04 | US | Minnesota | Chippewa | 27023 | 999 | 9 | 0 | 990 | 45.02343421 | -95.56403693 | 2020-12-05 05:27:36 | Chippewa, Minnesota, US |
2020-07-23 | US | Minnesota | Waseca | 27161 | 99 | 0 | 0 | 99 | 44.02211116 | -93.58720034 | 2020-07-24 05:30:40 | Waseca, Minnesota, US |
2020-08-15 | US | Minnesota | Wabasha | 27157 | 99 | 0 | 0 | 99 | 44.28424356 | -92.23121312 | 2020-08-16 04:27:42 | Wabasha, Minnesota, US |
2020-08-31 | US | Minnesota | Mille Lacs | 27095 | 102 | 3 | 0 | 99 | 45.93705297 | -93.63236823 | 2020-09-01 04:28:31 | Mille Lacs, Minnesota, US |
2020-08-19 | US | Minnesota | Brown | 27015 | 101 | 2 | 0 | 99 | 44.24205652 | -94.72562874 | 2020-08-20 04:27:43 | Brown, Minnesota, US |
2020-07-05 | US | Minnesota | Le Sueur | 27079 | 100 | 1 | 0 | 99 | 44.37136597 | -93.72844721 | 2020-07-06 04:33:57 | Le Sueur, Minnesota, US |
2020-09-05 | US | Minnesota | Pennington | 27113 | 100 | 1 | 0 | 99 | 48.06642577 | -96.0370814 | 2020-09-06 04:28:33 | Pennington, Minnesota, US |
2020-07-07 | US | Minnesota | Otter Tail | 27111 | 100 | 1 | 0 | 99 | 46.40846929 | -95.70835255 | 2020-07-08 05:33:48 | Otter Tail, Minnesota, US |
2020-09-10 | US | Minnesota | Jackson | 27063 | 100 | 1 | 0 | 99 | 43.67423373 | -95.15398258 | 2020-09-11 04:46:23 | Jackson, Minnesota, US |
2020-06-05 | US | Minnesota | Lyon | 27083 | 101 | 2 | 0 | 99 | 44.41327865 | -95.83806103 | 2020-06-06 02:33:00 | Lyon, Minnesota, US |
2020-09-11 | US | Minnesota | Jackson | 27063 | 100 | 1 | 0 | 99 | 43.67423373 | -95.15398258 | 2020-09-12 04:25:05 | Jackson, Minnesota, US |
2020-08-21 | US | Minnesota | Sibley | 27143 | 101 | 2 | 0 | 99 | 44.5796592 | -94.23164924 | 2020-08-22 04:27:49 | Sibley, Minnesota, US |
2020-07-25 | US | Minnesota | Isanti | 27059 | 99 | 0 | 0 | 99 | 45.56181234 | -93.29487636 | 2020-07-26 04:35:00 | Isanti, Minnesota, US |
2020-09-28 | US | Minnesota | Pope | 27121 | 99 | 0 | 0 | 99 | 45.58606667 | -95.44451209 | 2020-09-29 04:23:42 | Pope, Minnesota, US |
2020-11-07 | US | Minnesota | Kittson | 27069 | 100 | 1 | 0 | 99 | 48.77754106 | -96.78317184 | 2020-11-08 05:24:56 | Kittson, Minnesota, US |
2020-08-26 | US | Minnesota | Rock | 27133 | 99 | 0 | 0 | 99 | 43.67482683 | -96.25296832 | 2020-08-27 04:28:15 | Rock, Minnesota, US |
2020-12-17 | US | Minnesota | Cook | 27031 | 99 | 0 | 0 | 99 | 47.90504893 | -90.52629546 | 2020-12-18 05:28:18 | Cook, Minnesota, US |
2020-07-08 | US | Minnesota | Otter Tail | 27111 | 100 | 1 | 0 | 99 | 46.40846929 | -95.70835255 | 2020-07-09 04:34:23 | Otter Tail, Minnesota, US |
2020-10-12 | US | Minnesota | Wilkin | 27167 | 102 | 3 | 0 | 99 | 46.35721532 | -96.4684375 | 2020-10-13 04:24:02 | Wilkin, Minnesota, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;