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-30 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1769204 | 1769204 | 2021-09-30 | Aitkin | Minnesota | 27001 | 1628 | 39 |
1769205 | 1769205 | 2021-09-30 | Anoka | Minnesota | 27003 | 49997 | 495 |
1769206 | 1769206 | 2021-09-30 | Becker | Minnesota | 27005 | 4752 | 61 |
1769207 | 1769207 | 2021-09-30 | Beltrami | Minnesota | 27007 | 5594 | 72 |
1769208 | 1769208 | 2021-09-30 | Benton | Minnesota | 27009 | 6817 | 102 |
1769209 | 1769209 | 2021-09-30 | Big Stone | Minnesota | 27011 | 720 | 4 |
1769210 | 1769210 | 2021-09-30 | Blue Earth | Minnesota | 27013 | 9034 | 49 |
1769211 | 1769211 | 2021-09-30 | Brown | Minnesota | 27015 | 3696 | 44 |
1769212 | 1769212 | 2021-09-30 | Carlton | Minnesota | 27017 | 4077 | 60 |
1769213 | 1769213 | 2021-09-30 | Carver | Minnesota | 27019 | 12613 | 53 |
1769214 | 1769214 | 2021-09-30 | Cass | Minnesota | 27021 | 3687 | 39 |
1769215 | 1769215 | 2021-09-30 | Chippewa | Minnesota | 27023 | 1747 | 39 |
1769216 | 1769216 | 2021-09-30 | Chisago | Minnesota | 27025 | 7521 | 58 |
1769217 | 1769217 | 2021-09-30 | Clay | Minnesota | 27027 | 9508 | 97 |
1769218 | 1769218 | 2021-09-30 | Clearwater | Minnesota | 27029 | 1188 | 18 |
1769219 | 1769219 | 2021-09-30 | Cook | Minnesota | 27031 | 219 | 0 |
1769220 | 1769220 | 2021-09-30 | Cottonwood | Minnesota | 27033 | 1825 | 24 |
1769221 | 1769221 | 2021-09-30 | Crow Wing | Minnesota | 27035 | 8358 | 104 |
1769222 | 1769222 | 2021-09-30 | Dakota | Minnesota | 27037 | 53805 | 505 |
1769223 | 1769223 | 2021-09-30 | Dodge | Minnesota | 27039 | 2537 | 5 |
1769224 | 1769224 | 2021-09-30 | Douglas | Minnesota | 27041 | 5651 | 84 |
1769225 | 1769225 | 2021-09-30 | Faribault | Minnesota | 27043 | 1916 | 25 |
1769226 | 1769226 | 2021-09-30 | Fillmore | Minnesota | 27045 | 2093 | 11 |
1769227 | 1769227 | 2021-09-30 | Freeborn | Minnesota | 27047 | 4477 | 42 |
1769228 | 1769228 | 2021-09-30 | Goodhue | Minnesota | 27049 | 5697 | 81 |
1769229 | 1769229 | 2021-09-30 | Grant | Minnesota | 27051 | 708 | 9 |
1769230 | 1769230 | 2021-09-30 | Hennepin | Minnesota | 27053 | 144695 | 1877 |
1769231 | 1769231 | 2021-09-30 | Houston | Minnesota | 27055 | 2143 | 17 |
1769232 | 1769232 | 2021-09-30 | Hubbard | Minnesota | 27057 | 2524 | 41 |
1769233 | 1769233 | 2021-09-30 | Isanti | Minnesota | 27059 | 5146 | 71 |
1769234 | 1769234 | 2021-09-30 | Itasca | Minnesota | 27061 | 5468 | 73 |
1769235 | 1769235 | 2021-09-30 | Jackson | Minnesota | 27063 | 1375 | 12 |
1769236 | 1769236 | 2021-09-30 | Kanabec | Minnesota | 27065 | 1726 | 29 |
1769237 | 1769237 | 2021-09-30 | Kandiyohi | Minnesota | 27067 | 7678 | 93 |
1769238 | 1769238 | 2021-09-30 | Kittson | Minnesota | 27069 | 556 | 22 |
1769239 | 1769239 | 2021-09-30 | Koochiching | Minnesota | 27071 | 1304 | 19 |
1769240 | 1769240 | 2021-09-30 | Lac qui Parle | Minnesota | 27073 | 906 | 24 |
1769241 | 1769241 | 2021-09-30 | Lake | Minnesota | 27075 | 991 | 21 |
1769242 | 1769242 | 2021-09-30 | Lake of the Woods | Minnesota | 27077 | 427 | 4 |
1769243 | 1769243 | 2021-09-30 | Le Sueur | Minnesota | 27079 | 3551 | 30 |
1769244 | 1769244 | 2021-09-30 | Lincoln | Minnesota | 27081 | 697 | 4 |
1769245 | 1769245 | 2021-09-30 | Lyon | Minnesota | 27083 | 4131 | 54 |
1769246 | 1769246 | 2021-09-30 | Mahnomen | Minnesota | 27087 | 760 | 9 |
1769247 | 1769247 | 2021-09-30 | Marshall | Minnesota | 27089 | 1119 | 19 |
1769248 | 1769248 | 2021-09-30 | Martin | Minnesota | 27091 | 2820 | 33 |
1769249 | 1769249 | 2021-09-30 | McLeod | Minnesota | 27085 | 5317 | 65 |
1769250 | 1769250 | 2021-09-30 | Meeker | Minnesota | 27093 | 3219 | 49 |
1769251 | 1769251 | 2021-09-30 | Mille Lacs | Minnesota | 27095 | 3715 | 61 |
1769252 | 1769252 | 2021-09-30 | Morrison | Minnesota | 27097 | 4913 | 63 |
1769253 | 1769253 | 2021-09-30 | Mower | Minnesota | 27099 | 5906 | 38 |
1769254 | 1769254 | 2021-09-30 | Murray | Minnesota | 27101 | 1210 | 10 |
1769255 | 1769255 | 2021-09-30 | Nicollet | Minnesota | 27103 | 3964 | 49 |
1769256 | 1769256 | 2021-09-30 | Nobles | Minnesota | 27105 | 4620 | 51 |
1769257 | 1769257 | 2021-09-30 | Norman | Minnesota | 27107 | 714 | 9 |
1769258 | 1769258 | 2021-09-30 | Olmsted | Minnesota | 27109 | 16640 | 112 |
1769259 | 1769259 | 2021-09-30 | Otter Tail | Minnesota | 27111 | 7122 | 98 |
1769260 | 1769260 | 2021-09-30 | Pennington | Minnesota | 27113 | 2004 | 22 |
1769261 | 1769261 | 2021-09-30 | Pine | Minnesota | 27115 | 3931 | 29 |
1769262 | 1769262 | 2021-09-30 | Pipestone | Minnesota | 27117 | 1270 | 27 |
1769263 | 1769263 | 2021-09-30 | Polk | Minnesota | 27119 | 4599 | 75 |
1769264 | 1769264 | 2021-09-30 | Pope | Minnesota | 27121 | 1379 | 8 |
1769265 | 1769265 | 2021-09-30 | Ramsey | Minnesota | 27123 | 60222 | 955 |
1769266 | 1769266 | 2021-09-30 | Red Lake | Minnesota | 27125 | 522 | 8 |
1769267 | 1769267 | 2021-09-30 | Redwood | Minnesota | 27127 | 2144 | 43 |
1769268 | 1769268 | 2021-09-30 | Renville | Minnesota | 27129 | 2096 | 48 |
1769269 | 1769269 | 2021-09-30 | Rice | Minnesota | 27131 | 9436 | 127 |
1769270 | 1769270 | 2021-09-30 | Rock | Minnesota | 27133 | 1464 | 19 |
1769271 | 1769271 | 2021-09-30 | Roseau | Minnesota | 27135 | 2425 | 24 |
1769272 | 1769272 | 2021-09-30 | Scott | Minnesota | 27139 | 20371 | 151 |
1769273 | 1769273 | 2021-09-30 | Sherburne | Minnesota | 27141 | 14155 | 109 |
1769274 | 1769274 | 2021-09-30 | Sibley | Minnesota | 27143 | 1853 | 12 |
1769275 | 1769275 | 2021-09-30 | St. Louis | Minnesota | 27137 | 21461 | 342 |
1769276 | 1769276 | 2021-09-30 | Stearns | Minnesota | 27145 | 26075 | 244 |
1769277 | 1769277 | 2021-09-30 | Steele | Minnesota | 27147 | 5342 | 21 |
1769278 | 1769278 | 2021-09-30 | Stevens | Minnesota | 27149 | 1126 | 11 |
1769279 | 1769279 | 2021-09-30 | Swift | Minnesota | 27151 | 1228 | 19 |
1769280 | 1769280 | 2021-09-30 | Todd | Minnesota | 27153 | 3436 | 35 |
1769281 | 1769281 | 2021-09-30 | Traverse | Minnesota | 27155 | 456 | 5 |
1769282 | 1769282 | 2021-09-30 | Unknown | Minnesota | 634 | 103 | |
1769283 | 1769283 | 2021-09-30 | Wabasha | Minnesota | 27157 | 2594 | 5 |
1769284 | 1769284 | 2021-09-30 | Wadena | Minnesota | 27159 | 2028 | 27 |
1769285 | 1769285 | 2021-09-30 | Waseca | Minnesota | 27161 | 3041 | 26 |
1769286 | 1769286 | 2021-09-30 | Washington | Minnesota | 27163 | 31709 | 320 |
1769287 | 1769287 | 2021-09-30 | Watonwan | Minnesota | 27165 | 1608 | 11 |
1769288 | 1769288 | 2021-09-30 | Wilkin | Minnesota | 27167 | 929 | 14 |
1769289 | 1769289 | 2021-09-30 | Winona | Minnesota | 27169 | 5732 | 52 |
1769290 | 1769290 | 2021-09-30 | Wright | Minnesota | 27171 | 19346 | 167 |
1769291 | 1769291 | 2021-09-30 | Yellow Medicine | Minnesota | 27173 | 1359 | 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);