update removed country from view and added state province