PTD Comma-Delimited Results Standard

Home » PTD Comma-Delimited Results Standard
Comma-Delimited Result File Format #1

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