lexington legends
the 2013 season was the only year where kansas city was the mlb affiliate for the lexington legends .
{'scope': 'all', 'row': '13', 'col': '7', 'col_other': '1', 'criterion': 'equal', 'value': 'kansas city', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'mlb affiliate', 'kansas city'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose mlb affiliate record fuzzily matches to kansas city .', 'tostr': 'filter_eq { all_rows ; mlb affiliate ; kansas city }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; mlb affiliate ; kansas city } }', 'tointer': 'select the rows whose mlb affiliate record fuzzily matches to kansas city . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'mlb affiliate', 'kansas city'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose mlb affiliate record fuzzily matches to kansas city .', 'tostr': 'filter_eq { all_rows ; mlb affiliate ; kansas city }'}, 'season'], 'result': '2013', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; mlb affiliate ; kansas city } ; season }'}, '2013'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; mlb affiliate ; kansas city } ; season } ; 2013 }', 'tointer': 'the season record of this unqiue row is 2013 .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; mlb affiliate ; kansas city } } ; eq { hop { filter_eq { all_rows ; mlb affiliate ; kansas city } ; season } ; 2013 } } = true', 'tointer': 'select the rows whose mlb affiliate record fuzzily matches to kansas city . there is only one such row in the table . the season record of this unqiue row is 2013 .'}
and { only { filter_eq { all_rows ; mlb affiliate ; kansas city } } ; eq { hop { filter_eq { all_rows ; mlb affiliate ; kansas city } ; season } ; 2013 } } = true
select the rows whose mlb affiliate record fuzzily matches to kansas city . there is only one such row in the table . the season record of this unqiue row is 2013 .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'mlb affiliate_7': 'mlb affiliate', 'kansas city_8': 'kansas city', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'season_9': 'season', '2013_10': '2013'}
['season', 'manager', 'record', 'win %', 'post - season record', 'post - season win %', 'mlb affiliate']
[['2001', 'joe cannon', '92 - 48', '657', '4 - 0', '1.000', 'houston'], ['2002', 'joe cannon', '81 - 59', '579', '-', '-', 'houston'], ['2003 ♦', 'russ nixon', '75 - 63', '543', '0 - 2', '000', 'houston'], ['2004', 'iván dejesús', '68 - 72', '486', '-', '-', 'houston'], ['2005', 'tim bogar', '81 - 58', '583', '-', '-', 'houston'], ['2006 ♦', 'jack lind', '75 - 63', '543', '0 - 2', '000', 'houston'], ['2007', 'gregg langbehn', '59 - 81', '421', '-', '-', 'houston'], ['2008', 'gregg langbehn', '45 - 93', '326', '-', '-', 'houston'], ['2009', 'tom lawless', '68 - 72', '486', '-', '-', 'houston'], ['2010', 'rodney linares', '71 - 68', '511', '-', '-', 'houston'], ['2011', 'rodney linares', '59 - 79', '428', '-', '-', 'houston'], ['2012', 'iván dejesús', '69 - 69', '500', '-', '-', 'houston'], ['2013', 'brian buchanan', '44 - 42', '512', '-', '-', 'kansas city']]