ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where date = "2020-10-29" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
678390 | 678390 | 2020-10-29 | Aitkin | Minnesota | 27001 | 198 | 2 |
678391 | 678391 | 2020-10-29 | Anoka | Minnesota | 27003 | 9344 | 155 |
678392 | 678392 | 2020-10-29 | Becker | Minnesota | 27005 | 621 | 4 |
678393 | 678393 | 2020-10-29 | Beltrami | Minnesota | 27007 | 961 | 8 |
678394 | 678394 | 2020-10-29 | Benton | Minnesota | 27009 | 1033 | 11 |
678395 | 678395 | 2020-10-29 | Big Stone | Minnesota | 27011 | 159 | 1 |
678396 | 678396 | 2020-10-29 | Blue Earth | Minnesota | 27013 | 2114 | 7 |
678397 | 678397 | 2020-10-29 | Brown | Minnesota | 27015 | 348 | 3 |
678398 | 678398 | 2020-10-29 | Carlton | Minnesota | 27017 | 509 | 2 |
678399 | 678399 | 2020-10-29 | Carver | Minnesota | 27019 | 1888 | 7 |
678400 | 678400 | 2020-10-29 | Cass | Minnesota | 27021 | 422 | 5 |
678401 | 678401 | 2020-10-29 | Chippewa | Minnesota | 27023 | 473 | 3 |
678402 | 678402 | 2020-10-29 | Chisago | Minnesota | 27025 | 1156 | 2 |
678403 | 678403 | 2020-10-29 | Clay | Minnesota | 27027 | 2529 | 44 |
678404 | 678404 | 2020-10-29 | Clearwater | Minnesota | 27029 | 138 | 1 |
678405 | 678405 | 2020-10-29 | Cook | Minnesota | 27031 | 19 | 0 |
678406 | 678406 | 2020-10-29 | Cottonwood | Minnesota | 27033 | 295 | 0 |
678407 | 678407 | 2020-10-29 | Crow Wing | Minnesota | 27035 | 1143 | 22 |
678408 | 678408 | 2020-10-29 | Dakota | Minnesota | 27037 | 10271 | 139 |
678409 | 678409 | 2020-10-29 | Dodge | Minnesota | 27039 | 413 | 0 |
678410 | 678410 | 2020-10-29 | Douglas | Minnesota | 27041 | 774 | 4 |
678411 | 678411 | 2020-10-29 | Faribault | Minnesota | 27043 | 252 | 0 |
678412 | 678412 | 2020-10-29 | Fillmore | Minnesota | 27045 | 277 | 0 |
678413 | 678413 | 2020-10-29 | Freeborn | Minnesota | 27047 | 718 | 5 |
678414 | 678414 | 2020-10-29 | Goodhue | Minnesota | 27049 | 651 | 11 |
678415 | 678415 | 2020-10-29 | Grant | Minnesota | 27051 | 105 | 4 |
678416 | 678416 | 2020-10-29 | Hennepin | Minnesota | 27053 | 35484 | 995 |
678417 | 678417 | 2020-10-29 | Houston | Minnesota | 27055 | 238 | 1 |
678418 | 678418 | 2020-10-29 | Hubbard | Minnesota | 27057 | 434 | 4 |
678419 | 678419 | 2020-10-29 | Isanti | Minnesota | 27059 | 599 | 5 |
678420 | 678420 | 2020-10-29 | Itasca | Minnesota | 27061 | 788 | 17 |
678421 | 678421 | 2020-10-29 | Jackson | Minnesota | 27063 | 221 | 1 |
678422 | 678422 | 2020-10-29 | Kanabec | Minnesota | 27065 | 237 | 10 |
678423 | 678423 | 2020-10-29 | Kandiyohi | Minnesota | 27067 | 1821 | 5 |
678424 | 678424 | 2020-10-29 | Kittson | Minnesota | 27069 | 53 | 0 |
678425 | 678425 | 2020-10-29 | Koochiching | Minnesota | 27071 | 175 | 5 |
678426 | 678426 | 2020-10-29 | Lac qui Parle | Minnesota | 27073 | 145 | 3 |
678427 | 678427 | 2020-10-29 | Lake | Minnesota | 27075 | 133 | 0 |
678428 | 678428 | 2020-10-29 | Lake of the Woods | Minnesota | 27077 | 44 | 1 |
678429 | 678429 | 2020-10-29 | Le Sueur | Minnesota | 27079 | 664 | 6 |
678430 | 678430 | 2020-10-29 | Lincoln | Minnesota | 27081 | 193 | 0 |
678431 | 678431 | 2020-10-29 | Lyon | Minnesota | 27083 | 1030 | 6 |
678432 | 678432 | 2020-10-29 | Mahnomen | Minnesota | 27087 | 129 | 2 |
678433 | 678433 | 2020-10-29 | Marshall | Minnesota | 27089 | 151 | 1 |
678434 | 678434 | 2020-10-29 | Martin | Minnesota | 27091 | 626 | 18 |
678435 | 678435 | 2020-10-29 | McLeod | Minnesota | 27085 | 621 | 4 |
678436 | 678436 | 2020-10-29 | Meeker | Minnesota | 27093 | 359 | 3 |
678437 | 678437 | 2020-10-29 | Mille Lacs | Minnesota | 27095 | 449 | 18 |
678438 | 678438 | 2020-10-29 | Morrison | Minnesota | 27097 | 825 | 9 |
678439 | 678439 | 2020-10-29 | Mower | Minnesota | 27099 | 1545 | 18 |
678440 | 678440 | 2020-10-29 | Murray | Minnesota | 27101 | 297 | 3 |
678441 | 678441 | 2020-10-29 | Nicollet | Minnesota | 27103 | 771 | 18 |
678442 | 678442 | 2020-10-29 | Nobles | Minnesota | 27105 | 2343 | 18 |
678443 | 678443 | 2020-10-29 | Norman | Minnesota | 27107 | 134 | 0 |
678444 | 678444 | 2020-10-29 | Olmsted | Minnesota | 27109 | 3402 | 30 |
678445 | 678445 | 2020-10-29 | Otter Tail | Minnesota | 27111 | 950 | 8 |
678446 | 678446 | 2020-10-29 | Pennington | Minnesota | 27113 | 218 | 1 |
678447 | 678447 | 2020-10-29 | Pine | Minnesota | 27115 | 577 | 0 |
678448 | 678448 | 2020-10-29 | Pipestone | Minnesota | 27117 | 366 | 17 |
678449 | 678449 | 2020-10-29 | Polk | Minnesota | 27119 | 836 | 4 |
678450 | 678450 | 2020-10-29 | Pope | Minnesota | 27121 | 168 | 0 |
678451 | 678451 | 2020-10-29 | Ramsey | Minnesota | 27123 | 14726 | 372 |
678452 | 678452 | 2020-10-29 | Red Lake | Minnesota | 27125 | 82 | 2 |
678453 | 678453 | 2020-10-29 | Redwood | Minnesota | 27127 | 299 | 12 |
678454 | 678454 | 2020-10-29 | Renville | Minnesota | 27129 | 272 | 13 |
678455 | 678455 | 2020-10-29 | Rice | Minnesota | 27131 | 1702 | 10 |
678456 | 678456 | 2020-10-29 | Rock | Minnesota | 27133 | 359 | 5 |
678457 | 678457 | 2020-10-29 | Roseau | Minnesota | 27135 | 330 | 0 |
678458 | 678458 | 2020-10-29 | Scott | Minnesota | 27139 | 3604 | 36 |
678459 | 678459 | 2020-10-29 | Sherburne | Minnesota | 27141 | 1831 | 22 |
678460 | 678460 | 2020-10-29 | Sibley | Minnesota | 27143 | 266 | 3 |
678461 | 678461 | 2020-10-29 | St. Louis | Minnesota | 27137 | 3258 | 74 |
678462 | 678462 | 2020-10-29 | Stearns | Minnesota | 27145 | 6255 | 50 |
678463 | 678463 | 2020-10-29 | Steele | Minnesota | 27147 | 801 | 3 |
678464 | 678464 | 2020-10-29 | Stevens | Minnesota | 27149 | 194 | 1 |
678465 | 678465 | 2020-10-29 | Swift | Minnesota | 27151 | 225 | 2 |
678466 | 678466 | 2020-10-29 | Todd | Minnesota | 27153 | 896 | 7 |
678467 | 678467 | 2020-10-29 | Traverse | Minnesota | 27155 | 59 | 0 |
678468 | 678468 | 2020-10-29 | Unknown | Minnesota | 291 | 53 | |
678469 | 678469 | 2020-10-29 | Wabasha | Minnesota | 27157 | 414 | 1 |
678470 | 678470 | 2020-10-29 | Wadena | Minnesota | 27159 | 264 | 3 |
678471 | 678471 | 2020-10-29 | Waseca | Minnesota | 27161 | 945 | 10 |
678472 | 678472 | 2020-10-29 | Washington | Minnesota | 27163 | 6362 | 73 |
678473 | 678473 | 2020-10-29 | Watonwan | Minnesota | 27165 | 582 | 4 |
678474 | 678474 | 2020-10-29 | Wilkin | Minnesota | 27167 | 145 | 4 |
678475 | 678475 | 2020-10-29 | Winona | Minnesota | 27169 | 1336 | 19 |
678476 | 678476 | 2020-10-29 | Wright | Minnesota | 27171 | 2731 | 16 |
678477 | 678477 | 2020-10-29 | Yellow Medicine | Minnesota | 27173 | 298 | 6 |
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);