ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where "date" is on date 2020-09-29 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
581092 | 581092 | 2020-09-29 | Aitkin | Minnesota | 27001 | 84 | 1 |
581093 | 581093 | 2020-09-29 | Anoka | Minnesota | 27003 | 6281 | 137 |
581094 | 581094 | 2020-09-29 | Becker | Minnesota | 27005 | 284 | 2 |
581095 | 581095 | 2020-09-29 | Beltrami | Minnesota | 27007 | 460 | 5 |
581096 | 581096 | 2020-09-29 | Benton | Minnesota | 27009 | 563 | 3 |
581097 | 581097 | 2020-09-29 | Big Stone | Minnesota | 27011 | 83 | 0 |
581098 | 581098 | 2020-09-29 | Blue Earth | Minnesota | 27013 | 1736 | 6 |
581099 | 581099 | 2020-09-29 | Brown | Minnesota | 27015 | 196 | 2 |
581100 | 581100 | 2020-09-29 | Carlton | Minnesota | 27017 | 279 | 1 |
581101 | 581101 | 2020-09-29 | Carver | Minnesota | 27019 | 1446 | 7 |
581102 | 581102 | 2020-09-29 | Cass | Minnesota | 27021 | 186 | 4 |
581103 | 581103 | 2020-09-29 | Chippewa | Minnesota | 27023 | 232 | 1 |
581104 | 581104 | 2020-09-29 | Chisago | Minnesota | 27025 | 517 | 1 |
581105 | 581105 | 2020-09-29 | Clay | Minnesota | 27027 | 1424 | 41 |
581106 | 581106 | 2020-09-29 | Clearwater | Minnesota | 27029 | 31 | 0 |
581107 | 581107 | 2020-09-29 | Cook | Minnesota | 27031 | 7 | 0 |
581108 | 581108 | 2020-09-29 | Cottonwood | Minnesota | 27033 | 229 | 0 |
581109 | 581109 | 2020-09-29 | Crow Wing | Minnesota | 27035 | 554 | 18 |
581110 | 581110 | 2020-09-29 | Dakota | Minnesota | 27037 | 7692 | 126 |
581111 | 581111 | 2020-09-29 | Dodge | Minnesota | 27039 | 261 | 0 |
581112 | 581112 | 2020-09-29 | Douglas | Minnesota | 27041 | 352 | 2 |
581113 | 581113 | 2020-09-29 | Faribault | Minnesota | 27043 | 147 | 0 |
581114 | 581114 | 2020-09-29 | Fillmore | Minnesota | 27045 | 133 | 0 |
581115 | 581115 | 2020-09-29 | Freeborn | Minnesota | 27047 | 546 | 4 |
581116 | 581116 | 2020-09-29 | Goodhue | Minnesota | 27049 | 389 | 9 |
581117 | 581117 | 2020-09-29 | Grant | Minnesota | 27051 | 63 | 4 |
581118 | 581118 | 2020-09-29 | Hennepin | Minnesota | 27053 | 27557 | 932 |
581119 | 581119 | 2020-09-29 | Houston | Minnesota | 27055 | 130 | 0 |
581120 | 581120 | 2020-09-29 | Hubbard | Minnesota | 27057 | 122 | 1 |
581121 | 581121 | 2020-09-29 | Isanti | Minnesota | 27059 | 319 | 1 |
581122 | 581122 | 2020-09-29 | Itasca | Minnesota | 27061 | 352 | 15 |
581123 | 581123 | 2020-09-29 | Jackson | Minnesota | 27063 | 153 | 1 |
581124 | 581124 | 2020-09-29 | Kanabec | Minnesota | 27065 | 128 | 8 |
581125 | 581125 | 2020-09-29 | Kandiyohi | Minnesota | 27067 | 1056 | 3 |
581126 | 581126 | 2020-09-29 | Kittson | Minnesota | 27069 | 12 | 0 |
581127 | 581127 | 2020-09-29 | Koochiching | Minnesota | 27071 | 123 | 3 |
581128 | 581128 | 2020-09-29 | Lac qui Parle | Minnesota | 27073 | 68 | 1 |
581129 | 581129 | 2020-09-29 | Lake | Minnesota | 27075 | 60 | 0 |
581130 | 581130 | 2020-09-29 | Lake of the Woods | Minnesota | 27077 | 24 | 1 |
581131 | 581131 | 2020-09-29 | Le Sueur | Minnesota | 27079 | 476 | 4 |
581132 | 581132 | 2020-09-29 | Lincoln | Minnesota | 27081 | 118 | 0 |
581133 | 581133 | 2020-09-29 | Lyon | Minnesota | 27083 | 733 | 4 |
581134 | 581134 | 2020-09-29 | Mahnomen | Minnesota | 27087 | 49 | 1 |
581135 | 581135 | 2020-09-29 | Marshall | Minnesota | 27089 | 53 | 1 |
581136 | 581136 | 2020-09-29 | Martin | Minnesota | 27091 | 446 | 11 |
581137 | 581137 | 2020-09-29 | McLeod | Minnesota | 27085 | 502 | 2 |
581138 | 581138 | 2020-09-29 | Meeker | Minnesota | 27093 | 213 | 2 |
581139 | 581139 | 2020-09-29 | Mille Lacs | Minnesota | 27095 | 169 | 3 |
581140 | 581140 | 2020-09-29 | Morrison | Minnesota | 27097 | 270 | 2 |
581141 | 581141 | 2020-09-29 | Mower | Minnesota | 27099 | 1344 | 6 |
581142 | 581142 | 2020-09-29 | Murray | Minnesota | 27101 | 174 | 2 |
581143 | 581143 | 2020-09-29 | Nicollet | Minnesota | 27103 | 547 | 17 |
581144 | 581144 | 2020-09-29 | Nobles | Minnesota | 27105 | 1979 | 16 |
581145 | 581145 | 2020-09-29 | Norman | Minnesota | 27107 | 56 | 0 |
581146 | 581146 | 2020-09-29 | Olmsted | Minnesota | 27109 | 2535 | 28 |
581147 | 581147 | 2020-09-29 | Otter Tail | Minnesota | 27111 | 469 | 4 |
581148 | 581148 | 2020-09-29 | Pennington | Minnesota | 27113 | 120 | 1 |
581149 | 581149 | 2020-09-29 | Pine | Minnesota | 27115 | 355 | 0 |
581150 | 581150 | 2020-09-29 | Pipestone | Minnesota | 27117 | 238 | 10 |
581151 | 581151 | 2020-09-29 | Polk | Minnesota | 27119 | 327 | 4 |
581152 | 581152 | 2020-09-29 | Pope | Minnesota | 27121 | 100 | 0 |
581153 | 581153 | 2020-09-29 | Ramsey | Minnesota | 27123 | 11167 | 323 |
581154 | 581154 | 2020-09-29 | Red Lake | Minnesota | 27125 | 45 | 1 |
581155 | 581155 | 2020-09-29 | Redwood | Minnesota | 27127 | 178 | 3 |
581156 | 581156 | 2020-09-29 | Renville | Minnesota | 27129 | 161 | 8 |
581157 | 581157 | 2020-09-29 | Rice | Minnesota | 27131 | 1347 | 8 |
581158 | 581158 | 2020-09-29 | Rock | Minnesota | 27133 | 181 | 0 |
581159 | 581159 | 2020-09-29 | Roseau | Minnesota | 27135 | 126 | 0 |
581160 | 581160 | 2020-09-29 | Scott | Minnesota | 27139 | 2648 | 33 |
581161 | 581161 | 2020-09-29 | Sherburne | Minnesota | 27141 | 1177 | 14 |
581162 | 581162 | 2020-09-29 | Sibley | Minnesota | 27143 | 202 | 3 |
581163 | 581163 | 2020-09-29 | St. Louis | Minnesota | 27137 | 1725 | 42 |
581164 | 581164 | 2020-09-29 | Stearns | Minnesota | 27145 | 4094 | 24 |
581165 | 581165 | 2020-09-29 | Steele | Minnesota | 27147 | 555 | 2 |
581166 | 581166 | 2020-09-29 | Stevens | Minnesota | 27149 | 107 | 1 |
581167 | 581167 | 2020-09-29 | Swift | Minnesota | 27151 | 144 | 1 |
581168 | 581168 | 2020-09-29 | Todd | Minnesota | 27153 | 507 | 2 |
581169 | 581169 | 2020-09-29 | Traverse | Minnesota | 27155 | 34 | 0 |
581170 | 581170 | 2020-09-29 | Unknown | Minnesota | 205 | 52 | |
581171 | 581171 | 2020-09-29 | Wabasha | Minnesota | 27157 | 206 | 0 |
581172 | 581172 | 2020-09-29 | Wadena | Minnesota | 27159 | 73 | 0 |
581173 | 581173 | 2020-09-29 | Waseca | Minnesota | 27161 | 722 | 8 |
581174 | 581174 | 2020-09-29 | Washington | Minnesota | 27163 | 3918 | 55 |
581175 | 581175 | 2020-09-29 | Watonwan | Minnesota | 27165 | 535 | 4 |
581176 | 581176 | 2020-09-29 | Wilkin | Minnesota | 27167 | 71 | 3 |
581177 | 581177 | 2020-09-29 | Winona | Minnesota | 27169 | 920 | 18 |
581178 | 581178 | 2020-09-29 | Wright | Minnesota | 27171 | 1701 | 7 |
581179 | 581179 | 2020-09-29 | Yellow Medicine | Minnesota | 27173 | 198 | 2 |
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);