I think this has been brought up in the past but I can't find it for
the life of me.  The Hall of Fame website, Baseballlibrary.com and a
few other places say that HOF'er Fred Clarke hit .406 in 1897.
Baseball-reference.com, MLB.com and many other places disagree,
putting Clarke's 1897 average closer to .390.  Does anyone know the
story behind this discrepancy?  Didn't someone write an article
somewhere on this topic?  The difference was significant since it's
the only season that Clarke allegedly hit .400+

Thanks!  :)

Bill Knight

Hi Bill - Clarke's numbers, and more notably Cap Anson's, were adjusted by
the editors of the McMillan Baseball Encyclopedia based on some really
sloppy practices after David Neft was no longer in charge.  This mess is
described in Alan Schwarz's The Numbers Game on p158-161.  I'll work on
getting the good folk at BaseballLibrary.com to update their bio.

Rod Nelson
Research Services Manager
www.sabr.org

-----Original Message-----
From: baseball-databank@yahoogroups.com On Behalf Of wknight94
Sent: Thursday, November 02, 2006 12:16 PM
To: baseball-databank@yahoogroups.com
Subject: [baseball-databank] Fred Clarke hit .406 in 1897?

I think this has been brought up in the past but I can't find it for
the life of me.  The Hall of Fame website, Baseballlibrary.com and a
few other places say that HOF'er Fred Clarke hit .406 in 1897.
Baseball-reference.com, MLB.com and many other places disagree,
putting Clarke's 1897 average closer to .390.  Does anyone know the
story behind this discrepancy?  Didn't someone write an article
somewhere on this topic?  The difference was significant since it's
the only season that Clarke allegedly hit .400+

Thanks!  :)

Bill Knight




http://www.baseball-databank.org/
Yahoo! Groups Links

I have released the source code to one of my Markov
programs, which you can find here:

http://www.tangotiger.net/markov.html

Anyone who wants to understand run expectancy, linear
weights, or runs created better will find the above
useful, if not mandatory.

Hopefully, others will share some of their black boxes
with researchers at large.

Tom

---------------------------------------------
http://www.InsideTheBook.com
The Book--Playing The Percentages In Baseball










________________________________________________________________________________\
____
Sponsored Link

For just $24.99/mo., Vonage offers unlimited local and long- distance calling.
Sign up now. http://www.vonage.com/startsavingnow/

-----Original Message-----
From: baseball-databank@yahoogroups.com [mailto:baseball-databank@yahoogroups.com]On Behalf Of Sean Forman
Sent: Friday, November 17, 2006 3:30 PM
To: Baseball Databank
Subject: [baseball-databank] 2006 stats

Hello,

I have uploaded the 2006 stats.  Consider this a first pass.  I think they are correct and they have been vetted on baseball-reference for a few weeks now, but there are no guarantees.

Also, there have been hundreds of corrections largely from the SABR bio and records committee and some from random users.

I will put out another release following the announcement of the remaining records at some point in December. 

I hope to spend a week on this project during the off-season, so maybe we'll be able to get it kickstarted.

sean

--
--
Sincerely,        
Sean Forman

Baseball Stats!  http://www.Baseball-Reference.com/
SR Blog!           http://www.Baseball-Reference.com/blog/

Hello,

I have uploaded the 2006 stats.  Consider this a first pass.  I think they are correct and they have been vetted on baseball-reference for a few weeks now, but there are no guarantees.

Also, there have been hundreds of corrections largely from the SABR bio and records committee and some from random users.

I will put out another release following the announcement of the remaining records at some point in December. 

I hope to spend a week on this project during the off-season, so maybe we'll be able to get it kickstarted.

sean

--
--
Sincerely,        
Sean Forman

Baseball Stats!  http://www.Baseball-Reference.com/
SR Blog!           http://www.Baseball-Reference.com/blog/

-----Original Message-----
From: baseball-databank@yahoogroups.com [mailto:baseball-databank@yahoogroups.com]On Behalf Of KJOK
Sent: Friday, November 17, 2006 7:44 PM
To: baseball-databank@yahoogroups.com
Subject: Re: [baseball-databank] 2006 stats

