Barry Rogerson was involved in the incident with a police horse after the team he supports, Newcastle United, lost heavily in the local derby against Sunderland in April.
Shortly after the incident above, Mr Rogerson said he "lashed out" because he was trying to protect himself after becoming separated from his friends.
"I'm not proud," he told ITV Tyne Tees at the time. "I really let my family down."
More top news
Rugby star Matt Dawson has revealed how he required heart surgery after developing Lyme disease from a tick bite.
New images have emerged which it's claimed is the man believed to be responsible for driving a van into pedestrians in Barcelona.
Only applicants with the ability to find the listing would be suitable for the position, which requires 'excellent analytical' skills.