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 |
---|---|---|---|---|---|---|---|
1816342 | 1816342 | 2021-10-14 | Goochland | Virginia | 51075 | 1948 | 29 |
1813094 | 1813094 | 2021-10-13 | Goochland | Virginia | 51075 | 1939 | 29 |
1809845 | 1809845 | 2021-10-12 | Goochland | Virginia | 51075 | 1934 | 29 |
1806595 | 1806595 | 2021-10-11 | Goochland | Virginia | 51075 | 1910 | 29 |
1803345 | 1803345 | 2021-10-10 | Goochland | Virginia | 51075 | 1910 | 29 |
1800096 | 1800096 | 2021-10-09 | Goochland | Virginia | 51075 | 1910 | 29 |
1796847 | 1796847 | 2021-10-08 | Goochland | Virginia | 51075 | 1910 | 29 |
1793598 | 1793598 | 2021-10-07 | Goochland | Virginia | 51075 | 1901 | 28 |
1790349 | 1790349 | 2021-10-06 | Goochland | Virginia | 51075 | 1898 | 28 |
1787101 | 1787101 | 2021-10-05 | Goochland | Virginia | 51075 | 1886 | 28 |
1783852 | 1783852 | 2021-10-04 | Goochland | Virginia | 51075 | 1885 | 28 |
1780603 | 1780603 | 2021-10-03 | Goochland | Virginia | 51075 | 1861 | 28 |
1777353 | 1777353 | 2021-10-02 | Goochland | Virginia | 51075 | 1861 | 28 |
1774103 | 1774103 | 2021-10-01 | Goochland | Virginia | 51075 | 1861 | 28 |
1770853 | 1770853 | 2021-09-30 | Goochland | Virginia | 51075 | 1843 | 28 |
1767604 | 1767604 | 2021-09-29 | Goochland | Virginia | 51075 | 1840 | 28 |
1764355 | 1764355 | 2021-09-28 | Goochland | Virginia | 51075 | 1835 | 28 |
1761106 | 1761106 | 2021-09-27 | Goochland | Virginia | 51075 | 1829 | 28 |
1757858 | 1757858 | 2021-09-26 | Goochland | Virginia | 51075 | 1818 | 27 |
1754610 | 1754610 | 2021-09-25 | Goochland | Virginia | 51075 | 1818 | 27 |
1751362 | 1751362 | 2021-09-24 | Goochland | Virginia | 51075 | 1818 | 27 |
1748113 | 1748113 | 2021-09-23 | Goochland | Virginia | 51075 | 1815 | 27 |
1744863 | 1744863 | 2021-09-22 | Goochland | Virginia | 51075 | 1811 | 27 |
1741614 | 1741614 | 2021-09-21 | Goochland | Virginia | 51075 | 1805 | 27 |
1738365 | 1738365 | 2021-09-20 | Goochland | Virginia | 51075 | 1797 | 27 |
1735116 | 1735116 | 2021-09-19 | Goochland | Virginia | 51075 | 1780 | 27 |
1731866 | 1731866 | 2021-09-18 | Goochland | Virginia | 51075 | 1780 | 27 |
1728616 | 1728616 | 2021-09-17 | Goochland | Virginia | 51075 | 1780 | 27 |
1725366 | 1725366 | 2021-09-16 | Goochland | Virginia | 51075 | 1772 | 27 |
1722117 | 1722117 | 2021-09-15 | Goochland | Virginia | 51075 | 1763 | 27 |
1718869 | 1718869 | 2021-09-14 | Goochland | Virginia | 51075 | 1754 | 27 |
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 |
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);