year location men's individual women's individual men's team women's team mixed team ref
year
location
men 's individual
women 's individual
men 's team
women 's team
mixed team
ref
number
first second
first second
number text text(text) text(text) text text text number
1996 vaulx-en-velin franck dauphin (fra) anna campagnoli (ita) united states chinese taipei united states
what are the number of times the location was in madrid ?
WP VBD-AUX DT NN IN NNS DT NN VBD-AUX IN NNP .
2
Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Column Keyword Literal.String
select count ( * ) from w where c2 = 'madrid'
None None Keyword Keyword Keyword Keyword None Column None None Literal None
['agg', 'agg_count'] ['agg', 'agg_count'] ['agg', 'agg_count'] ['agg', 'agg_count'] c2