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 2020-08-20 and state = "Minnesota" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
451692 | 451692 | 2020-08-20 | Aitkin | Minnesota | 27001 | 44 | 1 |
451693 | 451693 | 2020-08-20 | Anoka | Minnesota | 27003 | 4177 | 116 |
451694 | 451694 | 2020-08-20 | Becker | Minnesota | 27005 | 170 | 1 |
451695 | 451695 | 2020-08-20 | Beltrami | Minnesota | 27007 | 286 | 1 |
451696 | 451696 | 2020-08-20 | Benton | Minnesota | 27009 | 342 | 3 |
451697 | 451697 | 2020-08-20 | Big Stone | Minnesota | 27011 | 29 | 0 |
451698 | 451698 | 2020-08-20 | Blue Earth | Minnesota | 27013 | 1018 | 5 |
451699 | 451699 | 2020-08-20 | Brown | Minnesota | 27015 | 101 | 2 |
451700 | 451700 | 2020-08-20 | Carlton | Minnesota | 27017 | 162 | 1 |
451701 | 451701 | 2020-08-20 | Carver | Minnesota | 27019 | 991 | 4 |
451702 | 451702 | 2020-08-20 | Cass | Minnesota | 27021 | 86 | 3 |
451703 | 451703 | 2020-08-20 | Chippewa | Minnesota | 27023 | 126 | 1 |
451704 | 451704 | 2020-08-20 | Chisago | Minnesota | 27025 | 238 | 1 |
451705 | 451705 | 2020-08-20 | Clay | Minnesota | 27027 | 807 | 40 |
451706 | 451706 | 2020-08-20 | Clearwater | Minnesota | 27029 | 15 | 0 |
451707 | 451707 | 2020-08-20 | Cook | Minnesota | 27031 | 6 | 0 |
451708 | 451708 | 2020-08-20 | Cottonwood | Minnesota | 27033 | 193 | 0 |
451709 | 451709 | 2020-08-20 | Crow Wing | Minnesota | 27035 | 279 | 15 |
451710 | 451710 | 2020-08-20 | Dakota | Minnesota | 27037 | 5048 | 108 |
451711 | 451711 | 2020-08-20 | Dodge | Minnesota | 27039 | 143 | 0 |
451712 | 451712 | 2020-08-20 | Douglas | Minnesota | 27041 | 146 | 1 |
451713 | 451713 | 2020-08-20 | Faribault | Minnesota | 27043 | 99 | 0 |
451714 | 451714 | 2020-08-20 | Fillmore | Minnesota | 27045 | 78 | 0 |
451715 | 451715 | 2020-08-20 | Freeborn | Minnesota | 27047 | 377 | 1 |
451716 | 451716 | 2020-08-20 | Goodhue | Minnesota | 27049 | 232 | 9 |
451717 | 451717 | 2020-08-20 | Grant | Minnesota | 27051 | 55 | 4 |
451718 | 451718 | 2020-08-20 | Hennepin | Minnesota | 27053 | 21050 | 860 |
451719 | 451719 | 2020-08-20 | Houston | Minnesota | 27055 | 63 | 0 |
451720 | 451720 | 2020-08-20 | Hubbard | Minnesota | 27057 | 39 | 0 |
451721 | 451721 | 2020-08-20 | Isanti | Minnesota | 27059 | 156 | 0 |
451722 | 451722 | 2020-08-20 | Itasca | Minnesota | 27061 | 153 | 12 |
451723 | 451723 | 2020-08-20 | Jackson | Minnesota | 27063 | 87 | 0 |
451724 | 451724 | 2020-08-20 | Kanabec | Minnesota | 27065 | 48 | 4 |
451725 | 451725 | 2020-08-20 | Kandiyohi | Minnesota | 27067 | 753 | 1 |
451726 | 451726 | 2020-08-20 | Kittson | Minnesota | 27069 | 3 | 0 |
451727 | 451727 | 2020-08-20 | Koochiching | Minnesota | 27071 | 84 | 3 |
451728 | 451728 | 2020-08-20 | Lac qui Parle | Minnesota | 27073 | 10 | 0 |
451729 | 451729 | 2020-08-20 | Lake | Minnesota | 27075 | 25 | 0 |
451730 | 451730 | 2020-08-20 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
451731 | 451731 | 2020-08-20 | Le Sueur | Minnesota | 27079 | 285 | 2 |
451732 | 451732 | 2020-08-20 | Lincoln | Minnesota | 27081 | 62 | 0 |
451733 | 451733 | 2020-08-20 | Lyon | Minnesota | 27083 | 436 | 3 |
451734 | 451734 | 2020-08-20 | Mahnomen | Minnesota | 27087 | 31 | 1 |
451735 | 451735 | 2020-08-20 | Marshall | Minnesota | 27089 | 30 | 0 |
451736 | 451736 | 2020-08-20 | Martin | Minnesota | 27091 | 214 | 6 |
451737 | 451737 | 2020-08-20 | McLeod | Minnesota | 27085 | 282 | 1 |
451738 | 451738 | 2020-08-20 | Meeker | Minnesota | 27093 | 91 | 2 |
451739 | 451739 | 2020-08-20 | Mille Lacs | Minnesota | 27095 | 83 | 3 |
451740 | 451740 | 2020-08-20 | Morrison | Minnesota | 27097 | 104 | 1 |
451741 | 451741 | 2020-08-20 | Mower | Minnesota | 27099 | 1139 | 3 |
451742 | 451742 | 2020-08-20 | Murray | Minnesota | 27101 | 132 | 1 |
451743 | 451743 | 2020-08-20 | Nicollet | Minnesota | 27103 | 396 | 13 |
451744 | 451744 | 2020-08-20 | Nobles | Minnesota | 27105 | 1807 | 11 |
451745 | 451745 | 2020-08-20 | Norman | Minnesota | 27107 | 43 | 0 |
451746 | 451746 | 2020-08-20 | Olmsted | Minnesota | 27109 | 1877 | 24 |
451747 | 451747 | 2020-08-20 | Otter Tail | Minnesota | 27111 | 229 | 4 |
451748 | 451748 | 2020-08-20 | Pennington | Minnesota | 27113 | 74 | 1 |
451749 | 451749 | 2020-08-20 | Pine | Minnesota | 27115 | 132 | 0 |
451750 | 451750 | 2020-08-20 | Pipestone | Minnesota | 27117 | 166 | 9 |
451751 | 451751 | 2020-08-20 | Polk | Minnesota | 27119 | 171 | 4 |
451752 | 451752 | 2020-08-20 | Pope | Minnesota | 27121 | 55 | 0 |
451753 | 451753 | 2020-08-20 | Ramsey | Minnesota | 27123 | 8312 | 280 |
451754 | 451754 | 2020-08-20 | Red Lake | Minnesota | 27125 | 27 | 0 |
451755 | 451755 | 2020-08-20 | Redwood | Minnesota | 27127 | 40 | 0 |
451756 | 451756 | 2020-08-20 | Renville | Minnesota | 27129 | 69 | 5 |
451757 | 451757 | 2020-08-20 | Rice | Minnesota | 27131 | 1096 | 8 |
451758 | 451758 | 2020-08-20 | Rock | Minnesota | 27133 | 93 | 0 |
451759 | 451759 | 2020-08-20 | Roseau | Minnesota | 27135 | 58 | 0 |
451760 | 451760 | 2020-08-20 | Scott | Minnesota | 27139 | 1782 | 25 |
451761 | 451761 | 2020-08-20 | Sherburne | Minnesota | 27141 | 801 | 11 |
451762 | 451762 | 2020-08-20 | Sibley | Minnesota | 27143 | 99 | 2 |
451763 | 451763 | 2020-08-20 | St. Louis | Minnesota | 27137 | 707 | 21 |
451764 | 451764 | 2020-08-20 | Stearns | Minnesota | 27145 | 3019 | 21 |
451765 | 451765 | 2020-08-20 | Steele | Minnesota | 27147 | 378 | 2 |
451766 | 451766 | 2020-08-20 | Stevens | Minnesota | 27149 | 22 | 0 |
451767 | 451767 | 2020-08-20 | Swift | Minnesota | 27151 | 58 | 1 |
451768 | 451768 | 2020-08-20 | Todd | Minnesota | 27153 | 436 | 2 |
451769 | 451769 | 2020-08-20 | Traverse | Minnesota | 27155 | 19 | 0 |
451770 | 451770 | 2020-08-20 | Unknown | Minnesota | 166 | 46 | |
451771 | 451771 | 2020-08-20 | Wabasha | Minnesota | 27157 | 107 | 0 |
451772 | 451772 | 2020-08-20 | Wadena | Minnesota | 27159 | 31 | 0 |
451773 | 451773 | 2020-08-20 | Waseca | Minnesota | 27161 | 193 | 1 |
451774 | 451774 | 2020-08-20 | Washington | Minnesota | 27163 | 2478 | 51 |
451775 | 451775 | 2020-08-20 | Watonwan | Minnesota | 27165 | 395 | 3 |
451776 | 451776 | 2020-08-20 | Wilkin | Minnesota | 27167 | 41 | 3 |
451777 | 451777 | 2020-08-20 | Winona | Minnesota | 27169 | 286 | 17 |
451778 | 451778 | 2020-08-20 | Wright | Minnesota | 27171 | 1019 | 6 |
451779 | 451779 | 2020-08-20 | Yellow Medicine | Minnesota | 27173 | 57 | 0 |
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);