2006 pga championship
geoff ogilvy was the only player in the 2006 pga championship from australia .
{'scope': 'all', 'row': '6', 'col': '3', 'col_other': '2', 'criterion': 'equal', 'value': 'australia', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'country', 'australia'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose country record fuzzily matches to australia .', 'tostr': 'filter_eq { all_rows ; country ; australia }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; country ; australia } }', 'tointer': 'select the rows whose country record fuzzily matches to australia . 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', 'australia'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose country record fuzzily matches to australia .', 'tostr': 'filter_eq { all_rows ; country ; australia }'}, 'player'], 'result': 'geoff ogilvy', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; country ; australia } ; player }'}, 'geoff ogilvy'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; country ; australia } ; player } ; geoff ogilvy }', 'tointer': 'the player record of this unqiue row is geoff ogilvy .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; country ; australia } } ; eq { hop { filter_eq { all_rows ; country ; australia } ; player } ; geoff ogilvy } } = true', 'tointer': 'select the rows whose country record fuzzily matches to australia . there is only one such row in the table . the player record of this unqiue row is geoff ogilvy .'}
and { only { filter_eq { all_rows ; country ; australia } } ; eq { hop { filter_eq { all_rows ; country ; australia } ; player } ; geoff ogilvy } } = true
select the rows whose country record fuzzily matches to australia . there is only one such row in the table . the player record of this unqiue row is geoff ogilvy .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'country_7': 'country', 'australia_8': 'australia', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'player_9': 'player', 'geoff ogilvy_10': 'geoff ogilvy'}
['place', 'player', 'country', 'score', 'to par']
[['t1', 'billy andrade', 'united states', '67 + 69 = 136', '- 8'], ['t1', 'luke donald', 'england', '68 + 68 = 136', '- 8'], ['t1', 'henrik stenson', 'sweden', '68 + 68 = 136', '- 8'], ['t1', 'tim herron', 'united states', '69 + 67 = 136', '- 8'], ['t5', 'davis love iii', 'united states', '68 + 69 = 137', '- 7'], ['t5', 'geoff ogilvy', 'australia', '69 + 68 = 137', '- 7'], ['t5', 'tiger woods', 'united states', '69 + 68 = 137', '- 7'], ['t8', 'fred funk', 'united states', '69 + 69 = 138', '- 6'], ['t8', 'billy mayfair', 'united states', '69 + 69 = 138', '- 6'], ['t8', 'chris riley', 'united states', '66 + 72 = 138', '- 6'], ['t8', 'david toms', 'united states', '71 + 67 = 138', '- 6']]