ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 46057 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 |
---|---|---|---|---|---|---|---|
1195597 | 1195597 | 2021-04-06 | Hamlin | South Dakota | 46057 | 755 | 38 |
1192349 | 1192349 | 2021-04-05 | Hamlin | South Dakota | 46057 | 755 | 38 |
1189100 | 1189100 | 2021-04-04 | Hamlin | South Dakota | 46057 | 754 | 38 |
1185853 | 1185853 | 2021-04-03 | Hamlin | South Dakota | 46057 | 754 | 38 |
1182606 | 1182606 | 2021-04-02 | Hamlin | South Dakota | 46057 | 751 | 38 |
1179359 | 1179359 | 2021-04-01 | Hamlin | South Dakota | 46057 | 747 | 38 |
1176112 | 1176112 | 2021-03-31 | Hamlin | South Dakota | 46057 | 745 | 38 |
1172865 | 1172865 | 2021-03-30 | Hamlin | South Dakota | 46057 | 745 | 38 |
1169618 | 1169618 | 2021-03-29 | Hamlin | South Dakota | 46057 | 745 | 38 |
1166370 | 1166370 | 2021-03-28 | Hamlin | South Dakota | 46057 | 743 | 38 |
1163122 | 1163122 | 2021-03-27 | Hamlin | South Dakota | 46057 | 742 | 38 |
1159873 | 1159873 | 2021-03-26 | Hamlin | South Dakota | 46057 | 740 | 38 |
1156626 | 1156626 | 2021-03-25 | Hamlin | South Dakota | 46057 | 738 | 38 |
1153379 | 1153379 | 2021-03-24 | Hamlin | South Dakota | 46057 | 738 | 38 |
1150132 | 1150132 | 2021-03-23 | Hamlin | South Dakota | 46057 | 737 | 38 |
1146885 | 1146885 | 2021-03-22 | Hamlin | South Dakota | 46057 | 737 | 38 |
1143638 | 1143638 | 2021-03-21 | Hamlin | South Dakota | 46057 | 737 | 38 |
1140391 | 1140391 | 2021-03-20 | Hamlin | South Dakota | 46057 | 737 | 38 |
1137145 | 1137145 | 2021-03-19 | Hamlin | South Dakota | 46057 | 735 | 38 |
1133899 | 1133899 | 2021-03-18 | Hamlin | South Dakota | 46057 | 734 | 38 |
1130651 | 1130651 | 2021-03-17 | Hamlin | South Dakota | 46057 | 734 | 38 |
1127404 | 1127404 | 2021-03-16 | Hamlin | South Dakota | 46057 | 730 | 38 |
1124158 | 1124158 | 2021-03-15 | Hamlin | South Dakota | 46057 | 729 | 38 |
1120912 | 1120912 | 2021-03-14 | Hamlin | South Dakota | 46057 | 729 | 38 |
1117665 | 1117665 | 2021-03-13 | Hamlin | South Dakota | 46057 | 729 | 38 |
1114418 | 1114418 | 2021-03-12 | Hamlin | South Dakota | 46057 | 728 | 38 |
1111172 | 1111172 | 2021-03-11 | Hamlin | South Dakota | 46057 | 726 | 38 |
1107926 | 1107926 | 2021-03-10 | Hamlin | South Dakota | 46057 | 724 | 38 |
1104680 | 1104680 | 2021-03-09 | Hamlin | South Dakota | 46057 | 723 | 38 |
1101434 | 1101434 | 2021-03-08 | Hamlin | South Dakota | 46057 | 722 | 38 |
1098188 | 1098188 | 2021-03-07 | Hamlin | South Dakota | 46057 | 722 | 38 |
1094940 | 1094940 | 2021-03-06 | Hamlin | South Dakota | 46057 | 721 | 38 |
1091694 | 1091694 | 2021-03-05 | Hamlin | South Dakota | 46057 | 721 | 38 |
1088448 | 1088448 | 2021-03-04 | Hamlin | South Dakota | 46057 | 719 | 38 |
1085203 | 1085203 | 2021-03-03 | Hamlin | South Dakota | 46057 | 717 | 38 |
1081957 | 1081957 | 2021-03-02 | Hamlin | South Dakota | 46057 | 714 | 37 |
1078711 | 1078711 | 2021-03-01 | Hamlin | South Dakota | 46057 | 713 | 37 |
1075466 | 1075466 | 2021-02-28 | Hamlin | South Dakota | 46057 | 712 | 37 |
1072220 | 1072220 | 2021-02-27 | Hamlin | South Dakota | 46057 | 709 | 37 |
1068974 | 1068974 | 2021-02-26 | Hamlin | South Dakota | 46057 | 710 | 38 |
1065729 | 1065729 | 2021-02-25 | Hamlin | South Dakota | 46057 | 707 | 38 |
1062484 | 1062484 | 2021-02-24 | Hamlin | South Dakota | 46057 | 701 | 38 |
1059239 | 1059239 | 2021-02-23 | Hamlin | South Dakota | 46057 | 699 | 38 |
1055993 | 1055993 | 2021-02-22 | Hamlin | South Dakota | 46057 | 695 | 38 |
1052747 | 1052747 | 2021-02-21 | Hamlin | South Dakota | 46057 | 695 | 38 |
1049500 | 1049500 | 2021-02-20 | Hamlin | South Dakota | 46057 | 694 | 38 |
1046253 | 1046253 | 2021-02-19 | Hamlin | South Dakota | 46057 | 694 | 38 |
1043008 | 1043008 | 2021-02-18 | Hamlin | South Dakota | 46057 | 689 | 38 |
1039763 | 1039763 | 2021-02-17 | Hamlin | South Dakota | 46057 | 687 | 38 |
1036518 | 1036518 | 2021-02-16 | Hamlin | South Dakota | 46057 | 685 | 38 |
1033273 | 1033273 | 2021-02-15 | Hamlin | South Dakota | 46057 | 684 | 38 |
1030027 | 1030027 | 2021-02-14 | Hamlin | South Dakota | 46057 | 682 | 38 |
1026780 | 1026780 | 2021-02-13 | Hamlin | South Dakota | 46057 | 682 | 38 |
1023535 | 1023535 | 2021-02-12 | Hamlin | South Dakota | 46057 | 679 | 38 |
1020290 | 1020290 | 2021-02-11 | Hamlin | South Dakota | 46057 | 676 | 38 |
1017045 | 1017045 | 2021-02-10 | Hamlin | South Dakota | 46057 | 673 | 38 |
1013800 | 1013800 | 2021-02-09 | Hamlin | South Dakota | 46057 | 673 | 38 |
1010555 | 1010555 | 2021-02-08 | Hamlin | South Dakota | 46057 | 673 | 38 |
1007309 | 1007309 | 2021-02-07 | Hamlin | South Dakota | 46057 | 672 | 38 |
1004063 | 1004063 | 2021-02-06 | Hamlin | South Dakota | 46057 | 672 | 38 |
1000817 | 1000817 | 2021-02-05 | Hamlin | South Dakota | 46057 | 671 | 38 |
997571 | 997571 | 2021-02-04 | Hamlin | South Dakota | 46057 | 671 | 38 |
994325 | 994325 | 2021-02-03 | Hamlin | South Dakota | 46057 | 670 | 38 |
991079 | 991079 | 2021-02-02 | Hamlin | South Dakota | 46057 | 669 | 38 |
987833 | 987833 | 2021-02-01 | Hamlin | South Dakota | 46057 | 669 | 38 |
984586 | 984586 | 2021-01-31 | Hamlin | South Dakota | 46057 | 669 | 38 |
981339 | 981339 | 2021-01-30 | Hamlin | South Dakota | 46057 | 666 | 38 |
978093 | 978093 | 2021-01-29 | Hamlin | South Dakota | 46057 | 665 | 38 |
974848 | 974848 | 2021-01-28 | Hamlin | South Dakota | 46057 | 665 | 38 |
971603 | 971603 | 2021-01-27 | Hamlin | South Dakota | 46057 | 664 | 38 |
968358 | 968358 | 2021-01-26 | Hamlin | South Dakota | 46057 | 664 | 38 |
965114 | 965114 | 2021-01-25 | Hamlin | South Dakota | 46057 | 662 | 38 |
961869 | 961869 | 2021-01-24 | Hamlin | South Dakota | 46057 | 662 | 38 |
958624 | 958624 | 2021-01-23 | Hamlin | South Dakota | 46057 | 662 | 38 |
955378 | 955378 | 2021-01-22 | Hamlin | South Dakota | 46057 | 662 | 38 |
952133 | 952133 | 2021-01-21 | Hamlin | South Dakota | 46057 | 658 | 38 |
948888 | 948888 | 2021-01-20 | Hamlin | South Dakota | 46057 | 656 | 38 |
945642 | 945642 | 2021-01-19 | Hamlin | South Dakota | 46057 | 652 | 38 |
942395 | 942395 | 2021-01-18 | Hamlin | South Dakota | 46057 | 650 | 38 |
939150 | 939150 | 2021-01-17 | Hamlin | South Dakota | 46057 | 650 | 38 |
935905 | 935905 | 2021-01-16 | Hamlin | South Dakota | 46057 | 649 | 38 |
932660 | 932660 | 2021-01-15 | Hamlin | South Dakota | 46057 | 648 | 38 |
929415 | 929415 | 2021-01-14 | Hamlin | South Dakota | 46057 | 644 | 37 |
926170 | 926170 | 2021-01-13 | Hamlin | South Dakota | 46057 | 640 | 37 |
922924 | 922924 | 2021-01-12 | Hamlin | South Dakota | 46057 | 635 | 37 |
919679 | 919679 | 2021-01-11 | Hamlin | South Dakota | 46057 | 631 | 37 |
916434 | 916434 | 2021-01-10 | Hamlin | South Dakota | 46057 | 631 | 37 |
913189 | 913189 | 2021-01-09 | Hamlin | South Dakota | 46057 | 629 | 36 |
909944 | 909944 | 2021-01-08 | Hamlin | South Dakota | 46057 | 627 | 36 |
906699 | 906699 | 2021-01-07 | Hamlin | South Dakota | 46057 | 624 | 36 |
903453 | 903453 | 2021-01-06 | Hamlin | South Dakota | 46057 | 619 | 36 |
900208 | 900208 | 2021-01-05 | Hamlin | South Dakota | 46057 | 614 | 36 |
896963 | 896963 | 2021-01-04 | Hamlin | South Dakota | 46057 | 609 | 36 |
893717 | 893717 | 2021-01-03 | Hamlin | South Dakota | 46057 | 609 | 36 |
890471 | 890471 | 2021-01-02 | Hamlin | South Dakota | 46057 | 608 | 36 |
887224 | 887224 | 2021-01-01 | Hamlin | South Dakota | 46057 | 606 | 34 |
883979 | 883979 | 2020-12-31 | Hamlin | South Dakota | 46057 | 606 | 34 |
880734 | 880734 | 2020-12-30 | Hamlin | South Dakota | 46057 | 603 | 34 |
877489 | 877489 | 2020-12-29 | Hamlin | South Dakota | 46057 | 601 | 32 |
874244 | 874244 | 2020-12-28 | Hamlin | South Dakota | 46057 | 599 | 32 |
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);