ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 54035 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 |
---|---|---|---|---|---|---|---|
1949714 | 1949714 | 2021-11-24 | Jackson | West Virginia | 54035 | 4212 | 92 |
1946463 | 1946463 | 2021-11-23 | Jackson | West Virginia | 54035 | 4207 | 90 |
1943212 | 1943212 | 2021-11-22 | Jackson | West Virginia | 54035 | 4208 | 90 |
1939962 | 1939962 | 2021-11-21 | Jackson | West Virginia | 54035 | 4191 | 88 |
1936712 | 1936712 | 2021-11-20 | Jackson | West Virginia | 54035 | 4186 | 88 |
1933462 | 1933462 | 2021-11-19 | Jackson | West Virginia | 54035 | 4171 | 88 |
1930210 | 1930210 | 2021-11-18 | Jackson | West Virginia | 54035 | 4158 | 88 |
1926960 | 1926960 | 2021-11-17 | Jackson | West Virginia | 54035 | 4146 | 88 |
1923710 | 1923710 | 2021-11-16 | Jackson | West Virginia | 54035 | 4136 | 88 |
1920461 | 1920461 | 2021-11-15 | Jackson | West Virginia | 54035 | 4132 | 88 |
1917211 | 1917211 | 2021-11-14 | Jackson | West Virginia | 54035 | 4121 | 87 |
1913961 | 1913961 | 2021-11-13 | Jackson | West Virginia | 54035 | 4111 | 87 |
1910711 | 1910711 | 2021-11-12 | Jackson | West Virginia | 54035 | 4098 | 87 |
1907462 | 1907462 | 2021-11-11 | Jackson | West Virginia | 54035 | 4090 | 87 |
1904213 | 1904213 | 2021-11-10 | Jackson | West Virginia | 54035 | 4075 | 87 |
1900963 | 1900963 | 2021-11-09 | Jackson | West Virginia | 54035 | 4059 | 87 |
1897713 | 1897713 | 2021-11-08 | Jackson | West Virginia | 54035 | 4054 | 87 |
1894463 | 1894463 | 2021-11-07 | Jackson | West Virginia | 54035 | 4050 | 87 |
1891213 | 1891213 | 2021-11-06 | Jackson | West Virginia | 54035 | 4043 | 87 |
1887963 | 1887963 | 2021-11-05 | Jackson | West Virginia | 54035 | 4033 | 87 |
1884713 | 1884713 | 2021-11-04 | Jackson | West Virginia | 54035 | 4016 | 87 |
1881464 | 1881464 | 2021-11-03 | Jackson | West Virginia | 54035 | 4006 | 87 |
1878215 | 1878215 | 2021-11-02 | Jackson | West Virginia | 54035 | 3999 | 87 |
1874966 | 1874966 | 2021-11-01 | Jackson | West Virginia | 54035 | 3988 | 87 |
1871717 | 1871717 | 2021-10-31 | Jackson | West Virginia | 54035 | 3975 | 86 |
1868468 | 1868468 | 2021-10-30 | Jackson | West Virginia | 54035 | 3970 | 86 |
1865219 | 1865219 | 2021-10-29 | Jackson | West Virginia | 54035 | 3961 | 86 |
1861970 | 1861970 | 2021-10-28 | Jackson | West Virginia | 54035 | 3954 | 86 |
1858721 | 1858721 | 2021-10-27 | Jackson | West Virginia | 54035 | 3944 | 85 |
1855472 | 1855472 | 2021-10-26 | Jackson | West Virginia | 54035 | 3928 | 83 |
1852223 | 1852223 | 2021-10-25 | Jackson | West Virginia | 54035 | 3925 | 83 |
1848973 | 1848973 | 2021-10-24 | Jackson | West Virginia | 54035 | 3911 | 83 |
1845723 | 1845723 | 2021-10-23 | Jackson | West Virginia | 54035 | 3906 | 83 |
1842473 | 1842473 | 2021-10-22 | Jackson | West Virginia | 54035 | 3886 | 83 |
1839224 | 1839224 | 2021-10-21 | Jackson | West Virginia | 54035 | 3870 | 83 |
1835975 | 1835975 | 2021-10-20 | Jackson | West Virginia | 54035 | 3858 | 83 |
1832726 | 1832726 | 2021-10-19 | Jackson | West Virginia | 54035 | 3855 | 80 |
1829477 | 1829477 | 2021-10-18 | Jackson | West Virginia | 54035 | 3836 | 80 |
1826228 | 1826228 | 2021-10-17 | Jackson | West Virginia | 54035 | 3813 | 79 |
1822979 | 1822979 | 2021-10-16 | Jackson | West Virginia | 54035 | 3790 | 79 |
1819730 | 1819730 | 2021-10-15 | Jackson | West Virginia | 54035 | 3774 | 79 |
1816481 | 1816481 | 2021-10-14 | Jackson | West Virginia | 54035 | 3760 | 77 |
1813233 | 1813233 | 2021-10-13 | Jackson | West Virginia | 54035 | 3731 | 76 |
1809984 | 1809984 | 2021-10-12 | Jackson | West Virginia | 54035 | 3709 | 76 |
1806735 | 1806735 | 2021-10-11 | Jackson | West Virginia | 54035 | 3695 | 76 |
1803484 | 1803484 | 2021-10-10 | Jackson | West Virginia | 54035 | 3680 | 74 |
1800235 | 1800235 | 2021-10-09 | Jackson | West Virginia | 54035 | 3659 | 74 |
1796986 | 1796986 | 2021-10-08 | Jackson | West Virginia | 54035 | 3627 | 74 |
1793737 | 1793737 | 2021-10-07 | Jackson | West Virginia | 54035 | 3587 | 72 |
1790488 | 1790488 | 2021-10-06 | Jackson | West Virginia | 54035 | 3551 | 72 |
1787240 | 1787240 | 2021-10-05 | Jackson | West Virginia | 54035 | 3530 | 72 |
1783991 | 1783991 | 2021-10-04 | Jackson | West Virginia | 54035 | 3513 | 72 |
1780742 | 1780742 | 2021-10-03 | Jackson | West Virginia | 54035 | 3493 | 72 |
1777492 | 1777492 | 2021-10-02 | Jackson | West Virginia | 54035 | 3470 | 72 |
1774242 | 1774242 | 2021-10-01 | Jackson | West Virginia | 54035 | 3449 | 72 |
1770992 | 1770992 | 2021-09-30 | Jackson | West Virginia | 54035 | 3414 | 71 |
1767743 | 1767743 | 2021-09-29 | Jackson | West Virginia | 54035 | 3378 | 70 |
1764494 | 1764494 | 2021-09-28 | Jackson | West Virginia | 54035 | 3343 | 69 |
1761245 | 1761245 | 2021-09-27 | Jackson | West Virginia | 54035 | 3325 | 69 |
1757997 | 1757997 | 2021-09-26 | Jackson | West Virginia | 54035 | 3296 | 68 |
1754749 | 1754749 | 2021-09-25 | Jackson | West Virginia | 54035 | 3254 | 68 |
1751501 | 1751501 | 2021-09-24 | Jackson | West Virginia | 54035 | 3225 | 68 |
1748252 | 1748252 | 2021-09-23 | Jackson | West Virginia | 54035 | 3172 | 68 |
1745002 | 1745002 | 2021-09-22 | Jackson | West Virginia | 54035 | 3150 | 68 |
1741753 | 1741753 | 2021-09-21 | Jackson | West Virginia | 54035 | 3129 | 68 |
1738504 | 1738504 | 2021-09-20 | Jackson | West Virginia | 54035 | 3116 | 68 |
1735255 | 1735255 | 2021-09-19 | Jackson | West Virginia | 54035 | 3068 | 65 |
1732005 | 1732005 | 2021-09-18 | Jackson | West Virginia | 54035 | 3042 | 65 |
1728755 | 1728755 | 2021-09-17 | Jackson | West Virginia | 54035 | 2992 | 65 |
1725505 | 1725505 | 2021-09-16 | Jackson | West Virginia | 54035 | 2961 | 65 |
1722256 | 1722256 | 2021-09-15 | Jackson | West Virginia | 54035 | 2932 | 65 |
1719008 | 1719008 | 2021-09-14 | Jackson | West Virginia | 54035 | 2912 | 65 |
1715760 | 1715760 | 2021-09-13 | Jackson | West Virginia | 54035 | 2893 | 65 |
1712514 | 1712514 | 2021-09-12 | Jackson | West Virginia | 54035 | 2852 | 64 |
1709267 | 1709267 | 2021-09-11 | Jackson | West Virginia | 54035 | 2821 | 64 |
1706020 | 1706020 | 2021-09-10 | Jackson | West Virginia | 54035 | 2784 | 64 |
1702770 | 1702770 | 2021-09-09 | Jackson | West Virginia | 54035 | 2759 | 64 |
1699521 | 1699521 | 2021-09-08 | Jackson | West Virginia | 54035 | 2746 | 64 |
1696273 | 1696273 | 2021-09-07 | Jackson | West Virginia | 54035 | 2723 | 64 |
1693025 | 1693025 | 2021-09-06 | Jackson | West Virginia | 54035 | 2716 | 64 |
1689776 | 1689776 | 2021-09-05 | Jackson | West Virginia | 54035 | 2689 | 64 |
1686526 | 1686526 | 2021-09-04 | Jackson | West Virginia | 54035 | 2665 | 64 |
1683275 | 1683275 | 2021-09-03 | Jackson | West Virginia | 54035 | 2631 | 64 |
1680025 | 1680025 | 2021-09-02 | Jackson | West Virginia | 54035 | 2605 | 64 |
1676777 | 1676777 | 2021-09-01 | Jackson | West Virginia | 54035 | 2578 | 64 |
1673530 | 1673530 | 2021-08-31 | Jackson | West Virginia | 54035 | 2555 | 64 |
1670282 | 1670282 | 2021-08-30 | Jackson | West Virginia | 54035 | 2546 | 64 |
1667035 | 1667035 | 2021-08-29 | Jackson | West Virginia | 54035 | 2529 | 64 |
1663787 | 1663787 | 2021-08-28 | Jackson | West Virginia | 54035 | 2493 | 64 |
1660539 | 1660539 | 2021-08-27 | Jackson | West Virginia | 54035 | 2493 | 64 |
1657291 | 1657291 | 2021-08-26 | Jackson | West Virginia | 54035 | 2488 | 64 |
1654043 | 1654043 | 2021-08-25 | Jackson | West Virginia | 54035 | 2479 | 64 |
1650797 | 1650797 | 2021-08-24 | Jackson | West Virginia | 54035 | 2463 | 63 |
1647548 | 1647548 | 2021-08-23 | Jackson | West Virginia | 54035 | 2451 | 63 |
1644299 | 1644299 | 2021-08-22 | Jackson | West Virginia | 54035 | 2416 | 63 |
1641049 | 1641049 | 2021-08-21 | Jackson | West Virginia | 54035 | 2416 | 63 |
1637799 | 1637799 | 2021-08-20 | Jackson | West Virginia | 54035 | 2416 | 63 |
1634549 | 1634549 | 2021-08-19 | Jackson | West Virginia | 54035 | 2409 | 63 |
1631301 | 1631301 | 2021-08-18 | Jackson | West Virginia | 54035 | 2404 | 63 |
1628054 | 1628054 | 2021-08-17 | Jackson | West Virginia | 54035 | 2394 | 62 |
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);