ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where fips = 54001 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 |
---|---|---|---|---|---|---|---|
1949697 | 1949697 | 2021-11-24 | Barbour | West Virginia | 54001 | 2940 | 52 |
1946446 | 1946446 | 2021-11-23 | Barbour | West Virginia | 54001 | 2925 | 52 |
1943195 | 1943195 | 2021-11-22 | Barbour | West Virginia | 54001 | 2924 | 52 |
1939945 | 1939945 | 2021-11-21 | Barbour | West Virginia | 54001 | 2922 | 51 |
1936695 | 1936695 | 2021-11-20 | Barbour | West Virginia | 54001 | 2916 | 51 |
1933445 | 1933445 | 2021-11-19 | Barbour | West Virginia | 54001 | 2912 | 51 |
1930193 | 1930193 | 2021-11-18 | Barbour | West Virginia | 54001 | 2902 | 51 |
1926943 | 1926943 | 2021-11-17 | Barbour | West Virginia | 54001 | 2895 | 50 |
1923693 | 1923693 | 2021-11-16 | Barbour | West Virginia | 54001 | 2883 | 49 |
1920444 | 1920444 | 2021-11-15 | Barbour | West Virginia | 54001 | 2871 | 47 |
1917194 | 1917194 | 2021-11-14 | Barbour | West Virginia | 54001 | 2863 | 46 |
1913944 | 1913944 | 2021-11-13 | Barbour | West Virginia | 54001 | 2859 | 46 |
1910694 | 1910694 | 2021-11-12 | Barbour | West Virginia | 54001 | 2821 | 46 |
1907445 | 1907445 | 2021-11-11 | Barbour | West Virginia | 54001 | 2813 | 46 |
1904196 | 1904196 | 2021-11-10 | Barbour | West Virginia | 54001 | 2799 | 46 |
1900946 | 1900946 | 2021-11-09 | Barbour | West Virginia | 54001 | 2791 | 46 |
1897696 | 1897696 | 2021-11-08 | Barbour | West Virginia | 54001 | 2779 | 45 |
1894446 | 1894446 | 2021-11-07 | Barbour | West Virginia | 54001 | 2772 | 45 |
1891196 | 1891196 | 2021-11-06 | Barbour | West Virginia | 54001 | 2769 | 45 |
1887946 | 1887946 | 2021-11-05 | Barbour | West Virginia | 54001 | 2759 | 45 |
1884696 | 1884696 | 2021-11-04 | Barbour | West Virginia | 54001 | 2749 | 45 |
1881447 | 1881447 | 2021-11-03 | Barbour | West Virginia | 54001 | 2744 | 45 |
1878198 | 1878198 | 2021-11-02 | Barbour | West Virginia | 54001 | 2736 | 45 |
1874949 | 1874949 | 2021-11-01 | Barbour | West Virginia | 54001 | 2715 | 44 |
1871700 | 1871700 | 2021-10-31 | Barbour | West Virginia | 54001 | 2715 | 44 |
1868451 | 1868451 | 2021-10-30 | Barbour | West Virginia | 54001 | 2709 | 44 |
1865202 | 1865202 | 2021-10-29 | Barbour | West Virginia | 54001 | 2700 | 44 |
1861953 | 1861953 | 2021-10-28 | Barbour | West Virginia | 54001 | 2690 | 44 |
1858704 | 1858704 | 2021-10-27 | Barbour | West Virginia | 54001 | 2682 | 44 |
1855455 | 1855455 | 2021-10-26 | Barbour | West Virginia | 54001 | 2669 | 44 |
1852206 | 1852206 | 2021-10-25 | Barbour | West Virginia | 54001 | 2656 | 44 |
1848956 | 1848956 | 2021-10-24 | Barbour | West Virginia | 54001 | 2653 | 44 |
1845706 | 1845706 | 2021-10-23 | Barbour | West Virginia | 54001 | 2648 | 44 |
1842456 | 1842456 | 2021-10-22 | Barbour | West Virginia | 54001 | 2635 | 44 |
1839207 | 1839207 | 2021-10-21 | Barbour | West Virginia | 54001 | 2630 | 44 |
1835958 | 1835958 | 2021-10-20 | Barbour | West Virginia | 54001 | 2620 | 44 |
1832709 | 1832709 | 2021-10-19 | Barbour | West Virginia | 54001 | 2605 | 43 |
1829460 | 1829460 | 2021-10-18 | Barbour | West Virginia | 54001 | 2596 | 43 |
1826211 | 1826211 | 2021-10-17 | Barbour | West Virginia | 54001 | 2592 | 43 |
1822962 | 1822962 | 2021-10-16 | Barbour | West Virginia | 54001 | 2585 | 43 |
1819713 | 1819713 | 2021-10-15 | Barbour | West Virginia | 54001 | 2573 | 43 |
1816464 | 1816464 | 2021-10-14 | Barbour | West Virginia | 54001 | 2556 | 43 |
1813216 | 1813216 | 2021-10-13 | Barbour | West Virginia | 54001 | 2547 | 43 |
1809967 | 1809967 | 2021-10-12 | Barbour | West Virginia | 54001 | 2531 | 43 |
1806718 | 1806718 | 2021-10-11 | Barbour | West Virginia | 54001 | 2526 | 43 |
1803467 | 1803467 | 2021-10-10 | Barbour | West Virginia | 54001 | 2511 | 43 |
1800218 | 1800218 | 2021-10-09 | Barbour | West Virginia | 54001 | 2502 | 43 |
1796969 | 1796969 | 2021-10-08 | Barbour | West Virginia | 54001 | 2492 | 43 |
1793720 | 1793720 | 2021-10-07 | Barbour | West Virginia | 54001 | 2478 | 43 |
1790471 | 1790471 | 2021-10-06 | Barbour | West Virginia | 54001 | 2469 | 43 |
1787223 | 1787223 | 2021-10-05 | Barbour | West Virginia | 54001 | 2463 | 42 |
1783974 | 1783974 | 2021-10-04 | Barbour | West Virginia | 54001 | 2457 | 42 |
1780725 | 1780725 | 2021-10-03 | Barbour | West Virginia | 54001 | 2452 | 41 |
1777475 | 1777475 | 2021-10-02 | Barbour | West Virginia | 54001 | 2448 | 41 |
1774225 | 1774225 | 2021-10-01 | Barbour | West Virginia | 54001 | 2439 | 41 |
1770975 | 1770975 | 2021-09-30 | Barbour | West Virginia | 54001 | 2417 | 40 |
1767726 | 1767726 | 2021-09-29 | Barbour | West Virginia | 54001 | 2397 | 40 |
1764477 | 1764477 | 2021-09-28 | Barbour | West Virginia | 54001 | 2384 | 40 |
1761228 | 1761228 | 2021-09-27 | Barbour | West Virginia | 54001 | 2379 | 40 |
1757980 | 1757980 | 2021-09-26 | Barbour | West Virginia | 54001 | 2368 | 40 |
1754732 | 1754732 | 2021-09-25 | Barbour | West Virginia | 54001 | 2361 | 40 |
1751484 | 1751484 | 2021-09-24 | Barbour | West Virginia | 54001 | 2352 | 40 |
1748235 | 1748235 | 2021-09-23 | Barbour | West Virginia | 54001 | 2323 | 40 |
1744985 | 1744985 | 2021-09-22 | Barbour | West Virginia | 54001 | 2310 | 40 |
1741736 | 1741736 | 2021-09-21 | Barbour | West Virginia | 54001 | 2296 | 40 |
1738487 | 1738487 | 2021-09-20 | Barbour | West Virginia | 54001 | 2281 | 40 |
1735238 | 1735238 | 2021-09-19 | Barbour | West Virginia | 54001 | 2275 | 39 |
1731988 | 1731988 | 2021-09-18 | Barbour | West Virginia | 54001 | 2268 | 39 |
1728738 | 1728738 | 2021-09-17 | Barbour | West Virginia | 54001 | 2249 | 39 |
1725488 | 1725488 | 2021-09-16 | Barbour | West Virginia | 54001 | 2217 | 37 |
1722239 | 1722239 | 2021-09-15 | Barbour | West Virginia | 54001 | 2207 | 37 |
1718991 | 1718991 | 2021-09-14 | Barbour | West Virginia | 54001 | 2175 | 37 |
1715743 | 1715743 | 2021-09-13 | Barbour | West Virginia | 54001 | 2162 | 37 |
1712497 | 1712497 | 2021-09-12 | Barbour | West Virginia | 54001 | 2156 | 37 |
1709250 | 1709250 | 2021-09-11 | Barbour | West Virginia | 54001 | 2152 | 37 |
1706003 | 1706003 | 2021-09-10 | Barbour | West Virginia | 54001 | 2133 | 37 |
1702753 | 1702753 | 2021-09-09 | Barbour | West Virginia | 54001 | 2115 | 35 |
1699504 | 1699504 | 2021-09-08 | Barbour | West Virginia | 54001 | 2096 | 35 |
1696256 | 1696256 | 2021-09-07 | Barbour | West Virginia | 54001 | 2080 | 35 |
1693008 | 1693008 | 2021-09-06 | Barbour | West Virginia | 54001 | 2070 | 35 |
1689759 | 1689759 | 2021-09-05 | Barbour | West Virginia | 54001 | 2055 | 35 |
1686509 | 1686509 | 2021-09-04 | Barbour | West Virginia | 54001 | 2042 | 35 |
1683258 | 1683258 | 2021-09-03 | Barbour | West Virginia | 54001 | 2018 | 35 |
1680008 | 1680008 | 2021-09-02 | Barbour | West Virginia | 54001 | 2016 | 35 |
1676760 | 1676760 | 2021-09-01 | Barbour | West Virginia | 54001 | 1994 | 35 |
1673513 | 1673513 | 2021-08-31 | Barbour | West Virginia | 54001 | 1966 | 34 |
1670265 | 1670265 | 2021-08-30 | Barbour | West Virginia | 54001 | 1947 | 34 |
1667018 | 1667018 | 2021-08-29 | Barbour | West Virginia | 54001 | 1937 | 34 |
1663770 | 1663770 | 2021-08-28 | Barbour | West Virginia | 54001 | 1873 | 34 |
1660522 | 1660522 | 2021-08-27 | Barbour | West Virginia | 54001 | 1873 | 34 |
1657274 | 1657274 | 2021-08-26 | Barbour | West Virginia | 54001 | 1839 | 34 |
1654026 | 1654026 | 2021-08-25 | Barbour | West Virginia | 54001 | 1808 | 34 |
1650780 | 1650780 | 2021-08-24 | Barbour | West Virginia | 54001 | 1789 | 34 |
1647531 | 1647531 | 2021-08-23 | Barbour | West Virginia | 54001 | 1783 | 34 |
1644282 | 1644282 | 2021-08-22 | Barbour | West Virginia | 54001 | 1727 | 34 |
1641032 | 1641032 | 2021-08-21 | Barbour | West Virginia | 54001 | 1727 | 34 |
1637782 | 1637782 | 2021-08-20 | Barbour | West Virginia | 54001 | 1727 | 34 |
1634532 | 1634532 | 2021-08-19 | Barbour | West Virginia | 54001 | 1707 | 34 |
1631284 | 1631284 | 2021-08-18 | Barbour | West Virginia | 54001 | 1672 | 34 |
1628037 | 1628037 | 2021-08-17 | Barbour | West Virginia | 54001 | 1648 | 34 |
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);