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 ...
2883
Joseph Adler
joseph_adler
Jan 2, 2006 6:48 pm
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...
2884
KJOK
kjokbaseball
Jan 2, 2006 11:46 pm
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...
2885
KJOK
kjokbaseball
Jan 3, 2006 12:01 am
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...
2886
tangotiger
Jan 3, 2006 5:02 am
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....
2887
KJOK
kjokbaseball
Jan 3, 2006 5:35 am
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...
2888
tangotiger
Jan 3, 2006 12:58 pm
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 ...
2889
Keith Hemmelman
khemmelman
Jan 3, 2006 5:08 pm
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...
2890
John Walsh
walshj58
Jan 3, 2006 6:34 pm
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...
2891
Bruce Cowgill
bcowgill23
Jan 4, 2006 5:25 pm
Speaking of the "public" version: Is the fomat of the Lahman version going to change? If so, in what ways? Is there an expected launch date for it?...
2892
Derek Adair
D_Adair
Jan 4, 2006 5:59 pm
... 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*...
2893
Sean Lahman
anson2995
Jan 5, 2006 4:49 pm
From: "Bruce Cowgill" <brucec23@...> ... I expect to have a release available by this weekend, and it will remain in the same database structure as ...
2894
dsreyn
Jan 6, 2006 2:23 pm
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...
2895
dsreyn
Jan 8, 2006 2:17 am
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...
2896
dsreyn
Jan 8, 2006 4:20 am
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...
2897
dsreyn
Jan 8, 2006 4:21 am
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...
2898
KJOK
kjokbaseball
Jan 8, 2006 7:25 am
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...
2899
Keith Hemmelman
khemmelman
Jan 9, 2006 5:43 pm
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...
2900
Sean Forman
sforman71
Jan 9, 2006 5:58 pm
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...
2901
Keith Hemmelman
khemmelman
Jan 9, 2006 6:35 pm
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...
2902
Sean Forman
sforman71
Jan 9, 2006 7:34 pm
FOI ... From: Greg Spira <gregspira@...> Date: Jan 6, 2006 2:28 PM Subject: 2002 To: Sean Forman <sean-forman@...> The head of...
2903
Charles Creasy
chazcreasy1
Jan 9, 2006 7:57 pm
Probably not standardized SQL, but it works well enough. SELECT SeriesPost.yearID, SeriesPost.round, TeamsFranchises_1.franchName, TeamsFranchises.franchName ...
2904
Keith Hemmelman
khemmelman
Jan 10, 2006 1:24 am
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...
2905
baseball-databank@yah...
Jan 10, 2006 2:56 pm
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 :...
2906
baseball-databank@yah...
Jan 10, 2006 2:58 pm
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 :...
2907
dsreyn
Jan 10, 2006 3:02 pm
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...
2908
Mike Emeigh
mwemeigh
Jan 10, 2006 4:02 pm
... 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...
2909
Keith Hemmelman
khemmelman
Jan 11, 2006 3:58 am
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...
2910
Joseph Adler
joseph_adler
Jan 13, 2006 7:32 am
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 ...
2911
jptacek
Jan 14, 2006 4:58 am
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...