weightlifting at the 2007 pan american games
among those lifted at least 330 kg total in the 2007 pan-am games , juan quiterio was only one who did n't snatch at least 150 .
{'scope': 'subset', 'row': '5', 'col': '3', 'col_other': '1', 'criterion': 'less_than', 'value': '150', 'subset': {'col': '5', 'criterion': 'greater_than_eq', 'value': '330'}}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_less', 'args': [{'func': 'filter_greater_eq', 'args': ['all_rows', 'total ( kg )', '330'], 'result': None, 'ind': 0, 'tostr': 'filter_greater_eq { all_rows ; total ( kg ) ; 330 }', 'tointer': 'select the rows whose total ( kg ) record is greater than or equal to 330 .'}, 'snatch', '150'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose total ( kg ) record is greater than or equal to 330 . among these rows , select the rows whose snatch record is less than 150 .', 'tostr': 'filter_less { filter_greater_eq { all_rows ; total ( kg ) ; 330 } ; snatch ; 150 }'}], 'result': True, 'ind': 2, 'tostr': 'only { filter_less { filter_greater_eq { all_rows ; total ( kg ) ; 330 } ; snatch ; 150 } }', 'tointer': 'select the rows whose total ( kg ) record is greater than or equal to 330 . among these rows , select the rows whose snatch record is less than 150 . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_less', 'args': [{'func': 'filter_greater_eq', 'args': ['all_rows', 'total ( kg )', '330'], 'result': None, 'ind': 0, 'tostr': 'filter_greater_eq { all_rows ; total ( kg ) ; 330 }', 'tointer': 'select the rows whose total ( kg ) record is greater than or equal to 330 .'}, 'snatch', '150'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose total ( kg ) record is greater than or equal to 330 . among these rows , select the rows whose snatch record is less than 150 .', 'tostr': 'filter_less { filter_greater_eq { all_rows ; total ( kg ) ; 330 } ; snatch ; 150 }'}, 'name'], 'result': 'juan quiterio ( dom )', 'ind': 3, 'tostr': 'hop { filter_less { filter_greater_eq { all_rows ; total ( kg ) ; 330 } ; snatch ; 150 } ; name }'}, 'juan quiterio ( dom )'], 'result': True, 'ind': 4, 'tostr': 'eq { hop { filter_less { filter_greater_eq { all_rows ; total ( kg ) ; 330 } ; snatch ; 150 } ; name } ; juan quiterio ( dom ) }', 'tointer': 'the name record of this unqiue row is juan quiterio ( dom ) .'}], 'result': True, 'ind': 5, 'tostr': 'and { only { filter_less { filter_greater_eq { all_rows ; total ( kg ) ; 330 } ; snatch ; 150 } } ; eq { hop { filter_less { filter_greater_eq { all_rows ; total ( kg ) ; 330 } ; snatch ; 150 } ; name } ; juan quiterio ( dom ) } } = true', 'tointer': 'select the rows whose total ( kg ) record is greater than or equal to 330 . among these rows , select the rows whose snatch record is less than 150 . there is only one such row in the table . the name record of this unqiue row is juan quiterio ( dom ) .'}
and { only { filter_less { filter_greater_eq { all_rows ; total ( kg ) ; 330 } ; snatch ; 150 } } ; eq { hop { filter_less { filter_greater_eq { all_rows ; total ( kg ) ; 330 } ; snatch ; 150 } ; name } ; juan quiterio ( dom ) } } = true
select the rows whose total ( kg ) record is greater than or equal to 330 . among these rows , select the rows whose snatch record is less than 150 . there is only one such row in the table . the name record of this unqiue row is juan quiterio ( dom ) .
{'and_5': 'and', 'result_6': 'true', 'only_2': 'only', 'filter_less_1': 'filter_less', 'filter_greater_eq_0': 'filter_greater_eq', 'all_rows_7': 'all_rows', 'total (kg)_8': 'total ( kg )', '330_9': '330', 'snatch_10': 'snatch', '150_11': '150', 'str_eq_4': 'str_eq', 'str_hop_3': 'str_hop', 'name_12': 'name', 'juan quiterio ( dom )_13': 'juan quiterio ( dom )'}
['name', 'bodyweight', 'snatch', 'clean & jerk', 'total ( kg )']
[['josé oliver ruíz ( col )', '84.45', '160.0', '203.0', '363.0'], ['jadier valladares ( cub )', '84.50', '161.0', '202.0', '363.0'], ['herbys márquez ( ven )', '84.75', '155.0', '195.0', '350.0'], ['kendrick farris ( usa )', '84.15', '158.0', '191.0', '349.0'], ['juan quiterio ( dom )', '84.35', '145.0', '185.0', '330.0'], ['buck ramsay ( can )', '84.75', '140.0', '178.0', '318.0'], ['rafael andrade ( bra )', '83.75', '140.0', '175.0', '315.0'], ['edward silva ( uru )', '84.10', '120.0', '150.0', '270.0']]