ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 54107 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 |
---|---|---|---|---|---|---|---|
1719044 | 1719044 | 2021-09-14 | Wood | West Virginia | 54107 | 10355 | 190 |
1715796 | 1715796 | 2021-09-13 | Wood | West Virginia | 54107 | 10262 | 189 |
1712550 | 1712550 | 2021-09-12 | Wood | West Virginia | 54107 | 10196 | 186 |
1709303 | 1709303 | 2021-09-11 | Wood | West Virginia | 54107 | 10113 | 186 |
1706056 | 1706056 | 2021-09-10 | Wood | West Virginia | 54107 | 9977 | 186 |
1702807 | 1702807 | 2021-09-09 | Wood | West Virginia | 54107 | 9882 | 185 |
1699557 | 1699557 | 2021-09-08 | Wood | West Virginia | 54107 | 9786 | 184 |
1696309 | 1696309 | 2021-09-07 | Wood | West Virginia | 54107 | 9710 | 184 |
1693061 | 1693061 | 2021-09-06 | Wood | West Virginia | 54107 | 9647 | 184 |
1689812 | 1689812 | 2021-09-05 | Wood | West Virginia | 54107 | 9600 | 184 |
1686562 | 1686562 | 2021-09-04 | Wood | West Virginia | 54107 | 9477 | 184 |
1683312 | 1683312 | 2021-09-03 | Wood | West Virginia | 54107 | 9362 | 183 |
1680061 | 1680061 | 2021-09-02 | Wood | West Virginia | 54107 | 9269 | 184 |
1676813 | 1676813 | 2021-09-01 | Wood | West Virginia | 54107 | 9171 | 183 |
1673566 | 1673566 | 2021-08-31 | Wood | West Virginia | 54107 | 9086 | 182 |
1670318 | 1670318 | 2021-08-30 | Wood | West Virginia | 54107 | 9043 | 182 |
1667071 | 1667071 | 2021-08-29 | Wood | West Virginia | 54107 | 8980 | 181 |
1663823 | 1663823 | 2021-08-28 | Wood | West Virginia | 54107 | 8900 | 180 |
1660575 | 1660575 | 2021-08-27 | Wood | West Virginia | 54107 | 8900 | 180 |
1657327 | 1657327 | 2021-08-26 | Wood | West Virginia | 54107 | 8825 | 180 |
1654079 | 1654079 | 2021-08-25 | Wood | West Virginia | 54107 | 8781 | 180 |
1650833 | 1650833 | 2021-08-24 | Wood | West Virginia | 54107 | 8736 | 180 |
1647584 | 1647584 | 2021-08-23 | Wood | West Virginia | 54107 | 8690 | 180 |
1644335 | 1644335 | 2021-08-22 | Wood | West Virginia | 54107 | 8600 | 180 |
1641085 | 1641085 | 2021-08-21 | Wood | West Virginia | 54107 | 8600 | 180 |
1637835 | 1637835 | 2021-08-20 | Wood | West Virginia | 54107 | 8600 | 180 |
1634585 | 1634585 | 2021-08-19 | Wood | West Virginia | 54107 | 8539 | 178 |
1631337 | 1631337 | 2021-08-18 | Wood | West Virginia | 54107 | 8483 | 177 |
1628090 | 1628090 | 2021-08-17 | Wood | West Virginia | 54107 | 8432 | 177 |
1624843 | 1624843 | 2021-08-16 | Wood | West Virginia | 54107 | 8363 | 177 |
1621596 | 1621596 | 2021-08-15 | Wood | West Virginia | 54107 | 8285 | 177 |
1618348 | 1618348 | 2021-08-14 | Wood | West Virginia | 54107 | 8285 | 177 |
1615100 | 1615100 | 2021-08-13 | Wood | West Virginia | 54107 | 8285 | 177 |
1611851 | 1611851 | 2021-08-12 | Wood | West Virginia | 54107 | 8276 | 177 |
1608604 | 1608604 | 2021-08-11 | Wood | West Virginia | 54107 | 8257 | 177 |
1605355 | 1605355 | 2021-08-10 | Wood | West Virginia | 54107 | 8234 | 177 |
1602105 | 1602105 | 2021-08-09 | Wood | West Virginia | 54107 | 8205 | 177 |
1598857 | 1598857 | 2021-08-08 | Wood | West Virginia | 54107 | 8148 | 177 |
1595608 | 1595608 | 2021-08-07 | Wood | West Virginia | 54107 | 8148 | 177 |
1592359 | 1592359 | 2021-08-06 | Wood | West Virginia | 54107 | 8148 | 177 |
1589110 | 1589110 | 2021-08-05 | Wood | West Virginia | 54107 | 8124 | 177 |
1585861 | 1585861 | 2021-08-04 | Wood | West Virginia | 54107 | 8114 | 177 |
1582611 | 1582611 | 2021-08-03 | Wood | West Virginia | 54107 | 8095 | 177 |
1579361 | 1579361 | 2021-08-02 | Wood | West Virginia | 54107 | 8081 | 177 |
1576113 | 1576113 | 2021-08-01 | Wood | West Virginia | 54107 | 8050 | 177 |
1572865 | 1572865 | 2021-07-31 | Wood | West Virginia | 54107 | 8050 | 177 |
1569617 | 1569617 | 2021-07-30 | Wood | West Virginia | 54107 | 8050 | 177 |
1566369 | 1566369 | 2021-07-29 | Wood | West Virginia | 54107 | 8044 | 177 |
1563121 | 1563121 | 2021-07-28 | Wood | West Virginia | 54107 | 8033 | 177 |
1559873 | 1559873 | 2021-07-27 | Wood | West Virginia | 54107 | 8026 | 177 |
1556626 | 1556626 | 2021-07-26 | Wood | West Virginia | 54107 | 8021 | 177 |
1553379 | 1553379 | 2021-07-25 | Wood | West Virginia | 54107 | 8005 | 177 |
1550132 | 1550132 | 2021-07-24 | Wood | West Virginia | 54107 | 8005 | 177 |
1546885 | 1546885 | 2021-07-23 | Wood | West Virginia | 54107 | 8005 | 177 |
1543638 | 1543638 | 2021-07-22 | Wood | West Virginia | 54107 | 7993 | 177 |
1540390 | 1540390 | 2021-07-21 | Wood | West Virginia | 54107 | 7989 | 176 |
1537143 | 1537143 | 2021-07-20 | Wood | West Virginia | 54107 | 7984 | 176 |
1533895 | 1533895 | 2021-07-19 | Wood | West Virginia | 54107 | 7979 | 176 |
1530648 | 1530648 | 2021-07-18 | Wood | West Virginia | 54107 | 7967 | 176 |
1527401 | 1527401 | 2021-07-17 | Wood | West Virginia | 54107 | 7967 | 176 |
1524154 | 1524154 | 2021-07-16 | Wood | West Virginia | 54107 | 7967 | 176 |
1520906 | 1520906 | 2021-07-15 | Wood | West Virginia | 54107 | 7967 | 176 |
1517658 | 1517658 | 2021-07-14 | Wood | West Virginia | 54107 | 7967 | 176 |
1514411 | 1514411 | 2021-07-13 | Wood | West Virginia | 54107 | 7965 | 176 |
1511165 | 1511165 | 2021-07-12 | Wood | West Virginia | 54107 | 7965 | 176 |
1507918 | 1507918 | 2021-07-11 | Wood | West Virginia | 54107 | 7957 | 176 |
1504672 | 1504672 | 2021-07-10 | Wood | West Virginia | 54107 | 7957 | 176 |
1501426 | 1501426 | 2021-07-09 | Wood | West Virginia | 54107 | 7957 | 176 |
1498180 | 1498180 | 2021-07-08 | Wood | West Virginia | 54107 | 7957 | 176 |
1494933 | 1494933 | 2021-07-07 | Wood | West Virginia | 54107 | 7954 | 176 |
1491686 | 1491686 | 2021-07-06 | Wood | West Virginia | 54107 | 7953 | 176 |
1488439 | 1488439 | 2021-07-05 | Wood | West Virginia | 54107 | 7948 | 176 |
1485192 | 1485192 | 2021-07-04 | Wood | West Virginia | 54107 | 7948 | 176 |
1481946 | 1481946 | 2021-07-03 | Wood | West Virginia | 54107 | 7948 | 176 |
1478699 | 1478699 | 2021-07-02 | Wood | West Virginia | 54107 | 7948 | 176 |
1475453 | 1475453 | 2021-07-01 | Wood | West Virginia | 54107 | 7949 | 176 |
1472207 | 1472207 | 2021-06-30 | Wood | West Virginia | 54107 | 7948 | 176 |
1468962 | 1468962 | 2021-06-29 | Wood | West Virginia | 54107 | 7947 | 176 |
1465717 | 1465717 | 2021-06-28 | Wood | West Virginia | 54107 | 7944 | 176 |
1462472 | 1462472 | 2021-06-27 | Wood | West Virginia | 54107 | 7944 | 176 |
1459227 | 1459227 | 2021-06-26 | Wood | West Virginia | 54107 | 7944 | 176 |
1455982 | 1455982 | 2021-06-25 | Wood | West Virginia | 54107 | 7944 | 176 |
1452737 | 1452737 | 2021-06-24 | Wood | West Virginia | 54107 | 7943 | 176 |
1449491 | 1449491 | 2021-06-23 | Wood | West Virginia | 54107 | 7936 | 176 |
1446246 | 1446246 | 2021-06-22 | Wood | West Virginia | 54107 | 7930 | 176 |
1443001 | 1443001 | 2021-06-21 | Wood | West Virginia | 54107 | 7925 | 176 |
1439756 | 1439756 | 2021-06-20 | Wood | West Virginia | 54107 | 7925 | 176 |
1436509 | 1436509 | 2021-06-19 | Wood | West Virginia | 54107 | 7925 | 176 |
1433262 | 1433262 | 2021-06-18 | Wood | West Virginia | 54107 | 7925 | 176 |
1430016 | 1430016 | 2021-06-17 | Wood | West Virginia | 54107 | 7925 | 176 |
1426771 | 1426771 | 2021-06-16 | Wood | West Virginia | 54107 | 7923 | 176 |
1423525 | 1423525 | 2021-06-15 | Wood | West Virginia | 54107 | 7922 | 176 |
1420278 | 1420278 | 2021-06-14 | Wood | West Virginia | 54107 | 7921 | 176 |
1417033 | 1417033 | 2021-06-13 | Wood | West Virginia | 54107 | 7918 | 176 |
1413787 | 1413787 | 2021-06-12 | Wood | West Virginia | 54107 | 7918 | 176 |
1410542 | 1410542 | 2021-06-11 | Wood | West Virginia | 54107 | 7918 | 176 |
1407297 | 1407297 | 2021-06-10 | Wood | West Virginia | 54107 | 7917 | 176 |
1404051 | 1404051 | 2021-06-09 | Wood | West Virginia | 54107 | 7912 | 176 |
1400806 | 1400806 | 2021-06-08 | Wood | West Virginia | 54107 | 7912 | 175 |
1397561 | 1397561 | 2021-06-07 | Wood | West Virginia | 54107 | 7909 | 175 |
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);