ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67,883 rows where state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 27123 147
- 27019 144
- 27003 142
- 27109 142
- 27037 141
- 27053 141
- 27145 141
- 27171 140
- 27129 139
- 27161 138
- 27163 138
- 27009 136
- 27013 136
- 27091 136
- 27103 136
- 27131 135
- 27099 134
- 27139 134
- 27025 133
- 27027 133
- 27045 133
- 27039 132
- 27063 132
- 27137 132
- 27147 132
- 27157 132
- 27079 131
- 27073 130
- 27141 130
- 27011 129
- …
county >30
- Ramsey 147
- Carver 144
- Anoka 142
- Olmsted 142
- Dakota 141
- Hennepin 141
- Stearns 141
- Wright 140
- Renville 139
- Waseca 138
- Washington 138
- Benton 136
- Blue Earth 136
- Martin 136
- Nicollet 136
- Rice 135
- Mower 134
- Scott 134
- Chisago 133
- Clay 133
- Fillmore 133
- Dodge 132
- Jackson 132
- St. Louis 132
- Steele 132
- Wabasha 132
- Le Sueur 131
- Lac qui Parle 130
- Sherburne 130
- Big Stone 129
- …
state 1
- Minnesota · 10,495 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
384053 | 384053 | 2020-07-30 | Chisago | Minnesota | 27025 | 160 | 1 |
384054 | 384054 | 2020-07-30 | Clay | Minnesota | 27027 | 734 | 39 |
384055 | 384055 | 2020-07-30 | Clearwater | Minnesota | 27029 | 14 | 0 |
384056 | 384056 | 2020-07-30 | Cook | Minnesota | 27031 | 2 | 0 |
384057 | 384057 | 2020-07-30 | Cottonwood | Minnesota | 27033 | 165 | 0 |
384058 | 384058 | 2020-07-30 | Crow Wing | Minnesota | 27035 | 183 | 13 |
384059 | 384059 | 2020-07-30 | Dakota | Minnesota | 27037 | 3710 | 102 |
384060 | 384060 | 2020-07-30 | Dodge | Minnesota | 27039 | 121 | 0 |
384061 | 384061 | 2020-07-30 | Douglas | Minnesota | 27041 | 120 | 0 |
384062 | 384062 | 2020-07-30 | Faribault | Minnesota | 27043 | 78 | 0 |
384063 | 384063 | 2020-07-30 | Fillmore | Minnesota | 27045 | 58 | 0 |
384064 | 384064 | 2020-07-30 | Freeborn | Minnesota | 27047 | 352 | 1 |
384065 | 384065 | 2020-07-30 | Goodhue | Minnesota | 27049 | 163 | 8 |
384066 | 384066 | 2020-07-30 | Grant | Minnesota | 27051 | 44 | 1 |
384067 | 384067 | 2020-07-30 | Hennepin | Minnesota | 27053 | 17092 | 810 |
384068 | 384068 | 2020-07-30 | Houston | Minnesota | 27055 | 37 | 0 |
384069 | 384069 | 2020-07-30 | Hubbard | Minnesota | 27057 | 25 | 0 |
384070 | 384070 | 2020-07-30 | Isanti | Minnesota | 27059 | 102 | 0 |
384071 | 384071 | 2020-07-30 | Itasca | Minnesota | 27061 | 123 | 12 |
384072 | 384072 | 2020-07-30 | Jackson | Minnesota | 27063 | 69 | 0 |
384073 | 384073 | 2020-07-30 | Kanabec | Minnesota | 27065 | 23 | 1 |
384074 | 384074 | 2020-07-30 | Kandiyohi | Minnesota | 27067 | 653 | 1 |
384075 | 384075 | 2020-07-30 | Kittson | Minnesota | 27069 | 3 | 0 |
384076 | 384076 | 2020-07-30 | Koochiching | Minnesota | 27071 | 66 | 3 |
384077 | 384077 | 2020-07-30 | Lac qui Parle | Minnesota | 27073 | 6 | 0 |
384078 | 384078 | 2020-07-30 | Lake | Minnesota | 27075 | 14 | 0 |
384079 | 384079 | 2020-07-30 | Lake of the Woods | Minnesota | 27077 | 1 | 0 |
384080 | 384080 | 2020-07-30 | Le Sueur | Minnesota | 27079 | 196 | 1 |
384081 | 384081 | 2020-07-30 | Lincoln | Minnesota | 27081 | 53 | 0 |
384082 | 384082 | 2020-07-30 | Lyon | Minnesota | 27083 | 414 | 3 |
384083 | 384083 | 2020-07-30 | Mahnomen | Minnesota | 27087 | 20 | 1 |
384084 | 384084 | 2020-07-30 | Marshall | Minnesota | 27089 | 27 | 0 |
384085 | 384085 | 2020-07-30 | Martin | Minnesota | 27091 | 198 | 5 |
384086 | 384086 | 2020-07-30 | McLeod | Minnesota | 27085 | 121 | 0 |
384087 | 384087 | 2020-07-30 | Meeker | Minnesota | 27093 | 83 | 2 |
384088 | 384088 | 2020-07-30 | Mille Lacs | Minnesota | 27095 | 53 | 3 |
384089 | 384089 | 2020-07-30 | Morrison | Minnesota | 27097 | 80 | 1 |
384090 | 384090 | 2020-07-30 | Mower | Minnesota | 27099 | 1059 | 2 |
384091 | 384091 | 2020-07-30 | Murray | Minnesota | 27101 | 119 | 1 |
384092 | 384092 | 2020-07-30 | Nicollet | Minnesota | 27103 | 287 | 13 |
384093 | 384093 | 2020-07-30 | Nobles | Minnesota | 27105 | 1737 | 6 |
384094 | 384094 | 2020-07-30 | Norman | Minnesota | 27107 | 33 | 0 |
384095 | 384095 | 2020-07-30 | Olmsted | Minnesota | 27109 | 1567 | 22 |
384096 | 384096 | 2020-07-30 | Otter Tail | Minnesota | 27111 | 162 | 3 |
384097 | 384097 | 2020-07-30 | Pennington | Minnesota | 27113 | 69 | 1 |
384098 | 384098 | 2020-07-30 | Pine | Minnesota | 27115 | 123 | 0 |
384099 | 384099 | 2020-07-30 | Pipestone | Minnesota | 27117 | 140 | 9 |
384100 | 384100 | 2020-07-30 | Polk | Minnesota | 27119 | 124 | 3 |
384101 | 384101 | 2020-07-30 | Pope | Minnesota | 27121 | 35 | 0 |
384102 | 384102 | 2020-07-30 | Ramsey | Minnesota | 27123 | 6607 | 258 |
384103 | 384103 | 2020-07-30 | Red Lake | Minnesota | 27125 | 13 | 0 |
384104 | 384104 | 2020-07-30 | Redwood | Minnesota | 27127 | 30 | 0 |
384105 | 384105 | 2020-07-30 | Renville | Minnesota | 27129 | 54 | 5 |
384106 | 384106 | 2020-07-30 | Rice | Minnesota | 27131 | 970 | 8 |
384107 | 384107 | 2020-07-30 | Rock | Minnesota | 27133 | 70 | 0 |
384108 | 384108 | 2020-07-30 | Roseau | Minnesota | 27135 | 42 | 0 |
384109 | 384109 | 2020-07-30 | Scott | Minnesota | 27139 | 1272 | 11 |
384110 | 384110 | 2020-07-30 | Sherburne | Minnesota | 27141 | 602 | 6 |
384111 | 384111 | 2020-07-30 | Sibley | Minnesota | 27143 | 76 | 2 |
384112 | 384112 | 2020-07-30 | St. Louis | Minnesota | 27137 | 366 | 18 |
384113 | 384113 | 2020-07-30 | Stearns | Minnesota | 27145 | 2763 | 20 |
384114 | 384114 | 2020-07-30 | Steele | Minnesota | 27147 | 318 | 1 |
384115 | 384115 | 2020-07-30 | Stevens | Minnesota | 27149 | 15 | 0 |
384116 | 384116 | 2020-07-30 | Swift | Minnesota | 27151 | 51 | 1 |
384117 | 384117 | 2020-07-30 | Todd | Minnesota | 27153 | 413 | 2 |
384118 | 384118 | 2020-07-30 | Traverse | Minnesota | 27155 | 10 | 0 |
384119 | 384119 | 2020-07-30 | Unknown | Minnesota | 158 | 40 | |
384120 | 384120 | 2020-07-30 | Wabasha | Minnesota | 27157 | 74 | 0 |
384121 | 384121 | 2020-07-30 | Wadena | Minnesota | 27159 | 23 | 0 |
384122 | 384122 | 2020-07-30 | Waseca | Minnesota | 27161 | 123 | 0 |
384123 | 384123 | 2020-07-30 | Washington | Minnesota | 27163 | 1792 | 43 |
384124 | 384124 | 2020-07-30 | Watonwan | Minnesota | 27165 | 298 | 0 |
384125 | 384125 | 2020-07-30 | Wilkin | Minnesota | 27167 | 25 | 3 |
384126 | 384126 | 2020-07-30 | Winona | Minnesota | 27169 | 239 | 16 |
384127 | 384127 | 2020-07-30 | Wright | Minnesota | 27171 | 759 | 5 |
384128 | 384128 | 2020-07-30 | Yellow Medicine | Minnesota | 27173 | 47 | 0 |
380824 | 380824 | 2020-07-29 | Aitkin | Minnesota | 27001 | 25 | 0 |
380825 | 380825 | 2020-07-29 | Anoka | Minnesota | 27003 | 3130 | 112 |
380826 | 380826 | 2020-07-29 | Becker | Minnesota | 27005 | 120 | 1 |
380827 | 380827 | 2020-07-29 | Beltrami | Minnesota | 27007 | 164 | 0 |
380828 | 380828 | 2020-07-29 | Benton | Minnesota | 27009 | 292 | 3 |
380829 | 380829 | 2020-07-29 | Big Stone | Minnesota | 27011 | 22 | 0 |
380830 | 380830 | 2020-07-29 | Blue Earth | Minnesota | 27013 | 794 | 4 |
380831 | 380831 | 2020-07-29 | Brown | Minnesota | 27015 | 76 | 2 |
380832 | 380832 | 2020-07-29 | Carlton | Minnesota | 27017 | 116 | 0 |
380833 | 380833 | 2020-07-29 | Carver | Minnesota | 27019 | 710 | 2 |
380834 | 380834 | 2020-07-29 | Cass | Minnesota | 27021 | 46 | 2 |
380835 | 380835 | 2020-07-29 | Chippewa | Minnesota | 27023 | 92 | 1 |
380836 | 380836 | 2020-07-29 | Chisago | Minnesota | 27025 | 158 | 1 |
380837 | 380837 | 2020-07-29 | Clay | Minnesota | 27027 | 725 | 39 |
380838 | 380838 | 2020-07-29 | Clearwater | Minnesota | 27029 | 14 | 0 |
380839 | 380839 | 2020-07-29 | Cook | Minnesota | 27031 | 2 | 0 |
380840 | 380840 | 2020-07-29 | Cottonwood | Minnesota | 27033 | 162 | 0 |
380841 | 380841 | 2020-07-29 | Crow Wing | Minnesota | 27035 | 170 | 13 |
380842 | 380842 | 2020-07-29 | Dakota | Minnesota | 27037 | 3656 | 102 |
380843 | 380843 | 2020-07-29 | Dodge | Minnesota | 27039 | 119 | 0 |
380844 | 380844 | 2020-07-29 | Douglas | Minnesota | 27041 | 119 | 0 |
380845 | 380845 | 2020-07-29 | Faribault | Minnesota | 27043 | 76 | 0 |
380846 | 380846 | 2020-07-29 | Fillmore | Minnesota | 27045 | 56 | 0 |
380847 | 380847 | 2020-07-29 | Freeborn | Minnesota | 27047 | 349 | 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);