CSV Field Legend

The following key briefly describes what is in each field of the CSV files.

ColumnTitleExplanation
AMeeting 
BTime 
CRace TypeFlat, All Weather, Chase, Hurdle, NHF
DRace ClassOur rating of the race's class. Nothing to do with the BHA
ETitle 
FGoing 
GFurlongs 
HPrize 
IMinimum AgeYoungest horse in the race
JMaximum AgeOldest Horse in the race
KMean WeightThe average eight carried in the race
LRatingThe horse's final rating
MHorse 
NCard Number 
OGender 
PStall Number 
QStall Percentage 
RWearing 
SDays Since Last RunA negative value means that its last run was in a different race type
TNumber of Results 
UGoing RegressionAnalytical regression figures for the going. Big is best
VDistance RegressionAnalytical regression figures for the distance Big is best
WAge 
XWeight (Stones & Pounds) 
YWeight (Pounds) 
ZTotal Wins 
AARecent Wins 
ABCourse Wins 
ACPenalties 
ADAllowances 
AEWeight DeltaThe weight compared to the race average (Col K)
AFRaw RatingThe horse's Raw rating
AGJockey 
AHJockey Rating 
AITrainer 
AJTrainer Rating 
AKTrainer FormTrForm
ALConnections RatingConn
AMForm TrendFrm field - Trend value over the last 3 races
ANForm - Last RunLst field
AOClassCls - how many pounds the horse has in hand in terms of class to win
APWinning FormWinF field
AQSpeedSpd
ARAlarms 
ASClass PositionWhere the horse is expected to finish if class alone were an issue.
ATWin Class Probability 
AUWin Class Probability (Normalised)HCP
AVValue Odds 
AWValue Odds (Probability) 
AXForecast SP 
AYChase Jumping Ability 
AZRatings Position 
BACSV Version 
BBHandicap 
BCValue Place Odds 
BDBetFair SP Forecast Win Price 
BEBetFair SP Forecast Place Price 
BFRaw Adjusted for Age and WeightThe horse's RAdj rating
BGDate 
BHElapsed DaysOur internal dates are based on days since 1st January, 1970
BISystems 
BJTime 24 Hour 
BKTJC WinsTrainer/Jockey/Course combinations
BLTJC Runs 
BMTJC PL 
BNTJC SR 
BOTJC ROI 
BPTJC Type Wins 
BQTJC Type Runs 
BRTJC Type PL 
BSTJC Type SR 
BTTJC Type ROI 
BUBST/GMT 
BVRunners 
BWTC WinsTrainer/Course combination
BXTC Runs 
BYTC PL 
BZTC SR 
CATC ROI 
CBJC WinsJockey/Course combination
CCJC Runs 
CDJC PL 
CEJC SR 
CFJC ROI 
CGValue Odds (BetFair format) 
CHTJ WinsTrainer/Jockey combination
CITJ Runs 
CJTJ PL 
CKTJ SR 
CLTJ ROI 
CMTRF_20RunsWinsTrainer's Recent Form over his last 20 runs
CNTRF_20RunsRuns 
COTRF_20RunsPL 
CPTRF_20RunsSR 
CQTRF_20RunsROI 
CRTRF_20RunsDays 
CSTRF_2WeeksWinsTrainer's Recent Form over his last 2 weeks
CTTRF_2WeeksRuns 
CUTRF_2WeeksPL 
CVTRF_2WeeksSR 
CWTRF_2WeeksROI 
CXTRF_4WeeksWinsTrainer's Recent Form over his last 4 weeks
CYTRF_4WeeksRuns 
CZTRF_4WeeksPL 
DATRF_4WeeksSR 
DBTRF_4WeeksROI 
DCHorse Form 
DDSellingIs this race a Selling race?
DEClaiming 
DFAuction 
DGNovice 
DHMaiden 
DIBeginner 
DJHunter Chase 
DKRaw RankingThe horse's ranking in this race according to the Raw field
DLRAdj Ranking 
DMJockey Ranking 
DNTrainer Ranking 
DOTrForm Ranking 
DPConn Ranking 
DQFrm Ranking 
DRLst Ranking 
DSCls Ranking 
DTWinF Ranking 
DUSpd Ranking 
DVHCP Ranking 
DWTrainer Calendar RunsTrainer over the past five years only in this calendar window
DXTrainer Calendar Wins 
DYTrainer Calendar Return 
DZTrainer Calendar P/L 
EATrainer Calendar SR% 
EBTrainer Calendar ROI% 
ECTrainer 5 year RunsHow has the trainer fared over the past five years.
EDTrainer 5 year Wins 
EETrainer 5 year Return 
EFTrainer 5 year P/L 
EGTrainer 5 year SR% 
EHTrainer 5 year ROI% 
EICountry 
EJRGoing RankingThe horse's ranking in this race according to the Regression Going field
EKRDistance Ranking 
ELClass Differential RunsNumber of races run in same race type to work out the Class Differential average
EMClass Differential TotalSum of all Class ratings for races entered of same type
ENClass Differential AverageAverage of the above
EOClass Differential DifferenceDifference between today's race class and average race class ran
EPClass Differential Wins Runs The same as the Class Differential but only considering races won
EQClass Differential Wins Total 
ERClass Differential Wins Average 
ESClass Differential Wins DifferenceThe class difference between today's race and the races this horse has won.
ETWeight Differential RunsNumber of races run in same race type to work out the Weight Differential average
EUWeight Differential TotalSum of all Weights carried for races entered of same type
EVWeight Differential AverageAverage of the above
EWWeight Differential DifferenceDifference between today's weight and average weight carried
EXWeight Differential Wins Runs The same as the Weight Differential but only considering races won
EYWeight Differential Wins Total 
EZWeight Differential Wins Average 
FAWeight Differential Wins DifferenceThe Weight difference between today's race and the weight in the races won.
FBClass/Weight Differential RunsAs the previous eight columns, but looking at the Class & Weight combined.
FCClass/Weight Differential Total  
FDClass/Weight Differential Average 
FEClass/Weight Differential Difference 
FFClass/Weight Differential Wins Runs  
FGClass/Weight Differential Wins Total 
FHClass/Weight Differential Wins Average 
FIClass/Weight Differential Wins Difference 
FJUKHR_CardRaceIDOur internal RaceID for when the ratings are constructed.
FKUKHR_CardHorseID ditto, but for the Horse ID
FLUKHR_CardTrainerID 
FMUKHR_CardJockeyID 
FNUKHR_CardCourseID  
FOLast Time Class DropDrop in Class from race of same type
FPLast Time Weight Drop 
FQLast Time PosnPosition gained last time out
FRLast Time Lengths How many lengths last time out behind
FSLast Time Distance ChangedChange in distance ran
FTLast Time Trainer ChangeChange of Trainer rating since last time
FULast Time Jockey ChangeChange of Jockey rating since last time
FVClass Differential Runs 1 YearNumber of races run in same race type to work out the Class Differential average, calculated over the past one year.
FWClass Differential Total 1 YearSum of all Class ratings for races entered of same type
FXClass Differential Average 1 YearAverage of the above
FYClass Differential Difference 1 YearDifference between today's race class and average race class ran
FZClass Differential Wins Runs 1 Year The same as the Class Differential but only considering races won
GAClass Differential Wins Total 1 Year 
GBClass Differential Wins Average 1 Year 
GCClass Differential Wins Difference 1 YearThe class difference between today's race and the races this horse has won.
GDWeight Differential Runs 1 YearNumber of races run in same race type to work out the Weight Differential average
GEWeight Differential Total 1 YearSum of all Weights carried for races entered of same type
GFWeight Differential Average 1 YearAverage of the above
GGWeight Differential Difference 1 YearDifference between today's weight and average weight carried
GHWeight Differential Wins Runs 1 Year The same as the Weight Differential but only considering races won
GIWeight Differential Wins Total 1 Year 
GJWeight Differential Wins Average 1 Year 
GKWeight Differential Wins Difference 1 YearThe Weight difference between today's race and the weight in the races won.
GLClass/Weight Differential Runs 1 YearAs the previous eight columns, but looking at the Class & Weight combined.
GMClass/Weight Differential Total 1 Year  
GNClass/Weight Differential Average 1 Year 
GOClass/Weight Differential Difference 1 Year 
GPClass/Weight Differential Wins Runs 1 Year  
GQClass/Weight Differential Wins Total 1 Year 
GRClass/Weight Differential Wins Average 1 Year 
GSClass/Weight Differential Wins Difference 1 Year 
GT Race5RunsAgoHow well this horse ran five races ago
GU Race4RunsAgoHow well this horse ran four races ago
GV Race3RunsAgoHow well this horse ran three races ago
GW Race2RunsAgoHow well this horse ran two races ago
GX Race1RunAgoHow well this horse ran last race
GY Sire Runs AllSire's progenies' runs
GZ Sire Wins AllSire's progenies' wins
HA Sire P/L AllSire's progenies' profit/loss
HB Sire SR AllSire's progenies' strike rate
HC Sire ROI AllSire's progenies' ROI%
HD Sire A/E AllSire's progenies' A/E value
HE Dam Runs AllDam's progenies' runs
HF Dam Wins AllDam's progenies' wins
HG Dam P/L AllDam's progenies' profit/loss
HH Dam SR AllDam's progenies' strike rate
HI Dam ROI AllDam's progenies' ROI%
HJ Dam A/E AllDam's progenies' A/E value
HKSire RaceType Run Sire RaceType Run
HLSire RaceType Win Sire RaceType Win
HMSire RaceType PL Sire RaceType PL
HNSire RaceType SR Sire RaceType SR
HOSire RaceType ROI Sire RaceType ROI
HPSire RaceType AE Sire RaceType AE
HQDam RaceType Run Dam RaceType Run
HRDam RaceType Win Dam RaceType Win
HSDam RaceType PL Dam RaceType PL
HTDam RaceType SR Dam RaceType SR
HUDam RaceType ROI Dam RaceType ROI
HVDam RaceType AE Dam RaceType AE
HWSire Going Run Sire Going Run
HXSire Going Win Sire Going Win
HYSire Going PL Sire Going PL
HZSire Going SR Sire Going SR
IASire Going ROI Sire Going ROI
IBSire Going AE Sire Going AE
ICDam Going Run Dam Going Run
IDDam Going Win Dam Going Win
IEDam Going PL Dam Going PL
IFDam Going SR Dam Going SR
IGDam Going ROI Dam Going ROI
IHDam Going AE Dam Going AE
IISire Distance Run Sire Distance Run
IJSire Distance Win Sire Distance Win
IKSire Distance PL Sire Distance PL
ILSire Distance SR Sire Distance SR
IMSire Distance ROI Sire Distance ROI
INSire Distance AE Sire Distance AE
IODam Distance Run Dam Distance Run
IPDam Distance Win Dam Distance Win
IQDam Distance PL Dam Distance PL
IRDam Distance SR Dam Distance SR
ISDam Distance ROI Dam Distance ROI
ITDam Distance AE Dam Distance AE
IUSire GoingDistance Run Sire GoingDistance Run
IVSire GoingDistance Win Sire GoingDistance Win
IWSire GoingDistance PL Sire GoingDistance PL
IXSire GoingDistance SR Sire GoingDistance SR
IYSire GoingDistance ROI Sire GoingDistance ROI
IZSire GoingDistance AE Sire GoingDistance AE
JADam GoingDistance Run Dam GoingDistance Run
JBDam GoingDistance Win Dam GoingDistance Win
JCDam GoingDistance PL Dam GoingDistance PL
JDDam Going Distance SR Dam Going Distance SR
JEDam GoingDistance ROI Dam GoingDistance ROI
JFDam GoingDistance AE Dam GoingDistance AE
JGSire DistanceRange Run Sire DistanceRange Run
JHSire DistanceRange Win Sire DistanceRange Win
JISire DistanceRange PL Sire DistanceRange PL
JJSire DistanceRange SR Sire DistanceRange SR
JKSire DistanceRange ROI Sire DistanceRange ROI
JLSire DistanceRange AE Sire DistanceRange AE
JMDam DistanceRange Run Dam DistanceRange Run
JNDam DistanceRange Win Dam DistanceRange Win
JODam DistanceRange PL Dam DistanceRange PL
JPDam DistanceRange SR Dam DistanceRange SR
JQDam DistanceRange ROI Dam DistanceRange ROI
JRDam DistanceRange AE Dam DistanceRange AE
JSSire RaceClass Run Sire RaceClass Run
JTSire RaceClass Win Sire RaceClass Win
JUSire RaceClass PL Sire RaceClass PL
JVSire RaceClass SR Sire RaceClass SR
JWSire RaceClass ROI Sire RaceClass ROI
JXSire RaceClass AE Sire RaceClass AE
JYDam RaceClass Run Dam RaceClass Run
JZDam RaceClass Win Dam RaceClass Win
KADam RaceClass PL Dam RaceClass PL
KBDam RaceClass PL Dam RaceClass PL
KCDam RaceClass ROI Dam RaceClass ROI
KDDam RaceClass AE Dam RaceClass AE
KESire Age Run Sire Age Run
KFSire Age Win Sire Age Win
KGSire Age PL Sire Age PL
KHSire Age SR Sire Age SR
KISire Age ROI Sire Age ROI
KJSire Age AE Sire Age AE
KKDam Age Run Dam Age Run
KLDam Age Win Dam Age Win
KMDam Age PL Dam Age PL
KNDam Age SR Dam Age SR
KODam Age ROI Dam Age ROI
KPDam Age AE Dam Age AE
KQSire AdjacentGoing Run Sire AdjacentGoing Run
KRSire AdjacentGoing Win Sire AdjacentGoing Win
KSSire AdjacentGoing PL Sire AdjacentGoing PL
KTSire AdjacentGoing SR Sire AdjacentGoing SR
KUSire AdjacentGoing ROI Sire AdjacentGoing ROI
KVSire AdjacentGoing AE Sire AdjacentGoing AE
KWDam AdjacentGoing Run Dam AdjacentGoing Run
KXDam AdjacentGoing Win Dam AdjacentGoing Win
KYDam AdjacentGoing PL Dam AdjacentGoing PL
KZDam AdjacentGoing SR Dam AdjacentGoing SR
LADam AdjacentGoing ROI Dam AdjacentGoing ROI
LBDam AdjacentGoing AE Dam AdjacentGoing AE
LCSire Sire
LDUKHR SireID UKHR SireID
LEDam Dam
LFUKHR DamID UKHR DamID
LGRace5RunsAgoRaceType Race5RunsAgoRaceType
LHRace4RunsAgoRaceType Race4RunsAgoRaceType
LIRace3RunsAgoRaceType Race3RunsAgoRaceType
LJRace2RunsAgoRaceType Race2RunsAgoRaceType
LKRace1RunAgoRaceType Race1RunAgoRaceType
LLRace5RunsAgoRaceClass Race5RunsAgoRaceClass
LMRace4RunsAgoRaceClass Race4RunsAgoRaceClass
LNRace3RunsAgoRaceClass Race3RunsAgoRaceClass
LORace2RunsAgoRaceClass Race2RunsAgoRaceClass
LPRace1RunAgoRaceClass Race1RunAgoRaceClass
LQRace5RunsAgoRaceClassType Race5RunsAgoRaceClassType
LRRace4RunsAgoRaceClassType Race4RunsAgoRaceClassType
LSRace3RunsAgoRaceClassType Race3RunsAgoRaceClassType
LTRace2RunsAgoRaceClassType Race2RunsAgoRaceClassType
LURace1RunAgoRaceClassType Race1RunAgoRaceClassType
LVKouldsScore All Sire KouldsScore All Sire
LWKouldsScore All Dam KouldsScore All Dam
LXKouldsScore RaceType Sire KouldsScore RaceType Sire
LYKouldsScore RaceType Dam KouldsScore RaceType Dam
LZKouldsScore Going Sire KouldsScore Going Sire
MAKouldsScore Going Dam KouldsScore Going Dam
MBKouldsScore Distance Sire KouldsScore Distance Sire
MCKouldsScore Distance Dam KouldsScore Distance Dam
MDKouldsScore GoingDistance Sire KouldsScore GoingDistance Sire
MEKouldsScore GoingDistance Dam KouldsScore GoingDistance Dam
MFKouldsScore Distance20pc Sire KouldsScore Distance20pc Sire
MGKouldsScore Distance20pc Dam KouldsScore Distance20pc Dam
MHKouldsScore RaceClass Sire KouldsScore RaceClass Sire
MIKouldsScore RaceClass Dam KouldsScore RaceClass Dam
MJKouldsScore Age Sire KouldsScore Age Sire
MKKouldsScore Age Dam KouldsScore Age Dam
MLKouldsScore GoingBand Sire KouldsScore GoingBand Sire
MMKouldsScore GoingBand Dam KouldsScore GoingBand Dam
MNKouldsScore Total KouldsScore Total
   
MOWRITE FAVOURITE RANKING 
MPBetfair Placed 
MQBetfair Place S.P. 
MRBetfair Win S.P. 
MSActual Going 
MTResult 
MUWRITE IN S.P. HERE 
MVUKHR_RaceIDThe UK Horse Racing internal indices for the races, entry, horse, etc..
MWUKHR_EntryID 
MX UKHR_HorseID 
MY UKHR_TrainerID 
MZ UKHR_Jockey_ID 
NA UKHR_CourseID 

The Alarms are as follows:
b beaten favourite last time out
d new distance
e won easily last time
g new going
t new trainer
+ significant drop in class
- significant rise in class
c coupled with top weight in handicap
m minimum class race to date
p lowest odds to date
W previous winner in this race one or more years ago