ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Hughes" 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 |
---|---|---|---|---|---|---|---|
1718386 | 1718386 | 2021-09-14 | Hughes | South Dakota | 46065 | 2680 | 43 |
1715138 | 1715138 | 2021-09-13 | Hughes | South Dakota | 46065 | 2675 | 43 |
1711892 | 1711892 | 2021-09-12 | Hughes | South Dakota | 46065 | 2669 | 43 |
1708645 | 1708645 | 2021-09-11 | Hughes | South Dakota | 46065 | 2669 | 43 |
1705398 | 1705398 | 2021-09-10 | Hughes | South Dakota | 46065 | 2669 | 43 |
1702148 | 1702148 | 2021-09-09 | Hughes | South Dakota | 46065 | 2662 | 43 |
1698899 | 1698899 | 2021-09-08 | Hughes | South Dakota | 46065 | 2654 | 43 |
1695651 | 1695651 | 2021-09-07 | Hughes | South Dakota | 46065 | 2647 | 43 |
1692403 | 1692403 | 2021-09-06 | Hughes | South Dakota | 46065 | 2643 | 43 |
1689154 | 1689154 | 2021-09-05 | Hughes | South Dakota | 46065 | 2643 | 43 |
1685904 | 1685904 | 2021-09-04 | Hughes | South Dakota | 46065 | 2643 | 43 |
1682653 | 1682653 | 2021-09-03 | Hughes | South Dakota | 46065 | 2643 | 43 |
1679403 | 1679403 | 2021-09-02 | Hughes | South Dakota | 46065 | 2639 | 43 |
1676155 | 1676155 | 2021-09-01 | Hughes | South Dakota | 46065 | 2632 | 43 |
1672908 | 1672908 | 2021-08-31 | Hughes | South Dakota | 46065 | 2626 | 43 |
1669660 | 1669660 | 2021-08-30 | Hughes | South Dakota | 46065 | 2622 | 43 |
1666413 | 1666413 | 2021-08-29 | Hughes | South Dakota | 46065 | 2619 | 43 |
1663165 | 1663165 | 2021-08-28 | Hughes | South Dakota | 46065 | 2619 | 43 |
1659917 | 1659917 | 2021-08-27 | Hughes | South Dakota | 46065 | 2619 | 43 |
1656668 | 1656668 | 2021-08-26 | Hughes | South Dakota | 46065 | 2610 | 43 |
1653421 | 1653421 | 2021-08-25 | Hughes | South Dakota | 46065 | 2605 | 43 |
1650174 | 1650174 | 2021-08-24 | Hughes | South Dakota | 46065 | 2601 | 43 |
1646925 | 1646925 | 2021-08-23 | Hughes | South Dakota | 46065 | 2590 | 43 |
1643676 | 1643676 | 2021-08-22 | Hughes | South Dakota | 46065 | 2587 | 43 |
1640426 | 1640426 | 2021-08-21 | Hughes | South Dakota | 46065 | 2587 | 43 |
1637176 | 1637176 | 2021-08-20 | Hughes | South Dakota | 46065 | 2587 | 43 |
1633926 | 1633926 | 2021-08-19 | Hughes | South Dakota | 46065 | 2584 | 43 |
1630679 | 1630679 | 2021-08-18 | Hughes | South Dakota | 46065 | 2582 | 43 |
1627432 | 1627432 | 2021-08-17 | Hughes | South Dakota | 46065 | 2579 | 43 |
1624185 | 1624185 | 2021-08-16 | Hughes | South Dakota | 46065 | 2565 | 43 |
1620938 | 1620938 | 2021-08-15 | Hughes | South Dakota | 46065 | 2561 | 43 |
1617690 | 1617690 | 2021-08-14 | Hughes | South Dakota | 46065 | 2561 | 43 |
1614442 | 1614442 | 2021-08-13 | Hughes | South Dakota | 46065 | 2561 | 43 |
1611193 | 1611193 | 2021-08-12 | Hughes | South Dakota | 46065 | 2561 | 43 |
1607945 | 1607945 | 2021-08-11 | Hughes | South Dakota | 46065 | 2560 | 43 |
1604696 | 1604696 | 2021-08-10 | Hughes | South Dakota | 46065 | 2546 | 43 |
1601447 | 1601447 | 2021-08-09 | Hughes | South Dakota | 46065 | 2546 | 43 |
1598199 | 1598199 | 2021-08-08 | Hughes | South Dakota | 46065 | 2546 | 43 |
1594950 | 1594950 | 2021-08-07 | Hughes | South Dakota | 46065 | 2546 | 43 |
1591701 | 1591701 | 2021-08-06 | Hughes | South Dakota | 46065 | 2546 | 43 |
1588452 | 1588452 | 2021-08-05 | Hughes | South Dakota | 46065 | 2546 | 43 |
1585202 | 1585202 | 2021-08-04 | Hughes | South Dakota | 46065 | 2546 | 43 |
1581952 | 1581952 | 2021-08-03 | Hughes | South Dakota | 46065 | 2538 | 42 |
1578703 | 1578703 | 2021-08-02 | Hughes | South Dakota | 46065 | 2538 | 42 |
1575455 | 1575455 | 2021-08-01 | Hughes | South Dakota | 46065 | 2538 | 42 |
1572207 | 1572207 | 2021-07-31 | Hughes | South Dakota | 46065 | 2538 | 42 |
1568959 | 1568959 | 2021-07-30 | Hughes | South Dakota | 46065 | 2538 | 42 |
1565711 | 1565711 | 2021-07-29 | Hughes | South Dakota | 46065 | 2538 | 42 |
1562463 | 1562463 | 2021-07-28 | Hughes | South Dakota | 46065 | 2538 | 42 |
1559215 | 1559215 | 2021-07-27 | Hughes | South Dakota | 46065 | 2530 | 42 |
1555968 | 1555968 | 2021-07-26 | Hughes | South Dakota | 46065 | 2530 | 42 |
1552721 | 1552721 | 2021-07-25 | Hughes | South Dakota | 46065 | 2530 | 42 |
1549474 | 1549474 | 2021-07-24 | Hughes | South Dakota | 46065 | 2530 | 42 |
1546227 | 1546227 | 2021-07-23 | Hughes | South Dakota | 46065 | 2530 | 42 |
1542980 | 1542980 | 2021-07-22 | Hughes | South Dakota | 46065 | 2530 | 42 |
1539732 | 1539732 | 2021-07-21 | Hughes | South Dakota | 46065 | 2530 | 42 |
1536485 | 1536485 | 2021-07-20 | Hughes | South Dakota | 46065 | 2527 | 42 |
1533237 | 1533237 | 2021-07-19 | Hughes | South Dakota | 46065 | 2527 | 42 |
1529990 | 1529990 | 2021-07-18 | Hughes | South Dakota | 46065 | 2527 | 42 |
1526743 | 1526743 | 2021-07-17 | Hughes | South Dakota | 46065 | 2527 | 42 |
1523496 | 1523496 | 2021-07-16 | Hughes | South Dakota | 46065 | 2527 | 42 |
1520248 | 1520248 | 2021-07-15 | Hughes | South Dakota | 46065 | 2527 | 42 |
1517000 | 1517000 | 2021-07-14 | Hughes | South Dakota | 46065 | 2527 | 42 |
1513753 | 1513753 | 2021-07-13 | Hughes | South Dakota | 46065 | 2527 | 42 |
1510507 | 1510507 | 2021-07-12 | Hughes | South Dakota | 46065 | 2527 | 42 |
1507260 | 1507260 | 2021-07-11 | Hughes | South Dakota | 46065 | 2527 | 42 |
1504014 | 1504014 | 2021-07-10 | Hughes | South Dakota | 46065 | 2527 | 42 |
1500768 | 1500768 | 2021-07-09 | Hughes | South Dakota | 46065 | 2527 | 42 |
1497522 | 1497522 | 2021-07-08 | Hughes | South Dakota | 46065 | 2527 | 42 |
1494275 | 1494275 | 2021-07-07 | Hughes | South Dakota | 46065 | 2527 | 42 |
1491028 | 1491028 | 2021-07-06 | Hughes | South Dakota | 46065 | 2526 | 42 |
1487781 | 1487781 | 2021-07-05 | Hughes | South Dakota | 46065 | 2526 | 42 |
1484534 | 1484534 | 2021-07-04 | Hughes | South Dakota | 46065 | 2526 | 42 |
1481288 | 1481288 | 2021-07-03 | Hughes | South Dakota | 46065 | 2526 | 42 |
1478041 | 1478041 | 2021-07-02 | Hughes | South Dakota | 46065 | 2526 | 42 |
1474795 | 1474795 | 2021-07-01 | Hughes | South Dakota | 46065 | 2526 | 42 |
1471549 | 1471549 | 2021-06-30 | Hughes | South Dakota | 46065 | 2526 | 42 |
1468304 | 1468304 | 2021-06-29 | Hughes | South Dakota | 46065 | 2525 | 42 |
1465059 | 1465059 | 2021-06-28 | Hughes | South Dakota | 46065 | 2526 | 41 |
1461814 | 1461814 | 2021-06-27 | Hughes | South Dakota | 46065 | 2526 | 41 |
1458569 | 1458569 | 2021-06-26 | Hughes | South Dakota | 46065 | 2526 | 41 |
1455324 | 1455324 | 2021-06-25 | Hughes | South Dakota | 46065 | 2526 | 41 |
1452079 | 1452079 | 2021-06-24 | Hughes | South Dakota | 46065 | 2526 | 41 |
1448833 | 1448833 | 2021-06-23 | Hughes | South Dakota | 46065 | 2524 | 41 |
1445588 | 1445588 | 2021-06-22 | Hughes | South Dakota | 46065 | 2524 | 41 |
1442343 | 1442343 | 2021-06-21 | Hughes | South Dakota | 46065 | 2523 | 41 |
1439098 | 1439098 | 2021-06-20 | Hughes | South Dakota | 46065 | 2523 | 41 |
1435851 | 1435851 | 2021-06-19 | Hughes | South Dakota | 46065 | 2523 | 41 |
1432604 | 1432604 | 2021-06-18 | Hughes | South Dakota | 46065 | 2523 | 41 |
1429358 | 1429358 | 2021-06-17 | Hughes | South Dakota | 46065 | 2523 | 41 |
1426113 | 1426113 | 2021-06-16 | Hughes | South Dakota | 46065 | 2523 | 41 |
1422866 | 1422866 | 2021-06-15 | Hughes | South Dakota | 46065 | 2523 | 41 |
1419620 | 1419620 | 2021-06-14 | Hughes | South Dakota | 46065 | 2523 | 41 |
1416375 | 1416375 | 2021-06-13 | Hughes | South Dakota | 46065 | 2523 | 41 |
1413129 | 1413129 | 2021-06-12 | Hughes | South Dakota | 46065 | 2523 | 41 |
1409884 | 1409884 | 2021-06-11 | Hughes | South Dakota | 46065 | 2523 | 41 |
1406639 | 1406639 | 2021-06-10 | Hughes | South Dakota | 46065 | 2523 | 41 |
1403393 | 1403393 | 2021-06-09 | Hughes | South Dakota | 46065 | 2523 | 41 |
1400148 | 1400148 | 2021-06-08 | Hughes | South Dakota | 46065 | 2523 | 41 |
1396903 | 1396903 | 2021-06-07 | Hughes | South Dakota | 46065 | 2523 | 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);