World Series Videos out of print and rare SABR's Essential Gift Ideas & more... Guru's Picks: Baseball: A Film by Ken Burns - Nine Inning Set

About the Guru's Baseball Data
Source Data:  The data in this private archive was compiled from various sources. Older data was largely dependent on Sean Lahman's database at Baseball1.  
Data Format:  I saved all data as Excel spreadsheets for Windows (Mac users will need to convert the files).  I chose spreadsheet form over plain text (or ascii) because it will be easier to import into Access or other database or spreadsheet software for most people.  For those using SAS, SPSS or other advanced statistical software, I recommend DBMS/Copy software for data format conversion.
Primary Key: Fields shown in bold face represent the primary key.
Downloading Data:  I compressed all of the files using WinZip software to save disk space and shorten downloading times.  If you do not have WinZip software you can download for free from www.shareware.com.
Updates: Check back here regularly because new data gets added often!

You are the manager. Real players & stats. Easy to Play. Try it!

Click on the Stadium to play the Guru's Free online baseball game.

<EMBED src="http://baseballguru.com/awards.mid" autostart=true volume=100>   

   Data Archive: The Guru's Private Stock

Downloadable Spreadsheets

Would you mind joining the Guru's mailing list?  I like to keep track of who's using the data so that I can send update info.

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):

MLB 2010 Season data: mlb2010.xls MLB 2009 Season data: mlb2009.xls MLB 2008 Season data: mlb2008.xls and by team: mlb2008byteam.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

MLB 2007 Season data:  mlb2007.xls and by team: mlb2007byteam.xls

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

MLB 2005 Season data: mlb2005.xls  and by team: mlb2005byteam.xls

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

MLB 2004, 2003, and 2002 Season data: mlb2004.xls  |mlb2003.xls  |  mlb2002.xls

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

Batter's Data: bat97.zip | bat98.zip | bat99.zip | bat2000.zip - Complete yearly batting stats for American.and National leagues for 1997, 1998 and 1999.

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.

Pitcher's Data:  pit97.zip | pit98.zip | pit99.zip | pit2000.zip - Complete yearly pitching stats for American.and National leagues for 1997, 1998 and 1999.

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 :-) 33% off USA TODAY Baseball Warehouse Grand Slam Mall

Sabermetricians: Ask how you can post your baseball analysis on BaseballGuru.com

Become a member of the Guru's BrainTrust
Keep informed of the latest developments. The Braintrust is a free newsletter.