About the Guru's
Baseball Data
|
![]() ![]() ![]() ![]() Downloadable Spreadsheets Would you mind joining the Guru's mailing list?
MLB Season data: mlb2022.xls / mlb2021.xls Actuals*: mlb2020.xls - For the shortened 2020 season, two sets of stats are given (actual and projected). mlb2019.xls / mlb2018.xls / mlb2017.xls / mlb2016.xls / mlb2015.xls / mlb2014.xls / mlb2013.xls / mlb2012.xls / mlb2011.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 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 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 PREVIOUS YEARS (Excel spreadsheet files): 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 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 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.
![]() Fields: playtmlgyr LASTNAME FIRSTNAME YEAR TEAM LG salary playerID mlbam
![]() Fields: ID, Team, LG (league), Team LG, Team LGYearF, Year, GateRec, MediaRev, StadiumRev, OtherRev, TotalRev, PlayerCosts, OperatingExp, OperatingIncome, FranchiseValue ![]() 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) ![]() Fields: BALLPARK, Year, TeamLG ![]() Fields: TEAMLGYEARF, LG, City, Franchise, Team, TeamLG, YearF(first), YearL(last), Team Name ![]() Fields: TEAMLGYEARF, Team LG, TEAM, LG, Appearances, Wins, Losses, PCT, Team Name ![]() 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
![]()
Browse our affiliates :-) Sabermetricians: Ask how you can post your baseball analysis on BaseballGuru.com Become a member of the Guru's BrainTrust
|