Chadwick Chadwick: Software Tools for Scoring Baseball Games

Table Of Contents

Previous topic

cwevent: Expanded event descriptor

Next topic

cwsub: Player substitution descriptor

This Page

cwgame: Game information extractor

cwgame is a command-line tool which extracts summary information about each game in the data file. These fields are grouped into two categories. There are 83 fields which are compatible with the Retrosheet BGAME game descriptor tool. These are specified using the -f command-line flag. In addition, cwgame offers a number “extended” fields which expand upon or give more detailed information not easily accessed via the standard fields. These are are specified using the -x command-line flag. Many of these extended fields are defined to match fields which appear in the Retrosheet gamelogs.

Note

cwgame guarantees that the standard field numbers will match those used by BGAME. Standard field numbers therefore can be treated as stable, and it should be safe to write scripts referring to them. Extended fields are provisional, and extended fields may be added or withdrawn in future versions. Extended fields are assigned numbers to maintain a logical cohesion, with related fields being grouped. Therefore, extended field numbers are not promised to be stable. It is recommended to use the field labels instead in writing scripts to process the output of cwgame extended fields.

The following table gives the contents of each of the 84 fields cwgame outputs.

cwgame standard field numbers
Field number Description Header
0 Game ID GAME_ID
1 Date GAME_DT
2 Game number GAME_CT
3 Day of week GAME_DY
4 Start time START_GAME_TM
5 DH used flag DH_FL
6 Day/night flag DAYNIGHT_PARK_CD
7 Visiting team AWAY_TEAM_ID
8 Home team HOME_TEAM_ID
9 Game site PARK_ID
10 Visitors starting pitcher AWAY_START_PIT_ID
11 Home starting pitcher HOME_START_PIT_ID
12 Home plate umpire BASE4_UMP_ID
13 First base umpire BASE1_UMP_ID
14 Second base umpire BASE2_UMP_ID
15 Third base umpire BASE3_UMP_ID
16 Left field umpire LF_UMP_ID
17 Right field umpire RF_UMP_ID
18 Attendance ATTEND_PARK_CT
19 PS scorer SCORER_RECORD_ID
20 Translator TRANSLATOR_RECORD_ID
21 Inputter INPUTTER_RECORD_ID
22 Input time INPUT_RECORD_TS
23 Edit time EDIT_RECORD_TS
24 How scored METHOD_RECORD_CD
25 Pitches entered PITCHES_RECORD_CD
26 Temperature TEMP_PARK_CT
27 Wind direction WIND_DIRECTION_PARK_CD
28 Wind speed WIND_SPEED_PARK_CT
29 Field condition FIELD_PARK_CD
30 Precipitation PRECIP_PARK_CD
31 Sky SKY_PARK_CD
32 Time of game MINUTES_GAME_CT
33 Number of innings INN_CT
34 Visitor final score AWAY_SCORE_CT
35 Home final score HOME_SCORE_CT
36 Visitor hits AWAY_HITS_CT
37 Home hits HOME_HITS_CT
38 Visitor errors AWAY_ERR_CT
39 Home errors HOME_ERR_CT
40 Visitor left on base AWAY_LOB_CT
41 Home left on base HOME_LOB_CT
42 Winning pitcher WIN_PIT_ID
43 Losing pitcher LOSE_PIT_ID
44 Save SAVE_PIT_ID
45 Game-winning RBI GWRBI_BAT_ID
46 Visitor batter 1 AWAY_LINEUP1_BAT_ID
47 Visitor batter 1 position AWAY_LINEUP1_FLD_CD
48 Visitor batter 2 AWAY_LINEUP2_BAT_ID
49 Visitor batter 2 position AWAY_LINEUP2_FLD_CD
50 Visitor batter 3 AWAY_LINEUP3_BAT_ID
51 Visitor batter 3 position AWAY_LINEUP3_FLD_CD
52 Visitor batter 4 AWAY_LINEUP4_BAT_ID
53 Visitor batter 4 position AWAY_LINEUP4_FLD_CD
54 Visitor batter 5 AWAY_LINEUP5_BAT_ID
55 Visitor batter 5 position AWAY_LINEUP5_FLD_CD
56 Visitor batter 6 AWAY_LINEUP6_BAT_ID
57 Visitor batter 6 position AWAY_LINEUP6_FLD_CD
58 Visitor batter 7 AWAY_LINEUP7_BAT_ID
59 Visitor batter 7 position AWAY_LINEUP7_FLD_CD
60 Visitor batter 8 AWAY_LINEUP8_BAT_ID
61 Visitor batter 8 position AWAY_LINEUP8_FLD_CD
62 Visitor batter 9 AWAY_LINEUP9_BAT_ID
63 Visitor batter 9 position AWAY_LINEUP9_FLD_CD
64 Home batter 1 HOME_LINEUP1_BAT_ID
65 Home batter 1 position HOME_LINEUP1_FLD_CD
66 Home batter 2 HOME_LINEUP2_BAT_ID
67 Home batter 2 position HOME_LINEUP2_FLD_CD
68 Home batter 3 HOME_LINEUP3_BAT_ID
69 Home batter 3 position HOME_LINEUP3_FLD_CD
70 Home batter 4 HOME_LINEUP4_BAT_ID
71 Home batter 4 position HOME_LINEUP4_FLD_CD
72 Home batter 5 HOME_LINEUP5_BAT_ID
73 Home batter 5 position HOME_LINEUP5_FLD_CD
74 Home batter 6 HOME_LINEUP6_BAT_ID
75 Home batter 6 position HOME_LINEUP6_FLD_CD
76 Home batter 7 HOME_LINEUP7_BAT_ID
77 Home batter 7 position HOME_LINEUP7_FLD_CD
78 Home batter 8 HOME_LINEUP8_BAT_ID
79 Home batter 8 position HOME_LINEUP8_FLD_CD
80 Home batter 9 HOME_LINEUP9_BAT_ID
81 Home batter 9 position HOME_LINEUP9_FLD_CD
82 Visitor finishing pitcher AWAY_FINISH_PIT_ID
83 Home finishing pitcher HOME_FINISH_PIT_ID
cwgame extended field numbers
Field number Description Header
0 visiting team league AWAY_TEAM_LEAGUE_ID
1 home team league HOME_TEAM_LEAGUE_ID
2 visiting team game number AWAY_TEAM_GAME_CT
3 home team game number HOME_TEAM_GAME_CT
4 length of game in outs OUTS_CT
5 information on completion of game COMPLETION_TX
6 information on forfeit of game FORFEIT_TX
7 information on protest of game PROTEST_TX
8 visiting team linescore AWAY_LINE_TX
9 home team linescore HOME_LINE_TX
10 visiting team AB AWAY_AB_CT
11 visiting team 2B AWAY_2B_CT
12 visiting team 3B AWAY_3B_CT
13 visiting team HR AWAY_HR_CT
14 visiting team RBI AWAY_BI_CT
15 visiting team SH AWAY_SH_CT
16 visiting team SF AWAY_SF_CT
17 visiting team HP AWAY_HP_CT
18 visiting team BB AWAY_BB_CT
19 visiting team IBB AWAY_IBB_CT
20 visiting team SO AWAY_SO_CT
21 visiting team SB AWAY_SB_CT
22 visiting team CS AWAY_CS_CT
23 visiting team GDP AWAY_GDP_CT
24 visiting team reach on interference AWAY_XI_CT
25 number of pitchers used by visiting team AWAY_PITCHER_CT
26 visiting team individual ER allowed AWAY_ER_CT
27 visiting team team ER allowed AWAY_TER_CT
28 visiting team WP AWAY_WP_CT
29 visiting team BK AWAY_BK_CT
30 visiting team PO AWAY_PO_CT
31 visiting team A AWAY_A_CT
32 visiting team PB AWAY_PB_CT
33 visiting team DP AWAY_DP_CT
34 visiting team TP AWAY_TP_CT
35 home team AB HOME_AB_CT
36 home team 2B HOME_2B_CT
37 home team 3B HOME_3B_CT
38 home team HR HOME_HR_CT
39 home team RBI HOME_RBI_CT
40 home team SH HOME_SH_CT
41 home team SF HOME_SF_CT
42 home team HP HOME_HP_CT
43 home team BB HOME_BB_CT
44 home team IBB HOME_IBB_CT
45 home team SO HOME_SO_CT
46 home team SB HOME_SB_CT
47 home team CS HOME_CS_CT
48 home team GDP HOME_GDP_CT
49 home team reach on interference HOME_XI_CT
50 number of pitchers used by home team HOME_PITCHER_CT
51 home team individual ER allowed HOME_ER_CT
52 home team team ER allowed HOME_TER_CT
53 home team WP HOME_WP_CT
54 home team BK HOME_BK_CT
55 home team PO HOME_PO_CT
56 home team A HOME_A_CT
57 home team PB HOME_PB_CT
58 home team DP HOME_DP_CT
59 home team TP HOME_TP_CT
60 home plate umpire name UMP_HOME_NAME_TX
61 first base umpire name UMP_1B_NAME_TX
62 second base umpire name UMP_2B_NAME_TX
63 third base umpire name UMP_3B_NAME_TX
64 left field umpire name UMP_LF_NAME_TX
65 right field umpire name UMP_RF_NAME_TX
66 visitors manager ID AWAY_MANAGER_ID
67 visitors manager name AWAY_MANAGER_NAME_TX
68 home manager ID HOME_MANAGER_ID
69 home manager name HOME_MANAGER_NAME_TX
70 winning pitcher name WIN_PIT_NAME_TX
71 losing pitcher name LOSE_PIT_NAME_TX
72 save pitcher name SAVE_PIT_NAME_TX
73 batter with goahead RBI ID GOAHEAD_RBI_ID
74 batter with goahead RBI GOAHEAD_RBI_NAME_TX
75 visitor batter 1 name AWAY_LINEUP1_BAT_NAME_TX
76 visitor batter 2 name AWAY_LINEUP2_BAT_NAME_TX
77 visitor batter 3 name AWAY_LINEUP3_BAT_NAME_TX
78 visitor batter 4 name AWAY_LINEUP4_BAT_NAME_TX
79 visitor batter 5 name AWAY_LINEUP5_BAT_NAME_TX
80 visitor batter 6 name AWAY_LINEUP6_BAT_NAME_TX
81 visitor batter 7 name AWAY_LINEUP7_BAT_NAME_TX
82 visitor batter 8 name AWAY_LINEUP8_BAT_NAME_TX
83 visitor batter 9 name AWAY_LINEUP9_BAT_NAME_TX
84 home batter 1 name HOME_LINEUP1_BAT_NAME_TX
85 home batter 2 name HOME_LINEUP2_BAT_NAME_TX
86 home batter 3 name HOME_LINEUP3_BAT_NAME_TX
87 home batter 4 name HOME_LINEUP4_BAT_NAME_TX
88 home batter 5 name HOME_LINEUP5_BAT_NAME_TX
89 home batter 6 name HOME_LINEUP6_BAT_NAME_TX
90 home batter 7 name HOME_LINEUP7_BAT_NAME_TX
91 home batter 8 name HOME_LINEUP8_BAT_NAME_TX
92 home batter 9 name HOME_LINEUP9_BAT_NAME_TX
93 additional information ADD_INFO_TX
94 acquisition information ACQ_INFO_TX

