I realize that this is a relatively minor detail in relation to some of the other things being planned here, but I've noticed that the current MySQL schema has...
Hey guys...I don't know if anyone else noticed this since it's not a huge deal 99% of the time, but for some reason in the 2007 season (most recent in the...
I have compiled additional batting and pitching statistics from Retrosheet Play by Play data and wanted to share them here. I've linked the Retro ID's to the...
Thank you for showing that the best answer is found in the easiest of places. Tom ... From: J. G. Preston <jgpreston@...> Subject: Re: [RetroList] Jiim...
(Cross-posting to Retrolist and BDB) This is to point out a discrepancy, without knowing which is correct. The Lahman DB and B-R.com has Jim Busby with one...
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...
I am looking for career batting and pitching splits for every Major Leaguer. I had been going to every retrosheet player page and copying them manually one at...
I did some research and signed up for this Yahoo! group for the Database and couldn't find the answer to this. There are some players that are missing InnOuts...
http://rapidshare.com/files/28249895/minordetails.zip.html <http://rapidshare.com/files/28249895/minordetails.zip.html> I'm not sure if this data is already...
Digging deeper, I looked at 1933 and 1934 thinking that the symmetric errors might just be data entry. See attachment. Different clubs are involved. I looked...
Using the query: mysql> select yearID sum(HR) from Teams where lgID = "AL" group by yearID; I am puzzeling over some small incosistancies between the number of...
The latest & greatest KJOK Ballparks database is now available at seamheads.com website under DATABASES (link is ballpark stats splits). THANKS, KJOK...
I think this was bounced the first time ... I would steer clear of copying an existing id system, be it retrosheet, STATS or Elias. Using their system would...
From the standpoint of an Oracle programmer/dba there is a difference between a 0 and a NULL. A zero is a value. It's value is ZERO. A null by definition is...
Hi, Working mostly with MySQL type baseball-databank files, I haven't been able to figure why sometimes SF's are zero and sometimes NULL in the pre-1954...
I've created a separate Yahoo group, so as to not interfere with Retrolist or Baseball-Databank. This purpose of this new group is to yada yada yada a SQL...
I didn't quite make it by opening day, but there is a new set of files I uploaded this morning. The fielding table has a number of important new additions. ...
This article reminded me quite a bit of how 'open' (vs. closed) is viewed in sabermetric circles: http://www.sciam.com/article.cfm?id=science-2-point-0...
I am a PHP developer and I think it would be really cool to use Propel (http://propel.phpdb.org/trac/) with the statistics provided by BDB either for personal...
I haven't received a response, and it appears that this message is not in the archives, so I am resending. *** In order to get the BDB Board rolling, we...
Has anyone developed webservices that web masters could use vs. downloading and managing their own database? If not I would like to volunteer to do this. It...
I found something interesting while rooting around in Google recently. The MLB has, in a publicly accessible portion of their site, all their reports and notes...
Is there still a plan to change to numeric table IDs such as creating an ID for team+lge+year for the batting, pitching, fielding tables instead of separate...
Last year I picked up my copies on eBay, and I'm sure I'll be able to do the same this year. However, it seems like it should be possible to purchase these...
I see that defensive GS information is missing for all players in 2007. Can we expect to see this corrected in a new version? (I'm working with the mysql...
Sports Reference (operators of Baseball-Reference.com) in Philadelphia is looking to hire paid interns for computer programming positions this summer. Details...
I have uploaded (am uploading) the 2005 files. There is a mysql file and a csv file as well. I would welcome an access file if and when someone is able to...