Daily trainers insights
Introduction
This table provides a wide range of historical performance statistics corresponding to each trainer with a runner in each race (for both Flat and Jumps racing) for all races since March 2008. Unlike most of the other tables in Smartform, there is no "historic" version of this table, since it corresponds exactly to the daily_runners_beta and daily_runners table, which also run from March 2008. However, this table contains fields that are calculated based on all previous races of the same type to give you an indication of the trainer's historic performance. For example, in a flat all weather handicap race today, you will be able to find statistics relating to the trainer's previous 5 year strike rate for flat all weather handicaps. It is updated for each day, so for the current day's racing you have all the statistics you need to make an informed judgement about a trainer's historic performance for runners under today's conditions. Similarly, you can go back in time to any previous day's racing to find the statistics that were pertinent to the trainer's historic performance at that time.
All the statistics in these tables have been engineered from the data in the Smartform database to provide insight on top of the raw data, from standard win and place strike rates to more granular variables like average number of horses beaten according to distance, course, course and distance, age, handicap, race_type and race_code.
With Smartform, you can of course create your own statistics for historical trainer performance, and there are a practically infinite number of possibilities in addition to those included in the default table. However we appreciate that many users would prefer a convenient baseline of performance statistics or may not have the time to create their own. Hence daily_trainers_insights.
Each variable has been painstakingly tested to ensure that the correct previous information is provided on a "to date" basis for each runner at the time of entry in the historic database without taking into account the result of the upcoming run. This means systems backtesting and modelling use cases are all valid with this dataset.
Read more below on how to install the data.
Using the new smartform updater
If you are using the new smartform updater, once you have installed the dataset using the links below, there is nothing else to configure. Once the data is loaded into the database, you will be able to update it using the updater.
The feed name is daily_trainers_insights so the following command invocation will update it:
smartform-updater daily_trainers_insights
Alternatively it will be picked up if you are using the all-feeds mode:
smartform-updater all-feeds
The table definition
| Field | Data Type | Description | Comments |
|---|---|---|---|
| race_id | int | internal field, reference for race_id field, corresponds to historic_races table and race_id in historic_runners table | Primary key; corresponds to race_id in other tables |
| runner_id | int | internal field, reference for each unique runner, corresponds with historic_runners runner_id | Primary key; corresponds to runner_id in other tables |
| trainer_id | int | Unique trainer identifier, corresponds to trainer_id in daily_runners tables | Indexed for optimized trainer queries |
| trainer_name | text | Name of the trainer | Convenience field for displaying trainer name in single table queries |
| meeting_date | date | Date of the race | |
| race_type | varchar(25) | race_type corresponding to “Flat”, “All Weather Flat”, “Chase”, “Hurdle” and “National Hunt Flat” | Trainer insights use the race_type for statistics on performance by race_type, as well as by race_code |
| race_code | varchar(10) | race_code relates to the two codes of thoroughbred racing in UK and IRE, “Flat” and “Jumps” | race_code groups all Jumps race types and both Flat race_types for statistics on trainer performance |
| course | text | Name of the racecourse | |
| distance_furlongs | int | Distance of the race in furlongs | Rounded to nearest furlong |
| age | int | Age of the runner in whole years at the time of the race | |
| handicap | int | Indicates whether the race is a handicap race (1) or not (0) | |
| rc_5Y_prb | decimal(6,2) | The average (mean) PRB for this trainer’s runners for the past 5 years (prior to each meeting_date) at this code of racing (specific to each runner’s race today) | “prb” statistics relate to the percentage of rivals beaten. In the case of aggregated statistics, this is the mean figure for all the trainers’ runners that qualify in this category over the past 5 years prior to the meeting_date |
| rc_5Y_runs | int | Trainer number of runs over today’s race code in the past 5 years | A count of all the trainer’s daily runners at today’s race_code in a rolling 5 year period, ie. Within 5 years of the date of today’s race |
| rc_5Y_wins | int | Trainer number of runs over today’s race code in the past 5 years | A count of all the trainer’s winning races at today’s race_code from all the daily runners in a rolling 5 year period, ie. Within 5 years of the date of today’s race |
| rc_5Y_strike_rate | decimal(6,2) | Win strike rate expressed as a percentage to 2 decimal places from wins over runners for this race code in the past 5 years | |
| rc_21D_prb | decimal(6,2) | The average (mean) PRB for this trainer’s runners for the past 21 days (prior to each meeting_date) at this code of racing | “prb” statistics relate to the percentage of rivals beaten. In the case of aggregated statistics, this is the mean figure for all the trainers’ runners that qualify in this category over the past 21 days prior to the meeting_date. |
| rc_21D_runs | int | Number of runs over this race code in the past 21 days | Short-term performance metric |
| rc_21D_wins | int | Number of wins over this race code in the past 21 days | Short-term performance metric |
| rc_21D_strike_rate | decimal(6,2) | Strike rate (%) for the past 21 days | Short-term performance metric |
| rc_42D_prb | decimal(6,2) | The average (mean) PRB for this trainer’s runners for the past 42 days (prior to each meeting_date) at this code of racing | “prb” statistics relate to the percentage of rivals beaten. In the case of aggregated statistics, this is the mean figure for all the trainers’ runners that qualify in this category over the past 42 days prior to the meeting_date |
| rc_42D_runs | int | Number of runs over this race code in the past 42 days | Short-term performance metric, can be used in conjunction with the 21 day metrics to look at short term upticks or downturns in trainer form |
| rc_42D_wins | int | Number of wins over this race code in the past 42 days | Short-term performance metric, can be used in conjunction with the 21 day metrics to look at short term upticks or downturns in trainer form |
| rc_42D_strike_rate | decimal(6,2) | Strike rate (%) for the past 42 days | Short-term performance metric, can be used in conjunction with the 21 day metrics to look at short term upticks or downturns in trainer form |
| rt_5Y_prb | decimal(6,2) | The average (mean) PRB for this trainer’s runners for the past 5 years (prior to each meeting_date) for the race_type of today’s runner | “prb” statistics relate to the percentage of rivals beaten. In the case of aggregated statistics, this is the mean figure for all the trainers’ runners that qualify in this category over the past 5 years prior to the meeting_date |
| rt_5Y_runs | int | Trainer number of runs over today’s race type in the past 5 years | A count of all the trainer’s daily runners for this race_type in a rolling 5 year period, ie. Within 5 years of the date of today’s race |
| rt_5Y_wins | int | Trainer number of runs over today’s race type in the past 5 years | A count of all the trainer’s winning races for this race_type from all the daily runners in a rolling 5 year period, ie. Within 5 years of the date of today’s race |
| rt_5Y_strike_rate | decimal(6,2) | Win strike rate expressed as a percentage to 2 decimal places from wins over runners for today’s race_type in the past 5 years | |
| rt_5Y_course_prb | decimal(6,2) | Average (mean) PRB for course and race_type over the past 5 years | “prb” statistics relate to the percentage of rivals beaten. In the case of aggregated statistics, this is the mean figure for all the trainers’ runners that qualify in this category over the past 5 years prior to the meeting_date for today’s course and race_type |
| rt_5Y_course_runs | int | Number of runs at the course for this race_type in the past 5 years | Course and race_type specific historical performance |
| rt_5Y_course_wins | int | Number of wins at the course for this race_type in the past 5 years in the past 5 years | Course and race_type specific historical performance |
| rt_5Y_course_strike_rate | decimal(6,2) | Strike rate (%) for course for this race_type in the past 5 years over the past 5 years | Course and race_type specific historical performance |
| rt_5Y_distance_prb | decimal(6,2) | Average (mean) PRB for this distance and race_type over the past 5 years | “prb” statistics relate to the percentage of rivals beaten. In the case of aggregated statistics, this is the mean figure for all the trainers’ runners that qualify in this category over the past 5 years prior to the meeting_date |
| rt_5Y_distance_runs | int | Number of runs at the distance for this race_type in the past 5 years | Distance and race_type specific historical performance |
| rt_5Y_distance_wins | int | Number of wins at the distance for this race_type in the past 5 years | Distance and race_type specific historical performance |
| rt_5Y_distance_strike_rate | decimal(6,2) | Strike rate (%) at the distance for this race_type in the past 5 years | Distance and race_type specific historical performance |
| rt_5Y_candd_prb | decimal(6,2) | Average (mean) PRB for course and distance, at this race_type over the past 5 years | “prb” statistics relate to the percentage of rivals beaten. In the case of aggregated statistics, this is the mean figure for all the trainers’ runners that qualify in this category over the past 5 years prior to the meeting_date |
| rt_5Y_candd_runs | int | Number of runs at course and distance for this race_type in the past 5 years | Combined course and distance historical performance for this race_type |
| rt_5Y_candd_wins | int | Number of wins at course and distance for this race_type in the past 5 years | Combined course and distance historical performance for this race_type |
| rt_5Y_candd_strike_rate | decimal(6,2) | Strike rate (%) for course and distance for this race_type over the past 5 years | Combined course and distance historical performance for this race_type |
| rt_5Y_age_prb | decimal(6,2) | Average (mean) PRB for age group (by year) for this race_type over the past 5 years | “prb” statistics relate to the percentage of rivals beaten. In the case of aggregated statistics, this is the mean figure for all the trainers’ runners that qualify in this category over the past 5 years prior to the meeting_date |
| rt_5Y_age_runs | int | Number of runs for age group (by year) for this race_type in the past 5 years | Age-specific historical performance for this race_type |
| rt_5Y_age_wins | int | Number of wins for age group (by year) for this race_type in the past 5 years | Age-specific historical performance for this race_type |
| rt_5Y_age_strike_rate | decimal(6,2) | Strike rate (%) for age group (by year) for this race_type over the past 5 years | Age-specific historical performance for this race_type |
| rt_5Y_hcap_condition_prb | decimal(6,2) | Average (mean) PRB for handicap conditions by race_type over the past 5 years | “prb” statistics relate to the percentage of rivals beaten. In the case of aggregated statistics, this is the mean figure for all the trainers’ runners that qualify in this category over the past 5 years prior to the meeting_date |
| rt_5Y_hcap_condition_runs | int | Number of runs under handicap conditions (ie. According to whether today’s race is a handicap) by race_type in the past 5 years | Handicap-specific historical performance |
| rt_5Y_hcap_condition_wins | int | Number of wins under handicap conditions by race_type in the past 5 years | Handicap-specific historical performance |
| rt_5Y_hcap_condition_strike_rate | decimal(6,2) | Strike rate (%) for handicap conditions by race_type over the past 5 years | Handicap-specific historical performance |
| loaded_at | timestamp | smartform_internal_field | When the Smartform record was updated |
Smartform subscription required
To read more, you must first purchase a Smartform Racing Database subscription.
Click here to go straight to the purchase screens, or read more about Smartform Racing Database.