ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Goochland" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1715621 | 1715621 | 2021-09-13 | Goochland | Virginia | 51075 | 1749 | 27 |
1712375 | 1712375 | 2021-09-12 | Goochland | Virginia | 51075 | 1737 | 26 |
1709128 | 1709128 | 2021-09-11 | Goochland | Virginia | 51075 | 1737 | 26 |
1705881 | 1705881 | 2021-09-10 | Goochland | Virginia | 51075 | 1737 | 26 |
1702631 | 1702631 | 2021-09-09 | Goochland | Virginia | 51075 | 1730 | 26 |
1699382 | 1699382 | 2021-09-08 | Goochland | Virginia | 51075 | 1723 | 26 |
1696134 | 1696134 | 2021-09-07 | Goochland | Virginia | 51075 | 1720 | 25 |
1692886 | 1692886 | 2021-09-06 | Goochland | Virginia | 51075 | 1718 | 25 |
1689637 | 1689637 | 2021-09-05 | Goochland | Virginia | 51075 | 1697 | 25 |
1686387 | 1686387 | 2021-09-04 | Goochland | Virginia | 51075 | 1697 | 25 |
1683136 | 1683136 | 2021-09-03 | Goochland | Virginia | 51075 | 1697 | 25 |
1679886 | 1679886 | 2021-09-02 | Goochland | Virginia | 51075 | 1687 | 25 |
1676638 | 1676638 | 2021-09-01 | Goochland | Virginia | 51075 | 1679 | 25 |
1673391 | 1673391 | 2021-08-31 | Goochland | Virginia | 51075 | 1668 | 25 |
1670143 | 1670143 | 2021-08-30 | Goochland | Virginia | 51075 | 1663 | 25 |
1666896 | 1666896 | 2021-08-29 | Goochland | Virginia | 51075 | 1647 | 25 |
1663648 | 1663648 | 2021-08-28 | Goochland | Virginia | 51075 | 1647 | 25 |
1660400 | 1660400 | 2021-08-27 | Goochland | Virginia | 51075 | 1647 | 25 |
1657151 | 1657151 | 2021-08-26 | Goochland | Virginia | 51075 | 1639 | 24 |
1653904 | 1653904 | 2021-08-25 | Goochland | Virginia | 51075 | 1634 | 24 |
1650658 | 1650658 | 2021-08-24 | Goochland | Virginia | 51075 | 1631 | 24 |
1647409 | 1647409 | 2021-08-23 | Goochland | Virginia | 51075 | 1627 | 24 |
1644160 | 1644160 | 2021-08-22 | Goochland | Virginia | 51075 | 1606 | 24 |
1640910 | 1640910 | 2021-08-21 | Goochland | Virginia | 51075 | 1606 | 24 |
1637660 | 1637660 | 2021-08-20 | Goochland | Virginia | 51075 | 1606 | 24 |
1634410 | 1634410 | 2021-08-19 | Goochland | Virginia | 51075 | 1602 | 24 |
1631162 | 1631162 | 2021-08-18 | Goochland | Virginia | 51075 | 1596 | 24 |
1627915 | 1627915 | 2021-08-17 | Goochland | Virginia | 51075 | 1590 | 24 |
1624668 | 1624668 | 2021-08-16 | Goochland | Virginia | 51075 | 1580 | 24 |
1621421 | 1621421 | 2021-08-15 | Goochland | Virginia | 51075 | 1566 | 24 |
1618173 | 1618173 | 2021-08-14 | Goochland | Virginia | 51075 | 1566 | 24 |
1614925 | 1614925 | 2021-08-13 | Goochland | Virginia | 51075 | 1566 | 24 |
1611676 | 1611676 | 2021-08-12 | Goochland | Virginia | 51075 | 1564 | 24 |
1608429 | 1608429 | 2021-08-11 | Goochland | Virginia | 51075 | 1560 | 24 |
1605180 | 1605180 | 2021-08-10 | Goochland | Virginia | 51075 | 1555 | 24 |
1601930 | 1601930 | 2021-08-09 | Goochland | Virginia | 51075 | 1551 | 24 |
1598682 | 1598682 | 2021-08-08 | Goochland | Virginia | 51075 | 1533 | 24 |
1595433 | 1595433 | 2021-08-07 | Goochland | Virginia | 51075 | 1533 | 24 |
1592184 | 1592184 | 2021-08-06 | Goochland | Virginia | 51075 | 1533 | 24 |
1588935 | 1588935 | 2021-08-05 | Goochland | Virginia | 51075 | 1530 | 24 |
1585686 | 1585686 | 2021-08-04 | Goochland | Virginia | 51075 | 1525 | 24 |
1582436 | 1582436 | 2021-08-03 | Goochland | Virginia | 51075 | 1520 | 24 |
1579186 | 1579186 | 2021-08-02 | Goochland | Virginia | 51075 | 1517 | 24 |
1575938 | 1575938 | 2021-08-01 | Goochland | Virginia | 51075 | 1509 | 24 |
1572690 | 1572690 | 2021-07-31 | Goochland | Virginia | 51075 | 1509 | 24 |
1569442 | 1569442 | 2021-07-30 | Goochland | Virginia | 51075 | 1509 | 24 |
1566194 | 1566194 | 2021-07-29 | Goochland | Virginia | 51075 | 1506 | 24 |
1562946 | 1562946 | 2021-07-28 | Goochland | Virginia | 51075 | 1501 | 23 |
1559698 | 1559698 | 2021-07-27 | Goochland | Virginia | 51075 | 1499 | 23 |
1556451 | 1556451 | 2021-07-26 | Goochland | Virginia | 51075 | 1498 | 23 |
1553204 | 1553204 | 2021-07-25 | Goochland | Virginia | 51075 | 1492 | 23 |
1549957 | 1549957 | 2021-07-24 | Goochland | Virginia | 51075 | 1492 | 23 |
1546710 | 1546710 | 2021-07-23 | Goochland | Virginia | 51075 | 1492 | 23 |
1543463 | 1543463 | 2021-07-22 | Goochland | Virginia | 51075 | 1489 | 23 |
1540215 | 1540215 | 2021-07-21 | Goochland | Virginia | 51075 | 1488 | 23 |
1536968 | 1536968 | 2021-07-20 | Goochland | Virginia | 51075 | 1488 | 23 |
1533720 | 1533720 | 2021-07-19 | Goochland | Virginia | 51075 | 1488 | 23 |
1530473 | 1530473 | 2021-07-18 | Goochland | Virginia | 51075 | 1487 | 23 |
1527226 | 1527226 | 2021-07-17 | Goochland | Virginia | 51075 | 1487 | 23 |
1523979 | 1523979 | 2021-07-16 | Goochland | Virginia | 51075 | 1487 | 23 |
1520731 | 1520731 | 2021-07-15 | Goochland | Virginia | 51075 | 1487 | 23 |
1517483 | 1517483 | 2021-07-14 | Goochland | Virginia | 51075 | 1485 | 23 |
1514236 | 1514236 | 2021-07-13 | Goochland | Virginia | 51075 | 1486 | 23 |
1510990 | 1510990 | 2021-07-12 | Goochland | Virginia | 51075 | 1484 | 23 |
1507743 | 1507743 | 2021-07-11 | Goochland | Virginia | 51075 | 1485 | 23 |
1504497 | 1504497 | 2021-07-10 | Goochland | Virginia | 51075 | 1485 | 23 |
1501251 | 1501251 | 2021-07-09 | Goochland | Virginia | 51075 | 1485 | 23 |
1498005 | 1498005 | 2021-07-08 | Goochland | Virginia | 51075 | 1485 | 23 |
1494758 | 1494758 | 2021-07-07 | Goochland | Virginia | 51075 | 1483 | 23 |
1491511 | 1491511 | 2021-07-06 | Goochland | Virginia | 51075 | 1483 | 23 |
1488264 | 1488264 | 2021-07-05 | Goochland | Virginia | 51075 | 1483 | 23 |
1485017 | 1485017 | 2021-07-04 | Goochland | Virginia | 51075 | 1482 | 23 |
1481771 | 1481771 | 2021-07-03 | Goochland | Virginia | 51075 | 1482 | 23 |
1478524 | 1478524 | 2021-07-02 | Goochland | Virginia | 51075 | 1483 | 23 |
1475278 | 1475278 | 2021-07-01 | Goochland | Virginia | 51075 | 1479 | 23 |
1472032 | 1472032 | 2021-06-30 | Goochland | Virginia | 51075 | 1479 | 23 |
1468787 | 1468787 | 2021-06-29 | Goochland | Virginia | 51075 | 1478 | 23 |
1465542 | 1465542 | 2021-06-28 | Goochland | Virginia | 51075 | 1478 | 23 |
1462297 | 1462297 | 2021-06-27 | Goochland | Virginia | 51075 | 1477 | 23 |
1459052 | 1459052 | 2021-06-26 | Goochland | Virginia | 51075 | 1477 | 23 |
1455807 | 1455807 | 2021-06-25 | Goochland | Virginia | 51075 | 1476 | 23 |
1452562 | 1452562 | 2021-06-24 | Goochland | Virginia | 51075 | 1472 | 23 |
1449316 | 1449316 | 2021-06-23 | Goochland | Virginia | 51075 | 1472 | 23 |
1446071 | 1446071 | 2021-06-22 | Goochland | Virginia | 51075 | 1472 | 23 |
1442826 | 1442826 | 2021-06-21 | Goochland | Virginia | 51075 | 1472 | 23 |
1439581 | 1439581 | 2021-06-20 | Goochland | Virginia | 51075 | 1471 | 23 |
1436334 | 1436334 | 2021-06-19 | Goochland | Virginia | 51075 | 1470 | 23 |
1433087 | 1433087 | 2021-06-18 | Goochland | Virginia | 51075 | 1470 | 23 |
1429841 | 1429841 | 2021-06-17 | Goochland | Virginia | 51075 | 1469 | 23 |
1426596 | 1426596 | 2021-06-16 | Goochland | Virginia | 51075 | 1469 | 23 |
1423350 | 1423350 | 2021-06-15 | Goochland | Virginia | 51075 | 1469 | 23 |
1420103 | 1420103 | 2021-06-14 | Goochland | Virginia | 51075 | 1468 | 23 |
1416858 | 1416858 | 2021-06-13 | Goochland | Virginia | 51075 | 1468 | 23 |
1413612 | 1413612 | 2021-06-12 | Goochland | Virginia | 51075 | 1468 | 23 |
1410367 | 1410367 | 2021-06-11 | Goochland | Virginia | 51075 | 1469 | 23 |
1407122 | 1407122 | 2021-06-10 | Goochland | Virginia | 51075 | 1469 | 23 |
1403876 | 1403876 | 2021-06-09 | Goochland | Virginia | 51075 | 1469 | 23 |
1400631 | 1400631 | 2021-06-08 | Goochland | Virginia | 51075 | 1469 | 23 |
1397386 | 1397386 | 2021-06-07 | Goochland | Virginia | 51075 | 1466 | 23 |
1394139 | 1394139 | 2021-06-06 | Goochland | Virginia | 51075 | 1465 | 23 |
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);