We have been processing all the CSV files which we've produced back until January 2005 so that they have been cleaned up and ready to add to any database.
Over the years the CSVs have had hundreds of columns added and this project was to, initially, make the structure of each day's CSV file since the start date (7th January 2005) the same. The second part of the project, the one that, by far, took the longest was the filling in, where we could, of all the blanks in the earlier CSV files.
This mean that, for example, the Trainer Recent 20 Day Form would be populated in the CSV for a certain mid-April date in 2007, say, would the figures for the twenty days before that date. This meant a lot of back calculation through the database which, in the end, took weeks.
We've also cleaned up any data which we found needed cleaning and the CSV results from 2005 are ready.
Each .zip file contains the whole of the results data for that year and can each be used to populate one's own databases if one so wishes.
A tool is being developed to aid the user to analyse the above data.
The following key briefly describes what is in each field of the CSV files.
| Column | Title | Explanation |
| A | Meeting | |
| B | Time | |
| C | Race Type | Flat, All Weather, Chase, Hurdle, NHF |
| D | Race Class | Our rating of the race's class. Nothing to do with the BHA |
| E | Title | |
| F | Going | |
| G | Furlongs | |
| H | Prize | |
| I | Minimum Age | Youngest horse in the race |
| J | Maximum Age | Oldest Horse in the race |
| K | Mean Weight | The average eight carried in the race |
| L | Rating | The horse's final rating |
| M | Horse | |
| N | Card Number | |
| O | Gender | |
| P | Stall Number | |
| Q | Stall Percentage | |
| R | Wearing | |
| S | Days Since Last Run | A negative value means that its last run was in a different race type |
| T | Number of Results | |
| U | Going Regression | Analytical regression figures for the going. Big is best |
| V | Distance Regression | Analytical regression figures for the distance Big is best |
| W | Age | |
| X | Weight (Stones & Pounds) | |
| Y | Weight (Pounds) | |
| Z | Total Wins | |
| AA | Recent Wins | |
| AB | Course Wins | |
| AC | Penalties | |
| AD | Allowances | |
| AE | Weight Delta | The weight compared to the race average (Col K) |
| AF | Raw Rating | The horse's Raw rating |
| AG | Jockey | |
| AH | Jockey Rating | |
| AI | Trainer | |
| AJ | Trainer Rating | |
| AK | Trainer Form | TrForm |
| AL | Connections Rating | Conn |
| AM | Form Trend | Frm field - Trend value over the last 3 races |
| AN | Form - Last Run | Lst field |
| AO | Class | Cls - how many pounds the horse has in hand in terms of class to win |
| AP | Winning Form | WinF field |
| AQ | Speed | Spd |
| AR | Alarms | |
| AS | Class Position | Where the horse is expected to finish if class alone were an issue. |
| AT | Win Class Probability | |
| AU | Win Class Probability (Normalised) | |
| AV | Value Odds | |
| AW | Value Odds (Probability) | |
| AX | Forecast SP | |
| AY | Chase Jumping Ability | |
| AZ | Ratings Position | |
| BA | CSV Version | |
| BB | Handicap | |
| BC | Value Place Odds | |
| BD | BetFair SP Forecast Win Price | |
| BE | BetFair SP Forecast Place Price | |
| BF | Raw Adjusted for Age and Weight | The horse's RAdj rating |
| BG | Date | |
| BH | Elapsed Days | Our internal dates are based on days since 1st January, 1970 |
| BI | Systems | |
| BJ | Time 24 Hour | |
| BK | TJC Wins | Trainer/Jockey/Course combinations |
| BL | TJC Runs | |
| BM | TJC PL | |
| BN | TJC SR | |
| BO | TJC ROI | |
| BP | TJC Type Wins | |
| BQ | TJC Type Runs | |
| BR | TJC Type PL | |
| BS | TJC Type SR | |
| BT | TJC Type ROI | |
| BU | BST/GMT | |
| BV | Runners | |
| BW | TC Wins | Trainer/Course combination |
| BX | TC Runs | |
| BY | TC PL | |
| BZ | TC SR | |
| CA | TC ROI | |
| CB | JC Wins | Jockey/Course combination |
| CC | JC Runs | |
| CD | JC PL | |
| CE | JC SR | |
| CF | JC ROI | |
| CG | Value Odds (BetFair format) | |
| CH | TJ Wins | Trainer/Jockey combination |
| CI | TJ Runs | |
| CJ | TJ PL | |
| CK | TJ SR | |
| CL | TJ ROI | |
| CM | TRF_20RunsWins | Trainer's Recent Form over his last 20 runs |
| CN | TRF_20RunsRuns | |
| CO | TRF_20RunsPL | |
| CP | TRF_20RunsSR | |
| CQ | TRF_20RunsROI | |
| CR | TRF_20RunsDays | |
| CS | TRF_2WeeksWins | Trainer's Recent Form over his last 2 weeks |
| CT | TRF_2WeeksRuns | |
| CU | TRF_2WeeksPL | |
| CV | TRF_2WeeksSR | |
| CW | TRF_2WeeksROI | |
| CX | TRF_4WeeksWins | Trainer's Recent Form over his last 4 weeks |
| CY | TRF_4WeeksRuns | |
| CZ | TRF_4WeeksPL | |
| DA | TRF_4WeeksSR | |
| DB | TRF_4WeeksROI | |
| DC | Horse Form | |
| DD | Selling | Is this race a Selling race? |
| DE | Claiming | |
| DF | Auction | |
| DG | Novice | |
| DH | Maiden | |
| DI | Beginner | |
| DJ | Hunter Chase | |
| DK | Raw Ranking | The horse's ranking in this race according to the Raw field |
| DL | RAdj Ranking | |
| DM | Jockey Ranking | |
| DN | Trainer Ranking | |
| DO | TrForm Ranking | |
| DP | Conn Ranking | |
| DQ | Frm Ranking | |
| DR | Lst Ranking | |
| DS | Cls Ranking | |
| DT | WinF Ranking | |
| DU | Spd Ranking | |
| DV | HCP Ranking | |
| DW | Trainer Calendar Runs | Trainer over the past five years only in this calendar window |
| DX | Trainer Calendar Wins | |
| DY | Trainer Calendar Return | |
| DZ | Trainer Calendar P/L | |
| EA | Trainer Calendar SR% | |
| EB | Trainer Calendar ROI% | |
| EC | Trainer 5 year Runs | How has the trainer fared over the past five years. |
| ED | Trainer 5 year Wins | |
| EE | Trainer 5 year Return | |
| EF | Trainer 5 year P/L | |
| EG | Trainer 5 year SR% | |
| EH | Trainer 5 year ROI% | |
| EI | Country | |
| EJ | RGoing Ranking | The horse's ranking in this race according to the Regression Going field |
| EK | RDistance Ranking | |
| EL | Class Differential Runs | Number of races run in same race type to work out the Class Differential average |
| EM | Class Differential Total | Sum of all Class ratings for races entered of same type |
| EN | Class Differential Average | Average of the above |
| EO | Class Differential Difference | Difference between today's race class and average race class ran |
| EP | Class Differential Wins Runs | The same as the Class Differential but only considering races won |
| EQ | Class Differential Wins Total | |
| ER | Class Differential Wins Average | |
| ES | Class Differential Wins Difference | The class difference between today's race and the races this horse has won. |
| ET | Weight Differential Runs | Number of races run in same race type to work out the Weight Differential average |
| EU | Weight Differential Total | Sum of all Weights carried for races entered of same type |
| EV | Weight Differential Average | Average of the above |
| EW | Weight Differential Difference | Difference between today's weight and average weight carried |
| EX | Weight Differential Wins Runs | The same as the Weight Differential but only considering races won |
| EY | Weight Differential Wins Total | |
| EZ | Weight Differential Wins Average | |
| FA | Weight Differential Wins Difference | The Weight difference between today's race and the weight in the races won. |
| FB | Class/Weight Differential Runs | As the previous eight columns, but looking at the Class & Weight combined. |
| FC | Class/Weight Differential Total | |
| FD | Class/Weight Differential Average | |
| FE | Class/Weight Differential Difference | |
| FF | Class/Weight Differential Wins Runs | |
| FG | Class/Weight Differential Wins Total | |
| FH | Class/Weight Differential Wins Average | |
| FI | Class/Weight Differential Wins Difference | |
| FJ | UKHR_CardRaceID | Our internal RaceID for when the ratings are constructed. |
| FK | UKHR_CardHorseID | ditto, but for the Horse ID |
| FL | UKHR_CardTrainerID | |
| FM | UKHR_CardJockeyID | |
| FN | UKHR_CardCourseID | |
| FO | Last Time Class Drop | Drop in Class from race of same type |
| FP | Last Time Weight Drop | |
| FQ | Last Time Posn | Position gained last time out |
| FR | Last Time Lengths | How many lengths last time out behind |
| FS | Last Time Distance Changed | Change in distance ran |
| FT | Last Time Trainer Change | Change of Trainer rating since last time |
| FU | Last Time Jockey Change | Change of Jockey rating since last time |
| | | |
| FV | WRITE FAVOURITE RANKING | |
| FW | Betfair Placed | |
| FX | Betfair Place S.P. | |
| FY | Betfair Win S.P. | |
| FZ | Actual Going | |
| GA | Result | |
| GB | WRITE IN S.P. HERE | |
| GC | UKHR_RaceID | The UK Horse Racing internal indices for the races, entry, horse, etc.. |
| GD | UKHR_EntryID | |
| GE | UKHR_HorseID | |
| GF | UKHR_TrainerID | |
| GG | UKHR_Jockey_ID | |
| GH | UKHR_CourseID | |