ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Jackson" 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 |
---|---|---|---|---|---|---|---|
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 |
1624807 | 1624807 | 2021-08-16 | Jackson | West Virginia | 54035 | 2380 | 62 |
1621560 | 1621560 | 2021-08-15 | Jackson | West Virginia | 54035 | 2373 | 62 |
1618312 | 1618312 | 2021-08-14 | Jackson | West Virginia | 54035 | 2373 | 62 |
1615064 | 1615064 | 2021-08-13 | Jackson | West Virginia | 54035 | 2373 | 62 |
1611815 | 1611815 | 2021-08-12 | Jackson | West Virginia | 54035 | 2370 | 62 |
1608568 | 1608568 | 2021-08-11 | Jackson | West Virginia | 54035 | 2360 | 62 |
1605319 | 1605319 | 2021-08-10 | Jackson | West Virginia | 54035 | 2358 | 62 |
1602069 | 1602069 | 2021-08-09 | Jackson | West Virginia | 54035 | 2350 | 62 |
1598821 | 1598821 | 2021-08-08 | Jackson | West Virginia | 54035 | 2338 | 62 |
1595572 | 1595572 | 2021-08-07 | Jackson | West Virginia | 54035 | 2338 | 62 |
1592323 | 1592323 | 2021-08-06 | Jackson | West Virginia | 54035 | 2338 | 62 |
1589074 | 1589074 | 2021-08-05 | Jackson | West Virginia | 54035 | 2327 | 62 |
1585825 | 1585825 | 2021-08-04 | Jackson | West Virginia | 54035 | 2320 | 62 |
1582575 | 1582575 | 2021-08-03 | Jackson | West Virginia | 54035 | 2313 | 62 |
1579325 | 1579325 | 2021-08-02 | Jackson | West Virginia | 54035 | 2310 | 62 |
1576077 | 1576077 | 2021-08-01 | Jackson | West Virginia | 54035 | 2299 | 62 |
1572829 | 1572829 | 2021-07-31 | Jackson | West Virginia | 54035 | 2299 | 62 |
1569581 | 1569581 | 2021-07-30 | Jackson | West Virginia | 54035 | 2299 | 62 |
1566333 | 1566333 | 2021-07-29 | Jackson | West Virginia | 54035 | 2296 | 62 |
1563085 | 1563085 | 2021-07-28 | Jackson | West Virginia | 54035 | 2293 | 62 |
1559837 | 1559837 | 2021-07-27 | Jackson | West Virginia | 54035 | 2291 | 62 |
1556590 | 1556590 | 2021-07-26 | Jackson | West Virginia | 54035 | 2287 | 62 |
1553343 | 1553343 | 2021-07-25 | Jackson | West Virginia | 54035 | 2283 | 62 |
1550096 | 1550096 | 2021-07-24 | Jackson | West Virginia | 54035 | 2283 | 62 |
1546849 | 1546849 | 2021-07-23 | Jackson | West Virginia | 54035 | 2283 | 62 |
1543602 | 1543602 | 2021-07-22 | Jackson | West Virginia | 54035 | 2280 | 62 |
1540354 | 1540354 | 2021-07-21 | Jackson | West Virginia | 54035 | 2278 | 61 |
1537107 | 1537107 | 2021-07-20 | Jackson | West Virginia | 54035 | 2278 | 61 |
1533859 | 1533859 | 2021-07-19 | Jackson | West Virginia | 54035 | 2276 | 61 |
1530612 | 1530612 | 2021-07-18 | Jackson | West Virginia | 54035 | 2272 | 61 |
1527365 | 1527365 | 2021-07-17 | Jackson | West Virginia | 54035 | 2272 | 61 |
1524118 | 1524118 | 2021-07-16 | Jackson | West Virginia | 54035 | 2272 | 61 |
1520870 | 1520870 | 2021-07-15 | Jackson | West Virginia | 54035 | 2271 | 61 |
1517622 | 1517622 | 2021-07-14 | Jackson | West Virginia | 54035 | 2270 | 61 |
1514375 | 1514375 | 2021-07-13 | Jackson | West Virginia | 54035 | 2269 | 61 |
1511129 | 1511129 | 2021-07-12 | Jackson | West Virginia | 54035 | 2269 | 61 |
1507882 | 1507882 | 2021-07-11 | Jackson | West Virginia | 54035 | 2268 | 61 |
1504636 | 1504636 | 2021-07-10 | Jackson | West Virginia | 54035 | 2268 | 61 |
1501390 | 1501390 | 2021-07-09 | Jackson | West Virginia | 54035 | 2268 | 61 |
1498144 | 1498144 | 2021-07-08 | Jackson | West Virginia | 54035 | 2268 | 61 |
1494897 | 1494897 | 2021-07-07 | Jackson | West Virginia | 54035 | 2265 | 61 |
1491650 | 1491650 | 2021-07-06 | Jackson | West Virginia | 54035 | 2265 | 61 |
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);