ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 54039 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 |
---|---|---|---|---|---|---|---|
2177316 | 2177316 | 2022-02-02 | Kanawha | West Virginia | 54039 | 42877 | 608 |
2174063 | 2174063 | 2022-02-01 | Kanawha | West Virginia | 54039 | 42525 | 601 |
2170811 | 2170811 | 2022-01-31 | Kanawha | West Virginia | 54039 | 42335 | 596 |
2167558 | 2167558 | 2022-01-30 | Kanawha | West Virginia | 54039 | 42146 | 594 |
2164303 | 2164303 | 2022-01-29 | Kanawha | West Virginia | 54039 | 41827 | 594 |
2161048 | 2161048 | 2022-01-28 | Kanawha | West Virginia | 54039 | 41360 | 594 |
2157792 | 2157792 | 2022-01-27 | Kanawha | West Virginia | 54039 | 40847 | 593 |
2154539 | 2154539 | 2022-01-26 | Kanawha | West Virginia | 54039 | 40115 | 593 |
2151286 | 2151286 | 2022-01-25 | Kanawha | West Virginia | 54039 | 39735 | 591 |
2148034 | 2148034 | 2022-01-24 | Kanawha | West Virginia | 54039 | 39489 | 591 |
2144782 | 2144782 | 2022-01-23 | Kanawha | West Virginia | 54039 | 38933 | 590 |
2141527 | 2141527 | 2022-01-22 | Kanawha | West Virginia | 54039 | 38084 | 590 |
2138271 | 2138271 | 2022-01-21 | Kanawha | West Virginia | 54039 | 37121 | 590 |
2135016 | 2135016 | 2022-01-20 | Kanawha | West Virginia | 54039 | 36664 | 586 |
2131764 | 2131764 | 2022-01-19 | Kanawha | West Virginia | 54039 | 36196 | 586 |
2128510 | 2128510 | 2022-01-18 | Kanawha | West Virginia | 54039 | 35906 | 586 |
2125257 | 2125257 | 2022-01-17 | Kanawha | West Virginia | 54039 | 35622 | 586 |
2122005 | 2122005 | 2022-01-16 | Kanawha | West Virginia | 54039 | 35251 | 586 |
2118753 | 2118753 | 2022-01-15 | Kanawha | West Virginia | 54039 | 34754 | 586 |
2115501 | 2115501 | 2022-01-14 | Kanawha | West Virginia | 54039 | 34163 | 586 |
2112249 | 2112249 | 2022-01-13 | Kanawha | West Virginia | 54039 | 33647 | 586 |
2108997 | 2108997 | 2022-01-12 | Kanawha | West Virginia | 54039 | 32930 | 585 |
2105746 | 2105746 | 2022-01-11 | Kanawha | West Virginia | 54039 | 32504 | 585 |
2102495 | 2102495 | 2022-01-10 | Kanawha | West Virginia | 54039 | 32322 | 583 |
2099244 | 2099244 | 2022-01-09 | Kanawha | West Virginia | 54039 | 32105 | 581 |
2095993 | 2095993 | 2022-01-08 | Kanawha | West Virginia | 54039 | 31869 | 581 |
2092741 | 2092741 | 2022-01-07 | Kanawha | West Virginia | 54039 | 31419 | 581 |
2089489 | 2089489 | 2022-01-06 | Kanawha | West Virginia | 54039 | 30921 | 578 |
2086238 | 2086238 | 2022-01-05 | Kanawha | West Virginia | 54039 | 30340 | 577 |
2082986 | 2082986 | 2022-01-04 | Kanawha | West Virginia | 54039 | 30112 | 576 |
2079734 | 2079734 | 2022-01-03 | Kanawha | West Virginia | 54039 | 29919 | 576 |
2076482 | 2076482 | 2022-01-02 | Kanawha | West Virginia | 54039 | 29101 | 573 |
2073231 | 2073231 | 2022-01-01 | Kanawha | West Virginia | 54039 | 29101 | 573 |
2069980 | 2069980 | 2021-12-31 | Kanawha | West Virginia | 54039 | 29101 | 573 |
2066729 | 2066729 | 2021-12-30 | Kanawha | West Virginia | 54039 | 29101 | 573 |
2063479 | 2063479 | 2021-12-29 | Kanawha | West Virginia | 54039 | 28813 | 571 |
2060229 | 2060229 | 2021-12-28 | Kanawha | West Virginia | 54039 | 28661 | 568 |
2056980 | 2056980 | 2021-12-27 | Kanawha | West Virginia | 54039 | 28570 | 567 |
2053731 | 2053731 | 2021-12-26 | Kanawha | West Virginia | 54039 | 28292 | 566 |
2050481 | 2050481 | 2021-12-25 | Kanawha | West Virginia | 54039 | 28292 | 566 |
2047231 | 2047231 | 2021-12-24 | Kanawha | West Virginia | 54039 | 28292 | 566 |
2043981 | 2043981 | 2021-12-23 | Kanawha | West Virginia | 54039 | 28292 | 566 |
2040732 | 2040732 | 2021-12-22 | Kanawha | West Virginia | 54039 | 28193 | 566 |
2037482 | 2037482 | 2021-12-21 | Kanawha | West Virginia | 54039 | 28133 | 563 |
2034232 | 2034232 | 2021-12-20 | Kanawha | West Virginia | 54039 | 28093 | 563 |
2030982 | 2030982 | 2021-12-19 | Kanawha | West Virginia | 54039 | 28034 | 561 |
2027731 | 2027731 | 2021-12-18 | Kanawha | West Virginia | 54039 | 27963 | 561 |
2024480 | 2024480 | 2021-12-17 | Kanawha | West Virginia | 54039 | 27880 | 561 |
2021229 | 2021229 | 2021-12-16 | Kanawha | West Virginia | 54039 | 27793 | 561 |
2017978 | 2017978 | 2021-12-15 | Kanawha | West Virginia | 54039 | 27719 | 561 |
2014728 | 2014728 | 2021-12-14 | Kanawha | West Virginia | 54039 | 27634 | 559 |
2011477 | 2011477 | 2021-12-13 | Kanawha | West Virginia | 54039 | 27584 | 559 |
2008226 | 2008226 | 2021-12-12 | Kanawha | West Virginia | 54039 | 27529 | 559 |
2004975 | 2004975 | 2021-12-11 | Kanawha | West Virginia | 54039 | 27442 | 559 |
2001724 | 2001724 | 2021-12-10 | Kanawha | West Virginia | 54039 | 27361 | 559 |
1998474 | 1998474 | 2021-12-09 | Kanawha | West Virginia | 54039 | 27294 | 556 |
1995223 | 1995223 | 2021-12-08 | Kanawha | West Virginia | 54039 | 27206 | 555 |
1991972 | 1991972 | 2021-12-07 | Kanawha | West Virginia | 54039 | 27124 | 554 |
1988721 | 1988721 | 2021-12-06 | Kanawha | West Virginia | 54039 | 27074 | 551 |
1985471 | 1985471 | 2021-12-05 | Kanawha | West Virginia | 54039 | 27019 | 549 |
1982221 | 1982221 | 2021-12-04 | Kanawha | West Virginia | 54039 | 26963 | 549 |
1978971 | 1978971 | 2021-12-03 | Kanawha | West Virginia | 54039 | 26878 | 549 |
1975721 | 1975721 | 2021-12-02 | Kanawha | West Virginia | 54039 | 26808 | 547 |
1972472 | 1972472 | 2021-12-01 | Kanawha | West Virginia | 54039 | 26653 | 539 |
1969222 | 1969222 | 2021-11-30 | Kanawha | West Virginia | 54039 | 26576 | 538 |
1965972 | 1965972 | 2021-11-29 | Kanawha | West Virginia | 54039 | 26514 | 534 |
1962720 | 1962720 | 2021-11-28 | Kanawha | West Virginia | 54039 | 26320 | 531 |
1959469 | 1959469 | 2021-11-27 | Kanawha | West Virginia | 54039 | 26320 | 531 |
1956218 | 1956218 | 2021-11-26 | Kanawha | West Virginia | 54039 | 26320 | 531 |
1952967 | 1952967 | 2021-11-25 | Kanawha | West Virginia | 54039 | 26320 | 531 |
1949716 | 1949716 | 2021-11-24 | Kanawha | West Virginia | 54039 | 26320 | 531 |
1946465 | 1946465 | 2021-11-23 | Kanawha | West Virginia | 54039 | 26243 | 524 |
1943214 | 1943214 | 2021-11-22 | Kanawha | West Virginia | 54039 | 26251 | 523 |
1939964 | 1939964 | 2021-11-21 | Kanawha | West Virginia | 54039 | 26209 | 522 |
1936714 | 1936714 | 2021-11-20 | Kanawha | West Virginia | 54039 | 26150 | 522 |
1933464 | 1933464 | 2021-11-19 | Kanawha | West Virginia | 54039 | 26405 | 522 |
1930212 | 1930212 | 2021-11-18 | Kanawha | West Virginia | 54039 | 26003 | 522 |
1926962 | 1926962 | 2021-11-17 | Kanawha | West Virginia | 54039 | 25928 | 520 |
1923712 | 1923712 | 2021-11-16 | Kanawha | West Virginia | 54039 | 25866 | 517 |
1920463 | 1920463 | 2021-11-15 | Kanawha | West Virginia | 54039 | 25824 | 513 |
1917213 | 1917213 | 2021-11-14 | Kanawha | West Virginia | 54039 | 25777 | 507 |
1913963 | 1913963 | 2021-11-13 | Kanawha | West Virginia | 54039 | 25724 | 507 |
1910713 | 1910713 | 2021-11-12 | Kanawha | West Virginia | 54039 | 25995 | 507 |
1907464 | 1907464 | 2021-11-11 | Kanawha | West Virginia | 54039 | 25586 | 507 |
1904215 | 1904215 | 2021-11-10 | Kanawha | West Virginia | 54039 | 25503 | 504 |
1900965 | 1900965 | 2021-11-09 | Kanawha | West Virginia | 54039 | 25447 | 499 |
1897715 | 1897715 | 2021-11-08 | Kanawha | West Virginia | 54039 | 25405 | 496 |
1894465 | 1894465 | 2021-11-07 | Kanawha | West Virginia | 54039 | 25376 | 492 |
1891215 | 1891215 | 2021-11-06 | Kanawha | West Virginia | 54039 | 25292 | 492 |
1887965 | 1887965 | 2021-11-05 | Kanawha | West Virginia | 54039 | 25229 | 492 |
1884715 | 1884715 | 2021-11-04 | Kanawha | West Virginia | 54039 | 25153 | 491 |
1881466 | 1881466 | 2021-11-03 | Kanawha | West Virginia | 54039 | 25078 | 489 |
1878217 | 1878217 | 2021-11-02 | Kanawha | West Virginia | 54039 | 24989 | 486 |
1874968 | 1874968 | 2021-11-01 | Kanawha | West Virginia | 54039 | 24952 | 486 |
1871719 | 1871719 | 2021-10-31 | Kanawha | West Virginia | 54039 | 24901 | 484 |
1868470 | 1868470 | 2021-10-30 | Kanawha | West Virginia | 54039 | 24809 | 484 |
1865221 | 1865221 | 2021-10-29 | Kanawha | West Virginia | 54039 | 24720 | 484 |
1861972 | 1861972 | 2021-10-28 | Kanawha | West Virginia | 54039 | 24666 | 482 |
1858723 | 1858723 | 2021-10-27 | Kanawha | West Virginia | 54039 | 24578 | 478 |
1855474 | 1855474 | 2021-10-26 | Kanawha | West Virginia | 54039 | 24483 | 475 |
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);