Sire Ids in Daily Runners

Question

Can sire_id & dam_sire_id be added to daily_runners? I tried to pull this information from the historic runners table however in cases where it is a horses first race this data isn't available, leaving large holes in my data set.

Answer 1

Yes, for a first race this is indeed tricky.  It requires a major alteration in the way we assign IDs which we are working on with the next release of the database, which is planned for later this year and will be released in beta first.

Answer 2

If you work with sire_name rather than sire_id you will find that the former is populated for first runs. That was my work around and a useful one at that given how useful sibling stats are for young horses with no/little actual form to reference.

Answer 3

We are now adding sire ID to daily runners in the Smartform Beta to be released to all current subscribers from 10/07.