Daily jockeys insights
Introduction
This table provides a wide range of historical performance statistics corresponding to each jockey riding each 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 jockey's historic performance. For example, in a flat all weather handicap race today, you will be able to find statistics relating to the jockey'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 jockey's historic performance when riding similar 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 jockey's historic performance at that time.
This table corresponds exactly to the equivalent daily_trainers_insights table that provides the same variables by trainer.
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_jockeys_insights so the following command invocation will update it:
smartform-updater daily_jockeys_insightsAlternatively it will be picked up if you are using the all-feeds mode:
smartform-updater all-feedsThe table definition
daily_jockeys_insights
| 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 |
| jockey_id | int | Unique jockey identifier, corresponds to jockey_id in daily_runners tables | Indexed for optimized jockey queries |
| jockey_name | text | Name of the jockey | Convenience field for displaying jockey 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” | Jockey 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 jockey 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 jockey’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 jockeys’ runners that qualify in this category over the past 5 years prior to the meeting_date |
| rc_5Y_runs | int | Jockey number of runs over today’s race code in the past 5 years | A count of all the jockey’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 | Jockey number of runs over today’s race code in the past 5 years | A count of all the jockey’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 jockey’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 jockeys’ 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 jockey’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 jockeys’ 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 jockey 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 jockey 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 jockey form |
| rt_5Y_prb | decimal(6,2) | The average (mean) PRB for this jockey’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 jockeys’ runners that qualify in this category over the past 5 years prior to the meeting_date |
| rt_5Y_runs | int | Jockey number of runs over today’s race type in the past 5 years | A count of all the jockey’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 | Jockey number of runs over today’s race type in the past 5 years | A count of all the jockey’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 jockeys’ 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 jockeys’ 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 jockeys’ 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 jockeys’ 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 jockeys’ 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.