ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where date = "2021-11-22" 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 |
---|---|---|---|---|---|---|---|
1941422 | 1941422 | 2021-11-22 | Aitkin | Minnesota | 27001 | 2119 | 48 |
1941423 | 1941423 | 2021-11-22 | Anoka | Minnesota | 27003 | 61024 | 560 |
1941424 | 1941424 | 2021-11-22 | Becker | Minnesota | 27005 | 6083 | 71 |
1941425 | 1941425 | 2021-11-22 | Beltrami | Minnesota | 27007 | 7873 | 92 |
1941426 | 1941426 | 2021-11-22 | Benton | Minnesota | 27009 | 8608 | 122 |
1941427 | 1941427 | 2021-11-22 | Big Stone | Minnesota | 27011 | 921 | 5 |
1941428 | 1941428 | 2021-11-22 | Blue Earth | Minnesota | 27013 | 11014 | 65 |
1941429 | 1941429 | 2021-11-22 | Brown | Minnesota | 27015 | 4571 | 57 |
1941430 | 1941430 | 2021-11-22 | Carlton | Minnesota | 27017 | 5155 | 72 |
1941431 | 1941431 | 2021-11-22 | Carver | Minnesota | 27019 | 15858 | 65 |
1941432 | 1941432 | 2021-11-22 | Cass | Minnesota | 27021 | 4834 | 51 |
1941433 | 1941433 | 2021-11-22 | Chippewa | Minnesota | 27023 | 2128 | 41 |
1941434 | 1941434 | 2021-11-22 | Chisago | Minnesota | 27025 | 9558 | 70 |
1941435 | 1941435 | 2021-11-22 | Clay | Minnesota | 27027 | 11708 | 102 |
1941436 | 1941436 | 2021-11-22 | Clearwater | Minnesota | 27029 | 1522 | 20 |
1941437 | 1941437 | 2021-11-22 | Cook | Minnesota | 27031 | 295 | 0 |
1941438 | 1941438 | 2021-11-22 | Cottonwood | Minnesota | 27033 | 2205 | 32 |
1941439 | 1941439 | 2021-11-22 | Crow Wing | Minnesota | 27035 | 10756 | 121 |
1941440 | 1941440 | 2021-11-22 | Dakota | Minnesota | 27037 | 64444 | 563 |
1941441 | 1941441 | 2021-11-22 | Dodge | Minnesota | 27039 | 3383 | 11 |
1941442 | 1941442 | 2021-11-22 | Douglas | Minnesota | 27041 | 7481 | 99 |
1941443 | 1941443 | 2021-11-22 | Faribault | Minnesota | 27043 | 2483 | 31 |
1941444 | 1941444 | 2021-11-22 | Fillmore | Minnesota | 27045 | 2918 | 15 |
1941445 | 1941445 | 2021-11-22 | Freeborn | Minnesota | 27047 | 5405 | 44 |
1941446 | 1941446 | 2021-11-22 | Goodhue | Minnesota | 27049 | 7599 | 93 |
1941447 | 1941447 | 2021-11-22 | Grant | Minnesota | 27051 | 945 | 9 |
1941448 | 1941448 | 2021-11-22 | Hennepin | Minnesota | 27053 | 171633 | 2004 |
1941449 | 1941449 | 2021-11-22 | Houston | Minnesota | 27055 | 2611 | 17 |
1941450 | 1941450 | 2021-11-22 | Hubbard | Minnesota | 27057 | 3404 | 48 |
1941451 | 1941451 | 2021-11-22 | Isanti | Minnesota | 27059 | 6657 | 83 |
1941452 | 1941452 | 2021-11-22 | Itasca | Minnesota | 27061 | 7347 | 93 |
1941453 | 1941453 | 2021-11-22 | Jackson | Minnesota | 27063 | 1580 | 16 |
1941454 | 1941454 | 2021-11-22 | Kanabec | Minnesota | 27065 | 2347 | 34 |
1941455 | 1941455 | 2021-11-22 | Kandiyohi | Minnesota | 27067 | 9513 | 104 |
1941456 | 1941456 | 2021-11-22 | Kittson | Minnesota | 27069 | 699 | 22 |
1941457 | 1941457 | 2021-11-22 | Koochiching | Minnesota | 27071 | 1613 | 22 |
1941458 | 1941458 | 2021-11-22 | Lac qui Parle | Minnesota | 27073 | 1171 | 25 |
1941459 | 1941459 | 2021-11-22 | Lake | Minnesota | 27075 | 1270 | 24 |
1941460 | 1941460 | 2021-11-22 | Lake of the Woods | Minnesota | 27077 | 520 | 5 |
1941461 | 1941461 | 2021-11-22 | Le Sueur | Minnesota | 27079 | 4365 | 33 |
1941462 | 1941462 | 2021-11-22 | Lincoln | Minnesota | 27081 | 859 | 5 |
1941463 | 1941463 | 2021-11-22 | Lyon | Minnesota | 27083 | 5102 | 61 |
1941464 | 1941464 | 2021-11-22 | Mahnomen | Minnesota | 27087 | 1037 | 14 |
1941465 | 1941465 | 2021-11-22 | Marshall | Minnesota | 27089 | 1491 | 21 |
1941466 | 1941466 | 2021-11-22 | Martin | Minnesota | 27091 | 3722 | 43 |
1941467 | 1941467 | 2021-11-22 | McLeod | Minnesota | 27085 | 6824 | 83 |
1941468 | 1941468 | 2021-11-22 | Meeker | Minnesota | 27093 | 4157 | 57 |
1941469 | 1941469 | 2021-11-22 | Mille Lacs | Minnesota | 27095 | 5016 | 71 |
1941470 | 1941470 | 2021-11-22 | Morrison | Minnesota | 27097 | 6515 | 78 |
1941471 | 1941471 | 2021-11-22 | Mower | Minnesota | 27099 | 7119 | 46 |
1941472 | 1941472 | 2021-11-22 | Murray | Minnesota | 27101 | 1495 | 11 |
1941473 | 1941473 | 2021-11-22 | Nicollet | Minnesota | 27103 | 4971 | 57 |
1941474 | 1941474 | 2021-11-22 | Nobles | Minnesota | 27105 | 5183 | 54 |
1941475 | 1941475 | 2021-11-22 | Norman | Minnesota | 27107 | 1018 | 9 |
1941476 | 1941476 | 2021-11-22 | Olmsted | Minnesota | 27109 | 21150 | 126 |
1941477 | 1941477 | 2021-11-22 | Otter Tail | Minnesota | 27111 | 9439 | 123 |
1941478 | 1941478 | 2021-11-22 | Pennington | Minnesota | 27113 | 2417 | 29 |
1941479 | 1941479 | 2021-11-22 | Pine | Minnesota | 27115 | 4897 | 41 |
1941480 | 1941480 | 2021-11-22 | Pipestone | Minnesota | 27117 | 1470 | 29 |
1941481 | 1941481 | 2021-11-22 | Polk | Minnesota | 27119 | 5810 | 84 |
1941482 | 1941482 | 2021-11-22 | Pope | Minnesota | 27121 | 1964 | 10 |
1941483 | 1941483 | 2021-11-22 | Ramsey | Minnesota | 27123 | 70883 | 1030 |
1941484 | 1941484 | 2021-11-22 | Red Lake | Minnesota | 27125 | 687 | 10 |
1941485 | 1941485 | 2021-11-22 | Redwood | Minnesota | 27127 | 2729 | 45 |
1941486 | 1941486 | 2021-11-22 | Renville | Minnesota | 27129 | 2598 | 51 |
1941487 | 1941487 | 2021-11-22 | Rice | Minnesota | 27131 | 10992 | 137 |
1941488 | 1941488 | 2021-11-22 | Rock | Minnesota | 27133 | 1729 | 28 |
1941489 | 1941489 | 2021-11-22 | Roseau | Minnesota | 27135 | 3047 | 31 |
1941490 | 1941490 | 2021-11-22 | Scott | Minnesota | 27139 | 24685 | 177 |
1941491 | 1941491 | 2021-11-22 | Sherburne | Minnesota | 27141 | 18030 | 122 |
1941492 | 1941492 | 2021-11-22 | Sibley | Minnesota | 27143 | 2407 | 17 |
1941493 | 1941493 | 2021-11-22 | St. Louis | Minnesota | 27137 | 27846 | 387 |
1941494 | 1941494 | 2021-11-22 | Stearns | Minnesota | 27145 | 32146 | 271 |
1941495 | 1941495 | 2021-11-22 | Steele | Minnesota | 27147 | 6552 | 30 |
1941496 | 1941496 | 2021-11-22 | Stevens | Minnesota | 27149 | 1610 | 11 |
1941497 | 1941497 | 2021-11-22 | Swift | Minnesota | 27151 | 1655 | 22 |
1941498 | 1941498 | 2021-11-22 | Todd | Minnesota | 27153 | 4747 | 40 |
1941499 | 1941499 | 2021-11-22 | Traverse | Minnesota | 27155 | 593 | 6 |
1941500 | 1941500 | 2021-11-22 | Unknown | Minnesota | 672 | 124 | |
1941501 | 1941501 | 2021-11-22 | Wabasha | Minnesota | 27157 | 3576 | 9 |
1941502 | 1941502 | 2021-11-22 | Wadena | Minnesota | 27159 | 2927 | 37 |
1941503 | 1941503 | 2021-11-22 | Waseca | Minnesota | 27161 | 3587 | 32 |
1941504 | 1941504 | 2021-11-22 | Washington | Minnesota | 27163 | 38455 | 348 |
1941505 | 1941505 | 2021-11-22 | Watonwan | Minnesota | 27165 | 1923 | 20 |
1941506 | 1941506 | 2021-11-22 | Wilkin | Minnesota | 27167 | 1171 | 15 |
1941507 | 1941507 | 2021-11-22 | Winona | Minnesota | 27169 | 6913 | 56 |
1941508 | 1941508 | 2021-11-22 | Wright | Minnesota | 27171 | 24789 | 198 |
1941509 | 1941509 | 2021-11-22 | Yellow Medicine | Minnesota | 27173 | 1816 | 21 |
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);