name elected term began term ended
name
elected
term began
term ended
number parsed year month day
number parsed year month day
text text date date
henry a. atkins appointed december 2, 1869
elected july 11, 1870 december 1, 1969 january 1, 1978
who was the mayor before jordan ?
WP VBD-AUX DT NN IN NNP .
Henry A. Atkins
Keyword Column Keyword Keyword Keyword Column Keyword Keyword Keyword Column Keyword Keyword Keyword Column Keyword Literal.String Keyword Keyword Keyword Column Keyword Keyword Keyword
select c1 from w where c3_year < ( select c3_year from w where c1 = 'john t. jordan' ) order by c3_year desc limit 1
None None None Column Column Literal None
c1 c3_year