clear lake ( oregon )
clear lake of coos county , oregon is the body of water that has the second highest gnis id .
{'row': '12', 'col': '5', 'order': '2', 'col_other': '1', 'max_or_min': 'max_to_min', 'value_mentioned': 'no', 'scope': 'all', 'subset': None}
{'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'nth_argmax', 'args': ['all_rows', 'gnis id', '2'], 'result': None, 'ind': 0, 'tostr': 'nth_argmax { all_rows ; gnis id ; 2 }'}, 'name'], 'result': 'clear lake ( coos county , oregon )', 'ind': 1, 'tostr': 'hop { nth_argmax { all_rows ; gnis id ; 2 } ; name }'}, 'clear lake ( coos county , oregon )'], 'result': True, 'ind': 2, 'tostr': 'eq { hop { nth_argmax { all_rows ; gnis id ; 2 } ; name } ; clear lake ( coos county , oregon ) } = true', 'tointer': 'select the row whose gnis id record of all rows is 2nd maximum . the name record of this row is clear lake ( coos county , oregon ) .'}
eq { hop { nth_argmax { all_rows ; gnis id ; 2 } ; name } ; clear lake ( coos county , oregon ) } = true
select the row whose gnis id record of all rows is 2nd maximum . the name record of this row is clear lake ( coos county , oregon ) .
{'str_eq_2': 'str_eq', 'result_3': 'true', 'str_hop_1': 'str_hop', 'nth_argmax_0': 'nth_argmax', 'all_rows_4': 'all_rows', 'gnis id_5': 'gnis id', '2_6': '2', 'name_7': 'name', 'clear lake (coos county , oregon)_8': 'clear lake ( coos county , oregon )'}
['name', 'type', 'elevation', 'usgs map', 'gnis id']
[['clear lake ( douglas county , oregon )', 'lake', 'feet ( m )', 'winchester bay', '1139800'], ['clear lake ( wasco county , oregon )', 'reservoir', 'feet ( m )', 'wapinitia pass', '1139803'], ['clear lake ( amazon creek , oregon )', 'lake', 'feet ( m )', 'eugene west', '1119000'], ['clear lake ( marion county , oregon )', 'lake', 'feet ( m )', 'mission bottom', '1119001'], ['clear lake ( tillamook county , oregon )', 'lake', 'feet ( m )', 'garibaldi', '1119002'], ['clear lake ( clatsop county , oregon )', 'lake', 'feet ( m )', 'warrenton', '1119003'], ['clear lake , oregon', 'populated place', 'feet ( m )', 'mission bottom', '1119004'], ['clear lake ( florence , lane county , oregon )', 'lake', 'feet ( m )', 'mercer lake', '1139801'], ['clear lake ( clackamas county , oregon )', 'lake', 'feet ( m )', 'elwood', '1139802'], ['clear lake ( wallowa county , oregon )', 'lake', 'feet ( m )', 'clear lake ridge', '1139804'], ['clear lake ( linn county , oregon )', 'lake', 'feet ( m )', 'clear lake', '1139805'], ['clear lake ( coos county , oregon )', 'lake', 'feet ( m )', 'lakeside', '1154640'], ['malabon , oregon', 'historic locale', 'feet ( m )', 'eugene west', '1166549']]