## determine deleted records
insert ignore into removedRecords
select brKey
from bioRecordList
left join GBIF.bioRecord  on brKey = bioRecordKey
where bioRecordKey is null;
