Table: superfund_sites_co
Columns: cerclis_id
name
county
proposed
listed
construction_completed
partially_deleted

Question: Which county is named broderick wood products?
SQL: SELECT "county" FROM superfund_sites_co WHERE "name" = 'broderick wood products'

Question: What construction completed is named nelson tunnel/commodore waste rock?
SQL: SELECT "construction_completed" FROM superfund_sites_co WHERE "name" = 'nelson tunnel/commodore waste rock'

Question: What is the ID of marshall landfill on 09/08/1983?
SQL: SELECT "cerclis_id" FROM superfund_sites_co WHERE "listed" = '09/08/1983' AND "name" = 'marshall landfill'