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 RecordEach 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 sizeRacecard entry — Barrier draw, weight carried, gear, trainer name, jockey name, starting ratingResult entry — Finishing position, finishing time, margin to winner, margin to next runner, sectional times where availableCareer totals — Wins, runs, places — queryable as aggregates against the results table using horse IDQuerying Form SequencesBecause 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.
Recent Comments