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-09-17 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
542219 | 542219 | 2020-09-17 | Aitkin | Minnesota | 27001 | 69 | 1 |
542220 | 542220 | 2020-09-17 | Anoka | Minnesota | 27003 | 5531 | 131 |
542221 | 542221 | 2020-09-17 | Becker | Minnesota | 27005 | 235 | 2 |
542222 | 542222 | 2020-09-17 | Beltrami | Minnesota | 27007 | 362 | 4 |
542223 | 542223 | 2020-09-17 | Benton | Minnesota | 27009 | 479 | 3 |
542224 | 542224 | 2020-09-17 | Big Stone | Minnesota | 27011 | 64 | 0 |
542225 | 542225 | 2020-09-17 | Blue Earth | Minnesota | 27013 | 1540 | 6 |
542226 | 542226 | 2020-09-17 | Brown | Minnesota | 27015 | 158 | 2 |
542227 | 542227 | 2020-09-17 | Carlton | Minnesota | 27017 | 226 | 1 |
542228 | 542228 | 2020-09-17 | Carver | Minnesota | 27019 | 1303 | 7 |
542229 | 542229 | 2020-09-17 | Cass | Minnesota | 27021 | 120 | 3 |
542230 | 542230 | 2020-09-17 | Chippewa | Minnesota | 27023 | 182 | 1 |
542231 | 542231 | 2020-09-17 | Chisago | Minnesota | 27025 | 415 | 1 |
542232 | 542232 | 2020-09-17 | Clay | Minnesota | 27027 | 1199 | 40 |
542233 | 542233 | 2020-09-17 | Clearwater | Minnesota | 27029 | 24 | 0 |
542234 | 542234 | 2020-09-17 | Cook | Minnesota | 27031 | 6 | 0 |
542235 | 542235 | 2020-09-17 | Cottonwood | Minnesota | 27033 | 213 | 0 |
542236 | 542236 | 2020-09-17 | Crow Wing | Minnesota | 27035 | 402 | 18 |
542237 | 542237 | 2020-09-17 | Dakota | Minnesota | 27037 | 6942 | 124 |
542238 | 542238 | 2020-09-17 | Dodge | Minnesota | 27039 | 182 | 0 |
542239 | 542239 | 2020-09-17 | Douglas | Minnesota | 27041 | 219 | 1 |
542240 | 542240 | 2020-09-17 | Faribault | Minnesota | 27043 | 129 | 0 |
542241 | 542241 | 2020-09-17 | Fillmore | Minnesota | 27045 | 98 | 0 |
542242 | 542242 | 2020-09-17 | Freeborn | Minnesota | 27047 | 490 | 3 |
542243 | 542243 | 2020-09-17 | Goodhue | Minnesota | 27049 | 317 | 9 |
542244 | 542244 | 2020-09-17 | Grant | Minnesota | 27051 | 57 | 4 |
542245 | 542245 | 2020-09-17 | Hennepin | Minnesota | 27053 | 25264 | 915 |
542246 | 542246 | 2020-09-17 | Houston | Minnesota | 27055 | 105 | 0 |
542247 | 542247 | 2020-09-17 | Hubbard | Minnesota | 27057 | 65 | 0 |
542248 | 542248 | 2020-09-17 | Isanti | Minnesota | 27059 | 221 | 0 |
542249 | 542249 | 2020-09-17 | Itasca | Minnesota | 27061 | 255 | 13 |
542250 | 542250 | 2020-09-17 | Jackson | Minnesota | 27063 | 120 | 1 |
542251 | 542251 | 2020-09-17 | Kanabec | Minnesota | 27065 | 95 | 8 |
542252 | 542252 | 2020-09-17 | Kandiyohi | Minnesota | 27067 | 908 | 2 |
542253 | 542253 | 2020-09-17 | Kittson | Minnesota | 27069 | 13 | 0 |
542254 | 542254 | 2020-09-17 | Koochiching | Minnesota | 27071 | 98 | 3 |
542255 | 542255 | 2020-09-17 | Lac qui Parle | Minnesota | 27073 | 36 | 0 |
542256 | 542256 | 2020-09-17 | Lake | Minnesota | 27075 | 48 | 0 |
542257 | 542257 | 2020-09-17 | Lake of the Woods | Minnesota | 27077 | 20 | 1 |
542258 | 542258 | 2020-09-17 | Le Sueur | Minnesota | 27079 | 440 | 3 |
542259 | 542259 | 2020-09-17 | Lincoln | Minnesota | 27081 | 93 | 0 |
542260 | 542260 | 2020-09-17 | Lyon | Minnesota | 27083 | 624 | 4 |
542261 | 542261 | 2020-09-17 | Mahnomen | Minnesota | 27087 | 44 | 1 |
542262 | 542262 | 2020-09-17 | Marshall | Minnesota | 27089 | 48 | 1 |
542263 | 542263 | 2020-09-17 | Martin | Minnesota | 27091 | 280 | 9 |
542264 | 542264 | 2020-09-17 | McLeod | Minnesota | 27085 | 433 | 2 |
542265 | 542265 | 2020-09-17 | Meeker | Minnesota | 27093 | 155 | 2 |
542266 | 542266 | 2020-09-17 | Mille Lacs | Minnesota | 27095 | 133 | 3 |
542267 | 542267 | 2020-09-17 | Morrison | Minnesota | 27097 | 184 | 1 |
542268 | 542268 | 2020-09-17 | Mower | Minnesota | 27099 | 1253 | 4 |
542269 | 542269 | 2020-09-17 | Murray | Minnesota | 27101 | 149 | 2 |
542270 | 542270 | 2020-09-17 | Nicollet | Minnesota | 27103 | 487 | 16 |
542271 | 542271 | 2020-09-17 | Nobles | Minnesota | 27105 | 1914 | 16 |
542272 | 542272 | 2020-09-17 | Norman | Minnesota | 27107 | 51 | 0 |
542273 | 542273 | 2020-09-17 | Olmsted | Minnesota | 27109 | 2237 | 26 |
542274 | 542274 | 2020-09-17 | Otter Tail | Minnesota | 27111 | 367 | 4 |
542275 | 542275 | 2020-09-17 | Pennington | Minnesota | 27113 | 107 | 1 |
542276 | 542276 | 2020-09-17 | Pine | Minnesota | 27115 | 198 | 0 |
542277 | 542277 | 2020-09-17 | Pipestone | Minnesota | 27117 | 205 | 9 |
542278 | 542278 | 2020-09-17 | Polk | Minnesota | 27119 | 257 | 4 |
542279 | 542279 | 2020-09-17 | Pope | Minnesota | 27121 | 81 | 0 |
542280 | 542280 | 2020-09-17 | Ramsey | Minnesota | 27123 | 10267 | 314 |
542281 | 542281 | 2020-09-17 | Red Lake | Minnesota | 27125 | 37 | 0 |
542282 | 542282 | 2020-09-17 | Redwood | Minnesota | 27127 | 91 | 0 |
542283 | 542283 | 2020-09-17 | Renville | Minnesota | 27129 | 117 | 6 |
542284 | 542284 | 2020-09-17 | Rice | Minnesota | 27131 | 1279 | 8 |
542285 | 542285 | 2020-09-17 | Rock | Minnesota | 27133 | 139 | 0 |
542286 | 542286 | 2020-09-17 | Roseau | Minnesota | 27135 | 105 | 0 |
542287 | 542287 | 2020-09-17 | Scott | Minnesota | 27139 | 2325 | 32 |
542288 | 542288 | 2020-09-17 | Sherburne | Minnesota | 27141 | 1050 | 13 |
542289 | 542289 | 2020-09-17 | Sibley | Minnesota | 27143 | 166 | 3 |
542290 | 542290 | 2020-09-17 | St. Louis | Minnesota | 27137 | 1233 | 29 |
542291 | 542291 | 2020-09-17 | Stearns | Minnesota | 27145 | 3629 | 23 |
542292 | 542292 | 2020-09-17 | Steele | Minnesota | 27147 | 506 | 2 |
542293 | 542293 | 2020-09-17 | Stevens | Minnesota | 27149 | 91 | 1 |
542294 | 542294 | 2020-09-17 | Swift | Minnesota | 27151 | 99 | 1 |
542295 | 542295 | 2020-09-17 | Todd | Minnesota | 27153 | 472 | 2 |
542296 | 542296 | 2020-09-17 | Traverse | Minnesota | 27155 | 29 | 0 |
542297 | 542297 | 2020-09-17 | Unknown | Minnesota | 209 | 52 | |
542298 | 542298 | 2020-09-17 | Wabasha | Minnesota | 27157 | 164 | 0 |
542299 | 542299 | 2020-09-17 | Wadena | Minnesota | 27159 | 61 | 0 |
542300 | 542300 | 2020-09-17 | Waseca | Minnesota | 27161 | 411 | 8 |
542301 | 542301 | 2020-09-17 | Washington | Minnesota | 27163 | 3459 | 55 |
542302 | 542302 | 2020-09-17 | Watonwan | Minnesota | 27165 | 484 | 4 |
542303 | 542303 | 2020-09-17 | Wilkin | Minnesota | 27167 | 55 | 3 |
542304 | 542304 | 2020-09-17 | Winona | Minnesota | 27169 | 727 | 18 |
542305 | 542305 | 2020-09-17 | Wright | Minnesota | 27171 | 1477 | 7 |
542306 | 542306 | 2020-09-17 | Yellow Medicine | Minnesota | 27173 | 142 | 1 |
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);