travis parrott
the tournament in valencia , spain was the only tournament travis parrott played on a clay surface .
{'scope': 'all', 'row': '3', 'col': '3', 'col_other': '2', 'criterion': 'equal', 'value': 'clay', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'surface', 'clay'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose surface record fuzzily matches to clay .', 'tostr': 'filter_eq { all_rows ; surface ; clay }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; surface ; clay } }', 'tointer': 'select the rows whose surface record fuzzily matches to clay . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'surface', 'clay'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose surface record fuzzily matches to clay .', 'tostr': 'filter_eq { all_rows ; surface ; clay }'}, 'tournament'], 'result': 'valencia , spain', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; surface ; clay } ; tournament }'}, 'valencia , spain'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; surface ; clay } ; tournament } ; valencia , spain }', 'tointer': 'the tournament record of this unqiue row is valencia , spain .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; surface ; clay } } ; eq { hop { filter_eq { all_rows ; surface ; clay } ; tournament } ; valencia , spain } } = true', 'tointer': 'select the rows whose surface record fuzzily matches to clay . there is only one such row in the table . the tournament record of this unqiue row is valencia , spain .'}
and { only { filter_eq { all_rows ; surface ; clay } } ; eq { hop { filter_eq { all_rows ; surface ; clay } ; tournament } ; valencia , spain } } = true
select the rows whose surface record fuzzily matches to clay . there is only one such row in the table . the tournament record of this unqiue row is valencia , spain .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'surface_7': 'surface', 'clay_8': 'clay', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'tournament_9': 'tournament', 'valencia , spain_10': 'valencia , spain'}
['date', 'tournament', 'surface', 'partnering', 'opponent in the final', 'score']
[['august 16 , 2004', 'washington , dc , united states', 'hard', 'dmitry tursunov', 'chris haggard robbie koenig', '7 - 6 3 , 6 - 1'], ['july 4 , 2005', 'newport , us', 'grass', 'graydon oliver', 'jordan kerr jim thomas', '7 - 6 5 , 7 - 6 5'], ['april 14 , 2008', 'valencia , spain', 'clay', 'filip polášek', 'máximo gonzález juan mónaco', '7 - 5 , 7 - 5'], ['august 4 , 2008', 'los angeles , us', 'hard', 'dušan vemić', 'rohan bopanna eric butorac', '7 - 6 5 , 7 - 6 5'], ['february 22 , 2009', 'memphis , tennessee , us', 'hard', 'filip polášek', 'mardy fish mark knowles', '7 - 6 7 , 6 - 1'], ['june 19 , 2009', 'eastbourne , united kingdom', 'grass', 'filip polášek', 'mariusz fyrstenberg marcin matkowski', '6 - 4 , 6 - 4']]