All of the the tables imported into MS Access PERFECTLY!

 

THANKS,

Kevin

Sean Forman <sean-forman@baseball-reference.com> wrote:

Hello,

I have uploaded the 2006 stats.  Consider this a first pass.  I think they are correct and they have been vetted on baseball-reference for a few weeks now, but there are no guarantees.

Also, there have been hundreds of corrections largely from the SABR bio and records committee and some from random users.

I will put out another release following the announcement of the remaining records at some point in December. 

I hope to spend a week on this project during the off-season, so maybe we'll be able to get it kickstarted.

sean

--
--
Sincerely,        
Sean Forman

Baseball Stats!  http://www.Baseball-Reference.com/
SR Blog!           http://www.Baseball-Reference.com/blog/

---

Check out the all-new Yahoo! Mail beta - Fire up a more powerful email and get things done faster.

You might want to check into this but it appears to me that Dioner
Navarro's stints for 2006 are backwards.

--- In baseball-databank@yahoogroups.com, "Sean Forman" <sean-
forman@...> wrote:
>
> Hello,
>
> I have uploaded the 2006 stats.  Consider this a first pass.  I
think they
> are correct and they have been vetted on baseball-reference for a
few weeks
> now, but there are no guarantees.
>
> Also, there have been hundreds of corrections largely from the
SABR bio and
> records committee and some from random users.
>
> I will put out another release following the announcement of the
remaining
> records at some point in December.
>
> I hope to spend a week on this project during the off-season, so
maybe we'll
> be able to get it kickstarted.
>
> sean
>
> --
> --
> Sincerely,
> Sean Forman
>
> Baseball Stats!  http://www.Baseball-Reference.com/
> SR Blog!           http://www.Baseball-Reference.com/blog/
>

Kevin, did the last field in each row import properly when you directly imported the CSV files into Access?  (If so, what version of Access are your running?)  In the past, I've had a problem where the last field in several tables did not get imported when I tried to directly import the CSV files.  I had to first bring the CSV files into Excel and then import into Access from the Excel spreadsheets I made for each table.  (I'm running Access 2000.)

 

Keith Hemmelman

 

-----Original Message-----
From: baseball-databank@yahoogroups.com [mailto:baseball-databank@yahoogroups.com]On Behalf Of KJOK
Sent: Friday, November 17, 2006 7:44 PM
To: baseball-databank@yahoogroups.com
Subject: Re: [baseball-databank] 2006 stats

All of the the tables imported into MS Access PERFECTLY!

 

THANKS,

Kevin

Sean Forman <sean-forman@baseball-reference.com> wrote:

Hello,

I have uploaded the 2006 stats.  Consider this a first pass.  I think they are correct and they have been vetted on baseball-reference for a few weeks now, but there are no guarantees.

Also, there have been hundreds of corrections largely from the SABR bio and records committee and some from random users.

I will put out another release following the announcement of the remaining records at some point in December. 

I hope to spend a week on this project during the off-season, so maybe we'll be able to get it kickstarted.

sean

--
--
Sincerely,        
Sean Forman

Baseball Stats!  http://www.Baseball-Reference.com/
SR Blog!           http://www.Baseball-Reference.com/blog/

---

Check out the all-new Yahoo! Mail beta - Fire up a more powerful email and get things done faster.

Forgive the possibly stupid question, but where can I download the 2006
stats?  I have looked in the "files" and "database" sections of this
group to no avail.

I'd really like to import them into PureSim's database and run some
tests!

Shaun Sullivan
Developer, PureSim Baseball
www.puresim.com

-----Original Message-----
From: baseball-databank@yahoogroups.com [mailto:baseball-databank@yahoogroups.com]On Behalf Of Sean Forman
Sent: Saturday, November 18, 2006 9:09 AM
To: Baseball Databank
Subject: [baseball-databank] Re: 2006 stats

I just realized that I didn't provide any links here.  Sorry about that.

The databases are located at

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

There is a mysql version and a csv version.  These are complete historical databases with all data from 1871-2006.

