[Comedian2004]

The way it works is this:

In each CSV file, you will see fields named:

player_id
team_id
city_id

and others...

You can do a lookup for each of these IDs, For example:

the 1st field in the players.csv is the player's ID. So, if in the games.csv file, it references a player_id, then you can look up in the players.csv file to see the players name. In access or excel, this is known as a lookup.

Be warned. The teams.csv is not accurate for historical correct leagues or if you change team names. Basically, the IDs are used again. So, in 1901 the New York Highlanders will have a team ID of 1. Later, in 1955, the New York Yankees will also have a team ID of 1. So, anyone from the Highlander team will show up as being on the Yankees.

The work around is to do a yearly dump and access the teams.csv from said year. That is one of the reasons that I recommend everyone do a yearly dump. There is another work around that I have created in Visual Basic, but it is too complex to explain here.