Treat names as labels, not primary keys
Separate horse identity from runner identity.
Read more →Technology / Racing insight
Build race records that survive name changes, duplicate names and corrected meetings.
Names are useful to people and risky as database identifiers.
Why a name-only join loses information
Stable identifiers support reliable links and historical corrections. They are a foundation rather than a guarantee of data quality.
Explore the example →Runner JSON validator
Build race records that survive name changes, duplicate names and corrected meetings.
Open the tool →Put the research into context.
Build race records that survive name changes, duplicate names and corrected meetings.