year competition venue position event notes
year
competition
venue
position
event
notes
number
address
number
number hour min sec
number text address rank text time
1979 grandma's marathon duluth, united states 1st marathon 2:37:37
what were the total number of times the venue was located in the united states ?
WP VBD-AUX DT JJ NN IN NNS DT NN VBD-AUX JJ IN DT NNP NNPS .
6
Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Column Keyword Literal.String
select count ( * ) from w where c3_address = 'united states'
None None None Keyword Keyword Keyword Keyword None None None Column Column None Literal Literal None
['agg', 'agg_count'] ['agg', 'agg_count'] ['agg', 'agg_count'] ['agg', 'agg_count'] c3_address c3_address