ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Logan" 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 |
---|---|---|---|---|---|---|---|
2177319 | 2177319 | 2022-02-02 | Logan | West Virginia | 54045 | 8623 | 161 |
2174066 | 2174066 | 2022-02-01 | Logan | West Virginia | 54045 | 8554 | 160 |
2170814 | 2170814 | 2022-01-31 | Logan | West Virginia | 54045 | 8489 | 160 |
2167561 | 2167561 | 2022-01-30 | Logan | West Virginia | 54045 | 8445 | 160 |
2164306 | 2164306 | 2022-01-29 | Logan | West Virginia | 54045 | 8383 | 160 |
2161051 | 2161051 | 2022-01-28 | Logan | West Virginia | 54045 | 8299 | 160 |
2157795 | 2157795 | 2022-01-27 | Logan | West Virginia | 54045 | 8171 | 158 |
2154542 | 2154542 | 2022-01-26 | Logan | West Virginia | 54045 | 8058 | 156 |
2151289 | 2151289 | 2022-01-25 | Logan | West Virginia | 54045 | 7923 | 156 |
2148037 | 2148037 | 2022-01-24 | Logan | West Virginia | 54045 | 7864 | 156 |
2144785 | 2144785 | 2022-01-23 | Logan | West Virginia | 54045 | 7802 | 156 |
2141530 | 2141530 | 2022-01-22 | Logan | West Virginia | 54045 | 7722 | 156 |
2138274 | 2138274 | 2022-01-21 | Logan | West Virginia | 54045 | 7557 | 156 |
2135019 | 2135019 | 2022-01-20 | Logan | West Virginia | 54045 | 7416 | 156 |
2131767 | 2131767 | 2022-01-19 | Logan | West Virginia | 54045 | 7279 | 156 |
2128513 | 2128513 | 2022-01-18 | Logan | West Virginia | 54045 | 7176 | 156 |
2125260 | 2125260 | 2022-01-17 | Logan | West Virginia | 54045 | 7135 | 155 |
2122008 | 2122008 | 2022-01-16 | Logan | West Virginia | 54045 | 7087 | 155 |
2118756 | 2118756 | 2022-01-15 | Logan | West Virginia | 54045 | 7037 | 155 |
2115504 | 2115504 | 2022-01-14 | Logan | West Virginia | 54045 | 6954 | 155 |
2112252 | 2112252 | 2022-01-13 | Logan | West Virginia | 54045 | 6874 | 155 |
2109000 | 2109000 | 2022-01-12 | Logan | West Virginia | 54045 | 6788 | 155 |
2105749 | 2105749 | 2022-01-11 | Logan | West Virginia | 54045 | 6707 | 155 |
2102498 | 2102498 | 2022-01-10 | Logan | West Virginia | 54045 | 6672 | 155 |
2099247 | 2099247 | 2022-01-09 | Logan | West Virginia | 54045 | 6640 | 155 |
2095996 | 2095996 | 2022-01-08 | Logan | West Virginia | 54045 | 6606 | 155 |
2092744 | 2092744 | 2022-01-07 | Logan | West Virginia | 54045 | 6576 | 155 |
2089492 | 2089492 | 2022-01-06 | Logan | West Virginia | 54045 | 6516 | 155 |
2086241 | 2086241 | 2022-01-05 | Logan | West Virginia | 54045 | 6458 | 154 |
2082989 | 2082989 | 2022-01-04 | Logan | West Virginia | 54045 | 6429 | 154 |
2079737 | 2079737 | 2022-01-03 | Logan | West Virginia | 54045 | 6390 | 154 |
2076485 | 2076485 | 2022-01-02 | Logan | West Virginia | 54045 | 6279 | 154 |
2073234 | 2073234 | 2022-01-01 | Logan | West Virginia | 54045 | 6279 | 154 |
2069983 | 2069983 | 2021-12-31 | Logan | West Virginia | 54045 | 6279 | 154 |
2066732 | 2066732 | 2021-12-30 | Logan | West Virginia | 54045 | 6279 | 154 |
2063482 | 2063482 | 2021-12-29 | Logan | West Virginia | 54045 | 6253 | 154 |
2060232 | 2060232 | 2021-12-28 | Logan | West Virginia | 54045 | 6218 | 154 |
2056983 | 2056983 | 2021-12-27 | Logan | West Virginia | 54045 | 6197 | 153 |
2053734 | 2053734 | 2021-12-26 | Logan | West Virginia | 54045 | 6155 | 153 |
2050484 | 2050484 | 2021-12-25 | Logan | West Virginia | 54045 | 6155 | 153 |
2047234 | 2047234 | 2021-12-24 | Logan | West Virginia | 54045 | 6155 | 153 |
2043984 | 2043984 | 2021-12-23 | Logan | West Virginia | 54045 | 6155 | 153 |
2040735 | 2040735 | 2021-12-22 | Logan | West Virginia | 54045 | 6132 | 152 |
2037485 | 2037485 | 2021-12-21 | Logan | West Virginia | 54045 | 6100 | 151 |
2034235 | 2034235 | 2021-12-20 | Logan | West Virginia | 54045 | 6075 | 150 |
2030985 | 2030985 | 2021-12-19 | Logan | West Virginia | 54045 | 6058 | 150 |
2027734 | 2027734 | 2021-12-18 | Logan | West Virginia | 54045 | 6043 | 150 |
2024483 | 2024483 | 2021-12-17 | Logan | West Virginia | 54045 | 6018 | 150 |
2021232 | 2021232 | 2021-12-16 | Logan | West Virginia | 54045 | 6002 | 150 |
2017981 | 2017981 | 2021-12-15 | Logan | West Virginia | 54045 | 5986 | 150 |
2014731 | 2014731 | 2021-12-14 | Logan | West Virginia | 54045 | 5958 | 150 |
2011480 | 2011480 | 2021-12-13 | Logan | West Virginia | 54045 | 5943 | 149 |
2008229 | 2008229 | 2021-12-12 | Logan | West Virginia | 54045 | 5936 | 149 |
2004978 | 2004978 | 2021-12-11 | Logan | West Virginia | 54045 | 5921 | 149 |
2001727 | 2001727 | 2021-12-10 | Logan | West Virginia | 54045 | 5907 | 149 |
1998477 | 1998477 | 2021-12-09 | Logan | West Virginia | 54045 | 5896 | 149 |
1995226 | 1995226 | 2021-12-08 | Logan | West Virginia | 54045 | 5871 | 148 |
1991975 | 1991975 | 2021-12-07 | Logan | West Virginia | 54045 | 5860 | 148 |
1988724 | 1988724 | 2021-12-06 | Logan | West Virginia | 54045 | 5845 | 148 |
1985474 | 1985474 | 2021-12-05 | Logan | West Virginia | 54045 | 5834 | 148 |
1982224 | 1982224 | 2021-12-04 | Logan | West Virginia | 54045 | 5817 | 148 |
1978974 | 1978974 | 2021-12-03 | Logan | West Virginia | 54045 | 5799 | 148 |
1975724 | 1975724 | 2021-12-02 | Logan | West Virginia | 54045 | 5784 | 148 |
1972475 | 1972475 | 2021-12-01 | Logan | West Virginia | 54045 | 5761 | 146 |
1969225 | 1969225 | 2021-11-30 | Logan | West Virginia | 54045 | 5727 | 146 |
1965975 | 1965975 | 2021-11-29 | Logan | West Virginia | 54045 | 5712 | 146 |
1962723 | 1962723 | 2021-11-28 | Logan | West Virginia | 54045 | 5656 | 144 |
1959472 | 1959472 | 2021-11-27 | Logan | West Virginia | 54045 | 5656 | 144 |
1956221 | 1956221 | 2021-11-26 | Logan | West Virginia | 54045 | 5656 | 144 |
1952970 | 1952970 | 2021-11-25 | Logan | West Virginia | 54045 | 5656 | 144 |
1949719 | 1949719 | 2021-11-24 | Logan | West Virginia | 54045 | 5656 | 144 |
1946468 | 1946468 | 2021-11-23 | Logan | West Virginia | 54045 | 5644 | 143 |
1943217 | 1943217 | 2021-11-22 | Logan | West Virginia | 54045 | 5615 | 141 |
1939967 | 1939967 | 2021-11-21 | Logan | West Virginia | 54045 | 5607 | 140 |
1936717 | 1936717 | 2021-11-20 | Logan | West Virginia | 54045 | 5599 | 140 |
1933467 | 1933467 | 2021-11-19 | Logan | West Virginia | 54045 | 5594 | 140 |
1930215 | 1930215 | 2021-11-18 | Logan | West Virginia | 54045 | 5572 | 140 |
1926965 | 1926965 | 2021-11-17 | Logan | West Virginia | 54045 | 5558 | 140 |
1923715 | 1923715 | 2021-11-16 | Logan | West Virginia | 54045 | 5544 | 140 |
1920466 | 1920466 | 2021-11-15 | Logan | West Virginia | 54045 | 5532 | 140 |
1917216 | 1917216 | 2021-11-14 | Logan | West Virginia | 54045 | 5525 | 140 |
1913966 | 1913966 | 2021-11-13 | Logan | West Virginia | 54045 | 5519 | 140 |
1910716 | 1910716 | 2021-11-12 | Logan | West Virginia | 54045 | 5502 | 140 |
1907467 | 1907467 | 2021-11-11 | Logan | West Virginia | 54045 | 5482 | 140 |
1904218 | 1904218 | 2021-11-10 | Logan | West Virginia | 54045 | 5467 | 140 |
1900968 | 1900968 | 2021-11-09 | Logan | West Virginia | 54045 | 5452 | 139 |
1897718 | 1897718 | 2021-11-08 | Logan | West Virginia | 54045 | 5445 | 139 |
1894468 | 1894468 | 2021-11-07 | Logan | West Virginia | 54045 | 5444 | 138 |
1891218 | 1891218 | 2021-11-06 | Logan | West Virginia | 54045 | 5435 | 138 |
1887968 | 1887968 | 2021-11-05 | Logan | West Virginia | 54045 | 5424 | 138 |
1884718 | 1884718 | 2021-11-04 | Logan | West Virginia | 54045 | 5406 | 138 |
1881469 | 1881469 | 2021-11-03 | Logan | West Virginia | 54045 | 5396 | 138 |
1878220 | 1878220 | 2021-11-02 | Logan | West Virginia | 54045 | 5380 | 138 |
1874971 | 1874971 | 2021-11-01 | Logan | West Virginia | 54045 | 5365 | 136 |
1871722 | 1871722 | 2021-10-31 | Logan | West Virginia | 54045 | 5358 | 136 |
1868473 | 1868473 | 2021-10-30 | Logan | West Virginia | 54045 | 5353 | 136 |
1865224 | 1865224 | 2021-10-29 | Logan | West Virginia | 54045 | 5336 | 136 |
1861975 | 1861975 | 2021-10-28 | Logan | West Virginia | 54045 | 5326 | 136 |
1858726 | 1858726 | 2021-10-27 | Logan | West Virginia | 54045 | 5307 | 135 |
1855477 | 1855477 | 2021-10-26 | Logan | West Virginia | 54045 | 5295 | 135 |
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);