Table: us_historical_vacancies
Columns: district
vacator
reason_for_change
successor
date_successor_seated

Question: When nathaniel g. taylor (u) is the successor what is the vacator?
SQL: SELECT "vacator" FROM us_historical_vacancies WHERE "successor" = 'Nathaniel G. Taylor (U)'

Question: When william b. campbell (u) is the successor what is the district?
SQL: SELECT "district" FROM us_historical_vacancies WHERE "successor" = 'William B. Campbell (U)'

Question: When james brooks (d) is the vacator what is the date the successor was seated?
SQL: SELECT "date_successor_seated" FROM us_historical_vacancies WHERE "vacator" = 'James Brooks (D)'

Question: When john w. leftwich (uu) is the successor what is the date the successor was seated?
SQL: SELECT "date_successor_seated" FROM us_historical_vacancies WHERE "successor" = 'John W. Leftwich (UU)'

Question: When new york 8th is teh district who is the successor?
SQL: SELECT "successor" FROM us_historical_vacancies WHERE "district" = 'New York 8th'