andrew pattison
of the competitions that andrew pattison participated in , the 2nd to last one was when his opponent in the final was victor pecci .
{'row': '10', 'col': '2', 'order': '2', 'col_other': '4', 'max_or_min': 'max_to_min', 'value_mentioned': 'no', 'scope': 'all', 'subset': None}
{'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'nth_argmax', 'args': ['all_rows', 'date', '2'], 'result': None, 'ind': 0, 'tostr': 'nth_argmax { all_rows ; date ; 2 }'}, 'opponent in the final'], 'result': 'víctor pecci', 'ind': 1, 'tostr': 'hop { nth_argmax { all_rows ; date ; 2 } ; opponent in the final }'}, 'víctor pecci'], 'result': True, 'ind': 2, 'tostr': 'eq { hop { nth_argmax { all_rows ; date ; 2 } ; opponent in the final } ; víctor pecci } = true', 'tointer': 'select the row whose date record of all rows is 2nd maximum . the opponent in the final record of this row is víctor pecci .'}
eq { hop { nth_argmax { all_rows ; date ; 2 } ; opponent in the final } ; víctor pecci } = true
select the row whose date record of all rows is 2nd maximum . the opponent in the final record of this row is víctor pecci .
{'str_eq_2': 'str_eq', 'result_3': 'true', 'str_hop_1': 'str_hop', 'nth_argmax_0': 'nth_argmax', 'all_rows_4': 'all_rows', 'date_5': 'date', '2_6': '2', 'opponent in the final_7': 'opponent in the final', 'víctor pecci_8': 'víctor pecci'}
['outcome', 'date', 'championship', 'opponent in the final', 'score in the final']
[['runner - up', '23 july 1972', 'columbus , ohio , us', 'jimmy connors', '5 - 7 , 3 - 6 , 5 - 7'], ['runner - up', '30 july 1972', 'tanglewood , usa', 'bob hewitt', '6 - 3 , 3 - 6 , 1 - 6'], ['runner - up', '14 august 1972', 'montreal , canada', 'ilie năstase', '4 - 6 , 3 - 6'], ['winner', '8 april 1974', 'monte carlo , monaco', 'ilie năstase', '5 - 7 , 6 - 3 , 6 - 4'], ['winner', '15 april 1974', 'johannesburg , south africa', 'john alexander', '6 - 3 , 7 - 5'], ['runner - up', '28 october 1974', 'vienna , austria', 'vitas gerulaitis', '4 - 6 , 6 - 3 , 3 - 6 , 2 - 6'], ['runner - up', '7 january 1976', 'columbus , ohio , us', 'arthur ashe', '6 - 3 , 3 - 6 , 6 - 7 ( 4 )'], ['runner - up', '8 february 1976', 'dayton , ohio , us', 'jaime fillol sr', '4 - 6 , 7 - 6 , 4 - 6'], ['winner', '14 september 1977', 'laguna niguel , us', 'colin dibley', '2 - 6 , 7 - 6 , 6 - 4'], ['winner', '27 november 1979', 'johannesburg , south africa', 'víctor pecci', '2 - 6 , 6 - 3 , 6 - 2 , 6 - 3'], ['runner - up', '7 july 1980', 'newport , rhode island , us', 'vijay amritraj', '1 - 6 , 7 - 5 , 3 - 6']]