ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Lawrence" and fips = 39087 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1815470 | 1815470 | 2021-10-14 | Lawrence | Ohio | 39087 | 9595 | 137 |
1812222 | 1812222 | 2021-10-13 | Lawrence | Ohio | 39087 | 9556 | 137 |
1808973 | 1808973 | 2021-10-12 | Lawrence | Ohio | 39087 | 9534 | 137 |
1805723 | 1805723 | 2021-10-11 | Lawrence | Ohio | 39087 | 9490 | 137 |
1802473 | 1802473 | 2021-10-10 | Lawrence | Ohio | 39087 | 9481 | 137 |
1799224 | 1799224 | 2021-10-09 | Lawrence | Ohio | 39087 | 9462 | 137 |
1795975 | 1795975 | 2021-10-08 | Lawrence | Ohio | 39087 | 9442 | 137 |
1792726 | 1792726 | 2021-10-07 | Lawrence | Ohio | 39087 | 9414 | 136 |
1789477 | 1789477 | 2021-10-06 | Lawrence | Ohio | 39087 | 9367 | 136 |
1786229 | 1786229 | 2021-10-05 | Lawrence | Ohio | 39087 | 9333 | 136 |
1782980 | 1782980 | 2021-10-04 | Lawrence | Ohio | 39087 | 9307 | 126 |
1779731 | 1779731 | 2021-10-03 | Lawrence | Ohio | 39087 | 9294 | 126 |
1776481 | 1776481 | 2021-10-02 | Lawrence | Ohio | 39087 | 9270 | 126 |
1773231 | 1773231 | 2021-10-01 | Lawrence | Ohio | 39087 | 9239 | 126 |
1769981 | 1769981 | 2021-09-30 | Lawrence | Ohio | 39087 | 9171 | 126 |
1766732 | 1766732 | 2021-09-29 | Lawrence | Ohio | 39087 | 9136 | 126 |
1763483 | 1763483 | 2021-09-28 | Lawrence | Ohio | 39087 | 9079 | 126 |
1760234 | 1760234 | 2021-09-27 | Lawrence | Ohio | 39087 | 9005 | 125 |
1756986 | 1756986 | 2021-09-26 | Lawrence | Ohio | 39087 | 8967 | 125 |
1753738 | 1753738 | 2021-09-25 | Lawrence | Ohio | 39087 | 8934 | 125 |
1750490 | 1750490 | 2021-09-24 | Lawrence | Ohio | 39087 | 8886 | 125 |
1747240 | 1747240 | 2021-09-23 | Lawrence | Ohio | 39087 | 8809 | 125 |
1743991 | 1743991 | 2021-09-22 | Lawrence | Ohio | 39087 | 8755 | 125 |
1740742 | 1740742 | 2021-09-21 | Lawrence | Ohio | 39087 | 8682 | 125 |
1737493 | 1737493 | 2021-09-20 | Lawrence | Ohio | 39087 | 8583 | 116 |
1734243 | 1734243 | 2021-09-19 | Lawrence | Ohio | 39087 | 8549 | 116 |
1730993 | 1730993 | 2021-09-18 | Lawrence | Ohio | 39087 | 8516 | 116 |
1727743 | 1727743 | 2021-09-17 | Lawrence | Ohio | 39087 | 8441 | 116 |
1724494 | 1724494 | 2021-09-16 | Lawrence | Ohio | 39087 | 8335 | 116 |
1721245 | 1721245 | 2021-09-15 | Lawrence | Ohio | 39087 | 8225 | 116 |
1717997 | 1717997 | 2021-09-14 | Lawrence | Ohio | 39087 | 8111 | 116 |
1714749 | 1714749 | 2021-09-13 | Lawrence | Ohio | 39087 | 7992 | 116 |
1711503 | 1711503 | 2021-09-12 | Lawrence | Ohio | 39087 | 7920 | 116 |
1708256 | 1708256 | 2021-09-11 | Lawrence | Ohio | 39087 | 7868 | 116 |
1705009 | 1705009 | 2021-09-10 | Lawrence | Ohio | 39087 | 7776 | 116 |
1701759 | 1701759 | 2021-09-09 | Lawrence | Ohio | 39087 | 7648 | 111 |
1698510 | 1698510 | 2021-09-08 | Lawrence | Ohio | 39087 | 7593 | 111 |
1695262 | 1695262 | 2021-09-07 | Lawrence | Ohio | 39087 | 7505 | 111 |
1692014 | 1692014 | 2021-09-06 | Lawrence | Ohio | 39087 | 7449 | 111 |
1688765 | 1688765 | 2021-09-05 | Lawrence | Ohio | 39087 | 7394 | 111 |
1685515 | 1685515 | 2021-09-04 | Lawrence | Ohio | 39087 | 7322 | 111 |
1682264 | 1682264 | 2021-09-03 | Lawrence | Ohio | 39087 | 7246 | 111 |
1679014 | 1679014 | 2021-09-02 | Lawrence | Ohio | 39087 | 7177 | 111 |
1675766 | 1675766 | 2021-09-01 | Lawrence | Ohio | 39087 | 7095 | 111 |
1672519 | 1672519 | 2021-08-31 | Lawrence | Ohio | 39087 | 7012 | 111 |
1669271 | 1669271 | 2021-08-30 | Lawrence | Ohio | 39087 | 6897 | 111 |
1666024 | 1666024 | 2021-08-29 | Lawrence | Ohio | 39087 | 6857 | 111 |
1662776 | 1662776 | 2021-08-28 | Lawrence | Ohio | 39087 | 6840 | 111 |
1659528 | 1659528 | 2021-08-27 | Lawrence | Ohio | 39087 | 6783 | 111 |
1656279 | 1656279 | 2021-08-26 | Lawrence | Ohio | 39087 | 6722 | 111 |
1653032 | 1653032 | 2021-08-25 | Lawrence | Ohio | 39087 | 6654 | 111 |
1649785 | 1649785 | 2021-08-24 | Lawrence | Ohio | 39087 | 6579 | 111 |
1646536 | 1646536 | 2021-08-23 | Lawrence | Ohio | 39087 | 6545 | 108 |
1643287 | 1643287 | 2021-08-22 | Lawrence | Ohio | 39087 | 6526 | 108 |
1640037 | 1640037 | 2021-08-21 | Lawrence | Ohio | 39087 | 6521 | 108 |
1636787 | 1636787 | 2021-08-20 | Lawrence | Ohio | 39087 | 6489 | 108 |
1633537 | 1633537 | 2021-08-19 | Lawrence | Ohio | 39087 | 6427 | 107 |
1630290 | 1630290 | 2021-08-18 | Lawrence | Ohio | 39087 | 6386 | 107 |
1627043 | 1627043 | 2021-08-17 | Lawrence | Ohio | 39087 | 6343 | 107 |
1623796 | 1623796 | 2021-08-16 | Lawrence | Ohio | 39087 | 6293 | 107 |
1620549 | 1620549 | 2021-08-15 | Lawrence | Ohio | 39087 | 6281 | 107 |
1617301 | 1617301 | 2021-08-14 | Lawrence | Ohio | 39087 | 6278 | 107 |
1614053 | 1614053 | 2021-08-13 | Lawrence | Ohio | 39087 | 6245 | 107 |
1610804 | 1610804 | 2021-08-12 | Lawrence | Ohio | 39087 | 6216 | 107 |
1607556 | 1607556 | 2021-08-11 | Lawrence | Ohio | 39087 | 6196 | 107 |
1604307 | 1604307 | 2021-08-10 | Lawrence | Ohio | 39087 | 6167 | 107 |
1601058 | 1601058 | 2021-08-09 | Lawrence | Ohio | 39087 | 6142 | 106 |
1597810 | 1597810 | 2021-08-08 | Lawrence | Ohio | 39087 | 6132 | 106 |
1594561 | 1594561 | 2021-08-07 | Lawrence | Ohio | 39087 | 6128 | 106 |
1591312 | 1591312 | 2021-08-06 | Lawrence | Ohio | 39087 | 6105 | 106 |
1588063 | 1588063 | 2021-08-05 | Lawrence | Ohio | 39087 | 6084 | 106 |
1584813 | 1584813 | 2021-08-04 | Lawrence | Ohio | 39087 | 6062 | 106 |
1581563 | 1581563 | 2021-08-03 | Lawrence | Ohio | 39087 | 6033 | 106 |
1578314 | 1578314 | 2021-08-02 | Lawrence | Ohio | 39087 | 6009 | 104 |
1575066 | 1575066 | 2021-08-01 | Lawrence | Ohio | 39087 | 5999 | 104 |
1571818 | 1571818 | 2021-07-31 | Lawrence | Ohio | 39087 | 5991 | 104 |
1568570 | 1568570 | 2021-07-30 | Lawrence | Ohio | 39087 | 5988 | 104 |
1565322 | 1565322 | 2021-07-29 | Lawrence | Ohio | 39087 | 5975 | 104 |
1562074 | 1562074 | 2021-07-28 | Lawrence | Ohio | 39087 | 5964 | 104 |
1558826 | 1558826 | 2021-07-27 | Lawrence | Ohio | 39087 | 5947 | 104 |
1555579 | 1555579 | 2021-07-26 | Lawrence | Ohio | 39087 | 5917 | 104 |
1552332 | 1552332 | 2021-07-25 | Lawrence | Ohio | 39087 | 5912 | 104 |
1549085 | 1549085 | 2021-07-24 | Lawrence | Ohio | 39087 | 5911 | 104 |
1545838 | 1545838 | 2021-07-23 | Lawrence | Ohio | 39087 | 5905 | 104 |
1542591 | 1542591 | 2021-07-22 | Lawrence | Ohio | 39087 | 5894 | 104 |
1539343 | 1539343 | 2021-07-21 | Lawrence | Ohio | 39087 | 5883 | 104 |
1536096 | 1536096 | 2021-07-20 | Lawrence | Ohio | 39087 | 5871 | 104 |
1532848 | 1532848 | 2021-07-19 | Lawrence | Ohio | 39087 | 5855 | 104 |
1529601 | 1529601 | 2021-07-18 | Lawrence | Ohio | 39087 | 5849 | 104 |
1526354 | 1526354 | 2021-07-17 | Lawrence | Ohio | 39087 | 5848 | 104 |
1523107 | 1523107 | 2021-07-16 | Lawrence | Ohio | 39087 | 5844 | 104 |
1519859 | 1519859 | 2021-07-15 | Lawrence | Ohio | 39087 | 5835 | 104 |
1516611 | 1516611 | 2021-07-14 | Lawrence | Ohio | 39087 | 5824 | 104 |
1513364 | 1513364 | 2021-07-13 | Lawrence | Ohio | 39087 | 5819 | 104 |
1510118 | 1510118 | 2021-07-12 | Lawrence | Ohio | 39087 | 5814 | 103 |
1506871 | 1506871 | 2021-07-11 | Lawrence | Ohio | 39087 | 5804 | 103 |
1503625 | 1503625 | 2021-07-10 | Lawrence | Ohio | 39087 | 5801 | 103 |
1500379 | 1500379 | 2021-07-09 | Lawrence | Ohio | 39087 | 5785 | 103 |
1497133 | 1497133 | 2021-07-08 | Lawrence | Ohio | 39087 | 5776 | 103 |
1493886 | 1493886 | 2021-07-07 | Lawrence | Ohio | 39087 | 5768 | 103 |
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);