ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where date = "2020-09-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 |
---|---|---|---|---|---|---|---|
584333 | 584333 | 2020-09-30 | Aitkin | Minnesota | 27001 | 88 | 1 |
584334 | 584334 | 2020-09-30 | Anoka | Minnesota | 27003 | 6343 | 138 |
584335 | 584335 | 2020-09-30 | Becker | Minnesota | 27005 | 286 | 2 |
584336 | 584336 | 2020-09-30 | Beltrami | Minnesota | 27007 | 473 | 5 |
584337 | 584337 | 2020-09-30 | Benton | Minnesota | 27009 | 568 | 3 |
584338 | 584338 | 2020-09-30 | Big Stone | Minnesota | 27011 | 83 | 0 |
584339 | 584339 | 2020-09-30 | Blue Earth | Minnesota | 27013 | 1743 | 7 |
584340 | 584340 | 2020-09-30 | Brown | Minnesota | 27015 | 199 | 2 |
584341 | 584341 | 2020-09-30 | Carlton | Minnesota | 27017 | 286 | 1 |
584342 | 584342 | 2020-09-30 | Carver | Minnesota | 27019 | 1451 | 7 |
584343 | 584343 | 2020-09-30 | Cass | Minnesota | 27021 | 188 | 4 |
584344 | 584344 | 2020-09-30 | Chippewa | Minnesota | 27023 | 233 | 1 |
584345 | 584345 | 2020-09-30 | Chisago | Minnesota | 27025 | 522 | 1 |
584346 | 584346 | 2020-09-30 | Clay | Minnesota | 27027 | 1457 | 41 |
584347 | 584347 | 2020-09-30 | Clearwater | Minnesota | 27029 | 32 | 0 |
584348 | 584348 | 2020-09-30 | Cook | Minnesota | 27031 | 7 | 0 |
584349 | 584349 | 2020-09-30 | Cottonwood | Minnesota | 27033 | 229 | 0 |
584350 | 584350 | 2020-09-30 | Crow Wing | Minnesota | 27035 | 563 | 18 |
584351 | 584351 | 2020-09-30 | Dakota | Minnesota | 27037 | 7724 | 127 |
584352 | 584352 | 2020-09-30 | Dodge | Minnesota | 27039 | 268 | 0 |
584353 | 584353 | 2020-09-30 | Douglas | Minnesota | 27041 | 362 | 2 |
584354 | 584354 | 2020-09-30 | Faribault | Minnesota | 27043 | 149 | 0 |
584355 | 584355 | 2020-09-30 | Fillmore | Minnesota | 27045 | 134 | 0 |
584356 | 584356 | 2020-09-30 | Freeborn | Minnesota | 27047 | 548 | 4 |
584357 | 584357 | 2020-09-30 | Goodhue | Minnesota | 27049 | 392 | 9 |
584358 | 584358 | 2020-09-30 | Grant | Minnesota | 27051 | 64 | 4 |
584359 | 584359 | 2020-09-30 | Hennepin | Minnesota | 27053 | 27728 | 936 |
584360 | 584360 | 2020-09-30 | Houston | Minnesota | 27055 | 135 | 0 |
584361 | 584361 | 2020-09-30 | Hubbard | Minnesota | 27057 | 126 | 1 |
584362 | 584362 | 2020-09-30 | Isanti | Minnesota | 27059 | 324 | 1 |
584363 | 584363 | 2020-09-30 | Itasca | Minnesota | 27061 | 356 | 16 |
584364 | 584364 | 2020-09-30 | Jackson | Minnesota | 27063 | 154 | 1 |
584365 | 584365 | 2020-09-30 | Kanabec | Minnesota | 27065 | 131 | 8 |
584366 | 584366 | 2020-09-30 | Kandiyohi | Minnesota | 27067 | 1057 | 3 |
584367 | 584367 | 2020-09-30 | Kittson | Minnesota | 27069 | 12 | 0 |
584368 | 584368 | 2020-09-30 | Koochiching | Minnesota | 27071 | 123 | 4 |
584369 | 584369 | 2020-09-30 | Lac qui Parle | Minnesota | 27073 | 72 | 1 |
584370 | 584370 | 2020-09-30 | Lake | Minnesota | 27075 | 61 | 0 |
584371 | 584371 | 2020-09-30 | Lake of the Woods | Minnesota | 27077 | 24 | 1 |
584372 | 584372 | 2020-09-30 | Le Sueur | Minnesota | 27079 | 480 | 4 |
584373 | 584373 | 2020-09-30 | Lincoln | Minnesota | 27081 | 118 | 0 |
584374 | 584374 | 2020-09-30 | Lyon | Minnesota | 27083 | 738 | 4 |
584375 | 584375 | 2020-09-30 | Mahnomen | Minnesota | 27087 | 49 | 1 |
584376 | 584376 | 2020-09-30 | Marshall | Minnesota | 27089 | 53 | 1 |
584377 | 584377 | 2020-09-30 | Martin | Minnesota | 27091 | 462 | 11 |
584378 | 584378 | 2020-09-30 | McLeod | Minnesota | 27085 | 503 | 2 |
584379 | 584379 | 2020-09-30 | Meeker | Minnesota | 27093 | 214 | 2 |
584380 | 584380 | 2020-09-30 | Mille Lacs | Minnesota | 27095 | 172 | 3 |
584381 | 584381 | 2020-09-30 | Morrison | Minnesota | 27097 | 280 | 2 |
584382 | 584382 | 2020-09-30 | Mower | Minnesota | 27099 | 1348 | 6 |
584383 | 584383 | 2020-09-30 | Murray | Minnesota | 27101 | 176 | 2 |
584384 | 584384 | 2020-09-30 | Nicollet | Minnesota | 27103 | 553 | 17 |
584385 | 584385 | 2020-09-30 | Nobles | Minnesota | 27105 | 1979 | 16 |
584386 | 584386 | 2020-09-30 | Norman | Minnesota | 27107 | 58 | 0 |
584387 | 584387 | 2020-09-30 | Olmsted | Minnesota | 27109 | 2544 | 28 |
584388 | 584388 | 2020-09-30 | Otter Tail | Minnesota | 27111 | 473 | 4 |
584389 | 584389 | 2020-09-30 | Pennington | Minnesota | 27113 | 120 | 1 |
584390 | 584390 | 2020-09-30 | Pine | Minnesota | 27115 | 361 | 0 |
584391 | 584391 | 2020-09-30 | Pipestone | Minnesota | 27117 | 239 | 10 |
584392 | 584392 | 2020-09-30 | Polk | Minnesota | 27119 | 334 | 4 |
584393 | 584393 | 2020-09-30 | Pope | Minnesota | 27121 | 100 | 0 |
584394 | 584394 | 2020-09-30 | Ramsey | Minnesota | 27123 | 11209 | 325 |
584395 | 584395 | 2020-09-30 | Red Lake | Minnesota | 27125 | 45 | 1 |
584396 | 584396 | 2020-09-30 | Redwood | Minnesota | 27127 | 180 | 5 |
584397 | 584397 | 2020-09-30 | Renville | Minnesota | 27129 | 163 | 8 |
584398 | 584398 | 2020-09-30 | Rice | Minnesota | 27131 | 1351 | 8 |
584399 | 584399 | 2020-09-30 | Rock | Minnesota | 27133 | 184 | 1 |
584400 | 584400 | 2020-09-30 | Roseau | Minnesota | 27135 | 125 | 0 |
584401 | 584401 | 2020-09-30 | Scott | Minnesota | 27139 | 2663 | 33 |
584402 | 584402 | 2020-09-30 | Sherburne | Minnesota | 27141 | 1185 | 14 |
584403 | 584403 | 2020-09-30 | Sibley | Minnesota | 27143 | 203 | 3 |
584404 | 584404 | 2020-09-30 | St. Louis | Minnesota | 27137 | 1747 | 42 |
584405 | 584405 | 2020-09-30 | Stearns | Minnesota | 27145 | 4119 | 25 |
584406 | 584406 | 2020-09-30 | Steele | Minnesota | 27147 | 560 | 2 |
584407 | 584407 | 2020-09-30 | Stevens | Minnesota | 27149 | 107 | 1 |
584408 | 584408 | 2020-09-30 | Swift | Minnesota | 27151 | 145 | 1 |
584409 | 584409 | 2020-09-30 | Todd | Minnesota | 27153 | 514 | 2 |
584410 | 584410 | 2020-09-30 | Traverse | Minnesota | 27155 | 36 | 0 |
584411 | 584411 | 2020-09-30 | Unknown | Minnesota | 207 | 53 | |
584412 | 584412 | 2020-09-30 | Wabasha | Minnesota | 27157 | 208 | 0 |
584413 | 584413 | 2020-09-30 | Wadena | Minnesota | 27159 | 73 | 0 |
584414 | 584414 | 2020-09-30 | Waseca | Minnesota | 27161 | 722 | 8 |
584415 | 584415 | 2020-09-30 | Washington | Minnesota | 27163 | 3950 | 55 |
584416 | 584416 | 2020-09-30 | Watonwan | Minnesota | 27165 | 535 | 4 |
584417 | 584417 | 2020-09-30 | Wilkin | Minnesota | 27167 | 71 | 3 |
584418 | 584418 | 2020-09-30 | Winona | Minnesota | 27169 | 923 | 18 |
584419 | 584419 | 2020-09-30 | Wright | Minnesota | 27171 | 1713 | 7 |
584420 | 584420 | 2020-09-30 | Yellow Medicine | Minnesota | 27173 | 200 | 3 |
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);