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 |