the chicago code
the pilot episode was the only time more than 9 million viewers watched the show .
{'scope': 'all', 'row': '1', 'col': '7', 'col_other': '2', 'criterion': 'greater_than', 'value': '9.0', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_greater', 'args': ['all_rows', 'us viewers ( million )', '9.0'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose us viewers ( million ) record is greater than 9.0 .', 'tostr': 'filter_greater { all_rows ; us viewers ( million ) ; 9.0 }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_greater { all_rows ; us viewers ( million ) ; 9.0 } }', 'tointer': 'select the rows whose us viewers ( million ) record is greater than 9.0 . 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 )', '9.0'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose us viewers ( million ) record is greater than 9.0 .', 'tostr': 'filter_greater { all_rows ; us viewers ( million ) ; 9.0 }'}, 'title'], 'result': 'pilot', 'ind': 2, 'tostr': 'hop { filter_greater { all_rows ; us viewers ( million ) ; 9.0 } ; title }'}, 'pilot'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_greater { all_rows ; us viewers ( million ) ; 9.0 } ; title } ; pilot }', 'tointer': 'the title record of this unqiue row is pilot .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_greater { all_rows ; us viewers ( million ) ; 9.0 } } ; eq { hop { filter_greater { all_rows ; us viewers ( million ) ; 9.0 } ; title } ; pilot } } = true', 'tointer': 'select the rows whose us viewers ( million ) record is greater than 9.0 . there is only one such row in the table . the title record of this unqiue row is pilot .'}
and { only { filter_greater { all_rows ; us viewers ( million ) ; 9.0 } } ; eq { hop { filter_greater { all_rows ; us viewers ( million ) ; 9.0 } ; title } ; pilot } } = true
select the rows whose us viewers ( million ) record is greater than 9.0 . there is only one such row in the table . the title record of this unqiue row is pilot .
{'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 )', '9.0_8': '9.0', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'title_9': 'title', 'pilot_10': 'pilot'}
['no', 'title', 'directed by', 'written by', 'original air date', 'production code', 'us viewers ( million )']
[['1', 'pilot', 'charles mcdougall', 'shawn ryan', 'february 7 , 2011', '1ata79', '9.43'], ['2', 'hog butcher', 'clark johnson', 'patrick massett & john zinman', 'february 14 , 2011', '1ata01', '7.35'], ['3', 'gillis , chase & babyface', 'guy ferland', 'davey holmes', 'february 21 , 2011', '1ata09', '7.87'], ['4', 'cabrini - green', 'jean de segonzac', 'tim minear & jon worley', 'february 28 , 2011', '1ata10', '8.04'], ['5', "o'leary 's cow", 'clark johnson', 'kevin townsley', 'march 7 , 2011', '1ata03', '7.46'], ['6', 'the gold coin kid', 'lesli linka glatter', 'heather mitchell', 'march 14 , 2011', '1ata02', '7.30'], ['7', 'black hand and the shotgun man', 'billy gierhart', 'davey holmes', 'march 21 , 2011', '1ata04', '6.16'], ['8', 'wild onions', 'adam arkin', 'virgil williams', 'april 11 , 2011', '1ata05', '5.94'], ['9', "st valentine 's day massacre", 'michael offer', 'christal henry', 'april 18 , 2011', '1ata06', '6.38'], ['10', 'bathhouse & hinky dink', "terrence o'hara", 'patrick massett & john zinman', 'may 2 , 2011', '1ata07', '5.60'], ['11', 'black sox', 'michael offer', 'heather mitchell & kevin townsley', 'may 9 , 2011', '1ata08', '5.67'], ['12', 'greylord & gambat', 'paris barclay', 'virgil williams', 'may 16 , 2011', '1ata11', '5.86']]