year competition venue position notes
year
competition
venue
position
notes
number
address
number
number
number text address rank unitnum
1983 pan american games caracas, venezuela 2nd 78.34 m
how many of the competitions that took place were based in a venue in the united states ?
WRB JJ IN DT NNS WDT VBD NN VBD-AUX VBN IN DT NN IN DT NNP NNPS .
2
Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Literal.String
select count ( c2 ) from w where c3_address = 'united states'
Keyword Keyword None None Column None None None None None None None Column None None Literal Literal None
['agg', 'agg_count'] ['agg', 'agg_count'] c2 c3_address