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 |
---|---|---|---|---|---|---|---|
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 |
1623795 | 1623795 | 2021-08-16 | Lake | Ohio | 39085 | 22072 | 399 |
1620548 | 1620548 | 2021-08-15 | Lake | Ohio | 39085 | 22052 | 399 |
1617300 | 1617300 | 2021-08-14 | Lake | Ohio | 39085 | 22023 | 399 |
1614052 | 1614052 | 2021-08-13 | Lake | Ohio | 39085 | 21988 | 399 |
1610803 | 1610803 | 2021-08-12 | Lake | Ohio | 39085 | 21942 | 398 |
1607555 | 1607555 | 2021-08-11 | Lake | Ohio | 39085 | 21885 | 398 |
1604306 | 1604306 | 2021-08-10 | Lake | Ohio | 39085 | 21814 | 398 |
1601057 | 1601057 | 2021-08-09 | Lake | Ohio | 39085 | 21780 | 397 |
1597809 | 1597809 | 2021-08-08 | Lake | Ohio | 39085 | 21758 | 397 |
1594560 | 1594560 | 2021-08-07 | Lake | Ohio | 39085 | 21741 | 397 |
1591311 | 1591311 | 2021-08-06 | Lake | Ohio | 39085 | 21696 | 397 |
1588062 | 1588062 | 2021-08-05 | Lake | Ohio | 39085 | 21666 | 397 |
1584812 | 1584812 | 2021-08-04 | Lake | Ohio | 39085 | 21629 | 397 |
1581562 | 1581562 | 2021-08-03 | Lake | Ohio | 39085 | 21602 | 397 |
1578313 | 1578313 | 2021-08-02 | Lake | Ohio | 39085 | 21561 | 396 |
1575065 | 1575065 | 2021-08-01 | Lake | Ohio | 39085 | 21548 | 396 |
1571817 | 1571817 | 2021-07-31 | Lake | Ohio | 39085 | 21538 | 396 |
1568569 | 1568569 | 2021-07-30 | Lake | Ohio | 39085 | 21524 | 396 |
1565321 | 1565321 | 2021-07-29 | Lake | Ohio | 39085 | 21509 | 396 |
1562073 | 1562073 | 2021-07-28 | Lake | Ohio | 39085 | 21482 | 396 |
1558825 | 1558825 | 2021-07-27 | Lake | Ohio | 39085 | 21472 | 396 |
1555578 | 1555578 | 2021-07-26 | Lake | Ohio | 39085 | 21457 | 396 |
1552331 | 1552331 | 2021-07-25 | Lake | Ohio | 39085 | 21448 | 396 |
1549084 | 1549084 | 2021-07-24 | Lake | Ohio | 39085 | 21442 | 396 |
1545837 | 1545837 | 2021-07-23 | Lake | Ohio | 39085 | 21429 | 396 |
1542590 | 1542590 | 2021-07-22 | Lake | Ohio | 39085 | 21419 | 395 |
1539342 | 1539342 | 2021-07-21 | Lake | Ohio | 39085 | 21403 | 395 |
1536095 | 1536095 | 2021-07-20 | Lake | Ohio | 39085 | 21383 | 395 |
1532847 | 1532847 | 2021-07-19 | Lake | Ohio | 39085 | 21365 | 394 |
1529600 | 1529600 | 2021-07-18 | Lake | Ohio | 39085 | 21361 | 394 |
1526353 | 1526353 | 2021-07-17 | Lake | Ohio | 39085 | 21359 | 394 |
1523106 | 1523106 | 2021-07-16 | Lake | Ohio | 39085 | 21351 | 394 |
1519858 | 1519858 | 2021-07-15 | Lake | Ohio | 39085 | 21340 | 391 |
1516610 | 1516610 | 2021-07-14 | Lake | Ohio | 39085 | 21330 | 391 |
1513363 | 1513363 | 2021-07-13 | Lake | Ohio | 39085 | 21323 | 391 |
1510117 | 1510117 | 2021-07-12 | Lake | Ohio | 39085 | 21314 | 391 |
1506870 | 1506870 | 2021-07-11 | Lake | Ohio | 39085 | 21300 | 391 |
1503624 | 1503624 | 2021-07-10 | Lake | Ohio | 39085 | 21292 | 391 |
1500378 | 1500378 | 2021-07-09 | Lake | Ohio | 39085 | 21286 | 391 |
1497132 | 1497132 | 2021-07-08 | Lake | Ohio | 39085 | 21277 | 391 |
1493885 | 1493885 | 2021-07-07 | Lake | Ohio | 39085 | 21267 | 391 |
1490638 | 1490638 | 2021-07-06 | Lake | Ohio | 39085 | 21262 | 390 |
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);