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 312
- 27019 309
- 27003 307
- 27109 307
- 27037 306
- 27053 306
- 27145 306
- 27171 305
- 27129 304
- 27161 303
- 27163 303
- 27009 301
- 27013 301
- 27091 301
- 27103 301
- 27131 300
- 27099 299
- 27139 299
- 27025 298
- 27027 298
- 27045 298
- 27039 297
- 27063 297
- 27137 297
- 27147 297
- 27157 297
- 27079 296
- 27073 295
- 27141 295
- 27011 294
- …
county >30
- Ramsey 312
- Carver 309
- Anoka 307
- Olmsted 307
- Dakota 306
- Hennepin 306
- Stearns 306
- Wright 305
- Renville 304
- Waseca 303
- Washington 303
- Benton 301
- Blue Earth 301
- Martin 301
- Nicollet 301
- Rice 300
- Mower 299
- Scott 299
- Chisago 298
- Clay 298
- Fillmore 298
- Dodge 297
- Jackson 297
- St. Louis 297
- Steele 297
- Wabasha 297
- Le Sueur 296
- Lac qui Parle 295
- Sherburne 295
- Big Stone 294
- …
state 1
- Minnesota · 25,015 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
918531 | 918531 | 2021-01-11 | Chisago | Minnesota | 27025 | 4427 | 29 |
918532 | 918532 | 2021-01-11 | Clay | Minnesota | 27027 | 6372 | 78 |
918533 | 918533 | 2021-01-11 | Clearwater | Minnesota | 27029 | 678 | 14 |
918534 | 918534 | 2021-01-11 | Cook | Minnesota | 27031 | 111 | 0 |
918535 | 918535 | 2021-01-11 | Cottonwood | Minnesota | 27033 | 1239 | 17 |
918536 | 918536 | 2021-01-11 | Crow Wing | Minnesota | 27035 | 4709 | 71 |
918537 | 918537 | 2021-01-11 | Dakota | Minnesota | 27037 | 32250 | 309 |
918538 | 918538 | 2021-01-11 | Dodge | Minnesota | 27039 | 1274 | 4 |
918539 | 918539 | 2021-01-11 | Douglas | Minnesota | 27041 | 3669 | 64 |
918540 | 918540 | 2021-01-11 | Faribault | Minnesota | 27043 | 1013 | 14 |
918541 | 918541 | 2021-01-11 | Fillmore | Minnesota | 27045 | 1175 | 3 |
918542 | 918542 | 2021-01-11 | Freeborn | Minnesota | 27047 | 2253 | 18 |
918543 | 918543 | 2021-01-11 | Goodhue | Minnesota | 27049 | 3338 | 53 |
918544 | 918544 | 2021-01-11 | Grant | Minnesota | 27051 | 423 | 7 |
918545 | 918545 | 2021-01-11 | Hennepin | Minnesota | 27053 | 91060 | 1447 |
918546 | 918546 | 2021-01-11 | Houston | Minnesota | 27055 | 1300 | 13 |
918547 | 918547 | 2021-01-11 | Hubbard | Minnesota | 27057 | 1451 | 37 |
918548 | 918548 | 2021-01-11 | Isanti | Minnesota | 27059 | 2776 | 39 |
918549 | 918549 | 2021-01-11 | Itasca | Minnesota | 27061 | 2783 | 41 |
918550 | 918550 | 2021-01-11 | Jackson | Minnesota | 27063 | 829 | 10 |
918551 | 918551 | 2021-01-11 | Kanabec | Minnesota | 27065 | 961 | 18 |
918552 | 918552 | 2021-01-11 | Kandiyohi | Minnesota | 27067 | 5481 | 69 |
918553 | 918553 | 2021-01-11 | Kittson | Minnesota | 27069 | 357 | 19 |
918554 | 918554 | 2021-01-11 | Koochiching | Minnesota | 27071 | 572 | 10 |
918555 | 918555 | 2021-01-11 | Lac qui Parle | Minnesota | 27073 | 646 | 16 |
918556 | 918556 | 2021-01-11 | Lake | Minnesota | 27075 | 603 | 15 |
918557 | 918557 | 2021-01-11 | Lake of the Woods | Minnesota | 27077 | 170 | 1 |
918558 | 918558 | 2021-01-11 | Le Sueur | Minnesota | 27079 | 2047 | 15 |
918559 | 918559 | 2021-01-11 | Lincoln | Minnesota | 27081 | 477 | 1 |
918560 | 918560 | 2021-01-11 | Lyon | Minnesota | 27083 | 2971 | 34 |
918561 | 918561 | 2021-01-11 | Mahnomen | Minnesota | 27087 | 405 | 7 |
918562 | 918562 | 2021-01-11 | Marshall | Minnesota | 27089 | 696 | 15 |
918563 | 918563 | 2021-01-11 | Martin | Minnesota | 27091 | 1657 | 26 |
918564 | 918564 | 2021-01-11 | McLeod | Minnesota | 27085 | 3204 | 41 |
918565 | 918565 | 2021-01-11 | Meeker | Minnesota | 27093 | 1959 | 33 |
918566 | 918566 | 2021-01-11 | Mille Lacs | Minnesota | 27095 | 2108 | 45 |
918567 | 918567 | 2021-01-11 | Morrison | Minnesota | 27097 | 3063 | 43 |
918568 | 918568 | 2021-01-11 | Mower | Minnesota | 27099 | 3494 | 26 |
918569 | 918569 | 2021-01-11 | Murray | Minnesota | 27101 | 844 | 5 |
918570 | 918570 | 2021-01-11 | Nicollet | Minnesota | 27103 | 2196 | 36 |
918571 | 918571 | 2021-01-11 | Nobles | Minnesota | 27105 | 3624 | 46 |
918572 | 918572 | 2021-01-11 | Norman | Minnesota | 27107 | 421 | 8 |
918573 | 918573 | 2021-01-11 | Olmsted | Minnesota | 27109 | 10015 | 68 |
918574 | 918574 | 2021-01-11 | Otter Tail | Minnesota | 27111 | 4444 | 57 |
918575 | 918575 | 2021-01-11 | Pennington | Minnesota | 27113 | 932 | 15 |
918576 | 918576 | 2021-01-11 | Pine | Minnesota | 27115 | 2614 | 13 |
918577 | 918577 | 2021-01-11 | Pipestone | Minnesota | 27117 | 911 | 22 |
918578 | 918578 | 2021-01-11 | Polk | Minnesota | 27119 | 3252 | 53 |
918579 | 918579 | 2021-01-11 | Pope | Minnesota | 27121 | 732 | 5 |
918580 | 918580 | 2021-01-11 | Ramsey | Minnesota | 27123 | 39054 | 722 |
918581 | 918581 | 2021-01-11 | Red Lake | Minnesota | 27125 | 314 | 4 |
918582 | 918582 | 2021-01-11 | Redwood | Minnesota | 27127 | 1362 | 27 |
918583 | 918583 | 2021-01-11 | Renville | Minnesota | 27129 | 1351 | 39 |
918584 | 918584 | 2021-01-11 | Rice | Minnesota | 27131 | 5872 | 64 |
918585 | 918585 | 2021-01-11 | Rock | Minnesota | 27133 | 1074 | 11 |
918586 | 918586 | 2021-01-11 | Roseau | Minnesota | 27135 | 1641 | 16 |
918587 | 918587 | 2021-01-11 | Scott | Minnesota | 27139 | 11665 | 93 |
918588 | 918588 | 2021-01-11 | Sherburne | Minnesota | 27141 | 8071 | 62 |
918589 | 918589 | 2021-01-11 | Sibley | Minnesota | 27143 | 1066 | 7 |
918590 | 918590 | 2021-01-11 | St. Louis | Minnesota | 27137 | 13315 | 229 |
918591 | 918591 | 2021-01-11 | Stearns | Minnesota | 27145 | 17568 | 179 |
918592 | 918592 | 2021-01-11 | Steele | Minnesota | 27147 | 2628 | 9 |
918593 | 918593 | 2021-01-11 | Stevens | Minnesota | 27149 | 690 | 8 |
918594 | 918594 | 2021-01-11 | Swift | Minnesota | 27151 | 820 | 17 |
918595 | 918595 | 2021-01-11 | Todd | Minnesota | 27153 | 2292 | 29 |
918596 | 918596 | 2021-01-11 | Traverse | Minnesota | 27155 | 237 | 3 |
918597 | 918597 | 2021-01-11 | Unknown | Minnesota | 532 | 68 | |
918598 | 918598 | 2021-01-11 | Wabasha | Minnesota | 27157 | 1631 | 2 |
918599 | 918599 | 2021-01-11 | Wadena | Minnesota | 27159 | 1176 | 13 |
918600 | 918600 | 2021-01-11 | Waseca | Minnesota | 27161 | 1864 | 16 |
918601 | 918601 | 2021-01-11 | Washington | Minnesota | 27163 | 19630 | 213 |
918602 | 918602 | 2021-01-11 | Watonwan | Minnesota | 27165 | 1049 | 7 |
918603 | 918603 | 2021-01-11 | Wilkin | Minnesota | 27167 | 608 | 9 |
918604 | 918604 | 2021-01-11 | Winona | Minnesota | 27169 | 3763 | 45 |
918605 | 918605 | 2021-01-11 | Wright | Minnesota | 27171 | 11364 | 98 |
918606 | 918606 | 2021-01-11 | Yellow Medicine | Minnesota | 27173 | 920 | 14 |
915274 | 915274 | 2021-01-10 | Aitkin | Minnesota | 27001 | 1049 | 33 |
915275 | 915275 | 2021-01-10 | Anoka | Minnesota | 27003 | 30354 | 347 |
915276 | 915276 | 2021-01-10 | Becker | Minnesota | 27005 | 2774 | 38 |
915277 | 915277 | 2021-01-10 | Beltrami | Minnesota | 27007 | 3009 | 46 |
915278 | 915278 | 2021-01-10 | Benton | Minnesota | 27009 | 4090 | 84 |
915279 | 915279 | 2021-01-10 | Big Stone | Minnesota | 27011 | 450 | 3 |
915280 | 915280 | 2021-01-10 | Blue Earth | Minnesota | 27013 | 5272 | 32 |
915281 | 915281 | 2021-01-10 | Brown | Minnesota | 27015 | 2096 | 34 |
915282 | 915282 | 2021-01-10 | Carlton | Minnesota | 27017 | 2741 | 41 |
915283 | 915283 | 2021-01-10 | Carver | Minnesota | 27019 | 6789 | 34 |
915284 | 915284 | 2021-01-10 | Cass | Minnesota | 27021 | 2007 | 22 |
915285 | 915285 | 2021-01-10 | Chippewa | Minnesota | 27023 | 1304 | 31 |
915286 | 915286 | 2021-01-10 | Chisago | Minnesota | 27025 | 4419 | 29 |
915287 | 915287 | 2021-01-10 | Clay | Minnesota | 27027 | 6369 | 78 |
915288 | 915288 | 2021-01-10 | Clearwater | Minnesota | 27029 | 678 | 14 |
915289 | 915289 | 2021-01-10 | Cook | Minnesota | 27031 | 111 | 0 |
915290 | 915290 | 2021-01-10 | Cottonwood | Minnesota | 27033 | 1238 | 17 |
915291 | 915291 | 2021-01-10 | Crow Wing | Minnesota | 27035 | 4691 | 71 |
915292 | 915292 | 2021-01-10 | Dakota | Minnesota | 27037 | 32154 | 308 |
915293 | 915293 | 2021-01-10 | Dodge | Minnesota | 27039 | 1273 | 4 |
915294 | 915294 | 2021-01-10 | Douglas | Minnesota | 27041 | 3663 | 64 |
915295 | 915295 | 2021-01-10 | Faribault | Minnesota | 27043 | 1011 | 14 |
915296 | 915296 | 2021-01-10 | Fillmore | Minnesota | 27045 | 1174 | 3 |
915297 | 915297 | 2021-01-10 | Freeborn | Minnesota | 27047 | 2245 | 18 |
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);