First email as part of the group.  Apologies if I am violating any protocols.

I've been trying to use the Baseball Databank (BDB) database to compute Win
Shares.  I've been following the book's step-by-step example with the 1998 St.
Louis Cardinals and I keep running into small discrepancies between the book and
the BDB.  Most of the time the book matches Baseball-Reference (B-R) and/or
Retrosheet.

Issues that I have encountered so far (all involved the 1998 NL):
1. Roberto Petagine (CIN) has 2 GIDP in BDB.  B-R has 1.  Retrosheet has him
hitting into two double plays, but one was a line drive type.
2. There are three pitcher HBP in the NL missing.  According to B-R John Thomson
(COL) has 2 and Gabe Gonzalez (FLO) has 1.  BDB has 0 for both.
3. The league fielding putouts (69710) to not match the total of the league
IPOuts (69719).
4. The league IPOuts (69719) do not match B-R (69720).  I haven't tracked down
where that stray out is yet.
5. For the entire NL, BDB has 837 WP, B-R has 835.  Again, I didn't track down
particular players yet.
6. The pitching runs allowed (not earned runs, just plain old runs) is off
significantly.  BDB has 11918, B-R 11943.  I did track down a couple of players
with Florida that have discrepancies.  Antonio Alfoseca has has 32 in BDB
(matching his ER) but 36 in B-R.  Felix Heredia has 25 in BDB (also matching his
ER) but 30 in B-R.  There are more discrepancies than those two though.

There are also issues with fielding assists, but that does not concern me as
much as the other stuff.

Is this the right place to report these issues?  I am willing to help track down
discrepancies, upon request.

Paul Golba

> Is this the right place to report these issues?  I am willing to help
> track down discrepancies, upon request.
>
> Paul Golba
>

This is absolutely the right place.  And while you didn't break any
protocols (if we even have any), from where I sit you can break whatever
protocols you need to, to report data issues like this.

Truth > whatever

Tom

If you are ONLY going to use players with a BDB_ID, why don't you do:

select player_id from batting where year_id between 2007 and 2009;

Tom


> So a quick question here- I'm working on my little projection system and
> I'm
> doing a lot of hacky crap to put together the "list of MLB players" to
> project. Right now I'm using the entire 40 man rosters of every team as
> provided by mlb.com. I have to use Tango's list of IDs - which is awesome,
> but still under development - to match each MLB player up with their BDB
> ID,
> and excluding any guy w/o a BDB ID brings the rosters down by 10ish.
>
> I need the BDB ID as I'm using the BDB's stats for projections.
>
> Is there some cleaner way of doing this? Some better "list of players"
> from
> which to work?
>
> Any tips appreciated. Thanks!
>
> --
> Wells Oliver
> wells@...
>


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

select distinct player_id ...

Tom

If I have a file with retroID and player name, are there files out there that I
can use to link those names with a team?  I would prefer to use Excel if
possible.

Do I understand you correctly that you want to see:

playerID,teamID

So that you will see the team for every player the team the player played on?

In that case:
select a.playerID as bdbid, retroid,teamID,min(yearid) as
minYear,max(yearid) as maxyear

from appearances a inner join master m
on a.playerid = m.playerid

group by a.playerID,retroid,teamID
;

Tom

> you need to contact _Sean-Foreman@..._
> (mailto:Sean-Foreman@...)
>
>
> In a message dated 3/19/2010 10:42:20 P.M. Eastern Daylight Time,
> kgoldpc@... writes:
>
>
>
>
> If I have a file with retroID and player name, are there files out there
> that I can use to link those names with a team? I would prefer to use
> Excel
> if  possible.
>
>
>
>


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

Thanks Tango. This worked perfectly.

--- In baseball-databank@yahoogroups.com, "Tangotiger" <tom@...> wrote:
>
> Do I understand you correctly that you want to see:
>
> playerID,teamID
>
> So that you will see the team for every player the team the player played on?
>
> In that case:
> select a.playerID as bdbid, retroid,teamID,min(yearid) as
> minYear,max(yearid) as maxyear
>
> from appearances a inner join master m
> on a.playerid = m.playerid
>
> group by a.playerID,retroid,teamID
> ;
>
> Tom
>
> > you need to contact _Sean-Foreman@..._
> > (mailto:Sean-Foreman@...)
> >
> >
> > In a message dated 3/19/2010 10:42:20 P.M. Eastern Daylight Time,
> > kgoldpc@... writes:
> >
> >
> >
> >
> > If I have a file with retroID and player name, are there files out there
> > that I can use to link those names with a team? I would prefer to use
> > Excel
> > if  possible.
> >
> >
> >
> >
>
>
> ---------------------------------------------
> The Book--Playing The Percentages In Baseball
> http://www.InsideTheBook.com
>

