Runner ID Mixup

Question

Waldvogel - https://www.britishhorseracing.com/racing/horses/horse/#!/1691530 seems to have two runner ID, 608644 and 670057 even when the BHA DB suggest it's just the same horse here (detected through joining daily_runners and historic_runners and manual inspection) Does anyone have a recommended fix here?

Answer 1

These sort of clashes occur from time to time due to ID errors in our source data.  We're finally taking the plunge and will be introducing new IDs from January 2019, and source data IDs will be provided for information purposes only.  This should resolve any former clashes with IDs for runners, sires or dams.