5 Things You Didn’t Know About the World Cup

During the matches in Brazil, we’ve been building a giant graph database to explore the tournament in an entirely different way. The use of data in sports reporting is nothing new. However, the data that is used quite often is. Metrics like possession, shots on goal, goal differences and so on, are familiar to most of us. They’re also very conventional analyses based on relational data.

Graphing the same data enables us to identify some altogether different trends based on data gathered by our team. On June 18th, we hosted a Hackathon in London, where we gathered together

During the matches in Brazil, we’ve been building a giant graph database to explore the tournament in an entirely different way. The use of data in sports reporting is

View Post

Extending the World Cup Graph Domain Model

Last week I wrote a post explaining the initial data model for the Neo4j World Cup graph which looked like this:

World Cup Graph Model

This version of the model covered World Cups, teams, stadiums and hosts but what was missing was the players who played in those matches.

Over the weekend I've worked on getting the player data into shape and have added it to the graph. The domain model with players included looks like this:

World Cup Graph Model

So the things that have been added are:

  • A Squad node which represents the players who were named to represent their country at a specific world cup

Last week I wrote a post explaining the initial data model for the Neo4j World Cup graph which looked like this: This version of the model covered World Cups, teams

View Post

World Cup Hackathons

The following are confirmed World Cup hackathons:

Amsterdam (Sign up)
Wednesday 18th June 2014, 6.00
Proeflokaal Brouwerij de Prael, Oudezijds Armsteeg 26, Amsterdam (map)

London (Sign up)
Wednesday 18th June 2014, 6.30
5 - 11 Lavington Street, London, SE10NZ, London (map)

Pune (Sign up)
Friday 20th June 2014, 9.00

San Francisco (Sign up)
Tuesday 8th July 2014, 6.00


We'll add more as they're organised. If you'd like to host one please get in touch!

The following are confirmed World Cup hackathons: Amsterdam (Sign up) Wednesday 18th June 2014, 6.00Proeflokaal Brouwerij de Prael, Oudezijds Armsteeg 26, Amsterdam (map) London (Sign up) Wednesday 18th June

View Post

The World Cup Graph Domain Model

In our previous post we mentioned a graph gist containing a data set of World Cup matches but didn't go into any detail about what the World Cup Graph looks like.

The following diagram, created using Alistair Jones' excellent arrows, shows the domain model at a high level:

World Cup Graph Model

The World Cup sits at the centre of our graph and contains relationships to lots of meta data. At the moment not much is going on around matches but the intention is to introduce player data into the graph which will change that.

At first glance it may seem that we've pulled

In our previous post we mentioned a graph gist containing a data set of World Cup matches but didn't go into any detail about what the World Cup Graph looks

View Post

World Cup Quiz - test out your cypher skillz!

In time for the World Cup we've created a little quiz with some questions that you can discover the answer to by writing cypher queries against our World Cup graph.

You can either download the data set and write queries on your local Neo4j instance or just fork the graph gist and work on it online.

We also prepared a readonly instance of the database online on GrapheneDB which you can use for querying here. Just make sure you adapt the styling of the graph-visualization.

Here are some resources to get you going:

In time for the World Cup we've created a little quiz with some questions that you can discover the answer to by writing cypher queries against our World Cup graph

View Post

World Cup Hackathon: Amsterdam Edition

Neo4j is creating a World Cup data set which includes historic data and relates world cups, matches, players, countries, stadiums and more.

Neo4j meetup groups around the world will create GraphGists to extract insights and/or extend the model to make it even more interesting.

On Wednesday 18th June the Neo4j Amsterdam group will join the party as part of their Graph Cafe football special. You can sign up on the meetup.com page.

You'll even be able to watch the Holland vs Australia match before the event gets underway.

Look forward to seeing you there!

Neo4j is creating a World Cup data set which includes historic data and relates world cups, matches, players, countries, stadiums and more. Neo4j meetup groups around the world will create

View Post

World Cup Hackathon: San Francisco Edition

Neo4j is creating a World Cup data set which includes historic data and relates world cups, matches, players, countries, stadiums and more.

Neo4j meetup groups around the world will create GraphGists to extract insights and/or extend the model to make it even more interesting.

On Thursday 8th July the Neo4j San Francisco group will join the party. You can sign up on the meetup.com page.

Look forward to seeing you there!

Neo4j is creating a World Cup data set which includes historic data and relates world cups, matches, players, countries, stadiums and more. Neo4j meetup groups around the world will create

View Post

World Cup Hackathon in India

Neo4j is creating a World Cup data set which includes historic data and relates world cups, matches, players, countries, stadiums and more.

Neo4j meetup groups around the world will create GraphGists to extract insights and/or extend the model to make it even more interesting. We want to participate with an all-indian meetup on this topic.

We are a fairly large group in India so the thought is to engage in a "distributed" meetup where one can join in individually, or form smaller teams/groups in your city. We'd like participants to talk/discuss stuff via a common Hangout. If

Neo4j is creating a World Cup data set which includes historic data and relates world cups, matches, players, countries, stadiums and more. Neo4j meetup groups around the world will create

View Post

Introducing the World Cup Graph + London Hackathon

With World Cup 2014 just around the corner we thought it'd be fun to build a Neo4j graph all about the World Cup.

This will be an open graph that everybody can explore and help evolve.

To get us started there's already a graph gist published which has a model containing all the matches, stadiums, hosts and more.

We'll organise hackathons in different countries to build on top of this starting with one in the Neo4j London office on 18th June. Please sign up on the meetup page if you want to attend.

If you want to run a hackathon

With World Cup 2014 just around the corner we thought it'd be fun to build a Neo4j graph all about the World Cup. This will be an open graph that

View Post