ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 46125 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 |
---|---|---|---|---|---|---|---|
922958 | 922958 | 2021-01-12 | Turner | South Dakota | 46125 | 1003 | 49 |
919713 | 919713 | 2021-01-11 | Turner | South Dakota | 46125 | 999 | 49 |
916468 | 916468 | 2021-01-10 | Turner | South Dakota | 46125 | 998 | 49 |
913223 | 913223 | 2021-01-09 | Turner | South Dakota | 46125 | 996 | 49 |
909978 | 909978 | 2021-01-08 | Turner | South Dakota | 46125 | 994 | 49 |
906733 | 906733 | 2021-01-07 | Turner | South Dakota | 46125 | 987 | 49 |
903487 | 903487 | 2021-01-06 | Turner | South Dakota | 46125 | 982 | 49 |
900242 | 900242 | 2021-01-05 | Turner | South Dakota | 46125 | 978 | 49 |
896997 | 896997 | 2021-01-04 | Turner | South Dakota | 46125 | 976 | 49 |
893751 | 893751 | 2021-01-03 | Turner | South Dakota | 46125 | 975 | 49 |
890505 | 890505 | 2021-01-02 | Turner | South Dakota | 46125 | 974 | 49 |
887258 | 887258 | 2021-01-01 | Turner | South Dakota | 46125 | 970 | 49 |
884013 | 884013 | 2020-12-31 | Turner | South Dakota | 46125 | 970 | 49 |
880768 | 880768 | 2020-12-30 | Turner | South Dakota | 46125 | 964 | 47 |
877523 | 877523 | 2020-12-29 | Turner | South Dakota | 46125 | 956 | 47 |
874278 | 874278 | 2020-12-28 | Turner | South Dakota | 46125 | 950 | 47 |
871033 | 871033 | 2020-12-27 | Turner | South Dakota | 46125 | 949 | 47 |
867788 | 867788 | 2020-12-26 | Turner | South Dakota | 46125 | 944 | 47 |
864543 | 864543 | 2020-12-25 | Turner | South Dakota | 46125 | 942 | 47 |
861298 | 861298 | 2020-12-24 | Turner | South Dakota | 46125 | 942 | 47 |
858053 | 858053 | 2020-12-23 | Turner | South Dakota | 46125 | 936 | 47 |
854808 | 854808 | 2020-12-22 | Turner | South Dakota | 46125 | 934 | 47 |
851563 | 851563 | 2020-12-21 | Turner | South Dakota | 46125 | 930 | 47 |
848318 | 848318 | 2020-12-20 | Turner | South Dakota | 46125 | 927 | 47 |
845073 | 845073 | 2020-12-19 | Turner | South Dakota | 46125 | 923 | 47 |
841827 | 841827 | 2020-12-18 | Turner | South Dakota | 46125 | 917 | 47 |
838582 | 838582 | 2020-12-17 | Turner | South Dakota | 46125 | 907 | 47 |
835336 | 835336 | 2020-12-16 | Turner | South Dakota | 46125 | 902 | 47 |
832090 | 832090 | 2020-12-15 | Turner | South Dakota | 46125 | 895 | 47 |
828843 | 828843 | 2020-12-14 | Turner | South Dakota | 46125 | 893 | 47 |
825597 | 825597 | 2020-12-13 | Turner | South Dakota | 46125 | 892 | 47 |
822350 | 822350 | 2020-12-12 | Turner | South Dakota | 46125 | 883 | 47 |
819104 | 819104 | 2020-12-11 | Turner | South Dakota | 46125 | 880 | 47 |
815858 | 815858 | 2020-12-10 | Turner | South Dakota | 46125 | 876 | 47 |
812612 | 812612 | 2020-12-09 | Turner | South Dakota | 46125 | 862 | 47 |
809368 | 809368 | 2020-12-08 | Turner | South Dakota | 46125 | 851 | 46 |
806123 | 806123 | 2020-12-07 | Turner | South Dakota | 46125 | 848 | 46 |
802878 | 802878 | 2020-12-06 | Turner | South Dakota | 46125 | 843 | 46 |
799633 | 799633 | 2020-12-05 | Turner | South Dakota | 46125 | 842 | 46 |
796388 | 796388 | 2020-12-04 | Turner | South Dakota | 46125 | 820 | 46 |
793143 | 793143 | 2020-12-03 | Turner | South Dakota | 46125 | 814 | 45 |
789898 | 789898 | 2020-12-02 | Turner | South Dakota | 46125 | 802 | 43 |
786653 | 786653 | 2020-12-01 | Turner | South Dakota | 46125 | 788 | 42 |
783409 | 783409 | 2020-11-30 | Turner | South Dakota | 46125 | 784 | 42 |
780164 | 780164 | 2020-11-29 | Turner | South Dakota | 46125 | 782 | 42 |
776918 | 776918 | 2020-11-28 | Turner | South Dakota | 46125 | 777 | 42 |
773673 | 773673 | 2020-11-27 | Turner | South Dakota | 46125 | 772 | 40 |
770428 | 770428 | 2020-11-26 | Turner | South Dakota | 46125 | 766 | 36 |
767182 | 767182 | 2020-11-25 | Turner | South Dakota | 46125 | 766 | 36 |
763937 | 763937 | 2020-11-24 | Turner | South Dakota | 46125 | 760 | 36 |
760692 | 760692 | 2020-11-23 | Turner | South Dakota | 46125 | 757 | 36 |
757447 | 757447 | 2020-11-22 | Turner | South Dakota | 46125 | 754 | 36 |
754200 | 754200 | 2020-11-21 | Turner | South Dakota | 46125 | 751 | 35 |
750954 | 750954 | 2020-11-20 | Turner | South Dakota | 46125 | 739 | 35 |
747708 | 747708 | 2020-11-19 | Turner | South Dakota | 46125 | 733 | 35 |
744462 | 744462 | 2020-11-18 | Turner | South Dakota | 46125 | 727 | 35 |
741215 | 741215 | 2020-11-17 | Turner | South Dakota | 46125 | 716 | 34 |
737969 | 737969 | 2020-11-16 | Turner | South Dakota | 46125 | 712 | 34 |
734725 | 734725 | 2020-11-15 | Turner | South Dakota | 46125 | 705 | 34 |
731479 | 731479 | 2020-11-14 | Turner | South Dakota | 46125 | 693 | 33 |
728235 | 728235 | 2020-11-13 | Turner | South Dakota | 46125 | 682 | 31 |
724991 | 724991 | 2020-11-12 | Turner | South Dakota | 46125 | 666 | 31 |
721748 | 721748 | 2020-11-11 | Turner | South Dakota | 46125 | 652 | 31 |
718505 | 718505 | 2020-11-10 | Turner | South Dakota | 46125 | 638 | 31 |
715262 | 715262 | 2020-11-09 | Turner | South Dakota | 46125 | 627 | 30 |
712018 | 712018 | 2020-11-08 | Turner | South Dakota | 46125 | 621 | 30 |
708774 | 708774 | 2020-11-07 | Turner | South Dakota | 46125 | 603 | 29 |
705531 | 705531 | 2020-11-06 | Turner | South Dakota | 46125 | 586 | 27 |
702288 | 702288 | 2020-11-05 | Turner | South Dakota | 46125 | 574 | 22 |
699044 | 699044 | 2020-11-04 | Turner | South Dakota | 46125 | 557 | 21 |
695801 | 695801 | 2020-11-03 | Turner | South Dakota | 46125 | 546 | 18 |
692559 | 692559 | 2020-11-02 | Turner | South Dakota | 46125 | 534 | 18 |
689315 | 689315 | 2020-11-01 | Turner | South Dakota | 46125 | 531 | 18 |
686070 | 686070 | 2020-10-31 | Turner | South Dakota | 46125 | 516 | 18 |
682827 | 682827 | 2020-10-30 | Turner | South Dakota | 46125 | 504 | 18 |
679584 | 679584 | 2020-10-29 | Turner | South Dakota | 46125 | 483 | 16 |
676341 | 676341 | 2020-10-28 | Turner | South Dakota | 46125 | 475 | 11 |
673098 | 673098 | 2020-10-27 | Turner | South Dakota | 46125 | 453 | 11 |
669856 | 669856 | 2020-10-26 | Turner | South Dakota | 46125 | 451 | 11 |
666612 | 666612 | 2020-10-25 | Turner | South Dakota | 46125 | 446 | 11 |
663367 | 663367 | 2020-10-24 | Turner | South Dakota | 46125 | 436 | 9 |
660123 | 660123 | 2020-10-23 | Turner | South Dakota | 46125 | 424 | 9 |
656879 | 656879 | 2020-10-22 | Turner | South Dakota | 46125 | 413 | 8 |
653634 | 653634 | 2020-10-21 | Turner | South Dakota | 46125 | 399 | 8 |
650389 | 650389 | 2020-10-20 | Turner | South Dakota | 46125 | 394 | 8 |
647145 | 647145 | 2020-10-19 | Turner | South Dakota | 46125 | 387 | 8 |
643899 | 643899 | 2020-10-18 | Turner | South Dakota | 46125 | 377 | 8 |
640651 | 640651 | 2020-10-17 | Turner | South Dakota | 46125 | 361 | 8 |
637405 | 637405 | 2020-10-16 | Turner | South Dakota | 46125 | 341 | 8 |
634159 | 634159 | 2020-10-15 | Turner | South Dakota | 46125 | 335 | 8 |
630914 | 630914 | 2020-10-14 | Turner | South Dakota | 46125 | 315 | 8 |
627670 | 627670 | 2020-10-13 | Turner | South Dakota | 46125 | 294 | 8 |
624428 | 624428 | 2020-10-12 | Turner | South Dakota | 46125 | 290 | 8 |
621185 | 621185 | 2020-10-11 | Turner | South Dakota | 46125 | 287 | 7 |
617942 | 617942 | 2020-10-10 | Turner | South Dakota | 46125 | 276 | 7 |
614700 | 614700 | 2020-10-09 | Turner | South Dakota | 46125 | 259 | 7 |
611459 | 611459 | 2020-10-08 | Turner | South Dakota | 46125 | 250 | 7 |
608217 | 608217 | 2020-10-07 | Turner | South Dakota | 46125 | 235 | 5 |
604974 | 604974 | 2020-10-06 | Turner | South Dakota | 46125 | 188 | 4 |
601732 | 601732 | 2020-10-05 | Turner | South Dakota | 46125 | 187 | 4 |
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);