ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where "date" is on date 2020-10-18 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
642704 | 642704 | 2020-10-18 | Aitkin | Minnesota | 27001 | 151 | 1 |
642705 | 642705 | 2020-10-18 | Anoka | Minnesota | 27003 | 7955 | 148 |
642706 | 642706 | 2020-10-18 | Becker | Minnesota | 27005 | 483 | 3 |
642707 | 642707 | 2020-10-18 | Beltrami | Minnesota | 27007 | 753 | 7 |
642708 | 642708 | 2020-10-18 | Benton | Minnesota | 27009 | 826 | 5 |
642709 | 642709 | 2020-10-18 | Big Stone | Minnesota | 27011 | 127 | 0 |
642710 | 642710 | 2020-10-18 | Blue Earth | Minnesota | 27013 | 1958 | 7 |
642711 | 642711 | 2020-10-18 | Brown | Minnesota | 27015 | 290 | 3 |
642712 | 642712 | 2020-10-18 | Carlton | Minnesota | 27017 | 372 | 1 |
642713 | 642713 | 2020-10-18 | Carver | Minnesota | 27019 | 1686 | 7 |
642714 | 642714 | 2020-10-18 | Cass | Minnesota | 27021 | 304 | 5 |
642715 | 642715 | 2020-10-18 | Chippewa | Minnesota | 27023 | 373 | 3 |
642716 | 642716 | 2020-10-18 | Chisago | Minnesota | 27025 | 831 | 2 |
642717 | 642717 | 2020-10-18 | Clay | Minnesota | 27027 | 2008 | 43 |
642718 | 642718 | 2020-10-18 | Clearwater | Minnesota | 27029 | 74 | 0 |
642719 | 642719 | 2020-10-18 | Cook | Minnesota | 27031 | 11 | 0 |
642720 | 642720 | 2020-10-18 | Cottonwood | Minnesota | 27033 | 261 | 0 |
642721 | 642721 | 2020-10-18 | Crow Wing | Minnesota | 27035 | 868 | 21 |
642722 | 642722 | 2020-10-18 | Dakota | Minnesota | 27037 | 9146 | 133 |
642723 | 642723 | 2020-10-18 | Dodge | Minnesota | 27039 | 360 | 0 |
642724 | 642724 | 2020-10-18 | Douglas | Minnesota | 27041 | 592 | 3 |
642725 | 642725 | 2020-10-18 | Faribault | Minnesota | 27043 | 208 | 0 |
642726 | 642726 | 2020-10-18 | Fillmore | Minnesota | 27045 | 235 | 0 |
642727 | 642727 | 2020-10-18 | Freeborn | Minnesota | 27047 | 631 | 4 |
642728 | 642728 | 2020-10-18 | Goodhue | Minnesota | 27049 | 497 | 11 |
642729 | 642729 | 2020-10-18 | Grant | Minnesota | 27051 | 86 | 4 |
642730 | 642730 | 2020-10-18 | Hennepin | Minnesota | 27053 | 32050 | 965 |
642731 | 642731 | 2020-10-18 | Houston | Minnesota | 27055 | 180 | 1 |
642732 | 642732 | 2020-10-18 | Hubbard | Minnesota | 27057 | 301 | 2 |
642733 | 642733 | 2020-10-18 | Isanti | Minnesota | 27059 | 480 | 3 |
642734 | 642734 | 2020-10-18 | Itasca | Minnesota | 27061 | 671 | 17 |
642735 | 642735 | 2020-10-18 | Jackson | Minnesota | 27063 | 189 | 1 |
642736 | 642736 | 2020-10-18 | Kanabec | Minnesota | 27065 | 187 | 10 |
642737 | 642737 | 2020-10-18 | Kandiyohi | Minnesota | 27067 | 1519 | 4 |
642738 | 642738 | 2020-10-18 | Kittson | Minnesota | 27069 | 27 | 0 |
642739 | 642739 | 2020-10-18 | Koochiching | Minnesota | 27071 | 160 | 4 |
642740 | 642740 | 2020-10-18 | Lac qui Parle | Minnesota | 27073 | 122 | 2 |
642741 | 642741 | 2020-10-18 | Lake | Minnesota | 27075 | 100 | 0 |
642742 | 642742 | 2020-10-18 | Lake of the Woods | Minnesota | 27077 | 40 | 1 |
642743 | 642743 | 2020-10-18 | Le Sueur | Minnesota | 27079 | 582 | 5 |
642744 | 642744 | 2020-10-18 | Lincoln | Minnesota | 27081 | 164 | 0 |
642745 | 642745 | 2020-10-18 | Lyon | Minnesota | 27083 | 914 | 6 |
642746 | 642746 | 2020-10-18 | Mahnomen | Minnesota | 27087 | 91 | 1 |
642747 | 642747 | 2020-10-18 | Marshall | Minnesota | 27089 | 86 | 1 |
642748 | 642748 | 2020-10-18 | Martin | Minnesota | 27091 | 584 | 16 |
642749 | 642749 | 2020-10-18 | McLeod | Minnesota | 27085 | 566 | 3 |
642750 | 642750 | 2020-10-18 | Meeker | Minnesota | 27093 | 304 | 3 |
642751 | 642751 | 2020-10-18 | Mille Lacs | Minnesota | 27095 | 346 | 7 |
642752 | 642752 | 2020-10-18 | Morrison | Minnesota | 27097 | 577 | 6 |
642753 | 642753 | 2020-10-18 | Mower | Minnesota | 27099 | 1489 | 12 |
642754 | 642754 | 2020-10-18 | Murray | Minnesota | 27101 | 244 | 3 |
642755 | 642755 | 2020-10-18 | Nicollet | Minnesota | 27103 | 664 | 17 |
642756 | 642756 | 2020-10-18 | Nobles | Minnesota | 27105 | 2117 | 16 |
642757 | 642757 | 2020-10-18 | Norman | Minnesota | 27107 | 93 | 0 |
642758 | 642758 | 2020-10-18 | Olmsted | Minnesota | 27109 | 3050 | 29 |
642759 | 642759 | 2020-10-18 | Otter Tail | Minnesota | 27111 | 720 | 6 |
642760 | 642760 | 2020-10-18 | Pennington | Minnesota | 27113 | 162 | 1 |
642761 | 642761 | 2020-10-18 | Pine | Minnesota | 27115 | 504 | 0 |
642762 | 642762 | 2020-10-18 | Pipestone | Minnesota | 27117 | 324 | 16 |
642763 | 642763 | 2020-10-18 | Polk | Minnesota | 27119 | 489 | 4 |
642764 | 642764 | 2020-10-18 | Pope | Minnesota | 27121 | 142 | 0 |
642765 | 642765 | 2020-10-18 | Ramsey | Minnesota | 27123 | 13185 | 346 |
642766 | 642766 | 2020-10-18 | Red Lake | Minnesota | 27125 | 56 | 2 |
642767 | 642767 | 2020-10-18 | Redwood | Minnesota | 27127 | 248 | 10 |
642768 | 642768 | 2020-10-18 | Renville | Minnesota | 27129 | 225 | 11 |
642769 | 642769 | 2020-10-18 | Rice | Minnesota | 27131 | 1562 | 9 |
642770 | 642770 | 2020-10-18 | Rock | Minnesota | 27133 | 286 | 1 |
642771 | 642771 | 2020-10-18 | Roseau | Minnesota | 27135 | 189 | 0 |
642772 | 642772 | 2020-10-18 | Scott | Minnesota | 27139 | 3156 | 34 |
642773 | 642773 | 2020-10-18 | Sherburne | Minnesota | 27141 | 1532 | 21 |
642774 | 642774 | 2020-10-18 | Sibley | Minnesota | 27143 | 235 | 3 |
642775 | 642775 | 2020-10-18 | St. Louis | Minnesota | 27137 | 2585 | 63 |
642776 | 642776 | 2020-10-18 | Stearns | Minnesota | 27145 | 5255 | 34 |
642777 | 642777 | 2020-10-18 | Steele | Minnesota | 27147 | 716 | 2 |
642778 | 642778 | 2020-10-18 | Stevens | Minnesota | 27149 | 163 | 1 |
642779 | 642779 | 2020-10-18 | Swift | Minnesota | 27151 | 191 | 1 |
642780 | 642780 | 2020-10-18 | Todd | Minnesota | 27153 | 692 | 2 |
642781 | 642781 | 2020-10-18 | Traverse | Minnesota | 27155 | 49 | 0 |
642782 | 642782 | 2020-10-18 | Unknown | Minnesota | 273 | 53 | |
642783 | 642783 | 2020-10-18 | Wabasha | Minnesota | 27157 | 320 | 0 |
642784 | 642784 | 2020-10-18 | Wadena | Minnesota | 27159 | 179 | 0 |
642785 | 642785 | 2020-10-18 | Waseca | Minnesota | 27161 | 908 | 9 |
642786 | 642786 | 2020-10-18 | Washington | Minnesota | 27163 | 5172 | 67 |
642787 | 642787 | 2020-10-18 | Watonwan | Minnesota | 27165 | 563 | 4 |
642788 | 642788 | 2020-10-18 | Wilkin | Minnesota | 27167 | 122 | 4 |
642789 | 642789 | 2020-10-18 | Winona | Minnesota | 27169 | 1167 | 18 |
642790 | 642790 | 2020-10-18 | Wright | Minnesota | 27171 | 2247 | 14 |
642791 | 642791 | 2020-10-18 | Yellow Medicine | Minnesota | 27173 | 265 | 5 |
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);