ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
762 rows where county = "Grant" 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 |
---|---|---|---|---|---|---|---|
1719002 | 1719002 | 2021-09-14 | Grant | West Virginia | 54023 | 1693 | 30 |
1715754 | 1715754 | 2021-09-13 | Grant | West Virginia | 54023 | 1684 | 30 |
1712508 | 1712508 | 2021-09-12 | Grant | West Virginia | 54023 | 1651 | 30 |
1709261 | 1709261 | 2021-09-11 | Grant | West Virginia | 54023 | 1630 | 30 |
1706014 | 1706014 | 2021-09-10 | Grant | West Virginia | 54023 | 1613 | 30 |
1702764 | 1702764 | 2021-09-09 | Grant | West Virginia | 54023 | 1584 | 30 |
1699515 | 1699515 | 2021-09-08 | Grant | West Virginia | 54023 | 1574 | 30 |
1696267 | 1696267 | 2021-09-07 | Grant | West Virginia | 54023 | 1561 | 29 |
1693019 | 1693019 | 2021-09-06 | Grant | West Virginia | 54023 | 1544 | 29 |
1689770 | 1689770 | 2021-09-05 | Grant | West Virginia | 54023 | 1533 | 29 |
1686520 | 1686520 | 2021-09-04 | Grant | West Virginia | 54023 | 1512 | 29 |
1683269 | 1683269 | 2021-09-03 | Grant | West Virginia | 54023 | 1491 | 29 |
1680019 | 1680019 | 2021-09-02 | Grant | West Virginia | 54023 | 1482 | 29 |
1676771 | 1676771 | 2021-09-01 | Grant | West Virginia | 54023 | 1462 | 29 |
1673524 | 1673524 | 2021-08-31 | Grant | West Virginia | 54023 | 1445 | 29 |
1670276 | 1670276 | 2021-08-30 | Grant | West Virginia | 54023 | 1443 | 29 |
1667029 | 1667029 | 2021-08-29 | Grant | West Virginia | 54023 | 1434 | 29 |
1663781 | 1663781 | 2021-08-28 | Grant | West Virginia | 54023 | 1400 | 29 |
1660533 | 1660533 | 2021-08-27 | Grant | West Virginia | 54023 | 1400 | 29 |
1657285 | 1657285 | 2021-08-26 | Grant | West Virginia | 54023 | 1393 | 29 |
1654037 | 1654037 | 2021-08-25 | Grant | West Virginia | 54023 | 1388 | 29 |
1650791 | 1650791 | 2021-08-24 | Grant | West Virginia | 54023 | 1387 | 29 |
1647542 | 1647542 | 2021-08-23 | Grant | West Virginia | 54023 | 1383 | 29 |
1644293 | 1644293 | 2021-08-22 | Grant | West Virginia | 54023 | 1372 | 29 |
1641043 | 1641043 | 2021-08-21 | Grant | West Virginia | 54023 | 1372 | 29 |
1637793 | 1637793 | 2021-08-20 | Grant | West Virginia | 54023 | 1372 | 29 |
1634543 | 1634543 | 2021-08-19 | Grant | West Virginia | 54023 | 1369 | 29 |
1631295 | 1631295 | 2021-08-18 | Grant | West Virginia | 54023 | 1365 | 29 |
1628048 | 1628048 | 2021-08-17 | Grant | West Virginia | 54023 | 1360 | 29 |
1624801 | 1624801 | 2021-08-16 | Grant | West Virginia | 54023 | 1352 | 29 |
1621554 | 1621554 | 2021-08-15 | Grant | West Virginia | 54023 | 1345 | 29 |
1618306 | 1618306 | 2021-08-14 | Grant | West Virginia | 54023 | 1345 | 29 |
1615058 | 1615058 | 2021-08-13 | Grant | West Virginia | 54023 | 1345 | 29 |
1611809 | 1611809 | 2021-08-12 | Grant | West Virginia | 54023 | 1342 | 29 |
1608562 | 1608562 | 2021-08-11 | Grant | West Virginia | 54023 | 1340 | 29 |
1605313 | 1605313 | 2021-08-10 | Grant | West Virginia | 54023 | 1338 | 29 |
1602063 | 1602063 | 2021-08-09 | Grant | West Virginia | 54023 | 1337 | 29 |
1598815 | 1598815 | 2021-08-08 | Grant | West Virginia | 54023 | 1331 | 29 |
1595566 | 1595566 | 2021-08-07 | Grant | West Virginia | 54023 | 1331 | 29 |
1592317 | 1592317 | 2021-08-06 | Grant | West Virginia | 54023 | 1331 | 29 |
1589068 | 1589068 | 2021-08-05 | Grant | West Virginia | 54023 | 1329 | 29 |
1585819 | 1585819 | 2021-08-04 | Grant | West Virginia | 54023 | 1328 | 29 |
1582569 | 1582569 | 2021-08-03 | Grant | West Virginia | 54023 | 1325 | 29 |
1579319 | 1579319 | 2021-08-02 | Grant | West Virginia | 54023 | 1325 | 29 |
1576071 | 1576071 | 2021-08-01 | Grant | West Virginia | 54023 | 1324 | 29 |
1572823 | 1572823 | 2021-07-31 | Grant | West Virginia | 54023 | 1324 | 29 |
1569575 | 1569575 | 2021-07-30 | Grant | West Virginia | 54023 | 1324 | 29 |
1566327 | 1566327 | 2021-07-29 | Grant | West Virginia | 54023 | 1322 | 29 |
1563079 | 1563079 | 2021-07-28 | Grant | West Virginia | 54023 | 1320 | 29 |
1559831 | 1559831 | 2021-07-27 | Grant | West Virginia | 54023 | 1320 | 29 |
1556584 | 1556584 | 2021-07-26 | Grant | West Virginia | 54023 | 1320 | 29 |
1553337 | 1553337 | 2021-07-25 | Grant | West Virginia | 54023 | 1322 | 29 |
1550090 | 1550090 | 2021-07-24 | Grant | West Virginia | 54023 | 1322 | 29 |
1546843 | 1546843 | 2021-07-23 | Grant | West Virginia | 54023 | 1322 | 29 |
1543596 | 1543596 | 2021-07-22 | Grant | West Virginia | 54023 | 1321 | 28 |
1540348 | 1540348 | 2021-07-21 | Grant | West Virginia | 54023 | 1319 | 28 |
1537101 | 1537101 | 2021-07-20 | Grant | West Virginia | 54023 | 1319 | 28 |
1533853 | 1533853 | 2021-07-19 | Grant | West Virginia | 54023 | 1319 | 28 |
1530606 | 1530606 | 2021-07-18 | Grant | West Virginia | 54023 | 1319 | 28 |
1527359 | 1527359 | 2021-07-17 | Grant | West Virginia | 54023 | 1319 | 28 |
1524112 | 1524112 | 2021-07-16 | Grant | West Virginia | 54023 | 1319 | 28 |
1520864 | 1520864 | 2021-07-15 | Grant | West Virginia | 54023 | 1319 | 28 |
1517616 | 1517616 | 2021-07-14 | Grant | West Virginia | 54023 | 1319 | 28 |
1514369 | 1514369 | 2021-07-13 | Grant | West Virginia | 54023 | 1318 | 28 |
1511123 | 1511123 | 2021-07-12 | Grant | West Virginia | 54023 | 1318 | 28 |
1507876 | 1507876 | 2021-07-11 | Grant | West Virginia | 54023 | 1316 | 28 |
1504630 | 1504630 | 2021-07-10 | Grant | West Virginia | 54023 | 1316 | 28 |
1501384 | 1501384 | 2021-07-09 | Grant | West Virginia | 54023 | 1316 | 28 |
1498138 | 1498138 | 2021-07-08 | Grant | West Virginia | 54023 | 1316 | 28 |
1494891 | 1494891 | 2021-07-07 | Grant | West Virginia | 54023 | 1317 | 28 |
1491644 | 1491644 | 2021-07-06 | Grant | West Virginia | 54023 | 1317 | 28 |
1488397 | 1488397 | 2021-07-05 | Grant | West Virginia | 54023 | 1317 | 28 |
1485150 | 1485150 | 2021-07-04 | Grant | West Virginia | 54023 | 1317 | 28 |
1481904 | 1481904 | 2021-07-03 | Grant | West Virginia | 54023 | 1317 | 28 |
1478657 | 1478657 | 2021-07-02 | Grant | West Virginia | 54023 | 1317 | 28 |
1475411 | 1475411 | 2021-07-01 | Grant | West Virginia | 54023 | 1316 | 28 |
1472165 | 1472165 | 2021-06-30 | Grant | West Virginia | 54023 | 1315 | 28 |
1468920 | 1468920 | 2021-06-29 | Grant | West Virginia | 54023 | 1312 | 28 |
1465675 | 1465675 | 2021-06-28 | Grant | West Virginia | 54023 | 1311 | 28 |
1462430 | 1462430 | 2021-06-27 | Grant | West Virginia | 54023 | 1309 | 28 |
1459185 | 1459185 | 2021-06-26 | Grant | West Virginia | 54023 | 1309 | 28 |
1455940 | 1455940 | 2021-06-25 | Grant | West Virginia | 54023 | 1309 | 28 |
1452695 | 1452695 | 2021-06-24 | Grant | West Virginia | 54023 | 1309 | 28 |
1449449 | 1449449 | 2021-06-23 | Grant | West Virginia | 54023 | 1309 | 28 |
1446204 | 1446204 | 2021-06-22 | Grant | West Virginia | 54023 | 1307 | 28 |
1442959 | 1442959 | 2021-06-21 | Grant | West Virginia | 54023 | 1307 | 28 |
1439714 | 1439714 | 2021-06-20 | Grant | West Virginia | 54023 | 1307 | 28 |
1436467 | 1436467 | 2021-06-19 | Grant | West Virginia | 54023 | 1307 | 28 |
1433220 | 1433220 | 2021-06-18 | Grant | West Virginia | 54023 | 1307 | 28 |
1429974 | 1429974 | 2021-06-17 | Grant | West Virginia | 54023 | 1307 | 28 |
1426729 | 1426729 | 2021-06-16 | Grant | West Virginia | 54023 | 1307 | 28 |
1423483 | 1423483 | 2021-06-15 | Grant | West Virginia | 54023 | 1306 | 28 |
1420236 | 1420236 | 2021-06-14 | Grant | West Virginia | 54023 | 1306 | 28 |
1416991 | 1416991 | 2021-06-13 | Grant | West Virginia | 54023 | 1305 | 27 |
1413745 | 1413745 | 2021-06-12 | Grant | West Virginia | 54023 | 1305 | 27 |
1410500 | 1410500 | 2021-06-11 | Grant | West Virginia | 54023 | 1305 | 27 |
1407255 | 1407255 | 2021-06-10 | Grant | West Virginia | 54023 | 1304 | 27 |
1404009 | 1404009 | 2021-06-09 | Grant | West Virginia | 54023 | 1304 | 27 |
1400764 | 1400764 | 2021-06-08 | Grant | West Virginia | 54023 | 1301 | 27 |
1397519 | 1397519 | 2021-06-07 | Grant | West Virginia | 54023 | 1300 | 27 |
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);