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.
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.
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.
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.
This is something I’ve been interested in, so I decided to look it up. The data come from retrosheet.
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.
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.