ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 54107 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 |
---|---|---|---|---|---|---|---|
2177350 | 2177350 | 2022-02-02 | Wood | West Virginia | 54107 | 20512 | 298 |
2174097 | 2174097 | 2022-02-01 | Wood | West Virginia | 54107 | 20411 | 298 |
2170845 | 2170845 | 2022-01-31 | Wood | West Virginia | 54107 | 20344 | 297 |
2167592 | 2167592 | 2022-01-30 | Wood | West Virginia | 54107 | 20261 | 297 |
2164337 | 2164337 | 2022-01-29 | Wood | West Virginia | 54107 | 20181 | 297 |
2161082 | 2161082 | 2022-01-28 | Wood | West Virginia | 54107 | 20061 | 297 |
2157826 | 2157826 | 2022-01-27 | Wood | West Virginia | 54107 | 19881 | 296 |
2154573 | 2154573 | 2022-01-26 | Wood | West Virginia | 54107 | 19723 | 295 |
2151320 | 2151320 | 2022-01-25 | Wood | West Virginia | 54107 | 19558 | 294 |
2148068 | 2148068 | 2022-01-24 | Wood | West Virginia | 54107 | 19419 | 294 |
2144816 | 2144816 | 2022-01-23 | Wood | West Virginia | 54107 | 19250 | 291 |
2141561 | 2141561 | 2022-01-22 | Wood | West Virginia | 54107 | 19060 | 291 |
2138305 | 2138305 | 2022-01-21 | Wood | West Virginia | 54107 | 18822 | 291 |
2135050 | 2135050 | 2022-01-20 | Wood | West Virginia | 54107 | 18645 | 291 |
2131798 | 2131798 | 2022-01-19 | Wood | West Virginia | 54107 | 18468 | 288 |
2128544 | 2128544 | 2022-01-18 | Wood | West Virginia | 54107 | 18305 | 288 |
2125291 | 2125291 | 2022-01-17 | Wood | West Virginia | 54107 | 18243 | 285 |
2122039 | 2122039 | 2022-01-16 | Wood | West Virginia | 54107 | 18075 | 284 |
2118787 | 2118787 | 2022-01-15 | Wood | West Virginia | 54107 | 17854 | 284 |
2115535 | 2115535 | 2022-01-14 | Wood | West Virginia | 54107 | 17540 | 284 |
2112283 | 2112283 | 2022-01-13 | Wood | West Virginia | 54107 | 17298 | 283 |
2109031 | 2109031 | 2022-01-12 | Wood | West Virginia | 54107 | 17083 | 282 |
2105780 | 2105780 | 2022-01-11 | Wood | West Virginia | 54107 | 16889 | 278 |
2102529 | 2102529 | 2022-01-10 | Wood | West Virginia | 54107 | 16790 | 278 |
2099278 | 2099278 | 2022-01-09 | Wood | West Virginia | 54107 | 16691 | 277 |
2096027 | 2096027 | 2022-01-08 | Wood | West Virginia | 54107 | 16557 | 277 |
2092775 | 2092775 | 2022-01-07 | Wood | West Virginia | 54107 | 16363 | 277 |
2089523 | 2089523 | 2022-01-06 | Wood | West Virginia | 54107 | 16183 | 277 |
2086272 | 2086272 | 2022-01-05 | Wood | West Virginia | 54107 | 15992 | 277 |
2083020 | 2083020 | 2022-01-04 | Wood | West Virginia | 54107 | 15819 | 277 |
2079768 | 2079768 | 2022-01-03 | Wood | West Virginia | 54107 | 15698 | 277 |
2076516 | 2076516 | 2022-01-02 | Wood | West Virginia | 54107 | 15367 | 277 |
2073265 | 2073265 | 2022-01-01 | Wood | West Virginia | 54107 | 15367 | 277 |
2070014 | 2070014 | 2021-12-31 | Wood | West Virginia | 54107 | 15367 | 277 |
2066763 | 2066763 | 2021-12-30 | Wood | West Virginia | 54107 | 15367 | 277 |
2063513 | 2063513 | 2021-12-29 | Wood | West Virginia | 54107 | 15274 | 276 |
2060263 | 2060263 | 2021-12-28 | Wood | West Virginia | 54107 | 15192 | 276 |
2057014 | 2057014 | 2021-12-27 | Wood | West Virginia | 54107 | 15151 | 275 |
2053765 | 2053765 | 2021-12-26 | Wood | West Virginia | 54107 | 15043 | 274 |
2050515 | 2050515 | 2021-12-25 | Wood | West Virginia | 54107 | 15043 | 274 |
2047265 | 2047265 | 2021-12-24 | Wood | West Virginia | 54107 | 15043 | 274 |
2044015 | 2044015 | 2021-12-23 | Wood | West Virginia | 54107 | 15043 | 274 |
2040766 | 2040766 | 2021-12-22 | Wood | West Virginia | 54107 | 14997 | 274 |
2037516 | 2037516 | 2021-12-21 | Wood | West Virginia | 54107 | 14970 | 273 |
2034266 | 2034266 | 2021-12-20 | Wood | West Virginia | 54107 | 14948 | 272 |
2031016 | 2031016 | 2021-12-19 | Wood | West Virginia | 54107 | 14921 | 272 |
2027765 | 2027765 | 2021-12-18 | Wood | West Virginia | 54107 | 14902 | 272 |
2024514 | 2024514 | 2021-12-17 | Wood | West Virginia | 54107 | 14878 | 272 |
2021263 | 2021263 | 2021-12-16 | Wood | West Virginia | 54107 | 14843 | 272 |
2018012 | 2018012 | 2021-12-15 | Wood | West Virginia | 54107 | 14794 | 272 |
2014762 | 2014762 | 2021-12-14 | Wood | West Virginia | 54107 | 14747 | 272 |
2011511 | 2011511 | 2021-12-13 | Wood | West Virginia | 54107 | 14725 | 271 |
2008260 | 2008260 | 2021-12-12 | Wood | West Virginia | 54107 | 14698 | 271 |
2005009 | 2005009 | 2021-12-11 | Wood | West Virginia | 54107 | 14660 | 271 |
2001758 | 2001758 | 2021-12-10 | Wood | West Virginia | 54107 | 14601 | 271 |
1998508 | 1998508 | 2021-12-09 | Wood | West Virginia | 54107 | 14542 | 271 |
1995257 | 1995257 | 2021-12-08 | Wood | West Virginia | 54107 | 14504 | 268 |
1992006 | 1992006 | 2021-12-07 | Wood | West Virginia | 54107 | 14466 | 268 |
1988755 | 1988755 | 2021-12-06 | Wood | West Virginia | 54107 | 14441 | 267 |
1985505 | 1985505 | 2021-12-05 | Wood | West Virginia | 54107 | 14390 | 266 |
1982255 | 1982255 | 2021-12-04 | Wood | West Virginia | 54107 | 14352 | 266 |
1979005 | 1979005 | 2021-12-03 | Wood | West Virginia | 54107 | 14303 | 266 |
1975755 | 1975755 | 2021-12-02 | Wood | West Virginia | 54107 | 14220 | 266 |
1972506 | 1972506 | 2021-12-01 | Wood | West Virginia | 54107 | 14158 | 265 |
1969256 | 1969256 | 2021-11-30 | Wood | West Virginia | 54107 | 14106 | 265 |
1966006 | 1966006 | 2021-11-29 | Wood | West Virginia | 54107 | 14058 | 263 |
1962754 | 1962754 | 2021-11-28 | Wood | West Virginia | 54107 | 13906 | 264 |
1959503 | 1959503 | 2021-11-27 | Wood | West Virginia | 54107 | 13906 | 264 |
1956252 | 1956252 | 2021-11-26 | Wood | West Virginia | 54107 | 13906 | 264 |
1953001 | 1953001 | 2021-11-25 | Wood | West Virginia | 54107 | 13906 | 264 |
1949750 | 1949750 | 2021-11-24 | Wood | West Virginia | 54107 | 13906 | 264 |
1946499 | 1946499 | 2021-11-23 | Wood | West Virginia | 54107 | 13862 | 262 |
1943248 | 1943248 | 2021-11-22 | Wood | West Virginia | 54107 | 13821 | 262 |
1939998 | 1939998 | 2021-11-21 | Wood | West Virginia | 54107 | 13800 | 259 |
1936748 | 1936748 | 2021-11-20 | Wood | West Virginia | 54107 | 13776 | 259 |
1933498 | 1933498 | 2021-11-19 | Wood | West Virginia | 54107 | 13745 | 259 |
1930246 | 1930246 | 2021-11-18 | Wood | West Virginia | 54107 | 13691 | 258 |
1926996 | 1926996 | 2021-11-17 | Wood | West Virginia | 54107 | 13647 | 256 |
1923746 | 1923746 | 2021-11-16 | Wood | West Virginia | 54107 | 13600 | 255 |
1920497 | 1920497 | 2021-11-15 | Wood | West Virginia | 54107 | 13576 | 254 |
1917247 | 1917247 | 2021-11-14 | Wood | West Virginia | 54107 | 13552 | 254 |
1913997 | 1913997 | 2021-11-13 | Wood | West Virginia | 54107 | 13538 | 254 |
1910747 | 1910747 | 2021-11-12 | Wood | West Virginia | 54107 | 13517 | 254 |
1907498 | 1907498 | 2021-11-11 | Wood | West Virginia | 54107 | 13483 | 254 |
1904249 | 1904249 | 2021-11-10 | Wood | West Virginia | 54107 | 13454 | 254 |
1900999 | 1900999 | 2021-11-09 | Wood | West Virginia | 54107 | 13415 | 254 |
1897749 | 1897749 | 2021-11-08 | Wood | West Virginia | 54107 | 13397 | 254 |
1894499 | 1894499 | 2021-11-07 | Wood | West Virginia | 54107 | 13382 | 251 |
1891249 | 1891249 | 2021-11-06 | Wood | West Virginia | 54107 | 13353 | 251 |
1887999 | 1887999 | 2021-11-05 | Wood | West Virginia | 54107 | 13324 | 251 |
1884749 | 1884749 | 2021-11-04 | Wood | West Virginia | 54107 | 13303 | 250 |
1881500 | 1881500 | 2021-11-03 | Wood | West Virginia | 54107 | 13278 | 250 |
1878251 | 1878251 | 2021-11-02 | Wood | West Virginia | 54107 | 13242 | 249 |
1875002 | 1875002 | 2021-11-01 | Wood | West Virginia | 54107 | 13217 | 249 |
1871753 | 1871753 | 2021-10-31 | Wood | West Virginia | 54107 | 13185 | 246 |
1868504 | 1868504 | 2021-10-30 | Wood | West Virginia | 54107 | 13152 | 246 |
1865255 | 1865255 | 2021-10-29 | Wood | West Virginia | 54107 | 13119 | 246 |
1862006 | 1862006 | 2021-10-28 | Wood | West Virginia | 54107 | 13088 | 246 |
1858757 | 1858757 | 2021-10-27 | Wood | West Virginia | 54107 | 13070 | 245 |
1855508 | 1855508 | 2021-10-26 | Wood | West Virginia | 54107 | 13037 | 243 |
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);