In the quest of understanding the complex nature of the state-sponsored corruption in Egypt, we decided to study three main entities and the key relations within and among them. As can be seen in the model above, various data about Person, Organization, and Project entities were collected. We decided to distinguish the formal position tie from the influence tie between Person and Organization, as well as Person and Project, in order to handle all the possible scenarios. Some government organizations have authorities and agencies that belong to them or affiliated with them, hence we created “Affiliated_with” tie to capture such a relation.
Although Projects seem to be independent, it was important for us to capture those projects that were linked in a way or another, like being funded from the same IMF loan. Final note about the model is that we prepared it, and hence the collected data, to handle temporal/longitudinal analysis. This is why all the ties capture “start_date” and “end_date” of the relation between entities.