Baseball Books, CD's, Videos, Software, Toys


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.  
Primary Key: Fields shown in bold face represent the primary key; MLBAM_ID or PLAYERID (which is nearly always the same as baseabll-reference).
Updates: Sorry this page is largely out of date. It is on my to do list to make this really cool with original stats and insights. In the mean time, please see my Player Forecasts page.

- Craig (the Guru)

The Guru's FAMOUS Baseball Boardgame
You are the manager. Real players & stats. Easy to Play. Try it!

Complete game playing directions Strategy and base running charts Player Cards: 1996 World Series - Yankees & Braves

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

<EMBED src="http://baseballguru.com/awards.mid" autostart=true volume=100> BaseballGuru.com Home Page Clubhouse!  

 Baseball Data Archive  Data Archive: The Guru's Private Stock


Fantasy Insider Other Baseball Stat Resources   Statistics books  Player Forecasts!!

Downloadable Spreadsheets

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

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.zipbat98.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.zippit98.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.


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

HomeGuru's Baseball Book StoreLink to UsBraintrust & Mailing ListsEmail the GuruContact InfoRead baseball analysis

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.