ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
240 rows where deaths = 79 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 |
---|---|---|---|---|---|---|---|
2312898 | 2312898 | 2022-03-16 | Monroe | Ohio | 39111 | 3450 | 79 |
2309645 | 2309645 | 2022-03-15 | Monroe | Ohio | 39111 | 3450 | 79 |
2306392 | 2306392 | 2022-03-14 | Monroe | Ohio | 39111 | 3450 | 79 |
2303141 | 2303141 | 2022-03-13 | Monroe | Ohio | 39111 | 3450 | 79 |
2299889 | 2299889 | 2022-03-12 | Monroe | Ohio | 39111 | 3450 | 79 |
2296637 | 2296637 | 2022-03-11 | Monroe | Ohio | 39111 | 3450 | 79 |
2293385 | 2293385 | 2022-03-10 | Monroe | Ohio | 39111 | 3447 | 79 |
2290133 | 2290133 | 2022-03-09 | Monroe | Ohio | 39111 | 3444 | 79 |
2286881 | 2286881 | 2022-03-08 | Monroe | Ohio | 39111 | 3440 | 79 |
2270615 | 2270615 | 2022-03-03 | Meigs | Ohio | 39105 | 4563 | 79 |
2267363 | 2267363 | 2022-03-02 | Meigs | Ohio | 39105 | 4553 | 79 |
2264110 | 2264110 | 2022-03-01 | Meigs | Ohio | 39105 | 4547 | 79 |
2260860 | 2260860 | 2022-02-28 | Meigs | Ohio | 39105 | 4544 | 79 |
2257609 | 2257609 | 2022-02-27 | Meigs | Ohio | 39105 | 4539 | 79 |
2254358 | 2254358 | 2022-02-26 | Meigs | Ohio | 39105 | 4534 | 79 |
2251107 | 2251107 | 2022-02-25 | Meigs | Ohio | 39105 | 4526 | 79 |
2247856 | 2247856 | 2022-02-24 | Meigs | Ohio | 39105 | 4513 | 79 |
2244605 | 2244605 | 2022-02-23 | Meigs | Ohio | 39105 | 4505 | 79 |
2241354 | 2241354 | 2022-02-22 | Meigs | Ohio | 39105 | 4500 | 79 |
2065752 | 2065752 | 2021-12-30 | Union | Ohio | 39159 | 10733 | 79 |
2062502 | 2062502 | 2021-12-29 | Union | Ohio | 39159 | 10642 | 79 |
2059252 | 2059252 | 2021-12-28 | Union | Ohio | 39159 | 10549 | 79 |
2056003 | 2056003 | 2021-12-27 | Union | Ohio | 39159 | 10441 | 79 |
2052754 | 2052754 | 2021-12-26 | Union | Ohio | 39159 | 10403 | 79 |
2049504 | 2049504 | 2021-12-25 | Union | Ohio | 39159 | 10358 | 79 |
2046254 | 2046254 | 2021-12-24 | Union | Ohio | 39159 | 10358 | 79 |
2033241 | 2033241 | 2021-12-20 | Pike | Ohio | 39131 | 4891 | 79 |
2033264 | 2033264 | 2021-12-20 | Wyandot | Ohio | 39175 | 4032 | 79 |
2029991 | 2029991 | 2021-12-19 | Pike | Ohio | 39131 | 4876 | 79 |
2030014 | 2030014 | 2021-12-19 | Wyandot | Ohio | 39175 | 4027 | 79 |
2026740 | 2026740 | 2021-12-18 | Pike | Ohio | 39131 | 4851 | 79 |
2026763 | 2026763 | 2021-12-18 | Wyandot | Ohio | 39175 | 4020 | 79 |
2023489 | 2023489 | 2021-12-17 | Pike | Ohio | 39131 | 4842 | 79 |
2023512 | 2023512 | 2021-12-17 | Wyandot | Ohio | 39175 | 4004 | 79 |
2020199 | 2020199 | 2021-12-16 | Gallia | Ohio | 39053 | 4950 | 79 |
2020238 | 2020238 | 2021-12-16 | Pike | Ohio | 39131 | 4821 | 79 |
2016948 | 2016948 | 2021-12-15 | Gallia | Ohio | 39053 | 4917 | 79 |
2016987 | 2016987 | 2021-12-15 | Pike | Ohio | 39131 | 4798 | 79 |
2013698 | 2013698 | 2021-12-14 | Gallia | Ohio | 39053 | 4898 | 79 |
2013737 | 2013737 | 2021-12-14 | Pike | Ohio | 39131 | 4790 | 79 |
2010447 | 2010447 | 2021-12-13 | Gallia | Ohio | 39053 | 4875 | 79 |
2007196 | 2007196 | 2021-12-12 | Gallia | Ohio | 39053 | 4863 | 79 |
2003945 | 2003945 | 2021-12-11 | Gallia | Ohio | 39053 | 4853 | 79 |
2000694 | 2000694 | 2021-12-10 | Gallia | Ohio | 39053 | 4833 | 79 |
1997444 | 1997444 | 2021-12-09 | Gallia | Ohio | 39053 | 4812 | 79 |
1994193 | 1994193 | 2021-12-08 | Gallia | Ohio | 39053 | 4802 | 79 |
1990942 | 1990942 | 2021-12-07 | Gallia | Ohio | 39053 | 4769 | 79 |
1987728 | 1987728 | 2021-12-06 | Perry | Ohio | 39127 | 5712 | 79 |
1984478 | 1984478 | 2021-12-05 | Perry | Ohio | 39127 | 5705 | 79 |
1981228 | 1981228 | 2021-12-04 | Perry | Ohio | 39127 | 5684 | 79 |
1977978 | 1977978 | 2021-12-03 | Perry | Ohio | 39127 | 5667 | 79 |
1974728 | 1974728 | 2021-12-02 | Perry | Ohio | 39127 | 5649 | 79 |
1971479 | 1971479 | 2021-12-01 | Perry | Ohio | 39127 | 5630 | 79 |
1968229 | 1968229 | 2021-11-30 | Perry | Ohio | 39127 | 5611 | 79 |
1964978 | 1964978 | 2021-11-29 | Perry | Ohio | 39127 | 5588 | 79 |
1961726 | 1961726 | 2021-11-28 | Perry | Ohio | 39127 | 5584 | 79 |
1958475 | 1958475 | 2021-11-27 | Perry | Ohio | 39127 | 5571 | 79 |
1955224 | 1955224 | 2021-11-26 | Perry | Ohio | 39127 | 5557 | 79 |
1951973 | 1951973 | 2021-11-25 | Perry | Ohio | 39127 | 5536 | 79 |
1948722 | 1948722 | 2021-11-24 | Perry | Ohio | 39127 | 5536 | 79 |
1945471 | 1945471 | 2021-11-23 | Perry | Ohio | 39127 | 5518 | 79 |
1942220 | 1942220 | 2021-11-22 | Perry | Ohio | 39127 | 5502 | 79 |
1938970 | 1938970 | 2021-11-21 | Perry | Ohio | 39127 | 5495 | 79 |
1935720 | 1935720 | 2021-11-20 | Perry | Ohio | 39127 | 5486 | 79 |
1932470 | 1932470 | 2021-11-19 | Perry | Ohio | 39127 | 5467 | 79 |
1919436 | 1919436 | 2021-11-15 | Guernsey | Ohio | 39059 | 6490 | 79 |
1916186 | 1916186 | 2021-11-14 | Guernsey | Ohio | 39059 | 6481 | 79 |
1912936 | 1912936 | 2021-11-13 | Guernsey | Ohio | 39059 | 6462 | 79 |
1909686 | 1909686 | 2021-11-12 | Guernsey | Ohio | 39059 | 6432 | 79 |
1883698 | 1883698 | 2021-11-04 | Jackson | Ohio | 39079 | 5304 | 79 |
1880449 | 1880449 | 2021-11-03 | Jackson | Ohio | 39079 | 5285 | 79 |
1877200 | 1877200 | 2021-11-02 | Jackson | Ohio | 39079 | 5265 | 79 |
1851173 | 1851173 | 2021-10-25 | Athens | Ohio | 39009 | 7795 | 79 |
1847923 | 1847923 | 2021-10-24 | Athens | Ohio | 39009 | 7792 | 79 |
1844673 | 1844673 | 2021-10-23 | Athens | Ohio | 39009 | 7777 | 79 |
1841423 | 1841423 | 2021-10-22 | Athens | Ohio | 39009 | 7761 | 79 |
1838206 | 1838206 | 2021-10-21 | Hocking | Ohio | 39073 | 3555 | 79 |
1838251 | 1838251 | 2021-10-21 | Van Wert | Ohio | 39161 | 3695 | 79 |
1834957 | 1834957 | 2021-10-20 | Hocking | Ohio | 39073 | 3543 | 79 |
1835002 | 1835002 | 2021-10-20 | Van Wert | Ohio | 39161 | 3682 | 79 |
1831708 | 1831708 | 2021-10-19 | Hocking | Ohio | 39073 | 3532 | 79 |
1831753 | 1831753 | 2021-10-19 | Van Wert | Ohio | 39161 | 3666 | 79 |
1815442 | 1815442 | 2021-10-14 | Coshocton | Ohio | 39031 | 4604 | 79 |
1812194 | 1812194 | 2021-10-13 | Coshocton | Ohio | 39031 | 4563 | 79 |
1808945 | 1808945 | 2021-10-12 | Coshocton | Ohio | 39031 | 4535 | 79 |
1805687 | 1805687 | 2021-10-11 | Brown | Ohio | 39015 | 6172 | 79 |
1802437 | 1802437 | 2021-10-10 | Brown | Ohio | 39015 | 6165 | 79 |
1799188 | 1799188 | 2021-10-09 | Brown | Ohio | 39015 | 6137 | 79 |
1795939 | 1795939 | 2021-10-08 | Brown | Ohio | 39015 | 6115 | 79 |
1724464 | 1724464 | 2021-09-16 | Clinton | Ohio | 39027 | 5089 | 79 |
1721215 | 1721215 | 2021-09-15 | Clinton | Ohio | 39027 | 5053 | 79 |
1717967 | 1717967 | 2021-09-14 | Clinton | Ohio | 39027 | 5025 | 79 |
1692016 | 1692016 | 2021-09-06 | Logan | Ohio | 39091 | 4660 | 79 |
1688767 | 1688767 | 2021-09-05 | Logan | Ohio | 39091 | 4633 | 79 |
1685517 | 1685517 | 2021-09-04 | Logan | Ohio | 39091 | 4606 | 79 |
1682266 | 1682266 | 2021-09-03 | Logan | Ohio | 39091 | 4573 | 79 |
1678996 | 1678996 | 2021-09-02 | Fulton | Ohio | 39051 | 4775 | 79 |
1679016 | 1679016 | 2021-09-02 | Logan | Ohio | 39091 | 4539 | 79 |
1675748 | 1675748 | 2021-09-01 | Fulton | Ohio | 39051 | 4751 | 79 |
1675768 | 1675768 | 2021-09-01 | Logan | Ohio | 39091 | 4500 | 79 |
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);