The Crawfish Boxes: An SB Nation Community

Navigation: Jump to content areas:


Pro Quality. Fan Perspective.
Login-facebook
Around SBN: College Football Preseason Top 25 Rankings

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.

0 recs  |  Comment 6 comments |

Story-email Email Printer Print

Around SB Nation

Atlanta Braves Postseason Pace

Sep 2010 from Talking Chop - 40 comments

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 timmy_ 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 timmy_ 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.
Start posting about the Astros »

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

Connect_with_facebook

FanPosts

Community blog posts and discussion.

Recent FanPosts

Astrobritrs2_small
Only one side of the coin?
Small
Barret Loux
Colevatar_small
Thank You, Astros Fans
Small
Astros Payroll
Small
Bored at work: Minor Questions for the Board
Small
Is the rebuilding over?
Adsc_0111pick_off_try_small
Yankees place Lance Berkman on 15 day DL
Colevatar_small
Question for Astros fans
Astrobritrs2_small
Is it Naive to Think Your Guy Didn't Juice?
Johns_small
MMP Appreciation

+ New FanPost All FanPosts >

TCB Tweets!

  

Current Series

NL Central Standings

W L PCT GB STRK
Cincinnati 78 55 .586 0 Won 4
St. Louis 69 62 .526 8 Lost 5
Houston 62 71 .466 16 Won 3
Milwaukee 62 71 .466 16 Lost 3
Chicago 57 77 .425 21.5 Won 1
Pittsburgh 44 89 .330 34 Lost 1

(updated 9.2.2010 at 9:47 AM CDT)

SBNation.com Recent Stories

ATLANTA - APRIL 22:  Omar Infante #4 of the Atlanta Braves celebrates after scoring against the Philiadelphia Phillies at Turner Field on April 22, 2010 in Atlanta, Georgia.  (Photo by Kevin C. Cox/Getty Images)

Albert Pujols, Joey Votto, And The Triple Crown Villains Who Plot Their Ruin

Washington Nationals' Nyjer Morgan, center, is led off the field after a brawl during the sixth inning of a baseball game against the Florida Marlins, Wednesday, Sept. 1, 2010, in Miami. (AP Photo/Wilfredo Lee) +4 updates

Nats, Marlins Brawl After Nyjer Morgan Charges Mound

Photo

Aroldis Chapman Touches 104, Earns First Win As Reds Rally Past Brewers

More from SBNation.com >


Humble Blog Managers

Godzillaemptyfridge_small Evan Hochschild

Lovelance_small Stephen Higdon

Old_school_dome_logo_small David Coleman

Editors

Nsapcs13_large_small clack

H_astros_small Subber10

Astros2_small timmy_

Astros_logo121009_small OremLK

Profphoto_small allphilla