ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where deaths = 1, fips = 27089 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
701138 | 701138 | 2020-11-05 | Marshall | Minnesota | 27089 | 224 | 1 |
697894 | 697894 | 2020-11-04 | Marshall | Minnesota | 27089 | 213 | 1 |
694651 | 694651 | 2020-11-03 | Marshall | Minnesota | 27089 | 204 | 1 |
691409 | 691409 | 2020-11-02 | Marshall | Minnesota | 27089 | 193 | 1 |
688164 | 688164 | 2020-11-01 | Marshall | Minnesota | 27089 | 187 | 1 |
684920 | 684920 | 2020-10-31 | Marshall | Minnesota | 27089 | 177 | 1 |
681677 | 681677 | 2020-10-30 | Marshall | Minnesota | 27089 | 161 | 1 |
678433 | 678433 | 2020-10-29 | Marshall | Minnesota | 27089 | 151 | 1 |
675191 | 675191 | 2020-10-28 | Marshall | Minnesota | 27089 | 137 | 1 |
671948 | 671948 | 2020-10-27 | Marshall | Minnesota | 27089 | 131 | 1 |
668706 | 668706 | 2020-10-26 | Marshall | Minnesota | 27089 | 126 | 1 |
665462 | 665462 | 2020-10-25 | Marshall | Minnesota | 27089 | 121 | 1 |
662217 | 662217 | 2020-10-24 | Marshall | Minnesota | 27089 | 110 | 1 |
658973 | 658973 | 2020-10-23 | Marshall | Minnesota | 27089 | 103 | 1 |
655728 | 655728 | 2020-10-22 | Marshall | Minnesota | 27089 | 97 | 1 |
652483 | 652483 | 2020-10-21 | Marshall | Minnesota | 27089 | 90 | 1 |
649238 | 649238 | 2020-10-20 | Marshall | Minnesota | 27089 | 88 | 1 |
645994 | 645994 | 2020-10-19 | Marshall | Minnesota | 27089 | 87 | 1 |
642747 | 642747 | 2020-10-18 | Marshall | Minnesota | 27089 | 86 | 1 |
639500 | 639500 | 2020-10-17 | Marshall | Minnesota | 27089 | 82 | 1 |
636254 | 636254 | 2020-10-16 | Marshall | Minnesota | 27089 | 76 | 1 |
633008 | 633008 | 2020-10-15 | Marshall | Minnesota | 27089 | 74 | 1 |
629763 | 629763 | 2020-10-14 | Marshall | Minnesota | 27089 | 73 | 1 |
626519 | 626519 | 2020-10-13 | Marshall | Minnesota | 27089 | 70 | 1 |
623277 | 623277 | 2020-10-12 | Marshall | Minnesota | 27089 | 70 | 1 |
620034 | 620034 | 2020-10-11 | Marshall | Minnesota | 27089 | 70 | 1 |
616792 | 616792 | 2020-10-10 | Marshall | Minnesota | 27089 | 68 | 1 |
613551 | 613551 | 2020-10-09 | Marshall | Minnesota | 27089 | 63 | 1 |
610309 | 610309 | 2020-10-08 | Marshall | Minnesota | 27089 | 62 | 1 |
607067 | 607067 | 2020-10-07 | Marshall | Minnesota | 27089 | 61 | 1 |
603824 | 603824 | 2020-10-06 | Marshall | Minnesota | 27089 | 60 | 1 |
600582 | 600582 | 2020-10-05 | Marshall | Minnesota | 27089 | 58 | 1 |
597339 | 597339 | 2020-10-04 | Marshall | Minnesota | 27089 | 58 | 1 |
594098 | 594098 | 2020-10-03 | Marshall | Minnesota | 27089 | 57 | 1 |
590857 | 590857 | 2020-10-02 | Marshall | Minnesota | 27089 | 55 | 1 |
587616 | 587616 | 2020-10-01 | Marshall | Minnesota | 27089 | 54 | 1 |
584376 | 584376 | 2020-09-30 | Marshall | Minnesota | 27089 | 53 | 1 |
581135 | 581135 | 2020-09-29 | Marshall | Minnesota | 27089 | 53 | 1 |
577894 | 577894 | 2020-09-28 | Marshall | Minnesota | 27089 | 53 | 1 |
574653 | 574653 | 2020-09-27 | Marshall | Minnesota | 27089 | 53 | 1 |
571410 | 571410 | 2020-09-26 | Marshall | Minnesota | 27089 | 52 | 1 |
568168 | 568168 | 2020-09-25 | Marshall | Minnesota | 27089 | 51 | 1 |
564928 | 564928 | 2020-09-24 | Marshall | Minnesota | 27089 | 50 | 1 |
561688 | 561688 | 2020-09-23 | Marshall | Minnesota | 27089 | 50 | 1 |
558451 | 558451 | 2020-09-22 | Marshall | Minnesota | 27089 | 50 | 1 |
555214 | 555214 | 2020-09-21 | Marshall | Minnesota | 27089 | 50 | 1 |
551976 | 551976 | 2020-09-20 | Marshall | Minnesota | 27089 | 49 | 1 |
548737 | 548737 | 2020-09-19 | Marshall | Minnesota | 27089 | 48 | 1 |
545499 | 545499 | 2020-09-18 | Marshall | Minnesota | 27089 | 48 | 1 |
542262 | 542262 | 2020-09-17 | Marshall | Minnesota | 27089 | 48 | 1 |
539026 | 539026 | 2020-09-16 | Marshall | Minnesota | 27089 | 48 | 1 |
535789 | 535789 | 2020-09-15 | Marshall | Minnesota | 27089 | 49 | 1 |
532554 | 532554 | 2020-09-14 | Marshall | Minnesota | 27089 | 49 | 1 |
529318 | 529318 | 2020-09-13 | Marshall | Minnesota | 27089 | 49 | 1 |
526082 | 526082 | 2020-09-12 | Marshall | Minnesota | 27089 | 46 | 1 |
522846 | 522846 | 2020-09-11 | Marshall | Minnesota | 27089 | 46 | 1 |
519609 | 519609 | 2020-09-10 | Marshall | Minnesota | 27089 | 46 | 1 |
516374 | 516374 | 2020-09-09 | Marshall | Minnesota | 27089 | 44 | 1 |
513140 | 513140 | 2020-09-08 | Marshall | Minnesota | 27089 | 44 | 1 |
509908 | 509908 | 2020-09-07 | Marshall | Minnesota | 27089 | 44 | 1 |
506675 | 506675 | 2020-09-06 | Marshall | Minnesota | 27089 | 44 | 1 |
503442 | 503442 | 2020-09-05 | Marshall | Minnesota | 27089 | 44 | 1 |
500208 | 500208 | 2020-09-04 | Marshall | Minnesota | 27089 | 44 | 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);