/
game_log_fields.txt
136 lines (135 loc) · 6.41 KB
/
game_log_fields.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
Field(s) Meaning
1 Date in the form "yyyymmdd"
2 Number of game:
"0" -- a single game
"1" -- the first game of a double (or triple) header
including seperate admission doubleheaders
"2" -- the second game of a double (or triple) header
including seperate admission doubleheaders
"3" -- the third game of a triple-header
"A" -- the first game of a double-header involving 3 teams
"B" -- the second game of a double-header involving 3 teams
3 Day of week ("Sun","Mon","Tue","Wed","Thu","Fri","Sat")
4-5 Visiting team and league
6 Visiting team game number
For this and the home team game number, ties are counted as
games and suspended games are counted from the starting
rather than the ending date.
7-8 Home team and league
9 Home team game number
10-11 Visiting and home team score (unquoted)
12 Length of game in outs (unquoted). A full 9-inning game would
have a 54 in this field. If the home team won without batting
in the bottom of the ninth, this field would contain a 51.
13 Day/night indicator ("D" or "N")
14 Completion information. If the game was completed at a
later date (either due to a suspension or an upheld protest)
this field will include:
"yyyymmdd,park,vs,hs,len" Where
yyyymmdd -- the date the game was completed
park -- the park ID where the game was completed
vs -- the visitor score at the time of interruption
hs -- the home score at the time of interruption
len -- the length of the game in outs at time of interruption
All the rest of the information in the record refers to the
entire game.
15 Forfeit information:
"V" -- the game was forfeited to the visiting team
"H" -- the game was forfeited to the home team
"T" -- the game was ruled a no-decision
16 Protest information:
"P" -- the game was protested by an unidentified team
"V" -- a disallowed protest was made by the visiting team
"H" -- a disallowed protest was made by the home team
"X" -- an upheld protest was made by the visiting team
"Y" -- an upheld protest was made by the home team
Note: two of these last four codes can appear in the field
(if both teams protested the game).
17 Park ID
18 Attendance (unquoted)
19 Time of game in minutes (unquoted)
20-21 Visiting and home line scores. For example:
"010000(10)0x"
Would indicate a game where the home team scored a run in
the second inning, ten in the seventh and didn't bat in the
bottom of the ninth.
22-38 Visiting team offensive statistics (unquoted) (in order):
at-bats
hits
doubles
triples
homeruns
RBI
sacrifice hits. This may include sacrifice flies for years
prior to 1954 when sacrifice flies were allowed.
sacrifice flies (since 1954)
hit-by-pitch
walks
intentional walks
strikeouts
stolen bases
caught stealing
grounded into double plays
awarded first on catcher's interference
left on base
39-43 Visiting team pitching statistics (unquoted)(in order):
pitchers used ( 1 means it was a complete game )
individual earned runs
team earned runs
wild pitches
balks
44-49 Visiting team defensive statistics (unquoted) (in order):
putouts. Note: prior to 1931, this may not equal 3 times
the number of innings pitched. Prior to that, no
putout was awarded when a runner was declared out for
being hit by a batted ball.
assists
errors
passed balls
double plays
triple plays
50-66 Home team offensive statistics
67-71 Home team pitching statistics
72-77 Home team defensive statistics
78-79 Home plate umpire ID and name
80-81 1B umpire ID and name
82-83 2B umpire ID and name
84-85 3B umpire ID and name
86-87 LF umpire ID and name
88-89 RF umpire ID and name
If any umpire positions were not filled for a particular game
the fields will be "","(none)".
90-91 Visiting team manager ID and name
92-93 Home team manager ID and name
94-95 Winning pitcher ID and name
96-97 Losing pitcher ID and name
98-99 Saving pitcher ID and name--"","(none)" if none awarded
100-101 Game Winning RBI batter ID and name--"","(none)" if none
awarded
102-103 Visiting starting pitcher ID and name
104-105 Home starting pitcher ID and name
106-132 Visiting starting players ID, name and defensive position,
listed in the order (1-9) they appeared in the batting order.
133-159 Home starting players ID, name and defensive position
listed in the order (1-9) they appeared in the batting order.
160 Additional information. This is a grab-bag of informational
items that might not warrant a field on their own. The field
is alpha-numeric. Some items are represented by tokens such as:
"HTBF" -- home team batted first.
Note: if "HTBF" is specified it would be possible to see
something like "01002000x" in the visitor's line score.
Changes in umpire positions during a game will also appear in
this field. These will be in the form:
umpchange,inning,umpPosition,umpid with the latter three
repeated for each umpire.
These changes occur with umpire injuries, late arrival of
umpires or changes from completion of suspended games. Details
of suspended games are in field 14.
161 Acquisition information:
"Y" -- we have the complete game
"N" -- we don't have any portion of the game
"D" -- the game was derived from box score and game story
"P" -- we have some portion of the game. We may be missing
innings at the beginning, middle and end of the game.
Missing fields will be NULL.