Summary Results File Format
This document specifies the Comma-Delimited Summary Results File Format (revision 1) for thoroughbred racing data. This file is best used in conjunction with the Post Time Daily comma-delimited past performance file.
File Naming Convention
Format: RMMDDYYE.TTT
| Component | Description |
|---|---|
| R | Constant prefix |
| MM | Month (01-12) |
| DD | Day (01-31) |
| YY | Year (96-xx) |
| E | Optional evening code (for tracks running split day/evening cards) |
| TTT | Track code (2-3 characters) |
Example: R051925.IND
Format Details
- One file per race card
- Strings and dates are quoted
- Floating-point numbers use x.y notation where x represents total digits and y represents decimal places
- All times are expressed in seconds and fractions of a second in tenths
Data Field Specifications (35 Fields)
| Field | Type | Description |
|---|---|---|
| 1 | string(3) | Version identifier (always "1") |
| 2 | date | Race date (MM/dd/yy format) |
| 3 | string(3) | Track ID |
| 4 | number | Race number |
| 5 | string(1) | Evening indicator |
| 6 | number | Distance in feet |
| 7 | string(3) | Track condition |
| 8 | number | Inner track: 0=No, 1=Yes |
| 9 | number | Turf: 0=No, 1=Yes |
| 10 | number | Off-turf: 0=No, 1=Yes |
| 11 | number | Chute start: 0=No, 1=Yes |
| 12 | number | About distance: 0=No, 1=Yes |
| 13 | number | Steeplechase: 0=No, 1=Yes |
| 14 | number | Hurdle: 0=No, 1=Yes |
| 15 | number | Hunt: 0=No, 1=Yes |
| 16 | number | Race class code (-1 to 5) |
| 17 | string(14) | Race class description |
| 18 | number | Grade designation (-1, 0, or 1-6) |
| 19 | number | Statebreds indicator: 0=No, 1=Yes |
| 20 | number | Restricted race indicator: 0=No, 1=Yes |
| 21 | number | Purse amount |
| 22 | number | Claiming price |
| 23 | string(3) | Age restrictions |
| 24 | number | Sex restrictions (0=male, 1=female, 2=mixed) |
| 25 | number | Final race time (seconds) |
| 26 | string(22) | Runner name |
| 27 | number | Post position |
| 28 | string(3) | Saddlecloth number |
| 29 | number | Original finish position |
| 30 | number | Beaten lengths (99.99 = DNF) |
| 31 | number | Dead heat indicator: 0=No, 1=Yes |
| 32 | number | Disqualified indicator: 0=No, 1=Yes |
| 33 | number | Official finish position |
| 34 | number | Final odds |
| 35 | string(22) | Jockey/Trainer names |
Race Class Codes
| Code | Description |
|---|---|
| -1 | Unknown |
| 0 | Maiden Claiming (MCLM) |
| 1 | Maiden Special Weight (MSW) |
| 2 | Claiming (CLM) |
| 3 | Allowance (ALW) |
| 4 | Stakes (STKS) |
| 5 | Handicap (HDCP) |
Grade Values
| Value | Description |
|---|---|
| -1 | Unknown |
| 0 | Not graded |
| 1-3 | Grade I, II, or III |
| 4-6 | Listed/Black-type stakes |
Special Values
| Field | Value | Meaning |
|---|---|---|
| Beaten lengths | 99.99 | Did not finish (DNF) |
| Race class | -1 | Unknown class |
| Grade | -1 | Unknown grade |
Copyright 2025 by Scratchsoft, Inc.