👉 To perform feature analysis quicker, download the following 4 files:
\nnyra_start_table.csv - horse/jockey race data
\ntrack_id - Track name where the race took place. AQU -Aqueduct, BEL - Belmont, SAR - Saratoga.
\nrace_date - Race date. Format: YYYY-MM-DD.
\nrace_number - Each day every race is assigned by a number.
\nprogram_number - Unique three char string to identify a horse in the race.
\nweight_carried - Total weight carried by the horse in the race
\njockey - Name of the jockey on the horse in the race
\nodds - Odds to win the race passed as an integer. Divide by 100 to derive the odds to 1. Example - 1280 would be 12.8-1.
\nnyra_race_table.csv - racetrack race data
\ntrack_id - Track name where the race took place. AQU -Aqueduct, BEL - Belmont, SAR - Saratoga.
\nrace_date - Race date. Format: YYYY-MM-DD.
\nrace_number - Each day every race is assigned by a number.
\ndistance_id - Distance of the race (in furlongs). Example - 600 would be 6 furlongs.
\ncourse_type - The course the race was run over passed as one character. M - Hurdle, D - Dirt, O - Outer turf, I - Inner turf, T - turf.
\ntrack_condition - The condition of the course the race was run. YL - Yielding, FM - Firm, SY - Sloppy, GD - Good, FT - Fast, MY - Muddy, SF - Soft.
\nrun_up_distance - Distance (in feet) of the gate to the start of the race.
\nrace_type - The classification of the race passed as as five characters. STK - Stakes, WCL - Waiver Claiming, WMC - Waiver Maiden Claiming, SST - Starter Stakes, SHP - Starter Handicap, CLM - Claiming, STR - Starter Allowance, AOC - Allowance Optionl Claimer, SOC - Starter Optional Claimer, MCL - Maiden Claiming, ALW - Allowance, MSW - Maiden Special Weight.
\npurse - Purse in US dollars of the race passed as an money with two decimal places.
\npost_time - Time of day the race began passed as 5 character. Example - 01220 would be 12:20.
\nnyra_tracking_table.csv - tracking data
\ntrack_id - rack name where the race took place. AQU -Aqueduct, BEL - Belmont, SAR - Saratoga.
\nrace_date - Race date. Format: YYYY-MM-DD.
\nrace_number - Each day every race is assigned by a number.
\nprogram_number - Unique three char string to identify a horse in the race.
\ntrakus_index - Tracking horse moments with the latitude and longitude in the race for every 0.25 seconds.
\nlatitude - The latitude of the horse in the race.
\nlongitude - The longitude of the horse in the race.
\nnyra_2019_complete.csv - combined table of three above files
\nThis file is the combined 3 files into one table.
\n