ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
87 rows where date = "2020-06-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 |
---|---|---|---|---|---|---|---|
288381 | 288381 | 2020-06-30 | Aitkin | Minnesota | 27001 | 14 | 0 |
288382 | 288382 | 2020-06-30 | Anoka | Minnesota | 27003 | 2097 | 107 |
288383 | 288383 | 2020-06-30 | Becker | Minnesota | 27005 | 54 | 0 |
288384 | 288384 | 2020-06-30 | Beltrami | Minnesota | 27007 | 27 | 0 |
288385 | 288385 | 2020-06-30 | Benton | Minnesota | 27009 | 208 | 3 |
288386 | 288386 | 2020-06-30 | Big Stone | Minnesota | 27011 | 14 | 0 |
288387 | 288387 | 2020-06-30 | Blue Earth | Minnesota | 27013 | 403 | 2 |
288388 | 288388 | 2020-06-30 | Brown | Minnesota | 27015 | 30 | 2 |
288389 | 288389 | 2020-06-30 | Carlton | Minnesota | 27017 | 81 | 0 |
288390 | 288390 | 2020-06-30 | Carver | Minnesota | 27019 | 340 | 1 |
288391 | 288391 | 2020-06-30 | Cass | Minnesota | 27021 | 13 | 2 |
288392 | 288392 | 2020-06-30 | Chippewa | Minnesota | 27023 | 75 | 1 |
288393 | 288393 | 2020-06-30 | Chisago | Minnesota | 27025 | 93 | 1 |
288394 | 288394 | 2020-06-30 | Clay | Minnesota | 27027 | 563 | 37 |
288395 | 288395 | 2020-06-30 | Clearwater | Minnesota | 27029 | 7 | 0 |
288396 | 288396 | 2020-06-30 | Cook | Minnesota | 27031 | 1 | 0 |
288397 | 288397 | 2020-06-30 | Cottonwood | Minnesota | 27033 | 133 | 0 |
288398 | 288398 | 2020-06-30 | Crow Wing | Minnesota | 27035 | 102 | 12 |
288399 | 288399 | 2020-06-30 | Dakota | Minnesota | 27037 | 2180 | 87 |
288400 | 288400 | 2020-06-30 | Dodge | Minnesota | 27039 | 81 | 0 |
288401 | 288401 | 2020-06-30 | Douglas | Minnesota | 27041 | 61 | 0 |
288402 | 288402 | 2020-06-30 | Faribault | Minnesota | 27043 | 53 | 0 |
288403 | 288403 | 2020-06-30 | Fillmore | Minnesota | 27045 | 25 | 0 |
288404 | 288404 | 2020-06-30 | Freeborn | Minnesota | 27047 | 281 | 0 |
288405 | 288405 | 2020-06-30 | Goodhue | Minnesota | 27049 | 119 | 8 |
288406 | 288406 | 2020-06-30 | Grant | Minnesota | 27051 | 6 | 0 |
288407 | 288407 | 2020-06-30 | Hennepin | Minnesota | 27053 | 11796 | 776 |
288408 | 288408 | 2020-06-30 | Houston | Minnesota | 27055 | 24 | 0 |
288409 | 288409 | 2020-06-30 | Hubbard | Minnesota | 27057 | 5 | 0 |
288410 | 288410 | 2020-06-30 | Isanti | Minnesota | 27059 | 61 | 0 |
288411 | 288411 | 2020-06-30 | Itasca | Minnesota | 27061 | 65 | 12 |
288412 | 288412 | 2020-06-30 | Jackson | Minnesota | 27063 | 54 | 0 |
288413 | 288413 | 2020-06-30 | Kanabec | Minnesota | 27065 | 14 | 1 |
288414 | 288414 | 2020-06-30 | Kandiyohi | Minnesota | 27067 | 565 | 1 |
288415 | 288415 | 2020-06-30 | Kittson | Minnesota | 27069 | 2 | 0 |
288416 | 288416 | 2020-06-30 | Koochiching | Minnesota | 27071 | 13 | 1 |
288417 | 288417 | 2020-06-30 | Lac qui Parle | Minnesota | 27073 | 4 | 0 |
288418 | 288418 | 2020-06-30 | Lake | Minnesota | 27075 | 7 | 0 |
288419 | 288419 | 2020-06-30 | Le Sueur | Minnesota | 27079 | 82 | 1 |
288420 | 288420 | 2020-06-30 | Lincoln | Minnesota | 27081 | 8 | 0 |
288421 | 288421 | 2020-06-30 | Lyon | Minnesota | 27083 | 295 | 2 |
288422 | 288422 | 2020-06-30 | Mahnomen | Minnesota | 27087 | 7 | 1 |
288423 | 288423 | 2020-06-30 | Marshall | Minnesota | 27089 | 12 | 0 |
288424 | 288424 | 2020-06-30 | Martin | Minnesota | 27091 | 156 | 5 |
288425 | 288425 | 2020-06-30 | McLeod | Minnesota | 27085 | 81 | 0 |
288426 | 288426 | 2020-06-30 | Meeker | Minnesota | 27093 | 58 | 1 |
288427 | 288427 | 2020-06-30 | Mille Lacs | Minnesota | 27095 | 32 | 2 |
288428 | 288428 | 2020-06-30 | Morrison | Minnesota | 27097 | 58 | 1 |
288429 | 288429 | 2020-06-30 | Mower | Minnesota | 27099 | 921 | 2 |
288430 | 288430 | 2020-06-30 | Murray | Minnesota | 27101 | 51 | 0 |
288431 | 288431 | 2020-06-30 | Nicollet | Minnesota | 27103 | 144 | 12 |
288432 | 288432 | 2020-06-30 | Nobles | Minnesota | 27105 | 1652 | 6 |
288433 | 288433 | 2020-06-30 | Norman | Minnesota | 27107 | 20 | 0 |
288434 | 288434 | 2020-06-30 | Olmsted | Minnesota | 27109 | 1047 | 15 |
288435 | 288435 | 2020-06-30 | Otter Tail | Minnesota | 27111 | 92 | 1 |
288436 | 288436 | 2020-06-30 | Pennington | Minnesota | 27113 | 50 | 0 |
288437 | 288437 | 2020-06-30 | Pine | Minnesota | 27115 | 100 | 0 |
288438 | 288438 | 2020-06-30 | Pipestone | Minnesota | 27117 | 25 | 1 |
288439 | 288439 | 2020-06-30 | Polk | Minnesota | 27119 | 79 | 2 |
288440 | 288440 | 2020-06-30 | Pope | Minnesota | 27121 | 10 | 0 |
288441 | 288441 | 2020-06-30 | Ramsey | Minnesota | 27123 | 4685 | 217 |
288442 | 288442 | 2020-06-30 | Red Lake | Minnesota | 27125 | 3 | 0 |
288443 | 288443 | 2020-06-30 | Redwood | Minnesota | 27127 | 16 | 0 |
288444 | 288444 | 2020-06-30 | Renville | Minnesota | 27129 | 24 | 2 |
288445 | 288445 | 2020-06-30 | Rice | Minnesota | 27131 | 809 | 7 |
288446 | 288446 | 2020-06-30 | Rock | Minnesota | 27133 | 30 | 0 |
288447 | 288447 | 2020-06-30 | Roseau | Minnesota | 27135 | 6 | 0 |
288448 | 288448 | 2020-06-30 | Scott | Minnesota | 27139 | 658 | 4 |
288449 | 288449 | 2020-06-30 | Sherburne | Minnesota | 27141 | 295 | 4 |
288450 | 288450 | 2020-06-30 | Sibley | Minnesota | 27143 | 48 | 2 |
288451 | 288451 | 2020-06-30 | St. Louis | Minnesota | 27137 | 161 | 14 |
288452 | 288452 | 2020-06-30 | Stearns | Minnesota | 27145 | 2265 | 19 |
288453 | 288453 | 2020-06-30 | Steele | Minnesota | 27147 | 215 | 0 |
288454 | 288454 | 2020-06-30 | Stevens | Minnesota | 27149 | 4 | 0 |
288455 | 288455 | 2020-06-30 | Swift | Minnesota | 27151 | 20 | 1 |
288456 | 288456 | 2020-06-30 | Todd | Minnesota | 27153 | 398 | 2 |
288457 | 288457 | 2020-06-30 | Traverse | Minnesota | 27155 | 5 | 0 |
288458 | 288458 | 2020-06-30 | Unknown | Minnesota | 118 | 35 | |
288459 | 288459 | 2020-06-30 | Wabasha | Minnesota | 27157 | 31 | 0 |
288460 | 288460 | 2020-06-30 | Wadena | Minnesota | 27159 | 15 | 0 |
288461 | 288461 | 2020-06-30 | Waseca | Minnesota | 27161 | 57 | 0 |
288462 | 288462 | 2020-06-30 | Washington | Minnesota | 27163 | 1008 | 40 |
288463 | 288463 | 2020-06-30 | Watonwan | Minnesota | 27165 | 203 | 0 |
288464 | 288464 | 2020-06-30 | Wilkin | Minnesota | 27167 | 20 | 3 |
288465 | 288465 | 2020-06-30 | Winona | Minnesota | 27169 | 119 | 15 |
288466 | 288466 | 2020-06-30 | Wright | Minnesota | 27171 | 445 | 5 |
288467 | 288467 | 2020-06-30 | Yellow Medicine | Minnesota | 27173 | 29 | 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);