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-01-19 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
944480 | 944480 | 2021-01-19 | Aitkin | Minnesota | 27001 | 1084 | 33 |
944481 | 944481 | 2021-01-19 | Anoka | Minnesota | 27003 | 30999 | 364 |
944482 | 944482 | 2021-01-19 | Becker | Minnesota | 27005 | 2849 | 39 |
944483 | 944483 | 2021-01-19 | Beltrami | Minnesota | 27007 | 3103 | 47 |
944484 | 944484 | 2021-01-19 | Benton | Minnesota | 27009 | 4201 | 86 |
944485 | 944485 | 2021-01-19 | Big Stone | Minnesota | 27011 | 457 | 3 |
944486 | 944486 | 2021-01-19 | Blue Earth | Minnesota | 27013 | 5410 | 33 |
944487 | 944487 | 2021-01-19 | Brown | Minnesota | 27015 | 2151 | 34 |
944488 | 944488 | 2021-01-19 | Carlton | Minnesota | 27017 | 2800 | 43 |
944489 | 944489 | 2021-01-19 | Carver | Minnesota | 27019 | 6948 | 36 |
944490 | 944490 | 2021-01-19 | Cass | Minnesota | 27021 | 2076 | 23 |
944491 | 944491 | 2021-01-19 | Chippewa | Minnesota | 27023 | 1313 | 32 |
944492 | 944492 | 2021-01-19 | Chisago | Minnesota | 27025 | 4527 | 32 |
944493 | 944493 | 2021-01-19 | Clay | Minnesota | 27027 | 6532 | 80 |
944494 | 944494 | 2021-01-19 | Clearwater | Minnesota | 27029 | 685 | 14 |
944495 | 944495 | 2021-01-19 | Cook | Minnesota | 27031 | 114 | 0 |
944496 | 944496 | 2021-01-19 | Cottonwood | Minnesota | 27033 | 1272 | 18 |
944497 | 944497 | 2021-01-19 | Crow Wing | Minnesota | 27035 | 4827 | 74 |
944498 | 944498 | 2021-01-19 | Dakota | Minnesota | 27037 | 33072 | 340 |
944499 | 944499 | 2021-01-19 | Dodge | Minnesota | 27039 | 1347 | 4 |
944500 | 944500 | 2021-01-19 | Douglas | Minnesota | 27041 | 3741 | 66 |
944501 | 944501 | 2021-01-19 | Faribault | Minnesota | 27043 | 1059 | 16 |
944502 | 944502 | 2021-01-19 | Fillmore | Minnesota | 27045 | 1235 | 5 |
944503 | 944503 | 2021-01-19 | Freeborn | Minnesota | 27047 | 2453 | 21 |
944504 | 944504 | 2021-01-19 | Goodhue | Minnesota | 27049 | 3479 | 58 |
944505 | 944505 | 2021-01-19 | Grant | Minnesota | 27051 | 429 | 8 |
944506 | 944506 | 2021-01-19 | Hennepin | Minnesota | 27053 | 93101 | 1480 |
944507 | 944507 | 2021-01-19 | Houston | Minnesota | 27055 | 1359 | 13 |
944508 | 944508 | 2021-01-19 | Hubbard | Minnesota | 27057 | 1493 | 38 |
944509 | 944509 | 2021-01-19 | Isanti | Minnesota | 27059 | 2828 | 41 |
944510 | 944510 | 2021-01-19 | Itasca | Minnesota | 27061 | 2845 | 43 |
944511 | 944511 | 2021-01-19 | Jackson | Minnesota | 27063 | 856 | 10 |
944512 | 944512 | 2021-01-19 | Kanabec | Minnesota | 27065 | 978 | 18 |
944513 | 944513 | 2021-01-19 | Kandiyohi | Minnesota | 27067 | 5543 | 71 |
944514 | 944514 | 2021-01-19 | Kittson | Minnesota | 27069 | 372 | 19 |
944515 | 944515 | 2021-01-19 | Koochiching | Minnesota | 27071 | 596 | 10 |
944516 | 944516 | 2021-01-19 | Lac qui Parle | Minnesota | 27073 | 657 | 16 |
944517 | 944517 | 2021-01-19 | Lake | Minnesota | 27075 | 637 | 15 |
944518 | 944518 | 2021-01-19 | Lake of the Woods | Minnesota | 27077 | 195 | 1 |
944519 | 944519 | 2021-01-19 | Le Sueur | Minnesota | 27079 | 2100 | 15 |
944520 | 944520 | 2021-01-19 | Lincoln | Minnesota | 27081 | 484 | 1 |
944521 | 944521 | 2021-01-19 | Lyon | Minnesota | 27083 | 3022 | 36 |
944522 | 944522 | 2021-01-19 | Mahnomen | Minnesota | 27087 | 410 | 7 |
944523 | 944523 | 2021-01-19 | Marshall | Minnesota | 27089 | 702 | 15 |
944524 | 944524 | 2021-01-19 | Martin | Minnesota | 27091 | 1700 | 26 |
944525 | 944525 | 2021-01-19 | McLeod | Minnesota | 27085 | 3253 | 45 |
944526 | 944526 | 2021-01-19 | Meeker | Minnesota | 27093 | 1997 | 33 |
944527 | 944527 | 2021-01-19 | Mille Lacs | Minnesota | 27095 | 2142 | 46 |
944528 | 944528 | 2021-01-19 | Morrison | Minnesota | 27097 | 3117 | 44 |
944529 | 944529 | 2021-01-19 | Mower | Minnesota | 27099 | 3655 | 29 |
944530 | 944530 | 2021-01-19 | Murray | Minnesota | 27101 | 881 | 5 |
944531 | 944531 | 2021-01-19 | Nicollet | Minnesota | 27103 | 2246 | 36 |
944532 | 944532 | 2021-01-19 | Nobles | Minnesota | 27105 | 3708 | 46 |
944533 | 944533 | 2021-01-19 | Norman | Minnesota | 27107 | 424 | 8 |
944534 | 944534 | 2021-01-19 | Olmsted | Minnesota | 27109 | 10484 | 75 |
944535 | 944535 | 2021-01-19 | Otter Tail | Minnesota | 27111 | 4571 | 67 |
944536 | 944536 | 2021-01-19 | Pennington | Minnesota | 27113 | 992 | 15 |
944537 | 944537 | 2021-01-19 | Pine | Minnesota | 27115 | 2667 | 13 |
944538 | 944538 | 2021-01-19 | Pipestone | Minnesota | 27117 | 944 | 23 |
944539 | 944539 | 2021-01-19 | Polk | Minnesota | 27119 | 3286 | 58 |
944540 | 944540 | 2021-01-19 | Pope | Minnesota | 27121 | 738 | 5 |
944541 | 944541 | 2021-01-19 | Ramsey | Minnesota | 27123 | 40016 | 739 |
944542 | 944542 | 2021-01-19 | Red Lake | Minnesota | 27125 | 317 | 4 |
944543 | 944543 | 2021-01-19 | Redwood | Minnesota | 27127 | 1397 | 27 |
944544 | 944544 | 2021-01-19 | Renville | Minnesota | 27129 | 1375 | 39 |
944545 | 944545 | 2021-01-19 | Rice | Minnesota | 27131 | 6068 | 68 |
944546 | 944546 | 2021-01-19 | Rock | Minnesota | 27133 | 1102 | 12 |
944547 | 944547 | 2021-01-19 | Roseau | Minnesota | 27135 | 1654 | 16 |
944548 | 944548 | 2021-01-19 | Scott | Minnesota | 27139 | 11954 | 96 |
944549 | 944549 | 2021-01-19 | Sherburne | Minnesota | 27141 | 8213 | 65 |
944550 | 944550 | 2021-01-19 | Sibley | Minnesota | 27143 | 1085 | 7 |
944551 | 944551 | 2021-01-19 | St. Louis | Minnesota | 27137 | 13690 | 241 |
944552 | 944552 | 2021-01-19 | Stearns | Minnesota | 27145 | 17871 | 187 |
944553 | 944553 | 2021-01-19 | Steele | Minnesota | 27147 | 2737 | 9 |
944554 | 944554 | 2021-01-19 | Stevens | Minnesota | 27149 | 701 | 8 |
944555 | 944555 | 2021-01-19 | Swift | Minnesota | 27151 | 834 | 18 |
944556 | 944556 | 2021-01-19 | Todd | Minnesota | 27153 | 2317 | 30 |
944557 | 944557 | 2021-01-19 | Traverse | Minnesota | 27155 | 250 | 3 |
944558 | 944558 | 2021-01-19 | Unknown | Minnesota | 505 | 68 | |
944559 | 944559 | 2021-01-19 | Wabasha | Minnesota | 27157 | 1708 | 3 |
944560 | 944560 | 2021-01-19 | Wadena | Minnesota | 27159 | 1201 | 16 |
944561 | 944561 | 2021-01-19 | Waseca | Minnesota | 27161 | 1893 | 16 |
944562 | 944562 | 2021-01-19 | Washington | Minnesota | 27163 | 20164 | 228 |
944563 | 944563 | 2021-01-19 | Watonwan | Minnesota | 27165 | 1066 | 8 |
944564 | 944564 | 2021-01-19 | Wilkin | Minnesota | 27167 | 625 | 9 |
944565 | 944565 | 2021-01-19 | Winona | Minnesota | 27169 | 3896 | 46 |
944566 | 944566 | 2021-01-19 | Wright | Minnesota | 27171 | 11614 | 104 |
944567 | 944567 | 2021-01-19 | Yellow Medicine | Minnesota | 27173 | 937 | 14 |
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);