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 |
---|---|---|---|---|---|---|---|
1829467 | 1829467 | 2021-10-18 | Clay | West Virginia | 54015 | 1187 | 17 |
1826218 | 1826218 | 2021-10-17 | Clay | West Virginia | 54015 | 1181 | 17 |
1822969 | 1822969 | 2021-10-16 | Clay | West Virginia | 54015 | 1174 | 17 |
1819720 | 1819720 | 2021-10-15 | Clay | West Virginia | 54015 | 1161 | 17 |
1816471 | 1816471 | 2021-10-14 | Clay | West Virginia | 54015 | 1148 | 17 |
1813223 | 1813223 | 2021-10-13 | Clay | West Virginia | 54015 | 1127 | 17 |
1809974 | 1809974 | 2021-10-12 | Clay | West Virginia | 54015 | 1125 | 17 |
1806725 | 1806725 | 2021-10-11 | Clay | West Virginia | 54015 | 1123 | 17 |
1803474 | 1803474 | 2021-10-10 | Clay | West Virginia | 54015 | 1119 | 17 |
1800225 | 1800225 | 2021-10-09 | Clay | West Virginia | 54015 | 1111 | 17 |
1796976 | 1796976 | 2021-10-08 | Clay | West Virginia | 54015 | 1108 | 17 |
1793727 | 1793727 | 2021-10-07 | Clay | West Virginia | 54015 | 1098 | 17 |
1790478 | 1790478 | 2021-10-06 | Clay | West Virginia | 54015 | 1082 | 17 |
1787230 | 1787230 | 2021-10-05 | Clay | West Virginia | 54015 | 1077 | 17 |
1783981 | 1783981 | 2021-10-04 | Clay | West Virginia | 54015 | 1077 | 17 |
1780732 | 1780732 | 2021-10-03 | Clay | West Virginia | 54015 | 1069 | 16 |
1777482 | 1777482 | 2021-10-02 | Clay | West Virginia | 54015 | 1057 | 16 |
1774232 | 1774232 | 2021-10-01 | Clay | West Virginia | 54015 | 1055 | 16 |
1770982 | 1770982 | 2021-09-30 | Clay | West Virginia | 54015 | 1049 | 16 |
1767733 | 1767733 | 2021-09-29 | Clay | West Virginia | 54015 | 1043 | 16 |
1764484 | 1764484 | 2021-09-28 | Clay | West Virginia | 54015 | 1042 | 13 |
1761235 | 1761235 | 2021-09-27 | Clay | West Virginia | 54015 | 1040 | 13 |
1757987 | 1757987 | 2021-09-26 | Clay | West Virginia | 54015 | 1026 | 13 |
1754739 | 1754739 | 2021-09-25 | Clay | West Virginia | 54015 | 1019 | 13 |
1751491 | 1751491 | 2021-09-24 | Clay | West Virginia | 54015 | 1017 | 13 |
1748242 | 1748242 | 2021-09-23 | Clay | West Virginia | 54015 | 1009 | 13 |
1744992 | 1744992 | 2021-09-22 | Clay | West Virginia | 54015 | 997 | 13 |
1741743 | 1741743 | 2021-09-21 | Clay | West Virginia | 54015 | 998 | 13 |
1738494 | 1738494 | 2021-09-20 | Clay | West Virginia | 54015 | 991 | 13 |
1735245 | 1735245 | 2021-09-19 | Clay | West Virginia | 54015 | 981 | 13 |
1731995 | 1731995 | 2021-09-18 | Clay | West Virginia | 54015 | 978 | 13 |
1728745 | 1728745 | 2021-09-17 | Clay | West Virginia | 54015 | 967 | 13 |
1725495 | 1725495 | 2021-09-16 | Clay | West Virginia | 54015 | 953 | 12 |
1722246 | 1722246 | 2021-09-15 | Clay | West Virginia | 54015 | 946 | 12 |
1718998 | 1718998 | 2021-09-14 | Clay | West Virginia | 54015 | 934 | 12 |
1715750 | 1715750 | 2021-09-13 | Clay | West Virginia | 54015 | 917 | 12 |
1712504 | 1712504 | 2021-09-12 | Clay | West Virginia | 54015 | 903 | 12 |
1709257 | 1709257 | 2021-09-11 | Clay | West Virginia | 54015 | 890 | 12 |
1706010 | 1706010 | 2021-09-10 | Clay | West Virginia | 54015 | 851 | 12 |
1702760 | 1702760 | 2021-09-09 | Clay | West Virginia | 54015 | 849 | 12 |
1699511 | 1699511 | 2021-09-08 | Clay | West Virginia | 54015 | 828 | 12 |
1696263 | 1696263 | 2021-09-07 | Clay | West Virginia | 54015 | 813 | 11 |
1693015 | 1693015 | 2021-09-06 | Clay | West Virginia | 54015 | 803 | 11 |
1689766 | 1689766 | 2021-09-05 | Clay | West Virginia | 54015 | 792 | 11 |
1686516 | 1686516 | 2021-09-04 | Clay | West Virginia | 54015 | 774 | 11 |
1683265 | 1683265 | 2021-09-03 | Clay | West Virginia | 54015 | 763 | 11 |
1680015 | 1680015 | 2021-09-02 | Clay | West Virginia | 54015 | 737 | 11 |
1676767 | 1676767 | 2021-09-01 | Clay | West Virginia | 54015 | 714 | 11 |
1673520 | 1673520 | 2021-08-31 | Clay | West Virginia | 54015 | 702 | 11 |
1670272 | 1670272 | 2021-08-30 | Clay | West Virginia | 54015 | 693 | 11 |
1667025 | 1667025 | 2021-08-29 | Clay | West Virginia | 54015 | 677 | 11 |
1663777 | 1663777 | 2021-08-28 | Clay | West Virginia | 54015 | 649 | 11 |
1660529 | 1660529 | 2021-08-27 | Clay | West Virginia | 54015 | 649 | 11 |
1657281 | 1657281 | 2021-08-26 | Clay | West Virginia | 54015 | 641 | 11 |
1654033 | 1654033 | 2021-08-25 | Clay | West Virginia | 54015 | 632 | 11 |
1650787 | 1650787 | 2021-08-24 | Clay | West Virginia | 54015 | 622 | 11 |
1647538 | 1647538 | 2021-08-23 | Clay | West Virginia | 54015 | 619 | 11 |
1644289 | 1644289 | 2021-08-22 | Clay | West Virginia | 54015 | 602 | 11 |
1641039 | 1641039 | 2021-08-21 | Clay | West Virginia | 54015 | 602 | 11 |
1637789 | 1637789 | 2021-08-20 | Clay | West Virginia | 54015 | 602 | 11 |
1634539 | 1634539 | 2021-08-19 | Clay | West Virginia | 54015 | 597 | 11 |
1631291 | 1631291 | 2021-08-18 | Clay | West Virginia | 54015 | 594 | 11 |
1628044 | 1628044 | 2021-08-17 | Clay | West Virginia | 54015 | 591 | 11 |
1624797 | 1624797 | 2021-08-16 | Clay | West Virginia | 54015 | 579 | 11 |
1621550 | 1621550 | 2021-08-15 | Clay | West Virginia | 54015 | 568 | 11 |
1618302 | 1618302 | 2021-08-14 | Clay | West Virginia | 54015 | 568 | 11 |
1615054 | 1615054 | 2021-08-13 | Clay | West Virginia | 54015 | 568 | 11 |
1611805 | 1611805 | 2021-08-12 | Clay | West Virginia | 54015 | 562 | 11 |
1608558 | 1608558 | 2021-08-11 | Clay | West Virginia | 54015 | 560 | 11 |
1605309 | 1605309 | 2021-08-10 | Clay | West Virginia | 54015 | 558 | 11 |
1602059 | 1602059 | 2021-08-09 | Clay | West Virginia | 54015 | 555 | 11 |
1598811 | 1598811 | 2021-08-08 | Clay | West Virginia | 54015 | 551 | 11 |
1595562 | 1595562 | 2021-08-07 | Clay | West Virginia | 54015 | 551 | 11 |
1592313 | 1592313 | 2021-08-06 | Clay | West Virginia | 54015 | 551 | 11 |
1589064 | 1589064 | 2021-08-05 | Clay | West Virginia | 54015 | 549 | 11 |
1585815 | 1585815 | 2021-08-04 | Clay | West Virginia | 54015 | 547 | 11 |
1582565 | 1582565 | 2021-08-03 | Clay | West Virginia | 54015 | 548 | 11 |
1579315 | 1579315 | 2021-08-02 | Clay | West Virginia | 54015 | 548 | 11 |
1576067 | 1576067 | 2021-08-01 | Clay | West Virginia | 54015 | 548 | 11 |
1572819 | 1572819 | 2021-07-31 | Clay | West Virginia | 54015 | 548 | 11 |
1569571 | 1569571 | 2021-07-30 | Clay | West Virginia | 54015 | 548 | 11 |
1566323 | 1566323 | 2021-07-29 | Clay | West Virginia | 54015 | 546 | 11 |
1563075 | 1563075 | 2021-07-28 | Clay | West Virginia | 54015 | 544 | 11 |
1559827 | 1559827 | 2021-07-27 | Clay | West Virginia | 54015 | 544 | 11 |
1556580 | 1556580 | 2021-07-26 | Clay | West Virginia | 54015 | 546 | 11 |
1553333 | 1553333 | 2021-07-25 | Clay | West Virginia | 54015 | 544 | 11 |
1550086 | 1550086 | 2021-07-24 | Clay | West Virginia | 54015 | 544 | 11 |
1546839 | 1546839 | 2021-07-23 | Clay | West Virginia | 54015 | 544 | 11 |
1543592 | 1543592 | 2021-07-22 | Clay | West Virginia | 54015 | 544 | 11 |
1540344 | 1540344 | 2021-07-21 | Clay | West Virginia | 54015 | 544 | 11 |
1537097 | 1537097 | 2021-07-20 | Clay | West Virginia | 54015 | 544 | 11 |
1533849 | 1533849 | 2021-07-19 | Clay | West Virginia | 54015 | 544 | 11 |
1530602 | 1530602 | 2021-07-18 | Clay | West Virginia | 54015 | 543 | 11 |
1527355 | 1527355 | 2021-07-17 | Clay | West Virginia | 54015 | 543 | 11 |
1524108 | 1524108 | 2021-07-16 | Clay | West Virginia | 54015 | 543 | 11 |
1520860 | 1520860 | 2021-07-15 | Clay | West Virginia | 54015 | 544 | 11 |
1517612 | 1517612 | 2021-07-14 | Clay | West Virginia | 54015 | 544 | 11 |
1514365 | 1514365 | 2021-07-13 | Clay | West Virginia | 54015 | 543 | 11 |
1511119 | 1511119 | 2021-07-12 | Clay | West Virginia | 54015 | 543 | 11 |
1507872 | 1507872 | 2021-07-11 | Clay | West Virginia | 54015 | 543 | 11 |
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);