1997 cfl draft
in the 1997 cfl draft , the only player picked from north dakota was tim prinsen .
{'scope': 'all', 'row': '4', 'col': '5', 'col_other': '3', 'criterion': 'equal', 'value': 'north dakota', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'college', 'north dakota'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose college record fuzzily matches to north dakota .', 'tostr': 'filter_eq { all_rows ; college ; north dakota }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; college ; north dakota } }', 'tointer': 'select the rows whose college record fuzzily matches to north dakota . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'college', 'north dakota'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose college record fuzzily matches to north dakota .', 'tostr': 'filter_eq { all_rows ; college ; north dakota }'}, 'player'], 'result': 'tim prinsen', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; college ; north dakota } ; player }'}, 'tim prinsen'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; college ; north dakota } ; player } ; tim prinsen }', 'tointer': 'the player record of this unqiue row is tim prinsen .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; college ; north dakota } } ; eq { hop { filter_eq { all_rows ; college ; north dakota } ; player } ; tim prinsen } } = true', 'tointer': 'select the rows whose college record fuzzily matches to north dakota . there is only one such row in the table . the player record of this unqiue row is tim prinsen .'}
and { only { filter_eq { all_rows ; college ; north dakota } } ; eq { hop { filter_eq { all_rows ; college ; north dakota } ; player } ; tim prinsen } } = true
select the rows whose college record fuzzily matches to north dakota . there is only one such row in the table . the player record of this unqiue row is tim prinsen .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'college_7': 'college', 'north dakota_8': 'north dakota', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'player_9': 'player', 'tim prinsen_10': 'tim prinsen'}
['pick', 'cfl team', 'player', 'position', 'college']
[['1', 'toronto argonauts', 'chad folk', 'ol', 'utah'], ['2', 'saskatchewan roughriders', 'ben fairbrother', 'ol', 'calgary'], ['3', 'edmonton eskimos', 'ian franklin', 'cb', 'weber state'], ['4', 'hamilton tiger - cats', 'tim prinsen', 'og', 'north dakota'], ['5', 'calgary stampeders', 'doug brown', 'dl', 'simon fraser'], ['6', 'montreal alouettes', 'steve charbonneau', 'dl', 'new hampshire'], ['7', 'calgary', 'jason clemett', 'lb', 'simon fraser'], ['8', 'edmonton', 'mark farraway', 'dl', 'st francis xavier']]