Search the web
Sign In
New User? Sign Up
baseball-databank · Baseball Databank
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Show off your group to the world. Share a photo of your group with us.

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
Advanced
What is the g_old column in the batting table   Message List  
Reply | Forward Message #3782 of 3880 |
Re: [baseball-databank] What is the g_old column in the batting table

Micke,

G_old was the old value before I created the appearances table.  I think the issue for the players below is that they were injured before the game started or removed before officially getting into the game.  G_batting is based on the retrosheet files.

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


On Wed, Aug 12, 2009 at 4:13 AM, Micke Hovmöller <micke.hovmoller@...> wrote:
 

What is the g_old column in the batting table?

I googled a bit but couldn't find the answer, and the documentation only say "G_old          old Games Played field". Specifically, why does it differ from g_batting for players who never pitched?

Example:
select *
  from batting b
  where g_batting <> g_old
    and not exists
      (select null
        from pitching p
        where b.playerid = p.playerid
          and b.yearid = p.yearid
          and b.teamid = p.teamid
          and b.stint = p.stint)

Gives these player years:
greenkh01    2006    1    SDN    NL
bellira01    1996    1    ATL    NL
benjami01    1994    1    SFN    NL
cartega01    1979    1    MON    NL
clarkje01    1990    1    SDN    NL
mccraqu01    1997    1    COL    NL
mearepa01    2001    1    PIT    NL
redmomi01    2002    1    FLO    NL
sakatle01    1982    1    BAL    AL
spierbi01    1993    1    ML4    AL
thomaga01    1978    2    NYA    AL

Looking at the game logs, I can't figure out what happened here that caused g_batting and g_old to differ.

/Micke




Wed Aug 12, 2009 1:42 pm

sforman71
Offline Offline
Send Email Send Email

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

What is the g_old column in the batting table? I googled a bit but couldn't find the answer, and the documentation only say "G_old old Games Played...
Micke Hovmöller
mhovm1
Offline Send Email
Aug 12, 2009
8:14 am

Micke, G_old was the old value before I created the appearances table. I think the issue for the players below is that they were injured before the game ...
Sean Forman
sforman71
Offline Send Email
Aug 12, 2009
1:44 pm
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help