ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Hardy" 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 |
---|---|---|---|---|---|---|---|
1196222 | 1196222 | 2021-04-06 | Hardy | West Virginia | 54031 | 1404 | 24 |
1192974 | 1192974 | 2021-04-05 | Hardy | West Virginia | 54031 | 1401 | 24 |
1189724 | 1189724 | 2021-04-04 | Hardy | West Virginia | 54031 | 1399 | 24 |
1186477 | 1186477 | 2021-04-03 | Hardy | West Virginia | 54031 | 1399 | 24 |
1183230 | 1183230 | 2021-04-02 | Hardy | West Virginia | 54031 | 1396 | 24 |
1179983 | 1179983 | 2021-04-01 | Hardy | West Virginia | 54031 | 1395 | 24 |
1176736 | 1176736 | 2021-03-31 | Hardy | West Virginia | 54031 | 1394 | 24 |
1173489 | 1173489 | 2021-03-30 | Hardy | West Virginia | 54031 | 1391 | 23 |
1170242 | 1170242 | 2021-03-29 | Hardy | West Virginia | 54031 | 1383 | 23 |
1166994 | 1166994 | 2021-03-28 | Hardy | West Virginia | 54031 | 1381 | 23 |
1163746 | 1163746 | 2021-03-27 | Hardy | West Virginia | 54031 | 1379 | 23 |
1160498 | 1160498 | 2021-03-26 | Hardy | West Virginia | 54031 | 1372 | 23 |
1157250 | 1157250 | 2021-03-25 | Hardy | West Virginia | 54031 | 1370 | 23 |
1154003 | 1154003 | 2021-03-24 | Hardy | West Virginia | 54031 | 1355 | 23 |
1150756 | 1150756 | 2021-03-23 | Hardy | West Virginia | 54031 | 1352 | 23 |
1147509 | 1147509 | 2021-03-22 | Hardy | West Virginia | 54031 | 1347 | 23 |
1144262 | 1144262 | 2021-03-21 | Hardy | West Virginia | 54031 | 1346 | 23 |
1141015 | 1141015 | 2021-03-20 | Hardy | West Virginia | 54031 | 1338 | 23 |
1137769 | 1137769 | 2021-03-19 | Hardy | West Virginia | 54031 | 1337 | 23 |
1134523 | 1134523 | 2021-03-18 | Hardy | West Virginia | 54031 | 1337 | 23 |
1131275 | 1131275 | 2021-03-17 | Hardy | West Virginia | 54031 | 1333 | 23 |
1128028 | 1128028 | 2021-03-16 | Hardy | West Virginia | 54031 | 1325 | 23 |
1124782 | 1124782 | 2021-03-15 | Hardy | West Virginia | 54031 | 1311 | 23 |
1121536 | 1121536 | 2021-03-14 | Hardy | West Virginia | 54031 | 1310 | 23 |
1118289 | 1118289 | 2021-03-13 | Hardy | West Virginia | 54031 | 1309 | 23 |
1115042 | 1115042 | 2021-03-12 | Hardy | West Virginia | 54031 | 1308 | 23 |
1111796 | 1111796 | 2021-03-11 | Hardy | West Virginia | 54031 | 1305 | 20 |
1108550 | 1108550 | 2021-03-10 | Hardy | West Virginia | 54031 | 1302 | 20 |
1105304 | 1105304 | 2021-03-09 | Hardy | West Virginia | 54031 | 1292 | 20 |
1102058 | 1102058 | 2021-03-08 | Hardy | West Virginia | 54031 | 1289 | 20 |
1098812 | 1098812 | 2021-03-07 | Hardy | West Virginia | 54031 | 1287 | 20 |
1095564 | 1095564 | 2021-03-06 | Hardy | West Virginia | 54031 | 1285 | 20 |
1092318 | 1092318 | 2021-03-05 | Hardy | West Virginia | 54031 | 1277 | 20 |
1089072 | 1089072 | 2021-03-04 | Hardy | West Virginia | 54031 | 1274 | 20 |
1085827 | 1085827 | 2021-03-03 | Hardy | West Virginia | 54031 | 1273 | 20 |
1082581 | 1082581 | 2021-03-02 | Hardy | West Virginia | 54031 | 1270 | 20 |
1079335 | 1079335 | 2021-03-01 | Hardy | West Virginia | 54031 | 1267 | 20 |
1076090 | 1076090 | 2021-02-28 | Hardy | West Virginia | 54031 | 1267 | 20 |
1072844 | 1072844 | 2021-02-27 | Hardy | West Virginia | 54031 | 1265 | 20 |
1069598 | 1069598 | 2021-02-26 | Hardy | West Virginia | 54031 | 1264 | 20 |
1066353 | 1066353 | 2021-02-25 | Hardy | West Virginia | 54031 | 1263 | 20 |
1063108 | 1063108 | 2021-02-24 | Hardy | West Virginia | 54031 | 1261 | 20 |
1059863 | 1059863 | 2021-02-23 | Hardy | West Virginia | 54031 | 1263 | 20 |
1056617 | 1056617 | 2021-02-22 | Hardy | West Virginia | 54031 | 1260 | 20 |
1053371 | 1053371 | 2021-02-21 | Hardy | West Virginia | 54031 | 1259 | 20 |
1050124 | 1050124 | 2021-02-20 | Hardy | West Virginia | 54031 | 1258 | 20 |
1046877 | 1046877 | 2021-02-19 | Hardy | West Virginia | 54031 | 1257 | 20 |
1043632 | 1043632 | 2021-02-18 | Hardy | West Virginia | 54031 | 1256 | 20 |
1040387 | 1040387 | 2021-02-17 | Hardy | West Virginia | 54031 | 1252 | 20 |
1037142 | 1037142 | 2021-02-16 | Hardy | West Virginia | 54031 | 1248 | 20 |
1033897 | 1033897 | 2021-02-15 | Hardy | West Virginia | 54031 | 1246 | 20 |
1030651 | 1030651 | 2021-02-14 | Hardy | West Virginia | 54031 | 1245 | 20 |
1027404 | 1027404 | 2021-02-13 | Hardy | West Virginia | 54031 | 1245 | 20 |
1024159 | 1024159 | 2021-02-12 | Hardy | West Virginia | 54031 | 1246 | 20 |
1020914 | 1020914 | 2021-02-11 | Hardy | West Virginia | 54031 | 1245 | 20 |
1017669 | 1017669 | 2021-02-10 | Hardy | West Virginia | 54031 | 1243 | 18 |
1014424 | 1014424 | 2021-02-09 | Hardy | West Virginia | 54031 | 1244 | 18 |
1011179 | 1011179 | 2021-02-08 | Hardy | West Virginia | 54031 | 1242 | 18 |
1007933 | 1007933 | 2021-02-07 | Hardy | West Virginia | 54031 | 1243 | 18 |
1004687 | 1004687 | 2021-02-06 | Hardy | West Virginia | 54031 | 1239 | 17 |
1001441 | 1001441 | 2021-02-05 | Hardy | West Virginia | 54031 | 1234 | 17 |
998195 | 998195 | 2021-02-04 | Hardy | West Virginia | 54031 | 1231 | 16 |
994949 | 994949 | 2021-02-03 | Hardy | West Virginia | 54031 | 1226 | 16 |
991703 | 991703 | 2021-02-02 | Hardy | West Virginia | 54031 | 1223 | 16 |
988457 | 988457 | 2021-02-01 | Hardy | West Virginia | 54031 | 1221 | 16 |
985210 | 985210 | 2021-01-31 | Hardy | West Virginia | 54031 | 1219 | 16 |
981963 | 981963 | 2021-01-30 | Hardy | West Virginia | 54031 | 1215 | 16 |
978717 | 978717 | 2021-01-29 | Hardy | West Virginia | 54031 | 1201 | 16 |
975472 | 975472 | 2021-01-28 | Hardy | West Virginia | 54031 | 1187 | 16 |
972227 | 972227 | 2021-01-27 | Hardy | West Virginia | 54031 | 1179 | 16 |
968982 | 968982 | 2021-01-26 | Hardy | West Virginia | 54031 | 1173 | 14 |
965738 | 965738 | 2021-01-25 | Hardy | West Virginia | 54031 | 1162 | 14 |
962493 | 962493 | 2021-01-24 | Hardy | West Virginia | 54031 | 1150 | 14 |
959248 | 959248 | 2021-01-23 | Hardy | West Virginia | 54031 | 1136 | 14 |
956002 | 956002 | 2021-01-22 | Hardy | West Virginia | 54031 | 1135 | 14 |
952757 | 952757 | 2021-01-21 | Hardy | West Virginia | 54031 | 1119 | 14 |
949512 | 949512 | 2021-01-20 | Hardy | West Virginia | 54031 | 1107 | 14 |
946266 | 946266 | 2021-01-19 | Hardy | West Virginia | 54031 | 1103 | 14 |
943019 | 943019 | 2021-01-18 | Hardy | West Virginia | 54031 | 1087 | 14 |
939774 | 939774 | 2021-01-17 | Hardy | West Virginia | 54031 | 1083 | 14 |
936529 | 936529 | 2021-01-16 | Hardy | West Virginia | 54031 | 1078 | 12 |
933284 | 933284 | 2021-01-15 | Hardy | West Virginia | 54031 | 1048 | 12 |
930039 | 930039 | 2021-01-14 | Hardy | West Virginia | 54031 | 1017 | 12 |
926794 | 926794 | 2021-01-13 | Hardy | West Virginia | 54031 | 1015 | 12 |
923548 | 923548 | 2021-01-12 | Hardy | West Virginia | 54031 | 1011 | 11 |
920303 | 920303 | 2021-01-11 | Hardy | West Virginia | 54031 | 995 | 11 |
917058 | 917058 | 2021-01-10 | Hardy | West Virginia | 54031 | 986 | 11 |
913813 | 913813 | 2021-01-09 | Hardy | West Virginia | 54031 | 921 | 10 |
910568 | 910568 | 2021-01-08 | Hardy | West Virginia | 54031 | 903 | 10 |
907323 | 907323 | 2021-01-07 | Hardy | West Virginia | 54031 | 882 | 10 |
904077 | 904077 | 2021-01-06 | Hardy | West Virginia | 54031 | 875 | 9 |
900832 | 900832 | 2021-01-05 | Hardy | West Virginia | 54031 | 845 | 8 |
897587 | 897587 | 2021-01-04 | Hardy | West Virginia | 54031 | 834 | 8 |
894341 | 894341 | 2021-01-03 | Hardy | West Virginia | 54031 | 826 | 8 |
891095 | 891095 | 2021-01-02 | Hardy | West Virginia | 54031 | 809 | 8 |
887848 | 887848 | 2021-01-01 | Hardy | West Virginia | 54031 | 799 | 8 |
884603 | 884603 | 2020-12-31 | Hardy | West Virginia | 54031 | 775 | 7 |
881358 | 881358 | 2020-12-30 | Hardy | West Virginia | 54031 | 761 | 7 |
878113 | 878113 | 2020-12-29 | Hardy | West Virginia | 54031 | 751 | 6 |
874868 | 874868 | 2020-12-28 | Hardy | West Virginia | 54031 | 734 | 6 |
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);