ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Franklin" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2112101 | 2112101 | 2022-01-13 | Franklin | Virginia | 51067 | 8308 | 134 |
2108849 | 2108849 | 2022-01-12 | Franklin | Virginia | 51067 | 8206 | 134 |
2105598 | 2105598 | 2022-01-11 | Franklin | Virginia | 51067 | 8085 | 133 |
2102347 | 2102347 | 2022-01-10 | Franklin | Virginia | 51067 | 8025 | 132 |
2099096 | 2099096 | 2022-01-09 | Franklin | Virginia | 51067 | 7740 | 132 |
2095845 | 2095845 | 2022-01-08 | Franklin | Virginia | 51067 | 7740 | 132 |
2092593 | 2092593 | 2022-01-07 | Franklin | Virginia | 51067 | 7740 | 132 |
2089341 | 2089341 | 2022-01-06 | Franklin | Virginia | 51067 | 7675 | 132 |
2086090 | 2086090 | 2022-01-05 | Franklin | Virginia | 51067 | 7617 | 132 |
2082838 | 2082838 | 2022-01-04 | Franklin | Virginia | 51067 | 7582 | 132 |
2079586 | 2079586 | 2022-01-03 | Franklin | Virginia | 51067 | 7533 | 132 |
2076334 | 2076334 | 2022-01-02 | Franklin | Virginia | 51067 | 7387 | 129 |
2073083 | 2073083 | 2022-01-01 | Franklin | Virginia | 51067 | 7387 | 129 |
2069832 | 2069832 | 2021-12-31 | Franklin | Virginia | 51067 | 7387 | 129 |
2066581 | 2066581 | 2021-12-30 | Franklin | Virginia | 51067 | 7298 | 129 |
2063331 | 2063331 | 2021-12-29 | Franklin | Virginia | 51067 | 7255 | 128 |
2060081 | 2060081 | 2021-12-28 | Franklin | Virginia | 51067 | 7205 | 128 |
2056832 | 2056832 | 2021-12-27 | Franklin | Virginia | 51067 | 7173 | 126 |
2053583 | 2053583 | 2021-12-26 | Franklin | Virginia | 51067 | 7117 | 126 |
2050333 | 2050333 | 2021-12-25 | Franklin | Virginia | 51067 | 7117 | 126 |
2047083 | 2047083 | 2021-12-24 | Franklin | Virginia | 51067 | 7117 | 126 |
2043833 | 2043833 | 2021-12-23 | Franklin | Virginia | 51067 | 7084 | 126 |
2040584 | 2040584 | 2021-12-22 | Franklin | Virginia | 51067 | 7061 | 123 |
2037334 | 2037334 | 2021-12-21 | Franklin | Virginia | 51067 | 7044 | 121 |
2034084 | 2034084 | 2021-12-20 | Franklin | Virginia | 51067 | 7033 | 120 |
2030834 | 2030834 | 2021-12-19 | Franklin | Virginia | 51067 | 6959 | 118 |
2027583 | 2027583 | 2021-12-18 | Franklin | Virginia | 51067 | 6959 | 118 |
2024332 | 2024332 | 2021-12-17 | Franklin | Virginia | 51067 | 6959 | 118 |
2021081 | 2021081 | 2021-12-16 | Franklin | Virginia | 51067 | 6935 | 117 |
2017830 | 2017830 | 2021-12-15 | Franklin | Virginia | 51067 | 6902 | 116 |
2014580 | 2014580 | 2021-12-14 | Franklin | Virginia | 51067 | 6868 | 116 |
2011329 | 2011329 | 2021-12-13 | Franklin | Virginia | 51067 | 6847 | 115 |
2008078 | 2008078 | 2021-12-12 | Franklin | Virginia | 51067 | 6751 | 115 |
2004827 | 2004827 | 2021-12-11 | Franklin | Virginia | 51067 | 6751 | 115 |
2001576 | 2001576 | 2021-12-10 | Franklin | Virginia | 51067 | 6751 | 115 |
1998326 | 1998326 | 2021-12-09 | Franklin | Virginia | 51067 | 6724 | 114 |
1995075 | 1995075 | 2021-12-08 | Franklin | Virginia | 51067 | 6693 | 114 |
1991824 | 1991824 | 2021-12-07 | Franklin | Virginia | 51067 | 6648 | 114 |
1988573 | 1988573 | 2021-12-06 | Franklin | Virginia | 51067 | 6638 | 112 |
1985323 | 1985323 | 2021-12-05 | Franklin | Virginia | 51067 | 6557 | 112 |
1982073 | 1982073 | 2021-12-04 | Franklin | Virginia | 51067 | 6557 | 112 |
1978823 | 1978823 | 2021-12-03 | Franklin | Virginia | 51067 | 6557 | 112 |
1975573 | 1975573 | 2021-12-02 | Franklin | Virginia | 51067 | 6516 | 112 |
1972324 | 1972324 | 2021-12-01 | Franklin | Virginia | 51067 | 6492 | 112 |
1969074 | 1969074 | 2021-11-30 | Franklin | Virginia | 51067 | 6470 | 112 |
1965824 | 1965824 | 2021-11-29 | Franklin | Virginia | 51067 | 6457 | 112 |
1962572 | 1962572 | 2021-11-28 | Franklin | Virginia | 51067 | 6419 | 112 |
1959321 | 1959321 | 2021-11-27 | Franklin | Virginia | 51067 | 6419 | 112 |
1956070 | 1956070 | 2021-11-26 | Franklin | Virginia | 51067 | 6419 | 112 |
1952819 | 1952819 | 2021-11-25 | Franklin | Virginia | 51067 | 6403 | 111 |
1949568 | 1949568 | 2021-11-24 | Franklin | Virginia | 51067 | 6380 | 111 |
1946317 | 1946317 | 2021-11-23 | Franklin | Virginia | 51067 | 6357 | 111 |
1943066 | 1943066 | 2021-11-22 | Franklin | Virginia | 51067 | 6346 | 111 |
1939816 | 1939816 | 2021-11-21 | Franklin | Virginia | 51067 | 6284 | 110 |
1936566 | 1936566 | 2021-11-20 | Franklin | Virginia | 51067 | 6284 | 110 |
1933316 | 1933316 | 2021-11-19 | Franklin | Virginia | 51067 | 6284 | 110 |
1930064 | 1930064 | 2021-11-18 | Franklin | Virginia | 51067 | 6269 | 108 |
1926814 | 1926814 | 2021-11-17 | Franklin | Virginia | 51067 | 6241 | 108 |
1923564 | 1923564 | 2021-11-16 | Franklin | Virginia | 51067 | 6223 | 108 |
1920315 | 1920315 | 2021-11-15 | Franklin | Virginia | 51067 | 6213 | 108 |
1917065 | 1917065 | 2021-11-14 | Franklin | Virginia | 51067 | 6182 | 107 |
1913815 | 1913815 | 2021-11-13 | Franklin | Virginia | 51067 | 6182 | 107 |
1910565 | 1910565 | 2021-11-12 | Franklin | Virginia | 51067 | 6182 | 107 |
1907316 | 1907316 | 2021-11-11 | Franklin | Virginia | 51067 | 6170 | 107 |
1904067 | 1904067 | 2021-11-10 | Franklin | Virginia | 51067 | 6154 | 107 |
1900817 | 1900817 | 2021-11-09 | Franklin | Virginia | 51067 | 6136 | 107 |
1897567 | 1897567 | 2021-11-08 | Franklin | Virginia | 51067 | 6130 | 107 |
1894317 | 1894317 | 2021-11-07 | Franklin | Virginia | 51067 | 6097 | 107 |
1891067 | 1891067 | 2021-11-06 | Franklin | Virginia | 51067 | 6097 | 107 |
1887817 | 1887817 | 2021-11-05 | Franklin | Virginia | 51067 | 6097 | 107 |
1884567 | 1884567 | 2021-11-04 | Franklin | Virginia | 51067 | 6085 | 107 |
1881318 | 1881318 | 2021-11-03 | Franklin | Virginia | 51067 | 6080 | 106 |
1878069 | 1878069 | 2021-11-02 | Franklin | Virginia | 51067 | 6071 | 106 |
1874820 | 1874820 | 2021-11-01 | Franklin | Virginia | 51067 | 6058 | 106 |
1871571 | 1871571 | 2021-10-31 | Franklin | Virginia | 51067 | 6039 | 104 |
1868322 | 1868322 | 2021-10-30 | Franklin | Virginia | 51067 | 6039 | 104 |
1865073 | 1865073 | 2021-10-29 | Franklin | Virginia | 51067 | 6039 | 104 |
1861824 | 1861824 | 2021-10-28 | Franklin | Virginia | 51067 | 6023 | 104 |
1858575 | 1858575 | 2021-10-27 | Franklin | Virginia | 51067 | 6017 | 103 |
1855326 | 1855326 | 2021-10-26 | Franklin | Virginia | 51067 | 6000 | 102 |
1852077 | 1852077 | 2021-10-25 | Franklin | Virginia | 51067 | 5996 | 102 |
1848827 | 1848827 | 2021-10-24 | Franklin | Virginia | 51067 | 5971 | 100 |
1845577 | 1845577 | 2021-10-23 | Franklin | Virginia | 51067 | 5971 | 100 |
1842327 | 1842327 | 2021-10-22 | Franklin | Virginia | 51067 | 5971 | 100 |
1839078 | 1839078 | 2021-10-21 | Franklin | Virginia | 51067 | 5957 | 99 |
1835829 | 1835829 | 2021-10-20 | Franklin | Virginia | 51067 | 5926 | 98 |
1832580 | 1832580 | 2021-10-19 | Franklin | Virginia | 51067 | 5894 | 98 |
1829331 | 1829331 | 2021-10-18 | Franklin | Virginia | 51067 | 5882 | 98 |
1826082 | 1826082 | 2021-10-17 | Franklin | Virginia | 51067 | 5840 | 98 |
1822833 | 1822833 | 2021-10-16 | Franklin | Virginia | 51067 | 5840 | 98 |
1819584 | 1819584 | 2021-10-15 | Franklin | Virginia | 51067 | 5840 | 98 |
1816335 | 1816335 | 2021-10-14 | Franklin | Virginia | 51067 | 5822 | 98 |
1813087 | 1813087 | 2021-10-13 | Franklin | Virginia | 51067 | 5800 | 98 |
1809838 | 1809838 | 2021-10-12 | Franklin | Virginia | 51067 | 5779 | 96 |
1806588 | 1806588 | 2021-10-11 | Franklin | Virginia | 51067 | 5724 | 96 |
1803338 | 1803338 | 2021-10-10 | Franklin | Virginia | 51067 | 5724 | 96 |
1800089 | 1800089 | 2021-10-09 | Franklin | Virginia | 51067 | 5724 | 96 |
1796840 | 1796840 | 2021-10-08 | Franklin | Virginia | 51067 | 5724 | 96 |
1793591 | 1793591 | 2021-10-07 | Franklin | Virginia | 51067 | 5706 | 96 |
1790342 | 1790342 | 2021-10-06 | Franklin | Virginia | 51067 | 5674 | 96 |
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);