ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where date = "2021-10-05" 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 |
---|---|---|---|---|---|---|---|
1785452 | 1785452 | 2021-10-05 | Aitkin | Minnesota | 27001 | 1668 | 40 |
1785453 | 1785453 | 2021-10-05 | Anoka | Minnesota | 27003 | 51005 | 498 |
1785454 | 1785454 | 2021-10-05 | Becker | Minnesota | 27005 | 4927 | 61 |
1785455 | 1785455 | 2021-10-05 | Beltrami | Minnesota | 27007 | 5871 | 72 |
1785456 | 1785456 | 2021-10-05 | Benton | Minnesota | 27009 | 7021 | 102 |
1785457 | 1785457 | 2021-10-05 | Big Stone | Minnesota | 27011 | 740 | 4 |
1785458 | 1785458 | 2021-10-05 | Blue Earth | Minnesota | 27013 | 9193 | 53 |
1785459 | 1785459 | 2021-10-05 | Brown | Minnesota | 27015 | 3787 | 44 |
1785460 | 1785460 | 2021-10-05 | Carlton | Minnesota | 27017 | 4167 | 60 |
1785461 | 1785461 | 2021-10-05 | Carver | Minnesota | 27019 | 12838 | 53 |
1785462 | 1785462 | 2021-10-05 | Cass | Minnesota | 27021 | 3832 | 41 |
1785463 | 1785463 | 2021-10-05 | Chippewa | Minnesota | 27023 | 1774 | 39 |
1785464 | 1785464 | 2021-10-05 | Chisago | Minnesota | 27025 | 7717 | 59 |
1785465 | 1785465 | 2021-10-05 | Clay | Minnesota | 27027 | 9659 | 98 |
1785466 | 1785466 | 2021-10-05 | Clearwater | Minnesota | 27029 | 1245 | 18 |
1785467 | 1785467 | 2021-10-05 | Cook | Minnesota | 27031 | 223 | 0 |
1785468 | 1785468 | 2021-10-05 | Cottonwood | Minnesota | 27033 | 1856 | 24 |
1785469 | 1785469 | 2021-10-05 | Crow Wing | Minnesota | 27035 | 8687 | 104 |
1785470 | 1785470 | 2021-10-05 | Dakota | Minnesota | 27037 | 54525 | 509 |
1785471 | 1785471 | 2021-10-05 | Dodge | Minnesota | 27039 | 2588 | 6 |
1785472 | 1785472 | 2021-10-05 | Douglas | Minnesota | 27041 | 5827 | 85 |
1785473 | 1785473 | 2021-10-05 | Faribault | Minnesota | 27043 | 2009 | 26 |
1785474 | 1785474 | 2021-10-05 | Fillmore | Minnesota | 27045 | 2145 | 11 |
1785475 | 1785475 | 2021-10-05 | Freeborn | Minnesota | 27047 | 4593 | 42 |
1785476 | 1785476 | 2021-10-05 | Goodhue | Minnesota | 27049 | 5797 | 82 |
1785477 | 1785477 | 2021-10-05 | Grant | Minnesota | 27051 | 725 | 9 |
1785478 | 1785478 | 2021-10-05 | Hennepin | Minnesota | 27053 | 146828 | 1881 |
1785479 | 1785479 | 2021-10-05 | Houston | Minnesota | 27055 | 2199 | 17 |
1785480 | 1785480 | 2021-10-05 | Hubbard | Minnesota | 27057 | 2642 | 41 |
1785481 | 1785481 | 2021-10-05 | Isanti | Minnesota | 27059 | 5291 | 71 |
1785482 | 1785482 | 2021-10-05 | Itasca | Minnesota | 27061 | 5634 | 73 |
1785483 | 1785483 | 2021-10-05 | Jackson | Minnesota | 27063 | 1402 | 12 |
1785484 | 1785484 | 2021-10-05 | Kanabec | Minnesota | 27065 | 1768 | 29 |
1785485 | 1785485 | 2021-10-05 | Kandiyohi | Minnesota | 27067 | 7831 | 94 |
1785486 | 1785486 | 2021-10-05 | Kittson | Minnesota | 27069 | 573 | 22 |
1785487 | 1785487 | 2021-10-05 | Koochiching | Minnesota | 27071 | 1337 | 19 |
1785488 | 1785488 | 2021-10-05 | Lac qui Parle | Minnesota | 27073 | 921 | 24 |
1785489 | 1785489 | 2021-10-05 | Lake | Minnesota | 27075 | 1020 | 21 |
1785490 | 1785490 | 2021-10-05 | Lake of the Woods | Minnesota | 27077 | 435 | 4 |
1785491 | 1785491 | 2021-10-05 | Le Sueur | Minnesota | 27079 | 3628 | 30 |
1785492 | 1785492 | 2021-10-05 | Lincoln | Minnesota | 27081 | 708 | 4 |
1785493 | 1785493 | 2021-10-05 | Lyon | Minnesota | 27083 | 4236 | 54 |
1785494 | 1785494 | 2021-10-05 | Mahnomen | Minnesota | 27087 | 789 | 10 |
1785495 | 1785495 | 2021-10-05 | Marshall | Minnesota | 27089 | 1194 | 19 |
1785496 | 1785496 | 2021-10-05 | Martin | Minnesota | 27091 | 2935 | 33 |
1785497 | 1785497 | 2021-10-05 | McLeod | Minnesota | 27085 | 5480 | 66 |
1785498 | 1785498 | 2021-10-05 | Meeker | Minnesota | 27093 | 3329 | 51 |
1785499 | 1785499 | 2021-10-05 | Mille Lacs | Minnesota | 27095 | 3796 | 63 |
1785500 | 1785500 | 2021-10-05 | Morrison | Minnesota | 27097 | 5083 | 63 |
1785501 | 1785501 | 2021-10-05 | Mower | Minnesota | 27099 | 6038 | 39 |
1785502 | 1785502 | 2021-10-05 | Murray | Minnesota | 27101 | 1246 | 10 |
1785503 | 1785503 | 2021-10-05 | Nicollet | Minnesota | 27103 | 4025 | 49 |
1785504 | 1785504 | 2021-10-05 | Nobles | Minnesota | 27105 | 4667 | 51 |
1785505 | 1785505 | 2021-10-05 | Norman | Minnesota | 27107 | 759 | 9 |
1785506 | 1785506 | 2021-10-05 | Olmsted | Minnesota | 27109 | 17009 | 112 |
1785507 | 1785507 | 2021-10-05 | Otter Tail | Minnesota | 27111 | 7309 | 100 |
1785508 | 1785508 | 2021-10-05 | Pennington | Minnesota | 27113 | 2044 | 23 |
1785509 | 1785509 | 2021-10-05 | Pine | Minnesota | 27115 | 4005 | 29 |
1785510 | 1785510 | 2021-10-05 | Pipestone | Minnesota | 27117 | 1283 | 27 |
1785511 | 1785511 | 2021-10-05 | Polk | Minnesota | 27119 | 4760 | 75 |
1785512 | 1785512 | 2021-10-05 | Pope | Minnesota | 27121 | 1416 | 8 |
1785513 | 1785513 | 2021-10-05 | Ramsey | Minnesota | 27123 | 60958 | 959 |
1785514 | 1785514 | 2021-10-05 | Red Lake | Minnesota | 27125 | 545 | 8 |
1785515 | 1785515 | 2021-10-05 | Redwood | Minnesota | 27127 | 2204 | 43 |
1785516 | 1785516 | 2021-10-05 | Renville | Minnesota | 27129 | 2148 | 48 |
1785517 | 1785517 | 2021-10-05 | Rice | Minnesota | 27131 | 9558 | 127 |
1785518 | 1785518 | 2021-10-05 | Rock | Minnesota | 27133 | 1483 | 19 |
1785519 | 1785519 | 2021-10-05 | Roseau | Minnesota | 27135 | 2494 | 24 |
1785520 | 1785520 | 2021-10-05 | Scott | Minnesota | 27139 | 20634 | 153 |
1785521 | 1785521 | 2021-10-05 | Sherburne | Minnesota | 27141 | 14559 | 109 |
1785522 | 1785522 | 2021-10-05 | Sibley | Minnesota | 27143 | 1904 | 12 |
1785523 | 1785523 | 2021-10-05 | St. Louis | Minnesota | 27137 | 22024 | 344 |
1785524 | 1785524 | 2021-10-05 | Stearns | Minnesota | 27145 | 26682 | 248 |
1785525 | 1785525 | 2021-10-05 | Steele | Minnesota | 27147 | 5466 | 21 |
1785526 | 1785526 | 2021-10-05 | Stevens | Minnesota | 27149 | 1148 | 11 |
1785527 | 1785527 | 2021-10-05 | Swift | Minnesota | 27151 | 1267 | 19 |
1785528 | 1785528 | 2021-10-05 | Todd | Minnesota | 27153 | 3556 | 35 |
1785529 | 1785529 | 2021-10-05 | Traverse | Minnesota | 27155 | 473 | 5 |
1785530 | 1785530 | 2021-10-05 | Unknown | Minnesota | 654 | 113 | |
1785531 | 1785531 | 2021-10-05 | Wabasha | Minnesota | 27157 | 2655 | 5 |
1785532 | 1785532 | 2021-10-05 | Wadena | Minnesota | 27159 | 2126 | 27 |
1785533 | 1785533 | 2021-10-05 | Waseca | Minnesota | 27161 | 3129 | 26 |
1785534 | 1785534 | 2021-10-05 | Washington | Minnesota | 27163 | 32185 | 322 |
1785535 | 1785535 | 2021-10-05 | Watonwan | Minnesota | 27165 | 1638 | 11 |
1785536 | 1785536 | 2021-10-05 | Wilkin | Minnesota | 27167 | 950 | 14 |
1785537 | 1785537 | 2021-10-05 | Winona | Minnesota | 27169 | 5855 | 52 |
1785538 | 1785538 | 2021-10-05 | Wright | Minnesota | 27171 | 19831 | 168 |
1785539 | 1785539 | 2021-10-05 | Yellow Medicine | Minnesota | 27173 | 1399 | 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);