Trying to recreate OptaJoe stats with a football data set I've collected - https://twitter.com/OptaJoe/status/328549908967743488

late_goals

START team = node:teams('name:"Manchester City"')
MATCH team-[:played_in]-game-[goal:scored_in]-player-[:played]-playerStats-[:for]-team, playerStats-[:in]-game
WHERE goal.minute > 75
RETURN player.name, game.name, goal.minute, game.home_goals + " - " + game.away_goals AS score, game.friendly_date
ORDER BY game.date, goal.minute


+--------------------------------------------------------------------------------------------------------------------+
| player.name      | game.name                                 | goal.minute | score   | game.friendly_date          |
+--------------------------------------------------------------------------------------------------------------------+
| "Samir Nasri"    | "Manchester City vs Southampton"          | 80          | "3 - 2" | "2012-08-19 16:00:00 +0100" |
| "Carlos Tevez"   | "Liverpool vs Manchester City"            | 80          | "2 - 2" | "2012-08-26 16:00:00 +0100" |
| "Carlos Tevez"   | "Manchester City vs Queens Park Rangers"  | 90          | "3 - 1" | "2012-09-01 17:30:00 +0100" |
| "Edin Dzeko"     | "Fulham vs Manchester City"               | 87          | "1 - 2" | "2012-09-29 15:00:00 +0100" |
| "James Milner"   | "Manchester City vs Sunderland"           | 89          | "3 - 0" | "2012-10-06 12:45:00 +0100" |
| "Edin Dzeko"     | "West Bromwich Albion vs Manchester City" | 80          | "1 - 2" | "2012-10-20 15:00:00 +0100" |
| "Edin Dzeko"     | "West Bromwich Albion vs Manchester City" | 90          | "1 - 2" | "2012-10-20 15:00:00 +0100" |
| "Edin Dzeko"     | "Manchester City vs Tottenham Hotspur"    | 88          | "2 - 1" | "2012-11-11 13:30:00 +0000" |
| "Pablo Zabaleta" | "Manchester City vs Manchester United"    | 86          | "2 - 3" | "2012-12-09 13:30:00 +0000" |
| "Yaya Touré"     | "Newcastle United vs Manchester City"     | 78          | "1 - 3" | "2012-12-15 12:45:00 +0000" |
| "Gareth Barry"   | "Manchester City vs Reading"              | 90          | "1 - 0" | "2012-12-22 15:00:00 +0000" |
| "Sergio Agüero"  | "Manchester City vs Liverpool"            | 78          | "2 - 2" | "2013-02-03 16:00:00 +0000" |
| "Carlos Tevez"   | "Manchester City vs Chelsea"              | 85          | "2 - 0" | "2013-02-24 13:30:00 +0000" |
| "Sergio Agüero"  | "Manchester United vs Manchester City"    | 78          | "1 - 2" | "2013-04-08 20:00:00 +0100" |
| "Carlos Tevez"   | "Manchester City vs Wigan Athletic"       | 83          | "1 - 0" | "2013-04-17 19:45:00 +0100" |
| "Yaya Touré"     | "Manchester City vs West Ham United"      | 83          | "2 - 1" | "2013-04-27 12:45:00 +0100" |
+--------------------------------------------------------------------------------------------------------------------+
16 rows