ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67,883 rows where state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 27123 148
- 27019 146
- 27003 144
- 27109 143
- 27037 142
- 27053 142
- 27145 142
- 27171 141
- 27129 140
- 27161 139
- 27163 139
- 27009 138
- 27013 138
- 27091 137
- 27103 137
- 27131 136
- 27099 135
- 27139 135
- 27025 134
- 27027 134
- 27045 134
- 27039 133
- 27063 133
- 27137 133
- 27147 133
- 27157 133
- 27079 132
- 27011 131
- 27021 131
- 27073 131
- …
county >30
- Ramsey 148
- Carver 146
- Anoka 144
- Olmsted 143
- Dakota 142
- Hennepin 142
- Stearns 142
- Wright 141
- Renville 140
- Waseca 139
- Washington 139
- Benton 138
- Blue Earth 138
- Martin 137
- Nicollet 137
- Rice 136
- Mower 135
- Scott 135
- Chisago 134
- Clay 134
- Fillmore 134
- Dodge 133
- Jackson 133
- St. Louis 133
- Steele 133
- Wabasha 133
- Le Sueur 132
- Big Stone 131
- Cass 131
- Lac qui Parle 131
- …
state 1
- Minnesota · 10,595 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387259 | 387259 | 2020-07-31 | Aitkin | Minnesota | 27001 | 27 | 0 |
387260 | 387260 | 2020-07-31 | Anoka | Minnesota | 27003 | 3245 | 112 |
387261 | 387261 | 2020-07-31 | Becker | Minnesota | 27005 | 134 | 1 |
387262 | 387262 | 2020-07-31 | Beltrami | Minnesota | 27007 | 184 | 0 |
387263 | 387263 | 2020-07-31 | Benton | Minnesota | 27009 | 299 | 3 |
387264 | 387264 | 2020-07-31 | Big Stone | Minnesota | 27011 | 22 | 0 |
387265 | 387265 | 2020-07-31 | Blue Earth | Minnesota | 27013 | 824 | 4 |
387266 | 387266 | 2020-07-31 | Brown | Minnesota | 27015 | 79 | 2 |
387267 | 387267 | 2020-07-31 | Carlton | Minnesota | 27017 | 121 | 0 |
387268 | 387268 | 2020-07-31 | Carver | Minnesota | 27019 | 744 | 2 |
387269 | 387269 | 2020-07-31 | Cass | Minnesota | 27021 | 54 | 2 |
387270 | 387270 | 2020-07-31 | Chippewa | Minnesota | 27023 | 93 | 1 |
387271 | 387271 | 2020-07-31 | Chisago | Minnesota | 27025 | 167 | 1 |
387272 | 387272 | 2020-07-31 | Clay | Minnesota | 27027 | 740 | 39 |
387273 | 387273 | 2020-07-31 | Clearwater | Minnesota | 27029 | 14 | 0 |
387274 | 387274 | 2020-07-31 | Cook | Minnesota | 27031 | 2 | 0 |
387275 | 387275 | 2020-07-31 | Cottonwood | Minnesota | 27033 | 167 | 0 |
387276 | 387276 | 2020-07-31 | Crow Wing | Minnesota | 27035 | 192 | 13 |
387277 | 387277 | 2020-07-31 | Dakota | Minnesota | 27037 | 3797 | 102 |
387278 | 387278 | 2020-07-31 | Dodge | Minnesota | 27039 | 122 | 0 |
387279 | 387279 | 2020-07-31 | Douglas | Minnesota | 27041 | 124 | 0 |
387280 | 387280 | 2020-07-31 | Faribault | Minnesota | 27043 | 80 | 0 |
387281 | 387281 | 2020-07-31 | Fillmore | Minnesota | 27045 | 59 | 0 |
387282 | 387282 | 2020-07-31 | Freeborn | Minnesota | 27047 | 353 | 1 |
387283 | 387283 | 2020-07-31 | Goodhue | Minnesota | 27049 | 169 | 8 |
387284 | 387284 | 2020-07-31 | Grant | Minnesota | 27051 | 44 | 1 |
387285 | 387285 | 2020-07-31 | Hennepin | Minnesota | 27053 | 17316 | 813 |
387286 | 387286 | 2020-07-31 | Houston | Minnesota | 27055 | 37 | 0 |
387287 | 387287 | 2020-07-31 | Hubbard | Minnesota | 27057 | 27 | 0 |
387288 | 387288 | 2020-07-31 | Isanti | Minnesota | 27059 | 102 | 0 |
387289 | 387289 | 2020-07-31 | Itasca | Minnesota | 27061 | 125 | 12 |
387290 | 387290 | 2020-07-31 | Jackson | Minnesota | 27063 | 68 | 0 |
387291 | 387291 | 2020-07-31 | Kanabec | Minnesota | 27065 | 23 | 1 |
387292 | 387292 | 2020-07-31 | Kandiyohi | Minnesota | 27067 | 662 | 1 |
387293 | 387293 | 2020-07-31 | Kittson | Minnesota | 27069 | 3 | 0 |
387294 | 387294 | 2020-07-31 | Koochiching | Minnesota | 27071 | 68 | 3 |
387295 | 387295 | 2020-07-31 | Lac qui Parle | Minnesota | 27073 | 6 | 0 |
387296 | 387296 | 2020-07-31 | Lake | Minnesota | 27075 | 15 | 0 |
387297 | 387297 | 2020-07-31 | Lake of the Woods | Minnesota | 27077 | 1 | 0 |
387298 | 387298 | 2020-07-31 | Le Sueur | Minnesota | 27079 | 196 | 1 |
387299 | 387299 | 2020-07-31 | Lincoln | Minnesota | 27081 | 53 | 0 |
387300 | 387300 | 2020-07-31 | Lyon | Minnesota | 27083 | 414 | 3 |
387301 | 387301 | 2020-07-31 | Mahnomen | Minnesota | 27087 | 22 | 1 |
387302 | 387302 | 2020-07-31 | Marshall | Minnesota | 27089 | 27 | 0 |
387303 | 387303 | 2020-07-31 | Martin | Minnesota | 27091 | 202 | 5 |
387304 | 387304 | 2020-07-31 | McLeod | Minnesota | 27085 | 125 | 0 |
387305 | 387305 | 2020-07-31 | Meeker | Minnesota | 27093 | 83 | 2 |
387306 | 387306 | 2020-07-31 | Mille Lacs | Minnesota | 27095 | 54 | 3 |
387307 | 387307 | 2020-07-31 | Morrison | Minnesota | 27097 | 81 | 1 |
387308 | 387308 | 2020-07-31 | Mower | Minnesota | 27099 | 1064 | 2 |
387309 | 387309 | 2020-07-31 | Murray | Minnesota | 27101 | 120 | 1 |
387310 | 387310 | 2020-07-31 | Nicollet | Minnesota | 27103 | 298 | 13 |
387311 | 387311 | 2020-07-31 | Nobles | Minnesota | 27105 | 1738 | 6 |
387312 | 387312 | 2020-07-31 | Norman | Minnesota | 27107 | 34 | 0 |
387313 | 387313 | 2020-07-31 | Olmsted | Minnesota | 27109 | 1588 | 23 |
387314 | 387314 | 2020-07-31 | Otter Tail | Minnesota | 27111 | 164 | 3 |
387315 | 387315 | 2020-07-31 | Pennington | Minnesota | 27113 | 70 | 1 |
387316 | 387316 | 2020-07-31 | Pine | Minnesota | 27115 | 124 | 0 |
387317 | 387317 | 2020-07-31 | Pipestone | Minnesota | 27117 | 142 | 9 |
387318 | 387318 | 2020-07-31 | Polk | Minnesota | 27119 | 125 | 3 |
387319 | 387319 | 2020-07-31 | Pope | Minnesota | 27121 | 38 | 0 |
387320 | 387320 | 2020-07-31 | Ramsey | Minnesota | 27123 | 6686 | 259 |
387321 | 387321 | 2020-07-31 | Red Lake | Minnesota | 27125 | 16 | 0 |
387322 | 387322 | 2020-07-31 | Redwood | Minnesota | 27127 | 30 | 0 |
387323 | 387323 | 2020-07-31 | Renville | Minnesota | 27129 | 56 | 5 |
387324 | 387324 | 2020-07-31 | Rice | Minnesota | 27131 | 975 | 8 |
387325 | 387325 | 2020-07-31 | Rock | Minnesota | 27133 | 72 | 0 |
387326 | 387326 | 2020-07-31 | Roseau | Minnesota | 27135 | 42 | 0 |
387327 | 387327 | 2020-07-31 | Scott | Minnesota | 27139 | 1296 | 12 |
387328 | 387328 | 2020-07-31 | Sherburne | Minnesota | 27141 | 615 | 6 |
387329 | 387329 | 2020-07-31 | Sibley | Minnesota | 27143 | 76 | 2 |
387330 | 387330 | 2020-07-31 | St. Louis | Minnesota | 27137 | 383 | 18 |
387331 | 387331 | 2020-07-31 | Stearns | Minnesota | 27145 | 2791 | 20 |
387332 | 387332 | 2020-07-31 | Steele | Minnesota | 27147 | 321 | 1 |
387333 | 387333 | 2020-07-31 | Stevens | Minnesota | 27149 | 15 | 0 |
387334 | 387334 | 2020-07-31 | Swift | Minnesota | 27151 | 51 | 1 |
387335 | 387335 | 2020-07-31 | Todd | Minnesota | 27153 | 413 | 2 |
387336 | 387336 | 2020-07-31 | Traverse | Minnesota | 27155 | 10 | 0 |
387337 | 387337 | 2020-07-31 | Unknown | Minnesota | 156 | 40 | |
387338 | 387338 | 2020-07-31 | Wabasha | Minnesota | 27157 | 78 | 0 |
387339 | 387339 | 2020-07-31 | Wadena | Minnesota | 27159 | 23 | 0 |
387340 | 387340 | 2020-07-31 | Waseca | Minnesota | 27161 | 128 | 0 |
387341 | 387341 | 2020-07-31 | Washington | Minnesota | 27163 | 1817 | 43 |
387342 | 387342 | 2020-07-31 | Watonwan | Minnesota | 27165 | 299 | 0 |
387343 | 387343 | 2020-07-31 | Wilkin | Minnesota | 27167 | 26 | 3 |
387344 | 387344 | 2020-07-31 | Winona | Minnesota | 27169 | 240 | 16 |
387345 | 387345 | 2020-07-31 | Wright | Minnesota | 27171 | 770 | 5 |
387346 | 387346 | 2020-07-31 | Yellow Medicine | Minnesota | 27173 | 47 | 0 |
384041 | 384041 | 2020-07-30 | Aitkin | Minnesota | 27001 | 25 | 0 |
384042 | 384042 | 2020-07-30 | Anoka | Minnesota | 27003 | 3190 | 112 |
384043 | 384043 | 2020-07-30 | Becker | Minnesota | 27005 | 129 | 1 |
384044 | 384044 | 2020-07-30 | Beltrami | Minnesota | 27007 | 180 | 0 |
384045 | 384045 | 2020-07-30 | Benton | Minnesota | 27009 | 294 | 3 |
384046 | 384046 | 2020-07-30 | Big Stone | Minnesota | 27011 | 22 | 0 |
384047 | 384047 | 2020-07-30 | Blue Earth | Minnesota | 27013 | 801 | 4 |
384048 | 384048 | 2020-07-30 | Brown | Minnesota | 27015 | 78 | 2 |
384049 | 384049 | 2020-07-30 | Carlton | Minnesota | 27017 | 120 | 0 |
384050 | 384050 | 2020-07-30 | Carver | Minnesota | 27019 | 723 | 2 |
384051 | 384051 | 2020-07-30 | Cass | Minnesota | 27021 | 50 | 2 |
384052 | 384052 | 2020-07-30 | Chippewa | Minnesota | 27023 | 92 | 1 |
Advanced export
JSON shape: default, array, newline-delimited
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] desc);