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 |
---|---|---|---|---|---|---|---|
1094974 | 1094974 | 2021-03-06 | Turner | South Dakota | 46125 | 1071 | 53 |
1091728 | 1091728 | 2021-03-05 | Turner | South Dakota | 46125 | 1071 | 53 |
1088482 | 1088482 | 2021-03-04 | Turner | South Dakota | 46125 | 1071 | 53 |
1085237 | 1085237 | 2021-03-03 | Turner | South Dakota | 46125 | 1068 | 53 |
1081991 | 1081991 | 2021-03-02 | Turner | South Dakota | 46125 | 1067 | 53 |
1078745 | 1078745 | 2021-03-01 | Turner | South Dakota | 46125 | 1067 | 53 |
1075500 | 1075500 | 2021-02-28 | Turner | South Dakota | 46125 | 1067 | 53 |
1072254 | 1072254 | 2021-02-27 | Turner | South Dakota | 46125 | 1066 | 53 |
1069008 | 1069008 | 2021-02-26 | Turner | South Dakota | 46125 | 1065 | 53 |
1065763 | 1065763 | 2021-02-25 | Turner | South Dakota | 46125 | 1065 | 53 |
1062518 | 1062518 | 2021-02-24 | Turner | South Dakota | 46125 | 1064 | 53 |
1059273 | 1059273 | 2021-02-23 | Turner | South Dakota | 46125 | 1063 | 53 |
1056027 | 1056027 | 2021-02-22 | Turner | South Dakota | 46125 | 1060 | 53 |
1052781 | 1052781 | 2021-02-21 | Turner | South Dakota | 46125 | 1059 | 53 |
1049534 | 1049534 | 2021-02-20 | Turner | South Dakota | 46125 | 1059 | 53 |
1046287 | 1046287 | 2021-02-19 | Turner | South Dakota | 46125 | 1057 | 52 |
1043042 | 1043042 | 2021-02-18 | Turner | South Dakota | 46125 | 1055 | 51 |
1039797 | 1039797 | 2021-02-17 | Turner | South Dakota | 46125 | 1053 | 51 |
1036552 | 1036552 | 2021-02-16 | Turner | South Dakota | 46125 | 1053 | 51 |
1033307 | 1033307 | 2021-02-15 | Turner | South Dakota | 46125 | 1053 | 51 |
1030061 | 1030061 | 2021-02-14 | Turner | South Dakota | 46125 | 1051 | 51 |
1026814 | 1026814 | 2021-02-13 | Turner | South Dakota | 46125 | 1051 | 51 |
1023569 | 1023569 | 2021-02-12 | Turner | South Dakota | 46125 | 1050 | 50 |
1020324 | 1020324 | 2021-02-11 | Turner | South Dakota | 46125 | 1049 | 50 |
1017079 | 1017079 | 2021-02-10 | Turner | South Dakota | 46125 | 1046 | 50 |
1013834 | 1013834 | 2021-02-09 | Turner | South Dakota | 46125 | 1046 | 50 |
1010589 | 1010589 | 2021-02-08 | Turner | South Dakota | 46125 | 1046 | 50 |
1007343 | 1007343 | 2021-02-07 | Turner | South Dakota | 46125 | 1046 | 50 |
1004097 | 1004097 | 2021-02-06 | Turner | South Dakota | 46125 | 1044 | 50 |
1000851 | 1000851 | 2021-02-05 | Turner | South Dakota | 46125 | 1044 | 50 |
997605 | 997605 | 2021-02-04 | Turner | South Dakota | 46125 | 1044 | 50 |
994359 | 994359 | 2021-02-03 | Turner | South Dakota | 46125 | 1044 | 50 |
991113 | 991113 | 2021-02-02 | Turner | South Dakota | 46125 | 1042 | 50 |
987867 | 987867 | 2021-02-01 | Turner | South Dakota | 46125 | 1042 | 50 |
984620 | 984620 | 2021-01-31 | Turner | South Dakota | 46125 | 1042 | 50 |
981373 | 981373 | 2021-01-30 | Turner | South Dakota | 46125 | 1042 | 50 |
978127 | 978127 | 2021-01-29 | Turner | South Dakota | 46125 | 1042 | 50 |
974882 | 974882 | 2021-01-28 | Turner | South Dakota | 46125 | 1042 | 50 |
971637 | 971637 | 2021-01-27 | Turner | South Dakota | 46125 | 1041 | 50 |
968392 | 968392 | 2021-01-26 | Turner | South Dakota | 46125 | 1038 | 49 |
965148 | 965148 | 2021-01-25 | Turner | South Dakota | 46125 | 1036 | 49 |
961903 | 961903 | 2021-01-24 | Turner | South Dakota | 46125 | 1035 | 49 |
958658 | 958658 | 2021-01-23 | Turner | South Dakota | 46125 | 1034 | 49 |
955412 | 955412 | 2021-01-22 | Turner | South Dakota | 46125 | 1029 | 49 |
952167 | 952167 | 2021-01-21 | Turner | South Dakota | 46125 | 1028 | 49 |
948922 | 948922 | 2021-01-20 | Turner | South Dakota | 46125 | 1024 | 49 |
945676 | 945676 | 2021-01-19 | Turner | South Dakota | 46125 | 1023 | 49 |
942429 | 942429 | 2021-01-18 | Turner | South Dakota | 46125 | 1023 | 49 |
939184 | 939184 | 2021-01-17 | Turner | South Dakota | 46125 | 1022 | 49 |
935939 | 935939 | 2021-01-16 | Turner | South Dakota | 46125 | 1020 | 49 |
932694 | 932694 | 2021-01-15 | Turner | South Dakota | 46125 | 1019 | 49 |
929449 | 929449 | 2021-01-14 | Turner | South Dakota | 46125 | 1012 | 49 |
926204 | 926204 | 2021-01-13 | Turner | South Dakota | 46125 | 1009 | 49 |
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 |
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);