2006 pga championship
mike weir was the only player from canada in the 2006 pga championship .
{'scope': 'all', 'row': '3', 'col': '3', 'col_other': '2', 'criterion': 'equal', 'value': 'canada', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'country', 'canada'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose country record fuzzily matches to canada .', 'tostr': 'filter_eq { all_rows ; country ; canada }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; country ; canada } }', 'tointer': 'select the rows whose country record fuzzily matches to canada . 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', 'canada'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose country record fuzzily matches to canada .', 'tostr': 'filter_eq { all_rows ; country ; canada }'}, 'player'], 'result': 'mike weir', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; country ; canada } ; player }'}, 'mike weir'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; country ; canada } ; player } ; mike weir }', 'tointer': 'the player record of this unqiue row is mike weir .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; country ; canada } } ; eq { hop { filter_eq { all_rows ; country ; canada } ; player } ; mike weir } } = true', 'tointer': 'select the rows whose country record fuzzily matches to canada . there is only one such row in the table . the player record of this unqiue row is mike weir .'}
and { only { filter_eq { all_rows ; country ; canada } } ; eq { hop { filter_eq { all_rows ; country ; canada } ; player } ; mike weir } } = true
select the rows whose country record fuzzily matches to canada . there is only one such row in the table . the player record of this unqiue row is mike weir .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'country_7': 'country', 'canada_8': 'canada', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'player_9': 'player', 'mike weir_10': 'mike weir'}
['place', 'player', 'country', 'score', 'to par']
[['t1', 'tiger woods', 'united states', '69 + 68 + 65 = 202', '- 14'], ['t1', 'luke donald', 'england', '68 + 68 + 66 = 202', '- 14'], ['3', 'mike weir', 'canada', '72 + 67 + 65 = 204', '- 12'], ['4', 'geoff ogilvy', 'australia', '69 + 68 + 68 = 205', '- 11'], ['t5', 'shaun micheel', 'united states', '69 + 70 + 67 = 206', '- 10'], ['t5', 'sergio garcía', 'spain', '69 + 70 + 67 = 206', '- 10'], ['7', 'k j choi', 'south korea', '73 + 67 + 67 = 207', '- 9'], ['t8', 'chris dimarco', 'united states', '71 + 70 + 67 = 208', '- 8'], ['t8', 'tim herron', 'united states', '69 + 67 + 72 = 208', '- 8'], ['t8', 'phil mickelson', 'united states', '69 + 71 + 68 = 208', '- 8'], ['t8', 'ian poulter', 'england', '70 + 70 + 68 = 208', '- 8']]