Ozzie Sport

Yay! It is over. This is the final total. Rankings changed through out the tournament. For the two sites, there were audiences I’d like to call distinct. The data when examined in total suggests that different fan communities inside a wider community of football fans use geolocation services differently. As previously mentioned, this may be useful for people involved with the Rugby World Cup in 2011. I should also see about getting some of my AFL and NRL data out… but that’s not as on point.

The winner of the World Cup was not the winner for average checkins per game they played. English speaking countries didn’t dominate at the top of the ladder. You didn’t need to be a team who made it through more than the first round to crack the leaderboard’s top 10, though it certainly helped. The home team didn’t necessarily hold a major advantage.

Foursquare

Gowalla

Related Posts:

• World Cup, through quarter finals: Foursquare and gowalla checkin totals
• World Cup, end of the second round: Foursquare and gowalla checkin totals
• World Cup, end of the first round: Foursquare and gowalla checkin totals
• World Cup, day 8: Foursquare and gowalla checkin totals

The World Cup is done.  Based on averages, there do appear to be trends for usage around different teams.  I don’t have any other large international competition which to compare this two but it might be of interest to others who are organizing such events like the women’s World Cup for soccer and the Rugby World Cup.  Some national contingents will be the same and if we assume that these patterns hold across nationalities… it might give national sides, companies and organizers using geolocation services an idea which one is better for their audience and which games to target.  This is especially true if we assume that Foursquare and Gowalla users are representative of active social media users period who will use other services to discuss the event.

Related to the results: For the Germany vs. Spain game,between getting data before the event and after the event, Foursquare merged two locations.  If I had just used the one, it would have possibly included an additional 43 checks for the game that were from previous games.  Thus, I subtracted the previous venue’s totals from the venue that they were merged into.

Onwards with the results…

Foursquare

Gowalla

Related Posts:

• World Cup, end of the second round: Foursquare and gowalla checkin totals
• World Cup, end of the first round: Foursquare and gowalla checkin totals
• World Cup, day 8: Foursquare and gowalla checkin totals
• World Cup, day 7: Gowalla checkin totals

That Ghana versus Uruguay: Wow. Wow.  Also, wow!  It was a major win for Foursquare as the game smashed the record for total checkins set by South Africa for the first game with 676 checkins compared to 335.  The game booted South Africa and Mexico from the top of the Foursquare table.  Sadly, it didn’t do this so much for Brazil and the Netherlands.   Gowalla sadly didn’t see the same Foursquare response.  There just doesn’t seem to be the same audience and there isn’t the same level of deviation of for national sides and between rounds.3.8 average checkin for the top team on Gowalla and 0 for the team on the bottom.  Foursquare has 179 on top and 17.3 on bottom.

There appears to be something going on with Foursquare.  I’ve included at the bottom a table which demonstrates what I’m talking about.  It looks like for four venues Foursquare removed a number of checkins or a large number of people deleted their own checkins.  I’m not certain what exactly happened as I can’t see who checked in and what games were effected.  It is annoying.  (And I don’t know who else is covering Foursquare and the World Cup to see if they’ve noticed these issues.)

Foursquare

Gowalla

Foursquare Checkin Losses

Related Posts:

• World Cup, end of the second round: Foursquare and gowalla checkin totals
• World Cup, end of the first round: Foursquare and gowalla checkin totals
• World Cup, day 8: Foursquare and gowalla checkin totals
• World Cup, day 7: Gowalla checkin totals

The second round came to an end and the third round is about to start.  My initial thinking was that as the tournament went on, you’d see more checkins at games.  My assumptions were that ticket prices would go up for later rounds, leading to a more affluent, social media connected audience attending these game.  I also assumed that the stadiums would be at capacity, where early first round games would not be. My assumption was South Africa would have the highest average checkins for all team, because of the home country advantage.  I also figured most of the teams left in would be big name team, which would have a wider audience than their own national base. I also thought that Foursquare would always beat Gowalla by a lot. I don’t quite know what I based these assumption on; it just felt like what I thought obvious patterns should be.

