ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where fips = 51011 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1420059 | 1420059 | 2021-06-14 | Appomattox | Virginia | 51011 | 1621 | 26 |
1416814 | 1416814 | 2021-06-13 | Appomattox | Virginia | 51011 | 1621 | 26 |
1413568 | 1413568 | 2021-06-12 | Appomattox | Virginia | 51011 | 1621 | 26 |
1410323 | 1410323 | 2021-06-11 | Appomattox | Virginia | 51011 | 1621 | 26 |
1407078 | 1407078 | 2021-06-10 | Appomattox | Virginia | 51011 | 1622 | 26 |
1403832 | 1403832 | 2021-06-09 | Appomattox | Virginia | 51011 | 1623 | 26 |
1400587 | 1400587 | 2021-06-08 | Appomattox | Virginia | 51011 | 1622 | 26 |
1397342 | 1397342 | 2021-06-07 | Appomattox | Virginia | 51011 | 1622 | 26 |
1394095 | 1394095 | 2021-06-06 | Appomattox | Virginia | 51011 | 1622 | 26 |
1390850 | 1390850 | 2021-06-05 | Appomattox | Virginia | 51011 | 1622 | 26 |
1387605 | 1387605 | 2021-06-04 | Appomattox | Virginia | 51011 | 1620 | 26 |
1384360 | 1384360 | 2021-06-03 | Appomattox | Virginia | 51011 | 1617 | 26 |
1381114 | 1381114 | 2021-06-02 | Appomattox | Virginia | 51011 | 1616 | 26 |
1377869 | 1377869 | 2021-06-01 | Appomattox | Virginia | 51011 | 1615 | 26 |
1374623 | 1374623 | 2021-05-31 | Appomattox | Virginia | 51011 | 1616 | 25 |
1371378 | 1371378 | 2021-05-30 | Appomattox | Virginia | 51011 | 1615 | 25 |
1368132 | 1368132 | 2021-05-29 | Appomattox | Virginia | 51011 | 1614 | 25 |
1364886 | 1364886 | 2021-05-28 | Appomattox | Virginia | 51011 | 1614 | 25 |
1361640 | 1361640 | 2021-05-27 | Appomattox | Virginia | 51011 | 1613 | 25 |
1358394 | 1358394 | 2021-05-26 | Appomattox | Virginia | 51011 | 1611 | 25 |
1355148 | 1355148 | 2021-05-25 | Appomattox | Virginia | 51011 | 1610 | 25 |
1351902 | 1351902 | 2021-05-24 | Appomattox | Virginia | 51011 | 1599 | 25 |
1348656 | 1348656 | 2021-05-23 | Appomattox | Virginia | 51011 | 1598 | 25 |
1345408 | 1345408 | 2021-05-22 | Appomattox | Virginia | 51011 | 1598 | 25 |
1342160 | 1342160 | 2021-05-21 | Appomattox | Virginia | 51011 | 1595 | 25 |
1338912 | 1338912 | 2021-05-20 | Appomattox | Virginia | 51011 | 1593 | 25 |
1335665 | 1335665 | 2021-05-19 | Appomattox | Virginia | 51011 | 1593 | 25 |
1332418 | 1332418 | 2021-05-18 | Appomattox | Virginia | 51011 | 1593 | 25 |
1329171 | 1329171 | 2021-05-17 | Appomattox | Virginia | 51011 | 1593 | 25 |
1325925 | 1325925 | 2021-05-16 | Appomattox | Virginia | 51011 | 1592 | 25 |
1322679 | 1322679 | 2021-05-15 | Appomattox | Virginia | 51011 | 1592 | 25 |
1319433 | 1319433 | 2021-05-14 | Appomattox | Virginia | 51011 | 1592 | 25 |
1316185 | 1316185 | 2021-05-13 | Appomattox | Virginia | 51011 | 1592 | 25 |
1312939 | 1312939 | 2021-05-12 | Appomattox | Virginia | 51011 | 1592 | 25 |
1309692 | 1309692 | 2021-05-11 | Appomattox | Virginia | 51011 | 1592 | 25 |
1306446 | 1306446 | 2021-05-10 | Appomattox | Virginia | 51011 | 1591 | 25 |
1303200 | 1303200 | 2021-05-09 | Appomattox | Virginia | 51011 | 1589 | 24 |
1299953 | 1299953 | 2021-05-08 | Appomattox | Virginia | 51011 | 1589 | 24 |
1296706 | 1296706 | 2021-05-07 | Appomattox | Virginia | 51011 | 1590 | 24 |
1293460 | 1293460 | 2021-05-06 | Appomattox | Virginia | 51011 | 1588 | 24 |
1290214 | 1290214 | 2021-05-05 | Appomattox | Virginia | 51011 | 1585 | 24 |
1286968 | 1286968 | 2021-05-04 | Appomattox | Virginia | 51011 | 1583 | 24 |
1283722 | 1283722 | 2021-05-03 | Appomattox | Virginia | 51011 | 1583 | 24 |
1280475 | 1280475 | 2021-05-02 | Appomattox | Virginia | 51011 | 1583 | 24 |
1277228 | 1277228 | 2021-05-01 | Appomattox | Virginia | 51011 | 1583 | 24 |
1273981 | 1273981 | 2021-04-30 | Appomattox | Virginia | 51011 | 1579 | 24 |
1270734 | 1270734 | 2021-04-29 | Appomattox | Virginia | 51011 | 1576 | 24 |
1267487 | 1267487 | 2021-04-28 | Appomattox | Virginia | 51011 | 1574 | 24 |
1264240 | 1264240 | 2021-04-27 | Appomattox | Virginia | 51011 | 1574 | 24 |
1260993 | 1260993 | 2021-04-26 | Appomattox | Virginia | 51011 | 1574 | 24 |
1257746 | 1257746 | 2021-04-25 | Appomattox | Virginia | 51011 | 1573 | 24 |
1254499 | 1254499 | 2021-04-24 | Appomattox | Virginia | 51011 | 1573 | 24 |
1251252 | 1251252 | 2021-04-23 | Appomattox | Virginia | 51011 | 1568 | 24 |
1248005 | 1248005 | 2021-04-22 | Appomattox | Virginia | 51011 | 1567 | 24 |
1244758 | 1244758 | 2021-04-21 | Appomattox | Virginia | 51011 | 1566 | 24 |
1241511 | 1241511 | 2021-04-20 | Appomattox | Virginia | 51011 | 1566 | 24 |
1238264 | 1238264 | 2021-04-19 | Appomattox | Virginia | 51011 | 1565 | 24 |
1235017 | 1235017 | 2021-04-18 | Appomattox | Virginia | 51011 | 1564 | 24 |
1231769 | 1231769 | 2021-04-17 | Appomattox | Virginia | 51011 | 1562 | 24 |
1228521 | 1228521 | 2021-04-16 | Appomattox | Virginia | 51011 | 1562 | 24 |
1225273 | 1225273 | 2021-04-15 | Appomattox | Virginia | 51011 | 1562 | 24 |
1222026 | 1222026 | 2021-04-14 | Appomattox | Virginia | 51011 | 1560 | 24 |
1218778 | 1218778 | 2021-04-13 | Appomattox | Virginia | 51011 | 1505 | 23 |
1215530 | 1215530 | 2021-04-12 | Appomattox | Virginia | 51011 | 1505 | 23 |
1212283 | 1212283 | 2021-04-11 | Appomattox | Virginia | 51011 | 1502 | 23 |
1209034 | 1209034 | 2021-04-10 | Appomattox | Virginia | 51011 | 1501 | 23 |
1205786 | 1205786 | 2021-04-09 | Appomattox | Virginia | 51011 | 1494 | 23 |
1202538 | 1202538 | 2021-04-08 | Appomattox | Virginia | 51011 | 1491 | 23 |
1199290 | 1199290 | 2021-04-07 | Appomattox | Virginia | 51011 | 1488 | 23 |
1196041 | 1196041 | 2021-04-06 | Appomattox | Virginia | 51011 | 1488 | 23 |
1192793 | 1192793 | 2021-04-05 | Appomattox | Virginia | 51011 | 1485 | 23 |
1189543 | 1189543 | 2021-04-04 | Appomattox | Virginia | 51011 | 1483 | 23 |
1186296 | 1186296 | 2021-04-03 | Appomattox | Virginia | 51011 | 1483 | 23 |
1183049 | 1183049 | 2021-04-02 | Appomattox | Virginia | 51011 | 1479 | 23 |
1179802 | 1179802 | 2021-04-01 | Appomattox | Virginia | 51011 | 1479 | 23 |
1176555 | 1176555 | 2021-03-31 | Appomattox | Virginia | 51011 | 1478 | 23 |
1173308 | 1173308 | 2021-03-30 | Appomattox | Virginia | 51011 | 1476 | 23 |
1170061 | 1170061 | 2021-03-29 | Appomattox | Virginia | 51011 | 1477 | 23 |
1166813 | 1166813 | 2021-03-28 | Appomattox | Virginia | 51011 | 1475 | 23 |
1163565 | 1163565 | 2021-03-27 | Appomattox | Virginia | 51011 | 1474 | 23 |
1160317 | 1160317 | 2021-03-26 | Appomattox | Virginia | 51011 | 1472 | 23 |
1157069 | 1157069 | 2021-03-25 | Appomattox | Virginia | 51011 | 1469 | 23 |
1153822 | 1153822 | 2021-03-24 | Appomattox | Virginia | 51011 | 1466 | 23 |
1150575 | 1150575 | 2021-03-23 | Appomattox | Virginia | 51011 | 1461 | 23 |
1147328 | 1147328 | 2021-03-22 | Appomattox | Virginia | 51011 | 1460 | 23 |
1144081 | 1144081 | 2021-03-21 | Appomattox | Virginia | 51011 | 1458 | 23 |
1140834 | 1140834 | 2021-03-20 | Appomattox | Virginia | 51011 | 1457 | 23 |
1137588 | 1137588 | 2021-03-19 | Appomattox | Virginia | 51011 | 1455 | 23 |
1134342 | 1134342 | 2021-03-18 | Appomattox | Virginia | 51011 | 1452 | 23 |
1131094 | 1131094 | 2021-03-17 | Appomattox | Virginia | 51011 | 1449 | 23 |
1127847 | 1127847 | 2021-03-16 | Appomattox | Virginia | 51011 | 1446 | 23 |
1124601 | 1124601 | 2021-03-15 | Appomattox | Virginia | 51011 | 1444 | 23 |
1121355 | 1121355 | 2021-03-14 | Appomattox | Virginia | 51011 | 1443 | 23 |
1118108 | 1118108 | 2021-03-13 | Appomattox | Virginia | 51011 | 1442 | 23 |
1114861 | 1114861 | 2021-03-12 | Appomattox | Virginia | 51011 | 1443 | 23 |
1111615 | 1111615 | 2021-03-11 | Appomattox | Virginia | 51011 | 1442 | 23 |
1108369 | 1108369 | 2021-03-10 | Appomattox | Virginia | 51011 | 1439 | 23 |
1105123 | 1105123 | 2021-03-09 | Appomattox | Virginia | 51011 | 1436 | 21 |
1101877 | 1101877 | 2021-03-08 | Appomattox | Virginia | 51011 | 1434 | 20 |
1098631 | 1098631 | 2021-03-07 | Appomattox | Virginia | 51011 | 1430 | 19 |
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);