ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
468 rows where deaths = 49 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 |
---|---|---|---|---|---|---|---|
2179568 | 2179568 | 2022-02-03 | Morgan | Ohio | 39115 | 3096 | 49 |
2176317 | 2176317 | 2022-02-02 | Morgan | Ohio | 39115 | 3076 | 49 |
2173063 | 2173063 | 2022-02-01 | Morgan | Ohio | 39115 | 3055 | 49 |
2020233 | 2020233 | 2021-12-16 | Noble | Ohio | 39121 | 2279 | 49 |
2016982 | 2016982 | 2021-12-15 | Noble | Ohio | 39121 | 2276 | 49 |
2013732 | 2013732 | 2021-12-14 | Noble | Ohio | 39121 | 2270 | 49 |
2010481 | 2010481 | 2021-12-13 | Noble | Ohio | 39121 | 2267 | 49 |
2007230 | 2007230 | 2021-12-12 | Noble | Ohio | 39121 | 2258 | 49 |
2003979 | 2003979 | 2021-12-11 | Noble | Ohio | 39121 | 2256 | 49 |
2000728 | 2000728 | 2021-12-10 | Noble | Ohio | 39121 | 2251 | 49 |
1997478 | 1997478 | 2021-12-09 | Noble | Ohio | 39121 | 2247 | 49 |
1994227 | 1994227 | 2021-12-08 | Noble | Ohio | 39121 | 2242 | 49 |
1990976 | 1990976 | 2021-12-07 | Noble | Ohio | 39121 | 2232 | 49 |
1987725 | 1987725 | 2021-12-06 | Noble | Ohio | 39121 | 2219 | 49 |
1984475 | 1984475 | 2021-12-05 | Noble | Ohio | 39121 | 2215 | 49 |
1981225 | 1981225 | 2021-12-04 | Noble | Ohio | 39121 | 2213 | 49 |
1977975 | 1977975 | 2021-12-03 | Noble | Ohio | 39121 | 2203 | 49 |
1964977 | 1964977 | 2021-11-29 | Paulding | Ohio | 39125 | 3193 | 49 |
1961725 | 1961725 | 2021-11-28 | Paulding | Ohio | 39125 | 3179 | 49 |
1958474 | 1958474 | 2021-11-27 | Paulding | Ohio | 39125 | 3174 | 49 |
1955223 | 1955223 | 2021-11-26 | Paulding | Ohio | 39125 | 3170 | 49 |
1929189 | 1929189 | 2021-11-18 | Harrison | Ohio | 39067 | 1971 | 49 |
1925939 | 1925939 | 2021-11-17 | Harrison | Ohio | 39067 | 1964 | 49 |
1922689 | 1922689 | 2021-11-16 | Harrison | Ohio | 39067 | 1957 | 49 |
1919440 | 1919440 | 2021-11-15 | Harrison | Ohio | 39067 | 1942 | 49 |
1916190 | 1916190 | 2021-11-14 | Harrison | Ohio | 39067 | 1942 | 49 |
1912940 | 1912940 | 2021-11-13 | Harrison | Ohio | 39067 | 1938 | 49 |
1909690 | 1909690 | 2021-11-12 | Harrison | Ohio | 39067 | 1934 | 49 |
1906441 | 1906441 | 2021-11-11 | Harrison | Ohio | 39067 | 1927 | 49 |
1903192 | 1903192 | 2021-11-10 | Harrison | Ohio | 39067 | 1919 | 49 |
1899942 | 1899942 | 2021-11-09 | Harrison | Ohio | 39067 | 1907 | 49 |
1828475 | 1828475 | 2021-10-18 | Meigs | Ohio | 39105 | 2592 | 49 |
1825226 | 1825226 | 2021-10-17 | Meigs | Ohio | 39105 | 2583 | 49 |
1821977 | 1821977 | 2021-10-16 | Meigs | Ohio | 39105 | 2578 | 49 |
1818728 | 1818728 | 2021-10-15 | Meigs | Ohio | 39105 | 2568 | 49 |
1769993 | 1769993 | 2021-09-30 | Monroe | Ohio | 39111 | 1978 | 49 |
1766744 | 1766744 | 2021-09-29 | Monroe | Ohio | 39111 | 1968 | 49 |
1763495 | 1763495 | 2021-09-28 | Monroe | Ohio | 39111 | 1949 | 49 |
1760246 | 1760246 | 2021-09-27 | Monroe | Ohio | 39111 | 1934 | 49 |
1756998 | 1756998 | 2021-09-26 | Monroe | Ohio | 39111 | 1931 | 49 |
1753750 | 1753750 | 2021-09-25 | Monroe | Ohio | 39111 | 1927 | 49 |
1750502 | 1750502 | 2021-09-24 | Monroe | Ohio | 39111 | 1919 | 49 |
1747252 | 1747252 | 2021-09-23 | Monroe | Ohio | 39111 | 1908 | 49 |
1744003 | 1744003 | 2021-09-22 | Monroe | Ohio | 39111 | 1897 | 49 |
1740754 | 1740754 | 2021-09-21 | Monroe | Ohio | 39111 | 1884 | 49 |
1737505 | 1737505 | 2021-09-20 | Monroe | Ohio | 39111 | 1867 | 49 |
1737529 | 1737529 | 2021-09-20 | Union | Ohio | 39159 | 7216 | 49 |
1734255 | 1734255 | 2021-09-19 | Monroe | Ohio | 39111 | 1856 | 49 |
1734279 | 1734279 | 2021-09-19 | Union | Ohio | 39159 | 7192 | 49 |
1731005 | 1731005 | 2021-09-18 | Monroe | Ohio | 39111 | 1850 | 49 |
1731029 | 1731029 | 2021-09-18 | Union | Ohio | 39159 | 7178 | 49 |
1727755 | 1727755 | 2021-09-17 | Monroe | Ohio | 39111 | 1833 | 49 |
1727779 | 1727779 | 2021-09-17 | Union | Ohio | 39159 | 7141 | 49 |
1724506 | 1724506 | 2021-09-16 | Monroe | Ohio | 39111 | 1806 | 49 |
1724509 | 1724509 | 2021-09-16 | Morrow | Ohio | 39117 | 3635 | 49 |
1724530 | 1724530 | 2021-09-16 | Union | Ohio | 39159 | 7092 | 49 |
1721257 | 1721257 | 2021-09-15 | Monroe | Ohio | 39111 | 1786 | 49 |
1721260 | 1721260 | 2021-09-15 | Morrow | Ohio | 39117 | 3591 | 49 |
1721281 | 1721281 | 2021-09-15 | Union | Ohio | 39159 | 7035 | 49 |
1718009 | 1718009 | 2021-09-14 | Monroe | Ohio | 39111 | 1766 | 49 |
1718012 | 1718012 | 2021-09-14 | Morrow | Ohio | 39117 | 3560 | 49 |
1718033 | 1718033 | 2021-09-14 | Union | Ohio | 39159 | 7004 | 49 |
1714785 | 1714785 | 2021-09-13 | Union | Ohio | 39159 | 6960 | 49 |
1711539 | 1711539 | 2021-09-12 | Union | Ohio | 39159 | 6934 | 49 |
1708292 | 1708292 | 2021-09-11 | Union | Ohio | 39159 | 6915 | 49 |
1705045 | 1705045 | 2021-09-10 | Union | Ohio | 39159 | 6877 | 49 |
1701725 | 1701725 | 2021-09-09 | Carroll | Ohio | 39019 | 2394 | 49 |
1701795 | 1701795 | 2021-09-09 | Union | Ohio | 39159 | 6819 | 49 |
1698476 | 1698476 | 2021-09-08 | Carroll | Ohio | 39019 | 2375 | 49 |
1698546 | 1698546 | 2021-09-08 | Union | Ohio | 39159 | 6753 | 49 |
1695228 | 1695228 | 2021-09-07 | Carroll | Ohio | 39019 | 2353 | 49 |
1695298 | 1695298 | 2021-09-07 | Union | Ohio | 39159 | 6689 | 49 |
1691980 | 1691980 | 2021-09-06 | Carroll | Ohio | 39019 | 2346 | 49 |
1692050 | 1692050 | 2021-09-06 | Union | Ohio | 39159 | 6674 | 49 |
1688731 | 1688731 | 2021-09-05 | Carroll | Ohio | 39019 | 2328 | 49 |
1688801 | 1688801 | 2021-09-05 | Union | Ohio | 39159 | 6655 | 49 |
1685481 | 1685481 | 2021-09-04 | Carroll | Ohio | 39019 | 2315 | 49 |
1685551 | 1685551 | 2021-09-04 | Union | Ohio | 39159 | 6625 | 49 |
1682230 | 1682230 | 2021-09-03 | Carroll | Ohio | 39019 | 2299 | 49 |
1682300 | 1682300 | 2021-09-03 | Union | Ohio | 39159 | 6581 | 49 |
1678980 | 1678980 | 2021-09-02 | Carroll | Ohio | 39019 | 2286 | 49 |
1679050 | 1679050 | 2021-09-02 | Union | Ohio | 39159 | 6526 | 49 |
1675732 | 1675732 | 2021-09-01 | Carroll | Ohio | 39019 | 2253 | 49 |
1675802 | 1675802 | 2021-09-01 | Union | Ohio | 39159 | 6482 | 49 |
1672485 | 1672485 | 2021-08-31 | Carroll | Ohio | 39019 | 2241 | 49 |
1672555 | 1672555 | 2021-08-31 | Union | Ohio | 39159 | 6423 | 49 |
1669237 | 1669237 | 2021-08-30 | Carroll | Ohio | 39019 | 2224 | 49 |
1669307 | 1669307 | 2021-08-30 | Union | Ohio | 39159 | 6378 | 49 |
1665990 | 1665990 | 2021-08-29 | Carroll | Ohio | 39019 | 2212 | 49 |
1666060 | 1666060 | 2021-08-29 | Union | Ohio | 39159 | 6366 | 49 |
1662742 | 1662742 | 2021-08-28 | Carroll | Ohio | 39019 | 2200 | 49 |
1662812 | 1662812 | 2021-08-28 | Union | Ohio | 39159 | 6346 | 49 |
1659494 | 1659494 | 2021-08-27 | Carroll | Ohio | 39019 | 2186 | 49 |
1659564 | 1659564 | 2021-08-27 | Union | Ohio | 39159 | 6314 | 49 |
1656245 | 1656245 | 2021-08-26 | Carroll | Ohio | 39019 | 2176 | 49 |
1656315 | 1656315 | 2021-08-26 | Union | Ohio | 39159 | 6289 | 49 |
1652998 | 1652998 | 2021-08-25 | Carroll | Ohio | 39019 | 2170 | 49 |
1653068 | 1653068 | 2021-08-25 | Union | Ohio | 39159 | 6249 | 49 |
1649751 | 1649751 | 2021-08-24 | Carroll | Ohio | 39019 | 2159 | 49 |
1649821 | 1649821 | 2021-08-24 | Union | Ohio | 39159 | 6223 | 49 |
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);