Industrial areas in the North East and Midlands are least resilient to economic shocks, BBC-commissioned research suggests.