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 2021-09-04 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1684736 | 1684736 | 2021-09-04 | Aitkin | Minnesota | 27001 | 1494 | 38 |
1684737 | 1684737 | 2021-09-04 | Anoka | Minnesota | 27003 | 46303 | 473 |
1684738 | 1684738 | 2021-09-04 | Becker | Minnesota | 27005 | 4099 | 58 |
1684739 | 1684739 | 2021-09-04 | Beltrami | Minnesota | 27007 | 4659 | 69 |
1684740 | 1684740 | 2021-09-04 | Benton | Minnesota | 27009 | 6163 | 98 |
1684741 | 1684741 | 2021-09-04 | Big Stone | Minnesota | 27011 | 644 | 4 |
1684742 | 1684742 | 2021-09-04 | Blue Earth | Minnesota | 27013 | 8263 | 47 |
1684743 | 1684743 | 2021-09-04 | Brown | Minnesota | 27015 | 3320 | 42 |
1684744 | 1684744 | 2021-09-04 | Carlton | Minnesota | 27017 | 3765 | 59 |
1684745 | 1684745 | 2021-09-04 | Carver | Minnesota | 27019 | 11608 | 51 |
1684746 | 1684746 | 2021-09-04 | Cass | Minnesota | 27021 | 3183 | 34 |
1684747 | 1684747 | 2021-09-04 | Chippewa | Minnesota | 27023 | 1653 | 39 |
1684748 | 1684748 | 2021-09-04 | Chisago | Minnesota | 27025 | 6766 | 56 |
1684749 | 1684749 | 2021-09-04 | Clay | Minnesota | 27027 | 8721 | 92 |
1684750 | 1684750 | 2021-09-04 | Clearwater | Minnesota | 27029 | 965 | 18 |
1684751 | 1684751 | 2021-09-04 | Cook | Minnesota | 27031 | 199 | 0 |
1684752 | 1684752 | 2021-09-04 | Cottonwood | Minnesota | 27033 | 1736 | 24 |
1684753 | 1684753 | 2021-09-04 | Crow Wing | Minnesota | 27035 | 7438 | 100 |
1684754 | 1684754 | 2021-09-04 | Dakota | Minnesota | 27037 | 50330 | 489 |
1684755 | 1684755 | 2021-09-04 | Dodge | Minnesota | 27039 | 2265 | 3 |
1684756 | 1684756 | 2021-09-04 | Douglas | Minnesota | 27041 | 5131 | 83 |
1684757 | 1684757 | 2021-09-04 | Faribault | Minnesota | 27043 | 1692 | 22 |
1684758 | 1684758 | 2021-09-04 | Fillmore | Minnesota | 27045 | 1798 | 10 |
1684759 | 1684759 | 2021-09-04 | Freeborn | Minnesota | 27047 | 4021 | 37 |
1684760 | 1684760 | 2021-09-04 | Goodhue | Minnesota | 27049 | 5309 | 76 |
1684761 | 1684761 | 2021-09-04 | Grant | Minnesota | 27051 | 630 | 8 |
1684762 | 1684762 | 2021-09-04 | Hennepin | Minnesota | 27053 | 135989 | 1839 |
1684763 | 1684763 | 2021-09-04 | Houston | Minnesota | 27055 | 1937 | 16 |
1684764 | 1684764 | 2021-09-04 | Hubbard | Minnesota | 27057 | 2155 | 41 |
1684765 | 1684765 | 2021-09-04 | Isanti | Minnesota | 27059 | 4737 | 69 |
1684766 | 1684766 | 2021-09-04 | Itasca | Minnesota | 27061 | 4952 | 70 |
1684767 | 1684767 | 2021-09-04 | Jackson | Minnesota | 27063 | 1323 | 12 |
1684768 | 1684768 | 2021-09-04 | Kanabec | Minnesota | 27065 | 1586 | 29 |
1684769 | 1684769 | 2021-09-04 | Kandiyohi | Minnesota | 27067 | 7228 | 88 |
1684770 | 1684770 | 2021-09-04 | Kittson | Minnesota | 27069 | 512 | 22 |
1684771 | 1684771 | 2021-09-04 | Koochiching | Minnesota | 27071 | 1038 | 19 |
1684772 | 1684772 | 2021-09-04 | Lac qui Parle | Minnesota | 27073 | 811 | 22 |
1684773 | 1684773 | 2021-09-04 | Lake | Minnesota | 27075 | 886 | 21 |
1684774 | 1684774 | 2021-09-04 | Lake of the Woods | Minnesota | 27077 | 370 | 4 |
1684775 | 1684775 | 2021-09-04 | Le Sueur | Minnesota | 27079 | 3257 | 29 |
1684776 | 1684776 | 2021-09-04 | Lincoln | Minnesota | 27081 | 613 | 4 |
1684777 | 1684777 | 2021-09-04 | Lyon | Minnesota | 27083 | 3814 | 54 |
1684778 | 1684778 | 2021-09-04 | Mahnomen | Minnesota | 27087 | 628 | 9 |
1684779 | 1684779 | 2021-09-04 | Marshall | Minnesota | 27089 | 974 | 18 |
1684780 | 1684780 | 2021-09-04 | Martin | Minnesota | 27091 | 2504 | 33 |
1684781 | 1684781 | 2021-09-04 | McLeod | Minnesota | 27085 | 4722 | 61 |
1684782 | 1684782 | 2021-09-04 | Meeker | Minnesota | 27093 | 2913 | 46 |
1684783 | 1684783 | 2021-09-04 | Mille Lacs | Minnesota | 27095 | 3408 | 59 |
1684784 | 1684784 | 2021-09-04 | Morrison | Minnesota | 27097 | 4518 | 62 |
1684785 | 1684785 | 2021-09-04 | Mower | Minnesota | 27099 | 5283 | 34 |
1684786 | 1684786 | 2021-09-04 | Murray | Minnesota | 27101 | 1120 | 10 |
1684787 | 1684787 | 2021-09-04 | Nicollet | Minnesota | 27103 | 3571 | 47 |
1684788 | 1684788 | 2021-09-04 | Nobles | Minnesota | 27105 | 4350 | 50 |
1684789 | 1684789 | 2021-09-04 | Norman | Minnesota | 27107 | 598 | 9 |
1684790 | 1684790 | 2021-09-04 | Olmsted | Minnesota | 27109 | 15101 | 108 |
1684791 | 1684791 | 2021-09-04 | Otter Tail | Minnesota | 27111 | 6385 | 89 |
1684792 | 1684792 | 2021-09-04 | Pennington | Minnesota | 27113 | 1798 | 20 |
1684793 | 1684793 | 2021-09-04 | Pine | Minnesota | 27115 | 3623 | 23 |
1684794 | 1684794 | 2021-09-04 | Pipestone | Minnesota | 27117 | 1210 | 26 |
1684795 | 1684795 | 2021-09-04 | Polk | Minnesota | 27119 | 4138 | 75 |
1684796 | 1684796 | 2021-09-04 | Pope | Minnesota | 27121 | 1245 | 8 |
1684797 | 1684797 | 2021-09-04 | Ramsey | Minnesota | 27123 | 56793 | 930 |
1684798 | 1684798 | 2021-09-04 | Red Lake | Minnesota | 27125 | 450 | 7 |
1684799 | 1684799 | 2021-09-04 | Redwood | Minnesota | 27127 | 1892 | 41 |
1684800 | 1684800 | 2021-09-04 | Renville | Minnesota | 27129 | 1931 | 46 |
1684801 | 1684801 | 2021-09-04 | Rice | Minnesota | 27131 | 8800 | 115 |
1684802 | 1684802 | 2021-09-04 | Rock | Minnesota | 27133 | 1360 | 19 |
1684803 | 1684803 | 2021-09-04 | Roseau | Minnesota | 27135 | 2228 | 21 |
1684804 | 1684804 | 2021-09-04 | Scott | Minnesota | 27139 | 18907 | 141 |
1684805 | 1684805 | 2021-09-04 | Sherburne | Minnesota | 27141 | 12969 | 99 |
1684806 | 1684806 | 2021-09-04 | Sibley | Minnesota | 27143 | 1658 | 10 |
1684807 | 1684807 | 2021-09-04 | St. Louis | Minnesota | 27137 | 19376 | 326 |
1684808 | 1684808 | 2021-09-04 | Stearns | Minnesota | 27145 | 24007 | 234 |
1684809 | 1684809 | 2021-09-04 | Steele | Minnesota | 27147 | 4624 | 21 |
1684810 | 1684810 | 2021-09-04 | Stevens | Minnesota | 27149 | 989 | 11 |
1684811 | 1684811 | 2021-09-04 | Swift | Minnesota | 27151 | 1149 | 18 |
1684812 | 1684812 | 2021-09-04 | Todd | Minnesota | 27153 | 3078 | 34 |
1684813 | 1684813 | 2021-09-04 | Traverse | Minnesota | 27155 | 406 | 5 |
1684814 | 1684814 | 2021-09-04 | Unknown | Minnesota | 588 | 93 | |
1684815 | 1684815 | 2021-09-04 | Wabasha | Minnesota | 27157 | 2298 | 4 |
1684816 | 1684816 | 2021-09-04 | Wadena | Minnesota | 27159 | 1734 | 23 |
1684817 | 1684817 | 2021-09-04 | Waseca | Minnesota | 27161 | 2726 | 23 |
1684818 | 1684818 | 2021-09-04 | Washington | Minnesota | 27163 | 29609 | 305 |
1684819 | 1684819 | 2021-09-04 | Watonwan | Minnesota | 27165 | 1467 | 10 |
1684820 | 1684820 | 2021-09-04 | Wilkin | Minnesota | 27167 | 877 | 14 |
1684821 | 1684821 | 2021-09-04 | Winona | Minnesota | 27169 | 5225 | 52 |
1684822 | 1684822 | 2021-09-04 | Wright | Minnesota | 27171 | 17714 | 159 |
1684823 | 1684823 | 2021-09-04 | Yellow Medicine | Minnesota | 27173 | 1204 | 20 |
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);