ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 51093 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177187 | 2177187 | 2022-02-02 | Isle of Wight | Virginia | 51093 | 7004 | 93 |
2173934 | 2173934 | 2022-02-01 | Isle of Wight | Virginia | 51093 | 6966 | 93 |
2170682 | 2170682 | 2022-01-31 | Isle of Wight | Virginia | 51093 | 6924 | 93 |
2167429 | 2167429 | 2022-01-30 | Isle of Wight | Virginia | 51093 | 6857 | 92 |
2164174 | 2164174 | 2022-01-29 | Isle of Wight | Virginia | 51093 | 6857 | 92 |
2160919 | 2160919 | 2022-01-28 | Isle of Wight | Virginia | 51093 | 6857 | 92 |
2157663 | 2157663 | 2022-01-27 | Isle of Wight | Virginia | 51093 | 6808 | 92 |
2154410 | 2154410 | 2022-01-26 | Isle of Wight | Virginia | 51093 | 6757 | 92 |
2151157 | 2151157 | 2022-01-25 | Isle of Wight | Virginia | 51093 | 6690 | 92 |
2147905 | 2147905 | 2022-01-24 | Isle of Wight | Virginia | 51093 | 6664 | 92 |
2144652 | 2144652 | 2022-01-23 | Isle of Wight | Virginia | 51093 | 6561 | 92 |
2141397 | 2141397 | 2022-01-22 | Isle of Wight | Virginia | 51093 | 6561 | 92 |
2138141 | 2138141 | 2022-01-21 | Isle of Wight | Virginia | 51093 | 6561 | 92 |
2134887 | 2134887 | 2022-01-20 | Isle of Wight | Virginia | 51093 | 6477 | 92 |
2131635 | 2131635 | 2022-01-19 | Isle of Wight | Virginia | 51093 | 6386 | 92 |
2128381 | 2128381 | 2022-01-18 | Isle of Wight | Virginia | 51093 | 6312 | 92 |
2125128 | 2125128 | 2022-01-17 | Isle of Wight | Virginia | 51093 | 6257 | 92 |
2121876 | 2121876 | 2022-01-16 | Isle of Wight | Virginia | 51093 | 6010 | 92 |
2118624 | 2118624 | 2022-01-15 | Isle of Wight | Virginia | 51093 | 6010 | 92 |
2115372 | 2115372 | 2022-01-14 | Isle of Wight | Virginia | 51093 | 6010 | 92 |
2112120 | 2112120 | 2022-01-13 | Isle of Wight | Virginia | 51093 | 5946 | 92 |
2108868 | 2108868 | 2022-01-12 | Isle of Wight | Virginia | 51093 | 5879 | 93 |
2105617 | 2105617 | 2022-01-11 | Isle of Wight | Virginia | 51093 | 5786 | 93 |
2102366 | 2102366 | 2022-01-10 | Isle of Wight | Virginia | 51093 | 5725 | 93 |
2099115 | 2099115 | 2022-01-09 | Isle of Wight | Virginia | 51093 | 5504 | 93 |
2095864 | 2095864 | 2022-01-08 | Isle of Wight | Virginia | 51093 | 5504 | 93 |
2092612 | 2092612 | 2022-01-07 | Isle of Wight | Virginia | 51093 | 5504 | 93 |
2089360 | 2089360 | 2022-01-06 | Isle of Wight | Virginia | 51093 | 5437 | 93 |
2086109 | 2086109 | 2022-01-05 | Isle of Wight | Virginia | 51093 | 5361 | 93 |
2082857 | 2082857 | 2022-01-04 | Isle of Wight | Virginia | 51093 | 5309 | 93 |
2079605 | 2079605 | 2022-01-03 | Isle of Wight | Virginia | 51093 | 5239 | 93 |
2076353 | 2076353 | 2022-01-02 | Isle of Wight | Virginia | 51093 | 5097 | 93 |
2073102 | 2073102 | 2022-01-01 | Isle of Wight | Virginia | 51093 | 5097 | 93 |
2069851 | 2069851 | 2021-12-31 | Isle of Wight | Virginia | 51093 | 5097 | 93 |
2066600 | 2066600 | 2021-12-30 | Isle of Wight | Virginia | 51093 | 5031 | 93 |
2063350 | 2063350 | 2021-12-29 | Isle of Wight | Virginia | 51093 | 4973 | 93 |
2060100 | 2060100 | 2021-12-28 | Isle of Wight | Virginia | 51093 | 4931 | 93 |
2056851 | 2056851 | 2021-12-27 | Isle of Wight | Virginia | 51093 | 4912 | 93 |
2053602 | 2053602 | 2021-12-26 | Isle of Wight | Virginia | 51093 | 4869 | 93 |
2050352 | 2050352 | 2021-12-25 | Isle of Wight | Virginia | 51093 | 4869 | 93 |
2047102 | 2047102 | 2021-12-24 | Isle of Wight | Virginia | 51093 | 4869 | 93 |
2043852 | 2043852 | 2021-12-23 | Isle of Wight | Virginia | 51093 | 4850 | 93 |
2040603 | 2040603 | 2021-12-22 | Isle of Wight | Virginia | 51093 | 4836 | 93 |
2037353 | 2037353 | 2021-12-21 | Isle of Wight | Virginia | 51093 | 4825 | 93 |
2034103 | 2034103 | 2021-12-20 | Isle of Wight | Virginia | 51093 | 4803 | 93 |
2030853 | 2030853 | 2021-12-19 | Isle of Wight | Virginia | 51093 | 4764 | 93 |
2027602 | 2027602 | 2021-12-18 | Isle of Wight | Virginia | 51093 | 4764 | 93 |
2024351 | 2024351 | 2021-12-17 | Isle of Wight | Virginia | 51093 | 4764 | 93 |
2021100 | 2021100 | 2021-12-16 | Isle of Wight | Virginia | 51093 | 4748 | 93 |
2017849 | 2017849 | 2021-12-15 | Isle of Wight | Virginia | 51093 | 4740 | 93 |
2014599 | 2014599 | 2021-12-14 | Isle of Wight | Virginia | 51093 | 4726 | 93 |
2011348 | 2011348 | 2021-12-13 | Isle of Wight | Virginia | 51093 | 4722 | 93 |
2008097 | 2008097 | 2021-12-12 | Isle of Wight | Virginia | 51093 | 4708 | 92 |
2004846 | 2004846 | 2021-12-11 | Isle of Wight | Virginia | 51093 | 4708 | 92 |
2001595 | 2001595 | 2021-12-10 | Isle of Wight | Virginia | 51093 | 4708 | 92 |
1998345 | 1998345 | 2021-12-09 | Isle of Wight | Virginia | 51093 | 4700 | 92 |
1995094 | 1995094 | 2021-12-08 | Isle of Wight | Virginia | 51093 | 4686 | 92 |
1991843 | 1991843 | 2021-12-07 | Isle of Wight | Virginia | 51093 | 4676 | 92 |
1988592 | 1988592 | 2021-12-06 | Isle of Wight | Virginia | 51093 | 4663 | 92 |
1985342 | 1985342 | 2021-12-05 | Isle of Wight | Virginia | 51093 | 4646 | 92 |
1982092 | 1982092 | 2021-12-04 | Isle of Wight | Virginia | 51093 | 4646 | 92 |
1978842 | 1978842 | 2021-12-03 | Isle of Wight | Virginia | 51093 | 4646 | 92 |
1975592 | 1975592 | 2021-12-02 | Isle of Wight | Virginia | 51093 | 4635 | 92 |
1972343 | 1972343 | 2021-12-01 | Isle of Wight | Virginia | 51093 | 4630 | 92 |
1969093 | 1969093 | 2021-11-30 | Isle of Wight | Virginia | 51093 | 4624 | 92 |
1965843 | 1965843 | 2021-11-29 | Isle of Wight | Virginia | 51093 | 4613 | 92 |
1962591 | 1962591 | 2021-11-28 | Isle of Wight | Virginia | 51093 | 4606 | 91 |
1959340 | 1959340 | 2021-11-27 | Isle of Wight | Virginia | 51093 | 4606 | 91 |
1956089 | 1956089 | 2021-11-26 | Isle of Wight | Virginia | 51093 | 4606 | 91 |
1952838 | 1952838 | 2021-11-25 | Isle of Wight | Virginia | 51093 | 4602 | 91 |
1949587 | 1949587 | 2021-11-24 | Isle of Wight | Virginia | 51093 | 4598 | 91 |
1946336 | 1946336 | 2021-11-23 | Isle of Wight | Virginia | 51093 | 4592 | 91 |
1943085 | 1943085 | 2021-11-22 | Isle of Wight | Virginia | 51093 | 4586 | 91 |
1939835 | 1939835 | 2021-11-21 | Isle of Wight | Virginia | 51093 | 4581 | 91 |
1936585 | 1936585 | 2021-11-20 | Isle of Wight | Virginia | 51093 | 4581 | 91 |
1933335 | 1933335 | 2021-11-19 | Isle of Wight | Virginia | 51093 | 4581 | 91 |
1930083 | 1930083 | 2021-11-18 | Isle of Wight | Virginia | 51093 | 4576 | 91 |
1926833 | 1926833 | 2021-11-17 | Isle of Wight | Virginia | 51093 | 4565 | 91 |
1923583 | 1923583 | 2021-11-16 | Isle of Wight | Virginia | 51093 | 4564 | 91 |
1920334 | 1920334 | 2021-11-15 | Isle of Wight | Virginia | 51093 | 4554 | 90 |
1917084 | 1917084 | 2021-11-14 | Isle of Wight | Virginia | 51093 | 4542 | 90 |
1913834 | 1913834 | 2021-11-13 | Isle of Wight | Virginia | 51093 | 4542 | 90 |
1910584 | 1910584 | 2021-11-12 | Isle of Wight | Virginia | 51093 | 4542 | 90 |
1907335 | 1907335 | 2021-11-11 | Isle of Wight | Virginia | 51093 | 4535 | 89 |
1904086 | 1904086 | 2021-11-10 | Isle of Wight | Virginia | 51093 | 4530 | 89 |
1900836 | 1900836 | 2021-11-09 | Isle of Wight | Virginia | 51093 | 4521 | 89 |
1897586 | 1897586 | 2021-11-08 | Isle of Wight | Virginia | 51093 | 4516 | 89 |
1894336 | 1894336 | 2021-11-07 | Isle of Wight | Virginia | 51093 | 4508 | 89 |
1891086 | 1891086 | 2021-11-06 | Isle of Wight | Virginia | 51093 | 4508 | 89 |
1887836 | 1887836 | 2021-11-05 | Isle of Wight | Virginia | 51093 | 4508 | 89 |
1884586 | 1884586 | 2021-11-04 | Isle of Wight | Virginia | 51093 | 4495 | 89 |
1881337 | 1881337 | 2021-11-03 | Isle of Wight | Virginia | 51093 | 4487 | 89 |
1878088 | 1878088 | 2021-11-02 | Isle of Wight | Virginia | 51093 | 4476 | 89 |
1874839 | 1874839 | 2021-11-01 | Isle of Wight | Virginia | 51093 | 4467 | 89 |
1871590 | 1871590 | 2021-10-31 | Isle of Wight | Virginia | 51093 | 4447 | 88 |
1868341 | 1868341 | 2021-10-30 | Isle of Wight | Virginia | 51093 | 4447 | 88 |
1865092 | 1865092 | 2021-10-29 | Isle of Wight | Virginia | 51093 | 4447 | 88 |
1861843 | 1861843 | 2021-10-28 | Isle of Wight | Virginia | 51093 | 4441 | 87 |
1858594 | 1858594 | 2021-10-27 | Isle of Wight | Virginia | 51093 | 4434 | 86 |
1855345 | 1855345 | 2021-10-26 | Isle of Wight | Virginia | 51093 | 4428 | 86 |
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);