MLB ERA and HR Leaders of the Last Decade

by DyingQuail 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 |

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 DyingQuail 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 @ AT&T Park

Houston Astros The Crawfish Boxes @ San Francisco Giants McCovey Chronicles Friday, Jul 3, 2009, 9:15 PM CDT AT&T Park Felipe Paulino vs Ryan Sadowski Mostly clear. Game time temperature around 65. Complete Coverage >
Sat 07/04		3:05 PM CDT
Sun 07/05		3:05 PM CDT

NL Central Standings

	W	L	PCT	GB	STRK
St. Louis Viva El Birdos	43	38	.530	0	Won 2
Milwaukee Brew Crew Ball	42	38	.525	0.5	Lost 3
Chicago Bleed Cubbie Blue	39	38	.506	2	Won 3
Cincinnati Red Reporter	39	38	.506	2	Won 2
Houston The Crawfish Boxes	38	39	.493	3	Won 2
Pittsburgh Bucs Dugout	36	43	.455	6	Lost 2

(updated 7.3.2009 at 5:19 PM CDT)

The Crawfish Boxes: An SB Nation Community

Login Bar

Network Bar

The Crawfish Boxes

An Unofficial Houston Astros Blog : In Bobby Heck we trust