SELECT id, name, parent FROM villa_loc WHERE name LIKE 'Lower%Normandy' OR name LIKE 'Lower%Normandy-Cote dAzur' OR name LIKE 'Lower%Normandy area' OR name LIKE 'Lower%Normandy city' OR name LIKE 'Lower%Normandy coast' OR name LIKE 'Lower%Normandy island'