joão barbosa
2004 was the only year that that joão barbosa had a dnf position .
{'scope': 'all', 'row': '1', 'col': '6', 'col_other': '1', 'criterion': 'equal', 'value': 'dnf', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'pos', 'dnf'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose pos record fuzzily matches to dnf .', 'tostr': 'filter_eq { all_rows ; pos ; dnf }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; pos ; dnf } }', 'tointer': 'select the rows whose pos record fuzzily matches to dnf . there is only one such row in the table .'}, {'func': 'eq', 'args': [{'func': 'num_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'pos', 'dnf'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose pos record fuzzily matches to dnf .', 'tostr': 'filter_eq { all_rows ; pos ; dnf }'}, 'year'], 'result': '2004', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; pos ; dnf } ; year }'}, '2004'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; pos ; dnf } ; year } ; 2004 }', 'tointer': 'the year record of this unqiue row is 2004 .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; pos ; dnf } } ; eq { hop { filter_eq { all_rows ; pos ; dnf } ; year } ; 2004 } } = true', 'tointer': 'select the rows whose pos record fuzzily matches to dnf . there is only one such row in the table . the year record of this unqiue row is 2004 .'}
and { only { filter_eq { all_rows ; pos ; dnf } } ; eq { hop { filter_eq { all_rows ; pos ; dnf } ; year } ; 2004 } } = true
select the rows whose pos record fuzzily matches to dnf . there is only one such row in the table . the year record of this unqiue row is 2004 .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'pos_7': 'pos', 'dnf_8': 'dnf', 'eq_3': 'eq', 'num_hop_2': 'num_hop', 'year_9': 'year', '2004_10': '2004'}
['year', 'team', 'co - drivers', 'class', 'laps', 'pos', 'class pos']
[['2004', 'rollcentre racing', 'martin short rob barff', 'lmp1', '230', 'dnf', 'dnf'], ['2005', 'rollcentre racing', 'martin short vanina ickx', 'lmp1', '318', '16th', '8th'], ['2006', 'rollcentre racing', 'martin short stuart moseley', 'lmp2', '294', '20th', '5th'], ['2007', 'rollcentre racing', 'stuart hall martin short', 'lmp1', '347', '4th', '4th'], ['2008', 'rollcentre racing', 'stéphan grégoire vanina ickx', 'lmp1', '352', '11th', '10th'], ['2009', 'pescarolo sport', 'christophe tinseau bruce jouanny', 'lmp1', '368', '8th', '8th'], ['2011', 'level 5 motorsports', 'scott tucker christophe bouchut', 'lmp2', '319', '10th', '3rd']]