ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
134 rows where deaths = 117 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2358411 | 2358411 | 2022-03-30 | Fayette | Ohio | 39047 | 7765 | 117 |
2355157 | 2355157 | 2022-03-29 | Fayette | Ohio | 39047 | 7765 | 117 |
2351904 | 2351904 | 2022-03-28 | Fayette | Ohio | 39047 | 7765 | 117 |
2348652 | 2348652 | 2022-03-27 | Fayette | Ohio | 39047 | 7765 | 117 |
2345399 | 2345399 | 2022-03-26 | Fayette | Ohio | 39047 | 7765 | 117 |
2342146 | 2342146 | 2022-03-25 | Fayette | Ohio | 39047 | 7765 | 117 |
2338893 | 2338893 | 2022-03-24 | Fayette | Ohio | 39047 | 7765 | 117 |
2335652 | 2335652 | 2022-03-23 | Hocking | Ohio | 39073 | 6609 | 117 |
2332398 | 2332398 | 2022-03-22 | Hocking | Ohio | 39073 | 6609 | 117 |
2329145 | 2329145 | 2022-03-21 | Hocking | Ohio | 39073 | 6609 | 117 |
2325893 | 2325893 | 2022-03-20 | Hocking | Ohio | 39073 | 6609 | 117 |
2322640 | 2322640 | 2022-03-19 | Hocking | Ohio | 39073 | 6609 | 117 |
2319386 | 2319386 | 2022-03-18 | Hocking | Ohio | 39073 | 6609 | 117 |
2316132 | 2316132 | 2022-03-17 | Hocking | Ohio | 39073 | 6609 | 117 |
2312879 | 2312879 | 2022-03-16 | Hocking | Ohio | 39073 | 6590 | 117 |
2309626 | 2309626 | 2022-03-15 | Hocking | Ohio | 39073 | 6590 | 117 |
2306373 | 2306373 | 2022-03-14 | Hocking | Ohio | 39073 | 6590 | 117 |
2303122 | 2303122 | 2022-03-13 | Hocking | Ohio | 39073 | 6590 | 117 |
2299870 | 2299870 | 2022-03-12 | Hocking | Ohio | 39073 | 6589 | 117 |
2296618 | 2296618 | 2022-03-11 | Hocking | Ohio | 39073 | 6585 | 117 |
2192575 | 2192575 | 2022-02-07 | Mercer | Ohio | 39107 | 9488 | 117 |
2189321 | 2189321 | 2022-02-06 | Mercer | Ohio | 39107 | 9482 | 117 |
2186068 | 2186068 | 2022-02-05 | Mercer | Ohio | 39107 | 9478 | 117 |
2182816 | 2182816 | 2022-02-04 | Mercer | Ohio | 39107 | 9474 | 117 |
2156744 | 2156744 | 2022-01-27 | Champaign | Ohio | 39021 | 8229 | 117 |
2153491 | 2153491 | 2022-01-26 | Champaign | Ohio | 39021 | 8170 | 117 |
2150239 | 2150239 | 2022-01-25 | Champaign | Ohio | 39021 | 8056 | 117 |
2133987 | 2133987 | 2022-01-20 | Guernsey | Ohio | 39059 | 9423 | 117 |
2133997 | 2133997 | 2022-01-20 | Jackson | Ohio | 39079 | 7582 | 117 |
2130735 | 2130735 | 2022-01-19 | Guernsey | Ohio | 39059 | 9304 | 117 |
2130745 | 2130745 | 2022-01-19 | Jackson | Ohio | 39079 | 7510 | 117 |
2127481 | 2127481 | 2022-01-18 | Guernsey | Ohio | 39059 | 9179 | 117 |
2127491 | 2127491 | 2022-01-18 | Jackson | Ohio | 39079 | 7409 | 117 |
2010440 | 2010440 | 2021-12-13 | Defiance | Ohio | 39039 | 7618 | 117 |
2007189 | 2007189 | 2021-12-12 | Defiance | Ohio | 39039 | 7608 | 117 |
2003938 | 2003938 | 2021-12-11 | Defiance | Ohio | 39039 | 7586 | 117 |
2000687 | 2000687 | 2021-12-10 | Defiance | Ohio | 39039 | 7566 | 117 |
1997437 | 1997437 | 2021-12-09 | Defiance | Ohio | 39039 | 7544 | 117 |
1994186 | 1994186 | 2021-12-08 | Defiance | Ohio | 39039 | 7502 | 117 |
1990935 | 1990935 | 2021-12-07 | Defiance | Ohio | 39039 | 7471 | 117 |
1987684 | 1987684 | 2021-12-06 | Defiance | Ohio | 39039 | 7431 | 117 |
1984434 | 1984434 | 2021-12-05 | Defiance | Ohio | 39039 | 7418 | 117 |
1981184 | 1981184 | 2021-12-04 | Defiance | Ohio | 39039 | 7404 | 117 |
1977934 | 1977934 | 2021-12-03 | Defiance | Ohio | 39039 | 7358 | 117 |
1974670 | 1974670 | 2021-12-02 | Auglaize | Ohio | 39011 | 7897 | 117 |
1971421 | 1971421 | 2021-12-01 | Auglaize | Ohio | 39011 | 7846 | 117 |
1968171 | 1968171 | 2021-11-30 | Auglaize | Ohio | 39011 | 7794 | 117 |
1964950 | 1964950 | 2021-11-29 | Highland | Ohio | 39071 | 6615 | 117 |
1961698 | 1961698 | 2021-11-28 | Highland | Ohio | 39071 | 6608 | 117 |
1958447 | 1958447 | 2021-11-27 | Highland | Ohio | 39071 | 6591 | 117 |
1955196 | 1955196 | 2021-11-26 | Highland | Ohio | 39071 | 6578 | 117 |
1951945 | 1951945 | 2021-11-25 | Highland | Ohio | 39071 | 6552 | 117 |
1948694 | 1948694 | 2021-11-24 | Highland | Ohio | 39071 | 6552 | 117 |
1945443 | 1945443 | 2021-11-23 | Highland | Ohio | 39071 | 6527 | 117 |
1792750 | 1792750 | 2021-10-07 | Preble | Ohio | 39135 | 5462 | 117 |
1789501 | 1789501 | 2021-10-06 | Preble | Ohio | 39135 | 5412 | 117 |
1786253 | 1786253 | 2021-10-05 | Preble | Ohio | 39135 | 5375 | 117 |
1782939 | 1782939 | 2021-10-04 | Ashland | Ohio | 39005 | 6362 | 117 |
1779690 | 1779690 | 2021-10-03 | Ashland | Ohio | 39005 | 6321 | 117 |
1776440 | 1776440 | 2021-10-02 | Ashland | Ohio | 39005 | 6307 | 117 |
1773190 | 1773190 | 2021-10-01 | Ashland | Ohio | 39005 | 6270 | 117 |
1769940 | 1769940 | 2021-09-30 | Ashland | Ohio | 39005 | 6227 | 117 |
1766691 | 1766691 | 2021-09-29 | Ashland | Ohio | 39005 | 6189 | 117 |
1763442 | 1763442 | 2021-09-28 | Ashland | Ohio | 39005 | 6148 | 117 |
1760207 | 1760207 | 2021-09-27 | Crawford | Ohio | 39033 | 5603 | 117 |
1756959 | 1756959 | 2021-09-26 | Crawford | Ohio | 39033 | 5591 | 117 |
1753711 | 1753711 | 2021-09-25 | Crawford | Ohio | 39033 | 5563 | 117 |
1750463 | 1750463 | 2021-09-24 | Crawford | Ohio | 39033 | 5530 | 117 |
1692043 | 1692043 | 2021-09-06 | Scioto | Ohio | 39145 | 8759 | 117 |
1688794 | 1688794 | 2021-09-05 | Scioto | Ohio | 39145 | 8711 | 117 |
1685544 | 1685544 | 2021-09-04 | Scioto | Ohio | 39145 | 8639 | 117 |
1682293 | 1682293 | 2021-09-03 | Scioto | Ohio | 39145 | 8575 | 117 |
1679012 | 1679012 | 2021-09-02 | Knox | Ohio | 39083 | 5619 | 117 |
1675764 | 1675764 | 2021-09-01 | Knox | Ohio | 39083 | 5545 | 117 |
1672517 | 1672517 | 2021-08-31 | Knox | Ohio | 39083 | 5486 | 117 |
1269901 | 1269901 | 2021-04-29 | Huron | Ohio | 39077 | 5384 | 117 |
1266654 | 1266654 | 2021-04-28 | Huron | Ohio | 39077 | 5375 | 117 |
1263407 | 1263407 | 2021-04-27 | Huron | Ohio | 39077 | 5371 | 117 |
1201738 | 1201738 | 2021-04-08 | Sandusky | Ohio | 39143 | 5063 | 117 |
1198489 | 1198489 | 2021-04-07 | Sandusky | Ohio | 39143 | 5043 | 117 |
1195240 | 1195240 | 2021-04-06 | Sandusky | Ohio | 39143 | 5034 | 117 |
1191992 | 1191992 | 2021-04-05 | Sandusky | Ohio | 39143 | 5020 | 117 |
1188743 | 1188743 | 2021-04-04 | Sandusky | Ohio | 39143 | 5001 | 117 |
1185496 | 1185496 | 2021-04-03 | Sandusky | Ohio | 39143 | 5001 | 117 |
1182249 | 1182249 | 2021-04-02 | Sandusky | Ohio | 39143 | 4994 | 117 |
1179002 | 1179002 | 2021-04-01 | Sandusky | Ohio | 39143 | 4981 | 117 |
1175755 | 1175755 | 2021-03-31 | Sandusky | Ohio | 39143 | 4975 | 117 |
1172508 | 1172508 | 2021-03-30 | Sandusky | Ohio | 39143 | 4956 | 117 |
1169261 | 1169261 | 2021-03-29 | Sandusky | Ohio | 39143 | 4936 | 117 |
1166013 | 1166013 | 2021-03-28 | Sandusky | Ohio | 39143 | 4932 | 117 |
1162765 | 1162765 | 2021-03-27 | Sandusky | Ohio | 39143 | 4929 | 117 |
1159516 | 1159516 | 2021-03-26 | Sandusky | Ohio | 39143 | 4926 | 117 |
1133489 | 1133489 | 2021-03-18 | Darke | Ohio | 39037 | 5097 | 117 |
1130241 | 1130241 | 2021-03-17 | Darke | Ohio | 39037 | 5088 | 117 |
1126994 | 1126994 | 2021-03-16 | Darke | Ohio | 39037 | 5085 | 117 |
1101065 | 1101065 | 2021-03-08 | Muskingum | Ohio | 39119 | 8252 | 117 |
1097819 | 1097819 | 2021-03-07 | Muskingum | Ohio | 39119 | 8244 | 117 |
1094571 | 1094571 | 2021-03-06 | Muskingum | Ohio | 39119 | 8238 | 117 |
1091325 | 1091325 | 2021-03-05 | Muskingum | Ohio | 39119 | 8224 | 117 |
1075077 | 1075077 | 2021-02-28 | Huron | Ohio | 39077 | 4781 | 117 |
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);