Recently, while working on a project, I needed to find a list of all umpires who worked behind the plate at Boston Red Sox games at Fenway Park during a specific season. Retrosheet has umpire game logs on their site, which show all of the games worked by an umpire during a season. But I needed a list I could filter by team and game location.
I wrote a python script that uses the Retrosheet Event and Box Score Event files to build spreadsheets that include all of the umpire info for each game during one or more seasons. Since the Retrosheet files are organized by decade, the script can process a set of files and produce a single output file in .csv format that can easily be saved in Excel (.xlsx) or other spreadsheet formats.
The script and sample output files are available in GitHub: https://github.com/mhamel12/RetrosheetUmpires