ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 46027 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 |
---|---|---|---|---|---|---|---|
1949072 | 1949072 | 2021-11-24 | Clay | South Dakota | 46027 | 2305 | 17 |
1945821 | 1945821 | 2021-11-23 | Clay | South Dakota | 46027 | 2298 | 17 |
1942570 | 1942570 | 2021-11-22 | Clay | South Dakota | 46027 | 2288 | 17 |
1939320 | 1939320 | 2021-11-21 | Clay | South Dakota | 46027 | 2283 | 17 |
1936070 | 1936070 | 2021-11-20 | Clay | South Dakota | 46027 | 2283 | 17 |
1932820 | 1932820 | 2021-11-19 | Clay | South Dakota | 46027 | 2283 | 17 |
1929569 | 1929569 | 2021-11-18 | Clay | South Dakota | 46027 | 2276 | 17 |
1926319 | 1926319 | 2021-11-17 | Clay | South Dakota | 46027 | 2267 | 17 |
1923069 | 1923069 | 2021-11-16 | Clay | South Dakota | 46027 | 2267 | 18 |
1919820 | 1919820 | 2021-11-15 | Clay | South Dakota | 46027 | 2260 | 18 |
1916570 | 1916570 | 2021-11-14 | Clay | South Dakota | 46027 | 2256 | 18 |
1913320 | 1913320 | 2021-11-13 | Clay | South Dakota | 46027 | 2256 | 18 |
1910070 | 1910070 | 2021-11-12 | Clay | South Dakota | 46027 | 2256 | 18 |
1906821 | 1906821 | 2021-11-11 | Clay | South Dakota | 46027 | 2253 | 18 |
1903572 | 1903572 | 2021-11-10 | Clay | South Dakota | 46027 | 2253 | 18 |
1900322 | 1900322 | 2021-11-09 | Clay | South Dakota | 46027 | 2244 | 18 |
1897072 | 1897072 | 2021-11-08 | Clay | South Dakota | 46027 | 2242 | 18 |
1893822 | 1893822 | 2021-11-07 | Clay | South Dakota | 46027 | 2239 | 18 |
1890572 | 1890572 | 2021-11-06 | Clay | South Dakota | 46027 | 2239 | 18 |
1887322 | 1887322 | 2021-11-05 | Clay | South Dakota | 46027 | 2239 | 18 |
1884072 | 1884072 | 2021-11-04 | Clay | South Dakota | 46027 | 2234 | 18 |
1880823 | 1880823 | 2021-11-03 | Clay | South Dakota | 46027 | 2232 | 18 |
1877574 | 1877574 | 2021-11-02 | Clay | South Dakota | 46027 | 2226 | 18 |
1874325 | 1874325 | 2021-11-01 | Clay | South Dakota | 46027 | 2220 | 18 |
1871076 | 1871076 | 2021-10-31 | Clay | South Dakota | 46027 | 2218 | 18 |
1867827 | 1867827 | 2021-10-30 | Clay | South Dakota | 46027 | 2218 | 18 |
1864578 | 1864578 | 2021-10-29 | Clay | South Dakota | 46027 | 2218 | 18 |
1861329 | 1861329 | 2021-10-28 | Clay | South Dakota | 46027 | 2211 | 18 |
1858080 | 1858080 | 2021-10-27 | Clay | South Dakota | 46027 | 2210 | 18 |
1854831 | 1854831 | 2021-10-26 | Clay | South Dakota | 46027 | 2202 | 18 |
1851582 | 1851582 | 2021-10-25 | Clay | South Dakota | 46027 | 2190 | 18 |
1848332 | 1848332 | 2021-10-24 | Clay | South Dakota | 46027 | 2187 | 18 |
1845082 | 1845082 | 2021-10-23 | Clay | South Dakota | 46027 | 2187 | 18 |
1841832 | 1841832 | 2021-10-22 | Clay | South Dakota | 46027 | 2187 | 18 |
1838583 | 1838583 | 2021-10-21 | Clay | South Dakota | 46027 | 2186 | 18 |
1835334 | 1835334 | 2021-10-20 | Clay | South Dakota | 46027 | 2177 | 18 |
1832085 | 1832085 | 2021-10-19 | Clay | South Dakota | 46027 | 2166 | 18 |
1828836 | 1828836 | 2021-10-18 | Clay | South Dakota | 46027 | 2153 | 18 |
1825587 | 1825587 | 2021-10-17 | Clay | South Dakota | 46027 | 2150 | 18 |
1822338 | 1822338 | 2021-10-16 | Clay | South Dakota | 46027 | 2150 | 18 |
1819089 | 1819089 | 2021-10-15 | Clay | South Dakota | 46027 | 2150 | 18 |
1815840 | 1815840 | 2021-10-14 | Clay | South Dakota | 46027 | 2147 | 18 |
1812592 | 1812592 | 2021-10-13 | Clay | South Dakota | 46027 | 2139 | 18 |
1809343 | 1809343 | 2021-10-12 | Clay | South Dakota | 46027 | 2123 | 18 |
1806093 | 1806093 | 2021-10-11 | Clay | South Dakota | 46027 | 2117 | 18 |
1802843 | 1802843 | 2021-10-10 | Clay | South Dakota | 46027 | 2117 | 18 |
1799594 | 1799594 | 2021-10-09 | Clay | South Dakota | 46027 | 2117 | 18 |
1796345 | 1796345 | 2021-10-08 | Clay | South Dakota | 46027 | 2117 | 18 |
1793096 | 1793096 | 2021-10-07 | Clay | South Dakota | 46027 | 2116 | 18 |
1789847 | 1789847 | 2021-10-06 | Clay | South Dakota | 46027 | 2112 | 17 |
1786599 | 1786599 | 2021-10-05 | Clay | South Dakota | 46027 | 2109 | 16 |
1783350 | 1783350 | 2021-10-04 | Clay | South Dakota | 46027 | 2108 | 16 |
1780101 | 1780101 | 2021-10-03 | Clay | South Dakota | 46027 | 2104 | 16 |
1776851 | 1776851 | 2021-10-02 | Clay | South Dakota | 46027 | 2104 | 16 |
1773601 | 1773601 | 2021-10-01 | Clay | South Dakota | 46027 | 2104 | 16 |
1770351 | 1770351 | 2021-09-30 | Clay | South Dakota | 46027 | 2104 | 16 |
1767102 | 1767102 | 2021-09-29 | Clay | South Dakota | 46027 | 2101 | 16 |
1763853 | 1763853 | 2021-09-28 | Clay | South Dakota | 46027 | 2097 | 16 |
1760604 | 1760604 | 2021-09-27 | Clay | South Dakota | 46027 | 2092 | 15 |
1757356 | 1757356 | 2021-09-26 | Clay | South Dakota | 46027 | 2090 | 15 |
1754108 | 1754108 | 2021-09-25 | Clay | South Dakota | 46027 | 2090 | 15 |
1750860 | 1750860 | 2021-09-24 | Clay | South Dakota | 46027 | 2090 | 15 |
1747611 | 1747611 | 2021-09-23 | Clay | South Dakota | 46027 | 2085 | 15 |
1744361 | 1744361 | 2021-09-22 | Clay | South Dakota | 46027 | 2080 | 15 |
1741112 | 1741112 | 2021-09-21 | Clay | South Dakota | 46027 | 2077 | 15 |
1737863 | 1737863 | 2021-09-20 | Clay | South Dakota | 46027 | 2071 | 15 |
1734613 | 1734613 | 2021-09-19 | Clay | South Dakota | 46027 | 2064 | 15 |
1731363 | 1731363 | 2021-09-18 | Clay | South Dakota | 46027 | 2064 | 15 |
1728113 | 1728113 | 2021-09-17 | Clay | South Dakota | 46027 | 2064 | 15 |
1724864 | 1724864 | 2021-09-16 | Clay | South Dakota | 46027 | 2060 | 15 |
1721615 | 1721615 | 2021-09-15 | Clay | South Dakota | 46027 | 2055 | 15 |
1718367 | 1718367 | 2021-09-14 | Clay | South Dakota | 46027 | 2050 | 15 |
1715119 | 1715119 | 2021-09-13 | Clay | South Dakota | 46027 | 2045 | 15 |
1711873 | 1711873 | 2021-09-12 | Clay | South Dakota | 46027 | 2043 | 15 |
1708626 | 1708626 | 2021-09-11 | Clay | South Dakota | 46027 | 2043 | 15 |
1705379 | 1705379 | 2021-09-10 | Clay | South Dakota | 46027 | 2043 | 15 |
1702129 | 1702129 | 2021-09-09 | Clay | South Dakota | 46027 | 2037 | 15 |
1698880 | 1698880 | 2021-09-08 | Clay | South Dakota | 46027 | 2019 | 15 |
1695632 | 1695632 | 2021-09-07 | Clay | South Dakota | 46027 | 2009 | 15 |
1692384 | 1692384 | 2021-09-06 | Clay | South Dakota | 46027 | 2006 | 15 |
1689135 | 1689135 | 2021-09-05 | Clay | South Dakota | 46027 | 2006 | 15 |
1685885 | 1685885 | 2021-09-04 | Clay | South Dakota | 46027 | 2006 | 15 |
1682634 | 1682634 | 2021-09-03 | Clay | South Dakota | 46027 | 2006 | 15 |
1679384 | 1679384 | 2021-09-02 | Clay | South Dakota | 46027 | 1999 | 15 |
1676136 | 1676136 | 2021-09-01 | Clay | South Dakota | 46027 | 1991 | 15 |
1672889 | 1672889 | 2021-08-31 | Clay | South Dakota | 46027 | 1986 | 15 |
1669641 | 1669641 | 2021-08-30 | Clay | South Dakota | 46027 | 1976 | 15 |
1666394 | 1666394 | 2021-08-29 | Clay | South Dakota | 46027 | 1970 | 15 |
1663146 | 1663146 | 2021-08-28 | Clay | South Dakota | 46027 | 1970 | 15 |
1659898 | 1659898 | 2021-08-27 | Clay | South Dakota | 46027 | 1970 | 15 |
1656649 | 1656649 | 2021-08-26 | Clay | South Dakota | 46027 | 1969 | 15 |
1653402 | 1653402 | 2021-08-25 | Clay | South Dakota | 46027 | 1965 | 15 |
1650155 | 1650155 | 2021-08-24 | Clay | South Dakota | 46027 | 1959 | 15 |
1646906 | 1646906 | 2021-08-23 | Clay | South Dakota | 46027 | 1956 | 15 |
1643657 | 1643657 | 2021-08-22 | Clay | South Dakota | 46027 | 1953 | 15 |
1640407 | 1640407 | 2021-08-21 | Clay | South Dakota | 46027 | 1953 | 15 |
1637157 | 1637157 | 2021-08-20 | Clay | South Dakota | 46027 | 1953 | 15 |
1633907 | 1633907 | 2021-08-19 | Clay | South Dakota | 46027 | 1951 | 15 |
1630660 | 1630660 | 2021-08-18 | Clay | South Dakota | 46027 | 1952 | 15 |
1627413 | 1627413 | 2021-08-17 | Clay | South Dakota | 46027 | 1947 | 15 |
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);