ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Clermont" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812191 | 1812191 | 2021-10-13 | Clermont | Ohio | 39025 | 27626 | 315 |
1808942 | 1808942 | 2021-10-12 | Clermont | Ohio | 39025 | 27537 | 315 |
1805692 | 1805692 | 2021-10-11 | Clermont | Ohio | 39025 | 27472 | 313 |
1802442 | 1802442 | 2021-10-10 | Clermont | Ohio | 39025 | 27436 | 313 |
1799193 | 1799193 | 2021-10-09 | Clermont | Ohio | 39025 | 27342 | 313 |
1795944 | 1795944 | 2021-10-08 | Clermont | Ohio | 39025 | 27296 | 313 |
1792695 | 1792695 | 2021-10-07 | Clermont | Ohio | 39025 | 27189 | 306 |
1789446 | 1789446 | 2021-10-06 | Clermont | Ohio | 39025 | 27076 | 306 |
1786198 | 1786198 | 2021-10-05 | Clermont | Ohio | 39025 | 26979 | 306 |
1782949 | 1782949 | 2021-10-04 | Clermont | Ohio | 39025 | 26887 | 305 |
1779700 | 1779700 | 2021-10-03 | Clermont | Ohio | 39025 | 26774 | 305 |
1776450 | 1776450 | 2021-10-02 | Clermont | Ohio | 39025 | 26705 | 305 |
1773200 | 1773200 | 2021-10-01 | Clermont | Ohio | 39025 | 26619 | 305 |
1769950 | 1769950 | 2021-09-30 | Clermont | Ohio | 39025 | 26528 | 300 |
1766701 | 1766701 | 2021-09-29 | Clermont | Ohio | 39025 | 26372 | 300 |
1763452 | 1763452 | 2021-09-28 | Clermont | Ohio | 39025 | 26262 | 300 |
1760203 | 1760203 | 2021-09-27 | Clermont | Ohio | 39025 | 26123 | 297 |
1756955 | 1756955 | 2021-09-26 | Clermont | Ohio | 39025 | 26081 | 297 |
1753707 | 1753707 | 2021-09-25 | Clermont | Ohio | 39025 | 25990 | 297 |
1750459 | 1750459 | 2021-09-24 | Clermont | Ohio | 39025 | 25897 | 297 |
1747209 | 1747209 | 2021-09-23 | Clermont | Ohio | 39025 | 25753 | 292 |
1743960 | 1743960 | 2021-09-22 | Clermont | Ohio | 39025 | 25628 | 292 |
1740711 | 1740711 | 2021-09-21 | Clermont | Ohio | 39025 | 25496 | 292 |
1737462 | 1737462 | 2021-09-20 | Clermont | Ohio | 39025 | 25366 | 287 |
1734212 | 1734212 | 2021-09-19 | Clermont | Ohio | 39025 | 25297 | 287 |
1730962 | 1730962 | 2021-09-18 | Clermont | Ohio | 39025 | 25206 | 287 |
1727712 | 1727712 | 2021-09-17 | Clermont | Ohio | 39025 | 25072 | 287 |
1724463 | 1724463 | 2021-09-16 | Clermont | Ohio | 39025 | 24904 | 278 |
1721214 | 1721214 | 2021-09-15 | Clermont | Ohio | 39025 | 24726 | 278 |
1717966 | 1717966 | 2021-09-14 | Clermont | Ohio | 39025 | 24582 | 278 |
1714718 | 1714718 | 2021-09-13 | Clermont | Ohio | 39025 | 24464 | 275 |
1711472 | 1711472 | 2021-09-12 | Clermont | Ohio | 39025 | 24369 | 275 |
1708225 | 1708225 | 2021-09-11 | Clermont | Ohio | 39025 | 24284 | 275 |
1704978 | 1704978 | 2021-09-10 | Clermont | Ohio | 39025 | 24098 | 275 |
1701728 | 1701728 | 2021-09-09 | Clermont | Ohio | 39025 | 23860 | 271 |
1698479 | 1698479 | 2021-09-08 | Clermont | Ohio | 39025 | 23742 | 271 |
1695231 | 1695231 | 2021-09-07 | Clermont | Ohio | 39025 | 23609 | 271 |
1691983 | 1691983 | 2021-09-06 | Clermont | Ohio | 39025 | 23518 | 270 |
1688734 | 1688734 | 2021-09-05 | Clermont | Ohio | 39025 | 23455 | 270 |
1685484 | 1685484 | 2021-09-04 | Clermont | Ohio | 39025 | 23284 | 270 |
1682233 | 1682233 | 2021-09-03 | Clermont | Ohio | 39025 | 23127 | 270 |
1678983 | 1678983 | 2021-09-02 | Clermont | Ohio | 39025 | 22975 | 269 |
1675735 | 1675735 | 2021-09-01 | Clermont | Ohio | 39025 | 22795 | 269 |
1672488 | 1672488 | 2021-08-31 | Clermont | Ohio | 39025 | 22566 | 269 |
1669240 | 1669240 | 2021-08-30 | Clermont | Ohio | 39025 | 22406 | 268 |
1665993 | 1665993 | 2021-08-29 | Clermont | Ohio | 39025 | 22353 | 268 |
1662745 | 1662745 | 2021-08-28 | Clermont | Ohio | 39025 | 22243 | 268 |
1659497 | 1659497 | 2021-08-27 | Clermont | Ohio | 39025 | 22152 | 268 |
1656248 | 1656248 | 2021-08-26 | Clermont | Ohio | 39025 | 22062 | 266 |
1653001 | 1653001 | 2021-08-25 | Clermont | Ohio | 39025 | 21959 | 266 |
1649754 | 1649754 | 2021-08-24 | Clermont | Ohio | 39025 | 21880 | 266 |
1646505 | 1646505 | 2021-08-23 | Clermont | Ohio | 39025 | 21827 | 265 |
1643256 | 1643256 | 2021-08-22 | Clermont | Ohio | 39025 | 21770 | 265 |
1640006 | 1640006 | 2021-08-21 | Clermont | Ohio | 39025 | 21734 | 265 |
1636756 | 1636756 | 2021-08-20 | Clermont | Ohio | 39025 | 21681 | 265 |
1633506 | 1633506 | 2021-08-19 | Clermont | Ohio | 39025 | 21583 | 264 |
1630259 | 1630259 | 2021-08-18 | Clermont | Ohio | 39025 | 21494 | 264 |
1627012 | 1627012 | 2021-08-17 | Clermont | Ohio | 39025 | 21433 | 264 |
1623765 | 1623765 | 2021-08-16 | Clermont | Ohio | 39025 | 21359 | 262 |
1620518 | 1620518 | 2021-08-15 | Clermont | Ohio | 39025 | 21319 | 262 |
1617270 | 1617270 | 2021-08-14 | Clermont | Ohio | 39025 | 21264 | 262 |
1614022 | 1614022 | 2021-08-13 | Clermont | Ohio | 39025 | 21199 | 262 |
1610773 | 1610773 | 2021-08-12 | Clermont | Ohio | 39025 | 21154 | 262 |
1607525 | 1607525 | 2021-08-11 | Clermont | Ohio | 39025 | 21044 | 262 |
1604276 | 1604276 | 2021-08-10 | Clermont | Ohio | 39025 | 20952 | 262 |
1601027 | 1601027 | 2021-08-09 | Clermont | Ohio | 39025 | 20888 | 262 |
1597779 | 1597779 | 2021-08-08 | Clermont | Ohio | 39025 | 20865 | 262 |
1594530 | 1594530 | 2021-08-07 | Clermont | Ohio | 39025 | 20822 | 262 |
1591281 | 1591281 | 2021-08-06 | Clermont | Ohio | 39025 | 20759 | 262 |
1588032 | 1588032 | 2021-08-05 | Clermont | Ohio | 39025 | 20717 | 261 |
1584782 | 1584782 | 2021-08-04 | Clermont | Ohio | 39025 | 20657 | 261 |
1581532 | 1581532 | 2021-08-03 | Clermont | Ohio | 39025 | 20592 | 261 |
1578283 | 1578283 | 2021-08-02 | Clermont | Ohio | 39025 | 20546 | 261 |
1575035 | 1575035 | 2021-08-01 | Clermont | Ohio | 39025 | 20529 | 261 |
1571787 | 1571787 | 2021-07-31 | Clermont | Ohio | 39025 | 20506 | 261 |
1568539 | 1568539 | 2021-07-30 | Clermont | Ohio | 39025 | 20469 | 261 |
1565291 | 1565291 | 2021-07-29 | Clermont | Ohio | 39025 | 20450 | 261 |
1562043 | 1562043 | 2021-07-28 | Clermont | Ohio | 39025 | 20425 | 261 |
1558795 | 1558795 | 2021-07-27 | Clermont | Ohio | 39025 | 20391 | 261 |
1555548 | 1555548 | 2021-07-26 | Clermont | Ohio | 39025 | 20368 | 260 |
1552301 | 1552301 | 2021-07-25 | Clermont | Ohio | 39025 | 20360 | 260 |
1549054 | 1549054 | 2021-07-24 | Clermont | Ohio | 39025 | 20350 | 260 |
1545807 | 1545807 | 2021-07-23 | Clermont | Ohio | 39025 | 20338 | 260 |
1542560 | 1542560 | 2021-07-22 | Clermont | Ohio | 39025 | 20329 | 259 |
1539312 | 1539312 | 2021-07-21 | Clermont | Ohio | 39025 | 20320 | 259 |
1536065 | 1536065 | 2021-07-20 | Clermont | Ohio | 39025 | 20299 | 259 |
1532817 | 1532817 | 2021-07-19 | Clermont | Ohio | 39025 | 20276 | 259 |
1529570 | 1529570 | 2021-07-18 | Clermont | Ohio | 39025 | 20269 | 259 |
1526323 | 1526323 | 2021-07-17 | Clermont | Ohio | 39025 | 20263 | 259 |
1523076 | 1523076 | 2021-07-16 | Clermont | Ohio | 39025 | 20254 | 259 |
1519828 | 1519828 | 2021-07-15 | Clermont | Ohio | 39025 | 20246 | 259 |
1516580 | 1516580 | 2021-07-14 | Clermont | Ohio | 39025 | 20238 | 259 |
1513333 | 1513333 | 2021-07-13 | Clermont | Ohio | 39025 | 20229 | 259 |
1510087 | 1510087 | 2021-07-12 | Clermont | Ohio | 39025 | 20224 | 258 |
1506840 | 1506840 | 2021-07-11 | Clermont | Ohio | 39025 | 20219 | 258 |
1503594 | 1503594 | 2021-07-10 | Clermont | Ohio | 39025 | 20218 | 258 |
1500348 | 1500348 | 2021-07-09 | Clermont | Ohio | 39025 | 20213 | 258 |
1497102 | 1497102 | 2021-07-08 | Clermont | Ohio | 39025 | 20209 | 257 |
1493855 | 1493855 | 2021-07-07 | Clermont | Ohio | 39025 | 20202 | 257 |
1490608 | 1490608 | 2021-07-06 | Clermont | Ohio | 39025 | 20197 | 256 |
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);