ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Randolph" 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 |
---|---|---|---|---|---|---|---|
1949738 | 1949738 | 2021-11-24 | Randolph | West Virginia | 54083 | 5462 | 55 |
1946487 | 1946487 | 2021-11-23 | Randolph | West Virginia | 54083 | 5452 | 55 |
1943236 | 1943236 | 2021-11-22 | Randolph | West Virginia | 54083 | 5435 | 55 |
1939986 | 1939986 | 2021-11-21 | Randolph | West Virginia | 54083 | 5417 | 53 |
1936736 | 1936736 | 2021-11-20 | Randolph | West Virginia | 54083 | 5406 | 53 |
1933486 | 1933486 | 2021-11-19 | Randolph | West Virginia | 54083 | 5387 | 53 |
1930234 | 1930234 | 2021-11-18 | Randolph | West Virginia | 54083 | 5373 | 53 |
1926984 | 1926984 | 2021-11-17 | Randolph | West Virginia | 54083 | 5343 | 53 |
1923734 | 1923734 | 2021-11-16 | Randolph | West Virginia | 54083 | 5320 | 52 |
1920485 | 1920485 | 2021-11-15 | Randolph | West Virginia | 54083 | 5309 | 51 |
1917235 | 1917235 | 2021-11-14 | Randolph | West Virginia | 54083 | 5303 | 51 |
1913985 | 1913985 | 2021-11-13 | Randolph | West Virginia | 54083 | 5294 | 51 |
1910735 | 1910735 | 2021-11-12 | Randolph | West Virginia | 54083 | 5283 | 51 |
1907486 | 1907486 | 2021-11-11 | Randolph | West Virginia | 54083 | 5266 | 51 |
1904237 | 1904237 | 2021-11-10 | Randolph | West Virginia | 54083 | 5254 | 50 |
1900987 | 1900987 | 2021-11-09 | Randolph | West Virginia | 54083 | 5237 | 50 |
1897737 | 1897737 | 2021-11-08 | Randolph | West Virginia | 54083 | 5221 | 50 |
1894487 | 1894487 | 2021-11-07 | Randolph | West Virginia | 54083 | 5217 | 50 |
1891237 | 1891237 | 2021-11-06 | Randolph | West Virginia | 54083 | 5212 | 50 |
1887987 | 1887987 | 2021-11-05 | Randolph | West Virginia | 54083 | 5202 | 50 |
1884737 | 1884737 | 2021-11-04 | Randolph | West Virginia | 54083 | 5186 | 50 |
1881488 | 1881488 | 2021-11-03 | Randolph | West Virginia | 54083 | 5176 | 50 |
1878239 | 1878239 | 2021-11-02 | Randolph | West Virginia | 54083 | 5162 | 50 |
1874990 | 1874990 | 2021-11-01 | Randolph | West Virginia | 54083 | 5149 | 50 |
1871741 | 1871741 | 2021-10-31 | Randolph | West Virginia | 54083 | 5144 | 50 |
1868492 | 1868492 | 2021-10-30 | Randolph | West Virginia | 54083 | 5143 | 50 |
1865243 | 1865243 | 2021-10-29 | Randolph | West Virginia | 54083 | 5100 | 50 |
1861994 | 1861994 | 2021-10-28 | Randolph | West Virginia | 54083 | 5088 | 49 |
1858745 | 1858745 | 2021-10-27 | Randolph | West Virginia | 54083 | 5077 | 48 |
1855496 | 1855496 | 2021-10-26 | Randolph | West Virginia | 54083 | 5066 | 47 |
1852247 | 1852247 | 2021-10-25 | Randolph | West Virginia | 54083 | 5047 | 47 |
1848997 | 1848997 | 2021-10-24 | Randolph | West Virginia | 54083 | 5029 | 47 |
1845747 | 1845747 | 2021-10-23 | Randolph | West Virginia | 54083 | 5025 | 47 |
1842497 | 1842497 | 2021-10-22 | Randolph | West Virginia | 54083 | 5015 | 47 |
1839248 | 1839248 | 2021-10-21 | Randolph | West Virginia | 54083 | 4996 | 47 |
1835999 | 1835999 | 2021-10-20 | Randolph | West Virginia | 54083 | 4988 | 46 |
1832750 | 1832750 | 2021-10-19 | Randolph | West Virginia | 54083 | 4976 | 44 |
1829501 | 1829501 | 2021-10-18 | Randolph | West Virginia | 54083 | 4956 | 44 |
1826252 | 1826252 | 2021-10-17 | Randolph | West Virginia | 54083 | 4948 | 44 |
1823003 | 1823003 | 2021-10-16 | Randolph | West Virginia | 54083 | 4944 | 44 |
1819754 | 1819754 | 2021-10-15 | Randolph | West Virginia | 54083 | 4935 | 44 |
1816505 | 1816505 | 2021-10-14 | Randolph | West Virginia | 54083 | 4923 | 43 |
1813257 | 1813257 | 2021-10-13 | Randolph | West Virginia | 54083 | 4905 | 41 |
1810008 | 1810008 | 2021-10-12 | Randolph | West Virginia | 54083 | 4894 | 41 |
1806759 | 1806759 | 2021-10-11 | Randolph | West Virginia | 54083 | 4878 | 40 |
1803508 | 1803508 | 2021-10-10 | Randolph | West Virginia | 54083 | 4869 | 39 |
1800259 | 1800259 | 2021-10-09 | Randolph | West Virginia | 54083 | 4864 | 38 |
1797010 | 1797010 | 2021-10-08 | Randolph | West Virginia | 54083 | 4849 | 39 |
1793761 | 1793761 | 2021-10-07 | Randolph | West Virginia | 54083 | 4826 | 38 |
1790512 | 1790512 | 2021-10-06 | Randolph | West Virginia | 54083 | 4804 | 37 |
1787264 | 1787264 | 2021-10-05 | Randolph | West Virginia | 54083 | 4782 | 37 |
1784015 | 1784015 | 2021-10-04 | Randolph | West Virginia | 54083 | 4773 | 37 |
1780766 | 1780766 | 2021-10-03 | Randolph | West Virginia | 54083 | 4765 | 35 |
1777516 | 1777516 | 2021-10-02 | Randolph | West Virginia | 54083 | 4757 | 35 |
1774266 | 1774266 | 2021-10-01 | Randolph | West Virginia | 54083 | 4701 | 34 |
1771016 | 1771016 | 2021-09-30 | Randolph | West Virginia | 54083 | 4678 | 31 |
1767767 | 1767767 | 2021-09-29 | Randolph | West Virginia | 54083 | 4615 | 31 |
1764518 | 1764518 | 2021-09-28 | Randolph | West Virginia | 54083 | 4593 | 29 |
1761269 | 1761269 | 2021-09-27 | Randolph | West Virginia | 54083 | 4578 | 29 |
1758021 | 1758021 | 2021-09-26 | Randolph | West Virginia | 54083 | 4565 | 28 |
1754773 | 1754773 | 2021-09-25 | Randolph | West Virginia | 54083 | 4546 | 28 |
1751525 | 1751525 | 2021-09-24 | Randolph | West Virginia | 54083 | 4528 | 28 |
1748276 | 1748276 | 2021-09-23 | Randolph | West Virginia | 54083 | 4499 | 28 |
1745026 | 1745026 | 2021-09-22 | Randolph | West Virginia | 54083 | 4479 | 28 |
1741777 | 1741777 | 2021-09-21 | Randolph | West Virginia | 54083 | 4417 | 28 |
1738528 | 1738528 | 2021-09-20 | Randolph | West Virginia | 54083 | 4370 | 28 |
1735279 | 1735279 | 2021-09-19 | Randolph | West Virginia | 54083 | 4356 | 28 |
1732029 | 1732029 | 2021-09-18 | Randolph | West Virginia | 54083 | 4335 | 28 |
1728779 | 1728779 | 2021-09-17 | Randolph | West Virginia | 54083 | 4304 | 28 |
1725529 | 1725529 | 2021-09-16 | Randolph | West Virginia | 54083 | 4239 | 27 |
1722280 | 1722280 | 2021-09-15 | Randolph | West Virginia | 54083 | 4171 | 27 |
1719032 | 1719032 | 2021-09-14 | Randolph | West Virginia | 54083 | 4146 | 26 |
1715784 | 1715784 | 2021-09-13 | Randolph | West Virginia | 54083 | 4088 | 26 |
1712538 | 1712538 | 2021-09-12 | Randolph | West Virginia | 54083 | 4076 | 25 |
1709291 | 1709291 | 2021-09-11 | Randolph | West Virginia | 54083 | 4054 | 25 |
1706044 | 1706044 | 2021-09-10 | Randolph | West Virginia | 54083 | 4005 | 25 |
1702794 | 1702794 | 2021-09-09 | Randolph | West Virginia | 54083 | 3947 | 25 |
1699545 | 1699545 | 2021-09-08 | Randolph | West Virginia | 54083 | 3887 | 24 |
1696297 | 1696297 | 2021-09-07 | Randolph | West Virginia | 54083 | 3839 | 24 |
1693049 | 1693049 | 2021-09-06 | Randolph | West Virginia | 54083 | 3818 | 24 |
1689800 | 1689800 | 2021-09-05 | Randolph | West Virginia | 54083 | 3797 | 24 |
1686550 | 1686550 | 2021-09-04 | Randolph | West Virginia | 54083 | 3767 | 24 |
1683299 | 1683299 | 2021-09-03 | Randolph | West Virginia | 54083 | 3727 | 24 |
1680049 | 1680049 | 2021-09-02 | Randolph | West Virginia | 54083 | 3685 | 24 |
1676801 | 1676801 | 2021-09-01 | Randolph | West Virginia | 54083 | 3629 | 23 |
1673554 | 1673554 | 2021-08-31 | Randolph | West Virginia | 54083 | 3586 | 21 |
1670306 | 1670306 | 2021-08-30 | Randolph | West Virginia | 54083 | 3547 | 20 |
1667059 | 1667059 | 2021-08-29 | Randolph | West Virginia | 54083 | 3525 | 19 |
1663811 | 1663811 | 2021-08-28 | Randolph | West Virginia | 54083 | 3445 | 19 |
1660563 | 1660563 | 2021-08-27 | Randolph | West Virginia | 54083 | 3445 | 19 |
1657315 | 1657315 | 2021-08-26 | Randolph | West Virginia | 54083 | 3384 | 19 |
1654067 | 1654067 | 2021-08-25 | Randolph | West Virginia | 54083 | 3334 | 19 |
1650821 | 1650821 | 2021-08-24 | Randolph | West Virginia | 54083 | 3294 | 18 |
1647572 | 1647572 | 2021-08-23 | Randolph | West Virginia | 54083 | 3255 | 18 |
1644323 | 1644323 | 2021-08-22 | Randolph | West Virginia | 54083 | 3185 | 18 |
1641073 | 1641073 | 2021-08-21 | Randolph | West Virginia | 54083 | 3185 | 18 |
1637823 | 1637823 | 2021-08-20 | Randolph | West Virginia | 54083 | 3185 | 18 |
1634573 | 1634573 | 2021-08-19 | Randolph | West Virginia | 54083 | 3159 | 18 |
1631325 | 1631325 | 2021-08-18 | Randolph | West Virginia | 54083 | 3117 | 18 |
1628078 | 1628078 | 2021-08-17 | Randolph | West Virginia | 54083 | 3093 | 18 |
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);