Tweets from Denver and New England Fanbases During the AFC Championship Game

I thought it would be cool to use Jeff Gentry’s twitteR package during the NFL AFC Championship Game to scrape geo and keyword specific tweets.

I scraped tweets every 10 minutes starting on January 17th until January 21st. I scraped for the keyword “Broncos” in the Denver, CO area and in a 150-mile radius around the city. I did the same thing for “Patriots” but limited to tweets within a 150-mile radius of Boston, MA. This was a poor mistake on my part though – I completely missed all tweets that just said “Pats”, which is definitely a more common way of referencing the team in New England. A few other things to consider are the populations in both cities, which are fortunately very similar (~600k each). However, since I covered a 150-mile radius around each city, this covers a lot of western Massachusetts and even into Albany as well as the Atlantic ocean. Overall, I ended up with about 80,000 tweets but I did get rate-limited a few times so there are some gaps. If you’re interested in seeing the code – I’ve created a gist.


boston

On the Denver side, a good portion of the Rocky Mountains was included, so hopefully it washes out on both sides. Of course I did a disservice to my fellow Pats fans by leaving out the “Pats” keyword, but I’ll know for the next time.


denver

A few take-aways from the Tableau dashboard below:

  • Broncos fans out-tweeted Patriots fans – keep in mind I left out the “Pats” keyword and both cities were surrounded by a 150-mile radius so if there are drastic population differences I would have needed to normalize these numbers.
  • I ran a naive sentiment analysis on each fan-base and plotted the sentiment over time during the game. It’s clear to see the Broncos fan-base sentiment on the uptick towards the end and the Patriots fans sentiment decreasing. I followed Jeffrey Breen’s approach here for sentiment analysis on Twitter to gauge customer attitudes towards airlines
  • The top tweeters for each team were PatriotsLine for the Pats and BroncosBaby07 for the Broncos.
  • The word cloud shows each fan bases most tweeted words indicated by size and color indicates team. I found it amusing that us poor Patriots fans were mentioning the Bruins and the Stanley Cup whereas you can clearly see Broncos fans mentioning the Super Bowl

  • Chin up Patriots fans – they had an amazing season despite over 20% of their salary cap being on the IR for the season. The fact that they still made it to the AFC Championship with all of those starters injured is nothing short of amazing. And here’s a gif for you to watch in case you get sad about all those times Brady was left hanging:


    Comments (0)

    Join the discussion, leave a reply!