vc zenit - kazan
matthew anderson is the only player on the vc zenit - kazan team from the united states .
{'scope': 'all', 'row': '1', 'col': '2', 'col_other': '3', 'criterion': 'equal', 'value': 'united states', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'nationality', 'united states'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose nationality record fuzzily matches to united states .', 'tostr': 'filter_eq { all_rows ; nationality ; united states }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; nationality ; united states } }', 'tointer': 'select the rows whose nationality record fuzzily matches to united states . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'nationality', 'united states'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose nationality record fuzzily matches to united states .', 'tostr': 'filter_eq { all_rows ; nationality ; united states }'}, 'player'], 'result': 'matthew anderson', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; nationality ; united states } ; player }'}, 'matthew anderson'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; nationality ; united states } ; player } ; matthew anderson }', 'tointer': 'the player record of this unqiue row is matthew anderson .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; nationality ; united states } } ; eq { hop { filter_eq { all_rows ; nationality ; united states } ; player } ; matthew anderson } } = true', 'tointer': 'select the rows whose nationality record fuzzily matches to united states . there is only one such row in the table . the player record of this unqiue row is matthew anderson .'}
and { only { filter_eq { all_rows ; nationality ; united states } } ; eq { hop { filter_eq { all_rows ; nationality ; united states } ; player } ; matthew anderson } } = true
select the rows whose nationality record fuzzily matches to united states . there is only one such row in the table . the player record of this unqiue row is matthew anderson .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'nationality_7': 'nationality', 'united states_8': 'united states', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'player_9': 'player', 'matthew anderson_10': 'matthew anderson'}
['shirt no', 'nationality', 'player', 'birth date', 'height', 'position']
[['1', 'united states', 'matthew anderson', 'april 18 , 1987 ( age26 )', '204', 'outside hitter'], ['3', 'russia', 'nikolay apalikov', 'august 26 , 1982 ( age31 )', '203', 'middle blocker'], ['4', 'russia', 'ivan demakov', 'june 1 , 1993 ( age20 )', '209', 'middle blocker'], ['5', 'italy', 'valerio vermiglio', 'march 1 , 1976 ( age37 )', '189', 'setter'], ['6', 'russia', 'eugeniy sivozhelez', 'june 8 , 1986 ( age27 )', '196', 'outside hitter'], ['7', 'russia', 'aleksandr volkov', 'february 14 , 1985 ( age28 )', '210', 'middle blocker'], ['8', 'russia', 'igor kolodinsky', 'july 7 , 1983 ( age30 )', '197', 'setter'], ['9', 'russia', 'alexey cheremisin', 'september 23 , 1980 ( age33 )', '204', 'opposite hitter'], ['10', 'russia', 'yury berezhko', 'january 27 , 1981 ( age33 )', '198', 'outside hitter'], ['13', 'russia', 'vitaliy matychenko', 'august 4 , 1983 ( age30 )', '194', 'setter'], ['14', 'russia', 'alexander abrosimov', 'august 25 , 1983 ( age30 )', '207', 'middle blocker'], ['15', 'russia', 'alexey obmochaev', 'may 22 , 1989 ( age24 )', '188', 'libero'], ['17', 'russia', 'vladislav babichev', 'february 18 , 1981 ( age32 )', '185', 'libero']]