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...
3903
Tangotiger
tom@...
Feb 5, 2010 8:55 pm
In conjunction with the earlier mention, jonesja05 (Jason Dewey Jones) should have a STATS Id of 7191 not 6246. Basically, the two were swapped. Tom ... The...
3904
Tangotiger
tom@...
Feb 5, 2010 9:59 pm
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...
3905
Tangotiger
tom@...
Feb 5, 2010 11:17 pm
I forgot to note that these are showing duplicates based on conflicting data sources and I haven’t tried to resolve them yet: bis_id mlbam1 mlbam2 18 297292...
3906
Wells Oliver
xmutex
Feb 9, 2010 4:12 am
Am I missing something or is this not included in the Pitching table, nor derivable- there's no doubles nor triples. -- Wells Oliver wells@......
3907
Clem Comly
ccomly2003
Feb 9, 2010 4:31 am
They are not official statistics. It is available on Retrosheet for seasons that have 100% play-by-play and for recent seasons where p-b-p are available. Clem...
3908
mitchell m
mmc_cann
Feb 9, 2010 5:42 pm
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...
3909
Theodore Turocy
arb1ter
Feb 9, 2010 5:59 pm
... There's a basic logical fallacy in this argument. The example shows that when something is unknown implies it should be represented as a NULL. It does not...
3910
Tangotiger
tom@...
Feb 9, 2010 6:28 pm
... Ted is correct in his other response. We want to classify things as: a - known to not have occurred b - unknown to have occurred c - impossible to have...
3911
mitchell m
mmc_cann
Feb 10, 2010 7:50 pm
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...
3912
Sean Forman
sforman71
Feb 10, 2010 7:52 pm
Mitchell, Replacing nulls with zero on your end is trivial. Using excel, do a find replace. Using linux, write a perl or sed script to replace. Using a ...
3913
tangotiger
Feb 10, 2010 9:27 pm
IIRC, SF came in and out of existence. If the BDB is showing 0 where it should be null based on the definition, then that should be corrected. A database is...
3914
tangotiger
Feb 10, 2010 9:29 pm
By the way, you COULD use "-1" to represent one of the two conditions I noted in my first email, with null taking the other. This though is going to be extra...
3915
Rod Nelson
rockymtnsabr
Feb 10, 2010 10:54 pm
If the concept of baseball data in book form appeals to you, you'll want to download The Emerald Guide to Baseball - 2010 in PDF format from ...
3916
Alberto Perdomo
albertop69
Feb 11, 2010 1:35 pm
Rod, Thanks for this wonderful guide! There is a minor error in the table of contents (page vi) ... Florida State League is shown as Class A instead of...
3917
mitchell m
mmc_cann
Feb 15, 2010 4:50 pm
Sean, Tom, Yes it is easy to change NULLs to zeds. I've got lots of practice. Then I decided that it would be easier to alter the defaults. Then I noticed...
3918
Bryan Walko
bryanwalko
Feb 15, 2010 4:50 pm
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...
3919
Michael Westbay
westbaystars
Feb 16, 2010 12:39 am
... 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....
