Table schema:
CREATE TABLE table_name_96 (lifespan VARCHAR, party VARCHAR, state VARCHAR, representative VARCHAR)

Question: What is the lifespan of Joseph Vance, a democratic-republican from Ohio?
SQL: SELECT lifespan FROM table_name_96 WHERE state = "ohio" AND representative = "joseph vance" AND party = "democratic-republican"