ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
86 rows where deaths = 11, fips = 46097 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2014120 | 2014120 | 2021-12-14 | Miner | South Dakota | 46097 | 373 | 11 |
2010869 | 2010869 | 2021-12-13 | Miner | South Dakota | 46097 | 372 | 11 |
2007618 | 2007618 | 2021-12-12 | Miner | South Dakota | 46097 | 371 | 11 |
2004367 | 2004367 | 2021-12-11 | Miner | South Dakota | 46097 | 371 | 11 |
2001116 | 2001116 | 2021-12-10 | Miner | South Dakota | 46097 | 371 | 11 |
1997866 | 1997866 | 2021-12-09 | Miner | South Dakota | 46097 | 369 | 11 |
1994615 | 1994615 | 2021-12-08 | Miner | South Dakota | 46097 | 369 | 11 |
1991364 | 1991364 | 2021-12-07 | Miner | South Dakota | 46097 | 369 | 11 |
1988113 | 1988113 | 2021-12-06 | Miner | South Dakota | 46097 | 368 | 11 |
1984863 | 1984863 | 2021-12-05 | Miner | South Dakota | 46097 | 368 | 11 |
1981613 | 1981613 | 2021-12-04 | Miner | South Dakota | 46097 | 368 | 11 |
1978363 | 1978363 | 2021-12-03 | Miner | South Dakota | 46097 | 368 | 11 |
1975113 | 1975113 | 2021-12-02 | Miner | South Dakota | 46097 | 368 | 11 |
1971864 | 1971864 | 2021-12-01 | Miner | South Dakota | 46097 | 366 | 11 |
1968614 | 1968614 | 2021-11-30 | Miner | South Dakota | 46097 | 365 | 11 |
1965363 | 1965363 | 2021-11-29 | Miner | South Dakota | 46097 | 365 | 11 |
1962111 | 1962111 | 2021-11-28 | Miner | South Dakota | 46097 | 365 | 11 |
1958860 | 1958860 | 2021-11-27 | Miner | South Dakota | 46097 | 365 | 11 |
1955609 | 1955609 | 2021-11-26 | Miner | South Dakota | 46097 | 365 | 11 |
1952358 | 1952358 | 2021-11-25 | Miner | South Dakota | 46097 | 365 | 11 |
1949107 | 1949107 | 2021-11-24 | Miner | South Dakota | 46097 | 365 | 11 |
1945856 | 1945856 | 2021-11-23 | Miner | South Dakota | 46097 | 365 | 11 |
1942605 | 1942605 | 2021-11-22 | Miner | South Dakota | 46097 | 364 | 11 |
1939355 | 1939355 | 2021-11-21 | Miner | South Dakota | 46097 | 364 | 11 |
1936105 | 1936105 | 2021-11-20 | Miner | South Dakota | 46097 | 364 | 11 |
1932855 | 1932855 | 2021-11-19 | Miner | South Dakota | 46097 | 364 | 11 |
1929604 | 1929604 | 2021-11-18 | Miner | South Dakota | 46097 | 362 | 11 |
1926354 | 1926354 | 2021-11-17 | Miner | South Dakota | 46097 | 362 | 11 |
1923104 | 1923104 | 2021-11-16 | Miner | South Dakota | 46097 | 360 | 11 |
1919855 | 1919855 | 2021-11-15 | Miner | South Dakota | 46097 | 360 | 11 |
1916605 | 1916605 | 2021-11-14 | Miner | South Dakota | 46097 | 358 | 11 |
1913355 | 1913355 | 2021-11-13 | Miner | South Dakota | 46097 | 358 | 11 |
1910105 | 1910105 | 2021-11-12 | Miner | South Dakota | 46097 | 358 | 11 |
1906856 | 1906856 | 2021-11-11 | Miner | South Dakota | 46097 | 358 | 11 |
1903607 | 1903607 | 2021-11-10 | Miner | South Dakota | 46097 | 358 | 11 |
1900357 | 1900357 | 2021-11-09 | Miner | South Dakota | 46097 | 358 | 11 |
1897107 | 1897107 | 2021-11-08 | Miner | South Dakota | 46097 | 357 | 11 |
1893857 | 1893857 | 2021-11-07 | Miner | South Dakota | 46097 | 357 | 11 |
1890607 | 1890607 | 2021-11-06 | Miner | South Dakota | 46097 | 357 | 11 |
1887357 | 1887357 | 2021-11-05 | Miner | South Dakota | 46097 | 357 | 11 |
1884107 | 1884107 | 2021-11-04 | Miner | South Dakota | 46097 | 355 | 11 |
1880858 | 1880858 | 2021-11-03 | Miner | South Dakota | 46097 | 354 | 11 |
1877609 | 1877609 | 2021-11-02 | Miner | South Dakota | 46097 | 354 | 11 |
1874360 | 1874360 | 2021-11-01 | Miner | South Dakota | 46097 | 354 | 11 |
1871111 | 1871111 | 2021-10-31 | Miner | South Dakota | 46097 | 354 | 11 |
1867862 | 1867862 | 2021-10-30 | Miner | South Dakota | 46097 | 354 | 11 |
1864613 | 1864613 | 2021-10-29 | Miner | South Dakota | 46097 | 354 | 11 |
1861364 | 1861364 | 2021-10-28 | Miner | South Dakota | 46097 | 353 | 11 |
1858115 | 1858115 | 2021-10-27 | Miner | South Dakota | 46097 | 353 | 11 |
1854866 | 1854866 | 2021-10-26 | Miner | South Dakota | 46097 | 352 | 11 |
1851617 | 1851617 | 2021-10-25 | Miner | South Dakota | 46097 | 350 | 11 |
1848367 | 1848367 | 2021-10-24 | Miner | South Dakota | 46097 | 349 | 11 |
1845117 | 1845117 | 2021-10-23 | Miner | South Dakota | 46097 | 349 | 11 |
1841867 | 1841867 | 2021-10-22 | Miner | South Dakota | 46097 | 349 | 11 |
1838618 | 1838618 | 2021-10-21 | Miner | South Dakota | 46097 | 349 | 11 |
1835369 | 1835369 | 2021-10-20 | Miner | South Dakota | 46097 | 349 | 11 |
1832120 | 1832120 | 2021-10-19 | Miner | South Dakota | 46097 | 349 | 11 |
1828871 | 1828871 | 2021-10-18 | Miner | South Dakota | 46097 | 349 | 11 |
1825622 | 1825622 | 2021-10-17 | Miner | South Dakota | 46097 | 349 | 11 |
1822373 | 1822373 | 2021-10-16 | Miner | South Dakota | 46097 | 349 | 11 |
1819124 | 1819124 | 2021-10-15 | Miner | South Dakota | 46097 | 349 | 11 |
1815875 | 1815875 | 2021-10-14 | Miner | South Dakota | 46097 | 349 | 11 |
1812627 | 1812627 | 2021-10-13 | Miner | South Dakota | 46097 | 349 | 11 |
1809378 | 1809378 | 2021-10-12 | Miner | South Dakota | 46097 | 348 | 11 |
1806128 | 1806128 | 2021-10-11 | Miner | South Dakota | 46097 | 332 | 11 |
1802878 | 1802878 | 2021-10-10 | Miner | South Dakota | 46097 | 332 | 11 |
1799629 | 1799629 | 2021-10-09 | Miner | South Dakota | 46097 | 332 | 11 |
1796380 | 1796380 | 2021-10-08 | Miner | South Dakota | 46097 | 332 | 11 |
1793131 | 1793131 | 2021-10-07 | Miner | South Dakota | 46097 | 328 | 11 |
1789882 | 1789882 | 2021-10-06 | Miner | South Dakota | 46097 | 328 | 11 |
1786634 | 1786634 | 2021-10-05 | Miner | South Dakota | 46097 | 328 | 11 |
1783385 | 1783385 | 2021-10-04 | Miner | South Dakota | 46097 | 327 | 11 |
1780136 | 1780136 | 2021-10-03 | Miner | South Dakota | 46097 | 326 | 11 |
1776886 | 1776886 | 2021-10-02 | Miner | South Dakota | 46097 | 326 | 11 |
1773636 | 1773636 | 2021-10-01 | Miner | South Dakota | 46097 | 326 | 11 |
1770386 | 1770386 | 2021-09-30 | Miner | South Dakota | 46097 | 326 | 11 |
1767137 | 1767137 | 2021-09-29 | Miner | South Dakota | 46097 | 326 | 11 |
1763888 | 1763888 | 2021-09-28 | Miner | South Dakota | 46097 | 326 | 11 |
1760639 | 1760639 | 2021-09-27 | Miner | South Dakota | 46097 | 326 | 11 |
1757391 | 1757391 | 2021-09-26 | Miner | South Dakota | 46097 | 324 | 11 |
1754143 | 1754143 | 2021-09-25 | Miner | South Dakota | 46097 | 324 | 11 |
1750895 | 1750895 | 2021-09-24 | Miner | South Dakota | 46097 | 324 | 11 |
1747646 | 1747646 | 2021-09-23 | Miner | South Dakota | 46097 | 324 | 11 |
1744396 | 1744396 | 2021-09-22 | Miner | South Dakota | 46097 | 324 | 11 |
1741147 | 1741147 | 2021-09-21 | Miner | South Dakota | 46097 | 321 | 11 |
1737898 | 1737898 | 2021-09-20 | Miner | South Dakota | 46097 | 321 | 11 |
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);