ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
738 rows where fips = 46137 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 |
---|---|---|---|---|---|---|---|
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 |
1854884 | 1854884 | 2021-10-26 | Ziebach | South Dakota | 46137 | 421 | 9 |
1851635 | 1851635 | 2021-10-25 | Ziebach | South Dakota | 46137 | 421 | 9 |
1848385 | 1848385 | 2021-10-24 | Ziebach | South Dakota | 46137 | 420 | 9 |
1845135 | 1845135 | 2021-10-23 | Ziebach | South Dakota | 46137 | 420 | 9 |
1841885 | 1841885 | 2021-10-22 | Ziebach | South Dakota | 46137 | 420 | 9 |
1838636 | 1838636 | 2021-10-21 | Ziebach | South Dakota | 46137 | 401 | 9 |
1835387 | 1835387 | 2021-10-20 | Ziebach | South Dakota | 46137 | 392 | 9 |
1832138 | 1832138 | 2021-10-19 | Ziebach | South Dakota | 46137 | 383 | 9 |
1828889 | 1828889 | 2021-10-18 | Ziebach | South Dakota | 46137 | 383 | 9 |
1825640 | 1825640 | 2021-10-17 | Ziebach | South Dakota | 46137 | 382 | 9 |
1822391 | 1822391 | 2021-10-16 | Ziebach | South Dakota | 46137 | 382 | 9 |
1819142 | 1819142 | 2021-10-15 | Ziebach | South Dakota | 46137 | 382 | 9 |
1815893 | 1815893 | 2021-10-14 | Ziebach | South Dakota | 46137 | 382 | 9 |
1812645 | 1812645 | 2021-10-13 | Ziebach | South Dakota | 46137 | 382 | 9 |
1809396 | 1809396 | 2021-10-12 | Ziebach | South Dakota | 46137 | 382 | 9 |
1806146 | 1806146 | 2021-10-11 | Ziebach | South Dakota | 46137 | 382 | 9 |
1802896 | 1802896 | 2021-10-10 | Ziebach | South Dakota | 46137 | 382 | 9 |
1799647 | 1799647 | 2021-10-09 | Ziebach | South Dakota | 46137 | 382 | 9 |
1796398 | 1796398 | 2021-10-08 | Ziebach | South Dakota | 46137 | 382 | 9 |
1793149 | 1793149 | 2021-10-07 | Ziebach | South Dakota | 46137 | 382 | 9 |
1789900 | 1789900 | 2021-10-06 | Ziebach | South Dakota | 46137 | 381 | 9 |
1786652 | 1786652 | 2021-10-05 | Ziebach | South Dakota | 46137 | 381 | 9 |
1783403 | 1783403 | 2021-10-04 | Ziebach | South Dakota | 46137 | 381 | 9 |
1780154 | 1780154 | 2021-10-03 | Ziebach | South Dakota | 46137 | 381 | 9 |
1776904 | 1776904 | 2021-10-02 | Ziebach | South Dakota | 46137 | 381 | 9 |
1773654 | 1773654 | 2021-10-01 | Ziebach | South Dakota | 46137 | 381 | 9 |
1770404 | 1770404 | 2021-09-30 | Ziebach | South Dakota | 46137 | 381 | 9 |
1767155 | 1767155 | 2021-09-29 | Ziebach | South Dakota | 46137 | 379 | 9 |
1763906 | 1763906 | 2021-09-28 | Ziebach | South Dakota | 46137 | 379 | 9 |
1760657 | 1760657 | 2021-09-27 | Ziebach | South Dakota | 46137 | 379 | 9 |
1757409 | 1757409 | 2021-09-26 | Ziebach | South Dakota | 46137 | 379 | 9 |
1754161 | 1754161 | 2021-09-25 | Ziebach | South Dakota | 46137 | 379 | 9 |
1750913 | 1750913 | 2021-09-24 | Ziebach | South Dakota | 46137 | 379 | 9 |
1747664 | 1747664 | 2021-09-23 | Ziebach | South Dakota | 46137 | 379 | 9 |
1744414 | 1744414 | 2021-09-22 | Ziebach | South Dakota | 46137 | 379 | 9 |
1741165 | 1741165 | 2021-09-21 | Ziebach | South Dakota | 46137 | 377 | 9 |
1737916 | 1737916 | 2021-09-20 | Ziebach | South Dakota | 46137 | 373 | 9 |
1734666 | 1734666 | 2021-09-19 | Ziebach | South Dakota | 46137 | 373 | 9 |
1731416 | 1731416 | 2021-09-18 | Ziebach | South Dakota | 46137 | 373 | 9 |
1728166 | 1728166 | 2021-09-17 | Ziebach | South Dakota | 46137 | 373 | 9 |
1724917 | 1724917 | 2021-09-16 | Ziebach | South Dakota | 46137 | 373 | 9 |
1721668 | 1721668 | 2021-09-15 | Ziebach | South Dakota | 46137 | 370 | 9 |
1718420 | 1718420 | 2021-09-14 | Ziebach | South Dakota | 46137 | 366 | 9 |
1715172 | 1715172 | 2021-09-13 | Ziebach | South Dakota | 46137 | 365 | 9 |
1711926 | 1711926 | 2021-09-12 | Ziebach | South Dakota | 46137 | 362 | 9 |
1708679 | 1708679 | 2021-09-11 | Ziebach | South Dakota | 46137 | 362 | 9 |
1705432 | 1705432 | 2021-09-10 | Ziebach | South Dakota | 46137 | 362 | 9 |
1702182 | 1702182 | 2021-09-09 | Ziebach | South Dakota | 46137 | 363 | 9 |
1698933 | 1698933 | 2021-09-08 | Ziebach | South Dakota | 46137 | 362 | 9 |
1695685 | 1695685 | 2021-09-07 | Ziebach | South Dakota | 46137 | 351 | 9 |
1692437 | 1692437 | 2021-09-06 | Ziebach | South Dakota | 46137 | 349 | 9 |
1689188 | 1689188 | 2021-09-05 | Ziebach | South Dakota | 46137 | 349 | 9 |
1685938 | 1685938 | 2021-09-04 | Ziebach | South Dakota | 46137 | 349 | 9 |
1682687 | 1682687 | 2021-09-03 | Ziebach | South Dakota | 46137 | 349 | 9 |
1679437 | 1679437 | 2021-09-02 | Ziebach | South Dakota | 46137 | 349 | 9 |
1676189 | 1676189 | 2021-09-01 | Ziebach | South Dakota | 46137 | 349 | 9 |
1672942 | 1672942 | 2021-08-31 | Ziebach | South Dakota | 46137 | 349 | 9 |
1669694 | 1669694 | 2021-08-30 | Ziebach | South Dakota | 46137 | 349 | 9 |
1666447 | 1666447 | 2021-08-29 | Ziebach | South Dakota | 46137 | 349 | 9 |
1663199 | 1663199 | 2021-08-28 | Ziebach | South Dakota | 46137 | 349 | 9 |
1659951 | 1659951 | 2021-08-27 | Ziebach | South Dakota | 46137 | 349 | 9 |
1656702 | 1656702 | 2021-08-26 | Ziebach | South Dakota | 46137 | 349 | 9 |
1653455 | 1653455 | 2021-08-25 | Ziebach | South Dakota | 46137 | 349 | 9 |
1650208 | 1650208 | 2021-08-24 | Ziebach | South Dakota | 46137 | 349 | 9 |
1646959 | 1646959 | 2021-08-23 | Ziebach | South Dakota | 46137 | 344 | 9 |
1643710 | 1643710 | 2021-08-22 | Ziebach | South Dakota | 46137 | 341 | 9 |
1640460 | 1640460 | 2021-08-21 | Ziebach | South Dakota | 46137 | 341 | 9 |
1637210 | 1637210 | 2021-08-20 | Ziebach | South Dakota | 46137 | 341 | 9 |
1633960 | 1633960 | 2021-08-19 | Ziebach | South Dakota | 46137 | 341 | 9 |
1630713 | 1630713 | 2021-08-18 | Ziebach | South Dakota | 46137 | 341 | 9 |
1627466 | 1627466 | 2021-08-17 | Ziebach | South Dakota | 46137 | 341 | 9 |
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);