Scrape US Thoroughbred horse racing data from Equibase.com — the official source for North American racing. Extract race entries (horses, jockeys, trainers, odds) and results (finish order, times, payouts) for any date and track. Ideal for handicappers and sports analytics.
What this record is: race (one race card/result), late_change (one race-day change, late_changes mode) or horse_history (one horse profile, includeHorseHistory).
Type:string | null
Race Id
race_id
Optional
Unique race identifier (track code + date + race number). On a late_change record it is the race the change applies to (null for page-wide notices and track conditions), so it joins to race records.
Type:string | null
Race Date
race_date
Optional
Race date in YYYY-MM-DD format
Type:string | null
Track Code
track_code
Optional
Short track code (e.g. AQU, CD, SA)
Type:string | null
Track Name
track_name
Optional
Full track name (e.g. Aqueduct, Churchill Downs, Santa Anita Park)
Type:string | null
Race Number
race_number
Optional
Race number on the card (1-12+)
Type:number | null
Race Name
race_name
Optional
Race name or grade (e.g. Kentucky Derby, Allowance Optional Claiming)
Type:string | null
Race Type
race_type
Optional
Race classification: Maiden, Allowance, Stakes, Claiming, etc.
Pipe-delimited entry list: post|horse|jockey|trainer|weight|ml_odds. One entry per horse.
Type:string | null
Entries Detail
entries_detail
Optional
Structured entries, one object per horse: program_number (P#), post_position (PP), horse_name (keeps the state/country suffix), state_bred (the suffix alone, e.g. OH; null when the name has none), horse_refno + horse_registry (Equibase stable id), age_sex (as published, e.g. 4/G), age (number) + sex (C colt, F filly, G gelding, H horse, M mare, R ridgling), medication, claim_price_usd, jockey, trainer, weight_lbs, ml_odds, is_scratched, coupled_group (numeric stem of a lettered program number, 1A -> 1), finish_position + dead_heat (the official finish once results are in, joined on program number; null in entries mode, for scratches and for runners outside the order of finish), live_odds (Equibase's tote odds for the runner, e.g. 5/2, as of live_odds_as_of; final odds once live_odds_final is true; null for scratches and for cards older than the previous race day). Scratched horses are included with is_scratched true and null program/post.
Type:object[] | null
Live Odds As Of
live_odds_as_of
Optional
Tote time of the live odds in entries_detail, as Equibase prints it (e.g. 12:15 PM, track local time). Until the tote opens the odds equal the morning line. Null when Equibase has no odds for the race, which is always the case for cards older than the previous race day.
Type:string | null
Live Odds Final
live_odds_final
Optional
True when the live odds are the final tote odds (the race has run); false while betting is open; null when there are no live odds.
Type:boolean | null
Race Cancelled
race_cancelled
Optional
True when Equibase's Cancellations feed lists this race (or the whole card, All Races) as cancelled; false when it does not; null when the feed could not be read on this run.
Type:boolean | null
Results Available
results_available
Optional
Whether race results are available (false for future/today races)
Type:boolean | null
Winner Horse
winner_horse
Optional
Name of the winning horse
Type:string | null
Winner Jockey
winner_jockey
Optional
Name of the winning jockey
Type:string | null
Winner Trainer
winner_trainer
Optional
Name of the winning trainer
Type:string | null
Winning Owner
winning_owner
Optional
Registered owner of the winning horse (null until results are posted)
Type:string | null
Winning Breeder
winning_breeder
Optional
Breeder of the winning horse (null until results are posted)
Type:string | null
Winning Time
winning_time
Optional
Official winning time (e.g. 1:23.45)
Type:string | null
Finish Order
finish_order
Optional
Comma-separated finish order: place. horse (margin). Example: 1. War Of Will (2), 2. Maximum Security (nk), 3. Country House (hd)
Type:string | null
Finish Order Detail
finish_order_detail
Optional
Structured order of finish, one object per horse: finish_position (official: horses in a dead heat share a position, and the next horse skips, e.g. 1, 2, 3, 3, 5), program_number, horse_name, horse_refno, horse_registry, dead_heat (true when the position is shared).
Type:object[] | null
Result Revision
result_revision
Optional
Fingerprint of the official result (finish order plus every payout). Compare it across runs of the same race_id: it changes only when Equibase revises the order of finish or a payout. Null when the race has no published result.
Full $2 win/place/show payout board, one object per chart row: finish_position, program_number, horse_name, horse_refno, horse_registry, win_payout, place_payout, show_payout (null where the chart prints none), dead_heat. finish_position is the official one: in a dead heat both horses carry the shared position (a dead heat for 3rd lists two show horses at 3). Lets Place/Show bets on 2nd and 3rd settle.
Type:object[] | null
Exotic Payouts By Type
exotic_payouts_by_type
Optional
Exotic payouts keyed by canonical bet type (a track's 'Perfecta' is keyed exacta). Each value: payoff, raw_label (the track's own wording), wager_unit_usd, winning_numbers, payoffs (every payoff line for that bet type; a dead heat splits the pool and the chart prints one line per winning combination).
Type:object | null
Entry Url
entry_url
Optional
URL to the Equibase entry page for this track/date
Type:string | null
Result Url
result_url
Optional
URL to the Equibase result summary page for this track/date
Type:string | null
Scraped At
scraped_at
Optional
ISO timestamp when this record was scraped
Type:string | null
Change Id
change_id
Optional
late_change records: stable id of the change (track|date|race|program|type|time, with a numeric suffix when two identical lines were posted).
Type:string | null
Change Type
change_type
Optional
late_change records: scratch, scratch_reason (the stated reason was updated), course (e.g. Turf to Dirt), jockey, weight (weight carried), horse_weight, distance, rail, owner, apprentice, equipment, gelding (first start since being gelded), weather, notice (a page-wide announcement such as all races off the turf), track_condition (the track's current conditions line) or other.
Type:string | null
Change Text
change_text
Optional
late_change records: the change exactly as Equibase prints it.
Type:string | null
Program Number
program_number
Optional
late_change records: program number of the horse the change is about (join key with entries_detail.program_number); null for race-level and page-wide changes.
Type:string | null
Horse Name
horse_name
Optional
late_change and horse_history records: the horse's name as Equibase prints it (state/country suffix kept).
Type:string | null
Old Value
old_value
Optional
late_change records: value before the change, when Equibase prints one (e.g. the previous jockey or the previous scratch reason).
Type:string | null
New Value
new_value
Optional
late_change records: value after the change (the new jockey, 'Scratched', the new course, the rail setting, the conditions line).
Type:string | null
Reason
reason
Optional
late_change records for scratches: the scratch reason Equibase gives (e.g. PrivVet-Illness, Off-Turf, Reason Unavailable).
Type:string | null
Time Posted
time_posted
Optional
late_change records: when Equibase posted the change, as printed in ET (e.g. 11:05 AM ET), 'Reported at Entry Time', or the page's last-updated time for page-wide lines.
Type:string | null
Time Posted At
time_posted_at
Optional
late_change records: time_posted as an ISO UTC timestamp; null for 'Reported at Entry Time'.
Type:string | null
Horse Refno
horse_refno
Optional
horse_history records: Equibase's stable horse id (the same id entries_detail carries).
Type:string | null
Horse Registry
horse_registry
Optional
horse_history records: registry letter of the horse id (T = Thoroughbred).
Type:string | null
Entered Race Ids
entered_race_ids
Optional
horse_history records: race_ids of this run's saved races the horse is entered in.
Type:string[] | null
Past Starts
past_starts
Optional
horse_history records: one object per career start, newest first: race_id (joins to race records), track_code, track_name, race_date, race_number, race_type, breed, finish_position, speed_figure (Equibase speed figure, null when not published). Empty for an unraced horse.
Type:object[] | null
Workouts
workouts
Optional
horse_history records: workouts from the last 60 days: track_code, track_name, workout_date, surface, distance, time, note, rank (e.g. 7/22). Empty for an idle horse.
Type:object[] | null
Profile Url
profile_url
Optional
horse_history records: the public Equibase profile page the record was read from.