ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
112 rows where deaths = 127 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501670 | 2501670 | 2022-05-13 | Gallia | Ohio | 39053 | 7565 | 127 |
2498412 | 2498412 | 2022-05-12 | Gallia | Ohio | 39053 | 7565 | 127 |
2247857 | 2247857 | 2022-02-24 | Mercer | Ohio | 39107 | 9635 | 127 |
2244606 | 2244606 | 2022-02-23 | Mercer | Ohio | 39107 | 9630 | 127 |
2241355 | 2241355 | 2022-02-22 | Mercer | Ohio | 39107 | 9622 | 127 |
2202323 | 2202323 | 2022-02-10 | Jackson | Ohio | 39079 | 8546 | 127 |
2199069 | 2199069 | 2022-02-09 | Jackson | Ohio | 39079 | 8521 | 127 |
2195815 | 2195815 | 2022-02-08 | Jackson | Ohio | 39079 | 8484 | 127 |
2192561 | 2192561 | 2022-02-07 | Jackson | Ohio | 39079 | 8456 | 127 |
2189307 | 2189307 | 2022-02-06 | Jackson | Ohio | 39079 | 8440 | 127 |
2186054 | 2186054 | 2022-02-05 | Jackson | Ohio | 39079 | 8423 | 127 |
2182802 | 2182802 | 2022-02-04 | Jackson | Ohio | 39079 | 8401 | 127 |
2179592 | 2179592 | 2022-02-03 | Van Wert | Ohio | 39161 | 6363 | 127 |
2176341 | 2176341 | 2022-02-02 | Van Wert | Ohio | 39161 | 6352 | 127 |
2173087 | 2173087 | 2022-02-01 | Van Wert | Ohio | 39161 | 6317 | 127 |
2169783 | 2169783 | 2022-01-31 | Guernsey | Ohio | 39059 | 10020 | 127 |
2166528 | 2166528 | 2022-01-30 | Guernsey | Ohio | 39059 | 10007 | 127 |
2163273 | 2163273 | 2022-01-29 | Guernsey | Ohio | 39059 | 9994 | 127 |
2160018 | 2160018 | 2022-01-28 | Guernsey | Ohio | 39059 | 9953 | 127 |
2146977 | 2146977 | 2022-01-24 | Adams | Ohio | 39001 | 6227 | 127 |
2143723 | 2143723 | 2022-01-23 | Adams | Ohio | 39001 | 6193 | 127 |
2140468 | 2140468 | 2022-01-22 | Adams | Ohio | 39001 | 6159 | 127 |
2137212 | 2137212 | 2022-01-21 | Adams | Ohio | 39001 | 6084 | 127 |
2133971 | 2133971 | 2022-01-20 | Clinton | Ohio | 39027 | 9087 | 127 |
2130719 | 2130719 | 2022-01-19 | Clinton | Ohio | 39027 | 8950 | 127 |
2127465 | 2127465 | 2022-01-18 | Clinton | Ohio | 39027 | 8810 | 127 |
2088518 | 2088518 | 2022-01-06 | Williams | Ohio | 39171 | 7293 | 127 |
2085267 | 2085267 | 2022-01-05 | Williams | Ohio | 39171 | 7265 | 127 |
2082015 | 2082015 | 2022-01-04 | Williams | Ohio | 39171 | 7201 | 127 |
2078763 | 2078763 | 2022-01-03 | Williams | Ohio | 39171 | 7152 | 127 |
2075512 | 2075512 | 2022-01-02 | Williams | Ohio | 39171 | 7146 | 127 |
2072261 | 2072261 | 2022-01-01 | Williams | Ohio | 39171 | 7119 | 127 |
2069010 | 2069010 | 2021-12-31 | Williams | Ohio | 39171 | 7119 | 127 |
2033183 | 2033183 | 2021-12-20 | Brown | Ohio | 39015 | 7695 | 127 |
2029933 | 2029933 | 2021-12-19 | Brown | Ohio | 39015 | 7677 | 127 |
2026682 | 2026682 | 2021-12-18 | Brown | Ohio | 39015 | 7663 | 127 |
2023431 | 2023431 | 2021-12-17 | Brown | Ohio | 39015 | 7629 | 127 |
1896696 | 1896696 | 2021-11-08 | Holmes | Ohio | 39075 | 3767 | 127 |
1893446 | 1893446 | 2021-11-07 | Holmes | Ohio | 39075 | 3762 | 127 |
1890196 | 1890196 | 2021-11-06 | Holmes | Ohio | 39075 | 3749 | 127 |
1886946 | 1886946 | 2021-11-05 | Holmes | Ohio | 39075 | 3749 | 127 |
1815443 | 1815443 | 2021-10-14 | Crawford | Ohio | 39033 | 6128 | 127 |
1812195 | 1812195 | 2021-10-13 | Crawford | Ohio | 39033 | 6099 | 127 |
1808946 | 1808946 | 2021-10-12 | Crawford | Ohio | 39033 | 6067 | 127 |
1805696 | 1805696 | 2021-10-11 | Crawford | Ohio | 39033 | 6045 | 127 |
1802446 | 1802446 | 2021-10-10 | Crawford | Ohio | 39033 | 6035 | 127 |
1799197 | 1799197 | 2021-10-09 | Crawford | Ohio | 39033 | 6010 | 127 |
1795948 | 1795948 | 2021-10-08 | Crawford | Ohio | 39033 | 5992 | 127 |
1770022 | 1770022 | 2021-09-30 | Washington | Ohio | 39167 | 7615 | 127 |
1766773 | 1766773 | 2021-09-29 | Washington | Ohio | 39167 | 7561 | 127 |
1763524 | 1763524 | 2021-09-28 | Washington | Ohio | 39167 | 7513 | 127 |
1760263 | 1760263 | 2021-09-27 | Scioto | Ohio | 39145 | 10618 | 127 |
1757015 | 1757015 | 2021-09-26 | Scioto | Ohio | 39145 | 10585 | 127 |
1753767 | 1753767 | 2021-09-25 | Scioto | Ohio | 39145 | 10531 | 127 |
1750519 | 1750519 | 2021-09-24 | Scioto | Ohio | 39145 | 10477 | 127 |
1747269 | 1747269 | 2021-09-23 | Scioto | Ohio | 39145 | 10394 | 127 |
1744020 | 1744020 | 2021-09-22 | Scioto | Ohio | 39145 | 10324 | 127 |
1740771 | 1740771 | 2021-09-21 | Scioto | Ohio | 39145 | 10235 | 127 |
1737488 | 1737488 | 2021-09-20 | Huron | Ohio | 39077 | 7309 | 127 |
1734238 | 1734238 | 2021-09-19 | Huron | Ohio | 39077 | 7279 | 127 |
1730988 | 1730988 | 2021-09-18 | Huron | Ohio | 39077 | 7253 | 127 |
1727738 | 1727738 | 2021-09-17 | Huron | Ohio | 39077 | 7210 | 127 |
1315345 | 1315345 | 2021-05-13 | Hancock | Ohio | 39063 | 6930 | 127 |
1312099 | 1312099 | 2021-05-12 | Hancock | Ohio | 39063 | 6932 | 127 |
1308852 | 1308852 | 2021-05-11 | Hancock | Ohio | 39063 | 6929 | 127 |
1305606 | 1305606 | 2021-05-10 | Hancock | Ohio | 39063 | 6920 | 127 |
1302360 | 1302360 | 2021-05-09 | Hancock | Ohio | 39063 | 6916 | 127 |
1299112 | 1299112 | 2021-05-08 | Hancock | Ohio | 39063 | 6914 | 127 |
1295866 | 1295866 | 2021-05-07 | Hancock | Ohio | 39063 | 6906 | 127 |
1247193 | 1247193 | 2021-04-22 | Muskingum | Ohio | 39119 | 8734 | 127 |
1243946 | 1243946 | 2021-04-21 | Muskingum | Ohio | 39119 | 8729 | 127 |
1240699 | 1240699 | 2021-04-20 | Muskingum | Ohio | 39119 | 8721 | 127 |
1237452 | 1237452 | 2021-04-19 | Muskingum | Ohio | 39119 | 8717 | 127 |
1234205 | 1234205 | 2021-04-18 | Muskingum | Ohio | 39119 | 8710 | 127 |
1230957 | 1230957 | 2021-04-17 | Muskingum | Ohio | 39119 | 8706 | 127 |
1227709 | 1227709 | 2021-04-16 | Muskingum | Ohio | 39119 | 8702 | 127 |
1224461 | 1224461 | 2021-04-15 | Muskingum | Ohio | 39119 | 8688 | 127 |
1221214 | 1221214 | 2021-04-14 | Muskingum | Ohio | 39119 | 8676 | 127 |
1217966 | 1217966 | 2021-04-13 | Muskingum | Ohio | 39119 | 8665 | 127 |
1214718 | 1214718 | 2021-04-12 | Muskingum | Ohio | 39119 | 8656 | 127 |
1211471 | 1211471 | 2021-04-11 | Muskingum | Ohio | 39119 | 8653 | 127 |
1208222 | 1208222 | 2021-04-10 | Muskingum | Ohio | 39119 | 8639 | 127 |
1204974 | 1204974 | 2021-04-09 | Muskingum | Ohio | 39119 | 8626 | 127 |
1201726 | 1201726 | 2021-04-08 | Muskingum | Ohio | 39119 | 8610 | 127 |
1198477 | 1198477 | 2021-04-07 | Muskingum | Ohio | 39119 | 8590 | 127 |
1195228 | 1195228 | 2021-04-06 | Muskingum | Ohio | 39119 | 8568 | 127 |
1101056 | 1101056 | 2021-03-08 | Marion | Ohio | 39101 | 8027 | 127 |
1097810 | 1097810 | 2021-03-07 | Marion | Ohio | 39101 | 8021 | 127 |
1094562 | 1094562 | 2021-03-06 | Marion | Ohio | 39101 | 8020 | 127 |
1091316 | 1091316 | 2021-03-05 | Marion | Ohio | 39101 | 8015 | 127 |
1065361 | 1065361 | 2021-02-25 | Muskingum | Ohio | 39119 | 8068 | 127 |
1016630 | 1016630 | 2021-02-10 | Clermont | Ohio | 39025 | 17503 | 127 |
1016672 | 1016672 | 2021-02-10 | Miami | Ohio | 39109 | 9741 | 127 |
1013385 | 1013385 | 2021-02-09 | Clermont | Ohio | 39025 | 17446 | 127 |
964688 | 964688 | 2021-01-25 | Allen | Ohio | 39003 | 9988 | 127 |
954972 | 954972 | 2021-01-22 | Erie | Ohio | 39043 | 6113 | 127 |
951727 | 951727 | 2021-01-21 | Erie | Ohio | 39043 | 6090 | 127 |
925787 | 925787 | 2021-01-13 | Licking | Ohio | 39089 | 12202 | 127 |
922541 | 922541 | 2021-01-12 | Licking | Ohio | 39089 | 12109 | 127 |
919280 | 919280 | 2021-01-11 | Greene | Ohio | 39057 | 10930 | 127 |
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);