ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Butler" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812187 | 1812187 | 2021-10-13 | Butler | Ohio | 39017 | 50526 | 694 |
1808938 | 1808938 | 2021-10-12 | Butler | Ohio | 39017 | 50387 | 694 |
1805688 | 1805688 | 2021-10-11 | Butler | Ohio | 39017 | 50272 | 685 |
1802438 | 1802438 | 2021-10-10 | Butler | Ohio | 39017 | 50195 | 685 |
1799189 | 1799189 | 2021-10-09 | Butler | Ohio | 39017 | 50048 | 685 |
1795940 | 1795940 | 2021-10-08 | Butler | Ohio | 39017 | 49919 | 685 |
1792691 | 1792691 | 2021-10-07 | Butler | Ohio | 39017 | 49745 | 675 |
1789442 | 1789442 | 2021-10-06 | Butler | Ohio | 39017 | 49586 | 675 |
1786194 | 1786194 | 2021-10-05 | Butler | Ohio | 39017 | 49446 | 675 |
1782945 | 1782945 | 2021-10-04 | Butler | Ohio | 39017 | 49303 | 674 |
1779696 | 1779696 | 2021-10-03 | Butler | Ohio | 39017 | 49189 | 674 |
1776446 | 1776446 | 2021-10-02 | Butler | Ohio | 39017 | 49095 | 674 |
1773196 | 1773196 | 2021-10-01 | Butler | Ohio | 39017 | 48916 | 674 |
1769946 | 1769946 | 2021-09-30 | Butler | Ohio | 39017 | 48783 | 667 |
1766697 | 1766697 | 2021-09-29 | Butler | Ohio | 39017 | 48587 | 667 |
1763448 | 1763448 | 2021-09-28 | Butler | Ohio | 39017 | 48427 | 667 |
1760199 | 1760199 | 2021-09-27 | Butler | Ohio | 39017 | 48223 | 663 |
1756951 | 1756951 | 2021-09-26 | Butler | Ohio | 39017 | 48139 | 663 |
1753703 | 1753703 | 2021-09-25 | Butler | Ohio | 39017 | 48000 | 663 |
1750455 | 1750455 | 2021-09-24 | Butler | Ohio | 39017 | 47858 | 663 |
1747205 | 1747205 | 2021-09-23 | Butler | Ohio | 39017 | 47623 | 655 |
1743956 | 1743956 | 2021-09-22 | Butler | Ohio | 39017 | 47417 | 655 |
1740707 | 1740707 | 2021-09-21 | Butler | Ohio | 39017 | 47209 | 655 |
1737458 | 1737458 | 2021-09-20 | Butler | Ohio | 39017 | 47000 | 653 |
1734208 | 1734208 | 2021-09-19 | Butler | Ohio | 39017 | 46869 | 653 |
1730958 | 1730958 | 2021-09-18 | Butler | Ohio | 39017 | 46732 | 653 |
1727708 | 1727708 | 2021-09-17 | Butler | Ohio | 39017 | 46471 | 653 |
1724459 | 1724459 | 2021-09-16 | Butler | Ohio | 39017 | 46214 | 649 |
1721210 | 1721210 | 2021-09-15 | Butler | Ohio | 39017 | 45993 | 649 |
1717962 | 1717962 | 2021-09-14 | Butler | Ohio | 39017 | 45737 | 649 |
1714714 | 1714714 | 2021-09-13 | Butler | Ohio | 39017 | 45521 | 646 |
1711468 | 1711468 | 2021-09-12 | Butler | Ohio | 39017 | 45363 | 646 |
1708221 | 1708221 | 2021-09-11 | Butler | Ohio | 39017 | 45265 | 646 |
1704974 | 1704974 | 2021-09-10 | Butler | Ohio | 39017 | 44994 | 646 |
1701724 | 1701724 | 2021-09-09 | Butler | Ohio | 39017 | 44687 | 642 |
1698475 | 1698475 | 2021-09-08 | Butler | Ohio | 39017 | 44499 | 642 |
1695227 | 1695227 | 2021-09-07 | Butler | Ohio | 39017 | 44349 | 642 |
1691979 | 1691979 | 2021-09-06 | Butler | Ohio | 39017 | 44184 | 642 |
1688730 | 1688730 | 2021-09-05 | Butler | Ohio | 39017 | 44101 | 642 |
1685480 | 1685480 | 2021-09-04 | Butler | Ohio | 39017 | 43876 | 642 |
1682229 | 1682229 | 2021-09-03 | Butler | Ohio | 39017 | 43676 | 642 |
1678979 | 1678979 | 2021-09-02 | Butler | Ohio | 39017 | 43504 | 635 |
1675731 | 1675731 | 2021-09-01 | Butler | Ohio | 39017 | 43269 | 635 |
1672484 | 1672484 | 2021-08-31 | Butler | Ohio | 39017 | 42931 | 635 |
1669236 | 1669236 | 2021-08-30 | Butler | Ohio | 39017 | 42712 | 630 |
1665989 | 1665989 | 2021-08-29 | Butler | Ohio | 39017 | 42641 | 630 |
1662741 | 1662741 | 2021-08-28 | Butler | Ohio | 39017 | 42521 | 630 |
1659493 | 1659493 | 2021-08-27 | Butler | Ohio | 39017 | 42362 | 630 |
1656244 | 1656244 | 2021-08-26 | Butler | Ohio | 39017 | 42223 | 625 |
1652997 | 1652997 | 2021-08-25 | Butler | Ohio | 39017 | 42033 | 625 |
1649750 | 1649750 | 2021-08-24 | Butler | Ohio | 39017 | 41925 | 625 |
1646501 | 1646501 | 2021-08-23 | Butler | Ohio | 39017 | 41813 | 622 |
1643252 | 1643252 | 2021-08-22 | Butler | Ohio | 39017 | 41730 | 622 |
1640002 | 1640002 | 2021-08-21 | Butler | Ohio | 39017 | 41662 | 622 |
1636752 | 1636752 | 2021-08-20 | Butler | Ohio | 39017 | 41579 | 622 |
1633502 | 1633502 | 2021-08-19 | Butler | Ohio | 39017 | 41476 | 620 |
1630255 | 1630255 | 2021-08-18 | Butler | Ohio | 39017 | 41375 | 620 |
1627008 | 1627008 | 2021-08-17 | Butler | Ohio | 39017 | 41269 | 620 |
1623761 | 1623761 | 2021-08-16 | Butler | Ohio | 39017 | 41191 | 616 |
1620514 | 1620514 | 2021-08-15 | Butler | Ohio | 39017 | 41134 | 616 |
1617266 | 1617266 | 2021-08-14 | Butler | Ohio | 39017 | 41065 | 616 |
1614018 | 1614018 | 2021-08-13 | Butler | Ohio | 39017 | 40997 | 616 |
1610769 | 1610769 | 2021-08-12 | Butler | Ohio | 39017 | 40917 | 616 |
1607521 | 1607521 | 2021-08-11 | Butler | Ohio | 39017 | 40829 | 616 |
1604272 | 1604272 | 2021-08-10 | Butler | Ohio | 39017 | 40731 | 616 |
1601023 | 1601023 | 2021-08-09 | Butler | Ohio | 39017 | 40660 | 616 |
1597775 | 1597775 | 2021-08-08 | Butler | Ohio | 39017 | 40624 | 616 |
1594526 | 1594526 | 2021-08-07 | Butler | Ohio | 39017 | 40584 | 616 |
1591277 | 1591277 | 2021-08-06 | Butler | Ohio | 39017 | 40508 | 616 |
1588028 | 1588028 | 2021-08-05 | Butler | Ohio | 39017 | 40470 | 615 |
1584778 | 1584778 | 2021-08-04 | Butler | Ohio | 39017 | 40387 | 615 |
1581528 | 1581528 | 2021-08-03 | Butler | Ohio | 39017 | 40324 | 615 |
1578279 | 1578279 | 2021-08-02 | Butler | Ohio | 39017 | 40267 | 614 |
1575031 | 1575031 | 2021-08-01 | Butler | Ohio | 39017 | 40244 | 614 |
1571783 | 1571783 | 2021-07-31 | Butler | Ohio | 39017 | 40210 | 614 |
1568535 | 1568535 | 2021-07-30 | Butler | Ohio | 39017 | 40156 | 614 |
1565287 | 1565287 | 2021-07-29 | Butler | Ohio | 39017 | 40110 | 614 |
1562039 | 1562039 | 2021-07-28 | Butler | Ohio | 39017 | 40064 | 614 |
1558791 | 1558791 | 2021-07-27 | Butler | Ohio | 39017 | 40000 | 614 |
1555544 | 1555544 | 2021-07-26 | Butler | Ohio | 39017 | 39936 | 614 |
1552297 | 1552297 | 2021-07-25 | Butler | Ohio | 39017 | 39925 | 614 |
1549050 | 1549050 | 2021-07-24 | Butler | Ohio | 39017 | 39902 | 614 |
1545803 | 1545803 | 2021-07-23 | Butler | Ohio | 39017 | 39879 | 614 |
1542556 | 1542556 | 2021-07-22 | Butler | Ohio | 39017 | 39845 | 614 |
1539308 | 1539308 | 2021-07-21 | Butler | Ohio | 39017 | 39814 | 614 |
1536061 | 1536061 | 2021-07-20 | Butler | Ohio | 39017 | 39773 | 614 |
1532813 | 1532813 | 2021-07-19 | Butler | Ohio | 39017 | 39748 | 613 |
1529566 | 1529566 | 2021-07-18 | Butler | Ohio | 39017 | 39730 | 613 |
1526319 | 1526319 | 2021-07-17 | Butler | Ohio | 39017 | 39725 | 613 |
1523072 | 1523072 | 2021-07-16 | Butler | Ohio | 39017 | 39699 | 613 |
1519824 | 1519824 | 2021-07-15 | Butler | Ohio | 39017 | 39683 | 612 |
1516576 | 1516576 | 2021-07-14 | Butler | Ohio | 39017 | 39659 | 612 |
1513329 | 1513329 | 2021-07-13 | Butler | Ohio | 39017 | 39640 | 612 |
1510083 | 1510083 | 2021-07-12 | Butler | Ohio | 39017 | 39625 | 611 |
1506836 | 1506836 | 2021-07-11 | Butler | Ohio | 39017 | 39614 | 611 |
1503590 | 1503590 | 2021-07-10 | Butler | Ohio | 39017 | 39607 | 611 |
1500344 | 1500344 | 2021-07-09 | Butler | Ohio | 39017 | 39599 | 611 |
1497098 | 1497098 | 2021-07-08 | Butler | Ohio | 39017 | 39570 | 611 |
1493851 | 1493851 | 2021-07-07 | Butler | Ohio | 39017 | 39547 | 611 |
1490604 | 1490604 | 2021-07-06 | Butler | Ohio | 39017 | 39538 | 610 |
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);