ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 46087 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 |
---|---|---|---|---|---|---|---|
1094956 | 1094956 | 2021-03-06 | McCook | South Dakota | 46087 | 747 | 24 |
1091710 | 1091710 | 2021-03-05 | McCook | South Dakota | 46087 | 747 | 24 |
1088464 | 1088464 | 2021-03-04 | McCook | South Dakota | 46087 | 745 | 24 |
1085219 | 1085219 | 2021-03-03 | McCook | South Dakota | 46087 | 745 | 24 |
1081973 | 1081973 | 2021-03-02 | McCook | South Dakota | 46087 | 744 | 24 |
1078727 | 1078727 | 2021-03-01 | McCook | South Dakota | 46087 | 741 | 24 |
1075482 | 1075482 | 2021-02-28 | McCook | South Dakota | 46087 | 740 | 24 |
1072236 | 1072236 | 2021-02-27 | McCook | South Dakota | 46087 | 740 | 24 |
1068990 | 1068990 | 2021-02-26 | McCook | South Dakota | 46087 | 739 | 24 |
1065745 | 1065745 | 2021-02-25 | McCook | South Dakota | 46087 | 739 | 24 |
1062500 | 1062500 | 2021-02-24 | McCook | South Dakota | 46087 | 739 | 24 |
1059255 | 1059255 | 2021-02-23 | McCook | South Dakota | 46087 | 738 | 24 |
1056009 | 1056009 | 2021-02-22 | McCook | South Dakota | 46087 | 738 | 24 |
1052763 | 1052763 | 2021-02-21 | McCook | South Dakota | 46087 | 738 | 24 |
1049516 | 1049516 | 2021-02-20 | McCook | South Dakota | 46087 | 738 | 24 |
1046269 | 1046269 | 2021-02-19 | McCook | South Dakota | 46087 | 736 | 24 |
1043024 | 1043024 | 2021-02-18 | McCook | South Dakota | 46087 | 734 | 24 |
1039779 | 1039779 | 2021-02-17 | McCook | South Dakota | 46087 | 732 | 24 |
1036534 | 1036534 | 2021-02-16 | McCook | South Dakota | 46087 | 732 | 24 |
1033289 | 1033289 | 2021-02-15 | McCook | South Dakota | 46087 | 731 | 24 |
1030043 | 1030043 | 2021-02-14 | McCook | South Dakota | 46087 | 731 | 24 |
1026796 | 1026796 | 2021-02-13 | McCook | South Dakota | 46087 | 730 | 24 |
1023551 | 1023551 | 2021-02-12 | McCook | South Dakota | 46087 | 730 | 24 |
1020306 | 1020306 | 2021-02-11 | McCook | South Dakota | 46087 | 728 | 24 |
1017061 | 1017061 | 2021-02-10 | McCook | South Dakota | 46087 | 727 | 24 |
1013816 | 1013816 | 2021-02-09 | McCook | South Dakota | 46087 | 726 | 24 |
1010571 | 1010571 | 2021-02-08 | McCook | South Dakota | 46087 | 725 | 24 |
1007325 | 1007325 | 2021-02-07 | McCook | South Dakota | 46087 | 724 | 24 |
1004079 | 1004079 | 2021-02-06 | McCook | South Dakota | 46087 | 723 | 24 |
1000833 | 1000833 | 2021-02-05 | McCook | South Dakota | 46087 | 723 | 24 |
997587 | 997587 | 2021-02-04 | McCook | South Dakota | 46087 | 721 | 24 |
994341 | 994341 | 2021-02-03 | McCook | South Dakota | 46087 | 719 | 24 |
991095 | 991095 | 2021-02-02 | McCook | South Dakota | 46087 | 718 | 23 |
987849 | 987849 | 2021-02-01 | McCook | South Dakota | 46087 | 718 | 23 |
984602 | 984602 | 2021-01-31 | McCook | South Dakota | 46087 | 718 | 23 |
981355 | 981355 | 2021-01-30 | McCook | South Dakota | 46087 | 716 | 23 |
978109 | 978109 | 2021-01-29 | McCook | South Dakota | 46087 | 716 | 23 |
974864 | 974864 | 2021-01-28 | McCook | South Dakota | 46087 | 715 | 23 |
971619 | 971619 | 2021-01-27 | McCook | South Dakota | 46087 | 713 | 22 |
968374 | 968374 | 2021-01-26 | McCook | South Dakota | 46087 | 713 | 22 |
965130 | 965130 | 2021-01-25 | McCook | South Dakota | 46087 | 713 | 22 |
961885 | 961885 | 2021-01-24 | McCook | South Dakota | 46087 | 713 | 22 |
958640 | 958640 | 2021-01-23 | McCook | South Dakota | 46087 | 714 | 22 |
955394 | 955394 | 2021-01-22 | McCook | South Dakota | 46087 | 714 | 22 |
952149 | 952149 | 2021-01-21 | McCook | South Dakota | 46087 | 713 | 22 |
948904 | 948904 | 2021-01-20 | McCook | South Dakota | 46087 | 711 | 22 |
945658 | 945658 | 2021-01-19 | McCook | South Dakota | 46087 | 710 | 22 |
942411 | 942411 | 2021-01-18 | McCook | South Dakota | 46087 | 709 | 22 |
939166 | 939166 | 2021-01-17 | McCook | South Dakota | 46087 | 709 | 22 |
935921 | 935921 | 2021-01-16 | McCook | South Dakota | 46087 | 709 | 22 |
932676 | 932676 | 2021-01-15 | McCook | South Dakota | 46087 | 709 | 22 |
929431 | 929431 | 2021-01-14 | McCook | South Dakota | 46087 | 709 | 22 |
926186 | 926186 | 2021-01-13 | McCook | South Dakota | 46087 | 709 | 22 |
922940 | 922940 | 2021-01-12 | McCook | South Dakota | 46087 | 707 | 22 |
919695 | 919695 | 2021-01-11 | McCook | South Dakota | 46087 | 705 | 22 |
916450 | 916450 | 2021-01-10 | McCook | South Dakota | 46087 | 704 | 22 |
913205 | 913205 | 2021-01-09 | McCook | South Dakota | 46087 | 704 | 22 |
909960 | 909960 | 2021-01-08 | McCook | South Dakota | 46087 | 699 | 22 |
906715 | 906715 | 2021-01-07 | McCook | South Dakota | 46087 | 697 | 22 |
903469 | 903469 | 2021-01-06 | McCook | South Dakota | 46087 | 695 | 22 |
900224 | 900224 | 2021-01-05 | McCook | South Dakota | 46087 | 689 | 22 |
896979 | 896979 | 2021-01-04 | McCook | South Dakota | 46087 | 688 | 22 |
893733 | 893733 | 2021-01-03 | McCook | South Dakota | 46087 | 688 | 22 |
890487 | 890487 | 2021-01-02 | McCook | South Dakota | 46087 | 683 | 22 |
887240 | 887240 | 2021-01-01 | McCook | South Dakota | 46087 | 683 | 22 |
883995 | 883995 | 2020-12-31 | McCook | South Dakota | 46087 | 683 | 22 |
880750 | 880750 | 2020-12-30 | McCook | South Dakota | 46087 | 683 | 21 |
877505 | 877505 | 2020-12-29 | McCook | South Dakota | 46087 | 673 | 21 |
874260 | 874260 | 2020-12-28 | McCook | South Dakota | 46087 | 672 | 21 |
871015 | 871015 | 2020-12-27 | McCook | South Dakota | 46087 | 670 | 21 |
867770 | 867770 | 2020-12-26 | McCook | South Dakota | 46087 | 669 | 21 |
864525 | 864525 | 2020-12-25 | McCook | South Dakota | 46087 | 665 | 21 |
861280 | 861280 | 2020-12-24 | McCook | South Dakota | 46087 | 665 | 21 |
858035 | 858035 | 2020-12-23 | McCook | South Dakota | 46087 | 661 | 21 |
854790 | 854790 | 2020-12-22 | McCook | South Dakota | 46087 | 658 | 21 |
851545 | 851545 | 2020-12-21 | McCook | South Dakota | 46087 | 653 | 21 |
848300 | 848300 | 2020-12-20 | McCook | South Dakota | 46087 | 650 | 21 |
845055 | 845055 | 2020-12-19 | McCook | South Dakota | 46087 | 650 | 21 |
841809 | 841809 | 2020-12-18 | McCook | South Dakota | 46087 | 646 | 21 |
838564 | 838564 | 2020-12-17 | McCook | South Dakota | 46087 | 644 | 21 |
835318 | 835318 | 2020-12-16 | McCook | South Dakota | 46087 | 637 | 21 |
832072 | 832072 | 2020-12-15 | McCook | South Dakota | 46087 | 635 | 21 |
828825 | 828825 | 2020-12-14 | McCook | South Dakota | 46087 | 634 | 21 |
825579 | 825579 | 2020-12-13 | McCook | South Dakota | 46087 | 634 | 21 |
822332 | 822332 | 2020-12-12 | McCook | South Dakota | 46087 | 630 | 21 |
819086 | 819086 | 2020-12-11 | McCook | South Dakota | 46087 | 627 | 20 |
815840 | 815840 | 2020-12-10 | McCook | South Dakota | 46087 | 621 | 20 |
812594 | 812594 | 2020-12-09 | McCook | South Dakota | 46087 | 618 | 19 |
809350 | 809350 | 2020-12-08 | McCook | South Dakota | 46087 | 617 | 19 |
806105 | 806105 | 2020-12-07 | McCook | South Dakota | 46087 | 614 | 19 |
802860 | 802860 | 2020-12-06 | McCook | South Dakota | 46087 | 614 | 19 |
799615 | 799615 | 2020-12-05 | McCook | South Dakota | 46087 | 611 | 19 |
796370 | 796370 | 2020-12-04 | McCook | South Dakota | 46087 | 606 | 17 |
793125 | 793125 | 2020-12-03 | McCook | South Dakota | 46087 | 607 | 17 |
789880 | 789880 | 2020-12-02 | McCook | South Dakota | 46087 | 604 | 17 |
786635 | 786635 | 2020-12-01 | McCook | South Dakota | 46087 | 597 | 15 |
783391 | 783391 | 2020-11-30 | McCook | South Dakota | 46087 | 597 | 15 |
780146 | 780146 | 2020-11-29 | McCook | South Dakota | 46087 | 596 | 15 |
776900 | 776900 | 2020-11-28 | McCook | South Dakota | 46087 | 589 | 15 |
773655 | 773655 | 2020-11-27 | McCook | South Dakota | 46087 | 583 | 15 |
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);