SCHEMA:
CREATE TABLE table_name_43 (name VARCHAR, entered_service VARCHAR, location VARCHAR, type VARCHAR)
USER:
What is the name of the location and ship type in the Gulf of Mexico that entered service in 1999?

QUERY:
SELECT name FROM table_name_43 WHERE location = "gulf of mexico" AND type = "ship" AND entered_service = "1999"