loonie
the special loonie from 2007 themed the trumpeter swan was the only one with an issued price of 45.95 .
{'scope': 'all', 'row': '5', 'col': '5', 'col_other': '1,2', 'criterion': 'equal', 'value': '45.95', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_eq', 'args': ['all_rows', 'issue price', '45.95'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose issue price record is equal to 45.95 .', 'tostr': 'filter_eq { all_rows ; issue price ; 45.95 }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; issue price ; 45.95 } }', 'tointer': 'select the rows whose issue price record is equal to 45.95 . there is only one such row in the table .'}, {'func': 'and', 'args': [{'func': 'eq', 'args': [{'func': 'num_hop', 'args': [{'func': 'filter_eq', 'args': ['all_rows', 'issue price', '45.95'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose issue price record is equal to 45.95 .', 'tostr': 'filter_eq { all_rows ; issue price ; 45.95 }'}, 'year'], 'result': '2007', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; issue price ; 45.95 } ; year }'}, '2007'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; issue price ; 45.95 } ; year } ; 2007 }', 'tointer': 'the year record of this unqiue row is 2007 .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_eq', 'args': ['all_rows', 'issue price', '45.95'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose issue price record is equal to 45.95 .', 'tostr': 'filter_eq { all_rows ; issue price ; 45.95 }'}, 'theme'], 'result': 'trumpeter swan', 'ind': 4, 'tostr': 'hop { filter_eq { all_rows ; issue price ; 45.95 } ; theme }'}, 'trumpeter swan'], 'result': True, 'ind': 5, 'tostr': 'eq { hop { filter_eq { all_rows ; issue price ; 45.95 } ; theme } ; trumpeter swan }', 'tointer': 'the theme record of this unqiue row is trumpeter swan .'}], 'result': True, 'ind': 6, 'tostr': 'and { eq { hop { filter_eq { all_rows ; issue price ; 45.95 } ; year } ; 2007 } ; eq { hop { filter_eq { all_rows ; issue price ; 45.95 } ; theme } ; trumpeter swan } }', 'tointer': 'the year record of this unqiue row is 2007 . the theme record of this unqiue row is trumpeter swan .'}], 'result': True, 'ind': 7, 'tostr': 'and { only { filter_eq { all_rows ; issue price ; 45.95 } } ; and { eq { hop { filter_eq { all_rows ; issue price ; 45.95 } ; year } ; 2007 } ; eq { hop { filter_eq { all_rows ; issue price ; 45.95 } ; theme } ; trumpeter swan } } } = true', 'tointer': 'select the rows whose issue price record is equal to 45.95 . there is only one such row in the table . the year record of this unqiue row is 2007 . the theme record of this unqiue row is trumpeter swan .'}
and { only { filter_eq { all_rows ; issue price ; 45.95 } } ; and { eq { hop { filter_eq { all_rows ; issue price ; 45.95 } ; year } ; 2007 } ; eq { hop { filter_eq { all_rows ; issue price ; 45.95 } ; theme } ; trumpeter swan } } } = true
select the rows whose issue price record is equal to 45.95 . there is only one such row in the table . the year record of this unqiue row is 2007 . the theme record of this unqiue row is trumpeter swan .
{'and_7': 'and', 'result_8': 'true', 'only_1': 'only', 'filter_eq_0': 'filter_eq', 'all_rows_9': 'all_rows', 'issue price_10': 'issue price', '45.95_11': '45.95', 'and_6': 'and', 'eq_3': 'eq', 'num_hop_2': 'num_hop', 'year_12': 'year', '2007_13': '2007', 'str_eq_5': 'str_eq', 'str_hop_4': 'str_hop', 'theme_14': 'theme', 'trumpeter swan_15': 'trumpeter swan'}
['year', 'theme', 'artist', 'mintage', 'issue price']
[['2002', '15th anniversary loonie', 'dora de pãdery - hunt', '67672', '39.95'], ['2004', 'jack miner bird sanctuary', 'susan taylor', '46493', '39.95'], ['2005', 'tufted puffin', 'n / a', '39818', '39.95'], ['2006', 'snowy owl', 'glen loates', '39935', '44.95'], ['2007', 'trumpeter swan', 'kerri burnett', '40000', '45.95'], ['2008', 'common eider', 'mark hobson', '40000', '47.95'], ['2009', 'great blue heron', 'chris jordison', '40000', '47.95'], ['2010', 'northern harrier', 'arnold nogy', '35000', '49.95'], ['2011', 'great gray owl', 'arnold nogy', '35000', '49.95'], ['2012', '25th anniversary loonie', 'arnold nogy', '35000', '49.95']]