ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
738 rows where county = "Clay" 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 |
---|---|---|---|---|---|---|---|
2177304 | 2177304 | 2022-02-02 | Clay | West Virginia | 54015 | 2119 | 31 |
2174051 | 2174051 | 2022-02-01 | Clay | West Virginia | 54015 | 2105 | 31 |
2170799 | 2170799 | 2022-01-31 | Clay | West Virginia | 54015 | 2099 | 31 |
2167546 | 2167546 | 2022-01-30 | Clay | West Virginia | 54015 | 2089 | 31 |
2164291 | 2164291 | 2022-01-29 | Clay | West Virginia | 54015 | 2081 | 31 |
2161036 | 2161036 | 2022-01-28 | Clay | West Virginia | 54015 | 2072 | 31 |
2157780 | 2157780 | 2022-01-27 | Clay | West Virginia | 54015 | 2043 | 31 |
2154527 | 2154527 | 2022-01-26 | Clay | West Virginia | 54015 | 2021 | 30 |
2151274 | 2151274 | 2022-01-25 | Clay | West Virginia | 54015 | 2015 | 30 |
2148022 | 2148022 | 2022-01-24 | Clay | West Virginia | 54015 | 2013 | 30 |
2144770 | 2144770 | 2022-01-23 | Clay | West Virginia | 54015 | 2007 | 30 |
2141515 | 2141515 | 2022-01-22 | Clay | West Virginia | 54015 | 1984 | 30 |
2138259 | 2138259 | 2022-01-21 | Clay | West Virginia | 54015 | 1957 | 30 |
2135004 | 2135004 | 2022-01-20 | Clay | West Virginia | 54015 | 1930 | 30 |
2131752 | 2131752 | 2022-01-19 | Clay | West Virginia | 54015 | 1905 | 30 |
2128498 | 2128498 | 2022-01-18 | Clay | West Virginia | 54015 | 1885 | 30 |
2125245 | 2125245 | 2022-01-17 | Clay | West Virginia | 54015 | 1870 | 29 |
2121993 | 2121993 | 2022-01-16 | Clay | West Virginia | 54015 | 1857 | 29 |
2118741 | 2118741 | 2022-01-15 | Clay | West Virginia | 54015 | 1837 | 29 |
2115489 | 2115489 | 2022-01-14 | Clay | West Virginia | 54015 | 1811 | 29 |
2112237 | 2112237 | 2022-01-13 | Clay | West Virginia | 54015 | 1798 | 29 |
2108985 | 2108985 | 2022-01-12 | Clay | West Virginia | 54015 | 1769 | 28 |
2105734 | 2105734 | 2022-01-11 | Clay | West Virginia | 54015 | 1763 | 28 |
2102483 | 2102483 | 2022-01-10 | Clay | West Virginia | 54015 | 1760 | 28 |
2099232 | 2099232 | 2022-01-09 | Clay | West Virginia | 54015 | 1737 | 28 |
2095981 | 2095981 | 2022-01-08 | Clay | West Virginia | 54015 | 1730 | 28 |
2092729 | 2092729 | 2022-01-07 | Clay | West Virginia | 54015 | 1720 | 28 |
2089477 | 2089477 | 2022-01-06 | Clay | West Virginia | 54015 | 1718 | 26 |
2086226 | 2086226 | 2022-01-05 | Clay | West Virginia | 54015 | 1687 | 26 |
2082974 | 2082974 | 2022-01-04 | Clay | West Virginia | 54015 | 1684 | 26 |
2079722 | 2079722 | 2022-01-03 | Clay | West Virginia | 54015 | 1678 | 26 |
2076470 | 2076470 | 2022-01-02 | Clay | West Virginia | 54015 | 1640 | 26 |
2073219 | 2073219 | 2022-01-01 | Clay | West Virginia | 54015 | 1640 | 26 |
2069968 | 2069968 | 2021-12-31 | Clay | West Virginia | 54015 | 1640 | 26 |
2066717 | 2066717 | 2021-12-30 | Clay | West Virginia | 54015 | 1640 | 26 |
2063467 | 2063467 | 2021-12-29 | Clay | West Virginia | 54015 | 1618 | 26 |
2060217 | 2060217 | 2021-12-28 | Clay | West Virginia | 54015 | 1613 | 25 |
2056968 | 2056968 | 2021-12-27 | Clay | West Virginia | 54015 | 1613 | 25 |
2053719 | 2053719 | 2021-12-26 | Clay | West Virginia | 54015 | 1587 | 25 |
2050469 | 2050469 | 2021-12-25 | Clay | West Virginia | 54015 | 1587 | 25 |
2047219 | 2047219 | 2021-12-24 | Clay | West Virginia | 54015 | 1587 | 25 |
2043969 | 2043969 | 2021-12-23 | Clay | West Virginia | 54015 | 1587 | 25 |
2040720 | 2040720 | 2021-12-22 | Clay | West Virginia | 54015 | 1572 | 25 |
2037470 | 2037470 | 2021-12-21 | Clay | West Virginia | 54015 | 1570 | 25 |
2034220 | 2034220 | 2021-12-20 | Clay | West Virginia | 54015 | 1566 | 25 |
2030970 | 2030970 | 2021-12-19 | Clay | West Virginia | 54015 | 1559 | 25 |
2027719 | 2027719 | 2021-12-18 | Clay | West Virginia | 54015 | 1551 | 25 |
2024468 | 2024468 | 2021-12-17 | Clay | West Virginia | 54015 | 1532 | 25 |
2021217 | 2021217 | 2021-12-16 | Clay | West Virginia | 54015 | 1520 | 25 |
2017966 | 2017966 | 2021-12-15 | Clay | West Virginia | 54015 | 1502 | 25 |
2014716 | 2014716 | 2021-12-14 | Clay | West Virginia | 54015 | 1494 | 25 |
2011465 | 2011465 | 2021-12-13 | Clay | West Virginia | 54015 | 1487 | 25 |
2008214 | 2008214 | 2021-12-12 | Clay | West Virginia | 54015 | 1476 | 24 |
2004963 | 2004963 | 2021-12-11 | Clay | West Virginia | 54015 | 1461 | 24 |
2001712 | 2001712 | 2021-12-10 | Clay | West Virginia | 54015 | 1449 | 24 |
1998462 | 1998462 | 2021-12-09 | Clay | West Virginia | 54015 | 1441 | 24 |
1995211 | 1995211 | 2021-12-08 | Clay | West Virginia | 54015 | 1426 | 24 |
1991960 | 1991960 | 2021-12-07 | Clay | West Virginia | 54015 | 1427 | 24 |
1988709 | 1988709 | 2021-12-06 | Clay | West Virginia | 54015 | 1427 | 23 |
1985459 | 1985459 | 2021-12-05 | Clay | West Virginia | 54015 | 1422 | 23 |
1982209 | 1982209 | 2021-12-04 | Clay | West Virginia | 54015 | 1419 | 23 |
1978959 | 1978959 | 2021-12-03 | Clay | West Virginia | 54015 | 1413 | 23 |
1975709 | 1975709 | 2021-12-02 | Clay | West Virginia | 54015 | 1404 | 23 |
1972460 | 1972460 | 2021-12-01 | Clay | West Virginia | 54015 | 1393 | 23 |
1969210 | 1969210 | 2021-11-30 | Clay | West Virginia | 54015 | 1390 | 22 |
1965960 | 1965960 | 2021-11-29 | Clay | West Virginia | 54015 | 1386 | 21 |
1962708 | 1962708 | 2021-11-28 | Clay | West Virginia | 54015 | 1368 | 22 |
1959457 | 1959457 | 2021-11-27 | Clay | West Virginia | 54015 | 1368 | 22 |
1956206 | 1956206 | 2021-11-26 | Clay | West Virginia | 54015 | 1368 | 22 |
1952955 | 1952955 | 2021-11-25 | Clay | West Virginia | 54015 | 1368 | 22 |
1949704 | 1949704 | 2021-11-24 | Clay | West Virginia | 54015 | 1368 | 22 |
1946453 | 1946453 | 2021-11-23 | Clay | West Virginia | 54015 | 1368 | 21 |
1943202 | 1943202 | 2021-11-22 | Clay | West Virginia | 54015 | 1363 | 21 |
1939952 | 1939952 | 2021-11-21 | Clay | West Virginia | 54015 | 1359 | 21 |
1936702 | 1936702 | 2021-11-20 | Clay | West Virginia | 54015 | 1358 | 21 |
1933452 | 1933452 | 2021-11-19 | Clay | West Virginia | 54015 | 1353 | 21 |
1930200 | 1930200 | 2021-11-18 | Clay | West Virginia | 54015 | 1345 | 21 |
1926950 | 1926950 | 2021-11-17 | Clay | West Virginia | 54015 | 1332 | 21 |
1923700 | 1923700 | 2021-11-16 | Clay | West Virginia | 54015 | 1330 | 20 |
1920451 | 1920451 | 2021-11-15 | Clay | West Virginia | 54015 | 1330 | 20 |
1917201 | 1917201 | 2021-11-14 | Clay | West Virginia | 54015 | 1327 | 20 |
1913951 | 1913951 | 2021-11-13 | Clay | West Virginia | 54015 | 1319 | 20 |
1910701 | 1910701 | 2021-11-12 | Clay | West Virginia | 54015 | 1314 | 20 |
1907452 | 1907452 | 2021-11-11 | Clay | West Virginia | 54015 | 1305 | 20 |
1904203 | 1904203 | 2021-11-10 | Clay | West Virginia | 54015 | 1294 | 20 |
1900953 | 1900953 | 2021-11-09 | Clay | West Virginia | 54015 | 1293 | 20 |
1897703 | 1897703 | 2021-11-08 | Clay | West Virginia | 54015 | 1293 | 20 |
1894453 | 1894453 | 2021-11-07 | Clay | West Virginia | 54015 | 1291 | 20 |
1891203 | 1891203 | 2021-11-06 | Clay | West Virginia | 54015 | 1289 | 20 |
1887953 | 1887953 | 2021-11-05 | Clay | West Virginia | 54015 | 1281 | 20 |
1884703 | 1884703 | 2021-11-04 | Clay | West Virginia | 54015 | 1271 | 20 |
1881454 | 1881454 | 2021-11-03 | Clay | West Virginia | 54015 | 1259 | 20 |
1878205 | 1878205 | 2021-11-02 | Clay | West Virginia | 54015 | 1258 | 20 |
1874956 | 1874956 | 2021-11-01 | Clay | West Virginia | 54015 | 1260 | 20 |
1871707 | 1871707 | 2021-10-31 | Clay | West Virginia | 54015 | 1250 | 20 |
1868458 | 1868458 | 2021-10-30 | Clay | West Virginia | 54015 | 1241 | 20 |
1865209 | 1865209 | 2021-10-29 | Clay | West Virginia | 54015 | 1238 | 20 |
1861960 | 1861960 | 2021-10-28 | Clay | West Virginia | 54015 | 1235 | 20 |
1858711 | 1858711 | 2021-10-27 | Clay | West Virginia | 54015 | 1227 | 20 |
1855462 | 1855462 | 2021-10-26 | Clay | West Virginia | 54015 | 1224 | 19 |
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);