ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Lincoln" 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 |
---|---|---|---|---|---|---|---|
1624194 | 1624194 | 2021-08-16 | Lincoln | South Dakota | 46083 | 8860 | 78 |
1620947 | 1620947 | 2021-08-15 | Lincoln | South Dakota | 46083 | 8851 | 78 |
1617699 | 1617699 | 2021-08-14 | Lincoln | South Dakota | 46083 | 8851 | 78 |
1614451 | 1614451 | 2021-08-13 | Lincoln | South Dakota | 46083 | 8851 | 78 |
1611202 | 1611202 | 2021-08-12 | Lincoln | South Dakota | 46083 | 8834 | 78 |
1607954 | 1607954 | 2021-08-11 | Lincoln | South Dakota | 46083 | 8824 | 78 |
1604705 | 1604705 | 2021-08-10 | Lincoln | South Dakota | 46083 | 8766 | 78 |
1601456 | 1601456 | 2021-08-09 | Lincoln | South Dakota | 46083 | 8766 | 78 |
1598208 | 1598208 | 2021-08-08 | Lincoln | South Dakota | 46083 | 8766 | 78 |
1594959 | 1594959 | 2021-08-07 | Lincoln | South Dakota | 46083 | 8766 | 78 |
1591710 | 1591710 | 2021-08-06 | Lincoln | South Dakota | 46083 | 8766 | 78 |
1588461 | 1588461 | 2021-08-05 | Lincoln | South Dakota | 46083 | 8766 | 78 |
1585211 | 1585211 | 2021-08-04 | Lincoln | South Dakota | 46083 | 8766 | 78 |
1581961 | 1581961 | 2021-08-03 | Lincoln | South Dakota | 46083 | 8751 | 78 |
1578712 | 1578712 | 2021-08-02 | Lincoln | South Dakota | 46083 | 8751 | 78 |
1575464 | 1575464 | 2021-08-01 | Lincoln | South Dakota | 46083 | 8751 | 78 |
1572216 | 1572216 | 2021-07-31 | Lincoln | South Dakota | 46083 | 8751 | 78 |
1568968 | 1568968 | 2021-07-30 | Lincoln | South Dakota | 46083 | 8751 | 78 |
1565720 | 1565720 | 2021-07-29 | Lincoln | South Dakota | 46083 | 8751 | 78 |
1562472 | 1562472 | 2021-07-28 | Lincoln | South Dakota | 46083 | 8751 | 78 |
1559224 | 1559224 | 2021-07-27 | Lincoln | South Dakota | 46083 | 8736 | 78 |
1555977 | 1555977 | 2021-07-26 | Lincoln | South Dakota | 46083 | 8736 | 78 |
1552730 | 1552730 | 2021-07-25 | Lincoln | South Dakota | 46083 | 8736 | 78 |
1549483 | 1549483 | 2021-07-24 | Lincoln | South Dakota | 46083 | 8736 | 78 |
1546236 | 1546236 | 2021-07-23 | Lincoln | South Dakota | 46083 | 8736 | 78 |
1542989 | 1542989 | 2021-07-22 | Lincoln | South Dakota | 46083 | 8736 | 78 |
1539741 | 1539741 | 2021-07-21 | Lincoln | South Dakota | 46083 | 8736 | 78 |
1536494 | 1536494 | 2021-07-20 | Lincoln | South Dakota | 46083 | 8725 | 78 |
1533246 | 1533246 | 2021-07-19 | Lincoln | South Dakota | 46083 | 8725 | 78 |
1529999 | 1529999 | 2021-07-18 | Lincoln | South Dakota | 46083 | 8725 | 78 |
1526752 | 1526752 | 2021-07-17 | Lincoln | South Dakota | 46083 | 8725 | 78 |
1523505 | 1523505 | 2021-07-16 | Lincoln | South Dakota | 46083 | 8725 | 78 |
1520257 | 1520257 | 2021-07-15 | Lincoln | South Dakota | 46083 | 8725 | 78 |
1517009 | 1517009 | 2021-07-14 | Lincoln | South Dakota | 46083 | 8725 | 78 |
1513762 | 1513762 | 2021-07-13 | Lincoln | South Dakota | 46083 | 8725 | 78 |
1510516 | 1510516 | 2021-07-12 | Lincoln | South Dakota | 46083 | 8725 | 78 |
1507269 | 1507269 | 2021-07-11 | Lincoln | South Dakota | 46083 | 8725 | 78 |
1504023 | 1504023 | 2021-07-10 | Lincoln | South Dakota | 46083 | 8725 | 78 |
1500777 | 1500777 | 2021-07-09 | Lincoln | South Dakota | 46083 | 8725 | 78 |
1497531 | 1497531 | 2021-07-08 | Lincoln | South Dakota | 46083 | 8725 | 78 |
1494284 | 1494284 | 2021-07-07 | Lincoln | South Dakota | 46083 | 8725 | 78 |
1491037 | 1491037 | 2021-07-06 | Lincoln | South Dakota | 46083 | 8722 | 78 |
1487790 | 1487790 | 2021-07-05 | Lincoln | South Dakota | 46083 | 8722 | 78 |
1484543 | 1484543 | 2021-07-04 | Lincoln | South Dakota | 46083 | 8722 | 78 |
1481297 | 1481297 | 2021-07-03 | Lincoln | South Dakota | 46083 | 8722 | 78 |
1478050 | 1478050 | 2021-07-02 | Lincoln | South Dakota | 46083 | 8722 | 78 |
1474804 | 1474804 | 2021-07-01 | Lincoln | South Dakota | 46083 | 8722 | 78 |
1471558 | 1471558 | 2021-06-30 | Lincoln | South Dakota | 46083 | 8722 | 78 |
1468313 | 1468313 | 2021-06-29 | Lincoln | South Dakota | 46083 | 8722 | 78 |
1465068 | 1465068 | 2021-06-28 | Lincoln | South Dakota | 46083 | 8722 | 78 |
1461823 | 1461823 | 2021-06-27 | Lincoln | South Dakota | 46083 | 8722 | 78 |
1458578 | 1458578 | 2021-06-26 | Lincoln | South Dakota | 46083 | 8722 | 78 |
1455333 | 1455333 | 2021-06-25 | Lincoln | South Dakota | 46083 | 8722 | 78 |
1452088 | 1452088 | 2021-06-24 | Lincoln | South Dakota | 46083 | 8722 | 78 |
1448842 | 1448842 | 2021-06-23 | Lincoln | South Dakota | 46083 | 8722 | 78 |
1445597 | 1445597 | 2021-06-22 | Lincoln | South Dakota | 46083 | 8721 | 78 |
1442352 | 1442352 | 2021-06-21 | Lincoln | South Dakota | 46083 | 8721 | 78 |
1439107 | 1439107 | 2021-06-20 | Lincoln | South Dakota | 46083 | 8720 | 78 |
1435860 | 1435860 | 2021-06-19 | Lincoln | South Dakota | 46083 | 8720 | 78 |
1432613 | 1432613 | 2021-06-18 | Lincoln | South Dakota | 46083 | 8720 | 78 |
1429367 | 1429367 | 2021-06-17 | Lincoln | South Dakota | 46083 | 8720 | 78 |
1426122 | 1426122 | 2021-06-16 | Lincoln | South Dakota | 46083 | 8719 | 78 |
1422875 | 1422875 | 2021-06-15 | Lincoln | South Dakota | 46083 | 8717 | 78 |
1419629 | 1419629 | 2021-06-14 | Lincoln | South Dakota | 46083 | 8715 | 78 |
1416384 | 1416384 | 2021-06-13 | Lincoln | South Dakota | 46083 | 8715 | 78 |
1413138 | 1413138 | 2021-06-12 | Lincoln | South Dakota | 46083 | 8715 | 78 |
1409893 | 1409893 | 2021-06-11 | Lincoln | South Dakota | 46083 | 8715 | 78 |
1406648 | 1406648 | 2021-06-10 | Lincoln | South Dakota | 46083 | 8717 | 78 |
1403402 | 1403402 | 2021-06-09 | Lincoln | South Dakota | 46083 | 8716 | 78 |
1400157 | 1400157 | 2021-06-08 | Lincoln | South Dakota | 46083 | 8715 | 78 |
1396912 | 1396912 | 2021-06-07 | Lincoln | South Dakota | 46083 | 8715 | 78 |
1393665 | 1393665 | 2021-06-06 | Lincoln | South Dakota | 46083 | 8716 | 78 |
1390420 | 1390420 | 2021-06-05 | Lincoln | South Dakota | 46083 | 8716 | 78 |
1387175 | 1387175 | 2021-06-04 | Lincoln | South Dakota | 46083 | 8716 | 78 |
1383930 | 1383930 | 2021-06-03 | Lincoln | South Dakota | 46083 | 8712 | 78 |
1380684 | 1380684 | 2021-06-02 | Lincoln | South Dakota | 46083 | 8711 | 77 |
1377439 | 1377439 | 2021-06-01 | Lincoln | South Dakota | 46083 | 8710 | 77 |
1374193 | 1374193 | 2021-05-31 | Lincoln | South Dakota | 46083 | 8710 | 77 |
1370948 | 1370948 | 2021-05-30 | Lincoln | South Dakota | 46083 | 8709 | 77 |
1367702 | 1367702 | 2021-05-29 | Lincoln | South Dakota | 46083 | 8709 | 77 |
1364456 | 1364456 | 2021-05-28 | Lincoln | South Dakota | 46083 | 8709 | 77 |
1361210 | 1361210 | 2021-05-27 | Lincoln | South Dakota | 46083 | 8705 | 77 |
1357964 | 1357964 | 2021-05-26 | Lincoln | South Dakota | 46083 | 8704 | 77 |
1354718 | 1354718 | 2021-05-25 | Lincoln | South Dakota | 46083 | 8702 | 77 |
1351472 | 1351472 | 2021-05-24 | Lincoln | South Dakota | 46083 | 8698 | 77 |
1348226 | 1348226 | 2021-05-23 | Lincoln | South Dakota | 46083 | 8696 | 77 |
1344978 | 1344978 | 2021-05-22 | Lincoln | South Dakota | 46083 | 8696 | 77 |
1341730 | 1341730 | 2021-05-21 | Lincoln | South Dakota | 46083 | 8696 | 77 |
1338482 | 1338482 | 2021-05-20 | Lincoln | South Dakota | 46083 | 8695 | 77 |
1335235 | 1335235 | 2021-05-19 | Lincoln | South Dakota | 46083 | 8695 | 77 |
1331988 | 1331988 | 2021-05-18 | Lincoln | South Dakota | 46083 | 8694 | 77 |
1328741 | 1328741 | 2021-05-17 | Lincoln | South Dakota | 46083 | 8690 | 77 |
1325495 | 1325495 | 2021-05-16 | Lincoln | South Dakota | 46083 | 8687 | 77 |
1322249 | 1322249 | 2021-05-15 | Lincoln | South Dakota | 46083 | 8687 | 77 |
1319003 | 1319003 | 2021-05-14 | Lincoln | South Dakota | 46083 | 8687 | 77 |
1315755 | 1315755 | 2021-05-13 | Lincoln | South Dakota | 46083 | 8684 | 77 |
1312509 | 1312509 | 2021-05-12 | Lincoln | South Dakota | 46083 | 8676 | 77 |
1309262 | 1309262 | 2021-05-11 | Lincoln | South Dakota | 46083 | 8671 | 77 |
1306016 | 1306016 | 2021-05-10 | Lincoln | South Dakota | 46083 | 8658 | 77 |
1302770 | 1302770 | 2021-05-09 | Lincoln | South Dakota | 46083 | 8652 | 77 |
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);