question: What is the lifespan of Joseph Vance, a democratic-republican from Ohio?
answer: SELECT lifespan FROM table_name_96 WHERE state = "ohio" AND representative = "joseph vance" AND party = "democratic-republican"
context: CREATE TABLE table_name_96 (lifespan VARCHAR, party VARCHAR, state VARCHAR, representative VARCHAR)