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-09-07 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1694485 | 1694485 | 2021-09-07 | Aitkin | Minnesota | 27001 | 1503 | 38 |
1694486 | 1694486 | 2021-09-07 | Anoka | Minnesota | 27003 | 46461 | 473 |
1694487 | 1694487 | 2021-09-07 | Becker | Minnesota | 27005 | 4112 | 58 |
1694488 | 1694488 | 2021-09-07 | Beltrami | Minnesota | 27007 | 4687 | 69 |
1694489 | 1694489 | 2021-09-07 | Benton | Minnesota | 27009 | 6186 | 98 |
1694490 | 1694490 | 2021-09-07 | Big Stone | Minnesota | 27011 | 646 | 4 |
1694491 | 1694491 | 2021-09-07 | Blue Earth | Minnesota | 27013 | 8282 | 47 |
1694492 | 1694492 | 2021-09-07 | Brown | Minnesota | 27015 | 3331 | 42 |
1694493 | 1694493 | 2021-09-07 | Carlton | Minnesota | 27017 | 3779 | 59 |
1694494 | 1694494 | 2021-09-07 | Carver | Minnesota | 27019 | 11647 | 51 |
1694495 | 1694495 | 2021-09-07 | Cass | Minnesota | 27021 | 3196 | 34 |
1694496 | 1694496 | 2021-09-07 | Chippewa | Minnesota | 27023 | 1656 | 39 |
1694497 | 1694497 | 2021-09-07 | Chisago | Minnesota | 27025 | 6808 | 56 |
1694498 | 1694498 | 2021-09-07 | Clay | Minnesota | 27027 | 8740 | 92 |
1694499 | 1694499 | 2021-09-07 | Clearwater | Minnesota | 27029 | 968 | 18 |
1694500 | 1694500 | 2021-09-07 | Cook | Minnesota | 27031 | 199 | 0 |
1694501 | 1694501 | 2021-09-07 | Cottonwood | Minnesota | 27033 | 1740 | 24 |
1694502 | 1694502 | 2021-09-07 | Crow Wing | Minnesota | 27035 | 7457 | 100 |
1694503 | 1694503 | 2021-09-07 | Dakota | Minnesota | 27037 | 50485 | 489 |
1694504 | 1694504 | 2021-09-07 | Dodge | Minnesota | 27039 | 2273 | 3 |
1694505 | 1694505 | 2021-09-07 | Douglas | Minnesota | 27041 | 5146 | 83 |
1694506 | 1694506 | 2021-09-07 | Faribault | Minnesota | 27043 | 1699 | 22 |
1694507 | 1694507 | 2021-09-07 | Fillmore | Minnesota | 27045 | 1803 | 10 |
1694508 | 1694508 | 2021-09-07 | Freeborn | Minnesota | 27047 | 4049 | 37 |
1694509 | 1694509 | 2021-09-07 | Goodhue | Minnesota | 27049 | 5327 | 76 |
1694510 | 1694510 | 2021-09-07 | Grant | Minnesota | 27051 | 632 | 8 |
1694511 | 1694511 | 2021-09-07 | Hennepin | Minnesota | 27053 | 136379 | 1843 |
1694512 | 1694512 | 2021-09-07 | Houston | Minnesota | 27055 | 1941 | 16 |
1694513 | 1694513 | 2021-09-07 | Hubbard | Minnesota | 27057 | 2162 | 41 |
1694514 | 1694514 | 2021-09-07 | Isanti | Minnesota | 27059 | 4751 | 70 |
1694515 | 1694515 | 2021-09-07 | Itasca | Minnesota | 27061 | 4964 | 70 |
1694516 | 1694516 | 2021-09-07 | Jackson | Minnesota | 27063 | 1325 | 12 |
1694517 | 1694517 | 2021-09-07 | Kanabec | Minnesota | 27065 | 1589 | 29 |
1694518 | 1694518 | 2021-09-07 | Kandiyohi | Minnesota | 27067 | 7245 | 88 |
1694519 | 1694519 | 2021-09-07 | Kittson | Minnesota | 27069 | 513 | 22 |
1694520 | 1694520 | 2021-09-07 | Koochiching | Minnesota | 27071 | 1039 | 19 |
1694521 | 1694521 | 2021-09-07 | Lac qui Parle | Minnesota | 27073 | 814 | 22 |
1694522 | 1694522 | 2021-09-07 | Lake | Minnesota | 27075 | 888 | 21 |
1694523 | 1694523 | 2021-09-07 | Lake of the Woods | Minnesota | 27077 | 372 | 4 |
1694524 | 1694524 | 2021-09-07 | Le Sueur | Minnesota | 27079 | 3265 | 29 |
1694525 | 1694525 | 2021-09-07 | Lincoln | Minnesota | 27081 | 614 | 4 |
1694526 | 1694526 | 2021-09-07 | Lyon | Minnesota | 27083 | 3817 | 54 |
1694527 | 1694527 | 2021-09-07 | Mahnomen | Minnesota | 27087 | 628 | 9 |
1694528 | 1694528 | 2021-09-07 | Marshall | Minnesota | 27089 | 981 | 18 |
1694529 | 1694529 | 2021-09-07 | Martin | Minnesota | 27091 | 2513 | 33 |
1694530 | 1694530 | 2021-09-07 | McLeod | Minnesota | 27085 | 4746 | 61 |
1694531 | 1694531 | 2021-09-07 | Meeker | Minnesota | 27093 | 2927 | 46 |
1694532 | 1694532 | 2021-09-07 | Mille Lacs | Minnesota | 27095 | 3421 | 59 |
1694533 | 1694533 | 2021-09-07 | Morrison | Minnesota | 27097 | 4525 | 62 |
1694534 | 1694534 | 2021-09-07 | Mower | Minnesota | 27099 | 5319 | 34 |
1694535 | 1694535 | 2021-09-07 | Murray | Minnesota | 27101 | 1124 | 10 |
1694536 | 1694536 | 2021-09-07 | Nicollet | Minnesota | 27103 | 3583 | 47 |
1694537 | 1694537 | 2021-09-07 | Nobles | Minnesota | 27105 | 4364 | 50 |
1694538 | 1694538 | 2021-09-07 | Norman | Minnesota | 27107 | 604 | 9 |
1694539 | 1694539 | 2021-09-07 | Olmsted | Minnesota | 27109 | 15162 | 108 |
1694540 | 1694540 | 2021-09-07 | Otter Tail | Minnesota | 27111 | 6409 | 89 |
1694541 | 1694541 | 2021-09-07 | Pennington | Minnesota | 27113 | 1806 | 20 |
1694542 | 1694542 | 2021-09-07 | Pine | Minnesota | 27115 | 3630 | 23 |
1694543 | 1694543 | 2021-09-07 | Pipestone | Minnesota | 27117 | 1211 | 26 |
1694544 | 1694544 | 2021-09-07 | Polk | Minnesota | 27119 | 4150 | 75 |
1694545 | 1694545 | 2021-09-07 | Pope | Minnesota | 27121 | 1255 | 8 |
1694546 | 1694546 | 2021-09-07 | Ramsey | Minnesota | 27123 | 56935 | 932 |
1694547 | 1694547 | 2021-09-07 | Red Lake | Minnesota | 27125 | 452 | 7 |
1694548 | 1694548 | 2021-09-07 | Redwood | Minnesota | 27127 | 1900 | 41 |
1694549 | 1694549 | 2021-09-07 | Renville | Minnesota | 27129 | 1936 | 46 |
1694550 | 1694550 | 2021-09-07 | Rice | Minnesota | 27131 | 8818 | 116 |
1694551 | 1694551 | 2021-09-07 | Rock | Minnesota | 27133 | 1361 | 19 |
1694552 | 1694552 | 2021-09-07 | Roseau | Minnesota | 27135 | 2241 | 21 |
1694553 | 1694553 | 2021-09-07 | Scott | Minnesota | 27139 | 18942 | 141 |
1694554 | 1694554 | 2021-09-07 | Sherburne | Minnesota | 27141 | 12993 | 99 |
1694555 | 1694555 | 2021-09-07 | Sibley | Minnesota | 27143 | 1665 | 10 |
1694556 | 1694556 | 2021-09-07 | St. Louis | Minnesota | 27137 | 19432 | 328 |
1694557 | 1694557 | 2021-09-07 | Stearns | Minnesota | 27145 | 24075 | 234 |
1694558 | 1694558 | 2021-09-07 | Steele | Minnesota | 27147 | 4659 | 21 |
1694559 | 1694559 | 2021-09-07 | Stevens | Minnesota | 27149 | 994 | 11 |
1694560 | 1694560 | 2021-09-07 | Swift | Minnesota | 27151 | 1154 | 19 |
1694561 | 1694561 | 2021-09-07 | Todd | Minnesota | 27153 | 3089 | 34 |
1694562 | 1694562 | 2021-09-07 | Traverse | Minnesota | 27155 | 407 | 5 |
1694563 | 1694563 | 2021-09-07 | Unknown | Minnesota | 589 | 93 | |
1694564 | 1694564 | 2021-09-07 | Wabasha | Minnesota | 27157 | 2304 | 4 |
1694565 | 1694565 | 2021-09-07 | Wadena | Minnesota | 27159 | 1741 | 23 |
1694566 | 1694566 | 2021-09-07 | Waseca | Minnesota | 27161 | 2739 | 23 |
1694567 | 1694567 | 2021-09-07 | Washington | Minnesota | 27163 | 29690 | 306 |
1694568 | 1694568 | 2021-09-07 | Watonwan | Minnesota | 27165 | 1469 | 10 |
1694569 | 1694569 | 2021-09-07 | Wilkin | Minnesota | 27167 | 879 | 14 |
1694570 | 1694570 | 2021-09-07 | Winona | Minnesota | 27169 | 5272 | 52 |
1694571 | 1694571 | 2021-09-07 | Wright | Minnesota | 27171 | 17791 | 159 |
1694572 | 1694572 | 2021-09-07 | Yellow Medicine | Minnesota | 27173 | 1210 | 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);