Your method of multiplying the AL HR rate by 89% to get it to the same
mean as the NL rate implies that the average AL pitcher = average NL
pitcher.

This is not necessarily true, and almost certainly not true.

Tom

> Trying to figure out league adjustments for 2009- doing HR per 9 right
> now.
> Querying like so:
>
> SELECT
> SUM(HR),
> SUM(HR) / SUM(IPouts / 3) * 9,
> lgID
> FROM Pitching
> WHERE yearID = 2009
> GROUP BY lgID;
>
> Yields 1.1127 for the AL and 0.9928 for the NL.
>
> Therefore the difference in rate would be a 0.1 advantage to the AL.
>
> Seems kinda odd. Am I going about this the right way? Thanks for any tips.
>
> --
> Wells Oliver
> wells@...
>


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

I don't know the answer to this, but looking at the data I would guess this is
what they are doing:

These two coordinates show where the ball crossed the plate:

px="0.397"
pz="2.207"

px is the ball's "inside/outside" position. 0.00 is the middle of the plate.
negative is (probably) inside on a
right-handed hitter. positive is outside

pz is the ball's height off the ground. 0.00 is the ground itself.

Each pitch also lists the top and bottom of the strike zone, which varies by
batter:

sz_top="3.72"
sz_bot="1.72"

Wells Oliver wrote:
>
>
> Which of the lovely attributes in the <pitch> elements contains where
> the pitch was in the strike zone? (the numbers you use to make a heat map)
>
>
http://gd2.mlb.com/components/game/mlb/year_2009/month_07/day_05/gid_2009_07_05_\
balmlb_anamlb_1/inning/inning_4.xml
>
<http://gd2.mlb.com/components/game/mlb/year_2009/month_07/day_05/gid_2009_07_05\
_balmlb_anamlb_1/inning/inning_4.xml>
>
> --
> Wells Oliver
> wells@... <mailto:wells@...>

--
Clay Dreslough
President, Sports Mogul Inc.
cjd@...
www.sportsmogul.com
Baseball Mogul 2011, now available:
http://www.sportsmogul.com/games/baseball2k11.html

Also, look at Retrosheet as the "tie-breaker".

Tom

> Any idea what would account for the difference in career split totals on
> yahoo.com and baseball-reference.com?
>

 

Wells,

You need to be a lot more specific.  What are the differences you are seeing?

sean
---
Sean Forman
Sports Reference LLC, President
http://www.sports-reference.com/

On Mon, Mar 29, 2010 at 12:53 PM, Wells Oliver <wells@submute.net> wrote:

 

Any idea what would account for the difference in career split totals on yahoo.com and baseball-reference.com?

Ichiro on Yahoo: http://sports.yahoo.com/mlb/players/6615/splits;_ylt=AlNqRTkpU1Aas_ifYQm778GFCLcF?year=career&type=Batting

Ichiro on b-ref: http://www.baseball-reference.com/players/split.cgi?n1=suzukic01&year=Career&t=b

Just the nature of using different data sources? Post-season play?

--
Wells Oliver
wells@submute.net

For 2008, I was able to get a player's primary position sheet.  Does anyone know
if someone has done one for the 2009 season?  thanks.

I posted an Access DB that calculates the prim pos for a player for any
season (or career.. can't remember).  Look in the files section somewhere
for a file called PrimPos.mdb or such.

Tom

> For 2008, I was able to get a player's primary position sheet.  Does
> anyone know if someone has done one for the 2009 season?  thanks.
>
>


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

My modified version of the Lahman/BDB databse has primary positions for all
players listed in the batting table:

http://www.mediafire.com/?omc4yizmugz

The method I use to determine primary position is the same as Tango's, except I
used defensive innings (actual and estimated prior to 1952) instead of games.

There are 205 records in the Data-Bank Master table that have a PlayerID but no
retroID.  They are also missing the holtzID, the lahman40ID, and the lahman45ID,
but I do not know if any of those are relevant (I suspect the lahman IDs are for
obsolete versions of that DB, no idea about holtzID).  The bbrefID is populated
for all of them.

Of the 205 records, 204 are for players that debuted in 2009.  In fact ALL of
the players that debuted in 2009 are missing that information.  The other
playerID is hemonro99 for a Roland Hemond, who does not appear in the Batting,
Pitching, or Fielding tables and and appears to be a baseball executive with no
playing experience.

Is this going to be fixed?  Or did I just volunteer?

Paul Golba