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 316
- 27019 314
- 27003 312
- 27109 311
- 27037 310
- 27053 310
- 27145 310
- 27171 309
- 27129 308
- 27161 307
- 27163 307
- 27009 306
- 27013 306
- 27091 305
- 27103 305
- 27131 304
- 27099 303
- 27139 303
- 27025 302
- 27027 302
- 27045 302
- 27039 301
- 27063 301
- 27137 301
- 27147 301
- 27157 301
- 27079 300
- 27011 299
- 27021 299
- 27073 299
- …
county >30
- Ramsey 316
- Carver 314
- Anoka 312
- Olmsted 311
- Dakota 310
- Hennepin 310
- Stearns 310
- Wright 309
- Renville 308
- Waseca 307
- Washington 307
- Benton 306
- Blue Earth 306
- Martin 305
- Nicollet 305
- Rice 304
- Mower 303
- Scott 303
- Chisago 302
- Clay 302
- Fillmore 302
- Dodge 301
- Jackson 301
- St. Louis 301
- Steele 301
- Wabasha 301
- Le Sueur 300
- Big Stone 299
- Cass 299
- Lac qui Parle 299
- …
state 1
- Minnesota · 25,379 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
931500 | 931500 | 2021-01-15 | Aitkin | Minnesota | 27001 | 1067 | 33 |
931501 | 931501 | 2021-01-15 | Anoka | Minnesota | 27003 | 30733 | 358 |
931502 | 931502 | 2021-01-15 | Becker | Minnesota | 27005 | 2806 | 38 |
931503 | 931503 | 2021-01-15 | Beltrami | Minnesota | 27007 | 3074 | 46 |
931504 | 931504 | 2021-01-15 | Benton | Minnesota | 27009 | 4160 | 85 |
931505 | 931505 | 2021-01-15 | Big Stone | Minnesota | 27011 | 452 | 3 |
931506 | 931506 | 2021-01-15 | Blue Earth | Minnesota | 27013 | 5363 | 33 |
931507 | 931507 | 2021-01-15 | Brown | Minnesota | 27015 | 2126 | 34 |
931508 | 931508 | 2021-01-15 | Carlton | Minnesota | 27017 | 2780 | 42 |
931509 | 931509 | 2021-01-15 | Carver | Minnesota | 27019 | 6893 | 36 |
931510 | 931510 | 2021-01-15 | Cass | Minnesota | 27021 | 2047 | 23 |
931511 | 931511 | 2021-01-15 | Chippewa | Minnesota | 27023 | 1307 | 32 |
931512 | 931512 | 2021-01-15 | Chisago | Minnesota | 27025 | 4479 | 32 |
931513 | 931513 | 2021-01-15 | Clay | Minnesota | 27027 | 6466 | 78 |
931514 | 931514 | 2021-01-15 | Clearwater | Minnesota | 27029 | 683 | 14 |
931515 | 931515 | 2021-01-15 | Cook | Minnesota | 27031 | 113 | 0 |
931516 | 931516 | 2021-01-15 | Cottonwood | Minnesota | 27033 | 1256 | 18 |
931517 | 931517 | 2021-01-15 | Crow Wing | Minnesota | 27035 | 4781 | 73 |
931518 | 931518 | 2021-01-15 | Dakota | Minnesota | 27037 | 32680 | 325 |
931519 | 931519 | 2021-01-15 | Dodge | Minnesota | 27039 | 1324 | 4 |
931520 | 931520 | 2021-01-15 | Douglas | Minnesota | 27041 | 3715 | 66 |
931521 | 931521 | 2021-01-15 | Faribault | Minnesota | 27043 | 1038 | 14 |
931522 | 931522 | 2021-01-15 | Fillmore | Minnesota | 27045 | 1213 | 5 |
931523 | 931523 | 2021-01-15 | Freeborn | Minnesota | 27047 | 2387 | 20 |
931524 | 931524 | 2021-01-15 | Goodhue | Minnesota | 27049 | 3428 | 57 |
931525 | 931525 | 2021-01-15 | Grant | Minnesota | 27051 | 425 | 7 |
931526 | 931526 | 2021-01-15 | Hennepin | Minnesota | 27053 | 92172 | 1468 |
931527 | 931527 | 2021-01-15 | Houston | Minnesota | 27055 | 1336 | 13 |
931528 | 931528 | 2021-01-15 | Hubbard | Minnesota | 27057 | 1476 | 38 |
931529 | 931529 | 2021-01-15 | Isanti | Minnesota | 27059 | 2806 | 40 |
931530 | 931530 | 2021-01-15 | Itasca | Minnesota | 27061 | 2815 | 43 |
931531 | 931531 | 2021-01-15 | Jackson | Minnesota | 27063 | 850 | 10 |
931532 | 931532 | 2021-01-15 | Kanabec | Minnesota | 27065 | 968 | 18 |
931533 | 931533 | 2021-01-15 | Kandiyohi | Minnesota | 27067 | 5515 | 71 |
931534 | 931534 | 2021-01-15 | Kittson | Minnesota | 27069 | 368 | 19 |
931535 | 931535 | 2021-01-15 | Koochiching | Minnesota | 27071 | 584 | 10 |
931536 | 931536 | 2021-01-15 | Lac qui Parle | Minnesota | 27073 | 654 | 16 |
931537 | 931537 | 2021-01-15 | Lake | Minnesota | 27075 | 626 | 15 |
931538 | 931538 | 2021-01-15 | Lake of the Woods | Minnesota | 27077 | 177 | 1 |
931539 | 931539 | 2021-01-15 | Le Sueur | Minnesota | 27079 | 2076 | 15 |
931540 | 931540 | 2021-01-15 | Lincoln | Minnesota | 27081 | 481 | 1 |
931541 | 931541 | 2021-01-15 | Lyon | Minnesota | 27083 | 2990 | 35 |
931542 | 931542 | 2021-01-15 | Mahnomen | Minnesota | 27087 | 407 | 7 |
931543 | 931543 | 2021-01-15 | Marshall | Minnesota | 27089 | 701 | 15 |
931544 | 931544 | 2021-01-15 | Martin | Minnesota | 27091 | 1688 | 26 |
931545 | 931545 | 2021-01-15 | McLeod | Minnesota | 27085 | 3222 | 44 |
931546 | 931546 | 2021-01-15 | Meeker | Minnesota | 27093 | 1982 | 33 |
931547 | 931547 | 2021-01-15 | Mille Lacs | Minnesota | 27095 | 2121 | 45 |
931548 | 931548 | 2021-01-15 | Morrison | Minnesota | 27097 | 3093 | 43 |
931549 | 931549 | 2021-01-15 | Mower | Minnesota | 27099 | 3601 | 27 |
931550 | 931550 | 2021-01-15 | Murray | Minnesota | 27101 | 862 | 5 |
931551 | 931551 | 2021-01-15 | Nicollet | Minnesota | 27103 | 2226 | 36 |
931552 | 931552 | 2021-01-15 | Nobles | Minnesota | 27105 | 3663 | 46 |
931553 | 931553 | 2021-01-15 | Norman | Minnesota | 27107 | 421 | 8 |
931554 | 931554 | 2021-01-15 | Olmsted | Minnesota | 27109 | 10316 | 71 |
931555 | 931555 | 2021-01-15 | Otter Tail | Minnesota | 27111 | 4513 | 62 |
931556 | 931556 | 2021-01-15 | Pennington | Minnesota | 27113 | 967 | 15 |
931557 | 931557 | 2021-01-15 | Pine | Minnesota | 27115 | 2644 | 13 |
931558 | 931558 | 2021-01-15 | Pipestone | Minnesota | 27117 | 934 | 23 |
931559 | 931559 | 2021-01-15 | Polk | Minnesota | 27119 | 3270 | 56 |
931560 | 931560 | 2021-01-15 | Pope | Minnesota | 27121 | 735 | 5 |
931561 | 931561 | 2021-01-15 | Ramsey | Minnesota | 27123 | 39534 | 730 |
931562 | 931562 | 2021-01-15 | Red Lake | Minnesota | 27125 | 315 | 4 |
931563 | 931563 | 2021-01-15 | Redwood | Minnesota | 27127 | 1388 | 27 |
931564 | 931564 | 2021-01-15 | Renville | Minnesota | 27129 | 1363 | 39 |
931565 | 931565 | 2021-01-15 | Rice | Minnesota | 27131 | 5978 | 66 |
931566 | 931566 | 2021-01-15 | Rock | Minnesota | 27133 | 1094 | 12 |
931567 | 931567 | 2021-01-15 | Roseau | Minnesota | 27135 | 1652 | 16 |
931568 | 931568 | 2021-01-15 | Scott | Minnesota | 27139 | 11853 | 94 |
931569 | 931569 | 2021-01-15 | Sherburne | Minnesota | 27141 | 8136 | 64 |
931570 | 931570 | 2021-01-15 | Sibley | Minnesota | 27143 | 1076 | 7 |
931571 | 931571 | 2021-01-15 | St. Louis | Minnesota | 27137 | 13503 | 239 |
931572 | 931572 | 2021-01-15 | Stearns | Minnesota | 27145 | 17728 | 184 |
931573 | 931573 | 2021-01-15 | Steele | Minnesota | 27147 | 2701 | 9 |
931574 | 931574 | 2021-01-15 | Stevens | Minnesota | 27149 | 696 | 8 |
931575 | 931575 | 2021-01-15 | Swift | Minnesota | 27151 | 830 | 17 |
931576 | 931576 | 2021-01-15 | Todd | Minnesota | 27153 | 2305 | 29 |
931577 | 931577 | 2021-01-15 | Traverse | Minnesota | 27155 | 244 | 3 |
931578 | 931578 | 2021-01-15 | Unknown | Minnesota | 562 | 68 | |
931579 | 931579 | 2021-01-15 | Wabasha | Minnesota | 27157 | 1680 | 2 |
931580 | 931580 | 2021-01-15 | Wadena | Minnesota | 27159 | 1182 | 14 |
931581 | 931581 | 2021-01-15 | Waseca | Minnesota | 27161 | 1880 | 15 |
931582 | 931582 | 2021-01-15 | Washington | Minnesota | 27163 | 19904 | 223 |
931583 | 931583 | 2021-01-15 | Watonwan | Minnesota | 27165 | 1059 | 8 |
931584 | 931584 | 2021-01-15 | Wilkin | Minnesota | 27167 | 621 | 9 |
931585 | 931585 | 2021-01-15 | Winona | Minnesota | 27169 | 3845 | 46 |
931586 | 931586 | 2021-01-15 | Wright | Minnesota | 27171 | 11519 | 102 |
931587 | 931587 | 2021-01-15 | Yellow Medicine | Minnesota | 27173 | 926 | 14 |
928255 | 928255 | 2021-01-14 | Aitkin | Minnesota | 27001 | 1066 | 33 |
928256 | 928256 | 2021-01-14 | Anoka | Minnesota | 27003 | 30638 | 354 |
928257 | 928257 | 2021-01-14 | Becker | Minnesota | 27005 | 2794 | 38 |
928258 | 928258 | 2021-01-14 | Beltrami | Minnesota | 27007 | 3057 | 46 |
928259 | 928259 | 2021-01-14 | Benton | Minnesota | 27009 | 4148 | 85 |
928260 | 928260 | 2021-01-14 | Big Stone | Minnesota | 27011 | 451 | 3 |
928261 | 928261 | 2021-01-14 | Blue Earth | Minnesota | 27013 | 5338 | 33 |
928262 | 928262 | 2021-01-14 | Brown | Minnesota | 27015 | 2123 | 34 |
928263 | 928263 | 2021-01-14 | Carlton | Minnesota | 27017 | 2769 | 42 |
928264 | 928264 | 2021-01-14 | Carver | Minnesota | 27019 | 6866 | 36 |
928265 | 928265 | 2021-01-14 | Cass | Minnesota | 27021 | 2038 | 23 |
928266 | 928266 | 2021-01-14 | Chippewa | Minnesota | 27023 | 1306 | 32 |
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);