1989 open championship
david feherty was the only competing player representing northern ireland .
{'scope': 'all', 'row': '7', 'col': '3', 'col_other': '2', 'criterion': 'equal', 'value': 'northern ireland', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'country', 'northern ireland'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose country record fuzzily matches to northern ireland .', 'tostr': 'filter_eq { all_rows ; country ; northern ireland }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; country ; northern ireland } }', 'tointer': 'select the rows whose country record fuzzily matches to northern ireland . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'country', 'northern ireland'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose country record fuzzily matches to northern ireland .', 'tostr': 'filter_eq { all_rows ; country ; northern ireland }'}, 'player'], 'result': 'david feherty', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; country ; northern ireland } ; player }'}, 'david feherty'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; country ; northern ireland } ; player } ; david feherty }', 'tointer': 'the player record of this unqiue row is david feherty .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; country ; northern ireland } } ; eq { hop { filter_eq { all_rows ; country ; northern ireland } ; player } ; david feherty } } = true', 'tointer': 'select the rows whose country record fuzzily matches to northern ireland . there is only one such row in the table . the player record of this unqiue row is david feherty .'}
and { only { filter_eq { all_rows ; country ; northern ireland } } ; eq { hop { filter_eq { all_rows ; country ; northern ireland } ; player } ; david feherty } } = true
select the rows whose country record fuzzily matches to northern ireland . there is only one such row in the table . the player record of this unqiue row is david feherty .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'country_7': 'country', 'northern ireland_8': 'northern ireland', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'player_9': 'player', 'david feherty_10': 'david feherty'}
['place', 'player', 'country', 'score', 'to par', 'money']
[['t1', 'mark calcavecchia', 'united states', '71 + 68 + 68 + 68 = 275', '- 13', 'playoff'], ['t1', 'greg norman', 'australia', '69 + 70 + 72 + 64 = 275', '- 13', 'playoff'], ['t1', 'wayne grady', 'australia', '68 + 67 + 69 + 71 = 275', '- 13', 'playoff'], ['4', 'tom watson', 'united states', '69 + 68 + 68 + 72 = 277', '- 11', '40000'], ['5', 'jodie mudd', 'united states', '73 + 67 + 68 + 70 = 278', '- 10', '30000'], ['t6', 'fred couples', 'united states', '68 + 71 + 68 + 72 = 279', '- 9', '26000'], ['t6', 'david feherty', 'northern ireland', '71 + 67 + 69 + 72 = 279', '- 9', '26000'], ['t8', 'eduardo romero', 'argentina', '68 + 70 + 75 + 67 = 280', '- 8', '21000'], ['t8', 'paul azinger', 'united states', '68 + 73 + 67 + 72 = 280', '- 8', '21000'], ['t8', 'payne stewart', 'united states', '72 + 65 + 69 + 74 = 280', '- 8', '21000']]