Comment by MuffinFlavored

> a professional association still sends its journal to the former owner of my house, dead more than a dozen years

SELECT COUNT(*) FROM death_certificates WHERE ssn = 'the_dead_persons_ssn';

if count is greater than 0, strip from list...?