Oil Spill vs. Arizona II: Location Analysis of Tweets
The Arizona Immigration Law and the Gulf Oil Spill have been among the biggest news stories this month. We’re tracking tweets on an ongoing basis for both stories.
We had a suggestion to map these Tweets by location (thanks to @hornOKplease!). Because the stories have a regional focus and national attention, it seemed like the perfect analysis. We took a sample of ~5,000 tweets for each story and used our handy location normalization feature to gather city, state, county and latitude longitude for the tweets. Take a look at these cool charts…
Tweets are mapped by latitude and longitude. Each point on the map represents at least 1 Tweet.Â The size of the bubble reflects the number of Tweets from each location from our sample.Â In Both Charts, the purple shaded background overlay provides population by county. The darker shading reflects higher populations.
- Both stories appeared to reflect the regional focus. The Arizona story had greater volume in the Southwest, and border states. The Gulf Oil Spill discussions had a clear concentration in Gulf states such as Louisiana, Mississippi, and Florida.
- The Gulf Oil Spill seems to have garnered broader national attention than the Arizona immigration story. The Arizona activity is more heavily concentrated in large cities. The Oil Spill also had high volume in major cities, but appeared to have moreÂ distributedÂ activity in smaller markets relatively speaking.
- Major media centers seems to consistently drive high volume. When it comes to news, Los Angeles and New York may be the center of the Twitterverse rather than San Francisco.
How to Run Your Own Tweet Mapping Analysis:
We used RowFeeder Enterprise to capture the Twitter data in Excel. We had the location normalization feature turned on. The mapping is done by running the RowFeeder Excel output into Tableau. Just a couple clicks in Tableau and the maps are done!
Adam is the Co-Founder and VP of Strategy at Simply Measured. In 2010 (aka the dark ages of social marketing), Adam joined Damon Cortesi and Aviel Ginzburg to found "Untitled Startup, Inc" with the goal of helping marketers and analysts use social data to do their best work. The company quickly evolved to become Simply Measured and the trusted leader in social analytics. Outside of Simply Measured, Adam is a golfer, breakfast enthusiast, and long-time data geek.