ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Lake" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1948701 | 1948701 | 2021-11-24 | Lake | Ohio | 39085 | 30757 | 486 |
1945450 | 1945450 | 2021-11-23 | Lake | Ohio | 39085 | 30540 | 486 |
1942199 | 1942199 | 2021-11-22 | Lake | Ohio | 39085 | 30372 | 482 |
1938949 | 1938949 | 2021-11-21 | Lake | Ohio | 39085 | 30262 | 482 |
1935699 | 1935699 | 2021-11-20 | Lake | Ohio | 39085 | 30110 | 482 |
1932449 | 1932449 | 2021-11-19 | Lake | Ohio | 39085 | 29898 | 482 |
1929198 | 1929198 | 2021-11-18 | Lake | Ohio | 39085 | 29689 | 474 |
1925948 | 1925948 | 2021-11-17 | Lake | Ohio | 39085 | 29510 | 474 |
1922698 | 1922698 | 2021-11-16 | Lake | Ohio | 39085 | 29326 | 474 |
1919449 | 1919449 | 2021-11-15 | Lake | Ohio | 39085 | 29190 | 470 |
1916199 | 1916199 | 2021-11-14 | Lake | Ohio | 39085 | 29089 | 470 |
1912949 | 1912949 | 2021-11-13 | Lake | Ohio | 39085 | 28985 | 470 |
1909699 | 1909699 | 2021-11-12 | Lake | Ohio | 39085 | 28857 | 470 |
1906450 | 1906450 | 2021-11-11 | Lake | Ohio | 39085 | 28713 | 468 |
1903201 | 1903201 | 2021-11-10 | Lake | Ohio | 39085 | 28590 | 468 |
1899951 | 1899951 | 2021-11-09 | Lake | Ohio | 39085 | 28468 | 468 |
1896701 | 1896701 | 2021-11-08 | Lake | Ohio | 39085 | 28348 | 461 |
1893451 | 1893451 | 2021-11-07 | Lake | Ohio | 39085 | 28289 | 461 |
1890201 | 1890201 | 2021-11-06 | Lake | Ohio | 39085 | 28155 | 461 |
1886951 | 1886951 | 2021-11-05 | Lake | Ohio | 39085 | 28087 | 461 |
1883701 | 1883701 | 2021-11-04 | Lake | Ohio | 39085 | 27992 | 457 |
1880452 | 1880452 | 2021-11-03 | Lake | Ohio | 39085 | 27896 | 457 |
1877203 | 1877203 | 2021-11-02 | Lake | Ohio | 39085 | 27791 | 457 |
1873954 | 1873954 | 2021-11-01 | Lake | Ohio | 39085 | 27710 | 454 |
1870705 | 1870705 | 2021-10-31 | Lake | Ohio | 39085 | 27647 | 454 |
1867456 | 1867456 | 2021-10-30 | Lake | Ohio | 39085 | 27588 | 454 |
1864207 | 1864207 | 2021-10-29 | Lake | Ohio | 39085 | 27501 | 454 |
1860958 | 1860958 | 2021-10-28 | Lake | Ohio | 39085 | 27420 | 451 |
1857709 | 1857709 | 2021-10-27 | Lake | Ohio | 39085 | 27328 | 451 |
1854460 | 1854460 | 2021-10-26 | Lake | Ohio | 39085 | 27256 | 451 |
1851211 | 1851211 | 2021-10-25 | Lake | Ohio | 39085 | 27179 | 448 |
1847961 | 1847961 | 2021-10-24 | Lake | Ohio | 39085 | 27122 | 448 |
1844711 | 1844711 | 2021-10-23 | Lake | Ohio | 39085 | 27063 | 448 |
1841461 | 1841461 | 2021-10-22 | Lake | Ohio | 39085 | 26979 | 448 |
1838212 | 1838212 | 2021-10-21 | Lake | Ohio | 39085 | 26907 | 443 |
1834963 | 1834963 | 2021-10-20 | Lake | Ohio | 39085 | 26812 | 443 |
1831714 | 1831714 | 2021-10-19 | Lake | Ohio | 39085 | 26743 | 443 |
1828465 | 1828465 | 2021-10-18 | Lake | Ohio | 39085 | 26669 | 434 |
1825216 | 1825216 | 2021-10-17 | Lake | Ohio | 39085 | 26609 | 434 |
1821967 | 1821967 | 2021-10-16 | Lake | Ohio | 39085 | 26543 | 434 |
1818718 | 1818718 | 2021-10-15 | Lake | Ohio | 39085 | 26457 | 434 |
1815469 | 1815469 | 2021-10-14 | Lake | Ohio | 39085 | 26352 | 432 |
1812221 | 1812221 | 2021-10-13 | Lake | Ohio | 39085 | 26274 | 432 |
1808972 | 1808972 | 2021-10-12 | Lake | Ohio | 39085 | 26163 | 432 |
1805722 | 1805722 | 2021-10-11 | Lake | Ohio | 39085 | 26093 | 432 |
1802472 | 1802472 | 2021-10-10 | Lake | Ohio | 39085 | 26029 | 432 |
1799223 | 1799223 | 2021-10-09 | Lake | Ohio | 39085 | 25941 | 432 |
1795974 | 1795974 | 2021-10-08 | Lake | Ohio | 39085 | 25876 | 432 |
1792725 | 1792725 | 2021-10-07 | Lake | Ohio | 39085 | 25776 | 428 |
1789476 | 1789476 | 2021-10-06 | Lake | Ohio | 39085 | 25664 | 428 |
1786228 | 1786228 | 2021-10-05 | Lake | Ohio | 39085 | 25543 | 428 |
1782979 | 1782979 | 2021-10-04 | Lake | Ohio | 39085 | 25468 | 424 |
1779730 | 1779730 | 2021-10-03 | Lake | Ohio | 39085 | 25393 | 424 |
1776480 | 1776480 | 2021-10-02 | Lake | Ohio | 39085 | 25340 | 424 |
1773230 | 1773230 | 2021-10-01 | Lake | Ohio | 39085 | 25252 | 424 |
1769980 | 1769980 | 2021-09-30 | Lake | Ohio | 39085 | 25158 | 422 |
1766731 | 1766731 | 2021-09-29 | Lake | Ohio | 39085 | 25083 | 422 |
1763482 | 1763482 | 2021-09-28 | Lake | Ohio | 39085 | 25000 | 422 |
1760233 | 1760233 | 2021-09-27 | Lake | Ohio | 39085 | 24920 | 422 |
1756985 | 1756985 | 2021-09-26 | Lake | Ohio | 39085 | 24873 | 422 |
1753737 | 1753737 | 2021-09-25 | Lake | Ohio | 39085 | 24809 | 422 |
1750489 | 1750489 | 2021-09-24 | Lake | Ohio | 39085 | 24746 | 422 |
1747239 | 1747239 | 2021-09-23 | Lake | Ohio | 39085 | 24662 | 417 |
1743990 | 1743990 | 2021-09-22 | Lake | Ohio | 39085 | 24585 | 417 |
1740741 | 1740741 | 2021-09-21 | Lake | Ohio | 39085 | 24513 | 417 |
1737492 | 1737492 | 2021-09-20 | Lake | Ohio | 39085 | 24432 | 416 |
1734242 | 1734242 | 2021-09-19 | Lake | Ohio | 39085 | 24390 | 416 |
1730992 | 1730992 | 2021-09-18 | Lake | Ohio | 39085 | 24339 | 416 |
1727742 | 1727742 | 2021-09-17 | Lake | Ohio | 39085 | 24249 | 416 |
1724493 | 1724493 | 2021-09-16 | Lake | Ohio | 39085 | 24170 | 411 |
1721244 | 1721244 | 2021-09-15 | Lake | Ohio | 39085 | 24088 | 411 |
1717996 | 1717996 | 2021-09-14 | Lake | Ohio | 39085 | 23984 | 411 |
1714748 | 1714748 | 2021-09-13 | Lake | Ohio | 39085 | 23884 | 408 |
1711502 | 1711502 | 2021-09-12 | Lake | Ohio | 39085 | 23824 | 408 |
1708255 | 1708255 | 2021-09-11 | Lake | Ohio | 39085 | 23767 | 408 |
1705008 | 1705008 | 2021-09-10 | Lake | Ohio | 39085 | 23664 | 408 |
1701758 | 1701758 | 2021-09-09 | Lake | Ohio | 39085 | 23568 | 405 |
1698509 | 1698509 | 2021-09-08 | Lake | Ohio | 39085 | 23495 | 405 |
1695261 | 1695261 | 2021-09-07 | Lake | Ohio | 39085 | 23411 | 405 |
1692013 | 1692013 | 2021-09-06 | Lake | Ohio | 39085 | 23337 | 405 |
1688764 | 1688764 | 2021-09-05 | Lake | Ohio | 39085 | 23302 | 405 |
1685514 | 1685514 | 2021-09-04 | Lake | Ohio | 39085 | 23244 | 405 |
1682263 | 1682263 | 2021-09-03 | Lake | Ohio | 39085 | 23176 | 405 |
1679013 | 1679013 | 2021-09-02 | Lake | Ohio | 39085 | 23105 | 404 |
1675765 | 1675765 | 2021-09-01 | Lake | Ohio | 39085 | 23026 | 404 |
1672518 | 1672518 | 2021-08-31 | Lake | Ohio | 39085 | 22943 | 404 |
1669270 | 1669270 | 2021-08-30 | Lake | Ohio | 39085 | 22882 | 404 |
1666023 | 1666023 | 2021-08-29 | Lake | Ohio | 39085 | 22841 | 404 |
1662775 | 1662775 | 2021-08-28 | Lake | Ohio | 39085 | 22792 | 404 |
1659527 | 1659527 | 2021-08-27 | Lake | Ohio | 39085 | 22714 | 404 |
1656278 | 1656278 | 2021-08-26 | Lake | Ohio | 39085 | 22636 | 401 |
1653031 | 1653031 | 2021-08-25 | Lake | Ohio | 39085 | 22534 | 401 |
1649784 | 1649784 | 2021-08-24 | Lake | Ohio | 39085 | 22459 | 401 |
1646535 | 1646535 | 2021-08-23 | Lake | Ohio | 39085 | 22398 | 401 |
1643286 | 1643286 | 2021-08-22 | Lake | Ohio | 39085 | 22358 | 401 |
1640036 | 1640036 | 2021-08-21 | Lake | Ohio | 39085 | 22325 | 401 |
1636786 | 1636786 | 2021-08-20 | Lake | Ohio | 39085 | 22260 | 401 |
1633536 | 1633536 | 2021-08-19 | Lake | Ohio | 39085 | 22205 | 399 |
1630289 | 1630289 | 2021-08-18 | Lake | Ohio | 39085 | 22166 | 399 |
1627042 | 1627042 | 2021-08-17 | Lake | Ohio | 39085 | 22122 | 399 |
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);