ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
766 rows where fips = 54027 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 |
---|---|---|---|---|---|---|---|
1420238 | 1420238 | 2021-06-14 | Hampshire | West Virginia | 54027 | 1916 | 36 |
1416993 | 1416993 | 2021-06-13 | Hampshire | West Virginia | 54027 | 1915 | 36 |
1413747 | 1413747 | 2021-06-12 | Hampshire | West Virginia | 54027 | 1915 | 36 |
1410502 | 1410502 | 2021-06-11 | Hampshire | West Virginia | 54027 | 1915 | 36 |
1407257 | 1407257 | 2021-06-10 | Hampshire | West Virginia | 54027 | 1914 | 36 |
1404011 | 1404011 | 2021-06-09 | Hampshire | West Virginia | 54027 | 1914 | 36 |
1400766 | 1400766 | 2021-06-08 | Hampshire | West Virginia | 54027 | 1912 | 34 |
1397521 | 1397521 | 2021-06-07 | Hampshire | West Virginia | 54027 | 1912 | 34 |
1394274 | 1394274 | 2021-06-06 | Hampshire | West Virginia | 54027 | 1910 | 34 |
1391029 | 1391029 | 2021-06-05 | Hampshire | West Virginia | 54027 | 1910 | 34 |
1387784 | 1387784 | 2021-06-04 | Hampshire | West Virginia | 54027 | 1910 | 34 |
1384539 | 1384539 | 2021-06-03 | Hampshire | West Virginia | 54027 | 1909 | 34 |
1381293 | 1381293 | 2021-06-02 | Hampshire | West Virginia | 54027 | 1909 | 34 |
1378048 | 1378048 | 2021-06-01 | Hampshire | West Virginia | 54027 | 1907 | 34 |
1374802 | 1374802 | 2021-05-31 | Hampshire | West Virginia | 54027 | 1904 | 34 |
1371557 | 1371557 | 2021-05-30 | Hampshire | West Virginia | 54027 | 1904 | 34 |
1368311 | 1368311 | 2021-05-29 | Hampshire | West Virginia | 54027 | 1904 | 34 |
1365065 | 1365065 | 2021-05-28 | Hampshire | West Virginia | 54027 | 1904 | 34 |
1361819 | 1361819 | 2021-05-27 | Hampshire | West Virginia | 54027 | 1902 | 34 |
1358573 | 1358573 | 2021-05-26 | Hampshire | West Virginia | 54027 | 1895 | 34 |
1355327 | 1355327 | 2021-05-25 | Hampshire | West Virginia | 54027 | 1891 | 34 |
1352081 | 1352081 | 2021-05-24 | Hampshire | West Virginia | 54027 | 1890 | 34 |
1348835 | 1348835 | 2021-05-23 | Hampshire | West Virginia | 54027 | 1883 | 34 |
1345587 | 1345587 | 2021-05-22 | Hampshire | West Virginia | 54027 | 1883 | 34 |
1342339 | 1342339 | 2021-05-21 | Hampshire | West Virginia | 54027 | 1883 | 34 |
1339091 | 1339091 | 2021-05-20 | Hampshire | West Virginia | 54027 | 1878 | 34 |
1335844 | 1335844 | 2021-05-19 | Hampshire | West Virginia | 54027 | 1871 | 34 |
1332597 | 1332597 | 2021-05-18 | Hampshire | West Virginia | 54027 | 1871 | 34 |
1329350 | 1329350 | 2021-05-17 | Hampshire | West Virginia | 54027 | 1869 | 34 |
1326104 | 1326104 | 2021-05-16 | Hampshire | West Virginia | 54027 | 1862 | 34 |
1322858 | 1322858 | 2021-05-15 | Hampshire | West Virginia | 54027 | 1853 | 34 |
1319612 | 1319612 | 2021-05-14 | Hampshire | West Virginia | 54027 | 1842 | 34 |
1316364 | 1316364 | 2021-05-13 | Hampshire | West Virginia | 54027 | 1837 | 34 |
1313118 | 1313118 | 2021-05-12 | Hampshire | West Virginia | 54027 | 1825 | 34 |
1309871 | 1309871 | 2021-05-11 | Hampshire | West Virginia | 54027 | 1810 | 34 |
1306625 | 1306625 | 2021-05-10 | Hampshire | West Virginia | 54027 | 1804 | 34 |
1303379 | 1303379 | 2021-05-09 | Hampshire | West Virginia | 54027 | 1800 | 34 |
1300132 | 1300132 | 2021-05-08 | Hampshire | West Virginia | 54027 | 1796 | 34 |
1296885 | 1296885 | 2021-05-07 | Hampshire | West Virginia | 54027 | 1795 | 34 |
1293639 | 1293639 | 2021-05-06 | Hampshire | West Virginia | 54027 | 1792 | 34 |
1290393 | 1290393 | 2021-05-05 | Hampshire | West Virginia | 54027 | 1784 | 33 |
1287147 | 1287147 | 2021-05-04 | Hampshire | West Virginia | 54027 | 1772 | 33 |
1283901 | 1283901 | 2021-05-03 | Hampshire | West Virginia | 54027 | 1767 | 33 |
1280654 | 1280654 | 2021-05-02 | Hampshire | West Virginia | 54027 | 1765 | 33 |
1277407 | 1277407 | 2021-05-01 | Hampshire | West Virginia | 54027 | 1760 | 33 |
1274160 | 1274160 | 2021-04-30 | Hampshire | West Virginia | 54027 | 1752 | 33 |
1270913 | 1270913 | 2021-04-29 | Hampshire | West Virginia | 54027 | 1755 | 33 |
1267666 | 1267666 | 2021-04-28 | Hampshire | West Virginia | 54027 | 1751 | 33 |
1264419 | 1264419 | 2021-04-27 | Hampshire | West Virginia | 54027 | 1746 | 33 |
1261172 | 1261172 | 2021-04-26 | Hampshire | West Virginia | 54027 | 1742 | 33 |
1257925 | 1257925 | 2021-04-25 | Hampshire | West Virginia | 54027 | 1742 | 33 |
1254678 | 1254678 | 2021-04-24 | Hampshire | West Virginia | 54027 | 1739 | 33 |
1251431 | 1251431 | 2021-04-23 | Hampshire | West Virginia | 54027 | 1735 | 33 |
1248184 | 1248184 | 2021-04-22 | Hampshire | West Virginia | 54027 | 1732 | 33 |
1244937 | 1244937 | 2021-04-21 | Hampshire | West Virginia | 54027 | 1724 | 33 |
1241690 | 1241690 | 2021-04-20 | Hampshire | West Virginia | 54027 | 1716 | 33 |
1238443 | 1238443 | 2021-04-19 | Hampshire | West Virginia | 54027 | 1715 | 33 |
1235196 | 1235196 | 2021-04-18 | Hampshire | West Virginia | 54027 | 1715 | 33 |
1231948 | 1231948 | 2021-04-17 | Hampshire | West Virginia | 54027 | 1702 | 33 |
1228700 | 1228700 | 2021-04-16 | Hampshire | West Virginia | 54027 | 1686 | 32 |
1225452 | 1225452 | 2021-04-15 | Hampshire | West Virginia | 54027 | 1681 | 32 |
1222205 | 1222205 | 2021-04-14 | Hampshire | West Virginia | 54027 | 1680 | 32 |
1218957 | 1218957 | 2021-04-13 | Hampshire | West Virginia | 54027 | 1677 | 32 |
1215709 | 1215709 | 2021-04-12 | Hampshire | West Virginia | 54027 | 1669 | 32 |
1212462 | 1212462 | 2021-04-11 | Hampshire | West Virginia | 54027 | 1665 | 32 |
1209213 | 1209213 | 2021-04-10 | Hampshire | West Virginia | 54027 | 1662 | 32 |
1205965 | 1205965 | 2021-04-09 | Hampshire | West Virginia | 54027 | 1661 | 32 |
1202717 | 1202717 | 2021-04-08 | Hampshire | West Virginia | 54027 | 1654 | 32 |
1199469 | 1199469 | 2021-04-07 | Hampshire | West Virginia | 54027 | 1651 | 32 |
1196220 | 1196220 | 2021-04-06 | Hampshire | West Virginia | 54027 | 1647 | 32 |
1192972 | 1192972 | 2021-04-05 | Hampshire | West Virginia | 54027 | 1644 | 32 |
1189722 | 1189722 | 2021-04-04 | Hampshire | West Virginia | 54027 | 1640 | 32 |
1186475 | 1186475 | 2021-04-03 | Hampshire | West Virginia | 54027 | 1637 | 32 |
1183228 | 1183228 | 2021-04-02 | Hampshire | West Virginia | 54027 | 1629 | 32 |
1179981 | 1179981 | 2021-04-01 | Hampshire | West Virginia | 54027 | 1624 | 32 |
1176734 | 1176734 | 2021-03-31 | Hampshire | West Virginia | 54027 | 1616 | 32 |
1173487 | 1173487 | 2021-03-30 | Hampshire | West Virginia | 54027 | 1609 | 32 |
1170240 | 1170240 | 2021-03-29 | Hampshire | West Virginia | 54027 | 1605 | 32 |
1166992 | 1166992 | 2021-03-28 | Hampshire | West Virginia | 54027 | 1604 | 32 |
1163744 | 1163744 | 2021-03-27 | Hampshire | West Virginia | 54027 | 1601 | 32 |
1160496 | 1160496 | 2021-03-26 | Hampshire | West Virginia | 54027 | 1596 | 32 |
1157248 | 1157248 | 2021-03-25 | Hampshire | West Virginia | 54027 | 1595 | 32 |
1154001 | 1154001 | 2021-03-24 | Hampshire | West Virginia | 54027 | 1591 | 32 |
1150754 | 1150754 | 2021-03-23 | Hampshire | West Virginia | 54027 | 1586 | 32 |
1147507 | 1147507 | 2021-03-22 | Hampshire | West Virginia | 54027 | 1585 | 32 |
1144260 | 1144260 | 2021-03-21 | Hampshire | West Virginia | 54027 | 1584 | 32 |
1141013 | 1141013 | 2021-03-20 | Hampshire | West Virginia | 54027 | 1582 | 32 |
1137767 | 1137767 | 2021-03-19 | Hampshire | West Virginia | 54027 | 1577 | 32 |
1134521 | 1134521 | 2021-03-18 | Hampshire | West Virginia | 54027 | 1574 | 31 |
1131273 | 1131273 | 2021-03-17 | Hampshire | West Virginia | 54027 | 1574 | 31 |
1128026 | 1128026 | 2021-03-16 | Hampshire | West Virginia | 54027 | 1570 | 29 |
1124780 | 1124780 | 2021-03-15 | Hampshire | West Virginia | 54027 | 1562 | 29 |
1121534 | 1121534 | 2021-03-14 | Hampshire | West Virginia | 54027 | 1562 | 29 |
1118287 | 1118287 | 2021-03-13 | Hampshire | West Virginia | 54027 | 1559 | 29 |
1115040 | 1115040 | 2021-03-12 | Hampshire | West Virginia | 54027 | 1558 | 29 |
1111794 | 1111794 | 2021-03-11 | Hampshire | West Virginia | 54027 | 1553 | 29 |
1108548 | 1108548 | 2021-03-10 | Hampshire | West Virginia | 54027 | 1551 | 28 |
1105302 | 1105302 | 2021-03-09 | Hampshire | West Virginia | 54027 | 1548 | 28 |
1102056 | 1102056 | 2021-03-08 | Hampshire | West Virginia | 54027 | 1549 | 28 |
1098810 | 1098810 | 2021-03-07 | Hampshire | West Virginia | 54027 | 1548 | 28 |
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);