fringe ( season 1 )
the only episode to have more than 12 million viewers was the transformation .
{'scope': 'all', 'row': '11', 'col': '7', 'col_other': '2', 'criterion': 'greater_than', 'value': '12', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_greater', 'args': ['all_rows', 'us viewers ( million )', '12'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose us viewers ( million ) record is greater than 12 .', 'tostr': 'filter_greater { all_rows ; us viewers ( million ) ; 12 }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_greater { all_rows ; us viewers ( million ) ; 12 } }', 'tointer': 'select the rows whose us viewers ( million ) record is greater than 12 . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_greater', 'args': ['all_rows', 'us viewers ( million )', '12'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose us viewers ( million ) record is greater than 12 .', 'tostr': 'filter_greater { all_rows ; us viewers ( million ) ; 12 }'}, 'title'], 'result': 'the transformation', 'ind': 2, 'tostr': 'hop { filter_greater { all_rows ; us viewers ( million ) ; 12 } ; title }'}, 'the transformation'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_greater { all_rows ; us viewers ( million ) ; 12 } ; title } ; the transformation }', 'tointer': 'the title record of this unqiue row is the transformation .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_greater { all_rows ; us viewers ( million ) ; 12 } } ; eq { hop { filter_greater { all_rows ; us viewers ( million ) ; 12 } ; title } ; the transformation } } = true', 'tointer': 'select the rows whose us viewers ( million ) record is greater than 12 . there is only one such row in the table . the title record of this unqiue row is the transformation .'}
and { only { filter_greater { all_rows ; us viewers ( million ) ; 12 } } ; eq { hop { filter_greater { all_rows ; us viewers ( million ) ; 12 } ; title } ; the transformation } } = true
select the rows whose us viewers ( million ) record is greater than 12 . there is only one such row in the table . the title record of this unqiue row is the transformation .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_greater_0': 'filter_greater', 'all_rows_6': 'all_rows', 'us viewers (million)_7': 'us viewers ( million )', '12_8': '12', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'title_9': 'title', 'the transformation_10': 'the transformation'}
['-', 'title', 'directed by', 'written by', 'original air date', 'production code', 'us viewers ( million )']
[['1', 'pilot', 'alex graves', 'j j abrams & alex kurtzman & roberto orci', 'september 9 , 2008', '276038', '9.13'], ['3', 'the ghost network', 'frederick e o toye', 'david h goodman & j r orci', 'september 23 , 2008', '3t7652', '9.42'], ['4', 'the arrival', 'paul edwards', 'j j abrams & jeff pinkner', 'september 30 , 2008', '3t7653', '9.91'], ['5', 'power hungry', 'christopher misiano', 'jason cahill & julia cho', 'october 14 , 2008', '3t7654', '9.16'], ['6', 'the cure', 'bill eagles', 'felicia d henderson & brad caleb kane', 'october 21 , 2008', '3t7655', '8.91'], ['7', 'in which we meet mr jones', 'brad anderson', 'j j abrams & jeff pinkner', 'november 11 , 2008', '3t7656', '8.61'], ['8', 'the equation', 'gwyneth horder - payton', 'j r orci & david h goodman', 'november 18 , 2008', '3t7657', '9.18'], ['9', 'the dreamscape', 'frederick e o toye', 'zack whedon & julia cho', 'november 25 , 2008', '3t7658', '7.70'], ['10', 'safe', 'michael zinberg', 'david h goodman & jason cahill', 'december 2 , 2008', '3t7659', '8.54'], ['12', 'the no - brainer', 'john polson', 'david h goodman & brad caleb kane', 'january 27 , 2009', '3t7661', '11.62'], ['13', 'the transformation', 'brad anderson', 'zack whedon & j r orci', 'february 3 , 2009', '3t7662', '12.78'], ['15', 'inner child', 'frederick e o toye', 'brad caleb kane & julia cho', 'april 7 , 2009', '3t7664', '9.88'], ['16', 'unleashed', 'brad anderson', 'zack whedon & j r orci', 'april 14 , 2009', '3t7665', '10.15'], ['17', 'bad dreams', 'akiva goldsman', 'akiva goldsman', 'april 21 , 2009', '3t7666', '9.89']]