ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where fips = 54031 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 |
---|---|---|---|---|---|---|---|
1420240 | 1420240 | 2021-06-14 | Hardy | West Virginia | 54031 | 1564 | 24 |
1416995 | 1416995 | 2021-06-13 | Hardy | West Virginia | 54031 | 1562 | 24 |
1413749 | 1413749 | 2021-06-12 | Hardy | West Virginia | 54031 | 1562 | 24 |
1410504 | 1410504 | 2021-06-11 | Hardy | West Virginia | 54031 | 1562 | 24 |
1407259 | 1407259 | 2021-06-10 | Hardy | West Virginia | 54031 | 1562 | 24 |
1404013 | 1404013 | 2021-06-09 | Hardy | West Virginia | 54031 | 1563 | 24 |
1400768 | 1400768 | 2021-06-08 | Hardy | West Virginia | 54031 | 1563 | 24 |
1397523 | 1397523 | 2021-06-07 | Hardy | West Virginia | 54031 | 1561 | 24 |
1394276 | 1394276 | 2021-06-06 | Hardy | West Virginia | 54031 | 1557 | 24 |
1391031 | 1391031 | 2021-06-05 | Hardy | West Virginia | 54031 | 1557 | 24 |
1387786 | 1387786 | 2021-06-04 | Hardy | West Virginia | 54031 | 1557 | 24 |
1384541 | 1384541 | 2021-06-03 | Hardy | West Virginia | 54031 | 1556 | 24 |
1381295 | 1381295 | 2021-06-02 | Hardy | West Virginia | 54031 | 1553 | 24 |
1378050 | 1378050 | 2021-06-01 | Hardy | West Virginia | 54031 | 1553 | 24 |
1374804 | 1374804 | 2021-05-31 | Hardy | West Virginia | 54031 | 1552 | 24 |
1371559 | 1371559 | 2021-05-30 | Hardy | West Virginia | 54031 | 1552 | 24 |
1368313 | 1368313 | 2021-05-29 | Hardy | West Virginia | 54031 | 1552 | 24 |
1365067 | 1365067 | 2021-05-28 | Hardy | West Virginia | 54031 | 1552 | 24 |
1361821 | 1361821 | 2021-05-27 | Hardy | West Virginia | 54031 | 1552 | 24 |
1358575 | 1358575 | 2021-05-26 | Hardy | West Virginia | 54031 | 1553 | 24 |
1355329 | 1355329 | 2021-05-25 | Hardy | West Virginia | 54031 | 1553 | 24 |
1352083 | 1352083 | 2021-05-24 | Hardy | West Virginia | 54031 | 1554 | 24 |
1348837 | 1348837 | 2021-05-23 | Hardy | West Virginia | 54031 | 1550 | 24 |
1345589 | 1345589 | 2021-05-22 | Hardy | West Virginia | 54031 | 1550 | 24 |
1342341 | 1342341 | 2021-05-21 | Hardy | West Virginia | 54031 | 1550 | 24 |
1339093 | 1339093 | 2021-05-20 | Hardy | West Virginia | 54031 | 1545 | 24 |
1335846 | 1335846 | 2021-05-19 | Hardy | West Virginia | 54031 | 1541 | 24 |
1332599 | 1332599 | 2021-05-18 | Hardy | West Virginia | 54031 | 1535 | 24 |
1329352 | 1329352 | 2021-05-17 | Hardy | West Virginia | 54031 | 1532 | 24 |
1326106 | 1326106 | 2021-05-16 | Hardy | West Virginia | 54031 | 1533 | 24 |
1322860 | 1322860 | 2021-05-15 | Hardy | West Virginia | 54031 | 1531 | 24 |
1319614 | 1319614 | 2021-05-14 | Hardy | West Virginia | 54031 | 1530 | 24 |
1316366 | 1316366 | 2021-05-13 | Hardy | West Virginia | 54031 | 1529 | 24 |
1313120 | 1313120 | 2021-05-12 | Hardy | West Virginia | 54031 | 1528 | 24 |
1309873 | 1309873 | 2021-05-11 | Hardy | West Virginia | 54031 | 1524 | 24 |
1306627 | 1306627 | 2021-05-10 | Hardy | West Virginia | 54031 | 1520 | 24 |
1303381 | 1303381 | 2021-05-09 | Hardy | West Virginia | 54031 | 1518 | 24 |
1300134 | 1300134 | 2021-05-08 | Hardy | West Virginia | 54031 | 1514 | 24 |
1296887 | 1296887 | 2021-05-07 | Hardy | West Virginia | 54031 | 1513 | 24 |
1293641 | 1293641 | 2021-05-06 | Hardy | West Virginia | 54031 | 1506 | 24 |
1290395 | 1290395 | 2021-05-05 | Hardy | West Virginia | 54031 | 1504 | 24 |
1287149 | 1287149 | 2021-05-04 | Hardy | West Virginia | 54031 | 1505 | 24 |
1283903 | 1283903 | 2021-05-03 | Hardy | West Virginia | 54031 | 1502 | 24 |
1280656 | 1280656 | 2021-05-02 | Hardy | West Virginia | 54031 | 1501 | 24 |
1277409 | 1277409 | 2021-05-01 | Hardy | West Virginia | 54031 | 1499 | 24 |
1274162 | 1274162 | 2021-04-30 | Hardy | West Virginia | 54031 | 1498 | 24 |
1270915 | 1270915 | 2021-04-29 | Hardy | West Virginia | 54031 | 1494 | 24 |
1267668 | 1267668 | 2021-04-28 | Hardy | West Virginia | 54031 | 1486 | 24 |
1264421 | 1264421 | 2021-04-27 | Hardy | West Virginia | 54031 | 1470 | 24 |
1261174 | 1261174 | 2021-04-26 | Hardy | West Virginia | 54031 | 1467 | 24 |
1257927 | 1257927 | 2021-04-25 | Hardy | West Virginia | 54031 | 1461 | 24 |
1254680 | 1254680 | 2021-04-24 | Hardy | West Virginia | 54031 | 1458 | 24 |
1251433 | 1251433 | 2021-04-23 | Hardy | West Virginia | 54031 | 1455 | 24 |
1248186 | 1248186 | 2021-04-22 | Hardy | West Virginia | 54031 | 1450 | 24 |
1244939 | 1244939 | 2021-04-21 | Hardy | West Virginia | 54031 | 1447 | 24 |
1241692 | 1241692 | 2021-04-20 | Hardy | West Virginia | 54031 | 1443 | 24 |
1238445 | 1238445 | 2021-04-19 | Hardy | West Virginia | 54031 | 1436 | 24 |
1235198 | 1235198 | 2021-04-18 | Hardy | West Virginia | 54031 | 1436 | 24 |
1231950 | 1231950 | 2021-04-17 | Hardy | West Virginia | 54031 | 1434 | 24 |
1228702 | 1228702 | 2021-04-16 | Hardy | West Virginia | 54031 | 1431 | 24 |
1225454 | 1225454 | 2021-04-15 | Hardy | West Virginia | 54031 | 1424 | 24 |
1222207 | 1222207 | 2021-04-14 | Hardy | West Virginia | 54031 | 1425 | 24 |
1218959 | 1218959 | 2021-04-13 | Hardy | West Virginia | 54031 | 1423 | 24 |
1215711 | 1215711 | 2021-04-12 | Hardy | West Virginia | 54031 | 1422 | 24 |
1212464 | 1212464 | 2021-04-11 | Hardy | West Virginia | 54031 | 1422 | 24 |
1209215 | 1209215 | 2021-04-10 | Hardy | West Virginia | 54031 | 1422 | 24 |
1205967 | 1205967 | 2021-04-09 | Hardy | West Virginia | 54031 | 1413 | 24 |
1202719 | 1202719 | 2021-04-08 | Hardy | West Virginia | 54031 | 1413 | 24 |
1199471 | 1199471 | 2021-04-07 | Hardy | West Virginia | 54031 | 1407 | 24 |
1196222 | 1196222 | 2021-04-06 | Hardy | West Virginia | 54031 | 1404 | 24 |
1192974 | 1192974 | 2021-04-05 | Hardy | West Virginia | 54031 | 1401 | 24 |
1189724 | 1189724 | 2021-04-04 | Hardy | West Virginia | 54031 | 1399 | 24 |
1186477 | 1186477 | 2021-04-03 | Hardy | West Virginia | 54031 | 1399 | 24 |
1183230 | 1183230 | 2021-04-02 | Hardy | West Virginia | 54031 | 1396 | 24 |
1179983 | 1179983 | 2021-04-01 | Hardy | West Virginia | 54031 | 1395 | 24 |
1176736 | 1176736 | 2021-03-31 | Hardy | West Virginia | 54031 | 1394 | 24 |
1173489 | 1173489 | 2021-03-30 | Hardy | West Virginia | 54031 | 1391 | 23 |
1170242 | 1170242 | 2021-03-29 | Hardy | West Virginia | 54031 | 1383 | 23 |
1166994 | 1166994 | 2021-03-28 | Hardy | West Virginia | 54031 | 1381 | 23 |
1163746 | 1163746 | 2021-03-27 | Hardy | West Virginia | 54031 | 1379 | 23 |
1160498 | 1160498 | 2021-03-26 | Hardy | West Virginia | 54031 | 1372 | 23 |
1157250 | 1157250 | 2021-03-25 | Hardy | West Virginia | 54031 | 1370 | 23 |
1154003 | 1154003 | 2021-03-24 | Hardy | West Virginia | 54031 | 1355 | 23 |
1150756 | 1150756 | 2021-03-23 | Hardy | West Virginia | 54031 | 1352 | 23 |
1147509 | 1147509 | 2021-03-22 | Hardy | West Virginia | 54031 | 1347 | 23 |
1144262 | 1144262 | 2021-03-21 | Hardy | West Virginia | 54031 | 1346 | 23 |
1141015 | 1141015 | 2021-03-20 | Hardy | West Virginia | 54031 | 1338 | 23 |
1137769 | 1137769 | 2021-03-19 | Hardy | West Virginia | 54031 | 1337 | 23 |
1134523 | 1134523 | 2021-03-18 | Hardy | West Virginia | 54031 | 1337 | 23 |
1131275 | 1131275 | 2021-03-17 | Hardy | West Virginia | 54031 | 1333 | 23 |
1128028 | 1128028 | 2021-03-16 | Hardy | West Virginia | 54031 | 1325 | 23 |
1124782 | 1124782 | 2021-03-15 | Hardy | West Virginia | 54031 | 1311 | 23 |
1121536 | 1121536 | 2021-03-14 | Hardy | West Virginia | 54031 | 1310 | 23 |
1118289 | 1118289 | 2021-03-13 | Hardy | West Virginia | 54031 | 1309 | 23 |
1115042 | 1115042 | 2021-03-12 | Hardy | West Virginia | 54031 | 1308 | 23 |
1111796 | 1111796 | 2021-03-11 | Hardy | West Virginia | 54031 | 1305 | 20 |
1108550 | 1108550 | 2021-03-10 | Hardy | West Virginia | 54031 | 1302 | 20 |
1105304 | 1105304 | 2021-03-09 | Hardy | West Virginia | 54031 | 1292 | 20 |
1102058 | 1102058 | 2021-03-08 | Hardy | West Virginia | 54031 | 1289 | 20 |
1098812 | 1098812 | 2021-03-07 | Hardy | West Virginia | 54031 | 1287 | 20 |
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);