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 |
---|---|---|---|---|---|---|---|
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 |
1624809 | 1624809 | 2021-08-16 | Kanawha | West Virginia | 54039 | 16231 | 365 |
1621562 | 1621562 | 2021-08-15 | Kanawha | West Virginia | 54039 | 16046 | 365 |
1618314 | 1618314 | 2021-08-14 | Kanawha | West Virginia | 54039 | 16046 | 365 |
1615066 | 1615066 | 2021-08-13 | Kanawha | West Virginia | 54039 | 16046 | 365 |
1611817 | 1611817 | 2021-08-12 | Kanawha | West Virginia | 54039 | 16004 | 365 |
1608570 | 1608570 | 2021-08-11 | Kanawha | West Virginia | 54039 | 15966 | 365 |
1605321 | 1605321 | 2021-08-10 | Kanawha | West Virginia | 54039 | 15943 | 365 |
1602071 | 1602071 | 2021-08-09 | Kanawha | West Virginia | 54039 | 15918 | 365 |
1598823 | 1598823 | 2021-08-08 | Kanawha | West Virginia | 54039 | 15844 | 366 |
1595574 | 1595574 | 2021-08-07 | Kanawha | West Virginia | 54039 | 15844 | 366 |
1592325 | 1592325 | 2021-08-06 | Kanawha | West Virginia | 54039 | 15844 | 366 |
1589076 | 1589076 | 2021-08-05 | Kanawha | West Virginia | 54039 | 15816 | 365 |
1585827 | 1585827 | 2021-08-04 | Kanawha | West Virginia | 54039 | 15790 | 364 |
1582577 | 1582577 | 2021-08-03 | Kanawha | West Virginia | 54039 | 15770 | 364 |
1579327 | 1579327 | 2021-08-02 | Kanawha | West Virginia | 54039 | 15762 | 363 |
1576079 | 1576079 | 2021-08-01 | Kanawha | West Virginia | 54039 | 15712 | 363 |
1572831 | 1572831 | 2021-07-31 | Kanawha | West Virginia | 54039 | 15712 | 363 |
1569583 | 1569583 | 2021-07-30 | Kanawha | West Virginia | 54039 | 15712 | 363 |
1566335 | 1566335 | 2021-07-29 | Kanawha | West Virginia | 54039 | 15685 | 363 |
1563087 | 1563087 | 2021-07-28 | Kanawha | West Virginia | 54039 | 15663 | 361 |
1559839 | 1559839 | 2021-07-27 | Kanawha | West Virginia | 54039 | 15649 | 361 |
1556592 | 1556592 | 2021-07-26 | Kanawha | West Virginia | 54039 | 15630 | 361 |
1553345 | 1553345 | 2021-07-25 | Kanawha | West Virginia | 54039 | 15594 | 361 |
1550098 | 1550098 | 2021-07-24 | Kanawha | West Virginia | 54039 | 15594 | 361 |
1546851 | 1546851 | 2021-07-23 | Kanawha | West Virginia | 54039 | 15594 | 361 |
1543604 | 1543604 | 2021-07-22 | Kanawha | West Virginia | 54039 | 15586 | 361 |
1540356 | 1540356 | 2021-07-21 | Kanawha | West Virginia | 54039 | 15579 | 361 |
1537109 | 1537109 | 2021-07-20 | Kanawha | West Virginia | 54039 | 15574 | 361 |
1533861 | 1533861 | 2021-07-19 | Kanawha | West Virginia | 54039 | 15569 | 361 |
1530614 | 1530614 | 2021-07-18 | Kanawha | West Virginia | 54039 | 15553 | 361 |
1527367 | 1527367 | 2021-07-17 | Kanawha | West Virginia | 54039 | 15553 | 361 |
1524120 | 1524120 | 2021-07-16 | Kanawha | West Virginia | 54039 | 15553 | 361 |
1520872 | 1520872 | 2021-07-15 | Kanawha | West Virginia | 54039 | 15547 | 361 |
1517624 | 1517624 | 2021-07-14 | Kanawha | West Virginia | 54039 | 15539 | 361 |
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);