New: daily_sires_insights Table Now in Smartform

Following on from our recent releases of daily_trainers_insights and daily_jockeys_insights, we’re pleased to announce the addition of a new insights table to Smartform: daily_sires_insights.

This new table contains engineered statistics for every runner since March 2008, summarising the historic performance of each horse’s sire under a wide range of conditions. With over 2.3 million rows and 40+ variables, daily_sires_insights lets you query:

• Percentage of Rivals Beaten (PRB) and strike rate
• Split by course, distance, race type, race code, age group, and handicap status
• Across three timeframes: last 5 years, 42 days, and 21 days
• For each day in the database — fully backtestable and forward-compatible

As with other Smartform daily insights tables, the values are rolled up to the date of the race (i.e. no leakage from future performance), making it ideal for both live betting systems and historical model building.

While the table can power complex backtesting pipelines or machine learning models, it also offers immediate value even for simple queries.

For example, here’s a single race from the weekend at Sandown (14:25) where we used the rt_5Y_course_prb variable to rank the sires of each runner by their average performance at the course over the last five years. The top-ranked sire was flagged automatically from the data, and for our cherry-picked example that horse went on to win at 14/1.

This query took just a few lines of SQL to join the daily_sires_insights table with the runners for the race and calculate the rankings:

SELECT
r.horse_name,
s.prb_5yr_by_course
FROM
daily_runners r
JOIN
daily_sires_insights s
ON r.meeting_date = s.meeting_date AND r.horse_name = s.horse_name
WHERE
r.meeting_date = '2025-08-31'
AND r.course = 'Sandown'
AND r.race_time = '14:25'
ORDER BY
s.prb_5yr_by_course DESC;

This is just one of many ways to use the table — in fact, every runner in every race comes with this level of insight now built in. So whether you’re looking to test broader breeding strategies or just want a quick read on today’s runners, this table has you covered.

Smartform subscribers can now download the new daily_sires_insights dataset by visiting the downloads section of the site once logged in. You can view the full schema here, including all field definitions and update schedule.

As always, if you have any questions or suggestions, feel free to get in touch.

Enjoy!

This entry was posted on Monday, September 1st, 2025 at 12:59 pm. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.