ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Putnam" 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 |
---|---|---|---|---|---|---|---|
1488425 | 1488425 | 2021-07-05 | Putnam | West Virginia | 54079 | 5331 | 93 |
1485178 | 1485178 | 2021-07-04 | Putnam | West Virginia | 54079 | 5331 | 93 |
1481932 | 1481932 | 2021-07-03 | Putnam | West Virginia | 54079 | 5331 | 93 |
1478685 | 1478685 | 2021-07-02 | Putnam | West Virginia | 54079 | 5331 | 93 |
1475439 | 1475439 | 2021-07-01 | Putnam | West Virginia | 54079 | 5329 | 93 |
1472193 | 1472193 | 2021-06-30 | Putnam | West Virginia | 54079 | 5330 | 93 |
1468948 | 1468948 | 2021-06-29 | Putnam | West Virginia | 54079 | 5329 | 93 |
1465703 | 1465703 | 2021-06-28 | Putnam | West Virginia | 54079 | 5326 | 93 |
1462458 | 1462458 | 2021-06-27 | Putnam | West Virginia | 54079 | 5321 | 93 |
1459213 | 1459213 | 2021-06-26 | Putnam | West Virginia | 54079 | 5321 | 93 |
1455968 | 1455968 | 2021-06-25 | Putnam | West Virginia | 54079 | 5321 | 93 |
1452723 | 1452723 | 2021-06-24 | Putnam | West Virginia | 54079 | 5321 | 93 |
1449477 | 1449477 | 2021-06-23 | Putnam | West Virginia | 54079 | 5321 | 93 |
1446232 | 1446232 | 2021-06-22 | Putnam | West Virginia | 54079 | 5319 | 93 |
1442987 | 1442987 | 2021-06-21 | Putnam | West Virginia | 54079 | 5316 | 93 |
1439742 | 1439742 | 2021-06-20 | Putnam | West Virginia | 54079 | 5316 | 93 |
1436495 | 1436495 | 2021-06-19 | Putnam | West Virginia | 54079 | 5316 | 93 |
1433248 | 1433248 | 2021-06-18 | Putnam | West Virginia | 54079 | 5316 | 93 |
1430002 | 1430002 | 2021-06-17 | Putnam | West Virginia | 54079 | 5316 | 93 |
1426757 | 1426757 | 2021-06-16 | Putnam | West Virginia | 54079 | 5314 | 93 |
1423511 | 1423511 | 2021-06-15 | Putnam | West Virginia | 54079 | 5310 | 94 |
1420264 | 1420264 | 2021-06-14 | Putnam | West Virginia | 54079 | 5309 | 94 |
1417019 | 1417019 | 2021-06-13 | Putnam | West Virginia | 54079 | 5304 | 94 |
1413773 | 1413773 | 2021-06-12 | Putnam | West Virginia | 54079 | 5304 | 94 |
1410528 | 1410528 | 2021-06-11 | Putnam | West Virginia | 54079 | 5304 | 94 |
1407283 | 1407283 | 2021-06-10 | Putnam | West Virginia | 54079 | 5303 | 94 |
1404037 | 1404037 | 2021-06-09 | Putnam | West Virginia | 54079 | 5303 | 94 |
1400792 | 1400792 | 2021-06-08 | Putnam | West Virginia | 54079 | 5301 | 93 |
1397547 | 1397547 | 2021-06-07 | Putnam | West Virginia | 54079 | 5298 | 93 |
1394300 | 1394300 | 2021-06-06 | Putnam | West Virginia | 54079 | 5293 | 93 |
1391055 | 1391055 | 2021-06-05 | Putnam | West Virginia | 54079 | 5293 | 93 |
1387810 | 1387810 | 2021-06-04 | Putnam | West Virginia | 54079 | 5293 | 93 |
1384565 | 1384565 | 2021-06-03 | Putnam | West Virginia | 54079 | 5289 | 93 |
1381319 | 1381319 | 2021-06-02 | Putnam | West Virginia | 54079 | 5288 | 93 |
1378074 | 1378074 | 2021-06-01 | Putnam | West Virginia | 54079 | 5287 | 93 |
1374828 | 1374828 | 2021-05-31 | Putnam | West Virginia | 54079 | 5276 | 93 |
1371583 | 1371583 | 2021-05-30 | Putnam | West Virginia | 54079 | 5276 | 93 |
1368337 | 1368337 | 2021-05-29 | Putnam | West Virginia | 54079 | 5276 | 93 |
1365091 | 1365091 | 2021-05-28 | Putnam | West Virginia | 54079 | 5276 | 93 |
1361845 | 1361845 | 2021-05-27 | Putnam | West Virginia | 54079 | 5272 | 93 |
1358599 | 1358599 | 2021-05-26 | Putnam | West Virginia | 54079 | 5270 | 93 |
1355353 | 1355353 | 2021-05-25 | Putnam | West Virginia | 54079 | 5267 | 93 |
1352107 | 1352107 | 2021-05-24 | Putnam | West Virginia | 54079 | 5263 | 93 |
1348861 | 1348861 | 2021-05-23 | Putnam | West Virginia | 54079 | 5232 | 93 |
1345613 | 1345613 | 2021-05-22 | Putnam | West Virginia | 54079 | 5232 | 93 |
1342365 | 1342365 | 2021-05-21 | Putnam | West Virginia | 54079 | 5232 | 93 |
1339117 | 1339117 | 2021-05-20 | Putnam | West Virginia | 54079 | 5222 | 93 |
1335870 | 1335870 | 2021-05-19 | Putnam | West Virginia | 54079 | 5212 | 93 |
1332623 | 1332623 | 2021-05-18 | Putnam | West Virginia | 54079 | 5203 | 93 |
1329376 | 1329376 | 2021-05-17 | Putnam | West Virginia | 54079 | 5195 | 93 |
1326130 | 1326130 | 2021-05-16 | Putnam | West Virginia | 54079 | 5188 | 92 |
1322884 | 1322884 | 2021-05-15 | Putnam | West Virginia | 54079 | 5181 | 92 |
1319638 | 1319638 | 2021-05-14 | Putnam | West Virginia | 54079 | 5172 | 92 |
1316390 | 1316390 | 2021-05-13 | Putnam | West Virginia | 54079 | 5166 | 92 |
1313144 | 1313144 | 2021-05-12 | Putnam | West Virginia | 54079 | 5153 | 92 |
1309897 | 1309897 | 2021-05-11 | Putnam | West Virginia | 54079 | 5140 | 91 |
1306651 | 1306651 | 2021-05-10 | Putnam | West Virginia | 54079 | 5132 | 90 |
1303405 | 1303405 | 2021-05-09 | Putnam | West Virginia | 54079 | 5126 | 90 |
1300158 | 1300158 | 2021-05-08 | Putnam | West Virginia | 54079 | 5107 | 90 |
1296911 | 1296911 | 2021-05-07 | Putnam | West Virginia | 54079 | 5094 | 90 |
1293665 | 1293665 | 2021-05-06 | Putnam | West Virginia | 54079 | 5087 | 90 |
1290419 | 1290419 | 2021-05-05 | Putnam | West Virginia | 54079 | 5065 | 90 |
1287173 | 1287173 | 2021-05-04 | Putnam | West Virginia | 54079 | 5046 | 90 |
1283927 | 1283927 | 2021-05-03 | Putnam | West Virginia | 54079 | 5035 | 90 |
1280680 | 1280680 | 2021-05-02 | Putnam | West Virginia | 54079 | 5025 | 90 |
1277433 | 1277433 | 2021-05-01 | Putnam | West Virginia | 54079 | 5006 | 90 |
1274186 | 1274186 | 2021-04-30 | Putnam | West Virginia | 54079 | 4985 | 90 |
1270939 | 1270939 | 2021-04-29 | Putnam | West Virginia | 54079 | 4962 | 90 |
1267692 | 1267692 | 2021-04-28 | Putnam | West Virginia | 54079 | 4945 | 90 |
1264445 | 1264445 | 2021-04-27 | Putnam | West Virginia | 54079 | 4932 | 89 |
1261198 | 1261198 | 2021-04-26 | Putnam | West Virginia | 54079 | 4913 | 100 |
1257951 | 1257951 | 2021-04-25 | Putnam | West Virginia | 54079 | 4896 | 100 |
1254704 | 1254704 | 2021-04-24 | Putnam | West Virginia | 54079 | 4877 | 100 |
1251457 | 1251457 | 2021-04-23 | Putnam | West Virginia | 54079 | 4866 | 100 |
1248210 | 1248210 | 2021-04-22 | Putnam | West Virginia | 54079 | 4854 | 100 |
1244963 | 1244963 | 2021-04-21 | Putnam | West Virginia | 54079 | 4843 | 100 |
1241716 | 1241716 | 2021-04-20 | Putnam | West Virginia | 54079 | 4833 | 100 |
1238469 | 1238469 | 2021-04-19 | Putnam | West Virginia | 54079 | 4823 | 100 |
1235222 | 1235222 | 2021-04-18 | Putnam | West Virginia | 54079 | 4815 | 100 |
1231974 | 1231974 | 2021-04-17 | Putnam | West Virginia | 54079 | 4806 | 100 |
1228726 | 1228726 | 2021-04-16 | Putnam | West Virginia | 54079 | 4782 | 100 |
1225478 | 1225478 | 2021-04-15 | Putnam | West Virginia | 54079 | 4764 | 100 |
1222231 | 1222231 | 2021-04-14 | Putnam | West Virginia | 54079 | 4744 | 99 |
1218983 | 1218983 | 2021-04-13 | Putnam | West Virginia | 54079 | 4735 | 98 |
1215735 | 1215735 | 2021-04-12 | Putnam | West Virginia | 54079 | 4723 | 98 |
1212488 | 1212488 | 2021-04-11 | Putnam | West Virginia | 54079 | 4710 | 98 |
1209239 | 1209239 | 2021-04-10 | Putnam | West Virginia | 54079 | 4699 | 98 |
1205991 | 1205991 | 2021-04-09 | Putnam | West Virginia | 54079 | 4687 | 98 |
1202743 | 1202743 | 2021-04-08 | Putnam | West Virginia | 54079 | 4675 | 98 |
1199495 | 1199495 | 2021-04-07 | Putnam | West Virginia | 54079 | 4662 | 95 |
1196246 | 1196246 | 2021-04-06 | Putnam | West Virginia | 54079 | 4654 | 93 |
1192998 | 1192998 | 2021-04-05 | Putnam | West Virginia | 54079 | 4633 | 93 |
1189748 | 1189748 | 2021-04-04 | Putnam | West Virginia | 54079 | 4622 | 93 |
1186501 | 1186501 | 2021-04-03 | Putnam | West Virginia | 54079 | 4605 | 93 |
1183254 | 1183254 | 2021-04-02 | Putnam | West Virginia | 54079 | 4586 | 93 |
1180007 | 1180007 | 2021-04-01 | Putnam | West Virginia | 54079 | 4563 | 92 |
1176760 | 1176760 | 2021-03-31 | Putnam | West Virginia | 54079 | 4544 | 92 |
1173513 | 1173513 | 2021-03-30 | Putnam | West Virginia | 54079 | 4542 | 89 |
1170266 | 1170266 | 2021-03-29 | Putnam | West Virginia | 54079 | 4525 | 89 |
1167018 | 1167018 | 2021-03-28 | Putnam | West Virginia | 54079 | 4506 | 89 |
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);