ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Roberts" 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 |
---|---|---|---|---|---|---|---|
1949114 | 1949114 | 2021-11-24 | Roberts | South Dakota | 46109 | 1636 | 45 |
1945863 | 1945863 | 2021-11-23 | Roberts | South Dakota | 46109 | 1632 | 45 |
1942612 | 1942612 | 2021-11-22 | Roberts | South Dakota | 46109 | 1624 | 45 |
1939362 | 1939362 | 2021-11-21 | Roberts | South Dakota | 46109 | 1621 | 45 |
1936112 | 1936112 | 2021-11-20 | Roberts | South Dakota | 46109 | 1621 | 45 |
1932862 | 1932862 | 2021-11-19 | Roberts | South Dakota | 46109 | 1621 | 45 |
1929611 | 1929611 | 2021-11-18 | Roberts | South Dakota | 46109 | 1615 | 45 |
1926361 | 1926361 | 2021-11-17 | Roberts | South Dakota | 46109 | 1611 | 44 |
1923111 | 1923111 | 2021-11-16 | Roberts | South Dakota | 46109 | 1609 | 44 |
1919862 | 1919862 | 2021-11-15 | Roberts | South Dakota | 46109 | 1599 | 44 |
1916612 | 1916612 | 2021-11-14 | Roberts | South Dakota | 46109 | 1595 | 44 |
1913362 | 1913362 | 2021-11-13 | Roberts | South Dakota | 46109 | 1595 | 44 |
1910112 | 1910112 | 2021-11-12 | Roberts | South Dakota | 46109 | 1595 | 44 |
1906863 | 1906863 | 2021-11-11 | Roberts | South Dakota | 46109 | 1594 | 44 |
1903614 | 1903614 | 2021-11-10 | Roberts | South Dakota | 46109 | 1594 | 44 |
1900364 | 1900364 | 2021-11-09 | Roberts | South Dakota | 46109 | 1590 | 43 |
1897114 | 1897114 | 2021-11-08 | Roberts | South Dakota | 46109 | 1581 | 43 |
1893864 | 1893864 | 2021-11-07 | Roberts | South Dakota | 46109 | 1578 | 43 |
1890614 | 1890614 | 2021-11-06 | Roberts | South Dakota | 46109 | 1578 | 43 |
1887364 | 1887364 | 2021-11-05 | Roberts | South Dakota | 46109 | 1578 | 43 |
1884114 | 1884114 | 2021-11-04 | Roberts | South Dakota | 46109 | 1575 | 43 |
1880865 | 1880865 | 2021-11-03 | Roberts | South Dakota | 46109 | 1571 | 43 |
1877616 | 1877616 | 2021-11-02 | Roberts | South Dakota | 46109 | 1564 | 43 |
1874367 | 1874367 | 2021-11-01 | Roberts | South Dakota | 46109 | 1562 | 43 |
1871118 | 1871118 | 2021-10-31 | Roberts | South Dakota | 46109 | 1560 | 43 |
1867869 | 1867869 | 2021-10-30 | Roberts | South Dakota | 46109 | 1560 | 43 |
1864620 | 1864620 | 2021-10-29 | Roberts | South Dakota | 46109 | 1560 | 43 |
1861371 | 1861371 | 2021-10-28 | Roberts | South Dakota | 46109 | 1553 | 43 |
1858122 | 1858122 | 2021-10-27 | Roberts | South Dakota | 46109 | 1551 | 43 |
1854873 | 1854873 | 2021-10-26 | Roberts | South Dakota | 46109 | 1545 | 43 |
1851624 | 1851624 | 2021-10-25 | Roberts | South Dakota | 46109 | 1539 | 43 |
1848374 | 1848374 | 2021-10-24 | Roberts | South Dakota | 46109 | 1535 | 43 |
1845124 | 1845124 | 2021-10-23 | Roberts | South Dakota | 46109 | 1535 | 43 |
1841874 | 1841874 | 2021-10-22 | Roberts | South Dakota | 46109 | 1535 | 43 |
1838625 | 1838625 | 2021-10-21 | Roberts | South Dakota | 46109 | 1531 | 43 |
1835376 | 1835376 | 2021-10-20 | Roberts | South Dakota | 46109 | 1530 | 43 |
1832127 | 1832127 | 2021-10-19 | Roberts | South Dakota | 46109 | 1525 | 43 |
1828878 | 1828878 | 2021-10-18 | Roberts | South Dakota | 46109 | 1513 | 43 |
1825629 | 1825629 | 2021-10-17 | Roberts | South Dakota | 46109 | 1509 | 43 |
1822380 | 1822380 | 2021-10-16 | Roberts | South Dakota | 46109 | 1509 | 43 |
1819131 | 1819131 | 2021-10-15 | Roberts | South Dakota | 46109 | 1509 | 43 |
1815882 | 1815882 | 2021-10-14 | Roberts | South Dakota | 46109 | 1505 | 43 |
1812634 | 1812634 | 2021-10-13 | Roberts | South Dakota | 46109 | 1503 | 43 |
1809385 | 1809385 | 2021-10-12 | Roberts | South Dakota | 46109 | 1498 | 43 |
1806135 | 1806135 | 2021-10-11 | Roberts | South Dakota | 46109 | 1497 | 43 |
1802885 | 1802885 | 2021-10-10 | Roberts | South Dakota | 46109 | 1497 | 43 |
1799636 | 1799636 | 2021-10-09 | Roberts | South Dakota | 46109 | 1497 | 43 |
1796387 | 1796387 | 2021-10-08 | Roberts | South Dakota | 46109 | 1497 | 43 |
1793138 | 1793138 | 2021-10-07 | Roberts | South Dakota | 46109 | 1495 | 43 |
1789889 | 1789889 | 2021-10-06 | Roberts | South Dakota | 46109 | 1495 | 43 |
1786641 | 1786641 | 2021-10-05 | Roberts | South Dakota | 46109 | 1487 | 43 |
1783392 | 1783392 | 2021-10-04 | Roberts | South Dakota | 46109 | 1485 | 43 |
1780143 | 1780143 | 2021-10-03 | Roberts | South Dakota | 46109 | 1484 | 43 |
1776893 | 1776893 | 2021-10-02 | Roberts | South Dakota | 46109 | 1484 | 43 |
1773643 | 1773643 | 2021-10-01 | Roberts | South Dakota | 46109 | 1484 | 43 |
1770393 | 1770393 | 2021-09-30 | Roberts | South Dakota | 46109 | 1482 | 43 |
1767144 | 1767144 | 2021-09-29 | Roberts | South Dakota | 46109 | 1481 | 43 |
1763895 | 1763895 | 2021-09-28 | Roberts | South Dakota | 46109 | 1481 | 43 |
1760646 | 1760646 | 2021-09-27 | Roberts | South Dakota | 46109 | 1478 | 43 |
1757398 | 1757398 | 2021-09-26 | Roberts | South Dakota | 46109 | 1475 | 43 |
1754150 | 1754150 | 2021-09-25 | Roberts | South Dakota | 46109 | 1475 | 43 |
1750902 | 1750902 | 2021-09-24 | Roberts | South Dakota | 46109 | 1475 | 43 |
1747653 | 1747653 | 2021-09-23 | Roberts | South Dakota | 46109 | 1472 | 43 |
1744403 | 1744403 | 2021-09-22 | Roberts | South Dakota | 46109 | 1469 | 43 |
1741154 | 1741154 | 2021-09-21 | Roberts | South Dakota | 46109 | 1468 | 43 |
1737905 | 1737905 | 2021-09-20 | Roberts | South Dakota | 46109 | 1465 | 43 |
1734655 | 1734655 | 2021-09-19 | Roberts | South Dakota | 46109 | 1463 | 43 |
1731405 | 1731405 | 2021-09-18 | Roberts | South Dakota | 46109 | 1463 | 43 |
1728155 | 1728155 | 2021-09-17 | Roberts | South Dakota | 46109 | 1463 | 43 |
1724906 | 1724906 | 2021-09-16 | Roberts | South Dakota | 46109 | 1461 | 43 |
1721657 | 1721657 | 2021-09-15 | Roberts | South Dakota | 46109 | 1457 | 43 |
1718409 | 1718409 | 2021-09-14 | Roberts | South Dakota | 46109 | 1456 | 43 |
1715161 | 1715161 | 2021-09-13 | Roberts | South Dakota | 46109 | 1454 | 43 |
1711915 | 1711915 | 2021-09-12 | Roberts | South Dakota | 46109 | 1452 | 43 |
1708668 | 1708668 | 2021-09-11 | Roberts | South Dakota | 46109 | 1452 | 43 |
1705421 | 1705421 | 2021-09-10 | Roberts | South Dakota | 46109 | 1452 | 43 |
1702171 | 1702171 | 2021-09-09 | Roberts | South Dakota | 46109 | 1450 | 43 |
1698922 | 1698922 | 2021-09-08 | Roberts | South Dakota | 46109 | 1446 | 43 |
1695674 | 1695674 | 2021-09-07 | Roberts | South Dakota | 46109 | 1442 | 43 |
1692426 | 1692426 | 2021-09-06 | Roberts | South Dakota | 46109 | 1442 | 43 |
1689177 | 1689177 | 2021-09-05 | Roberts | South Dakota | 46109 | 1442 | 43 |
1685927 | 1685927 | 2021-09-04 | Roberts | South Dakota | 46109 | 1442 | 43 |
1682676 | 1682676 | 2021-09-03 | Roberts | South Dakota | 46109 | 1442 | 43 |
1679426 | 1679426 | 2021-09-02 | Roberts | South Dakota | 46109 | 1441 | 43 |
1676178 | 1676178 | 2021-09-01 | Roberts | South Dakota | 46109 | 1438 | 43 |
1672931 | 1672931 | 2021-08-31 | Roberts | South Dakota | 46109 | 1437 | 43 |
1669683 | 1669683 | 2021-08-30 | Roberts | South Dakota | 46109 | 1433 | 43 |
1666436 | 1666436 | 2021-08-29 | Roberts | South Dakota | 46109 | 1433 | 43 |
1663188 | 1663188 | 2021-08-28 | Roberts | South Dakota | 46109 | 1433 | 43 |
1659940 | 1659940 | 2021-08-27 | Roberts | South Dakota | 46109 | 1433 | 43 |
1656691 | 1656691 | 2021-08-26 | Roberts | South Dakota | 46109 | 1433 | 43 |
1653444 | 1653444 | 2021-08-25 | Roberts | South Dakota | 46109 | 1432 | 43 |
1650197 | 1650197 | 2021-08-24 | Roberts | South Dakota | 46109 | 1431 | 43 |
1646948 | 1646948 | 2021-08-23 | Roberts | South Dakota | 46109 | 1425 | 43 |
1643699 | 1643699 | 2021-08-22 | Roberts | South Dakota | 46109 | 1424 | 43 |
1640449 | 1640449 | 2021-08-21 | Roberts | South Dakota | 46109 | 1424 | 43 |
1637199 | 1637199 | 2021-08-20 | Roberts | South Dakota | 46109 | 1424 | 43 |
1633949 | 1633949 | 2021-08-19 | Roberts | South Dakota | 46109 | 1423 | 43 |
1630702 | 1630702 | 2021-08-18 | Roberts | South Dakota | 46109 | 1421 | 43 |
1627455 | 1627455 | 2021-08-17 | Roberts | South Dakota | 46109 | 1421 | 43 |
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);