riding candidate gender residence occupation votes % rank biographical notes
riding
candidate
gender
residence
occupation
votes
%
rank
biographical notes
number
number
number
text text text text text number number rank text
cape breton-canso mark macneill m inverness government and business policy advisor 7660 21.1 3rd served in ottawa as a consultant with national advisory board on science and technology, with the treasury board secretariat and the solicitor general's aboriginal policing secretariat
how many candidates were from halifax ?
WRB JJ NNS VBD-AUX IN NNP .
2
Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Literal.String
select count ( c2 ) from w where c4 = 'halifax'
Keyword Keyword Column None Column Literal None
['agg', 'agg_count'] ['agg', 'agg_count'] c2 c4