ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
498 rows where deaths = 15 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Knox 48
- Delaware 41
- Adams 34
- Putnam 34
- Vinton 32
- Coshocton 31
- Gallia 21
- Perry 21
- Monroe 19
- Sandusky 19
- Guernsey 15
- Seneca 14
- Shelby 14
- Clermont 11
- Wyandot 10
- Brown 7
- Madison 7
- Marion 7
- Belmont 6
- Fairfield 6
- Huron 6
- Preble 6
- Tuscarawas 6
- Ashtabula 5
- Auglaize 5
- Paulding 5
- Warren 5
- Defiance 4
- Medina 4
- Clark 3
- …
state 1
- Ohio · 498 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1338123 | 1338123 | 2021-05-20 | Vinton | Ohio | 39163 | 849 | 15 |
1334876 | 1334876 | 2021-05-19 | Vinton | Ohio | 39163 | 849 | 15 |
1331629 | 1331629 | 2021-05-18 | Vinton | Ohio | 39163 | 849 | 15 |
1328382 | 1328382 | 2021-05-17 | Vinton | Ohio | 39163 | 849 | 15 |
1325136 | 1325136 | 2021-05-16 | Vinton | Ohio | 39163 | 847 | 15 |
1321890 | 1321890 | 2021-05-15 | Vinton | Ohio | 39163 | 846 | 15 |
1318644 | 1318644 | 2021-05-14 | Vinton | Ohio | 39163 | 842 | 15 |
1315396 | 1315396 | 2021-05-13 | Vinton | Ohio | 39163 | 841 | 15 |
1312150 | 1312150 | 2021-05-12 | Vinton | Ohio | 39163 | 838 | 15 |
1308903 | 1308903 | 2021-05-11 | Vinton | Ohio | 39163 | 835 | 15 |
1305657 | 1305657 | 2021-05-10 | Vinton | Ohio | 39163 | 832 | 15 |
1302411 | 1302411 | 2021-05-09 | Vinton | Ohio | 39163 | 832 | 15 |
1299163 | 1299163 | 2021-05-08 | Vinton | Ohio | 39163 | 831 | 15 |
1295917 | 1295917 | 2021-05-07 | Vinton | Ohio | 39163 | 828 | 15 |
1292671 | 1292671 | 2021-05-06 | Vinton | Ohio | 39163 | 824 | 15 |
1289425 | 1289425 | 2021-05-05 | Vinton | Ohio | 39163 | 821 | 15 |
1286179 | 1286179 | 2021-05-04 | Vinton | Ohio | 39163 | 820 | 15 |
1282933 | 1282933 | 2021-05-03 | Vinton | Ohio | 39163 | 820 | 15 |
1279686 | 1279686 | 2021-05-02 | Vinton | Ohio | 39163 | 820 | 15 |
1276439 | 1276439 | 2021-05-01 | Vinton | Ohio | 39163 | 820 | 15 |
1273192 | 1273192 | 2021-04-30 | Vinton | Ohio | 39163 | 819 | 15 |
1078365 | 1078365 | 2021-03-01 | Vinton | Ohio | 39163 | 767 | 15 |
1075120 | 1075120 | 2021-02-28 | Vinton | Ohio | 39163 | 766 | 15 |
1071874 | 1071874 | 2021-02-27 | Vinton | Ohio | 39163 | 766 | 15 |
1068628 | 1068628 | 2021-02-26 | Vinton | Ohio | 39163 | 766 | 15 |
1065383 | 1065383 | 2021-02-25 | Vinton | Ohio | 39163 | 765 | 15 |
1062139 | 1062139 | 2021-02-24 | Vinton | Ohio | 39163 | 765 | 15 |
1058893 | 1058893 | 2021-02-23 | Vinton | Ohio | 39163 | 762 | 15 |
1055647 | 1055647 | 2021-02-22 | Vinton | Ohio | 39163 | 762 | 15 |
1052401 | 1052401 | 2021-02-21 | Vinton | Ohio | 39163 | 762 | 15 |
1049154 | 1049154 | 2021-02-20 | Vinton | Ohio | 39163 | 760 | 15 |
1045907 | 1045907 | 2021-02-19 | Vinton | Ohio | 39163 | 760 | 15 |
1016618 | 1016618 | 2021-02-10 | Adams | Ohio | 39001 | 2079 | 15 |
1013373 | 1013373 | 2021-02-09 | Adams | Ohio | 39001 | 2072 | 15 |
1010128 | 1010128 | 2021-02-08 | Adams | Ohio | 39001 | 2047 | 15 |
1006882 | 1006882 | 2021-02-07 | Adams | Ohio | 39001 | 2036 | 15 |
1003636 | 1003636 | 2021-02-06 | Adams | Ohio | 39001 | 2030 | 15 |
1000390 | 1000390 | 2021-02-05 | Adams | Ohio | 39001 | 2023 | 15 |
997144 | 997144 | 2021-02-04 | Adams | Ohio | 39001 | 2004 | 15 |
993898 | 993898 | 2021-02-03 | Adams | Ohio | 39001 | 1990 | 15 |
990652 | 990652 | 2021-02-02 | Adams | Ohio | 39001 | 1971 | 15 |
987406 | 987406 | 2021-02-01 | Adams | Ohio | 39001 | 1953 | 15 |
984159 | 984159 | 2021-01-31 | Adams | Ohio | 39001 | 1952 | 15 |
980912 | 980912 | 2021-01-30 | Adams | Ohio | 39001 | 1952 | 15 |
977666 | 977666 | 2021-01-29 | Adams | Ohio | 39001 | 1903 | 15 |
974421 | 974421 | 2021-01-28 | Adams | Ohio | 39001 | 1860 | 15 |
971176 | 971176 | 2021-01-27 | Adams | Ohio | 39001 | 1833 | 15 |
967931 | 967931 | 2021-01-26 | Adams | Ohio | 39001 | 1798 | 15 |
964687 | 964687 | 2021-01-25 | Adams | Ohio | 39001 | 1777 | 15 |
961442 | 961442 | 2021-01-24 | Adams | Ohio | 39001 | 1769 | 15 |
958197 | 958197 | 2021-01-23 | Adams | Ohio | 39001 | 1761 | 15 |
954951 | 954951 | 2021-01-22 | Adams | Ohio | 39001 | 1730 | 15 |
951706 | 951706 | 2021-01-21 | Adams | Ohio | 39001 | 1720 | 15 |
948461 | 948461 | 2021-01-20 | Adams | Ohio | 39001 | 1695 | 15 |
945215 | 945215 | 2021-01-19 | Adams | Ohio | 39001 | 1674 | 15 |
941968 | 941968 | 2021-01-18 | Adams | Ohio | 39001 | 1658 | 15 |
938723 | 938723 | 2021-01-17 | Adams | Ohio | 39001 | 1656 | 15 |
935478 | 935478 | 2021-01-16 | Adams | Ohio | 39001 | 1655 | 15 |
932233 | 932233 | 2021-01-15 | Adams | Ohio | 39001 | 1618 | 15 |
928988 | 928988 | 2021-01-14 | Adams | Ohio | 39001 | 1608 | 15 |
925743 | 925743 | 2021-01-13 | Adams | Ohio | 39001 | 1592 | 15 |
925752 | 925752 | 2021-01-13 | Carroll | Ohio | 39019 | 1418 | 15 |
922497 | 922497 | 2021-01-12 | Adams | Ohio | 39001 | 1586 | 15 |
922504 | 922504 | 2021-01-12 | Brown | Ohio | 39015 | 2826 | 15 |
922506 | 922506 | 2021-01-12 | Carroll | Ohio | 39019 | 1406 | 15 |
919252 | 919252 | 2021-01-11 | Adams | Ohio | 39001 | 1562 | 15 |
919259 | 919259 | 2021-01-11 | Brown | Ohio | 39015 | 2803 | 15 |
916007 | 916007 | 2021-01-10 | Adams | Ohio | 39001 | 1561 | 15 |
916014 | 916014 | 2021-01-10 | Brown | Ohio | 39015 | 2776 | 15 |
912762 | 912762 | 2021-01-09 | Adams | Ohio | 39001 | 1552 | 15 |
912769 | 912769 | 2021-01-09 | Brown | Ohio | 39015 | 2742 | 15 |
909517 | 909517 | 2021-01-08 | Adams | Ohio | 39001 | 1531 | 15 |
909524 | 909524 | 2021-01-08 | Brown | Ohio | 39015 | 2697 | 15 |
906279 | 906279 | 2021-01-07 | Brown | Ohio | 39015 | 2642 | 15 |
903033 | 903033 | 2021-01-06 | Brown | Ohio | 39015 | 2600 | 15 |
893353 | 893353 | 2021-01-03 | Perry | Ohio | 39127 | 1904 | 15 |
890107 | 890107 | 2021-01-02 | Perry | Ohio | 39127 | 1886 | 15 |
886860 | 886860 | 2021-01-01 | Perry | Ohio | 39127 | 1847 | 15 |
883615 | 883615 | 2020-12-31 | Perry | Ohio | 39127 | 1847 | 15 |
880370 | 880370 | 2020-12-30 | Perry | Ohio | 39127 | 1805 | 15 |
877125 | 877125 | 2020-12-29 | Perry | Ohio | 39127 | 1778 | 15 |
873880 | 873880 | 2020-12-28 | Perry | Ohio | 39127 | 1760 | 15 |
870635 | 870635 | 2020-12-27 | Perry | Ohio | 39127 | 1751 | 15 |
867390 | 867390 | 2020-12-26 | Perry | Ohio | 39127 | 1739 | 15 |
864097 | 864097 | 2020-12-25 | Coshocton | Ohio | 39031 | 1582 | 15 |
864145 | 864145 | 2020-12-25 | Perry | Ohio | 39127 | 1716 | 15 |
860852 | 860852 | 2020-12-24 | Coshocton | Ohio | 39031 | 1582 | 15 |
860900 | 860900 | 2020-12-24 | Perry | Ohio | 39127 | 1716 | 15 |
857607 | 857607 | 2020-12-23 | Coshocton | Ohio | 39031 | 1556 | 15 |
857655 | 857655 | 2020-12-23 | Perry | Ohio | 39127 | 1677 | 15 |
854362 | 854362 | 2020-12-22 | Coshocton | Ohio | 39031 | 1525 | 15 |
854410 | 854410 | 2020-12-22 | Perry | Ohio | 39127 | 1653 | 15 |
851117 | 851117 | 2020-12-21 | Coshocton | Ohio | 39031 | 1513 | 15 |
851165 | 851165 | 2020-12-21 | Perry | Ohio | 39127 | 1642 | 15 |
847872 | 847872 | 2020-12-20 | Coshocton | Ohio | 39031 | 1493 | 15 |
847920 | 847920 | 2020-12-20 | Perry | Ohio | 39127 | 1617 | 15 |
844627 | 844627 | 2020-12-19 | Coshocton | Ohio | 39031 | 1463 | 15 |
844675 | 844675 | 2020-12-19 | Perry | Ohio | 39127 | 1571 | 15 |
841381 | 841381 | 2020-12-18 | Coshocton | Ohio | 39031 | 1444 | 15 |
841429 | 841429 | 2020-12-18 | Perry | Ohio | 39127 | 1549 | 15 |
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);