CREATE INDEX ON :table ("dwc_terms_institutionCode"); -- Remove institutions that we have direct data for DELETE FROM :table WHERE "dwc_terms_institutionCode" IN ( 'MO' , 'NY' ) /* list obtained using: SELECT provider FROM sourcelist JOIN provider_count ON level = 'top-level' AND provider_count.provider = sourcelist.name WHERE source_id = source_by_shortname('SpeciesLink') */ ;