2006 japanese television dramas
the only 2006 japanese television drama with an average rating of 14.2 % is sapuri .
{'scope': 'all', 'row': '1', 'col': '5', 'col_other': '2', 'criterion': 'equal', 'value': '14.2 %', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'average ratings', '14.2 %'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose average ratings record fuzzily matches to 14.2 % .', 'tostr': 'filter_eq { all_rows ; average ratings ; 14.2 % }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; average ratings ; 14.2 % } }', 'tointer': 'select the rows whose average ratings record fuzzily matches to 14.2 % . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'average ratings', '14.2 %'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose average ratings record fuzzily matches to 14.2 % .', 'tostr': 'filter_eq { all_rows ; average ratings ; 14.2 % }'}, 'romaji title'], 'result': 'sapuri', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; average ratings ; 14.2 % } ; romaji title }'}, 'sapuri'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; average ratings ; 14.2 % } ; romaji title } ; sapuri }', 'tointer': 'the romaji title record of this unqiue row is sapuri .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; average ratings ; 14.2 % } } ; eq { hop { filter_eq { all_rows ; average ratings ; 14.2 % } ; romaji title } ; sapuri } } = true', 'tointer': 'select the rows whose average ratings record fuzzily matches to 14.2 % . there is only one such row in the table . the romaji title record of this unqiue row is sapuri .'}
and { only { filter_eq { all_rows ; average ratings ; 14.2 % } } ; eq { hop { filter_eq { all_rows ; average ratings ; 14.2 % } ; romaji title } ; sapuri } } = true
select the rows whose average ratings record fuzzily matches to 14.2 % . there is only one such row in the table . the romaji title record of this unqiue row is sapuri .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'average ratings_7': 'average ratings', '14.2%_8': '14.2 %', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'romaji title_9': 'romaji title', 'sapuri_10': 'sapuri'}
['japanese title', 'romaji title', 'tv station', 'episodes', 'average ratings']
[['サプリ', 'sapuri', 'fuji tv', '11', '14.2 %'], ['不信のとき ～ ウーマン ・ ウォーズ ～', 'fushin no toki ~ woman wars ~', 'fuji tv', '12', '12.9 %'], ['結婚できない男', 'kekkon dekinai otoko', 'fuji tv', '12', '17.1 %'], ['ダンドリ 。 ～ dance ☆ drill ～', 'dandori ~ dance ☆ drill ~', 'fuji tv', '11', '8.9 %'], ['誰よりもママを愛す', 'dare yorimo mama wo ai su', 'tbs', '11', '10.4 %'], ['花嫁は厄年ッ !', 'hanayome wa yakudoshi !', 'tbs', '12', '12.0 %'], ['タイヨウのうた', 'taiyou no uta', 'tbs', '10', '10.3 %'], ['レガッタ ～ 君といた永遠 ～', 'regatta ~ kimi to ita eien ~', 'tv - asahi', '9', '5.4 %'], ['下北サンデーズ', 'shimokita sundays', 'tv - asahi', '9', '7.3 %'], ['caとお呼びっ !', 'ca to oyobbi !', 'ntv', '11', '9.5 %'], ['マイ ☆ ボス マイ ☆ ヒーロー', 'my ☆ boss my ☆ hero', 'ntv', '10', '18.9 %']]