Re: [baseball-databank] retroID in the mater table
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 Master table in the BDB schema?
Sang
On Jan 17, 2008, at 2:43 PM, Tangotiger wrote:
The RetroID *is* in the MASTER table (look all the way at the end). I think it's missing for the 2007 rookies.
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
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
... 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...
... 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
... I have Coutlangus's RETROID as coutj001 and Vazquez's bbrefid as vasquvi01. I have also found the following errors in the RETROID column of the master...
Someone, I think Rod, asked me a long while back for my list of Retro/BDB mappings for the new players. This is my unofficial list: playerID retroid abreuto01...
Tangotiger
tom@...
Mar 13, 2008 3:08 pm
For those interested, do this: 1. Take the data below, and create a table called MasterRookies, with two fields (playerID, retroID), and copy the data into...
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...
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...
Having problems with message search?
Offline 
Send Email