2008 - 09 detroit red wings season
in the 2008-09 detroit red wings season , the last overall pick for a player from the united states , was max nicastro .
{'scope': 'subset', 'col_superlative': '2', 'row_superlative': '2', 'value_mentioned': 'no', 'max_or_min': 'max', 'other_col': '3', 'subset': {'col': '5', 'criterion': 'equal', 'value': 'united states'}}
{'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'argmax', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'nationality', 'united states'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; nationality ; united states }', 'tointer': 'select the rows whose nationality record fuzzily matches to united states .'}, 'overall pick'], 'result': None, 'ind': 1, 'tostr': 'argmax { filter_eq { all_rows ; nationality ; united states } ; overall pick }'}, 'player'], 'result': 'max nicastro', 'ind': 2, 'tostr': 'hop { argmax { filter_eq { all_rows ; nationality ; united states } ; overall pick } ; player }'}, 'max nicastro'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { argmax { filter_eq { all_rows ; nationality ; united states } ; overall pick } ; player } ; max nicastro } = true', 'tointer': 'select the rows whose nationality record fuzzily matches to united states . select the row whose overall pick record of these rows is maximum . the player record of this row is max nicastro .'}
eq { hop { argmax { filter_eq { all_rows ; nationality ; united states } ; overall pick } ; player } ; max nicastro } = true
select the rows whose nationality record fuzzily matches to united states . select the row whose overall pick record of these rows is maximum . the player record of this row is max nicastro .
{'str_eq_3': 'str_eq', 'result_4': 'true', 'str_hop_2': 'str_hop', 'argmax_1': 'argmax', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_5': 'all_rows', 'nationality_6': 'nationality', 'united states_7': 'united states', 'overall pick_8': 'overall pick', 'player_9': 'player', 'max nicastro_10': 'max nicastro'}
['round', 'overall pick', 'player', 'position', 'nationality', 'college / junior / club team ( league )']
[['1', '30', 'thomas mccollum', 'goaltender', 'united states', 'guelph storm ( ohl )'], ['3', '91', 'max nicastro', 'defenseman', 'united states', 'chicago steel ( ushl )'], ['4', '121', 'gustav nyquist', 'center', 'sweden', 'malmö redhawks ( sweden jr )'], ['5', '151', 'julien cayer', 'center', 'canada', 'northwood school ( hs - new york )'], ['6', '181', 'stephen johnston', 'left wing', 'canada', 'belleville bulls ( ohl )'], ['7', '211', 'jesper samuelsson', 'center', 'sweden', 'hc vita hästen ( swe - 3 )']]