GraphGists

Graph of the Free Agent players of Major League Baseball 2016

I used the 2016 Free Agent Tracker of FanGraphs to get the data about the current Free Agent players, and their new contract. The graph contains the contracts made till 16th December 2015.

My data modell is illustrated by David Price, who signed a record seven-year, $217 million contract with the Boston Red Sox.

wYcFHZB

Usecases

Top 10 Annual Salary of Player with New Contract

MATCH (p:Player)-[:NEW_CONTRACT]->(c:Contract) RETURN p.name,c.salary as Total,c.years as Years,c.salary/c.years as Annual order by Annual desc limit 10

Annual Salary Averages by Divisions of Player with New Contract

MATCH (l:League)-[:HAS_DIVISION]–>(d:Division)-[:MEMBER]-(:Team)<-[:SEASON2016]-(p:Player)-[:NEW_CONTRACT]->(c:Contract) WHERE c.years is not null and c.salary is not null RETURN d.name, AVG(c.salary/c.years) as AnnualAvg order by AnnualAvg desc limit 10

Oldest Players with New Contract

MATCH (p:Player)-[:NEW_CONTRACT]-(c:Contract) RETURN p.name as Name, p.age as Age, c.years as Years order by Age desc limit 10;

Money in contracts with FA Players by Team

MATCH (l:League)-[:HAS_DIVISION]–>(d:Division)-[:MEMBER]-(t:Team)<-[:SEASON2016]-(p:Player)-[:NEW_CONTRACT]->(c:Contract) WHERE c.years is not null and c.salary is not null RETURN t.name as Team, SUM(c.salary) as Money order by Money desc limit 10