ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 27091 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921808 | 921808 | 2021-01-12 | Martin | Minnesota | 27091 | 1664 | 26 |
918563 | 918563 | 2021-01-11 | Martin | Minnesota | 27091 | 1657 | 26 |
915318 | 915318 | 2021-01-10 | Martin | Minnesota | 27091 | 1652 | 26 |
912073 | 912073 | 2021-01-09 | Martin | Minnesota | 27091 | 1643 | 26 |
908828 | 908828 | 2021-01-08 | Martin | Minnesota | 27091 | 1631 | 26 |
905582 | 905582 | 2021-01-07 | Martin | Minnesota | 27091 | 1620 | 25 |
902337 | 902337 | 2021-01-06 | Martin | Minnesota | 27091 | 1617 | 25 |
899092 | 899092 | 2021-01-05 | Martin | Minnesota | 27091 | 1603 | 25 |
895847 | 895847 | 2021-01-04 | Martin | Minnesota | 27091 | 1594 | 25 |
892600 | 892600 | 2021-01-03 | Martin | Minnesota | 27091 | 1585 | 25 |
889354 | 889354 | 2021-01-02 | Martin | Minnesota | 27091 | 1581 | 25 |
886108 | 886108 | 2021-01-01 | Martin | Minnesota | 27091 | 1570 | 25 |
882863 | 882863 | 2020-12-31 | Martin | Minnesota | 27091 | 1570 | 25 |
879618 | 879618 | 2020-12-30 | Martin | Minnesota | 27091 | 1564 | 25 |
876373 | 876373 | 2020-12-29 | Martin | Minnesota | 27091 | 1558 | 25 |
873128 | 873128 | 2020-12-28 | Martin | Minnesota | 27091 | 1551 | 25 |
869883 | 869883 | 2020-12-27 | Martin | Minnesota | 27091 | 1547 | 25 |
866638 | 866638 | 2020-12-26 | Martin | Minnesota | 27091 | 1544 | 25 |
863393 | 863393 | 2020-12-25 | Martin | Minnesota | 27091 | 1542 | 24 |
860148 | 860148 | 2020-12-24 | Martin | Minnesota | 27091 | 1542 | 24 |
856903 | 856903 | 2020-12-23 | Martin | Minnesota | 27091 | 1535 | 24 |
853658 | 853658 | 2020-12-22 | Martin | Minnesota | 27091 | 1522 | 23 |
850413 | 850413 | 2020-12-21 | Martin | Minnesota | 27091 | 1518 | 23 |
847168 | 847168 | 2020-12-20 | Martin | Minnesota | 27091 | 1506 | 23 |
843922 | 843922 | 2020-12-19 | Martin | Minnesota | 27091 | 1494 | 23 |
840677 | 840677 | 2020-12-18 | Martin | Minnesota | 27091 | 1479 | 23 |
837432 | 837432 | 2020-12-17 | Martin | Minnesota | 27091 | 1465 | 23 |
834186 | 834186 | 2020-12-16 | Martin | Minnesota | 27091 | 1447 | 23 |
830939 | 830939 | 2020-12-15 | Martin | Minnesota | 27091 | 1432 | 23 |
827693 | 827693 | 2020-12-14 | Martin | Minnesota | 27091 | 1429 | 23 |
824446 | 824446 | 2020-12-13 | Martin | Minnesota | 27091 | 1422 | 23 |
821200 | 821200 | 2020-12-12 | Martin | Minnesota | 27091 | 1406 | 23 |
817954 | 817954 | 2020-12-11 | Martin | Minnesota | 27091 | 1402 | 23 |
814708 | 814708 | 2020-12-10 | Martin | Minnesota | 27091 | 1383 | 23 |
811463 | 811463 | 2020-12-09 | Martin | Minnesota | 27091 | 1365 | 23 |
808218 | 808218 | 2020-12-08 | Martin | Minnesota | 27091 | 1354 | 23 |
804973 | 804973 | 2020-12-07 | Martin | Minnesota | 27091 | 1338 | 23 |
801728 | 801728 | 2020-12-06 | Martin | Minnesota | 27091 | 1318 | 23 |
798483 | 798483 | 2020-12-05 | Martin | Minnesota | 27091 | 1301 | 22 |
795238 | 795238 | 2020-12-04 | Martin | Minnesota | 27091 | 1273 | 22 |
791993 | 791993 | 2020-12-03 | Martin | Minnesota | 27091 | 1247 | 21 |
788748 | 788748 | 2020-12-02 | Martin | Minnesota | 27091 | 1212 | 21 |
785503 | 785503 | 2020-12-01 | Martin | Minnesota | 27091 | 1194 | 20 |
782259 | 782259 | 2020-11-30 | Martin | Minnesota | 27091 | 1174 | 20 |
779013 | 779013 | 2020-11-29 | Martin | Minnesota | 27091 | 1133 | 20 |
775768 | 775768 | 2020-11-28 | Martin | Minnesota | 27091 | 1112 | 20 |
772523 | 772523 | 2020-11-27 | Martin | Minnesota | 27091 | 1055 | 20 |
769278 | 769278 | 2020-11-26 | Martin | Minnesota | 27091 | 1019 | 20 |
766032 | 766032 | 2020-11-25 | Martin | Minnesota | 27091 | 1019 | 20 |
762787 | 762787 | 2020-11-24 | Martin | Minnesota | 27091 | 1006 | 20 |
759542 | 759542 | 2020-11-23 | Martin | Minnesota | 27091 | 982 | 20 |
756295 | 756295 | 2020-11-22 | Martin | Minnesota | 27091 | 970 | 20 |
753049 | 753049 | 2020-11-21 | Martin | Minnesota | 27091 | 935 | 20 |
749803 | 749803 | 2020-11-20 | Martin | Minnesota | 27091 | 913 | 20 |
746557 | 746557 | 2020-11-19 | Martin | Minnesota | 27091 | 890 | 20 |
743310 | 743310 | 2020-11-18 | Martin | Minnesota | 27091 | 865 | 19 |
740063 | 740063 | 2020-11-17 | Martin | Minnesota | 27091 | 852 | 19 |
736819 | 736819 | 2020-11-16 | Martin | Minnesota | 27091 | 846 | 19 |
733573 | 733573 | 2020-11-15 | Martin | Minnesota | 27091 | 817 | 19 |
730328 | 730328 | 2020-11-14 | Martin | Minnesota | 27091 | 775 | 19 |
727085 | 727085 | 2020-11-13 | Martin | Minnesota | 27091 | 760 | 19 |
723842 | 723842 | 2020-11-12 | Martin | Minnesota | 27091 | 749 | 19 |
720599 | 720599 | 2020-11-11 | Martin | Minnesota | 27091 | 735 | 19 |
717356 | 717356 | 2020-11-10 | Martin | Minnesota | 27091 | 724 | 18 |
714112 | 714112 | 2020-11-09 | Martin | Minnesota | 27091 | 715 | 18 |
710868 | 710868 | 2020-11-08 | Martin | Minnesota | 27091 | 711 | 18 |
707624 | 707624 | 2020-11-07 | Martin | Minnesota | 27091 | 701 | 18 |
704381 | 704381 | 2020-11-06 | Martin | Minnesota | 27091 | 688 | 18 |
701139 | 701139 | 2020-11-05 | Martin | Minnesota | 27091 | 673 | 18 |
697895 | 697895 | 2020-11-04 | Martin | Minnesota | 27091 | 670 | 18 |
694652 | 694652 | 2020-11-03 | Martin | Minnesota | 27091 | 659 | 18 |
691410 | 691410 | 2020-11-02 | Martin | Minnesota | 27091 | 655 | 18 |
688165 | 688165 | 2020-11-01 | Martin | Minnesota | 27091 | 651 | 18 |
684921 | 684921 | 2020-10-31 | Martin | Minnesota | 27091 | 646 | 18 |
681678 | 681678 | 2020-10-30 | Martin | Minnesota | 27091 | 637 | 18 |
678434 | 678434 | 2020-10-29 | Martin | Minnesota | 27091 | 626 | 18 |
675192 | 675192 | 2020-10-28 | Martin | Minnesota | 27091 | 619 | 18 |
671949 | 671949 | 2020-10-27 | Martin | Minnesota | 27091 | 615 | 18 |
668707 | 668707 | 2020-10-26 | Martin | Minnesota | 27091 | 613 | 17 |
665463 | 665463 | 2020-10-25 | Martin | Minnesota | 27091 | 613 | 17 |
662218 | 662218 | 2020-10-24 | Martin | Minnesota | 27091 | 611 | 17 |
658974 | 658974 | 2020-10-23 | Martin | Minnesota | 27091 | 606 | 16 |
655729 | 655729 | 2020-10-22 | Martin | Minnesota | 27091 | 602 | 16 |
652484 | 652484 | 2020-10-21 | Martin | Minnesota | 27091 | 599 | 16 |
649239 | 649239 | 2020-10-20 | Martin | Minnesota | 27091 | 589 | 16 |
645995 | 645995 | 2020-10-19 | Martin | Minnesota | 27091 | 586 | 16 |
642748 | 642748 | 2020-10-18 | Martin | Minnesota | 27091 | 584 | 16 |
639501 | 639501 | 2020-10-17 | Martin | Minnesota | 27091 | 579 | 16 |
636255 | 636255 | 2020-10-16 | Martin | Minnesota | 27091 | 567 | 16 |
633009 | 633009 | 2020-10-15 | Martin | Minnesota | 27091 | 558 | 16 |
629764 | 629764 | 2020-10-14 | Martin | Minnesota | 27091 | 558 | 16 |
626520 | 626520 | 2020-10-13 | Martin | Minnesota | 27091 | 551 | 16 |
623278 | 623278 | 2020-10-12 | Martin | Minnesota | 27091 | 548 | 14 |
620035 | 620035 | 2020-10-11 | Martin | Minnesota | 27091 | 546 | 14 |
616793 | 616793 | 2020-10-10 | Martin | Minnesota | 27091 | 543 | 14 |
613552 | 613552 | 2020-10-09 | Martin | Minnesota | 27091 | 535 | 14 |
610310 | 610310 | 2020-10-08 | Martin | Minnesota | 27091 | 531 | 13 |
607068 | 607068 | 2020-10-07 | Martin | Minnesota | 27091 | 525 | 13 |
603825 | 603825 | 2020-10-06 | Martin | Minnesota | 27091 | 517 | 12 |
600583 | 600583 | 2020-10-05 | Martin | Minnesota | 27091 | 510 | 12 |
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);