Some of these assumptions appeared to be a bit true.  Some of them not.  Appearing in the second round did not mean that a team climbed the ladder of total checkins.  Witness Japan, Paraguay, South Korea, Slovakia, Brazil and Germany who are averaging less than 50 checkins a game on Foursquare at the end of round 2.  Some of these are popular teams and they are all team who played in the second round.  Chile, Brazil, South Korea all appeared in the bottom 16 teams on Gowalla at the end of the second round.  South Africa wasn’t anywhere close to the top on Gowalla.  It should probably hold on to the top spot on Foursquare.  (Mexico has passed it though for total checkins.)  Patterns that I thought would emerge haven’t.

Anyway, on with the data…

Foursquare

Gowalla

Related Posts:

• World Cup, end of the first round: Foursquare and gowalla checkin totals
• World Cup, day 8: Foursquare and gowalla checkin totals
• World Cup, day 7: Gowalla checkin totals
• World Cup, day 7: Foursquare checkin totals

One of the challenges of social media metrics is identifying what numbers matter, how to get those numbers ,  how to organize that data in a way that facilitates quickly getting the data and making it useful, and making sure your data set is complete.  The latter can be problematic as people can always create new communities, groups, hashtags, accounts, etc. If you don’t organize your data in a useful way and regularly update it, you can create such a huge mess as to make your data almost unusable.

This is a problem I’ve run into with my AFL and NRL Foursquare data.  When I first started gathering this data in late April, I spent a day or two looking for all the venues.  Slightly problematic issue arose in that not all venues had been created.  I never went back to regularly check to see if these venues had been created.  What this means is that my NRL data has several huge holes in it, because venues don’t exist or the venue that does exist was not the more popular of the ones created.

Another problem was the data was not collected in a way that I found entirely logical when I revisited it to try to create a table to show the average number of checkins at home and away matches for the NRL.  (I wanted to do the NRL first, before I tackled the AFL because I’m focusing on the AFL and trial and erroring on the NRL seemed wiser.)  I gathered the total checkins and unique visitors every Thursday through Monday night for all venues that played NRL and AFL games that I had identified.  In hindsight, this wasn’t the best way to go about this.  I should have identified everything by games being played as it would have made processing the data much, much easier and I wouldn’t have as much “garbage” data that I have to wade through.  I’ve spent most of the morning correcting this mistake by identifying games and venue locations so I can more easily and efficiently track total checkins for AFL games and some NRL games.  (Later, I can try to do this when the A-League, W-League and NBL start up.)

Looking through existing Foursquare data though, I really don’t know if I will want to process it.  I’d almost rather go through the last quarter of the season, where I know I have a complete data set than try to piece together the data dating back to late April.  I probably won’t do that but I’ll likely have to figure out what to do.  It isn’t pretty and I’m really kicking myself for what could have been a lot of time wasted each data gathering data that I can’t use.

My gowalla data faces similar issues.  The big difference there is I’ve always known I haven’t had a complete data set and it was through processing World Cup data on Gowalla that I realized my collection issues with Foursquare data collection.  I’d love to use Gowalla for AFL/NRL analysis but it isn’t going to happen.  I mean, it really isn’t going to happen, especially as Foursquare is the bigger priority as it has greater penetration in Australia and I never had a complete venue list for Gowalla.

Related Posts:

• An interview with Ben Pollack from the Canberra Raiders
• Notes on AFL/NRL foursquare sporting venues in Australia
• Most popular Australian (and New Zealand) sport related Twitter accounts (November 24)
• More popular Australian (and Kiwi) sport related Facebook fanpages and groups (November 23)

The first round has ended and we’ve now a fair amount of data for Foursquare and Gowalla. This can be used to try to figure out which fans were most likely to checkin. The top of the table surprised me a bit with who was there and who wasn’t there. The bottom of the table was also a bit surprising. I rather thought that there would be fewer English speaking countries near the bottom and that the Asian and African sides would be over represented. That doesn’t appear to be the case.

