ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where date = "2020-11-30" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
782215 | 782215 | 2020-11-30 | Aitkin | Minnesota | 27001 | 778 | 30 |
782216 | 782216 | 2020-11-30 | Anoka | Minnesota | 27003 | 22583 | 228 |
782217 | 782217 | 2020-11-30 | Becker | Minnesota | 27005 | 2094 | 16 |
782218 | 782218 | 2020-11-30 | Beltrami | Minnesota | 27007 | 2192 | 18 |
782219 | 782219 | 2020-11-30 | Benton | Minnesota | 27009 | 3057 | 51 |
782220 | 782220 | 2020-11-30 | Big Stone | Minnesota | 27011 | 324 | 2 |
782221 | 782221 | 2020-11-30 | Blue Earth | Minnesota | 27013 | 4180 | 16 |
782222 | 782222 | 2020-11-30 | Brown | Minnesota | 27015 | 1457 | 15 |
782223 | 782223 | 2020-11-30 | Carlton | Minnesota | 27017 | 1913 | 16 |
782224 | 782224 | 2020-11-30 | Carver | Minnesota | 27019 | 4862 | 15 |
782225 | 782225 | 2020-11-30 | Cass | Minnesota | 27021 | 1460 | 10 |
782226 | 782226 | 2020-11-30 | Chippewa | Minnesota | 27023 | 914 | 7 |
782227 | 782227 | 2020-11-30 | Chisago | Minnesota | 27025 | 3156 | 12 |
782228 | 782228 | 2020-11-30 | Clay | Minnesota | 27027 | 5089 | 57 |
782229 | 782229 | 2020-11-30 | Clearwater | Minnesota | 27029 | 526 | 8 |
782230 | 782230 | 2020-11-30 | Cook | Minnesota | 27031 | 77 | 0 |
782231 | 782231 | 2020-11-30 | Cottonwood | Minnesota | 27033 | 896 | 4 |
782232 | 782232 | 2020-11-30 | Crow Wing | Minnesota | 27035 | 3640 | 34 |
782233 | 782233 | 2020-11-30 | Dakota | Minnesota | 27037 | 22414 | 190 |
782234 | 782234 | 2020-11-30 | Dodge | Minnesota | 27039 | 870 | 0 |
782235 | 782235 | 2020-11-30 | Douglas | Minnesota | 27041 | 2668 | 37 |
782236 | 782236 | 2020-11-30 | Faribault | Minnesota | 27043 | 573 | 2 |
782237 | 782237 | 2020-11-30 | Fillmore | Minnesota | 27045 | 724 | 0 |
782238 | 782238 | 2020-11-30 | Freeborn | Minnesota | 27047 | 1554 | 6 |
782239 | 782239 | 2020-11-30 | Goodhue | Minnesota | 27049 | 2084 | 28 |
782240 | 782240 | 2020-11-30 | Grant | Minnesota | 27051 | 280 | 6 |
782241 | 782241 | 2020-11-30 | Hennepin | Minnesota | 27053 | 67336 | 1116 |
782242 | 782242 | 2020-11-30 | Houston | Minnesota | 27055 | 713 | 4 |
782243 | 782243 | 2020-11-30 | Hubbard | Minnesota | 27057 | 1157 | 25 |
782244 | 782244 | 2020-11-30 | Isanti | Minnesota | 27059 | 1942 | 17 |
782245 | 782245 | 2020-11-30 | Itasca | Minnesota | 27061 | 1939 | 23 |
782246 | 782246 | 2020-11-30 | Jackson | Minnesota | 27063 | 496 | 1 |
782247 | 782247 | 2020-11-30 | Kanabec | Minnesota | 27065 | 627 | 13 |
782248 | 782248 | 2020-11-30 | Kandiyohi | Minnesota | 27067 | 4205 | 22 |
782249 | 782249 | 2020-11-30 | Kittson | Minnesota | 27069 | 229 | 8 |
782250 | 782250 | 2020-11-30 | Koochiching | Minnesota | 27071 | 399 | 6 |
782251 | 782251 | 2020-11-30 | Lac qui Parle | Minnesota | 27073 | 386 | 3 |
782252 | 782252 | 2020-11-30 | Lake | Minnesota | 27075 | 432 | 6 |
782253 | 782253 | 2020-11-30 | Lake of the Woods | Minnesota | 27077 | 101 | 1 |
782254 | 782254 | 2020-11-30 | Le Sueur | Minnesota | 27079 | 1488 | 11 |
782255 | 782255 | 2020-11-30 | Lincoln | Minnesota | 27081 | 365 | 1 |
782256 | 782256 | 2020-11-30 | Lyon | Minnesota | 27083 | 2230 | 11 |
782257 | 782257 | 2020-11-30 | Mahnomen | Minnesota | 27087 | 304 | 4 |
782258 | 782258 | 2020-11-30 | Marshall | Minnesota | 27089 | 505 | 9 |
782259 | 782259 | 2020-11-30 | Martin | Minnesota | 27091 | 1174 | 20 |
782260 | 782260 | 2020-11-30 | McLeod | Minnesota | 27085 | 2179 | 14 |
782261 | 782261 | 2020-11-30 | Meeker | Minnesota | 27093 | 1328 | 9 |
782262 | 782262 | 2020-11-30 | Mille Lacs | Minnesota | 27095 | 1570 | 31 |
782263 | 782263 | 2020-11-30 | Morrison | Minnesota | 27097 | 2338 | 29 |
782264 | 782264 | 2020-11-30 | Mower | Minnesota | 27099 | 2658 | 23 |
782265 | 782265 | 2020-11-30 | Murray | Minnesota | 27101 | 595 | 3 |
782266 | 782266 | 2020-11-30 | Nicollet | Minnesota | 27103 | 1640 | 26 |
782267 | 782267 | 2020-11-30 | Nobles | Minnesota | 27105 | 3099 | 30 |
782268 | 782268 | 2020-11-30 | Norman | Minnesota | 27107 | 353 | 7 |
782269 | 782269 | 2020-11-30 | Olmsted | Minnesota | 27109 | 6811 | 34 |
782270 | 782270 | 2020-11-30 | Otter Tail | Minnesota | 27111 | 3217 | 23 |
782271 | 782271 | 2020-11-30 | Pennington | Minnesota | 27113 | 663 | 8 |
782272 | 782272 | 2020-11-30 | Pine | Minnesota | 27115 | 1395 | 8 |
782273 | 782273 | 2020-11-30 | Pipestone | Minnesota | 27117 | 741 | 18 |
782274 | 782274 | 2020-11-30 | Polk | Minnesota | 27119 | 2612 | 24 |
782275 | 782275 | 2020-11-30 | Pope | Minnesota | 27121 | 553 | 1 |
782276 | 782276 | 2020-11-30 | Ramsey | Minnesota | 27123 | 28256 | 505 |
782277 | 782277 | 2020-11-30 | Red Lake | Minnesota | 27125 | 216 | 3 |
782278 | 782278 | 2020-11-30 | Redwood | Minnesota | 27127 | 979 | 19 |
782279 | 782279 | 2020-11-30 | Renville | Minnesota | 27129 | 895 | 29 |
782280 | 782280 | 2020-11-30 | Rice | Minnesota | 27131 | 4192 | 37 |
782281 | 782281 | 2020-11-30 | Rock | Minnesota | 27133 | 788 | 9 |
782282 | 782282 | 2020-11-30 | Roseau | Minnesota | 27135 | 1219 | 4 |
782283 | 782283 | 2020-11-30 | Scott | Minnesota | 27139 | 8597 | 55 |
782284 | 782284 | 2020-11-30 | Sherburne | Minnesota | 27141 | 6015 | 41 |
782285 | 782285 | 2020-11-30 | Sibley | Minnesota | 27143 | 800 | 4 |
782286 | 782286 | 2020-11-30 | St. Louis | Minnesota | 27137 | 8991 | 112 |
782287 | 782287 | 2020-11-30 | Stearns | Minnesota | 27145 | 13976 | 117 |
782288 | 782288 | 2020-11-30 | Steele | Minnesota | 27147 | 1991 | 7 |
782289 | 782289 | 2020-11-30 | Stevens | Minnesota | 27149 | 524 | 3 |
782290 | 782290 | 2020-11-30 | Swift | Minnesota | 27151 | 599 | 8 |
782291 | 782291 | 2020-11-30 | Todd | Minnesota | 27153 | 1825 | 14 |
782292 | 782292 | 2020-11-30 | Traverse | Minnesota | 27155 | 149 | 1 |
782293 | 782293 | 2020-11-30 | Unknown | Minnesota | 444 | 59 | |
782294 | 782294 | 2020-11-30 | Wabasha | Minnesota | 27157 | 1078 | 1 |
782295 | 782295 | 2020-11-30 | Wadena | Minnesota | 27159 | 815 | 6 |
782296 | 782296 | 2020-11-30 | Waseca | Minnesota | 27161 | 1398 | 11 |
782297 | 782297 | 2020-11-30 | Washington | Minnesota | 27163 | 14207 | 116 |
782298 | 782298 | 2020-11-30 | Watonwan | Minnesota | 27165 | 863 | 4 |
782299 | 782299 | 2020-11-30 | Wilkin | Minnesota | 27167 | 392 | 5 |
782300 | 782300 | 2020-11-30 | Winona | Minnesota | 27169 | 2848 | 30 |
782301 | 782301 | 2020-11-30 | Wright | Minnesota | 27171 | 7955 | 43 |
782302 | 782302 | 2020-11-30 | Yellow Medicine | Minnesota | 27173 | 665 | 12 |
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);