list of csi : ny characters
on csi : ny , mac taylor appeared in more episodes than jo danville .
{'row_1': '1', 'row_2': '2', 'col': '6', 'col_other': '1', 'relation': 'greater', 'record_mentioned': 'no', 'diff_result': None}
{'func': 'greater', 'args': [{'func': 'num_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'character', 'mac taylor csi detective'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose character record fuzzily matches to mac taylor csi detective .', 'tostr': 'filter_eq { all_rows ; character ; mac taylor csi detective }'}, 'episodes'], 'result': None, 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; character ; mac taylor csi detective } ; episodes }', 'tointer': 'select the rows whose character record fuzzily matches to mac taylor csi detective . take the episodes record of this row .'}, {'func': 'num_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'character', 'jo danville csi detective'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose character record fuzzily matches to jo danville csi detective .', 'tostr': 'filter_eq { all_rows ; character ; jo danville csi detective }'}, 'episodes'], 'result': None, 'ind': 3, 'tostr': 'hop { filter_eq { all_rows ; character ; jo danville csi detective } ; episodes }', 'tointer': 'select the rows whose character record fuzzily matches to jo danville csi detective . take the episodes record of this row .'}], 'result': True, 'ind': 4, 'tostr': 'greater { hop { filter_eq { all_rows ; character ; mac taylor csi detective } ; episodes } ; hop { filter_eq { all_rows ; character ; jo danville csi detective } ; episodes } } = true', 'tointer': 'select the rows whose character record fuzzily matches to mac taylor csi detective . take the episodes record of this row . select the rows whose character record fuzzily matches to jo danville csi detective . take the episodes record of this row . the first record is greater than the second record .'}
greater { hop { filter_eq { all_rows ; character ; mac taylor csi detective } ; episodes } ; hop { filter_eq { all_rows ; character ; jo danville csi detective } ; episodes } } = true
select the rows whose character record fuzzily matches to mac taylor csi detective . take the episodes record of this row . select the rows whose character record fuzzily matches to jo danville csi detective . take the episodes record of this row . the first record is greater than the second record .
{'greater_4': 'greater', 'result_5': 'true', 'num_hop_2': 'num_hop', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'character_7': 'character', 'mac taylor csi detective_8': 'mac taylor csi detective', 'episodes_9': 'episodes', 'num_hop_3': 'num_hop', 'filter_str_eq_1': 'filter_str_eq', 'all_rows_10': 'all_rows', 'character_11': 'character', 'jo danville csi detective_12': 'jo danville csi detective', 'episodes_13': 'episodes'}
['character', 'portrayed by', 'first appearance', 'last appearance', 'duration', 'episodes']
[['mac taylor csi detective', 'gary sinise', 'blink 1 , 2 , 3', 'today is life', '1.01 - 9.17', '197'], ['jo danville csi detective', 'sela ward', 'the 34th floor', 'today is life', '7.01 - 9.17', '57'], ['danny messer csi detective', 'carmine giovinazzo', 'blink 1', 'today is life', '1.01 - 9.17', '197'], ['lindsay monroe messer csi detective', 'anna belknap', 'zoo york', 'today is life', '2.03 - 9.17', '172 4'], ['dr sid hammerback chief medical examiner', 'robert joy', 'dancing with the fishes', 'today is life', '2.05 - 9.17', '168 4'], ['adam ross lab technician', 'a j buckley', 'bad beat', 'today is life', '2.08 - 9.17', '141 4'], ['dr sheldon hawkes csi', 'hill harper', 'blink 1', 'today is life', '1.01 - 9.17', '197'], ['don flack homicide detective', 'eddie cahill', 'blink', 'today is life', '1.01 - 9.17', '197'], ['aiden burn csi detective', 'vanessa ferlito', 'blink 1', 'heroes', '1.01 - 2.02 , 2.23', '26']]