name took office left office party notes/events
name
took office
left office
party
notes\\/events
number
number parsed year month day
number parsed year month day
number text date date text text
11 william mccreery march 4, 1803 march 3, 1809 democratic republican resigned to accept position as minister plenipotentiary to russia
before peter little , how long did the democratic republican party hold the office , in years ?
IN NNP NNP , WRB RB VBD-AUX DT JJ NNP NNP VB DT NN , IN NNS .
13 years
Keyword Keyword Keyword Column Keyword Column Keyword Keyword Keyword Keyword Column Keyword Keyword Keyword Column Keyword Keyword Keyword Column Keyword Literal.String Keyword Keyword Column Keyword Literal.String
select sum ( c4_year - c3_year ) from w where c3_parsed < ( select c3_parsed from w where c2 = 'peter little' ) and c5 = 'democratic republican'
Column Literal Literal None Keyword Keyword None None Literal Literal Column Column None Column None None None None
c3_parsed ['before', 'before_minus'] ['before', 'before_minus'] c5 c3_year c3_year