Tom:

Don't know if I have a "solution" but:

1. Batting.G = Pitching.G 28,885 cases.

Should be no issue with these.

2. Batting.G < Pitching.G 2,521 cases (All but 6 of
these are 1997-2004. 2005 has none of these cases)

I believe these are mostly all American League
pitchers. If the pitcher batted (such as in an
interleague game, or where team lost the DH) or he
Pinch Ran/Pinch Hit/played another position, then he
got a batting game from 1997-2004. On games where he
didn't bat, he did not get a batting game, but a
pitching game only. Ideally either 1973-1996 & 2005
should be consistent with that, or else 1997-2004
should all be "re-done" to be consistent with
1973-1996 & 2005.

The 6 other cases are possibly data errors, and would
need to be looked at individually.

Batting.G > Pitching.G 5492 cases.

These should mostly be where either, as you described,
position players pitched, OR where pitchers pinch hit
or pinch ran or played another position within a
season.

THANKS,
Kevin

--- Tom Timmerman <timmermant@...> wrote:

> Hello all,
> Looking through the archives, I see that John asked
> the question I
> was about to ask, but I don't see where it was ever
> answered.
> Basically the question is: How do you determine
> games played for
> those appearing in both the batting and pitching
> tables?
>
> I merged the batting and pitching tables (from the
> Lahman Access
> version) and found this:
> Batting.G = Pitching.G 28,885 cases
> Batting.G < Pitching.G 2,521 cases
> (All but 6 of these are 1997-2004. 2005 has none
> of these cases)
> Batting.G > Pitching.G 5492 cases
> (These are spread evenly across all years and
> appear to reflect
> normal examples of position players doing some
> pitching. For these I
> assume that Batting.G is the correct number of games
> played.)
>
> Anybody got solution?
>
> Thanks,
> Tom
>
>
> --- In baseball-databank@yahoogroups.com,
> "john_rickert"
> <rickert@...> wrote:
> >
> >
> > Is there any plan to put players games played in
> the baseball
> databank?
> >
> > Before 1998, everyone's games played was included
> in the Batting
> file,
> > but since then, the pitchers' totals are no longer
> listed in
> either section.
> > e.g. last year, Johann Santana appeared in 34
> games.
> > In the batting section Santana is listed as
> batting in 2 games
> (presumably
> > interleague games)
> > in the pitching section, he is listed as pitching
> in 34 games.
> >
> > Randy Johnson appeared in 35 games.
> > Johnson is listed as batting in 33 games,
> pitching in 35.
> >
> > Brooks Kieschnick appeared in 77 games.
> > Kieschnick is listed as batting in 75 games,
> pitching in 32.
> > How do we determine the actual number of games
> played for
> Kieschnick.
> >
> > And these are all obvious players. Most years,
> there is some
> pitcher who makes some
> > pinch running/pinch fielding appearance. How do we
> find these for
> the years since inter-
> > league play started?
> >
> > A less obvious player is Jason Simontacchi, who
> played in 15 games.
> > Simontacchi is listed as batting in 14 games,
> pitching in 13.
> >
> > john rickert
> >
>
>
>
>
>


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com