list of covert affairs episodes
for covert affairs episodes , of the episodes that originally aired in august , the only one written by dana calvo was the one titled houses of the holy .
{'scope': 'subset', 'row': '6', 'col': '4', 'col_other': '2', 'criterion': 'equal', 'value': 'dana calvo', 'subset': {'col': '5', 'criterion': 'fuzzily_match', 'value': 'august'}}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'original air date', 'august'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; original air date ; august }', 'tointer': 'select the rows whose original air date record fuzzily matches to august .'}, 'written by', 'dana calvo'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose original air date record fuzzily matches to august . among these rows , select the rows whose written by record fuzzily matches to dana calvo .', 'tostr': 'filter_eq { filter_eq { all_rows ; original air date ; august } ; written by ; dana calvo }'}], 'result': True, 'ind': 2, 'tostr': 'only { filter_eq { filter_eq { all_rows ; original air date ; august } ; written by ; dana calvo } }', 'tointer': 'select the rows whose original air date record fuzzily matches to august . among these rows , select the rows whose written by record fuzzily matches to dana calvo . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'original air date', 'august'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; original air date ; august }', 'tointer': 'select the rows whose original air date record fuzzily matches to august .'}, 'written by', 'dana calvo'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose original air date record fuzzily matches to august . among these rows , select the rows whose written by record fuzzily matches to dana calvo .', 'tostr': 'filter_eq { filter_eq { all_rows ; original air date ; august } ; written by ; dana calvo }'}, 'title'], 'result': 'houses of the holy', 'ind': 3, 'tostr': 'hop { filter_eq { filter_eq { all_rows ; original air date ; august } ; written by ; dana calvo } ; title }'}, 'houses of the holy'], 'result': True, 'ind': 4, 'tostr': 'eq { hop { filter_eq { filter_eq { all_rows ; original air date ; august } ; written by ; dana calvo } ; title } ; houses of the holy }', 'tointer': 'the title record of this unqiue row is houses of the holy .'}], 'result': True, 'ind': 5, 'tostr': 'and { only { filter_eq { filter_eq { all_rows ; original air date ; august } ; written by ; dana calvo } } ; eq { hop { filter_eq { filter_eq { all_rows ; original air date ; august } ; written by ; dana calvo } ; title } ; houses of the holy } } = true', 'tointer': 'select the rows whose original air date record fuzzily matches to august . among these rows , select the rows whose written by record fuzzily matches to dana calvo . there is only one such row in the table . the title record of this unqiue row is houses of the holy .'}
and { only { filter_eq { filter_eq { all_rows ; original air date ; august } ; written by ; dana calvo } } ; eq { hop { filter_eq { filter_eq { all_rows ; original air date ; august } ; written by ; dana calvo } ; title } ; houses of the holy } } = true
select the rows whose original air date record fuzzily matches to august . among these rows , select the rows whose written by record fuzzily matches to dana calvo . there is only one such row in the table . the title record of this unqiue row is houses of the holy .
{'and_5': 'and', 'result_6': 'true', 'only_2': 'only', 'filter_str_eq_1': 'filter_str_eq', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_7': 'all_rows', 'original air date_8': 'original air date', 'august_9': 'august', 'written by_10': 'written by', 'dana calvo_11': 'dana calvo', 'str_eq_4': 'str_eq', 'str_hop_3': 'str_hop', 'title_12': 'title', 'houses of the holy_13': 'houses of the holy'}
['series', 'title', 'directed by', 'written by', 'original air date', 'production code', 'us viewers ( million )']
[['1', 'pilot welcome to the cia', 'tim matheson', 'matt corman & chris ord', 'july 13 , 2010', 'ca101', '4.88'], ['2', "walter 's walk", 'félix alcalá', 'matt corman & chris ord', 'july 20 , 2010', 'ca102', '5.21'], ['3', 'south bound suarez', 'john kretchmer', 'james parriott', 'july 27 , 2010', 'ca103', '4.83'], ['4', 'no quarter', 'allan kroeker', 'stephen hootstein', 'august 3 , 2010', 'ca104', '5.30'], ['5', 'in the light', 'jonathan glassner', 'meredith lavender & marcie ulin', 'august 10 , 2010', 'ca105', '5.17'], ['6', 'houses of the holy', 'alex chapple', 'dana calvo', 'august 17 , 2010', 'ca106', '5.36'], ['7', 'communication breakdown', 'kate woods', 'matthew lau', 'august 24 , 2010', 'ca107', '5.87'], ['8', 'what is and what should never be', 'rod hardy', 'brett conrad', 'august 31 , 2010', 'ca108', '5.26'], ['9', 'fool in the rain', 'vincent misiano', 'stephen hootstein', 'september 7 , 2010', 'ca109', '5.40'], ['10', "i ca n't quit you baby", 'ken girotti', 'james parriott', 'september 14 , 2010', 'ca110', '4.59']]