Out[3]:
Table |
Columns |
allstarfull |
playerID, yearID, gameNum, gameID, teamID, lgID, GP, startingPos |
appearances |
yearID, teamID, lgID, playerID, G_all, G_batting, G_defense, G_p, G_c, G_1b, G_2 b, G_3b, G_ss, G_lf, G_cf, G_rf, G_of, G_dh, G_ph, G_pr |
awardsmanagers |
managerID, awardID, yearID, lgID, tie, notes |
awardsplayers |
playerID, awardID, yearID, lgID, tie, notes |
awardssharemanagers |
awardID, yearID, lgID, managerID, pointsWon, pointsMax, votesFirst |
awardsshareplayers |
awardID, yearID, lgID, playerID, pointsWon, pointsMax, votesFirst |
battingpost |
yearID, round, playerID, teamID, lgID, G, AB, R, H, 2B, 3B, HR, RBI, SB, CS, BB, SO, IBB, HBP, SH, SF, GIDP |
fielding |
playerID, yearID, stint, teamID, lgID, POS, G, GS, InnOuts, PO, A, E, DP, PB, WP , SB, CS, ZR |
fieldingof |
playerID, yearID, stint, Glf, Gcf, Grf |
fieldingpost |
playerID, yearID, teamID, lgID, round, POS, G, GS, InnOuts, PO, A, E, DP, TP, PB , SB, CS |
halloffame |
hofID, yearid, votedBy, ballots, needed, votes, inducted, category |
hofold |
hofID, yearid, votedBy, ballots, votes, inducted, category |
managers |
managerID, yearID, teamID, lgID, inseason, G, W, L, rank, plyrMgr |
managershalf |
managerID, yearID, teamID, lgID, inseason, half, G, W, L, rank |
master |
lahmanID, playerID, managerID, hofID, birthYear, birthMonth, birthDay, birthCoun try, birthState, birthCity, deathYear, deathMonth, deathDay, deathCountry, death State, deathCity, nameFirst, nameLast, nameNote, nameGiven, nameNick, weight, he ight, bats, throws, debut, finalGame, college, lahman40ID, lahman45ID, retroID, holtzID, bbrefID |
pitching |
playerID, yearID, stint, teamID, lgID, W, L, G, GS, CG, SHO, SV, IPouts, H, ER, HR, BB, SO, BAOpp, ERA, IBB, WP, HBP, BK, BFP, GF, R, SH, SF, GIDP |
pitchingpost |
playerID, yearID, round, teamID, lgID, W, L, G, GS, CG, SHO, SV, IPouts, H, ER, HR, BB, SO, BAOpp, ERA, IBB, WP, HBP, BK, BFP, GF, R, SH, SF, GIDP |
salaries |
yearID, teamID, lgID, playerID, salary |
schools |
schoolID, schoolName, schoolCity, schoolState, schoolNick |
schoolsplayers |
playerID, schoolID, yearMin, yearMax |
seriespost |
yearID, round, teamIDwinner, lgIDwinner, teamIDloser, lgIDloser, wins, losses, t ies |
teams |
yearID, lgID, teamID, franchID, divID, Rank, G, Ghome, W, L, DivWin, WCWin, LgWi n, WSWin, R, AB, H, 2B, 3B, HR, BB, SO, SB, CS, HBP, SF, RA, ER, ERA, CG, SHO, S V, IPouts, HA, HRA, BBA, SOA, E, DP, FP, name, park, attendance, BPF, PPF, teamI DBR, teamIDlahman45, teamIDretro |
teamsfranchises |
franchID, franchName, active, NAassoc |
teamshalf |
yearID, lgID, teamID, Half, divID, DivWin, Rank, G, W, L |
tmp_batting |
playerID, yearID, stint, teamID, lgID, G, G_batting, AB, R, H, 2B, 3B, HR, RBI, SB, CS, BB, SO, IBB, HBP, SH, SF, GIDP, G_old |