ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
423 rows where deaths = 51 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2202341 | 2202341 | 2022-02-10 | Morgan | Ohio | 39115 | 3145 | 51 |
2202366 | 2202366 | 2022-02-10 | Vinton | Ohio | 39163 | 2831 | 51 |
2199087 | 2199087 | 2022-02-09 | Morgan | Ohio | 39115 | 3142 | 51 |
2199112 | 2199112 | 2022-02-09 | Vinton | Ohio | 39163 | 2827 | 51 |
2195833 | 2195833 | 2022-02-08 | Morgan | Ohio | 39115 | 3134 | 51 |
2195858 | 2195858 | 2022-02-08 | Vinton | Ohio | 39163 | 2812 | 51 |
2192604 | 2192604 | 2022-02-07 | Vinton | Ohio | 39163 | 2796 | 51 |
2189350 | 2189350 | 2022-02-06 | Vinton | Ohio | 39163 | 2788 | 51 |
2186097 | 2186097 | 2022-02-05 | Vinton | Ohio | 39163 | 2787 | 51 |
2182845 | 2182845 | 2022-02-04 | Vinton | Ohio | 39163 | 2777 | 51 |
2134018 | 2134018 | 2022-01-20 | Noble | Ohio | 39121 | 2893 | 51 |
2130766 | 2130766 | 2022-01-19 | Noble | Ohio | 39121 | 2850 | 51 |
2127512 | 2127512 | 2022-01-18 | Noble | Ohio | 39121 | 2815 | 51 |
2124260 | 2124260 | 2022-01-17 | Noble | Ohio | 39121 | 2798 | 51 |
2121008 | 2121008 | 2022-01-16 | Noble | Ohio | 39121 | 2788 | 51 |
2117756 | 2117756 | 2022-01-15 | Noble | Ohio | 39121 | 2768 | 51 |
2114505 | 2114505 | 2022-01-14 | Noble | Ohio | 39121 | 2716 | 51 |
2111253 | 2111253 | 2022-01-13 | Noble | Ohio | 39121 | 2672 | 51 |
2108001 | 2108001 | 2022-01-12 | Noble | Ohio | 39121 | 2635 | 51 |
2104750 | 2104750 | 2022-01-11 | Noble | Ohio | 39121 | 2610 | 51 |
1997480 | 1997480 | 2021-12-09 | Paulding | Ohio | 39125 | 3336 | 51 |
1994229 | 1994229 | 2021-12-08 | Paulding | Ohio | 39125 | 3312 | 51 |
1990978 | 1990978 | 2021-12-07 | Paulding | Ohio | 39125 | 3294 | 51 |
1987727 | 1987727 | 2021-12-06 | Paulding | Ohio | 39125 | 3275 | 51 |
1984477 | 1984477 | 2021-12-05 | Paulding | Ohio | 39125 | 3263 | 51 |
1981227 | 1981227 | 2021-12-04 | Paulding | Ohio | 39125 | 3261 | 51 |
1977977 | 1977977 | 2021-12-03 | Paulding | Ohio | 39125 | 3254 | 51 |
1974727 | 1974727 | 2021-12-02 | Paulding | Ohio | 39125 | 3238 | 51 |
1971478 | 1971478 | 2021-12-01 | Paulding | Ohio | 39125 | 3223 | 51 |
1968228 | 1968228 | 2021-11-30 | Paulding | Ohio | 39125 | 3205 | 51 |
1951943 | 1951943 | 2021-11-25 | Harrison | Ohio | 39067 | 2025 | 51 |
1948692 | 1948692 | 2021-11-24 | Harrison | Ohio | 39067 | 2025 | 51 |
1945441 | 1945441 | 2021-11-23 | Harrison | Ohio | 39067 | 2010 | 51 |
1851221 | 1851221 | 2021-10-25 | Meigs | Ohio | 39105 | 2672 | 51 |
1847971 | 1847971 | 2021-10-24 | Meigs | Ohio | 39105 | 2668 | 51 |
1844721 | 1844721 | 2021-10-23 | Meigs | Ohio | 39105 | 2658 | 51 |
1841471 | 1841471 | 2021-10-22 | Meigs | Ohio | 39105 | 2646 | 51 |
1815482 | 1815482 | 2021-10-14 | Monroe | Ohio | 39111 | 2097 | 51 |
1812234 | 1812234 | 2021-10-13 | Monroe | Ohio | 39111 | 2089 | 51 |
1808985 | 1808985 | 2021-10-12 | Monroe | Ohio | 39111 | 2075 | 51 |
1792748 | 1792748 | 2021-10-07 | Pike | Ohio | 39131 | 4194 | 51 |
1789499 | 1789499 | 2021-10-06 | Pike | Ohio | 39131 | 4174 | 51 |
1786251 | 1786251 | 2021-10-05 | Pike | Ohio | 39131 | 4162 | 51 |
1769996 | 1769996 | 2021-09-30 | Morrow | Ohio | 39117 | 4155 | 51 |
1770017 | 1770017 | 2021-09-30 | Union | Ohio | 39159 | 7618 | 51 |
1766747 | 1766747 | 2021-09-29 | Morrow | Ohio | 39117 | 4114 | 51 |
1766768 | 1766768 | 2021-09-29 | Union | Ohio | 39159 | 7581 | 51 |
1763498 | 1763498 | 2021-09-28 | Morrow | Ohio | 39117 | 4066 | 51 |
1763519 | 1763519 | 2021-09-28 | Union | Ohio | 39159 | 7526 | 51 |
1760249 | 1760249 | 2021-09-27 | Morrow | Ohio | 39117 | 4005 | 51 |
1760270 | 1760270 | 2021-09-27 | Union | Ohio | 39159 | 7453 | 51 |
1757001 | 1757001 | 2021-09-26 | Morrow | Ohio | 39117 | 3982 | 51 |
1757022 | 1757022 | 2021-09-26 | Union | Ohio | 39159 | 7439 | 51 |
1753753 | 1753753 | 2021-09-25 | Morrow | Ohio | 39117 | 3964 | 51 |
1753774 | 1753774 | 2021-09-25 | Union | Ohio | 39159 | 7426 | 51 |
1750505 | 1750505 | 2021-09-24 | Morrow | Ohio | 39117 | 3938 | 51 |
1750526 | 1750526 | 2021-09-24 | Union | Ohio | 39159 | 7407 | 51 |
1747255 | 1747255 | 2021-09-23 | Morrow | Ohio | 39117 | 3890 | 51 |
1747276 | 1747276 | 2021-09-23 | Union | Ohio | 39159 | 7366 | 51 |
1744006 | 1744006 | 2021-09-22 | Morrow | Ohio | 39117 | 3838 | 51 |
1744027 | 1744027 | 2021-09-22 | Union | Ohio | 39159 | 7318 | 51 |
1740757 | 1740757 | 2021-09-21 | Morrow | Ohio | 39117 | 3793 | 51 |
1740778 | 1740778 | 2021-09-21 | Union | Ohio | 39159 | 7264 | 51 |
1724460 | 1724460 | 2021-09-16 | Carroll | Ohio | 39019 | 2515 | 51 |
1724474 | 1724474 | 2021-09-16 | Fayette | Ohio | 39047 | 3613 | 51 |
1724514 | 1724514 | 2021-09-16 | Perry | Ohio | 39127 | 4211 | 51 |
1721211 | 1721211 | 2021-09-15 | Carroll | Ohio | 39019 | 2504 | 51 |
1721225 | 1721225 | 2021-09-15 | Fayette | Ohio | 39047 | 3539 | 51 |
1721265 | 1721265 | 2021-09-15 | Perry | Ohio | 39127 | 4140 | 51 |
1717963 | 1717963 | 2021-09-14 | Carroll | Ohio | 39019 | 2481 | 51 |
1717977 | 1717977 | 2021-09-14 | Fayette | Ohio | 39047 | 3515 | 51 |
1718017 | 1718017 | 2021-09-14 | Perry | Ohio | 39127 | 4070 | 51 |
1714715 | 1714715 | 2021-09-13 | Carroll | Ohio | 39019 | 2451 | 51 |
1714729 | 1714729 | 2021-09-13 | Fayette | Ohio | 39047 | 3489 | 51 |
1711469 | 1711469 | 2021-09-12 | Carroll | Ohio | 39019 | 2440 | 51 |
1711483 | 1711483 | 2021-09-12 | Fayette | Ohio | 39047 | 3477 | 51 |
1708222 | 1708222 | 2021-09-11 | Carroll | Ohio | 39019 | 2425 | 51 |
1708236 | 1708236 | 2021-09-11 | Fayette | Ohio | 39047 | 3462 | 51 |
1704975 | 1704975 | 2021-09-10 | Carroll | Ohio | 39019 | 2419 | 51 |
1704989 | 1704989 | 2021-09-10 | Fayette | Ohio | 39047 | 3436 | 51 |
1701739 | 1701739 | 2021-09-09 | Fayette | Ohio | 39047 | 3402 | 51 |
1698490 | 1698490 | 2021-09-08 | Fayette | Ohio | 39047 | 3376 | 51 |
1695242 | 1695242 | 2021-09-07 | Fayette | Ohio | 39047 | 3331 | 51 |
1656262 | 1656262 | 2021-08-26 | Gallia | Ohio | 39053 | 2821 | 51 |
1653015 | 1653015 | 2021-08-25 | Gallia | Ohio | 39053 | 2804 | 51 |
1649768 | 1649768 | 2021-08-24 | Gallia | Ohio | 39053 | 2781 | 51 |
1646519 | 1646519 | 2021-08-23 | Gallia | Ohio | 39053 | 2750 | 51 |
1643270 | 1643270 | 2021-08-22 | Gallia | Ohio | 39053 | 2743 | 51 |
1640020 | 1640020 | 2021-08-21 | Gallia | Ohio | 39053 | 2733 | 51 |
1636770 | 1636770 | 2021-08-20 | Gallia | Ohio | 39053 | 2702 | 51 |
1633520 | 1633520 | 2021-08-19 | Gallia | Ohio | 39053 | 2688 | 51 |
1630273 | 1630273 | 2021-08-18 | Gallia | Ohio | 39053 | 2672 | 51 |
1627026 | 1627026 | 2021-08-17 | Gallia | Ohio | 39053 | 2655 | 51 |
1623779 | 1623779 | 2021-08-16 | Gallia | Ohio | 39053 | 2635 | 51 |
1620532 | 1620532 | 2021-08-15 | Gallia | Ohio | 39053 | 2626 | 51 |
1617284 | 1617284 | 2021-08-14 | Gallia | Ohio | 39053 | 2620 | 51 |
1614036 | 1614036 | 2021-08-13 | Gallia | Ohio | 39053 | 2612 | 51 |
1610787 | 1610787 | 2021-08-12 | Gallia | Ohio | 39053 | 2605 | 51 |
1607539 | 1607539 | 2021-08-11 | Gallia | Ohio | 39053 | 2596 | 51 |
1604290 | 1604290 | 2021-08-10 | Gallia | Ohio | 39053 | 2589 | 51 |
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);