canterbury golf club
for the canterbury golf club , when the tournament was the senior tournament players championship , the only time the winner was miller barber was in 1983 .
{'scope': 'subset', 'row': '8', 'col': '3', 'col_other': '1', 'criterion': 'equal', 'value': 'miller barber', 'subset': {'col': '2', 'criterion': 'equal', 'value': 'senior tournament players championship'}}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'tournament', 'senior tournament players championship'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; tournament ; senior tournament players championship }', 'tointer': 'select the rows whose tournament record fuzzily matches to senior tournament players championship .'}, 'winner', 'miller barber'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose tournament record fuzzily matches to senior tournament players championship . among these rows , select the rows whose winner record fuzzily matches to miller barber .', 'tostr': 'filter_eq { filter_eq { all_rows ; tournament ; senior tournament players championship } ; winner ; miller barber }'}], 'result': True, 'ind': 2, 'tostr': 'only { filter_eq { filter_eq { all_rows ; tournament ; senior tournament players championship } ; winner ; miller barber } }', 'tointer': 'select the rows whose tournament record fuzzily matches to senior tournament players championship . among these rows , select the rows whose winner record fuzzily matches to miller barber . there is only one such row in the table .'}, {'func': 'eq', 'args': [{'func': 'num_hop', 'args': [{'func': 'filter_str_eq', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'tournament', 'senior tournament players championship'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; tournament ; senior tournament players championship }', 'tointer': 'select the rows whose tournament record fuzzily matches to senior tournament players championship .'}, 'winner', 'miller barber'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose tournament record fuzzily matches to senior tournament players championship . among these rows , select the rows whose winner record fuzzily matches to miller barber .', 'tostr': 'filter_eq { filter_eq { all_rows ; tournament ; senior tournament players championship } ; winner ; miller barber }'}, 'year'], 'result': '1983', 'ind': 3, 'tostr': 'hop { filter_eq { filter_eq { all_rows ; tournament ; senior tournament players championship } ; winner ; miller barber } ; year }'}, '1983'], 'result': True, 'ind': 4, 'tostr': 'eq { hop { filter_eq { filter_eq { all_rows ; tournament ; senior tournament players championship } ; winner ; miller barber } ; year } ; 1983 }', 'tointer': 'the year record of this unqiue row is 1983 .'}], 'result': True, 'ind': 5, 'tostr': 'and { only { filter_eq { filter_eq { all_rows ; tournament ; senior tournament players championship } ; winner ; miller barber } } ; eq { hop { filter_eq { filter_eq { all_rows ; tournament ; senior tournament players championship } ; winner ; miller barber } ; year } ; 1983 } } = true', 'tointer': 'select the rows whose tournament record fuzzily matches to senior tournament players championship . among these rows , select the rows whose winner record fuzzily matches to miller barber . there is only one such row in the table . the year record of this unqiue row is 1983 .'}
and { only { filter_eq { filter_eq { all_rows ; tournament ; senior tournament players championship } ; winner ; miller barber } } ; eq { hop { filter_eq { filter_eq { all_rows ; tournament ; senior tournament players championship } ; winner ; miller barber } ; year } ; 1983 } } = true
select the rows whose tournament record fuzzily matches to senior tournament players championship . among these rows , select the rows whose winner record fuzzily matches to miller barber . there is only one such row in the table . the year record of this unqiue row is 1983 .
{'and_5': 'and', 'result_6': 'true', 'only_2': 'only', 'filter_str_eq_1': 'filter_str_eq', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_7': 'all_rows', 'tournament_8': 'tournament', 'senior tournament players championship_9': 'senior tournament players championship', 'winner_10': 'winner', 'miller barber_11': 'miller barber', 'eq_4': 'eq', 'num_hop_3': 'num_hop', 'year_12': 'year', '1983_13': '1983'}
['year', 'tournament', 'winner', 'country', 'score', 'to par', 'margin of victory', "winner 's share"]
[['1932', 'western open ( a )', 'walter hagen', 'united states', '288', 'even', '1 stroke', 'u'], ['1937', 'western open', 'ralph guldahl', 'united states', '287', '- 1', 'playoff ( b )', 'u'], ['1940', 'us open', 'lawson little', 'united states', '287', '- 1', 'playoff ( c )', '1000'], ['1946', 'us open', 'lloyd mangrum', 'united states', '284', '- 4', 'playoff ( d )', '1833'], ['1964', 'us amateur', 'william c campbell', 'united states', '1 up', 'n / a', 'n / a', 'n / a'], ['1973', 'pga championship', 'jack nicklaus', 'united states', '277', '- 7', '4 strokes', '45000'], ['1979', 'us amateur', "mark o'meara", 'united states', '8 & 7', 'n / a', 'n / a', 'n / a'], ['1983', 'senior tournament players championship', 'miller barber', 'united states', '278', '- 10', '1 stroke', '40000'], ['1984', 'senior tournament players championship', 'arnold palmer', 'united states', '276', '- 12', '3 strokes', '36000'], ['1985', 'senior tournament players championship', 'arnold palmer', 'united states', '274', '- 14', '11 strokes', '36000'], ['1986', 'senior tournament players championship', 'chi - chi rodríguez', 'united states', '206', '- 10', '2 strokes', '45000'], ['1996', 'us senior open', 'dave stockton', 'united states', '277', '- 11', '2 strokes', '215500'], ['2009', 'senior pga championship', 'michael allen', 'united states', '274', '- 6', '2 strokes', '360000']]