ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
179 rows where deaths = 72 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2283607 | 2283607 | 2022-03-07 | Harrison | Ohio | 39067 | 3205 | 72 |
2280355 | 2280355 | 2022-03-06 | Harrison | Ohio | 39067 | 3205 | 72 |
2277102 | 2277102 | 2022-03-05 | Harrison | Ohio | 39067 | 3205 | 72 |
2273849 | 2273849 | 2022-03-04 | Harrison | Ohio | 39067 | 3205 | 72 |
2270596 | 2270596 | 2022-03-03 | Harrison | Ohio | 39067 | 3204 | 72 |
2270625 | 2270625 | 2022-03-03 | Paulding | Ohio | 39125 | 4584 | 72 |
2267344 | 2267344 | 2022-03-02 | Harrison | Ohio | 39067 | 3202 | 72 |
2267373 | 2267373 | 2022-03-02 | Paulding | Ohio | 39125 | 4585 | 72 |
2264091 | 2264091 | 2022-03-01 | Harrison | Ohio | 39067 | 3199 | 72 |
2264120 | 2264120 | 2022-03-01 | Paulding | Ohio | 39125 | 4585 | 72 |
2260841 | 2260841 | 2022-02-28 | Harrison | Ohio | 39067 | 3198 | 72 |
2257590 | 2257590 | 2022-02-27 | Harrison | Ohio | 39067 | 3196 | 72 |
2254339 | 2254339 | 2022-02-26 | Harrison | Ohio | 39067 | 3195 | 72 |
2251088 | 2251088 | 2022-02-25 | Harrison | Ohio | 39067 | 3192 | 72 |
2225102 | 2225102 | 2022-02-17 | Monroe | Ohio | 39111 | 3404 | 72 |
2221851 | 2221851 | 2022-02-16 | Monroe | Ohio | 39111 | 3402 | 72 |
2218600 | 2218600 | 2022-02-15 | Monroe | Ohio | 39111 | 3399 | 72 |
2078735 | 2078735 | 2022-01-03 | Morrow | Ohio | 39117 | 6026 | 72 |
2075484 | 2075484 | 2022-01-02 | Morrow | Ohio | 39117 | 5980 | 72 |
2072233 | 2072233 | 2022-01-01 | Morrow | Ohio | 39117 | 5903 | 72 |
2068982 | 2068982 | 2021-12-31 | Morrow | Ohio | 39117 | 5903 | 72 |
2020196 | 2020196 | 2021-12-16 | Fayette | Ohio | 39047 | 5242 | 72 |
2016945 | 2016945 | 2021-12-15 | Fayette | Ohio | 39047 | 5216 | 72 |
2013695 | 2013695 | 2021-12-14 | Fayette | Ohio | 39047 | 5186 | 72 |
2010444 | 2010444 | 2021-12-13 | Fayette | Ohio | 39047 | 5147 | 72 |
2007193 | 2007193 | 2021-12-12 | Fayette | Ohio | 39047 | 5132 | 72 |
2003942 | 2003942 | 2021-12-11 | Fayette | Ohio | 39047 | 5115 | 72 |
2000691 | 2000691 | 2021-12-10 | Fayette | Ohio | 39047 | 5096 | 72 |
1997441 | 1997441 | 2021-12-09 | Fayette | Ohio | 39047 | 5067 | 72 |
1994190 | 1994190 | 2021-12-08 | Fayette | Ohio | 39047 | 5036 | 72 |
1990939 | 1990939 | 2021-12-07 | Fayette | Ohio | 39047 | 5024 | 72 |
1987688 | 1987688 | 2021-12-06 | Fayette | Ohio | 39047 | 4990 | 72 |
1984438 | 1984438 | 2021-12-05 | Fayette | Ohio | 39047 | 4972 | 72 |
1981188 | 1981188 | 2021-12-04 | Fayette | Ohio | 39047 | 4956 | 72 |
1977938 | 1977938 | 2021-12-03 | Fayette | Ohio | 39047 | 4940 | 72 |
1951989 | 1951989 | 2021-11-25 | Union | Ohio | 39159 | 9268 | 72 |
1948738 | 1948738 | 2021-11-24 | Union | Ohio | 39159 | 9268 | 72 |
1945487 | 1945487 | 2021-11-23 | Union | Ohio | 39159 | 9223 | 72 |
1883685 | 1883685 | 2021-11-04 | Gallia | Ohio | 39053 | 4323 | 72 |
1883724 | 1883724 | 2021-11-04 | Pike | Ohio | 39131 | 4410 | 72 |
1880436 | 1880436 | 2021-11-03 | Gallia | Ohio | 39053 | 4305 | 72 |
1880475 | 1880475 | 2021-11-03 | Pike | Ohio | 39131 | 4400 | 72 |
1877187 | 1877187 | 2021-11-02 | Gallia | Ohio | 39053 | 4294 | 72 |
1877226 | 1877226 | 2021-11-02 | Pike | Ohio | 39131 | 4394 | 72 |
1860945 | 1860945 | 2021-10-28 | Guernsey | Ohio | 39059 | 6081 | 72 |
1857696 | 1857696 | 2021-10-27 | Guernsey | Ohio | 39059 | 6046 | 72 |
1854447 | 1854447 | 2021-10-26 | Guernsey | Ohio | 39059 | 5987 | 72 |
1851203 | 1851203 | 2021-10-25 | Henry | Ohio | 39069 | 3669 | 72 |
1847953 | 1847953 | 2021-10-24 | Henry | Ohio | 39069 | 3662 | 72 |
1844703 | 1844703 | 2021-10-23 | Henry | Ohio | 39069 | 3653 | 72 |
1841453 | 1841453 | 2021-10-22 | Henry | Ohio | 39069 | 3640 | 72 |
1838180 | 1838180 | 2021-10-21 | Champaign | Ohio | 39021 | 5103 | 72 |
1834931 | 1834931 | 2021-10-20 | Champaign | Ohio | 39021 | 5093 | 72 |
1831682 | 1831682 | 2021-10-19 | Champaign | Ohio | 39021 | 5063 | 72 |
1828427 | 1828427 | 2021-10-18 | Athens | Ohio | 39009 | 7695 | 72 |
1825178 | 1825178 | 2021-10-17 | Athens | Ohio | 39009 | 7680 | 72 |
1821929 | 1821929 | 2021-10-16 | Athens | Ohio | 39009 | 7670 | 72 |
1818680 | 1818680 | 2021-10-15 | Athens | Ohio | 39009 | 7653 | 72 |
1805712 | 1805712 | 2021-10-11 | Hardin | Ohio | 39065 | 3974 | 72 |
1802462 | 1802462 | 2021-10-10 | Hardin | Ohio | 39065 | 3963 | 72 |
1799213 | 1799213 | 2021-10-09 | Hardin | Ohio | 39065 | 3945 | 72 |
1795964 | 1795964 | 2021-10-08 | Hardin | Ohio | 39065 | 3924 | 72 |
1792719 | 1792719 | 2021-10-07 | Hocking | Ohio | 39073 | 3377 | 72 |
1789470 | 1789470 | 2021-10-06 | Hocking | Ohio | 39073 | 3360 | 72 |
1786222 | 1786222 | 2021-10-05 | Hocking | Ohio | 39073 | 3333 | 72 |
1782973 | 1782973 | 2021-10-04 | Hocking | Ohio | 39073 | 3293 | 72 |
1782985 | 1782985 | 2021-10-04 | Madison | Ohio | 39097 | 5648 | 72 |
1779724 | 1779724 | 2021-10-03 | Hocking | Ohio | 39073 | 3264 | 72 |
1779736 | 1779736 | 2021-10-03 | Madison | Ohio | 39097 | 5635 | 72 |
1776474 | 1776474 | 2021-10-02 | Hocking | Ohio | 39073 | 3256 | 72 |
1776486 | 1776486 | 2021-10-02 | Madison | Ohio | 39097 | 5630 | 72 |
1773224 | 1773224 | 2021-10-01 | Hocking | Ohio | 39073 | 3248 | 72 |
1773236 | 1773236 | 2021-10-01 | Madison | Ohio | 39097 | 5616 | 72 |
1769945 | 1769945 | 2021-09-30 | Brown | Ohio | 39015 | 5885 | 72 |
1770019 | 1770019 | 2021-09-30 | Van Wert | Ohio | 39161 | 3307 | 72 |
1766696 | 1766696 | 2021-09-29 | Brown | Ohio | 39015 | 5846 | 72 |
1766770 | 1766770 | 2021-09-29 | Van Wert | Ohio | 39161 | 3278 | 72 |
1763447 | 1763447 | 2021-09-28 | Brown | Ohio | 39015 | 5825 | 72 |
1763521 | 1763521 | 2021-09-28 | Van Wert | Ohio | 39161 | 3257 | 72 |
1760198 | 1760198 | 2021-09-27 | Brown | Ohio | 39015 | 5790 | 72 |
1756950 | 1756950 | 2021-09-26 | Brown | Ohio | 39015 | 5782 | 72 |
1753702 | 1753702 | 2021-09-25 | Brown | Ohio | 39015 | 5753 | 72 |
1750454 | 1750454 | 2021-09-24 | Brown | Ohio | 39015 | 5729 | 72 |
1701729 | 1701729 | 2021-09-09 | Clinton | Ohio | 39027 | 4870 | 72 |
1701751 | 1701751 | 2021-09-09 | Highland | Ohio | 39071 | 4867 | 72 |
1698480 | 1698480 | 2021-09-08 | Clinton | Ohio | 39027 | 4833 | 72 |
1698502 | 1698502 | 2021-09-08 | Highland | Ohio | 39071 | 4805 | 72 |
1695232 | 1695232 | 2021-09-07 | Clinton | Ohio | 39027 | 4784 | 72 |
1695254 | 1695254 | 2021-09-07 | Highland | Ohio | 39071 | 4740 | 72 |
1691984 | 1691984 | 2021-09-06 | Clinton | Ohio | 39027 | 4742 | 72 |
1688735 | 1688735 | 2021-09-05 | Clinton | Ohio | 39027 | 4728 | 72 |
1685485 | 1685485 | 2021-09-04 | Clinton | Ohio | 39027 | 4702 | 72 |
1682234 | 1682234 | 2021-09-03 | Clinton | Ohio | 39027 | 4665 | 72 |
1428951 | 1428951 | 2021-06-17 | Fulton | Ohio | 39051 | 4320 | 72 |
1425706 | 1425706 | 2021-06-16 | Fulton | Ohio | 39051 | 4319 | 72 |
1422459 | 1422459 | 2021-06-15 | Fulton | Ohio | 39051 | 4318 | 72 |
1088066 | 1088066 | 2021-03-04 | Logan | Ohio | 39091 | 3560 | 72 |
1084821 | 1084821 | 2021-03-03 | Logan | Ohio | 39091 | 3557 | 72 |
1081575 | 1081575 | 2021-03-02 | Logan | Ohio | 39091 | 3544 | 72 |
1019868 | 1019868 | 2021-02-11 | Auglaize | Ohio | 39011 | 4457 | 72 |
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);