updated external data and added extra columns