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

I have the Salary data that's in the Baseball Databasnk.I presume that was
from Doug Pappas. While looking for missing Transactions, I have ran across
several players with salaries in seasons they did not play (Safe to guess
Disabled list?) and missing salaries for years they did play. While I don't
have an example of the former,  (I'll keep my eyes open for data), here is
the latter"

John Costello
Year Team 		 Stint G
1988 St. Louis Cardinals 1   36
1989 St. Louis Cardinals 1   48
1990 St. Louis Cardinals 1    4
1990 Montreal Expos 	 2    4
1991 San Diego Padres    1   27


Salary Information
Year Salary
1989 85000
1990 105000

What was the salary in 1988 and 1991? And is the 1990 salary a combined
salary between the 2 teams?


On another note, is there salary data for managers and coaches?

Mike Crain

I would suggest forwarding these sorts of questions to Doug Pappas. It's
possible that there's some reason for Costello being excluded (Doug could
enlighten us).  if there's a gap in his database, which seems more likely,
Doug would like to know. We also should ask him to keep us in the loop when
he makes changes and corrections to his historical data.

As for manager and coaches salaries, I suspect the answer is that the data
is not available.  The player data is published by the player's union, to
help players now what their peers are being paid.  Coaches and managers
don't have a union, and so there's nobody in place to publish the data. Some
teams and some coaches may disclose their salaries in print, but that's
anecdotal and problematic.

Regards,
Sean

