ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Raleigh" 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 |
---|---|---|---|---|---|---|---|
1839247 | 1839247 | 2021-10-21 | Raleigh | West Virginia | 54081 | 11123 | 167 |
1835998 | 1835998 | 2021-10-20 | Raleigh | West Virginia | 54081 | 11086 | 166 |
1832749 | 1832749 | 2021-10-19 | Raleigh | West Virginia | 54081 | 11022 | 165 |
1829500 | 1829500 | 2021-10-18 | Raleigh | West Virginia | 54081 | 10986 | 165 |
1826251 | 1826251 | 2021-10-17 | Raleigh | West Virginia | 54081 | 10949 | 165 |
1823002 | 1823002 | 2021-10-16 | Raleigh | West Virginia | 54081 | 10925 | 165 |
1819753 | 1819753 | 2021-10-15 | Raleigh | West Virginia | 54081 | 10883 | 166 |
1816504 | 1816504 | 2021-10-14 | Raleigh | West Virginia | 54081 | 10829 | 159 |
1813256 | 1813256 | 2021-10-13 | Raleigh | West Virginia | 54081 | 10769 | 158 |
1810007 | 1810007 | 2021-10-12 | Raleigh | West Virginia | 54081 | 10719 | 158 |
1806758 | 1806758 | 2021-10-11 | Raleigh | West Virginia | 54081 | 10687 | 158 |
1803507 | 1803507 | 2021-10-10 | Raleigh | West Virginia | 54081 | 10658 | 156 |
1800258 | 1800258 | 2021-10-09 | Raleigh | West Virginia | 54081 | 10641 | 156 |
1797009 | 1797009 | 2021-10-08 | Raleigh | West Virginia | 54081 | 10583 | 156 |
1793760 | 1793760 | 2021-10-07 | Raleigh | West Virginia | 54081 | 10546 | 152 |
1790511 | 1790511 | 2021-10-06 | Raleigh | West Virginia | 54081 | 10484 | 148 |
1787263 | 1787263 | 2021-10-05 | Raleigh | West Virginia | 54081 | 10422 | 143 |
1784014 | 1784014 | 2021-10-04 | Raleigh | West Virginia | 54081 | 10387 | 142 |
1780765 | 1780765 | 2021-10-03 | Raleigh | West Virginia | 54081 | 10372 | 139 |
1777515 | 1777515 | 2021-10-02 | Raleigh | West Virginia | 54081 | 10337 | 139 |
1774265 | 1774265 | 2021-10-01 | Raleigh | West Virginia | 54081 | 10296 | 139 |
1771015 | 1771015 | 2021-09-30 | Raleigh | West Virginia | 54081 | 10251 | 137 |
1767766 | 1767766 | 2021-09-29 | Raleigh | West Virginia | 54081 | 10200 | 136 |
1764517 | 1764517 | 2021-09-28 | Raleigh | West Virginia | 54081 | 10148 | 134 |
1761268 | 1761268 | 2021-09-27 | Raleigh | West Virginia | 54081 | 10116 | 134 |
1758020 | 1758020 | 2021-09-26 | Raleigh | West Virginia | 54081 | 10068 | 132 |
1754772 | 1754772 | 2021-09-25 | Raleigh | West Virginia | 54081 | 10022 | 132 |
1751524 | 1751524 | 2021-09-24 | Raleigh | West Virginia | 54081 | 9955 | 132 |
1748275 | 1748275 | 2021-09-23 | Raleigh | West Virginia | 54081 | 9870 | 131 |
1745025 | 1745025 | 2021-09-22 | Raleigh | West Virginia | 54081 | 9776 | 131 |
1741776 | 1741776 | 2021-09-21 | Raleigh | West Virginia | 54081 | 9698 | 130 |
1738527 | 1738527 | 2021-09-20 | Raleigh | West Virginia | 54081 | 9647 | 127 |
1735278 | 1735278 | 2021-09-19 | Raleigh | West Virginia | 54081 | 9605 | 124 |
1732028 | 1732028 | 2021-09-18 | Raleigh | West Virginia | 54081 | 9545 | 124 |
1728778 | 1728778 | 2021-09-17 | Raleigh | West Virginia | 54081 | 9474 | 123 |
1725528 | 1725528 | 2021-09-16 | Raleigh | West Virginia | 54081 | 9388 | 122 |
1722279 | 1722279 | 2021-09-15 | Raleigh | West Virginia | 54081 | 9297 | 120 |
1719031 | 1719031 | 2021-09-14 | Raleigh | West Virginia | 54081 | 9212 | 118 |
1715783 | 1715783 | 2021-09-13 | Raleigh | West Virginia | 54081 | 9156 | 118 |
1712537 | 1712537 | 2021-09-12 | Raleigh | West Virginia | 54081 | 9121 | 117 |
1709290 | 1709290 | 2021-09-11 | Raleigh | West Virginia | 54081 | 9036 | 117 |
1706043 | 1706043 | 2021-09-10 | Raleigh | West Virginia | 54081 | 8919 | 117 |
1702793 | 1702793 | 2021-09-09 | Raleigh | West Virginia | 54081 | 8819 | 114 |
1699544 | 1699544 | 2021-09-08 | Raleigh | West Virginia | 54081 | 8740 | 114 |
1696296 | 1696296 | 2021-09-07 | Raleigh | West Virginia | 54081 | 8681 | 113 |
1693048 | 1693048 | 2021-09-06 | Raleigh | West Virginia | 54081 | 8629 | 113 |
1689799 | 1689799 | 2021-09-05 | Raleigh | West Virginia | 54081 | 8560 | 111 |
1686549 | 1686549 | 2021-09-04 | Raleigh | West Virginia | 54081 | 8495 | 111 |
1683298 | 1683298 | 2021-09-03 | Raleigh | West Virginia | 54081 | 8432 | 111 |
1680048 | 1680048 | 2021-09-02 | Raleigh | West Virginia | 54081 | 8328 | 111 |
1676800 | 1676800 | 2021-09-01 | Raleigh | West Virginia | 54081 | 8249 | 111 |
1673553 | 1673553 | 2021-08-31 | Raleigh | West Virginia | 54081 | 8193 | 111 |
1670305 | 1670305 | 2021-08-30 | Raleigh | West Virginia | 54081 | 8141 | 111 |
1667058 | 1667058 | 2021-08-29 | Raleigh | West Virginia | 54081 | 8088 | 111 |
1663810 | 1663810 | 2021-08-28 | Raleigh | West Virginia | 54081 | 8008 | 110 |
1660562 | 1660562 | 2021-08-27 | Raleigh | West Virginia | 54081 | 8008 | 110 |
1657314 | 1657314 | 2021-08-26 | Raleigh | West Virginia | 54081 | 7949 | 110 |
1654066 | 1654066 | 2021-08-25 | Raleigh | West Virginia | 54081 | 7874 | 108 |
1650820 | 1650820 | 2021-08-24 | Raleigh | West Virginia | 54081 | 7817 | 107 |
1647571 | 1647571 | 2021-08-23 | Raleigh | West Virginia | 54081 | 7783 | 107 |
1644322 | 1644322 | 2021-08-22 | Raleigh | West Virginia | 54081 | 7668 | 106 |
1641072 | 1641072 | 2021-08-21 | Raleigh | West Virginia | 54081 | 7668 | 106 |
1637822 | 1637822 | 2021-08-20 | Raleigh | West Virginia | 54081 | 7668 | 106 |
1634572 | 1634572 | 2021-08-19 | Raleigh | West Virginia | 54081 | 7620 | 106 |
1631324 | 1631324 | 2021-08-18 | Raleigh | West Virginia | 54081 | 7563 | 106 |
1628077 | 1628077 | 2021-08-17 | Raleigh | West Virginia | 54081 | 7535 | 105 |
1624830 | 1624830 | 2021-08-16 | Raleigh | West Virginia | 54081 | 7474 | 105 |
1621583 | 1621583 | 2021-08-15 | Raleigh | West Virginia | 54081 | 7432 | 104 |
1618335 | 1618335 | 2021-08-14 | Raleigh | West Virginia | 54081 | 7432 | 104 |
1615087 | 1615087 | 2021-08-13 | Raleigh | West Virginia | 54081 | 7432 | 104 |
1611838 | 1611838 | 2021-08-12 | Raleigh | West Virginia | 54081 | 7429 | 103 |
1608591 | 1608591 | 2021-08-11 | Raleigh | West Virginia | 54081 | 7403 | 102 |
1605342 | 1605342 | 2021-08-10 | Raleigh | West Virginia | 54081 | 7383 | 101 |
1602092 | 1602092 | 2021-08-09 | Raleigh | West Virginia | 54081 | 7365 | 101 |
1598844 | 1598844 | 2021-08-08 | Raleigh | West Virginia | 54081 | 7298 | 102 |
1595595 | 1595595 | 2021-08-07 | Raleigh | West Virginia | 54081 | 7298 | 102 |
1592346 | 1592346 | 2021-08-06 | Raleigh | West Virginia | 54081 | 7298 | 102 |
1589097 | 1589097 | 2021-08-05 | Raleigh | West Virginia | 54081 | 7280 | 102 |
1585848 | 1585848 | 2021-08-04 | Raleigh | West Virginia | 54081 | 7252 | 101 |
1582598 | 1582598 | 2021-08-03 | Raleigh | West Virginia | 54081 | 7236 | 101 |
1579348 | 1579348 | 2021-08-02 | Raleigh | West Virginia | 54081 | 7225 | 101 |
1576100 | 1576100 | 2021-08-01 | Raleigh | West Virginia | 54081 | 7183 | 101 |
1572852 | 1572852 | 2021-07-31 | Raleigh | West Virginia | 54081 | 7183 | 101 |
1569604 | 1569604 | 2021-07-30 | Raleigh | West Virginia | 54081 | 7183 | 101 |
1566356 | 1566356 | 2021-07-29 | Raleigh | West Virginia | 54081 | 7178 | 101 |
1563108 | 1563108 | 2021-07-28 | Raleigh | West Virginia | 54081 | 7163 | 101 |
1559860 | 1559860 | 2021-07-27 | Raleigh | West Virginia | 54081 | 7152 | 101 |
1556613 | 1556613 | 2021-07-26 | Raleigh | West Virginia | 54081 | 7149 | 101 |
1553366 | 1553366 | 2021-07-25 | Raleigh | West Virginia | 54081 | 7141 | 101 |
1550119 | 1550119 | 2021-07-24 | Raleigh | West Virginia | 54081 | 7141 | 101 |
1546872 | 1546872 | 2021-07-23 | Raleigh | West Virginia | 54081 | 7141 | 101 |
1543625 | 1543625 | 2021-07-22 | Raleigh | West Virginia | 54081 | 7136 | 101 |
1540377 | 1540377 | 2021-07-21 | Raleigh | West Virginia | 54081 | 7132 | 100 |
1537130 | 1537130 | 2021-07-20 | Raleigh | West Virginia | 54081 | 7130 | 100 |
1533882 | 1533882 | 2021-07-19 | Raleigh | West Virginia | 54081 | 7128 | 100 |
1530635 | 1530635 | 2021-07-18 | Raleigh | West Virginia | 54081 | 7119 | 100 |
1527388 | 1527388 | 2021-07-17 | Raleigh | West Virginia | 54081 | 7119 | 100 |
1524141 | 1524141 | 2021-07-16 | Raleigh | West Virginia | 54081 | 7119 | 100 |
1520893 | 1520893 | 2021-07-15 | Raleigh | West Virginia | 54081 | 7113 | 100 |
1517645 | 1517645 | 2021-07-14 | Raleigh | West Virginia | 54081 | 7110 | 100 |
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);