|
Value Tech, Inc. is pleased to announce its first comma-delimited result file format. Value Tech, Inc. believes that this file in best used, in conjunction with, the Value Tech, Inc. comma-delimited past performance file. This file will
allow researchers to analyze a myriad of racing angles and systems. Best
of all it’s priced at only 50 cents per racing card.
The Value Tech, Inc. Result File Format #1 is a comma delimited
format and consists of one (1) comma-delimited file for each race card
at a particular track. The file contains the result information for all
the live thoroughbred races run at a particular track on a particular
day. The naming convention for these result files is as follows:
RMMDDYYE.TTT
where R always appears, MM is the month code (01-12), DD is the day code
(01-31), YY is the year code (96-xx), E is an optional evening code*,
and TTT is a two or three character code track code. Taken together,
these codes uniquely identify which racing card a particular file
contains data for.
*Note: The E code is an optional code and will only apply for those
tracks that run two thoroughbred race cards on a single day. Tracks that
run only one evening card and no day card will not have the E code
designation. Only tracks like FG, or CBY that occasionally run split day
and evening cards on the same day for thoroughbred racing will have this
code.
For those of you using relational databases, this file is not
particularly relational as it conceptually consists of a joining
(flattening) of a race information file and a horse information file for
each race. For purposes of simplicity we have made this a single file
format.
All fields are separated by comma, and strings (dates are also strings)
are enclosed in quotation marks. The max size field indicates the
maximum width of a paticular value. For floating point numbers (real,
double, single and so forth) the width will be indicated as x.y where x
is the maximum number of digits (including the
decimal point) and y is the maximum number of digits after a decimal point. In each case, these are maximums and not a
guaranteed size.
All times will be expressed in seconds and fractions of a second in tenths.
Field # (or sequence) |
Type
|
Max Size
|
Comment
|
|
1 versionString
|
string
|
3
|
Always 1 for this version
|
|
2 racedate
|
date
|
8
|
String of “MM/DD/YY”
|
|
3 track
|
string
|
3
|
|
|
4 racenumber
|
numeric
|
2
|
|
|
5 evening code
|
string
|
1
|
E if an evening card as described above, otherwise one blank space
|
|
6 distance in feet
|
numeric
|
4
|
|
|
7 track conditions
|
string
|
3
|
As printed in form (lowercase) Dirt: fst, fr, gd, sl, sly, my, hy, wf
Turf: fm, gd, hd, yl, sf, wm wm=wet firm
|
|
8 inner code
|
numeric
|
1
|
0 = false, 1 = true
|
|
9 turf code
|
numeric
|
1
|
0 = false, 1 = true
|
|
10 off the turf
|
numeric
|
1
|
0 = false, 1 = true
|
|
11 chute
|
numeric
|
1
|
0 = false, 1 = true
|
|
12 about
|
numeric
|
1
|
0 = false, 1 = true
|
|
13 steeplechase
|
numeric
|
1
|
0 = false, 1 = true
|
|
14 hurdle
|
numeric
|
1
|
0 = false, 1 = true
|
|
15 hunt
|
numeric
|
1
|
0 = false, 1 = true
|
|
16 raceclass
|
numeric
|
1
|
0 = MCLM 1 = MSW 2 = CLM 3 = ALW 4 = STKS 5 = HDCP
-1 = Unavailable Note:
Many races which are actually
Handicap races will sometimes fall
into category 4. This is currently
unavoidable.
|
|
17 race class description
|
string
|
14
|
Examples: Alw 42000 N1x Alw 47500N$my LasFlorsBCH-G3
Md Sp Wt Clm 25000
|
|
18 grade
|
numeric
|
1
|
-1 if not any of the others
0 if a non-graded stakes or handicap
1, 2, 3 for a grade 1, grade 2 or grade 3 race.
4, 5, 6 for a grade 1, grade 2 or grade 3 race in Canada
|
|
19 state bred
|
numeric
|
1
|
0 = false, 1 = true
|
|
20 restricted
|
numeric
|
1
|
0 = false, 1 = true
|
|
21 purse
|
numeric
|
9
|
|
|
22 claiming price
|
numeric
|
7
|
if applicable
|
|
23 age restrictions
|
string
|
3
|
2 2UP 23 3 3UP 34 345 4 4UP 45 5 5UP 6UP 7UP 8 8UP 89 9UP 10UP OPEN
Combinations like 345 indicate race is for 3, 4 and 5 year olds only
|
|
24 sex restrictions
|
numeric
|
1
|
0 = MALE 1 = FEMALE 2 = MIXED
|
|
25 race final_time
|
numeric
|
6.2
|
|
|
26 Horsename
|
string
|
22
|
|
|
27 Post Position
|
numeric
|
2
|
|
|
28 Saddle Cloth Number
|
string
|
3
|
|
|
29 Original Finish Position
|
numeric
|
2
|
Horses that don’t finish will have a finish pos.
|
|
30 finish_lengths
|
numeric
|
5.2
|
value of 99.99 if horse did not finish, broke down, or issue like that
|
|
31 dead_heat
|
numeric
|
1
|
0 = false, 1 = true
|
|
32 dq_flag
|
numeric
|
1
|
0 = false, 1 = true
|
|
33 revised finish position
|
numeric
|
2
|
revised position if dh or dq affected finish position
otherwise will match Original Finish Pos
|
|
34 final odds
|
numeric
|
6.2
|
|
|
35 jockey
|
string
|
22
|
|
|
36 trainer
|
string
|
22
|
|
|
