Interesting Perfect Or Near-Perfect Games
Posted: May 22, 2011 Filed under: Research, Retrosheet Leave a comment »I had a little extra time on my hands and decided to use my Retrosheet database to find some interesting near perfect or actually perfect games.
Perfect Games:
August 6th, 1967 – Minnesota Twins – 2, Boston Red Sox – 0
Pitcher: Dean Chance
Dean Chance pitched five perfect innings, but the game was called due to rain. Since it was past five innings, this still counts as an official game.
April 21, 1984 – Montreal Expos – 4, St. Louis Cardinals – 0
Pitcher: David Palmer
David Palmer and the Montreal Expos were in the same situation here. The perfect game was called due to rain after five innings.
Have We Been Seeing Fewer Extra Inning Games?
Posted: May 20, 2011 Filed under: Research, Retrosheet Leave a comment »Yesterday, I found how long extra inning games last. Today, I’m going to look at how often extra inning games are played. Since the data go back to 1950 when less games were played, I simply divided the total number of extra inning games by the total number of games played that year. I also added in a 5-year moving average trend line.
Click the picture to make it readable.
From 1950-1996, extra inning games accounted for an average of 9.69% of all games per year. Since then, the average per year is 8.34%. It’s odd that this all begins in the wild card era, but I don’t see any reason for a correlation between the two.
When Do Extra Inning Games End?
Posted: May 19, 2011 Filed under: Research, Retrosheet 1 Comment »This is something I’ve been interested in, so I decided to look it up. The data come from retrosheet.
Click the picture to make it readable.
Retrosheet MySQL Queries
Posted: May 16, 2011 Filed under: Retrosheet 3 Comments »Here are a few Retrosheet queries I have found helpful. You can download Retrosheet using the steps outlined here. These queries assume you followed those exact steps. If your columns are named something different, you’ll have to change that part of the code a bit. All of this was done by trial and error, so there may be a better way to do the code.
How to Put Retrosheet on Your Windows Computer…For Dummies
Posted: May 16, 2011 Filed under: Retrosheet Leave a comment »I have never taken a database class and have no idea what I’m doing as far as programming goes. So naturally, I decided to figure out how to put retrosheet on my computer and learn how to manipulate it. What could go wrong? These are the steps I would have taken If I knew what to do in the first place. If they don’t work for you, I probably can’t help. These steps are for Windows. I will hopefully do one for Mac as well, although the “Saberizing a Mac” series at Beyond the Boxscore has a lot of help there.
