Sorry, dropped the S in the paste.
http://groups.yahoo.com/group/BBTransactions

>  -----Original Message-----
> From:  Crain, Mike (LNG-DAY)
> Sent: Friday, April 04, 2003 4:54 PM
> To: 'BBALL - Databank'; 'SABR - 19Century'; 'SABR - Spring Training';
> 'SABR- Deadball'; 'SABR - Mailing List'; 'SABR - Baseball Deaths'
> Subject: New Baseball group - BaseballCardDB
>
> A new Yahoo! Group has been created.
>
> Group name: BBTransactions
> Group home page; http://groups.yahoo.com/group/BBTransaction
>
> This group will be used as a focal point to post/update research on
> transactions in the history of professional baseball. Trades, drafts, free
> agency signings, etc. The group will also accept more non-traditional
> items (i.e. call ups, disabled list entries, etc) and evaluate their
> addition to the main database.
>
>
>
> Hope list admins will forgive me if this is a little off-topic. I think
> this might fit nicely into alot of these areas.
>
> Mike Crain
> Helpdesk Support Engineer 2  - Dayton
> Webstar Support
> CLE Desktop Support
> LexisNexis*
> Phone - (937)865-6800 x55155
> Email - mike.crain@...
> sendpage - mikec
>

Example: http://www.s-t.com/daily/11-01/11-15-01/b06sp085.htm

I see mentioned in a couple of places local chapters giving out
awards specific to the team (Marlins list it in their 2001 Media
Guide). Does te BBWAA have a "website" (Could find it with a Google
search) or any place to find local awards details?

6 Apr 2003, "Local BBWAA awards", Mike Crain wrote:

> Example: http://www.s-t.com/daily/11-01/11-15-01/b06sp085.htm
>
> I see mentioned in a couple of places local chapters giving out
> awards specific to the team (Marlins list it in their 2001 Media
> Guide). Does te BBWAA have a "website" (Could find it with a Google
> search) or any place to find local awards details?

12-18 months ago, collective wisdom on the Deadball Era Cmtee was that
there is no website and the organization is/has been rather secretive.

One list of members was published in Turkin & Thompson, Official
Encyclopedia of Baseball, 1st. ed., 1951, p563-67.  I haven't examined
later editions of that reference.  In 1951, each regular member was
affiliated with a publication and was a member of one of the MLB-city
chapters.  There were seven Associate Members in Newark and Toledo, three
Foreign Members in Cuba and Colombia, and ~100 Honorary Members.  It
appears to me that almost all of the honoraries were retired regulars.
For each regular and each (I guess) retired regular, the list includes
"year in which member joined the association".

All regular listings imply
     {Chapter1951,Publication1951,NameFML,YearJoined}
and most honorary listings provide
     {NameFML,YearJoined,Chapter}.

So the 1951 list alone provides quite a bit of the BBWAA membership
history, 1908-1951, and a few more generously spaced snapshots by the same
camera would cover almost all longterm 20c members and a great number of
mediums and shorties.

Transcription to an electronic database is a useful project.

P/\/ \/\/t
Paul Wendt, Watertown MA, USA <pgw@...>

I'm cross-posting this to the BDB and SABR-L so please excuse any
duplication.

I'm looking for a source that details the World Series coaches. One
hypothetically could assume that it is the team's coaches, but I'd like
verification in case one was fired mid-season, etc.

Mike Crain
Email - mike.crain@lexisnexisDOTcom

http://groups.yahoo.com/group/baseball-databank/files/Positions/

I updated the primpos.mdb file to allow the creation of the primary
position by year or by career.  I refer to LahmanID, but you can edit
that to playerid or anything you want.

I also include an Access 97 version, which is untested.  (Access 2000
lets you reverse-save to prior versions.)

