Yes, in the Files section, I have a step-by-step list of things that need to be done to the BDB database to get it up to speed. See here: ...
3505
Tony Robran
trobran
Jan 2, 2008 9:52 pm
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...
3506
Sean Lahman
anson2995
Jan 3, 2008 3:53 pm
... 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,...
3507
Andrew E Dolphin
coachdlfn
Jan 7, 2008 8:30 pm
... 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...
3508
Tangotiger
tom@...
Jan 7, 2008 8:42 pm
... 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...
3509
Tom Timmerman
timmermant
Jan 8, 2008 9:12 pm
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...
3510
park96
Jan 17, 2008 7:40 pm
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...
3511
Tangotiger
tom@...
Jan 17, 2008 7:44 pm
The RetroID *is* in the MASTER table (look all the way at the end). I think it's missing for the 2007 rookies. Tom...
3512
Sang Park
park96
Jan 17, 2008 8:16 pm
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...
3513
Tangotiger
tom@...
Jan 17, 2008 9:04 pm
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...
3514
Theodore Turocy
arb1ter
Jan 17, 2008 9:14 pm
... 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...
3515
Rod Nelson
rockymtnsabr
Jan 17, 2008 9:45 pm
RETROID bbrefID FIRSTNAME LASTNAME abret001 abreuto01 Tony Abreu acosm001 acostma01 Manny Acosta albaj001 albaljo01 Jonathan Albaladejo andej004 anderjo03 Josh...
3516
Sang Park
park96
Jan 17, 2008 9:53 pm
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...
3517
Tangotiger
tom@...
Jan 17, 2008 10:02 pm
... Good stuff. Retrosheet released their 2007 files a few weeks ago. You should be able to verify against their .ROS file. Tom...
3518
Clem Comly
ccomly2003
Jan 19, 2008 3:06 pm
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...
3519
Sean Forman
sforman71
Feb 22, 2008 9:56 pm
Sports Reference (operators of Baseball-Reference.com) in Philadelphia is looking to hire paid interns for computer programming positions this summer. Details...
3520
ChuckLittle323@...
chucklittle323
Feb 27, 2008 6:01 pm
Check out this new website. I think you guys will enjoy it... www.BaseballStatGenie.com Chuck...
3521
Tangotiger
tom@...
Feb 27, 2008 8:04 pm
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...
3522
Tangotiger
tom@...
Feb 27, 2008 8:20 pm
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...
3523
Chuck Little
chucklittle323
Feb 28, 2008 2:46 pm
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,...
3524
Tangotiger
tom@...
Feb 28, 2008 2:56 pm
... 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...
3525
John Walsh
walshj58
Feb 29, 2008 2:26 pm
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...
3526
viscount626
Feb 29, 2008 2:34 pm
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...
3527
dsreyn
Mar 6, 2008 1:19 pm
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...
3528
Bill
mrnaturl1
Mar 6, 2008 6:59 pm
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...
3529
Tom Stillman
giantsfan_94121
Mar 7, 2008 1:39 am
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 ...
3530
Bryan Walko
bryanwalko
Mar 7, 2008 3:22 am
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...
3531
dsreyn
Mar 7, 2008 1:15 pm
I haven't seen the Red and Green books in bookstores for several years. I've also checked Amazon, but no luck there on the recent editions. Doug...
3532
Anthony Giacalone
anthonygiaca...
Mar 7, 2008 5:46 pm
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...
3533
parked43
Mar 10, 2008 5:20 pm
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...
