Table: senate_successors
Columns: state_class
vacator
reason_for_change
successor
date_of_successors_formal_installation

Question: Name the successor for james noble died in previous congress
SQL: SELECT "successor" FROM senate_successors WHERE "reason_for_change" = 'James Noble died in previous Congress'

Question: Name the state class for isaac d. barnard (j)
SQL: SELECT "state_class" FROM senate_successors WHERE "vacator" = 'Isaac D. Barnard (J)'