Posts Tagged Uruguay

World Cup, day 3: Foursquare checkin totals

Posted by Laura on Monday, 14 June, 2010

It is day three and the trend appears to be fewer Foursquare checkins. It is interesting to speculate why. The six teams at the bottom of the checkin ladder all played in games with one European side. Two of those matches were against African sides and one was against Asian side. Those six teams failed to earn their supporters a swarm badge. Is Foursquare less popular in Europe than it is in English speaking countries? Do football fans from those countries use other geolocation sites? Let me know.

Ladder Table

Country Total Checkins Total Unique Visitors Average Checkins Average Unique Visitors Grounds
Mexico 335 135 335 135 Soccer City Soccer Stadium
South Africa 335 135 335 135 Soccer City Soccer Stadium
Argentina 203 74 203 74 Ellis Park Stadium
Nigeria 203 74 203 74 Ellis Park Stadium
England 136 55 136 55 Royal Bafokeng Stadium
USA 136 55 136 55 Royal Bafokeng Stadium
France 124 54 124 54 Green Point Stadium
Uruguay 124 54 124 54 Green Point Stadium
Australia 59 27 59 27 Moses Mabhida Stadium
Germany 59 27 59 27 Moses Mabhida Stadium
Ghana 35 17 35 17 Loftus Versfeld Stadium
Serbia 35 17 35 17 Loftus Versfeld Stadium
Greece 30 17 30 17 Nelson Mandela Bay Stadium
South Korea 30 17 30 17 Nelson Mandela Bay Stadium
Algeria 18 4 18 4 Peter Mokaba Stadium
Slovenia 18 4 18 4 Peter Mokaba Stadium

Data Table

Facility Name Type Link Checkins Unique Visitors Mayor Difference Difference Date Team 1 Team 2
Soccer City Soccer City Soccer Stadium Stadium http://foursquare.com/venue/4410569 67 36 10-Jun-10
Soccer City Soccer City Soccer Stadium Stadium http://foursquare.com/venue/4410569 402 171 ardyheijnekamp 335 135 11-Jun-10 South Africa Mexico
Cape Town Stadium Green Point Stadium Stadium http://foursquare.com/venue/4410404 64 31 10-Jun-10
Cape Town Stadium Green Point Stadium Stadium http://foursquare.com/venue/4410404 188 85 124 54 11-Jun-10 Uruguay France
Nelson Mandela Bay Stadium Nelson Mandela Stadium Stadium http://foursquare.com/venue/4410289 19 11 11-Jun-10
Nelson Mandela Bay Stadium Nelson Mandela Stadium Stadium http://foursquare.com/venue/4410289 49 28 30 17 12-Jun-10 Greece South Korea
Ellis Park Stadium Coca-Cola Park (Ellis Park Stadium) Stadium http://foursquare.com/venue/278284 40 19 -1159291 11-Jun-10
Ellis Park Stadium Ellis Park Stadium (Coca-Cola Park) Stadium http://foursquare.com/venue/4410611 243 93 -1159291 203 74 12-Jun-10 Argentina Nigeria
Royal Bafokeng Stadium Royal Bafokeng Stadium Soccer http://foursquare.com/venue/3949992 18 9 -511308 11-Jun-10
Royal Bafokeng Stadium royal bafokeng stadium http://foursquare.com/venue/4668670 0 0 11-Jun-10
Royal Bafokeng Stadium Royal Bafokeng Stadium Soccer http://foursquare.com/venue/3949992 151 61 -511308 133 52 12-Jun-10 USA England
Royal Bafokeng Stadium royal bafokeng stadium http://foursquare.com/venue/4668670 3 3 3 3 12-Jun-10 USA England
Peter Mokaba Stadium Peter Mokaba Stadium Soccer http://foursquare.com/venue/3949867 12 5 rickycatto 12-Jun-10
Peter Mokaba Stadium Peter Mokaba Stadium Soccer http://foursquare.com/venue/3949867 30 9 rickycatto 18 4 13-Jun-10 Algeria Slovenia
Loftus Versfeld Stadium Loftus Versveld Stadium Stadium http://foursquare.com/venue/593221 31 21 -522247 12-Jun-10
Loftus Versfeld Stadium Loftus Versveld Stadium Stadium http://foursquare.com/venue/593221 66 38 -522247 35 17 13-Jun-10 Serbia Ghana
Moses Mabhida Stadium Moses Mabhida Stadium Durban http://foursquare.com/venue/4570899 1 1 12-Jun-10
Moses Mabhida Stadium Moses Mabhida Stadium Durban http://foursquare.com/venue/4570899 9 7 aussiegoldy 8 6 13-Jun-10 Australia Germany
Moses Mabhida Stadium Moses Mabhida Stadium Stadium http://foursquare.com/venue/4408569 24 17 12-Jun-10
Moses Mabhida Stadium Moses Mabhida Stadium Stadium http://foursquare.com/venue/4408569 75 38 51 21 13-Jun-10 Australia Germany
Moses Mabhida Stadium KEG – Moses Mabhida Stadium Pub http://foursquare.com/venue/1816495 3 3 12-Jun-10
Moses Mabhida Stadium KEG – Moses Mabhida Stadium Pub http://foursquare.com/venue/1816495 3 3 0 0 13-Jun-10 Australia Germany

Related Posts:

World Cup, day 2: Foursquare checkin totals

Posted by Laura on Sunday, 13 June, 2010

