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 322
- 27019 320
- 27003 318
- 27109 317
- 27037 316
- 27053 316
- 27145 316
- 27171 315
- 27129 314
- 27161 313
- 27163 313
- 27009 312
- 27013 312
- 27091 311
- 27103 311
- 27131 310
- 27099 309
- 27139 309
- 27025 308
- 27027 308
- 27045 308
- 27039 307
- 27063 307
- 27137 307
- 27147 307
- 27157 307
- 27079 306
- 27011 305
- 27021 305
- 27073 305
- …
county >30
- Ramsey 322
- Carver 320
- Anoka 318
- Olmsted 317
- Dakota 316
- Hennepin 316
- Stearns 316
- Wright 315
- Renville 314
- Waseca 313
- Washington 313
- Benton 312
- Blue Earth 312
- Martin 311
- Nicollet 311
- Rice 310
- Mower 309
- Scott 309
- Chisago 308
- Clay 308
- Fillmore 308
- Dodge 307
- Jackson 307
- St. Louis 307
- Steele 307
- Wabasha 307
- Le Sueur 306
- Big Stone 305
- Cass 305
- Lac qui Parle 305
- …
state 1
- Minnesota · 25,907 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
950973 | 950973 | 2021-01-21 | Aitkin | Minnesota | 27001 | 1085 | 33 |
950974 | 950974 | 2021-01-21 | Anoka | Minnesota | 27003 | 31118 | 366 |
950975 | 950975 | 2021-01-21 | Becker | Minnesota | 27005 | 2869 | 39 |
950976 | 950976 | 2021-01-21 | Beltrami | Minnesota | 27007 | 3132 | 48 |
950977 | 950977 | 2021-01-21 | Benton | Minnesota | 27009 | 4215 | 87 |
950978 | 950978 | 2021-01-21 | Big Stone | Minnesota | 27011 | 466 | 3 |
950979 | 950979 | 2021-01-21 | Blue Earth | Minnesota | 27013 | 5448 | 33 |
950980 | 950980 | 2021-01-21 | Brown | Minnesota | 27015 | 2158 | 34 |
950981 | 950981 | 2021-01-21 | Carlton | Minnesota | 27017 | 2822 | 43 |
950982 | 950982 | 2021-01-21 | Carver | Minnesota | 27019 | 6983 | 38 |
950983 | 950983 | 2021-01-21 | Cass | Minnesota | 27021 | 2084 | 24 |
950984 | 950984 | 2021-01-21 | Chippewa | Minnesota | 27023 | 1317 | 32 |
950985 | 950985 | 2021-01-21 | Chisago | Minnesota | 27025 | 4550 | 36 |
950986 | 950986 | 2021-01-21 | Clay | Minnesota | 27027 | 6546 | 81 |
950987 | 950987 | 2021-01-21 | Clearwater | Minnesota | 27029 | 686 | 14 |
950988 | 950988 | 2021-01-21 | Cook | Minnesota | 27031 | 115 | 0 |
950989 | 950989 | 2021-01-21 | Cottonwood | Minnesota | 27033 | 1278 | 18 |
950990 | 950990 | 2021-01-21 | Crow Wing | Minnesota | 27035 | 4868 | 77 |
950991 | 950991 | 2021-01-21 | Dakota | Minnesota | 27037 | 33243 | 348 |
950992 | 950992 | 2021-01-21 | Dodge | Minnesota | 27039 | 1362 | 4 |
950993 | 950993 | 2021-01-21 | Douglas | Minnesota | 27041 | 3766 | 66 |
950994 | 950994 | 2021-01-21 | Faribault | Minnesota | 27043 | 1074 | 16 |
950995 | 950995 | 2021-01-21 | Fillmore | Minnesota | 27045 | 1253 | 5 |
950996 | 950996 | 2021-01-21 | Freeborn | Minnesota | 27047 | 2495 | 23 |
950997 | 950997 | 2021-01-21 | Goodhue | Minnesota | 27049 | 3512 | 59 |
950998 | 950998 | 2021-01-21 | Grant | Minnesota | 27051 | 429 | 8 |
950999 | 950999 | 2021-01-21 | Hennepin | Minnesota | 27053 | 93511 | 1486 |
951000 | 951000 | 2021-01-21 | Houston | Minnesota | 27055 | 1390 | 14 |
951001 | 951001 | 2021-01-21 | Hubbard | Minnesota | 27057 | 1499 | 38 |
951002 | 951002 | 2021-01-21 | Isanti | Minnesota | 27059 | 2832 | 41 |
951003 | 951003 | 2021-01-21 | Itasca | Minnesota | 27061 | 2859 | 43 |
951004 | 951004 | 2021-01-21 | Jackson | Minnesota | 27063 | 863 | 10 |
951005 | 951005 | 2021-01-21 | Kanabec | Minnesota | 27065 | 980 | 18 |
951006 | 951006 | 2021-01-21 | Kandiyohi | Minnesota | 27067 | 5557 | 72 |
951007 | 951007 | 2021-01-21 | Kittson | Minnesota | 27069 | 372 | 20 |
951008 | 951008 | 2021-01-21 | Koochiching | Minnesota | 27071 | 599 | 10 |
951009 | 951009 | 2021-01-21 | Lac qui Parle | Minnesota | 27073 | 657 | 16 |
951010 | 951010 | 2021-01-21 | Lake | Minnesota | 27075 | 656 | 15 |
951011 | 951011 | 2021-01-21 | Lake of the Woods | Minnesota | 27077 | 195 | 1 |
951012 | 951012 | 2021-01-21 | Le Sueur | Minnesota | 27079 | 2117 | 16 |
951013 | 951013 | 2021-01-21 | Lincoln | Minnesota | 27081 | 489 | 2 |
951014 | 951014 | 2021-01-21 | Lyon | Minnesota | 27083 | 3033 | 38 |
951015 | 951015 | 2021-01-21 | Mahnomen | Minnesota | 27087 | 413 | 7 |
951016 | 951016 | 2021-01-21 | Marshall | Minnesota | 27089 | 703 | 15 |
951017 | 951017 | 2021-01-21 | Martin | Minnesota | 27091 | 1713 | 26 |
951018 | 951018 | 2021-01-21 | McLeod | Minnesota | 27085 | 3265 | 46 |
951019 | 951019 | 2021-01-21 | Meeker | Minnesota | 27093 | 2006 | 33 |
951020 | 951020 | 2021-01-21 | Mille Lacs | Minnesota | 27095 | 2147 | 45 |
951021 | 951021 | 2021-01-21 | Morrison | Minnesota | 27097 | 3129 | 45 |
951022 | 951022 | 2021-01-21 | Mower | Minnesota | 27099 | 3694 | 29 |
951023 | 951023 | 2021-01-21 | Murray | Minnesota | 27101 | 899 | 5 |
951024 | 951024 | 2021-01-21 | Nicollet | Minnesota | 27103 | 2264 | 37 |
951025 | 951025 | 2021-01-21 | Nobles | Minnesota | 27105 | 3724 | 46 |
951026 | 951026 | 2021-01-21 | Norman | Minnesota | 27107 | 424 | 8 |
951027 | 951027 | 2021-01-21 | Olmsted | Minnesota | 27109 | 10620 | 75 |
951028 | 951028 | 2021-01-21 | Otter Tail | Minnesota | 27111 | 4593 | 67 |
951029 | 951029 | 2021-01-21 | Pennington | Minnesota | 27113 | 1003 | 15 |
951030 | 951030 | 2021-01-21 | Pine | Minnesota | 27115 | 2678 | 14 |
951031 | 951031 | 2021-01-21 | Pipestone | Minnesota | 27117 | 955 | 23 |
951032 | 951032 | 2021-01-21 | Polk | Minnesota | 27119 | 3300 | 59 |
951033 | 951033 | 2021-01-21 | Pope | Minnesota | 27121 | 742 | 5 |
951034 | 951034 | 2021-01-21 | Ramsey | Minnesota | 27123 | 40220 | 742 |
951035 | 951035 | 2021-01-21 | Red Lake | Minnesota | 27125 | 318 | 4 |
951036 | 951036 | 2021-01-21 | Redwood | Minnesota | 27127 | 1406 | 27 |
951037 | 951037 | 2021-01-21 | Renville | Minnesota | 27129 | 1378 | 40 |
951038 | 951038 | 2021-01-21 | Rice | Minnesota | 27131 | 6139 | 69 |
951039 | 951039 | 2021-01-21 | Rock | Minnesota | 27133 | 1106 | 12 |
951040 | 951040 | 2021-01-21 | Roseau | Minnesota | 27135 | 1661 | 17 |
951041 | 951041 | 2021-01-21 | Scott | Minnesota | 27139 | 12035 | 97 |
951042 | 951042 | 2021-01-21 | Sherburne | Minnesota | 27141 | 8239 | 66 |
951043 | 951043 | 2021-01-21 | Sibley | Minnesota | 27143 | 1089 | 7 |
951044 | 951044 | 2021-01-21 | St. Louis | Minnesota | 27137 | 13777 | 244 |
951045 | 951045 | 2021-01-21 | Stearns | Minnesota | 27145 | 17957 | 188 |
951046 | 951046 | 2021-01-21 | Steele | Minnesota | 27147 | 2758 | 10 |
951047 | 951047 | 2021-01-21 | Stevens | Minnesota | 27149 | 703 | 8 |
951048 | 951048 | 2021-01-21 | Swift | Minnesota | 27151 | 838 | 18 |
951049 | 951049 | 2021-01-21 | Todd | Minnesota | 27153 | 2325 | 30 |
951050 | 951050 | 2021-01-21 | Traverse | Minnesota | 27155 | 255 | 3 |
951051 | 951051 | 2021-01-21 | Unknown | Minnesota | 507 | 68 | |
951052 | 951052 | 2021-01-21 | Wabasha | Minnesota | 27157 | 1729 | 3 |
951053 | 951053 | 2021-01-21 | Wadena | Minnesota | 27159 | 1204 | 17 |
951054 | 951054 | 2021-01-21 | Waseca | Minnesota | 27161 | 1907 | 16 |
951055 | 951055 | 2021-01-21 | Washington | Minnesota | 27163 | 20282 | 231 |
951056 | 951056 | 2021-01-21 | Watonwan | Minnesota | 27165 | 1067 | 8 |
951057 | 951057 | 2021-01-21 | Wilkin | Minnesota | 27167 | 629 | 9 |
951058 | 951058 | 2021-01-21 | Winona | Minnesota | 27169 | 3919 | 48 |
951059 | 951059 | 2021-01-21 | Wright | Minnesota | 27171 | 11688 | 106 |
951060 | 951060 | 2021-01-21 | Yellow Medicine | Minnesota | 27173 | 939 | 16 |
947727 | 947727 | 2021-01-20 | Aitkin | Minnesota | 27001 | 1083 | 33 |
947728 | 947728 | 2021-01-20 | Anoka | Minnesota | 27003 | 31061 | 365 |
947729 | 947729 | 2021-01-20 | Becker | Minnesota | 27005 | 2862 | 39 |
947730 | 947730 | 2021-01-20 | Beltrami | Minnesota | 27007 | 3110 | 48 |
947731 | 947731 | 2021-01-20 | Benton | Minnesota | 27009 | 4210 | 86 |
947732 | 947732 | 2021-01-20 | Big Stone | Minnesota | 27011 | 460 | 3 |
947733 | 947733 | 2021-01-20 | Blue Earth | Minnesota | 27013 | 5432 | 33 |
947734 | 947734 | 2021-01-20 | Brown | Minnesota | 27015 | 2155 | 34 |
947735 | 947735 | 2021-01-20 | Carlton | Minnesota | 27017 | 2809 | 43 |
947736 | 947736 | 2021-01-20 | Carver | Minnesota | 27019 | 6964 | 36 |
947737 | 947737 | 2021-01-20 | Cass | Minnesota | 27021 | 2077 | 23 |
947738 | 947738 | 2021-01-20 | Chippewa | Minnesota | 27023 | 1316 | 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);