Interesting Perfect Or Near-Perfect Games

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.

Read the rest of this entry »


Have We Been Seeing Fewer Extra Inning Games?

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?

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

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.

Read the rest of this entry »

How to Put Retrosheet on Your Windows Computer…For Dummies

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.

Read the rest of this entry »