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 |
---|---|---|---|---|---|---|---|
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 |
1624208 | 1624208 | 2021-08-16 | Roberts | South Dakota | 46109 | 1415 | 43 |
1620961 | 1620961 | 2021-08-15 | Roberts | South Dakota | 46109 | 1413 | 43 |
1617713 | 1617713 | 2021-08-14 | Roberts | South Dakota | 46109 | 1413 | 43 |
1614465 | 1614465 | 2021-08-13 | Roberts | South Dakota | 46109 | 1413 | 43 |
1611216 | 1611216 | 2021-08-12 | Roberts | South Dakota | 46109 | 1413 | 43 |
1607968 | 1607968 | 2021-08-11 | Roberts | South Dakota | 46109 | 1413 | 43 |
1604719 | 1604719 | 2021-08-10 | Roberts | South Dakota | 46109 | 1406 | 43 |
1601470 | 1601470 | 2021-08-09 | Roberts | South Dakota | 46109 | 1406 | 43 |
1598222 | 1598222 | 2021-08-08 | Roberts | South Dakota | 46109 | 1406 | 43 |
1594973 | 1594973 | 2021-08-07 | Roberts | South Dakota | 46109 | 1406 | 43 |
1591724 | 1591724 | 2021-08-06 | Roberts | South Dakota | 46109 | 1406 | 43 |
1588475 | 1588475 | 2021-08-05 | Roberts | South Dakota | 46109 | 1406 | 43 |
1585225 | 1585225 | 2021-08-04 | Roberts | South Dakota | 46109 | 1406 | 43 |
1581975 | 1581975 | 2021-08-03 | Roberts | South Dakota | 46109 | 1405 | 43 |
1578726 | 1578726 | 2021-08-02 | Roberts | South Dakota | 46109 | 1405 | 43 |
1575478 | 1575478 | 2021-08-01 | Roberts | South Dakota | 46109 | 1405 | 43 |
1572230 | 1572230 | 2021-07-31 | Roberts | South Dakota | 46109 | 1405 | 43 |
1568982 | 1568982 | 2021-07-30 | Roberts | South Dakota | 46109 | 1405 | 43 |
1565734 | 1565734 | 2021-07-29 | Roberts | South Dakota | 46109 | 1405 | 43 |
1562486 | 1562486 | 2021-07-28 | Roberts | South Dakota | 46109 | 1405 | 43 |
1559238 | 1559238 | 2021-07-27 | Roberts | South Dakota | 46109 | 1401 | 43 |
1555991 | 1555991 | 2021-07-26 | Roberts | South Dakota | 46109 | 1401 | 43 |
1552744 | 1552744 | 2021-07-25 | Roberts | South Dakota | 46109 | 1401 | 43 |
1549497 | 1549497 | 2021-07-24 | Roberts | South Dakota | 46109 | 1401 | 43 |
1546250 | 1546250 | 2021-07-23 | Roberts | South Dakota | 46109 | 1401 | 43 |
1543003 | 1543003 | 2021-07-22 | Roberts | South Dakota | 46109 | 1401 | 43 |
1539755 | 1539755 | 2021-07-21 | Roberts | South Dakota | 46109 | 1401 | 43 |
1536508 | 1536508 | 2021-07-20 | Roberts | South Dakota | 46109 | 1399 | 43 |
1533260 | 1533260 | 2021-07-19 | Roberts | South Dakota | 46109 | 1399 | 43 |
1530013 | 1530013 | 2021-07-18 | Roberts | South Dakota | 46109 | 1399 | 43 |
1526766 | 1526766 | 2021-07-17 | Roberts | South Dakota | 46109 | 1399 | 43 |
1523519 | 1523519 | 2021-07-16 | Roberts | South Dakota | 46109 | 1399 | 43 |
1520271 | 1520271 | 2021-07-15 | Roberts | South Dakota | 46109 | 1399 | 43 |
1517023 | 1517023 | 2021-07-14 | Roberts | South Dakota | 46109 | 1399 | 43 |
1513776 | 1513776 | 2021-07-13 | Roberts | South Dakota | 46109 | 1397 | 42 |
1510530 | 1510530 | 2021-07-12 | Roberts | South Dakota | 46109 | 1397 | 42 |
1507283 | 1507283 | 2021-07-11 | Roberts | South Dakota | 46109 | 1397 | 42 |
1504037 | 1504037 | 2021-07-10 | Roberts | South Dakota | 46109 | 1397 | 42 |
1500791 | 1500791 | 2021-07-09 | Roberts | South Dakota | 46109 | 1397 | 42 |
1497545 | 1497545 | 2021-07-08 | Roberts | South Dakota | 46109 | 1397 | 42 |
1494298 | 1494298 | 2021-07-07 | Roberts | South Dakota | 46109 | 1397 | 42 |
1491051 | 1491051 | 2021-07-06 | Roberts | South Dakota | 46109 | 1396 | 42 |
1487804 | 1487804 | 2021-07-05 | Roberts | South Dakota | 46109 | 1396 | 42 |
1484557 | 1484557 | 2021-07-04 | Roberts | South Dakota | 46109 | 1396 | 42 |
1481311 | 1481311 | 2021-07-03 | Roberts | South Dakota | 46109 | 1396 | 42 |
1478064 | 1478064 | 2021-07-02 | Roberts | South Dakota | 46109 | 1396 | 42 |
1474818 | 1474818 | 2021-07-01 | Roberts | South Dakota | 46109 | 1396 | 42 |
1471572 | 1471572 | 2021-06-30 | Roberts | South Dakota | 46109 | 1394 | 42 |
1468327 | 1468327 | 2021-06-29 | Roberts | South Dakota | 46109 | 1393 | 42 |
1465082 | 1465082 | 2021-06-28 | Roberts | South Dakota | 46109 | 1392 | 42 |
1461837 | 1461837 | 2021-06-27 | Roberts | South Dakota | 46109 | 1390 | 42 |
1458592 | 1458592 | 2021-06-26 | Roberts | South Dakota | 46109 | 1390 | 42 |
1455347 | 1455347 | 2021-06-25 | Roberts | South Dakota | 46109 | 1390 | 42 |
1452102 | 1452102 | 2021-06-24 | Roberts | South Dakota | 46109 | 1388 | 41 |
1448856 | 1448856 | 2021-06-23 | Roberts | South Dakota | 46109 | 1387 | 41 |
1445611 | 1445611 | 2021-06-22 | Roberts | South Dakota | 46109 | 1385 | 41 |
1442366 | 1442366 | 2021-06-21 | Roberts | South Dakota | 46109 | 1384 | 41 |
1439121 | 1439121 | 2021-06-20 | Roberts | South Dakota | 46109 | 1384 | 41 |
1435874 | 1435874 | 2021-06-19 | Roberts | South Dakota | 46109 | 1384 | 41 |
1432627 | 1432627 | 2021-06-18 | Roberts | South Dakota | 46109 | 1384 | 41 |
1429381 | 1429381 | 2021-06-17 | Roberts | South Dakota | 46109 | 1384 | 41 |
1426136 | 1426136 | 2021-06-16 | Roberts | South Dakota | 46109 | 1380 | 41 |
1422889 | 1422889 | 2021-06-15 | Roberts | South Dakota | 46109 | 1380 | 41 |
1419643 | 1419643 | 2021-06-14 | Roberts | South Dakota | 46109 | 1378 | 41 |
1416398 | 1416398 | 2021-06-13 | Roberts | South Dakota | 46109 | 1378 | 41 |
1413152 | 1413152 | 2021-06-12 | Roberts | South Dakota | 46109 | 1378 | 41 |
1409907 | 1409907 | 2021-06-11 | Roberts | South Dakota | 46109 | 1378 | 41 |
1406662 | 1406662 | 2021-06-10 | Roberts | South Dakota | 46109 | 1378 | 41 |
1403416 | 1403416 | 2021-06-09 | Roberts | South Dakota | 46109 | 1379 | 41 |
1400171 | 1400171 | 2021-06-08 | Roberts | South Dakota | 46109 | 1378 | 41 |
1396926 | 1396926 | 2021-06-07 | Roberts | South Dakota | 46109 | 1378 | 41 |
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);