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...
3860
Tangotiger
tom@...
Nov 25, 2009 11:34 pm
204 new players I only did a cursory check. Tom retro bdb alleb001 allenbr01 andeb004 anderbr04 andre001 andruel01 atkim001 atkinmi01 augeb001 augenbr01 ...
3861
albertop69
Nov 26, 2009 9:13 pm
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 ...
3862
Alberto Perdomo
albertop69
Nov 26, 2009 9:14 pm
Below the playerId/mlbId mapping for the 204 new players on 2009. allenbr01,450315 anderbr04,474463 andruel01,462101 atkinmi01,444444 augenbr01,446248 ...
3863
Alberto Perdomo
albertop69
Nov 26, 2009 9:18 pm
Hi, all: I've been checking the master table and have found, that according to MLB. . Bryan Augenstein's (446248/augenbr01) birth city is Sebastian not...
3864
Sean Forman
sforman71
Nov 26, 2009 9:23 pm
The batting table does not include games for the pitcher when there was a dh. It is only when they appear in the lineup that they get a batting game played....
3865
Tangotiger
tom@...
Nov 27, 2009 5:47 am
http://www.insidethebook.com/ee/index.php/site/article/player_id_mappings_2009/ Tom ... The Book--Playing The Percentages In Baseball ...
3866
Rod Nelson
rockymtnsabr
Nov 27, 2009 7:25 am
Hi Tom - this seems to be a perpetual problem.. Either that, or I'm clueless. burneaj01 burnea.01 ...
3867
Tangotiger
tom@...
Nov 27, 2009 3:34 pm
I'm not sure I understand the problem. The player_id in the bdb is not the same as the player_id on b-r.com. Indeed, there is a b-r.com id in the Master...
3868
tangotiger
Nov 27, 2009 3:38 pm
GReat job Sean. I ran the files through my loader shell, and it looks like everything works fine. No changes needed. Tom ... Tim Raines, Hall of Fame 2008 ...
3869
Alberto Perdomo
albertop69
Nov 29, 2009 7:59 pm
Below the mlbId for the 204 players debuted on 2009 allenbr01,450315 anderbr04,474463 andruel01,462101 atkinmi01,444444 augenbr01,446248 avilaal01,488671 ...
3870
Alberto Perdomo
albertop69
Nov 29, 2009 8:05 pm
Great! Processing the new data, noticed that fielding and appearances tables have new columns. What does contains/means the 'experience' column in the...
3871
Sean Forman
sforman71
Nov 30, 2009 3:17 pm
missing_g are cases where either the official and pbp accounts differ on games played (perhaps the player was injured while batting and never took the field or...
3872
Wells Oliver
xmutex
Dec 2, 2009 4:06 am
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 ...
3873
Sean Forman
sforman71
Dec 2, 2009 4:07 am
I haven't looked at the gamelogs, but I'm guessing they had three ties due to games called on account of darkness. Happened a lot back then. sean ... Sean...
3874
Wells Oliver
xmutex
Dec 2, 2009 4:29 am
Ah yeah, that's it, BOS had 3 ties in 1947. Any idea if PA/ABs in these games count towards batting title dis/qualification? On Tue, Dec 1, 2009 at 10:07 PM,...
3875
Sean Forman
sforman71
Dec 2, 2009 4:32 am
Meaning they need 511 rather than 502? I don't think that rule was in effect back then. I'm guessing that in more modern cases they only need the 502, but...
3876
Mike Emeigh
mwemeigh
Dec 2, 2009 4:48 am
Rule is per scheduled game. Replays of tie games are not scheduled games. Sent from my BlackBerry Smartphone provided by Alltel ... From: Sean Forman...
3877
Wells Oliver
xmutex
Dec 2, 2009 5:21 am
Well from 1945 - 56 it's 2.6 AB per team game, so would that be 154 team games or 157? Really really fringe case (and I am not sure it'd change anything), but...
3878
Clem Comly
ccomly2003
Dec 2, 2009 5:22 am
In 1947 you needed 400 AB. Period. Nowadays it is 3.1 PA/ "game scheduled" so a tie game or an end of season playoff game doesn't raise the bar. Clem Comly ...
3879
Clem Comly
ccomly2003
Dec 11, 2009 1:21 pm
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...
3880
Sean Forman
sforman71
Dec 11, 2009 1:22 pm
Thanks, I will fix this. sean ... Sean Forman Sports Reference LLC, President http://www.sports-reference.com/...
3881
Dan
draysgorocco
Dec 21, 2009 5:56 pm
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...
3882
Wells Oliver
xmutex
Dec 21, 2009 5:56 pm
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...
3883
KJOK
kjokbaseball
Dec 21, 2009 6:43 pm
I have a spreadsheet that simulates the Marcel process.   My calculations seem to be hitting the correct numbers for Beltran. I think it might be easiest...
3884
Sean Smith
briandkaat
Dec 22, 2009 12:30 am
Just an idea, but are you removing pitcher hitting from the league totals? That might be just enough to throw the numbers off by 1. Sean Smith...
3885
Wells Oliver
xmutex
Dec 22, 2009 12:57 am
Wanted to say thanks- that this is quite helpful. One last question- how does Marcel deal with a player not having three league years of data? Do the 5/4/3...
3886
Wells Oliver
xmutex
Dec 22, 2009 12:59 am
I'm thinking that might be it. I am currently using this query to get batters: SELECT Batting.playerID FROM Batting LEFT JOIN Pitching ON Pitching.playerID =...
3887
wyerscj
Dec 22, 2009 11:35 am
I did a similar project a year or so ago. Full source code is here: http://basql.wikidot.com/marcels...
3888
Sean Forman
sforman71
Dec 22, 2009 2:06 pm
... This is by design. They were AL pitchers who never appeared in a batting lineup. The Appearances table should now be the go to place for games played...