I think Michael M. had a better way to do this in Access, by using
the Iif command (which would not be portable to other databases, I
don't think), and doing it in 1 step instead of the multi-step
process I follow.

Thanks, Tom

Unfortunately, I don't have Access97, and so I can't
do anything with it.

Here however is the SQL, and you can recreate it
yourself:


Create query called: oquendoSum
SELECT Fielding.LahmanID, Fielding.Year, Fielding.Pos,
Positions.Priority, Sum(Fielding.G) AS G
FROM Fielding INNER JOIN Positions ON Fielding.Pos =
Positions.Pos
GROUP BY Fielding.LahmanID, Fielding.Year,
Fielding.Pos, Positions.Priority;


Create query called: oquendoMax
SELECT oquendoSum.LahmanID, oquendoSum.Year,
Max(oquendoSum.G) AS G
FROM oquendoSum
GROUP BY oquendoSum.LahmanID, oquendoSum.Year;


Create query called: oquendoPrimary
SELECT oquendoMax.LahmanID, oquendoMax.Year,
oquendoMax.G, Min(oquendoSum.Priority) AS
MinOfPriority
FROM oquendoMax INNER JOIN oquendoSum ON (oquendoMax.G
= oquendoSum.G) AND (oquendoMax.Year =
oquendoSum.Year) AND (oquendoMax.LahmanID =
oquendoSum.LahmanID)
GROUP BY oquendoMax.LahmanID, oquendoMax.Year,
oquendoMax.G;


Create a query called: createPrimaryPositionsByYear
SELECT oquendoPrimary.LahmanID, oquendoPrimary.Year,
oquendoPrimary.G, Positions.Pos INTO
PrimaryPositionsYear
FROM oquendoPrimary INNER JOIN Positions ON
oquendoPrimary.MinOfPriority = Positions.Priority;


Create a table called: Positions, with the following
fields and data
Pos Priority
P 0
C 1
SS 2
CF 3
2B 4
3B 5
RF 6
LF 7
OF 8
1B 9
DH 10

After all that is done, simply execute that last
query.  It will create a redundant table for you,
listing the primary position for each fielder/year.

Thanks, Tom





__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
http://tax.yahoo.com

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the baseball-databank
group.

   File        : /Positions/primpos.zip
   Uploaded by : tangotiger <tmasc@...>
   Description : (Updated) POSITIONS - determine primary fielding position

You can access this file at the URL

http://groups.yahoo.com/group/baseball-databank/files/Positions/primpos.zip

To learn more about file sharing for your group, please visit

http://help.yahoo.com/help/us/groups/files

Regards,

tangotiger <tmasc@...>

Hi,

I discovered an error in the Teams file.  The 1981 Houston Astros
are listed as giving up only 4 home runs.  The error can be seen on
this page:

      http://baseball-reference.com/teams/HOU/1981.shtml

They actually gave up 40 home runs, which is what you get when you
add up the individual home runs allowed.  This agrees with the
Retrosheet site.

Justin Kubatko
---
jkubatko@...
jkubatko@...

Justin Kubatko wrote:
> Hi,
>
> I discovered an error in the Teams file.  The 1981 Houston Astros
> are listed as giving up only 4 home runs.  The error can be seen on
> this page:
>
>      http://baseball-reference.com/teams/HOU/1981.shtml
>
> They actually gave up 40 home runs, which is what you get when you
> add up the individual home runs allowed.  This agrees with the
> Retrosheet site.
>
> Justin Kubatko


Thanks, I'll get that fixed.


--
Sincerely,
Sean Forman

Baseball Stats!   http://www.Baseball-Reference.com/
Baseball Analysis!    http://www.BaseballPrimer.com/

Here is an update on the new Transaction group , group home page;
http://groups.yahoo.com/group/BBTransaction
>
> This group will be used as a focal point to post/update research on
> transactions in the history of professional baseball. Trades, drafts, free
> agency signings, etc. The group will also accept more non-traditional
> items (i.e. call ups, disabled list entries, etc) and evaluate their
> addition to the main database.
I just uploaded a missing transaction breakdown into the FILES section of
the group. I uploaded a breakdown by years (5 year increments) and by teams
. Please take a look and see which ones you may be able to resolve. In the
future we will be uploading a list of team moves that we do not have any
transaction data for, but that is still a couple of months away. Come take a
look and see if we can make another research project a resounding success.

> Hope list admins will forgive me if this is a little off-topic. I think
> this might fit nicely into alot of these areas.
>
> Mike Crain
> Helpdesk Support Engineer 2  - Dayton
> Webstar Support
> CLE Desktop Support
> LexisNexis*
> Phone - (937)865-6800 x55155
> Email - mike.crain@...
> sendpage - mikec
>

DOH! I did it again! The correct link is
http://groups.yahoo.com/group/BBTransactions. At least the group is better
organized than I am!

>  -----Original Message-----
> From:  Crain, Mike (LNG-DAY)
> Sent: Monday, April 28, 2003 5:09 PM
> To: 'BBALL - Databank'; 'SABR - 19Century'; 'SABR - Spring Training';
> 'SABR- Deadball'; 'SABR - Mailing List'; 'RetroList@yahoogroups.com';
> 'BaseballBiz@yahoogroups.com'
> Subject: Yahoo Transactions group
>
>  Here is an update on the new Transaction group , group home page;
> http://groups.yahoo.com/group/BBTransactions
>
>  This group will be used as a focal point to post/update research on
> transactions in the history of professional baseball. Trades, drafts, free
> agency signings, etc. The group will also accept more non-traditional
> items (i.e. call ups, disabled list entries, etc) and evaluate their
> addition to the main database.
> I just uploaded a missing transaction breakdown into the FILES section of
> the group. I uploaded a breakdown by years (5 year increments) and by
> teams . Please take a look and see which ones you may be able to resolve.
> In the future we will be uploading a list of team moves that we do not
> have any transaction data for, but that is still a couple of months away.
> Come take a look and see if we can make another research project a
> resounding success.
>
>  Hope list admins will forgive me if this is a little off-topic. I
> think this might fit nicely into alot of these areas.
>
>  Mike Crain
>  Helpdesk Support Engineer 2  - Dayton
>  Webstar Support
>  CLE Desktop Support
>  LexisNexis*
>  Phone - (937)865-6800 x55155
>  Email - mike.crain@...
>  sendpage - mikec
>

DOH! I did it again! The correct link is
http://groups.yahoo.com/group/BBTransactions. At least the group is better
organized than I am!

>  -----Original Message-----
> From:       Crain, Mike (LNG-DAY) 
> Sent:      Monday, April 28, 2003 5:09 PM
> To:      'BBALL - Databank'; 'SABR - 19Century'; 'SABR - Spring Training';
> 'SABR- Deadball'; 'SABR - Mailing List'; 'RetroList@yahoogroups.com';
> 'BaseballBiz@yahoogroups.com'
> Subject:      Yahoo Transactions group
>
>       Here is an update on the new Transaction group , group home page;
> http://groups.yahoo.com/group/BBTransactions
>      
>       This group will be used as a focal point to post/update research on
> transactions in the history of professional baseball. Trades, drafts, free
> agency signings, etc. The group will also accept more non-traditional
> items (i.e. call ups, disabled list entries, etc) and evaluate their
> addition to the main database.
> I just uploaded a missing transaction breakdown into the FILES section of
> the group. I uploaded a breakdown by years (5 year increments) and by
> teams . Please take a look and see which ones you may be able to resolve.
> In the future we will be uploading a list of team moves that we do not
> have any transaction data for, but that is still a couple of months away.
> Come take a look and see if we can make another research project a
> resounding success.
>
>       Hope list admins will forgive me if this is a little off-topic. I
> think this might fit nicely into alot of these areas.
>
>       Mike Crain
>       Helpdesk Support Engineer 2  - Dayton
>       Webstar Support
>       CLE Desktop Support
>       LexisNexis*
>       Phone - (937)865-6800 x55155
>       Email - mike.crain@...
>       sendpage - mikec
>


http://www.baseball-databank.org/

To unsubscribe from this group, send an email to:
baseball-databank-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Sorry about that. Anyone got any cofee?

http://groups.yahoo.com/group/BBTransactions


--- Timothy Fisher <trfishermi@...> wrote:
> Give it one more try Mike, your correct URL should be
> http://groups.yahoo.com/group/BBTransactions without the "." at the end.
> Tim
> "Crain, Mike (LNG-DAY)" <ucraimx@...> wrote:DOH! I did it again!
> The correct link is
> http://groups.yahoo.com/group/BBTransactions. At least the group is
> better
> organized than I am!
>
> >  -----Original Message-----
> > From:       Crain, Mike (LNG-DAY)
> > Sent:      Monday, April 28, 2003 5:09 PM
> > To:      'BBALL - Databank'; 'SABR - 19Century'; 'SABR - Spring
> Training';
> > 'SABR- Deadball'; 'SABR - Mailing List'; 'RetroList@yahoogroups.com';
> > 'BaseballBiz@yahoogroups.com'
> > Subject:      Yahoo Transactions group
> >
> >       Here is an update on the new Transaction group , group home
> page;
> > http://groups.yahoo.com/group/BBTransactions
> >
> >       This group will be used as a focal point to post/update research
> on
> > transactions in the history of professional baseball. Trades, drafts,
> free
> > agency signings, etc. The group will also accept more non-traditional
> > items (i.e. call ups, disabled list entries, etc) and evaluate their
> > addition to the main database.
> > I just uploaded a missing transaction breakdown into the FILES section
> of
> > the group. I uploaded a breakdown by years (5 year increments) and by
> > teams . Please take a look and see which ones you may be able to
> resolve.
> > In the future we will be uploading a list of team moves that we do not
> > have any transaction data for, but that is still a couple of months
> away.
> > Come take a look and see if we can make another research project a
> > resounding success.
> >
> >       Hope list admins will forgive me if this is a little off-topic.
> I
> > think this might fit nicely into alot of these areas.
> >
> >       Mike Crain
> >       Helpdesk Support Engineer 2  - Dayton
> >       Webstar Support
> >       CLE Desktop Support
> >       LexisNexis*
> >       Phone - (937)865-6800 x55155
> >       Email - mike.crain@...
> >       sendpage - mikec
> >
>
> Yahoo! Groups Sponsor
> http://www.baseball-databank.org/
>
> To unsubscribe from this group, send an email to:
> baseball-databank-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
> ---------------------------------
> Do you Yahoo!?
> The New Yahoo! Search - Faster. Easier. Bingo.

George McMillan, birth and death unknown.
It appears that "0" should be replaced by "" in six date fields.
--Paul

Mordecai Brown, FL1914
stint 1, St Louis (SLF)
stint 2, Brooklyn (BRF)

St Louis, FL1914
manager 1, Mordecai Brown (brownmo01)
manager 2, Fielder Jones (jonesfi01)

I checked two Lahman50 tables only.  The Pitcher stints should be
exchanged; the Manager stints are correct.

The Pitcher and Manager tables are practically inconsistent in this case,
showing that Brown pitched first for Brooklyn but served as St Louis'
first manager.

P/\/ \/\/t
Paul Wendt, Watertown MA, USA <pgw@...>

Lahman50 Pitcher and Manager tables are practically inconsistent for
Mordecai Brown 1914, showing that he pitched first for Brooklyn but served
as St Louis' first manager.

Perhaps the manager table can be checked against all the player tables for
this type of inconsistency and its converse, where some team's last
manager played last for another team.  (Neither check will uncover logical
inconsistencies, since teams begin and end their seasons on different
dates, especially in the bankruptcy days to 1891.  I guess that few cases
will be uncovered, and they will be easy to confirm as "true positives".)

Perhaps the player tables can be checked against each other.

P/\/ \/\/t
Paul Wendt, Watertown MA, USA <pgw@...>

I think someone else came up with the manager stints, doing most (all?) of
their work by hand. So I think a check like you describe would be wise.
It's likely any errors found are in the player tables. I don't think
there's any harm in checking the player tables against each other, but I
doubt anything will be discovered there, since the source was the same for
all of those. there's always the chance for mismatching or something along
those lines, though, so it wouldn't hurt.

Derek


On Wed, 30 Apr 2003, Paul Wendt wrote:

> Lahman50 Pitcher and Manager tables are practically inconsistent for
> Mordecai Brown 1914, showing that he pitched first for Brooklyn but served
> as St Louis' first manager.
>
> Perhaps the manager table can be checked against all the player tables for
> this type of inconsistency and its converse, where some team's last
> manager played last for another team.  (Neither check will uncover logical
> inconsistencies, since teams begin and end their seasons on different
> dates, especially in the bankruptcy days to 1891.  I guess that few cases
> will be uncovered, and they will be easy to confirm as "true positives".)
>
> Perhaps the player tables can be checked against each other.
>
> P/\/ \/\/t
> Paul Wendt, Watertown MA, USA <pgw@...>

Ed Barrow, height 0 weight 0 and debut 0000-00-00
It appears that "0" should be replaced by "" in three fields.

I checked debut dates for a *subset* of the Lahman50 Master table,
and found Ed Barrow (did not play MLB) debut 0000-00-00.

I noticed weight 0 and height 0 for Barrow, so I checked my subset and
found one other with weight 0, two others with height 0.

There may be other fields where ZERO should not appear, but does.

--Paul

Is there a biographical committee here?

For the maybe committee:
Much data is missing for Hall of Fame members who did not play or manage,
although much of it has been published.  Much data is missing for managers
who did not play.  I understand that it is maintained by the SABR
Biographical Cmtee, for all MLB managers as for all MLB players.

Two SABR publications include biographical data for many 19c personages,
_Nineteenth Century Stars_ (1989) and _Baseball's First Stars_ (1996).

For example, here is the extra data published in the second volume,
"BB1st*", for the three men in the database with 1820s birthdates.

Alexander Cartwright [BB1st*, p24], name weight & height:
   "Alexander Joy, Jr.", Alick, 210, 74
(I wonder whether Knick basepaths were measured in Cartwright's paces.)

Bill Cammeyer [BB1st*, p21], birth death & name:
   USA, NY, New York, 1898, 9, 4, USA, NY, Brooklyn, William Henry, *
(* no mention of "Bill".)

Henry Chadwick [BB1st*, p26-27], birth death & name
   England, Devonshire, Exeter, 1908, 4, 20, USA, NY, Brooklyn, Henry, Chad

P/\/ \/\/t
Paul Wendt, Watertown MA, USA <pgw@...>
Chair, 19th Century Committee, SABR

29 Apr, "mcmilge01 vital dates"

> George McMillan, birth and death unknown.
> It appears that "0" should be replaced by "" in six date fields.

30 Apr, "barroed01 weight, height, debut ZERO"

> Ed Barrow, height 0 weight 0 and debut 0000-00-00
> It appears that "0" should be replaced by "" in three fields.

I checked the subset of Lahman50 Master table with debut < 1921,
which I extracted from the whole for a baseball purpose.
Barrow is the only one with debut < 1871.

For some of the nine fields where I reported bad ZEROs for mcmilge01 and
barroed01, the early-debut subset includes 1 or 2 others with bad ZEROs.

I also checked the maximum value in each of those nine fields and did not
see any obvious mistakes.

--Paul

I have the recent data and have forwarded that to Derek as well. It is a
flat text file. Derek, are you going to sync it or would you like someone
else to pick that up for you?


Mike C
--- Paul Wendt <pgw@...> wrote:
> Is there a biographical committee here?
>
> For the maybe committee:
> Much data is missing for Hall of Fame members who did not play or
> manage,
> although much of it has been published.  Much data is missing for
> managers
> who did not play.  I understand that it is maintained by the SABR
> Biographical Cmtee, for all MLB managers as for all MLB players.
>
> Two SABR publications include biographical data for many 19c personages,
> _Nineteenth Century Stars_ (1989) and _Baseball's First Stars_ (1996).
>
> For example, here is the extra data published in the second volume,
> "BB1st*", for the three men in the database with 1820s birthdates.
>
> Alexander Cartwright [BB1st*, p24], name weight & height:
>   "Alexander Joy, Jr.", Alick, 210, 74
> (I wonder whether Knick basepaths were measured in Cartwright's paces.)
>
> Bill Cammeyer [BB1st*, p21], birth death & name:
>   USA, NY, New York, 1898, 9, 4, USA, NY, Brooklyn, William Henry, *
> (* no mention of "Bill".)
>
> Henry Chadwick [BB1st*, p26-27], birth death & name
>   England, Devonshire, Exeter, 1908, 4, 20, USA, NY, Brooklyn, Henry,
> Chad
>
> P/\/ \/\/t
> Paul Wendt, Watertown MA, USA <pgw@...>
> Chair, 19th Century Committee, SABR
>
>

Paul Wendt wrote:
> Lahman50 Pitcher and Manager tables are practically inconsistent for
> Mordecai Brown 1914, showing that he pitched first for Brooklyn but served
> as St Louis' first manager.
>
> Perhaps the manager table can be checked against all the player tables for
> this type of inconsistency and its converse, where some team's last
> manager played last for another team.  (Neither check will uncover logical
> inconsistencies, since teams begin and end their seasons on different
> dates, especially in the bankruptcy days to 1891.  I guess that few cases
> will be uncovered, and they will be easy to confirm as "true positives".)
>
> Perhaps the player tables can be checked against each other.
>
> P/\/ \/\/t
> Paul Wendt, Watertown MA, USA <pgw@...>


The player tables have been checked against each other.  I'm fairly
confident that we don't have any stint errors between fielding and
batting and pitching tables.  I've fixed a couple of the ones you sent
me regarding the managers.

My school year ends this week, so I should be able to update the BDB
more often this summer and hopefully implement a system that keeps one
person from being the bottleneck for corrections and updates.


--
Sincerely,
Sean Forman

Baseball Stats!   http://www.Baseball-Reference.com/
Baseball Analysis!    http://www.BaseballPrimer.com/

I was about to embark on some research based on pitcher's throwing handeness
using the Access97 version of the database. I discovered that exactly two
pitchers born in the 20th century are missing this information, and it seems
to be the result of a processing error somewhere, as the information is
present in the Text version.

In the Access97 version of the database, downloaded as lahman50-97.zip,
three players have some strange looking information in the Master table:

PlayerID=campbmi02 nameFirst=Mike nameLast=Campbell nameNote=Also known as \
PlayerID=macdobo01 nameFirst=Bob nameLast=MacDonald nameNote=also known as \
PlayerID=woodwro01 nameFirst=Rob nameLast=Woodward nameNote=Also known as \

All the fields to the right of nameNote (height, weight, bats, throws,
retroID, etc.) are missing. I am highly skeptical that any of these players
were ever known to anyone as \.

In the text version of the database, downloaded as lahman50-csv.zip, the
information is different:

PlayerID=campbmi02 nameNote=Also known as \Mat Campbell\""
PlayerID=macdobo01 nameNote=also known as \Rob MacDonald\""
PlayerID=woodwro01 nameNote=Also known as \Bob Woodward\""

Most of the fields to the right of nameNote are present, and presumably
correct. Does the unusual syntax in the nameNote field signify anything,
other than the presence of poltergeists intent on rendering the database as
difficult to use as possible?

I have no capability of processing the Access2000 version.

Hope this helps.

Those are escape characters to allow UNIX/Linux to
process " as a character, rather than as a delimiter.
This was part of my notes regarding illegal characters
for our DB.

Tom

--- Michael Mavrogiannis <mmavrogi@...>
wrote:
> I was about to embark on some research based on
> pitcher's throwing handeness
> using the Access97 version of the database. I
> discovered that exactly two
> pitchers born in the 20th century are missing this
> information, and it seems
> to be the result of a processing error somewhere, as
> the information is
> present in the Text version.
>
> In the Access97 version of the database, downloaded
> as lahman50-97.zip,
> three players have some strange looking information
> in the Master table:
>
> PlayerID=campbmi02 nameFirst=Mike nameLast=Campbell
> nameNote=Also known as \
> PlayerID=macdobo01 nameFirst=Bob nameLast=MacDonald
> nameNote=also known as \
> PlayerID=woodwro01 nameFirst=Rob nameLast=Woodward
> nameNote=Also known as \
>
> All the fields to the right of nameNote (height,
> weight, bats, throws,
> retroID, etc.) are missing. I am highly skeptical
> that any of these players
> were ever known to anyone as \.
>
> In the text version of the database, downloaded as
> lahman50-csv.zip, the
> information is different:
>
> PlayerID=campbmi02 nameNote=Also known as \Mat
> Campbell\""
> PlayerID=macdobo01 nameNote=also known as \Rob
> MacDonald\""
> PlayerID=woodwro01 nameNote=Also known as \Bob
> Woodward\""
>
> Most of the fields to the right of nameNote are
> present, and presumably
> correct. Does the unusual syntax in the nameNote
> field signify anything,
> other than the presence of poltergeists intent on
> rendering the database as
> difficult to use as possible?
>
> I have no capability of processing the Access2000
> version.
>
> Hope this helps.
>
>
>
>
> ------------------------ Yahoo! Groups Sponsor
>
> http://www.baseball-databank.org/
>
> To unsubscribe from this group, send an email to:
> baseball-databank-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>


__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com

Does anyone know of a site where I can find the 1993-1995 al splits
now that stats, inc has changed it's website?

Jerrod Riggan's debut date is listed as 2002-08-29 in the 12-10 version of
the DB in the Master table. This should be 2000-08-29. Source: TB7.

----

I'm updating things on my end and will soon be posting updated Master,
Fielding, and Pitching files with all "extra" info I have inline.

Extra info:
Master: Stats ID
Fielding: PB
Pitching: IBB, WP, HBP, BK, BFP, GF

Hopefully, that will be the last time I need to sync those up, and then
the "official" files will have all the data.

This will also allow me to address Mike's recent requests (or at the very
least, give him the info he needs to continue without needing to wait for
me).

Regards,
Derek

Someone at Primer alerted me to this.

According to the TEAMS table, we have the following
yearID SumOfDP
1999 4624
2000 4722
2001 4439
2002 3845

(quite a drop in 2002).

The FIELDING table, which may be out of date in my
version shows
yearID SumOfDP
1999 12575
2000 12651
2001 11926

(no 2002 data?)

Based on Ray Kerby's software, it shows:
Year DP
1999 4687
2000 4713
2001 4439
2002 4568

Seems, as the Primer reader pointed out, that the 2002
data at BDB has GIDP data for 2002, while it has all
DP data for pre-2002.

Strange as well that Ray's and BDB match for 2001 data
exactly, but is slightly off for 99/00 (off by 63 and
9).  Not sure if Ray's event files were not the final
version, or it's his program, or BDB.

If someone wants to reconcile this against the
"official" stats, that would be great.

Thanks, Tom





__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com

Robert Dudek wrote the following at Primer
========
From the Sporting News Baseball Guides:

2002(both leagues): 4565 DPs in 2426 games (1.88 per
game)
2001(both leagues): 4435 DPs in 2429 games (1.83 per
game)

From STATS Major League Handbook:

2000(both leagues): 4712 DPs in 2430 games (1.94 per
game
===========

which shows that Ray is closer, but there is no
agreement between all sources.

Even the one year where Ray and BDB match (2001:
4439), they don't match the above (4435).

Tom

--- "tmasc@..." <tmasc@...> wrote:
> Someone at Primer alerted me to this.
>
> According to the TEAMS table, we have the following
> yearID SumOfDP
> 1999 4624
> 2000 4722
> 2001 4439
> 2002 3845
>
> (quite a drop in 2002).
>
> The FIELDING table, which may be out of date in my
> version shows
> yearID SumOfDP
> 1999 12575
> 2000 12651
> 2001 11926
>
> (no 2002 data?)
>
> Based on Ray Kerby's software, it shows:
> Year DP
> 1999 4687
> 2000 4713
> 2001 4439
> 2002 4568
>
> Seems, as the Primer reader pointed out, that the
> 2002
> data at BDB has GIDP data for 2002, while it has all
> DP data for pre-2002.
>
> Strange as well that Ray's and BDB match for 2001
> data
> exactly, but is slightly off for 99/00 (off by 63
> and
> 9).  Not sure if Ray's event files were not the
> final
> version, or it's his program, or BDB.
>
> If someone wants to reconcile this against the
> "official" stats, that would be great.
>
> Thanks, Tom
>
>
>
>
>
> __________________________________
> Do you Yahoo!?
> The New Yahoo! Search - Faster. Easier. Bingo.
> http://search.yahoo.com
>


__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com