ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where deaths = 247 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2449576 | 2449576 | 2022-04-27 | Lawrence | Ohio | 39087 | 17895 | 247 |
2446319 | 2446319 | 2022-04-26 | Lawrence | Ohio | 39087 | 17895 | 247 |
2443064 | 2443064 | 2022-04-25 | Lawrence | Ohio | 39087 | 17895 | 247 |
2439808 | 2439808 | 2022-04-24 | Lawrence | Ohio | 39087 | 17895 | 247 |
2436552 | 2436552 | 2022-04-23 | Lawrence | Ohio | 39087 | 17895 | 247 |
2433296 | 2433296 | 2022-04-22 | Lawrence | Ohio | 39087 | 17895 | 247 |
2430040 | 2430040 | 2022-04-21 | Lawrence | Ohio | 39087 | 17895 | 247 |
2426784 | 2426784 | 2022-04-20 | Lawrence | Ohio | 39087 | 17867 | 247 |
2423528 | 2423528 | 2022-04-19 | Lawrence | Ohio | 39087 | 17867 | 247 |
2420271 | 2420271 | 2022-04-18 | Lawrence | Ohio | 39087 | 17867 | 247 |
2417016 | 2417016 | 2022-04-17 | Lawrence | Ohio | 39087 | 17867 | 247 |
2413760 | 2413760 | 2022-04-16 | Lawrence | Ohio | 39087 | 17867 | 247 |
2410504 | 2410504 | 2022-04-15 | Lawrence | Ohio | 39087 | 17867 | 247 |
2407248 | 2407248 | 2022-04-14 | Lawrence | Ohio | 39087 | 17867 | 247 |
2215344 | 2215344 | 2022-02-14 | Marion | Ohio | 39101 | 19546 | 247 |
2212093 | 2212093 | 2022-02-13 | Marion | Ohio | 39101 | 19532 | 247 |
2208840 | 2208840 | 2022-02-12 | Marion | Ohio | 39101 | 19525 | 247 |
2205587 | 2205587 | 2022-02-11 | Marion | Ohio | 39101 | 19505 | 247 |
2192549 | 2192549 | 2022-02-07 | Geauga | Ohio | 39055 | 15755 | 247 |
2189295 | 2189295 | 2022-02-06 | Geauga | Ohio | 39055 | 15746 | 247 |
2186042 | 2186042 | 2022-02-05 | Geauga | Ohio | 39055 | 15741 | 247 |
2182790 | 2182790 | 2022-02-04 | Geauga | Ohio | 39055 | 15731 | 247 |
2133964 | 2133964 | 2022-01-20 | Belmont | Ohio | 39013 | 13767 | 247 |
2130712 | 2130712 | 2022-01-19 | Belmont | Ohio | 39013 | 13554 | 247 |
2127458 | 2127458 | 2022-01-18 | Belmont | Ohio | 39013 | 13369 | 247 |
2124206 | 2124206 | 2022-01-17 | Belmont | Ohio | 39013 | 13255 | 247 |
2120954 | 2120954 | 2022-01-16 | Belmont | Ohio | 39013 | 13174 | 247 |
2117702 | 2117702 | 2022-01-15 | Belmont | Ohio | 39013 | 13084 | 247 |
2114451 | 2114451 | 2022-01-14 | Belmont | Ohio | 39013 | 12939 | 247 |
2111199 | 2111199 | 2022-01-13 | Belmont | Ohio | 39013 | 12756 | 247 |
2111263 | 2111263 | 2022-01-13 | Ross | Ohio | 39141 | 14863 | 247 |
2107947 | 2107947 | 2022-01-12 | Belmont | Ohio | 39013 | 12602 | 247 |
2108011 | 2108011 | 2022-01-12 | Ross | Ohio | 39141 | 14615 | 247 |
2104696 | 2104696 | 2022-01-11 | Belmont | Ohio | 39013 | 12471 | 247 |
2104760 | 2104760 | 2022-01-11 | Ross | Ohio | 39141 | 14437 | 247 |
1851191 | 1851191 | 2021-10-25 | Fairfield | Ohio | 39045 | 22438 | 247 |
1847941 | 1847941 | 2021-10-24 | Fairfield | Ohio | 39045 | 22420 | 247 |
1844691 | 1844691 | 2021-10-23 | Fairfield | Ohio | 39045 | 22395 | 247 |
1841441 | 1841441 | 2021-10-22 | Fairfield | Ohio | 39045 | 22354 | 247 |
1828489 | 1828489 | 2021-10-18 | Portage | Ohio | 39133 | 17696 | 247 |
1825240 | 1825240 | 2021-10-17 | Portage | Ohio | 39133 | 17662 | 247 |
1821991 | 1821991 | 2021-10-16 | Portage | Ohio | 39133 | 17616 | 247 |
1818742 | 1818742 | 2021-10-15 | Portage | Ohio | 39133 | 17579 | 247 |
1428954 | 1428954 | 2021-06-17 | Greene | Ohio | 39057 | 15272 | 247 |
1425709 | 1425709 | 2021-06-16 | Greene | Ohio | 39057 | 15271 | 247 |
1422462 | 1422462 | 2021-06-15 | Greene | Ohio | 39057 | 15262 | 247 |
1419266 | 1419266 | 2021-06-14 | Tuscarawas | Ohio | 39157 | 8639 | 247 |
1416021 | 1416021 | 2021-06-13 | Tuscarawas | Ohio | 39157 | 8633 | 247 |
1412775 | 1412775 | 2021-06-12 | Tuscarawas | Ohio | 39157 | 8633 | 247 |
1409530 | 1409530 | 2021-06-11 | Tuscarawas | Ohio | 39157 | 8632 | 247 |
1406285 | 1406285 | 2021-06-10 | Tuscarawas | Ohio | 39157 | 8627 | 247 |
1403039 | 1403039 | 2021-06-09 | Tuscarawas | Ohio | 39157 | 8625 | 247 |
1399794 | 1399794 | 2021-06-08 | Tuscarawas | Ohio | 39157 | 8624 | 247 |
1396549 | 1396549 | 2021-06-07 | Tuscarawas | Ohio | 39157 | 8621 | 247 |
1393302 | 1393302 | 2021-06-06 | Tuscarawas | Ohio | 39157 | 8613 | 247 |
1390057 | 1390057 | 2021-06-05 | Tuscarawas | Ohio | 39157 | 8609 | 247 |
1386812 | 1386812 | 2021-06-04 | Tuscarawas | Ohio | 39157 | 8604 | 247 |
1383567 | 1383567 | 2021-06-03 | Tuscarawas | Ohio | 39157 | 8599 | 247 |
1380321 | 1380321 | 2021-06-02 | Tuscarawas | Ohio | 39157 | 8594 | 247 |
1360781 | 1360781 | 2021-05-27 | Clermont | Ohio | 39025 | 19997 | 247 |
1357535 | 1357535 | 2021-05-26 | Clermont | Ohio | 39025 | 19994 | 247 |
1354289 | 1354289 | 2021-05-25 | Clermont | Ohio | 39025 | 19978 | 247 |
1351043 | 1351043 | 2021-05-24 | Clermont | Ohio | 39025 | 19969 | 247 |
1347797 | 1347797 | 2021-05-23 | Clermont | Ohio | 39025 | 19960 | 247 |
1344549 | 1344549 | 2021-05-22 | Clermont | Ohio | 39025 | 19944 | 247 |
1341301 | 1341301 | 2021-05-21 | Clermont | Ohio | 39025 | 19928 | 247 |
1156249 | 1156249 | 2021-03-25 | Medina | Ohio | 39103 | 14145 | 247 |
1153002 | 1153002 | 2021-03-24 | Medina | Ohio | 39103 | 14128 | 247 |
1149755 | 1149755 | 2021-03-23 | Medina | Ohio | 39103 | 14095 | 247 |
1146508 | 1146508 | 2021-03-22 | Medina | Ohio | 39103 | 14065 | 247 |
1143261 | 1143261 | 2021-03-21 | Medina | Ohio | 39103 | 14037 | 247 |
1140014 | 1140014 | 2021-03-20 | Medina | Ohio | 39103 | 14018 | 247 |
1136768 | 1136768 | 2021-03-19 | Medina | Ohio | 39103 | 13991 | 247 |
912773 | 912773 | 2021-01-09 | Clark | Ohio | 39023 | 9876 | 247 |
909528 | 909528 | 2021-01-08 | Clark | Ohio | 39023 | 9758 | 247 |
394440 | 394440 | 2020-08-02 | Hamilton | Ohio | 39061 | 9110 | 247 |
359112 | 359112 | 2020-07-22 | Mahoning | Ohio | 39099 | 2187 | 247 |
355908 | 355908 | 2020-07-21 | Mahoning | Ohio | 39099 | 2148 | 247 |
204958 | 204958 | 2020-06-03 | Cuyahoga | Ohio | 39035 | 4669 | 247 |
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);