ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 54103 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 |
---|---|---|---|---|---|---|---|
1517656 | 1517656 | 2021-07-14 | Wetzel | West Virginia | 54103 | 1400 | 32 |
1514409 | 1514409 | 2021-07-13 | Wetzel | West Virginia | 54103 | 1399 | 32 |
1511163 | 1511163 | 2021-07-12 | Wetzel | West Virginia | 54103 | 1400 | 32 |
1507916 | 1507916 | 2021-07-11 | Wetzel | West Virginia | 54103 | 1396 | 32 |
1504670 | 1504670 | 2021-07-10 | Wetzel | West Virginia | 54103 | 1396 | 32 |
1501424 | 1501424 | 2021-07-09 | Wetzel | West Virginia | 54103 | 1396 | 32 |
1498178 | 1498178 | 2021-07-08 | Wetzel | West Virginia | 54103 | 1394 | 32 |
1494931 | 1494931 | 2021-07-07 | Wetzel | West Virginia | 54103 | 1394 | 32 |
1491684 | 1491684 | 2021-07-06 | Wetzel | West Virginia | 54103 | 1393 | 32 |
1488437 | 1488437 | 2021-07-05 | Wetzel | West Virginia | 54103 | 1392 | 32 |
1485190 | 1485190 | 2021-07-04 | Wetzel | West Virginia | 54103 | 1392 | 32 |
1481944 | 1481944 | 2021-07-03 | Wetzel | West Virginia | 54103 | 1392 | 32 |
1478697 | 1478697 | 2021-07-02 | Wetzel | West Virginia | 54103 | 1392 | 32 |
1475451 | 1475451 | 2021-07-01 | Wetzel | West Virginia | 54103 | 1391 | 32 |
1472205 | 1472205 | 2021-06-30 | Wetzel | West Virginia | 54103 | 1390 | 32 |
1468960 | 1468960 | 2021-06-29 | Wetzel | West Virginia | 54103 | 1390 | 31 |
1465715 | 1465715 | 2021-06-28 | Wetzel | West Virginia | 54103 | 1390 | 31 |
1462470 | 1462470 | 2021-06-27 | Wetzel | West Virginia | 54103 | 1385 | 31 |
1459225 | 1459225 | 2021-06-26 | Wetzel | West Virginia | 54103 | 1385 | 31 |
1455980 | 1455980 | 2021-06-25 | Wetzel | West Virginia | 54103 | 1385 | 31 |
1452735 | 1452735 | 2021-06-24 | Wetzel | West Virginia | 54103 | 1385 | 31 |
1449489 | 1449489 | 2021-06-23 | Wetzel | West Virginia | 54103 | 1385 | 31 |
1446244 | 1446244 | 2021-06-22 | Wetzel | West Virginia | 54103 | 1385 | 31 |
1442999 | 1442999 | 2021-06-21 | Wetzel | West Virginia | 54103 | 1385 | 31 |
1439754 | 1439754 | 2021-06-20 | Wetzel | West Virginia | 54103 | 1385 | 31 |
1436507 | 1436507 | 2021-06-19 | Wetzel | West Virginia | 54103 | 1385 | 31 |
1433260 | 1433260 | 2021-06-18 | Wetzel | West Virginia | 54103 | 1385 | 31 |
1430014 | 1430014 | 2021-06-17 | Wetzel | West Virginia | 54103 | 1385 | 31 |
1426769 | 1426769 | 2021-06-16 | Wetzel | West Virginia | 54103 | 1386 | 31 |
1423523 | 1423523 | 2021-06-15 | Wetzel | West Virginia | 54103 | 1384 | 31 |
1420276 | 1420276 | 2021-06-14 | Wetzel | West Virginia | 54103 | 1384 | 31 |
1417031 | 1417031 | 2021-06-13 | Wetzel | West Virginia | 54103 | 1382 | 31 |
1413785 | 1413785 | 2021-06-12 | Wetzel | West Virginia | 54103 | 1382 | 31 |
1410540 | 1410540 | 2021-06-11 | Wetzel | West Virginia | 54103 | 1382 | 31 |
1407295 | 1407295 | 2021-06-10 | Wetzel | West Virginia | 54103 | 1381 | 31 |
1404049 | 1404049 | 2021-06-09 | Wetzel | West Virginia | 54103 | 1379 | 31 |
1400804 | 1400804 | 2021-06-08 | Wetzel | West Virginia | 54103 | 1378 | 31 |
1397559 | 1397559 | 2021-06-07 | Wetzel | West Virginia | 54103 | 1378 | 31 |
1394312 | 1394312 | 2021-06-06 | Wetzel | West Virginia | 54103 | 1378 | 31 |
1391067 | 1391067 | 2021-06-05 | Wetzel | West Virginia | 54103 | 1378 | 31 |
1387822 | 1387822 | 2021-06-04 | Wetzel | West Virginia | 54103 | 1378 | 31 |
1384577 | 1384577 | 2021-06-03 | Wetzel | West Virginia | 54103 | 1377 | 31 |
1381331 | 1381331 | 2021-06-02 | Wetzel | West Virginia | 54103 | 1378 | 31 |
1378086 | 1378086 | 2021-06-01 | Wetzel | West Virginia | 54103 | 1378 | 31 |
1374840 | 1374840 | 2021-05-31 | Wetzel | West Virginia | 54103 | 1377 | 31 |
1371595 | 1371595 | 2021-05-30 | Wetzel | West Virginia | 54103 | 1377 | 31 |
1368349 | 1368349 | 2021-05-29 | Wetzel | West Virginia | 54103 | 1377 | 31 |
1365103 | 1365103 | 2021-05-28 | Wetzel | West Virginia | 54103 | 1377 | 31 |
1361857 | 1361857 | 2021-05-27 | Wetzel | West Virginia | 54103 | 1376 | 31 |
1358611 | 1358611 | 2021-05-26 | Wetzel | West Virginia | 54103 | 1377 | 31 |
1355365 | 1355365 | 2021-05-25 | Wetzel | West Virginia | 54103 | 1372 | 31 |
1352119 | 1352119 | 2021-05-24 | Wetzel | West Virginia | 54103 | 1375 | 31 |
1348873 | 1348873 | 2021-05-23 | Wetzel | West Virginia | 54103 | 1370 | 31 |
1345625 | 1345625 | 2021-05-22 | Wetzel | West Virginia | 54103 | 1370 | 31 |
1342377 | 1342377 | 2021-05-21 | Wetzel | West Virginia | 54103 | 1370 | 31 |
1339129 | 1339129 | 2021-05-20 | Wetzel | West Virginia | 54103 | 1369 | 31 |
1335882 | 1335882 | 2021-05-19 | Wetzel | West Virginia | 54103 | 1362 | 31 |
1332635 | 1332635 | 2021-05-18 | Wetzel | West Virginia | 54103 | 1362 | 31 |
1329388 | 1329388 | 2021-05-17 | Wetzel | West Virginia | 54103 | 1362 | 31 |
1326142 | 1326142 | 2021-05-16 | Wetzel | West Virginia | 54103 | 1358 | 30 |
1322896 | 1322896 | 2021-05-15 | Wetzel | West Virginia | 54103 | 1355 | 30 |
1319650 | 1319650 | 2021-05-14 | Wetzel | West Virginia | 54103 | 1351 | 30 |
1316402 | 1316402 | 2021-05-13 | Wetzel | West Virginia | 54103 | 1345 | 30 |
1313156 | 1313156 | 2021-05-12 | Wetzel | West Virginia | 54103 | 1339 | 30 |
1309909 | 1309909 | 2021-05-11 | Wetzel | West Virginia | 54103 | 1332 | 29 |
1306663 | 1306663 | 2021-05-10 | Wetzel | West Virginia | 54103 | 1329 | 29 |
1303417 | 1303417 | 2021-05-09 | Wetzel | West Virginia | 54103 | 1327 | 29 |
1300170 | 1300170 | 2021-05-08 | Wetzel | West Virginia | 54103 | 1319 | 29 |
1296923 | 1296923 | 2021-05-07 | Wetzel | West Virginia | 54103 | 1317 | 29 |
1293677 | 1293677 | 2021-05-06 | Wetzel | West Virginia | 54103 | 1311 | 29 |
1290431 | 1290431 | 2021-05-05 | Wetzel | West Virginia | 54103 | 1304 | 29 |
1287185 | 1287185 | 2021-05-04 | Wetzel | West Virginia | 54103 | 1291 | 29 |
1283939 | 1283939 | 2021-05-03 | Wetzel | West Virginia | 54103 | 1287 | 29 |
1280692 | 1280692 | 2021-05-02 | Wetzel | West Virginia | 54103 | 1284 | 29 |
1277445 | 1277445 | 2021-05-01 | Wetzel | West Virginia | 54103 | 1282 | 29 |
1274198 | 1274198 | 2021-04-30 | Wetzel | West Virginia | 54103 | 1278 | 29 |
1270951 | 1270951 | 2021-04-29 | Wetzel | West Virginia | 54103 | 1270 | 29 |
1267704 | 1267704 | 2021-04-28 | Wetzel | West Virginia | 54103 | 1261 | 29 |
1264457 | 1264457 | 2021-04-27 | Wetzel | West Virginia | 54103 | 1256 | 29 |
1261210 | 1261210 | 2021-04-26 | Wetzel | West Virginia | 54103 | 1247 | 29 |
1257963 | 1257963 | 2021-04-25 | Wetzel | West Virginia | 54103 | 1247 | 29 |
1254716 | 1254716 | 2021-04-24 | Wetzel | West Virginia | 54103 | 1244 | 29 |
1251469 | 1251469 | 2021-04-23 | Wetzel | West Virginia | 54103 | 1238 | 29 |
1248222 | 1248222 | 2021-04-22 | Wetzel | West Virginia | 54103 | 1224 | 29 |
1244975 | 1244975 | 2021-04-21 | Wetzel | West Virginia | 54103 | 1221 | 29 |
1241728 | 1241728 | 2021-04-20 | Wetzel | West Virginia | 54103 | 1213 | 29 |
1238481 | 1238481 | 2021-04-19 | Wetzel | West Virginia | 54103 | 1198 | 29 |
1235234 | 1235234 | 2021-04-18 | Wetzel | West Virginia | 54103 | 1195 | 29 |
1231986 | 1231986 | 2021-04-17 | Wetzel | West Virginia | 54103 | 1188 | 29 |
1228738 | 1228738 | 2021-04-16 | Wetzel | West Virginia | 54103 | 1183 | 29 |
1225490 | 1225490 | 2021-04-15 | Wetzel | West Virginia | 54103 | 1180 | 29 |
1222243 | 1222243 | 2021-04-14 | Wetzel | West Virginia | 54103 | 1177 | 29 |
1218995 | 1218995 | 2021-04-13 | Wetzel | West Virginia | 54103 | 1176 | 29 |
1215747 | 1215747 | 2021-04-12 | Wetzel | West Virginia | 54103 | 1204 | 29 |
1212500 | 1212500 | 2021-04-11 | Wetzel | West Virginia | 54103 | 1204 | 29 |
1209251 | 1209251 | 2021-04-10 | Wetzel | West Virginia | 54103 | 1203 | 29 |
1206003 | 1206003 | 2021-04-09 | Wetzel | West Virginia | 54103 | 1203 | 29 |
1202755 | 1202755 | 2021-04-08 | Wetzel | West Virginia | 54103 | 1202 | 29 |
1199507 | 1199507 | 2021-04-07 | Wetzel | West Virginia | 54103 | 1200 | 29 |
1196258 | 1196258 | 2021-04-06 | Wetzel | West Virginia | 54103 | 1195 | 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);