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 310
- 27019 308
- 27003 306
- 27109 305
- 27037 304
- 27053 304
- 27145 304
- 27171 303
- 27129 302
- 27161 301
- 27163 301
- 27009 300
- 27013 300
- 27091 299
- 27103 299
- 27131 298
- 27099 297
- 27139 297
- 27025 296
- 27027 296
- 27045 296
- 27039 295
- 27063 295
- 27137 295
- 27147 295
- 27157 295
- 27079 294
- 27011 293
- 27021 293
- 27073 293
- …
county >30
- Ramsey 310
- Carver 308
- Anoka 306
- Olmsted 305
- Dakota 304
- Hennepin 304
- Stearns 304
- Wright 303
- Renville 302
- Waseca 301
- Washington 301
- Benton 300
- Blue Earth 300
- Martin 299
- Nicollet 299
- Rice 298
- Mower 297
- Scott 297
- Chisago 296
- Clay 296
- Fillmore 296
- Dodge 295
- Jackson 295
- St. Louis 295
- Steele 295
- Wabasha 295
- Le Sueur 294
- Big Stone 293
- Cass 293
- Lac qui Parle 293
- …
state 1
- Minnesota · 24,851 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
912029 | 912029 | 2021-01-09 | Aitkin | Minnesota | 27001 | 1047 | 33 |
912030 | 912030 | 2021-01-09 | Anoka | Minnesota | 27003 | 30210 | 346 |
912031 | 912031 | 2021-01-09 | Becker | Minnesota | 27005 | 2763 | 38 |
912032 | 912032 | 2021-01-09 | Beltrami | Minnesota | 27007 | 2994 | 45 |
912033 | 912033 | 2021-01-09 | Benton | Minnesota | 27009 | 4076 | 84 |
912034 | 912034 | 2021-01-09 | Big Stone | Minnesota | 27011 | 449 | 3 |
912035 | 912035 | 2021-01-09 | Blue Earth | Minnesota | 27013 | 5263 | 32 |
912036 | 912036 | 2021-01-09 | Brown | Minnesota | 27015 | 2084 | 34 |
912037 | 912037 | 2021-01-09 | Carlton | Minnesota | 27017 | 2730 | 40 |
912038 | 912038 | 2021-01-09 | Carver | Minnesota | 27019 | 6755 | 34 |
912039 | 912039 | 2021-01-09 | Cass | Minnesota | 27021 | 2002 | 21 |
912040 | 912040 | 2021-01-09 | Chippewa | Minnesota | 27023 | 1302 | 31 |
912041 | 912041 | 2021-01-09 | Chisago | Minnesota | 27025 | 4402 | 29 |
912042 | 912042 | 2021-01-09 | Clay | Minnesota | 27027 | 6357 | 78 |
912043 | 912043 | 2021-01-09 | Clearwater | Minnesota | 27029 | 676 | 14 |
912044 | 912044 | 2021-01-09 | Cook | Minnesota | 27031 | 109 | 0 |
912045 | 912045 | 2021-01-09 | Cottonwood | Minnesota | 27033 | 1238 | 16 |
912046 | 912046 | 2021-01-09 | Crow Wing | Minnesota | 27035 | 4666 | 71 |
912047 | 912047 | 2021-01-09 | Dakota | Minnesota | 27037 | 31965 | 298 |
912048 | 912048 | 2021-01-09 | Dodge | Minnesota | 27039 | 1273 | 4 |
912049 | 912049 | 2021-01-09 | Douglas | Minnesota | 27041 | 3653 | 64 |
912050 | 912050 | 2021-01-09 | Faribault | Minnesota | 27043 | 1006 | 13 |
912051 | 912051 | 2021-01-09 | Fillmore | Minnesota | 27045 | 1169 | 2 |
912052 | 912052 | 2021-01-09 | Freeborn | Minnesota | 27047 | 2214 | 18 |
912053 | 912053 | 2021-01-09 | Goodhue | Minnesota | 27049 | 3312 | 52 |
912054 | 912054 | 2021-01-09 | Grant | Minnesota | 27051 | 417 | 7 |
912055 | 912055 | 2021-01-09 | Hennepin | Minnesota | 27053 | 90265 | 1443 |
912056 | 912056 | 2021-01-09 | Houston | Minnesota | 27055 | 1280 | 13 |
912057 | 912057 | 2021-01-09 | Hubbard | Minnesota | 27057 | 1442 | 37 |
912058 | 912058 | 2021-01-09 | Isanti | Minnesota | 27059 | 2764 | 37 |
912059 | 912059 | 2021-01-09 | Itasca | Minnesota | 27061 | 2767 | 41 |
912060 | 912060 | 2021-01-09 | Jackson | Minnesota | 27063 | 822 | 10 |
912061 | 912061 | 2021-01-09 | Kanabec | Minnesota | 27065 | 956 | 18 |
912062 | 912062 | 2021-01-09 | Kandiyohi | Minnesota | 27067 | 5472 | 68 |
912063 | 912063 | 2021-01-09 | Kittson | Minnesota | 27069 | 356 | 19 |
912064 | 912064 | 2021-01-09 | Koochiching | Minnesota | 27071 | 569 | 10 |
912065 | 912065 | 2021-01-09 | Lac qui Parle | Minnesota | 27073 | 645 | 16 |
912066 | 912066 | 2021-01-09 | Lake | Minnesota | 27075 | 589 | 15 |
912067 | 912067 | 2021-01-09 | Lake of the Woods | Minnesota | 27077 | 163 | 1 |
912068 | 912068 | 2021-01-09 | Le Sueur | Minnesota | 27079 | 2039 | 15 |
912069 | 912069 | 2021-01-09 | Lincoln | Minnesota | 27081 | 475 | 1 |
912070 | 912070 | 2021-01-09 | Lyon | Minnesota | 27083 | 2954 | 32 |
912071 | 912071 | 2021-01-09 | Mahnomen | Minnesota | 27087 | 402 | 7 |
912072 | 912072 | 2021-01-09 | Marshall | Minnesota | 27089 | 695 | 15 |
912073 | 912073 | 2021-01-09 | Martin | Minnesota | 27091 | 1643 | 26 |
912074 | 912074 | 2021-01-09 | McLeod | Minnesota | 27085 | 3189 | 41 |
912075 | 912075 | 2021-01-09 | Meeker | Minnesota | 27093 | 1942 | 33 |
912076 | 912076 | 2021-01-09 | Mille Lacs | Minnesota | 27095 | 2100 | 45 |
912077 | 912077 | 2021-01-09 | Morrison | Minnesota | 27097 | 3049 | 43 |
912078 | 912078 | 2021-01-09 | Mower | Minnesota | 27099 | 3479 | 26 |
912079 | 912079 | 2021-01-09 | Murray | Minnesota | 27101 | 831 | 5 |
912080 | 912080 | 2021-01-09 | Nicollet | Minnesota | 27103 | 2186 | 36 |
912081 | 912081 | 2021-01-09 | Nobles | Minnesota | 27105 | 3599 | 46 |
912082 | 912082 | 2021-01-09 | Norman | Minnesota | 27107 | 418 | 8 |
912083 | 912083 | 2021-01-09 | Olmsted | Minnesota | 27109 | 9978 | 66 |
912084 | 912084 | 2021-01-09 | Otter Tail | Minnesota | 27111 | 4408 | 57 |
912085 | 912085 | 2021-01-09 | Pennington | Minnesota | 27113 | 923 | 15 |
912086 | 912086 | 2021-01-09 | Pine | Minnesota | 27115 | 2602 | 12 |
912087 | 912087 | 2021-01-09 | Pipestone | Minnesota | 27117 | 905 | 22 |
912088 | 912088 | 2021-01-09 | Polk | Minnesota | 27119 | 3247 | 53 |
912089 | 912089 | 2021-01-09 | Pope | Minnesota | 27121 | 724 | 5 |
912090 | 912090 | 2021-01-09 | Ramsey | Minnesota | 27123 | 38748 | 718 |
912091 | 912091 | 2021-01-09 | Red Lake | Minnesota | 27125 | 313 | 4 |
912092 | 912092 | 2021-01-09 | Redwood | Minnesota | 27127 | 1356 | 27 |
912093 | 912093 | 2021-01-09 | Renville | Minnesota | 27129 | 1347 | 39 |
912094 | 912094 | 2021-01-09 | Rice | Minnesota | 27131 | 5830 | 62 |
912095 | 912095 | 2021-01-09 | Rock | Minnesota | 27133 | 1061 | 11 |
912096 | 912096 | 2021-01-09 | Roseau | Minnesota | 27135 | 1639 | 16 |
912097 | 912097 | 2021-01-09 | Scott | Minnesota | 27139 | 11591 | 91 |
912098 | 912098 | 2021-01-09 | Sherburne | Minnesota | 27141 | 8023 | 62 |
912099 | 912099 | 2021-01-09 | Sibley | Minnesota | 27143 | 1056 | 6 |
912100 | 912100 | 2021-01-09 | St. Louis | Minnesota | 27137 | 13202 | 226 |
912101 | 912101 | 2021-01-09 | Stearns | Minnesota | 27145 | 17499 | 179 |
912102 | 912102 | 2021-01-09 | Steele | Minnesota | 27147 | 2605 | 9 |
912103 | 912103 | 2021-01-09 | Stevens | Minnesota | 27149 | 689 | 8 |
912104 | 912104 | 2021-01-09 | Swift | Minnesota | 27151 | 818 | 17 |
912105 | 912105 | 2021-01-09 | Todd | Minnesota | 27153 | 2281 | 29 |
912106 | 912106 | 2021-01-09 | Traverse | Minnesota | 27155 | 234 | 2 |
912107 | 912107 | 2021-01-09 | Unknown | Minnesota | 500 | 68 | |
912108 | 912108 | 2021-01-09 | Wabasha | Minnesota | 27157 | 1625 | 2 |
912109 | 912109 | 2021-01-09 | Wadena | Minnesota | 27159 | 1168 | 12 |
912110 | 912110 | 2021-01-09 | Waseca | Minnesota | 27161 | 1856 | 16 |
912111 | 912111 | 2021-01-09 | Washington | Minnesota | 27163 | 19449 | 211 |
912112 | 912112 | 2021-01-09 | Watonwan | Minnesota | 27165 | 1045 | 7 |
912113 | 912113 | 2021-01-09 | Wilkin | Minnesota | 27167 | 607 | 9 |
912114 | 912114 | 2021-01-09 | Winona | Minnesota | 27169 | 3736 | 45 |
912115 | 912115 | 2021-01-09 | Wright | Minnesota | 27171 | 11277 | 97 |
912116 | 912116 | 2021-01-09 | Yellow Medicine | Minnesota | 27173 | 916 | 14 |
908784 | 908784 | 2021-01-08 | Aitkin | Minnesota | 27001 | 1044 | 33 |
908785 | 908785 | 2021-01-08 | Anoka | Minnesota | 27003 | 30068 | 342 |
908786 | 908786 | 2021-01-08 | Becker | Minnesota | 27005 | 2752 | 37 |
908787 | 908787 | 2021-01-08 | Beltrami | Minnesota | 27007 | 2981 | 44 |
908788 | 908788 | 2021-01-08 | Benton | Minnesota | 27009 | 4052 | 84 |
908789 | 908789 | 2021-01-08 | Big Stone | Minnesota | 27011 | 449 | 3 |
908790 | 908790 | 2021-01-08 | Blue Earth | Minnesota | 27013 | 5226 | 32 |
908791 | 908791 | 2021-01-08 | Brown | Minnesota | 27015 | 2073 | 34 |
908792 | 908792 | 2021-01-08 | Carlton | Minnesota | 27017 | 2720 | 39 |
908793 | 908793 | 2021-01-08 | Carver | Minnesota | 27019 | 6716 | 34 |
908794 | 908794 | 2021-01-08 | Cass | Minnesota | 27021 | 1989 | 21 |
908795 | 908795 | 2021-01-08 | Chippewa | Minnesota | 27023 | 1298 | 31 |
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);