Lahman Baseball Database --------------------------------------------------------------------------- 2.1 MASTER table playerID A unique code asssigned to each player. The playerID links the data in this file with records in the other files. managerID An ID for individuals who served as managers hofID An ID for individuals who are in teh baseball Hall of Fame birthYear Year player was born birthMonth Month player was born birthDay Day player was born birthCountry Country where player was born birthState State where player was born birthCity City where player was born deathYear Year player died deathMonth Month player died deathDay Day player died deathCountry Country where player died deathState State where player died deathCity City where player died nameFirst Player's first name nameLast Player's last name nameNote Note about player's name (usually signifying that they changed their name or played under two differnt names) nameGiven Player's given name (typically first and middle) nameNick Player's nickname weight Player's weight in pounds height Player's height in inches bats Player's batting hand (left, right, or both) throws Player's throwing hand (left or right) debut Date that player made first major league appearance college College attended lahman40ID ID used in Lahman Database version 4.0 lahman45ID ID used in Lahman database version 4.5 retroID ID used by retrosheet holtzID ID used by Sean Holtz's Baseball Almanac bbrefID ID used by Baseball Reference website ------------------------------------------------------------------------------ 2.2 Batting Table playerID Player ID code yearID Year stintID player's stint (order of appearances within a season) teamID Team lgID League G Games AB At Bats R Runs H Hits 2B Doubles 3B Triples HR Homeruns RBI Runs Batted In SB Stolen Bases CS Caught Stealing BB Base on Balls SO Strikeouts IBB Intentional walks HBP Hit by pitch SH Sacrifice hits SF Sacrifice flies GIDP Grounded into double plays ------------------------------------------------------------------------------ 2.3 Pitching table playerID Player ID code yearID Year stintID player's stint (order of appearances within a season) teamID Team lgID League W Wins L Losses G Games GS Games Started CG Complete Games SHO Shutouts SV Saves IPOuts Outs Pitched (innings pitched x 3) H Hits ER Earned Runs HR Homeruns BB Walks SO Strikeouts BAOpp Opponent's Batting Average ERA Earned Run Average IBB Intentional Walks WP Wild Pitches HBP Batters Hit By Pitch BK Balks BFP Batters faced by Pitcher GF Games Finished R Runs Allowed ------------------------------------------------------------------------------ 2.4 Fielding Table playerID Player ID code yearID Year stintID player's stint (order of appearances within a season) teamID Team lgID League Pos Position G Games GS Games Started InnOuts Time played in the field expressed as outs PO Putouts A Assists E Errors DP Double Plays PB Passed Balls ZR Zone Rating ------------------------------------------------------------------------------ 2.5 All-Star table playerID Player ID code Year Year lgID League ------------------------------------------------------------------------------ 2.6 HOF table hofID Player ID code yearID Year of ballot votedBy Method by which player was voted upon ballots Total ballots cast in that year needed Number of votes needed for selection in that year votes Total votes received inducted Whether player was inducted by that vote or not (Y or N) category Category in which can ------------------------------------------------------------------------------ 2.7 Managers table managerID Player ID Number yearID Year teamID Team lgID League inseason Managerial order. Zero if the individual managed the team the entire year. Otherwise denotes where the manager appeared in the managerial order (1 for first manager, 2 for second, etc.) G Games managed W Wins L Losses rank Team's final position in standings that year plyrMgr Player Manager (denoted by 'Y') ------------------------------------------------------------------------------ 2.8 Teams table yearID Year lgID League teamID Team franchID Franchise (links to TeamsFranchise table) divID Team's division Rank Position in final standings G Games played GHome Games played at home W Wins L Losses DivWin Division Winner (Y or N) WCWin Wild Card Winner (Y or N) LgWin League Champion(Y or N) WSWin World Series Winner (Y or N) R Runs scored AB At bats H Hits by batters 2B Doubles 3B Triples HR Homeruns by batters BB Walks by batters SO Strikeouts by batters SB Stolen bases CS Caught stealing HBP Batters hit by pitch SF Sacrifice flies RA Opponents runs scored ER Earned runs allowed ERA Earned run average CG Complete games SHO Shutouts SV Saves IPOuts Outs Pitched (innings pitched x 3) HA Hits allowed HRA Homeruns allowed BBA Walks allowed SOA Strikeouts by pitchers E Errors DP Double Plays FP Fielding percentage name Team's full name park Name of team's home ballpark attendance Home attendance total BPF Three-year park factor for batters PPF Three-year park factor for pitchers teamIDBR Team ID used by Baseball Reference website teamIDlahman45 Team ID used in Lahman database version 4.5 teamIDretro Team ID used by Retrosheet ------------------------------------------------------------------------------ 2.9 BattingPost table yearID Year round Level of playoffs playerID Player ID code teamID Team lgID League G Games AB At Bats R Runs H Hits 2B Doubles 3B Triples HR Homeruns RBI Runs Batted In SB Stolen Bases CS Caught stealing BB Base on Balls SO Strikeouts IBB Intentional walks HBP Hit by pitch SH Sacrifices SF Sacrifice flies GIDP Grounded into double plays ------------------------------------------------------------------------------ 2.10 PitchingPost table yearID Year round Level of playoffs playerID Player ID code teamID Team lgID League W Wins L Losses G Games GS Games Started CG Complete Games SHO Shutouts SV Saves IPOuts Outs Pitched (innings pitched x 3) H Hits R Runs ER Earned Runs HR Homeruns BB Walks SO Strikeouts BAOpp Opponents' batting average ERA Earned Run Average IBB Intentional Walks WP Wild Pitches HBP Batters Hit By Pitch BK Balks BFP Batters faced by Pitcher GF Games Finished R Runs Allowed SH Sacrifice Hits allowed SF Sacrifice Flies allowed GIDP Grounded into Double Plays ------------------------------------------------------------------------------ 2.11 TeamFranchises table franchID Franchise ID franchName Franchise name active Whetehr team is currently active (Y or N) NAassoc ID of National Association team franchise played as ------------------------------------------------------------------------------ 2.12 FieldingOF table playerID Player ID code yearID Year stintID player's stint (order of appearances within a season) Glf Games played in left field Gcf Games played in center field Grf Games played in right field ------------------------------------------------------------------------------ 2.13 ManagersHalf table managerID Manager ID code yearID Year teamID Team lgID League inseason Managerial order. One if the individual managed the team the entire year. Otherwise denotes where the manager appeared in the managerial order (1 for first manager, 2 for second, etc.) half First or second half of season G Games managed W Wins L Losses rank Team's position in standings for the half ------------------------------------------------------------------------------ 2.14 TeamsHalf table yearID Year teamID Team lgID League half First or second half of season divID Division DivWin Won Division (Y or N) rank Team's position in standings for the half G Games played W Wins L Losses ------------------------------------------------------------------------------ 2.15 Salaries table yearID Year teamID Team lgID League playerID Player ID code salary Salary ------------------------------------------------------------------------------ 2.16 SeriesPost table yearID Year round Level of playoffs teamIDwinner Team ID of the team that won the series lgIDwinner League ID of the team that won the series teamIDloser Team ID of the team that lost the series lgIDloser League ID of the team that lost the series wins Wins by team that won the series losses Losses by team that won the series ties Tie games ------------------------------------------------------------------------------ 2.17 AwardsManagers table managerID Manager ID code awardID Name of award won yearID Year lgID League tie Award was a tie (Y or N) notes Notes about the award ------------------------------------------------------------------------------ 2.18 AwardsPlayers table playerID Player ID code awardID Name of award won yearID Year lgID League tie Award was a tie (Y or N) notes Notes about the award ------------------------------------------------------------------------------ 2.19 AwardsShareManagers table awardID name of award votes were received for yearID Year lgID League managerID Manager ID code pointsWon Number of points received pointsMax Maximum numner of points possible votesFirst Number of first place votes ------------------------------------------------------------------------------ 2.20 AwardsSharePlayers table awardID name of award votes were received for yearID Year lgID League playerID Player ID code pointsWon Number of points received pointsMax Maximum numner of points possible votesFirst Number of first place votes ------------------------------------------------------------------------------ 2.21 FieldingPost table playerID Player ID code yearID Year teamID Team lgID League round Level of playoffs Pos Position G Games GS Games Started InnOuts Time played in the field expressed as outs PO Putouts A Assists E Errors DP Double Plays TP Triple Plays PB Passed Balls SB Stolen Bases allowed (by catcher) CS Caught STealing (by catcher) ------------------------------------------------------------------------------