1987 u.s. open ( golf )
berhand langer was the only player from west germany in the 1987 u.s. open golf tournament .
{'scope': 'all', 'row': '4', 'col': '3', 'col_other': '2', 'criterion': 'equal', 'value': 'west germany', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'country', 'west germany'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose country record fuzzily matches to west germany .', 'tostr': 'filter_eq { all_rows ; country ; west germany }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; country ; west germany } }', 'tointer': 'select the rows whose country record fuzzily matches to west germany . 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', 'west germany'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose country record fuzzily matches to west germany .', 'tostr': 'filter_eq { all_rows ; country ; west germany }'}, 'player'], 'result': 'bernhard langer', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; country ; west germany } ; player }'}, 'bernhard langer'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; country ; west germany } ; player } ; bernhard langer }', 'tointer': 'the player record of this unqiue row is bernhard langer .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; country ; west germany } } ; eq { hop { filter_eq { all_rows ; country ; west germany } ; player } ; bernhard langer } } = true', 'tointer': 'select the rows whose country record fuzzily matches to west germany . there is only one such row in the table . the player record of this unqiue row is bernhard langer .'}
and { only { filter_eq { all_rows ; country ; west germany } } ; eq { hop { filter_eq { all_rows ; country ; west germany } ; player } ; bernhard langer } } = true
select the rows whose country record fuzzily matches to west germany . there is only one such row in the table . the player record of this unqiue row is bernhard langer .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'country_7': 'country', 'west germany_8': 'west germany', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'player_9': 'player', 'bernhard langer_10': 'bernhard langer'}
['place', 'player', 'country', 'score', 'to par']
[['t1', 'tom watson', 'united states', '72 + 65 = 137', '- 3'], ['t1', 'mark wiebe', 'united states', '70 + 67 = 137', '- 3'], ['t3', 'john cook', 'united states', '70 + 68 = 138', '- 2'], ['t3', 'bernhard langer', 'west germany', '69 + 69 = 138', '- 2'], ['t3', 'tsuneyuki nakajima', 'japan', '68 + 70 = 138', '- 2'], ['t3', 'jack nicklaus', 'united states', '70 + 68 = 138', '- 2'], ['t3', 'jim thorpe', 'united states', '70 + 68 = 138', '- 2'], ['t8', 'ben crenshaw', 'united states', '67 + 72 = 139', '- 1'], ['t8', 'bob eastwood', 'united states', '73 + 66 = 139', '- 1'], ['t8', 'larry mize', 'united states', '71 + 68 = 139', '- 1'], ['t8', 'scott simpson', 'united states', '71 + 68 = 139', '- 1']]