list of top association football goal scorers by country
for the top association football goal scorers , for those that had over 200 matches , the only one with 134 goals was jeff cunningham .
{'scope': 'subset', 'row': '1', 'col': '5', 'col_other': '2', 'criterion': 'equal', 'value': '134', 'subset': {'col': '4', 'criterion': 'greater_than', 'value': '200'}}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_eq', 'args': [{'func': 'filter_greater', 'args': ['all_rows', 'matches', '200'], 'result': None, 'ind': 0, 'tostr': 'filter_greater { all_rows ; matches ; 200 }', 'tointer': 'select the rows whose matches record is greater than 200 .'}, 'goals', '134'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose matches record is greater than 200 . among these rows , select the rows whose goals record is equal to 134 .', 'tostr': 'filter_eq { filter_greater { all_rows ; matches ; 200 } ; goals ; 134 }'}], 'result': True, 'ind': 2, 'tostr': 'only { filter_eq { filter_greater { all_rows ; matches ; 200 } ; goals ; 134 } }', 'tointer': 'select the rows whose matches record is greater than 200 . among these rows , select the rows whose goals record is equal to 134 . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_eq', 'args': [{'func': 'filter_greater', 'args': ['all_rows', 'matches', '200'], 'result': None, 'ind': 0, 'tostr': 'filter_greater { all_rows ; matches ; 200 }', 'tointer': 'select the rows whose matches record is greater than 200 .'}, 'goals', '134'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose matches record is greater than 200 . among these rows , select the rows whose goals record is equal to 134 .', 'tostr': 'filter_eq { filter_greater { all_rows ; matches ; 200 } ; goals ; 134 }'}, 'name'], 'result': 'jeff cunningham', 'ind': 3, 'tostr': 'hop { filter_eq { filter_greater { all_rows ; matches ; 200 } ; goals ; 134 } ; name }'}, 'jeff cunningham'], 'result': True, 'ind': 4, 'tostr': 'eq { hop { filter_eq { filter_greater { all_rows ; matches ; 200 } ; goals ; 134 } ; name } ; jeff cunningham }', 'tointer': 'the name record of this unqiue row is jeff cunningham .'}], 'result': True, 'ind': 5, 'tostr': 'and { only { filter_eq { filter_greater { all_rows ; matches ; 200 } ; goals ; 134 } } ; eq { hop { filter_eq { filter_greater { all_rows ; matches ; 200 } ; goals ; 134 } ; name } ; jeff cunningham } } = true', 'tointer': 'select the rows whose matches record is greater than 200 . among these rows , select the rows whose goals record is equal to 134 . there is only one such row in the table . the name record of this unqiue row is jeff cunningham .'}
and { only { filter_eq { filter_greater { all_rows ; matches ; 200 } ; goals ; 134 } } ; eq { hop { filter_eq { filter_greater { all_rows ; matches ; 200 } ; goals ; 134 } ; name } ; jeff cunningham } } = true
select the rows whose matches record is greater than 200 . among these rows , select the rows whose goals record is equal to 134 . there is only one such row in the table . the name record of this unqiue row is jeff cunningham .
{'and_5': 'and', 'result_6': 'true', 'only_2': 'only', 'filter_eq_1': 'filter_eq', 'filter_greater_0': 'filter_greater', 'all_rows_7': 'all_rows', 'matches_8': 'matches', '200_9': '200', 'goals_10': 'goals', '134_11': '134', 'str_eq_4': 'str_eq', 'str_hop_3': 'str_hop', 'name_12': 'name', 'jeff cunningham_13': 'jeff cunningham'}
['rank', 'name', 'years', 'matches', 'goals']
[['1', 'jeff cunningham', '1998 - 2011', '365', '134'], ['2', 'jaime moreno', '1996 - 2010', '340', '133'], ['3', 'landon donovan', '2001 - present', '281', '124'], ['4', 'ante razov', '1996 - 2009', '262', '114'], ['5', 'jason kreis', '1996 - 2007', '305', '108'], ['6', 'taylor twellman', '2002 - 2010', '174', '101'], ['7', 'dwayne de rosario', '2001 - current', '300', '100'], ['8', 'edson buddle', '2001 - 2010', '231', '90'], ['9', 'carlos ruiz', '2002 - 2008 , 2011', '169', '88'], ['10', 'roy lassiter', '1996 - 2002', '179', '88']]