ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 51087 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1949583 | 1949583 | 2021-11-24 | Henrico | Virginia | 51087 | 35518 | 731 |
1946332 | 1946332 | 2021-11-23 | Henrico | Virginia | 51087 | 35464 | 732 |
1943081 | 1943081 | 2021-11-22 | Henrico | Virginia | 51087 | 35414 | 732 |
1939831 | 1939831 | 2021-11-21 | Henrico | Virginia | 51087 | 35263 | 730 |
1936581 | 1936581 | 2021-11-20 | Henrico | Virginia | 51087 | 35263 | 730 |
1933331 | 1933331 | 2021-11-19 | Henrico | Virginia | 51087 | 35263 | 730 |
1930079 | 1930079 | 2021-11-18 | Henrico | Virginia | 51087 | 35198 | 728 |
1926829 | 1926829 | 2021-11-17 | Henrico | Virginia | 51087 | 35149 | 728 |
1923579 | 1923579 | 2021-11-16 | Henrico | Virginia | 51087 | 35075 | 728 |
1920330 | 1920330 | 2021-11-15 | Henrico | Virginia | 51087 | 35049 | 728 |
1917080 | 1917080 | 2021-11-14 | Henrico | Virginia | 51087 | 34942 | 727 |
1913830 | 1913830 | 2021-11-13 | Henrico | Virginia | 51087 | 34942 | 727 |
1910580 | 1910580 | 2021-11-12 | Henrico | Virginia | 51087 | 34942 | 727 |
1907331 | 1907331 | 2021-11-11 | Henrico | Virginia | 51087 | 34908 | 727 |
1904082 | 1904082 | 2021-11-10 | Henrico | Virginia | 51087 | 34851 | 726 |
1900832 | 1900832 | 2021-11-09 | Henrico | Virginia | 51087 | 34823 | 725 |
1897582 | 1897582 | 2021-11-08 | Henrico | Virginia | 51087 | 34776 | 721 |
1894332 | 1894332 | 2021-11-07 | Henrico | Virginia | 51087 | 34692 | 720 |
1891082 | 1891082 | 2021-11-06 | Henrico | Virginia | 51087 | 34692 | 720 |
1887832 | 1887832 | 2021-11-05 | Henrico | Virginia | 51087 | 34692 | 720 |
1884582 | 1884582 | 2021-11-04 | Henrico | Virginia | 51087 | 34647 | 720 |
1881333 | 1881333 | 2021-11-03 | Henrico | Virginia | 51087 | 34610 | 718 |
1878084 | 1878084 | 2021-11-02 | Henrico | Virginia | 51087 | 34560 | 717 |
1874835 | 1874835 | 2021-11-01 | Henrico | Virginia | 51087 | 34536 | 717 |
1871586 | 1871586 | 2021-10-31 | Henrico | Virginia | 51087 | 34431 | 716 |
1868337 | 1868337 | 2021-10-30 | Henrico | Virginia | 51087 | 34431 | 716 |
1865088 | 1865088 | 2021-10-29 | Henrico | Virginia | 51087 | 34431 | 716 |
1861839 | 1861839 | 2021-10-28 | Henrico | Virginia | 51087 | 34378 | 714 |
1858590 | 1858590 | 2021-10-27 | Henrico | Virginia | 51087 | 34337 | 714 |
1855341 | 1855341 | 2021-10-26 | Henrico | Virginia | 51087 | 34308 | 713 |
1852092 | 1852092 | 2021-10-25 | Henrico | Virginia | 51087 | 34266 | 711 |
1848842 | 1848842 | 2021-10-24 | Henrico | Virginia | 51087 | 34096 | 708 |
1845592 | 1845592 | 2021-10-23 | Henrico | Virginia | 51087 | 34096 | 708 |
1842342 | 1842342 | 2021-10-22 | Henrico | Virginia | 51087 | 34096 | 708 |
1839093 | 1839093 | 2021-10-21 | Henrico | Virginia | 51087 | 34044 | 708 |
1835844 | 1835844 | 2021-10-20 | Henrico | Virginia | 51087 | 33969 | 707 |
1832595 | 1832595 | 2021-10-19 | Henrico | Virginia | 51087 | 33908 | 706 |
1829346 | 1829346 | 2021-10-18 | Henrico | Virginia | 51087 | 33845 | 705 |
1826097 | 1826097 | 2021-10-17 | Henrico | Virginia | 51087 | 33701 | 703 |
1822848 | 1822848 | 2021-10-16 | Henrico | Virginia | 51087 | 33701 | 703 |
1819599 | 1819599 | 2021-10-15 | Henrico | Virginia | 51087 | 33701 | 703 |
1816350 | 1816350 | 2021-10-14 | Henrico | Virginia | 51087 | 33604 | 701 |
1813102 | 1813102 | 2021-10-13 | Henrico | Virginia | 51087 | 33522 | 701 |
1809853 | 1809853 | 2021-10-12 | Henrico | Virginia | 51087 | 33460 | 700 |
1806603 | 1806603 | 2021-10-11 | Henrico | Virginia | 51087 | 33230 | 694 |
1803353 | 1803353 | 2021-10-10 | Henrico | Virginia | 51087 | 33230 | 694 |
1800104 | 1800104 | 2021-10-09 | Henrico | Virginia | 51087 | 33230 | 694 |
1796855 | 1796855 | 2021-10-08 | Henrico | Virginia | 51087 | 33230 | 694 |
1793606 | 1793606 | 2021-10-07 | Henrico | Virginia | 51087 | 33127 | 698 |
1790357 | 1790357 | 2021-10-06 | Henrico | Virginia | 51087 | 33054 | 698 |
1787109 | 1787109 | 2021-10-05 | Henrico | Virginia | 51087 | 32944 | 696 |
1783860 | 1783860 | 2021-10-04 | Henrico | Virginia | 51087 | 32898 | 690 |
1780611 | 1780611 | 2021-10-03 | Henrico | Virginia | 51087 | 32659 | 687 |
1777361 | 1777361 | 2021-10-02 | Henrico | Virginia | 51087 | 32659 | 687 |
1774111 | 1774111 | 2021-10-01 | Henrico | Virginia | 51087 | 32659 | 687 |
1770861 | 1770861 | 2021-09-30 | Henrico | Virginia | 51087 | 32584 | 683 |
1767612 | 1767612 | 2021-09-29 | Henrico | Virginia | 51087 | 32493 | 681 |
1764363 | 1764363 | 2021-09-28 | Henrico | Virginia | 51087 | 32411 | 681 |
1761114 | 1761114 | 2021-09-27 | Henrico | Virginia | 51087 | 32324 | 679 |
1757866 | 1757866 | 2021-09-26 | Henrico | Virginia | 51087 | 32106 | 677 |
1754618 | 1754618 | 2021-09-25 | Henrico | Virginia | 51087 | 32106 | 677 |
1751370 | 1751370 | 2021-09-24 | Henrico | Virginia | 51087 | 32106 | 677 |
1748121 | 1748121 | 2021-09-23 | Henrico | Virginia | 51087 | 32034 | 676 |
1744871 | 1744871 | 2021-09-22 | Henrico | Virginia | 51087 | 31907 | 675 |
1741622 | 1741622 | 2021-09-21 | Henrico | Virginia | 51087 | 31770 | 673 |
1738373 | 1738373 | 2021-09-20 | Henrico | Virginia | 51087 | 31667 | 670 |
1735124 | 1735124 | 2021-09-19 | Henrico | Virginia | 51087 | 31422 | 668 |
1731874 | 1731874 | 2021-09-18 | Henrico | Virginia | 51087 | 31422 | 668 |
1728624 | 1728624 | 2021-09-17 | Henrico | Virginia | 51087 | 31422 | 668 |
1725374 | 1725374 | 2021-09-16 | Henrico | Virginia | 51087 | 31288 | 666 |
1722125 | 1722125 | 2021-09-15 | Henrico | Virginia | 51087 | 31183 | 665 |
1718877 | 1718877 | 2021-09-14 | Henrico | Virginia | 51087 | 31066 | 662 |
1715629 | 1715629 | 2021-09-13 | Henrico | Virginia | 51087 | 30928 | 660 |
1712383 | 1712383 | 2021-09-12 | Henrico | Virginia | 51087 | 30630 | 660 |
1709136 | 1709136 | 2021-09-11 | Henrico | Virginia | 51087 | 30630 | 660 |
1705889 | 1705889 | 2021-09-10 | Henrico | Virginia | 51087 | 30630 | 660 |
1702639 | 1702639 | 2021-09-09 | Henrico | Virginia | 51087 | 30503 | 658 |
1699390 | 1699390 | 2021-09-08 | Henrico | Virginia | 51087 | 30388 | 656 |
1696142 | 1696142 | 2021-09-07 | Henrico | Virginia | 51087 | 30243 | 656 |
1692894 | 1692894 | 2021-09-06 | Henrico | Virginia | 51087 | 30172 | 654 |
1689645 | 1689645 | 2021-09-05 | Henrico | Virginia | 51087 | 29847 | 653 |
1686395 | 1686395 | 2021-09-04 | Henrico | Virginia | 51087 | 29847 | 653 |
1683144 | 1683144 | 2021-09-03 | Henrico | Virginia | 51087 | 29847 | 653 |
1679894 | 1679894 | 2021-09-02 | Henrico | Virginia | 51087 | 29714 | 652 |
1676646 | 1676646 | 2021-09-01 | Henrico | Virginia | 51087 | 29581 | 651 |
1673399 | 1673399 | 2021-08-31 | Henrico | Virginia | 51087 | 29472 | 651 |
1670151 | 1670151 | 2021-08-30 | Henrico | Virginia | 51087 | 29357 | 650 |
1666904 | 1666904 | 2021-08-29 | Henrico | Virginia | 51087 | 29025 | 649 |
1663656 | 1663656 | 2021-08-28 | Henrico | Virginia | 51087 | 29025 | 649 |
1660408 | 1660408 | 2021-08-27 | Henrico | Virginia | 51087 | 29025 | 649 |
1657159 | 1657159 | 2021-08-26 | Henrico | Virginia | 51087 | 28873 | 647 |
1653912 | 1653912 | 2021-08-25 | Henrico | Virginia | 51087 | 28712 | 647 |
1650666 | 1650666 | 2021-08-24 | Henrico | Virginia | 51087 | 28592 | 645 |
1647417 | 1647417 | 2021-08-23 | Henrico | Virginia | 51087 | 28473 | 644 |
1644168 | 1644168 | 2021-08-22 | Henrico | Virginia | 51087 | 28138 | 643 |
1640918 | 1640918 | 2021-08-21 | Henrico | Virginia | 51087 | 28138 | 643 |
1637668 | 1637668 | 2021-08-20 | Henrico | Virginia | 51087 | 28138 | 643 |
1634418 | 1634418 | 2021-08-19 | Henrico | Virginia | 51087 | 28041 | 643 |
1631170 | 1631170 | 2021-08-18 | Henrico | Virginia | 51087 | 27915 | 643 |
1627923 | 1627923 | 2021-08-17 | Henrico | Virginia | 51087 | 27848 | 643 |
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);