Foursquare

Gowalla

Related Posts:

• World Cup, day 8: Foursquare and gowalla checkin totals
• World Cup, day 7: Gowalla checkin totals
• World Cup, day 7: Foursquare checkin totals
• World Cup, day 6: Foursquare checkin totals

On Foursquare, there were changes near the top and near the bottom of the ladder.  Yesterday featured one swarm badge, which was the same as the day before and the day before that. It will be interesting to see how teams progress into the second and third games. After the first round, will totals probably matter more than averages? What audience is seeing second round games?

Foursquare

Gowalla
Gowalla doesn’t have the checkin strength of Foursquare. A big game on it doesn’t even get to the low count for foursquare and a lot of games have 0s. The ladder is also pretty much completely different.

How different are these two tables? Teams were ranked based on total average checkins. The difference was then calculated and 12 teams had positions that differed by 10 or more places with only two teams sharing the same position.

Related Posts:

• World Cup, day 7: Foursquare checkin totals
• World Cup, day 6: Foursquare checkin totals
• World Cup, day 7: Gowalla checkin totals
• World Cup, day 5: Foursquare checkin totals

Gowalla is the other major geolocation checkin site. I haven’t looked at it since the first day of the World Cup. I need to be a bit more proactive in checking it and updating but the total checkin volume is just so much lower that it is hard to see it as a contender during the cup. (Though, to be fair, Foursquare is falling and when the checkin rate has a difference of 18, that’s not many people.)

I’ve completed a table comparing the total and average checkins on Gowalla for all World Cup games to date. The rankings are rather different than for that of the Foursquare. I’d love speculation as to why.

Related Posts:

• World Cup, day 8: Foursquare and gowalla checkin totals
• World Cup, day 7: Foursquare checkin totals
• World Cup, day 6: Foursquare checkin totals
• World Cup, day 5: Foursquare checkin totals

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

Raw Data

Gowalla

Related Posts:

• World Cup, day 8: Foursquare and gowalla checkin totals
• World Cup, day 7: Foursquare checkin totals
• World Cup, day 6: Foursquare checkin totals
• World Cup, day 3: Foursquare checkin totals

This post was broken up into multiple posts because there was a lot of rows. It should hopefully be easier to find data/information this way.

ecademy
ecademy is an alternative to LinkedIn.

Facebook
This first set is based on www.facebook.com/ads/create/.

This table was designed to look at growth of Socceroos related fan pages.

