Navigation: Jump to content areas:


Pro Quality. Fan Perspective.
Login-facebook
Around SBN: Josh Hamilton Reportedly Seen Drinking In Dallas Bar

Astros to the DL: A cool new tool

I've officially wasted a big chunk of my afternoon playing with this new Injury Database. Download it if you want, give it a spin and see what you can find.  I loaded in first and last names, plus team affiliations and was able to do some Astros-related work. As the article explains, this data only goes back to 2002, but there's still good stuff in there. What did I find?

  • 79 different Houston players have spent time on the DL since 2002, totaling 3,403 days of missed time.There were a total of 198,625 missed days in MLB over that time, averaging out to 6,620.3 days per team. Who knew the Astros have been that lucky with injuries the past seven years?
  • Strains were by far the most common type of injury with 1,120 trips to the DL. There were also over 100 each of Soreness, Fractures, Sprains, Tears, Tendinitis, Inflammation and Surgery. Shoulder injuries were by far the most common, showing up 758 times, followed by Elbow, Knee and Hand injuries. Least common? Head, followed by Upper Back, Chest and Face.
  • For the Astros? There have been 14 shoulder injuries, just edging out the 12 elbow injuries as the most injured body part. Other injury groups above five were Groin (8), Abdomen (5), Thigh (5) and Lower Back (5). No Astros hurt their Head, Foot, Ankle, Upper Back or Chest during this timeframe.
  • Injuries were more common on the right side of the body than the left, 1657 to 1068. The Astros ratio was 33 to 28, which is not as pronounced, but still favors the right.
  • 2009 featured the most Houston DL trips of any season in the grouping with 22. Only two other seasons saw double-figure trips as the Astros sent 10 to the DL in 2007 and 11 in 2002. During the World Series year of 2005? Just four DL trips, including 127 days from Jeff Bagwell, 32 from Lance Berkman, 41 from Brandon Backe and 28 from Humberto Quintero. No wonder that team didn't have much offense!
  • The player who's been on the DL the most since 2002? Roy Oswalt with six trips. He has spent a combined 132 days on the DL over that time. Oswalt had three different stints on the DL in 2003 and missed 82 days that season due to a strained then pulled groin. He's been on the DL four times with strains, one with a muscle pull and once with pain in his back.
  • Other players in the top five were Brandon Backe (5 trips), Kazuo Matsui (4), Humberto Quintero (3), Andy Pettite (3) and Doug Brocail (3). Some of the Astro names I had forgotten (Tom Gordon! Hipolito Pichardo!) and others just made me sad (Wade Miller...). The Astro with the most total DL time was easily Backe, who had 394 missed days. Brian Moehler clocks in with 186 while Adam Everett missed 149 days. Wade Miller and Aaron Boone also had over 140 missed days. Surprisingly, Jason Jennings missed 93 total days. I really thought he had been more dependable than that.
  • The major league leader in days missed is Chad Fox with 841. Chris Snelling comes in second with 813 while Mike Hampton has 688 and Chris Carpenter has 666. The rest of the top ten are all names you'd recognize (Mark Prior, Troy Percival, Carl Pavano, Jason Schmidt) with a couple that you might not have thought of (Dmitri Young? Rusty Greer?). Notable trade target this offseason Rafael Soriano has spent 505 days on the DL but was just edged out by free agent pickup Nick Johnson (515) for the player changing teams this offseason with the biggest injury history.

That's all I've got, people. Dive in yourself if you'd like. It certainly proved a good diversion for me.

Comment 6 comments  |  0 recs  | 

Do you like this story?

Comments

Display:

The ’stros medical staff is pretty well-regarded.

by AstroAndy on Feb 17, 2010 10:40 PM CST reply actions  

Well we do have the Texas Medical Center and Baylor School of Medicine so I think there is some doctor talent in the area.

Miss-placed Houstonian living and going to school in the wilderness of Wyoming. Fresno St. 28 - Wyoming 35 (2 OT)!!! Hands down best game I have ever been to.

by BigNate7 on Feb 19, 2010 10:26 AM CST up reply actions  

The reason for injuries being more common on the right side than the left side is possibly due to the fact that generally their are more right handed players than left handed player (those who throw right and bat left or vice versa being the exception). I don’t think you were tying to get at anything, but I’d find it interesting to look at the rate of injuries for left handed vs right handed players and seeing which had the higher percentage.

by Timothy De Block on Feb 18, 2010 7:21 AM CST reply actions  

What program do I need to be using to open this database? I’m currently using excel but I have a suspicion that’s not correct.

by Timothy De Block on Feb 18, 2010 7:30 AM CST up reply actions  

There are two inside the zip file. The first is just code for a SQL dump but the second should be an excel file. That’s the one I used to import into Access.

by David Coleman on Feb 18, 2010 8:33 AM CST up reply actions  

Yeah, was just an observation, not trying go deeper. It does make sense that there are more righties, and the lack of the same pronounced split with Houston is probably due to a small sample size not evening out the gap.

by David Coleman on Feb 18, 2010 8:35 AM CST up reply actions  

Comments For This Post Are Closed


User Tools

Welcome to the Crawfishboxes, the SBNation blog for the Houston Astros.

FanPosts

Community blog posts and discussion.

Recent FanPosts

Imagescawdx4zz_small
I think Luhnow is Going for IT
Small
Russ Canzler?
Small
Cuban Import?
Htown_small
As much as a name change is upsetting.....could this be a chance to go back to our roots?
Htown_small
A name change just alienates the fan base further
Imagescawdx4zz_small
Should we Trade Carlos Lee
Small
Angel Sanchez designated
Img00034-20090811-1430_small
Crane mulling new name and uniform
Logotexans-1-1-1_small
APBA Baseball League
Small
2012 Astros Prospects Preview

+ New FanPost All FanPosts >

TCB Tweets!

    

Current Series

3 game series vs Rockies @ Minute Maid Park

Sat 04/07 6:05 PM CDT
Sun 04/08 1:05 PM CDT

NL Central Standings

W L PCT GB STRK
Chicago 0 0 .000 0 Lost 0
Cincinnati 0 0 .000 0 Lost 0
Houston 0 0 .000 0 Lost 0
Milwaukee 0 0 .000 0 Lost 0
Pittsburgh 0 0 .000 0 Lost 0
St. Louis 0 0 .000 0 Lost 0

(updated 2.3.2012 at 11:55 PM CST)


Managing Editors

Tcb_icon_small Timothy De Block

Old_school_dome_logo_small David Coleman

Editors

Nsapcs13_large_small clack

H_astros_small Subber10

Astrobritrs2_small AstroB

Small conroestro

Small native_astro

Small CRPerry13

Authors

Astros_logo121009_small OremLK

This-is-my-boom-stick_small allphilla

Th_houston-astros-logo-3_small Will Bonn