ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Turner" 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 |
---|---|---|---|---|---|---|---|
1280066 | 1280066 | 2021-05-02 | Turner | South Dakota | 46125 | 1168 | 56 |
1276819 | 1276819 | 2021-05-01 | Turner | South Dakota | 46125 | 1168 | 56 |
1273572 | 1273572 | 2021-04-30 | Turner | South Dakota | 46125 | 1168 | 56 |
1270325 | 1270325 | 2021-04-29 | Turner | South Dakota | 46125 | 1166 | 56 |
1267078 | 1267078 | 2021-04-28 | Turner | South Dakota | 46125 | 1165 | 56 |
1263831 | 1263831 | 2021-04-27 | Turner | South Dakota | 46125 | 1165 | 56 |
1260584 | 1260584 | 2021-04-26 | Turner | South Dakota | 46125 | 1164 | 56 |
1257337 | 1257337 | 2021-04-25 | Turner | South Dakota | 46125 | 1160 | 56 |
1254090 | 1254090 | 2021-04-24 | Turner | South Dakota | 46125 | 1160 | 56 |
1250843 | 1250843 | 2021-04-23 | Turner | South Dakota | 46125 | 1159 | 56 |
1247596 | 1247596 | 2021-04-22 | Turner | South Dakota | 46125 | 1156 | 56 |
1244349 | 1244349 | 2021-04-21 | Turner | South Dakota | 46125 | 1153 | 56 |
1241102 | 1241102 | 2021-04-20 | Turner | South Dakota | 46125 | 1153 | 56 |
1237855 | 1237855 | 2021-04-19 | Turner | South Dakota | 46125 | 1152 | 56 |
1234608 | 1234608 | 2021-04-18 | Turner | South Dakota | 46125 | 1150 | 56 |
1231360 | 1231360 | 2021-04-17 | Turner | South Dakota | 46125 | 1150 | 56 |
1228112 | 1228112 | 2021-04-16 | Turner | South Dakota | 46125 | 1148 | 56 |
1224864 | 1224864 | 2021-04-15 | Turner | South Dakota | 46125 | 1148 | 56 |
1221617 | 1221617 | 2021-04-14 | Turner | South Dakota | 46125 | 1147 | 56 |
1218369 | 1218369 | 2021-04-13 | Turner | South Dakota | 46125 | 1144 | 55 |
1215121 | 1215121 | 2021-04-12 | Turner | South Dakota | 46125 | 1144 | 55 |
1211874 | 1211874 | 2021-04-11 | Turner | South Dakota | 46125 | 1141 | 55 |
1208625 | 1208625 | 2021-04-10 | Turner | South Dakota | 46125 | 1141 | 55 |
1205377 | 1205377 | 2021-04-09 | Turner | South Dakota | 46125 | 1142 | 55 |
1202129 | 1202129 | 2021-04-08 | Turner | South Dakota | 46125 | 1142 | 54 |
1198880 | 1198880 | 2021-04-07 | Turner | South Dakota | 46125 | 1143 | 54 |
1195631 | 1195631 | 2021-04-06 | Turner | South Dakota | 46125 | 1140 | 54 |
1192383 | 1192383 | 2021-04-05 | Turner | South Dakota | 46125 | 1137 | 54 |
1189134 | 1189134 | 2021-04-04 | Turner | South Dakota | 46125 | 1137 | 54 |
1185887 | 1185887 | 2021-04-03 | Turner | South Dakota | 46125 | 1137 | 54 |
1182640 | 1182640 | 2021-04-02 | Turner | South Dakota | 46125 | 1133 | 54 |
1179393 | 1179393 | 2021-04-01 | Turner | South Dakota | 46125 | 1132 | 54 |
1176146 | 1176146 | 2021-03-31 | Turner | South Dakota | 46125 | 1133 | 53 |
1172899 | 1172899 | 2021-03-30 | Turner | South Dakota | 46125 | 1131 | 53 |
1169652 | 1169652 | 2021-03-29 | Turner | South Dakota | 46125 | 1130 | 53 |
1166404 | 1166404 | 2021-03-28 | Turner | South Dakota | 46125 | 1129 | 53 |
1163156 | 1163156 | 2021-03-27 | Turner | South Dakota | 46125 | 1127 | 53 |
1159907 | 1159907 | 2021-03-26 | Turner | South Dakota | 46125 | 1127 | 53 |
1156660 | 1156660 | 2021-03-25 | Turner | South Dakota | 46125 | 1127 | 53 |
1153413 | 1153413 | 2021-03-24 | Turner | South Dakota | 46125 | 1127 | 53 |
1150166 | 1150166 | 2021-03-23 | Turner | South Dakota | 46125 | 1121 | 53 |
1146919 | 1146919 | 2021-03-22 | Turner | South Dakota | 46125 | 1117 | 53 |
1143672 | 1143672 | 2021-03-21 | Turner | South Dakota | 46125 | 1116 | 53 |
1140425 | 1140425 | 2021-03-20 | Turner | South Dakota | 46125 | 1113 | 53 |
1137179 | 1137179 | 2021-03-19 | Turner | South Dakota | 46125 | 1111 | 53 |
1133933 | 1133933 | 2021-03-18 | Turner | South Dakota | 46125 | 1105 | 53 |
1130685 | 1130685 | 2021-03-17 | Turner | South Dakota | 46125 | 1100 | 53 |
1127438 | 1127438 | 2021-03-16 | Turner | South Dakota | 46125 | 1096 | 53 |
1124192 | 1124192 | 2021-03-15 | Turner | South Dakota | 46125 | 1091 | 53 |
1120946 | 1120946 | 2021-03-14 | Turner | South Dakota | 46125 | 1091 | 53 |
1117699 | 1117699 | 2021-03-13 | Turner | South Dakota | 46125 | 1087 | 53 |
1114452 | 1114452 | 2021-03-12 | Turner | South Dakota | 46125 | 1087 | 53 |
1111206 | 1111206 | 2021-03-11 | Turner | South Dakota | 46125 | 1084 | 53 |
1107960 | 1107960 | 2021-03-10 | Turner | South Dakota | 46125 | 1080 | 53 |
1104714 | 1104714 | 2021-03-09 | Turner | South Dakota | 46125 | 1077 | 53 |
1101468 | 1101468 | 2021-03-08 | Turner | South Dakota | 46125 | 1074 | 53 |
1098222 | 1098222 | 2021-03-07 | Turner | South Dakota | 46125 | 1074 | 53 |
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 |
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);