ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
109 rows where deaths = 217 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 |
---|---|---|---|---|---|---|---|
2426743 | 2426743 | 2022-04-20 | Ashland | Ohio | 39005 | 11967 | 217 |
2423487 | 2423487 | 2022-04-19 | Ashland | Ohio | 39005 | 11967 | 217 |
2420230 | 2420230 | 2022-04-18 | Ashland | Ohio | 39005 | 11967 | 217 |
2416975 | 2416975 | 2022-04-17 | Ashland | Ohio | 39005 | 11967 | 217 |
2413719 | 2413719 | 2022-04-16 | Ashland | Ohio | 39005 | 11967 | 217 |
2410463 | 2410463 | 2022-04-15 | Ashland | Ohio | 39005 | 11967 | 217 |
2407207 | 2407207 | 2022-04-14 | Ashland | Ohio | 39005 | 11967 | 217 |
2403951 | 2403951 | 2022-04-13 | Ashland | Ohio | 39005 | 11959 | 217 |
2400696 | 2400696 | 2022-04-12 | Ashland | Ohio | 39005 | 11959 | 217 |
2397441 | 2397441 | 2022-04-11 | Ashland | Ohio | 39005 | 11959 | 217 |
2394186 | 2394186 | 2022-04-10 | Ashland | Ohio | 39005 | 11959 | 217 |
2390930 | 2390930 | 2022-04-09 | Ashland | Ohio | 39005 | 11959 | 217 |
2387674 | 2387674 | 2022-04-08 | Ashland | Ohio | 39005 | 11959 | 217 |
2384419 | 2384419 | 2022-04-07 | Ashland | Ohio | 39005 | 11959 | 217 |
2270627 | 2270627 | 2022-03-03 | Pickaway | Ohio | 39129 | 17410 | 217 |
2267375 | 2267375 | 2022-03-02 | Pickaway | Ohio | 39129 | 17399 | 217 |
2264122 | 2264122 | 2022-03-01 | Pickaway | Ohio | 39129 | 17396 | 217 |
2260846 | 2260846 | 2022-02-28 | Huron | Ohio | 39077 | 14382 | 217 |
2257595 | 2257595 | 2022-02-27 | Huron | Ohio | 39077 | 14379 | 217 |
2254344 | 2254344 | 2022-02-26 | Huron | Ohio | 39077 | 14371 | 217 |
2251093 | 2251093 | 2022-02-25 | Huron | Ohio | 39077 | 14370 | 217 |
2247842 | 2247842 | 2022-02-24 | Huron | Ohio | 39077 | 14364 | 217 |
2244591 | 2244591 | 2022-02-23 | Huron | Ohio | 39077 | 14360 | 217 |
2241340 | 2241340 | 2022-02-22 | Huron | Ohio | 39077 | 14348 | 217 |
2225088 | 2225088 | 2022-02-17 | Knox | Ohio | 39083 | 12984 | 217 |
2225118 | 2225118 | 2022-02-17 | Sandusky | Ohio | 39143 | 13793 | 217 |
2225120 | 2225120 | 2022-02-17 | Seneca | Ohio | 39147 | 12598 | 217 |
2221837 | 2221837 | 2022-02-16 | Knox | Ohio | 39083 | 12971 | 217 |
2221867 | 2221867 | 2022-02-16 | Sandusky | Ohio | 39143 | 13791 | 217 |
2221869 | 2221869 | 2022-02-16 | Seneca | Ohio | 39147 | 12594 | 217 |
2218586 | 2218586 | 2022-02-15 | Knox | Ohio | 39083 | 12952 | 217 |
2218616 | 2218616 | 2022-02-15 | Sandusky | Ohio | 39143 | 13782 | 217 |
2218618 | 2218618 | 2022-02-15 | Seneca | Ohio | 39147 | 12589 | 217 |
2215335 | 2215335 | 2022-02-14 | Knox | Ohio | 39083 | 12943 | 217 |
2215367 | 2215367 | 2022-02-14 | Seneca | Ohio | 39147 | 12582 | 217 |
2212084 | 2212084 | 2022-02-13 | Knox | Ohio | 39083 | 12939 | 217 |
2212116 | 2212116 | 2022-02-13 | Seneca | Ohio | 39147 | 12576 | 217 |
2208831 | 2208831 | 2022-02-12 | Knox | Ohio | 39083 | 12927 | 217 |
2208863 | 2208863 | 2022-02-12 | Seneca | Ohio | 39147 | 12567 | 217 |
2205578 | 2205578 | 2022-02-11 | Knox | Ohio | 39083 | 12917 | 217 |
2205610 | 2205610 | 2022-02-11 | Seneca | Ohio | 39147 | 12554 | 217 |
2169826 | 2169826 | 2022-01-31 | Scioto | Ohio | 39145 | 19232 | 217 |
2166571 | 2166571 | 2022-01-30 | Scioto | Ohio | 39145 | 19149 | 217 |
2163316 | 2163316 | 2022-01-29 | Scioto | Ohio | 39145 | 19061 | 217 |
2160061 | 2160061 | 2022-01-28 | Scioto | Ohio | 39145 | 18927 | 217 |
2078727 | 2078727 | 2022-01-03 | Marion | Ohio | 39101 | 15192 | 217 |
2075476 | 2075476 | 2022-01-02 | Marion | Ohio | 39101 | 15096 | 217 |
2072225 | 2072225 | 2022-01-01 | Marion | Ohio | 39101 | 14953 | 217 |
2068974 | 2068974 | 2021-12-31 | Marion | Ohio | 39101 | 14953 | 217 |
2065694 | 2065694 | 2021-12-30 | Erie | Ohio | 39043 | 14866 | 217 |
2062444 | 2062444 | 2021-12-29 | Erie | Ohio | 39043 | 14609 | 217 |
2059194 | 2059194 | 2021-12-28 | Erie | Ohio | 39043 | 14407 | 217 |
2055945 | 2055945 | 2021-12-27 | Erie | Ohio | 39043 | 14212 | 217 |
2052696 | 2052696 | 2021-12-26 | Erie | Ohio | 39043 | 14125 | 217 |
2049446 | 2049446 | 2021-12-25 | Erie | Ohio | 39043 | 13956 | 217 |
2046196 | 2046196 | 2021-12-24 | Erie | Ohio | 39043 | 13956 | 217 |
2020232 | 2020232 | 2021-12-16 | Muskingum | Ohio | 39119 | 17411 | 217 |
2016981 | 2016981 | 2021-12-15 | Muskingum | Ohio | 39119 | 17360 | 217 |
2013731 | 2013731 | 2021-12-14 | Muskingum | Ohio | 39119 | 17292 | 217 |
1919410 | 1919410 | 2021-11-15 | Ashtabula | Ohio | 39007 | 11166 | 217 |
1916160 | 1916160 | 2021-11-14 | Ashtabula | Ohio | 39007 | 11093 | 217 |
1912910 | 1912910 | 2021-11-13 | Ashtabula | Ohio | 39007 | 11006 | 217 |
1909660 | 1909660 | 2021-11-12 | Ashtabula | Ohio | 39007 | 10910 | 217 |
1815514 | 1815514 | 2021-10-14 | Wood | Ohio | 39173 | 17063 | 217 |
1812266 | 1812266 | 2021-10-13 | Wood | Ohio | 39173 | 17016 | 217 |
1809017 | 1809017 | 2021-10-12 | Wood | Ohio | 39173 | 16952 | 217 |
1714728 | 1714728 | 2021-09-13 | Fairfield | Ohio | 39045 | 19528 | 217 |
1711482 | 1711482 | 2021-09-12 | Fairfield | Ohio | 39045 | 19439 | 217 |
1708235 | 1708235 | 2021-09-11 | Fairfield | Ohio | 39045 | 19384 | 217 |
1704988 | 1704988 | 2021-09-10 | Fairfield | Ohio | 39045 | 19278 | 217 |
1542614 | 1542614 | 2021-07-22 | Portage | Ohio | 39133 | 13380 | 217 |
1539366 | 1539366 | 2021-07-21 | Portage | Ohio | 39133 | 13376 | 217 |
1536119 | 1536119 | 2021-07-20 | Portage | Ohio | 39133 | 13367 | 217 |
1532871 | 1532871 | 2021-07-19 | Portage | Ohio | 39133 | 13356 | 217 |
1529624 | 1529624 | 2021-07-18 | Portage | Ohio | 39133 | 13344 | 217 |
1526377 | 1526377 | 2021-07-17 | Portage | Ohio | 39133 | 13338 | 217 |
1523130 | 1523130 | 2021-07-16 | Portage | Ohio | 39133 | 13331 | 217 |
1519882 | 1519882 | 2021-07-15 | Portage | Ohio | 39133 | 13325 | 217 |
1516634 | 1516634 | 2021-07-14 | Portage | Ohio | 39133 | 13309 | 217 |
1513387 | 1513387 | 2021-07-13 | Portage | Ohio | 39133 | 13304 | 217 |
1383533 | 1383533 | 2021-06-03 | Licking | Ohio | 39089 | 16606 | 217 |
1380287 | 1380287 | 2021-06-02 | Licking | Ohio | 39089 | 16597 | 217 |
1360854 | 1360854 | 2021-05-27 | Wayne | Ohio | 39169 | 9042 | 217 |
1357608 | 1357608 | 2021-05-26 | Wayne | Ohio | 39169 | 9031 | 217 |
1354362 | 1354362 | 2021-05-25 | Wayne | Ohio | 39169 | 9017 | 217 |
1315368 | 1315368 | 2021-05-13 | Miami | Ohio | 39109 | 10701 | 217 |
1312122 | 1312122 | 2021-05-12 | Miami | Ohio | 39109 | 10696 | 217 |
1308875 | 1308875 | 2021-05-11 | Miami | Ohio | 39109 | 10686 | 217 |
1305629 | 1305629 | 2021-05-10 | Miami | Ohio | 39109 | 10675 | 217 |
1302383 | 1302383 | 2021-05-09 | Miami | Ohio | 39109 | 10674 | 217 |
1299135 | 1299135 | 2021-05-08 | Miami | Ohio | 39109 | 10670 | 217 |
1295889 | 1295889 | 2021-05-07 | Miami | Ohio | 39109 | 10661 | 217 |
1146471 | 1146471 | 2021-03-22 | Columbiana | Ohio | 39029 | 8291 | 217 |
1143224 | 1143224 | 2021-03-21 | Columbiana | Ohio | 39029 | 8288 | 217 |
1139977 | 1139977 | 2021-03-20 | Columbiana | Ohio | 39029 | 8283 | 217 |
1136731 | 1136731 | 2021-03-19 | Columbiana | Ohio | 39029 | 8279 | 217 |
1123731 | 1123731 | 2021-03-15 | Allen | Ohio | 39003 | 10868 | 217 |
1120485 | 1120485 | 2021-03-14 | Allen | Ohio | 39003 | 10866 | 217 |
1117238 | 1117238 | 2021-03-13 | Allen | Ohio | 39003 | 10862 | 217 |
1113991 | 1113991 | 2021-03-12 | Allen | Ohio | 39003 | 10862 | 217 |
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);