Archive for category World Cup

Foursquare Checkins for the World Cup

Posted by Laura on Saturday, 12 June, 2010

To anyone who reads this regularly, I apologize in advance.  I may update this information with new posts on a fairly regular basis during the World Cup.   A question I’ve had prior to the World Cup was: Will certain teams have more foursquare checkins than other teams?  This has some interesting side questions that are not available from the data but are interesting to speculate about: Who is checking in to these games?  Are checkins by game reflective of the composition of a nation’s supporters who made the trip? (Or because certain national contingents are more likely to have smart phones that are compatible with South Africa’s mobile network?) Are tech savvy South Africans more likely to show up for certain games involving certain nations?

Only two games have been played so far.  There isn’t much data.  Both groups of fans should have earned swarm badges.  Below are two charts.  The first is the totals by team. The second is my raw data.

Totals and Averages by Team

Totals Total Checkins Total Unique Visitors Average Checkins Average Unique Visitors Grounds
South Africa 335 135 335 135 Soccer City Soccer Stadium
Mexico 335 135 335 135 Soccer City Soccer Stadium
Uruguay 124 54 124 54 Green Point Stadium
France 124 54 124 54 Green Point Stadium

Raw data

Facility Name Type Link Checkins Unique Visitors Mayor Difference Difference Date Team 1 Team 2
Soccer City Soccer City Soccer Stadium Stadium foursquare.com/venue/4410569 67 36 10-Jun-10
Soccer City Soccer City Soccer Stadium Stadium foursquare.com/venue/4410569 402 171 ardyheijnekamp 335 135 11-Jun-10 South Africa Mexico
Cape Town Stadium Green Point Stadium Stadium foursquare.com/venue/4410404 64 31 10-Jun-10
Cape Town Stadium Green Point Stadium Stadium foursquare.com/venue/4410404 188 85 124 54 11-Jun-10 Uruguay France

Related Posts: