outcasts ( tv series )
episode 7 was the only episode that had an original air date in the month of march .
{'scope': 'all', 'row': '7', 'col': '7', 'col_other': '1,2', 'criterion': 'fuzzily_match', 'value': 'march', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'original air date', 'march'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose original air date record fuzzily matches to march .', 'tostr': 'filter_eq { all_rows ; original air date ; march }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; original air date ; march } }', 'tointer': 'select the rows whose original air date record fuzzily matches to march . 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', 'original air date', 'march'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose original air date record fuzzily matches to march .', 'tostr': 'filter_eq { all_rows ; original air date ; march }'}, 'episode'], 'result': '7', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; original air date ; march } ; episode }'}, '7'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; original air date ; march } ; episode } ; 7 }', 'tointer': 'the episode record of this unqiue row is 7 .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'original air date', 'march'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose original air date record fuzzily matches to march .', 'tostr': 'filter_eq { all_rows ; original air date ; march }'}, 'title'], 'result': 'episode 7', 'ind': 4, 'tostr': 'hop { filter_eq { all_rows ; original air date ; march } ; title }'}, 'episode 7'], 'result': True, 'ind': 5, 'tostr': 'eq { hop { filter_eq { all_rows ; original air date ; march } ; title } ; episode 7 }', 'tointer': 'the title record of this unqiue row is episode 7 .'}], 'result': True, 'ind': 6, 'tostr': 'and { eq { hop { filter_eq { all_rows ; original air date ; march } ; episode } ; 7 } ; eq { hop { filter_eq { all_rows ; original air date ; march } ; title } ; episode 7 } }', 'tointer': 'the episode record of this unqiue row is 7 . the title record of this unqiue row is episode 7 .'}], 'result': True, 'ind': 7, 'tostr': 'and { only { filter_eq { all_rows ; original air date ; march } } ; and { eq { hop { filter_eq { all_rows ; original air date ; march } ; episode } ; 7 } ; eq { hop { filter_eq { all_rows ; original air date ; march } ; title } ; episode 7 } } } = true', 'tointer': 'select the rows whose original air date record fuzzily matches to march . there is only one such row in the table . the episode record of this unqiue row is 7 . the title record of this unqiue row is episode 7 .'}
and { only { filter_eq { all_rows ; original air date ; march } } ; and { eq { hop { filter_eq { all_rows ; original air date ; march } ; episode } ; 7 } ; eq { hop { filter_eq { all_rows ; original air date ; march } ; title } ; episode 7 } } } = true
select the rows whose original air date record fuzzily matches to march . there is only one such row in the table . the episode record of this unqiue row is 7 . the title record of this unqiue row is episode 7 .
{'and_7': 'and', 'result_8': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_9': 'all_rows', 'original air date_10': 'original air date', 'march_11': 'march', 'and_6': 'and', 'eq_3': 'eq', 'num_hop_2': 'num_hop', 'episode_12': 'episode', '7_13': '7', 'str_eq_5': 'str_eq', 'str_hop_4': 'str_hop', 'title_14': 'title', 'episode 7_15': 'episode 7'}
['episode', 'title', 'directed by', 'written by', 'uk viewers ( million )', 'share ( % )', 'original air date']
[['1', 'episode 1', 'bharat nalluri', 'ben richards', '4.50', '17.9', '7 february 2011'], ['2', 'episode 2', 'bharat nalluri', 'ben richards', '3.30', '13.0', '8 february 2011'], ['3', 'episode 3', 'omar madha', 'ben richards and simon block', '2.95', '11.8', '14 february 2011'], ['4', 'episode 4', 'omar madha', 'jack lothian', '2.63', '10.05', '15 february 2011'], ['5', 'episode 5', 'andy goddard', 'ben richards and jimmy gardner', '2.70', '10.8', '21 february 2011'], ['6', 'episode 6', 'andy goddard', 'david farr', '1.52', '10.5', '27 february 2011'], ['7', 'episode 7', 'jamie payne', 'david farr', '1.33', '9.7', '6 march 2011']]