ny_times_us_counties

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 license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

29,867 rows where state = "Minnesota" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips

county

state

  • Minnesota · 29,867 ✖
Link rowid date ▲ county state fips cases deaths
1097026 1097026 2021-03-07 Aitkin Minnesota 27001 1192 33
1097027 1097027 2021-03-07 Anoka Minnesota 27003 33545 392
1097028 1097028 2021-03-07 Becker Minnesota 27005 3151 43
1097029 1097029 2021-03-07 Beltrami Minnesota 27007 3391 51
1097030 1097030 2021-03-07 Benton Minnesota 27009 4518 90
1097031 1097031 2021-03-07 Big Stone Minnesota 27011 517 3
1097032 1097032 2021-03-07 Blue Earth Minnesota 27013 6044 35
1097033 1097033 2021-03-07 Brown Minnesota 27015 2491 37
1097034 1097034 2021-03-07 Carlton Minnesota 27017 3006 49
1097035 1097035 2021-03-07 Carver Minnesota 27019 7909 41
1097036 1097036 2021-03-07 Cass Minnesota 27021 2214 24
1097037 1097037 2021-03-07 Chippewa Minnesota 27023 1370 35
1097038 1097038 2021-03-07 Chisago Minnesota 27025 5029 45
1097039 1097039 2021-03-07 Clay Minnesota 27027 6962 88
1097040 1097040 2021-03-07 Clearwater Minnesota 27029 720 14
1097041 1097041 2021-03-07 Cook Minnesota 27031 119 0
1097042 1097042 2021-03-07 Cottonwood Minnesota 27033 1361 20
1097043 1097043 2021-03-07 Crow Wing Minnesota 27035 5236 82
1097044 1097044 2021-03-07 Dakota Minnesota 27037 36714 394
1097045 1097045 2021-03-07 Dodge Minnesota 27039 1546 4
1097046 1097046 2021-03-07 Douglas Minnesota 27041 3950 68
1097047 1097047 2021-03-07 Faribault Minnesota 27043 1250 17
1097048 1097048 2021-03-07 Fillmore Minnesota 27045 1402 9
1097049 1097049 2021-03-07 Freeborn Minnesota 27047 2871 24
1097050 1097050 2021-03-07 Goodhue Minnesota 27049 3901 69
1097051 1097051 2021-03-07 Grant Minnesota 27051 492 8
1097052 1097052 2021-03-07 Hennepin Minnesota 27053 101682 1593
1097053 1097053 2021-03-07 Houston Minnesota 27055 1582 14
1097054 1097054 2021-03-07 Hubbard Minnesota 27057 1610 41
1097055 1097055 2021-03-07 Isanti Minnesota 27059 3100 56
1097056 1097056 2021-03-07 Itasca Minnesota 27061 3153 46
1097057 1097057 2021-03-07 Jackson Minnesota 27063 947 10
1097058 1097058 2021-03-07 Kanabec Minnesota 27065 1091 20
1097059 1097059 2021-03-07 Kandiyohi Minnesota 27067 5822 74
1097060 1097060 2021-03-07 Kittson Minnesota 27069 411 21
1097061 1097061 2021-03-07 Koochiching Minnesota 27071 621 11
1097062 1097062 2021-03-07 Lac qui Parle Minnesota 27073 688 16
1097063 1097063 2021-03-07 Lake Minnesota 27075 743 18
1097064 1097064 2021-03-07 Lake of the Woods Minnesota 27077 223 1
1097065 1097065 2021-03-07 Le Sueur Minnesota 27079 2386 20
1097066 1097066 2021-03-07 Lincoln Minnesota 27081 512 2
1097067 1097067 2021-03-07 Lyon Minnesota 27083 3140 45
1097068 1097068 2021-03-07 Mahnomen Minnesota 27087 443 7
1097069 1097069 2021-03-07 Marshall Minnesota 27089 787 15
1097070 1097070 2021-03-07 Martin Minnesota 27091 1908 29
1097071 1097071 2021-03-07 McLeod Minnesota 27085 3419 50
1097072 1097072 2021-03-07 Meeker Minnesota 27093 2085 34
1097073 1097073 2021-03-07 Mille Lacs Minnesota 27095 2300 47
1097074 1097074 2021-03-07 Morrison Minnesota 27097 3281 47
1097075 1097075 2021-03-07 Mower Minnesota 27099 4119 31
1097076 1097076 2021-03-07 Murray Minnesota 27101 954 8
1097077 1097077 2021-03-07 Nicollet Minnesota 27103 2633 41
1097078 1097078 2021-03-07 Nobles Minnesota 27105 3873 47
1097079 1097079 2021-03-07 Norman Minnesota 27107 480 8
1097080 1097080 2021-03-07 Olmsted Minnesota 27109 11878 90
1097081 1097081 2021-03-07 Otter Tail Minnesota 27111 4871 71
1097082 1097082 2021-03-07 Pennington Minnesota 27113 1398 16
1097083 1097083 2021-03-07 Pine Minnesota 27115 2836 16
1097084 1097084 2021-03-07 Pipestone Minnesota 27117 1019 24
1097085 1097085 2021-03-07 Polk Minnesota 27119 3453 63
1097086 1097086 2021-03-07 Pope Minnesota 27121 818 5
1097087 1097087 2021-03-07 Ramsey Minnesota 27123 43388 811
1097088 1097088 2021-03-07 Red Lake Minnesota 27125 361 5
1097089 1097089 2021-03-07 Redwood Minnesota 27127 1471 27
1097090 1097090 2021-03-07 Renville Minnesota 27129 1529 40
1097091 1097091 2021-03-07 Rice Minnesota 27131 6786 91
1097092 1097092 2021-03-07 Rock Minnesota 27133 1163 14
1097093 1097093 2021-03-07 Roseau Minnesota 27135 1810 17
1097094 1097094 2021-03-07 Scott Minnesota 27139 13445 107
1097095 1097095 2021-03-07 Sherburne Minnesota 27141 8794 74
1097096 1097096 2021-03-07 Sibley Minnesota 27143 1183 10
1097097 1097097 2021-03-07 St. Louis Minnesota 27137 14915 265
1097098 1097098 2021-03-07 Stearns Minnesota 27145 18847 202
1097099 1097099 2021-03-07 Steele Minnesota 27147 3043 11
1097100 1097100 2021-03-07 Stevens Minnesota 27149 747 8
1097101 1097101 2021-03-07 Swift Minnesota 27151 878 18
1097102 1097102 2021-03-07 Todd Minnesota 27153 2503 30
1097103 1097103 2021-03-07 Traverse Minnesota 27155 311 5
1097104 1097104 2021-03-07 Unknown Minnesota   521 68
1097105 1097105 2021-03-07 Wabasha Minnesota 27157 1873 3
1097106 1097106 2021-03-07 Wadena Minnesota 27159 1315 20
1097107 1097107 2021-03-07 Waseca Minnesota 27161 2112 17
1097108 1097108 2021-03-07 Washington Minnesota 27163 22247 262
1097109 1097109 2021-03-07 Watonwan Minnesota 27165 1183 8
1097110 1097110 2021-03-07 Wilkin Minnesota 27167 677 11
1097111 1097111 2021-03-07 Winona Minnesota 27169 4197 49
1097112 1097112 2021-03-07 Wright Minnesota 27171 12635 116
1097113 1097113 2021-03-07 Yellow Medicine Minnesota 27173 978 17
1093779 1093779 2021-03-06 Aitkin Minnesota 27001 1191 33
1093780 1093780 2021-03-06 Anoka Minnesota 27003 33496 391
1093781 1093781 2021-03-06 Becker Minnesota 27005 3148 42
1093782 1093782 2021-03-06 Beltrami Minnesota 27007 3389 51
1093783 1093783 2021-03-06 Benton Minnesota 27009 4509 90
1093784 1093784 2021-03-06 Big Stone Minnesota 27011 517 3
1093785 1093785 2021-03-06 Blue Earth Minnesota 27013 6010 35
1093786 1093786 2021-03-06 Brown Minnesota 27015 2482 37
1093787 1093787 2021-03-06 Carlton Minnesota 27017 3004 49
1093788 1093788 2021-03-06 Carver Minnesota 27019 7876 41
1093789 1093789 2021-03-06 Cass Minnesota 27021 2212 24
1093790 1093790 2021-03-06 Chippewa Minnesota 27023 1369 35

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
CREATE INDEX [idx_ny_times_us_counties_state]
    ON [ny_times_us_counties] ([state]);
CREATE INDEX [idx_ny_times_us_counties_county]
    ON [ny_times_us_counties] ([county]);
CREATE INDEX [idx_ny_times_us_counties_fips]
    ON [ny_times_us_counties] ([fips]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date]);