lori chalupny
lori chalupny 's second goal was the only goal that happened in virginia beach .
{'scope': 'all', 'row': '2', 'col': '2', 'col_other': '1', 'criterion': 'fuzzily_match', 'value': 'virginia beach', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'location', 'virginia beach'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose location record fuzzily matches to virginia beach .', 'tostr': 'filter_eq { all_rows ; location ; virginia beach }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; location ; virginia beach } }', 'tointer': 'select the rows whose location record fuzzily matches to virginia beach . there is only one such row in the table .'}, {'func': 'eq', 'args': [{'func': 'num_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'location', 'virginia beach'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose location record fuzzily matches to virginia beach .', 'tostr': 'filter_eq { all_rows ; location ; virginia beach }'}, 'goal'], 'result': '2', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; location ; virginia beach } ; goal }'}, '2'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; location ; virginia beach } ; goal } ; 2 }', 'tointer': 'the goal record of this unqiue row is 2 .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; location ; virginia beach } } ; eq { hop { filter_eq { all_rows ; location ; virginia beach } ; goal } ; 2 } } = true', 'tointer': 'select the rows whose location record fuzzily matches to virginia beach . there is only one such row in the table . the goal record of this unqiue row is 2 .'}
and { only { filter_eq { all_rows ; location ; virginia beach } } ; eq { hop { filter_eq { all_rows ; location ; virginia beach } ; goal } ; 2 } } = true
select the rows whose location record fuzzily matches to virginia beach . there is only one such row in the table . the goal record of this unqiue row is 2 .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'location_7': 'location', 'virginia beach_8': 'virginia beach', 'eq_3': 'eq', 'num_hop_2': 'num_hop', 'goal_9': 'goal', '2_10': '2'}
['goal', 'location', 'lineup', 'assist / pass', 'score', 'result', 'competition']
[['1', 'usa albuquerque nm', "on 70 ' ( off lilly )", 'tarpley', '3 - 0', '3 - 0', 'friendly'], ['2', 'usa virginia beach', '90 . start', 'unassisted', '1 - 0', '2 - 0', 'friendly'], ['3', 'chn guangzhou', '90 . start', 'unassisted', '1 - 0', '2 - 0', 'four nations tournament'], ['4', 'usa frisco tx', "off 72 ' ( on wagner )", 'tarpley', '3 - 1', '6 - 2', 'friendly'], ['5', 'chn shanghai', '90 . start', 'wambach', '1 - 0', '1 - 0', 'world cup group b'], ['6', 'chn shanghai', '90 . start', 'unassisted', '3 - 0', '4 - 1', 'world cup final - third place playoff'], ['7', 'chn beijing', '90 . start', 'rodriguez', '2 - 1', '4 - 2', 'olympics tournament'], ['8', 'usa bridgeview il', '90 . start', 'tarpley', '1 - 0', '2 - 0', 'friendly']]