ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 39093 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812225 | 1812225 | 2021-10-13 | Lorain | Ohio | 39093 | 34632 | 566 |
1808976 | 1808976 | 2021-10-12 | Lorain | Ohio | 39093 | 34466 | 566 |
1805726 | 1805726 | 2021-10-11 | Lorain | Ohio | 39093 | 34336 | 564 |
1802476 | 1802476 | 2021-10-10 | Lorain | Ohio | 39093 | 34252 | 564 |
1799227 | 1799227 | 2021-10-09 | Lorain | Ohio | 39093 | 34093 | 564 |
1795978 | 1795978 | 2021-10-08 | Lorain | Ohio | 39093 | 34018 | 564 |
1792729 | 1792729 | 2021-10-07 | Lorain | Ohio | 39093 | 33833 | 554 |
1789480 | 1789480 | 2021-10-06 | Lorain | Ohio | 39093 | 33643 | 554 |
1786232 | 1786232 | 2021-10-05 | Lorain | Ohio | 39093 | 33513 | 554 |
1782983 | 1782983 | 2021-10-04 | Lorain | Ohio | 39093 | 33317 | 551 |
1779734 | 1779734 | 2021-10-03 | Lorain | Ohio | 39093 | 33160 | 551 |
1776484 | 1776484 | 2021-10-02 | Lorain | Ohio | 39093 | 33070 | 551 |
1773234 | 1773234 | 2021-10-01 | Lorain | Ohio | 39093 | 32932 | 551 |
1769984 | 1769984 | 2021-09-30 | Lorain | Ohio | 39093 | 32810 | 543 |
1766735 | 1766735 | 2021-09-29 | Lorain | Ohio | 39093 | 32641 | 543 |
1763486 | 1763486 | 2021-09-28 | Lorain | Ohio | 39093 | 32467 | 543 |
1760237 | 1760237 | 2021-09-27 | Lorain | Ohio | 39093 | 32263 | 539 |
1756989 | 1756989 | 2021-09-26 | Lorain | Ohio | 39093 | 32165 | 539 |
1753741 | 1753741 | 2021-09-25 | Lorain | Ohio | 39093 | 32046 | 539 |
1750493 | 1750493 | 2021-09-24 | Lorain | Ohio | 39093 | 31922 | 539 |
1747243 | 1747243 | 2021-09-23 | Lorain | Ohio | 39093 | 31748 | 532 |
1743994 | 1743994 | 2021-09-22 | Lorain | Ohio | 39093 | 31567 | 532 |
1740745 | 1740745 | 2021-09-21 | Lorain | Ohio | 39093 | 31418 | 532 |
1737496 | 1737496 | 2021-09-20 | Lorain | Ohio | 39093 | 31241 | 529 |
1734246 | 1734246 | 2021-09-19 | Lorain | Ohio | 39093 | 31113 | 529 |
1730996 | 1730996 | 2021-09-18 | Lorain | Ohio | 39093 | 31004 | 529 |
1727746 | 1727746 | 2021-09-17 | Lorain | Ohio | 39093 | 30874 | 529 |
1724497 | 1724497 | 2021-09-16 | Lorain | Ohio | 39093 | 30651 | 525 |
1721248 | 1721248 | 2021-09-15 | Lorain | Ohio | 39093 | 30438 | 525 |
1718000 | 1718000 | 2021-09-14 | Lorain | Ohio | 39093 | 30240 | 525 |
1714752 | 1714752 | 2021-09-13 | Lorain | Ohio | 39093 | 30075 | 523 |
1711506 | 1711506 | 2021-09-12 | Lorain | Ohio | 39093 | 29907 | 523 |
1708259 | 1708259 | 2021-09-11 | Lorain | Ohio | 39093 | 29804 | 523 |
1705012 | 1705012 | 2021-09-10 | Lorain | Ohio | 39093 | 29584 | 523 |
1701762 | 1701762 | 2021-09-09 | Lorain | Ohio | 39093 | 29426 | 521 |
1698513 | 1698513 | 2021-09-08 | Lorain | Ohio | 39093 | 29209 | 521 |
1695265 | 1695265 | 2021-09-07 | Lorain | Ohio | 39093 | 29089 | 521 |
1692017 | 1692017 | 2021-09-06 | Lorain | Ohio | 39093 | 28949 | 521 |
1688768 | 1688768 | 2021-09-05 | Lorain | Ohio | 39093 | 28792 | 521 |
1685518 | 1685518 | 2021-09-04 | Lorain | Ohio | 39093 | 28701 | 521 |
1682267 | 1682267 | 2021-09-03 | Lorain | Ohio | 39093 | 28547 | 521 |
1679017 | 1679017 | 2021-09-02 | Lorain | Ohio | 39093 | 28426 | 521 |
1675769 | 1675769 | 2021-09-01 | Lorain | Ohio | 39093 | 28279 | 521 |
1672522 | 1672522 | 2021-08-31 | Lorain | Ohio | 39093 | 28177 | 521 |
1669274 | 1669274 | 2021-08-30 | Lorain | Ohio | 39093 | 28095 | 518 |
1666027 | 1666027 | 2021-08-29 | Lorain | Ohio | 39093 | 28005 | 518 |
1662779 | 1662779 | 2021-08-28 | Lorain | Ohio | 39093 | 27908 | 518 |
1659531 | 1659531 | 2021-08-27 | Lorain | Ohio | 39093 | 27787 | 518 |
1656282 | 1656282 | 2021-08-26 | Lorain | Ohio | 39093 | 27698 | 516 |
1653035 | 1653035 | 2021-08-25 | Lorain | Ohio | 39093 | 27579 | 516 |
1649788 | 1649788 | 2021-08-24 | Lorain | Ohio | 39093 | 27479 | 516 |
1646539 | 1646539 | 2021-08-23 | Lorain | Ohio | 39093 | 27403 | 515 |
1643290 | 1643290 | 2021-08-22 | Lorain | Ohio | 39093 | 27350 | 515 |
1640040 | 1640040 | 2021-08-21 | Lorain | Ohio | 39093 | 27300 | 515 |
1636790 | 1636790 | 2021-08-20 | Lorain | Ohio | 39093 | 27221 | 515 |
1633540 | 1633540 | 2021-08-19 | Lorain | Ohio | 39093 | 27149 | 513 |
1630293 | 1630293 | 2021-08-18 | Lorain | Ohio | 39093 | 27058 | 513 |
1627046 | 1627046 | 2021-08-17 | Lorain | Ohio | 39093 | 26990 | 513 |
1623799 | 1623799 | 2021-08-16 | Lorain | Ohio | 39093 | 26922 | 513 |
1620552 | 1620552 | 2021-08-15 | Lorain | Ohio | 39093 | 26872 | 513 |
1617304 | 1617304 | 2021-08-14 | Lorain | Ohio | 39093 | 26825 | 513 |
1614056 | 1614056 | 2021-08-13 | Lorain | Ohio | 39093 | 26772 | 513 |
1610807 | 1610807 | 2021-08-12 | Lorain | Ohio | 39093 | 26719 | 511 |
1607559 | 1607559 | 2021-08-11 | Lorain | Ohio | 39093 | 26650 | 511 |
1604310 | 1604310 | 2021-08-10 | Lorain | Ohio | 39093 | 26581 | 511 |
1601061 | 1601061 | 2021-08-09 | Lorain | Ohio | 39093 | 26516 | 511 |
1597813 | 1597813 | 2021-08-08 | Lorain | Ohio | 39093 | 26474 | 511 |
1594564 | 1594564 | 2021-08-07 | Lorain | Ohio | 39093 | 26443 | 511 |
1591315 | 1591315 | 2021-08-06 | Lorain | Ohio | 39093 | 26406 | 511 |
1588066 | 1588066 | 2021-08-05 | Lorain | Ohio | 39093 | 26364 | 511 |
1584816 | 1584816 | 2021-08-04 | Lorain | Ohio | 39093 | 26317 | 511 |
1581566 | 1581566 | 2021-08-03 | Lorain | Ohio | 39093 | 26232 | 511 |
1578317 | 1578317 | 2021-08-02 | Lorain | Ohio | 39093 | 26204 | 510 |
1575069 | 1575069 | 2021-08-01 | Lorain | Ohio | 39093 | 26190 | 510 |
1571821 | 1571821 | 2021-07-31 | Lorain | Ohio | 39093 | 26166 | 510 |
1568573 | 1568573 | 2021-07-30 | Lorain | Ohio | 39093 | 26135 | 510 |
1565325 | 1565325 | 2021-07-29 | Lorain | Ohio | 39093 | 26104 | 510 |
1562077 | 1562077 | 2021-07-28 | Lorain | Ohio | 39093 | 26072 | 510 |
1558829 | 1558829 | 2021-07-27 | Lorain | Ohio | 39093 | 26029 | 510 |
1555582 | 1555582 | 2021-07-26 | Lorain | Ohio | 39093 | 25996 | 509 |
1552335 | 1552335 | 2021-07-25 | Lorain | Ohio | 39093 | 25975 | 509 |
1549088 | 1549088 | 2021-07-24 | Lorain | Ohio | 39093 | 25956 | 509 |
1545841 | 1545841 | 2021-07-23 | Lorain | Ohio | 39093 | 25937 | 509 |
1542594 | 1542594 | 2021-07-22 | Lorain | Ohio | 39093 | 25918 | 509 |
1539346 | 1539346 | 2021-07-21 | Lorain | Ohio | 39093 | 25877 | 509 |
1536099 | 1536099 | 2021-07-20 | Lorain | Ohio | 39093 | 25859 | 509 |
1532851 | 1532851 | 2021-07-19 | Lorain | Ohio | 39093 | 25840 | 508 |
1529604 | 1529604 | 2021-07-18 | Lorain | Ohio | 39093 | 25826 | 508 |
1526357 | 1526357 | 2021-07-17 | Lorain | Ohio | 39093 | 25818 | 508 |
1523110 | 1523110 | 2021-07-16 | Lorain | Ohio | 39093 | 25806 | 508 |
1519862 | 1519862 | 2021-07-15 | Lorain | Ohio | 39093 | 25796 | 508 |
1516614 | 1516614 | 2021-07-14 | Lorain | Ohio | 39093 | 25782 | 508 |
1513367 | 1513367 | 2021-07-13 | Lorain | Ohio | 39093 | 25773 | 508 |
1510121 | 1510121 | 2021-07-12 | Lorain | Ohio | 39093 | 25773 | 507 |
1506874 | 1506874 | 2021-07-11 | Lorain | Ohio | 39093 | 25768 | 507 |
1503628 | 1503628 | 2021-07-10 | Lorain | Ohio | 39093 | 25763 | 507 |
1500382 | 1500382 | 2021-07-09 | Lorain | Ohio | 39093 | 25760 | 507 |
1497136 | 1497136 | 2021-07-08 | Lorain | Ohio | 39093 | 25754 | 507 |
1493889 | 1493889 | 2021-07-07 | Lorain | Ohio | 39093 | 25751 | 507 |
1490642 | 1490642 | 2021-07-06 | Lorain | Ohio | 39093 | 25739 | 506 |
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);