ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
766 rows where county = "Hampshire" and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 532 ✖
- 7 15
- 42 13
- 40 12
- 1920 11
- 1935 11
- 92 9
- 91 8
- 8 6
- 12 6
- 76 6
- 93 6
- 5811 6
- 6 5
- 1927 5
- 1939 5
- 3596 5
- 31 4
- 33 4
- 74 4
- 100 4
- 118 4
- 1904 4
- 1929 4
- 4010 4
- 4124 4
- 5815 4
- 2 3
- 35 3
- 39 3
- 41 3
- 95 3
- 108 3
- 112 3
- 117 3
- 119 3
- 123 3
- 1548 3
- 1883 3
- 1910 3
- 1915 3
- 1951 3
- 1979 3
- 2030 3
- 5680 3
- 5738 3
- 5780 3
- 5793 3
- 5803 3
- 5822 3
- 5830 3
- 5846 3
- 5872 3
- 5893 3
- 4 2
- 9 2
- 10 2
- 13 2
- 21 2
- 28 2
- 29 2
- 44 2
- 51 2
- 55 2
- 86 2
- 90 2
- 103 2
- 109 2
- 111 2
- 122 2
- 175 2
- 923 2
- 1551 2
- 1562 2
- 1574 2
- 1715 2
- 1742 2
- 1871 2
- 1909 2
- 1912 2
- 1914 2
- 1925 2
- 1928 2
- 1933 2
- 2109 2
- 3332 2
- 5814 2
- 5818 2
- 5837 2
- 5880 2
- 5901 2
- 5 1
- 11 1
- 15 1
- 17 1
- 23 1
- 34 1
- 45 1
- 46 1
- 48 1
- 50 1
- 54 1
- 56 1
- 58 1
- 64 1
- 67 1
- 68 1
- 70 1
- 73 1
- 75 1
- 80 1
- 84 1
- 88 1
- 89 1
- 96 1
- 97 1
- 99 1
- 102 1
- 104 1
- 106 1
- 107 1
- 110 1
- 115 1
- 116 1
- 125 1
- 127 1
- 130 1
- 133 1
- 140 1
- 143 1
- 144 1
- 146 1
- 149 1
- 158 1
- 165 1
- 171 1
- 176 1
- 184 1
- 188 1
- 193 1
- 194 1
- 202 1
- 206 1
- 207 1
- 217 1
- 233 1
- 242 1
- 246 1
- 256 1
- 265 1
- 277 1
- 288 1
- 295 1
- 299 1
- 306 1
- 313 1
- 325 1
- 338 1
- 353 1
- 372 1
- 381 1
- 394 1
- 422 1
- 443 1
- 460 1
- 476 1
- 516 1
- 547 1
- 564 1
- 583 1
- 594 1
- 631 1
- 664 1
- 682 1
- 724 1
- 753 1
- 780 1
- 810 1
- 817 1
- 832 1
- 844 1
- 891 1
- 907 1
- 926 1
- 943 1
- 966 1
- 988 1
- 1015 1
- 1026 1
- 1038 1
- 1055 1
- 1070 1
- 1084 1
- 1094 1
- 1119 1
- 1129 1
- 1145 1
- 1164 1
- 1175 1
- 1188 1
- 1192 1
- 1209 1
- 1217 1
- 1228 1
- 1231 1
- 1245 1
- 1257 1
- 1278 1
- 1288 1
- 1302 1
- 1316 1
- 1324 1
- 1332 1
- 1343 1
- 1362 1
- 1365 1
- 1388 1
- 1395 1
- 1398 1
- 1400 1
- 1408 1
- 1413 1
- 1421 1
- 1427 1
- 1448 1
- 1449 1
- 1452 1
- 1454 1
- 1467 1
- 1468 1
- 1472 1
- 1473 1
- 1474 1
- 1478 1
- 1485 1
- 1490 1
- 1491 1
- 1495 1
- 1498 1
- 1499 1
- 1504 1
- 1511 1
- 1515 1
- 1522 1
- 1528 1
- 1530 1
- 1532 1
- 1538 1
- 1546 1
- 1549 1
- 1552 1
- 1553 1
- 1558 1
- 1559 1
- 1570 1
- 1577 1
- 1582 1
- 1584 1
- 1585 1
- 1586 1
- 1591 1
- 1595 1
- 1596 1
- 1601 1
- 1604 1
- 1605 1
- 1609 1
- 1616 1
- 1624 1
- 1629 1
- 1637 1
- 1640 1
- 1644 1
- 1647 1
- 1651 1
- 1654 1
- 1661 1
- 1662 1
- 1665 1
- 1669 1
- 1677 1
- 1680 1
- 1681 1
- 1686 1
- 1702 1
- 1716 1
- 1724 1
- 1732 1
- 1735 1
- 1739 1
- 1746 1
- 1751 1
- 1752 1
- 1755 1
- 1760 1
- 1765 1
- 1767 1
- 1772 1
- 1784 1
- 1792 1
- 1795 1
- 1796 1
- 1800 1
- 1804 1
- 1810 1
- 1825 1
- 1837 1
- 1842 1
- 1853 1
- 1862 1
- 1869 1
- 1878 1
- 1890 1
- 1891 1
- 1895 1
- 1902 1
- 1907 1
- 1916 1
- 1917 1
- 1919 1
- 1926 1
- 1931 1
- 1936 1
- 1937 1
- 1942 1
- 1943 1
- 1944 1
- 1948 1
- 1956 1
- 1963 1
- 1966 1
- 1977 1
- 1993 1
- 2008 1
- 2012 1
- 2021 1
- 2070 1
- 2076 1
- 2080 1
- 2098 1
- 2138 1
- 2150 1
- 2156 1
- 2174 1
- 2183 1
- 2204 1
- 2230 1
- 2250 1
- 2267 1
- 2276 1
- 2293 1
- 2308 1
- 2345 1
- 2367 1
- 2394 1
- 2408 1
- 2435 1
- 2464 1
- 2500 1
- 2518 1
- 2538 1
- 2558 1
- 2582 1
- 2610 1
- 2636 1
- 2666 1
- 2695 1
- 2713 1
- 2727 1
- 2742 1
- 2753 1
- 2767 1
- 2785 1
- 2804 1
- 2820 1
- 2832 1
- 2838 1
- 2847 1
- 2861 1
- 2877 1
- 2897 1
- 2955 1
- 2963 1
- 2974 1
- 2982 1
- 3000 1
- 3025 1
- 3047 1
- 3078 1
- 3082 1
- 3089 1
- 3099 1
- 3117 1
- 3135 1
- 3142 1
- 3150 1
- 3158 1
- 3159 1
- 3180 1
- 3200 1
- 3208 1
- 3221 1
- 3228 1
- 3239 1
- 3241 1
- 3251 1
- 3274 1
- 3294 1
- 3313 1
- 3328 1
- 3350 1
- 3370 1
- 3399 1
- 3402 1
- 3423 1
- 3434 1
- 3438 1
- 3449 1
- 3474 1
- 3502 1
- 3536 1
- 3554 1
- 3571 1
- 3577 1
- 3581 1
- 3641 1
- 3661 1
- 3692 1
- 3728 1
- 3753 1
- 3763 1
- 3773 1
- 3777 1
- 3798 1
- 3814 1
- 3831 1
- 3843 1
- 3873 1
- 3877 1
- 3886 1
- 3894 1
- 3904 1
- 3928 1
- 3941 1
- 3954 1
- 3961 1
- 3973 1
- 3983 1
- 3992 1
- 4043 1
- 4058 1
- 4079 1
- 4214 1
- 4235 1
- 4261 1
- 4328 1
- 4395 1
- 4437 1
- 4458 1
- 4492 1
- 4520 1
- 4549 1
- 4607 1
- 4665 1
- 4703 1
- 4733 1
- 4777 1
- 4788 1
- 4842 1
- 4925 1
- 4972 1
- 5035 1
- 5067 1
- 5095 1
- 5116 1
- 5166 1
- 5209 1
- 5249 1
- 5280 1
- 5313 1
- 5326 1
- 5360 1
- 5377 1
- 5420 1
- 5441 1
- 5475 1
- 5494 1
- 5507 1
- 5533 1
- 5555 1
- 5580 1
- 5589 1
- 5596 1
- 5605 1
- 5613 1
- 5633 1
- 5648 1
- 5667 1
- 5702 1
- 5707 1
- 5710 1
- 5732 1
- 5753 1
- 5756 1
- 5765 1
- 5772 1
- 5783 1
- 5784 1
- 5788 1
- 5795 1
- 5796 1
- 5799 1
- 5800 1
- 5801 1
- 5806 1
- 5810 1
- 5817 1
- 5821 1
- 5824 1
- 5825 1
- 5826 1
- 5829 1
- 5841 1
- 5842 1
- 5854 1
- 5857 1
- 5863 1
- 5868 1
- 5879 1
- 5883 1
- 5902 1
- 5904 1
- 5906 1
state 1
- West Virginia · 766 ✖
fips 1
- 54027 766
county 1
- Hampshire · 766 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502696 | 2502696 | 2022-05-13 | Hampshire | West Virginia | 54027 | 5906 | 73 |
2499438 | 2499438 | 2022-05-12 | Hampshire | West Virginia | 54027 | 5904 | 73 |
2496180 | 2496180 | 2022-05-11 | Hampshire | West Virginia | 54027 | 5902 | 73 |
2492922 | 2492922 | 2022-05-10 | Hampshire | West Virginia | 54027 | 5901 | 73 |
2489664 | 2489664 | 2022-05-09 | Hampshire | West Virginia | 54027 | 5901 | 73 |
2486407 | 2486407 | 2022-05-08 | Hampshire | West Virginia | 54027 | 5893 | 72 |
2483149 | 2483149 | 2022-05-07 | Hampshire | West Virginia | 54027 | 5893 | 72 |
2479891 | 2479891 | 2022-05-06 | Hampshire | West Virginia | 54027 | 5893 | 72 |
2476633 | 2476633 | 2022-05-05 | Hampshire | West Virginia | 54027 | 5883 | 72 |
2473375 | 2473375 | 2022-05-04 | Hampshire | West Virginia | 54027 | 5880 | 72 |
2470118 | 2470118 | 2022-05-03 | Hampshire | West Virginia | 54027 | 5880 | 72 |
2466862 | 2466862 | 2022-05-02 | Hampshire | West Virginia | 54027 | 5879 | 72 |
2463607 | 2463607 | 2022-05-01 | Hampshire | West Virginia | 54027 | 5872 | 72 |
2460351 | 2460351 | 2022-04-30 | Hampshire | West Virginia | 54027 | 5872 | 72 |
2457095 | 2457095 | 2022-04-29 | Hampshire | West Virginia | 54027 | 5872 | 72 |
2453839 | 2453839 | 2022-04-28 | Hampshire | West Virginia | 54027 | 5868 | 72 |
2450583 | 2450583 | 2022-04-27 | Hampshire | West Virginia | 54027 | 5863 | 72 |
2447327 | 2447327 | 2022-04-26 | Hampshire | West Virginia | 54027 | 5857 | 72 |
2444071 | 2444071 | 2022-04-25 | Hampshire | West Virginia | 54027 | 5854 | 72 |
2440815 | 2440815 | 2022-04-24 | Hampshire | West Virginia | 54027 | 5846 | 72 |
2437559 | 2437559 | 2022-04-23 | Hampshire | West Virginia | 54027 | 5846 | 72 |
2434303 | 2434303 | 2022-04-22 | Hampshire | West Virginia | 54027 | 5846 | 72 |
2431047 | 2431047 | 2022-04-21 | Hampshire | West Virginia | 54027 | 5842 | 72 |
2427791 | 2427791 | 2022-04-20 | Hampshire | West Virginia | 54027 | 5841 | 72 |
2424535 | 2424535 | 2022-04-19 | Hampshire | West Virginia | 54027 | 5837 | 72 |
2421279 | 2421279 | 2022-04-18 | Hampshire | West Virginia | 54027 | 5837 | 71 |
2418023 | 2418023 | 2022-04-17 | Hampshire | West Virginia | 54027 | 5830 | 71 |
2414767 | 2414767 | 2022-04-16 | Hampshire | West Virginia | 54027 | 5830 | 71 |
2411511 | 2411511 | 2022-04-15 | Hampshire | West Virginia | 54027 | 5830 | 71 |
2408255 | 2408255 | 2022-04-14 | Hampshire | West Virginia | 54027 | 5825 | 71 |
2404999 | 2404999 | 2022-04-13 | Hampshire | West Virginia | 54027 | 5824 | 71 |
2401744 | 2401744 | 2022-04-12 | Hampshire | West Virginia | 54027 | 5829 | 71 |
2398489 | 2398489 | 2022-04-11 | Hampshire | West Virginia | 54027 | 5826 | 71 |
2395234 | 2395234 | 2022-04-10 | Hampshire | West Virginia | 54027 | 5822 | 71 |
2391978 | 2391978 | 2022-04-09 | Hampshire | West Virginia | 54027 | 5822 | 71 |
2388722 | 2388722 | 2022-04-08 | Hampshire | West Virginia | 54027 | 5822 | 71 |
2385467 | 2385467 | 2022-04-07 | Hampshire | West Virginia | 54027 | 5821 | 71 |
2382212 | 2382212 | 2022-04-06 | Hampshire | West Virginia | 54027 | 5818 | 71 |
2378957 | 2378957 | 2022-04-05 | Hampshire | West Virginia | 54027 | 5818 | 71 |
2375703 | 2375703 | 2022-04-04 | Hampshire | West Virginia | 54027 | 5817 | 71 |
2372451 | 2372451 | 2022-04-03 | Hampshire | West Virginia | 54027 | 5815 | 71 |
2369198 | 2369198 | 2022-04-02 | Hampshire | West Virginia | 54027 | 5815 | 71 |
2365945 | 2365945 | 2022-04-01 | Hampshire | West Virginia | 54027 | 5815 | 71 |
2362692 | 2362692 | 2022-03-31 | Hampshire | West Virginia | 54027 | 5814 | 71 |
2359438 | 2359438 | 2022-03-30 | Hampshire | West Virginia | 54027 | 5815 | 71 |
2356184 | 2356184 | 2022-03-29 | Hampshire | West Virginia | 54027 | 5814 | 71 |
2352931 | 2352931 | 2022-03-28 | Hampshire | West Virginia | 54027 | 5811 | 71 |
2349679 | 2349679 | 2022-03-27 | Hampshire | West Virginia | 54027 | 5811 | 71 |
2346426 | 2346426 | 2022-03-26 | Hampshire | West Virginia | 54027 | 5811 | 71 |
2343173 | 2343173 | 2022-03-25 | Hampshire | West Virginia | 54027 | 5811 | 71 |
2339920 | 2339920 | 2022-03-24 | Hampshire | West Virginia | 54027 | 5811 | 71 |
2336667 | 2336667 | 2022-03-23 | Hampshire | West Virginia | 54027 | 5811 | 70 |
2333413 | 2333413 | 2022-03-22 | Hampshire | West Virginia | 54027 | 5810 | 70 |
2330159 | 2330159 | 2022-03-21 | Hampshire | West Virginia | 54027 | 5806 | 70 |
2326907 | 2326907 | 2022-03-20 | Hampshire | West Virginia | 54027 | 5803 | 70 |
2323654 | 2323654 | 2022-03-19 | Hampshire | West Virginia | 54027 | 5803 | 70 |
2320400 | 2320400 | 2022-03-18 | Hampshire | West Virginia | 54027 | 5803 | 70 |
2317146 | 2317146 | 2022-03-17 | Hampshire | West Virginia | 54027 | 5801 | 70 |
2313893 | 2313893 | 2022-03-16 | Hampshire | West Virginia | 54027 | 5800 | 70 |
2310640 | 2310640 | 2022-03-15 | Hampshire | West Virginia | 54027 | 5799 | 69 |
2307387 | 2307387 | 2022-03-14 | Hampshire | West Virginia | 54027 | 5795 | 69 |
2304136 | 2304136 | 2022-03-13 | Hampshire | West Virginia | 54027 | 5793 | 69 |
2300884 | 2300884 | 2022-03-12 | Hampshire | West Virginia | 54027 | 5793 | 69 |
2297632 | 2297632 | 2022-03-11 | Hampshire | West Virginia | 54027 | 5793 | 69 |
2294380 | 2294380 | 2022-03-10 | Hampshire | West Virginia | 54027 | 5796 | 69 |
2291128 | 2291128 | 2022-03-09 | Hampshire | West Virginia | 54027 | 5788 | 68 |
2287876 | 2287876 | 2022-03-08 | Hampshire | West Virginia | 54027 | 5784 | 68 |
2284624 | 2284624 | 2022-03-07 | Hampshire | West Virginia | 54027 | 5783 | 68 |
2281372 | 2281372 | 2022-03-06 | Hampshire | West Virginia | 54027 | 5780 | 67 |
2278119 | 2278119 | 2022-03-05 | Hampshire | West Virginia | 54027 | 5780 | 67 |
2274866 | 2274866 | 2022-03-04 | Hampshire | West Virginia | 54027 | 5780 | 67 |
2271613 | 2271613 | 2022-03-03 | Hampshire | West Virginia | 54027 | 5772 | 67 |
2268361 | 2268361 | 2022-03-02 | Hampshire | West Virginia | 54027 | 5765 | 67 |
2265108 | 2265108 | 2022-03-01 | Hampshire | West Virginia | 54027 | 5756 | 67 |
2261858 | 2261858 | 2022-02-28 | Hampshire | West Virginia | 54027 | 5753 | 67 |
2258607 | 2258607 | 2022-02-27 | Hampshire | West Virginia | 54027 | 5738 | 67 |
2255356 | 2255356 | 2022-02-26 | Hampshire | West Virginia | 54027 | 5738 | 67 |
2252105 | 2252105 | 2022-02-25 | Hampshire | West Virginia | 54027 | 5738 | 67 |
2248854 | 2248854 | 2022-02-24 | Hampshire | West Virginia | 54027 | 5732 | 65 |
2245603 | 2245603 | 2022-02-23 | Hampshire | West Virginia | 54027 | 5710 | 64 |
2242352 | 2242352 | 2022-02-22 | Hampshire | West Virginia | 54027 | 5707 | 64 |
2239101 | 2239101 | 2022-02-21 | Hampshire | West Virginia | 54027 | 5702 | 64 |
2235850 | 2235850 | 2022-02-20 | Hampshire | West Virginia | 54027 | 5680 | 64 |
2232599 | 2232599 | 2022-02-19 | Hampshire | West Virginia | 54027 | 5680 | 64 |
2229348 | 2229348 | 2022-02-18 | Hampshire | West Virginia | 54027 | 5680 | 64 |
2226097 | 2226097 | 2022-02-17 | Hampshire | West Virginia | 54027 | 5667 | 64 |
2222846 | 2222846 | 2022-02-16 | Hampshire | West Virginia | 54027 | 5648 | 64 |
2219595 | 2219595 | 2022-02-15 | Hampshire | West Virginia | 54027 | 5633 | 64 |
2216345 | 2216345 | 2022-02-14 | Hampshire | West Virginia | 54027 | 5613 | 64 |
2213094 | 2213094 | 2022-02-13 | Hampshire | West Virginia | 54027 | 5605 | 64 |
2209841 | 2209841 | 2022-02-12 | Hampshire | West Virginia | 54027 | 5596 | 64 |
2206588 | 2206588 | 2022-02-11 | Hampshire | West Virginia | 54027 | 5589 | 64 |
2203335 | 2203335 | 2022-02-10 | Hampshire | West Virginia | 54027 | 5580 | 64 |
2200081 | 2200081 | 2022-02-09 | Hampshire | West Virginia | 54027 | 5555 | 64 |
2196827 | 2196827 | 2022-02-08 | Hampshire | West Virginia | 54027 | 5533 | 64 |
2193572 | 2193572 | 2022-02-07 | Hampshire | West Virginia | 54027 | 5507 | 64 |
2190319 | 2190319 | 2022-02-06 | Hampshire | West Virginia | 54027 | 5494 | 64 |
2187066 | 2187066 | 2022-02-05 | Hampshire | West Virginia | 54027 | 5475 | 64 |
2183813 | 2183813 | 2022-02-04 | Hampshire | West Virginia | 54027 | 5441 | 64 |
2180561 | 2180561 | 2022-02-03 | Hampshire | West Virginia | 54027 | 5420 | 64 |
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);