Here is the list of tables and their defs and the row counts.
http://www.baseball-databank.org/files/BDB-def-2006-11-17.txt
http://www.baseball-databank.org/files/tables.txt

Please note that the fielding table probably won't fit into excel at over 120,000 rows.

sean

On 11/17/06, Sean Forman <sean-forman@baseball-reference.com> wrote:

Hello,

I have uploaded the 2006 stats.  Consider this a first pass.  I think they are correct and they have been vetted on baseball-reference for a few weeks now, but there are no guarantees.

Also, there have been hundreds of corrections largely from the SABR bio and records committee and some from random users.

I will put out another release following the announcement of the remaining records at some point in December. 

I hope to spend a week on this project during the off-season, so maybe we'll be able to get it kickstarted.

sean

--
--
Sincerely,        
Sean Forman

Baseball Stats!   http://www.Baseball-Reference.com/
SR Blog!           http://www.Baseball-Reference.com/blog/

--
--
Sincerely,        
Sean Forman

Baseball Stats!  http://www.Baseball-Reference.com/
SR Blog!           http://www.Baseball-Reference.com/blog/

-----Original Message-----
From: baseball-databank@yahoogroups.com [mailto:baseball-databank@yahoogroups.com]On Behalf Of puresimmer
Sent: Saturday, November 18, 2006 5:26 AM
To: baseball-databank@yahoogroups.com
Subject: [baseball-databank] Re: 2006 stats

Forgive the possibly stupid question, but where can I download the 2006
stats? I have looked in the "files" and "database" sections of this
group to no avail.

I'd really like to import them into PureSim's database and run some
tests!

Shaun Sullivan
Developer, PureSim Baseball
www.puresim.com

There's a problem with the 2004 postseason pitching data in the latest
release.  Home runs allowed are incorrect - it's just a repeat of the
earned runs entry.  For some reason I wasn't able to upload the
corrections to the files area, so I have put the revised (2004 only)
data here:

http://alum.wpi.edu/~dreynolds/baseball/patch.pitpost

Doug

Ed Sprague is a "return to team" case in 2000.  He started the season
with the Padres and was traded to the Red Sox on 6/30.  He was then
released by the Red Sox on 8/23 and signed with the Padres on 8/31.
According to Retrosheet, he played 53 games in his first stint with
the Padres, and 20 in his second stint (plus 33 games with the Red
Sox).  However, the database does not have separate data for his two
stints with the Padres.  These are his 2000 entries in the Batting table:

spraged02,2000,1,SDN,NL,73,157,19,41,12,0,10,27,0,0,13,40,2,3,0,2,1
spraged02,2000,2,BOS,AL,33,111,11,24,4,0,2,9,0,0,12,18,0,0,0,0,2

Doug

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        : /ofgames.csv
   Uploaded by : dsreyn <dreynolds@...>
   Description : Total games played in outfield, 1996-2006

You can access this file at the URL:
http://groups.yahoo.com/group/baseball-databank/files/ofgames.csv

To learn more about file sharing for your group, please visit:
http://help.yahoo.com/help/us/groups/files

Regards,

dsreyn <dreynolds@...>

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        : /TSN-AllStar.csv
   Uploaded by : dsreyn <dreynolds@...>
   Description : Sporting News all-star team selections (updated through 2006)

You can access this file at the URL:
http://groups.yahoo.com/group/baseball-databank/files/TSN-AllStar.csv

To learn more about file sharing for your group, please visit:
http://help.yahoo.com/help/us/groups/files

Regards,

dsreyn <dreynolds@...>

Yes, Sprague is a return to team.
      http://world.std.com/~pgw/19c/return.to.team.html
Does anyone know the returns to team for 2005 or 2006?  I will add them
to that list.
Paul Wendt

20 Nov 2006, dsreyn wrote:
> Ed Sprague is a "return to team" case in 2000.  He started the season
> with the Padres and was traded to the Red Sox on 6/30.  He was then
> released by the Red Sox on 8/23 and signed with the Padres on 8/31.

Doug Mirabelli went from the Red Sox to the Padres and back to the Red Sox this
year.

Chuck

