ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
749 rows where county = "Gilmer" and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 392 ✖
- 10 32
- 13 24
- 18 18
- 2088 18
- 64 14
- 8 11
- 16 11
- 2099 11
- 19 10
- 2 8
- 20 8
- 873 8
- 881 8
- 875 7
- 888 7
- 14 6
- 721 6
- 728 6
- 874 6
- 1443 6
- 2092 6
- 2094 6
- 49 5
- 731 5
- 885 5
- 889 5
- 2091 5
- 9 4
- 12 4
- 17 4
- 48 4
- 732 4
- 733 4
- 734 4
- 890 4
- 891 4
- 936 4
- 1562 4
- 1601 4
- 2066 4
- 2083 4
- 2098 4
- 3 3
- 51 3
- 65 3
- 180 3
- 659 3
- 726 3
- 741 3
- 872 3
- 882 3
- 884 3
- 893 3
- 895 3
- 907 3
- 960 3
- 1484 3
- 1501 3
- 2044 3
- 2075 3
- 2101 3
- 4 2
- 46 2
- 50 2
- 62 2
- 166 2
- 175 2
- 214 2
- 542 2
- 660 2
- 706 2
- 710 2
- 712 2
- 718 2
- 719 2
- 720 2
- 723 2
- 730 2
- 745 2
- 802 2
- 854 2
- 868 2
- 886 2
- 900 2
- 984 2
- 1008 2
- 1316 2
- 1346 2
- 1416 2
- 1427 2
- 1439 2
- 1442 2
- 1458 2
- 1582 2
- 1642 2
- 2029 2
- 2069 2
- 2079 2
- 2085 2
- 2090 2
- 1 1
- 11 1
- 21 1
- 27 1
- 29 1
- 32 1
- 33 1
- 39 1
- 43 1
- 45 1
- 54 1
- 57 1
- 60 1
- 61 1
- 71 1
- 87 1
- 116 1
- 117 1
- 118 1
- 119 1
- 169 1
- 174 1
- 179 1
- 182 1
- 183 1
- 186 1
- 192 1
- 196 1
- 199 1
- 200 1
- 202 1
- 203 1
- 206 1
- 209 1
- 215 1
- 218 1
- 221 1
- 222 1
- 225 1
- 228 1
- 231 1
- 234 1
- 244 1
- 254 1
- 256 1
- 257 1
- 258 1
- 262 1
- 267 1
- 270 1
- 272 1
- 292 1
- 295 1
- 319 1
- 334 1
- 345 1
- 358 1
- 372 1
- 375 1
- 386 1
- 391 1
- 397 1
- 413 1
- 418 1
- 431 1
- 437 1
- 443 1
- 444 1
- 457 1
- 468 1
- 475 1
- 484 1
- 494 1
- 506 1
- 510 1
- 512 1
- 514 1
- 531 1
- 532 1
- 534 1
- 536 1
- 539 1
- 549 1
- 553 1
- 555 1
- 559 1
- 560 1
- 562 1
- 567 1
- 584 1
- 587 1
- 589 1
- 592 1
- 656 1
- 657 1
- 658 1
- 661 1
- 663 1
- 671 1
- 673 1
- 676 1
- 679 1
- 683 1
- 695 1
- 699 1
- 701 1
- 702 1
- 703 1
- 705 1
- 714 1
- 715 1
- 724 1
- 725 1
- 729 1
- 735 1
- 737 1
- 738 1
- 739 1
- 746 1
- 750 1
- 762 1
- 765 1
- 783 1
- 791 1
- 798 1
- 815 1
- 823 1
- 826 1
- 834 1
- 843 1
- 857 1
- 861 1
- 863 1
- 866 1
- 867 1
- 870 1
- 879 1
- 892 1
- 901 1
- 905 1
- 920 1
- 927 1
- 929 1
- 939 1
- 948 1
- 953 1
- 958 1
- 965 1
- 967 1
- 970 1
- 983 1
- 999 1
- 1004 1
- 1012 1
- 1019 1
- 1033 1
- 1035 1
- 1041 1
- 1048 1
- 1052 1
- 1061 1
- 1066 1
- 1067 1
- 1075 1
- 1080 1
- 1089 1
- 1090 1
- 1106 1
- 1118 1
- 1139 1
- 1145 1
- 1149 1
- 1152 1
- 1158 1
- 1163 1
- 1178 1
- 1185 1
- 1188 1
- 1190 1
- 1194 1
- 1200 1
- 1211 1
- 1222 1
- 1228 1
- 1233 1
- 1236 1
- 1238 1
- 1244 1
- 1265 1
- 1269 1
- 1283 1
- 1289 1
- 1290 1
- 1292 1
- 1303 1
- 1308 1
- 1310 1
- 1321 1
- 1324 1
- 1327 1
- 1340 1
- 1341 1
- 1344 1
- 1349 1
- 1355 1
- 1362 1
- 1372 1
- 1377 1
- 1388 1
- 1390 1
- 1392 1
- 1393 1
- 1405 1
- 1407 1
- 1409 1
- 1411 1
- 1415 1
- 1417 1
- 1418 1
- 1420 1
- 1429 1
- 1430 1
- 1436 1
- 1463 1
- 1471 1
- 1477 1
- 1480 1
- 1485 1
- 1491 1
- 1496 1
- 1498 1
- 1510 1
- 1520 1
- 1530 1
- 1533 1
- 1539 1
- 1546 1
- 1550 1
- 1558 1
- 1588 1
- 1612 1
- 1613 1
- 1617 1
- 1622 1
- 1628 1
- 1634 1
- 1641 1
- 1646 1
- 1661 1
- 1678 1
- 1697 1
- 1709 1
- 1715 1
- 1726 1
- 1733 1
- 1741 1
- 1766 1
- 1805 1
- 1818 1
- 1833 1
- 1837 1
- 1850 1
- 1862 1
- 1875 1
- 1878 1
- 1886 1
- 1895 1
- 1901 1
- 1909 1
- 1938 1
- 1954 1
- 1963 1
- 1973 1
- 1974 1
- 1986 1
- 1993 1
- 2005 1
- 2014 1
- 2018 1
- 2022 1
- 2035 1
- 2046 1
- 2048 1
- 2055 1
- 2061 1
- 2070 1
- 2072 1
- 2078 1
- 2080 1
- 2089 1
- 2093 1
- 2096 1
state 1
- West Virginia · 749 ✖
fips 1
- 54021 749
county 1
- Gilmer · 749 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502693 | 2502693 | 2022-05-13 | Gilmer | West Virginia | 54021 | 2101 | 19 |
2499435 | 2499435 | 2022-05-12 | Gilmer | West Virginia | 54021 | 2101 | 19 |
2496177 | 2496177 | 2022-05-11 | Gilmer | West Virginia | 54021 | 2101 | 19 |
2492919 | 2492919 | 2022-05-10 | Gilmer | West Virginia | 54021 | 2098 | 19 |
2489661 | 2489661 | 2022-05-09 | Gilmer | West Virginia | 54021 | 2098 | 19 |
2486404 | 2486404 | 2022-05-08 | Gilmer | West Virginia | 54021 | 2099 | 19 |
2483146 | 2483146 | 2022-05-07 | Gilmer | West Virginia | 54021 | 2099 | 19 |
2479888 | 2479888 | 2022-05-06 | Gilmer | West Virginia | 54021 | 2099 | 19 |
2476630 | 2476630 | 2022-05-05 | Gilmer | West Virginia | 54021 | 2099 | 19 |
2473372 | 2473372 | 2022-05-04 | Gilmer | West Virginia | 54021 | 2099 | 19 |
2470115 | 2470115 | 2022-05-03 | Gilmer | West Virginia | 54021 | 2099 | 19 |
2466859 | 2466859 | 2022-05-02 | Gilmer | West Virginia | 54021 | 2099 | 19 |
2463604 | 2463604 | 2022-05-01 | Gilmer | West Virginia | 54021 | 2099 | 19 |
2460348 | 2460348 | 2022-04-30 | Gilmer | West Virginia | 54021 | 2099 | 19 |
2457092 | 2457092 | 2022-04-29 | Gilmer | West Virginia | 54021 | 2099 | 19 |
2453836 | 2453836 | 2022-04-28 | Gilmer | West Virginia | 54021 | 2099 | 19 |
2450580 | 2450580 | 2022-04-27 | Gilmer | West Virginia | 54021 | 2098 | 19 |
2447324 | 2447324 | 2022-04-26 | Gilmer | West Virginia | 54021 | 2098 | 19 |
2444068 | 2444068 | 2022-04-25 | Gilmer | West Virginia | 54021 | 2096 | 19 |
2440812 | 2440812 | 2022-04-24 | Gilmer | West Virginia | 54021 | 2094 | 19 |
2437556 | 2437556 | 2022-04-23 | Gilmer | West Virginia | 54021 | 2094 | 19 |
2434300 | 2434300 | 2022-04-22 | Gilmer | West Virginia | 54021 | 2094 | 19 |
2431044 | 2431044 | 2022-04-21 | Gilmer | West Virginia | 54021 | 2094 | 19 |
2427788 | 2427788 | 2022-04-20 | Gilmer | West Virginia | 54021 | 2094 | 19 |
2424532 | 2424532 | 2022-04-19 | Gilmer | West Virginia | 54021 | 2094 | 19 |
2421276 | 2421276 | 2022-04-18 | Gilmer | West Virginia | 54021 | 2093 | 19 |
2418020 | 2418020 | 2022-04-17 | Gilmer | West Virginia | 54021 | 2092 | 19 |
2414764 | 2414764 | 2022-04-16 | Gilmer | West Virginia | 54021 | 2092 | 19 |
2411508 | 2411508 | 2022-04-15 | Gilmer | West Virginia | 54021 | 2092 | 19 |
2408252 | 2408252 | 2022-04-14 | Gilmer | West Virginia | 54021 | 2092 | 19 |
2404996 | 2404996 | 2022-04-13 | Gilmer | West Virginia | 54021 | 2092 | 19 |
2401741 | 2401741 | 2022-04-12 | Gilmer | West Virginia | 54021 | 2092 | 19 |
2398486 | 2398486 | 2022-04-11 | Gilmer | West Virginia | 54021 | 2091 | 19 |
2395231 | 2395231 | 2022-04-10 | Gilmer | West Virginia | 54021 | 2091 | 19 |
2391975 | 2391975 | 2022-04-09 | Gilmer | West Virginia | 54021 | 2091 | 19 |
2388719 | 2388719 | 2022-04-08 | Gilmer | West Virginia | 54021 | 2091 | 19 |
2385464 | 2385464 | 2022-04-07 | Gilmer | West Virginia | 54021 | 2091 | 19 |
2382209 | 2382209 | 2022-04-06 | Gilmer | West Virginia | 54021 | 2090 | 19 |
2378954 | 2378954 | 2022-04-05 | Gilmer | West Virginia | 54021 | 2090 | 19 |
2375700 | 2375700 | 2022-04-04 | Gilmer | West Virginia | 54021 | 2089 | 19 |
2372448 | 2372448 | 2022-04-03 | Gilmer | West Virginia | 54021 | 2088 | 19 |
2369195 | 2369195 | 2022-04-02 | Gilmer | West Virginia | 54021 | 2088 | 19 |
2365942 | 2365942 | 2022-04-01 | Gilmer | West Virginia | 54021 | 2088 | 19 |
2362689 | 2362689 | 2022-03-31 | Gilmer | West Virginia | 54021 | 2088 | 19 |
2359435 | 2359435 | 2022-03-30 | Gilmer | West Virginia | 54021 | 2088 | 19 |
2356181 | 2356181 | 2022-03-29 | Gilmer | West Virginia | 54021 | 2088 | 18 |
2352928 | 2352928 | 2022-03-28 | Gilmer | West Virginia | 54021 | 2088 | 18 |
2349676 | 2349676 | 2022-03-27 | Gilmer | West Virginia | 54021 | 2088 | 18 |
2346423 | 2346423 | 2022-03-26 | Gilmer | West Virginia | 54021 | 2088 | 18 |
2343170 | 2343170 | 2022-03-25 | Gilmer | West Virginia | 54021 | 2088 | 18 |
2339917 | 2339917 | 2022-03-24 | Gilmer | West Virginia | 54021 | 2088 | 18 |
2336664 | 2336664 | 2022-03-23 | Gilmer | West Virginia | 54021 | 2088 | 18 |
2333410 | 2333410 | 2022-03-22 | Gilmer | West Virginia | 54021 | 2088 | 18 |
2330156 | 2330156 | 2022-03-21 | Gilmer | West Virginia | 54021 | 2088 | 18 |
2326904 | 2326904 | 2022-03-20 | Gilmer | West Virginia | 54021 | 2088 | 18 |
2323651 | 2323651 | 2022-03-19 | Gilmer | West Virginia | 54021 | 2088 | 18 |
2320397 | 2320397 | 2022-03-18 | Gilmer | West Virginia | 54021 | 2088 | 18 |
2317143 | 2317143 | 2022-03-17 | Gilmer | West Virginia | 54021 | 2088 | 18 |
2313890 | 2313890 | 2022-03-16 | Gilmer | West Virginia | 54021 | 2085 | 18 |
2310637 | 2310637 | 2022-03-15 | Gilmer | West Virginia | 54021 | 2085 | 18 |
2307384 | 2307384 | 2022-03-14 | Gilmer | West Virginia | 54021 | 2080 | 18 |
2304133 | 2304133 | 2022-03-13 | Gilmer | West Virginia | 54021 | 2083 | 18 |
2300881 | 2300881 | 2022-03-12 | Gilmer | West Virginia | 54021 | 2083 | 18 |
2297629 | 2297629 | 2022-03-11 | Gilmer | West Virginia | 54021 | 2083 | 18 |
2294377 | 2294377 | 2022-03-10 | Gilmer | West Virginia | 54021 | 2083 | 18 |
2291125 | 2291125 | 2022-03-09 | Gilmer | West Virginia | 54021 | 2079 | 18 |
2287873 | 2287873 | 2022-03-08 | Gilmer | West Virginia | 54021 | 2079 | 18 |
2284621 | 2284621 | 2022-03-07 | Gilmer | West Virginia | 54021 | 2078 | 18 |
2281369 | 2281369 | 2022-03-06 | Gilmer | West Virginia | 54021 | 2075 | 18 |
2278116 | 2278116 | 2022-03-05 | Gilmer | West Virginia | 54021 | 2075 | 18 |
2274863 | 2274863 | 2022-03-04 | Gilmer | West Virginia | 54021 | 2075 | 18 |
2271610 | 2271610 | 2022-03-03 | Gilmer | West Virginia | 54021 | 2070 | 18 |
2268358 | 2268358 | 2022-03-02 | Gilmer | West Virginia | 54021 | 2069 | 18 |
2265105 | 2265105 | 2022-03-01 | Gilmer | West Virginia | 54021 | 2072 | 18 |
2261855 | 2261855 | 2022-02-28 | Gilmer | West Virginia | 54021 | 2069 | 18 |
2258604 | 2258604 | 2022-02-27 | Gilmer | West Virginia | 54021 | 2066 | 18 |
2255353 | 2255353 | 2022-02-26 | Gilmer | West Virginia | 54021 | 2066 | 18 |
2252102 | 2252102 | 2022-02-25 | Gilmer | West Virginia | 54021 | 2066 | 18 |
2248851 | 2248851 | 2022-02-24 | Gilmer | West Virginia | 54021 | 2066 | 18 |
2245600 | 2245600 | 2022-02-23 | Gilmer | West Virginia | 54021 | 2061 | 18 |
2242349 | 2242349 | 2022-02-22 | Gilmer | West Virginia | 54021 | 2055 | 18 |
2239098 | 2239098 | 2022-02-21 | Gilmer | West Virginia | 54021 | 2048 | 18 |
2235847 | 2235847 | 2022-02-20 | Gilmer | West Virginia | 54021 | 2044 | 18 |
2232596 | 2232596 | 2022-02-19 | Gilmer | West Virginia | 54021 | 2044 | 18 |
2229345 | 2229345 | 2022-02-18 | Gilmer | West Virginia | 54021 | 2044 | 18 |
2226094 | 2226094 | 2022-02-17 | Gilmer | West Virginia | 54021 | 2046 | 18 |
2222843 | 2222843 | 2022-02-16 | Gilmer | West Virginia | 54021 | 2035 | 18 |
2219592 | 2219592 | 2022-02-15 | Gilmer | West Virginia | 54021 | 2029 | 18 |
2216342 | 2216342 | 2022-02-14 | Gilmer | West Virginia | 54021 | 2029 | 17 |
2213091 | 2213091 | 2022-02-13 | Gilmer | West Virginia | 54021 | 2022 | 17 |
2209838 | 2209838 | 2022-02-12 | Gilmer | West Virginia | 54021 | 2018 | 17 |
2206585 | 2206585 | 2022-02-11 | Gilmer | West Virginia | 54021 | 2014 | 17 |
2203332 | 2203332 | 2022-02-10 | Gilmer | West Virginia | 54021 | 2005 | 17 |
2200078 | 2200078 | 2022-02-09 | Gilmer | West Virginia | 54021 | 1993 | 17 |
2196824 | 2196824 | 2022-02-08 | Gilmer | West Virginia | 54021 | 1986 | 17 |
2193569 | 2193569 | 2022-02-07 | Gilmer | West Virginia | 54021 | 1974 | 17 |
2190316 | 2190316 | 2022-02-06 | Gilmer | West Virginia | 54021 | 1973 | 17 |
2187063 | 2187063 | 2022-02-05 | Gilmer | West Virginia | 54021 | 1963 | 17 |
2183810 | 2183810 | 2022-02-04 | Gilmer | West Virginia | 54021 | 1954 | 17 |
2180558 | 2180558 | 2022-02-03 | Gilmer | West Virginia | 54021 | 1938 | 17 |
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);