ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Marshall" 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 |
---|---|---|---|---|---|---|---|
2177321 | 2177321 | 2022-02-02 | Marshall | West Virginia | 54051 | 8104 | 143 |
2174068 | 2174068 | 2022-02-01 | Marshall | West Virginia | 54051 | 8064 | 143 |
2170816 | 2170816 | 2022-01-31 | Marshall | West Virginia | 54051 | 8015 | 143 |
2167563 | 2167563 | 2022-01-30 | Marshall | West Virginia | 54051 | 8001 | 143 |
2164308 | 2164308 | 2022-01-29 | Marshall | West Virginia | 54051 | 7979 | 143 |
2161053 | 2161053 | 2022-01-28 | Marshall | West Virginia | 54051 | 7941 | 143 |
2157797 | 2157797 | 2022-01-27 | Marshall | West Virginia | 54051 | 7892 | 143 |
2154544 | 2154544 | 2022-01-26 | Marshall | West Virginia | 54051 | 7768 | 143 |
2151291 | 2151291 | 2022-01-25 | Marshall | West Virginia | 54051 | 7717 | 143 |
2148039 | 2148039 | 2022-01-24 | Marshall | West Virginia | 54051 | 7665 | 143 |
2144787 | 2144787 | 2022-01-23 | Marshall | West Virginia | 54051 | 7641 | 142 |
2141532 | 2141532 | 2022-01-22 | Marshall | West Virginia | 54051 | 7546 | 142 |
2138276 | 2138276 | 2022-01-21 | Marshall | West Virginia | 54051 | 7480 | 142 |
2135021 | 2135021 | 2022-01-20 | Marshall | West Virginia | 54051 | 7387 | 142 |
2131769 | 2131769 | 2022-01-19 | Marshall | West Virginia | 54051 | 7288 | 139 |
2128515 | 2128515 | 2022-01-18 | Marshall | West Virginia | 54051 | 7240 | 139 |
2125262 | 2125262 | 2022-01-17 | Marshall | West Virginia | 54051 | 7194 | 138 |
2122010 | 2122010 | 2022-01-16 | Marshall | West Virginia | 54051 | 7065 | 137 |
2118758 | 2118758 | 2022-01-15 | Marshall | West Virginia | 54051 | 7006 | 137 |
2115506 | 2115506 | 2022-01-14 | Marshall | West Virginia | 54051 | 6921 | 137 |
2112254 | 2112254 | 2022-01-13 | Marshall | West Virginia | 54051 | 6872 | 137 |
2109002 | 2109002 | 2022-01-12 | Marshall | West Virginia | 54051 | 6806 | 136 |
2105751 | 2105751 | 2022-01-11 | Marshall | West Virginia | 54051 | 6745 | 135 |
2102500 | 2102500 | 2022-01-10 | Marshall | West Virginia | 54051 | 6621 | 134 |
2099249 | 2099249 | 2022-01-09 | Marshall | West Virginia | 54051 | 6590 | 134 |
2095998 | 2095998 | 2022-01-08 | Marshall | West Virginia | 54051 | 6566 | 134 |
2092746 | 2092746 | 2022-01-07 | Marshall | West Virginia | 54051 | 6489 | 134 |
2089494 | 2089494 | 2022-01-06 | Marshall | West Virginia | 54051 | 6416 | 133 |
2086243 | 2086243 | 2022-01-05 | Marshall | West Virginia | 54051 | 6379 | 133 |
2082991 | 2082991 | 2022-01-04 | Marshall | West Virginia | 54051 | 6324 | 133 |
2079739 | 2079739 | 2022-01-03 | Marshall | West Virginia | 54051 | 6295 | 133 |
2076487 | 2076487 | 2022-01-02 | Marshall | West Virginia | 54051 | 6120 | 133 |
2073236 | 2073236 | 2022-01-01 | Marshall | West Virginia | 54051 | 6120 | 133 |
2069985 | 2069985 | 2021-12-31 | Marshall | West Virginia | 54051 | 6120 | 133 |
2066734 | 2066734 | 2021-12-30 | Marshall | West Virginia | 54051 | 6120 | 133 |
2063484 | 2063484 | 2021-12-29 | Marshall | West Virginia | 54051 | 6094 | 133 |
2060234 | 2060234 | 2021-12-28 | Marshall | West Virginia | 54051 | 6074 | 132 |
2056985 | 2056985 | 2021-12-27 | Marshall | West Virginia | 54051 | 6064 | 132 |
2053736 | 2053736 | 2021-12-26 | Marshall | West Virginia | 54051 | 6014 | 132 |
2050486 | 2050486 | 2021-12-25 | Marshall | West Virginia | 54051 | 6014 | 132 |
2047236 | 2047236 | 2021-12-24 | Marshall | West Virginia | 54051 | 6014 | 132 |
2043986 | 2043986 | 2021-12-23 | Marshall | West Virginia | 54051 | 6014 | 132 |
2040737 | 2040737 | 2021-12-22 | Marshall | West Virginia | 54051 | 5993 | 132 |
2037487 | 2037487 | 2021-12-21 | Marshall | West Virginia | 54051 | 5969 | 131 |
2034237 | 2034237 | 2021-12-20 | Marshall | West Virginia | 54051 | 5960 | 131 |
2030987 | 2030987 | 2021-12-19 | Marshall | West Virginia | 54051 | 5952 | 130 |
2027736 | 2027736 | 2021-12-18 | Marshall | West Virginia | 54051 | 5937 | 130 |
2024485 | 2024485 | 2021-12-17 | Marshall | West Virginia | 54051 | 5921 | 130 |
2021234 | 2021234 | 2021-12-16 | Marshall | West Virginia | 54051 | 5911 | 130 |
2017983 | 2017983 | 2021-12-15 | Marshall | West Virginia | 54051 | 5904 | 130 |
2014733 | 2014733 | 2021-12-14 | Marshall | West Virginia | 54051 | 5893 | 129 |
2011482 | 2011482 | 2021-12-13 | Marshall | West Virginia | 54051 | 5876 | 129 |
2008231 | 2008231 | 2021-12-12 | Marshall | West Virginia | 54051 | 5865 | 126 |
2004980 | 2004980 | 2021-12-11 | Marshall | West Virginia | 54051 | 5860 | 126 |
2001729 | 2001729 | 2021-12-10 | Marshall | West Virginia | 54051 | 5850 | 126 |
1998479 | 1998479 | 2021-12-09 | Marshall | West Virginia | 54051 | 5829 | 126 |
1995228 | 1995228 | 2021-12-08 | Marshall | West Virginia | 54051 | 5819 | 125 |
1991977 | 1991977 | 2021-12-07 | Marshall | West Virginia | 54051 | 5802 | 124 |
1988726 | 1988726 | 2021-12-06 | Marshall | West Virginia | 54051 | 5796 | 123 |
1985476 | 1985476 | 2021-12-05 | Marshall | West Virginia | 54051 | 5792 | 122 |
1982226 | 1982226 | 2021-12-04 | Marshall | West Virginia | 54051 | 5779 | 122 |
1978976 | 1978976 | 2021-12-03 | Marshall | West Virginia | 54051 | 5754 | 122 |
1975726 | 1975726 | 2021-12-02 | Marshall | West Virginia | 54051 | 5737 | 119 |
1972477 | 1972477 | 2021-12-01 | Marshall | West Virginia | 54051 | 5713 | 119 |
1969227 | 1969227 | 2021-11-30 | Marshall | West Virginia | 54051 | 5702 | 119 |
1965977 | 1965977 | 2021-11-29 | Marshall | West Virginia | 54051 | 5689 | 119 |
1962725 | 1962725 | 2021-11-28 | Marshall | West Virginia | 54051 | 5642 | 119 |
1959474 | 1959474 | 2021-11-27 | Marshall | West Virginia | 54051 | 5642 | 119 |
1956223 | 1956223 | 2021-11-26 | Marshall | West Virginia | 54051 | 5642 | 119 |
1952972 | 1952972 | 2021-11-25 | Marshall | West Virginia | 54051 | 5642 | 119 |
1949721 | 1949721 | 2021-11-24 | Marshall | West Virginia | 54051 | 5642 | 119 |
1946470 | 1946470 | 2021-11-23 | Marshall | West Virginia | 54051 | 5617 | 118 |
1943219 | 1943219 | 2021-11-22 | Marshall | West Virginia | 54051 | 5603 | 117 |
1939969 | 1939969 | 2021-11-21 | Marshall | West Virginia | 54051 | 5592 | 117 |
1936719 | 1936719 | 2021-11-20 | Marshall | West Virginia | 54051 | 5572 | 117 |
1933469 | 1933469 | 2021-11-19 | Marshall | West Virginia | 54051 | 5563 | 117 |
1930217 | 1930217 | 2021-11-18 | Marshall | West Virginia | 54051 | 5541 | 117 |
1926967 | 1926967 | 2021-11-17 | Marshall | West Virginia | 54051 | 5514 | 117 |
1923717 | 1923717 | 2021-11-16 | Marshall | West Virginia | 54051 | 5492 | 117 |
1920468 | 1920468 | 2021-11-15 | Marshall | West Virginia | 54051 | 5479 | 116 |
1917218 | 1917218 | 2021-11-14 | Marshall | West Virginia | 54051 | 5470 | 116 |
1913968 | 1913968 | 2021-11-13 | Marshall | West Virginia | 54051 | 5455 | 116 |
1910718 | 1910718 | 2021-11-12 | Marshall | West Virginia | 54051 | 5439 | 116 |
1907469 | 1907469 | 2021-11-11 | Marshall | West Virginia | 54051 | 5426 | 116 |
1904220 | 1904220 | 2021-11-10 | Marshall | West Virginia | 54051 | 5414 | 116 |
1900970 | 1900970 | 2021-11-09 | Marshall | West Virginia | 54051 | 5403 | 116 |
1897720 | 1897720 | 2021-11-08 | Marshall | West Virginia | 54051 | 5395 | 116 |
1894470 | 1894470 | 2021-11-07 | Marshall | West Virginia | 54051 | 5389 | 116 |
1891220 | 1891220 | 2021-11-06 | Marshall | West Virginia | 54051 | 5375 | 116 |
1887970 | 1887970 | 2021-11-05 | Marshall | West Virginia | 54051 | 5367 | 116 |
1884720 | 1884720 | 2021-11-04 | Marshall | West Virginia | 54051 | 5359 | 116 |
1881471 | 1881471 | 2021-11-03 | Marshall | West Virginia | 54051 | 5353 | 116 |
1878222 | 1878222 | 2021-11-02 | Marshall | West Virginia | 54051 | 5341 | 116 |
1874973 | 1874973 | 2021-11-01 | Marshall | West Virginia | 54051 | 5332 | 115 |
1871724 | 1871724 | 2021-10-31 | Marshall | West Virginia | 54051 | 5329 | 114 |
1868475 | 1868475 | 2021-10-30 | Marshall | West Virginia | 54051 | 5319 | 114 |
1865226 | 1865226 | 2021-10-29 | Marshall | West Virginia | 54051 | 5301 | 114 |
1861977 | 1861977 | 2021-10-28 | Marshall | West Virginia | 54051 | 5297 | 114 |
1858728 | 1858728 | 2021-10-27 | Marshall | West Virginia | 54051 | 5281 | 110 |
1855479 | 1855479 | 2021-10-26 | Marshall | West Virginia | 54051 | 5273 | 110 |
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);