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 |
---|---|---|---|---|---|---|---|
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 |
1624831 | 1624831 | 2021-08-16 | Randolph | West Virginia | 54083 | 3033 | 17 |
1621584 | 1621584 | 2021-08-15 | Randolph | West Virginia | 54083 | 3012 | 17 |
1618336 | 1618336 | 2021-08-14 | Randolph | West Virginia | 54083 | 3012 | 17 |
1615088 | 1615088 | 2021-08-13 | Randolph | West Virginia | 54083 | 3012 | 17 |
1611839 | 1611839 | 2021-08-12 | Randolph | West Virginia | 54083 | 3004 | 17 |
1608592 | 1608592 | 2021-08-11 | Randolph | West Virginia | 54083 | 2993 | 17 |
1605343 | 1605343 | 2021-08-10 | Randolph | West Virginia | 54083 | 2978 | 17 |
1602093 | 1602093 | 2021-08-09 | Randolph | West Virginia | 54083 | 2959 | 17 |
1598845 | 1598845 | 2021-08-08 | Randolph | West Virginia | 54083 | 2938 | 17 |
1595596 | 1595596 | 2021-08-07 | Randolph | West Virginia | 54083 | 2938 | 17 |
1592347 | 1592347 | 2021-08-06 | Randolph | West Virginia | 54083 | 2938 | 17 |
1589098 | 1589098 | 2021-08-05 | Randolph | West Virginia | 54083 | 2923 | 17 |
1585849 | 1585849 | 2021-08-04 | Randolph | West Virginia | 54083 | 2913 | 17 |
1582599 | 1582599 | 2021-08-03 | Randolph | West Virginia | 54083 | 2908 | 17 |
1579349 | 1579349 | 2021-08-02 | Randolph | West Virginia | 54083 | 2904 | 17 |
1576101 | 1576101 | 2021-08-01 | Randolph | West Virginia | 54083 | 2891 | 17 |
1572853 | 1572853 | 2021-07-31 | Randolph | West Virginia | 54083 | 2891 | 17 |
1569605 | 1569605 | 2021-07-30 | Randolph | West Virginia | 54083 | 2891 | 17 |
1566357 | 1566357 | 2021-07-29 | Randolph | West Virginia | 54083 | 2888 | 17 |
1563109 | 1563109 | 2021-07-28 | Randolph | West Virginia | 54083 | 2884 | 15 |
1559861 | 1559861 | 2021-07-27 | Randolph | West Virginia | 54083 | 2884 | 15 |
1556614 | 1556614 | 2021-07-26 | Randolph | West Virginia | 54083 | 2882 | 15 |
1553367 | 1553367 | 2021-07-25 | Randolph | West Virginia | 54083 | 2879 | 15 |
1550120 | 1550120 | 2021-07-24 | Randolph | West Virginia | 54083 | 2879 | 15 |
1546873 | 1546873 | 2021-07-23 | Randolph | West Virginia | 54083 | 2879 | 15 |
1543626 | 1543626 | 2021-07-22 | Randolph | West Virginia | 54083 | 2872 | 15 |
1540378 | 1540378 | 2021-07-21 | Randolph | West Virginia | 54083 | 2872 | 15 |
1537131 | 1537131 | 2021-07-20 | Randolph | West Virginia | 54083 | 2871 | 15 |
1533883 | 1533883 | 2021-07-19 | Randolph | West Virginia | 54083 | 2870 | 15 |
1530636 | 1530636 | 2021-07-18 | Randolph | West Virginia | 54083 | 2867 | 15 |
1527389 | 1527389 | 2021-07-17 | Randolph | West Virginia | 54083 | 2867 | 15 |
1524142 | 1524142 | 2021-07-16 | Randolph | West Virginia | 54083 | 2867 | 15 |
1520894 | 1520894 | 2021-07-15 | Randolph | West Virginia | 54083 | 2864 | 15 |
1517646 | 1517646 | 2021-07-14 | Randolph | West Virginia | 54083 | 2863 | 15 |
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);