MLB ERA and HR Leaders of the Last Decade

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

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.

Tweet Comment 2 comments | 0 recs |

Do you like this story?

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

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

Comments For This Post Are Closed

Current Series

3 game series vs Rockies @ Minute Maid Park

Colorado Rockies Purple Row @ Houston Astros The Crawfish Boxes Friday, Apr 6, 2012, 6:05 PM CDT Minute Maid Park Complete Coverage >
Sat 04/07		6:05 PM CDT
Sun 04/08		1:05 PM CDT

NL Central Standings

	PCT	STRK
Chicago Bleed Cubbie Blue	.000	Lost 0
Cincinnati Red Reporter	.000	Lost 0
Houston The Crawfish Boxes	.000	Lost 0
Milwaukee Brew Crew Ball	.000	Lost 0
Pittsburgh Bucs Dugout	.000	Lost 0
St. Louis Viva El Birdos	.000	Lost 0