ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 46009 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 |
---|---|---|---|---|---|---|---|
1718358 | 1718358 | 2021-09-14 | Bon Homme | South Dakota | 46009 | 1582 | 29 |
1715110 | 1715110 | 2021-09-13 | Bon Homme | South Dakota | 46009 | 1582 | 29 |
1711864 | 1711864 | 2021-09-12 | Bon Homme | South Dakota | 46009 | 1581 | 29 |
1708617 | 1708617 | 2021-09-11 | Bon Homme | South Dakota | 46009 | 1581 | 29 |
1705370 | 1705370 | 2021-09-10 | Bon Homme | South Dakota | 46009 | 1581 | 29 |
1702120 | 1702120 | 2021-09-09 | Bon Homme | South Dakota | 46009 | 1580 | 29 |
1698871 | 1698871 | 2021-09-08 | Bon Homme | South Dakota | 46009 | 1578 | 29 |
1695623 | 1695623 | 2021-09-07 | Bon Homme | South Dakota | 46009 | 1576 | 29 |
1692375 | 1692375 | 2021-09-06 | Bon Homme | South Dakota | 46009 | 1575 | 29 |
1689126 | 1689126 | 2021-09-05 | Bon Homme | South Dakota | 46009 | 1575 | 29 |
1685876 | 1685876 | 2021-09-04 | Bon Homme | South Dakota | 46009 | 1575 | 29 |
1682625 | 1682625 | 2021-09-03 | Bon Homme | South Dakota | 46009 | 1575 | 29 |
1679375 | 1679375 | 2021-09-02 | Bon Homme | South Dakota | 46009 | 1573 | 29 |
1676127 | 1676127 | 2021-09-01 | Bon Homme | South Dakota | 46009 | 1573 | 29 |
1672880 | 1672880 | 2021-08-31 | Bon Homme | South Dakota | 46009 | 1571 | 29 |
1669632 | 1669632 | 2021-08-30 | Bon Homme | South Dakota | 46009 | 1568 | 29 |
1666385 | 1666385 | 2021-08-29 | Bon Homme | South Dakota | 46009 | 1568 | 29 |
1663137 | 1663137 | 2021-08-28 | Bon Homme | South Dakota | 46009 | 1568 | 29 |
1659889 | 1659889 | 2021-08-27 | Bon Homme | South Dakota | 46009 | 1568 | 29 |
1656640 | 1656640 | 2021-08-26 | Bon Homme | South Dakota | 46009 | 1567 | 29 |
1653393 | 1653393 | 2021-08-25 | Bon Homme | South Dakota | 46009 | 1565 | 29 |
1650146 | 1650146 | 2021-08-24 | Bon Homme | South Dakota | 46009 | 1563 | 29 |
1646897 | 1646897 | 2021-08-23 | Bon Homme | South Dakota | 46009 | 1561 | 29 |
1643648 | 1643648 | 2021-08-22 | Bon Homme | South Dakota | 46009 | 1561 | 29 |
1640398 | 1640398 | 2021-08-21 | Bon Homme | South Dakota | 46009 | 1561 | 29 |
1637148 | 1637148 | 2021-08-20 | Bon Homme | South Dakota | 46009 | 1561 | 29 |
1633898 | 1633898 | 2021-08-19 | Bon Homme | South Dakota | 46009 | 1561 | 29 |
1630651 | 1630651 | 2021-08-18 | Bon Homme | South Dakota | 46009 | 1560 | 29 |
1627404 | 1627404 | 2021-08-17 | Bon Homme | South Dakota | 46009 | 1558 | 29 |
1624157 | 1624157 | 2021-08-16 | Bon Homme | South Dakota | 46009 | 1558 | 29 |
1620910 | 1620910 | 2021-08-15 | Bon Homme | South Dakota | 46009 | 1558 | 29 |
1617662 | 1617662 | 2021-08-14 | Bon Homme | South Dakota | 46009 | 1558 | 29 |
1614414 | 1614414 | 2021-08-13 | Bon Homme | South Dakota | 46009 | 1558 | 29 |
1611165 | 1611165 | 2021-08-12 | Bon Homme | South Dakota | 46009 | 1558 | 29 |
1607917 | 1607917 | 2021-08-11 | Bon Homme | South Dakota | 46009 | 1558 | 29 |
1604668 | 1604668 | 2021-08-10 | Bon Homme | South Dakota | 46009 | 1556 | 29 |
1601419 | 1601419 | 2021-08-09 | Bon Homme | South Dakota | 46009 | 1556 | 29 |
1598171 | 1598171 | 2021-08-08 | Bon Homme | South Dakota | 46009 | 1556 | 29 |
1594922 | 1594922 | 2021-08-07 | Bon Homme | South Dakota | 46009 | 1556 | 29 |
1591673 | 1591673 | 2021-08-06 | Bon Homme | South Dakota | 46009 | 1556 | 29 |
1588424 | 1588424 | 2021-08-05 | Bon Homme | South Dakota | 46009 | 1556 | 29 |
1585174 | 1585174 | 2021-08-04 | Bon Homme | South Dakota | 46009 | 1556 | 29 |
1581924 | 1581924 | 2021-08-03 | Bon Homme | South Dakota | 46009 | 1554 | 29 |
1578675 | 1578675 | 2021-08-02 | Bon Homme | South Dakota | 46009 | 1554 | 29 |
1575427 | 1575427 | 2021-08-01 | Bon Homme | South Dakota | 46009 | 1554 | 29 |
1572179 | 1572179 | 2021-07-31 | Bon Homme | South Dakota | 46009 | 1554 | 29 |
1568931 | 1568931 | 2021-07-30 | Bon Homme | South Dakota | 46009 | 1554 | 29 |
1565683 | 1565683 | 2021-07-29 | Bon Homme | South Dakota | 46009 | 1554 | 29 |
1562435 | 1562435 | 2021-07-28 | Bon Homme | South Dakota | 46009 | 1554 | 29 |
1559187 | 1559187 | 2021-07-27 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1555940 | 1555940 | 2021-07-26 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1552693 | 1552693 | 2021-07-25 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1549446 | 1549446 | 2021-07-24 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1546199 | 1546199 | 2021-07-23 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1542952 | 1542952 | 2021-07-22 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1539704 | 1539704 | 2021-07-21 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1536457 | 1536457 | 2021-07-20 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1533209 | 1533209 | 2021-07-19 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1529962 | 1529962 | 2021-07-18 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1526715 | 1526715 | 2021-07-17 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1523468 | 1523468 | 2021-07-16 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1520220 | 1520220 | 2021-07-15 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1516972 | 1516972 | 2021-07-14 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1513725 | 1513725 | 2021-07-13 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1510479 | 1510479 | 2021-07-12 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1507232 | 1507232 | 2021-07-11 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1503986 | 1503986 | 2021-07-10 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1500740 | 1500740 | 2021-07-09 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1497494 | 1497494 | 2021-07-08 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1494247 | 1494247 | 2021-07-07 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1491000 | 1491000 | 2021-07-06 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1487753 | 1487753 | 2021-07-05 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1484506 | 1484506 | 2021-07-04 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1481260 | 1481260 | 2021-07-03 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1478013 | 1478013 | 2021-07-02 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1474767 | 1474767 | 2021-07-01 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1471521 | 1471521 | 2021-06-30 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1468276 | 1468276 | 2021-06-29 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1465031 | 1465031 | 2021-06-28 | Bon Homme | South Dakota | 46009 | 1555 | 28 |
1461786 | 1461786 | 2021-06-27 | Bon Homme | South Dakota | 46009 | 1555 | 28 |
1458541 | 1458541 | 2021-06-26 | Bon Homme | South Dakota | 46009 | 1555 | 28 |
1455296 | 1455296 | 2021-06-25 | Bon Homme | South Dakota | 46009 | 1555 | 28 |
1452051 | 1452051 | 2021-06-24 | Bon Homme | South Dakota | 46009 | 1555 | 28 |
1448805 | 1448805 | 2021-06-23 | Bon Homme | South Dakota | 46009 | 1555 | 28 |
1445560 | 1445560 | 2021-06-22 | Bon Homme | South Dakota | 46009 | 1555 | 28 |
1442315 | 1442315 | 2021-06-21 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1439070 | 1439070 | 2021-06-20 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1435823 | 1435823 | 2021-06-19 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1432576 | 1432576 | 2021-06-18 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1429330 | 1429330 | 2021-06-17 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1426085 | 1426085 | 2021-06-16 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1422838 | 1422838 | 2021-06-15 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1419592 | 1419592 | 2021-06-14 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1416347 | 1416347 | 2021-06-13 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1413101 | 1413101 | 2021-06-12 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1409856 | 1409856 | 2021-06-11 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1406611 | 1406611 | 2021-06-10 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1403365 | 1403365 | 2021-06-09 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1400120 | 1400120 | 2021-06-08 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1396875 | 1396875 | 2021-06-07 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
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);