... The original data set is at the above location. The links to the 2009 data can be found here: ...
3920
Tangotiger
tom@...
Feb 16, 2010 4:10 am
... If you followed my rules, then you would have to conclude that there is never an occasion in playoff baseball that someone hit a HR and we didn' t know...
3921
mitchell m
mmc_cann
Feb 16, 2010 4:51 am
I'm still learning how to use the up load features of other parts of this group.... On the Open Office spreadsheet it is pretty easy to change the display...
3922
wydiyd
Feb 22, 2010 7:01 pm
I just ran a query on all the colleges that players attended. The numbers are lower than the ones from B-ref. In a couple of case, the player attended two...
3923
Wells Oliver
xmutex
Feb 23, 2010 8:33 pm
Sorry, is there a definitive place to go (or an almost definitive place to go) for a csv/mysql export of MLBAM IDs mapped to retro/bbref IDs? I'll make a...
3924
Tangotiger
tom@...
Feb 23, 2010 8:58 pm
The definitive will be in this thread: www.insidethebook.com/ee/index.php/site/comments/the_universal_player_id_and_biographical_data_project/ I'm still...
3925
Wells Oliver
xmutex
Mar 1, 2010 8:14 pm
Hey everyone. I'm working through some little things and I'm wondering if I am just missing something obvious: what I'd like to do is use the Gameday data to...
3926
Wells Oliver
xmutex
Mar 4, 2010 8:27 pm
ARGH, nevermind- was using 'content' and not 'component'. Apologies to one and all. ... -- Wells Oliver wells@......
3927
Sean Forman
sforman71
Mar 4, 2010 8:28 pm
sean ... Sean Forman Sports Reference LLC, President http://www.sports-reference.com/...
3928
Wells Oliver
xmutex
Mar 4, 2010 9:20 pm
Anyone know if MLB.com is still going to provide the standard XML data for Gameday this year? I know it's just spring training, and so no pitchfx data, but...
3929
Paul Golba
pgolba2
Mar 11, 2010 1:12 pm
First email as part of the group. Apologies if I am violating any protocols. I've been trying to use the Baseball Databank (BDB) database to compute Win...
3930
Tangotiger
tom@...
Mar 11, 2010 2:19 pm
... This is absolutely the right place. And while you didn't break any protocols (if we even have any), from where I sit you can break whatever protocols you...
3931
Wells Oliver
xmutex
Mar 18, 2010 5:44 pm
So a quick question here- I'm working on my little projection system and I'm doing a lot of hacky crap to put together the "list of MLB players" to project....
3932
Tangotiger
tom@...
Mar 18, 2010 6:14 pm
If you are ONLY going to use players with a BDB_ID, why don't you do: select player_id from batting where year_id between 2007 and 2009; Tom ... The...
3933
Tangotiger
tom@...
Mar 18, 2010 6:17 pm
select distinct player_id ... Tom...
3934
kgold11
Mar 20, 2010 2:42 am
If I have a file with retroID and player name, are there files out there that I can use to link those names with a team? I would prefer to use Excel if...
3935
SABRMnLgs@...
sabrmnlgs
Mar 21, 2010 1:41 am
you need to contact _Sean-Foreman@..._ (mailto:Sean-Foreman@...) In a message dated 3/19/2010 10:42:20 P.M. Eastern...
3936
Tangotiger
tom@...
Mar 21, 2010 3:08 pm
Do I understand you correctly that you want to see: playerID,teamID So that you will see the team for every player the team the player played on? In that case:...
3937
kgold11
Mar 22, 2010 2:09 pm
Thanks Tango. This worked perfectly....
3938
Wells Oliver
xmutex
Mar 26, 2010 7:31 pm
Trying to figure out league adjustments for 2009- doing HR per 9 right now. Querying like so: SELECT SUM(HR), SUM(HR) / SUM(IPouts / 3) * 9, lgID FROM Pitching...
3939
Tangotiger
tom@...
Mar 26, 2010 9:01 pm
Your method of multiplying the AL HR rate by 89% to get it to the same mean as the NL rate implies that the average AL pitcher = average NL pitcher. This is...
3940
Wells Oliver
xmutex
Mar 26, 2010 9:15 pm
Which of the lovely attributes in the <pitch> elements contains where the pitch was in the strike zone? (the numbers you use to make a heat map) ...
3941
Clay Dreslough
dreslough
Mar 29, 2010 12:45 am
I don't know the answer to this, but looking at the data I would guess this is what they are doing: These two coordinates show where the ball crossed the...
3942
Wells Oliver
xmutex
Mar 29, 2010 5:50 pm
Any idea what would account for the difference in career split totals on yahoo.com and baseball-reference.com? Ichiro on Yahoo: ...
3943
Sean Forman
sforman71
Mar 29, 2010 6:03 pm
Wells, You need to be a lot more specific. What are the differences you are seeing? sean ... Sean Forman Sports Reference LLC, President ...
3944
Tangotiger
tom@...
Mar 29, 2010 6:11 pm
Also, look at Retrosheet as the "tie-breaker". Tom...
3945
Anthony Giacalone
anthonygiaca...
Mar 29, 2010 7:10 pm
Sean, I noticed that bb-ref normalized career splits are messed for pitchers at least. They are off by a column and they don't seem to equal the right number...
3946
Wells Oliver
xmutex
Mar 29, 2010 7:12 pm
Sorry, was kind of a pre-caffeine question. The importat numbers (AB, H, etc) are the same between b-ref and Yahoo for Ichiro's splits are the same. The only...
3947
Sean Forman
sforman71
Mar 29, 2010 7:13 pm
Anthony, I think that has been fixed. Let me know if that is not the case. sean ... Sean Forman Sports Reference LLC, President ...
3948
Sean Forman
sforman71
Mar 29, 2010 7:16 pm
... My guess is that for some of them they may be counting games where any pitcher was a RH or LH rather than just games he faced one. They may also be...
