ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Henrico" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2112116 | 2112116 | 2022-01-13 | Henrico | Virginia | 51087 | 51281 | 754 |
2108864 | 2108864 | 2022-01-12 | Henrico | Virginia | 51087 | 50648 | 754 |
2105613 | 2105613 | 2022-01-11 | Henrico | Virginia | 51087 | 49903 | 753 |
2102362 | 2102362 | 2022-01-10 | Henrico | Virginia | 51087 | 49176 | 750 |
2099111 | 2099111 | 2022-01-09 | Henrico | Virginia | 51087 | 47181 | 750 |
2095860 | 2095860 | 2022-01-08 | Henrico | Virginia | 51087 | 47181 | 750 |
2092608 | 2092608 | 2022-01-07 | Henrico | Virginia | 51087 | 47181 | 750 |
2089356 | 2089356 | 2022-01-06 | Henrico | Virginia | 51087 | 46502 | 750 |
2086105 | 2086105 | 2022-01-05 | Henrico | Virginia | 51087 | 45747 | 750 |
2082853 | 2082853 | 2022-01-04 | Henrico | Virginia | 51087 | 45200 | 750 |
2079601 | 2079601 | 2022-01-03 | Henrico | Virginia | 51087 | 44535 | 750 |
2076349 | 2076349 | 2022-01-02 | Henrico | Virginia | 51087 | 42631 | 749 |
2073098 | 2073098 | 2022-01-01 | Henrico | Virginia | 51087 | 42631 | 749 |
2069847 | 2069847 | 2021-12-31 | Henrico | Virginia | 51087 | 42631 | 749 |
2066596 | 2066596 | 2021-12-30 | Henrico | Virginia | 51087 | 41848 | 749 |
2063346 | 2063346 | 2021-12-29 | Henrico | Virginia | 51087 | 41247 | 748 |
2060096 | 2060096 | 2021-12-28 | Henrico | Virginia | 51087 | 40623 | 747 |
2056847 | 2056847 | 2021-12-27 | Henrico | Virginia | 51087 | 40195 | 747 |
2053598 | 2053598 | 2021-12-26 | Henrico | Virginia | 51087 | 39184 | 746 |
2050348 | 2050348 | 2021-12-25 | Henrico | Virginia | 51087 | 39184 | 746 |
2047098 | 2047098 | 2021-12-24 | Henrico | Virginia | 51087 | 39184 | 746 |
2043848 | 2043848 | 2021-12-23 | Henrico | Virginia | 51087 | 38770 | 745 |
2040599 | 2040599 | 2021-12-22 | Henrico | Virginia | 51087 | 38552 | 745 |
2037349 | 2037349 | 2021-12-21 | Henrico | Virginia | 51087 | 38349 | 745 |
2034099 | 2034099 | 2021-12-20 | Henrico | Virginia | 51087 | 38166 | 744 |
2030849 | 2030849 | 2021-12-19 | Henrico | Virginia | 51087 | 37746 | 744 |
2027598 | 2027598 | 2021-12-18 | Henrico | Virginia | 51087 | 37746 | 744 |
2024347 | 2024347 | 2021-12-17 | Henrico | Virginia | 51087 | 37746 | 744 |
2021096 | 2021096 | 2021-12-16 | Henrico | Virginia | 51087 | 37596 | 744 |
2017845 | 2017845 | 2021-12-15 | Henrico | Virginia | 51087 | 37457 | 740 |
2014595 | 2014595 | 2021-12-14 | Henrico | Virginia | 51087 | 37348 | 739 |
2011344 | 2011344 | 2021-12-13 | Henrico | Virginia | 51087 | 37255 | 738 |
2008093 | 2008093 | 2021-12-12 | Henrico | Virginia | 51087 | 36966 | 737 |
2004842 | 2004842 | 2021-12-11 | Henrico | Virginia | 51087 | 36966 | 737 |
2001591 | 2001591 | 2021-12-10 | Henrico | Virginia | 51087 | 36966 | 737 |
1998341 | 1998341 | 2021-12-09 | Henrico | Virginia | 51087 | 36845 | 737 |
1995090 | 1995090 | 2021-12-08 | Henrico | Virginia | 51087 | 36692 | 736 |
1991839 | 1991839 | 2021-12-07 | Henrico | Virginia | 51087 | 36603 | 736 |
1988588 | 1988588 | 2021-12-06 | Henrico | Virginia | 51087 | 36530 | 736 |
1985338 | 1985338 | 2021-12-05 | Henrico | Virginia | 51087 | 36220 | 737 |
1982088 | 1982088 | 2021-12-04 | Henrico | Virginia | 51087 | 36220 | 737 |
1978838 | 1978838 | 2021-12-03 | Henrico | Virginia | 51087 | 36220 | 737 |
1975588 | 1975588 | 2021-12-02 | Henrico | Virginia | 51087 | 36120 | 735 |
1972339 | 1972339 | 2021-12-01 | Henrico | Virginia | 51087 | 35998 | 735 |
1969089 | 1969089 | 2021-11-30 | Henrico | Virginia | 51087 | 35911 | 734 |
1965839 | 1965839 | 2021-11-29 | Henrico | Virginia | 51087 | 35843 | 734 |
1962587 | 1962587 | 2021-11-28 | Henrico | Virginia | 51087 | 35665 | 731 |
1959336 | 1959336 | 2021-11-27 | Henrico | Virginia | 51087 | 35665 | 731 |
1956085 | 1956085 | 2021-11-26 | Henrico | Virginia | 51087 | 35665 | 731 |
1952834 | 1952834 | 2021-11-25 | Henrico | Virginia | 51087 | 35596 | 731 |
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 |
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);