MLB ERA and HR Leaders of the Last Decade

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:

Picture_22_medium

I thought two things when I saw the result:

  1. I love Roy Oswalt.
  2. 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):
Picture_23_medium

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.
X
Log In Sign Up

forgot?
Log In Sign Up

Forgot password?

We'll email you a reset link.

If you signed up using a 3rd party account like Facebook or Twitter, please login with it instead.

Forgot password?

Try another email?

Almost done,

Join The Crawfish Boxes

You must be a member of The Crawfish Boxes to participate.

We have our own Community Guidelines at The Crawfish Boxes. You should read them.

Join The Crawfish Boxes

You must be a member of The Crawfish Boxes to participate.

We have our own Community Guidelines at The Crawfish Boxes. You should read them.

Spinner

Authenticating

Great!

Choose an available username to complete sign up.

In order to provide our users with a better overall experience, we ask for more information from Facebook when using it to login so that we can learn more about our audience and provide you with the best possible experience. We do not store specific user data and the sharing of it is not required to login with Facebook.

tracking_pixel_9351_tracker