weightlifting at the 2007 pan american games
the lowest bodyweight of a lifter who achieved a total of over 195 kg was the 57.05 kg of rusmeris villar .
{'scope': 'subset', 'row': '2', 'col': '2', 'order': '1', 'col_other': '1', 'max_or_min': 'min_to_max', 'value_mentioned': 'yes', 'subset': {'col': '5', 'criterion': 'greater_than', 'value': '195.0'}}
{'func': 'and', 'args': [{'func': 'eq', 'args': [{'func': 'nth_min', 'args': [{'func': 'filter_greater', 'args': ['all_rows', 'total ( kg )', '195.0'], 'result': None, 'ind': 0, 'tostr': 'filter_greater { all_rows ; total ( kg ) ; 195.0 }', 'tointer': 'select the rows whose total ( kg ) record is greater than 195.0 .'}, 'bodyweight', '1'], 'result': '57.05', 'ind': 1, 'tostr': 'nth_min { filter_greater { all_rows ; total ( kg ) ; 195.0 } ; bodyweight ; 1 }', 'tointer': 'select the rows whose total ( kg ) record is greater than 195.0 . the 1st minimum bodyweight record of these rows is 57.05 .'}, '57.05'], 'result': True, 'ind': 2, 'tostr': 'eq { nth_min { filter_greater { all_rows ; total ( kg ) ; 195.0 } ; bodyweight ; 1 } ; 57.05 }', 'tointer': 'select the rows whose total ( kg ) record is greater than 195.0 . the 1st minimum bodyweight record of these rows is 57.05 .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'nth_argmin', 'args': [{'func': 'filter_greater', 'args': ['all_rows', 'total ( kg )', '195.0'], 'result': None, 'ind': 0, 'tostr': 'filter_greater { all_rows ; total ( kg ) ; 195.0 }', 'tointer': 'select the rows whose total ( kg ) record is greater than 195.0 .'}, 'bodyweight', '1'], 'result': None, 'ind': 3, 'tostr': 'nth_argmin { filter_greater { all_rows ; total ( kg ) ; 195.0 } ; bodyweight ; 1 }'}, 'name'], 'result': 'rusmeris villar ( col )', 'ind': 4, 'tostr': 'hop { nth_argmin { filter_greater { all_rows ; total ( kg ) ; 195.0 } ; bodyweight ; 1 } ; name }'}, 'rusmeris villar ( col )'], 'result': True, 'ind': 5, 'tostr': 'eq { hop { nth_argmin { filter_greater { all_rows ; total ( kg ) ; 195.0 } ; bodyweight ; 1 } ; name } ; rusmeris villar ( col ) }', 'tointer': 'the name record of the row with 1st minimum bodyweight record is rusmeris villar ( col ) .'}], 'result': True, 'ind': 6, 'tostr': 'and { eq { nth_min { filter_greater { all_rows ; total ( kg ) ; 195.0 } ; bodyweight ; 1 } ; 57.05 } ; eq { hop { nth_argmin { filter_greater { all_rows ; total ( kg ) ; 195.0 } ; bodyweight ; 1 } ; name } ; rusmeris villar ( col ) } } = true', 'tointer': 'select the rows whose total ( kg ) record is greater than 195.0 . the 1st minimum bodyweight record of these rows is 57.05 . the name record of the row with 1st minimum bodyweight record is rusmeris villar ( col ) .'}
and { eq { nth_min { filter_greater { all_rows ; total ( kg ) ; 195.0 } ; bodyweight ; 1 } ; 57.05 } ; eq { hop { nth_argmin { filter_greater { all_rows ; total ( kg ) ; 195.0 } ; bodyweight ; 1 } ; name } ; rusmeris villar ( col ) } } = true
select the rows whose total ( kg ) record is greater than 195.0 . the 1st minimum bodyweight record of these rows is 57.05 . the name record of the row with 1st minimum bodyweight record is rusmeris villar ( col ) .
{'and_6': 'and', 'result_7': 'true', 'eq_2': 'eq', 'nth_min_1': 'nth_min', 'filter_greater_0': 'filter_greater', 'all_rows_8': 'all_rows', 'total (kg)_9': 'total ( kg )', '195.0_10': '195.0', 'bodyweight_11': 'bodyweight', '1_12': '1', '57.05_13': '57.05', 'str_eq_5': 'str_eq', 'str_hop_4': 'str_hop', 'nth_argmin_3': 'nth_argmin', 'bodyweight_14': 'bodyweight', '1_15': '1', 'name_16': 'name', 'rusmeris villar ( col )_17': 'rusmeris villar ( col )'}
['name', 'bodyweight', 'snatch', 'clean & jerk', 'total ( kg )']
[['alexandra escobar ( ecu )', '57.35', '98.0', '125.0', '223.0'], ['rusmeris villar ( col )', '57.05', '90.0', '114.0', '204.0'], ['maria cecilia floriddia ( arg )', '57.45', '90.0', '110.0', '200.0'], ['gretty lugo ( ven )', '57.55', '88.0', '108.0', '196.0'], ['geralee vega ( pur )', '57.80', '85.0', '110.0', '195.0'], ['jackie berube ( usa )', '57.85', '86.0', '105.0', '191.0'], ['wildri de los santos ( dom )', '57.35', '84.0', '106.0', '190.0'], ['quisia yaneli ( mex )', '58.00', '82.0', '103.0', '185.0'], ['valãrie lefebvre ( can )', '57.75', '78.0', '98.0', '176.0'], ['eliane silva ( bra )', '57.00', '75.0', '90.0', '165.0']]