ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
87 rows where date = "2020-06-21" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
260122 | 260122 | 2020-06-21 | Aitkin | Minnesota | 27001 | 13 | 0 |
260123 | 260123 | 2020-06-21 | Anoka | Minnesota | 27003 | 1894 | 102 |
260124 | 260124 | 2020-06-21 | Becker | Minnesota | 27005 | 49 | 0 |
260125 | 260125 | 2020-06-21 | Beltrami | Minnesota | 27007 | 25 | 0 |
260126 | 260126 | 2020-06-21 | Benton | Minnesota | 27009 | 201 | 3 |
260127 | 260127 | 2020-06-21 | Big Stone | Minnesota | 27011 | 14 | 0 |
260128 | 260128 | 2020-06-21 | Blue Earth | Minnesota | 27013 | 214 | 2 |
260129 | 260129 | 2020-06-21 | Brown | Minnesota | 27015 | 21 | 2 |
260130 | 260130 | 2020-06-21 | Carlton | Minnesota | 27017 | 81 | 0 |
260131 | 260131 | 2020-06-21 | Carver | Minnesota | 27019 | 294 | 1 |
260132 | 260132 | 2020-06-21 | Cass | Minnesota | 27021 | 12 | 2 |
260133 | 260133 | 2020-06-21 | Chippewa | Minnesota | 27023 | 66 | 1 |
260134 | 260134 | 2020-06-21 | Chisago | Minnesota | 27025 | 87 | 1 |
260135 | 260135 | 2020-06-21 | Clay | Minnesota | 27027 | 526 | 37 |
260136 | 260136 | 2020-06-21 | Clearwater | Minnesota | 27029 | 6 | 0 |
260137 | 260137 | 2020-06-21 | Cook | Minnesota | 27031 | 1 | 0 |
260138 | 260138 | 2020-06-21 | Cottonwood | Minnesota | 27033 | 121 | 0 |
260139 | 260139 | 2020-06-21 | Crow Wing | Minnesota | 27035 | 94 | 11 |
260140 | 260140 | 2020-06-21 | Dakota | Minnesota | 27037 | 1915 | 82 |
260141 | 260141 | 2020-06-21 | Dodge | Minnesota | 27039 | 65 | 0 |
260142 | 260142 | 2020-06-21 | Douglas | Minnesota | 27041 | 54 | 0 |
260143 | 260143 | 2020-06-21 | Faribault | Minnesota | 27043 | 33 | 0 |
260144 | 260144 | 2020-06-21 | Fillmore | Minnesota | 27045 | 23 | 0 |
260145 | 260145 | 2020-06-21 | Freeborn | Minnesota | 27047 | 251 | 0 |
260146 | 260146 | 2020-06-21 | Goodhue | Minnesota | 27049 | 105 | 7 |
260147 | 260147 | 2020-06-21 | Grant | Minnesota | 27051 | 6 | 0 |
260148 | 260148 | 2020-06-21 | Hennepin | Minnesota | 27053 | 10830 | 747 |
260149 | 260149 | 2020-06-21 | Houston | Minnesota | 27055 | 13 | 0 |
260150 | 260150 | 2020-06-21 | Hubbard | Minnesota | 27057 | 5 | 0 |
260151 | 260151 | 2020-06-21 | Isanti | Minnesota | 27059 | 55 | 0 |
260152 | 260152 | 2020-06-21 | Itasca | Minnesota | 27061 | 59 | 12 |
260153 | 260153 | 2020-06-21 | Jackson | Minnesota | 27063 | 52 | 0 |
260154 | 260154 | 2020-06-21 | Kanabec | Minnesota | 27065 | 13 | 1 |
260155 | 260155 | 2020-06-21 | Kandiyohi | Minnesota | 27067 | 560 | 1 |
260156 | 260156 | 2020-06-21 | Kittson | Minnesota | 27069 | 1 | 0 |
260157 | 260157 | 2020-06-21 | Koochiching | Minnesota | 27071 | 9 | 0 |
260158 | 260158 | 2020-06-21 | Lac qui Parle | Minnesota | 27073 | 4 | 0 |
260159 | 260159 | 2020-06-21 | Lake | Minnesota | 27075 | 4 | 0 |
260160 | 260160 | 2020-06-21 | Le Sueur | Minnesota | 27079 | 62 | 1 |
260161 | 260161 | 2020-06-21 | Lincoln | Minnesota | 27081 | 6 | 0 |
260162 | 260162 | 2020-06-21 | Lyon | Minnesota | 27083 | 274 | 2 |
260163 | 260163 | 2020-06-21 | Mahnomen | Minnesota | 27087 | 6 | 1 |
260164 | 260164 | 2020-06-21 | Marshall | Minnesota | 27089 | 12 | 0 |
260165 | 260165 | 2020-06-21 | Martin | Minnesota | 27091 | 148 | 5 |
260166 | 260166 | 2020-06-21 | McLeod | Minnesota | 27085 | 67 | 0 |
260167 | 260167 | 2020-06-21 | Meeker | Minnesota | 27093 | 51 | 1 |
260168 | 260168 | 2020-06-21 | Mille Lacs | Minnesota | 27095 | 30 | 1 |
260169 | 260169 | 2020-06-21 | Morrison | Minnesota | 27097 | 55 | 1 |
260170 | 260170 | 2020-06-21 | Mower | Minnesota | 27099 | 797 | 2 |
260171 | 260171 | 2020-06-21 | Murray | Minnesota | 27101 | 47 | 0 |
260172 | 260172 | 2020-06-21 | Nicollet | Minnesota | 27103 | 108 | 12 |
260173 | 260173 | 2020-06-21 | Nobles | Minnesota | 27105 | 1631 | 6 |
260174 | 260174 | 2020-06-21 | Norman | Minnesota | 27107 | 18 | 0 |
260175 | 260175 | 2020-06-21 | Olmsted | Minnesota | 27109 | 903 | 14 |
260176 | 260176 | 2020-06-21 | Otter Tail | Minnesota | 27111 | 85 | 1 |
260177 | 260177 | 2020-06-21 | Pennington | Minnesota | 27113 | 50 | 0 |
260178 | 260178 | 2020-06-21 | Pine | Minnesota | 27115 | 97 | 0 |
260179 | 260179 | 2020-06-21 | Pipestone | Minnesota | 27117 | 14 | 0 |
260180 | 260180 | 2020-06-21 | Polk | Minnesota | 27119 | 72 | 2 |
260181 | 260181 | 2020-06-21 | Pope | Minnesota | 27121 | 10 | 0 |
260182 | 260182 | 2020-06-21 | Ramsey | Minnesota | 27123 | 4306 | 210 |
260183 | 260183 | 2020-06-21 | Red Lake | Minnesota | 27125 | 3 | 0 |
260184 | 260184 | 2020-06-21 | Redwood | Minnesota | 27127 | 12 | 0 |
260185 | 260185 | 2020-06-21 | Renville | Minnesota | 27129 | 12 | 1 |
260186 | 260186 | 2020-06-21 | Rice | Minnesota | 27131 | 748 | 4 |
260187 | 260187 | 2020-06-21 | Rock | Minnesota | 27133 | 28 | 0 |
260188 | 260188 | 2020-06-21 | Roseau | Minnesota | 27135 | 6 | 0 |
260189 | 260189 | 2020-06-21 | Scott | Minnesota | 27139 | 570 | 4 |
260190 | 260190 | 2020-06-21 | Sherburne | Minnesota | 27141 | 275 | 4 |
260191 | 260191 | 2020-06-21 | Sibley | Minnesota | 27143 | 29 | 2 |
260192 | 260192 | 2020-06-21 | St. Louis | Minnesota | 27137 | 142 | 14 |
260193 | 260193 | 2020-06-21 | Stearns | Minnesota | 27145 | 2134 | 19 |
260194 | 260194 | 2020-06-21 | Steele | Minnesota | 27147 | 194 | 0 |
260195 | 260195 | 2020-06-21 | Stevens | Minnesota | 27149 | 2 | 0 |
260196 | 260196 | 2020-06-21 | Swift | Minnesota | 27151 | 20 | 1 |
260197 | 260197 | 2020-06-21 | Todd | Minnesota | 27153 | 388 | 2 |
260198 | 260198 | 2020-06-21 | Traverse | Minnesota | 27155 | 5 | 0 |
260199 | 260199 | 2020-06-21 | Unknown | Minnesota | 114 | 32 | |
260200 | 260200 | 2020-06-21 | Wabasha | Minnesota | 27157 | 27 | 0 |
260201 | 260201 | 2020-06-21 | Wadena | Minnesota | 27159 | 12 | 0 |
260202 | 260202 | 2020-06-21 | Waseca | Minnesota | 27161 | 40 | 0 |
260203 | 260203 | 2020-06-21 | Washington | Minnesota | 27163 | 885 | 38 |
260204 | 260204 | 2020-06-21 | Watonwan | Minnesota | 27165 | 144 | 0 |
260205 | 260205 | 2020-06-21 | Wilkin | Minnesota | 27167 | 20 | 3 |
260206 | 260206 | 2020-06-21 | Winona | Minnesota | 27169 | 94 | 15 |
260207 | 260207 | 2020-06-21 | Wright | Minnesota | 27171 | 401 | 2 |
260208 | 260208 | 2020-06-21 | Yellow Medicine | Minnesota | 27173 | 22 | 0 |
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);