Table: legislators_biography
Columns: office
type
location
took_office
left_office

Question: What date did the executive office in Dover take office?
SQL: SELECT "took_office" FROM legislators_biography WHERE "location" = 'dover' AND "type" = 'executive'

Question: What left office date happened in Washington?
SQL: SELECT "left_office" FROM legislators_biography WHERE "location" = 'washington'

Question: What type of office left office in 1810?
SQL: SELECT "office" FROM legislators_biography WHERE "left_office" = '1810'