ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
236 rows where deaths = 15, fips = 46027 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1624166 | 1624166 | 2021-08-16 | Clay | South Dakota | 46027 | 1945 | 15 |
1620919 | 1620919 | 2021-08-15 | Clay | South Dakota | 46027 | 1944 | 15 |
1617671 | 1617671 | 2021-08-14 | Clay | South Dakota | 46027 | 1944 | 15 |
1614423 | 1614423 | 2021-08-13 | Clay | South Dakota | 46027 | 1944 | 15 |
1611174 | 1611174 | 2021-08-12 | Clay | South Dakota | 46027 | 1942 | 15 |
1607926 | 1607926 | 2021-08-11 | Clay | South Dakota | 46027 | 1942 | 15 |
1604677 | 1604677 | 2021-08-10 | Clay | South Dakota | 46027 | 1939 | 15 |
1601428 | 1601428 | 2021-08-09 | Clay | South Dakota | 46027 | 1939 | 15 |
1598180 | 1598180 | 2021-08-08 | Clay | South Dakota | 46027 | 1939 | 15 |
1594931 | 1594931 | 2021-08-07 | Clay | South Dakota | 46027 | 1939 | 15 |
1591682 | 1591682 | 2021-08-06 | Clay | South Dakota | 46027 | 1939 | 15 |
1588433 | 1588433 | 2021-08-05 | Clay | South Dakota | 46027 | 1939 | 15 |
1585183 | 1585183 | 2021-08-04 | Clay | South Dakota | 46027 | 1939 | 15 |
1581933 | 1581933 | 2021-08-03 | Clay | South Dakota | 46027 | 1938 | 15 |
1578684 | 1578684 | 2021-08-02 | Clay | South Dakota | 46027 | 1938 | 15 |
1575436 | 1575436 | 2021-08-01 | Clay | South Dakota | 46027 | 1938 | 15 |
1572188 | 1572188 | 2021-07-31 | Clay | South Dakota | 46027 | 1938 | 15 |
1568940 | 1568940 | 2021-07-30 | Clay | South Dakota | 46027 | 1938 | 15 |
1565692 | 1565692 | 2021-07-29 | Clay | South Dakota | 46027 | 1938 | 15 |
1562444 | 1562444 | 2021-07-28 | Clay | South Dakota | 46027 | 1938 | 15 |
1559196 | 1559196 | 2021-07-27 | Clay | South Dakota | 46027 | 1937 | 15 |
1555949 | 1555949 | 2021-07-26 | Clay | South Dakota | 46027 | 1937 | 15 |
1552702 | 1552702 | 2021-07-25 | Clay | South Dakota | 46027 | 1937 | 15 |
1549455 | 1549455 | 2021-07-24 | Clay | South Dakota | 46027 | 1937 | 15 |
1546208 | 1546208 | 2021-07-23 | Clay | South Dakota | 46027 | 1937 | 15 |
1542961 | 1542961 | 2021-07-22 | Clay | South Dakota | 46027 | 1937 | 15 |
1539713 | 1539713 | 2021-07-21 | Clay | South Dakota | 46027 | 1937 | 15 |
1536466 | 1536466 | 2021-07-20 | Clay | South Dakota | 46027 | 1933 | 15 |
1533218 | 1533218 | 2021-07-19 | Clay | South Dakota | 46027 | 1933 | 15 |
1529971 | 1529971 | 2021-07-18 | Clay | South Dakota | 46027 | 1933 | 15 |
1526724 | 1526724 | 2021-07-17 | Clay | South Dakota | 46027 | 1933 | 15 |
1523477 | 1523477 | 2021-07-16 | Clay | South Dakota | 46027 | 1933 | 15 |
1520229 | 1520229 | 2021-07-15 | Clay | South Dakota | 46027 | 1933 | 15 |
1516981 | 1516981 | 2021-07-14 | Clay | South Dakota | 46027 | 1933 | 15 |
1513734 | 1513734 | 2021-07-13 | Clay | South Dakota | 46027 | 1933 | 15 |
1510488 | 1510488 | 2021-07-12 | Clay | South Dakota | 46027 | 1933 | 15 |
1507241 | 1507241 | 2021-07-11 | Clay | South Dakota | 46027 | 1933 | 15 |
1503995 | 1503995 | 2021-07-10 | Clay | South Dakota | 46027 | 1933 | 15 |
1500749 | 1500749 | 2021-07-09 | Clay | South Dakota | 46027 | 1933 | 15 |
1497503 | 1497503 | 2021-07-08 | Clay | South Dakota | 46027 | 1933 | 15 |
1494256 | 1494256 | 2021-07-07 | Clay | South Dakota | 46027 | 1933 | 15 |
1491009 | 1491009 | 2021-07-06 | Clay | South Dakota | 46027 | 1933 | 15 |
1487762 | 1487762 | 2021-07-05 | Clay | South Dakota | 46027 | 1933 | 15 |
1484515 | 1484515 | 2021-07-04 | Clay | South Dakota | 46027 | 1933 | 15 |
1481269 | 1481269 | 2021-07-03 | Clay | South Dakota | 46027 | 1933 | 15 |
1478022 | 1478022 | 2021-07-02 | Clay | South Dakota | 46027 | 1933 | 15 |
1474776 | 1474776 | 2021-07-01 | Clay | South Dakota | 46027 | 1933 | 15 |
1471530 | 1471530 | 2021-06-30 | Clay | South Dakota | 46027 | 1932 | 15 |
1468285 | 1468285 | 2021-06-29 | Clay | South Dakota | 46027 | 1932 | 15 |
1465040 | 1465040 | 2021-06-28 | Clay | South Dakota | 46027 | 1931 | 15 |
1461795 | 1461795 | 2021-06-27 | Clay | South Dakota | 46027 | 1931 | 15 |
1458550 | 1458550 | 2021-06-26 | Clay | South Dakota | 46027 | 1931 | 15 |
1455305 | 1455305 | 2021-06-25 | Clay | South Dakota | 46027 | 1931 | 15 |
1452060 | 1452060 | 2021-06-24 | Clay | South Dakota | 46027 | 1931 | 15 |
1448814 | 1448814 | 2021-06-23 | Clay | South Dakota | 46027 | 1931 | 15 |
1445569 | 1445569 | 2021-06-22 | Clay | South Dakota | 46027 | 1931 | 15 |
1442324 | 1442324 | 2021-06-21 | Clay | South Dakota | 46027 | 1932 | 15 |
1439079 | 1439079 | 2021-06-20 | Clay | South Dakota | 46027 | 1933 | 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);