ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 51085 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177181 | 2177181 | 2022-02-02 | Hanover | Virginia | 51085 | 20109 | 216 |
2173928 | 2173928 | 2022-02-01 | Hanover | Virginia | 51085 | 20051 | 215 |
2170676 | 2170676 | 2022-01-31 | Hanover | Virginia | 51085 | 19983 | 215 |
2167423 | 2167423 | 2022-01-30 | Hanover | Virginia | 51085 | 19710 | 212 |
2164168 | 2164168 | 2022-01-29 | Hanover | Virginia | 51085 | 19710 | 212 |
2160913 | 2160913 | 2022-01-28 | Hanover | Virginia | 51085 | 19710 | 212 |
2157657 | 2157657 | 2022-01-27 | Hanover | Virginia | 51085 | 19557 | 212 |
2154404 | 2154404 | 2022-01-26 | Hanover | Virginia | 51085 | 19367 | 211 |
2151151 | 2151151 | 2022-01-25 | Hanover | Virginia | 51085 | 19181 | 211 |
2147899 | 2147899 | 2022-01-24 | Hanover | Virginia | 51085 | 19020 | 211 |
2144646 | 2144646 | 2022-01-23 | Hanover | Virginia | 51085 | 18533 | 209 |
2141391 | 2141391 | 2022-01-22 | Hanover | Virginia | 51085 | 18533 | 209 |
2138135 | 2138135 | 2022-01-21 | Hanover | Virginia | 51085 | 18533 | 209 |
2134881 | 2134881 | 2022-01-20 | Hanover | Virginia | 51085 | 18377 | 209 |
2131629 | 2131629 | 2022-01-19 | Hanover | Virginia | 51085 | 18213 | 209 |
2128375 | 2128375 | 2022-01-18 | Hanover | Virginia | 51085 | 18042 | 209 |
2125122 | 2125122 | 2022-01-17 | Hanover | Virginia | 51085 | 17926 | 209 |
2121870 | 2121870 | 2022-01-16 | Hanover | Virginia | 51085 | 17397 | 209 |
2118618 | 2118618 | 2022-01-15 | Hanover | Virginia | 51085 | 17397 | 209 |
2115366 | 2115366 | 2022-01-14 | Hanover | Virginia | 51085 | 17397 | 209 |
2112114 | 2112114 | 2022-01-13 | Hanover | Virginia | 51085 | 17186 | 209 |
2108862 | 2108862 | 2022-01-12 | Hanover | Virginia | 51085 | 16981 | 209 |
2105611 | 2105611 | 2022-01-11 | Hanover | Virginia | 51085 | 16774 | 208 |
2102360 | 2102360 | 2022-01-10 | Hanover | Virginia | 51085 | 16558 | 208 |
2099109 | 2099109 | 2022-01-09 | Hanover | Virginia | 51085 | 15821 | 208 |
2095858 | 2095858 | 2022-01-08 | Hanover | Virginia | 51085 | 15821 | 208 |
2092606 | 2092606 | 2022-01-07 | Hanover | Virginia | 51085 | 15821 | 208 |
2089354 | 2089354 | 2022-01-06 | Hanover | Virginia | 51085 | 15578 | 208 |
2086103 | 2086103 | 2022-01-05 | Hanover | Virginia | 51085 | 15378 | 208 |
2082851 | 2082851 | 2022-01-04 | Hanover | Virginia | 51085 | 15253 | 208 |
2079599 | 2079599 | 2022-01-03 | Hanover | Virginia | 51085 | 15026 | 208 |
2076347 | 2076347 | 2022-01-02 | Hanover | Virginia | 51085 | 14552 | 208 |
2073096 | 2073096 | 2022-01-01 | Hanover | Virginia | 51085 | 14552 | 208 |
2069845 | 2069845 | 2021-12-31 | Hanover | Virginia | 51085 | 14552 | 208 |
2066594 | 2066594 | 2021-12-30 | Hanover | Virginia | 51085 | 14332 | 208 |
2063344 | 2063344 | 2021-12-29 | Hanover | Virginia | 51085 | 14179 | 208 |
2060094 | 2060094 | 2021-12-28 | Hanover | Virginia | 51085 | 14037 | 208 |
2056845 | 2056845 | 2021-12-27 | Hanover | Virginia | 51085 | 13894 | 207 |
2053596 | 2053596 | 2021-12-26 | Hanover | Virginia | 51085 | 13661 | 207 |
2050346 | 2050346 | 2021-12-25 | Hanover | Virginia | 51085 | 13661 | 207 |
2047096 | 2047096 | 2021-12-24 | Hanover | Virginia | 51085 | 13661 | 207 |
2043846 | 2043846 | 2021-12-23 | Hanover | Virginia | 51085 | 13546 | 205 |
2040597 | 2040597 | 2021-12-22 | Hanover | Virginia | 51085 | 13463 | 205 |
2037347 | 2037347 | 2021-12-21 | Hanover | Virginia | 51085 | 13401 | 205 |
2034097 | 2034097 | 2021-12-20 | Hanover | Virginia | 51085 | 13323 | 205 |
2030847 | 2030847 | 2021-12-19 | Hanover | Virginia | 51085 | 13206 | 202 |
2027596 | 2027596 | 2021-12-18 | Hanover | Virginia | 51085 | 13206 | 202 |
2024345 | 2024345 | 2021-12-17 | Hanover | Virginia | 51085 | 13206 | 202 |
2021094 | 2021094 | 2021-12-16 | Hanover | Virginia | 51085 | 13166 | 202 |
2017843 | 2017843 | 2021-12-15 | Hanover | Virginia | 51085 | 13111 | 202 |
2014593 | 2014593 | 2021-12-14 | Hanover | Virginia | 51085 | 13060 | 202 |
2011342 | 2011342 | 2021-12-13 | Hanover | Virginia | 51085 | 13009 | 202 |
2008091 | 2008091 | 2021-12-12 | Hanover | Virginia | 51085 | 12893 | 202 |
2004840 | 2004840 | 2021-12-11 | Hanover | Virginia | 51085 | 12893 | 202 |
2001589 | 2001589 | 2021-12-10 | Hanover | Virginia | 51085 | 12893 | 202 |
1998339 | 1998339 | 2021-12-09 | Hanover | Virginia | 51085 | 12832 | 201 |
1995088 | 1995088 | 2021-12-08 | Hanover | Virginia | 51085 | 12772 | 201 |
1991837 | 1991837 | 2021-12-07 | Hanover | Virginia | 51085 | 12728 | 201 |
1988586 | 1988586 | 2021-12-06 | Hanover | Virginia | 51085 | 12685 | 201 |
1985336 | 1985336 | 2021-12-05 | Hanover | Virginia | 51085 | 12598 | 201 |
1982086 | 1982086 | 2021-12-04 | Hanover | Virginia | 51085 | 12598 | 201 |
1978836 | 1978836 | 2021-12-03 | Hanover | Virginia | 51085 | 12598 | 201 |
1975586 | 1975586 | 2021-12-02 | Hanover | Virginia | 51085 | 12557 | 201 |
1972337 | 1972337 | 2021-12-01 | Hanover | Virginia | 51085 | 12522 | 201 |
1969087 | 1969087 | 2021-11-30 | Hanover | Virginia | 51085 | 12493 | 201 |
1965837 | 1965837 | 2021-11-29 | Hanover | Virginia | 51085 | 12427 | 201 |
1962585 | 1962585 | 2021-11-28 | Hanover | Virginia | 51085 | 12399 | 201 |
1959334 | 1959334 | 2021-11-27 | Hanover | Virginia | 51085 | 12399 | 201 |
1956083 | 1956083 | 2021-11-26 | Hanover | Virginia | 51085 | 12399 | 201 |
1952832 | 1952832 | 2021-11-25 | Hanover | Virginia | 51085 | 12382 | 201 |
1949581 | 1949581 | 2021-11-24 | Hanover | Virginia | 51085 | 12362 | 201 |
1946330 | 1946330 | 2021-11-23 | Hanover | Virginia | 51085 | 12347 | 200 |
1943079 | 1943079 | 2021-11-22 | Hanover | Virginia | 51085 | 12313 | 198 |
1939829 | 1939829 | 2021-11-21 | Hanover | Virginia | 51085 | 12263 | 199 |
1936579 | 1936579 | 2021-11-20 | Hanover | Virginia | 51085 | 12263 | 199 |
1933329 | 1933329 | 2021-11-19 | Hanover | Virginia | 51085 | 12263 | 199 |
1930077 | 1930077 | 2021-11-18 | Hanover | Virginia | 51085 | 12227 | 199 |
1926827 | 1926827 | 2021-11-17 | Hanover | Virginia | 51085 | 12196 | 199 |
1923577 | 1923577 | 2021-11-16 | Hanover | Virginia | 51085 | 12159 | 199 |
1920328 | 1920328 | 2021-11-15 | Hanover | Virginia | 51085 | 12136 | 199 |
1917078 | 1917078 | 2021-11-14 | Hanover | Virginia | 51085 | 12068 | 199 |
1913828 | 1913828 | 2021-11-13 | Hanover | Virginia | 51085 | 12068 | 199 |
1910578 | 1910578 | 2021-11-12 | Hanover | Virginia | 51085 | 12068 | 199 |
1907329 | 1907329 | 2021-11-11 | Hanover | Virginia | 51085 | 12041 | 198 |
1904080 | 1904080 | 2021-11-10 | Hanover | Virginia | 51085 | 12029 | 198 |
1900830 | 1900830 | 2021-11-09 | Hanover | Virginia | 51085 | 12013 | 198 |
1897580 | 1897580 | 2021-11-08 | Hanover | Virginia | 51085 | 11990 | 197 |
1894330 | 1894330 | 2021-11-07 | Hanover | Virginia | 51085 | 11926 | 196 |
1891080 | 1891080 | 2021-11-06 | Hanover | Virginia | 51085 | 11926 | 196 |
1887830 | 1887830 | 2021-11-05 | Hanover | Virginia | 51085 | 11926 | 196 |
1884580 | 1884580 | 2021-11-04 | Hanover | Virginia | 51085 | 11902 | 196 |
1881331 | 1881331 | 2021-11-03 | Hanover | Virginia | 51085 | 11879 | 196 |
1878082 | 1878082 | 2021-11-02 | Hanover | Virginia | 51085 | 11858 | 196 |
1874833 | 1874833 | 2021-11-01 | Hanover | Virginia | 51085 | 11836 | 196 |
1871584 | 1871584 | 2021-10-31 | Hanover | Virginia | 51085 | 11783 | 196 |
1868335 | 1868335 | 2021-10-30 | Hanover | Virginia | 51085 | 11783 | 196 |
1865086 | 1865086 | 2021-10-29 | Hanover | Virginia | 51085 | 11783 | 196 |
1861837 | 1861837 | 2021-10-28 | Hanover | Virginia | 51085 | 11762 | 195 |
1858588 | 1858588 | 2021-10-27 | Hanover | Virginia | 51085 | 11737 | 195 |
1855339 | 1855339 | 2021-10-26 | Hanover | Virginia | 51085 | 11721 | 195 |
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);