ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where fips = 39125 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419250 | 1419250 | 2021-06-14 | Paulding | Ohio | 39125 | 1763 | 42 |
1416005 | 1416005 | 2021-06-13 | Paulding | Ohio | 39125 | 1763 | 42 |
1412759 | 1412759 | 2021-06-12 | Paulding | Ohio | 39125 | 1763 | 42 |
1409514 | 1409514 | 2021-06-11 | Paulding | Ohio | 39125 | 1763 | 42 |
1406269 | 1406269 | 2021-06-10 | Paulding | Ohio | 39125 | 1763 | 41 |
1403023 | 1403023 | 2021-06-09 | Paulding | Ohio | 39125 | 1760 | 41 |
1399778 | 1399778 | 2021-06-08 | Paulding | Ohio | 39125 | 1760 | 41 |
1396533 | 1396533 | 2021-06-07 | Paulding | Ohio | 39125 | 1760 | 41 |
1393286 | 1393286 | 2021-06-06 | Paulding | Ohio | 39125 | 1760 | 41 |
1390041 | 1390041 | 2021-06-05 | Paulding | Ohio | 39125 | 1760 | 41 |
1386796 | 1386796 | 2021-06-04 | Paulding | Ohio | 39125 | 1760 | 41 |
1383551 | 1383551 | 2021-06-03 | Paulding | Ohio | 39125 | 1760 | 41 |
1380305 | 1380305 | 2021-06-02 | Paulding | Ohio | 39125 | 1758 | 41 |
1377060 | 1377060 | 2021-06-01 | Paulding | Ohio | 39125 | 1757 | 41 |
1373814 | 1373814 | 2021-05-31 | Paulding | Ohio | 39125 | 1757 | 41 |
1370569 | 1370569 | 2021-05-30 | Paulding | Ohio | 39125 | 1757 | 41 |
1367323 | 1367323 | 2021-05-29 | Paulding | Ohio | 39125 | 1757 | 41 |
1364077 | 1364077 | 2021-05-28 | Paulding | Ohio | 39125 | 1757 | 41 |
1360831 | 1360831 | 2021-05-27 | Paulding | Ohio | 39125 | 1755 | 41 |
1357585 | 1357585 | 2021-05-26 | Paulding | Ohio | 39125 | 1755 | 41 |
1354339 | 1354339 | 2021-05-25 | Paulding | Ohio | 39125 | 1755 | 41 |
1351093 | 1351093 | 2021-05-24 | Paulding | Ohio | 39125 | 1751 | 41 |
1347847 | 1347847 | 2021-05-23 | Paulding | Ohio | 39125 | 1751 | 41 |
1344599 | 1344599 | 2021-05-22 | Paulding | Ohio | 39125 | 1751 | 41 |
1341351 | 1341351 | 2021-05-21 | Paulding | Ohio | 39125 | 1750 | 41 |
1338103 | 1338103 | 2021-05-20 | Paulding | Ohio | 39125 | 1750 | 41 |
1334856 | 1334856 | 2021-05-19 | Paulding | Ohio | 39125 | 1746 | 41 |
1331609 | 1331609 | 2021-05-18 | Paulding | Ohio | 39125 | 1745 | 41 |
1328362 | 1328362 | 2021-05-17 | Paulding | Ohio | 39125 | 1743 | 40 |
1325116 | 1325116 | 2021-05-16 | Paulding | Ohio | 39125 | 1740 | 40 |
1321870 | 1321870 | 2021-05-15 | Paulding | Ohio | 39125 | 1740 | 40 |
1318624 | 1318624 | 2021-05-14 | Paulding | Ohio | 39125 | 1739 | 40 |
1315376 | 1315376 | 2021-05-13 | Paulding | Ohio | 39125 | 1735 | 40 |
1312130 | 1312130 | 2021-05-12 | Paulding | Ohio | 39125 | 1734 | 40 |
1308883 | 1308883 | 2021-05-11 | Paulding | Ohio | 39125 | 1733 | 40 |
1305637 | 1305637 | 2021-05-10 | Paulding | Ohio | 39125 | 1728 | 40 |
1302391 | 1302391 | 2021-05-09 | Paulding | Ohio | 39125 | 1726 | 40 |
1299143 | 1299143 | 2021-05-08 | Paulding | Ohio | 39125 | 1726 | 40 |
1295897 | 1295897 | 2021-05-07 | Paulding | Ohio | 39125 | 1725 | 40 |
1292651 | 1292651 | 2021-05-06 | Paulding | Ohio | 39125 | 1724 | 40 |
1289405 | 1289405 | 2021-05-05 | Paulding | Ohio | 39125 | 1717 | 40 |
1286159 | 1286159 | 2021-05-04 | Paulding | Ohio | 39125 | 1711 | 40 |
1282913 | 1282913 | 2021-05-03 | Paulding | Ohio | 39125 | 1708 | 39 |
1279666 | 1279666 | 2021-05-02 | Paulding | Ohio | 39125 | 1707 | 39 |
1276419 | 1276419 | 2021-05-01 | Paulding | Ohio | 39125 | 1707 | 39 |
1273172 | 1273172 | 2021-04-30 | Paulding | Ohio | 39125 | 1705 | 39 |
1269925 | 1269925 | 2021-04-29 | Paulding | Ohio | 39125 | 1705 | 39 |
1266678 | 1266678 | 2021-04-28 | Paulding | Ohio | 39125 | 1702 | 39 |
1263431 | 1263431 | 2021-04-27 | Paulding | Ohio | 39125 | 1699 | 39 |
1260184 | 1260184 | 2021-04-26 | Paulding | Ohio | 39125 | 1698 | 39 |
1256937 | 1256937 | 2021-04-25 | Paulding | Ohio | 39125 | 1696 | 39 |
1253690 | 1253690 | 2021-04-24 | Paulding | Ohio | 39125 | 1696 | 39 |
1250443 | 1250443 | 2021-04-23 | Paulding | Ohio | 39125 | 1693 | 39 |
1247196 | 1247196 | 2021-04-22 | Paulding | Ohio | 39125 | 1692 | 39 |
1243949 | 1243949 | 2021-04-21 | Paulding | Ohio | 39125 | 1692 | 39 |
1240702 | 1240702 | 2021-04-20 | Paulding | Ohio | 39125 | 1691 | 39 |
1237455 | 1237455 | 2021-04-19 | Paulding | Ohio | 39125 | 1688 | 38 |
1234208 | 1234208 | 2021-04-18 | Paulding | Ohio | 39125 | 1687 | 38 |
1230960 | 1230960 | 2021-04-17 | Paulding | Ohio | 39125 | 1686 | 38 |
1227712 | 1227712 | 2021-04-16 | Paulding | Ohio | 39125 | 1686 | 38 |
1224464 | 1224464 | 2021-04-15 | Paulding | Ohio | 39125 | 1685 | 38 |
1221217 | 1221217 | 2021-04-14 | Paulding | Ohio | 39125 | 1682 | 38 |
1217969 | 1217969 | 2021-04-13 | Paulding | Ohio | 39125 | 1677 | 38 |
1214721 | 1214721 | 2021-04-12 | Paulding | Ohio | 39125 | 1677 | 38 |
1211474 | 1211474 | 2021-04-11 | Paulding | Ohio | 39125 | 1676 | 38 |
1208225 | 1208225 | 2021-04-10 | Paulding | Ohio | 39125 | 1675 | 38 |
1204977 | 1204977 | 2021-04-09 | Paulding | Ohio | 39125 | 1674 | 38 |
1201729 | 1201729 | 2021-04-08 | Paulding | Ohio | 39125 | 1672 | 38 |
1198480 | 1198480 | 2021-04-07 | Paulding | Ohio | 39125 | 1672 | 38 |
1195231 | 1195231 | 2021-04-06 | Paulding | Ohio | 39125 | 1672 | 38 |
1191983 | 1191983 | 2021-04-05 | Paulding | Ohio | 39125 | 1671 | 38 |
1188734 | 1188734 | 2021-04-04 | Paulding | Ohio | 39125 | 1669 | 38 |
1185487 | 1185487 | 2021-04-03 | Paulding | Ohio | 39125 | 1669 | 38 |
1182240 | 1182240 | 2021-04-02 | Paulding | Ohio | 39125 | 1667 | 38 |
1178993 | 1178993 | 2021-04-01 | Paulding | Ohio | 39125 | 1666 | 38 |
1175746 | 1175746 | 2021-03-31 | Paulding | Ohio | 39125 | 1662 | 38 |
1172499 | 1172499 | 2021-03-30 | Paulding | Ohio | 39125 | 1659 | 38 |
1169252 | 1169252 | 2021-03-29 | Paulding | Ohio | 39125 | 1657 | 38 |
1166004 | 1166004 | 2021-03-28 | Paulding | Ohio | 39125 | 1655 | 38 |
1162756 | 1162756 | 2021-03-27 | Paulding | Ohio | 39125 | 1655 | 38 |
1159507 | 1159507 | 2021-03-26 | Paulding | Ohio | 39125 | 1654 | 38 |
1156260 | 1156260 | 2021-03-25 | Paulding | Ohio | 39125 | 1650 | 36 |
1153013 | 1153013 | 2021-03-24 | Paulding | Ohio | 39125 | 1650 | 36 |
1149766 | 1149766 | 2021-03-23 | Paulding | Ohio | 39125 | 1648 | 36 |
1146519 | 1146519 | 2021-03-22 | Paulding | Ohio | 39125 | 1647 | 36 |
1143272 | 1143272 | 2021-03-21 | Paulding | Ohio | 39125 | 1647 | 36 |
1140025 | 1140025 | 2021-03-20 | Paulding | Ohio | 39125 | 1645 | 36 |
1136779 | 1136779 | 2021-03-19 | Paulding | Ohio | 39125 | 1645 | 36 |
1133533 | 1133533 | 2021-03-18 | Paulding | Ohio | 39125 | 1644 | 35 |
1130285 | 1130285 | 2021-03-17 | Paulding | Ohio | 39125 | 1642 | 35 |
1127038 | 1127038 | 2021-03-16 | Paulding | Ohio | 39125 | 1639 | 35 |
1123792 | 1123792 | 2021-03-15 | Paulding | Ohio | 39125 | 1634 | 35 |
1120546 | 1120546 | 2021-03-14 | Paulding | Ohio | 39125 | 1632 | 35 |
1117299 | 1117299 | 2021-03-13 | Paulding | Ohio | 39125 | 1632 | 35 |
1114052 | 1114052 | 2021-03-12 | Paulding | Ohio | 39125 | 1628 | 35 |
1110806 | 1110806 | 2021-03-11 | Paulding | Ohio | 39125 | 1625 | 34 |
1107560 | 1107560 | 2021-03-10 | Paulding | Ohio | 39125 | 1625 | 34 |
1104314 | 1104314 | 2021-03-09 | Paulding | Ohio | 39125 | 1619 | 34 |
1101068 | 1101068 | 2021-03-08 | Paulding | Ohio | 39125 | 1613 | 34 |
1097822 | 1097822 | 2021-03-07 | Paulding | Ohio | 39125 | 1611 | 34 |
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);