ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where date = "2020-10-16" 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 |
---|---|---|---|---|---|---|---|
636211 | 636211 | 2020-10-16 | Aitkin | Minnesota | 27001 | 140 | 1 |
636212 | 636212 | 2020-10-16 | Anoka | Minnesota | 27003 | 7715 | 147 |
636213 | 636213 | 2020-10-16 | Becker | Minnesota | 27005 | 460 | 2 |
636214 | 636214 | 2020-10-16 | Beltrami | Minnesota | 27007 | 714 | 7 |
636215 | 636215 | 2020-10-16 | Benton | Minnesota | 27009 | 790 | 4 |
636216 | 636216 | 2020-10-16 | Big Stone | Minnesota | 27011 | 121 | 0 |
636217 | 636217 | 2020-10-16 | Blue Earth | Minnesota | 27013 | 1933 | 7 |
636218 | 636218 | 2020-10-16 | Brown | Minnesota | 27015 | 285 | 3 |
636219 | 636219 | 2020-10-16 | Carlton | Minnesota | 27017 | 368 | 1 |
636220 | 636220 | 2020-10-16 | Carver | Minnesota | 27019 | 1646 | 7 |
636221 | 636221 | 2020-10-16 | Cass | Minnesota | 27021 | 289 | 4 |
636222 | 636222 | 2020-10-16 | Chippewa | Minnesota | 27023 | 357 | 2 |
636223 | 636223 | 2020-10-16 | Chisago | Minnesota | 27025 | 787 | 2 |
636224 | 636224 | 2020-10-16 | Clay | Minnesota | 27027 | 1919 | 43 |
636225 | 636225 | 2020-10-16 | Clearwater | Minnesota | 27029 | 64 | 0 |
636226 | 636226 | 2020-10-16 | Cook | Minnesota | 27031 | 8 | 0 |
636227 | 636227 | 2020-10-16 | Cottonwood | Minnesota | 27033 | 253 | 0 |
636228 | 636228 | 2020-10-16 | Crow Wing | Minnesota | 27035 | 810 | 21 |
636229 | 636229 | 2020-10-16 | Dakota | Minnesota | 27037 | 8930 | 133 |
636230 | 636230 | 2020-10-16 | Dodge | Minnesota | 27039 | 349 | 0 |
636231 | 636231 | 2020-10-16 | Douglas | Minnesota | 27041 | 556 | 3 |
636232 | 636232 | 2020-10-16 | Faribault | Minnesota | 27043 | 198 | 0 |
636233 | 636233 | 2020-10-16 | Fillmore | Minnesota | 27045 | 223 | 0 |
636234 | 636234 | 2020-10-16 | Freeborn | Minnesota | 27047 | 618 | 4 |
636235 | 636235 | 2020-10-16 | Goodhue | Minnesota | 27049 | 477 | 11 |
636236 | 636236 | 2020-10-16 | Grant | Minnesota | 27051 | 84 | 4 |
636237 | 636237 | 2020-10-16 | Hennepin | Minnesota | 27053 | 31472 | 962 |
636238 | 636238 | 2020-10-16 | Houston | Minnesota | 27055 | 174 | 1 |
636239 | 636239 | 2020-10-16 | Hubbard | Minnesota | 27057 | 264 | 2 |
636240 | 636240 | 2020-10-16 | Isanti | Minnesota | 27059 | 460 | 3 |
636241 | 636241 | 2020-10-16 | Itasca | Minnesota | 27061 | 638 | 17 |
636242 | 636242 | 2020-10-16 | Jackson | Minnesota | 27063 | 183 | 1 |
636243 | 636243 | 2020-10-16 | Kanabec | Minnesota | 27065 | 178 | 10 |
636244 | 636244 | 2020-10-16 | Kandiyohi | Minnesota | 27067 | 1464 | 4 |
636245 | 636245 | 2020-10-16 | Kittson | Minnesota | 27069 | 23 | 0 |
636246 | 636246 | 2020-10-16 | Koochiching | Minnesota | 27071 | 156 | 4 |
636247 | 636247 | 2020-10-16 | Lac qui Parle | Minnesota | 27073 | 118 | 2 |
636248 | 636248 | 2020-10-16 | Lake | Minnesota | 27075 | 94 | 0 |
636249 | 636249 | 2020-10-16 | Lake of the Woods | Minnesota | 27077 | 39 | 1 |
636250 | 636250 | 2020-10-16 | Le Sueur | Minnesota | 27079 | 574 | 5 |
636251 | 636251 | 2020-10-16 | Lincoln | Minnesota | 27081 | 156 | 0 |
636252 | 636252 | 2020-10-16 | Lyon | Minnesota | 27083 | 896 | 6 |
636253 | 636253 | 2020-10-16 | Mahnomen | Minnesota | 27087 | 85 | 1 |
636254 | 636254 | 2020-10-16 | Marshall | Minnesota | 27089 | 76 | 1 |
636255 | 636255 | 2020-10-16 | Martin | Minnesota | 27091 | 567 | 16 |
636256 | 636256 | 2020-10-16 | McLeod | Minnesota | 27085 | 555 | 3 |
636257 | 636257 | 2020-10-16 | Meeker | Minnesota | 27093 | 294 | 3 |
636258 | 636258 | 2020-10-16 | Mille Lacs | Minnesota | 27095 | 329 | 7 |
636259 | 636259 | 2020-10-16 | Morrison | Minnesota | 27097 | 536 | 5 |
636260 | 636260 | 2020-10-16 | Mower | Minnesota | 27099 | 1473 | 11 |
636261 | 636261 | 2020-10-16 | Murray | Minnesota | 27101 | 234 | 3 |
636262 | 636262 | 2020-10-16 | Nicollet | Minnesota | 27103 | 651 | 17 |
636263 | 636263 | 2020-10-16 | Nobles | Minnesota | 27105 | 2093 | 16 |
636264 | 636264 | 2020-10-16 | Norman | Minnesota | 27107 | 88 | 0 |
636265 | 636265 | 2020-10-16 | Olmsted | Minnesota | 27109 | 2979 | 29 |
636266 | 636266 | 2020-10-16 | Otter Tail | Minnesota | 27111 | 670 | 6 |
636267 | 636267 | 2020-10-16 | Pennington | Minnesota | 27113 | 153 | 1 |
636268 | 636268 | 2020-10-16 | Pine | Minnesota | 27115 | 488 | 0 |
636269 | 636269 | 2020-10-16 | Pipestone | Minnesota | 27117 | 320 | 16 |
636270 | 636270 | 2020-10-16 | Polk | Minnesota | 27119 | 455 | 4 |
636271 | 636271 | 2020-10-16 | Pope | Minnesota | 27121 | 136 | 0 |
636272 | 636272 | 2020-10-16 | Ramsey | Minnesota | 27123 | 12922 | 341 |
636273 | 636273 | 2020-10-16 | Red Lake | Minnesota | 27125 | 52 | 2 |
636274 | 636274 | 2020-10-16 | Redwood | Minnesota | 27127 | 231 | 10 |
636275 | 636275 | 2020-10-16 | Renville | Minnesota | 27129 | 216 | 11 |
636276 | 636276 | 2020-10-16 | Rice | Minnesota | 27131 | 1522 | 8 |
636277 | 636277 | 2020-10-16 | Rock | Minnesota | 27133 | 281 | 1 |
636278 | 636278 | 2020-10-16 | Roseau | Minnesota | 27135 | 172 | 0 |
636279 | 636279 | 2020-10-16 | Scott | Minnesota | 27139 | 3057 | 34 |
636280 | 636280 | 2020-10-16 | Sherburne | Minnesota | 27141 | 1467 | 20 |
636281 | 636281 | 2020-10-16 | Sibley | Minnesota | 27143 | 232 | 3 |
636282 | 636282 | 2020-10-16 | St. Louis | Minnesota | 27137 | 2498 | 61 |
636283 | 636283 | 2020-10-16 | Stearns | Minnesota | 27145 | 5094 | 33 |
636284 | 636284 | 2020-10-16 | Steele | Minnesota | 27147 | 692 | 2 |
636285 | 636285 | 2020-10-16 | Stevens | Minnesota | 27149 | 153 | 1 |
636286 | 636286 | 2020-10-16 | Swift | Minnesota | 27151 | 179 | 1 |
636287 | 636287 | 2020-10-16 | Todd | Minnesota | 27153 | 657 | 2 |
636288 | 636288 | 2020-10-16 | Traverse | Minnesota | 27155 | 47 | 0 |
636289 | 636289 | 2020-10-16 | Unknown | Minnesota | 271 | 53 | |
636290 | 636290 | 2020-10-16 | Wabasha | Minnesota | 27157 | 303 | 0 |
636291 | 636291 | 2020-10-16 | Wadena | Minnesota | 27159 | 170 | 0 |
636292 | 636292 | 2020-10-16 | Waseca | Minnesota | 27161 | 893 | 9 |
636293 | 636293 | 2020-10-16 | Washington | Minnesota | 27163 | 4942 | 66 |
636294 | 636294 | 2020-10-16 | Watonwan | Minnesota | 27165 | 557 | 4 |
636295 | 636295 | 2020-10-16 | Wilkin | Minnesota | 27167 | 110 | 4 |
636296 | 636296 | 2020-10-16 | Winona | Minnesota | 27169 | 1136 | 18 |
636297 | 636297 | 2020-10-16 | Wright | Minnesota | 27171 | 2170 | 13 |
636298 | 636298 | 2020-10-16 | Yellow Medicine | Minnesota | 27173 | 260 | 5 |
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);