The Crawfish Boxes: An SB Nation Community

Navigation: Jump to content areas:



Sports blogs for fans, by fans.
Around SBN: Coyotes Ink Aucoin to One Year Deal


spread the word

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.

0 recs | Comment 2 comments | Share on Facebook Digg!

Story-email Email Printer Print

Comments

Display:

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 reply actions 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 DyingQuail on Nov 23, 2008 8:25 PM CST to parent up reply reply actions actions   0 recs

Comments For This Post Are Closed


User Tools

Welcome to the Crawfishboxes, the SBNation blog for the Houston Astros.
Start posting about the Astros »

Join SB Nation and dive into communities focused on all your favorite teams.

FanPosts

Community blog posts and discussion.

Recent FanPosts

Dsc_0118bee2_small
Astros Play Day Game Against Padres
Astroandyavatar_small
International Free Agent Signings
Houston_texans_small
Am I the only one...
Small
Special thanks goes to
Astroandyavatar_small
Astros Uniforms - Vote your favorite
Johns_small
Lance Berkman
Astroandyavatar_small
Roy Oswalt, Russ Ortiz, and FIP
Small
Where Astros Draftees Are Off To
Small
Fernando Nieve
Small
Lancaster Blues: Astros farm system has depth in the outfield

Post_icon New FanPost All FanPosts Carrot-mini

THE CRAWFISH BOXES GETS SOCIAL

Picture_88_medium The Crawfish Boxes on Facebook

Picture_89_medium The Crawfish Boxes on Twitter

Current Series

3 game series vs Giants @ AT&T Park

Sat 07/04 3:05 PM CDT
Sun 07/05 3:05 PM CDT

NL Central Standings

W L PCT GB STRK
St. Louis 43 38 .530 0 Won 2
Milwaukee 42 38 .525 0.5 Lost 3
Chicago 39 38 .506 2 Won 3
Cincinnati 39 38 .506 2 Won 2
Houston 38 39 .493 3 Won 2
Pittsburgh 36 43 .455 6 Lost 2

(updated 7.3.2009 at 5:19 PM CDT)


Humble Blog Managers

Urbanshocker_small HighLeveragePerformer

Lovelance_small DyingQuail

Editors

Nsapcs13_large_small clack

Fbod6_small farm_stros

Official Partner of Yahoo! Sports