ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 51003 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1816293 | 1816293 | 2021-10-14 | Albemarle | Virginia | 51003 | 7817 | 95 |
1813045 | 1813045 | 2021-10-13 | Albemarle | Virginia | 51003 | 7788 | 95 |
1809796 | 1809796 | 2021-10-12 | Albemarle | Virginia | 51003 | 7770 | 98 |
1806546 | 1806546 | 2021-10-11 | Albemarle | Virginia | 51003 | 7709 | 96 |
1803296 | 1803296 | 2021-10-10 | Albemarle | Virginia | 51003 | 7709 | 96 |
1800047 | 1800047 | 2021-10-09 | Albemarle | Virginia | 51003 | 7709 | 96 |
1796798 | 1796798 | 2021-10-08 | Albemarle | Virginia | 51003 | 7709 | 96 |
1793549 | 1793549 | 2021-10-07 | Albemarle | Virginia | 51003 | 7697 | 96 |
1790300 | 1790300 | 2021-10-06 | Albemarle | Virginia | 51003 | 7674 | 95 |
1787052 | 1787052 | 2021-10-05 | Albemarle | Virginia | 51003 | 7641 | 95 |
1783803 | 1783803 | 2021-10-04 | Albemarle | Virginia | 51003 | 7621 | 95 |
1780554 | 1780554 | 2021-10-03 | Albemarle | Virginia | 51003 | 7560 | 93 |
1777304 | 1777304 | 2021-10-02 | Albemarle | Virginia | 51003 | 7560 | 93 |
1774054 | 1774054 | 2021-10-01 | Albemarle | Virginia | 51003 | 7560 | 93 |
1770804 | 1770804 | 2021-09-30 | Albemarle | Virginia | 51003 | 7529 | 92 |
1767555 | 1767555 | 2021-09-29 | Albemarle | Virginia | 51003 | 7504 | 92 |
1764306 | 1764306 | 2021-09-28 | Albemarle | Virginia | 51003 | 7475 | 92 |
1761057 | 1761057 | 2021-09-27 | Albemarle | Virginia | 51003 | 7455 | 92 |
1757809 | 1757809 | 2021-09-26 | Albemarle | Virginia | 51003 | 7396 | 92 |
1754561 | 1754561 | 2021-09-25 | Albemarle | Virginia | 51003 | 7396 | 92 |
1751313 | 1751313 | 2021-09-24 | Albemarle | Virginia | 51003 | 7396 | 92 |
1748064 | 1748064 | 2021-09-23 | Albemarle | Virginia | 51003 | 7351 | 91 |
1744814 | 1744814 | 2021-09-22 | Albemarle | Virginia | 51003 | 7318 | 90 |
1741565 | 1741565 | 2021-09-21 | Albemarle | Virginia | 51003 | 7275 | 90 |
1738316 | 1738316 | 2021-09-20 | Albemarle | Virginia | 51003 | 7242 | 90 |
1735067 | 1735067 | 2021-09-19 | Albemarle | Virginia | 51003 | 7133 | 89 |
1731817 | 1731817 | 2021-09-18 | Albemarle | Virginia | 51003 | 7133 | 89 |
1728567 | 1728567 | 2021-09-17 | Albemarle | Virginia | 51003 | 7133 | 89 |
1725317 | 1725317 | 2021-09-16 | Albemarle | Virginia | 51003 | 7086 | 89 |
1722068 | 1722068 | 2021-09-15 | Albemarle | Virginia | 51003 | 7033 | 89 |
1718820 | 1718820 | 2021-09-14 | Albemarle | Virginia | 51003 | 6991 | 89 |
1715572 | 1715572 | 2021-09-13 | Albemarle | Virginia | 51003 | 6940 | 87 |
1712326 | 1712326 | 2021-09-12 | Albemarle | Virginia | 51003 | 6859 | 87 |
1709079 | 1709079 | 2021-09-11 | Albemarle | Virginia | 51003 | 6859 | 87 |
1705832 | 1705832 | 2021-09-10 | Albemarle | Virginia | 51003 | 6859 | 87 |
1702582 | 1702582 | 2021-09-09 | Albemarle | Virginia | 51003 | 6800 | 85 |
1699333 | 1699333 | 2021-09-08 | Albemarle | Virginia | 51003 | 6762 | 85 |
1696085 | 1696085 | 2021-09-07 | Albemarle | Virginia | 51003 | 6732 | 85 |
1692837 | 1692837 | 2021-09-06 | Albemarle | Virginia | 51003 | 6715 | 85 |
1689588 | 1689588 | 2021-09-05 | Albemarle | Virginia | 51003 | 6626 | 85 |
1686338 | 1686338 | 2021-09-04 | Albemarle | Virginia | 51003 | 6626 | 85 |
1683087 | 1683087 | 2021-09-03 | Albemarle | Virginia | 51003 | 6626 | 85 |
1679837 | 1679837 | 2021-09-02 | Albemarle | Virginia | 51003 | 6597 | 85 |
1676589 | 1676589 | 2021-09-01 | Albemarle | Virginia | 51003 | 6533 | 85 |
1673342 | 1673342 | 2021-08-31 | Albemarle | Virginia | 51003 | 6511 | 85 |
1670094 | 1670094 | 2021-08-30 | Albemarle | Virginia | 51003 | 6477 | 85 |
1666847 | 1666847 | 2021-08-29 | Albemarle | Virginia | 51003 | 6398 | 85 |
1663599 | 1663599 | 2021-08-28 | Albemarle | Virginia | 51003 | 6398 | 85 |
1660351 | 1660351 | 2021-08-27 | Albemarle | Virginia | 51003 | 6398 | 85 |
1657102 | 1657102 | 2021-08-26 | Albemarle | Virginia | 51003 | 6356 | 85 |
1653855 | 1653855 | 2021-08-25 | Albemarle | Virginia | 51003 | 6340 | 85 |
1650609 | 1650609 | 2021-08-24 | Albemarle | Virginia | 51003 | 6311 | 85 |
1647360 | 1647360 | 2021-08-23 | Albemarle | Virginia | 51003 | 6295 | 85 |
1644111 | 1644111 | 2021-08-22 | Albemarle | Virginia | 51003 | 6243 | 85 |
1640861 | 1640861 | 2021-08-21 | Albemarle | Virginia | 51003 | 6243 | 85 |
1637611 | 1637611 | 2021-08-20 | Albemarle | Virginia | 51003 | 6243 | 85 |
1634361 | 1634361 | 2021-08-19 | Albemarle | Virginia | 51003 | 6230 | 85 |
1631113 | 1631113 | 2021-08-18 | Albemarle | Virginia | 51003 | 6204 | 85 |
1627866 | 1627866 | 2021-08-17 | Albemarle | Virginia | 51003 | 6193 | 85 |
1624619 | 1624619 | 2021-08-16 | Albemarle | Virginia | 51003 | 6183 | 85 |
1621372 | 1621372 | 2021-08-15 | Albemarle | Virginia | 51003 | 6135 | 85 |
1618124 | 1618124 | 2021-08-14 | Albemarle | Virginia | 51003 | 6135 | 85 |
1614876 | 1614876 | 2021-08-13 | Albemarle | Virginia | 51003 | 6135 | 85 |
1611627 | 1611627 | 2021-08-12 | Albemarle | Virginia | 51003 | 6121 | 85 |
1608380 | 1608380 | 2021-08-11 | Albemarle | Virginia | 51003 | 6095 | 85 |
1605131 | 1605131 | 2021-08-10 | Albemarle | Virginia | 51003 | 6079 | 85 |
1601881 | 1601881 | 2021-08-09 | Albemarle | Virginia | 51003 | 6073 | 85 |
1598633 | 1598633 | 2021-08-08 | Albemarle | Virginia | 51003 | 6027 | 85 |
1595384 | 1595384 | 2021-08-07 | Albemarle | Virginia | 51003 | 6027 | 85 |
1592135 | 1592135 | 2021-08-06 | Albemarle | Virginia | 51003 | 6027 | 85 |
1588886 | 1588886 | 2021-08-05 | Albemarle | Virginia | 51003 | 6006 | 85 |
1585637 | 1585637 | 2021-08-04 | Albemarle | Virginia | 51003 | 5996 | 85 |
1582387 | 1582387 | 2021-08-03 | Albemarle | Virginia | 51003 | 5978 | 85 |
1579137 | 1579137 | 2021-08-02 | Albemarle | Virginia | 51003 | 5971 | 85 |
1575889 | 1575889 | 2021-08-01 | Albemarle | Virginia | 51003 | 5946 | 85 |
1572641 | 1572641 | 2021-07-31 | Albemarle | Virginia | 51003 | 5946 | 85 |
1569393 | 1569393 | 2021-07-30 | Albemarle | Virginia | 51003 | 5946 | 85 |
1566145 | 1566145 | 2021-07-29 | Albemarle | Virginia | 51003 | 5934 | 85 |
1562897 | 1562897 | 2021-07-28 | Albemarle | Virginia | 51003 | 5921 | 85 |
1559649 | 1559649 | 2021-07-27 | Albemarle | Virginia | 51003 | 5912 | 85 |
1556402 | 1556402 | 2021-07-26 | Albemarle | Virginia | 51003 | 5904 | 85 |
1553155 | 1553155 | 2021-07-25 | Albemarle | Virginia | 51003 | 5896 | 85 |
1549908 | 1549908 | 2021-07-24 | Albemarle | Virginia | 51003 | 5896 | 85 |
1546661 | 1546661 | 2021-07-23 | Albemarle | Virginia | 51003 | 5896 | 85 |
1543414 | 1543414 | 2021-07-22 | Albemarle | Virginia | 51003 | 5892 | 85 |
1540166 | 1540166 | 2021-07-21 | Albemarle | Virginia | 51003 | 5885 | 85 |
1536919 | 1536919 | 2021-07-20 | Albemarle | Virginia | 51003 | 5881 | 85 |
1533671 | 1533671 | 2021-07-19 | Albemarle | Virginia | 51003 | 5869 | 85 |
1530424 | 1530424 | 2021-07-18 | Albemarle | Virginia | 51003 | 5859 | 85 |
1527177 | 1527177 | 2021-07-17 | Albemarle | Virginia | 51003 | 5859 | 85 |
1523930 | 1523930 | 2021-07-16 | Albemarle | Virginia | 51003 | 5859 | 85 |
1520682 | 1520682 | 2021-07-15 | Albemarle | Virginia | 51003 | 5852 | 85 |
1517434 | 1517434 | 2021-07-14 | Albemarle | Virginia | 51003 | 5847 | 85 |
1514187 | 1514187 | 2021-07-13 | Albemarle | Virginia | 51003 | 5841 | 85 |
1510941 | 1510941 | 2021-07-12 | Albemarle | Virginia | 51003 | 5840 | 85 |
1507694 | 1507694 | 2021-07-11 | Albemarle | Virginia | 51003 | 5840 | 85 |
1504448 | 1504448 | 2021-07-10 | Albemarle | Virginia | 51003 | 5839 | 85 |
1501202 | 1501202 | 2021-07-09 | Albemarle | Virginia | 51003 | 5833 | 85 |
1497956 | 1497956 | 2021-07-08 | Albemarle | Virginia | 51003 | 5830 | 85 |
1494709 | 1494709 | 2021-07-07 | Albemarle | Virginia | 51003 | 5832 | 85 |
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);