People in Weardale, Consett and Bishop Auckland saw the stunning sight, while others in Northumberland and North Yorkshire also spotted the northern lights.