ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where date = "2022-04-29" 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 |
---|---|---|---|---|---|---|---|
2455306 | 2455306 | 2022-04-29 | Aitkin | Minnesota | 27001 | 3003 | 62 |
2455307 | 2455307 | 2022-04-29 | Anoka | Minnesota | 27003 | 99314 | 795 |
2455308 | 2455308 | 2022-04-29 | Becker | Minnesota | 27005 | 8862 | 93 |
2455309 | 2455309 | 2022-04-29 | Beltrami | Minnesota | 27007 | 12087 | 128 |
2455310 | 2455310 | 2022-04-29 | Benton | Minnesota | 27009 | 14136 | 174 |
2455311 | 2455311 | 2022-04-29 | Big Stone | Minnesota | 27011 | 1406 | 9 |
2455312 | 2455312 | 2022-04-29 | Blue Earth | Minnesota | 27013 | 18170 | 100 |
2455313 | 2455313 | 2022-04-29 | Brown | Minnesota | 27015 | 6555 | 81 |
2455314 | 2455314 | 2022-04-29 | Carlton | Minnesota | 27017 | 8996 | 96 |
2455315 | 2455315 | 2022-04-29 | Carver | Minnesota | 27019 | 26982 | 117 |
2455316 | 2455316 | 2022-04-29 | Cass | Minnesota | 27021 | 7053 | 80 |
2455317 | 2455317 | 2022-04-29 | Chippewa | Minnesota | 27023 | 3092 | 48 |
2455318 | 2455318 | 2022-04-29 | Chisago | Minnesota | 27025 | 14635 | 120 |
2455319 | 2455319 | 2022-04-29 | Clay | Minnesota | 27027 | 19920 | 124 |
2455320 | 2455320 | 2022-04-29 | Clearwater | Minnesota | 27029 | 2165 | 30 |
2455321 | 2455321 | 2022-04-29 | Cook | Minnesota | 27031 | 571 | 4 |
2455322 | 2455322 | 2022-04-29 | Cottonwood | Minnesota | 27033 | 3230 | 41 |
2455323 | 2455323 | 2022-04-29 | Crow Wing | Minnesota | 27035 | 16058 | 169 |
2455324 | 2455324 | 2022-04-29 | Dakota | Minnesota | 27037 | 111490 | 772 |
2455325 | 2455325 | 2022-04-29 | Dodge | Minnesota | 27039 | 5782 | 21 |
2455326 | 2455326 | 2022-04-29 | Douglas | Minnesota | 27041 | 10981 | 116 |
2455327 | 2455327 | 2022-04-29 | Faribault | Minnesota | 27043 | 3796 | 51 |
2455328 | 2455328 | 2022-04-29 | Fillmore | Minnesota | 27045 | 4840 | 24 |
2455329 | 2455329 | 2022-04-29 | Freeborn | Minnesota | 27047 | 9148 | 74 |
2455330 | 2455330 | 2022-04-29 | Goodhue | Minnesota | 27049 | 13341 | 133 |
2455331 | 2455331 | 2022-04-29 | Grant | Minnesota | 27051 | 1481 | 12 |
2455332 | 2455332 | 2022-04-29 | Hennepin | Minnesota | 27053 | 304826 | 2585 |
2455333 | 2455333 | 2022-04-29 | Houston | Minnesota | 27055 | 4587 | 18 |
2455334 | 2455334 | 2022-04-29 | Hubbard | Minnesota | 27057 | 4971 | 59 |
2455335 | 2455335 | 2022-04-29 | Isanti | Minnesota | 27059 | 10147 | 117 |
2455336 | 2455336 | 2022-04-29 | Itasca | Minnesota | 27061 | 11091 | 146 |
2455337 | 2455337 | 2022-04-29 | Jackson | Minnesota | 27063 | 2157 | 17 |
2455338 | 2455338 | 2022-04-29 | Kanabec | Minnesota | 27065 | 3535 | 56 |
2455339 | 2455339 | 2022-04-29 | Kandiyohi | Minnesota | 27067 | 13483 | 139 |
2455340 | 2455340 | 2022-04-29 | Kittson | Minnesota | 27069 | 1043 | 27 |
2455341 | 2455341 | 2022-04-29 | Koochiching | Minnesota | 27071 | 2748 | 37 |
2455342 | 2455342 | 2022-04-29 | Lac qui Parle | Minnesota | 27073 | 1750 | 29 |
2455343 | 2455343 | 2022-04-29 | Lake | Minnesota | 27075 | 2087 | 28 |
2455344 | 2455344 | 2022-04-29 | Lake of the Woods | Minnesota | 27077 | 770 | 6 |
2455345 | 2455345 | 2022-04-29 | Le Sueur | Minnesota | 27079 | 6521 | 51 |
2455346 | 2455346 | 2022-04-29 | Lincoln | Minnesota | 27081 | 1216 | 6 |
2455347 | 2455347 | 2022-04-29 | Lyon | Minnesota | 27083 | 7087 | 72 |
2455348 | 2455348 | 2022-04-29 | Mahnomen | Minnesota | 27087 | 1785 | 17 |
2455349 | 2455349 | 2022-04-29 | Marshall | Minnesota | 27089 | 2106 | 23 |
2455350 | 2455350 | 2022-04-29 | Martin | Minnesota | 27091 | 5624 | 64 |
2455351 | 2455351 | 2022-04-29 | McLeod | Minnesota | 27085 | 10640 | 108 |
2455352 | 2455352 | 2022-04-29 | Meeker | Minnesota | 27093 | 5964 | 75 |
2455353 | 2455353 | 2022-04-29 | Mille Lacs | Minnesota | 27095 | 7273 | 114 |
2455354 | 2455354 | 2022-04-29 | Morrison | Minnesota | 27097 | 9146 | 105 |
2455355 | 2455355 | 2022-04-29 | Mower | Minnesota | 27099 | 11956 | 73 |
2455356 | 2455356 | 2022-04-29 | Murray | Minnesota | 27101 | 2035 | 16 |
2455357 | 2455357 | 2022-04-29 | Nicollet | Minnesota | 27103 | 8119 | 66 |
2455358 | 2455358 | 2022-04-29 | Nobles | Minnesota | 27105 | 6965 | 60 |
2455359 | 2455359 | 2022-04-29 | Norman | Minnesota | 27107 | 1505 | 13 |
2455360 | 2455360 | 2022-04-29 | Olmsted | Minnesota | 27109 | 42216 | 182 |
2455361 | 2455361 | 2022-04-29 | Otter Tail | Minnesota | 27111 | 13636 | 167 |
2455362 | 2455362 | 2022-04-29 | Pennington | Minnesota | 27113 | 3620 | 41 |
2455363 | 2455363 | 2022-04-29 | Pine | Minnesota | 27115 | 7057 | 67 |
2455364 | 2455364 | 2022-04-29 | Pipestone | Minnesota | 27117 | 2002 | 34 |
2455365 | 2455365 | 2022-04-29 | Polk | Minnesota | 27119 | 8887 | 107 |
2455366 | 2455366 | 2022-04-29 | Pope | Minnesota | 27121 | 3051 | 17 |
2455367 | 2455367 | 2022-04-29 | Ramsey | Minnesota | 27123 | 126091 | 1337 |
2455368 | 2455368 | 2022-04-29 | Red Lake | Minnesota | 27125 | 944 | 13 |
2455369 | 2455369 | 2022-04-29 | Redwood | Minnesota | 27127 | 3950 | 53 |
2455370 | 2455370 | 2022-04-29 | Renville | Minnesota | 27129 | 3752 | 56 |
2455371 | 2455371 | 2022-04-29 | Rice | Minnesota | 27131 | 18052 | 176 |
2455372 | 2455372 | 2022-04-29 | Rock | Minnesota | 27133 | 2336 | 34 |
2455373 | 2455373 | 2022-04-29 | Roseau | Minnesota | 27135 | 4481 | 44 |
2455374 | 2455374 | 2022-04-29 | Scott | Minnesota | 27139 | 40566 | 260 |
2455375 | 2455375 | 2022-04-29 | Sherburne | Minnesota | 27141 | 27393 | 181 |
2455376 | 2455376 | 2022-04-29 | Sibley | Minnesota | 27143 | 3548 | 24 |
2455377 | 2455377 | 2022-04-29 | St. Louis | Minnesota | 27137 | 47585 | 531 |
2455378 | 2455378 | 2022-04-29 | Stearns | Minnesota | 27145 | 51131 | 367 |
2455379 | 2455379 | 2022-04-29 | Steele | Minnesota | 27147 | 10508 | 62 |
2455380 | 2455380 | 2022-04-29 | Stevens | Minnesota | 27149 | 2638 | 13 |
2455381 | 2455381 | 2022-04-29 | Swift | Minnesota | 27151 | 2299 | 33 |
2455382 | 2455382 | 2022-04-29 | Todd | Minnesota | 27153 | 6820 | 58 |
2455383 | 2455383 | 2022-04-29 | Traverse | Minnesota | 27155 | 858 | 10 |
2455384 | 2455384 | 2022-04-29 | Unknown | Minnesota | 1074 | 270 | |
2455385 | 2455385 | 2022-04-29 | Wabasha | Minnesota | 27157 | 5685 | 16 |
2455386 | 2455386 | 2022-04-29 | Wadena | Minnesota | 27159 | 4234 | 55 |
2455387 | 2455387 | 2022-04-29 | Waseca | Minnesota | 27161 | 5563 | 39 |
2455388 | 2455388 | 2022-04-29 | Washington | Minnesota | 27163 | 67767 | 479 |
2455389 | 2455389 | 2022-04-29 | Watonwan | Minnesota | 27165 | 2984 | 23 |
2455390 | 2455390 | 2022-04-29 | Wilkin | Minnesota | 27167 | 1658 | 22 |
2455391 | 2455391 | 2022-04-29 | Winona | Minnesota | 27169 | 12879 | 72 |
2455392 | 2455392 | 2022-04-29 | Wright | Minnesota | 27171 | 36777 | 305 |
2455393 | 2455393 | 2022-04-29 | Yellow Medicine | Minnesota | 27173 | 2544 | 29 |
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);