ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where date = "2020-12-13" 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 |
---|---|---|---|---|---|---|---|
824402 | 824402 | 2020-12-13 | Aitkin | Minnesota | 27001 | 926 | 31 |
824403 | 824403 | 2020-12-13 | Anoka | Minnesota | 27003 | 26575 | 262 |
824404 | 824404 | 2020-12-13 | Becker | Minnesota | 27005 | 2492 | 29 |
824405 | 824405 | 2020-12-13 | Beltrami | Minnesota | 27007 | 2603 | 27 |
824406 | 824406 | 2020-12-13 | Benton | Minnesota | 27009 | 3562 | 65 |
824407 | 824407 | 2020-12-13 | Big Stone | Minnesota | 27011 | 404 | 2 |
824408 | 824408 | 2020-12-13 | Blue Earth | Minnesota | 27013 | 4696 | 22 |
824409 | 824409 | 2020-12-13 | Brown | Minnesota | 27015 | 1818 | 23 |
824410 | 824410 | 2020-12-13 | Carlton | Minnesota | 27017 | 2347 | 29 |
824411 | 824411 | 2020-12-13 | Carver | Minnesota | 27019 | 5876 | 22 |
824412 | 824412 | 2020-12-13 | Cass | Minnesota | 27021 | 1764 | 13 |
824413 | 824413 | 2020-12-13 | Chippewa | Minnesota | 27023 | 1117 | 18 |
824414 | 824414 | 2020-12-13 | Chisago | Minnesota | 27025 | 3759 | 24 |
824415 | 824415 | 2020-12-13 | Clay | Minnesota | 27027 | 5757 | 69 |
824416 | 824416 | 2020-12-13 | Clearwater | Minnesota | 27029 | 610 | 10 |
824417 | 824417 | 2020-12-13 | Cook | Minnesota | 27031 | 97 | 0 |
824418 | 824418 | 2020-12-13 | Cottonwood | Minnesota | 27033 | 1128 | 5 |
824419 | 824419 | 2020-12-13 | Crow Wing | Minnesota | 27035 | 4243 | 47 |
824420 | 824420 | 2020-12-13 | Dakota | Minnesota | 27037 | 27132 | 234 |
824421 | 824421 | 2020-12-13 | Dodge | Minnesota | 27039 | 1049 | 3 |
824422 | 824422 | 2020-12-13 | Douglas | Minnesota | 27041 | 3176 | 50 |
824423 | 824423 | 2020-12-13 | Faribault | Minnesota | 27043 | 770 | 5 |
824424 | 824424 | 2020-12-13 | Fillmore | Minnesota | 27045 | 919 | 0 |
824425 | 824425 | 2020-12-13 | Freeborn | Minnesota | 27047 | 1789 | 14 |
824426 | 824426 | 2020-12-13 | Goodhue | Minnesota | 27049 | 2622 | 35 |
824427 | 824427 | 2020-12-13 | Grant | Minnesota | 27051 | 343 | 7 |
824428 | 824428 | 2020-12-13 | Hennepin | Minnesota | 27053 | 79134 | 1243 |
824429 | 824429 | 2020-12-13 | Houston | Minnesota | 27055 | 994 | 5 |
824430 | 824430 | 2020-12-13 | Hubbard | Minnesota | 27057 | 1290 | 33 |
824431 | 824431 | 2020-12-13 | Isanti | Minnesota | 27059 | 2386 | 24 |
824432 | 824432 | 2020-12-13 | Itasca | Minnesota | 27061 | 2417 | 29 |
824433 | 824433 | 2020-12-13 | Jackson | Minnesota | 27063 | 688 | 3 |
824434 | 824434 | 2020-12-13 | Kanabec | Minnesota | 27065 | 845 | 18 |
824435 | 824435 | 2020-12-13 | Kandiyohi | Minnesota | 27067 | 5016 | 47 |
824436 | 824436 | 2020-12-13 | Kittson | Minnesota | 27069 | 324 | 13 |
824437 | 824437 | 2020-12-13 | Koochiching | Minnesota | 27071 | 492 | 7 |
824438 | 824438 | 2020-12-13 | Lac qui Parle | Minnesota | 27073 | 519 | 7 |
824439 | 824439 | 2020-12-13 | Lake | Minnesota | 27075 | 496 | 11 |
824440 | 824440 | 2020-12-13 | Lake of the Woods | Minnesota | 27077 | 136 | 1 |
824441 | 824441 | 2020-12-13 | Le Sueur | Minnesota | 27079 | 1782 | 13 |
824442 | 824442 | 2020-12-13 | Lincoln | Minnesota | 27081 | 427 | 1 |
824443 | 824443 | 2020-12-13 | Lyon | Minnesota | 27083 | 2609 | 23 |
824444 | 824444 | 2020-12-13 | Mahnomen | Minnesota | 27087 | 358 | 6 |
824445 | 824445 | 2020-12-13 | Marshall | Minnesota | 27089 | 622 | 11 |
824446 | 824446 | 2020-12-13 | Martin | Minnesota | 27091 | 1422 | 23 |
824447 | 824447 | 2020-12-13 | McLeod | Minnesota | 27085 | 2820 | 30 |
824448 | 824448 | 2020-12-13 | Meeker | Minnesota | 27093 | 1741 | 22 |
824449 | 824449 | 2020-12-13 | Mille Lacs | Minnesota | 27095 | 1872 | 38 |
824450 | 824450 | 2020-12-13 | Morrison | Minnesota | 27097 | 2724 | 36 |
824451 | 824451 | 2020-12-13 | Mower | Minnesota | 27099 | 3086 | 23 |
824452 | 824452 | 2020-12-13 | Murray | Minnesota | 27101 | 699 | 5 |
824453 | 824453 | 2020-12-13 | Nicollet | Minnesota | 27103 | 1899 | 30 |
824454 | 824454 | 2020-12-13 | Nobles | Minnesota | 27105 | 3383 | 41 |
824455 | 824455 | 2020-12-13 | Norman | Minnesota | 27107 | 398 | 7 |
824456 | 824456 | 2020-12-13 | Olmsted | Minnesota | 27109 | 8082 | 46 |
824457 | 824457 | 2020-12-13 | Otter Tail | Minnesota | 27111 | 3862 | 37 |
824458 | 824458 | 2020-12-13 | Pennington | Minnesota | 27113 | 830 | 10 |
824459 | 824459 | 2020-12-13 | Pine | Minnesota | 27115 | 1969 | 10 |
824460 | 824460 | 2020-12-13 | Pipestone | Minnesota | 27117 | 834 | 18 |
824461 | 824461 | 2020-12-13 | Polk | Minnesota | 27119 | 3043 | 39 |
824462 | 824462 | 2020-12-13 | Pope | Minnesota | 27121 | 638 | 3 |
824463 | 824463 | 2020-12-13 | Ramsey | Minnesota | 27123 | 33697 | 590 |
824464 | 824464 | 2020-12-13 | Red Lake | Minnesota | 27125 | 274 | 3 |
824465 | 824465 | 2020-12-13 | Redwood | Minnesota | 27127 | 1192 | 22 |
824466 | 824466 | 2020-12-13 | Renville | Minnesota | 27129 | 1180 | 34 |
824467 | 824467 | 2020-12-13 | Rice | Minnesota | 27131 | 4885 | 45 |
824468 | 824468 | 2020-12-13 | Rock | Minnesota | 27133 | 965 | 10 |
824469 | 824469 | 2020-12-13 | Roseau | Minnesota | 27135 | 1518 | 9 |
824470 | 824470 | 2020-12-13 | Scott | Minnesota | 27139 | 10091 | 70 |
824471 | 824471 | 2020-12-13 | Sherburne | Minnesota | 27141 | 7010 | 49 |
824472 | 824472 | 2020-12-13 | Sibley | Minnesota | 27143 | 928 | 4 |
824473 | 824473 | 2020-12-13 | St. Louis | Minnesota | 27137 | 11121 | 158 |
824474 | 824474 | 2020-12-13 | Stearns | Minnesota | 27145 | 15926 | 145 |
824475 | 824475 | 2020-12-13 | Steele | Minnesota | 27147 | 2341 | 9 |
824476 | 824476 | 2020-12-13 | Stevens | Minnesota | 27149 | 619 | 5 |
824477 | 824477 | 2020-12-13 | Swift | Minnesota | 27151 | 736 | 13 |
824478 | 824478 | 2020-12-13 | Todd | Minnesota | 27153 | 2107 | 18 |
824479 | 824479 | 2020-12-13 | Traverse | Minnesota | 27155 | 176 | 2 |
824480 | 824480 | 2020-12-13 | Unknown | Minnesota | 506 | 59 | |
824481 | 824481 | 2020-12-13 | Wabasha | Minnesota | 27157 | 1334 | 2 |
824482 | 824482 | 2020-12-13 | Wadena | Minnesota | 27159 | 1015 | 9 |
824483 | 824483 | 2020-12-13 | Waseca | Minnesota | 27161 | 1565 | 11 |
824484 | 824484 | 2020-12-13 | Washington | Minnesota | 27163 | 16830 | 150 |
824485 | 824485 | 2020-12-13 | Watonwan | Minnesota | 27165 | 990 | 5 |
824486 | 824486 | 2020-12-13 | Wilkin | Minnesota | 27167 | 529 | 5 |
824487 | 824487 | 2020-12-13 | Winona | Minnesota | 27169 | 3291 | 39 |
824488 | 824488 | 2020-12-13 | Wright | Minnesota | 27171 | 9853 | 65 |
824489 | 824489 | 2020-12-13 | Yellow Medicine | Minnesota | 27173 | 792 | 13 |
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);