ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where date = "2022-01-01" 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 |
---|---|---|---|---|---|---|---|
2071440 | 2071440 | 2022-01-01 | Aitkin | Minnesota | 27001 | 2424 | 54 |
2071441 | 2071441 | 2022-01-01 | Anoka | Minnesota | 27003 | 71618 | 676 |
2071442 | 2071442 | 2022-01-01 | Becker | Minnesota | 27005 | 6618 | 81 |
2071443 | 2071443 | 2022-01-01 | Beltrami | Minnesota | 27007 | 8803 | 111 |
2071444 | 2071444 | 2022-01-01 | Benton | Minnesota | 27009 | 10048 | 140 |
2071445 | 2071445 | 2022-01-01 | Big Stone | Minnesota | 27011 | 1014 | 7 |
2071446 | 2071446 | 2022-01-01 | Blue Earth | Minnesota | 27013 | 12732 | 82 |
2071447 | 2071447 | 2022-01-01 | Brown | Minnesota | 27015 | 5031 | 66 |
2071448 | 2071448 | 2022-01-01 | Carlton | Minnesota | 27017 | 6115 | 80 |
2071449 | 2071449 | 2022-01-01 | Carver | Minnesota | 27019 | 18778 | 90 |
2071450 | 2071450 | 2022-01-01 | Cass | Minnesota | 27021 | 5391 | 64 |
2071451 | 2071451 | 2022-01-01 | Chippewa | Minnesota | 27023 | 2352 | 43 |
2071452 | 2071452 | 2022-01-01 | Chisago | Minnesota | 27025 | 11021 | 100 |
2071453 | 2071453 | 2022-01-01 | Clay | Minnesota | 27027 | 13171 | 113 |
2071454 | 2071454 | 2022-01-01 | Clearwater | Minnesota | 27029 | 1691 | 25 |
2071455 | 2071455 | 2022-01-01 | Cook | Minnesota | 27031 | 356 | 1 |
2071456 | 2071456 | 2022-01-01 | Cottonwood | Minnesota | 27033 | 2487 | 34 |
2071457 | 2071457 | 2022-01-01 | Crow Wing | Minnesota | 27035 | 12214 | 139 |
2071458 | 2071458 | 2022-01-01 | Dakota | Minnesota | 27037 | 76390 | 655 |
2071459 | 2071459 | 2022-01-01 | Dodge | Minnesota | 27039 | 3979 | 13 |
2071460 | 2071460 | 2022-01-01 | Douglas | Minnesota | 27041 | 8525 | 103 |
2071461 | 2071461 | 2022-01-01 | Faribault | Minnesota | 27043 | 2841 | 40 |
2071462 | 2071462 | 2022-01-01 | Fillmore | Minnesota | 27045 | 3454 | 17 |
2071463 | 2071463 | 2022-01-01 | Freeborn | Minnesota | 27047 | 6349 | 51 |
2071464 | 2071464 | 2022-01-01 | Goodhue | Minnesota | 27049 | 9243 | 109 |
2071465 | 2071465 | 2022-01-01 | Grant | Minnesota | 27051 | 1120 | 12 |
2071466 | 2071466 | 2022-01-01 | Hennepin | Minnesota | 27053 | 203703 | 2179 |
2071467 | 2071467 | 2022-01-01 | Houston | Minnesota | 27055 | 3160 | 18 |
2071468 | 2071468 | 2022-01-01 | Hubbard | Minnesota | 27057 | 3805 | 51 |
2071469 | 2071469 | 2022-01-01 | Isanti | Minnesota | 27059 | 7849 | 97 |
2071470 | 2071470 | 2022-01-01 | Itasca | Minnesota | 27061 | 8500 | 114 |
2071471 | 2071471 | 2022-01-01 | Jackson | Minnesota | 27063 | 1726 | 16 |
2071472 | 2071472 | 2022-01-01 | Kanabec | Minnesota | 27065 | 2825 | 45 |
2071473 | 2071473 | 2022-01-01 | Kandiyohi | Minnesota | 27067 | 10530 | 118 |
2071474 | 2071474 | 2022-01-01 | Kittson | Minnesota | 27069 | 856 | 24 |
2071475 | 2071475 | 2022-01-01 | Koochiching | Minnesota | 27071 | 1996 | 29 |
2071476 | 2071476 | 2022-01-01 | Lac qui Parle | Minnesota | 27073 | 1341 | 26 |
2071477 | 2071477 | 2022-01-01 | Lake | Minnesota | 27075 | 1475 | 26 |
2071478 | 2071478 | 2022-01-01 | Lake of the Woods | Minnesota | 27077 | 566 | 5 |
2071479 | 2071479 | 2022-01-01 | Le Sueur | Minnesota | 27079 | 5074 | 41 |
2071480 | 2071480 | 2022-01-01 | Lincoln | Minnesota | 27081 | 947 | 5 |
2071481 | 2071481 | 2022-01-01 | Lyon | Minnesota | 27083 | 5621 | 66 |
2071482 | 2071482 | 2022-01-01 | Mahnomen | Minnesota | 27087 | 1160 | 16 |
2071483 | 2071483 | 2022-01-01 | Marshall | Minnesota | 27089 | 1655 | 23 |
2071484 | 2071484 | 2022-01-01 | Martin | Minnesota | 27091 | 4235 | 52 |
2071485 | 2071485 | 2022-01-01 | McLeod | Minnesota | 27085 | 7909 | 92 |
2071486 | 2071486 | 2022-01-01 | Meeker | Minnesota | 27093 | 4742 | 67 |
2071487 | 2071487 | 2022-01-01 | Mille Lacs | Minnesota | 27095 | 5826 | 93 |
2071488 | 2071488 | 2022-01-01 | Morrison | Minnesota | 27097 | 7172 | 87 |
2071489 | 2071489 | 2022-01-01 | Mower | Minnesota | 27099 | 7941 | 55 |
2071490 | 2071490 | 2022-01-01 | Murray | Minnesota | 27101 | 1616 | 14 |
2071491 | 2071491 | 2022-01-01 | Nicollet | Minnesota | 27103 | 5724 | 62 |
2071492 | 2071492 | 2022-01-01 | Nobles | Minnesota | 27105 | 5469 | 56 |
2071493 | 2071493 | 2022-01-01 | Norman | Minnesota | 27107 | 1094 | 10 |
2071494 | 2071494 | 2022-01-01 | Olmsted | Minnesota | 27109 | 25067 | 139 |
2071495 | 2071495 | 2022-01-01 | Otter Tail | Minnesota | 27111 | 10556 | 144 |
2071496 | 2071496 | 2022-01-01 | Pennington | Minnesota | 27113 | 2669 | 32 |
2071497 | 2071497 | 2022-01-01 | Pine | Minnesota | 27115 | 5677 | 48 |
2071498 | 2071498 | 2022-01-01 | Pipestone | Minnesota | 27117 | 1622 | 30 |
2071499 | 2071499 | 2022-01-01 | Polk | Minnesota | 27119 | 6357 | 91 |
2071500 | 2071500 | 2022-01-01 | Pope | Minnesota | 27121 | 2279 | 14 |
2071501 | 2071501 | 2022-01-01 | Ramsey | Minnesota | 27123 | 84152 | 1129 |
2071502 | 2071502 | 2022-01-01 | Red Lake | Minnesota | 27125 | 736 | 11 |
2071503 | 2071503 | 2022-01-01 | Redwood | Minnesota | 27127 | 3034 | 49 |
2071504 | 2071504 | 2022-01-01 | Renville | Minnesota | 27129 | 2877 | 52 |
2071505 | 2071505 | 2022-01-01 | Rice | Minnesota | 27131 | 12539 | 148 |
2071506 | 2071506 | 2022-01-01 | Rock | Minnesota | 27133 | 1860 | 32 |
2071507 | 2071507 | 2022-01-01 | Roseau | Minnesota | 27135 | 3409 | 37 |
2071508 | 2071508 | 2022-01-01 | Scott | Minnesota | 27139 | 29161 | 212 |
2071509 | 2071509 | 2022-01-01 | Sherburne | Minnesota | 27141 | 20962 | 153 |
2071510 | 2071510 | 2022-01-01 | Sibley | Minnesota | 27143 | 2801 | 20 |
2071511 | 2071511 | 2022-01-01 | St. Louis | Minnesota | 27137 | 32941 | 449 |
2071512 | 2071512 | 2022-01-01 | Stearns | Minnesota | 27145 | 37185 | 311 |
2071513 | 2071513 | 2022-01-01 | Steele | Minnesota | 27147 | 7541 | 41 |
2071514 | 2071514 | 2022-01-01 | Stevens | Minnesota | 27149 | 1885 | 11 |
2071515 | 2071515 | 2022-01-01 | Swift | Minnesota | 27151 | 1829 | 29 |
2071516 | 2071516 | 2022-01-01 | Todd | Minnesota | 27153 | 5291 | 51 |
2071517 | 2071517 | 2022-01-01 | Traverse | Minnesota | 27155 | 632 | 8 |
2071518 | 2071518 | 2022-01-01 | Unknown | Minnesota | 764 | 140 | |
2071519 | 2071519 | 2022-01-01 | Wabasha | Minnesota | 27157 | 4118 | 12 |
2071520 | 2071520 | 2022-01-01 | Wadena | Minnesota | 27159 | 3242 | 44 |
2071521 | 2071521 | 2022-01-01 | Waseca | Minnesota | 27161 | 4280 | 35 |
2071522 | 2071522 | 2022-01-01 | Washington | Minnesota | 27163 | 45954 | 406 |
2071523 | 2071523 | 2022-01-01 | Watonwan | Minnesota | 27165 | 2171 | 21 |
2071524 | 2071524 | 2022-01-01 | Wilkin | Minnesota | 27167 | 1290 | 17 |
2071525 | 2071525 | 2022-01-01 | Winona | Minnesota | 27169 | 8467 | 63 |
2071526 | 2071526 | 2022-01-01 | Wright | Minnesota | 27171 | 28702 | 259 |
2071527 | 2071527 | 2022-01-01 | Yellow Medicine | Minnesota | 27173 | 2020 | 25 |
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);