1998 icc knockout trophy
the only left handed batter at the 1998 icc knockout trophy from windward islands was nixon mclean .
{'scope': 'subset', 'row': '10', 'col': '6', 'col_other': '2,4', 'criterion': 'equal', 'value': 'windward islands', 'subset': {'col': '4', 'criterion': 'equal', 'value': 'left hand bat'}}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'batting style', 'left hand bat'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; batting style ; left hand bat }', 'tointer': 'select the rows whose batting style record fuzzily matches to left hand bat .'}, 'first class team', 'windward islands'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose batting style record fuzzily matches to left hand bat . among these rows , select the rows whose first class team record fuzzily matches to windward islands .', 'tostr': 'filter_eq { filter_eq { all_rows ; batting style ; left hand bat } ; first class team ; windward islands }'}], 'result': True, 'ind': 2, 'tostr': 'only { filter_eq { filter_eq { all_rows ; batting style ; left hand bat } ; first class team ; windward islands } }', 'tointer': 'select the rows whose batting style record fuzzily matches to left hand bat . among these rows , select the rows whose first class team record fuzzily matches to windward islands . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'batting style', 'left hand bat'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; batting style ; left hand bat }', 'tointer': 'select the rows whose batting style record fuzzily matches to left hand bat .'}, 'first class team', 'windward islands'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose batting style record fuzzily matches to left hand bat . among these rows , select the rows whose first class team record fuzzily matches to windward islands .', 'tostr': 'filter_eq { filter_eq { all_rows ; batting style ; left hand bat } ; first class team ; windward islands }'}, 'player'], 'result': 'nixon mclean', 'ind': 3, 'tostr': 'hop { filter_eq { filter_eq { all_rows ; batting style ; left hand bat } ; first class team ; windward islands } ; player }'}, 'nixon mclean'], 'result': True, 'ind': 4, 'tostr': 'eq { hop { filter_eq { filter_eq { all_rows ; batting style ; left hand bat } ; first class team ; windward islands } ; player } ; nixon mclean }', 'tointer': 'the player record of this unqiue row is nixon mclean .'}], 'result': True, 'ind': 5, 'tostr': 'and { only { filter_eq { filter_eq { all_rows ; batting style ; left hand bat } ; first class team ; windward islands } } ; eq { hop { filter_eq { filter_eq { all_rows ; batting style ; left hand bat } ; first class team ; windward islands } ; player } ; nixon mclean } } = true', 'tointer': 'select the rows whose batting style record fuzzily matches to left hand bat . among these rows , select the rows whose first class team record fuzzily matches to windward islands . there is only one such row in the table . the player record of this unqiue row is nixon mclean .'}
and { only { filter_eq { filter_eq { all_rows ; batting style ; left hand bat } ; first class team ; windward islands } } ; eq { hop { filter_eq { filter_eq { all_rows ; batting style ; left hand bat } ; first class team ; windward islands } ; player } ; nixon mclean } } = true
select the rows whose batting style record fuzzily matches to left hand bat . among these rows , select the rows whose first class team record fuzzily matches to windward islands . there is only one such row in the table . the player record of this unqiue row is nixon mclean .
{'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', 'batting style_8': 'batting style', 'left hand bat_9': 'left hand bat', 'first class team_10': 'first class team', 'windward islands_11': 'windward islands', 'str_eq_4': 'str_eq', 'str_hop_3': 'str_hop', 'player_12': 'player', 'nixon mclean_13': 'nixon mclean'}
['no', 'player', 'date of birth', 'batting style', 'bowling style', 'first class team']
[['59', 'brian lara ( captain )', '2 may 1969', 'left hand bat', 'right arm leg break googly', 'trinidad and tobago'], ['55', 'keith arthurton', '21 february 1965', 'left hand bat', 'left arm orthodox spin', 'leeward islands'], ['66', 'shivnarine chanderpaul', '16 august 1974', 'left hand bat', 'right arm leg break', 'guyana'], ['86', 'mervyn dillon', '5 june 1974', 'right hand bat', 'right arm fast - medium', 'trinidad and tobago'], ['50', 'carl hooper', '15 december 1966', 'right hand bat', 'right arm off break', 'guyana'], ['76', 'ridley jacobs ( wicket - keeper )', '26 november 1967', 'left hand bat', 'wicket - keeper', 'leeward islands'], ['89', 'reon king', '6 october 1975', 'right hand bat', 'right arm fast - medium', 'guyana'], ['58', 'clayton lambert', '10 february 1962', 'left hand bat', 'right arm off break', 'guyana'], ['85', 'rawl lewis', '5 september 1974', 'right hand bat', 'right arm leg break googly', 'windward islands'], ['78', 'nixon mclean', '20 july 1973', 'left hand bat', 'right arm fast', 'windward islands'], ['87', 'neil mcgarrell', '12 july 1972', 'right hand bat', 'left arm orthodox spin', 'guyana'], ['51', 'phil simmons', '18 april 1963', 'right hand bat', 'right arm medium', 'trinidad and tobago'], ['61', 'philo wallace', '2 august 1970', 'right hand bat', 'right arm medium', 'barbados'], ['68', 'stuart williams', '12 august 1969', 'right hand bat', 'right arm medium', 'leeward islands']]