Instantly share code, notes, and snippets.

@matt-bernhardt /analysis.R
Last active Mar 5, 2016

Embed
What would you like to do?
Download ZIP
Data and analysis scripts for an article on repeatability of success in Major League Soccer. The published article describing this work has been published at http://www.massivereportdata.com/blog/2016/03/05/revisiting-the-repeatability-of-team-success/
Raw
analysis.R
## Data preparation
# Read in data
data <- read.csv('data.csv')
# Convert Playoffs1 and Playoffs2 to ordered factor
data$Playoffs1 <- factor(data$Playoffs1, levels = c("Did Not Qualify", "Octofinals", "Quarterfinalist", "Semifinalist", "Finalist", "Champion"))
data$Playoffs2 <- factor(data$Playoffs2, levels = c("Did Not Qualify", "Octofinals", "Quarterfinalist", "Semifinalist", "Finalist", "Champion"))
# Add duplicate Year encoding as a factor
data$Year1F <- factor(data$Year1)
data$Year2F <- factor(data$Year2)
## Plot formatting
par(
mfrow=c(1,1), # only one plot per image
new=F, # clear the plot frame before each plot
las=1, # axis labels are always horizontal
pch=21, # graphic marks are circles with separate stroke and fill colors
cex.axis = 0.7, # font size of axis marks
cex.lab = 0.85, # font size of axis labels
cex=1.2 # base font size
)
## Regular Season
# PPG from year to year
plot(data$PPG1, data$PPG2, pch=19, xlim=c(0,3), ylim=c(0,3), xlab="First year Points Per Game", ylab="Following year PPG", main="Year-over-year points per game in MLS")
abline(lm(data$PPG2~data$PPG1))
grid(lty=1,lwd=1,col="#e1e1e6")
par(new=T)
plot(data$PPG1, data$PPG2, pch=19, xlim=c(0,3), ylim=c(0,3), xlab="First year Points Per Game", ylab="Following year PPG", main="Year-over-year points per game in MLS")
text("Matt Bernhardt\n@BernhardtSoccer\nMassiveReportData.com",x=2.98,y=0.05,col="gray",adj=c(1,0))
# Linear model of PPG year to year
model <- lm(data$PPG2 ~ data$PPG1)
summary(model)
# Exploration plots of the linear model (unused in the article)
par(mfrow=c(2,2))
plot(model, pch=19)
par(mfrow=c(1,1))
## Playoffs
# Performance: playoff advancement
plot(data$Playoffs1, main="Playoff advancement over MLS history", xlab="Playoff Result", ylab="Frequency", col=rainbow(6))
# Playoff outcomes from year to year
# TODO: Rotate vertical axis labels to horizontal
plot(data$Playoffs1, data$Playoffs2, xlab="Playoff outcome", ylab="Following year outcome", main="Year-over-year playoff outcomes in MLS", col=rainbow(6))
# Histograms of next-year playoff advancements by year1 advancement
plot(
data$Playoffs2[data$Playoffs1=="Did Not Qualify"],
main="Subsequent playoff performance after missing the playoffs",
ylim=c(0,50),
col=rainbow(6)
)
plot(
data$Playoffs2[data$Playoffs1=="Octofinals"],
main="Subsequent playoff performance after losing in an octofinal / play-in",
ylim=c(0,50),
col=rainbow(6)
)
plot(
data$Playoffs2[data$Playoffs1=="Quarterfinalist"],
main="Subsequent playoff performance after losing in the quarterfinals",
ylim=c(0,50),
col=rainbow(6)
)
plot(
data$Playoffs2[data$Playoffs1=="Semifinalist"],
main="Subsequent playoff performance after losing in the semifinals",
ylim=c(0,50),
col=rainbow(6)
)
plot(
data$Playoffs2[data$Playoffs1=="Finalist"],
main="Subsequent playoff performance after losing in MLS Cup",
ylim=c(0,50),
col=rainbow(6)
)
plot(
data$Playoffs2[data$Playoffs1=="Champion"],
main="Subsequent playoff performance after winning MLS Cup",
ylim=c(0,50),
col=rainbow(6)
)
## Other explorations, not appearing in the article
# Continuing teams each year in MLS
plot(data$Year1F, main="MLS teams that returned the next year", ylab="Number of Teams", xlab="Season")
# Performance: points earned
hist(data$Pts1, main="Histogram of points earned in MLS", xlab="Points earned", ylab="Frequency", col="gray")
# Performance: points per game
hist(data$PPG1, main="Histogram of points per game in MLS", xlab="Points per game", ylab="Frequency", col="gray")
## Fun plots
# Fun plots
# TODO: Colors from team identity, rather than rainbow?
plot(data$Year1F,data$Team,xlab="Seasons",ylab="Teams",col=rainbow(21),main="Teams in Major League Soccer")
# PPG1 to PPG2 scatterplot, colored by year2 playoffs
plot(data$PPG1, data$PPG2, pch=19, xlim=c(0,3), ylim=c(0,3), xlab="Points Per Game", ylab="Following year PPG", main="Year-over-year points per game in MLS", col=data$Playoffs1)
Raw
data.csv
Team Year1 Pts1 GP1 PPG1 Playoffs1 Playoffs1Int Year2 Pts2 GP2 PPG2 Playoffs2 Playoffs2Int
Colorado Rapids 1996 29 32 0.9063 Did Not Qualify 0 1997 38 32 1.1875 Finalist 4
Columbus Crew 1996 37 32 1.1563 Quarterfinalist 2 1997 39 32 1.2188 Semifinalist 3
D.C. United 1996 46 32 1.4375 Champion 5 1997 55 32 1.7188 Champion 5
FC Dallas 1996 41 32 1.2813 Quarterfinalist 2 1997 42 32 1.3125 Semifinalist 3
Los Angeles Galaxy 1996 49 32 1.5313 Finalist 4 1997 44 32 1.375 Quarterfinalist 2
New England Revolution 1996 33 32 1.0313 Did Not Qualify 0 1997 37 32 1.1563 Quarterfinalist 2
New York Red Bulls 1996 39 32 1.2188 Quarterfinalist 2 1997 35 32 1.0938 Did Not Qualify 0
San Jose Earthquakes 1996 39 32 1.2188 Quarterfinalist 2 1997 30 32 0.9375 Did Not Qualify 0
Sporting Kansas City 1996 41 32 1.2813 Semifinalist 3 1997 49 32 1.5313 Quarterfinalist 2
Tampa Bay Mutiny 1996 58 32 1.8125 Semifinalist 3 1997 45 32 1.4063 Quarterfinalist 2
Colorado Rapids 1997 38 32 1.1875 Finalist 4 1998 44 32 1.375 Quarterfinalist 2
Columbus Crew 1997 39 32 1.2188 Semifinalist 3 1998 45 32 1.4063 Semifinalist 3
D.C. United 1997 55 32 1.7188 Champion 5 1998 58 32 1.8125 Finalist 4
FC Dallas 1997 42 32 1.3125 Semifinalist 3 1998 37 32 1.1563 Quarterfinalist 2
Los Angeles Galaxy 1997 44 32 1.375 Quarterfinalist 2 1998 68 32 2.125 Semifinalist 3
New England Revolution 1997 37 32 1.1563 Quarterfinalist 2 1998 29 32 0.9063 Did Not Qualify 0
New York Red Bulls 1997 35 32 1.0938 Did Not Qualify 0 1998 39 32 1.2188 Quarterfinalist 2
San Jose Earthquakes 1997 30 32 0.9375 Did Not Qualify 0 1998 33 32 1.0313 Did Not Qualify 0
Sporting Kansas City 1997 49 32 1.5313 Quarterfinalist 2 1998 32 32 1 Did Not Qualify 0
Tampa Bay Mutiny 1997 45 32 1.4063 Quarterfinalist 2 1998 34 32 1.0625 Did Not Qualify 0
Chicago Fire 1998 56 32 1.75 Champion 5 1999 48 32 1.5 Quarterfinalist 2
Colorado Rapids 1998 44 32 1.375 Quarterfinalist 2 1999 48 32 1.5 Quarterfinalist 2
Columbus Crew 1998 45 32 1.4063 Semifinalist 3 1999 45 32 1.4063 Semifinalist 3
D.C. United 1998 58 32 1.8125 Finalist 4 1999 57 32 1.7813 Champion 5
FC Dallas 1998 37 32 1.1563 Quarterfinalist 2 1999 51 32 1.5938 Semifinalist 3
Los Angeles Galaxy 1998 68 32 2.125 Semifinalist 3 1999 54 32 1.6875 Finalist 4
Miami Fusion 1998 35 32 1.0938 Quarterfinalist 2 1999 29 32 0.9063 Quarterfinalist 2
New England Revolution 1998 29 32 0.9063 Did Not Qualify 0 1999 26 32 0.8125 Did Not Qualify 0
New York Red Bulls 1998 39 32 1.2188 Quarterfinalist 2 1999 15 32 0.4688 Did Not Qualify 0
San Jose Earthquakes 1998 33 32 1.0313 Did Not Qualify 0 1999 37 32 1.1563 Did Not Qualify 0
Sporting Kansas City 1998 32 32 1 Did Not Qualify 0 1999 20 32 0.625 Did Not Qualify 0
Tampa Bay Mutiny 1998 34 32 1.0625 Did Not Qualify 0 1999 32 32 1 Quarterfinalist 2
Chicago Fire 1999 48 32 1.5 Quarterfinalist 2 2000 57 32 1.7813 Finalist 4
Colorado Rapids 1999 48 32 1.5 Quarterfinalist 2 2000 43 32 1.3438 Quarterfinalist 2
Columbus Crew 1999 45 32 1.4063 Semifinalist 3 2000 38 32 1.1875 Did Not Qualify 0
D.C. United 1999 57 32 1.7813 Champion 5 2000 30 32 0.9375 Did Not Qualify 0
FC Dallas 1999 51 32 1.5938 Semifinalist 3 2000 46 32 1.4375 Quarterfinalist 2
Los Angeles Galaxy 1999 54 32 1.6875 Finalist 4 2000 50 32 1.5625 Semifinalist 3
Miami Fusion 1999 29 32 0.9063 Quarterfinalist 2 2000 41 32 1.2813 Did Not Qualify 0
New England Revolution 1999 26 32 0.8125 Did Not Qualify 0 2000 45 32 1.4063 Quarterfinalist 2
New York Red Bulls 1999 15 32 0.4688 Did Not Qualify 0 2000 54 32 1.6875 Semifinalist 3
San Jose Earthquakes 1999 37 32 1.1563 Did Not Qualify 0 2000 29 32 0.9063 Did Not Qualify 0
Sporting Kansas City 1999 20 32 0.625 Did Not Qualify 0 2000 57 32 1.7813 Champion 5
Tampa Bay Mutiny 1999 32 32 1 Quarterfinalist 2 2000 52 32 1.625 Quarterfinalist 2
Chicago Fire 2000 57 32 1.7813 Finalist 4 2001 53 27 1.963 Semifinalist 3
Colorado Rapids 2000 43 32 1.3438 Quarterfinalist 2 2001 23 26 0.8846 Did Not Qualify 0
Columbus Crew 2000 38 32 1.1875 Did Not Qualify 0 2001 45 26 1.7308 Quarterfinalist 2
D.C. United 2000 30 32 0.9375 Did Not Qualify 0 2001 26 26 1 Did Not Qualify 0
FC Dallas 2000 46 32 1.4375 Quarterfinalist 2 2001 35 26 1.3462 Quarterfinalist 2
Los Angeles Galaxy 2000 50 32 1.5625 Semifinalist 3 2001 47 26 1.8077 Finalist 4
Miami Fusion 2000 41 32 1.2813 Did Not Qualify 0 2001 53 26 2.0385 Semifinalist 3
New England Revolution 2000 45 32 1.4063 Quarterfinalist 2 2001 27 27 1 Did Not Qualify 0
New York Red Bulls 2000 54 32 1.6875 Semifinalist 3 2001 42 26 1.6154 Quarterfinalist 2
San Jose Earthquakes 2000 29 32 0.9063 Did Not Qualify 0 2001 45 26 1.7308 Champion 5
Sporting Kansas City 2000 57 32 1.7813 Champion 5 2001 36 27 1.3333 Quarterfinalist 2
Tampa Bay Mutiny 2000 52 32 1.625 Quarterfinalist 2 2001 14 27 0.5185 Did Not Qualify 0
Chicago Fire 2001 53 27 1.963 Semifinalist 3 2002 37 28 1.3214 Quarterfinalist 2
Colorado Rapids 2001 23 26 0.8846 Did Not Qualify 0 2002 43 28 1.5357 Semifinalist 3
Columbus Crew 2001 45 26 1.7308 Quarterfinalist 2 2002 38 28 1.3571 Semifinalist 3
D.C. United 2001 26 26 1 Did Not Qualify 0 2002 32 28 1.1429 Did Not Qualify 0
FC Dallas 2001 35 26 1.3462 Quarterfinalist 2 2002 43 28 1.5357 Quarterfinalist 2
Los Angeles Galaxy 2001 47 26 1.8077 Finalist 4 2002 51 28 1.8214 Champion 5
New England Revolution 2001 27 27 1 Did Not Qualify 0 2002 38 28 1.3571 Finalist 4
New York Red Bulls 2001 42 26 1.6154 Quarterfinalist 2 2002 35 28 1.25 Did Not Qualify 0
San Jose Earthquakes 2001 45 26 1.7308 Champion 5 2002 45 28 1.6071 Quarterfinalist 2
Sporting Kansas City 2001 36 27 1.3333 Quarterfinalist 2 2002 36 28 1.2857 Quarterfinalist 2
Chicago Fire 2002 37 28 1.3214 Quarterfinalist 2 2003 53 30 1.7667 Finalist 4
Colorado Rapids 2002 43 28 1.5357 Semifinalist 3 2003 40 30 1.3333 Quarterfinalist 2
Columbus Crew 2002 38 28 1.3571 Semifinalist 3 2003 38 30 1.2667 Did Not Qualify 0
D.C. United 2002 32 28 1.1429 Did Not Qualify 0 2003 39 30 1.3 Quarterfinalist 2
FC Dallas 2002 43 28 1.5357 Quarterfinalist 2 2003 23 30 0.7667 Did Not Qualify 0
Los Angeles Galaxy 2002 51 28 1.8214 Champion 5 2003 36 30 1.2 Quarterfinalist 2
New England Revolution 2002 38 28 1.3571 Finalist 4 2003 45 30 1.5 Semifinalist 3
New York Red Bulls 2002 35 28 1.25 Did Not Qualify 0 2003 42 30 1.4 Quarterfinalist 2
San Jose Earthquakes 2002 45 28 1.6071 Quarterfinalist 2 2003 51 30 1.7 Champion 5
Sporting Kansas City 2002 36 28 1.2857 Quarterfinalist 2 2003 42 30 1.4 Semifinalist 3
Chicago Fire 2003 53 30 1.7667 Finalist 4 2004 33 30 1.1 Did Not Qualify 0
Colorado Rapids 2003 40 30 1.3333 Quarterfinalist 2 2004 41 30 1.3667 Quarterfinalist 2
Columbus Crew 2003 38 30 1.2667 Did Not Qualify 0 2004 49 30 1.6333 Quarterfinalist 2
D.C. United 2003 39 30 1.3 Quarterfinalist 2 2004 42 30 1.4 Champion 5
FC Dallas 2003 23 30 0.7667 Did Not Qualify 0 2004 36 30 1.2 Did Not Qualify 0
Los Angeles Galaxy 2003 36 30 1.2 Quarterfinalist 2 2004 43 30 1.4333 Semifinalist 3
New England Revolution 2003 45 30 1.5 Semifinalist 3 2004 33 30 1.1 Semifinalist 3
New York Red Bulls 2003 42 30 1.4 Quarterfinalist 2 2004 40 30 1.3333 Quarterfinalist 2
San Jose Earthquakes 2003 51 30 1.7 Champion 5 2004 38 30 1.2667 Quarterfinalist 2
Sporting Kansas City 2003 42 30 1.4 Semifinalist 3 2004 49 30 1.6333 Finalist 4
Chicago Fire 2004 33 30 1.1 Did Not Qualify 0 2005 49 32 1.5313 Semifinalist 3
Colorado Rapids 2004 41 30 1.3667 Quarterfinalist 2 2005 45 32 1.4063 Semifinalist 3
Columbus Crew 2004 49 30 1.6333 Quarterfinalist 2 2005 38 32 1.1875 Did Not Qualify 0
D.C. United 2004 42 30 1.4 Champion 5 2005 54 32 1.6875 Quarterfinalist 2
FC Dallas 2004 36 30 1.2 Did Not Qualify 0 2005 48 32 1.5 Quarterfinalist 2
Los Angeles Galaxy 2004 43 30 1.4333 Semifinalist 3 2005 45 32 1.4063 Champion 5
New England Revolution 2004 33 30 1.1 Semifinalist 3 2005 59 32 1.8438 Finalist 4
New York Red Bulls 2004 40 30 1.3333 Quarterfinalist 2 2005 47 32 1.4688 Quarterfinalist 2
San Jose Earthquakes 2004 38 30 1.2667 Quarterfinalist 2 2005 64 32 2 Quarterfinalist 2
Sporting Kansas City 2004 49 30 1.6333 Finalist 4 2005 45 32 1.4063 Did Not Qualify 0
Chicago Fire 2005 49 32 1.5313 Semifinalist 3 2006 47 32 1.4688 Quarterfinalist 2
Chivas USA 2005 18 32 0.5625 Did Not Qualify 0 2006 43 32 1.3438 Quarterfinalist 2
Colorado Rapids 2005 45 32 1.4063 Semifinalist 3 2006 41 32 1.2813 Semifinalist 3
Columbus Crew 2005 38 32 1.1875 Did Not Qualify 0 2006 33 32 1.0313 Did Not Qualify 0
D.C. United 2005 54 32 1.6875 Quarterfinalist 2 2006 55 32 1.7188 Semifinalist 3
FC Dallas 2005 48 32 1.5 Quarterfinalist 2 2006 52 32 1.625 Quarterfinalist 2
Los Angeles Galaxy 2005 45 32 1.4063 Champion 5 2006 39 32 1.2188 Did Not Qualify 0
New England Revolution 2005 59 32 1.8438 Finalist 4 2006 48 32 1.5 Finalist 4
New York Red Bulls 2005 47 32 1.4688 Quarterfinalist 2 2006 39 32 1.2188 Quarterfinalist 2
Real Salt Lake 2005 20 32 0.625 Did Not Qualify 0 2006 39 32 1.2188 Did Not Qualify 0
Sporting Kansas City 2005 45 32 1.4063 Did Not Qualify 0 2006 38 32 1.1875 Did Not Qualify 0
Chicago Fire 2006 47 32 1.4688 Quarterfinalist 2 2007 40 30 1.3333 Semifinalist 3
Chivas USA 2006 43 32 1.3438 Quarterfinalist 2 2007 53 30 1.7667 Quarterfinalist 2
Colorado Rapids 2006 41 32 1.2813 Semifinalist 3 2007 35 30 1.1667 Did Not Qualify 0
Columbus Crew 2006 33 32 1.0313 Did Not Qualify 0 2007 37 30 1.2333 Did Not Qualify 0
D.C. United 2006 55 32 1.7188 Semifinalist 3 2007 55 30 1.8333 Quarterfinalist 2
FC Dallas 2006 52 32 1.625 Quarterfinalist 2 2007 44 30 1.4667 Quarterfinalist 2
Houston Dynamo 2006 46 32 1.4375 Champion 5 2007 52 30 1.7333 Champion 5
Los Angeles Galaxy 2006 39 32 1.2188 Did Not Qualify 0 2007 34 30 1.1333 Did Not Qualify 0
New England Revolution 2006 48 32 1.5 Finalist 4 2007 50 30 1.6667 Finalist 4
New York Red Bulls 2006 39 32 1.2188 Quarterfinalist 2 2007 43 30 1.4333 Quarterfinalist 2
Real Salt Lake 2006 39 32 1.2188 Did Not Qualify 0 2007 27 30 0.9 Did Not Qualify 0
Sporting Kansas City 2006 38 32 1.1875 Did Not Qualify 0 2007 40 30 1.3333 Semifinalist 3
Chicago Fire 2007 40 30 1.3333 Semifinalist 3 2008 46 30 1.5333 Semifinalist 3
Chivas USA 2007 53 30 1.7667 Quarterfinalist 2 2008 43 30 1.4333 Quarterfinalist 2
Colorado Rapids 2007 35 30 1.1667 Did Not Qualify 0 2008 38 30 1.2667 Did Not Qualify 0
Columbus Crew 2007 37 30 1.2333 Did Not Qualify 0 2008 57 30 1.9 Champion 5
D.C. United 2007 55 30 1.8333 Quarterfinalist 2 2008 37 30 1.2333 Did Not Qualify 0
FC Dallas 2007 44 30 1.4667 Quarterfinalist 2 2008 36 30 1.2 Did Not Qualify 0
Houston Dynamo 2007 52 30 1.7333 Champion 5 2008 51 30 1.7 Quarterfinalist 2
Los Angeles Galaxy 2007 34 30 1.1333 Did Not Qualify 0 2008 33 30 1.1 Did Not Qualify 0
New England Revolution 2007 50 30 1.6667 Finalist 4 2008 43 30 1.4333 Quarterfinalist 2
New York Red Bulls 2007 43 30 1.4333 Quarterfinalist 2 2008 39 30 1.3 Finalist 4
Real Salt Lake 2007 27 30 0.9 Did Not Qualify 0 2008 40 30 1.3333 Semifinalist 3
Sporting Kansas City 2007 40 30 1.3333 Semifinalist 3 2008 42 30 1.4 Quarterfinalist 2
Toronto FC 2007 25 30 0.8333 Did Not Qualify 0 2008 35 30 1.1667 Did Not Qualify 0
Chicago Fire 2008 46 30 1.5333 Semifinalist 3 2009 45 30 1.5 Semifinalist 3
Chivas USA 2008 43 30 1.4333 Quarterfinalist 2 2009 45 30 1.5 Quarterfinalist 2
Colorado Rapids 2008 38 30 1.2667 Did Not Qualify 0 2009 40 30 1.3333 Did Not Qualify 0
Columbus Crew 2008 57 30 1.9 Champion 5 2009 49 30 1.6333 Quarterfinalist 2
D.C. United 2008 37 30 1.2333 Did Not Qualify 0 2009 40 30 1.3333 Did Not Qualify 0
FC Dallas 2008 36 30 1.2 Did Not Qualify 0 2009 39 30 1.3 Did Not Qualify 0
Houston Dynamo 2008 51 30 1.7 Quarterfinalist 2 2009 48 30 1.6 Semifinalist 3
Los Angeles Galaxy 2008 33 30 1.1 Did Not Qualify 0 2009 48 30 1.6 Finalist 4
New England Revolution 2008 43 30 1.4333 Quarterfinalist 2 2009 42 30 1.4 Quarterfinalist 2
New York Red Bulls 2008 39 30 1.3 Finalist 4 2009 21 30 0.7 Did Not Qualify 0
Real Salt Lake 2008 40 30 1.3333 Semifinalist 3 2009 40 30 1.3333 Champion 5
San Jose Earthquakes 2008 33 30 1.1 Did Not Qualify 0 2009 30 30 1 Did Not Qualify 0
Sporting Kansas City 2008 42 30 1.4 Quarterfinalist 2 2009 33 30 1.1 Did Not Qualify 0
Toronto FC 2008 35 30 1.1667 Did Not Qualify 0 2009 39 30 1.3 Did Not Qualify 0
Chicago Fire 2009 45 30 1.5 Semifinalist 3 2010 36 30 1.2 Did Not Qualify 0
Chivas USA 2009 45 30 1.5 Quarterfinalist 2 2010 28 30 0.9333 Did Not Qualify 0
Colorado Rapids 2009 40 30 1.3333 Did Not Qualify 0 2010 46 30 1.5333 Champion 5
Columbus Crew 2009 49 30 1.6333 Quarterfinalist 2 2010 50 30 1.6667 Quarterfinalist 2
D.C. United 2009 40 30 1.3333 Did Not Qualify 0 2010 22 30 0.7333 Did Not Qualify 0
FC Dallas 2009 39 30 1.3 Did Not Qualify 0 2010 50 30 1.6667 Finalist 4
Houston Dynamo 2009 48 30 1.6 Semifinalist 3 2010 33 30 1.1 Did Not Qualify 0
Los Angeles Galaxy 2009 48 30 1.6 Finalist 4 2010 59 30 1.9667 Semifinalist 3
New England Revolution 2009 42 30 1.4 Quarterfinalist 2 2010 32 30 1.0667 Did Not Qualify 0
New York Red Bulls 2009 21 30 0.7 Did Not Qualify 0 2010 51 30 1.7 Quarterfinalist 2
Real Salt Lake 2009 40 30 1.3333 Champion 5 2010 56 30 1.8667 Quarterfinalist 2
San Jose Earthquakes 2009 30 30 1 Did Not Qualify 0 2010 46 30 1.5333 Semifinalist 3
Seattle Sounders 2009 47 30 1.5667 Quarterfinalist 2 2010 48 30 1.6 Quarterfinalist 2
Sporting Kansas City 2009 33 30 1.1 Did Not Qualify 0 2010 39 30 1.3 Did Not Qualify 0
Toronto FC 2009 39 30 1.3 Did Not Qualify 0 2010 35 30 1.1667 Did Not Qualify 0
Chicago Fire 2010 36 30 1.2 Did Not Qualify 0 2011 43 34 1.2647 Did Not Qualify 0
Chivas USA 2010 28 30 0.9333 Did Not Qualify 0 2011 36 34 1.0588 Did Not Qualify 0
Colorado Rapids 2010 46 30 1.5333 Champion 5 2011 49 34 1.4412 Quarterfinalist 2
Columbus Crew 2010 50 30 1.6667 Quarterfinalist 2 2011 47 34 1.3824 Octofinals 1
D.C. United 2010 22 30 0.7333 Did Not Qualify 0 2011 39 34 1.1471 Did Not Qualify 0
FC Dallas 2010 50 30 1.6667 Finalist 4 2011 52 34 1.5294 Octofinals 1
Houston Dynamo 2010 33 30 1.1 Did Not Qualify 0 2011 49 34 1.4412 Finalist 4
Los Angeles Galaxy 2010 59 30 1.9667 Semifinalist 3 2011 67 34 1.9706 Champion 5
New England Revolution 2010 32 30 1.0667 Did Not Qualify 0 2011 28 34 0.8235 Did Not Qualify 0
New York Red Bulls 2010 51 30 1.7 Quarterfinalist 2 2011 46 34 1.3529 Quarterfinalist 2
Philadelphia Union 2010 31 30 1.0333 Did Not Qualify 0 2011 48 34 1.4118 Quarterfinalist 2
Real Salt Lake 2010 56 30 1.8667 Quarterfinalist 2 2011 53 34 1.5588 Semifinalist 3
San Jose Earthquakes 2010 46 30 1.5333 Semifinalist 3 2011 38 34 1.1176 Did Not Qualify 0
Seattle Sounders 2010 48 30 1.6 Quarterfinalist 2 2011 63 34 1.8529 Quarterfinalist 2
Sporting Kansas City 2010 39 30 1.3 Did Not Qualify 0 2011 51 34 1.5 Semifinalist 3
Toronto FC 2010 35 30 1.1667 Did Not Qualify 0 2011 33 34 0.9706 Did Not Qualify 0
Chicago Fire 2011 43 34 1.2647 Did Not Qualify 0 2012 57 34 1.6765 Octofinals 1
Chivas USA 2011 36 34 1.0588 Did Not Qualify 0 2012 30 34 0.8824 Did Not Qualify 0
Colorado Rapids 2011 49 34 1.4412 Quarterfinalist 2 2012 37 34 1.0882 Did Not Qualify 0
Columbus Crew 2011 47 34 1.3824 Octofinals 1 2012 52 34 1.5294 Did Not Qualify 0
D.C. United 2011 39 34 1.1471 Did Not Qualify 0 2012 58 34 1.7059 Semifinalist 3
FC Dallas 2011 52 34 1.5294 Octofinals 1 2012 39 34 1.1471 Did Not Qualify 0
Houston Dynamo 2011 49 34 1.4412 Finalist 4 2012 53 34 1.5588 Finalist 4
Los Angeles Galaxy 2011 67 34 1.9706 Champion 5 2012 54 34 1.5882 Champion 5
New England Revolution 2011 28 34 0.8235 Did Not Qualify 0 2012 35 34 1.0294 Did Not Qualify 0
New York Red Bulls 2011 46 34 1.3529 Quarterfinalist 2 2012 57 34 1.6765 Quarterfinalist 2
Philadelphia Union 2011 48 34 1.4118 Quarterfinalist 2 2012 36 34 1.0588 Did Not Qualify 0
Portland Timbers 2011 42 34 1.2353 Did Not Qualify 0 2012 34 34 1 Did Not Qualify 0
Real Salt Lake 2011 53 34 1.5588 Semifinalist 3 2012 57 34 1.6765 Quarterfinalist 2
San Jose Earthquakes 2011 38 34 1.1176 Did Not Qualify 0 2012 66 34 1.9412 Quarterfinalist 2
Seattle Sounders 2011 63 34 1.8529 Quarterfinalist 2 2012 56 34 1.6471 Semifinalist 3
Sporting Kansas City 2011 51 34 1.5 Semifinalist 3 2012 63 34 1.8529 Quarterfinalist 2
Toronto FC 2011 33 34 0.9706 Did Not Qualify 0 2012 23 34 0.6765 Did Not Qualify 0
Vancouver Whitecaps 2011 28 34 0.8235 Did Not Qualify 0 2012 43 34 1.2647 Octofinals 1
Chicago Fire 2012 57 34 1.6765 Octofinals 1 2013 49 34 1.4412 Did Not Qualify 0
Chivas USA 2012 30 34 0.8824 Did Not Qualify 0 2013 26 34 0.7647 Did Not Qualify 0
Colorado Rapids 2012 37 34 1.0882 Did Not Qualify 0 2013 51 34 1.5 Octofinals 1
Columbus Crew 2012 52 34 1.5294 Did Not Qualify 0 2013 41 34 1.2059 Did Not Qualify 0
D.C. United 2012 58 34 1.7059 Semifinalist 3 2013 16 34 0.4706 Did Not Qualify 0
FC Dallas 2012 39 34 1.1471 Did Not Qualify 0 2013 44 34 1.2941 Did Not Qualify 0
Houston Dynamo 2012 53 34 1.5588 Finalist 4 2013 51 34 1.5 Semifinalist 3
Los Angeles Galaxy 2012 54 34 1.5882 Champion 5 2013 53 34 1.5588 Quarterfinalist 2
Montreal Impact 2012 42 34 1.2353 Did Not Qualify 0 2013 49 34 1.4412 Octofinals 1
New England Revolution 2012 35 34 1.0294 Did Not Qualify 0 2013 51 34 1.5 Quarterfinalist 2
New York Red Bulls 2012 57 34 1.6765 Quarterfinalist 2 2013 59 34 1.7353 Quarterfinalist 2
Philadelphia Union 2012 36 34 1.0588 Did Not Qualify 0 2013 46 34 1.3529 Did Not Qualify 0
Portland Timbers 2012 34 34 1 Did Not Qualify 0 2013 57 34 1.6765 Semifinalist 3
Real Salt Lake 2012 57 34 1.6765 Quarterfinalist 2 2013 56 34 1.6471 Finalist 4
San Jose Earthquakes 2012 66 34 1.9412 Quarterfinalist 2 2013 51 34 1.5 Did Not Qualify 0
Seattle Sounders 2012 56 34 1.6471 Semifinalist 3 2013 52 34 1.5294 Quarterfinalist 2
Sporting Kansas City 2012 63 34 1.8529 Quarterfinalist 2 2013 58 34 1.7059 Champion 5
Toronto FC 2012 23 34 0.6765 Did Not Qualify 0 2013 29 34 0.8529 Did Not Qualify 0
Vancouver Whitecaps 2012 43 34 1.2647 Octofinals 1 2013 48 34 1.4118 Did Not Qualify 0
Chicago Fire 2013 49 34 1.4412 Did Not Qualify 0 2014 36 34 1.0588 Did Not Qualify 0
Chivas USA 2013 26 34 0.7647 Did Not Qualify 0 2014 33 34 0.9706 Did Not Qualify 0
Colorado Rapids 2013 51 34 1.5 Octofinals 1 2014 32 34 0.9412 Did Not Qualify 0
Columbus Crew 2013 41 34 1.2059 Did Not Qualify 0 2014 52 34 1.5294 Quarterfinalist 2
D.C. United 2013 16 34 0.4706 Did Not Qualify 0 2014 59 34 1.7353 Quarterfinalist 2
FC Dallas 2013 44 34 1.2941 Did Not Qualify 0 2014 54 34 1.5882 Quarterfinalist 2
Houston Dynamo 2013 51 34 1.5 Semifinalist 3 2014 39 34 1.1471 Did Not Qualify 0
Los Angeles Galaxy 2013 53 34 1.5588 Quarterfinalist 2 2014 61 34 1.7941 Champion 5
Montreal Impact 2013 49 34 1.4412 Octofinals 1 2014 28 34 0.8235 Did Not Qualify 0
New England Revolution 2013 51 34 1.5 Quarterfinalist 2 2014 55 34 1.6176 Finalist 4
New York Red Bulls 2013 59 34 1.7353 Quarterfinalist 2 2014 50 34 1.4706 Semifinalist 3
Philadelphia Union 2013 46 34 1.3529 Did Not Qualify 0 2014 42 34 1.2353 Did Not Qualify 0
Portland Timbers 2013 57 34 1.6765 Semifinalist 3 2014 49 34 1.4412 Did Not Qualify 0
Real Salt Lake 2013 56 34 1.6471 Finalist 4 2014 56 34 1.6471 Quarterfinalist 2
San Jose Earthquakes 2013 51 34 1.5 Did Not Qualify 0 2014 30 34 0.8824 Did Not Qualify 0
Seattle Sounders 2013 52 34 1.5294 Quarterfinalist 2 2014 64 34 1.8824 Semifinalist 3
Sporting Kansas City 2013 58 34 1.7059 Champion 5 2014 49 34 1.4412 Octofinals 1
Toronto FC 2013 29 34 0.8529 Did Not Qualify 0 2014 41 34 1.2059 Did Not Qualify 0
Vancouver Whitecaps 2013 48 34 1.4118 Did Not Qualify 0 2014 50 34 1.4706 Octofinals 1
Chicago Fire 2014 36 34 1.0588 Did Not Qualify 0 2015 30 34 0.8824 Did Not Qualify 0
Colorado Rapids 2014 32 34 0.9412 Did Not Qualify 0 2015 37 34 1.0882 Did Not Qualify 0
Columbus Crew 2014 52 34 1.5294 Quarterfinalist 2 2015 53 34 1.5588 Finalist 4
D.C. United 2014 59 34 1.7353 Quarterfinalist 2 2015 51 34 1.5 Quarterfinalist 2
FC Dallas 2014 54 34 1.5882 Quarterfinalist 2 2015 60 34 1.7647 Semifinalist 3
Houston Dynamo 2014 39 34 1.1471 Did Not Qualify 0 2015 42 34 1.2353 Did Not Qualify 0
Los Angeles Galaxy 2014 61 34 1.7941 Champion 5 2015 51 34 1.5 Octofinals 1
Montreal Impact 2014 28 34 0.8235 Did Not Qualify 0 2015 51 34 1.5 Quarterfinalist 2
New England Revolution 2014 55 34 1.6176 Finalist 4 2015 50 34 1.4706 Octofinals 1
New York Red Bulls 2014 50 34 1.4706 Semifinalist 3 2015 60 34 1.7647 Semifinalist 3
Philadelphia Union 2014 42 34 1.2353 Did Not Qualify 0 2015 37 34 1.0882 Did Not Qualify 0
Portland Timbers 2014 49 34 1.4412 Did Not Qualify 0 2015 53 34 1.5588 Champion 5
Real Salt Lake 2014 56 34 1.6471 Quarterfinalist 2 2015 41 34 1.2059 Did Not Qualify 0
San Jose Earthquakes 2014 30 34 0.8824 Did Not Qualify 0 2015 47 34 1.3824 Did Not Qualify 0
Seattle Sounders 2014 64 34 1.8824 Semifinalist 3 2015 51 34 1.5 Quarterfinalist 2
Sporting Kansas City 2014 49 34 1.4412 Octofinals 1 2015 51 34 1.5 Octofinals 1
Toronto FC 2014 41 34 1.2059 Did Not Qualify 0 2015 49 34 1.4412 Octofinals 1
Vancouver Whitecaps 2014 50 34 1.4706 Octofinals 1 2015 53 34 1.5588 Quarterfinalist 2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment