ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
87 rows where date = "2020-07-07" 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 |
---|---|---|---|---|---|---|---|
310506 | 310506 | 2020-07-07 | Aitkin | Minnesota | 27001 | 15 | 0 |
310507 | 310507 | 2020-07-07 | Anoka | Minnesota | 27003 | 2266 | 109 |
310508 | 310508 | 2020-07-07 | Becker | Minnesota | 27005 | 57 | 0 |
310509 | 310509 | 2020-07-07 | Beltrami | Minnesota | 27007 | 34 | 0 |
310510 | 310510 | 2020-07-07 | Benton | Minnesota | 27009 | 220 | 3 |
310511 | 310511 | 2020-07-07 | Big Stone | Minnesota | 27011 | 15 | 0 |
310512 | 310512 | 2020-07-07 | Blue Earth | Minnesota | 27013 | 494 | 2 |
310513 | 310513 | 2020-07-07 | Brown | Minnesota | 27015 | 34 | 2 |
310514 | 310514 | 2020-07-07 | Carlton | Minnesota | 27017 | 87 | 0 |
310515 | 310515 | 2020-07-07 | Carver | Minnesota | 27019 | 395 | 1 |
310516 | 310516 | 2020-07-07 | Cass | Minnesota | 27021 | 16 | 2 |
310517 | 310517 | 2020-07-07 | Chippewa | Minnesota | 27023 | 79 | 1 |
310518 | 310518 | 2020-07-07 | Chisago | Minnesota | 27025 | 102 | 1 |
310519 | 310519 | 2020-07-07 | Clay | Minnesota | 27027 | 591 | 38 |
310520 | 310520 | 2020-07-07 | Clearwater | Minnesota | 27029 | 9 | 0 |
310521 | 310521 | 2020-07-07 | Cook | Minnesota | 27031 | 1 | 0 |
310522 | 310522 | 2020-07-07 | Cottonwood | Minnesota | 27033 | 136 | 0 |
310523 | 310523 | 2020-07-07 | Crow Wing | Minnesota | 27035 | 108 | 12 |
310524 | 310524 | 2020-07-07 | Dakota | Minnesota | 27037 | 2421 | 92 |
310525 | 310525 | 2020-07-07 | Dodge | Minnesota | 27039 | 88 | 0 |
310526 | 310526 | 2020-07-07 | Douglas | Minnesota | 27041 | 65 | 0 |
310527 | 310527 | 2020-07-07 | Faribault | Minnesota | 27043 | 60 | 0 |
310528 | 310528 | 2020-07-07 | Fillmore | Minnesota | 27045 | 30 | 0 |
310529 | 310529 | 2020-07-07 | Freeborn | Minnesota | 27047 | 297 | 0 |
310530 | 310530 | 2020-07-07 | Goodhue | Minnesota | 27049 | 131 | 8 |
310531 | 310531 | 2020-07-07 | Grant | Minnesota | 27051 | 17 | 0 |
310532 | 310532 | 2020-07-07 | Hennepin | Minnesota | 27053 | 12597 | 787 |
310533 | 310533 | 2020-07-07 | Houston | Minnesota | 27055 | 27 | 0 |
310534 | 310534 | 2020-07-07 | Hubbard | Minnesota | 27057 | 8 | 0 |
310535 | 310535 | 2020-07-07 | Isanti | Minnesota | 27059 | 75 | 0 |
310536 | 310536 | 2020-07-07 | Itasca | Minnesota | 27061 | 64 | 12 |
310537 | 310537 | 2020-07-07 | Jackson | Minnesota | 27063 | 55 | 0 |
310538 | 310538 | 2020-07-07 | Kanabec | Minnesota | 27065 | 15 | 1 |
310539 | 310539 | 2020-07-07 | Kandiyohi | Minnesota | 27067 | 578 | 1 |
310540 | 310540 | 2020-07-07 | Kittson | Minnesota | 27069 | 2 | 0 |
310541 | 310541 | 2020-07-07 | Koochiching | Minnesota | 27071 | 18 | 1 |
310542 | 310542 | 2020-07-07 | Lac qui Parle | Minnesota | 27073 | 4 | 0 |
310543 | 310543 | 2020-07-07 | Lake | Minnesota | 27075 | 6 | 0 |
310544 | 310544 | 2020-07-07 | Le Sueur | Minnesota | 27079 | 108 | 1 |
310545 | 310545 | 2020-07-07 | Lincoln | Minnesota | 27081 | 10 | 0 |
310546 | 310546 | 2020-07-07 | Lyon | Minnesota | 27083 | 327 | 2 |
310547 | 310547 | 2020-07-07 | Mahnomen | Minnesota | 27087 | 10 | 1 |
310548 | 310548 | 2020-07-07 | Marshall | Minnesota | 27089 | 12 | 0 |
310549 | 310549 | 2020-07-07 | Martin | Minnesota | 27091 | 171 | 5 |
310550 | 310550 | 2020-07-07 | McLeod | Minnesota | 27085 | 92 | 0 |
310551 | 310551 | 2020-07-07 | Meeker | Minnesota | 27093 | 61 | 1 |
310552 | 310552 | 2020-07-07 | Mille Lacs | Minnesota | 27095 | 34 | 2 |
310553 | 310553 | 2020-07-07 | Morrison | Minnesota | 27097 | 61 | 1 |
310554 | 310554 | 2020-07-07 | Mower | Minnesota | 27099 | 960 | 2 |
310555 | 310555 | 2020-07-07 | Murray | Minnesota | 27101 | 65 | 0 |
310556 | 310556 | 2020-07-07 | Nicollet | Minnesota | 27103 | 173 | 12 |
310557 | 310557 | 2020-07-07 | Nobles | Minnesota | 27105 | 1672 | 6 |
310558 | 310558 | 2020-07-07 | Norman | Minnesota | 27107 | 20 | 0 |
310559 | 310559 | 2020-07-07 | Olmsted | Minnesota | 27109 | 1147 | 15 |
310560 | 310560 | 2020-07-07 | Otter Tail | Minnesota | 27111 | 100 | 1 |
310561 | 310561 | 2020-07-07 | Pennington | Minnesota | 27113 | 52 | 0 |
310562 | 310562 | 2020-07-07 | Pine | Minnesota | 27115 | 107 | 0 |
310563 | 310563 | 2020-07-07 | Pipestone | Minnesota | 27117 | 59 | 2 |
310564 | 310564 | 2020-07-07 | Polk | Minnesota | 27119 | 82 | 2 |
310565 | 310565 | 2020-07-07 | Pope | Minnesota | 27121 | 12 | 0 |
310566 | 310566 | 2020-07-07 | Ramsey | Minnesota | 27123 | 4963 | 229 |
310567 | 310567 | 2020-07-07 | Red Lake | Minnesota | 27125 | 4 | 0 |
310568 | 310568 | 2020-07-07 | Redwood | Minnesota | 27127 | 19 | 0 |
310569 | 310569 | 2020-07-07 | Renville | Minnesota | 27129 | 36 | 2 |
310570 | 310570 | 2020-07-07 | Rice | Minnesota | 27131 | 848 | 8 |
310571 | 310571 | 2020-07-07 | Rock | Minnesota | 27133 | 31 | 0 |
310572 | 310572 | 2020-07-07 | Roseau | Minnesota | 27135 | 17 | 0 |
310573 | 310573 | 2020-07-07 | Scott | Minnesota | 27139 | 762 | 4 |
310574 | 310574 | 2020-07-07 | Sherburne | Minnesota | 27141 | 325 | 5 |
310575 | 310575 | 2020-07-07 | Sibley | Minnesota | 27143 | 54 | 2 |
310576 | 310576 | 2020-07-07 | St. Louis | Minnesota | 27137 | 196 | 15 |
310577 | 310577 | 2020-07-07 | Stearns | Minnesota | 27145 | 2414 | 19 |
310578 | 310578 | 2020-07-07 | Steele | Minnesota | 27147 | 237 | 1 |
310579 | 310579 | 2020-07-07 | Stevens | Minnesota | 27149 | 5 | 0 |
310580 | 310580 | 2020-07-07 | Swift | Minnesota | 27151 | 22 | 1 |
310581 | 310581 | 2020-07-07 | Todd | Minnesota | 27153 | 401 | 2 |
310582 | 310582 | 2020-07-07 | Traverse | Minnesota | 27155 | 5 | 0 |
310583 | 310583 | 2020-07-07 | Unknown | Minnesota | 122 | 37 | |
310584 | 310584 | 2020-07-07 | Wabasha | Minnesota | 27157 | 33 | 0 |
310585 | 310585 | 2020-07-07 | Wadena | Minnesota | 27159 | 15 | 0 |
310586 | 310586 | 2020-07-07 | Waseca | Minnesota | 27161 | 71 | 0 |
310587 | 310587 | 2020-07-07 | Washington | Minnesota | 27163 | 1137 | 40 |
310588 | 310588 | 2020-07-07 | Watonwan | Minnesota | 27165 | 238 | 0 |
310589 | 310589 | 2020-07-07 | Wilkin | Minnesota | 27167 | 21 | 3 |
310590 | 310590 | 2020-07-07 | Winona | Minnesota | 27169 | 129 | 15 |
310591 | 310591 | 2020-07-07 | Wright | Minnesota | 27171 | 483 | 5 |
310592 | 310592 | 2020-07-07 | Yellow Medicine | Minnesota | 27173 | 30 | 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);