Loading ...
Sorry, an error occurred while loading the content.

What is the g_old column in the batting table

Expand Messages
  • Micke Hovmöller
    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
    Message 1 of 2 , Aug 12, 2009
    View Source
    • 0 Attachment
      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
    • Sean Forman
      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
      Message 2 of 2 , Aug 12, 2009
      View Source
      • 0 Attachment
        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


      Your message has been successfully submitted and would be delivered to recipients shortly.