ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2020-05-07" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
fips >30
county >30
- Aitkin 1
- Anoka 1
- Becker 1
- Beltrami 1
- Benton 1
- Big Stone 1
- Blue Earth 1
- Brown 1
- Carlton 1
- Carver 1
- Cass 1
- Chippewa 1
- Chisago 1
- Clay 1
- Clearwater 1
- Cottonwood 1
- Crow Wing 1
- Dakota 1
- Dodge 1
- Douglas 1
- Faribault 1
- Fillmore 1
- Freeborn 1
- Goodhue 1
- Grant 1
- Hennepin 1
- Houston 1
- Isanti 1
- Itasca 1
- Jackson 1
- …
state 1
- Minnesota · 84 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
122533 | 122533 | 2020-05-07 | Aitkin | Minnesota | 27001 | 1 | 0 |
122534 | 122534 | 2020-05-07 | Anoka | Minnesota | 27003 | 426 | 27 |
122535 | 122535 | 2020-05-07 | Becker | Minnesota | 27005 | 18 | 0 |
122536 | 122536 | 2020-05-07 | Beltrami | Minnesota | 27007 | 6 | 0 |
122537 | 122537 | 2020-05-07 | Benton | Minnesota | 27009 | 64 | 1 |
122538 | 122538 | 2020-05-07 | Big Stone | Minnesota | 27011 | 2 | 0 |
122539 | 122539 | 2020-05-07 | Blue Earth | Minnesota | 27013 | 55 | 0 |
122540 | 122540 | 2020-05-07 | Brown | Minnesota | 27015 | 9 | 1 |
122541 | 122541 | 2020-05-07 | Carlton | Minnesota | 27017 | 62 | 0 |
122542 | 122542 | 2020-05-07 | Carver | Minnesota | 27019 | 58 | 0 |
122543 | 122543 | 2020-05-07 | Cass | Minnesota | 27021 | 7 | 0 |
122544 | 122544 | 2020-05-07 | Chippewa | Minnesota | 27023 | 5 | 0 |
122545 | 122545 | 2020-05-07 | Chisago | Minnesota | 27025 | 14 | 1 |
122546 | 122546 | 2020-05-07 | Clay | Minnesota | 27027 | 222 | 15 |
122547 | 122547 | 2020-05-07 | Clearwater | Minnesota | 27029 | 2 | 0 |
122548 | 122548 | 2020-05-07 | Cottonwood | Minnesota | 27033 | 43 | 0 |
122549 | 122549 | 2020-05-07 | Crow Wing | Minnesota | 27035 | 23 | 1 |
122550 | 122550 | 2020-05-07 | Dakota | Minnesota | 27037 | 322 | 12 |
122551 | 122551 | 2020-05-07 | Dodge | Minnesota | 27039 | 22 | 0 |
122552 | 122552 | 2020-05-07 | Douglas | Minnesota | 27041 | 14 | 0 |
122553 | 122553 | 2020-05-07 | Faribault | Minnesota | 27043 | 7 | 0 |
122554 | 122554 | 2020-05-07 | Fillmore | Minnesota | 27045 | 12 | 1 |
122555 | 122555 | 2020-05-07 | Freeborn | Minnesota | 27047 | 39 | 0 |
122556 | 122556 | 2020-05-07 | Goodhue | Minnesota | 27049 | 25 | 0 |
122557 | 122557 | 2020-05-07 | Grant | Minnesota | 27051 | 1 | 0 |
122558 | 122558 | 2020-05-07 | Hennepin | Minnesota | 27053 | 2962 | 342 |
122559 | 122559 | 2020-05-07 | Houston | Minnesota | 27055 | 2 | 0 |
122560 | 122560 | 2020-05-07 | Isanti | Minnesota | 27059 | 7 | 0 |
122561 | 122561 | 2020-05-07 | Itasca | Minnesota | 27061 | 24 | 0 |
122562 | 122562 | 2020-05-07 | Jackson | Minnesota | 27063 | 29 | 0 |
122563 | 122563 | 2020-05-07 | Kanabec | Minnesota | 27065 | 4 | 0 |
122564 | 122564 | 2020-05-07 | Kandiyohi | Minnesota | 27067 | 238 | 1 |
122565 | 122565 | 2020-05-07 | Kittson | Minnesota | 27069 | 1 | 0 |
122566 | 122566 | 2020-05-07 | Koochiching | Minnesota | 27071 | 1 | 0 |
122567 | 122567 | 2020-05-07 | Lac qui Parle | Minnesota | 27073 | 2 | 0 |
122568 | 122568 | 2020-05-07 | Lake | Minnesota | 27075 | 1 | 0 |
122569 | 122569 | 2020-05-07 | Le Sueur | Minnesota | 27079 | 28 | 0 |
122570 | 122570 | 2020-05-07 | Lincoln | Minnesota | 27081 | 3 | 0 |
122571 | 122571 | 2020-05-07 | Lyon | Minnesota | 27083 | 15 | 0 |
122572 | 122572 | 2020-05-07 | Mahnomen | Minnesota | 27087 | 2 | 1 |
122573 | 122573 | 2020-05-07 | Marshall | Minnesota | 27089 | 8 | 0 |
122574 | 122574 | 2020-05-07 | Martin | Minnesota | 27091 | 111 | 4 |
122575 | 122575 | 2020-05-07 | McLeod | Minnesota | 27085 | 6 | 0 |
122576 | 122576 | 2020-05-07 | Meeker | Minnesota | 27093 | 18 | 0 |
122577 | 122577 | 2020-05-07 | Mille Lacs | Minnesota | 27095 | 6 | 1 |
122578 | 122578 | 2020-05-07 | Morrison | Minnesota | 27097 | 11 | 0 |
122579 | 122579 | 2020-05-07 | Mower | Minnesota | 27099 | 36 | 0 |
122580 | 122580 | 2020-05-07 | Murray | Minnesota | 27101 | 25 | 0 |
122581 | 122581 | 2020-05-07 | Nicollet | Minnesota | 27103 | 18 | 2 |
122582 | 122582 | 2020-05-07 | Nobles | Minnesota | 27105 | 1153 | 2 |
122583 | 122583 | 2020-05-07 | Norman | Minnesota | 27107 | 9 | 0 |
122584 | 122584 | 2020-05-07 | Olmsted | Minnesota | 27109 | 336 | 8 |
122585 | 122585 | 2020-05-07 | Otter Tail | Minnesota | 27111 | 21 | 0 |
122586 | 122586 | 2020-05-07 | Pennington | Minnesota | 27113 | 1 | 0 |
122587 | 122587 | 2020-05-07 | Pine | Minnesota | 27115 | 61 | 0 |
122588 | 122588 | 2020-05-07 | Pipestone | Minnesota | 27117 | 5 | 0 |
122589 | 122589 | 2020-05-07 | Polk | Minnesota | 27119 | 43 | 0 |
122590 | 122590 | 2020-05-07 | Pope | Minnesota | 27121 | 3 | 0 |
122591 | 122591 | 2020-05-07 | Ramsey | Minnesota | 27123 | 717 | 39 |
122592 | 122592 | 2020-05-07 | Red Lake | Minnesota | 27125 | 1 | 0 |
122593 | 122593 | 2020-05-07 | Redwood | Minnesota | 27127 | 3 | 0 |
122594 | 122594 | 2020-05-07 | Renville | Minnesota | 27129 | 6 | 0 |
122595 | 122595 | 2020-05-07 | Rice | Minnesota | 27131 | 48 | 1 |
122596 | 122596 | 2020-05-07 | Rock | Minnesota | 27133 | 19 | 0 |
122597 | 122597 | 2020-05-07 | Roseau | Minnesota | 27135 | 1 | 0 |
122598 | 122598 | 2020-05-07 | Scott | Minnesota | 27139 | 100 | 1 |
122599 | 122599 | 2020-05-07 | Sherburne | Minnesota | 27141 | 88 | 1 |
122600 | 122600 | 2020-05-07 | Sibley | Minnesota | 27143 | 2 | 0 |
122601 | 122601 | 2020-05-07 | St. Louis | Minnesota | 27137 | 89 | 11 |
122602 | 122602 | 2020-05-07 | Stearns | Minnesota | 27145 | 1161 | 4 |
122603 | 122603 | 2020-05-07 | Steele | Minnesota | 27147 | 37 | 0 |
122604 | 122604 | 2020-05-07 | Swift | Minnesota | 27151 | 2 | 0 |
122605 | 122605 | 2020-05-07 | Todd | Minnesota | 27153 | 26 | 0 |
122606 | 122606 | 2020-05-07 | Traverse | Minnesota | 27155 | 2 | 0 |
122607 | 122607 | 2020-05-07 | Unknown | Minnesota | 18 | 0 | |
122608 | 122608 | 2020-05-07 | Wabasha | Minnesota | 27157 | 12 | 0 |
122609 | 122609 | 2020-05-07 | Wadena | Minnesota | 27159 | 4 | 0 |
122610 | 122610 | 2020-05-07 | Waseca | Minnesota | 27161 | 12 | 0 |
122611 | 122611 | 2020-05-07 | Washington | Minnesota | 27163 | 193 | 12 |
122612 | 122612 | 2020-05-07 | Watonwan | Minnesota | 27165 | 18 | 0 |
122613 | 122613 | 2020-05-07 | Wilkin | Minnesota | 27167 | 12 | 3 |
122614 | 122614 | 2020-05-07 | Winona | Minnesota | 27169 | 68 | 15 |
122615 | 122615 | 2020-05-07 | Wright | Minnesota | 27171 | 73 | 1 |
122616 | 122616 | 2020-05-07 | Yellow Medicine | Minnesota | 27173 | 3 | 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);