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 |
---|---|---|---|---|---|---|---|
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 |
1095427 | 1095427 | 2021-03-06 | Goochland | Virginia | 51075 | 1230 | 17 |
1092181 | 1092181 | 2021-03-05 | Goochland | Virginia | 51075 | 1225 | 17 |
1088935 | 1088935 | 2021-03-04 | Goochland | Virginia | 51075 | 1219 | 17 |
1085690 | 1085690 | 2021-03-03 | Goochland | Virginia | 51075 | 1220 | 17 |
1082444 | 1082444 | 2021-03-02 | Goochland | Virginia | 51075 | 1219 | 16 |
1079198 | 1079198 | 2021-03-01 | Goochland | Virginia | 51075 | 1209 | 15 |
1075953 | 1075953 | 2021-02-28 | Goochland | Virginia | 51075 | 1207 | 13 |
1072707 | 1072707 | 2021-02-27 | Goochland | Virginia | 51075 | 1208 | 13 |
1069461 | 1069461 | 2021-02-26 | Goochland | Virginia | 51075 | 1204 | 12 |
1066216 | 1066216 | 2021-02-25 | Goochland | Virginia | 51075 | 1199 | 11 |
1062971 | 1062971 | 2021-02-24 | Goochland | Virginia | 51075 | 1201 | 10 |
1059726 | 1059726 | 2021-02-23 | Goochland | Virginia | 51075 | 1198 | 8 |
1056480 | 1056480 | 2021-02-22 | Goochland | Virginia | 51075 | 1196 | 8 |
1053234 | 1053234 | 2021-02-21 | Goochland | Virginia | 51075 | 1194 | 8 |
1049987 | 1049987 | 2021-02-20 | Goochland | Virginia | 51075 | 1191 | 8 |
1046740 | 1046740 | 2021-02-19 | Goochland | Virginia | 51075 | 1189 | 8 |
1043495 | 1043495 | 2021-02-18 | Goochland | Virginia | 51075 | 1187 | 8 |
1040250 | 1040250 | 2021-02-17 | Goochland | Virginia | 51075 | 1178 | 8 |
1037005 | 1037005 | 2021-02-16 | Goochland | Virginia | 51075 | 1171 | 8 |
1033760 | 1033760 | 2021-02-15 | Goochland | Virginia | 51075 | 1169 | 8 |
1030514 | 1030514 | 2021-02-14 | Goochland | Virginia | 51075 | 1161 | 8 |
1027267 | 1027267 | 2021-02-13 | Goochland | Virginia | 51075 | 1151 | 8 |
1024022 | 1024022 | 2021-02-12 | Goochland | Virginia | 51075 | 1144 | 8 |
1020777 | 1020777 | 2021-02-11 | Goochland | Virginia | 51075 | 1141 | 8 |
1017532 | 1017532 | 2021-02-10 | Goochland | Virginia | 51075 | 1135 | 8 |
1014287 | 1014287 | 2021-02-09 | Goochland | Virginia | 51075 | 1126 | 8 |
1011042 | 1011042 | 2021-02-08 | Goochland | Virginia | 51075 | 1107 | 8 |
1007796 | 1007796 | 2021-02-07 | Goochland | Virginia | 51075 | 1104 | 8 |
1004550 | 1004550 | 2021-02-06 | Goochland | Virginia | 51075 | 1098 | 8 |
1001304 | 1001304 | 2021-02-05 | Goochland | Virginia | 51075 | 1088 | 8 |
998058 | 998058 | 2021-02-04 | Goochland | Virginia | 51075 | 1077 | 8 |
994812 | 994812 | 2021-02-03 | Goochland | Virginia | 51075 | 1065 | 8 |
991566 | 991566 | 2021-02-02 | Goochland | Virginia | 51075 | 1050 | 8 |
988320 | 988320 | 2021-02-01 | Goochland | Virginia | 51075 | 1043 | 8 |
985073 | 985073 | 2021-01-31 | Goochland | Virginia | 51075 | 1035 | 8 |
981826 | 981826 | 2021-01-30 | Goochland | Virginia | 51075 | 1028 | 8 |
978580 | 978580 | 2021-01-29 | Goochland | Virginia | 51075 | 1017 | 7 |
975335 | 975335 | 2021-01-28 | Goochland | Virginia | 51075 | 1006 | 7 |
972090 | 972090 | 2021-01-27 | Goochland | Virginia | 51075 | 989 | 7 |
968845 | 968845 | 2021-01-26 | Goochland | Virginia | 51075 | 980 | 7 |
965601 | 965601 | 2021-01-25 | Goochland | Virginia | 51075 | 968 | 7 |
962356 | 962356 | 2021-01-24 | Goochland | Virginia | 51075 | 949 | 7 |
959111 | 959111 | 2021-01-23 | Goochland | Virginia | 51075 | 943 | 7 |
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);