For anyone who's an international baseball geek, I noticed that outside of the US, the only decent historical stats were for the Japanese League. The Korean...
Tango Tom and other interest baseball data bank users, Wednesday, You really believe that the present NULL defaulting plan up is justified and most correct. I...
Paul DuBois, "MySQL Cookbook," recipe 1.2 creates a database of limbs. Humans have 2 arms and 2 legs. Insects get 6 legs and 0 arms. A phonograph gets 1 arm...
I have found a willing partner in MLBAM to provide all their IDs. I have taken the first step of cobbling ID maps of various people and sources, and have...
Line 1: Player MLBAM BDB Retro Line 2: correct STATS, but has incorrect in Xref_Stats Chris Smith 434672 smithch07 smitc002 8253 not 6378 Jacque Jones 150218...
Is there some way to finagle baseball-reference.com, either the leaderboards or using the play index, to show yearly team totals? Like I want to sort all ...
I was reading through the Statement of Purpose and looking for the BDB license. We are thinking about publishing a book that would include a minimal amount of...
Maybe 58 days till catchers and pitchers report. The 2009 data now works on my Acer aspire one running Vista. I originally tried loading it in the MySQL part...
I've noticed that the Batting table has some errors. There are numerous pitchers who are not included on the batting table, most of whom seem to be first year...
Hey, hopefully someone here might be able to tell me where I've gone wrong. I'm trying to manually generate the Marcel projections in order to, well, get a...
All the DNP 2009 AllStars in AllStarFull table appear to have null not 0 for GP. No other row has a value other than 0 or 1. The 2009 stars that did play...
The Teams record for BOS 1947 has 157 for G, not 154. BOS won 83 and lost 71- I'm guessing 157 is in error? Or am I mistaken? Thanks. -- Wells Oliver ...
Below the mlbId for the 204 players debuted on 2009 allenbr01,450315 anderbr04,474463 andruel01,462101 atkinmi01,444444 augenbr01,446248 avilaal01,488671 ...
The use of alphanumeric player Ids, while not preferable for B design, works well for ad hoc queries. For example, I have created a switchboard in Access that...
Think i have found these differences, please check. --Sean Gallagher played in 14 games not 8 (gallase01) http://mlb.mlb.com/team/player.jsp?player_id=451595 ...
Below the playerId/mlbId mapping for the 204 new players on 2009. allenbr01,450315 anderbr04,474463 andruel01,462101 atkinmi01,444444 augenbr01,446248 ...
204 new players I only did a cursory check. Tom retro bdb alleb001 allenbr01 andeb004 anderbr04 andre001 andruel01 atkim001 atkinmi01 augeb001 augenbr01 ...
David Huff played his first game: "2009-05-17", not "2009-05-23" http://www.baseball-reference.com/boxes/TBA/TBA200905170.shtml Tom ... The Book--Playing The...
This also exists in the MySQL version. Maybe I'm misreading things, but... there's a player with playerID smithch07 in the Master table, Chris Smith. The...
Is there any existing cross reference for any of the IDs in the Master table (lahman, retro, etc) to those used by MLB.com? Thanks. -- Wells Oliver ...
I just happened to notice that the combined outfield fielding line was not included in the Fielding table for the 2008 season - only separate LF/CF/RF entries...
Is there a list that maps either the mlbmaster table to the player_id mlb.com uses? Also, does anyone know when the new data is generally available on...
Hello, I am getting familiar with the Retrosheet play by play data which is ready to be imported into a relational database. I was wondering what methodology...
Baseball Reference and Retrosheet have Valverde born July 24, 1979, but ESPN, CBS Sportsline, and Fan Graphs have him born March 24, 1978. MLB Trade Rumors has...
