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 |
---|---|---|---|---|---|---|---|
1949737 | 1949737 | 2021-11-24 | Raleigh | West Virginia | 54081 | 12248 | 192 |
1946486 | 1946486 | 2021-11-23 | Raleigh | West Virginia | 54081 | 12216 | 191 |
1943235 | 1943235 | 2021-11-22 | Raleigh | West Virginia | 54081 | 12168 | 190 |
1939985 | 1939985 | 2021-11-21 | Raleigh | West Virginia | 54081 | 12141 | 189 |
1936735 | 1936735 | 2021-11-20 | Raleigh | West Virginia | 54081 | 12108 | 189 |
1933485 | 1933485 | 2021-11-19 | Raleigh | West Virginia | 54081 | 12059 | 189 |
1930233 | 1930233 | 2021-11-18 | Raleigh | West Virginia | 54081 | 12009 | 189 |
1926983 | 1926983 | 2021-11-17 | Raleigh | West Virginia | 54081 | 11966 | 188 |
1923733 | 1923733 | 2021-11-16 | Raleigh | West Virginia | 54081 | 11937 | 187 |
1920484 | 1920484 | 2021-11-15 | Raleigh | West Virginia | 54081 | 11914 | 186 |
1917234 | 1917234 | 2021-11-14 | Raleigh | West Virginia | 54081 | 11890 | 186 |
1913984 | 1913984 | 2021-11-13 | Raleigh | West Virginia | 54081 | 11859 | 186 |
1910734 | 1910734 | 2021-11-12 | Raleigh | West Virginia | 54081 | 11836 | 186 |
1907485 | 1907485 | 2021-11-11 | Raleigh | West Virginia | 54081 | 11808 | 186 |
1904236 | 1904236 | 2021-11-10 | Raleigh | West Virginia | 54081 | 11769 | 184 |
1900986 | 1900986 | 2021-11-09 | Raleigh | West Virginia | 54081 | 11745 | 183 |
1897736 | 1897736 | 2021-11-08 | Raleigh | West Virginia | 54081 | 11712 | 180 |
1894486 | 1894486 | 2021-11-07 | Raleigh | West Virginia | 54081 | 11694 | 178 |
1891236 | 1891236 | 2021-11-06 | Raleigh | West Virginia | 54081 | 11664 | 178 |
1887986 | 1887986 | 2021-11-05 | Raleigh | West Virginia | 54081 | 11631 | 178 |
1884736 | 1884736 | 2021-11-04 | Raleigh | West Virginia | 54081 | 11608 | 177 |
1881487 | 1881487 | 2021-11-03 | Raleigh | West Virginia | 54081 | 11576 | 175 |
1878238 | 1878238 | 2021-11-02 | Raleigh | West Virginia | 54081 | 11535 | 175 |
1874989 | 1874989 | 2021-11-01 | Raleigh | West Virginia | 54081 | 11510 | 174 |
1871740 | 1871740 | 2021-10-31 | Raleigh | West Virginia | 54081 | 11490 | 173 |
1868491 | 1868491 | 2021-10-30 | Raleigh | West Virginia | 54081 | 11477 | 173 |
1865242 | 1865242 | 2021-10-29 | Raleigh | West Virginia | 54081 | 11439 | 173 |
1861993 | 1861993 | 2021-10-28 | Raleigh | West Virginia | 54081 | 11401 | 173 |
1858744 | 1858744 | 2021-10-27 | Raleigh | West Virginia | 54081 | 11360 | 171 |
1855495 | 1855495 | 2021-10-26 | Raleigh | West Virginia | 54081 | 11330 | 171 |
1852246 | 1852246 | 2021-10-25 | Raleigh | West Virginia | 54081 | 11295 | 169 |
1848996 | 1848996 | 2021-10-24 | Raleigh | West Virginia | 54081 | 11246 | 168 |
1845746 | 1845746 | 2021-10-23 | Raleigh | West Virginia | 54081 | 11223 | 168 |
1842496 | 1842496 | 2021-10-22 | Raleigh | West Virginia | 54081 | 11177 | 168 |
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 |
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);