ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 39109 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812233 | 1812233 | 2021-10-13 | Miami | Ohio | 39109 | 15140 | 289 |
1808984 | 1808984 | 2021-10-12 | Miami | Ohio | 39109 | 15079 | 289 |
1805734 | 1805734 | 2021-10-11 | Miami | Ohio | 39109 | 15024 | 284 |
1802484 | 1802484 | 2021-10-10 | Miami | Ohio | 39109 | 14995 | 284 |
1799235 | 1799235 | 2021-10-09 | Miami | Ohio | 39109 | 14923 | 284 |
1795986 | 1795986 | 2021-10-08 | Miami | Ohio | 39109 | 14893 | 284 |
1792737 | 1792737 | 2021-10-07 | Miami | Ohio | 39109 | 14816 | 275 |
1789488 | 1789488 | 2021-10-06 | Miami | Ohio | 39109 | 14742 | 275 |
1786240 | 1786240 | 2021-10-05 | Miami | Ohio | 39109 | 14684 | 275 |
1782991 | 1782991 | 2021-10-04 | Miami | Ohio | 39109 | 14632 | 271 |
1779742 | 1779742 | 2021-10-03 | Miami | Ohio | 39109 | 14562 | 271 |
1776492 | 1776492 | 2021-10-02 | Miami | Ohio | 39109 | 14523 | 271 |
1773242 | 1773242 | 2021-10-01 | Miami | Ohio | 39109 | 14446 | 271 |
1769992 | 1769992 | 2021-09-30 | Miami | Ohio | 39109 | 14374 | 265 |
1766743 | 1766743 | 2021-09-29 | Miami | Ohio | 39109 | 14305 | 265 |
1763494 | 1763494 | 2021-09-28 | Miami | Ohio | 39109 | 14219 | 265 |
1760245 | 1760245 | 2021-09-27 | Miami | Ohio | 39109 | 14091 | 261 |
1756997 | 1756997 | 2021-09-26 | Miami | Ohio | 39109 | 14063 | 261 |
1753749 | 1753749 | 2021-09-25 | Miami | Ohio | 39109 | 14018 | 261 |
1750501 | 1750501 | 2021-09-24 | Miami | Ohio | 39109 | 13963 | 261 |
1747251 | 1747251 | 2021-09-23 | Miami | Ohio | 39109 | 13889 | 253 |
1744002 | 1744002 | 2021-09-22 | Miami | Ohio | 39109 | 13786 | 253 |
1740753 | 1740753 | 2021-09-21 | Miami | Ohio | 39109 | 13745 | 253 |
1737504 | 1737504 | 2021-09-20 | Miami | Ohio | 39109 | 13660 | 249 |
1734254 | 1734254 | 2021-09-19 | Miami | Ohio | 39109 | 13594 | 249 |
1731004 | 1731004 | 2021-09-18 | Miami | Ohio | 39109 | 13549 | 249 |
1727754 | 1727754 | 2021-09-17 | Miami | Ohio | 39109 | 13473 | 249 |
1724505 | 1724505 | 2021-09-16 | Miami | Ohio | 39109 | 13369 | 244 |
1721256 | 1721256 | 2021-09-15 | Miami | Ohio | 39109 | 13283 | 244 |
1718008 | 1718008 | 2021-09-14 | Miami | Ohio | 39109 | 13216 | 244 |
1714760 | 1714760 | 2021-09-13 | Miami | Ohio | 39109 | 13163 | 242 |
1711514 | 1711514 | 2021-09-12 | Miami | Ohio | 39109 | 13091 | 242 |
1708267 | 1708267 | 2021-09-11 | Miami | Ohio | 39109 | 13029 | 242 |
1705020 | 1705020 | 2021-09-10 | Miami | Ohio | 39109 | 12930 | 242 |
1701770 | 1701770 | 2021-09-09 | Miami | Ohio | 39109 | 12814 | 238 |
1698521 | 1698521 | 2021-09-08 | Miami | Ohio | 39109 | 12725 | 238 |
1695273 | 1695273 | 2021-09-07 | Miami | Ohio | 39109 | 12658 | 238 |
1692025 | 1692025 | 2021-09-06 | Miami | Ohio | 39109 | 12611 | 237 |
1688776 | 1688776 | 2021-09-05 | Miami | Ohio | 39109 | 12574 | 237 |
1685526 | 1685526 | 2021-09-04 | Miami | Ohio | 39109 | 12496 | 237 |
1682275 | 1682275 | 2021-09-03 | Miami | Ohio | 39109 | 12433 | 237 |
1679025 | 1679025 | 2021-09-02 | Miami | Ohio | 39109 | 12359 | 237 |
1675777 | 1675777 | 2021-09-01 | Miami | Ohio | 39109 | 12282 | 237 |
1672530 | 1672530 | 2021-08-31 | Miami | Ohio | 39109 | 12234 | 237 |
1669282 | 1669282 | 2021-08-30 | Miami | Ohio | 39109 | 12166 | 237 |
1666035 | 1666035 | 2021-08-29 | Miami | Ohio | 39109 | 12137 | 237 |
1662787 | 1662787 | 2021-08-28 | Miami | Ohio | 39109 | 12080 | 237 |
1659539 | 1659539 | 2021-08-27 | Miami | Ohio | 39109 | 12011 | 237 |
1656290 | 1656290 | 2021-08-26 | Miami | Ohio | 39109 | 11967 | 235 |
1653043 | 1653043 | 2021-08-25 | Miami | Ohio | 39109 | 11888 | 235 |
1649796 | 1649796 | 2021-08-24 | Miami | Ohio | 39109 | 11845 | 235 |
1646547 | 1646547 | 2021-08-23 | Miami | Ohio | 39109 | 11798 | 235 |
1643298 | 1643298 | 2021-08-22 | Miami | Ohio | 39109 | 11751 | 235 |
1640048 | 1640048 | 2021-08-21 | Miami | Ohio | 39109 | 11723 | 235 |
1636798 | 1636798 | 2021-08-20 | Miami | Ohio | 39109 | 11657 | 235 |
1633548 | 1633548 | 2021-08-19 | Miami | Ohio | 39109 | 11597 | 233 |
1630301 | 1630301 | 2021-08-18 | Miami | Ohio | 39109 | 11547 | 233 |
1627054 | 1627054 | 2021-08-17 | Miami | Ohio | 39109 | 11491 | 233 |
1623807 | 1623807 | 2021-08-16 | Miami | Ohio | 39109 | 11477 | 232 |
1620560 | 1620560 | 2021-08-15 | Miami | Ohio | 39109 | 11466 | 232 |
1617312 | 1617312 | 2021-08-14 | Miami | Ohio | 39109 | 11436 | 232 |
1614064 | 1614064 | 2021-08-13 | Miami | Ohio | 39109 | 11404 | 232 |
1610815 | 1610815 | 2021-08-12 | Miami | Ohio | 39109 | 11383 | 231 |
1607567 | 1607567 | 2021-08-11 | Miami | Ohio | 39109 | 11358 | 231 |
1604318 | 1604318 | 2021-08-10 | Miami | Ohio | 39109 | 11312 | 231 |
1601069 | 1601069 | 2021-08-09 | Miami | Ohio | 39109 | 11278 | 229 |
1597821 | 1597821 | 2021-08-08 | Miami | Ohio | 39109 | 11268 | 229 |
1594572 | 1594572 | 2021-08-07 | Miami | Ohio | 39109 | 11241 | 229 |
1591323 | 1591323 | 2021-08-06 | Miami | Ohio | 39109 | 11212 | 229 |
1588074 | 1588074 | 2021-08-05 | Miami | Ohio | 39109 | 11191 | 229 |
1584824 | 1584824 | 2021-08-04 | Miami | Ohio | 39109 | 11158 | 229 |
1581574 | 1581574 | 2021-08-03 | Miami | Ohio | 39109 | 11140 | 229 |
1578325 | 1578325 | 2021-08-02 | Miami | Ohio | 39109 | 11116 | 228 |
1575077 | 1575077 | 2021-08-01 | Miami | Ohio | 39109 | 11106 | 228 |
1571829 | 1571829 | 2021-07-31 | Miami | Ohio | 39109 | 11094 | 228 |
1568581 | 1568581 | 2021-07-30 | Miami | Ohio | 39109 | 11078 | 228 |
1565333 | 1565333 | 2021-07-29 | Miami | Ohio | 39109 | 11059 | 228 |
1562085 | 1562085 | 2021-07-28 | Miami | Ohio | 39109 | 11047 | 228 |
1558837 | 1558837 | 2021-07-27 | Miami | Ohio | 39109 | 11019 | 228 |
1555590 | 1555590 | 2021-07-26 | Miami | Ohio | 39109 | 10998 | 228 |
1552343 | 1552343 | 2021-07-25 | Miami | Ohio | 39109 | 10993 | 228 |
1549096 | 1549096 | 2021-07-24 | Miami | Ohio | 39109 | 10981 | 228 |
1545849 | 1545849 | 2021-07-23 | Miami | Ohio | 39109 | 10976 | 228 |
1542602 | 1542602 | 2021-07-22 | Miami | Ohio | 39109 | 10958 | 228 |
1539354 | 1539354 | 2021-07-21 | Miami | Ohio | 39109 | 10947 | 228 |
1536107 | 1536107 | 2021-07-20 | Miami | Ohio | 39109 | 10935 | 228 |
1532859 | 1532859 | 2021-07-19 | Miami | Ohio | 39109 | 10929 | 228 |
1529612 | 1529612 | 2021-07-18 | Miami | Ohio | 39109 | 10923 | 228 |
1526365 | 1526365 | 2021-07-17 | Miami | Ohio | 39109 | 10920 | 228 |
1523118 | 1523118 | 2021-07-16 | Miami | Ohio | 39109 | 10915 | 228 |
1519870 | 1519870 | 2021-07-15 | Miami | Ohio | 39109 | 10908 | 227 |
1516622 | 1516622 | 2021-07-14 | Miami | Ohio | 39109 | 10904 | 227 |
1513375 | 1513375 | 2021-07-13 | Miami | Ohio | 39109 | 10902 | 227 |
1510129 | 1510129 | 2021-07-12 | Miami | Ohio | 39109 | 10895 | 226 |
1506882 | 1506882 | 2021-07-11 | Miami | Ohio | 39109 | 10892 | 226 |
1503636 | 1503636 | 2021-07-10 | Miami | Ohio | 39109 | 10888 | 226 |
1500390 | 1500390 | 2021-07-09 | Miami | Ohio | 39109 | 10887 | 226 |
1497144 | 1497144 | 2021-07-08 | Miami | Ohio | 39109 | 10885 | 226 |
1493897 | 1493897 | 2021-07-07 | Miami | Ohio | 39109 | 10882 | 226 |
1490650 | 1490650 | 2021-07-06 | Miami | Ohio | 39109 | 10879 | 226 |
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);