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-23 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
957463 | 957463 | 2021-01-23 | Aitkin | Minnesota | 27001 | 1112 | 33 |
957464 | 957464 | 2021-01-23 | Anoka | Minnesota | 27003 | 31283 | 368 |
957465 | 957465 | 2021-01-23 | Becker | Minnesota | 27005 | 2888 | 39 |
957466 | 957466 | 2021-01-23 | Beltrami | Minnesota | 27007 | 3150 | 48 |
957467 | 957467 | 2021-01-23 | Benton | Minnesota | 27009 | 4232 | 88 |
957468 | 957468 | 2021-01-23 | Big Stone | Minnesota | 27011 | 469 | 3 |
957469 | 957469 | 2021-01-23 | Blue Earth | Minnesota | 27013 | 5468 | 33 |
957470 | 957470 | 2021-01-23 | Brown | Minnesota | 27015 | 2174 | 34 |
957471 | 957471 | 2021-01-23 | Carlton | Minnesota | 27017 | 2835 | 43 |
957472 | 957472 | 2021-01-23 | Carver | Minnesota | 27019 | 7031 | 39 |
957473 | 957473 | 2021-01-23 | Cass | Minnesota | 27021 | 2105 | 24 |
957474 | 957474 | 2021-01-23 | Chippewa | Minnesota | 27023 | 1323 | 32 |
957475 | 957475 | 2021-01-23 | Chisago | Minnesota | 27025 | 4581 | 38 |
957476 | 957476 | 2021-01-23 | Clay | Minnesota | 27027 | 6576 | 84 |
957477 | 957477 | 2021-01-23 | Clearwater | Minnesota | 27029 | 687 | 14 |
957478 | 957478 | 2021-01-23 | Cook | Minnesota | 27031 | 115 | 0 |
957479 | 957479 | 2021-01-23 | Cottonwood | Minnesota | 27033 | 1289 | 18 |
957480 | 957480 | 2021-01-23 | Crow Wing | Minnesota | 27035 | 4891 | 78 |
957481 | 957481 | 2021-01-23 | Dakota | Minnesota | 27037 | 33463 | 350 |
957482 | 957482 | 2021-01-23 | Dodge | Minnesota | 27039 | 1386 | 4 |
957483 | 957483 | 2021-01-23 | Douglas | Minnesota | 27041 | 3784 | 66 |
957484 | 957484 | 2021-01-23 | Faribault | Minnesota | 27043 | 1088 | 16 |
957485 | 957485 | 2021-01-23 | Fillmore | Minnesota | 27045 | 1264 | 6 |
957486 | 957486 | 2021-01-23 | Freeborn | Minnesota | 27047 | 2536 | 23 |
957487 | 957487 | 2021-01-23 | Goodhue | Minnesota | 27049 | 3553 | 62 |
957488 | 957488 | 2021-01-23 | Grant | Minnesota | 27051 | 438 | 8 |
957489 | 957489 | 2021-01-23 | Hennepin | Minnesota | 27053 | 94138 | 1495 |
957490 | 957490 | 2021-01-23 | Houston | Minnesota | 27055 | 1398 | 14 |
957491 | 957491 | 2021-01-23 | Hubbard | Minnesota | 27057 | 1502 | 38 |
957492 | 957492 | 2021-01-23 | Isanti | Minnesota | 27059 | 2848 | 42 |
957493 | 957493 | 2021-01-23 | Itasca | Minnesota | 27061 | 2871 | 43 |
957494 | 957494 | 2021-01-23 | Jackson | Minnesota | 27063 | 873 | 10 |
957495 | 957495 | 2021-01-23 | Kanabec | Minnesota | 27065 | 993 | 18 |
957496 | 957496 | 2021-01-23 | Kandiyohi | Minnesota | 27067 | 5567 | 72 |
957497 | 957497 | 2021-01-23 | Kittson | Minnesota | 27069 | 373 | 20 |
957498 | 957498 | 2021-01-23 | Koochiching | Minnesota | 27071 | 603 | 10 |
957499 | 957499 | 2021-01-23 | Lac qui Parle | Minnesota | 27073 | 660 | 16 |
957500 | 957500 | 2021-01-23 | Lake | Minnesota | 27075 | 663 | 15 |
957501 | 957501 | 2021-01-23 | Lake of the Woods | Minnesota | 27077 | 196 | 1 |
957502 | 957502 | 2021-01-23 | Le Sueur | Minnesota | 27079 | 2135 | 16 |
957503 | 957503 | 2021-01-23 | Lincoln | Minnesota | 27081 | 489 | 2 |
957504 | 957504 | 2021-01-23 | Lyon | Minnesota | 27083 | 3047 | 38 |
957505 | 957505 | 2021-01-23 | Mahnomen | Minnesota | 27087 | 414 | 7 |
957506 | 957506 | 2021-01-23 | Marshall | Minnesota | 27089 | 703 | 15 |
957507 | 957507 | 2021-01-23 | Martin | Minnesota | 27091 | 1717 | 26 |
957508 | 957508 | 2021-01-23 | McLeod | Minnesota | 27085 | 3279 | 47 |
957509 | 957509 | 2021-01-23 | Meeker | Minnesota | 27093 | 2012 | 33 |
957510 | 957510 | 2021-01-23 | Mille Lacs | Minnesota | 27095 | 2150 | 45 |
957511 | 957511 | 2021-01-23 | Morrison | Minnesota | 27097 | 3141 | 45 |
957512 | 957512 | 2021-01-23 | Mower | Minnesota | 27099 | 3721 | 29 |
957513 | 957513 | 2021-01-23 | Murray | Minnesota | 27101 | 909 | 6 |
957514 | 957514 | 2021-01-23 | Nicollet | Minnesota | 27103 | 2279 | 38 |
957515 | 957515 | 2021-01-23 | Nobles | Minnesota | 27105 | 3744 | 47 |
957516 | 957516 | 2021-01-23 | Norman | Minnesota | 27107 | 425 | 8 |
957517 | 957517 | 2021-01-23 | Olmsted | Minnesota | 27109 | 10739 | 75 |
957518 | 957518 | 2021-01-23 | Otter Tail | Minnesota | 27111 | 4631 | 67 |
957519 | 957519 | 2021-01-23 | Pennington | Minnesota | 27113 | 1010 | 16 |
957520 | 957520 | 2021-01-23 | Pine | Minnesota | 27115 | 2696 | 14 |
957521 | 957521 | 2021-01-23 | Pipestone | Minnesota | 27117 | 964 | 23 |
957522 | 957522 | 2021-01-23 | Polk | Minnesota | 27119 | 3306 | 60 |
957523 | 957523 | 2021-01-23 | Pope | Minnesota | 27121 | 746 | 5 |
957524 | 957524 | 2021-01-23 | Ramsey | Minnesota | 27123 | 40509 | 748 |
957525 | 957525 | 2021-01-23 | Red Lake | Minnesota | 27125 | 320 | 4 |
957526 | 957526 | 2021-01-23 | Redwood | Minnesota | 27127 | 1410 | 27 |
957527 | 957527 | 2021-01-23 | Renville | Minnesota | 27129 | 1380 | 40 |
957528 | 957528 | 2021-01-23 | Rice | Minnesota | 27131 | 6211 | 70 |
957529 | 957529 | 2021-01-23 | Rock | Minnesota | 27133 | 1119 | 12 |
957530 | 957530 | 2021-01-23 | Roseau | Minnesota | 27135 | 1663 | 17 |
957531 | 957531 | 2021-01-23 | Scott | Minnesota | 27139 | 12130 | 98 |
957532 | 957532 | 2021-01-23 | Sherburne | Minnesota | 27141 | 8278 | 68 |
957533 | 957533 | 2021-01-23 | Sibley | Minnesota | 27143 | 1094 | 7 |
957534 | 957534 | 2021-01-23 | St. Louis | Minnesota | 27137 | 13916 | 247 |
957535 | 957535 | 2021-01-23 | Stearns | Minnesota | 27145 | 18051 | 190 |
957536 | 957536 | 2021-01-23 | Steele | Minnesota | 27147 | 2785 | 10 |
957537 | 957537 | 2021-01-23 | Stevens | Minnesota | 27149 | 707 | 8 |
957538 | 957538 | 2021-01-23 | Swift | Minnesota | 27151 | 844 | 18 |
957539 | 957539 | 2021-01-23 | Todd | Minnesota | 27153 | 2331 | 30 |
957540 | 957540 | 2021-01-23 | Traverse | Minnesota | 27155 | 261 | 3 |
957541 | 957541 | 2021-01-23 | Unknown | Minnesota | 513 | 68 | |
957542 | 957542 | 2021-01-23 | Wabasha | Minnesota | 27157 | 1741 | 3 |
957543 | 957543 | 2021-01-23 | Wadena | Minnesota | 27159 | 1202 | 18 |
957544 | 957544 | 2021-01-23 | Waseca | Minnesota | 27161 | 1928 | 16 |
957545 | 957545 | 2021-01-23 | Washington | Minnesota | 27163 | 20471 | 234 |
957546 | 957546 | 2021-01-23 | Watonwan | Minnesota | 27165 | 1068 | 8 |
957547 | 957547 | 2021-01-23 | Wilkin | Minnesota | 27167 | 634 | 9 |
957548 | 957548 | 2021-01-23 | Winona | Minnesota | 27169 | 3942 | 48 |
957549 | 957549 | 2021-01-23 | Wright | Minnesota | 27171 | 11756 | 107 |
957550 | 957550 | 2021-01-23 | Yellow Medicine | Minnesota | 27173 | 949 | 16 |
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);