ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where "date" is on date 2021-10-25 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1850435 | 1850435 | 2021-10-25 | Aitkin | Minnesota | 27001 | 1857 | 43 |
1850436 | 1850436 | 2021-10-25 | Anoka | Minnesota | 27003 | 54212 | 521 |
1850437 | 1850437 | 2021-10-25 | Becker | Minnesota | 27005 | 5375 | 62 |
1850438 | 1850438 | 2021-10-25 | Beltrami | Minnesota | 27007 | 6612 | 80 |
1850439 | 1850439 | 2021-10-25 | Benton | Minnesota | 27009 | 7538 | 112 |
1850440 | 1850440 | 2021-10-25 | Big Stone | Minnesota | 27011 | 798 | 4 |
1850441 | 1850441 | 2021-10-25 | Blue Earth | Minnesota | 27013 | 9694 | 59 |
1850442 | 1850442 | 2021-10-25 | Brown | Minnesota | 27015 | 4130 | 47 |
1850443 | 1850443 | 2021-10-25 | Carlton | Minnesota | 27017 | 4493 | 66 |
1850444 | 1850444 | 2021-10-25 | Carver | Minnesota | 27019 | 13724 | 56 |
1850445 | 1850445 | 2021-10-25 | Cass | Minnesota | 27021 | 4264 | 46 |
1850446 | 1850446 | 2021-10-25 | Chippewa | Minnesota | 27023 | 1914 | 40 |
1850447 | 1850447 | 2021-10-25 | Chisago | Minnesota | 27025 | 8413 | 63 |
1850448 | 1850448 | 2021-10-25 | Clay | Minnesota | 27027 | 10275 | 99 |
1850449 | 1850449 | 2021-10-25 | Clearwater | Minnesota | 27029 | 1367 | 18 |
1850450 | 1850450 | 2021-10-25 | Cook | Minnesota | 27031 | 245 | 0 |
1850451 | 1850451 | 2021-10-25 | Cottonwood | Minnesota | 27033 | 1973 | 29 |
1850452 | 1850452 | 2021-10-25 | Crow Wing | Minnesota | 27035 | 9565 | 109 |
1850453 | 1850453 | 2021-10-25 | Dakota | Minnesota | 27037 | 57266 | 526 |
1850454 | 1850454 | 2021-10-25 | Dodge | Minnesota | 27039 | 2742 | 10 |
1850455 | 1850455 | 2021-10-25 | Douglas | Minnesota | 27041 | 6352 | 90 |
1850456 | 1850456 | 2021-10-25 | Faribault | Minnesota | 27043 | 2215 | 30 |
1850457 | 1850457 | 2021-10-25 | Fillmore | Minnesota | 27045 | 2461 | 13 |
1850458 | 1850458 | 2021-10-25 | Freeborn | Minnesota | 27047 | 4888 | 42 |
1850459 | 1850459 | 2021-10-25 | Goodhue | Minnesota | 27049 | 6221 | 85 |
1850460 | 1850460 | 2021-10-25 | Grant | Minnesota | 27051 | 794 | 9 |
1850461 | 1850461 | 2021-10-25 | Hennepin | Minnesota | 27053 | 154134 | 1929 |
1850462 | 1850462 | 2021-10-25 | Houston | Minnesota | 27055 | 2325 | 17 |
1850463 | 1850463 | 2021-10-25 | Hubbard | Minnesota | 27057 | 2937 | 44 |
1850464 | 1850464 | 2021-10-25 | Isanti | Minnesota | 27059 | 5758 | 74 |
1850465 | 1850465 | 2021-10-25 | Itasca | Minnesota | 27061 | 6238 | 86 |
1850466 | 1850466 | 2021-10-25 | Jackson | Minnesota | 27063 | 1475 | 15 |
1850467 | 1850467 | 2021-10-25 | Kanabec | Minnesota | 27065 | 1928 | 30 |
1850468 | 1850468 | 2021-10-25 | Kandiyohi | Minnesota | 27067 | 8414 | 97 |
1850469 | 1850469 | 2021-10-25 | Kittson | Minnesota | 27069 | 614 | 22 |
1850470 | 1850470 | 2021-10-25 | Koochiching | Minnesota | 27071 | 1391 | 19 |
1850471 | 1850471 | 2021-10-25 | Lac qui Parle | Minnesota | 27073 | 996 | 24 |
1850472 | 1850472 | 2021-10-25 | Lake | Minnesota | 27075 | 1100 | 21 |
1850473 | 1850473 | 2021-10-25 | Lake of the Woods | Minnesota | 27077 | 477 | 4 |
1850474 | 1850474 | 2021-10-25 | Le Sueur | Minnesota | 27079 | 3873 | 32 |
1850475 | 1850475 | 2021-10-25 | Lincoln | Minnesota | 27081 | 786 | 5 |
1850476 | 1850476 | 2021-10-25 | Lyon | Minnesota | 27083 | 4582 | 56 |
1850477 | 1850477 | 2021-10-25 | Mahnomen | Minnesota | 27087 | 912 | 12 |
1850478 | 1850478 | 2021-10-25 | Marshall | Minnesota | 27089 | 1346 | 20 |
1850479 | 1850479 | 2021-10-25 | Martin | Minnesota | 27091 | 3272 | 36 |
1850480 | 1850480 | 2021-10-25 | McLeod | Minnesota | 27085 | 5986 | 70 |
1850481 | 1850481 | 2021-10-25 | Meeker | Minnesota | 27093 | 3603 | 54 |
1850482 | 1850482 | 2021-10-25 | Mille Lacs | Minnesota | 27095 | 4195 | 67 |
1850483 | 1850483 | 2021-10-25 | Morrison | Minnesota | 27097 | 5650 | 68 |
1850484 | 1850484 | 2021-10-25 | Mower | Minnesota | 27099 | 6475 | 41 |
1850485 | 1850485 | 2021-10-25 | Murray | Minnesota | 27101 | 1356 | 11 |
1850486 | 1850486 | 2021-10-25 | Nicollet | Minnesota | 27103 | 4354 | 54 |
1850487 | 1850487 | 2021-10-25 | Nobles | Minnesota | 27105 | 4830 | 52 |
1850488 | 1850488 | 2021-10-25 | Norman | Minnesota | 27107 | 884 | 9 |
1850489 | 1850489 | 2021-10-25 | Olmsted | Minnesota | 27109 | 18209 | 120 |
1850490 | 1850490 | 2021-10-25 | Otter Tail | Minnesota | 27111 | 8119 | 106 |
1850491 | 1850491 | 2021-10-25 | Pennington | Minnesota | 27113 | 2175 | 27 |
1850492 | 1850492 | 2021-10-25 | Pine | Minnesota | 27115 | 4306 | 32 |
1850493 | 1850493 | 2021-10-25 | Pipestone | Minnesota | 27117 | 1334 | 27 |
1850494 | 1850494 | 2021-10-25 | Polk | Minnesota | 27119 | 5150 | 80 |
1850495 | 1850495 | 2021-10-25 | Pope | Minnesota | 27121 | 1619 | 8 |
1850496 | 1850496 | 2021-10-25 | Ramsey | Minnesota | 27123 | 63557 | 983 |
1850497 | 1850497 | 2021-10-25 | Red Lake | Minnesota | 27125 | 591 | 9 |
1850498 | 1850498 | 2021-10-25 | Redwood | Minnesota | 27127 | 2408 | 43 |
1850499 | 1850499 | 2021-10-25 | Renville | Minnesota | 27129 | 2288 | 49 |
1850500 | 1850500 | 2021-10-25 | Rice | Minnesota | 27131 | 10005 | 131 |
1850501 | 1850501 | 2021-10-25 | Rock | Minnesota | 27133 | 1558 | 19 |
1850502 | 1850502 | 2021-10-25 | Roseau | Minnesota | 27135 | 2653 | 27 |
1850503 | 1850503 | 2021-10-25 | Scott | Minnesota | 27139 | 21689 | 160 |
1850504 | 1850504 | 2021-10-25 | Sherburne | Minnesota | 27141 | 15601 | 115 |
1850505 | 1850505 | 2021-10-25 | Sibley | Minnesota | 27143 | 2128 | 12 |
1850506 | 1850506 | 2021-10-25 | St. Louis | Minnesota | 27137 | 23879 | 362 |
1850507 | 1850507 | 2021-10-25 | Stearns | Minnesota | 27145 | 28657 | 254 |
1850508 | 1850508 | 2021-10-25 | Steele | Minnesota | 27147 | 5882 | 25 |
1850509 | 1850509 | 2021-10-25 | Stevens | Minnesota | 27149 | 1265 | 11 |
1850510 | 1850510 | 2021-10-25 | Swift | Minnesota | 27151 | 1354 | 19 |
1850511 | 1850511 | 2021-10-25 | Todd | Minnesota | 27153 | 4053 | 36 |
1850512 | 1850512 | 2021-10-25 | Traverse | Minnesota | 27155 | 517 | 5 |
1850513 | 1850513 | 2021-10-25 | Unknown | Minnesota | 659 | 124 | |
1850514 | 1850514 | 2021-10-25 | Wabasha | Minnesota | 27157 | 2983 | 8 |
1850515 | 1850515 | 2021-10-25 | Wadena | Minnesota | 27159 | 2413 | 29 |
1850516 | 1850516 | 2021-10-25 | Waseca | Minnesota | 27161 | 3286 | 31 |
1850517 | 1850517 | 2021-10-25 | Washington | Minnesota | 27163 | 33796 | 332 |
1850518 | 1850518 | 2021-10-25 | Watonwan | Minnesota | 27165 | 1716 | 12 |
1850519 | 1850519 | 2021-10-25 | Wilkin | Minnesota | 27167 | 1032 | 14 |
1850520 | 1850520 | 2021-10-25 | Winona | Minnesota | 27169 | 6142 | 54 |
1850521 | 1850521 | 2021-10-25 | Wright | Minnesota | 27171 | 21464 | 171 |
1850522 | 1850522 | 2021-10-25 | Yellow Medicine | Minnesota | 27173 | 1584 | 20 |
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);