MLB ERA and HR Leaders of the Last Decade

by Stephen Higdon on Nov 23, 2008 11:12 AM CST Comment 2 comments

Recently, at MVN's Statistically Speaking (Stat Speak), Colin Wyers, of the Marcels I posted last week, has a series running entitled, "Building a sabermetricans work bench." It basically walks you though how to set up a MySQL structured database full of baseball stats, and it has been a godsend for me.

Having played around with some of his example queries, I wanted to see who has been the best pitcher in the last decade, and being fairly uninitiated in culling out deeper data than the basics, I used ERA, and a minimum average of 150 IP/year:

I thought two things when I saw the result:

I love Roy Oswalt.
How incredible would a 2005 rotation of: Roy Oswalt, Johan Santana (had he not been traded lost in the Rule 5 draft), Roger Clemens, and Andy Pettitte.

I'm sure that number two could have never been in existence, but it's fun to think about.

Then I wanted to see who's leading the way in mashing HR in the new millennium (it's an important question because chicks dig the long ball):

A-Rod is ridiculous and Lance snuck in, beating out Big Pappi by five home runs. This table also made me think: Do I remember when Andruw Jones was good?

Well, that's all I have for you on Sunday morning, but I hope you found it mildly entertaining. Any datamining you'd like to see besides these simple ones? Issue me and challenge and I'll get on it over the Thanksgiving break.

0 recs | Comment 2 comments | Share

Story-email Email Printer Print

Comments

Nice,

but one little thing: Santana was never traded by the Astros. We just left him unprotected and he was taken by the Marlins in the Rule 5 draft.

by Only_A_Lad on Nov 23, 2008 4:19 PM CST reply actions 0 recs

True

Though, in my head that seemed like an appropriate phrasing somehow.

The Crawfishboxes
A good friend of mine used to say, "This is a very simple game. You throw the ball, you catch the ball, you hit the ball. Sometimes you win, sometimes you lose, sometimes it rains." Think about that for a while.

by Stephen Higdon on Nov 23, 2008 8:25 PM CST up reply actions 0 recs

Comments For This Post Are Closed

Search

FanPosts

Community blog posts and discussion.

Recent FanPosts

+ New FanPost All FanPosts >

Current Series

3 game series vs Giants @ Minute Maid Park

San Francisco Giants McCovey Chronicles @ Houston Astros The Crawfish Boxes Monday, Apr 5, 2010, 6:05 PM CDT Minute Maid Park Complete Coverage >
Tue 04/06		7:05 PM CDT
Wed 04/07		1:05 PM CDT

NL Central Standings

	W	L	PCT	GB	STRK

(updated 3.14.2010 at 11:48 PM CDT)

The Crawfish Boxes: An SB Nation Community

Network Bar

The Crawfish Boxes -