ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Warren" and fips = 51187 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177249 | 2177249 | 2022-02-02 | Warren | Virginia | 51187 | 8082 | 122 |
2173996 | 2173996 | 2022-02-01 | Warren | Virginia | 51187 | 8053 | 122 |
2170744 | 2170744 | 2022-01-31 | Warren | Virginia | 51187 | 8024 | 121 |
2167491 | 2167491 | 2022-01-30 | Warren | Virginia | 51187 | 7942 | 118 |
2164236 | 2164236 | 2022-01-29 | Warren | Virginia | 51187 | 7942 | 118 |
2160981 | 2160981 | 2022-01-28 | Warren | Virginia | 51187 | 7942 | 118 |
2157725 | 2157725 | 2022-01-27 | Warren | Virginia | 51187 | 7918 | 116 |
2154472 | 2154472 | 2022-01-26 | Warren | Virginia | 51187 | 7885 | 116 |
2151219 | 2151219 | 2022-01-25 | Warren | Virginia | 51187 | 7831 | 115 |
2147967 | 2147967 | 2022-01-24 | Warren | Virginia | 51187 | 7809 | 115 |
2144715 | 2144715 | 2022-01-23 | Warren | Virginia | 51187 | 7699 | 111 |
2141460 | 2141460 | 2022-01-22 | Warren | Virginia | 51187 | 7699 | 111 |
2138204 | 2138204 | 2022-01-21 | Warren | Virginia | 51187 | 7699 | 111 |
2134949 | 2134949 | 2022-01-20 | Warren | Virginia | 51187 | 7644 | 111 |
2131697 | 2131697 | 2022-01-19 | Warren | Virginia | 51187 | 7615 | 111 |
2128443 | 2128443 | 2022-01-18 | Warren | Virginia | 51187 | 7582 | 111 |
2125190 | 2125190 | 2022-01-17 | Warren | Virginia | 51187 | 7560 | 110 |
2121938 | 2121938 | 2022-01-16 | Warren | Virginia | 51187 | 7407 | 110 |
2118686 | 2118686 | 2022-01-15 | Warren | Virginia | 51187 | 7407 | 110 |
2115434 | 2115434 | 2022-01-14 | Warren | Virginia | 51187 | 7407 | 110 |
2112182 | 2112182 | 2022-01-13 | Warren | Virginia | 51187 | 7333 | 110 |
2108930 | 2108930 | 2022-01-12 | Warren | Virginia | 51187 | 7255 | 110 |
2105679 | 2105679 | 2022-01-11 | Warren | Virginia | 51187 | 7158 | 108 |
2102428 | 2102428 | 2022-01-10 | Warren | Virginia | 51187 | 7096 | 108 |
2099177 | 2099177 | 2022-01-09 | Warren | Virginia | 51187 | 6813 | 108 |
2095926 | 2095926 | 2022-01-08 | Warren | Virginia | 51187 | 6813 | 108 |
2092674 | 2092674 | 2022-01-07 | Warren | Virginia | 51187 | 6813 | 108 |
2089422 | 2089422 | 2022-01-06 | Warren | Virginia | 51187 | 6725 | 108 |
2086171 | 2086171 | 2022-01-05 | Warren | Virginia | 51187 | 6645 | 108 |
2082919 | 2082919 | 2022-01-04 | Warren | Virginia | 51187 | 6608 | 108 |
2079667 | 2079667 | 2022-01-03 | Warren | Virginia | 51187 | 6550 | 108 |
2076415 | 2076415 | 2022-01-02 | Warren | Virginia | 51187 | 6334 | 107 |
2073164 | 2073164 | 2022-01-01 | Warren | Virginia | 51187 | 6334 | 107 |
2069913 | 2069913 | 2021-12-31 | Warren | Virginia | 51187 | 6334 | 107 |
2066662 | 2066662 | 2021-12-30 | Warren | Virginia | 51187 | 6257 | 107 |
2063412 | 2063412 | 2021-12-29 | Warren | Virginia | 51187 | 6209 | 107 |
2060162 | 2060162 | 2021-12-28 | Warren | Virginia | 51187 | 6137 | 107 |
2056913 | 2056913 | 2021-12-27 | Warren | Virginia | 51187 | 6120 | 107 |
2053664 | 2053664 | 2021-12-26 | Warren | Virginia | 51187 | 6052 | 107 |
2050414 | 2050414 | 2021-12-25 | Warren | Virginia | 51187 | 6052 | 107 |
2047164 | 2047164 | 2021-12-24 | Warren | Virginia | 51187 | 6052 | 107 |
2043914 | 2043914 | 2021-12-23 | Warren | Virginia | 51187 | 6014 | 107 |
2040665 | 2040665 | 2021-12-22 | Warren | Virginia | 51187 | 5972 | 107 |
2037415 | 2037415 | 2021-12-21 | Warren | Virginia | 51187 | 5934 | 105 |
2034165 | 2034165 | 2021-12-20 | Warren | Virginia | 51187 | 5914 | 102 |
2030915 | 2030915 | 2021-12-19 | Warren | Virginia | 51187 | 5836 | 102 |
2027664 | 2027664 | 2021-12-18 | Warren | Virginia | 51187 | 5836 | 102 |
2024413 | 2024413 | 2021-12-17 | Warren | Virginia | 51187 | 5836 | 102 |
2021162 | 2021162 | 2021-12-16 | Warren | Virginia | 51187 | 5802 | 101 |
2017911 | 2017911 | 2021-12-15 | Warren | Virginia | 51187 | 5772 | 101 |
2014661 | 2014661 | 2021-12-14 | Warren | Virginia | 51187 | 5725 | 101 |
2011410 | 2011410 | 2021-12-13 | Warren | Virginia | 51187 | 5708 | 100 |
2008159 | 2008159 | 2021-12-12 | Warren | Virginia | 51187 | 5661 | 98 |
2004908 | 2004908 | 2021-12-11 | Warren | Virginia | 51187 | 5661 | 98 |
2001657 | 2001657 | 2021-12-10 | Warren | Virginia | 51187 | 5661 | 98 |
1998407 | 1998407 | 2021-12-09 | Warren | Virginia | 51187 | 5631 | 96 |
1995156 | 1995156 | 2021-12-08 | Warren | Virginia | 51187 | 5599 | 95 |
1991905 | 1991905 | 2021-12-07 | Warren | Virginia | 51187 | 5567 | 95 |
1988654 | 1988654 | 2021-12-06 | Warren | Virginia | 51187 | 5551 | 95 |
1985404 | 1985404 | 2021-12-05 | Warren | Virginia | 51187 | 5502 | 95 |
1982154 | 1982154 | 2021-12-04 | Warren | Virginia | 51187 | 5502 | 95 |
1978904 | 1978904 | 2021-12-03 | Warren | Virginia | 51187 | 5502 | 95 |
1975654 | 1975654 | 2021-12-02 | Warren | Virginia | 51187 | 5471 | 95 |
1972405 | 1972405 | 2021-12-01 | Warren | Virginia | 51187 | 5446 | 95 |
1969155 | 1969155 | 2021-11-30 | Warren | Virginia | 51187 | 5411 | 94 |
1965905 | 1965905 | 2021-11-29 | Warren | Virginia | 51187 | 5395 | 94 |
1962653 | 1962653 | 2021-11-28 | Warren | Virginia | 51187 | 5360 | 94 |
1959402 | 1959402 | 2021-11-27 | Warren | Virginia | 51187 | 5360 | 94 |
1956151 | 1956151 | 2021-11-26 | Warren | Virginia | 51187 | 5360 | 94 |
1952900 | 1952900 | 2021-11-25 | Warren | Virginia | 51187 | 5351 | 94 |
1949649 | 1949649 | 2021-11-24 | Warren | Virginia | 51187 | 5324 | 94 |
1946398 | 1946398 | 2021-11-23 | Warren | Virginia | 51187 | 5303 | 94 |
1943147 | 1943147 | 2021-11-22 | Warren | Virginia | 51187 | 5289 | 94 |
1939897 | 1939897 | 2021-11-21 | Warren | Virginia | 51187 | 5243 | 94 |
1936647 | 1936647 | 2021-11-20 | Warren | Virginia | 51187 | 5243 | 94 |
1933397 | 1933397 | 2021-11-19 | Warren | Virginia | 51187 | 5243 | 94 |
1930145 | 1930145 | 2021-11-18 | Warren | Virginia | 51187 | 5229 | 94 |
1926895 | 1926895 | 2021-11-17 | Warren | Virginia | 51187 | 5205 | 94 |
1923645 | 1923645 | 2021-11-16 | Warren | Virginia | 51187 | 5178 | 93 |
1920396 | 1920396 | 2021-11-15 | Warren | Virginia | 51187 | 5166 | 93 |
1917146 | 1917146 | 2021-11-14 | Warren | Virginia | 51187 | 5151 | 92 |
1913896 | 1913896 | 2021-11-13 | Warren | Virginia | 51187 | 5151 | 92 |
1910646 | 1910646 | 2021-11-12 | Warren | Virginia | 51187 | 5151 | 92 |
1907397 | 1907397 | 2021-11-11 | Warren | Virginia | 51187 | 5131 | 91 |
1904148 | 1904148 | 2021-11-10 | Warren | Virginia | 51187 | 5123 | 91 |
1900898 | 1900898 | 2021-11-09 | Warren | Virginia | 51187 | 5107 | 91 |
1897648 | 1897648 | 2021-11-08 | Warren | Virginia | 51187 | 5096 | 91 |
1894398 | 1894398 | 2021-11-07 | Warren | Virginia | 51187 | 5064 | 87 |
1891148 | 1891148 | 2021-11-06 | Warren | Virginia | 51187 | 5064 | 87 |
1887898 | 1887898 | 2021-11-05 | Warren | Virginia | 51187 | 5064 | 87 |
1884648 | 1884648 | 2021-11-04 | Warren | Virginia | 51187 | 5049 | 87 |
1881399 | 1881399 | 2021-11-03 | Warren | Virginia | 51187 | 5041 | 86 |
1878150 | 1878150 | 2021-11-02 | Warren | Virginia | 51187 | 5027 | 85 |
1874901 | 1874901 | 2021-11-01 | Warren | Virginia | 51187 | 5011 | 84 |
1871652 | 1871652 | 2021-10-31 | Warren | Virginia | 51187 | 4996 | 84 |
1868403 | 1868403 | 2021-10-30 | Warren | Virginia | 51187 | 4996 | 84 |
1865154 | 1865154 | 2021-10-29 | Warren | Virginia | 51187 | 4996 | 84 |
1861905 | 1861905 | 2021-10-28 | Warren | Virginia | 51187 | 4972 | 84 |
1858656 | 1858656 | 2021-10-27 | Warren | Virginia | 51187 | 4948 | 83 |
1855407 | 1855407 | 2021-10-26 | Warren | Virginia | 51187 | 4932 | 83 |
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);