How scored (field 24)

This field outputs a numeric code corresponding to the medium by which the play-by-play account was recorded.

Numeric codes for how scored field
Code Description
0 unknown
1 park
2 tv
3 radio

Pitches entered (field 25)

This field outputs a numeric code corresponding to the level of pitch detail in the file.

Numeric codes for pitches entered field
Code Description
0 unknown
1 pitches
2 count
3 none

Note

This field reports the contents of the info,pitches field in the game file. Some games with partial pitch information will have this field set to none or count.

Temperature (field 26)

The game-time temperature, in degrees Fahrenheit. The value 0 is used when the temperature is unknown.

Wind direction (field 27)

This field outputs a numeric code corresponding to the direction of the wind.

Numeric codes for wind direction field
Code Description
0 unknown
1 tolf
2 tocf
3 torf
4 ltor
5 fromlf
6 fromcf
7 fromrf
8 rtol

Wind speed (field 28)

The game time wind speed, in miles per hour. The value -1 is used when the wind speed is unknown.

Field condition (field 29)

This field outputs a numeric code corresponding to the condition of the field.

Numeric codes for field condition field
Code Description
0 unknown
1 soaked
2 wet
3 damp
4 dry

Precipitation (field 30)

This field outputs a numeric code corresponding to the precipitation level.

Numeric codes for precipitation field
Code Description
0 unknown
1 none
2 drizzle
3 showers
4 rain
5 snow

Sky (field 31)

This field outputs a numeric code corresponding to the sky conditions.

Numeric codes for sky field.

Numeric codes for sky field
Code Description
0 unknown
1 sunny
2 cloudy
3 overcast
4 night
5 dome