ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where date = "2020-05-22" 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 |
---|---|---|---|---|---|---|---|
167601 | 167601 | 2020-05-22 | Aitkin | Minnesota | 27001 | 4 | 0 |
167602 | 167602 | 2020-05-22 | Anoka | Minnesota | 27003 | 1044 | 53 |
167603 | 167603 | 2020-05-22 | Becker | Minnesota | 27005 | 33 | 0 |
167604 | 167604 | 2020-05-22 | Beltrami | Minnesota | 27007 | 10 | 0 |
167605 | 167605 | 2020-05-22 | Benton | Minnesota | 27009 | 158 | 2 |
167606 | 167606 | 2020-05-22 | Big Stone | Minnesota | 27011 | 3 | 0 |
167607 | 167607 | 2020-05-22 | Blue Earth | Minnesota | 27013 | 108 | 1 |
167608 | 167608 | 2020-05-22 | Brown | Minnesota | 27015 | 11 | 2 |
167609 | 167609 | 2020-05-22 | Carlton | Minnesota | 27017 | 71 | 0 |
167610 | 167610 | 2020-05-22 | Carver | Minnesota | 27019 | 146 | 2 |
167611 | 167611 | 2020-05-22 | Cass | Minnesota | 27021 | 10 | 2 |
167612 | 167612 | 2020-05-22 | Chippewa | Minnesota | 27023 | 39 | 0 |
167613 | 167613 | 2020-05-22 | Chisago | Minnesota | 27025 | 41 | 1 |
167614 | 167614 | 2020-05-22 | Clay | Minnesota | 27027 | 356 | 22 |
167615 | 167615 | 2020-05-22 | Clearwater | Minnesota | 27029 | 2 | 0 |
167616 | 167616 | 2020-05-22 | Cottonwood | Minnesota | 27033 | 61 | 0 |
167617 | 167617 | 2020-05-22 | Crow Wing | Minnesota | 27035 | 42 | 1 |
167618 | 167618 | 2020-05-22 | Dakota | Minnesota | 27037 | 961 | 33 |
167619 | 167619 | 2020-05-22 | Dodge | Minnesota | 27039 | 41 | 0 |
167620 | 167620 | 2020-05-22 | Douglas | Minnesota | 27041 | 27 | 0 |
167621 | 167621 | 2020-05-22 | Faribault | Minnesota | 27043 | 11 | 0 |
167622 | 167622 | 2020-05-22 | Fillmore | Minnesota | 27045 | 17 | 1 |
167623 | 167623 | 2020-05-22 | Freeborn | Minnesota | 27047 | 76 | 0 |
167624 | 167624 | 2020-05-22 | Goodhue | Minnesota | 27049 | 43 | 2 |
167625 | 167625 | 2020-05-22 | Grant | Minnesota | 27051 | 2 | 0 |
167626 | 167626 | 2020-05-22 | Hennepin | Minnesota | 27053 | 6350 | 518 |
167627 | 167627 | 2020-05-22 | Houston | Minnesota | 27055 | 2 | 0 |
167628 | 167628 | 2020-05-22 | Isanti | Minnesota | 27059 | 21 | 0 |
167629 | 167629 | 2020-05-22 | Itasca | Minnesota | 27061 | 51 | 6 |
167630 | 167630 | 2020-05-22 | Jackson | Minnesota | 27063 | 37 | 0 |
167631 | 167631 | 2020-05-22 | Kanabec | Minnesota | 27065 | 11 | 1 |
167632 | 167632 | 2020-05-22 | Kandiyohi | Minnesota | 27067 | 443 | 1 |
167633 | 167633 | 2020-05-22 | Kittson | Minnesota | 27069 | 1 | 0 |
167634 | 167634 | 2020-05-22 | Koochiching | Minnesota | 27071 | 4 | 0 |
167635 | 167635 | 2020-05-22 | Lac qui Parle | Minnesota | 27073 | 3 | 0 |
167636 | 167636 | 2020-05-22 | Lake | Minnesota | 27075 | 1 | 0 |
167637 | 167637 | 2020-05-22 | Le Sueur | Minnesota | 27079 | 39 | 1 |
167638 | 167638 | 2020-05-22 | Lincoln | Minnesota | 27081 | 4 | 0 |
167639 | 167639 | 2020-05-22 | Lyon | Minnesota | 27083 | 29 | 0 |
167640 | 167640 | 2020-05-22 | Mahnomen | Minnesota | 27087 | 5 | 1 |
167641 | 167641 | 2020-05-22 | Marshall | Minnesota | 27089 | 8 | 0 |
167642 | 167642 | 2020-05-22 | Martin | Minnesota | 27091 | 124 | 5 |
167643 | 167643 | 2020-05-22 | McLeod | Minnesota | 27085 | 24 | 0 |
167644 | 167644 | 2020-05-22 | Meeker | Minnesota | 27093 | 41 | 0 |
167645 | 167645 | 2020-05-22 | Mille Lacs | Minnesota | 27095 | 15 | 1 |
167646 | 167646 | 2020-05-22 | Morrison | Minnesota | 27097 | 34 | 0 |
167647 | 167647 | 2020-05-22 | Mower | Minnesota | 27099 | 112 | 1 |
167648 | 167648 | 2020-05-22 | Murray | Minnesota | 27101 | 34 | 0 |
167649 | 167649 | 2020-05-22 | Nicollet | Minnesota | 27103 | 63 | 3 |
167650 | 167650 | 2020-05-22 | Nobles | Minnesota | 27105 | 1432 | 2 |
167651 | 167651 | 2020-05-22 | Norman | Minnesota | 27107 | 11 | 0 |
167652 | 167652 | 2020-05-22 | Olmsted | Minnesota | 27109 | 525 | 10 |
167653 | 167653 | 2020-05-22 | Otter Tail | Minnesota | 27111 | 52 | 0 |
167654 | 167654 | 2020-05-22 | Pennington | Minnesota | 27113 | 6 | 0 |
167655 | 167655 | 2020-05-22 | Pine | Minnesota | 27115 | 84 | 0 |
167656 | 167656 | 2020-05-22 | Pipestone | Minnesota | 27117 | 10 | 0 |
167657 | 167657 | 2020-05-22 | Polk | Minnesota | 27119 | 57 | 2 |
167658 | 167658 | 2020-05-22 | Pope | Minnesota | 27121 | 6 | 0 |
167659 | 167659 | 2020-05-22 | Ramsey | Minnesota | 27123 | 2018 | 93 |
167660 | 167660 | 2020-05-22 | Red Lake | Minnesota | 27125 | 3 | 0 |
167661 | 167661 | 2020-05-22 | Redwood | Minnesota | 27127 | 3 | 0 |
167662 | 167662 | 2020-05-22 | Renville | Minnesota | 27129 | 5 | 0 |
167663 | 167663 | 2020-05-22 | Rice | Minnesota | 27131 | 328 | 2 |
167664 | 167664 | 2020-05-22 | Rock | Minnesota | 27133 | 20 | 0 |
167665 | 167665 | 2020-05-22 | Roseau | Minnesota | 27135 | 1 | 0 |
167666 | 167666 | 2020-05-22 | Scott | Minnesota | 27139 | 316 | 2 |
167667 | 167667 | 2020-05-22 | Sherburne | Minnesota | 27141 | 193 | 1 |
167668 | 167668 | 2020-05-22 | Sibley | Minnesota | 27143 | 12 | 0 |
167669 | 167669 | 2020-05-22 | St. Louis | Minnesota | 27137 | 109 | 13 |
167670 | 167670 | 2020-05-22 | Stearns | Minnesota | 27145 | 1881 | 12 |
167671 | 167671 | 2020-05-22 | Steele | Minnesota | 27147 | 134 | 0 |
167672 | 167672 | 2020-05-22 | Swift | Minnesota | 27151 | 15 | 0 |
167673 | 167673 | 2020-05-22 | Todd | Minnesota | 27153 | 140 | 0 |
167674 | 167674 | 2020-05-22 | Traverse | Minnesota | 27155 | 3 | 0 |
167675 | 167675 | 2020-05-22 | Unknown | Minnesota | 29 | 9 | |
167676 | 167676 | 2020-05-22 | Wabasha | Minnesota | 27157 | 16 | 0 |
167677 | 167677 | 2020-05-22 | Wadena | Minnesota | 27159 | 6 | 0 |
167678 | 167678 | 2020-05-22 | Waseca | Minnesota | 27161 | 23 | 0 |
167679 | 167679 | 2020-05-22 | Washington | Minnesota | 27163 | 453 | 25 |
167680 | 167680 | 2020-05-22 | Watonwan | Minnesota | 27165 | 45 | 0 |
167681 | 167681 | 2020-05-22 | Wilkin | Minnesota | 27167 | 11 | 3 |
167682 | 167682 | 2020-05-22 | Winona | Minnesota | 27169 | 76 | 15 |
167683 | 167683 | 2020-05-22 | Wright | Minnesota | 27171 | 213 | 2 |
167684 | 167684 | 2020-05-22 | Yellow Medicine | Minnesota | 27173 | 5 | 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);