Keith, I apologize but the August 2 release was not a public release in the sense that it was a dramatic departure from the previous structure of the BDB. I ...
Hi Sean, I'm not sure that I understand what happened here. In August 2005, the format of the database was radically changed to a more efficient database...
OK, we're good on Team ID, but.... For Franchise ID, WAS 2005 has a Franchise ID of WSN. WSN 1893-1899 has a Franchise ID of WAS. I'm thinking it makes sense...
It's my understanding that the "official" database is the one released after the season, usually in December of each year. The database just released had the...
Uhhh... I haven't looked at the database yet, but the Franchise ID of Washington should MON, no? If the franchise ID of 93-99 is WAS, that shouldn't change....
I was expecting MON also for the Expos/Nationals franchise, but it is WSN, not MON. MON or WAS would be OK with me, but WAS is of course taken as of now by the...
There is really no reason for the Expos to have a franchise ID of WAS, or anything other than MON. The Nationals should also be MON. Mike Jefferson can ...
Thank you for the reply Sean. It's certainly not the end of the world for me to start over due to the format change. It generally takes me a little longer...
My own interpretation is that the public releases appear at www.baseball1.com and anything else found at baseball-databank.org is "experimental". FWIW, I too...
... Sean Lahman controls the version he posts, so I can only speak for the databank version available at the site. The quick and easy answer is that it *will*...
From: "Bruce Cowgill" <brucec23@...> ... I expect to have a release available by this weekend, and it will remain in the same database structure as ...
Harold Baines split the 1997 season between the White Sox and Orioles. The BDB fielding table lists Baines as playing 1 game in RF for the Orioles, and no...
The awards table lists Pete Alexander with pitching triple crowns in 1915, 1916, and 1920. However, I believe that he should be credited with a fourth triple...
I have put together a file giving total games played in the outfield for the years where outfield fielding statistics are separated by LF / CF / RF. The file...
A file of Sporting News All-Star team selections is available at: http://alum.wpi.edu/~dreynolds/baseball/TSN-AllStar.csv The format is the same as in the...
Good idea Doug. THANKS, Kevin dsreyn <dreynolds@...> wrote: I have put together a file giving total games played in the outfield for the years where...
Sorry to bother everyone with this, but I've run completely out of ideas. I have been working with the 12/30/05 BDB in MS Access getting several queries setup...
Doug, could you put this in the files area. That would be the best way to make sure we eventually get it added. sean ... -- Sincerely, Sean Forman Baseball...
I've been working on my Access database of the BDB data and came across what I believe may be a minor data error. For the 2002 Babe Ruth Award Winner, it lists...
Probably not standardized SQL, but it works well enough. SELECT SeriesPost.yearID, SeriesPost.round, TeamsFranchises_1.franchName, TeamsFranchises.franchName ...
Thank you for the reply. Late this afternoon I was able to contact a friend who has more skills with working in Access than I do and we were able to work it...
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the baseball-databank group. File :...
baseball-databank@yah...
Jan 10, 2006 2:56 pm
2906
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the baseball-databank group. File :...
baseball-databank@yah...
Jan 10, 2006 2:58 pm
2907
The teams table gives the 2005 Yankees team stolen base total as 84. Stolen bases for the individual players in the batting table add to 85. MLB.com gives the...
... 85. ... Four is Crosby's correct total. On October 2, Crosby advanced to second base in the seventh inning with the Yankees trailing 7-1, and was...
In the "Managers" table, the "Rank" for Dave Miley is listed as "6" for the 2005 season. He was the 1st manager of the year for the Reds and then Jerry Narron...
Hi everyone, I'm trying to merge the fielding and fieldingof tables, and have been coming up with slightly weird results. I assumed that each row in the ...
I noticed that the database does not have GIDP for the new version. Is that data no longer available? Just wondering since it is utilized in the Runs Created...