Data Development: the Spreadsheet

-
As I move toward the start of the writing process in roughly one week for the spring issue (Vol. 15, No. 1) of the American Association Almanac, I'm wrapping up the work on the eight principal databases I've been constructing since the end of November. They concern the leading triples hitters for each team of the original American Association from 1902 to 1962. Each spreadsheet is designed to make automatic calculations for the percentages I'm most interested easier to perform. My intention in posting this blog was to post an example of one whole file. At this point I'm not sure I'll be able to do that, however, I will offer a sample at the very least. Each spreadsheet covers the career record for each team's top triple hitters. This could include those who led over time or who was among the team's top three producers during a given season. No less than 110 players are listed in any one team's spreadsheet. The totals for each player are derived and sorted so each category can be ranked for the leading players. What is especially valuable is the data for multi-team players; a multi-team player, also known as a split-season player, spent his time with more than one team. In this record the data has been gleaned from the box scores in order to produce the record for just the team he's listed with as being a leading producer. The time it takes to perform such an exercise can be excessive; while at other times it can take only an hour or two. Regardless, the records for the American Association's leading triples hitters has never been published. It serves the baseball research community as a testament to thorough and creative research while offering fans of regional baseball history a fundamental look a the leading players from a bygone era.

Sample 1: The Indianapolis Indians, page 1

 

While this blogsite does not permit me to publish whole files, anyone who is interested in obtaining a copy of a particular data file can write me with their request. Send an email to
pureout@msn.com
with your request. Thank you!

Comments

Post a Comment

Popular posts from this blog

Ballparks of Indianapolis, Part 2: Perry Stadium/Victory Field

-
Image
The American Association Almanac Volume 20, Number 1 Spring 2024 Perry Stadium/Victory Field and the Indianapolis Indians      The Spring 2024 edition of the American Association Almanac (print journal, just published) describes Perry Stadium (later Victory Field), the home of the Indianapolis Indians, in replete detail. The publication consists of roughly 28,000 words, comprising a 64-page booklet format with a color cover, and centerfold which includes home performance data for both the 1932 and 1948 Indianapolis Indians. It is set in 11-pt. Times New Roman and was completed March 26, 2024.      The long-time home of the Indians was built in 1931 by Norman A. Perry in homage to his brother, James Perry , who was killed in an airplane accident just outside Indianapolis in 1929. In the spring of 2023 the Almanac published Part 1 of this two-part series (please see separate blog entry). In 1942 the park was renamed Victory Field just a month after Perry sold the Indians which occurre
Read more

The First All-Star Game

-
Image
Eighty years ago this week the American Association put its first cadre of All-Stars on display. The event took place July 19, 1934 at hitter-friendly Nicollet Park in Minneapolis. Interesting how this anniversary corresponds with MLB's 2014 All-Star game to be played tomorrow night at Target Field in Minneapolis, just a few miles due north of where Nicollet Park once stood. The Millers defeated the All-Stars, 13-6. The 1934 American Association All-Star Team The contest pitted the American Association All-Stars against the Minneapolis Millers, the club which was in first-place on the pre-selected date. In the photo above are (with position played during game): BACK ROW:   GEORGE HOCKETTE (lhp), ALLAN SOTHORON (mgr), EARL WEBB (rf), MEL ALMADA (lf-cf), LIN STORTI (2b), ERNIE WINGARD (1b), FRED BEDORE (3b), and JACK KLOZA (lf). FRONT ROW:   TONY RENSA (c), GENE TROW (rhp), MILT GALATZER (cf), BILL BRENZEL (c), JOSE OLIVARES (ss), GARLAND BRAXTON (lhp), and AL NIEMIC (ss). Tha
Read more

Contact the American Association Almanac

-
Image
If you wish to contact the American Association Almanac for answers to questions or comments you might have, please email me at pureout@msn.com There is no advertising accepted in the American Association Almanac. To subscribe to the American Association Almanac, you have a few different options. Option 1: Subscribe for one year. You get three issues, Spring, Summer and Fall. The cost is $18.00. Option 2: Subscribe for two years. You get six issues. Cost is $32.00. Option 3: Become a Lifetime Subscriber. Ten years guaranteed. Cost: $150.00. Option 4: Become a Benefactor of the Almanac. Minimum donation: $200.00. Monies donated to the American Association Almanac are used to further the cause of researching the information used in this publication. Starting with the Spring issue of 2008, all benefactors will have their name published in each subsequent issue. Back issues are available on a per unit basis or as a complete set. Please contact me for details.
Read more