ny_times_us_counties

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

8,848 rows where state = "Minnesota" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date)

fips

county

state

  • Minnesota · 8,848 ✖
Link rowid date ▲ county state fips cases deaths
317759 317759 2020-07-11 Aitkin Minnesota 27001 15 0
317760 317760 2020-07-11 Anoka Minnesota 27003 2393 111
317761 317761 2020-07-11 Becker Minnesota 27005 62 0
317762 317762 2020-07-11 Beltrami Minnesota 27007 47 0
317763 317763 2020-07-11 Benton Minnesota 27009 236 3
317764 317764 2020-07-11 Big Stone Minnesota 27011 17 0
317765 317765 2020-07-11 Blue Earth Minnesota 27013 563 2
317766 317766 2020-07-11 Brown Minnesota 27015 44 2
317767 317767 2020-07-11 Carlton Minnesota 27017 90 0
317768 317768 2020-07-11 Carver Minnesota 27019 469 1
317769 317769 2020-07-11 Cass Minnesota 27021 19 2
317770 317770 2020-07-11 Chippewa Minnesota 27023 80 1
317771 317771 2020-07-11 Chisago Minnesota 27025 107 1
317772 317772 2020-07-11 Clay Minnesota 27027 612 38
317773 317773 2020-07-11 Clearwater Minnesota 27029 12 0
317774 317774 2020-07-11 Cook Minnesota 27031 1 0
317775 317775 2020-07-11 Cottonwood Minnesota 27033 142 0
317776 317776 2020-07-11 Crow Wing Minnesota 27035 113 12
317777 317777 2020-07-11 Dakota Minnesota 27037 2655 96
317778 317778 2020-07-11 Dodge Minnesota 27039 96 0
317779 317779 2020-07-11 Douglas Minnesota 27041 70 0
317780 317780 2020-07-11 Faribault Minnesota 27043 61 0
317781 317781 2020-07-11 Fillmore Minnesota 27045 35 0
317782 317782 2020-07-11 Freeborn Minnesota 27047 312 0
317783 317783 2020-07-11 Goodhue Minnesota 27049 140 8
317784 317784 2020-07-11 Grant Minnesota 27051 25 0
317785 317785 2020-07-11 Hennepin Minnesota 27053 13328 790
317786 317786 2020-07-11 Houston Minnesota 27055 32 0
317787 317787 2020-07-11 Hubbard Minnesota 27057 10 0
317788 317788 2020-07-11 Isanti Minnesota 27059 81 0
317789 317789 2020-07-11 Itasca Minnesota 27061 71 12
317790 317790 2020-07-11 Jackson Minnesota 27063 57 0
317791 317791 2020-07-11 Kanabec Minnesota 27065 17 1
317792 317792 2020-07-11 Kandiyohi Minnesota 27067 590 1
317793 317793 2020-07-11 Kittson Minnesota 27069 2 0
317794 317794 2020-07-11 Koochiching Minnesota 27071 21 1
317795 317795 2020-07-11 Lac qui Parle Minnesota 27073 5 0
317796 317796 2020-07-11 Lake Minnesota 27075 6 0
317797 317797 2020-07-11 Le Sueur Minnesota 27079 125 1
317798 317798 2020-07-11 Lincoln Minnesota 27081 17 0
317799 317799 2020-07-11 Lyon Minnesota 27083 333 2
317800 317800 2020-07-11 Mahnomen Minnesota 27087 10 1
317801 317801 2020-07-11 Marshall Minnesota 27089 13 0
317802 317802 2020-07-11 Martin Minnesota 27091 175 5
317803 317803 2020-07-11 McLeod Minnesota 27085 100 0
317804 317804 2020-07-11 Meeker Minnesota 27093 62 1
317805 317805 2020-07-11 Mille Lacs Minnesota 27095 39 2
317806 317806 2020-07-11 Morrison Minnesota 27097 64 1
317807 317807 2020-07-11 Mower Minnesota 27099 982 2
317808 317808 2020-07-11 Murray Minnesota 27101 73 0
317809 317809 2020-07-11 Nicollet Minnesota 27103 203 12
317810 317810 2020-07-11 Nobles Minnesota 27105 1684 6
317811 317811 2020-07-11 Norman Minnesota 27107 21 0
317812 317812 2020-07-11 Olmsted Minnesota 27109 1259 20
317813 317813 2020-07-11 Otter Tail Minnesota 27111 111 1
317814 317814 2020-07-11 Pennington Minnesota 27113 53 0
317815 317815 2020-07-11 Pine Minnesota 27115 112 0
317816 317816 2020-07-11 Pipestone Minnesota 27117 69 4
317817 317817 2020-07-11 Polk Minnesota 27119 88 3
317818 317818 2020-07-11 Pope Minnesota 27121 13 0
317819 317819 2020-07-11 Ramsey Minnesota 27123 5169 232
317820 317820 2020-07-11 Red Lake Minnesota 27125 4 0
317821 317821 2020-07-11 Redwood Minnesota 27127 23 0
317822 317822 2020-07-11 Renville Minnesota 27129 37 2
317823 317823 2020-07-11 Rice Minnesota 27131 879 8
317824 317824 2020-07-11 Rock Minnesota 27133 34 0
317825 317825 2020-07-11 Roseau Minnesota 27135 25 0
317826 317826 2020-07-11 Scott Minnesota 27139 858 4
317827 317827 2020-07-11 Sherburne Minnesota 27141 362 5
317828 317828 2020-07-11 Sibley Minnesota 27143 58 2
317829 317829 2020-07-11 St. Louis Minnesota 27137 223 16
317830 317830 2020-07-11 Stearns Minnesota 27145 2496 19
317831 317831 2020-07-11 Steele Minnesota 27147 245 1
317832 317832 2020-07-11 Stevens Minnesota 27149 11 0
317833 317833 2020-07-11 Swift Minnesota 27151 33 1
317834 317834 2020-07-11 Todd Minnesota 27153 402 2
317835 317835 2020-07-11 Traverse Minnesota 27155 6 0
317836 317836 2020-07-11 Unknown Minnesota   126 38
317837 317837 2020-07-11 Wabasha Minnesota 27157 38 0
317838 317838 2020-07-11 Wadena Minnesota 27159 17 0
317839 317839 2020-07-11 Waseca Minnesota 27161 77 0
317840 317840 2020-07-11 Washington Minnesota 27163 1255 41
317841 317841 2020-07-11 Watonwan Minnesota 27165 267 0
317842 317842 2020-07-11 Wilkin Minnesota 27167 22 3
317843 317843 2020-07-11 Winona Minnesota 27169 141 15
317844 317844 2020-07-11 Wright Minnesota 27171 528 5
317845 317845 2020-07-11 Yellow Medicine Minnesota 27173 31 0
314661 314661 2020-07-10 Aitkin Minnesota 27001 15 0
314662 314662 2020-07-10 Anoka Minnesota 27003 2360 111
314663 314663 2020-07-10 Becker Minnesota 27005 57 0
314664 314664 2020-07-10 Beltrami Minnesota 27007 43 0
314665 314665 2020-07-10 Benton Minnesota 27009 235 3
314666 314666 2020-07-10 Big Stone Minnesota 27011 17 0
314667 314667 2020-07-10 Blue Earth Minnesota 27013 544 2
314668 314668 2020-07-10 Brown Minnesota 27015 43 2
314669 314669 2020-07-10 Carlton Minnesota 27017 89 0
314670 314670 2020-07-10 Carver Minnesota 27019 442 1
314671 314671 2020-07-10 Cass Minnesota 27021 19 2
314672 314672 2020-07-10 Chippewa Minnesota 27023 79 1
314673 314673 2020-07-10 Chisago Minnesota 27025 105 1

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
Powered by Datasette · Query took 1036.342ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette