Conversation on this mailing list has gotten pretty spotty, and I was wondering if there is any plan for an updated BD database? I've got hitters and pitchers...
There's actually an updated database posted at http://www.baseball-databank.org/ I noticed it the other day. I'm not sure if it's the final release for this...
... I haven't compared the numerical data in the new version with other sources yet. However, if anyone does use that version, there's a couple things to know...
... That is a Beta release. It has a couple of minor slight errors that will be corrected by the time the main release is announced. (From what I remember,...
Tangotiger
tom@...
Dec 10, 2007 6:02 pm
3493
Tom, Is there an ETA for the final release? Is there anything those not involved in the process now can do to help? Thanks. Peter...
... I would suspect it would be prior to Xmas, but I can't confirm that. I don't think there's anything you can do to speed up the process. However, I am...
Tangotiger
tom@...
Dec 11, 2007 4:18 pm
3495
I don't mean to be a complainer, but in case this has inadvertently slipped through the cracks - some of the postseason data is incomplete for recent seasons....
... I can't speak for anyone else, but complaints that can lead to corrective responses (like the above post) are always appreciated, and specifically, ...
Tangotiger
tom@...
Dec 11, 2007 10:52 pm
3497
I also neglected to mention - in addition, there are no entries in FieldingPost for these three seasons (2005-2007). Doug ... corrective ... specifically,...
Two of the lines in FieldingOF do not have corresponding lines in Fielding "lehanmi01",1884,1,1,0,0 "geisem01",1882,1,0,3,2 "lehanmi01",1884,1,1,0,0 Mike...
Just an FYI... BDB is using "LAA" as the Angels team ID, starting in 2005. Retrosheet has continued to use "ANA". For the years 1961-1964, both however use...
... We should definitely change one of the LAA. That shouldn't have happened. Key changes are problematic. As a general rule, any key changes need to be...
Tangotiger
tom@...
Dec 31, 2007 3:35 pm
3501
Tom: Yes, that's what I was trying to hint at - changing one of the LAA would be the easiest way to go. I assume the Lahman database will have the same issue? ...
I think I've mentioned this for a couple of years, but the 1891 AA Philadelphia team has a Team ID of PH4, but I believe it really should be PHQ. The...
I'm sorry if this is a dumb question but I wasn't able to find the answer on the site or FAQ, but what is the different between the Baseball-Databank database...
... Not a dumb question. The underlying data is the same, as are the table structures. The Lahman database is distributed primarily in MS Access format,...
... Is this something that may be addressed in the future? I prefer the CSV files to SQL personally, since they're platform independent... Thanks, Andy...
... The BDB files are csv and SQL: http://baseball-databank.org/files/ I always use the csv files, and import them into my database. The Lahman database is set...
Tangotiger
tom@...
Jan 7, 2008 8:42 pm
3509
I noticed that the current release is still missing hbp and sf data in the team file prior to 2000. Tom ... it's ... are ... additional...
I was wondering where to get the data which maps the playerID in the Master table to the retroID data? Basically, I wanted to cross reference the play by play...
The RetroID *is* in the MASTER table (look all the way at the end). I think it's missing for the 2007 rookies. Tom...
Tangotiger
tom@...
Jan 17, 2008 7:44 pm
3512
Hi Tom, I guess that was my question. How do we map the 2007 rookies to a RetroID so that we can map the play by play data from retrosheet over onto the...
The easiest, thought not fastest, way is to wait for the next release (no date on that). I also think that Ted Turocy recently posted the link of Retro/BDB ids...
Tangotiger
tom@...
Jan 17, 2008 9:04 pm
3514
... Alas, no, I don't have that, because, I've been relying on databank for that concordance in my database. :) Surely, someone in this group must have done...
I would do it myself but am unsure as to the naming convention used for the retroID. For instance, when I look at Julio Gonalez, his retroID is gonzj101. The...
... Good stuff. Retrosheet released their 2007 files a few weeks ago. You should be able to verify against their .ROS file. Tom...
Tangotiger
tom@...
Jan 17, 2008 10:02 pm
3518
Unofficially, Retro IDs are obviously first 4 letters of last name (if <4, right fill with dashes) plus first letter first name but beware commonly used...