pete sampras career statistics
the only masters series finals singles match that pete sampras competed in on a clay surface was in 1994 in rome .
{'scope': 'all', 'row': '7', 'col': '4', 'col_other': '2,3', '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': 'and', 'args': [{'func': 'eq', 'args': [{'func': 'num_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 }'}, 'year'], 'result': '1994', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; surface ; clay } ; year }'}, '1994'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; surface ; clay } ; year } ; 1994 }', 'tointer': 'the year record of this unqiue row is 1994 .'}, {'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 }'}, 'championship'], 'result': 'rome', 'ind': 4, 'tostr': 'hop { filter_eq { all_rows ; surface ; clay } ; championship }'}, 'rome'], 'result': True, 'ind': 5, 'tostr': 'eq { hop { filter_eq { all_rows ; surface ; clay } ; championship } ; rome }', 'tointer': 'the championship record of this unqiue row is rome .'}], 'result': True, 'ind': 6, 'tostr': 'and { eq { hop { filter_eq { all_rows ; surface ; clay } ; year } ; 1994 } ; eq { hop { filter_eq { all_rows ; surface ; clay } ; championship } ; rome } }', 'tointer': 'the year record of this unqiue row is 1994 . the championship record of this unqiue row is rome .'}], 'result': True, 'ind': 7, 'tostr': 'and { only { filter_eq { all_rows ; surface ; clay } } ; and { eq { hop { filter_eq { all_rows ; surface ; clay } ; year } ; 1994 } ; eq { hop { filter_eq { all_rows ; surface ; clay } ; championship } ; rome } } } = true', 'tointer': 'select the rows whose surface record fuzzily matches to clay . there is only one such row in the table . the year record of this unqiue row is 1994 . the championship record of this unqiue row is rome .'}
and { only { filter_eq { all_rows ; surface ; clay } } ; and { eq { hop { filter_eq { all_rows ; surface ; clay } ; year } ; 1994 } ; eq { hop { filter_eq { all_rows ; surface ; clay } ; championship } ; rome } } } = true
select the rows whose surface record fuzzily matches to clay . there is only one such row in the table . the year record of this unqiue row is 1994 . the championship record of this unqiue row is rome .
{'and_7': 'and', 'result_8': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_9': 'all_rows', 'surface_10': 'surface', 'clay_11': 'clay', 'and_6': 'and', 'eq_3': 'eq', 'num_hop_2': 'num_hop', 'year_12': 'year', '1994_13': '1994', 'str_eq_5': 'str_eq', 'str_hop_4': 'str_hop', 'championship_14': 'championship', 'rome_15': 'rome'}
['outcome', 'year', 'championship', 'surface', 'opponent in the final', 'score in the final']
[['runner - up', '1991', 'cincinnati', 'hard', 'guy forget', '6 - 2 , 6 - 7 ( 4 - 7 ) , 4 - 6'], ['runner - up', '1991', 'paris', 'carpet ( i )', 'guy forget', '6 - 7 ( 9 - 11 ) , 6 - 4 , 7 - 5 , 4 - 6 , 4 - 6'], ['winner', '1992', 'cincinnati', 'hard', 'ivan lendl', '6 - 3 , 3 - 6 , 6 - 3'], ['winner', '1993', 'miami', 'hard', 'malivai washington', '6 - 3 , 6 - 2'], ['winner', '1994', 'indian wells', 'hard', 'petr korda', '4 - 6 , 6 - 3 , 3 - 6 , 6 - 3 , 6 - 2'], ['winner', '1994', 'miami ( 2 )', 'hard', 'andre agassi', '5 - 7 , 6 - 3 , 6 - 3'], ['winner', '1994', 'rome', 'clay', 'boris becker', '6 - 1 , 6 - 2 , 6 - 2'], ['winner', '1995', 'indian wells ( 2 )', 'hard', 'andre agassi', '7 - 5 , 6 - 3 , 7 - 5'], ['runner - up', '1995', 'miami', 'hard', 'andre agassi', '6 - 3 , 2 - 6 , 6 - 7 ( 6 - 8 )'], ['runner - up', '1995', 'canada ( montreal )', 'hard', 'andre agassi', '6 - 3 , 2 - 6 , 3 - 6'], ['winner', '1995', 'paris', 'carpet ( i )', 'boris becker', '7 - 6 ( 7 - 5 ) , 6 - 4 , 6 - 4'], ['runner - up', '1996', 'stuttgart', 'carpet ( i )', 'boris becker', '6 - 3 , 3 - 6 , 6 - 3 , 3 - 6 , 4 - 6'], ['winner', '1997', 'cincinnati ( 2 )', 'hard', 'thomas muster', '6 - 3 , 6 - 4'], ['winner', '1997', 'paris ( 2 )', 'carpet ( i )', 'jonas björkman', '6 - 3 , 4 - 6 , 6 - 3 , 6 - 1'], ['runner - up', '1998', 'cincinnati ( 2 )', 'hard', 'patrick rafter', '6 - 1 , 6 - 7 ( 2 - 7 ) , 4 - 6'], ['runner - up', '1998', 'paris ( 2 )', 'carpet ( i )', 'greg rusedski', '4 - 6 , 6 - 7 ( 4 - 7 ) , 3 - 6'], ['winner', '1999', 'cincinnati ( 3 )', 'hard', 'patrick rafter', '7 - 6 ( 9 - 7 ) , 6 - 3'], ['winner', '2000', 'miami ( 3 )', 'hard', 'gustavo kuerten', '6 - 1 , 6 - 7 ( 2 - 7 ) , 7 - 6 ( 7 - 5 ) , 7 - 6 ( 10 - 8 )']]