Retrosheet


Play-by-Play Crosswalk


Parsed play-by-play data for all games for which Retrosheet has play-by-play data (including deduced event files) are available for download here. Retrosheet event files can also be parsed using the program, bevent.exe, which is described and can be downloaded from here.

The table below provides a crosswalk between output from bevent.exe ('bevent' column #), output from cwevent.exe, an extended version of bevent.exe developed by Ted Turocy and available from his Chadwick repository ('cwevent' header), and the parsed play-by-play files available for download from Retrosheet ('plays' column name).

'bevent' column #	'cwevent' header	'plays' column name	Description
0			GAME_ID			gid			Game ID
1			AWAY_TEAM_ID					Visiting team
			HOME_TEAM_ID					home team id
2			INN_CT			inning			Inning
3			BAT_HOME_ID		top_bot			Top (0) or bottom (1) of inning
			BAT_LAST_ID		vis_home		Visiting (0) or home (1) team batting
			BAT_TEAM_ID		batteam			batting team id
			FLD_TEAM_ID		pitteam			fielding team id
4			OUTS_CT			outs_pre		Outs at start of play
						outs_post		Outs at end of play
5			BALLS_CT					Balls
6			STRIKES_CT					Strikes
			COUNT_TX		count			Pitch count
7			PITCH_SEQ_TX		pitches			Pitch sequence
						nump			Number of pitches
8			AWAY_SCORE_CT					Visitor score
9			HOME_SCORE_CT					Home score
10			BAT_ID			batter			Batter
11			BAT_HAND_CD		bathand			Batter hand
12			RESP_BAT_ID					Result batter
13			RESP_BAT_HAND_CD				Result batter hand
14			PIT_ID			pitcher			Pitcher
15			PIT_HAND_CD		pithand			Pitcher hand
16			RESP_PIT_ID					Result pitcher
17			RESP_PIT_HAND_CD				Result pitcher hand
18			POS2_FLD_ID		f2			Catcher
19			POS3_FLD_ID		f3			First baseman
20			POS4_FLD_ID		f4			Second baseman
21			POS5_FLD_ID		f5			Third baseman
22			POS6_FLD_ID		f6			Shortstop
23			POS7_FLD_ID		f7			Left fielder
24			POS8_FLD_ID		f8			Center fielder
25			POS9_FLD_ID		f9			Right fielder
26			BASE1_RUN_ID		br1_pre			Runner on first base at start of play
27			BASE2_RUN_ID		br2_pre			Runner on second base at start of play
28			BASE3_RUN_ID		br3_pre			Runner on third base at start of play
						br1_post		Runner on first base at end of play
						br2_post		Runner on second base at end of play
						br3_post		Runner on third base at end of play
29			EVENT_TX		event			Event text
30			LEADOFF_FL					Leadoff flag
31			PH_FL			{bat_f = 11}		Pinch-hit flag
32			BAT_FLD_CD		bat_f			Defensive position of batter
33			BAT_LINEUP_ID		lp			Lineup position of batter
34			EVENT_CD		**			Event type (see below for bevent/cwent event types and translation to 'plays')
35			BAT_EVENT_FL		pa			Batter event flag (pa = 0/1; bevent/cwevent = T/F)
36			AB_FL			ab			Official time at bat flag (ab = 0/1; bevent/cwent = T/F)
37			H_CD						Hit value (total bases of hit) = {single + 2*double + 3*triple + 4*hr}
						single			Single
						double			Double
						triple			Triple
						hr			Home run
38			SH_FL			sh			Sacrifice hit flag
39			SF_FL			sf			Sacrifice fly flag
						hbp			Hit-by-pitch
						walk			Walk
						iw			Intentional walk
						k			Strikeout
						xi			Catchers' interference
						oth			Other play
						othout			Out on 'other play'
						noout			Non-out on 'other play'
						k_safe			Batter safe on strikeout
40			EVENT_OUTS_CT					Outs on play = {outs_post - outs_pre}
41			DP_FL						Double play flag
						gdp			GDP (grounded-into-double-play; official stat since late 1930s)
						othdp			Other double play
42			TP_FL			tp			Triple play flag
43			RBI_CT			rbi			RBI on play
						rbi_b			RBI credited for run scored by batter
						rbi1			RBI credited for run scored by RBI credited for runner on first base
						rbi2			RBI credited for run scored by RBI credited for runner on second base
						rbi3			RBI credited for run scored by RBI credited for runner on third base
44			WP_FL			wp			Wild pitch flag
45			PB_FL			pb			Passed ball flag
						bk			Balk
						di			Defensive indifference
						oa			Other baserunner advancement (non-plate appearance)
						bip			Ball-in-play
46			FLD_CD			firstf			Fielded by
			FLD_ID						id of player fielding batted ball
47			BATTEDBALL_CD		hittype			Batted ball type
48			BUNT_FL			bunt			Bunt flag
49			FOUL_FL						Foul flag
						ground			Ground ball
						fly			Fly ball (or pop up)
						line			Line drive
50			BATTEDBALL_LOC_TX	loc			Hit location
51			ERR_CT						Number of errors = {e1+e2+e3+e4+e5+e6+e7+e8+e9}
52			ERR1_FLD_CD					1st error player
53			ERR1_CD						1st error type
54			ERR2_FLD_CD					2nd error player
55			ERR2_CD						2nd error type
56			ERR3_FLD_CD					3rd error player
57			ERR3_CD						3rd error type
						e1			Error(s) by pitcher
						e2			Error(s) by catcher
						e3			Error(s) by first baseman
						e4			Error(s) by second baseman
						e5			Error(s) by third baseman
						e6			Error(s) by shortstop
						e7			Error(s) by left fielder
						e8			Error(s) by center fielder
						e9			Error(s) by right fielder
58			BAT_DEST_ID					Batter destination
59			RUN1_DEST_ID					Runner on first destination
60			RUN2_DEST_ID					Runner on second destination
61			RUN3_DEST_ID					Runner on third destination
62			BAT_PLAY_TX					Play on batter
63			RUN1_PLAY_TX					Play on runner on first
64			RUN2_PLAY_TX					Play on runner on second
65			RUN3_PLAY_TX					Play on runner on third
66			RUN1_SB_FL		sb2			Stolen base for runner on first
67			RUN2_SB_FL		sb3			Stolen base for runner on second
68			RUN3_SB_FL		sbh			Stolen base for runner on third
69			RUN1_CS_FL		cs2			Caught stealing for runner on first
70			RUN2_CS_FL		cs3			Caught stealing for runner on second
71			RUN3_CS_FL		csh			Caught stealing for runner on third
72			RUN1_PK_FL		pko1			Pickoff of runner on first
73			RUN2_PK_FL		pko2			Pickoff of runner on second
74			RUN3_PK_FL		pko3			Pickoff of runner on third
						prun_b			Pitcher responsible for batter
75			RUN1_RESP_PIT_ID	prun1			Pitcher responsible for runner on first
76			RUN2_RESP_PIT_ID	prun2			Pitcher responsible for runner on second
77			RUN3_RESP_PIT_ID	prun3			Pitcher responsible for runner on third
78			GAME_NEW_FL		{pn=1}			New game flag
79			GAME_END_FL					End game flag
80			PR_RUN1_FL					Pinch-runner on first
81			PR_RUN2_FL					Pinch-runner on second
82			PR_RUN3_FL					Pinch-runner on third
83			REMOVED_FOR_PR_RUN1_ID				Runner removed for pinch-runner on first
84			REMOVED_FOR_PR_RUN2_ID				Runner removed for pinch-runner on second
85			REMOVED_FOR_PR_RUN3_ID				Runner removed for pinch-runner on third
86			REMOVED_FOR_PH_BAT_ID				Batter removed for pinch-hitter
87			REMOVED_FOR_PH_BAT_FLD_CD			Position of batter removed for pinch-hitter
88			PO1_FLD_CD					Fielder with first putout
89			PO2_FLD_CD					Fielder with second putout
90			PO3_FLD_CD					Fielder with third putout
						po1			Putout(s) by pitcher
						po2			Putout(s) by catcher
						po3			Putout(s) by first baseman
						po4			Putout(s) by second baseman
						po5			Putout(s) by third baseman
						po6			Putout(s) by shortstop
						po7			Putout(s) by left fielder
						po8			Putout(s) by center fielder
						po9			Putout(s) by right fielder
			UNKNOWN_OUT_EXC_FL	po0			unknown fielding credit flag; putouts made by unknown fielder
						batout1			fielder who made first putout on batter (including force outs)
						batout2			fielder who made second putout on batter (including force outs)
						batout3			fielder who made third putout on batter (including force outs)
						brout_b			fielder who made out on batter as a baserunner
						brout1			fielder who made putout on runner on first base
						brout2			fielder who made putout on runner on second base
						brout3			fielder who made putout on runner on third base
91			ASS1_FLD_CD					Fielder with first assist
92			ASS2_FLD_CD					Fielder with second assist
93			ASS3_FLD_CD					Fielder with third assist
94			ASS4_FLD_CD					Fielder with fourth assist
95			ASS5_FLD_CD					Fielder with fifth assist
			ASS6_FLD_CD					fielder with sixth assist
			ASS7_FLD_CD					fielder with seventh assist
			ASS8_FLD_CD					fielder with eighth assist
			ASS9_FLD_CD					fielder with ninth assist
			ASS10_FLD_CD					fielder with tenth assist
						a1			Assist(s) by pitcher
						a2			Assist(s) by catcher
						a3			Assist(s) by first baseman
						a4			Assist(s) by second baseman
						a5			Assist(s) by third baseman
						a6			Assist(s) by shortstop
						a7			Assist(s) by left fielder
						a8			Assist(s) by center fielder
						a9			Assist(s) by right fielder
96			EVENT_ID		pn			Event number
			INN_NEW_FL					start of half inning flag
			INN_END_FL					end of half inning flag
			START_BAT_SCORE_CT				score for team on offense
			START_FLD_SCORE_CT				score for team on defense
			INN_RUNS_CT					runs scored in this half inning
			GAME_PA_CT					number of plate appearances in game for team on offense
			INN_PA_CT					number of plate appearances in inning for team on offense
			PA_NEW_FL					start of plate appearance flag
			PA_TRUNC_FL					truncated plate appearance flag
			START_BASES_CD					base state at start of play
			END_BASES_CD					base state at end of play
			BAT_START_FL					batter is starter flag
			RESP_BAT_START_FL				result batter is starter flag
						l1			batting team lineup position 1 (player id)
						l2			batting team lineup position 2 (player id)
						l3			batting team lineup position 3 (player id)
						l4			batting team lineup position 4 (player id)
						l5			batting team lineup position 5 (player id)
						l6			batting team lineup position 6 (player id)
						l7			batting team lineup position 7 (player id)
						l8			batting team lineup position 8 (player id)
						l9			batting team lineup position 9 (player id)
						lf1			fielding position of batting team lineup position 1 (1-9, 10=dh, 11=ph, 12=pr)
						lf2			fielding position of batting team lineup position 2 (1-9, 10=dh, 11=ph, 12=pr)
						lf3			fielding position of batting team lineup position 3 (1-9, 10=dh, 11=ph, 12=pr)
						lf4			fielding position of batting team lineup position 4 (1-9, 10=dh, 11=ph, 12=pr)
						lf5			fielding position of batting team lineup position 5 (1-9, 10=dh, 11=ph, 12=pr)
						lf6			fielding position of batting team lineup position 6 (1-9, 10=dh, 11=ph, 12=pr)
						lf7			fielding position of batting team lineup position 7 (1-9, 10=dh, 11=ph, 12=pr)
						lf8			fielding position of batting team lineup position 8 (1-9, 10=dh, 11=ph, 12=pr)
						lf9			fielding position of batting team lineup position 9 (1-9, 10=dh, 11=ph, 12=pr)
			BAT_ON_DECK_ID					ID of the batter on deck
			BAT_IN_HOLD_ID					ID of the batter in the hold
			PIT_START_FL					pitcher is starter flag
			RESP_PIT_START_FL				result pitcher is starter flag
			RUN1_FLD_CD					defensive position of runner on first
			RUN1_LINEUP_CD					lineup position of runner on first
			RUN1_ORIGIN_EVENT_ID				event number on which runner on first reached base
			RUN2_FLD_CD					defensive position of runner on second
			RUN2_LINEUP_CD					lineup position of runner on second
			RUN2_ORIGIN_EVENT_ID				event number on which runner on second reached base
			RUN3_FLD_CD					defensive position of runner on third
			RUN3_LINEUP_CD					lineup position of runner on third
			RUN3_ORIGIN_EVENT_ID				event number on which runner on third reached base
			RUN1_RESP_CAT_ID				responsible catcher for runner on first
			RUN2_RESP_CAT_ID				responsible catcher for runner on second
			RUN3_RESP_CAT_ID				responsible catcher for runner on third
			PA_BALL_CT					number of balls in plate appearance
			PA_CALLED_BALL_CT				number of called balls in plate appearance
			PA_INTENT_BALL_CT				number of intentional balls in plate appearance
			PA_PITCHOUT_BALL_CT				number of pitchouts in plate appearance
			PA_HITBATTER_BALL_CT				number of pitches hitting batter in plate appearance
			PA_OTHER_BALL_CT				number of other balls in plate appearance
			PA_STRIKE_CT					number of strikes in plate appearance
			PA_CALLED_STRIKE_CT				number of called strikes in plate appearance
			PA_SWINGMISS_STRIKE_CT				number of swinging strikes in plate appearance
			PA_FOUL_STRIKE_CT				number of foul balls in plate appearance
			PA_INPLAY_STRIKE_CT				number of balls in play in plate appearance
			PA_OTHER_STRIKE_CT				number of other strikes in plate appearance
			EVENT_RUNS_CT		runs			number of runs on play
						run_b			Run scored by batter
						run1			Run scored by runner on first base
						run2			Run scored by runner on second base
						run3			Run scored by runner on third base
						er			Earned runs on play
						tur			Team unearned runs on play
						ur_b			Unearned run scored by batter
						ur1			Unearned run scored by Unearned runner on first base
						ur2			Unearned run scored by Unearned runner on second base
						ur3			Unearned run scored by Unearned runner on third base
			BASE2_FORCE_FL					force play at second flag
			BASE3_FORCE_FL					force play at third flag
			BASE4_FORCE_FL					force play at home flag
			BAT_SAFE_ERR_FL					batter safe on error flag
			BAT_FATE_ID					fate of batter (base ultimately advanced to)
			RUN1_FATE_ID					fate of runner on first
			RUN2_FATE_ID					fate of runner on second
			RUN3_FATE_ID					fate of runner on third
			FATE_RUNS_CT					runs scored in half inning after this event
			UNCERTAIN_PLAY_EXC_FL					uncertain play flag
						fseq			fielding sequence for out(s): e.g., 643 for 6-4-3 double play
									(0 indicates unknown fielder)
						dpopp			Double-play opportunity (runner on 1st, less than two outs)
						pivot			pivot man on double-play opportunity if one existed
								  	- on ground ball where 'dpopp' = 1, 'pivot' is player who made initial putout
								     	  if a baserunner was forced out,
									  or fielder of ground ball ('firstf') if no force out
								  	- idea behind 'pivot' is to establish fielders who deserve to share 
									  credit/blame for converting double plays
						umphome			Home plate umpire
						ump1b			First-base umpire
						ump2b			Second-base umpire
						ump3b			Third-base umpire
						umplf			Left field umpire
						umprf			Right field umpire
						date			Date
						site			Location (ballpark) of event
						gametype		Type of game (regular, exhibition, allstar, etc.)
						pbp			Type of play-by-play: 'deduced' or 'full'

			
Event Codes: bevent column 34; cwevent 'EVENT_CD'
bevent/cwent	plays			Description
2		othout			Generic out
3		k			Strikeout
4		{sb2+sb3+sbh}		Stolen base
5		di			Defensive indifference
6		{cs2+cs3+csh}		Caught stealing
8		{pko1+pko2+pko3}	Pickoff
9		wp			Wild pitch
10		pb			Passed ball
11		bk			Balk
12		oa			Other advance/out advancing
13					Foul error
14		w			Walk
15		iw			Intentional walk
16		hbp			Hit by pitch
17		xi			Interference
18					Error
19					Fielder’s choice
		noout			Other play on which no batting out was made (combines event codes 18 and 19)
20		single			Single
21		double			Double
22		triple			Triple
23		hr			Home run
It is always Retrosheet's intention that everything it offers for download (and displays on its website) is as correct as possible. The data offered for download here include no known errors. Nevertheless, this is a massive undertaking and the volume of data here is quite formidable. Please let me know if you find any errors or have any issues with any of the files.

Enjoy!

Tom Thress
Retrosheet President


NOTICES

Recipients of Retrosheet data are free to make any desired use of the information, including (but not limited to) selling it, giving it away, or producing a commercial product based upon the data. Retrosheet has one requirement for any such transfer of data or product development, which is that the following statement must appear prominently

     The information used here was obtained free of
     charge from and is copyrighted by Retrosheet.  Interested
     parties may contact Retrosheet at 20 Sunset Rd.,
     Newark, DE 19711.

Retrosheet makes no guarantees of accuracy for the information that is supplied. Much effort is expended to make our website as correct as possible, but Retrosheet shall not be held responsible for any consequences arising from the use the material presented here. All information is subject to corrections as additional data are received. We are grateful to anyone who discovers discrepancies and we appreciate learning of the details.

Retrosheet website last updated August 4, 2025.
All data contained at this site is copyright 1996-2025 by Retrosheet. All Rights Reserved. Click here for information about the use of Retrosheet data

Send comments and suggestions to Tom Thress: tthress-ATsign-retrosheet.org.
Join the Retrosheet Discussion group here: RetroList
Retrosheet is an all-volunteer organization and a 501(c)(3) charitable organization. To volunteer, please e-mail Tom Thress. To make a donation, you can visit here: Donation Page