magnus larsson
2004 was the only year that magnus larsson failed to have a top 1000 year end ranking .
{'scope': 'all', 'row': '20', 'col': '18', 'col_other': '1', 'criterion': 'greater_than', 'value': '1000', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_greater', 'args': ['all_rows', '2004', '1000'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose 2004 record is greater than 1000 .', 'tostr': 'filter_greater { all_rows ; 2004 ; 1000 }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_greater { all_rows ; 2004 ; 1000 } }', 'tointer': 'select the rows whose 2004 record is greater than 1000 . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_greater', 'args': ['all_rows', '2004', '1000'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose 2004 record is greater than 1000 .', 'tostr': 'filter_greater { all_rows ; 2004 ; 1000 }'}, 'tournament'], 'result': 'year end ranking', 'ind': 2, 'tostr': 'hop { filter_greater { all_rows ; 2004 ; 1000 } ; tournament }'}, 'year end ranking'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_greater { all_rows ; 2004 ; 1000 } ; tournament } ; year end ranking }', 'tointer': 'the tournament record of this unqiue row is year end ranking .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_greater { all_rows ; 2004 ; 1000 } } ; eq { hop { filter_greater { all_rows ; 2004 ; 1000 } ; tournament } ; year end ranking } } = true', 'tointer': 'select the rows whose 2004 record is greater than 1000 . there is only one such row in the table . the tournament record of this unqiue row is year end ranking .'}
and { only { filter_greater { all_rows ; 2004 ; 1000 } } ; eq { hop { filter_greater { all_rows ; 2004 ; 1000 } ; tournament } ; year end ranking } } = true
select the rows whose 2004 record is greater than 1000 . there is only one such row in the table . the tournament record of this unqiue row is year end ranking .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_greater_0': 'filter_greater', 'all_rows_6': 'all_rows', '2004_7': '2004', '1000_8': '1000', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'tournament_9': 'tournament', 'year end ranking_10': 'year end ranking'}
['tournament', '1988', '1989', '1990', '1991', '1992', '1993', '1994', '1995', '1996', '1997', '1998', '1999', '2000', '2001', '2002', '2003', '2004', 'career sr', 'career win - loss']
[['grand slams', 'grand slams', 'grand slams', 'grand slams', 'grand slams', 'grand slams', 'grand slams', 'grand slams', 'grand slams', 'grand slams', 'grand slams', 'grand slams', 'grand slams', 'grand slams', 'grand slams', 'grand slams', 'grand slams', 'grand slams', 'grand slams', 'grand slams'], ['australian open', 'a', '1r', '2r', '1r', '1r', '2r', '1r', '4r', '3r', '2r', '1r', 'a', 'a', 'a', 'a', '1r', 'a', '0 / 11', '7 - 11'], ['french open', 'a', 'a', 'a', '3r', '3r', '3r', 'sf', '4r', '1r', '3r', '1r', '2r', 'a', '3r', 'lq', 'a', 'a', '0 / 10', '19 - 10'], ['wimbledon', 'a', 'a', '1r', '2r', '3r', '2r', '1r', 'a', '2r', 'a', '4r', '1r', 'a', '3r', '1r', 'a', 'a', '0 / 10', '10 - 10'], ['us open', 'a', 'a', 'a', '3r', '2r', 'qf', '1r', 'a', '1r', 'qf', 'qf', '3r', 'a', '1r', 'lq', 'a', 'a', '0 / 9', '17 - 9'], ['grand slam sr', '0 / 0', '0 / 1', '0 / 2', '0 / 4', '0 / 4', '0 / 4', '0 / 4', '0 / 2', '0 / 4', '0 / 3', '0 / 4', '0 / 3', '0 / 0', '0 / 3', '0 / 1', '0 / 1', '0 / 0', '0 / 40', 'n / a'], ['annual win - loss', '0 - 0', '0 - 1', '1 - 2', '5 - 4', '5 - 4', '8 - 4', '5 - 4', '5 - 2', '3 - 4', '7 - 3', '7 - 4', '3 - 3', '0 - 0', '4 - 3', '0 - 1', '0 - 1', '0 - 0', 'n / a', '53 - 40'], ['atp masters series', 'atp masters series', 'atp masters series', 'atp masters series', 'atp masters series', 'atp masters series', 'atp masters series', 'atp masters series', 'atp masters series', 'atp masters series', 'atp masters series', 'atp masters series', 'atp masters series', 'atp masters series', 'atp masters series', 'atp masters series', 'atp masters series', 'atp masters series', 'atp masters series', 'atp masters series'], ['indian wells', 'nme', 'nme', 'a', 'a', 'a', 'a', 'a', 'qf', '1r', '3r', '1r', 'a', 'a', 'a', 'a', 'a', 'a', '0 / 4', '5 - 4'], ['miami', 'nme', 'nme', 'a', 'a', 'a', '2r', 'a', 'sf', '2r', '4r', '2r', 'a', '1r', 'a', 'lq', 'lq', 'a', '0 / 6', '7 - 6'], ['monte carlo', 'nme', 'nme', 'a', '3r', '3r', '3r', '1r', '2r', '1r', 'qf', 'a', 'a', '1r', 'a', 'lq', 'a', 'a', '0 / 7', '9 - 7'], ['rome', 'nme', 'nme', 'a', '1r', '1r', '1r', 'a', 'a', 'a', '3r', 'a', 'a', 'a', 'a', 'lq', 'a', 'a', '0 / 4', '2 - 4'], ['hamburg', 'nme', 'nme', 'a', '2r', 'a', '1r', '2r', 'a', 'qf', '1r', 'a', 'a', 'a', 'a', 'lq', 'a', 'a', '0 / 5', '5 - 5'], ['canada', 'nme', 'nme', 'a', 'a', 'a', 'a', 'a', 'a', 'a', 'a', 'a', '1r', 'a', 'a', 'a', 'a', 'a', '0 / 1', '0 - 1'], ['cincinnati', 'nme', 'nme', 'a', 'a', 'a', 'a', 'a', 'a', '2r', '1r', 'sf', '2r', 'a', 'lq', 'a', 'a', 'a', '0 / 4', '6 - 4'], ['madrid ( stuttgart )', 'nme', 'nme', '2r', '2r', '2r', '2r', 'qf', 'a', 'a', 'qf', 'a', '2r', 'a', 'a', 'a', 'a', 'a', '0 / 7', '11 - 6'], ['paris', 'nme', 'nme', 'a', 'a', '2r', '2r', '3r', '3r', '2r', '1r', 'a', 'a', 'a', 'lq', 'a', 'a', 'a', '0 / 6', '6 - 6'], ['masters series sr', '0 / 0', '0 / 0', '0 / 1', '0 / 4', '0 / 4', '0 / 6', '0 / 4', '0 / 4', '0 / 6', '0 / 8', '0 / 3', '0 / 3', '0 / 2', '0 / 0', '0 / 0', '0 / 0', '0 / 0', '0 / 44', 'n / a'], ['annual win - loss', 'n / a', 'n / a', '1 - 1', '4 - 4', '4 - 4', '4 - 6', '6 - 4', '8 - 4', '5 - 6', '13 - 8', '4 - 3', '2 - 2', '0 - 2', '0 - 0', '0 - 0', '0 - 0', '0 - 0', 'n / a', '51 - 43'], ['year end ranking', '381', '145', '56', '61', '34', '39', '19', '17', '46', '25', '43', '96', '75', '136', '152', '507', '1422', 'n / a', 'n / a']]