About the Guru's Baseball
Fantasy Insider Other Baseball Stat Resources Statistics books Player Forecasts!!
MLB 2014 Season data: mlb2014.xls
Below is the list of variables in these spreadsheets. Some are sabermetric and Guru inventions. Glossary and Forecasts
Variables for Batters: playerID nameFirst nameLast bats throws age year stints teamID lg G tap AB R H db tr HR RBI SB CS BB SO IBB hbp SH SF GIDP avg obp slg woba PRO GURU ROTO pos1 g1 pos2 g2 pos3 g3 pos4 g4 pos5 g5 gs5 baseball_prospectus_id mlbam_id
Variables for Pitchers: playerid nameFirst nameLast throws age year stints teamID LG POS1 W L CG GP GS SV IPOuts ip ERA HA ER HRA BBA SOA IBBA WP HPBA BK BFP RA CMD DOM CTL HR9 WHIP WRIP HRBIB RAVG FIP DERA babip babipera STUFF GURU ROTO baseball_prospectus_id mlbam_id
MLB 2013 Season data: mlb2013.xls
MLB 2012 Season data: mlb2012.xls
MLB 2011 Season data: mlb2011.xls
MLB 2010 Season data: mlb2010.xls
MLB 2009 Season data: mlb2009.xls
Below is the list of variables in the spreadsheet. Some are sabermetric and Guru inventions. Glossary and Forecasts
Variables for Batters: playerID nameFirst nameLast bats throws age year stints teamID lg G tap AB R H db tr HR RBI SB CS BB SO IBB hbp SH SF GIDP avg obp slg woba PRO GURU pos1 g1 gs1 innouts1 po1 a1 e1 dp1 pb1 pct1 pos2 g2 gs2 innouts2 po2 a2 e2 dp2 pb2 pos3 g3 gs3 innouts3 po3 a3 e3 dp3 pb3 pos4 g4 gs4 innouts4 po4 a4 e4 dp4 pb4 pos5 g5 gs5 innouts5 po5 a5 e5 dp5 pb5
Variables for Pitchers: playerID nameFirst nameLast throws age year teamID LG POS1 W L CG GP GS SHO SV IPOuts ip ERA HA ER HRA BBA SOA IBBA WP HPBA BK BFP GF RA LOB loba CMD DOM CTL HR9 WHIP WRIP HRBIB RAVG FIP DERA babip babipera STUFF GURU
Here is the complete list of variables: playerID LG TEAM bats throws FNAME LNAME POSNUM1 POS1 age teamID G OPS SLG AVG OBP AB R H 2B 3B HR RBI BB SO SB CS SBPCT GIDP HBP SH SF IBB ERA GS W L PCT CG SV IP IPouts HA ER BBA SOA GP HRA SHO WHIP GF BFP HBPA IBBA WP BK RA G1 InnOuts1 PO1 A1 E1 DP1 PB1 FPCT1 POSNUM2 POSNUM3 POSNUM4 POSNUM5 G2 G3 G4 G5
MLB 2006 Season data: mlb2006.xls
This years data set wil have everything. Here is the complete list of variables: ID LG TEAM bats FNAME LNAME pos1num Pos1 Age G OPS SLG AVG OBP AB R H 2B 3B HR RBI BB SO SB CS SBPCT GDP HBP SH SF IBB OPS+ ERA GS W L PCT CG SV IP HA RA ER BBA SOA GP HRA SHO WHIP GF BFP HBPA IBBA ERA+ INN1 GS1 G1 PO1 A1 E1 DP1 FPCT1 PB DH_G POS2 INN2 GS2 G2 PO2 A2 E2 DP2 FPCT2 POS3 INN3 GS3 G3 PO3 A3 E3 DP3 FPCT3 POS4 INN4 GS4 G4 PO4 A4 E4 DP4 FPCT4 POS5 INN5 GS5 G5 PO5 A5 E5 DP5 FPCT5
This years data set wil have everything. Here is the complete list of variables: ID, LG, TEAM, FName, LName, G, OPS, SLG, AVG, OBP, AB, R, H, 2B, 3B, HR, RBI, BB, SO, SB, CS, SBPCT, ERA, GS, W, L, PCT, CG, SV, IP, HA, RA, ER, BBA, SOA, GP, HRA, SHO, WHIP, BAA, Year, TEAMLG, POS1, G1, TC1, INN1, PO1, A1, E1, DP1, FPCT1, RF1, ZR1, PB1, SBA1, CSA1, CSAPCT1, CERA, POS2, G2, TC2, INN2, PO2, A2, E2, DP2, FPCT2, PB2, SBA2, CSA2, CSAPCT2, POS3, POS4, POS5, G3, G4, G5
This years data set has all batting and pitching data, fielding is limited to primary position and errors. Here is the complete list of variables: LG, Team, FNAME, LNAME, pos1, G, OPS, SLG, AVG, OBP, AB, R, H, 2B, 3B, HR, RBI, BB, SO, SB, CS, HBP, SAC, SF, ERA, GS, W, L, PCT, CG, SV, IP, HA, RA, ER, BBA, HB, SOA, WP, BALKS, HRA, SHO, BATS, THROWS, G5, pos5, G4, pos4, G3, pos3, G2, pos2, G1, PO1, A1, DP1, E1, Year, TEAM LG
MLB 2001 Season data: mlb2001.zip
Fields: LG, TEAM, FNAME, LNAME, pos1num, G, OPS, SLG, AVG, OBP, AB, R, H, 2B, 3B, HR, RBI, BB, SO, SB, CS, IBB, HBP, GIDP, SAC, SF, ERA, GS, W, L, PCT, CG, SV, GF, IP, HA, RA, ER, BBA, SOA, LahmanID, Bats, Throws, A1, E1, DP1, PO1, POS2, POS3, POS4, POS5
Fields: Year, LG, Pos, TEAM, LahmanID, Player Name, QOP (secret performance stat), G, AB, R, H, 2B, 3B, HR, RBI, BB, HPB, SO, SB, CS, AVG, OBA, SLG, OPS. NOTE: 1999 data has RANK insteas of QOP.
Fields: Year, LG, POS, TEAM, LahmanID, Player Name, QSO (secret performance stat), W, L, ERA, G, GS, CG, SH, QS, QS%, IP, H, ER, HR, BB, SO, SO%, SV, HD, BS. NOTE 1999 data has RANK instead of QSO and 1999 QS, QS%, HD and BS will be added as it becomes available.
salary.zip - Complete yearly salaries by player for 1985 through 2010.
Fields: playtmlgyr LASTNAME FIRSTNAME YEAR TEAM LG salary playerID mlbam
biz.zip - Complete yearly MLB cash flows by team for 1990 through 1996 in millions of dollars.
Fields: ID, Team, LG (league), Team LG, Team LGYearF, Year, GateRec, MediaRev, StadiumRev, OtherRev, TotalRev, PlayerCosts, OperatingExp, OperatingIncome, FranchiseValue
stadium.zip - Stadiums listed by Team, League and Year of first season. Seating capacities, field dimensions and park factor represent a typical season. Complete for 1998, some data as far back as 1884, including disbanded teams.
Fields: STADIUMID, LG, Team, TeamLG, Stadium, Location, B_YR (beginning), E_YR (ending), Team Name, Capacity, Surface, Surf (abbr), LF Fence, CF Fence, RF Fence, Grandstand, Alley LF, Alley RF, HT LF (height), HT CF, HT RF, PF (Typical Expected Park Factor), Number (counter)
ballpark.zip - Ballparks listed by name, the first year it was used for MLB play and the team that played there.
Fields: BALLPARK, Year, TeamLG
teams.zip - All Major League teams from 1871-2001.
Fields: TEAMLGYEARF, LG, City, Franchise, Team, TeamLG, YearF(first), YearL(last), Team Name
wsteams.xls - World Series team summary totals. Complete through 2001.
Fields: TEAMLGYEARF, Team LG, TEAM, LG, Appearances, Wins, Losses, PCT, Team Name
worldseries.zip - Yearly World Series and Post Season results and stats, 2001 back to 1884.
Fields: TMLGYEAR, Result, TeamLG, TMLGYEARF, TEAM, LG, Year, WinCount, LossCount, Team Name, Wins, Losses, Pct, RF, RA, Manager, CWins, CLosses, CAppearances, ws_mvp, ws_w, ws_l, ws_rf, ws_ra, lcs_w, lcs_l, lcs_rf, lcs_ra, div_w, div_l, div_rf, div_ra, WorldSeries (Y/N), w_post, l_post, pct_post, rfpost, rapost, w_total, l_total, pct_total, rftotal, ratotal
Japanese Baseball Data Archive
Sabermetricians: Ask how you can post your baseball analysis on BaseballGuru.com
Become a member of the Guru's