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