The most comprehensive data analysis of its kind has found wide variation across council areas, with Middlesbrough in the North East faring the worst