ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Madison" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812227 | 1812227 | 2021-10-13 | Madison | Ohio | 39097 | 5817 | 75 |
1808978 | 1808978 | 2021-10-12 | Madison | Ohio | 39097 | 5796 | 75 |
1805728 | 1805728 | 2021-10-11 | Madison | Ohio | 39097 | 5771 | 74 |
1802478 | 1802478 | 2021-10-10 | Madison | Ohio | 39097 | 5761 | 74 |
1799229 | 1799229 | 2021-10-09 | Madison | Ohio | 39097 | 5744 | 74 |
1795980 | 1795980 | 2021-10-08 | Madison | Ohio | 39097 | 5736 | 74 |
1792731 | 1792731 | 2021-10-07 | Madison | Ohio | 39097 | 5717 | 73 |
1789482 | 1789482 | 2021-10-06 | Madison | Ohio | 39097 | 5701 | 73 |
1786234 | 1786234 | 2021-10-05 | Madison | Ohio | 39097 | 5687 | 73 |
1782985 | 1782985 | 2021-10-04 | Madison | Ohio | 39097 | 5648 | 72 |
1779736 | 1779736 | 2021-10-03 | Madison | Ohio | 39097 | 5635 | 72 |
1776486 | 1776486 | 2021-10-02 | Madison | Ohio | 39097 | 5630 | 72 |
1773236 | 1773236 | 2021-10-01 | Madison | Ohio | 39097 | 5616 | 72 |
1769986 | 1769986 | 2021-09-30 | Madison | Ohio | 39097 | 5586 | 71 |
1766737 | 1766737 | 2021-09-29 | Madison | Ohio | 39097 | 5563 | 71 |
1763488 | 1763488 | 2021-09-28 | Madison | Ohio | 39097 | 5552 | 71 |
1760239 | 1760239 | 2021-09-27 | Madison | Ohio | 39097 | 5525 | 71 |
1756991 | 1756991 | 2021-09-26 | Madison | Ohio | 39097 | 5521 | 71 |
1753743 | 1753743 | 2021-09-25 | Madison | Ohio | 39097 | 5510 | 71 |
1750495 | 1750495 | 2021-09-24 | Madison | Ohio | 39097 | 5493 | 71 |
1747245 | 1747245 | 2021-09-23 | Madison | Ohio | 39097 | 5467 | 71 |
1743996 | 1743996 | 2021-09-22 | Madison | Ohio | 39097 | 5433 | 71 |
1740747 | 1740747 | 2021-09-21 | Madison | Ohio | 39097 | 5407 | 71 |
1737498 | 1737498 | 2021-09-20 | Madison | Ohio | 39097 | 5371 | 70 |
1734248 | 1734248 | 2021-09-19 | Madison | Ohio | 39097 | 5355 | 70 |
1730998 | 1730998 | 2021-09-18 | Madison | Ohio | 39097 | 5351 | 70 |
1727748 | 1727748 | 2021-09-17 | Madison | Ohio | 39097 | 5324 | 70 |
1724499 | 1724499 | 2021-09-16 | Madison | Ohio | 39097 | 5297 | 68 |
1721250 | 1721250 | 2021-09-15 | Madison | Ohio | 39097 | 5273 | 68 |
1718002 | 1718002 | 2021-09-14 | Madison | Ohio | 39097 | 5237 | 68 |
1714754 | 1714754 | 2021-09-13 | Madison | Ohio | 39097 | 5209 | 68 |
1711508 | 1711508 | 2021-09-12 | Madison | Ohio | 39097 | 5185 | 68 |
1708261 | 1708261 | 2021-09-11 | Madison | Ohio | 39097 | 5175 | 68 |
1705014 | 1705014 | 2021-09-10 | Madison | Ohio | 39097 | 5138 | 68 |
1701764 | 1701764 | 2021-09-09 | Madison | Ohio | 39097 | 5101 | 66 |
1698515 | 1698515 | 2021-09-08 | Madison | Ohio | 39097 | 5053 | 66 |
1695267 | 1695267 | 2021-09-07 | Madison | Ohio | 39097 | 5031 | 66 |
1692019 | 1692019 | 2021-09-06 | Madison | Ohio | 39097 | 5019 | 66 |
1688770 | 1688770 | 2021-09-05 | Madison | Ohio | 39097 | 4999 | 66 |
1685520 | 1685520 | 2021-09-04 | Madison | Ohio | 39097 | 4990 | 66 |
1682269 | 1682269 | 2021-09-03 | Madison | Ohio | 39097 | 4963 | 66 |
1679019 | 1679019 | 2021-09-02 | Madison | Ohio | 39097 | 4931 | 65 |
1675771 | 1675771 | 2021-09-01 | Madison | Ohio | 39097 | 4888 | 65 |
1672524 | 1672524 | 2021-08-31 | Madison | Ohio | 39097 | 4858 | 65 |
1669276 | 1669276 | 2021-08-30 | Madison | Ohio | 39097 | 4828 | 65 |
1666029 | 1666029 | 2021-08-29 | Madison | Ohio | 39097 | 4818 | 65 |
1662781 | 1662781 | 2021-08-28 | Madison | Ohio | 39097 | 4800 | 65 |
1659533 | 1659533 | 2021-08-27 | Madison | Ohio | 39097 | 4761 | 65 |
1656284 | 1656284 | 2021-08-26 | Madison | Ohio | 39097 | 4741 | 65 |
1653037 | 1653037 | 2021-08-25 | Madison | Ohio | 39097 | 4721 | 65 |
1649790 | 1649790 | 2021-08-24 | Madison | Ohio | 39097 | 4703 | 65 |
1646541 | 1646541 | 2021-08-23 | Madison | Ohio | 39097 | 4674 | 65 |
1643292 | 1643292 | 2021-08-22 | Madison | Ohio | 39097 | 4663 | 65 |
1640042 | 1640042 | 2021-08-21 | Madison | Ohio | 39097 | 4659 | 65 |
1636792 | 1636792 | 2021-08-20 | Madison | Ohio | 39097 | 4644 | 65 |
1633542 | 1633542 | 2021-08-19 | Madison | Ohio | 39097 | 4627 | 65 |
1630295 | 1630295 | 2021-08-18 | Madison | Ohio | 39097 | 4617 | 65 |
1627048 | 1627048 | 2021-08-17 | Madison | Ohio | 39097 | 4601 | 65 |
1623801 | 1623801 | 2021-08-16 | Madison | Ohio | 39097 | 4597 | 65 |
1620554 | 1620554 | 2021-08-15 | Madison | Ohio | 39097 | 4592 | 65 |
1617306 | 1617306 | 2021-08-14 | Madison | Ohio | 39097 | 4584 | 65 |
1614058 | 1614058 | 2021-08-13 | Madison | Ohio | 39097 | 4573 | 65 |
1610809 | 1610809 | 2021-08-12 | Madison | Ohio | 39097 | 4564 | 65 |
1607561 | 1607561 | 2021-08-11 | Madison | Ohio | 39097 | 4559 | 65 |
1604312 | 1604312 | 2021-08-10 | Madison | Ohio | 39097 | 4547 | 65 |
1601063 | 1601063 | 2021-08-09 | Madison | Ohio | 39097 | 4541 | 65 |
1597815 | 1597815 | 2021-08-08 | Madison | Ohio | 39097 | 4535 | 65 |
1594566 | 1594566 | 2021-08-07 | Madison | Ohio | 39097 | 4532 | 65 |
1591317 | 1591317 | 2021-08-06 | Madison | Ohio | 39097 | 4520 | 65 |
1588068 | 1588068 | 2021-08-05 | Madison | Ohio | 39097 | 4514 | 66 |
1584818 | 1584818 | 2021-08-04 | Madison | Ohio | 39097 | 4502 | 66 |
1581568 | 1581568 | 2021-08-03 | Madison | Ohio | 39097 | 4500 | 66 |
1578319 | 1578319 | 2021-08-02 | Madison | Ohio | 39097 | 4495 | 66 |
1575071 | 1575071 | 2021-08-01 | Madison | Ohio | 39097 | 4492 | 66 |
1571823 | 1571823 | 2021-07-31 | Madison | Ohio | 39097 | 4489 | 66 |
1568575 | 1568575 | 2021-07-30 | Madison | Ohio | 39097 | 4482 | 66 |
1565327 | 1565327 | 2021-07-29 | Madison | Ohio | 39097 | 4481 | 66 |
1562079 | 1562079 | 2021-07-28 | Madison | Ohio | 39097 | 4480 | 66 |
1558831 | 1558831 | 2021-07-27 | Madison | Ohio | 39097 | 4475 | 66 |
1555584 | 1555584 | 2021-07-26 | Madison | Ohio | 39097 | 4472 | 66 |
1552337 | 1552337 | 2021-07-25 | Madison | Ohio | 39097 | 4472 | 66 |
1549090 | 1549090 | 2021-07-24 | Madison | Ohio | 39097 | 4470 | 66 |
1545843 | 1545843 | 2021-07-23 | Madison | Ohio | 39097 | 4469 | 66 |
1542596 | 1542596 | 2021-07-22 | Madison | Ohio | 39097 | 4467 | 66 |
1539348 | 1539348 | 2021-07-21 | Madison | Ohio | 39097 | 4466 | 66 |
1536101 | 1536101 | 2021-07-20 | Madison | Ohio | 39097 | 4466 | 66 |
1532853 | 1532853 | 2021-07-19 | Madison | Ohio | 39097 | 4464 | 66 |
1529606 | 1529606 | 2021-07-18 | Madison | Ohio | 39097 | 4463 | 66 |
1526359 | 1526359 | 2021-07-17 | Madison | Ohio | 39097 | 4462 | 66 |
1523112 | 1523112 | 2021-07-16 | Madison | Ohio | 39097 | 4462 | 66 |
1519864 | 1519864 | 2021-07-15 | Madison | Ohio | 39097 | 4460 | 66 |
1516616 | 1516616 | 2021-07-14 | Madison | Ohio | 39097 | 4459 | 66 |
1513369 | 1513369 | 2021-07-13 | Madison | Ohio | 39097 | 4458 | 66 |
1510123 | 1510123 | 2021-07-12 | Madison | Ohio | 39097 | 4458 | 66 |
1506876 | 1506876 | 2021-07-11 | Madison | Ohio | 39097 | 4458 | 66 |
1503630 | 1503630 | 2021-07-10 | Madison | Ohio | 39097 | 4456 | 66 |
1500384 | 1500384 | 2021-07-09 | Madison | Ohio | 39097 | 4453 | 66 |
1497138 | 1497138 | 2021-07-08 | Madison | Ohio | 39097 | 4453 | 66 |
1493891 | 1493891 | 2021-07-07 | Madison | Ohio | 39097 | 4452 | 66 |
1490644 | 1490644 | 2021-07-06 | Madison | Ohio | 39097 | 4451 | 66 |
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);