ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 51163 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280577 | 1280577 | 2021-05-02 | Rockbridge | Virginia | 51163 | 1513 | 46 |
1277330 | 1277330 | 2021-05-01 | Rockbridge | Virginia | 51163 | 1510 | 46 |
1274083 | 1274083 | 2021-04-30 | Rockbridge | Virginia | 51163 | 1507 | 46 |
1270836 | 1270836 | 2021-04-29 | Rockbridge | Virginia | 51163 | 1503 | 46 |
1267589 | 1267589 | 2021-04-28 | Rockbridge | Virginia | 51163 | 1499 | 46 |
1264342 | 1264342 | 2021-04-27 | Rockbridge | Virginia | 51163 | 1498 | 46 |
1261095 | 1261095 | 2021-04-26 | Rockbridge | Virginia | 51163 | 1496 | 46 |
1257848 | 1257848 | 2021-04-25 | Rockbridge | Virginia | 51163 | 1492 | 46 |
1254601 | 1254601 | 2021-04-24 | Rockbridge | Virginia | 51163 | 1491 | 46 |
1251354 | 1251354 | 2021-04-23 | Rockbridge | Virginia | 51163 | 1490 | 46 |
1248107 | 1248107 | 2021-04-22 | Rockbridge | Virginia | 51163 | 1489 | 46 |
1244860 | 1244860 | 2021-04-21 | Rockbridge | Virginia | 51163 | 1487 | 46 |
1241613 | 1241613 | 2021-04-20 | Rockbridge | Virginia | 51163 | 1485 | 46 |
1238366 | 1238366 | 2021-04-19 | Rockbridge | Virginia | 51163 | 1480 | 46 |
1235119 | 1235119 | 2021-04-18 | Rockbridge | Virginia | 51163 | 1479 | 46 |
1231871 | 1231871 | 2021-04-17 | Rockbridge | Virginia | 51163 | 1475 | 46 |
1228623 | 1228623 | 2021-04-16 | Rockbridge | Virginia | 51163 | 1473 | 46 |
1225375 | 1225375 | 2021-04-15 | Rockbridge | Virginia | 51163 | 1469 | 46 |
1222128 | 1222128 | 2021-04-14 | Rockbridge | Virginia | 51163 | 1469 | 46 |
1218880 | 1218880 | 2021-04-13 | Rockbridge | Virginia | 51163 | 1468 | 46 |
1215632 | 1215632 | 2021-04-12 | Rockbridge | Virginia | 51163 | 1466 | 46 |
1212385 | 1212385 | 2021-04-11 | Rockbridge | Virginia | 51163 | 1465 | 46 |
1209136 | 1209136 | 2021-04-10 | Rockbridge | Virginia | 51163 | 1464 | 46 |
1205888 | 1205888 | 2021-04-09 | Rockbridge | Virginia | 51163 | 1463 | 46 |
1202640 | 1202640 | 2021-04-08 | Rockbridge | Virginia | 51163 | 1460 | 46 |
1199392 | 1199392 | 2021-04-07 | Rockbridge | Virginia | 51163 | 1460 | 46 |
1196143 | 1196143 | 2021-04-06 | Rockbridge | Virginia | 51163 | 1458 | 46 |
1192895 | 1192895 | 2021-04-05 | Rockbridge | Virginia | 51163 | 1453 | 45 |
1189645 | 1189645 | 2021-04-04 | Rockbridge | Virginia | 51163 | 1451 | 45 |
1186398 | 1186398 | 2021-04-03 | Rockbridge | Virginia | 51163 | 1451 | 44 |
1183151 | 1183151 | 2021-04-02 | Rockbridge | Virginia | 51163 | 1448 | 44 |
1179904 | 1179904 | 2021-04-01 | Rockbridge | Virginia | 51163 | 1447 | 44 |
1176657 | 1176657 | 2021-03-31 | Rockbridge | Virginia | 51163 | 1446 | 44 |
1173410 | 1173410 | 2021-03-30 | Rockbridge | Virginia | 51163 | 1445 | 44 |
1170163 | 1170163 | 2021-03-29 | Rockbridge | Virginia | 51163 | 1445 | 44 |
1166915 | 1166915 | 2021-03-28 | Rockbridge | Virginia | 51163 | 1445 | 44 |
1163667 | 1163667 | 2021-03-27 | Rockbridge | Virginia | 51163 | 1441 | 44 |
1160419 | 1160419 | 2021-03-26 | Rockbridge | Virginia | 51163 | 1440 | 44 |
1157171 | 1157171 | 2021-03-25 | Rockbridge | Virginia | 51163 | 1436 | 44 |
1153924 | 1153924 | 2021-03-24 | Rockbridge | Virginia | 51163 | 1433 | 44 |
1150677 | 1150677 | 2021-03-23 | Rockbridge | Virginia | 51163 | 1433 | 44 |
1147430 | 1147430 | 2021-03-22 | Rockbridge | Virginia | 51163 | 1431 | 44 |
1144183 | 1144183 | 2021-03-21 | Rockbridge | Virginia | 51163 | 1434 | 44 |
1140936 | 1140936 | 2021-03-20 | Rockbridge | Virginia | 51163 | 1431 | 44 |
1137690 | 1137690 | 2021-03-19 | Rockbridge | Virginia | 51163 | 1427 | 44 |
1134444 | 1134444 | 2021-03-18 | Rockbridge | Virginia | 51163 | 1428 | 44 |
1131196 | 1131196 | 2021-03-17 | Rockbridge | Virginia | 51163 | 1426 | 44 |
1127949 | 1127949 | 2021-03-16 | Rockbridge | Virginia | 51163 | 1414 | 44 |
1124703 | 1124703 | 2021-03-15 | Rockbridge | Virginia | 51163 | 1418 | 44 |
1121457 | 1121457 | 2021-03-14 | Rockbridge | Virginia | 51163 | 1418 | 44 |
1118210 | 1118210 | 2021-03-13 | Rockbridge | Virginia | 51163 | 1410 | 44 |
1114963 | 1114963 | 2021-03-12 | Rockbridge | Virginia | 51163 | 1392 | 44 |
1111717 | 1111717 | 2021-03-11 | Rockbridge | Virginia | 51163 | 1382 | 44 |
1108471 | 1108471 | 2021-03-10 | Rockbridge | Virginia | 51163 | 1355 | 44 |
1105225 | 1105225 | 2021-03-09 | Rockbridge | Virginia | 51163 | 1339 | 44 |
1101979 | 1101979 | 2021-03-08 | Rockbridge | Virginia | 51163 | 1316 | 42 |
1098733 | 1098733 | 2021-03-07 | Rockbridge | Virginia | 51163 | 1315 | 41 |
1095485 | 1095485 | 2021-03-06 | Rockbridge | Virginia | 51163 | 1309 | 40 |
1092239 | 1092239 | 2021-03-05 | Rockbridge | Virginia | 51163 | 1307 | 39 |
1088993 | 1088993 | 2021-03-04 | Rockbridge | Virginia | 51163 | 1298 | 37 |
1085748 | 1085748 | 2021-03-03 | Rockbridge | Virginia | 51163 | 1291 | 36 |
1082502 | 1082502 | 2021-03-02 | Rockbridge | Virginia | 51163 | 1281 | 36 |
1079256 | 1079256 | 2021-03-01 | Rockbridge | Virginia | 51163 | 1278 | 36 |
1076011 | 1076011 | 2021-02-28 | Rockbridge | Virginia | 51163 | 1279 | 35 |
1072765 | 1072765 | 2021-02-27 | Rockbridge | Virginia | 51163 | 1274 | 34 |
1069519 | 1069519 | 2021-02-26 | Rockbridge | Virginia | 51163 | 1270 | 33 |
1066274 | 1066274 | 2021-02-25 | Rockbridge | Virginia | 51163 | 1266 | 32 |
1063029 | 1063029 | 2021-02-24 | Rockbridge | Virginia | 51163 | 1267 | 31 |
1059784 | 1059784 | 2021-02-23 | Rockbridge | Virginia | 51163 | 1248 | 30 |
1056538 | 1056538 | 2021-02-22 | Rockbridge | Virginia | 51163 | 1248 | 30 |
1053292 | 1053292 | 2021-02-21 | Rockbridge | Virginia | 51163 | 1240 | 29 |
1050045 | 1050045 | 2021-02-20 | Rockbridge | Virginia | 51163 | 1229 | 29 |
1046798 | 1046798 | 2021-02-19 | Rockbridge | Virginia | 51163 | 1246 | 29 |
1043553 | 1043553 | 2021-02-18 | Rockbridge | Virginia | 51163 | 1247 | 29 |
1040308 | 1040308 | 2021-02-17 | Rockbridge | Virginia | 51163 | 1240 | 29 |
1037063 | 1037063 | 2021-02-16 | Rockbridge | Virginia | 51163 | 1223 | 29 |
1033818 | 1033818 | 2021-02-15 | Rockbridge | Virginia | 51163 | 1219 | 29 |
1030572 | 1030572 | 2021-02-14 | Rockbridge | Virginia | 51163 | 1212 | 29 |
1027325 | 1027325 | 2021-02-13 | Rockbridge | Virginia | 51163 | 1200 | 29 |
1024080 | 1024080 | 2021-02-12 | Rockbridge | Virginia | 51163 | 1172 | 29 |
1020835 | 1020835 | 2021-02-11 | Rockbridge | Virginia | 51163 | 1167 | 29 |
1017590 | 1017590 | 2021-02-10 | Rockbridge | Virginia | 51163 | 1147 | 29 |
1014345 | 1014345 | 2021-02-09 | Rockbridge | Virginia | 51163 | 1136 | 29 |
1011100 | 1011100 | 2021-02-08 | Rockbridge | Virginia | 51163 | 1130 | 29 |
1007854 | 1007854 | 2021-02-07 | Rockbridge | Virginia | 51163 | 1125 | 29 |
1004608 | 1004608 | 2021-02-06 | Rockbridge | Virginia | 51163 | 1121 | 29 |
1001362 | 1001362 | 2021-02-05 | Rockbridge | Virginia | 51163 | 1098 | 29 |
998116 | 998116 | 2021-02-04 | Rockbridge | Virginia | 51163 | 1091 | 29 |
994870 | 994870 | 2021-02-03 | Rockbridge | Virginia | 51163 | 1088 | 29 |
991624 | 991624 | 2021-02-02 | Rockbridge | Virginia | 51163 | 1076 | 29 |
988378 | 988378 | 2021-02-01 | Rockbridge | Virginia | 51163 | 1074 | 29 |
985131 | 985131 | 2021-01-31 | Rockbridge | Virginia | 51163 | 1072 | 29 |
981884 | 981884 | 2021-01-30 | Rockbridge | Virginia | 51163 | 1067 | 29 |
978638 | 978638 | 2021-01-29 | Rockbridge | Virginia | 51163 | 1053 | 28 |
975393 | 975393 | 2021-01-28 | Rockbridge | Virginia | 51163 | 1043 | 27 |
972148 | 972148 | 2021-01-27 | Rockbridge | Virginia | 51163 | 1025 | 27 |
968903 | 968903 | 2021-01-26 | Rockbridge | Virginia | 51163 | 1012 | 23 |
965659 | 965659 | 2021-01-25 | Rockbridge | Virginia | 51163 | 1006 | 23 |
962414 | 962414 | 2021-01-24 | Rockbridge | Virginia | 51163 | 991 | 23 |
959169 | 959169 | 2021-01-23 | Rockbridge | Virginia | 51163 | 979 | 23 |
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);