ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Rappahannock" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2112161 | 2112161 | 2022-01-13 | Rappahannock | Virginia | 51157 | 799 | 7 |
2108909 | 2108909 | 2022-01-12 | Rappahannock | Virginia | 51157 | 794 | 7 |
2105658 | 2105658 | 2022-01-11 | Rappahannock | Virginia | 51157 | 791 | 7 |
2102407 | 2102407 | 2022-01-10 | Rappahannock | Virginia | 51157 | 788 | 7 |
2099156 | 2099156 | 2022-01-09 | Rappahannock | Virginia | 51157 | 762 | 7 |
2095905 | 2095905 | 2022-01-08 | Rappahannock | Virginia | 51157 | 762 | 7 |
2092653 | 2092653 | 2022-01-07 | Rappahannock | Virginia | 51157 | 762 | 7 |
2089401 | 2089401 | 2022-01-06 | Rappahannock | Virginia | 51157 | 755 | 7 |
2086150 | 2086150 | 2022-01-05 | Rappahannock | Virginia | 51157 | 752 | 7 |
2082898 | 2082898 | 2022-01-04 | Rappahannock | Virginia | 51157 | 748 | 7 |
2079646 | 2079646 | 2022-01-03 | Rappahannock | Virginia | 51157 | 744 | 7 |
2076394 | 2076394 | 2022-01-02 | Rappahannock | Virginia | 51157 | 729 | 7 |
2073143 | 2073143 | 2022-01-01 | Rappahannock | Virginia | 51157 | 729 | 7 |
2069892 | 2069892 | 2021-12-31 | Rappahannock | Virginia | 51157 | 729 | 7 |
2066641 | 2066641 | 2021-12-30 | Rappahannock | Virginia | 51157 | 714 | 7 |
2063391 | 2063391 | 2021-12-29 | Rappahannock | Virginia | 51157 | 708 | 7 |
2060141 | 2060141 | 2021-12-28 | Rappahannock | Virginia | 51157 | 700 | 7 |
2056892 | 2056892 | 2021-12-27 | Rappahannock | Virginia | 51157 | 698 | 7 |
2053643 | 2053643 | 2021-12-26 | Rappahannock | Virginia | 51157 | 688 | 7 |
2050393 | 2050393 | 2021-12-25 | Rappahannock | Virginia | 51157 | 688 | 7 |
2047143 | 2047143 | 2021-12-24 | Rappahannock | Virginia | 51157 | 688 | 7 |
2043893 | 2043893 | 2021-12-23 | Rappahannock | Virginia | 51157 | 684 | 7 |
2040644 | 2040644 | 2021-12-22 | Rappahannock | Virginia | 51157 | 679 | 7 |
2037394 | 2037394 | 2021-12-21 | Rappahannock | Virginia | 51157 | 674 | 7 |
2034144 | 2034144 | 2021-12-20 | Rappahannock | Virginia | 51157 | 673 | 7 |
2030894 | 2030894 | 2021-12-19 | Rappahannock | Virginia | 51157 | 672 | 7 |
2027643 | 2027643 | 2021-12-18 | Rappahannock | Virginia | 51157 | 672 | 7 |
2024392 | 2024392 | 2021-12-17 | Rappahannock | Virginia | 51157 | 672 | 7 |
2021141 | 2021141 | 2021-12-16 | Rappahannock | Virginia | 51157 | 669 | 7 |
2017890 | 2017890 | 2021-12-15 | Rappahannock | Virginia | 51157 | 667 | 6 |
2014640 | 2014640 | 2021-12-14 | Rappahannock | Virginia | 51157 | 662 | 6 |
2011389 | 2011389 | 2021-12-13 | Rappahannock | Virginia | 51157 | 658 | 6 |
2008138 | 2008138 | 2021-12-12 | Rappahannock | Virginia | 51157 | 654 | 5 |
2004887 | 2004887 | 2021-12-11 | Rappahannock | Virginia | 51157 | 654 | 5 |
2001636 | 2001636 | 2021-12-10 | Rappahannock | Virginia | 51157 | 654 | 5 |
1998386 | 1998386 | 2021-12-09 | Rappahannock | Virginia | 51157 | 649 | 5 |
1995135 | 1995135 | 2021-12-08 | Rappahannock | Virginia | 51157 | 646 | 5 |
1991884 | 1991884 | 2021-12-07 | Rappahannock | Virginia | 51157 | 645 | 5 |
1988633 | 1988633 | 2021-12-06 | Rappahannock | Virginia | 51157 | 644 | 5 |
1985383 | 1985383 | 2021-12-05 | Rappahannock | Virginia | 51157 | 639 | 5 |
1982133 | 1982133 | 2021-12-04 | Rappahannock | Virginia | 51157 | 639 | 5 |
1978883 | 1978883 | 2021-12-03 | Rappahannock | Virginia | 51157 | 639 | 5 |
1975633 | 1975633 | 2021-12-02 | Rappahannock | Virginia | 51157 | 638 | 5 |
1972384 | 1972384 | 2021-12-01 | Rappahannock | Virginia | 51157 | 636 | 5 |
1969134 | 1969134 | 2021-11-30 | Rappahannock | Virginia | 51157 | 635 | 5 |
1965884 | 1965884 | 2021-11-29 | Rappahannock | Virginia | 51157 | 634 | 5 |
1962632 | 1962632 | 2021-11-28 | Rappahannock | Virginia | 51157 | 627 | 5 |
1959381 | 1959381 | 2021-11-27 | Rappahannock | Virginia | 51157 | 627 | 5 |
1956130 | 1956130 | 2021-11-26 | Rappahannock | Virginia | 51157 | 627 | 5 |
1952879 | 1952879 | 2021-11-25 | Rappahannock | Virginia | 51157 | 627 | 5 |
1949628 | 1949628 | 2021-11-24 | Rappahannock | Virginia | 51157 | 626 | 5 |
1946377 | 1946377 | 2021-11-23 | Rappahannock | Virginia | 51157 | 622 | 5 |
1943126 | 1943126 | 2021-11-22 | Rappahannock | Virginia | 51157 | 620 | 5 |
1939876 | 1939876 | 2021-11-21 | Rappahannock | Virginia | 51157 | 616 | 5 |
1936626 | 1936626 | 2021-11-20 | Rappahannock | Virginia | 51157 | 616 | 5 |
1933376 | 1933376 | 2021-11-19 | Rappahannock | Virginia | 51157 | 616 | 5 |
1930124 | 1930124 | 2021-11-18 | Rappahannock | Virginia | 51157 | 615 | 5 |
1926874 | 1926874 | 2021-11-17 | Rappahannock | Virginia | 51157 | 611 | 5 |
1923624 | 1923624 | 2021-11-16 | Rappahannock | Virginia | 51157 | 608 | 5 |
1920375 | 1920375 | 2021-11-15 | Rappahannock | Virginia | 51157 | 605 | 5 |
1917125 | 1917125 | 2021-11-14 | Rappahannock | Virginia | 51157 | 604 | 5 |
1913875 | 1913875 | 2021-11-13 | Rappahannock | Virginia | 51157 | 604 | 5 |
1910625 | 1910625 | 2021-11-12 | Rappahannock | Virginia | 51157 | 604 | 5 |
1907376 | 1907376 | 2021-11-11 | Rappahannock | Virginia | 51157 | 602 | 5 |
1904127 | 1904127 | 2021-11-10 | Rappahannock | Virginia | 51157 | 601 | 5 |
1900877 | 1900877 | 2021-11-09 | Rappahannock | Virginia | 51157 | 598 | 5 |
1897627 | 1897627 | 2021-11-08 | Rappahannock | Virginia | 51157 | 598 | 5 |
1894377 | 1894377 | 2021-11-07 | Rappahannock | Virginia | 51157 | 590 | 5 |
1891127 | 1891127 | 2021-11-06 | Rappahannock | Virginia | 51157 | 590 | 5 |
1887877 | 1887877 | 2021-11-05 | Rappahannock | Virginia | 51157 | 590 | 5 |
1884627 | 1884627 | 2021-11-04 | Rappahannock | Virginia | 51157 | 589 | 4 |
1881378 | 1881378 | 2021-11-03 | Rappahannock | Virginia | 51157 | 586 | 4 |
1878129 | 1878129 | 2021-11-02 | Rappahannock | Virginia | 51157 | 582 | 4 |
1874880 | 1874880 | 2021-11-01 | Rappahannock | Virginia | 51157 | 580 | 4 |
1871631 | 1871631 | 2021-10-31 | Rappahannock | Virginia | 51157 | 577 | 4 |
1868382 | 1868382 | 2021-10-30 | Rappahannock | Virginia | 51157 | 577 | 4 |
1865133 | 1865133 | 2021-10-29 | Rappahannock | Virginia | 51157 | 577 | 4 |
1861884 | 1861884 | 2021-10-28 | Rappahannock | Virginia | 51157 | 577 | 4 |
1858635 | 1858635 | 2021-10-27 | Rappahannock | Virginia | 51157 | 576 | 4 |
1855386 | 1855386 | 2021-10-26 | Rappahannock | Virginia | 51157 | 575 | 4 |
1852137 | 1852137 | 2021-10-25 | Rappahannock | Virginia | 51157 | 575 | 4 |
1848887 | 1848887 | 2021-10-24 | Rappahannock | Virginia | 51157 | 574 | 4 |
1845637 | 1845637 | 2021-10-23 | Rappahannock | Virginia | 51157 | 574 | 4 |
1842387 | 1842387 | 2021-10-22 | Rappahannock | Virginia | 51157 | 574 | 4 |
1839138 | 1839138 | 2021-10-21 | Rappahannock | Virginia | 51157 | 570 | 4 |
1835889 | 1835889 | 2021-10-20 | Rappahannock | Virginia | 51157 | 567 | 4 |
1832640 | 1832640 | 2021-10-19 | Rappahannock | Virginia | 51157 | 566 | 4 |
1829391 | 1829391 | 2021-10-18 | Rappahannock | Virginia | 51157 | 563 | 4 |
1826142 | 1826142 | 2021-10-17 | Rappahannock | Virginia | 51157 | 559 | 4 |
1822893 | 1822893 | 2021-10-16 | Rappahannock | Virginia | 51157 | 559 | 4 |
1819644 | 1819644 | 2021-10-15 | Rappahannock | Virginia | 51157 | 559 | 4 |
1816395 | 1816395 | 2021-10-14 | Rappahannock | Virginia | 51157 | 554 | 4 |
1813147 | 1813147 | 2021-10-13 | Rappahannock | Virginia | 51157 | 551 | 4 |
1809898 | 1809898 | 2021-10-12 | Rappahannock | Virginia | 51157 | 546 | 4 |
1806648 | 1806648 | 2021-10-11 | Rappahannock | Virginia | 51157 | 538 | 4 |
1803398 | 1803398 | 2021-10-10 | Rappahannock | Virginia | 51157 | 538 | 4 |
1800149 | 1800149 | 2021-10-09 | Rappahannock | Virginia | 51157 | 538 | 4 |
1796900 | 1796900 | 2021-10-08 | Rappahannock | Virginia | 51157 | 538 | 4 |
1793651 | 1793651 | 2021-10-07 | Rappahannock | Virginia | 51157 | 535 | 4 |
1790402 | 1790402 | 2021-10-06 | Rappahannock | Virginia | 51157 | 532 | 4 |
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);