CREATE TABLE table_name_74 (cerclis_id VARCHAR2, proposed VARCHAR2, partially_deleted VARCHAR2)

what is the cerclis ID when the site was proposed on 12/30/1982 and was partially deleted on 05/01/2003?
SELECT cerclis_id FROM table_name_74 WHERE proposed = "12/30/1982" AND partially_deleted = "05/01/2003"
SELECT "cerclis_id" FROM "table_name_74" WHERE "05/01/2003" = "partially_deleted" AND "12/30/1982" = "proposed"