ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
234 rows where deaths = 23 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 21
county 21
- Bon Homme 36
- Charles Mix 35
- Fall River 22
- Walworth 19
- Hutchinson 17
- Tripp 16
- Custer 12
- Moody 11
- Day 9
- Gregory 7
- Union 7
- Dewey 6
- Lake 6
- McCook 6
- Roberts 6
- Lawrence 5
- Oglala Lakota 4
- Yankton 4
- Todd 3
- Brookings 2
- Pennington 1
state 1
- South Dakota · 234 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2310006 | 2310006 | 2022-03-15 | Custer | South Dakota | 46033 | 2019 | 23 |
2306753 | 2306753 | 2022-03-14 | Custer | South Dakota | 46033 | 2019 | 23 |
2303502 | 2303502 | 2022-03-13 | Custer | South Dakota | 46033 | 2017 | 23 |
2300250 | 2300250 | 2022-03-12 | Custer | South Dakota | 46033 | 2017 | 23 |
2296998 | 2296998 | 2022-03-11 | Custer | South Dakota | 46033 | 2017 | 23 |
2293746 | 2293746 | 2022-03-10 | Custer | South Dakota | 46033 | 2017 | 23 |
2290494 | 2290494 | 2022-03-09 | Custer | South Dakota | 46033 | 2017 | 23 |
2287242 | 2287242 | 2022-03-08 | Custer | South Dakota | 46033 | 2017 | 23 |
2283990 | 2283990 | 2022-03-07 | Custer | South Dakota | 46033 | 2015 | 23 |
2280738 | 2280738 | 2022-03-06 | Custer | South Dakota | 46033 | 2016 | 23 |
2277485 | 2277485 | 2022-03-05 | Custer | South Dakota | 46033 | 2016 | 23 |
2274232 | 2274232 | 2022-03-04 | Custer | South Dakota | 46033 | 2016 | 23 |
2264519 | 2264519 | 2022-03-01 | Tripp | South Dakota | 46123 | 1378 | 23 |
2261269 | 2261269 | 2022-02-28 | Tripp | South Dakota | 46123 | 1373 | 23 |
2258018 | 2258018 | 2022-02-27 | Tripp | South Dakota | 46123 | 1372 | 23 |
2254767 | 2254767 | 2022-02-26 | Tripp | South Dakota | 46123 | 1372 | 23 |
2251516 | 2251516 | 2022-02-25 | Tripp | South Dakota | 46123 | 1372 | 23 |
2248265 | 2248265 | 2022-02-24 | Tripp | South Dakota | 46123 | 1372 | 23 |
2245014 | 2245014 | 2022-02-23 | Tripp | South Dakota | 46123 | 1370 | 23 |
2241763 | 2241763 | 2022-02-22 | Tripp | South Dakota | 46123 | 1367 | 23 |
2238512 | 2238512 | 2022-02-21 | Tripp | South Dakota | 46123 | 1367 | 23 |
2238515 | 2238515 | 2022-02-21 | Walworth | South Dakota | 46129 | 1300 | 23 |
2235261 | 2235261 | 2022-02-20 | Tripp | South Dakota | 46123 | 1367 | 23 |
2235264 | 2235264 | 2022-02-20 | Walworth | South Dakota | 46129 | 1300 | 23 |
2232010 | 2232010 | 2022-02-19 | Tripp | South Dakota | 46123 | 1367 | 23 |
2232013 | 2232013 | 2022-02-19 | Walworth | South Dakota | 46129 | 1300 | 23 |
2228759 | 2228759 | 2022-02-18 | Tripp | South Dakota | 46123 | 1367 | 23 |
2228762 | 2228762 | 2022-02-18 | Walworth | South Dakota | 46129 | 1300 | 23 |
2225508 | 2225508 | 2022-02-17 | Tripp | South Dakota | 46123 | 1367 | 23 |
2225511 | 2225511 | 2022-02-17 | Walworth | South Dakota | 46129 | 1298 | 23 |
2222257 | 2222257 | 2022-02-16 | Tripp | South Dakota | 46123 | 1365 | 23 |
2222260 | 2222260 | 2022-02-16 | Walworth | South Dakota | 46129 | 1297 | 23 |
2219006 | 2219006 | 2022-02-15 | Tripp | South Dakota | 46123 | 1364 | 23 |
2219009 | 2219009 | 2022-02-15 | Walworth | South Dakota | 46129 | 1295 | 23 |
2215755 | 2215755 | 2022-02-14 | Tripp | South Dakota | 46123 | 1360 | 23 |
2215758 | 2215758 | 2022-02-14 | Walworth | South Dakota | 46129 | 1294 | 23 |
2212507 | 2212507 | 2022-02-13 | Walworth | South Dakota | 46129 | 1291 | 23 |
2209254 | 2209254 | 2022-02-12 | Walworth | South Dakota | 46129 | 1291 | 23 |
2206001 | 2206001 | 2022-02-11 | Walworth | South Dakota | 46129 | 1291 | 23 |
2202748 | 2202748 | 2022-02-10 | Walworth | South Dakota | 46129 | 1288 | 23 |
2199494 | 2199494 | 2022-02-09 | Walworth | South Dakota | 46129 | 1284 | 23 |
2196240 | 2196240 | 2022-02-08 | Walworth | South Dakota | 46129 | 1283 | 23 |
2192986 | 2192986 | 2022-02-07 | Walworth | South Dakota | 46129 | 1282 | 23 |
2189732 | 2189732 | 2022-02-06 | Walworth | South Dakota | 46129 | 1275 | 23 |
2186479 | 2186479 | 2022-02-05 | Walworth | South Dakota | 46129 | 1275 | 23 |
2183227 | 2183227 | 2022-02-04 | Walworth | South Dakota | 46129 | 1275 | 23 |
2179975 | 2179975 | 2022-02-03 | Walworth | South Dakota | 46129 | 1270 | 23 |
2105129 | 2105129 | 2022-01-11 | Lake | South Dakota | 46079 | 1964 | 23 |
2101878 | 2101878 | 2022-01-10 | Lake | South Dakota | 46079 | 1943 | 23 |
2098627 | 2098627 | 2022-01-09 | Lake | South Dakota | 46079 | 1920 | 23 |
2095375 | 2095375 | 2022-01-08 | Lake | South Dakota | 46079 | 1920 | 23 |
2092123 | 2092123 | 2022-01-07 | Lake | South Dakota | 46079 | 1920 | 23 |
2088871 | 2088871 | 2022-01-06 | Lake | South Dakota | 46079 | 1905 | 23 |
1997868 | 1997868 | 2021-12-09 | Moody | South Dakota | 46101 | 921 | 23 |
1994617 | 1994617 | 2021-12-08 | Moody | South Dakota | 46101 | 916 | 23 |
1991366 | 1991366 | 2021-12-07 | Moody | South Dakota | 46101 | 906 | 23 |
1988115 | 1988115 | 2021-12-06 | Moody | South Dakota | 46101 | 900 | 23 |
1984865 | 1984865 | 2021-12-05 | Moody | South Dakota | 46101 | 893 | 23 |
1981615 | 1981615 | 2021-12-04 | Moody | South Dakota | 46101 | 893 | 23 |
1978365 | 1978365 | 2021-12-03 | Moody | South Dakota | 46101 | 893 | 23 |
1975115 | 1975115 | 2021-12-02 | Moody | South Dakota | 46101 | 887 | 23 |
1971866 | 1971866 | 2021-12-01 | Moody | South Dakota | 46101 | 873 | 23 |
1968616 | 1968616 | 2021-11-30 | Moody | South Dakota | 46101 | 858 | 23 |
1965365 | 1965365 | 2021-11-29 | Moody | South Dakota | 46101 | 851 | 23 |
1923079 | 1923079 | 2021-11-16 | Fall River | South Dakota | 46047 | 1099 | 23 |
1919830 | 1919830 | 2021-11-15 | Fall River | South Dakota | 46047 | 1081 | 23 |
1916580 | 1916580 | 2021-11-14 | Fall River | South Dakota | 46047 | 1067 | 23 |
1913330 | 1913330 | 2021-11-13 | Fall River | South Dakota | 46047 | 1067 | 23 |
1910080 | 1910080 | 2021-11-12 | Fall River | South Dakota | 46047 | 1067 | 23 |
1906831 | 1906831 | 2021-11-11 | Fall River | South Dakota | 46047 | 1059 | 23 |
1903582 | 1903582 | 2021-11-10 | Fall River | South Dakota | 46047 | 1059 | 23 |
1900332 | 1900332 | 2021-11-09 | Fall River | South Dakota | 46047 | 1047 | 23 |
1897082 | 1897082 | 2021-11-08 | Fall River | South Dakota | 46047 | 1033 | 23 |
1893832 | 1893832 | 2021-11-07 | Fall River | South Dakota | 46047 | 1025 | 23 |
1890582 | 1890582 | 2021-11-06 | Fall River | South Dakota | 46047 | 1025 | 23 |
1887332 | 1887332 | 2021-11-05 | Fall River | South Dakota | 46047 | 1025 | 23 |
1884082 | 1884082 | 2021-11-04 | Fall River | South Dakota | 46047 | 1014 | 23 |
1880833 | 1880833 | 2021-11-03 | Fall River | South Dakota | 46047 | 1006 | 23 |
1877584 | 1877584 | 2021-11-02 | Fall River | South Dakota | 46047 | 999 | 23 |
1874335 | 1874335 | 2021-11-01 | Fall River | South Dakota | 46047 | 995 | 23 |
1871086 | 1871086 | 2021-10-31 | Fall River | South Dakota | 46047 | 990 | 23 |
1867837 | 1867837 | 2021-10-30 | Fall River | South Dakota | 46047 | 990 | 23 |
1864588 | 1864588 | 2021-10-29 | Fall River | South Dakota | 46047 | 990 | 23 |
1861339 | 1861339 | 2021-10-28 | Fall River | South Dakota | 46047 | 985 | 23 |
1858090 | 1858090 | 2021-10-27 | Fall River | South Dakota | 46047 | 979 | 23 |
1854841 | 1854841 | 2021-10-26 | Fall River | South Dakota | 46047 | 972 | 23 |
1695630 | 1695630 | 2021-09-07 | Charles Mix | South Dakota | 46023 | 1522 | 23 |
1692382 | 1692382 | 2021-09-06 | Charles Mix | South Dakota | 46023 | 1518 | 23 |
1689133 | 1689133 | 2021-09-05 | Charles Mix | South Dakota | 46023 | 1518 | 23 |
1685883 | 1685883 | 2021-09-04 | Charles Mix | South Dakota | 46023 | 1518 | 23 |
1682632 | 1682632 | 2021-09-03 | Charles Mix | South Dakota | 46023 | 1518 | 23 |
1679382 | 1679382 | 2021-09-02 | Charles Mix | South Dakota | 46023 | 1512 | 23 |
1676134 | 1676134 | 2021-09-01 | Charles Mix | South Dakota | 46023 | 1506 | 23 |
1672887 | 1672887 | 2021-08-31 | Charles Mix | South Dakota | 46023 | 1498 | 23 |
1669639 | 1669639 | 2021-08-30 | Charles Mix | South Dakota | 46023 | 1491 | 23 |
1666392 | 1666392 | 2021-08-29 | Charles Mix | South Dakota | 46023 | 1487 | 23 |
1663144 | 1663144 | 2021-08-28 | Charles Mix | South Dakota | 46023 | 1487 | 23 |
1659896 | 1659896 | 2021-08-27 | Charles Mix | South Dakota | 46023 | 1487 | 23 |
1656647 | 1656647 | 2021-08-26 | Charles Mix | South Dakota | 46023 | 1483 | 23 |
1653400 | 1653400 | 2021-08-25 | Charles Mix | South Dakota | 46023 | 1478 | 23 |
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);