---- Paul Wendt <pgw@...> wrote:
> Yes, Sprague is a return to team.
>      http://world.std.com/~pgw/19c/return.to.team.html
> Does anyone know the returns to team for 2005 or 2006?  I will add them
> to that list.
> Paul Wendt
>
> 20 Nov 2006, dsreyn wrote:
> > Ed Sprague is a "return to team" case in 2000.  He started the season
> > with the Padres and was traded to the Red Sox on 6/30.  He was then
> > released by the Red Sox on 8/23 and signed with the Padres on 8/31.

No, the Red Sox traded Mirabelli to the Padres in the off-season
(12/7/2005) for Mark Loretta, so he only had one stint with the Red
Sox in 2006.

Doug

--- In baseball-databank@yahoogroups.com, <mjohns2@...> wrote:
>
> Doug Mirabelli went from the Red Sox to the Padres and back to the
Red Sox this year.
>
> Chuck
>
> ---- Paul Wendt <pgw@...> wrote:
> > Yes, Sprague is a return to team.
> >      http://world.std.com/~pgw/19c/return.to.team.html
> > Does anyone know the returns to team for 2005 or 2006?  I will add
them
> > to that list.
> > Paul Wendt
> >
> > 20 Nov 2006, dsreyn wrote:
> > > Ed Sprague is a "return to team" case in 2000.  He started the
season
> > > with the Padres and was traded to the Red Sox on 6/30.  He was then
> > > released by the Red Sox on 8/23 and signed with the Padres on 8/31.
>

I believe James Baldwin had two separate stints with the Orioles in
2005, with some time with the Rangers in between.

http://www.all-baseball.com/transactionguy/archives/cat_orioles.html

--Phil Kirlin

Paul Wendt wrote:
>
>
> Yes, Sprague is a return to team.
> http://world.std.com/~pgw/19c/return.to.team.html
> <http://world.std.com/~pgw/19c/return.to.team.html>
> Does anyone know the returns to team for 2005 or 2006? I will add them
> to that list.
> Paul Wendt
>
> 20 Nov 2006, dsreyn wrote:
>  > Ed Sprague is a "return to team" case in 2000. He started the season
>  > with the Padres and was traded to the Red Sox on 6/30. He was then
>  > released by the Red Sox on 8/23 and signed with the Padres on 8/31.
>
>

Novice questions here I should know the answer to.  What is the
difference between the BDB stats and those from Baseball Archive?  Are
they from the same source?  Just curious.

You need to learn the Baseball Almanac policy.  Ask editor Sean Holtz.
He sometimes revises biographical data.  Playing data, I don't know.
Paul Wendt


On Wed, 29 Nov 2006, John Walsh wrote:

> I'm just a user, but I'm fairly certain that they are the same exact
> databases.
>
> -John
>
>
> On 11/29/06, jdpeterman <jdpeterman@...> wrote:
>>
>>   Novice questions here I should know the answer to. What is the
>> difference between the BDB stats and those from Baseball Archive? Are
>> they from the same source? Just curious.
>>
>>
>

You need to learn the Baseball Almanac policy. Ask editor Sean Holtz.
He sometimes revises biographical data. Playing data, I don't know.
Paul Wendt

On Wed, 29 Nov 2006, John Walsh wrote:

> I'm just a user, but I'm fairly certain that they are the same exact
> databases.
>
> -John
>
>
> On 11/29/06, jdpeterman <jdpeterman@netscape.net> wrote:
>>
>> Novice questions here I should know the answer to. What is the
>> difference between the BDB stats and those from Baseball Archive? Are
>> they from the same source? Just curious.
>>
>>
>

It's possible I messed something up during my import of the CSV files into my Access database, but I believe there are two records in the Salary table in which the corresponding playerID does not exist in the Master table.  I've listed the two records from the Salary table below:

 

yearID     teamID     lgID     playerID     salary

2006       FLO        NL       megremi01    327000

2006       TBA        AL       morish01     500000

 

I searched the Master table for the "megremi01" and "morish01" playerID's and could not find them.

 

So my question is, are there two records missing from the Master table, or are these two records in the Salary table not supposed to be there?

 

 

Keith Hemmelman