ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
108 rows where deaths = 149 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 |
---|---|---|---|---|---|---|---|
2293359 | 2293359 | 2022-03-10 | Guernsey | Ohio | 39059 | 10415 | 149 |
2290107 | 2290107 | 2022-03-09 | Guernsey | Ohio | 39059 | 10411 | 149 |
2286855 | 2286855 | 2022-03-08 | Guernsey | Ohio | 39059 | 10410 | 149 |
2283606 | 2283606 | 2022-03-07 | Hardin | Ohio | 39065 | 7046 | 149 |
2280354 | 2280354 | 2022-03-06 | Hardin | Ohio | 39065 | 7046 | 149 |
2277101 | 2277101 | 2022-03-05 | Hardin | Ohio | 39065 | 7045 | 149 |
2273848 | 2273848 | 2022-03-04 | Hardin | Ohio | 39065 | 7043 | 149 |
2238064 | 2238064 | 2022-02-21 | Clinton | Ohio | 39027 | 10227 | 149 |
2234813 | 2234813 | 2022-02-20 | Clinton | Ohio | 39027 | 10221 | 149 |
2231562 | 2231562 | 2022-02-19 | Clinton | Ohio | 39027 | 10218 | 149 |
2228311 | 2228311 | 2022-02-18 | Clinton | Ohio | 39027 | 10205 | 149 |
2225060 | 2225060 | 2022-02-17 | Clinton | Ohio | 39027 | 10191 | 149 |
2221809 | 2221809 | 2022-02-16 | Clinton | Ohio | 39027 | 10183 | 149 |
2218558 | 2218558 | 2022-02-15 | Clinton | Ohio | 39027 | 10171 | 149 |
2215307 | 2215307 | 2022-02-14 | Clinton | Ohio | 39027 | 10159 | 149 |
2212056 | 2212056 | 2022-02-13 | Clinton | Ohio | 39027 | 10152 | 149 |
2208803 | 2208803 | 2022-02-12 | Clinton | Ohio | 39027 | 10152 | 149 |
2205550 | 2205550 | 2022-02-11 | Clinton | Ohio | 39027 | 10148 | 149 |
2179518 | 2179518 | 2022-02-03 | Brown | Ohio | 39015 | 10816 | 149 |
2179597 | 2179597 | 2022-02-03 | Williams | Ohio | 39171 | 8730 | 149 |
2176267 | 2176267 | 2022-02-02 | Brown | Ohio | 39015 | 10767 | 149 |
2176346 | 2176346 | 2022-02-02 | Williams | Ohio | 39171 | 8719 | 149 |
2173013 | 2173013 | 2022-02-01 | Brown | Ohio | 39015 | 10684 | 149 |
2173092 | 2173092 | 2022-02-01 | Williams | Ohio | 39171 | 8682 | 149 |
2169761 | 2169761 | 2022-01-31 | Brown | Ohio | 39015 | 10632 | 149 |
2166506 | 2166506 | 2022-01-30 | Brown | Ohio | 39015 | 10608 | 149 |
2163251 | 2163251 | 2022-01-29 | Brown | Ohio | 39015 | 10580 | 149 |
2159996 | 2159996 | 2022-01-28 | Brown | Ohio | 39015 | 10520 | 149 |
2156739 | 2156739 | 2022-01-27 | Auglaize | Ohio | 39011 | 11053 | 149 |
2156779 | 2156779 | 2022-01-27 | Logan | Ohio | 39091 | 9678 | 149 |
2153486 | 2153486 | 2022-01-26 | Auglaize | Ohio | 39011 | 11006 | 149 |
2153526 | 2153526 | 2022-01-26 | Logan | Ohio | 39091 | 9608 | 149 |
2150234 | 2150234 | 2022-01-25 | Auglaize | Ohio | 39011 | 10915 | 149 |
2150274 | 2150274 | 2022-01-25 | Logan | Ohio | 39091 | 9502 | 149 |
1974667 | 1974667 | 2021-12-02 | Ashland | Ohio | 39005 | 7956 | 149 |
1971418 | 1971418 | 2021-12-01 | Ashland | Ohio | 39005 | 7917 | 149 |
1968168 | 1968168 | 2021-11-30 | Ashland | Ohio | 39005 | 7873 | 149 |
1951974 | 1951974 | 2021-11-25 | Pickaway | Ohio | 39129 | 11947 | 149 |
1948723 | 1948723 | 2021-11-24 | Pickaway | Ohio | 39129 | 11947 | 149 |
1945472 | 1945472 | 2021-11-23 | Pickaway | Ohio | 39129 | 11912 | 149 |
1942221 | 1942221 | 2021-11-22 | Pickaway | Ohio | 39129 | 11887 | 149 |
1938971 | 1938971 | 2021-11-21 | Pickaway | Ohio | 39129 | 11859 | 149 |
1935721 | 1935721 | 2021-11-20 | Pickaway | Ohio | 39129 | 11853 | 149 |
1932471 | 1932471 | 2021-11-19 | Pickaway | Ohio | 39129 | 11830 | 149 |
1929220 | 1929220 | 2021-11-18 | Pickaway | Ohio | 39129 | 11819 | 149 |
1925970 | 1925970 | 2021-11-17 | Pickaway | Ohio | 39129 | 11790 | 149 |
1922720 | 1922720 | 2021-11-16 | Pickaway | Ohio | 39129 | 11763 | 149 |
1919471 | 1919471 | 2021-11-15 | Pickaway | Ohio | 39129 | 11742 | 149 |
1916221 | 1916221 | 2021-11-14 | Pickaway | Ohio | 39129 | 11726 | 149 |
1912971 | 1912971 | 2021-11-13 | Pickaway | Ohio | 39129 | 11707 | 149 |
1909721 | 1909721 | 2021-11-12 | Pickaway | Ohio | 39129 | 11686 | 149 |
1906446 | 1906446 | 2021-11-11 | Huron | Ohio | 39077 | 8973 | 149 |
1906472 | 1906472 | 2021-11-11 | Pickaway | Ohio | 39129 | 11662 | 149 |
1903197 | 1903197 | 2021-11-10 | Huron | Ohio | 39077 | 8934 | 149 |
1903223 | 1903223 | 2021-11-10 | Pickaway | Ohio | 39129 | 11645 | 149 |
1899947 | 1899947 | 2021-11-09 | Huron | Ohio | 39077 | 8888 | 149 |
1899973 | 1899973 | 2021-11-09 | Pickaway | Ohio | 39129 | 11627 | 149 |
1883732 | 1883732 | 2021-11-04 | Seneca | Ohio | 39147 | 7757 | 149 |
1880483 | 1880483 | 2021-11-03 | Seneca | Ohio | 39147 | 7712 | 149 |
1877234 | 1877234 | 2021-11-02 | Seneca | Ohio | 39147 | 7666 | 149 |
1828454 | 1828454 | 2021-10-18 | Hancock | Ohio | 39063 | 9546 | 149 |
1825205 | 1825205 | 2021-10-17 | Hancock | Ohio | 39063 | 9525 | 149 |
1821956 | 1821956 | 2021-10-16 | Hancock | Ohio | 39063 | 9504 | 149 |
1818707 | 1818707 | 2021-10-15 | Hancock | Ohio | 39063 | 9476 | 149 |
1815458 | 1815458 | 2021-10-14 | Hancock | Ohio | 39063 | 9435 | 149 |
1815499 | 1815499 | 2021-10-14 | Scioto | Ohio | 39145 | 11297 | 149 |
1812210 | 1812210 | 2021-10-13 | Hancock | Ohio | 39063 | 9381 | 149 |
1812251 | 1812251 | 2021-10-13 | Scioto | Ohio | 39145 | 11271 | 149 |
1808961 | 1808961 | 2021-10-12 | Hancock | Ohio | 39063 | 9325 | 149 |
1809002 | 1809002 | 2021-10-12 | Scioto | Ohio | 39145 | 11229 | 149 |
1737509 | 1737509 | 2021-09-20 | Muskingum | Ohio | 39119 | 12377 | 149 |
1734259 | 1734259 | 2021-09-19 | Muskingum | Ohio | 39119 | 12324 | 149 |
1731009 | 1731009 | 2021-09-18 | Muskingum | Ohio | 39119 | 12261 | 149 |
1727759 | 1727759 | 2021-09-17 | Muskingum | Ohio | 39119 | 12115 | 149 |
1377025 | 1377025 | 2021-06-01 | Geauga | Ohio | 39055 | 6816 | 149 |
1373779 | 1373779 | 2021-05-31 | Geauga | Ohio | 39055 | 6812 | 149 |
1370534 | 1370534 | 2021-05-30 | Geauga | Ohio | 39055 | 6812 | 149 |
1367288 | 1367288 | 2021-05-29 | Geauga | Ohio | 39055 | 6809 | 149 |
1364042 | 1364042 | 2021-05-28 | Geauga | Ohio | 39055 | 6805 | 149 |
1360796 | 1360796 | 2021-05-27 | Geauga | Ohio | 39055 | 6799 | 149 |
1357550 | 1357550 | 2021-05-26 | Geauga | Ohio | 39055 | 6799 | 149 |
1354304 | 1354304 | 2021-05-25 | Geauga | Ohio | 39055 | 6790 | 149 |
1351058 | 1351058 | 2021-05-24 | Geauga | Ohio | 39055 | 6788 | 149 |
1347812 | 1347812 | 2021-05-23 | Geauga | Ohio | 39055 | 6778 | 149 |
1344564 | 1344564 | 2021-05-22 | Geauga | Ohio | 39055 | 6772 | 149 |
1341316 | 1341316 | 2021-05-21 | Geauga | Ohio | 39055 | 6768 | 149 |
1338068 | 1338068 | 2021-05-20 | Geauga | Ohio | 39055 | 6762 | 149 |
1334821 | 1334821 | 2021-05-19 | Geauga | Ohio | 39055 | 6754 | 149 |
1331574 | 1331574 | 2021-05-18 | Geauga | Ohio | 39055 | 6746 | 149 |
1247174 | 1247174 | 2021-04-22 | Jefferson | Ohio | 39081 | 5389 | 149 |
1243927 | 1243927 | 2021-04-21 | Jefferson | Ohio | 39081 | 5372 | 149 |
1240680 | 1240680 | 2021-04-20 | Jefferson | Ohio | 39081 | 5360 | 149 |
1032868 | 1032868 | 2021-02-15 | Fairfield | Ohio | 39045 | 14137 | 149 |
1029622 | 1029622 | 2021-02-14 | Fairfield | Ohio | 39045 | 14118 | 149 |
1026375 | 1026375 | 2021-02-13 | Fairfield | Ohio | 39045 | 14080 | 149 |
987488 | 987488 | 2021-02-01 | Warren | Ohio | 39165 | 20618 | 149 |
984241 | 984241 | 2021-01-31 | Warren | Ohio | 39165 | 20531 | 149 |
980994 | 980994 | 2021-01-30 | Warren | Ohio | 39165 | 20444 | 149 |
977748 | 977748 | 2021-01-29 | Warren | Ohio | 39165 | 20356 | 149 |
903112 | 903112 | 2021-01-06 | Wood | Ohio | 39173 | 8923 | 149 |
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);