ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Isle of Wight" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1852096 | 1852096 | 2021-10-25 | Isle of Wight | Virginia | 51093 | 4423 | 85 |
1848846 | 1848846 | 2021-10-24 | Isle of Wight | Virginia | 51093 | 4408 | 85 |
1845596 | 1845596 | 2021-10-23 | Isle of Wight | Virginia | 51093 | 4408 | 85 |
1842346 | 1842346 | 2021-10-22 | Isle of Wight | Virginia | 51093 | 4408 | 85 |
1839097 | 1839097 | 2021-10-21 | Isle of Wight | Virginia | 51093 | 4401 | 85 |
1835848 | 1835848 | 2021-10-20 | Isle of Wight | Virginia | 51093 | 4395 | 85 |
1832599 | 1832599 | 2021-10-19 | Isle of Wight | Virginia | 51093 | 4389 | 85 |
1829350 | 1829350 | 2021-10-18 | Isle of Wight | Virginia | 51093 | 4376 | 84 |
1826101 | 1826101 | 2021-10-17 | Isle of Wight | Virginia | 51093 | 4350 | 83 |
1822852 | 1822852 | 2021-10-16 | Isle of Wight | Virginia | 51093 | 4350 | 83 |
1819603 | 1819603 | 2021-10-15 | Isle of Wight | Virginia | 51093 | 4350 | 83 |
1816354 | 1816354 | 2021-10-14 | Isle of Wight | Virginia | 51093 | 4339 | 83 |
1813106 | 1813106 | 2021-10-13 | Isle of Wight | Virginia | 51093 | 4324 | 83 |
1809857 | 1809857 | 2021-10-12 | Isle of Wight | Virginia | 51093 | 4311 | 83 |
1806607 | 1806607 | 2021-10-11 | Isle of Wight | Virginia | 51093 | 4263 | 82 |
1803357 | 1803357 | 2021-10-10 | Isle of Wight | Virginia | 51093 | 4263 | 82 |
1800108 | 1800108 | 2021-10-09 | Isle of Wight | Virginia | 51093 | 4263 | 82 |
1796859 | 1796859 | 2021-10-08 | Isle of Wight | Virginia | 51093 | 4263 | 82 |
1793610 | 1793610 | 2021-10-07 | Isle of Wight | Virginia | 51093 | 4243 | 82 |
1790361 | 1790361 | 2021-10-06 | Isle of Wight | Virginia | 51093 | 4235 | 82 |
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);