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 |
---|---|---|---|---|---|---|---|
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 |
870999 | 870999 | 2020-12-27 | Hamlin | South Dakota | 46057 | 597 | 32 |
867754 | 867754 | 2020-12-26 | Hamlin | South Dakota | 46057 | 593 | 32 |
864509 | 864509 | 2020-12-25 | Hamlin | South Dakota | 46057 | 589 | 32 |
861264 | 861264 | 2020-12-24 | Hamlin | South Dakota | 46057 | 589 | 32 |
858019 | 858019 | 2020-12-23 | Hamlin | South Dakota | 46057 | 583 | 32 |
854774 | 854774 | 2020-12-22 | Hamlin | South Dakota | 46057 | 580 | 32 |
851529 | 851529 | 2020-12-21 | Hamlin | South Dakota | 46057 | 577 | 32 |
848284 | 848284 | 2020-12-20 | Hamlin | South Dakota | 46057 | 575 | 32 |
845039 | 845039 | 2020-12-19 | Hamlin | South Dakota | 46057 | 574 | 32 |
841793 | 841793 | 2020-12-18 | Hamlin | South Dakota | 46057 | 570 | 32 |
838548 | 838548 | 2020-12-17 | Hamlin | South Dakota | 46057 | 567 | 30 |
835302 | 835302 | 2020-12-16 | Hamlin | South Dakota | 46057 | 564 | 29 |
832056 | 832056 | 2020-12-15 | Hamlin | South Dakota | 46057 | 559 | 28 |
828809 | 828809 | 2020-12-14 | Hamlin | South Dakota | 46057 | 553 | 28 |
825563 | 825563 | 2020-12-13 | Hamlin | South Dakota | 46057 | 552 | 28 |
822316 | 822316 | 2020-12-12 | Hamlin | South Dakota | 46057 | 550 | 27 |
819070 | 819070 | 2020-12-11 | Hamlin | South Dakota | 46057 | 547 | 27 |
815824 | 815824 | 2020-12-10 | Hamlin | South Dakota | 46057 | 541 | 26 |
812578 | 812578 | 2020-12-09 | Hamlin | South Dakota | 46057 | 533 | 21 |
809334 | 809334 | 2020-12-08 | Hamlin | South Dakota | 46057 | 530 | 19 |
806089 | 806089 | 2020-12-07 | Hamlin | South Dakota | 46057 | 527 | 19 |
802844 | 802844 | 2020-12-06 | Hamlin | South Dakota | 46057 | 525 | 19 |
799599 | 799599 | 2020-12-05 | Hamlin | South Dakota | 46057 | 518 | 17 |
796354 | 796354 | 2020-12-04 | Hamlin | South Dakota | 46057 | 510 | 17 |
793109 | 793109 | 2020-12-03 | Hamlin | South Dakota | 46057 | 503 | 17 |
789864 | 789864 | 2020-12-02 | Hamlin | South Dakota | 46057 | 491 | 9 |
786619 | 786619 | 2020-12-01 | Hamlin | South Dakota | 46057 | 484 | 4 |
783375 | 783375 | 2020-11-30 | Hamlin | South Dakota | 46057 | 481 | 4 |
780130 | 780130 | 2020-11-29 | Hamlin | South Dakota | 46057 | 479 | 4 |
776884 | 776884 | 2020-11-28 | Hamlin | South Dakota | 46057 | 476 | 4 |
773639 | 773639 | 2020-11-27 | Hamlin | South Dakota | 46057 | 458 | 3 |
770394 | 770394 | 2020-11-26 | Hamlin | South Dakota | 46057 | 446 | 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);