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 127
- 27019 125
- 27003 123
- 27109 122
- 27037 121
- 27053 121
- 27145 121
- 27171 120
- 27129 119
- 27161 118
- 27163 118
- 27009 117
- 27013 117
- 27091 116
- 27103 116
- 27131 115
- 27099 114
- 27139 114
- 27025 113
- 27027 113
- 27045 113
- 27039 112
- 27063 112
- 27137 112
- 27147 112
- 27157 112
- 27079 111
- 27011 110
- 27021 110
- 27073 110
- …
county >30
- Ramsey 127
- Carver 125
- Anoka 123
- Olmsted 122
- Dakota 121
- Hennepin 121
- Stearns 121
- Wright 120
- Renville 119
- Waseca 118
- Washington 118
- Benton 117
- Blue Earth 117
- Martin 116
- Nicollet 116
- Rice 115
- Mower 114
- Scott 114
- Chisago 113
- Clay 113
- Fillmore 113
- Dodge 112
- Jackson 112
- St. Louis 112
- Steele 112
- Wabasha 112
- Le Sueur 111
- Big Stone 110
- Cass 110
- Lac qui Parle 110
- …
state 1
- Minnesota · 8,761 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
320025 | 320025 | 2020-07-10 | Aitkin | Minnesota | 27001 | 15 | 0 |
320026 | 320026 | 2020-07-10 | Anoka | Minnesota | 27003 | 2360 | 111 |
320027 | 320027 | 2020-07-10 | Becker | Minnesota | 27005 | 57 | 0 |
320028 | 320028 | 2020-07-10 | Beltrami | Minnesota | 27007 | 43 | 0 |
320029 | 320029 | 2020-07-10 | Benton | Minnesota | 27009 | 235 | 3 |
320030 | 320030 | 2020-07-10 | Big Stone | Minnesota | 27011 | 17 | 0 |
320031 | 320031 | 2020-07-10 | Blue Earth | Minnesota | 27013 | 544 | 2 |
320032 | 320032 | 2020-07-10 | Brown | Minnesota | 27015 | 43 | 2 |
320033 | 320033 | 2020-07-10 | Carlton | Minnesota | 27017 | 89 | 0 |
320034 | 320034 | 2020-07-10 | Carver | Minnesota | 27019 | 442 | 1 |
320035 | 320035 | 2020-07-10 | Cass | Minnesota | 27021 | 19 | 2 |
320036 | 320036 | 2020-07-10 | Chippewa | Minnesota | 27023 | 79 | 1 |
320037 | 320037 | 2020-07-10 | Chisago | Minnesota | 27025 | 105 | 1 |
320038 | 320038 | 2020-07-10 | Clay | Minnesota | 27027 | 601 | 38 |
320039 | 320039 | 2020-07-10 | Clearwater | Minnesota | 27029 | 10 | 0 |
320040 | 320040 | 2020-07-10 | Cook | Minnesota | 27031 | 1 | 0 |
320041 | 320041 | 2020-07-10 | Cottonwood | Minnesota | 27033 | 138 | 0 |
320042 | 320042 | 2020-07-10 | Crow Wing | Minnesota | 27035 | 110 | 12 |
320043 | 320043 | 2020-07-10 | Dakota | Minnesota | 27037 | 2570 | 94 |
320044 | 320044 | 2020-07-10 | Dodge | Minnesota | 27039 | 97 | 0 |
320045 | 320045 | 2020-07-10 | Douglas | Minnesota | 27041 | 69 | 0 |
320046 | 320046 | 2020-07-10 | Faribault | Minnesota | 27043 | 61 | 0 |
320047 | 320047 | 2020-07-10 | Fillmore | Minnesota | 27045 | 31 | 0 |
320048 | 320048 | 2020-07-10 | Freeborn | Minnesota | 27047 | 309 | 0 |
320049 | 320049 | 2020-07-10 | Goodhue | Minnesota | 27049 | 138 | 8 |
320050 | 320050 | 2020-07-10 | Grant | Minnesota | 27051 | 24 | 0 |
320051 | 320051 | 2020-07-10 | Hennepin | Minnesota | 27053 | 13054 | 790 |
320052 | 320052 | 2020-07-10 | Houston | Minnesota | 27055 | 29 | 0 |
320053 | 320053 | 2020-07-10 | Hubbard | Minnesota | 27057 | 8 | 0 |
320054 | 320054 | 2020-07-10 | Isanti | Minnesota | 27059 | 80 | 0 |
320055 | 320055 | 2020-07-10 | Itasca | Minnesota | 27061 | 69 | 12 |
320056 | 320056 | 2020-07-10 | Jackson | Minnesota | 27063 | 57 | 0 |
320057 | 320057 | 2020-07-10 | Kanabec | Minnesota | 27065 | 16 | 1 |
320058 | 320058 | 2020-07-10 | Kandiyohi | Minnesota | 27067 | 587 | 1 |
320059 | 320059 | 2020-07-10 | Kittson | Minnesota | 27069 | 2 | 0 |
320060 | 320060 | 2020-07-10 | Koochiching | Minnesota | 27071 | 17 | 1 |
320061 | 320061 | 2020-07-10 | Lac qui Parle | Minnesota | 27073 | 4 | 0 |
320062 | 320062 | 2020-07-10 | Lake | Minnesota | 27075 | 6 | 0 |
320063 | 320063 | 2020-07-10 | Le Sueur | Minnesota | 27079 | 119 | 1 |
320064 | 320064 | 2020-07-10 | Lincoln | Minnesota | 27081 | 13 | 0 |
320065 | 320065 | 2020-07-10 | Lyon | Minnesota | 27083 | 332 | 2 |
320066 | 320066 | 2020-07-10 | Mahnomen | Minnesota | 27087 | 10 | 1 |
320067 | 320067 | 2020-07-10 | Marshall | Minnesota | 27089 | 12 | 0 |
320068 | 320068 | 2020-07-10 | Martin | Minnesota | 27091 | 172 | 5 |
320069 | 320069 | 2020-07-10 | McLeod | Minnesota | 27085 | 99 | 0 |
320070 | 320070 | 2020-07-10 | Meeker | Minnesota | 27093 | 62 | 1 |
320071 | 320071 | 2020-07-10 | Mille Lacs | Minnesota | 27095 | 36 | 2 |
320072 | 320072 | 2020-07-10 | Morrison | Minnesota | 27097 | 62 | 1 |
320073 | 320073 | 2020-07-10 | Mower | Minnesota | 27099 | 974 | 2 |
320074 | 320074 | 2020-07-10 | Murray | Minnesota | 27101 | 68 | 0 |
320075 | 320075 | 2020-07-10 | Nicollet | Minnesota | 27103 | 191 | 12 |
320076 | 320076 | 2020-07-10 | Nobles | Minnesota | 27105 | 1676 | 6 |
320077 | 320077 | 2020-07-10 | Norman | Minnesota | 27107 | 21 | 0 |
320078 | 320078 | 2020-07-10 | Olmsted | Minnesota | 27109 | 1235 | 18 |
320079 | 320079 | 2020-07-10 | Otter Tail | Minnesota | 27111 | 104 | 1 |
320080 | 320080 | 2020-07-10 | Pennington | Minnesota | 27113 | 53 | 0 |
320081 | 320081 | 2020-07-10 | Pine | Minnesota | 27115 | 111 | 0 |
320082 | 320082 | 2020-07-10 | Pipestone | Minnesota | 27117 | 67 | 4 |
320083 | 320083 | 2020-07-10 | Polk | Minnesota | 27119 | 86 | 3 |
320084 | 320084 | 2020-07-10 | Pope | Minnesota | 27121 | 12 | 0 |
320085 | 320085 | 2020-07-10 | Ramsey | Minnesota | 27123 | 5127 | 233 |
320086 | 320086 | 2020-07-10 | Red Lake | Minnesota | 27125 | 4 | 0 |
320087 | 320087 | 2020-07-10 | Redwood | Minnesota | 27127 | 21 | 0 |
320088 | 320088 | 2020-07-10 | Renville | Minnesota | 27129 | 37 | 2 |
320089 | 320089 | 2020-07-10 | Rice | Minnesota | 27131 | 873 | 8 |
320090 | 320090 | 2020-07-10 | Rock | Minnesota | 27133 | 31 | 0 |
320091 | 320091 | 2020-07-10 | Roseau | Minnesota | 27135 | 21 | 0 |
320092 | 320092 | 2020-07-10 | Scott | Minnesota | 27139 | 823 | 4 |
320093 | 320093 | 2020-07-10 | Sherburne | Minnesota | 27141 | 344 | 5 |
320094 | 320094 | 2020-07-10 | Sibley | Minnesota | 27143 | 57 | 2 |
320095 | 320095 | 2020-07-10 | St. Louis | Minnesota | 27137 | 218 | 16 |
320096 | 320096 | 2020-07-10 | Stearns | Minnesota | 27145 | 2481 | 19 |
320097 | 320097 | 2020-07-10 | Steele | Minnesota | 27147 | 243 | 1 |
320098 | 320098 | 2020-07-10 | Stevens | Minnesota | 27149 | 10 | 0 |
320099 | 320099 | 2020-07-10 | Swift | Minnesota | 27151 | 29 | 1 |
320100 | 320100 | 2020-07-10 | Todd | Minnesota | 27153 | 402 | 2 |
320101 | 320101 | 2020-07-10 | Traverse | Minnesota | 27155 | 6 | 0 |
320102 | 320102 | 2020-07-10 | Unknown | Minnesota | 124 | 38 | |
320103 | 320103 | 2020-07-10 | Wabasha | Minnesota | 27157 | 35 | 0 |
320104 | 320104 | 2020-07-10 | Wadena | Minnesota | 27159 | 16 | 0 |
320105 | 320105 | 2020-07-10 | Waseca | Minnesota | 27161 | 75 | 0 |
320106 | 320106 | 2020-07-10 | Washington | Minnesota | 27163 | 1228 | 40 |
320107 | 320107 | 2020-07-10 | Watonwan | Minnesota | 27165 | 245 | 0 |
320108 | 320108 | 2020-07-10 | Wilkin | Minnesota | 27167 | 21 | 3 |
320109 | 320109 | 2020-07-10 | Winona | Minnesota | 27169 | 136 | 15 |
320110 | 320110 | 2020-07-10 | Wright | Minnesota | 27171 | 516 | 5 |
320111 | 320111 | 2020-07-10 | Yellow Medicine | Minnesota | 27173 | 31 | 0 |
316850 | 316850 | 2020-07-09 | Aitkin | Minnesota | 27001 | 15 | 0 |
316851 | 316851 | 2020-07-09 | Anoka | Minnesota | 27003 | 2328 | 111 |
316852 | 316852 | 2020-07-09 | Becker | Minnesota | 27005 | 57 | 0 |
316853 | 316853 | 2020-07-09 | Beltrami | Minnesota | 27007 | 41 | 0 |
316854 | 316854 | 2020-07-09 | Benton | Minnesota | 27009 | 228 | 3 |
316855 | 316855 | 2020-07-09 | Big Stone | Minnesota | 27011 | 17 | 0 |
316856 | 316856 | 2020-07-09 | Blue Earth | Minnesota | 27013 | 535 | 2 |
316857 | 316857 | 2020-07-09 | Brown | Minnesota | 27015 | 39 | 2 |
316858 | 316858 | 2020-07-09 | Carlton | Minnesota | 27017 | 89 | 0 |
316859 | 316859 | 2020-07-09 | Carver | Minnesota | 27019 | 433 | 1 |
316860 | 316860 | 2020-07-09 | Cass | Minnesota | 27021 | 19 | 2 |
316861 | 316861 | 2020-07-09 | Chippewa | Minnesota | 27023 | 79 | 1 |
316862 | 316862 | 2020-07-09 | Chisago | Minnesota | 27025 | 103 | 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);