ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 27009 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921768 | 921768 | 2021-01-12 | Benton | Minnesota | 27009 | 4108 | 84 |
918523 | 918523 | 2021-01-11 | Benton | Minnesota | 27009 | 4097 | 84 |
915278 | 915278 | 2021-01-10 | Benton | Minnesota | 27009 | 4090 | 84 |
912033 | 912033 | 2021-01-09 | Benton | Minnesota | 27009 | 4076 | 84 |
908788 | 908788 | 2021-01-08 | Benton | Minnesota | 27009 | 4052 | 84 |
905542 | 905542 | 2021-01-07 | Benton | Minnesota | 27009 | 4039 | 83 |
902297 | 902297 | 2021-01-06 | Benton | Minnesota | 27009 | 4031 | 83 |
899052 | 899052 | 2021-01-05 | Benton | Minnesota | 27009 | 4004 | 82 |
895807 | 895807 | 2021-01-04 | Benton | Minnesota | 27009 | 3991 | 82 |
892560 | 892560 | 2021-01-03 | Benton | Minnesota | 27009 | 3948 | 82 |
889314 | 889314 | 2021-01-02 | Benton | Minnesota | 27009 | 3923 | 80 |
886068 | 886068 | 2021-01-01 | Benton | Minnesota | 27009 | 3888 | 78 |
882823 | 882823 | 2020-12-31 | Benton | Minnesota | 27009 | 3888 | 78 |
879578 | 879578 | 2020-12-30 | Benton | Minnesota | 27009 | 3874 | 77 |
876333 | 876333 | 2020-12-29 | Benton | Minnesota | 27009 | 3853 | 76 |
873088 | 873088 | 2020-12-28 | Benton | Minnesota | 27009 | 3846 | 76 |
869843 | 869843 | 2020-12-27 | Benton | Minnesota | 27009 | 3836 | 75 |
866598 | 866598 | 2020-12-26 | Benton | Minnesota | 27009 | 3812 | 75 |
863353 | 863353 | 2020-12-25 | Benton | Minnesota | 27009 | 3792 | 72 |
860108 | 860108 | 2020-12-24 | Benton | Minnesota | 27009 | 3792 | 72 |
856863 | 856863 | 2020-12-23 | Benton | Minnesota | 27009 | 3773 | 72 |
853618 | 853618 | 2020-12-22 | Benton | Minnesota | 27009 | 3764 | 72 |
850373 | 850373 | 2020-12-21 | Benton | Minnesota | 27009 | 3749 | 72 |
847128 | 847128 | 2020-12-20 | Benton | Minnesota | 27009 | 3726 | 72 |
843882 | 843882 | 2020-12-19 | Benton | Minnesota | 27009 | 3701 | 70 |
840637 | 840637 | 2020-12-18 | Benton | Minnesota | 27009 | 3678 | 68 |
837392 | 837392 | 2020-12-17 | Benton | Minnesota | 27009 | 3654 | 67 |
834146 | 834146 | 2020-12-16 | Benton | Minnesota | 27009 | 3632 | 66 |
830899 | 830899 | 2020-12-15 | Benton | Minnesota | 27009 | 3617 | 65 |
827653 | 827653 | 2020-12-14 | Benton | Minnesota | 27009 | 3589 | 65 |
824406 | 824406 | 2020-12-13 | Benton | Minnesota | 27009 | 3562 | 65 |
821160 | 821160 | 2020-12-12 | Benton | Minnesota | 27009 | 3540 | 63 |
817914 | 817914 | 2020-12-11 | Benton | Minnesota | 27009 | 3516 | 62 |
814668 | 814668 | 2020-12-10 | Benton | Minnesota | 27009 | 3496 | 61 |
811423 | 811423 | 2020-12-09 | Benton | Minnesota | 27009 | 3507 | 60 |
808178 | 808178 | 2020-12-08 | Benton | Minnesota | 27009 | 3457 | 58 |
804933 | 804933 | 2020-12-07 | Benton | Minnesota | 27009 | 3426 | 57 |
801688 | 801688 | 2020-12-06 | Benton | Minnesota | 27009 | 3370 | 57 |
798443 | 798443 | 2020-12-05 | Benton | Minnesota | 27009 | 3319 | 56 |
795198 | 795198 | 2020-12-04 | Benton | Minnesota | 27009 | 3263 | 56 |
791953 | 791953 | 2020-12-03 | Benton | Minnesota | 27009 | 3227 | 53 |
788708 | 788708 | 2020-12-02 | Benton | Minnesota | 27009 | 3172 | 53 |
785463 | 785463 | 2020-12-01 | Benton | Minnesota | 27009 | 3088 | 51 |
782219 | 782219 | 2020-11-30 | Benton | Minnesota | 27009 | 3057 | 51 |
778973 | 778973 | 2020-11-29 | Benton | Minnesota | 27009 | 2994 | 51 |
775728 | 775728 | 2020-11-28 | Benton | Minnesota | 27009 | 2933 | 48 |
772483 | 772483 | 2020-11-27 | Benton | Minnesota | 27009 | 2858 | 47 |
769238 | 769238 | 2020-11-26 | Benton | Minnesota | 27009 | 2786 | 42 |
765992 | 765992 | 2020-11-25 | Benton | Minnesota | 27009 | 2786 | 42 |
762747 | 762747 | 2020-11-24 | Benton | Minnesota | 27009 | 2693 | 40 |
759502 | 759502 | 2020-11-23 | Benton | Minnesota | 27009 | 2619 | 40 |
756255 | 756255 | 2020-11-22 | Benton | Minnesota | 27009 | 2563 | 38 |
753009 | 753009 | 2020-11-21 | Benton | Minnesota | 27009 | 2511 | 37 |
749763 | 749763 | 2020-11-20 | Benton | Minnesota | 27009 | 2449 | 36 |
746517 | 746517 | 2020-11-19 | Benton | Minnesota | 27009 | 2370 | 36 |
743270 | 743270 | 2020-11-18 | Benton | Minnesota | 27009 | 2225 | 35 |
740023 | 740023 | 2020-11-17 | Benton | Minnesota | 27009 | 2187 | 32 |
736779 | 736779 | 2020-11-16 | Benton | Minnesota | 27009 | 2098 | 32 |
733533 | 733533 | 2020-11-15 | Benton | Minnesota | 27009 | 2023 | 32 |
730288 | 730288 | 2020-11-14 | Benton | Minnesota | 27009 | 1987 | 28 |
727045 | 727045 | 2020-11-13 | Benton | Minnesota | 27009 | 1907 | 28 |
723802 | 723802 | 2020-11-12 | Benton | Minnesota | 27009 | 1805 | 26 |
720559 | 720559 | 2020-11-11 | Benton | Minnesota | 27009 | 1696 | 23 |
717316 | 717316 | 2020-11-10 | Benton | Minnesota | 27009 | 1658 | 22 |
714072 | 714072 | 2020-11-09 | Benton | Minnesota | 27009 | 1605 | 22 |
710828 | 710828 | 2020-11-08 | Benton | Minnesota | 27009 | 1540 | 21 |
707584 | 707584 | 2020-11-07 | Benton | Minnesota | 27009 | 1473 | 19 |
704341 | 704341 | 2020-11-06 | Benton | Minnesota | 27009 | 1416 | 17 |
701099 | 701099 | 2020-11-05 | Benton | Minnesota | 27009 | 1327 | 16 |
697855 | 697855 | 2020-11-04 | Benton | Minnesota | 27009 | 1274 | 16 |
694612 | 694612 | 2020-11-03 | Benton | Minnesota | 27009 | 1211 | 15 |
691370 | 691370 | 2020-11-02 | Benton | Minnesota | 27009 | 1160 | 15 |
688125 | 688125 | 2020-11-01 | Benton | Minnesota | 27009 | 1134 | 14 |
684881 | 684881 | 2020-10-31 | Benton | Minnesota | 27009 | 1121 | 12 |
681638 | 681638 | 2020-10-30 | Benton | Minnesota | 27009 | 1090 | 12 |
678394 | 678394 | 2020-10-29 | Benton | Minnesota | 27009 | 1033 | 11 |
675152 | 675152 | 2020-10-28 | Benton | Minnesota | 27009 | 1009 | 9 |
671909 | 671909 | 2020-10-27 | Benton | Minnesota | 27009 | 976 | 9 |
668667 | 668667 | 2020-10-26 | Benton | Minnesota | 27009 | 950 | 9 |
665423 | 665423 | 2020-10-25 | Benton | Minnesota | 27009 | 940 | 9 |
662178 | 662178 | 2020-10-24 | Benton | Minnesota | 27009 | 923 | 8 |
658934 | 658934 | 2020-10-23 | Benton | Minnesota | 27009 | 910 | 7 |
655689 | 655689 | 2020-10-22 | Benton | Minnesota | 27009 | 882 | 7 |
652444 | 652444 | 2020-10-21 | Benton | Minnesota | 27009 | 862 | 5 |
649199 | 649199 | 2020-10-20 | Benton | Minnesota | 27009 | 857 | 5 |
645955 | 645955 | 2020-10-19 | Benton | Minnesota | 27009 | 841 | 5 |
642708 | 642708 | 2020-10-18 | Benton | Minnesota | 27009 | 826 | 5 |
639461 | 639461 | 2020-10-17 | Benton | Minnesota | 27009 | 815 | 4 |
636215 | 636215 | 2020-10-16 | Benton | Minnesota | 27009 | 790 | 4 |
632969 | 632969 | 2020-10-15 | Benton | Minnesota | 27009 | 755 | 4 |
629724 | 629724 | 2020-10-14 | Benton | Minnesota | 27009 | 740 | 4 |
626480 | 626480 | 2020-10-13 | Benton | Minnesota | 27009 | 715 | 4 |
623238 | 623238 | 2020-10-12 | Benton | Minnesota | 27009 | 704 | 4 |
619995 | 619995 | 2020-10-11 | Benton | Minnesota | 27009 | 691 | 4 |
616753 | 616753 | 2020-10-10 | Benton | Minnesota | 27009 | 673 | 4 |
613512 | 613512 | 2020-10-09 | Benton | Minnesota | 27009 | 667 | 4 |
610270 | 610270 | 2020-10-08 | Benton | Minnesota | 27009 | 655 | 4 |
607028 | 607028 | 2020-10-07 | Benton | Minnesota | 27009 | 640 | 4 |
603785 | 603785 | 2020-10-06 | Benton | Minnesota | 27009 | 627 | 3 |
600543 | 600543 | 2020-10-05 | Benton | Minnesota | 27009 | 618 | 3 |
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);