ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Jefferson" and fips = 39081 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1831712 | 1831712 | 2021-10-19 | Jefferson | Ohio | 39081 | 8492 | 197 |
1828463 | 1828463 | 2021-10-18 | Jefferson | Ohio | 39081 | 8481 | 191 |
1825214 | 1825214 | 2021-10-17 | Jefferson | Ohio | 39081 | 8468 | 191 |
1821965 | 1821965 | 2021-10-16 | Jefferson | Ohio | 39081 | 8455 | 191 |
1818716 | 1818716 | 2021-10-15 | Jefferson | Ohio | 39081 | 8439 | 191 |
1815467 | 1815467 | 2021-10-14 | Jefferson | Ohio | 39081 | 8415 | 191 |
1812219 | 1812219 | 2021-10-13 | Jefferson | Ohio | 39081 | 8353 | 191 |
1808970 | 1808970 | 2021-10-12 | Jefferson | Ohio | 39081 | 8324 | 191 |
1805720 | 1805720 | 2021-10-11 | Jefferson | Ohio | 39081 | 8289 | 190 |
1802470 | 1802470 | 2021-10-10 | Jefferson | Ohio | 39081 | 8265 | 190 |
1799221 | 1799221 | 2021-10-09 | Jefferson | Ohio | 39081 | 8247 | 190 |
1795972 | 1795972 | 2021-10-08 | Jefferson | Ohio | 39081 | 8208 | 190 |
1792723 | 1792723 | 2021-10-07 | Jefferson | Ohio | 39081 | 8179 | 185 |
1789474 | 1789474 | 2021-10-06 | Jefferson | Ohio | 39081 | 8116 | 185 |
1786226 | 1786226 | 2021-10-05 | Jefferson | Ohio | 39081 | 8080 | 185 |
1782977 | 1782977 | 2021-10-04 | Jefferson | Ohio | 39081 | 8037 | 180 |
1779728 | 1779728 | 2021-10-03 | Jefferson | Ohio | 39081 | 8019 | 180 |
1776478 | 1776478 | 2021-10-02 | Jefferson | Ohio | 39081 | 8007 | 180 |
1773228 | 1773228 | 2021-10-01 | Jefferson | Ohio | 39081 | 7943 | 180 |
1769978 | 1769978 | 2021-09-30 | Jefferson | Ohio | 39081 | 7899 | 176 |
1766729 | 1766729 | 2021-09-29 | Jefferson | Ohio | 39081 | 7853 | 176 |
1763480 | 1763480 | 2021-09-28 | Jefferson | Ohio | 39081 | 7804 | 176 |
1760231 | 1760231 | 2021-09-27 | Jefferson | Ohio | 39081 | 7785 | 175 |
1756983 | 1756983 | 2021-09-26 | Jefferson | Ohio | 39081 | 7736 | 175 |
1753735 | 1753735 | 2021-09-25 | Jefferson | Ohio | 39081 | 7691 | 175 |
1750487 | 1750487 | 2021-09-24 | Jefferson | Ohio | 39081 | 7635 | 175 |
1747237 | 1747237 | 2021-09-23 | Jefferson | Ohio | 39081 | 7589 | 172 |
1743988 | 1743988 | 2021-09-22 | Jefferson | Ohio | 39081 | 7527 | 172 |
1740739 | 1740739 | 2021-09-21 | Jefferson | Ohio | 39081 | 7465 | 172 |
1737490 | 1737490 | 2021-09-20 | Jefferson | Ohio | 39081 | 7397 | 168 |
1734240 | 1734240 | 2021-09-19 | Jefferson | Ohio | 39081 | 7357 | 168 |
1730990 | 1730990 | 2021-09-18 | Jefferson | Ohio | 39081 | 7324 | 168 |
1727740 | 1727740 | 2021-09-17 | Jefferson | Ohio | 39081 | 7263 | 168 |
1724491 | 1724491 | 2021-09-16 | Jefferson | Ohio | 39081 | 7167 | 168 |
1721242 | 1721242 | 2021-09-15 | Jefferson | Ohio | 39081 | 7093 | 168 |
1717994 | 1717994 | 2021-09-14 | Jefferson | Ohio | 39081 | 7003 | 168 |
1714746 | 1714746 | 2021-09-13 | Jefferson | Ohio | 39081 | 6949 | 168 |
1711500 | 1711500 | 2021-09-12 | Jefferson | Ohio | 39081 | 6900 | 168 |
1708253 | 1708253 | 2021-09-11 | Jefferson | Ohio | 39081 | 6851 | 168 |
1705006 | 1705006 | 2021-09-10 | Jefferson | Ohio | 39081 | 6792 | 168 |
1701756 | 1701756 | 2021-09-09 | Jefferson | Ohio | 39081 | 6729 | 166 |
1698507 | 1698507 | 2021-09-08 | Jefferson | Ohio | 39081 | 6681 | 166 |
1695259 | 1695259 | 2021-09-07 | Jefferson | Ohio | 39081 | 6625 | 166 |
1692011 | 1692011 | 2021-09-06 | Jefferson | Ohio | 39081 | 6584 | 166 |
1688762 | 1688762 | 2021-09-05 | Jefferson | Ohio | 39081 | 6556 | 166 |
1685512 | 1685512 | 2021-09-04 | Jefferson | Ohio | 39081 | 6511 | 166 |
1682261 | 1682261 | 2021-09-03 | Jefferson | Ohio | 39081 | 6465 | 166 |
1679011 | 1679011 | 2021-09-02 | Jefferson | Ohio | 39081 | 6424 | 166 |
1675763 | 1675763 | 2021-09-01 | Jefferson | Ohio | 39081 | 6349 | 166 |
1672516 | 1672516 | 2021-08-31 | Jefferson | Ohio | 39081 | 6299 | 166 |
1669268 | 1669268 | 2021-08-30 | Jefferson | Ohio | 39081 | 6262 | 164 |
1666021 | 1666021 | 2021-08-29 | Jefferson | Ohio | 39081 | 6244 | 164 |
1662773 | 1662773 | 2021-08-28 | Jefferson | Ohio | 39081 | 6214 | 164 |
1659525 | 1659525 | 2021-08-27 | Jefferson | Ohio | 39081 | 6169 | 164 |
1656276 | 1656276 | 2021-08-26 | Jefferson | Ohio | 39081 | 6144 | 163 |
1653029 | 1653029 | 2021-08-25 | Jefferson | Ohio | 39081 | 6116 | 163 |
1649782 | 1649782 | 2021-08-24 | Jefferson | Ohio | 39081 | 6101 | 163 |
1646533 | 1646533 | 2021-08-23 | Jefferson | Ohio | 39081 | 6078 | 163 |
1643284 | 1643284 | 2021-08-22 | Jefferson | Ohio | 39081 | 6065 | 163 |
1640034 | 1640034 | 2021-08-21 | Jefferson | Ohio | 39081 | 6042 | 163 |
1636784 | 1636784 | 2021-08-20 | Jefferson | Ohio | 39081 | 6015 | 163 |
1633534 | 1633534 | 2021-08-19 | Jefferson | Ohio | 39081 | 5990 | 163 |
1630287 | 1630287 | 2021-08-18 | Jefferson | Ohio | 39081 | 5971 | 163 |
1627040 | 1627040 | 2021-08-17 | Jefferson | Ohio | 39081 | 5956 | 163 |
1623793 | 1623793 | 2021-08-16 | Jefferson | Ohio | 39081 | 5929 | 162 |
1620546 | 1620546 | 2021-08-15 | Jefferson | Ohio | 39081 | 5922 | 162 |
1617298 | 1617298 | 2021-08-14 | Jefferson | Ohio | 39081 | 5911 | 162 |
1614050 | 1614050 | 2021-08-13 | Jefferson | Ohio | 39081 | 5897 | 162 |
1610801 | 1610801 | 2021-08-12 | Jefferson | Ohio | 39081 | 5889 | 162 |
1607553 | 1607553 | 2021-08-11 | Jefferson | Ohio | 39081 | 5878 | 162 |
1604304 | 1604304 | 2021-08-10 | Jefferson | Ohio | 39081 | 5859 | 162 |
1601055 | 1601055 | 2021-08-09 | Jefferson | Ohio | 39081 | 5831 | 162 |
1597807 | 1597807 | 2021-08-08 | Jefferson | Ohio | 39081 | 5830 | 162 |
1594558 | 1594558 | 2021-08-07 | Jefferson | Ohio | 39081 | 5825 | 162 |
1591309 | 1591309 | 2021-08-06 | Jefferson | Ohio | 39081 | 5818 | 162 |
1588060 | 1588060 | 2021-08-05 | Jefferson | Ohio | 39081 | 5808 | 162 |
1584810 | 1584810 | 2021-08-04 | Jefferson | Ohio | 39081 | 5797 | 162 |
1581560 | 1581560 | 2021-08-03 | Jefferson | Ohio | 39081 | 5787 | 162 |
1578311 | 1578311 | 2021-08-02 | Jefferson | Ohio | 39081 | 5780 | 162 |
1575063 | 1575063 | 2021-08-01 | Jefferson | Ohio | 39081 | 5772 | 162 |
1571815 | 1571815 | 2021-07-31 | Jefferson | Ohio | 39081 | 5769 | 162 |
1568567 | 1568567 | 2021-07-30 | Jefferson | Ohio | 39081 | 5747 | 162 |
1565319 | 1565319 | 2021-07-29 | Jefferson | Ohio | 39081 | 5733 | 162 |
1562071 | 1562071 | 2021-07-28 | Jefferson | Ohio | 39081 | 5729 | 162 |
1558823 | 1558823 | 2021-07-27 | Jefferson | Ohio | 39081 | 5725 | 162 |
1555576 | 1555576 | 2021-07-26 | Jefferson | Ohio | 39081 | 5723 | 162 |
1552329 | 1552329 | 2021-07-25 | Jefferson | Ohio | 39081 | 5722 | 162 |
1549082 | 1549082 | 2021-07-24 | Jefferson | Ohio | 39081 | 5720 | 162 |
1545835 | 1545835 | 2021-07-23 | Jefferson | Ohio | 39081 | 5718 | 162 |
1542588 | 1542588 | 2021-07-22 | Jefferson | Ohio | 39081 | 5716 | 162 |
1539340 | 1539340 | 2021-07-21 | Jefferson | Ohio | 39081 | 5715 | 162 |
1536093 | 1536093 | 2021-07-20 | Jefferson | Ohio | 39081 | 5714 | 162 |
1532845 | 1532845 | 2021-07-19 | Jefferson | Ohio | 39081 | 5714 | 162 |
1529598 | 1529598 | 2021-07-18 | Jefferson | Ohio | 39081 | 5713 | 162 |
1526351 | 1526351 | 2021-07-17 | Jefferson | Ohio | 39081 | 5712 | 162 |
1523104 | 1523104 | 2021-07-16 | Jefferson | Ohio | 39081 | 5708 | 162 |
1519856 | 1519856 | 2021-07-15 | Jefferson | Ohio | 39081 | 5708 | 162 |
1516608 | 1516608 | 2021-07-14 | Jefferson | Ohio | 39081 | 5706 | 162 |
1513361 | 1513361 | 2021-07-13 | Jefferson | Ohio | 39081 | 5702 | 162 |
1510115 | 1510115 | 2021-07-12 | Jefferson | Ohio | 39081 | 5697 | 160 |
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);