ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Trumbull" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812256 | 1812256 | 2021-10-13 | Trumbull | Ohio | 39155 | 22161 | 541 |
1809007 | 1809007 | 2021-10-12 | Trumbull | Ohio | 39155 | 22040 | 541 |
1805757 | 1805757 | 2021-10-11 | Trumbull | Ohio | 39155 | 21993 | 539 |
1802507 | 1802507 | 2021-10-10 | Trumbull | Ohio | 39155 | 21927 | 539 |
1799258 | 1799258 | 2021-10-09 | Trumbull | Ohio | 39155 | 21831 | 539 |
1796009 | 1796009 | 2021-10-08 | Trumbull | Ohio | 39155 | 21798 | 539 |
1792760 | 1792760 | 2021-10-07 | Trumbull | Ohio | 39155 | 21631 | 534 |
1789511 | 1789511 | 2021-10-06 | Trumbull | Ohio | 39155 | 21455 | 534 |
1786263 | 1786263 | 2021-10-05 | Trumbull | Ohio | 39155 | 21310 | 534 |
1783014 | 1783014 | 2021-10-04 | Trumbull | Ohio | 39155 | 21238 | 528 |
1779765 | 1779765 | 2021-10-03 | Trumbull | Ohio | 39155 | 21148 | 528 |
1776515 | 1776515 | 2021-10-02 | Trumbull | Ohio | 39155 | 21079 | 528 |
1773265 | 1773265 | 2021-10-01 | Trumbull | Ohio | 39155 | 20945 | 528 |
1770015 | 1770015 | 2021-09-30 | Trumbull | Ohio | 39155 | 20868 | 520 |
1766766 | 1766766 | 2021-09-29 | Trumbull | Ohio | 39155 | 20712 | 520 |
1763517 | 1763517 | 2021-09-28 | Trumbull | Ohio | 39155 | 20582 | 520 |
1760268 | 1760268 | 2021-09-27 | Trumbull | Ohio | 39155 | 20465 | 516 |
1757020 | 1757020 | 2021-09-26 | Trumbull | Ohio | 39155 | 20378 | 516 |
1753772 | 1753772 | 2021-09-25 | Trumbull | Ohio | 39155 | 20257 | 516 |
1750524 | 1750524 | 2021-09-24 | Trumbull | Ohio | 39155 | 20127 | 516 |
1747274 | 1747274 | 2021-09-23 | Trumbull | Ohio | 39155 | 19983 | 509 |
1744025 | 1744025 | 2021-09-22 | Trumbull | Ohio | 39155 | 19866 | 509 |
1740776 | 1740776 | 2021-09-21 | Trumbull | Ohio | 39155 | 19790 | 509 |
1737527 | 1737527 | 2021-09-20 | Trumbull | Ohio | 39155 | 19696 | 508 |
1734277 | 1734277 | 2021-09-19 | Trumbull | Ohio | 39155 | 19598 | 508 |
1731027 | 1731027 | 2021-09-18 | Trumbull | Ohio | 39155 | 19500 | 508 |
1727777 | 1727777 | 2021-09-17 | Trumbull | Ohio | 39155 | 19397 | 508 |
1724528 | 1724528 | 2021-09-16 | Trumbull | Ohio | 39155 | 19300 | 506 |
1721279 | 1721279 | 2021-09-15 | Trumbull | Ohio | 39155 | 19195 | 506 |
1718031 | 1718031 | 2021-09-14 | Trumbull | Ohio | 39155 | 19093 | 506 |
1714783 | 1714783 | 2021-09-13 | Trumbull | Ohio | 39155 | 18942 | 500 |
1711537 | 1711537 | 2021-09-12 | Trumbull | Ohio | 39155 | 18870 | 500 |
1708290 | 1708290 | 2021-09-11 | Trumbull | Ohio | 39155 | 18788 | 500 |
1705043 | 1705043 | 2021-09-10 | Trumbull | Ohio | 39155 | 18674 | 500 |
1701793 | 1701793 | 2021-09-09 | Trumbull | Ohio | 39155 | 18591 | 500 |
1698544 | 1698544 | 2021-09-08 | Trumbull | Ohio | 39155 | 18502 | 500 |
1695296 | 1695296 | 2021-09-07 | Trumbull | Ohio | 39155 | 18435 | 500 |
1692048 | 1692048 | 2021-09-06 | Trumbull | Ohio | 39155 | 18356 | 497 |
1688799 | 1688799 | 2021-09-05 | Trumbull | Ohio | 39155 | 18317 | 497 |
1685549 | 1685549 | 2021-09-04 | Trumbull | Ohio | 39155 | 18247 | 497 |
1682298 | 1682298 | 2021-09-03 | Trumbull | Ohio | 39155 | 18174 | 497 |
1679048 | 1679048 | 2021-09-02 | Trumbull | Ohio | 39155 | 18119 | 496 |
1675800 | 1675800 | 2021-09-01 | Trumbull | Ohio | 39155 | 18043 | 496 |
1672553 | 1672553 | 2021-08-31 | Trumbull | Ohio | 39155 | 18004 | 496 |
1669305 | 1669305 | 2021-08-30 | Trumbull | Ohio | 39155 | 17934 | 496 |
1666058 | 1666058 | 2021-08-29 | Trumbull | Ohio | 39155 | 17884 | 496 |
1662810 | 1662810 | 2021-08-28 | Trumbull | Ohio | 39155 | 17847 | 496 |
1659562 | 1659562 | 2021-08-27 | Trumbull | Ohio | 39155 | 17779 | 496 |
1656313 | 1656313 | 2021-08-26 | Trumbull | Ohio | 39155 | 17745 | 494 |
1653066 | 1653066 | 2021-08-25 | Trumbull | Ohio | 39155 | 17672 | 494 |
1649819 | 1649819 | 2021-08-24 | Trumbull | Ohio | 39155 | 17635 | 494 |
1646570 | 1646570 | 2021-08-23 | Trumbull | Ohio | 39155 | 17592 | 494 |
1643321 | 1643321 | 2021-08-22 | Trumbull | Ohio | 39155 | 17564 | 494 |
1640071 | 1640071 | 2021-08-21 | Trumbull | Ohio | 39155 | 17530 | 494 |
1636821 | 1636821 | 2021-08-20 | Trumbull | Ohio | 39155 | 17494 | 494 |
1633571 | 1633571 | 2021-08-19 | Trumbull | Ohio | 39155 | 17472 | 493 |
1630324 | 1630324 | 2021-08-18 | Trumbull | Ohio | 39155 | 17429 | 493 |
1627077 | 1627077 | 2021-08-17 | Trumbull | Ohio | 39155 | 17389 | 493 |
1623830 | 1623830 | 2021-08-16 | Trumbull | Ohio | 39155 | 17348 | 493 |
1620583 | 1620583 | 2021-08-15 | Trumbull | Ohio | 39155 | 17326 | 493 |
1617335 | 1617335 | 2021-08-14 | Trumbull | Ohio | 39155 | 17284 | 493 |
1614087 | 1614087 | 2021-08-13 | Trumbull | Ohio | 39155 | 17246 | 493 |
1610838 | 1610838 | 2021-08-12 | Trumbull | Ohio | 39155 | 17214 | 493 |
1607590 | 1607590 | 2021-08-11 | Trumbull | Ohio | 39155 | 17157 | 493 |
1604341 | 1604341 | 2021-08-10 | Trumbull | Ohio | 39155 | 17117 | 493 |
1601092 | 1601092 | 2021-08-09 | Trumbull | Ohio | 39155 | 17085 | 493 |
1597844 | 1597844 | 2021-08-08 | Trumbull | Ohio | 39155 | 17070 | 493 |
1594595 | 1594595 | 2021-08-07 | Trumbull | Ohio | 39155 | 17055 | 493 |
1591346 | 1591346 | 2021-08-06 | Trumbull | Ohio | 39155 | 17011 | 493 |
1588097 | 1588097 | 2021-08-05 | Trumbull | Ohio | 39155 | 16985 | 493 |
1584847 | 1584847 | 2021-08-04 | Trumbull | Ohio | 39155 | 16967 | 493 |
1581597 | 1581597 | 2021-08-03 | Trumbull | Ohio | 39155 | 16940 | 493 |
1578348 | 1578348 | 2021-08-02 | Trumbull | Ohio | 39155 | 16915 | 493 |
1575100 | 1575100 | 2021-08-01 | Trumbull | Ohio | 39155 | 16900 | 493 |
1571852 | 1571852 | 2021-07-31 | Trumbull | Ohio | 39155 | 16885 | 493 |
1568604 | 1568604 | 2021-07-30 | Trumbull | Ohio | 39155 | 16863 | 493 |
1565356 | 1565356 | 2021-07-29 | Trumbull | Ohio | 39155 | 16846 | 492 |
1562108 | 1562108 | 2021-07-28 | Trumbull | Ohio | 39155 | 16829 | 492 |
1558860 | 1558860 | 2021-07-27 | Trumbull | Ohio | 39155 | 16801 | 492 |
1555613 | 1555613 | 2021-07-26 | Trumbull | Ohio | 39155 | 16786 | 491 |
1552366 | 1552366 | 2021-07-25 | Trumbull | Ohio | 39155 | 16770 | 491 |
1549119 | 1549119 | 2021-07-24 | Trumbull | Ohio | 39155 | 16755 | 491 |
1545872 | 1545872 | 2021-07-23 | Trumbull | Ohio | 39155 | 16744 | 491 |
1542625 | 1542625 | 2021-07-22 | Trumbull | Ohio | 39155 | 16738 | 489 |
1539377 | 1539377 | 2021-07-21 | Trumbull | Ohio | 39155 | 16727 | 489 |
1536130 | 1536130 | 2021-07-20 | Trumbull | Ohio | 39155 | 16722 | 489 |
1532882 | 1532882 | 2021-07-19 | Trumbull | Ohio | 39155 | 16713 | 487 |
1529635 | 1529635 | 2021-07-18 | Trumbull | Ohio | 39155 | 16651 | 487 |
1526388 | 1526388 | 2021-07-17 | Trumbull | Ohio | 39155 | 16647 | 487 |
1523141 | 1523141 | 2021-07-16 | Trumbull | Ohio | 39155 | 16640 | 487 |
1519893 | 1519893 | 2021-07-15 | Trumbull | Ohio | 39155 | 16637 | 487 |
1516645 | 1516645 | 2021-07-14 | Trumbull | Ohio | 39155 | 16633 | 487 |
1513398 | 1513398 | 2021-07-13 | Trumbull | Ohio | 39155 | 16629 | 487 |
1510152 | 1510152 | 2021-07-12 | Trumbull | Ohio | 39155 | 16623 | 486 |
1506905 | 1506905 | 2021-07-11 | Trumbull | Ohio | 39155 | 16623 | 486 |
1503659 | 1503659 | 2021-07-10 | Trumbull | Ohio | 39155 | 16620 | 486 |
1500413 | 1500413 | 2021-07-09 | Trumbull | Ohio | 39155 | 16617 | 486 |
1497167 | 1497167 | 2021-07-08 | Trumbull | Ohio | 39155 | 16616 | 486 |
1493920 | 1493920 | 2021-07-07 | Trumbull | Ohio | 39155 | 16613 | 486 |
1490673 | 1490673 | 2021-07-06 | Trumbull | Ohio | 39155 | 16609 | 485 |
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);