The Baseball Guru's Private Data Archive

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!

Data Archive: The Guru's Private Stock

Other Baseball Stat Resources

Statistics books

Fantasy Insider

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

PREVIOUS YEARS (Excel spreadsheet files):

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.

hof.zip - Complete list of Hall of Famers through 2006, sorted by year inducted then alphabetically by last name.

Fields: RecNum, LahmanID, LName, FName, Indicted, By, Ballots, Votes, Pct, Pos, Category

allstar.zip - Complete list of All Stars including 2000, sorted alphabetically then by year.

Fields: LahmanID, FName, LName, Year, TEAM LG

salary.zip - Complete yearly salaries by player for 1985 through 1998.

Fields: SalaryID, Player Name, Team, LG (league), Year, Salary, TeamLG, PID, LahmanID, LIDYEAR, playtmlgyr

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-present.

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