ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where date = "2020-08-24" 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 |
---|---|---|---|---|---|---|---|
464606 | 464606 | 2020-08-24 | Aitkin | Minnesota | 27001 | 45 | 1 |
464607 | 464607 | 2020-08-24 | Anoka | Minnesota | 27003 | 4386 | 117 |
464608 | 464608 | 2020-08-24 | Becker | Minnesota | 27005 | 178 | 1 |
464609 | 464609 | 2020-08-24 | Beltrami | Minnesota | 27007 | 296 | 1 |
464610 | 464610 | 2020-08-24 | Benton | Minnesota | 27009 | 354 | 3 |
464611 | 464611 | 2020-08-24 | Big Stone | Minnesota | 27011 | 31 | 0 |
464612 | 464612 | 2020-08-24 | Blue Earth | Minnesota | 27013 | 1057 | 5 |
464613 | 464613 | 2020-08-24 | Brown | Minnesota | 27015 | 110 | 2 |
464614 | 464614 | 2020-08-24 | Carlton | Minnesota | 27017 | 171 | 1 |
464615 | 464615 | 2020-08-24 | Carver | Minnesota | 27019 | 1040 | 4 |
464616 | 464616 | 2020-08-24 | Cass | Minnesota | 27021 | 92 | 3 |
464617 | 464617 | 2020-08-24 | Chippewa | Minnesota | 27023 | 129 | 1 |
464618 | 464618 | 2020-08-24 | Chisago | Minnesota | 27025 | 277 | 1 |
464619 | 464619 | 2020-08-24 | Clay | Minnesota | 27027 | 830 | 40 |
464620 | 464620 | 2020-08-24 | Clearwater | Minnesota | 27029 | 17 | 0 |
464621 | 464621 | 2020-08-24 | Cook | Minnesota | 27031 | 6 | 0 |
464622 | 464622 | 2020-08-24 | Cottonwood | Minnesota | 27033 | 194 | 0 |
464623 | 464623 | 2020-08-24 | Crow Wing | Minnesota | 27035 | 290 | 16 |
464624 | 464624 | 2020-08-24 | Dakota | Minnesota | 27037 | 5337 | 110 |
464625 | 464625 | 2020-08-24 | Dodge | Minnesota | 27039 | 148 | 0 |
464626 | 464626 | 2020-08-24 | Douglas | Minnesota | 27041 | 147 | 1 |
464627 | 464627 | 2020-08-24 | Faribault | Minnesota | 27043 | 108 | 0 |
464628 | 464628 | 2020-08-24 | Fillmore | Minnesota | 27045 | 80 | 0 |
464629 | 464629 | 2020-08-24 | Freeborn | Minnesota | 27047 | 389 | 1 |
464630 | 464630 | 2020-08-24 | Goodhue | Minnesota | 27049 | 241 | 9 |
464631 | 464631 | 2020-08-24 | Grant | Minnesota | 27051 | 55 | 4 |
464632 | 464632 | 2020-08-24 | Hennepin | Minnesota | 27053 | 21846 | 867 |
464633 | 464633 | 2020-08-24 | Houston | Minnesota | 27055 | 65 | 0 |
464634 | 464634 | 2020-08-24 | Hubbard | Minnesota | 27057 | 42 | 0 |
464635 | 464635 | 2020-08-24 | Isanti | Minnesota | 27059 | 166 | 0 |
464636 | 464636 | 2020-08-24 | Itasca | Minnesota | 27061 | 166 | 12 |
464637 | 464637 | 2020-08-24 | Jackson | Minnesota | 27063 | 91 | 0 |
464638 | 464638 | 2020-08-24 | Kanabec | Minnesota | 27065 | 62 | 4 |
464639 | 464639 | 2020-08-24 | Kandiyohi | Minnesota | 27067 | 779 | 1 |
464640 | 464640 | 2020-08-24 | Kittson | Minnesota | 27069 | 3 | 0 |
464641 | 464641 | 2020-08-24 | Koochiching | Minnesota | 27071 | 85 | 3 |
464642 | 464642 | 2020-08-24 | Lac qui Parle | Minnesota | 27073 | 13 | 0 |
464643 | 464643 | 2020-08-24 | Lake | Minnesota | 27075 | 27 | 0 |
464644 | 464644 | 2020-08-24 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
464645 | 464645 | 2020-08-24 | Le Sueur | Minnesota | 27079 | 326 | 2 |
464646 | 464646 | 2020-08-24 | Lincoln | Minnesota | 27081 | 63 | 0 |
464647 | 464647 | 2020-08-24 | Lyon | Minnesota | 27083 | 445 | 3 |
464648 | 464648 | 2020-08-24 | Mahnomen | Minnesota | 27087 | 32 | 1 |
464649 | 464649 | 2020-08-24 | Marshall | Minnesota | 27089 | 31 | 0 |
464650 | 464650 | 2020-08-24 | Martin | Minnesota | 27091 | 219 | 6 |
464651 | 464651 | 2020-08-24 | McLeod | Minnesota | 27085 | 307 | 1 |
464652 | 464652 | 2020-08-24 | Meeker | Minnesota | 27093 | 94 | 2 |
464653 | 464653 | 2020-08-24 | Mille Lacs | Minnesota | 27095 | 87 | 3 |
464654 | 464654 | 2020-08-24 | Morrison | Minnesota | 27097 | 108 | 1 |
464655 | 464655 | 2020-08-24 | Mower | Minnesota | 27099 | 1162 | 3 |
464656 | 464656 | 2020-08-24 | Murray | Minnesota | 27101 | 137 | 1 |
464657 | 464657 | 2020-08-24 | Nicollet | Minnesota | 27103 | 412 | 14 |
464658 | 464658 | 2020-08-24 | Nobles | Minnesota | 27105 | 1827 | 11 |
464659 | 464659 | 2020-08-24 | Norman | Minnesota | 27107 | 45 | 0 |
464660 | 464660 | 2020-08-24 | Olmsted | Minnesota | 27109 | 1919 | 24 |
464661 | 464661 | 2020-08-24 | Otter Tail | Minnesota | 27111 | 245 | 4 |
464662 | 464662 | 2020-08-24 | Pennington | Minnesota | 27113 | 76 | 1 |
464663 | 464663 | 2020-08-24 | Pine | Minnesota | 27115 | 139 | 0 |
464664 | 464664 | 2020-08-24 | Pipestone | Minnesota | 27117 | 174 | 9 |
464665 | 464665 | 2020-08-24 | Polk | Minnesota | 27119 | 179 | 4 |
464666 | 464666 | 2020-08-24 | Pope | Minnesota | 27121 | 58 | 0 |
464667 | 464667 | 2020-08-24 | Ramsey | Minnesota | 27123 | 8678 | 286 |
464668 | 464668 | 2020-08-24 | Red Lake | Minnesota | 27125 | 28 | 0 |
464669 | 464669 | 2020-08-24 | Redwood | Minnesota | 27127 | 47 | 0 |
464670 | 464670 | 2020-08-24 | Renville | Minnesota | 27129 | 72 | 6 |
464671 | 464671 | 2020-08-24 | Rice | Minnesota | 27131 | 1147 | 8 |
464672 | 464672 | 2020-08-24 | Rock | Minnesota | 27133 | 99 | 0 |
464673 | 464673 | 2020-08-24 | Roseau | Minnesota | 27135 | 64 | 0 |
464674 | 464674 | 2020-08-24 | Scott | Minnesota | 27139 | 1859 | 28 |
464675 | 464675 | 2020-08-24 | Sherburne | Minnesota | 27141 | 835 | 12 |
464676 | 464676 | 2020-08-24 | Sibley | Minnesota | 27143 | 116 | 2 |
464677 | 464677 | 2020-08-24 | St. Louis | Minnesota | 27137 | 768 | 22 |
464678 | 464678 | 2020-08-24 | Stearns | Minnesota | 27145 | 3106 | 21 |
464679 | 464679 | 2020-08-24 | Steele | Minnesota | 27147 | 399 | 2 |
464680 | 464680 | 2020-08-24 | Stevens | Minnesota | 27149 | 28 | 0 |
464681 | 464681 | 2020-08-24 | Swift | Minnesota | 27151 | 60 | 1 |
464682 | 464682 | 2020-08-24 | Todd | Minnesota | 27153 | 443 | 2 |
464683 | 464683 | 2020-08-24 | Traverse | Minnesota | 27155 | 21 | 0 |
464684 | 464684 | 2020-08-24 | Unknown | Minnesota | 173 | 46 | |
464685 | 464685 | 2020-08-24 | Wabasha | Minnesota | 27157 | 111 | 0 |
464686 | 464686 | 2020-08-24 | Wadena | Minnesota | 27159 | 44 | 0 |
464687 | 464687 | 2020-08-24 | Waseca | Minnesota | 27161 | 219 | 2 |
464688 | 464688 | 2020-08-24 | Washington | Minnesota | 27163 | 2663 | 51 |
464689 | 464689 | 2020-08-24 | Watonwan | Minnesota | 27165 | 404 | 3 |
464690 | 464690 | 2020-08-24 | Wilkin | Minnesota | 27167 | 45 | 3 |
464691 | 464691 | 2020-08-24 | Winona | Minnesota | 27169 | 302 | 17 |
464692 | 464692 | 2020-08-24 | Wright | Minnesota | 27171 | 1102 | 6 |
464693 | 464693 | 2020-08-24 | Yellow Medicine | Minnesota | 27173 | 66 | 1 |
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);