ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where fips = 54109 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 |
---|---|---|---|---|---|---|---|
2112284 | 2112284 | 2022-01-13 | Wyoming | West Virginia | 54109 | 4667 | 79 |
2109032 | 2109032 | 2022-01-12 | Wyoming | West Virginia | 54109 | 4617 | 78 |
2105781 | 2105781 | 2022-01-11 | Wyoming | West Virginia | 54109 | 4548 | 77 |
2102530 | 2102530 | 2022-01-10 | Wyoming | West Virginia | 54109 | 4533 | 77 |
2099279 | 2099279 | 2022-01-09 | Wyoming | West Virginia | 54109 | 4527 | 77 |
2096028 | 2096028 | 2022-01-08 | Wyoming | West Virginia | 54109 | 4506 | 77 |
2092776 | 2092776 | 2022-01-07 | Wyoming | West Virginia | 54109 | 4478 | 77 |
2089524 | 2089524 | 2022-01-06 | Wyoming | West Virginia | 54109 | 4451 | 77 |
2086273 | 2086273 | 2022-01-05 | Wyoming | West Virginia | 54109 | 4405 | 76 |
2083021 | 2083021 | 2022-01-04 | Wyoming | West Virginia | 54109 | 4366 | 76 |
2079769 | 2079769 | 2022-01-03 | Wyoming | West Virginia | 54109 | 4356 | 76 |
2076517 | 2076517 | 2022-01-02 | Wyoming | West Virginia | 54109 | 4265 | 76 |
2073266 | 2073266 | 2022-01-01 | Wyoming | West Virginia | 54109 | 4265 | 76 |
2070015 | 2070015 | 2021-12-31 | Wyoming | West Virginia | 54109 | 4265 | 76 |
2066764 | 2066764 | 2021-12-30 | Wyoming | West Virginia | 54109 | 4265 | 76 |
2063514 | 2063514 | 2021-12-29 | Wyoming | West Virginia | 54109 | 4236 | 76 |
2060264 | 2060264 | 2021-12-28 | Wyoming | West Virginia | 54109 | 4197 | 76 |
2057015 | 2057015 | 2021-12-27 | Wyoming | West Virginia | 54109 | 4190 | 76 |
2053766 | 2053766 | 2021-12-26 | Wyoming | West Virginia | 54109 | 4153 | 76 |
2050516 | 2050516 | 2021-12-25 | Wyoming | West Virginia | 54109 | 4153 | 76 |
2047266 | 2047266 | 2021-12-24 | Wyoming | West Virginia | 54109 | 4153 | 76 |
2044016 | 2044016 | 2021-12-23 | Wyoming | West Virginia | 54109 | 4153 | 76 |
2040767 | 2040767 | 2021-12-22 | Wyoming | West Virginia | 54109 | 4126 | 76 |
2037517 | 2037517 | 2021-12-21 | Wyoming | West Virginia | 54109 | 4109 | 76 |
2034267 | 2034267 | 2021-12-20 | Wyoming | West Virginia | 54109 | 4104 | 76 |
2031017 | 2031017 | 2021-12-19 | Wyoming | West Virginia | 54109 | 4099 | 75 |
2027766 | 2027766 | 2021-12-18 | Wyoming | West Virginia | 54109 | 4088 | 75 |
2024515 | 2024515 | 2021-12-17 | Wyoming | West Virginia | 54109 | 4077 | 75 |
2021264 | 2021264 | 2021-12-16 | Wyoming | West Virginia | 54109 | 4064 | 75 |
2018013 | 2018013 | 2021-12-15 | Wyoming | West Virginia | 54109 | 4049 | 75 |
2014763 | 2014763 | 2021-12-14 | Wyoming | West Virginia | 54109 | 4037 | 75 |
2011512 | 2011512 | 2021-12-13 | Wyoming | West Virginia | 54109 | 4023 | 75 |
2008261 | 2008261 | 2021-12-12 | Wyoming | West Virginia | 54109 | 4018 | 75 |
2005010 | 2005010 | 2021-12-11 | Wyoming | West Virginia | 54109 | 4015 | 75 |
2001759 | 2001759 | 2021-12-10 | Wyoming | West Virginia | 54109 | 4003 | 75 |
1998509 | 1998509 | 2021-12-09 | Wyoming | West Virginia | 54109 | 3997 | 72 |
1995258 | 1995258 | 2021-12-08 | Wyoming | West Virginia | 54109 | 3983 | 72 |
1992007 | 1992007 | 2021-12-07 | Wyoming | West Virginia | 54109 | 3977 | 72 |
1988756 | 1988756 | 2021-12-06 | Wyoming | West Virginia | 54109 | 3972 | 71 |
1985506 | 1985506 | 2021-12-05 | Wyoming | West Virginia | 54109 | 3966 | 71 |
1982256 | 1982256 | 2021-12-04 | Wyoming | West Virginia | 54109 | 3952 | 71 |
1979006 | 1979006 | 2021-12-03 | Wyoming | West Virginia | 54109 | 3940 | 71 |
1975756 | 1975756 | 2021-12-02 | Wyoming | West Virginia | 54109 | 3911 | 71 |
1972507 | 1972507 | 2021-12-01 | Wyoming | West Virginia | 54109 | 3899 | 67 |
1969257 | 1969257 | 2021-11-30 | Wyoming | West Virginia | 54109 | 3884 | 67 |
1966007 | 1966007 | 2021-11-29 | Wyoming | West Virginia | 54109 | 3883 | 67 |
1962755 | 1962755 | 2021-11-28 | Wyoming | West Virginia | 54109 | 3865 | 67 |
1959504 | 1959504 | 2021-11-27 | Wyoming | West Virginia | 54109 | 3865 | 67 |
1956253 | 1956253 | 2021-11-26 | Wyoming | West Virginia | 54109 | 3865 | 67 |
1953002 | 1953002 | 2021-11-25 | Wyoming | West Virginia | 54109 | 3865 | 67 |
1949751 | 1949751 | 2021-11-24 | Wyoming | West Virginia | 54109 | 3865 | 67 |
1946500 | 1946500 | 2021-11-23 | Wyoming | West Virginia | 54109 | 3858 | 67 |
1943249 | 1943249 | 2021-11-22 | Wyoming | West Virginia | 54109 | 3857 | 67 |
1939999 | 1939999 | 2021-11-21 | Wyoming | West Virginia | 54109 | 3854 | 67 |
1936749 | 1936749 | 2021-11-20 | Wyoming | West Virginia | 54109 | 3847 | 67 |
1933499 | 1933499 | 2021-11-19 | Wyoming | West Virginia | 54109 | 3842 | 67 |
1930247 | 1930247 | 2021-11-18 | Wyoming | West Virginia | 54109 | 3839 | 67 |
1926997 | 1926997 | 2021-11-17 | Wyoming | West Virginia | 54109 | 3829 | 67 |
1923747 | 1923747 | 2021-11-16 | Wyoming | West Virginia | 54109 | 3814 | 67 |
1920498 | 1920498 | 2021-11-15 | Wyoming | West Virginia | 54109 | 3814 | 66 |
1917248 | 1917248 | 2021-11-14 | Wyoming | West Virginia | 54109 | 3814 | 66 |
1913998 | 1913998 | 2021-11-13 | Wyoming | West Virginia | 54109 | 3805 | 66 |
1910748 | 1910748 | 2021-11-12 | Wyoming | West Virginia | 54109 | 3797 | 66 |
1907499 | 1907499 | 2021-11-11 | Wyoming | West Virginia | 54109 | 3788 | 66 |
1904250 | 1904250 | 2021-11-10 | Wyoming | West Virginia | 54109 | 3777 | 66 |
1901000 | 1901000 | 2021-11-09 | Wyoming | West Virginia | 54109 | 3765 | 66 |
1897750 | 1897750 | 2021-11-08 | Wyoming | West Virginia | 54109 | 3763 | 65 |
1894500 | 1894500 | 2021-11-07 | Wyoming | West Virginia | 54109 | 3758 | 65 |
1891250 | 1891250 | 2021-11-06 | Wyoming | West Virginia | 54109 | 3748 | 65 |
1888000 | 1888000 | 2021-11-05 | Wyoming | West Virginia | 54109 | 3738 | 65 |
1884750 | 1884750 | 2021-11-04 | Wyoming | West Virginia | 54109 | 3728 | 65 |
1881501 | 1881501 | 2021-11-03 | Wyoming | West Virginia | 54109 | 3718 | 65 |
1878252 | 1878252 | 2021-11-02 | Wyoming | West Virginia | 54109 | 3705 | 65 |
1875003 | 1875003 | 2021-11-01 | Wyoming | West Virginia | 54109 | 3699 | 61 |
1871754 | 1871754 | 2021-10-31 | Wyoming | West Virginia | 54109 | 3690 | 61 |
1868505 | 1868505 | 2021-10-30 | Wyoming | West Virginia | 54109 | 3675 | 61 |
1865256 | 1865256 | 2021-10-29 | Wyoming | West Virginia | 54109 | 3661 | 61 |
1862007 | 1862007 | 2021-10-28 | Wyoming | West Virginia | 54109 | 3649 | 61 |
1858758 | 1858758 | 2021-10-27 | Wyoming | West Virginia | 54109 | 3638 | 61 |
1855509 | 1855509 | 2021-10-26 | Wyoming | West Virginia | 54109 | 3617 | 61 |
1852260 | 1852260 | 2021-10-25 | Wyoming | West Virginia | 54109 | 3613 | 60 |
1849010 | 1849010 | 2021-10-24 | Wyoming | West Virginia | 54109 | 3600 | 59 |
1845760 | 1845760 | 2021-10-23 | Wyoming | West Virginia | 54109 | 3583 | 59 |
1842510 | 1842510 | 2021-10-22 | Wyoming | West Virginia | 54109 | 3569 | 59 |
1839261 | 1839261 | 2021-10-21 | Wyoming | West Virginia | 54109 | 3561 | 58 |
1836012 | 1836012 | 2021-10-20 | Wyoming | West Virginia | 54109 | 3547 | 57 |
1832763 | 1832763 | 2021-10-19 | Wyoming | West Virginia | 54109 | 3529 | 57 |
1829514 | 1829514 | 2021-10-18 | Wyoming | West Virginia | 54109 | 3521 | 57 |
1826265 | 1826265 | 2021-10-17 | Wyoming | West Virginia | 54109 | 3512 | 57 |
1823016 | 1823016 | 2021-10-16 | Wyoming | West Virginia | 54109 | 3498 | 57 |
1819767 | 1819767 | 2021-10-15 | Wyoming | West Virginia | 54109 | 3489 | 56 |
1816518 | 1816518 | 2021-10-14 | Wyoming | West Virginia | 54109 | 3473 | 55 |
1813270 | 1813270 | 2021-10-13 | Wyoming | West Virginia | 54109 | 3452 | 56 |
1810021 | 1810021 | 2021-10-12 | Wyoming | West Virginia | 54109 | 3432 | 56 |
1806772 | 1806772 | 2021-10-11 | Wyoming | West Virginia | 54109 | 3424 | 54 |
1803521 | 1803521 | 2021-10-10 | Wyoming | West Virginia | 54109 | 3419 | 54 |
1800272 | 1800272 | 2021-10-09 | Wyoming | West Virginia | 54109 | 3400 | 54 |
1797023 | 1797023 | 2021-10-08 | Wyoming | West Virginia | 54109 | 3397 | 54 |
1793774 | 1793774 | 2021-10-07 | Wyoming | West Virginia | 54109 | 3374 | 52 |
1790525 | 1790525 | 2021-10-06 | Wyoming | West Virginia | 54109 | 3325 | 52 |
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);