ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where date = "2020-10-30" 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 |
---|---|---|---|---|---|---|---|
681634 | 681634 | 2020-10-30 | Aitkin | Minnesota | 27001 | 214 | 2 |
681635 | 681635 | 2020-10-30 | Anoka | Minnesota | 27003 | 9573 | 156 |
681636 | 681636 | 2020-10-30 | Becker | Minnesota | 27005 | 665 | 4 |
681637 | 681637 | 2020-10-30 | Beltrami | Minnesota | 27007 | 983 | 9 |
681638 | 681638 | 2020-10-30 | Benton | Minnesota | 27009 | 1090 | 12 |
681639 | 681639 | 2020-10-30 | Big Stone | Minnesota | 27011 | 167 | 1 |
681640 | 681640 | 2020-10-30 | Blue Earth | Minnesota | 27013 | 2136 | 7 |
681641 | 681641 | 2020-10-30 | Brown | Minnesota | 27015 | 365 | 3 |
681642 | 681642 | 2020-10-30 | Carlton | Minnesota | 27017 | 537 | 2 |
681643 | 681643 | 2020-10-30 | Carver | Minnesota | 27019 | 1916 | 7 |
681644 | 681644 | 2020-10-30 | Cass | Minnesota | 27021 | 438 | 5 |
681645 | 681645 | 2020-10-30 | Chippewa | Minnesota | 27023 | 489 | 3 |
681646 | 681646 | 2020-10-30 | Chisago | Minnesota | 27025 | 1191 | 2 |
681647 | 681647 | 2020-10-30 | Clay | Minnesota | 27027 | 2591 | 45 |
681648 | 681648 | 2020-10-30 | Clearwater | Minnesota | 27029 | 143 | 1 |
681649 | 681649 | 2020-10-30 | Cook | Minnesota | 27031 | 20 | 0 |
681650 | 681650 | 2020-10-30 | Cottonwood | Minnesota | 27033 | 299 | 0 |
681651 | 681651 | 2020-10-30 | Crow Wing | Minnesota | 27035 | 1208 | 22 |
681652 | 681652 | 2020-10-30 | Dakota | Minnesota | 27037 | 10420 | 139 |
681653 | 681653 | 2020-10-30 | Dodge | Minnesota | 27039 | 420 | 0 |
681654 | 681654 | 2020-10-30 | Douglas | Minnesota | 27041 | 804 | 4 |
681655 | 681655 | 2020-10-30 | Faribault | Minnesota | 27043 | 258 | 0 |
681656 | 681656 | 2020-10-30 | Fillmore | Minnesota | 27045 | 284 | 0 |
681657 | 681657 | 2020-10-30 | Freeborn | Minnesota | 27047 | 727 | 5 |
681658 | 681658 | 2020-10-30 | Goodhue | Minnesota | 27049 | 682 | 11 |
681659 | 681659 | 2020-10-30 | Grant | Minnesota | 27051 | 109 | 4 |
681660 | 681660 | 2020-10-30 | Hennepin | Minnesota | 27053 | 36126 | 997 |
681661 | 681661 | 2020-10-30 | Houston | Minnesota | 27055 | 249 | 2 |
681662 | 681662 | 2020-10-30 | Hubbard | Minnesota | 27057 | 469 | 5 |
681663 | 681663 | 2020-10-30 | Isanti | Minnesota | 27059 | 619 | 6 |
681664 | 681664 | 2020-10-30 | Itasca | Minnesota | 27061 | 806 | 17 |
681665 | 681665 | 2020-10-30 | Jackson | Minnesota | 27063 | 226 | 1 |
681666 | 681666 | 2020-10-30 | Kanabec | Minnesota | 27065 | 236 | 10 |
681667 | 681667 | 2020-10-30 | Kandiyohi | Minnesota | 27067 | 1869 | 5 |
681668 | 681668 | 2020-10-30 | Kittson | Minnesota | 27069 | 54 | 0 |
681669 | 681669 | 2020-10-30 | Koochiching | Minnesota | 27071 | 177 | 5 |
681670 | 681670 | 2020-10-30 | Lac qui Parle | Minnesota | 27073 | 147 | 3 |
681671 | 681671 | 2020-10-30 | Lake | Minnesota | 27075 | 139 | 0 |
681672 | 681672 | 2020-10-30 | Lake of the Woods | Minnesota | 27077 | 47 | 1 |
681673 | 681673 | 2020-10-30 | Le Sueur | Minnesota | 27079 | 671 | 6 |
681674 | 681674 | 2020-10-30 | Lincoln | Minnesota | 27081 | 197 | 0 |
681675 | 681675 | 2020-10-30 | Lyon | Minnesota | 27083 | 1044 | 6 |
681676 | 681676 | 2020-10-30 | Mahnomen | Minnesota | 27087 | 134 | 2 |
681677 | 681677 | 2020-10-30 | Marshall | Minnesota | 27089 | 161 | 1 |
681678 | 681678 | 2020-10-30 | Martin | Minnesota | 27091 | 637 | 18 |
681679 | 681679 | 2020-10-30 | McLeod | Minnesota | 27085 | 629 | 4 |
681680 | 681680 | 2020-10-30 | Meeker | Minnesota | 27093 | 370 | 3 |
681681 | 681681 | 2020-10-30 | Mille Lacs | Minnesota | 27095 | 471 | 18 |
681682 | 681682 | 2020-10-30 | Morrison | Minnesota | 27097 | 852 | 9 |
681683 | 681683 | 2020-10-30 | Mower | Minnesota | 27099 | 1553 | 18 |
681684 | 681684 | 2020-10-30 | Murray | Minnesota | 27101 | 302 | 3 |
681685 | 681685 | 2020-10-30 | Nicollet | Minnesota | 27103 | 783 | 18 |
681686 | 681686 | 2020-10-30 | Nobles | Minnesota | 27105 | 2368 | 18 |
681687 | 681687 | 2020-10-30 | Norman | Minnesota | 27107 | 141 | 0 |
681688 | 681688 | 2020-10-30 | Olmsted | Minnesota | 27109 | 3449 | 30 |
681689 | 681689 | 2020-10-30 | Otter Tail | Minnesota | 27111 | 980 | 8 |
681690 | 681690 | 2020-10-30 | Pennington | Minnesota | 27113 | 222 | 1 |
681691 | 681691 | 2020-10-30 | Pine | Minnesota | 27115 | 596 | 0 |
681692 | 681692 | 2020-10-30 | Pipestone | Minnesota | 27117 | 372 | 17 |
681693 | 681693 | 2020-10-30 | Polk | Minnesota | 27119 | 884 | 5 |
681694 | 681694 | 2020-10-30 | Pope | Minnesota | 27121 | 174 | 0 |
681695 | 681695 | 2020-10-30 | Ramsey | Minnesota | 27123 | 14966 | 377 |
681696 | 681696 | 2020-10-30 | Red Lake | Minnesota | 27125 | 84 | 2 |
681697 | 681697 | 2020-10-30 | Redwood | Minnesota | 27127 | 310 | 12 |
681698 | 681698 | 2020-10-30 | Renville | Minnesota | 27129 | 286 | 13 |
681699 | 681699 | 2020-10-30 | Rice | Minnesota | 27131 | 1742 | 10 |
681700 | 681700 | 2020-10-30 | Rock | Minnesota | 27133 | 366 | 5 |
681701 | 681701 | 2020-10-30 | Roseau | Minnesota | 27135 | 365 | 0 |
681702 | 681702 | 2020-10-30 | Scott | Minnesota | 27139 | 3666 | 36 |
681703 | 681703 | 2020-10-30 | Sherburne | Minnesota | 27141 | 1899 | 24 |
681704 | 681704 | 2020-10-30 | Sibley | Minnesota | 27143 | 273 | 3 |
681705 | 681705 | 2020-10-30 | St. Louis | Minnesota | 27137 | 3330 | 74 |
681706 | 681706 | 2020-10-30 | Stearns | Minnesota | 27145 | 6478 | 50 |
681707 | 681707 | 2020-10-30 | Steele | Minnesota | 27147 | 817 | 3 |
681708 | 681708 | 2020-10-30 | Stevens | Minnesota | 27149 | 200 | 1 |
681709 | 681709 | 2020-10-30 | Swift | Minnesota | 27151 | 232 | 2 |
681710 | 681710 | 2020-10-30 | Todd | Minnesota | 27153 | 933 | 7 |
681711 | 681711 | 2020-10-30 | Traverse | Minnesota | 27155 | 61 | 0 |
681712 | 681712 | 2020-10-30 | Unknown | Minnesota | 257 | 54 | |
681713 | 681713 | 2020-10-30 | Wabasha | Minnesota | 27157 | 428 | 1 |
681714 | 681714 | 2020-10-30 | Wadena | Minnesota | 27159 | 274 | 3 |
681715 | 681715 | 2020-10-30 | Waseca | Minnesota | 27161 | 950 | 10 |
681716 | 681716 | 2020-10-30 | Washington | Minnesota | 27163 | 6490 | 74 |
681717 | 681717 | 2020-10-30 | Watonwan | Minnesota | 27165 | 585 | 4 |
681718 | 681718 | 2020-10-30 | Wilkin | Minnesota | 27167 | 148 | 4 |
681719 | 681719 | 2020-10-30 | Winona | Minnesota | 27169 | 1362 | 19 |
681720 | 681720 | 2020-10-30 | Wright | Minnesota | 27171 | 2825 | 16 |
681721 | 681721 | 2020-10-30 | Yellow Medicine | Minnesota | 27173 | 309 | 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);