The scene outside Cologne cathedral on the night of the attacks
The disgusting list of crimes reported in the German city run to a staggering 821 complaints, and range from sexual assaults to gang rape.
When including reported attacks from all of the major cities in the North Rhine-Westphalia state - including Cologne, Dusseldorf, Dortmund and Bielefeld - the complaint figure is said to almost top 1,000.
A shocking 359 complaints relate to sexual offences, while 659 women were recorded as alleged victims, according to the list finally published by NRW state government.
It also revealed 126 claims of "rape by a group" and 47 allegations of "sexual assault by a group".
Far-right protestors smashed up kebab shops during a protest following the attacks
German migrant protests
Tue, January 12, 2016
Thirty-one suspects, including 18 asylum seekers, are under investigation over offences including sexual assault and theft in Cologne on New Year's Eve. Far right protestors in Lepzig have rallied against refugees and German chancellor Angela Merkel.