ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where fips = 51097 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177191 | 2177191 | 2022-02-02 | King and Queen | Virginia | 51097 | 1075 | 10 |
2173938 | 2173938 | 2022-02-01 | King and Queen | Virginia | 51097 | 1072 | 10 |
2170686 | 2170686 | 2022-01-31 | King and Queen | Virginia | 51097 | 1067 | 10 |
2167433 | 2167433 | 2022-01-30 | King and Queen | Virginia | 51097 | 1054 | 10 |
2164178 | 2164178 | 2022-01-29 | King and Queen | Virginia | 51097 | 1054 | 10 |
2160923 | 2160923 | 2022-01-28 | King and Queen | Virginia | 51097 | 1054 | 10 |
2157667 | 2157667 | 2022-01-27 | King and Queen | Virginia | 51097 | 1046 | 10 |
2154414 | 2154414 | 2022-01-26 | King and Queen | Virginia | 51097 | 1036 | 10 |
2151161 | 2151161 | 2022-01-25 | King and Queen | Virginia | 51097 | 1024 | 9 |
2147909 | 2147909 | 2022-01-24 | King and Queen | Virginia | 51097 | 1015 | 9 |
2144656 | 2144656 | 2022-01-23 | King and Queen | Virginia | 51097 | 994 | 9 |
2141401 | 2141401 | 2022-01-22 | King and Queen | Virginia | 51097 | 994 | 9 |
2138145 | 2138145 | 2022-01-21 | King and Queen | Virginia | 51097 | 994 | 9 |
2134891 | 2134891 | 2022-01-20 | King and Queen | Virginia | 51097 | 987 | 9 |
2131639 | 2131639 | 2022-01-19 | King and Queen | Virginia | 51097 | 978 | 9 |
2128385 | 2128385 | 2022-01-18 | King and Queen | Virginia | 51097 | 972 | 9 |
2125132 | 2125132 | 2022-01-17 | King and Queen | Virginia | 51097 | 966 | 9 |
2121880 | 2121880 | 2022-01-16 | King and Queen | Virginia | 51097 | 937 | 9 |
2118628 | 2118628 | 2022-01-15 | King and Queen | Virginia | 51097 | 937 | 9 |
2115376 | 2115376 | 2022-01-14 | King and Queen | Virginia | 51097 | 937 | 9 |
2112124 | 2112124 | 2022-01-13 | King and Queen | Virginia | 51097 | 926 | 9 |
2108872 | 2108872 | 2022-01-12 | King and Queen | Virginia | 51097 | 914 | 9 |
2105621 | 2105621 | 2022-01-11 | King and Queen | Virginia | 51097 | 899 | 9 |
2102370 | 2102370 | 2022-01-10 | King and Queen | Virginia | 51097 | 890 | 9 |
2099119 | 2099119 | 2022-01-09 | King and Queen | Virginia | 51097 | 835 | 9 |
2095868 | 2095868 | 2022-01-08 | King and Queen | Virginia | 51097 | 835 | 9 |
2092616 | 2092616 | 2022-01-07 | King and Queen | Virginia | 51097 | 835 | 9 |
2089364 | 2089364 | 2022-01-06 | King and Queen | Virginia | 51097 | 817 | 9 |
2086113 | 2086113 | 2022-01-05 | King and Queen | Virginia | 51097 | 804 | 9 |
2082861 | 2082861 | 2022-01-04 | King and Queen | Virginia | 51097 | 802 | 9 |
2079609 | 2079609 | 2022-01-03 | King and Queen | Virginia | 51097 | 790 | 9 |
2076357 | 2076357 | 2022-01-02 | King and Queen | Virginia | 51097 | 755 | 9 |
2073106 | 2073106 | 2022-01-01 | King and Queen | Virginia | 51097 | 755 | 9 |
2069855 | 2069855 | 2021-12-31 | King and Queen | Virginia | 51097 | 755 | 9 |
2066604 | 2066604 | 2021-12-30 | King and Queen | Virginia | 51097 | 746 | 9 |
2063354 | 2063354 | 2021-12-29 | King and Queen | Virginia | 51097 | 737 | 9 |
2060104 | 2060104 | 2021-12-28 | King and Queen | Virginia | 51097 | 730 | 9 |
2056855 | 2056855 | 2021-12-27 | King and Queen | Virginia | 51097 | 728 | 9 |
2053606 | 2053606 | 2021-12-26 | King and Queen | Virginia | 51097 | 720 | 9 |
2050356 | 2050356 | 2021-12-25 | King and Queen | Virginia | 51097 | 720 | 9 |
2047106 | 2047106 | 2021-12-24 | King and Queen | Virginia | 51097 | 720 | 9 |
2043856 | 2043856 | 2021-12-23 | King and Queen | Virginia | 51097 | 718 | 9 |
2040607 | 2040607 | 2021-12-22 | King and Queen | Virginia | 51097 | 718 | 9 |
2037357 | 2037357 | 2021-12-21 | King and Queen | Virginia | 51097 | 712 | 9 |
2034107 | 2034107 | 2021-12-20 | King and Queen | Virginia | 51097 | 710 | 9 |
2030857 | 2030857 | 2021-12-19 | King and Queen | Virginia | 51097 | 702 | 9 |
2027606 | 2027606 | 2021-12-18 | King and Queen | Virginia | 51097 | 702 | 9 |
2024355 | 2024355 | 2021-12-17 | King and Queen | Virginia | 51097 | 702 | 9 |
2021104 | 2021104 | 2021-12-16 | King and Queen | Virginia | 51097 | 700 | 9 |
2017853 | 2017853 | 2021-12-15 | King and Queen | Virginia | 51097 | 699 | 9 |
2014603 | 2014603 | 2021-12-14 | King and Queen | Virginia | 51097 | 695 | 9 |
2011352 | 2011352 | 2021-12-13 | King and Queen | Virginia | 51097 | 695 | 9 |
2008101 | 2008101 | 2021-12-12 | King and Queen | Virginia | 51097 | 690 | 9 |
2004850 | 2004850 | 2021-12-11 | King and Queen | Virginia | 51097 | 690 | 9 |
2001599 | 2001599 | 2021-12-10 | King and Queen | Virginia | 51097 | 690 | 9 |
1998349 | 1998349 | 2021-12-09 | King and Queen | Virginia | 51097 | 687 | 9 |
1995098 | 1995098 | 2021-12-08 | King and Queen | Virginia | 51097 | 685 | 9 |
1991847 | 1991847 | 2021-12-07 | King and Queen | Virginia | 51097 | 684 | 9 |
1988596 | 1988596 | 2021-12-06 | King and Queen | Virginia | 51097 | 682 | 9 |
1985346 | 1985346 | 2021-12-05 | King and Queen | Virginia | 51097 | 675 | 9 |
1982096 | 1982096 | 2021-12-04 | King and Queen | Virginia | 51097 | 675 | 9 |
1978846 | 1978846 | 2021-12-03 | King and Queen | Virginia | 51097 | 675 | 9 |
1975596 | 1975596 | 2021-12-02 | King and Queen | Virginia | 51097 | 674 | 9 |
1972347 | 1972347 | 2021-12-01 | King and Queen | Virginia | 51097 | 671 | 9 |
1969097 | 1969097 | 2021-11-30 | King and Queen | Virginia | 51097 | 671 | 9 |
1965847 | 1965847 | 2021-11-29 | King and Queen | Virginia | 51097 | 668 | 9 |
1962595 | 1962595 | 2021-11-28 | King and Queen | Virginia | 51097 | 667 | 8 |
1959344 | 1959344 | 2021-11-27 | King and Queen | Virginia | 51097 | 667 | 8 |
1956093 | 1956093 | 2021-11-26 | King and Queen | Virginia | 51097 | 667 | 8 |
1952842 | 1952842 | 2021-11-25 | King and Queen | Virginia | 51097 | 666 | 8 |
1949591 | 1949591 | 2021-11-24 | King and Queen | Virginia | 51097 | 665 | 8 |
1946340 | 1946340 | 2021-11-23 | King and Queen | Virginia | 51097 | 663 | 8 |
1943089 | 1943089 | 2021-11-22 | King and Queen | Virginia | 51097 | 662 | 8 |
1939839 | 1939839 | 2021-11-21 | King and Queen | Virginia | 51097 | 658 | 8 |
1936589 | 1936589 | 2021-11-20 | King and Queen | Virginia | 51097 | 658 | 8 |
1933339 | 1933339 | 2021-11-19 | King and Queen | Virginia | 51097 | 658 | 8 |
1930087 | 1930087 | 2021-11-18 | King and Queen | Virginia | 51097 | 656 | 8 |
1926837 | 1926837 | 2021-11-17 | King and Queen | Virginia | 51097 | 655 | 8 |
1923587 | 1923587 | 2021-11-16 | King and Queen | Virginia | 51097 | 653 | 8 |
1920338 | 1920338 | 2021-11-15 | King and Queen | Virginia | 51097 | 651 | 8 |
1917088 | 1917088 | 2021-11-14 | King and Queen | Virginia | 51097 | 650 | 8 |
1913838 | 1913838 | 2021-11-13 | King and Queen | Virginia | 51097 | 650 | 8 |
1910588 | 1910588 | 2021-11-12 | King and Queen | Virginia | 51097 | 650 | 8 |
1907339 | 1907339 | 2021-11-11 | King and Queen | Virginia | 51097 | 649 | 8 |
1904090 | 1904090 | 2021-11-10 | King and Queen | Virginia | 51097 | 647 | 8 |
1900840 | 1900840 | 2021-11-09 | King and Queen | Virginia | 51097 | 648 | 8 |
1897590 | 1897590 | 2021-11-08 | King and Queen | Virginia | 51097 | 646 | 8 |
1894340 | 1894340 | 2021-11-07 | King and Queen | Virginia | 51097 | 642 | 8 |
1891090 | 1891090 | 2021-11-06 | King and Queen | Virginia | 51097 | 642 | 8 |
1887840 | 1887840 | 2021-11-05 | King and Queen | Virginia | 51097 | 642 | 8 |
1884590 | 1884590 | 2021-11-04 | King and Queen | Virginia | 51097 | 642 | 8 |
1881341 | 1881341 | 2021-11-03 | King and Queen | Virginia | 51097 | 640 | 8 |
1878092 | 1878092 | 2021-11-02 | King and Queen | Virginia | 51097 | 640 | 8 |
1874843 | 1874843 | 2021-11-01 | King and Queen | Virginia | 51097 | 640 | 8 |
1871594 | 1871594 | 2021-10-31 | King and Queen | Virginia | 51097 | 637 | 8 |
1868345 | 1868345 | 2021-10-30 | King and Queen | Virginia | 51097 | 637 | 8 |
1865096 | 1865096 | 2021-10-29 | King and Queen | Virginia | 51097 | 637 | 8 |
1861847 | 1861847 | 2021-10-28 | King and Queen | Virginia | 51097 | 634 | 8 |
1858598 | 1858598 | 2021-10-27 | King and Queen | Virginia | 51097 | 634 | 8 |
1855349 | 1855349 | 2021-10-26 | King and Queen | Virginia | 51097 | 634 | 8 |
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);