ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Albemarle" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1491462 | 1491462 | 2021-07-06 | Albemarle | Virginia | 51003 | 5831 | 85 |
1488215 | 1488215 | 2021-07-05 | Albemarle | Virginia | 51003 | 5831 | 85 |
1484968 | 1484968 | 2021-07-04 | Albemarle | Virginia | 51003 | 5831 | 85 |
1481722 | 1481722 | 2021-07-03 | Albemarle | Virginia | 51003 | 5830 | 85 |
1478475 | 1478475 | 2021-07-02 | Albemarle | Virginia | 51003 | 5829 | 85 |
1475229 | 1475229 | 2021-07-01 | Albemarle | Virginia | 51003 | 5830 | 85 |
1471983 | 1471983 | 2021-06-30 | Albemarle | Virginia | 51003 | 5826 | 85 |
1468738 | 1468738 | 2021-06-29 | Albemarle | Virginia | 51003 | 5824 | 85 |
1465493 | 1465493 | 2021-06-28 | Albemarle | Virginia | 51003 | 5823 | 85 |
1462248 | 1462248 | 2021-06-27 | Albemarle | Virginia | 51003 | 5823 | 85 |
1459003 | 1459003 | 2021-06-26 | Albemarle | Virginia | 51003 | 5820 | 85 |
1455758 | 1455758 | 2021-06-25 | Albemarle | Virginia | 51003 | 5819 | 85 |
1452513 | 1452513 | 2021-06-24 | Albemarle | Virginia | 51003 | 5817 | 85 |
1449267 | 1449267 | 2021-06-23 | Albemarle | Virginia | 51003 | 5817 | 85 |
1446022 | 1446022 | 2021-06-22 | Albemarle | Virginia | 51003 | 5816 | 85 |
1442777 | 1442777 | 2021-06-21 | Albemarle | Virginia | 51003 | 5816 | 85 |
1439532 | 1439532 | 2021-06-20 | Albemarle | Virginia | 51003 | 5816 | 85 |
1436285 | 1436285 | 2021-06-19 | Albemarle | Virginia | 51003 | 5817 | 85 |
1433038 | 1433038 | 2021-06-18 | Albemarle | Virginia | 51003 | 5815 | 85 |
1429792 | 1429792 | 2021-06-17 | Albemarle | Virginia | 51003 | 5814 | 85 |
1426547 | 1426547 | 2021-06-16 | Albemarle | Virginia | 51003 | 5813 | 85 |
1423301 | 1423301 | 2021-06-15 | Albemarle | Virginia | 51003 | 5811 | 85 |
1420054 | 1420054 | 2021-06-14 | Albemarle | Virginia | 51003 | 5811 | 84 |
1416809 | 1416809 | 2021-06-13 | Albemarle | Virginia | 51003 | 5808 | 84 |
1413563 | 1413563 | 2021-06-12 | Albemarle | Virginia | 51003 | 5809 | 83 |
1410318 | 1410318 | 2021-06-11 | Albemarle | Virginia | 51003 | 5810 | 83 |
1407073 | 1407073 | 2021-06-10 | Albemarle | Virginia | 51003 | 5811 | 83 |
1403827 | 1403827 | 2021-06-09 | Albemarle | Virginia | 51003 | 5811 | 83 |
1400582 | 1400582 | 2021-06-08 | Albemarle | Virginia | 51003 | 5811 | 83 |
1397337 | 1397337 | 2021-06-07 | Albemarle | Virginia | 51003 | 5808 | 83 |
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);