MLB.com codes *are* MLBAM codes.  Sometimes you hear "Elias player ID",
but those are different.

Tom

> We've aimed to generate such a repository, which authorized folks can help
> keep up-to-date:
>
> http://www.SportsCodes.org
>
> If memory serves, we've got MLBAM codes in there... and I *think* also the
> mlb.com ones (which may be different).
>
> Regards,
> Alan.
>
> President
> XML Team Solutions
>
> --- In baseball-databank@yahoogroups.com, Wells Oliver <wells@...> wrote:
>>
>> Is there any existing cross reference for any of the IDs in the Master
>> table
>> (lahman, retro, etc) to those used by MLB.com?
>>
>> Thanks.
>>
>> --
>> Wells Oliver
>> wells@...
>>
>
>
>


---------------------------------------------
The Book--Playing The Percentages In Baseball
http://www.InsideTheBook.com

We've aimed to generate such a repository, which authorized folks can help keep
up-to-date:

http://www.SportsCodes.org

If memory serves, we've got MLBAM codes in there... and I *think* also the
mlb.com ones (which may be different).

Regards,
Alan.

President
XML Team Solutions

--- In baseball-databank@yahoogroups.com, Wells Oliver <wells@...> wrote:
>
> Is there any existing cross reference for any of the IDs in the Master table
> (lahman, retro, etc) to those used by MLB.com?
>
> Thanks.
>
> --
> Wells Oliver
> wells@...
>

> Is there any existing cross reference for any of the IDs in the Master
> table
> (lahman, retro, etc) to those used by MLB.com?
>

For the active players through 2008, it's here:
http://www.insidethebook.com/ee/index.php/site/comments/mlb_milb_8833/

I'll be doing it for the 2009 players as well.

If someone wants to spend the time for the older players, I can probably
help.  I have done it for all of them, but there's many differences, and I
didn't go back to cross-check the differences.

Tom

I just happened to notice that the combined outfield fielding line was not
included in the Fielding table for the 2008 season - only separate LF/CF/RF
entries are given.  Was this an oversight, or is this going to be a permanent
change going forward?

Doug

Is there a list that maps either the mlbmaster table to the player_id mlb.com
uses?

Also, does anyone know when the new data is generally available on
baseball-databank.org?

On Tue, Sep 29, 2009 at 10:05 AM, Nick Miceli wrote:
>
>
>
> I want to get better levels of predictive validity for fielding that are
presently possible with available summary measures.

This is definitely moving off-topic for this group.

What I'm going to suggest is that you put together a summary of the
information that you would LIKE to have in order to come up with a
"better model", post it on the Retrosheet list, and then those of us
on that list (which does include many people on this list but which
has little to do with the purpose of this list) who have long
experience with using the event files can help you figure out whether
and to what extent you can get that information out of the PBP data.
Specific fielding (and fielder) information tends to be fairly
complete back to 1989, but much less so prior to that - sometimes all
you know is that a batter hit a single or made an out, but you don't
always know who fielded the ball or made the play, let alone what type
of ball it was.
--
Mike Emeigh
MWE55inNC@...

"Confidence isn't knowledge; in fact, confidence can *prevent*
knowledge and innovation from happening, because an unquestioned
belief means you never measure, never test, never look at
alternatives."

-- Esther Schindler

I want to get better levels of predictive validity for fielding that are
presently possible with available summary measures. -- NSM

--- In baseball-databank@yahoogroups.com, Mike Emeigh <mwe55innc@...> wrote:
>
> On Mon, Sep 28, 2009 at 12:59 PM, Nick Miceli wrote:
>
> It's hard to suggest a method without knowing what you're trying to
> learn. What kinds of questions do you want to try to answer using PBP
> data?
>
> (And yes, this is probably better fodder for the Retrosheet discussion
> group than for this one.)
> --
> Mike Emeigh

On Mon, Sep 28, 2009 at 12:59 PM, Nick Miceli wrote:
>
>
>
> Hello,
>
> I am getting familiar with the Retrosheet play by play data which is ready to
be imported into a relational database.
>
> I was wondering what methodology or quantitative approach you would use to
analyze this kind of data?

It's hard to suggest a method without knowing what you're trying to
learn. What kinds of questions do you want to try to answer using PBP
data?

(And yes, this is probably better fodder for the Retrosheet discussion
group than for this one.)
--
Mike Emeigh
MWE55inNC@...

"Confidence isn't knowledge; in fact, confidence can *prevent*
knowledge and innovation from happening, because an unquestioned
belief means you never measure, never test, never look at
alternatives."

-- Esther Schindler

Hello,

I am getting familiar with the Retrosheet play by play data which is ready to be
imported into a relational database.

I was wondering what methodology or quantitative approach you would use to
analyze this kind of data?

Any discussion or input you would care to offer would be greatly appreciated.

Regards,

Nick Miceli

PS to Moderator: If this is considered an off topic post, I apologize and
understand why you'd not approve it. - NSM

Baseball Reference and Retrosheet have Valverde born July 24, 1979, but ESPN,
CBS Sportsline, and Fan Graphs have him born March 24, 1978. MLB Trade Rumors
has him being 32 in 2010. Those are the only sites I looked at, but I wondered
if anyone knew the reason for why they didn't match.

> I would point out that this is a violation of the terms of use of Sports
> Reference sites.  I find it a bit ironic that I'm approving messages that
> encourage this behavior.  I would suggest at the very least subscribing to
> the Play Index if you are going to take part in this behavior since I
> receive exactly zero income from this behavior and have to pay inflated
> bandwidth charges because of it.

