ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
763 rows where county = "Monroe" 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 |
---|---|---|---|---|---|---|---|
1719022 | 1719022 | 2021-09-14 | Monroe | West Virginia | 54063 | 1759 | 19 |
1715774 | 1715774 | 2021-09-13 | Monroe | West Virginia | 54063 | 1752 | 19 |
1712528 | 1712528 | 2021-09-12 | Monroe | West Virginia | 54063 | 1742 | 19 |
1709281 | 1709281 | 2021-09-11 | Monroe | West Virginia | 54063 | 1719 | 19 |
1706034 | 1706034 | 2021-09-10 | Monroe | West Virginia | 54063 | 1693 | 19 |
1702784 | 1702784 | 2021-09-09 | Monroe | West Virginia | 54063 | 1673 | 19 |
1699535 | 1699535 | 2021-09-08 | Monroe | West Virginia | 54063 | 1658 | 19 |
1696287 | 1696287 | 2021-09-07 | Monroe | West Virginia | 54063 | 1647 | 19 |
1693039 | 1693039 | 2021-09-06 | Monroe | West Virginia | 54063 | 1642 | 19 |
1689790 | 1689790 | 2021-09-05 | Monroe | West Virginia | 54063 | 1620 | 19 |
1686540 | 1686540 | 2021-09-04 | Monroe | West Virginia | 54063 | 1599 | 19 |
1683289 | 1683289 | 2021-09-03 | Monroe | West Virginia | 54063 | 1569 | 19 |
1680039 | 1680039 | 2021-09-02 | Monroe | West Virginia | 54063 | 1556 | 20 |
1676791 | 1676791 | 2021-09-01 | Monroe | West Virginia | 54063 | 1541 | 20 |
1673544 | 1673544 | 2021-08-31 | Monroe | West Virginia | 54063 | 1516 | 19 |
1670296 | 1670296 | 2021-08-30 | Monroe | West Virginia | 54063 | 1508 | 19 |
1667049 | 1667049 | 2021-08-29 | Monroe | West Virginia | 54063 | 1479 | 19 |
1663801 | 1663801 | 2021-08-28 | Monroe | West Virginia | 54063 | 1417 | 19 |
1660553 | 1660553 | 2021-08-27 | Monroe | West Virginia | 54063 | 1417 | 19 |
1657305 | 1657305 | 2021-08-26 | Monroe | West Virginia | 54063 | 1404 | 19 |
1654057 | 1654057 | 2021-08-25 | Monroe | West Virginia | 54063 | 1383 | 18 |
1650811 | 1650811 | 2021-08-24 | Monroe | West Virginia | 54063 | 1347 | 18 |
1647562 | 1647562 | 2021-08-23 | Monroe | West Virginia | 54063 | 1340 | 18 |
1644313 | 1644313 | 2021-08-22 | Monroe | West Virginia | 54063 | 1315 | 18 |
1641063 | 1641063 | 2021-08-21 | Monroe | West Virginia | 54063 | 1315 | 18 |
1637813 | 1637813 | 2021-08-20 | Monroe | West Virginia | 54063 | 1315 | 18 |
1634563 | 1634563 | 2021-08-19 | Monroe | West Virginia | 54063 | 1304 | 18 |
1631315 | 1631315 | 2021-08-18 | Monroe | West Virginia | 54063 | 1292 | 18 |
1628068 | 1628068 | 2021-08-17 | Monroe | West Virginia | 54063 | 1286 | 18 |
1624821 | 1624821 | 2021-08-16 | Monroe | West Virginia | 54063 | 1281 | 18 |
1621574 | 1621574 | 2021-08-15 | Monroe | West Virginia | 54063 | 1275 | 18 |
1618326 | 1618326 | 2021-08-14 | Monroe | West Virginia | 54063 | 1275 | 18 |
1615078 | 1615078 | 2021-08-13 | Monroe | West Virginia | 54063 | 1275 | 18 |
1611829 | 1611829 | 2021-08-12 | Monroe | West Virginia | 54063 | 1273 | 18 |
1608582 | 1608582 | 2021-08-11 | Monroe | West Virginia | 54063 | 1269 | 18 |
1605333 | 1605333 | 2021-08-10 | Monroe | West Virginia | 54063 | 1268 | 18 |
1602083 | 1602083 | 2021-08-09 | Monroe | West Virginia | 54063 | 1262 | 18 |
1598835 | 1598835 | 2021-08-08 | Monroe | West Virginia | 54063 | 1251 | 18 |
1595586 | 1595586 | 2021-08-07 | Monroe | West Virginia | 54063 | 1251 | 18 |
1592337 | 1592337 | 2021-08-06 | Monroe | West Virginia | 54063 | 1251 | 18 |
1589088 | 1589088 | 2021-08-05 | Monroe | West Virginia | 54063 | 1249 | 18 |
1585839 | 1585839 | 2021-08-04 | Monroe | West Virginia | 54063 | 1249 | 18 |
1582589 | 1582589 | 2021-08-03 | Monroe | West Virginia | 54063 | 1245 | 18 |
1579339 | 1579339 | 2021-08-02 | Monroe | West Virginia | 54063 | 1245 | 18 |
1576091 | 1576091 | 2021-08-01 | Monroe | West Virginia | 54063 | 1242 | 18 |
1572843 | 1572843 | 2021-07-31 | Monroe | West Virginia | 54063 | 1242 | 18 |
1569595 | 1569595 | 2021-07-30 | Monroe | West Virginia | 54063 | 1242 | 18 |
1566347 | 1566347 | 2021-07-29 | Monroe | West Virginia | 54063 | 1241 | 18 |
1563099 | 1563099 | 2021-07-28 | Monroe | West Virginia | 54063 | 1238 | 18 |
1559851 | 1559851 | 2021-07-27 | Monroe | West Virginia | 54063 | 1236 | 18 |
1556604 | 1556604 | 2021-07-26 | Monroe | West Virginia | 54063 | 1234 | 18 |
1553357 | 1553357 | 2021-07-25 | Monroe | West Virginia | 54063 | 1229 | 18 |
1550110 | 1550110 | 2021-07-24 | Monroe | West Virginia | 54063 | 1229 | 18 |
1546863 | 1546863 | 2021-07-23 | Monroe | West Virginia | 54063 | 1229 | 18 |
1543616 | 1543616 | 2021-07-22 | Monroe | West Virginia | 54063 | 1229 | 18 |
1540368 | 1540368 | 2021-07-21 | Monroe | West Virginia | 54063 | 1229 | 18 |
1537121 | 1537121 | 2021-07-20 | Monroe | West Virginia | 54063 | 1227 | 18 |
1533873 | 1533873 | 2021-07-19 | Monroe | West Virginia | 54063 | 1226 | 18 |
1530626 | 1530626 | 2021-07-18 | Monroe | West Virginia | 54063 | 1226 | 18 |
1527379 | 1527379 | 2021-07-17 | Monroe | West Virginia | 54063 | 1226 | 18 |
1524132 | 1524132 | 2021-07-16 | Monroe | West Virginia | 54063 | 1226 | 18 |
1520884 | 1520884 | 2021-07-15 | Monroe | West Virginia | 54063 | 1226 | 18 |
1517636 | 1517636 | 2021-07-14 | Monroe | West Virginia | 54063 | 1226 | 18 |
1514389 | 1514389 | 2021-07-13 | Monroe | West Virginia | 54063 | 1226 | 18 |
1511143 | 1511143 | 2021-07-12 | Monroe | West Virginia | 54063 | 1227 | 18 |
1507896 | 1507896 | 2021-07-11 | Monroe | West Virginia | 54063 | 1227 | 18 |
1504650 | 1504650 | 2021-07-10 | Monroe | West Virginia | 54063 | 1227 | 18 |
1501404 | 1501404 | 2021-07-09 | Monroe | West Virginia | 54063 | 1227 | 18 |
1498158 | 1498158 | 2021-07-08 | Monroe | West Virginia | 54063 | 1226 | 17 |
1494911 | 1494911 | 2021-07-07 | Monroe | West Virginia | 54063 | 1226 | 17 |
1491664 | 1491664 | 2021-07-06 | Monroe | West Virginia | 54063 | 1226 | 17 |
1488417 | 1488417 | 2021-07-05 | Monroe | West Virginia | 54063 | 1223 | 17 |
1485170 | 1485170 | 2021-07-04 | Monroe | West Virginia | 54063 | 1223 | 17 |
1481924 | 1481924 | 2021-07-03 | Monroe | West Virginia | 54063 | 1223 | 17 |
1478677 | 1478677 | 2021-07-02 | Monroe | West Virginia | 54063 | 1223 | 17 |
1475431 | 1475431 | 2021-07-01 | Monroe | West Virginia | 54063 | 1223 | 17 |
1472185 | 1472185 | 2021-06-30 | Monroe | West Virginia | 54063 | 1223 | 17 |
1468940 | 1468940 | 2021-06-29 | Monroe | West Virginia | 54063 | 1221 | 17 |
1465695 | 1465695 | 2021-06-28 | Monroe | West Virginia | 54063 | 1221 | 17 |
1462450 | 1462450 | 2021-06-27 | Monroe | West Virginia | 54063 | 1220 | 17 |
1459205 | 1459205 | 2021-06-26 | Monroe | West Virginia | 54063 | 1220 | 17 |
1455960 | 1455960 | 2021-06-25 | Monroe | West Virginia | 54063 | 1220 | 17 |
1452715 | 1452715 | 2021-06-24 | Monroe | West Virginia | 54063 | 1218 | 17 |
1449469 | 1449469 | 2021-06-23 | Monroe | West Virginia | 54063 | 1217 | 17 |
1446224 | 1446224 | 2021-06-22 | Monroe | West Virginia | 54063 | 1218 | 17 |
1442979 | 1442979 | 2021-06-21 | Monroe | West Virginia | 54063 | 1207 | 17 |
1439734 | 1439734 | 2021-06-20 | Monroe | West Virginia | 54063 | 1207 | 17 |
1436487 | 1436487 | 2021-06-19 | Monroe | West Virginia | 54063 | 1207 | 17 |
1433240 | 1433240 | 2021-06-18 | Monroe | West Virginia | 54063 | 1207 | 17 |
1429994 | 1429994 | 2021-06-17 | Monroe | West Virginia | 54063 | 1207 | 17 |
1426749 | 1426749 | 2021-06-16 | Monroe | West Virginia | 54063 | 1204 | 17 |
1423503 | 1423503 | 2021-06-15 | Monroe | West Virginia | 54063 | 1203 | 17 |
1420256 | 1420256 | 2021-06-14 | Monroe | West Virginia | 54063 | 1203 | 17 |
1417011 | 1417011 | 2021-06-13 | Monroe | West Virginia | 54063 | 1197 | 17 |
1413765 | 1413765 | 2021-06-12 | Monroe | West Virginia | 54063 | 1197 | 17 |
1410520 | 1410520 | 2021-06-11 | Monroe | West Virginia | 54063 | 1197 | 17 |
1407275 | 1407275 | 2021-06-10 | Monroe | West Virginia | 54063 | 1194 | 17 |
1404029 | 1404029 | 2021-06-09 | Monroe | West Virginia | 54063 | 1193 | 17 |
1400784 | 1400784 | 2021-06-08 | Monroe | West Virginia | 54063 | 1191 | 17 |
1397539 | 1397539 | 2021-06-07 | Monroe | West Virginia | 54063 | 1190 | 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);