When james brooks (d) is the vacator what is the date the successor was seated?
create table table_2147588_4 (date_successor_seated varchar, vacator varchar, PRIMARY KEY (date_successor_seated))
select date_successor_seated from table_2147588_4 where vacator = "james brooks (d)"