In racing terminology, “form” refers to a horse’s recent performance history. In a structured dataset, a form record is a joined view of race, racecard, and result data — a richer structure than the shorthand notation familiar from race programmes.
The Components of a Race Record
Each race in our schema resolves into several linked tables. A complete form record for a single runner in a single race contains:
- Race context — Date, venue, distance, going, class rating, prize money, field size
- Racecard entry — Barrier draw, weight carried, gear, trainer name, jockey name, starting rating
- Result entry — Finishing position, finishing time, margin to winner, margin to next runner, sectional times where available
- Career totals — Wins, runs, places — queryable as aggregates against the results table using horse ID
Querying Form Sequences
Because the schema uses stable horse identifiers as foreign keys, constructing a form sequence for any horse is a standard ordered query: SELECT * FROM results WHERE horse_id = X ORDER BY race_date DESC LIMIT 10. The result set is a clean, date-sorted performance history with all relevant context fields already available without additional joins (for the most common fields; deeper context requires the standard join to the races table).
Schema documentation covering field names, types and join conventions is provided to all subscribers. View dataset options or explore the API.
No responses yet