ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 47005 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419657 | 1419657 | 2021-06-14 | Benton | Tennessee | 47005 | 1687 | 42 |
1416412 | 1416412 | 2021-06-13 | Benton | Tennessee | 47005 | 1687 | 42 |
1413166 | 1413166 | 2021-06-12 | Benton | Tennessee | 47005 | 1687 | 42 |
1409921 | 1409921 | 2021-06-11 | Benton | Tennessee | 47005 | 1687 | 42 |
1406676 | 1406676 | 2021-06-10 | Benton | Tennessee | 47005 | 1684 | 42 |
1403430 | 1403430 | 2021-06-09 | Benton | Tennessee | 47005 | 1683 | 42 |
1400185 | 1400185 | 2021-06-08 | Benton | Tennessee | 47005 | 1685 | 42 |
1396940 | 1396940 | 2021-06-07 | Benton | Tennessee | 47005 | 1684 | 42 |
1393693 | 1393693 | 2021-06-06 | Benton | Tennessee | 47005 | 1684 | 42 |
1390448 | 1390448 | 2021-06-05 | Benton | Tennessee | 47005 | 1684 | 42 |
1387203 | 1387203 | 2021-06-04 | Benton | Tennessee | 47005 | 1684 | 42 |
1383958 | 1383958 | 2021-06-03 | Benton | Tennessee | 47005 | 1682 | 42 |
1380712 | 1380712 | 2021-06-02 | Benton | Tennessee | 47005 | 1682 | 42 |
1377467 | 1377467 | 2021-06-01 | Benton | Tennessee | 47005 | 1682 | 41 |
1374221 | 1374221 | 2021-05-31 | Benton | Tennessee | 47005 | 1679 | 41 |
1370976 | 1370976 | 2021-05-30 | Benton | Tennessee | 47005 | 1679 | 41 |
1367730 | 1367730 | 2021-05-29 | Benton | Tennessee | 47005 | 1679 | 41 |
1364484 | 1364484 | 2021-05-28 | Benton | Tennessee | 47005 | 1679 | 41 |
1361238 | 1361238 | 2021-05-27 | Benton | Tennessee | 47005 | 1681 | 41 |
1357992 | 1357992 | 2021-05-26 | Benton | Tennessee | 47005 | 1683 | 40 |
1354746 | 1354746 | 2021-05-25 | Benton | Tennessee | 47005 | 1682 | 40 |
1351500 | 1351500 | 2021-05-24 | Benton | Tennessee | 47005 | 1682 | 40 |
1348254 | 1348254 | 2021-05-23 | Benton | Tennessee | 47005 | 1682 | 40 |
1345006 | 1345006 | 2021-05-22 | Benton | Tennessee | 47005 | 1682 | 40 |
1341758 | 1341758 | 2021-05-21 | Benton | Tennessee | 47005 | 1682 | 40 |
1338510 | 1338510 | 2021-05-20 | Benton | Tennessee | 47005 | 1682 | 40 |
1335263 | 1335263 | 2021-05-19 | Benton | Tennessee | 47005 | 1682 | 40 |
1332016 | 1332016 | 2021-05-18 | Benton | Tennessee | 47005 | 1680 | 40 |
1328769 | 1328769 | 2021-05-17 | Benton | Tennessee | 47005 | 1676 | 40 |
1325523 | 1325523 | 2021-05-16 | Benton | Tennessee | 47005 | 1673 | 40 |
1322277 | 1322277 | 2021-05-15 | Benton | Tennessee | 47005 | 1673 | 40 |
1319031 | 1319031 | 2021-05-14 | Benton | Tennessee | 47005 | 1673 | 40 |
1315783 | 1315783 | 2021-05-13 | Benton | Tennessee | 47005 | 1670 | 40 |
1312537 | 1312537 | 2021-05-12 | Benton | Tennessee | 47005 | 1670 | 40 |
1309290 | 1309290 | 2021-05-11 | Benton | Tennessee | 47005 | 1666 | 40 |
1306044 | 1306044 | 2021-05-10 | Benton | Tennessee | 47005 | 1667 | 40 |
1302798 | 1302798 | 2021-05-09 | Benton | Tennessee | 47005 | 1665 | 40 |
1299551 | 1299551 | 2021-05-08 | Benton | Tennessee | 47005 | 1665 | 40 |
1296304 | 1296304 | 2021-05-07 | Benton | Tennessee | 47005 | 1665 | 40 |
1293058 | 1293058 | 2021-05-06 | Benton | Tennessee | 47005 | 1659 | 40 |
1289812 | 1289812 | 2021-05-05 | Benton | Tennessee | 47005 | 1657 | 40 |
1286566 | 1286566 | 2021-05-04 | Benton | Tennessee | 47005 | 1657 | 40 |
1283320 | 1283320 | 2021-05-03 | Benton | Tennessee | 47005 | 1656 | 40 |
1280073 | 1280073 | 2021-05-02 | Benton | Tennessee | 47005 | 1652 | 40 |
1276826 | 1276826 | 2021-05-01 | Benton | Tennessee | 47005 | 1652 | 40 |
1273579 | 1273579 | 2021-04-30 | Benton | Tennessee | 47005 | 1652 | 40 |
1270332 | 1270332 | 2021-04-29 | Benton | Tennessee | 47005 | 1654 | 40 |
1267085 | 1267085 | 2021-04-28 | Benton | Tennessee | 47005 | 1650 | 40 |
1263838 | 1263838 | 2021-04-27 | Benton | Tennessee | 47005 | 1644 | 40 |
1260591 | 1260591 | 2021-04-26 | Benton | Tennessee | 47005 | 1643 | 40 |
1257344 | 1257344 | 2021-04-25 | Benton | Tennessee | 47005 | 1640 | 40 |
1254097 | 1254097 | 2021-04-24 | Benton | Tennessee | 47005 | 1640 | 40 |
1250850 | 1250850 | 2021-04-23 | Benton | Tennessee | 47005 | 1640 | 40 |
1247603 | 1247603 | 2021-04-22 | Benton | Tennessee | 47005 | 1634 | 40 |
1244356 | 1244356 | 2021-04-21 | Benton | Tennessee | 47005 | 1634 | 40 |
1241109 | 1241109 | 2021-04-20 | Benton | Tennessee | 47005 | 1631 | 40 |
1237862 | 1237862 | 2021-04-19 | Benton | Tennessee | 47005 | 1632 | 40 |
1234615 | 1234615 | 2021-04-18 | Benton | Tennessee | 47005 | 1629 | 40 |
1231367 | 1231367 | 2021-04-17 | Benton | Tennessee | 47005 | 1629 | 40 |
1228119 | 1228119 | 2021-04-16 | Benton | Tennessee | 47005 | 1629 | 40 |
1224871 | 1224871 | 2021-04-15 | Benton | Tennessee | 47005 | 1628 | 40 |
1221624 | 1221624 | 2021-04-14 | Benton | Tennessee | 47005 | 1623 | 40 |
1218376 | 1218376 | 2021-04-13 | Benton | Tennessee | 47005 | 1620 | 40 |
1215128 | 1215128 | 2021-04-12 | Benton | Tennessee | 47005 | 1617 | 40 |
1211881 | 1211881 | 2021-04-11 | Benton | Tennessee | 47005 | 1609 | 40 |
1208632 | 1208632 | 2021-04-10 | Benton | Tennessee | 47005 | 1609 | 40 |
1205384 | 1205384 | 2021-04-09 | Benton | Tennessee | 47005 | 1609 | 40 |
1202136 | 1202136 | 2021-04-08 | Benton | Tennessee | 47005 | 1607 | 40 |
1198887 | 1198887 | 2021-04-07 | Benton | Tennessee | 47005 | 1600 | 40 |
1195638 | 1195638 | 2021-04-06 | Benton | Tennessee | 47005 | 1596 | 40 |
1192390 | 1192390 | 2021-04-05 | Benton | Tennessee | 47005 | 1594 | 40 |
1189141 | 1189141 | 2021-04-04 | Benton | Tennessee | 47005 | 1576 | 40 |
1185894 | 1185894 | 2021-04-03 | Benton | Tennessee | 47005 | 1576 | 40 |
1182647 | 1182647 | 2021-04-02 | Benton | Tennessee | 47005 | 1576 | 40 |
1179400 | 1179400 | 2021-04-01 | Benton | Tennessee | 47005 | 1576 | 40 |
1176153 | 1176153 | 2021-03-31 | Benton | Tennessee | 47005 | 1571 | 40 |
1172906 | 1172906 | 2021-03-30 | Benton | Tennessee | 47005 | 1568 | 40 |
1169659 | 1169659 | 2021-03-29 | Benton | Tennessee | 47005 | 1564 | 40 |
1166411 | 1166411 | 2021-03-28 | Benton | Tennessee | 47005 | 1561 | 39 |
1163163 | 1163163 | 2021-03-27 | Benton | Tennessee | 47005 | 1561 | 39 |
1159914 | 1159914 | 2021-03-26 | Benton | Tennessee | 47005 | 1561 | 39 |
1156667 | 1156667 | 2021-03-25 | Benton | Tennessee | 47005 | 1559 | 39 |
1153420 | 1153420 | 2021-03-24 | Benton | Tennessee | 47005 | 1554 | 39 |
1150173 | 1150173 | 2021-03-23 | Benton | Tennessee | 47005 | 1545 | 39 |
1146926 | 1146926 | 2021-03-22 | Benton | Tennessee | 47005 | 1543 | 39 |
1143679 | 1143679 | 2021-03-21 | Benton | Tennessee | 47005 | 1540 | 39 |
1140432 | 1140432 | 2021-03-20 | Benton | Tennessee | 47005 | 1540 | 39 |
1137186 | 1137186 | 2021-03-19 | Benton | Tennessee | 47005 | 1540 | 39 |
1133940 | 1133940 | 2021-03-18 | Benton | Tennessee | 47005 | 1537 | 39 |
1130692 | 1130692 | 2021-03-17 | Benton | Tennessee | 47005 | 1534 | 39 |
1127445 | 1127445 | 2021-03-16 | Benton | Tennessee | 47005 | 1528 | 39 |
1124199 | 1124199 | 2021-03-15 | Benton | Tennessee | 47005 | 1527 | 39 |
1120953 | 1120953 | 2021-03-14 | Benton | Tennessee | 47005 | 1525 | 39 |
1117706 | 1117706 | 2021-03-13 | Benton | Tennessee | 47005 | 1525 | 39 |
1114459 | 1114459 | 2021-03-12 | Benton | Tennessee | 47005 | 1525 | 39 |
1111213 | 1111213 | 2021-03-11 | Benton | Tennessee | 47005 | 1520 | 39 |
1107967 | 1107967 | 2021-03-10 | Benton | Tennessee | 47005 | 1517 | 39 |
1104721 | 1104721 | 2021-03-09 | Benton | Tennessee | 47005 | 1514 | 39 |
1101475 | 1101475 | 2021-03-08 | Benton | Tennessee | 47005 | 1513 | 39 |
1098229 | 1098229 | 2021-03-07 | Benton | Tennessee | 47005 | 1513 | 39 |
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);