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-13 and state = "Minnesota" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
429107 | 429107 | 2020-08-13 | Aitkin | Minnesota | 27001 | 41 | 1 |
429108 | 429108 | 2020-08-13 | Anoka | Minnesota | 27003 | 3841 | 115 |
429109 | 429109 | 2020-08-13 | Becker | Minnesota | 27005 | 162 | 1 |
429110 | 429110 | 2020-08-13 | Beltrami | Minnesota | 27007 | 264 | 0 |
429111 | 429111 | 2020-08-13 | Benton | Minnesota | 27009 | 325 | 3 |
429112 | 429112 | 2020-08-13 | Big Stone | Minnesota | 27011 | 25 | 0 |
429113 | 429113 | 2020-08-13 | Blue Earth | Minnesota | 27013 | 946 | 5 |
429114 | 429114 | 2020-08-13 | Brown | Minnesota | 27015 | 92 | 2 |
429115 | 429115 | 2020-08-13 | Carlton | Minnesota | 27017 | 147 | 0 |
429116 | 429116 | 2020-08-13 | Carver | Minnesota | 27019 | 899 | 3 |
429117 | 429117 | 2020-08-13 | Cass | Minnesota | 27021 | 80 | 2 |
429118 | 429118 | 2020-08-13 | Chippewa | Minnesota | 27023 | 117 | 1 |
429119 | 429119 | 2020-08-13 | Chisago | Minnesota | 27025 | 209 | 1 |
429120 | 429120 | 2020-08-13 | Clay | Minnesota | 27027 | 794 | 40 |
429121 | 429121 | 2020-08-13 | Clearwater | Minnesota | 27029 | 14 | 0 |
429122 | 429122 | 2020-08-13 | Cook | Minnesota | 27031 | 5 | 0 |
429123 | 429123 | 2020-08-13 | Cottonwood | Minnesota | 27033 | 178 | 0 |
429124 | 429124 | 2020-08-13 | Crow Wing | Minnesota | 27035 | 252 | 14 |
429125 | 429125 | 2020-08-13 | Dakota | Minnesota | 27037 | 4610 | 106 |
429126 | 429126 | 2020-08-13 | Dodge | Minnesota | 27039 | 131 | 0 |
429127 | 429127 | 2020-08-13 | Douglas | Minnesota | 27041 | 144 | 2 |
429128 | 429128 | 2020-08-13 | Faribault | Minnesota | 27043 | 92 | 0 |
429129 | 429129 | 2020-08-13 | Fillmore | Minnesota | 27045 | 72 | 0 |
429130 | 429130 | 2020-08-13 | Freeborn | Minnesota | 27047 | 361 | 1 |
429131 | 429131 | 2020-08-13 | Goodhue | Minnesota | 27049 | 205 | 9 |
429132 | 429132 | 2020-08-13 | Grant | Minnesota | 27051 | 56 | 3 |
429133 | 429133 | 2020-08-13 | Hennepin | Minnesota | 27053 | 19873 | 842 |
429134 | 429134 | 2020-08-13 | Houston | Minnesota | 27055 | 45 | 0 |
429135 | 429135 | 2020-08-13 | Hubbard | Minnesota | 27057 | 36 | 0 |
429136 | 429136 | 2020-08-13 | Isanti | Minnesota | 27059 | 137 | 0 |
429137 | 429137 | 2020-08-13 | Itasca | Minnesota | 27061 | 146 | 12 |
429138 | 429138 | 2020-08-13 | Jackson | Minnesota | 27063 | 79 | 0 |
429139 | 429139 | 2020-08-13 | Kanabec | Minnesota | 27065 | 37 | 2 |
429140 | 429140 | 2020-08-13 | Kandiyohi | Minnesota | 27067 | 714 | 1 |
429141 | 429141 | 2020-08-13 | Kittson | Minnesota | 27069 | 3 | 0 |
429142 | 429142 | 2020-08-13 | Koochiching | Minnesota | 27071 | 83 | 3 |
429143 | 429143 | 2020-08-13 | Lac qui Parle | Minnesota | 27073 | 8 | 0 |
429144 | 429144 | 2020-08-13 | Lake | Minnesota | 27075 | 22 | 0 |
429145 | 429145 | 2020-08-13 | Lake of the Woods | Minnesota | 27077 | 4 | 0 |
429146 | 429146 | 2020-08-13 | Le Sueur | Minnesota | 27079 | 230 | 1 |
429147 | 429147 | 2020-08-13 | Lincoln | Minnesota | 27081 | 61 | 0 |
429148 | 429148 | 2020-08-13 | Lyon | Minnesota | 27083 | 426 | 3 |
429149 | 429149 | 2020-08-13 | Mahnomen | Minnesota | 27087 | 27 | 1 |
429150 | 429150 | 2020-08-13 | Marshall | Minnesota | 27089 | 29 | 0 |
429151 | 429151 | 2020-08-13 | Martin | Minnesota | 27091 | 210 | 5 |
429152 | 429152 | 2020-08-13 | McLeod | Minnesota | 27085 | 224 | 0 |
429153 | 429153 | 2020-08-13 | Meeker | Minnesota | 27093 | 87 | 2 |
429154 | 429154 | 2020-08-13 | Mille Lacs | Minnesota | 27095 | 73 | 3 |
429155 | 429155 | 2020-08-13 | Morrison | Minnesota | 27097 | 94 | 1 |
429156 | 429156 | 2020-08-13 | Mower | Minnesota | 27099 | 1111 | 2 |
429157 | 429157 | 2020-08-13 | Murray | Minnesota | 27101 | 125 | 1 |
429158 | 429158 | 2020-08-13 | Nicollet | Minnesota | 27103 | 356 | 13 |
429159 | 429159 | 2020-08-13 | Nobles | Minnesota | 27105 | 1777 | 7 |
429160 | 429160 | 2020-08-13 | Norman | Minnesota | 27107 | 40 | 0 |
429161 | 429161 | 2020-08-13 | Olmsted | Minnesota | 27109 | 1791 | 23 |
429162 | 429162 | 2020-08-13 | Otter Tail | Minnesota | 27111 | 204 | 4 |
429163 | 429163 | 2020-08-13 | Pennington | Minnesota | 27113 | 75 | 1 |
429164 | 429164 | 2020-08-13 | Pine | Minnesota | 27115 | 129 | 0 |
429165 | 429165 | 2020-08-13 | Pipestone | Minnesota | 27117 | 158 | 9 |
429166 | 429166 | 2020-08-13 | Polk | Minnesota | 27119 | 156 | 4 |
429167 | 429167 | 2020-08-13 | Pope | Minnesota | 27121 | 48 | 0 |
429168 | 429168 | 2020-08-13 | Ramsey | Minnesota | 27123 | 7827 | 270 |
429169 | 429169 | 2020-08-13 | Red Lake | Minnesota | 27125 | 24 | 0 |
429170 | 429170 | 2020-08-13 | Redwood | Minnesota | 27127 | 37 | 0 |
429171 | 429171 | 2020-08-13 | Renville | Minnesota | 27129 | 67 | 5 |
429172 | 429172 | 2020-08-13 | Rice | Minnesota | 27131 | 1046 | 8 |
429173 | 429173 | 2020-08-13 | Rock | Minnesota | 27133 | 86 | 0 |
429174 | 429174 | 2020-08-13 | Roseau | Minnesota | 27135 | 53 | 0 |
429175 | 429175 | 2020-08-13 | Scott | Minnesota | 27139 | 1634 | 22 |
429176 | 429176 | 2020-08-13 | Sherburne | Minnesota | 27141 | 753 | 10 |
429177 | 429177 | 2020-08-13 | Sibley | Minnesota | 27143 | 86 | 2 |
429178 | 429178 | 2020-08-13 | St. Louis | Minnesota | 27137 | 621 | 20 |
429179 | 429179 | 2020-08-13 | Stearns | Minnesota | 27145 | 2928 | 20 |
429180 | 429180 | 2020-08-13 | Steele | Minnesota | 27147 | 356 | 2 |
429181 | 429181 | 2020-08-13 | Stevens | Minnesota | 27149 | 18 | 0 |
429182 | 429182 | 2020-08-13 | Swift | Minnesota | 27151 | 56 | 1 |
429183 | 429183 | 2020-08-13 | Todd | Minnesota | 27153 | 430 | 2 |
429184 | 429184 | 2020-08-13 | Traverse | Minnesota | 27155 | 13 | 0 |
429185 | 429185 | 2020-08-13 | Unknown | Minnesota | 181 | 46 | |
429186 | 429186 | 2020-08-13 | Wabasha | Minnesota | 27157 | 93 | 0 |
429187 | 429187 | 2020-08-13 | Wadena | Minnesota | 27159 | 28 | 0 |
429188 | 429188 | 2020-08-13 | Waseca | Minnesota | 27161 | 156 | 1 |
429189 | 429189 | 2020-08-13 | Washington | Minnesota | 27163 | 2227 | 48 |
429190 | 429190 | 2020-08-13 | Watonwan | Minnesota | 27165 | 367 | 1 |
429191 | 429191 | 2020-08-13 | Wilkin | Minnesota | 27167 | 35 | 3 |
429192 | 429192 | 2020-08-13 | Winona | Minnesota | 27169 | 266 | 16 |
429193 | 429193 | 2020-08-13 | Wright | Minnesota | 27171 | 918 | 5 |
429194 | 429194 | 2020-08-13 | Yellow Medicine | Minnesota | 27173 | 53 | 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);