ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
755 rows where county = "Marshall" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921807 | 921807 | 2021-01-12 | Marshall | Minnesota | 27089 | 696 | 15 |
918562 | 918562 | 2021-01-11 | Marshall | Minnesota | 27089 | 696 | 15 |
915317 | 915317 | 2021-01-10 | Marshall | Minnesota | 27089 | 695 | 15 |
912072 | 912072 | 2021-01-09 | Marshall | Minnesota | 27089 | 695 | 15 |
908827 | 908827 | 2021-01-08 | Marshall | Minnesota | 27089 | 692 | 15 |
905581 | 905581 | 2021-01-07 | Marshall | Minnesota | 27089 | 689 | 15 |
902336 | 902336 | 2021-01-06 | Marshall | Minnesota | 27089 | 687 | 15 |
899091 | 899091 | 2021-01-05 | Marshall | Minnesota | 27089 | 683 | 13 |
895846 | 895846 | 2021-01-04 | Marshall | Minnesota | 27089 | 684 | 13 |
892599 | 892599 | 2021-01-03 | Marshall | Minnesota | 27089 | 680 | 13 |
889353 | 889353 | 2021-01-02 | Marshall | Minnesota | 27089 | 677 | 12 |
886107 | 886107 | 2021-01-01 | Marshall | Minnesota | 27089 | 675 | 12 |
882862 | 882862 | 2020-12-31 | Marshall | Minnesota | 27089 | 675 | 12 |
879617 | 879617 | 2020-12-30 | Marshall | Minnesota | 27089 | 671 | 12 |
876372 | 876372 | 2020-12-29 | Marshall | Minnesota | 27089 | 671 | 12 |
873127 | 873127 | 2020-12-28 | Marshall | Minnesota | 27089 | 671 | 12 |
869882 | 869882 | 2020-12-27 | Marshall | Minnesota | 27089 | 670 | 12 |
866637 | 866637 | 2020-12-26 | Marshall | Minnesota | 27089 | 669 | 12 |
863392 | 863392 | 2020-12-25 | Marshall | Minnesota | 27089 | 667 | 12 |
860147 | 860147 | 2020-12-24 | Marshall | Minnesota | 27089 | 667 | 12 |
856902 | 856902 | 2020-12-23 | Marshall | Minnesota | 27089 | 665 | 12 |
853657 | 853657 | 2020-12-22 | Marshall | Minnesota | 27089 | 665 | 11 |
850412 | 850412 | 2020-12-21 | Marshall | Minnesota | 27089 | 664 | 11 |
847167 | 847167 | 2020-12-20 | Marshall | Minnesota | 27089 | 659 | 11 |
843921 | 843921 | 2020-12-19 | Marshall | Minnesota | 27089 | 655 | 11 |
840676 | 840676 | 2020-12-18 | Marshall | Minnesota | 27089 | 652 | 11 |
837431 | 837431 | 2020-12-17 | Marshall | Minnesota | 27089 | 647 | 11 |
834185 | 834185 | 2020-12-16 | Marshall | Minnesota | 27089 | 641 | 11 |
830938 | 830938 | 2020-12-15 | Marshall | Minnesota | 27089 | 636 | 11 |
827692 | 827692 | 2020-12-14 | Marshall | Minnesota | 27089 | 630 | 11 |
824445 | 824445 | 2020-12-13 | Marshall | Minnesota | 27089 | 622 | 11 |
821199 | 821199 | 2020-12-12 | Marshall | Minnesota | 27089 | 615 | 11 |
817953 | 817953 | 2020-12-11 | Marshall | Minnesota | 27089 | 607 | 11 |
814707 | 814707 | 2020-12-10 | Marshall | Minnesota | 27089 | 595 | 11 |
811462 | 811462 | 2020-12-09 | Marshall | Minnesota | 27089 | 585 | 11 |
808217 | 808217 | 2020-12-08 | Marshall | Minnesota | 27089 | 578 | 11 |
804972 | 804972 | 2020-12-07 | Marshall | Minnesota | 27089 | 576 | 11 |
801727 | 801727 | 2020-12-06 | Marshall | Minnesota | 27089 | 568 | 10 |
798482 | 798482 | 2020-12-05 | Marshall | Minnesota | 27089 | 560 | 10 |
795237 | 795237 | 2020-12-04 | Marshall | Minnesota | 27089 | 550 | 10 |
791992 | 791992 | 2020-12-03 | Marshall | Minnesota | 27089 | 545 | 9 |
788747 | 788747 | 2020-12-02 | Marshall | Minnesota | 27089 | 528 | 9 |
785502 | 785502 | 2020-12-01 | Marshall | Minnesota | 27089 | 514 | 9 |
782258 | 782258 | 2020-11-30 | Marshall | Minnesota | 27089 | 505 | 9 |
779012 | 779012 | 2020-11-29 | Marshall | Minnesota | 27089 | 497 | 9 |
775767 | 775767 | 2020-11-28 | Marshall | Minnesota | 27089 | 475 | 8 |
772522 | 772522 | 2020-11-27 | Marshall | Minnesota | 27089 | 450 | 8 |
769277 | 769277 | 2020-11-26 | Marshall | Minnesota | 27089 | 443 | 8 |
766031 | 766031 | 2020-11-25 | Marshall | Minnesota | 27089 | 443 | 8 |
762786 | 762786 | 2020-11-24 | Marshall | Minnesota | 27089 | 437 | 7 |
759541 | 759541 | 2020-11-23 | Marshall | Minnesota | 27089 | 427 | 7 |
756294 | 756294 | 2020-11-22 | Marshall | Minnesota | 27089 | 404 | 7 |
753048 | 753048 | 2020-11-21 | Marshall | Minnesota | 27089 | 388 | 7 |
749802 | 749802 | 2020-11-20 | Marshall | Minnesota | 27089 | 375 | 7 |
746556 | 746556 | 2020-11-19 | Marshall | Minnesota | 27089 | 360 | 7 |
743309 | 743309 | 2020-11-18 | Marshall | Minnesota | 27089 | 352 | 7 |
740062 | 740062 | 2020-11-17 | Marshall | Minnesota | 27089 | 350 | 6 |
736818 | 736818 | 2020-11-16 | Marshall | Minnesota | 27089 | 326 | 6 |
733572 | 733572 | 2020-11-15 | Marshall | Minnesota | 27089 | 310 | 6 |
730327 | 730327 | 2020-11-14 | Marshall | Minnesota | 27089 | 308 | 6 |
727084 | 727084 | 2020-11-13 | Marshall | Minnesota | 27089 | 295 | 6 |
723841 | 723841 | 2020-11-12 | Marshall | Minnesota | 27089 | 281 | 5 |
720598 | 720598 | 2020-11-11 | Marshall | Minnesota | 27089 | 278 | 5 |
717355 | 717355 | 2020-11-10 | Marshall | Minnesota | 27089 | 269 | 4 |
714111 | 714111 | 2020-11-09 | Marshall | Minnesota | 27089 | 264 | 4 |
710867 | 710867 | 2020-11-08 | Marshall | Minnesota | 27089 | 259 | 4 |
707623 | 707623 | 2020-11-07 | Marshall | Minnesota | 27089 | 244 | 3 |
704380 | 704380 | 2020-11-06 | Marshall | Minnesota | 27089 | 233 | 3 |
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 |
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);