ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 51075 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1420103 | 1420103 | 2021-06-14 | Goochland | Virginia | 51075 | 1468 | 23 |
1416858 | 1416858 | 2021-06-13 | Goochland | Virginia | 51075 | 1468 | 23 |
1413612 | 1413612 | 2021-06-12 | Goochland | Virginia | 51075 | 1468 | 23 |
1410367 | 1410367 | 2021-06-11 | Goochland | Virginia | 51075 | 1469 | 23 |
1407122 | 1407122 | 2021-06-10 | Goochland | Virginia | 51075 | 1469 | 23 |
1403876 | 1403876 | 2021-06-09 | Goochland | Virginia | 51075 | 1469 | 23 |
1400631 | 1400631 | 2021-06-08 | Goochland | Virginia | 51075 | 1469 | 23 |
1397386 | 1397386 | 2021-06-07 | Goochland | Virginia | 51075 | 1466 | 23 |
1394139 | 1394139 | 2021-06-06 | Goochland | Virginia | 51075 | 1465 | 23 |
1390894 | 1390894 | 2021-06-05 | Goochland | Virginia | 51075 | 1464 | 23 |
1387649 | 1387649 | 2021-06-04 | Goochland | Virginia | 51075 | 1463 | 23 |
1384404 | 1384404 | 2021-06-03 | Goochland | Virginia | 51075 | 1462 | 23 |
1381158 | 1381158 | 2021-06-02 | Goochland | Virginia | 51075 | 1461 | 23 |
1377913 | 1377913 | 2021-06-01 | Goochland | Virginia | 51075 | 1461 | 23 |
1374667 | 1374667 | 2021-05-31 | Goochland | Virginia | 51075 | 1460 | 23 |
1371422 | 1371422 | 2021-05-30 | Goochland | Virginia | 51075 | 1460 | 23 |
1368176 | 1368176 | 2021-05-29 | Goochland | Virginia | 51075 | 1460 | 23 |
1364930 | 1364930 | 2021-05-28 | Goochland | Virginia | 51075 | 1459 | 23 |
1361684 | 1361684 | 2021-05-27 | Goochland | Virginia | 51075 | 1458 | 23 |
1358438 | 1358438 | 2021-05-26 | Goochland | Virginia | 51075 | 1457 | 23 |
1355192 | 1355192 | 2021-05-25 | Goochland | Virginia | 51075 | 1456 | 23 |
1351946 | 1351946 | 2021-05-24 | Goochland | Virginia | 51075 | 1455 | 23 |
1348700 | 1348700 | 2021-05-23 | Goochland | Virginia | 51075 | 1454 | 23 |
1345452 | 1345452 | 2021-05-22 | Goochland | Virginia | 51075 | 1454 | 23 |
1342204 | 1342204 | 2021-05-21 | Goochland | Virginia | 51075 | 1454 | 23 |
1338956 | 1338956 | 2021-05-20 | Goochland | Virginia | 51075 | 1453 | 23 |
1335709 | 1335709 | 2021-05-19 | Goochland | Virginia | 51075 | 1454 | 23 |
1332462 | 1332462 | 2021-05-18 | Goochland | Virginia | 51075 | 1451 | 23 |
1329215 | 1329215 | 2021-05-17 | Goochland | Virginia | 51075 | 1451 | 23 |
1325969 | 1325969 | 2021-05-16 | Goochland | Virginia | 51075 | 1447 | 23 |
1322723 | 1322723 | 2021-05-15 | Goochland | Virginia | 51075 | 1447 | 23 |
1319477 | 1319477 | 2021-05-14 | Goochland | Virginia | 51075 | 1446 | 23 |
1316229 | 1316229 | 2021-05-13 | Goochland | Virginia | 51075 | 1442 | 23 |
1312983 | 1312983 | 2021-05-12 | Goochland | Virginia | 51075 | 1441 | 23 |
1309736 | 1309736 | 2021-05-11 | Goochland | Virginia | 51075 | 1438 | 23 |
1306490 | 1306490 | 2021-05-10 | Goochland | Virginia | 51075 | 1437 | 23 |
1303244 | 1303244 | 2021-05-09 | Goochland | Virginia | 51075 | 1437 | 23 |
1299997 | 1299997 | 2021-05-08 | Goochland | Virginia | 51075 | 1436 | 23 |
1296750 | 1296750 | 2021-05-07 | Goochland | Virginia | 51075 | 1435 | 23 |
1293504 | 1293504 | 2021-05-06 | Goochland | Virginia | 51075 | 1435 | 23 |
1290258 | 1290258 | 2021-05-05 | Goochland | Virginia | 51075 | 1435 | 23 |
1287012 | 1287012 | 2021-05-04 | Goochland | Virginia | 51075 | 1435 | 23 |
1283766 | 1283766 | 2021-05-03 | Goochland | Virginia | 51075 | 1435 | 23 |
1280519 | 1280519 | 2021-05-02 | Goochland | Virginia | 51075 | 1434 | 23 |
1277272 | 1277272 | 2021-05-01 | Goochland | Virginia | 51075 | 1431 | 23 |
1274025 | 1274025 | 2021-04-30 | Goochland | Virginia | 51075 | 1430 | 23 |
1270778 | 1270778 | 2021-04-29 | Goochland | Virginia | 51075 | 1428 | 23 |
1267531 | 1267531 | 2021-04-28 | Goochland | Virginia | 51075 | 1424 | 23 |
1264284 | 1264284 | 2021-04-27 | Goochland | Virginia | 51075 | 1416 | 23 |
1261037 | 1261037 | 2021-04-26 | Goochland | Virginia | 51075 | 1415 | 23 |
1257790 | 1257790 | 2021-04-25 | Goochland | Virginia | 51075 | 1415 | 23 |
1254543 | 1254543 | 2021-04-24 | Goochland | Virginia | 51075 | 1413 | 23 |
1251296 | 1251296 | 2021-04-23 | Goochland | Virginia | 51075 | 1409 | 23 |
1248049 | 1248049 | 2021-04-22 | Goochland | Virginia | 51075 | 1406 | 23 |
1244802 | 1244802 | 2021-04-21 | Goochland | Virginia | 51075 | 1401 | 23 |
1241555 | 1241555 | 2021-04-20 | Goochland | Virginia | 51075 | 1397 | 23 |
1238308 | 1238308 | 2021-04-19 | Goochland | Virginia | 51075 | 1396 | 23 |
1235061 | 1235061 | 2021-04-18 | Goochland | Virginia | 51075 | 1391 | 23 |
1231813 | 1231813 | 2021-04-17 | Goochland | Virginia | 51075 | 1388 | 23 |
1228565 | 1228565 | 2021-04-16 | Goochland | Virginia | 51075 | 1382 | 23 |
1225317 | 1225317 | 2021-04-15 | Goochland | Virginia | 51075 | 1377 | 23 |
1222070 | 1222070 | 2021-04-14 | Goochland | Virginia | 51075 | 1373 | 23 |
1218822 | 1218822 | 2021-04-13 | Goochland | Virginia | 51075 | 1368 | 23 |
1215574 | 1215574 | 2021-04-12 | Goochland | Virginia | 51075 | 1364 | 23 |
1212327 | 1212327 | 2021-04-11 | Goochland | Virginia | 51075 | 1360 | 23 |
1209078 | 1209078 | 2021-04-10 | Goochland | Virginia | 51075 | 1355 | 23 |
1205830 | 1205830 | 2021-04-09 | Goochland | Virginia | 51075 | 1350 | 23 |
1202582 | 1202582 | 2021-04-08 | Goochland | Virginia | 51075 | 1345 | 23 |
1199334 | 1199334 | 2021-04-07 | Goochland | Virginia | 51075 | 1342 | 22 |
1196085 | 1196085 | 2021-04-06 | Goochland | Virginia | 51075 | 1333 | 22 |
1192837 | 1192837 | 2021-04-05 | Goochland | Virginia | 51075 | 1331 | 22 |
1189587 | 1189587 | 2021-04-04 | Goochland | Virginia | 51075 | 1330 | 21 |
1186340 | 1186340 | 2021-04-03 | Goochland | Virginia | 51075 | 1325 | 21 |
1183093 | 1183093 | 2021-04-02 | Goochland | Virginia | 51075 | 1321 | 21 |
1179846 | 1179846 | 2021-04-01 | Goochland | Virginia | 51075 | 1317 | 21 |
1176599 | 1176599 | 2021-03-31 | Goochland | Virginia | 51075 | 1315 | 21 |
1173352 | 1173352 | 2021-03-30 | Goochland | Virginia | 51075 | 1312 | 21 |
1170105 | 1170105 | 2021-03-29 | Goochland | Virginia | 51075 | 1310 | 21 |
1166857 | 1166857 | 2021-03-28 | Goochland | Virginia | 51075 | 1306 | 21 |
1163609 | 1163609 | 2021-03-27 | Goochland | Virginia | 51075 | 1300 | 20 |
1160361 | 1160361 | 2021-03-26 | Goochland | Virginia | 51075 | 1294 | 20 |
1157113 | 1157113 | 2021-03-25 | Goochland | Virginia | 51075 | 1291 | 20 |
1153866 | 1153866 | 2021-03-24 | Goochland | Virginia | 51075 | 1289 | 20 |
1150619 | 1150619 | 2021-03-23 | Goochland | Virginia | 51075 | 1287 | 20 |
1147372 | 1147372 | 2021-03-22 | Goochland | Virginia | 51075 | 1284 | 20 |
1144125 | 1144125 | 2021-03-21 | Goochland | Virginia | 51075 | 1280 | 20 |
1140878 | 1140878 | 2021-03-20 | Goochland | Virginia | 51075 | 1274 | 20 |
1137632 | 1137632 | 2021-03-19 | Goochland | Virginia | 51075 | 1270 | 20 |
1134386 | 1134386 | 2021-03-18 | Goochland | Virginia | 51075 | 1267 | 21 |
1131138 | 1131138 | 2021-03-17 | Goochland | Virginia | 51075 | 1263 | 21 |
1127891 | 1127891 | 2021-03-16 | Goochland | Virginia | 51075 | 1262 | 19 |
1124645 | 1124645 | 2021-03-15 | Goochland | Virginia | 51075 | 1259 | 18 |
1121399 | 1121399 | 2021-03-14 | Goochland | Virginia | 51075 | 1257 | 18 |
1118152 | 1118152 | 2021-03-13 | Goochland | Virginia | 51075 | 1257 | 17 |
1114905 | 1114905 | 2021-03-12 | Goochland | Virginia | 51075 | 1256 | 17 |
1111659 | 1111659 | 2021-03-11 | Goochland | Virginia | 51075 | 1251 | 17 |
1108413 | 1108413 | 2021-03-10 | Goochland | Virginia | 51075 | 1248 | 17 |
1105167 | 1105167 | 2021-03-09 | Goochland | Virginia | 51075 | 1246 | 17 |
1101921 | 1101921 | 2021-03-08 | Goochland | Virginia | 51075 | 1236 | 17 |
1098675 | 1098675 | 2021-03-07 | Goochland | Virginia | 51075 | 1234 | 17 |
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);