ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Kanawha" 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 |
---|---|---|---|---|---|---|---|
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 |
1852225 | 1852225 | 2021-10-25 | Kanawha | West Virginia | 54039 | 24417 | 469 |
1848975 | 1848975 | 2021-10-24 | Kanawha | West Virginia | 54039 | 24304 | 467 |
1845725 | 1845725 | 2021-10-23 | Kanawha | West Virginia | 54039 | 24264 | 467 |
1842475 | 1842475 | 2021-10-22 | Kanawha | West Virginia | 54039 | 24182 | 467 |
1839226 | 1839226 | 2021-10-21 | Kanawha | West Virginia | 54039 | 24103 | 464 |
1835977 | 1835977 | 2021-10-20 | Kanawha | West Virginia | 54039 | 23989 | 459 |
1832728 | 1832728 | 2021-10-19 | Kanawha | West Virginia | 54039 | 23912 | 454 |
1829479 | 1829479 | 2021-10-18 | Kanawha | West Virginia | 54039 | 23859 | 449 |
1826230 | 1826230 | 2021-10-17 | Kanawha | West Virginia | 54039 | 23800 | 449 |
1822981 | 1822981 | 2021-10-16 | Kanawha | West Virginia | 54039 | 23683 | 449 |
1819732 | 1819732 | 2021-10-15 | Kanawha | West Virginia | 54039 | 23560 | 449 |
1816483 | 1816483 | 2021-10-14 | Kanawha | West Virginia | 54039 | 23414 | 444 |
1813235 | 1813235 | 2021-10-13 | Kanawha | West Virginia | 54039 | 23296 | 438 |
1809986 | 1809986 | 2021-10-12 | Kanawha | West Virginia | 54039 | 23204 | 438 |
1806737 | 1806737 | 2021-10-11 | Kanawha | West Virginia | 54039 | 23137 | 437 |
1803486 | 1803486 | 2021-10-10 | Kanawha | West Virginia | 54039 | 23073 | 436 |
1800237 | 1800237 | 2021-10-09 | Kanawha | West Virginia | 54039 | 22940 | 436 |
1796988 | 1796988 | 2021-10-08 | Kanawha | West Virginia | 54039 | 22851 | 436 |
1793739 | 1793739 | 2021-10-07 | Kanawha | West Virginia | 54039 | 22738 | 431 |
1790490 | 1790490 | 2021-10-06 | Kanawha | West Virginia | 54039 | 22613 | 429 |
1787242 | 1787242 | 2021-10-05 | Kanawha | West Virginia | 54039 | 22477 | 428 |
1783993 | 1783993 | 2021-10-04 | Kanawha | West Virginia | 54039 | 22402 | 428 |
1780744 | 1780744 | 2021-10-03 | Kanawha | West Virginia | 54039 | 22297 | 425 |
1777494 | 1777494 | 2021-10-02 | Kanawha | West Virginia | 54039 | 22222 | 425 |
1774244 | 1774244 | 2021-10-01 | Kanawha | West Virginia | 54039 | 22057 | 425 |
1770994 | 1770994 | 2021-09-30 | Kanawha | West Virginia | 54039 | 21912 | 423 |
1767745 | 1767745 | 2021-09-29 | Kanawha | West Virginia | 54039 | 21775 | 422 |
1764496 | 1764496 | 2021-09-28 | Kanawha | West Virginia | 54039 | 21604 | 417 |
1761247 | 1761247 | 2021-09-27 | Kanawha | West Virginia | 54039 | 21536 | 415 |
1757999 | 1757999 | 2021-09-26 | Kanawha | West Virginia | 54039 | 21464 | 409 |
1754751 | 1754751 | 2021-09-25 | Kanawha | West Virginia | 54039 | 21357 | 409 |
1751503 | 1751503 | 2021-09-24 | Kanawha | West Virginia | 54039 | 21182 | 409 |
1748254 | 1748254 | 2021-09-23 | Kanawha | West Virginia | 54039 | 20988 | 410 |
1745004 | 1745004 | 2021-09-22 | Kanawha | West Virginia | 54039 | 20905 | 410 |
1741755 | 1741755 | 2021-09-21 | Kanawha | West Virginia | 54039 | 20755 | 410 |
1738506 | 1738506 | 2021-09-20 | Kanawha | West Virginia | 54039 | 20673 | 408 |
1735257 | 1735257 | 2021-09-19 | Kanawha | West Virginia | 54039 | 20590 | 402 |
1732007 | 1732007 | 2021-09-18 | Kanawha | West Virginia | 54039 | 20497 | 402 |
1728757 | 1728757 | 2021-09-17 | Kanawha | West Virginia | 54039 | 20333 | 402 |
1725507 | 1725507 | 2021-09-16 | Kanawha | West Virginia | 54039 | 20112 | 396 |
1722258 | 1722258 | 2021-09-15 | Kanawha | West Virginia | 54039 | 19943 | 392 |
1719010 | 1719010 | 2021-09-14 | Kanawha | West Virginia | 54039 | 19817 | 388 |
1715762 | 1715762 | 2021-09-13 | Kanawha | West Virginia | 54039 | 19729 | 388 |
1712516 | 1712516 | 2021-09-12 | Kanawha | West Virginia | 54039 | 19612 | 384 |
1709269 | 1709269 | 2021-09-11 | Kanawha | West Virginia | 54039 | 19426 | 384 |
1706022 | 1706022 | 2021-09-10 | Kanawha | West Virginia | 54039 | 19268 | 384 |
1702772 | 1702772 | 2021-09-09 | Kanawha | West Virginia | 54039 | 19032 | 382 |
1699523 | 1699523 | 2021-09-08 | Kanawha | West Virginia | 54039 | 18946 | 380 |
1696275 | 1696275 | 2021-09-07 | Kanawha | West Virginia | 54039 | 18848 | 378 |
1693027 | 1693027 | 2021-09-06 | Kanawha | West Virginia | 54039 | 18793 | 377 |
1689778 | 1689778 | 2021-09-05 | Kanawha | West Virginia | 54039 | 18649 | 375 |
1686528 | 1686528 | 2021-09-04 | Kanawha | West Virginia | 54039 | 18523 | 375 |
1683277 | 1683277 | 2021-09-03 | Kanawha | West Virginia | 54039 | 18323 | 374 |
1680027 | 1680027 | 2021-09-02 | Kanawha | West Virginia | 54039 | 18181 | 375 |
1676779 | 1676779 | 2021-09-01 | Kanawha | West Virginia | 54039 | 18006 | 374 |
1673532 | 1673532 | 2021-08-31 | Kanawha | West Virginia | 54039 | 17898 | 373 |
1670284 | 1670284 | 2021-08-30 | Kanawha | West Virginia | 54039 | 17784 | 373 |
1667037 | 1667037 | 2021-08-29 | Kanawha | West Virginia | 54039 | 17682 | 372 |
1663789 | 1663789 | 2021-08-28 | Kanawha | West Virginia | 54039 | 17365 | 372 |
1660541 | 1660541 | 2021-08-27 | Kanawha | West Virginia | 54039 | 17365 | 372 |
1657293 | 1657293 | 2021-08-26 | Kanawha | West Virginia | 54039 | 17231 | 370 |
1654045 | 1654045 | 2021-08-25 | Kanawha | West Virginia | 54039 | 17035 | 370 |
1650799 | 1650799 | 2021-08-24 | Kanawha | West Virginia | 54039 | 16953 | 367 |
1647550 | 1647550 | 2021-08-23 | Kanawha | West Virginia | 54039 | 16873 | 367 |
1644301 | 1644301 | 2021-08-22 | Kanawha | West Virginia | 54039 | 16558 | 367 |
1641051 | 1641051 | 2021-08-21 | Kanawha | West Virginia | 54039 | 16558 | 367 |
1637801 | 1637801 | 2021-08-20 | Kanawha | West Virginia | 54039 | 16558 | 367 |
1634551 | 1634551 | 2021-08-19 | Kanawha | West Virginia | 54039 | 16455 | 367 |
1631303 | 1631303 | 2021-08-18 | Kanawha | West Virginia | 54039 | 16350 | 367 |
1628056 | 1628056 | 2021-08-17 | Kanawha | West Virginia | 54039 | 16294 | 367 |
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);