GraphGists

England Senior squad for RBS 6 Nations 2016 and Elite Player Squad

Version 0.1, 13th January 2016

The training squad for the 6 Nations campaign was announced at 2pm on the 13th January, this graph shows the players who were picked for the squad, their domestic club and includes injury replacements.

Setup

The graph

MATCH (n) RETURN n

How many players in the squad?

match (c:Club)<-[r:PLAYS_FOR]-(p:Player)-[*2..2]-(s:Squad)
where s.name = '6 Nations 2016'
return count(r) as players;

Which premiership team has had the most players selected?

match (c:Club)<-[r:PLAYS_FOR]-(p:Player)-[*2..2]-(s:Squad)
where s.name = '6 Nations 2016'
return c.name as club, count(r) as players
order by players desc, club asc;

Who are the uncapped players?

match (p:Player)-[*2..2]-(s:Squad)
where s.name = '6 Nations 2016'
and p.caps = 0
return p.name as uncapped;

Who are the injury replacements?

match (m)-[:INJURY_REPLACEMENT_FOR]->(n)
return m.name as substitutes, n.name as injured;