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 558
- 27019 556
- 27003 554
- 27109 553
- 27037 552
- 27053 552
- 27145 552
- 27171 551
- 27129 550
- 27161 549
- 27163 549
- 27009 548
- 27013 548
- 27091 547
- 27103 547
- 27131 546
- 27099 545
- 27139 545
- 27025 544
- 27027 544
- 27045 544
- 27039 543
- 27063 543
- 27137 543
- 27147 543
- 27157 543
- 27079 542
- 27011 541
- 27021 541
- 27073 541
- …
county >30
- Ramsey 558
- Carver 556
- Anoka 554
- Olmsted 553
- Dakota 552
- Hennepin 552
- Stearns 552
- Wright 551
- Renville 550
- Waseca 549
- Washington 549
- Benton 548
- Blue Earth 548
- Martin 547
- Nicollet 547
- Rice 546
- Mower 545
- Scott 545
- Chisago 544
- Clay 544
- Fillmore 544
- Dodge 543
- Jackson 543
- St. Louis 543
- Steele 543
- Wabasha 543
- Le Sueur 542
- Big Stone 541
- Cass 541
- Lac qui Parle 541
- …
state 1
- Minnesota · 46,675 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1717220 | 1717220 | 2021-09-14 | Aitkin | Minnesota | 27001 | 1536 | 38 |
1717221 | 1717221 | 2021-09-14 | Anoka | Minnesota | 27003 | 47542 | 476 |
1717222 | 1717222 | 2021-09-14 | Becker | Minnesota | 27005 | 4255 | 59 |
1717223 | 1717223 | 2021-09-14 | Beltrami | Minnesota | 27007 | 4911 | 70 |
1717224 | 1717224 | 2021-09-14 | Benton | Minnesota | 27009 | 6369 | 98 |
1717225 | 1717225 | 2021-09-14 | Big Stone | Minnesota | 27011 | 670 | 4 |
1717226 | 1717226 | 2021-09-14 | Blue Earth | Minnesota | 27013 | 8547 | 47 |
1717227 | 1717227 | 2021-09-14 | Brown | Minnesota | 27015 | 3420 | 43 |
1717228 | 1717228 | 2021-09-14 | Carlton | Minnesota | 27017 | 3857 | 59 |
1717229 | 1717229 | 2021-09-14 | Carver | Minnesota | 27019 | 11941 | 51 |
1717230 | 1717230 | 2021-09-14 | Cass | Minnesota | 27021 | 3374 | 35 |
1717231 | 1717231 | 2021-09-14 | Chippewa | Minnesota | 27023 | 1692 | 39 |
1717232 | 1717232 | 2021-09-14 | Chisago | Minnesota | 27025 | 7036 | 57 |
1717233 | 1717233 | 2021-09-14 | Clay | Minnesota | 27027 | 9022 | 93 |
1717234 | 1717234 | 2021-09-14 | Clearwater | Minnesota | 27029 | 989 | 18 |
1717235 | 1717235 | 2021-09-14 | Cook | Minnesota | 27031 | 206 | 0 |
1717236 | 1717236 | 2021-09-14 | Cottonwood | Minnesota | 27033 | 1756 | 24 |
1717237 | 1717237 | 2021-09-14 | Crow Wing | Minnesota | 27035 | 7684 | 101 |
1717238 | 1717238 | 2021-09-14 | Dakota | Minnesota | 27037 | 51562 | 493 |
1717239 | 1717239 | 2021-09-14 | Dodge | Minnesota | 27039 | 2369 | 3 |
1717240 | 1717240 | 2021-09-14 | Douglas | Minnesota | 27041 | 5264 | 84 |
1717241 | 1717241 | 2021-09-14 | Faribault | Minnesota | 27043 | 1764 | 22 |
1717242 | 1717242 | 2021-09-14 | Fillmore | Minnesota | 27045 | 1894 | 10 |
1717243 | 1717243 | 2021-09-14 | Freeborn | Minnesota | 27047 | 4244 | 38 |
1717244 | 1717244 | 2021-09-14 | Goodhue | Minnesota | 27049 | 5441 | 79 |
1717245 | 1717245 | 2021-09-14 | Grant | Minnesota | 27051 | 658 | 8 |
1717246 | 1717246 | 2021-09-14 | Hennepin | Minnesota | 27053 | 139244 | 1849 |
1717247 | 1717247 | 2021-09-14 | Houston | Minnesota | 27055 | 2004 | 16 |
1717248 | 1717248 | 2021-09-14 | Hubbard | Minnesota | 27057 | 2250 | 41 |
1717249 | 1717249 | 2021-09-14 | Isanti | Minnesota | 27059 | 4851 | 70 |
1717250 | 1717250 | 2021-09-14 | Itasca | Minnesota | 27061 | 5084 | 70 |
1717251 | 1717251 | 2021-09-14 | Jackson | Minnesota | 27063 | 1339 | 12 |
1717252 | 1717252 | 2021-09-14 | Kanabec | Minnesota | 27065 | 1626 | 29 |
1717253 | 1717253 | 2021-09-14 | Kandiyohi | Minnesota | 27067 | 7386 | 88 |
1717254 | 1717254 | 2021-09-14 | Kittson | Minnesota | 27069 | 526 | 22 |
1717255 | 1717255 | 2021-09-14 | Koochiching | Minnesota | 27071 | 1123 | 19 |
1717256 | 1717256 | 2021-09-14 | Lac qui Parle | Minnesota | 27073 | 833 | 23 |
1717257 | 1717257 | 2021-09-14 | Lake | Minnesota | 27075 | 900 | 21 |
1717258 | 1717258 | 2021-09-14 | Lake of the Woods | Minnesota | 27077 | 378 | 4 |
1717259 | 1717259 | 2021-09-14 | Le Sueur | Minnesota | 27079 | 3361 | 29 |
1717260 | 1717260 | 2021-09-14 | Lincoln | Minnesota | 27081 | 632 | 4 |
1717261 | 1717261 | 2021-09-14 | Lyon | Minnesota | 27083 | 3881 | 54 |
1717262 | 1717262 | 2021-09-14 | Mahnomen | Minnesota | 27087 | 661 | 9 |
1717263 | 1717263 | 2021-09-14 | Marshall | Minnesota | 27089 | 1004 | 18 |
1717264 | 1717264 | 2021-09-14 | Martin | Minnesota | 27091 | 2577 | 33 |
1717265 | 1717265 | 2021-09-14 | McLeod | Minnesota | 27085 | 4937 | 62 |
1717266 | 1717266 | 2021-09-14 | Meeker | Minnesota | 27093 | 3003 | 46 |
1717267 | 1717267 | 2021-09-14 | Mille Lacs | Minnesota | 27095 | 3510 | 60 |
1717268 | 1717268 | 2021-09-14 | Morrison | Minnesota | 27097 | 4615 | 62 |
1717269 | 1717269 | 2021-09-14 | Mower | Minnesota | 27099 | 5482 | 36 |
1717270 | 1717270 | 2021-09-14 | Murray | Minnesota | 27101 | 1138 | 10 |
1717271 | 1717271 | 2021-09-14 | Nicollet | Minnesota | 27103 | 3699 | 47 |
1717272 | 1717272 | 2021-09-14 | Nobles | Minnesota | 27105 | 4442 | 50 |
1717273 | 1717273 | 2021-09-14 | Norman | Minnesota | 27107 | 628 | 9 |
1717274 | 1717274 | 2021-09-14 | Olmsted | Minnesota | 27109 | 15582 | 110 |
1717275 | 1717275 | 2021-09-14 | Otter Tail | Minnesota | 27111 | 6588 | 90 |
1717276 | 1717276 | 2021-09-14 | Pennington | Minnesota | 27113 | 1871 | 21 |
1717277 | 1717277 | 2021-09-14 | Pine | Minnesota | 27115 | 3698 | 26 |
1717278 | 1717278 | 2021-09-14 | Pipestone | Minnesota | 27117 | 1233 | 26 |
1717279 | 1717279 | 2021-09-14 | Polk | Minnesota | 27119 | 4268 | 75 |
1717280 | 1717280 | 2021-09-14 | Pope | Minnesota | 27121 | 1279 | 8 |
1717281 | 1717281 | 2021-09-14 | Ramsey | Minnesota | 27123 | 58054 | 938 |
1717282 | 1717282 | 2021-09-14 | Red Lake | Minnesota | 27125 | 465 | 7 |
1717283 | 1717283 | 2021-09-14 | Redwood | Minnesota | 27127 | 1946 | 41 |
1717284 | 1717284 | 2021-09-14 | Renville | Minnesota | 27129 | 1978 | 47 |
1717285 | 1717285 | 2021-09-14 | Rice | Minnesota | 27131 | 9016 | 118 |
1717286 | 1717286 | 2021-09-14 | Rock | Minnesota | 27133 | 1374 | 19 |
1717287 | 1717287 | 2021-09-14 | Roseau | Minnesota | 27135 | 2290 | 22 |
1717288 | 1717288 | 2021-09-14 | Scott | Minnesota | 27139 | 19422 | 142 |
1717289 | 1717289 | 2021-09-14 | Sherburne | Minnesota | 27141 | 13324 | 100 |
1717290 | 1717290 | 2021-09-14 | Sibley | Minnesota | 27143 | 1733 | 10 |
1717291 | 1717291 | 2021-09-14 | St. Louis | Minnesota | 27137 | 19963 | 330 |
1717292 | 1717292 | 2021-09-14 | Stearns | Minnesota | 27145 | 24590 | 236 |
1717293 | 1717293 | 2021-09-14 | Steele | Minnesota | 27147 | 4937 | 21 |
1717294 | 1717294 | 2021-09-14 | Stevens | Minnesota | 27149 | 1041 | 11 |
1717295 | 1717295 | 2021-09-14 | Swift | Minnesota | 27151 | 1160 | 19 |
1717296 | 1717296 | 2021-09-14 | Todd | Minnesota | 27153 | 3164 | 34 |
1717297 | 1717297 | 2021-09-14 | Traverse | Minnesota | 27155 | 419 | 5 |
1717298 | 1717298 | 2021-09-14 | Unknown | Minnesota | 604 | 93 | |
1717299 | 1717299 | 2021-09-14 | Wabasha | Minnesota | 27157 | 2378 | 4 |
1717300 | 1717300 | 2021-09-14 | Wadena | Minnesota | 27159 | 1808 | 23 |
1717301 | 1717301 | 2021-09-14 | Waseca | Minnesota | 27161 | 2838 | 23 |
1717302 | 1717302 | 2021-09-14 | Washington | Minnesota | 27163 | 30346 | 309 |
1717303 | 1717303 | 2021-09-14 | Watonwan | Minnesota | 27165 | 1531 | 11 |
1717304 | 1717304 | 2021-09-14 | Wilkin | Minnesota | 27167 | 889 | 14 |
1717305 | 1717305 | 2021-09-14 | Winona | Minnesota | 27169 | 5475 | 52 |
1717306 | 1717306 | 2021-09-14 | Wright | Minnesota | 27171 | 18258 | 161 |
1717307 | 1717307 | 2021-09-14 | Yellow Medicine | Minnesota | 27173 | 1228 | 20 |
1713972 | 1713972 | 2021-09-13 | Aitkin | Minnesota | 27001 | 1524 | 38 |
1713973 | 1713973 | 2021-09-13 | Anoka | Minnesota | 27003 | 47228 | 475 |
1713974 | 1713974 | 2021-09-13 | Becker | Minnesota | 27005 | 4221 | 59 |
1713975 | 1713975 | 2021-09-13 | Beltrami | Minnesota | 27007 | 4867 | 70 |
1713976 | 1713976 | 2021-09-13 | Benton | Minnesota | 27009 | 6320 | 98 |
1713977 | 1713977 | 2021-09-13 | Big Stone | Minnesota | 27011 | 666 | 4 |
1713978 | 1713978 | 2021-09-13 | Blue Earth | Minnesota | 27013 | 8469 | 47 |
1713979 | 1713979 | 2021-09-13 | Brown | Minnesota | 27015 | 3387 | 43 |
1713980 | 1713980 | 2021-09-13 | Carlton | Minnesota | 27017 | 3844 | 59 |
1713981 | 1713981 | 2021-09-13 | Carver | Minnesota | 27019 | 11860 | 51 |
1713982 | 1713982 | 2021-09-13 | Cass | Minnesota | 27021 | 3349 | 35 |
1713983 | 1713983 | 2021-09-13 | Chippewa | Minnesota | 27023 | 1679 | 39 |
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);