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...
Sports Reference (operators of Baseball-Reference.com) in Philadelphia is looking to hire paid interns for computer programming positions this summer. Details...
Your site doesn't work well in Firefox. This is wrong: " + .30(SB) - .60(CS) ". That was published in The Hidden Game, which has since been corrected. (.22...
Tangotiger
tom@...
Feb 27, 2008 8:04 pm
3522
I installed this a month ago, and several people have contributed pages: http://tangotiger.net/wiki/index.php?title=Main_Page Feel free to make your own...
Tangotiger
tom@...
Feb 27, 2008 8:20 pm
3523
Thanks for the feedback. The site is very new and I knew that this mail group would provide some good ideas. I will add career totals on the player profile,...
... You need to create a league/year table that gives you the "non-out" totals. From there, you get the out value for each league/year. For example, you...
Tangotiger
tom@...
Feb 28, 2008 2:56 pm
3525
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...
Has there been any update to the National Pastime Almanac to include 2007 data? Been offlist for a while, so, if it happened, I didn't get it. If it has been...
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 get my stock of books & the team media guides straight from the stadium press box. I recall seeing the Red/Green books in B.Daltons at one time. I don't know...
Not everyone has access to a stadium press box. Very few people do. But I agree with Bill that a bookstore may be able to help. I have not seen the Red and ...
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...
This service has been free for the last couple years, so long as you registered with mlb.com Bryan Walko wrote: I found something interesting while rooting...
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...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
