north melbourne football club
for the north melbourne football club , when the captain was a simpson , the only time the chairman was j magowan was in 2007 .
{'scope': 'subset', 'row': '8', 'col': '4', 'col_other': '1', 'criterion': 'equal', 'value': 'j magowan', 'subset': {'col': '7', 'criterion': 'equal', 'value': 'a simpson'}}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'captain', 'a simpson'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; captain ; a simpson }', 'tointer': 'select the rows whose captain record fuzzily matches to a simpson .'}, 'chairman', 'j magowan'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose captain record fuzzily matches to a simpson . among these rows , select the rows whose chairman record fuzzily matches to j magowan .', 'tostr': 'filter_eq { filter_eq { all_rows ; captain ; a simpson } ; chairman ; j magowan }'}], 'result': True, 'ind': 2, 'tostr': 'only { filter_eq { filter_eq { all_rows ; captain ; a simpson } ; chairman ; j magowan } }', 'tointer': 'select the rows whose captain record fuzzily matches to a simpson . among these rows , select the rows whose chairman record fuzzily matches to j magowan . there is only one such row in the table .'}, {'func': 'eq', 'args': [{'func': 'num_hop', 'args': [{'func': 'filter_str_eq', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'captain', 'a simpson'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; captain ; a simpson }', 'tointer': 'select the rows whose captain record fuzzily matches to a simpson .'}, 'chairman', 'j magowan'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose captain record fuzzily matches to a simpson . among these rows , select the rows whose chairman record fuzzily matches to j magowan .', 'tostr': 'filter_eq { filter_eq { all_rows ; captain ; a simpson } ; chairman ; j magowan }'}, 'year'], 'result': '2007', 'ind': 3, 'tostr': 'hop { filter_eq { filter_eq { all_rows ; captain ; a simpson } ; chairman ; j magowan } ; year }'}, '2007'], 'result': True, 'ind': 4, 'tostr': 'eq { hop { filter_eq { filter_eq { all_rows ; captain ; a simpson } ; chairman ; j magowan } ; year } ; 2007 }', 'tointer': 'the year record of this unqiue row is 2007 .'}], 'result': True, 'ind': 5, 'tostr': 'and { only { filter_eq { filter_eq { all_rows ; captain ; a simpson } ; chairman ; j magowan } } ; eq { hop { filter_eq { filter_eq { all_rows ; captain ; a simpson } ; chairman ; j magowan } ; year } ; 2007 } } = true', 'tointer': 'select the rows whose captain record fuzzily matches to a simpson . among these rows , select the rows whose chairman record fuzzily matches to j magowan . there is only one such row in the table . the year record of this unqiue row is 2007 .'}
and { only { filter_eq { filter_eq { all_rows ; captain ; a simpson } ; chairman ; j magowan } } ; eq { hop { filter_eq { filter_eq { all_rows ; captain ; a simpson } ; chairman ; j magowan } ; year } ; 2007 } } = true
select the rows whose captain record fuzzily matches to a simpson . among these rows , select the rows whose chairman record fuzzily matches to j magowan . there is only one such row in the table . the year record of this unqiue row is 2007 .
{'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', 'captain_8': 'captain', 'a simpson_9': 'a simpson', 'chairman_10': 'chairman', 'j magowan_11': 'j magowan', 'eq_4': 'eq', 'num_hop_3': 'num_hop', 'year_12': 'year', '2007_13': '2007'}
['year', 'w : l : d', 'position', 'chairman', 'ceo', 'coach', 'captain', 'vice - captain', 'best and fairest', 'leading goalkicker']
[['2000', '15:10:0', '4th', 'r p casey / a carter', 'g miller', 'd pagan', 'w carey', 'a stevens', 'p bell', 'w carey 69'], ['2001', '9:13:0', '13th', 'a carter / a aylett', 'g miller / m easy', 'd pagan', 'w carey', 'a stevens', 's grant', 's rocca 48'], ['2002', '12:11:0', '7th', 'a aylett', 'm easy / g walsh', 'd pagan', 'a stevens', 'g archer', 'a simpson', 's rocca 50'], ['2003', '11:10:1', '10th', 'a aylett', 'g walsh', 'd laidley', 'a stevens', 'g archer', 'b harvey', 'l harding 33'], ['2004', '10:12:0', '10th', 'a aylett', 'g walsh', 'd laidley', 'a simpson', 'b harvey', 'b rawlings', 's rocca 49'], ['2005', '13:10:0', '7th', 'a aylett / g duff', 'g walsh', 'd laidley', 'a simpson', 'b harvey', 'b harvey', 'n thompson 52'], ['2006', '7:15:0', '14th', 'g duff', 'g walsh / r aylett', 'd laidley', 'a simpson', 'b harvey', 'b rawlings', 'n thompson 54'], ['2007', '15:10:0', '3rd', 'g duff / j magowan / j brayshaw', 'r aylett', 'd laidley', 'a simpson', 'b harvey', 'b harvey', 'c jones 43'], ['2008', '12:10:1', '7th', 'j brayshaw', 'e arocca', 'd laidley', 'a simpson', 'b harvey', 'b harvey', 'd hale 37'], ['2009', '7:14:1', '13th', 'j brayshaw', 'e arocca', 'd laidley / d crocker', 'b harvey', 'd petrie', 'a swallow', 'd petrie 27'], ['2010', '11:11:0', '9th', 'j brayshaw', 'e arocca', 'b scott', 'b harvey', 'd petrie', 'b harvey , b rawlings', 'l thomas 29'], ['2011', '10:12:0', '9th', 'j brayshaw', 'e arocca', 'b scott', 'b harvey', 'd petrie', 'a swallow , d wells', 'd petrie 48'], ['2012', '14:8:0', '8th', 'j brayshaw', 'earocca / cvale', 'b scott', 'a swallow', 'd petrie , j ziebell', 'aswallow', 'd petrie 57']]