Daily Racecard CSV File

What's In The Daily Racecard CSV File

I have been creating Racecards in a data format for some time, which were for my personal use. They enable me to run various scripts and apps against them to assist with betting angles. Then these were passed onto colleagues and fellow professional horse racing enthusiasts. Now we are giving you Free access to the Racecard.csv file. The daily file will include each meeting from United Kingdom and Ireland to create a Single Daily Racecard CSV File. I usually complete creating the racecard.csv by 8 am approximately each morning. This will be made available via on the Subscribers Download page in the ‘Free Items’ section.

Format of the File(s)

If you look at details of our racing results data files, you will see we have these available in two formats. The Duo, which is in fact two files, race information in one and horse details in the other. The other type is the Single File Format style. The racecards.csv files are based upon the SFF style. Therefore there is one line of data representing each horse that is running every day.

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. The explanation and screenshots are split into 3 sections and all form the final Racecard.CSV. 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. 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.

Final data columns

The final columns have 3 which are reserved for our Class Ratings. These are no longer available to the public. You may wish to delete them or substitute your own ratings here.ve the horses weight to be carried in total pounds which makes converting your own ratings easier.

BR2 – Reserved for Best Class Rating from the last 2 races when published*
BR3 – Reserved for Best Class Rating from the last 3 races when published*
BRY – Reserved for Best Class Rating from the last year (12 months) when published*
Odds – A guide to the starting price
WtLbs -The total weight in pounds

*Currently CR’s are not being published

Obtaining The Files and Summary

In summary at the 24 hour stage you will be able to download these files

Race.csv
Horse.xls
Horse.csv
Racecard.csv

Please download a copy of the Sample files we use as an example by clicking the button below. With Excel please be aware that older versions of Excel are not very good at importing CSV, as it attempts to correct some columns to Date format.
A CSV needs importing into a spreadsheet and please see this guide https://www.racingformbook.com/Downloads/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

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.