The History of English Football Champions: 1888-2018

Last week I saw this really cool viz from Squawka Football on Twitter and wanted to see if I could rebuild it.

1889 ➡️ 2̶0̶1̶8̶ 2019

Watch the race to become the most successful club in English top-flight history unfold before you. Now updated. pic.twitter.com/4IprWQ16ZT

— Squawka Football (@Squawka) May 13, 2019

Given that this requires animation, I knew I needed a tool that supported this and I turned to Flourish. The data has to be structured in a very specific way, so I downloaded the data from Wikipedia, imported it into Alteryx for a bit of a massage, and spit it back out in the format Flourish required.

And voila! An animated viz of the history of English football champions from 1888-2018. Very little effort required + great animation = win!