The Import Charts File records detailed data for each horse race at a selected track and date, including track, date, race number, distance, surface, race type and grade, purse, age/sex restrictions, fractions, final time, track condition, horse details (post position, name, country, birth year, weight, claiming price, positions, beaten lengths, odds, medication, equipment), trainer, jockey, owner, last race info, and today's class/race name. Age/sex restriction codes specify eligible horse categories.
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