ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Washington" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177250 | 2177250 | 2022-02-02 | Washington | Virginia | 51191 | 12259 | 191 |
2173997 | 2173997 | 2022-02-01 | Washington | Virginia | 51191 | 12167 | 191 |
2170745 | 2170745 | 2022-01-31 | Washington | Virginia | 51191 | 12086 | 191 |
2167492 | 2167492 | 2022-01-30 | Washington | Virginia | 51191 | 11797 | 191 |
2164237 | 2164237 | 2022-01-29 | Washington | Virginia | 51191 | 11797 | 191 |
2160982 | 2160982 | 2022-01-28 | Washington | Virginia | 51191 | 11797 | 191 |
2157726 | 2157726 | 2022-01-27 | Washington | Virginia | 51191 | 11710 | 191 |
2154473 | 2154473 | 2022-01-26 | Washington | Virginia | 51191 | 11596 | 191 |
2151220 | 2151220 | 2022-01-25 | Washington | Virginia | 51191 | 11466 | 190 |
2147968 | 2147968 | 2022-01-24 | Washington | Virginia | 51191 | 11321 | 190 |
2144716 | 2144716 | 2022-01-23 | Washington | Virginia | 51191 | 11010 | 190 |
2141461 | 2141461 | 2022-01-22 | Washington | Virginia | 51191 | 11010 | 190 |
2138205 | 2138205 | 2022-01-21 | Washington | Virginia | 51191 | 11010 | 190 |
2134950 | 2134950 | 2022-01-20 | Washington | Virginia | 51191 | 10844 | 190 |
2131698 | 2131698 | 2022-01-19 | Washington | Virginia | 51191 | 10665 | 186 |
2128444 | 2128444 | 2022-01-18 | Washington | Virginia | 51191 | 10558 | 186 |
2125191 | 2125191 | 2022-01-17 | Washington | Virginia | 51191 | 10479 | 186 |
2121939 | 2121939 | 2022-01-16 | Washington | Virginia | 51191 | 10131 | 186 |
2118687 | 2118687 | 2022-01-15 | Washington | Virginia | 51191 | 10131 | 186 |
2115435 | 2115435 | 2022-01-14 | Washington | Virginia | 51191 | 10131 | 186 |
2112183 | 2112183 | 2022-01-13 | Washington | Virginia | 51191 | 10049 | 186 |
2108931 | 2108931 | 2022-01-12 | Washington | Virginia | 51191 | 9922 | 185 |
2105680 | 2105680 | 2022-01-11 | Washington | Virginia | 51191 | 9842 | 184 |
2102429 | 2102429 | 2022-01-10 | Washington | Virginia | 51191 | 9740 | 184 |
2099178 | 2099178 | 2022-01-09 | Washington | Virginia | 51191 | 9520 | 182 |
2095927 | 2095927 | 2022-01-08 | Washington | Virginia | 51191 | 9520 | 182 |
2092675 | 2092675 | 2022-01-07 | Washington | Virginia | 51191 | 9520 | 182 |
2089423 | 2089423 | 2022-01-06 | Washington | Virginia | 51191 | 9432 | 182 |
2086172 | 2086172 | 2022-01-05 | Washington | Virginia | 51191 | 9343 | 179 |
2082920 | 2082920 | 2022-01-04 | Washington | Virginia | 51191 | 9301 | 179 |
2079668 | 2079668 | 2022-01-03 | Washington | Virginia | 51191 | 9239 | 178 |
2076416 | 2076416 | 2022-01-02 | Washington | Virginia | 51191 | 9130 | 178 |
2073165 | 2073165 | 2022-01-01 | Washington | Virginia | 51191 | 9130 | 178 |
2069914 | 2069914 | 2021-12-31 | Washington | Virginia | 51191 | 9130 | 178 |
2066663 | 2066663 | 2021-12-30 | Washington | Virginia | 51191 | 9080 | 177 |
2063413 | 2063413 | 2021-12-29 | Washington | Virginia | 51191 | 9059 | 177 |
2060163 | 2060163 | 2021-12-28 | Washington | Virginia | 51191 | 9023 | 176 |
2056914 | 2056914 | 2021-12-27 | Washington | Virginia | 51191 | 8993 | 168 |
2053665 | 2053665 | 2021-12-26 | Washington | Virginia | 51191 | 8943 | 168 |
2050415 | 2050415 | 2021-12-25 | Washington | Virginia | 51191 | 8943 | 168 |
2047165 | 2047165 | 2021-12-24 | Washington | Virginia | 51191 | 8943 | 168 |
2043915 | 2043915 | 2021-12-23 | Washington | Virginia | 51191 | 8921 | 168 |
2040666 | 2040666 | 2021-12-22 | Washington | Virginia | 51191 | 8884 | 168 |
2037416 | 2037416 | 2021-12-21 | Washington | Virginia | 51191 | 8856 | 168 |
2034166 | 2034166 | 2021-12-20 | Washington | Virginia | 51191 | 8835 | 168 |
2030916 | 2030916 | 2021-12-19 | Washington | Virginia | 51191 | 8753 | 168 |
2027665 | 2027665 | 2021-12-18 | Washington | Virginia | 51191 | 8753 | 168 |
2024414 | 2024414 | 2021-12-17 | Washington | Virginia | 51191 | 8753 | 168 |
2021163 | 2021163 | 2021-12-16 | Washington | Virginia | 51191 | 8708 | 168 |
2017912 | 2017912 | 2021-12-15 | Washington | Virginia | 51191 | 8666 | 167 |
2014662 | 2014662 | 2021-12-14 | Washington | Virginia | 51191 | 8645 | 167 |
2011411 | 2011411 | 2021-12-13 | Washington | Virginia | 51191 | 8604 | 164 |
2008160 | 2008160 | 2021-12-12 | Washington | Virginia | 51191 | 8546 | 161 |
2004909 | 2004909 | 2021-12-11 | Washington | Virginia | 51191 | 8546 | 161 |
2001658 | 2001658 | 2021-12-10 | Washington | Virginia | 51191 | 8546 | 161 |
1998408 | 1998408 | 2021-12-09 | Washington | Virginia | 51191 | 8497 | 161 |
1995157 | 1995157 | 2021-12-08 | Washington | Virginia | 51191 | 8457 | 160 |
1991906 | 1991906 | 2021-12-07 | Washington | Virginia | 51191 | 8408 | 160 |
1988655 | 1988655 | 2021-12-06 | Washington | Virginia | 51191 | 8366 | 160 |
1985405 | 1985405 | 2021-12-05 | Washington | Virginia | 51191 | 8267 | 160 |
1982155 | 1982155 | 2021-12-04 | Washington | Virginia | 51191 | 8267 | 160 |
1978905 | 1978905 | 2021-12-03 | Washington | Virginia | 51191 | 8267 | 160 |
1975655 | 1975655 | 2021-12-02 | Washington | Virginia | 51191 | 8217 | 160 |
1972406 | 1972406 | 2021-12-01 | Washington | Virginia | 51191 | 8165 | 159 |
1969156 | 1969156 | 2021-11-30 | Washington | Virginia | 51191 | 8110 | 159 |
1965906 | 1965906 | 2021-11-29 | Washington | Virginia | 51191 | 8074 | 158 |
1962654 | 1962654 | 2021-11-28 | Washington | Virginia | 51191 | 8028 | 156 |
1959403 | 1959403 | 2021-11-27 | Washington | Virginia | 51191 | 8028 | 156 |
1956152 | 1956152 | 2021-11-26 | Washington | Virginia | 51191 | 8028 | 156 |
1952901 | 1952901 | 2021-11-25 | Washington | Virginia | 51191 | 8023 | 156 |
1949650 | 1949650 | 2021-11-24 | Washington | Virginia | 51191 | 8000 | 156 |
1946399 | 1946399 | 2021-11-23 | Washington | Virginia | 51191 | 7969 | 156 |
1943148 | 1943148 | 2021-11-22 | Washington | Virginia | 51191 | 7940 | 156 |
1939898 | 1939898 | 2021-11-21 | Washington | Virginia | 51191 | 7908 | 156 |
1936648 | 1936648 | 2021-11-20 | Washington | Virginia | 51191 | 7908 | 156 |
1933398 | 1933398 | 2021-11-19 | Washington | Virginia | 51191 | 7908 | 156 |
1930146 | 1930146 | 2021-11-18 | Washington | Virginia | 51191 | 7879 | 156 |
1926896 | 1926896 | 2021-11-17 | Washington | Virginia | 51191 | 7861 | 155 |
1923646 | 1923646 | 2021-11-16 | Washington | Virginia | 51191 | 7842 | 155 |
1920397 | 1920397 | 2021-11-15 | Washington | Virginia | 51191 | 7828 | 155 |
1917147 | 1917147 | 2021-11-14 | Washington | Virginia | 51191 | 7791 | 153 |
1913897 | 1913897 | 2021-11-13 | Washington | Virginia | 51191 | 7791 | 153 |
1910647 | 1910647 | 2021-11-12 | Washington | Virginia | 51191 | 7791 | 153 |
1907398 | 1907398 | 2021-11-11 | Washington | Virginia | 51191 | 7779 | 152 |
1904149 | 1904149 | 2021-11-10 | Washington | Virginia | 51191 | 7769 | 148 |
1900899 | 1900899 | 2021-11-09 | Washington | Virginia | 51191 | 7755 | 148 |
1897649 | 1897649 | 2021-11-08 | Washington | Virginia | 51191 | 7742 | 148 |
1894399 | 1894399 | 2021-11-07 | Washington | Virginia | 51191 | 7708 | 148 |
1891149 | 1891149 | 2021-11-06 | Washington | Virginia | 51191 | 7708 | 148 |
1887899 | 1887899 | 2021-11-05 | Washington | Virginia | 51191 | 7708 | 148 |
1884649 | 1884649 | 2021-11-04 | Washington | Virginia | 51191 | 7689 | 148 |
1881400 | 1881400 | 2021-11-03 | Washington | Virginia | 51191 | 7661 | 148 |
1878151 | 1878151 | 2021-11-02 | Washington | Virginia | 51191 | 7640 | 148 |
1874902 | 1874902 | 2021-11-01 | Washington | Virginia | 51191 | 7617 | 148 |
1871653 | 1871653 | 2021-10-31 | Washington | Virginia | 51191 | 7589 | 146 |
1868404 | 1868404 | 2021-10-30 | Washington | Virginia | 51191 | 7589 | 146 |
1865155 | 1865155 | 2021-10-29 | Washington | Virginia | 51191 | 7589 | 146 |
1861906 | 1861906 | 2021-10-28 | Washington | Virginia | 51191 | 7572 | 146 |
1858657 | 1858657 | 2021-10-27 | Washington | Virginia | 51191 | 7556 | 146 |
1855408 | 1855408 | 2021-10-26 | Washington | Virginia | 51191 | 7531 | 146 |
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);