Daily Racecard CSV File

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 CSV Racecards available at the 48 hour stage before racing takes place whenever possible. We also amend this the day before with any late changes. This is definitely released each day before the next days racing takes place. Plus we have added the Racecard-CSV file. 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 putting the information to their 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. Downloading the Sample will make this easy to see exactly what you get. Mainly the Class Rating for each horse as you would see on our website racecards. Plus the Odds data and we also have the horses weight to be carried in total pounds.

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

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

To help with the above issue, we include the horses file as an xlsx also. The 3 files are downloaded in a zip file combined.

These Daily Racecard CSV Files are available for and on each days racing.

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

About us

Simply put RacingFormBook will help inform and assist you to find winners and enjoyment from Horse Racing. Provide historical horse racing results data.

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.