The Import Charts File is a detailed record layout for horse racing data at a selected track and date, containing information for each horse that raced. It includes various data points such as track, date, race number, distance, surface type, race type and grade, purse, age/sex restrictions, and statebred flag. Additional details cover fractions, final time, track condition, horse's positions and lengths at various calls, finish position, odds, medication, equipment, and key personnel like trainer, jockey, and owner. The file also provides codes for age/sex restrictions and other specific race conditions.
IMPORT CHARTS FILE : Described below is the record layout of the file.
==================== The Import Charts File contains a record for each
horse which raced at the selected track and date.
1. TRACK CHARACTER XXX 3
2. DATE CHARACTER XXXXXXXX 8 CYMD
3. RACE NUMBER NUMERIC 99 2
4. DISTANCE (in yards) NUMERIC 99999 5 (- value for
about distances)
5. SURFACE CHARACTER X 1
D-dirt
T-turf
d-inner dirt
t-inner turf
s-steeplechase
h-hurdle
6. RACE TYPE CHARACTER XX 2
G-graded stk/hcp
N-nongraded stk/hcp
A-allowance
AO - Allowance Optional Claiming
R-starter allowance
T-starter Hcp.
C-claiming
CO - Optional Claiming
S-mdn sp wt
M-mdn claiming
MO - Maiden Optional Claiming
NO - Optional Claiming Stk
7. RACE GRADE NUMERIC 9 1
0= not graded
1= Grade I
2= Grade II
3= Grade III
5= Grade I Canada
6= Grade II Canada
7= Grade III Canada
8. PURSE NUMERIC 99999999 8
9. AGE/SEX RESTR. CHARACTER XXX 3 see codes below
10. STATEBRED FLAG CHARACTER X 1
0= Non-Statebred
1= Statebred
11. FRACTION #1 (if any) NUMERIC 999.99 6
12. FRACTION #2 (if any) NUMERIC 999.99 6
13. FRACTION #3 (if any) NUMERIC 999.99 6
14. FRACTION #4 (if any) NUMERIC 999.99 6
15. FRACTION #5 (if any) NUMERIC 999.99 6
16. FINAL TIME NUMERIC 999.99 6
17. TRACK CONDITION CHARACTER XX 2
18. Horse's POST POSITION NUMERIC 99 2
19. Horse's ENTRY/COUPLING FLAG CHARACTER X 1 e-part of an entr
y
20. Horse's NAME CHARACTER 25
21. Horse's Country Code CHARACTER XXXXX 5 (if applicable)
22. Horse's YEAR OF BIRTH NUMERIC 99 2
23. Horse's WEIGHT NUMERIC 999 3
24. Horse's CLAIMING PRICE NUMERIC 9999999 7
25. Horse's Start Call Posit. CHARACTER 2
26. Horse's 1st Call Position CHARACTER 2
27. Horse's 2nd Call Position CHARACTER 2
28. Horse's 3rd Call Position CHARACTER 2
29. Horse's Stretch Position CHARACTER 2
30. Horse's Finish Position NUMERIC 99 2 92 = Did Not Fini
sh
31. Horse's St. Call Btnlngths NUMERIC 99.99 5
32. Horse's 1st Call Btnlngths NUMERIC 99.99 5
33. Horse's 2nd Call Btnlngths NUMERIC 99.99 5
34. Horse's 3rd Call Btnlngths NUMERIC 99.99 5
35. Horse's Stretch Call Btnln NUMERIC 99.99 5
36. Horse's FINISH BEATEN LTHS NUMERIC 99.99 5 0 for Winner
37. Horse's ODDS to $1.00 NUMERIC 999.99 6
38. Horse's MEDICATION NUMERIC 9 1
0=None,1=Lasix,
2=Bute,3=Bute& Las
ix
39. Horse's EQUIPMENT CHARACTER X 1 b-blinkers
40. Trainer's Name CHARACTER 30
41. Jockey's Name CHARACTER 25
42. Owner's Name CHARACTER 40
43. Last Race Date CHARACTER 8
44. Last BRIS Track Code CHARACTER 3
45. Last Race # NUMERIC 2
46. Last Session NUMERIC 1
47. Last Post Position NUMERIC 2
48. Today's Class/Race Name CHARACTER 14
Age/Sex Restriction Codes (3 character string):
1st character 2nd character 3rd character
------------- ------------- -------------
A - 2 year olds O - That age only N - No Sex Restrictions
B - 3 year olds U - That age and up M - Mares and Fillies Only
C - 4 year olds C - Colts and/or Geldings Only
D - 5 year olds F - Fillies Only
E - 3 & 4 year olds
F - 4 & 5 year olds
G - 3, 4, & 5 year olds
H - all ages
Example: "BON" - means a "3 year olds only" race with no sex restrictions