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 679
- 27019 677
- 27003 675
- 27109 674
- 27037 673
- 27053 673
- 27145 673
- 27171 672
- 27129 671
- 27161 670
- 27163 670
- 27009 669
- 27013 669
- 27091 668
- 27103 668
- 27131 667
- 27099 666
- 27139 666
- 27025 665
- 27027 665
- 27045 665
- 27039 664
- 27063 664
- 27137 664
- 27147 664
- 27157 664
- 27079 663
- 27011 662
- 27021 662
- 27073 662
- …
county >30
- Ramsey 679
- Carver 677
- Anoka 675
- Olmsted 674
- Dakota 673
- Hennepin 673
- Stearns 673
- Wright 672
- Renville 671
- Waseca 670
- Washington 670
- Benton 669
- Blue Earth 669
- Martin 668
- Nicollet 668
- Rice 667
- Mower 666
- Scott 666
- Chisago 665
- Clay 665
- Fillmore 665
- Dodge 664
- Jackson 664
- St. Louis 664
- Steele 664
- Wabasha 664
- Le Sueur 663
- Big Stone 662
- Cass 662
- Lac qui Parle 662
- …
state 1
- Minnesota · 57,323 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110457 | 2110457 | 2022-01-13 | Aitkin | Minnesota | 27001 | 2505 | 55 |
2110458 | 2110458 | 2022-01-13 | Anoka | Minnesota | 27003 | 79046 | 708 |
2110459 | 2110459 | 2022-01-13 | Becker | Minnesota | 27005 | 6915 | 82 |
2110460 | 2110460 | 2022-01-13 | Beltrami | Minnesota | 27007 | 9305 | 112 |
2110461 | 2110461 | 2022-01-13 | Benton | Minnesota | 27009 | 10752 | 146 |
2110462 | 2110462 | 2022-01-13 | Big Stone | Minnesota | 27011 | 1094 | 7 |
2110463 | 2110463 | 2022-01-13 | Blue Earth | Minnesota | 27013 | 13620 | 84 |
2110464 | 2110464 | 2022-01-13 | Brown | Minnesota | 27015 | 5290 | 69 |
2110465 | 2110465 | 2022-01-13 | Carlton | Minnesota | 27017 | 6406 | 82 |
2110466 | 2110466 | 2022-01-13 | Carver | Minnesota | 27019 | 20673 | 93 |
2110467 | 2110467 | 2022-01-13 | Cass | Minnesota | 27021 | 5589 | 66 |
2110468 | 2110468 | 2022-01-13 | Chippewa | Minnesota | 27023 | 2441 | 43 |
2110469 | 2110469 | 2022-01-13 | Chisago | Minnesota | 27025 | 11689 | 106 |
2110470 | 2110470 | 2022-01-13 | Clay | Minnesota | 27027 | 14278 | 114 |
2110471 | 2110471 | 2022-01-13 | Clearwater | Minnesota | 27029 | 1746 | 27 |
2110472 | 2110472 | 2022-01-13 | Cook | Minnesota | 27031 | 414 | 1 |
2110473 | 2110473 | 2022-01-13 | Cottonwood | Minnesota | 27033 | 2622 | 36 |
2110474 | 2110474 | 2022-01-13 | Crow Wing | Minnesota | 27035 | 12790 | 146 |
2110475 | 2110475 | 2022-01-13 | Dakota | Minnesota | 27037 | 85520 | 685 |
2110476 | 2110476 | 2022-01-13 | Dodge | Minnesota | 27039 | 4301 | 14 |
2110477 | 2110477 | 2022-01-13 | Douglas | Minnesota | 27041 | 8942 | 109 |
2110478 | 2110478 | 2022-01-13 | Faribault | Minnesota | 27043 | 3005 | 44 |
2110479 | 2110479 | 2022-01-13 | Fillmore | Minnesota | 27045 | 3694 | 18 |
2110480 | 2110480 | 2022-01-13 | Freeborn | Minnesota | 27047 | 6877 | 56 |
2110481 | 2110481 | 2022-01-13 | Goodhue | Minnesota | 27049 | 10004 | 112 |
2110482 | 2110482 | 2022-01-13 | Grant | Minnesota | 27051 | 1176 | 12 |
2110483 | 2110483 | 2022-01-13 | Hennepin | Minnesota | 27053 | 233623 | 2258 |
2110484 | 2110484 | 2022-01-13 | Houston | Minnesota | 27055 | 3446 | 18 |
2110485 | 2110485 | 2022-01-13 | Hubbard | Minnesota | 27057 | 3972 | 52 |
2110486 | 2110486 | 2022-01-13 | Isanti | Minnesota | 27059 | 8328 | 101 |
2110487 | 2110487 | 2022-01-13 | Itasca | Minnesota | 27061 | 8956 | 122 |
2110488 | 2110488 | 2022-01-13 | Jackson | Minnesota | 27063 | 1817 | 16 |
2110489 | 2110489 | 2022-01-13 | Kanabec | Minnesota | 27065 | 2936 | 48 |
2110490 | 2110490 | 2022-01-13 | Kandiyohi | Minnesota | 27067 | 10990 | 123 |
2110491 | 2110491 | 2022-01-13 | Kittson | Minnesota | 27069 | 892 | 25 |
2110492 | 2110492 | 2022-01-13 | Koochiching | Minnesota | 27071 | 2075 | 32 |
2110493 | 2110493 | 2022-01-13 | Lac qui Parle | Minnesota | 27073 | 1404 | 26 |
2110494 | 2110494 | 2022-01-13 | Lake | Minnesota | 27075 | 1555 | 26 |
2110495 | 2110495 | 2022-01-13 | Lake of the Woods | Minnesota | 27077 | 597 | 5 |
2110496 | 2110496 | 2022-01-13 | Le Sueur | Minnesota | 27079 | 5316 | 44 |
2110497 | 2110497 | 2022-01-13 | Lincoln | Minnesota | 27081 | 1002 | 5 |
2110498 | 2110498 | 2022-01-13 | Lyon | Minnesota | 27083 | 5971 | 68 |
2110499 | 2110499 | 2022-01-13 | Mahnomen | Minnesota | 27087 | 1215 | 17 |
2110500 | 2110500 | 2022-01-13 | Marshall | Minnesota | 27089 | 1714 | 23 |
2110501 | 2110501 | 2022-01-13 | Martin | Minnesota | 27091 | 4451 | 53 |
2110502 | 2110502 | 2022-01-13 | McLeod | Minnesota | 27085 | 8331 | 97 |
2110503 | 2110503 | 2022-01-13 | Meeker | Minnesota | 27093 | 4925 | 70 |
2110504 | 2110504 | 2022-01-13 | Mille Lacs | Minnesota | 27095 | 6077 | 99 |
2110505 | 2110505 | 2022-01-13 | Morrison | Minnesota | 27097 | 7419 | 92 |
2110506 | 2110506 | 2022-01-13 | Mower | Minnesota | 27099 | 8984 | 58 |
2110507 | 2110507 | 2022-01-13 | Murray | Minnesota | 27101 | 1713 | 14 |
2110508 | 2110508 | 2022-01-13 | Nicollet | Minnesota | 27103 | 6102 | 63 |
2110509 | 2110509 | 2022-01-13 | Nobles | Minnesota | 27105 | 5782 | 56 |
2110510 | 2110510 | 2022-01-13 | Norman | Minnesota | 27107 | 1134 | 11 |
2110511 | 2110511 | 2022-01-13 | Olmsted | Minnesota | 27109 | 28820 | 146 |
2110512 | 2110512 | 2022-01-13 | Otter Tail | Minnesota | 27111 | 10902 | 148 |
2110513 | 2110513 | 2022-01-13 | Pennington | Minnesota | 27113 | 2799 | 34 |
2110514 | 2110514 | 2022-01-13 | Pine | Minnesota | 27115 | 5893 | 56 |
2110515 | 2110515 | 2022-01-13 | Pipestone | Minnesota | 27117 | 1705 | 31 |
2110516 | 2110516 | 2022-01-13 | Polk | Minnesota | 27119 | 6663 | 92 |
2110517 | 2110517 | 2022-01-13 | Pope | Minnesota | 27121 | 2375 | 14 |
2110518 | 2110518 | 2022-01-13 | Ramsey | Minnesota | 27123 | 96274 | 1172 |
2110519 | 2110519 | 2022-01-13 | Red Lake | Minnesota | 27125 | 773 | 11 |
2110520 | 2110520 | 2022-01-13 | Redwood | Minnesota | 27127 | 3176 | 50 |
2110521 | 2110521 | 2022-01-13 | Renville | Minnesota | 27129 | 3000 | 52 |
2110522 | 2110522 | 2022-01-13 | Rice | Minnesota | 27131 | 13616 | 152 |
2110523 | 2110523 | 2022-01-13 | Rock | Minnesota | 27133 | 1969 | 32 |
2110524 | 2110524 | 2022-01-13 | Roseau | Minnesota | 27135 | 3572 | 37 |
2110525 | 2110525 | 2022-01-13 | Scott | Minnesota | 27139 | 32218 | 221 |
2110526 | 2110526 | 2022-01-13 | Sherburne | Minnesota | 27141 | 22366 | 160 |
2110527 | 2110527 | 2022-01-13 | Sibley | Minnesota | 27143 | 2900 | 23 |
2110528 | 2110528 | 2022-01-13 | St. Louis | Minnesota | 27137 | 35203 | 468 |
2110529 | 2110529 | 2022-01-13 | Stearns | Minnesota | 27145 | 40179 | 328 |
2110530 | 2110530 | 2022-01-13 | Steele | Minnesota | 27147 | 8046 | 46 |
2110531 | 2110531 | 2022-01-13 | Stevens | Minnesota | 27149 | 2047 | 11 |
2110532 | 2110532 | 2022-01-13 | Swift | Minnesota | 27151 | 1856 | 30 |
2110533 | 2110533 | 2022-01-13 | Todd | Minnesota | 27153 | 5566 | 54 |
2110534 | 2110534 | 2022-01-13 | Traverse | Minnesota | 27155 | 655 | 8 |
2110535 | 2110535 | 2022-01-13 | Unknown | Minnesota | 3366 | 140 | |
2110536 | 2110536 | 2022-01-13 | Wabasha | Minnesota | 27157 | 4378 | 13 |
2110537 | 2110537 | 2022-01-13 | Wadena | Minnesota | 27159 | 3376 | 45 |
2110538 | 2110538 | 2022-01-13 | Waseca | Minnesota | 27161 | 4470 | 36 |
2110539 | 2110539 | 2022-01-13 | Washington | Minnesota | 27163 | 51479 | 421 |
2110540 | 2110540 | 2022-01-13 | Watonwan | Minnesota | 27165 | 2265 | 22 |
2110541 | 2110541 | 2022-01-13 | Wilkin | Minnesota | 27167 | 1337 | 19 |
2110542 | 2110542 | 2022-01-13 | Winona | Minnesota | 27169 | 9525 | 63 |
2110543 | 2110543 | 2022-01-13 | Wright | Minnesota | 27171 | 30531 | 270 |
2110544 | 2110544 | 2022-01-13 | Yellow Medicine | Minnesota | 27173 | 2116 | 25 |
2107206 | 2107206 | 2022-01-12 | Aitkin | Minnesota | 27001 | 2488 | 55 |
2107207 | 2107207 | 2022-01-12 | Anoka | Minnesota | 27003 | 78044 | 705 |
2107208 | 2107208 | 2022-01-12 | Becker | Minnesota | 27005 | 6884 | 81 |
2107209 | 2107209 | 2022-01-12 | Beltrami | Minnesota | 27007 | 9228 | 111 |
2107210 | 2107210 | 2022-01-12 | Benton | Minnesota | 27009 | 10668 | 146 |
2107211 | 2107211 | 2022-01-12 | Big Stone | Minnesota | 27011 | 1089 | 7 |
2107212 | 2107212 | 2022-01-12 | Blue Earth | Minnesota | 27013 | 13468 | 84 |
2107213 | 2107213 | 2022-01-12 | Brown | Minnesota | 27015 | 5246 | 69 |
2107214 | 2107214 | 2022-01-12 | Carlton | Minnesota | 27017 | 6361 | 82 |
2107215 | 2107215 | 2022-01-12 | Carver | Minnesota | 27019 | 20365 | 92 |
2107216 | 2107216 | 2022-01-12 | Cass | Minnesota | 27021 | 5563 | 66 |
2107217 | 2107217 | 2022-01-12 | Chippewa | Minnesota | 27023 | 2432 | 43 |
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);