gulf coast league orioles
in the only season where they were managed by tommy shields , the orioles finished in 4th place .
{'scope': 'all', 'row': '7', 'col': '4', 'col_other': '3', 'criterion': 'equal', 'value': 'tommy shields', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'manager', 'tommy shields'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose manager record fuzzily matches to tommy shields .', 'tostr': 'filter_eq { all_rows ; manager ; tommy shields }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; manager ; tommy shields } }', 'tointer': 'select the rows whose manager record fuzzily matches to tommy shields . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'manager', 'tommy shields'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose manager record fuzzily matches to tommy shields .', 'tostr': 'filter_eq { all_rows ; manager ; tommy shields }'}, 'finish'], 'result': '4th', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; manager ; tommy shields } ; finish }'}, '4th'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; manager ; tommy shields } ; finish } ; 4th }', 'tointer': 'the finish record of this unqiue row is 4th .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; manager ; tommy shields } } ; eq { hop { filter_eq { all_rows ; manager ; tommy shields } ; finish } ; 4th } } = true', 'tointer': 'select the rows whose manager record fuzzily matches to tommy shields . there is only one such row in the table . the finish record of this unqiue row is 4th .'}
and { only { filter_eq { all_rows ; manager ; tommy shields } } ; eq { hop { filter_eq { all_rows ; manager ; tommy shields } ; finish } ; 4th } } = true
select the rows whose manager record fuzzily matches to tommy shields . there is only one such row in the table . the finish record of this unqiue row is 4th .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'manager_7': 'manager', 'tommy shields_8': 'tommy shields', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'finish_9': 'finish', '4th_10': '4th'}
['year', 'record', 'finish', 'manager', 'playoffs']
[['gcl orioles ( 1991 - 2003 )', 'gcl orioles ( 1991 - 2003 )', 'gcl orioles ( 1991 - 2003 )', 'gcl orioles ( 1991 - 2003 )', 'gcl orioles ( 1991 - 2003 )'], ['1991', '35 - 24', '1st', 'ed napoleon', 'lost league finals'], ['1992', '29 - 29', '9th', 'phillip wellman', 'missed'], ['1993', '30 - 28', '8th', 'oneri fleita', 'missed'], ['1994', '23 - 36', '12th', 'oneri fleita', 'missed'], ['1995', '34 - 25', '7th', 'julio garcia', 'missed'], ['1996', '36 - 24', '4th', 'tommy shields', 'missed'], ['1997', '27 - 33', '10th', 'butch davis', 'missed'], ['1998', '28 - 32', '8th ( t )', 'butch davis', 'missed'], ['1999', '31 - 28', '6th', 'jesus alfaro', 'missed'], ['2000', '25 - 31', '9th', 'jesus alfaro', 'missed'], ['2001', '22 - 34', '11th ( t )', 'jesus alfaro', 'missed'], ['2002', '24 - 36', '12th', 'jesus alfaro', 'missed'], ['2003', '32 - 28', '4th', 'jesus alfaro', 'missed'], ['gcl orioles ( 2007 - present )', 'gcl orioles ( 2007 - present )', 'gcl orioles ( 2007 - present )', 'gcl orioles ( 2007 - present )', 'gcl orioles ( 2007 - present )'], ['2007', '32 - 24', '2nd east', 'orlando gomez', 'missed']]