> -----Original Message-----
> From: Crain, Mike (LNG-DAY) [mailto:ucraimx@...]
> Sent: Tuesday, May 20, 2003 5:01 PM
> To: 'SABR - Baseball Biz'; 'BBALL - Databank'
> Subject: [baseball-databank] Salary data
>
>
> I have the Salary data that's in the Baseball Databasnk.I presume that was
> from Doug Pappas. While looking for missing Transactions, I have
> ran across
> several players with salaries in seasons they did not play (Safe to guess
> Disabled list?) and missing salaries for years they did play.
> While I don't
> have an example of the former,  (I'll keep my eyes open for data), here is
> the latter"
>
> John Costello
> Year Team 		 Stint G
> 1988 St. Louis Cardinals 1   36
> 1989 St. Louis Cardinals 1   48
> 1990 St. Louis Cardinals 1    4
> 1990 Montreal Expos 	 2    4
> 1991 San Diego Padres    1   27
>
>
> Salary Information
> Year Salary
> 1989 85000
> 1990 105000
>
> What was the salary in 1988 and 1991? And is the 1990 salary a combined
> salary between the 2 teams?
>
>
> On another note, is there salary data for managers and coaches?
>
> Mike Crain
>
>
>
> 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/
>
>
>
>
>

I'd like to know if anyone's updated the MLB schedule that I
parsed/posted to this group at the start of the season (for rainouts,
etc).

Thanks... Tom

Just came across an error in the post-season data.  Tippy Martinez has
incorrect data for the 1979 World Series. We show him with one IP in the WS.
In fact, he pitched 1.1 innings.  I verified this with the box scores at
retrosheet.  Total Baseball also agrees that he pitched 1.1  innings.

Regards,
Sean Lahman

Does anyone know where I get minor league statistics for prior
seasons online?  I just downloaded the 2002 seasons from this group
and would like to be able to get any prior seasons available.

Fellow BDB-ers:

The Debut Date in the current release is in a dte format , I.e.
1/1/2003. I wanted to see if others thougt that should be broken up
into DebutMonth, DebutDay, DebutYear like birth and death dates are.
I think it'd be good to be able to query on those seperate fields.

I also have the SABR Bio Commitee data. There are ALOT of updates we
don't have are missing. One of which is a FinalGame (Which is the
data of the player's Final Game).  What do you think?


Also, does anyone know in SQL a easy way to break those fields up?



Mike Crain

FinalGame data sounds like nice data to have...
Real easy to pull debutmonth, debutday, debutyear:

(I created debutmonth, debutday & debutyear fields and defined each type as
a smallint)

try this:
update master
set debutmonth = month(debut),
debutday = day(debut),
debutyear = year(debut)
where debut is not null




declare @today datetime
--select top 1 * from [master]

set @today = (select top 1 debut from master)


select month(@today)
select day(@today)
select year(@today)


>From: "Mike Crain" <ucraimx@...>
>Reply-To: baseball-databank@yahoogroups.com
>To: baseball-databank@yahoogroups.com
>Subject: [baseball-databank] Debut date/Final game date
>Date: Sat, 24 May 2003 18:09:43 -0000
>
>Fellow BDB-ers:
>
>The Debut Date in the current release is in a dte format , I.e.
>1/1/2003. I wanted to see if others thougt that should be broken up
>into DebutMonth, DebutDay, DebutYear like birth and death dates are.
>I think it'd be good to be able to query on those seperate fields.
>
>I also have the SABR Bio Commitee data. There are ALOT of updates we
>don't have are missing. One of which is a FinalGame (Which is the
>data of the player's Final Game).  What do you think?
>
>
>Also, does anyone know in SQL a easy way to break those fields up?
>
>
>
>Mike Crain
>

_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
http://join.msn.com/?page=features/virus

Thanks!!!!!!!!!!
--- tom lewis <tlewis0271@...> wrote:
> FinalGame data sounds like nice data to have...
> Real easy to pull debutmonth, debutday, debutyear:
>
> (I created debutmonth, debutday & debutyear fields and defined each type
> as
> a smallint)
>
> try this:
> update master
> set debutmonth = month(debut),
> debutday = day(debut),
> debutyear = year(debut)
> where debut is not null
>
>
>
>
> declare @today datetime
> --select top 1 * from [master]
>
> set @today = (select top 1 debut from master)
>
>
> select month(@today)
> select day(@today)
> select year(@today)
>
>
> >From: "Mike Crain" <ucraimx@...>
> >Reply-To: baseball-databank@yahoogroups.com
> >To: baseball-databank@yahoogroups.com
> >Subject: [baseball-databank] Debut date/Final game date
> >Date: Sat, 24 May 2003 18:09:43 -0000
> >
> >Fellow BDB-ers:
> >
> >The Debut Date in the current release is in a dte format , I.e.
> >1/1/2003. I wanted to see if others thougt that should be broken up
> >into DebutMonth, DebutDay, DebutYear like birth and death dates are.
> >I think it'd be good to be able to query on those seperate fields.
> >
> >I also have the SABR Bio Commitee data. There are ALOT of updates we
> >don't have are missing. One of which is a FinalGame (Which is the
> >data of the player's Final Game).  What do you think?
> >
> >
> >Also, does anyone know in SQL a easy way to break those fields up?
> >
> >
> >
> >Mike Crain
> >
>
> _________________________________________________________________
> MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
> http://join.msn.com/?page=features/virus
>
>

Mike Crain wrote:
> Fellow BDB-ers:
>
> The Debut Date in the current release is in a dte format , I.e.
> 1/1/2003. I wanted to see if others thougt that should be broken up
> into DebutMonth, DebutDay, DebutYear like birth and death dates are.
> I think it'd be good to be able to query on those seperate fields.
>
> I also have the SABR Bio Commitee data. There are ALOT of updates we
> don't have are missing. One of which is a FinalGame (Which is the
> data of the player's Final Game).  What do you think?
>
>
> Also, does anyone know in SQL a easy way to break those fields up?
>
>
>
> Mike Crain


I think the posted solution handled the question you were looking for.
I also think that having final game would be a definite plus.  We'll
work on adding that this summer.


--
Sincerely,
Sean Forman

Baseball Stats!   http://www.Baseball-Reference.com/
Baseball Analysis!    http://www.BaseballPrimer.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        : /test.csv
   Uploaded by : ucraimx <ucraimx@...>
   Description : File of Debut/Final Game dates from SABR BioCommitee

You can access this file at the URL

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

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

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

Regards,

ucraimx <ucraimx@...>

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        : /estpitch.zip
   Uploaded by : tangotiger <tmasc@...>
   Description : Pitch counts, estimated.  Uses 3.3*(ipouts+h+bb)+1.5*so+2.2*bb. 
Untested.

You can access this file at the URL

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

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

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

Regards,

tangotiger <tmasc@...>

I have done updates on the "Awards" table (added more awards , as
well as some accomplishments (40-40 club, HR is first/last AB). Has
anyone else done any work on their copy? I was going to post mine if
not (If so, we can mesh together for a nice release).


Mike Crain

Following Mike's note, this is probably a good as time
as any to ask the members here as to what they are
prepared (time/effort/resources) to contribute in the
next 0 to 3 months.

For my part, I'm prepared to implement the latest DB
design that Tom Lewis and I proposed (and apparently
ratified by default).
http://groups.yahoo.com/group/baseball-databank/message/1367

I haven't updated my TODO list from a few months ago,
but I will, once we've established any kind of
momentum.  This is the last TODO list
http://groups.yahoo.com/group/baseball-databank/message/1242
An additional 300 messages have appeared in the
archives since that went out.

So, I'll say that I can contribute 2 hrs/week for 8 of
the next 12 weeks.

Anyone else?

Tom



__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com

Once the new MASTER is done, I'm going to update my coach, exec,and umpire
tabnle with the matching ID's. Then those will be ready for release. I'm
working with the Transdaction group and will have a "list" of transactions
that have no record of in Tom's database, so that will take some of my
time. Also woking to get a SQL version of the BDB ready for SABR web site.

There is probably a few other things, but none coming to mind.
--- "tmasc@..." <tmasc@...> wrote:
> Following Mike's note, this is probably a good as time
> as any to ask the members here as to what they are
> prepared (time/effort/resources) to contribute in the
> next 0 to 3 months.
>
> For my part, I'm prepared to implement the latest DB
> design that Tom Lewis and I proposed (and apparently
> ratified by default).
> http://groups.yahoo.com/group/baseball-databank/message/1367
>
> I haven't updated my TODO list from a few months ago,
> but I will, once we've established any kind of
> momentum.  This is the last TODO list
> http://groups.yahoo.com/group/baseball-databank/message/1242
> An additional 300 messages have appeared in the
> archives since that went out.
>
> So, I'll say that I can contribute 2 hrs/week for 8 of
> the next 12 weeks.
>
> Anyone else?
>
> Tom
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
> http://calendar.yahoo.com
>

Greetings.

I'm sending this out to a couple of different groups looking for information
Please forgive me if this is slightly off topic.

I'm looking for information on the hiring/firing dates of Managers/coaches ,
and  dates where the owner of a team changed hands. While these are not
typical "Transactions", I think this would be interesting information to
pool up. Either on or off list responses are OK with me. Or you could post
them in my Transaction group:http://groups.yahoo.com/group/BBTransactions/
(Which is the right URL this time!).

If you know of a source that has this information, if you could mention that
as well. I have the information at http://mlb.com (2000-2003) already.

Mike Crain

tmasc@... wrote:

> Anyone else?
>
> Tom


I'm going to piggy-back on Tom's note here and ask if there is any
interest in meeting at the SABR convention in Denver July 9-13.  I could
ask Rod Nelson, who may be on this group for a room and a time we could
meet.

I hope to put out a roadmap for future development in the next few
weeks.  I'm dropping some other activities which will hopefully give me
more time for this.

Sincerely,
Sean Forman

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

SABRscouts@... wrote:
> I personally would love to know that this group can meet face-to-face
> this summer in Denver at SABR33.  This would allow me, the database
> novice in this forum, to pick the brains on how best to integrate the
> massive Excel files I've assembled for the Scouts Committee and the
> BioProject.  We are at a critical point in convention planning with the
> program going to the printer soon and frankly, it will take a little
> politicking to get this on the official schedule, but not totally out of
> the question.


At the moment, I would say we will be best served by something informal,
so please don't go to any trouble to get it on the official schedule.
Word of mouth should be sufficient.

What I would suggest is that once the schedule is done, we can fit
something in around it.  Even if it means, meeting in the lobby or in
the hotel bar for 30 minutes to an hour.

Sincerely,
Sean Forman

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

On Sun, 15 Jun 2003, Sean Forman wrote:

> At the moment, I would say we will be best served by something informal,
> so please don't go to any trouble to get it on the official schedule.
> Word of mouth should be sufficient.
>
> What I would suggest is that once the schedule is done, we can fit
> something in around it.  Even if it means, meeting in the lobby or in
> the hotel bar for 30 minutes to an hour.

Folks,

From my experience in Rod's position last year, I know that SABR does not
permit any official Convention event to be scheduled opposite its Board of
Directors meeting, so Sunday morning after 9:30am should remain free of
official events.

It is a high priority for me to meet Sean again briefly and I will make
that more than brief, or join an informal bbdb meeting, if convenient.
My calling card is an epoch not a theme (19th century, not Umpires), so I
have many high priorities at the Annual Convention (and many interests).

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

The Pictorial History Committee is also developing a massive data base in
Excel format.   The Player Image Index contains about 20,000 records and
catalogues info about photos of more than 14,000 major league players.  I would
be
interested in participating in a discussion in Denver if one is held.

       Bill Hickman
       Chair, Pictorial History Committee

--- In baseball-databank@yahoogroups.com, "tmasc@y..." <tmasc@y...>
wrote:
> Following Mike's note, this is probably a good as time
> as any to ask the members here as to what they are
> prepared (time/effort/resources) to contribute in the
> next 0 to 3 months.
>
> For my part, I'm prepared to implement the latest DB
> design that Tom Lewis and I proposed (and apparently
> ratified by default).
> http://groups.yahoo.com/group/baseball-databank/message/1367
>
> I haven't updated my TODO list from a few months ago,
> but I will, once we've established any kind of
> momentum.  This is the last TODO list
> http://groups.yahoo.com/group/baseball-databank/message/1242
> An additional 300 messages have appeared in the
> archives since that went out.
>
> So, I'll say that I can contribute 2 hrs/week for 8 of
> the next 12 weeks.
>
> Anyone else?
>
> Tom
>

First off, I apologize for my long silence. I've been sporadically
working on my Web-based DB frontend. No fancy GUI yet, but I've
covered the batting/pitching/fielding tables (and my custom
derivitaives thereof) pretty well. Latest accomplishment was to
figure out how to handle the year (hopefully) intelligently when the
user queries across multiple tables.

Though it'll eventually have to be modified somewhat to handle the
new design (which, by the way, to an eye mostly untrained in DB
structure [Database Systems couurse is on my fall schedule, however]
looks fine to me), I think that, within the next three months, I
think that can safely say that I'll be able at least to have some
primitive searching of team/franchise tables and, at the very least,
coherent documentation, since, if you recall from my previous posts
from a while back, what the frontend accepts isn't SQL.

Everyone,


I have a question on announcers. Doug  Pappas was good enough to supply me
with a list of team announcers from 2000-2003. I have another couple of
questions.

1. Who announced for the big networks (ESPN, CBS, etc) from 2000-2003?
2. In TB7, Curt Smith indicated that announcers worked "Post-Season"
(basically indicating that it was not in the regular season. But that could
be LCS, World Series, All-Star game). Does anyone have any details on this
so I can break it out?

Mike Crain
Phone - (937)865-6800 x55155