ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where date = "2020-11-27" 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 |
---|---|---|---|---|---|---|---|
772479 | 772479 | 2020-11-27 | Aitkin | Minnesota | 27001 | 717 | 29 |
772480 | 772480 | 2020-11-27 | Anoka | Minnesota | 27003 | 20851 | 224 |
772481 | 772481 | 2020-11-27 | Becker | Minnesota | 27005 | 1940 | 15 |
772482 | 772482 | 2020-11-27 | Beltrami | Minnesota | 27007 | 2025 | 17 |
772483 | 772483 | 2020-11-27 | Benton | Minnesota | 27009 | 2858 | 47 |
772484 | 772484 | 2020-11-27 | Big Stone | Minnesota | 27011 | 296 | 2 |
772485 | 772485 | 2020-11-27 | Blue Earth | Minnesota | 27013 | 3958 | 13 |
772486 | 772486 | 2020-11-27 | Brown | Minnesota | 27015 | 1312 | 15 |
772487 | 772487 | 2020-11-27 | Carlton | Minnesota | 27017 | 1704 | 14 |
772488 | 772488 | 2020-11-27 | Carver | Minnesota | 27019 | 4432 | 13 |
772489 | 772489 | 2020-11-27 | Cass | Minnesota | 27021 | 1333 | 10 |
772490 | 772490 | 2020-11-27 | Chippewa | Minnesota | 27023 | 815 | 7 |
772491 | 772491 | 2020-11-27 | Chisago | Minnesota | 27025 | 2979 | 9 |
772492 | 772492 | 2020-11-27 | Clay | Minnesota | 27027 | 4733 | 56 |
772493 | 772493 | 2020-11-27 | Clearwater | Minnesota | 27029 | 481 | 7 |
772494 | 772494 | 2020-11-27 | Cook | Minnesota | 27031 | 63 | 0 |
772495 | 772495 | 2020-11-27 | Cottonwood | Minnesota | 27033 | 794 | 2 |
772496 | 772496 | 2020-11-27 | Crow Wing | Minnesota | 27035 | 3447 | 31 |
772497 | 772497 | 2020-11-27 | Dakota | Minnesota | 27037 | 20527 | 189 |
772498 | 772498 | 2020-11-27 | Dodge | Minnesota | 27039 | 823 | 0 |
772499 | 772499 | 2020-11-27 | Douglas | Minnesota | 27041 | 2422 | 35 |
772500 | 772500 | 2020-11-27 | Faribault | Minnesota | 27043 | 525 | 1 |
772501 | 772501 | 2020-11-27 | Fillmore | Minnesota | 27045 | 651 | 0 |
772502 | 772502 | 2020-11-27 | Freeborn | Minnesota | 27047 | 1479 | 5 |
772503 | 772503 | 2020-11-27 | Goodhue | Minnesota | 27049 | 1906 | 28 |
772504 | 772504 | 2020-11-27 | Grant | Minnesota | 27051 | 256 | 6 |
772505 | 772505 | 2020-11-27 | Hennepin | Minnesota | 27053 | 62433 | 1107 |
772506 | 772506 | 2020-11-27 | Houston | Minnesota | 27055 | 653 | 4 |
772507 | 772507 | 2020-11-27 | Hubbard | Minnesota | 27057 | 1075 | 23 |
772508 | 772508 | 2020-11-27 | Isanti | Minnesota | 27059 | 1790 | 16 |
772509 | 772509 | 2020-11-27 | Itasca | Minnesota | 27061 | 1791 | 23 |
772510 | 772510 | 2020-11-27 | Jackson | Minnesota | 27063 | 458 | 1 |
772511 | 772511 | 2020-11-27 | Kanabec | Minnesota | 27065 | 557 | 13 |
772512 | 772512 | 2020-11-27 | Kandiyohi | Minnesota | 27067 | 3787 | 19 |
772513 | 772513 | 2020-11-27 | Kittson | Minnesota | 27069 | 202 | 7 |
772514 | 772514 | 2020-11-27 | Koochiching | Minnesota | 27071 | 367 | 5 |
772515 | 772515 | 2020-11-27 | Lac qui Parle | Minnesota | 27073 | 351 | 3 |
772516 | 772516 | 2020-11-27 | Lake | Minnesota | 27075 | 391 | 6 |
772517 | 772517 | 2020-11-27 | Lake of the Woods | Minnesota | 27077 | 94 | 1 |
772518 | 772518 | 2020-11-27 | Le Sueur | Minnesota | 27079 | 1411 | 11 |
772519 | 772519 | 2020-11-27 | Lincoln | Minnesota | 27081 | 333 | 1 |
772520 | 772520 | 2020-11-27 | Lyon | Minnesota | 27083 | 2067 | 11 |
772521 | 772521 | 2020-11-27 | Mahnomen | Minnesota | 27087 | 283 | 4 |
772522 | 772522 | 2020-11-27 | Marshall | Minnesota | 27089 | 450 | 8 |
772523 | 772523 | 2020-11-27 | Martin | Minnesota | 27091 | 1055 | 20 |
772524 | 772524 | 2020-11-27 | McLeod | Minnesota | 27085 | 1985 | 11 |
772525 | 772525 | 2020-11-27 | Meeker | Minnesota | 27093 | 1163 | 8 |
772526 | 772526 | 2020-11-27 | Mille Lacs | Minnesota | 27095 | 1451 | 31 |
772527 | 772527 | 2020-11-27 | Morrison | Minnesota | 27097 | 2240 | 27 |
772528 | 772528 | 2020-11-27 | Mower | Minnesota | 27099 | 2485 | 23 |
772529 | 772529 | 2020-11-27 | Murray | Minnesota | 27101 | 562 | 3 |
772530 | 772530 | 2020-11-27 | Nicollet | Minnesota | 27103 | 1549 | 25 |
772531 | 772531 | 2020-11-27 | Nobles | Minnesota | 27105 | 3014 | 29 |
772532 | 772532 | 2020-11-27 | Norman | Minnesota | 27107 | 330 | 7 |
772533 | 772533 | 2020-11-27 | Olmsted | Minnesota | 27109 | 6399 | 34 |
772534 | 772534 | 2020-11-27 | Otter Tail | Minnesota | 27111 | 2888 | 20 |
772535 | 772535 | 2020-11-27 | Pennington | Minnesota | 27113 | 613 | 7 |
772536 | 772536 | 2020-11-27 | Pine | Minnesota | 27115 | 1278 | 8 |
772537 | 772537 | 2020-11-27 | Pipestone | Minnesota | 27117 | 696 | 18 |
772538 | 772538 | 2020-11-27 | Polk | Minnesota | 27119 | 2382 | 23 |
772539 | 772539 | 2020-11-27 | Pope | Minnesota | 27121 | 507 | 1 |
772540 | 772540 | 2020-11-27 | Ramsey | Minnesota | 27123 | 26238 | 493 |
772541 | 772541 | 2020-11-27 | Red Lake | Minnesota | 27125 | 203 | 3 |
772542 | 772542 | 2020-11-27 | Redwood | Minnesota | 27127 | 875 | 18 |
772543 | 772543 | 2020-11-27 | Renville | Minnesota | 27129 | 773 | 22 |
772544 | 772544 | 2020-11-27 | Rice | Minnesota | 27131 | 3933 | 35 |
772545 | 772545 | 2020-11-27 | Rock | Minnesota | 27133 | 714 | 9 |
772546 | 772546 | 2020-11-27 | Roseau | Minnesota | 27135 | 1107 | 4 |
772547 | 772547 | 2020-11-27 | Scott | Minnesota | 27139 | 7981 | 54 |
772548 | 772548 | 2020-11-27 | Sherburne | Minnesota | 27141 | 5522 | 41 |
772549 | 772549 | 2020-11-27 | Sibley | Minnesota | 27143 | 756 | 4 |
772550 | 772550 | 2020-11-27 | St. Louis | Minnesota | 27137 | 8141 | 108 |
772551 | 772551 | 2020-11-27 | Stearns | Minnesota | 27145 | 13245 | 106 |
772552 | 772552 | 2020-11-27 | Steele | Minnesota | 27147 | 1833 | 6 |
772553 | 772553 | 2020-11-27 | Stevens | Minnesota | 27149 | 481 | 3 |
772554 | 772554 | 2020-11-27 | Swift | Minnesota | 27151 | 544 | 8 |
772555 | 772555 | 2020-11-27 | Todd | Minnesota | 27153 | 1739 | 12 |
772556 | 772556 | 2020-11-27 | Traverse | Minnesota | 27155 | 139 | 1 |
772557 | 772557 | 2020-11-27 | Unknown | Minnesota | 445 | 59 | |
772558 | 772558 | 2020-11-27 | Wabasha | Minnesota | 27157 | 994 | 1 |
772559 | 772559 | 2020-11-27 | Wadena | Minnesota | 27159 | 747 | 6 |
772560 | 772560 | 2020-11-27 | Waseca | Minnesota | 27161 | 1359 | 11 |
772561 | 772561 | 2020-11-27 | Washington | Minnesota | 27163 | 13220 | 111 |
772562 | 772562 | 2020-11-27 | Watonwan | Minnesota | 27165 | 810 | 4 |
772563 | 772563 | 2020-11-27 | Wilkin | Minnesota | 27167 | 360 | 5 |
772564 | 772564 | 2020-11-27 | Winona | Minnesota | 27169 | 2666 | 29 |
772565 | 772565 | 2020-11-27 | Wright | Minnesota | 27171 | 7203 | 38 |
772566 | 772566 | 2020-11-27 | Yellow Medicine | Minnesota | 27173 | 615 | 11 |
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);