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 2022-02-21 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2237315 | 2237315 | 2022-02-21 | Aitkin | Minnesota | 27001 | 2879 | 60 |
2237316 | 2237316 | 2022-02-21 | Anoka | Minnesota | 27003 | 96901 | 765 |
2237317 | 2237317 | 2022-02-21 | Becker | Minnesota | 27005 | 8532 | 87 |
2237318 | 2237318 | 2022-02-21 | Beltrami | Minnesota | 27007 | 11173 | 118 |
2237319 | 2237319 | 2022-02-21 | Benton | Minnesota | 27009 | 13690 | 165 |
2237320 | 2237320 | 2022-02-21 | Big Stone | Minnesota | 27011 | 1356 | 8 |
2237321 | 2237321 | 2022-02-21 | Blue Earth | Minnesota | 27013 | 17266 | 91 |
2237322 | 2237322 | 2022-02-21 | Brown | Minnesota | 27015 | 6440 | 74 |
2237323 | 2237323 | 2022-02-21 | Carlton | Minnesota | 27017 | 8663 | 90 |
2237324 | 2237324 | 2022-02-21 | Carver | Minnesota | 27019 | 26003 | 107 |
2237325 | 2237325 | 2022-02-21 | Cass | Minnesota | 27021 | 6695 | 75 |
2237326 | 2237326 | 2022-02-21 | Chippewa | Minnesota | 27023 | 3000 | 47 |
2237327 | 2237327 | 2022-02-21 | Chisago | Minnesota | 27025 | 14283 | 116 |
2237328 | 2237328 | 2022-02-21 | Clay | Minnesota | 27027 | 19256 | 118 |
2237329 | 2237329 | 2022-02-21 | Clearwater | Minnesota | 27029 | 2097 | 29 |
2237330 | 2237330 | 2022-02-21 | Cook | Minnesota | 27031 | 533 | 4 |
2237331 | 2237331 | 2022-02-21 | Cottonwood | Minnesota | 27033 | 3151 | 40 |
2237332 | 2237332 | 2022-02-21 | Crow Wing | Minnesota | 27035 | 15620 | 160 |
2237333 | 2237333 | 2022-02-21 | Dakota | Minnesota | 27037 | 107495 | 739 |
2237334 | 2237334 | 2022-02-21 | Dodge | Minnesota | 27039 | 5521 | 20 |
2237335 | 2237335 | 2022-02-21 | Douglas | Minnesota | 27041 | 10670 | 113 |
2237336 | 2237336 | 2022-02-21 | Faribault | Minnesota | 27043 | 3683 | 49 |
2237337 | 2237337 | 2022-02-21 | Fillmore | Minnesota | 27045 | 4578 | 22 |
2237338 | 2237338 | 2022-02-21 | Freeborn | Minnesota | 27047 | 8813 | 69 |
2237339 | 2237339 | 2022-02-21 | Goodhue | Minnesota | 27049 | 12658 | 120 |
2237340 | 2237340 | 2022-02-21 | Grant | Minnesota | 27051 | 1430 | 12 |
2237341 | 2237341 | 2022-02-21 | Hennepin | Minnesota | 27053 | 291774 | 2478 |
2237342 | 2237342 | 2022-02-21 | Houston | Minnesota | 27055 | 4260 | 18 |
2237343 | 2237343 | 2022-02-21 | Hubbard | Minnesota | 27057 | 4812 | 56 |
2237344 | 2237344 | 2022-02-21 | Isanti | Minnesota | 27059 | 9955 | 113 |
2237345 | 2237345 | 2022-02-21 | Itasca | Minnesota | 27061 | 10769 | 137 |
2237346 | 2237346 | 2022-02-21 | Jackson | Minnesota | 27063 | 2117 | 17 |
2237347 | 2237347 | 2022-02-21 | Kanabec | Minnesota | 27065 | 3442 | 54 |
2237348 | 2237348 | 2022-02-21 | Kandiyohi | Minnesota | 27067 | 13118 | 132 |
2237349 | 2237349 | 2022-02-21 | Kittson | Minnesota | 27069 | 1018 | 26 |
2237350 | 2237350 | 2022-02-21 | Koochiching | Minnesota | 27071 | 2622 | 34 |
2237351 | 2237351 | 2022-02-21 | Lac qui Parle | Minnesota | 27073 | 1706 | 28 |
2237352 | 2237352 | 2022-02-21 | Lake | Minnesota | 27075 | 1995 | 28 |
2237353 | 2237353 | 2022-02-21 | Lake of the Woods | Minnesota | 27077 | 739 | 5 |
2237354 | 2237354 | 2022-02-21 | Le Sueur | Minnesota | 27079 | 6309 | 49 |
2237355 | 2237355 | 2022-02-21 | Lincoln | Minnesota | 27081 | 1198 | 6 |
2237356 | 2237356 | 2022-02-21 | Lyon | Minnesota | 27083 | 6973 | 71 |
2237357 | 2237357 | 2022-02-21 | Mahnomen | Minnesota | 27087 | 1646 | 17 |
2237358 | 2237358 | 2022-02-21 | Marshall | Minnesota | 27089 | 2009 | 23 |
2237359 | 2237359 | 2022-02-21 | Martin | Minnesota | 27091 | 5448 | 59 |
2237360 | 2237360 | 2022-02-21 | McLeod | Minnesota | 27085 | 10314 | 101 |
2237361 | 2237361 | 2022-02-21 | Meeker | Minnesota | 27093 | 5756 | 74 |
2237362 | 2237362 | 2022-02-21 | Mille Lacs | Minnesota | 27095 | 7064 | 109 |
2237363 | 2237363 | 2022-02-21 | Morrison | Minnesota | 27097 | 8909 | 99 |
2237364 | 2237364 | 2022-02-21 | Mower | Minnesota | 27099 | 11624 | 67 |
2237365 | 2237365 | 2022-02-21 | Murray | Minnesota | 27101 | 1991 | 15 |
2237366 | 2237366 | 2022-02-21 | Nicollet | Minnesota | 27103 | 7767 | 66 |
2237367 | 2237367 | 2022-02-21 | Nobles | Minnesota | 27105 | 6855 | 58 |
2237368 | 2237368 | 2022-02-21 | Norman | Minnesota | 27107 | 1461 | 13 |
2237369 | 2237369 | 2022-02-21 | Olmsted | Minnesota | 27109 | 39231 | 166 |
2237370 | 2237370 | 2022-02-21 | Otter Tail | Minnesota | 27111 | 13224 | 160 |
2237371 | 2237371 | 2022-02-21 | Pennington | Minnesota | 27113 | 3429 | 39 |
2237372 | 2237372 | 2022-02-21 | Pine | Minnesota | 27115 | 6886 | 61 |
2237373 | 2237373 | 2022-02-21 | Pipestone | Minnesota | 27117 | 1966 | 34 |
2237374 | 2237374 | 2022-02-21 | Polk | Minnesota | 27119 | 8370 | 97 |
2237375 | 2237375 | 2022-02-21 | Pope | Minnesota | 27121 | 2900 | 17 |
2237376 | 2237376 | 2022-02-21 | Ramsey | Minnesota | 27123 | 121272 | 1293 |
2237377 | 2237377 | 2022-02-21 | Red Lake | Minnesota | 27125 | 917 | 12 |
2237378 | 2237378 | 2022-02-21 | Redwood | Minnesota | 27127 | 3821 | 52 |
2237379 | 2237379 | 2022-02-21 | Renville | Minnesota | 27129 | 3574 | 55 |
2237380 | 2237380 | 2022-02-21 | Rice | Minnesota | 27131 | 17347 | 167 |
2237381 | 2237381 | 2022-02-21 | Rock | Minnesota | 27133 | 2305 | 33 |
2237382 | 2237382 | 2022-02-21 | Roseau | Minnesota | 27135 | 4345 | 43 |
2237383 | 2237383 | 2022-02-21 | Scott | Minnesota | 27139 | 39410 | 246 |
2237384 | 2237384 | 2022-02-21 | Sherburne | Minnesota | 27141 | 26919 | 174 |
2237385 | 2237385 | 2022-02-21 | Sibley | Minnesota | 27143 | 3401 | 23 |
2237386 | 2237386 | 2022-02-21 | St. Louis | Minnesota | 27137 | 45288 | 511 |
2237387 | 2237387 | 2022-02-21 | Stearns | Minnesota | 27145 | 49758 | 353 |
2237388 | 2237388 | 2022-02-21 | Steele | Minnesota | 27147 | 10128 | 55 |
2237389 | 2237389 | 2022-02-21 | Stevens | Minnesota | 27149 | 2565 | 13 |
2237390 | 2237390 | 2022-02-21 | Swift | Minnesota | 27151 | 2257 | 33 |
2237391 | 2237391 | 2022-02-21 | Todd | Minnesota | 27153 | 6581 | 54 |
2237392 | 2237392 | 2022-02-21 | Traverse | Minnesota | 27155 | 818 | 10 |
2237393 | 2237393 | 2022-02-21 | Unknown | Minnesota | 6791 | 170 | |
2237394 | 2237394 | 2022-02-21 | Wabasha | Minnesota | 27157 | 5376 | 16 |
2237395 | 2237395 | 2022-02-21 | Wadena | Minnesota | 27159 | 4068 | 51 |
2237396 | 2237396 | 2022-02-21 | Waseca | Minnesota | 27161 | 5376 | 39 |
2237397 | 2237397 | 2022-02-21 | Washington | Minnesota | 27163 | 65380 | 463 |
2237398 | 2237398 | 2022-02-21 | Watonwan | Minnesota | 27165 | 2890 | 22 |
2237399 | 2237399 | 2022-02-21 | Wilkin | Minnesota | 27167 | 1597 | 22 |
2237400 | 2237400 | 2022-02-21 | Winona | Minnesota | 27169 | 12202 | 70 |
2237401 | 2237401 | 2022-02-21 | Wright | Minnesota | 27171 | 35932 | 298 |
2237402 | 2237402 | 2022-02-21 | Yellow Medicine | Minnesota | 27173 | 2471 | 28 |
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);