ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 54081 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177337 | 2177337 | 2022-02-02 | Raleigh | West Virginia | 54081 | 20260 | 270 |
2174084 | 2174084 | 2022-02-01 | Raleigh | West Virginia | 54081 | 20090 | 269 |
2170832 | 2170832 | 2022-01-31 | Raleigh | West Virginia | 54081 | 19947 | 268 |
2167579 | 2167579 | 2022-01-30 | Raleigh | West Virginia | 54081 | 19835 | 267 |
2164324 | 2164324 | 2022-01-29 | Raleigh | West Virginia | 54081 | 19721 | 267 |
2161069 | 2161069 | 2022-01-28 | Raleigh | West Virginia | 54081 | 19537 | 267 |
2157813 | 2157813 | 2022-01-27 | Raleigh | West Virginia | 54081 | 19274 | 261 |
2154560 | 2154560 | 2022-01-26 | Raleigh | West Virginia | 54081 | 19015 | 259 |
2151307 | 2151307 | 2022-01-25 | Raleigh | West Virginia | 54081 | 18814 | 259 |
2148055 | 2148055 | 2022-01-24 | Raleigh | West Virginia | 54081 | 18641 | 259 |
2144803 | 2144803 | 2022-01-23 | Raleigh | West Virginia | 54081 | 18478 | 254 |
2141548 | 2141548 | 2022-01-22 | Raleigh | West Virginia | 54081 | 18210 | 254 |
2138292 | 2138292 | 2022-01-21 | Raleigh | West Virginia | 54081 | 17879 | 254 |
2135037 | 2135037 | 2022-01-20 | Raleigh | West Virginia | 54081 | 17596 | 252 |
2131785 | 2131785 | 2022-01-19 | Raleigh | West Virginia | 54081 | 17294 | 249 |
2128531 | 2128531 | 2022-01-18 | Raleigh | West Virginia | 54081 | 17058 | 247 |
2125278 | 2125278 | 2022-01-17 | Raleigh | West Virginia | 54081 | 16950 | 246 |
2122026 | 2122026 | 2022-01-16 | Raleigh | West Virginia | 54081 | 16709 | 243 |
2118774 | 2118774 | 2022-01-15 | Raleigh | West Virginia | 54081 | 16518 | 243 |
2115522 | 2115522 | 2022-01-14 | Raleigh | West Virginia | 54081 | 16241 | 243 |
2112270 | 2112270 | 2022-01-13 | Raleigh | West Virginia | 54081 | 15966 | 242 |
2109018 | 2109018 | 2022-01-12 | Raleigh | West Virginia | 54081 | 15585 | 240 |
2105767 | 2105767 | 2022-01-11 | Raleigh | West Virginia | 54081 | 15127 | 233 |
2102516 | 2102516 | 2022-01-10 | Raleigh | West Virginia | 54081 | 15042 | 233 |
2099265 | 2099265 | 2022-01-09 | Raleigh | West Virginia | 54081 | 14948 | 233 |
2096014 | 2096014 | 2022-01-08 | Raleigh | West Virginia | 54081 | 14855 | 233 |
2092762 | 2092762 | 2022-01-07 | Raleigh | West Virginia | 54081 | 14687 | 233 |
2089510 | 2089510 | 2022-01-06 | Raleigh | West Virginia | 54081 | 14558 | 231 |
2086259 | 2086259 | 2022-01-05 | Raleigh | West Virginia | 54081 | 14373 | 227 |
2083007 | 2083007 | 2022-01-04 | Raleigh | West Virginia | 54081 | 14272 | 227 |
2079755 | 2079755 | 2022-01-03 | Raleigh | West Virginia | 54081 | 14203 | 227 |
2076503 | 2076503 | 2022-01-02 | Raleigh | West Virginia | 54081 | 13924 | 225 |
2073252 | 2073252 | 2022-01-01 | Raleigh | West Virginia | 54081 | 13924 | 225 |
2070001 | 2070001 | 2021-12-31 | Raleigh | West Virginia | 54081 | 13924 | 225 |
2066750 | 2066750 | 2021-12-30 | Raleigh | West Virginia | 54081 | 13924 | 225 |
2063500 | 2063500 | 2021-12-29 | Raleigh | West Virginia | 54081 | 13823 | 220 |
2060250 | 2060250 | 2021-12-28 | Raleigh | West Virginia | 54081 | 13771 | 218 |
2057001 | 2057001 | 2021-12-27 | Raleigh | West Virginia | 54081 | 13719 | 216 |
2053752 | 2053752 | 2021-12-26 | Raleigh | West Virginia | 54081 | 13605 | 214 |
2050502 | 2050502 | 2021-12-25 | Raleigh | West Virginia | 54081 | 13605 | 214 |
2047252 | 2047252 | 2021-12-24 | Raleigh | West Virginia | 54081 | 13605 | 214 |
2044002 | 2044002 | 2021-12-23 | Raleigh | West Virginia | 54081 | 13605 | 214 |
2040753 | 2040753 | 2021-12-22 | Raleigh | West Virginia | 54081 | 13528 | 214 |
2037503 | 2037503 | 2021-12-21 | Raleigh | West Virginia | 54081 | 13487 | 213 |
2034253 | 2034253 | 2021-12-20 | Raleigh | West Virginia | 54081 | 13445 | 212 |
2031003 | 2031003 | 2021-12-19 | Raleigh | West Virginia | 54081 | 13413 | 211 |
2027752 | 2027752 | 2021-12-18 | Raleigh | West Virginia | 54081 | 13352 | 211 |
2024501 | 2024501 | 2021-12-17 | Raleigh | West Virginia | 54081 | 13282 | 211 |
2021250 | 2021250 | 2021-12-16 | Raleigh | West Virginia | 54081 | 13211 | 209 |
2017999 | 2017999 | 2021-12-15 | Raleigh | West Virginia | 54081 | 13133 | 209 |
2014749 | 2014749 | 2021-12-14 | Raleigh | West Virginia | 54081 | 13084 | 206 |
2011498 | 2011498 | 2021-12-13 | Raleigh | West Virginia | 54081 | 13042 | 206 |
2008247 | 2008247 | 2021-12-12 | Raleigh | West Virginia | 54081 | 12994 | 204 |
2004996 | 2004996 | 2021-12-11 | Raleigh | West Virginia | 54081 | 12940 | 204 |
2001745 | 2001745 | 2021-12-10 | Raleigh | West Virginia | 54081 | 12892 | 204 |
1998495 | 1998495 | 2021-12-09 | Raleigh | West Virginia | 54081 | 12840 | 203 |
1995244 | 1995244 | 2021-12-08 | Raleigh | West Virginia | 54081 | 12784 | 200 |
1991993 | 1991993 | 2021-12-07 | Raleigh | West Virginia | 54081 | 12723 | 200 |
1988742 | 1988742 | 2021-12-06 | Raleigh | West Virginia | 54081 | 12679 | 200 |
1985492 | 1985492 | 2021-12-05 | Raleigh | West Virginia | 54081 | 12654 | 200 |
1982242 | 1982242 | 2021-12-04 | Raleigh | West Virginia | 54081 | 12630 | 200 |
1978992 | 1978992 | 2021-12-03 | Raleigh | West Virginia | 54081 | 12577 | 200 |
1975742 | 1975742 | 2021-12-02 | Raleigh | West Virginia | 54081 | 12524 | 200 |
1972493 | 1972493 | 2021-12-01 | Raleigh | West Virginia | 54081 | 12466 | 196 |
1969243 | 1969243 | 2021-11-30 | Raleigh | West Virginia | 54081 | 12400 | 196 |
1965993 | 1965993 | 2021-11-29 | Raleigh | West Virginia | 54081 | 12366 | 194 |
1962741 | 1962741 | 2021-11-28 | Raleigh | West Virginia | 54081 | 12248 | 192 |
1959490 | 1959490 | 2021-11-27 | Raleigh | West Virginia | 54081 | 12248 | 192 |
1956239 | 1956239 | 2021-11-26 | Raleigh | West Virginia | 54081 | 12248 | 192 |
1952988 | 1952988 | 2021-11-25 | Raleigh | West Virginia | 54081 | 12248 | 192 |
1949737 | 1949737 | 2021-11-24 | Raleigh | West Virginia | 54081 | 12248 | 192 |
1946486 | 1946486 | 2021-11-23 | Raleigh | West Virginia | 54081 | 12216 | 191 |
1943235 | 1943235 | 2021-11-22 | Raleigh | West Virginia | 54081 | 12168 | 190 |
1939985 | 1939985 | 2021-11-21 | Raleigh | West Virginia | 54081 | 12141 | 189 |
1936735 | 1936735 | 2021-11-20 | Raleigh | West Virginia | 54081 | 12108 | 189 |
1933485 | 1933485 | 2021-11-19 | Raleigh | West Virginia | 54081 | 12059 | 189 |
1930233 | 1930233 | 2021-11-18 | Raleigh | West Virginia | 54081 | 12009 | 189 |
1926983 | 1926983 | 2021-11-17 | Raleigh | West Virginia | 54081 | 11966 | 188 |
1923733 | 1923733 | 2021-11-16 | Raleigh | West Virginia | 54081 | 11937 | 187 |
1920484 | 1920484 | 2021-11-15 | Raleigh | West Virginia | 54081 | 11914 | 186 |
1917234 | 1917234 | 2021-11-14 | Raleigh | West Virginia | 54081 | 11890 | 186 |
1913984 | 1913984 | 2021-11-13 | Raleigh | West Virginia | 54081 | 11859 | 186 |
1910734 | 1910734 | 2021-11-12 | Raleigh | West Virginia | 54081 | 11836 | 186 |
1907485 | 1907485 | 2021-11-11 | Raleigh | West Virginia | 54081 | 11808 | 186 |
1904236 | 1904236 | 2021-11-10 | Raleigh | West Virginia | 54081 | 11769 | 184 |
1900986 | 1900986 | 2021-11-09 | Raleigh | West Virginia | 54081 | 11745 | 183 |
1897736 | 1897736 | 2021-11-08 | Raleigh | West Virginia | 54081 | 11712 | 180 |
1894486 | 1894486 | 2021-11-07 | Raleigh | West Virginia | 54081 | 11694 | 178 |
1891236 | 1891236 | 2021-11-06 | Raleigh | West Virginia | 54081 | 11664 | 178 |
1887986 | 1887986 | 2021-11-05 | Raleigh | West Virginia | 54081 | 11631 | 178 |
1884736 | 1884736 | 2021-11-04 | Raleigh | West Virginia | 54081 | 11608 | 177 |
1881487 | 1881487 | 2021-11-03 | Raleigh | West Virginia | 54081 | 11576 | 175 |
1878238 | 1878238 | 2021-11-02 | Raleigh | West Virginia | 54081 | 11535 | 175 |
1874989 | 1874989 | 2021-11-01 | Raleigh | West Virginia | 54081 | 11510 | 174 |
1871740 | 1871740 | 2021-10-31 | Raleigh | West Virginia | 54081 | 11490 | 173 |
1868491 | 1868491 | 2021-10-30 | Raleigh | West Virginia | 54081 | 11477 | 173 |
1865242 | 1865242 | 2021-10-29 | Raleigh | West Virginia | 54081 | 11439 | 173 |
1861993 | 1861993 | 2021-10-28 | Raleigh | West Virginia | 54081 | 11401 | 173 |
1858744 | 1858744 | 2021-10-27 | Raleigh | West Virginia | 54081 | 11360 | 171 |
1855495 | 1855495 | 2021-10-26 | Raleigh | West Virginia | 54081 | 11330 | 171 |
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);