ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Benton" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387263 | 387263 | 2020-07-31 | Benton | Minnesota | 27009 | 299 | 3 |
384045 | 384045 | 2020-07-30 | Benton | Minnesota | 27009 | 294 | 3 |
380828 | 380828 | 2020-07-29 | Benton | Minnesota | 27009 | 292 | 3 |
377611 | 377611 | 2020-07-28 | Benton | Minnesota | 27009 | 290 | 3 |
374396 | 374396 | 2020-07-27 | Benton | Minnesota | 27009 | 288 | 3 |
371184 | 371184 | 2020-07-26 | Benton | Minnesota | 27009 | 287 | 3 |
367974 | 367974 | 2020-07-25 | Benton | Minnesota | 27009 | 283 | 3 |
364767 | 364767 | 2020-07-24 | Benton | Minnesota | 27009 | 278 | 3 |
361560 | 361560 | 2020-07-23 | Benton | Minnesota | 27009 | 276 | 3 |
358355 | 358355 | 2020-07-22 | Benton | Minnesota | 27009 | 274 | 3 |
355152 | 355152 | 2020-07-21 | Benton | Minnesota | 27009 | 272 | 3 |
351950 | 351950 | 2020-07-20 | Benton | Minnesota | 27009 | 269 | 3 |
348750 | 348750 | 2020-07-19 | Benton | Minnesota | 27009 | 266 | 3 |
345549 | 345549 | 2020-07-18 | Benton | Minnesota | 27009 | 263 | 3 |
342349 | 342349 | 2020-07-17 | Benton | Minnesota | 27009 | 256 | 3 |
339153 | 339153 | 2020-07-16 | Benton | Minnesota | 27009 | 255 | 3 |
335957 | 335957 | 2020-07-15 | Benton | Minnesota | 27009 | 250 | 3 |
332764 | 332764 | 2020-07-14 | Benton | Minnesota | 27009 | 243 | 3 |
329577 | 329577 | 2020-07-13 | Benton | Minnesota | 27009 | 242 | 3 |
326391 | 326391 | 2020-07-12 | Benton | Minnesota | 27009 | 239 | 3 |
323208 | 323208 | 2020-07-11 | Benton | Minnesota | 27009 | 236 | 3 |
320029 | 320029 | 2020-07-10 | Benton | Minnesota | 27009 | 235 | 3 |
316854 | 316854 | 2020-07-09 | Benton | Minnesota | 27009 | 228 | 3 |
313680 | 313680 | 2020-07-08 | Benton | Minnesota | 27009 | 221 | 3 |
310510 | 310510 | 2020-07-07 | Benton | Minnesota | 27009 | 220 | 3 |
307342 | 307342 | 2020-07-06 | Benton | Minnesota | 27009 | 217 | 3 |
304175 | 304175 | 2020-07-05 | Benton | Minnesota | 27009 | 215 | 3 |
301011 | 301011 | 2020-07-04 | Benton | Minnesota | 27009 | 214 | 3 |
297848 | 297848 | 2020-07-03 | Benton | Minnesota | 27009 | 214 | 3 |
294690 | 294690 | 2020-07-02 | Benton | Minnesota | 27009 | 212 | 3 |
291536 | 291536 | 2020-07-01 | Benton | Minnesota | 27009 | 208 | 3 |
288385 | 288385 | 2020-06-30 | Benton | Minnesota | 27009 | 208 | 3 |
285235 | 285235 | 2020-06-29 | Benton | Minnesota | 27009 | 208 | 3 |
282090 | 282090 | 2020-06-28 | Benton | Minnesota | 27009 | 208 | 3 |
278942 | 278942 | 2020-06-27 | Benton | Minnesota | 27009 | 207 | 3 |
275794 | 275794 | 2020-06-26 | Benton | Minnesota | 27009 | 203 | 3 |
272651 | 272651 | 2020-06-25 | Benton | Minnesota | 27009 | 203 | 3 |
269514 | 269514 | 2020-06-24 | Benton | Minnesota | 27009 | 204 | 3 |
266381 | 266381 | 2020-06-23 | Benton | Minnesota | 27009 | 204 | 3 |
263255 | 263255 | 2020-06-22 | Benton | Minnesota | 27009 | 202 | 3 |
260126 | 260126 | 2020-06-21 | Benton | Minnesota | 27009 | 201 | 3 |
257000 | 257000 | 2020-06-20 | Benton | Minnesota | 27009 | 201 | 3 |
253880 | 253880 | 2020-06-19 | Benton | Minnesota | 27009 | 200 | 3 |
250765 | 250765 | 2020-06-18 | Benton | Minnesota | 27009 | 198 | 3 |
247653 | 247653 | 2020-06-17 | Benton | Minnesota | 27009 | 195 | 3 |
244540 | 244540 | 2020-06-16 | Benton | Minnesota | 27009 | 193 | 3 |
241429 | 241429 | 2020-06-15 | Benton | Minnesota | 27009 | 193 | 3 |
238320 | 238320 | 2020-06-14 | Benton | Minnesota | 27009 | 193 | 3 |
235213 | 235213 | 2020-06-13 | Benton | Minnesota | 27009 | 190 | 3 |
232108 | 232108 | 2020-06-12 | Benton | Minnesota | 27009 | 190 | 3 |
229004 | 229004 | 2020-06-11 | Benton | Minnesota | 27009 | 190 | 3 |
225902 | 225902 | 2020-06-10 | Benton | Minnesota | 27009 | 190 | 3 |
222804 | 222804 | 2020-06-09 | Benton | Minnesota | 27009 | 190 | 3 |
219709 | 219709 | 2020-06-08 | Benton | Minnesota | 27009 | 188 | 3 |
216617 | 216617 | 2020-06-07 | Benton | Minnesota | 27009 | 188 | 3 |
213529 | 213529 | 2020-06-06 | Benton | Minnesota | 27009 | 187 | 3 |
210445 | 210445 | 2020-06-05 | Benton | Minnesota | 27009 | 185 | 3 |
207364 | 207364 | 2020-06-04 | Benton | Minnesota | 27009 | 182 | 3 |
204283 | 204283 | 2020-06-03 | Benton | Minnesota | 27009 | 181 | 3 |
201206 | 201206 | 2020-06-02 | Benton | Minnesota | 27009 | 178 | 3 |
198133 | 198133 | 2020-06-01 | Benton | Minnesota | 27009 | 178 | 3 |
195062 | 195062 | 2020-05-31 | Benton | Minnesota | 27009 | 177 | 3 |
191994 | 191994 | 2020-05-30 | Benton | Minnesota | 27009 | 175 | 3 |
188930 | 188930 | 2020-05-29 | Benton | Minnesota | 27009 | 175 | 3 |
185872 | 185872 | 2020-05-28 | Benton | Minnesota | 27009 | 173 | 3 |
182817 | 182817 | 2020-05-27 | Benton | Minnesota | 27009 | 169 | 2 |
179771 | 179771 | 2020-05-26 | Benton | Minnesota | 27009 | 167 | 2 |
176727 | 176727 | 2020-05-25 | Benton | Minnesota | 27009 | 167 | 2 |
173684 | 173684 | 2020-05-24 | Benton | Minnesota | 27009 | 166 | 2 |
170642 | 170642 | 2020-05-23 | Benton | Minnesota | 27009 | 161 | 2 |
167605 | 167605 | 2020-05-22 | Benton | Minnesota | 27009 | 158 | 2 |
164569 | 164569 | 2020-05-21 | Benton | Minnesota | 27009 | 152 | 2 |
161540 | 161540 | 2020-05-20 | Benton | Minnesota | 27009 | 148 | 2 |
158514 | 158514 | 2020-05-19 | Benton | Minnesota | 27009 | 142 | 2 |
155496 | 155496 | 2020-05-18 | Benton | Minnesota | 27009 | 138 | 2 |
152482 | 152482 | 2020-05-17 | Benton | Minnesota | 27009 | 131 | 2 |
149471 | 149471 | 2020-05-16 | Benton | Minnesota | 27009 | 122 | 2 |
146466 | 146466 | 2020-05-15 | Benton | Minnesota | 27009 | 117 | 2 |
143466 | 143466 | 2020-05-14 | Benton | Minnesota | 27009 | 109 | 2 |
140471 | 140471 | 2020-05-13 | Benton | Minnesota | 27009 | 100 | 2 |
137477 | 137477 | 2020-05-12 | Benton | Minnesota | 27009 | 100 | 2 |
134487 | 134487 | 2020-05-11 | Benton | Minnesota | 27009 | 93 | 2 |
131496 | 131496 | 2020-05-10 | Benton | Minnesota | 27009 | 92 | 2 |
128506 | 128506 | 2020-05-09 | Benton | Minnesota | 27009 | 87 | 2 |
125519 | 125519 | 2020-05-08 | Benton | Minnesota | 27009 | 76 | 2 |
122537 | 122537 | 2020-05-07 | Benton | Minnesota | 27009 | 64 | 1 |
119564 | 119564 | 2020-05-06 | Benton | Minnesota | 27009 | 59 | 1 |
116604 | 116604 | 2020-05-05 | Benton | Minnesota | 27009 | 48 | 1 |
113723 | 113723 | 2020-05-04 | Benton | Minnesota | 27009 | 35 | 1 |
110844 | 110844 | 2020-05-03 | Benton | Minnesota | 27009 | 32 | 1 |
107973 | 107973 | 2020-05-02 | Benton | Minnesota | 27009 | 29 | 1 |
105109 | 105109 | 2020-05-01 | Benton | Minnesota | 27009 | 21 | 1 |
102249 | 102249 | 2020-04-30 | Benton | Minnesota | 27009 | 15 | 0 |
99397 | 99397 | 2020-04-29 | Benton | Minnesota | 27009 | 10 | 0 |
96551 | 96551 | 2020-04-28 | Benton | Minnesota | 27009 | 6 | 0 |
93716 | 93716 | 2020-04-27 | Benton | Minnesota | 27009 | 4 | 0 |
90895 | 90895 | 2020-04-26 | Benton | Minnesota | 27009 | 4 | 0 |
88079 | 88079 | 2020-04-25 | Benton | Minnesota | 27009 | 4 | 0 |
85269 | 85269 | 2020-04-24 | Benton | Minnesota | 27009 | 4 | 0 |
82465 | 82465 | 2020-04-23 | Benton | Minnesota | 27009 | 4 | 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);