ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 27171 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387345 | 387345 | 2020-07-31 | Wright | Minnesota | 27171 | 770 | 5 |
384127 | 384127 | 2020-07-30 | Wright | Minnesota | 27171 | 759 | 5 |
380910 | 380910 | 2020-07-29 | Wright | Minnesota | 27171 | 744 | 5 |
377693 | 377693 | 2020-07-28 | Wright | Minnesota | 27171 | 734 | 5 |
374478 | 374478 | 2020-07-27 | Wright | Minnesota | 27171 | 722 | 5 |
371266 | 371266 | 2020-07-26 | Wright | Minnesota | 27171 | 705 | 5 |
368056 | 368056 | 2020-07-25 | Wright | Minnesota | 27171 | 692 | 5 |
364848 | 364848 | 2020-07-24 | Wright | Minnesota | 27171 | 675 | 4 |
361641 | 361641 | 2020-07-23 | Wright | Minnesota | 27171 | 664 | 4 |
358436 | 358436 | 2020-07-22 | Wright | Minnesota | 27171 | 652 | 4 |
355233 | 355233 | 2020-07-21 | Wright | Minnesota | 27171 | 647 | 4 |
352031 | 352031 | 2020-07-20 | Wright | Minnesota | 27171 | 623 | 4 |
348831 | 348831 | 2020-07-19 | Wright | Minnesota | 27171 | 614 | 4 |
345630 | 345630 | 2020-07-18 | Wright | Minnesota | 27171 | 598 | 4 |
342430 | 342430 | 2020-07-17 | Wright | Minnesota | 27171 | 585 | 4 |
339234 | 339234 | 2020-07-16 | Wright | Minnesota | 27171 | 576 | 4 |
336038 | 336038 | 2020-07-15 | Wright | Minnesota | 27171 | 564 | 5 |
332845 | 332845 | 2020-07-14 | Wright | Minnesota | 27171 | 555 | 5 |
329658 | 329658 | 2020-07-13 | Wright | Minnesota | 27171 | 547 | 5 |
326472 | 326472 | 2020-07-12 | Wright | Minnesota | 27171 | 539 | 5 |
323289 | 323289 | 2020-07-11 | Wright | Minnesota | 27171 | 528 | 5 |
320110 | 320110 | 2020-07-10 | Wright | Minnesota | 27171 | 516 | 5 |
316935 | 316935 | 2020-07-09 | Wright | Minnesota | 27171 | 505 | 5 |
313761 | 313761 | 2020-07-08 | Wright | Minnesota | 27171 | 492 | 5 |
310591 | 310591 | 2020-07-07 | Wright | Minnesota | 27171 | 483 | 5 |
307423 | 307423 | 2020-07-06 | Wright | Minnesota | 27171 | 475 | 5 |
304256 | 304256 | 2020-07-05 | Wright | Minnesota | 27171 | 465 | 5 |
301092 | 301092 | 2020-07-04 | Wright | Minnesota | 27171 | 456 | 5 |
297929 | 297929 | 2020-07-03 | Wright | Minnesota | 27171 | 456 | 5 |
294771 | 294771 | 2020-07-02 | Wright | Minnesota | 27171 | 453 | 5 |
291617 | 291617 | 2020-07-01 | Wright | Minnesota | 27171 | 448 | 5 |
288466 | 288466 | 2020-06-30 | Wright | Minnesota | 27171 | 445 | 5 |
285316 | 285316 | 2020-06-29 | Wright | Minnesota | 27171 | 438 | 4 |
282171 | 282171 | 2020-06-28 | Wright | Minnesota | 27171 | 426 | 4 |
279023 | 279023 | 2020-06-27 | Wright | Minnesota | 27171 | 420 | 4 |
275875 | 275875 | 2020-06-26 | Wright | Minnesota | 27171 | 419 | 4 |
272732 | 272732 | 2020-06-25 | Wright | Minnesota | 27171 | 411 | 3 |
269595 | 269595 | 2020-06-24 | Wright | Minnesota | 27171 | 409 | 3 |
266462 | 266462 | 2020-06-23 | Wright | Minnesota | 27171 | 405 | 3 |
263336 | 263336 | 2020-06-22 | Wright | Minnesota | 27171 | 403 | 2 |
260207 | 260207 | 2020-06-21 | Wright | Minnesota | 27171 | 401 | 2 |
257081 | 257081 | 2020-06-20 | Wright | Minnesota | 27171 | 397 | 2 |
253961 | 253961 | 2020-06-19 | Wright | Minnesota | 27171 | 394 | 2 |
250846 | 250846 | 2020-06-18 | Wright | Minnesota | 27171 | 391 | 2 |
247734 | 247734 | 2020-06-17 | Wright | Minnesota | 27171 | 390 | 2 |
244621 | 244621 | 2020-06-16 | Wright | Minnesota | 27171 | 383 | 2 |
241510 | 241510 | 2020-06-15 | Wright | Minnesota | 27171 | 378 | 2 |
238401 | 238401 | 2020-06-14 | Wright | Minnesota | 27171 | 377 | 2 |
235294 | 235294 | 2020-06-13 | Wright | Minnesota | 27171 | 375 | 2 |
232188 | 232188 | 2020-06-12 | Wright | Minnesota | 27171 | 372 | 2 |
229084 | 229084 | 2020-06-11 | Wright | Minnesota | 27171 | 367 | 2 |
225982 | 225982 | 2020-06-10 | Wright | Minnesota | 27171 | 362 | 2 |
222884 | 222884 | 2020-06-09 | Wright | Minnesota | 27171 | 361 | 2 |
219789 | 219789 | 2020-06-08 | Wright | Minnesota | 27171 | 361 | 2 |
216697 | 216697 | 2020-06-07 | Wright | Minnesota | 27171 | 358 | 2 |
213609 | 213609 | 2020-06-06 | Wright | Minnesota | 27171 | 351 | 2 |
210525 | 210525 | 2020-06-05 | Wright | Minnesota | 27171 | 349 | 2 |
207444 | 207444 | 2020-06-04 | Wright | Minnesota | 27171 | 339 | 2 |
204363 | 204363 | 2020-06-03 | Wright | Minnesota | 27171 | 332 | 2 |
201286 | 201286 | 2020-06-02 | Wright | Minnesota | 27171 | 327 | 2 |
198213 | 198213 | 2020-06-01 | Wright | Minnesota | 27171 | 320 | 2 |
195142 | 195142 | 2020-05-31 | Wright | Minnesota | 27171 | 313 | 1 |
192074 | 192074 | 2020-05-30 | Wright | Minnesota | 27171 | 305 | 1 |
189010 | 189010 | 2020-05-29 | Wright | Minnesota | 27171 | 287 | 1 |
185952 | 185952 | 2020-05-28 | Wright | Minnesota | 27171 | 280 | 1 |
182896 | 182896 | 2020-05-27 | Wright | Minnesota | 27171 | 269 | 1 |
179850 | 179850 | 2020-05-26 | Wright | Minnesota | 27171 | 263 | 1 |
176806 | 176806 | 2020-05-25 | Wright | Minnesota | 27171 | 253 | 1 |
173763 | 173763 | 2020-05-24 | Wright | Minnesota | 27171 | 240 | 1 |
170721 | 170721 | 2020-05-23 | Wright | Minnesota | 27171 | 231 | 1 |
167683 | 167683 | 2020-05-22 | Wright | Minnesota | 27171 | 213 | 2 |
164647 | 164647 | 2020-05-21 | Wright | Minnesota | 27171 | 200 | 1 |
161618 | 161618 | 2020-05-20 | Wright | Minnesota | 27171 | 198 | 1 |
158592 | 158592 | 2020-05-19 | Wright | Minnesota | 27171 | 182 | 1 |
155574 | 155574 | 2020-05-18 | Wright | Minnesota | 27171 | 172 | 1 |
152560 | 152560 | 2020-05-17 | Wright | Minnesota | 27171 | 162 | 1 |
149549 | 149549 | 2020-05-16 | Wright | Minnesota | 27171 | 152 | 1 |
146544 | 146544 | 2020-05-15 | Wright | Minnesota | 27171 | 140 | 1 |
143544 | 143544 | 2020-05-14 | Wright | Minnesota | 27171 | 130 | 1 |
140549 | 140549 | 2020-05-13 | Wright | Minnesota | 27171 | 119 | 1 |
137555 | 137555 | 2020-05-12 | Wright | Minnesota | 27171 | 119 | 1 |
134565 | 134565 | 2020-05-11 | Wright | Minnesota | 27171 | 110 | 1 |
131574 | 131574 | 2020-05-10 | Wright | Minnesota | 27171 | 102 | 1 |
128584 | 128584 | 2020-05-09 | Wright | Minnesota | 27171 | 92 | 1 |
125597 | 125597 | 2020-05-08 | Wright | Minnesota | 27171 | 83 | 1 |
122615 | 122615 | 2020-05-07 | Wright | Minnesota | 27171 | 73 | 1 |
119641 | 119641 | 2020-05-06 | Wright | Minnesota | 27171 | 69 | 1 |
116681 | 116681 | 2020-05-05 | Wright | Minnesota | 27171 | 60 | 1 |
113799 | 113799 | 2020-05-04 | Wright | Minnesota | 27171 | 54 | 1 |
110920 | 110920 | 2020-05-03 | Wright | Minnesota | 27171 | 50 | 1 |
108049 | 108049 | 2020-05-02 | Wright | Minnesota | 27171 | 48 | 1 |
105184 | 105184 | 2020-05-01 | Wright | Minnesota | 27171 | 43 | 1 |
102323 | 102323 | 2020-04-30 | Wright | Minnesota | 27171 | 42 | 1 |
99471 | 99471 | 2020-04-29 | Wright | Minnesota | 27171 | 40 | 1 |
96625 | 96625 | 2020-04-28 | Wright | Minnesota | 27171 | 35 | 1 |
93789 | 93789 | 2020-04-27 | Wright | Minnesota | 27171 | 34 | 1 |
90968 | 90968 | 2020-04-26 | Wright | Minnesota | 27171 | 33 | 1 |
88152 | 88152 | 2020-04-25 | Wright | Minnesota | 27171 | 33 | 1 |
85342 | 85342 | 2020-04-24 | Wright | Minnesota | 27171 | 32 | 1 |
82538 | 82538 | 2020-04-23 | Wright | Minnesota | 27171 | 32 | 1 |
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);