With a few more teams having played, checkin patterns may be emerging. Only one game hasn’t gotten a swarm badge. The game involved an Asian team and a less popular European team. English language speaking countries doesn’t seem to be a factor for checkins at this point as the Nigeria vs. Argentina game was second.  I’ve also tacked on Gowalla data to the end of this post as there isn’t much there to really supply another post: People are just not using it at any volume similar to that of Foursquare.

Onwards with the data set…

Rankings Table

Country Total Checkins Total Unique Visitors Average Checkins Average Unique Visitors Grounds
Mexico 335 135 335 135 Soccer City Soccer Stadium
South Africa 335 135 335 135 Soccer City Soccer Stadium
Argentina 203 74 203 74 Ellis Park Stadium
Nigeria 203 74 203 74 Ellis Park Stadium
England 136 55 136 55 Royal Bafokeng Stadium
USA 136 55 136 55 Royal Bafokeng Stadium
France 124 54 124 54 Green Point Stadium
Uruguay 124 54 124 54 Green Point Stadium
Greece 30 17 30 17 Nelson Mandela Bay Stadium
South Korea 30 17 30 17 Nelson Mandela Bay 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 http://foursquare.com/venue/4410569 67 36 10-Jun-10
Soccer City Soccer City Soccer Stadium Stadium http://foursquare.com/venue/4410569 402 171 ardyheijnekamp 335 135 11-Jun-10 South Africa Mexico
Cape Town Stadium Green Point Stadium Stadium http://foursquare.com/venue/4410404 64 31 10-Jun-10
Cape Town Stadium Green Point Stadium Stadium http://foursquare.com/venue/4410404 188 85 124 54 11-Jun-10 Uruguay France
Nelson Mandela Bay Stadium Nelson Mandela Stadium Stadium http://foursquare.com/venue/4410289 19 11 11-Jun-10
Nelson Mandela Bay Stadium Nelson Mandela Stadium Stadium http://foursquare.com/venue/4410289 49 28 30 17 12-Jun-10 Greece South Korea
Ellis Park Stadium Coca-Cola Park (Ellis Park Stadium) Stadium http://foursquare.com/venue/278284 40 19 -1159291 11-Jun-10
Ellis Park Stadium Ellis Park Stadium (Coca-Cola Park) Stadium http://foursquare.com/venue/4410611 243 93 -1159291 203 74 12-Jun-10 Argentina Nigeria
Royal Bafokeng Stadium Royal Bafokeng Stadium Soccer http://foursquare.com/venue/3949992 18 9 -511308 11-Jun-10
Royal Bafokeng Stadium royal bafokeng stadium http://foursquare.com/venue/4668670 0 0 11-Jun-10
Royal Bafokeng Stadium Royal Bafokeng Stadium Soccer http://foursquare.com/venue/3949992 151 61 -511308 133 52 12-Jun-10 USA England
Royal Bafokeng Stadium royal bafokeng stadium http://foursquare.com/venue/4668670 3 3 3 3 12-Jun-10 USA England

Gowalla

Team Total Checkins Average Checkins Grounds URL
England 3 3 Royal Bafokeng Stadium http://gowalla.com/spots/1062400
USA 3 3 Royal Bafokeng Stadium http://gowalla.com/spots/1062400
Argentina 2 2 Coca-Cola Park (Ellis Park Stadium) http://gowalla.com/spots/960110
France 2 2 Green Point Stadium http://gowalla.com/spots/127362
Mexico 2 2 Soccer City Soccer Stadium http://gowalla.com/spots/653944
Nigeria 2 2 Coca-Cola Park (Ellis Park Stadium) http://gowalla.com/spots/960110
South Africa 2 2 Soccer City Soccer Stadium http://gowalla.com/spots/653944
Uruguay 2 2 Green Point Stadium http://gowalla.com/spots/127362
Greece 0 0 Nelson Mandela Bay Stadium http://gowalla.com/spots/750428
South Korea 0 0 Nelson Mandela Bay Stadium http://gowalla.com/spots/750428

Related Posts:

Gowalla World Cup Checkins

Posted by Laura on Saturday, 12 June, 2010

This post is similar to the Foursquare Checkins for the World Cup in terms of content and purpose.  The only real difference is that it looks at a different service.  Gowalla is popular with a number of people in the US and elsewhere because it allows users to upload pictures to the location page and allows friends to easily comment in reply to people who are at that location.  It just doesn’t have as many total users as Foursquare. I thought it would be interesting to track the differences in checkins on Gowalla as they appear to cater to a different type of user than Foursquare.  This leads to a question of if and how the checkin patterns between the services will differ?  (They do appear to after the first set of games as the total checkins are the same.)  Gowalla is different than Foursquare in that you can retrospectively go in and get by date data so long as you get it in the past 30 days.  Foursquare requires manually getting this information every day. Also worth noting, it looks like Gowalla also updated their World Cup venues to merge duplicate locations. This was done some time between June 7 and June 12, 2010. As a researcher, I find this less problematic than Foursquare because of how Gowalla shows its checkins. Either way, as I can see by date checkins, it doesn’t effect historical checkins.

Below are the tables for total checkins and raw data.

Total and Average Checkins

Totals Total Checkins Average Checkins Grounds
South Africa 2 2 Soccer City Soccer Stadium
Mexico 2 2 Soccer City Soccer Stadium
Uruguay 2 2 Green Point Stadium
France 2 2 Green Point Stadium

Raw Data

Facility Name Link Date checked Checkins Date Team 1 Team 2
Soccer City Soccer City gowalla.com/spots/653944 12-Jun-10 2 11-Jun-10 South Africa Mexico
Cape Town Stadium Cape Town Stadium gowalla.com/spots/127362 12-Jun-10 2 11-Jun-10 Uruguay France

Related Posts:

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: