ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
386 rows where deaths = 37 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1974747 | 1974747 | 2021-12-02 | Vinton | Ohio | 39163 | 1869 | 37 |
1971498 | 1971498 | 2021-12-01 | Vinton | Ohio | 39163 | 1857 | 37 |
1968248 | 1968248 | 2021-11-30 | Vinton | Ohio | 39163 | 1843 | 37 |
1964997 | 1964997 | 2021-11-29 | Vinton | Ohio | 39163 | 1839 | 37 |
1961745 | 1961745 | 2021-11-28 | Vinton | Ohio | 39163 | 1828 | 37 |
1958494 | 1958494 | 2021-11-27 | Vinton | Ohio | 39163 | 1820 | 37 |
1955243 | 1955243 | 2021-11-26 | Vinton | Ohio | 39163 | 1816 | 37 |
1919464 | 1919464 | 2021-11-15 | Morgan | Ohio | 39115 | 2008 | 37 |
1916214 | 1916214 | 2021-11-14 | Morgan | Ohio | 39115 | 2007 | 37 |
1912964 | 1912964 | 2021-11-13 | Morgan | Ohio | 39115 | 2003 | 37 |
1909714 | 1909714 | 2021-11-12 | Morgan | Ohio | 39115 | 1997 | 37 |
1906465 | 1906465 | 2021-11-11 | Morgan | Ohio | 39115 | 1993 | 37 |
1903216 | 1903216 | 2021-11-10 | Morgan | Ohio | 39115 | 1986 | 37 |
1899966 | 1899966 | 2021-11-09 | Morgan | Ohio | 39115 | 1983 | 37 |
1646558 | 1646558 | 2021-08-23 | Pike | Ohio | 39131 | 2675 | 37 |
1643309 | 1643309 | 2021-08-22 | Pike | Ohio | 39131 | 2671 | 37 |
1640059 | 1640059 | 2021-08-21 | Pike | Ohio | 39131 | 2667 | 37 |
1636809 | 1636809 | 2021-08-20 | Pike | Ohio | 39131 | 2657 | 37 |
1633559 | 1633559 | 2021-08-19 | Pike | Ohio | 39131 | 2635 | 37 |
1630312 | 1630312 | 2021-08-18 | Pike | Ohio | 39131 | 2615 | 37 |
1627065 | 1627065 | 2021-08-17 | Pike | Ohio | 39131 | 2601 | 37 |
1623818 | 1623818 | 2021-08-16 | Pike | Ohio | 39131 | 2580 | 37 |
1620571 | 1620571 | 2021-08-15 | Pike | Ohio | 39131 | 2578 | 37 |
1617323 | 1617323 | 2021-08-14 | Pike | Ohio | 39131 | 2566 | 37 |
1614075 | 1614075 | 2021-08-13 | Pike | Ohio | 39131 | 2561 | 37 |
1610826 | 1610826 | 2021-08-12 | Pike | Ohio | 39131 | 2545 | 37 |
1607578 | 1607578 | 2021-08-11 | Pike | Ohio | 39131 | 2523 | 37 |
1604329 | 1604329 | 2021-08-10 | Pike | Ohio | 39131 | 2511 | 37 |
1601080 | 1601080 | 2021-08-09 | Pike | Ohio | 39131 | 2506 | 37 |
1597832 | 1597832 | 2021-08-08 | Pike | Ohio | 39131 | 2496 | 37 |
1594583 | 1594583 | 2021-08-07 | Pike | Ohio | 39131 | 2487 | 37 |
1591334 | 1591334 | 2021-08-06 | Pike | Ohio | 39131 | 2481 | 37 |
1588085 | 1588085 | 2021-08-05 | Pike | Ohio | 39131 | 2477 | 37 |
1584835 | 1584835 | 2021-08-04 | Pike | Ohio | 39131 | 2476 | 37 |
1581585 | 1581585 | 2021-08-03 | Pike | Ohio | 39131 | 2471 | 37 |
1578336 | 1578336 | 2021-08-02 | Pike | Ohio | 39131 | 2468 | 37 |
1575088 | 1575088 | 2021-08-01 | Pike | Ohio | 39131 | 2464 | 37 |
1571840 | 1571840 | 2021-07-31 | Pike | Ohio | 39131 | 2460 | 37 |
1568592 | 1568592 | 2021-07-30 | Pike | Ohio | 39131 | 2455 | 37 |
1565344 | 1565344 | 2021-07-29 | Pike | Ohio | 39131 | 2451 | 37 |
1562096 | 1562096 | 2021-07-28 | Pike | Ohio | 39131 | 2448 | 37 |
1558848 | 1558848 | 2021-07-27 | Pike | Ohio | 39131 | 2447 | 37 |
1555601 | 1555601 | 2021-07-26 | Pike | Ohio | 39131 | 2446 | 37 |
1552354 | 1552354 | 2021-07-25 | Pike | Ohio | 39131 | 2445 | 37 |
1549107 | 1549107 | 2021-07-24 | Pike | Ohio | 39131 | 2445 | 37 |
1545860 | 1545860 | 2021-07-23 | Pike | Ohio | 39131 | 2445 | 37 |
1542613 | 1542613 | 2021-07-22 | Pike | Ohio | 39131 | 2445 | 37 |
1539365 | 1539365 | 2021-07-21 | Pike | Ohio | 39131 | 2445 | 37 |
1536118 | 1536118 | 2021-07-20 | Pike | Ohio | 39131 | 2443 | 37 |
1532870 | 1532870 | 2021-07-19 | Pike | Ohio | 39131 | 2440 | 37 |
1529623 | 1529623 | 2021-07-18 | Pike | Ohio | 39131 | 2439 | 37 |
1526376 | 1526376 | 2021-07-17 | Pike | Ohio | 39131 | 2438 | 37 |
1523129 | 1523129 | 2021-07-16 | Pike | Ohio | 39131 | 2437 | 37 |
1519881 | 1519881 | 2021-07-15 | Pike | Ohio | 39131 | 2437 | 37 |
1516633 | 1516633 | 2021-07-14 | Pike | Ohio | 39131 | 2435 | 37 |
1513386 | 1513386 | 2021-07-13 | Pike | Ohio | 39131 | 2432 | 37 |
1510140 | 1510140 | 2021-07-12 | Pike | Ohio | 39131 | 2432 | 37 |
1506893 | 1506893 | 2021-07-11 | Pike | Ohio | 39131 | 2432 | 37 |
1503647 | 1503647 | 2021-07-10 | Pike | Ohio | 39131 | 2431 | 37 |
1500401 | 1500401 | 2021-07-09 | Pike | Ohio | 39131 | 2430 | 37 |
1497155 | 1497155 | 2021-07-08 | Pike | Ohio | 39131 | 2430 | 37 |
1493908 | 1493908 | 2021-07-07 | Pike | Ohio | 39131 | 2430 | 37 |
1406240 | 1406240 | 2021-06-10 | Harrison | Ohio | 39067 | 1136 | 37 |
1402994 | 1402994 | 2021-06-09 | Harrison | Ohio | 39067 | 1136 | 37 |
1399749 | 1399749 | 2021-06-08 | Harrison | Ohio | 39067 | 1135 | 37 |
1396504 | 1396504 | 2021-06-07 | Harrison | Ohio | 39067 | 1135 | 37 |
1393257 | 1393257 | 2021-06-06 | Harrison | Ohio | 39067 | 1135 | 37 |
1390012 | 1390012 | 2021-06-05 | Harrison | Ohio | 39067 | 1135 | 37 |
1386767 | 1386767 | 2021-06-04 | Harrison | Ohio | 39067 | 1134 | 37 |
1383522 | 1383522 | 2021-06-03 | Harrison | Ohio | 39067 | 1134 | 37 |
1380276 | 1380276 | 2021-06-02 | Harrison | Ohio | 39067 | 1136 | 37 |
1377031 | 1377031 | 2021-06-01 | Harrison | Ohio | 39067 | 1132 | 37 |
1373785 | 1373785 | 2021-05-31 | Harrison | Ohio | 39067 | 1131 | 37 |
1370540 | 1370540 | 2021-05-30 | Harrison | Ohio | 39067 | 1131 | 37 |
1367294 | 1367294 | 2021-05-29 | Harrison | Ohio | 39067 | 1130 | 37 |
1364048 | 1364048 | 2021-05-28 | Harrison | Ohio | 39067 | 1129 | 37 |
1360802 | 1360802 | 2021-05-27 | Harrison | Ohio | 39067 | 1129 | 37 |
1357556 | 1357556 | 2021-05-26 | Harrison | Ohio | 39067 | 1121 | 37 |
1354310 | 1354310 | 2021-05-25 | Harrison | Ohio | 39067 | 1114 | 37 |
1351064 | 1351064 | 2021-05-24 | Harrison | Ohio | 39067 | 1112 | 37 |
1347818 | 1347818 | 2021-05-23 | Harrison | Ohio | 39067 | 1108 | 37 |
1344570 | 1344570 | 2021-05-22 | Harrison | Ohio | 39067 | 1107 | 37 |
1341322 | 1341322 | 2021-05-21 | Harrison | Ohio | 39067 | 1106 | 37 |
1338074 | 1338074 | 2021-05-20 | Harrison | Ohio | 39067 | 1105 | 37 |
1338101 | 1338101 | 2021-05-20 | Noble | Ohio | 39121 | 1343 | 37 |
1334827 | 1334827 | 2021-05-19 | Harrison | Ohio | 39067 | 1104 | 37 |
1334854 | 1334854 | 2021-05-19 | Noble | Ohio | 39121 | 1341 | 37 |
1331580 | 1331580 | 2021-05-18 | Harrison | Ohio | 39067 | 1098 | 37 |
1331607 | 1331607 | 2021-05-18 | Noble | Ohio | 39121 | 1341 | 37 |
1328333 | 1328333 | 2021-05-17 | Harrison | Ohio | 39067 | 1096 | 37 |
1328360 | 1328360 | 2021-05-17 | Noble | Ohio | 39121 | 1341 | 37 |
1325087 | 1325087 | 2021-05-16 | Harrison | Ohio | 39067 | 1096 | 37 |
1325114 | 1325114 | 2021-05-16 | Noble | Ohio | 39121 | 1341 | 37 |
1321841 | 1321841 | 2021-05-15 | Harrison | Ohio | 39067 | 1092 | 37 |
1321868 | 1321868 | 2021-05-15 | Noble | Ohio | 39121 | 1341 | 37 |
1318595 | 1318595 | 2021-05-14 | Harrison | Ohio | 39067 | 1092 | 37 |
1318622 | 1318622 | 2021-05-14 | Noble | Ohio | 39121 | 1337 | 37 |
1315347 | 1315347 | 2021-05-13 | Harrison | Ohio | 39067 | 1090 | 37 |
1315374 | 1315374 | 2021-05-13 | Noble | Ohio | 39121 | 1336 | 37 |
1312101 | 1312101 | 2021-05-12 | Harrison | Ohio | 39067 | 1088 | 37 |
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);