ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
87 rows where date = "2020-07-16" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
339149 | 339149 | 2020-07-16 | Aitkin | Minnesota | 27001 | 18 | 0 |
339150 | 339150 | 2020-07-16 | Anoka | Minnesota | 27003 | 2534 | 108 |
339151 | 339151 | 2020-07-16 | Becker | Minnesota | 27005 | 71 | 0 |
339152 | 339152 | 2020-07-16 | Beltrami | Minnesota | 27007 | 71 | 0 |
339153 | 339153 | 2020-07-16 | Benton | Minnesota | 27009 | 255 | 3 |
339154 | 339154 | 2020-07-16 | Big Stone | Minnesota | 27011 | 18 | 0 |
339155 | 339155 | 2020-07-16 | Blue Earth | Minnesota | 27013 | 639 | 2 |
339156 | 339156 | 2020-07-16 | Brown | Minnesota | 27015 | 53 | 2 |
339157 | 339157 | 2020-07-16 | Carlton | Minnesota | 27017 | 96 | 0 |
339158 | 339158 | 2020-07-16 | Carver | Minnesota | 27019 | 533 | 2 |
339159 | 339159 | 2020-07-16 | Cass | Minnesota | 27021 | 26 | 2 |
339160 | 339160 | 2020-07-16 | Chippewa | Minnesota | 27023 | 83 | 1 |
339161 | 339161 | 2020-07-16 | Chisago | Minnesota | 27025 | 114 | 1 |
339162 | 339162 | 2020-07-16 | Clay | Minnesota | 27027 | 638 | 38 |
339163 | 339163 | 2020-07-16 | Clearwater | Minnesota | 27029 | 14 | 0 |
339164 | 339164 | 2020-07-16 | Cook | Minnesota | 27031 | 1 | 0 |
339165 | 339165 | 2020-07-16 | Cottonwood | Minnesota | 27033 | 146 | 0 |
339166 | 339166 | 2020-07-16 | Crow Wing | Minnesota | 27035 | 122 | 12 |
339167 | 339167 | 2020-07-16 | Dakota | Minnesota | 27037 | 2912 | 99 |
339168 | 339168 | 2020-07-16 | Dodge | Minnesota | 27039 | 107 | 0 |
339169 | 339169 | 2020-07-16 | Douglas | Minnesota | 27041 | 91 | 0 |
339170 | 339170 | 2020-07-16 | Faribault | Minnesota | 27043 | 67 | 0 |
339171 | 339171 | 2020-07-16 | Fillmore | Minnesota | 27045 | 40 | 0 |
339172 | 339172 | 2020-07-16 | Freeborn | Minnesota | 27047 | 317 | 1 |
339173 | 339173 | 2020-07-16 | Goodhue | Minnesota | 27049 | 146 | 8 |
339174 | 339174 | 2020-07-16 | Grant | Minnesota | 27051 | 32 | 1 |
339175 | 339175 | 2020-07-16 | Hennepin | Minnesota | 27053 | 14125 | 794 |
339176 | 339176 | 2020-07-16 | Houston | Minnesota | 27055 | 33 | 0 |
339177 | 339177 | 2020-07-16 | Hubbard | Minnesota | 27057 | 12 | 0 |
339178 | 339178 | 2020-07-16 | Isanti | Minnesota | 27059 | 87 | 0 |
339179 | 339179 | 2020-07-16 | Itasca | Minnesota | 27061 | 86 | 12 |
339180 | 339180 | 2020-07-16 | Jackson | Minnesota | 27063 | 60 | 0 |
339181 | 339181 | 2020-07-16 | Kanabec | Minnesota | 27065 | 18 | 1 |
339182 | 339182 | 2020-07-16 | Kandiyohi | Minnesota | 27067 | 601 | 1 |
339183 | 339183 | 2020-07-16 | Kittson | Minnesota | 27069 | 2 | 0 |
339184 | 339184 | 2020-07-16 | Koochiching | Minnesota | 27071 | 29 | 2 |
339185 | 339185 | 2020-07-16 | Lac qui Parle | Minnesota | 27073 | 6 | 0 |
339186 | 339186 | 2020-07-16 | Lake | Minnesota | 27075 | 12 | 0 |
339187 | 339187 | 2020-07-16 | Le Sueur | Minnesota | 27079 | 144 | 1 |
339188 | 339188 | 2020-07-16 | Lincoln | Minnesota | 27081 | 37 | 0 |
339189 | 339189 | 2020-07-16 | Lyon | Minnesota | 27083 | 369 | 2 |
339190 | 339190 | 2020-07-16 | Mahnomen | Minnesota | 27087 | 15 | 1 |
339191 | 339191 | 2020-07-16 | Marshall | Minnesota | 27089 | 17 | 0 |
339192 | 339192 | 2020-07-16 | Martin | Minnesota | 27091 | 179 | 5 |
339193 | 339193 | 2020-07-16 | McLeod | Minnesota | 27085 | 104 | 0 |
339194 | 339194 | 2020-07-16 | Meeker | Minnesota | 27093 | 68 | 1 |
339195 | 339195 | 2020-07-16 | Mille Lacs | Minnesota | 27095 | 41 | 2 |
339196 | 339196 | 2020-07-16 | Morrison | Minnesota | 27097 | 70 | 1 |
339197 | 339197 | 2020-07-16 | Mower | Minnesota | 27099 | 996 | 2 |
339198 | 339198 | 2020-07-16 | Murray | Minnesota | 27101 | 89 | 0 |
339199 | 339199 | 2020-07-16 | Nicollet | Minnesota | 27103 | 219 | 13 |
339200 | 339200 | 2020-07-16 | Nobles | Minnesota | 27105 | 1698 | 6 |
339201 | 339201 | 2020-07-16 | Norman | Minnesota | 27107 | 22 | 0 |
339202 | 339202 | 2020-07-16 | Olmsted | Minnesota | 27109 | 1353 | 20 |
339203 | 339203 | 2020-07-16 | Otter Tail | Minnesota | 27111 | 123 | 1 |
339204 | 339204 | 2020-07-16 | Pennington | Minnesota | 27113 | 55 | 0 |
339205 | 339205 | 2020-07-16 | Pine | Minnesota | 27115 | 115 | 0 |
339206 | 339206 | 2020-07-16 | Pipestone | Minnesota | 27117 | 103 | 5 |
339207 | 339207 | 2020-07-16 | Polk | Minnesota | 27119 | 91 | 3 |
339208 | 339208 | 2020-07-16 | Pope | Minnesota | 27121 | 19 | 0 |
339209 | 339209 | 2020-07-16 | Ramsey | Minnesota | 27123 | 5470 | 246 |
339210 | 339210 | 2020-07-16 | Red Lake | Minnesota | 27125 | 5 | 0 |
339211 | 339211 | 2020-07-16 | Redwood | Minnesota | 27127 | 26 | 0 |
339212 | 339212 | 2020-07-16 | Renville | Minnesota | 27129 | 37 | 3 |
339213 | 339213 | 2020-07-16 | Rice | Minnesota | 27131 | 905 | 8 |
339214 | 339214 | 2020-07-16 | Rock | Minnesota | 27133 | 36 | 0 |
339215 | 339215 | 2020-07-16 | Roseau | Minnesota | 27135 | 30 | 0 |
339216 | 339216 | 2020-07-16 | Scott | Minnesota | 27139 | 965 | 7 |
339217 | 339217 | 2020-07-16 | Sherburne | Minnesota | 27141 | 400 | 5 |
339218 | 339218 | 2020-07-16 | Sibley | Minnesota | 27143 | 62 | 2 |
339219 | 339219 | 2020-07-16 | St. Louis | Minnesota | 27137 | 254 | 16 |
339220 | 339220 | 2020-07-16 | Stearns | Minnesota | 27145 | 2596 | 19 |
339221 | 339221 | 2020-07-16 | Steele | Minnesota | 27147 | 274 | 1 |
339222 | 339222 | 2020-07-16 | Stevens | Minnesota | 27149 | 13 | 0 |
339223 | 339223 | 2020-07-16 | Swift | Minnesota | 27151 | 40 | 1 |
339224 | 339224 | 2020-07-16 | Todd | Minnesota | 27153 | 405 | 2 |
339225 | 339225 | 2020-07-16 | Traverse | Minnesota | 27155 | 8 | 0 |
339226 | 339226 | 2020-07-16 | Unknown | Minnesota | 131 | 40 | |
339227 | 339227 | 2020-07-16 | Wabasha | Minnesota | 27157 | 49 | 0 |
339228 | 339228 | 2020-07-16 | Wadena | Minnesota | 27159 | 18 | 0 |
339229 | 339229 | 2020-07-16 | Waseca | Minnesota | 27161 | 83 | 0 |
339230 | 339230 | 2020-07-16 | Washington | Minnesota | 27163 | 1369 | 40 |
339231 | 339231 | 2020-07-16 | Watonwan | Minnesota | 27165 | 272 | 0 |
339232 | 339232 | 2020-07-16 | Wilkin | Minnesota | 27167 | 23 | 3 |
339233 | 339233 | 2020-07-16 | Winona | Minnesota | 27169 | 163 | 16 |
339234 | 339234 | 2020-07-16 | Wright | Minnesota | 27171 | 576 | 4 |
339235 | 339235 | 2020-07-16 | Yellow Medicine | Minnesota | 27173 | 35 | 0 |
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);