CREATE INDEX ON :table (acronym);

-- Remove institutions that we have direct data for

DELETE FROM :table

WHERE acronym IN (

    'MO' -- "all MO records in REMIB are also available from MO's own website"

    --, 'ARIZ' -- Some REMIB ARIZ specimens not yet in ARIZ itself

    --, 'NY' -- Some REMIB NY specimens not yet in NY itself

/* 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('REMIB')

*/

;