CREATE TABLE table_name_96 (lifespan VARCHAR(255), party VARCHAR(255), state VARCHAR(255), representative VARCHAR(255))
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"