Part 2/2: looking at the Web of Belgian Public Companies in Neo4j

Yesterday, I published part 1 of this short little blogpost on how we could load the dataset of a great newspaper article in De Tijd (our local financial/economic newspaper) into Neo4j. Of course, the whole point of that loading process (all of which is easily copied from github, btw) is to be able to do some additional querying on the dataset - just because we can :) ... So let's do some simple queries here, and then you can of course explore this some more yourself!

Start with some simple queries

In the article above, one of the key figures in the web of public companies, is Luc Bertrand, the CEO of Ackermans & Van Haaren - a former dredging company that turned into a holding company. Let's explore the network around him - by walking the paths from his node for three hops.

//network around Luc Bertrand 

match path = (m:Male)-[r*..3]-(n) 

where m.name contains "Bertrand"return path

That query gives us a nice little graph that we can explore:

Part 1/2: looking at the Web of Belgian Public Companies in Neo4j

Just a few days ago I came across an interesting article on Belgium's premier economic newspaper - (De Tijd, the local equivalent of the Financial Times or the Wall Street Journal) that was over here:

The title of the article is "The Spider's web of publicly traded Belgium", referring to the web of companies, ceo's, chairmen and directors for the 126 public companies that Belgium still has.