ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
86 rows where deaths = 91 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- South Dakota · 86 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2199471 | 2199471 | 2022-02-09 | Lincoln | South Dakota | 46083 | 15329 | 91 |
2196217 | 2196217 | 2022-02-08 | Lincoln | South Dakota | 46083 | 15301 | 91 |
2192963 | 2192963 | 2022-02-07 | Lincoln | South Dakota | 46083 | 15271 | 91 |
2189709 | 2189709 | 2022-02-06 | Lincoln | South Dakota | 46083 | 15260 | 91 |
2186456 | 2186456 | 2022-02-05 | Lincoln | South Dakota | 46083 | 15260 | 91 |
2183204 | 2183204 | 2022-02-04 | Lincoln | South Dakota | 46083 | 15260 | 91 |
2179952 | 2179952 | 2022-02-03 | Lincoln | South Dakota | 46083 | 15240 | 91 |
2134372 | 2134372 | 2022-01-20 | Codington | South Dakota | 46029 | 7395 | 91 |
2131120 | 2131120 | 2022-01-19 | Codington | South Dakota | 46029 | 7286 | 91 |
2127866 | 2127866 | 2022-01-18 | Codington | South Dakota | 46029 | 7091 | 91 |
2124614 | 2124614 | 2022-01-17 | Codington | South Dakota | 46029 | 7041 | 91 |
2121362 | 2121362 | 2022-01-16 | Codington | South Dakota | 46029 | 7041 | 91 |
2118110 | 2118110 | 2022-01-15 | Codington | South Dakota | 46029 | 7041 | 91 |
2114859 | 2114859 | 2022-01-14 | Codington | South Dakota | 46029 | 7041 | 91 |
2111607 | 2111607 | 2022-01-13 | Codington | South Dakota | 46029 | 6953 | 91 |
2108355 | 2108355 | 2022-01-12 | Codington | South Dakota | 46029 | 6880 | 91 |
2105104 | 2105104 | 2022-01-11 | Codington | South Dakota | 46029 | 6818 | 91 |
2101853 | 2101853 | 2022-01-10 | Codington | South Dakota | 46029 | 6699 | 91 |
2098602 | 2098602 | 2022-01-09 | Codington | South Dakota | 46029 | 6669 | 91 |
2095350 | 2095350 | 2022-01-08 | Codington | South Dakota | 46029 | 6669 | 91 |
2092098 | 2092098 | 2022-01-07 | Codington | South Dakota | 46029 | 6669 | 91 |
2088846 | 2088846 | 2022-01-06 | Codington | South Dakota | 46029 | 6624 | 91 |
2085595 | 2085595 | 2022-01-05 | Codington | South Dakota | 46029 | 6596 | 91 |
2082343 | 2082343 | 2022-01-04 | Codington | South Dakota | 46029 | 6556 | 91 |
2079091 | 2079091 | 2022-01-03 | Codington | South Dakota | 46029 | 6463 | 91 |
2075840 | 2075840 | 2022-01-02 | Codington | South Dakota | 46029 | 6450 | 91 |
2072589 | 2072589 | 2022-01-01 | Codington | South Dakota | 46029 | 6450 | 91 |
2069338 | 2069338 | 2021-12-31 | Codington | South Dakota | 46029 | 6450 | 91 |
2066087 | 2066087 | 2021-12-30 | Codington | South Dakota | 46029 | 6450 | 91 |
2062837 | 2062837 | 2021-12-29 | Codington | South Dakota | 46029 | 6434 | 91 |
2059587 | 2059587 | 2021-12-28 | Codington | South Dakota | 46029 | 6418 | 91 |
2056338 | 2056338 | 2021-12-27 | Codington | South Dakota | 46029 | 6375 | 91 |
2053089 | 2053089 | 2021-12-26 | Codington | South Dakota | 46029 | 6363 | 91 |
2049839 | 2049839 | 2021-12-25 | Codington | South Dakota | 46029 | 6363 | 91 |
2046589 | 2046589 | 2021-12-24 | Codington | South Dakota | 46029 | 6363 | 91 |
2043339 | 2043339 | 2021-12-23 | Codington | South Dakota | 46029 | 6363 | 91 |
2040090 | 2040090 | 2021-12-22 | Codington | South Dakota | 46029 | 6356 | 91 |
2036840 | 2036840 | 2021-12-21 | Codington | South Dakota | 46029 | 6350 | 91 |
1292995 | 1292995 | 2021-05-06 | Brown | South Dakota | 46013 | 5547 | 91 |
1289749 | 1289749 | 2021-05-05 | Brown | South Dakota | 46013 | 5542 | 91 |
1286503 | 1286503 | 2021-05-04 | Brown | South Dakota | 46013 | 5533 | 91 |
1283257 | 1283257 | 2021-05-03 | Brown | South Dakota | 46013 | 5517 | 91 |
1280010 | 1280010 | 2021-05-02 | Brown | South Dakota | 46013 | 5509 | 91 |
1276763 | 1276763 | 2021-05-01 | Brown | South Dakota | 46013 | 5509 | 91 |
1273516 | 1273516 | 2021-04-30 | Brown | South Dakota | 46013 | 5509 | 91 |
1270269 | 1270269 | 2021-04-29 | Brown | South Dakota | 46013 | 5499 | 91 |
1267022 | 1267022 | 2021-04-28 | Brown | South Dakota | 46013 | 5494 | 91 |
1263775 | 1263775 | 2021-04-27 | Brown | South Dakota | 46013 | 5475 | 91 |
1260528 | 1260528 | 2021-04-26 | Brown | South Dakota | 46013 | 5467 | 91 |
1257281 | 1257281 | 2021-04-25 | Brown | South Dakota | 46013 | 5463 | 91 |
1254034 | 1254034 | 2021-04-24 | Brown | South Dakota | 46013 | 5463 | 91 |
1250787 | 1250787 | 2021-04-23 | Brown | South Dakota | 46013 | 5459 | 91 |
1247540 | 1247540 | 2021-04-22 | Brown | South Dakota | 46013 | 5450 | 91 |
1244293 | 1244293 | 2021-04-21 | Brown | South Dakota | 46013 | 5445 | 91 |
1241046 | 1241046 | 2021-04-20 | Brown | South Dakota | 46013 | 5442 | 91 |
1237799 | 1237799 | 2021-04-19 | Brown | South Dakota | 46013 | 5433 | 91 |
1234552 | 1234552 | 2021-04-18 | Brown | South Dakota | 46013 | 5429 | 91 |
1231304 | 1231304 | 2021-04-17 | Brown | South Dakota | 46013 | 5429 | 91 |
1228056 | 1228056 | 2021-04-16 | Brown | South Dakota | 46013 | 5426 | 91 |
1224808 | 1224808 | 2021-04-15 | Brown | South Dakota | 46013 | 5422 | 91 |
1221561 | 1221561 | 2021-04-14 | Brown | South Dakota | 46013 | 5418 | 91 |
1218313 | 1218313 | 2021-04-13 | Brown | South Dakota | 46013 | 5409 | 91 |
1215065 | 1215065 | 2021-04-12 | Brown | South Dakota | 46013 | 5395 | 91 |
1211818 | 1211818 | 2021-04-11 | Brown | South Dakota | 46013 | 5387 | 91 |
1208569 | 1208569 | 2021-04-10 | Brown | South Dakota | 46013 | 5387 | 91 |
1205321 | 1205321 | 2021-04-09 | Brown | South Dakota | 46013 | 5376 | 91 |
1202073 | 1202073 | 2021-04-08 | Brown | South Dakota | 46013 | 5366 | 91 |
1198824 | 1198824 | 2021-04-07 | Brown | South Dakota | 46013 | 5356 | 91 |
1195575 | 1195575 | 2021-04-06 | Brown | South Dakota | 46013 | 5343 | 91 |
1192327 | 1192327 | 2021-04-05 | Brown | South Dakota | 46013 | 5337 | 91 |
1189078 | 1189078 | 2021-04-04 | Brown | South Dakota | 46013 | 5331 | 91 |
1185831 | 1185831 | 2021-04-03 | Brown | South Dakota | 46013 | 5331 | 91 |
1182584 | 1182584 | 2021-04-02 | Brown | South Dakota | 46013 | 5322 | 91 |
1179337 | 1179337 | 2021-04-01 | Brown | South Dakota | 46013 | 5314 | 91 |
1176090 | 1176090 | 2021-03-31 | Brown | South Dakota | 46013 | 5304 | 91 |
1172843 | 1172843 | 2021-03-30 | Brown | South Dakota | 46013 | 5290 | 91 |
1169596 | 1169596 | 2021-03-29 | Brown | South Dakota | 46013 | 5286 | 91 |
1166348 | 1166348 | 2021-03-28 | Brown | South Dakota | 46013 | 5281 | 91 |
1163100 | 1163100 | 2021-03-27 | Brown | South Dakota | 46013 | 5276 | 91 |
1159851 | 1159851 | 2021-03-26 | Brown | South Dakota | 46013 | 5264 | 91 |
1156604 | 1156604 | 2021-03-25 | Brown | South Dakota | 46013 | 5258 | 91 |
1153357 | 1153357 | 2021-03-24 | Brown | South Dakota | 46013 | 5253 | 91 |
1150110 | 1150110 | 2021-03-23 | Brown | South Dakota | 46013 | 5244 | 91 |
1146863 | 1146863 | 2021-03-22 | Brown | South Dakota | 46013 | 5242 | 91 |
1143616 | 1143616 | 2021-03-21 | Brown | South Dakota | 46013 | 5240 | 91 |
634146 | 634146 | 2020-10-15 | Minnehaha | South Dakota | 46099 | 8531 | 91 |
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);