clock menu more-arrow no yes mobile

Filed under:

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.