As a matter of good conscience, one should not spider a site on a daily or
weekly basis.  I would think being able to spider a site once a year
should be acceptable for some (few? many?) website owners, as long as the
data is for personal use.

As for cost, a GB of bandwidth probably costs a dime.  If a data-heavy
page has 250K, and if there's say 100K number of pages, then the total
amount of download would be 25 GB, or it costs Sean $2.50 each time
someone downloads his whole site.  If on the other hand you are
downloading just current-season data, then it would be less than a GB, or
say about a nickel or a dime each time. PI costs 29$, or 8 cents a day.
So, that's a more than fair deal.  Not to mention you get PI for "free".

It's a tough situation for Sean. He compiles the end-of-year data for us
to distribute, so that's a benefit.  Not only that, but his joint venture
with Palmer for the Emerald guide is also a big benefit.  I'm sure he'd
like to make it easier for us on a daily basis, but he's got to respect
his own licencing agreement with his data provider.

Not to mention that once or twice, I've asked him (or Justin) to custom
compile something for me, and they did it as a courtesy.  Sean is not "The
Man" that we can feel good about taking advantage of.  I'm sure Wells did
it innocently enough.

As for the legal matter of "Terms of Service", I would presume that would
be tough to enforce.  The TOS have to be accepted by the user, not
imposed.  For example, he can truthfully claim to have never read the TOS,
and so, how can he be prosecuted for not adhering to them?  Of course, the
web would come to a standstill if we had to ask the user to accept the TOS
each time he enters a site.

All to say: be nice to Sean.

Tom

On Fri, Sep 18, 2009 at 12:28 PM, Matthew Gargano <mgargano@...> wrote:
 

Would you be willing to share that py script Wells?

I haven't tried it, but Baseball On a Stick probably might satisfy you.

Tom

> Tom -
>
> I joined and searched retrosql and did not see anything for current year
> stats. Is there some kind of guide or readme on how things work on the
> group?
>
> Thanks,
>
> MG
>
>
> On Fri, Sep 11, 2009 at 5:50 PM, Matthew Gargano <mgargano@...>
> wrote:
>
>>
>>
>> On Thursday, September 3, 2009, Tangotiger <tom@...> wrote:
>> >
>> >> That's awesome Tom, I didn't know that, sorry for making an
>> assumption.
>> >> Is
>> >> there anything that automatically updates data within the current
>> season?
>> >>
>> >
>> > Best bet is to join the RetroSQL group.  There's a couple of
>> (external)
>> > ongoing things that are highlighted there.
>> >
>> > Tom
>> >
>> >
>> >
>> > ------------------------------------
>> >
>> > http://www.baseball-databank.org/Yahoo! Groups Links
>> >
>> >
>> >
>> >
>>
>


---------------------------------------------
The Book--Playing The Percentages In Baseball
http://www.InsideTheBook.com

I posted the service time data on my site last year, mapped to some ID
(MLBAM?  BDB?).  I think it was for the 2008 season.

Tom

> Maury,
>
> Salary information is included in the BDB. There really isn't a
> centralized repository for service time - I have a set of data gotten from
> the guy who runs Cot's Baseball Contracts that I've worked on mapping to
> the Baseball Databank player IDs. (And it's more like two years of data,
> maybe three - can't recall exactly.) Unfortunately I don't have access to
> that right now (the computer it's on is in a state of disassembly.) I'll
> try to get something for you over the weekend.
>
> --CW
>
> --- In baseball-databank@yahoogroups.com, Maury Brown
> <maurybaseballcrazy@...> wrote:
>>
>> Question... I've been looking high and low for a resource that will
>> allow me to query MLB service time + position (and in my dream world,
>> salary). This goes to salary arbitration research I'm doing, so even if
>> the data were only 5 years in duration, it would suit my purposes for
>> "look backs"
>>
>> Does the Databank DB have this aspect within? I don't recall seeing it,
>> but I might have missed.
>>
>> Thanks,
>> Maury
>>
>
>
>


---------------------------------------------
The Book--Playing The Percentages In Baseball
http://www.InsideTheBook.com

Maury,

Salary information is included in the BDB. There really isn't a centralized
repository for service time - I have a set of data gotten from the guy who runs
Cot's Baseball Contracts that I've worked on mapping to the Baseball Databank
player IDs. (And it's more like two years of data, maybe three - can't recall
exactly.) Unfortunately I don't have access to that right now (the computer it's
on is in a state of disassembly.) I'll try to get something for you over the
weekend.

--CW

--- In baseball-databank@yahoogroups.com, Maury Brown <maurybaseballcrazy@...>
wrote:
>
> Question... I've been looking high and low for a resource that will allow me
to query MLB service time + position (and in my dream world, salary). This goes
to salary arbitration research I'm doing, so even if the data were only 5 years
in duration, it would suit my purposes for "look backs"
>
> Does the Databank DB have this aspect within? I don't recall seeing it, but I
might have missed.
>
> Thanks,
> Maury
>

----- Original Message -----

From: Paul Riker

To: baseball-databank@yahoogroups.com

Sent: Tuesday, February 03, 2009 7:26 PM

Subject: [baseball-databank] Minor League Stats

 

Does anyone know where to download minor league stats?
Any

---

Windows Live™ Hotmail®…more than just e-mail. See how it works.