anaprof 2006
the san francisco fc team had the 2nd highest number of points in the 2006 season of anaprof .
{'row': '2', 'col': '10', 'order': '2', 'col_other': '2', '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', 'points ( pts )', '2'], 'result': None, 'ind': 0, 'tostr': 'nth_argmax { all_rows ; points ( pts ) ; 2 }'}, 'team ( equipo )'], 'result': 'san francisco fc', 'ind': 1, 'tostr': 'hop { nth_argmax { all_rows ; points ( pts ) ; 2 } ; team ( equipo ) }'}, 'san francisco fc'], 'result': True, 'ind': 2, 'tostr': 'eq { hop { nth_argmax { all_rows ; points ( pts ) ; 2 } ; team ( equipo ) } ; san francisco fc } = true', 'tointer': 'select the row whose points ( pts ) record of all rows is 2nd maximum . the team ( equipo ) record of this row is san francisco fc .'}
eq { hop { nth_argmax { all_rows ; points ( pts ) ; 2 } ; team ( equipo ) } ; san francisco fc } = true
select the row whose points ( pts ) record of all rows is 2nd maximum . the team ( equipo ) record of this row is san francisco fc .
{'str_eq_2': 'str_eq', 'result_3': 'true', 'str_hop_1': 'str_hop', 'nth_argmax_0': 'nth_argmax', 'all_rows_4': 'all_rows', 'points (pts)_5': 'points ( pts )', '2_6': '2', 'team (equipo)_7': 'team ( equipo )', 'san francisco fc_8': 'san francisco fc'}
['place ( posición )', 'team ( equipo )', 'played ( pj )', 'won ( pg )', 'draw ( pe )', 'lost ( pp )', 'goals scored ( gf )', 'goals conceded ( gc )', '+ / - ( dif )', 'points ( pts )']
[['1', 'tauro fc', '18', '10', '7', '1', '31', '17', '+ 14', '37'], ['2', 'san francisco fc', '18', '11', '2', '5', '40', '25', '+ 15', '35'], ['3', 'arabe unido', '18', '10', '3', '5', '30', '20', '+ 10', '33'], ['4', 'atlético veragüense', '18', '9', '6', '3', '22', '16', '+ 6', '33'], ['5', 'plaza amador', '18', '9', '4', '5', '25', '17', '+ 8', '31'], ['6', 'alianza fc', '18', '8', '2', '8', '29', '31', '- 2', '26'], ['7', 'municipal chorrillo', '18', '6', '6', '6', '24', '23', '+ 1', '24'], ['8', "sporting ' 89", '18', '4', '1', '13', '17', '31', '- 14', '13'], ['9', 'atlético chiriquí', '18', '2', '4', '12', '14', '30', '- 16', '10'], ['10', 'policia nacional', '18', '3', '1', '14', '17', '39', '- 22', '10']]