ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Champaign" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812189 | 1812189 | 2021-10-13 | Champaign | Ohio | 39021 | 4967 | 70 |
1808940 | 1808940 | 2021-10-12 | Champaign | Ohio | 39021 | 4932 | 70 |
1805690 | 1805690 | 2021-10-11 | Champaign | Ohio | 39021 | 4914 | 66 |
1802440 | 1802440 | 2021-10-10 | Champaign | Ohio | 39021 | 4906 | 66 |
1799191 | 1799191 | 2021-10-09 | Champaign | Ohio | 39021 | 4876 | 66 |
1795942 | 1795942 | 2021-10-08 | Champaign | Ohio | 39021 | 4869 | 66 |
1792693 | 1792693 | 2021-10-07 | Champaign | Ohio | 39021 | 4847 | 65 |
1789444 | 1789444 | 2021-10-06 | Champaign | Ohio | 39021 | 4810 | 65 |
1786196 | 1786196 | 2021-10-05 | Champaign | Ohio | 39021 | 4774 | 65 |
1782947 | 1782947 | 2021-10-04 | Champaign | Ohio | 39021 | 4754 | 64 |
1779698 | 1779698 | 2021-10-03 | Champaign | Ohio | 39021 | 4735 | 64 |
1776448 | 1776448 | 2021-10-02 | Champaign | Ohio | 39021 | 4719 | 64 |
1773198 | 1773198 | 2021-10-01 | Champaign | Ohio | 39021 | 4698 | 64 |
1769948 | 1769948 | 2021-09-30 | Champaign | Ohio | 39021 | 4664 | 64 |
1766699 | 1766699 | 2021-09-29 | Champaign | Ohio | 39021 | 4632 | 64 |
1763450 | 1763450 | 2021-09-28 | Champaign | Ohio | 39021 | 4605 | 64 |
1760201 | 1760201 | 2021-09-27 | Champaign | Ohio | 39021 | 4566 | 64 |
1756953 | 1756953 | 2021-09-26 | Champaign | Ohio | 39021 | 4549 | 64 |
1753705 | 1753705 | 2021-09-25 | Champaign | Ohio | 39021 | 4542 | 64 |
1750457 | 1750457 | 2021-09-24 | Champaign | Ohio | 39021 | 4522 | 64 |
1747207 | 1747207 | 2021-09-23 | Champaign | Ohio | 39021 | 4488 | 64 |
1743958 | 1743958 | 2021-09-22 | Champaign | Ohio | 39021 | 4459 | 64 |
1740709 | 1740709 | 2021-09-21 | Champaign | Ohio | 39021 | 4435 | 64 |
1737460 | 1737460 | 2021-09-20 | Champaign | Ohio | 39021 | 4402 | 64 |
1734210 | 1734210 | 2021-09-19 | Champaign | Ohio | 39021 | 4381 | 64 |
1730960 | 1730960 | 2021-09-18 | Champaign | Ohio | 39021 | 4362 | 64 |
1727710 | 1727710 | 2021-09-17 | Champaign | Ohio | 39021 | 4329 | 64 |
1724461 | 1724461 | 2021-09-16 | Champaign | Ohio | 39021 | 4295 | 63 |
1721212 | 1721212 | 2021-09-15 | Champaign | Ohio | 39021 | 4264 | 63 |
1717964 | 1717964 | 2021-09-14 | Champaign | Ohio | 39021 | 4225 | 63 |
1714716 | 1714716 | 2021-09-13 | Champaign | Ohio | 39021 | 4195 | 63 |
1711470 | 1711470 | 2021-09-12 | Champaign | Ohio | 39021 | 4165 | 63 |
1708223 | 1708223 | 2021-09-11 | Champaign | Ohio | 39021 | 4147 | 63 |
1704976 | 1704976 | 2021-09-10 | Champaign | Ohio | 39021 | 4114 | 63 |
1701726 | 1701726 | 2021-09-09 | Champaign | Ohio | 39021 | 4061 | 61 |
1698477 | 1698477 | 2021-09-08 | Champaign | Ohio | 39021 | 4032 | 61 |
1695229 | 1695229 | 2021-09-07 | Champaign | Ohio | 39021 | 4003 | 61 |
1691981 | 1691981 | 2021-09-06 | Champaign | Ohio | 39021 | 3987 | 61 |
1688732 | 1688732 | 2021-09-05 | Champaign | Ohio | 39021 | 3966 | 61 |
1685482 | 1685482 | 2021-09-04 | Champaign | Ohio | 39021 | 3947 | 61 |
1682231 | 1682231 | 2021-09-03 | Champaign | Ohio | 39021 | 3926 | 61 |
1678981 | 1678981 | 2021-09-02 | Champaign | Ohio | 39021 | 3899 | 60 |
1675733 | 1675733 | 2021-09-01 | Champaign | Ohio | 39021 | 3875 | 60 |
1672486 | 1672486 | 2021-08-31 | Champaign | Ohio | 39021 | 3851 | 60 |
1669238 | 1669238 | 2021-08-30 | Champaign | Ohio | 39021 | 3828 | 60 |
1665991 | 1665991 | 2021-08-29 | Champaign | Ohio | 39021 | 3809 | 60 |
1662743 | 1662743 | 2021-08-28 | Champaign | Ohio | 39021 | 3798 | 60 |
1659495 | 1659495 | 2021-08-27 | Champaign | Ohio | 39021 | 3786 | 60 |
1656246 | 1656246 | 2021-08-26 | Champaign | Ohio | 39021 | 3769 | 60 |
1652999 | 1652999 | 2021-08-25 | Champaign | Ohio | 39021 | 3738 | 60 |
1649752 | 1649752 | 2021-08-24 | Champaign | Ohio | 39021 | 3715 | 60 |
1646503 | 1646503 | 2021-08-23 | Champaign | Ohio | 39021 | 3708 | 60 |
1643254 | 1643254 | 2021-08-22 | Champaign | Ohio | 39021 | 3698 | 60 |
1640004 | 1640004 | 2021-08-21 | Champaign | Ohio | 39021 | 3690 | 60 |
1636754 | 1636754 | 2021-08-20 | Champaign | Ohio | 39021 | 3669 | 60 |
1633504 | 1633504 | 2021-08-19 | Champaign | Ohio | 39021 | 3657 | 60 |
1630257 | 1630257 | 2021-08-18 | Champaign | Ohio | 39021 | 3644 | 60 |
1627010 | 1627010 | 2021-08-17 | Champaign | Ohio | 39021 | 3635 | 60 |
1623763 | 1623763 | 2021-08-16 | Champaign | Ohio | 39021 | 3611 | 60 |
1620516 | 1620516 | 2021-08-15 | Champaign | Ohio | 39021 | 3603 | 60 |
1617268 | 1617268 | 2021-08-14 | Champaign | Ohio | 39021 | 3598 | 60 |
1614020 | 1614020 | 2021-08-13 | Champaign | Ohio | 39021 | 3589 | 60 |
1610771 | 1610771 | 2021-08-12 | Champaign | Ohio | 39021 | 3570 | 60 |
1607523 | 1607523 | 2021-08-11 | Champaign | Ohio | 39021 | 3566 | 60 |
1604274 | 1604274 | 2021-08-10 | Champaign | Ohio | 39021 | 3557 | 60 |
1601025 | 1601025 | 2021-08-09 | Champaign | Ohio | 39021 | 3545 | 60 |
1597777 | 1597777 | 2021-08-08 | Champaign | Ohio | 39021 | 3544 | 60 |
1594528 | 1594528 | 2021-08-07 | Champaign | Ohio | 39021 | 3540 | 60 |
1591279 | 1591279 | 2021-08-06 | Champaign | Ohio | 39021 | 3534 | 60 |
1588030 | 1588030 | 2021-08-05 | Champaign | Ohio | 39021 | 3528 | 60 |
1584780 | 1584780 | 2021-08-04 | Champaign | Ohio | 39021 | 3523 | 60 |
1581530 | 1581530 | 2021-08-03 | Champaign | Ohio | 39021 | 3517 | 60 |
1578281 | 1578281 | 2021-08-02 | Champaign | Ohio | 39021 | 3513 | 60 |
1575033 | 1575033 | 2021-08-01 | Champaign | Ohio | 39021 | 3512 | 60 |
1571785 | 1571785 | 2021-07-31 | Champaign | Ohio | 39021 | 3510 | 60 |
1568537 | 1568537 | 2021-07-30 | Champaign | Ohio | 39021 | 3509 | 60 |
1565289 | 1565289 | 2021-07-29 | Champaign | Ohio | 39021 | 3504 | 60 |
1562041 | 1562041 | 2021-07-28 | Champaign | Ohio | 39021 | 3498 | 60 |
1558793 | 1558793 | 2021-07-27 | Champaign | Ohio | 39021 | 3496 | 60 |
1555546 | 1555546 | 2021-07-26 | Champaign | Ohio | 39021 | 3483 | 60 |
1552299 | 1552299 | 2021-07-25 | Champaign | Ohio | 39021 | 3480 | 60 |
1549052 | 1549052 | 2021-07-24 | Champaign | Ohio | 39021 | 3477 | 60 |
1545805 | 1545805 | 2021-07-23 | Champaign | Ohio | 39021 | 3475 | 60 |
1542558 | 1542558 | 2021-07-22 | Champaign | Ohio | 39021 | 3474 | 60 |
1539310 | 1539310 | 2021-07-21 | Champaign | Ohio | 39021 | 3474 | 60 |
1536063 | 1536063 | 2021-07-20 | Champaign | Ohio | 39021 | 3470 | 60 |
1532815 | 1532815 | 2021-07-19 | Champaign | Ohio | 39021 | 3470 | 60 |
1529568 | 1529568 | 2021-07-18 | Champaign | Ohio | 39021 | 3468 | 60 |
1526321 | 1526321 | 2021-07-17 | Champaign | Ohio | 39021 | 3468 | 60 |
1523074 | 1523074 | 2021-07-16 | Champaign | Ohio | 39021 | 3468 | 60 |
1519826 | 1519826 | 2021-07-15 | Champaign | Ohio | 39021 | 3467 | 60 |
1516578 | 1516578 | 2021-07-14 | Champaign | Ohio | 39021 | 3467 | 60 |
1513331 | 1513331 | 2021-07-13 | Champaign | Ohio | 39021 | 3464 | 60 |
1510085 | 1510085 | 2021-07-12 | Champaign | Ohio | 39021 | 3464 | 60 |
1506838 | 1506838 | 2021-07-11 | Champaign | Ohio | 39021 | 3464 | 60 |
1503592 | 1503592 | 2021-07-10 | Champaign | Ohio | 39021 | 3461 | 60 |
1500346 | 1500346 | 2021-07-09 | Champaign | Ohio | 39021 | 3460 | 60 |
1497100 | 1497100 | 2021-07-08 | Champaign | Ohio | 39021 | 3459 | 60 |
1493853 | 1493853 | 2021-07-07 | Champaign | Ohio | 39021 | 3456 | 60 |
1490606 | 1490606 | 2021-07-06 | Champaign | Ohio | 39021 | 3456 | 60 |
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);