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 |
---|---|---|---|---|---|---|---|
2177168 | 2177168 | 2022-02-02 | Franklin | Virginia | 51067 | 9893 | 141 |
2173915 | 2173915 | 2022-02-01 | Franklin | Virginia | 51067 | 9842 | 140 |
2170663 | 2170663 | 2022-01-31 | Franklin | Virginia | 51067 | 9793 | 140 |
2167410 | 2167410 | 2022-01-30 | Franklin | Virginia | 51067 | 9641 | 140 |
2164155 | 2164155 | 2022-01-29 | Franklin | Virginia | 51067 | 9641 | 140 |
2160900 | 2160900 | 2022-01-28 | Franklin | Virginia | 51067 | 9641 | 140 |
2157644 | 2157644 | 2022-01-27 | Franklin | Virginia | 51067 | 9569 | 140 |
2154391 | 2154391 | 2022-01-26 | Franklin | Virginia | 51067 | 9491 | 139 |
2151138 | 2151138 | 2022-01-25 | Franklin | Virginia | 51067 | 9441 | 139 |
2147886 | 2147886 | 2022-01-24 | Franklin | Virginia | 51067 | 9377 | 137 |
2144633 | 2144633 | 2022-01-23 | Franklin | Virginia | 51067 | 9124 | 134 |
2141378 | 2141378 | 2022-01-22 | Franklin | Virginia | 51067 | 9124 | 134 |
2138122 | 2138122 | 2022-01-21 | Franklin | Virginia | 51067 | 9124 | 134 |
2134868 | 2134868 | 2022-01-20 | Franklin | Virginia | 51067 | 9007 | 134 |
2131616 | 2131616 | 2022-01-19 | Franklin | Virginia | 51067 | 8854 | 134 |
2128362 | 2128362 | 2022-01-18 | Franklin | Virginia | 51067 | 8833 | 134 |
2125109 | 2125109 | 2022-01-17 | Franklin | Virginia | 51067 | 8809 | 134 |
2121857 | 2121857 | 2022-01-16 | Franklin | Virginia | 51067 | 8442 | 134 |
2118605 | 2118605 | 2022-01-15 | Franklin | Virginia | 51067 | 8442 | 134 |
2115353 | 2115353 | 2022-01-14 | Franklin | Virginia | 51067 | 8442 | 134 |
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 |
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);