ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
83 rows where "date" is on date 2020-05-05 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 · 83 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
116600 | 116600 | 2020-05-05 | Aitkin | Minnesota | 27001 | 1 | 0 |
116601 | 116601 | 2020-05-05 | Anoka | Minnesota | 27003 | 344 | 20 |
116602 | 116602 | 2020-05-05 | Becker | Minnesota | 27005 | 15 | 0 |
116603 | 116603 | 2020-05-05 | Beltrami | Minnesota | 27007 | 6 | 0 |
116604 | 116604 | 2020-05-05 | Benton | Minnesota | 27009 | 48 | 1 |
116605 | 116605 | 2020-05-05 | Big Stone | Minnesota | 27011 | 2 | 0 |
116606 | 116606 | 2020-05-05 | Blue Earth | Minnesota | 27013 | 51 | 0 |
116607 | 116607 | 2020-05-05 | Brown | Minnesota | 27015 | 9 | 1 |
116608 | 116608 | 2020-05-05 | Carlton | Minnesota | 27017 | 60 | 0 |
116609 | 116609 | 2020-05-05 | Carver | Minnesota | 27019 | 39 | 0 |
116610 | 116610 | 2020-05-05 | Cass | Minnesota | 27021 | 7 | 0 |
116611 | 116611 | 2020-05-05 | Chippewa | Minnesota | 27023 | 3 | 0 |
116612 | 116612 | 2020-05-05 | Chisago | Minnesota | 27025 | 13 | 1 |
116613 | 116613 | 2020-05-05 | Clay | Minnesota | 27027 | 201 | 14 |
116614 | 116614 | 2020-05-05 | Clearwater | Minnesota | 27029 | 2 | 0 |
116615 | 116615 | 2020-05-05 | Cottonwood | Minnesota | 27033 | 41 | 0 |
116616 | 116616 | 2020-05-05 | Crow Wing | Minnesota | 27035 | 21 | 1 |
116617 | 116617 | 2020-05-05 | Dakota | Minnesota | 27037 | 241 | 11 |
116618 | 116618 | 2020-05-05 | Dodge | Minnesota | 27039 | 22 | 0 |
116619 | 116619 | 2020-05-05 | Douglas | Minnesota | 27041 | 10 | 0 |
116620 | 116620 | 2020-05-05 | Faribault | Minnesota | 27043 | 7 | 0 |
116621 | 116621 | 2020-05-05 | Fillmore | Minnesota | 27045 | 12 | 1 |
116622 | 116622 | 2020-05-05 | Freeborn | Minnesota | 27047 | 37 | 0 |
116623 | 116623 | 2020-05-05 | Goodhue | Minnesota | 27049 | 23 | 0 |
116624 | 116624 | 2020-05-05 | Grant | Minnesota | 27051 | 1 | 0 |
116625 | 116625 | 2020-05-05 | Hennepin | Minnesota | 27053 | 2519 | 303 |
116626 | 116626 | 2020-05-05 | Houston | Minnesota | 27055 | 1 | 0 |
116627 | 116627 | 2020-05-05 | Isanti | Minnesota | 27059 | 6 | 0 |
116628 | 116628 | 2020-05-05 | Itasca | Minnesota | 27061 | 13 | 0 |
116629 | 116629 | 2020-05-05 | Jackson | Minnesota | 27063 | 25 | 0 |
116630 | 116630 | 2020-05-05 | Kanabec | Minnesota | 27065 | 2 | 0 |
116631 | 116631 | 2020-05-05 | Kandiyohi | Minnesota | 27067 | 200 | 1 |
116632 | 116632 | 2020-05-05 | Kittson | Minnesota | 27069 | 1 | 0 |
116633 | 116633 | 2020-05-05 | Koochiching | Minnesota | 27071 | 1 | 0 |
116634 | 116634 | 2020-05-05 | Lac qui Parle | Minnesota | 27073 | 2 | 0 |
116635 | 116635 | 2020-05-05 | Le Sueur | Minnesota | 27079 | 26 | 0 |
116636 | 116636 | 2020-05-05 | Lincoln | Minnesota | 27081 | 3 | 0 |
116637 | 116637 | 2020-05-05 | Lyon | Minnesota | 27083 | 10 | 0 |
116638 | 116638 | 2020-05-05 | Mahnomen | Minnesota | 27087 | 2 | 0 |
116639 | 116639 | 2020-05-05 | Marshall | Minnesota | 27089 | 7 | 0 |
116640 | 116640 | 2020-05-05 | Martin | Minnesota | 27091 | 111 | 4 |
116641 | 116641 | 2020-05-05 | McLeod | Minnesota | 27085 | 4 | 0 |
116642 | 116642 | 2020-05-05 | Meeker | Minnesota | 27093 | 17 | 0 |
116643 | 116643 | 2020-05-05 | Mille Lacs | Minnesota | 27095 | 4 | 1 |
116644 | 116644 | 2020-05-05 | Morrison | Minnesota | 27097 | 7 | 0 |
116645 | 116645 | 2020-05-05 | Mower | Minnesota | 27099 | 33 | 0 |
116646 | 116646 | 2020-05-05 | Murray | Minnesota | 27101 | 20 | 0 |
116647 | 116647 | 2020-05-05 | Nicollet | Minnesota | 27103 | 16 | 2 |
116648 | 116648 | 2020-05-05 | Nobles | Minnesota | 27105 | 1069 | 1 |
116649 | 116649 | 2020-05-05 | Norman | Minnesota | 27107 | 9 | 0 |
116650 | 116650 | 2020-05-05 | Olmsted | Minnesota | 27109 | 313 | 8 |
116651 | 116651 | 2020-05-05 | Otter Tail | Minnesota | 27111 | 19 | 0 |
116652 | 116652 | 2020-05-05 | Pennington | Minnesota | 27113 | 1 | 0 |
116653 | 116653 | 2020-05-05 | Pine | Minnesota | 27115 | 60 | 0 |
116654 | 116654 | 2020-05-05 | Pipestone | Minnesota | 27117 | 4 | 0 |
116655 | 116655 | 2020-05-05 | Polk | Minnesota | 27119 | 42 | 0 |
116656 | 116656 | 2020-05-05 | Pope | Minnesota | 27121 | 1 | 0 |
116657 | 116657 | 2020-05-05 | Ramsey | Minnesota | 27123 | 583 | 37 |
116658 | 116658 | 2020-05-05 | Red Lake | Minnesota | 27125 | 1 | 0 |
116659 | 116659 | 2020-05-05 | Redwood | Minnesota | 27127 | 3 | 0 |
116660 | 116660 | 2020-05-05 | Renville | Minnesota | 27129 | 5 | 0 |
116661 | 116661 | 2020-05-05 | Rice | Minnesota | 27131 | 30 | 1 |
116662 | 116662 | 2020-05-05 | Rock | Minnesota | 27133 | 18 | 0 |
116663 | 116663 | 2020-05-05 | Roseau | Minnesota | 27135 | 1 | 0 |
116664 | 116664 | 2020-05-05 | Scott | Minnesota | 27139 | 74 | 1 |
116665 | 116665 | 2020-05-05 | Sherburne | Minnesota | 27141 | 71 | 1 |
116666 | 116666 | 2020-05-05 | Sibley | Minnesota | 27143 | 2 | 0 |
116667 | 116667 | 2020-05-05 | St. Louis | Minnesota | 27137 | 81 | 11 |
116668 | 116668 | 2020-05-05 | Stearns | Minnesota | 27145 | 815 | 2 |
116669 | 116669 | 2020-05-05 | Steele | Minnesota | 27147 | 25 | 0 |
116670 | 116670 | 2020-05-05 | Swift | Minnesota | 27151 | 2 | 0 |
116671 | 116671 | 2020-05-05 | Todd | Minnesota | 27153 | 15 | 0 |
116672 | 116672 | 2020-05-05 | Traverse | Minnesota | 27155 | 2 | 0 |
116673 | 116673 | 2020-05-05 | Unknown | Minnesota | 20 | 1 | |
116674 | 116674 | 2020-05-05 | Wabasha | Minnesota | 27157 | 10 | 0 |
116675 | 116675 | 2020-05-05 | Wadena | Minnesota | 27159 | 3 | 0 |
116676 | 116676 | 2020-05-05 | Waseca | Minnesota | 27161 | 6 | 0 |
116677 | 116677 | 2020-05-05 | Washington | Minnesota | 27163 | 162 | 12 |
116678 | 116678 | 2020-05-05 | Watonwan | Minnesota | 27165 | 15 | 0 |
116679 | 116679 | 2020-05-05 | Wilkin | Minnesota | 27167 | 12 | 3 |
116680 | 116680 | 2020-05-05 | Winona | Minnesota | 27169 | 68 | 15 |
116681 | 116681 | 2020-05-05 | Wright | Minnesota | 27171 | 60 | 1 |
116682 | 116682 | 2020-05-05 | 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);