What's In The Daily Racecard CSV File
We cover each meeting from United Kingdom and Ireland to create a Daily Racecard CSV File. The aim is to make the Racecards dara available at the 48 hour stage, before racing takes place whenever possible.
We also amend the files the day before with any late changes. This is normally released each day before 24 hours before racing takes place. This is the point that the Racecard-CSV file is added. This contains all the data in one file and includes the unique Class Ratings as published on the website.
Format
If you look at our racing results data files, you will see we have two formats in which they are available for download. The Duo, which is in fact two files, then the Single File Format style. We are now producing the racecard information in a similar way to the Duo. These are the Raw data files we use to publish our own racecards on the website.
Then for the 24 hour update we include the SFF style. This is a Single File Format which has as it suggest, all the information in one file. Not only that but we also include our fantastic Class Ratings which are published at this 24 hour – in advance of racing stage.
Daily Racecard CSV File Data
The data that is contained in each Daily Racecard CSV file covers all the most pertinent information around each race and is detailed below. Many of our customers find the CSV files an invaluable source as this was something they found time consuming in trying to create themselves. This leaves them free to concentrate in adapting the information for their own specific requirements.
Daily Racecard CSV File Explained
Here are the details contained in the racecard CSV Files. Firstly the screenshot below is from the races file. It shows columns of data for the race details.
- Col A – For every race this is the ID which will correspond to the RacesID in the horses file
- Col B – The racecourse for each race
- Col C – Time the race is scheduled to start
- Col D – Race name or title
- Col E – Race distance in Miles-Furlongs-Yards
- Col F – Class of the race, 1 being highest & the Age Range for the age range that a race maybe restricted to
- Col G – The prize money for winner in the local currency
- Col H – The going at time the file is published
- Col I – Number of horses to run in the race
Now the second of the files known as Horses, which covers complete details for the runners in each of the days races. We provide this file in CSV and also as an XLXS in an additional file. Some column headers are legacy ones. i.e. Race Time when we first generated the data this column contained not only the course name, but also the time of the race. We decided to omit the time part eventually. Similarly the AgeWt contained the age as part of this field. In the end we opted to put the Age in its own separate column.
- RacesId This corresponds to the ID column in the Races file
- RaceTime The course that the race is being run at
- CardNo The official race card number allocated to a horse
- HorseName Horses name (with country of breeding)
- AgeWt The weight a horse will carry Pounds-Stones
- Trainer A horses trainer
- Jockey The rider for each horse
- OR The Official Rating as rated by the racing governing body
- FFigs A horses last 6 finishing positions with the latest to the right
- Draw Which racing stall at the start of a race that a horse will run from
- Days The number of days a horse last ran
- Age The age of the horse when the race takes place
- Aid Any head gear that is being worn and a 1 denotes first time it has been applied. It is also the column we put any Penalty (ex weight) a horse has received
- Allow A jockeys allowance in pounds that will be deducted from the weight the horse is set to carry
- cdb Course & Distance (CD), or Distance (D), or Course (C) winner letters. Plus a Beaten Favourite (bf) is noted here.
Additional data at 24 hour stage
With the 24 hour download we include all the information above as one file plus these additional fields below. Downloading the Sample will show exactly what you get.
Major addition is that the Class Rating are published. They are replicated from the cards seen on the racecard webpages. The predicted Odds data is included. As a bonus we have the horses weight to be carried in total pounds which makes converting your own ratings easier.
- BR2 – Best Class Rating from the last 2 races
- BR3 – Best Class Rating from the last 3 races
- BRY – Best Class Rating from the last year (12 months)
- Odds – A guide to the starting price
- WtLbs -The total weight in pounds
Obtaining The Files and Summary
In summary at the 48 hour stage their are 3 files
- Race.csv
- Horse.xls
- Horse.csv
The XLS contain same information but in the additional format.
At the 24 hour stage there is the updated information plus included is all the data as a single file. So you will download
- Race.csv
- Horse.xls
- Horse.csv
- Racecard.csv
Please download a copy of the sample day we use as an example by clicking the button below. With Excel please be aware that Excel is not very good at importing CSV as it attempts to correct some columns to Date format.
A CSV needs importing into a spreadsheet. See this guide https://www.racingformbook.co.uk/sample/Importing_CSV_to_Excel.pdf
We provide the files to our Subscribers as one of the services that they receive. To become a Subscriber or register as a member for Free then Click Membership Options.
There are not many places where you can obtain the days horse racing cards in a CSV format, so we hope that in providing them we can assist those looking for this information.
As always please send any comments or question to us via the Contact Us page or email support@racingformbook.com
Our mission
To further anyone’s ambition to use the information, whether this is as a point of reference, a repository for their ratings or to enable the research into racing systems.
Our offer
- Horse racing results CSV data files
- Provide Horse Racing Databases
- Formbook Builder Application
- Results data going back to the start of 2016