Craig A. James wrote:
Since we're only aggregating information, we have no control over the data that these companies provide.
And at the end of the day that's the root of the problem. It's easy to be lulled into "well it looks like a primary key" rather than being able to guarantee it.
-- Richard Huxton Archonet Ltd