ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 39159 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812258 | 1812258 | 2021-10-13 | Union | Ohio | 39159 | 8017 | 55 |
1809009 | 1809009 | 2021-10-12 | Union | Ohio | 39159 | 7994 | 55 |
1805759 | 1805759 | 2021-10-11 | Union | Ohio | 39159 | 7962 | 55 |
1802509 | 1802509 | 2021-10-10 | Union | Ohio | 39159 | 7953 | 55 |
1799260 | 1799260 | 2021-10-09 | Union | Ohio | 39159 | 7933 | 55 |
1796011 | 1796011 | 2021-10-08 | Union | Ohio | 39159 | 7922 | 55 |
1792762 | 1792762 | 2021-10-07 | Union | Ohio | 39159 | 7883 | 54 |
1789513 | 1789513 | 2021-10-06 | Union | Ohio | 39159 | 7837 | 54 |
1786265 | 1786265 | 2021-10-05 | Union | Ohio | 39159 | 7794 | 54 |
1783016 | 1783016 | 2021-10-04 | Union | Ohio | 39159 | 7759 | 53 |
1779767 | 1779767 | 2021-10-03 | Union | Ohio | 39159 | 7729 | 53 |
1776517 | 1776517 | 2021-10-02 | Union | Ohio | 39159 | 7719 | 53 |
1773267 | 1773267 | 2021-10-01 | Union | Ohio | 39159 | 7681 | 53 |
1770017 | 1770017 | 2021-09-30 | Union | Ohio | 39159 | 7618 | 51 |
1766768 | 1766768 | 2021-09-29 | Union | Ohio | 39159 | 7581 | 51 |
1763519 | 1763519 | 2021-09-28 | Union | Ohio | 39159 | 7526 | 51 |
1760270 | 1760270 | 2021-09-27 | Union | Ohio | 39159 | 7453 | 51 |
1757022 | 1757022 | 2021-09-26 | Union | Ohio | 39159 | 7439 | 51 |
1753774 | 1753774 | 2021-09-25 | Union | Ohio | 39159 | 7426 | 51 |
1750526 | 1750526 | 2021-09-24 | Union | Ohio | 39159 | 7407 | 51 |
1747276 | 1747276 | 2021-09-23 | Union | Ohio | 39159 | 7366 | 51 |
1744027 | 1744027 | 2021-09-22 | Union | Ohio | 39159 | 7318 | 51 |
1740778 | 1740778 | 2021-09-21 | Union | Ohio | 39159 | 7264 | 51 |
1737529 | 1737529 | 2021-09-20 | Union | Ohio | 39159 | 7216 | 49 |
1734279 | 1734279 | 2021-09-19 | Union | Ohio | 39159 | 7192 | 49 |
1731029 | 1731029 | 2021-09-18 | Union | Ohio | 39159 | 7178 | 49 |
1727779 | 1727779 | 2021-09-17 | Union | Ohio | 39159 | 7141 | 49 |
1724530 | 1724530 | 2021-09-16 | Union | Ohio | 39159 | 7092 | 49 |
1721281 | 1721281 | 2021-09-15 | Union | Ohio | 39159 | 7035 | 49 |
1718033 | 1718033 | 2021-09-14 | Union | Ohio | 39159 | 7004 | 49 |
1714785 | 1714785 | 2021-09-13 | Union | Ohio | 39159 | 6960 | 49 |
1711539 | 1711539 | 2021-09-12 | Union | Ohio | 39159 | 6934 | 49 |
1708292 | 1708292 | 2021-09-11 | Union | Ohio | 39159 | 6915 | 49 |
1705045 | 1705045 | 2021-09-10 | Union | Ohio | 39159 | 6877 | 49 |
1701795 | 1701795 | 2021-09-09 | Union | Ohio | 39159 | 6819 | 49 |
1698546 | 1698546 | 2021-09-08 | Union | Ohio | 39159 | 6753 | 49 |
1695298 | 1695298 | 2021-09-07 | Union | Ohio | 39159 | 6689 | 49 |
1692050 | 1692050 | 2021-09-06 | Union | Ohio | 39159 | 6674 | 49 |
1688801 | 1688801 | 2021-09-05 | Union | Ohio | 39159 | 6655 | 49 |
1685551 | 1685551 | 2021-09-04 | Union | Ohio | 39159 | 6625 | 49 |
1682300 | 1682300 | 2021-09-03 | Union | Ohio | 39159 | 6581 | 49 |
1679050 | 1679050 | 2021-09-02 | Union | Ohio | 39159 | 6526 | 49 |
1675802 | 1675802 | 2021-09-01 | Union | Ohio | 39159 | 6482 | 49 |
1672555 | 1672555 | 2021-08-31 | Union | Ohio | 39159 | 6423 | 49 |
1669307 | 1669307 | 2021-08-30 | Union | Ohio | 39159 | 6378 | 49 |
1666060 | 1666060 | 2021-08-29 | Union | Ohio | 39159 | 6366 | 49 |
1662812 | 1662812 | 2021-08-28 | Union | Ohio | 39159 | 6346 | 49 |
1659564 | 1659564 | 2021-08-27 | Union | Ohio | 39159 | 6314 | 49 |
1656315 | 1656315 | 2021-08-26 | Union | Ohio | 39159 | 6289 | 49 |
1653068 | 1653068 | 2021-08-25 | Union | Ohio | 39159 | 6249 | 49 |
1649821 | 1649821 | 2021-08-24 | Union | Ohio | 39159 | 6223 | 49 |
1646572 | 1646572 | 2021-08-23 | Union | Ohio | 39159 | 6185 | 49 |
1643323 | 1643323 | 2021-08-22 | Union | Ohio | 39159 | 6178 | 49 |
1640073 | 1640073 | 2021-08-21 | Union | Ohio | 39159 | 6170 | 49 |
1636823 | 1636823 | 2021-08-20 | Union | Ohio | 39159 | 6149 | 49 |
1633573 | 1633573 | 2021-08-19 | Union | Ohio | 39159 | 6137 | 49 |
1630326 | 1630326 | 2021-08-18 | Union | Ohio | 39159 | 6119 | 49 |
1627079 | 1627079 | 2021-08-17 | Union | Ohio | 39159 | 6105 | 49 |
1623832 | 1623832 | 2021-08-16 | Union | Ohio | 39159 | 6090 | 49 |
1620585 | 1620585 | 2021-08-15 | Union | Ohio | 39159 | 6072 | 49 |
1617337 | 1617337 | 2021-08-14 | Union | Ohio | 39159 | 6065 | 49 |
1614089 | 1614089 | 2021-08-13 | Union | Ohio | 39159 | 6059 | 49 |
1610840 | 1610840 | 2021-08-12 | Union | Ohio | 39159 | 6048 | 49 |
1607592 | 1607592 | 2021-08-11 | Union | Ohio | 39159 | 6031 | 49 |
1604343 | 1604343 | 2021-08-10 | Union | Ohio | 39159 | 6013 | 49 |
1601094 | 1601094 | 2021-08-09 | Union | Ohio | 39159 | 5998 | 49 |
1597846 | 1597846 | 2021-08-08 | Union | Ohio | 39159 | 5996 | 49 |
1594597 | 1594597 | 2021-08-07 | Union | Ohio | 39159 | 5992 | 49 |
1591348 | 1591348 | 2021-08-06 | Union | Ohio | 39159 | 5984 | 49 |
1588099 | 1588099 | 2021-08-05 | Union | Ohio | 39159 | 5973 | 49 |
1584849 | 1584849 | 2021-08-04 | Union | Ohio | 39159 | 5960 | 49 |
1581599 | 1581599 | 2021-08-03 | Union | Ohio | 39159 | 5951 | 49 |
1578350 | 1578350 | 2021-08-02 | Union | Ohio | 39159 | 5941 | 49 |
1575102 | 1575102 | 2021-08-01 | Union | Ohio | 39159 | 5934 | 49 |
1571854 | 1571854 | 2021-07-31 | Union | Ohio | 39159 | 5934 | 49 |
1568606 | 1568606 | 2021-07-30 | Union | Ohio | 39159 | 5927 | 49 |
1565358 | 1565358 | 2021-07-29 | Union | Ohio | 39159 | 5924 | 49 |
1562110 | 1562110 | 2021-07-28 | Union | Ohio | 39159 | 5916 | 49 |
1558862 | 1558862 | 2021-07-27 | Union | Ohio | 39159 | 5909 | 49 |
1555615 | 1555615 | 2021-07-26 | Union | Ohio | 39159 | 5904 | 49 |
1552368 | 1552368 | 2021-07-25 | Union | Ohio | 39159 | 5904 | 49 |
1549121 | 1549121 | 2021-07-24 | Union | Ohio | 39159 | 5903 | 49 |
1545874 | 1545874 | 2021-07-23 | Union | Ohio | 39159 | 5900 | 49 |
1542627 | 1542627 | 2021-07-22 | Union | Ohio | 39159 | 5895 | 49 |
1539379 | 1539379 | 2021-07-21 | Union | Ohio | 39159 | 5887 | 49 |
1536132 | 1536132 | 2021-07-20 | Union | Ohio | 39159 | 5886 | 49 |
1532884 | 1532884 | 2021-07-19 | Union | Ohio | 39159 | 5883 | 49 |
1529637 | 1529637 | 2021-07-18 | Union | Ohio | 39159 | 5882 | 49 |
1526390 | 1526390 | 2021-07-17 | Union | Ohio | 39159 | 5882 | 49 |
1523143 | 1523143 | 2021-07-16 | Union | Ohio | 39159 | 5880 | 49 |
1519895 | 1519895 | 2021-07-15 | Union | Ohio | 39159 | 5880 | 49 |
1516647 | 1516647 | 2021-07-14 | Union | Ohio | 39159 | 5878 | 49 |
1513400 | 1513400 | 2021-07-13 | Union | Ohio | 39159 | 5875 | 49 |
1510154 | 1510154 | 2021-07-12 | Union | Ohio | 39159 | 5870 | 49 |
1506907 | 1506907 | 2021-07-11 | Union | Ohio | 39159 | 5868 | 49 |
1503661 | 1503661 | 2021-07-10 | Union | Ohio | 39159 | 5867 | 49 |
1500415 | 1500415 | 2021-07-09 | Union | Ohio | 39159 | 5867 | 49 |
1497169 | 1497169 | 2021-07-08 | Union | Ohio | 39159 | 5866 | 49 |
1493922 | 1493922 | 2021-07-07 | Union | Ohio | 39159 | 5862 | 49 |
1490675 | 1490675 | 2021-07-06 | Union | Ohio | 39159 | 5859 | 49 |
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);