http://www.brisnet.com/library/newchart2.txt
v1.018 8/17/2011
Comprehensive Charts File
=========================
Featuring comma delimited result charts for North American racetracks
The Comprehensive Charts File consists of a set of six record types/files :
#1-Race,,#2-Start,#3-ITM_Payoff,#4-Exotic_Payoff,#5-Breeding,#6-Footnotes
All six comma delimited files can be found in a single ZIP file for
the specific track and racedate (eg. DMR07012005c.zip). The files contained
in each zip file contain extensive race chart information for a given track
and racedate. A detailed description is listed below.
FILE #1: RACE FILE (1 record per race):
---------------------------------------
Max
Field# Description Format Length Notes
1 Track Code Char 3
2 Date YYYYMMDD 8
3 Race # Numeric 2
4 Day/Evening Flag Char 1 D- Day Racing
E- Evening Racing
5 Distance Numeric 5.2 Most commonly reported in yards
eg. 1320 for 6 furlongs
6 Distance unit Char 1 Y= Yards
M= Meters
F= Furlongs
7 About Distance flag Char 1 A- About
*** Three surface related fields are provided for your convenience.
Depending on your preference, use whichever field(s) best suits your needs.
Field#8 uses the same surface code ("D") for both Dirt and All-Weather surfaces.
Field#9 uses a different surface code ("A") for All-Weather surfaces.
Field#11 is a flag indicating whether the race was run on an All-Weather surface.
8 Surface_1 (older style)Char 1 D- main (dirt or all weather)
d- inner (inner dirt)
T- main turf
t- inner turf
9 Surface_2 (newer style)Char 1 A- main AW (All-Weather only, excludes dirt)
D- main (dirt only, excludes AW)
d- inner dirt
T- turf
t- inner turf
10 Reserved
11 All-Weather Flag Char 1 A- All-Weather surface
12 Chute Start flag Char 1 C- Chute start
13 BRIS Racetype Char 2 G1- Grade I stk/hcp
G2- Grade II stk/hcp
G3- Grade III stk/hcp
1C- Grade I Canadian
2C- Grade II Canadian
3C- Grade III Canadian
N- Non-graded stk/hcp
A- Allowance
AO- Allowance Opt. Clmg
R- Starter Alw
T- Starter Hcp
F- Trial
C- Claiming
CO- Optional Claiming
S- Maiden Sp Wt
M- Maiden Claiming
MO- Maiden Opt. Clmg
NO- Optional Clmg Stk
14 EQB Racetype Char 5 CLM- Claiming
ALW- Allowance
MCL- Maiden Claiming
MSW- Maiden Sp Weight
STK- Stakes
MDN- Maiden
STR- Starter Allowance
FTR- Futurity Trial
AOC- Allowance Opt. Clmg
HCP- Handicap
SHP- Starter Handicap
TRL- Trial
etc.
15 Race Grade Num 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
16 Age/Sex Restrictions Char 3 see codes below
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
17 Race Restrictions code Char 20 eg.: NW2L, NW29M, NW1Y+, etc.
18 Statebred flag Char 1 "s" - statebred
19 Abbrev. Race Class Char 20 eg. ALW44000NW2L
20 Breed indicator Char 2 Breed type of race
eg. "TB" for thoroughbred
21 Country Code of race Char 3 eg. "USA"
22 Purse (USD) Numeric 8
23 TotalValueofrace(USD) Numeric 8
24 Reserved
25 Reserved
26 Reserved
27 Reserved
28 MaxClmgPrice (of race) Numeric 7 Highest permitted clmg price
29 Reserved
30 Race Conditions Text_1 255 "For three year olds and upwards
31 Race Conditions Text_2 255 which have never won three races.
32 Race Conditions Text_3 255 By subscribtion ..."
33 Race Conditions Text_4 255
34 Race Conditions Text_5 255
35 Reserved
36 Reserved
37 Field Size Numeric 2
38 Track Condition Char 2 FT- fast
WF- wet fast
FR- frozen
GD- good
SY- sloppy
MY- muddy
SL- slow
HY- heavy
HD- hard
FM- firm
YL- yielding
SF- soft
etc.
39 Fraction #1 (if any) Numeric 5.2 999.99
40 Fraction #2 (if any) Numeric 5.2 999.99
41 Fraction #3 (if any) Numeric 5.2 999.99
42 Fraction #4 (if any) Numeric 5.2 999.99
43 Fraction #5 (if any) Numeric 5.2 999.99
44 Final Time Numeric 5.2 999.99
45 Fraction #1 Distance Numeric 4 Distance (in yards) that the
46 Fraction #2 Distance Numeric 4 corresponding fraction# was
47 Fraction #3 Distance Numeric 4 taken from...
48 Fraction #4 Distance Numeric 4
49 Fraction #5 Distance Numeric 4
50 Off Time Char 5 "00131" for 1:31
*** Depending on the distance of a race, there are up to 6 chart calls
reported: Start call, Pt.ofCall#1,#2,#3, Stretch call, and Finish call.
Pt.ofCall #1,#2, and #3 DO NOT necessarily correspond to Fractiion #1, #2,
or #3. The actual distance of any reported fraction and the distance of any
reported "call" is provided in fields #45-#49 and #51-#54, respectively.
51 Start Call Distance Numeric 4 normally reported in yards; 0 for sprints
52 Pt. of Call#1 Distance Numeric 4 normally reported in yards
53 Pt. of Call#2 Distance Numeric 4 normally reported in yards
54 Pt. of Call#3 Distance Numeric 4 normally reported in yards
55 Race Name Char 80 eg. "Kentucky Derby"
56 Start Description Char 50
57 Temp Rail Distance Numeric 3 reported in feet
58 Off Turf indicator Char 1 O- originally scheduled
for turf
59 Off Turf Dist Chg Flag Char 1 Y- Distance chg
N- No Distance chg
60 Reserved
61 Reserved
62 Reserved
63 Weather Char 65
64 Race Temperature Numeric 3
65 WPS Show Pool Numeric 9
66 Run Up Distance Numeric 4
67-99 Reserved
FILE #2: START FILE (1 record per start):
-----------------------------------------
Max
Field# Description Format Length Notes
1 Track Code Char 3
2 Date YYYYMMDD 8
3 Race # Numeric 2
4 Day/Evening Flag Char 1 D- Day Racing
E- Evening Racing
5 Horsename Char 25
6 Foreign bred code Char 5 Country code if foregin bred (Non-US,CAN,PR)
7 State bred code Char 5 Statebred code if US,CAN,or PR bred
8 Post Position Numeric 2 May contain 99 if scratched
9 Program Number Char 3 May also contain coupled letter
"1A" or "SCR" if scratched
10 Year of Birth Numer 4 CCYY
11 Breed Char 2
12 Coupled flag Char 1 When applicable, this field will
usually contain the coupled letter
(A,B,C,D,E,F,X,Y,...)
13 Abbrev. Jockey name Char 25 Abbrev. jockey string
14 Jockey last name Char 25
15 Jockey first name Char 15
16 Jockey middle name Char 15
17 Reserved
18 Abbrev. Trainer name Char 30 Abbrev. trainer string
19 Trainer last name Char 80
20 Trainer first name Char 15
21 Trainer middle name Char 15
22 Trip Comment Char 22
23 Reserved
24 Owner name(s) Char 80
25 Owner first name Char 15 First & middle owner name is
sometimes provided when there
is only a single owner
26 Owner middle name Char 15
27 Claiming Price Numeric 8 Claiming Price of the HORSE
28 Medication codes Char 7 A- Adjunct Bleeder Medication
B- Bute
C- First time Bute
L- Lasix
M- First Lasix
eg. "BM" for Bute, First lasix
29 Equipment codes Char 7 see codes below
No Equipment H Outer Rims S Nasal Strip
1 Running W's I Inserts T Turndowns
2 Screens J Aluminum Pad U Spurs
3 Shields K Flipping halter W Queen's Plates
A Aluminum Pads L Bar Shoes Y No shoes
B Blinkers M Blocks Z Tongue tie
C Mud Calks N No Whip
D Glued Shoes O Blinkers Off
E Inner Rims P Pads
F Front bandages Q Nasal Strip off
G Goggles R Bar Shoe
30 Earnings (USD) Numeric 9
31 Odds Numeric 6.2 9999.99
32 Non-betting flag Char 1 Y- nonbetting starter
33 Favorite flag Numeric 1 1- favorite
0- non-favorite
34 Reserved
35 Reserved
36 DQ flag Char 1 Y- Disqualified
37 DQ placing Numeric 2 Official placing if Dq'd.
Otherwise: 0
38 Weight Numeric 4
39 Corrected Weight? Char 1 Y- if different than
program weight
40 Overweight amount Numeric 3 OW= (Weight carried
- Program weight)
41 Claimed indicator Char 1 Y- horse was claimed
42 Claimed by...AbbrevTrn Char 30 Abbrev. trainer string
43 Claimed by...TrainerLN Char 25 new trainer last name
44 Claimed by...TrainerFN Char 15 new trainer first name
45 Claimed by...TrainerMN Char 15 new trainer middle name
46 Reserved
47 Claimed by...AbbrevOwn Char 40 Abbrev. new owner string
48 Claimed by...OwnerLN Char 80 new owner last name
49 Claimed by...OwnerFN Char 15 new owner first name
50 Claimed by...OwnerMN Char 15 new owner middle name
51 Win payoff (if any) Numeric 6.2 9999.99
52 Place payoff (if any) Numeric 6.2 9999.99
53 Show payoff (if any) Numeric 6.2 9999.99
54 Reserved
55 Start Call Position Numeric 2
56 Call #1 Position Numeric 2
57 Call #2 Position Numeric 2
58 Call #3 Position Numeric 2
59 Stretch Position Numeric 2
60 Finish Position Numeric 2 Original finish position
61 Official Position Numeric 2 Official finish position
62 Start Call Lengths Ahd Numeric 5.2 used for leader only
63 Call #1 Lengths Ahd Numeric 5.2
64 Call #2 Lengths Ahd Numeric 5.2
65 Call #3 Lengths Ahd Numeric 5.2
66 Stretch Lengths Ahd Numeric 5.2
67 Finish Lengths Ahd Numeric 5.2
68 Start Call Lengths Bhd Numeric 5.2 leader = 0
69 Call #1 Lengths Bhd Numeric 5.2
70 Call #2 Lengths Bhd Numeric 5.2
71 Call #3 Lengths Bhd Numeric 5.2
72 Stretch Lengths Bhd Numeric 5.2
73 Finish Lengths Bhd Numeric 5.2
74 Start Call Margin Numeric 5.2 Lengths ahead of closest
75 Call #1 Margin Numeric 5.2 trailing horse
76 Call #2 Margin Numeric 5.2
77 Call #3 Margin Numeric 5.2
78 Stretch Margin Numeric 5.2
79 Finish Margin Numeric 5.2
80 Dead Heat flag Char 2 DH - dead heat
81 HorseRegID Char 8
82 JockeyID Numeric
83 TrainerID Numeric
84 OwnerID Numeric
85 Claimed_by_New_Trn_ID Numeric (when applicable)
86 Claimed_by_New_Own_ID Numeric (when applicable)
87 Equibase Reference Num Numeric 9
88 Void Indicator Char 1 Y - when voided
89 Void Reason Char 1 A - Administrative
D - Deceased
O - Other
P - Positive Test
V - Vet
90-99 Reserved
FILE #3: ITM Payoff File (1 record for each itm finisher):
----------------------------------------------------------
Max
Field# Description Format Length Notes
1 Track Code Char 3
2 Date YYYYMMDD 8
3 Race # Numeric 2
4 Day/Evening Flag Char 1 D- Day Racing
E- Evening Racing
5 Horsename Char 25
6 Foreign Bred code Char 5 Country code if foreign bred
7 Statebred code Char 5 Statebred code if domestic bred
8 Program Number Char 3
9 Win Payoff Numeric 6.2 9999.99
10 Place Payoff Numeric 6.2 9999.99
11 Show Payoff Numeric 6.2 9999.99
12-25 Reserved
FILE #4: Exotic Payoff File (1 record for each payoff):
-------------------------------------------------------
Max
Field# Description Format Length Notes
1 Track Code Char 3
2 Date YYYYMMDD 8
3 Race # Numeric 2
4 Day/Evening Flag Char 1 D- Day Racing
E- Evening Racing
5 Wager Type Char 45
6 Bet Amount Numeric 5.2 999.99
7 Payoff amount Numeric 11.2 999999999.99
8 Number correct Numeric 5 Used for races like Pick6.
This field reflects the
number correct for this
record. There will often
be two records for a wager
...one record may show "6"
correct (and it's
corresponding payoff) and
another record may show
"5" correct (and it's
corresponding payoff).
9 Winning Numbers Char 45 may also contain the word
"ALL" and "/" and "-"
10 Wager Pool Numeric 11.2 999999999.99
11 Carryover amount Numeric 11.2 999999999.99
12-25 Reserved
FILE #5: BREEDING File (1 record per race winner):
--------------------------------------------------
Max
Field# Description Format Length Notes
1 Track Code Char 3
2 Date YYYYMMDD 8
3 Race # Numeric 2
4 Day/Evening Flag Char 1 D- Day Racing
E- Evening Racing
5 Horsename Char 25
6 Foreign bred code Char 5 Country code if foreign bred
7 Statebred code Char 5 Statebred code if domestic bred
8 Program Number Char 3
9 Breeder Char 80
10 Color Char 20
11 Foal date 8 YYYYMMDD
12 Age Numeric 2
13 Sex Char 1
14 Sire Char 25
15 Dam Char 25
16 Broodmare Sire Char 25
17-25 Reserved
FILE #6: FOOTNOTES File (usually contains multiple records per race):
---------------------------------------------------------------------
Max
Field# Description Format Length Notes
1 Track Code Char 3
2 Date YYYYMMDD 8
3 Race # Numeric 2
4 Day/Evening Flag Char 1 D- Day Racing
E- Evening Racing
5 Footnote sequence# Numeric 2
6 Footnote text Char 80
7-10 Reserved
RECENT REVISION HISTORY:
08/17/2011 Added #81-#86 to File2 (Start File)
(c) Copyright 2011 Bloodstock Research Information Services All Rights Reserved.
Source: www.brisnet.com
