This post will introduce the relevant minor leagues used in my data model. A somewhat complete listing of leagues for 2013 can be found here at baseball-reference. There are quite a few leagues. This blog will focus only on AAA, AA, Adv-A, and some A leagues. AAA is the most advanced, then AA, then Adv-A, and finally A. AAA has a Mexican league which won’t be analyzed yet because that league has no MLB affiliates. We want to be able to get a look into various affiliate’s farm systems and not become overwhelmed.
First let’s introduce the leagues and their teams. The following tables use the format of this data model. These tables will provide an idea as to what affiliate’s belong to which league and you can get an idea as to how good that team is with respect to batting (1st column) and pitching (2nd column). This can provide a glimpse into what kind of players each MLB team is farming from a macro perspective. I’ll get into more detailed explanation of these tables in a future posting. All results in these tables are from the 2013 season.
First let’s look at AAA. There are two relevant leagues with affiliates in AAA; Pacific Coast League (pcl) and International League (int). There are 16 teams in pcl and 14 teams in int accounting for all 30 MLB teams. Affiliates will be using the 3 letter franchise key used throughout this site.
Pacific Coast League
In the next post I’ll list AA and Adv-A and then a detailed explaination of some columns used in these tables. The main purpose of these first few posts is to introduce the minor leagues I’ll be covering, their teams, and MLB affiliations.