ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
748 rows where county = "Hand" 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 |
---|---|---|---|---|---|---|---|
1718383 | 1718383 | 2021-09-14 | Hand | South Dakota | 46059 | 373 | 6 |
1715135 | 1715135 | 2021-09-13 | Hand | South Dakota | 46059 | 372 | 6 |
1711889 | 1711889 | 2021-09-12 | Hand | South Dakota | 46059 | 370 | 6 |
1708642 | 1708642 | 2021-09-11 | Hand | South Dakota | 46059 | 370 | 6 |
1705395 | 1705395 | 2021-09-10 | Hand | South Dakota | 46059 | 370 | 6 |
1702145 | 1702145 | 2021-09-09 | Hand | South Dakota | 46059 | 369 | 6 |
1698896 | 1698896 | 2021-09-08 | Hand | South Dakota | 46059 | 368 | 6 |
1695648 | 1695648 | 2021-09-07 | Hand | South Dakota | 46059 | 368 | 6 |
1692400 | 1692400 | 2021-09-06 | Hand | South Dakota | 46059 | 368 | 6 |
1689151 | 1689151 | 2021-09-05 | Hand | South Dakota | 46059 | 368 | 6 |
1685901 | 1685901 | 2021-09-04 | Hand | South Dakota | 46059 | 368 | 6 |
1682650 | 1682650 | 2021-09-03 | Hand | South Dakota | 46059 | 368 | 6 |
1679400 | 1679400 | 2021-09-02 | Hand | South Dakota | 46059 | 368 | 6 |
1676152 | 1676152 | 2021-09-01 | Hand | South Dakota | 46059 | 367 | 6 |
1672905 | 1672905 | 2021-08-31 | Hand | South Dakota | 46059 | 367 | 6 |
1669657 | 1669657 | 2021-08-30 | Hand | South Dakota | 46059 | 367 | 6 |
1666410 | 1666410 | 2021-08-29 | Hand | South Dakota | 46059 | 367 | 6 |
1663162 | 1663162 | 2021-08-28 | Hand | South Dakota | 46059 | 367 | 6 |
1659914 | 1659914 | 2021-08-27 | Hand | South Dakota | 46059 | 367 | 6 |
1656665 | 1656665 | 2021-08-26 | Hand | South Dakota | 46059 | 367 | 6 |
1653418 | 1653418 | 2021-08-25 | Hand | South Dakota | 46059 | 367 | 6 |
1650171 | 1650171 | 2021-08-24 | Hand | South Dakota | 46059 | 367 | 6 |
1646922 | 1646922 | 2021-08-23 | Hand | South Dakota | 46059 | 366 | 6 |
1643673 | 1643673 | 2021-08-22 | Hand | South Dakota | 46059 | 366 | 6 |
1640423 | 1640423 | 2021-08-21 | Hand | South Dakota | 46059 | 366 | 6 |
1637173 | 1637173 | 2021-08-20 | Hand | South Dakota | 46059 | 366 | 6 |
1633923 | 1633923 | 2021-08-19 | Hand | South Dakota | 46059 | 366 | 6 |
1630676 | 1630676 | 2021-08-18 | Hand | South Dakota | 46059 | 366 | 6 |
1627429 | 1627429 | 2021-08-17 | Hand | South Dakota | 46059 | 366 | 6 |
1624182 | 1624182 | 2021-08-16 | Hand | South Dakota | 46059 | 366 | 6 |
1620935 | 1620935 | 2021-08-15 | Hand | South Dakota | 46059 | 366 | 6 |
1617687 | 1617687 | 2021-08-14 | Hand | South Dakota | 46059 | 366 | 6 |
1614439 | 1614439 | 2021-08-13 | Hand | South Dakota | 46059 | 366 | 6 |
1611190 | 1611190 | 2021-08-12 | Hand | South Dakota | 46059 | 366 | 6 |
1607942 | 1607942 | 2021-08-11 | Hand | South Dakota | 46059 | 366 | 6 |
1604693 | 1604693 | 2021-08-10 | Hand | South Dakota | 46059 | 366 | 6 |
1601444 | 1601444 | 2021-08-09 | Hand | South Dakota | 46059 | 366 | 6 |
1598196 | 1598196 | 2021-08-08 | Hand | South Dakota | 46059 | 366 | 6 |
1594947 | 1594947 | 2021-08-07 | Hand | South Dakota | 46059 | 366 | 6 |
1591698 | 1591698 | 2021-08-06 | Hand | South Dakota | 46059 | 366 | 6 |
1588449 | 1588449 | 2021-08-05 | Hand | South Dakota | 46059 | 366 | 6 |
1585199 | 1585199 | 2021-08-04 | Hand | South Dakota | 46059 | 366 | 6 |
1581949 | 1581949 | 2021-08-03 | Hand | South Dakota | 46059 | 365 | 6 |
1578700 | 1578700 | 2021-08-02 | Hand | South Dakota | 46059 | 365 | 6 |
1575452 | 1575452 | 2021-08-01 | Hand | South Dakota | 46059 | 365 | 6 |
1572204 | 1572204 | 2021-07-31 | Hand | South Dakota | 46059 | 365 | 6 |
1568956 | 1568956 | 2021-07-30 | Hand | South Dakota | 46059 | 365 | 6 |
1565708 | 1565708 | 2021-07-29 | Hand | South Dakota | 46059 | 365 | 6 |
1562460 | 1562460 | 2021-07-28 | Hand | South Dakota | 46059 | 365 | 6 |
1559212 | 1559212 | 2021-07-27 | Hand | South Dakota | 46059 | 365 | 6 |
1555965 | 1555965 | 2021-07-26 | Hand | South Dakota | 46059 | 365 | 6 |
1552718 | 1552718 | 2021-07-25 | Hand | South Dakota | 46059 | 365 | 6 |
1549471 | 1549471 | 2021-07-24 | Hand | South Dakota | 46059 | 365 | 6 |
1546224 | 1546224 | 2021-07-23 | Hand | South Dakota | 46059 | 365 | 6 |
1542977 | 1542977 | 2021-07-22 | Hand | South Dakota | 46059 | 365 | 6 |
1539729 | 1539729 | 2021-07-21 | Hand | South Dakota | 46059 | 365 | 6 |
1536482 | 1536482 | 2021-07-20 | Hand | South Dakota | 46059 | 365 | 6 |
1533234 | 1533234 | 2021-07-19 | Hand | South Dakota | 46059 | 365 | 6 |
1529987 | 1529987 | 2021-07-18 | Hand | South Dakota | 46059 | 365 | 6 |
1526740 | 1526740 | 2021-07-17 | Hand | South Dakota | 46059 | 365 | 6 |
1523493 | 1523493 | 2021-07-16 | Hand | South Dakota | 46059 | 365 | 6 |
1520245 | 1520245 | 2021-07-15 | Hand | South Dakota | 46059 | 365 | 6 |
1516997 | 1516997 | 2021-07-14 | Hand | South Dakota | 46059 | 365 | 6 |
1513750 | 1513750 | 2021-07-13 | Hand | South Dakota | 46059 | 365 | 6 |
1510504 | 1510504 | 2021-07-12 | Hand | South Dakota | 46059 | 365 | 6 |
1507257 | 1507257 | 2021-07-11 | Hand | South Dakota | 46059 | 365 | 6 |
1504011 | 1504011 | 2021-07-10 | Hand | South Dakota | 46059 | 365 | 6 |
1500765 | 1500765 | 2021-07-09 | Hand | South Dakota | 46059 | 365 | 6 |
1497519 | 1497519 | 2021-07-08 | Hand | South Dakota | 46059 | 365 | 6 |
1494272 | 1494272 | 2021-07-07 | Hand | South Dakota | 46059 | 365 | 6 |
1491025 | 1491025 | 2021-07-06 | Hand | South Dakota | 46059 | 365 | 6 |
1487778 | 1487778 | 2021-07-05 | Hand | South Dakota | 46059 | 365 | 6 |
1484531 | 1484531 | 2021-07-04 | Hand | South Dakota | 46059 | 365 | 6 |
1481285 | 1481285 | 2021-07-03 | Hand | South Dakota | 46059 | 365 | 6 |
1478038 | 1478038 | 2021-07-02 | Hand | South Dakota | 46059 | 365 | 6 |
1474792 | 1474792 | 2021-07-01 | Hand | South Dakota | 46059 | 365 | 6 |
1471546 | 1471546 | 2021-06-30 | Hand | South Dakota | 46059 | 365 | 6 |
1468301 | 1468301 | 2021-06-29 | Hand | South Dakota | 46059 | 364 | 6 |
1465056 | 1465056 | 2021-06-28 | Hand | South Dakota | 46059 | 364 | 6 |
1461811 | 1461811 | 2021-06-27 | Hand | South Dakota | 46059 | 364 | 6 |
1458566 | 1458566 | 2021-06-26 | Hand | South Dakota | 46059 | 364 | 6 |
1455321 | 1455321 | 2021-06-25 | Hand | South Dakota | 46059 | 364 | 6 |
1452076 | 1452076 | 2021-06-24 | Hand | South Dakota | 46059 | 364 | 6 |
1448830 | 1448830 | 2021-06-23 | Hand | South Dakota | 46059 | 364 | 6 |
1445585 | 1445585 | 2021-06-22 | Hand | South Dakota | 46059 | 364 | 6 |
1442340 | 1442340 | 2021-06-21 | Hand | South Dakota | 46059 | 364 | 6 |
1439095 | 1439095 | 2021-06-20 | Hand | South Dakota | 46059 | 364 | 6 |
1435848 | 1435848 | 2021-06-19 | Hand | South Dakota | 46059 | 364 | 6 |
1432601 | 1432601 | 2021-06-18 | Hand | South Dakota | 46059 | 364 | 6 |
1429355 | 1429355 | 2021-06-17 | Hand | South Dakota | 46059 | 364 | 6 |
1426110 | 1426110 | 2021-06-16 | Hand | South Dakota | 46059 | 364 | 6 |
1422863 | 1422863 | 2021-06-15 | Hand | South Dakota | 46059 | 364 | 6 |
1419617 | 1419617 | 2021-06-14 | Hand | South Dakota | 46059 | 364 | 6 |
1416372 | 1416372 | 2021-06-13 | Hand | South Dakota | 46059 | 364 | 6 |
1413126 | 1413126 | 2021-06-12 | Hand | South Dakota | 46059 | 364 | 6 |
1409881 | 1409881 | 2021-06-11 | Hand | South Dakota | 46059 | 364 | 6 |
1406636 | 1406636 | 2021-06-10 | Hand | South Dakota | 46059 | 363 | 6 |
1403390 | 1403390 | 2021-06-09 | Hand | South Dakota | 46059 | 363 | 6 |
1400145 | 1400145 | 2021-06-08 | Hand | South Dakota | 46059 | 363 | 6 |
1396900 | 1396900 | 2021-06-07 | Hand | South Dakota | 46059 | 363 | 6 |
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);