League	Team	Name	Url	Total members	Type	Date checked	Included in FB2	Official
World Cup Soccer	Socceroos	Socceroos – Australian National Football Team	https://www.facebook.com/Socceroos	32	741	Page	15-May-10	No	Yes
World Cup Soccer	Socceroos	Socceroos	https://www.facebook.com/pages/Socceroos/106019049438817	3	Page	15-May-10	No	No
World Cup Soccer	Socceroos	Socceroos	https://www.facebook.com/pages/Socceroos/112443855448354	4	Page	15-May-10	No	No
World Cup Soccer	Socceroos	Socceroos	https://www.facebook.com/pages/Socceroos/108710262493191	0	Page	15-May-10	No	No
World Cup Soccer	Socceroos	Socceroos	https://www.facebook.com/pages/Socceroos/119664741377244	0	Page	15-May-10	No	No
World Cup Soccer	Socceroos	SOCCEROOS	https://www.facebook.com/pages/SOCCEROOS-/126051170744978	41	Page	15-May-10	No	No
World Cup Soccer	Socceroos	Socceroos	https://www.facebook.com/pages/Socceroos/106353142733985	185	Page	15-May-10	No	No
World Cup Soccer	Socceroos	Young Socceroos	https://www.facebook.com/pages/Young-Socceroos/115695218444154	0	Page	15-May-10	No	No
World Cup Soccer	Socceroos	socceroos fan? get on it!!!!!	https://www.facebook.com/pages/socceroos-fan-get-on-it/118141831550071	3	Page	15-May-10	No	No
World Cup Soccer	Socceroos	Australian University Socceroos	https://www.facebook.com/pages/Australian-University-Socceroos/279400107713	197	Page	15-May-10	No	No
World Cup Soccer	Socceroos	Cheering for the Socceroos at the local club in the World Cup	https://www.facebook.com/pages/Cheering-for-the-Socceroos-at-the-local-club-in-the-World-Cup/406886935323	86	Page	15-May-10	No	No
World Cup Soccer	Socceroos	The Football Supporters’ Pledge: A-League	Socceroos & Grassroots	https://www.facebook.com/pages/The-Football-Supporters-Pledge-A-League-Socceroos-Grassroots/114421618592491	3	Page	15-May-10	No	No
World Cup Soccer	Socceroos	Langerak is a God	and will be in the Socceroos one day p.s hes HOT	https://www.facebook.com/pages/Langerak-is-a-God-and-will-be-in-the-Socceroos-one-day-ps-hes-HOT/103909322982210	82	Page	15-May-10	No	No
World Cup Soccer	Socceroos	100	000 Strong Socceroos Supporters To Win 2010 World Cup	https://www.facebook.com/pages/100000-Strong-Socceroos-Supporters-To-Win-2010-World-Cup/362147231671	188	Page	15-May-10	No	No
World Cup Soccer	Socceroos	Change the name of the Socceroos	https://www.facebook.com/pages/Brisbane-Australia/Change-the-name-of-the-Socceroos/206601790281	12	Page	15-May-10	No	No
World Cup Soccer	Socceroos	Brett Holman shouldn’t play for the Socceroos	https://www.facebook.com/pages/Brett-Holman-shouldnt-play-for-the-Socceroos/155289433083	84	Page	15-May-10	No	No
World Cup Soccer	Socceroos	kickoff.com.au: A-League	Socceroos	Australian and International football	https://www.facebook.com/pages/kickoffcomau-A-League-Socceroos-Australian-and-International-football/238919388600	113	Page	15-May-10	No	No
World Cup Soccer	Socceroos	Support for the Socceroos in South Africa	https://www.facebook.com/pages/Support-for-the-Socceroos-in-South-Africa/118426448190124	3	Page	15-May-10	No	No
World Cup Soccer	Socceroos	Petition for Israel to come play the Socceroos	https://www.facebook.com/pages/Petition-for-Israel-to-come-play-the-Socceroos/124315894249250	20	Page	15-May-10	No	No
World Cup Soccer	Socceroos	Socceroos to dominate in 2010	https://www.facebook.com/pages/Socceroos-to-dominate-in-2010/125877250762609	140	Page	15-May-10	No	No
World Cup Soccer	Socceroos	Socceroos – Australian National Football Team	https://www.facebook.com/Socceroos	51	640	Page	28-May-10	No	Yes
World Cup Soccer	Socceroos	Socceroos – Australian National Football Team	https://www.facebook.com/Socceroos	59	215	Page	30-May-10	No	Yes
World Cup Soccer	Socceroos	Socceroos	https://www.facebook.com/pages/Socceroos/106019049438817	14	Page	30-May-10	No	No
World Cup Soccer	Socceroos	Socceroos	https://www.facebook.com/pages/Socceroos/112443855448354	29	Page	30-May-10	No	No
World Cup Soccer	Socceroos	Socceroos	https://www.facebook.com/pages/Socceroos/108710262493191	11	Page	30-May-10	No	No
World Cup Soccer	Socceroos	Socceroos	https://www.facebook.com/pages/Socceroos/119664741377244	2	Page	30-May-10	No	No
World Cup Soccer	Socceroos	SOCCEROOS	https://www.facebook.com/pages/SOCCEROOS-/126051170744978	98	Page	30-May-10	No	No
World Cup Soccer	Socceroos	Socceroos	https://www.facebook.com/pages/Socceroos/106353142733985	293	Page	30-May-10	No	No
World Cup Soccer	Socceroos	Young Socceroos	https://www.facebook.com/pages/Young-Socceroos/115695218444154	1	Page	30-May-10	No	No
World Cup Soccer	Socceroos	socceroos fan? get on it!!!!!	https://www.facebook.com/pages/socceroos-fan-get-on-it/118141831550071	8	Page	30-May-10	No	No
World Cup Soccer	Socceroos	Australian University Socceroos	https://www.facebook.com/pages/Australian-University-Socceroos/279400107713	203	Page	30-May-10	No	No
World Cup Soccer	Socceroos	Cheering for the Socceroos at the local club in the World Cup	https://www.facebook.com/pages/Cheering-for-the-Socceroos-at-the-local-club-in-the-World-Cup/406886935323	93	Page	30-May-10	No	No
World Cup Soccer	Socceroos	The Football Supporters’ Pledge: A-League	Socceroos & Grassroots	https://www.facebook.com/pages/The-Football-Supporters-Pledge-A-League-Socceroos-Grassroots/114421618592491	4	Page	30-May-10	No	No
World Cup Soccer	Socceroos	Langerak is a God	and will be in the Socceroos one day p.s hes HOT	https://www.facebook.com/pages/Langerak-is-a-God-and-will-be-in-the-Socceroos-one-day-ps-hes-HOT/103909322982210	83	Page	30-May-10	No	No
World Cup Soccer	Socceroos	100	000 Strong Socceroos Supporters To Win 2010 World Cup	https://www.facebook.com/pages/100000-Strong-Socceroos-Supporters-To-Win-2010-World-Cup/362147231671	246	Page	30-May-10	No	No
World Cup Soccer	Socceroos	Change the name of the Socceroos	https://www.facebook.com/pages/Brisbane-Australia/Change-the-name-of-the-Socceroos/206601790281	12	Page	30-May-10	No	No
World Cup Soccer	Socceroos	Brett Holman shouldn’t play for the Socceroos	https://www.facebook.com/pages/Brett-Holman-shouldnt-play-for-the-Socceroos/155289433083	107	Page	30-May-10	No	No
World Cup Soccer	Socceroos	kickoff.com.au: A-League	Socceroos	Australian and International football	https://www.facebook.com/pages/kickoffcomau-A-League-Socceroos-Australian-and-International-football/238919388600	117	Page	30-May-10	No	No
World Cup Soccer	Socceroos	Support for the Socceroos in South Africa	https://www.facebook.com/pages/Support-for-the-Socceroos-in-South-Africa/118426448190124	9	Page	30-May-10	No	No
World Cup Soccer	Socceroos	Petition for Israel to come play the Socceroos	https://www.facebook.com/pages/Petition-for-Israel-to-come-play-the-Socceroos/124315894249250	24	Page	30-May-10	No	No
World Cup Soccer	Socceroos	Socceroos to dominate in 2010	https://www.facebook.com/pages/Socceroos-to-dominate-in-2010/125877250762609	291	Page	30-May-10	No	No
World Cup Soccer	Socceroos	Socceroos – Australian National Football Team	https://www.facebook.com/Socceroos	64	956	Page	1-Jun-10	No	Yes
World Cup Soccer	Socceroos	Socceroos – Australian National Football Team	https://www.facebook.com/Socceroos	70	261	Page	5-Jun-10	No	Yes
World Cup Soccer	Socceroos	Socceroos – Australian National Football Team	https://www.facebook.com/Socceroos	71	286	Page	7-Jun-10	No	Yes
World Cup Soccer	Socceroos	Socceroos – Australian National Football Team	https://www.facebook.com/Socceroos	73	463	Page	10-Jun-10	No	Yes
World Cup Soccer	Socceroos	Socceroos to dominate in 2010	https://www.facebook.com/pages/Socceroos-to-dominate-in-2010/125877250762609	330	Page	10-Jun-10	No	No
World Cup Soccer	Socceroos	Socceroos	https://www.facebook.com/pages/Socceroos/106019049438817	31	Page	10-Jun-10	No	No
World Cup Soccer	Socceroos	Socceroos	https://www.facebook.com/pages/Socceroos/112443855448354	48	Page	10-Jun-10	No	No
World Cup Soccer	Socceroos	Socceroos	https://www.facebook.com/pages/Socceroos/108710262493191	52	Page	10-Jun-10	No	No
World Cup Soccer	Socceroos	Socceroos	https://www.facebook.com/pages/Socceroos/119664741377244	4	Page	10-Jun-10	No	No
World Cup Soccer	Socceroos	SOCCEROOS	https://www.facebook.com/pages/SOCCEROOS-/126051170744978	110	Page	10-Jun-10	No	No
World Cup Soccer	Socceroos	Socceroos	https://www.facebook.com/pages/Socceroos/106353142733985	448	Page	10-Jun-10	No	No
World Cup Soccer	Socceroos	Young Socceroos	https://www.facebook.com/pages/Young-Socceroos/115695218444154	3	Page	10-Jun-10	No	No
World Cup Soccer	Socceroos	socceroos fan? get on it!!!!!	https://www.facebook.com/pages/socceroos-fan-get-on-it/118141831550071	9	Page	10-Jun-10	No	No
World Cup Soccer	Socceroos	Cheering for the Socceroos at the local club in the World Cup	https://www.facebook.com/pages/Cheering-for-the-Socceroos-at-the-local-club-in-the-World-Cup/406886935323	93	Page	10-Jun-10	No	No
World Cup Soccer	Socceroos	The Football Supporters’ Pledge: A-League	Socceroos & Grassroots	https://www.facebook.com/pages/The-Football-Supporters-Pledge-A-League-Socceroos-Grassroots/114421618592491	4	Page	10-Jun-10	No	No
World Cup Soccer	Socceroos	Langerak is a God	and will be in the Socceroos one day p.s hes HOT	https://www.facebook.com/pages/Langerak-is-a-God-and-will-be-in-the-Socceroos-one-day-ps-hes-HOT/103909322982210	86	Page	10-Jun-10	No	No
World Cup Soccer	Socceroos	100	000 Strong Socceroos Supporters To Win 2010 World Cup	https://www.facebook.com/pages/100000-Strong-Socceroos-Supporters-To-Win-2010-World-Cup/362147231671	337	Page	10-Jun-10	No	No
World Cup Soccer	Socceroos	Change the name of the Socceroos	https://www.facebook.com/pages/Brisbane-Australia/Change-the-name-of-the-Socceroos/206601790281	12	Page	10-Jun-10	No	No
World Cup Soccer	Socceroos	Brett Holman shouldn’t play for the Socceroos	https://www.facebook.com/pages/Brett-Holman-shouldnt-play-for-the-Socceroos/155289433083	113	Page	10-Jun-10	No	No
World Cup Soccer	Socceroos	kickoff.com.au: A-League	Socceroos	Australian and International football	https://www.facebook.com/pages/kickoffcomau-A-League-Socceroos-Australian-and-International-football/238919388600	117	Page	10-Jun-10	No	No
World Cup Soccer	Socceroos	Support for the Socceroos in South Africa	https://www.facebook.com/pages/Support-for-the-Socceroos-in-South-Africa/118426448190124	13	Page	10-Jun-10	No	No
World Cup Soccer	Socceroos	Petition for Israel to come play the Socceroos	https://www.facebook.com/pages/Petition-for-Israel-to-come-play-the-Socceroos/124315894249250	23	Page	10-Jun-10	No	No
World Cup Soccer	Socceroos	Socceroos – Australian National Football Team	https://www.facebook.com/Socceroos	74	987	Page	12-Jun-10	No	Yes
World Cup Soccer	Socceroos	Socceroos to dominate in 2010	https://www.facebook.com/pages/Socceroos-to-dominate-in-2010/125877250762609	335	Page	12-Jun-10	No	No
World Cup Soccer	Socceroos	Socceroos	https://www.facebook.com/pages/Socceroos/106019049438817	33	Page	12-Jun-10	No	No
World Cup Soccer	Socceroos	Socceroos	https://www.facebook.com/pages/Socceroos/112443855448354	57	Page	12-Jun-10	No	No
World Cup Soccer	Socceroos	Socceroos	https://www.facebook.com/pages/Socceroos/108710262493191	53	Page	12-Jun-10	No	No
World Cup Soccer	Socceroos	Socceroos	https://www.facebook.com/pages/Socceroos/119664741377244	5	Page	12-Jun-10	No	No
World Cup Soccer	Socceroos	SOCCEROOS	https://www.facebook.com/pages/SOCCEROOS-/126051170744978	113	Page	12-Jun-10	No	No
World Cup Soccer	Socceroos	Socceroos	https://www.facebook.com/pages/Socceroos/106353142733985	455	Page	12-Jun-10	No	No
World Cup Soccer	Socceroos	Young Socceroos	https://www.facebook.com/pages/Young-Socceroos/115695218444154	3	Page	12-Jun-10	No	No
World Cup Soccer	Socceroos	socceroos fan? get on it!!!!!	https://www.facebook.com/pages/socceroos-fan-get-on-it/118141831550071	9	Page	12-Jun-10	No	No
World Cup Soccer	Socceroos	Cheering for the Socceroos at the local club in the World Cup	https://www.facebook.com/pages/Cheering-for-the-Socceroos-at-the-local-club-in-the-World-Cup/406886935323	95	Page	12-Jun-10	No	No
World Cup Soccer	Socceroos	The Football Supporters’ Pledge: A-League	Socceroos & Grassroots	https://www.facebook.com/pages/The-Football-Supporters-Pledge-A-League-Socceroos-Grassroots/114421618592491	4	Page	12-Jun-10	No	No
World Cup Soccer	Socceroos	Langerak is a God	and will be in the Socceroos one day p.s hes HOT	https://www.facebook.com/pages/Langerak-is-a-God-and-will-be-in-the-Socceroos-one-day-ps-hes-HOT/103909322982210	86	Page	12-Jun-10	No	No
World Cup Soccer	Socceroos	100	000 Strong Socceroos Supporters To Win 2010 World Cup	https://www.facebook.com/pages/100000-Strong-Socceroos-Supporters-To-Win-2010-World-Cup/362147231671	342	Page	12-Jun-10	No	No
World Cup Soccer	Socceroos	Change the name of the Socceroos	https://www.facebook.com/pages/Brisbane-Australia/Change-the-name-of-the-Socceroos/206601790281	12	Page	12-Jun-10	No	No
World Cup Soccer	Socceroos	Brett Holman shouldn’t play for the Socceroos	https://www.facebook.com/pages/Brett-Holman-shouldnt-play-for-the-Socceroos/155289433083	113	Page	12-Jun-10	No	No
World Cup Soccer	Socceroos	kickoff.com.au: A-League	Socceroos	Australian and International football	https://www.facebook.com/pages/kickoffcomau-A-League-Socceroos-Australian-and-International-football/238919388600	117	Page	12-Jun-10	No	No
World Cup Soccer	Socceroos	Support for the Socceroos in South Africa	https://www.facebook.com/pages/Support-for-the-Socceroos-in-South-Africa/118426448190124	14	Page	12-Jun-10	No	No
World Cup Soccer	Socceroos	Petition for Israel to come play the Socceroos	https://www.facebook.com/pages/Petition-for-Israel-to-come-play-the-Socceroos/124315894249250	23	Page	12-Jun-10	No	No

Foursquare
This is my complete table to date for all venues. It doesn’t necessarily connect to the Socceroos but it is World Cup related data so I’m shoving it in here.