ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 39085 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1487391 | 1487391 | 2021-07-05 | Lake | Ohio | 39085 | 21259 | 390 |
1484144 | 1484144 | 2021-07-04 | Lake | Ohio | 39085 | 21252 | 390 |
1480898 | 1480898 | 2021-07-03 | Lake | Ohio | 39085 | 21252 | 390 |
1477651 | 1477651 | 2021-07-02 | Lake | Ohio | 39085 | 21248 | 390 |
1474405 | 1474405 | 2021-07-01 | Lake | Ohio | 39085 | 21246 | 390 |
1471159 | 1471159 | 2021-06-30 | Lake | Ohio | 39085 | 21240 | 390 |
1467914 | 1467914 | 2021-06-29 | Lake | Ohio | 39085 | 21240 | 390 |
1464669 | 1464669 | 2021-06-28 | Lake | Ohio | 39085 | 21238 | 390 |
1461424 | 1461424 | 2021-06-27 | Lake | Ohio | 39085 | 21237 | 390 |
1458179 | 1458179 | 2021-06-26 | Lake | Ohio | 39085 | 21232 | 390 |
1454934 | 1454934 | 2021-06-25 | Lake | Ohio | 39085 | 21227 | 390 |
1451689 | 1451689 | 2021-06-24 | Lake | Ohio | 39085 | 21223 | 389 |
1448443 | 1448443 | 2021-06-23 | Lake | Ohio | 39085 | 21219 | 389 |
1445198 | 1445198 | 2021-06-22 | Lake | Ohio | 39085 | 21216 | 389 |
1441953 | 1441953 | 2021-06-21 | Lake | Ohio | 39085 | 21213 | 388 |
1438708 | 1438708 | 2021-06-20 | Lake | Ohio | 39085 | 21211 | 388 |
1435461 | 1435461 | 2021-06-19 | Lake | Ohio | 39085 | 21207 | 388 |
1432214 | 1432214 | 2021-06-18 | Lake | Ohio | 39085 | 21187 | 388 |
1428968 | 1428968 | 2021-06-17 | Lake | Ohio | 39085 | 21166 | 387 |
1425723 | 1425723 | 2021-06-16 | Lake | Ohio | 39085 | 21147 | 387 |
1422476 | 1422476 | 2021-06-15 | Lake | Ohio | 39085 | 21145 | 387 |
1419230 | 1419230 | 2021-06-14 | Lake | Ohio | 39085 | 21139 | 385 |
1415985 | 1415985 | 2021-06-13 | Lake | Ohio | 39085 | 21135 | 385 |
1412739 | 1412739 | 2021-06-12 | Lake | Ohio | 39085 | 21133 | 385 |
1409494 | 1409494 | 2021-06-11 | Lake | Ohio | 39085 | 21126 | 385 |
1406249 | 1406249 | 2021-06-10 | Lake | Ohio | 39085 | 21121 | 384 |
1403003 | 1403003 | 2021-06-09 | Lake | Ohio | 39085 | 21118 | 384 |
1399758 | 1399758 | 2021-06-08 | Lake | Ohio | 39085 | 21113 | 384 |
1396513 | 1396513 | 2021-06-07 | Lake | Ohio | 39085 | 21105 | 384 |
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);