ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
910 rows where deaths = 10 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Haakon 188
- Miner 131
- Brule 98
- Lyman 73
- Ziebach 54
- Buffalo 41
- Deuel 41
- Faulk 26
- Fall River 24
- Gregory 22
- Meade 21
- Walworth 21
- Union 16
- Todd 15
- Codington 14
- Tripp 14
- Charles Mix 13
- Custer 13
- Moody 12
- Lake 11
- Corson 9
- Beadle 6
- Clay 5
- Lincoln 5
- Aurora 4
- Brown 4
- Pennington 4
- Kingsbury 3
- Roberts 3
- Bennett 2
- …
state 1
- South Dakota · 910 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2248233 | 2248233 | 2022-02-24 | Hand | South Dakota | 46059 | 561 | 10 |
2176663 | 2176663 | 2022-02-02 | Bennett | South Dakota | 46007 | 732 | 10 |
2173409 | 2173409 | 2022-02-01 | Bennett | South Dakota | 46007 | 728 | 10 |
2030392 | 2030392 | 2021-12-19 | Ziebach | South Dakota | 46137 | 481 | 10 |
2027141 | 2027141 | 2021-12-18 | Ziebach | South Dakota | 46137 | 481 | 10 |
2023890 | 2023890 | 2021-12-17 | Ziebach | South Dakota | 46137 | 481 | 10 |
2020639 | 2020639 | 2021-12-16 | Ziebach | South Dakota | 46137 | 481 | 10 |
2017388 | 2017388 | 2021-12-15 | Ziebach | South Dakota | 46137 | 480 | 10 |
2014138 | 2014138 | 2021-12-14 | Ziebach | South Dakota | 46137 | 480 | 10 |
2010887 | 2010887 | 2021-12-13 | Ziebach | South Dakota | 46137 | 480 | 10 |
2007636 | 2007636 | 2021-12-12 | Ziebach | South Dakota | 46137 | 480 | 10 |
2004385 | 2004385 | 2021-12-11 | Ziebach | South Dakota | 46137 | 480 | 10 |
2001134 | 2001134 | 2021-12-10 | Ziebach | South Dakota | 46137 | 480 | 10 |
1997884 | 1997884 | 2021-12-09 | Ziebach | South Dakota | 46137 | 473 | 10 |
1994633 | 1994633 | 2021-12-08 | Ziebach | South Dakota | 46137 | 473 | 10 |
1991382 | 1991382 | 2021-12-07 | Ziebach | South Dakota | 46137 | 465 | 10 |
1988131 | 1988131 | 2021-12-06 | Ziebach | South Dakota | 46137 | 464 | 10 |
1984881 | 1984881 | 2021-12-05 | Ziebach | South Dakota | 46137 | 464 | 10 |
1981631 | 1981631 | 2021-12-04 | Ziebach | South Dakota | 46137 | 464 | 10 |
1978381 | 1978381 | 2021-12-03 | Ziebach | South Dakota | 46137 | 464 | 10 |
1975131 | 1975131 | 2021-12-02 | Ziebach | South Dakota | 46137 | 464 | 10 |
1971882 | 1971882 | 2021-12-01 | Ziebach | South Dakota | 46137 | 464 | 10 |
1968632 | 1968632 | 2021-11-30 | Ziebach | South Dakota | 46137 | 464 | 10 |
1965381 | 1965381 | 2021-11-29 | Ziebach | South Dakota | 46137 | 463 | 10 |
1962129 | 1962129 | 2021-11-28 | Ziebach | South Dakota | 46137 | 463 | 10 |
1958878 | 1958878 | 2021-11-27 | Ziebach | South Dakota | 46137 | 463 | 10 |
1955627 | 1955627 | 2021-11-26 | Ziebach | South Dakota | 46137 | 463 | 10 |
1952376 | 1952376 | 2021-11-25 | Ziebach | South Dakota | 46137 | 463 | 10 |
1949125 | 1949125 | 2021-11-24 | Ziebach | South Dakota | 46137 | 463 | 10 |
1945874 | 1945874 | 2021-11-23 | Ziebach | South Dakota | 46137 | 463 | 10 |
1942623 | 1942623 | 2021-11-22 | Ziebach | South Dakota | 46137 | 461 | 10 |
1939373 | 1939373 | 2021-11-21 | Ziebach | South Dakota | 46137 | 461 | 10 |
1936123 | 1936123 | 2021-11-20 | Ziebach | South Dakota | 46137 | 461 | 10 |
1932873 | 1932873 | 2021-11-19 | Ziebach | South Dakota | 46137 | 461 | 10 |
1929622 | 1929622 | 2021-11-18 | Ziebach | South Dakota | 46137 | 460 | 10 |
1926372 | 1926372 | 2021-11-17 | Ziebach | South Dakota | 46137 | 453 | 10 |
1923122 | 1923122 | 2021-11-16 | Ziebach | South Dakota | 46137 | 453 | 10 |
1919873 | 1919873 | 2021-11-15 | Ziebach | South Dakota | 46137 | 451 | 10 |
1916623 | 1916623 | 2021-11-14 | Ziebach | South Dakota | 46137 | 446 | 10 |
1913373 | 1913373 | 2021-11-13 | Ziebach | South Dakota | 46137 | 446 | 10 |
1910123 | 1910123 | 2021-11-12 | Ziebach | South Dakota | 46137 | 446 | 10 |
1906874 | 1906874 | 2021-11-11 | Ziebach | South Dakota | 46137 | 446 | 10 |
1903625 | 1903625 | 2021-11-10 | Ziebach | South Dakota | 46137 | 446 | 10 |
1900375 | 1900375 | 2021-11-09 | Ziebach | South Dakota | 46137 | 443 | 10 |
1897125 | 1897125 | 2021-11-08 | Ziebach | South Dakota | 46137 | 441 | 10 |
1893875 | 1893875 | 2021-11-07 | Ziebach | South Dakota | 46137 | 441 | 10 |
1890625 | 1890625 | 2021-11-06 | Ziebach | South Dakota | 46137 | 441 | 10 |
1887375 | 1887375 | 2021-11-05 | Ziebach | South Dakota | 46137 | 441 | 10 |
1884125 | 1884125 | 2021-11-04 | Ziebach | South Dakota | 46137 | 439 | 10 |
1880876 | 1880876 | 2021-11-03 | Ziebach | South Dakota | 46137 | 439 | 10 |
1877627 | 1877627 | 2021-11-02 | Ziebach | South Dakota | 46137 | 439 | 10 |
1874378 | 1874378 | 2021-11-01 | Ziebach | South Dakota | 46137 | 438 | 10 |
1871129 | 1871129 | 2021-10-31 | Ziebach | South Dakota | 46137 | 426 | 10 |
1867880 | 1867880 | 2021-10-30 | Ziebach | South Dakota | 46137 | 426 | 10 |
1864631 | 1864631 | 2021-10-29 | Ziebach | South Dakota | 46137 | 426 | 10 |
1861382 | 1861382 | 2021-10-28 | Ziebach | South Dakota | 46137 | 421 | 10 |
1858133 | 1858133 | 2021-10-27 | Ziebach | South Dakota | 46137 | 421 | 10 |
1757362 | 1757362 | 2021-09-26 | Deuel | South Dakota | 46039 | 619 | 10 |
1754114 | 1754114 | 2021-09-25 | Deuel | South Dakota | 46039 | 619 | 10 |
1750866 | 1750866 | 2021-09-24 | Deuel | South Dakota | 46039 | 619 | 10 |
1747617 | 1747617 | 2021-09-23 | Deuel | South Dakota | 46039 | 619 | 10 |
1744367 | 1744367 | 2021-09-22 | Deuel | South Dakota | 46039 | 618 | 10 |
1741118 | 1741118 | 2021-09-21 | Deuel | South Dakota | 46039 | 618 | 10 |
1737869 | 1737869 | 2021-09-20 | Deuel | South Dakota | 46039 | 617 | 10 |
1734619 | 1734619 | 2021-09-19 | Deuel | South Dakota | 46039 | 614 | 10 |
1734648 | 1734648 | 2021-09-19 | Miner | South Dakota | 46097 | 321 | 10 |
1731369 | 1731369 | 2021-09-18 | Deuel | South Dakota | 46039 | 614 | 10 |
1731398 | 1731398 | 2021-09-18 | Miner | South Dakota | 46097 | 321 | 10 |
1728119 | 1728119 | 2021-09-17 | Deuel | South Dakota | 46039 | 614 | 10 |
1728148 | 1728148 | 2021-09-17 | Miner | South Dakota | 46097 | 321 | 10 |
1724870 | 1724870 | 2021-09-16 | Deuel | South Dakota | 46039 | 614 | 10 |
1724899 | 1724899 | 2021-09-16 | Miner | South Dakota | 46097 | 321 | 10 |
1721621 | 1721621 | 2021-09-15 | Deuel | South Dakota | 46039 | 614 | 10 |
1721650 | 1721650 | 2021-09-15 | Miner | South Dakota | 46097 | 321 | 10 |
1718373 | 1718373 | 2021-09-14 | Deuel | South Dakota | 46039 | 610 | 10 |
1718402 | 1718402 | 2021-09-14 | Miner | South Dakota | 46097 | 321 | 10 |
1715125 | 1715125 | 2021-09-13 | Deuel | South Dakota | 46039 | 610 | 10 |
1715154 | 1715154 | 2021-09-13 | Miner | South Dakota | 46097 | 321 | 10 |
1711879 | 1711879 | 2021-09-12 | Deuel | South Dakota | 46039 | 610 | 10 |
1711908 | 1711908 | 2021-09-12 | Miner | South Dakota | 46097 | 320 | 10 |
1708632 | 1708632 | 2021-09-11 | Deuel | South Dakota | 46039 | 610 | 10 |
1708661 | 1708661 | 2021-09-11 | Miner | South Dakota | 46097 | 320 | 10 |
1705385 | 1705385 | 2021-09-10 | Deuel | South Dakota | 46039 | 610 | 10 |
1705414 | 1705414 | 2021-09-10 | Miner | South Dakota | 46097 | 320 | 10 |
1702135 | 1702135 | 2021-09-09 | Deuel | South Dakota | 46039 | 608 | 10 |
1702164 | 1702164 | 2021-09-09 | Miner | South Dakota | 46097 | 319 | 10 |
1698886 | 1698886 | 2021-09-08 | Deuel | South Dakota | 46039 | 606 | 10 |
1698915 | 1698915 | 2021-09-08 | Miner | South Dakota | 46097 | 318 | 10 |
1695638 | 1695638 | 2021-09-07 | Deuel | South Dakota | 46039 | 602 | 10 |
1695667 | 1695667 | 2021-09-07 | Miner | South Dakota | 46097 | 317 | 10 |
1692390 | 1692390 | 2021-09-06 | Deuel | South Dakota | 46039 | 602 | 10 |
1692419 | 1692419 | 2021-09-06 | Miner | South Dakota | 46097 | 316 | 10 |
1689141 | 1689141 | 2021-09-05 | Deuel | South Dakota | 46039 | 602 | 10 |
1689170 | 1689170 | 2021-09-05 | Miner | South Dakota | 46097 | 316 | 10 |
1685891 | 1685891 | 2021-09-04 | Deuel | South Dakota | 46039 | 602 | 10 |
1685920 | 1685920 | 2021-09-04 | Miner | South Dakota | 46097 | 316 | 10 |
1682640 | 1682640 | 2021-09-03 | Deuel | South Dakota | 46039 | 602 | 10 |
1682669 | 1682669 | 2021-09-03 | Miner | South Dakota | 46097 | 316 | 10 |
1679390 | 1679390 | 2021-09-02 | Deuel | South Dakota | 46039 | 601 | 10 |
1679419 | 1679419 | 2021-09-02 | Miner | South Dakota | 46097 | 315 | 10 |
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);