Search the web
Sign In
New User? Sign Up
baseball-databank · Baseball Databank
  • Members Only
  • Post
  • Files
  • Photos
  • Database
  • Polls
  • Members
  • Calendar
  • Promote
  • Groups Labs (Beta)
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Want to share photos of your group with the world? Add a group photo to Flickr.

Best of Y! Groups

   Check them out and nominate your group.
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.

Messages

   Messages Help
Message #
Search:
Advanced
retroID in the mater table   Message List  
Reply | Forward Message #3513 of 3880 |
Re: [baseball-databank] retroID in the mater table

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 for
the 2007 rookies. Check the archives from Nov or Dec.

Tom


> 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.
>>
>> Tom
>>
>>
>>
>
>


---------------------------------------------
The Book--Playing The Percentages In Baseball
http://www.InsideTheBook.com
Thu Jan 17, 2008 8:22 pm

Show Message Option
tom@...
Send Email Send Email

Forward 		Message #3513 of 3880 |
Expand Messages Author Sort by Date

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... 		park96
Offline Send Email 		Jan 17, 2008
7:40 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...
Tangotiger
tom@...
Send Email 		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...
Sang Park
park96
Offline Send Email 		Jan 17, 2008
8:16 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...
Tangotiger
tom@...
Send Email 		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...
Theodore Turocy
arb1ter
Offline Send Email 		Jan 17, 2008
9:14 pm

RETROID bbrefID FIRSTNAME LASTNAME abret001 abreuto01 Tony Abreu acosm001 acostma01 Manny Acosta albaj001 albaljo01 Jonathan Albaladejo andej004 anderjo03 Josh...
Rod Nelson
rockymtnsabr
Offline Send Email 		Jan 17, 2008
9:45 pm

... Good stuff. Retrosheet released their 2007 files a few weeks ago. You should be able to verify against their .ROS file. Tom...
Tangotiger
tom@...
Send Email 		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...
seaver78
Offline Send Email 		Mar 12, 2008
4:19 pm

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@...
Send Email 		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...
tangotiger
Offline Send Email 		Aug 31, 2008
2:35 am

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...
Sang Park
park96
Offline Send Email 		Jan 17, 2008
9:53 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...
Clem Comly
ccomly2003
Offline Send Email 		Jan 19, 2008
3:06 pm
< Prev Topic  |  Next Topic >
Message #
Search:
Advanced
Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help