name party province term expires years in office
name
party
province
term expires
years in office
number
minimum_number minimum_parsed minimum_year maximum_number maximum_parsed maximum_year
text text text number timespan
william atkinson liberal central 1989 1983-1984
who has had the shortest term in office
WP VBD-AUX VBD-AUX DT JJS NN IN NN
William Atkinson
select c1 from w order by c5_maximum_number - c5_minimum_number asc limit 1