ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 46067 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1091699 | 1091699 | 2021-03-05 | Hutchinson | South Dakota | 46067 | 790 | 25 |
1088453 | 1088453 | 2021-03-04 | Hutchinson | South Dakota | 46067 | 790 | 25 |
1085208 | 1085208 | 2021-03-03 | Hutchinson | South Dakota | 46067 | 790 | 25 |
1081962 | 1081962 | 2021-03-02 | Hutchinson | South Dakota | 46067 | 789 | 24 |
1078716 | 1078716 | 2021-03-01 | Hutchinson | South Dakota | 46067 | 788 | 24 |
1075471 | 1075471 | 2021-02-28 | Hutchinson | South Dakota | 46067 | 788 | 24 |
1072225 | 1072225 | 2021-02-27 | Hutchinson | South Dakota | 46067 | 788 | 24 |
1068979 | 1068979 | 2021-02-26 | Hutchinson | South Dakota | 46067 | 787 | 24 |
1065734 | 1065734 | 2021-02-25 | Hutchinson | South Dakota | 46067 | 787 | 24 |
1062489 | 1062489 | 2021-02-24 | Hutchinson | South Dakota | 46067 | 786 | 24 |
1059244 | 1059244 | 2021-02-23 | Hutchinson | South Dakota | 46067 | 784 | 24 |
1055998 | 1055998 | 2021-02-22 | Hutchinson | South Dakota | 46067 | 783 | 24 |
1052752 | 1052752 | 2021-02-21 | Hutchinson | South Dakota | 46067 | 783 | 24 |
1049505 | 1049505 | 2021-02-20 | Hutchinson | South Dakota | 46067 | 783 | 24 |
1046258 | 1046258 | 2021-02-19 | Hutchinson | South Dakota | 46067 | 783 | 24 |
1043013 | 1043013 | 2021-02-18 | Hutchinson | South Dakota | 46067 | 782 | 24 |
1039768 | 1039768 | 2021-02-17 | Hutchinson | South Dakota | 46067 | 780 | 24 |
1036523 | 1036523 | 2021-02-16 | Hutchinson | South Dakota | 46067 | 779 | 24 |
1033278 | 1033278 | 2021-02-15 | Hutchinson | South Dakota | 46067 | 775 | 24 |
1030032 | 1030032 | 2021-02-14 | Hutchinson | South Dakota | 46067 | 775 | 24 |
1026785 | 1026785 | 2021-02-13 | Hutchinson | South Dakota | 46067 | 774 | 24 |
1023540 | 1023540 | 2021-02-12 | Hutchinson | South Dakota | 46067 | 771 | 24 |
1020295 | 1020295 | 2021-02-11 | Hutchinson | South Dakota | 46067 | 770 | 24 |
1017050 | 1017050 | 2021-02-10 | Hutchinson | South Dakota | 46067 | 768 | 24 |
1013805 | 1013805 | 2021-02-09 | Hutchinson | South Dakota | 46067 | 767 | 24 |
1010560 | 1010560 | 2021-02-08 | Hutchinson | South Dakota | 46067 | 767 | 24 |
1007314 | 1007314 | 2021-02-07 | Hutchinson | South Dakota | 46067 | 766 | 24 |
1004068 | 1004068 | 2021-02-06 | Hutchinson | South Dakota | 46067 | 766 | 23 |
1000822 | 1000822 | 2021-02-05 | Hutchinson | South Dakota | 46067 | 763 | 23 |
997576 | 997576 | 2021-02-04 | Hutchinson | South Dakota | 46067 | 760 | 23 |
994330 | 994330 | 2021-02-03 | Hutchinson | South Dakota | 46067 | 759 | 23 |
991084 | 991084 | 2021-02-02 | Hutchinson | South Dakota | 46067 | 758 | 23 |
987838 | 987838 | 2021-02-01 | Hutchinson | South Dakota | 46067 | 757 | 23 |
984591 | 984591 | 2021-01-31 | Hutchinson | South Dakota | 46067 | 758 | 23 |
981344 | 981344 | 2021-01-30 | Hutchinson | South Dakota | 46067 | 757 | 23 |
978098 | 978098 | 2021-01-29 | Hutchinson | South Dakota | 46067 | 755 | 23 |
974853 | 974853 | 2021-01-28 | Hutchinson | South Dakota | 46067 | 755 | 23 |
971608 | 971608 | 2021-01-27 | Hutchinson | South Dakota | 46067 | 752 | 23 |
968363 | 968363 | 2021-01-26 | Hutchinson | South Dakota | 46067 | 750 | 23 |
965119 | 965119 | 2021-01-25 | Hutchinson | South Dakota | 46067 | 748 | 23 |
961874 | 961874 | 2021-01-24 | Hutchinson | South Dakota | 46067 | 748 | 23 |
958629 | 958629 | 2021-01-23 | Hutchinson | South Dakota | 46067 | 748 | 23 |
955383 | 955383 | 2021-01-22 | Hutchinson | South Dakota | 46067 | 746 | 23 |
952138 | 952138 | 2021-01-21 | Hutchinson | South Dakota | 46067 | 742 | 23 |
948893 | 948893 | 2021-01-20 | Hutchinson | South Dakota | 46067 | 738 | 22 |
945647 | 945647 | 2021-01-19 | Hutchinson | South Dakota | 46067 | 736 | 22 |
942400 | 942400 | 2021-01-18 | Hutchinson | South Dakota | 46067 | 735 | 22 |
939155 | 939155 | 2021-01-17 | Hutchinson | South Dakota | 46067 | 735 | 22 |
935910 | 935910 | 2021-01-16 | Hutchinson | South Dakota | 46067 | 731 | 22 |
932665 | 932665 | 2021-01-15 | Hutchinson | South Dakota | 46067 | 729 | 21 |
929420 | 929420 | 2021-01-14 | Hutchinson | South Dakota | 46067 | 728 | 20 |
926175 | 926175 | 2021-01-13 | Hutchinson | South Dakota | 46067 | 723 | 20 |
922929 | 922929 | 2021-01-12 | Hutchinson | South Dakota | 46067 | 721 | 20 |
919684 | 919684 | 2021-01-11 | Hutchinson | South Dakota | 46067 | 719 | 20 |
916439 | 916439 | 2021-01-10 | Hutchinson | South Dakota | 46067 | 719 | 20 |
913194 | 913194 | 2021-01-09 | Hutchinson | South Dakota | 46067 | 716 | 19 |
909949 | 909949 | 2021-01-08 | Hutchinson | South Dakota | 46067 | 711 | 18 |
906704 | 906704 | 2021-01-07 | Hutchinson | South Dakota | 46067 | 709 | 18 |
903458 | 903458 | 2021-01-06 | Hutchinson | South Dakota | 46067 | 707 | 17 |
900213 | 900213 | 2021-01-05 | Hutchinson | South Dakota | 46067 | 704 | 17 |
896968 | 896968 | 2021-01-04 | Hutchinson | South Dakota | 46067 | 703 | 17 |
893722 | 893722 | 2021-01-03 | Hutchinson | South Dakota | 46067 | 703 | 17 |
890476 | 890476 | 2021-01-02 | Hutchinson | South Dakota | 46067 | 701 | 16 |
887229 | 887229 | 2021-01-01 | Hutchinson | South Dakota | 46067 | 700 | 16 |
883984 | 883984 | 2020-12-31 | Hutchinson | South Dakota | 46067 | 700 | 16 |
880739 | 880739 | 2020-12-30 | Hutchinson | South Dakota | 46067 | 697 | 16 |
877494 | 877494 | 2020-12-29 | Hutchinson | South Dakota | 46067 | 696 | 16 |
874249 | 874249 | 2020-12-28 | Hutchinson | South Dakota | 46067 | 694 | 16 |
871004 | 871004 | 2020-12-27 | Hutchinson | South Dakota | 46067 | 692 | 16 |
867759 | 867759 | 2020-12-26 | Hutchinson | South Dakota | 46067 | 690 | 16 |
864514 | 864514 | 2020-12-25 | Hutchinson | South Dakota | 46067 | 688 | 14 |
861269 | 861269 | 2020-12-24 | Hutchinson | South Dakota | 46067 | 688 | 14 |
858024 | 858024 | 2020-12-23 | Hutchinson | South Dakota | 46067 | 683 | 14 |
854779 | 854779 | 2020-12-22 | Hutchinson | South Dakota | 46067 | 682 | 14 |
851534 | 851534 | 2020-12-21 | Hutchinson | South Dakota | 46067 | 678 | 14 |
848289 | 848289 | 2020-12-20 | Hutchinson | South Dakota | 46067 | 676 | 14 |
845044 | 845044 | 2020-12-19 | Hutchinson | South Dakota | 46067 | 674 | 14 |
841798 | 841798 | 2020-12-18 | Hutchinson | South Dakota | 46067 | 673 | 14 |
838553 | 838553 | 2020-12-17 | Hutchinson | South Dakota | 46067 | 669 | 14 |
835307 | 835307 | 2020-12-16 | Hutchinson | South Dakota | 46067 | 666 | 14 |
832061 | 832061 | 2020-12-15 | Hutchinson | South Dakota | 46067 | 657 | 14 |
828814 | 828814 | 2020-12-14 | Hutchinson | South Dakota | 46067 | 650 | 14 |
825568 | 825568 | 2020-12-13 | Hutchinson | South Dakota | 46067 | 649 | 14 |
822321 | 822321 | 2020-12-12 | Hutchinson | South Dakota | 46067 | 642 | 14 |
819075 | 819075 | 2020-12-11 | Hutchinson | South Dakota | 46067 | 638 | 14 |
815829 | 815829 | 2020-12-10 | Hutchinson | South Dakota | 46067 | 632 | 13 |
812583 | 812583 | 2020-12-09 | Hutchinson | South Dakota | 46067 | 628 | 13 |
809339 | 809339 | 2020-12-08 | Hutchinson | South Dakota | 46067 | 620 | 13 |
806094 | 806094 | 2020-12-07 | Hutchinson | South Dakota | 46067 | 619 | 13 |
802849 | 802849 | 2020-12-06 | Hutchinson | South Dakota | 46067 | 613 | 13 |
799604 | 799604 | 2020-12-05 | Hutchinson | South Dakota | 46067 | 608 | 13 |
796359 | 796359 | 2020-12-04 | Hutchinson | South Dakota | 46067 | 604 | 11 |
793114 | 793114 | 2020-12-03 | Hutchinson | South Dakota | 46067 | 600 | 11 |
789869 | 789869 | 2020-12-02 | Hutchinson | South Dakota | 46067 | 586 | 10 |
786624 | 786624 | 2020-12-01 | Hutchinson | South Dakota | 46067 | 576 | 9 |
783380 | 783380 | 2020-11-30 | Hutchinson | South Dakota | 46067 | 573 | 9 |
780135 | 780135 | 2020-11-29 | Hutchinson | South Dakota | 46067 | 568 | 8 |
776889 | 776889 | 2020-11-28 | Hutchinson | South Dakota | 46067 | 562 | 8 |
773644 | 773644 | 2020-11-27 | Hutchinson | South Dakota | 46067 | 551 | 7 |
770399 | 770399 | 2020-11-26 | Hutchinson | South Dakota | 46067 | 541 | 6 |
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);