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 |
---|---|---|---|---|---|---|---|
1419650 | 1419650 | 2021-06-14 | Turner | South Dakota | 46125 | 1182 | 57 |
1416405 | 1416405 | 2021-06-13 | Turner | South Dakota | 46125 | 1182 | 57 |
1413159 | 1413159 | 2021-06-12 | Turner | South Dakota | 46125 | 1181 | 57 |
1409914 | 1409914 | 2021-06-11 | Turner | South Dakota | 46125 | 1181 | 57 |
1406669 | 1406669 | 2021-06-10 | Turner | South Dakota | 46125 | 1181 | 57 |
1403423 | 1403423 | 2021-06-09 | Turner | South Dakota | 46125 | 1181 | 57 |
1400178 | 1400178 | 2021-06-08 | Turner | South Dakota | 46125 | 1181 | 57 |
1396933 | 1396933 | 2021-06-07 | Turner | South Dakota | 46125 | 1181 | 57 |
1393686 | 1393686 | 2021-06-06 | Turner | South Dakota | 46125 | 1181 | 57 |
1390441 | 1390441 | 2021-06-05 | Turner | South Dakota | 46125 | 1181 | 57 |
1387196 | 1387196 | 2021-06-04 | Turner | South Dakota | 46125 | 1181 | 57 |
1383951 | 1383951 | 2021-06-03 | Turner | South Dakota | 46125 | 1181 | 57 |
1380705 | 1380705 | 2021-06-02 | Turner | South Dakota | 46125 | 1181 | 57 |
1377460 | 1377460 | 2021-06-01 | Turner | South Dakota | 46125 | 1180 | 57 |
1374214 | 1374214 | 2021-05-31 | Turner | South Dakota | 46125 | 1180 | 57 |
1370969 | 1370969 | 2021-05-30 | Turner | South Dakota | 46125 | 1180 | 57 |
1367723 | 1367723 | 2021-05-29 | Turner | South Dakota | 46125 | 1180 | 57 |
1364477 | 1364477 | 2021-05-28 | Turner | South Dakota | 46125 | 1180 | 57 |
1361231 | 1361231 | 2021-05-27 | Turner | South Dakota | 46125 | 1179 | 56 |
1357985 | 1357985 | 2021-05-26 | Turner | South Dakota | 46125 | 1178 | 56 |
1354739 | 1354739 | 2021-05-25 | Turner | South Dakota | 46125 | 1178 | 56 |
1351493 | 1351493 | 2021-05-24 | Turner | South Dakota | 46125 | 1176 | 56 |
1348247 | 1348247 | 2021-05-23 | Turner | South Dakota | 46125 | 1174 | 56 |
1344999 | 1344999 | 2021-05-22 | Turner | South Dakota | 46125 | 1174 | 56 |
1341751 | 1341751 | 2021-05-21 | Turner | South Dakota | 46125 | 1174 | 56 |
1338503 | 1338503 | 2021-05-20 | Turner | South Dakota | 46125 | 1173 | 56 |
1335256 | 1335256 | 2021-05-19 | Turner | South Dakota | 46125 | 1173 | 56 |
1332009 | 1332009 | 2021-05-18 | Turner | South Dakota | 46125 | 1173 | 56 |
1328762 | 1328762 | 2021-05-17 | Turner | South Dakota | 46125 | 1173 | 56 |
1325516 | 1325516 | 2021-05-16 | Turner | South Dakota | 46125 | 1173 | 56 |
1322270 | 1322270 | 2021-05-15 | Turner | South Dakota | 46125 | 1173 | 56 |
1319024 | 1319024 | 2021-05-14 | Turner | South Dakota | 46125 | 1173 | 56 |
1315776 | 1315776 | 2021-05-13 | Turner | South Dakota | 46125 | 1173 | 56 |
1312530 | 1312530 | 2021-05-12 | Turner | South Dakota | 46125 | 1172 | 56 |
1309283 | 1309283 | 2021-05-11 | Turner | South Dakota | 46125 | 1171 | 56 |
1306037 | 1306037 | 2021-05-10 | Turner | South Dakota | 46125 | 1172 | 56 |
1302791 | 1302791 | 2021-05-09 | Turner | South Dakota | 46125 | 1172 | 56 |
1299544 | 1299544 | 2021-05-08 | Turner | South Dakota | 46125 | 1172 | 56 |
1296297 | 1296297 | 2021-05-07 | Turner | South Dakota | 46125 | 1172 | 56 |
1293051 | 1293051 | 2021-05-06 | Turner | South Dakota | 46125 | 1171 | 56 |
1289805 | 1289805 | 2021-05-05 | Turner | South Dakota | 46125 | 1171 | 56 |
1286559 | 1286559 | 2021-05-04 | Turner | South Dakota | 46125 | 1170 | 56 |
1283313 | 1283313 | 2021-05-03 | Turner | South Dakota | 46125 | 1169 | 56 |
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 |
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);