ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where date = "2021-08-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 |
---|---|---|---|---|---|---|---|
1668494 | 1668494 | 2021-08-30 | Aitkin | Minnesota | 27001 | 1474 | 37 |
1668495 | 1668495 | 2021-08-30 | Anoka | Minnesota | 27003 | 45678 | 472 |
1668496 | 1668496 | 2021-08-30 | Becker | Minnesota | 27005 | 4055 | 58 |
1668497 | 1668497 | 2021-08-30 | Beltrami | Minnesota | 27007 | 4549 | 68 |
1668498 | 1668498 | 2021-08-30 | Benton | Minnesota | 27009 | 6089 | 98 |
1668499 | 1668499 | 2021-08-30 | Big Stone | Minnesota | 27011 | 629 | 4 |
1668500 | 1668500 | 2021-08-30 | Blue Earth | Minnesota | 27013 | 8150 | 47 |
1668501 | 1668501 | 2021-08-30 | Brown | Minnesota | 27015 | 3276 | 42 |
1668502 | 1668502 | 2021-08-30 | Carlton | Minnesota | 27017 | 3733 | 59 |
1668503 | 1668503 | 2021-08-30 | Carver | Minnesota | 27019 | 11420 | 50 |
1668504 | 1668504 | 2021-08-30 | Cass | Minnesota | 27021 | 3091 | 34 |
1668505 | 1668505 | 2021-08-30 | Chippewa | Minnesota | 27023 | 1633 | 39 |
1668506 | 1668506 | 2021-08-30 | Chisago | Minnesota | 27025 | 6676 | 55 |
1668507 | 1668507 | 2021-08-30 | Clay | Minnesota | 27027 | 8649 | 92 |
1668508 | 1668508 | 2021-08-30 | Clearwater | Minnesota | 27029 | 948 | 18 |
1668509 | 1668509 | 2021-08-30 | Cook | Minnesota | 27031 | 196 | 0 |
1668510 | 1668510 | 2021-08-30 | Cottonwood | Minnesota | 27033 | 1718 | 24 |
1668511 | 1668511 | 2021-08-30 | Crow Wing | Minnesota | 27035 | 7318 | 100 |
1668512 | 1668512 | 2021-08-30 | Dakota | Minnesota | 27037 | 49736 | 486 |
1668513 | 1668513 | 2021-08-30 | Dodge | Minnesota | 27039 | 2172 | 3 |
1668514 | 1668514 | 2021-08-30 | Douglas | Minnesota | 27041 | 5068 | 83 |
1668515 | 1668515 | 2021-08-30 | Faribault | Minnesota | 27043 | 1661 | 22 |
1668516 | 1668516 | 2021-08-30 | Fillmore | Minnesota | 27045 | 1767 | 10 |
1668517 | 1668517 | 2021-08-30 | Freeborn | Minnesota | 27047 | 3899 | 37 |
1668518 | 1668518 | 2021-08-30 | Goodhue | Minnesota | 27049 | 5198 | 76 |
1668519 | 1668519 | 2021-08-30 | Grant | Minnesota | 27051 | 620 | 8 |
1668520 | 1668520 | 2021-08-30 | Hennepin | Minnesota | 27053 | 134308 | 1830 |
1668521 | 1668521 | 2021-08-30 | Houston | Minnesota | 27055 | 1902 | 16 |
1668522 | 1668522 | 2021-08-30 | Hubbard | Minnesota | 27057 | 2110 | 41 |
1668523 | 1668523 | 2021-08-30 | Isanti | Minnesota | 27059 | 4654 | 68 |
1668524 | 1668524 | 2021-08-30 | Itasca | Minnesota | 27061 | 4864 | 69 |
1668525 | 1668525 | 2021-08-30 | Jackson | Minnesota | 27063 | 1310 | 12 |
1668526 | 1668526 | 2021-08-30 | Kanabec | Minnesota | 27065 | 1560 | 29 |
1668527 | 1668527 | 2021-08-30 | Kandiyohi | Minnesota | 27067 | 7126 | 87 |
1668528 | 1668528 | 2021-08-30 | Kittson | Minnesota | 27069 | 509 | 22 |
1668529 | 1668529 | 2021-08-30 | Koochiching | Minnesota | 27071 | 1012 | 19 |
1668530 | 1668530 | 2021-08-30 | Lac qui Parle | Minnesota | 27073 | 795 | 22 |
1668531 | 1668531 | 2021-08-30 | Lake | Minnesota | 27075 | 879 | 21 |
1668532 | 1668532 | 2021-08-30 | Lake of the Woods | Minnesota | 27077 | 361 | 4 |
1668533 | 1668533 | 2021-08-30 | Le Sueur | Minnesota | 27079 | 3184 | 30 |
1668534 | 1668534 | 2021-08-30 | Lincoln | Minnesota | 27081 | 606 | 3 |
1668535 | 1668535 | 2021-08-30 | Lyon | Minnesota | 27083 | 3796 | 54 |
1668536 | 1668536 | 2021-08-30 | Mahnomen | Minnesota | 27087 | 615 | 9 |
1668537 | 1668537 | 2021-08-30 | Marshall | Minnesota | 27089 | 958 | 18 |
1668538 | 1668538 | 2021-08-30 | Martin | Minnesota | 27091 | 2469 | 33 |
1668539 | 1668539 | 2021-08-30 | McLeod | Minnesota | 27085 | 4630 | 61 |
1668540 | 1668540 | 2021-08-30 | Meeker | Minnesota | 27093 | 2857 | 46 |
1668541 | 1668541 | 2021-08-30 | Mille Lacs | Minnesota | 27095 | 3349 | 58 |
1668542 | 1668542 | 2021-08-30 | Morrison | Minnesota | 27097 | 4462 | 62 |
1668543 | 1668543 | 2021-08-30 | Mower | Minnesota | 27099 | 5186 | 34 |
1668544 | 1668544 | 2021-08-30 | Murray | Minnesota | 27101 | 1114 | 10 |
1668545 | 1668545 | 2021-08-30 | Nicollet | Minnesota | 27103 | 3524 | 46 |
1668546 | 1668546 | 2021-08-30 | Nobles | Minnesota | 27105 | 4277 | 50 |
1668547 | 1668547 | 2021-08-30 | Norman | Minnesota | 27107 | 587 | 9 |
1668548 | 1668548 | 2021-08-30 | Olmsted | Minnesota | 27109 | 14776 | 108 |
1668549 | 1668549 | 2021-08-30 | Otter Tail | Minnesota | 27111 | 6288 | 89 |
1668550 | 1668550 | 2021-08-30 | Pennington | Minnesota | 27113 | 1699 | 20 |
1668551 | 1668551 | 2021-08-30 | Pine | Minnesota | 27115 | 3583 | 23 |
1668552 | 1668552 | 2021-08-30 | Pipestone | Minnesota | 27117 | 1195 | 26 |
1668553 | 1668553 | 2021-08-30 | Polk | Minnesota | 27119 | 4073 | 75 |
1668554 | 1668554 | 2021-08-30 | Pope | Minnesota | 27121 | 1222 | 8 |
1668555 | 1668555 | 2021-08-30 | Ramsey | Minnesota | 27123 | 56074 | 924 |
1668556 | 1668556 | 2021-08-30 | Red Lake | Minnesota | 27125 | 434 | 7 |
1668557 | 1668557 | 2021-08-30 | Redwood | Minnesota | 27127 | 1870 | 41 |
1668558 | 1668558 | 2021-08-30 | Renville | Minnesota | 27129 | 1906 | 46 |
1668559 | 1668559 | 2021-08-30 | Rice | Minnesota | 27131 | 8695 | 113 |
1668560 | 1668560 | 2021-08-30 | Rock | Minnesota | 27133 | 1347 | 19 |
1668561 | 1668561 | 2021-08-30 | Roseau | Minnesota | 27135 | 2211 | 21 |
1668562 | 1668562 | 2021-08-30 | Scott | Minnesota | 27139 | 18637 | 141 |
1668563 | 1668563 | 2021-08-30 | Sherburne | Minnesota | 27141 | 12803 | 98 |
1668564 | 1668564 | 2021-08-30 | Sibley | Minnesota | 27143 | 1622 | 10 |
1668565 | 1668565 | 2021-08-30 | St. Louis | Minnesota | 27137 | 19145 | 325 |
1668566 | 1668566 | 2021-08-30 | Stearns | Minnesota | 27145 | 23717 | 231 |
1668567 | 1668567 | 2021-08-30 | Steele | Minnesota | 27147 | 4461 | 21 |
1668568 | 1668568 | 2021-08-30 | Stevens | Minnesota | 27149 | 972 | 11 |
1668569 | 1668569 | 2021-08-30 | Swift | Minnesota | 27151 | 1139 | 18 |
1668570 | 1668570 | 2021-08-30 | Todd | Minnesota | 27153 | 3036 | 33 |
1668571 | 1668571 | 2021-08-30 | Traverse | Minnesota | 27155 | 399 | 5 |
1668572 | 1668572 | 2021-08-30 | Unknown | Minnesota | 596 | 93 | |
1668573 | 1668573 | 2021-08-30 | Wabasha | Minnesota | 27157 | 2244 | 4 |
1668574 | 1668574 | 2021-08-30 | Wadena | Minnesota | 27159 | 1710 | 23 |
1668575 | 1668575 | 2021-08-30 | Waseca | Minnesota | 27161 | 2655 | 23 |
1668576 | 1668576 | 2021-08-30 | Washington | Minnesota | 27163 | 29263 | 304 |
1668577 | 1668577 | 2021-08-30 | Watonwan | Minnesota | 27165 | 1447 | 10 |
1668578 | 1668578 | 2021-08-30 | Wilkin | Minnesota | 27167 | 869 | 14 |
1668579 | 1668579 | 2021-08-30 | Winona | Minnesota | 27169 | 5087 | 52 |
1668580 | 1668580 | 2021-08-30 | Wright | Minnesota | 27171 | 17411 | 157 |
1668581 | 1668581 | 2021-08-30 | Yellow Medicine | Minnesota | 27173 | 1194 | 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);