colin morgan
2008 was the only year colin morgan won a newcomer award .
{'scope': 'all', 'row': '1', 'col': '3', 'col_other': '1,5', 'criterion': 'fuzzily_match', 'value': 'newcomer', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'category', 'newcomer'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose category record fuzzily matches to newcomer .', 'tostr': 'filter_eq { all_rows ; category ; newcomer }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; category ; newcomer } }', 'tointer': 'select the rows whose category record fuzzily matches to newcomer . there is only one such row in the table .'}, {'func': 'and', 'args': [{'func': 'eq', 'args': [{'func': 'num_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'category', 'newcomer'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose category record fuzzily matches to newcomer .', 'tostr': 'filter_eq { all_rows ; category ; newcomer }'}, 'year'], 'result': '2008', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; category ; newcomer } ; year }'}, '2008'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; category ; newcomer } ; year } ; 2008 }', 'tointer': 'the year record of this unqiue row is 2008 .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'category', 'newcomer'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose category record fuzzily matches to newcomer .', 'tostr': 'filter_eq { all_rows ; category ; newcomer }'}, 'result'], 'result': 'won', 'ind': 4, 'tostr': 'hop { filter_eq { all_rows ; category ; newcomer } ; result }'}, 'won'], 'result': True, 'ind': 5, 'tostr': 'eq { hop { filter_eq { all_rows ; category ; newcomer } ; result } ; won }', 'tointer': 'the result record of this unqiue row is won .'}], 'result': True, 'ind': 6, 'tostr': 'and { eq { hop { filter_eq { all_rows ; category ; newcomer } ; year } ; 2008 } ; eq { hop { filter_eq { all_rows ; category ; newcomer } ; result } ; won } }', 'tointer': 'the year record of this unqiue row is 2008 . the result record of this unqiue row is won .'}], 'result': True, 'ind': 7, 'tostr': 'and { only { filter_eq { all_rows ; category ; newcomer } } ; and { eq { hop { filter_eq { all_rows ; category ; newcomer } ; year } ; 2008 } ; eq { hop { filter_eq { all_rows ; category ; newcomer } ; result } ; won } } } = true', 'tointer': 'select the rows whose category record fuzzily matches to newcomer . there is only one such row in the table . the year record of this unqiue row is 2008 . the result record of this unqiue row is won .'}
and { only { filter_eq { all_rows ; category ; newcomer } } ; and { eq { hop { filter_eq { all_rows ; category ; newcomer } ; year } ; 2008 } ; eq { hop { filter_eq { all_rows ; category ; newcomer } ; result } ; won } } } = true
select the rows whose category record fuzzily matches to newcomer . there is only one such row in the table . the year record of this unqiue row is 2008 . the result record of this unqiue row is won .
{'and_7': 'and', 'result_8': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_9': 'all_rows', 'category_10': 'category', 'newcomer_11': 'newcomer', 'and_6': 'and', 'eq_3': 'eq', 'num_hop_2': 'num_hop', 'year_12': 'year', '2008_13': '2008', 'str_eq_5': 'str_eq', 'str_hop_4': 'str_hop', 'result_14': 'result', 'won_15': 'won'}
['year', 'award', 'category', 'role', 'result']
[['2008', 'variety club showbiz awards', 'outstanding newcomer', 'merlin in merlin', 'won'], ['2009', 'monte carlo tv festival awards', 'outstanding actor ( drama )', 'merlin in merlin', 'nominated'], ['2010', 'monte carlo tv festival awards', 'outstanding actor ( drama )', 'merlin in merlin', 'nominated'], ['2011', 'monte carlo tv festival awards', 'outstanding actor ( drama )', 'merlin in merlin', 'nominated'], ['2012', 'virgin media tv awards', 'best actor', 'merlin in merlin', 'won'], ['2013', 'national television award', 'drama performance : male', 'merlin in merlin', 'won']]