ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67,883 rows where state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 27123 405
- 27019 403
- 27003 401
- 27109 400
- 27037 399
- 27053 399
- 27145 399
- 27171 398
- 27129 397
- 27161 396
- 27163 396
- 27009 395
- 27013 395
- 27091 394
- 27103 394
- 27131 393
- 27099 392
- 27139 392
- 27025 391
- 27027 391
- 27045 391
- 27039 390
- 27063 390
- 27137 390
- 27147 390
- 27157 390
- 27079 389
- 27011 388
- 27021 388
- 27073 388
- …
date (date) >30 ✖
- 2020-07-25 88
- 2020-07-26 88
- 2020-07-27 88
- 2020-07-28 88
- 2020-07-29 88
- 2020-07-30 88
- 2020-07-31 88
- 2020-08-01 88
- 2020-08-02 88
- 2020-08-03 88
- 2020-08-04 88
- 2020-08-05 88
- 2020-08-06 88
- 2020-08-07 88
- 2020-08-08 88
- 2020-08-09 88
- 2020-08-10 88
- 2020-08-11 88
- 2020-08-12 88
- 2020-08-13 88
- 2020-08-14 88
- 2020-08-15 88
- 2020-08-16 88
- 2020-08-17 88
- 2020-08-18 88
- 2020-08-19 88
- 2020-08-20 88
- 2020-08-21 88
- 2020-08-22 88
- 2020-08-23 88
- …
county >30
- Ramsey 405
- Carver 403
- Anoka 401
- Olmsted 400
- Dakota 399
- Hennepin 399
- Stearns 399
- Wright 398
- Renville 397
- Waseca 396
- Washington 396
- Benton 395
- Blue Earth 395
- Martin 394
- Nicollet 394
- Rice 393
- Mower 392
- Scott 392
- Chisago 391
- Clay 391
- Fillmore 391
- Dodge 390
- Jackson 390
- St. Louis 390
- Steele 390
- Wabasha 390
- Le Sueur 389
- Big Stone 388
- Cass 388
- Lac qui Parle 388
- …
state 1
- Minnesota · 33,211 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1220421 | 1220421 | 2021-04-14 | Aitkin | Minnesota | 27001 | 1275 | 36 |
1220422 | 1220422 | 2021-04-14 | Anoka | Minnesota | 27003 | 37816 | 415 |
1220423 | 1220423 | 2021-04-14 | Becker | Minnesota | 27005 | 3493 | 48 |
1220424 | 1220424 | 2021-04-14 | Beltrami | Minnesota | 27007 | 3692 | 57 |
1220425 | 1220425 | 2021-04-14 | Benton | Minnesota | 27009 | 5245 | 97 |
1220426 | 1220426 | 2021-04-14 | Big Stone | Minnesota | 27011 | 556 | 4 |
1220427 | 1220427 | 2021-04-14 | Blue Earth | Minnesota | 27013 | 6873 | 40 |
1220428 | 1220428 | 2021-04-14 | Brown | Minnesota | 27015 | 2922 | 39 |
1220429 | 1220429 | 2021-04-14 | Carlton | Minnesota | 27017 | 3253 | 52 |
1220430 | 1220430 | 2021-04-14 | Carver | Minnesota | 27019 | 9649 | 44 |
1220431 | 1220431 | 2021-04-14 | Cass | Minnesota | 27021 | 2459 | 26 |
1220432 | 1220432 | 2021-04-14 | Chippewa | Minnesota | 27023 | 1442 | 36 |
1220433 | 1220433 | 2021-04-14 | Chisago | Minnesota | 27025 | 5415 | 49 |
1220434 | 1220434 | 2021-04-14 | Clay | Minnesota | 27027 | 7738 | 89 |
1220435 | 1220435 | 2021-04-14 | Clearwater | Minnesota | 27029 | 761 | 14 |
1220436 | 1220436 | 2021-04-14 | Cook | Minnesota | 27031 | 144 | 0 |
1220437 | 1220437 | 2021-04-14 | Cottonwood | Minnesota | 27033 | 1541 | 20 |
1220438 | 1220438 | 2021-04-14 | Crow Wing | Minnesota | 27035 | 6035 | 86 |
1220439 | 1220439 | 2021-04-14 | Dakota | Minnesota | 27037 | 41764 | 418 |
1220440 | 1220440 | 2021-04-14 | Dodge | Minnesota | 27039 | 1691 | 4 |
1220441 | 1220441 | 2021-04-14 | Douglas | Minnesota | 27041 | 4372 | 70 |
1220442 | 1220442 | 2021-04-14 | Faribault | Minnesota | 27043 | 1424 | 19 |
1220443 | 1220443 | 2021-04-14 | Fillmore | Minnesota | 27045 | 1510 | 9 |
1220444 | 1220444 | 2021-04-14 | Freeborn | Minnesota | 27047 | 3236 | 29 |
1220445 | 1220445 | 2021-04-14 | Goodhue | Minnesota | 27049 | 4353 | 71 |
1220446 | 1220446 | 2021-04-14 | Grant | Minnesota | 27051 | 542 | 8 |
1220447 | 1220447 | 2021-04-14 | Hennepin | Minnesota | 27053 | 113983 | 1672 |
1220448 | 1220448 | 2021-04-14 | Houston | Minnesota | 27055 | 1620 | 14 |
1220449 | 1220449 | 2021-04-14 | Hubbard | Minnesota | 27057 | 1692 | 41 |
1220450 | 1220450 | 2021-04-14 | Isanti | Minnesota | 27059 | 3675 | 59 |
1220451 | 1220451 | 2021-04-14 | Itasca | Minnesota | 27061 | 3625 | 52 |
1220452 | 1220452 | 2021-04-14 | Jackson | Minnesota | 27063 | 1154 | 10 |
1220453 | 1220453 | 2021-04-14 | Kanabec | Minnesota | 27065 | 1268 | 21 |
1220454 | 1220454 | 2021-04-14 | Kandiyohi | Minnesota | 27067 | 6226 | 79 |
1220455 | 1220455 | 2021-04-14 | Kittson | Minnesota | 27069 | 461 | 22 |
1220456 | 1220456 | 2021-04-14 | Koochiching | Minnesota | 27071 | 764 | 12 |
1220457 | 1220457 | 2021-04-14 | Lac qui Parle | Minnesota | 27073 | 734 | 22 |
1220458 | 1220458 | 2021-04-14 | Lake | Minnesota | 27075 | 779 | 19 |
1220459 | 1220459 | 2021-04-14 | Lake of the Woods | Minnesota | 27077 | 298 | 3 |
1220460 | 1220460 | 2021-04-14 | Le Sueur | Minnesota | 27079 | 2676 | 22 |
1220461 | 1220461 | 2021-04-14 | Lincoln | Minnesota | 27081 | 556 | 2 |
1220462 | 1220462 | 2021-04-14 | Lyon | Minnesota | 27083 | 3450 | 48 |
1220463 | 1220463 | 2021-04-14 | Mahnomen | Minnesota | 27087 | 489 | 8 |
1220464 | 1220464 | 2021-04-14 | Marshall | Minnesota | 27089 | 847 | 17 |
1220465 | 1220465 | 2021-04-14 | Martin | Minnesota | 27091 | 2107 | 29 |
1220466 | 1220466 | 2021-04-14 | McLeod | Minnesota | 27085 | 3857 | 54 |
1220467 | 1220467 | 2021-04-14 | Meeker | Minnesota | 27093 | 2303 | 37 |
1220468 | 1220468 | 2021-04-14 | Mille Lacs | Minnesota | 27095 | 2748 | 49 |
1220469 | 1220469 | 2021-04-14 | Morrison | Minnesota | 27097 | 3891 | 59 |
1220470 | 1220470 | 2021-04-14 | Mower | Minnesota | 27099 | 4486 | 32 |
1220471 | 1220471 | 2021-04-14 | Murray | Minnesota | 27101 | 1018 | 9 |
1220472 | 1220472 | 2021-04-14 | Nicollet | Minnesota | 27103 | 3032 | 42 |
1220473 | 1220473 | 2021-04-14 | Nobles | Minnesota | 27105 | 3978 | 48 |
1220474 | 1220474 | 2021-04-14 | Norman | Minnesota | 27107 | 516 | 9 |
1220475 | 1220475 | 2021-04-14 | Olmsted | Minnesota | 27109 | 12647 | 96 |
1220476 | 1220476 | 2021-04-14 | Otter Tail | Minnesota | 27111 | 5374 | 73 |
1220477 | 1220477 | 2021-04-14 | Pennington | Minnesota | 27113 | 1490 | 19 |
1220478 | 1220478 | 2021-04-14 | Pine | Minnesota | 27115 | 3075 | 21 |
1220479 | 1220479 | 2021-04-14 | Pipestone | Minnesota | 27117 | 1088 | 25 |
1220480 | 1220480 | 2021-04-14 | Polk | Minnesota | 27119 | 3598 | 66 |
1220481 | 1220481 | 2021-04-14 | Pope | Minnesota | 27121 | 994 | 6 |
1220482 | 1220482 | 2021-04-14 | Ramsey | Minnesota | 27123 | 47188 | 850 |
1220483 | 1220483 | 2021-04-14 | Red Lake | Minnesota | 27125 | 382 | 7 |
1220484 | 1220484 | 2021-04-14 | Redwood | Minnesota | 27127 | 1648 | 35 |
1220485 | 1220485 | 2021-04-14 | Renville | Minnesota | 27129 | 1691 | 43 |
1220486 | 1220486 | 2021-04-14 | Rice | Minnesota | 27131 | 7506 | 101 |
1220487 | 1220487 | 2021-04-14 | Rock | Minnesota | 27133 | 1218 | 18 |
1220488 | 1220488 | 2021-04-14 | Roseau | Minnesota | 27135 | 1948 | 18 |
1220489 | 1220489 | 2021-04-14 | Scott | Minnesota | 27139 | 15682 | 117 |
1220490 | 1220490 | 2021-04-14 | Sherburne | Minnesota | 27141 | 10373 | 80 |
1220491 | 1220491 | 2021-04-14 | Sibley | Minnesota | 27143 | 1340 | 10 |
1220492 | 1220492 | 2021-04-14 | St. Louis | Minnesota | 27137 | 16572 | 296 |
1220493 | 1220493 | 2021-04-14 | Stearns | Minnesota | 27145 | 20738 | 218 |
1220494 | 1220494 | 2021-04-14 | Steele | Minnesota | 27147 | 3546 | 14 |
1220495 | 1220495 | 2021-04-14 | Stevens | Minnesota | 27149 | 799 | 10 |
1220496 | 1220496 | 2021-04-14 | Swift | Minnesota | 27151 | 980 | 18 |
1220497 | 1220497 | 2021-04-14 | Todd | Minnesota | 27153 | 2664 | 30 |
1220498 | 1220498 | 2021-04-14 | Traverse | Minnesota | 27155 | 359 | 5 |
1220499 | 1220499 | 2021-04-14 | Unknown | Minnesota | 560 | 78 | |
1220500 | 1220500 | 2021-04-14 | Wabasha | Minnesota | 27157 | 1990 | 3 |
1220501 | 1220501 | 2021-04-14 | Wadena | Minnesota | 27159 | 1420 | 21 |
1220502 | 1220502 | 2021-04-14 | Waseca | Minnesota | 27161 | 2287 | 20 |
1220503 | 1220503 | 2021-04-14 | Washington | Minnesota | 27163 | 24550 | 273 |
1220504 | 1220504 | 2021-04-14 | Watonwan | Minnesota | 27165 | 1250 | 9 |
1220505 | 1220505 | 2021-04-14 | Wilkin | Minnesota | 27167 | 763 | 12 |
1220506 | 1220506 | 2021-04-14 | Winona | Minnesota | 27169 | 4366 | 49 |
1220507 | 1220507 | 2021-04-14 | Wright | Minnesota | 27171 | 14561 | 125 |
1220508 | 1220508 | 2021-04-14 | Yellow Medicine | Minnesota | 27173 | 1098 | 19 |
1217173 | 1217173 | 2021-04-13 | Aitkin | Minnesota | 27001 | 1275 | 36 |
1217174 | 1217174 | 2021-04-13 | Anoka | Minnesota | 27003 | 37699 | 413 |
1217175 | 1217175 | 2021-04-13 | Becker | Minnesota | 27005 | 3479 | 48 |
1217176 | 1217176 | 2021-04-13 | Beltrami | Minnesota | 27007 | 3675 | 57 |
1217177 | 1217177 | 2021-04-13 | Benton | Minnesota | 27009 | 5230 | 96 |
1217178 | 1217178 | 2021-04-13 | Big Stone | Minnesota | 27011 | 554 | 4 |
1217179 | 1217179 | 2021-04-13 | Blue Earth | Minnesota | 27013 | 6848 | 40 |
1217180 | 1217180 | 2021-04-13 | Brown | Minnesota | 27015 | 2917 | 39 |
1217181 | 1217181 | 2021-04-13 | Carlton | Minnesota | 27017 | 3246 | 52 |
1217182 | 1217182 | 2021-04-13 | Carver | Minnesota | 27019 | 9605 | 43 |
1217183 | 1217183 | 2021-04-13 | Cass | Minnesota | 27021 | 2450 | 26 |
1217184 | 1217184 | 2021-04-13 | Chippewa | Minnesota | 27023 | 1437 | 36 |
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);